# NPPES provider directory

`vlada_curated.dim_provider` · Provider identity · status live · 9,798,758 rows

NPPES-derived provider directory: name, entity type (individual/org), taxonomy/specialty, location, and parent organizational NPI. Resolves any NPI emitted by a rate query. From nppes_version 2026-09, taxonomy is the PRIMARY taxonomy (Primary Taxonomy Switch = Y); taxonomy_code_1 keeps Taxonomy Code_1 as printed (the pre-2026-09 meaning).

**Grain.** One row per NPI.

| column | type | meaning |
|---|---|---|
| npi | string |  |
| entity_type | int |  |
| name | string |  |
| first_name | string |  |
| last_name | string |  |
| credential | string |  |
| city | string |  |
| state | string |  |
| postal_code | string |  |
| taxonomy | string |  |
| npi_prefix | string |  |
| provider_entity_id | string |  |
| nppes_version | string |  |
| loaded_at | timestamp |  |
| taxonomy_code_1 | string |  |
| taxonomy_basis | string |  |
| nppes_source_sha256 | string |  |

Tools that read it: resolve_provider

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