About this Dataset

Skilled Nursing Facility Change Of Ownership

The Skilled Nursing Facility (SNF) Change of Ownership (CHOW) dataset provides information on the SNF ownership changes that occurred on or after January 1, 2016. This data includes information on the buyer and seller organization’s legal business name, provider type, change of ownership type (CHOW, Acquisition/Merger, or Consolidation) and the effective date of the change.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:28:47.959007
Tags: hospitals-facilities, medicare, medicare-prescription-drug, original-medicare, provider-enrollment

Tables

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_0475c.skilled_nursing_facility_change_of_ownership_2022_03_31

421.98 kB
3,267 rows
23 columns

CREATE TABLE skilled_nursing_facility_change_of_ownership_2022_03_31 (
  "enrollment_id_buyer" VARCHAR  -- ENROLLMENT ID - BUYER,
  "enrollment_state_buyer" VARCHAR  -- ENROLLMENT STATE - BUYER,
  "provider_type_code_buyer" VARCHAR  -- PROVIDER TYPE CODE - BUYER,
  "provider_type_text_buyer" VARCHAR  -- PROVIDER TYPE TEXT - BUYER,
  "npi_buyer" BIGINT  -- NPI - BUYER,
  "multiple_npi_flag_buyer" VARCHAR  -- MULTIPLE NPI FLAG - BUYER,
  "ccn_buyer" VARCHAR  -- CCN - BUYER,
  "associate_id_buyer" BIGINT  -- ASSOCIATE ID - BUYER,
  "organization_name_buyer" VARCHAR  -- ORGANIZATION NAME - BUYER,
  "doing_business_as_name_buyer" VARCHAR  -- DOING BUSINESS AS NAME - BUYER,
  "chow_type_code" VARCHAR,
  "chow_type_text" VARCHAR,
  "effective_date" TIMESTAMP,
  "enrollment_id_seller" VARCHAR  -- ENROLLMENT ID - SELLER,
  "enrollment_state_seller" VARCHAR  -- ENROLLMENT STATE - SELLER,
  "provider_type_code_seller" VARCHAR  -- PROVIDER TYPE CODE - SELLER,
  "provider_type_text_seller" VARCHAR  -- PROVIDER TYPE TEXT - SELLER,
  "npi_seller" DOUBLE  -- NPI - SELLER,
  "multiple_npi_flag_seller" VARCHAR  -- MULTIPLE NPI FLAG - SELLER,
  "ccn_seller" VARCHAR  -- CCN - SELLER,
  "associate_id_seller" BIGINT  -- ASSOCIATE ID - SELLER,
  "organization_name_seller" VARCHAR  -- ORGANIZATION NAME - SELLER,
  "doing_business_as_name_seller" VARCHAR  -- DOING BUSINESS AS NAME - SELLER
);

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_0475c.skilled_nursing_facility_change_of_ownership_2022_06_30

434.59 kB
3,367 rows
23 columns

CREATE TABLE skilled_nursing_facility_change_of_ownership_2022_06_30 (
  "enrollment_id_buyer" VARCHAR  -- ENROLLMENT ID - BUYER,
  "enrollment_state_buyer" VARCHAR  -- ENROLLMENT STATE - BUYER,
  "provider_type_code_buyer" VARCHAR  -- PROVIDER TYPE CODE - BUYER,
  "provider_type_text_buyer" VARCHAR  -- PROVIDER TYPE TEXT - BUYER,
  "npi_buyer" BIGINT  -- NPI - BUYER,
  "multiple_npi_flag_buyer" VARCHAR  -- MULTIPLE NPI FLAG - BUYER,
  "ccn_buyer" VARCHAR  -- CCN - BUYER,
  "associate_id_buyer" BIGINT  -- ASSOCIATE ID - BUYER,
  "organization_name_buyer" VARCHAR  -- ORGANIZATION NAME - BUYER,
  "doing_business_as_name_buyer" VARCHAR  -- DOING BUSINESS AS NAME - BUYER,
  "chow_type_code" VARCHAR,
  "chow_type_text" VARCHAR,
  "effective_date" TIMESTAMP,
  "enrollment_id_seller" VARCHAR  -- ENROLLMENT ID - SELLER,
  "enrollment_state_seller" VARCHAR  -- ENROLLMENT STATE - SELLER,
  "provider_type_code_seller" VARCHAR  -- PROVIDER TYPE CODE - SELLER,
  "provider_type_text_seller" VARCHAR  -- PROVIDER TYPE TEXT - SELLER,
  "npi_seller" DOUBLE  -- NPI - SELLER,
  "multiple_npi_flag_seller" VARCHAR  -- MULTIPLE NPI FLAG - SELLER,
  "ccn_seller" VARCHAR  -- CCN - SELLER,
  "associate_id_seller" BIGINT  -- ASSOCIATE ID - SELLER,
  "organization_name_seller" VARCHAR  -- ORGANIZATION NAME - SELLER,
  "doing_business_as_name_seller" VARCHAR  -- DOING BUSINESS AS NAME - SELLER
);

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_0475c.skilled_nursing_facility_change_of_ownership_2022_09_30

