training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
20 rows where "qa:training_date_first_seen" is on date 2018-08-15 and "training:start_date" is on date 2017-06-07 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
674c35a6-d258-451e-bd8e-fa63b9a8e268 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2017 Department of State Training | AT I Apprentice TECH (AEC) | CO NAVAL AIR TECHNICAL TRAINING CENTER PENSAC | AIR DEFENSE DEPT | 6/7/2017 | 2017-06-07 | 7/10/2017 | 2017-07-10 | Pensacola, FL, US | 1 | 9367 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
59eb5d5c-6577-4635-a861-36f17271cafd | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET-1 - Fiscal Year 2017 Department of State Training | Armor Basic Officer Leader-Branch | Armor School | 1st Brigade | 6/7/2017 | 2017-06-07 | 6/8/2017 | 2017-06-08 | Ft. Benning, GA, US | 1 | 286 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
7d128242-b379-4ed9-91f7-1625a64294da | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET-1 - Fiscal Year 2017 Department of State Training | Armor Basic Officer Leader-Branch | Armor School | 3d Intervention Regiment | 6/7/2017 | 2017-06-07 | 6/8/2017 | 2017-06-08 | Ft. Benning, GA, US | 1 | 286 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
69142fa2-eed2-4c41-ade9-6655efaf3799 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | Amigo Infante Foundation | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 1 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
99723926-9d79-4964-b03e-97b7308afc2a | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | Andes University | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 1 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
6463deaf-0c96-4966-88fd-dedd03b40573 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | Bussines Consultant | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 1 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
bf6bdd52-3fed-4e63-8b49-1332aed26a50 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | CEMI Group | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 2 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
748d288c-6c6c-4fb0-943f-e906eb98b922 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | COLMIL General Command | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 1 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
01275cc8-9afb-478c-80d8-c911ba1606d4 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | COTEF | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 1 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
655a5bde-aaee-4865-9025-2c34ec51df0e | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | Del Rosario University | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 1 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
a3a0524f-e713-4b0c-b495-8adbceaeb19e | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | DIPON | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 1 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
3acffbd3-3fba-47f7-b5fd-aca634d85ceb | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | ESDEGUE | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 14 | 51010 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
7746e3b7-75cc-4579-9024-9a894387ff85 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | ESDEGUE/CREES | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 1 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
1f189e7e-6ffa-48da-908d-e3652de304de | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | ESDEGUE/EPEFAC | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 1 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
47173312-ec9d-45e4-b3b9-6f4b69c55bfb | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | ESMAI | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 2 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
a04fa90d-5e18-4f3d-9987-22f69b232fd1 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | INVIAS | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 1 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
9a195f4a-de58-4b5a-9d59-ead0ee576bfe | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | Ministry of Defense | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 2 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
3630d49b-17a5-46e6-af2e-22f80bb70a31 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | Ministry orf Defense | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 1 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
e690cb4f-d983-4582-89e9-b9a670aaa040 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | Ministry TIC | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 1 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
0847b174-b035-4062-8f4a-d20679ab7a21 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2017 Department of Defense Training | CO - JSOU Regional CVE MTT/In Country | COLOMBIA (In Country Training) | National University of Colombia | 6/7/2017 | 2017-06-07 | 6/17/2017 | 2017-06-17 | Bogota, CO | 1 | 0 | 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]);