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 1 row (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 "qa:training_date_first_seen" = :p0 and "training:country_iso_3166_1" = :p1 and rowid in (select rowid from [training-data_fts] where [training-data_fts] match escape_fts(:search)) order by [training:start_date] desc 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
3162f3aa-b005-462f-9c1a-5837ab5cdcf6	4189374e-437e-49a6-a769-023b2b22de02	2010_2011_Africa_fmtrpt.tsv	Nigeria	NGA	IMET-1 - Fiscal Year 2010 Department of State Training	PSYCHOLOGICAL OPERATIONS OFFICER	US unit not specified in 2010-2011 report	GUARDS BRIGADE	1/4/2010	2010-01-04	4/16/2010	2010-04-16	JFK SPECIAL WARFARE CENTER	1	18541	https://2009-2017.state.gov/documents/organization/171509.pdf	Not checked against source; verify accuracy before use	2011	2019-07-16