Occupant and Alcohol-Impaired Driving Deaths in States, 2005-2014

Alcohol-Impaired Driving Fatalities 2005-2014; All persons killed in crashes involving a driver with BAC >= .08 g/dL. Occupant Fatalities 2005-2014; All occupants killed where body type = 1-79. Source: National Highway Traffic Safety Administration's (NHTSA) Fatality Analysis Reporting System (FARS), 2005-2013 Final Reports and 2014 Annual Report File

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cdc-gov/occupant-and-alcoholimpaired-driving-deaths-in-haed-k2ka\".\"occupant_and_alcoholimpaired_driving_deaths_in\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.