training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
23 rows where "qa:training_date_first_seen" is on date -4707-05-25 and "training:end_date" is on date 2008-07-09 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
58acd7d1-cfed-4f5d-a474-88309c48e994 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Africa_fmtrpt.tsv | Rwanda | RWA | IMET-1 - FY 2008 DoS Training | NCO ACADEMY PH-IV (E6 | US unit not specified in 2008-2009 report | Airforce college | 5/29/2008 | 2008-05-29 | 7/9/2008 | 2008-07-09 | LACKLAND AFB, TX (OTHER THAN DLI AND IAAFA STUDENTS) | 1 | 7955 | https://2009-2017.state.gov/documents/organization/152766.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
044e5856-06d1-42fb-a8ef-1a00808d36d9 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Bolivia | BOL | Section 1004 - FY 2008 DoD Training | SPAN UH-1 HELO RPR CN 1004 | US unit not specified in 2008-2009 report | UH-1 Task Force \"Red Devils\" | 4/29/2008 | 2008-04-29 | 7/9/2008 | 2008-07-09 | AVIATION SCHOOL | 1 | 14666 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
5a527d3c-f380-4e69-af24-a6c281414159 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Bolivia | BOL | Section 1004 - FY 2008 DoD Training | SPAN UH-1 HELO RPR CN 1004 | US unit not specified in 2008-2009 report | UH-1 Task Force \"Red Devils\" | 4/29/2008 | 2008-04-29 | 7/9/2008 | 2008-07-09 | AVIATION SCHOOL | 1 | 14666 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
61a9b87c-ffa9-4611-9606-be0f1739752a | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2008 DoS Training | SPAN UH-1 HELO RPR CN 1004 | US unit not specified in 2008-2009 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 4/29/2008 | 2008-04-29 | 7/9/2008 | 2008-07-09 | AVIATION SCHOOL | 1 | 8217 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
3414e57b-c417-4d0c-a3b0-354191267703 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2008 DoS Training | SPAN UH-1 HELO RPR CN 1004 | US unit not specified in 2008-2009 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 4/29/2008 | 2008-04-29 | 7/9/2008 | 2008-07-09 | AVIATION SCHOOL | 1 | 8217 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
fb6b2c8e-d7dd-4646-8d79-4f0af2556ca7 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2008 DoS Training | SPAN UH-1 HELO RPR CN 1004 | US unit not specified in 2008-2009 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 4/29/2008 | 2008-04-29 | 7/9/2008 | 2008-07-09 | AVIATION SCHOOL | 1 | 8217 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
5b40403d-d643-48ec-9b65-2573ab04bc92 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2008 DoS Training | SPAN UH-1 HELO RPR CN 1004 | US unit not specified in 2008-2009 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 4/29/2008 | 2008-04-29 | 7/9/2008 | 2008-07-09 | AVIATION SCHOOL | 1 | 8217 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
0000a84e-aaed-4087-90cb-0779844e6587 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2008 DoS Training | SPAN UH-1 HELO RPR CN 1004 | US unit not specified in 2008-2009 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 4/29/2008 | 2008-04-29 | 7/9/2008 | 2008-07-09 | AVIATION SCHOOL | 1 | 8217 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
810120e8-e339-4911-a4e9-e56d2fee6824 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2008 DoS Training | SPAN UH-1 HELO RPR CN 1004 | US unit not specified in 2008-2009 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 4/29/2008 | 2008-04-29 | 7/9/2008 | 2008-07-09 | AVIATION SCHOOL | 1 | 8217 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
64367143-f894-4829-844e-b8ad0837b82b | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2008 DoS Training | SPAN UH-1 HELO RPR CN 1004 | US unit not specified in 2008-2009 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 4/29/2008 | 2008-04-29 | 7/9/2008 | 2008-07-09 | AVIATION SCHOOL | 1 | 8217 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
c44949cf-b6a6-4458-b5cc-7991e4c7f3a5 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2008 DoS Training | SPAN UH-1 HELO RPR CN 1004 | US unit not specified in 2008-2009 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 4/29/2008 | 2008-04-29 | 7/9/2008 | 2008-07-09 | AVIATION SCHOOL | 1 | 8217 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
10735d5f-5ba7-4f4f-9432-ae3320f5e812 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2008 DoS Training | SPAN UH-1 HELO RPR CN 1004 | US unit not specified in 2008-2009 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 4/29/2008 | 2008-04-29 | 7/9/2008 | 2008-07-09 | AVIATION SCHOOL | 1 | 8217 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
a712c2ad-9ab0-4fc0-9b19-d8f9a2804dc8 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2008 DoS Training | SPAN UH-1 HELO RPR CN 1004 | US unit not specified in 2008-2009 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 4/29/2008 | 2008-04-29 | 7/9/2008 | 2008-07-09 | AVIATION SCHOOL | 1 | 8217 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
3cfcd290-42a5-4e11-90fe-5338139bfae1 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2008 DoS Training | SPAN UH-1 HELO RPR CN 1004 | US unit not specified in 2008-2009 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 4/29/2008 | 2008-04-29 | 7/9/2008 | 2008-07-09 | AVIATION SCHOOL | 1 | 8217 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
095032b0-940d-4f4d-afb3-de40362b8076 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Paraguay | PRY | IMET-1 - FY 2008 DoS Training | SPAN UH-1 HELO RPR - ALL | US unit not specified in 2008-2009 report | Comando de la Fuerza Aérea | 4/29/2008 | 2008-04-29 | 7/9/2008 | 2008-07-09 | AVIATION SCHOOL | 1 | 25883 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
bf286aa0-9b17-4f88-99bd-263241afe834 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - FY 2008 DoS Training | UH-1 HELICOPTER RPR SUPVR BNCOC (SP) | US unit not specified in 2008-2009 report | Colombian Army UH-60 Helicopter Batallion | 4/28/2008 | 2008-04-28 | 7/9/2008 | 2008-07-09 | AVIATION LOGISTICS SCHOOL | 1 | 10994 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
47183889-d08b-4ee8-990e-21b77046a838 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2008 DoS Training | UH-1 HELICOPTER RPR SUPVR BNCOC (SP) | US unit not specified in 2008-2009 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 4/28/2008 | 2008-04-28 | 7/9/2008 | 2008-07-09 | AVIATION LOGISTICS SCHOOL | 1 | 3476 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
2126b5a0-7fe2-4f0f-8640-dfeadcc5136b | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2008 DoS Training | UH-1 HELICOPTER RPR SUPVR BNCOC (SP) | US unit not specified in 2008-2009 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 4/28/2008 | 2008-04-28 | 7/9/2008 | 2008-07-09 | AVIATION LOGISTICS SCHOOL | 1 | 3476 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
58f5e57a-dbbe-4960-9283-f212dae73a27 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Peru | PER | INL - FY 2008 DoS Training | UH-1 HELICOPTER RPR SUPVR BNCOC (SP) | US unit not specified in 2008-2009 report | PERUVIAN NATIONAL POLICE-DIRAVPOL | 4/28/2008 | 2008-04-28 | 7/9/2008 | 2008-07-09 | AVIATION LOGISTICS SCHOOL | 1 | 10874 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
c1d1c010-38fc-4908-b0c0-ea9588016612 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Western_Hemisphere_fmtrpt.tsv | Peru | PER | INL - FY 2008 DoS Training | UH-1 HELICOPTER RPR SUPVR BNCOC (SP) | US unit not specified in 2008-2009 report | PERUVIAN NATIONAL POLICE-DIRAVPOL | 4/28/2008 | 2008-04-28 | 7/9/2008 | 2008-07-09 | AVIATION LOGISTICS SCHOOL | 1 | 10874 | https://2009-2017.state.gov/documents/organization/152774.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
331e53cc-4c35-470b-8bda-d6fa7408d9d8 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Tunisia | TUN | IMET-1 - FY 2008 DoS Training | WATER TREATMENT SPECIALIST | US unit not specified in 2008-2009 report | Water Treatment Team, Beja Military Base | 4/7/2008 | 2008-04-07 | 7/9/2008 | 2008-07-09 | QUARTERMASTER SCHOOL | 1 | 14032 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
bba0f8b8-136a-4e16-a67b-3718c0874ef2 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - FY 2008 DoS Training | INTL EOD PH II (SURFACE) | US unit not specified in 2008-2009 report | King Hussein Air College | 3/18/2008 | 2008-03-18 | 7/9/2008 | 2008-07-09 | NAVAL SCHOOL EXPLOSIVE ORDNANCE DISPOSAL EGLIN AFB FL | 1 | 5792 | https://2009-2017.state.gov/documents/organization/152770.pdf | Not checked against source; verify accuracy before use | 2009 | 2019-07-16 |
6e4d04a1-ed7c-4a5a-a8eb-97836fd2fbf6 | 333125f2-0bae-4feb-bdde-8c6fd26d0ccb | 2008_2009_East_Asia_And_Pacific_fmtrpt.tsv | Malaysia | MYS | IMET-1 - FY 2008 DoS Training | NAVAL COMMAND COLLEGE | US unit not specified in 2008-2009 report | Personnel Div, Royal Msian Navy HQ | 8/20/2007 | 2007-08-20 | 7/9/2008 | 2008-07-09 | NAVAL COMMAND COLLEGE NEWPORT RI | 1 | 104462 | https://2009-2017.state.gov/documents/organization/152767.pdf | Not checked against source; verify accuracy before use | 2009 | 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]);