Dataset: Skilled Nursing Facility Change Of Ownership

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: 2023-10-18T00:24:52.371684
Tags: hospitals-facilities, medicare, medicare-prescription-drug, original-medicare, provider-enrollment

Tables

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership.skilled_nursing_facility_change_of_ownership_2023_09_30

505.57 KB
4041 rows
23 columns


CREATE TABLE skilled_nursing_facility_change_of_ownership_2023_09_30 (
  "enrollment_id_buyer" VARCHAR,
  "enrollment_state_buyer" VARCHAR,
  "provider_type_code_buyer" VARCHAR,
  "provider_type_text_buyer" VARCHAR,
  "npi_buyer" BIGINT,
  "multiple_npi_flag_buyer" VARCHAR,
  "ccn_buyer" VARCHAR,
  "associate_id_buyer" BIGINT,
  "organization_name_buyer" VARCHAR,
  "doing_business_as_name_buyer" VARCHAR,
  "chow_type_code" VARCHAR,
  "chow_type_text" VARCHAR,
  "effective_date" TIMESTAMP,
  "enrollment_id_seller" VARCHAR,
  "enrollment_state_seller" VARCHAR,
  "provider_type_code_seller" VARCHAR,
  "provider_type_text_seller" VARCHAR,
  "npi_seller" DOUBLE,
  "multiple_npi_flag_seller" VARCHAR,
  "ccn_seller" VARCHAR,
  "associate_id_seller" BIGINT,
  "organization_name_seller" VARCHAR,
  "doing_business_as_name_seller" VARCHAR
);

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership.skilled_nursing_facility_change_of_ownership_2023_06_30

483.57 KB
3852 rows
23 columns


CREATE TABLE skilled_nursing_facility_change_of_ownership_2023_06_30 (
  "enrollment_id_buyer" VARCHAR,
  "enrollment_state_buyer" VARCHAR,
  "provider_type_code_buyer" VARCHAR,
  "provider_type_text_buyer" VARCHAR,
  "npi_buyer" BIGINT,
  "multiple_npi_flag_buyer" VARCHAR,
  "ccn_buyer" VARCHAR,
  "associate_id_buyer" BIGINT,
  "organization_name_buyer" VARCHAR,
  "doing_business_as_name_buyer" VARCHAR,
  "chow_type_code" VARCHAR,
  "chow_type_text" VARCHAR,
  "effective_date" TIMESTAMP,
  "enrollment_id_seller" VARCHAR,
  "enrollment_state_seller" VARCHAR,
  "provider_type_code_seller" VARCHAR,
  "provider_type_text_seller" VARCHAR,
  "npi_seller" DOUBLE,
  "multiple_npi_flag_seller" VARCHAR,
  "ccn_seller" VARCHAR,
  "associate_id_seller" BIGINT,
  "organization_name_seller" VARCHAR,
  "doing_business_as_name_seller" VARCHAR
);

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership.skilled_nursing_facility_change_of_ownership_2023_03_31

466.78 KB
3717 rows
23 columns


CREATE TABLE skilled_nursing_facility_change_of_ownership_2023_03_31 (
  "enrollment_id_buyer" VARCHAR,
  "enrollment_state_buyer" VARCHAR,
  "provider_type_code_buyer" VARCHAR,
  "provider_type_text_buyer" VARCHAR,
  "npi_buyer" BIGINT,
  "multiple_npi_flag_buyer" VARCHAR,
  "ccn_buyer" VARCHAR,
  "associate_id_buyer" BIGINT,
  "organization_name_buyer" VARCHAR,
  "doing_business_as_name_buyer" VARCHAR,
  "chow_type_code" VARCHAR,
  "chow_type_text" VARCHAR,
  "effective_date" TIMESTAMP,
  "enrollment_id_seller" VARCHAR,
  "enrollment_state_seller" VARCHAR,
  "provider_type_code_seller" VARCHAR,
  "provider_type_text_seller" VARCHAR,
  "npi_seller" DOUBLE,
  "multiple_npi_flag_seller" VARCHAR,
  "ccn_seller" VARCHAR,
  "associate_id_seller" BIGINT,
  "organization_name_seller" VARCHAR,
  "doing_business_as_name_seller" VARCHAR
);

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership.skilled_nursing_facility_change_of_ownership_2022_12_30

455.94 KB
3625 rows
23 columns


