About this Dataset

Allegheny County Birth Outcomes

This data includes several different tables presenting counts of births by race (total, Black, white) by Census Tract aggregated over a five-year period (2014-18). Data extracted from Pennsylvania's Vital Statistics Database 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. 2014 used a different methodology to assign census tract compared to years 2015-2018. Counts < 5 are censored and displayed as "None". Census-tract-level counts may not equal county-level counts when summed due to censored data or missing data. For cause of death, underlying cause of death from the death certificate is used and is categorized based on ICD-10 codes, defined below.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:08:34.156669
Tags: births, natality

Tables

Birth Outcomes By Census Tract (2014-2018)

@usgov.allegheny_county_city_of_pitts_allegheny_county_birth_outcomes.birth_outcomes_by_census_tract_2014_2018

18.19 KB
388 rows
10 columns


CREATE TABLE birth_outcomes_by_census_tract_2014_2018 (
  "census_tract" BIGINT,
  "total_births_white" DOUBLE,
  "total_births_black" DOUBLE,
  "total_births_total" BIGINT,
  "low_birthweight" DOUBLE,
  "preterm" DOUBLE,
  "medicaid" DOUBLE,
  "breastfeeding" BIGINT,
  "smoking" DOUBLE,
  "first_trimester_pretal_care" BIGINT
);

Birth Outcomes County-wide (2014-2018)

@usgov.allegheny_county_city_of_pitts_allegheny_county_birth_outcomes.birth_outcomes_county_wide_2014_2018

3.91 KB
48 rows
4 columns


CREATE TABLE birth_outcomes_county_wide_2014_2018 (
  "indicator" VARCHAR,
  "age_label" VARCHAR,
  "race_label" VARCHAR,
  "count" BIGINT
);