COVID-19 Cases Over Time

data.sfgov.org | Last Updated 8 Aug 2022

Note: 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. Some fluctuation in historic data may result when this change is implemented on July 15, 2022. Note: On January 22, 2022, system updates to improve the timeliness and accuracy of San Francisco COVID-19 cases and deaths data were implemented. You might see some fluctuations in historic data as a result of this change. Due to the changes, starting on January 22, 2022, the number of new cases reported daily will be higher than under the old system as cases that would have taken longer to process will be reported earlier. <strong>A. SUMMARY</strong> This dataset represents San Francisco COVID-19 positive confirmed cases by specimen collection date. Cases are included on the date the positive test was collected (the specimen collection date). Data is lagged by five days, meaning the most recent specimen collection date included is 5 days prior to today. All data update daily as more information becomes available. <strong>B. HOW THE DATASET IS CREATED</strong> Case information is based on confirmed positive laboratory tests reported to the City. The City then completes quality assurance and other data verification processes. This data may not be immediately available for recently reported cases because of the time needed to process tests and validate cases. Daily case totals on previous days may increase or decrease. <a href="https://sf.gov/information/covid-19-data-questions">Learn more</a>. Data are continually updated to maximize completeness of information and reporting on San Francisco residents with COVID-19. <strong>C. UPDATE PROCESS</strong> Updates automatically at 05:00 AM Pacific Time each day. Redundant runs are scheduled at 07:00 AM and 09:00 AM in case of pipeline failure. Dataset will not update on the business day following any federal holiday. <strong>D. HOW TO USE THIS DATASET</strong> This dataset shows new cases and cumulative cases by specimen collection date. Specimen collection date is the date the positive test was collected (the date the person was tested). New cases are the count of cases where the positive tests were collected on that specific specimen collection date. Cumulative cases are the running total of all San Francisco cases up to the specimen collection date listed. Use <a href="https://data.sfgov.org/d/j7i3-u9ke">the Cases by Population Characteristics dataset</a> to see cases by different subgroups including race/ethnicity, age, gender, and homelessness.

This dataset has the following 5 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Specimen Collection Datespecimen_collection_datecalendar_dateThe date the positive test was collected (the date the person was tested)
New Casesnew_casesnumberCases are counted as confirmed on the date of specimen collection after a positive lab test result
Cumulative Casescumulative_casesnumberCumulative Cases
Data As Ofdata_as_ofcalendar_dateTimestamp for last update date in source system
Data Loaded Atdata_loaded_atcalendar_dateTimestamp when data entered the Socrata System