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. A redundant run is scheduled at 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

• 4/10/2024 - An issue with our testing data was identified and corrected leading to a small increase in testing records over time.
  
• 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
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 every week.

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

• 9/12/2024 -Hospitalization data are now being tracked through a new source and are available here.
  
• 5/1/2024 - hospitalization data reporting to the National Healthcare Safety Network (NHSN) changed from mandatory to optional for all hospitals nationwide. We will be pausing the refresh of the underlying data beginning 5/2/2024.
  
• 12/14/2023 – added column “hospitalreportingpct” to indicate the percentage of hospitals who submitted data on each report date.
  
• 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.

Contains buyout declarations and buyout agreements filed at the Rent Board. Rent Ordinance Section 37.9E, effective March 7, 2015, is a provision that regulates "buyout agreements" between landlords and tenants under which landlords pay tenants money or other consideration to vacate their rent-controlled rental units. For more information, please see: https://www.sf.gov/information/buyout-agreements

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

This data set includes the Office of the Assessor-Recorder’s secured property tax roll spanning from July 1, 2007 to June 30, 2023. It includes all legally disclosable information, including location of property, value of property, the unique property identifier, and specific property characteristics. The data is used to accurately and fairly appraise all taxable property in the City and County of San Francisco. The Office of the Assessor-Recorder makes no representation or warranty that the information provided is accurate and/or has no errors or omissions.

This dataset is updated annually after the roll is closed and certified. This typically happens by August of each year.

This report includes information about calls made to SF311, including: (1) number of calls answered, (2) service level (percentage of calls answered within 60 seconds), (3) average speed of answer (number of seconds to answer the call), and (4) transferred calls (percentage of calls transferred to another agency).

***As of November 2023, this map has been updated to use a new format. For details, please see here.*** The TIGER/Line Files are shapefiles and related database files (.dbf) that are an extract of selected geographic and cartographic information from the U.S. Census Bureaus Master Address File Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line File is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. Census Blocks are statistical areas bounded on all sides by visible features, such as streets, roads, streams, and railroad tracks, and/or by nonvisible boundaries such as city, town, township, and county limits, and short line-of-sight extensions of streets and roads. Census blocks are relatively small in area; for example, a block in a city bounded by streets. However, census blocks in remote areas are often large and irregular and may even be many square miles in area. A common misunderstanding is that data users think census blocks are used geographically to build all other census geographic areas, rather all other census geographic areas are updated and then used as the primary constraints, along with roads and water features, to delineate the tabulation blocks. As a result, all 2010 Census blocks nest within every other 2010 Census geographic area, so that Census Bureau statistical data can be tabulated at the block level and aggregated up to the appropriate geographic areas.

These records indicate the actual violations and comments by the inspector found during the inspection. The data should be sorted on the Complaint Number field and the Item Sequence Number field. The user should be able to link this file with the Department of Building Inspection Complaints dataset to get a more accurate picture of the violations.

Hourly rate steps for all stepped salary plans. See the City Employment Classification Definitions dataset for job descriptions and minimum qualifications for each position.