CREATE TABLE skilled_nursing_facility_change_of_ownership_2022_12_30 (
  "enrollment_id_buyer" VARCHAR,
  "enrollment_state_buyer" VARCHAR,
  "provider_type_code_buyer" VARCHAR,
  "provider_type_text_buyer" VARCHAR,
  "npi_buyer" BIGINT,
  "multiple_npi_flag_buyer" VARCHAR,
  "ccn_buyer" VARCHAR,
  "associate_id_buyer" BIGINT,
  "organization_name_buyer" VARCHAR,
  "doing_business_as_name_buyer" VARCHAR,
  "chow_type_code" VARCHAR,
  "chow_type_text" VARCHAR,
  "effective_date" TIMESTAMP,
  "enrollment_id_seller" VARCHAR,
  "enrollment_state_seller" VARCHAR,
  "provider_type_code_seller" VARCHAR,
  "provider_type_text_seller" VARCHAR,
  "npi_seller" DOUBLE,
  "multiple_npi_flag_seller" VARCHAR,
  "ccn_seller" VARCHAR,
  "associate_id_seller" BIGINT,
  "organization_name_seller" VARCHAR,
  "doing_business_as_name_seller" VARCHAR
);

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership.skilled_nursing_facility_change_of_ownership_2022_09_30

441.16 KB
3499 rows
23 columns


CREATE TABLE skilled_nursing_facility_change_of_ownership_2022_09_30 (
  "enrollment_id_buyer" VARCHAR,
  "enrollment_state_buyer" VARCHAR,
  "provider_type_code_buyer" VARCHAR,
  "provider_type_text_buyer" VARCHAR,
  "npi_buyer" BIGINT,
  "multiple_npi_flag_buyer" VARCHAR,
  "ccn_buyer" VARCHAR,
  "associate_id_buyer" BIGINT,
  "organization_name_buyer" VARCHAR,
  "doing_business_as_name_buyer" VARCHAR,
  "chow_type_code" VARCHAR,
  "chow_type_text" VARCHAR,
  "effective_date" TIMESTAMP,
  "enrollment_id_seller" VARCHAR,
  "enrollment_state_seller" VARCHAR,
  "provider_type_code_seller" VARCHAR,
  "provider_type_text_seller" VARCHAR,
  "npi_seller" DOUBLE,
  "multiple_npi_flag_seller" VARCHAR,
  "ccn_seller" VARCHAR,
  "associate_id_seller" BIGINT,
  "organization_name_seller" VARCHAR,
  "doing_business_as_name_seller" VARCHAR
);

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership.skilled_nursing_facility_change_of_ownership_2022_06_30

424.4 KB
3367 rows
23 columns


CREATE TABLE skilled_nursing_facility_change_of_ownership_2022_06_30 (
  "enrollment_id_buyer" VARCHAR,
  "enrollment_state_buyer" VARCHAR,
  "provider_type_code_buyer" VARCHAR,
  "provider_type_text_buyer" VARCHAR,
  "npi_buyer" BIGINT,
  "multiple_npi_flag_buyer" VARCHAR,
  "ccn_buyer" VARCHAR,
  "associate_id_buyer" BIGINT,
  "organization_name_buyer" VARCHAR,
  "doing_business_as_name_buyer" VARCHAR,
  "chow_type_code" VARCHAR,
  "chow_type_text" VARCHAR,
  "effective_date" TIMESTAMP,
  "enrollment_id_seller" VARCHAR,
  "enrollment_state_seller" VARCHAR,
  "provider_type_code_seller" VARCHAR,
  "provider_type_text_seller" VARCHAR,
  "npi_seller" DOUBLE,
  "multiple_npi_flag_seller" VARCHAR,
  "ccn_seller" VARCHAR,
  "associate_id_seller" BIGINT,
  "organization_name_seller" VARCHAR,
  "doing_business_as_name_seller" VARCHAR
);

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

@usgov.hhs_gov_skilled_nursing_facility_change_of_ownership.skilled_nursing_facility_change_of_ownership_2022_03_31

412.09 KB
3267 rows
23 columns


CREATE TABLE skilled_nursing_facility_change_of_ownership_2022_03_31 (
  "enrollment_id_buyer" VARCHAR,
  "enrollment_state_buyer" VARCHAR,
  "provider_type_code_buyer" VARCHAR,
  "provider_type_text_buyer" VARCHAR,
  "npi_buyer" BIGINT,
  "multiple_npi_flag_buyer" VARCHAR,
  "ccn_buyer" VARCHAR,
  "associate_id_buyer" BIGINT,
  "organization_name_buyer" VARCHAR,
  "doing_business_as_name_buyer" VARCHAR,
  "chow_type_code" VARCHAR,
  "chow_type_text" VARCHAR,
  "effective_date" TIMESTAMP,
  "enrollment_id_seller" VARCHAR,
  "enrollment_state_seller" VARCHAR,
  "provider_type_code_seller" VARCHAR,
  "provider_type_text_seller" VARCHAR,
  "npi_seller" DOUBLE,
  "multiple_npi_flag_seller" VARCHAR,
  "ccn_seller" VARCHAR,
  "associate_id_seller" BIGINT,
  "organization_name_seller" VARCHAR,
  "doing_business_as_name_seller" VARCHAR
);