training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
7 rows where "training:end_date" is on date 2002-09-21 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
e3b091e7-f421-4b5b-ac13-fb59795fdd4d | 048fb2d9-6651-4ba0-b36a-a526539f4cfd | 2002_2003_Europe_fmtrpt.tsv | Albania | ALB | Europe Region, Albania, International Military Education and Training (IMET), FY 02 | ENGLISH LANGUAGE SURVEY | Ministry of Defense meeting with the Minister, Human resouces director, General staff: J-5, J-3 Directors; Visiting Commando Brigade , Training-Doc Command, Foreign Language and Civilian Protection base directors and their staffs (all located in Tirana). Meeting with stering group at MoD (8 people) and SIAC contractors (2). In total they met 35 people. | 9/14/02 | 2002-09-14 | 9/21/02 | 2002-09-21 | Albania | 0 | 7127 | https://2009-2017.state.gov/documents/organization/21819.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
fc19bfb3-75cd-4edf-8536-aae848bf4ff3 | 048fb2d9-6651-4ba0-b36a-a526539f4cfd | 2002_2003_Western_Hemisphere_fmtrpt.tsv | Bolivia | BOL | Western Hemisphere Region, Bolivia, PME Exchanges, FY 02 | MET PEACE SUP OPS PH III | BL Army Special Operations / PKO School, Sanandita; BL Army; BL Navy; BL Air Force and BL Joint Chief of Staff | 9/9/02 | 2002-09-09 | 9/21/02 | 2002-09-21 | La Paz, Bolivia | 40 | 83610 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 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]);