training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
33 rows where "qa:training_date_scraped" is on date 2022-03-25 and "training:end_date" is on date 2020-09-22 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7fd32835-3c4e-4d3c-bb71-63d8542ec284 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Russia | RUS | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Crisis In Belarus | GCMC - 0 | Woodrow Wilson International Center for Scholars | 9/22/2020 | 2020-09-22 | 9/22/2020 | 2020-09-22 | Virtural Event | 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 |
193afa8e-d63d-467e-8c0c-7ddc25272158 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Ukraine | UKR | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Crisis In Belarus | GCMC - 0 | Ukraine Hennadii Udovenko Diplomatic Academy | 9/22/2020 | 2020-09-22 | 9/22/2020 | 2020-09-22 | Virtural Event | 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 |
78e13b7e-ce3f-46f5-8a62-ccd5cfd82e60 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | 22nd division | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
64478a3c-df82-4533-b0d2-102201ed9b18 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | 23rd division/North Command | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
e0230436-31b6-40ff-b296-b1ef34704d9f | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | 32nd division | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
3f40dc3b-9158-46ce-890b-c50dc9367467 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | Air Force Health Department | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
cef40986-740e-439c-adef-4b3a5d2a0357 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | Commando unit | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
ba135eeb-aaf9-4dc2-8ed4-8a6fe95e3d06 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | crime investigation Clinic | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
41459597-e665-40b1-a2a0-cd45dc48f549 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | crime prevention unit | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
dc53bf6f-559c-42ba-bb00-e466573ae6a7 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | diplomatic security unit | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
0c4597e2-1f25-4b47-a746-81b8a3c54fde | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | Disease prevention and promotion | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 5 | 2345 | 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 |
48d792da-2f86-4b39-b7af-0f3af81b66d2 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | East Command level-3 hospital | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
2fd57293-dc77-4d04-bc38-ec6fc3c2fa64 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | East Command Staff Clinic | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
c75a9a74-0b94-41f9-b412-0360a94c9010 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | Eastern headquarters Division -2 clinic | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
3f39de41-58b4-4cf7-84b6-5e37176aea84 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | Federal Police Division -1 | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
0de2d988-93e3-46ab-b61e-ce1aa2ed51a0 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | Gofa level-1 Hospital | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
5fd8c992-61ea-41f0-ba32-485e6b3ac3f4 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | Ketena- 2 clinic | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
7ac2bb20-28d7-4bfa-ae2c-d2a56e8e0ec8 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | kolfe training center | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
f42056c2-63dc-415a-ad6c-ce3904f1e10c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | North Command | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
51c73e5e-e523-4140-b078-0918aeb77e96 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | North Division | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 2 | 938 | 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 |
46a9a74c-54dc-4def-8358-e6ed1b78f0ac | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | peace&law enforcement | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
861653a0-6494-4298-9998-aa6175c40d1a | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | Police Hospital | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 7 | 3283 | 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 |
bc76c2d9-9e1d-43ce-9146-ba74b07fb608 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | Police universty | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
c82a9aff-4aa3-4114-b1fb-c7ff9e0ec05b | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | Radio Communication unit | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
461473df-f36d-4e80-80db-d9173cecf1c5 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | Signal Level-1 Hospital | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
12304cc7-2218-485f-917c-421082f991a8 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | Special Operation Force | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
8a839e44-776e-4653-8381-0c779d170c7b | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | Tollay Training Center | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
b3be83ff-363e-48d0-b897-51da02ae92cb | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | vehicle &maintanance unit clinic | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
fcedc437-d693-448f-88cf-30be19fedd70 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | WEST headquarters Division 2 | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 1 | 469 | 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 |
27402e6f-a516-49f6-892e-1916e8b392ef | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Ethiopia | ETH | Misc DoD/DoS Non-SA - Fiscal Year 2020 Department of Defense Training | Frontline Field Epidemiology Training Program | UNK - 0 | woman affairs of federal police clinic | 9/16/2020 | 2020-09-16 | 9/22/2020 | 2020-09-22 | Adama | 2 | 938 | 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 |
e85f6f3f-68d7-4728-8b62-15792aa175ce | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Micronesia | FSM | Section 333 - Fiscal Year 2020 Department of Defense Training | New Equipment Puma Training | AeroVironment - 0 | Army | 9/7/2020 | 2020-09-07 | 9/22/2020 | 2020-09-22 | Redstone Arsenal, AL, US | 1 | 186820 | 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 |
70b93878-50a4-4053-8690-91d135261c14 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Armor School - 0 | Special Forces | 9/5/2020 | 2020-09-05 | 9/22/2020 | 2020-09-22 | Ft. Benning, GA, US | 1 | 2249 | 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 |
16b5404c-eaae-4906-822c-37f8d00eddbe | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Lebanon | LBN | Section 333 - Fiscal Year 2020 Department of Defense Training | HWMMV And LMTV Maintenance. TAFT For Lebanon | Lebanon (In Country Training) - 0 | Army | 9/23/2019 | 2019-09-23 | 9/22/2020 | 2020-09-22 | Lebanon (In Country Training) | 1 | 0 | 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 |
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]);