Covid-19 Tests by Race Ethnicity and Date

data.sfgov.org | Last Updated 7 Aug 2022

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 April 16, 2021, this dataset will update daily with a five-day data lag. Note: As of February 2022, the way race/ethnicity is categorized has been changed. See Section B for additional information. <strong>A. SUMMARY</strong> 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. <strong>The total number of positive test results is not equal to the total number of COVID-19 cases in San Francisco.</strong> 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.” <strong>B. NOTE ON RACE/ETHNICITY</strong> 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." On February 10, 2022, the method for which race/ethnicity is categorized was updated for the sake of data accuracy, clarity, and stability. The new 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 a SF provider. All persons across all races who identify as Hispanic/Latino are recorded as “"Hispanic or Latino/a, all races." The new 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,” or “White” for their first COVID-19 test, then that data will not change—even if a different race/ethnicity is reported for them for any future COVID-19 tests. There are two exceptions to this rule. The first exception is that if a person marks “Other” or “Unknown” on their first test and then on a subsequent test they report “Asian;” "Black or African American;" "Hispanic or Latino/a, all races;" "American Indian or Alaska Native;" "Native Hawaiian or Other Pacific Islander;" or "White”, then this subsequent reported race/ethnicity will overwrite the previous recording of “Other” or “Unknown”. If a person has only ever selected “Other” or “Unknown” as their race/ethnicity, then it will be recorded as “Other” or “Unknown.” This change provides more specific and actionable data on who is tested in San Francisco. The second exception is that if a person ever marks “Hispanic or Latino/a, all races” for race/ethnicity then this choice will always overwrite any previous or future answer. This is because it is an overarching category that can include any and all other races and is mutually exclusive with the other answers. A person's race/ethnicity will be recorded as “Multi-racial” if they select two or more values among the following choices: “Asian,” “Black or African American,” “American Indian or Alaska Native,” “Native Hawaiian or Other Pacific Islander,” “White,” or “Other.” If a person selects a combination of two or more race/ethnicity answers that includes “Hispanic or Latino/a, all races” then they will still be recorded as “Hispanic or Latino/a, all races”—not as “Multi-racial.” <strong>C. HOW THE DATASET IS CREATED</strong> 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. <strong>D. UPDATE PROCESS</strong> Updates automatically at 5:00AM Pacific Time each day. Redundant runs are scheduled at 7:00AM and 9:00AM in case of pipeline failure. <strong>E. HOW TO USE THIS DATASET</strong> 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, 2020 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 user can analyze this data by sorting or filtering by the "specimen_collection_date" field. Calculating Percent Positivity: The positivity rate is the percentage of tests that return a positive result for COVID-19 (positive tests divided by the sum of positive and negative tests). Indeterminate results, which could not conclusively determine whether COVID-19 virus was present, are not included in the calculation of percent positive. When there are fewer than 20 positives tests for a given race/ethnicity and time period, the positivity rate is not calculated for the public tracker because rates of small test counts are less reliable. Calculating Testing Rates: To calculate the testing rate per 10,000 residents, divide the total number of tests collected (positive, negative, and indeterminate results) for the specified race/ethnicity by the total number of residents who identify as that race/ethnicity (according to the <a href="https://data.census.gov/cedsci/table?q=race%2F%20ethnicity&g=0500000US06075&tid=ACSDP5Y2018.DP05&hidePreview=true">2018 5-year estimates from the American Community Survey</a>), then multiply by 10,000. When there are fewer than 20 total tests for a given race/ethnicity and time period, the testing rate is not calculated for the public tracker because rates of small test counts are less reliable. Read more about how this data is updated and validated daily: https://sf.gov/information/covid-19-data-questions There are two other datasets related to tests: 1. <a href="https://data.sfgov.org/COVID-19/Covid-19-Tests/nfpa-mg4g">COVID-19 Tests</a> 2. <a href="https://data.sfgov.org/COVID-19/Covid-19-Testing-by-Geography-and-Date/qhc5-mubk/data">COVID-19 Tests by Neighborhood and Date</a>

Tags: covid, covid-19, testing, test, lab testing, covid19 testing, race, race/ethnicity, ethnicity

This dataset has the following 14 columns:

Column NameAPI Column NameData Type
Specimen Collection Datespecimen_collection_datecalendar_date
Race Ethnicityrace_ethnicitytext
Race Ethnicity Sort Orderrace_ethnicity_sort_ordernumber
Population Estimatepopulation_estimatenumber
New Indeterminate Testsnew_indeterminate_testsnumber
New Negative Testsnew_negative_testsnumber
New Positive Testsnew_positive_testsnumber
Total New Teststotal_new_testsnumber
Cumulative Indeterminate Testscumulative_indeterminate_testsnumber
Cumulative Negative Testscumulative_negative_testsnumber
Cumulative Positive Testscumulative_positive_testsnumber
Total Cumulative Teststotal_cumulative_testsnumber
last_updated_atlast_updated_atcalendar_date
data_loaded_atdata_loaded_atcalendar_date