training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
36 rows where "qa:training_date_first_seen" is on date -4707-05-27 and "training:start_date" is on date 2010-03-18 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
f67fc9cb-43dc-4719-a8f8-62119cf56904 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Africa_fmtrpt.tsv | Kenya | KEN | IMET-1 - Fiscal Year 2010 Department of State Training | FIELD ARTILLERY CAPTAINS CAREER | US unit not specified in 2010-2011 report | GIL GIL ARTILLERY BATALLION | 3/18/2010 | 2010-03-18 | 9/3/2010 | 2010-09-03 | FIELD ARTILLERY SCHOOL | 1 | 21721 | https://2009-2017.state.gov/documents/organization/171509.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
9a7b222a-f50e-4a22-8a13-09b00deede7d | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Africa_fmtrpt.tsv | Nigeria | NGA | IMET-1 - Fiscal Year 2010 Department of State Training | FIELD ARTILLERY CAPTAINS CAREER | US unit not specified in 2010-2011 report | NIGERIA DEFENSE ACADEMY, KADUNA | 3/18/2010 | 2010-03-18 | 9/3/2010 | 2010-09-03 | FIELD ARTILLERY SCHOOL | 1 | 21721 | https://2009-2017.state.gov/documents/organization/171509.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
9ce3f291-0d82-47db-bd2f-f530e9323ba5 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Africa_fmtrpt.tsv | Senegal | SEN | IMET-1 - Fiscal Year 2010 Department of State Training | FIELD ARTILLERY CAPTAINS CAREER | US unit not specified in 2010-2011 report | ARTILLERY BN | 3/18/2010 | 2010-03-18 | 9/3/2010 | 2010-09-03 | FIELD ARTILLERY SCHOOL | 1 | 21721 | https://2009-2017.state.gov/documents/organization/171509.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
0d1e0ada-4de7-4a4c-830f-be19e7a6dc01 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | IMET-1 - Fiscal Year 2010 Department of State Training | FIELD ARTILLERY CAPTAINS CAREER | US unit not specified in 2010-2011 report | KODIM 142 REM 142/DAM VII WRB | 3/18/2010 | 2010-03-18 | 9/3/2010 | 2010-09-03 | FIELD ARTILLERY SCHOOL | 1 | 21721 | https://2009-2017.state.gov/documents/organization/171510.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
e1dcfe75-86d5-46d4-b6be-a349ce8223d0 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Europe_fmtrpt.tsv | Georgia | GEO | FMF - Fiscal Year 2010 Department of State Training | AVIATION MAINTENANCE OFFICER | US unit not specified in 2010-2011 report | UH-1H HELICOPTER SQUADRON, ALEXEEVKA | 3/18/2010 | 2010-03-18 | 3/24/2010 | 2010-03-24 | AVIATION SCHOOL | 1 | 2588 | https://2009-2017.state.gov/documents/organization/171511.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
7e3f1762-8c7e-44f1-bfc3-8eb4b47ba1bb | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Egypt | EGY | IMET-1 - Fiscal Year 2010 Department of State Training | FIELD ARTILLERY CAPTAINS CAREER | US unit not specified in 2010-2011 report | ARTILLARY DEPT | 3/18/2010 | 2010-03-18 | 9/3/2010 | 2010-09-03 | FIELD ARTILLERY SCHOOL | 1 | 21721 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
9a7f30d9-2e65-4caf-a51a-5480147197be | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
98e16eff-d7ad-44b5-96a0-7ddb0801d0fd | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
04eea30b-ec76-4f0c-88b1-eab660a04dcc | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
df4ea9db-19c1-4b54-96f4-c5293aa1f977 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
71dc7f92-fcdb-4707-8f3d-530fde8f2ce3 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
5af079c8-ce9c-4efb-bb8b-612f84375250 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
805ab823-51d3-42ae-b6f0-43aced97d4dd | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
7cc37cd0-67f1-4928-9a1c-67c00629920f | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
94ff45c2-dbf6-469f-b276-400572358589 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
6c8f95a3-ef83-41e1-be42-68e54b760013 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
0e19c1fa-0f8e-4001-b459-9360d4cd83b6 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
04822f4c-dffc-42c8-9cb8-6aa2a737db81 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
d3e43493-0a6e-4a4e-92f3-111c8c359f94 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 22474 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
84f690d3-62ff-44df-bbdc-1f751dfa2488 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
7c83b290-6d27-4d4d-81fc-3e279e06ebba | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
bae8dcc8-013a-4f3a-ab31-33a5df4d1e8b | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
a5a2b140-ffcf-4d3a-a6c8-34d4f90058f4 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
7f5b5392-5b73-4e8b-99ac-a7de7715dd3d | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
6431e178-3fa0-464d-b62b-26ec7d8d7cfb | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
992261f3-5486-4795-9ecb-fa311386fe6b | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
2fec3fab-a582-4692-b14e-626130e7e7c3 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
5d18cf2e-08bb-42e9-aaad-96d157b244b9 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
73657a35-0def-448a-88df-344a05feb637 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
fec03004-0568-4113-85fa-f500ad0f9776 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
7eb3fef0-c8b9-4f14-84a2-1e7852efe52d | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
bf1716d5-8ac9-44aa-b680-0e1533e491a4 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | AIR FORCE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 20220 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
af7458e9-7b79-4cc9-b406-da4be46b5f5c | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
772191df-bd80-4ecd-bfa8-147d883328bb | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-2 - Fiscal Year 2010 Department of State Training | DISAM FOREIGN PURCH MET | US unit not specified in 2010-2011 report | MINISTRY OF DEFENSE | 3/18/2010 | 2010-03-18 | 4/3/2010 | 2010-04-03 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
9255faa2-d03a-478c-8341-b0d981193b50 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - Fiscal Year 2010 Department of State Training | FIELD ARTILLERY CAPTAINS CAREER | US unit not specified in 2010-2011 report | 1ST BRIGADE | 3/18/2010 | 2010-03-18 | 9/3/2010 | 2010-09-03 | FIELD ARTILLERY SCHOOL | 1 | 21721 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
ef326130-0784-495e-a1df-5a0ecb0579ab | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Chile | RCH | IMET-1 - Fiscal Year 2010 Department of State Training | FIELD ARTILLERY CAPTAINS CAREER | US unit not specified in 2010-2011 report | MILITARY ACADEMY | 3/18/2010 | 2010-03-18 | 9/3/2010 | 2010-09-03 | FIELD ARTILLERY SCHOOL | 1 | 9444 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "training-data" ( [training:id:admin] TEXT PRIMARY KEY, [training:source] TEXT, [qa:training_group] TEXT, [training:country] TEXT, [training:country_iso_3166_1] TEXT, [training:program] TEXT, [training:course_title] TEXT, [training:delivery_unit] TEXT, [training:recipient_unit] TEXT, [qa:training_start_date] TEXT, [training:start_date] TEXT, [qa:training_end_date] TEXT, [training:end_date] TEXT, [training:location] TEXT, [training:quantity] INTEGER, [training:total_cost] INTEGER, [qa:training_source_url] TEXT, [training:status:admin] TEXT, [qa:training_date_first_seen] TEXT, [qa:training_date_scraped] TEXT ); CREATE INDEX [idx_training-data_training:id:admin_training:source_qa:training_group_training:country_training:country_iso_3166_1_training:program_training:course_title_training:delivery_unit_training:recipient_unit_qa:training_start_date_training:start_date_qa:training_end_date_training:end_date_training:location_training:quantity_training:total_cost_qa:training_source_url_training:status:admin_qa:training_date_first_seen_qa:training_date_scraped] ON [training-data] ([training:id:admin], [training:source], [qa:training_group], [training:country], [training:country_iso_3166_1], [training:program], [training:course_title], [training:delivery_unit], [training:recipient_unit], [qa:training_start_date], [training:start_date], [qa:training_end_date], [training:end_date], [training:location], [training:quantity], [training:total_cost], [qa:training_source_url], [training:status:admin], [qa:training_date_first_seen], [qa:training_date_scraped]);