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 "qa:training_date_first_seen" is on date -4707-05-26, "training:end_date" is on date 2009-07-10 and "training:start_date" is on date 2009-05-11 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
568332b7-64d2-4b05-bdf1-d212af4f4a0f | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Africa_fmtrpt.tsv | Burundi | BDI | IMET-1 - FY 2009 DoS Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | Burundian Army 11446 | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | https://2009-2017.state.gov/documents/organization/155997.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
b3f2a574-62de-447c-b264-283426579ded | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Africa_fmtrpt.tsv | Senegal | SEN | IMET-1 - FY 2009 DoS Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | Material BN | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | 10869 | https://2009-2017.state.gov/documents/organization/155997.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
abbceb96-ebe9-4b66-a88c-1c080a957f6d | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Africa_fmtrpt.tsv | Senegal | SEN | IMET-1 - FY 2009 DoS Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | Air Force OPS BN | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | 11566 | https://2009-2017.state.gov/documents/organization/155997.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
e317d08f-8f1c-4b07-bf38-f5bf1377aa0d | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | IMET-1 - FY 2009 DoS Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | Maintenance Depot 10 12052 | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | https://2009-2017.state.gov/documents/organization/155998.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
07e5fd7e-dca9-41f0-b46e-1e84e57b0bd0 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_East_Asia_and_Pacific_fmtrpt.tsv | Malaysia | MYS | IMET-1 - FY 2009 DoS Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | MAF Electronic Warfare Training Centre 10289 | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | https://2009-2017.state.gov/documents/organization/155998.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
a050c5c7-3ecc-4bfd-a73e-601297e8df51 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - FY 2009 DoS Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | EASTERN MINDANAO COMMAND 10542 | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | https://2009-2017.state.gov/documents/organization/155998.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
70f36d8d-4852-4b27-aec7-85d3e7220020 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Bahrain | BHR | IMET-1 - FY 2009 DoS Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | ROYAL BAHRAIN NAVAL FORCE 3050 | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
12471fe6-483f-4fa2-b00a-1932e37e74e2 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Bahrain | BHR | IMET-1 - FY 2009 DoS Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | ROYAL BAHRAIN NAVAL FORCE 3050 | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
9b16663a-99f1-47c0-a6f8-36cb3b58305f | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - FY 2009 DoS Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | ABOU-HAMMAD AIR BASE 10012 | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
ca0201fb-368d-4398-8b67-1a8366280bbe | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - FY 2009 DoS Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | AIR REGIMENT 770 9729 | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
41695272-ea13-4b80-85bf-652b873bfacc | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - FY 2009 DoS Training | GENERAL ENGLISH LANG TNG | US unit not specified in 2009-2010 report | AIR LIFT WING | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | 10288 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
8cd198c4-af52-4ecb-b252-1ea5335cd6cb | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - FY 2009 DoS Training | GENERAL ENGLISH LANG TNG | US unit not specified in 2009-2010 report | AIR LIFT WING | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | 10288 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
a37f30d7-a6d2-4cd9-a335-dd2090a27c07 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - FY 2009 DoS Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | JOINT LOGISTICS DIRECTORATE 12252 | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
a58c3cdc-b3d0-4bca-9c19-5cac12e94a92 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - FY 2009 DoS Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | Kleyat Air Base 12002 | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 | |
b995255c-3c14-47a4-b29e-03b002979354 | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Morocco | MAR | IMET-1 - FY 2009 DoS Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | 1 BASE - SALE | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | 11399 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
2191c52e-4273-4b6a-9156-a3b81aed12ca | 3ae10e65-b946-4e3d-86d5-5dfbce339ebd | 2009_2010_Near_East_fmtrpt.tsv | Oman | OMN | IMET-1 - FY 2009 DoS Training | SPECIALIZED ENG LANG TNG | US unit not specified in 2009-2010 report | RAFO | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | 9660 | https://2009-2017.state.gov/documents/organization/156000.pdf | Not checked against source; verify accuracy before use | 2010 | 2019-07-16 |
0631df92-6bbd-4b7f-8a38-d95a9e2779c0 | 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 | 5/11/2009 | 2009-05-11 | 7/10/2009 | 2009-07-10 | DLIELC, LACKLAND AFB TX | 1 | 7518 | 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]);