About this Dataset

[TEST] Austin Crash Report Data - Crash Level Records

This is a test dataset for development only.

Our official crash record dataset is available here:
https://data.austintexas.gov/Transportation-and-Mobility/Austin-Crash-Report-Data-Crash-Level-Records/y2wy-tgr5/about_data
Organization: City of Austin
Last updated: 2020-11-12T13:21:03.578362
Tags: archive, crash, cris, public-extract, report, spcs, specification, specifications, test

Tables

Table 1

@usgov.city_of_austin_under_construction_test_crash_report_data.table_1

18.16 MB
214488 rows
50 columns


CREATE TABLE table_1 (
  "id" BIGINT,
  "cris_crash_id" DOUBLE,
  "crash_fatal_fl" BOOLEAN,
  "crash_timestamp_ct" VARCHAR,
  "case_id" VARCHAR,
  "rpt_block_num" VARCHAR,
  "rpt_street_pfx" 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,
  "law_enf_fatality_count" BIGINT,
  "death_cnt" BIGINT,
  "point" VARCHAR,
  "units_involved" VARCHAR,
  "onsys_fl" BOOLEAN,
  "private_dr_fl" BOOLEAN,
  "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,
  "micromobility_serious_injury_count" BIGINT,
  "micromobility_death_count" BIGINT,
  "crash_timestamp" VARCHAR,
  "address_primary" VARCHAR,
  "address_secondary" VARCHAR,
  "is_deleted" BOOLEAN,
  "is_temporary_record" BOOLEAN,
  "active_school_zone" VARCHAR,
  "apd_sector_id" VARCHAR,
  "at_intrsct_fl" VARCHAR,
  "john1" VARCHAR,
  "john2" VARCHAR,
  "est_comp_cost_crash_based" BIGINT,
  "est_total_person_comp_cost" BIGINT
);