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 the tables
| Column | Tables | Meaning |
|---|---|---|
specialty | providers_hi | CMS'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_type | providers_hi | I = individual, O = organization. Organizations get facility and supplier types, such as Ambulatory Surgical Center or Clinical Laboratory, instead of clinical specialties. |
npi | providers_hi, provider_services_hi | One 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
- In this public file, specialty is a plain-text description such as 'Internal Medicine' or 'Physical Therapist in Private Practice', not a code. Store it as text (VARCHAR).
- A NUCC taxonomy code is a different thing: a unique alphanumeric code, ten characters long, organized in three levels (provider grouping, classification and area of specialization). It comes from the NPI application, not from claims.
- A provider can choose more than one taxonomy code for an NPI but must mark one as primary. CMS publishes a crosswalk that links Medicare provider and supplier types to taxonomy codes.
Common pitfalls
- Medicare specialty and NUCC taxonomy are separate classifications. Don't assume the specialty text here matches the provider's primary taxonomy code; use the CMS crosswalk when you need to connect them.
- One specialty per NPI is a simplification. CMS picks the specialty code with the most services, so a provider who bills under two specialties shows up under only one.
- Not every specialty is a physician specialty. Nurse practitioners, physical therapists, optometrists and organizations such as clinical labs all have their own values, so filter on purpose before comparing.
- Free-text matching is fragile. specialty ILIKE '%surgery%' finds Orthopedic Surgery but also Oral Surgery (Dentist only), and misses Ambulatory Surgical Center. List the exact values you mean.
- Specialty sizes vary a lot. Compare per provider, or within one specialty, rather than raw totals across specialties.
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