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-10-23T10:00:33.261478
Tags: hospitals-facilities, medicare, medicare-advantage, original-medicare, provider-enrollment

Tables

Hospital Change Of Ownership : 2022-03-31

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2022_03_31

74.05 kB
490 rows
23 columns

CREATE TABLE hospital_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" BIGINT  -- 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
);

Hospital Change Of Ownership : 2022-06-30

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2022_06_30

74.14 kB
489 rows
23 columns

CREATE TABLE hospital_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" BIGINT  -- 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
);

Hospital Change Of Ownership : 2022-09-30

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2022_09_30

74.04 kB
489 rows
23 columns

CREATE TABLE hospital_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" BIGINT  -- 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
);

Hospital Change Of Ownership : 2022-12-30

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2022_12_30

74.47 kB
492 rows
23 columns

CREATE TABLE hospital_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" BIGINT  -- 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
);

Hospital Change Of Ownership : 2023-03-31

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2023_03_31

74.26 kB
488 rows
23 columns

CREATE TABLE hospital_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" BIGINT  -- 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
);

Hospital Change Of Ownership : 2023-06-30

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2023_06_30

88.39 kB
630 rows
23 columns

CREATE TABLE hospital_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
);

Hospital Change Of Ownership : 2023-09-30

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2023_09_30

89.97 kB
642 rows
23 columns

CREATE TABLE hospital_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
);

Hospital Change Of Ownership : 2023-12-31

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2023_12_31

91.66 kB
655 rows
23 columns

CREATE TABLE hospital_change_of_ownership_2023_12_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
);

Hospital Change Of Ownership : 2024-03-31

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2024_03_31

93.18 kB
666 rows
23 columns

CREATE TABLE hospital_change_of_ownership_2024_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
);

Hospital Change Of Ownership : 2024-06-01

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2024_06_01

94.08 kB
676 rows
23 columns

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

Hospital Change Of Ownership : 2024-09-01

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2024_09_01

95.46 kB
690 rows
23 columns

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

Hospital Change Of Ownership : 2024-12-01

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2024_12_01

97.4 kB
707 rows
23 columns

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

Hospital Change Of Ownership : 2025-03-01

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2025_03_01

98.47 kB
715 rows
23 columns

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

Hospital Change Of Ownership : 2025-06-01

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2025_06_01

101.14 kB
741 rows
23 columns

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

Hospital Change Of Ownership : 2025-09-01

@usgov.hhs_gov_hospital_change_of_ownership_12e0e.hospital_change_of_ownership_2025_09_01

102.28 kB
749 rows
23 columns

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