About this Dataset

Hospital Change Of Ownership

The Hospital Change of Ownership (CHOW) dataset provides information on the hospital 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-07-16T16:34:47.180281
Tags: hospitals-facilities, medicare, medicare-advantage, original-medicare, provider-enrollment

Tables

Hospital Change Of Ownership : 2025-06-01

@usgov.hhs_gov_hospital_change_of_ownership.hospital_change_of_ownership_2025_06_01

98.76 KB
741 rows
23 columns


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