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 Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Date of Death | date_of_death | calendar_date | Date of death | 2021-01-30T00:00:00.000 2020-05-08T00:00:00.000 2022-02-15T00:00:00.000 2021-09-02T00:00:00.000 2022-05-03T00:00:00.000 view top 100 |
New Deaths | new_deaths | number | Count of new deaths | 0 1 2 3 4 view top 100 |
Cumulative Deaths | cumulative_deaths | number | Cumulative count of deaths | 568 52 563 562 673 view top 100 |
Data As Of | data_as_of | calendar_date | Timestamp for last update date in source system | 2022-08-17T04:30:01.327 view top 100 |
Data Loaded At | data_loaded_at | calendar_date | Timestamp when data entered the socrata system | 2022-08-17T07:00:08.320 2022-08-17T07:00:08.361 2022-08-17T07:00:08.404 2022-08-17T07:00:08.237 2022-08-17T07:00:08.270 view top 100 |