About this Dataset

Westmoreland County Crash Data

Contains locations and information about every crash incident reported to the police in Westmoreland County from 2011 to 2015. 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.

**This data is historical only, but new data can be found on PennDOT's Crash Download Map tool linked in the Resources section.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:08:50.287468

Tables

Municipality Codes

@usgov.allegheny_county_city_of_pitts_westmoreland_county_crash_data.municipality_codes

3.58 kB
65 rows
2 columns

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

2011 Crash Data

@usgov.allegheny_county_city_of_pitts_westmoreland_county_crash_data.n_2011_crash_data

430.92 kB
3,413 rows
189 columns

CREATE TABLE n_2011_crash_data (
  "n__id" BIGINT  -- Id,
  "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
);

2012 Crash Data

@usgov.allegheny_county_city_of_pitts_westmoreland_county_crash_data.n_2012_crash_data

423.53 kB
3,336 rows
189 columns

CREATE TABLE n_2012_crash_data (
  "n__id" BIGINT  -- Id,
  "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
);

2013 Crash Data

@usgov.allegheny_county_city_of_pitts_westmoreland_county_crash_data.n_2013_crash_data

418.22 kB
3,221 rows
189 columns

CREATE TABLE n_2013_crash_data (
  "n__id" BIGINT  -- Id,
  "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
);

2014 Crash Data

@usgov.allegheny_county_city_of_pitts_westmoreland_county_crash_data.n_2014_crash_data

416.94 kB
3,274 rows
189 columns

CREATE TABLE n_2014_crash_data (
  "n__id" BIGINT  -- Id,
  "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
);

Police Agency Codes

@usgov.allegheny_county_city_of_pitts_westmoreland_county_crash_data.police_agency_codes

3.25 kB
44 rows
2 columns

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