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_date_first_seen = 2014 and training:start_date = "2013-02-27" sorted by training:start_date descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
b80755ad-ef2e-48a1-842a-efd4535de3f5 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2013 Department of State Training | Military Intelligence BOLC-Branch | INTELLIGENCE SCHOOL | PRESIDENTIAL GUARDS | 2/27/2013 | 2013-02-27 | 6/25/2013 | 2013-06-25 | INTELLIGENCE SCHOOL | 1 | 34312 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
521ed293-95c8-436b-ba7f-d2275d2912f7 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | BACOA | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1150 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
1ce03e7e-9595-4db1-afdb-30ff4b9c73cd | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | BAMAM | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1150 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
1a3babd8-feaf-4cab-8bbe-b7179973521e | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | BAS03 | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1155 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
3e8a1e9b-35df-4152-85ca-843894e021e0 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | BASAM | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1150 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
11237f45-ee46-4dea-81b0-9de0e8f97103 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | BASCO | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1150 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
34336bfb-2969-4101-b385-baa8b51afa0b | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | BASRO | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1155 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
3c20de6d-537d-428d-815e-af780c9740b1 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | BFER2 | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1150 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
c62db90e-b3e8-49d7-86da-45efcab50419 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | BIAHE | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1150 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
30620681-054f-4022-9eb9-257db98b3bdb | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | BIJUL | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1150 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
9b9396cf-b2b0-466f-847a-e40769f03190 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | BISER | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1150 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
38e9d001-5f5c-4c5b-b443-2b768b38635b | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | BITEC1 | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1150 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
fb0ab9de-f154-4e90-85d3-c4866841d593 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | BPM13 | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1155 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
7c6d361a-2050-4a71-ad67-cb0581556734 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | BPM15 | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1155 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
5351869b-45f0-479a-a271-d047e8fb3272 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | COESE | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1150 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
3322420f-22e6-4840-8a31-2b4fc0329cb3 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | DIVISION 8TH | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 2 | 2310 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
19e07a8c-e223-4ab5-96e3-d58b0a4c4756 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | FUCAD | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 1155 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
05b7100b-4b60-47b1-b2e2-a32f1ef9a3f3 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - Fiscal Year 2013 Department of State Training | Human Rights Instructor | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | COLOMBIAN POLICE, ANTINARCOTICS DIRECTORATE | 2/27/2013 | 2013-02-27 | 3/27/2013 | 2013-03-27 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 2 | 1576 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
c5cda707-07a4-4fa9-8058-408f97d40321 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Peru | PER | Section 1004 - Fiscal Year 2013 Department of Defense Training | Introductory Air Intelligence | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | NAVY | 2/27/2013 | 2013-02-27 | 4/17/2013 | 2013-04-17 | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND AFB, TX | 1 | 9165 | 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
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]);