state-department-data

Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more

Custom SQL query returning 2 rows (hide)

select [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] from [training-data] where date("qa:training_date_scraped") = :p0 and "qa:training_source_url" = :p1 and "training:country_iso_3166_1" = :p2 and "training:source" = :p3 and rowid in (select rowid from [training-data_fts] where [training-data_fts] match escape_fts(:search)) order by [training:start_date] limit 101

Query parameters

This data as json, CSV

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
b0f6f2d3-2a80-4171-b5b9-d2b99764726d	4bb42ad2-5ae2-4d21-b512-23eef531daaa	2011_2012_Africa_fmtrpt.tsv	Nigeria	NGA	Regional Centers - Fiscal Year 2011 Department of Defense Training	2011-02 Next Generation of African Security Sector Leaders Course - Washington DC	Days - N/A	177 Guards Battalion	2/27/2011	2011-02-27	3/26/2011	2011-03-26	US	28	18365	https://2009-2017.state.gov/documents/organization/197610.pdf	Not checked against source; verify accuracy before use	2012	2019-07-16
5e6141c2-8e40-4a08-84ef-b5bde5b40882	4bb42ad2-5ae2-4d21-b512-23eef531daaa	2011_2012_Africa_fmtrpt.tsv	Nigeria	NGA	Regional Centers - Fiscal Year 2011 Department of Defense Training	NEXT GENERATION OF AFRICAN MILITARY LEADERS	AFRICA CTR FOR SECURITY STUDIES - N/A	GUARDS BRIGADE NIGERIAN ARMY	2/28/2011	2011-02-28	3/25/2011	2011-03-25	AFRICA CTR FOR SECURITY STUDIES	1		https://2009-2017.state.gov/documents/organization/197610.pdf	Not checked against source; verify accuracy before use	2012	2019-07-16