training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
17 rows where training:country_iso_3166_1 = "MEX" and "training:start_date" is on date 2009-02-16 sorted by training:start_date
This data as json, CSV (advanced)
Suggested facets: training:recipient_unit, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7f4a7493-2a77-45da-8f37-737114482981 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - FY 2009 DoS Training | CAPTAINS CAREER COMMON CORE | US unit not specified in 2009-2010 report | SEDENA | 2/16/2009 | 2009-02-16 | 2/27/2009 | 2009-02-27 | ARMOR SCHOOL | 1 | 462 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
b3f3dfb7-56c4-484c-b16d-378bb934f9dc | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | SEDENA | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | MEXICO (IN COUNTRY TRAINING) | 1 | 77646 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
818aa9d6-4c34-4162-80db-dc7ada5a3ee0 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | SEDENA | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | 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 |
6acb67ee-55b6-4402-a440-1fad7f11f6ff | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | SEMAR | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | 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 |
c438e44a-c15e-4679-81a7-fcd4141540ef | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | SEDENA | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | 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 |
a7bdef5a-ac5d-40dc-a4ab-7373ce406587 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | SEDENA | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | 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 |
330bbdd1-3596-4c59-a36c-8ebb42c8f8a1 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | SEMAR | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | 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 |
34360d3b-9c81-4f4c-89e1-6a295a6ee1ec | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | CIVILIAN AUTHORITY | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | 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 |
bfb23294-442d-42bc-8a8d-4168c44aec56 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | CIVILIAN AUTHORITY | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | 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 |
55a3dc22-0de7-4fb2-9ada-b4a5553196d1 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | SEDENA | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | 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 |
ecd7e268-5575-4409-8ada-2112e6d2e829 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | CIVILIAN AUTHORITY | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | 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 |
3136b2a9-8ffb-447e-a7aa-020be25b67a2 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | CIVILIAN AUTHORITY | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | 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 |
0b4722fa-2931-47f9-ab15-80703779b1a6 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | CIVILIAN AUTHORITY | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | 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 |
b2a8f4ac-b057-4ddf-be01-340fa08c6f30 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | SEDENA | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | 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 |
40d90e4c-c7fe-4fcd-911a-1e42c1bd2bc6 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | SEDENA | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | 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 |
9aade887-5e7a-4c8a-8151-64441cc9bdd6 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | MET CIV-MILITARY RELATIONS | US unit not specified in 2009-2010 report | SEDENA | 2/16/2009 | 2009-02-16 | 2/20/2009 | 2009-02-20 | 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 |
a779d068-69b6-4ab7-9e74-337dfa2dda5a | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | SEDENA | 2/16/2009 | 2009-02-16 | 4/17/2009 | 2009-04-17 | DLIELC, LACKLAND AFB TX | 1 | 8884 | 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]);