About this Dataset

Home Health Agency All Owners

The Home Health Agency (HHA) All Owners dataset provides ownership information on all HHAs currently enrolled in Medicare. This data includes ownership information such as ownership name, ownership type, ownership address and ownership effective date.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:22:49.139241
Tags: home-health, hospitals-facilities, medicare, medicare-advantage, original-medicare, provider-enrollment

Tables

Home Health Agency All Owners : 2024-07-01

@usgov.hhs_gov_home_health_agency_all_owners_09561.home_health_agency_all_owners_2024_07_01

2.83 MB
104,004 rows
34 columns

CREATE TABLE home_health_agency_all_owners_2024_07_01 (
  "enrollment_id" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "associate_id_owner" BIGINT  -- ASSOCIATE ID - OWNER,
  "type_owner" VARCHAR  -- TYPE - OWNER,
  "role_code_owner" BIGINT  -- ROLE CODE - OWNER,
  "role_text_owner" VARCHAR  -- ROLE TEXT - OWNER,
  "association_date_owner" TIMESTAMP  -- ASSOCIATION DATE - OWNER,
  "first_name_owner" VARCHAR  -- FIRST NAME - OWNER,
  "middle_name_owner" VARCHAR  -- MIDDLE NAME - OWNER,
  "last_name_owner" VARCHAR  -- LAST NAME - OWNER,
  "title_owner" VARCHAR  -- TITLE - OWNER,
  "organization_name_owner" VARCHAR  -- ORGANIZATION NAME - OWNER,
  "doing_business_as_name_owner" VARCHAR  -- DOING BUSINESS AS NAME - OWNER,
  "address_line_1_owner" VARCHAR  -- ADDRESS LINE 1 - OWNER,
  "address_line_2_owner" VARCHAR  -- ADDRESS LINE 2 - OWNER,
  "city_owner" VARCHAR  -- CITY - OWNER,
  "state_owner" VARCHAR  -- STATE - OWNER,
  "zip_code_owner" DOUBLE  -- ZIP CODE - OWNER,
  "percentage_ownership" DOUBLE,
  "created_for_acquisition_owner" VARCHAR  -- CREATED FOR ACQUISITION - OWNER,
  "corporation_owner" VARCHAR  -- CORPORATION - OWNER,
  "llc_owner" VARCHAR  -- LLC - OWNER,
  "medical_provider_supplier_owner" VARCHAR  -- MEDICAL PROVIDER SUPPLIER - OWNER,
  "management_services_company_owner" VARCHAR  -- MANAGEMENT SERVICES COMPANY - OWNER,
  "medical_staffing_company_owner" VARCHAR  -- MEDICAL STAFFING COMPANY - OWNER,
  "holding_company_owner" VARCHAR  -- HOLDING COMPANY - OWNER,
  "investment_firm_owner" VARCHAR  -- INVESTMENT FIRM - OWNER,
  "financial_institution_owner" VARCHAR  -- FINANCIAL INSTITUTION - OWNER,
  "consulting_firm_owner" VARCHAR  -- CONSULTING FIRM - OWNER,
  "for_profit_owner" VARCHAR  -- FOR PROFIT - OWNER,
  "non_profit_owner" VARCHAR  -- NON PROFIT - OWNER,
  "other_type_owner" VARCHAR  -- OTHER TYPE - OWNER,
  "other_type_text_owner" VARCHAR  -- OTHER TYPE TEXT - OWNER
);

Home Health Agency All Owners : 2024-10-01

@usgov.hhs_gov_home_health_agency_all_owners_09561.home_health_agency_all_owners_2024_10_01

2.81 MB
103,003 rows
34 columns

