training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
237,603 rows sorted by training:course_title
This data as json, CSV (advanced)
Suggested facets: training:end_date (date), qa:training_date_scraped (date)
These facets timed out: training:start_date
qa:training_date_first_seen (date) 14 ✖
- -4707-05-27 19,671
- -4707-05-26 18,945
- -4707-05-25 16,877
- 2021-08-04 14,229
- -4707-05-28 12,845
- 2018-08-15 12,301
- 2017-10-27 11,964
- 2008-01-31 11,905
- 2019-12-06 11,904
- -4707-05-29 11,148
- -4707-05-30 11,051
- -4707-05-31 10,487
- -4707-06-01 10,322
- 2022-03-16 9,771
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6ab8d091-49bd-425f-82f3-acaf00e94beb | 04ac6784-aa03-4c20-978e-960d2d59ca02 | 2003_2004_Western_Hemisphere_fmtrpt.tsv | Bolivia | BOL | Western Hemisphere Region, Bolivia, Drug Interdiction and Counter-Drug Activities, Section 1004, FY03 | Force | https://2009-2017.state.gov/documents/organization/34338.pdf | Not checked against source; verify accuracy before use | 2004-06 | 2019-07-16 | |||||||||
7b090d11-bb7b-4587-a453-7529a6005b92 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Angola | AGO | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 24 | 364134 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
cfde1b80-a60f-44ff-97dd-72cb4447f03e | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Angola | AGO | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 9 | 98382 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
ba37cbca-e5af-4b22-b318-c2a2a1210e1c | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Benin | BEN | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 3 | 7518 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
50b0f4d5-c00c-4760-b1ab-c1bebc2f4fb9 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Benin | BEN | GPOI - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 76 | 675687 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
72a4455c-487d-467f-a377-c635eecdf58d | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Benin | BEN | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 4 | 91088 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
741695cd-cde3-4583-9ec4-6406e54b8225 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Benin | BEN | IMET-X - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 5 | 135064 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
5daab5d8-f364-4874-a088-0b5f17d566bf | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Benin | BEN | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 66 | 189231 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
afdbc78e-8da5-4e03-8be4-c4025a00ee2c | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Botswana | BWA | ALP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 1 | 23848 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
73d9dcda-004f-41d4-9c39-3638cd9a4861 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Botswana | BWA | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 5 | 34371 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
6781f734-e601-4482-9279-2bafde9edaba | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Botswana | BWA | FMF - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 24 | 302910 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
f984507b-5f65-4557-ad1a-ced165174e2e | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Botswana | BWA | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 56 | 755179 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
b62225fd-659e-4949-849c-487453dd9c23 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Botswana | BWA | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 105 | 119937 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
54d4670d-f6a3-444d-8bb1-3f00e99135cb | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Burkina Faso | BFA | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 5 | 17393 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
7e489578-20d4-4fee-8176-f5211cfaaf28 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Burkina Faso | BFA | GPOI - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 890 | 1173390 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
14bd2ff4-3573-4e9f-861c-823d77eba851 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Burkina Faso | BFA | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 3 | 52048 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
e4ddc847-1981-4786-bcfd-d6ac5c7301ab | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Burkina Faso | BFA | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 201 | 142890 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
7140d0b3-b9c3-4826-a4de-072229345439 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Burundi | BDI | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 2 | 9758 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
bd4b5a3b-30d2-42ce-996e-17f42e0a21d4 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Burundi | BDI | GPOI - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 52 | 451547 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
ee0945f3-2e68-41eb-bd9b-37209971c8df | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Burundi | BDI | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 6 | 136661 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
70d45106-7696-46c9-a43c-593a24061197 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Burundi | BDI | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 69 | 53454 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
9b50ea08-1802-4157-bbac-55361fa302dc | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Cameroon | CMR | ALP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 2 | 10676 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
1ae1c9ca-4468-43c6-8b3b-4e6185ed1e15 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Cameroon | CMR | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 19 | 80443 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
59d3ef7d-61ba-48f9-8598-3c6476c193a8 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Cameroon | CMR | GPOI - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 85 | 439523 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
f11feee6-508d-4858-a948-c196b8483b7c | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Cameroon | CMR | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 17 | 244121 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
7610757f-6ba1-4284-b3b7-f9f63a755e18 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Cameroon | CMR | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 12 | 144075 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
02aaedb2-da82-452d-8dda-8943a1540f7f | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Cameroon | CMR | Service Academies - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 1 | 67914 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
e5a328bc-6fa4-4ee3-b58b-da1a9be9bce0 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Cape Verde, Republic Of | CPV | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 2 | 3972 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
208bc8f0-92ac-475e-859a-c7fc07420fb0 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Cape Verde, Republic Of | CPV | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 14 | 180461 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
c730b70c-e787-4385-b730-ad853de832df | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Cape Verde, Republic Of | CPV | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 4 | 49632 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
dc65b583-5314-4050-83ea-de9ccd25d6f6 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Central African Republic | RCA | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 4 | 78602 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
1c3a8ee7-bb99-4808-b734-08d143449f4d | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Central African Republic | RCA | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 1 | 20677 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
0a8e78c4-0085-4f34-8051-b477950f45ee | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Chad | TCD | ALP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 3 | 20895 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
94dac4b7-5c09-4ef5-b9fa-bd214465d63f | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Chad | TCD | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 8 | 41671 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
3993a63d-8b36-4e81-8a61-b8a4ac9b1b60 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Chad | TCD | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 12 | 162013 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
f144c95b-22f6-4c33-8433-cfa67558efb7 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Chad | TCD | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 7 | 95762 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
e70fb4d2-2bf9-44fc-a62f-ce5beb1810f9 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Comoros | COM | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 2 | 9758 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
f10869bf-b391-4472-8b50-07f9520ad53e | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Comoros | COM | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 3 | 34072 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
8faea0dc-803f-4390-be21-5ee4ae106abd | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Comoros | COM | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 6 | 100075 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
6160a93d-7949-4bea-bd26-2f09b979b4aa | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Cote d'Ivoire | CIV | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 10 | 153249 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
f93ccd3e-981b-43cb-b6cd-7cdfc754531e | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Democratic Republic of Congo | COD | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 65 | 171201 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
ef33d15b-7f46-43e8-b72e-e80ab67d8811 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Democratic Republic of Congo | COD | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 5 | 83513 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
c01363b1-875a-4192-9a2d-f394f581f6b4 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Djibouti | DJI | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 5 | 21632 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
a375c690-68fe-44f2-84a6-8be2decfd8a8 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Djibouti | DJI | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 12 | 291201 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
152bee2b-5147-4a22-8d59-4387e1822acc | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Djibouti | DJI | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 22 | 76360 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
aa1b2c65-e69e-4969-945c-f0725ffb20d5 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Equatorial Guinea | GNQ | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 1 | 5366 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
49b0d5fa-f1df-48cc-9dc5-74326b031805 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Equatorial Guinea | GNQ | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 7 | 84302 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
5c44d967-9689-4dde-bdb9-d05dcbcc9555 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Ethiopia | ETH | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 5 | 66413 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
3b6eecfd-9cff-47ec-99c4-4084b50af068 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Ethiopia | ETH | FMF - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 43 | 185098 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
58e41ad9-c529-4732-87b3-e2051f04ad35 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Ethiopia | ETH | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 38 | 443318 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
4a763ef7-4374-4839-87b9-fbdcdb52d0e3 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Ethiopia | ETH | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 33 | 92648 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
fdad2151-55c5-46b7-913e-b7ca11b0e58f | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Gabon | GAB | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 1 | 2600 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
32c4abba-f717-4f4f-9025-1821640ff253 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Gabon | GAB | GPOI - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 516 | 730011 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
b15c48f0-35f9-4bad-bdda-22fe2feac3b6 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Gabon | GAB | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 13 | 196647 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
38f62e7b-1de3-42cf-9879-b0a93d24f3d0 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Gabon | GAB | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 11 | 130730 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
3c8b9328-8f3f-443e-aba2-c5404051ae1b | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Gambia | GMB | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 3 | 4860 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
28903d9a-8b2a-4a0c-9503-4165bfdfd84e | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Gambia | GMB | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 67 | 144649 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
418c7ae0-778e-4457-884a-2bbd04e9e36f | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Gambia | GMB | IMET-X - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 4 | 14027 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
e6c128c9-9229-425b-9092-a096a3fcad5f | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Gambia | GMB | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 7 | 98241 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
1b2e0b2f-5d19-4867-9afe-2d1778bef5ee | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Ghana | GHA | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 7 | 146017 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
2cdc45af-d053-4353-9966-d6a75ac0945d | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Ghana | GHA | FMF - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 4 | 36623 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
3f64f5f9-cadf-445c-b162-18ca7c55da36 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Ghana | GHA | GPOI - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 1219 | 4611879 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
f8894d66-ecdd-4015-954d-3ed0d07bb930 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Ghana | GHA | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 45 | 651345 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
2653571f-3fa3-4b27-908b-56ce64f2c8e7 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Ghana | GHA | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 15 | 157513 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
45d4a8e4-4b87-4f1b-81d9-8b5564a4f2cb | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Ghana | GHA | Section 1004 - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 6 | 87218 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
3d1b5117-7ae0-4cbc-995c-45d33c041a1c | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Guinea | GIN | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 101 | 389951 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
c1a09f69-ba58-4827-a51a-dadf050393be | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Guinea | GIN | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 5 | 73702 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
5b0661b6-27f0-4065-843d-0749ed901c7e | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Guinea-Bissau | GNB | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 36 | 73039 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
0a99ea97-7f7f-42a5-b644-45a1b0392ef8 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Guinea-Bissau | GNB | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 5 | 70785 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
c882b3a5-fec1-4d9f-b86e-f785100c07d4 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Kenya | KEN | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 50 | 474706 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
c2abbb7a-ede2-4334-894c-e7b3a0eef9df | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Kenya | KEN | DOHS/USCG - FY 2007 DOHS Training | US unit not specified in 2007-2008 report | 29 | 115975 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
53262072-0333-46a6-aef2-671c7ca694b8 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Kenya | KEN | GPOI - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 141 | 888269 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
dd58732e-d440-430a-9000-25a044747de3 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Kenya | KEN | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 2 | 13533 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
81210aaf-b7fd-4426-9372-f1e9e4d768a3 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Kenya | KEN | IMET-X - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 5 | 60627 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
f9eb2dfd-2b62-49b0-a06c-96bbd9a226f9 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Kenya | KEN | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 13 | 134398 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
74d4ef87-65fe-4a4d-aa10-d08464881a87 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Lesotho | LSO | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | UNK | 1/23/2007 | 2007-01-23 | 1/24/2007 | 2007-01-24 | Marshall Center Garmisch, Germany | 71 | 187913 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |
b8cc5cf8-85da-4dfa-af09-2b1291bd1e5b | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Lesotho | LSO | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||||
5d903c17-2d65-43e1-9a63-a84061dcd1e0 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Liberia | LBR | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 7 | 58097 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
9299a449-7870-484d-9241-d6a665316954 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Liberia | LBR | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 3 | 59159 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
dfbef2aa-c291-4a89-83e3-d277c2643ddf | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Madagascar | MDG | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 4 | 13638 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
525178e8-4851-4e30-aad2-397bf4f1ca18 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Madagascar | MDG | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 28 | 97346 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
5a246b0b-689a-4417-9fff-e2ec78b255ef | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Madagascar | MDG | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 11 | 153394 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
27dabf8e-519e-4c44-b071-648cc5c92f61 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Madagascar | MDG | Service Academies - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 1 | 0 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
daaff75a-d849-4644-ae89-9b26b0984933 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Malawi | MWI | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 3 | 12358 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
785379e2-234c-4806-b253-dad20741aa3a | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Malawi | MWI | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 29 | 262852 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
c78bebfa-7f87-42f7-8384-cc44cf4fdf1b | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Malawi | MWI | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 29 | 159467 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
079bb3e9-7f61-426d-9e04-ac3db2139cc7 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Mali | MLI | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 10 | 272639 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
8f1d820b-44ff-4c39-b1f1-68654b6d343b | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Mali | MLI | GPOI - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 391 | 522003 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
1ba9bf14-721b-4f9d-95b6-b205c0554ffe | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Mali | MLI | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 4 | 28250 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
dd42e6c0-296d-4f14-86ed-002737c6877f | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Mali | MLI | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 25 | 88744 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
bec64c13-5c4a-4ada-8083-76d5147a2c55 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Mauritania | MRT | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 24 | 90204 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
5b925c50-91da-4ad2-ab8c-b460da70f893 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Mauritania | MRT | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 28 | 40166 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
866ea911-9c25-41ef-9455-8c4ac1972666 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Mauritania | MRT | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 6 | 85422 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
84ca7fc4-d0ac-483b-9023-80de6c336a6b | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Mauritania | MRT | Section 1004 - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 50 | 250000 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
cbadb043-c60e-4373-b37e-0291337b73d3 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Mauritius | MUS | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 50 | 94451 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
185031c0-56a1-43b5-91d2-f25d78b7fc83 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Mauritius | MUS | Regional Centers - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 8 | 142512 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
29cd97da-860b-46d4-808e-41c0f55f0a7a | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Mauritius | MUS | Service Academies - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 1 | 0 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
bd8dccac-5e9b-4fce-96f7-4aad6b85450c | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Mozambique | MOZ | CTFP - FY 2007 DoD Training | US unit not specified in 2007-2008 report | 8 | 70119 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
197fc205-2171-4570-81f9-027d10e73740 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Mozambique | MOZ | GPOI - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 47 | 66063 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 | |||||||
43e3b2ac-6482-426e-8ed8-9fcf39bafa53 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Africa_fmtrpt.tsv | Mozambique | MOZ | IMET-1 - FY 2007 DoS Training | US unit not specified in 2007-2008 report | 67 | 180054 | https://2009-2017.state.gov/documents/organization/126573.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 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]);