Home Health Agency Enrollments
U.S. Department of Health & Human Services
@usgov.hhs_gov_home_health_agency_enrollments_76ca1
U.S. Department of Health & Human Services
@usgov.hhs_gov_home_health_agency_enrollments_76ca1
The Home Health Agency (HHA) Enrollments dataset provides enrollment information on all HHAs currently enrolled in Medicare. This data includes information on the HHA's legal business name, doing business as name, organization type and address.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:29:07.813707
Tags: home-health, hospitals-facilities, medicare, medicare-advantage, original-medicare, provider-enrollment
CREATE TABLE home_health_agency_enrollments_2023_04_01 (
"enrollment_id" VARCHAR,
"enrollment_state" VARCHAR,
"provider_type_code" VARCHAR,
"provider_type_text" VARCHAR,
"npi" BIGINT,
"multiple_npi_flag" VARCHAR,
"ccn" VARCHAR,
"associate_id" BIGINT,
"organization_name" VARCHAR,
"doing_business_as_name" VARCHAR,
"incorporation_date" TIMESTAMP,
"incorporation_state" VARCHAR,
"organization_type_structure" VARCHAR,
"organization_other_type_text" VARCHAR,
"proprietary_nonprofit" VARCHAR,
"address_line_1" VARCHAR,
"address_line_2" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" BIGINT,
"practice_location_type" VARCHAR,
"location_other_type_text" VARCHAR
);
CREATE TABLE home_health_agency_enrollments_2023_07_17 (
"enrollment_id" VARCHAR,
"enrollment_state" VARCHAR,
"provider_type_code" VARCHAR,
"provider_type_text" VARCHAR,
"npi" BIGINT,
"multiple_npi_flag" VARCHAR,
"ccn" VARCHAR,
"associate_id" BIGINT,
"organization_name" VARCHAR,
"doing_business_as_name" VARCHAR,
"incorporation_date" TIMESTAMP,
"incorporation_state" VARCHAR,
"organization_type_structure" VARCHAR,
"organization_other_type_text" VARCHAR,
"proprietary_nonprofit" VARCHAR,
"address_line_1" VARCHAR,
"address_line_2" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" BIGINT,
"practice_location_type" VARCHAR,
"location_other_type_text" VARCHAR
);
CREATE TABLE home_health_agency_enrollments_2023_10_02 (
"enrollment_id" VARCHAR,
"enrollment_state" VARCHAR,
"provider_type_code" VARCHAR,
"provider_type_text" VARCHAR,
"npi" BIGINT,
"multiple_npi_flag" VARCHAR,
"ccn" VARCHAR,
"associate_id" BIGINT,
"organization_name" VARCHAR,
"doing_business_as_name" VARCHAR,
"incorporation_date" TIMESTAMP,
"incorporation_state" VARCHAR,
"organization_type_structure" VARCHAR,
"organization_other_type_text" VARCHAR,
"proprietary_nonprofit" VARCHAR,
"address_line_1" VARCHAR,
"address_line_2" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" BIGINT,
"practice_location_type" VARCHAR,
"location_other_type_text" VARCHAR
);
CREATE TABLE home_health_agency_enrollments_2024_01_05 (
"enrollment_id" VARCHAR,
"enrollment_state" VARCHAR,
"provider_type_code" VARCHAR,
"provider_type_text" VARCHAR,
"npi" BIGINT,
"multiple_npi_flag" VARCHAR,
"ccn" VARCHAR,
"associate_id" BIGINT,
"organization_name" VARCHAR,
"doing_business_as_name" VARCHAR,
"incorporation_date" TIMESTAMP,
"incorporation_state" VARCHAR,
"organization_type_structure" VARCHAR,
"organization_other_type_text" VARCHAR,
"proprietary_nonprofit" VARCHAR,
"address_line_1" VARCHAR,
"address_line_2" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" BIGINT,
"practice_location_type" VARCHAR,
"location_other_type_text" VARCHAR
);
CREATE TABLE home_health_agency_enrollments_2024_04_01 (
"enrollment_id" VARCHAR,
"enrollment_state" VARCHAR,
"provider_type_code" VARCHAR,
"provider_type_text" VARCHAR,
"npi" BIGINT,
"multiple_npi_flag" VARCHAR,
"ccn" VARCHAR,
"associate_id" BIGINT,
"organization_name" VARCHAR,
"doing_business_as_name" VARCHAR,
"incorporation_date" TIMESTAMP,
"incorporation_state" VARCHAR,
"organization_type_structure" VARCHAR,
"organization_other_type_text" VARCHAR,
"proprietary_nonprofit" VARCHAR,
"address_line_1" VARCHAR,
"address_line_2" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" BIGINT,
"practice_location_type" VARCHAR,
"location_other_type_text" VARCHAR
);
CREATE TABLE home_health_agency_enrollments_2024_07_01 (
"enrollment_id" VARCHAR,
"enrollment_state" VARCHAR,
"provider_type_code" VARCHAR,
"provider_type_text" VARCHAR,
"npi" BIGINT,
"multiple_npi_flag" VARCHAR,
"ccn" VARCHAR,
"associate_id" BIGINT,
"organization_name" VARCHAR,
"doing_business_as_name" VARCHAR,
"incorporation_date" TIMESTAMP,
"incorporation_state" VARCHAR,
"organization_type_structure" VARCHAR,
"organization_other_type_text" VARCHAR,
"proprietary_nonprofit" VARCHAR,
"address_line_1" VARCHAR,
"address_line_2" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" BIGINT,
"practice_location_type" VARCHAR,
"location_other_type_text" VARCHAR
);
CREATE TABLE home_health_agency_enrollments_2024_10_01 (
"enrollment_id" VARCHAR,
"enrollment_state" VARCHAR,
"provider_type_code" VARCHAR,
"provider_type_text" VARCHAR,
"npi" BIGINT,
"multiple_npi_flag" VARCHAR,
"ccn" VARCHAR,
"associate_id" BIGINT,
"organization_name" VARCHAR,
"doing_business_as_name" VARCHAR,
"incorporation_date" TIMESTAMP,
"incorporation_state" VARCHAR,
"organization_type_structure" VARCHAR,
"organization_other_type_text" VARCHAR,
"proprietary_nonprofit" VARCHAR,
"address_line_1" VARCHAR,
"address_line_2" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" BIGINT,
"practice_location_type" VARCHAR,
"location_other_type_text" VARCHAR
);
CREATE TABLE home_health_agency_enrollments_2025_01_01 (
"enrollment_id" VARCHAR,
"enrollment_state" VARCHAR,
"provider_type_code" VARCHAR,
"provider_type_text" VARCHAR,
"npi" BIGINT,
"multiple_npi_flag" VARCHAR,
"ccn" VARCHAR,
"associate_id" BIGINT,
"organization_name" VARCHAR,
"doing_business_as_name" VARCHAR,
"incorporation_date" TIMESTAMP,
"incorporation_state" VARCHAR,
"organization_type_structure" VARCHAR,
"organization_other_type_text" VARCHAR,
"proprietary_nonprofit" VARCHAR,
"address_line_1" VARCHAR,
"address_line_2" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" BIGINT,
"practice_location_type" VARCHAR,
"location_other_type_text" VARCHAR
);
CREATE TABLE home_health_agency_enrollments_2025_07_01 (
"enrollment_id" VARCHAR,
"enrollment_state" VARCHAR,
"provider_type_code" VARCHAR,
"provider_type_text" VARCHAR,
"npi" BIGINT,
"multiple_npi_flag" VARCHAR,
"ccn" VARCHAR,
"associate_id" BIGINT,
"organization_name" VARCHAR,
"doing_business_as_name" VARCHAR,
"incorporation_date" TIMESTAMP,
"incorporation_state" VARCHAR,
"organization_type_structure" VARCHAR,
"organization_other_type_text" VARCHAR,
"proprietary_nonprofit" VARCHAR,
"address_line_1" VARCHAR,
"address_line_2" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" BIGINT,
"practice_location_type" VARCHAR,
"location_other_type_text" VARCHAR
);
Anyone who has the link will be able to view this.