About this dataset

Context

The dataset tabulates the population of San Francisco by race. It includes the population of San Francisco across racial categories (excluding ethnicity) as identified by the Census Bureau. The dataset can be utilized to understand the population distribution of San Francisco across relevant racial categories.

Key observations

The percent distribution of San Francisco population by race (across all racial categories recognized by the U.S. Census Bureau): 40.49% are white, 5.09% are Black or African American, 0.66% are American Indian and Alaska Native, 34.97% are Asian, 0.38% are Native Hawaiian and other Pacific Islander, 7.75% are some other race and 10.66% are multiracial.

Content

When available, the data consists of estimates from the U.S. Census Bureau American Community Survey (ACS) 2019-2023 5-Year Estimates.

Racial categories include:

• White
• Black or African American
• American Indian and Alaska Native
• Asian
• Native Hawaiian and Other Pacific Islander
• Some other race
• Two or more races (multiracial)

Variables / Data Columns

• Race: This column displays the racial categories (excluding ethnicity) for the San Francisco
• Population: The population of the racial category (excluding ethnicity) in the San Francisco is shown in this column.
• % of Total Population: This column displays the percentage distribution of each race as a proportion of San Francisco total population. Please note that the sum of all percentages may not equal one due to rounding of values.

Good to know

Margin of Error

Data in the dataset are based on the estimates and are subject to sampling variability and thus a margin of error. Neilsberg Research recommends using caution when presening these estimates in your research.

Custom data

If you do need custom data for any of your research project, report or presentation, you can contact our research staff at research@neilsberg.com for a feasibility of a custom tabulation on a fee-for-service basis.

Inspiration

Neilsberg Research Team curates, analyze and publishes demographics and economic data from a variety of public and proprietary sources, each of which often includes multiple surveys and programs. The large majority of Neilsberg Research aggregated datasets and insights is made available for free download at https://www.neilsberg.com/research/.

Recommended for further research

This dataset is a part of the main dataset for San Francisco Population by Race & Ethnicity. You can refer the same here

About this dataset

Context

The dataset tabulates the population of South San Francisco by race. It includes the population of South San Francisco across racial categories (excluding ethnicity) as identified by the Census Bureau. The dataset can be utilized to understand the population distribution of South San Francisco across relevant racial categories.

Key observations

The percent distribution of South San Francisco population by race (across all racial categories recognized by the U.S. Census Bureau): 26.58% are white, 1.73% are Black or African American, 0.69% are American Indian and Alaska Native, 43% are Asian, 1.12% are Native Hawaiian and other Pacific Islander, 14.04% are some other race and 12.86% are multiracial.

Content

When available, the data consists of estimates from the U.S. Census Bureau American Community Survey (ACS) 2019-2023 5-Year Estimates.

Racial categories include:

• White
• Black or African American
• American Indian and Alaska Native
• Asian
• Native Hawaiian and Other Pacific Islander
• Some other race
• Two or more races (multiracial)

Variables / Data Columns

• Race: This column displays the racial categories (excluding ethnicity) for the South San Francisco
• Population: The population of the racial category (excluding ethnicity) in the South San Francisco is shown in this column.
• % of Total Population: This column displays the percentage distribution of each race as a proportion of South San Francisco total population. Please note that the sum of all percentages may not equal one due to rounding of values.

Good to know

Margin of Error

Data in the dataset are based on the estimates and are subject to sampling variability and thus a margin of error. Neilsberg Research recommends using caution when presening these estimates in your research.

Custom data

If you do need custom data for any of your research project, report or presentation, you can contact our research staff at research@neilsberg.com for a feasibility of a custom tabulation on a fee-for-service basis.

Inspiration

Neilsberg Research Team curates, analyze and publishes demographics and economic data from a variety of public and proprietary sources, each of which often includes multiple surveys and programs. The large majority of Neilsberg Research aggregated datasets and insights is made available for free download at https://www.neilsberg.com/research/.

Recommended for further research

This dataset is a part of the main dataset for South San Francisco Population by Race & Ethnicity. You can refer the same here

About this dataset

Context

