About this Dataset

Rural Health Clinic Enrollments

The Rural Health Clinic (RHC) Enrollments dataset provides enrollment information on all RHCs currently enrolled in Medicare. This data includes information on the RHC's 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:35.089607
Tags: hospitals-facilities, medicare, outpatient-facilities, provider-enrollment, rural-health-clinics

Tables

Rural Health Clinic Enrollments : 2025-07-01

@usgov.hhs_gov_rural_health_clinic_enrollments.rural_health_clinic_enrollments_2025_07_01

471.54 KB
5448 rows
20 columns


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