Office of Traffic Safety Crash Data for Napa County and Selected Cities

Office of Traffic Safety Crash Data for Napa County and Selected Cities on the years 2017 to 2020. Data includes OTS Ranking metric that is used to compare similar sized cities on traffic safety statistics. The smaller the number, the higher up on the ranking and the worst traffic safety compared to similar locations.

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 \"countyofnapa/office-of-traffic-safety-crash-data-for-napa-c7ub-ipet\".\"office_of_traffic_safety_crash_data_for_napa\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.