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.

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.

A. SUMMARY
This dataset represents the COVID-19 vaccinations given to San Franciscans over time. All vaccines given to people who live in San Francisco are included, no matter where the vaccination took place. (The vaccine may have been administered in San Francisco or outside of San Francisco.) The three dose types are counted separately, i.e. (1) first doses administered as a part of a two-dose vaccination, (2) second doses administered as part of a two-dose vaccination, and (3) single-dose vaccines administered.

B. HOW THE DATASET IS CREATED
Information on doses administered to those who live in San Francisco is from the California Immunization Registry (CAIR), run by the California Department of Public Health (CDPH).

C. UPDATE PROCESS
Updated daily via automated process

D. HOW TO USE THIS DATASET
Different vaccines have different dosage requirements. For example, the Moderna and the Pfizer vaccines requires two doses for a resident to be fully vaccinated. Each dose is recorded separately in its respective column. Other vaccines, such as Johnson & Johnson, would only require a single dose to be considered fully vaccinated. Single dose vaccines counts are recorded in a separate column.
Summing the NEW_1ST_DOSES, NEW_2ND_DOSES, NEW_SINGLE_DOSES columns would give you the total count of vaccine doses administered on a given day. To count the number of individuals fully vaccinated on a given day, use the NEW_SERIES_COMPLETED column. To count the number of individuals vaccinated (with any dose) for the first time on a given day, use the NEW_RECIPIENTS column.
In our public dashboards we combine this dataset with the US Census's 2019 five-year American Community Survey population estimates to estimate the percent of San Franciscans vaccinated.

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, 2019 American Community Survey (ACS) 5-year population estimates are included to calculate the cumulative rate per 10,000 residents.

Dataset covers cases going back to March 2nd, 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.

The 2019 ACS estimates for population provided by the Census are used to create a cumulative rate which is equal to ([cumulative count up to that date] / [acs_population]) * 10000) representing the number of total cases per 10,000 residents (as of the specified date).

COVID-19 case data undergo quality assurance and other data verification processes and are continually updated to maximize completeness and accuracy of information. This means data may change for previous days as information is updated.

C. UPDATE PROCESS
Geographic analysis is scripted by SFDPH staff and synced to this dataset daily at 05:00 Pacific Time.

D. HOW TO USE THIS DATASET
This dataset can be used to track the spread of COVID-19 throughout the city, in a variety of geographic areas. Note that the new cases column in the data represents the number of new cases confirmed in a certain area on the specified day, while the cumulative cases column is the cumulative total of cases in a certain area as of the specified date.

Privacy rules in effect
To protect privacy, certain rules are in effect:
1. Any area with a cumulative case count less than 10 are dropped for all days the cumulative count was less than 10. These will be null values.
2. Once an area has a cumulative case count of 10 or greater, that area will have a new row of case data every day following.
3. Cases are dropped altogether for areas where acs_population < 1000
4. Deaths data are not included in this dataset for privacy reasons. The low COVID-19 death rate in San Francisco, along with other publicly available information on deaths, means that deaths data by geography and day is too granular and potentially risky. Read more in our privacy guidelines

Rate suppression in effect where counts lower than 20
Rates are not calculated unless the cumulative case count is greater than or equal to 20. Rates are generally unstable at small numbers, so we avoid calculating them directly. We advise you to apply the same approach as this is best practice in epidemiology.

A note on Census ZIP Code Tabulation Areas (ZCTAs)
ZIP Code Tabulation Areas are special boundaries created by the U.S. Census based on ZIP Codes developed by the USPS. They are not, however, the same thing. ZCTAs are areal representations of routes. Read how the Census develops ZCTAs on their website.

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
Updates automatically at 05:00 Pacific Time each day. Redundant runs are scheduled at 07:00 and 09:00 in case of pipeline failure. This data is on a 4-day lag to account for the time needed to complete and validate data from all SF acute care hospitals.
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
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
Medical provider confirmed COVID-19 cases and confirmed COVID-19 related deaths in San Francisco, CA aggregated by several different geographic areas and normalized by 2019 American Community Survey (ACS) 5-year estimates for population data to calculate rate per 10,000 residents.

Cases and deaths are both mapped to the residence of the individual, not to where they were infected or died. For example, if one was infected in San Francisco at work but lives in the East Bay, those are not counted as SF Cases or if one dies in Zuckerberg San Francisco General but is from another county, that is also not counted in this dataset.

