training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
17 rows where "qa:training_date_first_seen" is on date -4707-05-26 and "training:end_date" is on date 2008-10-07 sorted by training:course_title 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
343e9b3d-e224-49c8-8cf1-aa72b678ad0e | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - FY 2009 DoS Training | WHEELED VEHICLE MECHANIC BNCOC | US unit not specified in 2009-2010 report | 135TH INFANTRY BRIGADE | 8/13/2008 | 2008-08-13 | 10/7/2008 | 2008-10-07 | NCO ACADEMY - ORDNANCE | 1 | 11736 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
5f888a95-f4fb-4610-aacf-493c57d7c2ef | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - FY 2009 DoS Training | PA QUALIFICATION COURSE | US unit not specified in 2009-2010 report | CIVIL RELATIONS GRP | 8/5/2008 | 2008-08-05 | 10/7/2008 | 2008-10-07 | DEFENSE INFORMATION SCHOOL | 1 | 17771 | https://2009-2017.state.gov/documents/organization/155998.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
cecdc987-ffa6-4773-9c41-94fbc9b081b4 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - FY 2009 DoS Training | PA QUALIFICATION COURSE | US unit not specified in 2009-2010 report | NAVAL INTEL AND SECURITY GRP | 8/5/2008 | 2008-08-05 | 10/7/2008 | 2008-10-07 | DEFENSE INFORMATION SCHOOL | 1 | 17771 | https://2009-2017.state.gov/documents/organization/155998.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
6f055ff9-f40e-46b7-b679-5bfbd4a5c9b3 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | IMET-1 - FY 2009 DoS Training | PA QUALIFICATION COURSE | US unit not specified in 2009-2010 report | HQ 207 BRIGADE, KHARIAN | 8/5/2008 | 2008-08-05 | 10/7/2008 | 2008-10-07 | DEFENSE INFORMATION SCHOOL | 1 | 17421 | https://2009-2017.state.gov/documents/organization/156001.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
737bc36f-c700-44dc-aa21-9c1e76f8ba9a | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - FY 2009 DoS Training | CIVIL MILITARY OPS-SPANISH | US unit not specified in 2009-2010 report | COLOMBIAN ARMY COUNTER GUERRILLAS BATALLION No.67 | 8/25/2008 | 2008-08-25 | 10/7/2008 | 2008-10-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1915 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
e5da4ee8-4980-4683-9438-9fafbe6cbecc | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - FY 2009 DoS Training | CIVIL MILITARY OPS-SPANISH | US unit not specified in 2009-2010 report | COLOMBIAN ARMY COUNTER GUERRILLAS BATTALION NO.115 | 8/25/2008 | 2008-08-25 | 10/7/2008 | 2008-10-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1915 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
7a8ac499-3b6f-4aa0-9c53-509fd37be84a | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - FY 2009 DoS Training | CIVIL MILITARY OPS-SPANISH | US unit not specified in 2009-2010 report | COLOMBIAN ARMY COUNTER GUERRILLAS BATTALION No,103 | 8/25/2008 | 2008-08-25 | 10/7/2008 | 2008-10-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1915 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
afccf60f-7889-4b44-bf75-402ad134c1a1 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2009 DoS Training | CIVIL MILITARY OPS-SPANISH | US unit not specified in 2009-2010 report | COLOMBIAN NATIONAL POLICE, ANTINARCOTICS DIRECTOR | 8/25/2008 | 2008-08-25 | 10/7/2008 | 2008-10-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1425 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
858137eb-f400-44ee-ac29-bc1419dd413b | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2009 DoS Training | CIVIL MILITARY OPS-SPANISH | US unit not specified in 2009-2010 report | COLOMBIAN NATIONAL POLICE, ANTINARCOTICS DIRECTOR | 8/25/2008 | 2008-08-25 | 10/7/2008 | 2008-10-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1425 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
f333e247-721f-4038-a9da-918ebc53b264 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2009 DoS Training | CIVIL MILITARY OPS-SPANISH | US unit not specified in 2009-2010 report | COLOMBIAN NATIONAL POLICE, ANTINARCOTICS DIRECTOR | 8/25/2008 | 2008-08-25 | 10/7/2008 | 2008-10-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1425 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
840352e6-7371-4347-99c7-1e154d62eac7 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2009 DoS Training | CIVIL MILITARY OPS-SPANISH | US unit not specified in 2009-2010 report | COLOMBIAN NATIONAL POLICE, ANTINARCOTICS DIRECTOR | 8/25/2008 | 2008-08-25 | 10/7/2008 | 2008-10-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1425 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
c7004e67-ffe8-48ef-9da5-9373672da277 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2009 DoS Training | CIVIL MILITARY OPS-SPANISH | US unit not specified in 2009-2010 report | COLOMBIAN NATIONAL POLICE, CARABINERO | 8/25/2008 | 2008-08-25 | 10/7/2008 | 2008-10-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1425 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
c4b1d380-dd5e-41c5-b44c-bcde4c10b7fe | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2009 DoS Training | CIVIL MILITARY OPS-SPANISH | US unit not specified in 2009-2010 report | COLOMBIAN NATIONAL POLICE, CARABINEROS 1425 | 8/25/2008 | 2008-08-25 | 10/7/2008 | 2008-10-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
d4067384-5de2-4364-b751-575769f6d7b3 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2009 DoS Training | CIVIL MILITARY OPS-SPANISH | US unit not specified in 2009-2010 report | COLOMBIAN NATIONAL POLICE, CARABINERO | 8/25/2008 | 2008-08-25 | 10/7/2008 | 2008-10-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1425 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
e01fae69-51f1-4f07-8b15-73945fafd85d | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - FY 2009 DoD Training | CIVIL MILITARY OPS-SPANISH | US unit not specified in 2009-2010 report | Ministry of Defense, Quito | 8/25/2008 | 2008-08-25 | 10/7/2008 | 2008-10-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 15076 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
b5f95ace-f79f-406e-9c38-291d301828c3 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Peru | PER | IMET-X - FY 2009 DoS Training | CIVIL MILITARY OPS-SPANISH | US unit not specified in 2009-2010 report | Peruvian Army - Comando Conjunto FFAA | 8/25/2008 | 2008-08-25 | 10/7/2008 | 2008-10-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 6732 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
1a6eca5b-157c-49c2-a153-57390c50dd7a | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - FY 2009 DoS Training | BASIC INSTRUCTOR COURSE | US unit not specified in 2009-2010 report | Air Lift Wings | 9/3/2008 | 2008-09-03 | 10/7/2008 | 2008-10-07 | LACKLAND AFB, TX (OTHER THAN DLI AND IAAFA STUDENTS) | 1 | 3480 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 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]);