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-07-16T16:30:01.509092
Tags: hospitals-facilities, medicare, medicare-advantage, original-medicare, provider-enrollment

Tables

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_o_eb433ed6.skilled_nursing_facility_change_of_ownership_owner_inf_fae988ea

2.75 MB
107209 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,
  "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
);