About this Dataset

Weekly Pennsylvania COVID-19 Vaccinations Stats Archive

Weekly archive of some State of Pennsylvania datasets found in this list: https://data.pa.gov/browse?q=vaccinations

For most of these datasets, the "date_saved" field is the date that the WPRDC pulled the data from the state data portal and the archive combines all the saved records into one table. The exception to this is the "COVID-19 Vaccinations by Day by County of Residence Current Health (archive)" which is already published by the state as an entire history.

The "date_updated" field is based on the date that the "updatedAt" field from the corresponding data.pa.gov dataset. Changes to this field have turned out to not be a good indicator of whether records have updated, which is why we are archiving this data on a weekly basis without regard to the "updatedAt" value. The "date_saved" field is the one you should sort on to see the variation in vaccinations over time.

Most of the source tables have gone through schema changes or expansions. In some cases, we've kept the old archives under a separate resource with something like "[Orphaned Schema]" added to the resource name. In other cases, we've adjusted our schema to accommodate new column names, but there will be a date range during which the new columns have null values because we did not start pulling them until we became aware of them.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:59:49.478789
Tags: _etl, covid-19, vaccinations

Tables

COVID-19 Pennsylvania Vaccine Providers 2nd Dose Vaccine Allocation Current Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_pennsylvania_vaccine_providers_2nd_dose_vacci_d5dcba66

8.01 MB
615,814 rows
18 columns

CREATE TABLE covid_19_pennsylvania_vaccine_providers_2nd_dose_vacci_d5dcba66 (
  "n__id" BIGINT  -- Id,
  "date_saved" TIMESTAMP,
  "clinic_name" VARCHAR,
  "clinic_address" VARCHAR,
  "clinic_suite" VARCHAR,
  "clinic_address_additional" VARCHAR,
  "clinic_city" VARCHAR,
  "clinic_state" VARCHAR,
  "clinic_zip_code" BIGINT,
  "county_name" VARCHAR,
  "number_of_doses_allocated" DOUBLE,
  "most_recent_order_date" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "total_pfizer_ordered" DOUBLE,
  "total_moderna_ordered" DOUBLE,
  "total_janssen_ordered" DOUBLE,
  "date_updated" TIMESTAMP
);

COVID-19 Retail Pharmacy Partners Vaccine Allocation Current Health (mirror)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_retail_pharmacy_partners_vaccine_allocation_c_9ad7e095

1.34 MB
73,224 rows
15 columns

CREATE TABLE covid_19_retail_pharmacy_partners_vaccine_allocation_c_9ad7e095 (
  "n__id" BIGINT  -- Id,
  "date_saved" TIMESTAMP,
  "retail_pharmacy_partner_name" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "vaccine" VARCHAR,
  "date" TIMESTAMP,
  "doses" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "date_updated" TIMESTAMP
);

COVID-19 Vaccinations By Age Group Current County Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_vaccinations_by_age_group_current_county_heal_c9f80356

1.52 MB
15,028 rows
114 columns

