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 2006-07-31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
889a5881-25fb-4f85-9222-a7b975921cc2 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Africa_fmtrpt.tsv | Benin | BEN | IMET - FY 2006 DoS Training | MEDICAL STRATEGIC LDR CRS | - | MOD- Military Health Service | 7/10/2006 | 2006-07-10 | 7/31/2006 | 2006-07-31 | FORT SAM HOUSTON, TX | 1 | 18823 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92084.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
001b0d3a-7d60-436d-84d0-8e8a388448fa | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Near_East_fmtrpt.tsv | Israel | ISR | FMF - FY 2006 DoS Training | MEDICAL STRATEGIC LDR CRS | - | Army | 7/9/2006 | 2006-07-09 | 7/31/2006 | 2006-07-31 | FORT SAM HOUSTON, TX | 1 | 4515 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92087.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
d2d58e5c-f428-420d-ad7b-017fcdaf41be | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | Non-SA, Combatant Command - FY 2006 DoD Training | CPK2006JCET002W | - | SSG | 7/5/2006 | 2006-07-05 | 7/31/2006 | 2006-07-31 | Tarbela | 75 | 0 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92088.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
9027d563-b063-46de-a47d-f4a2fa446c90 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | Service Academies - FY 2006 DoD Training | Military Training Exchange | - | Cadet Field Training | 6/25/2006 | 2006-06-25 | 7/31/2006 | 2006-07-31 | United States Military Academy, West Point | 4 | 0 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
d7e15ad2-3ce0-4743-b437-376b416458ab | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Chile | RCH | Service Academies - FY 2006 DoD Training | Military Training Exchange | - | Cadet Field Training | 6/23/2006 | 2006-06-23 | 7/31/2006 | 2006-07-31 | United States Military Academy, West Point | 4 | 0 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
74c47965-4752-4ce4-83f2-54aab2acb422 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | IMET - FY 2006 DoS Training | INFANTRY MORTAR LEADER | - | Afghan National Army (ANA) | 6/19/2006 | 2006-06-19 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 6051 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92088.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
037c694c-691a-4177-8bda-fe382b397607 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_South_Central_Asia_fmtrpt.tsv | India | IND | IMET - FY 2006 DoS Training | INFANTRY MORTAR LEADER | - | 14 GARHWAL | 6/19/2006 | 2006-06-19 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 7603 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92088.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
0d5e8c16-e93d-4e7b-a4ed-9b2839ac9f00 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | FMF - FY 2006 DoS Training | P-3 FLIGHT ENGR SYS FAM | - | Flight Engineer, P-3C Orion | 6/14/2006 | 2006-06-14 | 7/31/2006 | 2006-07-31 | JACKSONVILLE, FL | 1 | 1426 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92088.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
3ffffb42-b8da-4b5f-8905-0eee375ae0fb | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | FMF - FY 2006 DoS Training | P-3 FLIGHT ENGR SYS FAM | - | Deputy Air Engineering Officer, PNS Mehran | 6/14/2006 | 2006-06-14 | 7/31/2006 | 2006-07-31 | JACKSONVILLE, FL | 1 | 1426 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92088.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
162a6fdd-5131-47ca-9b07-15e0f01a7931 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 1004 - FY 2006 DoD Training | UH-60 AVR QUAL - SPANISH | - | ARMY AVIATION BDE, BOGOTA, D.C. | 6/1/2006 | 2006-06-01 | 7/31/2006 | 2006-07-31 | FORT RUCKER, AL | 1 | 109567 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
2ace5aae-887b-4352-9989-a3b0bd0d38ae | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 1004 - FY 2006 DoD Training | UH-60 AVR QUAL - SPANISH | - | ARMY AVIATION BDE, BOGOTA, D.C. | 6/1/2006 | 2006-06-01 | 7/31/2006 | 2006-07-31 | FORT RUCKER, AL | 1 | 109567 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
c790c364-78eb-4a1a-8207-20de1946e6bb | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 1004 - FY 2006 DoD Training | UH-60 AVR QUAL - SPANISH | - | East Air Group, Marand�a, Vichada | 6/1/2006 | 2006-06-01 | 7/31/2006 | 2006-07-31 | FORT RUCKER, AL | 1 | 109567 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
250dde68-2cbc-4d59-bb68-5a1ca4bb508f | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 1004 - FY 2006 DoD Training | UH-60 AVR QUAL - SPANISH | - | Air Combat Command No.4, Melgar | 6/1/2006 | 2006-06-01 | 7/31/2006 | 2006-07-31 | FORT RUCKER, AL | 1 | 109567 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
92215257-0c8b-4656-8714-4f49b2c7892b | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 1004 - FY 2006 DoD Training | UH-60 AVR QUAL - SPANISH | - | ARMY AVIATION BDE, BOGOTA, D.C. | 6/1/2006 | 2006-06-01 | 7/31/2006 | 2006-07-31 | FORT RUCKER, AL | 1 | 109567 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
95c42d08-17fe-4800-ab43-a4ff7f27efdd | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 1004 - FY 2006 DoD Training | UH-60 AVR QUAL - SPANISH | - | ARMY AVIATION BDE, BOGOTA, D.C. | 6/1/2006 | 2006-06-01 | 7/31/2006 | 2006-07-31 | FORT RUCKER, AL | 1 | 109567 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
fc92e6a4-4083-41bb-bbcd-29585b8bcb9a | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 1004 - FY 2006 DoD Training | UH-60 AVR QUAL - SPANISH | - | ARMY AVIATION BDE, BOGOTA, D.C. | 6/1/2006 | 2006-06-01 | 7/31/2006 | 2006-07-31 | FORT RUCKER, AL | 1 | 109567 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
1551a7ae-9623-4679-86c8-7590a5845a63 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 1004 - FY 2006 DoD Training | UH-60 AVR QUAL - SPANISH | - | ARMY AVIATION BDE, BOGOTA, D.C. | 6/1/2006 | 2006-06-01 | 7/31/2006 | 2006-07-31 | FORT RUCKER, AL | 1 | 109567 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92089.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
f858c036-b44a-425e-9c09-bc032de4d34c | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | FMF - FY 2006 DoS Training | AN/USM-449B(V) I/MAINT | - | Armament Operator, PNS Karsaz | 4/24/2006 | 2006-04-24 | 7/31/2006 | 2006-07-31 | JACKSONVILLE, FL | 1 | 3876 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92088.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
b0f9c39e-de8c-488d-bd95-69b01d5c8adc | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | FMF - FY 2006 DoS Training | AN/USM-449B(V) I/MAINT | - | Supervisor, Radar, PNS Mehran | 4/24/2006 | 2006-04-24 | 7/31/2006 | 2006-07-31 | JACKSONVILLE, FL | 1 | 3876 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92088.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
fe826aa1-f014-4930-96ca-d0cb50c10315 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | FMF - FY 2006 DoS Training | AN/USM-449B(V) I/MAINT | - | Supervisor in Calibration Lab | 4/24/2006 | 2006-04-24 | 7/31/2006 | 2006-07-31 | JACKSONVILLE, FL | 1 | 3876 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92088.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
b151a53b-4bff-4da7-a277-bf37ee0760ff | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | FMF - FY 2006 DoS Training | AN/USM-449B(V) I/MAINT | - | Senior Supervisor, Radar/Radio, PNS Mehran | 4/24/2006 | 2006-04-24 | 7/31/2006 | 2006-07-31 | JACKSONVILLE, FL | 1 | 3876 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92088.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
fa7125ea-0d53-4b05-b1f0-6cfac8c4d85e | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_East_Asia_and_Pacific_fmtrpt.tsv | Fiji | FJI | IMET - FY 2006 DoS Training | INFANTRY OFFICER BASIC | - | REPUBLIC OF FIJI MILITARY FORCES | 4/3/2006 | 2006-04-03 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 1704 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92085.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
ab6a45c7-2fec-4128-aac0-8ff0785a2c75 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_East_Asia_and_Pacific_fmtrpt.tsv | Mongolia | MNG | IMET - FY 2006 DoS Training | INFANTRY OFFICER BASIC | - | NCO College, Defense University | 4/3/2006 | 2006-04-03 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 12431 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92085.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
62685523-b4ee-4972-85e3-b48db1709c96 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET - FY 2006 DoS Training | INFANTRY OFFICER BASIC | - | 76IB, 2ID, Phil Army, Atimonan, Quezon, Phil | 4/3/2006 | 2006-04-03 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 14671 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92085.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
ecf80798-b86e-439a-9665-e9129dbef429 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET - FY 2006 DoS Training | INFANTRY OFFICER BASIC | - | SEBA, HHSG, Phil Army, Ft Bonifacio, Taguig City, Phil | 4/3/2006 | 2006-04-03 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 14671 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92085.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
e7ae3095-82d2-4b59-86e0-47146bac4963 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Europe_fmtrpt.tsv | Armenia | ARM | IMET - FY 2006 DoS Training | INFANTRY OFFICER BASIC | - | Peacekeeping Battalion, Armenian Army | 4/3/2006 | 2006-04-03 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 1704 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92086.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
fa525fc9-2eb1-4013-b931-1046b01ecf74 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Europe_fmtrpt.tsv | Georgia | GEO | IMET - FY 2006 DoS Training | INFANTRY OFFICER BASIC | - | 31st Battalion, 3rd Brigade, Akhaltsikhe | 4/3/2006 | 2006-04-03 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 12431 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92086.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
f774e866-5f7f-43a8-be10-6d44789cbf79 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Europe_fmtrpt.tsv | Ukraine | UKR | IMET - FY 2006 DoS Training | INFANTRY OFFICER BASIC | - | Reconnaissance platoon, 95 Airmobile Brigade, 8 Army Corp, UAF. | 4/3/2006 | 2006-04-03 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 12431 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92086.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
f17b048a-08c6-490a-a6f0-7f0f769ca906 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Europe_fmtrpt.tsv | Ukraine | UKR | IMET - FY 2006 DoS Training | INFANTRY OFFICER BASIC | - | Reconnaissance battalion, 8 Army Corp, UAF. | 4/3/2006 | 2006-04-03 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 12431 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92086.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
ce7a8543-39f4-4702-b89b-11234e32ed4e | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Near_East_fmtrpt.tsv | Iraq | IRQ | Misc DOD/DOS Non-SA - FY 2006 DoD Training | INFANTRY OFFICER BASIC | - | Iraqi Army | 4/3/2006 | 2006-04-03 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 3409 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92087.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
564c1fa4-a0d6-45fe-b891-c9d301efa537 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Near_East_fmtrpt.tsv | Iraq | IRQ | Misc DOD/DOS Non-SA - FY 2006 DoD Training | INFANTRY OFFICER BASIC | - | Iraqi Army | 4/3/2006 | 2006-04-03 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 1705 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92087.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
6f29db43-d47f-4f9b-b6d1-665dc54859f2 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Near_East_fmtrpt.tsv | Jordan | JOR | IMET - FY 2006 DoS Training | INFANTRY OFFICER BASIC | - | JORDAN ARMY 4TH BATTALION-COMPANY COMMANDER | 4/3/2006 | 2006-04-03 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 15479 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92087.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
e273d02f-b777-4b01-9149-02e5ffd84571 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Near_East_fmtrpt.tsv | Jordan | JOR | IMET - FY 2006 DoS Training | INFANTRY OFFICER BASIC | - | JORDAN INFANTRY-COMPANY COMMANDER | 4/3/2006 | 2006-04-03 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 15479 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92087.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
9624c5ce-7cf7-4c07-ac4c-6db6e57fa355 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET - FY 2006 DoS Training | INFANTRY OFFICER BASIC | - | 10th Brigade | 4/3/2006 | 2006-04-03 | 7/31/2006 | 2006-07-31 | FORT BENNING, GA | 1 | 6751 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92087.htm | Not checked against source; verify accuracy before use | 2007-08 | 2019-07-16 |
5e6c025d-736c-4fb2-842e-a732c24999e8 | 1fcf235c-b155-4dde-bf01-3f209af7227f | 2006_2007_Near_East_fmtrpt.tsv | Yemen | YEM | IMET - FY 2006 DoS Training | INFO SYSTEMS OPER - ANALYST | - | YEMEN ARMY | 3/13/2006 | 2006-03-13 | 7/31/2006 | 2006-07-31 | FORT GORDON, GA | 1 | 14655 | https://2009-2017.state.gov/t/pm/rls/rpt/fmtrpt/2007/92087.htm | Not checked against source; verify accuracy before use | 2007-08 | 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]);