NPI Registry Exporter – Complete Provider Lists

Export a complete, current list of US healthcare providers by specialty, state, city or ZIP code from the CMS National Plan and Provider Enumeration System (NPPES) NPI Registry: name, NPI, taxonomy, practice address, phone, fax, license and enumeration date, ready for Excel, CSV or JSON.

Built for medical and dental sales teams, device and supply distributors, healthcare recruiters, credentialing teams and market researchers who need every provider of one kind in one place, not the first 1,200 the registry happens to return.

Why "complete by design"

The public NPI Registry API answers at most 1,200 records per search (200 per page, six pages). Ask it for every dentist in Texas and you get 1,200 of roughly 20,000, with no warning. This Actor:

1. probes every search to detect when it is full,
2. splits a full search automatically by provider type and then by ZIP prefix (78*, 786*, 7864*, 78640),
3. de-duplicates by NPI across every slice,
4. writes a completeness report to the run's key-value store (COMPLETENESS_REPORT) listing every slice, how many pages it took, and whether it was complete, split, truncated or error.

A truncated slice is one unsplittable ZIP with more than 1,200 providers of one type and specialty. It is rare with a specialty filter, more likely when you export every provider type in a dense ZIP; the run's status message and the report both say so and name the ZIP.

What you get

One row per unique provider (NPI). Key columns:

Column	Example
npi, enumerationType, providerType	1234567893, NPI-1, Individual
displayName, firstName, lastName, credential	SAMPLE, JANE Q, DDS
organizationName, authorizedOfficialName, authorizedOfficialTitle, authorizedOfficialPhone	organizations (NPI-2) only
taxonomyCode, taxonomyDescription, taxonomyIsPrimary	the taxonomy that matched your search
primaryTaxonomyCode, primaryTaxonomyDescription, allTaxonomyCodes
licenseNumber, licenseState, taxonomyGroup
practiceAddress1, practiceAddress2, practiceCity, practiceState, practicePostalCode, practiceZip5, practiceCountry	the practice location
practicePhone, practiceFax
mailingAddress1 … mailingPhone	optional, with Include mailing address columns
enumerationDate, lastUpdated, certificationDate, status
registryUrl, searchSlice, source, fetchedAt	audit trail

No emails: NPPES publishes none, and this Actor does not enrich records from other websites. Deactivated NPIs are reduced to the NPI, status and deactivation date, which is all CMS discloses for them, and those rows are saved free of charge.

The practice address shown is the one that matched your city or ZIP filter: if a provider's main location is elsewhere and only a secondary practice location matches, that location is shown and practiceLocationIsSecondary is true.

How to use it

1. Enter a Specialty as written in the NUCC taxonomy (Dentist, Family Medicine, Nurse Practitioner, Physical Therapist, Chiropractor, Pharmacy). The registry matches the text inside any of a provider's taxonomy descriptions, so Dentist also returns Dentist, General Practice and Dentist, Pediatric Dentistry; use a full description to narrow.
2. Pick the State of the practice location.
3. Optionally add Cities or ZIP codes / prefixes (786*). Leave both empty for the whole state.
4. Optionally limit to individuals (NPI-1) or organizations (NPI-2), add mailing columns, and set Maximum providers to export.
5. Run. Download the dataset as CSV, Excel or JSON from the Storage tab, and read COMPLETENESS_REPORT in the key-value store if you want proof the list is exhaustive.

Example inputs

All dentists in Kyle, Texas (about 65 rows, under a minute):

{ "taxonomyDescription": "Dentist", "state": "TX", "cities": ["Kyle"] }

Every orthodontist in Texas:

{ "taxonomyDescription": "Dentist, Orthodontics and Dentofacial Orthopedics", "state": "TX", "maxResults": 100000 }

Every provider of any kind in the 786 ZIP area:

{ "state": "TX", "postalCodes": ["786*"], "maxResults": 100000 }

The registry needs a specialty, a city or a ZIP code together with the state; a state on its own is rejected before any request is made.

Pricing

$2.50 per 1,000 providers on the Free plan (Bronze $2.20, Silver $1.90, Gold $1.60). A tiny start fee of $0.00005 per run (one two-hundredth of a cent). Otherwise you pay only for unique providers saved to your dataset; duplicates, deactivated NPIs and empty searches cost nothing. Use Maximum cost per run to cap any run: at $2.50 per 1,000, a $1.00 cap allows 399 providers and the Actor stops cleanly with a status message when the cap is reached.

Worked examples: 65 Kyle dentists ≈ $0.16. 20,000 Texas dentists ≈ $50 and about 15 minutes.

Limits and good citizenship

• One request per second to the registry, one fixed identity, no proxies. If the registry answers an error twice in a row the run stops politely, keeps everything already exported, and tells you to re-run later.
• One state per run (run once per state for multi-state lists). Up to 100,000 providers per run.
• City, state and ZIP filters apply to practice locations (address_purpose=LOCATION, main or secondary), so a provider whose only Kyle address is a mailing address is not included.
• A state-wide specialty export makes several hundred to about a thousand requests and takes 10 to 20 minutes.

Data source and attribution

Source: CMS National Plan and Provider Enumeration System (NPPES) NPI Registry API v2.1, https://npiregistry.cms.hhs.gov. NPPES data is public under the Freedom of Information Act; CMS states there is no charge to download it and no way for providers to opt out. Taxonomy codes are the NUCC Health Care Provider Taxonomy code set. Every row carries source and fetchedAt so you can cite it.

FAQ

Why do I get fewer rows than another tool? Filters apply to the practice location, duplicates are removed, and deactivated NPIs are reduced to NPI and date. The completeness report shows exactly what was searched.

Why no emails? The registry does not publish them, and this Actor never looks anywhere else.

How fresh is the data? The registry is updated daily; lastUpdated on each row is the provider's own last update.

Can I get mailing addresses? Yes, switch on Include mailing address columns.

What happens when my cost cap is hit? The run stops with a clear status message, the rows already saved stay in your dataset, and the report records stopReason: "budget".

Something looks wrong. Open an issue on the Issues tab with your input JSON; issues are answered within two business days.