State programs

MD HSCRC Monthly Revenue & Volumes

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

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1MD hospital revenue+volume per hospital x month x rate-center (the operationalized GBR).
215,432 rows, 61 hospitals.
3Tool ingest_hscrc_monthly.py.

Grain

Key	Grain
N/A	1One row per (hospital, month) — MD HSCRC monthly revenue/volume.

Columns (14)

Column	Type	Meaning
`hosp_num`	string
`hospital_name`	string
`report_date`	string
`rate_center`	string
`vol_in`	double
`vol_out`	double
`rev_in`	double
`rev_out`	double
`mcaid_rev_in`	double
`mcaid_rev_out`	double
`source_url`	string
`content_sha256`	string
`asserted_at`	string
`is_current`	boolean

Query it

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

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