training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
71 rows where "qa:training_date_first_seen" is on date 2018-08-15 and "training:end_date" is on date 2016-12-02 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
705d93c9-cdd8-4a11-86e7-4fd93fa2654b | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2017 Department of State Training | FPU Coordinators Course | N/A | N/A | 11/28/2016 | 2016-11-28 | 12/2/2016 | 2016-12-02 | Center of Excellence for Stability Police Units, Vicenza, Italy | 1 | 1403 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
5e973a92-d59a-4bd5-a820-c04f13443f08 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Madagascar | MDG | PKO - Fiscal Year 2017 Department of State Training | FPU Coordinators Course | N/A | N/A | 11/28/2016 | 2016-11-28 | 12/2/2016 | 2016-12-02 | Center of Excellence for Stability Police Units, Vicenza, Italy | 1 | 1403 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
04adb52a-34ff-481a-aeb2-5ddf686ab380 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Malawi | MWI | PKO - Fiscal Year 2017 Department of State Training | FPU Coordinators Course | N/A | N/A | 11/28/2016 | 2016-11-28 | 12/2/2016 | 2016-12-02 | Center of Excellence for Stability Police Units, Vicenza, Italy | 1 | 1403 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
701887ec-5c47-44c3-9595-9390c559f908 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Mali | MLI | PKO - Fiscal Year 2017 Department of State Training | American Language Course General English Training Only | DLIELC, LACKLAND AFB TX | 311 CCAS | 11/28/2016 | 2016-11-28 | 12/2/2016 | 2016-12-02 | Lackland AFB, TX, US | 1 | 11076 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
016a4650-ee6f-4d70-b2a5-f3f244ed302c | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Togo | TGO | PKO - Fiscal Year 2017 Department of State Training | FPU Coordinators Course | N/A | N/A | 11/28/2016 | 2016-11-28 | 12/2/2016 | 2016-12-02 | Center of Excellence for Stability Police Units, Vicenza, Italy | 1 | 1403 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
5852b208-57bc-49c0-acb8-9b2354c626e3 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Europe_fmtrpt.tsv | Ukraine | UKR | PKO - Fiscal Year 2017 Department of State Training | FPU Coordinators Course | N/A | N/A | 11/28/2016 | 2016-11-28 | 12/2/2016 | 2016-12-02 | Center of Excellence for Stability Police Units, Vicenza, Italy | 1 | 1403 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
40dc857a-0894-4605-acfc-6bc634913d13 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Jordan | JOR | PKO - Fiscal Year 2017 Department of State Training | FPU Coordinators Course | N/A | N/A | 11/28/2016 | 2016-11-28 | 12/2/2016 | 2016-12-02 | Center of Excellence for Stability Police Units, Vicenza, Italy | 1 | 1403 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
886b7093-3497-4886-ac07-9b53f6d086f1 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Tunisia | TUN | PKO - Fiscal Year 2017 Department of State Training | FPU Coordinators Course | N/A | N/A | 11/28/2016 | 2016-11-28 | 12/2/2016 | 2016-12-02 | Center of Excellence for Stability Police Units, Vicenza, Italy | 5 | 7013 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
5e3457e3-848a-491b-868b-1f25ff63e064 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | PKO - Fiscal Year 2017 Department of State Training | FPU Coordinators Course | N/A | N/A | 11/28/2016 | 2016-11-28 | 12/2/2016 | 2016-12-02 | Center of Excellence for Stability Police Units, Vicenza, Italy | 1 | 1403 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
0900b125-315c-4351-8864-974a7cf40ddf | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | PKO - Fiscal Year 2017 Department of State Training | FPU Coordinators Course | N/A | N/A | 11/28/2016 | 2016-11-28 | 12/2/2016 | 2016-12-02 | Center of Excellence for Stability Police Units, Vicenza, Italy | 1 | 1403 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
b84189f7-80ba-46ce-b86f-0038c43c791e | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | PKO - Fiscal Year 2017 Department of State Training | FPU Coordinators Course | N/A | N/A | 11/28/2016 | 2016-11-28 | 12/2/2016 | 2016-12-02 | Center of Excellence for Stability Police Units, Vicenza, Italy | 1 | 1403 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
1031a8ef-6c7d-4b7c-8dc4-7b098545cf03 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Uruguay | URY | PKO - Fiscal Year 2017 Department of State Training | FPU Coordinators Course | N/A | N/A | 11/28/2016 | 2016-11-28 | 12/2/2016 | 2016-12-02 | Center of Excellence for Stability Police Units, Vicenza, Italy | 2 | 2806 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
7ad97ed5-2381-4930-bda4-0d601a38480d | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Europe_fmtrpt.tsv | Serbia, Republic of | SRB | IMET-1 - Fiscal Year 2017 Department of State Training | CYBER Security For Information Leaders (6201) | NDU College of Information and Cyberspace | Ministry of Defense/Center for CIS and IT | 11/23/2016 | 2016-11-23 | 12/2/2016 | 2016-12-02 | Ft. Mcnair, NDU, DC, US | 2 | 25484 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
3d4bd538-06c2-4d1c-8f7d-59bc5ce37dfb | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Egypt | EGY | IMET-2 - Fiscal Year 2017 Department of State Training | CYBER Security For Information Leaders (6201) | NDU College of Information and Cyberspace | AMMUNITION DEPT | 11/23/2016 | 2016-11-23 | 12/2/2016 | 2016-12-02 | Ft. Mcnair, NDU, DC, US | 1 | 4294 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
ef2de9a5-df8c-4306-b01b-eea02574363e | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2017 Department of State Training | CH-47D Flight Simulator | AVIATION SCHOOL | KOM OSHEIM AIR BASE | 11/21/2016 | 2016-11-21 | 12/2/2016 | 2016-12-02 | Ft. Rucker, AL, US | 1 | 15521 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
28f47ccf-7b33-4085-a9bf-625e808ecda9 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2017 Department of State Training | CH-47D Flight Simulator | AVIATION SCHOOL | KOUM OUSHIM AIR BASE | 11/21/2016 | 2016-11-21 | 12/2/2016 | 2016-12-02 | Ft. Rucker, AL, US | 1 | 15521 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
a0ef4b7c-f36b-454e-ab44-05334032c1a4 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | FMF - Fiscal Year 2017 Department of State Training | Ranger Recycle Training (MCOE IMSO) | Armor School | Indonesian Armed Forces/AIRBORNE INFANTRY BRIGADE 17 | 11/19/2016 | 2016-11-19 | 12/2/2016 | 2016-12-02 | Ft. Benning, GA, US | 1 | 1709 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
1a123991-507e-4789-af40-386a25b6316c | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Mauritania | MRT | PKO - Fiscal Year 2017 Department of State Training | Logistics Course | N/A | FAM MINUSCA | 11/14/2016 | 2016-11-14 | 12/2/2016 | 2016-12-02 | Nouakchott Camp, Nouakchott, Mauritania | 20 | 23575 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
6d8bd79f-5964-4ede-aec0-0877f34dea77 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Timor-Leste, Democratic Republic of | TLS | IMET-1 - Fiscal Year 2017 Department of State Training | Airborne | INFANTRY SCHOOL | Fujileiros | 11/14/2016 | 2016-11-14 | 12/2/2016 | 2016-12-02 | Ft. Benning, GA, US | 1 | 6567 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
cfa988dc-7b6d-4325-9f7e-544eb29bb6d0 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2017 Department of State Training | Airborne | INFANTRY SCHOOL | 1st Infantry Brigade, Moldovan Army | 11/14/2016 | 2016-11-14 | 12/2/2016 | 2016-12-02 | Ft. Benning, GA, US | 1 | 4818 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
683b1f6a-ea5d-4f2d-b374-60fb7b92acce | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Uganda | UGA | PKO - Fiscal Year 2017 Department of State Training | Logistics Course | N/A | UG BG 21 | 11/7/2016 | 2016-11-07 | 12/2/2016 | 2016-12-02 | Camp Singo, Jinja, Uganda | 54 | 36435 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
684b940d-fd15-428e-9048-12a07a5b33c6 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2017 Department of State Training | Recovery Operations (Wheeled) | ORDNANCE MUNITIONS & ELECTRONICS SCHOOL | VEHICLE DEPT | 11/7/2016 | 2016-11-07 | 12/2/2016 | 2016-12-02 | Ft. Lee, VA, US | 1 | 10149 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
81e2a124-ea0e-4a55-8a65-b4295196240d | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Europe_fmtrpt.tsv | Kosovo | XKX | Regional Centers - Fiscal Year 2017 Department of Defense Training | MC Scholars Program | GCMC | Kosovo Ministry of Internal Affairs & Security | 10/31/2016 | 2016-10-31 | 12/2/2016 | 2016-12-02 | George C. Marshall European Center for Security Studies, Garmisch-Partenkirchen, Germany | 1 | 2888 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
dd75a182-604e-40e7-868c-e57a1cfd8877 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Burundi | BDI | PKO - Fiscal Year 2017 Department of State Training | AMISOM Force HQ Training | N/A | N/A | 10/30/2016 | 2016-10-30 | 12/2/2016 | 2016-12-02 | Nairobi, Kenya | 15 | 152412 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
415f6f90-c72e-470e-9079-153e1abca3e0 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Djibouti | DJI | PKO - Fiscal Year 2017 Department of State Training | AMISOM Force HQ Training | N/A | N/A | 10/30/2016 | 2016-10-30 | 12/2/2016 | 2016-12-02 | Nairobi, Kenya | 1 | 10161 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
f64d3465-0a09-4e39-a957-13b508d1b923 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Kenya | KEN | PKO - Fiscal Year 2017 Department of State Training | AMISOM Force HQ Training | N/A | N/A | 10/30/2016 | 2016-10-30 | 12/2/2016 | 2016-12-02 | Nairobi, Kenya | 8 | 81286 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
55e957c5-2ca5-4b9d-9766-7b2ee00f15fe | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Uganda | UGA | PKO - Fiscal Year 2017 Department of State Training | AMISOM Force HQ Training | N/A | N/A | 10/30/2016 | 2016-10-30 | 12/2/2016 | 2016-12-02 | Nairobi, Kenya | 11 | 111770 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
d6363b19-6aa8-4c37-bf69-79a97bd8a9f0 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Benin | BEN | PKO - Fiscal Year 2017 Department of State Training | PSO Soldier Skills Training | N/A | MINUSMA 5 | 10/24/2016 | 2016-10-24 | 12/2/2016 | 2016-12-02 | CANA Training Center, Cotonou, Benin | 279 | 144985 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
1088ea2b-118a-424d-9c08-dacc7d6fec43 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Laos | LAO | IMET-1 - Fiscal Year 2017 Department of State Training | American Language Course General English Training Only | DLIELC, LACKLAND AFB TX | ASEAN Department , Ministry of Foriegn Affairs | 10/24/2016 | 2016-10-24 | 12/2/2016 | 2016-12-02 | Lackland AFB, TX, US | 1 | 15427 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
859dca7c-42cc-4fbd-ab66-4365d382fe96 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2017 Department of State Training | International JT Maritime TACT DEV | SURFACE WARFARE OFFICERS SCHOOL COMMAND NEWPO | CARIBBEAN SURFACE FLEET | 10/11/2016 | 2016-10-11 | 12/2/2016 | 2016-12-02 | Newport, RI, US | 1 | 14260 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
620bda22-bb9e-480e-acd6-7113b0eb5ae8 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2017 Department of State Training | International JT Maritime TACT DEV | SURFACE WARFARE OFFICERS SCHOOL COMMAND NEWPO | SEMAR | 10/11/2016 | 2016-10-11 | 12/2/2016 | 2016-12-02 | Newport, RI, US | 2 | 30128 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
b43db68f-d236-4ffa-aa9d-5a332633f743 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Gabon | GAB | IMET-1 - Fiscal Year 2017 Department of State Training | American Language Course GET And SET | DLIELC, LACKLAND AFB TX | Navigation | 10/3/2016 | 2016-10-03 | 12/2/2016 | 2016-12-02 | Lackland AFB, TX, US | 1 | 11065 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
9d3f2171-648f-4382-92ff-7ab65686d1ee | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Benin | BEN | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Military | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 23772 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
8de46352-c588-4bf5-9664-d2c8c963c7ae | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Djibouti | DJI | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Djiboutian Armed Forces | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 36015 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
7c042477-c5a1-48cf-9fb6-c967a025b3fc | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Mauritius | MUS | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Mauritius National Coast Guard | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 26873 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
2217bbda-53d0-4f98-b4b2-126c3077fc4c | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Mozambique | MOZ | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | FADM | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 23302 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
5c7df2f8-4da9-40f4-a990-e3ec7557755b | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Seychelles | SYC | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Seychelles Coast Guard | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 2 | 56010 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
40985355-4f48-45fa-857d-b743b039e1ee | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Fiji | FJI | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Fiji Navy Squadron, Republic of Fiji Military Forces | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 28315 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
fb946473-505a-4142-bf94-42ec14d3e638 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | DOHS/USCG - Fiscal Year 2017 Department of Homeland Security Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Custom and Excise Office, Sabang City | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 32946 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
717282cc-2482-43ba-aff3-7799a526b8c7 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | 8th Naval Base | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 28105 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
ab913f48-3f2f-4d61-9d9a-303845bbc52b | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Timika Naval Base | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 27913 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
9e8d4218-512d-40b3-b208-7f808ffaf971 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Malaysia | MYS | DOHS/USCG - Fiscal Year 2017 Department of Homeland Security Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | MALAYSIA MARITIME ENFORCEMENT AGENCY | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 29915 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
e87785ee-bde2-419c-9e01-eaf74a37eb07 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Malaysia | MYS | DOHS/USCG - Fiscal Year 2017 Department of Homeland Security Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Malaysian Maritime Enforcement Agency | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 29915 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
05ffeaab-6b61-4a1a-a346-209bf7b2c90e | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Papua-New Guinea | PNG | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Papua New Guinea Defence Force | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 21426 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
f98542a7-c536-41a1-895d-6a51efe84e3f | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | HQS MARINE ENVIRONMENTAL PROTECTION COMMAND, MARINE ENVIRONMENTAL RESEARCH DEVELOPMENT CENTER, PHIL COAST GUARD | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 27115 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
005207a7-aa38-40b7-ba50-bb902e27420d | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Samoa | WSM | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | MARITIME POLICE WING | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 30415 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
ae0443b2-179d-4306-aa2a-e02b5d77b772 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Tonga | TON | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | His Majesty's Armed Forces | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 28365 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
254aae2b-d287-45ea-b79c-e099837e1ae6 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Vietnam | VNM | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Vietnam People's Navy | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 2 | 45470 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
0825afde-88ad-4f98-ae85-f766e03e046f | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Tunisia | TUN | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | FAST MISSLE BOAT | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 28115 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
cfc28a13-946e-4bbd-a259-6e50439f5889 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_South_Central_Asia_fmtrpt.tsv | Maldives | MDV | DOHS/USCG - Fiscal Year 2017 Department of Homeland Security Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | MNDF | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 2 | 56430 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
23a6a180-29bf-4093-acbd-39a606914e0f | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_South_Central_Asia_fmtrpt.tsv | Maldives | MDV | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | MNDF | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 28215 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
9e20b07a-a210-4c9a-8f06-73365c0816cf | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_South_Central_Asia_fmtrpt.tsv | Sri Lanka | LKA | DOHS/USCG - Fiscal Year 2017 Department of Homeland Security Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | SLCG | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 2 | 56530 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
6581c52c-a1d7-440d-9b1b-457dbd255886 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Bahamas | BHS | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | ROYAL BAHAMAS DEFENCE FORCE | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 24415 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
86984983-a6cf-4779-a0da-8300f36e1cd7 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Barbados | BRB | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Barbados Coast Guard | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 26015 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
125324a4-5009-4f97-ac9d-e296f7d82e7f | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Dominica | DMA | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Dominica Coast Guard | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 27015 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
b71e4a8c-4c46-482f-a225-34b4b1029e54 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Dom Rep Navy | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 24615 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
67bbf765-ce80-433e-a889-f1ea038135b6 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | DR NAVY | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 24615 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
0f7b65f0-646a-4413-a4e3-3859e71a16f2 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Navy Patrol Fleet | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 24615 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
493b3715-d428-4333-a817-33ff32c41d4e | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | Port Captain Livingston | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 1 | 24615 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
b9eb4265-fc36-49d7-9f4d-65f7a97a2cc6 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | SEMAR | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 2 | 51230 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
755414ac-813d-4ec9-8766-bb9eb4422a29 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Mali | MLI | PKO - Fiscal Year 2017 Department of State Training | American Language Course General English Training Only | DLIELC, LACKLAND AFB TX | Ministry of Finance, Kati custom office | 8/15/2016 | 2016-08-15 | 12/2/2016 | 2016-12-02 | Lackland AFB, TX, US | 2 | 61486 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
97dd6796-1f02-4f20-a252-1e75a42838c7 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Mali | MLI | PKO - Fiscal Year 2017 Department of State Training | American Language Course General English Training Only | DLIELC, LACKLAND AFB TX | Ministry of Security, Police Human Ressources Directorate | 8/15/2016 | 2016-08-15 | 12/2/2016 | 2016-12-02 | Lackland AFB, TX, US | 1 | 30743 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
738e44d3-589d-43a6-b237-f2e27c61f045 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Mali | MLI | PKO - Fiscal Year 2017 Department of State Training | American Language Course General English Training Only | DLIELC, LACKLAND AFB TX | Police Div of Studies, and data processing, Bamako | 8/15/2016 | 2016-08-15 | 12/2/2016 | 2016-12-02 | Lackland AFB, TX, US | 1 | 30743 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
105c3ed4-0a8f-4b67-945c-ce5ffc1c9afb | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | IMET-1 - Fiscal Year 2017 Department of State Training | International Surface Warfare Officer School | SURFACE WARFARE OFFICERS SCHOOL COMMAND NEWPO | Lemadang 632 Indonesian Naval Ship | 8/15/2016 | 2016-08-15 | 12/2/2016 | 2016-12-02 | Newport, RI, US | 1 | 22628 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
2c862844-da22-4bfa-bd8c-e75d32cf4355 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - Fiscal Year 2017 Department of State Training | International Surface Warfare Officer School | SURFACE WARFARE OFFICERS SCHOOL COMMAND NEWPO | NAVAL EDUCATION AND TRAINING COMMAND, PHILIPPINE NAVY | 8/15/2016 | 2016-08-15 | 12/2/2016 | 2016-12-02 | Newport, RI, US | 1 | 26811 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
c5dda988-de0f-4d6f-8ca0-7a864653d11d | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Timor-Leste, Democratic Republic of | TLS | IMET-1 - Fiscal Year 2017 Department of State Training | International Surface Warfare Officer School | SURFACE WARFARE OFFICERS SCHOOL COMMAND NEWPO | Naval Component | 8/15/2016 | 2016-08-15 | 12/2/2016 | 2016-12-02 | Newport, RI, US | 1 | 23988 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
d817de78-1303-4875-a695-a95e01989881 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Europe_fmtrpt.tsv | Montenegro, Republic of | NME | IMET-1 - Fiscal Year 2017 Department of State Training | International Surface Warfare Officer School | SURFACE WARFARE OFFICERS SCHOOL COMMAND NEWPO | Department for Radio Telecommunication, Training Ship Jadran | 8/15/2016 | 2016-08-15 | 12/2/2016 | 2016-12-02 | Newport, RI, US | 1 | 25917 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
111d767b-6bc5-4982-b2ec-4fa0338e18d2 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - Fiscal Year 2017 Department of State Training | International Surface Warfare Officer School | SURFACE WARFARE OFFICERS SCHOOL COMMAND NEWPO | Fleet Command | 8/15/2016 | 2016-08-15 | 12/2/2016 | 2016-12-02 | Newport, RI, US | 1 | 29117 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
6427d4dc-ac89-44b7-973c-857c13b36fa9 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Peru | PER | FMF - Fiscal Year 2017 Department of State Training | International Surface Warfare Officer School | SURFACE WARFARE OFFICERS SCHOOL COMMAND NEWPO | NAVY | 8/15/2016 | 2016-08-15 | 12/2/2016 | 2016-12-02 | Newport, RI, US | 1 | 4385 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
569b8bb0-61f9-412c-b238-8ff9a5b70359 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | ASFF - Fiscal Year 2017 Department of Defense Training | C-130H2 Pilot INITL Qualification (Full Course: A/S + Flying) | ANG LITTLE ROCK AFB, AR | MOD | 8/2/2016 | 2016-08-02 | 12/2/2016 | 2016-12-02 | ANG LITTLE ROCK AFB, AR | 1 | 61882 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
e9947264-c6fe-498e-b72d-f0eb81ce89b8 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Mauritania | MRT | PKO - Fiscal Year 2017 Department of State Training | American Language Course General English Training Only | DLIELC, LACKLAND AFB TX | Air Transportation Base of Nouakchott | 7/18/2016 | 2016-07-18 | 12/2/2016 | 2016-12-02 | Lackland AFB, TX, US | 1 | 33005 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 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]);