Solano County Issues Countywide Curfew Order for June 2 and June 3, 2020
[Editor: Peter Khoury ranks Solano County’s excellent COVID-19 Dashboard 3rd among the Bay Area’s 9 counties. He also points out areas for improvement. Read through to the end for Khoury’s call to action. – R.S.]
A ranking of Bay Area Counties’ COVID-19 DashboardsPhoenix Data Project, by Peter Khoury, April 2, 2020
The link article from the Harvard Business Review discusses Lessons from Italy’s response to Coronavirus. In particular they cite the need for lots of data, the need for micro-scale data, and the need for data standardization. The Bay Area is largely falling flat on all of these fronts. I rank the Bay Area counties’ dashboards below, but really they should all be unified displaying lots of consistent high quality information on all of them. At the bottom of the rankings I tell you how to take action.
These rankings are a tongue in cheek way to motivate / shame counties to improve the state of their information and communication with the public. However ideally the counties would all coordinate with each other and unify their information so that we can see trends across the entire Bay Area.
1st Place Santa Clara County
Santa Clara’s dashboard shot up in the rankings from 6th previously to 1st because it is not just one dashboard it is three. I’ve shown here to the left my favorite of the three, the hospital dashboard. This includes such vital information such as ventilators available and breaks down bed availability into acute beds and ICU beds. The graphs on the righthand side of the dashboard will show evolution of hospital resources over time. Really quality really excellent information.
Two additional asks which would make it even better. Create an API or easy way to download the data. Split the hospitalized patients into age groups like Solano county does.
2nd Place Sonoma County
Sonoma County’s dashboard excels. It has
the number of tests being run
the date the data was collected
cases by county region
the information in text form (if desired)
3rd Place Solano County
Solano county promises to have much of the information Sonoma county does but isn’t quite there yet.
The one thing Solano county deserves credit for is separating the cases by age into hospitalized and non-severe. This will be incredibly useful information going forward. I would encourage Solano county to further separate out the 19-64 year old age ranges.
4th Place Contra Costa County
Contra Costa County added information about testing and hospitalizations to their website. They’re also displaying the information as evolving over time which is good. There could be much more information at a finer granularity but its definitely good progress.
5th Place Marin County
Not nearly as good as the Solano and Sonoma but they are still providing hospitalization numbers. Their display of information could use a lot of work.
6th Place tie Napa and San Mateo County
San Mateo isn’t really providing much more than a case count and deaths. They do have this broken down by age but unlike the Solano county data the age breakdown doesn’t give me much additional useful information.
It does show the cases growing exponentially.
Napa county doesn’t break down the cases by age but it does breakdown the cases by area.
7th Place San Francisco
Last Place Joint Alameda and the City of Berkeley
The Alameda county website is incredibly flawed because of the “* Numbers exclude City of Berkeley cases.” I mean come on guys this is a local, regional, state, national, and global health emergency and Alameda County and the city of Berkeley can’t coordinate with each other?
I have found that the best way to improve your local county’s dashboard is to start calling your local politicians and to get your friends to call your local politicians. If you do not live in the Bay Area, go to your local county’s COVID-19 website and place it in these rankings. If you find it lacking, demand more information. At a minimum the website should have the information in bold.
Hospital beds available
ICU Beds available
Total number of tests conducted (this counts tests run multiple times on one person)
Total number of test conducted on unique individuals
Total number of tests that were positive for COVID-19
UPDATE: See today’s latest information
Thursday, April 2, 2020
Solano County reported 7 NEW POSITIVE CASES today – total is now 61. Today Solano County reported its FIRST DEATH.
As of today, 69 percent of positive cases were individuals between the ages of 19 and 64, and 31 percent were 65 were older. 23 of these are active cases (4 more than yesterday), and 22 of the total cases have resulted in hospitalizations (4 more than yesterday). The first reported case in Solano County was in Vacaville in February, which was also the first reported case in the United States of someone contracting the virus without having traveled abroad or knowingly come into contact with someone who tested positive.
Check out basic information in the screenshots here on Benicia Independent. IMPORTANT: Note the County’s interactive page has more. On the County website, you can click on “Number of cases” and then hover over the charts for detailed information.
The chart at right, “Cumulative number of cases…” gives a clear picture of the infection’s trajectory in Solano County. Our coronavirus data curve is on a steep upward trajectory. Everyone stay home and be safe!
Solano staff refuses to divulge WHERE in the County the positive cases reside.
Public health nurse first to test Solano residents from TravisBy Todd R. Hansen, Daily Republic, March 29, 2020
FAIRFIELD — Rodney Butterfield was not new to infectious diseases.
“As nurses, you frequently enter a space where a patient has an infectious disease,” said Butterfield, a 14-year veteran in the nursing profession, the past two as a registered nurse in the Solano County Public Health division. “But this was a little different.”
He volunteered to help test and track the health progress of four Solano County residents at their homes: three who had been released into Public Health care from Travis Air Force Base and one who is believed to have contracted the Covid-19 disease through a community contact.
Butterfield said the coronavirus was new to everyone – medical professionals and members of the public alike. There was very little information about it, and not all the information was correct, or it was changing so rapidly that even the medical profession struggled to keep up.
He said even today physicians are calling the Public Health office to make sense of the sometimes conflicting information, and there are frequent updates on how the virus can be transmitted.
The primary way, however, remains person-to-person, so health officials continue to emphasize the need to wash hands, keep a healthy distance from other people and to keep your environments clean and sanitized.
Even worse at the beginning, Butterfield noted, everyone who seemed to be getting Covid-19 were dying, if the scattered media reports were to be believed.
“So, yeah, it was a little scary because everything I’ve dealt with in the past was known,” Butterfield said. “It put you on a red alert to be cautious with all you did.”
But as cautious as the situation made Butterfield, he said his clients were truly scared.
“They were frightened. . . . At the time, they didn’t know anything about (the novel coronavirus). We didn’t know anything about it,” Butterfield said.
To make matters worse, and the isolation even more severe, neighbors were also uncertain and did not necessarily react with a sense of understanding or kindness.
“I don’t know what the neighbors said, but my clients felt ostracized,” Butterfield said.
“The question that was most penetrating for us was, ‘What is going to happen to us?’ ” Butterfield said of his clients’ concerns.
It was a question that had far-reaching effects, from the immediacy of their health to their families to what the future would be like for them.
Butterfield, who was a construction contractor in Utah in his first life and started his second career as a licensed vocational nurse in correctional facilities, said his four clients have recovered, and he has talked to two of them since.
“They were just thrilled that they were past this thing,” Butterfield said. “I think what they were thankful for the most was I was giving them the most updated information available.”
Butterfield has now returned to his normal duties, though he still fields calls about the new coronavirus. Many are from individuals who are concerned for their health because the companies they work for have not shut down or made any attempt to adhere to social guidelines.
Butterfield said the experience has made him wonder if he should have gone into research, because it will be researchers who find the ultimate cure.
“I just hope next year we will all be getting vaccinated for this,” Butterfield said.
Most people who have the new coronavirus experience only mild or moderate symptoms, such as fever and cough. Some people, especially older adults and those with underlying health problems, experience more severe illness such as pneumonia, or death.
The vast majority of people recover. The World Health Organization reports people with mild illness recover in about two weeks, while those with more severe illness may take three to six weeks to recover.