ARCHIVED: COVID-19 Hospital Capacity by US Government | Healthcare

About this Dataset

ARCHIVED: COVID-19 Hospital Capacity

**Note: As of July 21, 2021, this dataset no longer updates.** A. SUMMARY Data on daily hospital bed use and available capacity at San Francisco acute care hospitals from April 2020 onward. Long Term Care facilities (like Laguna Honda and Kentfield) are not included in this data as acute care patients cannot be admitted to these facilities. B. HOW THE DATASET IS CREATED This hospital capacity information is based on data that all SF acute care hospitals report to the San Francisco Department of Public Health. C. UPDATE PROCESS Updates automatically at 05:00 Pacific Time each day. Redundant runs are scheduled at 07:00 and 09:00 in case of pipeline failure. This data is on a 4-day lag to account for the time needed to complete and validate data from all SF acute care hospitals. D. HOW TO USE THIS DATASET This data provides visibility into current occupancy levels and use of San Francisco acute care hospitals and potential ability to accommodate anticipated surges of COVID patients. Data includes current census of COVID-19 patients (including both confirmed cases and suspected COVID patients) and other patients in acute care hospitals, shown in the “Status” column. The “Status” column also includes all available beds. This daily census information is stratified by type of bed (acute care, intensive care, and surge) in the “Bed Type” column. Acute care beds treat patients with illnesses and injuries including recovery from surgeries. Intensive care (ICU) beds are for sicker patients in need of critical and life support services that can include the use of a ventilator. Surge beds are the additional beds that can be made available to handle an influx of COVID-19 patients; surge beds are differentiated between acute care surge beds and ICU surge beds. Note: The current census of COVID patients shown here may not always match the hospitalizations data (https://data.sfgov.org/COVID-19/COVID-19-Hospitalizations/nxjg-bhem), as that data includes all hospitals and long term care facilities. As described above, those long term care facilities are not included here as they don’t have the capacity to take in additional acute care patients and therefore aren’t included in capacity measures.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:52.414898
Tags: acute, covid, covid-19, hospital, hospital-beds, hospital-capacity, icu, surge

Tables

Table 1

@usgov.city_of_san_francisco_covid_19_hospital_capacity.table_1

19.07 KB
4514 rows
5 columns


CREATE TABLE table_1 (
  "hospital" VARCHAR,
  "date" TIMESTAMP,
  "bed_type" VARCHAR,
  "status" VARCHAR,
  "count" BIGINT
);