Icon for Socrata external plugin
Open repository in Console
Updated 3 days ago
Indexed 4 hours ago

COVID-19 Unusable Vaccine Current County Health

This dataset contains aggregate data by clinic for COVID-19 doses that are reported to the Pennsylvania Statewide Immunization System (PA-SIIS) as waste or spoilage. <br>

Data includes the name, address and county of the clinics and the quantities of doses reported based on CDC’s standard waste reason codes or spoilage. <br>

Spoilage is defined as nonviable, unopened vials of vaccine. This typically includes vaccine that has expired and vaccine that was not kept stored at the correct temperature (due to conditions such as equipment failure).<br>

Wastage is defined as nonviable doses from opened vials. Standard CDC reasons are as follows: <br>


• Broken Vial or Syringe<br>

• Vaccine drawn (into syringe) but not administered<br>

• Lost or unaccounted for vaccine<br>

• Open vial but not administered<br>

• Other <br>


Data only includes information reported to PA-SIIS, the Pennsylvania Statewide Immunization Information System. Providers participating in the COVID-19 Program that are located in Philadelphia County or who are receiving vaccine inventory directly from CDC are not included in this dataset since they do not report inventory information to PA-SIIS.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"pa-gov/covid19-unusable-vaccine-current-county-health-r5v4-zbqw\".\"covid19_unusable_vaccine_current_county_health\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • covid19_unusable_vaccine_current_county_health
Upstream Metadata