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

`medicare_silver.hospital_outpatient_volume` · Medicare Advantage, Part D, Medicaid · status live · 892,793 rows

The 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. The utilization weight for distributing a hospital's measured department cost across the services it actually performs. Joins to the cost reports on ccn (95% of its CCNs have a cost report).

**Grain.** One row per (ccn, Comprehensive-APC, data_year). CMS Medicare Outpatient Hospitals by Provider & Service, 2015-2023. 892,793 rows, 3,773 hospitals.

| 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: `query_substrate` with `SELECT ... FROM medicare_silver.hospital_outpatient_volume WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.hospital_outpatient_volume")` first.