training-data

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

11 rows where "training:end_date" is on date 2003-05-20 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
31232f4c-7abb-4df9-9d42-dca02a70917d 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Mexico MEX Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY03 COLLINS ADF-60   3rd Electr Maint Echelon,BAM#13, Chihuahua, Chihuahua 5/1/2003 2003-05-01 5/20/2003 2003-05-20 LACKLAND AFB, TX 78236-5706 1 485 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
069c19b1-9a60-4f90-8c43-d1ba1155c9c1 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Mexico MEX Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY03 COLLINS ADF-60   3rd Electr Maint Eche, BAM#5, Zapopan, Jalisco 5/1/2003 2003-05-01 5/20/2003 2003-05-20 LACKLAND AFB, TX 78236-5706 1 485 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
7a188d20-9c47-4712-8a2d-c28d2262afd8 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Mexico MEX Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY03 COLLINS ADF-60   3rd Electr Maint Echelon,BAM#6, Tuxtla Gutierrez, Chiapas 5/1/2003 2003-05-01 5/20/2003 2003-05-20 LACKLAND AFB, TX 78236-5706 1 485 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
da733722-878b-4784-8ba7-213663abd0a2 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_South_Asia_fmtrpt.tsv Bangladesh BGD DOD South Asia Region, Bangladesh, Miscellaneous, DOD/DOS Non-Security Assistance,FY03 Balance Buffalo 03-1 ODA 125 1st Para Commando BN Bangladesh Navy Bangladesh Air Force 4/20/2003 2003-04-20 5/20/2003 2003-05-20 Chittagong, BG 60 80000 https://2009-2017.state.gov/documents/organization/34337.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
ed86ddc0-de83-4e46-8e3a-da7078a07fbc 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_South_Asia_fmtrpt.tsv Bangladesh BGD DOD South Asia Region, Bangladesh, Non-Security Assistance, Combatant Command,FY03 JCET 1/1 SFG 1st PARA COMMANDO BATTALION (60) BANGLADESH AIR FORCE HQ (10) NAVY BNS ISHA KHAN, CHITTAGONG 4/12/2003 2003-04-12 5/20/2003 2003-05-20 COXS BAZAR 80 473896 https://2009-2017.state.gov/documents/organization/34337.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
a075c355-b925-4df2-bf1f-d613eb5c0ff1 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Colombia COL Western Hemisphere Region, Colombia, Drug Interdiction and Counter-Drug Activities, Section 1004, FY03 UH-60 AVR QUAL - SPANISH   COLAF, AIR COMBAT COMMAND NO. 5, RIONEGRO 3/24/2003 2003-03-24 5/20/2003 2003-05-20 FT RUCKER AL 36362-5000 1 67662 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
e1ba9131-935f-448f-b759-0b2f61b6de62 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Colombia COL Western Hemisphere Region, Colombia, Drug Interdiction and Counter-Drug Activities, Section 1004, FY03 UH-60 AVR QUAL - SPANISH   COLAF, AIR COMBAT COMMAND NO. 4, MELGAR 3/24/2003 2003-03-24 5/20/2003 2003-05-20 FT RUCKER AL 36362-5000 1 67662 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
9257806f-be3c-488b-bdde-c6e8b82e7524 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Colombia COL Western Hemisphere Region, Colombia, International Narcotics and Law Enforcement (INL), FY03 UH-60 AVR QUAL - SPANISH   Colombian National Police, Air Service 3/24/2003 2003-03-24 5/20/2003 2003-05-20 FT RUCKER AL 36362-5000 1 67662 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
a8323567-12d5-4ec5-8115-613339f3c62b 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_Western_Hemisphere_fmtrpt.tsv Colombia COL Western Hemisphere Region, Colombia, International Narcotics and Law Enforcement (INL), FY03 UH-60 AVR QUAL - SPANISH   Colombian National Police, Air Service 3/24/2003 2003-03-24 5/20/2003 2003-05-20 FT RUCKER AL 36362-5000 1 67662 https://2009-2017.state.gov/documents/organization/34338.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
4b788fdb-011e-4200-aa9b-bf8fcf30bd3b 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_East_Asia_and_Pacific_fmtrpt.tsv Malaysia MYS East Asia and Pacific Region, Malaysia, International Military Education and Training (IMET), FY03 PA OFFICER QUAL CRS   Staff Officer Grade 2 (Public Relations), Army Training Command HQ 3/18/2003 2003-03-18 5/20/2003 2003-05-20 FT GEORGE G. MEADE MD 20755-5620 1 7304 https://2009-2017.state.gov/documents/organization/34330.pdf Not checked against source; verify accuracy before use 2004-06 2019-07-16
83cb0915-d4b0-400e-a3f6-253ae6f763c7 04ac6784-aa03-4c20-978e-960d2d59ca02 2003_2004_South_Asia_fmtrpt.tsv Bangladesh BGD South Asia Region, Bangladesh, International Military Education and Training (IMET), FY03 PA OFFICER QUAL CRS   Military Intelligence Directorate, Army HQ 3/18/2003 2003-03-18 5/20/2003 2003-05-20 FT GEORGE G. MEADE MD 20755-5620 1 7655 https://2009-2017.state.gov/documents/organization/34337.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]);