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 -4707-05-31, "training:end_date" is on date 2014-08-29 and "training:start_date" is on date 2014-07-14 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2ff87964-7186-4137-8c34-8ab1ae31a1e2 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Africa_fmtrpt.tsv | Ghana | GHA | IMET-1 - Fiscal Year 2014 Department of State Training | Flight Safety Officer (SATP/FSO) | Kirtland AFB, NM | Air Force Base Tamale | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | Kirtland AFB, NM, US | 1 | 11567 | https://2009-2017.state.gov/documents/organization/243029.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
6e8309f8-3174-4031-9d84-e3cd8c2f781f | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Africa_fmtrpt.tsv | Tanzania | TZA | CTFP - Fiscal Year 2014 Department of Defense Training | COMB STRAT INTEL Training Program | Defense Intelligence Agency (CSITP) | Defense Forces HQ | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | DIA, Washington, DC, DC, US | 1 | 14746 | https://2009-2017.state.gov/documents/organization/243029.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
af53f278-90a0-4d5b-be0f-e8e2d9135b54 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | IMET-1 - Fiscal Year 2014 Department of State Training | Flight Safety Officer (SATP/FSO) | Kirtland AFB, NM | Indonesian Armed Forces | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | Kirtland AFB, NM, US | 1 | 6465 | https://2009-2017.state.gov/documents/organization/243030.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
16399cdb-6ba6-4ed0-88bf-6b2340412b57 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - Fiscal Year 2014 Department of State Training | COMB STRAT INTEL Training Program | Defense Intelligence Agency (CSITP) | 300TH Air INTEL And Security GRP, PHIL Air Force | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | DIA, Washington, DC, DC, US | 1 | 21324 | https://2009-2017.state.gov/documents/organization/243030.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
eb55bcbb-ea7b-4efe-a675-87631773088a | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Europe_fmtrpt.tsv | Bosnia & Herzegovina | BIH | CTFP - Fiscal Year 2014 Department of Defense Training | COMB STRAT INTEL Training Program | Defense Intelligence Agency (CSITP) | Ministry Of Defense BIH, Joint Staff AF BIH | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | DIA, Washington, DC, DC, US | 1 | 14946 | https://2009-2017.state.gov/documents/organization/243031.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
b8a4ec5c-6822-4ee9-a7d4-1bb17e02cc5c | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Europe_fmtrpt.tsv | Montenegro, Republic of | NME | IMET-1 - Fiscal Year 2014 Department of State Training | COMB STRAT INTEL Training Program | Defense Intelligence Agency (CSITP) | Department For Military Intel And Security Affairs/MoD | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | DIA, Washington, DC, DC, US | 1 | 21474 | https://2009-2017.state.gov/documents/organization/243031.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
2f32474d-53a1-4aba-8adb-7e48d1345c3a | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Europe_fmtrpt.tsv | Serbia, Republic of | SRB | IMET-1 - Fiscal Year 2014 Department of State Training | Flight Safety Officer (SATP/FSO) | Kirtland AFB, NM | Fighter Bomber Sqaudron/98th Air Brigade | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | Kirtland AFB, NM, US | 1 | 8967 | https://2009-2017.state.gov/documents/organization/243031.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
991760e6-577e-4fa9-abda-c8d179adbf7c | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Europe_fmtrpt.tsv | Ukraine | UKR | IMET-1 - Fiscal Year 2014 Department of State Training | COMB STRAT INTEL Training Program | Defense Intelligence Agency (CSITP) | A0515 Main Intelligence D-te | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | DIA, Washington, DC, DC, US | 1 | 21274 | https://2009-2017.state.gov/documents/organization/243031.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
a219c40e-d194-4821-a801-9a9a1504373a | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Near_East_fmtrpt.tsv | Bahrain | BHR | IMET-1 - Fiscal Year 2014 Department of State Training | Flight Safety Officer (SATP/FSO) | Kirtland AFB, NM | Royal Bahrain Air Force | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | Kirtland AFB, NM, US | 1 | 1610 | https://2009-2017.state.gov/documents/organization/243032.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
ef5b675c-4d1c-4b29-8232-02e0ab4876b6 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-1 - Fiscal Year 2014 Department of State Training | Flight Safety Officer (SATP/FSO) | Kirtland AFB, NM | Iraqi Air Force | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | Kirtland AFB, NM, US | 1 | 6500 | https://2009-2017.state.gov/documents/organization/243032.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
9c004653-a14d-4af7-b41d-a916246af3fd | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2014 Department of State Training | Flight Safety Officer (SATP/FSO) | Kirtland AFB, NM | Israeli Air Force Safety Center - Accident Investigation Branch | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | Kirtland AFB, NM, US | 1 | 1610 | https://2009-2017.state.gov/documents/organization/243032.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
8fd80068-6bdd-461a-99a3-1c7cf5415854 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2014 Department of State Training | Flight Safety Officer (SATP/FSO) | Kirtland AFB, NM | Directorate Of Air Operations | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | Kirtland AFB, NM, US | 1 | 6296 | https://2009-2017.state.gov/documents/organization/243032.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
d9200884-66ca-4b63-a74a-9c92c3c49763 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2014 Department of State Training | Flight Safety Officer (SATP/FSO) | Kirtland AFB, NM | Directorate Of Operations | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | Kirtland AFB, NM, US | 1 | 6296 | https://2009-2017.state.gov/documents/organization/243032.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
04d162c2-e9de-416c-b41d-9d08f6bed923 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2014 Department of State Training | Flight Safety Officer (SATP/FSO) | Kirtland AFB, NM | Operations Directorate | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | Kirtland AFB, NM, US | 1 | 10567 | https://2009-2017.state.gov/documents/organization/243032.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
4600036b-cec2-4968-87da-c886841fc787 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Near_East_fmtrpt.tsv | Lebanon | LBN | CTFP - Fiscal Year 2014 Department of Defense Training | COMB STRAT INTEL Training Program | Defense Intelligence Agency (CSITP) | Mount Lebanon Intelligence | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | DIA, Washington, DC, DC, US | 1 | 15946 | https://2009-2017.state.gov/documents/organization/243032.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
8396200b-1c6a-4f25-b797-c4cf70c4e2a4 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Near_East_fmtrpt.tsv | Morocco | MAR | IMET-1 - Fiscal Year 2014 Department of State Training | Flight Safety Officer (SATP/FSO) | Kirtland AFB, NM | 1 Base-Sale | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | Kirtland AFB, NM, US | 1 | 10417 | https://2009-2017.state.gov/documents/organization/243032.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
77227a28-e973-47c3-9afb-529417e3e9a1 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | FMF - Fiscal Year 2014 Department of State Training | American Language Course GET And SET | DLIELC, Lackland AFB TX | MOD | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | Lackland AFB, TX, US | 1 | 15275 | https://2009-2017.state.gov/documents/organization/243033.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
b34e6968-b932-4f52-9196-752c90f3e8a2 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | CTFP - Fiscal Year 2014 Department of Defense Training | COMB STRAT INTEL Training Program | Defense Intelligence Agency (CSITP) | Nepal Army | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | DIA, Washington, DC, DC, US | 1 | 16946 | https://2009-2017.state.gov/documents/organization/243033.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
974b5a48-c915-4ca6-af85-7e3e9c3a6c53 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | CTFP - Fiscal Year 2014 Department of Defense Training | COMB STRAT INTEL Training Program | Defense Intelligence Agency (CSITP) | HQ 204 Survey Sector | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | DIA, Washington, DC, DC, US | 1 | 15596 | https://2009-2017.state.gov/documents/organization/243033.pdf | Not checked against source; verify accuracy before use | 2015 | 2019-07-16 |
875dc0b3-5e01-42cc-bcaf-e2e608fd3fd2 | 79e14f58-ea87-47c9-ad07-49d8742d8b3d | 2014_2015_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | IMET-1 - Fiscal Year 2014 Department of State Training | Flight Safety Officer (SATP/FSO) | Kirtland AFB, NM | Soto Cano Air Base | 7/14/2014 | 2014-07-14 | 8/29/2014 | 2014-08-29 | Kirtland AFB, NM, US | 1 | 7317 | https://2009-2017.state.gov/documents/organization/243034.pdf | Not checked against source; verify accuracy before use | 2015 | 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]);