training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
15 rows where "qa:training_date_first_seen" is on date 2018-08-15 and "training:end_date" is on date 2017-09-05 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
347c4b96-196f-496f-b000-0e7189c69451 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2017 Department of State Training | High Risk/Specialty Physical | DLIELC, LACKLAND AFB TX | SEPCIAL FORCES | 8/30/2017 | 2017-08-30 | 9/5/2017 | 2017-09-05 | Lackland AFB, TX, US | 1 | 1501 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
fd41b1eb-e810-4a29-8291-ee5e5562ccd6 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2017 Department of State Training | High Risk/Specialty Physical | DLIELC, LACKLAND AFB TX | SPECIAL FORCES | 8/30/2017 | 2017-08-30 | 9/5/2017 | 2017-09-05 | Lackland AFB, TX, US | 1 | 1501 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
14566665-e05c-4c32-9ae8-4a750f670032 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Niger | NER | CTFP - Fiscal Year 2017 Department of Defense Training | English Language Enhancement Course (ELEC) | MARSHALL CENTER | Niger Air Force Base 101 | 8/2/2017 | 2017-08-02 | 9/5/2017 | 2017-09-05 | Garmisch, GY | 1 | 20869 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
ac57d748-41d9-45a6-970e-f06aed4907c4 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Niger | NER | Regional Centers - Fiscal Year 2017 Department of Defense Training | English Language Enhancement Course (ELEC) | GCMC | Niger Army | 8/2/2017 | 2017-08-02 | 9/5/2017 | 2017-09-05 | George C. Marshall European Center for Security Studies, Garmisch-Partenkirchen, Germany | 1 | 13134 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
2c5f5af2-ab87-441f-b867-e8e4a1015a4d | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | Regional Centers - Fiscal Year 2017 Department of Defense Training | English Language Enhancement Course (ELEC) | GCMC | Department of Defence | 8/2/2017 | 2017-08-02 | 9/5/2017 | 2017-09-05 | George C. Marshall European Center for Security Studies, Garmisch-Partenkirchen, Germany | 1 | 12034 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
a78e3920-f71b-4131-964f-792035deca95 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Europe_fmtrpt.tsv | Bosnia & Herzegovina | BIH | Regional Centers - Fiscal Year 2017 Department of Defense Training | English Language Enhancement Course (ELEC) | GCMC | Bosnia and Herzegovina Ministry of Interior | 8/2/2017 | 2017-08-02 | 9/5/2017 | 2017-09-05 | George C. Marshall European Center for Security Studies, Garmisch-Partenkirchen, Germany | 1 | 10034 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
e238bccd-bf86-47f8-adba-36d18e29837f | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Europe_fmtrpt.tsv | Moldova | MDA | Regional Centers - Fiscal Year 2017 Department of Defense Training | English Language Enhancement Course (ELEC) | GCMC | Moldova Ministry of Internal Affairs | 8/2/2017 | 2017-08-02 | 9/5/2017 | 2017-09-05 | George C. Marshall European Center for Security Studies, Garmisch-Partenkirchen, Germany | 1 | 10234 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
42bf77a0-1490-41c7-8ee7-e7b57c151cbd | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Europe_fmtrpt.tsv | Moldova | MDA | Regional Centers - Fiscal Year 2017 Department of Defense Training | English Language Enhancement Course (ELEC) | GCMC | Moldova Parliament | 8/2/2017 | 2017-08-02 | 9/5/2017 | 2017-09-05 | George C. Marshall European Center for Security Studies, Garmisch-Partenkirchen, Germany | 1 | 10234 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
ae5844a0-3988-433b-9c32-6be001b81077 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Europe_fmtrpt.tsv | Serbia, Republic of | SRB | Regional Centers - Fiscal Year 2017 Department of Defense Training | English Language Enhancement Course (ELEC) | GCMC | Serbia Ministry of Interior | 8/2/2017 | 2017-08-02 | 9/5/2017 | 2017-09-05 | George C. Marshall European Center for Security Studies, Garmisch-Partenkirchen, Germany | 1 | 9934 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
640d93fd-3a03-4395-9bbb-5dc205b3c0b7 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Jordan | JOR | CTFP - Fiscal Year 2017 Department of Defense Training | English Language Enhancement Course (ELEC) | MARSHALL CENTER | DIRECTORATE OF MILITARY JUDICIARY | 8/2/2017 | 2017-08-02 | 9/5/2017 | 2017-09-05 | Garmisch, GY | 1 | 20869 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
60e1c1fd-3ef4-4b30-8a1a-35b852557dd6 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Lebanon | LBN | CTFP - Fiscal Year 2017 Department of Defense Training | English Language Enhancement Course (ELEC) | MARSHALL CENTER | North Region Military Command | 8/2/2017 | 2017-08-02 | 9/5/2017 | 2017-09-05 | Garmisch, GY | 1 | 20869 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
b2157c6d-484e-4696-b5c1-a9bcfac7d83f | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Morocco | MAR | CTFP - Fiscal Year 2017 Department of Defense Training | English Language Enhancement Course (ELEC) | MARSHALL CENTER | DGSN. HQ- Rabat | 8/2/2017 | 2017-08-02 | 9/5/2017 | 2017-09-05 | Garmisch, GY | 1 | 20869 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
3d20fcd1-c7c9-4ffd-81d8-561e82cb6595 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Tunisia | TUN | Regional Centers - Fiscal Year 2017 Department of Defense Training | English Language Enhancement Course (ELEC) | GCMC | Tunisia Ministry of National Defense | 8/2/2017 | 2017-08-02 | 9/5/2017 | 2017-09-05 | George C. Marshall European Center for Security Studies, Garmisch-Partenkirchen, Germany | 1 | 10334 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
0a177b8b-e765-48d4-b7ee-4b12c86d0730 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Mongolia | MNG | IMET-1 - Fiscal Year 2017 Department of State Training | ALPS III/TOEFL | DLIELC, LACKLAND AFB TX | General Staff of Mongolian Armed Forces | 5/22/2017 | 2017-05-22 | 9/5/2017 | 2017-09-05 | Lackland AFB, TX, US | 1 | 16929 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
802a9577-8cf4-4386-a866-0d189d603207 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Mongolia | MNG | IMET-1 - Fiscal Year 2017 Department of State Training | ALPS III/TOEFL | DLIELC, LACKLAND AFB TX | J3, General Staff of Armed Forces of Mongolia | 5/22/2017 | 2017-05-22 | 9/5/2017 | 2017-09-05 | Lackland AFB, TX, US | 1 | 19629 | 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]);