training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
24 rows where training:country_iso_3166_1 = "MEX" and "training:start_date" is on date 2009-02-02 sorted by training:start_date descending
This data as json, CSV (advanced)
Suggested facets: training:total_cost, training:end_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
aad73cd1-30a3-4d56-8365-d8c9fd227772 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
06fed22d-bee8-401d-9320-6821586ee15e | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
a6438214-9e83-4916-b75b-ec14bbc11f0d | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
9f89c9dd-ca0d-45b5-a60c-e45644ef8fbe | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
46eeaa1c-ab78-473d-91d2-26868254c693 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
11cea59e-99a0-42cf-bc8a-cac9c7e08dcb | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
81d60939-e72b-4f99-a2ee-578a9fefec38 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
e96cfa43-a5d7-464a-b790-924acea97c82 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
81f64fc4-9450-491b-b0ef-6f2df781de3f | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
36dcaa43-869a-42f2-b133-8400292202b9 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
fc3bb2bb-aca5-487c-9aa2-375f44200635 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
7745ed7b-5e53-4d74-bd5d-5ac0e084e0c7 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
93d4a350-5cff-43b5-8378-c72864bc783b | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
50509719-f83d-41a6-8108-44059b14183e | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
04b910cc-e908-428e-8f80-cdebe44d29a3 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
fbbb21af-143c-4a74-99f2-239b488ca4e4 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
161cf695-8c3c-4cab-b045-0255f5236cdb | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
75dc6fa4-01cf-40c3-b4e4-ebf6657090a9 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
73a4e2fa-8bbd-4f1d-9187-9215f102e8d0 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 22562 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
b4d75038-ff58-4ef0-b238-f9b486cb63df | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
cf6517ad-3279-4f68-aa31-1d206857dd65 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
620b1e5e-a67c-4958-8a7d-b868a8b3f174 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
263f83e1-060e-4d2b-9106-7d6e84c87c35 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
bb0db3eb-657c-4193-9df5-4b075fa2c9ea | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MTT COASTAL SAR OPS | US unit not specified in 2009-2010 report | SEMAR | 2/2/2009 | 2009-02-02 | 2/6/2009 | 2009-02-06 | MEXICO (IN COUNTRY TRAINING) | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 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]);