training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
34 rows where "qa:training_date_first_seen" is on date 2019-12-06 and "training:end_date" is on date 2017-11-22 sorted by training:id:admin
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1d267b51-f3ad-4a37-8c7f-3232b143f95e | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Europe_fmtrpt.tsv | Serbia, Republic of | SRB | IMET-1 - Fiscal Year 2018 Department of State Training | Military Intelligence BOLC-Branch | Intelligence School | Reconnaissance Company/Special Brigade | 7/27/2017 | 2017-07-27 | 11/22/2017 | 2017-11-22 | Ft. Huachuca, AZ, US | 1 | 22713 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
211a2074-8bfb-431c-a857-928ee6595c44 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Europe_fmtrpt.tsv | Ukraine | UKR | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Acquisition Negotiations | International Defense Acquisition Resource MA | Department Of Armament, MOD | 11/13/2017 | 2017-11-13 | 11/22/2017 | 2017-11-22 | Monterey, CA, US | 1 | 11417 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
22c93827-a6fa-4993-897f-08cf334ad4ed | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Europe_fmtrpt.tsv | Montenegro, Republic of | NME | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Acquisition Negotiations | International Defense Acquisition Resource MA | Defense Policy Directorate, MoD | 11/13/2017 | 2017-11-13 | 11/22/2017 | 2017-11-22 | Monterey, CA, US | 1 | 13217 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
2fb7135d-0c6a-4fd2-a283-e99aeff979d2 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Uganda | UGA | PKO - Fiscal Year 2018 Department of State Training | C-208 Recurrent Pilot Training | ONVOI Global Services | Uganda People's Defense Air Forces | 11/2/2017 | 2017-11-02 | 11/22/2017 | 2017-11-22 | DEFUNIAK SPRINGS, FL 32433 | 1 | 4025 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
3242a688-354a-4578-a9de-b49a8eecb6c3 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Europe_fmtrpt.tsv | Serbia, Republic of | SRB | Section 333 - Fiscal Year 2018 Department of Defense Training | Clandestine Lab Investigations | DOJ, ICITAP - 4 | Service for Drug Trafficking and Abuse of Drugs | 11/13/2017 | 2017-11-13 | 11/22/2017 | 2017-11-22 | Serbia | 30 | 90679 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
40a192a4-648f-4c21-968c-dbffdb740f1d | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Liberia | LBR | FMF - Fiscal Year 2018 Department of State Training | Logistics Captains Career (LOG-C-3) | ALU - Leader Courses | Headquarters, Armed Forces Of Liberia | 6/26/2017 | 2017-06-26 | 11/22/2017 | 2017-11-22 | Ft. Lee, VA, US | 1 | 29553 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
4a227329-77a1-4393-a44b-a5cb05afb88a | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Morocco | MAR | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Acquisition Negotiations | International Defense Acquisition Resource MA | Contract Service-ADN HQ | 11/13/2017 | 2017-11-13 | 11/22/2017 | 2017-11-22 | Monterey, CA, US | 1 | 11067 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
4a272198-b3c0-4c98-8593-d1f7cd1928e3 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Bahrain | BHR | IMET-1 - Fiscal Year 2018 Department of State Training | Physical Measurement & Calibration Journeyman (USAF) | Keesler AFB, MS | Royal Bahrain Air Force | 9/18/2017 | 2017-09-18 | 11/22/2017 | 2017-11-22 | Keesler AFB, MS, US | 1 | 700 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
4c978ae3-0514-4ace-8de8-2af6f83db58a | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Europe_fmtrpt.tsv | Georgia | GEO | IMET-1 - Fiscal Year 2018 Department of State Training | Engineer Basic Officer Leader-Branch | Engineer School | Engineer School, Krtsanisi Training Center | 7/11/2017 | 2017-07-11 | 11/22/2017 | 2017-11-22 | Ft. Leonard Wood, MO, US | 1 | 27331 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
4e6f1f9e-1640-4625-9ee7-b5a4f01dde16 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2018 Department of State Training | Logistics Captains Career (LOG-C-3) | ALU - Leader Courses | Directorate Of Maintenance Corps | 6/26/2017 | 2017-06-26 | 11/22/2017 | 2017-11-22 | Ft. Lee, VA, US | 1 | 29453 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
4e97c8fd-0c0b-4c4f-a428-a8a98fbd2067 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Uganda | UGA | PKO - Fiscal Year 2018 Department of State Training | C-208 Recurrent Pilot Training | ONVOI Global Services | Pilot | 11/2/2017 | 2017-11-02 | 11/22/2017 | 2017-11-22 | DEFUNIAK SPRINGS, FL 32433 | 1 | 4025 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
51b3eef8-78c9-4080-a243-de20a5c02d14 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2018 Department of State Training | C-130J SIM Refresher - Pilot | Keesler AFB, MS | 103RD Squadron | 11/19/2017 | 2017-11-19 | 11/22/2017 | 2017-11-22 | Keesler AFB, MS, US | 2 | 18140 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
53d901c6-0cc8-4de1-a572-5304fe15514c | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Oman | OMN | IMET-1 - Fiscal Year 2018 Department of State Training | Military Intelligence BOLC-Branch | Intelligence School | Royal Army Of Oman | 7/27/2017 | 2017-07-27 | 11/22/2017 | 2017-11-22 | Ft. Huachuca, AZ, US | 1 | 21815 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
78626ab4-68c5-4486-95c2-3c7231929eed | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2018 Department of State Training | Military Intelligence BOLC-Branch | Intelligence School | Border Guard Command | 7/27/2017 | 2017-07-27 | 11/22/2017 | 2017-11-22 | Ft. Huachuca, AZ, US | 1 | 23013 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
792fcda8-d805-49fb-9ee1-0ba6e9a369c1 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Kenya | KEN | IMET-1 - Fiscal Year 2018 Department of State Training | Logistics Captains Career (LOG-C-3) | ALU - Leader Courses | Kenya Army | 6/26/2017 | 2017-06-26 | 11/22/2017 | 2017-11-22 | Ft. Lee, VA, US | 1 | 29653 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
819f8946-26b1-4ab2-8cf3-06c74ecaaa27 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Acquisition Negotiations | International Defense Acquisition Resource MA | Coordinating Commission For Combat Aircraft | 11/13/2017 | 2017-11-13 | 11/22/2017 | 2017-11-22 | Monterey, CA, US | 1 | 3997 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
827b7ab0-320c-419c-8a6c-be7b2fa672e6 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Malaysia | MYS | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Acquisition Negotiations | International Defense Acquisition Resource MA | Eastern Fleet Maintenance Depot | 11/13/2017 | 2017-11-13 | 11/22/2017 | 2017-11-22 | Monterey, CA, US | 1 | 14067 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
849433f2-deca-494f-906d-e50b46394315 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Guinea | GIN | IMET-1 - Fiscal Year 2018 Department of State Training | Adjutant General Basic Officer Leader-Branch | Adjutant General School | Headquarters Battalion | 8/28/2017 | 2017-08-28 | 11/22/2017 | 2017-11-22 | Ft. Jackson, SC, US | 1 | 14837 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
8c97a768-8749-48d1-8774-5e32b7506d1a | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2018 Department of State Training | C-130J SIM Refresher - Loadmaster | Keesler AFB, MS | 103RD Squadron | 11/19/2017 | 2017-11-19 | 11/22/2017 | 2017-11-22 | Keesler AFB, MS, US | 1 | 4570 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
8fae0219-61ee-4e4d-aba0-eb883b55a6b1 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2018 Department of State Training | Military Intelligence BOLC-Branch | Intelligence School | Air Defense Directorate | 7/27/2017 | 2017-07-27 | 11/22/2017 | 2017-11-22 | Ft. Huachuca, AZ, US | 1 | 23201 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
95e7c55d-7bef-4fcd-a835-944a11427829 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Guinea | GIN | IMET-1 - Fiscal Year 2018 Department of State Training | Combat Medic Specialist | Medical Education Training Campus | Headquarters Battalion | 8/7/2017 | 2017-08-07 | 11/22/2017 | 2017-11-22 | Ft. Sam Houston, TX, US | 1 | 29350 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
993c1f56-080b-4a6e-bd80-977e422b4a4b | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Burkina Faso | BFA | IMET-1 - Fiscal Year 2018 Department of State Training | Logistics Captains Career (LOG-C-3) | ALU - Leader Courses | Armed Forces General Headquarters | 6/26/2017 | 2017-06-26 | 11/22/2017 | 2017-11-22 | Ft. Lee, VA, US | 1 | 29853 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
9ac3250c-37f9-40bb-bbc2-afd4b316a35d | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Swaziland | SWZ | IMET-1 - Fiscal Year 2018 Department of State Training | Adjutant General Basic Officer Leader-Branch | Adjutant General School | Swaziland Defense Force | 8/28/2017 | 2017-08-28 | 11/22/2017 | 2017-11-22 | Ft. Jackson, SC, US | 1 | 24407 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
9f88cd50-f9f5-4109-a44e-7411b6e41b53 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Djibouti | DJI | FMF - Fiscal Year 2018 Department of State Training | Adjutant General Basic Officer Leader-Branch | Adjutant General School | Djiboutian Armed Forces | 8/28/2017 | 2017-08-28 | 11/22/2017 | 2017-11-22 | Ft. Jackson, SC, US | 1 | 15112 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
a2e72910-1767-4fc5-8129-46eb124c37a5 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Bahrain | BHR | IMET-1 - Fiscal Year 2018 Department of State Training | Aircraft Structural Maintenance Apprentice | DET 1, 359 TRS AT Pensacola NAS | Royal Bahrain Air Force | 8/4/2017 | 2017-08-04 | 11/22/2017 | 2017-11-22 | Pensacola, FL, US | 1 | 1250 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
aa9c1732-eabc-4044-87bc-0eaff49bd2bb | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Sierra Leone | SLE | IMET-1 - Fiscal Year 2018 Department of State Training | SNCO Career Course USMC | Staff Non-Commissioned Officers Academy | Peace Mission Training Center-Hastings | 10/3/2017 | 2017-10-03 | 11/22/2017 | 2017-11-22 | Jacksonville, NC, US | 1 | 7704 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
b1d3019e-ff79-4f36-862c-16a932c6becb | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2018 Department of State Training | Observer | Keesler AFB, MS | 103RD Squadron | 11/19/2017 | 2017-11-19 | 11/22/2017 | 2017-11-22 | Keesler AFB, MS, US | 1 | 9070 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
c8fcaa25-9af2-4461-9e05-9183c1c8e01a | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2018 Department of State Training | Air Traffic Control Apprentice | Keesler AFB, MS | Air Operations Directorate | 8/14/2017 | 2017-08-14 | 11/22/2017 | 2017-11-22 | Keesler AFB, MS, US | 1 | 10579 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
ca69f0bf-e79d-4697-8545-3ae0ce0290db | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | South Africa | ZAF | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Acquisition Negotiations | International Defense Acquisition Resource MA | SA Army | 11/13/2017 | 2017-11-13 | 11/22/2017 | 2017-11-22 | Monterey, CA, US | 1 | 13217 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
caf502b2-bb1e-424b-a3c6-31e84eacab30 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Gabon | GAB | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Acquisition Negotiations | International Defense Acquisition Resource MA | Direction Of Operations | 11/13/2017 | 2017-11-13 | 11/22/2017 | 2017-11-22 | Monterey, CA, US | 1 | 16217 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
d881f52f-23cb-4320-9bfc-94551d9c8c98 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Liberia | LBR | IMET-1 - Fiscal Year 2018 Department of State Training | International Defense Acquisition Negotiations | International Defense Acquisition Resource MA | Ministry Of National Defense | 11/13/2017 | 2017-11-13 | 11/22/2017 | 2017-11-22 | Monterey, CA, US | 1 | 5569 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
e867ee0c-579e-4d45-84fc-fb2d7627b745 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2018 Department of State Training | Logistics Captains Career (LOG-C-3) | ALU - Leader Courses | DRIVING And Maintenance School | 6/26/2017 | 2017-06-26 | 11/22/2017 | 2017-11-22 | Ft. Lee, VA, US | 1 | 29453 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
ef5311d0-8d6d-4bb4-a653-d76a92604139 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2018 Department of State Training | Air Field Systems Apprentice | Keesler AFB, MS | Air Field Directorate | 7/24/2017 | 2017-07-24 | 11/22/2017 | 2017-11-22 | Keesler AFB, MS, US | 1 | 12121 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
ff8f763b-8502-4f7d-b130-93e9cd29aafa | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_East_Asia_and_Pacific_fmtrpt.tsv | Vietnam | VNM | IMET-1 - Fiscal Year 2018 Department of State Training | Logistics Captains Career (LOG-C-3) | ALU - Leader Courses | Military Logistics Academy | 6/26/2017 | 2017-06-26 | 11/22/2017 | 2017-11-22 | Ft. Lee, VA, US | 1 | 29953 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
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]);