About this Dataset

Skilled Nursing Facility Change Of Ownership - Owner Information

The Skilled Nursing Facility (SNF) 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-10-07T07:32:05.866436
Tags: hospitals-facilities, medicare, medicare-advantage, original-medicare, provider-enrollment

Tables

Skilled Nursing Facility Change Of Ownership - Owner Information : 2025-03-01

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_7248ed46.skilled_nursing_facility_change_of_ownership_owner_inf_024e4a7a

2.76 MB
103,102 rows
34 columns

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

Skilled Nursing Facility Change Of Ownership - Owner Information : 2022-12-30

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_7248ed46.skilled_nursing_facility_change_of_ownership_owner_inf_06d95674

2.1 MB
80,684 rows
34 columns

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

Skilled Nursing Facility Change Of Ownership - Owner Information : 2023-09-30

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_7248ed46.skilled_nursing_facility_change_of_ownership_owner_inf_1009e0ee

2.31 MB
88,111 rows
34 columns

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

Skilled Nursing Facility Change Of Ownership - Owner Information : 2023-12-31

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_7248ed46.skilled_nursing_facility_change_of_ownership_owner_inf_3ee09aa7

2.41 MB
91,574 rows
34 columns

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

Skilled Nursing Facility Change Of Ownership - Owner Information : 2024-12-01

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_7248ed46.skilled_nursing_facility_change_of_ownership_owner_inf_63525b65

2.72 MB
101,711 rows
34 columns

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

Skilled Nursing Facility Change Of Ownership - Owner Information : 2024-09-01

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_7248ed46.skilled_nursing_facility_change_of_ownership_owner_inf_b2a788d5

2.68 MB
100,875 rows
34 columns

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

Skilled Nursing Facility Change Of Ownership - Owner Information : 2022-06-30

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_7248ed46.skilled_nursing_facility_change_of_ownership_owner_inf_bb046ee4

1.97 MB
76,297 rows
34 columns

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

Skilled Nursing Facility Change Of Ownership - Owner Information : 2024-03-31

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_7248ed46.skilled_nursing_facility_change_of_ownership_owner_inf_cd31230b

2.49 MB
94,869 rows
34 columns

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

Skilled Nursing Facility Change Of Ownership - Owner Information : 2022-03-31

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_7248ed46.skilled_nursing_facility_change_of_ownership_owner_inf_e1f6db59

1.92 MB
74,481 rows
34 columns

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

Skilled Nursing Facility Change Of Ownership - Owner Information : 2022-09-30

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_7248ed46.skilled_nursing_facility_change_of_ownership_owner_inf_e7e5f896

2.05 MB
78,384 rows
34 columns

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

Skilled Nursing Facility Change Of Ownership - Owner Information : 2024-06-01

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_7248ed46.skilled_nursing_facility_change_of_ownership_owner_inf_e8ada00e

2.58 MB
98,071 rows
34 columns

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

Skilled Nursing Facility Change Of Ownership - Owner Information : 2023-03-31

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_7248ed46.skilled_nursing_facility_change_of_ownership_owner_inf_e8f832c6

2.14 MB
82,229 rows
34 columns

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

Skilled Nursing Facility Change Of Ownership - Owner Information : 2023-06-30

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_7248ed46.skilled_nursing_facility_change_of_ownership_owner_inf_ecc1ad4d

2.2 MB
84,562 rows
34 columns

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

Skilled Nursing Facility Change Of Ownership - Owner Information : 2025-06-01

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_7248ed46.skilled_nursing_facility_change_of_ownership_owner_inf_fae988ea

2.88 MB
107,209 rows
34 columns

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