About this Dataset

Hospital Enrollments

The Hospital Enrollments dataset provides enrollment information of all Hospitals currently enrolled in Medicare. This data includes information on the Hospital's sub-group type, legal business name, doing business as name, organization type and address.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-07-16T16:34:41.333480
Tags: hospitals-facilities, medicare, medicare-advantage, original-medicare, provider-enrollment

Tables

Hospital Enrollments : 2025-06-01

@usgov.hhs_gov_hospital_enrollments.hospital_enrollments_2025_06_01

782.22 KB
9244 rows
39 columns


CREATE TABLE hospital_enrollments_2025_06_01 (
  "enrollment_id" VARCHAR,
  "enrollment_state" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_text" VARCHAR,
  "npi" BIGINT,
  "multiple_npi_flag" VARCHAR,
  "ccn" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "incorporation_date" TIMESTAMP,
  "incorporation_state" VARCHAR,
  "organization_type_structure" VARCHAR,
  "organization_other_type_text" VARCHAR,
  "proprietary_nonprofit" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "practice_location_type" VARCHAR,
  "location_other_type_text" VARCHAR,
  "subgroup_general" VARCHAR,
  "subgroup_acute_care" VARCHAR,
  "subgroup_alcohol_drug" VARCHAR,
  "subgroup_childrens" VARCHAR,
  "subgroup_long_term" VARCHAR,
  "subgroup_psychiatric" VARCHAR,
  "subgroup_rehabilitation" VARCHAR,
  "subgroup_short_term" VARCHAR,
  "subgroup_swing_bed_approved" VARCHAR,
  "subgroup_psychiatric_unit" VARCHAR,
  "subgroup_rehabilitation_unit" VARCHAR,
  "subgroup_specialty_hospital" VARCHAR,
  "subgroup_other" VARCHAR,
  "subgroup_other_text" VARCHAR,
  "reh_conversion_flag" VARCHAR,
  "reh_conversion_date" TIMESTAMP,
  "cah_or_hospital_ccn" VARCHAR
);

Hospital Enrollments : 2025-07-01

@usgov.hhs_gov_hospital_enrollments.hospital_enrollments_2025_07_01

781.35 KB
9239 rows
39 columns


CREATE TABLE hospital_enrollments_2025_07_01 (
  "enrollment_id" VARCHAR,
  "enrollment_state" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_text" VARCHAR,
  "npi" BIGINT,
  "multiple_npi_flag" VARCHAR,
  "ccn" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "incorporation_date" TIMESTAMP,
  "incorporation_state" VARCHAR,
  "organization_type_structure" VARCHAR,
  "organization_other_type_text" VARCHAR,
  "proprietary_nonprofit" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "practice_location_type" VARCHAR,
  "location_other_type_text" VARCHAR,
  "subgroup_general" VARCHAR,
  "subgroup_acute_care" VARCHAR,
  "subgroup_alcohol_drug" VARCHAR,
  "subgroup_childrens" VARCHAR,
  "subgroup_long_term" VARCHAR,
  "subgroup_psychiatric" VARCHAR,
  "subgroup_rehabilitation" VARCHAR,
  "subgroup_short_term" VARCHAR,
  "subgroup_swing_bed_approved" VARCHAR,
  "subgroup_psychiatric_unit" VARCHAR,
  "subgroup_rehabilitation_unit" VARCHAR,
  "subgroup_specialty_hospital" VARCHAR,
  "subgroup_other" VARCHAR,
  "subgroup_other_text" VARCHAR,
  "reh_conversion_flag" VARCHAR,
  "reh_conversion_date" TIMESTAMP,
  "cah_or_hospital_ccn" VARCHAR
);