Provider Demographics and NPI Registry

This dataset provides a comprehensive registry of healthcare providers, including detailed demographic, credential, specialty, and practice location information mapped to the National Provider Identifier (NPI) system. It enables robust provider lookup, credential verification, and network management for healthcare organizations, payers, and regulatory agencies.

  • last updated 2 Nov 2025
  • by GoMask
The brief that made it

Provider directory management and lookup

Sample rows

preview · 8 of 100 rows · all 27 columns
npistringprovider_typestringprovider_middle_namestringprovider_last_namestringprovider_first_namestringprovider_suffixstringprovider_credentialstringspecialty_primarystringspecialty_secondarystringtaxonomy_code_primarystringtaxonomy_code_secondarystringpractice_namestringpractice_street_addressstringpractice_citystringpractice_statestringpractice_postal_codestringpractice_countrystringphone_numberstringfax_numberstringemailstringnppes_last_updatedateenumeration_datedatedeactivation_datedatereactivation_datedategenderstringlicense_numberstringlicense_statestring
3042157890IndividualASmithJohnblankMDInternal MedicineEndocrinology207R00000X207RE0101XDowntown Medical Group123 Oak StreetChicagoIL60601US(312) 555-0189(312) 555-0190john.smith@downtownmed.com2024-04-102012-05-14blankblankMaleIL123456IL
4781203462OrganizationblankCareWell ClinicblankblankblankFamily Practiceblank207Q00000XblankCareWell Clinic450 Maple AveHoustonTX77030US713-555-2210713-555-2211contact@carewellclinic.org2023-11-302015-01-19blankblankblankblankblank
1598734207IndividualRoseJohnsonEmilyblankDOPediatricsNeonatal-Perinatal Medicine208000000X2080N0001XChildren's Corner78 Elm Street Suite 100PhiladelphiaPA19103US215-555-3021215-555-3022emily.johnson@childrenscorner.com2023-08-172016-02-12blankblankFemalePA654321PA
2370185463IndividualblankMartinezCarlosMDMDCardiologyInterventional Cardiology207RC0000X207RI0011XHeart Health Partners159 Pine BlvdSan AntonioTX78205-1234US210-555-4432210-555-4433c.martinez@hearthealthpartners.com2023-12-052011-09-03blankblankMaleTX234567TX
3089124756OrganizationblankNovaCare RehabblankblankblankPhysical Therapyblank225100000XblankNovaCare Rehabilitation Center390 Spruce RoadLos AngelesCA90024US310-555-8921310-555-8922info@novacarela.com2024-01-182017-07-25blankblankblankblankblank
1795632148IndividualSLeeJenniferblankNPFamily PracticeWomen's Health363LF0000X363LW0102XHealthy Family Clinic246 Willow AveSeattleWA98109US(206) 555-7282(206) 555-7283jlee@healthyfamilyclinic.com2023-10-122014-06-22blankblankFemaleWA901234WA
4653201789IndividualGRiveraLuisblankPAOrthopedic Surgeryblank363A00000XblankOrthopedic Associates675 Cedar LaneDenverCO80218US303-555-9128blanklrivera@orthoassoc.com2024-05-022015-11-15blankblankMaleCO567890CO
5972384106OrganizationblankBright Smile DentalblankblankblankGeneral Dentistryblank122300000XblankBright Smile Dental89 Main StreetPhoenixAZ85012US602-555-3410602-555-3411contact@brightsmileaz.com2023-09-262018-03-29blankblankblankblankblank

What the 100 rows show

from the 100-row sample
  • 2genders
  • 3practice countries
  • 4provider credentials
  • 25specialty primaries
  • 30practice states
provider_type100 rows by value
0306060Individual60%40Organization40%
provider_middle_name39 rows with a value · 61 left blank
  1. R5
  2. A4
  3. L4
  4. S3
  5. J3
  6. E3
  7. T3
  8. P2
  9. M2
  10. K2
27 columns by typefrom the column list below
  • string 23
  • date 4

Columns

27 columns in two groups
blueprint · 27 columns
columntypedescriptionexample
Text 23 columns
npistringNational Provider Identifier, a unique 10-digit identifier for healthcare providersunique3042157890
provider_last_namestringProvider's legal last name or organization nameSmith
provider_first_namestringProvider's legal first name (individual providers only)optionalJohn
provider_middle_namestringProvider's middle name (individual providers only)optionalA
provider_suffixstringProvider's name suffix (e.g., Jr., Sr., III)4 suffixes · optionalMD
provider_credentialstringProvider's credentials (e.g., MD, DO, NP, PA)4 credentials · optionalMD
provider_typestringType of provider: Individual or OrganizationIndividual · OrganizationIndividual
specialty_primarystringPrimary specialty of the provider (e.g., Internal Medicine, Family Practice)Internal Medicine
specialty_secondarystringSecondary specialty of the provider, if applicableoptionalEndocrinology
taxonomy_code_primarystringPrimary taxonomy code representing provider's classification and specialization207R00000X
taxonomy_code_secondarystringSecondary taxonomy code, if applicableoptional207RE0101X
practice_namestringName of the practice or organization where provider worksoptionalDowntown Medical Group
practice_street_addressstringStreet address of the provider's practice location123 Oak Street
practice_citystringCity of the provider's practice locationChicago
practice_statestringState of the provider's practice location (2-letter abbreviation)IL
practice_postal_codestringPostal code of the provider's practice location60601
practice_countrystringCountry of the provider's practice locationUS · CA · MXUS
phone_numberstringProvider's primary contact phone number(312) 555-0189
fax_numberstringProvider's fax numberoptional(312) 555-0190
emailstringProvider's contact email addressoptionalinfo@novacarela.com
genderstringProvider's gender (individual providers only)Male · Female · Other · Unknown · optionalMale
license_numberstringProvider's state license numberoptionalIL123456
license_statestringState where provider is licensed (2-letter abbreviation)optionalIL
Dates and times 4 columns
nppes_last_updatedateDate when provider's NPPES record was last updated2024-04-10
enumeration_datedateDate when provider was assigned their NPI2012-05-14
deactivation_datedateDate when provider's NPI was deactivated, if applicableoptional2023-09-15
reactivation_datedateDate when provider's NPI was reactivated, if applicableoptional2024-01-05

Use it for

  • rows10027 columnsrows by provider type60Indivi…40Organi…

    A healthcare dashboard

    A breakdown of provider_middle_name. Excel, Power BI or Tableau.

  • What pattern can you find in 100 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 100 rows.

  • A software demo

    Believable npis with provider_last_name, provider_first_name and provider_middle_name to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 27 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset100 rows27 columns
Yours1,000 rows27 columnspractice_street_address: UK only

blueprint · provider-demographics-and-npi-registry

Behind this dataset

Same schema. As many rows as you need.

These 100 rows came out of a blueprint — 27 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • NPI (National Provider Identifier) unique 10-digit number
  • Provider type: individual (Type 1) or organizational (Type 2)
  • Provider name: first, middle, last, suffix, credentials
  • Specialty: primary care, cardiology, surgery, etc.
  • Taxonomy code for specialty (NUCC Health Care Provider Taxonomy)
  • Practice location address and phone
  • Medical group or hospital affiliation
  • NPPES (National Plan and Provider Enumeration System) data
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
provider-demographics-and-npi-registry

More in Healthcare

Browse all
Also in HealthcarePatient Encounters and VisitsEmergency Department Triage PatternsHealthcare-Insurance Claims IntegrationAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.