About this Dataset

Allegheny County Crash Data

Contains locations and information about every crash incident reported to the police in Allegheny County from 2004 to 2020. Fields include injury severity, fatalities, information about the vehicles involved, location information, and factors that may have contributed to the crash. Data is provided by PennDOT and is subject to PennDOT's data privacy restrictions, which are noted in the metadata information section below.

The map below shows car crashes in Allegheny County during 2016, with the color indicating whether it was a rear end collision or not.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:07:37.843622
Tags: _etl, _jupyter, accident, bicycle, bus, car, crash, incident, motorcycle, pedestrian, speed, traffic, transportation, truck, vehicle

Tables

Municipality Codes

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.municipality_codes

4.55 KB
130 rows
2 columns


CREATE TABLE municipality_codes (
  "code" BIGINT,
  "municipality" VARCHAR
);

2004 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2004_crash_data

954.97 KB
12535 rows
188 columns


CREATE TABLE n_2004_crash_data (
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" DOUBLE,
  "hour_of_day" DOUBLE,
  "illumination" BIGINT,
  "weather" BIGINT,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" BIGINT,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" DOUBLE,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT,
  "sv_run_off_rd" BIGINT
);

2005 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2005_crash_data

930.43 KB
12215 rows
188 columns


CREATE TABLE n_2005_crash_data (
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" BIGINT,
  "hour_of_day" BIGINT,
  "illumination" BIGINT,
  "weather" BIGINT,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" BIGINT,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" BIGINT,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT,
  "sv_run_off_rd" BIGINT
);

2006 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2006_crash_data

963.62 KB
11747 rows
189 columns


CREATE TABLE n_2006_crash_data (
  "n__id" BIGINT,
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" BIGINT,
  "hour_of_day" BIGINT,
  "illumination" BIGINT,
  "weather" BIGINT,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" BIGINT,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" BIGINT,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT
);

2007 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2007_crash_data

1014.77 KB
12238 rows
189 columns


CREATE TABLE n_2007_crash_data (
  "n__id" BIGINT,
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" DOUBLE,
  "hour_of_day" DOUBLE,
  "illumination" BIGINT,
  "weather" BIGINT,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" BIGINT,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" BIGINT,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT
);

2008 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2008_crash_data

958.78 KB
11858 rows
188 columns


CREATE TABLE n_2008_crash_data (
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" BIGINT,
  "hour_of_day" BIGINT,
  "illumination" BIGINT,
  "weather" DOUBLE,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" BIGINT,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" BIGINT,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT,
  "sv_run_off_rd" BIGINT
);

2009 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2009_crash_data

1 MB
11677 rows
189 columns


CREATE TABLE n_2009_crash_data (
  "n__id" BIGINT,
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" BIGINT,
  "hour_of_day" BIGINT,
  "illumination" BIGINT,
  "weather" DOUBLE,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" BIGINT,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" BIGINT,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT
);

2010 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2010_crash_data

999.05 KB
11320 rows
189 columns


CREATE TABLE n_2010_crash_data (
  "n__id" BIGINT,
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" BIGINT,
  "hour_of_day" BIGINT,
  "illumination" BIGINT,
  "weather" DOUBLE,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" BIGINT,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" BIGINT,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT
);

2011 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2011_crash_data

989.86 KB
12189 rows
188 columns


CREATE TABLE n_2011_crash_data (
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" BIGINT,
  "hour_of_day" BIGINT,
  "illumination" BIGINT,
  "weather" BIGINT,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" BIGINT,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" BIGINT,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT,
  "sv_run_off_rd" BIGINT
);

2012 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2012_crash_data

1003.79 KB
12230 rows
188 columns


CREATE TABLE n_2012_crash_data (
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" BIGINT,
  "hour_of_day" BIGINT,
  "illumination" BIGINT,
  "weather" BIGINT,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" BIGINT,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" BIGINT,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT,
  "sv_run_off_rd" BIGINT
);

2013 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2013_crash_data

975.64 KB
11994 rows
188 columns


CREATE TABLE n_2013_crash_data (
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" BIGINT,
  "hour_of_day" BIGINT,
  "illumination" BIGINT,
  "weather" BIGINT,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" BIGINT,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" BIGINT,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT,
  "sv_run_off_rd" BIGINT
);

2014 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2014_crash_data

998.24 KB
12183 rows
188 columns


CREATE TABLE n_2014_crash_data (
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" BIGINT,
  "hour_of_day" BIGINT,
  "illumination" BIGINT,
  "weather" BIGINT,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" BIGINT,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" BIGINT,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT,
  "sv_run_off_rd" BIGINT
);

2015 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2015_crash_data

1.08 MB
12735 rows
189 columns


CREATE TABLE n_2015_crash_data (
  "n__id" BIGINT,
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" BIGINT,
  "hour_of_day" BIGINT,
  "illumination" BIGINT,
  "weather" BIGINT,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" BIGINT,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" BIGINT,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT
);

2016 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2016_crash_data

1.08 MB
12908 rows
189 columns


