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-31, "training:end_date" is on date 2014-07-25 and "training:start_date" is on date 2014-07-14 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
faaf375e-237e-4ddb-8485-3e8b69727f13 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | FMF - Fiscal Year 2014 Department of State Training | Defense Management For Indonesian Defense | Defense Resources Management Institute NPS MO | Indonesian Defense University | 7/14/2014 | 2014-07-14 | 7/25/2014 | 2014-07-25 | Monterey, CA, US | 1 | 10779 | https://2009-2017.state.gov/documents/organization/243030.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
22e733f3-993a-4522-9b4c-a7d465f2b792 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | FMF - Fiscal Year 2014 Department of State Training | Defense Management For Indonesian Defense | Defense Resources Management Institute NPS MO | Univeristy Of Defense | 7/14/2014 | 2014-07-14 | 7/25/2014 | 2014-07-25 | Monterey, CA, US | 1 | 10779 | https://2009-2017.state.gov/documents/organization/243030.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
c9b295a9-c4c4-48e9-8740-aea2b4ead793 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | FMF - Fiscal Year 2014 Department of State Training | Defense Management For Indonesian Defense | Defense Resources Management Institute NPS MO | University Of Defense | 7/14/2014 | 2014-07-14 | 7/25/2014 | 2014-07-25 | Monterey, CA, US | 14 | 150906 | https://2009-2017.state.gov/documents/organization/243030.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
162c9054-693d-4d3b-939e-897eb1b3afa1 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2014 Department of State Training | Instructor Training Course | Academy Of Health Sciences | Medical Services | 7/14/2014 | 2014-07-14 | 7/25/2014 | 2014-07-25 | Ft. Sam Houston, TX, US | 2 | 5416 | https://2009-2017.state.gov/documents/organization/243032.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
82cdf745-c360-467c-be9f-d182c540fd26 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2014 Department of State Training | Multi-Criteria Decision Making | Defense Resources Management Institute NPS MO | Department Of Data Systems Analysis-MOD | 7/14/2014 | 2014-07-14 | 7/25/2014 | 2014-07-25 | Monterey, CA, US | 1 | 4401 | https://2009-2017.state.gov/documents/organization/243032.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
f38bb942-7c4c-40f2-bf93-db806049b05c | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2014 Department of State Training | Multi-Criteria Decision Making | Defense Resources Management Institute NPS MO | Department Of Regulations-MOD | 7/14/2014 | 2014-07-14 | 7/25/2014 | 2014-07-25 | Monterey, CA, US | 1 | 4401 | https://2009-2017.state.gov/documents/organization/243032.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
8ed30f82-ef9a-4fe9-9005-609b56e1612a | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2014 Department of State Training | Multi-Criteria Decision Making | Defense Resources Management Institute NPS MO | Legal Department-MOD | 7/14/2014 | 2014-07-14 | 7/25/2014 | 2014-07-25 | Monterey, CA, US | 1 | 4401 | https://2009-2017.state.gov/documents/organization/243032.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
0624c01c-164c-4c21-9d0e-6ee09709ea67 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2014 Department of State Training | Multi-Criteria Decision Making | Defense Resources Management Institute NPS MO | Ministry Of Defense | 7/14/2014 | 2014-07-14 | 7/25/2014 | 2014-07-25 | Monterey, CA, US | 1 | 7451 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
e293d2c6-2f93-4062-a107-2d6a2ccd9d84 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2014 Department of State Training | Multi-Criteria Decision Making | Defense Resources Management Institute NPS MO | Ministry Of Defense - Strategy & Planning | 7/14/2014 | 2014-07-14 | 7/25/2014 | 2014-07-25 | Monterey, CA, US | 1 | 7451 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
d4c0a522-67b1-436d-91b0-cb05b2211c0e | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2014 Department of State Training | Multi-Criteria Decision Making | Defense Resources Management Institute NPS MO | Ministry Of Defense - Strategy /Planning Office | 7/14/2014 | 2014-07-14 | 7/25/2014 | 2014-07-25 | Monterey, CA, US | 1 | 7451 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
cbf2e690-befa-4805-b7a4-9d3e912edb49 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | IMET-1 - Fiscal Year 2014 Department of State Training | MTT Search Coordination & Execution | Dominican Republic (In Country Training) | Civilian | 7/14/2014 | 2014-07-14 | 7/25/2014 | 2014-07-25 | Dominican Republic (In Country Training) | 2 | 37625 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
5ef3951a-c6c0-4f43-8fa5-00ef3c64aeec | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | IMET-1 - Fiscal Year 2014 Department of State Training | MTT Search Coordination & Execution | Dominican Republic (In Country Training) | DR Air Force | 7/14/2014 | 2014-07-14 | 7/25/2014 | 2014-07-25 | Dominican Republic (In Country Training) | 3 | 0 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
55d60b39-26aa-4b8e-9b89-8467f727cf7d | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | IMET-1 - Fiscal Year 2014 Department of State Training | MTT Search Coordination & Execution | Dominican Republic (In Country Training) | DR Navy | 7/14/2014 | 2014-07-14 | 7/25/2014 | 2014-07-25 | Dominican Republic (In Country Training) | 16 | 0 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
bfc4c883-c472-4d2a-9351-b91496437695 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Uruguay | URY | IMET-1 - Fiscal Year 2014 Department of State Training | Unit Movement Officer Deployment Planning | Transportation School | Engineer Brigade I | 7/14/2014 | 2014-07-14 | 7/25/2014 | 2014-07-25 | Ft. Lee, VA, US | 1 | 4914 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 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]);