State programs

MD HSCRC All-Payer Hospital Unit Rates

vlada_curated.fact_md_hscrc_unit_rate·live·silver·Maryland All-Payer Hospital Rates & Volumes

Rows

22,588

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1MD all-payer approved unit rate per HSCRC hospital id and cost center across RY2013-RY2024 and RY2026 (22,588 rows).
2Effective-date changes and source-real split rate lines are preserved.
3Federal CCN/NPI joins require a bridge.
4Tool ingest_hscrc_rates.py.

Grain

Key	Grain
N/A	1One row per (rate_year, hospid, cost_center, effective_date, line_seq)

Columns (12)

Column	Type	Meaning
`hospital_name`	string
`hospid`	string
`cost_center`	string
`unit_rate`	double
`volume`	double
`effective_date`	string
`source_url`	string
`content_sha256`	string
`asserted_at`	string
`is_current`	boolean
`raw_effective_text`	string
`line_seq`	bigint

Query it

describe_data_source(source_fqn="vlada_curated.fact_md_hscrc_unit_rate")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.fact_md_hscrc_unit_rate 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_md_hscrc_unit_rate")`
Raw door	query_substrate

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