A. SUMMARY
Count of COVID+ patients admitted to the hospital. Patients who are hospitalized and test positive for COVID-19 may be admitted to an acute care bed (a regular hospital bed), or an intensive care unit (ICU) bed. This data shows the daily total count of COVID+ patients in these two bed types, and the data reflects totals from all San Francisco Hospitals.

B. HOW THE DATASET IS CREATED
Hospital information is based on admission data reported to the San Francisco Department of Public Health.

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

D. HOW TO USE THIS DATASET
Each record represents how many people were hospitalized on the date recorded in either an ICU bed or acute care bed (shown as Med/Surg under DPHCategory field).

The dataset shown here includes all San Francisco hospitals and updates daily with a four-day lag as information is collected and verified. Data may change as more current information becomes available.

E. CHANGE LOG

• 4/9/2021 - dataset updated daily with a four-day data lag.

Note: On 1/31/2023 we made the following changes:

• Renamed the column "last_updated_at" to "data_as_of"
  
• Added the following columns:
  
  • "cumulative_tests"
    
  • "cumulative_positive_tests"
    
  • "cumulative_negative_tests"
    
  • "cumulative_indeterminate_tests"

A. SUMMARY
Case information on COVID-19 Laboratory testing. This data includes a daily count of test results reported, and how many of those were positive, negative, and indeterminate. Reported tests include tests with a positive, negative or indeterminate result. Indeterminate results, which could not conclusively determine whether COVID-19 virus was present, are not included in the calculation of percent positive. Testing for the novel coronavirus is available through commercial, clinical, and hospital laboratories, as well as the SFDPH Public Health Laboratory.

Tests are de-duplicated by an individual and date. This means that if a person gets tested multiple times on different dates in the last 30 days, all of those individual tests will be included in this data as individual tests (on each specimen collection date).

Total positive test results is not equal to the total number of COVID-19 cases in San Francisco. 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 are duplicates of previously received positive results. These are not included in the total San Francisco COVID-19 case count. Additionally, investigation of positive test results might not be completed on the day of receipt; new cases will be added to the total case count after full investigation and verification.

B. HOW THE DATASET IS CREATED
Laboratory test volume and positivity for COVID-19 is based on electronic laboratory test reports. Deduplication, quality assurance measures and other data verification processes maximize accuracy of laboratory test information.

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

D. HOW TO USE THIS DATASET
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 "result_date" and see how the count of reported results and positivity rate have changed over time.

E. CHANGE LOG

• 1/31/2023 - renamed column “last_updated_at” to “data_as_of”.
  
• 1/31/2023 - added columns “cumulative_tests”, “cumulative_positive_tests”, “cumulative_negative_tests”, “cumulative_indeterminate_tests”.
  
• 4/16/2021 - dataset updated to refresh with a five-day data lag.

A. SUMMARY
A list of testing locations including address and coordinates for mapping.

B. HOW THE DATASET IS CREATED
Dataset is manually compiled by staff from the various testing providers.

C. UPDATE PROCESS
Data is updated as needed. If you have a site you'd like added to the dataset and map, please email DPH.DOC.Ops.Testing@sfdph.org.

D. HOW TO USE THIS DATASET
Dataset can be used to map locations of test sites and understand which require insurance and which do not. It is the base data used to power the user-facing map of testing locations at https://datasf.org/covid19-testing-locations

A. SUMMARY
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).

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.

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.

B. HOW THE DATASET IS CREATED
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. Learn more.

Data are continually updated to maximize completeness of information and reporting on San Francisco residents with COVID-19.

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

D. HOW TO USE THIS DATASET
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 the Cases by Population Characteristics dataset to see cases by different subgroups including race/ethnicity, age, gender, and homelessness.

E. CHANGE LOG

• 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.
  
• 9/28/2022 - backfilled 1,400 cases from the beginning of September 2022 due to an issue with CDPH data processing.
  
• 7/15/2022 - reinfections added to cases dataset. See section SUMMARY for more information on how reinfections are identified.
  
• 1/22/2022 - system updates to improve timeliness and accuracy of cases and deaths data were implemented.