Select Summary Statistics Dashboard data

The Summary Statistics dashboard includes rural and urban measures for roadway mileage, lane miles, vehicle miles traveled, fatalities, and fatality rate.

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 \"datahub-transportation-gov/select-summary-statistics-dashboard-data-f6w3-9e37\".\"select_summary_statistics_dashboard_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.