State programs

MA CHIA Relative Price (commercial price variation)

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

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1MA commercial price variation per payer x hospital (CY2023, 4,357;
21.0=statewide median).
3Tool ingest_chia_relative_price.py.

Grain

Key	Grain
N/A	1One row per (payer, hospital) — MA commercial relative price (1.0=statewide median).

Columns (21)

Column	Type	Meaning
`payer_name`	string
`payer_orgid`	string
`hospital`	string
`hospital_orgid`	string
`hospital_cohort`	string
`hospital_system`	string
`hospital_type`	string
`insurance_category`	string
`product_type`	string
`inpatient_rp`	double
`inpatient_payment_share`	double
`outpatient_rp`	double
`outpatient_payment_share`	double
`blended_rp`	double
`blended_percentile`	double
`blended_quartile`	double
`percent_total_network_payments`	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_relative_price")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.fact_ma_chia_relative_price 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_relative_price")`
Raw door	query_substrate
Company names	`payer_name` `payer_orgid` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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