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 "training:end_date" is on date 2009-05-29 and "training:start_date" is on date 2009-05-18 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
fd08a338-7de0-4c52-835e-5ca76fffbc49 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Africa_fmtrpt.tsv | Senegal | SEN | IMET-1 - FY 2009 DoS Training | CAPTAIN CAREER COMMON CORE (CLC3) | US unit not specified in 2009-2010 report | Material BN | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | ARMY LOGISTICS MANAGEMENT COLLEGE | 1 | 1460 | https://2009-2017.state.gov/documents/organization/155997.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
b0c61fc1-77ff-4406-8595-0e5f1b95b653 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_East_Asia_and_Pacific_fmtrpt.tsv | Papua-New Guinea | PNG | IMET-1 - FY 2009 DoS Training | INSTRUCTOR TNG COURSE | US unit not specified in 2009-2010 report | PAPUA NEW GUINEA DEFENSE FORCE 1405 | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | INFANTRY SCHOOL | 1 | https://2009-2017.state.gov/documents/organization/155998.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
2359b836-0131-4d33-b9db-16bdf1419946 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | FMF - FY 2009 DoS Training | CAPTAIN CAREER COMMON CORE (CLC3) | US unit not specified in 2009-2010 report | ON4 | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | ARMY LOGISTICS MANAGEMENT COLLEGE | 1 | 1460 | https://2009-2017.state.gov/documents/organization/155998.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
b9cc2dea-dae0-493d-971e-07e4fe094cf6 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - FY 2009 DoS Training | CAPTAIN CAREER COMMON CORE (CLC3) | US unit not specified in 2009-2010 report | 420TH SUPPLY WING | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | ARMY LOGISTICS MANAGEMENT COLLEGE | 1 | 1460 | https://2009-2017.state.gov/documents/organization/155998.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
e21f67c3-d5ad-4459-bf60-bd67feb4c145 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - FY 2009 DoS Training | CAPTAIN CAREER COMMON CORE (CLC3) | US unit not specified in 2009-2010 report | AFP Resource Management Office | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | ARMY LOGISTICS MANAGEMENT COLLEGE | 1 | 1460 | https://2009-2017.state.gov/documents/organization/155998.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
7f5cfd56-280e-408e-a211-279e47ca3889 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_East_Asia_and_Pacific_fmtrpt.tsv | Thailand | THA | IMET-1 - FY 2009 DoS Training | CAPTAIN CAREER COMMON CORE (CLC3) | US unit not specified in 2009-2010 report | 1st Ordnance Division, Chaengwattana Rd., Laksi, Bangkok | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | ARMY LOGISTICS MANAGEMENT COLLEGE | 1 | 1460 | https://2009-2017.state.gov/documents/organization/155998.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
2acc23df-b7ad-4afb-bbe6-ca95f1b703da | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Europe_fmtrpt.tsv | Azerbaijan | AZE | IMET-1 - FY 2009 DoS Training | CAPTAIN CAREER COMMON CORE (CLC3) | US unit not specified in 2009-2010 report | Army Unit | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | ARMY LOGISTICS MANAGEMENT COLLEGE | 1 | 1557 | https://2009-2017.state.gov/documents/organization/155999.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
1040b74b-f09c-48fc-8942-d38631da8400 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - FY 2009 DoS Training | CAPTAIN CAREER COMMON CORE (CLC3) | US unit not specified in 2009-2010 report | 95TH MISSILES' GRIGADE, AD | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | ARMY LOGISTICS MANAGEMENT COLLEGE | 1 | 1460 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
c7e424e1-1498-48e1-8164-bbbfb6862b3c | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - FY 2009 DoS Training | CH-47D FLIGHT SIMULATOR | US unit not specified in 2009-2010 report | KOM OUSHIM AIR BASE | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | EASTERN AVIATION TRAINING SITE | 1 | 8237 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
57bac851-6747-40db-ba87-3cf074af80b4 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - FY 2009 DoS Training | CH-47D FLIGHT SIMULATOR | US unit not specified in 2009-2010 report | KOM OUSHIM AIR BASE | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | EASTERN AVIATION TRAINING SITE | 1 | 8237 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
5d94faca-4b37-43a3-860e-b21b0056dfbb | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - FY 2009 DoS Training | CHEM BOLC3 INT'L STU PREP | US unit not specified in 2009-2010 report | CHEMICAL WARFAERE DEPT. | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | MANSCEN ARMY TRAINING CENTER | 1 | 5863 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
923f2dd0-9e10-4831-943c-80fcfa2dbb4f | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - FY 2009 DoS Training | UH-60A/L FLIGHT SIMULATOR | US unit not specified in 2009-2010 report | ALMAZA AIR BASE | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | EASTERN AVIATION TRAINING SITE | 1 | 8183 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
82bb85bc-0705-49f5-b462-9d749b81af5f | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - FY 2009 DoS Training | UH-60A/L FLIGHT SIMULATOR | US unit not specified in 2009-2010 report | ALMAZA AIR BASE | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | EASTERN AVIATION TRAINING SITE | 1 | 8183 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
6ca32c10-0414-439e-88e2-cce781d2601a | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - FY 2009 DoS Training | GENERAL ENGLISH ONLY | US unit not specified in 2009-2010 report | THE MILITARY OFFICE OF HIS MAJESTY THE KING (ROYAL | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | DLIELC, LACKLAND AFB TX | 1 | 1299 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
73d05ae3-c715-4e1a-871a-03948fa60937 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - FY 2009 DoS Training | CHEM BOLC3 INT'L STU PREP | US unit not specified in 2009-2010 report | CHEMICAL SUPPORTING UNIT | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | MANSCEN ARMY TRAINING CENTER | 1 | 6543 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
6b2170bf-ac23-4640-9216-3e1278dd5ef7 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Oman | OMN | IMET-1 - FY 2009 DoS Training | CAPTAIN CAREER COMMON CORE (CLC3) | US unit not specified in 2009-2010 report | RAO | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | ARMY LOGISTICS MANAGEMENT COLLEGE | 1 | 1460 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
417656d5-f65e-461f-b5ed-e65639be1d00 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_South_Central_Asia_fmtrpt.tsv | Kazakhstan | KAZ | IMET-1 - FY 2009 DoS Training | CAPTAIN CAREER COMMON CORE (CLC3) | US unit not specified in 2009-2010 report | Ministry of Defense | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | ARMY LOGISTICS MANAGEMENT COLLEGE | 1 | 1557 | https://2009-2017.state.gov/documents/organization/156001.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
38f2911c-7445-4d82-afab-9962008ea375 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | Regional Centers - FY 2009 DoD Training | US-Pakistan Strategic Dialogue 01-09 | US unit not specified in 2009-2010 report | Pakistan Navy | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | Washington, DC/Tampa, FL | 8 | 79350 | https://2009-2017.state.gov/documents/organization/156001.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
730236e2-f014-4e27-b7f4-532e5440ba5f | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | Regional Centers - FY 2009 DoD Training | US-Pakistan Strategic Dialogue 01-09 | US unit not specified in 2009-2010 report | Joint Staff | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | Washington, DC/Tampa, FL | 2 | 19838 | https://2009-2017.state.gov/documents/organization/156001.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
823bc77e-fb9f-4105-856f-efaf445d4253 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | Regional Centers - FY 2009 DoD Training | US-Pakistan Strategic Dialogue 01-09 | US unit not specified in 2009-2010 report | Pakistan Air Force | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | Washington, DC/Tampa, FL | 6 | 59513 | https://2009-2017.state.gov/documents/organization/156001.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
216715cf-d853-44c5-9519-a9bcda757731 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | Regional Centers - FY 2009 DoD Training | US-Pakistan Strategic Dialogue 01-09 | US unit not specified in 2009-2010 report | Pakistan Army | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | Washington, DC/Tampa, FL | 12 | 119025 | https://2009-2017.state.gov/documents/organization/156001.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
a26a09e8-160c-4141-b59e-fefee38a9ad9 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | IMET-1 - FY 2009 DoS Training | CAPTAIN CAREER COMMON CORE (CLC3) | US unit not specified in 2009-2010 report | Logistic Battalion | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | ARMY LOGISTICS MANAGEMENT COLLEGE | 1 | 612 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
bf7638ad-52aa-4f10-b68e-3da73b92aac9 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - FY 2009 DoD Training | MTT OUTBOARD MTR MAINT, ADV | US unit not specified in 2009-2010 report | Maint. Unit | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
e2dbb637-f5e8-4eee-8332-954b37c540b1 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - FY 2009 DoD Training | MTT OUTBOARD MTR MAINT, ADV | US unit not specified in 2009-2010 report | Maint. Unit | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
adadd868-27e8-43bb-b289-afb48b397845 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - FY 2009 DoD Training | MTT OUTBOARD MTR MAINT, ADV | US unit not specified in 2009-2010 report | Maint. Unit | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
0c45dc76-bbdc-4f77-962c-55bcaab9f987 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - FY 2009 DoD Training | MTT OUTBOARD MTR MAINT, ADV | US unit not specified in 2009-2010 report | Maint. Unit | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
1f65fa66-db58-49db-a2b5-cd3f9cfc1128 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - FY 2009 DoD Training | MTT OUTBOARD MTR MAINT, ADV | US unit not specified in 2009-2010 report | Maint. Unit | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
96ba301f-510f-43c0-a14e-58919fc19407 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - FY 2009 DoD Training | MTT OUTBOARD MTR MAINT, ADV | US unit not specified in 2009-2010 report | Maint. Unit | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
241fe32e-351c-4964-8605-bdb2ec95e9a3 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - FY 2009 DoD Training | MTT OUTBOARD MTR MAINT, ADV | US unit not specified in 2009-2010 report | Maint. Unit | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
602008ba-a4c7-4968-aa12-d83840c5d4a1 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - FY 2009 DoD Training | MTT OUTBOARD MTR MAINT, ADV | US unit not specified in 2009-2010 report | Maint. Unit | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
282bff9d-8725-4a64-99b8-4e146219c486 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - FY 2009 DoD Training | MTT OUTBOARD MTR MAINT, ADV | US unit not specified in 2009-2010 report | Operations Unit | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 32051 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
5b416331-c332-4b57-b40e-4e63182f0fa7 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - FY 2009 DoD Training | MTT OUTBOARD MTR MAINT, ADV | US unit not specified in 2009-2010 report | Maint. Unit | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
0f80f5bd-2cb8-48fe-a302-fe4afd5301ce | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - FY 2009 DoD Training | MTT OUTBOARD MTR MAINT, ADV | US unit not specified in 2009-2010 report | Maint. Unit | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
fc37d38c-2255-4547-bcf8-fade2360acb2 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - FY 2009 DoD Training | MTT OUTBOARD MTR MAINT, ADV | US unit not specified in 2009-2010 report | Maint. Unit | 5/18/2009 | 2009-05-18 | 5/29/2009 | 2009-05-29 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 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]);