Provider identity
Medicare provider CCN dimension (all provider types)
vlada_curated.dim_provider_ccn·live·dimRows
101,528
Columns
5
History
N/A
Card
nocolumns only
Typed tools
1
What it is
- 1The resolving dimension for Medicare CCNs of every provider type, built because cms:ccn is a family rather than one identifier.
- 2A CCN identifies a Medicare-certified provider and the type is encoded in the number, so the hospital identity dimension resolved hospitals at 99.9% and SNF, home-health, hospice, FQHC, RHC, ASC and dialysis rosters at roughly 0%.
- 3Built as the union of the ten rosters we already hold, each authoritative for its own type, rather than from CMS positional range conventions.
Grain
| Key | Grain |
|---|---|
| N/A |
|
Columns (5)
| Column | Type | Meaning |
|---|---|---|
ccn | string | |
provider_type | varchar(26) | |
all_provider_types | string | |
provider_type_count | bigint | |
ccn_type_digits | string |
Query it
describe_data_source(source_fqn="vlada_curated.dim_provider_ccn") # the card, live query_substrate(sql="SELECT * FROM vlada_curated.dim_provider_ccn WHERE <filter> LIMIT 100")
| Item | Value |
|---|---|
| Typed tools that read it | resolve_provider |
| Identity key | ccn |
| Join | how_to_join(source_fqn="vlada_curated.dim_provider_ccn") |
| Raw door | Athena (read-only): vlada_curated.dim_provider_ccn |
| Note | Measured 2026-08-15 - every roster that scored roughly 0% against the hospital dimension scores 100.0% here, and the hospital mart holds at 99.9%. Built by ops/scripts/build_dim_provider_ccn.py; every source read is pinned to is_current where the column exists. |
This page as markdown: /docs-md/data/vlada_curated_dim_provider_ccn.md · every page in one file: /llms-full.txt