US Healthcare Providers — Full NPPES File
U.S. · 9,369,042 locations
There are 9,369,042 Healthcare Providers in the US as of September 2026.
9,369,042 US healthcare provider records. 100% carry a street address, 100% a telephone number, 64% a state license number, 100% a specialty from the NUCC taxonomy, 17% the medical school and graduation year, 15% the group practice they bill under.
More about this list
Built from the CMS National Plan and Provider Enumeration System (NPPES) monthly file, the NPPES deactivation report, the NUCC provider taxonomy and the CMS Care Compare Doctors and Clinicians national file. Every deactivated NPI is removed — 351,911 of them — rather than shipped as an empty row, and the address is the practice location, never the mailing address. Coverage is 95 states and territories.
Need just some of them? Ask in your own words.
●Where the rows are
≡Sample Data Preview
| name | address | city | state | zip | phone | npi | entity type | specialty | county | cbsa title | organization name | credential | license number | license state | medicare specialty | medicare secondary specialties | group practice | group size | primary facility ccn | facility affiliations | medical school | graduation year | est years in practice | oig excluded | npis at address | last name | first name | middle name | name prefix | name suffix | other organization name | additional names | primary taxonomy code | provider grouping | classification | specialization | all taxonomy codes | taxonomy count | zip plus4 | fax | direct address | other endpoint | endpoint count | mailing address | mailing city | mailing state | mailing zip | mailing country | sex | sole proprietor | organization subpart | parent organization | authorized official | authorized official first | authorized official middle | authorized official last | authorized official title | authorized official credential | authorized official phone | other identifiers | other identifier types | other identifier issuers | taxonomy groups | secondary practice locations | enumeration date | last update date | certification date | ein | replacement npi | individual pac id | medicare enrollment id | group pac id | group address | group city | group state | group zip | practices at | telehealth | accepts assignment | group accepts assignment | group address line2 suppressed | medicare enrolled | facility affiliation types | facility ccns | hospital name | hospital address | hospital city | hospital state | hospital zip | hospital county | hospital type | hospital ownership | hospital emergency services | hospital rating | oig exclusion type | oig exclusion date | oig exclusion category | oig exclusion specialty | oig reinstatement date | oig waiver date | oig address | oig city | oig state | secondary practice locations n | secondary address | secondary city | secondary state | secondary zip | secondary phone | secondary phone ext | secondary fax | additional names 1 | additional name count | endpoint affiliation | county fips | state fips | cbsa code | cbsa type | zip land sqmi | latitude | longitude | country |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DANIEL C SCHUBERT | 4001 DALE ST STE 105 | ANCHORAGE | AK | 99508 | (907) 222-9930 | 1780670364 | Individual | Obstetrics & Gynecology Physician | Anchorage Municipality | Anchorage, AK | MD | 7161 | AK | OBSTETRICS/GYNECOLOGY | SELECT PHYSICAL THERAPY HOLDINGS INC | 2121 | 020006 | 1 | LOUISIANA STATE UNIVERSITY SCHOOL OF MEDICINE IN SHREVEPORT | 1998 | 28 | N | 2 | SCHUBERT | DANIEL | C | 207V00000X | Allopathic & Osteopathic Physicians | Obstetrics & Gynecology | 207V00000X | 1 | 99508-5444 | 9072229931 | 0 | 4001 DALE ST STE 105 | ANCHORAGE | AK | 99508 | US | M | N | 0 | 09/20/2005 | 12/02/2016 | 7012933427 | I20161215000614 | 9537076401 | 10928 EAGLE RIVER RD, SUITE 150 | EAGLE RIVER | AK | 99577 | 3 | Y | Y | Y | Hospital | 020006 | MAT-SU REGIONAL MEDICAL CENTER | 2500 SOUTH WOODWORTH LOOP | PALMER | AK | 99645 | MATANUSKA-SUSITNA | Acute Care Hospitals | Voluntary non-profit - Other | Yes | 3 | 0 | 0 | 02020 | 02 | 11260 | Metropolitan Statistical Area | 7.145 | 61.2014 | -149.817502 | US | |||||||||||||||||||||||||||||||||||||||||||||
| NASEER AHMAD HUMAYUN | 1420 MINERAL SPRINGS RD | DALTON | GA | 30720 | (706) 226-2330 | 1932194719 | Individual | Sleep Medicine (Internal Medicine) Physician | Whitfield County | Dalton, GA | MD | 052583 | GA | INTERNAL MEDICINE | CRITICAL CARE (INTENSIVISTS) | PULMONARY AND SLEEP MEDICINE P C | 2 | 110001 | 3 | OTHER | 1993 | 33 | N | 3 | HUMAYUN | NASEER | AHMAD | 207RS0012X | Allopathic & Osteopathic Physicians | Internal Medicine | Sleep Medicine | 207RS0012X|207RP1001X|207RC0200X | 3 | 30720-5354 | 7062262340 | 0 | 1420 MINERAL SPRINGS RD | DALTON | GA | 30720 | US | M | Y | 720395713A | 05 | 0 | 09/16/2005 | 02/13/2024 | 02/13/2024 | 9638082340 | I20040202000413 | 2860305570 | 1420 MINERAL SPRINGS RD | DALTON | GA | 30720 | 1 | Y | Y | Y | Hospital | 110001 | 110050 | 110023 | HAMILTON MEDICAL CENTER | 1200 MEMORIAL DRIVE | DALTON | GA | 30720 | WHITFIELD | Acute Care Hospitals | Voluntary non-profit - Private | No | 3 | 0 | 0 | 13313 | 13 | 19140 | Metropolitan Statistical Area | 48.668 | 34.733645 | -85.000824 | US | ||||||||||||||||||||||||||||||||||||||||
| VICTORIA ELIZABETH STEINER-LARSEN | 900 CATON AVE | BALTIMORE | MD | 21229 | (410) 369-2000 | 1578558359 | Individual | Family Medicine Physician | Baltimore city | Baltimore-Columbia-Towson, MD | MD | D0035527 | MD | FAMILY PRACTICE | SETON MEDICAL GROUP INC | 78 | 210011 | 2 | UNIVERSITY OF MARYLAND SCHOOL OF MEDICINE | 1985 | 41 | N | 146 | STEINER-LARSEN | VICTORIA | ELIZABETH | 207Q00000X | Allopathic & Osteopathic Physicians | Family Medicine | 207Q00000X | 1 | 21229-5201 | 4103692008 | 0 | 900 CATON AVE | BALTIMORE | MD | 21229 | US | F | N | 285931900 | 05 | 0 | 09/16/2005 | 07/27/2023 | 07/27/2023 | 1355471715 | I20100610000718 | 7416037924 | 900 CATON AVE | BALTIMORE | MD | 21229 | 1 | Y | Y | Y | Y | Hospital | Home health agency | 217108 | 210011 | SAINT AGNES HOSPITAL | 900 CATON AVENUE | BALTIMORE | MD | 21229 | BALTIMORE CITY | Acute Care Hospitals | Voluntary non-profit - Church | Yes | 3 | 0 | 0 | 24510 | 24 | 12580 | Metropolitan Statistical Area | 5.936 | 39.284239 | -76.691403 | US | |||||||||||||||||||||||||||||||||||||||||
| ANDREW J SEBASTYAN | 173 DANIEL WEBSTER HWY | NASHUA | NH | 03060 | (603) 891-4804 | 1992790745 | Individual | Family Medicine Physician | Hillsborough County | Manchester-Nashua, NH | MD | 180047 | SC | FAMILY PRACTICE | NORTH COUNTRY HOSPITAL AND HEALTH CENTER INC | 51 | 300003 | 5 | OTHER | 1985 | 41 | N | 30 | SEBASTYAN | ANDREW | J | 207Q00000X | Allopathic & Osteopathic Physicians | Family Medicine | 207Q00000X | 1 | 03060-5256 | 0 | PO BOX 808 | NASHUA | NH | 03061 | US | M | N | 0 | 09/19/2005 | 01/21/2015 | 1850317934 | I20241205000783 | 9739073479 | 488 ELM ST | BARTON | VT | 05822 | 1 | Y | Y | Y | Home health agency | Hospital | 300003 | 471303 | 470003 | 477018 | 471304 | MARY HITCHCOCK MEMORIAL HOSPITAL | 1 MEDICAL CENTER DRIVE | LEBANON | NH | 03756 | GRAFTON | Acute Care Hospitals | Voluntary non-profit - Private | Yes | 3 | 0 | 0 | 33011 | 33 | 31700 | Metropolitan Statistical Area | 6.559 | 42.741087 | -71.458266 | US | ||||||||||||||||||||||||||||||||||||||||||||||
| JOHN GOULD | 7430 COLLEGE ST | IRMO | SC | 29063 | (839) 200-7810 | 1215922091 | Individual | Internal Medicine Physician | Richland County | Columbia, SC | DO | 00632 | SC | INTERNAL MEDICINE | HOSPITALIST | THREE RIVERS MEDICAL ASSOCIATES PA | 11 | 420018 | 9 | PHILADELPHIA COLLEGE OF OSTEOPATHIC MEDICINE | 2000 | 26 | N | 15 | GOULD | JOHN | DR. | III | 207R00000X | Allopathic & Osteopathic Physicians | Internal Medicine | 207R00000X|207RH0002X | 2 | 29063-2903 | 8038917085 | 0 | 7430 COLLEGE ST | IRMO | SC | 29063 | US | M | N | 006326 | 05 | 0 | 09/16/2005 | 01/07/2022 | 01/07/2022 | 0345221297 | I20040526000986 | 1557267663 | 7430 COLLEGE ST | IRMO | SC | 29063 | 1 | Y | Y | Y | Y | Home health agency | Hospice | Hospital | 420026 | 427130 | 420018 | 420106 | 427039 | 421529 | 420086 | 427036 | 420073 | PRISMA HEALTH RICHLAND HOSPITAL | 5 MEDICAL PARK | COLUMBIA | SC | 29203 | RICHLAND | Acute Care Hospitals | Voluntary non-profit - Private | Yes | 3 | 0 | 0 | 45079 | 45 | 17900 | Metropolitan Statistical Area | 40.08 | 34.136998 | -81.202257 | US |
{}What's in each row
| Field | What it is | Rows filled |
|---|---|---|
| npi | National Provider Identifier — the federal key for every US healthcare provider | 100% |
| name | Organization legal business name, or the provider's full name | 100% |
| entity_ | Organization or Individual — whether the row is a business or a licensed person | 100% |
| specialty | Primary specialty, decoded from the NUCC provider taxonomy | 100% |
| address | Practice location street address (never the mailing address) | 100% |
| city | City | 100% |
| state | Two-letter state code | 100% |
| zip | 5-digit ZIP | 100% |
| phone | Practice location telephone, digits only | 100% |
| county | County the location is in | 99% |
| cbsa_ | Cbsa title | 95% |
| latitude | Latitude | 99% |
| longitude | Longitude | 99% |
| organization_ | Legal business name where the row is an organization | 21% |
| credential | Self-reported credential text, e.g. MD, DDS, NP | 51% |
| license_ | State license number for the primary taxonomy | 64% |
| license_ | State that issued that license | 68% |
| medicare_ | CMS's own primary specialty from Care Compare, independent of the self-declared taxonomy | 17% |
| medicare_ | Medicare secondary specialties | 2% |
| group_ | Group practice the clinician bills under | 15% |
| group_ | How many clinicians that group has | 15% |
| primary_ | Primary facility ccn | 10% |
| facility_ | Facility affiliations | 100% |
| medical_ | Medical school, from the CMS Care Compare clinician file | 17% |
| graduation_ | Year of graduation — the best available proxy for career stage | 17% |
| est_ | Est years in practice | 17% |
| oig_ | Oig excluded | 100% |
| npis_ | How many NPIs share this practice address — the entity-vs-location fan-in | 100% |
| last_ | Last name | 79% |
| first_ | First name | 79% |
| middle_ | Middle name | 42% |
| name_ | Name prefix | 22% |
| name_ | Name suffix | 1% |
| other_ | Other organization name | 5% |
| additional_ | Additional names | 7% |
| primary_ | Primary taxonomy code | 100% |
| provider_ | NUCC top-level grouping, e.g. Allopathic & Osteopathic Physicians | 100% |
| classification | NUCC classification — the level products are cut on | 100% |
| specialization | NUCC specialization, where the provider declared one | 35% |
| all_ | Every taxonomy code the provider declared, pipe-separated | 100% |
| taxonomy_ | How many distinct taxonomies that is | 100% |
| zip_ | ZIP+4 where the provider filed one | 100% |
| country | Country | 100% |
| fax | Practice location fax | 38% |
| direct_ | Direct secure-messaging address from the NPPES endpoint file. NOT a marketing email | 3% |
| other_ | Other endpoint | 2% |
| endpoint_ | How many electronic endpoints the provider registered | 100% |
| mailing_ | Business mailing address, kept separate because it differs for a large minority | 100% |
| mailing_ | Mailing city | 100% |
| mailing_ | Mailing state | 100% |
| mailing_ | Mailing ZIP | 100% |
| mailing_ | Mailing country | 100% |
| sex | Sex | 79% |
| sole_ | Y where an individual provider is a sole proprietor | 79% |
| organization_ | Y where this NPI is a subpart of a larger organization | 21% |
| parent_ | Parent organization legal business name where the NPI is a subpart | 2% |
| authorized_ | Named authorized official for an organization NPI | 21% |
| authorized_ | Authorized official first | 21% |
| authorized_ | Authorized official middle | 9% |
| authorized_ | Authorized official last | 21% |
| authorized_ | That official's title | 21% |
| authorized_ | Authorized official credential | 10% |
| authorized_ | That official's telephone | 21% |
| other_ | Other identifiers | 17% |
| other_ | Other identifier types | 17% |
| other_ | Other identifier issuers | 8% |
| taxonomy_ | Taxonomy groups | 13% |
| secondary_ | Count of additional practice locations filed since 2020 | 100% |
| enumeration_ | Date the NPI was issued | 100% |
| last_ | Date the provider last updated their NPPES record | 100% |
| certification_ | Certification date | 54% |
| ein | Employer Identification Number where the provider published one | 21% |
| individual_ | Individual pac id | 17% |
| medicare_ | Medicare enrollment id | 17% |
| group_ | CMS PAC id for that group, stable across refreshes | 15% |
| group_ | Group address | 17% |
| group_ | Group city | 17% |
| group_ | Group state | 17% |
| group_ | Group zip | 17% |
| practices_ | How many distinct groups the clinician bills under | 17% |
| telehealth | Y where CMS records the clinician as offering telehealth | 4% |
| accepts_ | Accepts assignment | 17% |
| group_ | Group accepts assignment | 17% |
| group_ | Group address line2 suppressed | 1% |
| medicare_ | Y where the provider appears in the Medicare Care Compare file | 17% |
| facility_ | Facility affiliation types | 10% |
| facility_ | Facility ccns | 10% |
| hospital_ | Hospital name | 10% |
| hospital_ | Hospital address | 10% |
| hospital_ | Hospital city | 10% |
| hospital_ | Hospital state | 10% |
| hospital_ | Hospital zip | 10% |
| hospital_ | Hospital county | 10% |
| hospital_ | Hospital type | 10% |
| hospital_ | Hospital ownership | 10% |
| hospital_ | Hospital emergency services | 10% |
| hospital_ | Hospital rating | 10% |
| secondary_ | Secondary practice locations n | 100% |
| secondary_ | Secondary address | 8% |
| secondary_ | Secondary city | 8% |
| secondary_ | Secondary state | 8% |
| secondary_ | Secondary zip | 8% |
| secondary_ | Secondary phone | 8% |
| secondary_ | Secondary fax | 3% |
| additional_ | Additional names 1 | 7% |
| additional_ | Additional name count | 100% |
| endpoint_ | Endpoint affiliation | 1% |
| county_ | Five-digit federal code of that county | 99% |
| state_ | State fips | 99% |
| cbsa_ | Cbsa code | 95% |
| cbsa_ | Cbsa type | 95% |
| zip_ | Zip land sqmi | 99% |
Rows filled is measured on every row of the delivered file.
✓Where this data comes from
This dataset is built from the CMS National Plan and Provider Enumeration System (NPPES) monthly file — the federal registry every billing provider must maintain — with the NPPES deactivation report applied so retired NPIs are excluded, specialties resolved against the NUCC provider taxonomy, and Medicare participation joined from the CMS Care Compare Doctors and Clinicians national file. Nothing here comes from a provider's own website; every record is the provider's own registered entry.
September 9, 2026
File built
123 fields
Columns in the file
Fill measured
On every row of the delivered file
Deactivated NPIs are removed using the CMS deactivation report, specialties are resolved against the NUCC taxonomy rather than kept as raw codes, and addresses are validated to US bounds and ZIP format. Records are otherwise published as registered — the federal file is the record of truth, and correcting it would make the dataset disagree with the source buyers reconcile against.
How we build and date every file: methodology.
Using ChatGPT, Claude or an API?
No setup needed. Ask ChatGPT or Claude your question about the US Healthcare Providers — Full NPPES File and give it this page: it can open https://locationlists.com/find?dataset=us-healthcare-providers-full-nppes-file with the filters you need and show you the count and price.
Using ChatGPT or Claude? Tell it to answer from locationlists.com/find — no account, no connector.
How assistants ask
No connector needed. Any AI assistant can answer from this site with a web link, no connector, no account: open https://locationlists.com/find with the question as query parameters.
If a question needs filtering, distance, drive time, combining lists or a price, open a /find link: either put the question itself in q=, or build the structured link. The answer does not need an API, a connector or an account.
Simplest, the question itself: https://locationlists.com/find?q=<the question in plain words>
Or set the parts yourself: https://locationlists.com/find?dataset=<slug>&state=<ST>&city=<city>&county=<county>&zip=<zip>&near=<place or zip>&radius=<miles>&drive=<minutes>&where=<column>:<op>:<value>&total=<rows>
Leave out what the question does not need. Use radius for straight-line miles or drive for minutes of driving (5 to 60), not both; near can name several places separated by | to reach from any of them. To ask about several lists at once, use datasets with two or more names, or category with a kind of business. To compare two lists, add relate=nearest and the other list with b. in front of its parameters. To count by area, use areas=county (or zip, state, metro). To keep only places whose county, ZIP code, metro area or state meets a Census figure, add area_where (for example county:population>1000000); with areas, per=100000 gives counts per 100,000 residents.
Links an assistant can open, each showing how many rows match, a few preview rows and the price for just that part:
- Only California, the state with the most: https://locationlists.com/find?dataset=us-healthcare-providers-full-nppes-file&state=CA
- Within 25 miles of New York, NY, the busiest area: https://locationlists.com/find?dataset=us-healthcare-providers-full-nppes-file&near=New+York+NY&radius=25
- Within a 30-minute drive of New York, NY: https://locationlists.com/find?dataset=us-healthcare-providers-full-nppes-file&near=New+York+NY&drive=30
- Only rows where sole_proprietor is Y: https://locationlists.com/find?dataset=us-healthcare-providers-full-nppes-file&where=sole_proprietor%3Aeq%3AY
- The whole list: add a city, state, ZIP code or distance:
https://locationlists.com/find?dataset=us-healthcare-providers-full-nppes-file - In plain words: "US Healthcare Providers — Full NPPES File in California": https://locationlists.com/find?q=US+Healthcare+Providers+%E2%80%94+Full+NPPES+File+in+California
- In plain words: "US Healthcare Providers — Full NPPES File within 25 miles of New York, NY": https://locationlists.com/find?q=US+Healthcare+Providers+%E2%80%94+Full+NPPES+File+within+25+miles+of+New+York%2C+NY
Optional: connect for repeat use or wallet payments:
Read https://locationlists.com/skill.md and follow the instructions to connect LocationLists. Then show me the US Healthcare Providers — Full NPPES File list.Your assistant will walk you through setup and show you the price before you pay.
For developers
Every step below has a no-connector equivalent: https://locationlists.com/find?dataset=us-healthcare-providers-full-nppes-file with the same filters as query parameters.
- Connect your agent to
https://locationlists.com/mcp(no key, no signup). - Call
count_locationswithdataset: "us-healthcare-providers-full-nppes-file"and any filter — it is free, and returns how many rows match and what they cost. - Fetch the rows with
query_locations: $0.02 per 100 rows from this dataset. Above 4,684,521 rows, buying the whole file is cheaper.
Paid in USDC over x402 — the agent gets an HTTP 402 with the exact price, signs, and retries. Money moves only after rows are delivered, so a failed or empty query costs nothing. Setup for Claude, Cursor and VS Code
?Frequently Asked Questions
How many Healthcare Providers are there in the US?
There are 9,369,042 Healthcare Providers in the US as of September 2026.
Where does this data come from?
The CMS National Plan and Provider Enumeration System — the federal NPI registry — plus the NUCC provider taxonomy and the CMS Care Compare clinician file. All three are published by the government and free to download; what you are buying is the parsing, the taxonomy decode, the deactivation cleanup and the cut. Every vendor selling an NPI-based list is working from the same files.
Are these businesses or individual people?
Organizations only — practices, clinics, agencies and facilities at their business address. Individual providers are sold separately so the two are never mixed.
One address sometimes has several NPIs. Does that inflate the count?
It can, and the file tells you: npis_at_address counts how many NPIs share each practice address. NPPES enumerates billing entities rather than premises, so a practice may carry one NPI per owning PLLC. Filter on that column to get sites.
Is this the same data Definitive Healthcare or IQVIA sell?
The registry underneath is the same public CMS file. What those vendors add on top is their own layer — hospital affiliations they research, executive contacts, claims-derived volumes, purchasing intent. If you need that, buy them. If you need the registry itself as a file you own, this is it, at a fraction of a subscription.
Does this include email addresses?
No, and no honest NPI-based product does — NPPES has no email field. What it does have is the Direct secure-messaging address that some providers register for clinical data exchange, and those ship in their own column, labelled, because they are not marketing addresses. Any vendor selling you a 'physician email list' built on NPI data appended those emails from somewhere else.
How current is it?
File built on September 9, 2026. It is not on an automatic refresh schedule, so check the build date above before you buy.
What format is the download?
A single UTF-8 CSV with a header row, one row per NPI, ready for Excel, a CRM import or a database load. Commercial licence, one-off purchase, no subscription.