451.75 kB
3,499 rows
23 columns

CREATE TABLE skilled_nursing_facility_change_of_ownership_2022_09_30 (
  "enrollment_id_buyer" VARCHAR  -- ENROLLMENT ID - BUYER,
  "enrollment_state_buyer" VARCHAR  -- ENROLLMENT STATE - BUYER,
  "provider_type_code_buyer" VARCHAR  -- PROVIDER TYPE CODE - BUYER,
  "provider_type_text_buyer" VARCHAR  -- PROVIDER TYPE TEXT - BUYER,
  "npi_buyer" BIGINT  -- NPI - BUYER,
  "multiple_npi_flag_buyer" VARCHAR  -- MULTIPLE NPI FLAG - BUYER,
  "ccn_buyer" VARCHAR  -- CCN - BUYER,
  "associate_id_buyer" BIGINT  -- ASSOCIATE ID - BUYER,
  "organization_name_buyer" VARCHAR  -- ORGANIZATION NAME - BUYER,
  "doing_business_as_name_buyer" VARCHAR  -- DOING BUSINESS AS NAME - BUYER,
  "chow_type_code" VARCHAR,
  "chow_type_text" VARCHAR,
  "effective_date" TIMESTAMP,
  "enrollment_id_seller" VARCHAR  -- ENROLLMENT ID - SELLER,
  "enrollment_state_seller" VARCHAR  -- ENROLLMENT STATE - SELLER,
  "provider_type_code_seller" VARCHAR  -- PROVIDER TYPE CODE - SELLER,
  "provider_type_text_seller" VARCHAR  -- PROVIDER TYPE TEXT - SELLER,
  "npi_seller" DOUBLE  -- NPI - SELLER,
  "multiple_npi_flag_seller" VARCHAR  -- MULTIPLE NPI FLAG - SELLER,
  "ccn_seller" VARCHAR  -- CCN - SELLER,
  "associate_id_seller" BIGINT  -- ASSOCIATE ID - SELLER,
  "organization_name_seller" VARCHAR  -- ORGANIZATION NAME - SELLER,
  "doing_business_as_name_seller" VARCHAR  -- DOING BUSINESS AS NAME - SELLER
);

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_0475c.skilled_nursing_facility_change_of_ownership_2022_12_30

466.88 kB
3,625 rows
23 columns

