About this Dataset

Allegheny County Mortality Indicators

This data includes counts of deaths by race (total, Black, white) by age grouping and cause of death by Census Tract aggregated over a five-year period (2014-18). Data extracted from Pennsylvania's Electronic Death Registry System (EDRS) with the following disclaimer: "These data were provided by the Pennsylvania Department of Health. The Department specifically disclaims responsibility for any analyses, interpretations, or conclusions." Census tract of residence was determined using address-level data. Records were excluded from analysis if address was missing or unmatched to a census tract (≈1% records). Census tracts starting with 980x.xx, 981x.xx, and 982x.xx were also excluded due to a geocoding error. For cause of death by census tract, counts were assessed using census tract by age and race; records were excluded if age, race, or location data were missing. Census-tract level counts < 5 are censored and displayed as NULL. Census-tract-level counts may not equal county-level counts when summed due to censored data or missing data.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:08:34.196177
Tags: cause-of-death, deaths, health, mortality

Tables

Mortality Indicators By Census Tract (2014-2018)

@usgov.allegheny_county_city_of_pitts_allegheny_county_mortal_de8d729d.mortality_indicators_by_census_tract_2014_2018

21.29 KB
388 rows
16 columns


CREATE TABLE mortality_indicators_by_census_tract_2014_2018 (
  "census_tract" BIGINT,
  "black_total_mortality" DOUBLE,
  "white_total_mortality" DOUBLE,
  "total_mortality" BIGINT,
  "alzheimer_s_disease" DOUBLE,
  "cancer" DOUBLE,
  "chronic_liver_disease_and_cirrhosis" DOUBLE,
  "chronic_lower_respiratory_diseases" DOUBLE,
  "diabetes" DOUBLE,
  "flu_and_pneumonia" DOUBLE,
  "heart_disease" DOUBLE,
  "homicide" DOUBLE,
  "septicemia" DOUBLE,
  "stroke" DOUBLE,
  "suicide" DOUBLE,
  "unintentional_injuries" DOUBLE
);

Mortality Indicators County-wide (2014-2018)

@usgov.allegheny_county_city_of_pitts_allegheny_county_mortal_de8d729d.mortality_indicators_county_wide_2014_2018

4.64 KB
286 rows
4 columns


CREATE TABLE mortality_indicators_county_wide_2014_2018 (
  "indicator" VARCHAR,
  "race_label" VARCHAR,
  "age_label" VARCHAR,
  "deaths" BIGINT
);