About this Dataset

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.
Organization: City of Austin
Last updated: 2020-11-12T13:34:43.153741
Tags: crash, vision-zero

Tables

Table 1

@usgov.city_of_austin_vision_zero_demographic_statistics.table_1

407.31 kB
8,847 rows
17 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "prsn_injry_sev_id" BIGINT,
  "prsn_age" DOUBLE,
  "prsn_ethnicity_id" DOUBLE,
  "mode_desc" VARCHAR,
  "mode_id" BIGINT,
  "crash_id" BIGINT,
  "crash_time_stamp_us_central" VARCHAR  -- Crash Time Stamp (US/Central),
  "crash_timestamp" VARCHAR,
  "cris_crash_id" DOUBLE,
  "is_deleted" BOOLEAN,
  "is_primary_person" BOOLEAN,
  "is_temporary_record" BOOLEAN,
  "person_ethnicity" VARCHAR,
  "person_sex_id" DOUBLE,
  "person_sex_label" VARCHAR,
  "unit_id" BIGINT
);