Hospital price transparency

Hospital department cost ratio history from Medicare cost reports (FY2011-2024)

vlada_curated.mart_hospital_dept_ccr_history·live·mart

Rows

1,359,025

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The same normalized department ratios as mart_hospital_dept_ccr for every recoverable fiscal year, for trends (a department's cost ratio over time) and for matching a price to the cost report of its own year.

Grain

Key	Grain
N/A	1One row per (hospital_ccn, cost_center_line, fy_year), with cost_center_label; the whole-hospital ratio under '__OVERALL__'. 21,359,025 rows, 6,909 hospitals, 14 fiscal years, 533 cost centers (measured 2026-09-27, qid 582e78d9).

Columns (7)

Column	Type	Meaning
`hospital_ccn`	string
`cost_center_line`	string
`cost_center_label`	string
`ccr_basis`	string
`dept_ccr`	double
`fy_year`	string
`ccr_vintage`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`hospital_ccn`
Join	`how_to_join(source_fqn="vlada_curated.mart_hospital_dept_ccr_history")`
Raw door	Athena (read-only via query_substrate): vlada_curated.mart_hospital_dept_ccr_history
Note	For a single current ratio use mart_hospital_dept_ccr.

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