Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    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.
    Grace Doherty
    @gracedoherty
    Hey all! In case you hadn't seen this. Government response tracker at national-level country data and US states: https://www.bsg.ox.ac.uk/research/research-projects/coronavirus-government-response-tracker?fbclid=IwAR1Q9uakn0fAb5i_xNfJvz7QrGY4jpR-gI95fz7YpCDV9BISbS8cU6oyGq0#data
    Sidiney Rodrigues
    @sidineyr
    This message was deleted
    Jeff Thomas
    @lasingallday
    Hi! I'm looking to contribute on this Github project and am wondering if there is anything specifically I could look into. I posted a comment on Issue #12 (Validate hospital bed stats...) last weekend but didn't hear anything back. It seems like there are open issues that might be solved (like issue #12), but I'm not sure. Let me know!
    Rob Emanuele
    @lossyrob
    Hey @lasingallday - for #12, we did validate to an extent that we were comfortable that our figures were within the margin of error before pushing the dataset out. That said, we didn't hunt down all of the differences, and I think that would be informative if you're interested in taking a look!
    Another analysis I've been thinking about is how to use the CCM data to help guide distribution efforts for an eventual vaccine - perhaps that's already taken care of by some other effort, but it would be an interesting analysis to take the hospital locations, estimate the population that each facility would serve for vaccinations, and use that to estimate a LOE for vaccination efforts. Just a thought!
    Jeff Thomas
    @lasingallday
    Thanks @lossyrob ! I will look further into the differences between the datasets.
    Jeff Thomas
    @lasingallday
    @lossyrob I wrote a comment on Issue 12 asking about which notebooks to QC in order to determine those diffs. Can you provide some guidance? ... And is anybody here doing that analysis to assist distribution efforts/has anything been published on that already? Not sure how active this github is now.
    daveluo
    @daveluo

    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.

    Jeff Thomas
    @lasingallday
    Thank you for your message @daveluo
    Mark Herringer
    @markherringer
    Hello all, jumping in again to share links to the work we're doing with openstreetmap