CREATE TABLE n_2016_crash_data (
  "n__id" BIGINT,
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" BIGINT,
  "hour_of_day" BIGINT,
  "illumination" BIGINT,
  "weather" BIGINT,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" BIGINT,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" BIGINT,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT
);

2017 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2017_crash_data

1 MB
12537 rows
191 columns


CREATE TABLE n_2017_crash_data (
  "n__id" BIGINT,
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" BIGINT,
  "hour_of_day" BIGINT,
  "illumination" BIGINT,
  "weather" BIGINT,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" BIGINT,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" BIGINT,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT
);

2018 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2018_crash_data

986.01 KB
12422 rows
187 columns


CREATE TABLE n_2018_crash_data (
  "automobile_count" DOUBLE,
  "belted_death_count" DOUBLE,
  "belted_maj_inj_count" DOUBLE,
  "bicycle_count" DOUBLE,
  "bicycle_death_count" DOUBLE,
  "bicycle_maj_inj_count" DOUBLE,
  "bus_count" DOUBLE,
  "collision_type" DOUBLE,
  "comm_veh_count" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "crash_county" DOUBLE,
  "crash_month" DOUBLE,
  "crash_year" DOUBLE,
  "crash_crn" DOUBLE,
  "day_of_week" DOUBLE,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "district" DOUBLE,
  "driver_count_16yr" DOUBLE,
  "driver_count_17yr" DOUBLE,
  "driver_count_18yr" DOUBLE,
  "driver_count_19yr" DOUBLE,
  "driver_count_20yr" DOUBLE,
  "driver_count_50_64yr" DOUBLE,
  "driver_count_65_74yr" DOUBLE,
  "driver_count_75plus" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "fatal_count" DOUBLE,
  "heavy_truck_count" DOUBLE,
  "hour_of_day" DOUBLE,
  "illumination" DOUBLE,
  "injury_count" DOUBLE,
  "intersect_type" DOUBLE,
  "lane_closed" DOUBLE,
  "latitude" VARCHAR,
  "ln_close_dir" DOUBLE,
  "location_type" DOUBLE,
  "longitude" VARCHAR,
  "maj_inj_count" DOUBLE,
  "max_severity_level" DOUBLE,
  "mcycle_death_count" DOUBLE,
  "mcycle_maj_inj_count" DOUBLE,
  "min_inj_count" DOUBLE,
  "mod_inj_count" DOUBLE,
  "motorcycle_count" DOUBLE,
  "municipality" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "ped_count" DOUBLE,
  "ped_death_count" DOUBLE,
  "ped_maj_inj_count" DOUBLE,
  "person_count" DOUBLE,
  "police_agcy" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "relation_to_road" DOUBLE,
  "road_condition" DOUBLE,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "small_truck_count" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "suv_count" DOUBLE,
  "tcd_func_cd" DOUBLE,
  "tcd_type" DOUBLE,
  "tfc_detour_ind" VARCHAR,
  "time_of_day" DOUBLE,
  "tot_inj_count" DOUBLE,
  "total_units" DOUBLE,
  "unb_death_count" DOUBLE,
  "unb_maj_inj_count" DOUBLE,
  "unbelted_occ_count" DOUBLE,
  "unk_inj_deg_count" DOUBLE,
  "unk_inj_per_count" DOUBLE,
  "urban_rural" DOUBLE,
  "van_count" DOUBLE,
  "vehicle_count" DOUBLE,
  "weather" DOUBLE,
  "work_zone_ind" VARCHAR,
  "work_zone_loc" DOUBLE,
  "work_zone_type" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" VARCHAR,
  "wz_flagger" VARCHAR,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" VARCHAR,
  "wz_moving" VARCHAR,
  "wz_other" VARCHAR,
  "wz_shlder_mdn" VARCHAR,
  "aggressive_driving" VARCHAR,
  "alcohol_related" VARCHAR,
  "bicycle" VARCHAR,
  "cell_phone" VARCHAR,
  "comm_vehicle" VARCHAR,
  "flag_crn" DOUBLE,
  "cross_median" VARCHAR,
  "curve_dvr_error" VARCHAR,
  "curved_road" VARCHAR,
  "deer_related" VARCHAR,
  "distracted" VARCHAR,
  "drinking_driver" VARCHAR,
  "driver_17yr" VARCHAR,
  "driver_18yr" VARCHAR
);

2019 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2019_crash_data

1.06 MB
12253 rows
191 columns


CREATE TABLE n_2019_crash_data (
  "n__id" BIGINT,
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" BIGINT,
  "hour_of_day" BIGINT,
  "illumination" BIGINT,
  "weather" BIGINT,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" VARCHAR,
  "sch_zone_ind" VARCHAR,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" VARCHAR,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" BIGINT,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" VARCHAR,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" DOUBLE,
  "wz_flagger" DOUBLE,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" DOUBLE,
  "wz_moving" DOUBLE,
  "wz_other" DOUBLE,
  "wz_shlder_mdn" DOUBLE,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT
);

2020 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2020_crash_data

877.79 KB
9863 rows
191 columns