CREATE TABLE skilled_nursing_facility_change_of_ownership_2022_12_30 (
  "enrollment_id_buyer" VARCHAR  -- ENROLLMENT ID - BUYER,
  "enrollment_state_buyer" VARCHAR  -- ENROLLMENT STATE - BUYER,
  "provider_type_code_buyer" VARCHAR  -- PROVIDER TYPE CODE - BUYER,
  "provider_type_text_buyer" VARCHAR  -- PROVIDER TYPE TEXT - BUYER,
  "npi_buyer" BIGINT  -- NPI - BUYER,
  "multiple_npi_flag_buyer" VARCHAR  -- MULTIPLE NPI FLAG - BUYER,
  "ccn_buyer" VARCHAR  -- CCN - BUYER,
  "associate_id_buyer" BIGINT  -- ASSOCIATE ID - BUYER,
  "organization_name_buyer" VARCHAR  -- ORGANIZATION NAME - BUYER,
  "doing_business_as_name_buyer" VARCHAR  -- DOING BUSINESS AS NAME - BUYER,
  "chow_type_code" VARCHAR,
  "chow_type_text" VARCHAR,
  "effective_date" TIMESTAMP,
  "enrollment_id_seller" VARCHAR  -- ENROLLMENT ID - SELLER,
  "enrollment_state_seller" VARCHAR  -- ENROLLMENT STATE - SELLER,
  "provider_type_code_seller" VARCHAR  -- PROVIDER TYPE CODE - SELLER,
  "provider_type_text_seller" VARCHAR  -- PROVIDER TYPE TEXT - SELLER,
  "npi_seller" DOUBLE  -- NPI - SELLER,
  "multiple_npi_flag_seller" VARCHAR  -- MULTIPLE NPI FLAG - SELLER,
  "ccn_seller" VARCHAR  -- CCN - SELLER,
  "associate_id_seller" BIGINT  -- ASSOCIATE ID - SELLER,
  "organization_name_seller" VARCHAR  -- ORGANIZATION NAME - SELLER,
  "doing_business_as_name_seller" VARCHAR  -- DOING BUSINESS AS NAME - SELLER
);

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_0475c.skilled_nursing_facility_change_of_ownership_2023_03_31

477.98 kB
3,717 rows
23 columns

CREATE TABLE skilled_nursing_facility_change_of_ownership_2023_03_31 (
  "enrollment_id_buyer" VARCHAR  -- ENROLLMENT ID - BUYER,
  "enrollment_state_buyer" VARCHAR  -- ENROLLMENT STATE - BUYER,
  "provider_type_code_buyer" VARCHAR  -- PROVIDER TYPE CODE - BUYER,
  "provider_type_text_buyer" VARCHAR  -- PROVIDER TYPE TEXT - BUYER,
  "npi_buyer" BIGINT  -- NPI - BUYER,
  "multiple_npi_flag_buyer" VARCHAR  -- MULTIPLE NPI FLAG - BUYER,
  "ccn_buyer" VARCHAR  -- CCN - BUYER,
  "associate_id_buyer" BIGINT  -- ASSOCIATE ID - BUYER,
  "organization_name_buyer" VARCHAR  -- ORGANIZATION NAME - BUYER,
  "doing_business_as_name_buyer" VARCHAR  -- DOING BUSINESS AS NAME - BUYER,
  "chow_type_code" VARCHAR,
  "chow_type_text" VARCHAR,
  "effective_date" TIMESTAMP,
  "enrollment_id_seller" VARCHAR  -- ENROLLMENT ID - SELLER,
  "enrollment_state_seller" VARCHAR  -- ENROLLMENT STATE - SELLER,
  "provider_type_code_seller" VARCHAR  -- PROVIDER TYPE CODE - SELLER,
  "provider_type_text_seller" VARCHAR  -- PROVIDER TYPE TEXT - SELLER,
  "npi_seller" DOUBLE  -- NPI - SELLER,
  "multiple_npi_flag_seller" VARCHAR  -- MULTIPLE NPI FLAG - SELLER,
  "ccn_seller" VARCHAR  -- CCN - SELLER,
  "associate_id_seller" BIGINT  -- ASSOCIATE ID - SELLER,
  "organization_name_seller" VARCHAR  -- ORGANIZATION NAME - SELLER,
  "doing_business_as_name_seller" VARCHAR  -- DOING BUSINESS AS NAME - SELLER
);

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_0475c.skilled_nursing_facility_change_of_ownership_2023_06_30

495.18 kB
3,852 rows
23 columns

