Icon for Socrata external plugin
Open repository in Console
Updated 7 months ago
Indexed 1 hour ago

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"pa-gov/covid19-aggregate-hospitalizations-current-weekly-kayn-sjhx\".\"covid19_aggregate_hospitalizations_current_weekly\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • covid19_aggregate_hospitalizations_current_weekly
Upstream Metadata