About this Dataset

Test Austin Crash Demographic Statistics - Incomplete And Not Intended For Public Analysis

This dataset serves as a part of the development process for the Austin Vision Zero programs public facing reporting applications. It is not complete, nor intended for use outside of the department’s software development efforts. Please see the following link for complete data: https://data.austintexas.gov/Transportation-and-Mobility/Vision-Zero-Crash-Report-Data-Demographic-Statisti/xecs-rpy9.
Organization: City of Austin
Last updated: 2020-11-12T13:33:31.817177
Tags: not-for-use, test-data

Tables

Table 1

@usgov.city_of_austin_under_construction_test_vision_zero_dem_3231802f.table_1

288.16 kB
6,240 rows
17 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "prsn_injry_sev_id" BIGINT,
  "prsn_age" DOUBLE,
  "prsn_sex_id" BIGINT,
  "prsn_ethnicity_id" DOUBLE,
  "cris_crash_id" BIGINT,
  "crash_timestamp_ct" VARCHAR,
  "mode_desc" VARCHAR,
  "mode_id" BIGINT,
  "is_primary_person" BOOLEAN,
  "unit_id" BIGINT,
  "crash_timestamp" VARCHAR,
  "prsn_sex_label" VARCHAR,
  "prsn_ethnicity_label" VARCHAR,
  "is_deleted" BOOLEAN,
  "is_temp_record" BOOLEAN,
  "crash_primary_key" BIGINT
);