CREATE TABLE skilled_nursing_facility_change_of_ownership_2023_06_30 (
  "enrollment_id_buyer" VARCHAR  -- ENROLLMENT ID - BUYER,
  "enrollment_state_buyer" VARCHAR  -- ENROLLMENT STATE - BUYER,
  "provider_type_code_buyer" VARCHAR  -- PROVIDER TYPE CODE - BUYER,
  "provider_type_text_buyer" VARCHAR  -- PROVIDER TYPE TEXT - BUYER,
  "npi_buyer" BIGINT  -- NPI - BUYER,
  "multiple_npi_flag_buyer" VARCHAR  -- MULTIPLE NPI FLAG - BUYER,
  "ccn_buyer" VARCHAR  -- CCN - BUYER,
  "associate_id_buyer" BIGINT  -- ASSOCIATE ID - BUYER,
  "organization_name_buyer" VARCHAR  -- ORGANIZATION NAME - BUYER,
  "doing_business_as_name_buyer" VARCHAR  -- DOING BUSINESS AS NAME - BUYER,
  "chow_type_code" VARCHAR,
  "chow_type_text" VARCHAR,
  "effective_date" TIMESTAMP,
  "enrollment_id_seller" VARCHAR  -- ENROLLMENT ID - SELLER,
  "enrollment_state_seller" VARCHAR  -- ENROLLMENT STATE - SELLER,
  "provider_type_code_seller" VARCHAR  -- PROVIDER TYPE CODE - SELLER,
  "provider_type_text_seller" VARCHAR  -- PROVIDER TYPE TEXT - SELLER,
  "npi_seller" DOUBLE  -- NPI - SELLER,
  "multiple_npi_flag_seller" VARCHAR  -- MULTIPLE NPI FLAG - SELLER,
  "ccn_seller" VARCHAR  -- CCN - SELLER,
  "associate_id_seller" BIGINT  -- ASSOCIATE ID - SELLER,
  "organization_name_seller" VARCHAR  -- ORGANIZATION NAME - SELLER,
  "doing_business_as_name_seller" VARCHAR  -- DOING BUSINESS AS NAME - SELLER
);

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership_0475c.skilled_nursing_facility_change_of_ownership_2023_09_30

517.7 kB
4,041 rows
23 columns

CREATE TABLE skilled_nursing_facility_change_of_ownership_2023_09_30 (
  "enrollment_id_buyer" VARCHAR  -- ENROLLMENT ID - BUYER,
  "enrollment_state_buyer" VARCHAR  -- ENROLLMENT STATE - BUYER,
  "provider_type_code_buyer" VARCHAR  -- PROVIDER TYPE CODE - BUYER,
  "provider_type_text_buyer" VARCHAR  -- PROVIDER TYPE TEXT - BUYER,
  "npi_buyer" BIGINT  -- NPI - BUYER,
  "multiple_npi_flag_buyer" VARCHAR  -- MULTIPLE NPI FLAG - BUYER,
  "ccn_buyer" VARCHAR  -- CCN - BUYER,
  "associate_id_buyer" BIGINT  -- ASSOCIATE ID - BUYER,
  "organization_name_buyer" VARCHAR  -- ORGANIZATION NAME - BUYER,
  "doing_business_as_name_buyer" VARCHAR  -- DOING BUSINESS AS NAME - BUYER,
  "chow_type_code" VARCHAR,
  "chow_type_text" VARCHAR,
  "effective_date" TIMESTAMP,
  "enrollment_id_seller" VARCHAR  -- ENROLLMENT ID - SELLER,
  "enrollment_state_seller" VARCHAR  -- ENROLLMENT STATE - SELLER,
  "provider_type_code_seller" VARCHAR  -- PROVIDER TYPE CODE - SELLER,
  "provider_type_text_seller" VARCHAR  -- PROVIDER TYPE TEXT - SELLER,
  "npi_seller" DOUBLE  -- NPI - SELLER,
  "multiple_npi_flag_seller" VARCHAR  -- MULTIPLE NPI FLAG - SELLER,
  "ccn_seller" VARCHAR  -- CCN - SELLER,
  "associate_id_seller" BIGINT  -- ASSOCIATE ID - SELLER,
  "organization_name_seller" VARCHAR  -- ORGANIZATION NAME - SELLER,
  "doing_business_as_name_seller" VARCHAR  -- DOING BUSINESS AS NAME - SELLER
);