CREATE TABLE covid_19_vaccinations_by_age_group_current_county_heal_c9f80356 (
  "n__id" BIGINT  -- Id,
  "date_saved" TIMESTAMP,
  "county_name" VARCHAR,
  "partially_covered_age_group_0_4" DOUBLE,
  "partially_covered_age_group_5_9" DOUBLE,
  "partially_covered_age_group_10_14" DOUBLE,
  "partially_covered_age_group_15_19" DOUBLE,
  "partially_covered_age_group_20_24" DOUBLE,
  "partially_covered_age_group_25_29" BIGINT,
  "partially_covered_age_group_30_34" DOUBLE,
  "partially_covered_age_group_35_39" BIGINT,
  "partially_covered_age_group_40_44" BIGINT,
  "partially_covered_age_group_45_49" BIGINT,
  "partially_covered_age_group_50_54" BIGINT,
  "partially_covered_age_group_55_59" BIGINT,
  "partially_covered_age_group_60_64" BIGINT,
  "partially_covered_age_group_65_69" BIGINT,
  "partially_covered_age_group_70_74" BIGINT,
  "partially_covered_age_group_75_79" BIGINT,
  "partially_covered_age_group_80_84" DOUBLE,
  "partially_covered_age_group_85_89" DOUBLE,
  "partially_covered_age_group_90_94" DOUBLE,
  "partially_covered_age_group_95_99" DOUBLE,
  "partially_covered_age_group_100_104" DOUBLE,
  "partially_covered_age_group_105_plus" DOUBLE,
  "fully_covered_age_group_0_4" DOUBLE,
  "fully_covered_age_group_5_9" DOUBLE,
  "fully_covered_age_group_10_14" DOUBLE,
  "fully_covered_age_group_15_19" DOUBLE,
  "fully_covered_age_group_20_24" BIGINT,
  "fully_covered_age_group_25_29" BIGINT,
  "fully_covered_age_group_30_34" BIGINT,
  "fully_covered_age_group_35_39" BIGINT,
  "fully_covered_age_group_40_44" BIGINT,
  "fully_covered_age_group_45_49" BIGINT,
  "fully_covered_age_group_50_54" BIGINT,
  "fully_covered_age_group_55_59" BIGINT,
  "fully_covered_age_group_60_64" BIGINT,
  "fully_covered_age_group_65_69" BIGINT,
  "fully_covered_age_group_70_74" BIGINT,
  "fully_covered_age_group_75_79" BIGINT,
  "fully_covered_age_group_80_84" BIGINT,
  "fully_covered_age_group_85_89" BIGINT,
  "fully_covered_age_group_94_94" BIGINT,
  "fully_covered_age_group_95_99" DOUBLE,
  "fully_covered_age_group_100_104" DOUBLE,
  "fully_covered_age_group_105_plus" DOUBLE,
  "additional_dose_1_age_group_0_4" VARCHAR,
  "additional_dose_1_age_group_5_9" DOUBLE,
  "additional_dose_1_age_group_10_14" DOUBLE,
  "additional_dose_1_age_group_15_19" DOUBLE,
  "additional_dose_1_age_group_20_24" DOUBLE,
  "additional_dose_1_age_group_25_29" DOUBLE,
  "additional_dose_1_age_group_30_34" DOUBLE,
  "additional_dose_1_age_group_35_39" DOUBLE,
  "additional_dose_1_age_group_40_44" DOUBLE,
  "additional_dose_1_age_group_45_49" DOUBLE,
  "additional_dose_1_age_group_50_54" DOUBLE,
  "additional_dose_1_age_group_55_59" DOUBLE,
  "additional_dose_1_age_group_60_64" DOUBLE,
  "additional_dose_1_age_group_65_69" DOUBLE,
  "additional_dose_1_age_group_70_74" DOUBLE,
  "additional_dose_1_age_group_75_79" DOUBLE,
  "additional_dose_1_age_group_80_84" DOUBLE,
  "additional_dose_1_age_group_85_89" DOUBLE,
  "additional_dose_1_age_group_90_94" DOUBLE,
  "additional_dose_1_age_group_95_99" DOUBLE,
  "additional_dose1_age_group_100_104" DOUBLE,
  "additional_dose_1_age_group_105_plus" DOUBLE,
  "additional_dose_2_age_group_0_4" VARCHAR,
  "additional_dose_2_age_group_5_9" VARCHAR,
  "additional_dose_2_age_group_10_14" DOUBLE,
  "additional_dose_2_age_group_15_19" DOUBLE,
  "additional_dose_2_age_group_20_24" DOUBLE,
  "additional_dose_2_age_group_25_29" DOUBLE,
  "additional_dose_2_age_group_30_34" DOUBLE,
  "additional_dose_2_age_group_35_39" DOUBLE,
  "additional_dose_2_age_group_40_44" DOUBLE,
  "additional_dose_2_age_group_45_49" DOUBLE,
  "additional_dose_2_age_group_50_54" DOUBLE,
  "additional_dose_2_age_group_55_59" DOUBLE,
  "additional_dose_2_age_group_60_64" DOUBLE,
  "additional_dose_2_age_group_65_69" DOUBLE,
  "additional_dose_2_age_group_70_74" DOUBLE,
  "additional_dose_2_age_group_75_79" DOUBLE,
  "additional_dose_2_age_group_80_84" DOUBLE,
  "additional_dose_2_age_group_85_89" DOUBLE,
  "additional_dose_2_age_group_90_94" DOUBLE,
  "additional_dose_2_age_group_95_99" DOUBLE,
  "additional_dose_2_age_group_100_104" DOUBLE,
  "additional_dose_2_age_group_105_plus" DOUBLE,
  "bivalent_booster1_age_group_0_4" VARCHAR,
  "bivalent_booster1_age_group_5_9" DOUBLE,
  "bivalent_booster1_age_group_10_14" DOUBLE,
  "bivalent_booster1_age_group_15_19" DOUBLE,
  "bivalent_booster1_age_group_20_24" DOUBLE,
  "bivalent_booster1_age_group_25_29" DOUBLE,
  "bivalent_booster1_age_group_30_34" DOUBLE,
  "bivalent_booster1_age_group_35_39" DOUBLE,
  "bivalent_booster1_age_group_40_44" DOUBLE
);

