training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
48 rows where training:source = "8602229d-5b77-42e5-b1bc-83fad2eda1b9" and "training:start_date" is on date 2017-05-11 sorted by training:start_date descending
This data as json, CSV (advanced)
| training:id:admin | training:source | qa:training_group | training:country | training:country_iso_3166_1 | training:program | training:course_title | training:delivery_unit | training:recipient_unit | qa:training_start_date | training:start_date ▲ | qa:training_end_date | training:end_date | training:location | training:quantity | training:total_cost | qa:training_source_url | training:status:admin | qa:training_date_first_seen | qa:training_date_scraped |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ef392694-c4d8-4790-a7b3-49c9609d033f | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Chad | TCD | PKO - Fiscal Year 2017 Department of State Training | C-130 Maintenance & Support MTT (In Country) | Chad (In Country Training) | Air Force | 5/11/2017 | 2017-05-11 | 5/27/2017 | 2017-05-27 | Chad (In Country Training) | 1 | 0 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 63af29a5-4440-4325-a70d-348433149d2f | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Chad | TCD | PKO - Fiscal Year 2017 Department of State Training | MTT 17-131 For In Country Only | Chad (In Country Training) | Air Force | 5/11/2017 | 2017-05-11 | 5/27/2017 | 2017-05-27 | Chad (In Country Training) | 1 | 22688 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| ed1a0aef-4600-4290-a06a-1a5ee1a46c28 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2017 Department of State Training | International EOD Phase I | NAVAL SCHOOL EXPLOSIVE ORDNANCE DISPOSAL EGLI | MINE COUNTER MEASURE BRIGADE | 5/11/2017 | 2017-05-11 | 7/17/2017 | 2017-07-17 | Eglin AFB, FL, US | 1 | 14246 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 6644f1dd-bd17-473c-98fd-90c4a0258f14 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Jordan | JOR | CTPF - Fiscal Year 2017 Department of Defense Training | UH-60M Aviator Qualification (TRANS) | AVIATION SCHOOL | AIR OPERATIONS DIRECTORATE | 5/11/2017 | 2017-05-11 | 6/22/2017 | 2017-06-22 | Ft. Rucker, AL, US | 1 | 87862 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| dcdaf9ca-65a0-4dd1-afd8-48362f10b09a | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2017 Department of State Training | UH-60M TBOS Flight Simulator | 1ST INFANTRY DIVISION MECHANIZED | ROYAL SQUADRON | 5/11/2017 | 2017-05-11 | 5/17/2017 | 2017-05-17 | Ft. Riley, KS, US | 2 | 16604 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 9fc86b6b-1a58-4ca5-a542-8a0c25237cfd | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | ASFF - Fiscal Year 2017 Department of Defense Training | High Risk/Specialty Physical | DLIELC, LACKLAND AFB TX | Ministry of Defense | 5/11/2017 | 2017-05-11 | 5/17/2017 | 2017-05-17 | Lackland AFB, TX, US | 1 | 1501 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 53a1e17b-c247-4bb0-b290-d02cb9d5f0f8 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_South_Central_Asia_fmtrpt.tsv | Bangladesh | BGD | IMET-1 - Fiscal Year 2017 Department of State Training | International EOD Phase I | NAVAL SCHOOL EXPLOSIVE ORDNANCE DISPOSAL EGLI | BNS Nirbhoy | 5/11/2017 | 2017-05-11 | 7/17/2017 | 2017-07-17 | Eglin AFB, FL, US | 1 | 15361 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 3e35599c-214a-49e7-828a-9087998adff2 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2017 Department of State Training | A/C Structural Maintenance Technician (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | COLOMBIAN POLICE, AIR SERVICE | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 2 | 4820 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| a0aca724-a0e8-4d5d-8673-0dcaed9be7c0 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2017 Department of State Training | Instructor Pilot Instrument PROC (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | COLOMBIAN POLICE, AIR SERVICE | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 2220 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| b14f8768-e2b3-4141-9ea4-8f32604bad3e | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2017 Department of State Training | International Logistics (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | COLOMBIAN NATIONAL POLICE, ARAVI | 5/11/2017 | 2017-05-11 | 6/23/2017 | 2017-06-23 | Lackland AFB, TX, US | 1 | 1240 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 995f364c-c222-4d91-858b-7034e43817b3 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2017 Department of State Training | International Logistics (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | COLOMBIAN POLICE, CARABINEROS | 5/11/2017 | 2017-05-11 | 6/23/2017 | 2017-06-23 | Lackland AFB, TX, US | 2 | 2480 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| d0f6a316-d0c0-4a4b-b7b5-167279505566 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2017 Department of State Training | International Logistics (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | COLOMBIAN POLICE, DIRAN | 5/11/2017 | 2017-05-11 | 6/23/2017 | 2017-06-23 | Lackland AFB, TX, US | 2 | 2480 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 64765bdc-860d-4254-b89b-4dc9c6730422 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2017 Department of State Training | On-the-Job-Training (On-the-job Training) ADMIN (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | COLOMBIAN POLICE, CARABINEROS | 5/11/2017 | 2017-05-11 | 6/8/2017 | 2017-06-08 | Lackland AFB, TX, US | 2 | 1700 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| bd9bb9d3-905a-4cf7-80ae-554de91478c5 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Costa Rica | CRI | IMET-1 - Fiscal Year 2017 Department of State Training | Aircraft Technician Course (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | CR VIGILANCIA AEREA | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 11680 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 321a8a51-0208-42b9-9ebd-0681ca998250 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - Fiscal Year 2017 Department of State Training | Instructor Pilot Instrument PROC (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | Central Air Command | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 13130 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| eaa11a58-c46b-420b-9b8a-cd821effa575 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | Section 1004 - Fiscal Year 2017 Department of Defense Training | A/C Structural Maintenance Technician (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | \"ARMANDO ESCALON ESPINAL\" AIR BASE | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 12300 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| e0f5afb3-6b6e-47a3-8417-dd58ec7c4d35 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | Section 1004 - Fiscal Year 2017 Department of Defense Training | Avionics COMM/NAV EQUIP TECH (IAAFA-Spanish)) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | ``Armando Escalon Espinal`` Air Base | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 12310 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 4a422877-c741-4450-8d30-c99d833a5a65 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | Section 1004 - Fiscal Year 2017 Department of Defense Training | Corrosion Control Technician (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | \"HECTOR CARACCIOLI MONCADA\" AIR BASE | 5/11/2017 | 2017-05-11 | 6/23/2017 | 2017-06-23 | Lackland AFB, TX, US | 1 | 7725 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| be2519af-d3f0-46eb-80fd-7369e33231d4 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | Section 1004 - Fiscal Year 2017 Department of Defense Training | Instructor Pilot Instrument PROC (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | AIR FORCE HEADQUARTERS (FA-3) | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 13630 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| e08233e3-9e95-485b-81f8-a4f327aeeb04 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | Section 1004 - Fiscal Year 2017 Department of Defense Training | INTEL, SURV & RECON Fund (ISR) IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | \"HERNAN ACOSTA MEJIA\" AIR BASE | 5/11/2017 | 2017-05-11 | 6/16/2017 | 2017-06-16 | Lackland AFB, TX, US | 1 | 7684 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| bb778e53-ddd9-48cf-9059-c8055b7a1ced | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | Section 1004 - Fiscal Year 2017 Department of Defense Training | International Logistics (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | \"ARMANDO ESCALON ESPINAL\" AIR BASE | 5/11/2017 | 2017-05-11 | 6/23/2017 | 2017-06-23 | Lackland AFB, TX, US | 1 | 8477 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 3378e24c-2c1f-46f5-ac16-5bb7085abf14 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | INCLE - Fiscal Year 2017 Department of State Training | Avionics COMM/NAV EQUIP TECH (IAAFA-Spanish)) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | Federal Police | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 14530 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 1bc7aabe-529b-4766-8331-57c06b7af7c6 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | INCLE - Fiscal Year 2017 Department of State Training | Avionics Instrument TECH (IAAFA-Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | Mexico's Attorney General Office | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 2 | 29040 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 53e92093-32d6-4b63-a23b-06270032e233 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | INCLE - Fiscal Year 2017 Department of State Training | Basic Helicopter Crew Chief (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | Mexico's Attorney General Office | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 3 | 43560 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 1d696e7b-262c-41d1-964c-425ac5937cb9 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | INCLE - Fiscal Year 2017 Department of State Training | IMS Medical Insurance Review | PHYSICAL TNG LOC NOT REQUIRED | Federal Police | 5/11/2017 | 2017-05-11 | 5/11/2017 | 2017-05-11 | N/A | 1 | 90 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 67215455-6a3e-40c4-aef6-f220bb8ee72e | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | INCLE - Fiscal Year 2017 Department of State Training | IMS Medical Insurance Review | PHYSICAL TNG LOC NOT REQUIRED | Mexico's Attorney General Office | 5/11/2017 | 2017-05-11 | 5/11/2017 | 2017-05-11 | N/A | 6 | 540 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| c78f2534-9380-4659-b0b9-01d57daf3453 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | INCLE - Fiscal Year 2017 Department of State Training | Instructor Pilot Instrument PROC (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | Mexico's Attorney General Office | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 14330 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 20b5a2a6-0c5b-42f8-906c-4a4874f14adc | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2017 Department of Defense Training | A/C Structural Maintenance Technician (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SEDENA | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 13000 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| cd74a6fe-83e4-4d5b-bbcc-697a3c25da4a | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2017 Department of Defense Training | Aircraft Hydraulic Systems Technician (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SEMAR | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 13000 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 0efd4dcb-3007-4b54-ba63-490991e5a4b3 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2017 Department of Defense Training | Aircraft Technician Course (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SEDENA | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 3 | 43560 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 454e9615-9573-48f6-885b-28db28379084 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2017 Department of Defense Training | Avionics COMM/NAV EQUIP TECH (IAAFA-Spanish)) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SEDENA | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 4 | 58120 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 2edd9859-9786-41f5-99bb-cab746401774 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2017 Department of Defense Training | Avionics Instrument TECH (IAAFA-Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SEDENA | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 14520 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 111a62b8-fbd6-46db-8965-7dd7a4b035bd | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2017 Department of Defense Training | Corrosion Control Technician (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SEDENA | 5/11/2017 | 2017-05-11 | 6/23/2017 | 2017-06-23 | Lackland AFB, TX, US | 1 | 9077 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| d7c65c5a-e28e-444f-8efa-ed02d56b1f7a | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2017 Department of Defense Training | Corrosion Control Technician (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SEMAR | 5/11/2017 | 2017-05-11 | 6/23/2017 | 2017-06-23 | Lackland AFB, TX, US | 2 | 16650 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 04fc4c30-a9c9-4571-bb64-f7f3124243e6 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2017 Department of Defense Training | International Logistics (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SEMAR | 5/11/2017 | 2017-05-11 | 6/23/2017 | 2017-06-23 | Lackland AFB, TX, US | 3 | 27231 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 7ef5b7d4-0aad-41fc-a1dd-491baefda81e | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2017 Department of Defense Training | On-the-Job-Training (On-the-job Training) ADMIN (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SEMAR | 5/11/2017 | 2017-05-11 | 6/8/2017 | 2017-06-08 | Lackland AFB, TX, US | 4 | 29660 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 19000b71-a2eb-4016-9482-bc06f5765e52 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | Section 1004 - Fiscal Year 2017 Department of Defense Training | A/C Structural Maintenance Technician (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SENAN/ | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 12300 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 9bb014e1-2fb1-4fc7-81ba-dcbdca63d92a | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | Section 1004 - Fiscal Year 2017 Department of Defense Training | Aircraft Technician Course (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SENAN/ AIRCRAFT TECHNICIAN | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 12300 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 824fa808-1787-429a-b8b6-7f1791dbc349 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | Section 1004 - Fiscal Year 2017 Department of Defense Training | Aircraft Technician Course (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SENAN/FIX WING MAINTENANCE | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 12300 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| bf37f095-25bf-4eba-8315-a20438471dc7 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | Section 1004 - Fiscal Year 2017 Department of Defense Training | Aircraft Technician Course (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SENAN/Maintenance Technician | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 12300 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 2719321d-5171-4494-b25c-ca4842c0aeb0 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | Section 1004 - Fiscal Year 2017 Department of Defense Training | Aircraft Technician Course (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SENAN/Quality Control And Planification Officer | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 13820 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| c0a68196-a66a-4ac8-ae10-59a685b0aa6b | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | Section 1004 - Fiscal Year 2017 Department of Defense Training | Avionics COMM/NAV EQUIP TECH (IAAFA-Spanish)) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SENAN/AVIONICS TECHNICIAN | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 12310 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| d52828ca-ee61-4c97-bf39-eb8c1988020a | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | Section 1004 - Fiscal Year 2017 Department of Defense Training | Avionics COMM/NAV EQUIP TECH (IAAFA-Spanish)) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SENAN/Quality Control Officer | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 13830 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| c58bff92-9cf1-41bf-88ea-e88fc0a45a26 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | Section 1004 - Fiscal Year 2017 Department of Defense Training | Instructor Pilot Instrument PROC (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SENAN/PILOT | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 13630 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 46d837b3-49a4-4c44-bc8c-0ffb0d4c80bc | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | Section 1004 - Fiscal Year 2017 Department of Defense Training | INTEL, SURV & RECON Fund (ISR) IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SENAN | 5/11/2017 | 2017-05-11 | 6/16/2017 | 2017-06-16 | Lackland AFB, TX, US | 1 | 7684 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 3f5b3ce0-573a-464e-95d3-05ed9ce1288c | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Peru | PER | Section 1004 - Fiscal Year 2017 Department of Defense Training | Instructor Pilot Instrument PROC (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | Ejercito del Peru | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 14330 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| e5a8f20f-da1e-49ca-9f43-482d97dad8a7 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Uruguay | URY | IMET-1 - Fiscal Year 2017 Department of State Training | Avionics Instrument TECH (IAAFA-Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | I Air Brigade | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 1 | 12650 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
| 3b98e550-3187-4971-b103-2b27d6f55501 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Uruguay | URY | IMET-1 - Fiscal Year 2017 Department of State Training | Instructor Pilot Instrument PROC (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | I AIR BRIGADE | 5/11/2017 | 2017-05-11 | 8/10/2017 | 2017-08-10 | Lackland AFB, TX, US | 2 | 27960 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 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]);