Profile Picture OpenData

created Jul 28 2021

updated Jul 5 2022

Description

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 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 count of cases where the positive tests were collected on that specific specimen collection date. The 7-day rolling average shows the trend in new cases. The rolling average is calculated by averaging the new cases for a particular day with the prior 6 days.
New case rates are the count of new cases per 100,000 residents in each vaccination status group. The 7-day rolling average shows the trend in case rates. The rolling average is calculated by averaging the case rate for a particular day with the prior six days. Percent of total new cases shows the percent of all cases on each day that were among a particular vaccination status.
Here is more information on how each case rate is calculated:
1. The case rate for all cases is equal to the number of new cases among all residents divided by the estimated total resident population.
2. Unvaccinated case rates are equal to the number of new cases among unvaccinated residents divided by the estimated number of unvaccinated residents. The estimated number of unvaccinated residents is calculated by subtracting the number of residents that have received at least one dose of a vaccine from the total estimated resident population.
3. Partially vaccinated case rates are equal to the number of new cases among partially vaccinated residents divided by the estimated number of partially vaccinated residents.

4. Fully vaccinated case rates are equal to the number of new cases among fully vaccinated residents divided by the estimated number of fully vaccinated residents.

Activity
Community Rating
Current value: 0 out of 5
Your Rating
Current value: 0 out of 5
Raters
0
Visits
1802
Downloads
452
Comments
0
Contributors
0
Meta
Category
COVID-19
Permissions
Public
Tags
vaccination, vaccines, cases, covid-19, covid
Row Label
SODA2 Only
Yes
Licensing and Attribution
Data Provided By
(none)
Source Link
(none)
Department Metrics
Publishing Department
Public Health
Detailed Descriptive
Geographic unit
Not applicable
Publishing Details
Publishing frequency
Daily
Data change frequency
Daily
This view cannot be displayed