training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
30 rows where "qa:training_date_scraped" is on date 2022-03-25 and "training:end_date" is on date 2020-05-14 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
d4cd5632-0042-4810-88ad-0052c4117515 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Madagascar | MDG | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Madagascar Ministry of Defense | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
c8d17ed4-4830-463a-941f-4c5a58d96108 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Burma | MMR | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Myanmar Redcross Society | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
a3586fad-1a9d-48ef-abd6-c087554d9c51 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | DEPHANKAM | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
a0c64db0-f876-483d-b4f3-0b02fcd5e02d | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Embassy of the United States in Indonesia | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
b0ce5b2c-543d-42e7-8f3a-4e52172ee6c2 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Indonesia National Commission on Violence Against Women | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
707b9363-c364-481b-9ce9-7af2aaf83433 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Malaysia | MYS | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Malaysia Ministry of Defence | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 2 | 0 | 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 |
5312c403-682d-46f4-8a7b-2e6639115b15 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Malaysia | MYS | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Malaysia Ministry of Health | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
cd71e6fe-7330-49a6-afce-311d37465cc7 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Malaysia | MYS | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Malaysian Maritime Enforcement Agency | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
188706f5-a67f-47b7-a0af-37f776bbe83d | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Congress of the Philippines | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 2 | 0 | 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 |
70941a9d-14b8-4e5d-b2ac-c146abdce81b | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Philippine Air Force | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
b7edb36f-683d-446c-9b73-408b14383164 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Philippine Coast Guard | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
4b653e0c-93a5-410d-b1b4-7afae2042d5d | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Philippine Department of the Interior and Local Government | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
ab1eda77-2d9d-4fea-9135-1663e4b1197c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Philippines Armed Forces | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
3d5fb319-26f6-4357-b10e-4958ca67883e | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Thailand | THA | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Cross Cultural Foundation | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
79d7025d-3ed5-4acf-a111-563a7f2feadb | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Thailand | THA | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Thailand Armed Forces | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
89bd3530-c9dd-4071-9916-aa03f66e9b48 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Vietnam | VNM | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Vietnam People s Army | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
f454cdeb-bd5f-419e-81bc-8a8c2200a0e5 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Switzerland | CHE | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Geneva Centre for the Democratic Control of Armed Forces | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - 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 |
162495b2-64e9-43e9-9125-758938e21995 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Afghanistan Office of the National Security Council | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
f710a374-b094-4138-b9ca-8399fac649d5 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Bangladesh | BGD | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Bangladesh Army | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
542ed00f-44ce-4d78-9bb7-6dbff998f8a0 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Bangladesh | BGD | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Bangladesh Ministry of Defense | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 2 | 0 | 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 |
fc833b63-9df5-40cf-8f61-acec43c0c1bb | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | India | IND | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Bharti Group | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
0afcd557-f096-481d-be76-07a88f145cbe | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | India | IND | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | BrahMos Aerospace | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
0d4ba166-6484-46a8-9ccb-53aff8a1091c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | India | IND | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Private Enterprise | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
59bfb509-bd3b-4d80-88db-c3148206a014 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Nepal Police | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
8b4886d3-f313-4a1e-b997-b40bb1f8ab51 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Nepali Army | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 2 | 0 | 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 |
5e98a7fb-73c4-4889-adda-4db93bd29eb3 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Pakistan Ministry of Information, Broadcasting and National Heritage | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
5251b183-7a22-41e8-aab5-4c66b57baf82 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Pakistan Navy | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
e6715f7d-195c-41a7-bc51-f6c9e1263ea0 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Sri Lanka | LKA | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Health And Security Collaboration To Manage COVID Infodemic | APCSS - 0 | Sri Lanka Ministry of Disaster Management | 5/14/2020 | 2020-05-14 | 5/14/2020 | 2020-05-14 | Virtual - Event | 1 | 0 | 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 |
275da5cb-f4b6-416b-a539-41d770bbf517 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Aviation Logistics School - 0 | Hamat Air Base | 5/8/2020 | 2020-05-08 | 5/14/2020 | 2020-05-14 | Ft. Eustis, VA, US | 1 | 1120 | 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 |
62ba0c3f-7b53-401f-806c-c50631740b4e | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | IMET-D&R - Fiscal Year 2020 Department of State Training | COVID-19 EXT | ALU - Leader Courses - 0 | Logistics Command | 4/3/2020 | 2020-04-03 | 5/14/2020 | 2020-05-14 | Ft. Lee, VA, US | 1 | 340 | 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]);