training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
22 rows where "qa:training_date_first_seen" is on date 2018-08-15 and "training:start_date" is on date 2017-03-10 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0a0b7ea5-7d0e-42ce-9b0c-6ef3d1b7015e | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Madagascar | MDG | IMET-1 - Fiscal Year 2017 Department of State Training | Instructor Development Course (IDC) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH S | Naval Forces | 3/10/2017 | 2017-03-10 | 3/23/2017 | 2017-03-23 | Stennis Space Center, MS, US | 1 | 1972 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
17ac7e29-a78d-4012-8e58-335c1f2af66f | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Madagascar | MDG | IMET-1 - Fiscal Year 2017 Department of State Training | Rule Of Law & DISCP MIL Operations | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH S | Air Force Base | 3/10/2017 | 2017-03-10 | 3/17/2017 | 2017-03-17 | Stennis Space Center, MS, US | 1 | 1342 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
0aa9e307-c0b9-4453-a73f-2471dd9df03a | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Madagascar | MDG | IMET-1 - Fiscal Year 2017 Department of State Training | Rule Of Law & DISCP MIL Operations | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH S | Naval Base | 3/10/2017 | 2017-03-10 | 3/17/2017 | 2017-03-17 | Stennis Space Center, MS, US | 1 | 1342 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
1e76ed27-1b72-4631-b615-cb1d09b75ba1 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Africa_fmtrpt.tsv | Zambia | ZMB | PKO - Fiscal Year 2017 Department of State Training | Pre-Deployment Training | N/A | N/A | 3/10/2017 | 2017-03-10 | 3/26/2017 | 2017-03-26 | Nanking PMTC, Lusaka, Zambia | 127 | 49067 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
fc5641db-2992-4d7c-82ce-8b311c8d7800 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | FMF - Fiscal Year 2017 Department of State Training | Instructor Development Course (IDC) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH S | Indonesian Armed Forces/Nanggala-402 Naval Ship | 3/10/2017 | 2017-03-10 | 3/23/2017 | 2017-03-23 | Stennis Space Center, MS, US | 1 | 8188 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
4b62512e-a42f-4cac-9d53-5a3831cf8100 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET-1 - Fiscal Year 2017 Department of State Training | Infantry Basic Officer Leader-Branch | INFANTRY SCHOOL | 10th Brigade | 3/10/2017 | 2017-03-10 | 3/11/2017 | 2017-03-11 | Ft. Benning, GA, US | 1 | 311 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
db1f7bec-7902-49f8-979d-1b8d54090435 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET-1 - Fiscal Year 2017 Department of State Training | Infantry Basic Officer Leader-Branch | INFANTRY SCHOOL | 8th Brigade | 3/10/2017 | 2017-03-10 | 3/11/2017 | 2017-03-11 | Ft. Benning, GA, US | 1 | 311 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
2154abfb-a905-402f-ad08-2d02e34afe67 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Near_East_fmtrpt.tsv | Tunisia | TUN | IMET-1 - Fiscal Year 2017 Department of State Training | OBS MED/Health/HYG-CONUS | Academy of Health Sciences | Military Hospital of Tunis | 3/10/2017 | 2017-03-10 | 3/22/2017 | 2017-03-22 | Ft. Sam Houston, TX, US | 1 | 2440 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
de85f627-2da3-4e81-91d6-6a9c16d69870 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Belize | BLZ | Section 1004 - Fiscal Year 2017 Department of Defense Training | Combat Life Saver Course (CLC) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH S | BELIZE COAST GUARD | 3/10/2017 | 2017-03-10 | 3/23/2017 | 2017-03-23 | Stennis Space Center, MS, US | 1 | 11357 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
325a3671-3fb9-4896-8e2f-319ab55d9162 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Belize | BLZ | Section 1004 - Fiscal Year 2017 Department of Defense Training | Combat Life Saver Course (CLC) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH S | BELIZE DEFENCE FORCE, MEDICAL UNIT, SUPPORT AND SERVICES BATTALION | 3/10/2017 | 2017-03-10 | 3/23/2017 | 2017-03-23 | Stennis Space Center, MS, US | 1 | 11357 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
f7294e12-5dda-43c7-9e9c-038fd0f87f02 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Belize | BLZ | Section 1004 - Fiscal Year 2017 Department of Defense Training | Instructor Development Course (IDC) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH S | BELIZE COAST GUARD | 3/10/2017 | 2017-03-10 | 3/23/2017 | 2017-03-23 | Stennis Space Center, MS, US | 1 | 1972 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
611f9d4c-9da3-4949-baeb-65d1d85ada99 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Belize | BLZ | Section 1004 - Fiscal Year 2017 Department of Defense Training | Instructor Development Course (IDC) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH S | BELIZE DEFENCE FORCE, SPECIAL BOAT UNIT, SUPPORT & SERVICES BATTALION, BELIZE DEFENCE FORCE | 3/10/2017 | 2017-03-10 | 3/23/2017 | 2017-03-23 | Stennis Space Center, MS, US | 1 | 1972 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
d779af74-aee9-4198-a7c0-a33d09049ef4 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2017 Department of State Training | Basic Instructor Course (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | COLOMBIAN NATIONAL POLICE, ANTINARCOTICS DIRECTORATE | 3/10/2017 | 2017-03-10 | 4/19/2017 | 2017-04-19 | Lackland AFB, TX, US | 2 | 2360 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
e1c5ed64-1df2-4879-a4ff-24008265ca95 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2017 Department of State Training | Basic Instructor Course (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | COLOMBIAN POLICE ANTINARCOTICS DIRECTORATE | 3/10/2017 | 2017-03-10 | 4/19/2017 | 2017-04-19 | Lackland AFB, TX, US | 1 | 1180 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
0b511404-5cc9-4d8b-a4b8-1b6e29366b52 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2017 Department of State Training | Basic Instructor Course (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | COLOMBIAN POLICE, ANTINARCOTICS DIRECTORATE | 3/10/2017 | 2017-03-10 | 4/19/2017 | 2017-04-19 | Lackland AFB, TX, US | 4 | 4720 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
f7a5cc29-1e4a-46c3-a74e-84e87ac02a90 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2017 Department of State Training | Basic Instructor Course (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | COLOMBIAN POLICE, ESIAF | 3/10/2017 | 2017-03-10 | 4/19/2017 | 2017-04-19 | Lackland AFB, TX, US | 1 | 1180 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
e29c840d-1e6e-428b-8fa7-ddf4459e2421 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INCLE - Fiscal Year 2017 Department of State Training | Basic Instructor Course (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | COLOMBIAN POLICE, JUNGLAS | 3/10/2017 | 2017-03-10 | 4/19/2017 | 2017-04-19 | Lackland AFB, TX, US | 2 | 2360 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
6dfbcfc3-41eb-4527-9827-2032a18070cf | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Dominica | DMA | FMF - Fiscal Year 2017 Department of State Training | Instructor Development Course (IDC) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH S | Dominica Coast Guard | 3/10/2017 | 2017-03-10 | 3/23/2017 | 2017-03-23 | Stennis Space Center, MS, US | 1 | 1972 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
9df7d46d-65d8-4049-80ef-296948205737 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Jamaica | JAM | IMET-1 - Fiscal Year 2017 Department of State Training | Rule Of Law & DISCP MIL Operations | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH S | Jamaica Defence Force | 3/10/2017 | 2017-03-10 | 3/17/2017 | 2017-03-17 | Stennis Space Center, MS, US | 2 | 10016 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
019a09d0-1e59-4d61-a8aa-b0cb66481f99 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Jamaica | JAM | Section 1004 - Fiscal Year 2017 Department of Defense Training | Combat Life Saver Course (CLC) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH S | Jamaica Defence Force | 3/10/2017 | 2017-03-10 | 3/23/2017 | 2017-03-23 | Stennis Space Center, MS, US | 2 | 20715 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
b8139b65-7f1e-42fd-96ff-92220dc10f3a | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Jamaica | JAM | Section 1004 - Fiscal Year 2017 Department of Defense Training | Instructor Development Course (IDC) | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH S | Jamaica Defence Force | 3/10/2017 | 2017-03-10 | 3/23/2017 | 2017-03-23 | Stennis Space Center, MS, US | 3 | 16914 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 2019-07-16 |
9ce9ff77-f8ad-4e14-b82e-1232dcd91893 | 8602229d-5b77-42e5-b1bc-83fad2eda1b9 | 2017_2018_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2017 Department of Defense Training | Basic Instructor Course (IAAFA - Spanish) | INTER AMERICAN AIR FORCES ACADEMY, LACKLAND | SEMAR | 3/10/2017 | 2017-03-10 | 4/19/2017 | 2017-04-19 | Lackland AFB, TX, US | 2 | 17526 | https://2009-2017.state.gov/documents/organization/284930.pdf | Not checked against source; verify accuracy before use | 2018-08-15 | 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]);