training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
235 rows where "training:start_date" is on date 2008-06-23 sorted by training:status:admin
This data as json, CSV (advanced)
qa:training_date_first_seen (date) 2 ✖
- -4707-05-25 34
- -4707-05-26 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
dad1b8da-6e6e-475e-abd4-48c3c812ad19 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Senegal | SEN | FMF - FY 2008 DoS Training | INTERNATIONAL FELLOWS ORIENTATION | US unit not specified in 2008-2009 report | Headquarter Staff BN | 6/23/2008 | 2008-06-23 | 8/1/2008 | 2008-08-01 | ARMY WAR COLLEGE | 1 | 18519 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
db8b0185-a6f4-47f9-a088-1fbdbe2bf9a9 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Ukraine | UKR | CTFP - FY 2008 DoD Training | CT-RESP TO TERRORISM - MET | US unit not specified in 2008-2009 report | Ministry of Transportation and Communications | 6/23/2008 | 2008-06-23 | 7/4/2008 | 2008-07-04 | UKRAINE (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
dba31a73-a7c9-4955-b1df-98f8f6ce4fd9 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | Directorate General for Research and Development | 6/23/2008 | 2008-06-23 | 6/27/2008 | 2008-06-27 | ARGENTINA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
dbda1ecd-0b1e-43b2-b50e-03c6db1c9c89 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - FY 2008 DoS Training | SENIOR INTERNATIONAL DEFENSE MANAGEMENT | US unit not specified in 2008-2009 report | ACCOUNTING DEPARTMENT | 6/23/2008 | 2008-06-23 | 7/18/2008 | 2008-07-18 | MONTEREY, CA | 1 | 12299 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
dc2f5ddd-efe2-4710-b173-b05a90f2eb71 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - FY 2008 DoS Training | COMBINED LOGISTICS CAPTAINS CAREER (ALMC) | US unit not specified in 2008-2009 report | QM DEPARTMENT, CENTRAL SECURITY, SINAI | 6/23/2008 | 2008-06-23 | 6/27/2008 | 2008-06-27 | ARMY LOGISTICS MANAGEMENT COLLEGE | 1 | 832 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
de58f2a5-a9b6-4dbd-bef6-7cfcf828c169 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Ukraine | UKR | CTFP - FY 2008 DoD Training | CT-RESP TO TERRORISM - MET | US unit not specified in 2008-2009 report | Execution and punishment Service | 6/23/2008 | 2008-06-23 | 7/4/2008 | 2008-07-04 | UKRAINE (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
dec857ba-a7b2-4796-8c3c-e3078f7c92ab | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | South Africa | ZAF | IMET-1 - FY 2008 DoS Training | SENIOR INTERNATIONAL DEFENSE MANAGEMENT | US unit not specified in 2008-2009 report | Navy Headquarters | 6/23/2008 | 2008-06-23 | 7/18/2008 | 2008-07-18 | MONTEREY, CA | 1 | 12999 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
df2a7792-6b91-4957-80b3-4eeda649aed3 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | SH-3 SIMULATOR TRAINING | US unit not specified in 2008-2009 report | SH-3 Squadron Espora | 6/23/2008 | 2008-06-23 | 6/27/2008 | 2008-06-27 | NAVY OPERATIONAL SUPPORT CENTER (NOSC) | 1 | 4952 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e1aa0e29-2b1e-490c-94b5-c9cb93b3256f | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Azerbaijan | AZE | CTFP - FY 2008 DoD Training | CT - LEGAL ASPECTS - MTT | US unit not specified in 2008-2009 report | Head Prosecutor's Office, Anti-Corruption Department | 6/23/2008 | 2008-06-23 | 6/27/2008 | 2008-06-27 | AZERBAIJAN (IN COUNTRY TRAINING) | 1 | 52662 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e32b295c-1426-4640-ba79-8c90c6da2ebb | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | Office of the Chief of Intelligence | 6/23/2008 | 2008-06-23 | 6/27/2008 | 2008-06-27 | ARGENTINA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e3edeb1e-2689-4268-b42d-08689cfb827b | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | Land Operations Command | 6/23/2008 | 2008-06-23 | 6/27/2008 | 2008-06-27 | ARGENTINA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e42dfe7a-8ffc-49a2-bb58-b9bad5db24f3 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_South_Central_Asia_fmtrpt.tsv | Kazakhstan | KAZ | IMET-1 - FY 2008 DoS Training | COMBINED LOGISTICS CAPTAINS CAREER (ALMC) | US unit not specified in 2008-2009 report | 89427, MINISTRY OF DEFENSE | 6/23/2008 | 2008-06-23 | 6/27/2008 | 2008-06-27 | ARMY LOGISTICS MANAGEMENT COLLEGE | 1 | 872 | https://2009-2017.state.gov/documents/organization/152773.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e6365d50-8304-409a-b615-76565e03f2e8 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Uganda | UGA | GPOI - FY 2008 DoS Training | ACOTA Uganda PSO NCO Leadership Training | US unit not specified in 2008-2009 report | UG Battle Group 3 | 6/23/2008 | 2008-06-23 | 7/4/2008 | 2008-07-04 | Singo | 94 | 112614 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e64d37fb-4183-45bc-bfec-7d1026233c3a | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Georgia | GEO | CTFP - FY 2008 DoD Training | INTERNATIONAL FELLOWS ORIENTATION | US unit not specified in 2008-2009 report | J3, Operation Department, Joint Staff | 6/23/2008 | 2008-06-23 | 8/1/2008 | 2008-08-01 | ARMY WAR COLLEGE | 1 | 13650 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e7f0460e-5546-404d-a873-dbfdb3ab0b54 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_East_Asia_And_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - FY 2008 DoS Training | SPECIALIZED ENGLISH LANGUAGE TRAINING | US unit not specified in 2008-2009 report | NAVAL OPERATIONS CENTER | 6/23/2008 | 2008-06-23 | 8/15/2008 | 2008-08-15 | DLIELC, LACKLAND AFB TX | 1 | 9250 | https://2009-2017.state.gov/documents/organization/152767.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e877679e-0727-41e0-8103-068bec8a4276 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | Directorate General for Institutional Affairs | 6/23/2008 | 2008-06-23 | 6/27/2008 | 2008-06-27 | ARGENTINA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
ed082792-7b46-45b4-8d0f-15fbb623a350 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Ukraine | UKR | IMET-1 - FY 2008 DoS Training | MP BOLC3 INT'L STU PREP | US unit not specified in 2008-2009 report | Group of combat support, Main law enforcement Depa | 6/23/2008 | 2008-06-23 | 7/3/2008 | 2008-07-03 | CHEMICAL SCHOOL | 1 | 2106 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
ed0b92b7-e995-4c49-af0f-e39538c4f3cc | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | SH-3 SIMULATOR TRAINING | US unit not specified in 2008-2009 report | SH-3 Squadron Espora | 6/23/2008 | 2008-06-23 | 6/27/2008 | 2008-06-27 | NAVY OPERATIONAL SUPPORT CENTER (NOSC) | 1 | 4952 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
ed453cf9-a23b-4c1b-b857-a54ee7ff1e90 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Uganda | UGA | IMET-1 - FY 2008 DoS Training | SENIOR INTERNATIONAL DEFENSE MANAGEMENT | US unit not specified in 2008-2009 report | UGANDA AIR FORCE | 6/23/2008 | 2008-06-23 | 7/18/2008 | 2008-07-18 | MONTEREY, CA | 1 | 12799 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
ed59784f-4dee-4da3-b852-32c7e3812841 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_East_Asia_And_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - FY 2008 DoS Training | INTERNATIONAL FELLOWS ORIENTATION | US unit not specified in 2008-2009 report | TRAINING AND DOCTRINES COMMAND | 6/23/2008 | 2008-06-23 | 8/1/2008 | 2008-08-01 | ARMY WAR COLLEGE | 1 | 18054 | https://2009-2017.state.gov/documents/organization/152767.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
ed77fdf5-f67c-4ea2-ae08-e8e21aceeddd | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | Riverine Squad | 6/23/2008 | 2008-06-23 | 6/27/2008 | 2008-06-27 | ARGENTINA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f1adedc9-e2bf-417e-a582-ef3928d68e2a | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_East_Asia_And_Pacific_fmtrpt.tsv | Malaysia | MYS | IMET-1 - FY 2008 DoS Training | INTERNATIONAL FELLOWS ORIENTATION | US unit not specified in 2008-2009 report | 10th Brigade Para, Terendak Camp | 6/23/2008 | 2008-06-23 | 8/1/2008 | 2008-08-01 | ARMY WAR COLLEGE | 1 | 13294 | https://2009-2017.state.gov/documents/organization/152767.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f26079af-a6f2-4dc4-b6c6-cea53066d99d | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_South_Central_Asia_fmtrpt.tsv | India | IND | IMET-1 - FY 2008 DoS Training | SENIOR INTERNATIONAL DEFENSE MANAGEMENT | US unit not specified in 2008-2009 report | ARTY DTE | 6/23/2008 | 2008-06-23 | 7/18/2008 | 2008-07-18 | MONTEREY, CA | 1 | 12249 | https://2009-2017.state.gov/documents/organization/152773.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f2fcd6b2-eb6b-4e5d-a130-7c33d9849611 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Israel | ISR | FMF - FY 2008 DoS Training | AH-1S Cobra | US unit not specified in 2008-2009 report | IAF-AIR WING 30 | 6/23/2008 | 2008-06-23 | 6/26/2008 | 2008-06-26 | AVIATION SCHOOL | 1 | 0 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f450f79c-5c8e-4016-aecc-fe61a4f10811 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_East_Asia_And_Pacific_fmtrpt.tsv | Malaysia | MYS | IMET-1 - FY 2008 DoS Training | SENIOR INTERNATIONAL DEFENSE MANAGEMENT | US unit not specified in 2008-2009 report | RMN HQ, Ministry of Defense, Jalan Padang Tembak, | 6/23/2008 | 2008-06-23 | 7/18/2008 | 2008-07-18 | MONTEREY, CA | 1 | 8999 | https://2009-2017.state.gov/documents/organization/152767.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f54dc422-38dd-49e2-b596-6d371d7ff387 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Iraq | IRQ | CTFP - FY 2008 DoD Training | INTERNATIONAL FELLOWS ORIENTATION | US unit not specified in 2008-2009 report | IRAQI ARMY | 6/23/2008 | 2008-06-23 | 8/1/2008 | 2008-08-01 | ARMY WAR COLLEGE | 1 | 13650 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f5bf27a0-7fe1-4328-aa9f-782585107e9e | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | IMET-1 - FY 2009 DoS Training | HEALTH CARE SPECIALISTS | US unit not specified in 2009-2010 report | 18th Infantry Battalion 3900 | 6/23/2008 | 2008-06-23 | 10/16/2008 | 2008-10-16 | ARMY MEDICAL DEPARTMENT CENTER & SCHOOL | 1 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
f5f25b1e-475d-494e-8fff-483034505abf | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Azerbaijan | AZE | CTFP - FY 2008 DoD Training | CT - LEGAL ASPECTS - MTT | US unit not specified in 2008-2009 report | Minisry of National Security | 6/23/2008 | 2008-06-23 | 6/27/2008 | 2008-06-27 | AZERBAIJAN (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f6c68169-6625-486e-b85c-78161a80caf4 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | EMERGENCY MEDICAL TECH | US unit not specified in 2008-2009 report | SEMAR | 6/23/2008 | 2008-06-23 | 7/11/2008 | 2008-07-11 | US COAST GUARD TRAINING CENTER PETALUMA CA | 1 | 2054 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f7d4b954-7580-48f9-ada4-6a770b1cf683 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | IMET-1 - FY 2008 DoS Training | SENIOR INTERNATIONAL DEFENSE MANAGEMENT | US unit not specified in 2008-2009 report | NO. 5 Brigade | 6/23/2008 | 2008-06-23 | 7/18/2008 | 2008-07-18 | MONTEREY, CA | 1 | 12799 | https://2009-2017.state.gov/documents/organization/152773.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f89894f4-7fef-4779-b864-8ec17de625fb | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_South_Central_Asia_fmtrpt.tsv | Bangladesh | BGD | IMET-1 - FY 2008 DoS Training | JET ENGINE MISHAP INV | US unit not specified in 2008-2009 report | Squadron Pilot | 6/23/2008 | 2008-06-23 | 7/3/2008 | 2008-07-03 | SHEPPARD AFB, TX | 1 | 5374 | https://2009-2017.state.gov/documents/organization/152773.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f8be6113-2d64-4bab-b0ed-a7c65069d896 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Azerbaijan | AZE | CTFP - FY 2008 DoD Training | CT - LEGAL ASPECTS - MTT | US unit not specified in 2008-2009 report | Head Prosecutor's Office | 6/23/2008 | 2008-06-23 | 6/27/2008 | 2008-06-27 | AZERBAIJAN (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
fad8e7f2-afed-4cdf-94b9-b691a9c8b571 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | South Africa | ZAF | IMET-1 - FY 2008 DoS Training | INTERNATIONAL FELLOWS ORIENTATION | US unit not specified in 2008-2009 report | Army Support , Western Cape | 6/23/2008 | 2008-06-23 | 8/1/2008 | 2008-08-01 | ARMY WAR COLLEGE | 1 | 22835 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
fc97e1c9-a5ee-4b26-b759-bd4de732816f | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Ghana | GHA | IMET-1 - FY 2008 DoS Training | PRIN INVEN CTRL (WPN SYS) | US unit not specified in 2008-2009 report | WESTERN NAVAL COMMAND | 6/23/2008 | 2008-06-23 | 7/3/2008 | 2008-07-03 | NAVY SUPPLY CORPS SCHOOL ATHENS GA | 1 | 1791 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
ff1e0d92-9864-4460-adcf-bb9301e6ded1 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Ukraine | UKR | CTFP - FY 2008 DoD Training | CT-RESP TO TERRORISM - MET | US unit not specified in 2008-2009 report | Secret Service of Ukraine | 6/23/2008 | 2008-06-23 | 7/4/2008 | 2008-07-04 | UKRAINE (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152768.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]);