CREATE TABLE home_health_agency_all_owners_2024_10_01 (
  "enrollment_id" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "associate_id_owner" BIGINT  -- ASSOCIATE ID - OWNER,
  "type_owner" VARCHAR  -- TYPE - OWNER,
  "role_code_owner" BIGINT  -- ROLE CODE - OWNER,
  "role_text_owner" VARCHAR  -- ROLE TEXT - OWNER,
  "association_date_owner" TIMESTAMP  -- ASSOCIATION DATE - OWNER,
  "first_name_owner" VARCHAR  -- FIRST NAME - OWNER,
  "middle_name_owner" VARCHAR  -- MIDDLE NAME - OWNER,
  "last_name_owner" VARCHAR  -- LAST NAME - OWNER,
  "title_owner" VARCHAR  -- TITLE - OWNER,
  "organization_name_owner" VARCHAR  -- ORGANIZATION NAME - OWNER,
  "doing_business_as_name_owner" VARCHAR  -- DOING BUSINESS AS NAME - OWNER,
  "address_line_1_owner" VARCHAR  -- ADDRESS LINE 1 - OWNER,
  "address_line_2_owner" VARCHAR  -- ADDRESS LINE 2 - OWNER,
  "city_owner" VARCHAR  -- CITY - OWNER,
  "state_owner" VARCHAR  -- STATE - OWNER,
  "zip_code_owner" DOUBLE  -- ZIP CODE - OWNER,
  "percentage_ownership" DOUBLE,
  "created_for_acquisition_owner" VARCHAR  -- CREATED FOR ACQUISITION - OWNER,
  "corporation_owner" VARCHAR  -- CORPORATION - OWNER,
  "llc_owner" VARCHAR  -- LLC - OWNER,
  "medical_provider_supplier_owner" VARCHAR  -- MEDICAL PROVIDER SUPPLIER - OWNER,
  "management_services_company_owner" VARCHAR  -- MANAGEMENT SERVICES COMPANY - OWNER,
  "medical_staffing_company_owner" VARCHAR  -- MEDICAL STAFFING COMPANY - OWNER,
  "holding_company_owner" VARCHAR  -- HOLDING COMPANY - OWNER,
  "investment_firm_owner" VARCHAR  -- INVESTMENT FIRM - OWNER,
  "financial_institution_owner" VARCHAR  -- FINANCIAL INSTITUTION - OWNER,
  "consulting_firm_owner" VARCHAR  -- CONSULTING FIRM - OWNER,
  "for_profit_owner" VARCHAR  -- FOR PROFIT - OWNER,
  "non_profit_owner" VARCHAR  -- NON PROFIT - OWNER,
  "other_type_owner" VARCHAR  -- OTHER TYPE - OWNER,
  "other_type_text_owner" VARCHAR  -- OTHER TYPE TEXT - OWNER
);

Home Health Agency All Owners : 2025-01-01

@usgov.hhs_gov_home_health_agency_all_owners_09561.home_health_agency_all_owners_2025_01_01

2.81 MB
102,925 rows
34 columns

CREATE TABLE home_health_agency_all_owners_2025_01_01 (
  "enrollment_id" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "associate_id_owner" BIGINT  -- ASSOCIATE ID - OWNER,
  "type_owner" VARCHAR  -- TYPE - OWNER,
  "role_code_owner" BIGINT  -- ROLE CODE - OWNER,
  "role_text_owner" VARCHAR  -- ROLE TEXT - OWNER,
  "association_date_owner" TIMESTAMP  -- ASSOCIATION DATE - OWNER,
  "first_name_owner" VARCHAR  -- FIRST NAME - OWNER,
  "middle_name_owner" VARCHAR  -- MIDDLE NAME - OWNER,
  "last_name_owner" VARCHAR  -- LAST NAME - OWNER,
  "title_owner" VARCHAR  -- TITLE - OWNER,
  "organization_name_owner" VARCHAR  -- ORGANIZATION NAME - OWNER,
  "doing_business_as_name_owner" VARCHAR  -- DOING BUSINESS AS NAME - OWNER,
  "address_line_1_owner" VARCHAR  -- ADDRESS LINE 1 - OWNER,
  "address_line_2_owner" VARCHAR  -- ADDRESS LINE 2 - OWNER,
  "city_owner" VARCHAR  -- CITY - OWNER,
  "state_owner" VARCHAR  -- STATE - OWNER,
  "zip_code_owner" DOUBLE  -- ZIP CODE - OWNER,
  "percentage_ownership" DOUBLE,
  "created_for_acquisition_owner" VARCHAR  -- CREATED FOR ACQUISITION - OWNER,
  "corporation_owner" VARCHAR  -- CORPORATION - OWNER,
  "llc_owner" VARCHAR  -- LLC - OWNER,
  "medical_provider_supplier_owner" VARCHAR  -- MEDICAL PROVIDER SUPPLIER - OWNER,
  "management_services_company_owner" VARCHAR  -- MANAGEMENT SERVICES COMPANY - OWNER,
  "medical_staffing_company_owner" VARCHAR  -- MEDICAL STAFFING COMPANY - OWNER,
  "holding_company_owner" VARCHAR  -- HOLDING COMPANY - OWNER,
  "investment_firm_owner" VARCHAR  -- INVESTMENT FIRM - OWNER,
  "financial_institution_owner" VARCHAR  -- FINANCIAL INSTITUTION - OWNER,
  "consulting_firm_owner" VARCHAR  -- CONSULTING FIRM - OWNER,
  "for_profit_owner" VARCHAR  -- FOR PROFIT - OWNER,
  "non_profit_owner" VARCHAR  -- NON PROFIT - OWNER,
  "other_type_owner" VARCHAR  -- OTHER TYPE - OWNER,
  "other_type_text_owner" VARCHAR  -- OTHER TYPE TEXT - OWNER
);

