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

Tables

Hospital Enrollments : 2025-10-01

@usgov.hhs_gov_hospital_enrollments_76dd9.hospital_enrollments_2025_10_01

796.65 kB
9,217 rows
39 columns

CREATE TABLE hospital_enrollments_2025_10_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 - GENERAL,
  "subgroup_acute_care" VARCHAR  -- SUBGROUP - ACUTE CARE,
  "subgroup_alcohol_drug" VARCHAR  -- SUBGROUP - ALCOHOL DRUG,
  "subgroup_childrens" VARCHAR  -- SUBGROUP - CHILDRENS,
  "subgroup_long_term" VARCHAR  -- SUBGROUP - LONG-TERM,
  "subgroup_psychiatric" VARCHAR  -- SUBGROUP - PSYCHIATRIC,
  "subgroup_rehabilitation" VARCHAR  -- SUBGROUP - REHABILITATION,
  "subgroup_short_term" VARCHAR  -- SUBGROUP - SHORT-TERM,
  "subgroup_swing_bed_approved" VARCHAR  -- SUBGROUP - SWING-BED APPROVED,
  "subgroup_psychiatric_unit" VARCHAR  -- SUBGROUP - PSYCHIATRIC UNIT,
  "subgroup_rehabilitation_unit" VARCHAR  -- SUBGROUP - REHABILITATION UNIT,
  "subgroup_specialty_hospital" VARCHAR  -- SUBGROUP - SPECIALTY HOSPITAL,
  "subgroup_other" VARCHAR  -- SUBGROUP - OTHER,
  "subgroup_other_text" VARCHAR  -- SUBGROUP - OTHER TEXT,
  "reh_conversion_flag" VARCHAR,
  "reh_conversion_date" TIMESTAMP,
  "cah_or_hospital_ccn" VARCHAR
);