Test data only

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
Updated daily, dataset uploaded manually by staff

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

Data shown here include all San Francisco hospitals and will be updated daily with a two-day lag as information is collected and verified. Data may change as more current information becomes available.

A. SUMMARY
Data on daily hospital bed use and available capacity at San Francisco acute care hospitals from April 2020 onward. Long Term Care facilities (like Laguna Honda and Kentfield) are not included in this data as acute care patients cannot be admitted to these facilities.
B. HOW THE DATASET IS CREATED
This hospital capacity information is based on data that all SF acute care hospitals report to the San Francisco Department of Public Health.
C. UPDATE PROCESS
Updated daily, dataset uploaded manually by staff. This data is on a 2-day lag to account for the time needed to get complete data from all SF acute care hospitals and validate this data.
D. HOW TO USE THIS DATASET
This data provides visibility into current occupancy levels and use of San Francisco acute care hospitals and potential ability to accommodate anticipated surges of COVID patients.
Data includes current census of COVID-19 patients (including both confirmed cases and suspected COVID patients) and other patients in acute care hospitals, shown in the “Status” column. The “Status” column also includes all available beds.
This daily census information is stratified by type of bed (acute care, intensive care, and surge) in the “Bed Type” column. Acute care beds treat patients with illnesses and injuries including recovery from surgeries. Intensive care (ICU) beds are for sicker patients in need of critical and life support services that can include the use of a ventilator. Surge beds are the additional beds that can be made available to handle an influx of COVID-19 patients; surge beds are differentiated between acute care surge beds and ICU surge beds.
Note: The current census of COVID patients shown here may not always match the hospitalizations data (https://data.sfgov.org/COVID-19/COVID-19-Hospitalizations/nxjg-bhem), as that data includes all hospitals and long term care facilities. As described above, those long term care facilities are not included here as they don’t have the capacity to take in additional acute care patients and therefore aren’t included in capacity measures.

A. SUMMARY
This dataset represents the COVID-19 positive confirmed cases and deaths by day and transmission type. Demographic and transmission data are based on information reported from case interviews, laboratories, and providers. This data may not be immediately available for recently reported cases and data will change to reflect as information becomes available.

B. HOW THE DATASET IS CREATED
Information on cases and deaths including case demographic and transmission details is reported from a combination of data sources including electronic and faxed laboratory reports, case interviews, medical providers, and electronic medical record systems. These multiple streams of data are merged, deduplicated, undergo quality assurance and other data verification processes, and are continually updated to maximize completeness of information and reporting on San Francisco residents with COVID-19.

C. UPDATE PROCESS
Updated daily, dataset uploaded manually by staff

D. HOW TO USE THIS DATASET
Case counts are provided by category of the disposition. Confirmed are those cases where lab testing was positive, deaths are those cases of infection resulting in death. To get counts in either category, you must filter the Case Type Disposition or pivot the data.

Transmission Category can be Community, Contact or Unknown. Unknowns may become known as more information becomes available about cases.

There are three other datasets related to cases:
1. COVID-19 Cases Summarized by Age Group
2. COVID-19 Cases Summarized by Race and Ethnicity
3. COVID-19 Cases Summarized by Gender

A. SUMMARY
This dataset represents the COVID-19 positive confirmed cases by homelessness. Demographic and transmission data are based on information reported from case interviews, laboratories, and providers. This data may not be immediately available for recently reported cases and data will change to reflect as information becomes available. Cumulative counts of 5 or fewer are excluded from the dataset.

B. HOW THE DATASET IS CREATED
Information on cases and deaths including case demographic and transmission details is reported from a combination of data sources including electronic and faxed laboratory reports, case interviews, medical providers, and electronic medical record systems. These multiple streams of data are merged, deduplicated, undergo quality assurance and other data verification processes, and are continually updated to maximize completeness of information and reporting on San Francisco residents with COVID-19. Data are prepared by close of business daily for public display.

C. UPDATE PROCESS
Updated daily, dataset uploaded manually by staff

D. HOW TO USE THIS DATASET
Unknowns may become known over time as more information is gathered.

Categories resulting in 5 or fewer cumulative cases are dropped for privacy reasons.

There are two other datasets related to cases:
1. COVID-19 Cases Summarized by Date, Transmission and Case Disposition
2. COVID-19 Cases Summarized by Race and Ethnicity
3. COVID-19 Cases Summarized by Age Group

A. SUMMARY
This dataset represents the COVID-19 positive confirmed cases by gender. Demographic and transmission data are based on information reported from case interviews, laboratories, and providers. This data may not be immediately available for recently reported cases and data will change to reflect as information becomes available. Cumulative counts of 5 or fewer are excluded from the dataset.

B. HOW THE DATASET IS CREATED
Information on cases and deaths including case demographic and transmission details is reported from a combination of data sources including electronic and faxed laboratory reports, case interviews, medical providers, and electronic medical record systems. These multiple streams of data are merged, deduplicated, undergo quality assurance and other data verification processes, and are continually updated to maximize completeness of information and reporting on San Francisco residents with COVID-19. Data are prepared by close of business daily for public display.

C. UPDATE PROCESS
Updated daily, dataset uploaded manually by staff

D. HOW TO USE THIS DATASET
Unknowns may become known over time as more information is gathered.

Gender groups resulting in 5 or fewer cumulative cases are dropped for privacy reasons.

There are two other datasets related to cases:
1. COVID-19 Cases Summarized by Date, Transmission and Case Disposition
2. COVID-19 Cases Summarized by Race and Ethnicity
3. COVID-19 Cases Summarized by Age Group

A. SUMMARY
This dataset represents the COVID-19 positive confirmed cases by race and ethnicity. Demographic and transmission data are based on information reported from case interviews, laboratories, and providers. This data may not be immediately available for recently reported cases and data will change to reflect as information becomes available. Cumulative counts of 5 or fewer are excluded from the dataset.

B. HOW THE DATASET IS CREATED
Information on cases and deaths including case demographic and transmission details is reported from a combination of data sources including electronic and faxed laboratory reports, case interviews, medical providers, and electronic medical record systems. These multiple streams of data are merged, deduplicated, undergo quality assurance and other data verification processes, and are continually updated to maximize completeness of information and reporting on San Francisco residents with COVID-19. Data are prepared by close of business daily for public display.

C. UPDATE PROCESS
Updated daily, dataset uploaded manually by staff

D. HOW TO USE THIS DATASET
Unknowns may become known over time as more information is gathered.

Race/Ethnicity groups resulting in 5 or fewer cumulative cases are dropped for privacy reasons.

There are three other datasets related to cases:
1. COVID-19 Cases Summarized by Date, Transmission and Case Disposition
2. COVID-19 Cases Summarized by Gender
3. COVID-19 Cases Summarized by Age Group

A. SUMMARY
This dataset represents the COVID-19 positive confirmed cases by age group. Demographic and transmission data are based on information reported from case interviews, laboratories, and providers. This data may not be immediately available for recently reported cases and data will change to reflect as information becomes available. Cumulative counts of 5 or fewer are excluded from the dataset.

B. HOW THE DATASET IS CREATED
Information on cases and deaths including case demographic and transmission details is reported from a combination of data sources including electronic and faxed laboratory reports, case interviews, medical providers, and electronic medical record systems. These multiple streams of data are merged, deduplicated, undergo quality assurance and other data verification processes, and are continually updated to maximize completeness of information and reporting on San Francisco residents with COVID-19. Data are prepared by close of business daily for public display.

C. UPDATE PROCESS
Updated daily, dataset uploaded manually by staff

D. HOW TO USE THIS DATASET
Age groups are binned in to the following groups to minimize re-identifcation:
<18, 18-30, 31-40, 41-50, 51-60, 61-70, 71-80, 81+, Unknown

Unknowns may become known over time as more information is gathered.

age groups resulting in 5 or fewer cumulative cases are dropped for privacy reasons.

There are two other datasets related to cases:
1. COVID-19 Cases Summarized by Date, Transmission and Case Disposition
2. COVID-19 Cases Summarized by Race and Ethnicity
3. COVID-19 Cases Summarized by Age Group

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.

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
Updated daily

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.

The Health Department has developed an inspection report and scoring system. After conducting an inspection of the facility, the Health Inspector calculates a score based on the violations observed. Violations can fall into:high risk category: records specific violations that directly relate to the transmission of food borne illnesses, the adulteration of food products and the contamination of food-contact surfaces.moderate risk category: records specific violations that are of a moderate risk to the public health and safety.low risk category: records violations that are low risk or have no immediate risk to the public health and safety.The score card that will be issued by the inspector is maintained at the food establishment and is available to the public in this dataset.
San Francisco's LIVES restaurant inspection data leverages the LIVES Flattened Schema (https://goo.gl/c3nNvr), which is based on LIVES version 2.0, cited on Yelp's website (http://www.yelp.com/healthscores).