Hospital Change Of Ownership - Owner Information
U.S. Department of Health & Human Services
@usgov.hhs_gov_hospital_change_of_ownership_owner_information
U.S. Department of Health & Human Services
@usgov.hhs_gov_hospital_change_of_ownership_owner_information
CREATE TABLE hospital_change_of_ownership_owner_information_2022_03_31 (
"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" VARCHAR,
"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
);
CREATE TABLE hospital_change_of_ownership_owner_information_2022_06_30 (
"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
);
CREATE TABLE hospital_change_of_ownership_owner_information_2022_09_30 (
"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
);
CREATE TABLE hospital_change_of_ownership_owner_information_2022_12_30 (
"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
);
CREATE TABLE hospital_change_of_ownership_owner_information_2023_03_31 (
"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
);
CREATE TABLE hospital_change_of_ownership_owner_information_2023_06_30 (
"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
);
CREATE TABLE hospital_change_of_ownership_owner_information_2023_09_30 (
"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
);
CREATE TABLE hospital_change_of_ownership_owner_information_2023_12_31 (
"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
);
CREATE TABLE hospital_change_of_ownership_owner_information_2024_03_31 (
"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
);
CREATE TABLE hospital_change_of_ownership_owner_information_2024_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,
"other_type_owner" VARCHAR,
"other_type_text_owner" VARCHAR
);
CREATE TABLE hospital_change_of_ownership_owner_information_2024_09_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
);
CREATE TABLE hospital_change_of_ownership_owner_information_2024_12_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
);
CREATE TABLE hospital_change_of_ownership_owner_information_2025_03_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
);
Anyone who has the link will be able to view this.