CREATE TABLE n_2020_crash_data (
  "n__id" BIGINT,
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" DOUBLE,
  "hour_of_day" DOUBLE,
  "illumination" BIGINT,
  "weather" DOUBLE,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" DOUBLE,
  "sch_zone_ind" DOUBLE,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" VARCHAR,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" DOUBLE,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" BIGINT,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" DOUBLE,
  "wz_flagger" DOUBLE,
  "wz_law_offcr_ind" DOUBLE,
  "wz_ln_closure" DOUBLE,
  "wz_moving" DOUBLE,
  "wz_other" DOUBLE,
  "wz_shlder_mdn" DOUBLE,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT
);

2021 Crash Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.n_2021_crash_data

1016.48 KB
11726 rows
191 columns


CREATE TABLE n_2021_crash_data (
  "n__id" BIGINT,
  "crash_crn" BIGINT,
  "district" BIGINT,
  "crash_county" BIGINT,
  "municipality" BIGINT,
  "police_agcy" VARCHAR,
  "crash_year" BIGINT,
  "crash_month" BIGINT,
  "day_of_week" BIGINT,
  "time_of_day" DOUBLE,
  "hour_of_day" DOUBLE,
  "illumination" BIGINT,
  "weather" BIGINT,
  "road_condition" BIGINT,
  "collision_type" BIGINT,
  "relation_to_road" BIGINT,
  "intersect_type" BIGINT,
  "tcd_type" BIGINT,
  "urban_rural" BIGINT,
  "location_type" BIGINT,
  "sch_bus_ind" DOUBLE,
  "sch_zone_ind" DOUBLE,
  "total_units" BIGINT,
  "person_count" BIGINT,
  "vehicle_count" BIGINT,
  "automobile_count" BIGINT,
  "motorcycle_count" BIGINT,
  "bus_count" BIGINT,
  "small_truck_count" BIGINT,
  "heavy_truck_count" BIGINT,
  "suv_count" BIGINT,
  "van_count" BIGINT,
  "bicycle_count" BIGINT,
  "fatal_count" BIGINT,
  "injury_count" BIGINT,
  "maj_inj_count" BIGINT,
  "mod_inj_count" VARCHAR,
  "min_inj_count" BIGINT,
  "unk_inj_deg_count" BIGINT,
  "unk_inj_per_count" BIGINT,
  "unbelted_occ_count" BIGINT,
  "unb_death_count" BIGINT,
  "unb_maj_inj_count" BIGINT,
  "belted_death_count" BIGINT,
  "belted_maj_inj_count" BIGINT,
  "mcycle_death_count" BIGINT,
  "mcycle_maj_inj_count" BIGINT,
  "bicycle_death_count" BIGINT,
  "bicycle_maj_inj_count" BIGINT,
  "ped_count" BIGINT,
  "ped_death_count" BIGINT,
  "ped_maj_inj_count" BIGINT,
  "comm_veh_count" BIGINT,
  "max_severity_level" BIGINT,
  "driver_count_16yr" BIGINT,
  "driver_count_17yr" BIGINT,
  "driver_count_18yr" BIGINT,
  "driver_count_19yr" BIGINT,
  "driver_count_20yr" BIGINT,
  "driver_count_50_64yr" BIGINT,
  "driver_count_65_74yr" BIGINT,
  "driver_count_75plus" BIGINT,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "dec_lat" DOUBLE,
  "dec_long" DOUBLE,
  "est_hrs_closed" DOUBLE,
  "lane_closed" BIGINT,
  "ln_close_dir" DOUBLE,
  "ntfy_hiwy_maint" VARCHAR,
  "rdwy_surf_type_cd" DOUBLE,
  "spec_juris_cd" DOUBLE,
  "tcd_func_cd" DOUBLE,
  "tfc_detour_ind" VARCHAR,
  "work_zone_ind" BIGINT,
  "work_zone_type" DOUBLE,
  "work_zone_loc" DOUBLE,
  "cons_zone_spd_lim" DOUBLE,
  "workers_pres" VARCHAR,
  "wz_close_detour" DOUBLE,
  "wz_flagger" DOUBLE,
  "wz_law_offcr_ind" VARCHAR,
  "wz_ln_closure" DOUBLE,
  "wz_moving" DOUBLE,
  "wz_other" DOUBLE,
  "wz_shlder_mdn" DOUBLE,
  "flag_crn" BIGINT,
  "interstate" BIGINT,
  "state_road" BIGINT,
  "local_road" BIGINT,
  "local_road_only" BIGINT,
  "turnpike" BIGINT,
  "wet_road" BIGINT,
  "snow_slush_road" BIGINT,
  "icy_road" BIGINT,
  "sudden_deer" BIGINT,
  "shldr_related" BIGINT,
  "rear_end" BIGINT,
  "ho_oppdir_sdswp" BIGINT,
  "hit_fixed_object" BIGINT
);

Police Agency Codes

@usgov.allegheny_county_city_of_pitts_allegheny_county_crash_data.police_agency_codes

4.56 KB
126 rows
2 columns


CREATE TABLE police_agency_codes (
  "code" BIGINT,
  "policy_agency" VARCHAR
);