training-data

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

7 rows where "training:end_date" is on date 2006-05-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
dde78b41-d8d6-4fd3-8c51-08b8ed05a76b 1fcf235c-b155-4dde-bf01-3f209af7227f 2006_2007_South_Central_Asia_fmtrpt.tsv Pakistan PAK FMF - FY 2006 DoS Training P-3C STRUC HYD PWR F/C O/M - Supervisor Airframe, PNS Mehran 4/24/2006 2006-04-24 5/15/2006 2006-05-15 OAK HARBOR, WA 1 937 https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92088.htm Not checked against source; verify accuracy before use 2007-08 2019-07-16
8e9c8983-2f04-4aa8-bf3c-2e9e568f5253 1fcf235c-b155-4dde-bf01-3f209af7227f 2006_2007_South_Central_Asia_fmtrpt.tsv Pakistan PAK FMF - FY 2006 DoS Training P-3C STRUC HYD PWR F/C O/M - Supervisor Airframe System, Hydrolic Shop, PNS Mehran 4/24/2006 2006-04-24 5/15/2006 2006-05-15 OAK HARBOR, WA 1 937 https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92088.htm Not checked against source; verify accuracy before use 2007-08 2019-07-16
c900c62c-fcfd-487c-80c8-2d1d4fe1d7a3 1fcf235c-b155-4dde-bf01-3f209af7227f 2006_2007_Africa_fmtrpt.tsv Ethiopia ETH Misc DOD/DOS Non-SA - FY 2006 DoD Training NECTAR BEND - CTU 4/15/2006 2006-04-15 5/15/2006 2006-05-15 Bilate 90 150000 https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92084.htm Not checked against source; verify accuracy before use 2007-08 2019-07-16
f91c3ec6-0630-484c-a993-dc4ec13e5666 1fcf235c-b155-4dde-bf01-3f209af7227f 2006_2007_Africa_fmtrpt.tsv Kenya KEN Misc DOD/DOS Non-SA - FY 2006 DoD Training NATURAL FIRE - MOD 20th Parachute Regiment (20th PARA) 4/15/2006 2006-04-15 5/15/2006 2006-05-15 Nairobi 75 0 https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92084.htm Not checked against source; verify accuracy before use 2007-08 2019-07-16
4585ef44-c444-498d-bc97-77af3f6e0d86 1fcf235c-b155-4dde-bf01-3f209af7227f 2006_2007_South_Central_Asia_fmtrpt.tsv Pakistan PAK IMET - FY 2006 DoS Training PERSONNEL APR - Assistant Director Civilian Personnel (ADCP) (Bases/Units), Air Headquarters, Islamabad 4/10/2006 2006-04-10 5/15/2006 2006-05-15 KEESLER AFB, MS 1 3122 https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92088.htm Not checked against source; verify accuracy before use 2007-08 2019-07-16
d795e4ef-c8de-439d-bdb7-6c07fa54a520 1fcf235c-b155-4dde-bf01-3f209af7227f 2006_2007_Western_Hemisphere_fmtrpt.tsv Chile RCH Service Academies - FY 2006 DoD Training USAFA Semester Exchange -   1/3/2006 2006-01-03 5/15/2006 2006-05-15 USAFA, Colorado Springs, CO 2 10000 https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm Not checked against source; verify accuracy before use 2007-08 2019-07-16
2ab1b2c6-67be-4701-a9b1-73bd2fc1d1df 1fcf235c-b155-4dde-bf01-3f209af7227f 2006_2007_Europe_fmtrpt.tsv Azerbaijan AZE IMET - FY 2006 DoS Training ENGLISH LANGUAGE CRSE - Army, Platoon Commander 1/2/2006 2006-01-02 5/15/2006 2006-05-15 LACKLAND AFB, TX 1 29299 https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92086.htm Not checked against source; verify accuracy before use 2007-08 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]);