training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
24 rows where training:country_iso_3166_1 = "MEX" and "training:start_date" is on date 2001-05-08 sorted by training:delivery_unit
This data as json, CSV (advanced)
Suggested facets: training:course_title, training:recipient_unit, training:end_date, training:location, training:total_cost, qa:training_date_scraped (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0b26349f-3027-433b-baae-22e8c3d36ba7 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | A/C STRUCT RPR/CORR CONTR | 4th Air Materiel Maint Echelon, Santa Lucia, Estado de Mexico | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
3d06cea0-cbcb-45c0-9106-d289f37aacc5 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | A/C STRUCT RPR/CORR CONTR | 4th Air Materiel Maint Echelon, Santa Lucia, Estado de | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
2c55461c-5b8d-479b-9e51-e7d2eab0b22f | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | ACFT ELECTRICAL REPAIR | Naval Superior Studies Center (CESNAV), Mexico, D.F. | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
140c839e-3e0f-4a3f-8872-591bc0255f35 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | ACFT PNEUDRAULICS SYS TECH | Air Naval Transport Sq., International Airport, Mexico, D.F. | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
992073c9-d060-4a11-a373-78d8e687b795 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | ACFT PNEUDRAULICS SYS TECH | 3rd Patrol Sq, Veracruz, Veracruz | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
ee25b37d-4e77-4663-a703-4332661280c5 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | ACFT PNEUDRAULICS SYS TECH | 1st Search & Rescue Sq, Salina Cruz, Oaxaca | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
2fb8a340-99d2-4d96-8ba1-49216442ed73 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | ACFT PNEUDRAULICS SYS TECH | Air Naval Maintenance Center, Veracruz, Veracruz | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
5098f56d-3255-4aa3-b7bc-3564dcb3f680 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | AIRCRAFT TECHNICIAN CRS | 402nd Air Sq., BAM #2, Ciudad Ixtepec, Oaxaca | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
63781ff9-0e28-4aca-a95d-23cbac55ffa4 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | AIRCRAFT TECHNICIAN CRS | BAM #1, Santa Lucia, Estado de Mexico | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
199bc2ca-6390-4029-bc61-eaa8ac56618b | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | AVIONICS COMM/NAV EQUIP | 3rd Echelon, Electronics Maintenance, BAM#8, Merida, Yucatan | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 1255 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
4c10334b-a706-4318-9287-afa21f4742fa | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | AVIONICS COMM/NAV EQUIP | 3rd Echelon, Electronics Maintenance, Tuxtla Gutierrez, Chiapas | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 1255 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
712f11a9-9ad2-4b2f-bd7a-fb905e3fe5b8 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | AVIONICS COMM/NAV EQUIP | 3rd Echelon, Electronics Maintenance, Tuxtla Gutierrez, Chiapas | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 1255 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
9b633b4b-e156-416c-97b7-71c06af6d497 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | AVIONICS INSTRUMENT SYS | 4th Electronics Maint Echelon, Santa Lucia, Estado de Mexico | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
ee61704b-08b8-4fae-bcd0-7291ce9f8137 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | AVIONICS INSTRUMENT SYS | 3rd Electronic Maintenance Echelon, Zapopan, Jalisco | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
f8fb534a-f275-4b14-ada4-8119c6c206eb | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | C-130/B/E/H/T-56 ENG TECH | 302nd Air Sq., Santa Lucia, Estado de Mexico | 5/8/01 | 2001-05-08 | 6/19/01 | 2001-06-19 | LACKLAND AFB, TX 78236-5706 | 1 | 510 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
9e4c6e1c-6b1b-4a66-a266-228f6ad31c08 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | C-130/B/E/H/T-56 ENG TECH | 302nd Air Sq., Santa Lucia, Estado de Mexico | 5/8/01 | 2001-05-08 | 6/19/01 | 2001-06-19 | LACKLAND AFB, TX 78236-5706 | 1 | 510 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
07fac5b7-6d64-4285-9ccb-377bf92e53cc | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | COLLINS ADF-60 | 3rd Electronic Maintenance Echelon, BAM #6, Tuxtla Gutierrez, Chiapas | 5/8/01 | 2001-05-08 | 5/24/01 | 2001-05-24 | LACKLAND AFB, TX 78236-5706 | 1 | 285 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
6b014fe9-e71a-4c28-ad70-d6b04dd6e1de | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | COLLINS ADF-60 | 3rd Electronic Maintenance Echelon, Merida, Yucatan | 5/8/01 | 2001-05-08 | 5/24/01 | 2001-05-24 | LACKLAND AFB, TX 78236-5706 | 1 | 285 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
82cc5557-e6ae-47e8-9cd4-25c244a65c09 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | COLLINS ADF-60 | 4th Electronic Maintenance Echelon, Santa Lucia, Estado de Mexico | 5/8/01 | 2001-05-08 | 5/24/01 | 2001-05-24 | LACKLAND AFB, TX 78236-5706 | 1 | 285 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
2f3ebb95-4e91-491d-ac8d-bdbfbd3b9ff1 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | ELECTRONIC FUNDAMENTALS | Aviation Military School, Zapopan, Jalisco | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
b2f7054f-0cbc-42de-a09d-14f5e48328b4 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | ELECTRONIC FUNDAMENTALS | Aviation Military School, Zapopan, Jalisco | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
dd1d8ede-ac60-4cc4-af19-c962babc2df1 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | ELECTRONIC FUNDAMENTALS | Aviation Military School, Zapopan, Jalisco | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
49fa78f9-fc72-4d23-99a9-b79725c41a8c | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | ELECTRONIC FUNDAMENTALS | 3rd Electronic Maint Echelon, Zapopan, Jalisco | 5/8/01 | 2001-05-08 | 8/22/01 | 2001-08-22 | LACKLAND AFB, TX 78236-5706 | 1 | 2301 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
526606d5-b921-4f75-a0d6-028dcd7b71a0 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | MIL FREE FALL JUMPMASTER | GAFE, Parachutist Brigade, Mexico, D.F. | 5/8/01 | 2001-05-08 | 6/1/01 | 2001-06-01 | FT BRAGG NC 28310 | 1 | 382 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 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]);