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-10-23T10:04:47.063507
Tags: hospitals-facilities, medicare, outpatient-facilities, provider-enrollment, rural-health-clinics, rural-urban

Tables

Rural Health Clinic All Owners : 2025-10-01

@usgov.hhs_gov_rural_health_clinic_all_owners_b6ce5.rural_health_clinic_all_owners_2025_10_01

1.35 MB
63,291 rows
38 columns

CREATE TABLE rural_health_clinic_all_owners_2025_10_01 (
  "enrollment_id" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "associate_id_owner" BIGINT  -- ASSOCIATE ID - OWNER,
  "type_owner" VARCHAR  -- TYPE - OWNER,
  "role_code_owner" BIGINT  -- ROLE CODE - OWNER,
  "role_text_owner" VARCHAR  -- ROLE TEXT - OWNER,
  "association_date_owner" TIMESTAMP  -- ASSOCIATION DATE - OWNER,
  "first_name_owner" VARCHAR  -- FIRST NAME - OWNER,
  "middle_name_owner" VARCHAR  -- MIDDLE NAME - OWNER,
  "last_name_owner" VARCHAR  -- LAST NAME - OWNER,
  "title_owner" VARCHAR  -- TITLE - OWNER,
  "organization_name_owner" VARCHAR  -- ORGANIZATION NAME - OWNER,
  "doing_business_as_name_owner" VARCHAR  -- DOING BUSINESS AS NAME - OWNER,
  "address_line_1_owner" VARCHAR  -- ADDRESS LINE 1 - OWNER,
  "address_line_2_owner" VARCHAR  -- ADDRESS LINE 2 - OWNER,
  "city_owner" VARCHAR  -- CITY - OWNER,
  "state_owner" VARCHAR  -- STATE - OWNER,
  "zip_code_owner" DOUBLE  -- ZIP CODE - OWNER,
  "percentage_ownership" DOUBLE,
  "created_for_acquisition_owner" VARCHAR  -- CREATED FOR ACQUISITION - OWNER,
  "corporation_owner" VARCHAR  -- CORPORATION - OWNER,
  "llc_owner" VARCHAR  -- LLC - OWNER,
  "medical_provider_supplier_owner" VARCHAR  -- MEDICAL PROVIDER SUPPLIER - OWNER,
  "management_services_company_owner" VARCHAR  -- MANAGEMENT SERVICES COMPANY - OWNER,
  "medical_staffing_company_owner" VARCHAR  -- MEDICAL STAFFING COMPANY - OWNER,
  "holding_company_owner" VARCHAR  -- HOLDING COMPANY - OWNER,
  "investment_firm_owner" VARCHAR  -- INVESTMENT FIRM - OWNER,
  "financial_institution_owner" VARCHAR  -- FINANCIAL INSTITUTION - OWNER,
  "consulting_firm_owner" VARCHAR  -- CONSULTING FIRM - OWNER,
  "for_profit_owner" VARCHAR  -- FOR PROFIT - OWNER,
  "non_profit_owner" VARCHAR  -- NON PROFIT - OWNER,
  "private_equity_company_owner" VARCHAR  -- PRIVATE EQUITY COMPANY - OWNER,
  "reit_owner" VARCHAR  -- REIT - OWNER,
  "chain_home_office_owner" VARCHAR  -- CHAIN HOME OFFICE - OWNER,
  "other_type_owner" VARCHAR  -- OTHER TYPE - OWNER,
  "other_type_text_owner" VARCHAR  -- OTHER TYPE TEXT - OWNER,
  "owned_by_another_org_or_ind_owner" VARCHAR  -- OWNED BY ANOTHER ORG OR IND - OWNER
);