San Francisco Data

Close
Author
OpenData
Description
<strong>A. SUMMARY</strong> 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. <strong>B. HOW THE DATASET IS CREATED</strong> 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. <a href="https://data.sfgov.org/stories/s/San-Francisco-COVID-19-Data-Questions/nudz-9tg2/">Learn more</a>. Data are continually updated to maximize completeness of information and reporting on San Francisco residents with COVID-19. <strong>C. UPDATE PROCESS</strong> 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. <strong>D. HOW TO USE THIS DATASET</strong> 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 <a href="https://data.sfgov.org/d/j7i3-u9ke">the Cases by Population Characteristics dataset</a> to see cases by different subgroups including race/ethnicity, age, gender, and homelessness.
Category
COVID-19
Rating
Current value: 0 out of 5
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Specimen Collection Date
specimen_collection_date
New Cases
new_cases
Cumulative Cases
cumulative_cases
Data As Of
data_as_of
Data Loaded At
data_loaded_at

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.