The dataset tabulates the Non-Hispanic population of South San Francisco by race. It includes the distribution of the Non-Hispanic population of South San Francisco across various race categories as identified by the Census Bureau. The dataset can be utilized to understand the Non-Hispanic population distribution of South San Francisco across relevant racial categories.

Key observations

Of the Non-Hispanic population in South San Francisco, the largest racial group is Asian alone with a population of 27,324 (61.21% of the total Non-Hispanic population).

Content

When available, the data consists of estimates from the U.S. Census Bureau American Community Survey (ACS) 2019-2023 5-Year Estimates.

Racial categories include:

• White
• Black or African American
• American Indian and Alaska Native
• Asian
• Native Hawaiian and Other Pacific Islander
• Some other race
• Two or more races (multiracial)

Variables / Data Columns

• Race: This column displays the racial categories (for Non-Hispanic) for the South San Francisco
• Population: The population of the racial category (for Non-Hispanic) in the South San Francisco is shown in this column.
• % of Total Population: This column displays the percentage distribution of each race as a proportion of South San Francisco total Non-Hispanic population. Please note that the sum of all percentages may not equal one due to rounding of values.

Good to know

Margin of Error

Data in the dataset are based on the estimates and are subject to sampling variability and thus a margin of error. Neilsberg Research recommends using caution when presening these estimates in your research.

Custom data

If you do need custom data for any of your research project, report or presentation, you can contact our research staff at research@neilsberg.com for a feasibility of a custom tabulation on a fee-for-service basis.

Inspiration

Neilsberg Research Team curates, analyze and publishes demographics and economic data from a variety of public and proprietary sources, each of which often includes multiple surveys and programs. The large majority of Neilsberg Research aggregated datasets and insights is made available for free download at https://www.neilsberg.com/research/.

Recommended for further research

This dataset is a part of the main dataset for South San Francisco Population by Race & Ethnicity. You can refer the same here

Graph and download economic data for Population Estimate, Total, Hispanic or Latino, Two or More Races, Two Races Including Some Other Race (5-year estimate) in San Francisco County, CA (B03002020E006075) from 2009 to 2023 about San Francisco, latino, hispanic, CA, estimate, persons, 5-year, population, and USA.

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.

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;" "Other;" and “Unknown."

The Race/Ethnicity categorization increases data clarity by emulating the methodology used by the U.S. Census in the American Community Survey. Specifically, persons who identify as "Asian," "Black or African American," "American Indian or Alaska Native," "Native Hawaiian or Other Pacific Islander," "White," "Multi-racial," or "Other" do NOT include any person who identified as Hispanic/Latino at any time in their testing reports that either (1) identified them as SF residents or (2) as someone who tested without a locating address by an SF provider. All persons across all races who identify as Hispanic/Latino are recorded as “"Hispanic or Latino/a, all races." This categorization increases data accuracy by correcting the way “Other” persons were counted. Previously, when a person reported “Other” for Race/Ethnicity, they would be recorded “Unknown.” Under the new categorization, they are counted as “Other” and are distinct from “Unknown.”

If a person records their race/ethnicity as “Asian,” “Black or African American,” “American Indian or Alaska Native,” “Native Hawaiian or Other Pacific Islander,” “White,” or “Other” for their first COVID-19 test, then this data will not change—even if a different race/ethnicity is reported for this person for any future COVID-19 test. There are two exceptions to this rule. The first exception is if a person’s race/ethnicity value i

This filtered view contains the population estimates for San Francisco demographic groups from the U.S. Census Bureau’s American Community Survey that are used in the Department of Public Health’s public reporting. Details on the underlying demographic data from the American Community Survey are available below. The demographics included are race/ethnicity and age groups. Different age groups are used for reporting on cases reporting versus vaccinations. The specific groups used in each of these reports can be found by using the "reporting_segment" column. We are using 2016-2020 ACS estimates in our public reporting, but additional years are included in this view as well for historical purposes.

The COVID-19 reports which use this data are available on SF.gov by clicking here.

San Francisco Population and Demographic Census data dataset filtered on:

• "reporting_segment" =
  • 'COVID-19 cases/testing reporting - age brackets'
  • OR 'Seasonal vaccine reporting - age groups'
  • OR 'from census table B03002' (race/ethnicity)