Dataset is cumulative and covers cases going back to March 2nd, 2020 when testing began.

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

B. HOW THE DATASET IS CREATED
Addresses from medical 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. The 2019 ACS estimates for population provided by the Census are used to create a rate which is equal to ([count] / [acs_population]) * 10000) representing the number of cases per 10,000 residents.

C. UPDATE PROCESS
Geographic analysis is scripted by SFDPH staff and synced to this dataset daily at 7:30 Pacific Time.

D. HOW TO USE THIS DATASET
Privacy rules in effect
To protect privacy, certain rules are in effect:
1. Case counts greater than 0 and less than 10 are dropped - these will be null (blank) values
2. Death counts greater than 0 and less than 10 are dropped - these will be null (blank) values
3. Cases and deaths dropped altogether for areas where acs_population < 1000

Rate suppression in effect where counts lower than 20
Rates are not calculated unless the case count is greater than or equal to 20. Rates are generally unstable at small numbers, so we avoid calculating them directly. We advise you to apply the same approach as this is best practice in epidemiology.

A note on Census ZIP Code Tabulation Areas (ZCTAs)
ZIP Code Tabulation Areas are special boundaries created by the U.S. Census based on ZIP Codes developed by the USPS. They are not, however, the same thing. ZCTAs are areal representations of routes. Read how the Census develops ZCTAs on their website.

Row included for Citywide case counts, incidence rate, and deaths
A single row is included that has the Citywide case counts and incidence rate. This can be used for comparisons. Citywide will capture all cases regardless of address quality. While some cases cannot be mapped to sub-areas like Census Tracts, ongoing data quality efforts result in improved mapping on a rolling bases.

A. SUMMARY
This dataset includes aggregate data on the type, status, population served, and individuals placed at each alternative housing site under contract with HSA.

B. HOW THE DATASET IS CREATED
Site Type, Status, and Population
The HSA DOC leadership inform the data tracker owner when the legal status, site type, or intended population to serve changes.

Daily Census and Units Available
The site monitors at each site inform the data tracker owner at the HSA DOC at least once daily with the updates to the daily census.

C. UPDATE PROCESS
Updated several times daily, whenever new information is shared with the data tracker owner. The data tracker owner inputs the data directly into the underlying SharePoint spreadsheet.

D. HOW TO USE THIS DATASET
Use the data for aggregate data on the site type, status, and daily census of individuals placed in the sites. Do not use this spreadsheet for individual-level information. There is no personally identifying or medical information in this dataset.

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

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.

A. SUMMARY
Medical provider confirmed COVID-19 cases and confirmed COVID-19 related deaths in San Francisco, CA aggregated by Census ZIP Code Tabulation Areas and normalized by 2018 American Community Survey (ACS) 5-year estimates for population data to calculate rate per 10,000 residents.

Cases and deaths are both mapped to the residence of the individual, not to where they were infected or died. For example, if one was infected in San Francisco at work but lives in the East Bay, those are not counted as SF Cases or if one dies in Zuckerberg San Francisco General but is from another county, that is also not counted in this dataset.

Dataset is cumulative and covers cases going back to March 2nd, 2020 when testing began. It is updated daily.

B. HOW THE DATASET IS CREATED
Addresses from medical 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. The 2018 ACS estimates for population provided by the Census are used to create a rate which is equal to ([count] / [acs_population]) * 10000) representing the number of cases per 10,000 residents.

C. UPDATE PROCESS
Geographic analysis is scripted by SFDPH staff and synced to this dataset each day.

D. HOW TO USE THIS DATASET
Privacy rules in effect
To protect privacy, certain rules are in effect:
1. Case counts greater than 0 and less than 10 are dropped - these will be null (blank) values
2. Cases dropped altogether for areas where acs_population < 1000

Rate suppression in effect where counts lower than 20
Rates are not calculated unless the case count is greater than or equal to 20. Rates are generally unstable at small numbers, so we avoid calculating them directly. We advise you to apply the same approach as this is best practice in epidemiology.

A note on Census ZIP Code Tabulation Areas (ZCTAs)
ZIP Code Tabulation Areas are special boundaries created by the U.S. Census based on ZIP Codes developed by the USPS. They are not, however, the same thing. ZCTAs are areal representations of routes. Read how the Census develops ZCTAs on their website.

This dataset is a filtered view of another dataset
You can find a full dataset of cases and deaths summarized by this and other geographic areas.