About this Dataset

Allegheny County COVID-19 Vaccinations

COVID-19 Vaccination data as reported by the County's health department.

This dataset contains 3 tables:

Allegheny County COVID-19 Vaccine Individual Data: Contains vaccination information on an individual level
Allegheny County COVID-19 Vaccine Municipal Data: Contains counts for each vaccination status for all neighborhoods in Allegheny County within the last 30 days
Allegheny County COVID-19 Vaccine Historical Municipal Data: Contains historical counts for each vaccination status for all neighborhoods in Allegheny County

Types of Vaccination Status:

Partially Vaccinated: If an individual has not completed their primary series with either 1 of 2-dose series or 2 of 3-dose series for children under the age of 5 years
Completed Primary Series (formerly Fully Vaccinated): If an individual has completed their primary series with the 1-dose J&J series, 2-dose series, or 3-dose series for children under 5 years.
Bivalent Booster: If an individual has obtained their bivalent booster dose.

Due to minor discrepancies in the Municipal boundary and the City of Pittsburgh Neighborhood files individuals whose City Neighborhood cannot be identified are be counted as “Undefined (Pittsburgh)”.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-05-14T23:26:25.027535
Tags: _etl, coronavirus, covid-19, covid19, department-of-health, health, sars-cov-2, vaccinations

Tables

Allegheny County COVID-19 Vaccine Historical Municipal Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_covid__fb04dcac.allegheny_county_covid_19_vaccine_historical_municipal_data

60.12 kB
5,246 rows
6 columns

CREATE TABLE allegheny_county_covid_19_vaccine_historical_municipal_data (
  "n__id" BIGINT  -- Id,
  "month" TIMESTAMP,
  "neighborhood_municipality" VARCHAR,
  "total_partially_vaccinated" BIGINT,
  "completed_primary_series" BIGINT,
  "bivalent_booster" BIGINT
);

Allegheny County COVID-19 Vaccine Municipal Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_covid__fb04dcac.allegheny_county_covid_19_vaccine_municipal_data

11.96 kB
221 rows
5 columns

CREATE TABLE allegheny_county_covid_19_vaccine_municipal_data (
  "n__id" BIGINT  -- Id,
  "neighborhood_municipality" VARCHAR,
  "total_partially_vaccinated" BIGINT,
  "completed_primary_series" BIGINT,
  "bivalent_booster" BIGINT
);

[Archived] Allegheny County COVID-19 Vaccine Historical Municipal Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_covid__fb04dcac.n__archived_allegheny_county_covid_19_vaccine_historic_94bd1c20

61.18 kB
4,657 rows
6 columns

CREATE TABLE n__archived_allegheny_county_covid_19_vaccine_historic_94bd1c20 (
  "n__id" BIGINT  -- Id,
  "month" TIMESTAMP,
  "neighborhood_municipality" VARCHAR,
  "total_partially_vaccinated" BIGINT,
  "total_fully_vaccinated" BIGINT,
  "total_fully_vaccinated_w_booster" BIGINT
);

[Archived] Allegheny County COVID-19 Vaccine Individual Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_covid__fb04dcac.n__archived_allegheny_county_covid_19_vaccine_individual_data

18.73 MB
927,826 rows
12 columns

CREATE TABLE n__archived_allegheny_county_covid_19_vaccine_individual_data (
  "indiv_id" VARCHAR,
  "vaccination_status" VARCHAR,
  "dose_1_vaccine_brand" VARCHAR,
  "dose_1_vaccination_date" TIMESTAMP,
  "dose_2_vaccine_brand" VARCHAR,
  "dose_2_vaccination_date" TIMESTAMP,
  "ad1_vaccine_brand" VARCHAR,
  "ad1_vaccination_date" TIMESTAMP,
  "age_bucket" VARCHAR,
  "gender" VARCHAR,
  "race" VARCHAR,
  "ethnicity" VARCHAR
);

[Archived] Allegheny County COVID-19 Vaccine Municipal Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_covid__fb04dcac.n__archived_allegheny_county_covid_19_vaccine_municipal_data

12.06 kB
221 rows
5 columns

CREATE TABLE n__archived_allegheny_county_covid_19_vaccine_municipal_data (
  "n__id" BIGINT  -- Id,
  "neighborhood_municipality" VARCHAR,
  "total_partially_vaccinated" BIGINT,
  "total_fully_vaccinated" BIGINT,
  "total_fully_vaccinated_w_booster" BIGINT
);