• AND "geography_name" = 'San Francisco County, California'

B. HOW THE DATASET IS CREATED The raw data is obtained from the census API. Some estimates as published as-is and some are derived.

C. UPDATE PROCESS New estimates and years of data are appended to this dataset. To request additional census data for San Francisco, email support@datasf.org

D. HOW TO USE THIS DATASET The dataset is long and contains multiple estimates, years and geographies. To use this dataset, you can filter by the overall segment which contains information about the source, years, geography, demographic category and reporting segment. For census data used in specific reports, you can filter to the reporting segment. To use a subset of the data, you can create a filtered view. More information of how to filter data and create a view can be found here

This data layer depicts, by census block group, race for the San Francisco Bay Region. The source data, from the United States Census Bureau, has been reprocessed by the Metropolitan Transportation Commission.

To produce this feature set, the Metropolitan Transportation Commission pulled data from the Decennial Census API P2 Table, and re-tabulated race and ethnicity population totals into following categories: ● Non-Hispanic White ● Hispanic ● Non-Hispanic Asian (includes Native Hawaiian and Pacific Islander) ● Non-Hispanic Black/African American ● Non-Hispanic Other Race and Multiple Races

The resulting attribute table had all margin of error fields deleted, Hispanic subcategories deleted, percentage fields added, county code field added, and the source field names were changed.

The source table used to develop this feature service is from the United States Census Bureau, 2020 Decennial Census.

Racial diversity is measured by a diversity index that is calculated using United States Census racial and ethnic population characteristics from the PL-94 data file. The diversity index is a quantitative measure of the distribution of the proportion of five major ethnic populations (non-Hispanic White, non-Hispanic Black, Asian and Pacific Islander, Hispanic, and Two or more races). The index ranges from 0 (low diversity meaning only one group is present) to 1 (meaning an equal proportion of all five groups is present). The diversity score for the United States in 2010 is 0.60. The diversity score for the San Francisco Bay Region is 0.84. Within the region, Solano (0.89) and Alameda (0.90) Counties are the most diverse and the remaining North Bay (0.55 - 0.64) Counties are the least diverse.

Graph and download economic data for Population Estimate, Total, Not Hispanic or Latino, Some Other Race Alone (5-year estimate) in Marin County, CA (B03002008E006041) from 2009 to 2023 about Marin County, CA; San Francisco; CA; non-hispanic; estimate; persons; 5-year; population; and USA.

A. SUMMARY Please note that the "Data Last Updated" date on this page denotes the most recent DataSF update and does not reflect the most recent update to this dataset. To confirm the completeness of this dataset please contact the Sheriff's Office at sheriff.tech.services@sfgov.org

The dataset provides summary information on individuals booked into the San Francisco City and County Jail since 2012, categorized by ethnicity. The table provides a breakdown of the total number of bookings by month and ethnicity. The unit of measure is the jail booking number. The data is collected by the Sheriff's Office and includes self-report and assigned data. However, some ethnicity categories with small sample sizes are grouped together to reduce the risk of re-identification and protect the privacy of individuals booked into jail.

The booking process refers to the procedure that occurs after an individual has been arrested and is taken into custody. The process begins with the arrest of an individual by law enforcement officers. The arrest can take place on the scene or at a later time if a warrant is issued. Once the individual has been arrested, and statutory law requires incarceration, they would be transported to the jail for booking. The arresting officer will record the reason for the arrest, along with any other relevant information. The sheriff’s deputies will then book the individual into jail, which involves taking their fingerprints, photograph, and recording personal information. The jail will assign a booking number, which is used to identify the individual throughout their time in custody. Once the booking process is complete, the individual will be incarcerated and will remain in custody until they are released per court order.

Disclaimer: The San Francisco Sheriff's Office does not guarantee the accuracy, completeness, or timeliness of the information as the data is subject to change as modifications and updates are completed.

B. HOW THE DATASET IS CREATED

When an arrest is presented to the Sheriff’s Office, relevant data is manually entered into the Sheriff Office's jail management system. Data reports are pulled from this system on a semi-regular basis, and added to Open Data.

