Updated Monthly

US Pharmacy Practices
U.S. Location Dataset // 109,189

109,189 healthcare organizations — practices, clinics, agencies and facilities, each at its business address. 100% carry a street address, 100% a telephone number, 62% 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. Coverage is 57 states and territories.

109,189Locations
50States
123Data Fields
CSVFormat

All 109,189 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 Pharmacy Practices locations in the USA

Showing 4,000 of 106,915 US locations (~4% 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 109,189 records as a CSV. One payment, yours to keep, no subscription.

Per record, for AI agents

$0.14 / 100 rows

Query and pay for exactly the rows you need through our MCP server. Buying the file wins above 54,595 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%county100%cbsa_title92%latitude100%longitude100%organization_name100%credential0%license_number62%license_state63%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_name0%first_name0%middle_name0%name_prefix0%name_suffix0%other_organization_name73%additional_names81%primary_taxonomy_code100%provider_grouping100%classification100%specialization73%all_taxonomy_codes100%taxonomy_count100%zip_plus4100%country100%fax70%direct_address0%other_endpoint6%endpoint_count100%mailing_address100%mailing_city100%mailing_state100%mailing_zip100%mailing_country100%sex0%sole_proprietor0%organization_subpart100%parent_organization17%authorized_official100%authorized_official_first100%authorized_official_middle26%authorized_official_last100%authorized_official_title100%authorized_official_credential24%authorized_official_phone100%other_identifiers70%other_identifier_types70%other_identifier_issuers62%taxonomy_groups1%secondary_practice_locations100%enumeration_date100%last_update_date100%certification_date52%ein100%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_address0%secondary_city0%secondary_state0%secondary_zip0%secondary_phone0%secondary_phone_ext0%secondary_fax0%additional_names_181%additional_name_count100%endpoint_affiliation5%county_fips100%state_fips100%cbsa_code92%cbsa_type92%zip_land_sqmi100%

The percentage is how much of the file carries that field, measured on the delivered CSV rather than estimated. 65 of 123 fields are populated on under half the rows (credential, 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

practices-pharmacy_locations_us.csv — 5 of 109,189 rows, 60 of 123 columns · scroll →UTF-8
npinameentity_typespecialtyaddresscitystatezipphonecountycbsa_titlelatitudelongitudeorganization_namelicense_numberlicense_statefacility_affiliationsoig_excludednpis_at_addressother_organization_nameadditional_namesprimary_taxonomy_codeprovider_groupingclassificationspecializationall_taxonomy_codestaxonomy_countzip_plus4countryfaxendpoint_countmailing_addressmailing_citymailing_statemailing_zipmailing_countryorganization_subpartauthorized_officialauthorized_official_firstauthorized_official_middleauthorized_official_lastauthorized_official_titleauthorized_official_credentialauthorized_official_phoneother_identifiersother_identifier_typesother_identifier_issuerssecondary_practice_locationsenumeration_datelast_update_datecertification_dateeinsecondary_practice_locations_nadditional_names_1additional_name_countcounty_fipsstate_fipscbsa_codecbsa_typezip_land_sqmi
1134114986NEWTON MEDICAL CENTER PHARMACYOrganizationPharmacy600 MEDICAL CENTER DRNEWTONKS671143162832700Harvey CountyWichita, KS38.067626-97.291649NEWTON MEDICAL CENTER PHARMACY208674KS0N63<UNAVAIL>NMC Health Pharmacy333600000XSuppliersPharmacy333600000X167114-8780US31680462620600 MEDICAL CENTER DRNEWTONKS67114USNVALLERIE L GLEASONVALLERIELGLEASONPRESIDENT & CHIEF EXECUTIVE OFFICER316283270005113601HOSPITAL PHARMACY PROVIDE009/19/200509/09/202109/09/2021<UNAVAIL>0NMC Health Pharmacy1200792048620Metropolitan Statistical Area236.941
1497740245POINTE COUPEE THRIF T WAY PHYOrganizationPharmacy3066 LA HIGHWAY 78LIVONIALA707552256372356Pointe Coupee ParishBaton Rouge, LA30.594669-91.529819POINTE COUPEE THRIF T WAY PHY696LA0N1<UNAVAIL>Livonia Thrif T Way Phy333600000XSuppliersPharmacy333600000X170755-3601US22563728550PO BOX 187LIVONIALA70755USNFRANK NED FOTIFRANKNEDFOTIOWNER PRESIDENTRPH22563728111226777|192225705|01NABP009/19/200508/22/2020<UNAVAIL>0Livonia Thrif T Way Phy1220772212940Metropolitan Statistical Area21.975
1275528929TLC PHARMACY INCOrganizationCommunity/Retail Pharmacy1509 STATE STWATERTOWNNY136013157861746Jefferson CountyWatertown-Fort Drum, NY43.969033-75.910451TLC PHARMACY INC026746NY0N1<UNAVAIL>TLC PHARMACY INC3336C0003XSuppliersPharmacyCommunity/Retail Pharmacy3336C0003X|333600000X213601-3517US31578671370PO BOX 21WATERTOWNNY13601USNLAURA SOBOLESKILAURASOBOLESKIPRES31578617463332993|0254423201|05NCPDP PROVIDER IDENTIFICATION NUMBER009/19/200504/29/2009<UNAVAIL>0TLC PHARMACY INC1360453648060Metropolitan Statistical Area140.748
1356336002ASCENSION WISCONSIN PHARMACY, INCOrganizationCommunity/Retail Pharmacy1901 WESTWOOD CENTER BLVDWAUSAUWI544017153559573Marathon CountyWausau, WI44.966821-89.709421ASCENSION WISCONSIN PHARMACY, INC0N21<UNAVAIL>Ascension Rx 7013336C0003XSuppliersPharmacyCommunity/Retail Pharmacy3336C0003X154401-2892US71535595790PO BOX 860644MINNEAPOLISMN55486USNJONATHAN W SOHNJONATHANWSOHNCFO4144653090009/19/200510/12/202010/12/2020<UNAVAIL>0Ascension Rx 7011550735548140Metropolitan Statistical Area84.174
1801881545MIDDLE MOODYCARE INCOrganizationCommunity/Retail Pharmacy4839 BLOOMFIELD RDMACONGA312064787811213Bibb CountyMacon-Bibb County, GA32.793366-83.684573MIDDLE MOODYCARE INCPHRE006040GA0N3<UNAVAIL>Powell's Bloomfield Pharmacy3336C0003XSuppliersPharmacyCommunity/Retail Pharmacy3336C0003X|333600000X231206-4307US478788907804839 BLOOMFIELD RDMACONGA31206USNROBERT BENJAMIN MOODYROBERTBENJAMINMOODYPHARMACISTR.PH.47878112131111828|000033448C|000033448A01|01|05NCPDP|MEDICAID DME009/19/200505/20/202505/20/2025<UNAVAIL>0Powell's Bloomfield Pharmacy1130211331420Metropolitan Statistical Area26.649
Showing 5 real rows from 109,189 total, all 60 columns that carry data in them. 63 further columns are empty across these five rows — the field list above gives each one's fill rate across the whole file.

US Pharmacy Practices

109,189 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?

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?

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
109,189 locations
Buy Dataset — $69