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:end_date" is on date 2020-09-03 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0495f1ef-764e-44b1-abd2-077e45425752 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Finland | FIN | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - High North Security: Developments In the Shadow Of COVID-19 | GCMC - 0 | Finland Ministry for Foreign Affairs | 9/3/2020 | 2020-09-03 | 9/3/2020 | 2020-09-03 | 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 |
cabbb54a-c9d1-4436-9ab8-740c5b0f26f7 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Finland | FIN | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - High North Security: Developments In the Shadow Of COVID-19 | GCMC - 0 | Finland University of Helsinki | 9/3/2020 | 2020-09-03 | 9/3/2020 | 2020-09-03 | 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 |
129be5e8-63bb-4312-a234-3f18a703c6c2 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Finland | FIN | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - High North Security: Developments In the Shadow Of COVID-19 | GCMC - 0 | Finland University of Oulu | 9/3/2020 | 2020-09-03 | 9/3/2020 | 2020-09-03 | 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 |
f2ace1fa-526e-4f9f-a146-b4f2fed83fcd | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Sweden | SWE | Regional Centers - Fiscal Year 2020 Department of Defense Training | Virtual - High North Security: Developments In the Shadow Of COVID-19 | GCMC - 0 | Swedish Defense University | 9/3/2020 | 2020-09-03 | 9/3/2020 | 2020-09-03 | 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 |
f1435f1d-b1e8-4eb4-a9de-3231ab3198bc | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Jordan | JOR | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Royal Jordan National Defense College Faculty Development Seminar | NESA - 0 | Jordan Ministry of Defense | 8/31/2020 | 2020-08-31 | 9/3/2020 | 2020-09-03 | Virtual - Event | 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 |
0fbd6f2d-eacc-447c-98dc-84775322967a | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Jordan | JOR | Regional Centers - Fiscal Year 2020 Department of Defense Training | NESA Royal Jordan National Defense College Faculty Development Seminar | NESA - 0 | Royal Jordan National Defense College | 8/31/2020 | 2020-08-31 | 9/3/2020 | 2020-09-03 | Virtual - Event | 22 | 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 |
91ee5d2f-1268-4f01-8095-59c7c6e22934 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Liberia | LBR | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Armed Forces Of Liberia | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8345 | 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 |
f2be140d-ebe3-4c76-9915-35a7721f2714 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Malawi | MWI | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Kamuzu Barracks, Malawi Defense Force Headquarters | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8345 | 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 |
8c17356b-8439-4251-8799-0db2ede4423b | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Nigeria | NGA | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Nigerian Army Headquarters Abuja | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8345 | 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 |
823288a5-3562-4749-abe8-a749c6138e66 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Senegal | SEN | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Support Group Air Force | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8673 | 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 |
39676007-342b-4266-ab64-84d446898939 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Sierra Leone | SLE | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | 5 Infantry Battalion | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8345 | 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 |
bdcca4f9-183e-46f1-ac49-a359c6a93bec | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Uganda | UGA | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Non COMMISSIONED Academy- JINJA | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8345 | 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 |
0aa694a5-10ae-4804-afed-14f456a5e9ce | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Office Of the Sergeant Major, Philippine Army | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8345 | 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 |
e249b972-7465-4489-addb-25c4ca3c5dbe | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Bosnia & Herzegovina | BIH | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | EOD Company | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8673 | 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 |
bac6000a-8c51-4581-8072-66b9ab31e353 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Georgia | GEO | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Georgian Special Operations Forces | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8345 | 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 |
04f965ee-093d-4498-a5d6-b138cfbd0e9e | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Georgia | GEO | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Joint Training And Evaluation Center, Training And Military Education Department | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8345 | 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 |
77477f91-df26-4780-8c49-088d1271253c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Kosovo | XKX | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Center For University Studies, KSF | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8345 | 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 |
50c4a90b-f194-4afe-88e9-9690a8232e70 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Kosovo | XKX | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | TRADOC, Training Center, KSF | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8345 | 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 |
891782b1-1635-4b5d-8c4a-79fc14ebe28b | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Special Forces Battalion, Moldovan Army | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8345 | 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 |
5b89aaaa-b969-4d74-a98f-b161bb773b46 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Iraq | IRQ | FMF - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Ministry Of Peshmerga, General Directorate Of Intelligence | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8837 | 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 |
8577bce8-c2e9-41b8-ab72-0aae45fec4dd | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Iraq | IRQ | FMF - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Ministry Of Peshmerga, Second Bridage, Management | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8837 | 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 |
eb54a393-2410-456b-9640-9e11ac97941f | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | MIDDILE Military Command | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8673 | 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 |
75ffcb52-01b9-4d26-b344-2c23fcfa3d42 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Army Intelligence Center | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 4245 | 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 |
2e708f0f-757d-4d42-8451-797cb4b705ad | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Colombian Army | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 8673 | 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 |
0bc9a91e-2569-41c6-9d15-b6b2ba9c7851 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Jamaica | JAM | IMET-1 - Fiscal Year 2020 Department of State Training | SGM International MIL Students Pre-Course | Sergeants Major Academy - 0 | Jamaica Defense Force | 8/17/2020 | 2020-08-17 | 9/3/2020 | 2020-09-03 | Ft. Bliss, TX, US | 1 | 15583 | 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 |
7a90904e-a7a4-40fc-8cc1-6bfc155c4db5 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Uganda | UGA | PKO - Fiscal Year 2020 Department of State Training | C-208 - Pilot Seasoning | Brunner Aerospace - Georgetown, TX - 0 | Uganda People s Defense Air Forces Airbase, Entebbe | 8/10/2020 | 2020-08-10 | 9/3/2020 | 2020-09-03 | Georgetown, TX | 1 | 2146 | 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 |
e08b6d19-eb4f-495b-85b2-3abbb25f7269 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Uganda | UGA | PKO - Fiscal Year 2020 Department of State Training | C-208 - Pilot Seasoning | Brunner Aerospace - Georgetown, TX - 0 | Uganda People s Defense Air Forces, Airbase Entebbe | 8/10/2020 | 2020-08-10 | 9/3/2020 | 2020-09-03 | Georgetown, TX | 1 | 2146 | 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 |
f68a4494-8132-4ce4-9a05-b42de11a36f4 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | Avionics Mechanic | UNK - 0 | Colombian Army | 6/30/2020 | 2020-06-30 | 9/3/2020 | 2020-09-03 | Tolemaida | 2 | 61206 | 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 |
f07235c9-90b2-40fa-955d-ac327fce89e6 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | Avionics Mechanic | UNK - 0 | Colombian National Police | 6/30/2020 | 2020-06-30 | 9/3/2020 | 2020-09-03 | Tolemaida | 1 | 30603 | 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 |
9ead035a-36c4-48e2-84c1-f501b06dc88d | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | Avionics Mechanic | UNK - 0 | Colombian Navy | 6/30/2020 | 2020-06-30 | 9/3/2020 | 2020-09-03 | Tolemaida | 1 | 30603 | 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 |
c870eb59-f557-456f-ae36-4c59e96e2709 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Zambia | ZMB | IMET-1 - Fiscal Year 2020 Department of State Training | Air Field Operations Officer | Keesler AFB, MS - 0 | Military | 5/26/2020 | 2020-05-26 | 9/3/2020 | 2020-09-03 | Keesler AFB, MS, US | 1 | 11795 | 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 |
66ac5446-a6aa-4e27-9742-69d2dd494e56 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2020 Department of State Training | ET Combined A School Electronics TECH (Block 0) | CSCS Unit Great Lakes IL - 0 | Air Defense Directorate | 3/12/2020 | 2020-03-12 | 9/3/2020 | 2020-09-03 | Great Lakes, IL, US | 1 | 43360 | 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]);