training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
152 rows where "training:end_date" is on date 2012-04-27 sorted by training:status:admin
This data as json, CSV (advanced)
qa:training_date_first_seen (date) 1 ✖
- -4707-05-29 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
db418c71-f8a7-441e-80ee-23df8a6de48d | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | GPOI - Fiscal Year 2012 Department of State Training | UN Civil-Military CoordiNation Officer’s Course (CIMIC) | UNK | 505 SRG, PAF | 4/16/2012 | 2012-04-16 | 4/27/2012 | 2012-04-27 | Camp O’Donnell, Philippines | 3 | 0 | https://2009-2017.state.gov/documents/organization/213462.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
de3b7d2f-192e-4638-bf0d-c68f68a7c9fa | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | Regional Centers - Fiscal Year 2012 Department of Defense Training | Defense Policy Course at the Inter American Defense College | CHDS | Policía Nacional de la República Dominicana | 4/9/2012 | 2012-04-09 | 4/27/2012 | 2012-04-27 | Washington, DC, United States | 1 | 0 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
df1d5323-f2dd-4667-80b2-d7111c06bcf9 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | GPOI - Fiscal Year 2012 Department of State Training | UN Civil-Military CoordiNation Officer’s Course (CIMIC) | UNK | NISF, PN | 4/16/2012 | 2012-04-16 | 4/27/2012 | 2012-04-27 | Camp O’Donnell, Philippines | 1 | 0 | https://2009-2017.state.gov/documents/organization/213462.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
e1204721-76e8-41ec-81c8-7afe1a811dd3 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | GPOI - Fiscal Year 2012 Department of State Training | UN Civil-Military CoordiNation Officer’s Course (CIMIC) | UNK | DC, TRADOC, PA | 4/16/2012 | 2012-04-16 | 4/27/2012 | 2012-04-27 | Camp O’Donnell, Philippines | 1 | 0 | https://2009-2017.state.gov/documents/organization/213462.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
e2975c4c-a7ed-4220-ba3a-8d2c1e5bd5c9 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Perspectives on Homeland Security and Defense | CHDS | Mexican Navy | 4/16/2012 | 2012-04-16 | 4/27/2012 | 2012-04-27 | Washington, DC, United States | 1 | 5250 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
e3d8dbe5-399d-45fb-9966-c464f8cce09a | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Regional Centers - Fiscal Year 2012 Department of Defense Training | Defense Policy Course at the Inter American Defense College | CHDS | Inter-American Defense College | 4/9/2012 | 2012-04-09 | 4/27/2012 | 2012-04-27 | Washington, DC, United States | 3 | 0 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
e7a31056-0126-447d-8ab0-970dbe1d124c | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_East_Asia_and_Pacific_fmtrpt.tsv | Thailand | THA | CTFP - Fiscal Year 2012 Department of Defense Training | Maritime Terrorism | CENTER FOR CIVIL-MILITARY RELATIONS MONTEREY CA | Central Investigation Bureau, Royal Thai Police | 4/23/2012 | 2012-04-23 | 4/27/2012 | 2012-04-27 | CIVIL-MILITARY RELATIONS NPS CENTER FOR MONTEREY CA | 1 | 10106 | https://2009-2017.state.gov/documents/organization/213462.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
e86ae9b7-0880-4efb-a869-fb50b1a4cfcd | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_East_Asia_and_Pacific_fmtrpt.tsv | Mongolia | MNG | GPOI - Fiscal Year 2012 Department of State Training | UN Logistics Officers’ Course (UNLOG) | UNK | Staff | 4/9/2012 | 2012-04-09 | 4/27/2012 | 2012-04-27 | Malaysian PSOTC, Port Dickson, Malaysia | 1 | 0 | https://2009-2017.state.gov/documents/organization/213462.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
ebd471dc-44e8-4fc7-9dd5-9aa09bf15425 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Regional Centers - Fiscal Year 2012 Department of Defense Training | Defense Policy Course at the Inter American Defense College | CHDS | Colombian Air Force | 4/9/2012 | 2012-04-09 | 4/27/2012 | 2012-04-27 | Washington, DC, United States | 1 | 0 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
ec096b6b-3a5a-43fe-a8ae-cc44699a8768 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | GPOI - Fiscal Year 2012 Department of State Training | UN Civil-Military CoordiNation Officer’s Course (CIMIC) | UNK | AFPPKOC | 4/16/2012 | 2012-04-16 | 4/27/2012 | 2012-04-27 | Camp O’Donnell, Philippines | 5 | 0 | https://2009-2017.state.gov/documents/organization/213462.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
ed46795f-bdd0-422d-8b97-1bc0af358fc8 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Europe_fmtrpt.tsv | Azerbaijan | AZE | Regional Centers - Fiscal Year 2012 Department of Defense Training | Azerbaijan MoD-Parliamentary Relations II | MC | Border Guard | 4/25/2012 | 2012-04-25 | 4/27/2012 | 2012-04-27 | Baku, Azerbaijan | 1 | 2756 | https://2009-2017.state.gov/documents/organization/213464.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
ed584e0a-5545-4171-9833-3dbae537f519 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Peru | PER | CTFP - Fiscal Year 2012 Department of Defense Training | Perspectives on Homeland Security and Defense | CHDS | Instituto de Defensa Legal | 4/16/2012 | 2012-04-16 | 4/27/2012 | 2012-04-27 | Washington, DC, United States | 1 | 5006 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
ee6110bd-5f66-4b02-b7dd-e15bf368a59d | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Maritime Terrorism | CENTER FOR CIVIL-MILITARY RELATIONS MONTEREY CA | SEMAR | 4/23/2012 | 2012-04-23 | 4/27/2012 | 2012-04-27 | CIVIL-MILITARY RELATIONS NPS CENTER FOR MONTEREY CA | 1 | 8456 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
f52ddf51-c508-4036-9c70-85d70524a46e | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | GPOI - Fiscal Year 2012 Department of State Training | UN Civil-Military CoordiNation Officer’s Course (CIMIC) | UNK | 5MIB, 5ID, PA | 4/16/2012 | 2012-04-16 | 4/27/2012 | 2012-04-27 | Camp O’Donnell, Philippines | 1 | 0 | https://2009-2017.state.gov/documents/organization/213462.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
f72b01ba-f1d8-4110-b380-9847bd3cb230 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | CTFP - Fiscal Year 2012 Department of Defense Training | Perspectives on Homeland Security and Defense | CHDS | Policía Federal | 4/16/2012 | 2012-04-16 | 4/27/2012 | 2012-04-27 | Washington, DC, United States | 1 | 5250 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
fd71a942-3da5-4360-8ce2-5e0bf1c71a9e | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET-1 - Fiscal Year 2012 Department of State Training | Advanced English Language INSTR Course (AELIC) | DLIELC, LACKLAND AFB TX | MEDCOM | 1/16/2012 | 2012-01-16 | 4/27/2012 | 2012-04-27 | DLIELC, LACKLAND AFB TX | 1 | 20146 | https://2009-2017.state.gov/documents/organization/213466.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
fe6529bf-274d-4939-bcc5-52dd8aa21b94 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Regional Centers - Fiscal Year 2012 Department of Defense Training | Defense Policy Course at the Inter American Defense College | CHDS | Colombian Army | 4/9/2012 | 2012-04-09 | 4/27/2012 | 2012-04-27 | Washington, DC, United States | 2 | 0 | https://2009-2017.state.gov/documents/organization/213470.pdf | Not checked against source; verify accuracy before use | 2013 | 2019-07-16 |
ff420589-e319-4ae6-b2f8-6641dc95dbe2 | 4faaea83-ee29-409a-8859-20f1be2b6c95 | 2012_2013_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | GPOI - Fiscal Year 2012 Department of State Training | UN Civil-Military CoordiNation Officer’s Course (CIMIC) | UNK | 203 BDE, 2ID, PA | 4/16/2012 | 2012-04-16 | 4/27/2012 | 2012-04-27 | Camp O’Donnell, Philippines | 1 | 0 | https://2009-2017.state.gov/documents/organization/213462.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]);