training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
158 rows where "training:end_date" is on date 2014-07-31 sorted by training:status:admin
This data as json, CSV (advanced)
qa:training_date_first_seen (date) 1 ✖
- -4707-05-31 23
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
da8a42bb-1573-4691-8ad0-3e0d68bba195 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | IMET-1 - Fiscal Year 2014 Department of State Training | Financial Management Officer | Keesler AFB, MS | Pakistan Air Force Academy Risalpur | 5/19/2014 | 2014-05-19 | 7/31/2014 | 2014-07-31 | Keesler AFB, MS, US | 1 | 13160 | https://2009-2017.state.gov/documents/organization/243033.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
db757479-c641-43bb-bf83-02ee87a195a5 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2014 Department of State Training | Basic Instructor Course | Inter-American Air Forces Academy, Lackland | Coast Guard Station - Amazonas | 6/2/2014 | 2014-06-02 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 1 | 4180 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
dba2706a-5616-4eea-a0a9-4807ea3fc465 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Paraguay | PRY | IMET-1 - Fiscal Year 2014 Department of State Training | CYBER Operations | Inter-American Air Forces Academy, Lackland | Paraguayan Air Force Command | 6/9/2014 | 2014-06-09 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 1 | 9485 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
ddf3e8e0-ee09-4b4d-8aba-5438d8624e6e | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2014 Department of State Training | Basic Helicopter Crew Chief | Inter-American Air Forces Academy, Lackland | Colombian Air Force NCO Academy Madrid Cundinamarca | 5/1/2014 | 2014-05-01 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 1 | 1660 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
dfe96c1e-2165-4eee-bf6d-4ca8ef09869d | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - Fiscal Year 2014 Department of State Training | Aircraft Hydraulic Systems Technician | Inter-American Air Forces Academy, Lackland | 601st Aircraft Maintenance And Supplies Battalion | 5/1/2014 | 2014-05-01 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 1 | 1660 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
e0ccadda-1c7c-4155-9b0b-f0b5d70e4315 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Peru | PER | Section 1004 - Fiscal Year 2014 Department of Defense Training | Material Management | Inter-American Air Forces Academy, Lackland | Air Force | 6/16/2014 | 2014-06-16 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 2 | 16860 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
e582b749-a6f5-48b1-94a7-64d0245d2c08 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2014 Department of Defense Training | CHDS Combating Terrorism Seminar | Colombia (In Country Training) | Chile | 7/28/2014 | 2014-07-28 | 7/31/2014 | 2014-07-31 | Colombia (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
e74855df-775f-4bcf-806d-c8fc91238588 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2014 Department of State Training | Special Reaction Team | Inter-American Air Forces Academy, Lackland | Air Combat Command No.2, Apiay | 6/9/2014 | 2014-06-09 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 1 | 420 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
ea00e5af-0f19-477d-9a50-930a212f1256 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Paraguay | PRY | IMET-1 - Fiscal Year 2014 Department of State Training | Weapons Safety | Inter-American Air Forces Academy, Lackland | Paraguayan Air Force Commander | 6/16/2014 | 2014-06-16 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 1 | 9331 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
ecb0293d-84f7-4860-ae7b-f08ae12f4aa3 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2014 Department of State Training | Aircraft ELECTR Fundamentals Technician | Inter-American Air Forces Academy, Lackland | Colombian Air Force NCO, Academy Madrid Cundinamarca | 5/1/2014 | 2014-05-01 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 3 | 4980 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
ed3fff7d-f11d-4dc5-921e-e6e8795bc9e7 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Chile | RCH | IMET-1 - Fiscal Year 2014 Department of State Training | International LOG/Supply Management Course | Inter-American Air Forces Academy, Lackland | Air Bragade No.1 | 6/16/2014 | 2014-06-16 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 1 | 1260 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
ee50892a-597c-4b52-bf96-cd50471cdf70 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Peru | PER | Section 1004 - Fiscal Year 2014 Department of Defense Training | Basic Helicopter Crew Chief | Inter-American Air Forces Academy, Lackland | Air Force | 5/1/2014 | 2014-05-01 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 1 | 11894 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
efd78df9-3a12-40c1-ae2c-56ab60e9ac41 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2014 Department of Defense Training | CHDS Combating Terrorism Seminar | Colombia (In Country Training) | EE.UU | 7/28/2014 | 2014-07-28 | 7/31/2014 | 2014-07-31 | Colombia (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 |
f350ca0d-5e3b-4e70-b927-95e66b3253e9 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | INL - Fiscal Year 2014 Department of State Training | INTEL, SURV & RECON Fundamentals (ISR) | Inter-American Air Forces Academy, Lackland | Federal Police | 6/23/2014 | 2014-06-23 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 2 | 15058 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
f37f4980-5042-4c82-a718-37aa513de171 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | IMET-1 - Fiscal Year 2014 Department of State Training | Inter-American Non COMM Off Academy (INCOA) | Inter-American Air Forces Academy, Lackland | Hector Caraccioli Moncada Air Base | 6/2/2014 | 2014-06-02 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 1 | 6981 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
f52d20d9-fea1-426f-830f-d613ad13438e | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2014 Department of Defense Training | CHDS Combating Terrorism Seminar | Colombia (In Country Training) | NDU | 7/28/2014 | 2014-07-28 | 7/31/2014 | 2014-07-31 | Colombia (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
f6055885-f84d-4a0a-9c03-12668d94c08a | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | IMET-1 - Fiscal Year 2014 Department of State Training | International LOG/Supply Management Course | Inter-American Air Forces Academy, Lackland | Honduran Air Force Headquarters | 6/16/2014 | 2014-06-16 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 1 | 7031 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
f84560b0-35b8-460e-9978-6c1cbe239bca | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Bahamas | BHS | Section 1004 - Fiscal Year 2014 Department of Defense Training | Initial Naval Aviation Survival Training | Naval Operational Medicine Institute DET NAMI | RBDF | 7/14/2014 | 2014-07-14 | 7/31/2014 | 2014-07-31 | Pensacola, FL, US | 1 | 7439 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
fad42e32-cfff-4057-8ef9-f4036cfb7b15 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | A/C STRUCT Maintenance Technician | Inter-American Air Forces Academy, Lackland | SEMAR | 5/1/2014 | 2014-05-01 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 1 | 12650 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
fb0a95b6-91a5-4764-a7b2-feeb62a95df9 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - Fiscal Year 2014 Department of State Training | Inter-American Non COMM Off Academy (INCOA) | Inter-American Air Forces Academy, Lackland | Colombian Navy, Intelligence Directorate | 6/2/2014 | 2014-06-02 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 1 | 1000 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
fb15b7cc-feab-4d63-8ece-50b959195d8b | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2014 Department of Defense Training | CHDS Combating Terrorism Seminar | Colombia (In Country Training) | Commando General-Protocol | 7/28/2014 | 2014-07-28 | 7/31/2014 | 2014-07-31 | Colombia (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
fb234c76-9239-4623-b308-e473efcfacf8 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Peru | PER | CTFP - Fiscal Year 2014 Department of Defense Training | CHDS Combating Terrorism Seminar | Colombia (In Country Training) | Army | 7/28/2014 | 2014-07-28 | 7/31/2014 | 2014-07-31 | Colombia (In Country Training) | 2 | 2256 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
fd68f09c-6208-4d41-9c31-7e9278e1a2dc | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - Fiscal Year 2014 Department of State Training | Corrosion Control Technician | Inter-American Air Forces Academy, Lackland | Colombian Police, Air Service | 6/16/2014 | 2014-06-16 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 1 | 860 | 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]);