training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
28 rows where training:recipient_unit = "SEDENA" and training:source = "79e14f58-ea87-47c9-ad07-49d8742d8b3d" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
07aefb34-eeff-4691-9800-177520d681f0 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | Airborne | Infantry School | SEDENA | 7/28/2014 | 2014-07-28 | 8/15/2014 | 2014-08-15 | Ft. Benning, GA, US | 1 | 3169 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
e9785531-6b75-4047-9ba6-4b2d69ea9dbd | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2014 Department of State Training | FA Off Advanced Preparatoryied Officer | Field Artillery School | SEDENA | 6/27/2014 | 2014-06-27 | 7/22/2014 | 2014-07-22 | Ft. Sill, OK, US | 1 | 5570 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
c2ae8fc5-3c85-4662-a3ec-713b756c5437 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2014 Department of State Training | International Fellows Orientation | Army War College | SEDENA | 6/23/2014 | 2014-06-23 | 8/1/2014 | 2014-08-01 | Carlisle Barracks, PA, US | 1 | 7217 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
ad15d429-47b8-4bec-9deb-fce4457b325c | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2014 Department of State Training | International Officer School (For ACSC) | Maxwell AFB, AL | SEDENA | 6/16/2014 | 2014-06-16 | 8/1/2014 | 2014-08-01 | Maxwell AFB, AL, US | 1 | 15230 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
92720ce1-9a85-4a7b-adaa-816255156d5e | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | C-130 B/E/H/T-56 ENG TECH | Inter-American Air Forces Academy, Lackland | SEDENA | 6/16/2014 | 2014-06-16 | 7/31/2014 | 2014-07-31 | Lackland AFB, TX, US | 1 | 8131 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
15a4eebd-57f0-4868-a405-5066897e46df | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | American Language Course General English Training Only | DLIELC, Lackland AFB TX | SEDENA | 5/26/2014 | 2014-05-26 | 7/18/2014 | 2014-07-18 | Lackland AFB, TX, US | 1 | 11599 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
5732fe77-36bd-4c09-afa0-ecb574b35af9 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | Engineer Operations | Western Hemisphere Institute For Security Cooperation | SEDENA | 5/21/2014 | 2014-05-21 | 7/9/2014 | 2014-07-09 | Ft. Benning, GA, US | 1 | 9105 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
f7fb2373-f7a3-4b66-aa78-81f6b90e84df | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | Spanish Initial Entry Rotary Wing (OH-58) | Aviation School | SEDENA | 3/17/2014 | 2014-03-17 | 9/5/2014 | 2014-09-05 | Ft. Rucker, AL, US | 2 | 279800 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
e58b593b-89f8-4ad6-b46b-aab4d331e801 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2014 Department of Defense Training | Comprehensive Security Responses To Terrorism | Asia Pacific Center For Security Studies | SEDENA | 2/24/2014 | 2014-02-24 | 3/19/2014 | 2014-03-19 | Honolulu, HI, US | 3 | 33000 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
dd538c4d-0016-4c44-80d7-a49cf6c73b19 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | Health Care Specialists | Medical Education Training Campus | SEDENA | 2/24/2014 | 2014-02-24 | 6/13/2014 | 2014-06-13 | Ft. Sam Houston, TX, US | 1 | 33369 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
c9175405-a6cf-4e50-aebf-8b8777b58999 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | Intelligence Analysis Of Transnational Operations | Western Hemisphere Institute For Security Cooperation | SEDENA | 2/19/2014 | 2014-02-19 | 4/3/2014 | 2014-04-03 | Ft. Benning, GA, US | 1 | 7248 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
c81bae08-c103-4776-a04a-84afd673421e | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | Small Unit Leader | Western Hemisphere Institute For Security Cooperation | SEDENA | 2/5/2014 | 2014-02-05 | 3/11/2014 | 2014-03-11 | Ft. Benning, GA, US | 1 | 6637 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
a0d36c4e-a015-47dd-ae8b-42a97a49886c | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | Medical Assistance | Western Hemisphere Institute For Security Cooperation | SEDENA | 1/29/2014 | 2014-01-29 | 3/27/2014 | 2014-03-27 | Ft. Benning, GA, US | 1 | 8857 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
eb8f0e5c-757d-466c-9581-e069af488ed0 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | C-26 Co-Pilot Initial | Flight Safety International Learn Center - San Antonio TX | SEDENA | 12/2/2013 | 2013-12-02 | 12/14/2013 | 2013-12-14 | San Antonio, TX, US | 2 | 8236 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
d4c9b1a2-de8e-43f2-8349-781f4dd75554 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | PT-6A Engine Technician | Inter-American Air Forces Academy, Lackland | SEDENA | 9/12/2013 | 2013-09-12 | 10/9/2013 | 2013-10-09 | Lackland AFB, TX, US | 2 | 7264 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
5ae7fbaf-3968-4c4b-8189-870b0c84714b | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | Engineer Operations | Western Hemisphere Institute For Security Cooperation | SEDENA | 9/11/2013 | 2013-09-11 | 10/24/2013 | 2013-10-24 | Ft. Benning, GA, US | 1 | 10281 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
16ac8c54-eb41-444a-af55-1658fe2d2e7f | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | Medical Assistance | Western Hemisphere Institute For Security Cooperation | SEDENA | 9/11/2013 | 2013-09-11 | 11/14/2013 | 2013-11-14 | Ft. Benning, GA, US | 3 | 11406 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
85abdd83-9f37-4d34-b311-162f907fb313 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | C-130H2 PLT Initial Qualification + SGLESHP (A/S + Flying) | Little Rock AFB, AR | SEDENA | 8/29/2013 | 2013-08-29 | 2/28/2014 | 2014-02-28 | Little Rock AFB, AR, US | 1 | 118839 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
bac7ff1f-9e6e-48c7-a65c-74fc0b04814f | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | Spanish Initial Entry Rotary Wing (OH-58) | Aviation School | SEDENA | 8/28/2013 | 2013-08-28 | 3/4/2014 | 2014-03-04 | Ft. Rucker, AL, US | 1 | 209616 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
7f3f4295-0432-47df-bc5d-5f1a008094a3 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2014 Department of State Training | Command And General Staff Officer'S Course | Command & General Staff College | SEDENA | 8/12/2013 | 2013-08-12 | 6/13/2014 | 2014-06-13 | Ft. Leavenworth, KS, US | 1 | 14275 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
3e70e0be-e305-4633-a7b6-9bd7ca3f29ad | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2014 Department of State Training | Hemispheric Defense & Security | Inter-American Defense College | SEDENA | 8/9/2013 | 2013-08-09 | 6/30/2014 | 2014-06-30 | Washington D.C., US | 1 | 20485 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
069913c9-33e5-445e-a24a-37dd7c053848 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2014 Department of State Training | Air Command & Staff College (ACSC Resident Course) | Maxwell AFB, AL | SEDENA | 8/7/2013 | 2013-08-07 | 6/9/2014 | 2014-06-09 | Maxwell AFB, AL, US | 1 | 52677 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
0703f158-710e-48e7-93f8-9da8d15349f5 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2014 Department of State Training | Army War College (Resident Course) | Army War College | SEDENA | 8/5/2013 | 2013-08-05 | 6/7/2014 | 2014-06-07 | Carlisle Barracks, PA, US | 1 | 20393 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
50a91555-7445-4289-bda9-766efb2ce5bf | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2014 Department of State Training | Air War College (AWC) Resident Program | Maxwell AFB, AL | SEDENA | 7/22/2013 | 2013-07-22 | 5/22/2014 | 2014-05-22 | Maxwell AFB, AL, US | 1 | 72802 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
ab12aaea-cdc4-4f8e-aa8f-4a824d4d25e2 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2014 Department of State Training | Intermediate Level Education | Western Hemisphere Institute For Security Cooperation | SEDENA | 7/18/2013 | 2013-07-18 | 5/28/2014 | 2014-05-28 | Ft. Benning, GA, US | 1 | 20886 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
e5fd80a2-bfdd-4e9e-aa13-4a8eeab28ef4 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | International EOD PH II Surface | Naval School Explosive Ordnance Disposal EGLI | SEDENA | 7/17/2013 | 2013-07-17 | 11/13/2013 | 2013-11-13 | Eglin AFB, FL, US | 1 | 21183 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
3b6257c3-94aa-4f65-b84e-84d4300604f8 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | Special Forces Qualificationied (Engineer SGT) | JFK Special Warfare Center | SEDENA | 6/24/2013 | 2013-06-24 | 2/6/2014 | 2014-02-06 | Ft. Bragg, NC, US | 1 | 22157 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
5dd6aa2b-6c79-4c70-b4d7-78e59210754b | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | ALP - Fiscal Year 2014 Department of Defense Training | Aviation Leadership PRG (T-6A) (SATP) | Columbus AFB MS | SEDENA | 3/12/2013 | 2013-03-12 | 4/25/2014 | 2014-04-25 | Columbus AFB, MS, US | 1 | 45543 | 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]);