training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
35 rows where "qa:training_date_scraped" is on date 2019-12-06 and "training:start_date" is on date 2017-09-25 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
a266ee09-6905-430b-9b47-f17216f37ba6 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Chad | TCD | PKO - Fiscal Year 2018 Department of State Training | Advanced Rifle Marksmanship Training | N/A | N/A | 9/25/2017 | 2017-09-25 | 10/6/2017 | 2017-10-06 | Loumia Training Camp, N'Djamena, CHAD | 39 | 22628 | 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 |
1049d5b2-b318-4300-a699-b64106af0163 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Chad | TCD | PKO - Fiscal Year 2018 Department of State Training | Mechanized Operations Training | N/A | N/A | 9/25/2017 | 2017-09-25 | 10/6/2017 | 2017-10-06 | Loumia Training Camp, N'Djamena, CHAD | 43 | 23984 | 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 |
367466cd-5db9-4220-aa32-a5daf8b06d61 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Chad | TCD | PKO - Fiscal Year 2018 Department of State Training | Mortar Operations Training | N/A | N/A | 9/25/2017 | 2017-09-25 | 10/6/2017 | 2017-10-06 | Loumia Training Camp, N'Djamena, CHAD | 42 | 22864 | 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 |
64d49a36-6b6e-478b-8aac-019c3c92d474 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Chad | TCD | PKO - Fiscal Year 2018 Department of State Training | Tactical Mission Leadership Training | N/A | Kidal BN | 9/25/2017 | 2017-09-25 | 10/6/2017 | 2017-10-06 | Loumia Training Camp, N'Djamena, CHAD | 68 | 27329 | 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 |
56decba6-6d6a-4db1-917d-37e058bbbbd5 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Chad | TCD | PKO - Fiscal Year 2018 Department of State Training | Tactical Mission Leadership Training | N/A | N/A | 9/25/2017 | 2017-09-25 | 10/6/2017 | 2017-10-06 | Loumia Training Camp, N'Djamena, CHAD | 10 | 11583 | 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 |
ce8d7acf-3038-45ed-bb4e-be9ebe34fb44 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Chad | TCD | PKO - Fiscal Year 2018 Department of State Training | Tactical Mission Leadership Training | N/A | Tessalit BN | 9/25/2017 | 2017-09-25 | 10/6/2017 | 2017-10-06 | Loumia Training Camp, N'Djamena, CHAD | 91 | 51477 | 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 |
a3e26ae9-0358-4dd1-bf01-ea7a4582b52c | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Djibouti | DJI | CTFP - Fiscal Year 2018 Department of Defense Training | COMB STRAT INTEL Training Program | Defense Intelligence Agency (CSITP) | Republican Guard | 9/25/2017 | 2017-09-25 | 11/9/2017 | 2017-11-09 | DIA, Washington, DC, DC, US | 1 | 5080 | 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 |
077c3dbf-4318-4600-b5e3-f1cd872e999c | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Mauritania | MRT | PKO - Fiscal Year 2018 Department of State Training | CoESPU Pre-Deployment Training | N/A | N/A | 9/25/2017 | 2017-09-25 | 10/20/2017 | 2017-10-20 | CoESPU, Vicenza, ITALY | 25 | 26923 | 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 |
69be1e07-cd1a-4979-bcf1-b3ec553bd9c3 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Mauritius | MUS | IMET-1 - Fiscal Year 2018 Department of State Training | Civil-Military Approaches To Maritime Security | Center For Civil-Military Relations Monterey | Mauritius National Coast Guard | 9/25/2017 | 2017-09-25 | 10/6/2017 | 2017-10-06 | Monterey, CA, US | 1 | 14666 | 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 |
533dde8a-7955-45f8-9cdb-86765c6e5e07 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Nigeria | NGA | CTFP - Fiscal Year 2018 Department of Defense Training | Civil-Military Approaches To Maritime Security | Center For Civil-Military Relations Monterey | Nigerian Air Force HQ | 9/25/2017 | 2017-09-25 | 10/6/2017 | 2017-10-06 | Monterey, CA, US | 1 | 18933 | 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 |
d9bf4523-fcdc-42b6-b735-65f6cfaa90f2 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Senegal | SEN | CTFP - Fiscal Year 2018 Department of Defense Training | COMB STRAT INTEL Training Program | Defense Intelligence Agency (CSITP) | Headquarters Staff | 9/25/2017 | 2017-09-25 | 11/9/2017 | 2017-11-09 | DIA, Washington, DC, DC, US | 1 | 11963 | 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 |
3f74a3d5-19d1-48ec-bc6e-7e01af5cc684 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Seychelles | SYC | IMET-1 - Fiscal Year 2018 Department of State Training | Civil-Military Approaches To Maritime Security | Center For Civil-Military Relations Monterey | Seychelles Presidential Security Unit | 9/25/2017 | 2017-09-25 | 10/6/2017 | 2017-10-06 | Monterey, CA, US | 1 | 14666 | 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 |
6f4b8375-0987-40d3-84ae-d77e27417bf3 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Tanzania, United Republic of | TZA | IMET-1 - Fiscal Year 2018 Department of State Training | COMB STRAT INTEL Training Program | Defense Intelligence Agency (CSITP) | Defense Forces HQ | 9/25/2017 | 2017-09-25 | 11/9/2017 | 2017-11-09 | DIA, Washington, DC, DC, US | 1 | 18080 | 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 |
b5e7fe76-e86d-48c4-9040-d4f8655fd31c | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Malaysia | MYS | IMET-1 - Fiscal Year 2018 Department of State Training | CYBER Security Fundamentals And Defense CERT | Naval Postgraduate School Monterey CA | Information Warfare Directorate, DISD | 9/25/2017 | 2017-09-25 | 3/30/2018 | 2018-03-30 | Monterey, CA, US | 1 | 55435 | 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 |
517638a5-1f26-4786-a233-0435768e5d3a | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - Fiscal Year 2018 Department of State Training | Signal Captains Career | Signal School | Command Signal Company, Army Signal Regiment, PHIL Army | 9/25/2017 | 2017-09-25 | 3/2/2018 | 2018-03-02 | Ft. Gordon, GA, US | 1 | 29556 | 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 |
c4a505d5-a5f7-46b8-821a-097218f743e5 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Timor-Leste, Democratic Republic of | TLS | IMET-1 - Fiscal Year 2018 Department of State Training | American Language Course GET And SET | DLIELC, Lackland AFB TX | Service Support Component | 9/25/2017 | 2017-09-25 | 12/22/2017 | 2017-12-22 | Lackland AFB, TX, US | 1 | 23770 | 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 |
948b8340-0bdc-49a1-88a3-7b5c79a764bb | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Timor-Leste, Democratic Republic of | TLS | IMET-1 - Fiscal Year 2018 Department of State Training | American Language Course GET And SET | DLIELC, Lackland AFB TX | Training And Formation Component | 9/25/2017 | 2017-09-25 | 12/22/2017 | 2017-12-22 | Lackland AFB, TX, US | 1 | 24191 | 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 |
996617c8-8f23-4217-8537-1103c360a110 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Tonga | TON | IMET-1 - Fiscal Year 2018 Department of State Training | Civil-Military Approaches To Maritime Security | Center For Civil-Military Relations Monterey | HIS MAJESTY'S Armed Forces | 9/25/2017 | 2017-09-25 | 10/6/2017 | 2017-10-06 | Monterey, CA, US | 1 | 20466 | 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 |
14a343d7-825a-4d0c-a0e6-1904f8a35f05 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Vietnam | VNM | IMET-1 - Fiscal Year 2018 Department of State Training | American Language Course General English Training Only | DLIELC, Lackland AFB TX | Engineering Brigade 83, Vietnam People's Navy | 9/25/2017 | 2017-09-25 | 12/1/2017 | 2017-12-01 | Lackland AFB, TX, US | 1 | 16947 | 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 |
ef30a8b0-72a4-4a79-aafa-d6a2da770821 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Europe_fmtrpt.tsv | Azerbaijan | AZE | IMET-1 - Fiscal Year 2018 Department of State Training | CYBER Security Fundamentals And Defense CERT | Naval Postgraduate School Monterey CA | Ministry Of Defense International Cooperation Department | 9/25/2017 | 2017-09-25 | 3/30/2018 | 2018-03-30 | Monterey, CA, US | 1 | 51185 | 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 |
8492cb84-4a93-4b8a-9b28-8dde1f18887b | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Europe_fmtrpt.tsv | Georgia | GEO | IMET-1 - Fiscal Year 2018 Department of State Training | COMB STRAT INTEL Training Program | Defense Intelligence Agency (CSITP) | J2, General Staff | 9/25/2017 | 2017-09-25 | 11/9/2017 | 2017-11-09 | DIA, Washington, DC, DC, US | 1 | 21930 | 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 |
c50e9100-a064-49ed-b8dc-e11cdedcbb59 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Europe_fmtrpt.tsv | Malta | MLT | IMET-1 - Fiscal Year 2018 Department of State Training | Basic Close Quarter Battle Course | International Special Training Center | Armed Forces Of Malta - Special Operations Unit | 9/25/2017 | 2017-09-25 | 10/20/2017 | 2017-10-20 | Pfullendorf, GY | 2 | 28664 | 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 |
932cbc55-74bd-47a5-9c3b-93c40cb04a11 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Algeria | DZA | CTFP - Fiscal Year 2018 Department of Defense Training | COMB STRAT INTEL Training Program | Defense Intelligence Agency (CSITP) | Office Of the Chief Of Staff | 9/25/2017 | 2017-09-25 | 11/9/2017 | 2017-11-09 | DIA, Washington, DC, DC, US | 1 | 6247 | 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 |
5734de7a-a861-4799-aee7-40778c2e410b | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2018 Department of State Training | Defense TECH & SYS-MS | Naval Postgraduate School Monterey CA | MAFAT | 9/25/2017 | 2017-09-25 | 9/21/2018 | 2018-09-21 | Monterey, CA, US | 1 | 34613 | 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 |
800f3802-630d-444c-81fd-a61b2f117473 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Lebanon | LBN | NADR - Fiscal Year 2018 Department of State Training | Border Security Course Refresher | N/A | 1st LBR | 9/25/2017 | 2017-09-25 | 10/13/2017 | 2017-10-13 | 1st LBR HQ | 10 | 8000 | 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 |
837c8955-d70e-4e28-8987-4450ed61e393 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | ASFF - Fiscal Year 2018 Department of Defense Training | A-29 Initial And Mission Qualification (AF) | Moody AFB, GA | MoD | 9/25/2017 | 2017-09-25 | 12/22/2017 | 2017-12-22 | Moody AFB, GA, US | 1 | 20062 | 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 |
cbdc1a0d-74f4-4819-aecf-9332ae7ccb22 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | ASFF - Fiscal Year 2018 Department of Defense Training | Field Studies Program | Moody AFB, GA | MoD | 9/25/2017 | 2017-09-25 | 12/22/2017 | 2017-12-22 | Moody AFB, GA, US | 1 | 455 | 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 |
7a156257-ab53-468e-966f-01da80f99242 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | CTFP - Fiscal Year 2018 Department of Defense Training | Combating Terrorism Policy And Strategy - MA | Naval Postgraduate School Monterey CA | 5TH Battalion, Azad Kashmir Regiment | 9/25/2017 | 2017-09-25 | 9/30/2018 | 2018-09-30 | Monterey, CA, US | 1 | 123715 | 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 |
95dd8840-dc3c-46f2-9bfe-6ea634e9ff72 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | IMET-1 - Fiscal Year 2018 Department of State Training | COMB STRAT INTEL Training Program | Defense Intelligence Agency (CSITP) | School Of Intelligence | 9/25/2017 | 2017-09-25 | 11/9/2017 | 2017-11-09 | DIA, Washington, DC, DC, US | 1 | 15996 | 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 |
8b7fa626-ea0f-4865-a217-2e26dac07290 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | IMET-1 - Fiscal Year 2018 Department of State Training | Signal Captains Career | Signal School | 18 Signal Battalion | 9/25/2017 | 2017-09-25 | 3/2/2018 | 2018-03-02 | Ft. Gordon, GA, US | 1 | 29409 | 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 |
4e15134c-b8b6-4788-a51c-5b2b35c36aae | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | IMET-1 - Fiscal Year 2018 Department of State Training | Signal Captains Career | Signal School | 52 Signal Battalion | 9/25/2017 | 2017-09-25 | 3/2/2018 | 2018-03-02 | Ft. Gordon, GA, US | 1 | 28942 | 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 |
afdde048-5025-4442-84fe-85be198e5833 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_South_Central_Asia_fmtrpt.tsv | Sri Lanka | LKA | IMET-1 - Fiscal Year 2018 Department of State Training | Civil-Military Approaches To Maritime Security | Center For Civil-Military Relations Monterey | Executive | 9/25/2017 | 2017-09-25 | 10/6/2017 | 2017-10-06 | Monterey, CA, US | 2 | 41332 | 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 |
dddc6e44-6d98-4835-b95b-f455615ca15c | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2018 Department of State Training | Aviation Maintenance Supervisor Spanish | Aviation Logistics School | Air Transportation Command, Bogota | 9/25/2017 | 2017-09-25 | 11/29/2017 | 2017-11-29 | Ft. Eustis, VA, US | 1 | 13773 | 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 |
6e200c1d-a63d-4ee8-b5a2-e41260025fd2 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2018 Department of State Training | Aviation Maintenance Supervisor Spanish | Aviation Logistics School | Colombian Army Aviation School | 9/25/2017 | 2017-09-25 | 11/29/2017 | 2017-11-29 | Ft. Eustis, VA, US | 2 | 34096 | 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 |
3cc1abed-acfe-4e13-b99f-c0ea53e4b1c1 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | El Salvador | SLV | ALP - Fiscal Year 2018 Department of Defense Training | Intro Flight Training ALP | Columbus AFB MS | Second Air Brigade | 9/25/2017 | 2017-09-25 | 12/15/2017 | 2017-12-15 | Columbus AFB, MS, US | 1 | 5656 | 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 |
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]);