# Medicare Outpatient Hospitals — by Provider and Service (granular APC price)

`medicare_silver.fact_outpatient_by_provider_service` · Medicare Advantage, Part D, Medicaid · status live · 1,008,975 rows

The CMS Medicare Outpatient Hospitals PUF at the provider×APC grain: per hospital (CCN) and comprehensive APC, beneficiary/service counts plus average submitted charge, Medicare allowed, Medicare paid, and outlier amounts. The complete official C-APC series is loaded for 2015-2024 at 1,008,975 rows. This is a claims-derived provider benchmark, not the contractual OPPS fee schedule.

**Grain.** One row per (data_year, hospital CCN, APC) — bene/services + charge + Medicare allowed/paid + outlier.

| column | type | meaning |
|---|---|---|
| data_year | int |  |
| ccn | string |  |
| org_name | string |  |
| state | string |  |
| zip5 | string |  |
| ruca | string |  |
| apc_cd | string |  |
| apc_desc | string |  |
| bene_cnt | double |  |
| capc_services | double |  |
| avg_submitted_charge | double |  |
| avg_medicare_allowed | double |  |
| avg_medicare_payment | double |  |
| outlier_services | double |  |
| avg_medicare_outlier | double |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.fact_outpatient_by_provider_service WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_outpatient_by_provider_service")` first.