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:start_date" is on date 2009-04-27 sorted by training:start_date descending
This data as json, CSV (advanced)
Suggested facets: training:course_title, training:recipient_unit, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
b363e8e7-cdd9-4dab-b8f1-31b0f3a50c5a | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
5318755b-1308-4b4d-8a3d-a7d6cdcd8217 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
a00da0b7-d411-4b21-8747-3964d79f67e9 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 13497 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
3a00ea39-641a-475e-82e7-a3d5705e8ca7 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
baeeece0-2071-4e10-b9f4-17db51f700e0 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
d60e9feb-28b3-48d5-9f53-3c65939c8588 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
ded2a4a8-2714-4d8b-819e-03aed202b49f | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
99b8eb5a-e645-4621-8f8e-e94dbdd0d8f5 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
26f6be05-6d50-4082-a402-37017a07fa82 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
2183a372-4c8e-4648-84d2-07d85ab1f6bf | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
22ddb8be-bd45-4459-a990-1767ff75c60d | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
7b8d98ba-6bfe-4555-a4a5-ea1106cd6116 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
f5b2d570-feb2-4dad-9e7a-6ecdf54a8e2f | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
b62a1231-4a78-46d7-b641-a5ad55df653f | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
af9f150d-17d9-4ee3-8478-3ae3b35b79ea | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
be9e5640-ebdf-442a-8ff8-811d65ca78f2 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
f18c66d7-792c-49c8-a055-fb378a8e8cba | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
3e804db7-248c-4a6e-8a08-abede5cc7e35 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
acab6802-291e-4ffd-bf33-d337908b1998 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
670aa838-c783-40de-ae3f-104939ca4fd0 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
f597c30f-09ca-4982-ba1a-92f79d54b501 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
4e0a45c5-2686-4137-a09c-b2f5bd7b2d8a | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
ce3bb041-331d-493c-837c-c653b0e3eeda | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
c1bc0609-6aff-430b-bdd1-b0360576a170 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS DRST RES | US unit not specified in 2009-2010 report | SEDENA | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 0 | https://2009-2017.state.gov/documents/organization/156002.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
8d9cb49b-41ac-4135-bfb7-e98d2a48b4bb | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - FY 2009 DoD Training | CRT LIFE SAV SKLS FRST RES | US unit not specified in 2009-2010 report | Air Force | 4/27/2009 | 2009-04-27 | 5/1/2009 | 2009-05-01 | VARIOUS | 1 | 12000 | 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]);