[ROWS] 5399
[PAGES] 2
[FIELDS] 20
[MODIFIED] 2025-01-15
[PERIODICITY] Quarterly [R/P3M]
[TEMPORAL] 2023-10-01 • 2025-03-31
[DICTIONARY] https://data.cms.gov/sites/default/files/2023-09/RHC_Enrollments_Data_Dictionary.pdf
[SITE] https://data.cms.gov/provider-characteristics/hospitals-and-other-facilities/rural-health-clinic-enrollments
[REFERENCES] https://data.cms.gov/sites/default/files/2024-10/RHC_Data_Guidance.pdf
[RESOURCES] https://data.cms.gov/data-api/v1/dataset-resources/3b7e7659-067e-41ea-8e36-f9ee2036e1f6
[DOWNLOAD] https://data.cms.gov/sites/default/files/2025-01/31a07f52-068f-4849-8731-aa0216554368/RHC_Enrollments_2025.01.02.csv
19 Rural Health Clinics
RHC Enrollments
The Rural Health Clinic (RHC) Enrollments dataset provides enrollment information on all RHCs currently enrolled in Medicare. This data includes information on the RHCs legal business name, doing business as name, organization type and address.
Metadata
Resources
[CSV] 1.14M 2025 RHC Enrollments Q1
<https://data.cms.gov/sites/default/files/2025-01/31a07f52-068f-4849-8731-aa0216554368/RHC_Enrollments_2025.01.02.csv>
[CSV] 3.66K 2025 RHC Additional NPIs Q1
<https://data.cms.gov/sites/default/files/2025-01/RHC_Additional_NPIs_2025.01.02.csv>
[CSV] 2.83K 2025 RHC Additional Addresses Q1
<https://data.cms.gov/sites/default/files/2025-01/RHC_Additional_Addresses_2025.01.02.csv>
[PDF] 480K 2025 RHC All Owners and Enrollments Data Guidance-2
<https://data.cms.gov/sites/default/files/2024-10/RHC_Data_Guidance.pdf>
[PDF] 336.09K 2025 RHC Enrollments Data Dictionary
<https://data.cms.gov/sites/default/files/2023-09/RHC_Enrollments_Data_Dictionary.pdf>
[ZIP] 1.41M 2025 RHC Change of Ownership (CHOW) Files Q1
<https://data.cms.gov/sites/default/files/2025-01/3ef36086-1ecf-4bf0-a064-8454f7ebac84/RHC_CHOW_2025.01.02.zip>
Dictionary
ENROLLMENT ID
RHC's enrollment ID.
ENROLLMENT STATE
RHC's enrollment state.
PROVIDER TYPE CODE
RHC's provider type code.
PROVIDER TYPE TEXT
RHC's provider type description.
NPI
RHC's NPI.
MULTIPLE NPI FLAG
Indicates if RHC has multiple NPIs.
CCN
RHC's CMS Certification Number (CCN), formerly
called an OSCAR Number.
ASSOCIATE ID
RHC's PECOS Associate Control (PAC) ID.
ORGANIZATION NAME
RHC's legal business name.
DOING BUSINESS AS NAME
RHC's doing-business-as name.
INCORPORATION DATE
Date RHC was incorporated.
INCORPORATION STATE
State RHC was incorporated.
ORGANIZATION TYPE STRUCTURE
RHC's organization type structure.
ORGANIZATION OTHER TYPE TEXT
Description of the organization structure if
OTHER.
PROPRIETARY_NONPROFIT
P if registered as proprietor with the IRS; N if
registered as non-profit.
ADDRESS LINE 1
Address line 1 of the RHC's practice location
address.
ADDRESS LINE 2
Address line 1 of the RHC's practice location
address.
CITY
City of the RHC's practice location address.
STATE
State of the RHC's practice location address.
ZIP CODE
Zip code of the RHC's practice location address.
Data
enroll_resp (5399 rows and 18 variables, 18 shown)
ID | Name | Type | Missings
---+------------+-----------+-------------
1 | enid | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+------------+-----------+-------------
2 | enid_state | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+------------+-----------+-------------
3 | prov_code | character | 0 (0.0%)
---+------------+-----------+-------------
4 | prov_desc | character | 0 (0.0%)
---+------------+-----------+-------------
5 | npi | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+------------+-----------+-------------
6 | multi_npi | integer | 0 (0.0%)
| | |
---+------------+-----------+-------------
7 | ccn | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+------------+-----------+-------------
8 | pac | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+------------+-----------+-------------
9 | org_name | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+------------+-----------+-------------
10 | dba_name | character | 964 (17.9%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+------------+-----------+-------------
11 | inc_date | date | 1374 (25.4%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+------------+-----------+-------------
12 | inc_state | character | 1328 (24.6%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+------------+-----------+-------------
13 | org_type | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+------------+-----------+-------------
14 | prop_non | character | 0 (0.0%)
| | |
| | |
---+------------+-----------+-------------
15 | city | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+------------+-----------+-------------
16 | state | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+------------+-----------+-------------
17 | zip | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+------------+-----------+-------------
18 | address | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
------------------------------------------
ID | Values | N
---+---------------------------------------+--------------
1 | O20020731000000 | 1 ( 0.0%)
| O20020813000023 | 1 ( 0.0%)
| O20020813000025 | 1 ( 0.0%)
| O20020814000001 | 1 ( 0.0%)
| O20020814000004 | 1 ( 0.0%)
| O20020815000017 | 1 ( 0.0%)
| O20020815000020 | 1 ( 0.0%)
| O20020819000008 | 1 ( 0.0%)
| O20020909000014 | 1 ( 0.0%)
| O20020911000010 | 1 ( 0.0%)
| (...) |
---+---------------------------------------+--------------
2 | AL | 148 ( 2.7%)
| AR | 166 ( 3.1%)
| AZ | 50 ( 0.9%)
| CA | 261 ( 4.8%)
| CO | 56 ( 1.0%)
| FL | 139 ( 2.6%)
| GA | 85 ( 1.6%)
| HI | 21 ( 0.4%)
| IA | 216 ( 4.0%)
| ID | 47 ( 0.9%)
| (...) |
---+---------------------------------------+--------------
3 | 00-17 | 5399 (100.0%)
---+---------------------------------------+--------------
4 | PART A PROVIDER - RURAL HEALTH CLINIC | 5399 (100.0%)
---+---------------------------------------+--------------
5 | 1003014952 | 1 ( 0.0%)
| 1003027442 | 1 ( 0.0%)
| 1003045113 | 1 ( 0.0%)
| 1003152430 | 1 ( 0.0%)
| 1003157603 | 1 ( 0.0%)
| 1003166117 | 1 ( 0.0%)
| 1003182601 | 1 ( 0.0%)
| 1003189606 | 1 ( 0.0%)
| 1003223306 | 1 ( 0.0%)
| 1003251802 | 1 ( 0.0%)
| (...) |
---+---------------------------------------+--------------
6 | 0 | 5296 ( 98.1%)
| 1 | 103 ( 1.9%)
---+---------------------------------------+--------------
7 | 013401 | 1 ( 0.0%)
| 013420 | 1 ( 0.0%)
| 013422 | 1 ( 0.0%)
| 013429 | 1 ( 0.0%)
| 013430 | 1 ( 0.0%)
| 013433 | 1 ( 0.0%)
| 013438 | 1 ( 0.0%)
| 013440 | 1 ( 0.0%)
| 013444 | 1 ( 0.0%)
| 013445 | 1 ( 0.0%)
| (...) |
---+---------------------------------------+--------------
8 | 0042101982 | 3 ( 0.1%)
| 0042105835 | 2 ( 0.0%)
| 0042118887 | 3 ( 0.1%)
| 0042127045 | 5 ( 0.1%)
| 0042127946 | 2 ( 0.0%)
| 0042128480 | 1 ( 0.0%)
| 0042129074 | 1 ( 0.0%)
| 0042129603 | 2 ( 0.0%)
| 0042200180 | 1 ( 0.0%)
| 0042203127 | 1 ( 0.0%)
| (...) |
---+---------------------------------------+--------------
9 | 1ST CHOICE URGENT CARE CENTER LLC | 1 ( 0.0%)
| A NEW START PRIMARY CARE LLC | 1 ( 0.0%)
| A PLUS MEDICAL OF RUSTON LLC | 1 ( 0.0%)
| A WOMAN'S PLACE, INC. | 1 ( 0.0%)
| A1 HEALTH CARE CLINIC | 1 ( 0.0%)
| AARON K. JONAN MEMORIAL CLINIC, INC. | 1 ( 0.0%)
| ABBEVILLE COUNTY MEMORIAL HOSPITAL | 2 ( 0.0%)
| ABBEVILLE GENERAL HOSPITAL | 3 ( 0.1%)
| ABERDEEN HEALTH CLINIC INC | 1 ( 0.0%)
| ABINGDON FAMILY HEALTHCARE INC | 1 ( 0.0%)
| (...) |
---+---------------------------------------+--------------
10 | 13TH STREET CLINIC | 1 ( 0.0%)
| 1ST CHOICE PRIMARY CARE | 1 ( 0.0%)
| A & M MEDICAL & DIAGNOSTIC | 1 ( 0.0%)
| A PLUS FAMILY CLINIC | 1 ( 0.0%)
| A+ PEDIATRICS | 1 ( 0.0%)
| ABBEVILLE AREA HEALTHCARE CENTER | 1 ( 0.0%)
| ABBEVILLE GENERAL HOSPITAL CLINIC | 1 ( 0.0%)
| ABC MEDICAL CLINIC OF HOLDENVILLE | 1 ( 0.0%)
| ABH BORGESS FAMILY MEDICINE | 1 ( 0.0%)
| AC RURAL HEALTH CLINIC | 1 ( 0.0%)
| (...) |
---+---------------------------------------+--------------
11 | 1859-01-28 | 4 ( 0.1%)
| 1873-10-29 | 1 ( 0.0%)
| 1874-04-29 | 5 ( 0.1%)
| 1880-01-02 | 23 ( 0.6%)
| 1883-09-26 | 1 ( 0.0%)
| 1885-12-09 | 2 ( 0.0%)
| 1888-09-26 | 2 ( 0.0%)
| 1889-02-11 | 1 ( 0.0%)
| 1894-03-23 | 5 ( 0.1%)
| 1894-11-26 | 3 ( 0.1%)
| (...) |
---+---------------------------------------+--------------
12 | AL | 103 ( 2.5%)
| AR | 139 ( 3.4%)
| AZ | 42 ( 1.0%)
| CA | 209 ( 5.1%)
| CO | 29 ( 0.7%)
| DE | 133 ( 3.3%)
| FL | 134 ( 3.3%)
| GA | 59 ( 1.4%)
| HI | 12 ( 0.3%)
| IA | 107 ( 2.6%)
| (...) |
---+---------------------------------------+--------------
13 | (COUNTY OWNED) | 1 ( 0.0%)
| (GOVERNMENT) | 1 ( 0.0%)
| (HOSPITAL DISTRICT) | 1 ( 0.0%)
| (PUBLIC AUTHORITY) | 1 ( 0.0%)
| (S CORPORATION) | 1 ( 0.0%)
| . | 1 ( 0.0%)
| 501 ( C) (3) | 1 ( 0.0%)
| 501 (C) (3) | 2 ( 0.0%)
| 501 (C) (3) GOVERNMENTAL ENTITY | 1 ( 0.0%)
| 501 (C) (3) NON-PROFIT CORPORATION | 1 ( 0.0%)
| (...) |
---+---------------------------------------+--------------
14 | D | 1 ( 0.0%)
| N | 3489 ( 64.6%)
| P | 1909 ( 35.4%)
---+---------------------------------------+--------------
15 | ABBEVILLE | 5 ( 0.1%)
| ABERDEEN | 6 ( 0.1%)
| ABERNATHY | 1 ( 0.0%)
| ABILENE | 1 ( 0.0%)
| ABINGDON | 2 ( 0.0%)
| ABSAROKEE | 1 ( 0.0%)
| ACKERMAN | 1 ( 0.0%)
| ADA | 3 ( 0.1%)
| ADAIR | 1 ( 0.0%)
| ADAMS | 2 ( 0.0%)
| (...) |
---+---------------------------------------+--------------
16 | AL | 148 ( 2.7%)
| AR | 156 ( 2.9%)
| AZ | 50 ( 0.9%)
| CA | 261 ( 4.8%)
| CO | 55 ( 1.0%)
| FL | 139 ( 2.6%)
| GA | 85 ( 1.6%)
| HI | 21 ( 0.4%)
| IA | 216 ( 4.0%)
| ID | 47 ( 0.9%)
| (...) |
---+---------------------------------------+--------------
17 | 012302148 | 1 ( 0.0%)
| 012472504 | 1 ( 0.0%)
| 012672930 | 1 ( 0.0%)
| 013313535 | 1 ( 0.0%)
| 013314901 | 1 ( 0.0%)
| 025542799 | 1 ( 0.0%)
| 025571406 | 1 ( 0.0%)
| 028077761 | 1 ( 0.0%)
| 032351259 | 1 ( 0.0%)
| 032641126 | 1 ( 0.0%)
| (...) |
---+---------------------------------------+--------------
18 | 1 CENTRE DRIVE | 1 ( 0.0%)
| 1 E WHALEN ST | 1 ( 0.0%)
| 1 HOSPITAL PLAZA | 1 ( 0.0%)
| 1 HOSPITAL RD | 1 ( 0.0%)
| 1 JACK FOSTER DR | 1 ( 0.0%)
| 1 KAMANI STREET | 1 ( 0.0%)
| 1 KWAN PLZ | 1 ( 0.0%)
| 1 LIBRARY LN 2 | 1 ( 0.0%)
| 1 MEDICAL CENTER DR | 1 ( 0.0%)
| 1 MEDICAL DR | 1 ( 0.0%)
| (...) |
----------------------------------------------------------
RHC 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.
Metadata
[ROWS] 62784
[PAGES] 13
[FIELDS] 34
[MODIFIED] 2025-01-15
[PERIODICITY] Quarterly [R/P3M]
[TEMPORAL] 2023-10-01 • 2025-03-31
[DICTIONARY] https://data.cms.gov/sites/default/files/2023-09/RHC_Enrollments_Data_Dictionary.pdf
[SITE] https://data.cms.gov/provider-characteristics/hospitals-and-other-facilities/rural-health-clinic-enrollments
[REFERENCES] https://data.cms.gov/sites/default/files/2024-10/RHC_Data_Guidance.pdf
[RESOURCES] https://data.cms.gov/data-api/v1/dataset-resources/3b7e7659-067e-41ea-8e36-f9ee2036e1f6
[DOWNLOAD] https://data.cms.gov/sites/default/files/2025-01/31a07f52-068f-4849-8731-aa0216554368/RHC_Enrollments_2025.01.02.csv
Resources
[CSV] 10M 2025 RHC All Owners Q1
<https://data.cms.gov/sites/default/files/2025-01/da02dffa-e26d-4c9c-85cb-3d8df1b98613/RHC_All_Owners_2025.01.02.csv>
[ZIP] 1.41M 2025 RHC Change of Ownership (CHOW) Files Q1
<https://data.cms.gov/sites/default/files/2025-01/3ef36086-1ecf-4bf0-a064-8454f7ebac84/RHC_CHOW_2025.01.02.zip>
[PDF] 480K 2024 RHC All Owners and Enrollments Data Guidance-2
<https://data.cms.gov/sites/default/files/2024-10/RHC_Data_Guidance.pdf>
[PDF] 350.79K 2024 RHC All Owners Data Dictionary Q4-Q1
<https://data.cms.gov/sites/default/files/2023-09/RHC_All_Owners_Data_Dictionary.pdf>
Dictionary
ENROLLMENT ID
RHC's enrollment ID.
ASSOCIATE ID
RHC's PECOS Associate Control (PAC) ID.
ORGANIZATION NAME
RHC's legal business name.
ASSOCIATE ID - OWNER
PAC ID of the Owner; an associate with ownership
or managing control interest in the RHC
enrollment.
TYPE - OWNER
Type of owner, I for individual and O for
organization.
ROLE CODE - OWNER
Owner's role code.
ROLE TEXT - OWNER
Description for Owner Role Code.
ASSOCIATION DATE - OWNER
Date owner became associated with the RHC.
FIRST NAME - OWNER
Individual owner's first name.
MIDDLE NAME - OWNER
Individual owner's middle name.
LAST NAME - OWNER
Individual owner's last name.
TITLE - OWNER
Individual owner's title.
ORGANIZATION NAME - OWNER
Organization owner's legal business name.
DOING BUSINESS AS NAME - OWNER
Organization owner's doing-business-as name.
ADDRESS LINE 1 - OWNER
Address line 1 of organization owner's mailing
address.
ADDRESS LINE 2 - OWNER
Address line 2 of organization owner's mailing
address.
CITY - OWNER
City of organization owner's mailing address.
STATE - OWNER
State of organization owner's mailing address.
ZIP CODE - OWNER
Zip code of organization owner's mailing address.
PERCENTAGE OWNERSHIP
Owner's ownership percentage in the RHC
enrollment.
CREATED FOR ACQUISITION - OWNER
Organization owner was solely created to acquire
the RHC and/or it's assets.
CORPORATION – OWNER
Owner's organization type is corporation.
LLC – OWNER
Owner's organization type is limited liability
company.
MEDICAL PROVIDER SUPPLIER – OWNER
Owner's organization type is medical
provider/supplier.
MANAGEMENT SERVICES COMPANY – OWNER
Owner's organization type is management services
company.
MEDICAL STAFFING COMPANY – OWNER
Owner's organization type is medical staffing
company.
HOLDING COMPANY – OWNER
Owner's organization type is holding company.
INVESTMENT FIRM – OWNER
Owner's organization type is investment firm.
FINANCIAL INSTITUTION – OWNER
Owner's organization type is bank or other
financial institution.
CONSULTING FIRM – OWNER
Owner's organization type is consulting firm.
FOR PROFIT – OWNER
Owner's organization type is for profit.
NON PROFIT – OWNER
Owner's organization type is non-profit.
OTHER TYPE – OWNER
Owner's organization type is not listed on the CMS
form.
OTHER TYPE TEXT – OWNER
Other type of owner's organization that is not
listed on the CMS form.
Data
owners_resp (10000 rows and 32 variables, 32 shown)
ID | Name | Type | Missings
---+-----------------+-------------+-------------
1 | enid | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
2 | pac | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
3 | org_name | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
4 | own_pac | character | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
5 | own_type | categorical | 0 (0.0%)
| | |
---+-----------------+-------------+-------------
6 | own_assoc_date | date | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
7 | own_first_name | character | 856 (8.6%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
8 | own_middle_name | character | 5620 (56.2%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
9 | own_last_name | character | 856 (8.6%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
10 | own_title | character | 3833 (38.3%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
11 | own_org_name | character | 9144 (91.4%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
12 | own_dba_name | character | 9415 (94.2%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
13 | own_city | character | 9145 (91.5%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
14 | own_state | character | 9145 (91.5%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
15 | own_zip | character | 9145 (91.5%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
16 | own_pct_owned | numeric | 7221 (72.2%)
---+-----------------+-------------+-------------
17 | is_acq | integer | 9628 (96.3%)
| | |
---+-----------------+-------------+-------------
18 | is_corp | integer | 9144 (91.4%)
| | |
---+-----------------+-------------+-------------
19 | is_llc | integer | 9144 (91.4%)
| | |
---+-----------------+-------------+-------------
20 | is_supp | integer | 9144 (91.4%)
| | |
---+-----------------+-------------+-------------
21 | is_mgmt | integer | 9144 (91.4%)
| | |
---+-----------------+-------------+-------------
22 | is_staff | integer | 9144 (91.4%)
| | |
---+-----------------+-------------+-------------
23 | is_hold | integer | 9144 (91.4%)
| | |
---+-----------------+-------------+-------------
24 | is_firm | integer | 9144 (91.4%)
| | |
---+-----------------+-------------+-------------
25 | is_bank | integer | 9144 (91.4%)
| | |
---+-----------------+-------------+-------------
26 | is_consult | integer | 9144 (91.4%)
---+-----------------+-------------+-------------
27 | is_forprof | integer | 9144 (91.4%)
| | |
---+-----------------+-------------+-------------
28 | is_nonprof | integer | 9144 (91.4%)
| | |
---+-----------------+-------------+-------------
29 | own_other_type | integer | 9144 (91.4%)
| | |
---+-----------------+-------------+-------------
30 | own_other_text | character | 9797 (98.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
31 | own_address | character | 9145 (91.5%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
---+-----------------+-------------+-------------
32 | own_role | categorical | 0 (0.0%)
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
-------------------------------------------------
ID | Values | N
---+------------------------------------------------+--------------
1 | O20020731000000 | 3 ( 0.0%)
| O20020813000023 | 13 ( 0.1%)
| O20020813000025 | 10 ( 0.1%)
| O20020814000001 | 12 ( 0.1%)
| O20020814000004 | 11 ( 0.1%)
| O20020815000017 | 19 ( 0.2%)
| O20020815000020 | 19 ( 0.2%)
| O20020819000008 | 17 ( 0.2%)
| O20020909000014 | 2 ( 0.0%)
| O20020911000010 | 12 ( 0.1%)
| (...) |
---+------------------------------------------------+--------------
2 | 0042101982 | 3 ( 0.0%)
| 0042127045 | 58 ( 0.6%)
| 0042127946 | 34 ( 0.3%)
| 0042129074 | 3 ( 0.0%)
| 0042129603 | 6 ( 0.1%)
| 0042200180 | 10 ( 0.1%)
| 0042208787 | 5 ( 0.0%)
| 0042228496 | 6 ( 0.1%)
| 0042233496 | 16 ( 0.2%)
| 0143130393 | 19 ( 0.2%)
| (...) |
---+------------------------------------------------+--------------
3 | AARON K. JONAN MEMORIAL CLINIC, INC. | 3 ( 0.0%)
| ABBEVILLE GENERAL HOSPITAL | 17 ( 0.2%)
| ABERDEEN HEALTH CLINIC INC | 3 ( 0.0%)
| ABINGDON FAMILY HEALTHCARE INC | 4 ( 0.0%)
| ACUTE CARE PEDIATRICS OF PALM COAST PA | 4 ( 0.0%)
| ACUTE CARE PEDIATRICS,PA | 4 ( 0.0%)
| ACV COMMUNITY SERVICES LLC | 5 ( 0.0%)
| ADAIR COUNTY MEMORIAL HOSPITAL | 20 ( 0.2%)
| ADAMS COUNTY HOSPITAL 2 | 14 ( 0.1%)
| ADVENTIST HEALTH CLEARLAKE HOSPITAL INC. | 42 ( 0.4%)
| (...) |
---+------------------------------------------------+--------------
4 | 0042101982 | 1 ( 0.0%)
| 0042108037 | 2 ( 0.0%)
| 0042116998 | 2 ( 0.0%)
| 0042119711 | 2 ( 0.0%)
| 0042128506 | 2 ( 0.0%)
| 0042129611 | 4 ( 0.0%)
| 0042200180 | 1 ( 0.0%)
| 0042206203 | 9 ( 0.1%)
| 0042208787 | 1 ( 0.0%)
| 0042233496 | 2 ( 0.0%)
| (...) |
---+------------------------------------------------+--------------
5 | I | 9144 ( 91.4%)
| O | 856 ( 8.6%)
---+------------------------------------------------+--------------
6 | 1901-01-01 | 1 ( 0.0%)
| 1904-09-28 | 1 ( 0.0%)
| 1954-01-29 | 1 ( 0.0%)
| 1955-07-30 | 1 ( 0.0%)
| 1957-10-23 | 1 ( 0.0%)
| 1962-01-01 | 4 ( 0.0%)
| 1966-01-01 | 25 ( 0.2%)
| 1966-04-14 | 1 ( 0.0%)
| 1966-04-24 | 1 ( 0.0%)
| 1966-07-01 | 2 ( 0.0%)
| (...) |
---+------------------------------------------------+--------------
7 | A | 4 ( 0.0%)
| AARICK | 2 ( 0.0%)
| AARON | 13 ( 0.1%)
| ABBIE | 1 ( 0.0%)
| ABBY | 2 ( 0.0%)
| ABDUL | 1 ( 0.0%)
| ABELARDO | 2 ( 0.0%)
| ABIGAIL | 7 ( 0.1%)
| ADA | 3 ( 0.0%)
| ADAM | 8 ( 0.1%)
| (...) |
---+------------------------------------------------+--------------
8 | ` | 3 ( 0.1%)
| A | 405 ( 9.2%)
| A. | 22 ( 0.5%)
| AARON | 1 ( 0.0%)
| ADAM | 1 ( 0.0%)
| ALAN | 17 ( 0.4%)
| ALBERT | 4 ( 0.1%)
| ALI | 1 ( 0.0%)
| ALLEN | 14 ( 0.3%)
| ALVIN | 5 ( 0.1%)
| (...) |
---+------------------------------------------------+--------------
9 | AAGARD | 2 ( 0.0%)
| ABBASSI | 1 ( 0.0%)
| ABDALLA | 8 ( 0.1%)
| ABDULLAH | 4 ( 0.0%)
| ABEL | 12 ( 0.1%)
| ABENDROTH | 4 ( 0.0%)
| ABOULEISH | 2 ( 0.0%)
| ABRUTZ | 2 ( 0.0%)
| ABSHIRE | 1 ( 0.0%)
| ACOB | 2 ( 0.0%)
| (...) |
---+------------------------------------------------+--------------
10 | 0 | 1 ( 0.0%)
| 05/01/2017 | 1 ( 0.0%)
| 100 | 1 ( 0.0%)
| 33.33 | 1 ( 0.0%)
| ACCOUNTANT | 1 ( 0.0%)
| ACO/VNS DIRECTOR | 1 ( 0.0%)
| ACTION CEO | 1 ( 0.0%)
| AD; | 16 ( 0.3%)
| AD;CFO | 1 ( 0.0%)
| AD;CHIEF EXECUTIVE OFFICER | 1 ( 0.0%)
| (...) |
---+------------------------------------------------+--------------
11 | ACV COMMUNITY SERVICES LLC | 1 ( 0.1%)
| ADAMS COUNTY HOSPITAL 2 | 3 ( 0.4%)
| ADVENTIST HEALTH DELANO | 1 ( 0.1%)
| ADVENTIST HEALTH SYSTEM/WEST | 6 ( 0.7%)
| ALEGENT CREIGHTON HEALTH | 6 ( 0.7%)
| ALEGENT HEALTH IMMANUEL MEDICAL CENTER | 2 ( 0.2%)
| ALLEN PARISH HOSPITAL DISTRICT NO 3 | 1 ( 0.1%)
| AMERICAN HOSPITAL MANAGEMENT CORPORATION | 1 ( 0.1%)
| AMITE COUNTY, BOARD OF SUPERVISORS | 1 ( 0.1%)
| ARTESIA GENERAL HOSPITAL | 1 ( 0.1%)
| (...) |
---+------------------------------------------------+--------------
12 | A C RURAL HEALTH CLINIC | 1 ( 0.2%)
| ADVENTIST HEALTH | 6 ( 1.0%)
| ADVENTIST HEALTH LODI MEMORIAL | 1 ( 0.2%)
| ADVENTR CHRISTIAN VILLAGE HOME CARE AGENCY | 1 ( 0.2%)
| AKRON CLINIC | 2 ( 0.3%)
| ALLEN PARISH HOSPITAL RURAL HEALTH CLINIC | 1 ( 0.2%)
| ALVIS F. JOHNSON HOME HEALTH AND HOSPICE | 1 ( 0.2%)
| AMPLIFY REVENUE CYCLE MANAGEMENT | 3 ( 0.5%)
| APERION CARE LINCOLN | 3 ( 0.5%)
| ARBOR HEALTH PACKWOOD CLINIC | 1 ( 0.2%)
| (...) |
---+------------------------------------------------+--------------
13 | ALBANY | 1 ( 0.1%)
| ALLIANCE | 2 ( 0.2%)
| ALMA | 2 ( 0.2%)
| AMERY | 1 ( 0.1%)
| ANACORTES | 1 ( 0.1%)
| ANTHONY | 1 ( 0.1%)
| APPLETON CITY | 1 ( 0.1%)
| ARCATA | 1 ( 0.1%)
| ARCO | 2 ( 0.2%)
| ARTESIA | 1 ( 0.1%)
| (...) |
---+------------------------------------------------+--------------
14 | AL | 7 ( 0.8%)
| AR | 18 ( 2.1%)
| AZ | 5 ( 0.6%)
| CA | 40 ( 4.7%)
| CO | 22 ( 2.6%)
| FL | 11 ( 1.3%)
| GA | 10 ( 1.2%)
| HI | 2 ( 0.2%)
| IA | 52 ( 6.1%)
| ID | 12 ( 1.4%)
| (...) |
---+------------------------------------------------+--------------
15 | 035983343 | 3 ( 0.4%)
| 044121005 | 2 ( 0.2%)
| 100052500 | 8 ( 0.9%)
| 100192700 | 3 ( 0.4%)
| 10022 | 6 ( 0.7%)
| 101110204 | 4 ( 0.5%)
| 153013336 | 1 ( 0.1%)
| 184311445 | 1 ( 0.1%)
| 226012808 | 2 ( 0.2%)
| 226012889 | 2 ( 0.2%)
| (...) |
---+------------------------------------------------+--------------
16 | [0, 1] | 2779
---+------------------------------------------------+--------------
17 | 0 | 357 ( 96.0%)
| 1 | 15 ( 4.0%)
---+------------------------------------------------+--------------
18 | 0 | 630 ( 73.6%)
| 1 | 226 ( 26.4%)
---+------------------------------------------------+--------------
19 | 0 | 800 ( 93.5%)
| 1 | 56 ( 6.5%)
---+------------------------------------------------+--------------
20 | 0 | 851 ( 99.4%)
| 1 | 5 ( 0.6%)
---+------------------------------------------------+--------------
21 | 0 | 833 ( 97.3%)
| 1 | 23 ( 2.7%)
---+------------------------------------------------+--------------
22 | 0 | 855 ( 99.9%)
| 1 | 1 ( 0.1%)
---+------------------------------------------------+--------------
23 | 0 | 825 ( 96.4%)
| 1 | 31 ( 3.6%)
---+------------------------------------------------+--------------
24 | 0 | 851 ( 99.4%)
| 1 | 5 ( 0.6%)
---+------------------------------------------------+--------------
25 | 0 | 849 ( 99.2%)
| 1 | 7 ( 0.8%)
---+------------------------------------------------+--------------
26 | 0 | 856 (100.0%)
---+------------------------------------------------+--------------
27 | 0 | 768 ( 89.7%)
| 1 | 88 ( 10.3%)
---+------------------------------------------------+--------------
28 | 0 | 483 ( 56.4%)
| 1 | 373 ( 43.6%)
---+------------------------------------------------+--------------
29 | 0 | 653 ( 76.3%)
| 1 | 203 ( 23.7%)
---+------------------------------------------------+--------------
30 | ( LOCAL GOVERNMENTAL AGENCY) | 1 ( 0.5%)
| (501(C)(3)HEALTH SYSTEM) | 1 ( 0.5%)
| . | 1 ( 0.5%)
| 501 (C) | 2 ( 1.0%)
| 501(3)(C) | 2 ( 1.0%)
| 501(C) | 1 ( 0.5%)
| 501(C)(3) | 1 ( 0.5%)
| BOARD OF DIRECTORS | 1 ( 0.5%)
| CA HEALTH CARE DISTRICT | 1 ( 0.5%)
| CAH HOSPITAL | 1 ( 0.5%)
| (...) |
---+------------------------------------------------+--------------
31 | 1 ADVENTIST HEALTH WAY | 5 ( 0.6%)
| 1 ADVENTIST WAY | 1 ( 0.1%)
| 1 MCLAREN PKWY | 1 ( 0.1%)
| 1 PARK PLZ | 12 ( 1.4%)
| 1 WALL ST | 8 ( 0.9%)
| 10 KRUGER RD | 1 ( 0.1%)
| 100 FALLS CANYON ROAD | 1 ( 0.1%)
| 100 MICHIGAN ST NE | 4 ( 0.5%)
| 100 NORTH TRYON STREET | 3 ( 0.4%)
| 100 PIONEERS MEDICAL CENTER DR | 1 ( 0.1%)
| (...) |
---+------------------------------------------------+--------------
32 | [25] CONTRACTED MANAGING EMPLOYEE | 89 ( 0.9%)
| [34] 5% OR GREATER DIRECT OWNERSHIP INTEREST | 703 ( 7.0%)
| [35] 5% OR GREATER INDIRECT OWNERSHIP INTEREST | 148 ( 1.5%)
| [36] 5% OR GREATER MORTGAGE INTEREST | 19 ( 0.2%)
| [37] 5% OR GREATER SECURITY INTEREST | 7 ( 0.1%)
| [38] GENERAL PARTNERSHIP INTEREST | 74 ( 0.7%)
| [39] LIMITED PARTNERSHIP INTEREST | 3 ( 0.0%)
| [40] CORPORATE OFFICER | 1818 ( 18.2%)
| [41] CORPORATE DIRECTOR | 4416 ( 44.2%)
| [42] W-2 MANAGING EMPLOYEE | 1575 ( 15.8%)
| (...) |
-------------------------------------------------------------------
Join
left join: owners_resp[enid, pac, org_name] 10000/10000 (100%) <10.93:1st> enroll_resp[enid, pac, org_name] 915/5399 (16.9%)
tibble [10,000 × 47] (S3: tbl_df/tbl/data.frame)
$ enid : chr [1:10000] "O20020731000000" "O20020731000000" "O20020731000000" "O20020813000023" ...
$ pac : chr [1:10000] "0941117907" "0941117907" "0941117907" "0042127045" ...
$ org_name : chr [1:10000] "PALOUSE HEALTH CENTER PS" "PALOUSE HEALTH CENTER PS" "PALOUSE HEALTH CENTER PS" "WEST RIVER HEALTH SERVICES" ...
$ own_pac : chr [1:10000] "1850208810" "1850208810" "7416196431" "0244355691" ...
$ own_type : Factor w/ 2 levels "I","O": 1 1 1 1 1 1 1 1 1 1 ...
$ own_assoc_date : Date[1:10000], format: "2000-03-21" "2000-03-21" ...
$ own_first_name : chr [1:10000] "SANDRA" "SANDRA" "WENDY" "LARRY" ...
$ own_middle_name: chr [1:10000] "K" "K" "M" NA ...
$ own_last_name : chr [1:10000] "SCHORZMAN" "SCHORZMAN" "GRIFFIN" "JACKSON" ...
$ own_title : chr [1:10000] "PRESIDENT" "PRESIDENT" "OFFICE MANAGER" NA ...
$ own_org_name : chr [1:10000] NA NA NA NA ...
$ own_dba_name : chr [1:10000] NA NA NA NA ...
$ own_city : chr [1:10000] NA NA NA NA ...
$ own_state : chr [1:10000] NA NA NA NA ...
$ own_zip : chr [1:10000] NA NA NA NA ...
$ own_pct_owned : num [1:10000] 0.5 NA NA NA NA NA NA NA NA NA ...
$ is_acq : int [1:10000] NA NA NA NA NA NA NA NA NA NA ...
$ is_corp : int [1:10000] NA NA NA NA NA NA NA NA NA NA ...
$ is_llc : int [1:10000] NA NA NA NA NA NA NA NA NA NA ...
$ is_supp : int [1:10000] NA NA NA NA NA NA NA NA NA NA ...
$ is_mgmt : int [1:10000] NA NA NA NA NA NA NA NA NA NA ...
$ is_staff : int [1:10000] NA NA NA NA NA NA NA NA NA NA ...
$ is_hold : int [1:10000] NA NA NA NA NA NA NA NA NA NA ...
$ is_firm : int [1:10000] NA NA NA NA NA NA NA NA NA NA ...
$ is_bank : int [1:10000] NA NA NA NA NA NA NA NA NA NA ...
$ is_consult : int [1:10000] NA NA NA NA NA NA NA NA NA NA ...
$ is_forprof : int [1:10000] NA NA NA NA NA NA NA NA NA NA ...
$ is_nonprof : int [1:10000] NA NA NA NA NA NA NA NA NA NA ...
$ own_other_type : int [1:10000] NA NA NA NA NA NA NA NA NA NA ...
$ own_other_text : chr [1:10000] NA NA NA NA ...
$ own_address : chr [1:10000] NA NA NA NA ...
$ own_role : Factor w/ 12 levels "[25] CONTRACTED MANAGING EMPLOYEE",..: 2 8 10 9 8 10 9 8 10 9 ...
$ enid_state : chr [1:10000] "WA" "WA" "WA" "ND" ...
$ prov_code : chr [1:10000] "00-17" "00-17" "00-17" "00-17" ...
$ prov_desc : chr [1:10000] "PART A PROVIDER - RURAL HEALTH CLINIC" "PART A PROVIDER - RURAL HEALTH CLINIC" "PART A PROVIDER - RURAL HEALTH CLINIC" "PART A PROVIDER - RURAL HEALTH CLINIC" ...
$ npi : chr [1:10000] "1508861386" "1508861386" "1508861386" "1497856025" ...
$ multi_npi : int [1:10000] 0 0 0 0 0 0 0 0 0 0 ...
$ ccn : chr [1:10000] "503883" "503883" "503883" "353982" ...
$ dba_name : chr [1:10000] "PALOUSE HEALTH CENTER" "PALOUSE HEALTH CENTER" "PALOUSE HEALTH CENTER" "BOWMAN CLINIC" ...
$ inc_date : Date[1:10000], format: "2000-03-21" "2000-03-21" ...
$ inc_state : chr [1:10000] "WA" "WA" "WA" "ND" ...
$ org_type : chr [1:10000] "CORPORATION" "CORPORATION" "CORPORATION" "CORPORATION" ...
$ prop_non : chr [1:10000] "P" "P" "P" "N" ...
$ city : chr [1:10000] "PALOUSE" "PALOUSE" "PALOUSE" "BOWMAN" ...
$ state : chr [1:10000] "WA" "WA" "WA" "ND" ...
$ zip : chr [1:10000] "99161" "99161" "99161" "586234507" ...
$ address : chr [1:10000] "235 E MAIN ST" "235 E MAIN ST" "235 E MAIN ST" "608 HIGHWAY 12 WEST" ...
RHC Change of Ownership (CHOW)
# A tibble: 413 × 23
enid_buyer enid_state_buyer prov_code_buyer prov_text_buyer npi_buyer
, ccn_buyer , pac_buyer ,
# org_name_buyer , dba_buyer , chow_code , chow_text ,
# effective_date , enid_seller , enid_state_seller ,
# prov_code_seller , prov_text_seller , npi_seller ,
# multi_npi_seller , ccn_seller , pac_seller ,
# org_name_seller , dba_seller