training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
65 rows where "qa:training_date_scraped" is on date 2022-03-25 and "training:end_date" is on date 2020-07-17 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
005961a2-301d-4bee-96c3-536c5c3e9e7c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ghana | GHA | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Ghana Ministry of Defence | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
27b7e2f0-f1c2-4036-ba19-0a2b487458a6 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ghana | GHA | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Ghana Ministry of Interior | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
710c8331-7707-4857-9e10-595a722aad57 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Austria | AUT | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Austria Ministry of Defense | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
84782a0b-6a1d-4bc0-a4c8-b561ab62be48 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Azerbaijan | AZE | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Azerbaijan State Security Service | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 2 | 1712 | 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 |
a9565835-8ca2-44be-8f59-5eaaf9a932c0 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Georgia | GEO | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Georgia Ministry of Defense | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
6c671914-2417-4998-bd6b-2bc72e4e607f | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Iraq | IRQ | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Ministry of Peshmerga Reform Directorate | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 2 | 1712 | 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 |
eaeaf68c-7dcb-4d80-9839-578ed9fac9e9 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Israel | ISR | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Embassy of Israel in the United States | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
3823f8f5-81aa-404b-88e0-170bc7cac3bc | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Israel | ISR | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Israel Ministry of Foreign Affairs | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
03fdbedf-27de-4664-b065-70cfda757294 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Jordan | JOR | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Jordan Civil Aviation Regulatory Commission | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
f5084dcc-fdc1-4d8e-81e4-433caa3db0dd | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Lebanon | LBN | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Lebanese Army | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 2 | 1712 | 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 |
5245fe75-96d9-411d-9306-11eb9b86f59c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Qatar | QAT | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Qatar Armed Forces Strategic Studies Center | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
853e8ad8-ad06-402a-bcb8-4d4d6257ffd5 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Yemen | YEM | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Ministry of Foreign Affairs | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
b87ce59e-4899-4ee5-86ee-6881a8f8f0d2 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Yemen | YEM | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Yemen Ministry of Defense | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
c82f4e1a-992e-41d3-bcc4-d0907ab895ff | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Maldives | MDV | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Maldives Defense Forces | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
1d41c5a7-5fd2-4a34-9815-2217cd7d13d9 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Maldives | MDV | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Maldives National Centre for Information Technology | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
00a7e689-b56d-42ff-bb2b-bdde050bf1ce | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Embassy of the United States in Nepal | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
008c9b90-c25f-4878-b875-acd9f4535149 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Nepal Ministry of Defense | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
8ca6fbdb-2d48-4aa1-821c-d1cacf41efe6 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Nepali Army | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
7ec64cf9-bbdd-4496-9dbc-2224e3ae95e3 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Pakistan Air Force | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
be255920-85e4-42ab-9bbe-3b473102e2ae | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Uzbekistan | UZB | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Embassy of the United States in Uzbekistan | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 4 | 3424 | 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 |
f990a9da-a55b-4119-90d3-7a5078b0fbc2 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Uzbekistan | UZB | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Uzbekistan Armed Forces Academy | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 1 | 856 | 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 |
61149098-9d7d-4279-a436-57174f5a3866 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Uzbekistan | UZB | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Executive Seminar | NESA - 0 | Uzbekistan Ministry for Development of Information Tech. & Communications | 7/13/2020 | 2020-07-13 | 7/17/2020 | 2020-07-17 | Virtual - Event | 2 | 1712 | 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 |
3a2e1571-4277-43c4-93da-b5fcdef2130c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Mali | MLI | PKO - Fiscal Year 2020 Department of State Training | Equipment Basic Operator Training (GPS & Printer) (Iteration 1) | PAE - 7 | DSM | 7/8/2020 | 2020-07-08 | 7/17/2020 | 2020-07-17 | BAMAKO, MALI | 7 | 8890 | 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 |
8c0e32f6-a3ba-4bd5-b2b5-d55a6469550d | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | Air Combat Command No. 3 Malambo, Atlantico | 7/7/2020 | 2020-07-07 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 8370 | 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 |
b85dcaab-5a47-4d4b-a6bf-66d613c3022e | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Kosovo | XKX | Section 333 - Fiscal Year 2020 Department of Defense Training | Contractor Furnished OCONUS Operator And Maintenan | Kosovo (In Country Training) - 0 | CIS COY, LFC, Kosovo Security Force | 7/6/2020 | 2020-07-06 | 7/17/2020 | 2020-07-17 | Kosovo (In Country Training) | 5 | 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 |
38e974f1-67c7-43b6-a75b-4959ed3d12d5 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Kosovo | XKX | Section 333 - Fiscal Year 2020 Department of Defense Training | Contractor Furnished OCONUS Operator And Maintenan | Kosovo (In Country Training) - 0 | Land Force Command, Kosovo Security Force | 7/6/2020 | 2020-07-06 | 7/17/2020 | 2020-07-17 | Kosovo (In Country Training) | 4 | 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 |
d81fd6eb-f20a-48fe-8a4f-e9b3620a0415 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Kosovo | XKX | Section 333 - Fiscal Year 2020 Department of Defense Training | Contractor Furnished OCONUS Operator And Maintenan | Kosovo (In Country Training) - 0 | Logistics Command, Kosovo Security Force | 7/6/2020 | 2020-07-06 | 7/17/2020 | 2020-07-17 | Kosovo (In Country Training) | 2 | 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 |
2925beb4-820d-4561-a6af-fe7637b06f4f | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Kosovo | XKX | Section 333 - Fiscal Year 2020 Department of Defense Training | Contractor Furnished OCONUS Operator And Maintenan | Kosovo (In Country Training) - 0 | National Guard, Kosovo Security Force | 7/6/2020 | 2020-07-06 | 7/17/2020 | 2020-07-17 | Kosovo (In Country Training) | 2 | 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 |
3276902c-fa2a-45ae-b9f7-c39070ceeb11 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Kosovo | XKX | Section 333 - Fiscal Year 2020 Department of Defense Training | Contractor Furnished OCONUS Operator And Maintenan | Kosovo (In Country Training) - 0 | TRADOC, Kosovo Security Force | 7/6/2020 | 2020-07-06 | 7/17/2020 | 2020-07-17 | Kosovo (In Country Training) | 3 | 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 |
bff0bf3c-b2ba-4eed-8367-a09c993fbbf7 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET-1 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | Directorate Of Geographical Affairs | 7/6/2020 | 2020-07-06 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 12452 | 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 |
2a53e9df-d0b5-45ca-9661-77c25fbbf3f1 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Tunisia | TUN | IMET-1 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | Logistics Bureau , AF Head Quarters | 7/6/2020 | 2020-07-06 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 14250 | 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 |
3d3ece53-347f-4d20-8eb2-b95fa21fe622 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | SEDENA | 7/6/2020 | 2020-07-06 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 11020 | 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 |
357335b2-1344-4b1f-b7a9-9f0b333765fd | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Liberia | LBR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Command & General Staff College - 0 | Armed Forces Of Liberia | 7/5/2020 | 2020-07-05 | 7/17/2020 | 2020-07-17 | Ft. Leavenworth, KS, US | 1 | 2495 | 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 |
486377ec-bc4a-4e6b-8215-aebfa9ee4ebf | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | IMET-2 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | No 25 Tactical Attack Squadron, Pakistan Air Force Base RAFIQUI, SHORKOT | 7/1/2020 | 2020-07-01 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 18203 | 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 |
1df5fbd3-43b6-4939-af67-f77e51830e70 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | IMET-1 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | Defense Research & Development Center | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 13534 | 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 |
6f6abc7a-9116-4fbe-87dd-b4de1a76abf8 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Kenya | KEN | IMET-1 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | Laikipia Air Base | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 20002 | 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 |
54154d63-60c4-4038-895e-6f5958962c4d | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | IMET-1 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | Indonesian Air Force/Indonesian War College | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 19252 | 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 |
b2ee6e88-28f6-4be8-884b-471dfe3d7f1a | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Mongolia | MNG | IMET-1 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | GSMAF | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 13220 | 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 |
6f0c7b99-c127-43d9-8ca8-90ee70e161ef | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | Office Of the Commanding Officer, Air Force Finance Center, Philippine Air Force | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 17431 | 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 |
f30b1273-7506-45ff-af94-dd412805d9e3 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Thailand | THA | IMET-2 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | Education Division, Air Command And Staff College, Directorate Of Education And Training, Royal Thai Air Force | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 13220 | 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 |
3ec952cd-af5b-47e2-8d24-230643cd3a75 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Ukraine | UKR | IMET-1 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | East Air Command Of the Air Force Unit A2533 | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 17388 | 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 |
641c116c-899e-4753-ab58-16917ae6ed8b | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | Air Operations Directorate | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 12452 | 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 |
2a52d4b1-979c-4132-b672-c08510759597 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | Argentine Air Force | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 8370 | 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 |
413ca263-b3aa-4e6e-8f28-cb1b14abfbc4 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - Fiscal Year 2020 Department of State Training | DIST ED: CYBER Network (IAAFA - Spanish) | IAAFA Distance Learning - 0 | Argentine Air Force | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Homestead AFB, FL, US | 1 | 480 | 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 |
a9cb32ba-877a-4b58-a81b-92a711f25b05 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | IMET-1 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | Management Directorate | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 8370 | 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 |
c9868aa6-f855-4122-ad8a-e9a6dd51a0ea | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2020 Department of State Training | DIST ED: CYBER Network (IAAFA - Spanish) | IAAFA Distance Learning - 0 | Colombian NCO Academy, Madrid Cundinamarca | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Homestead AFB, FL, US | 5 | 2400 | 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 |
78135029-a08d-44cb-a18a-230e048e44e9 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2020 Department of State Training | DIST ED: CYBER Network (IAAFA - Spanish) | IAAFA Distance Learning - 0 | Colombian Army | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Homestead AFB, FL, US | 2 | 960 | 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 |
62ce5013-bdbc-459e-b83b-b5a743ebe260 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 333 - Fiscal Year 2020 Department of Defense Training | DIST ED: CYBER Network (IAAFA - Spanish) | IAAFA Distance Learning - 0 | SEMAR | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Homestead AFB, FL, US | 2 | 960 | 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 |
d0c70edc-ee48-4e8c-904d-6cfcdf95ddd1 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | IMET-1 - Fiscal Year 2020 Department of State Training | DIST ED: CYBER Network (IAAFA - Spanish) | IAAFA Distance Learning - 0 | Police/SENAN | 6/29/2020 | 2020-06-29 | 7/17/2020 | 2020-07-17 | Homestead AFB, FL, US | 1 | 480 | 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 |
aa56b292-5c72-4379-bcba-388c4cd0b126 | 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/20/2020 | 2020-06-20 | 7/17/2020 | 2020-07-17 | Ft. Leavenworth, KS, US | 1 | 5420 | 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 |
775d541e-26e5-44b7-85eb-e99f4953ccc7 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Malawi | MWI | IMET-X - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Sergeants Major Academy - 0 | Zomba Air Base | 6/20/2020 | 2020-06-20 | 7/17/2020 | 2020-07-17 | Ft. Bliss, TX, US | 1 | 4992 | 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 |
b4cf1e3e-b7cd-40e3-aa39-df39544df996 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Nigeria | NGA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Sergeants Major Academy - 0 | Nigerian School Of Artillery KACHIA | 6/20/2020 | 2020-06-20 | 7/17/2020 | 2020-07-17 | Ft. Bliss, TX, US | 1 | 4592 | 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 |
73c82ab1-c48c-4bcb-8bb4-3dcc7fc61dc1 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Sierra Leone | SLE | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Sergeants Major Academy - 0 | Armed Forces Training Center | 6/20/2020 | 2020-06-20 | 7/17/2020 | 2020-07-17 | Ft. Bliss, TX, US | 1 | 4592 | 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 |
bb828901-fb61-4fef-9192-8aeb581874ec | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | College Of International Security Affairs - 0 | Beirut Intelligence Office | 6/20/2020 | 2020-06-20 | 7/17/2020 | 2020-07-17 | Ft. Mcnair, NDU, DC, US | 1 | 9864 | 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 |
3641faa3-402c-4eeb-9134-ee6a09e4e592 | 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 | College Of International Security Affairs - 0 | High College Of Military Studies, Kenitra | 6/20/2020 | 2020-06-20 | 7/17/2020 | 2020-07-17 | Ft. Mcnair, NDU, DC, US | 1 | 9464 | 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 |
11d0eb06-d090-42f7-b9d5-4ea4acb20cb8 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Belize | BLZ | FMF - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Sergeants Major Academy - 0 | Logistics Company | 6/20/2020 | 2020-06-20 | 7/17/2020 | 2020-07-17 | Ft. Bliss, TX, US | 1 | 5192 | 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 |
da9329f0-0352-4f3a-bacc-c60ff3fc30f7 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | Maintenance Test Pilot UH-60 | UNK - 0 | Colombian Army | 6/16/2020 | 2020-06-16 | 7/17/2020 | 2020-07-17 | Tolemaida | 2 | 86920 | 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 |
13751b7f-1b02-4362-b909-73cf03fa88dc | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Cameroon | CMR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Army War College - 0 | Military Intelligence Center | 6/6/2020 | 2020-06-06 | 7/17/2020 | 2020-07-17 | Carlisle Barracks, PA, US | 1 | 6594 | 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 |
e344b244-661f-4660-9ce5-52d19c181ae6 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | FMF - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Army War College - 0 | Headquarters And Headquarters Support Group, Philippine Army | 6/6/2020 | 2020-06-06 | 7/17/2020 | 2020-07-17 | Carlisle Barracks, PA, US | 1 | 7394 | 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 |
e963859b-a8e7-49e7-a925-6ecf6d83bca1 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Nigeria | NGA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Manscen Army Training Center - 0 | 13 Field Engineer Regiment, JOS | 5/25/2020 | 2020-05-25 | 7/17/2020 | 2020-07-17 | Ft. Leonard Wood, MO, US | 1 | 11403 | 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 |
1f640993-c88b-41de-aa9d-c895483dd39b | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Nigeria | NGA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Manscen Army Training Center - 0 | 45 Engineer Brigade, IKOYI Lagos | 5/25/2020 | 2020-05-25 | 7/17/2020 | 2020-07-17 | Ft. Leonard Wood, MO, US | 1 | 11403 | 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 |
f031410d-23f3-4261-a697-66d6c4280439 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Senegal | SEN | IMET-1 - Fiscal Year 2020 Department of State Training | Professional Military Education PREP (PME PREP) | DLIELC, Lackland AFB TX - 0 | Navy Support Group | 5/18/2020 | 2020-05-18 | 7/17/2020 | 2020-07-17 | Lackland AFB, TX, US | 1 | 15289 | 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 |
e80fe208-a63b-4535-815a-537f6fba512b | 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 | NDU College Of Information And Cyberspace - 0 | School Of High Military Studies- F.A.R | 4/12/2020 | 2020-04-12 | 7/17/2020 | 2020-07-17 | Ft. Mcnair, NDU, DC, US | 1 | 28564 | 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 |
f85a47b4-9ebc-444e-8f22-ee70068692e8 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Chad | TCD | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | DLIELC, Lackland AFB TX - 0 | Land Forces | 4/11/2020 | 2020-04-11 | 7/17/2020 | 2020-07-17 | Lackland AFB, TX, US | 1 | 10000 | 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 |
bdc33e35-c38e-4c0d-9a9c-6fac1a8ffa48 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Chile | RCH | IMET-1 - Fiscal Year 2020 Department of State Training | NWC International Fellows Program | Naval War College, Newport, RI - 0 | U.S. Naval Command College | 6/24/2019 | 2019-06-24 | 7/17/2020 | 2020-07-17 | Newport, RI, US | 1 | 6714 | 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]);