training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
31 rows where "qa:training_date_scraped" is on date 2022-03-25 and "training:start_date" is on date 2019-11-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9c79dda3-4a92-4c81-a337-aee96ee0c286 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Chad | TCD | PKO - Fiscal Year 2020 Department of State Training | GPS Operator And Maintenance Course | PAE - 23 | G5 Sahel Battalion | 11/25/2019 | 2019-11-25 | 11/29/2019 | 2019-11-29 | SATG, N Djamena, Chad | 23 | 17871 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
f5fc5d84-2331-4457-8692-de0d0b6618c3 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Chad | TCD | PKO - Fiscal Year 2020 Department of State Training | Light-Wheeled Vehicles (Toyota) Maintenance Course | PAE - 18 | G5 Sahel Battalion | 11/25/2019 | 2019-11-25 | 11/29/2019 | 2019-11-29 | SATG, N Djamena, Chad | 18 | 17352 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
61e7a3cf-fe97-4bc6-8122-2db689a38c17 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Cote D'Ivoire, Republic of | CIV | IMET-1 - Fiscal Year 2020 Department of State Training | American Language Course General English Training Only | DLIELC, Lackland AFB TX - 0 | ENSOA (IVORIAN Non COMMISSIONNED Officer Academy)/Ministry Of Defense | 11/25/2019 | 2019-11-25 | 1/10/2020 | 2020-01-10 | Lackland AFB, TX, US | 1 | 18838 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
267d0a10-9b12-4795-8dae-23989fb25c74 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2020 Department of State Training | Field Medical Training | UNK - 0 | 37 Military Hospital | 11/25/2019 | 2019-11-25 | 12/6/2019 | 2019-12-06 | Ghana | 35 | 28315 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
ae65c4b6-5f08-4b3d-87fd-de807001f95b | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Fiji | FJI | IMET-2 - Fiscal Year 2020 Department of State Training | Legal Aspects Of Combating Corruption - LCC | Defense Institute Of International Legal STUD - 0 | Republic Of Fiji Military Forces | 11/25/2019 | 2019-11-25 | 12/12/2019 | 2019-12-12 | DIILS, Newport, RI, US | 1 | 15582 | https://www.state.gov/wp-content/uploads/2022/03/11-Volume-I-Section-IV-Part-IV-II-East-Asia-and-Pacific.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
3e7c0285-6548-41e6-a219-0d9c0b7e8d7a | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Tonga | TON | IMET-1 - Fiscal Year 2020 Department of State Training | Information Technology Specialist | Signal School - 0 | His Majestys Armed Forces | 11/25/2019 | 2019-11-25 | 3/31/2020 | 2020-03-31 | Ft. Gordon, GA, US | 1 | 23393 | https://www.state.gov/wp-content/uploads/2022/03/11-Volume-I-Section-IV-Part-IV-II-East-Asia-and-Pacific.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
a7a7359c-fe9e-4a51-8509-398b5deecbd9 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Azerbaijan | AZE | ALP - Fiscal Year 2020 Department of Defense Training | Oral Proficiency AV ALP Scholarship | DLIELC, Lackland AFB TX - 0 | Air Force Unit # 411 | 11/25/2019 | 2019-11-25 | 4/10/2020 | 2020-04-10 | Lackland AFB, TX, US | 1 | 14766 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
cfd18949-a861-4e1f-8f77-cebb6826f336 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Serbia, Republic of | SRB | Section 333 - Fiscal Year 2020 Department of Defense Training | Intermediate Investigations Cybercrimes I | DHS/HIS - 1 | Ministry of Interior, Cybercrimes Unit and Anti-terrorism Investigations Unit | 11/25/2019 | 2019-11-25 | 11/29/2019 | 2019-11-29 | Vrnjacka Banja, Serbia | 17 | 29167 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
1b5793ef-d620-4b79-bf91-5c36a355fae5 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Ukraine | UKR | Regional Centers - Fiscal Year 2020 Department of Defense Training | UKR Defense Reform Seminar I | GCMC - 0 | Ukraine General Staff | 11/25/2019 | 2019-11-25 | 11/26/2019 | 2019-11-26 | Kyiv, Ukraine | 2 | 0 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
6814300e-0e53-452c-ae72-375360c63722 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Ukraine | UKR | Regional Centers - Fiscal Year 2020 Department of Defense Training | UKR Defense Reform Seminar I | GCMC - 0 | Ukraine Ministry of Defense | 11/25/2019 | 2019-11-25 | 11/26/2019 | 2019-11-26 | Kyiv, Ukraine | 12 | 0 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
448cdf08-e541-4c99-8319-cd3523f07bd0 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Ukraine | UKR | Regional Centers - Fiscal Year 2020 Department of Defense Training | UKR Defense Reform Seminar I | GCMC - 0 | Ukraine National Defense University | 11/25/2019 | 2019-11-25 | 11/26/2019 | 2019-11-26 | Kyiv, Ukraine | 1 | 0 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
fc5e7b68-6300-4e32-8f8e-f273941ce52a | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2020 Department of State Training | Allied Trades Specialist | Ordnance Munitions & Electronics School - 0 | Royal Maintenance Corps | 11/25/2019 | 2019-11-25 | 4/9/2020 | 2020-04-09 | Ft. Lee, VA, US | 2 | 63756 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
df087e73-02a9-4f55-9332-9314e716c4b2 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2020 Department of State Training | Small Arms/Towed Artillery Repairer | Ordnance Munitions & Electronics School - 0 | Royal Maintenance Corps | 11/25/2019 | 2019-11-25 | 1/27/2020 | 2020-01-27 | Ft. Lee, VA, US | 2 | 32352 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
c13e6831-9195-45a1-85e3-42cdaec828f7 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2020 Department of State Training | Wheeled Vehicle Mechanic (W/O FTX) | Ordnance Munitions & Electronics School - 0 | Royal Maintenance Corps | 11/25/2019 | 2019-11-25 | 2/21/2020 | 2020-02-21 | Ft. Lee, VA, US | 2 | 43540 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
c3711587-cb35-495c-b73a-d988b077f87c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2020 Department of State Training | Wheeled Vehicle Mechanic (W/O FTX) | Ordnance Munitions & Electronics School - 0 | Royal MAITENANCE Corps | 11/25/2019 | 2019-11-25 | 2/21/2020 | 2020-02-21 | Ft. Lee, VA, US | 1 | 21770 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
6c5b91a2-5e8e-4dab-aac2-61a340579ed5 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - Fiscal Year 2020 Department of State Training | Ammunition Specialist | Ordnance Munitions & Electronics School - 0 | Air Assault Regiment | 11/25/2019 | 2019-11-25 | 12/10/2019 | 2019-12-10 | Ft. Lee, VA, US | 1 | 8865 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
e98af32c-9aef-4e3e-a052-e0066f768ff6 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Kyrgyzstan | KGZ | IMET-D&R - Fiscal Year 2020 Department of State Training | American Language Course GET And SET | DLIELC, Lackland AFB TX - 0 | Main Directorate, State Border Service | 11/25/2019 | 2019-11-25 | 6/19/2020 | 2020-06-19 | Lackland AFB, TX, US | 1 | 55688 | https://www.state.gov/wp-content/uploads/2022/03/14-Volume-I-Section-IV-Part-IV-V-South-Central-Asia.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
6d015cd4-00d4-496c-876c-296be14a5c97 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Tajikistan | TJK | NADR - Fiscal Year 2020 Department of State Training | Operational Site Visit | UNK - 0 | Army | 11/25/2019 | 2019-11-25 | 11/30/2019 | 2019-11-30 | Merefa, Ukraine | 6 | 28044 | https://www.state.gov/wp-content/uploads/2022/03/14-Volume-I-Section-IV-Part-IV-V-South-Central-Asia.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
086b9311-769d-47d1-96f1-64632b30880c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Costa Rica | CRI | IMET-1 - Fiscal Year 2020 Department of State Training | Cybersecurity (IAAFA - Spanish) | Inter-American Air Forces Academy, Lackland - 0 | CR INTELLIGNECE And Security Bureau | 11/25/2019 | 2019-11-25 | 12/12/2019 | 2019-12-12 | Lackland AFB, TX, US | 1 | 3487 | 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 |
a71bf387-c548-445b-bb60-31c510382215 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Costa Rica | CRI | IMET-1 - Fiscal Year 2020 Department of State Training | Cybersecurity (IAAFA - Spanish) | Inter-American Air Forces Academy, Lackland - 0 | CR Judicial Branch Police | 11/25/2019 | 2019-11-25 | 12/12/2019 | 2019-12-12 | Lackland AFB, TX, US | 2 | 6560 | 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 |
d1b54095-a231-4816-a918-b63864e9fbb6 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Costa Rica | CRI | IMET-1 - Fiscal Year 2020 Department of State Training | Cybersecurity (IAAFA - Spanish) | Inter-American Air Forces Academy, Lackland - 0 | CR Ministry Of Science And Technology | 11/25/2019 | 2019-11-25 | 12/12/2019 | 2019-12-12 | Lackland AFB, TX, US | 1 | 3487 | 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 |
82c9021a-7370-4777-8ec8-665011007c1d | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | IMET-1 - Fiscal Year 2020 Department of State Training | Cybersecurity (IAAFA - Spanish) | Inter-American Air Forces Academy, Lackland - 0 | Police/PNP | 11/25/2019 | 2019-11-25 | 12/12/2019 | 2019-12-12 | Lackland AFB, TX, US | 1 | 2310 | 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 |
f1ccc36b-285a-4b2c-a6b4-9f24cb14d778 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | IMET-1 - Fiscal Year 2020 Department of State Training | Cybersecurity (IAAFA - Spanish) | Inter-American Air Forces Academy, Lackland - 0 | Police/Senafront | 11/25/2019 | 2019-11-25 | 12/12/2019 | 2019-12-12 | Lackland AFB, TX, US | 1 | 2490 | 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 |
41d53507-b546-4703-81a3-e743550d7658 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Peru | PER | FMF - Fiscal Year 2020 Department of State Training | Cybersecurity (IAAFA - Spanish) | Inter-American Air Forces Academy, Lackland - 0 | Fuerza Area Del Peru | 11/25/2019 | 2019-11-25 | 12/12/2019 | 2019-12-12 | Lackland AFB, TX, US | 1 | 6037 | 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 |
829adb82-b71a-433b-82d4-2362977490d3 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Peru | PER | FMF - Fiscal Year 2020 Department of State Training | Cybersecurity (IAAFA - Spanish) | Inter-American Air Forces Academy, Lackland - 0 | Peruvian Air Force | 11/25/2019 | 2019-11-25 | 12/12/2019 | 2019-12-12 | Lackland AFB, TX, US | 1 | 5830 | 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 |
1a0e4f5c-0644-47a2-8d40-0c6afa0636a3 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Peru | PER | FMF - Fiscal Year 2020 Department of State Training | Cybersecurity (IAAFA - Spanish) | Inter-American Air Forces Academy, Lackland - 0 | Peruvian Air Force/DITEL | 11/25/2019 | 2019-11-25 | 12/12/2019 | 2019-12-12 | Lackland AFB, TX, US | 1 | 5830 | 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 |
8fbef60e-3f11-494b-b5de-f9e8317a7ad3 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Peru | PER | NADR - Fiscal Year 2020 Department of State Training | EOD | UNK - 0 | Peruvian Air Force | 11/25/2019 | 2019-11-25 | 12/6/2019 | 2019-12-06 | Lima, Peru; Pucusana, Peru | 21 | 12411 | 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 |
5e9dad82-f79b-4577-8a95-edaf07f34f3d | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Uruguay | URY | IMET-D&R - Fiscal Year 2020 Department of State Training | ALC Specialized English Training Only | DLIELC, Lackland AFB TX - 0 | Infantry Marine Command | 11/25/2019 | 2019-11-25 | 1/24/2020 | 2020-01-24 | Lackland AFB, TX, US | 1 | 18641 | 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 |
975fc5d8-5b3c-4961-92cf-1b9eec90a6e8 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Uruguay | URY | IMET-D&R - Fiscal Year 2020 Department of State Training | ALC Specialized English Training Only | DLIELC, Lackland AFB TX - 0 | Naval Aviation | 11/25/2019 | 2019-11-25 | 1/24/2020 | 2020-01-24 | Lackland AFB, TX, US | 1 | 18641 | 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 |
81736184-5f34-4df8-8917-b807c465dea0 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Uruguay | URY | IMET-D&R - Fiscal Year 2020 Department of State Training | ALC Specialized English Training Only | DLIELC, Lackland AFB TX - 0 | Navy | 11/25/2019 | 2019-11-25 | 1/24/2020 | 2020-01-24 | Lackland AFB, TX, US | 1 | 18641 | 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 |
d084b9ae-b910-44e1-9c25-da0b65e0f0d4 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Uruguay | URY | IMET-D&R - Fiscal Year 2020 Department of State Training | American Language Course General English Training Only | DLIELC, Lackland AFB TX - 0 | CHOD | 11/25/2019 | 2019-11-25 | 1/24/2020 | 2020-01-24 | Lackland AFB, TX, US | 1 | 18597 | 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 |
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]);