Health insurers just published close to a trillion hospital prices

Post by abrichr » Wed, Sep 07, 2022, 3:19 AM UTC

refurb wrote: post #239

dj_gitmo wrote: post #60

Earlier quoted context omitted.

The US healthcare system is wildly complicated and inefficient because it is a double-bureaucracy; pubic and private. The government bureaucracy makes a bunch of rules and also provide healthcare through Medicare/Medicaid. The private bureaucracy compete with each other, and hospitals, and pharma companies, ect. Many of the private health providers are for-profit and lobby against rule changes that would reduce compl…

Canada is the only country I know of that has only one system - public. So your claim of public + private being the issue makes no sense when almost every country has that.

Post by bytelines » Wed, Sep 07, 2022, 3:24 AM UTC

DisjointedHunt wrote: post #293

mr_toad wrote: post #259

Earlier quoted context omitted.

I don’t think you can run BigQuery over a Google drive document.

Least you could do is search for something so simple before asserting it on HN https://cloud.google.com/bigquery/docs/external-data-drive

Post by nardi » Wed, Sep 07, 2022, 3:31 AM UTC

orangepurple wrote: post #57

axus wrote: post #7

Earlier quoted context omitted.

The article mentioned CSV files, it seems more like a reflection of what a huge bureaucracy the US healthcare system is. I liked their suggestion that the government should have created the database as part of the law, done the processing on the raw data, and made it more accessible.

import a CSV into Postgres with open(filepath) as fd: first_line = fd.readline() cols = [] for col in first_line.strip().split(','): col2 = f'''"{col.strip('"')}" text''' cols.append(col2) cols2 = ','.join(cols) print(f"create table {table_name} ({cols2});") print(f"\copy {table_name} from '{filepath}' csv header;") this variant will ingest whatever trash is in your CSV fields as-is (cast & cleanup later) run the out…

Post by JamesBarney » Wed, Sep 07, 2022, 3:34 AM UTC

groby_b wrote: post #194

dominotw wrote: post #171

Earlier quoted context omitted.

> Singapore which has exceptionally low healthcare spending yea because they have healthy population, its not because of some smart govt policy( if only it was that easy). singapore obesity rate = 10% usa obesity rate = 42 % usa obesity healthcare spend = 90%

That 90% number is plain not true. Please cite any source for that. The costs for obese folk are on average 90%-100% higher than for non-obese folk, but that's not 90% of total spending. (See e.g. https://pubmed.ncbi.nlm.nih.gov/33470881/ ) Total cost approaches 20% of spending: https://www.hsph.harvard.edu/obesity-prevention-source/obesi...

Post by eru » Wed, Sep 07, 2022, 3:36 AM UTC

xyzzy123 wrote: post #198

duffpkg wrote: post #89

Earlier quoted context omitted.

Healthcare is such a base layer of the economy, I find comparisons to be extraordinaly difficult between countries. On the most basic level our pathway to becoming a healthcare provider of all sorts is dramatically more expensive and limited than other countries, what healthcare providers are paid is dramatically more than other countries, we invest many times per capita what other countries put into basic medical re…

It's a confusopoly! They're most obvious with "basic" products like energy and comms - in theory what is delivered is mostly undifferentiated kWh or GB but through the magic of "confusing plans", marketers have succeeded in making comparisons very difficult for regular people. (You can do it, but you need OCD, a year of billing data and a spreadsheet - which greatly exceeds the cognitive effort most people will inves…