Baselight

Home Health Agency Enrollments

U.S. Department of Health & Human Services

@usgov.hhs_gov_home_health_agency_enrollments_76ca1

Loading...
Loading...

About this Dataset

Home Health Agency Enrollments

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

Tables

Home Health Agency Enrollments : 2023-04-01

@usgov.hhs_gov_home_health_agency_enrollments_76ca1.home_health_agency_enrollments_2023_04_01
  • 1.01 MB
  • 11,395 rows
  • 22 columns
Loading...
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
);

Home Health Agency Enrollments : 2023-07-17

@usgov.hhs_gov_home_health_agency_enrollments_76ca1.home_health_agency_enrollments_2023_07_17
  • 1.01 MB
  • 11,502 rows
  • 22 columns
Loading...
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
);

Home Health Agency Enrollments : 2023-10-02

@usgov.hhs_gov_home_health_agency_enrollments_76ca1.home_health_agency_enrollments_2023_10_02
  • 1.01 MB
  • 11,567 rows
  • 22 columns
Loading...
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
);

Home Health Agency Enrollments : 2024-01-05

@usgov.hhs_gov_home_health_agency_enrollments_76ca1.home_health_agency_enrollments_2024_01_05
  • 1.02 MB
  • 11,625 rows
  • 22 columns
Loading...
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
);

Home Health Agency Enrollments : 2024-04-01

@usgov.hhs_gov_home_health_agency_enrollments_76ca1.home_health_agency_enrollments_2024_04_01
  • 1.02 MB
  • 11,700 rows
  • 22 columns
Loading...
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
);

Home Health Agency Enrollments : 2024-07-01

@usgov.hhs_gov_home_health_agency_enrollments_76ca1.home_health_agency_enrollments_2024_07_01
  • 1.02 MB
  • 11,695 rows
  • 22 columns
Loading...
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
);

Home Health Agency Enrollments : 2024-10-01

@usgov.hhs_gov_home_health_agency_enrollments_76ca1.home_health_agency_enrollments_2024_10_01
  • 1.01 MB
  • 11,633 rows
  • 22 columns
Loading...
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
);

Home Health Agency Enrollments : 2025-01-01

@usgov.hhs_gov_home_health_agency_enrollments_76ca1.home_health_agency_enrollments_2025_01_01
  • 1.02 MB
  • 11,708 rows
  • 22 columns
Loading...
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
);

Home Health Agency Enrollments : 2025-07-01

@usgov.hhs_gov_home_health_agency_enrollments_76ca1.home_health_agency_enrollments_2025_07_01
  • 1.01 MB
  • 11,632 rows
  • 22 columns
Loading...
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
);

Share link

Anyone who has the link will be able to view this.