COVID-19 Vaccinations By Age Group Current Statewide Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_vaccinations_by_age_group_current_statewide_h_b6b18f90

85 kB
4,817 rows
9 columns

CREATE TABLE covid_19_vaccinations_by_age_group_current_statewide_h_b6b18f90 (
  "n__id" BIGINT  -- Id,
  "date_saved" TIMESTAMP,
  "age_group" VARCHAR,
  "partially_covered" BIGINT,
  "fully_covered" BIGINT,
  "additional_dose_1" DOUBLE,
  "additional_dose_2" DOUBLE,
  "bivalent_booster_1" DOUBLE,
  "date_updated" TIMESTAMP
);

COVID-19 Vaccinations By Ethnicity Current County Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_vaccinations_by_ethnicity_current_county_heal_cc016983

463.86 kB
15,028 rows
19 columns

CREATE TABLE covid_19_vaccinations_by_ethnicity_current_county_heal_cc016983 (
  "n__id" BIGINT  -- Id,
  "date_saved" TIMESTAMP,
  "county_name" VARCHAR,
  "partially_covered_hispanic" DOUBLE,
  "partially_covered_not_hispanic" BIGINT,
  "partially_covered_unknown" BIGINT,
  "fully_covered_hispanic" DOUBLE,
  "fully_covered_not_hispanic" BIGINT,
  "fully_covered_unknown" BIGINT,
  "additional_dose_1_hispanic" DOUBLE,
  "additional_dose_1_not_hispanic" DOUBLE,
  "additional_dose_1_unknown" DOUBLE,
  "additional_dose_2_hispanic" DOUBLE,
  "additional_dose_2_not_hispanic" DOUBLE,
  "additional_dose_2_unknown" DOUBLE,
  "bivalent_booster_1_hispanic" DOUBLE,
  "bivalent_booster_1_not_hispanic" DOUBLE,
  "bivalent_booster_1_unkown" DOUBLE,
  "date_updated" TIMESTAMP
);

COVID-19 Vaccinations By Ethnicity Current Statewide Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_vaccinations_by_ethnicity_current_statewide_h_93da7bc7

19.97 kB
666 rows
9 columns

CREATE TABLE covid_19_vaccinations_by_ethnicity_current_statewide_h_93da7bc7 (
  "n__id" BIGINT  -- Id,
  "date_saved" TIMESTAMP,
  "ethnicity" VARCHAR,
  "partially_covered" BIGINT,
  "fully_covered" BIGINT,
  "additional_dose_1" DOUBLE,
  "additional_dose_2" DOUBLE,
  "bivalent_booster_1" DOUBLE,
  "date_updated" TIMESTAMP
);

