The San Francisco Department of Public Health provides daily updates each morning. We will do the same.
The most recent numbers from the Health Department show nine newly-announced confirmed cases, and no new announced deaths as of yesterday.
Of the newly-announced cases, three were added with a confirmation date of May 1, five, May 24, and seven, May 25. The confirmed case counts on six previous dates were also retroactively decreased by one: March 6, March 8, April 21, April 30, May 10, and May 20.
The Public Health Department said Monday it won’t be able to tell us why any particular tweak to the dataset was made. They also said they don’t keep old versions of data around, and can’t make them available to the public. “The current data set is updated daily and the automated process does not cache previous versions,” said Bryan Dahl, a Joint Information Center spokesperson.
At Mission Local, we feel it’s important to maintain a historic record of how the data is being retroactively adjusted. We aren’t attributing malice, and there are perfectly valid reasons why the Health Department should be retroactively updating data to give us the most complete picture of the pandemic as new information about past cases is uncovered.
But those changes need to be made with as much transparency as possible. People throughout the Bay Area and around the world are using the numbers to analyze the data and draw conclusions about how well we’re doing. If the data they’re basing those conclusions on is shifting beneath their feet, we need to document that and account for it.
We have started locally preserving the released datasets we have access to, which we will make publicly available. So far, we have reconstructed most of the data for the past two weeks or so, but there are holes, and we’re missing the bulk of the older data that came out earlier. If you or anyone you know has been downloading the data and would like to contribute to the archive, please reach out to us! We’d love to hear from you. What we are most interested in are CSV files exported from the city’s COVID-19 Cases Summarized by Date, Transmission and Case Disposition page.
Next week, we’ll update our tracker so it can show readers both the number of daily new cases as of the date the Health Department announces them, as well as the retroactively-adjusted dates the Health Department says those cases and deaths were confirmed on.
San Francisco’s daily numbers continue to look good, but as other counties are opening up, their numbers are starting – as expected – to go up. No one appears to have an answer as to where the cases are coming from, but the San Francisco Chronicle reports that anecdotal information says that construction may be one source.
Alameda County, which has had the biggest increase, has a seven-day average of 60 cases; Contra Costa, 25; Marin, 13; San Mateo, 23; Santa Clara 26; and San Francisco is at 36. KQED’s tracker is easy to use.
You will be hearing more from us on testing, but we want to remind you that it is available in San Francisco for all essential workers, free of charge, regardless of residency, and regardless of symptoms. If you would like to be tested, a list of locations can be found at sf.gov/GetTestedSF, or on the city’s interactive map. Moreover, it is free for any San Francisco adult with just one of the symptoms – including fatigue or a headache.
Our data tracker is embedded below, or click here for a full screen version. And, you can find all of our recent daily tracker stories here.
Producing all of this content keeps us busy and if you haven’t already, please support our efforts.
Please note:
The embedded data tracker below will continue to be updated daily after this post is published.
For the number of confirmed cases each day, our tracker is tracking the date on which the Health Department announced new confirmed cases, not the date which the department said those cases were confirmed on.
There is a discrepancy between the total number of positive test results reported by the city and the total daily number of confirmed cases. The discrepancy comes from a delay in fully investigating positive test results. In doing so, health investigators find some duplicates and some are for people who live outside of the city, according to epidemiologists at the Department of Public Health. New cases are only added to the daily confirmed cases after an investigation is completed.
Also, there is also a discrepancy between the hospitalization data reported by the San Francisco Department of Public Health (SFDPH) and the county hospital data reported by the California Department of Public Health (CDPH). This is because SFDPH receives data from one additional hospital, San Francisco VA Health Care System, that is not required to report to CDPH. “SFDPH statistics will trend higher as long as this hospital has patients admitted as either COVID-19 positive or suspected COVID-19 positive.”
“the automated process does not cache previous versions”. A data tracker that doesn’t track data. Brilliant!
Maybe you could fix it for all?
“the automated process does not cache previous versions”. Wow. Must be a crack team working on that system.