Complete US Healthcare Provider Database
The complete US healthcare provider database, built straight from the federal source and ready to load.
NPI Data Services is a US healthcare data provider supplying the full national file of National Provider Identifier (NPI) records to payors, RCM teams, EHR and population-health vendors, ACOs, and B2B healthcare marketers. Each record originates from the CMS NPPES NPI Registry as submitted by the provider, then we link it to Medicare-enrollment and exclusion data and ship it as a clean, relational dataset. Buying the complete file from us means you get:
-
The entire national file:
All 9,246,456 NPI records — both individual practitioners and healthcare organizations — across every state and territory, so you can profile markets, build prospect lists, validate rosters, and refresh your provider master against a single authoritative source. -
A current monthly refresh:
We rebuild the file every month from the latest CMS NPPES release, so new registrations, address changes, and deactivations flow through to you instead of leaving you to reconcile a year-old snapshot of the NPPES database. -
A load-ready CSV model:
The data ships as plain UTF-8 CSV files keyed on NPI, so it imports into SQL, a data warehouse, a CRM, or a spreadsheet without custom parsing or a proprietary reader.
Coverage & record counts
The current file holds 9,246,456 NPI records: 7,311,735 individual practitioners and 1,934,721 healthcare organizations. Coverage spans all 50 states plus Washington, DC and Puerto Rico, and the totals shown here update each month as the file is rebuilt from CMS NPPES.
Don't need the whole country? Take it by state or by clinical specialty, or check live counts first in the free NPI Lookup.
Simplified Data Model and Layout
Rather than hand you one unwieldy flat file, we normalize the data into a small set of related CSV tables. Every table is keyed on the NPI, so you can join only the pieces you need and keep your load times and storage manageable:
- The model is split across these CSV files — entity_type.csv, people.csv, organization.csv, taxonomy.csv, otherid.csv, medicare_enrlmt.csv, location.csv, other_orgname.csv, medicare_sec_specialty.csv, and exclusions.csv.
-
entity_type.csv:
The spine of the model. It carries one row per NPI and an entity type code that routes the record to people.csv (individuals) or organization.csv (organizations). The NPI is the join key used by every other file. -
PECOS and LEIE flags:
entity_type.csv also carries a PECOS flag indicating Medicare enrollment and an LEIE flag indicating an OIG exclusion. Together they let you screen for enrollment status and sanctioned providers without leaving the file. -
Joining to Medicare data:
Because every table shares the NPI, you can attach Medicare-enrollment attributes — PAC ID and enrollment ID from medicare_enrlmt.csv — to any provider record with a single join. -
Taxonomies and other IDs:
taxonomy.csv holds up to 15 NUCC taxonomy records per provider, with classification, primary flag, and license, while otherid.csv holds up to 50 additional identifiers — enough to capture a provider's specialties and legacy IDs in full. -
Locations and alternate names:
location.csv supplies primary and secondary practice addresses, the business mailing address, and telephone and fax numbers; other_orgname.csv lists alternate and former organization names so you can match against the way an entity is actually known. -
Secondary specialties:
medicare_sec_specialty.csv pairs an enrollment ID with each secondary specialty reported by practitioners and DME suppliers. Join it back on enrollment ID or NPI to analyze providers by their full specialty mix rather than a single primary code.
The data model — 10 linked CSV files
| File | Contents | Links by |
|---|---|---|
entity_type.csv | Spine — one row per NPI; entity type (1 = individual, 2 = organization); PECOS & LEIE flags | NPI |
people.csv | Individual provider — name, credential, sole-proprietor flag | NPI |
organization.csv | Organization details — legal name, authorized official | NPI |
taxonomy.csv | Up to 15 taxonomies — NUCC code, classification, primary flag, license | NPI |
otherid.csv | Up to 50 other identifiers | NPI |
medicare_enrlmt.csv | Medicare enrollment — PAC ID, enrollment ID, specialty | NPI |
location.csv | Practice & mailing addresses, phone, fax | NPI |
other_orgname.csv | Additional / alternate organization names | NPI |
medicare_sec_specialty.csv | Enrollment ID ↔ secondary-specialty pairs (practitioners + DME) | Enrollment ID / NPI |
exclusions.csv | OIG LEIE exclusion records (exclusion type & date) for flagged NPIs | NPI |
Every download also includes FILES_LAYOUT.pdf (full record layout) and a README.txt.
Where the data comes from
The foundation is the federal CMS NPPES NPI Registry — the authoritative US record of every provider issued an NPI. On top of that we add CMS PECOS linkage for Medicare enrollment (PAC ID and enrollment ID) and OIG LEIE flags for excluded providers, and we standardize taxonomies to NUCC codes. Each monthly cycle we ingest the latest NPPES release, de-duplicate it, resolve the relationships, and rebuild the 10-file model so what you download reflects the current registry rather than a one-time export.
Better than the raw CMS file
| This database (download) | Free CMS NPPES file | NPI Registry API | |
|---|---|---|---|
| Format | Clean relational 10-file CSV | One flat raw file | JSON / REST |
| PECOS + LEIE linked | Yes | No | Yes (verify) |
| Ready to load | Yes | Needs heavy cleanup | Real-time, no bulk |
| Updated | Monthly | Irregular | Weekly |
| Best for | Analytics, marketing & master-data at scale | DIY teams | Real-time in-app lookups |
The raw NPPES download is free, but it arrives as a single flat extract that you have to clean, de-duplicate, and reshape before taxonomy, location, PECOS, and LEIE data are usable together — and it has no built-in exclusion linkage. We have already done that work and keep it current each month, so the file loads as-is. If you instead need to look up providers one at a time inside an application, the NPI Registry API is the better fit; the bulk download is built for analytics, marketing, and master-data work at scale.
Why NPI Data Services
We have specialized in NPI provider data since 2009 and supply it to payors, ACOs, RCM firms, and EHR and population-health vendors, as well as B2B teams marketing into healthcare. Three things define the product: authoritative federal sourcing from CMS NPPES, a monthly rebuild so the file stays current, and full transparency before purchase — the sample dataset, data model, and record layout are all downloadable on this page so you can confirm the structure and field coverage fit your use case.
Data Delivery
Delivery is electronic and immediate. As soon as your payment clears, the current month's file is packaged as a single ZIP — the 10 CSV tables plus the record-layout PDF and README — and made available to download right away. If you close the page before the download finishes, the file stays in your account: sign in and open the "Downloads" section under the "Account" menu to retrieve it again.
You don't have to buy blind. The sample dataset, the data model, and the record layout for the complete US provider file are all available here — use the buttons above to download or view them before you order.
Subscription Plan
Buy the file once, or subscribe to keep it current. A one-time purchase gives you the latest monthly build to download now; the 1-year subscription delivers a fresh file every month for twelve months. Pick the option that matches how often your provider data needs to refresh below.
Product Name |
Product Price |
Purchase Link |
|---|---|---|
| Complete Healthcare Provider Data - One Time Download | $600 | |
| File size: 1273.35 MB | Records Count: 9308211 | |
| Complete Healthcare Provider Data - 1-year Monthly Download | $3300 | |
| File size: 1273.35 MB | Records Count: 9308211 |
Custom Data Requirements & Support
Need a different structure, a specific field selection, or a format other than CSV — such as Microsoft Excel (.xlsx), Microsoft Access, or another file type? We routinely tailor the delivery to match how your systems consume data. Tell us what you need by email or through our contact page, and we will reply within two business days.
Frequently asked questions
What is included in the Complete US Healthcare Provider Database?
Every active NPI record in CMS NPPES — 9M+ individual and organizational providers — delivered as a clean, relational 10-file CSV model (entity type, people, organization, taxonomy, other IDs, Medicare enrollment, locations, other org names, Medicare secondary specialty, and exclusions), linked by NPI, with a record-layout PDF and README.
How many provider records are in the database?
Over 9 million NPI records covering both individual practitioners and healthcare organizations across all 50 states and US territories.
How often is the data updated?
Monthly, from the latest CMS NPPES release, so you always work from current provider records.
Which fields are included?
NPI, entity type, provider or organization name, up to 15 taxonomies, up to 50 other identifiers, primary and secondary practice addresses, business mailing address, telephone and fax, plus PECOS (Medicare-enrollment) and LEIE (OIG exclusion) flags.
Where does the data come from?
The federal CMS NPPES NPI Registry, enriched with PECOS Medicare-enrollment linkage and OIG LEIE exclusion flags.
How is this different from the free CMS NPPES file?
The raw NPPES download is a single flat file. We deliver a cleaned, de-duplicated, relational 10-file model with taxonomy, location, PECOS and LEIE data already linked by NPI, refreshed monthly and ready to load.
Can I buy just one state or a single specialty?
Yes — see State-wise NPI Data for a single state, and Clinical Specialty-wise NPI Data for a specific specialty or taxonomy.
What does it cost, and is a free sample available?
Buy it one-time, or via a 1-year subscription with monthly downloads. A free sample dataset, data model, and record layout are downloadable on this page.