A. SUMMARY Medical provider confirmed COVID-19 cases and confirmed COVID-19 related deaths in San Francisco, CA aggregated by several different geographic areas and normalized by 2016-2020 American Community Survey (ACS) 5-year estimates for population data to calculate rate per 10,000 residents.

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.

Cases and deaths are both mapped to the residence of the individual, not to where they were infected or died. For example, if one was infected in San Francisco at work but lives in the East Bay, those are not counted as SF Cases or if one dies in Zuckerberg San Francisco General but is from another county, that is also not counted in this dataset.

Dataset is cumulative and covers cases going back to 3/2/2020 when testing began.

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

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 geographic areas. Counts are generated based on the number of address points that match each geographic area. The 2016-2020 American Community Survey (ACS) population estimates provided by the Census are used to create a rate which is equal to ([count] / [acs_population]) * 10000) representing the number of cases per 10,000 residents.

C. UPDATE PROCESS Geographic analysis is scripted by SFDPH staff and synced to this dataset daily at 7:30 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).

Privacy rules in effect To protect privacy, certain rules are in effect: 1. Case counts greater than 0 and less than 10 are dropped - these will be null (blank) values 2. Death counts greater than 0 and less than 10 are dropped - these will be null (blank) values 3. Cases and deaths dropped altogether for areas where acs_population < 1000

Rate suppression in effect where counts lower than 20 Rates are not calculated unless the 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.

Row included for Citywide case counts, incidence rate, and deaths A single row is included that has the Citywide case counts and incidence rate. This 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 basis.

E. CHANGE LOG

• 9/11/2023 - data on COVID-19 cases and deaths summarized by geography 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 and death data by geography.
• 1/31/2023 - renamed column “last_updated_at” to “data_as_of”.
• 2/23/2022 - the New Cases Map dashboard began pulling from this dataset. To access Cases by Geography Over Time, please refer to this dataset.
• 1/22/2022 - system updates to improve timeliness and accuracy of cases and deaths data were implemented.
• 7/15/2022 - reinfections added to cases dataset. See section SUMMARY for more information on how reinfections are identified.
• 4/16/2021 - dataset updated to refresh with a five-day data lag.

It is increasingly recognized that policies have played a role in both alleviating and exacerbating the health and economic consequences of the COVID-19 pandemic. Yet there has been limited work to systematically evaluate the substantial variation in local COVID-19-related policies in the U.S. The objective of the U.S. COVID-19 County Policy (UCCP) Database is to systematically gather, characterize, and assess variation in U.S. county-level COVID-19-related policies. The current data upload represents the first wave of data collection, which includes data on over 20 policies gathered across 171 counties in 7 states during January-March 2021. These include county-level COVID-19-related policies within 3 policy domains that are likely to affect a variety of health outcomes: (1) containment/closure, (2) economic support, and (3) public health. In ongoing work, we are conducting retrospective longitudinal weekly data collection for the period 2020-2021 from a larger swath of 300+ U.S. counties in all 50 states and Washington D.C., and the current database will be updated with new data as it becomes available.

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.

Update Jan 26, 2023: This dataset is no longer being updated. Please visit https://sf.gov/get-vaccinated-against-covid-19 for information on vaccine locations. A. SUMMARY Dataset contains Vaccine Access points in City and County of San Francisco as listed on https://sf.gov/vaccine-sites. This site list is not inclusive of all City Sites, as some mobile sites and other providers may not be included. B. HOW THE DATASET IS CREATED Maintained by City staff. C. UPDATE PROCESS Updated daily via automated process

2019 Novel Coronavirus COVID-19 (2019-nCoV) Visual Dashboard and Map:
https://www.arcgis.com/apps/opsdashboard/index.html#/bda7594740fd40299423467b48e9ecf6

• Confirmed Cases by Country/Region/Sovereignty
• Confirmed Cases by Province/State/Dependency
• Deaths
• Recovered

Downloadable data:
https://github.com/CSSEGISandData/COVID-19

Additional Information about the Visual Dashboard:
https://systems.jhu.edu/research/public-health/ncov

