training-data

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

18 rows where "qa:training_date_first_seen" is on date -4707-05-30 and "training:end_date" is on date 2012-11-21 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
dc8c4d55-86ed-42a7-8cf4-b793ac2baafe 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Botswana BWA IMET-1 - Fiscal Year 2013 Department of State Training International Defense Acquisition Negotiations INTERNATIONAL DEFENSE ACQUISITION PROGRAM NPS MONTEREY CA Botswana Defence Force 11/12/2012 2012-11-12 11/21/2012 2012-11-21 IDARM NAVAL POSTGRADUATE SCHOOL MONTEREY CA 1 12464 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
fb0cfb27-5791-4b34-9c9a-3b99827f8e28 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Europe_fmtrpt.tsv Macedonia MKD IMET-1 - Fiscal Year 2013 Department of State Training International Defense Acquisition Negotiations INTERNATIONAL DEFENSE ACQUISITION PROGRAM NPS MONTEREY CA NATO Codification Bureu, Sector for Logistics, MOD 11/12/2012 2012-11-12 11/21/2012 2012-11-21 IDARM NAVAL POSTGRADUATE SCHOOL MONTEREY CA 1 10314 https://2009-2017.state.gov/documents/organization/230213.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
fc3f5941-2afc-48ce-aedd-08a99b377674 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Europe_fmtrpt.tsv Ukraine UKR IMET-1 - Fiscal Year 2013 Department of State Training International Defense Acquisition Negotiations INTERNATIONAL DEFENSE ACQUISITION PROGRAM NPS MONTEREY CA A0225, Naval Command 11/12/2012 2012-11-12 11/21/2012 2012-11-21 IDARM NAVAL POSTGRADUATE SCHOOL MONTEREY CA 1 6277 https://2009-2017.state.gov/documents/organization/230213.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
a4ebb4ca-c802-4276-9604-5155f4af505b 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_South_Central_Asia_fmtrpt.tsv India IND IMET-1 - Fiscal Year 2013 Department of State Training International Defense Acquisition Negotiations INTERNATIONAL DEFENSE ACQUISITION PROGRAM NPS MONTEREY CA ACQ WING (LS), MoD 11/12/2012 2012-11-12 11/21/2012 2012-11-21 IDARM NAVAL POSTGRADUATE SCHOOL MONTEREY CA 1 9050 https://2009-2017.state.gov/documents/organization/230217.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
093d967e-6ca6-4692-bd3d-19e89f3fce6f 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Argentina ARG IMET-1 - Fiscal Year 2013 Department of State Training International Defense Acquisition Negotiations INTERNATIONAL DEFENSE ACQUISITION PROGRAM NPS MONTEREY CA Directorate General for Defense Logistics Service 11/12/2012 2012-11-12 11/21/2012 2012-11-21 IDARM NAVAL POSTGRADUATE SCHOOL MONTEREY CA 1 9464 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
39acae80-50d2-4936-9d61-2a3317aaa8f1 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Europe_fmtrpt.tsv Bosnia & Herzegovina BIH IMET-1 - Fiscal Year 2013 Department of State Training MP BOLC-B International STU PREP MANSCEN ARMY TRAINING CENTER MINISTRY OF DEFENSE, MP BTN 11/1/2012 2012-11-01 11/21/2012 2012-11-21 MANSCEN ARMY TRAINING CENTER 1 6278 https://2009-2017.state.gov/documents/organization/230213.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
4544021c-605e-4516-bc3d-2daeb7cec494 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Europe_fmtrpt.tsv Ukraine UKR IMET-1 - Fiscal Year 2013 Department of State Training MP BOLC-B International STU PREP MANSCEN ARMY TRAINING CENTER A0552 11/1/2012 2012-11-01 11/21/2012 2012-11-21 MANSCEN ARMY TRAINING CENTER 1 8340 https://2009-2017.state.gov/documents/organization/230213.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
010e88f5-181d-4713-83a5-835bcb651395 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Egypt EGY FMF - Fiscal Year 2013 Department of State Training MP BOLC-B International STU PREP MANSCEN ARMY TRAINING CENTER MILITARY POLICE 11/1/2012 2012-11-01 11/21/2012 2012-11-21 MANSCEN ARMY TRAINING CENTER 1 6228 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
c7cedea7-ba06-4ce1-95ad-99cbb6174ea3 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv South Africa ZAF IMET-1 - Fiscal Year 2013 Department of State Training Basic Special Investigations Course FEDERAL LAW ENFORCEMENT TRAINING CENTER South African Military Police/ 10/4/2012 2012-10-04 11/21/2012 2012-11-21 FEDERAL LAW ENFORCEMENT TRAINING CENTER 1 7047 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
2fbde5ef-d9e8-4fdb-99a4-47723546695d 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Colombia COL FMF - Fiscal Year 2013 Department of State Training Spanish UH-60 Aviator Qualification AVIATION SCHOOL COLOMBIAN ARMY AVIATION SCHOOL 9/21/2012 2012-09-21 11/21/2012 2012-11-21 AVIATION SCHOOL 12 1774788 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
99d031fe-2197-45fb-b42f-84f1a1c958e3 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Liberia LBR IMET-1 - Fiscal Year 2013 Department of State Training Paralegal Specialist QUARTERMASTER SCHOOL ARMED FORCES OF LIBERIA 9/10/2012 2012-09-10 11/21/2012 2012-11-21 QUARTERMASTER SCHOOL 1 17686 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
dc237bd3-d626-4882-a01e-cc43d9f66161 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_South_Central_Asia_fmtrpt.tsv Pakistan PAK IMET-1 - Fiscal Year 2013 Department of State Training Animal Care Specialist Medical Education Training Campus Dog Platoon 9/6/2012 2012-09-06 11/21/2012 2012-11-21 083 1 18388 https://2009-2017.state.gov/documents/organization/230217.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
02a6d2c5-db7c-4495-aa08-6c8a517fbc97 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_South_Central_Asia_fmtrpt.tsv Pakistan PAK IMET-1 - Fiscal Year 2013 Department of State Training Animal Care Specialist Medical Education Training Campus RV&FC 9/6/2012 2012-09-06 11/21/2012 2012-11-21 083 1 18388 https://2009-2017.state.gov/documents/organization/230217.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
44e2b705-0b4d-4d2b-8a7a-53048d1ea32a 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Brazil BRA IMET-1 - Fiscal Year 2013 Department of State Training Parachute Rigger QUARTERMASTER SCHOOL ``General Penha Brasil`` Parachutist Instruction Center 9/4/2012 2012-09-04 11/21/2012 2012-11-21 QUARTERMASTER SCHOOL 1 4191 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
85671714-1380-407e-b54b-ad5a9c62867d 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Europe_fmtrpt.tsv Kosovo XKX IMET-1 - Fiscal Year 2013 Department of State Training Quartermaster Basic Officer Leader-Branch ALU - Leader Courses Rapid Reaction Brigade 8/6/2012 2012-08-06 11/21/2012 2012-11-21 ARMY LOG MGT COLLEGE - HUNTSVILLE CAMPUS 1 23136 https://2009-2017.state.gov/documents/organization/230213.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
f27f9d09-d654-48b2-82bc-08f56b8c7193 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Colombia COL FMF - Fiscal Year 2013 Department of State Training Avionic Mechanic AVIATION LOGISTICS SCHOOL COLOMBIAN ARMY AVIATION DIVISION 7/18/2012 2012-07-18 11/21/2012 2012-11-21 AVIATION LOGISTICS SCHOOL 2 37458 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
362fc25d-1f35-49d2-9507-4fc7da1c002c 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Mexico MEX Section 1004 - Fiscal Year 2013 Department of Defense Training Avionic Mechanic AVIATION LOGISTICS SCHOOL SEMAR 7/18/2012 2012-07-18 11/21/2012 2012-11-21 AVIATION LOGISTICS SCHOOL 3 52061 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
1c0a61fa-0ed3-44ef-9b22-da30c86c992b 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Peru PER ALP - Fiscal Year 2013 Department of Defense Training T-6 ALP Scholarship COLUMBUS AFB MS PERUVIAN AIR FORCE 12/21/2011 2011-12-21 11/21/2012 2012-11-21 COLOMBUS AFB MS 1 33887 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 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]);