Weekly updates have finished with the June 28th update. This dataset contains aggregate data of COVID vaccines administered to citizens based on zip code of residence. Data includes counts of individuals who received a vaccine dose that provides partial coverage against the disease and counts of individuals that received a vaccine dose that provides full coverage against the disease. Suppression applies for quantities less than 5. Data only includes information reported to PA-SIIS, the Pennsylvania Statewide Immunization Information System.
Effective 7/9/2021, the COVID-19 Vaccine Dashboard is updated to more accurately reflect the number of people who are partially and fully vaccinated in each county outside of Philadelphia, along with the demographics of those receiving vaccine. For state-to-state comparisons refer to the CDC vaccine data tracker located here: https://covid.cdc.gov/covid-data-tracker/#county-view

A. SUMMARY It is the policy of the San Francisco Department of Public Health to comply with patient/client/resident rights regarding Protected Health Information (PHI) as set forth in the Health Insurance Portability and Accountability Act of 1996 (HIPAA). These guidelines exists to provide guidance only as it relates to the public release of COVID-19 data through the tracker webpages, so that public reporting of de-identified information of residents’ health status, demographic and other characteristics, and geographical information reflect consistent reporting practices and meaningful differences in health outcomes, conditions that impact health, and delivery of services while safeguarding patient/client/resident rights regarding PHI.

COVID-19 related data will be released routinely in a variety of data products related to the tracker, including datasets through SF OpenData. Some data products may include data by county or smaller analysis unit such as ZIP code, neighborhood, or census tract.

Download the attached PDF for the policy.

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, 2016-2020 American Community Survey (ACS) population estimates are included to calculate the cumulative rate per 10,000 residents.

Dataset covers cases going back to 3/2/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 2016-2020 American Community Survey (ACS) population estimates 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 San Francisco population estimates for geographic regions can be found in a view based on the San Francisco Population and Demographic Census dataset. These population estimates are from the 2016-2020 5-year American Community Survey (ACS).

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. Read more in our privacy guidelines

Rate suppression in effect where counts lower than 20 Rates are not calculated unless the cumulative case count is greater than or equal to 20. Rates are generally unstable at small numbers, so we avoid calculating them directly. We advise you to apply the same approach as this is best practice in epidemiology.

A note on Census ZIP Code Tabulation Areas (ZCTAs) 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.

Rows included for Citywide case counts Rows are included for the Citywide case counts and incidence rate every day. These Citywide rows can be used for comparisons. Citywide will capture all cases regardless of address quality. While some cases cannot be mapped to sub-areas like Census Tracts, ongoing data quality efforts result in improved mapping on a rolling bases.

Related dataset See the dataset of the most recent cumulative counts for all geographic areas here: https://data.sfgov.org/COVID-19/COVID-19-Cases-and-Deaths-Summarized-by-Geography/tpyr-dvnc

E. CHANGE LOG

• 9/11/2023 - data on COVID-19 cases by geography over time are no longer being updated. This data is currently through 9/6/2023 and will not include any new data after this date.
• 4/6/2023 - the State implemented system updates to improve the integrity of historical data.
• 2/21/2023 - system updates to improve reliability and accuracy of cases data were implemented.
• 1/31/2023 - updated “acs_population” column to reflect the 2020 Census Bureau American Community Survey (ACS) San Francisco Population estimates.
• 1/31/2023 - implemented system updates to streamline and improve our geo-coded data, resulting in small shifts in our case data by geography.
• 1/31/2023 - renamed column “last_updated_at” to “data_as_of”.
• 1/31/2023 - removed the “multipolygon” column. To access the multipolygon geometry column for each geography unit, refer to COVID-19 Cases and Deaths Summarized by Geography.
• 1/22/2022 - system updates to improve timeliness and accuracy of cases and deaths data were implemented.
• 4/16/2021 - dataset updated to refresh with a five-day data lag.

Weekly updates have finished with the June 28th update. This dataset contains aggregate data by zip code of residence and by gender for individuals that received a COVID vaccination. Data includes counts of individuals who received a vaccine dose that provides partial coverage against the disease and counts of individuals that received a vaccine dose that provides full coverage against the disease. Suppression applies for quantities less than 5.
Effective 7/9/2021, the COVID-19 Vaccine Dashboard is updated to more accurately reflect the number of people who are partially and fully vaccinated in each county outside of Philadelphia, along with the demographics of those receiving vaccine. For state-to-state comparisons refer to the CDC vaccine data tracker located here: https://covid.cdc.gov/covid-data-tracker/#county-view

Data only includes information reported to PA-SIIS, the Pennsylvania Statewide Immunization Information System.

Weekly updates have finished with the June 28th update. This dataset contains aggregate data by zip code of residence and by ethnicity for individuals that received a COVID vaccination. Data includes counts of individuals who received a vaccine dose that provides partial coverage against the disease and counts of individuals that received a vaccine dose that provides full coverage against the disease. Suppression applies for quantities less than 5. Data only includes information reported to PA-SIIS, the Pennsylvania Statewide Immunization Information System.
Effective 7/9/2021, the COVID-19 Vaccine Dashboard is updated to more accurately reflect the number of people who are partially and fully vaccinated in each county outside of Philadelphia, along with the demographics of those receiving vaccine. For state-to-state comparisons refer to the CDC vaccine data tracker located here: https://covid.cdc.gov/covid-data-tracker/#county-view

