training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
20 rows where "qa:training_date_first_seen" is on date 2017-10-27, "training:end_date" is on date 2016-07-14 and "training:start_date" is on date 2016-05-23 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
908ddbbd-5dcc-44c0-9fe1-7c3320f5c7b9 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Kenya | KEN | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | Air Transport Wing | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 19801 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
be5da071-78e4-400e-91b4-d5fcf98b0173 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Nigeria | NGA | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | HQ Nigerian Air Force | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 20551 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
5f378cd4-4c70-402b-be35-c5d813637089 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Africa_fmtrpt.tsv | Senegal | SEN | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | 7th Air Force Support BN | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 18691 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
cbfbcb0d-a711-4c02-98b9-07369483fd82 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | Operations Office, Indonesian Air Force HQs | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 19090 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
ed6a2d30-0765-4831-8e52-a218e90c5045 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_East_Asia_and_Pacific_fmtrpt.tsv | Malaysia | MYS | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | Operations And Strategy Division, RMAF HQ | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 12751 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
f4f06e56-70fc-422f-9d83-76a5e32ae72e | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | Office Of the Director For Operations, 250TH PRESIDENTIAL Wing, Philippine Air Force | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 18260 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
35aef66e-5354-4ad8-bb61-f9c9401f0ace | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Egypt | EGY | IMET-2 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | KHATATBA Air Base | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 13676 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
8870af59-1b5b-4eb4-8bdb-050b4807057e | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | 131ST Squadron | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 4150 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
5bc8000e-eb09-4985-bbbb-e3076888060c | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | Air Operations Directorate | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 17410 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
abd51ec1-31b6-4dcf-9b00-df386a5dea5e | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | Rayak Air Base | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 19010 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
db72cd5c-1d77-4cf7-aab8-6bf3860c13e1 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Morocco | MAR | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | 5 Base - SIDI Slimane | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 17860 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
ba4628c3-8a10-4bf9-bb77-5605131a483a | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Oman | OMN | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | Royal Air Force Of Oman | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 18210 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
74a9eb9d-9126-4ee6-b39a-715b487f88af | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Near_East_fmtrpt.tsv | Tunisia | TUN | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | Supply Division/Kharrouba Air Base | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 19210 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
3aaa1665-522f-4073-aa9c-97e6557cde55 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_South_Central_Asia_fmtrpt.tsv | India | IND | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | Air HQ (VAYU BHAVAN) | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 17200 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
273f08de-9270-4228-b0b9-c522a404ce5e | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | Air War College, PAF Base Faisal | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 18226 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
87ec43e2-5e38-4290-a592-20efc3c970fc | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | Center For Investigation And Prevention Of Aerial Accidents | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 4150 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
ceb63ce6-2d16-47f2-9b31-b0bd4d2a8128 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Chile | RCH | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | FIDAE - Chile | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 4150 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
5dfcb16c-b299-4620-b2a2-7701d66b0aca | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | Air Combat Command No.2, Apiay | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 4150 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
7f348e09-ef98-49e0-8f8b-02f7cfe95002 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | IMET-1 - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | SEDENA | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 16560 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 2019-07-16 |
3195429a-e700-4e92-810f-578e29e96180 | 841f634e-6db0-4c1c-a2e3-4d6ff76505d4 | 2016_2017_Western_Hemisphere_fmtrpt.tsv | Peru | PER | FMF - Fiscal Year 2016 Department of State Training | International Off School (For AWC) | Maxwell AFB, AL | Air Force | 5/23/2016 | 2016-05-23 | 7/14/2016 | 2016-07-14 | Maxwell AFB, AL, US | 1 | 16860 | https://2009-2017.state.gov/documents/organization/275295.pdf | Not checked against source; verify accuracy before use | 2017-10-27 | 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]);