Dataset: Austin Crash Report Data - Crash Level Records

About this Dataset

Austin Crash Report Data - Crash Level Records

This dataset contains traffic crash 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). 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:35:00.151645
Tags: crash, vision-zero

Tables

Table 1

@usgov.city_of_austin_vision_zero_crash_report_data.table_1

18.4 MB
217205 rows
45 columns


CREATE TABLE table_1 (
  "id" BIGINT,
  "crash_id" DOUBLE,
  "crash_fatal_fl" BOOLEAN,
  "case_id" VARCHAR,
  "primary_address" VARCHAR,
  "secondary_address" VARCHAR,
  "rpt_block_num" VARCHAR,
  "rpt_street_name" VARCHAR,
  "rpt_street_sfx" VARCHAR,
  "crash_speed_limit" DOUBLE,
  "road_constr_zone_fl" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "crash_sev_id" BIGINT,
  "sus_serious_injry_cnt" BIGINT,
  "nonincap_injry_cnt" BIGINT,
  "poss_injry_cnt" BIGINT,
  "non_injry_cnt" BIGINT,
  "unkn_injry_cnt" BIGINT,
  "tot_injry_cnt" BIGINT,
  "death_cnt" BIGINT,
  "units_involved" VARCHAR,
  "point" VARCHAR,
  "motor_vehicle_death_count" BIGINT,
  "motor_vehicle_serious_injury_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_serious_injury_count" BIGINT,
  "pedestrian_death_count" BIGINT,
  "pedestrian_serious_injury_count" BIGINT,
  "motorcycle_death_count" BIGINT,
  "motorcycle_serious_injury_count" BIGINT,
  "other_death_count" BIGINT,
  "other_serious_injury_count" BIGINT,
  "onsys_fl" BOOLEAN,
  "private_dr_fl" BOOLEAN,
  "micromobility_serious_injury_count" BIGINT,
  "micromobility_death_count" BIGINT,
  "crash_timestamp_us_central" VARCHAR,
  "crash_timestamp" VARCHAR,
  "is_deleted" BOOLEAN,
  "is_temporary_record" BOOLEAN,
  "law_enforcement_fatality_count" BIGINT,
  "reported_street_prefix" VARCHAR,
  "estimated_maximum_comprehensive_cost" BIGINT,
  "estimated_total_comprehensive_cost" BIGINT
);