Allegheny County COVID-19 Vaccinations by US Government | Healthcare

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.027530
Tags: _etl, coronavirus, covid-19, covid19, department-of-health, health, sars-cov-2, vaccinations

Tables

Allegheny County COVID-19 Vaccine Individual Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_covid__fb04dcac.allegheny_county_covid_19_vaccine_individual_data

23.32 MB
947096 rows
11 columns


CREATE TABLE allegheny_county_covid_19_vaccine_individual_data (
  "n__id" BIGINT,
  "indiv_id" VARCHAR,
  "dose_1_vaccination_date" TIMESTAMP,
  "adj_fully_vax_date" TIMESTAMP,
  "adj_mv1_vax_date" TIMESTAMP,
  "adj_mv2_vax_date" TIMESTAMP,
  "adj_bv1_vax_date" TIMESTAMP,
  "age_bucket" VARCHAR,
  "gender" VARCHAR,
  "race" VARCHAR,
  "ethnicity" VARCHAR
);

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.68 KB
221 rows
5 columns


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

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

58.71 KB
5246 rows
6 columns


CREATE TABLE allegheny_county_covid_19_vaccine_historical_municipal_data (
  "n__id" BIGINT,
  "month" TIMESTAMP,
  "neighborhood_municipality" VARCHAR,
  "total_partially_vaccinated" BIGINT,
  "completed_primary_series" BIGINT,
  "bivalent_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

17.87 MB
927826 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

11.78 KB
221 rows
5 columns


CREATE TABLE n__archived_allegheny_county_covid_19_vaccine_municipal_data (
  "n__id" BIGINT,
  "neighborhood_municipality" VARCHAR,
  "total_partially_vaccinated" BIGINT,
  "total_fully_vaccinated" BIGINT,
  "total_fully_vaccinated_w_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

59.74 KB
4657 rows
6 columns


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