Home Health Agency All Owners : 2025-04-01

@usgov.hhs_gov_home_health_agency_all_owners_09561.home_health_agency_all_owners_2025_04_01

2.8 MB
102,395 rows
38 columns

CREATE TABLE home_health_agency_all_owners_2025_04_01 (
  "enrollment_id" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "associate_id_owner" BIGINT  -- ASSOCIATE ID - OWNER,
  "type_owner" VARCHAR  -- TYPE - OWNER,
  "role_code_owner" BIGINT  -- ROLE CODE - OWNER,
  "role_text_owner" VARCHAR  -- ROLE TEXT - OWNER,
  "association_date_owner" TIMESTAMP  -- ASSOCIATION DATE - OWNER,
  "first_name_owner" VARCHAR  -- FIRST NAME - OWNER,
  "middle_name_owner" VARCHAR  -- MIDDLE NAME - OWNER,
  "last_name_owner" VARCHAR  -- LAST NAME - OWNER,
  "title_owner" VARCHAR  -- TITLE - OWNER,
  "organization_name_owner" VARCHAR  -- ORGANIZATION NAME - OWNER,
  "doing_business_as_name_owner" VARCHAR  -- DOING BUSINESS AS NAME - OWNER,
  "address_line_1_owner" VARCHAR  -- ADDRESS LINE 1 - OWNER,
  "address_line_2_owner" VARCHAR  -- ADDRESS LINE 2 - OWNER,
  "city_owner" VARCHAR  -- CITY - OWNER,
  "state_owner" VARCHAR  -- STATE - OWNER,
  "zip_code_owner" DOUBLE  -- ZIP CODE - OWNER,
  "percentage_ownership" DOUBLE,
  "created_for_acquisition_owner" VARCHAR  -- CREATED FOR ACQUISITION - OWNER,
  "corporation_owner" VARCHAR  -- CORPORATION - OWNER,
  "llc_owner" VARCHAR  -- LLC - OWNER,
  "medical_provider_supplier_owner" VARCHAR  -- MEDICAL PROVIDER SUPPLIER - OWNER,
  "management_services_company_owner" VARCHAR  -- MANAGEMENT SERVICES COMPANY - OWNER,
  "medical_staffing_company_owner" VARCHAR  -- MEDICAL STAFFING COMPANY - OWNER,
  "holding_company_owner" VARCHAR  -- HOLDING COMPANY - OWNER,
  "investment_firm_owner" VARCHAR  -- INVESTMENT FIRM - OWNER,
  "financial_institution_owner" VARCHAR  -- FINANCIAL INSTITUTION - OWNER,
  "consulting_firm_owner" VARCHAR  -- CONSULTING FIRM - OWNER,
  "for_profit_owner" VARCHAR  -- FOR PROFIT - OWNER,
  "non_profit_owner" VARCHAR  -- NON PROFIT - OWNER,
  "private_equity_company_owner" VARCHAR  -- PRIVATE EQUITY COMPANY - OWNER,
  "reit_owner" VARCHAR  -- REIT - OWNER,
  "chain_home_office_owner" VARCHAR  -- CHAIN HOME OFFICE - OWNER,
  "other_type_owner" VARCHAR  -- OTHER TYPE - OWNER,
  "other_type_text_owner" VARCHAR  -- OTHER TYPE TEXT - OWNER,
  "owned_by_another_org_or_ind_owner" VARCHAR  -- OWNED BY ANOTHER ORG OR IND - OWNER
);

