training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
19 rows where qa:training_group = "2001_2002_Western_Hemisphere_fmtrpt.tsv" and "training:start_date" is on date 2001-03-19 sorted by training:start_date descending
This data as json, CSV (advanced)
Suggested facets: training:country, training:country_iso_3166_1, training:program, training:course_title, training:recipient_unit, qa:training_end_date, training:end_date, training:location, training:quantity, training:total_cost, training:start_date (date), training:end_date (date), qa:training_date_scraped (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2f3e91b7-2138-42d7-a565-572c7fa83d45 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | DoS Western Hemisphere Region, Argentina, International Military Education and Training (IMET), FY01 | DEFENSE ADV TRAFFIC MGT | Army Transportation Directorate | 3/19/01 | 2001-03-19 | 3/30/01 | 2001-03-30 | FT EUSTIS VA 23604-5481 | 1 | 272 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
f19e1ca4-7309-4614-be65-a0a5b02d6153 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | DoS Western Hemisphere Region, Brazil, International Military Education and Training (IMET), FY01 | COMBINED LOG CPT CAREER | ESAO-RJ | 3/19/01 | 2001-03-19 | 5/1/01 | 2001-05-01 | FT LEE VA 23801-1705 | 1 | 1227 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
bcf95665-7382-4bd4-bbe7-bd1195873ac9 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Western Hemisphere Region, Colombia, International Narcotics and Law Enforcement (INL), FY01 | AN/ARC 164 UHF RADIO | CNP AIR SERVICE | 3/19/01 | 2001-03-19 | 4/3/01 | 2001-04-03 | LACKLAND AFB, TX 78236-5706 | 1 | 285 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
2edcb929-acba-437e-bae8-0a3d7e3c83c6 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Western Hemisphere Region, Ecuador, International Military Education and Training (IMET), FY01 | C-130B/E/H PROPELLER TECHN | First Air Zone, 11th Wing | 3/19/01 | 2001-03-19 | 4/27/01 | 2001-04-27 | LACKLAND AFB, TX 78236-5706 | 1 | 3229 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
b1f5018b-c5cd-43b3-9bf7-366f84a73acb | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Western Hemisphere Region, Ecuador, International Military Education and Training (IMET), FY01 | C-130B/E/H PROPELLER TECHN | First Air Zone, 11th Wing | 3/19/01 | 2001-03-19 | 4/27/01 | 2001-04-27 | LACKLAND AFB, TX 78236-5706 | 1 | 3229 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
c3b1f4dc-86bf-41d7-b30f-9b536b6cdeee | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | El Salvador | SLV | DoS Western Hemisphere Region, El Salvador, International Military Education and Training (IMET), FY01 | ENGINEER OFF CPT CAREER | ENGINEER BGD | 3/19/01 | 2001-03-19 | 7/24/01 | 2001-07-24 | FT LEONARD WOOD MO 65473-5000 | 1 | 11251 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
9db152c8-862c-4f74-8e78-0ffb7aa664f9 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | Western Hemisphere Region, Honduras, International Military Education and Training (IMET), FY01 | ENGINEER OFF CPT CAREER | FIRST ENGINEER BATTALION, SIGUATEPEQUE, COMAYAGUA | 3/19/01 | 2001-03-19 | 7/24/01 | 2001-07-24 | FT LEONARD WOOD MO 65473-5000 | 1 | 11351 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
1e049918-e07c-4060-9699-e570fe8f8296 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | Western Hemisphere Region, Honduras, International Military Education and Training (IMET), FY01 | HUMAN RIGHTS INSTRUCTOR | 2ND INFANTERY BATTALION , TAMARA, FRANCISCO MORAZAN | 3/19/01 | 2001-03-19 | 4/6/01 | 2001-04-06 | FORT BENNING GA 31905-6245 | 1 | 2200 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
51793d84-e6fa-4be0-8c96-8d9e731e6424 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | Western Hemisphere Region, Honduras, International Military Education and Training (IMET), FY01 | HUMAN RIGHTS INSTRUCTOR | LICEO MILITAR DEL NORTE, SAN PEDRO SULA, CORTES | 3/19/01 | 2001-03-19 | 4/6/01 | 2001-04-06 | FORT BENNING GA 31905-6245 | 1 | 2200 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
5a1181c2-84ae-4dd6-b9b2-441ffe3f8101 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | Western Hemisphere Region, Honduras, International Military Education and Training (IMET), FY01 | TATS RADIO OPERATOR-MAINT | 3RD INFANTRY BATALLION , NACO, CORTES | 3/19/01 | 2001-03-19 | 5/24/01 | 2001-05-24 | FT GORDON GA 30905-5154 | 1 | 6086 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
9bff755f-5685-4442-9b2e-66c5cf0f0006 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Jamaica | JAM | Western Hemisphere Region, Jamaica, International Military Education and Training (IMET), FY01 | RULE OF LAW&DISCP MIL OPS | Navy | 3/19/01 | 2001-03-19 | 3/24/01 | 2001-03-24 | STENNIS SPACE CENTER, MS 39529-7099 | 1 | 495 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
e160ace6-3416-48fa-8ae8-795fc8cb2048 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Jamaica | JAM | Western Hemisphere Region, Jamaica, International Military Education and Training (IMET), FY01 | RULE OF LAW&DISCP MIL OPS | Navy | 3/19/01 | 2001-03-19 | 3/24/01 | 2001-03-24 | STENNIS SPACE CENTER, MS 39529-7099 | 1 | 495 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
98730392-9a93-43ef-9c15-99189818d2bb | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DoS Western Hemisphere Region, Mexico, Exchange Training, FY01 | MTT INTRO TO OPS INFO MGMT | Navy | 3/19/01 | 2001-03-19 | 3/23/01 | 2001-03-23 | Mexico | 30 | 0 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
a6d5757d-6f90-4dd6-abf0-44991059217d | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | C-130B/E/H PROPELLER TECHN | 302nd Air Sq., Santa Lucia, Estado de Mexico | 3/19/01 | 2001-03-19 | 4/27/01 | 2001-04-27 | LACKLAND AFB, TX 78236-5706 | 1 | 1481 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
8c03f7ba-55ed-48c0-9f36-bccc1c1e9a10 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | C-130B/E/H PROPELLER TECHN | 302nd Air Sq., Santa Lucia, Estado de Mexico | 3/19/01 | 2001-03-19 | 4/27/01 | 2001-04-27 | LACKLAND AFB, TX 78236-5706 | 1 | 1481 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
2703154a-2532-48a2-8e89-04f054eb527f | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | COMBINED LOG CPT CAREER | 1st Infantry Brigade, S | 3/19/01 | 2001-03-19 | 5/1/01 | 2001-05-01 | FT LEE VA 23801-1705 | 1 | 1227 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
99b9a0fc-ddad-4713-941b-c51658911924 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY01 | SPECIALIZED ENG LANG TNG | GAFE, Parachutist Brigade, Mexico, D.F. | 3/19/01 | 2001-03-19 | 5/18/01 | 2001-05-18 | SAN ANTONIO TX 78236-5259 | 1 | 3058 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
fc5949e0-95a8-4323-9175-40f10fce9c4e | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | DoS Western Hemisphere Region, Nicaragua, International Military Education and Training (IMET), FY01 | GENERAL ENGLISH ONLY | Chief, Security, Engineering Detachment, Nicaraguan Army | 3/19/01 | 2001-03-19 | 7/6/01 | 2001-07-06 | LACKLAND AFB, TX 78236 | 1 | 9230 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 2019-07-16 | |
9a238da2-16de-43bf-afa7-52eda0d1fb86 | 03221d24-92ea-4ccc-a6a2-bd88dbfcd9fb | 2001_2002_Western_Hemisphere_fmtrpt.tsv | St Kitts And Nevis | KNA | DoS Western Hemisphere Region, St Kitts And Nevis, International Military Education and Training (IMET), FY01 | STOREKEEPER A | COAST GUARD | 3/19/01 | 2001-03-19 | 5/18/01 | 2001-05-18 | PETALUMA, CA 94952-5000 | 1 | 4207 | https://2009-2017.state.gov/documents/organization/10970.pdf | Not checked against source; verify accuracy before use | 2002-03 | 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]);