COVID-19 Vaccinations By Gender Current County Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_vaccinations_by_gender_current_county_health_archive

335.39 kB
15,028 rows
19 columns

CREATE TABLE covid_19_vaccinations_by_gender_current_county_health_archive (
  "n__id" BIGINT  -- Id,
  "date_saved" TIMESTAMP,
  "county_name" VARCHAR,
  "partially_covered_female" BIGINT,
  "partially_covered_male" BIGINT,
  "partially_covered_unknown" DOUBLE,
  "fully_covered_female" BIGINT,
  "fully_covered_male" BIGINT,
  "fully_covered_unknown" DOUBLE,
  "additional_dose_1_female" DOUBLE,
  "additional_dose_1_male" DOUBLE,
  "additional_dose_1_unknown" DOUBLE,
  "additional_dose_2_female" DOUBLE,
  "additional_dose_2_male" DOUBLE,
  "additional_dose_2_unknown" DOUBLE,
  "bivalent_booster1_female" DOUBLE,
  "bivalent_booster1_male" DOUBLE,
  "bivalent_booster1_unknown" DOUBLE,
  "date_updated" TIMESTAMP
);

COVID-19 Vaccinations By Gender Current Statewide Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_vaccinations_by_gender_current_statewide_heal_981e7d62

17.11 kB
666 rows
9 columns

CREATE TABLE covid_19_vaccinations_by_gender_current_statewide_heal_981e7d62 (
  "n__id" BIGINT  -- Id,
  "date_saved" TIMESTAMP,
  "gender" VARCHAR,
  "partially_covered" BIGINT,
  "fully_covered" BIGINT,
  "additional_dose_1" DOUBLE,
  "additional_dose_2" DOUBLE,
  "bivalent_booster_1" DOUBLE,
  "date_updated" TIMESTAMP
);

COVID-19 Vaccinations By Race Current County Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_vaccinations_by_race_current_county_health_archive

762.46 kB
15,164 rows
39 columns

CREATE TABLE covid_19_vaccinations_by_race_current_county_health_archive (
  "n__id" BIGINT  -- Id,
  "date_saved" TIMESTAMP,
  "county_name" VARCHAR,
  "partially_covered_african_american" DOUBLE,
  "partially_covered_asian" DOUBLE,
  "partially_covered_native_american" DOUBLE,
  "partially_covered_pacific_islander" DOUBLE,
  "partially_covered_multiple_other" DOUBLE,
  "partially_covered_white" BIGINT,
  "partially_covered_unknown" DOUBLE,
  "fully_covered_african_american" DOUBLE,
  "fully_covered_asian" DOUBLE,
  "fully_covered_native_american" DOUBLE,
  "fully_covered_pacific_islander" DOUBLE,
  "fully_covered_multiple_other" BIGINT,
  "fully_covered_white" BIGINT,
  "fully_covered_unknown" BIGINT,
  "additional_dose_1_african_american" DOUBLE,
  "additional_dose_1_asian" DOUBLE,
  "additional_dose_1_native_american" DOUBLE,
  "additional_dose_1_pacific_islander" DOUBLE,
  "additional_dose_1_multiple_other" DOUBLE,
  "additional_dose_1_white" DOUBLE,
  "additional_dose_1_unknown" DOUBLE,
  "additional_dose_2_african_american" DOUBLE,
  "additional_dose_2_asian" DOUBLE,
  "additional_dose_2_native_american" DOUBLE,
  "additional_dose_2_pacific_islander" DOUBLE,
  "additional_dose_2_multiple_other" DOUBLE,
  "additional_dose_2_white" DOUBLE,
  "additional_dose_2_unknown" DOUBLE,
  "bivalent_booster_1_african_american" DOUBLE,
  "bivalent_booster_1_asian" DOUBLE,
  "bivalent_booster_1_native_american" DOUBLE,
  "bivalent_booster_1_pacific_islander" DOUBLE,
  "bivalent_booster_1_multiple_other" DOUBLE,
  "bivalent_booster_1_white" DOUBLE,
  "bivalent_booster_1_unknown" DOUBLE,
  "date_updated" TIMESTAMP
);

