training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
69 rows where "qa:training_date_scraped" is on date 2019-12-06 and "training:start_date" is on date 2018-02-12 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2a7eb34c-a72d-4037-94bc-fd53eaef849e | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Angola | AGO | IMET-1 - Fiscal Year 2018 Department of State Training | American Language Course General English Training Only | DLIELC, Lackland AFB TX | Angola Air Force | 2/12/2018 | 2018-02-12 | 5/25/2018 | 2018-05-25 | Lackland AFB, TX, US | 1 | 29876 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
863b452e-ff91-4f48-9cb3-39d37dbef37f | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Benin | BEN | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Management Course | Defense Resources Management Institute NPS MO | Military | 2/12/2018 | 2018-02-12 | 4/19/2018 | 2018-04-19 | Monterey, CA, US | 2 | 77952 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
c4ba4487-4168-4ecf-9864-b457c58cad9f | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Benin | BEN | PKO - Fiscal Year 2018 Department of State Training | Combat Lifesavers (CLS) Training | N/A | FAB MINUSMA 6 | 2/12/2018 | 2018-02-12 | 2/16/2018 | 2018-02-16 | Cana Training Center, Cana, BENIN | 30 | 5547 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
9ee0a10d-5644-4655-816a-e67ef7bb9582 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Benin | BEN | PKO - Fiscal Year 2018 Department of State Training | GPOI PKO Protection of Civilians in Armed Conflicts | US AFRICOM | Benin Army | 2/12/2018 | 2018-02-12 | 2/21/2018 | 2018-02-21 | Accra, GH | 1 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
70c50173-2d02-48af-bef8-bae3041d1e02 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Benin | BEN | PKO - Fiscal Year 2018 Department of State Training | Protection of Civilians Training | N/A | N/A | 2/12/2018 | 2018-02-12 | 2/21/2018 | 2018-02-21 | Kofi Annan International Peacekeeping Training Centre, Accra, GHANA | 4 | 9999 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
8c844333-7a0e-4336-9de7-e723731d51ea | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Burkina Faso | BFA | PKO - Fiscal Year 2018 Department of State Training | Protection of Civilians Training | N/A | N/A | 2/12/2018 | 2018-02-12 | 2/21/2018 | 2018-02-21 | Kofi Annan International Peacekeeping Training Centre, Accra, GHANA | 2 | 4999 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
d4c4df9c-6ae7-415f-a3a0-0e0c3a26e73e | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Cameroon | CMR | PKO - Fiscal Year 2018 Department of State Training | Protection of Civilians Training | N/A | N/A | 2/12/2018 | 2018-02-12 | 2/21/2018 | 2018-02-21 | Kofi Annan International Peacekeeping Training Centre, Accra, GHANA | 1 | 2500 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
d5bd306f-e6af-4a77-91e3-cb8324cefcba | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Djibouti | DJI | IMET-1 - Fiscal Year 2018 Department of State Training | American Language Course General English Training Only | DLIELC, Lackland AFB TX | Djibouti Navy | 2/12/2018 | 2018-02-12 | 5/11/2018 | 2018-05-11 | Lackland AFB, TX, US | 1 | 30206 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
b2219aa7-0c00-491f-8a92-b4c6dd83f7cc | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Djibouti | DJI | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Management Course | Defense Resources Management Institute NPS MO | Djibouti Navy-Special Operations Department | 2/12/2018 | 2018-02-12 | 4/19/2018 | 2018-04-19 | Monterey, CA, US | 1 | 52498 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
3027664f-5a1c-4b49-9e3b-672f76888650 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Ethiopia | ETH | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Management Course | Defense Resources Management Institute NPS MO | ENDF Command And Staff College | 2/12/2018 | 2018-02-12 | 4/19/2018 | 2018-04-19 | Monterey, CA, US | 1 | 38676 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
a9a52eb9-bc05-4c5e-8fe7-7c7f532a3311 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Gabon | GAB | PKO - Fiscal Year 2018 Department of State Training | MLE IDC | COGARD International Training DET Tracen Yorktown VA | Gabonese Armed Forces, Navy,Ogooue Maritime District, Ogooue-Maritime Province, Port-Gentil City | 2/12/2018 | 2018-02-12 | 2/23/2018 | 2018-02-23 | Yorktown, VA, US | 13 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
3fd7fe2f-190c-4b04-b2d9-2a1c0eca811f | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2018 Department of State Training | Instructor Writer Course | N/A | N/A | 2/12/2018 | 2018-02-12 | 3/9/2018 | 2018-03-09 | Burma Camp, Accra, GHANA | 34 | 139954 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
f9aecf6e-ea5e-4358-a7ea-a8f524812d20 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2018 Department of State Training | Protection of Civilians Training | N/A | N/A | 2/12/2018 | 2018-02-12 | 2/21/2018 | 2018-02-21 | Kofi Annan International Peacekeeping Training Centre, Accra, GHANA | 5 | 12499 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
a5a470d1-06e7-49dd-b15e-a3d70c929cd2 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Mali | MLI | IMET-X - Fiscal Year 2018 Department of State Training | American Language Course General English Training Only | DLIELC, Lackland AFB TX | GTB-GMM | 2/12/2018 | 2018-02-12 | 5/4/2018 | 2018-05-04 | Lackland AFB, TX, US | 1 | 26958 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
dec37ba6-6627-463c-b17a-36f2616b58ab | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Mauritania | MRT | PKO - Fiscal Year 2018 Department of State Training | Cessna-208 Maintenance Support | 818 MSAS - 22 | Mauritanian Air Force | 2/12/2018 | 2018-02-12 | 3/2/2018 | 2018-03-02 | Nouakchott, MR | 12 | 183406 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
3b0206a9-1bcf-481b-88ea-e60e23b05452 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Mauritania | MRT | PKO - Fiscal Year 2018 Department of State Training | Protection of Civilians Training | N/A | N/A | 2/12/2018 | 2018-02-12 | 2/21/2018 | 2018-02-21 | Kofi Annan International Peacekeeping Training Centre, Accra, GHANA | 2 | 5000 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
1453b90a-43f9-4d12-a129-ba99c6ed05ae | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Niger | NER | IMET-X - Fiscal Year 2018 Department of State Training | American Language Course GET And SET | DLIELC, Lackland AFB TX | Defense Health Directorate | 2/12/2018 | 2018-02-12 | 4/13/2018 | 2018-04-13 | Lackland AFB, TX, US | 1 | 25084 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
772858a6-8681-4d5c-9434-7f8834e69802 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Nigeria | NGA | PKO - Fiscal Year 2018 Department of State Training | Protection of Civilians Training | N/A | N/A | 2/12/2018 | 2018-02-12 | 2/21/2018 | 2018-02-21 | Kofi Annan International Peacekeeping Training Centre, Accra, GHANA | 4 | 9999 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
9a07b3c8-95b8-4071-8487-0f723cb19b6a | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Rwanda | RWA | PKO - Fiscal Year 2018 Department of State Training | Field Medical/Combat Lifesavers (CLS) Training | N/A | N/A | 2/12/2018 | 2018-02-12 | 3/2/2018 | 2018-03-02 | GAKO PSOTC, Gako, RWANDA | 42 | 71369 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
a9d461ee-11f2-4045-aee7-9afa0a3f9811 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Rwanda | RWA | PKO - Fiscal Year 2018 Department of State Training | USIP Training | N/A | N/A | 2/12/2018 | 2018-02-12 | 2/16/2018 | 2018-02-16 | GAKO PSOTC, Gako, RWANDA | 29 | 29999 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
c0ab88a3-fbd5-43a3-be8f-e64e8ee6c87f | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Senegal | SEN | CTFP - Fiscal Year 2018 Department of Defense Training | International Anti-Terrorism/Anti Piracy (IATP) | NITC, NAS Pensacola, FL | Navy Headquarters | 2/12/2018 | 2018-02-12 | 3/16/2018 | 2018-03-16 | Pensacola, FL, US | 1 | 14095 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
dd667fb0-3bd1-494e-a85e-303cd2203890 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Senegal | SEN | IMET-1 - Fiscal Year 2018 Department of State Training | American Language Course GET And SET | DLIELC, Lackland AFB TX | Maintenance Support BN | 2/12/2018 | 2018-02-12 | 5/4/2018 | 2018-05-04 | Lackland AFB, TX, US | 1 | 24128 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
4a0e7c8d-1f9a-447a-bb98-db0a09b6d2d3 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Senegal | SEN | PKO - Fiscal Year 2018 Department of State Training | Protection of Civilians Training | N/A | N/A | 2/12/2018 | 2018-02-12 | 2/21/2018 | 2018-02-21 | Kofi Annan International Peacekeeping Training Centre, Accra, GHANA | 7 | 17498 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
f4c9e655-9fb4-4f60-bbdb-6242ee1ac093 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Sierra Leone | SLE | PKO - Fiscal Year 2018 Department of State Training | Protection of Civilians Training | N/A | N/A | 2/12/2018 | 2018-02-12 | 2/21/2018 | 2018-02-21 | Kofi Annan International Peacekeeping Training Centre, Accra, GHANA | 3 | 7499 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
97eaa16d-7183-4905-85cb-d7379610efd7 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | South Africa | ZAF | PKO - Fiscal Year 2018 Department of State Training | Protection of Civilians Training | N/A | N/A | 2/12/2018 | 2018-02-12 | 2/21/2018 | 2018-02-21 | Kofi Annan International Peacekeeping Training Centre, Accra, GHANA | 1 | 2500 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
c775c792-b67d-46d5-ae96-5de47b5765a4 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Togo | TGO | Misc DoD/DoS Non-SA - Fiscal Year 2018 Department of Defense Training | Construction Equipment and Generator Repair training | North Dakota National Guard - 18 | Army | 2/12/2018 | 2018-02-12 | 2/16/2018 | 2018-02-16 | Lomé, TO | 14 | 99780 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
eef7cb7f-655a-40d0-8dd4-3f91e3717d70 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Togo | TGO | Misc DoD/DoS Non-SA - Fiscal Year 2018 Department of Defense Training | Construction Equipment and Generator Repair training | North Dakota National Guard - 6 | Navy | 2/12/2018 | 2018-02-12 | 2/16/2018 | 2018-02-16 | Lomé, TO | 2 | 33260 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
3a0783d4-d6c8-4c7b-803b-d27ee1bf6bf7 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Uganda | UGA | PKO - Fiscal Year 2018 Department of State Training | Command Staff and Operational Skills/CPX | N/A | UNGU 5 | 2/12/2018 | 2018-02-12 | 2/23/2018 | 2018-02-23 | Singo Peacekeeping Center, Kampala, UGANDA | 42 | 28476 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
0b7f0b6a-2b4c-42e9-bee9-6789517b2340 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Uganda | UGA | PKO - Fiscal Year 2018 Department of State Training | Protection of Civilians Training | N/A | N/A | 2/12/2018 | 2018-02-12 | 2/21/2018 | 2018-02-21 | Kofi Annan International Peacekeeping Training Centre, Accra, GHANA | 3 | 7499 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
ac8ca9e2-c0a2-4d2b-b77d-695baee9df6d | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | FMF - Fiscal Year 2018 Department of State Training | ALC Specialized English Training Only | DLIELC, Lackland AFB TX | Indonesian Air Force/Suryadarma Air Force Base | 2/12/2018 | 2018-02-12 | 4/13/2018 | 2018-04-13 | Lackland AFB, TX, US | 1 | 20104 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
659251fb-cd16-4ec8-88a5-de23c5445bb3 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | FMF - Fiscal Year 2018 Department of State Training | ALC Specialized English Training Only | DLIELC, Lackland AFB TX | Indonesian Armed Forces/Iswahyudi Air Force Base | 2/12/2018 | 2018-02-12 | 4/13/2018 | 2018-04-13 | Lackland AFB, TX, US | 1 | 20104 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
7c5c24c2-65f4-4f91-b408-2cf857a2563f | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | IMET-1 - Fiscal Year 2018 Department of State Training | Adjutant General Captains Career | Adjutant General School | Indonesian Army | 2/12/2018 | 2018-02-12 | 7/3/2018 | 2018-07-03 | Ft. Jackson, SC, US | 1 | 36007 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
c346851f-72b2-4062-a6d5-0da9320371da | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Laos | LAO | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Management Course | Defense Resources Management Institute NPS MO | General Logistic Department / Ministry Of National Defense | 2/12/2018 | 2018-02-12 | 4/19/2018 | 2018-04-19 | Monterey, CA, US | 1 | 44848 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
f585a1cf-be7c-429b-b5c5-6d0668ff0700 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Laos | LAO | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Management Course | Defense Resources Management Institute NPS MO | General Staff Department / Ministry Of National Defense | 2/12/2018 | 2018-02-12 | 4/19/2018 | 2018-04-19 | Monterey, CA, US | 1 | 44848 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
4f8d7f55-50cc-4f64-9db6-9ff8a5200915 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | Section 333 - Fiscal Year 2018 Department of Defense Training | MTT DIILS OCONUS Human Rights | Philippines (In Country Training) | 300TH AISG, PAF | 2/12/2018 | 2018-02-12 | 2/13/2018 | 2018-02-13 | Philippines (In Country Training) | 15 | 22580 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
699fc0b6-e550-4554-8833-e1e31b792a75 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | Section 333 - Fiscal Year 2018 Department of Defense Training | MTT DIILS OCONUS Human Rights | Philippines (In Country Training) | JSOG, AFP | 2/12/2018 | 2018-02-12 | 2/13/2018 | 2018-02-13 | Philippines (In Country Training) | 10 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
85f781cf-adbb-40e5-a452-83514416d73f | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | Section 333 - Fiscal Year 2018 Department of Defense Training | SCANEAGLE Maintainer Training | INSITU Group, INC | Armed Forces Of the Philippines Joint Special Operations Group | 2/12/2018 | 2018-02-12 | 3/16/2018 | 2018-03-16 | Bingen, WA, US | 2 | 20800 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
713097cb-e228-46ef-b581-3d2af266aed7 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Europe_fmtrpt.tsv | Georgia | GEO | IMET-1 - Fiscal Year 2018 Department of State Training | American Language Course General English Training Only | DLIELC, Lackland AFB TX | Georgia National Guard | 2/12/2018 | 2018-02-12 | 5/4/2018 | 2018-05-04 | Lackland AFB, TX, US | 1 | 28423 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
ea0b3d96-1e6b-4a54-96f0-a86496e71451 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Europe_fmtrpt.tsv | Kosovo | XKX | IMET-1 - Fiscal Year 2018 Department of State Training | Adjutant General Captains Career | Adjutant General School | TRADOC, KSF | 2/12/2018 | 2018-02-12 | 7/3/2018 | 2018-07-03 | Ft. Jackson, SC, US | 1 | 36327 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
cb10aa6d-4b8d-4217-8723-133cd7c8f95f | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Management Course | Defense Resources Management Institute NPS MO | J8 Financial Management, General Staff | 2/12/2018 | 2018-02-12 | 4/19/2018 | 2018-04-19 | Monterey, CA, US | 1 | 42498 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
129bf326-405b-4e6d-8b08-b60b47fdc9ed | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Europe_fmtrpt.tsv | Ukraine | UKR | FMF - Fiscal Year 2018 Department of State Training | International Defense Management Course | Defense Resources Management Institute NPS MO | A0304 Air Force HQ | 2/12/2018 | 2018-02-12 | 4/19/2018 | 2018-04-19 | Monterey, CA, US | 1 | 43048 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
51fae505-d5f7-4a12-9040-fa3cb13102fc | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2018 Department of State Training | Adjutant General Captains Career | Adjutant General School | Officers' Affairs | 2/12/2018 | 2018-02-12 | 7/3/2018 | 2018-07-03 | Ft. Jackson, SC, US | 1 | 34128 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
6b225766-4ad3-40b0-b480-0d4abc059d84 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2018 Department of State Training | International Defense Management Course | Defense Resources Management Institute NPS MO | Air Defense | 2/12/2018 | 2018-02-12 | 4/19/2018 | 2018-04-19 | Monterey, CA, US | 1 | 41898 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
619df3c8-cacd-43cc-985c-6744eebe887b | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2018 Department of State Training | NITC EOD PREP | NITC, NAS Pensacola, FL | Military Engineers | 2/12/2018 | 2018-02-12 | 3/2/2018 | 2018-03-02 | Pensacola, FL, US | 2 | 9538 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
763027b0-e938-4eeb-befa-a57ccc0a0251 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Iraq | IRQ | FMF - Fiscal Year 2018 Department of State Training | ALC Specialized English Training Only | DLIELC, Lackland AFB TX | MOD - Army Aviation Command - TAJI AB | 2/12/2018 | 2018-02-12 | 3/30/2018 | 2018-03-30 | Lackland AFB, TX, US | 1 | 20151 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
df0f5523-2fff-4908-ad51-13d1306dddf3 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Iraq | IRQ | FMF - Fiscal Year 2018 Department of State Training | American Language Course GET And SET | DLIELC, Lackland AFB TX | MOD - Army Aviation Command - TAJI AB/ Pilot Officer | 2/12/2018 | 2018-02-12 | 5/25/2018 | 2018-05-25 | Lackland AFB, TX, US | 1 | 29061 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
e82c0b4d-8b5a-48ef-a338-2b9d0b920264 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2018 Department of State Training | Adjutant General Captains Career | Adjutant General School | 2ND King Abdallah Group SPICAIL Forces | 2/12/2018 | 2018-02-12 | 7/3/2018 | 2018-07-03 | Ft. Jackson, SC, US | 1 | 34343 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
2e317667-a3fd-4d80-9728-a37c676e2fac | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2018 Department of State Training | ALC Specialized English Training Only | DLIELC, Lackland AFB TX | Communications Directorate | 2/12/2018 | 2018-02-12 | 4/13/2018 | 2018-04-13 | Lackland AFB, TX, US | 1 | 18404 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
ef74b153-0ea9-4437-a2b6-746b9ac3801b | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2018 Department of State Training | ALC Specialized English Training Only | DLIELC, Lackland AFB TX | Maintenance Directorate | 2/12/2018 | 2018-02-12 | 4/13/2018 | 2018-04-13 | Lackland AFB, TX, US | 2 | 35890 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
d5cdabfb-622c-40b9-ae3f-58cde2af5a00 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2018 Department of State Training | IERW UH-60 Track - All | Aviation School | Air Operations Directorate | 2/12/2018 | 2018-02-12 | 5/21/2018 | 2018-05-21 | Ft. Rucker, AL, US | 1 | 221757 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
a6709a3b-f3dd-4c56-9c1e-d23adb1624a4 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2018 Department of State Training | Tracked Vehicle Repairer (W/O FTX) | Ordnance Munitions & Electronics School | Royal Maintenance Corps | 2/12/2018 | 2018-02-12 | 4/16/2018 | 2018-04-16 | Ft. Lee, VA, US | 1 | 16107 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
ade49198-006e-4779-921a-8b3bcecc9a0f | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2018 Department of State Training | UH-60 (UH-60A/L) Flight Simulator | Eastern Aviation Training Site | Air Operations Directorate | 2/12/2018 | 2018-02-12 | 2/16/2018 | 2018-02-16 | Annville, PA, US | 2 | 15330 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
729b9e59-187f-48a1-ab5d-929d6f1faf8c | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2018 Department of State Training | UH-60M Simulator | Eastern Aviation Training Site | Air Operation Directorate | 2/12/2018 | 2018-02-12 | 2/16/2018 | 2018-02-16 | Annville, PA, US | 1 | 7860 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
74645066-5518-4624-a753-7cf1a49eb84f | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2018 Department of State Training | UH-60M Simulator | Eastern Aviation Training Site | Air Operations Directorate | 2/12/2018 | 2018-02-12 | 2/16/2018 | 2018-02-16 | Annville, PA, US | 1 | 7635 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
0af3c8f8-06f8-46cb-be24-d30bd0edfa1d | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2018 Department of State Training | ALC Specialized English Training Only | DLIELC, Lackland AFB TX | Command And Control Directorate | 2/12/2018 | 2018-02-12 | 3/30/2018 | 2018-03-30 | Lackland AFB, TX, US | 1 | 17217 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
11c317bd-ee78-4509-87c4-f5d90104dcb8 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2018 Department of State Training | American Language Course General English Training Only | DLIELC, Lackland AFB TX | Command And Control Directorate | 2/12/2018 | 2018-02-12 | 3/30/2018 | 2018-03-30 | Lackland AFB, TX, US | 1 | 15369 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
139eee34-27e3-4b39-95ec-403a6d9319d7 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2018 Department of State Training | Information Technology Fundamentals (ITF) | Keesler AFB, MS | Electro Communications Directorate | 2/12/2018 | 2018-02-12 | 2/22/2018 | 2018-02-22 | Keesler AFB, MS, US | 1 | 6067 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
6a72a32c-b7d3-4192-bb62-29f922d5d14d | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - Fiscal Year 2018 Department of State Training | Ranger Recycle Training (MCOE IMSO) | Armor School | Special Forces School | 2/12/2018 | 2018-02-12 | 3/23/2018 | 2018-03-23 | Ft. Benning, GA, US | 1 | 6458 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
6219c250-4770-41cd-9680-9acc30824826 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Management Course | Defense Resources Management Institute NPS MO | G4 - Equipment | 2/12/2018 | 2018-02-12 | 4/19/2018 | 2018-04-19 | Monterey, CA, US | 1 | 43048 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
78c1d72e-9ad0-440d-9b08-fa16a6e5b920 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Management Course | Defense Resources Management Institute NPS MO | Military Housing | 2/12/2018 | 2018-02-12 | 4/19/2018 | 2018-04-19 | Monterey, CA, US | 1 | 42711 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
ec894f09-2e8b-4d65-9498-b89ff6dd23e1 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Morocco | MAR | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Management Course | Defense Resources Management Institute NPS MO | ADMIN Department- MOD HQ- Rabat | 2/12/2018 | 2018-02-12 | 4/19/2018 | 2018-04-19 | Monterey, CA, US | 1 | 38476 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
26ee7bdb-e43b-44d2-b1bd-888902affca6 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Tunisia | TUN | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Management Course | Defense Resources Management Institute NPS MO | Cabinet Of Minister Of Defense | 2/12/2018 | 2018-02-12 | 4/19/2018 | 2018-04-19 | Monterey, CA, US | 1 | 44048 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
08731f6d-5091-4472-88b8-3aadd827410b | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | ASFF - Fiscal Year 2018 Department of Defense Training | High Risk/Specialty Physical | DLIELC, Lackland AFB TX | AAF/TAAC-Air | 2/12/2018 | 2018-02-12 | 2/16/2018 | 2018-02-16 | Lackland AFB, TX, US | 1 | 1530 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
b5aed2fd-e323-44d9-94fb-4643fac184ac | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_South_Central_Asia_fmtrpt.tsv | Kazakhstan, Republic Of | KAZ | FMF - Fiscal Year 2018 Department of State Training | American Language Course GET And SET | DLIELC, Lackland AFB TX | Section Chief, Information Analysis Department, Ministry Of Defense | 2/12/2018 | 2018-02-12 | 5/25/2018 | 2018-05-25 | Lackland AFB, TX, US | 1 | 29326 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
535d9b17-bd9c-45d7-a50f-91116616b8b9 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | IMET-1 - Fiscal Year 2018 Department of State Training | Senior Enlisted Advisor | Western HEMIS Institute For Security COOP | 6th Communication Battalion, 8th Motorized Infantry Brigade, Southern Military Command | 2/12/2018 | 2018-02-12 | 4/26/2018 | 2018-04-26 | Ft. Benning, GA, US | 1 | 2191 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
b84a31e9-ce96-4e01-9b79-152add00b5df | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Chile | RCH | IMET-1 - Fiscal Year 2018 Department of State Training | Senior Enlisted Advisor | Western HEMIS Institute For Security COOP | Special Operations LAUTARO | 2/12/2018 | 2018-02-12 | 4/26/2018 | 2018-04-26 | Ft. Benning, GA, US | 1 | 2191 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
2e3de1cc-e2a6-40bb-959f-7a236e800925 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2018 Department of State Training | Senior Enlisted Advisor | Western HEMIS Institute For Security COOP | JEDHU | 2/12/2018 | 2018-02-12 | 4/26/2018 | 2018-04-26 | Ft. Benning, GA, US | 3 | 39339 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
0124cae5-47c4-412c-bfa7-1366b72eb1b9 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - Fiscal Year 2018 Department of State Training | Senior Enlisted Advisor | Western HEMIS Institute For Security COOP | Adolfo V. Hall Institue | 2/12/2018 | 2018-02-12 | 4/26/2018 | 2018-04-26 | Ft. Benning, GA, US | 1 | 12413 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
ac472593-58a6-4de7-b374-dfe3c8baf6eb | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - Fiscal Year 2018 Department of State Training | Senior Enlisted Advisor | Western HEMIS Institute For Security COOP | Army General Assistance Service | 2/12/2018 | 2018-02-12 | 4/26/2018 | 2018-04-26 | Ft. Benning, GA, US | 1 | 12413 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
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]);