Asotin County Vehicle Collisions

This dataset includes vehicle collisions in Asotin County beginning in January 2016. Only collisions reported to law enforcement and entered in the Washington State Department of Transportation (WSDOT) Crash Database appear here.

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 \"wa-gov/asotin-county-vehicle-collisions-yu78-e98h\".\"asotin_county_vehicle_collisions\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.