training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
32 rows where "qa:training_date_scraped" is on date 2022-03-25 and "training:start_date" is on date 2020-07-01 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1e165f2a-22a4-459b-b3ae-a65934b40ab4 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Congo, Democratic Republic of (Kinshasa) | COD | PKO - Fiscal Year 2020 Department of State Training | Human Rights And International Humanitarian Law | N/A - 5 | 22nd Regional SECAS Directorate | 7/1/2020 | 2020-07-01 | 7/5/2020 | 2020-07-05 | CI Mura | 5 | 2375 | 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 |
c4608c90-01cf-4917-8974-1dad31ffcc22 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Congo, Democratic Republic of (Kinshasa) | COD | PKO - Fiscal Year 2020 Department of State Training | Human Rights And International Humanitarian Law | N/A - 5 | Mura Instruction Center | 7/1/2020 | 2020-07-01 | 7/5/2020 | 2020-07-05 | CI Mura | 5 | 2375 | 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 |
368a3754-263d-4a6b-a2f9-08b0a846be4c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Congo, Democratic Republic of (Kinshasa) | COD | PKO - Fiscal Year 2020 Department of State Training | Human Rights And International Humanitarian Law | N/A - 2 | NCO School Mura | 7/1/2020 | 2020-07-01 | 7/5/2020 | 2020-07-05 | CI Mura | 2 | 950 | 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 |
15c726a8-9b19-4464-92ac-6e385195a680 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Congo, Democratic Republic of (Kinshasa) | COD | PKO - Fiscal Year 2020 Department of State Training | Human Rights And International Humanitarian Law | N/A - 4 | 7/1/2020 | 2020-07-01 | 7/5/2020 | 2020-07-05 | Moba Kirungu | 4 | 184 | 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 | |
12028ad9-9af0-4364-8cf2-d3344dd7ed63 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Congo, Democratic Republic of (Kinshasa) | COD | PKO - Fiscal Year 2020 Department of State Training | Human Rights And International Humanitarian Law | N/A - 4 | 21 Brigade, 2nd Rapid Response Batallion | 7/1/2020 | 2020-07-01 | 7/5/2020 | 2020-07-05 | Moba Kirungu | 4 | 184 | 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 |
53e154d1-27db-4714-9b61-8f2d4380aae6 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Congo, Democratic Republic of (Kinshasa) | COD | PKO - Fiscal Year 2020 Department of State Training | Human Rights And International Humanitarian Law | N/A - 1 | 22 Brigade, 2nd Rapid Response Batallion | 7/1/2020 | 2020-07-01 | 7/5/2020 | 2020-07-05 | Moba Kirungu | 1 | 46 | 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 |
570315d8-8061-4aba-9525-333cbf71b375 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Congo, Democratic Republic of (Kinshasa) | COD | PKO - Fiscal Year 2020 Department of State Training | Human Rights And International Humanitarian Law | N/A - 1 | 23 Brigade, 2nd Rapid Response Batallion | 7/1/2020 | 2020-07-01 | 7/5/2020 | 2020-07-05 | Moba Kirungu | 1 | 46 | 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 |
2e359412-8661-4fce-868d-43d3d2cb34e1 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Congo, Democratic Republic of (Kinshasa) | COD | PKO - Fiscal Year 2020 Department of State Training | Human Rights And International Humanitarian Law | N/A - 1 | 24 Brigade, 2nd Rapid Response Batallion | 7/1/2020 | 2020-07-01 | 7/5/2020 | 2020-07-05 | Moba Kirungu | 1 | 46 | 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 |
ce2ed5b6-5f5a-4d5c-a09d-62dfadbe4922 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Kenya | KEN | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | ALU - Leader Courses - 0 | Kenya Army Office Of Codification (IT) | 7/1/2020 | 2020-07-01 | 9/30/2020 | 2020-09-30 | Ft. Lee, VA, US | 1 | 16943 | 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 |
10cac78f-5a13-40fa-8aa4-fa86edc6e095 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Mali | MLI | IMET-1 - Fiscal Year 2020 Department of State Training | Training Participant (Operational) | DLIELC, Lackland AFB TX - 0 | Army Telecommunication And Transmission Directorate | 7/1/2020 | 2020-07-01 | 8/31/2020 | 2020-08-31 | Lackland AFB, TX, US | 1 | 8327 | 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 |
16ef4110-0fe7-4920-bba7-0eaf4ba4d276 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Senegal | SEN | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Engineer School - 0 | 12th Battalion | 7/1/2020 | 2020-07-01 | 9/30/2020 | 2020-09-30 | Ft. Leonard Wood, MO, US | 1 | 17750 | 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 |
b81a9bf0-8fe0-4387-9532-af310d1f4d47 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Uganda | UGA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Chemical School - 0 | UPDF Engineering Brigade, CBRN Regiment | 7/1/2020 | 2020-07-01 | 9/30/2020 | 2020-09-30 | Ft. Leonard Wood, MO, US | 1 | 19869 | 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 |
5bd8e474-f2f3-4bce-8c2f-a2832da5c327 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | MSI - Fiscal Year 2020 Department of Defense Training | MTT SEAVISION System Training | Indonesia (In Country Training) - 0 | Navy | 7/1/2020 | 2020-07-01 | 7/9/2020 | 2020-07-09 | Indonesia (In Country Training) | 1 | 72360 | 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 |
dbff343d-0930-49ad-8bbe-e5c65572aef6 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Marshall Islands | MHL | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Indo-Pacific Update: Crisis, Complexity, And Resilience | APCSS - 0 | Marshall Islands Ministry of Foreign Affairs | 7/1/2020 | 2020-07-01 | 7/1/2020 | 2020-07-01 | 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 |
5e075834-6afa-408f-a87c-0fa7dc7d99d2 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Micronesia | FSM | Regional Centers - Fiscal Year 2020 Department of Defense Training | July Indo-Pacific Update | APCSS - 0 | Marshall Islands Ministry of Foreign Affairs | 7/1/2020 | 2020-07-01 | 7/1/2020 | 2020-07-01 | UNK | 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 |
7156f0c8-0867-4f4e-9816-d6e4e0019875 | 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 - Indo-Pacific Update: Crisis, Complexity, And Resilience | APCSS - 0 | Philippine Air Force | 7/1/2020 | 2020-07-01 | 7/1/2020 | 2020-07-01 | 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 |
79186ea1-d0ee-47e4-aeaa-ba252a814f6e | 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 - Indo-Pacific Update: Crisis, Complexity, And Resilience | APCSS - 0 | Philippines Ministry of Foreign Affairs | 7/1/2020 | 2020-07-01 | 7/1/2020 | 2020-07-01 | 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 |
b10042ac-bfeb-4291-8395-4df197b6c64b | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Tonga | TON | Regional Centers - Fiscal Year 2020 Department of Defense Training | July Indo-Pacific Update | APCSS - 0 | Consular Agency of Tonga in Honolulu | 7/1/2020 | 2020-07-01 | 7/1/2020 | 2020-07-01 | UNK | 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 |
1aa359f1-ddf1-4636-aed3-c3f7229ca169 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Tonga | TON | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - Alumni Engagement - Indo-Pacific Update: Crisis, Complexity, And Resilience | APCSS - 0 | Consular Agency of Tonga in Honolulu | 7/1/2020 | 2020-07-01 | 7/1/2020 | 2020-07-01 | 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 |
7570269d-d359-49a8-879b-971f90299e8e | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Kosovo | XKX | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Military Police School - 0 | Rapid Reaction Brigade, 1st BATT, KSF | 7/1/2020 | 2020-07-01 | 7/16/2020 | 2020-07-16 | Ft. Leonard Wood, MO, US | 1 | 614 | 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 |
24f9dd0a-f93a-4a51-8b37-954e8efa56a3 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Macedonia | MKD | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Army War College - 0 | General Inspection Office, Ministry Of Defense | 7/1/2020 | 2020-07-01 | 7/18/2020 | 2020-07-18 | Carlisle Barracks, PA, US | 1 | 3176 | 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 |
b280a2b8-805c-4063-8103-456b9b7a3339 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Infantry School - 0 | 1st Infantry Brigade, Moldovan Army | 7/1/2020 | 2020-07-01 | 7/31/2020 | 2020-07-31 | Ft. Benning, GA, US | 1 | 3608 | 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 |
1f55cb87-7225-4c85-a553-ac264b411a35 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Sergeants Major Academy - 0 | General Staff, Moldovan Army | 7/1/2020 | 2020-07-01 | 7/3/2020 | 2020-07-03 | Ft. Bliss, TX, US | 1 | 842 | 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 |
a71a43a8-2775-4b77-a48e-a794dcd91384 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Signal School - 0 | Signal Battalion, Moldovan Army | 7/1/2020 | 2020-07-01 | 7/1/2020 | 2020-07-01 | Ft. Gordon, GA, US | 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 |
e58411b5-1dcd-47b9-8baa-14a87ea45b92 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Signal School - 0 | Signal Battalion, Moldovan Army | 7/1/2020 | 2020-07-01 | 7/3/2020 | 2020-07-03 | Ft. Gordon, GA, US | 1 | 654 | 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 |
11e5b43a-77d9-4014-8554-ec159080ef55 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Command & General Staff College - 0 | J3 Operations, General Staff | 7/1/2020 | 2020-07-01 | 7/3/2020 | 2020-07-03 | Ft. Leavenworth, KS, US | 1 | 845 | 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 |
19b893e8-1f2f-40b7-bd38-e644d81b16de | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Air Defense Artillery School - 0 | 2nd Infantry Brigade, Moldovan Army | 7/1/2020 | 2020-07-01 | 7/31/2020 | 2020-07-31 | Ft. Sill, OK, US | 1 | 3608 | 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 |
d44bd221-d98f-40a0-8590-0a3581e8f9f1 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Ukraine | UKR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | College Of International Security Affairs - 0 | StratCom General Staff | 7/1/2020 | 2020-07-01 | 7/31/2020 | 2020-07-31 | Ft. Mcnair, NDU, DC, US | 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 |
b2a4c615-8001-4aa7-bfb2-b69d89ab772e | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Algeria | DZA | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | Army War College - 0 | Algerian Army | 7/1/2020 | 2020-07-01 | 7/30/2020 | 2020-07-30 | Carlisle Barracks, PA, US | 1 | 4710 | 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 |
4f249456-a2db-4808-b582-d59f163a1819 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2020 Department of State Training | Inside the Continental US (CONUS) Contractor Training | Egypt (In Country Training) - 0 | Army | 7/1/2020 | 2020-07-01 | 9/30/2020 | 2020-09-30 | Egypt (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 |
6fa82bc9-82bc-47d6-92a6-cac91b82b0ea | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Morocco | MAR | IMET-1 - Fiscal Year 2020 Department of State Training | COVID-19 EXT | USATC-Benning - 0 | 7TH Armor Group- OUMDRIGA | 7/1/2020 | 2020-07-01 | 9/30/2020 | 2020-09-30 | Ft. Benning, GA, US | 1 | 13578 | 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 |
486377ec-bc4a-4e6b-8215-aebfa9ee4ebf | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | IMET-2 - Fiscal Year 2020 Department of State Training | AWC Preparatory Course | Maxwell AFB, AL - 0 | No 25 Tactical Attack Squadron, Pakistan Air Force Base RAFIQUI, SHORKOT | 7/1/2020 | 2020-07-01 | 7/17/2020 | 2020-07-17 | Maxwell AFB, AL, US | 1 | 18203 | 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 |
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]);