Strategic Measure_Number of fatalities and serious injuries on the High-Injury Network

This dataset supports measure M.D.3 of SD 2023. The original source of the data is the Texas Department of Transportation supplemented by analysis from the Austin Transportation Department. Each row represents the number of fatalities or injuries on the High Injury Network for a year. This dataset can be used to see how many fatalities and serious injuries have occurred on the High Injury Network.

View more details and insights related to this measure on the story page: https://data.austintexas.gov/stories/s/M-D-3-Number-of-fatalities-and-serious-injuries-on/i39b-qmzk/

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-austintexas-gov/strategic-measurenumber-of-fatalities-and-serious-ft3n-udtt\".\"strategic_measurenumber_of_fatalities_and_serious\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.