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_first_seen" is on date -4707-05-28, "training:end_date" is on date 2011-08-25 and "training:start_date" is on date 2011-07-13 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
a5eaf500-420c-45fd-86ae-ccd012ae937e | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Africa_fmtrpt.tsv | Kenya | KEN | IMET-1 - Fiscal Year 2011 Department of State Training | ADV CALIBR MEAS & DIAGNOST | KEESLER AFB, MS - N/A | Kenya Air Force | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | KEESLER AFB, MS | 1 | 5325 | https://2009-2017.state.gov/documents/organization/197610.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
b4b9cd76-c71a-4cda-a7e6-ccb3b88c1c37 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Bolivia | BOL | IMET-1 - Fiscal Year 2011 Department of State Training | C-130/B/E/H/T-56 ENG TECH | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | C-130 Task Force \"Black Devils\" | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 2 | 14778 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
9dfb59f4-f838-4f65-81f6-d7dd8cdba8a9 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Bolivia | BOL | IMET-1 - Fiscal Year 2011 Department of State Training | CORROSION CONTROL TECHN | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | C-130 Task Force \"Black Devils\" | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 7539 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
0fbf66ed-c4b4-4b32-b085-e26a27633715 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Bolivia | BOL | Section 1004 - Fiscal Year 2011 Department of Defense Training | C-130/B/E/H/T-56 ENG TECH | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | C-130 Task Force \"Black Devils\" | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 7389 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
4c9c1ad8-02ce-43a5-93af-e2a6395ae254 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Bolivia | BOL | Section 1004 - Fiscal Year 2011 Department of Defense Training | CORROSION CONTROL TECHN | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | C-130 Task Force \"Black Devils\" | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 7539 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
cba03809-5813-4ca0-b979-41e2d265caa2 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Chile | RCH | IMET-1 - Fiscal Year 2011 Department of State Training | C-130/B/E/H/T-56 ENG TECH | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Academia Politecnica Aeronautica | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 7189 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
a4b1e10d-c3c4-422a-95ee-c5d4636f4583 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2011 Department of State Training | INTL LOG/SUPPLY MGMT CRS | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | CNMC - NATIONAL MAINTENANCE CENTER | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 880 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
e2531ebf-37ab-49dd-ae97-13b3027656c9 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2011 Department of State Training | INTL LOG/SUPPLY MGMT CRS | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | COLOMBIAN NAVY LOGISITCS HEADQUARTERS | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 880 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
e5cc1eda-e525-4586-939b-1d2c0b6d4ec4 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2011 Department of State Training | CORROSION CONTROL TECHN | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Air Transportaton Command | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 810 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
9c6894ee-9968-4086-9b06-59b225bceef0 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2011 Department of State Training | INTL LOG/SUPPLY MGMT CRS | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Colombian Air Force Aviation School | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 880 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
0f744a3a-cc81-4b86-b844-adc56d582f43 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2011 Department of State Training | INTL LOG/SUPPLY MGMT CRS | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Maintenance Air Command | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 880 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
b90fd34a-665e-44fa-9a7c-04e394a6ebea | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2011 Department of State Training | INTL SUPPLY/WAREHOUSE PRIN | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Colombian NCO Academy | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 3 | 2640 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
8598ef2e-8bae-4278-bb69-55ae3b969904 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - Fiscal Year 2011 Department of State Training | INTL LOG/SUPPLY MGMT CRS | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | COLOMBIAN NATIONAL POLICE, ANTINARCOTICS DIRECTORATE | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 880 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
3d2f99d4-64cd-41d0-836d-f75cbaf4dd3b | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - Fiscal Year 2011 Department of State Training | INTL LOG/SUPPLY MGMT CRS | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | COLOMBIAN NATIONAL POLICES | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 880 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
2f5d4131-ed9d-497d-b80c-3b6144922586 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - Fiscal Year 2011 Department of State Training | INTL SUPPLY/WAREHOUSE PRIN | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 7 | 6160 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
cf8a67c4-6589-4288-8252-201823f58385 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - Fiscal Year 2011 Department of Defense Training | CORROSION CONTROL TECHN | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Maintenance Squadron - Navy Aviation | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 6539 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
cc503976-af5f-4970-833f-bf6411859cc0 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - Fiscal Year 2011 Department of Defense Training | INTL LOG/SUPPLY MGMT CRS | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Army Finance Management | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 6639 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
55ba4a06-eb03-4fda-bb9a-19dcdba815fb | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - Fiscal Year 2011 Department of Defense Training | INTL LOG/SUPPLY MGMT CRS | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Navy Institute of Oceonography | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 6827 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
ddd4db52-d532-45c6-a0de-495640d9c653 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - Fiscal Year 2011 Department of Defense Training | INTL LOG/SUPPLY MGMT CRS | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Navy Logistics Management | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 6827 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
6e605e4e-dc24-4b79-90a9-e921d7d74d8a | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - Fiscal Year 2011 Department of Defense Training | INTL LOG/SUPPLY MGMT CRS | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Supply Management | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 6797 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
2b49d2b5-386e-4734-919e-42fa627f4d1d | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - Fiscal Year 2011 Department of Defense Training | INTL SUPPLY/WAREHOUSE PRIN | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Human Resources Management | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 6639 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
3e146a39-d28d-425d-8cc2-edcc216c412e | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - Fiscal Year 2011 Department of Defense Training | INTL SUPPLY/WAREHOUSE PRIN | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Second Division Logistics Battalion | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 6609 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
d01b063d-2645-45fd-bc9c-ad9f8e90ed46 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | El Salvador | SLV | IMET-1 - Fiscal Year 2011 Department of State Training | CORROSION CONTROL TECHN | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | ILOPANGO AIR FORCE BASE | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 7339 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
6ed21e85-c768-4e3a-96f2-08255abf35a0 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | INL - Fiscal Year 2011 Department of State Training | CORROSION CONTROL TECHN | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Secretaría de Seguridad Pública | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 6027 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
c2568095-c0af-4426-b787-74d9dd4d54c7 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | IMET-1 - Fiscal Year 2011 Department of State Training | WEAPONS SAFETY | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | PNP | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 6147 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
c5d3e115-06cb-4bca-9e1b-09ec25e8b96e | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | IMET-1 - Fiscal Year 2011 Department of State Training | WEAPONS SAFETY | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | SPI | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 5959 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
249553fe-eb5e-4594-8f16-85f07b8d7690 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Paraguay | PRY | IMET-1 - Fiscal Year 2011 Department of State Training | WEAPONS SAFETY | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Presidential Guard | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 7747 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
7d8c8091-d4da-41b4-aadf-c040a5d2e727 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Peru | PER | IMET-1 - Fiscal Year 2011 Department of State Training | CORROSION CONTROL TECHN | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | PERUVIAN AIR FORCE | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 7339 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
3d2db017-a2e5-452e-9ebc-16fd4fc8a1d6 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Peru | PER | INL - Fiscal Year 2011 Department of State Training | CORROSION CONTROL TECHN | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Directorate of Air Photography, Peruvian Air Force | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 7339 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
0456db33-eb85-4e22-883d-d661140ecb76 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Uruguay | URY | IMET-1 - Fiscal Year 2011 Department of State Training | C-130/B/E/H/T-56 ENG TECH | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX - N/A | Air Brigade I, Transportation Group | 7/13/2011 | 2011-07-13 | 8/25/2011 | 2011-08-25 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 6139 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
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]);