Updated Monthly

US Colon & Rectal Surgery
U.S. Location Dataset // 2,392

2,392 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, 76% the medical school and graduation year, 71% 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 51 states and territories.

2,392Locations
48States
123Data Fields
CSVFormat

All 2,392 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 Colon & Rectal Surgery locations in the USA

2,372 US locations · 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 2,392 records as a CSV. One payment, yours to keep, no subscription.

Per record, for AI agents

—

This dataset is small enough that the whole file is the only sensible purchase. Metered queries start at 5,000 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_title94%latitude97%longitude97%organization_name0%credential95%license_number100%license_state100%medicare_specialty76%medicare_secondary_specialties34%group_practice71%group_size71%primary_facility_ccn73%facility_affiliations100%medical_school76%graduation_year76%est_years_in_practice76%oig_excluded100%npis_at_address100%last_name100%first_name100%middle_name72%name_prefix46%name_suffix4%other_organization_name0%additional_names0%primary_taxonomy_code100%provider_grouping100%classification100%specialization0%all_taxonomy_codes100%taxonomy_count100%zip_plus4100%country100%fax65%direct_address18%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_identifiers41%other_identifier_types41%other_identifier_issuers14%taxonomy_groups3%secondary_practice_locations100%enumeration_date100%last_update_date100%certification_date58%ein0%replacement_npi0%individual_pac_id76%medicare_enrollment_id76%group_pac_id71%group_address76%group_city76%group_state76%group_zip76%practices_at76%telehealth25%accepts_assignment76%group_accepts_assignment76%group_address_line2_suppressed5%medicare_enrolled76%facility_affiliation_types73%facility_ccns73%hospital_name72%hospital_address72%hospital_city72%hospital_state72%hospital_zip72%hospital_county72%hospital_type72%hospital_ownership72%hospital_emergency_services72%hospital_rating72%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_address24%secondary_city24%secondary_state24%secondary_zip24%secondary_phone24%secondary_phone_ext0%secondary_fax12%additional_names_10%additional_name_count100%endpoint_affiliation4%county_fips97%state_fips97%cbsa_code94%cbsa_type94%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-colon-rectal-surgery_locations_us.csv — 5 of 2,392 rows, 83 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_groupingclassificationall_taxonomy_codestaxonomy_countzip_plus4countryfaxendpoint_countmailing_addressmailing_citymailing_statemailing_zipmailing_countrysexsole_proprietorother_identifiersother_identifier_typessecondary_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
1407842016PHILIP DEMETRIOS KONDYLISIndividualColon & Rectal Surgery Physician2750 LAUREL ST STE 103COLUMBIASC292048038654594Richland CountyColumbia, SC34.029028-80.999809MD97056SCCOLORECTAL SURGERY (PROCTOLOGY)KEYSTONE REHABILITATION SYSTEMS INC7563900091UNIVERSITY OF MASSACHUSETTS MEDICAL SCHOOL199234N6KONDYLISPHILIPDEMETRIOS208C00000XAllopathic & Osteopathic PhysiciansColon & Rectal Surgery208C00000X129204-2023US803865459402750 LAUREL ST STE 103COLUMBIASC29204USMN009/20/200507/20/202607/20/20263779587332I2017012400270570128267535930 OLD FRENCH RDERIEPA165092YYYHospital390009SAINT VINCENT HOSPITAL232 WEST 25TH STREETERIEPA16544ERIEAcute Care HospitalsVoluntary non-profit - PrivateYes400450794517900Metropolitan Statistical Area6.365
1235125659CARLOS EMILIO ALVAREZIndividualColon & Rectal Surgery Physician3661 S MIAMI AVE, STE 1006MIAMIFL331333058542432Miami-Dade CountyMiami-Fort Lauderdale-West Palm Beach, FL25.731479-80.23384M.D.0040711FL0N2ALVAREZCARLOSEMILIODR.208C00000XAllopathic & Osteopathic PhysiciansColon & Rectal Surgery208C00000X133133-4236US305859953103661 S MIAMI AVE, STE 1006MIAMIFL33133USMY009/21/200507/16/200700120861233100Metropolitan Statistical Area4.162
1972599025JOEL S NIZINIndividualColon & Rectal Surgery Physician1124 E RIDGEWOOD AVE STE 202RIDGEWOODNJ074502016899100Bergen CountyNew York-Newark-Jersey City, NY-NJ40.981591-74.113506M.D.MA44217NJCOLORECTAL SURGERY (PROCTOLOGY)VALLEY PHYSICIAN SERVICES PC5923100121HOWARD UNIVERSITY COLLEGE OF MEDICINE197848N4NIZINJOELS208C00000XAllopathic & Osteopathic PhysiciansColon & Rectal Surgery208C00000X107450-3941US201689910801124 E RIDGEWOOD AVE STE 202RIDGEWOODNJ07450USMNMAI050580305009/23/200510/02/20184082659883I200506220008583577857333108 JACKSON ST, APT 6BHOBOKENNJ070301YYYHospital310012VALLEY HOSPITAL4 VALLEY HEALTH PLAZAPARAMUSNJ07652BERGENAcute Care HospitalsVoluntary non-profit - PrivateYes400340033435620Metropolitan Statistical Area5.751
1538155676LAURA J GLADSTONEIndividualColon & Rectal Surgery Physician1145 BROADWAYSEATTLEWA981222063291760King CountySeattle-Tacoma-Bellevue, WA47.609503-122.295593MDMD00044898WACOLORECTAL SURGERY (PROCTOLOGY)THE POLYCLINIC PLLC3660OTHER199927N66GLADSTONELAURAJ208C00000XAllopathic & Osteopathic PhysiciansColon & Rectal Surgery208C00000X198122-4201US07600 EVERGREEN WAYEVERETTWA98203USFN843187605009/23/200506/15/202606/15/20261850324732I2005091200090321633281961145 BROADWAY, SUITE 2MSEATTLEWA981221YYYY00530335342660Metropolitan Statistical Area2.336
1295721223MICHAEL JOSEPH PAGEIndividualColon & Rectal Surgery Physician1212 PLEASANT ST, STE 211DES MOINESIA503095152831541Polk CountyDes Moines-West Des Moines, IA41.584192-93.621998M.D.35194IA0N19PAGEMICHAELJOSEPHDR.208C00000XAllopathic & Osteopathic PhysiciansColon & Rectal Surgery208C00000X150309-1414US515283047306800 LAKE DRIVE, STE 250WEST DES MOINESIA50266USMN009/26/200508/23/201100191531919780Metropolitan Statistical Area2.714
Showing 5 real rows from 2,392 total, all 83 columns that carry data in them. 40 further columns are empty across these five rows — the field list above gives each one's fill rate across the whole file.

US Colon & Rectal Surgery

2,392 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
2,392 locations
Buy Dataset — $49