training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
2 rows where training:country_iso_3166_1 = "MEX" and "training:start_date" is on date 2004-03-29 sorted by training:end_date
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 | |
50c0d32a-7782-48a0-8e77-74e716d6d5f8 | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY04 | SPECIALIZED ENG LANG TNG | Deputy Chief, A-2 (Intel), MAF Hqs, Mexico, D.F. | 3/29/2004 | 2004-03-29 | 5/28/2004 | 2004-05-28 | LACKLAND AFB, TX 78236 | 1 | 3210 | 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]);