training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
1 row where training:country_iso_3166_1 = "MEX" and "training:end_date" is on date 2004-04-07 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2fc2516a-ce97-4212-b1c6-7ceadecf3046 | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY04 | HOSPTL FOCUSED RSPN TO BIO | HOSNAVACA HOSNAVCAMP HOSNAVCHET HOSNAVGUAY HOSNAVMANZ HOSNAVSALC HOSNAVTAMP HOSNAVTLAN HOSNAVVER HOSP.NAV.ACAP. I.O.P. INST. LOGIS. MINA NAVMAN PEMEX, CAMP. RENACE SANAFRONT SANAUROS SANAVBLAS. SANAVCARD. SANAVCARM SANAVCHAMP SANAVCHAMP SANAVCOAT SANAVCOZ SANAVENS. SANAVFRONT SANAVLLARTA SANAVMAND SANAVMAT SANAVMJ SANAVMUJ SANAVPAZ SANAVPEN. SANAVTOP SANAVTUX SANAVUK SANAVYUK USUMANCINTA ZAPOTECO | 3/29/2004 | 2004-03-29 | 4/7/2004 | 2004-04-07 | VARIOUS | 318 | 18743 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 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]);