training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
63 rows where "qa:training_date_first_seen" is on date -4707-05-29 and "training:end_date" is on date 2012-05-17 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7f4b3a48-e439-4ada-9216-477bd177f19c | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Bosnia & Herzegovina | BIH | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Armed Forces | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 1 | 2765 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
a83fd882-7ca1-428b-aa34-f8f9456c1f04 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Bosnia & Herzegovina | BIH | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Ministry of Defense | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 1 | 1421 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
b1b71cc6-aed0-4b61-a304-00fc3a1dfb90 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Kosovo | XKX | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Police Service | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 1 | 1727 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
b2f2ed4a-0571-4af2-ab11-fccbdfa112cc | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Macedonia | MKD | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Academia | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 1 | 1662 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
aaa16cb3-4632-4a46-99d5-69a4bdaedcdc | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Macedonia | MKD | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Ministry of Defense | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 1 | 865 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
596afe30-7798-46f0-b791-1fcd7fc4c999 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Moldova | MDA | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Ministry of Defense | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 1 | 2376 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
741f5d91-638d-48e8-834c-c3c3614eef62 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Moldova | MDA | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Ministry of Reintegration | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 1 | 2244 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
27ef5253-fba1-4664-b6fd-18360eec5353 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Republic of Montenegro | MNE | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Academia | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 1 | 865 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
7656a9fe-187a-4310-80e3-4ce8c94fc3ea | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Republic of Montenegro | MNE | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Ministry of Defense | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 3 | 2595 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
7bc1d292-e410-4692-a0a3-570f90def939 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Republic of Montenegro | MNE | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Ministry of Foreign Affairs | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 1 | 865 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
353c77ee-ea41-4764-8670-14a6af4a8c88 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Republic of Montenegro | MNE | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | National Security Agency | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 1 | 865 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
111caab8-9a6d-4861-8080-866584203902 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Republic of Montenegro | MNE | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Police | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 2 | 1730 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
f7e93d2a-9593-4a30-b20a-be3fa71653ad | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Republic of Serbia | SRB | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Ministry of Defense | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 2 | 2096 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
e049b79c-6bb3-4664-8cbd-eb5c7c69e43c | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Ukraine | UKR | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Defense Attache Office, U.S. Embassy Ukraine | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 1 | 865 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
69045d76-8fd5-4b33-894a-75eb8ce0f4d6 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Ukraine | UKR | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Institute | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 1 | 1794 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
e8de9c60-33ab-4f5e-a5e4-6964d10cdd9a | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Ukraine | UKR | Regional Centers - Fiscal Year 2012 Department of Defense Training | 1st Annual MCAA SEES Workshop \"Regional Cooperation in the Security Sector\" | MC | Parliament | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | Podgorica, Montenegro | 1 | 1864 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
3339b7b2-5a0a-430f-aa74-bd7bb080af69 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2012 Department of State Training | AH-64 Flight Simulator | WESTERN ARMY AVIATION TRAINING SITE | IAF Air Wing 25 | 5/14/2012 | 2012-05-14 | 5/17/2012 | 2012-05-17 | WESTERN ARMY AVIATION TRAINING SITE | 6 | 15120 | https://2009-2017.state.gov/documents/organization/213466.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
859a26ae-5a94-4683-ab24-dd6f694f6bea | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | IMET-1 - Fiscal Year 2012 Department of State Training | DEF RES MGT CRS | DEFENSE RESOURCES MANAGEMENT INSTITUTE NPS MONTEREY CA | BR Army Staff | 4/23/2012 | 2012-04-23 | 5/17/2012 | 2012-05-17 | MONTEREY, CA | 1 | 7297 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
299d9965-ce5c-4af5-809a-4811084f0b6e | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | Section 1004 - Fiscal Year 2012 Department of Defense Training | International Small Arms Maintenance (ISAM) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1st Marine CORPS BN | 4/23/2012 | 2012-04-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 10064 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
a680dd13-a7ed-4e96-bce8-0b3073517aa2 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | Section 1004 - Fiscal Year 2012 Department of Defense Training | International Small Arms Maintenance (ISAM) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Navy Academy | 4/23/2012 | 2012-04-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 10064 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
b1f9179f-57dc-4f40-9b01-b78343fa5f49 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2012 Department of State Training | International Small Arms Maintenance (ISAM) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Colombian National Police, CARABINEROS | 4/20/2012 | 2012-04-20 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 6 | 35898 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
7e19511a-5be7-4bdd-9844-499d7332dc20 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2012 Department of State Training | International Small Arms Maintenance (ISAM) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Colombian National Police, Rural OPS Command | 4/20/2012 | 2012-04-20 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 5983 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
ab9e2cfc-921a-41f8-abe4-a0e18008e6da | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Peru | PER | INCLE - Fiscal Year 2012 Department of State Training | International Small Arms Maintenance (ISAM) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Peruvian National Air Police (DIRAVPOL) | 4/20/2012 | 2012-04-20 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 2 | 21728 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
5f7728ac-749b-4d58-8f46-cf52b7c0e7f6 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_East_Asia_and_Pacific_fmtrpt.tsv | Singapore | SGP | DHS/USCG - Fiscal Year 2012 Department of Homeland Security Training | Boarding OFF Basic EIMET | USCG MARITIME LAW ENFORCEMENT ACAD FLETC CHARLESTON | Singapore Police Coast Guard | 4/16/2012 | 2012-04-16 | 5/17/2012 | 2012-05-17 | USCG MARITIME LAW ENFORCEMENT ACAD FLETC CHARLESTON | 1 | 6531 | https://2009-2017.state.gov/documents/organization/213462.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
aea542a2-e073-4eee-8933-e314556cc4d4 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2012 Department of State Training | International Tactical Communications Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Colombian National Police, Anti Narcotics Directorate | 4/13/2012 | 2012-04-13 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 7463 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
58910a35-ea1e-471d-94b0-35f830a13ac3 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2012 Department of State Training | International Tactical Communications Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Colombian National Police, CARABINEROS | 4/13/2012 | 2012-04-13 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 14 | 104482 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
d002ca35-ec7e-4bfc-b4da-0800b786cafb | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2012 Department of State Training | International Tactical Communications Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Colombian National Police, Rural OPS Command | 4/13/2012 | 2012-04-13 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 5 | 37315 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
eb1aded9-f8dc-4514-80a8-c3cf67c57294 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | Section 1004 - Fiscal Year 2012 Department of Defense Training | International Tactical Communications Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | DR Navy | 4/13/2012 | 2012-04-13 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 13527 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
d67bc81e-9df8-4bfd-9bf4-4909b4c336a3 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | Section 1004 - Fiscal Year 2012 Department of Defense Training | International Tactical Communications Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Navy | 4/13/2012 | 2012-04-13 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 13527 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
a9d16357-2472-4fec-9df0-5e5a1b6cb2e5 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Africa_fmtrpt.tsv | Cape Verde, Republic of | CPV | IMET-1 - Fiscal Year 2012 Department of State Training | Diesel System'S Overhaul and Maintenance (DSOM) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Coast Guard | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 2 | 36858 | https://2009-2017.state.gov/documents/organization/213460.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
b0653123-dedf-43e3-84dc-b334bb0bb44b | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Africa_fmtrpt.tsv | Mozambique | MOZ | IMET-1 - Fiscal Year 2012 Department of State Training | OUTBOARD MTR MT & OVHL | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | FADM | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 23229 | https://2009-2017.state.gov/documents/organization/213460.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
c4995617-43ec-4e82-8d20-973e524d5ebb | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | Section 1004 - Fiscal Year 2012 Department of Defense Training | OUTBOARD MTR MT & OVHL | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Engineer Battalion | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 17848 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
3b4f1910-f4a1-4416-824d-297f98d32cc9 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | Section 1004 - Fiscal Year 2012 Department of Defense Training | OUTBOARD MTR MT & OVHL | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Ilha do Governador Marine Corps Base | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 17942 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
17a2ed3b-728f-4b5d-bbbb-5910c6678b0c | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | Section 1004 - Fiscal Year 2012 Department of Defense Training | OUTBOARD MTR MT & OVHL | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Navy | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 19079 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
91fb9f48-c442-46a7-a4af-fd0857ad6af8 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - Fiscal Year 2012 Department of Defense Training | OUTBOARD MTR MT & OVHL | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Coast Guard SubCommand Esmeraldas`` | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 18279 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
81b0d23d-8af5-4bc3-a927-69edc45f0d82 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - Fiscal Year 2012 Department of Defense Training | Patrol Craft Hull MAINT | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Floating Dike Rio Napo | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 18279 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
4d720577-98b0-4146-9bea-acf3e3b11b05 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | El Salvador | SLV | Section 1004 - Fiscal Year 2012 Department of Defense Training | OUTBOARD MTR MT & OVHL | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | LA UNION Navy Base | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 18879 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
12ba943e-b4ff-44db-bb2a-407f7e6fd9b9 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | El Salvador | SLV | Section 1004 - Fiscal Year 2012 Department of Defense Training | OUTBOARD MTR MT & OVHL | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Navy | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 18879 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
8d78f519-82ee-4d82-b6df-e1e81f3e3c3b | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | El Salvador | SLV | Section 1004 - Fiscal Year 2012 Department of Defense Training | Patrol Craft Hull MAINT | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Navy | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 2 | 37758 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
937bdd32-97ac-457f-956b-0a8ea8cec8f6 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - Fiscal Year 2012 Department of Defense Training | Diesel System'S Overhaul and Maintenance (DSOM) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | MAINT | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 18479 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
8d32b39f-19f5-4774-a471-3dbc57262408 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - Fiscal Year 2012 Department of Defense Training | OUTBOARD MTR MT & OVHL | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | MAINT | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 18479 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
d9ae668e-3384-41c8-9032-9b3579c62cbf | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - Fiscal Year 2012 Department of Defense Training | OUTBOARD MTR MT & OVHL | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | MAINT. | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 18479 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
6e72b5b2-c538-4a40-bbab-512ec73f2d38 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - Fiscal Year 2012 Department of Defense Training | Patrol Craft Hull MAINT | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | MAINT. | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 18479 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
8aaa2366-e5b5-4e6f-bb0d-5c29ba7d22ff | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - Fiscal Year 2012 Department of Defense Training | Patrol Craft Hull MAINT | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Navy MAINT Unit | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 18479 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
a46894cc-5064-4d8c-8d2e-30612c1eacfb | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | Section 1004 - Fiscal Year 2012 Department of Defense Training | Diesel System'S Overhaul and Maintenance (DSOM) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | SENAN | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 17779 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
f6829275-60cc-4f7a-9d5e-89978c176e49 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | Section 1004 - Fiscal Year 2012 Department of Defense Training | Diesel System'S Overhaul and Maintenance (DSOM) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | UTOA / PNP | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 17779 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
8745deb6-ebb8-40a3-87a5-f9dcf1151edd | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | Section 1004 - Fiscal Year 2012 Department of Defense Training | Patrol Craft Hull MAINT | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | SENAFRONT | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 17779 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
140ef81a-505e-405f-acb5-51ad04b3461d | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | Section 1004 - Fiscal Year 2012 Department of Defense Training | Patrol Craft Hull MAINT | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | UTOA / PNP | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 17779 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
93dfc901-88d9-4a35-ba78-bc5f78f81619 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Peru | PER | Section 1004 - Fiscal Year 2012 Department of Defense Training | Patrol Craft Hull MAINT | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Navy | 3/23/2012 | 2012-03-23 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 19000 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
055e3b21-eda3-466f-a006-f0487a273730 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2012 Department of State Training | Patrol Craft Officer Riverine (PCOR) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Colombian Navy, Intelligence Directorate | 3/16/2012 | 2012-03-16 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 13381 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
ef1d7b06-2acf-480c-9bc5-5cff0dce63bf | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2012 Department of State Training | Patrol Craft Officer Riverine (PCOR) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Colombian Navy, Intelligence Group | 3/16/2012 | 2012-03-16 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 2 | 26762 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
4ff39308-486a-4eb7-99a6-6ceb30f64e70 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - Fiscal Year 2012 Department of Defense Training | Patrol Craft Officer Riverine (PCOR) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Port Authority of San Lorenzo | 3/16/2012 | 2012-03-16 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 20129 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
02370024-5dde-45d1-aeeb-393086450eb6 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | El Salvador | SLV | Section 1004 - Fiscal Year 2012 Department of Defense Training | Patrol Craft Officer Riverine (PCOR) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Navy | 3/16/2012 | 2012-03-16 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 2 | 41458 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
ed722c49-e617-4138-81f8-33f7043289e9 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - Fiscal Year 2012 Department of Defense Training | Patrol Craft Officer Riverine (PCOR) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Communications | 3/16/2012 | 2012-03-16 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 20329 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
10bcdd75-32c7-496a-9a04-7fd05a66c74b | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | Section 1004 - Fiscal Year 2012 Department of Defense Training | Patrol Craft Officer Riverine (PCOR) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | UTOA / PNP | 3/16/2012 | 2012-03-16 | 5/17/2012 | 2012-05-17 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 19629 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
2b283433-2448-4037-b04c-798884241607 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | IMET-1 - Fiscal Year 2012 Department of State Training | PA Qualification Course | DEFENSE INFORMATION SCHOOL | Counter Insurgency and Jungle Warfare School | 3/13/2012 | 2012-03-13 | 5/17/2012 | 2012-05-17 | DEFENSE INFORMATION SCHOOL | 1 | 21454 | https://2009-2017.state.gov/documents/organization/213468.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
bcfef331-2619-4430-a907-8af2ef4bc0fc | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - Fiscal Year 2012 Department of State Training | Special Forces Qualification IED (DET OFF) | JFK SPECIAL WARFARE CENTER | 2SFC, ISFBN, SFR(A), SOCOM | 9/30/2011 | 2011-09-30 | 5/17/2012 | 2012-05-17 | JFK SPECIAL WARFARE CENTER | 1 | 34453 | https://2009-2017.state.gov/documents/organization/213462.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
93468565-7ce5-4912-b5bd-55484b20e72f | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_East_Asia_and_Pacific_fmtrpt.tsv | Thailand | THA | IMET-1 - Fiscal Year 2012 Department of State Training | Special Forces Qualification IED (DET OFF) | JFK SPECIAL WARFARE CENTER | Special Warfare Command, Royal Thai Army | 9/30/2011 | 2011-09-30 | 5/17/2012 | 2012-05-17 | JFK SPECIAL WARFARE CENTER | 1 | 34814 | https://2009-2017.state.gov/documents/organization/213462.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
46786008-9788-46c8-9b74-8875c1d5e7f2 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Georgia | GEO | IMET-1 - Fiscal Year 2012 Department of State Training | Special Forces Qualification IED (DET OFF) | JFK SPECIAL WARFARE CENTER | Joint Staff | 9/30/2011 | 2011-09-30 | 5/17/2012 | 2012-05-17 | JFK SPECIAL WARFARE CENTER | 1 | 34153 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
0d6ce8dc-629d-4e14-a800-a0a9dbc5015b | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Moldova | MDA | IMET-1 - Fiscal Year 2012 Department of State Training | Special Forces Qualification IED (DET OFF) | JFK SPECIAL WARFARE CENTER | Separate SF Battalion, Moldovan Army | 9/30/2011 | 2011-09-30 | 5/17/2012 | 2012-05-17 | JFK SPECIAL WARFARE CENTER | 1 | 33560 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
8ff70a41-05d6-4c64-a6f1-f36c85eabf54 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2012 Department of State Training | Special Forces Qualification IED (DET OFF) | JFK SPECIAL WARFARE CENTER | Infantry DEPT | 9/30/2011 | 2011-09-30 | 5/17/2012 | 2012-05-17 | JFK SPECIAL WARFARE CENTER | 1 | 33928 | https://2009-2017.state.gov/documents/organization/213466.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
7a2de37e-8868-4da5-952b-e072768916cd | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_South_Central_Asia_fmtrpt.tsv | India | IND | IMET-1 - Fiscal Year 2012 Department of State Training | Advanced Military Studies | COMMAND & GENERAL STAFF COLLEGE | Artillery | 7/5/2011 | 2011-07-05 | 5/17/2012 | 2012-05-17 | COMMAND & GENERAL STAFF COLLEGE | 1 | 59055 | https://2009-2017.state.gov/documents/organization/213468.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
64d16f7c-1d98-49b4-924a-8b40e1d5d27b | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_South_Central_Asia_fmtrpt.tsv | India | IND | IMET-1 - Fiscal Year 2012 Department of State Training | Advanced Operational Studies Fellowship | COMMAND & GENERAL STAFF COLLEGE | HQ 33 ARMD DIV | 6/24/2011 | 2011-06-24 | 5/17/2012 | 2012-05-17 | COMMAND & GENERAL STAFF COLLEGE | 1 | 100958 | https://2009-2017.state.gov/documents/organization/213468.pdf | Not checked against source; verify accuracy before use | 2013 | 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]);