training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
18 rows where "qa:training_date_scraped" is on date 2019-12-06 and "training:start_date" is on date 2018-08-12 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
76e8d9d5-2126-426f-9ccd-86d20f2ad51d | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Africa_fmtrpt.tsv | Mauritania | MRT | PKO - Fiscal Year 2018 Department of State Training | AMEP Mauritania site survey visit | DOD - 5 | MOD | 8/12/2018 | 2018-08-12 | 8/15/2018 | 2018-08-15 | Nouakchott, MR | 1 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
1d2b7227-575f-4f50-8846-d08c0b5c676a | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2018 Department of State Training | C-130J SIM Refresher - Loadmaster | Keesler AFB, MS | 103RD Squadron | 8/12/2018 | 2018-08-12 | 8/15/2018 | 2018-08-15 | Keesler AFB, MS, US | 2 | 9140 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
04ca2d62-fd6d-430d-8c87-0236e6608ce8 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2018 Department of State Training | C-130J SIM Refresher - Pilot | Keesler AFB, MS | 103RD Squadron | 8/12/2018 | 2018-08-12 | 8/15/2018 | 2018-08-15 | Keesler AFB, MS, US | 2 | 18140 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
d6419a8b-7e1d-4e84-a580-7fc43e0bced4 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2018 Department of State Training | C-130J SIM Refresher Observer | Keesler AFB, MS | 103RD Squadron | 8/12/2018 | 2018-08-12 | 8/15/2018 | 2018-08-15 | Keesler AFB, MS, US | 1 | 9070 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
1b63fb5b-f3ad-4e05-af12-1769a8ef5571 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2018 Department of Defense Training | CTFP - JSOU/In Country | Colombia (In Country Training) | Air Force / EPFAC | 8/12/2018 | 2018-08-12 | 8/17/2018 | 2018-08-17 | Bogota, CO | 1 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
f8b928fe-ffbf-42c4-bead-a2306d195f6b | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2018 Department of Defense Training | CTFP - JSOU/In Country | Colombia (In Country Training) | Army | 8/12/2018 | 2018-08-12 | 8/17/2018 | 2018-08-17 | Bogota, CO | 3 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
7c1162c8-87ac-4523-8a73-59e2f091a076 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2018 Department of Defense Training | CTFP - JSOU/In Country | Colombia (In Country Training) | Army / DESTA | 8/12/2018 | 2018-08-12 | 8/17/2018 | 2018-08-17 | Bogota, CO | 1 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
9f4543d3-d5f7-484e-9d46-b1c249525d70 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2018 Department of Defense Training | CTFP - JSOU/In Country | Colombia (In Country Training) | Army / ESCOM | 8/12/2018 | 2018-08-12 | 8/17/2018 | 2018-08-17 | Bogota, CO | 1 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
e1143875-b01f-4565-b41f-b8f934faaeb6 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2018 Department of Defense Training | CTFP - JSOU/In Country | Colombia (In Country Training) | Army / FUTZE | 8/12/2018 | 2018-08-12 | 8/17/2018 | 2018-08-17 | Bogota, CO | 1 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
9a8ccd58-cdac-446e-aece-9d5f5c08be32 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2018 Department of Defense Training | CTFP - JSOU/In Country | Colombia (In Country Training) | Army/ ESMAI | 8/12/2018 | 2018-08-12 | 8/17/2018 | 2018-08-17 | Bogota, CO | 1 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
b85f9a84-7e6e-4f24-b442-be124f110767 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2018 Department of Defense Training | CTFP - JSOU/In Country | Colombia (In Country Training) | CREES / ESDEGUE | 8/12/2018 | 2018-08-12 | 8/17/2018 | 2018-08-17 | Bogota, CO | 2 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
2e9406cc-e4e9-49e3-a332-e53331789b12 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2018 Department of Defense Training | CTFP - JSOU/In Country | Colombia (In Country Training) | ESDEGUE | 8/12/2018 | 2018-08-12 | 8/17/2018 | 2018-08-17 | Bogota, CO | 15 | 31346 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
f92ee910-2cff-4e69-8bbb-508c141824a6 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2018 Department of Defense Training | CTFP - JSOU/In Country | Colombia (In Country Training) | General Attorney | 8/12/2018 | 2018-08-12 | 8/17/2018 | 2018-08-17 | Bogota, CO | 1 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
9700406b-0a1e-49a6-8ef0-631ad603d2fb | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2018 Department of Defense Training | CTFP - JSOU/In Country | Colombia (In Country Training) | Marine Corps RECOIC | 8/12/2018 | 2018-08-12 | 8/17/2018 | 2018-08-17 | Bogota, CO | 1 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
bb87a890-989a-401a-872b-cc242cf1b5f7 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2018 Department of Defense Training | CTFP - JSOU/In Country | Colombia (In Country Training) | Ministry Of Defense | 8/12/2018 | 2018-08-12 | 8/17/2018 | 2018-08-17 | Bogota, CO | 1 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
f7f0e6e5-e76c-476f-9fbd-bdf278377bf8 | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2018 Department of Defense Training | CTFP - JSOU/In Country | Colombia (In Country Training) | UMNG | 8/12/2018 | 2018-08-12 | 8/17/2018 | 2018-08-17 | Bogota, CO | 1 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
5a7254a5-8251-4dc7-a579-6edfd4ea823e | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | CTFP - Fiscal Year 2018 Department of Defense Training | CTFP - JSOU/In Country | Colombia (In Country Training) | Universidad Military Nueva Granada | 8/12/2018 | 2018-08-12 | 8/17/2018 | 2018-08-17 | Bogota, CO | 1 | 0 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
05d650ab-9540-420b-bd3f-9618c2a0366a | 8d439057-bc2d-4141-8ff3-48d6842150eb | 2018_2019_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 333 - Fiscal Year 2018 Department of Defense Training | Tactical Cbt Care 2of2 | ARNORTH - 4 | Multiple units represented; training was \"school house\" driven through Direccion General de Sanidad | 8/12/2018 | 2018-08-12 | 8/24/2018 | 2018-08-24 | Mexico City, Distrito Federal, MX | 54 | 42700 | https://www.state.gov/wp-content/uploads/2019/12/FMT_Volume-I_FY2018_2019.pdf | Not checked against source; verify accuracy before use | 2019-12-06 | 2019-12-06 |
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]);