training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
16 rows where "qa:training_date_first_seen" is on date -4707-05-30 and "training:start_date" is on date 2013-09-24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2938ae5e-c474-4bfc-89e2-5627d830f8a7 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv | Mongolia | MNG | Regional Centers - Fiscal Year 2013 Department of Defense Training | Partnering with Afghanistan | N/A | 9/24/2013 | 2013-09-24 | 9/26/2013 | 2013-09-26 | Garmisch, Germany | 2 | 4492 | https://2009-2017.state.gov/documents/organization/230211.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 | |
7327af31-9f16-4dc5-9d4a-b975122fbb80 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | United Arab Emirates | ARE | Regional Centers - Fiscal Year 2013 Department of Defense Training | UAE NDC Course 2013-2014 | N/A | 9/24/2013 | 2013-09-24 | 9/27/2013 | 2013-09-27 | 1 | 0 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 | ||
52063168-41c9-40d0-b10f-d78d7687cf61 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | United Arab Emirates | ARE | Regional Centers - Fiscal Year 2013 Department of Defense Training | UAE NDC Course 2013-2014 | N/A | UAE National Defense College | 9/24/2013 | 2013-09-24 | 9/27/2013 | 2013-09-27 | 29 | 0 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 | |
a25f4068-64d4-4dd8-9075-c02caff32633 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | Regional Centers - Fiscal Year 2013 Department of Defense Training | Partnering with Afghanistan | N/A | Afghan Institute for Strategic Studies | 9/24/2013 | 2013-09-24 | 9/26/2013 | 2013-09-26 | Garmisch, Germany | 1 | 2246 | https://2009-2017.state.gov/documents/organization/230217.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
8346e175-7a11-4470-8d17-7baf86fca9ba | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | Regional Centers - Fiscal Year 2013 Department of Defense Training | Partnering with Afghanistan | N/A | Afghanistan Chamber of Commerce & Industry | 9/24/2013 | 2013-09-24 | 9/26/2013 | 2013-09-26 | Garmisch, Germany | 1 | 2246 | https://2009-2017.state.gov/documents/organization/230217.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
4ef067e2-d757-4c8c-9292-22b25e8f49bf | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | Regional Centers - Fiscal Year 2013 Department of Defense Training | Partnering with Afghanistan | N/A | Embassy of Afghanistan in New Delhi, India | 9/24/2013 | 2013-09-24 | 9/26/2013 | 2013-09-26 | Garmisch, Germany | 1 | 2246 | https://2009-2017.state.gov/documents/organization/230217.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
ade95ce2-799a-4220-af77-0805b61271e7 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | Regional Centers - Fiscal Year 2013 Department of Defense Training | Partnering with Afghanistan | N/A | Tadbeer Consulting, Inc. | 9/24/2013 | 2013-09-24 | 9/26/2013 | 2013-09-26 | Garmisch, Germany | 1 | 2246 | https://2009-2017.state.gov/documents/organization/230217.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
f996335f-df0a-4c02-b1c4-89e6a0fad8ae | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_South_Central_Asia_fmtrpt.tsv | Kazakhstan | KAZ | Regional Centers - Fiscal Year 2013 Department of Defense Training | Partnering with Afghanistan | N/A | 9/24/2013 | 2013-09-24 | 9/26/2013 | 2013-09-26 | Garmisch, Germany | 2 | 4492 | https://2009-2017.state.gov/documents/organization/230217.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 | |
48c3c6a6-4911-43fb-9260-94c0be5d6443 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_South_Central_Asia_fmtrpt.tsv | Kazakhstan | KAZ | Regional Centers - Fiscal Year 2013 Department of Defense Training | Partnering with Afghanistan | N/A | Kazakhstan Ministry of Defense | 9/24/2013 | 2013-09-24 | 9/26/2013 | 2013-09-26 | Garmisch, Germany | 1 | 2246 | https://2009-2017.state.gov/documents/organization/230217.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
681813d8-eaf0-43e2-bf62-82972a564aeb | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_South_Central_Asia_fmtrpt.tsv | Kazakhstan | KAZ | Regional Centers - Fiscal Year 2013 Department of Defense Training | Partnering with Afghanistan | N/A | Military Study Center | 9/24/2013 | 2013-09-24 | 9/26/2013 | 2013-09-26 | Garmisch, Germany | 1 | 2246 | https://2009-2017.state.gov/documents/organization/230217.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
7aa6ba05-d1d8-4e8a-970a-fbfe4688cd31 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_South_Central_Asia_fmtrpt.tsv | Kazakhstan | KAZ | Regional Centers - Fiscal Year 2013 Department of Defense Training | Partnering with Afghanistan | N/A | Ministry of Defense | 9/24/2013 | 2013-09-24 | 9/26/2013 | 2013-09-26 | Garmisch, Germany | 1 | 2246 | https://2009-2017.state.gov/documents/organization/230217.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
5f0e0002-1473-4374-9aa2-08fd6c21c2b4 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_South_Central_Asia_fmtrpt.tsv | Kyrgyzstan | KGZ | Regional Centers - Fiscal Year 2013 Department of Defense Training | Partnering with Afghanistan | N/A | Kyrgyzstan Border Services | 9/24/2013 | 2013-09-24 | 9/26/2013 | 2013-09-26 | Garmisch, Germany | 2 | 4492 | https://2009-2017.state.gov/documents/organization/230217.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
b1ff04fe-0347-45bc-ac4b-ef85ab64a45c | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_South_Central_Asia_fmtrpt.tsv | Tajikistan | TJK | Regional Centers - Fiscal Year 2013 Department of Defense Training | Partnering with Afghanistan | N/A | Center for Strategic Studies Under the President of Tajikistan | 9/24/2013 | 2013-09-24 | 9/26/2013 | 2013-09-26 | Garmisch, Germany | 1 | 2246 | https://2009-2017.state.gov/documents/organization/230217.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
93df5d81-395b-4c2b-96b1-ec9e9321a2b6 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_South_Central_Asia_fmtrpt.tsv | Tajikistan | TJK | Regional Centers - Fiscal Year 2013 Department of Defense Training | Partnering with Afghanistan | N/A | Tajikistan Ministry of Foreign Affairs | 9/24/2013 | 2013-09-24 | 9/26/2013 | 2013-09-26 | Garmisch, Germany | 2 | 4492 | https://2009-2017.state.gov/documents/organization/230217.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
79c00dfb-898e-4966-896f-78c240b8ccf0 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | UH-60A/L Flight Simulator | EASTERN AVIATION TRAINING SITE | COLOMBIAN ARMY AVIATION SCHOOL | 9/24/2013 | 2013-09-24 | 9/28/2013 | 2013-09-28 | EASTERN AVIATION TRAINING SITE | 6 | 28548 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
e6c28b7b-e048-4991-9d53-5e6e7d3447d0 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | INL - Fiscal Year 2013 Department of State Training | UH-60M Aviator Qualification/IP (TRANS) | AVIATION SCHOOL | Federal Police | 9/24/2013 | 2013-09-24 | 9/30/2013 | 2013-09-30 | AVIATION SCHOOL | 1 | 501 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 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]);