Updated Monthly

US Pharmacist
U.S. Location Dataset // 325,592

325,592 licensed healthcare providers at their practice address. 100% carry a street address, 100% a telephone number, 100% a state license number, 100% a specialty from the nucc taxonomy. 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. These rows are individual providers, so the record is a licensed person at the address where they practise. Buy the organization file instead if you need businesses only. Coverage is 64 states and territories.

325,592Locations
51States
123Data Fields
CSVFormat

All 325,592 records, as published — the complete set rather than a sample. That matters most for coverage and gap questions: put together the same list from partial searches and every location you miss reads as a gap that is not there, so the answer is wrong rather than merely late. Assembling the U.S.-wide coverage by hand also means one query per area against sources that cap what they return per search.

●Coverage Map

US Pharmacist locations in the USA

Showing 4,000 of 319,726 US locations (~1% sample) · Source: LocationLists.com

Location

☆Who uses this data

Life Sciences & Medical Device Sales

Targeting and territory design by specialty taxonomy, practice address and Medicare participation rather than by purchased lead lists.

Health Systems & Recruiting

Provider supply by specialty and geography — who practises where, and where a specialty is thin.

Payers & Network Management

Network adequacy testing and directory reconciliation against the federal registry of record.

Healthcare Analytics & Research

A clean NPI spine to join claims, quality or prescribing data onto, with deactivated NPIs already removed.

✓Data quality & methodology

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 is scraped from a provider's website; every record is the provider's own registered entry.

Monthly

Refresh frequency

Deduplicated

One row per NPI

Validated

Format checks on all fields

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.

⇆Three ways to buy this dataset

The whole file

$69

All 325,592 records as a CSV. One payment, yours to keep, no subscription.

Per record, for AI agents

$0.05 / 100 rows

Query and pay for exactly the rows you need through our MCP server. Buying the file wins above 162,796 records.

API access

MCP

Connect an assistant to search, sample, quote and buy. Pay by card or stablecoin, no account needed.

{}Data Fields

npi100%name100%entity_type100%specialty100%address100%city100%state100%zip100%phone100%county99%cbsa_title94%latitude99%longitude99%organization_name0%credential71%license_number100%license_state100%medicare_specialty0%medicare_secondary_specialties0%group_practice0%group_size0%primary_facility_ccn0%facility_affiliations100%medical_school0%graduation_year0%est_years_in_practice0%oig_excluded100%npis_at_address100%last_name100%first_name100%middle_name51%name_prefix36%name_suffix2%other_organization_name0%additional_names0%primary_taxonomy_code100%provider_grouping100%classification100%specialization10%all_taxonomy_codes100%taxonomy_count100%zip_plus4100%country100%fax30%direct_address1%other_endpoint2%endpoint_count100%mailing_address100%mailing_city100%mailing_state100%mailing_zip100%mailing_country100%sex100%sole_proprietor100%organization_subpart0%parent_organization0%authorized_official0%authorized_official_first0%authorized_official_middle0%authorized_official_last0%authorized_official_title0%authorized_official_credential0%authorized_official_phone0%other_identifiers5%other_identifier_types5%other_identifier_issuers4%taxonomy_groups1%secondary_practice_locations100%enumeration_date100%last_update_date100%certification_date43%ein0%replacement_npi0%individual_pac_id0%medicare_enrollment_id0%group_pac_id0%group_address0%group_city0%group_state0%group_zip0%practices_at0%telehealth0%accepts_assignment0%group_accepts_assignment0%group_address_line2_suppressed0%medicare_enrolled0%facility_affiliation_types0%facility_ccns0%hospital_name0%hospital_address0%hospital_city0%hospital_state0%hospital_zip0%hospital_county0%hospital_type0%hospital_ownership0%hospital_emergency_services0%hospital_rating0%oig_exclusion_type0%oig_exclusion_date0%oig_exclusion_category0%oig_exclusion_specialty0%oig_reinstatement_date0%oig_waiver_date0%oig_address0%oig_city0%oig_state0%secondary_practice_locations_n100%secondary_address3%secondary_city3%secondary_state3%secondary_zip3%secondary_phone3%secondary_phone_ext0%secondary_fax1%additional_names_10%additional_name_count100%endpoint_affiliation0%county_fips99%state_fips99%cbsa_code94%cbsa_type94%zip_land_sqmi99%

The percentage is how much of the file carries that field, measured on the delivered CSV rather than estimated. 76 of 123 fields are populated on under half the rows (organization_name, medicare_specialty, medicare_secondary_specialties, group_practice, group_size, primary_facility_ccn, …). Every row always carries the identifiers and the full address.

