COVID-19 Deaths Over Time

data.sfgov.org | Last Updated 17 Aug 2022

Note: On January 22, 2022, system updates to improve the timeliness and accuracy of San Francisco COVID-19 cases and deaths data were implemented. You might see some fluctuations in historic data as a result of this change. <strong>A. SUMMARY</strong> This dataset represents San Francisco COVID-19 related deaths by day. Deaths are included on the date the individual died. Data is lagged by five days, meaning the most date included is 5 days prior to today. All data update daily as more information becomes available. <strong>B. HOW THE DATASET IS CREATED</strong> COVID-19 deaths are suspected to be associated with COVID-19. This means COVID-19 is listed as a cause of death or significant condition on the death certificate. Deaths may be reported by: * Healthcare providers * The California Department of Public Health Vital Records * Case investigation or outbreak investigation * The Office of the Chief Medical Examiner It takes time to process this data. Because of this, data is lagged by 5 days and death totals for previous days may increase or decrease. More recent data is less reliable. Data are continually updated to maximize completeness of information and reporting on San Francisco COVID-19 deaths. <strong>C. UPDATE PROCESS</strong> Updates automatically at 05:00 AM Pacific Time each day. Redundant runs are scheduled at 07:00 AM and 09:00 AM in case of pipeline failure. Dataset will not update on the business day following any federal holiday. <strong>D. HOW TO USE THIS DATASET</strong> 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 <a href="https://data.sfgov.org/d/kkr3-wq7h">Deaths by Population Characteristics dataset</a> to see deaths by different subgroups including race/ethnicity, age, gender, and homelessness.

This dataset has the following 5 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Date of Deathdate_of_deathcalendar_dateDate of death
New Deathsnew_deathsnumberCount of new deaths
Cumulative Deathscumulative_deathsnumberCumulative count of deaths
Data As Ofdata_as_ofcalendar_dateTimestamp for last update date in source system
Data Loaded Atdata_loaded_atcalendar_dateTimestamp when data entered the socrata system