C. UPDATE PROCESS This dataset is scheduled to update monthly.

D. HOW TO USE THIS DATASET This data can be used to identify trends and patterns in the jail population over time. The date in this dataset is based on the date the suspect was booked into county jail for the arresting incident. The unit of measurement for this dataset is the booking number. A jail booking number is a unique identifier assigned to each individual who is booked into a jail facility.

E. RELATED DATASETS • Booking by Age • Bookings by Race • Booking by Male/Female

Graph and download economic data for Population Estimate, Total, Hispanic or Latino, Some Other Race Alone (5-year estimate) in Contra Costa County, CA (B03002018E006013) from 2009 to 2023 about Contra Costa County, CA; San Francisco; latino; hispanic; CA; estimate; persons; 5-year; population; and USA.

Context

COVID-19 data for San Francisco from data.sfgov.org

Content

COVID-19 Hospitalizations

COVID-19 Cases Summarized by Date, Transmission and Case Disposition

COVID-19 Cases Summarized by Race and Ethnicity

COVID-19 Cases Summarized by Age Group and Gender

COVID-19 Tests

Acknowledgements

Data from https://data.sfgov.org/analytics and https://data.sfgov.org/COVID-19/COVID-19-Cases-Summarized-by-Age-Group-and-Gender/sunc-2t3k and https://data.sfgov.org/COVID-19/COVID-19-Tests/nfpa-mg4g and https://data.sfgov.org/COVID-19/COVID-19-Hospitalizations/nxjg-bhem and https://data.sfgov.org/COVID-19/COVID-19-Cases-Summarized-by-Date-Transmission-and/tvq9-ec9w and https://data.sfgov.org/COVID-19/COVID-19-Cases-Summarized-by-Race-and-Ethnicity/vqqm-nsqg

Dataset license: https://datasf.org/opendata/terms-of-use/

Banner Photo by Maarten van den Heuvel on Unsplash

A. SUMMARY This dataset includes unintentional drug overdose death rates by race/ethnicity by year. This dataset is created using data from the California Electronic Death Registration System (CA-EDRS) via the Vital Records Business Intelligence System (VRBIS). Substance-related deaths are identified by reviewing the cause of death. Deaths caused by opioids, methamphetamine, and cocaine are included. Homicides and suicides are excluded. Ethnic and racial groups with fewer than 10 events are not tallied separately for privacy reasons but are included in the “all races” total.

Unintentional drug overdose death rates are calculated by dividing the total number of overdose deaths by race/ethnicity by the total population size for that demographic group and year and then multiplying by 100,000. The total population size is based on estimates from the US Census Bureau County Population Characteristics for San Francisco, 2022 Vintage by age, sex, race, and Hispanic origin.

These data differ from the data shared in the Preliminary Unintentional Drug Overdose Death by Year dataset since this dataset uses finalized counts of overdose deaths associated with cocaine, methamphetamine, and opioids only.

B. HOW THE DATASET IS CREATED This dataset is created by copying data from the Annual Substance Use Trends in San Francisco report from the San Francisco Department of Public Health Center on Substance Use and Health.

C. UPDATE PROCESS This dataset will be updated annually, typically at the end of the year.

D. HOW TO USE THIS DATASET N/A

E. RELATED DATASETS Overdose-Related 911 Responses by Emergency Medical Services Preliminary Unintentional Drug Overdose Deaths San Francisco Department of Public Health Substance Use Services

F. CHANGE LOG

• 12/16/2024 - Updated with 2023 data. Asian/Pacific Islander race/ethnicity group was changed to Asian.
• 12/16/2024 - Past year totals by race/ethnicity were revised after obtaining accurate race/ethnicity for some decedents that were previously marked as “unknown” race/ethnicity.

Graph and download economic data for Population Estimate, Total, Not Hispanic or Latino, Two or More Races, Two Races Excluding Some Other Race, and Three or More Races (5-year estimate) in Alameda County, CA (B03002011E006001) from 2009 to 2023 about Alameda County, CA; San Francisco; CA; non-hispanic; estimate; persons; 5-year; population; and USA.