≡Sample Data Preview

providers-pharmacist_locations_us.csv — 5 of 325,592 rows, 53 of 123 columns · scroll →UTF-8
npinameentity_typespecialtyaddresscitystatezipphonecountycbsa_titlelatitudelongitudecredentiallicense_numberlicense_statefacility_affiliationsoig_excludednpis_at_addresslast_namefirst_namemiddle_namename_prefixprimary_taxonomy_codeprovider_groupingclassificationspecializationall_taxonomy_codestaxonomy_countzip_plus4countryfaxendpoint_countmailing_addressmailing_citymailing_statemailing_zipmailing_countrysexsole_proprietorother_identifiersother_identifier_typesother_identifier_issuerssecondary_practice_locationsenumeration_datelast_update_datesecondary_practice_locations_nadditional_name_countcounty_fipsstate_fipscbsa_codecbsa_typezip_land_sqmi
1669467510ROBERT D. HARRISIndividualPsychiatric Pharmacist555 E MARKET STELMIRANY149016077271501Chemung CountyElmira, NY42.073505-76.73953R.PH., BCPP040355-1NY0N45HARRISROBERTD.MR.1835P1300XPharmacy Service ProvidersPharmacistPsychiatric1835P1300X114901-3223US0101 GROVE RDITHACANY14850USMN009/16/200507/13/202600360153621300Metropolitan Statistical Area33.2
1578558342AMGAD H. GIRGISIndividualPharmacist3300 SW 15TH STDEERFIELD BEACHFL334429543540530Broward CountyMiami-Fort Lauderdale-West Palm Beach, FL26.309716-80.144905R.PH.PH16660FL0N1GIRGISAMGADH.MR.183500000XPharmacy Service ProvidersPharmacist183500000X133442-8126US954354053803300 SW 15TH STDEERFIELD BEACHFL33442USMN1086594|PH1666001|01NCPDP|FLORIDA BOARD OF PHARMACY009/16/200507/08/200700120111233100Metropolitan Statistical Area6.869
1134114903GLENN RUSTY REXIndividualPharmacistRR 2 BOX 247STROUDOK740799189689531Lincoln CountyOklahoma City, OK35.743102-96.656155D.PH.8894OK0N9REXGLENNRUSTY183500000XPharmacy Service ProvidersPharmacist183500000X174079-9652US918968011304202 W 18TH AVESTILLWATEROK74074USMN009/16/200507/13/202600400814036420Metropolitan Statistical Area186.766
1447245220PETER CRAIG CALDWELLIndividualPharmacist1509 STATE STSANTA BARBARACA931018059654528Santa Barbara CountySanta Maria-Santa Barbara, CA34.419259-119.708049P.D.25356CA0N5CALDWELLPETERCRAIGMR.183500000XPharmacy Service ProvidersPharmacist183500000X193101-2513US805966184401509 STATE STSANTA BARBARACA93101USMN009/16/200507/13/202600060830642200Metropolitan Statistical Area3.202
1962497883JOSEPH RICHARD GERAIndividualPharmacist7435 W TALCOTT AVECHICAGOIL606317737925037Cook CountyChicago-Naperville-Elgin, IL-IN41.994769-87.813104R.PH.IL0N261GERAJOSEPHRICHARD183500000XPharmacy Service ProvidersPharmacist183500000X160631-3707US773792794907435 W TALCOTT AVECHICAGOIL60631USMN009/16/200507/13/202600170311716980Metropolitan Statistical Area3.746
Showing 5 real rows from 325,592 total, all 53 columns that carry data in them. 70 further columns are empty across these five rows — the field list above gives each one's fill rate across the whole file.

US Pharmacist

325,592 locations · CSV · Updated Monthly

Buy Dataset — $69

?Frequently Asked Questions

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?

Individual providers — a licensed person at the address where they practise. CMS publishes NPPES for public use with the practice address attached. If you need businesses only, buy the organization file or one of the practice cuts instead.

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?

CMS republishes the full file monthly and a delta weekly. These datasets are rebuilt from the monthly file, and 351,911 deactivated NPIs are removed each time rather than left in as empty rows.

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.

↔Related Datasets

US Healthcare Providers — Full NPPES File
9,369,042 locations$119
US Healthcare Organizations
1,958,129 locations$99
US Medicare-Enrolled Clinicians
1,622,183 locations$99
$69
325,592 locations
Buy Dataset — $69