training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
74 rows where "qa:training_date_first_seen" is on date 2017-10-27 and "training:end_date" is on date 2016-03-25 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ef041f61-2d1c-4f5d-88e0-232b7cda1cd4 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Burkina Faso | BFA | PKO - Fiscal Year 2016 Department of State Training | Field Medical Training | N/A | LAAFI-8 | 3/21/2016 | 2016-03-21 | 3/25/2016 | 2016-03-25 | Loumbila, Burkina Faso | 29 | 13170 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
80ab8ab9-6be2-4798-b488-a197b2e9ecfd | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Congo, Republic of (Brazzaville) | COG | FMF - Fiscal Year 2016 Department of State Training | Joint Transition Course | Joint Forces Staff College | Infantry | 3/21/2016 | 2016-03-21 | 3/25/2016 | 2016-03-25 | Norfolk, VA, US | 1 | 3929 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
19b6d27d-2aea-4c29-b010-c3350d673e18 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Sierra Leone | SLE | Non-SA, UC - Fiscal Year 2016 Department of Defense Training | Exercise Western Accord | US AFRICOM | Ministry of Defense/RSLAF | 3/21/2016 | 2016-03-21 | 3/25/2016 | 2016-03-25 | Burkina Faso-FPE | 1 | 3270 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
750eabf3-aeb2-43c5-879c-39172b21b5bc | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Europe_fmtrpt.tsv | Serbia, Republic of | SRB | IMET-1 - Fiscal Year 2016 Department of State Training | ENG BOLC-B International STU PREP | Manscen Army Training Center | 18 Engineer Battalion/1st Army Brigade | 3/21/2016 | 2016-03-21 | 3/25/2016 | 2016-03-25 | Ft. Leonard Wood, MO, US | 1 | 7204 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
c356bfac-8111-43fc-9ca2-1d20b19f2e5b | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2016 Department of State Training | ENG BOLC-B International STU PREP | Manscen Army Training Center | Military Engineers | 3/21/2016 | 2016-03-21 | 3/25/2016 | 2016-03-25 | Ft. Leonard Wood, MO, US | 1 | 7104 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
5c74feab-17f4-479e-84cb-0bfbd8f3d60d | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - Fiscal Year 2016 Department of State Training | Joint Transition Course | Joint Forces Staff College | 10th Infantry Brigade | 3/21/2016 | 2016-03-21 | 3/25/2016 | 2016-03-25 | Norfolk, VA, US | 1 | 9366 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
b261cde0-35c4-4af4-8f5a-89408d762a2c | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - Fiscal Year 2016 Department of State Training | Joint Transition Course | Joint Forces Staff College | 1st Intervention Regiment | 3/21/2016 | 2016-03-21 | 3/25/2016 | 2016-03-25 | Norfolk, VA, US | 1 | 9366 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
6626c655-093c-42f1-a58b-233ca1e5c6eb | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - Fiscal Year 2016 Department of State Training | Joint Transition Course | Joint Forces Staff College | Military Police | 3/21/2016 | 2016-03-21 | 3/25/2016 | 2016-03-25 | Norfolk, VA, US | 1 | 9366 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
e7a9115b-1362-45cc-b8c8-bcc47beb5cd8 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | IMET-1 - Fiscal Year 2016 Department of State Training | Joint Transition Course | Joint Forces Staff College | Army Intelligence Center | 3/21/2016 | 2016-03-21 | 3/25/2016 | 2016-03-25 | Norfolk, VA, US | 1 | 2024 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
69ec3a3b-b8f4-4bf7-8120-839a0f12ce89 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2016 Department of State Training | Joint Transition Course | Joint Forces Staff College | COEJC | 3/21/2016 | 2016-03-21 | 3/25/2016 | 2016-03-25 | Norfolk, VA, US | 2 | 6936 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
5e82eaa3-5b79-443d-a95c-3e5002af317e | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Burkina Faso | BFA | PKO - Fiscal Year 2016 Department of State Training | Engineer and Explosive Ordnance Recon (EEOR) | N/A | LAAFI-8 | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Loumbila, Burkina Faso | 40 | 19233 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
f11681f5-c351-4c0a-b34e-34a35b891be6 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Burkina Faso | BFA | PKO - Fiscal Year 2016 Department of State Training | Mechanized Operations Training | N/A | LAAFI-8 | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Loumbila, Burkina Faso | 125 | 18500 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
a1eccc58-36f0-4911-a70c-3961792fa879 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Burkina Faso | BFA | PKO - Fiscal Year 2016 Department of State Training | PSO Soldier Skills Training | N/A | LAAFI-8 | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Loumbila, Burkina Faso | 36 | 47478 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
3285ba09-8dc5-4ce3-b2fc-e72659ff3c46 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | 195459 | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
993bae14-79c5-4b00-956a-04418edbf2c2 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | 196566 | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
e4f0005b-9c0a-4a0a-98a3-8d69e128585a | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | 201875 | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
03813fb0-7b5c-400b-bddb-fc9db0d796a0 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | Ghana Navy | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
2fc3f910-dc40-4a97-b508-06597ee1abd1 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | GNS ANZONE | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
fe37f727-de07-4b9d-8a08-38499270110b | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | GNS EHWOR | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
7d53a2ed-a3e8-4b25-8853-e29c0373c31a | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | GNSD | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 6 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
e6388e77-f8b1-4d80-a03a-c3bacf54aa31 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | Headquarters ENC | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
b8ae2966-a488-4c81-a873-381ecbe82aee | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | HQ ENC | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
727d7248-e4f9-44b1-a731-9ba547a8e216 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | HQ WNC | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
af8f877e-2074-45e5-bd4e-d56e0548e29f | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | Naa GBEWAA Ship | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
898d72b5-ab65-49aa-8a39-d844e97b0c53 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | Naval Base Sekondi | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 3 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
6073c79d-95d1-4ca8-b80b-d99528e802f8 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | Naval Base Tema | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
3a3f5676-7293-4507-a97e-a4af57a51664 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | NAVDOCK | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 2 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
d13e98c4-b192-4f3a-aeb8-5c736e073e32 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | Navy Trade School | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
b1963371-f2a4-4f75-a903-8b2c9ba6ffb5 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | NB SEK | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 2 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
fd31cdf7-b691-48a5-b4c2-850b980fa0ed | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | NB TEMA | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 4 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
1ac9846a-5870-4bfd-be9d-8aebb8d972c7 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | NTTS | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
3d719dfd-9b6e-4a72-a660-efe25ebddbd0 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2016 Department of State Training | APS Supply Maritime Security Force | Ghana (In Country Training) | Yaa Asantewaa Ship | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ghana (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
39d43369-fc5b-466b-8076-d79c8fb050fa | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Senegal | SEN | PKO - Fiscal Year 2016 Department of State Training | VIP Protection Training | N/A | SENBATT 16 | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Toubacouta, Senegal | 40 | 11598 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
21294db7-b2a9-4cc9-b478-17eb3b5017e8 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | FMF - Fiscal Year 2016 Department of State Training | ADA Captains Career Preparatory International | Air Defense Artillery School | Brawijaya/5th Military Area Command | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ft. Sill, OK, US | 1 | 9920 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
b941a57b-b726-4133-9e38-9ff74aa67f74 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Europe_fmtrpt.tsv | Montenegro, Republic of | NME | DOHS/USCG - Fiscal Year 2016 Department of Homeland Security Training | SBO II | COGARD International Training DET Tracen Yorktown VA | Border Police | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Yorktown, VA, US | 12 | 0 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
dddc5c20-cc2d-4ae8-8f63-812ad1b475c8 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Egypt | EGY | IMET-2 - Fiscal Year 2016 Department of State Training | ADA Captains Career Preparatory International | Air Defense Artillery School | Air Defense | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ft. Sill, OK, US | 1 | 7850 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
cfc79bef-29d3-4f71-a827-6ed1abae8236 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Egypt | EGY | IMET-2 - Fiscal Year 2016 Department of State Training | ADA Captains Career Preparatory International | Air Defense Artillery School | Air Defense Department | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ft. Sill, OK, US | 1 | 7850 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
01b526d3-72dd-45cf-8ee1-b2c21c1920e4 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2016 Department of State Training | ADA Captains Career Preparatory International | Air Defense Artillery School | Air Defense Directorate | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ft. Sill, OK, US | 1 | 8300 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
3750fe58-f3b0-4b4c-8c37-32487c73f534 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Tunisia | TUN | IMET-1 - Fiscal Year 2016 Department of State Training | ADA Captains Career Preparatory International | Air Defense Artillery School | FONDOUK JEDID/Military Academy | 3/14/2016 | 2016-03-14 | 3/25/2016 | 2016-03-25 | Ft. Sill, OK, US | 1 | 9950 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
556f1cd2-1e33-4d3e-8b87-4eb26fb4324a | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Madagascar | MDG | Misc DoD/DoS Non-SA - Fiscal Year 2016 Department of Defense Training | Maritime Professionalization | MPP-118 - 4 | ANTSIRANANA NAVAL BASE | 3/12/2016 | 2016-03-12 | 3/25/2016 | 2016-03-25 | ANTSIRANANA | 30 | 1000 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
7dcf5255-90da-4359-83a6-a99ea1cdf7d1 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Palestinian Authority | PSE | CTFP - Fiscal Year 2016 Department of Defense Training | JSOU MIPR | Palestinian Authority (In Country Training) | Air Force | 3/12/2016 | 2016-03-12 | 3/25/2016 | 2016-03-25 | Palestinian Authority (In Country Training) | 1 | 7264 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
77be9ab4-095a-4114-8987-66c2c8161de9 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Jamaica | JAM | Section 1004 - Fiscal Year 2016 Department of Defense Training | Tactical Combat Casualty Care (TCCC) | U S NAV Small Craft Instructor And TECH Training School S | Jamaica Defense Force | 3/11/2016 | 2016-03-11 | 3/25/2016 | 2016-03-25 | Stennis Space Center, MS, US | 2 | 17092 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
cadb5d8f-8648-4f8c-8e73-53c6080aec5b | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Senegal | SEN | PKO - Fiscal Year 2016 Department of State Training | Command and Staff Operational Skills | N/A | SENBATT 16 | 3/10/2016 | 2016-03-10 | 3/25/2016 | 2016-03-25 | Toubacouta, Senegal | 32 | 87385 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
982de87c-729d-41a6-814a-f5a8a0e5ea26 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | FMF - Fiscal Year 2016 Department of State Training | Integrated Defense COMD&Control Course (IDC3) | Lackland AFB, TX (Other Than DLI And IAAFA S | 732nd Communications Squadron | 3/7/2016 | 2016-03-07 | 3/25/2016 | 2016-03-25 | Lackland AFB, TX, US | 1 | 7166 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
6e00ca12-afb7-41ed-8f2c-db9e0c5f8491 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2016 Department of State Training | Theater Air Options Course (TAOC) | Tyndall AFB, FL | Unit 501 | 3/7/2016 | 2016-03-07 | 3/25/2016 | 2016-03-25 | Tyndall AFB, FL, US | 2 | 3860 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
3d5cf9d1-4fc0-4c6b-ad4c-a08577fe542e | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2016 Department of State Training | Theater Air Options Course (TAOC) | Tyndall AFB, FL | Air Control Directorate | 3/7/2016 | 2016-03-07 | 3/25/2016 | 2016-03-25 | Tyndall AFB, FL, US | 1 | 4177 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
3ad59c6d-5595-4ce8-86f5-8a32ef31b491 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Europe_fmtrpt.tsv | Georgia | GEO | IMET-1 - Fiscal Year 2016 Department of State Training | Ranger Recycle Training (MCOE IMSO) | Armor School | National Defense Academy | 3/4/2016 | 2016-03-04 | 3/25/2016 | 2016-03-25 | Ft. Benning, GA, US | 1 | 3189 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
45a85f98-93a8-4fd7-b09a-210256b81bcc | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Kenya | KEN | IMET-1 - Fiscal Year 2016 Department of State Training | FA Off Advanced Preparatory-Allied Officer | Field Artillery School | HQ Artillery Brigade | 3/3/2016 | 2016-03-03 | 3/25/2016 | 2016-03-25 | Ft. Sill, OK, US | 1 | 10615 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
92c28b65-3642-47e0-b804-d859137664b3 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2016 Department of State Training | FA Off Advanced Preparatory-Allied Officer | Field Artillery School | Artillery HQ Of Southern Division | 3/3/2016 | 2016-03-03 | 3/25/2016 | 2016-03-25 | Ft. Sill, OK, US | 1 | 8765 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
9f84db0e-31a6-4e93-b34a-8b33dffe1086 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - Fiscal Year 2016 Department of State Training | FA Off Advanced Preparatory-Allied Officer | Field Artillery School | 2d Artillery Regiment | 3/3/2016 | 2016-03-03 | 3/25/2016 | 2016-03-25 | Ft. Sill, OK, US | 1 | 10365 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
0856eee8-262f-4799-876f-965ac27902d7 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Tunisia | TUN | IMET-1 - Fiscal Year 2016 Department of State Training | FA Off Advanced Preparatory-Allied Officer | Field Artillery School | Military Academy/Foundouk Jedid | 3/3/2016 | 2016-03-03 | 3/25/2016 | 2016-03-25 | Ft. Sill, OK, US | 1 | 10465 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
503ff445-2561-47c3-bdae-2ddc81a45f99 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | ASFF - Fiscal Year 2016 Department of Defense Training | FA Off Advanced Preparatory-Allied Officer | Field Artillery School | MoD | 3/3/2016 | 2016-03-03 | 3/25/2016 | 2016-03-25 | Ft. Sill, OK, US | 1 | 9948 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
87a661df-5c21-4fa4-94b5-f9aa850e938e | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Senegal | SEN | Section 1004 - Fiscal Year 2016 Department of Defense Training | M-SFA Cadre Enhancement | SPMAGTF-CR-AF - 20 | COFUMACO | 2/29/2016 | 2016-02-29 | 3/25/2016 | 2016-03-25 | Dakar | 61 | 124648 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
7b4217f0-5965-42d4-b6ca-e16136570589 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2016 Department of State Training | Military Free Fall Parachutist | JFK Special Warfare Center | Air Born 182 | 2/29/2016 | 2016-02-29 | 3/25/2016 | 2016-03-25 | Ft. Bragg, NC, US | 1 | 7601 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
41194868-caf7-42fa-a05c-d034f3dd2271 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Gabon | GAB | PKO - Fiscal Year 2016 Department of State Training | PSO Soldier Skills Training | N/A | GANBATT 2 | 2/15/2016 | 2016-02-15 | 3/25/2016 | 2016-03-25 | Libreville, Gabon | 393 | 307359 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
b4b0380e-2dba-488e-88bd-bbd18995d5ea | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Zambia | ZMB | PKO - Fiscal Year 2016 Department of State Training | PSO Soldier Skills Training | N/A | ZAMBATT 2 | 2/15/2016 | 2016-02-15 | 3/25/2016 | 2016-03-25 | Nanking Abta, Zambia | 152 | 261139 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
40ee9b5b-1c3b-4975-96e9-82e1f6695219 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Jordan | JOR | ALP - Fiscal Year 2016 Department of Defense Training | ALC ALP Scholarship | DLIELC, Lackland AFB TX | King Hussain Air College | 1/25/2016 | 2016-01-25 | 3/25/2016 | 2016-03-25 | Lackland AFB, TX, US | 1 | 10715 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
80dda236-d9bc-4924-8501-d4216a9f4ed7 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | IMET-1 - Fiscal Year 2016 Department of State Training | ALC Specialized English Training Only | DLIELC, Lackland AFB TX | Headquarters Air Defense Command | 1/25/2016 | 2016-01-25 | 3/25/2016 | 2016-03-25 | Lackland AFB, TX, US | 1 | 17394 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
5690cb87-6c23-4778-832d-2ca964e2b920 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2016 Department of State Training | Ranger | Infantry School | SF Battalion, MD Army | 1/24/2016 | 2016-01-24 | 3/25/2016 | 2016-03-25 | Ft. Benning, GA, US | 1 | 6762 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
479ba7bb-be82-4ce2-b793-8410b49b82a2 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Gabon | GAB | PKO - Fiscal Year 2016 Department of State Training | Africa Contengency Operation and Training Assistance - ACOTA | ACOTA Contractor - 19 | All military Components | 1/18/2016 | 2016-01-18 | 3/25/2016 | 2016-03-25 | Libreville, Gabon | 450 | 1000000 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
db7410cb-d9a9-44d0-a5e0-3b188de295e8 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_East_Asia_and_Pacific_fmtrpt.tsv | Vietnam | VNM | IMET-1 - Fiscal Year 2016 Department of State Training | American Language Course General English Training Only | DLIELC, Lackland AFB TX | Vietnam Air Defense - Air Force | 1/18/2016 | 2016-01-18 | 3/25/2016 | 2016-03-25 | Lackland AFB, TX, US | 1 | 17971 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
61f2219f-ee65-4e2f-809e-af6f59c2aa10 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2016 Department of State Training | American Language Course General English Training Only | DLIELC, Lackland AFB TX | 2nd Infantry Brigade, Moldovan Army | 1/4/2016 | 2016-01-04 | 3/25/2016 | 2016-03-25 | Lackland AFB, TX, US | 1 | 20390 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
55f179e3-88cc-4653-a058-7d397ac1d383 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Tunisia | TUN | IMET-1 - Fiscal Year 2016 Department of State Training | Engineering Science | Naval Postgraduate School Monterey CA | TAF HQs Human Resources Department/Ministry Of National Defense | 12/28/2015 | 2015-12-28 | 3/25/2016 | 2016-03-25 | Monterey, CA, US | 1 | 24157 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
d6bc445b-8c9c-4def-876b-4cd9dbdcd290 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | ASFF - Fiscal Year 2016 Department of Defense Training | American Language Course General English Training Only | DLIELC, Lackland AFB TX | MOD | 12/28/2015 | 2015-12-28 | 3/25/2016 | 2016-03-25 | Lackland AFB, TX, US | 1 | 42157 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
629b5f76-cfd3-47cd-a837-cd8a701c2d7f | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | IMET-1 - Fiscal Year 2016 Department of State Training | CYBER Security Fundamentals Certificate | Naval Postgraduate School Monterey CA | Military Intelligence Directorate, GHQ, Rawalpindi | 12/28/2015 | 2015-12-28 | 3/25/2016 | 2016-03-25 | Monterey, CA, US | 1 | 29800 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
d27385ed-bf44-4521-ae8a-caba3f7f5eaa | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | IMET-1 - Fiscal Year 2016 Department of State Training | Engineering Science | Naval Postgraduate School Monterey CA | HQ 11 Division | 12/28/2015 | 2015-12-28 | 3/25/2016 | 2016-03-25 | Monterey, CA, US | 1 | 28848 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
878c4b89-9b0f-45d6-bf93-1def02d0e131 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Cameroon | CMR | IMET-1 - Fiscal Year 2016 Department of State Training | American Language Course GET And SET | DLIELC, Lackland AFB TX | EPAEM - ISSONGO | 12/14/2015 | 2015-12-14 | 3/25/2016 | 2016-03-25 | Lackland AFB, TX, US | 1 | 28207 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
4107b89d-025c-43c7-9a39-29e223d4e148 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Senegal | SEN | IMET-1 - Fiscal Year 2016 Department of State Training | American Language Course GET And SET | DLIELC, Lackland AFB TX | Air Force Operations Unit | 12/14/2015 | 2015-12-14 | 3/25/2016 | 2016-03-25 | Lackland AFB, TX, US | 1 | 25331 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
92e78eb8-4c18-4647-9b9a-8456dc3ce23c | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Cameroon | CMR | Section 1206/2282 - Fiscal Year 2016 Department of Defense Training | American Language Course General English Training Only | DLIELC, Lackland AFB TX | BIR | 10/19/2015 | 2015-10-19 | 3/25/2016 | 2016-03-25 | Lackland AFB, TX, US | 8 | 285424 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
ade93a75-6cad-4c95-aa73-0c7e7add649c | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Jordan | JOR | Section 1206/2282 - Fiscal Year 2016 Department of Defense Training | Aircraft Training | Contractor - 5 | 25 squadron | 10/13/2015 | 2015-10-13 | 3/25/2016 | 2016-03-25 | Waco, TX | 5 | 850000 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
13078e9f-813d-400c-a7a5-b1b43ebf3fbf | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Jordan | JOR | Section 1206/2282 - Fiscal Year 2016 Department of Defense Training | AT-802 Pilot Training | L-3 Communications | Air Operations Directorate | 10/13/2015 | 2015-10-13 | 3/25/2016 | 2016-03-25 | Waco, TX, US | 5 | 74400 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
f6a965c2-d504-49f1-8751-58f1f6ce5d42 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_East_Asia_and_Pacific_fmtrpt.tsv | Mongolia | MNG | IMET-1 - Fiscal Year 2016 Department of State Training | CSCDEP Non-Resident Seminar | Mongolia (In Country Training) | Defense University Of Mongolia | 8/3/2015 | 2015-08-03 | 3/25/2016 | 2016-03-25 | Mongolia (In Country Training) | 1 | 698 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
36249a83-8f3a-48ac-a79d-90c75dfb7c86 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | IMET-1 - Fiscal Year 2016 Department of State Training | Civil-Military Relations-MA | Naval Postgraduate School Monterey CA | Foreign Relations Affairs, International Relations Unit | 12/29/2014 | 2014-12-29 | 3/25/2016 | 2016-03-25 | Monterey, CA, US | 1 | 131889 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
24e11ef9-e980-4e59-9b4d-ee098dd5dc4c | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | IMET-1 - Fiscal Year 2016 Department of State Training | Civil-Military Relations-MA | Naval Postgraduate School Monterey CA | Nepalese Army | 12/29/2014 | 2014-12-29 | 3/25/2016 | 2016-03-25 | Monterey, CA, US | 1 | 134129 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
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]);