SPECIALTY_TABLE

This table provides helpful context and categories around taxonomy codes and specialty mappings.

Queries that source from SPECIALTY_TABLE table

What is in the SPECIALTY_TABLE table?

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

featuredescriptionexample
taxonomy_codeTaxonomy code classification system that identifies the specific area of practice of a healthcare provider363LP0200X
subspecialtySub-specialty are specific areas of focus within a healthcare specialtynurse practitioner - pediatrics
specialtySpecialty is a branch of medicine that focuses on a specific area of the body, disease, or populationnurse practitioner
specialty_categoryBroader categories of specialty areas of focusphysician assistants & advanced practice nursing providers

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