pa-gov/covid19-aggregate-hospitalizations-current-weekly-kayn-sjhx
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 7 days ago
Indexed 4 hours ago

COVID-19 Aggregate Hospitalizations Current Weekly County Health

“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.

 
Preview
  • covid19_aggregate_hospitalizations_current_weekly
     
     
     
     
     
Upstream Metadata