training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
15 rows where "qa:training_date_first_seen" is on date 2018-08-15, "training:end_date" is on date 2017-08-18 and "training:start_date" is on date 2017-07-17 sorted by training:start_date descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ba7cee45-29cd-4785-adac-f7b04979b671 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Cameroon | CMR | CTPF - Fiscal Year 2017 Department of Defense Training | C-208 Initial Pilot Training | SPARTAN AVIATION, TULSA OK | 101 AF BASE YAOUNDE | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | Tulsa, OK, US | 1 | 4936 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
6fe48d6d-d831-4fa7-b2dc-462495d22272 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Cameroon | CMR | CTPF - Fiscal Year 2017 Department of Defense Training | C-208 Initial Pilot Training | SPARTAN AVIATION, TULSA OK | 301 GAROUA AIR FORCE BASE | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | Tulsa, OK, US | 1 | 5061 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
8b346b08-6b89-4ae5-82cd-13aa7a4086c8 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Cameroon | CMR | CTPF - Fiscal Year 2017 Department of Defense Training | C-208 Initial Pilot Training | SPARTAN AVIATION, TULSA OK | AIR FORCE JOINT SATFF HQ | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | Tulsa, OK, US | 1 | 5061 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
84850776-30a4-436b-a76b-b96347550a45 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Ghana | GHA | IMET-1 - Fiscal Year 2017 Department of State Training | USAF Senior NCO Academy | MAXWELL AFB, AL | Air Force Base Accra | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | Maxwell AFB, AL, US | 1 | 10245 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
621a3e30-21ef-4051-81b9-7c47de37ded8 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Niger | NER | CTPF - Fiscal Year 2017 Department of Defense Training | C-208 Initial Pilot Training | US Aviation Group | AIR FORCE BASE 101 NIAMEY | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | US Aviation Group | 1 | 13515 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
d866978b-c630-43f5-a643-f3036effe5d6 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Tanzania, United Republic of | TZA | FMF - Fiscal Year 2017 Department of State Training | High Risk/Specialty Physical | DLIELC, LACKLAND AFB TX | 92ND SPECIAL FROCES UNIT | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | Lackland AFB, TX, US | 1 | 1501 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
c790c647-ec1b-432c-9b45-77eb7d65bb0d | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Tanzania, United Republic of | TZA | IMET-1 - Fiscal Year 2017 Department of State Training | American Language Course GET And SET | DLIELC, LACKLAND AFB TX | 92ND BATTALION | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | Lackland AFB, TX, US | 1 | 13389 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
b5e510d1-d60e-4374-9dbd-c512db41db21 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Zambia | ZMB | IMET-1 - Fiscal Year 2017 Department of State Training | USAF Senior NCO Academy | MAXWELL AFB, AL | ZAMBIA AIR FORCE | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | Maxwell AFB, AL, US | 1 | 5336 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
ce27f509-bc4c-4111-8c1f-d42be87b2e4a | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | FMF - Fiscal Year 2017 Department of State Training | USAF Senior NCO Academy | MAXWELL AFB, AL | OFFICE OF THE SERGEANT MAJOR, NON-COMMISSIONED OFFICERS SCHOOL, AIR EDUCATION, TRAINING AND DOCTRINES COMMAND, PHILIPPINE AIR FORCE | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | Maxwell AFB, AL, US | 1 | 5745 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
76330520-0a5d-4dcd-8881-77c341b30836 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2017 Department of State Training | NCO Academy (Kapaun) | USAFE NCO ACADEMY AT KAPAUN AS | 114TH SQUADRON | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | Kapaun AS, GY | 1 | 420 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
33412035-c911-4162-83da-ae1e361354a4 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2017 Department of State Training | USAF Senior NCO Academy | MAXWELL AFB, AL | ELECTROMECHANICAL DIRECTORATE | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | Maxwell AFB, AL, US | 1 | 4780 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
4fd8cd3c-1516-4a88-962a-28b3138c40b9 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Morocco | MAR | IMET-1 - Fiscal Year 2017 Department of State Training | Basic Reconnaissance Primer Course | SCHOOL OF INFANTRY WEST CAMP PENDELTON CA | Intervention and Security Group | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | Camp Pendleton, CA, US | 1 | 3616 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
fc542a5d-b344-437b-9d11-56140564e6f9 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Chile | RCH | IMET-1 - Fiscal Year 2017 Department of State Training | Basic Reconnaissance Primer Course | SCHOOL OF INFANTRY WEST CAMP PENDELTON CA | Special Forces Command | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | Camp Pendleton, CA, US | 1 | 401 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
566866c8-eeee-48f4-ae9b-e77efe857ec2 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | El Salvador | SLV | Section 1004 - Fiscal Year 2017 Department of Defense Training | Border Security | 39th IBCT - 21 | Army | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | Ilogango | 18 | 45825 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
bf758ac0-b4db-4d59-b587-9116fb48c71a | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | INCLE - Fiscal Year 2017 Department of State Training | Aircraft Pneudraulics Repairer Spanish | AVIATION LOGISTICS SCHOOL | Federal Police | 7/17/2017 | 2017-07-17 | 8/18/2017 | 2017-08-18 | Ft. Eustis, VA, US | 2 | 22824 | 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
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]);