training-data

Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more

84 rows where "qa:training_date_first_seen" is on date -4707-05-30 and "training:end_date" is on date 2013-02-01 sorted by training:start_date descending

✎ View and edit SQL

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
f4e5d28c-c100-4fc6-b63b-774becc4a47c 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Brazil BRA Regional Centers - Fiscal Year 2013 Department of Defense Training IADB PKO Exercise N/A Inter-American Defense Board 1/31/2013 2013-01-31 2/1/2013 2013-02-01 Washington, DC, United States 5 0 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
b1de062d-fd5e-40c5-8feb-3e19f261cc47 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Chile RCH Regional Centers - Fiscal Year 2013 Department of Defense Training IADB PKO Exercise N/A Inter-American Defense Board 1/31/2013 2013-01-31 2/1/2013 2013-02-01 Washington, DC, United States 1 0 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
a19e5b69-abc7-44ff-8f33-fdc2522bbc4f 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Colombia COL Regional Centers - Fiscal Year 2013 Department of Defense Training IADB PKO Exercise N/A Inter-American Defense Board 1/31/2013 2013-01-31 2/1/2013 2013-02-01 Washington, DC, United States 3 0 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
3c393010-80f7-403b-8904-4f99d0746d41 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Dominican Republic DOM Regional Centers - Fiscal Year 2013 Department of Defense Training IADB PKO Exercise N/A Inter-American Defense Board 1/31/2013 2013-01-31 2/1/2013 2013-02-01 Washington, DC, United States 1 0 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
5cad5a1b-7c44-42ac-854f-5f78f87ed0f6 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Dominican Republic DOM Regional Centers - Fiscal Year 2013 Department of Defense Training IADB PKO Exercise N/A Policía Nacional de la República Dominicana 1/31/2013 2013-01-31 2/1/2013 2013-02-01 Washington, DC, United States 1 0 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
943d8fd7-6315-4805-98fc-397e15900b71 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Ecuador ECU Regional Centers - Fiscal Year 2013 Department of Defense Training IADB PKO Exercise N/A Inter-American Defense Board 1/31/2013 2013-01-31 2/1/2013 2013-02-01 Washington, DC, United States 2 0 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
bcffab52-ba56-4dcc-b14e-04fc96757af8 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Mexico MEX Regional Centers - Fiscal Year 2013 Department of Defense Training IADB PKO Exercise N/A Inter-American Defense Board 1/31/2013 2013-01-31 2/1/2013 2013-02-01 Washington, DC, United States 1 0 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
a0bd2f01-3c9f-4c89-aa16-f1b72b1014e8 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Peru PER Regional Centers - Fiscal Year 2013 Department of Defense Training IADB PKO Exercise N/A Inter-American Defense Board 1/31/2013 2013-01-31 2/1/2013 2013-02-01 Washington, DC, United States 1 0 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
9b6306d8-0992-4c67-be06-5f9a0837d06d 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_South_Central_Asia_fmtrpt.tsv India IND Regional Centers - Fiscal Year 2013 Department of Defense Training PKO Stability Operations RET - TAJ N/A   1/29/2013 2013-01-29 2/1/2013 2013-02-01 Dushanbe, Tajikistan 1 2284 https://2009-2017.state.gov/documents/organization/230217.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
d9030fd1-1ab5-4df8-b844-49caa7fd1a83 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_South_Central_Asia_fmtrpt.tsv Tajikistan TJK Regional Centers - Fiscal Year 2013 Department of Defense Training PKO Stability Operations RET - TAJ N/A   1/29/2013 2013-01-29 2/1/2013 2013-02-01 Dushanbe, Tajikistan 18 41112 https://2009-2017.state.gov/documents/organization/230217.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
a2b9c6d1-6371-4451-8ab3-567c24aaa2b3 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_South_Central_Asia_fmtrpt.tsv Tajikistan TJK Regional Centers - Fiscal Year 2013 Department of Defense Training PKO Stability Operations RET - TAJ N/A Informational Security, Security Council under the Presidential Administrat 1/29/2013 2013-01-29 2/1/2013 2013-02-01 Dushanbe, Tajikistan 1 2284 https://2009-2017.state.gov/documents/organization/230217.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
7ec88250-3407-4b03-b67b-39b800bab359 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Kenya KEN PKO - Fiscal Year 2013 Department of State Training ADSN Pre-Deployment Training - GPOI N/A N/A 1/28/2013 2013-01-28 2/1/2013 2013-02-01 Kenya 16 0 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
5dbe4e8b-9143-4fa7-a7e3-862f02c2426b 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv Singapore SGP CTFP - Fiscal Year 2013 Department of Defense Training AP13-1 Asia-Pacific Orientation Course N/A Republic of Singapore Air Force 1/28/2013 2013-01-28 2/1/2013 2013-02-01 Honolulu, United States 1 0 https://2009-2017.state.gov/documents/organization/230211.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
d49d441c-bdd7-4288-a9e9-acfc2536487a 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv Singapore SGP CTFP - Fiscal Year 2013 Department of Defense Training AP13-1 Asia-Pacific Orientation Course N/A Republic of Singapore Navy 1/28/2013 2013-01-28 2/1/2013 2013-02-01 Honolulu, United States 1 0 https://2009-2017.state.gov/documents/organization/230211.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
66a841f1-ad39-46fc-8b26-ca96f42a023a 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv Singapore SGP CTFP - Fiscal Year 2013 Department of Defense Training AP13-1 Asia-Pacific Orientation Course N/A Singapore Armed Forces 1/28/2013 2013-01-28 2/1/2013 2013-02-01 Honolulu, United States 1 0 https://2009-2017.state.gov/documents/organization/230211.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
1cb2ff71-fcbf-4bfb-8e7b-12fdada2c3f0 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv Singapore SGP CTFP - Fiscal Year 2013 Department of Defense Training AP13-1 Asia-Pacific Orientation Course N/A Singapore Ministry of Defense 1/28/2013 2013-01-28 2/1/2013 2013-02-01 Honolulu, United States 1 0 https://2009-2017.state.gov/documents/organization/230211.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
f2d6e60a-8961-4d5b-b837-4ee6c23c9a7a 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv Taiwan TWN CTFP - Fiscal Year 2013 Department of Defense Training AP13-1 Asia-Pacific Orientation Course N/A Taiwan Ministry of Foreign Affairs 1/28/2013 2013-01-28 2/1/2013 2013-02-01 Honolulu, United States 2 0 https://2009-2017.state.gov/documents/organization/230211.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
f10028a9-457e-43a0-b95d-2e6bd2161d7e 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv Taiwan TWN CTFP - Fiscal Year 2013 Department of Defense Training AP13-1 Asia-Pacific Orientation Course N/A Taiwan Ministry of National Defense 1/28/2013 2013-01-28 2/1/2013 2013-02-01 Honolulu, United States 1 0 https://2009-2017.state.gov/documents/organization/230211.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
46a02c9e-a039-4da0-a45b-bba47600fb9d 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv Vietnam VNM Regional Centers - Fiscal Year 2013 Department of Defense Training AP13-1 Asia-Pacific Orientation Course N/A Asia-Pacific Center for Security Studies 1/28/2013 2013-01-28 2/1/2013 2013-02-01 Honolulu, United States 1 0 https://2009-2017.state.gov/documents/organization/230211.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
02262275-ab96-4d13-b284-82867f043b97 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Jordan JOR FMF - Fiscal Year 2013 Department of State Training UH-60A/L Flight Simulator EASTERN AVIATION TRAINING SITE PRINCE HASHEM ROYAL BRIGADE 1/28/2013 2013-01-28 2/1/2013 2013-02-01 EASTERN AVIATION TRAINING SITE 1 10386 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
7d62c31b-af4a-44e2-8706-d0da0afc8dc2 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Jordan JOR FMF - Fiscal Year 2013 Department of State Training UH-60A/L Flight Simulator EASTERN AVIATION TRAINING SITE Prince Hashim Royal Bde 1/28/2013 2013-01-28 2/1/2013 2013-02-01 EASTERN AVIATION TRAINING SITE 1 10386 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
dafb8eb7-20ab-41ee-890f-704e0e10c141 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Jordan JOR FMF - Fiscal Year 2013 Department of State Training UH-60A/L Flight Simulator EASTERN AVIATION TRAINING SITE ROYAL SQUADRON 1/28/2013 2013-01-28 2/1/2013 2013-02-01 EASTERN AVIATION TRAINING SITE 2 20772 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
c6a93e07-fe4b-455e-bdd2-bb7001cad5f8 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Burundi BDI CTFP - Fiscal Year 2013 Department of Defense Training Improving Regional Responses to Transnational Threats N/A Ministry of National Defense and Veterans Affairs 1/27/2013 2013-01-27 2/1/2013 2013-02-01   4 26925 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
d5312142-7330-4909-9206-ce1af3ded81c 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Burundi BDI CTFP - Fiscal Year 2013 Department of Defense Training Improving Regional Responses to Transnational Threats N/A Ministry of Public Security 1/27/2013 2013-01-27 2/1/2013 2013-02-01   2 17950 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
16770a48-9e59-4815-8940-7ba79ce77940 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Djibouti DJI CTFP - Fiscal Year 2013 Department of Defense Training Improving Regional Responses to Transnational Threats N/A Ministry of Foreign Affairs and International Cooperation 1/27/2013 2013-01-27 2/1/2013 2013-02-01   1 8975 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
4540b04a-300f-4d87-9f3b-e88bd065e080 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Djibouti DJI CTFP - Fiscal Year 2013 Department of Defense Training Improving Regional Responses to Transnational Threats N/A Ministry of Interior 1/27/2013 2013-01-27 2/1/2013 2013-02-01   1 8975 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
44beb95c-d7e0-443e-945a-dc2019ef0f1f 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Djibouti DJI Regional Centers - Fiscal Year 2013 Department of Defense Training Improving Regional Responses to Transnational Threats N/A Intergovernmental Authority on Development 1/27/2013 2013-01-27 2/1/2013 2013-02-01   2 17950 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
369e329b-d548-4ad4-b4ab-6847c9f7b60f 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Ethiopia ETH CTFP - Fiscal Year 2013 Department of Defense Training Improving Regional Responses to Transnational Threats N/A Ministry of Federal Affairs 1/27/2013 2013-01-27 2/1/2013 2013-02-01   1 8975 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
02f16495-c660-4293-94dd-efad2d72f2d8 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Ethiopia ETH CTFP - Fiscal Year 2013 Department of Defense Training Improving Regional Responses to Transnational Threats N/A Ministry of Foreign Affairs 1/27/2013 2013-01-27 2/1/2013 2013-02-01   2 17950 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
61859c33-18a6-4432-8b2c-6039e2ad4dd7 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Kenya KEN CTFP - Fiscal Year 2013 Department of Defense Training Improving Regional Responses to Transnational Threats N/A Ministry of State for Defence 1/27/2013 2013-01-27 2/1/2013 2013-02-01   4 35900 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
63fc926c-9627-485e-b30e-31cb3e7be56c 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Tanzania TZA Regional Centers - Fiscal Year 2013 Department of Defense Training Improving Regional Responses to Transnational Threats N/A Ministry of Defence and National Service 1/27/2013 2013-01-27 2/1/2013 2013-02-01   1 8975 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
23c8cfc8-19b5-430d-8a3b-a74202caaa9e 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Uganda UGA CTFP - Fiscal Year 2013 Department of Defense Training Improving Regional Responses to Transnational Threats N/A Office of the President 1/27/2013 2013-01-27 2/1/2013 2013-02-01   1 8975 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
625a1b84-9d11-44eb-b1b2-93a161fdbf66 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Uganda UGA Regional Centers - Fiscal Year 2013 Department of Defense Training Improving Regional Responses to Transnational Threats N/A East African Community 1/27/2013 2013-01-27 2/1/2013 2013-02-01   1 8975 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
fc68298f-0b43-4878-8054-772ce9cfec83 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Uganda UGA Regional Centers - Fiscal Year 2013 Department of Defense Training Improving Regional Responses to Transnational Threats N/A Ministry of Foreign Affairs 1/27/2013 2013-01-27 2/1/2013 2013-02-01   3 26925 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
a1c79be9-d6e3-4152-9ea7-6fd35207fdb2 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Uganda UGA Regional Centers - Fiscal Year 2013 Department of Defense Training Improving Regional Responses to Transnational Threats N/A Ministry of Internal Affairs 1/27/2013 2013-01-27 2/1/2013 2013-02-01   2 17950 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
7bbe42af-6060-4431-8d39-d792246676e9 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Uganda UGA Regional Centers - Fiscal Year 2013 Department of Defense Training Improving Regional Responses to Transnational Threats N/A Office of the President 1/27/2013 2013-01-27 2/1/2013 2013-02-01   1 8975 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
d55eb287-ddf0-41f0-bcb8-be995c22a07d 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Burundi BDI PKO - Fiscal Year 2013 Department of State Training Mortar Operations Training - GPOI N/A BFDN 20 1/21/2013 2013-01-21 2/1/2013 2013-02-01 Mudubugu, Burundi 25 65728 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
5eb22cf4-bf5c-4641-aca7-f02e87949114 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Burundi BDI PKO - Fiscal Year 2013 Department of State Training Train the Trainer - GPOI N/A BFDN 20 1/21/2013 2013-01-21 2/1/2013 2013-02-01 Mudubugu, Burundi 29 0 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
9b66aea7-c015-4b29-97c1-ad0b9b11cb0a 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Gabon GAB PKO - Fiscal Year 2013 Department of State Training Armed Sentry - AMSI MCAST - 4 Gabon Navy 1/21/2013 2013-01-21 2/1/2013 2013-02-01 Libreville, Gabon 20 64125 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
0f64a705-ca81-4049-96aa-83945b0612ab 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Malawi MWI PKO - Fiscal Year 2013 Department of State Training Africa Deployment Assistance Partnership Team - GPOI N/A N/A 1/21/2013 2013-01-21 2/1/2013 2013-02-01 Salima, Malawi 34 29557 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
218250c5-0181-415e-9a30-592950ddf10f 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv Malaysia MYS DOHS/USCG - Fiscal Year 2013 Department of Homeland Security Training MTT Small Boat Operations I COGARD INTL TRNG DET TRACEN YORKTOWN VA Malaysian Maritime Enforcement Agency 1/21/2013 2013-01-21 2/1/2013 2013-02-01 COGARD INTL TRNG DET TRACEN YORKTOWN VA 16 0 https://2009-2017.state.gov/documents/organization/230211.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
e6ab4d25-9b10-4f3f-9f6d-1a31ab952c7b 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Egypt EGY FMF - Fiscal Year 2013 Department of State Training CH-47D Flight Simulator EASTERN AVIATION TRAINING SITE KOM OSHEIM AIR BASE 1/21/2013 2013-01-21 2/1/2013 2013-02-01 EASTERN AVIATION TRAINING SITE 2 17663 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
7f162d1a-045e-4fae-a9a9-7c9cc9a20310 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Egypt EGY IMET-1 - Fiscal Year 2013 Department of State Training Signal Captains Career PREP-International SIGNAL SCHOOL SIGNAL DEPT 1/16/2013 2013-01-16 2/1/2013 2013-02-01 SIGNAL SCHOOL 1 8473 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
d89caab4-4c62-4056-96c2-9aa6977256c5 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv Philippines PHL IMET-1 - Fiscal Year 2013 Department of State Training Airborne INFANTRY SCHOOL 4TH SPECIAL FORCES TEAM, SFBN, SFR(AIRBORNE) SOCOM PA 1/14/2013 2013-01-14 2/1/2013 2013-02-01 INFANTRY SCHOOL 1 8338 https://2009-2017.state.gov/documents/organization/230211.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
872a44e8-bb8f-42fb-af8a-fbe4fde2bc51 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Europe_fmtrpt.tsv Macedonia MKD FMF - Fiscal Year 2013 Department of State Training Airborne INFANTRY SCHOOL SF Battalion, Special Operations Regiment 1/14/2013 2013-01-14 2/1/2013 2013-02-01 INFANTRY SCHOOL 1 8538 https://2009-2017.state.gov/documents/organization/230213.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
23c7b103-5efd-4e0e-b1a9-a576a0371c0e 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Egypt EGY FMF - Fiscal Year 2013 Department of State Training Initial Naval Aviation Survival Training NAVAL OPERATIONAL MEDICINE INSTITUTE DET NAMI BORG ELARAB AIR BASE 1/14/2013 2013-01-14 2/1/2013 2013-02-01 NAVAL OPERATIONAL MEDICINE INSTITUTE DET NAMI 1 2435 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
fb07c419-de5d-4a5f-91fe-483e35c080f0 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Egypt EGY FMF - Fiscal Year 2013 Department of State Training Initial Naval Aviation Survival Training NAVAL OPERATIONAL MEDICINE INSTITUTE DET NAMI SH-2G SQUADRON 1/14/2013 2013-01-14 2/1/2013 2013-02-01 NAVAL OPERATIONAL MEDICINE INSTITUTE DET NAMI 1 2435 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
1aca2319-adb1-492e-91b2-4fede882455c 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Lebanon LBN FMF - Fiscal Year 2013 Department of State Training Airborne INFANTRY SCHOOL Ranger Regiment 1/14/2013 2013-01-14 2/1/2013 2013-02-01 INFANTRY SCHOOL 1 9888 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
2e20595e-c3a1-47ba-a337-102bbca98c69 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_South_Central_Asia_fmtrpt.tsv Kazakhstan KAZ Regional Centers - Fiscal Year 2013 Department of Defense Training Consecutive Interpretation Techniques Course N/A US Embassy Astana 1/14/2013 2013-01-14 2/1/2013 2013-02-01 Garmisch-Partenkirchen, Germany 1 3753 https://2009-2017.state.gov/documents/organization/230217.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
22ae591f-738c-4cd1-8740-ac8a15cc9bea 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_South_Central_Asia_fmtrpt.tsv Kazakhstan KAZ Regional Centers - Fiscal Year 2013 Department of Defense Training Consecutive Interpretation Techniques Course N/A US Embassy, Kazakhstan 1/14/2013 2013-01-14 2/1/2013 2013-02-01 Garmisch-Partenkirchen, Germany 1 3753 https://2009-2017.state.gov/documents/organization/230217.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
afe4b131-19af-4f94-b992-5f2b5c85d094 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_South_Central_Asia_fmtrpt.tsv Turkmenistan TKM Regional Centers - Fiscal Year 2013 Department of Defense Training Consecutive Interpretation Techniques Course N/A U.S. Embassy Ashgabat 1/14/2013 2013-01-14 2/1/2013 2013-02-01 Garmisch-Partenkirchen, Germany 1 3753 https://2009-2017.state.gov/documents/organization/230217.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
ad3b09d1-1006-4855-b889-a4a99354581d 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Dominican Republic DOM IMET-1 - Fiscal Year 2013 Department of State Training Spanish Instrument Refresher AVIATION SCHOOL Dominican Air Force 1/14/2013 2013-01-14 2/1/2013 2013-02-01 AVIATION SCHOOL 2 53176 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
9c292cad-f908-4705-aa16-f83a6e43d3af 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Mexico MEX Section 1004 - Fiscal Year 2013 Department of Defense Training Airborne INFANTRY SCHOOL SEDENA 1/14/2013 2013-01-14 2/1/2013 2013-02-01 INFANTRY SCHOOL 1 4055 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
b83b3fbd-ea25-4d9d-8c38-12d448ca0a53 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Jordan JOR IMET-1 - Fiscal Year 2013 Department of State Training CHEM BOLC-B International STU PREP MANSCEN ARMY TRAINING CENTER CHEMICAL SUPPORT UNIT 1/10/2013 2013-01-10 2/1/2013 2013-02-01 MANSCEN ARMY TRAINING CENTER 1 10290 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
8799ef19-8c65-48fa-a41e-a968538d1db4 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Lebanon LBN FMF - Fiscal Year 2013 Department of State Training ENG BOLC-B International STU PREP MANSCEN ARMY TRAINING CENTER 1st Infantry Brigade 1/10/2013 2013-01-10 2/1/2013 2013-02-01 MANSCEN ARMY TRAINING CENTER 1 8640 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
c665cbd4-6ce4-49cd-9c93-30ea5a9712ea 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Guyana GUY IMET-1 - Fiscal Year 2013 Department of State Training ENG BOLC-B International STU PREP MANSCEN ARMY TRAINING CENTER GUYANA DEFENCE FORCE 1/10/2013 2013-01-10 2/1/2013 2013-02-01 MANSCEN ARMY TRAINING CENTER 1 6890 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
8a8d1c10-768a-492f-9644-b58747b8c97a 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Nigeria NGA PKO - Fiscal Year 2013 Department of State Training PSO Soldier Skills Training - GPOI N/A NIBATT 20 1/7/2013 2013-01-07 2/1/2013 2013-02-01 Jaji, Nigeria 818 38767 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
d4506eaa-e633-48f8-8a02-fc53726d75c3 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Egypt EGY FMF - Fiscal Year 2013 Department of State Training Spinner and Component Overhaul DERCO AEROSPACE C-130 SQUADRON 1/7/2013 2013-01-07 2/1/2013 2013-02-01 DDERWIMI 2 9914 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
d4269cbd-acdf-42da-a7c4-5809bff27849 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_South_Central_Asia_fmtrpt.tsv Afghanistan AFG Section 1004 - Fiscal Year 2013 Department of Defense Training American Language Course GET and SET DLIELC, LACKLAND AFB TX Special Mission Wing 12/17/2012 2012-12-17 2/1/2013 2013-02-01 DLIELC, LACKLAND AFB TX 1 14081 https://2009-2017.state.gov/documents/organization/230217.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
ba5f226e-e1d1-43b5-a2f7-2a581e1733f0 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Senegal SEN IMET-1 - Fiscal Year 2013 Department of State Training ALC Specialized English Training Only DLIELC, LACKLAND AFB TX Navy Support Group 12/3/2012 2012-12-03 2/1/2013 2013-02-01 DLIELC, LACKLAND AFB TX 1 16909 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
1cc2bf08-88ec-4a13-8ca3-fcfb81c70166 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_South_Central_Asia_fmtrpt.tsv Kyrgyzstan KGZ CTFP - Fiscal Year 2013 Department of Defense Training American Language Course General English Training Only DLIELC, LACKLAND AFB TX Special Forces Detachment, MOD 12/3/2012 2012-12-03 2/1/2013 2013-02-01 DLIELC, LACKLAND AFB TX 1 20502 https://2009-2017.state.gov/documents/organization/230217.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
8065e8de-582e-4699-838b-72cf3a24b533 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Gabon GAB IMET-1 - Fiscal Year 2013 Department of State Training American Language Course GET and SET DLIELC, LACKLAND AFB TX Directorate of Transmissions/ Air Force HQ Staff 11/12/2012 2012-11-12 2/1/2013 2013-02-01 DLIELC, LACKLAND AFB TX 1 25181 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
8ba86b4a-f3a9-4049-9c02-45918255b2b7 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Senegal SEN IMET-1 - Fiscal Year 2013 Department of State Training Combined Logistics Captains Career (ALMC) ALU - Leader Courses Material BN 10/3/2012 2012-10-03 2/1/2013 2013-02-01 ARMY LOG MGT COLLEGE - HUNTSVILLE CAMPUS 1 20364 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
5aa5ee7c-0a44-47e0-97ba-3c2f71d5738a 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv Cambodia KHM FMF - Fiscal Year 2013 Department of State Training Combined Logistics Captains Career (ALMC) ALU - Leader Courses Ministry of National Defense 10/3/2012 2012-10-03 2/1/2013 2013-02-01 ARMY LOG MGT COLLEGE - HUNTSVILLE CAMPUS 1 20364 https://2009-2017.state.gov/documents/organization/230211.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
a7371a51-4997-4eb7-a33d-fb671e17f3fe 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Europe_fmtrpt.tsv Macedonia MKD IMET-1 - Fiscal Year 2013 Department of State Training Combined Logistics Captains Career (ALMC) ALU - Leader Courses Command Company, Ranger Battalion, Special Operations Regime 10/3/2012 2012-10-03 2/1/2013 2013-02-01 ARMY LOG MGT COLLEGE - HUNTSVILLE CAMPUS 1 20364 https://2009-2017.state.gov/documents/organization/230213.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
169f6778-0183-49bb-8e9a-26d7814f225b 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Egypt EGY IMET-1 - Fiscal Year 2013 Department of State Training Combined Logistics Captains Career (ALMC) ALU - Leader Courses LOGISTICS 10/3/2012 2012-10-03 2/1/2013 2013-02-01 ARMY LOG MGT COLLEGE - HUNTSVILLE CAMPUS 1 16712 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
f7ece335-cd78-466f-8897-67bc5a1e4f44 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Egypt EGY IMET-1 - Fiscal Year 2013 Department of State Training Combined Logistics Captains Career (ALMC) ALU - Leader Courses LOGISTICS AUTHORITY 10/3/2012 2012-10-03 2/1/2013 2013-02-01 ARMY LOG MGT COLLEGE - HUNTSVILLE CAMPUS 1 20364 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
bcabf260-d09b-4d89-8ca7-879b2978b91d 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_South_Central_Asia_fmtrpt.tsv Afghanistan AFG FMF - Fiscal Year 2013 Department of State Training Combined Logistics Captains Career (ALMC) ALU - Leader Courses MINISTRY OF DEFENSE 10/3/2012 2012-10-03 2/1/2013 2013-02-01 ARMY LOG MGT COLLEGE - HUNTSVILLE CAMPUS 1 19863 https://2009-2017.state.gov/documents/organization/230217.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
10d2f246-230e-479a-a59a-15768219d3cc 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Jamaica JAM IMET-1 - Fiscal Year 2013 Department of State Training Combined Logistics Captains Career (ALMC) ALU - Leader Courses Support & Services Battalion 10/3/2012 2012-10-03 2/1/2013 2013-02-01 ARMY LOG MGT COLLEGE - HUNTSVILLE CAMPUS 1 20364 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
420e9d72-355b-4275-9ae0-066c2122c0a0 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Gambia, The GMB IMET-1 - Fiscal Year 2013 Department of State Training Signal Basic Officer Leader-Branch SIGNAL SCHOOL Gambia Armed Forces Training School, Gambia Armed Forces 9/25/2012 2012-09-25 2/1/2013 2013-02-01 SIGNAL SCHOOL 1 20152 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
2e87c21e-47a5-43c8-a617-9c593a53478b 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Africa_fmtrpt.tsv Sudan, Republic of South SSD IMET-1 - Fiscal Year 2013 Department of State Training Signal Basic Officer Leader-Branch SIGNAL SCHOOL SPLA Signal Command 9/25/2012 2012-09-25 2/1/2013 2013-02-01 SIGNAL SCHOOL 1 17952 https://2009-2017.state.gov/documents/organization/230209.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
88be9183-065d-4944-84ce-a0d0ef21d8f0 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Lebanon LBN IMET-1 - Fiscal Year 2013 Department of State Training Signal Basic Officer Leader-Branch SIGNAL SCHOOL 11th Brigade 9/25/2012 2012-09-25 2/1/2013 2013-02-01 SIGNAL SCHOOL 1 22906 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
2f00ece6-c4ac-4418-b155-a33d60c579bc 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv Thailand THA IMET-1 - Fiscal Year 2013 Department of State Training Maneuver Captains Career USATC 2nd Special Forces Battalion, Royal Thai Army 8/7/2012 2012-08-07 2/1/2013 2013-02-01 USATC 1 25574 https://2009-2017.state.gov/documents/organization/230211.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
5fbb8ae9-61f7-477a-80c8-916f663278af 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv Thailand THA IMET-1 - Fiscal Year 2013 Department of State Training Maneuver Captains Career USATC Royal Thai Army 8/7/2012 2012-08-07 2/1/2013 2013-02-01 USATC 1 25774 https://2009-2017.state.gov/documents/organization/230211.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
5df18823-bcc9-45b5-8e9e-7ddb28dadfae 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Europe_fmtrpt.tsv Azerbaijan AZE IMET-1 - Fiscal Year 2013 Department of State Training Maneuver Captains Career USATC Army Unit 8/7/2012 2012-08-07 2/1/2013 2013-02-01 USATC 1 25774 https://2009-2017.state.gov/documents/organization/230213.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
557dfd77-7336-49c3-bdc0-abd39a9b3617 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Europe_fmtrpt.tsv Moldova MDA IMET-1 - Fiscal Year 2013 Department of State Training Maneuver Captains Career USATC SF Battalion, Moldovan Army 8/7/2012 2012-08-07 2/1/2013 2013-02-01 USATC 1 24433 https://2009-2017.state.gov/documents/organization/230213.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
f335deea-aa6d-46c5-96b7-1f3597bdb3d0 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Iraq IRQ IMET-X - Fiscal Year 2013 Department of State Training Maneuver Captains Career USATC MOD 8/7/2012 2012-08-07 2/1/2013 2013-02-01 USATC 1 25639 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
2466544c-d367-413d-bd7e-c66848a89e69 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Lebanon LBN IMET-1 - Fiscal Year 2013 Department of State Training Maneuver Captains Career USATC 5th Intervention Regiment 8/7/2012 2012-08-07 2/1/2013 2013-02-01 USATC 1 25774 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
e1081b84-fb38-4744-9cc7-f6437caef21d 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Oman OMN IMET-1 - Fiscal Year 2013 Department of State Training Maneuver Captains Career USATC RAO 8/7/2012 2012-08-07 2/1/2013 2013-02-01 USATC 1 25924 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
b333f729-a59b-4150-afe3-f940c668bc19 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Near_East_fmtrpt.tsv Tunisia TUN IMET-1 - Fiscal Year 2013 Department of State Training Maneuver Captains Career USATC Bizerte Military Base 8/7/2012 2012-08-07 2/1/2013 2013-02-01 USATC 1 25374 https://2009-2017.state.gov/documents/organization/230215.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
450d6b3c-2ab0-48a2-9783-7e7b557e680d 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_South_Central_Asia_fmtrpt.tsv Pakistan PAK IMET-1 - Fiscal Year 2013 Department of State Training Maneuver Captains Career USATC School Of Infantry And Tactics, Quetta 8/7/2012 2012-08-07 2/1/2013 2013-02-01 USATC 1 25384 https://2009-2017.state.gov/documents/organization/230217.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
8867ee8c-d98b-4cd8-ae5f-9a521b166cdc 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Brazil BRA IMET-1 - Fiscal Year 2013 Department of State Training Maneuver Captains Career USATC 1st Armor Brigade 8/7/2012 2012-08-07 2/1/2013 2013-02-01 USATC 1 8326 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
aa2048f1-4c7c-4b8d-904d-475f078bd5a0 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Brazil BRA IMET-1 - Fiscal Year 2013 Department of State Training Maneuver Captains Career USATC Military Academy 8/7/2012 2012-08-07 2/1/2013 2013-02-01 USATC 1 8326 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16
c09e42ac-4171-457e-9b1b-375e088e57ed 5c5f3950-1925-417b-b333-fed3650d87ea 2013_2014_Western_Hemisphere_fmtrpt.tsv Uruguay URY IMET-1 - Fiscal Year 2013 Department of State Training Maneuver Captains Career USATC IMAE (INSTITUTE OF BRANCHES AND SPECIALTIES 8/7/2012 2012-08-07 2/1/2013 2013-02-01 USATC 1 25624 https://2009-2017.state.gov/documents/organization/230219.pdf Not checked against source; verify accuracy before use 2014 2019-07-16

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);