This dataset tracks annual two or more races student percentage from 2011 to 2023 for Academy - Sf mcateer vs. California and San Francisco Unified School District

Some other race Health Insurance Coverage Statistics for 2023. This is part of a larger dataset covering consumer health insurance coverage rates in San Francisco, California by age, education, race, gender, work experience and more.

As of July 2nd, 2024 the COVID-19 Deaths by Population Characteristics Over Time dataset has been retired. This dataset is archived and will no longer update. We will be publishing a cumulative deaths by population characteristics dataset that will update moving forward. A. SUMMARY This dataset shows San Francisco COVID-19 deaths by population characteristics and by date. This data may not be immediately available for recently reported deaths. Data updates as more information becomes available. Because of this, death totals for previous days may increase or decrease. More recent data is less reliable. Population characteristics are subgroups, or demographic cross-sections, like age, race, or gender. The City tracks how deaths have been distributed among different subgroups. This information can reveal trends and disparities among groups. B. HOW THE DATASET IS CREATED As of January 1, 2023, COVID-19 deaths are defined as persons who had COVID-19 listed as a cause of death or a significant condition contributing to their death on their death certificate. This definition is in alignment with the California Department of Public Health and the national Council of State and Territorial Epidemiologists. Death certificates are maintained by the California Department of Public Health. Data on the population characteristics of COVID-19 deaths are from: Case reports Medical records Electronic lab reports Death certificates Data are continually updated to maximize completeness of information and reporting on San Francisco COVID-19 deaths. To protect resident privacy, we summarize COVID-19 data by only one characteristic at a time. Data are not shown until cumulative citywide deaths reach five or more. Data notes on each population characteristic type is listed below. Race/ethnicity * We include all race/ethnicity categories that are collected for COVID-19 cases. Gender * The City collects information on gender identity using these guidelines. C. UPDATE PROCESS Updates automatically at 06:30 and 07:30 AM Pacific Time on Wednesday each week. Dataset will not update on the business day following any federal holiday. D. HOW TO USE THIS DATASET Population estimates are only available for age groups and race/ethnicity categories. San Francisco population estimates for race/ethnicity and age groups 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 includes many different types of characteristics. Filter the “Characteristic Type” column to explore a topic area. Then, the “Characteristic Group” column shows each group or category within that topic area and the number of deaths on each date. New deaths are the count of deaths within that characteristic group on that specific date. Cumulative deaths are the running total of all San Francisco COVID-19 deaths in that characteristic group up to the date listed. This data may not be immediately available for more recent deaths. Data updates as more information becomes available. To explore data on the total number of deaths, use the COVID-19 Deaths Over Time dataset. E. CHANGE LOG 9/11/2023 - on this date, we began using an updated definition of a COVID-19 death to align with the California Department o

Graph and download economic data for Population Estimate, Total, Hispanic or Latino, Two or More Races, Two Races Including Some Other Race (5-year estimate) in Alameda County, CA (B03002020E006001) from 2009 to 2023 about Alameda County, CA; San Francisco; latino; hispanic; CA; estimate; persons; 5-year; population; and USA.

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 2016-2020 American Community Survey (ACS) population estimates for each demographic group.

C. UPDATE PROCESS Updated daily via automated process

D. HOW TO USE THIS DATASET San Francisco population estimates for race/ethnicity and age groups 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).

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 received their first or second monovalent (not bivalent) booster dose on a given day, use the "new_booster_recipients" and "new_2nd_booster_recipients" columns. To count the number of individuals who received their first bivalent booster dose on a given day, use the "new_bivalent_booster_recipients" column. To count the number of monovalent (not including bivalent) or bivalent booster doses administered on a given day, use the "new_booster_doses" or "new_bivalent_booster_doses" columns.

To count the number of individuals who have received a vaccine up to a certain date, use the columns beginning with "cumulative_..."

E. ARCHIVED DATA A previous version of this dataset

A. SUMMARY This archived dataset includes data for population characteristics that are no longer being reported publicly. The date on which each population characteristic type was archived can be found in the field “data_loaded_at”.

