training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
412 rows where "training:start_date" is on date 2008-09-08 sorted by training:status:admin
This data as json, CSV (advanced)
training:end_date (date) 9 ✖
- 2008-09-12 30
- 2008-09-19 24
- 2008-11-05 5
- 2008-09-11 3
- 2009-02-20 2
- 2009-03-05 2
- 2008-09-10 1
- 2008-09-18 1
- 2009-02-06 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
db48f866-f5c8-4c63-80b3-4068668e2497 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | International Defense Management Course (MIDMC) - MET | US unit not specified in 2008-2009 report | Directorate General for Operations and Logistics Supervision | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | 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 |
dc5fc61a-e302-4984-a8b9-3c5cc08ac2bb | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Nigeria | NGA | CTFP - FY 2008 DoD Training | CIV-MIL RESPONSE TO TERRORISM MARITIME SECURITY - MET | US unit not specified in 2008-2009 report | Naval Headquarters, Abuja | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | NIGERIA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
dc9f9dcd-d918-4f7a-99b0-14f6f3c68602 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Mauritius | MUS | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | SMF | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | MAURITIUS (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
dce2826f-bda1-4595-a0dc-7737bb04b987 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Austria | AUT | CTFP - FY 2008 DoD Training | CT- REGIONAL CIV-MIL - MET | US unit not specified in 2008-2009 report | MOD | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | SLOVENIA (IN COUNTRY TRAINING) | 1 | 510 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
dd02da77-21a8-4801-909f-403fa79e2a08 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - FY 2009 DoS Training | MILITARY INTELLIGENCE CAPTAINS CAREER | US unit not specified in 2009-2010 report | Directorate of Intelligence | 9/8/2008 | 2008-09-08 | 2/20/2009 | 2009-02-20 | INTELLIGENCE SCHOOL | 1 | 11396 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
dd709cc2-191b-4e10-b463-24f76bd91af8 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Jamaica | JAM | IMET-1 - FY 2008 DoS Training | INSTRUCTOR TRAINING COURSE | US unit not specified in 2008-2009 report | 1 JR/JDF | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | INFANTRY SCHOOL | 1 | 1499 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
dd8a5a31-12ce-49b4-84e5-15f6d3063fe4 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Jamaica | JAM | IMET-1 - FY 2008 DoS Training | INSTRUCTOR TRAINING COURSE | US unit not specified in 2008-2009 report | 2 JR | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | INFANTRY SCHOOL | 1 | 1499 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
ddceaad2-b2ea-4ddb-b304-bb4aef22b39a | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Jamaica | JAM | IMET-1 - FY 2008 DoS Training | INSTRUCTOR TRAINING COURSE | US unit not specified in 2008-2009 report | 2 JR | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | INFANTRY SCHOOL | 1 | 1499 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
df4db6d0-640c-44d9-9d91-03c64d68d201 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_East_Asia_And_Pacific_fmtrpt.tsv | Timor-Leste, Democratic Republic of | TLS | Regional Centers - FY 2008 DoD Training | Timor-Leste National Security Policy Development Workshop | US unit not specified in 2008-2009 report | National Parliament | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | Asia-Pacific Center for Security Studies, Honolulu, HI | 1 | 5130 | https://2009-2017.state.gov/documents/organization/152767.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
dffba733-a769-4abf-8ce3-4f8cc887d673 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Nigeria | NGA | CTFP - FY 2008 DoD Training | CIV-MIL RESPONSE TO TERRORISM MARITIME SECURITY - MET | US unit not specified in 2008-2009 report | Naval Headquarters, Abuja | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | NIGERIA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e07c421d-b88e-48c2-b986-ae517ce8fd14 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - FY 2008 DoS Training | ENG BOLCIII INT'L STU PREP | US unit not specified in 2008-2009 report | COLOMBIAN ARMY LANCEROS BATTALION | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | CHEMICAL SCHOOL | 1 | 3020 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e08ec674-99dd-4ef5-b4df-5faa10485958 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Jamaica | JAM | IMET-1 - FY 2008 DoS Training | INSTRUCTOR TRAINING COURSE | US unit not specified in 2008-2009 report | Support & Services Battalion | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | INFANTRY SCHOOL | 1 | 1499 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e142f24c-5d1b-4a27-a884-3bc94d5861e5 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Croatia | HRV | CTFP - FY 2008 DoD Training | CT- REGIONAL CIV-MIL - MET | US unit not specified in 2008-2009 report | Military Security Intelligence Agency | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | SLOVENIA (IN COUNTRY TRAINING) | 1 | 300 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e168540f-5e59-414f-a466-85b4eedbc6af | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Nigeria | NGA | CTFP - FY 2008 DoD Training | CIV-MIL RESPONSE TO TERRORISM MARITIME SECURITY - MET | US unit not specified in 2008-2009 report | Naval Headquarters, Abuja | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | NIGERIA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e1b6e2d6-8934-4f2b-8f9c-bbac0adfbd9c | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Israel | ISR | FMF - FY 2008 DoS Training | AH-64A FLIGHT SIMULATOR (CMS) | US unit not specified in 2008-2009 report | IAF-AIR WING 25 | 9/8/2008 | 2008-09-08 | 9/11/2008 | 2008-09-11 | EASTERN AVIATION TRAINING SITE | 1 | 2848 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e1c7a60c-4933-4bd5-bed9-caca23b6894d | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Ghana | GHA | Non-SA, UC, JCET - FY 2008 DoD Training | WATERSIDE PORT SECURITY - MTT | US unit not specified in 2008-2009 report | GHANA NAVY SHIP 'DZATA' | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e1cd227e-eaf9-44dc-a656-4ca9a8f66b9f | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Mauritius | MUS | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | SMF | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | MAURITIUS (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e2f584a5-6a5f-4ffb-bf99-ea9da9fc495e | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Ghana | GHA | Non-SA, UC, JCET - FY 2008 DoD Training | WATERSIDE PORT SECURITY - MTT | US unit not specified in 2008-2009 report | NAVAL TRADE TRAINING SCHOL | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e34303de-3e6c-440b-8aec-d5f78707e92b | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Croatia | HRV | CTFP - FY 2008 DoD Training | INTEL IN COMBAT TERORRISM - MTT | US unit not specified in 2008-2009 report | Military Security Intelligence Agency | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | SECURITY ASSISTANCE TNG MGMT OFC | 1 | 0 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e35b15d4-b20f-45a8-a3f7-a9c8d7a36171 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_East_Asia_And_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - FY 2008 DoS Training | CURRICULUM ADMINISTRATORS COURSE (CAC) | US unit not specified in 2008-2009 report | PHIL MILITARY ACADEMY | 9/8/2008 | 2008-09-08 | 9/18/2008 | 2008-09-18 | CO MARINE CORPS COMBAT SERVICE SUPPORT SCH CAMP LEJEUNE NC | 1 | 2506 | https://2009-2017.state.gov/documents/organization/152767.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e36913c9-e7cf-41fe-9ab4-603dd8d24b74 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Zambia | ZMB | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | DISASTER MANAGEMENT AND MITIGATION UNIT | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | ZAMBIA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e399856a-7832-49b3-9044-0c2659c28719 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Mauritius | MUS | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | SMF | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | MAURITIUS (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e3d50e7d-0e63-4a40-98f4-26bc08a72e76 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | International Defense Management Course (MIDMC) - MET | US unit not specified in 2008-2009 report | National Defense School | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | 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 |
e4124b8d-21fb-4d87-a8bd-79f6b441416b | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_East_Asia_And_Pacific_fmtrpt.tsv | Philippines | PHL | CTFP - FY 2008 DoD Training | CIV-MIL RESPONSE TO TERRORISM | US unit not specified in 2008-2009 report | WESTERN MINDANAO COMMAND | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | CIVIL-MILITARY RELATIONS NPS CENTER FOR MONTEREY CA | 1 | 11178 | https://2009-2017.state.gov/documents/organization/152767.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e45825d9-e69a-415e-8393-3135fb53b460 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Zambia | ZMB | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | MILITARY TRAINING EWSTABLISHMENT OF ZAMBIA | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | ZAMBIA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e49e162f-d3e3-45ae-93bd-c057709a2949 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Albania | ALB | CTFP - FY 2008 DoD Training | CIV-MIL RESPONSE TO TERRORISM | US unit not specified in 2008-2009 report | Ministry of Finance | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | CIVIL-MILITARY RELATIONS NPS CENTER FOR MONTEREY CA | 1 | 10628 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e4e30993-d050-4677-9178-db9aa229dea0 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Africa_fmtrpt.tsv | Djibouti | DJI | FMF - FY 2009 DoS Training | DLI ENGLISH LANGUAGE TECH | US unit not specified in 2009-2010 report | Military School (Holl-Holl) | 9/8/2008 | 2008-09-08 | 3/5/2009 | 2009-03-05 | DJIBOUTI (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/155997.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
e5495ac8-7be1-4389-8050-b629d04f24d8 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_East_Asia_And_Pacific_fmtrpt.tsv | Timor-Leste, Democratic Republic of | TLS | Regional Centers - FY 2008 DoD Training | Timor-Leste National Security Policy Development Workshop | US unit not specified in 2008-2009 report | PNTL Dili Headquarters | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | Asia-Pacific Center for Security Studies, Honolulu, HI | 1 | 5130 | https://2009-2017.state.gov/documents/organization/152767.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e67d42db-667b-47ed-849b-7539cbb01675 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_South_Central_Asia_fmtrpt.tsv | Kyrgyzstan | KGZ | IMET-1 - FY 2009 DoS Training | MILITARY INTELLIGENCE CAPTAINS CAREER | US unit not specified in 2009-2010 report | Unit 77588, Border Service | 9/8/2008 | 2008-09-08 | 2/20/2009 | 2009-02-20 | INTELLIGENCE SCHOOL | 1 | 24862 | https://2009-2017.state.gov/documents/organization/156001.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
e6b00769-cf80-4269-a127-36386cf1e065 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Peru | PER | INL - FY 2009 DoS Training | COUNTER NARCO-TERRORIAM INFORMATION ANALYST | US unit not specified in 2009-2010 report | PERUVIAN NATIONAL POLICE-DIRANDRO | 9/8/2008 | 2008-09-08 | 11/5/2008 | 2008-11-05 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 6109 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
e81693c0-639f-4f2e-8732-6886c8524e19 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Nigeria | NGA | CTFP - FY 2008 DoD Training | CIV-MIL RESPONSE TO TERRORISM MARITIME SECURITY - MET | US unit not specified in 2008-2009 report | Naval Headquarters, Abuja | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | NIGERIA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e8b94f82-368e-4e28-a162-c34dd102f1ed | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Peru | PER | Section 1004 - FY 2009 DoD Training | COUNTER NARCO-TERRORIAM INFORMATION ANALYST | US unit not specified in 2009-2010 report | PERUVIAN NATIONAL POLICE-DIRANDRO | 9/8/2008 | 2008-09-08 | 11/5/2008 | 2008-11-05 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 4792 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
e8c7111c-e692-4026-9265-cb3567be37f7 | 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 | 9/8/2008 | 2008-09-08 | 9/11/2008 | 2008-09-11 | 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 |
e8ca54ec-8887-4e0f-8590-235c8af693c4 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - FY 2009 DoD Training | COUNTER NARCO-TERRORIAM INFORMATION ANALYST | US unit not specified in 2009-2010 report | Army Military Intelligence School ( ESIM) 7286 | 9/8/2008 | 2008-09-08 | 11/5/2008 | 2008-11-05 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
ea266b76-d322-4e6e-99c7-34a1bb1f74a6 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Croatia | HRV | CTFP - FY 2008 DoD Training | INTEL IN COMBAT TERORRISM - MTT | US unit not specified in 2008-2009 report | Military Security Intelligence Agency | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | SECURITY ASSISTANCE TNG MGMT OFC | 1 | 0 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
ec3c9381-cc5c-482c-9bbe-b33719aa4fb2 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | International Defense Management Course (MIDMC) - MET | US unit not specified in 2008-2009 report | National Defense School | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | 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 |
ed3a1ba5-d285-441b-bbe0-1ebc00d6447b | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | International Defense Management Course (MIDMC) - MET | US unit not specified in 2008-2009 report | National Defense School | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | 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 |
edfb4c71-ffbd-4617-8c8f-e8843c44aa7c | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_East_Asia_And_Pacific_fmtrpt.tsv | Indonesia | IDN | CTFP - FY 2008 DoD Training | CIV-MIL RESPONSE TO TERRORISM | US unit not specified in 2008-2009 report | ARMY HEADQUARTERS | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | CIVIL-MILITARY RELATIONS NPS CENTER FOR MONTEREY CA | 1 | 12328 | https://2009-2017.state.gov/documents/organization/152767.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
ee2cdb9e-ab13-4f43-8d26-f5671394dbcf | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | International Defense Management Course (MIDMC) - MET | US unit not specified in 2008-2009 report | Joint Senior War College | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | 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 |
ee4a31ef-d6b9-426d-a193-4a063d3faf63 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Peru | PER | INL - FY 2009 DoS Training | COUNTER NARCO-TERRORIAM INFORMATION ANALYST | US unit not specified in 2009-2010 report | PERUVIAN NATIONAL POLICE-DIRANDRO | 9/8/2008 | 2008-09-08 | 11/5/2008 | 2008-11-05 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 4792 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
ee667d1d-664a-4e9e-a7e6-2d681acd6b95 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Africa_fmtrpt.tsv | Djibouti | DJI | FMF - FY 2009 DoS Training | DLI ENGLISH LANGUAGE TECH | US unit not specified in 2009-2010 report | Headquarters | 9/8/2008 | 2008-09-08 | 3/5/2009 | 2009-03-05 | DJIBOUTI (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/155997.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
eea3fab3-e92b-4708-a2dc-a2a0a745a459 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Zambia | ZMB | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | DISASTER MANAGEMENT AND MITIGATION UNIT | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | ZAMBIA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f0bd2e11-1878-491d-9644-88c12a473b25 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_South_Central_Asia_fmtrpt.tsv | Sri Lanka | LKA | CTFP - FY 2008 DoD Training | CIV-MIL RESPONSE TO TERRORISM | US unit not specified in 2008-2009 report | Admin Regiment | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | CIVIL-MILITARY RELATIONS NPS CENTER FOR MONTEREY CA | 1 | 12145 | https://2009-2017.state.gov/documents/organization/152773.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f1f9feaa-d0b5-4e0f-8aa5-77b255bf44b0 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Nigeria | NGA | CTFP - FY 2008 DoD Training | CIV-MIL RESPONSE TO TERRORISM MARITIME SECURITY - MET | US unit not specified in 2008-2009 report | Naval Headquarters, Abuja | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | NIGERIA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f2357313-4f1d-4a51-9e40-53b5abef28a8 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Israel | ISR | FMF - FY 2008 DoS Training | AH-64A FLIGHT SIMULATOR (CMS) | US unit not specified in 2008-2009 report | IAF-AIR WING 25 | 9/8/2008 | 2008-09-08 | 9/11/2008 | 2008-09-11 | EASTERN AVIATION TRAINING SITE | 1 | 2848 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f253a765-ad87-4214-825d-d6421293a7bf | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Yemen | YEM | IMET-1 - FY 2008 DoS Training | INSTRUCTOR DEVELOPMENT | US unit not specified in 2008-2009 report | YEMEN COAST GUARD | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | COGARD TRAINING CENTER YORKTOWN VA | 1 | 842 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f2aa0207-d1f0-403d-b223-07bc09eff4c5 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - FY 2008 DoS Training | TACTICAL LOGISTICS OFFICER | US unit not specified in 2008-2009 report | ROYAL JORDANIAN NAVY | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | COMMANDING GENERAL, EDUCATION COMMAND QUANTICO VA | 1 | 2309 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f36da4e3-d47e-4e71-8bce-6e30b4b0a02e | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Mauritius | MUS | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | SMF | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | MAURITIUS (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f49e7c2a-0e62-4586-bd4d-3331d7f28708 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Nigeria | NGA | CTFP - FY 2008 DoD Training | CIV-MIL RESPONSE TO TERRORISM MARITIME SECURITY - MET | US unit not specified in 2008-2009 report | Naval Headquarters, Abuja | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | NIGERIA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f4d199a5-ab33-4a1c-8a9d-d633951058fe | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Belize | BLZ | CTFP - FY 2008 DoD Training | CIV-MIL RESPONSE TO TERRORISM | US unit not specified in 2008-2009 report | GOLF COMPANY, SECOND INFANTRY BATTALION | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | CIVIL-MILITARY RELATIONS NPS CENTER FOR MONTEREY CA | 1 | 10078 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f59cb903-faee-40fb-a71e-4b6a842bbe5c | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Jordan | JOR | ALP - FY 2009 DoD Training | ALC ALP SCHOLARSHIP | US unit not specified in 2009-2010 report | KING HUSSEIN AIR COLLEGE 9926 | 9/8/2008 | 2008-09-08 | 2/6/2009 | 2009-02-06 | DLIELC, LACKLAND AFB TX | 1 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
f64e3af5-3d7c-417d-81e4-6083f690536e | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Kosovo | XKX | CTFP - FY 2008 DoD Training | CT- REGIONAL CIV-MIL - MET | US unit not specified in 2008-2009 report | Ministry of Internal Affairs | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | SLOVENIA (IN COUNTRY TRAINING) | 1 | 1055 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f68e9d94-5f72-44ac-8e42-b23f668d7baf | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Israel | ISR | FMF - FY 2008 DoS Training | SURVIVAL SYS | US unit not specified in 2008-2009 report | IAF-AIR WING 30 | 9/8/2008 | 2008-09-08 | 9/10/2008 | 2008-09-10 | SURVIVAL SYSTEMS TRAINING, INC | 1 | 0 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f6cc77bf-d96e-4728-bc52-78c1467057ee | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Zambia | ZMB | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | DISASTER MANAGEMENT AND MITIGATION UNIT | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | ZAMBIA (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f97cf4e4-69ee-403c-a189-4898021d6f98 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Ghana | GHA | IMET-1 - FY 2008 DoS Training | DAMAGE CONTROL, SM CUTTER | US unit not specified in 2008-2009 report | GHANA NAVY SHIP 'ACHIMOTA' | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | COGARD TRAINING CENTER YORKTOWN VA | 1 | 2338 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
faa78cca-96cb-46d4-a48c-73fb2d45a5d9 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Mauritius | MUS | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | SMF | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | MAURITIUS (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
fbb63100-5f71-4703-8597-f8c2c1b1da0a | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Croatia | HRV | CTFP - FY 2008 DoD Training | CT- REGIONAL CIV-MIL - MET | US unit not specified in 2008-2009 report | Military Security Intelligence Agency | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | SLOVENIA (IN COUNTRY TRAINING) | 1 | 300 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
fc148d6e-7002-4b44-a6f1-7ac0f05345ca | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Peru | PER | INL - FY 2009 DoS Training | COUNTER NARCO-TERRORIAM INFORMATION ANALYST | US unit not specified in 2009-2010 report | PERUVIAN NATIONAL POLICE-DIRANDRO | 9/8/2008 | 2008-09-08 | 11/5/2008 | 2008-11-05 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 6109 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
fc1f97cc-25a8-4811-9d0c-d810b3f7b70c | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Jamaica | JAM | IMET-1 - FY 2008 DoS Training | INSTRUCTOR TRAINING COURSE | US unit not specified in 2008-2009 report | Support & Services Battalion | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | INFANTRY SCHOOL | 1 | 1499 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
fc6f4ecd-0152-454d-8c6e-ebf763d3ff28 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Mauritius | MUS | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | SMF | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | MAURITIUS (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
fcb20a29-f1fd-4711-a1c1-a2f268c5aec9 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | International Defense Management Course (MIDMC) - MET | US unit not specified in 2008-2009 report | Directorate General for Operations and Logistics Supervision | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | 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 |
fde6bd78-bbec-4133-a4e4-1c103ada5808 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_East_Asia_And_Pacific_fmtrpt.tsv | Malaysia | MYS | CTFP - FY 2008 DoD Training | CIV-MIL RESPONSE TO TERRORISM | US unit not specified in 2008-2009 report | Special Action Unit, Royal Malaysia Police Headqua | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | CIVIL-MILITARY RELATIONS NPS CENTER FOR MONTEREY CA | 1 | 11678 | https://2009-2017.state.gov/documents/organization/152767.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
fe0924e0-05eb-44f7-82b2-987b6bc46fdc | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | International Defense Management Course (MIDMC) - MET | US unit not specified in 2008-2009 report | National Defense School | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | 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 |
fe29b42b-7234-4094-9e15-40011248ae95 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Moldova | MDA | CTFP - FY 2008 DoD Training | CT- REGIONAL CIV-MIL - MET | US unit not specified in 2008-2009 report | Ministry of Defense | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | SLOVENIA (IN COUNTRY TRAINING) | 1 | 1500 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
feb92d98-bab8-4ac8-8d48-c00e7521167b | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | International Defense Management Course (MIDMC) - MET | US unit not specified in 2008-2009 report | National Defense School | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | 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 |
febbd053-11a7-40a3-9a7f-56dfb627cbcc | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | IMET-1 - FY 2008 DoS Training | International Defense Management Course (MIDMC) - MET | US unit not specified in 2008-2009 report | National Defense School | 9/8/2008 | 2008-09-08 | 9/19/2008 | 2008-09-19 | 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 |
fed87ec2-31f9-4ac4-bf3d-93dc127ec26c | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Mauritius | MUS | IMET-1 - FY 2008 DoS Training | DIILS SEMINARS - MET | US unit not specified in 2008-2009 report | SMF | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | MAURITIUS (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
feda80b4-1d9e-438a-9126-4119ac1500d6 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Europe_fmtrpt.tsv | Macedonia | MKD | CTFP - FY 2008 DoD Training | CT- REGIONAL CIV-MIL - MET | US unit not specified in 2008-2009 report | National Security Agency | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | SLOVENIA (IN COUNTRY TRAINING) | 1 | 1000 | https://2009-2017.state.gov/documents/organization/152768.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
ff280b39-3cde-4a18-950a-5fbd628c9c7b | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_East_Asia_And_Pacific_fmtrpt.tsv | Timor-Leste, Democratic Republic of | TLS | Regional Centers - FY 2008 DoD Training | Timor-Leste National Security Policy Development Workshop | US unit not specified in 2008-2009 report | ANP | 9/8/2008 | 2008-09-08 | 9/12/2008 | 2008-09-12 | Asia-Pacific Center for Security Studies, Honolulu, HI | 1 | 8313 | https://2009-2017.state.gov/documents/organization/152767.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]);