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. Due to the changes, starting on January 22, 2022, the number of new cases reported daily will be higher than under the old system as cases that would have taken longer to process will be reported earlier.

Note: On September 12, 2021, a new case definition of COVID-19 was introduced that includes criteria for enumerating new infections after previous probable or confirmed infections (also known as reinfections). A reinfection is defined as a confirmed positive PCR lab test more than 90 days after a positive PCR or antigen test. The first reinfection case was identified on December 7, 2021. Some fluctuation in historic data may result when this change is implemented on July 15, 2022.

A. SUMMARY
This dataset represents San Francisco COVID-19 positive confirmed cases by vaccination status over time, starting January 1, 2021. Cases are included on the date the positive test was collected (the specimen collection date). Cases are counted in four categories: (1) all cases; (2) unvaccinated cases; (3) partially vaccinated cases; and (4) fully vaccinated cases.

1. All cases: Includes cases among all San Francisco residents regardless of vaccination status.

2. Unvaccinated cases: Cases are considered unvaccinated if their positive COVID-19 test was before receiving any vaccine. Cases that are not matched to a COVID-19 vaccination record are considered unvaccinated.

3. Partially vaccinated cases: Cases are considered partially vaccinated if their positive COVID-19 test was after they received at least one dose of a COVID-19 vaccine, but their positive test had been fewer than 14 days since the final dose in their vaccine series. Individuals who have only received one dose of a two-dose vaccine on the date of the positive test are also considered partially vaccinated.

4. Fully vaccinated cases: Cases are considered fully vaccinated if their positive COVID-19 test was 14 days or more after they received their 2nd dose in a 2-dose COVID-19 series or the single dose of a 1-dose vaccine. These are also called “breakthrough cases.”

Data is lagged by eight days, meaning the most recent specimen collection date included is eight days prior to today. All data updates daily as more information becomes available.

B. HOW THE DATASET IS CREATED
Case information is based on confirmed positive laboratory tests reported to the City. The City then completes quality assurance and other data verification processes. Vaccination data comes from the California Immunization Registry (CAIR2). The California Department of Public Health runs CAIR2. Individual-level case and vaccination data are matched to identify cases by vaccination status in this dataset. Case records are matched to vaccine records using first name, last name, date of birth, phone number, and email address.

We include vaccination records from all nine Bay Area counties in order to improve matching rates. This allows us to identify breakthrough cases among people who moved to the City from other Bay Area counties after completing their vaccine series. Only cases among San Francisco residents are included.

C. UPDATE PROCESS
Updates automatically at 08:00 AM Pacific Time each day.

D. HOW TO USE THIS DATASET
The dataset includes new cases, 7-day average new cases, new case rates, 7-day average new case rates, percent of total cases, and 7-day average percent of total cases for each vaccination category.

New cases are the coun