B. HOW THE DATASET IS CREATED Data on the population characteristics of COVID-19 cases are from:  * Case interviews  * Laboratories  * Medical providers    These multiple streams of data are merged, deduplicated, and undergo data verification processes.  

Race/ethnicity * We include all race/ethnicity categories that are collected for COVID-19 cases. * The population estimates for the "Other" or “Multi-racial” groups should be considered with caution. The Census definition is likely not exactly aligned with how the City collects this data. For that reason, we do not recommend calculating population rates for these groups.

Gender * The City collects information on gender identity using these guidelines.

Skilled Nursing Facility (SNF) occupancy * A Skilled Nursing Facility (SNF) is a type of long-term care facility that provides care to individuals, generally in their 60s and older, who need functional assistance in their daily lives.  * This dataset includes data for COVID-19 cases reported in Skilled Nursing Facilities (SNFs) through 12/31/2022, archived on 1/5/2023. These data were identified where “Characteristic_Type” = ‘Skilled Nursing Facility Occupancy’.

Sexual orientation * The City began asking adults 18 years old or older for their sexual orientation identification during case interviews as of April 28, 2020. Sexual orientation data prior to this date is unavailable. * The City doesn’t collect or report information about sexual orientation for persons under 12 years of age. * Case investigation interviews transitioned to the California Department of Public Health, Virtual Assistant information gathering beginning December 2021. The Virtual Assistant is only sent to adults who are 18+ years old. https://www.sfdph.org/dph/files/PoliciesProcedures/COM9_SexualOrientationGuidelines.pdf">Learn more about our data collection guidelines pertaining to sexual orientation.

Comorbidities * Underlying conditions are reported when a person has one or more underlying health conditions at the time of diagnosis or death.

Homelessness Persons are identified as homeless based on several data sources: * self-reported living situation * the location at the time of testing * Department of Public Health homelessness and health databases * Residents in Single-Room Occupancy hotels are not included in these figures. These methods serve as an estimate of persons experiencing homelessness. They may not meet other homelessness definitions.

Single Room Occupancy (SRO) tenancy * SRO buildings are defined by the San Francisco Housing Code as having six or more "residential guest rooms" which may be attached to shared bathrooms, kitchens, and living spaces. * The details of a person's living arrangements are verified during case interviews.

Transmission Type * Information on transmission of COVID-19 is based on case interviews with individuals who have a confirmed positive test. Individuals are asked if they have been in close contact with a known COVID-19 case. If they answer yes, transmission category is recorded as contact with a known case. If they report no contact with a known case, transmission category is recorded as community transmission. If the case is not interviewed or was not asked the question, they are counted as unknown.

C. UPDATE PROCESS This dataset has been archived and will no longer update as of 9/11/2023.

D. HOW TO USE THIS DATASET Population estimates are only available for age groups and race/ethnicity categories. San Francisco population estimates for race/ethnicity and age groups 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 includes many different types of characteristics. Filter the “Characteristic Type” column to explore a topic area. Then, the “Characteristic Group” column shows each group or category within that topic area and the number of cases on each date.

New cases are the count of cases within that characteristic group where the positive tests were collected on that specific specimen collection date. Cumulative cases are the running total of all San Francisco cases in that characteristic group up to the specimen collection date listed.

This data may not be immediately available for recently reported cases. Data updates as more information becomes available.

To explore data on the total number of cases, use the ARCHIVED: COVID-19 Cases Over Time dataset.

E. CHANGE LOG

• 9/11/2023 - data on COVID-19 cases by population characteristics over time are no longer being updated. The date on which each population characteristic type was archived can be found in the field “data_loaded_at”.
• 6/6/2023 - data on cases by transmission type have been removed. See section ARCHIVED DATA for more detail.
• 5/16/2023 - data on cases by sexual orientation, comorbidities, homelessness, and single room occupancy have been removed. See section ARCHIVED DATA for more detail.
• 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 “population_estimate” column to reflect the 2020 Census Bureau American Community Survey (ACS) San Francisco Population estimates.
• 1/5/2023 - data on SNF cases removed. See section ARCHIVED DATA for more detail.
• 3/23/2022 - ‘Native American’ changed to ‘American Indian or Alaska Native’ to align with the census.
• 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.