home / state-department-data

training_data

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

4 rows where search matches "Blackwater" sorted by quantity

View and edit SQL

Suggested facets: us_unit, student_unit, quantity, total_cost

Link rowid source_uuid group country iso_3166_1 program course_title us_unit student_unit start_date start_date_fixed end_date end_date_fixed location quantity ▼ total_cost source_url row_status date_first_seen date_scraped
39645 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-17
39642 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-17
39643 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-17
39644 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-17

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "training_data" (
	source_uuid VARCHAR NOT NULL, 
	"group" VARCHAR NOT NULL, 
	country VARCHAR, 
	iso_3166_1 VARCHAR NOT NULL, 
	program VARCHAR NOT NULL, 
	course_title VARCHAR, 
	us_unit VARCHAR, 
	student_unit VARCHAR, 
	start_date VARCHAR, 
	start_date_fixed VARCHAR, 
	end_date VARCHAR, 
	end_date_fixed VARCHAR, 
	location VARCHAR, 
	quantity VARCHAR, 
	total_cost VARCHAR, 
	source_url VARCHAR NOT NULL, 
	row_status VARCHAR NOT NULL, 
	date_first_seen VARCHAR NOT NULL, 
	date_scraped VARCHAR NOT NULL
)
Powered by Datasette · Query took 29.933ms · Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more