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 "training:end_date" is on date 2007-10-15 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
8dcb3182-60f3-4c68-ae1c-bdb41528941e 333125f2-0bae-4feb-bdde-8c6fd26d0ccb 2008_2009_Africa_fmtrpt.tsv Djibouti DJI IMET-1 - FY 2008 DoS Training OT PARTICIPANT US unit not specified in 2008-2009 report CHIEF OF STAFF OFFICE & LOGISTICS DIV 10/2/2007 2007-10-02 10/15/2007 2007-10-15 NDU 1 7000 https://2009-2017.state.gov/documents/organization/152766.pdf Not checked against source; verify accuracy before use 2009 2019-07-16
ef703fd3-b75e-4409-84f6-2a6aa0e48487 333125f2-0bae-4feb-bdde-8c6fd26d0ccb 2008_2009_Africa_fmtrpt.tsv Djibouti DJI IMET-1 - FY 2008 DoS Training OT PARTICIPANT US unit not specified in 2008-2009 report ARMORED SQUADRON 10/2/2007 2007-10-02 10/15/2007 2007-10-15 NDU 1 8144 https://2009-2017.state.gov/documents/organization/152766.pdf Not checked against source; verify accuracy before use 2009 2019-07-16
c18e3a28-6da3-423f-b410-e6ab97d175d0 333125f2-0bae-4feb-bdde-8c6fd26d0ccb 2008_2009_Africa_fmtrpt.tsv Djibouti DJI IMET-1 - FY 2008 DoS Training OT PARTICIPANT US unit not specified in 2008-2009 report MATERIAL COMMAND 10/2/2007 2007-10-02 10/15/2007 2007-10-15 NDU 1 7000 https://2009-2017.state.gov/documents/organization/152766.pdf Not checked against source; verify accuracy before use 2009 2019-07-16
b108354d-972f-4a09-b671-41a82b2662b9 333125f2-0bae-4feb-bdde-8c6fd26d0ccb 2008_2009_Africa_fmtrpt.tsv Djibouti DJI IMET-1 - FY 2008 DoS Training OT PARTICIPANT US unit not specified in 2008-2009 report US MATERIAL DEPOT 10/2/2007 2007-10-02 10/15/2007 2007-10-15 NDU 1 7000 https://2009-2017.state.gov/documents/organization/152766.pdf Not checked against source; verify accuracy before use 2009 2019-07-16
2edde00e-849f-492c-8e3f-240c6c76fba9 333125f2-0bae-4feb-bdde-8c6fd26d0ccb 2008_2009_Africa_fmtrpt.tsv Lesotho LSO IMET-X - FY 2008 DoS Training SIGNAL CAPTAINS CAREER PREP-INTERNATIONAL US unit not specified in 2008-2009 report SIGNALS COMPANY 9/28/2007 2007-09-28 10/15/2007 2007-10-15 SIGNAL SCHOOL 1 7140 https://2009-2017.state.gov/documents/organization/152766.pdf Not checked against source; verify accuracy before use 2009 2019-07-16
49e8e35b-d274-4ea0-af58-c37432377a01 333125f2-0bae-4feb-bdde-8c6fd26d0ccb 2008_2009_Europe_fmtrpt.tsv Republic of Serbia SRB IMET-X - FY 2008 DoS Training SIGNAL CAPTAINS CAREER PREP-INTERNATIONAL US unit not specified in 2008-2009 report Signal Unit 9/28/2007 2007-09-28 10/15/2007 2007-10-15 SIGNAL SCHOOL 1 10206 https://2009-2017.state.gov/documents/organization/152768.pdf Not checked against source; verify accuracy before use 2009 2019-07-16
47ca9910-c801-44a4-a967-81ad12ec370d 333125f2-0bae-4feb-bdde-8c6fd26d0ccb 2008_2009_Europe_fmtrpt.tsv Ukraine UKR IMET-1 - FY 2008 DoS Training SIGNAL CAPTAINS CAREER PREP-INTERNATIONAL US unit not specified in 2008-2009 report Automatic control Section, Staff Battalion, 30 Separate Brigade, Ground Force Command, UAF. 9/28/2007 2007-09-28 10/15/2007 2007-10-15 SIGNAL SCHOOL 1 4648 https://2009-2017.state.gov/documents/organization/152768.pdf Not checked against source; verify accuracy before use 2009 2019-07-16
0f7e1b89-5d02-464a-ae46-1901ce2cc1ea 333125f2-0bae-4feb-bdde-8c6fd26d0ccb 2008_2009_Near_East_fmtrpt.tsv Tunisia TUN IMET-1 - FY 2008 DoS Training SIGNAL CAPTAINS CAREER PREP-INTERNATIONAL US unit not specified in 2008-2009 report 71st Signal Regiment 9/28/2007 2007-09-28 10/15/2007 2007-10-15 SIGNAL SCHOOL 1 6823 https://2009-2017.state.gov/documents/organization/152770.pdf Not checked against source; verify accuracy before use 2009 2019-07-16
ed4f32d4-d82b-4e1f-a15f-41e9f2055aa0 333125f2-0bae-4feb-bdde-8c6fd26d0ccb 2008_2009_Near_East_fmtrpt.tsv Egypt EGY FMF - FY 2008 DoS Training AH-64D AVIATION QUAL - ALL US unit not specified in 2008-2009 report ABOU-HAMMAD AIR BASE 6/21/2007 2007-06-21 10/15/2007 2007-10-15 AVIATION SCHOOL 1 378668 https://2009-2017.state.gov/documents/organization/152770.pdf Not checked against source; verify accuracy before use 2009 2019-07-16
1d5c2ab8-bf2f-4230-9942-7c3397587899 333125f2-0bae-4feb-bdde-8c6fd26d0ccb 2008_2009_Near_East_fmtrpt.tsv Egypt EGY FMF - FY 2008 DoS Training AH-64D AVIATION QUAL - ALL US unit not specified in 2008-2009 report ABOU-HAMMAD AIR BASE 6/21/2007 2007-06-21 10/15/2007 2007-10-15 AVIATION SCHOOL 1 378668 https://2009-2017.state.gov/documents/organization/152770.pdf Not checked against source; verify accuracy before use 2009 2019-07-16
6e8b9486-3143-4911-9437-179973767bae 333125f2-0bae-4feb-bdde-8c6fd26d0ccb 2008_2009_Near_East_fmtrpt.tsv Egypt EGY FMF - FY 2008 DoS Training AH-64D AVIATION QUAL - ALL US unit not specified in 2008-2009 report ABOU-HAMMAD AIR BASE 6/21/2007 2007-06-21 10/15/2007 2007-10-15 AVIATION SCHOOL 1 378668 https://2009-2017.state.gov/documents/organization/152770.pdf Not checked against source; verify accuracy before use 2009 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]);