A. SUMMARY
Data on daily hospital bed use and available capacity at San Francisco acute care hospitals from April 2020 onward. Long Term Care facilities (like Laguna Honda and Kentfield) are not included in this data as acute care patients cannot be admitted to these facilities.
B. HOW THE DATASET IS CREATED
This hospital capacity information is based on data that all SF acute care hospitals report to the San Francisco Department of Public Health.
C. UPDATE PROCESS
Updates automatically at 05:00 Pacific Time each day. Redundant runs are scheduled at 07:00 and 09:00 in case of pipeline failure. This data is on a 4-day lag to account for the time needed to complete and validate data from all SF acute care hospitals.
D. HOW TO USE THIS DATASET
This data provides visibility into current occupancy levels and use of San Francisco acute care hospitals and potential ability to accommodate anticipated surges of COVID patients.
Data includes current census of COVID-19 patients (including both confirmed cases and suspected COVID patients) and other patients in acute care hospitals, shown in the “Status” column. The “Status” column also includes all available beds.
This daily census information is stratified by type of bed (acute care, intensive care, and surge) in the “Bed Type” column. Acute care beds treat patients with illnesses and injuries including recovery from surgeries. Intensive care (ICU) beds are for sicker patients in need of critical and life support services that can include the use of a ventilator. Surge beds are the additional beds that can be made available to handle an influx of COVID-19 patients; surge beds are differentiated between acute care surge beds and ICU surge beds.
Note: The current census of COVID patients shown here may not always match the hospitalizations data (https://data.sfgov.org/COVID-19/COVID-19-Hospitalizations/nxjg-bhem), as that data includes all hospitals and long term care facilities. As described above, those long term care facilities are not included here as they don’t have the capacity to take in additional acute care patients and therefore aren’t included in capacity measures.

Note: On 1/31/2023 we will also make the following changes:

• Rename the column "last_updated_at" to "data_as_of"
  
• Remove the "multipolygon" column

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. Due to the changes, starting on January 22, 2022, the number of new cases reported daily will be higher than under the old system as cases that would have taken longer to process will be reported earlier.

A. SUMMARY
This dataset contains COVID-19 positive confirmed cases aggregated by several different geographic areas and by day. COVID-19 cases are mapped to the residence of the individual and shown on the date the positive test was collected. In addition, 2019 American Community Survey (ACS) 5-year population estimates are included to calculate the cumulative rate per 10,000 residents.

Dataset covers cases going back to March 2nd, 2020 when testing began. This data may not be immediately available for recently reported cases and data will change to reflect as information becomes available. Data updated daily.

Geographic areas summarized are:
1. Analysis Neighborhoods
2. Census Tracts
3. Census Zip Code Tabulation Areas

B. HOW THE DATASET IS CREATED
Addresses from the COVID-19 case data are geocoded by the San Francisco Department of Public Health (SFDPH). Those addresses are spatially joined to the geographic areas. Counts are generated based on the number of address points that match each geographic area for a given date.

The 2019 ACS estimates for population provided by the Census are used to create a cumulative rate which is equal to ([cumulative count up to that date] / [acs_population]) * 10000) representing the number of total cases per 10,000 residents (as of the specified date).

COVID-19 case data undergo quality assurance and other data verification processes and are continually updated to maximize completeness and accuracy of information. This means data may change for previous days as information is updated.

C. UPDATE PROCESS
Geographic analysis is scripted by SFDPH staff and synced to this dataset daily at 05:00 Pacific Time.

D. HOW TO USE THIS DATASET
This dataset can be used to track the spread of COVID-19 throughout the city, in a variety of geographic areas. Note that the new cases column in the data represents the number of new cases confirmed in a certain area on the specified day, while the cumulative cases column is the cumulative total of cases in a certain area as of the specified date.

Privacy rules in effect
To protect privacy, certain rules are in effect:
1. Any area with a cumulative case count less than 10 are dropped for all days the cumulative count was less than 10. These will be null values.
2. Once an area has a cumulative case count of 10 or greater, that area will have a new row of case data every day following.
3. Cases are dropped altogether for areas where acs_population < 1000
4. Deaths data are not included in this dataset for privacy reasons. The low COVID-19 death rate in San Francisco, along with other publicly available information on deaths, means that deaths data by geography and day is too granular and potentially risky.

Note: On 1/31/2023 we will also make the following changes:

• Rename the column "last_updated_at" to "data_as_of"
  
• Remove the "multipolygon" column

Note: As of April 16, 2021, this dataset will update daily with a five-day data lag.

A. SUMMARY
This dataset includes COVID-19 tests by resident neighborhood and specimen collection date (the day the test was collected). Specifically, this dataset includes tests of San Francisco residents who listed a San Francisco home address at the time of testing. These resident addresses were then geo-located and mapped to neighborhoods. The resident address associated with each test is hand-entered and susceptible to errors, therefore neighborhood data should be interpreted as an approximation, not a precise nor comprehensive total.

In recent months, about 5% of tests are missing addresses and therefore cannot be included in any neighborhood totals. In earlier months, more tests were missing address data. Because of this high percentage of tests missing resident address data, this neighborhood testing data for March, April, and May should be interpreted with caution (see below)

