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

2 rows where search matches "married" sorted by end_date

View and edit SQL

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
20286 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Newly_Independent_States_fmtrpt.tsv Georgia GEO DOS NIS Region, Georgia, International Military Education and Training (IMET),FY03 INTL OFF INTEL CAPT CAREER   Has left the course, got married and stais in USA 8/7/2002 2002-08-07 11/25/2002 2002-11-25 FT HUACHUCA AZ 85613-7000 1 7437 https://2009-2017.state.gov/documents/organization/34336.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-17
20271 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Newly_Independent_States_fmtrpt.tsv Georgia GEO DOS NIS Region, Georgia, International Military Education and Training (IMET),FY03 ENGLISH LANGUAGE CRSE   Has left the course, got married and stais in USA 12/23/2002 2002-12-23 6/6/2003 2003-06-06 SAN ANTONIO TX 78236-5259 1 3212 https://2009-2017.state.gov/documents/organization/34336.pdf Not checked against source; verify accuracy before use 2004-06 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 27.83ms · Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more