Hospital price transparency
Hospital department cost ratios from Medicare cost reports (latest fiscal year per department)
Rows
138,458
Columns
6
History
N/A
Card
nocolumns only
Typed tools
0
What it is
- 1The normalized cost lens over the raw HCRIS Worksheet C table (medicare_silver.hospital_cost_report_dept): typed dept_ccr (double), the charge_as_cost 1.0 sentinel excluded, ratios at or above 10 excluded as parse or units defects, one row per hospital and department.
- 2Estimated cost of a service = its gross charge x the dept_ccr of the service's own cost center, found through medicare_silver.hcpcs_cost_center_crosswalk (hcpcs -> cost_center_line).
- 3An inpatient MS-DRG spans departments and uses the __OVERALL__ row, labelled by ccr_basis.
Grain
| Key | Grain |
|---|---|
| N/A |
|
Columns (6)
| Column | Type | Meaning |
|---|---|---|
hospital_ccn | string | |
cost_center_line | 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") # the card, live query_substrate(sql="SELECT * FROM vlada_curated.mart_hospital_dept_ccr 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") |
| Raw door | Athena (read-only via query_substrate): vlada_curated.mart_hospital_dept_ccr |
| Note | Normalized layer of the cost lens; the raw layer is medicare_silver.hospital_cost_report_dept (string columns, sentinel rows included). |
This page as markdown: /docs-md/data/vlada_curated_mart_hospital_dept_ccr.md · every page in one file: /llms-full.txt