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-10-23T10:01:49.930465
Tags: hospitals-facilities, medicare, medicare-advantage, original-medicare, provider-enrollment

Tables

Hospital All Owners : 2025-10-01

@usgov.hhs_gov_hospital_all_owners_2af72.hospital_all_owners_2025_10_01

3.57 MB
148,046 rows
38 columns

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