About this Dataset

COVID-19 Deaths Over Time

A. SUMMARY This dataset represents San Francisco COVID-19 related deaths by day. This data may not be immediately available for recently reported deaths. Data updates as more information becomes available. Because of this, death totals for previous days may increase or decrease. More recent data is less reliable. B. HOW THE DATASET IS CREATED As of January 1, 2023, COVID-19 deaths are defined as persons who had COVID-19 listed as a cause of death or a significant condition contributing to their death on their death certificate. This definition is in alignment with the California Department of Public Health and the national Council of State and Territorial Epidemiologists. Death data is provided by the California Department of Public Health. It takes time to process this data. Because of this, death totals may increase or decrease over time. Data are continually updated to maximize completeness of information and reporting on San Francisco COVID-19 deaths. C. UPDATE PROCESS Updates automatically at 06:30 and 07:30 AM Pacific Time on Wednesday each week. Dataset will not update on the business day following any federal holiday. D. HOW TO USE THIS DATASET This dataset shows new deaths and cumulative deaths by date of death. New deaths are the count of deaths on that specific date. Cumulative deaths are the running total of all San Francisco COVID-19 deaths up to the date listed. Use the Deaths by Population Characteristics Over Time dataset to see deaths by different subgroups including race/ethnicity, age, and gender. E. CHANGE LOG

9/11/2023 – on this date, we began using an updated definition of a COVID-19 death to align with the California Department of Public Health. This change was applied to COVID-19 deaths retrospectively beginning on 1/1/2023. More information about the recommendation by the Council of State and Territorial Epidemiologists that motivated this change can be found here.
4/6/2023 - the State implemented system updates to improve the integrity of historical data.
1/22/2022 - system updates to improve timeliness and accuracy of cases and deaths data were implemented.
Organization: City of San Francisco
Last updated: 2021-08-07T18:41:14.163620

Tables

Table 1

@usgov.city_of_san_francisco_covid_19_deaths_over_time.table_1

21.77 kB
1,891 rows
5 columns

CREATE TABLE table_1 (
  "date_of_death" VARCHAR,
  "new_deaths" BIGINT,
  "cumulative_deaths" BIGINT,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);