Provider identity

CCN → CBSA + Wage Index crosswalk

vlada_curated.dim_ccn_cbsa·live·dim·Medicare Inpatient Prospective Payment System (IPPS)

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Maps each hospital CCN to its geographic CBSA, county FIPS, and IPPS wage index.
2The bridge for wage-index localization of inpatient payment and for placing a hospital in its market.

Grain

Key	Grain
N/A	1One row per hospital CCN — its CBSA, county FIPS, and IPPS wage index.

Columns (4)

Column	Type	Meaning
`ccn`	string
`wage_index`	double
`geographic_cbsa`	string
`county_fips`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`ccn`
Join	`how_to_join(source_fqn="vlada_curated.dim_ccn_cbsa")`
Raw door	Athena (read-only via query_substrate): vlada_curated.dim_ccn_cbsa

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