training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
5 rows where "training:end_date" is on date 2003-02-16 sorted by training:status:admin
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
e2a48fe3-5326-4ca9-9d34-9ed5c30d6254 | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | DOS Western Hemisphere Region, Guatemala, International Military Education and Training (IMET),FY03 | MET CIV-MILITARY RELATIONS | 21 Military from different Units within the MOD (Chief of Staff Office, Joint Command and Military Zones). 21 Civilians from different organizations such as the Defense Policy Committee, San Carlos University, Secretariat of Strategic Analysis for the President (SAE), Secretariat for the Peace (SEPAZ), WSP International, Institute of Education for Long Term Development (IEPADES), De-Mining Program of Guatemala (AICMA), Association for the Investigation and Social Studies (ASIES), Democratic Incidence. | 2/12/2003 | 2003-02-12 | 2/16/2003 | 2003-02-16 | 42 | 38366 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 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]);