Updated Monthly

US Counselor
U.S. Location Dataset // 641,078

641,078 licensed healthcare providers at their practice address. 100% carry a street address, 100% a telephone number, 56% a state license number, 100% a specialty from the nucc taxonomy, 9% the medical school and graduation year, 5% 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 62 states and territories.

641,078Locations
51States
123Data Fields
CSVFormat

All 641,078 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 Counselor locations in the USA

Showing 4,000 of 633,648 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 641,078 records as a CSV. One payment, yours to keep, no subscription.

Per record, for AI agents

$0.03 / 100 rows

Query and pay for exactly the rows you need through our MCP server. Buying the file wins above 320,539 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_title95%latitude100%longitude100%organization_name0%credential56%license_number56%license_state60%medicare_specialty9%medicare_secondary_specialties0%group_practice5%group_size5%primary_facility_ccn0%facility_affiliations100%medical_school9%graduation_year9%est_years_in_practice9%oig_excluded100%npis_at_address100%last_name100%first_name100%middle_name50%name_prefix22%name_suffix2%other_organization_name0%additional_names0%primary_taxonomy_code100%provider_grouping100%classification100%specialization83%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_identifiers9%other_identifier_types9%other_identifier_issuers4%taxonomy_groups3%secondary_practice_locations100%enumeration_date100%last_update_date100%certification_date54%ein0%replacement_npi0%individual_pac_id9%medicare_enrollment_id9%group_pac_id5%group_address9%group_city9%group_state9%group_zip9%practices_at9%telehealth2%accepts_assignment9%group_accepts_assignment9%group_address_line2_suppressed1%medicare_enrolled9%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_address8%secondary_city8%secondary_state8%secondary_zip8%secondary_phone8%secondary_phone_ext0%secondary_fax2%additional_names_10%additional_name_count100%endpoint_affiliation0%county_fips100%state_fips100%cbsa_code95%cbsa_type95%zip_land_sqmi100%

The percentage is how much of the file carries that field, measured on the delivered CSV rather than estimated. 74 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-counselor_locations_us.csv — 5 of 641,078 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
1063407906MARY S STEVENSIndividualMental Health Counselor1000 COMMERCIAL LN, WTCSBSUFFOLKVA234347579421069Suffolk cityVirginia Beach-Chesapeake-Norfolk, VA-NC36.703003-76.592105LCSW0904002094VA0N1STEVENSMARYS101YM0800XBehavioral Health & Social Service ProvidersCounselorMental Health101YM0800X123434-8148US757925221301000 COMMERCIAL LN, WTCSBSUFFOLKVA23434USFN8904766|O83006|27037105|01|01OPITMA FAMILY CARE|TRIGONBC/BS HEALTHKEEPERS009/16/200507/13/202600518005147260Metropolitan Statistical Area206.781
1174518963ROBIN L REDMANIndividualMental Health Counselor405 FOULK RDWILMINGTONDE198033026553953New Castle CountyPhiladelphia-Camden-Wilmington, PA-NJ-DE-MD39.799872-75.542232LPCMHPC-0000289DE0N41REDMANROBINLMS.101YM0800XBehavioral Health & Social Service ProvidersCounselorMental Health101YM0800X119803-3809US01708 N BROOM ST, APT 2WILMINGTONDE19806USFN009/17/200507/13/202600100031037980Metropolitan Statistical Area12.659
1134114937MARY DEPAOLIS LUTZOIndividualMental Health Counselor7628 MASSACHUSETTS AVE, RICHEY LAKES PLAZANEW PORT RICHEYFL346537278485683Pasco CountyTampa-St. Petersburg-Clearwater, FL28.24408-82.688476PH.D., L.M.H.C.MH7808FL0N1LUTZOMARYDEPAOLISDR.101YM0800XBehavioral Health & Social Service ProvidersCounselorMental Health367500000X|101YM0800X234653-3022US01621 ANCROFT CTTRINITYFL34655USFY311743000|20116035305|01TRICARE009/18/200511/30/201500121011245300Metropolitan Statistical Area10.941
1861487662TONI ELLEN RAITEN-D'ANTONIOIndividualMental Health Counselor1 ARLINGTON CTMILLER PLACENY117646314763073Suffolk CountyNew York-Newark-Jersey City, NY-NJ40.92986-72.973063LCSWRP039058-1NY0N1RAITEN-D'ANTONIOTONIELLENMS.101YM0800XBehavioral Health & Social Service ProvidersCounselorMental Health101YM0800X111764-2202US01 ARLINGTON CTMILLER PLACENY11764USFN009/18/200507/13/202600361033635620Metropolitan Statistical Area9.18
1346235165ALISA RAY PELAEZIndividualCounselorRT 20QUIET DELLWV264083046226404Harrison CountyClarksburg, WV39.196594-80.306444LPC1662WV0N5PELAEZALISARAYMS.101Y00000XBehavioral Health & Social Service ProvidersCounselor101Y00000X126408US30462264040RR 2 BOX 233BMOUNT CLAREWV26408USFN009/19/200507/13/202600540335417220Micropolitan Statistical Area30.27
Showing 5 real rows from 641,078 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 Counselor

641,078 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
641,078 locations
Buy Dataset — $69