Weekly Pennsylvania COVID-19 Vaccinations Stats Archive

Description

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.

Resources

Name Format Description Link
8 This was the archive of data from https://data.pa.gov/Health/COVID-19-Vaccinations-by-Race-Current-County-Healt/x5z9-57ub until the source data's schema was radically changed. https://data.wprdc.org/datastore/dump/9553c0d4-8d95-46d5-829b-59dac67dc3d3
8 Archive of data from https://data.pa.gov/Health/COVID-19-Vaccinations-by-Ethnicity-Current-County-/7ruj-m7k6 https://data.wprdc.org/datastore/dump/a6abdc7e-2ad1-4e7d-9aed-6f49ef309be6
8 Archive of data from https://data.pa.gov/Health/COVID-19-Vaccinations-by-Age-Group-Current-Statewi/xy2e-dqvt https://data.wprdc.org/datastore/dump/cccf0fbf-ad2a-4a7b-953c-fceacc3708c5
8 Archive of data from https://data.pa.gov/Health/COVID-19-Vaccinations-by-Gender-Current-County-Hea/jweg-3ezy https://data.wprdc.org/datastore/dump/3f9fbca0-c47b-4da8-aa0b-9dbd08d0cf93
8 Archive of data from https://data.pa.gov/Health/COVID-19-Vaccinations-by-Gender-Current-Statewide-/id8t-dnk6 https://data.wprdc.org/datastore/dump/de68ec81-464d-422f-a5e8-ec9ab739d3dd
8 Archive of data from https://data.pa.gov/Health/COVID-19-Vaccinations-by-Ethnicity-Current-Statewi/u8hy-smfm https://data.wprdc.org/datastore/dump/c73aebfd-61e4-4141-ae52-ba2b914468b8
8 Archive of data from https://data.pa.gov/Covid-19/COVID-19-Vaccinations-by-Zip-Code-by-Race-Current-/g743-p9su https://data.wprdc.org/datastore/dump/d3f5c6a6-c5f8-48db-8da2-f22a39bc8ef8
8 Archive of data from https://data.pa.gov/Health/COVID-19-Vaccinations-by-Day-by-County-of-Residenc/bicw-3gwi https://data.wprdc.org/datastore/dump/7272bc6b-7c7e-4a7f-9ec0-9ee034e6147e
8 Archive of data from https://data.pa.gov/Health/COVID-19-Pennsylvania-Vaccine-Providers-2nd-Dose-V/8jae-5d8i https://data.wprdc.org/datastore/dump/4a113b3d-7d2c-4f8b-a4f4-7c1373260f75
8 Archive of data from https://data.pa.gov/Health/COVID-19-Vaccinations-by-Race-Current-Statewide-He/e384-bs7r https://data.wprdc.org/datastore/dump/33963feb-e96c-4034-903b-f8fe9d09f498
8 Archive of data from https://data.pa.gov/Health/COVID-19-Retail-Pharmacy-Partners-Vaccine-Allocati/vxbs-jbjq https://data.wprdc.org/datastore/dump/f7db882a-c522-4c21-9a0e-9a17452541bc
8 This was the archive of data from https://data.pa.gov/Health/COVID-19-Vaccinations-by-Ethnicity-Current-County-/7ruj-m7k6 until a change to the source-data schema necessitated the creation of a new archive with resource name " COVID-19 Vaccinations by Ethnicity Current County Health (archive)". https://data.wprdc.org/datastore/dump/e6d4d309-3dde-4e18-a7c6-a96934257d44
8 Straight duplication of CSV file from https://data.pa.gov/Health/COVID-19-Federal-Pharmacy-Partners-Long-Term-Care-/iwiy-rwzp https://data.wprdc.org/dataset/78dfb4f8-2ad5-4a7c-af4c-a5982e475a8a/resource/a0cee71c-809f-42d5-97d0-d8193cdbf1eb/download/weekly_long_term_care_vaccinations.csv
8 Archive of data from https://data.pa.gov/Health/COVID-19-Vaccinations-by-Age-Group-Current-County-/niuh-2xe3 https://data.wprdc.org/datastore/dump/8d45ae5e-9781-4ec3-9b4c-8d2560d54f9d
8 Archive of data from https://data.pa.gov/Health/COVID-19-Weekly-1st-Dose-Vaccine-Allocated-by-Penn/qsii-pka7 https://data.wprdc.org/datastore/dump/7d974d85-c13d-416d-8750-a98f1fecee98
8 Archive of data from https://data.pa.gov/Covid-19/COVID-19-Vaccinations-by-Zip-Code-by-Coverage-Curr/d63n-ygar https://data.wprdc.org/datastore/dump/72cc1e37-b73c-49a3-9c4d-c68d29b88cd5
8 Archive of data from https://data.pa.gov/Covid-19/COVID-19-Vaccinations-by-Zip-Code-by-Ethnicity-Cur/r2jr-ys6g https://data.wprdc.org/datastore/dump/fd96d23d-3089-422b-ae92-8b28e6628ef8
8 Archive of data from https://data.pa.gov/Covid-19/COVID-19-Vaccinations-by-Zip-Code-by-Gender-Curren/x2ja-pwvy https://data.wprdc.org/datastore/dump/c5863e72-37f5-4cbe-a67d-06d06a7f3c10
8 Archive of data from https://data.pa.gov/Health/COVID-19-Vaccinations-by-Residence-Current-County-/gcnb-epac https://data.wprdc.org/datastore/dump/e737675c-bd26-4a37-ade0-d5599ca871f0
8 Archive of data from https://data.pa.gov/Health/COVID-19-Vaccinations-by-Race-Current-County-Healt/x5z9-57ub https://data.wprdc.org/datastore/dump/a6f52fb9-6c3a-40e4-adc4-2bd806b165fd
8 This was the archive of data from https://data.pa.gov/Health/COVID-19-Vaccinations-by-Gender-Current-County-Hea/jweg-3ezy until the source-data schema changed. The new archive can be found under the resource name "COVID-19 Vaccinations by Gender Current County Health (archive)" https://data.wprdc.org/datastore/dump/29feecc2-5329-44d5-9d95-9467203414da
8 This was the archive of data from https://data.pa.gov/Health/COVID-19-Vaccinations-by-Age-Group-Current-County-/niuh-2xe3 The schema for that data source changed so the new archive has the resource name "COVID-19 Vaccinations by Age Group Current County Health (archive)" https://data.wprdc.org/datastore/dump/578f4dc4-c92e-48a4-922e-9bcf9d48a861
8 Archive of data from https://data.pa.gov/Covid-19/COVID-19-Vaccinations-by-Zip-Code-by-Age-Group-Cur/23vq-vzvj https://data.wprdc.org/datastore/dump/25e55b3a-609a-434f-b935-05bc549dafe8

Tags

  • vaccinations
  • _etl
  • covid-19

Topics

  • Local Government

Categories