Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
This data as json, CSV (advanced)
Suggested facets: source_uuid, group, program, quantity, source_url, date_first_seen, start_date_fixed (date), end_date_fixed (date), date_scraped (date)
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 |
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");