# Medicare PUF (NPI x HCPCS utilization)

`vlada_curated.dim_provider_service` · Provider identity · status live · 14,161,974 rows

Medicare Physician & Other Practitioners PUF — current deduped provider-service cache used by the ghost-rate filter and provider-service lookups. The cache keeps the most recent CMS PUF observation for each (npi, hcpcs_cd, place_of_service) key.

**Grain.** One row per (npi, hcpcs_cd, place_of_service) — most recent CMS PUF observation (current cache; data_year 2021-2023 reflects per-key recency)

| column | type | meaning |
|---|---|---|
| npi | string |  |
| hcpcs_cd | string |  |
| hcpcs_desc | string |  |
| place_of_service | string |  |
| provider_type | string |  |
| provider_state | string |  |
| provider_zip5 | string |  |
| total_services | bigint |  |
| total_beneficiaries | bigint |  |
| avg_submitted_charge | double |  |
| avg_allowed_amt | double |  |
| avg_medicare_payment | double |  |
| avg_standardized_payment | double |  |
| data_year | int |  |
| loaded_at | timestamp |  |

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