Archived as of 9/25/2025: The datasets will no longer receive updates but the historical data will continue to be available for download. Note: 11/1/2023: Publication of the COVID data will be delayed because of technical difficulties. Note: 9/20/2023: With the end of the federal emergency and reporting requirements continuing to evolve, the Indiana Department of Health will no longer publish and refresh the COVID-19 datasets after November 15, 2023 - one final dataset publication will continue to be available. Note: 5/10/2023: Due to a technical issue updates are delayed for COVID data. New files will be published as soon as they are available. Note: 3/22/2023: Due to a technical issue updates are delayed for COVID data. New files will be published as soon as they are available. Note: 3/15/2023 test data will be removed from the COVID dashboards and HUB files in recognition of the fact that widespread use of at-home tests and a decrease in lab testing no longer provides an accurate representation of COVID-19 spread. Historical Changes: 1/11/2023: Due to a technical issue updates are delayed for COVID data. New files will be published as soon as they are available. 1/5/2023: Due to a technical issue the COVID datasets were not updated on 1/4/23. Updates will be published as soon as they are available. 9/29/22: Due to a technical difficulty, the weekly COVID datasets were not generated yesterday. They will be updated with current data today - 9/29 - and may result in a temporary discrepancy with the numbers published on the dashboard until the normal weekly refresh resumes 10/5. 9/27/2022: As of 9/28, the Indiana Department of Health (IDOH) is moving to a weekly COVID update for the dashboard and all associated datasets to continue to provide trend data that is applicable and usable for our partners and the public. This is to maintain alignment across the nation as states move to weekly updates. 8/19/2022 - The first and second dose columns are being removed as of 8/22/22 as the Health department has transitioned to reporting on Fully/Partially vaccinated. The final historical file including these columns from 8/19 will continue to be available. 2/10/2022: Data was not published on 2/9/2022 due to a technical issue, but updated data was released 2/10/2022. 10/13/2021: This dataset now includes columns for new and total booster shots administered. Please see the data dictionary for additional details. 08/06/2021: There are updates today to county-level vaccination rates to reflect a correction to records that were assigned to the wrong location based on ZIP code. 06/23/2021: COVID Hub files will no longer be updated on Saturdays. The normal refresh of these files has been changed to Mon-Fri. 06/10/2021: COVID Hub files will no longer be updated on Sundays. The normal refresh of these files has been changed to Mon-Sat. 06/07/2021: Today’s new counts include doses newly reported to the Indiana Department of Health on Saturday and Sunday. 06/03/2021: Individuals are able to update their personal and demographic information during the vaccination registration process. Today’s data reflects changes made by individuals to their race, ethnicity, or county of residence over the course of their vaccination series. 05/06/2021: On Monday 5/3, individuals classified as "Unknown" county of residence were inadvertently converted to "Out of State." These individuals have been corrected in today's dataset. 03/17/2021: This dataset has been updated to include zeros for dates where there is no reported data. 03/11/2021: This dataset has been updated to include totals and newly administered single dose vaccination data.

Weekly updates have finished with the June 28th update. Some information may be found here: https://covid.cdc.gov/covid-data-tracker/#maps_new-admissions-rate-state
This dataset contains aggregate COVID-19 case counts and rates by date of first report for all counties in Pennsylvania and for the state as a whole. Counts include both confirmed and probable cases as defined by the Council of State and Territorial Epidemiologists (CSTE). At present, a person is counted as a case only once. Note that case counts by date of report are influenced by a variety of factors, including but not limited to testing availability, test ordering patterns (such as day of week patterns), labs reporting backlogged test results, and mass screenings in nursing homes, workplaces, schools, etc. Case reports received without a patient address are assigned to the county of the ordering provider or facility based on provider zip code. Cases reported with a residential address that does not match to a known postal address per the commonwealth geocoding service are assigned to a county based on the zip code of residence. Many zip codes cross county boundaries so there is some degree of misclassification of county. All counts may change on a daily basis due to reassignment of jurisdiction, removal of duplicate case reports, correction of errors, and other daily data cleaning activities. Downloaded data represents the best information available as of the previous day.
Data will be updated between 11:30 am to 1:30pm each Wednesday.

Poisson model of individual- and zip code-level factors associated with receipt of primary COVID-19 vaccination series and booster.

Weekly updates have finished with the June 28th update. This dataset contains aggregate data by zip code of residence and by race for individuals that received a COVID vaccination. Data includes counts of individuals who received a vaccine dose that provides partial coverage against the disease and counts of individuals that received a vaccine dose that provides full coverage against the disease. Suppression applies for quantities less than 5.
Effective 7/9/2021, the COVID-19 Vaccine Dashboard is updated to more accurately reflect the number of people who are partially and fully vaccinated in each county outside of Philadelphia, along with the demographics of those receiving vaccine. For state-to-state comparisons refer to the CDC vaccine data tracker located here: https://covid.cdc.gov/covid-data-tracker/#county-view

Data only includes information reported to PA-SIIS, the Pennsylvania Statewide Immunization Information System.

Characteristics of individuals receiving a booster vaccination.

Characteristics of individuals completing the primary series.