State programs

MA CHIA Revenue-to-Cost Ratio by Payer

vlada_curated.fact_ma_chia_revenue_cost_ratio·live·silver·Massachusetts Commercial Hospital Price & Cost Benchmarks

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1MA per-hospital revenue-to-cost ratio by payer (commercial 1.25x vs Medicaid 0.82x cost).
261 hospitals.
3Tool ingest_chia_profiles.py.

Grain

Key	Grain
N/A	1One row per (hospital, year) — MA CHIA revenue-to-cost ratio.

Columns (13)

Column	Type	Meaning
`hospital`	string
`orgid`	string
`hospital_system`	string
`cohort`	string
`rcr_all_payer`	double
`rcr_medicare`	double
`rcr_medicaid`	double
`rcr_commercial`	double
`rcr_other`	double
`source_url`	string
`content_sha256`	string
`asserted_at`	string
`is_current`	boolean

Query it

describe_data_source(source_fqn="vlada_curated.fact_ma_chia_revenue_cost_ratio")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.fact_ma_chia_revenue_cost_ratio WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	N/A
Join	`how_to_join(source_fqn="vlada_curated.fact_ma_chia_revenue_cost_ratio")`
Raw door	query_substrate

This page as markdown: /docs-md/data/vlada_curated_fact_ma_chia_revenue_cost_ratio.md · every page in one file: /llms-full.txt