Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Grace Doherty
    @gracedoherty
    Each point of interest lists simply facility name, city/state, and number of beds.
    Steven Pousty
    @thesteve0
    Hey folks - I would love to help. Any chance you want to move the data in PostGIS and maybe make an API on top of it?
    daveluo
    @daveluo
    :wave: hi @thesteve0! sorry for the delayed welcome. we haven't discussed much about postgis or APIs yet so they're unexplored areas. what'd you have in mind?
    Steven Pousty
    @thesteve0
    Hey @daveluo thanks for responding. Well I am devrel lead at Crunchy (postgres people) and I am looking for some volunteer work where I could also use Postgres. I was thinking of making a real relational model for the data and storing it in a db (Postgresql with spatial though PostGIS). I think the drawback would be ease of use for adding or updating data. Benefits more data cleanliness and better scalability
    The API would allow people to read the data and maybe do their own visualizations
    I love that you folks have information on ICU beds and percent occupancy - that's one of the most important metrics most people don't pay attention to
    and it's hard to get
    daveluo
    @daveluo
    got it, thanks for these thoughts! The "drawback would be ease of use for adding or updating data" is probably why we implicitly haven't considered it much yet - lots of structural changes happening still and new data being added. For instance, we're starting to add updated ICU bed/occupancy data for certain states and figuring out some data model changes to tally updated counts on a regular basis. @lossyrob has been thinking through this more than I so he'll probably chime in when he circles around to this
    thanks @gracedoherty for organizing another great mapathon! Lower participation this time around due to end-of-semester/finals for many potential folks but we had a very productive and fun time (with choice tunes: https://bit.ly/covidcaremap_tunes) collecting data about underreported Health Care Worker cases..
    daveluo
    @daveluo

    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

    ^ FYI @Geoyi @andrewwgithub @sunwsusan
    daveluo
    @daveluo
    validated HCW case counts and added screenshot or PDF attachments for each source of data
    Pavel Donin
    @doninpr_gitlab
    Hi everyone! I am experienced on web-map developing (mapbox, openlayers itc) and js (React/Redux, vanilla js). What can I do for your project? I would be glad to help you.
    Steven Pousty
    @thesteve0
    HCWs - what does that stand for?
    daveluo
    @daveluo
    health care workers
    @doninpr_gitlab :wave: hi and welcome! glad to hear about your interest and skills. back in a bit with thoughts on where we could use help, esp w/ React
    Pavel Donin
    @doninpr_gitlab
    @daveluo look forward to hearing from you
    6 replies
    daveluo
    @daveluo
    it's been very quiet on my end, mainly from juggling a few too many things at the moment, but also because there's so much happening that it's overwhelming to voice it all. But silence has a dampening and paralyzing effect so here's to fixing that...
    daveluo
    @daveluo
    Racial injustice and health injustice are being exposed in stark and tragic ways right now. Their consequences and the roots of their continued perpetuation are, and have always been, intertwined
    daveluo
    @daveluo
    daveluo
    @daveluo

    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.

    daveluo
    @daveluo
    i'm clearly not an expert on this - just trying to learn as much as possible with humility and serve as a waypoint for you who may be on a similar journey to find these experts and resources
    Grace Doherty
    @gracedoherty
    Thanks for the links, Dave.
    Grace Doherty
    @gracedoherty
    image.png
    This could be of interest. From AAG Middle Atlantic:
    gmu.zoom.us/webinar/register/WN_na1vwRaZQRuULBlAuPknTQ
    daveluo
    @daveluo
    thanks @gracedoherty !
    Shayan Chowdhury
    @schowdhury8
    Hi all! Stumbled upon your amazing CovidCareMap from a colleague and am curious about how we can use this data on hospitals under load to support them, through policy decisions as well as volunteers and donations. I'm running an open-source volunteer project called Reach4Help to support communities in need through volunteerism and wanted to explore how we can possibly help hospitals in need as well.
    4 replies
    daveluo
    @daveluo

    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.

    daveluo
    @daveluo
    also, to check in on the personal side, please reach out at any time if you want to chat about anything. It's been hard and it will continue to be hard. It's ok to not be ok.