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:recipient_unit descending
This data as json, CSV (advanced)
Suggested facets: qa:training_source_url, training:start_date (date), training:end_date (date), qa:training_date_first_seen (date), qa:training_date_scraped (date)
qa:training_group 20 ✖
- 2009_2010_Western_Hemisphere_fmtrpt.tsv 619
- 2010_2011_Western_Hemisphere_fmtrpt.tsv 599
- 2008_2009_Western_Hemisphere_fmtrpt.tsv 555
- 2016_2017_Western_Hemisphere_fmtrpt.tsv 413
- 2002_2003_Western_Hemisphere_fmtrpt.tsv 378
- 2003_2004_Western_Hemisphere_fmtrpt.tsv 340
- 2012_2013_Western_Hemisphere_fmtrpt.tsv 318
- 2001_2002_Western_Hemisphere_fmtrpt.tsv 314
- 2007_2008_Western_Hemisphere_fmtrpt.tsv 310
- 2018_2019_Western_Hemisphere_fmtrpt.tsv 299
- 2013_2014_Western_Hemisphere_fmtrpt.tsv 296
- 2017_2018_Western_Hemisphere_fmtrpt.tsv 296
- 2015_2016_Western_Hemisphere_fmtrpt.tsv 278
- 2014_2015_Western_Hemisphere_fmtrpt.tsv 263
- 2019_2020_Western_Hemisphere_fmtrpt.tsv 239
- 2011_2012_Western_Hemisphere_fmtrpt.tsv 230
- 2004_2005_Western_Hemisphere_fmtrpt.tsv 225
- 2005_2006_All_Regions_fmtrpt.tsv 175
- 2020_2021_Western_Hemisphere_fmtrpt.tsv 160
- 2006_2007_Western_Hemisphere_fmtrpt.tsv 53
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
a1fb7120-2bdf-4dab-801f-3f529e0d9f4e | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | RULE LAW&DISCP MIL OPS FOT | st Search & Rescue Sq, Salina Cruz, Oaxaca | 8/22/01 | 2001-08-22 | 8/28/01 | 2001-08-28 | LACKLAND AFB, TX 78236-5706 | 1 | 135 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
e6aa4738-dc4b-47a8-9637-4e21a8395b2c | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - FY 2006 DoD Training | MTT-Legal Aspects | - | s-S SEDENA Hqs | 1/16/2006 | 2006-01-16 | 1/20/2006 | 2006-01-20 | Ma. Isabel Slheraton Hotel | 20 | 31343 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
79126d92-5b71-4e2c-8cee-3be3de24b0bf | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | INSTRUCTOR TRAINING | nfantry Battalion, Toluca, Estado de Mexico | 6/25/01 | 2001-06-25 | 7/18/01 | 2001-07-18 | FORT BENNING GA 31905-6245 | 1 | 427 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
dede97d5-5536-47ae-be64-8bf9ebf4b63d | 15615dc2-0798-4dd7-84fe-b12d603b4601 | 2005_2006_All_Regions_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY05 | CR | de Mexico, MX | https://2009-2017.state.gov/documents/organization/75058.pdf | Not checked against source; verify accuracy before use | 2006-09 | 2019-07-16 | ||||||||
e0aca942-053e-40f2-ada1-a90445bec86e | 048fb2d9-6651-4ba0-b36a-a526539f4cfd | 2002_2003_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, Section 1004, FY 02 | SPECIALIZED ENG LANG TNG | ar Coll, Zapopan,Jalisco | 2/4/02 | 2002-02-04 | 4/5/02 | 2002-04-05 | LACKLAND AFB, TX 78236 | 1 | 6178 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
262174a5-9492-4fd5-b8f4-bbd00f671a91 | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY03 | SPECIALIZED ENG LANG TNG | Woman Specialties Clinic, Mil Central Hosp,Mexico, D.F. | 7/7/2003 | 2003-07-07 | 9/5/2003 | 2003-09-05 | SAN ANTONIO TX 78236-5259 | 1 | 4254 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
bbfb1dbc-b2eb-4f58-b132-54b695f3d955 | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY04 | OBS MED/HEALTH/HYG-CONUS | Woman Specialties Clinic, Mil Central Hosp,Mexico, D.F. | 9/15/2003 | 2003-09-15 | 11/14/2003 | 2003-11-14 | FT SAM HOUSTON TX 78234-6100 | 1 | 250 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 2019-07-16 | |
28b1dd63-d067-449f-a8ee-ebe889b57867 | 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 | LANGUAGE INSTRUCTOR/BASIC | War Materiel Mil School, Santa Fe, Mexico,D.F. | 6/3/2002 | 2002-06-03 | 12/6/2002 | 2002-12-06 | LACKLAND AFB, TX 78236 | 1 | 16048 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
8e4fce9d-4b7a-4a9e-a283-47f3e62c9775 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2016 Department of Defense Training | TCCC MTT3 | RAF - 9 | Various MX units | 2/29/2016 | 2016-02-29 | 3/4/2016 | 2016-03-04 | Mexico City, Mexico | 50 | 23890 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
1a6bab2b-a004-40c9-ae1f-a400a7006c78 | 15615dc2-0798-4dd7-84fe-b12d603b4601 | 2005_2006_All_Regions_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, Drug Interdiction and Counter-Drug Activities, Section 1004, FY05 | Patrol Boat Operator Training | SAO Uzbekistan | Uzbek Border Forces | 10/19/2004 | 2004-10-19 | 10/30/2004 | 2004-10-30 | Termez | 10 | 45000 | https://2009-2017.state.gov/documents/organization/75058.pdf | Not checked against source; verify accuracy before use | 2006-09 | 2019-07-16 |
74b6a137-66f8-4ea4-b4da-bd84fc1644b2 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2016 Department of Defense Training | Program In Applied Security Studies | Marshall Center | Unknown | 9/29/2015 | 2015-09-29 | 11/13/2015 | 2015-11-13 | Garmisch, GY | 1 | 22088 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
ffe94d80-b0f1-4a51-bcae-92b7d1c48681 | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, DoD Regional Centers for Strategic Studies, FY04 | CHDS Programs | Center for Hemispheric Defense Studies | University of Guadalajara, University of Quintana Roo | 4/26/2004 | 2004-04-26 | 5/14/2004 | 2004-05-14 | Washington, DC | 2 | 11400 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 2019-07-16 |
3359e89b-e1da-4d9c-a5b2-e82836e2241b | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2012 Department of Defense Training | NationLab, 2011 CESNAV | CHDS | Universidad de Guadalajara | 11/14/2011 | 2011-11-14 | 11/18/2011 | 2011-11-18 | Mexico City, Mexico | 1 | 84 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
43cbcd48-02b5-49d6-a5d6-e70f44cded8a | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2013 Department of Defense Training | Strategy and Defense Policy | N/A | Universidad de Guadalajara | 3/4/2013 | 2013-03-04 | 3/22/2013 | 2013-03-22 | Washington, DC, United States | 1 | 1097 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
87ee1c83-3574-4633-91f8-d07e8536041d | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2014 Department of Defense Training | Strategy and Defense Policy | WJPC | Universidad de Guadalajara | 5/5/2014 | 2014-05-05 | 5/16/2014 | 2014-05-16 | Washington D.C., US | 1 | 2634 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
6cc31bcd-8965-459d-984d-f97f483ce177 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2015 Department of Defense Training | Combating Transnational Organized Crime | William J. Perry Center for Hemispheric Defense Studies | Universidad de Guadalajara | 5/11/2015 | 2015-05-11 | 5/22/2015 | 2015-05-22 | Washington D.C., USA | 1 | 448 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
98f55f8d-c242-4473-ab4c-fdbb8b0c4b9f | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2016 Department of Defense Training | Confronting Transnational Threats in the Americas | William J. Perry Center for Hemispheric Defense Studies | Universidad de Guadalajara | 4/3/2016 | 2016-04-03 | 4/9/2016 | 2016-04-09 | Mexico City, Mexico | 1 | 477 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
bdae709a-828d-48f3-9a2e-c42de2d28551 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2018 Department of Defense Training | Strategic Implications Of HR And Rule Of Law | William J. Perry Center for Hemispheric Defense Studies (WJPC) | Universidad de Guadalajara | 5/14/2018 | 2018-05-14 | 5/25/2018 | 2018-05-25 | Washington, D.C. | 1 | 4804 | 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 |
0f3f2dcc-3787-4977-b9fc-cbb6b09995c2 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2015 Department of Defense Training | Strategy and Defense Policy | William J. Perry Center for Hemispheric Defense Studies | Universidad de Ciencias de la Seguridad del Estado de Nuevo León | 10/20/2014 | 2014-10-20 | 10/31/2014 | 2014-10-31 | Washington D.C., USA | 1 | 335 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 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 |
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 |
019d7aa4-423a-46c5-92a5-7b5fce7d2434 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2012 Department of Defense Training | NationLab, 2011 CESNAV | CHDS | Universidad Nacional Autónoma de México | 11/14/2011 | 2011-11-14 | 11/18/2011 | 2011-11-18 | Mexico City, Mexico | 2 | 168 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
8099fba5-6712-4cea-90c1-3beeb31a9609 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2016 Department of Defense Training | Illicit Commons: Drugs, Guns, & People Workshop | Near East South Asia Center for Strategic Studies | Universidad Nacional Autónoma de México | 7/18/2016 | 2016-07-18 | 7/21/2016 | 2016-07-21 | Casablanca, Morocco | 1 | 615 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
58cb55c1-2f6b-4126-87c7-83be21e2fd40 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2016 Department of Defense Training | Regional Transnational Threats Seminar - Central America | William J. Perry Center for Hemispheric Defense Studies | Universidad Nacional Autónoma de México | 9/7/2016 | 2016-09-07 | 9/9/2016 | 2016-09-09 | San José, Costa Rica | 1 | 839 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
366d8e63-393f-48ea-ad8e-c078b1afcd94 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2016 Department of Defense Training | Strategic Implications Of HR And Rule Of Law | William J. Perry Center for Hemispheric Defense Studies | Universidad Nacional Autónoma de México | 6/13/2016 | 2016-06-13 | 6/24/2016 | 2016-06-24 | Washington, D.C. | 2 | 788 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
cb9149aa-7617-4cb0-9ef0-677785b2c121 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2013 Department of Defense Training | Perspectives on Homeland Security and Defense | N/A | Universidad Nacional Autónoma de Mexico | 4/15/2013 | 2013-04-15 | 4/26/2013 | 2013-04-26 | Washington, DC, United States | 1 | 1441 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
d7421587-ff30-4a0c-83bf-b8a07dcbf13e | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2013 Department of Defense Training | NationLab CESNAV | N/A | Universidad Nacional Autónoma de Mexico | 11/5/2012 | 2012-11-05 | 11/9/2012 | 2012-11-09 | Mexico City, Mexico | 1 | 114 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
76b6044b-498a-4a45-97cb-061e7ed76a3d | 048fb2d9-6651-4ba0-b36a-a526539f4cfd | 2002_2003_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOD Western Hemisphere Region, Mexico, Center For Hemispheric Defense Studies(CHDS),FY02 | CHDS Programs | Center for Hemispheric Defense Studies | Universidad IberoAmericana | 7/15/02 | 2002-07-15 | 8/2/02 | 2002-08-02 | Washington, DC | 1 | 7999 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 |
cd568c17-d98b-4488-8ba9-d53ef6aa57b5 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2015 Department of Defense Training | Strategic Implications of Human Rights and Rule of Law | William J. Perry Center for Hemispheric Defense Studies | Universidad IberoAmericana | 5/11/2015 | 2015-05-11 | 5/22/2015 | 2015-05-22 | Washington D.C., USA | 1 | 1485 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
ada9e02a-2f4f-4b1d-bfd6-ac2ddfababf1 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2016 Department of Defense Training | Confronting Transnational Threats in the Americas | William J. Perry Center for Hemispheric Defense Studies | Universidad IberoAmericana | 4/3/2016 | 2016-04-03 | 4/9/2016 | 2016-04-09 | Mexico City, Mexico | 2 | 954 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
9a0ed4a9-a48a-44aa-aada-ad4f695c1522 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2014 Department of Defense Training | Strategy and Defense Policy | WJPC | Universidad Autónoma de Nuevo León | 9/23/2013 | 2013-09-23 | 10/11/2013 | 2013-10-11 | Washington D.C., US | 2 | 2700 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
1f8abb8d-965e-4210-b54f-bd072ef8346e | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Program On Countering Transnational Organized Crime (CTOC) | GCMC | Universidad Autónoma de Nuevo León | 11/30/2016 | 2016-11-30 | 12/15/2016 | 2016-12-15 | George C. Marshall European Center for Security Studies, Garmisch-Partenkirchen, Germany | 1 | 4361 | 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 |
007466c6-4d8f-47c2-8972-f16972cc43a6 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2018 Department of Defense Training | Regional Transnational Threats Seminar | William J. Perry Center for Hemispheric Defense Studies (WJPC) | Universidad Autónoma de Nuevo León | 6/5/2018 | 2018-06-05 | 6/7/2018 | 2018-06-07 | Panama City, PN | 1 | 2166 | 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 |
e66a3976-dbf9-4abc-b59d-028aaf60fc08 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2019 Department of Defense Training | ENGLISH LANGUAGE ENHANCEMENT COURSE (ELEC) | GCMC | Universidad Autónoma de Nuevo León | 6/5/2019 | 2019-06-05 | 7/9/2019 | 2019-07-09 | Garmisch-Partenkirchen, Germany | 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 |
66481cc9-12c8-4f98-9222-fe69c5700b3f | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2019 Department of Defense Training | PROGRAM ON COUNTERING TRANSNATIONAL ORGANIZED CRIME | GCMC | Universidad Autónoma de Nuevo León | 7/10/2019 | 2019-07-10 | 8/1/2019 | 2019-08-01 | Garmisch-Partenkirchen, Germany | 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 |
2f3d546d-6ccf-40ab-8597-68d42f13bd63 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2018 Department of Defense Training | Strategic Implications Of HR And Rule Of Law | William J. Perry Center for Hemispheric Defense Studies (WJPC) | Universidad Autónoma de Ciudad Juárez | 5/14/2018 | 2018-05-14 | 5/25/2018 | 2018-05-25 | Washington, D.C. | 1 | 4844 | 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 |
2cb4bd28-22a1-41b9-a63e-322756a11234 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2015 Department of Defense Training | Strategy and Defense Policy | William J. Perry Center for Hemispheric Defense Studies | Universidad Autónoma Metropolitana | 10/20/2014 | 2014-10-20 | 10/31/2014 | 2014-10-31 | Washington D.C., USA | 1 | 335 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
dadbf054-32b1-44a9-826e-3ef1f0c6997f | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2016 Department of Defense Training | Combating Transnational Organized Crime | William J. Perry Center for Hemispheric Defense Studies | Universidad Autónoma Metropolitana | 6/13/2016 | 2016-06-13 | 6/24/2016 | 2016-06-24 | Washington, D.C. | 1 | 353 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
8af28e54-7460-477e-a58b-2e4d711053ac | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2016 Department of Defense Training | Confronting Transnational Threats in the Americas | William J. Perry Center for Hemispheric Defense Studies | Universidad Autónoma Metropolitana | 4/3/2016 | 2016-04-03 | 4/9/2016 | 2016-04-09 | Mexico City, Mexico | 1 | 477 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
b1bef4a9-82f9-48ad-8701-33cc5164e9a5 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2020 Department of Defense Training | Strategy And Defense Policy | WJPC - 0 | Universidad Abierta y a Distancia de la Ciudad de México | 10/21/2019 | 2019-10-21 | 11/1/2019 | 2019-11-01 | Washington, DC | 1 | 3967 | 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 |
5940e392-9ce2-497d-93c8-899bec9b9907 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2015 Department of Defense Training | Strategic Implications of Human Rights and Rule of Law | William J. Perry Center for Hemispheric Defense Studies | Universidad Abierta y a Distancia de la Ciudad de México | 5/11/2015 | 2015-05-11 | 5/22/2015 | 2015-05-22 | Washington D.C., USA | 1 | 1485 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
8c4a6a05-2a35-4895-89b5-fe3553935248 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2017 Department of Defense Training | Global CTOC Community of Interest | GCMC | United Kingdom, National Council of Science and Technology, University of Bath | 2/22/2017 | 2017-02-22 | 2/24/2017 | 2017-02-24 | George C. Marshall European Center for Security Studies, Garmisch-Partenkirchen, Germany | 1 | 556 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
06c92d66-74ac-42fd-9e9a-2e33d3a5908c | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2018 Department of Defense Training | Program In Applied Security Studies | George C. Marshall European Center for Security Studies | United Kingdom University of Bath | 9/6/2017 | 2017-09-06 | 11/16/2017 | 2017-11-16 | Garmisch-Partenkirchen, Germany | 1 | 2750 | 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 |
911b6aba-75fd-4e9d-bb08-339c8808b0b5 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - FY 2006 DoD Training | MTT-Legal Aspects | - | Unidad Juridica | 1/16/2006 | 2006-01-16 | 1/20/2006 | 2006-01-20 | Ma. Isabel Slheraton Hotel | 1 | 1567.15 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
7d9ea9f7-1e33-45fd-b9c3-be77c450f943 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | UH-60 INSTRUCTOR PILOT (SP) | US unit not specified in 2008-2009 report | Unidad Esp.Transp. Aereo del Alto Mando,(UETAAM),Aerop.Intl, D.F. | 8/20/2007 | 2007-08-20 | 10/16/2007 | 2007-10-16 | AVIATION SCHOOL | 1 | 147786 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
d2fa9ea3-fa70-4630-9f62-d1b92b317420 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | UH-60 INSTRUCTOR PILOT (SP) | US unit not specified in 2008-2009 report | Unidad Esp.Transp. Aereo del Alto Mando,(UETAAM),Aerop.Intl, D.F. | 9/13/2007 | 2007-09-13 | 10/16/2007 | 2007-10-16 | AVIATION SCHOOL | 1 | 14468 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
254fd096-309b-40ad-b3f8-d81bc855e361 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Service Academies - Fiscal Year 2014 Department of Defense Training | United States Naval Academy | USNA | USNA | 10/1/2013 | 2013-10-01 | 9/30/2014 | 2014-09-30 | Annapolis, MD | 2 | 155033 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
219f92b3-af01-4614-82c7-ce42849e1c56 | 7afbcfe9-7e9d-4a45-8c24-c9246a4b250e | 2015_2016_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Service Academies - Fiscal Year 2015 Department of Defense Training | United States Naval Academy | N/A | USNA | 10/1/2014 | 2014-10-01 | 9/30/2015 | 2015-09-30 | United States Naval Academy, Annapolis, MD, USA | 2 | 155182 | https://2009-2017.state.gov/documents/organization/265162.pdf | Not checked against source; verify accuracy before use | 2016 | 2019-07-16 |
f6771a84-ca79-4d66-9f97-da79e7e52d74 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Exchange - Fiscal Year 2020 Department of Defense Training | FAEP - 10 Day Cultural Exchange | USMA - 0 | USMA | 3/1/2020 | 2020-03-01 | 4/1/2020 | 2020-04-01 | Mexico Military Academy | 2 | 10800 | 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 |
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 |
cb6bea15-d206-4ac9-b66c-7d6a54fea474 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Service Academies - Fiscal Year 2020 Department of Defense Training | United States Air Force Academy | USAFA - 0 | USAFA | 6/1/2019 | 2019-06-01 | 6/1/2020 | 2020-06-01 | Colorado Springs, CO | 1 | 82235 | 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 |
acb97b78-dcbe-46eb-868d-b934aee1cb53 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Service Academies - Fiscal Year 2019 Department of Defense Training | United States Air Force Academy | USAFA | USAFA | 6/1/2018 | 2018-06-01 | 6/1/2019 | 2019-06-01 | USAFA Colorado Springs CO | 1 | 80278 | 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 |
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 |
e7dcd76b-b3a3-4fdd-bca0-0a56bf7653cc | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Impact Of Pandemics On Migration And Refugees | GCMC - 0 | UNK | 6/25/2020 | 2020-06-25 | 6/25/2020 | 2020-06-25 | Virtural Event | 2 | 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 |
51851299-a657-4bd9-9dc3-b876b241013d | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - WPS: 20 years since Resolution 1325 – Where are we, where do we go from here. | GCMC - 0 | UNK | 8/25/2020 | 2020-08-25 | 8/25/2020 | 2020-08-25 | Virtural Event | 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 |
6dfeaa99-2810-4121-b5f8-81b5f1efe2b4 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - FY 2007 DoD Training | Senior Executive Seminar 07-6 | US unit not specified in 2007-2008 report | UNK | 8/20/2007 | 2007-08-20 | 8/31/2007 | 2007-08-31 | Marshall Center Garmisch, Germany | 1 | 2640 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
3d37f5c2-4f95-4d7b-8c2a-2d7fdd039cf3 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2011 Department of Defense Training | INTER-AGENCY COORDINATION AND COMBATING TERRORISM | CTR FOR HEMISPHERIC DEF STUDIES - N/A | UNIVERSIDAD NACIONAL AUTONOMA DE MEXICO | 6/6/2011 | 2011-06-06 | 6/24/2011 | 2011-06-24 | CTR FOR HEMISPHERIC DEF STUDIES (NDU) | 1 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 | |
6ac801c5-9510-474e-a889-fce01575aa1f | 048fb2d9-6651-4ba0-b36a-a526539f4cfd | 2002_2003_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOS Western Hemisphere Region, Mexico, International Narcotics and Law Enforcement (INL),FY02 | RULE LAW&DISCP MIL OPS FOT | Transmissions Mil School, Mexico, D.F. | 3/18/02 | 2002-03-18 | 3/22/02 | 2002-03-22 | LACKLAND AFB, TX 78236-5706 | 1 | 155 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
6295677a-a727-4b10-a5ce-c9ba66555256 | 048fb2d9-6651-4ba0-b36a-a526539f4cfd | 2002_2003_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Narcotics and Law Enforcement (INL), FY 02 | SPECIAL COMMUNICATIONS CRS | Transmissions Mil School, Mexico, D.F. | 1/16/02 | 2002-01-16 | 3/15/02 | 2002-03-15 | LACKLAND AFB, TX 78236-5706 | 1 | 376 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
b03e4bf8-dcd9-4d29-b88d-4f7e5c393e0c | 048fb2d9-6651-4ba0-b36a-a526539f4cfd | 2002_2003_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Narcotics and Law Enforcement (INL), FY 02 | RULE LAW&DISCP MIL OPS FOT | Transmissions Log Bn, Mexico, D.F. | 3/18/02 | 2002-03-18 | 3/22/02 | 2002-03-22 | LACKLAND AFB, TX 78236-5706 | 1 | 155 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
23a4af82-c1a2-4dec-9829-f21ad0131520 | 048fb2d9-6651-4ba0-b36a-a526539f4cfd | 2002_2003_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Narcotics and Law Enforcement (INL), FY 02 | SPECIAL COMMUNICATIONS CRS | Transmissions Log Bn, Mexico, D.F. | 1/16/02 | 2002-01-16 | 3/15/02 | 2002-03-15 | LACKLAND AFB, TX 78236-5706 | 1 | 376 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
a1bb7927-7df9-4c93-bc2d-0f59a94c6f42 | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOS Western Hemisphere Region, Mexico, International Narcotics and Law Enforcement (INL),FY03 | SPECIAL COMM CRS (PRIMARY) | Transm. Section,36th Mil Zone, Tapachula, Chiapas, MX | 6/2/2003 | 2003-06-02 | 6/27/2003 | 2003-06-27 | LACKLAND AFB, TX 78236-5706 | 1 | 265 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
ba939cc8-166a-4fb6-a13b-dd8dcedda772 | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOS Western Hemisphere Region, Mexico, International Narcotics and Law Enforcement (INL),FY03 | SPECIAL COMM CRS (PRIMARY) | Transm. Section, 8th Mil Zone, Tancol, Tamaulipas, MX | 6/2/2003 | 2003-06-02 | 6/27/2003 | 2003-06-27 | LACKLAND AFB, TX 78236-5706 | 1 | 265 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
2e3157bd-8b22-45b1-bb59-64c6359dd1e6 | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOS Western Hemisphere Region, Mexico, International Narcotics and Law Enforcement (INL),FY03 | SPECIAL COMM CRS (PRIMARY) | Transm. Section, 24th Mil Zone, Cuernavaca, Morelos, MX | 6/2/2003 | 2003-06-02 | 6/27/2003 | 2003-06-27 | LACKLAND AFB, TX 78236-5706 | 1 | 265 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
2ac8e8b2-15da-4a57-b390-eb792d9f9260 | 048fb2d9-6651-4ba0-b36a-a526539f4cfd | 2002_2003_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Narcotics and Law Enforcement (INL), FY 02 | RULE LAW&DISCP MIL OPS FOT | Transm Platoon,Mil Field No. 1-F, Mexico, D.F. | 3/18/02 | 2002-03-18 | 3/22/02 | 2002-03-22 | LACKLAND AFB, TX 78236-5706 | 1 | 1574 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
7e6deb06-7228-496d-b5d9-16952a93c41e | 048fb2d9-6651-4ba0-b36a-a526539f4cfd | 2002_2003_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Narcotics and Law Enforcement (INL), FY 02 | SPECIAL COMMUNICATIONS CRS | Transm Platoon,Mil Field No. 1-F, Mexico, D.F. | 3/27/02 | 2002-03-27 | 5/17/02 | 2002-05-17 | LACKLAND AFB, TX 78236-5706 | 1 | 2836 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
d2b863a9-3f1e-49ec-8135-b980230a2ba4 | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOS Western Hemisphere Region, Mexico, International Narcotics and Law Enforcement (INL),FY03 | SPECIAL COMM CRS (PRIMARY) | Trans Log Btn, Tacuba, Mexico, D.F. | 6/2/2003 | 2003-06-02 | 6/27/2003 | 2003-06-27 | LACKLAND AFB, TX 78236-5706 | 1 | 265 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
24e6d4c2-4f87-413b-824c-aad47f946c02 | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOS Western Hemisphere Region, Mexico, International Military Education and Training (IMET),FY03 | ACFT ELECTR FUNDAMENTALS | Tercer Escuadron Ala Mobil de Exploracion y Transporte | 5/1/2003 | 2003-05-01 | 8/15/2003 | 2003-08-15 | LACKLAND AFB, TX 78236-5706 | 1 | 3834 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
ac4c7533-b291-4c31-a8fb-daf31a35905c | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY03 | RULE LAW&DISCP MIL OPS FOT | Tercer Escuadron Ala Mobil de Exploracion y Transporte | 8/18/2003 | 2003-08-18 | 8/21/2003 | 2003-08-21 | LACKLAND AFB, TX 78236-5706 | 1 | 205 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
2e0059c1-beba-4118-8901-4ad4ddee16f4 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2012 Department of Defense Training | NationLab, 2011 CESNAV | CHDS | Tax Administration of Mexico | 11/14/2011 | 2011-11-14 | 11/18/2011 | 2011-11-18 | Mexico City, Mexico | 1 | 84 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
3d7ba0e5-089e-4344-8d32-10f4bcd4798b | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2013 Department of Defense Training | NationLab CESNAV | N/A | Tax Administration of Mexico | 11/5/2012 | 2012-11-05 | 11/9/2012 | 2012-11-09 | Mexico City, Mexico | 1 | 114 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 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 | |
7d28f39a-98d9-4a8a-ba82-ada82f3780a7 | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY03 | HELICOPTER CREW CHIEF | TERCER ESCUADRON ALA MOVIL DE EXPLORACION Y TRANSPORTE, CHETUMAL Q. ROO | 1/8/2003 | 2003-01-08 | 4/23/2003 | 2003-04-23 | LACKLAND AFB, TX 78236-5706 | 1 | 3834 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
8a49f5dd-274d-47a9-acb3-f9133d92ceb8 | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY03 | RULE LAW&DISCP MIL OPS FOT | TERCER ESCUADRON ALA MOVIL DE EXPLORACION Y TRANSPORTE, CHETUMAL Q. ROO | 4/23/2003 | 2003-04-23 | 4/26/2003 | 2003-04-26 | LACKLAND AFB, TX 78236-5706 | 1 | 205 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
5fe4a26d-b647-4e67-9fa1-a15990be17db | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOD Western Hemisphere Region, Mexico, Drug Interdiction and Counter-Drug Activities, Section 1004, FY04 | DEF RES MGT CRS | Subdirector, Secretaria de Marina | 8/16/2004 | 2004-08-16 | 9/10/2004 | 2004-09-10 | MONTEREY, CA 93943-5201 | 1 | 8392 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 2019-07-16 | |
646d0939-4e59-411c-b047-b74d5f1e2d54 | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOD Western Hemisphere Region, Mexico, Drug Interdiction and Counter-Drug Activities, Section 1004, FY04 | DEF RES MGT CRS | Subdirector Compras Importacion, Secretaria de Marina | 1/5/2004 | 2004-01-05 | 1/30/2004 | 2004-01-30 | MONTEREY, CA 93943-5201 | 1 | 8392 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 2019-07-16 | |
7aeec9b5-c804-4b13-b1d3-582c03c2dacf | 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 | CIV-MIL SID - SOUTHCOM | State&Local Coord, Interior Sec, Mexico, D.F. | 2/4/02 | 2002-02-04 | 2/15/02 | 2002-02-15 | HURLBURT FIELD, FL 32544-5826 | 1 | 3715 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
72cffaa0-7050-4703-8392-106b36aebf40 | 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 | PLANNING PEACE OPS | Staff, Law,Rules&Nav Doctr Comm,Navy Hqs | 7/15/02 | 2002-07-15 | 7/26/02 | 2002-07-26 | MONTEREY, CA 93943-5001 | 1 | 6110 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
3ea0a8a8-1413-459c-a846-15f040637055 | 048fb2d9-6651-4ba0-b36a-a526539f4cfd | 2002_2003_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, Section 1004, FY 02 | INFORMATION OPERATIONS | Staff, Defensa Hqs, Mexico, D.F. Staff, Defensa Hqs, Mexico, D.F. | 2/11/02 | 2002-02-11 | 4/11/02 | 2002-04-11 | FORT BENNING GA 31905-6245 | 1 | 1623 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
cb977e1e-b66b-40a5-822d-b0b2f9466fb0 | 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 | GENERAL ENGLISH ONLY | Staff, Chief Section, MAF Hqs, Mexico, D.F. | 3/25/02 | 2002-03-25 | 5/31/02 | 2002-05-31 | LACKLAND AFB, TX 78236 | 1 | 3492 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
b9e7b68d-8aac-400a-b4db-40abb2f46197 | 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 | INTL OFF SCH (FOR AWC) | Staff, Chief Section, MAF Hqs, Mexico, D.F. | 6/10/02 | 2002-06-10 | 7/19/02 | 2002-07-19 | MAXWELL AFB, AL 36112-6323 | 1 | 3895 | https://2009-2017.state.gov/documents/organization/21823.pdf | Not checked against source; verify accuracy before use | 2003-05 | 2019-07-16 | |
1a852283-744f-4ab9-832e-ea617a9c131d | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY03 | AIR WAR COLLEGE | Staff, Chief Section, MAF Hqs, Mexico, D.F. | 7/29/2002 | 2002-07-29 | 6/2/2003 | 2003-06-02 | MAXWELL AFB, AL 36112-6323 | 1 | 13590 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
77782d3f-de04-47e2-a7dd-b2cac9014bc1 | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY03 | SPECIALIZED ENG LANG TNG | Staff Chief, Parachute Bde, Mil Field No. 1, Mexico, D.F. | 4/28/2003 | 2003-04-28 | 6/27/2003 | 2003-06-27 | SAN ANTONIO TX 78236-5259 | 1 | 4254 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
2835a250-0866-4efa-b38f-e58786f22f6b | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY04 | ARMY WAR COLLEGE (RES CRS) | Staff Chief, Parachute Bde, Mil Field No. 1, Mexico, D.F. | 7/7/2003 | 2003-07-07 | 6/12/2004 | 2004-06-12 | CARLISLE BKS PA 17013-5050 | 1 | 21721 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 2019-07-16 | |
edee960f-09ce-44d6-b078-affa10fd0c16 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | INL - Fiscal Year 2011 Department of State Training | AVIONICS COMM/NAV EQUIP | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Srcreataría de Seguridad Pública | 2/11/2011 | 2011-02-11 | 5/10/2011 | 2011-05-10 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 9352 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
81f11991-1fb3-4dad-ab56-824d79d65686 | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY04 | INTL OFF SCH (FOR AC&SC) | Sq Cmdt, Aviation Military School; Zapopan, Jalisco, MX | 6/14/2004 | 2004-06-14 | 7/23/2004 | 2004-07-23 | MAXWELL AFB, AL 36112-6323 | 0 | 4965 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 2019-07-16 | |
75fc2436-9ac6-401f-be23-1f901723df7b | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY04 | SPECIALIZED ENG LANG TNG | Sq Cmdt, Aviation Military School; Zapopan, Jalisco, MX | 4/5/2004 | 2004-04-05 | 6/4/2004 | 2004-06-04 | LACKLAND AFB, TX 78236 | 1 | 3278 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 2019-07-16 | |
016cd8b4-1985-416e-addb-27cc5f9d36c4 | 15615dc2-0798-4dd7-84fe-b12d603b4601 | 2005_2006_All_Regions_fmtrpt.tsv | Mexico | MEX | DOS Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY05 | AIR COMD & STAFF COLLEGE | Sq Cmdt, Aviation Military School; Zapopan, Jalisco, MX | 8/3/2004 | 2004-08-03 | 6/7/2005 | 2005-06-07 | MAXWELL AFB, AL 36112 | 1 | 7540 | https://2009-2017.state.gov/documents/organization/75058.pdf | Not checked against source; verify accuracy before use | 2006-09 | 2019-07-16 | |
d7f69973-59c0-4c38-a8a9-4dc44b1fff6c | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | SPECIALIZED ENG LANG TNG | Special Forces, General Hqs, Mexico, D.F. | 5/21/01 | 2001-05-21 | 7/20/01 | 2001-07-20 | SAN ANTONIO TX 78236-5259 | 1 | 3058 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
1c05dea5-1fc6-47fc-9026-5e40764ca580 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - FY 2006 DoD Training | CG Development/Needs Assessment | - | Special Forces Gulf and Pacific; N/Aval HQS | 9/19/2006 | 2006-09-19 | 9/29/2006 | 2006-09-29 | Ciudad del Carmen and Veracruz | 6 | 15103.44 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
bc6f270f-fa10-4ace-8e2f-29ee6a581f85 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - FY 2006 DoD Training | CG Development/Needs Assessment | - | Special Forces Gulf and Pacific | 9/19/2006 | 2006-09-19 | 9/29/2006 | 2006-09-29 | Ciudad del Carmen and Veracruz | 2 | 5034.48 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
4666147d-b8e6-410d-abc1-d302cb20667c | 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 | DEPARTMENT RESOURCE MGT | South Task Force, Minatitlan, Veracruz | 1/13/2003 | 2003-01-13 | 2/20/2003 | 2003-02-20 | FORT BENNING GA 31905-6245 | 1 | 1674 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
67739fdc-6b95-4ee7-92eb-87c7c5c1020c | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY04 | LANGUAGE INSTRUCTOR/BASIC | Signal Commun. Mil School, Mexico, D.F. | 7/28/2003 | 2003-07-28 | 1/30/2004 | 2004-01-30 | LACKLAND AFB, TX 78236 | 1 | 8584 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 2019-07-16 | |
f5d3915b-350a-47e8-acf2-ec30062fcd49 | 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 | MANAGING ENG LANG TNG(MELT | Sergeant Branches Mil School, Puebla, Puebla | 8/19/2002 | 2002-08-19 | 10/11/2002 | 2002-10-11 | LACKLAND AFB, TX 78236 | 1 | 5805 | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |
f985ea55-d9f9-499d-a25b-76a559305df4 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2019 Department of Defense Training | Cyber Policy Development | WJPC | Security Analysis with Democracy Group | 9/16/2019 | 2019-09-16 | 9/27/2019 | 2019-09-27 | Washington, DC, USA | 1 | 1983 | 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 |
5f78d6af-7af8-4c36-9606-b8d768af1065 | 15615dc2-0798-4dd7-84fe-b12d603b4601 | 2005_2006_All_Regions_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY05 | BASIC OFFICER CRS USMC | Sector Naval, Tapachula, Chiapas, Mexico | 1/10/2005 | 2005-01-10 | 7/1/2005 | 2005-07-01 | QUANTICO, VA 22134 | 1 | 6439 | https://2009-2017.state.gov/documents/organization/75058.pdf | Not checked against source; verify accuracy before use | 2006-09 | 2019-07-16 | |
8e547987-af38-4892-93cd-267e1021b8ef | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - FY 2006 DoD Training | Waterside Port Security | - | Sector Naval La Paz; Sector Naval Topolobampo; Astillero No. 6 | 1/9/2006 | 2006-01-09 | 2/3/2006 | 2006-02-03 | Manzanillo, Colima; Veracruz, Veracruz | 4 | 4770.28 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
78c91ddd-7b06-461d-ac43-7b86d2b05bc6 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | INL - Fiscal Year 2011 Department of State Training | A/C STRUCT MAINT TECH | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Secretaría de seguridad Pública | 5/27/2011 | 2011-05-27 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 9504 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
9a75936f-e718-41f2-8c54-147b90d0e005 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2016 Department of Defense Training | Program On Countering Transnational Organized Crime (CTOC) | George C. Marshall European Center for Security Studies | Secretaría de Seguridad y Tránsito Municipal | 4/6/2016 | 2016-04-06 | 4/21/2016 | 2016-04-21 | Garmisch-Partenkirchen, Germany | 1 | 1947 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 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]);