The City and County of San Francisco was the first municipality in the United States to institute a COVID-19 contact tracing program. The San Francisco Department of Public Health (SFDPH) and the University of California, San Francisco (UCSF) created an outcome-based fully remote contact tracing curriculum using participatory learning methods to train non-public health emergency workers as contact tracers. Between April and December 2020, we trained over 300 individuals in contact tracing skills and procedures over three training phases. Using iterative curriculum design and Kirkpatrick’s evaluation methodology, we aimed to ensure high quality and successful person-centered contact tracing. The resulting curriculum consisted of 24 learning outcomes taught with six participatory skills development activities, asynchronous materials, and one-on-one contact tracer support. We collected more than 700 responses from trainees using various evaluation tools across the training phases, and contact tracers interviewed more than 24,000 contacts after training in our program. Our evaluations showed that knowledge and skills improved for most trainees and demonstrated the utility of the training program in preparing trainees to perform person-centered contact tracing in San Francisco. Local health jurisdictions and state health agencies can use this model of curriculum development and evaluation to rapidly train a non-public health workforce to respond to future public health emergencies.

While most construction sites have been closed down in the greater San Francisco Bay Area, many construction works in Los Angeles County appear to be moving forward. Read More

Background Rural U.S. communities are at risk from COVID-19 due to advanced age and limited access to acute care. Recognizing this, the Vashon Medical Reserve Corps (VMRC) in King County, Washington, implemented an all-volunteer, community-based COVID-19 response program. This program integrated public engagement, SARS-CoV-2 testing, contact tracing, vaccination, and material community support, and was associated with the lowest cumulative COVID-19 case rate in King County. This study aimed to investigate the contributions of demographics, geography and public health interventions to Vashon’s low COVID-19 rates. Methods This observational cross-sectional study compares cumulative COVID-19 rates and success of public health interventions from February 2020 through November 2021 for Vashon Island with King County (including metropolitan Seattle) and Whidbey Island, located ~50 km north of Vashon. To evaluate the role of demography, we developed multiple linear regression models of COVID-19 rates using metrics of age, race/ethnicity, wealth and educational attainment across 77 King County zip codes. To investigate the role of remote geography we expanded the regression models to include North, Central and South Whidbey, similarly remote island communities with varying demographic features. To evaluate the effectiveness of VMRC’s community-based public health measures, we directly compared Vashon’s success of vaccination and contact tracing with that of King County and South Whidbey, the Whidbey community most similar to Vashon. Results Vashon’s cumulative COVID-19 case rate was 29% that of King County overall (22.2 vs 76.8 cases/K). A multiple linear regression model based on King County demographics found educational attainment to be a major correlate of COVID-19 rates, and Vashon’s cumulative case rate was just 38% of predicted (p<.05), so demographics alone do not explain Vashon’s low COVID-19 case rate. Inclusion of Whidbey communities in the model identified a major effect of remote geography (-49 cases/K, p<.001), such that observed COVID-19 rates for all remote communities fell within the model’s 95% prediction interval. VMRC’s vaccination effort was highly effective, reaching a vaccination rate of 1500 doses/K four months before South Whidbey and King County and maintaining a cumulative vaccination rate 200 doses/K higher throughout the latter half of 2021 (p<.001). Including vaccination rates in the model reduced the effect of remote geography to -41 cases/K (p<.001). VMRC case investigation was also highly effective, interviewing 96% of referred cases in an average of 1.7 days compared with 69% in 3.7 days for Washington Department of Health investigating South Whidbey cases and 80% in 3.4 days for Public Health–Seattle & King County (both p<0.001). VMRC’s public health interventions were associated with a 30% lower case rate (p<0.001) and 55% lower hospitalization rate (p=0.056) than South Whidbey. Conclusion While the overall magnitude of the pre-Omicron COVID-19 pandemic in rural and urban U.S. communities was similar, we show that island communities in the Puget Sound region were substantially protected from COVID-19 by their geography. We further show that a volunteer community-based COVID-19 response program was highly effective in the Vashon community, augmenting the protective effect of geography. We suggest that Medical Reserve Corps should be an important element of future pandemic planning. Methods The study period extended from the pandemic onset in February 2020 through November 2021. Daily COVID-19 cases, hospitalizations, deaths and test numbers for King County as a whole and by zip code were downloaded from the King County COVID-19 dashboard (Feb 22, 2022 update). Population data for King County and Vashon are from the April 2020 US Census. Zip code level population data are the average of two zip code tabulation area estimates from the WA Office of Financial Management and Cubit (a commercial data vendor providing access to US Census information). The Asset Limited, Income Constrained, and Employed (ALICE) metric, a measure of the working poor, was obtained from United Way.