training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
13 rows where "qa:training_date_first_seen" is on date -4707-06-01, "training:end_date" is on date 2015-08-07 and "training:start_date" is on date 2015-08-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8382a4c0-6267-4b74-acff-d2f1c3c6cc47 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Africa_fmtrpt.tsv | Congo, Democratic Republic of (Kinshasa) | COD | PKO - Fiscal Year 2015 Department of State Training | Civil Military Operations (CMO) - Executive Seminar - ES 02-15 | N/A | FARDC | 8/3/2015 | 2015-08-03 | 8/7/2015 | 2015-08-07 | Democratic Republic of the Congo - Muanda | 15 | 245769 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
752bd201-c5f8-494f-a7c4-22ddd0421e89 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Africa_fmtrpt.tsv | South Africa | ZAF | IMET-1 - Fiscal Year 2015 Department of State Training | MET Logistics And Life Cycle Management | South Africa (In Country Training) | ARMSCOR | 8/3/2015 | 2015-08-03 | 8/7/2015 | 2015-08-07 | South Africa (In Country Training) | 3 | 0 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
069b4280-ed69-4174-8fc5-44d2aefd5be4 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Africa_fmtrpt.tsv | South Africa | ZAF | IMET-1 - Fiscal Year 2015 Department of State Training | MET Logistics And Life Cycle Management | South Africa (In Country Training) | SA Air Force | 8/3/2015 | 2015-08-03 | 8/7/2015 | 2015-08-07 | South Africa (In Country Training) | 5 | 50000 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
e98678d3-62fd-43db-85de-a94941022bc4 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Africa_fmtrpt.tsv | South Africa | ZAF | IMET-1 - Fiscal Year 2015 Department of State Training | MET Logistics And Life Cycle Management | South Africa (In Country Training) | SA Army | 8/3/2015 | 2015-08-03 | 8/7/2015 | 2015-08-07 | South Africa (In Country Training) | 18 | 0 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
35024b65-3d91-4b05-90e9-1b0152760121 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Africa_fmtrpt.tsv | South Africa | ZAF | IMET-1 - Fiscal Year 2015 Department of State Training | MET Logistics And Life Cycle Management | South Africa (In Country Training) | SA DoD | 8/3/2015 | 2015-08-03 | 8/7/2015 | 2015-08-07 | South Africa (In Country Training) | 3 | 0 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
bdf9e5f7-ad19-4e2b-8ddb-51cdb2eafb88 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Africa_fmtrpt.tsv | South Africa | ZAF | IMET-1 - Fiscal Year 2015 Department of State Training | MET Logistics And Life Cycle Management | South Africa (In Country Training) | SA Navy | 8/3/2015 | 2015-08-03 | 8/7/2015 | 2015-08-07 | South Africa (In Country Training) | 7 | 0 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
aacf3bed-b60e-47a5-b77b-a227ebc7435d | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Africa_fmtrpt.tsv | South Africa | ZAF | IMET-1 - Fiscal Year 2015 Department of State Training | MET Logistics And Life Cycle Management | South Africa (In Country Training) | SA SAMHS | 8/3/2015 | 2015-08-03 | 8/7/2015 | 2015-08-07 | South Africa (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
73cc2011-c1b0-4557-bb35-f9b7b81bc75b | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Africa_fmtrpt.tsv | South Africa | ZAF | IMET-1 - Fiscal Year 2015 Department of State Training | MET Logistics And Life Cycle Management | South Africa (In Country Training) | SITA | 8/3/2015 | 2015-08-03 | 8/7/2015 | 2015-08-07 | South Africa (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
92571f9e-8f4b-4722-beef-4896be274ef5 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_East_Asia_and_Pacific_fmtrpt.tsv | Cambodia | KHM | IMET-1 - Fiscal Year 2015 Department of State Training | KOVA, Global SM Boat Maintenance | Kampuchea (Cambodia) (In Country Training) | Navy | 8/3/2015 | 2015-08-03 | 8/7/2015 | 2015-08-07 | Cambodia (In Country Training) | 1 | 16305 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
da216bd2-840f-46a8-b2c6-e075695c906a | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_East_Asia_and_Pacific_fmtrpt.tsv | Taiwan | TWN | Exchange - Fiscal Year 2015 Department of Defense Training | Advanced GIS Using SCRIPTS | National Geospatial Intelligence College | Communication Developmnet Office, MND | 8/3/2015 | 2015-08-03 | 8/7/2015 | 2015-08-07 | Springfield, VA, US | 1 | 0 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
68d27872-36e1-4440-a1c8-da19fdc15184 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_East_Asia_and_Pacific_fmtrpt.tsv | Taiwan | TWN | Exchange - Fiscal Year 2015 Department of Defense Training | Advanced GIS Using SCRIPTS | National Geospatial Intelligence College | Scientific Research Office, NSB | 8/3/2015 | 2015-08-03 | 8/7/2015 | 2015-08-07 | Springfield, VA, US | 5 | 0 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
1c2b37a6-6534-437b-ab9d-a58cf8a5a794 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Europe_fmtrpt.tsv | Bosnia & Herzegovina | BIH | IMET-1 - Fiscal Year 2015 Department of State Training | SCM DISAM Logistics Support Course | Wright Patterson AFB , OH - DISAM | Ministry Of Defense BIH | 8/3/2015 | 2015-08-03 | 8/7/2015 | 2015-08-07 | Wright Patterson AFB, OH, US | 1 | 4818 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
87ff2ac9-53b2-445e-b02d-58ab4e4c02c2 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Europe_fmtrpt.tsv | Bosnia & Herzegovina | BIH | IMET-1 - Fiscal Year 2015 Department of State Training | SCM DISAM Logistics Support Course | Wright Patterson AFB , OH - DISAM | MOD | 8/3/2015 | 2015-08-03 | 8/7/2015 | 2015-08-07 | Wright Patterson AFB, OH, US | 1 | 4818 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 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]);