Dataset: Home Health Agency All Owners

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-05-16T06:02:18.480106
Tags: home-health, hospitals-facilities, medicare, medicare-advantage, original-medicare, provider-enrollment

Tables

Home Health Agency All Owners : 2025-04-01

@usgov.hhs_gov_home_health_agency_all_owners.home_health_agency_all_owners_2025_04_01

2.67 MB
102395 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,
  "type_owner" VARCHAR,
  "role_code_owner" BIGINT,
  "role_text_owner" VARCHAR,
  "association_date_owner" TIMESTAMP,
  "first_name_owner" VARCHAR,
  "middle_name_owner" VARCHAR,
  "last_name_owner" VARCHAR,
  "title_owner" VARCHAR,
  "organization_name_owner" VARCHAR,
  "doing_business_as_name_owner" VARCHAR,
  "address_line_1_owner" VARCHAR,
  "address_line_2_owner" VARCHAR,
  "city_owner" VARCHAR,
  "state_owner" VARCHAR,
  "zip_code_owner" DOUBLE,
  "percentage_ownership" DOUBLE,
  "created_for_acquisition_owner" VARCHAR,
  "corporation_owner" VARCHAR,
  "llc_owner" VARCHAR,
  "medical_provider_supplier_owner" VARCHAR,
  "management_services_company_owner" VARCHAR,
  "medical_staffing_company_owner" VARCHAR,
  "holding_company_owner" VARCHAR,
  "investment_firm_owner" VARCHAR,
  "financial_institution_owner" VARCHAR,
  "consulting_firm_owner" VARCHAR,
  "for_profit_owner" VARCHAR,
  "non_profit_owner" VARCHAR,
  "private_equity_company_owner" VARCHAR,
  "reit_owner" VARCHAR,
  "chain_home_office_owner" VARCHAR,
  "other_type_owner" VARCHAR,
  "other_type_text_owner" VARCHAR,
  "owned_by_another_org_or_ind_owner" VARCHAR
);

Home Health Agency All Owners : 2025-01-01

@usgov.hhs_gov_home_health_agency_all_owners.home_health_agency_all_owners_2025_01_01

2.68 MB
102925 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,
  "type_owner" VARCHAR,
  "role_code_owner" BIGINT,
  "role_text_owner" VARCHAR,
  "association_date_owner" TIMESTAMP,
  "first_name_owner" VARCHAR,
  "middle_name_owner" VARCHAR,
  "last_name_owner" VARCHAR,
  "title_owner" VARCHAR,
  "organization_name_owner" VARCHAR,
  "doing_business_as_name_owner" VARCHAR,
  "address_line_1_owner" VARCHAR,
  "address_line_2_owner" VARCHAR,
  "city_owner" VARCHAR,
  "state_owner" VARCHAR,
  "zip_code_owner" DOUBLE,
  "percentage_ownership" DOUBLE,
  "created_for_acquisition_owner" VARCHAR,
  "corporation_owner" VARCHAR,
  "llc_owner" VARCHAR,
  "medical_provider_supplier_owner" VARCHAR,
  "management_services_company_owner" VARCHAR,
  "medical_staffing_company_owner" VARCHAR,
  "holding_company_owner" VARCHAR,
  "investment_firm_owner" VARCHAR,
  "financial_institution_owner" VARCHAR,
  "consulting_firm_owner" VARCHAR,
  "for_profit_owner" VARCHAR,
  "non_profit_owner" VARCHAR,
  "other_type_owner" VARCHAR,
  "other_type_text_owner" VARCHAR
);

Home Health Agency All Owners : 2024-10-01

@usgov.hhs_gov_home_health_agency_all_owners.home_health_agency_all_owners_2024_10_01

2.68 MB
103003 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,
  "type_owner" VARCHAR,
  "role_code_owner" BIGINT,
  "role_text_owner" VARCHAR,
  "association_date_owner" TIMESTAMP,
  "first_name_owner" VARCHAR,
  "middle_name_owner" VARCHAR,
  "last_name_owner" VARCHAR,
  "title_owner" VARCHAR,
  "organization_name_owner" VARCHAR,
  "doing_business_as_name_owner" VARCHAR,
  "address_line_1_owner" VARCHAR,
  "address_line_2_owner" VARCHAR,
  "city_owner" VARCHAR,
  "state_owner" VARCHAR,
  "zip_code_owner" DOUBLE,
  "percentage_ownership" DOUBLE,
  "created_for_acquisition_owner" VARCHAR,
  "corporation_owner" VARCHAR,
  "llc_owner" VARCHAR,
  "medical_provider_supplier_owner" VARCHAR,
  "management_services_company_owner" VARCHAR,
  "medical_staffing_company_owner" VARCHAR,
  "holding_company_owner" VARCHAR,
  "investment_firm_owner" VARCHAR,
  "financial_institution_owner" VARCHAR,
  "consulting_firm_owner" VARCHAR,
  "for_profit_owner" VARCHAR,
  "non_profit_owner" VARCHAR,
  "other_type_owner" VARCHAR,
  "other_type_text_owner" VARCHAR
);

Home Health Agency All Owners : 2024-07-01

@usgov.hhs_gov_home_health_agency_all_owners.home_health_agency_all_owners_2024_07_01

2.7 MB
104004 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,
  "type_owner" VARCHAR,
  "role_code_owner" BIGINT,
  "role_text_owner" VARCHAR,
  "association_date_owner" TIMESTAMP,
  "first_name_owner" VARCHAR,
  "middle_name_owner" VARCHAR,
  "last_name_owner" VARCHAR,
  "title_owner" VARCHAR,
  "organization_name_owner" VARCHAR,
  "doing_business_as_name_owner" VARCHAR,
  "address_line_1_owner" VARCHAR,
  "address_line_2_owner" VARCHAR,
  "city_owner" VARCHAR,
  "state_owner" VARCHAR,
  "zip_code_owner" DOUBLE,
  "percentage_ownership" DOUBLE,
  "created_for_acquisition_owner" VARCHAR,
  "corporation_owner" VARCHAR,
  "llc_owner" VARCHAR,
  "medical_provider_supplier_owner" VARCHAR,
  "management_services_company_owner" VARCHAR,
  "medical_staffing_company_owner" VARCHAR,
  "holding_company_owner" VARCHAR,
  "investment_firm_owner" VARCHAR,
  "financial_institution_owner" VARCHAR,
  "consulting_firm_owner" VARCHAR,
  "for_profit_owner" VARCHAR,
  "non_profit_owner" VARCHAR,
  "other_type_owner" VARCHAR,
  "other_type_text_owner" VARCHAR
);