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 "training:end_date" is on date 2017-06-15 and training:source = "8602229d-5b77-42e5-b1bc-83fad2eda1b9" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9e4c69b5-a484-43a7-8f32-c59ebc38a05e | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Europe_fmtrpt.tsv | Macedonia | MKD | Regional Centers - Fiscal Year 2017 Department of Defense Training | Migration and Human Smuggling Regional Conference | GCMC | Macedonia Ministry of Defense | 6/14/2017 | 2017-06-14 | 6/15/2017 | 2017-06-15 | Athens, Greece | 2 | 7586 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
dae67a45-fd9e-4ca9-9c4f-dd13a8d8c78d | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Europe_fmtrpt.tsv | Serbia, Republic of | SRB | Regional Centers - Fiscal Year 2017 Department of Defense Training | Migration and Human Smuggling Regional Conference | GCMC | Minister's Office | 6/14/2017 | 2017-06-14 | 6/15/2017 | 2017-06-15 | Athens, Greece | 1 | 3323 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
d80d5e3b-f7a0-4bc3-bde4-457b1cd64130 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Europe_fmtrpt.tsv | Serbia, Republic of | SRB | Regional Centers - Fiscal Year 2017 Department of Defense Training | Migration and Human Smuggling Regional Conference | GCMC | Serbia Regional Center of Border Police | 6/14/2017 | 2017-06-14 | 6/15/2017 | 2017-06-15 | Athens, Greece | 2 | 6598 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
ee86cd04-ce65-4e92-85fb-0a47f4d8f671 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2017 Department of State Training | UH-60A/L (Country Provides Instructor/Operator) | EASTERN AVIATION TRAINING SITE | Air Combat Command No.2, Apiay | 6/12/2017 | 2017-06-12 | 6/15/2017 | 2017-06-15 | Annville, PA, US | 1 | 1200 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
ce15692b-882d-468a-966f-d21759f516a7 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2017 Department of State Training | UH-60A/L (Country Provides Instructor/Operator) | EASTERN AVIATION TRAINING SITE | Air Combat Command No.2, Rionegro | 6/12/2017 | 2017-06-12 | 6/15/2017 | 2017-06-15 | Annville, PA, US | 1 | 1200 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
1d10a232-68ec-4eb0-941c-9b116e7b3034 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2017 Department of State Training | UH-60A/L (Country Provides Instructor/Operator) | EASTERN AVIATION TRAINING SITE | Air Combat Command No.5, Rionegro | 6/12/2017 | 2017-06-12 | 6/15/2017 | 2017-06-15 | Annville, PA, US | 4 | 4800 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
1fc38272-fa07-42c9-9d23-d6ea02147f90 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | PKO - Fiscal Year 2017 Department of State Training | Nepal PKOIC | NEPAL (IN COUNTRY TRAINING) | 4th HELICOPTER WING ,ATANG SENDJAJA AFB | 6/5/2017 | 2017-06-05 | 6/15/2017 | 2017-06-15 | Nepal (In Country Training) | 1 | 1660 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
ab213249-c787-4b41-80d5-c6659502a5d6 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | PKO - Fiscal Year 2017 Department of State Training | Nepal PKOIC | NEPAL (IN COUNTRY TRAINING) | Office of Operations, TNI AD HQ | 6/5/2017 | 2017-06-05 | 6/15/2017 | 2017-06-15 | Nepal (In Country Training) | 1 | 1660 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
46fc537f-a650-462a-aec2-a6d2e28f7bd2 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | PKO - Fiscal Year 2017 Department of State Training | Peacekeeping Operations Instructor Course (PKOIC) | N/A | Armed Forces HQ | 6/5/2017 | 2017-06-05 | 6/15/2017 | 2017-06-15 | Birendra POTC, Panchkhal, Nepal | 1 | 269 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
049fde39-c74a-4667-842b-7a20a4062a90 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | PKO - Fiscal Year 2017 Department of State Training | Peacekeeping Operations Instructor Course (PKOIC) | N/A | N/A | 6/5/2017 | 2017-06-05 | 6/15/2017 | 2017-06-15 | Birendra POTC, Panchkhal, Nepal | 1 | 269 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
c5512a51-f352-45a6-9792-41c4e0ef3c48 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Mongolia | MNG | PKO - Fiscal Year 2017 Department of State Training | Nepal PKOIC | NEPAL (IN COUNTRY TRAINING) | 150 | 6/5/2017 | 2017-06-05 | 6/15/2017 | 2017-06-15 | Nepal (In Country Training) | 1 | 2864 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
11dea07b-46b1-48a0-b9f2-4d8b7f5fbc18 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Mongolia | MNG | PKO - Fiscal Year 2017 Department of State Training | Nepal PKOIC | NEPAL (IN COUNTRY TRAINING) | UNIT 350 | 6/5/2017 | 2017-06-05 | 6/15/2017 | 2017-06-15 | Nepal (In Country Training) | 1 | 2864 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
69a382b9-5957-4564-a3e4-5319e3f3be3b | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Mongolia | MNG | PKO - Fiscal Year 2017 Department of State Training | Peacekeeping Operations Instructor Course (PKOIC) | N/A | 150th BN | 6/5/2017 | 2017-06-05 | 6/15/2017 | 2017-06-15 | Birendra POTC, Panchkhal, Nepal | 2 | 538 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
a1715461-d27f-438f-855a-093a21900db5 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | FMF - Fiscal Year 2017 Department of State Training | C-130 Propeller(HS54H60-91) ORG Maintenance | LITTLE ROCK AFB, AR | 222nd Airlift Squadron 230th Airlift Wing | 6/5/2017 | 2017-06-05 | 6/15/2017 | 2017-06-15 | Little Rock AFB, AR, US | 1 | 6414 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
90d6d858-d55c-4d94-a9b7-1b494a2f0c58 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | FMF - Fiscal Year 2017 Department of State Training | C-130 Propeller(HS54H60-91) ORG Maintenance | LITTLE ROCK AFB, AR | 228th Tactical Crew Training Squadron | 6/5/2017 | 2017-06-05 | 6/15/2017 | 2017-06-15 | Little Rock AFB, AR, US | 1 | 6414 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
64d904e0-4717-4631-8261-78781b37b2b4 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | PKO - Fiscal Year 2017 Department of State Training | Peacekeeping Operations Instructor Course (PKOIC) | N/A | 14th Bde | 6/5/2017 | 2017-06-05 | 6/15/2017 | 2017-06-15 | Birendra POTC, Panchkhal, Nepal | 1 | 269 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
5b59190e-cacc-4a3f-b5d9-cd4ea5a9fa9f | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | PKO - Fiscal Year 2017 Department of State Training | Peacekeeping Operations Instructor Course (PKOIC) | N/A | Gorakh Dal BN | 6/5/2017 | 2017-06-05 | 6/15/2017 | 2017-06-15 | Birendra POTC, Panchkhal, Nepal | 1 | 269 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
0dc54f10-b749-4730-8b38-0555cc13b96c | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | PKO - Fiscal Year 2017 Department of State Training | Peacekeeping Operations Instructor Course (PKOIC) | N/A | N/A | 6/5/2017 | 2017-06-05 | 6/15/2017 | 2017-06-15 | Birendra POTC, Panchkhal, Nepal | 20 | 5379 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
46ece0a6-810c-4578-bbb1-4af500036782 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Niger | NER | CTPF - Fiscal Year 2017 Department of Defense Training | C-208 Initial & Advance Mx Training | SPARTAN AVIATION, TULSA OK | Niger Air Force | 5/29/2017 | 2017-05-29 | 6/15/2017 | 2017-06-15 | Tulsa, OK, US | 1 | 3230 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
0a562eaf-a47b-4075-ace4-438696043021 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Niger | NER | CTPF - Fiscal Year 2017 Department of Defense Training | C-208 Initial & Advance MX Training | SPARTAN AVIATION, TULSA OK | Nigerien Air Force | 5/29/2017 | 2017-05-29 | 6/15/2017 | 2017-06-15 | Tulsa, OK, US | 2 | 23160 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
389a25de-7ea2-4a25-8a12-7849199c982a | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2017 Department of State Training | CYBER Network (Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | COLOMBIAN POLICE, ANTINARCOTICS DIRECTORATE | 5/24/2017 | 2017-05-24 | 6/15/2017 | 2017-06-15 | Lackland AFB, TX, US | 5 | 3250 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
163aa3a3-6d97-4ca2-b093-24031a4ff287 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2017 Department of State Training | Petroleum Supply Specialist | QUARTERMASTER SCHOOL | ROYAL SUPPLY COMMAND | 4/19/2017 | 2017-04-19 | 6/15/2017 | 2017-06-15 | Ft. Lee, VA, US | 1 | 12025 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
7083538c-a262-4c9a-ad58-096adac4b299 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2017 Department of State Training | Psychological Operations Training (A&SS) | JFK SPECIAL WARFARE CENTER | SPECIAL OPERATION AVIATION BRIGADE | 4/17/2017 | 2017-04-17 | 6/15/2017 | 2017-06-15 | Ft. Bragg, NC, US | 1 | 16297 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
21d45e8e-730e-49e0-a2bc-8d0ad1799144 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | IMET-1 - Fiscal Year 2017 Department of State Training | Psychological Operations Training (A&SS) | JFK SPECIAL WARFARE CENTER | NO 559 FLIGHT PAF BASE | 4/17/2017 | 2017-04-17 | 6/15/2017 | 2017-06-15 | Ft. Bragg, NC, US | 1 | 15993 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
73e5637c-b509-4501-8154-4a749c04a8d2 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2017 Department of State Training | Practical Nurse - Phase 1 | Academy of Health Sciences | MEDICAL SERVICE | 3/27/2017 | 2017-03-27 | 6/15/2017 | 2017-06-15 | Ft. Sam Houston, TX, US | 1 | 25680 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
3edd5425-bfe4-4e69-ad18-240251848352 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Ghana | GHA | IMET-1 - Fiscal Year 2017 Department of State Training | Aircraft Maintenance Officer Course (AMOC) | SHEPPARD AFB, TX | Airforce Headquarters | 3/13/2017 | 2017-03-13 | 6/15/2017 | 2017-06-15 | Sheppard AFB, TX, US | 1 | 17548 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
964d5f40-6c9f-49af-8468-9ae206d2b992 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2017 Department of State Training | Aircraft Electrician Spanish | AVIATION LOGISTICS SCHOOL | COLOMBIAN ARMY AVIATION SCHOOL | 2/21/2017 | 2017-02-21 | 6/15/2017 | 2017-06-15 | Ft. Eustis, VA, US | 3 | 83217 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
15b9fb6a-b622-4571-ae1b-834db8b196e5 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Jordan | JOR | CTPF - Fiscal Year 2017 Department of Defense Training | Aircraft Powerplant Repairer | AVIATION LOGISTICS SCHOOL | MAINTENANCE DIRECTORATE | 2/7/2017 | 2017-02-07 | 6/15/2017 | 2017-06-15 | Ft. Eustis, VA, US | 1 | 16961 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
be5a882a-aaf9-4966-8aa3-6c3ecac3f05d | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Liberia | LBR | IMET-1 - Fiscal Year 2017 Department of State Training | Maneuver Captains Career | USATC-Benning | Armed Forces of Liberia | 1/4/2017 | 2017-01-04 | 6/15/2017 | 2017-06-15 | Ft. Benning, GA, US | 1 | 23750 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
c8330bf8-1463-40d3-becf-c48cc1e44bce | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Sierra Leone | SLE | IMET-1 - Fiscal Year 2017 Department of State Training | Maneuver Captains Career | USATC-Benning | 5 Infantry Brigade | 1/4/2017 | 2017-01-04 | 6/15/2017 | 2017-06-15 | Ft. Benning, GA, US | 1 | 23750 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
c08e6aa1-bff0-496f-883c-c525b3896299 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | FMF - Fiscal Year 2017 Department of State Training | Maneuver Captains Career | USATC-Benning | Indonesian Army Personnel Office | 1/4/2017 | 2017-01-04 | 6/15/2017 | 2017-06-15 | Ft. Benning, GA, US | 1 | 23710 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
f7a65d06-d43f-487a-9d12-d71abbd30767 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | FMF - Fiscal Year 2017 Department of State Training | Maneuver Captains Career | USATC-Benning | Indonesian Army/7th Military Area Command | 1/4/2017 | 2017-01-04 | 6/15/2017 | 2017-06-15 | Ft. Benning, GA, US | 1 | 23710 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
ec194bd4-1b84-40fa-9311-77c01bc9cd40 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - Fiscal Year 2017 Department of State Training | Maneuver Captains Career | USATC-Benning | 3RD LIGHT REACTION COMPANY, LIGHT REACTION REGIMENT, SPECIAL OPNS COMMAND, PHIL ARMY | 1/4/2017 | 2017-01-04 | 6/15/2017 | 2017-06-15 | Ft. Benning, GA, US | 1 | 23750 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
e249f6c3-874e-4c08-9308-bca10916d5f5 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - Fiscal Year 2017 Department of State Training | Maneuver Captains Career | USATC-Benning | 2d Intervention Regiment | 1/4/2017 | 2017-01-04 | 6/15/2017 | 2017-06-15 | Ft. Benning, GA, US | 1 | 23550 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
7b84f9d4-55e2-4faa-b60e-b2cf6b43e4bb | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Tunisia | TUN | IMET-1 - Fiscal Year 2017 Department of State Training | Maneuver Captains Career | USATC-Benning | Army NCO school, Bizerte | 1/4/2017 | 2017-01-04 | 6/15/2017 | 2017-06-15 | Ft. Benning, GA, US | 1 | 23550 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 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]);