Updated Monthly

US Orthopaedic Surgery
U.S. Location Dataset // 37,465

37,465 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, 67% the medical school and graduation year, 63% 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.

37,465Locations
49States
123Data Fields
CSVFormat

All 37,465 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 Orthopaedic Surgery locations in the USA

Showing 4,000 of 36,983 US locations (~11% 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 37,465 records as a CSV. One payment, yours to keep, no subscription.

Per record, for AI agents

$0.27 / 100 rows

Query and pay for exactly the rows you need through our MCP server. Buying the file wins above 18,733 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%county98%cbsa_title95%latitude98%longitude98%organization_name0%credential95%license_number100%license_state100%medicare_specialty67%medicare_secondary_specialties11%group_practice63%group_size63%primary_facility_ccn61%facility_affiliations100%medical_school67%graduation_year67%est_years_in_practice67%oig_excluded100%npis_at_address100%last_name100%first_name100%middle_name79%name_prefix47%name_suffix5%other_organization_name0%additional_names0%primary_taxonomy_code100%provider_grouping100%classification100%specialization33%all_taxonomy_codes100%taxonomy_count100%zip_plus4100%country100%fax67%direct_address13%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_identifiers45%other_identifier_types45%other_identifier_issuers21%taxonomy_groups2%secondary_practice_locations100%enumeration_date100%last_update_date100%certification_date54%ein0%replacement_npi0%individual_pac_id67%medicare_enrollment_id67%group_pac_id63%group_address67%group_city67%group_state67%group_zip67%practices_at67%telehealth9%accepts_assignment67%group_accepts_assignment67%group_address_line2_suppressed4%medicare_enrolled67%facility_affiliation_types61%facility_ccns61%hospital_name60%hospital_address60%hospital_city60%hospital_state60%hospital_zip60%hospital_county60%hospital_type60%hospital_ownership60%hospital_emergency_services60%hospital_rating60%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_fax12%additional_names_10%additional_name_count100%endpoint_affiliation4%county_fips98%state_fips98%cbsa_code95%cbsa_type95%zip_land_sqmi98%

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-orthopaedic-surgery_locations_us.csv — 5 of 37,465 rows, 86 of 123 columns · scroll →UTF-8
npinameentity_typespecialtyaddresscitystatezipphonecountycbsa_titlelatitudelongitudecredentiallicense_numberlicense_statemedicare_specialtygroup_practicegroup_sizeprimary_facility_ccnfacility_affiliationsmedical_schoolgraduation_yearest_years_in_practiceoig_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_issuerstaxonomy_groupssecondary_practice_locationsenumeration_datelast_update_datecertification_dateindividual_pac_idmedicare_enrollment_idgroup_pac_idgroup_addressgroup_citygroup_stategroup_zippractices_attelehealthaccepts_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
1154316099ROCCO RICHARD CALDERONEIndividualOrthopaedic Surgery of the Spine Physician2486 PONDEROSA DRIVE NORTH D 114CAMARILLOCA930108054842783Ventura CountyOxnard-Thousand Oaks-Ventura, CA34.227888-119.079553MDG78977CAORTHOPEDIC SURGERY0500823PENNSYLVANIA STATE UNIVERSITY COLLEGE OF MEDICINE198937N1CALDERONEROCCORICHARD207XS0117XAllopathic & Osteopathic PhysiciansOrthopaedic SurgeryOrthopaedic Surgery of the Spine207XS0117X193010-2469US805987851902486 PONDEROSA DRIVE NORTH D 114CAMARILLOCA93010USMN009/16/200505/24/20176901968205I200812200001212486 N PONDEROSA DR, SUITE D114CAMARILLOCA930101YYMYHospital | Home health agency050394 | 057040 | 050082ST JOHNS REGIONAL MEDICAL CENTER1600 N ROSE AVEOXNARDCA93030VENTURAAcute Care HospitalsVoluntary non-profit - PrivateYes400061110637100Metropolitan Statistical Area21.972
1598750366SUSAN LYNN JOLLYIndividualOrthopaedic Surgery Physician1100 N KENTUCKY AVEWEST PLAINSMO657754172569111Howell CountyWest Plains, MO36.701055-91.856335M.D.2015013479MOORTHOPEDIC SURGERYOZARKS MEDICAL CENTER1732600782OHIO STATE UNIVERSITY COLLEGE OF MEDICINE198442N176JOLLYSUSANLYNNDR.207X00000XAllopathic & Osteopathic PhysiciansOrthopaedic Surgery207X00000X|174400000X265775-2029US417256174601210 N. KENTUCKYWEST PLAINSMO65775USFN29220|01292200|201501347901|05|01LICENSE|MISSOURI MEDICAL LICENSE009/16/200507/17/202407/17/20247416855309I2015072000205938704918631100 N KENTUCKY AVEWEST PLAINSMO657751YYYHome health agency | Hospital267186 | 260078OZARKS HEALTHCARE1100 KENTUCKY AVEWEST PLAINSMO65775HOWELLAcute Care HospitalsVoluntary non-profit - PrivateYes200290912948460Micropolitan Statistical Area442.214
1356336283SETH DETCHON DODDSIndividualOrthopaedic Hand Surgery Physician900 NW 17TH ST DEPT OFMIAMIFL331363053266590Miami-Dade CountyMiami-Fort Lauderdale-West Palm Beach, FL25.787247-80.205296M.D.ME122035FLORTHOPEDIC SURGERYUNIVERSITY OF MIAMI23031000222HAHNEMANN UNIVERSITY COLLEGE OF MEDICINE200026N1DODDSSETHDETCHONDR.207XS0106XAllopathic & Osteopathic PhysiciansOrthopaedic SurgeryHand Surgery207X00000X|207XS0106X233136-1119US30532665850900 NW 17TH ST DEPT OFMIAMIFL33136USMY193200000X MULTI-SPECIALTY GROUP009/16/200512/20/202412/20/20242668484692I201509230018693274795109900 NW 17TH ST 1ST FLR, UMHC BASCOM PALMER EYE INSTITUTEMIAMIFL331361YYYYHospital100022 | 100079JACKSON HEALTH SYSTEM1611 NW 12TH AVEMIAMIFL33136MIAMI-DADEAcute Care HospitalsGovernment - Hospital District or AuthorityYes100120861233100Metropolitan Statistical Area1.402
1447245394FREDDY A ACHECARIndividualOrthopaedic Surgery Physician2041 MESA VALLEY WAY, SUITE 100AUSTELLGA301067709441100Cobb CountyAtlanta-Sandy Springs-Roswell, GA33.83288-84.628055M.D.045686GAORTHOPEDIC SURGERYRESURGENS, LLC1821100425TULANE UNIVERSITY SCHOOL OF MEDICINE199333N28ACHECARFREDDYADR.207X00000XAllopathic & Osteopathic PhysiciansOrthopaedic Surgery207X00000X130106-8157US770944646902041 MESA VALLEY WAY, SUITE 100AUSTELLGA30106USMN000819145E|000819145H|000819145J|000819145F05|05|05|05009/16/200506/27/20161153224324I2008111100077111532241425671 PEACHTREE DUNWOODY RD NE, SUITE 900 950ATLANTAGA303421YYYLong-term care hospital | Home health agency | Hospital110042 | 110184 | 117027 | 112007 | 110143WELLSTAR PAULDING MEDICAL CENTER2518 JIMMY LEE SMITH PARKWAYHIRAMGA30141PAULDINGAcute Care HospitalsVoluntary non-profit - OtherNo400130671312060Metropolitan Statistical Area12.607
1306831136BARTON STEVENSON ARTHURIndividualOrthopaedic Surgery Physician738 NEWMAN RDNEW BERNNC285622526342676Craven CountyNew Bern, NC35.080979-77.125033M.D.9800454NCORTHOPEDIC SURGERYSELECT PHYSICAL THERAPY HOLDINGS INC21213400425BRODY SCHOOL OF MEDICINE AT EAST CAROLINA UNIVERSITY199333N64ARTHURBARTONSTEVENSONDR.207X00000XAllopathic & Osteopathic PhysiciansOrthopaedic Surgery207X00000X|207XX0005X228562-5238US25263744790PO BOX 68POLLOCKSVILLENC28573USMN1096E|891096E01|05BCBS009/19/200512/30/202212/30/20221456444397I2007091300090995370764012654 M L KING JR BLVDNEW BERNNC285624YYYHome health agency | Hospital340042 | 347333 | 347171 | 340131 | 347124ONSLOW MEMORIAL HOSPITAL317 WESTERN BOULEVARDJACKSONVILLENC28546ONSLOWAcute Care HospitalsGovernment - Hospital District or AuthorityYes100370493735100Micropolitan Statistical Area151.689
Showing 5 real rows from 37,465 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 Orthopaedic Surgery

37,465 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

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
$49
37,465 locations
Buy Dataset — $49