Updated Monthly

US Surgery
U.S. Location Dataset // 49,944

49,944 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, 61% the medical school and graduation year, 56% the group practice they bill under. 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 59 states and territories.

49,944Locations
50States
123Data Fields
CSVFormat

All 49,944 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 Surgery locations in the USA

Showing 4,000 of 49,237 US locations (~8% 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

$49

All 49,944 records as a CSV. One payment, yours to keep, no subscription.

Per record, for AI agents

$0.21 / 100 rows

Query and pay for exactly the rows you need through our MCP server. Buying the file wins above 24,972 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%county97%cbsa_title93%latitude97%longitude97%organization_name0%credential94%license_number100%license_state100%medicare_specialty61%medicare_secondary_specialties12%group_practice56%group_size56%primary_facility_ccn56%facility_affiliations100%medical_school61%graduation_year61%est_years_in_practice61%oig_excluded100%npis_at_address100%last_name100%first_name100%middle_name71%name_prefix45%name_suffix4%other_organization_name0%additional_names0%primary_taxonomy_code100%provider_grouping100%classification100%specialization32%all_taxonomy_codes100%taxonomy_count100%zip_plus4100%country100%fax56%direct_address14%other_endpoint4%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_identifiers40%other_identifier_types40%other_identifier_issuers17%taxonomy_groups2%secondary_practice_locations100%enumeration_date100%last_update_date100%certification_date55%ein0%replacement_npi0%individual_pac_id61%medicare_enrollment_id61%group_pac_id56%group_address61%group_city61%group_state61%group_zip61%practices_at61%telehealth10%accepts_assignment61%group_accepts_assignment61%group_address_line2_suppressed4%medicare_enrolled61%facility_affiliation_types56%facility_ccns56%hospital_name55%hospital_address55%hospital_city55%hospital_state55%hospital_zip55%hospital_county55%hospital_type55%hospital_ownership55%hospital_emergency_services55%hospital_rating55%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_address22%secondary_city22%secondary_state22%secondary_zip22%secondary_phone22%secondary_phone_ext0%secondary_fax10%additional_names_10%additional_name_count100%endpoint_affiliation4%county_fips97%state_fips97%cbsa_code93%cbsa_type93%zip_land_sqmi97%

The percentage is how much of the file carries that field, measured on the delivered CSV rather than estimated. 44 of 123 fields are populated on under half the rows (organization_name, medicare_secondary_specialties, name_prefix, name_suffix, other_organization_name, additional_names, …). Every row always carries the identifiers and the full address.

Sample Data Preview

providers-surgery_locations_us.csv — 5 of 49,944 rows, 86 of 123 columns · scroll →UTF-8
npinameentity_typespecialtyaddresscitystatezipphonecountycbsa_titlelatitudelongitudecredentiallicense_numberlicense_statemedicare_specialtymedicare_secondary_specialtiesgroup_practicegroup_sizeprimary_facility_ccnfacility_affiliationsmedical_schoolgraduation_yearest_years_in_practiceoig_excludednpis_at_addresslast_namefirst_namemiddle_namename_prefixname_suffixprimary_taxonomy_codeprovider_groupingclassificationspecializationall_taxonomy_codestaxonomy_countzip_plus4countryfaxendpoint_countmailing_addressmailing_citymailing_statemailing_zipmailing_countrysexsole_proprietorother_identifiersother_identifier_typesother_identifier_issuerssecondary_practice_locationsenumeration_datelast_update_datecertification_dateindividual_pac_idmedicare_enrollment_idgroup_pac_idgroup_addressgroup_citygroup_stategroup_zippractices_ataccepts_assignmentgroup_accepts_assignmentmedicare_enrolledfacility_affiliation_typesfacility_ccnshospital_namehospital_addresshospital_cityhospital_statehospital_ziphospital_countyhospital_typehospital_ownershiphospital_emergency_serviceshospital_ratingsecondary_practice_locations_nadditional_name_countcounty_fipsstate_fipscbsa_codecbsa_typezip_land_sqmi
1033104997CARL ROSATIIndividualSurgery Physician47 NEW SCOTLAND AVEALBANYNY122085182625623Albany CountyAlbany-Schenectady-Troy, NY42.653031-73.809978M.D.204436-1NYGENERAL SURGERYALBANY MEDICAL COLLEGE10573300131OTHER198640N307ROSATICARLDR.208600000XAllopathic & Osteopathic PhysiciansSurgery208600000X112208-3412US5182625560047 NEW SCOTLAND AVEALBANYNY12208USMN0169174905009/16/200507/13/20262567416027I20050308000512175929311150 NEW SCOTLAND AVEALBANYNY122081YYYHospital330013ALBANY MEDICAL CENTER HOSPITAL43 NEW SCOTLAND AVENUE, MAIL CODE 34ALBANYNY12208ALBANYAcute Care HospitalsVoluntary non-profit - PrivateYes100360013610580Metropolitan Statistical Area4.403
1619962479WALTER PIERRE LEDETIndividualSurgery Physician914 CYPRESS STSULPHURLA706633375276363Calcasieu ParishLake Charles, LA30.278305-93.40559M.D.070975LAGENERAL SURGERYSULPHUR SURGICAL CLINC51900131LOUISIANA STATE UNIVERSITY SCHOOL OF MEDICINE IN NEW ORLEANS196858N4LEDETWALTERPIERREDR.JR.208600000XAllopathic & Osteopathic PhysiciansSurgery208600000X170663-5107US33752821680914 CYPRESS STSULPHURLA70663USMN721115080 70663 A003|1816312002|5136427|114567001|01|01|05TRICARE|CIGNA|AETNA009/16/200507/13/20263577607886I201002240002687911951546914 CYPRESS STSULPHURLA706631YYYHospital190013WEST CALCASIEU CAMERON HOSPITAL701 EAST CYPRESS STREETSULPHURLA70663CALCASIEUAcute Care HospitalsGovernment - Hospital District or AuthorityYes400220192229340Metropolitan Statistical Area97.776
1356336127JOSEPH MOZAIndividualSurgery Physician11865 FIRESTONE BLVDNORWALKCA906507603700209Los Angeles CountyLos Angeles-Long Beach-Anaheim, CA33.90779-118.082487MDA44933CAGENERAL SURGERYEAST LA EMERGENCY PHYSICIANS, INC.60506412OTHER198343N7MOZAJOSEPH208600000XAllopathic & Osteopathic PhysiciansSurgery208600000X|207P00000X290650-2902US0PO BOX 2333NEWPORT BEACHCA92659USMY135633612705009/16/200507/13/202307/13/20238729081542I2006081700028242849023214060 WHITTIER BLVDLOS ANGELESCA900232YYYHospital050641 | 051314EAST LOS ANGELES DOCTORS HOSPITAL4060 WHITTIER BLVDLOS ANGELESCA90023LOS ANGELESAcute Care HospitalsProprietaryYes100060370631080Metropolitan Statistical Area9.902
1629063300AARON L TRACHTEIndividualVascular Surgery Physician3401 W GORE BLVDLAWTONOK735055803574339Comanche CountyLawton, OK34.572847-98.487889MD20331OKCARDIAC SURGERYGENERAL SURGERYCOMANCHE COUNTY HEALTHCARE CORPORATION1253700223UNIVERSITY OF IOWA, RJ & L CARVER COLLEGE OF MEDICINE199630N185TRACHTEAARONL2086S0129XAllopathic & Osteopathic PhysiciansSurgeryVascular Surgery2086S0129X173505US58035744230PO BOX 785LAWTONOK73502USMN734127001AETNA009/19/200502/12/20082466430558I2004071400001907491924333201 W GORE BLVD, SUITE G2LAWTONOK735051YYYHospital370023 | 370056 | 370022JACKSON COUNTY MEMORIAL HOSPITAL AUTHORITY1200 EAST PECAN STALTUSOK73521JACKSONAcute Care HospitalsVoluntary non-profit - OtherYes300400314030020Metropolitan Statistical Area64.599
1811982671EDWARD PHILLIPS POLACKIndividualPlastic and Reconstructive Surgery Physician1 MEDICAL PARK, SUITE 704WHEELINGWV260033042433134Ohio CountyWheeling, WV-OH40.069192-80.650635M.D.11955WV0N5POLACKEDWARDPHILLIPSDR.2086S0122XAllopathic & Osteopathic PhysiciansSurgeryPlastic and Reconstructive Surgery2086S0122X|2086S0105X226003US304243383401 MEDICAL PARK, SUITE 704WHEELINGWV26003USMN0114270000|11955|041521405|01|05HMO009/16/200506/03/202006/03/202000540695448540Metropolitan Statistical Area91.1
Showing 5 real rows from 49,944 total, all 86 columns that carry data in them. 37 further columns are empty across these five rows — the field list above gives each one's fill rate across the whole file.

US Surgery

49,944 locations · CSV · Updated Monthly

Buy Dataset — $49

?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

$49
49,944 locations
Buy Dataset — $49