Updated Monthly

US Social Worker
U.S. Location Dataset // 455,952

455,952 licensed healthcare providers at their practice address. 100% carry a street address, 100% a telephone number, 82% a state license number, 100% a specialty from the nucc taxonomy, 15% the medical school and graduation year, 9% 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 65 states and territories.

455,952Locations

51States

123Data Fields

CSVFormat

All 455,952 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 Social Worker locations in the USA

Showing 4,000 of 450,433 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 455,952 records as a CSV. One payment, yours to keep, no subscription.

Per record, for AI agents

$0.04 / 100 rows

Query and pay for exactly the rows you need through our MCP server. Buying the file wins above 227,976 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%county99%cbsa_title95%latitude99%longitude99%organization_name0%credential73%license_number82%license_state84%medicare_specialty15%medicare_secondary_specialties0%group_practice9%group_size9%primary_facility_ccn0%facility_affiliations100%medical_school15%graduation_year15%est_years_in_practice15%oig_excluded100%npis_at_address100%last_name100%first_name100%middle_name53%name_prefix27%name_suffix1%other_organization_name0%additional_names0%primary_taxonomy_code100%provider_grouping100%classification100%specialization70%all_taxonomy_codes100%taxonomy_count100%zip_plus4100%country100%fax30%direct_address2%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_identifiers10%other_identifier_types10%other_identifier_issuers5%taxonomy_groups3%secondary_practice_locations100%enumeration_date100%last_update_date100%certification_date56%ein0%replacement_npi0%individual_pac_id15%medicare_enrollment_id15%group_pac_id9%group_address15%group_city15%group_state15%group_zip15%practices_at15%telehealth5%accepts_assignment15%group_accepts_assignment15%group_address_line2_suppressed1%medicare_enrolled15%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_address9%secondary_city9%secondary_state9%secondary_zip9%secondary_phone9%secondary_phone_ext1%secondary_fax3%additional_names_10%additional_name_count100%endpoint_affiliation1%county_fips99%state_fips99%cbsa_code95%cbsa_type95%zip_land_sqmi99%

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-social-worker_locations_us.csv — 5 of 455,952 rows, 72 of 123 columns · scroll →UTF-8

