COVID-19 Unusable Vaccine Current County Health NO FURTHER UPDATES

Weekly updates have finished.

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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"pa-gov/covid19-unusable-vaccine-current-county-health-no-r5v4-zbqw\".\"covid19_unusable_vaccine_current_county_health_no\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.