
(I had a few hours to spare)
Itâs based on the newly-released HHS dataset. The data itself is directionally solid (H/T to the data team at HHS).
Explore by visiting the @CodersCovid site:
https://reports.codersagainstcovid.org/hospitals
You can look at the national picture, or focus on one (or more states) just by adjusting the state filter at the top.
The other filters are dynamic: changing one automatically adjusts all of the others so that youâre only working with the data you want.
Hereâs Texas:
The other filters are dynamic: changing one automatically adjusts all of the others so that youâre only working with the data you want.
Hereâs Texas:
The drop-down filter for âCountyâ is searchable, so you can quickly find information about where you live.
Side note: youâll be surprised to see how many counties in the U.S. have 0 hospitals
Side note: youâll be surprised to see how many counties in the U.S. have 0 hospitals

I included a searchable filter for hospital names, too. This is helpful if youâre looking for historical trends.
Notes:
Reporting requirements have evolved, and you can see hiccups in the data. Donât worry: the data is *directionally* accurate â focus on the trend
Notes:

Note on hospital names (cont.)
There are several field hospitals in the dataset. These donât have a name, hence the ânullâ values here. Iâll make some time later this week to clean up the dataset a little more and make this context self-evident.

Thereâs also a filter for the *kind of hospital*
A few notes:
âShort Termâ is what we all think of when we say âhospitalâ
âLong termâ hospitals focus on rehabilitation. A #COVID19 patient might end up in one of these if they need ventilator support for a long timeâŚ.
A few notes:



âCritical Access Hospitalsâ (cont.): CAHs provide a âsafety netâ for rural communities, but looking at them on a map is misleading.
There are 1300 of them, they're everywhere, right?âŚ
There are 1300 of them, they're everywhere, right?âŚ
Donât be fooled by the map: all of those Critical Access Hospitals are *tiiiiiiny* â all told, weâre talking about 35,000 beds.
For context, the state of Texas has over 62,000 beds.
For context, the state of Texas has over 62,000 beds.

Pediatric medical data is *exceedingly* difficult to de-identify. I wonât get into the details, but suffice it to say that a domino effect results in most of the peds data getting censored.
âWhat parts of the country are running low on ICU capacity?â
This is mission-critical information that will help us mobilize resources, so I added a dedicated filter for that, too.
And we have another eye-opening revelation:
1 out of every 3 *hospitals* donât have an ICUâŚ
This is mission-critical information that will help us mobilize resources, so I added a dedicated filter for that, too.
And we have another eye-opening revelation:
1 out of every 3 *hospitals* donât have an ICUâŚ

So, where are these âICU desertsâ? Everywhere. Many are Critical Access Hospitals, all but a few are in rural America.
Health disparities take many forms, and they affect people of all races and ethnicities: âICU desertsâ illustrate how geography can be drive poor health outcomes. *This* is why data is critical: we canât fix what we canât see.
Now, try filtering for ICU capacity < 15%âŚ
Now, try filtering for ICU capacity < 15%âŚ
This is what keeps me up at night: metro hubs are running out of ICU beds.
Thatâs a *huge* problem b/c US healthcare delivery is predicated on the notion that small, rural communities always have the ability to transfer patients to âhigher levels of careâ
Thatâs a *huge* problem b/c US healthcare delivery is predicated on the notion that small, rural communities always have the ability to transfer patients to âhigher levels of careâ
Remember the thousands of critical access hospitals?
Recall that 1 out of 3 hospitals in America donât even have the *physical space* for an ICU (let alone the staff)?
Where are these #COVID19 patients going to go if thereâs no room in Sacramento, SLC, San Francisco, Las Vegas?
Recall that 1 out of 3 hospitals in America donât even have the *physical space* for an ICU (let alone the staff)?
Where are these #COVID19 patients going to go if thereâs no room in Sacramento, SLC, San Francisco, Las Vegas?
What about all of these #COVID19 patients that are waiting in the wings?
Or all of these #COVID19 patients that found out that they contracted a deadly virus within the last couple of weeks?
Weâre already running out of ICU capacity throughout the country.
These are all the hospitals that have less than 15% of their ICU capacity remaining.
Itâs not just California, Itâs also Arizona as @Cleavon_MD has called out several times per week for several weeks.
These are all the hospitals that have less than 15% of their ICU capacity remaining.
Itâs not just California, Itâs also Arizona as @Cleavon_MD has called out several times per week for several weeks.
Itâs also El Paso, every metro hub in TX + the Panhandle, OK, Missouri, Mississippi, Louisiana, Alabama, ATL, FloridaâŚthe northeast, the midwest, the northwestâŚ
cc @OliviaTroye @morgfair @PeterHotez @ashtonpittma @drmt @NicoleCarrWSB @DWUhlfelderLaw @IHME_UW @juliettekayyem
cc @OliviaTroye @morgfair @PeterHotez @ashtonpittma @drmt @NicoleCarrWSB @DWUhlfelderLaw @IHME_UW @juliettekayyem
And to round everything out: thereâs *also* a racial and ethnic disparity in access to hospital care: there are fewer hospitals and fewer hospital beds per 100K persons in counties where >55% of the population are persons of color.
cc @DrNunezSmith
cc @DrNunezSmith
So, taken together, these data show us that:
weâre running out of hospital capacity at the local level *and* regional levels
geographic *and* racial/ethnic disparities are each playing a role in creating a bottle neck in ICU-level care
(cont.)


(cont.)

(cont.)
Final words:
The vaccine is coming, but it wonât be here in time to save us from the next 2 waves, which will hit us in the next 1-2 weeks.
We can *and must* do more to protect ourselves: #WearAMask
and #HunkerDown
Plan for virtual holiday gatherings for the rest of year




Above all: donât lose sight of the fact that we will get through this.
There are better days ahead. I want you to be there to enjoy them. Your friends and family do, too.
So long as we focus on what we *have* to do now, weâll get back to what we *want* to do in the future./
There are better days ahead. I want you to be there to enjoy them. Your friends and family do, too.
So long as we focus on what we *have* to do now, weâll get back to what we *want* to do in the future./
