training_data

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

1 row where search matches "Blackwater" and quantity = 130 sorted by end_date

View and edit SQL

Suggested facets: start_date_fixed (date), end_date_fixed (date), date_scraped (date)

quantity

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

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 43.603ms · Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more