About this Dataset

Rural Health Clinic All Owners

The Rural Health Clinic (RHC) All Owners dataset provides ownership information on all RHCs currently enrolled in Medicare. This data includes ownership information such as ownership name, ownership type, ownership address and ownership effective date.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-07-16T16:36:45.099014
Tags: hospitals-facilities, medicare, outpatient-facilities, provider-enrollment, rural-health-clinics

Tables

Rural Health Clinic All Owners : 2025-07-01

@usgov.hhs_gov_rural_health_clinic_all_owners.rural_health_clinic_all_owners_2025_07_01

1.29 MB
63088 rows
38 columns


CREATE TABLE rural_health_clinic_all_owners_2025_07_01 (
  "enrollment_id" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "associate_id_owner" BIGINT,
  "type_owner" VARCHAR,
  "role_code_owner" BIGINT,
  "role_text_owner" VARCHAR,
  "association_date_owner" TIMESTAMP,
  "first_name_owner" VARCHAR,
  "middle_name_owner" VARCHAR,
  "last_name_owner" VARCHAR,
  "title_owner" VARCHAR,
  "organization_name_owner" VARCHAR,
  "doing_business_as_name_owner" VARCHAR,
  "address_line_1_owner" VARCHAR,
  "address_line_2_owner" VARCHAR,
  "city_owner" VARCHAR,
  "state_owner" VARCHAR,
  "zip_code_owner" DOUBLE,
  "percentage_ownership" DOUBLE,
  "created_for_acquisition_owner" VARCHAR,
  "corporation_owner" VARCHAR,
  "llc_owner" VARCHAR,
  "medical_provider_supplier_owner" VARCHAR,
  "management_services_company_owner" VARCHAR,
  "medical_staffing_company_owner" VARCHAR,
  "holding_company_owner" VARCHAR,
  "investment_firm_owner" VARCHAR,
  "financial_institution_owner" VARCHAR,
  "consulting_firm_owner" VARCHAR,
  "for_profit_owner" VARCHAR,
  "non_profit_owner" VARCHAR,
  "private_equity_company_owner" VARCHAR,
  "reit_owner" VARCHAR,
  "chain_home_office_owner" VARCHAR,
  "other_type_owner" VARCHAR,
  "other_type_text_owner" VARCHAR,
  "owned_by_another_org_or_ind_owner" VARCHAR
);