Learn Health Data

Concepts /

Taxonomy and specialty

How a provider's type and specialty are classified.

A taxonomy code is a unique 10-character code that describes a provider's classification and specialization. An NPI application has to include the taxonomy code that fits the provider. The National Uniform Claim Committee (NUCC) maintains the code list.

Medicare has its own provider and supplier types. CMS publishes a crosswalk that links the types eligible to enroll in Medicare to the matching taxonomy codes.

In this site's data: providers_hi.specialty is the Medicare specialty description from the CMS file. For example, 'Nurse Practitioner'.

In the tables

ColumnTablesMeaning
specialtyproviders_hiCMS's provider type (Rndrng_Prvdr_Type), derived from the specialty code on the provider's Medicare claims. If a provider reported more than one specialty code, CMS keeps the one with the most services.
entity_typeproviders_hiI = individual, O = organization. Organizations get facility and supplier types, such as Ambulatory Surgical Center or Clinical Laboratory, instead of clinical specialties.
npiproviders_hi, provider_services_hiOne row per provider in providers_hi, so each NPI has exactly one specialty here. Join on npi to bring specialty into service-level data.

Formats

Common pitfalls

Beginner queries

DuckDB SQL against this site's Parquet tables. Illustrative — the graded set is on /learn/.

Providers and services by specialty

DuckDB SQL

SELECT specialty, COUNT(*) AS npi_count, SUM(total_services) AS services FROM providers_hi GROUP BY specialty ORDER BY npi_count DESC LIMIT 10;

In this site's Hawaii cut, physical therapists, internal medicine and nurse practitioners have the most NPIs. Illustrative DuckDB SQL; graded exercises live on /learn/.

Organization types are not clinical specialties

DuckDB SQL

SELECT specialty, COUNT(*) AS npi_count FROM providers_hi WHERE entity_type = 'O' GROUP BY specialty ORDER BY npi_count DESC, specialty;

Organizations have facility and supplier types. Filter entity_type = 'I' when you mean individual practitioners.

See what a text match really catches

DuckDB SQL

SELECT specialty, COUNT(*) AS npi_count FROM providers_hi WHERE specialty ILIKE '%surgery%' GROUP BY specialty ORDER BY npi_count DESC, specialty;

Check the list before you trust it, then switch to WHERE specialty IN (...) with the exact values you want.

Where this shows up in the claim cycle: How a Claim Gets Paid, module 1: Who's who: payers and providers

Used in: Filter by specialty · Count providers by specialty · Which specialties bill drug J codes? · Flu shot administration by specialty

Sources