Provider identity
NPPES provider directory
Rows
9,798,758
Columns
17
History
N/A
Card
nocolumns only
Typed tools
1
What it is
- 1NPPES-derived provider directory: name, entity type (individual/org), taxonomy/specialty, location, and parent organizational NPI.
- 2Resolves any NPI emitted by a rate query.
- 3From 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
| Key | Grain |
|---|---|
| N/A |
|
Columns (17)
| 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 |
Query it
describe_data_source(source_fqn="vlada_curated.dim_provider") # the card, live query_substrate(sql="SELECT * FROM vlada_curated.dim_provider WHERE <filter> LIMIT 100")
| Item | Value |
|---|---|
| Typed tools that read it | resolve_provider |
| Identity key | npi |
| Join | how_to_join(source_fqn="vlada_curated.dim_provider") |
| Raw door | Tool: provider_substrate_lookup; Athena: vlada_curated.dim_provider |
| Note | entity_type 1 = individual, 2 = organization. taxonomy semantics are versioned: through 2026-03 Taxonomy Code_1 as printed; from 2026-09 the primary taxonomy (differs from Code_1 for 976,458 of 9,798,758 NPIs in the September 2026 release); taxonomy_basis names the rule; nppes_source_sha256 is the release zip. |
This page as markdown: /docs-md/data/vlada_curated_dim_provider.md · every page in one file: /llms-full.txt