COVID-19 Aggregate Hospitalizations Current Weekly County Health NO FURTHER UPDATES

Weekly updates have finished with the June 28th update.

“Note: Beginning 7/13/2022, the hospitals are no longer reporting data on airborne isolation beds resulting in null values being displayed for the airborne isolation bed metrics.”

This dataset contains aggregate hospitalization data related to COVID-19 patient which includes availability of ICU beds, patients on ventilators, ventilators in use, and total patients hospitalized data at the state and county level for Pennsylvania residents.

Data will be updated between 11:30 am to 1:30pm each Wednesday.

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-aggregate-hospitalizations-current-weekly-kayn-sjhx\".\"covid19_aggregate_hospitalizations_current_weekly\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.