training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
66 rows where "qa:training_date_scraped" is on date 2022-03-25 and "training:end_date" is on date 2020-07-31 sorted by training:start_date descending
This data as json, CSV (advanced)
training:id:admin | training:source | qa:training_group | training:country | training:country_iso_3166_1 | training:program | training:course_title | training:delivery_unit | training:recipient_unit | qa:training_start_date | training:start_date ▲ | qa:training_end_date | training:end_date | training:location | training:quantity | training:total_cost | qa:training_source_url | training:status:admin | qa:training_date_first_seen | qa:training_date_scraped |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
238e3078-1514-4348-80fe-b7156d8ff54a | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTIWFP - Fiscal Year 2020 Department of Defense Training | CTFP | Colombia (In Country Training) - 0 | Air Force | 7/27/2020 | 2020-07-27 | 7/31/2020 | 2020-07-31 | Bogota, CO | 1 | 1995 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
3fdcf157-1d0b-49ad-a460-7ef5235372af | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Mali | MLI | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Army War College - 0 | 51st Regiment | 7/26/2020 | 2020-07-26 | 7/31/2020 | 2020-07-31 | Carlisle Barracks, PA, US | 1 | 1292 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
724d5391-4285-4af4-b345-e5a1cad5c34c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Kosovo | XKX | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | ALU - Leader Courses - 0 | Logistics Battalion,Operation Support Brigade, KSF | 7/25/2020 | 2020-07-25 | 7/31/2020 | 2020-07-31 | Ft. Lee, VA, US | 1 | 1282 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
a02de0f4-9793-4ccf-80e1-641735f0409c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Morocco | MAR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | ALU - Leader Courses - 0 | Intendancy School-Sale | 7/25/2020 | 2020-07-25 | 7/31/2020 | 2020-07-31 | Ft. Lee, VA, US | 1 | 1132 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
b4097d28-2b5a-4dc7-ba09-9d0ad6e8becb | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2020 Department of State Training | Cavalry Leader | Armor School - 0 | 22nd Peacekeeping Battalion | 7/13/2020 | 2020-07-13 | 7/31/2020 | 2020-07-31 | Ft. Benning, GA, US | 1 | 5455 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
8ad189fc-4013-49fc-9647-6e7d99da67f2 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Guinea | GIN | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | ALU - Leader Courses - 0 | Guinean Armed Forces | 7/11/2020 | 2020-07-11 | 7/31/2020 | 2020-07-31 | Ft. Lee, VA, US | 1 | 7573 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
a3ccca66-00ce-44a3-86d5-6580768ec8e3 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Tunisia | TUN | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Command & General Staff College - 0 | Army Head Quarters | 7/8/2020 | 2020-07-08 | 7/31/2020 | 2020-07-31 | Ft. Leavenworth, KS, US | 1 | 8385 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
41e1f6bb-e817-472d-8cda-aa9fc4c3dfae | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Tunisia | TUN | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | National War College - 0 | ARSD | 7/8/2020 | 2020-07-08 | 7/31/2020 | 2020-07-31 | Ft. Mcnair, NDU, DC, US | 1 | 11037 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
d53f6313-4d99-45c1-b7d7-21c8b154005d | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Cameroon | CMR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | DLIELC, Lackland AFB TX - 0 | 1st Rapid Intervention Battalion | 7/5/2020 | 2020-07-05 | 7/31/2020 | 2020-07-31 | Lackland AFB, TX, US | 1 | 3105 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
87e0e083-5e89-48ba-b67e-b34066adf0c8 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Mali | MLI | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Sergeants Major Academy - 0 | 311CCS | 7/5/2020 | 2020-07-05 | 7/31/2020 | 2020-07-31 | Ft. Bliss, TX, US | 1 | 8765 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
b024909e-8282-4978-b667-c76905e38705 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Tanzania, United Republic of | TZA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Command & General Staff College - 0 | Defense Forces HQ | 7/2/2020 | 2020-07-02 | 7/31/2020 | 2020-07-31 | Ft. Leavenworth, KS, US | 1 | 10375 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
b280a2b8-805c-4063-8103-456b9b7a3339 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Infantry School - 0 | 1st Infantry Brigade, Moldovan Army | 7/1/2020 | 2020-07-01 | 7/31/2020 | 2020-07-31 | Ft. Benning, GA, US | 1 | 3608 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
19b893e8-1f2f-40b7-bd38-e644d81b16de | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Air Defense Artillery School - 0 | 2nd Infantry Brigade, Moldovan Army | 7/1/2020 | 2020-07-01 | 7/31/2020 | 2020-07-31 | Ft. Sill, OK, US | 1 | 3608 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
d44bd221-d98f-40a0-8590-0a3581e8f9f1 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Ukraine | UKR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | College Of International Security Affairs - 0 | StratCom General Staff | 7/1/2020 | 2020-07-01 | 7/31/2020 | 2020-07-31 | Ft. Mcnair, NDU, DC, US | 1 | 0 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
f3d79e83-f442-4b3f-80e9-b6925b1b351e | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Kosovo | XKX | IMET-2 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Field Artillery School - 0 | Rapid Reaction Brigade, 1st BATT, KSF | 6/27/2020 | 2020-06-27 | 7/31/2020 | 2020-07-31 | Ft. Sill, OK, US | 1 | 3696 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
6c3bd7a9-d742-4051-84fc-0f836d240afd | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Ukraine | UKR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | College Of International Security Affairs - 0 | General Staff, Main Operational Directorate | 6/22/2020 | 2020-06-22 | 7/31/2020 | 2020-07-31 | Ft. Mcnair, NDU, DC, US | 1 | 3042 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
c867714e-c22f-4cff-9fd1-d2bdaf79da7d | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | South Africa | ZAF | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Sergeants Major Academy - 0 | South African Army | 6/20/2020 | 2020-06-20 | 7/31/2020 | 2020-07-31 | Ft. Bliss, TX, US | 1 | 6888 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
8b1664b1-cf9b-4b0c-8405-aeffbbe720f1 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Mongolia | MNG | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Army War College - 0 | Ministry Of Defense Of Mongolia | 6/20/2020 | 2020-06-20 | 7/31/2020 | 2020-07-31 | Carlisle Barracks, PA, US | 1 | 8792 | https://www.state.gov/wp-content/uploads/2022/03/11-Volume-I-Section-IV-Part-IV-II-East-Asia-and-Pacific.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
2833bb52-792e-44cf-b8c2-77b9eb6ef1ae | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Montenegro, Republic of | NME | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Sergeants Major Academy - 0 | Infantry Battalion Headquarters | 6/20/2020 | 2020-06-20 | 7/31/2020 | 2020-07-31 | Ft. Bliss, TX, US | 1 | 164 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
641d66b2-d1b3-4047-905d-ddf001eec03a | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | College Of International Security Affairs - 0 | Air Operations Directorate | 6/20/2020 | 2020-06-20 | 7/31/2020 | 2020-07-31 | Ft. Mcnair, NDU, DC, US | 1 | 14696 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
2f0696fe-ae8e-4efc-b3bc-7c168fc1a741 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Kazakhstan, Republic Of | KAZ | FMF - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Sergeants Major Academy - 0 | Military Unit 61993, Ministry Of Defense | 6/20/2020 | 2020-06-20 | 7/31/2020 | 2020-07-31 | Ft. Bliss, TX, US | 1 | 7288 | https://www.state.gov/wp-content/uploads/2022/03/14-Volume-I-Section-IV-Part-IV-V-South-Central-Asia.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
9e43437d-ee6d-49b3-a8c7-c8ff1b4a6d88 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Kazakhstan, Republic Of | KAZ | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Sergeants Major Academy - 0 | 61993, Ministry Of Defense | 6/20/2020 | 2020-06-20 | 7/31/2020 | 2020-07-31 | Ft. Bliss, TX, US | 1 | 7288 | https://www.state.gov/wp-content/uploads/2022/03/14-Volume-I-Section-IV-Part-IV-V-South-Central-Asia.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
5b34b793-1900-4b52-85da-5dd76b531b65 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Cameroon | CMR | CTIWFP - Fiscal Year 2020 Department of Defense Training | COVID-19 EXT | College Of International Security Affairs - 0 | Command And Staff College YAOUNDE | 6/19/2020 | 2020-06-19 | 7/31/2020 | 2020-07-31 | Ft. Mcnair, NDU, DC, US | 1 | 14196 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
8bb9458f-2a25-48d4-8cdb-ba23cb9510c5 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Cameroon | CMR | CTIWFP - Fiscal Year 2020 Department of Defense Training | COVID-19 EXT | College Of International Security Affairs - 0 | Not EnteredMotorized Infantry Battalion | 6/19/2020 | 2020-06-19 | 7/31/2020 | 2020-07-31 | Ft. Mcnair, NDU, DC, US | 1 | 14196 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
70e08c1b-0e89-46d0-8b56-55c13204e0b9 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Nigeria | NGA | CTIWFP - Fiscal Year 2020 Department of Defense Training | COVID-19 EXT | College Of International Security Affairs - 0 | Nigeria Defense Intelligence Agency | 6/19/2020 | 2020-06-19 | 7/31/2020 | 2020-07-31 | Ft. Mcnair, NDU, DC, US | 1 | 14196 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
c6f91bd3-8225-4477-a1a0-a974d446de05 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Nigeria | NGA | CTIWFP - Fiscal Year 2020 Department of Defense Training | COVID-19 EXT | College Of International Security Affairs - 0 | Nigerian Army | 6/19/2020 | 2020-06-19 | 7/31/2020 | 2020-07-31 | Ft. Mcnair, NDU, DC, US | 1 | 14196 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
77e1d7cf-38b5-4de8-8277-82e34952e280 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Kosovo | XKX | CTIWFP - Fiscal Year 2020 Department of Defense Training | COVID-19 EXT | College Of International Security Affairs - 0 | Rapid Reaction Brigade, KSF | 6/19/2020 | 2020-06-19 | 7/31/2020 | 2020-07-31 | Ft. Mcnair, NDU, DC, US | 1 | 14196 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
83f46cd9-d9fb-47d9-aa3e-c3655f2f9c02 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Algeria | DZA | CTIWFP - Fiscal Year 2020 Department of Defense Training | COVID-19 EXT | College Of International Security Affairs - 0 | Military Intelligence Office | 6/19/2020 | 2020-06-19 | 7/31/2020 | 2020-07-31 | Ft. Mcnair, NDU, DC, US | 1 | 14196 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
a4106121-22d0-40d7-907a-abff5f1fa649 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Tunisia | TUN | CTIWFP - Fiscal Year 2020 Department of Defense Training | COVID-19 EXT | College Of International Security Affairs - 0 | Navy HQs | 6/19/2020 | 2020-06-19 | 7/31/2020 | 2020-07-31 | Ft. Mcnair, NDU, DC, US | 1 | 14196 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
12a91302-d417-4d81-96df-42cb319a0a81 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Kazakhstan, Republic Of | KAZ | FMF - Fiscal Year 2020 Department of State Training | COVID-19 EXT | College Of International Security Affairs - 0 | Section Chief, Military Unit 27943, Ministry Of Defense | 6/19/2020 | 2020-06-19 | 7/31/2020 | 2020-07-31 | Ft. Mcnair, NDU, DC, US | 1 | 14596 | https://www.state.gov/wp-content/uploads/2022/03/14-Volume-I-Section-IV-Part-IV-V-South-Central-Asia.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
2bc8ef14-2f10-4613-820d-8f229ba1594e | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Kyrgyzstan | KGZ | IMET-D&R - Fiscal Year 2020 Department of State Training | COVID-19 EXT | DLIELC, Lackland AFB TX - 0 | Main Directorate, State Border Service | 6/19/2020 | 2020-06-19 | 7/31/2020 | 2020-07-31 | Lackland AFB, TX, US | 1 | 4586 | https://www.state.gov/wp-content/uploads/2022/03/14-Volume-I-Section-IV-Part-IV-V-South-Central-Asia.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
b2c62533-ab4a-49cc-b1bd-5479fe50eca8 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Bosnia & Herzegovina | BIH | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Aviation School - 0 | Aviation Brigade | 6/16/2020 | 2020-06-16 | 7/31/2020 | 2020-07-31 | Ft. Rucker, AL, US | 1 | 113 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
c177ddaa-daca-46b4-89e3-a7f4856ce389 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Cameroon | CMR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Command & General Staff College - 0 | Gendarmerie Company Of Yaounde II | 6/13/2020 | 2020-06-13 | 7/31/2020 | 2020-07-31 | Ft. Leavenworth, KS, US | 1 | 0 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
19475f8b-56e5-425c-a345-2959a19571bf | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Cameroon | CMR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Command & General Staff College - 0 | Rapid Intervention Battalion Of Garoua | 6/13/2020 | 2020-06-13 | 7/31/2020 | 2020-07-31 | Ft. Leavenworth, KS, US | 1 | 0 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
66c2a833-170d-4745-afbb-93f12946f347 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Cameroon | CMR | IMET-2 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | DLIELC, Lackland AFB TX - 0 | 1st Rapid Intervention Battalion | 6/13/2020 | 2020-06-13 | 7/31/2020 | 2020-07-31 | Lackland AFB, TX, US | 1 | 2245 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
e34e1817-2c07-4dbd-9717-724a8bda0910 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Chad | TCD | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Command & General Staff College - 0 | EMELE/GEMIA | 6/13/2020 | 2020-06-13 | 7/31/2020 | 2020-07-31 | Ft. Leavenworth, KS, US | 1 | 0 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
decd9068-4ac2-4262-98c1-55d633c08725 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Niger | NER | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Command & General Staff College - 0 | Ministry Of Defense | 6/13/2020 | 2020-06-13 | 7/31/2020 | 2020-07-31 | Ft. Leavenworth, KS, US | 1 | 2304 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
9586e3fc-79a8-4583-85ae-ced276c16fbf | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Niger | NER | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | DLIELC, Lackland AFB TX - 0 | Prytanee Militaire De Niamey/Military Academy | 6/13/2020 | 2020-06-13 | 7/31/2020 | 2020-07-31 | Lackland AFB, TX, US | 1 | 3775 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
2cd72a21-b8c1-44f4-8133-156a0cff4c93 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Bosnia & Herzegovina | BIH | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Command & General Staff College - 0 | EOD Training Center, TRADOC | 6/13/2020 | 2020-06-13 | 7/31/2020 | 2020-07-31 | Ft. Leavenworth, KS, US | 1 | 165 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
1265a86c-daf8-455a-8cec-8321500b5e16 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Kosovo | XKX | FMF - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Infantry School - 0 | Rapid Reaction Brigade, 1st BATT, KSF | 6/13/2020 | 2020-06-13 | 7/31/2020 | 2020-07-31 | Ft. Benning, GA, US | 1 | 5055 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
cec45792-6fc2-45b8-a30f-283f051a093b | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Kazakhstan, Republic Of | KAZ | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Command & General Staff College - 0 | Operation Planning Officer, Military Unit 26363, Ministry Of Defense | 6/13/2020 | 2020-06-13 | 7/31/2020 | 2020-07-31 | Ft. Leavenworth, KS, US | 1 | 10004 | https://www.state.gov/wp-content/uploads/2022/03/14-Volume-I-Section-IV-Part-IV-V-South-Central-Asia.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
ea4d95aa-34a3-4a9e-a0ca-1a8d2aa5b2b3 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Kazakhstan, Republic Of | KAZ | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Command & General Staff College - 0 | Senior Officer, Combat Training Department, Ministry Of Defense | 6/13/2020 | 2020-06-13 | 7/31/2020 | 2020-07-31 | Ft. Leavenworth, KS, US | 1 | 10004 | https://www.state.gov/wp-content/uploads/2022/03/14-Volume-I-Section-IV-Part-IV-V-South-Central-Asia.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
227a7fb2-3bfa-41ac-8706-87d8985b4f9b | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Kyrgyzstan | KGZ | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Army War College - 0 | Regional Border Service Directorate, State Border Service | 6/6/2020 | 2020-06-06 | 7/31/2020 | 2020-07-31 | Carlisle Barracks, PA, US | 1 | 9192 | https://www.state.gov/wp-content/uploads/2022/03/14-Volume-I-Section-IV-Part-IV-V-South-Central-Asia.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
7140b59d-374b-4ca9-9af6-d5e629f8ca3c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Kyrgyzstan | KGZ | IMET-D&R - Fiscal Year 2020 Department of State Training | COVID-19 EXT | DLIELC, Lackland AFB TX - 0 | Unit 2026, State Border Service | 6/6/2020 | 2020-06-06 | 7/31/2020 | 2020-07-31 | Lackland AFB, TX, US | 1 | 6014 | https://www.state.gov/wp-content/uploads/2022/03/14-Volume-I-Section-IV-Part-IV-V-South-Central-Asia.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
b8961ba6-900a-4156-a236-b50ed184bf92 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Cameroon | CMR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Medical Education Training Campus - 0 | Military Hospital YAOUNDE | 6/5/2020 | 2020-06-05 | 7/31/2020 | 2020-07-31 | Ft. Sam Houston, TX, US | 1 | 11382 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
01ffec4e-7ba2-4fbc-b90b-bdd7e43105a0 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Kosovo | XKX | FMF - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Army War College - 0 | Rapid Reaction Brigade, 1st BATT, Command Group, KSF | 6/5/2020 | 2020-06-05 | 7/31/2020 | 2020-07-31 | Carlisle Barracks, PA, US | 1 | 9392 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
d955d5c9-315a-4fae-bf89-17cc7dd7db92 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Morocco | MAR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Army War College - 0 | Intel Department- F.A.R HQ- | 6/5/2020 | 2020-06-05 | 7/31/2020 | 2020-07-31 | Carlisle Barracks, PA, US | 1 | 6123 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
80145620-9abf-45a9-a40a-7b98a0a53b9c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Moldova | MDA | Service Academies - Fiscal Year 2020 Department of Defense Training | United States Air Force Academy | USAFA - 0 | USAFA | 6/1/2020 | 2020-06-01 | 7/31/2020 | 2020-07-31 | Colorado Springs, CO | 1 | 14556 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
57dd8524-ba63-4b10-9823-69efb11a14d2 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Malawi | MWI | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Infantry School - 0 | Kamuzu Barracks, Lilongwe | 5/31/2020 | 2020-05-31 | 7/31/2020 | 2020-07-31 | Ft. Benning, GA, US | 1 | 10822 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
927103ca-0c80-4b83-8c24-918d5f02c37e | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Malawi | MWI | IMET-D&R - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Infantry School - 0 | Kamuzu Barracks, Lilongwe | 5/30/2020 | 2020-05-30 | 7/31/2020 | 2020-07-31 | Ft. Benning, GA, US | 1 | 97 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
d1a4862a-bfcd-48e2-8825-810d66f30143 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Niger | NER | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | DLIELC, Lackland AFB TX - 0 | Construction Engineers Unit | 5/30/2020 | 2020-05-30 | 7/31/2020 | 2020-07-31 | Lackland AFB, TX, US | 1 | 6429 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
49a6f9ab-9595-475d-b90c-baf7bbb01e12 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | CTIWFP - Fiscal Year 2020 Department of Defense Training | COVID-19 EXT | JFK Special Warfare Center - 0 | MOD | 5/28/2020 | 2020-05-28 | 7/31/2020 | 2020-07-31 | Ft. Bragg, NC, US | 1 | 11115 | https://www.state.gov/wp-content/uploads/2022/03/14-Volume-I-Section-IV-Part-IV-V-South-Central-Asia.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
509a1c27-936e-420a-8791-604c92978ebb | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Bosnia & Herzegovina | BIH | Section 333 - Fiscal Year 2020 Department of Defense Training | American Language Course General English Training Only | DLIELC, Lackland AFB TX - 0 | Navy | 5/25/2020 | 2020-05-25 | 7/31/2020 | 2020-07-31 | Lackland AFB, TX, US | 1 | 21546 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
ca9819fb-dedd-4bb1-b97b-572d001a7faf | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Cameroon | CMR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | DLIELC, Lackland AFB TX - 0 | Army Airborne Battalion | 5/23/2020 | 2020-05-23 | 7/31/2020 | 2020-07-31 | Lackland AFB, TX, US | 1 | 7143 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
45a2950e-e3a5-459b-a922-a7032bef9a9a | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Liberia | LBR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Intelligence School - 0 | Armed Forces Of Liberia | 5/17/2020 | 2020-05-17 | 7/31/2020 | 2020-07-31 | Ft. Huachuca, AZ, US | 1 | 21917 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
d0d45662-3d58-49af-bd1a-b620a0993ca1 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Somalia | SOM | IMET-2 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Intelligence School - 0 | 38th Battalion | 5/9/2020 | 2020-05-09 | 7/31/2020 | 2020-07-31 | Ft. Huachuca, AZ, US | 1 | 14404 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
918dfdf0-23a1-45c0-a5e8-a7928097f19d | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Burkina Faso | BFA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | DLIELC, Lackland AFB TX - 0 | 10th Command And Support Regiment | 5/5/2020 | 2020-05-05 | 7/31/2020 | 2020-07-31 | Lackland AFB, TX, US | 1 | 9730 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
f815fcf1-3a03-4960-a473-4fa81a448867 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Morocco | MAR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | USATC-Benning - 0 | 7TH Armor Group- OUMDRIGA | 4/28/2020 | 2020-04-28 | 7/31/2020 | 2020-07-31 | Ft. Benning, GA, US | 1 | 6211 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
e0f6aa35-93ca-4b0f-a6f2-84665f8bfbf3 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Serbia, Republic of | SRB | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Engineer School - 0 | the 2nd Pontoon Battalion/River Flotilla | 4/26/2020 | 2020-04-26 | 7/31/2020 | 2020-07-31 | Ft. Leonard Wood, MO, US | 1 | 17554 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
227b2150-fa64-45a9-94ce-41fd1defb02e | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Niger | NER | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Armor School - 0 | Special Forces | 3/28/2020 | 2020-03-28 | 7/31/2020 | 2020-07-31 | Ft. Benning, GA, US | 1 | 12428 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
87ef34a0-859f-4914-8572-d1e966953a6b | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Nigeria | NGA | IMET-1 - Fiscal Year 2020 Department of State Training | Infantry Basic Officer Leader-Branch | Infantry School - 0 | Nigerian Army School Of Infantry, JAJI Kaduna | 2/24/2020 | 2020-02-24 | 7/31/2020 | 2020-07-31 | Ft. Benning, GA, US | 1 | 37135 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
01cfa50c-16b6-4cd5-8cdc-3dbe9a42b93c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2020 Department of State Training | Infantry Basic Officer Leader-Branch | Infantry School - 0 | Special Forces | 2/24/2020 | 2020-02-24 | 7/31/2020 | 2020-07-31 | Ft. Benning, GA, US | 1 | 33185 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
5b78160d-cb46-44d5-b7da-a15ea4d54816 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - Fiscal Year 2020 Department of State Training | Infantry Basic Officer Leader-Branch | Infantry School - 0 | 8th Infantry Brigade | 2/24/2020 | 2020-02-24 | 7/31/2020 | 2020-07-31 | Ft. Benning, GA, US | 1 | 33385 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
6e3a5f88-ef53-467e-a3ac-c2d6d2ffba9f | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - Fiscal Year 2020 Department of State Training | Infantry Basic Officer Leader-Branch | Infantry School - 0 | 9th Infantry Brigade | 2/24/2020 | 2020-02-24 | 7/31/2020 | 2020-07-31 | Ft. Benning, GA, US | 1 | 33385 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
e3230bdc-67e2-460c-a099-3155f1fe6592 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - Fiscal Year 2020 Department of State Training | Infantry Basic Officer Leader-Branch | Infantry School - 0 | Ranger Regiment | 2/24/2020 | 2020-02-24 | 7/31/2020 | 2020-07-31 | Ft. Benning, GA, US | 1 | 33385 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
dc526f4f-411a-4170-94fa-3ffdd5666e96 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Suriname | SUR | IMET-1 - Fiscal Year 2020 Department of State Training | Infantry Basic Officer Leader-Branch | Infantry School - 0 | Infantry Battalion | 2/24/2020 | 2020-02-24 | 7/31/2020 | 2020-07-31 | Ft. Benning, GA, US | 1 | 32455 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "training-data" ( [training:id:admin] TEXT PRIMARY KEY, [training:source] TEXT, [qa:training_group] TEXT, [training:country] TEXT, [training:country_iso_3166_1] TEXT, [training:program] TEXT, [training:course_title] TEXT, [training:delivery_unit] TEXT, [training:recipient_unit] TEXT, [qa:training_start_date] TEXT, [training:start_date] TEXT, [qa:training_end_date] TEXT, [training:end_date] TEXT, [training:location] TEXT, [training:quantity] INTEGER, [training:total_cost] INTEGER, [qa:training_source_url] TEXT, [training:status:admin] TEXT, [qa:training_date_first_seen] TEXT, [qa:training_date_scraped] TEXT ); CREATE INDEX [idx_training-data_training:id:admin_training:source_qa:training_group_training:country_training:country_iso_3166_1_training:program_training:course_title_training:delivery_unit_training:recipient_unit_qa:training_start_date_training:start_date_qa:training_end_date_training:end_date_training:location_training:quantity_training:total_cost_qa:training_source_url_training:status:admin_qa:training_date_first_seen_qa:training_date_scraped] ON [training-data] ([training:id:admin], [training:source], [qa:training_group], [training:country], [training:country_iso_3166_1], [training:program], [training:course_title], [training:delivery_unit], [training:recipient_unit], [qa:training_start_date], [training:start_date], [qa:training_end_date], [training:end_date], [training:location], [training:quantity], [training:total_cost], [qa:training_source_url], [training:status:admin], [qa:training_date_first_seen], [qa:training_date_scraped]);