San Francisco’s response to the coronavirus emergency is grounded in data, science and facts. Because of this, we took decisive action early on. Learn more about our response and see the data in context.

Cumulative number of positive cases and deaths over time.

Map showing confirmed positive COVID-19 cases and rate of cases by population size in San Francisco organized by zip code.

The daily number of COVID-19 tests reported to SFDPH and the proportion of positive test results.

The number of hospitalized patients in San Francisco who either have confirmed COVID-19 or are awaiting test results.

Information on demographics and transmission category for cases and deaths associated with COVID-19.

A snapshot of bed capacity across all San Francisco acute care hospitals.

A. SUMMARY
This dataset represents the COVID-19 positive confirmed cases and deaths by day and transmission type. Demographic and transmission data are based on information reported from case interviews, laboratories, and providers. This data may not be immediately available for recently reported cases and data will change to reflect as information becomes available.

B. HOW THE DATASET IS CREATED
Information on cases and deaths including case demographic and transmission details is reported from a combination of data sources including electronic and faxed laboratory reports, case interviews, medical providers, and electronic medical record systems. These multiple streams of data are merged, deduplicated, undergo quality assurance and other data verification processes, and are continually updated to maximize completeness of information and reporting on San Francisco residents with COVID-19.

C. UPDATE PROCESS
Updated daily, dataset uploaded manually by staff

D. HOW TO USE THIS DATASET
Case counts are provided by category of the disposition. Confirmed are those cases where lab testing was positive, deaths are those cases of infection resulting in death. To get counts in either category, you must filter the Case Type Disposition or pivot the data.

Transmission Category can be Community, Contact or Unknown. Unknowns may become known as more information becomes available about cases.

There are two other datasets related to cases:
1. COVID-19 Cases Summarized by Age Group and Gender
2. COVID-19 Cases Summarized by Race and Ethnicity

The Health Department has developed an inspection report and scoring system. After conducting an inspection of the facility, the Health Inspector calculates a score based on the violations observed. Violations can fall into:high risk category: records specific violations that directly relate to the transmission of food borne illnesses, the adulteration of food products and the contamination of food-contact surfaces.moderate risk category: records specific violations that are of a moderate risk to the public health and safety.low risk category: records violations that are low risk or have no immediate risk to the public health and safety.The score card that will be issued by the inspector is maintained at the food establishment and is available to the public in this dataset.
San Francisco's LIVES restaurant inspection data leverages the LIVES Flattened Schema (https://goo.gl/c3nNvr), which is based on LIVES version 2.0, cited on Yelp's website (http://www.yelp.com/healthscores).

A. SUMMARY
Medical provider confirmed COVID-19 cases in San Francisco, CA aggregated by zip codes and normalized by 2017 American Community Survey (ACS) 5-year estimates for population data to calculate rate per 10,000 residents.

B. HOW THE DATASET IS CREATED
Addresses from medical data are geocoded by the San Francisco Department of Public Health (SFDPH). Those addresses are spatially joined to the Zip Code Tabulation Areas (ZCTA) provided by the U.S. Census. Counts are generated based on the number of address points that match each ZCTA. The 2017 ACS estimates for population provided by the Census are used to create a rate which is equal to [case count] / ([zip code population]/10000) representing the number of cases per 10,000 residents.

The number of cases for any zip code that has fewer than 10 confirmed COVID-19 cases has been re-coded as a null in the dataset in order to protect privacy.

C. UPDATE PROCESS
Geographic analysis is scripted by SFDPH staff and synced to this dataset each day between 10am and 12pm PDT.

D. HOW TO USE THIS DATASET
Caveats and limitations
ZIP Code Tabulation Areas are special boundaries created by the U.S. Census based on ZIP Codes developed by the USPS. They are not, however, the same thing. ZCTAs are areal representations of routes. Read how the Census develops ZCTAs on their website.