COVID-19 Vaccinations By Race Current Statewide Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_vaccinations_by_race_current_statewide_health_archive

27.94 kB
1,568 rows
9 columns

CREATE TABLE covid_19_vaccinations_by_race_current_statewide_health_archive (
  "n__id" BIGINT  -- Id,
  "date_saved" TIMESTAMP,
  "race" VARCHAR,
  "partially_covered" BIGINT,
  "fully_covered" BIGINT,
  "additional_dose_1" DOUBLE,
  "additional_dose_2" DOUBLE,
  "bivalent_booster_1" DOUBLE,
  "date_updated" TIMESTAMP
);

COVID-19 Vaccinations By Zip Code By Age Group Current Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_vaccinations_by_zip_code_by_age_group_current_06a7e517

19.36 MB
664,594 rows
46 columns

CREATE TABLE covid_19_vaccinations_by_zip_code_by_age_group_current_06a7e517 (
  "n__id" BIGINT  -- Id,
  "date_updated" TIMESTAMP,
  "patient_zip_code" BIGINT,
  "partially_covered_10_14" DOUBLE,
  "partially_covered_15_19" DOUBLE,
  "partially_covered_20_24" DOUBLE,
  "partially_covered_25_29" DOUBLE,
  "partially_covered_30_34" DOUBLE,
  "partially_covered_35_39" DOUBLE,
  "partially_covered_40_44" DOUBLE,
  "partially_covered_45_49" DOUBLE,
  "partially_covered_50_54" DOUBLE,
  "partially_covered_55_59" DOUBLE,
  "partially_covered_60_64" DOUBLE,
  "partially_covered_65_69" DOUBLE,
  "partially_covered_70_74" DOUBLE,
  "partially_covered_75_79" DOUBLE,
  "partially_covered_80_84" DOUBLE,
  "partially_covered_85_89" DOUBLE,
  "partially_covered_90_94" DOUBLE,
  "partially_covered_95_99" DOUBLE,
  "partially_covered_100_104" DOUBLE,
  "partially_covered_105_plus" DOUBLE,
  "fully_covered_10_14" DOUBLE,
  "fully_covered_15_19" DOUBLE,
  "fully_covered_20_24" DOUBLE,
  "fully_covered_25_29" DOUBLE,
  "fully_covered_30_34" DOUBLE,
  "fully_covered_35_39" DOUBLE,
  "fully_covered_40_44" DOUBLE,
  "fully_covered_45_49" DOUBLE,
  "fully_covered_50_54" DOUBLE,
  "fully_covered_55_59" DOUBLE,
  "fully_covered_60_64" DOUBLE,
  "fully_covered_65_69" DOUBLE,
  "fully_covered_70_74" DOUBLE,
  "fully_covered_75_79" DOUBLE,
  "fully_covered_80_84" DOUBLE,
  "fully_covered_85_89" DOUBLE,
  "fully_covered_90_94" DOUBLE,
  "fully_covered_95_99" DOUBLE,
  "fully_covered_100_104" DOUBLE,
  "fully_covered_105_plus" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "date_saved" TIMESTAMP
);

COVID-19 Vaccinations By Zip Code By Coverage Current Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_vaccinations_by_zip_code_by_coverage_current__0ca96c2d

6.53 MB
664,586 rows
8 columns

CREATE TABLE covid_19_vaccinations_by_zip_code_by_coverage_current__0ca96c2d (
  "n__id" BIGINT  -- Id,
  "date_updated" TIMESTAMP,
  "patient_zip_code" BIGINT,
  "partially_covered" DOUBLE,
  "fully_covered" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "date_saved" TIMESTAMP
);

