sfgov/covid19-tests-by-race-ethnicity-and-date-kja3-qsky

  • covid
  • covid-19
  • covid19 testing
  • ethnicity
  • lab testing
  • + 4

Covid-19 Tests by Race Ethnicity and Date

Covid-19 Tests by Race Ethnicity and Date

<i><b>Note: As of April 16, 2021, this dataset will update daily with a five-day data lag.</i></b>

<strong>A. SUMMARY</strong>

This dataset includes San Francisco COVID-19 tests by race/ ethnicity and date. For each day, this dataset represents the daily count of tests collected by race/ethnicity, and how many of those were positive, negative, and indeterminate. Tests in this dataset include all tests collected from San Francisco residents who listed a San Francisco home address at the time of testing, and tests that were collected in San Francisco but had a missing home address. Data are based on information collected at the time of testing.

For recent data, about 25-30% of tests are missing race/ ethnicity information. Tests where the race/ ethnicity of the patient is unknown are included in the dataset under the "Unknown" category.

This data was 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).

<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. During this investigation, some test results are found to be for persons living outside of San Francisco and some people in San Francisco may be tested multiple times. In both cases, these results are not included in San Francisco’s total COVID-19 case count. To track the number of cases by race/ ethnicity, see this dashboard: https://data.sfgov.org/stories/s/w6za-6st8

<strong>B. 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>C. UPDATE PROCESS</strong>

Updates automatically at 05:00 Pacific Time each day. Redundant runs are scheduled at 07:00 and 09:00 in case of pipeline failure.

<strong>D. 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 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 data user can analyze this data by "specimen_collection_date".

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://data.sfgov.org/stories/s/nudz-9tg2

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/dataset/Covid-19-Testing-by

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Specimen Collection Datespecimen_collection_datespecimen_collection_dateCalendar date
New Positive Testsnew_positive_testsnew_positive_testsNumber
last_updated_atlast_updated_atlast_updated_atCalendar date
New Indeterminate Testsnew_indeterminate_testsnew_indeterminate_testsNumber
Cumulative Indeterminate Testscumulative_indeterminate_testscumulative_indeterminate_testsNumber
New Negative Testsnew_negative_testsnew_negative_testsNumber
Total New Teststotal_new_teststotal_new_testsNumber
Total Cumulative Teststotal_cumulative_teststotal_cumulative_testsNumber
Cumulative Negative Testscumulative_negative_testscumulative_negative_testsNumber
Cumulative Positive Testscumulative_positive_testscumulative_positive_testsNumber
data_loaded_atdata_loaded_atdata_loaded_atCalendar date
Race Ethnicity Sort Orderrace_ethnicity_sort_orderrace_ethnicity_sort_orderNumber
Race Ethnicityrace_ethnicityrace_ethnicityText

Upstream Metadata