npi	name	entity_type	specialty	address	city	state	zip	phone	county	cbsa_title	latitude	longitude	credential	license_number	license_state	medicare_specialty	group_practice	group_size	medical_school	graduation_year	est_years_in_practice	oig_excluded	npis_at_address	last_name	first_name	middle_name	name_prefix	primary_taxonomy_code	provider_grouping	classification	specialization	all_taxonomy_codes	taxonomy_count	zip_plus4	country	fax	mailing_address	mailing_city	mailing_state	mailing_zip	mailing_country	sex	sole_proprietor	other_identifiers	other_identifier_types	other_identifier_issuers	enumeration_date	last_update_date	certification_date	individual_pac_id	medicare_enrollment_id	group_pac_id	group_address	group_city	group_state	group_zip	practices_at	telehealth	accepts_assignment	group_accepts_assignment	medicare_enrolled	county_fips	state_fips	cbsa_code	cbsa_type	zip_land_sqmi
1861487647	MARK JOSEPH MOHAPP	Individual	Clinical Social Worker	1271 WISCONSIN ST, B	LAKE GENEVA	WI	53147	2622150826	Walworth County	Whitewater-Elkhorn, WI	42.558204	-88.451878	LCSW, CSAC	116-123	WI	CLINICAL SOCIAL WORKER	MERCY HEALTH SYSTEM CORPORATION	751	OTHER	1989	37	N	1	MOHAPP	MARK	JOSEPH	MR.	1041C0700X	Behavioral Health & Social Service Providers	Social Worker	Clinical	1041C0700X\|101YA0400X	2	53147-1748	US		1271 WISCONSIN ST, B	LAKE GENEVA	WI	53147	US	M	Y	137909000\|39269100\|39269100\|10670\|60158\|A917403\|39269100	01\|01\|01\|01\|01\|01\|05	MAGELLAN BID HEALTH\|CENPATICO\|HIRSP\|DEAN CARE\|CIGNA\|VALUE OPTIONS	09/16/2005	03/13/2013		6507808995	I20100223000297	7416860440	N2846 STATE RD, SUITE 67	WILLIAMS BAY	WI	53191	1		Y	Y	Y	55127	55	48580	Micropolitan Statistical Area	69.768
1720073513	LINDA C TRUM	Individual	Clinical Social Worker	111 PERKINS ST APT 52	JAMAICA PLAIN	MA	02130	7818716084	Suffolk County	Boston-Cambridge-Newton, MA-NH	42.308175	-71.113471	LICSW PHD	100580	MA	CLINICAL SOCIAL WORKER			OTHER	1993	33	N	1	TRUM	LINDA	C	DR.	1041C0700X	Behavioral Health & Social Service Providers	Social Worker	Clinical	1041C0700X	1	02130-4320	US		111 PERKINS ST APT 52	JAMAICA PLAIN	MA	02130	US	F	Y	424232\|752064\|TR P01626\|007858\|1004655	01\|01\|01\|01\|01	HARVARD PILGRIM\|TUFTS\|BLUE CROSSBLUE SHIELD\|VALUE OPTIONS\|BEACON	09/17/2005	09/05/2025	09/05/2025	0446275721	I20051006000548		111 PERKINS ST, SUITE 52	JAMAICA PLAIN	MA	02130	1	Y	Y	M	Y	25025	25	14460	Metropolitan Statistical Area	3.54
1326033127	RONNE H RABINOWITZ	Individual	Clinical Social Worker	67 RICHFIELD ST	PLAINVIEW	NY	11803	5163498650	Nassau County	New York-Newark-Jersey City, NY-NJ	40.781771	-73.473118	LCSW, CASAC	1041C0700X	NY	CLINICAL SOCIAL WORKER			OTHER	1995	31	N	1	RABINOWITZ	RONNE	H	MRS.	1041C0700X	Behavioral Health & Social Service Providers	Social Worker	Clinical	1041C0700X	1	11803-1438	US		67 RICHFIELD ST	PLAINVIEW	NY	11803	US	F	Y				09/18/2005	07/08/2007		5294883112	I20090504000396		67 RICHFIELD ST	PLAINVIEW	NY	11803	1	Y	Y	M	Y	36059	36	35620	Metropolitan Statistical Area	6.16
1740275544	JILL TURNER SCHECHTER	Individual	Clinical Social Worker	1001 N WASHINGTON BLVD, SUITE 211	SARASOTA	FL	34236	9413301096	Sarasota County	North Port-Bradenton-Sarasota, FL	27.325788	-82.559997	MSW, LCSW	SW6847	FL	CLINICAL SOCIAL WORKER	CENTER OF REVITALIZING PSYCHIATRY, P.C.	37	OTHER	1995	31	N	1	SCHECHTER	JILL	TURNER	MS.	1041C0700X	Behavioral Health & Social Service Providers	Social Worker	Clinical	1041C0700X	1	34236-3430	US	9413559518	1001 N WASHINGTON BLVD, SUITE 211	SARASOTA	FL	34236	US	F	Y	Z017W\|2196137\|766163100\|E7899A\|N4065	01\|01\|05\|01\|01	BLUE CROSS BLUE SHIELD\|CIGNA\|MEDICARE UNSPECIFIED\|EMPIRE BLUE CROSS, NY	09/18/2005	07/22/2013		4385532753	I20040308000678	0648239988	2033 WOOD ST, SUITE 220	SARASOTA	FL	34237	1	Y	Y	Y	Y	12115	12	35840	Metropolitan Statistical Area	3.556
1881689545	D LOWELL YODER	Individual	Social Worker	200 HAWKINS DR	IOWA CITY	IA	52242	3193537934	Johnson County	Iowa City, IA	41.662939	-91.54355	LISW	ISW02230	IA	CLINICAL SOCIAL WORKER	STATE UNIVERSITY OF IOWA	1885	OTHER	1989	37	N	3864	YODER	D LOWELL			104100000X	Behavioral Health & Social Service Providers	Social Worker		104100000X	1	52242-1009	US	3193536083	200 HAWKINS DR	IOWA CITY	IA	52242	US	M	N	19732	01	WELLMARK BCBS	09/19/2005	12/28/2007		4789736679	I20090724000028	7618884230	200 HAWKINS DR	IOWA CITY	IA	52242	1		Y	Y	Y	19103	19	26980	Metropolitan Statistical Area	0.716

Showing 5 real rows from 455,952 total, all 72 columns that carry data in them. 51 further columns are empty across these five rows — the field list above gives each one's fill rate across the whole file.

US Social Worker

455,952 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