NPPES_TABLE
This table takes the monthly updates to the CMS NPPES database, cleans, normalizes and orients their output into a concise feature set built for consumption.
Queries that source from NPPES_TABLE table
What is in the NPPES_TABLE table?
Results are returned as a json, pySpark DataFrame, or pandas DataFrame (default).
| feature | description | example |
|---|---|---|
| npi | National Provider Identifier (NPI) of the individual/organizational provider registered with NPPES. | 1306587324 |
| name | Full name or organizational name of the individual/organizational provider registered with NPPES. | cristina papari |
| entity_type | Indicator of whether the corresponding provider is an individual or organization. | individual |
| gender | Gender of the individual provider. | f |
| credential | Medical credential of the individual provider. | md |
| primary_taxonomy_code | Primary taxonomy code of the individual/organizational provider. | 207Q00000X |
| secondary_taxonomy_code | Secondary taxonomy code of the individual/organizational provider. | 235Z00000X |
| address | Primary address of the individual/organizational provider, as reported to NPPES. | 200 hawkins dr |
| city | City, State of the primary address of the individual/organizational provider, as reported to NPPES. | iowa city |
| state | State of the primary address of the individual/organizational provider, as reported to NPPES. | IA |
| zip | Zip code of the primary address of the individual/organizational provider, as reported to NPPES. | 52242 |
| phone | Primary phone number of the individual/organizational provider, as reported to NPPES. | 3193847507 |
| fax | Primary fax number of the individual/organizational provider, as reported to NPPES. | 3193847822 |
| sole_proprietor | Binary indicator (yes, no) as to whether the provider is registered as a sole proprietor with NPPES. | No |
| org_subpart | Binary indicator (yes, no) as to whether the provider is registered as an organizational subpart with NPPES. | No |
| org_lbn | Legal business name of the parent organization associated with an NPI. | consumerhealth, inc. |
| update_date | The last date in which NPPES table has been updated | 2023-09-01 |
Helper Function within the CareQuery API to help understand the underlying NPPES_TABLE dataset.
# import package
from care_query.care_query import CareQuery
# instantiate and connect
cq = CareQuery(email = "your-email",
token = "your-api-token")
# return details
print(cq.glossary.table_detail('NPPES_TABLE'))Updated 5 months ago