datahub-austintexas-gov/austin-crash-report-data-crash-victim-demographic-xecs-rpy9
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 6 hours ago
Indexed 3 hours ago

Austin Crash Report Data - Crash Victim Demographic Records

This dataset contains crash victim records for crashes which have occurred in Austin, TX in the last ten years. It is one of two datasets which power our Vision Zero Viewer dashboard, available here: https://visionzero.austin.gov/viewer.

Crash data may take several weeks to be submitted, reviewed, and finalized for inclusion in this dataset. To provide the most accurate information as possible, we only provide crash data as recent as two weeks old. Please also note that some crash records may take even longer to appear in this dataset, depending on the circumstances of the crash and the ensuing law enforcement investigation.

Crash data is obtained from the Texas Department of Transportation (TxDOT) Crash Record Information System (CRIS) database, which is populated by reports submitted by Texas Peace Officers throughout the state, including Austin Police Department (APD).

Please note that the data and information on this website is for informational purposes only. While we seek to provide accurate information, please note that errors may be present and information presented may not be complete.

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/austin-crash-report-data-crash-victim-demographic-xecs-rpy9\".\"austin_crash_report_data_crash_victim_demographic\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • austin_crash_report_data_crash_victim_demographic
     
     
     
     
     
Upstream Metadata