training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
25 rows where training:country_iso_3166_1 = "MEX" and "training:end_date" is on date 2008-09-28 sorted by qa:training_start_date
This data as json, CSV (advanced)
Suggested facets: training:total_cost, training:start_date (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
a8513e96-a6b7-47c8-b4c4-6fd069a84b39 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
71ca0c4a-569c-42c8-bf21-c6dcda9f3f3e | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
5e50bdec-9c68-41bc-98e0-adb802f320b1 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e75536ef-cfa9-4a5f-9f02-65d34588ad1a | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
8ac9d971-33f8-4dc7-87c4-6676b64dabe8 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
d8468d06-ad0b-4c5b-8af8-10eb17a4d512 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
dc92e913-6c37-4b31-989b-8fd781b246b0 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
c30c3126-71b0-41ed-8813-e595ab7f3812 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
9b234e7a-a5d3-45db-805d-e6a5b75ca572 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
bf97a964-1a0d-43bd-96a2-e942c8b13ca6 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f5c24639-80e5-4625-9016-75d9d789dbf1 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
dfa74993-98cf-484d-84df-9b9523ce0128 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
966acd2b-3d6d-47e0-aea5-26353eb8d658 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
dafe8fec-482e-4d1d-9473-e545d7011d88 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
8e25de0f-94e8-4241-880d-a36699e56c69 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
043d38c2-07f9-4d8d-b499-2dff625ac647 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e5f1b33f-14b9-4e2b-837f-378ef56c1f6e | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
d705a524-a3f6-43a9-98f7-2d8180b67390 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
72ed10aa-dc0e-4ca2-9cda-0fadfced9fd5 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
646a0ce4-b1fe-494f-8cc9-6b1f7ef058f1 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
8da01b33-8aa5-4c06-bb4f-124ceff6d09f | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
92e58a4f-13ed-4d98-81d6-734073e8f0a4 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
f3336fad-6793-44ce-8120-90000fc14d7e | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
e2c17144-c85f-4543-a245-bffd6acfdc52 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
0dd46453-069e-42bd-9f23-4a84fe729d1c | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2008 DoD Training | COASTAL SAR OPS - MTT | US unit not specified in 2008-2009 report | SEMAR | 9/20/2008 | 2008-09-20 | 9/28/2008 | 2008-09-28 | VARIOUS | 1 | 25118 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 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]);