Medicare Advantage, Part D, Medicaid

Hospital outpatient facility VOLUME (Medicare, by provider & service)

medicare_silver.hospital_outpatient_volume·live·silver·Medicare Fee-for-Service Utilization & Payments

Rows

892,793

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The FACILITY-side outpatient volume signal: per hospital (CCN), per Comprehensive APC, the service count (srvcs) and beneficiary count, plus average submitted charge / Medicare allowed / Medicare payment.
2The utilization weight for distributing a hospital's measured department cost across the services it actually performs.
3Joins to the cost reports on ccn (95% of its CCNs have a cost report).

Grain

Key	Grain
N/A	1One row per (ccn, Comprehensive-APC, data_year). 2CMS Medicare Outpatient Hospitals by Provider & Service, 2015-2023. 3892,793 rows, 3,773 hospitals.

Columns (11)

Column	Type	Meaning
`ccn`	string
`fy_year`	string
`org_name`	string
`state`	string
`apc_cd`	string
`apc_desc`	string
`bene_cnt`	string
`srvcs`	string
`avg_submitted_charge`	string
`avg_allowed`	string
`avg_payment`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`ccn`
Join	`how_to_join(source_fqn="medicare_silver.hospital_outpatient_volume")`
Raw door	Athena (read-only via query_substrate): medicare_silver.hospital_outpatient_volume
Company names	`org_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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