COVID-19 Vaccinations By Zip Code By Ethnicity Current Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_vaccinations_by_zip_code_by_ethnicity_current_b3483905

9.17 MB
664,594 rows
12 columns

CREATE TABLE covid_19_vaccinations_by_zip_code_by_ethnicity_current_b3483905 (
  "n__id" BIGINT  -- Id,
  "date_updated" TIMESTAMP,
  "patient_zip_code" BIGINT,
  "partially_covered_hispanic" DOUBLE,
  "partially_covered_not_hispanic" DOUBLE,
  "partially_covered_unknown" DOUBLE,
  "fully_covered_hispanic" DOUBLE,
  "fully_covered_not_hispanic" DOUBLE,
  "fully_covered_unknown" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "date_saved" TIMESTAMP
);

COVID-19 Vaccinations By Zip Code By Gender Current Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_vaccinations_by_zip_code_by_gender_current_he_a99c24b9

10.28 MB
664,594 rows
13 columns

CREATE TABLE covid_19_vaccinations_by_zip_code_by_gender_current_he_a99c24b9 (
  "n__id" BIGINT  -- Id,
  "date_updated" TIMESTAMP,
  "patient_zip_code" BIGINT,
  "partially_covered_female" DOUBLE,
  "partially_covered_male" DOUBLE,
  "partially_covered_unknown" DOUBLE,
  "fully_covered_female" DOUBLE,
  "fully_covered_male" DOUBLE,
  "fully_covered_unknown" DOUBLE,
  "georeferenced_point" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "date_saved" TIMESTAMP
);

COVID-19 Vaccinations By Zip Code By Race Current Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_vaccinations_by_zip_code_by_race_current_heal_97233290

11.13 MB
664,594 rows
20 columns

CREATE TABLE covid_19_vaccinations_by_zip_code_by_race_current_heal_97233290 (
  "n__id" BIGINT  -- Id,
  "date_updated" TIMESTAMP,
  "patient_zip_code" BIGINT,
  "partially_covered_african_american" DOUBLE,
  "partially_covered_asian" DOUBLE,
  "partially_covered_native_american" DOUBLE,
  "partially_covered_pacific_islander" DOUBLE,
  "partially_covered_multiple_other" DOUBLE,
  "partially_covered_white" DOUBLE,
  "partially_covered_unknown" DOUBLE,
  "fully_covered_african_american" DOUBLE,
  "fully_covered_asian" DOUBLE,
  "fully_covered_native_american" DOUBLE,
  "fully_covered_pacific_islander" DOUBLE,
  "fully_covered_multiple_other" DOUBLE,
  "fully_covered_white" DOUBLE,
  "fully_covered_unknown" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "date_saved" TIMESTAMP
);

COVID-19 Weekly 1st Dose Vaccine Allocated By Pennsylvania To Providers Current Health (archive)

@usgov.allegheny_county_city_of_pitts_weekly_pennsylvania_cov_8e005576.covid_19_weekly_1st_dose_vaccine_allocated_by_pennsylv_32b7af57

4.92 MB
454,208 rows
19 columns

CREATE TABLE covid_19_weekly_1st_dose_vaccine_allocated_by_pennsylv_32b7af57 (
  "n__id" BIGINT  -- Id,
  "date_saved" TIMESTAMP,
  "covid_19_vaccine_clinic_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "county_name" VARCHAR,
  "data_as_of_date" TIMESTAMP,
  "clinic_web_site" VARCHAR,
  "phone_number" VARCHAR,
  "number_of_doses_allocated" DOUBLE,
  "federal_allocation" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "total_pfizer_ordered" DOUBLE,
  "total_moderna_ordered" DOUBLE,
  "total_janssen_ordered" DOUBLE,
  "date_updated" TIMESTAMP
);