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 -4707-05-30 and "training:end_date" is on date 2013-05-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
bc487eb4-5646-4a54-b975-1b43f6fb1bba 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Somalia SOM PKO - Fiscal Year 2013 Department of State Training Static Security Commanders Course N/A Somali National Army - Cohort VI D Company 5/6/2013 2013-05-06 5/21/2013 2013-05-21 Mogadishu, Somalia 18 12107 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
395779e1-4a51-4d3e-aad9-52ece936f0cc 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Jordan JOR FMF - Fiscal Year 2013 Department of State Training Warrior Leader SERGEANTS MAJOR ACADEMY AIR DEFENSE FIFTH BATTALION 4/22/2013 2013-04-22 5/21/2013 2013-05-21 SERGEANTS MAJOR ACADEMY 1 4245 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
5ad1c1d3-3384-4ca7-b16a-3a1e221fab45 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Jordan JOR FMF - Fiscal Year 2013 Department of State Training Warrior Leader SERGEANTS MAJOR ACADEMY BORDER GUARD COMMAND/RECON BN 4/22/2013 2013-04-22 5/21/2013 2013-05-21 SERGEANTS MAJOR ACADEMY 1 4245 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
df4b58e7-d47a-4ef1-b345-c46c21808d9c 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Jordan JOR FMF - Fiscal Year 2013 Department of State Training Warrior Leader SERGEANTS MAJOR ACADEMY CENTRAL REGION COMMAND AIR DEFENSE BRANCH 4/22/2013 2013-04-22 5/21/2013 2013-05-21 SERGEANTS MAJOR ACADEMY 1 4245 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
a46885dc-befa-431c-8bb1-3dbe95c086ad 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Jordan JOR FMF - Fiscal Year 2013 Department of State Training Warrior Leader SERGEANTS MAJOR ACADEMY DIRECTORATE OF EDUCATION AND MILITARY CULTURE 4/22/2013 2013-04-22 5/21/2013 2013-05-21 SERGEANTS MAJOR ACADEMY 1 4245 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
b34af900-b0fd-472a-b70d-0d01f32f3b2d 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Jordan JOR FMF - Fiscal Year 2013 Department of State Training Warrior Leader SERGEANTS MAJOR ACADEMY DIRECTORATE OF ARTILLERY 4/22/2013 2013-04-22 5/21/2013 2013-05-21 SERGEANTS MAJOR ACADEMY 1 4245 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
2b1eb465-6702-4897-ab38-9dc32a01a224 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Jordan JOR FMF - Fiscal Year 2013 Department of State Training Warrior Leader SERGEANTS MAJOR ACADEMY NORTHERN REGION COMMAND/CLERK 4/22/2013 2013-04-22 5/21/2013 2013-05-21 SERGEANTS MAJOR ACADEMY 1 4245 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
1ee3dab4-1026-4644-85ef-116a1fed8b86 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Egypt EGY FMF - Fiscal Year 2013 Department of State Training Blade Inspection DERCO AEROSPACE CAIRO EAST AIR BASE 4/8/2013 2013-04-08 5/21/2013 2013-05-21 DDERWIMI 2 11390 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
ad6126c0-b243-4084-b763-33abb757e411 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Somalia SOM PKO - Fiscal Year 2013 Department of State Training Guard force mentoring N/A Somali National Army - Cohort VI D Company 3/19/2013 2013-03-19 5/21/2013 2013-05-21 Mogadishu, Somalia 140 145286 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
47d924dc-9136-4949-bc6f-dcffd3bd7f7a 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Gabon GAB IMET-1 - Fiscal Year 2013 Department of State Training Military Intelligence BOLC-Branch INTELLIGENCE SCHOOL AIR TRANPORTATION DIVISION 1/23/2013 2013-01-23 5/21/2013 2013-05-21 INTELLIGENCE SCHOOL 1 31347 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
c5f24f49-b614-4c8c-8d16-4ddb2469efb0 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Lebanon LBN FMF - Fiscal Year 2013 Department of State Training FA Basic Officer Leader-Branch FIELD ARTILLERY SCHOOL 2d Brigade 1/8/2013 2013-01-08 5/21/2013 2013-05-21 FIELD ARTILLERY SCHOOL 1 24594 https://2009-2017.state.gov/documents/organization/230215.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]);