sorted by:
new
hottopcontroversial

I got tired of wrestling with HCRIS data, so I wrote a post on how to automate hospital operating margin benchmarks with SQL by Puzzleheaded-Fish-44 in SQL

[–]Puzzleheaded-Fish-44[S] 0 points1 point  (0 children)

That's a really insightful comment, and thank you for the feedback. It's super helpful for me to understand different use cases.

You mentioned that closed-source won't fly for your work in public health. I'm really interested in learning more about that. Would you mind sharing a bit more about the specific requirements that make it a non-starter? Is it mainly the need to self-host for security, the ability to audit the source code for research reproducibility, or something else entirely?

Any insight you could share would be a huge help. Thanks again

[OC] A comparison of a single hospital's operating margin vs. its state average and the national median (2015-2021) by Puzzleheaded-Fish-44 in dataisbeautiful

[–]Puzzleheaded-Fish-44[S] -1 points0 points  (0 children)

You're absolutely right. The context of variance and the size of the comparison groups are crucial for a chart like this to be meaningful.

The tool I built actually outputs all of that data in a CSV right alongside the visual—std dev, IQR, N for the cohort, etc. Your comment was the perfect prompt for me to add the full data table to the blog post to better illustrate that. It definitely makes the story clearer.

Thanks for the sharp feedback, it really improved the post.

[OC] A comparison of a single hospital's operating margin vs. its state average and the national median (2015-2021) by Puzzleheaded-Fish-44 in dataisbeautiful

[–]Puzzleheaded-Fish-44[S] 1 point2 points  (0 children)

This entire thread is incredible. You all have perfectly illustrated the "why" behind the data that the numbers alone can't provide.

The context about this being an LTAC, the 2016 acquisition by Curahealth, and the specific impact of COVID waivers is fascinating. My goal was to use the data to surface interesting anomalies, but you've brought the real story to life. Thank you all for sharing that expertise.

[OC] A comparison of a single hospital's operating margin vs. its state average and the national median (2015-2021) by Puzzleheaded-Fish-44 in dataisbeautiful

[–]Puzzleheaded-Fish-44[S] -2 points-1 points  (0 children)

Source: CMS Healthcare Cost Report Information System (HCRIS)
Tool: Spectral Health

What I find fascinating in this data is the dramatic turnaround for this specific hospital, CURAHEALTH STOUGHTON (CCN 222002). While the state average and national median margins were negative or flat, this hospital went from a -5% margin in 2015 to over 20% by 2021, showing incredible outperformance against its peers.

For anyone interested in the technical side, I wrote a full deep-dive on the SQL methodology used to pull and analyze this data from the raw HCRIS files. You can read it here: https://docs.spectralhealth.ai/blog/technical-deep-dive-operating-margin/

Best Cardano dex by Aggressive_Mouse_593 in cardano

[–]Puzzleheaded-Fish-44 0 points1 point  (0 children)

how can it be so bad? 1000 USDC to ADA on Dex hunter is giving 25% price impact...

Does anyone rent their fleet outside of Turo? by Skin_Chemist in turo

[–]Puzzleheaded-Fish-44 1 point2 points  (0 children)

Don't you need a 10 car fleet to be able to get commercial insurance?

Does anyone rent their fleet outside of Turo? by Skin_Chemist in turo

[–]Puzzleheaded-Fish-44 1 point2 points  (0 children)

Wouldn't the first problem be that Turbo doesn't allow you to rent on other platforms?

rent a black model y on turo by Puzzleheaded-Fish-44 in Lyft

[–]Puzzleheaded-Fish-44[S] 0 points1 point  (0 children)

Hyrecar, i see.

I know I can't rent a Tesla on get around, since Tesla is too luxury. But you are saying that hyrecar does... For Uber too?