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>
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:
<a href="https://data.sfgov.org/COVID-19/Covid-19-Tests/nfpa-mg4g">COVID-19 Tests</a>
|Name||Socrata field name||Column name in ||Data type||Description|
|Specimen Collection Date||specimen_collection_date||specimen_collection_date||Calendar date|
|New Positive Tests||new_positive_tests||new_positive_tests||Number|
|New Indeterminate Tests||new_indeterminate_tests||new_indeterminate_tests||Number|
|Cumulative Indeterminate Tests||cumulative_indeterminate_tests||cumulative_indeterminate_tests||Number|
|New Negative Tests||new_negative_tests||new_negative_tests||Number|
|Total New Tests||total_new_tests||total_new_tests||Number|
|Total Cumulative Tests||total_cumulative_tests||total_cumulative_tests||Number|
|Cumulative Negative Tests||cumulative_negative_tests||cumulative_negative_tests||Number|
|Cumulative Positive Tests||cumulative_positive_tests||cumulative_positive_tests||Number|
|Race Ethnicity Sort Order||race_ethnicity_sort_order||race_ethnicity_sort_order||Number|