About this Dataset

Hospital All Owners

The Hospital All Owners Information dataset provides information on all owners of the hospitals. 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-07-16T16:20:54.642638
Tags: hospitals-facilities, medicare, medicare-advantage, original-medicare, provider-enrollment

Tables

Hospital All Owners : 2025-06-01

@usgov.hhs_gov_hospital_all_owners.hospital_all_owners_2025_06_01

3.41 MB
148170 rows
38 columns


CREATE TABLE hospital_all_owners_2025_06_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
);

Hospital All Owners : 2025-07-01

@usgov.hhs_gov_hospital_all_owners.hospital_all_owners_2025_07_01

3.41 MB
148088 rows
38 columns


CREATE TABLE hospital_all_owners_2025_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,
  "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
);