See what we collected at https://airtable.com/shrId9GL5mXSOHEGg/tblDQlqWVsC6e7hpb
After going thru and finding everything out there for all 50 states, we now know about 36K COVID cases among HCWs, which is the highest count i've seen so far and 4x the CDC reported number from last month. It's also higher than the 31K reported in this investigative report which just came out 2 days ago: https://www.revealnews.org/article/31000-and-counting/
What we have is still vastly incomplete with semi-outdated news sources. Only 10 states officially reporting HCW case numbers (via dashboards) + PA with daily press announcements
Racism is a public health issue. Police brutality is a public health issue.
Worth the 15-min listen in full: https://tradeoffs.org/2020/06/02/police-violence/
DG: Dr. Boyd points to a particularly powerful study on the mental health impacts of police violence that was published in 20-18 in the British medical journal The Lancet.
RB: It basically showed that police killing one unarmed black American in your state impacted the mental health of every other African-American in that state, and that the size of that burden of mental health impairments was analogous to the size of the burden of mental health impairments associated with diabetes. Just living in a state where police killed an unarmed black American causes a mental health impairment similar to if you actually had diabetes. I mean, it’s profound. And so the other thing that clinicians have to think about is how are we responding to the population level, mental health impact of police violence? Because now the person who needs an intervention is not just that one individual who is injured. It’s everyone in the state.
hi all, hope you are doing well. A long overdue update:
We've been updating state (and some county) ICU capacity data once weekly (usually collected Weds afternoon PST and pushed on Thurs morning) for the last 2 months.
These updates come from official state dashboards and validated data entries (and prior updates) can be viewed at https://airtable.com/shr3Mplh19M3ZGWeI/tblJCgmBz1SEsKeOn.
As of now, weekly updates come from 25 states or territories: AK, AZ, DC, FL, IL, IN, KS, LA, MA, ME, MI, MN, MO, MS, NC, NE, NJ, OK, OR, PA, PR, SC, TN, VA, WY.
Note that Florida updates are not shown on the Airtable because we update this state at the more granular facility/county/HRR/state levels weekly through a separate more-automated method.
For other states where there are no updates, we fall back to the historical capacity data (from HCRIS, HIFLD, DH). The HRR, county, and facility data is also almost all historical since not many jurisdictions release updated data on that level of granularity.
We can also update or correct data ad hoc at the county or state level whenever we find an issue or someone lets us know via this form: https://airtable.com/shrvqvhLTTMO1Yazg.
Hi @lasingallday , thank you for your interest in helping with this project! Sorry for my very slow response. FYI there's been a major public data release about COVID hospitalizations /health system capacity at the facility-level by the dept of Health and Human Services (HHS).
You can access the dataset and data dictionary at https://healthdata.gov/dataset/covid-19-reported-patient-impact-and-hospital-capacity-facility
A community FAQ with active issues and contributions at: https://github.com/CareSet/COVID_Hospital_PUF
Some overviews and preliminary analyses by several groups have already come out:
This dataset from HHS has everything we've tried (or dreamed) to gather publicly at CovidCareMap but in much greater completeness and granularity of detail (since almost all US hospitals are mandated to report these metrics to HHS every day). I'll be putting a notice containing these links at the top of our repo README shortly to alert visitors to this new dataset.