PROV_OUTREACH_TABLE

This table provides methods of outreach for individual healthcare providers, including emails, and primary locations.

Queries that source from PROV_OUTREACH_TABLE table

• provOutreach

What is in the PROV_OUTREACH_TABLE table?

Results are returned as a json, pySpark DataFrame, or pandas DataFrame (default).

feature	description	example
hcp_npi	National Provider Identifier (NPI) of the individual provider registered with NPPES.	1588763981
hcp_name	Full name of the individual provider record	randal aaberg
taxonomy	Primary taxonomy code of the individual provider	367A00000X
subspecialty	Subspecialty of the individual provider record	urology - general
specialty	Specialty of the individual provider record	urology
specialty_category	Specialty category of the individual provider record	allopathic & osteopathic physicians
email1	Primary email address of the individual provider	[email protected]
email2	Secondary email address of the individual provider	[email protected]
address	Primary address on record for the individual provider record	3288 moanalua rd
city	City of primary address for the individual provider record	honolulu
state	Two digit US State code of primary address for the individual provider record	HI
zip	Zip code of the primary address for the individual provider record	96819
phone	Primary phone number of the individual provider record	808-432-8000
fax	Primary fax number of the individual provider record	808-432-8000
update_date	The last date in which the provider contact details have been updated	2023-09-01

Helper Function within the CareQuery API to help understand the underlying PROV_OUTREACH_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('PROV_OUTREACH_TABLE'))