training-data

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

11 rows where "qa:training_date_first_seen" is on date 2018-08-15, "training:end_date" is on date 2016-12-16 and "training:start_date" is on date 2016-09-06 sorted by training:start_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

training:id:admin training:source qa:training_group training:country training:country_iso_3166_1 training:program training:course_title training:delivery_unit training:recipient_unit qa:training_start_date training:start_date ▲ qa:training_end_date training:end_date training:location training:quantity training:total_cost qa:training_source_url training:status:admin qa:training_date_first_seen qa:training_date_scraped
c4b693c7-2350-4d2f-94b1-900be189e010 8602229d-5b77-42e5-b1bc-83fad2eda1b9 2017_2018_Africa_fmtrpt.tsv Senegal SEN CTFP - Fiscal Year 2017 Department of Defense Training CTFP Homeland Defense Short Course College of International Security Affairs Legion of Gendarmerie West Center 9/6/2016 2016-09-06 12/16/2016 2016-12-16 Ft. Mcnair, NDU, DC, US 1 56895 https://2009-2017.state.gov/documents/organization/284930.pdf Not checked against source; verify accuracy before use 2018-08-15 2019-07-16
e30a4ede-4fe9-45f1-9e25-c2ff34791271 8602229d-5b77-42e5-b1bc-83fad2eda1b9 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv Indonesia IDN CTFP - Fiscal Year 2017 Department of Defense Training CTFP Homeland Defense Short Course College of International Security Affairs North and Central America Section, Directorate of Strategic Analysis, Directorate General of Defense Strategy, Indonesian Ministry of Defense 9/6/2016 2016-09-06 12/16/2016 2016-12-16 Ft. Mcnair, NDU, DC, US 1 57465 https://2009-2017.state.gov/documents/organization/284930.pdf Not checked against source; verify accuracy before use 2018-08-15 2019-07-16
b20ff804-1468-45ed-a8a9-6f8119f1bf74 8602229d-5b77-42e5-b1bc-83fad2eda1b9 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv Philippines PHL CTFP - Fiscal Year 2017 Department of Defense Training CTFP Homeland Defense Short Course College of International Security Affairs NAVAL BASE CAVITE, NAVAL INSTALLATION COMMAND, PHIL NAVY 9/6/2016 2016-09-06 12/16/2016 2016-12-16 Ft. Mcnair, NDU, DC, US 1 57075 https://2009-2017.state.gov/documents/organization/284930.pdf Not checked against source; verify accuracy before use 2018-08-15 2019-07-16
db3b89b9-a066-4c83-866f-91207f28f9e0 8602229d-5b77-42e5-b1bc-83fad2eda1b9 2017_2018_Europe_fmtrpt.tsv Macedonia MKD CTFP - Fiscal Year 2017 Department of Defense Training CTFP Homeland Defense Short Course College of International Security Affairs Military Service for Intelligence and Security 9/6/2016 2016-09-06 12/16/2016 2016-12-16 Ft. Mcnair, NDU, DC, US 1 57475 https://2009-2017.state.gov/documents/organization/284930.pdf Not checked against source; verify accuracy before use 2018-08-15 2019-07-16
d51e1c42-2145-4552-9734-8e782e52f278 8602229d-5b77-42e5-b1bc-83fad2eda1b9 2017_2018_Near_East_fmtrpt.tsv Jordan JOR CTFP - Fiscal Year 2017 Department of Defense Training CTFP Homeland Defense Short Course College of International Security Affairs BORDER GUARD HQ 9/6/2016 2016-09-06 12/16/2016 2016-12-16 Ft. Mcnair, NDU, DC, US 1 53959 https://2009-2017.state.gov/documents/organization/284930.pdf Not checked against source; verify accuracy before use 2018-08-15 2019-07-16
47989587-bb56-42d5-9af8-1545d0a31945 8602229d-5b77-42e5-b1bc-83fad2eda1b9 2017_2018_Near_East_fmtrpt.tsv Lebanon LBN CTFP - Fiscal Year 2017 Department of Defense Training CTFP Homeland Defense Short Course College of International Security Affairs 1st Intervention Regiment 9/6/2016 2016-09-06 12/16/2016 2016-12-16 Ft. Mcnair, NDU, DC, US 1 57425 https://2009-2017.state.gov/documents/organization/284930.pdf Not checked against source; verify accuracy before use 2018-08-15 2019-07-16
390e181c-f7a8-4de3-82a7-5833b223bccf 8602229d-5b77-42e5-b1bc-83fad2eda1b9 2017_2018_Near_East_fmtrpt.tsv Morocco MAR CTFP - Fiscal Year 2017 Department of Defense Training CTFP Homeland Defense Short Course College of International Security Affairs ERN - CASABLANCA 9/6/2016 2016-09-06 12/16/2016 2016-12-16 Ft. Mcnair, NDU, DC, US 1 56275 https://2009-2017.state.gov/documents/organization/284930.pdf Not checked against source; verify accuracy before use 2018-08-15 2019-07-16
441e8e58-3a7a-4071-b147-7eaa5f2c9703 8602229d-5b77-42e5-b1bc-83fad2eda1b9 2017_2018_South_Central_Asia_fmtrpt.tsv Pakistan PAK CTFP - Fiscal Year 2017 Department of Defense Training CTFP Homeland Defense Short Course College of International Security Affairs DIRECTORATE OF PLANS, JOINT STAFF HEADQUARTERS 9/6/2016 2016-09-06 12/16/2016 2016-12-16 Ft. Mcnair, NDU, DC, US 1 56541 https://2009-2017.state.gov/documents/organization/284930.pdf Not checked against source; verify accuracy before use 2018-08-15 2019-07-16
3859b872-6628-4447-ab96-5d8c011e587d 8602229d-5b77-42e5-b1bc-83fad2eda1b9 2017_2018_South_Central_Asia_fmtrpt.tsv Pakistan PAK CTFP - Fiscal Year 2017 Department of Defense Training CTFP Homeland Defense Short Course College of International Security Affairs JSHQ 9/6/2016 2016-09-06 12/16/2016 2016-12-16 Ft. Mcnair, NDU, DC, US 1 60391 https://2009-2017.state.gov/documents/organization/284930.pdf Not checked against source; verify accuracy before use 2018-08-15 2019-07-16
59107c07-368e-4677-8655-ad05cf0d9d76 8602229d-5b77-42e5-b1bc-83fad2eda1b9 2017_2018_Western_Hemisphere_fmtrpt.tsv Bahamas BHS CTFP - Fiscal Year 2017 Department of Defense Training CTFP Homeland Defense Short Course College of International Security Affairs RBDF 9/6/2016 2016-09-06 12/16/2016 2016-12-16 Ft. Mcnair, NDU, DC, US 1 53775 https://2009-2017.state.gov/documents/organization/284930.pdf Not checked against source; verify accuracy before use 2018-08-15 2019-07-16
bd6c22b3-7307-469c-a839-d9e3cbd2430a 8602229d-5b77-42e5-b1bc-83fad2eda1b9 2017_2018_Western_Hemisphere_fmtrpt.tsv Colombia COL CTFP - Fiscal Year 2017 Department of Defense Training CTFP Homeland Defense Short Course College of International Security Affairs Ministry of Defense 9/6/2016 2016-09-06 12/16/2016 2016-12-16 Ft. Mcnair, NDU, DC, US 1 52790 https://2009-2017.state.gov/documents/organization/284930.pdf Not checked against source; verify accuracy before use 2018-08-15 2019-07-16

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "training-data" (
   [training:id:admin] TEXT PRIMARY KEY,
   [training:source] TEXT,
   [qa:training_group] TEXT,
   [training:country] TEXT,
   [training:country_iso_3166_1] TEXT,
   [training:program] TEXT,
   [training:course_title] TEXT,
   [training:delivery_unit] TEXT,
   [training:recipient_unit] TEXT,
   [qa:training_start_date] TEXT,
   [training:start_date] TEXT,
   [qa:training_end_date] TEXT,
   [training:end_date] TEXT,
   [training:location] TEXT,
   [training:quantity] INTEGER,
   [training:total_cost] INTEGER,
   [qa:training_source_url] TEXT,
   [training:status:admin] TEXT,
   [qa:training_date_first_seen] TEXT,
   [qa:training_date_scraped] TEXT
);
CREATE INDEX [idx_training-data_training:id:admin_training:source_qa:training_group_training:country_training:country_iso_3166_1_training:program_training:course_title_training:delivery_unit_training:recipient_unit_qa:training_start_date_training:start_date_qa:training_end_date_training:end_date_training:location_training:quantity_training:total_cost_qa:training_source_url_training:status:admin_qa:training_date_first_seen_qa:training_date_scraped]
    ON [training-data] ([training:id:admin], [training:source], [qa:training_group], [training:country], [training:country_iso_3166_1], [training:program], [training:course_title], [training:delivery_unit], [training:recipient_unit], [qa:training_start_date], [training:start_date], [qa:training_end_date], [training:end_date], [training:location], [training:quantity], [training:total_cost], [qa:training_source_url], [training:status:admin], [qa:training_date_first_seen], [qa:training_date_scraped]);