training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
35 rows where "qa:training_date_first_seen" is on date -4707-05-25 and "training:end_date" is on date 2008-06-24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
035d531f-f56b-4546-8d17-06f78992032f | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - FY 2008 DoS Training | AIR MISSION COMMANDER (SP) | US unit not specified in 2008-2009 report | COLOMBIAN ARMY UH-60 HELICOPTER BATALLION | 6/4/2008 | 2008-06-04 | 6/24/2008 | 2008-06-24 | AVIATION SCHOOL | 1 | 7778 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
081027aa-9a88-4288-b76a-6669bf369a01 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - FY 2008 DoS Training | HAWK OFFICER COURSE | US unit not specified in 2008-2009 report | Air Defense | 4/22/2008 | 2008-04-22 | 6/24/2008 | 2008-06-24 | USAMMC (HAWK TRNG ONLY) | 1 | 37469 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
26bb2395-ac24-4ed6-bd6e-94f229857a72 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - FY 2008 DoS Training | AIR MISSION COMMANDER (SP) | US unit not specified in 2008-2009 report | COLOMBIAN ARMY UH-60 HELICOPTER BATALLION | 6/4/2008 | 2008-06-04 | 6/24/2008 | 2008-06-24 | AVIATION SCHOOL | 1 | 7778 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
27eec639-573c-42c8-ad24-dd0030a8a1c9 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - FY 2008 DoS Training | AIR MISSION COMMANDER (SP) | US unit not specified in 2008-2009 report | COLOMBIAN ARMY UH-60 HELICOPTER BATALLION | 6/4/2008 | 2008-06-04 | 6/24/2008 | 2008-06-24 | AVIATION SCHOOL | 1 | 7778 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
2f77dec5-bdd6-48fe-a9bd-f2d07bf55249 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_South_Central_Asia_fmtrpt.tsv | Sri Lanka | LKA | CTFP - FY 2008 DoD Training | INT OFR TACT INTEL CENTCOM | US unit not specified in 2008-2009 report | Internal Pilot -UAV | 5/13/2008 | 2008-05-13 | 6/24/2008 | 2008-06-24 | INTELLIGENCE SCHOOL | 1 | 11920 | https://2009-2017.state.gov/documents/organization/152773.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
362f3641-7d24-4763-a472-4882704087f4 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - FY 2008 DoS Training | HAWK OFFICER COURSE | US unit not specified in 2008-2009 report | AIR DEFENSE | 4/22/2008 | 2008-04-22 | 6/24/2008 | 2008-06-24 | USAMMC (HAWK TRNG ONLY) | 1 | 31662 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
3ee2b535-3a30-467d-a6e2-424113446486 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Peru | PER | INL - FY 2008 DoS Training | AIR MISSION COMMANDER (SP) | US unit not specified in 2008-2009 report | PERUVIAN NATIONAL POLICE-DIRAVPOL | 6/4/2008 | 2008-06-04 | 6/24/2008 | 2008-06-24 | AVIATION SCHOOL | 1 | 7768 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
4a2cb203-e257-437d-9d6b-495d59f0c99c | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_South_Central_Asia_fmtrpt.tsv | Bangladesh | BGD | IMET-1 - FY 2008 DoS Training | NAVAL STAFF COLLEGE | US unit not specified in 2008-2009 report | School of Maritime Warfare and Tactics | 8/1/2007 | 2007-08-01 | 6/24/2008 | 2008-06-24 | NAVAL STAFF COLLEGE NEWPORT RI | 1 | 108380 | https://2009-2017.state.gov/documents/organization/152773.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
4e848f4b-8ff0-4b90-97e6-69e6ea4d4bb7 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - FY 2008 DoS Training | AIR MISSION COMMANDER (SP) | US unit not specified in 2008-2009 report | COLOMBIAN ARMY UH-60 HELICOPTER BATALLION | 6/4/2008 | 2008-06-04 | 6/24/2008 | 2008-06-24 | AVIATION SCHOOL | 1 | 7778 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
5b653c60-4a51-4531-961b-fcea1f36ccc4 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_South_Central_Asia_fmtrpt.tsv | Sri Lanka | LKA | CTFP - FY 2008 DoD Training | INT OFR TACT INTEL CENTCOM | US unit not specified in 2008-2009 report | Operational Pilot | 5/13/2008 | 2008-05-13 | 6/24/2008 | 2008-06-24 | INTELLIGENCE SCHOOL | 1 | 11920 | https://2009-2017.state.gov/documents/organization/152773.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
620133c2-3da4-4a33-ac22-f5950f973397 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | CTFP - FY 2008 DoD Training | INT OFR TACT INTEL CENTCOM | US unit not specified in 2008-2009 report | 3 COMMANDO BATTALION, SSG | 5/13/2008 | 2008-05-13 | 6/24/2008 | 2008-06-24 | INTELLIGENCE SCHOOL | 1 | 14232 | https://2009-2017.state.gov/documents/organization/152773.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
62d3a946-0ec8-47f1-aac3-9677638ea352 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - FY 2008 DoS Training | AIR MISSION COMMANDER (SP) | US unit not specified in 2008-2009 report | COLOMBIAN ARMY UH-60 HELICOPTER BATALLION | 6/4/2008 | 2008-06-04 | 6/24/2008 | 2008-06-24 | AVIATION SCHOOL | 1 | 7778 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
63f2ce38-189b-482a-8e57-a20f65ffe73b | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_East_Asia_And_Pacific_fmtrpt.tsv | Papua-New Guinea | PNG | IMET-1 - FY 2008 DoS Training | MANEUVER ANCOC (INFANTRYMAN) | US unit not specified in 2008-2009 report | PAPUA NEW GUINEA DEFENCE FORCE | 6/18/2008 | 2008-06-18 | 6/24/2008 | 2008-06-24 | NCO ACADEMY - INFANTRY | 1 | 1043 | https://2009-2017.state.gov/documents/organization/152767.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
656ec3cd-6fb3-4e28-8f4f-7beed3c0f5f5 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Bahrain | BHR | IMET-1 - FY 2008 DoS Training | FUELS APPRENTICE | US unit not specified in 2008-2009 report | ROYAL BAHRAIN AIR FORCE | 5/12/2008 | 2008-05-12 | 6/24/2008 | 2008-06-24 | SHEPPARD AFB, TX | 1 | 1140 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
84df4805-81e6-4824-8796-137040014aa8 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Oman | OMN | IMET-1 - FY 2008 DoS Training | NAVAL STAFF COLLEGE | US unit not specified in 2008-2009 report | ROYAL NAVY OF OMAN | 1/16/2008 | 2008-01-16 | 6/24/2008 | 2008-06-24 | NAVAL STAFF COLLEGE NEWPORT RI | 1 | 55071 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
8ddcb5dc-48f9-48a2-9e8d-b6c4c7e7620c | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Jordan | JOR | CTFP - FY 2008 DoD Training | INT OFR TACT INTEL CENTCOM | US unit not specified in 2008-2009 report | Directorate of Military Intelligence | 5/13/2008 | 2008-05-13 | 6/24/2008 | 2008-06-24 | INTELLIGENCE SCHOOL | 1 | 11144 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
93ed2b8e-cebd-43f7-9b71-e160dd0ee8cd | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | IMET-1 - FY 2008 DoS Training | NAVAL STAFF COLLEGE | US unit not specified in 2008-2009 report | Marine Corps Battallion No. 21 Jaramijo | 1/16/2008 | 2008-01-16 | 6/24/2008 | 2008-06-24 | NAVAL STAFF COLLEGE NEWPORT RI | 1 | 40650 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
95224a5b-21ec-467b-b49b-0cd104779265 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Bolivia | BOL | Section 1004 - FY 2008 DoD Training | AIR MISSION COMMANDER (SP) | US unit not specified in 2008-2009 report | UH-1 Task Force \"Red Devils\", Bolivian Air Force | 6/4/2008 | 2008-06-04 | 6/24/2008 | 2008-06-24 | AVIATION SCHOOL | 1 | 7739 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
9e19c611-4adf-4d3c-a8c7-87f36cf087b3 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | IMET-1 - FY 2008 DoS Training | AIR MISSION COMMANDER (SP) | US unit not specified in 2008-2009 report | Rescue Squadron | 6/4/2008 | 2008-06-04 | 6/24/2008 | 2008-06-24 | AVIATION SCHOOL | 1 | 5889 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
a1afa64a-9af5-41e0-ad12-97c223f261ed | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 1004 - FY 2008 DoD Training | AIR MISSION COMMANDER (SP) | US unit not specified in 2008-2009 report | NAVAL AVIATION PACIFIC GROUP, MALAGA | 6/4/2008 | 2008-06-04 | 6/24/2008 | 2008-06-24 | AVIATION SCHOOL | 1 | 7473 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
ac08c973-2a73-4aa6-85ee-eecb8f691527 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_South_Central_Asia_fmtrpt.tsv | Bangladesh | BGD | IMET-1 - FY 2008 DoS Training | NAVAL COMMAND COLLEGE | US unit not specified in 2008-2009 report | Naval HQ | 8/1/2007 | 2007-08-01 | 6/24/2008 | 2008-06-24 | NAVAL COMMAND COLLEGE NEWPORT RI | 1 | 110136 | https://2009-2017.state.gov/documents/organization/152773.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
b22d9e9b-8acd-44f8-8bf0-5dec44b1b9ce | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | CTFP - FY 2008 DoD Training | INT OFR TACT INTEL CENTCOM | US unit not specified in 2008-2009 report | 313 Intelligence Battalion | 5/13/2008 | 2008-05-13 | 6/24/2008 | 2008-06-24 | INTELLIGENCE SCHOOL | 1 | 14114 | https://2009-2017.state.gov/documents/organization/152773.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
b71cbbfe-25fa-4ebf-aedb-711f96a2a6fc | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Jordan | JOR | CTFP - FY 2008 DoD Training | INT OFR TACT INTEL CENTCOM | US unit not specified in 2008-2009 report | Directorate of Military Intelligence | 5/13/2008 | 2008-05-13 | 6/24/2008 | 2008-06-24 | INTELLIGENCE SCHOOL | 1 | 11144 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
b84c6872-16f2-497a-8ca3-4636686e28ea | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_South_Central_Asia_fmtrpt.tsv | Kazakhstan | KAZ | Regional Centers - FY 2008 DoD Training | Kazakhstan Defense Education Enhancement Program | US unit not specified in 2008-2009 report | Kazak MoD | 6/23/2008 | 2008-06-23 | 6/24/2008 | 2008-06-24 | Astana, Kaz | 15 | 20000 | https://2009-2017.state.gov/documents/organization/152773.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
bb2bbd62-3d58-4091-bfda-763b14df717e | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Republic of Serbia | SRB | IMET-1 - FY 2008 DoS Training | MANEUVER ANCOC (INFANTRYMAN) | US unit not specified in 2008-2009 report | ANTITERRORIST BATALLION | 6/18/2008 | 2008-06-18 | 6/24/2008 | 2008-06-24 | NCO ACADEMY - ARMOR | 1 | 768 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
c06cf955-a970-49bf-821d-8f2474e24797 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - FY 2008 DoS Training | AIR MISSION COMMANDER (SP) | US unit not specified in 2008-2009 report | COLOMBIAN ARMY UH-60 HELICOPTER BATALLION | 6/4/2008 | 2008-06-04 | 6/24/2008 | 2008-06-24 | AVIATION SCHOOL | 1 | 7778 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
c0ac3515-b84e-469a-81f6-577b9051e576 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - FY 2008 DoS Training | HAWK OFFICER COURSE | US unit not specified in 2008-2009 report | Air Defense | 4/22/2008 | 2008-04-22 | 6/24/2008 | 2008-06-24 | USAMMC (HAWK TRNG ONLY) | 1 | 31642 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
c2fd22f7-7535-4a65-9cfb-d24821fb032d | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Jordan | JOR | CTFP - FY 2008 DoD Training | INT OFR TACT INTEL CENTCOM | US unit not specified in 2008-2009 report | Directorate of Military Intelligence | 5/13/2008 | 2008-05-13 | 6/24/2008 | 2008-06-24 | INTELLIGENCE SCHOOL | 1 | 11144 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
c4e1594b-6983-42af-bd7e-21190aab3524 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Bolivia | BOL | Section 1004 - FY 2008 DoD Training | AIR MISSION COMMANDER (SP) | US unit not specified in 2008-2009 report | UH-1 Task Force \"Red Devils\", Bolivian Air Force | 6/4/2008 | 2008-06-04 | 6/24/2008 | 2008-06-24 | AVIATION SCHOOL | 1 | 7739 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
cb198ebb-33b7-4b66-9666-4271ab1e8637 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - FY 2008 DoS Training | HAWK OFFICER COURSE | US unit not specified in 2008-2009 report | AIR DEFENSE | 4/22/2008 | 2008-04-22 | 6/24/2008 | 2008-06-24 | USAMMC (HAWK TRNG ONLY) | 1 | 31152 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
cb5a10ff-1dca-47f5-8b56-65163aa1c3e3 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Jordan | JOR | CTFP - FY 2008 DoD Training | INT OFR TACT INTEL CENTCOM | US unit not specified in 2008-2009 report | Directorate of Military Intelligence | 5/13/2008 | 2008-05-13 | 6/24/2008 | 2008-06-24 | INTELLIGENCE SCHOOL | 1 | 11144 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
d1891a01-7208-4221-a80b-3ec2dd5324b5 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - FY 2008 DoS Training | AIR MISSION COMMANDER (SP) | US unit not specified in 2008-2009 report | COLOMBIAN ARMY UH-60 HELICOPTER BATALLION | 6/4/2008 | 2008-06-04 | 6/24/2008 | 2008-06-24 | AVIATION SCHOOL | 1 | 7778 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e39b2e9f-7580-4db5-89a0-946a191e5258 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Israel | ISR | FMF - FY 2008 DoS Training | THEATER AIR OPNS COURSE | US unit not specified in 2008-2009 report | IAF-BASE 10 | 6/2/2008 | 2008-06-02 | 6/24/2008 | 2008-06-24 | TYNDALL AFB, FL | 1 | 4540 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f56561d8-5af6-4b1b-ac10-556cc7e8577c | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - FY 2008 DoS Training | AIR MISSION COMMANDER (SP) | US unit not specified in 2008-2009 report | COLOMBIAN ARMY UH-60 HELICOPTER BATALLION | 6/4/2008 | 2008-06-04 | 6/24/2008 | 2008-06-24 | AVIATION SCHOOL | 1 | 7778 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f5fb2b0f-c92f-432d-9216-7f5b1656e31b | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Israel | ISR | FMF - FY 2008 DoS Training | THEATER AIR OPNS COURSE | US unit not specified in 2008-2009 report | IAF-BASE 10 | 6/2/2008 | 2008-06-02 | 6/24/2008 | 2008-06-24 | TYNDALL AFB, FL | 1 | 4540 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 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]);