Baselight
Sign In

Rural Health Clinic Enrollments

U.S. Department of Health & Human Services

@usgov.hhs_gov_rural_health_clinic_enrollments_05b34

Loading...
Loading...

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-10-07T07:17:45.141588
Tags: hospitals-facilities, medicare, outpatient-facilities, provider-enrollment, rural-health-clinics, rural-urban

Tables

Rural Health Clinic Enrollments : 2023-10-29

@usgov.hhs_gov_rural_health_clinic_enrollments_05b34.rural_health_clinic_enrollments_2023_10_29
  • 464.58 kB
  • 5,189 rows
  • 20 columns
Loading... 
CREATE TABLE rural_health_clinic_enrollments_2023_10_29 (
  "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
);

Rural Health Clinic Enrollments : 2024-01-05

@usgov.hhs_gov_rural_health_clinic_enrollments_05b34.rural_health_clinic_enrollments_2024_01_05
  • 468.13 kB
  • 5,235 rows
  • 20 columns
Loading... 
CREATE TABLE rural_health_clinic_enrollments_2024_01_05 (
  "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
);

Rural Health Clinic Enrollments : 2024-04-01

@usgov.hhs_gov_rural_health_clinic_enrollments_05b34.rural_health_clinic_enrollments_2024_04_01
  • 473.07 kB
  • 5,307 rows
  • 20 columns
Loading... 
CREATE TABLE rural_health_clinic_enrollments_2024_04_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
);

Rural Health Clinic Enrollments : 2024-07-01

@usgov.hhs_gov_rural_health_clinic_enrollments_05b34.rural_health_clinic_enrollments_2024_07_01
  • 477.7 kB
  • 5,369 rows
  • 20 columns
Loading... 
CREATE TABLE rural_health_clinic_enrollments_2024_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
);

Rural Health Clinic Enrollments : 2024-10-01

@usgov.hhs_gov_rural_health_clinic_enrollments_05b34.rural_health_clinic_enrollments_2024_10_01
  • 476.85 kB
  • 5,361 rows
  • 20 columns
Loading... 
CREATE TABLE rural_health_clinic_enrollments_2024_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
);

Rural Health Clinic Enrollments : 2025-01-01

@usgov.hhs_gov_rural_health_clinic_enrollments_05b34.rural_health_clinic_enrollments_2025_01_01
  • 479.92 kB
  • 5,399 rows
  • 20 columns
Loading... 
CREATE TABLE rural_health_clinic_enrollments_2025_01_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
);

Rural Health Clinic Enrollments : 2025-04-01

@usgov.hhs_gov_rural_health_clinic_enrollments_05b34.rural_health_clinic_enrollments_2025_04_01
  • 481.61 kB
  • 5,425 rows
  • 20 columns
Loading... 
CREATE TABLE rural_health_clinic_enrollments_2025_04_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
);

Rural Health Clinic Enrollments : 2025-07-01

@usgov.hhs_gov_rural_health_clinic_enrollments_05b34.rural_health_clinic_enrollments_2025_07_01
  • 482.86 kB
  • 5,448 rows
  • 20 columns
Loading... 
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
);

Share link

Anyone who has the link will be able to view this.