About this Dataset

Hospital Change Of Ownership - Owner Information

The Hospital Change of Ownership (CHOW) - Owner Information dataset provides information on individual and organizational ownership interest and managerial control associated with the buyer and seller organizations, role of the owner, association date, address of the organizational owner and other ownership details.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-05-16T05:59:29.010644
Tags: hospitals-facilities, medicare, medicare-advantage, original-medicare, provider-enrollment

Tables

Hospital Change Of Ownership - Owner Information : 2022-03-31

@usgov.hhs_gov_hospital_change_of_ownership_owner_information.hospital_change_of_ownership_owner_information_2022_03_31

398.29 kB
15,104 rows
34 columns

CREATE TABLE hospital_change_of_ownership_owner_information_2022_03_31 (
  "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" VARCHAR  -- 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
);

Hospital Change Of Ownership - Owner Information : 2022-06-30

@usgov.hhs_gov_hospital_change_of_ownership_owner_information.hospital_change_of_ownership_owner_information_2022_06_30

400.44 kB
15,157 rows
34 columns

CREATE TABLE hospital_change_of_ownership_owner_information_2022_06_30 (
  "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
);

Hospital Change Of Ownership - Owner Information : 2022-09-30

@usgov.hhs_gov_hospital_change_of_ownership_owner_information.hospital_change_of_ownership_owner_information_2022_09_30

398.65 kB
15,225 rows
34 columns

CREATE TABLE hospital_change_of_ownership_owner_information_2022_09_30 (
  "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
);

Hospital Change Of Ownership - Owner Information : 2022-12-30

@usgov.hhs_gov_hospital_change_of_ownership_owner_information.hospital_change_of_ownership_owner_information_2022_12_30

402.91 kB
15,317 rows
34 columns

CREATE TABLE hospital_change_of_ownership_owner_information_2022_12_30 (
  "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
);

Hospital Change Of Ownership - Owner Information : 2023-03-31

@usgov.hhs_gov_hospital_change_of_ownership_owner_information.hospital_change_of_ownership_owner_information_2023_03_31

401.13 kB
15,132 rows
34 columns

CREATE TABLE hospital_change_of_ownership_owner_information_2023_03_31 (
  "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
);

Hospital Change Of Ownership - Owner Information : 2023-06-30

@usgov.hhs_gov_hospital_change_of_ownership_owner_information.hospital_change_of_ownership_owner_information_2023_06_30

483.37 kB
18,953 rows
34 columns

CREATE TABLE hospital_change_of_ownership_owner_information_2023_06_30 (
  "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
);

Hospital Change Of Ownership - Owner Information : 2023-09-30

@usgov.hhs_gov_hospital_change_of_ownership_owner_information.hospital_change_of_ownership_owner_information_2023_09_30

491.59 kB
19,233 rows
34 columns

CREATE TABLE hospital_change_of_ownership_owner_information_2023_09_30 (
  "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
);

Hospital Change Of Ownership - Owner Information : 2023-12-31

@usgov.hhs_gov_hospital_change_of_ownership_owner_information.hospital_change_of_ownership_owner_information_2023_12_31

507.15 kB
19,753 rows
34 columns

CREATE TABLE hospital_change_of_ownership_owner_information_2023_12_31 (
  "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
);

Hospital Change Of Ownership - Owner Information : 2024-03-31

@usgov.hhs_gov_hospital_change_of_ownership_owner_information.hospital_change_of_ownership_owner_information_2024_03_31

518.72 kB
20,089 rows
34 columns

CREATE TABLE hospital_change_of_ownership_owner_information_2024_03_31 (
  "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
);

Hospital Change Of Ownership - Owner Information : 2024-06-01

@usgov.hhs_gov_hospital_change_of_ownership_owner_information.hospital_change_of_ownership_owner_information_2024_06_01

528.97 kB
20,227 rows
34 columns

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

Hospital Change Of Ownership - Owner Information : 2024-09-01

@usgov.hhs_gov_hospital_change_of_ownership_owner_information.hospital_change_of_ownership_owner_information_2024_09_01

539.99 kB
20,567 rows
34 columns

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

Hospital Change Of Ownership - Owner Information : 2024-12-01

@usgov.hhs_gov_hospital_change_of_ownership_owner_information.hospital_change_of_ownership_owner_information_2024_12_01

547.12 kB
20,909 rows
34 columns

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

Hospital Change Of Ownership - Owner Information : 2025-03-01

@usgov.hhs_gov_hospital_change_of_ownership_owner_information.hospital_change_of_ownership_owner_information_2025_03_01

558.25 kB
21,289 rows
34 columns

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