Covid Capacity mapping for March 23rd

So I found two really interesting data sources. The first is a list of every single licensed hospital bed for every healthcare facility that is licensed by the California Department of Public Health (link). The second is a list of Coronavirus infections by county provided by the LA times (link). Since many Coronavirus victims require care in an intensive care bed, I thought it would be useful/scary to track the number of people we can expect to require treatment in an intensive care bed as a percentage of all intensive care beds by county. This lead to the following image:

 

And this table:

I estimated the ICU cases by dividing the case number by 10, based on the experience of Italian doctors as reported by the Washington Post.

County PercentCapacityUsed BED_CAPACITY Cases EstimatedICUCases
san benito 15 4 6 0.6
marin 12.6666666667 30 38 3.8
san mateo 12.2916666667 96 118 11.8
santa cruz 11.5384615385 13 15 1.5
santa clara 6.8949771689 438 302 30.2
san luis obispo 5.625 48 27 2.7
mono 5 2 1 0.1
monterey 4.6666666667 30 14 1.4
san joaquin 4.5555555556 90 41 4.1
yolo 4.2857142857 14 6 0.6
sonoma 3.75 72 27 2.7
contra costa 3.6094674556 169 61 6.1
alameda 3.6082474227 291 105 10.5
amador 3.3333333333 6 2 0.2
san francisco 3.3128834356 326 108 10.8
san diego 2.9421487603 605 178 17.8
calaveras 2.5 8 2 0.2
siskiyou 2.5 8 2 0.2
ventura 2.4390243902 123 30 3
santa barbara 2.2784810127 79 18 1.8
imperial 2.1428571429 28 6 0.6
placer 2.0689655172 58 12 1.2
los angeles 1.9160839161 2145 411 41.1
solano 1.7073170732 82 14 1.4
tulare 1.6923076923 65 11 1.1
orange 1.5472312704 614 95 9.5
sacramento 1.4095744681 376 53 5.3
nevada 1.25 8 1 0.1
yuba 1.25 24 3 0.3
riverside 1.1904761905 378 45 4.5
stanislaus 0.8695652174 92 8 0.8
humboldt 0.7692307692 26 2 0.2
el dorado 0.7142857143 28 2 0.2
mendocino 0.625 16 1 0.1
madera 0.5769230769 52 3 0.3
butte 0.4255319149 47 2 0.2
merced 0.4166666667 24 1 0.1
napa 0.4166666667 48 2 0.2
fresno 0.4026845638 149 6 0.6
san bernardino 0.3497942387 486 17 1.7
shasta 0.2857142857 70 2 0.2
kern 0.2580645161 155 4 0.4
colusa 0 6 0 0
del norte 0 6 0 0
inyo 0 4 0 0
kings 0 22 0 0
lake 0 8 0 0
tehama 0 8 0 0
tuolumne 0 6 0 0
alpine 0 0 0 0
glenn 0 0 0 0
lassen 0 0 0 0
mariposa 0 0 0 0
modoc 0 0 0 0
plumas 0 0 0 0
sierra 0 0 0 0
sutter 0 0 0 0
trinity 0 0 0 0

 

Leave a Reply

Your email address will not be published. Required fields are marked *