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-27 and "training:end_date" is on date 2010-05-06 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2fd642cd-1965-4ef0-af83-97aafb4ea064 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Europe_fmtrpt.tsv | Croatia | HRV | CTFP - Fiscal Year 2010 Department of Defense Training | MET REGIONAL DIILS | US unit not specified in 2010-2011 report | CHIEF OF DEFENSE CABINET | 5/3/2010 | 2010-05-03 | 5/6/2010 | 2010-05-06 | BOSNIA-HERCEGOVINA (IN COUNTRY TRAINING) | 1 | 1210 | https://2009-2017.state.gov/documents/organization/171511.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
3cb91ef2-3f4d-43af-a1ff-c9476fc44569 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Europe_fmtrpt.tsv | Macedonia | MKD | CTFP - Fiscal Year 2010 Department of Defense Training | MET REGIONAL DIILS | US unit not specified in 2010-2011 report | MILITARY SERVICE FOR INTELLIGENCE AND SECURITY | 5/3/2010 | 2010-05-03 | 5/6/2010 | 2010-05-06 | BOSNIA-HERCEGOVINA (IN COUNTRY TRAINING) | 1 | 960 | https://2009-2017.state.gov/documents/organization/171511.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
d8e50217-cb86-45ec-b32f-fd50de8d0dd7 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2010 Department of State Training | AH-64A FLIGHT SIM (CMS) | US unit not specified in 2010-2011 report | IAF-AIR WING 25 | 5/3/2010 | 2010-05-03 | 5/6/2010 | 2010-05-06 | EASTERN AVIATION TRAINING SITE | 1 | 2744 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
c52c59e4-a17a-4bc6-a946-157375d9adea | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2010 Department of State Training | AH-64A FLIGHT SIM (CMS) | US unit not specified in 2010-2011 report | IAF-AIR WING 25 | 5/3/2010 | 2010-05-03 | 5/6/2010 | 2010-05-06 | EASTERN AVIATION TRAINING SITE | 1 | 2744 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
5041e820-b058-4838-8520-ef5ab39b4657 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2010 Department of State Training | AH-64A FLIGHT SIM (CMS) | US unit not specified in 2010-2011 report | IAF-AIR WING 25 | 5/3/2010 | 2010-05-03 | 5/6/2010 | 2010-05-06 | EASTERN AVIATION TRAINING SITE | 1 | 2744 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
8b04fd88-59d9-44b8-93bd-89ea14a38348 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2010 Department of State Training | AH-64A FLIGHT SIM (CMS) | US unit not specified in 2010-2011 report | IAF-AIR WING 25 | 5/3/2010 | 2010-05-03 | 5/6/2010 | 2010-05-06 | EASTERN AVIATION TRAINING SITE | 1 | 2744 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
82a40d1f-d8b0-4f1b-b0c2-14e85dde3155 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2010 Department of State Training | AH-64A FLIGHT SIM (CMS) | US unit not specified in 2010-2011 report | IAF-AIR WING 25 | 5/3/2010 | 2010-05-03 | 5/6/2010 | 2010-05-06 | EASTERN AVIATION TRAINING SITE | 1 | 2744 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
ebeb0757-5418-4934-b4de-17bf47190fa2 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2010 Department of State Training | AH-64A FLIGHT SIM (CMS) | US unit not specified in 2010-2011 report | IAF-AIR WING 25 | 5/3/2010 | 2010-05-03 | 5/6/2010 | 2010-05-06 | EASTERN AVIATION TRAINING SITE | 1 | 2744 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
3cf3443f-cb5a-46fa-8ea5-5009a09f5730 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2010 Department of State Training | MINE COUNTERMEASURES FOR INT'L OFFICERS | US unit not specified in 2010-2011 report | NAVAL HQ, RAS ELTIN | 4/19/2010 | 2010-04-19 | 5/6/2010 | 2010-05-06 | PMWS | 1 | 2936 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
bdf297fc-0ce8-4add-80ba-ebcca033688e | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2010 Department of Defense Training | BRISTOW BELL 412 NVG TRAINING | US unit not specified in 2010-2011 report | SEDENA | 4/19/2010 | 2010-04-19 | 5/6/2010 | 2010-05-06 | DBTWFLTI | 1 | 738 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
59e56b7b-6959-472e-8fea-194bd7630ea1 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2010 Department of Defense Training | BRISTOW BELL 412 NVG TRAINING | US unit not specified in 2010-2011 report | SEDENA | 4/19/2010 | 2010-04-19 | 5/6/2010 | 2010-05-06 | DBTWFLTI | 1 | 738 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
752fd52a-5055-437d-84f8-0a83222e2220 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Africa_fmtrpt.tsv | Sierra Leone | SLE | Regional Centers - Fiscal Year 2010 Department of Defense Training | CARIBBEAN DEFENSE & SECURITY | US unit not specified in 2010-2011 report | N/A | 4/14/2010 | 2010-04-14 | 5/6/2010 | 2010-05-06 | Washington, DC | 1 | 10000 | https://2009-2017.state.gov/documents/organization/171509.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
e9309d9d-31cf-4a49-ad84-a2fa8b506405 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Antigua and Barbuda | ATG | Regional Centers - Fiscal Year 2010 Department of Defense Training | CARIBBEAN DEFENSE & SECURITY | US unit not specified in 2010-2011 report | N/A | 4/14/2010 | 2010-04-14 | 5/6/2010 | 2010-05-06 | Washington, DC | 2 | 20000 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
8d7bca73-3d01-4c1e-bbdc-72abd3a9770c | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Bahamas | BHS | Regional Centers - Fiscal Year 2010 Department of Defense Training | CARIBBEAN DEFENSE & SECURITY | US unit not specified in 2010-2011 report | N/A | 4/14/2010 | 2010-04-14 | 5/6/2010 | 2010-05-06 | Washington, DC | 1 | 10000 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
a6a3d40d-d3b1-4326-8108-168b4d5018f7 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Barbados | BRB | Regional Centers - Fiscal Year 2010 Department of Defense Training | CARIBBEAN DEFENSE & SECURITY | US unit not specified in 2010-2011 report | N/A | 4/14/2010 | 2010-04-14 | 5/6/2010 | 2010-05-06 | Washington, DC | 1 | 10000 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
ea13a517-be1a-4bfc-820e-a53f3f97e0b1 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Belize | BLZ | Regional Centers - Fiscal Year 2010 Department of Defense Training | CARIBBEAN DEFENSE & SECURITY | US unit not specified in 2010-2011 report | N/A | 4/14/2010 | 2010-04-14 | 5/6/2010 | 2010-05-06 | Washington, DC | 2 | 20000 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
d2dd632b-cac3-4aa5-8cc6-20c14145eac8 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Regional Centers - Fiscal Year 2010 Department of Defense Training | CARIBBEAN DEFENSE & SECURITY | US unit not specified in 2010-2011 report | N/A | 4/14/2010 | 2010-04-14 | 5/6/2010 | 2010-05-06 | Washington, DC | 3 | 20000 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
b70111a6-977f-4600-9c06-81d58babb770 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Grenada | GRD | Regional Centers - Fiscal Year 2010 Department of Defense Training | CARIBBEAN DEFENSE & SECURITY | US unit not specified in 2010-2011 report | N/A | 4/14/2010 | 2010-04-14 | 5/6/2010 | 2010-05-06 | Washington, DC | 1 | 10000 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
38cb0334-56b2-4a49-9b77-841234aaed85 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Guyana | GUY | Regional Centers - Fiscal Year 2010 Department of Defense Training | CARIBBEAN DEFENSE & SECURITY | US unit not specified in 2010-2011 report | N/A | 4/14/2010 | 2010-04-14 | 5/6/2010 | 2010-05-06 | Washington, DC | 3 | 30000 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
1e1bf4db-b595-410a-8e96-b1857510e01a | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Jamaica | JAM | Regional Centers - Fiscal Year 2010 Department of Defense Training | CARIBBEAN DEFENSE & SECURITY | US unit not specified in 2010-2011 report | N/A | 4/14/2010 | 2010-04-14 | 5/6/2010 | 2010-05-06 | Washington, DC | 9 | 90000 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
340d7a3b-b6ca-4194-8e4e-2e35641c4b67 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2010 Department of Defense Training | CARIBBEAN DEFENSE & SECURITY | US unit not specified in 2010-2011 report | N/A | 4/14/2010 | 2010-04-14 | 5/6/2010 | 2010-05-06 | Washington, DC | 1 | 10000 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
8d3e57ad-446a-47d3-ae37-2dcec7986457 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | St Lucia | LCA | Regional Centers - Fiscal Year 2010 Department of Defense Training | CARIBBEAN DEFENSE & SECURITY | US unit not specified in 2010-2011 report | N/A | 4/14/2010 | 2010-04-14 | 5/6/2010 | 2010-05-06 | Washington, DC | 3 | 30000 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
fccaf6b9-886a-4283-9dce-d3cb42d4f8b7 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Suriname | SUR | Regional Centers - Fiscal Year 2010 Department of Defense Training | CARIBBEAN DEFENSE & SECURITY | US unit not specified in 2010-2011 report | N/A | 4/14/2010 | 2010-04-14 | 5/6/2010 | 2010-05-06 | Washington, DC | 1 | 20000 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
f14687b2-c134-4dea-811b-769f6b6abc7a | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Trinidad and Tobago | TTO | Regional Centers - Fiscal Year 2010 Department of Defense Training | CARIBBEAN DEFENSE & SECURITY | US unit not specified in 2010-2011 report | N/A | 4/14/2010 | 2010-04-14 | 5/6/2010 | 2010-05-06 | Washington, DC | 5 | 50000 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
ab6c3810-1ea7-4d80-ad38-3d645c9d3d62 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Europe_fmtrpt.tsv | Georgia | GEO | DOHS/USCG - Fiscal Year 2010 Department of Homeland Security Training | BOARDING OFF BASIC EIMET | US unit not specified in 2010-2011 report | COAST GUARD | 4/5/2010 | 2010-04-05 | 5/6/2010 | 2010-05-06 | USCG MARITIME LAW ENFORCEMENT ACAD FLETC CHARLESTON | 1 | 6205 | https://2009-2017.state.gov/documents/organization/171511.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
54f804a1-7a73-43cf-8afe-01a63e02996f | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Europe_fmtrpt.tsv | Georgia | GEO | DOHS/USCG - Fiscal Year 2010 Department of Homeland Security Training | BOARDING OFF BASIC EIMET | US unit not specified in 2010-2011 report | COAST GUARD | 4/5/2010 | 2010-04-05 | 5/6/2010 | 2010-05-06 | USCG MARITIME LAW ENFORCEMENT ACAD FLETC CHARLESTON | 1 | 6205 | https://2009-2017.state.gov/documents/organization/171511.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
557316a6-0775-47ea-8461-c46ab51d5e38 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2010 Department of Defense Training | BELL 412 NVG TRAINING | US unit not specified in 2010-2011 report | SEDENA | 2/22/2010 | 2010-02-22 | 5/6/2010 | 2010-05-06 | DBTWFLTI | 1 | 738 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
e4e7a12a-ddd4-47cc-a78e-b1b54d9f37d3 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2010 Department of Defense Training | BELL 412 NVG TRAINING | US unit not specified in 2010-2011 report | SEDENA | 2/22/2010 | 2010-02-22 | 5/6/2010 | 2010-05-06 | DBTWFLTI | 1 | 738 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
65e97dad-96da-4c2a-95ec-f1e709e2ae81 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2010 Department of Defense Training | BELL 412 NVG TRAINING | US unit not specified in 2010-2011 report | SEDENA | 2/22/2010 | 2010-02-22 | 5/6/2010 | 2010-05-06 | DBTWFLTI | 1 | 738 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
38ca395c-1ed4-41d0-8330-990e06467244 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2010 Department of State Training | UH-60 HELICOPTER REPAIRER SUPERVISOR SPANISH | US unit not specified in 2010-2011 report | COLOMBAIN ARMY AVIATION BRIGADE | 2/17/2010 | 2010-02-17 | 5/6/2010 | 2010-05-06 | AVIATION LOGISTICS SCHOOL | 1 | 9645 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
5eb3d158-73b3-4d00-b1e9-abe971901c21 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2010 Department of State Training | UH-60 HELICOPTER REPAIRER SUPERVISOR SPANISH | US unit not specified in 2010-2011 report | COLOMBIAN ARMY AVIATION BRIGADE | 2/17/2010 | 2010-02-17 | 5/6/2010 | 2010-05-06 | AVIATION LOGISTICS SCHOOL | 1 | 9645 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
04e72fc3-0bd5-45ea-b875-4d3ed4f0cbad | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2010 Department of State Training | UH-60 HELICOPTER REPAIRER SUPERVISOR SPANISH | US unit not specified in 2010-2011 report | COLOMBIAN ARMY AVIATION BRIGADE | 2/17/2010 | 2010-02-17 | 5/6/2010 | 2010-05-06 | AVIATION LOGISTICS SCHOOL | 1 | 9645 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
2cd5c72e-7338-4750-b08d-e454353656c4 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2010 Department of State Training | UH-60 HELICOPTER REPAIRER SUPERVISOR SPANISH | US unit not specified in 2010-2011 report | COLOMBIAN ARMY AVIATION BRIGADE | 2/17/2010 | 2010-02-17 | 5/6/2010 | 2010-05-06 | AVIATION LOGISTICS SCHOOL | 1 | 9645 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
f06fc67c-369c-4aca-ba42-6b824a9d657f | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2010 Department of State Training | UH-60 HELICOPTER REPAIRER SUPERVISOR SPANISH | US unit not specified in 2010-2011 report | COLOMBIAN ARMY AVIATION BRIGADE | 2/17/2010 | 2010-02-17 | 5/6/2010 | 2010-05-06 | AVIATION LOGISTICS SCHOOL | 1 | 9645 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
903015d2-9320-496b-93fc-e7517c845471 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2010 Department of State Training | PMEL APPRENTICE (USAF) | US unit not specified in 2010-2011 report | AIR FORCE COMMAND | 1/4/2010 | 2010-01-04 | 5/6/2010 | 2010-05-06 | KEESLER AFB, MS | 1 | 12195 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 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]);