training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
6,360 rows where training:country_iso_3166_1 = "MEX" sorted by training:location descending
This data as json, CSV (advanced)
Suggested facets: training:source, qa:training_group, qa:training_source_url, qa:training_date_first_seen, qa:training_date_scraped, training:end_date (date), qa:training_date_first_seen (date), qa:training_date_scraped (date)
training:start_date (date) >30 ✖
- 2009-08-31 62
- 2009-03-01 53
- 2006-10-19 46
- 2007-03-18 45
- 2002-03-18 35
- 2008-01-11 34
- 2010-07-19 34
- 2008-11-17 31
- 2010-06-05 31
- 2002-04-24 30
- 2006-11-26 30
- 2007-10-20 30
- 2008-11-03 30
- 2007-03-11 29
- 2010-08-16 29
- 2007-10-21 28
- 2009-09-14 28
- 2010-03-22 28
- 2008-08-04 26
- 2010-07-31 26
- 2008-09-20 25
- 2009-04-27 25
- 2009-08-22 25
- 2010-09-06 25
- 2001-04-30 24
- 2001-05-08 24
- 2002-05-02 24
- 2008-07-28 24
- 2008-08-11 24
- 2009-02-02 24
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68d63397-7a76-4acc-8c06-a3caa7dcaafb | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - FY 2009 DoD Training | INTL INTELL FELLOWS PGM | US unit not specified in 2009-2010 report | SEDENA | 3/13/2009 | 2009-03-13 | 3/27/2009 | 2009-03-27 | dEFENSE INTELLIGENCE AGENCY | 1 | 5793 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
2dce6052-41a3-47ba-a40b-58d15bc2a0b0 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOHS/USCG - Fiscal Year 2020 Department of Homeland Security Training | Explosives Handling Supervisor | COGARD Training Center Yorktown VA - 0 | SEMAR | 2/24/2020 | 2020-02-24 | 3/6/2020 | 2020-03-06 | Yorktown, VA, US | 1 | 3631 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
a1b09c40-b025-48d7-bc0a-116e726a0c22 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOHS/USCG - Fiscal Year 2020 Department of Homeland Security Training | Marine Inspector Domestic | COGARD Training Center Yorktown VA - 0 | SEMAR | 8/29/2019 | 2019-08-29 | 10/4/2019 | 2019-10-04 | Yorktown, VA, US | 1 | 3050 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
c1130c05-8336-4c5f-b8e5-b96f88839972 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOHS/USCG - Fiscal Year 2020 Department of Homeland Security Training | MET Maritime Operations Planning & Management | COGARD International Training DET Tracen Yorktown VA - 0 | Navy | 12/16/2019 | 2019-12-16 | 12/20/2019 | 2019-12-20 | Yorktown, VA, US | 1 | 0 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
22036456-9eb2-49bc-aa07-4448dd0c0611 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOHS/USCG - Fiscal Year 2020 Department of Homeland Security Training | Port State Control Officer (PSCO) | COGARD Training Center Yorktown VA - 0 | SEMAR | 2/24/2020 | 2020-02-24 | 3/13/2020 | 2020-03-13 | Yorktown, VA, US | 2 | 11050 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
6eb3da68-2a7e-422d-a7de-7ba387b39c9a | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2020 Department of State Training | International Maritime Officer (IMOC) | COGARD Training Center Yorktown VA - 0 | SEMAR | 3/9/2020 | 2020-03-09 | 5/9/2020 | 2020-05-09 | Yorktown, VA, US | 1 | 23367 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
4d9faa7f-dc61-489b-a4a1-662387869002 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 333 - Fiscal Year 2020 Department of Defense Training | Maritime Search And Rescue Planning | COGARD Training Center Yorktown VA - 0 | SEMAR | 10/21/2019 | 2019-10-21 | 11/15/2019 | 2019-11-15 | Yorktown, VA, US | 1 | 4391 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
8a1fb14a-33b5-4f34-ad46-2ff1c7a44785 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2014 Department of State Training | International Maritime Officer (IMOC) | COGARD Training Center Yorktown VA | SEMAR | 8/26/2013 | 2013-08-26 | 12/5/2013 | 2013-12-05 | Yorktown, VA, US | 3 | 51630 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
672cf52d-07bb-4ff0-8b32-f3537103f9de | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | International Crisis CMD/Control | COGARD Training Center Yorktown VA | SEMAR | 7/7/2014 | 2014-07-07 | 7/18/2014 | 2014-07-18 | Yorktown, VA, US | 4 | 25796 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
2c60cba9-f090-4664-a3ba-16fa2fca3f8f | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | Maritime Search And Rescue Planning | COGARD Training Center Yorktown VA | SEMAR | 3/31/2014 | 2014-03-31 | 4/24/2014 | 2014-04-24 | Yorktown, VA, US | 1 | 5475 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
3d74e12b-4738-4d3d-954d-00476e172873 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | Maritime Search And Rescue Planning | COGARD Training Center Yorktown VA | SEMAR | 7/14/2014 | 2014-07-14 | 8/7/2014 | 2014-08-07 | Yorktown, VA, US | 1 | 5475 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
023c79d9-611d-4674-abd9-5cebd601ed46 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | MET CG Maritime Law Enforcement Instructor (CG 3) | COGARD International Training DET Tracen Yorktown VA | SEMAR | 4/21/2014 | 2014-04-21 | 5/2/2014 | 2014-05-02 | Yorktown, VA, US | 13 | 44797 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
80517050-1e22-4916-a490-f52216fe5df4 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | MET CG Maritime Law Enforcement Instructor (CG 3) | COGARD International Training DET Tracen Yorktown VA | SEMAR | 4/21/2014 | 2014-04-21 | 5/2/2014 | 2014-05-02 | Yorktown, VA, US | 1 | 0 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
5b2b45f7-75ba-4b9a-bed0-24503994edca | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | MET CG Maritime Law Enforcement JNT Boarding Officer CG 5 | COGARD International Training DET Tracen Yorktown VA | SEMAR | 5/5/2014 | 2014-05-05 | 5/16/2014 | 2014-05-16 | Yorktown, VA, US | 17 | 35747 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
a1591003-25d7-4c99-a603-f94c408119df | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2014 Department of Defense Training | MTT Small Boat Operations II | COGARD International Training DET Tracen Yorktown VA | SEMAR | 5/19/2014 | 2014-05-19 | 5/30/2014 | 2014-05-30 | Yorktown, VA, US | 12 | 50668 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
a6778d22-adba-41af-aab5-03bbb77f591f | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2015 Department of Defense Training | International Maritime Officer (IMOC) | COGARD Training Center Yorktown VA | SEMAR | 8/25/2014 | 2014-08-25 | 12/4/2014 | 2014-12-04 | Yorktown, VA, US | 3 | 72849 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
52f56033-a30d-40ea-a8ea-b250d4a25ec1 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2016 Department of State Training | International Boarding Officer Course | COGARD Training Center Yorktown VA | SEMAR | 1/25/2016 | 2016-01-25 | 2/19/2016 | 2016-02-19 | Yorktown, VA, US | 2 | 22124 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
878e1016-a0d4-4989-8f82-7b7a9cb700d1 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2016 Department of Defense Training | Damage Controlman A | COGARD Training Center Yorktown VA | SEMAR | 5/2/2016 | 2016-05-02 | 8/11/2016 | 2016-08-11 | Yorktown, VA, US | 1 | 12344 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
8e65d9e4-2133-4c2d-ba14-a609b6244d7a | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2016 Department of Defense Training | International Maritime Search And Rescue Planning | COGARD Training Center Yorktown VA | SEMAR | 7/11/2016 | 2016-07-11 | 7/22/2016 | 2016-07-22 | Yorktown, VA, US | 2 | 9430 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
c9182f07-bc92-40da-8c58-1f3498917d80 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2016 Department of Defense Training | MTT Small Boat Operations I | COGARD International Training DET Tracen Yorktown VA | SEMAR | 9/5/2016 | 2016-09-05 | 9/16/2016 | 2016-09-16 | Yorktown, VA, US | 12 | 54255 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
8d6b1def-91b9-4cad-a854-544abf994bf4 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2017 Department of State Training | International Boarding Officer Course | COGARD TRAINING CENTER YORKTOWN VA | SEMAR | 1/23/2017 | 2017-01-23 | 2/17/2017 | 2017-02-17 | Yorktown, VA, US | 2 | 23102 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
b9eb4265-fc36-49d7-9f4d-65f7a97a2cc6 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2017 Department of State Training | International Maritime Officer (IMOC) | COGARD TRAINING CENTER YORKTOWN VA | SEMAR | 8/22/2016 | 2016-08-22 | 12/2/2016 | 2016-12-02 | Yorktown, VA, US | 2 | 51230 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
27fd123d-c583-46a5-9259-299b0c0681e1 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2018 Department of State Training | International Boarding Officer Course (Spanish) | COGARD Training Center Yorktown VA | SEMAR | 1/22/2018 | 2018-01-22 | 2/15/2018 | 2018-02-15 | Yorktown, VA, US | 5 | 50840 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
fbc4d60d-25f1-4945-be49-b6da338d1725 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2018 Department of State Training | International Maritime Officer (IMOC) | COGARD Training Center Yorktown VA | SEMAR | 8/21/2017 | 2017-08-21 | 11/30/2017 | 2017-11-30 | Yorktown, VA, US | 2 | 51596 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
3df514ee-e3d0-41eb-a0db-7953c5f7589d | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 333 - Fiscal Year 2018 Department of Defense Training | Damage Controlman A | COGARD Training Center Yorktown VA | SEMAR | 5/29/2018 | 2018-05-29 | 9/6/2018 | 2018-09-06 | Yorktown, VA, US | 1 | 11684 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
cf1a4eee-d1ce-4570-b308-4c336719a4cc | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 333 - Fiscal Year 2018 Department of Defense Training | Maritime Search And Rescue Planning | COGARD Training Center Yorktown VA | SEMAR | 6/18/2018 | 2018-06-18 | 7/12/2018 | 2018-07-12 | Yorktown, VA, US | 2 | 8306 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
4aa211e7-8e64-4963-83fe-0d6a76bfc066 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOHS/USCG - Fiscal Year 2019 Department of Homeland Security Training | MET CG Maritime Law Enforcement Instructor (CG 3) | COGARD International Training DET Tracen Yorktown, VA | Navy | 5/20/2019 | 2019-05-20 | 5/31/2019 | 2019-05-31 | Yorktown, VA, US | 1 | 0 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
ec36957c-c3f7-435e-92e8-b2a2d8de4957 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOHS/USCG - Fiscal Year 2019 Department of Homeland Security Training | MS Investigating Officer (MS-603) | COGARD Training Center Yorktown, VA | SEMAR | 4/16/2019 | 2019-04-16 | 4/26/2019 | 2019-04-26 | Yorktown, VA, US | 1 | 3487 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
2b5fb91e-67fd-459f-a18b-5b6039dd1e05 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOHS/USCG - Fiscal Year 2019 Department of Homeland Security Training | MTT Boarding Officer Course | COGARD International Training DET Tracen Yorktown, VA | Navy | 5/6/2019 | 2019-05-06 | 5/17/2019 | 2019-05-17 | Yorktown, VA, US | 1 | 0 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
0bfddce9-af92-404d-8e16-6a4573b69f70 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOHS/USCG - Fiscal Year 2019 Department of Homeland Security Training | On-Line Pre-requisite | COGARD Training Center Yorktown, VA | SEMAR | 8/22/2019 | 2019-08-22 | 8/27/2019 | 2019-08-27 | Yorktown, VA, US | 1 | 2733 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
942a2771-2e91-4cc0-93d5-b8f87b28315e | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOHS/USCG - Fiscal Year 2019 Department of Homeland Security Training | Port State Control Officer (PSCO) | COGARD Training Center Yorktown, VA | SEMAR | 8/12/2019 | 2019-08-12 | 8/30/2019 | 2019-08-30 | Yorktown, VA, US | 1 | 4198 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
e0887af4-6c73-4165-802f-a8d89091a4d1 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | FMF - Fiscal Year 2019 Department of State Training | International Boarding Officer Course (Spanish) | COGARD Training Center Yorktown, VA | SEMAR | 1/22/2019 | 2019-01-22 | 2/14/2019 | 2019-02-14 | Yorktown, VA, US | 5 | 50570 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
392ffe73-8a13-4b74-8d72-4914f7d77f35 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2019 Department of State Training | International Maritime Officer (IMOC) | COGARD Training Center Yorktown, VA | SEMAR | 8/20/2018 | 2018-08-20 | 11/29/2018 | 2018-11-29 | Yorktown, VA, US | 2 | 43630 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
8560072e-6653-4385-b66b-f45dbced3052 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 333 - Fiscal Year 2019 Department of Defense Training | Boatswains Mate A | COGARD Training Center Yorktown, VA | SEMAR | 9/10/2018 | 2018-09-10 | 12/14/2018 | 2018-12-14 | Yorktown, VA, US | 1 | 10664 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
fa716d76-5ba3-464c-aa54-8307a5328d7f | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 333 - Fiscal Year 2019 Department of Defense Training | Damage Controlman A | COGARD Training Center Yorktown, VA | SEMAR | 7/16/2018 | 2018-07-16 | 10/25/2018 | 2018-10-25 | Yorktown, VA, US | 1 | 11509 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
61ff2bb5-581e-4850-b0a7-d398257b9cdb | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 333 - Fiscal Year 2019 Department of Defense Training | Damage Controlman A | COGARD Training Center Yorktown, VA | SEMAR | 9/4/2018 | 2018-09-04 | 12/13/2018 | 2018-12-13 | Yorktown, VA, US | 1 | 11166 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
9a1cdd4e-cf11-4c8b-a843-4334aa6cea0d | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 333 - Fiscal Year 2019 Department of Defense Training | Damage Controlman A | COGARD Training Center Yorktown, VA | SEMAR | 4/8/2019 | 2019-04-08 | 7/18/2019 | 2019-07-18 | Yorktown, VA, US | 1 | 10935 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
9d65d383-b0e5-4ccd-9ea3-a9fbce81b2ea | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 333 - Fiscal Year 2019 Department of Defense Training | Damage Controlman A | COGARD Training Center Yorktown, VA | SEMAR | 5/28/2019 | 2019-05-28 | 9/6/2019 | 2019-09-06 | Yorktown, VA, US | 1 | 11010 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
96145965-d570-4161-819a-e53d68d43f64 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 333 - Fiscal Year 2019 Department of Defense Training | Maritime Search And Rescue Planning | COGARD Training Center Yorktown, VA | SEMAR | 8/5/2019 | 2019-08-05 | 8/29/2019 | 2019-08-29 | Yorktown, VA, US | 1 | 4694 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
ad1ee8bb-fe8b-46a1-a70f-ed4c2a9b277a | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | SEARCH/RESCUE MARITIME | 7th Naval Zone, Isla Mujeres, Quintana Roo | 8/6/01 | 2001-08-06 | 8/23/01 | 2001-08-23 | YORKTOWN, VA 23690-5000 | 1 | 1371 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
81ffb8f9-cf08-4e4e-aa82-1d9ff2d2a6b3 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | SEARCH/RESCUE MARITIME | Destroyer \"Cuitlahuac\" (E01), Lazaro Cardenas, Michoacan | 8/6/01 | 2001-08-06 | 8/23/01 | 2001-08-23 | YORKTOWN, VA 23690-5000 | 1 | 1371 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
221c431d-bb82-4869-b7d8-bd5bb5ed3a71 | 048fb2d9-6651-4ba0-b36a-a526539f4cfd | 2002_2003_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY 02 | SEARCH/RESCUE MARITIME | 2nd Patrol Squadron,La Paz,Baja California Sur,MX | 8/12/02 | 2002-08-12 | 8/29/02 | 2002-08-29 | YORKTOWN, VA 23690-5000 | 1 | 2029 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
e7b02589-07d3-4d83-b17d-e5760f3d3f20 | 048fb2d9-6651-4ba0-b36a-a526539f4cfd | 2002_2003_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY 02 | SEARCH/RESCUE MARITIME | Cdt Patrol Ship PC-226, Yukalpeten,Yucatan,MX | 8/12/02 | 2002-08-12 | 8/29/02 | 2002-08-29 | YORKTOWN, VA 23690-5000 | 1 | 2029 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
ba9fe0a8-61b8-4fa3-aeee-4275fe222baf | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, Drug Interdiction and Counter-Drug Activities, Section 1004, FY03 | MET MLE ADV BOARD OFF | ARM \"Quintana\" (1), Veracruz, Veracruz ; ARM \"Otomi\" (1) Tampico, Tamaulipas; H. Escuela Naval Militar (1), Veracruz, Veracruz; ARM \"Guerrero\" (1) Tampico, Tamaulipas; Estado Mayor General Digim.(1), Navy Hqs., Mexico, D.F.; ARM \"Panuco\"(1) Tampico, Tamaulipas ' SEGESCAEREC (1), Campeche, Campeche; Centro de Capacitacion (2), El Salado, Veracruz; ARM \"Escobedo\"(3) Acapulco, Guerrero; ARM \"Manzanillo\"(1) Manzanillo, Colima; SUBNAVMAT 1), Matamoros, Tamaulipas; ARM \"Holzinger\"(1) Tampico, Tamaulipas; ARM \"Sonora\"(1), Coatzacoalcos, Veracruz; 2nd Naval Zone(1), Ensenada, Baja California; ARM \"Galeana(1), Manzanillo, Colima; ' ARM \"Aldebaran\"(1), Veracruz, Veracruz; BATEVAPA (1), Manzanillo, Colima; 6th Naval Zone (1), Lazaro Cardenas, Michoacan | 3/10/2003 | 2003-03-10 | 3/21/2003 | 2003-03-21 | YORKTOWN, VA 23690 | 21 | 20000 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
b1498e1b-6af4-4585-94c4-d0b74e84b0fa | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, Drug Interdiction and Counter-Drug Activities, Section 1004, FY03 | MTT OUTBOARD MTR MAINT CG9 | Taller de Reparaciones (10), Tampico, Tamaulipas; Naval Sector (2),Tuxpan, Veracruz; Taller de Reparaciones (1), Manzanillo, Colima; 3rd Naval Zone (1), Veracruz, Veracruz; 5th Naval Zone(1), Ciudad del Carmen, Campeche; Naval Sub-Sector(2), Matamoros, Tamaulipas; ARM \"Guanajuato\" (1), Tampico, Tamaulipas; Naval Sector (1), Yucalpeten, Yucatan; Naval Sector (1), Chetumal, Quintana Roo; Naval Sector (1) Coatzacoalcos, Veracruz. | 3/3/2003 | 2003-03-03 | 3/7/2003 | 2003-03-07 | YORKTOWN, VA 23690 | 21 | 16000 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
c8ada763-41b4-4091-99b0-dffc2c2d345a | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, Regional Defense Counterterrorism Fellowship Program, FY04 | MTT MARITIME CRISIS MGMT | CESNAV EDOMAYGRAL NAVCOAT NAVMAN ZN-1 ZN-10 ZN-2 ZN-3 ZN-4 ZN-5 ZN-6 ZN-7 ZN-8 | 2/23/2004 | 2004-02-23 | 3/5/2004 | 2004-03-05 | YORKTOWN, VA 23690 | 0 | 0 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 2019-07-16 | |
466267d4-59ef-4200-abd9-1f635b858d84 | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, Regional Defense Counterterrorism Fellowship Program, FY04 | MTT PORT SEC/VUL ASM | 2/DA. BRIG.NAV. SALINA CRUZ OAXACA ARM. “ALTAIR” B1-03 ARM.”HUMBOLDT” ARM.”MINA” F-214 ASTILLERO 20 CINOP CUARTFLOT. CUARTFLOT.PO-103 “ESCOBEDO” FRAIMPA JEM. FRAIMPA NAVMAN NAVPAZ NAVTLAN NAVTOP ZN-2 ZN-4 GUAYMAS | 2/9/2004 | 2004-02-09 | 2/13/2004 | 2004-02-13 | YORKTOWN, VA 23690 | 24 | 44000 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 2019-07-16 | |
a7ce53b8-d3df-400f-985e-e02c2adc71a4 | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, Regional Defense Counterterrorism Fellowship Program, FY04 | MTT PORT SEC/VUL ASM | EDOMAY S3 FUERNAVGO NAVCOAT NAVTUX SUBNAVCOZ SUBNAVFRONT ZN-1 ZN-3 ZN-5 ZN-7 | 2/16/2004 | 2004-02-16 | 2/20/2004 | 2004-02-20 | YORKTOWN, VA 23690 | 0 | 0 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 2019-07-16 | |
2bfeb350-4b05-4562-b212-2bdc95434901 | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, Regional Defense Counterterrorism Fellowship Program, FY04 | MTT WATERSIDE PORT SECUR | 1RA BRIGADA NAVAL COAT 1RA BRIGADA NAVAL ZN 1 1RA BRIGADA NAVAL ZN-5 2DA BRIGADA DE YUCATAN 2DA BRIGADA ZONA NAVAL ZN1 AGRUP DE SEG E INSTALACIONES ESTRATEG ARM ACHERNAR PI-1106 ARM PEACOCK PI-1125 ARM SUHAIL PI-1132 BRIGADA NAVAL CESNAV FUERZA NAVAL DEL GOLFO PATRULA COSTERA PUEBLA SECTOR NAVAL DE YUITALPETEN SECTOR NAVAL MILITAR COATZACOLA SECTOR NAVAL TUXPAN SEPTIMA ZONA NAVAL MILITAR ZN-7 ISLA MUJERES | 1/12/2004 | 2004-01-12 | 1/23/2004 | 2004-01-23 | YORKTOWN, VA 23690 | 40 | 44500 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 2019-07-16 | |
25e321d4-4c6d-4d0d-b33f-60be3ad7f31b | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, Regional Defense Counterterrorism Fellowship Program, FY04 | MTT WATERSIDE PORT SECUR | BATANPA-1 BRIG. NAVTOP CUARTFLOT. FRAIMPA NAVPAZ NAVTLAN PI-1123 PI-1136 ZN-10 ZN-2 ZN-4 ZN-6 | 1/26/2004 | 2004-01-26 | 2/6/2004 | 2004-02-06 | YORKTOWN, VA 23690 | 0 | 0 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 2019-07-16 | |
adf2ddd7-f52d-4628-b97d-b4c8097f7637 | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOD Western Hemisphere Region, Mexico, Non-Security Assistance, Combatant Command,FY03 | OCONUS SEM CRISIS DISASTER | 2/17/2003 | 2003-02-17 | 2/20/2003 | 2003-02-20 | YORKTOWN VA 23690 | 1 | 0 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | ||
5383daba-2970-46f5-b018-51b0a284619e | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOD Western Hemisphere Region, Mexico, Non-Security Assistance, Combatant Command,FY03 | OCONUS SEM ENVIRON PROTECT | 6/23/2003 | 2003-06-23 | 6/26/2003 | 2003-06-26 | YORKTOWN VA 23690 | 1 | 0 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | ||
3707eeec-6c85-4169-808e-983433fa37a8 | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOD Western Hemisphere Region, Mexico, Non-Security Assistance, Combatant Command,FY03 | OCONUS SEM ENVIRON PROTECT | 2/10/2003 | 2003-02-10 | 2/13/2003 | 2003-02-13 | YORKTOWN VA 23690 | 1 | 0 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | ||
bc68997d-312a-4762-b527-46f8fa35dbf1 | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOD Western Hemisphere Region, Mexico, Non-Security Assistance, Combatant Command,FY03 | OCONUS SEM INCIDENT CMD SY | 1/21/2003 | 2003-01-21 | 1/23/2003 | 2003-01-23 | YORKTOWN VA 23690 | 1 | 0 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | ||
8a3bbd25-cb9e-44e6-a81d-2960fd55d2fa | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOD Western Hemisphere Region, Mexico, Non-Security Assistance, Combatant Command,FY03 | OCONUS SEM SEARCH & RESCUE | 7/28/2003 | 2003-07-28 | 7/31/2003 | 2003-07-31 | YORKTOWN VA 23690 | 1 | 0 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | ||
065d3050-3b12-443c-9c76-016e7e1e4267 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2016 Department of Defense Training | Aerospace Medicine Primary - International | USAFSAM, Wright-Patterson AFB, OH | SEMAR | 3/21/2016 | 2016-03-21 | 5/20/2016 | 2016-05-20 | Wright Patterson AFB, OH, US | 4 | 42260 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
7f6f5f0d-7b36-4252-956b-4b217064a645 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2016 Department of Defense Training | Flight Nurse | USAFSAM, Wright-Patterson AFB, OH | SEMAR | 4/22/2016 | 2016-04-22 | 5/19/2016 | 2016-05-19 | Wright Patterson AFB, OH, US | 1 | 4465 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
8474da42-707f-4428-a986-905a93d9b0ee | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2016 Department of Defense Training | Flight Nurse | USAFSAM, Wright-Patterson AFB, OH | SEMAR | 7/18/2016 | 2016-07-18 | 8/12/2016 | 2016-08-12 | Wright Patterson AFB, OH, US | 1 | 4570 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
de56a0ce-0092-4b1f-a5af-51062d724820 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2017 Department of Defense Training | Aerospace Medicine Primary - International | USAFSAM, Wright-Patterson AFB, OH | SEMAR | 3/20/2017 | 2017-03-20 | 5/26/2017 | 2017-05-26 | Wright Patterson AFB, OH, US | 3 | 36540 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
2cb89230-cbe1-4b01-9dbc-6a97f17c68a0 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2017 Department of Defense Training | Flight Nurse | USAFSAM, Wright-Patterson AFB, OH | SEMAR | 4/28/2017 | 2017-04-28 | 5/25/2017 | 2017-05-25 | Wright Patterson AFB, OH, US | 4 | 17860 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
9f6341af-704f-4902-aecd-309d296c4484 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2019 Department of State Training | DISCS International Purchaser Finance And Logistics | DISCS - Wright Patterson AFB , OH | SEMAR | 7/8/2019 | 2019-07-08 | 7/26/2019 | 2019-07-26 | Wright Patterson AFB, OH, US | 1 | 4228 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
836b9616-a150-419b-b346-f9ceb312c5f7 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2019 Department of State Training | DISCS International Purchaser Finance And Logistics | DISCS - Wright Patterson AFB , OH | SEDENA | 8/5/2019 | 2019-08-05 | 8/23/2019 | 2019-08-23 | Wright Patterson AFB, OH, US | 2 | 8456 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
78e4f49b-53a7-4920-aef6-7c298763393a | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 333 - Fiscal Year 2019 Department of Defense Training | Aeromedical Evacuation TECH (Full Course) (AET) | USAFSAM, Wright-Patterson AFB, OH | Air Force | 8/26/2019 | 2019-08-26 | 9/25/2019 | 2019-09-25 | Wright Patterson AFB, OH, US | 2 | 10598 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
d861b032-8528-4a47-9187-994fa7bad041 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Combating Transnational Organized Crime | WJPC | El Colegio de Veracruz | 4/24/2017 | 2017-04-24 | 5/5/2017 | 2017-05-05 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 284 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
52f55d1f-ba14-499c-9e66-7f72c19226cc | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Combating Transnational Organized Crime | WJPC | Mexico National Security Commission | 4/24/2017 | 2017-04-24 | 5/5/2017 | 2017-05-05 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 284 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
ebcab14d-998c-4bb6-8151-8ed86f42a1df | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Combating Transnational Organized Crime | WJPC | Mexico Navy | 4/24/2017 | 2017-04-24 | 5/5/2017 | 2017-05-05 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 284 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
16eccd61-7463-464e-bfcb-013e6dcfdb07 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Cyber Policy Development | WJPC | ASIS International | 9/18/2017 | 2017-09-18 | 9/22/2017 | 2017-09-22 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 272 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
03f2955c-7ca6-4477-a1cf-ae30dfc97e05 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Cyber Policy Development | WJPC | Gobierno del Estado de Jalisco | 9/18/2017 | 2017-09-18 | 9/22/2017 | 2017-09-22 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 272 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
8cd71747-617e-42a1-9072-6583e807b7d5 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Cyber Policy Development | WJPC | Institute for Transparency, Public Info. and Personal Data Protection | 9/18/2017 | 2017-09-18 | 9/22/2017 | 2017-09-22 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 272 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
c432d58d-2bcd-4e80-8630-3d9f8a2b0eba | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Cyber Policy Development | WJPC | Mexico Ministry of Defense | 9/18/2017 | 2017-09-18 | 9/22/2017 | 2017-09-22 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 272 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
97fe6f6c-4e1b-4174-81e7-aadaa39c1fa0 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Cyber Policy Development | WJPC | Mexico National Security Commission | 9/18/2017 | 2017-09-18 | 9/22/2017 | 2017-09-22 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 272 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
d2cec748-3f6c-45c2-a486-5b8d22a0b31f | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Cyber Policy Development | WJPC | Mexico Navy | 9/18/2017 | 2017-09-18 | 9/22/2017 | 2017-09-22 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 272 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
1c54962b-0628-4e42-8c64-0207fe8f1c5f | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Cyber Policy Development | WJPC | US Private Enterprise | 9/18/2017 | 2017-09-18 | 9/22/2017 | 2017-09-22 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 272 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
59b90749-f47a-4c33-98d5-418747d4ea20 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Defense Policy And Complex Threats | WJPC | Centro de Estudios Superiores Navales | 3/27/2017 | 2017-03-27 | 4/7/2017 | 2017-04-07 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 730 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
d9a92c61-76b3-4db9-9257-24a39e5a2a20 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Defense Policy And Complex Threats | WJPC | Mexico National Security Commission | 3/27/2017 | 2017-03-27 | 4/7/2017 | 2017-04-07 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 730 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
793eab5f-fde1-40de-a68e-41a5dd797307 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Strategic Implications of Human Rights And Rule Of Law | WJPC | El Colegio de Veracruz | 4/24/2017 | 2017-04-24 | 5/5/2017 | 2017-05-05 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 1053 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
e8ac6588-52c9-4644-8df1-ae7071e9861f | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Strategic Implications of Human Rights And Rule Of Law | WJPC | Mexico National Security Commission | 4/24/2017 | 2017-04-24 | 5/5/2017 | 2017-05-05 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 1053 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
0b030571-ba67-437d-b199-bc660f1d8b91 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Strategic Implications of Human Rights And Rule Of Law | WJPC | Mexico Navy | 4/24/2017 | 2017-04-24 | 5/5/2017 | 2017-05-05 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 1053 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
0700d382-2cb1-4977-b17e-63f606a05554 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Strategy and Defense Policy | WJPC | Mexico Ministry of Defense | 10/10/2016 | 2016-10-10 | 10/21/2016 | 2016-10-21 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 2 | 626 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
e1d602ed-765b-496c-a506-d13ee496bece | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Strategy and Defense Policy | WJPC | Mexico Ministry of Governance | 10/10/2016 | 2016-10-10 | 10/21/2016 | 2016-10-21 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 313 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
99955fad-ae48-4beb-a21a-d74f063854c5 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Strategy and Defense Policy | WJPC | Mexico National Security Commission | 10/10/2016 | 2016-10-10 | 10/21/2016 | 2016-10-21 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 2 | 626 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
b9a6c436-755f-4953-b44a-ce0ff548d446 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Strategy and Defense Policy | WJPC | Mexico Navy | 10/10/2016 | 2016-10-10 | 10/21/2016 | 2016-10-21 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 2 | 626 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
e5aeea4c-2cd5-47f7-8c73-fbef81ef913c | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Strategy and Defense Policy | WJPC | Universidad Autónoma de Nuevo León | 10/10/2016 | 2016-10-10 | 10/21/2016 | 2016-10-21 | William J. Perry Center for Hemispheric Defense Studies, Washington, DC | 1 | 313 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
08fbc5dd-3880-452a-91f6-69ad458e04f3 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | PME - Fiscal Year 2013 Department of Defense Training | MPEP | USMA | N/A | 10/1/2012 | 2012-10-01 | 9/30/2013 | 2013-09-30 | West Point, NY | 2 | 0 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
727f831e-3887-4cfb-9943-4c885d6fcd5b | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Service Academies - Fiscal Year 2013 Department of Defense Training | Foreign Academy Exchange Program | USMA | N/A | 4/23/2013 | 2013-04-23 | 5/1/2013 | 2013-05-01 | West Point, NY | 4 | 0 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
254983a3-7875-4acd-b028-c69a19652950 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | PME - Fiscal Year 2014 Department of Defense Training | MPEP | USMA | N/A | 10/1/2013 | 2013-10-01 | 9/30/2014 | 2014-09-30 | West Point, NY | 1 | 0 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
6d03420d-83c6-4811-aa9e-94abf19821a9 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Exchange - Fiscal Year 2018 Department of Defense Training | U.S. Military Academy Foreign Academy Exchange Program | U.S. Military Academy | USMA | 3/25/2018 | 2018-03-25 | 4/5/2018 | 2018-04-05 | West Point, NY | 2 | 4500 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
2ce2178a-c910-455a-84b1-ec597d30d71b | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DoS Western Hemisphere Region, Mexico, Exchange Training, FY01 | Foreign Academy Exchg. Pr. | USMA | Mexican Army | 7/20/01 | 2001-07-20 | 8/3/01 | 2001-08-03 | West Point | 2 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
cf844786-484e-42f5-a882-f760a75d1c54 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Advanced Civil-Political-Military Relations and Democratic Leadership | CHDS | Centro de Estudios de Liderazgo | 10/17/2011 | 2011-10-17 | 11/4/2011 | 2011-11-04 | Washington, DC, United States | 1 | 6576 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
67bec834-7ec7-4656-8c11-ded519603dbb | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Advanced Civil-Political-Military Relations and Democratic Leadership | CHDS | Centro de Investigación y Seguridad Nacional | 10/17/2011 | 2011-10-17 | 11/4/2011 | 2011-11-04 | Washington, DC, United States | 1 | 6576 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
756791e4-fa50-463b-98a1-a71094fadbed | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Advanced Civil-Political-Military Relations and Democratic Leadership | CHDS | Universidad Nacional Autónoma de México | 10/17/2011 | 2011-10-17 | 11/4/2011 | 2011-11-04 | Washington, DC, United States | 1 | 6597 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
ccda0a3d-af62-48ee-98bf-94ce5d5ae714 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Caribbean Defense and Security Course | CHDS | Ministry of the Navy of Mexico | 7/16/2012 | 2012-07-16 | 7/27/2012 | 2012-07-27 | Washington, DC, United States | 1 | 3971 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
1c75cf67-6233-4862-bc76-c0df910b0f35 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Caribbean Defense and Security Course | CHDS | Secretaría de Seguridad Pública | 7/16/2012 | 2012-07-16 | 7/27/2012 | 2012-07-27 | Washington, DC, United States | 2 | 8045 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
4f97d6bd-755e-4ebd-860e-5d09026f3fea | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Combating Transnational Organized Crime | CHDS | Gobierno del Estado de Jalisco | 10/24/2011 | 2011-10-24 | 11/4/2011 | 2011-11-04 | Washington, DC, United States | 1 | 5189 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
16bb61bf-fd71-4492-9110-b4170431a5e4 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Combating Transnational Organized Crime | CHDS | Secretaría de Seguridad Pública | 9/10/2012 | 2012-09-10 | 9/21/2012 | 2012-09-21 | Washington, DC, United States | 1 | 4292 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
6c9cce8b-b5a8-47af-a54c-feb30f0b46e2 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Combating Transnational Organized Crime | CHDS | Universidad Nacional Autónoma de México | 9/10/2012 | 2012-09-10 | 9/21/2012 | 2012-09-21 | Washington, DC, United States | 2 | 8760 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
b7a3b1a9-cfd3-4427-83b2-5b232b2c125c | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Countering Narcotics and the Illicit Commons | ACSS | Gobierno del Estado de Jalisco | 2/13/2012 | 2012-02-13 | 2/17/2012 | 2012-02-17 | Washington, DC, United States | 1 | 5450 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
e2f00ef9-0494-4382-b8c7-28bbfa601768 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Countering Narcotics and the Illicit Commons | ACSS | Procuraduría General | 2/13/2012 | 2012-02-13 | 2/17/2012 | 2012-02-17 | Washington, DC, United States | 1 | 5280 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
14e1d754-17c8-49db-b823-85196809966a | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Perspectives on Homeland Security and Defense | CHDS | Centro de Estudios Superiores Navales | 4/16/2012 | 2012-04-16 | 4/27/2012 | 2012-04-27 | Washington, DC, United States | 1 | 5250 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
4dd91042-1a58-44b5-9554-806135fef89b | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Perspectives on Homeland Security and Defense | CHDS | Confidence Bureau & Integral Services | 4/16/2012 | 2012-04-16 | 4/27/2012 | 2012-04-27 | Washington, DC, United States | 1 | 5250 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 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]);