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 National Healthcare Safety Network (NHSN) and provided by the California Department of Public Health (CDPH).

C. UPDATE PROCESS
Updates automatically at 04:00 Pacific Time each day.

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 weekly with data for the past Sunday-Saturday as information is collected and verified. Data may change as more current information becomes available.

E. CHANGE LOG

• 8/7/2023 - In response to the end of the federal public health emergency on 5/11/2023 the California Hospital Association (CHA) stopped the collection and dissemination of COVID-19 hospitalization data. In alignment with the California Department of Public Health (CDPH), hospitalization data from 5/11/2023 onward are being pulled from the National Healthcare Safety Network (NHSN). The NHSN data is updated weekly and does not include information on COVID suspected (PUI) patients.
  
• 4/9/2021 - dataset updated daily with a four-day data lag.

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

• 9/11/2023 – Data on COVID-19 cases over time are no longer being updated. This data is currently through 9/6/2023 and will not include any new data after this date.
  
• 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.

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

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

• 6/21/2023 - A small number of additional COVID-19 testing records were released as part of our ongoing data cleaning efforts.
  
• 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
This dataset contains COVID-19 positive confirmed cases aggregated by several different geographic areas and by day. COVID-19 cases are mapped to the residence of the individual and shown on the date the positive test was collected. In addition, 2016-2020 American Community Survey (ACS) population estimates are included to calculate the cumulative rate per 10,000 residents.

Dataset covers cases going back to 3/2/2020 when testing began. This data may not be immediately available for recently reported cases and data will change to reflect as information becomes available. Data updated daily.

Geographic areas summarized are:
1. Analysis Neighborhoods
2. Census Tracts
3. Census Zip Code Tabulation Areas

B. HOW THE DATASET IS CREATED
Addresses from the COVID-19 case data are geocoded by the San Francisco Department of Public Health (SFDPH). Those addresses are spatially joined to the geographic areas. Counts are generated based on the number of address points that match each geographic area for a given date.</