Percentage of tests missing address information, by month in 2020
Mar - 33.6%
Apr - 25.9%
May - 11.1%
Jun - 7.2%
Jul - 5.8%
Aug - 5.4%
Sep - 5.1%
Oct (Oct 1-12) - 5.1%

To protect the privacy of residents, the City does not disclose the number of tests in neighborhoods with resident populations of fewer than 1,000 people. These neighborhoods are omitted from the data (they include Golden Gate Park, John McLaren Park, and Lands End).

Tests for residents that listed a Skilled Nursing Facility as their home address are not included in this neighborhood-level testing data. Skilled Nursing Facilities have required and repeated testing of residents, which would change neighborhood trends and not reflect the broader neighborhood's testing data.

This data was de-duplicated by individual and date, so if a person gets tested multiple times on different dates, all tests will be included in this dataset (on the day each test was collected).

The total number of positive test results is not equal to the total number of COVID-19 cases in San Francisco. During this investigation, some test results are found to be for persons living outside of San Francisco and some people in San Francisco may be tested multiple times (which is common). To see the number of new confirmed cases by neighborhood, reference this map: https://data.sfgov.org/stories/s/Map-of-Cumulative-Cases/adm5-wq8i#new-cases-map

B. HOW THE DATASET IS CREATED
COVID-19 laboratory test data is based on electronic laboratory test reports. Deduplication, quality assurance measures and other data verification processes maximize accuracy of laboratory test information. All testing data is then geo-coded by resident address. Then data is aggregated by analysis neighborhood and specimen collection date.

Data are prepared by close of business Monday through Saturday for public display.

C. UPDATE PROCESS
Updates automatically at 05:00 Pacific Time each day. Redundant runs are scheduled at 07:00 and 09:00 in case of pipeline failure.

D. HOW TO USE THIS DATASET
Due to the high degree of variation in the time needed to complete tests by different labs there is a delay in this reporting. On March 24 the Health Officer ordered all labs in the City to report complete COVID-19 testing information to the local and state health departments.

In order to track trends over time, a data user can analyze this data by "specimen_collection_date".

Calculating Percent Positivity: The pos

Note: On 1/31/2023 we will be updating our data to reflect the 2020 Census Bureau American Community Survey (ACS) San Francisco Population estimates.

Note: On 1/31/2023 we will rename the column "last_updated_at" to "data_as_of".

Note: As of March 2022, the race/ethnicity label changed from Native American to American Indian or Alaska Native to align with the Census.

Note: As of February 2022, the way race/ethnicity is categorized has been changed. See Section B for additional information.

Note: As of April 16, 2021, this dataset will update daily with a five-day data lag.

A. SUMMARY
This dataset includes San Francisco COVID-19 tests by race/ethnicity and by date. This dataset represents the daily count of tests collected, and the breakdown of test results (positive, negative, or indeterminate). Tests in this dataset include all those collected from persons who listed San Francisco as their home address at the time of testing. It also includes tests that were collected by San Francisco providers for persons who were missing a locating address. This dataset does not include tests for residents listing a locating address outside of San Francisco, even if they were tested in San Francisco.

The data were de-duplicated by individual and date, so if a person gets tested multiple times on different dates, all tests will be included in this dataset (on the day each test was collected). If a person tested multiple times on the same date, only one test is included from that date. When there are multiple tests on the same date, a positive result, if one exists, will always be selected as the record for the person. If a PCR and antigen test are taken on the same day, the PCR test will supersede. If a person tests multiple times on the same day and the results are all the same (e.g. all negative or all positive) then the first test done is selected as the record for the person.

The total number of positive test results is not equal to the total number of COVID-19 cases in San Francisco. Each positive test result is investigated by the health department. While the city tries to only report on tests for San Francisco residents (or tests in San Francisco for those with no locating address listed), some test results purported to be for San Francisco residents are actually for people living outside the city. This can be discovered during a case investigation or data quality assurance. In such an instance, the test would be counted as a positive test in the SF data but would not be counted as a COVID-19 case in San Francisco. If a person tests positive for COVID-19 on different dates, they would be included each of those times in the testing data but only one case. To track the number of cases by race/ethnicity, see this dashboard:
https://sf.gov/data/covid-19-population-characteristics#race-or-ethnicity-

