I continue to check my little dashboard of San Francisco COVID numbers each morning to figure out whether visiting the nearby university food court for a burrito is a pleasant convenience or the event doctors will pinpoint as the most likely cause of my resulting long-term lung problems. You may recall that about a month ago, the California Department of Public Health frustrated me by switching from their old system, which had a handy way for my dashboard to fetch a spreadsheet with wastewater data to a new system which didn't. I wrote to them, but they never wrote back, sigh. So I looked over their new dashboard system (tried to figure out how to write an automatic scraper to fetch the data; failed to immediately find a needle of data-download-link in a haystack of javascript; gave up quickly) and just figured out a system by which I visit the CDPH dashboard once every few days, download their spreadsheet by hand like a caveman, and then a script copies the spreadsheet from my Downloads folder to a place where my dashboard can use it.
tl;dr, my little dashboard is working again, albeit with some manual clunkiness. The wastewater data will always be a little behind… but that was already true.
