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

3 rows where search matches "guards" and iso_3166_1 = "NGA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_uuid, group, program, quantity, total_cost, source_url, date_first_seen

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
103904 103904 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-17
123187 123187 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-17
123205 123205 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-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 90.59ms · Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more