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 4 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 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
bbde855c-0ad9-4d39-a365-1adbdc8a0ebf	15615dc2-0798-4dd7-84fe-b12d603b4601	2005_2006_All_Regions_fmtrpt.tsv	Afghanistan	AFG	DOD South Asia Region, Afghanistan, Drug Interdiction and Counter-Drug Activities, Section 1004, FY05	CN Police Training JAN 05	Blackwater Corporation	CN Police-Afghanistan	1/15/2005	2005-01-15	3/15/2005	2005-03-15	Kabul	25	800000	https://2009-2017.state.gov/documents/organization/75058.pdf	Not checked against source; verify accuracy before use	2006-09	2019-07-16
ca19e7c6-983a-4211-b771-d9a1cbaef1c9	15615dc2-0798-4dd7-84fe-b12d603b4601	2005_2006_All_Regions_fmtrpt.tsv	Afghanistan	AFG	DOD South Asia Region, Afghanistan, Drug Interdiction and Counter-Drug Activities, Section 1004, FY05	CN Police Training NOV 04	Blackwater Corporation	CN Police-Afghanistan	11/15/2004	2004-11-15	1/15/2005	2005-01-15	Kabul	25	1045000	https://2009-2017.state.gov/documents/organization/75058.pdf	Not checked against source; verify accuracy before use	2006-09	2019-07-16
77f08573-1312-4a67-9781-f540b30846c7	15615dc2-0798-4dd7-84fe-b12d603b4601	2005_2006_All_Regions_fmtrpt.tsv	Afghanistan	AFG	DOD South Asia Region, Afghanistan, Drug Interdiction and Counter-Drug Activities, Section 1004, FY05	FY05 Pilot Trng, NIU/CNPA	Blackwater contract	Initial Afghan Counternarcotic police cadre	10/1/2004	2004-10-01	9/30/2005	2005-09-30	Kabul	130	4300000	https://2009-2017.state.gov/documents/organization/75058.pdf	Not checked against source; verify accuracy before use	2006-09	2019-07-16
cab3fd11-e526-44ff-bb78-5092d015ff67	15615dc2-0798-4dd7-84fe-b12d603b4601	2005_2006_All_Regions_fmtrpt.tsv	Afghanistan	AFG	DOD South Asia Region, Afghanistan, Drug Interdiction and Counter-Drug Activities, Section 1004, FY05	CN Police Training SEP 04	Blackwater Corporation	CN Police - Afghanistan, Ministry of Interior	9/15/2004	2004-09-15	11/15/2004	2004-11-15	Kabul	25	1045000	https://2009-2017.state.gov/documents/organization/75058.pdf	Not checked against source; verify accuracy before use	2006-09	2019-07-16