training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
14 rows where "qa:training_date_first_seen" is on date -4707-05-25 and "training:start_date" is on date 2007-09-03 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3d5d969f-cd69-4cec-ab23-99b509d7a510 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Guinea | GIN | IMET-1 - FY 2008 DoS Training | BASIC OFFICER COURSE USMC | US unit not specified in 2008-2009 report | JOINT FINANCE BUREAU | 9/3/2007 | 2007-09-03 | 3/19/2008 | 2008-03-19 | COMMANDING GENERAL, EDUCATION COMMAND QUANTICO VA | 1 | 19913 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
bf79ae5b-d5f7-4caf-a83d-b458fa272411 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Albania | ALB | IMET-1 - FY 2008 DoS Training | ENGLISH LANGUAGE COURSEE | US unit not specified in 2008-2009 report | Military Police Battalion, Sauk, Tirana | 9/3/2007 | 2007-09-03 | 11/9/2007 | 2007-11-09 | DLIELC, LACKLAND AFB TX | 1 | 14346 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
728ec4e8-b0ae-467b-90cc-b836e8ed9ddd | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Yemen | YEM | FMF - FY 2008 DoS Training | GENERAL ENGLISH ONLY | US unit not specified in 2008-2009 report | DEPARTMENT OF MILITARY INTELLIGENCE | 9/3/2007 | 2007-09-03 | 5/2/2008 | 2008-05-02 | DLIELC, LACKLAND AFB TX | 1 | 30646 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
73198259-8847-49c0-8d29-fa7d62ad23c4 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Yemen | YEM | FMF - FY 2008 DoS Training | GENERAL ENGLISH ONLY | US unit not specified in 2008-2009 report | MINISTRY OF DEFENSE | 9/3/2007 | 2007-09-03 | 5/2/2008 | 2008-05-02 | DLIELC, LACKLAND AFB TX | 1 | 27251 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
c1d55c5d-030f-4f66-95e9-5e5e2c319bac | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Yemen | YEM | FMF - FY 2008 DoS Training | GENERAL ENGLISH ONLY | US unit not specified in 2008-2009 report | REPUBLICAN GUARDS | 9/3/2007 | 2007-09-03 | 5/2/2008 | 2008-05-02 | DLIELC, LACKLAND AFB TX | 1 | 29278 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
3f7b1155-ff2d-4ead-9ff6-315dcd69977e | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Yemen | YEM | FMF - FY 2008 DoS Training | GENERAL ENGLISH ONLY | US unit not specified in 2008-2009 report | SPECIAL GUARD | 9/3/2007 | 2007-09-03 | 5/2/2008 | 2008-05-02 | DLIELC, LACKLAND AFB TX | 1 | 29177 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
2f5e356f-77cb-482a-9563-dba9628b49c7 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Yemen | YEM | FMF - FY 2008 DoS Training | GENERAL ENGLISH ONLY | US unit not specified in 2008-2009 report | COMMANDER-IN-CHIEF'S OFFICE | 9/3/2007 | 2007-09-03 | 5/2/2008 | 2008-05-02 | DLIELC, LACKLAND AFB TX | 1 | 29256 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
2093b9b2-8114-4cd2-b8fe-c73d7662a7fe | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Yemen | YEM | FMF - FY 2008 DoS Training | GENERAL ENGLISH ONLY | US unit not specified in 2008-2009 report | DEPARTMENT OF MILITARY INTELLIGENCE | 9/3/2007 | 2007-09-03 | 5/2/2008 | 2008-05-02 | DLIELC, LACKLAND AFB TX | 1 | 28753 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
faf733b9-7cf9-4336-b405-73375a3da285 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | CTFP - FY 2008 DoD Training | SPECIALIZED ENGLISH LANGUAGE TRAINING | US unit not specified in 2008-2009 report | PNS Iqbal, Pakistan Navy | 9/3/2007 | 2007-09-03 | 11/2/2007 | 2007-11-02 | DLIELC, LACKLAND AFB TX | 1 | 6486 | https://2009-2017.state.gov/documents/organization/152773.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f63d4b8f-2603-4f33-b2f4-bb22ebda9c4a | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_South_Central_Asia_fmtrpt.tsv | Turkmenistan | TKM | IMET-1 - FY 2008 DoS Training | AMERICAN LANGUAGE COURSE | US unit not specified in 2008-2009 report | Air Force & Air Defense | 9/3/2007 | 2007-09-03 | 6/6/2008 | 2008-06-06 | DLIELC, LACKLAND AFB TX | 1 | 28947 | https://2009-2017.state.gov/documents/organization/152773.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e664350c-6585-452d-836a-8d86a8aa358a | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Bolivia | BOL | IMET-X - FY 2008 DoS Training | AMERICAN LANGUAGE COURSE | US unit not specified in 2008-2009 report | High Altitude Diving Center \"CIBA\" | 9/3/2007 | 2007-09-03 | 1/4/2008 | 2008-01-04 | DLIELC, LACKLAND AFB TX | 1 | 16862 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
4ba45290-0929-4d4d-880b-664bba75723a | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Bolivia | BOL | IMET-X - FY 2008 DoS Training | GENERAL ENGLISH LANG TRAINING | US unit not specified in 2008-2009 report | High Altitude Diving Center \"CIBA\" | 9/3/2007 | 2007-09-03 | 12/28/2007 | 2007-12-28 | DLIELC, LACKLAND AFB TX | 1 | 13534 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
caa32bb2-ad06-4ba7-bd02-703c6ab01a70 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - FY 2008 DoS Training | BASIC OFFICER COURSE USMC | US unit not specified in 2008-2009 report | GAULA BUENAVENTURA | 9/3/2007 | 2007-09-03 | 3/19/2008 | 2008-03-19 | COMMANDING GENERAL, EDUCATION COMMAND QUANTICO VA | 1 | 17825 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e9f394f4-9ea7-422f-b53a-5e7d46df042e | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | IMET-1 - FY 2008 DoS Training | BASIC OFFICER COURSE USMC | US unit not specified in 2008-2009 report | DRN A COMPANY | 9/3/2007 | 2007-09-03 | 3/19/2008 | 2008-03-19 | COMMANDING GENERAL, EDUCATION COMMAND QUANTICO VA | 1 | 16187 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 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]);