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

• nppesDetail

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.

Python

# 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'))