Skip to contents


Facility affiliations data publicly reported in the Provider Data Catalog.


Search Examples

facility_affiliations(npi = 1003019563)
#> # A tibble: 4 × 7
#>   npi     pac_id_ind first_name middle_name last_name facility_type facility_ccn
#>   <chr>   <chr>      <chr>      <chr>       <chr>     <chr>         <chr>       
#> 1 100301… 4688707060 JOHN       JOSEPH      FRANK     Hospital      060116      
#> 2 100301… 4688707060 JOHN       JOSEPH      FRANK     Hospital      060009      
#> 3 100301… 4688707060 JOHN       JOSEPH      FRANK     Hospital      060028      
#> 4 100301… 4688707060 JOHN       JOSEPH      FRANK     Hospital      060004


facility_affiliations(parent_ccn = 670055)
#> # A tibble: 9 × 8
#>   npi     pac_id_ind first_name middle_name last_name facility_type facility_ccn
#>   <chr>   <chr>      <chr>      <chr>       <chr>     <chr>         <chr>       
#> 1 108374… 5698833655 RAFAEL     JORGE       FORNARIS  Inpatient re… 67T055      
#> 2 114442… 3577659580 LYSA       LEE         CURRY     Inpatient re… 67T055      
#> 3 155859… 8921241142 JOHN       D           ALFONSO   Inpatient re… 67T055      
#> 4 161923… 5597044024 FELIX      MARIA       RODRIGUE… Inpatient re… 67T055      
#> 5 171011… 9739337122 VIDYA      NA          AMARANENI Inpatient re… 67T055      
#> 6 172006… 7012947229 WILLIAM    WARREN      JANES     Inpatient re… 67T055      
#> 7 174057… 0345473773 GEOFF      R           WEIKLE    Inpatient re… 67T055      
#> 8 177086… 5193940997 AUSTON     J           MYERS     Inpatient re… 67T055      
#> 9 191226… 5092036509 SAAD       MD          MANSOOR   Inpatient re… 67T055      
#> # ℹ 1 more variable: parent_ccn <chr>


facility_affiliations(first_name = "John", 
                      last_name = "Hill", 
                      facility_type = "Home Health Agency")
#> # A tibble: 9 × 8
#>   npi        pac_id_ind first_name middle_name last_name suffix facility_type   
#>   <chr>      <chr>      <chr>      <chr>       <chr>     <chr>  <chr>           
#> 1 1174587588 7214998079 JOHN       C           HILL      III    Home health age…
#> 2 1174587588 7214998079 JOHN       C           HILL      III    Home health age…
#> 3 1174587588 7214998079 JOHN       C           HILL      III    Home health age…
#> 4 1174587588 7214998079 JOHN       C           HILL      III    Home health age…
#> 5 1558380444 4789619362 JOHN       M           HILL      NA     Home health age…
#> 6 1558380444 4789619362 JOHN       M           HILL      NA     Home health age…
#> 7 1558380444 4789619362 JOHN       M           HILL      NA     Home health age…
#> 8 1558380444 4789619362 JOHN       M           HILL      NA     Home health age…
#> 9 1558380444 4789619362 JOHN       M           HILL      NA     Home health age…
#> # ℹ 1 more variable: facility_ccn <chr>



Data Dictionary

Variable Description

npi

National Provider Identifier
Unique clinician ID assigned by NPPES.

pac_id

Provider Associate Level ID (PAC ID)
Unique individual clinician ID assigned by PECOS.

first_name

First Name
Individual clinician first name.

middle_name

Middle Name
Individual clinician middle name.

last_name

Last Name
Individual clinician last name.

suffix

Suffix
Individual clinician suffix.

facility_type

Facility Type
Facilities can fall into the following type categories: Hospital, Long-term Care Hospital, Nursing Home, Inpatient Rehabilitation Facility, Home Health Agency, Hospice, and Dialysis Facility.

facility_ccn

Facility Affiliations CCN
Medicare CCN of facility type or unit within hospital where an individual clinician provides service.

parent_ccn

Facility Affiliations Parent CCN
Medicare CCN of the primary hospital where individual clinician provides service, should the clinician provide services in a unit within the hospital.