training-data

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

41 rows where qa:training_date_first_seen = "2004-06" and "training:start_date" is on date 2003-05-27 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
0fea1080-4e76-4ac1-a4d4-a03c096e84b8 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Africa_fmtrpt.tsv Sierra Leone SLE DOS Africa Region, Sierra Leone, International Military Education and Training (IMET),FY03 INSTRUCTOR TNG COURSE   Army 5/27/2003 2003-05-27 6/13/2003 2003-06-13 FT BENNING GA 31905-5468 1 1658 https://2009-2017.state.gov/documents/organization/34329.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
4bbff1d8-bace-43ed-912a-dfcbc8154f2b 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_East_Asia_and_Pacific_fmtrpt.tsv Philippines PHL East Asia and Pacific Region, Philippines, International Military Education and Training (IMET), FY03 PETROLEUM SUPPLY SPEC   OTQMG, AFP, CGEA, Quezon City 5/27/2003 2003-05-27 8/6/2003 2003-08-06 FT LEE VA 23801-1509 1 8047 https://2009-2017.state.gov/documents/organization/34330.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
b6410ce7-a84d-4a6d-812f-f0601d4de177 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Europe_fmtrpt.tsv Croatia HRV DOS Europe Region, Croatia, International Military Education and Training (IMET),FY03 DRILL SERGEANT   261st Reconnaissance Company 5/27/2003 2003-05-27 7/29/2003 2003-07-29 FT LEONARD WOOD MO 65473-5000 1 719 https://2009-2017.state.gov/documents/organization/34331.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
7bd7337d-8af6-4157-a826-5372d6803a18 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Egypt EGY Near East Region, Egypt, Foreign Military Financing (FMF), FY03 INTL MK46 MOD 5 T/REFRESH   Navy: Torpedo department, Ras El-Teen Naval Base 5/27/2003 2003-05-27 6/23/2003 2003-06-23 KEYPORT, WA 98345-7610 1 18329 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
3c1439ed-0359-49ee-ac5e-bdeddb73bdbd 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Egypt EGY Near East Region, Egypt, Foreign Military Financing (FMF), FY03 INTL MK46 MOD 5 T/REFRESH   Navy: Torpedo department, Ras El-Teen Naval Base 5/27/2003 2003-05-27 6/23/2003 2003-06-23 KEYPORT, WA 98345-7610 1 18329 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
bf88791c-0c2d-4d6b-ac52-d6cafb192cc9 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Israel ISR Near East Region, Israel, Foreign Military Financing (FMF), FY03 AVTRA TH-57 SIMULATOR     5/27/2003 2003-05-27 5/30/2003 2003-05-30 MILTON, FL 32570-6017 1 723 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
93175013-75ad-44df-bd7e-d061331c27ed 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Israel ISR Near East Region, Israel, Foreign Military Financing (FMF), FY03 AVTRA TH-57 SIMULATOR     5/27/2003 2003-05-27 5/30/2003 2003-05-30 MILTON, FL 32570-6017 1 723 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
65c2b673-25b9-4e83-b9bd-d54017c4a7f5 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Israel ISR Near East Region, Israel, Foreign Military Financing (FMF), FY03 AVTRA TH-57 SIMULATOR     5/27/2003 2003-05-27 5/30/2003 2003-05-30 MILTON, FL 32570-6017 1 679 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
58801b5f-3a98-4cf0-86fc-025ce358a922 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Israel ISR Near East Region, Israel, Foreign Military Financing (FMF), FY03 AVTRA TH-57 SIMULATOR     5/27/2003 2003-05-27 5/30/2003 2003-05-30 MILTON, FL 32570-6017 1 679 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
79b49c2d-a2f1-492a-9f34-98de09d63739 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Israel ISR Near East Region, Israel, Foreign Military Financing (FMF), FY03 AVTRA TH-57 SIMULATOR     5/27/2003 2003-05-27 5/30/2003 2003-05-30 MILTON, FL 32570-6017 1 723 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
92fff286-a340-4b51-a104-b93b7e96ffc1 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Israel ISR Near East Region, Israel, Foreign Military Financing (FMF), FY03 AVTRA TH-57 SIMULATOR     5/27/2003 2003-05-27 5/30/2003 2003-05-30 MILTON, FL 32570-6017 1 723 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
20682e02-765e-4d53-add0-b1ea00ec0d74 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Israel ISR Near East Region, Israel, Foreign Military Financing (FMF), FY03 KA/FLT SAFETY/WICHITA,KS     5/27/2003 2003-05-27 5/30/2003 2003-05-30 WICHITA, KS 67206 1 0 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
79ccf3c4-1a15-4da9-9916-191b436b4cf7 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Israel ISR Near East Region, Israel, Foreign Military Financing (FMF), FY03 KA/FLT SAFETY/WICHITA,KS     5/27/2003 2003-05-27 5/30/2003 2003-05-30 WICHITA, KS 67206 1 0 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
e809ff39-cf36-436c-9dd6-1fd213ca8025 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Israel ISR Near East Region, Israel, Foreign Military Financing (FMF), FY03 KA/FLT SAFETY/WICHITA,KS     5/27/2003 2003-05-27 5/30/2003 2003-05-30 WICHITA, KS 67206 1 0 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
e4904fec-9941-4d52-8caf-16928ec1237b 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Israel ISR Near East Region, Israel, Foreign Military Financing (FMF), FY03 WWII/FLT SAFETY/DELAWARE     5/27/2003 2003-05-27 5/28/2003 2003-05-28 NEW CASTLE, DE 19720 1 0 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
9f06f730-4906-4d6c-8f53-0ef399a5347a 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Israel ISR Near East Region, Israel, Foreign Military Financing (FMF), FY03 WWII/FLT SAFETY/DELAWARE     5/27/2003 2003-05-27 5/28/2003 2003-05-28 NEW CASTLE, DE 19720 1 0 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
1f1143b4-9ac3-484a-b3b0-896bb097e22d 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Jordan JOR Near East Region, Jordan, International Military Education and Training (IMET), FY03 MILITARY INTEL OFF TACT   DIR OF MIL INTEL 5/27/2003 2003-05-27 7/16/2003 2003-07-16 FT HUACHUCA AZ 85613-7000 1 16729 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
f8bc016b-8f4b-423d-9e62-101f6d471296 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Jordan JOR Near East Region, Jordan, International Military Education and Training (IMET), FY03 MILITARY INTEL OFF TACT   DIR OF MIL INTEL 5/27/2003 2003-05-27 7/16/2003 2003-07-16 FT HUACHUCA AZ 85613-7000 1 16729 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
4c623b71-ac98-4038-9ced-6c4bae9f7d21 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Jordan JOR Near East Region, Jordan, International Military Education and Training (IMET), FY03 MILITARY INTEL OFF TACT   DIR OF MIL INTEL 5/27/2003 2003-05-27 7/16/2003 2003-07-16 FT HUACHUCA AZ 85613-7000 1 16729 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
8549a80f-ea87-49ed-acd3-28137d1aa7f9 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Jordan JOR Near East Region, Jordan, International Military Education and Training (IMET), FY03 MILITARY INTEL OFF TACT   DIR OF MIL INTEL 5/27/2003 2003-05-27 7/16/2003 2003-07-16 FT HUACHUCA AZ 85613-7000 1 16729 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
feae0f60-e266-4a9e-9cd4-58ccff69aef2 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Jordan JOR Near East Region, Jordan, International Military Education and Training (IMET), FY03 MILITARY INTEL OFF TACT   DIR OF MIL INTEL 5/27/2003 2003-05-27 7/16/2003 2003-07-16 FT HUACHUCA AZ 85613-7000 1 16729 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
4b77f7e5-4a0a-4dab-b46a-f3e623145ca1 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Jordan JOR Near East Region, Jordan, International Military Education and Training (IMET), FY03 MILITARY INTEL OFF TACT   DIR OF MIL INTEL 5/27/2003 2003-05-27 7/16/2003 2003-07-16 FT HUACHUCA AZ 85613-7000 1 16729 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
8c49f944-87d3-4f71-9362-d38cfe9fdcf5 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Jordan JOR Near East Region, Jordan, International Military Education and Training (IMET), FY03 MILITARY INTEL OFF TACT   DIR OF MIL INTEL 5/27/2003 2003-05-27 7/16/2003 2003-07-16 FT HUACHUCA AZ 85613-7000 1 16729 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
e4271e8e-82ac-40f5-bc78-4f3d8554bd87 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Jordan JOR Near East Region, Jordan, International Military Education and Training (IMET), FY03 MILITARY INTEL OFF TACT   DIR OF MIL INTEL 5/27/2003 2003-05-27 7/16/2003 2003-07-16 FT HUACHUCA AZ 85613-7000 1 16729 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
bd162156-2b20-4775-a3dc-b6d0c9c9ebf7 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Lebanon LBN Near East Region, Lebanon, International Military Education and Training (IMET), FY03 UH-1 HELO REPAIRER   Military Police Regiment 5/27/2003 2003-05-27 8/5/2003 2003-08-05 FT RUCKER AL 36362-5000 1 1320 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
56810ee8-8c2e-44e3-8ff5-3f10d65b6c06 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Lebanon LBN Near East Region, Lebanon, International Military Education and Training (IMET), FY03 UH-1 HELO REPAIRER   Beirut Air Base 5/27/2003 2003-05-27 8/5/2003 2003-08-05 FT RUCKER AL 36362-5000 1 1320 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
fe3afc97-3e09-4277-b560-849840aab46f 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Near_East_fmtrpt.tsv Lebanon LBN Near East Region, Lebanon, International Military Education and Training (IMET), FY03 UH-1 HELO REPAIRER   Beirut Air Base 5/27/2003 2003-05-27 8/5/2003 2003-08-05 FT RUCKER AL 36362-5000 1 1320 https://2009-2017.state.gov/documents/organization/34334.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
503545c9-d7d0-4cb6-b9c6-ef55a29aec68 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_South_Asia_fmtrpt.tsv India IND South Asia Region, India, International Military Education and Training (IMET), FY03 INTL ASW JR OFF CRS   INS NIPAT 5/27/2003 2003-05-27 6/20/2003 2003-06-20 SAN DIEGO, CA 92147-5193 1 2479 https://2009-2017.state.gov/documents/organization/34337.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
684588aa-121e-4f06-b628-b7a0c07eed0a 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Antigua And Barbuda ATG DOS Western Hemisphere Region, Antigua And Barbuda, International Military Education and Training (IMET),FY03 DRILL SERGEANT   Special Service Unit 5/27/2003 2003-05-27 7/29/2003 2003-07-29 FT LEONARD WOOD MO 65473-5000 1 4731 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
88258958-58a4-4193-b44a-d34363600f8a 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Chile RCH Western Hemisphere Region, Chile, International Military Education and Training (IMET), FY03 HUMAN RIGHTS INSTRUCTOR   NCO School 5/27/2003 2003-05-27 6/20/2003 2003-06-20 FORT BENNING GA 31905-6245 1 760 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
6c8ce7b9-9625-4fc9-98d0-2fd9f49a0fa9 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Dominica DMA Western Hemisphere Region, Dominica, International Military Education and Training (IMET), FY03 REFRIGERATOR & AIR COND   Coast Guard 5/27/2003 2003-05-27 7/3/2003 2003-07-03 YORKTOWN, VA 23690-5000 1 2928 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
7784eb0b-120b-47a8-9864-69948bb0816e 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Dominican Republic DOM Western Hemisphere Region, Dominican Republic, International Military Education and Training (IMET), FY03 INSTRUCTOR   ARMED FORCES J3 5/27/2003 2003-05-27 6/13/2003 2003-06-13 FORT BENNING GA 31905-6245 1 2108 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
29b5ede0-cfa3-461e-bde1-5d64453164ac 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Dominican Republic DOM Western Hemisphere Region, Dominican Republic, International Military Education and Training (IMET), FY03 INSTRUCTOR   5TH BRIGADE 5/27/2003 2003-05-27 6/20/2003 2003-06-20 FORT BENNING GA 31905-6245 1 2542 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
996e50e9-0643-4030-9c6a-e037f202112b 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Dominican Republic DOM Western Hemisphere Region, Dominican Republic, International Military Education and Training (IMET), FY03 INSTRUCTOR   INSTITUTE OF HUMAN RIGHTS 5/27/2003 2003-05-27 6/20/2003 2003-06-20 FORT BENNING GA 31905-6245 1 2542 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
252ceb31-4c86-4d04-b421-2bb6b65b29ef 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Mexico MEX Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY03 INSTRUCTOR   Escuela Superior de Guerra, Mexico, D.F. 5/27/2003 2003-05-27 6/20/2003 2003-06-20 FORT BENNING GA 31905-6245 1 519 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
85a20709-48e1-43d2-9be0-c893d00af1c5 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Nicaragua NIC DOD Western Hemisphere Region, Nicaragua, Non-Security Assistance, Combatant Command,FY03 OCONUS SEM FAMILIARIZATION     5/27/2003 2003-05-27 6/1/2003 2003-06-01 YORKTOWN VA 23690 1 0 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
139f1d59-1f98-42f9-ace9-8c567b13019d 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Peru PER Western Hemisphere Region, Peru, Drug Interdiction and Counter-Drug Activities, Section 1004, FY03 INSTRUCTOR   PE NAT POLICE-DIROPANDRO 5/27/2003 2003-05-27 6/20/2003 2003-06-20 FORT BENNING GA 31905-6245 1 519 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
fb248999-1b4a-4413-9f6b-788ccfb1ec1e 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Peru PER Western Hemisphere Region, Peru, Drug Interdiction and Counter-Drug Activities, Section 1004, FY03 INSTRUCTOR   PE NAT POLICE-DIROPANDRO 5/27/2003 2003-05-27 6/20/2003 2003-06-20 FORT BENNING GA 31905-6245 1 519 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
4761c403-19db-4e62-8154-34274dd73919 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Peru PER Western Hemisphere Region, Peru, Drug Interdiction and Counter-Drug Activities, Section 1004, FY03 INSTRUCTOR   PE NAT POLICE-DIROPANDRO 5/27/2003 2003-05-27 6/20/2003 2003-06-20 FORT BENNING GA 31905-6245 1 519 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
f8cf1488-271b-41f6-8e3d-dbfb9593bd10 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Peru PER DOD Western Hemisphere Region, Peru, Foreign Assistance Act Draw Down, Section 506,FY03 ORIENT TOUR TCA PROGRAM   NAVY-COMMANDING GENERAL 5/27/2003 2003-05-27 5/31/2003 2003-05-31   1 0 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
f5ab7c1d-8caf-4fa5-b109-1557cfbfec45 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Suriname SUR DOS Western Hemisphere Region, Suriname, International Military Education and Training (IMET),FY03 NAMP INDOC   HEAD OF LOGISTICS SECTION OF THE NAVY 5/27/2003 2003-05-27 8/1/2003 2003-08-01   1 6335 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 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]);