When a person gets tested for COVID-19, they may be asked to report information about themselves. One piece of information that might be requested is a person's race and ethnicity. These data are often incomplete in the laboratory and provider reports of the test results sent to the health department. The data can be missing or incomplete for several possible reasons:

• The person was not asked about their race and ethnicity.
• The person was asked, but refused to answer.
• The person answered, but the testing provider did not include the person's answers in the reports.
• The testing provider reported the person's answers in a format that could not be used by the health department.

For any of these reasons, a person's race/ethnicity will be recorded in the dataset as “Unknown.”

B. NOTE ON RACE/ETHNICITY
The different values for Race/Ethnicity in this dataset are "Asian;" "Black or African American;" "Hispanic or Latino/a, all races;" "American Indian or Alaska Native;" "Native Hawaiian or Other Pacific Islander;" "White;" "Multi-racial;" "Ot

A. SUMMARY
This dataset represents the COVID-19 vaccinations given to residents of San Francisco over time. All vaccines given to SF residents are included, no matter where the vaccination took place (the vaccine may have been administered in San Francisco or outside of San Francisco). The data are broken down by multiple demographic stratifications. This dataset also includes COVID-19 vaccinations given to SF residents by the San Francisco Department of Public Health (SFDPH) over time.

Data provides counts for residents who have received at least one dose, residents who have completed a primary vaccine series, residents who have received one or two monovalent (not bivalent) booster doses, and residents who have received a bivalent booster dose. A primary vaccine series is complete after an individual has received all intended doses of the initial series. There are one, two, and three dose primary vaccine series.

B. HOW THE DATASET IS CREATED
Information on doses administered to those who live in San Francisco is from the California Immunization Registry (CAIR2), run by the California Department of Public Health (CDPH). The information on individuals’ city of residence, age, race, and ethnicity are also recorded in CAIR and are self-reported at the time of vaccine administration.

In order to estimate the percent of San Franciscans vaccinated, we provide the 2019 five-year American Community Survey population estimates for each demographic group.

C. UPDATE PROCESS
Updated daily via automated process

D. HOW TO USE THIS DATASET
Before analysis, you must filter the dataset to the desired stratification of data using the "overall_segment" column.

For example, filtering "overall_segment" to "All SF Residents by Age Bracket, Administered by All Providers" will filter the data to residents whose vaccinations were administered by any provider. You can then further segment the data and calculate percentages by Age Brackets.

If you filter "overall_segment" to "All SF Residents by Race/Ethnicity, Administered by DPH Only", you will see the race/ethnicity breakdown for residents who received vaccinations from the San Francisco Department of Public Health (SFDPH).

If you filter "overall_segment" to "All SF Residents by Age Group, Administered by All Providers" you will see vaccination counts of various age eligibility groups that were administered by any provider.

To count the number of individuals vaccinated (with any primary series dose) for the first time on a given day, use the "new_recipients" column. To count the number of individuals who have completed their primary vaccine series on a given day, use the "new_series_completed" column. To count the number of primary series doses administered on a day (1st, 2nd, 3rd, or single doses), use the "new_primary_series_doses" column.

To count the number of individuals who r

A. SUMMARY
Geographic zones of the priority areas in the Tenderloin neighborhood used in the COVID-19 assessment and Tenderloin Neighborhood Plan. See more details on the plan here:
https://sf.gov/news/san-francisco-releases-tenderloin-neighborhood-safety-assessment-and-plan-covid-19

B. HOW THE DATASET IS CREATED
A team of representative City departments from the Healthy Streets Operation Center (Department of Emergency Management, Department of Public Health, Department of Homelessness and Supportive Housing, Human Rights Commission, San Francisco Police Department, San Francisco Fire Department, and Department of Public Works), SF Ho