austintexas-gov/2019-apd-traffic-fatality-data-egpd-hqdi
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 10 months ago
Indexed 6 hours ago

2019 APD Traffic Fatality Data

A dataset of 2019 APD Traffic Fatality Data

AUSTIN POLICE DEPARTMENT DATA DISCLAIMER

  1. The data provided are for informational use only and may differ from official APD crime data.

  2. APD’s crime database is continuously updated, so reports run at different times may produce different results. Care should be taken when comparing against other reports as different data collection methods and different data sources may have been used.

  3. The Austin Police Department does not assume any liability for any decision made or action taken or not taken by the recipient in reliance upon any information or data provided.

The Austin Police Department Fatality database contains only those crashes investigated by APD and is continuously being updated due to on-going investigations. The data provided here represents a snapshot of Traffic Fatality information at a specific point in time and may change. Due to the long processing times for toxicology testing, impairment and suspected impairment, statistics are based on the initial assessment of the Detectives and Medical Examiner.

NOTE: Empty fields indicate unknown data.

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 \"austintexas-gov/2019-apd-traffic-fatality-data-egpd-hqdi\".\"2019_apd_traffic_fatality_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • 2019_apd_traffic_fatality_data
     
     
     
     
     
Upstream Metadata