About this Dataset

COVID-19 Hospital Admissions Over Time

**As of 9/12/2024, we have resumed reporting on COVID-19 hospitalization data using a San Francisco specific dataset. These new data differ slightly from previous hospitalization data sources but the overall patterns and trends in hospitalizations remain consistent. You can access the previous data here. ** A. SUMMARY This dataset includes information on COVID+ hospital admissions for San Francisco residents into San Francisco hospitals. Specifically, the dataset includes the count and rate of COVID+ hospital admissions per 100,000. The data are reported by week. B. HOW THE DATASET IS CREATED Hospital admission data is reported to the San Francisco Department of Public Health (SFDPH) via the COVID Hospital Data Repository (CHDR), a system created via health officer order C19-16. The data includes all San Francisco hospitals except for the San Francisco VA Medical Center. San Francisco population estimates are pulled from a view based on the San Francisco Population and Demographic Census dataset. These population estimates are from the 2018-2022 5-year American Community Survey (ACS). C. UPDATE PROCESS Data updates weekly on Wednesday with data for the past Wednesday-Tuesday (one week lag). Data may change as more current information becomes available. D. HOW TO USE THIS DATASET New admissions are the count of COVID+ hospital admissions among San Francisco residents to San Francisco hospitals by week. The admission rate per 100,000 is calculated by multiplying the count of admissions each week by 100,000 and dividing by the population estimate. E. CHANGE LOG
Organization: City of San Francisco
Last updated: 2025-03-29T16:49:45.305705

Tables

Table 1

@usgov.city_of_san_francisco_covid_19_hospital_admissions_over_time.table_1

14.36 kB
272 rows
8 columns

CREATE TABLE table_1 (
  "admission_start_date" TIMESTAMP,
  "admission_end_date" TIMESTAMP,
  "hospital" VARCHAR,
  "total_admissions" BIGINT,
  "rate_of_admissions_per_100k" DOUBLE,
  "sf_population_estimate" BIGINT,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);