Home Health Agency All Owners : 2025-07-01

@usgov.hhs_gov_home_health_agency_all_owners_09561.home_health_agency_all_owners_2025_07_01

2.81 MB
102,259 rows
38 columns

CREATE TABLE home_health_agency_all_owners_2025_07_01 (
  "enrollment_id" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "associate_id_owner" BIGINT  -- ASSOCIATE ID - OWNER,
  "type_owner" VARCHAR  -- TYPE - OWNER,
  "role_code_owner" BIGINT  -- ROLE CODE - OWNER,
  "role_text_owner" VARCHAR  -- ROLE TEXT - OWNER,
  "association_date_owner" TIMESTAMP  -- ASSOCIATION DATE - OWNER,
  "first_name_owner" VARCHAR  -- FIRST NAME - OWNER,
  "middle_name_owner" VARCHAR  -- MIDDLE NAME - OWNER,
  "last_name_owner" VARCHAR  -- LAST NAME - OWNER,
  "title_owner" VARCHAR  -- TITLE - OWNER,
  "organization_name_owner" VARCHAR  -- ORGANIZATION NAME - OWNER,
  "doing_business_as_name_owner" VARCHAR  -- DOING BUSINESS AS NAME - OWNER,
  "address_line_1_owner" VARCHAR  -- ADDRESS LINE 1 - OWNER,
  "address_line_2_owner" VARCHAR  -- ADDRESS LINE 2 - OWNER,
  "city_owner" VARCHAR  -- CITY - OWNER,
  "state_owner" VARCHAR  -- STATE - OWNER,
  "zip_code_owner" DOUBLE  -- ZIP CODE - OWNER,
  "percentage_ownership" DOUBLE,
  "created_for_acquisition_owner" VARCHAR  -- CREATED FOR ACQUISITION - OWNER,
  "corporation_owner" VARCHAR  -- CORPORATION - OWNER,
  "llc_owner" VARCHAR  -- LLC - OWNER,
  "medical_provider_supplier_owner" VARCHAR  -- MEDICAL PROVIDER SUPPLIER - OWNER,
  "management_services_company_owner" VARCHAR  -- MANAGEMENT SERVICES COMPANY - OWNER,
  "medical_staffing_company_owner" VARCHAR  -- MEDICAL STAFFING COMPANY - OWNER,
  "holding_company_owner" VARCHAR  -- HOLDING COMPANY - OWNER,
  "investment_firm_owner" VARCHAR  -- INVESTMENT FIRM - OWNER,
  "financial_institution_owner" VARCHAR  -- FINANCIAL INSTITUTION - OWNER,
  "consulting_firm_owner" VARCHAR  -- CONSULTING FIRM - OWNER,
  "for_profit_owner" VARCHAR  -- FOR PROFIT - OWNER,
  "non_profit_owner" VARCHAR  -- NON PROFIT - OWNER,
  "private_equity_company_owner" VARCHAR  -- PRIVATE EQUITY COMPANY - OWNER,
  "reit_owner" VARCHAR  -- REIT - OWNER,
  "chain_home_office_owner" VARCHAR  -- CHAIN HOME OFFICE - OWNER,
  "other_type_owner" VARCHAR  -- OTHER TYPE - OWNER,
  "other_type_text_owner" VARCHAR  -- OTHER TYPE TEXT - OWNER,
  "owned_by_another_org_or_ind_owner" VARCHAR  -- OWNED BY ANOTHER ORG OR IND - OWNER
);