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"

Search:

descending

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-16
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-16
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-16

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "training_data" (
"source_uuid" TEXT,
  "group" TEXT,
  "country" TEXT,
  "iso_3166_1" TEXT,
  "program" TEXT,
  "course_title" TEXT,
  "us_unit" TEXT,
  "student_unit" TEXT,
  "start_date" TEXT,
  "start_date_fixed" TEXT,
  "end_date" TEXT,
  "end_date_fixed" TEXT,
  "location" TEXT,
  "quantity" INTEGER,
  "total_cost" INTEGER,
  "source_url" TEXT,
  "row_status" TEXT,
  "date_first_seen" TEXT,
  "date_scraped" TEXT
);
CREATE INDEX ["training_data_iso_3166_1"] ON [training_data]("iso_3166_1");
CREATE INDEX ["training_data_course_title"] ON [training_data]("course_title");
CREATE INDEX ["training_data_us_unit"] ON [training_data]("us_unit");
CREATE INDEX ["training_data_program"] ON [training_data]("program");
CREATE INDEX ["training_data_location"] ON [training_data]("location");
CREATE INDEX ["training_data_student_unit"] ON [training_data]("student_unit");
CREATE INDEX ["training_data_end_date_fixed"] ON [training_data]("end_date_fixed");
CREATE INDEX ["training_data_start_date_fixed"] ON [training_data]("start_date_fixed");