21  Facility Affiliations

This is the facility affiliations data publicly reported in the Provider Data Catalog.

Metadata

  [ROWS] 1563663 
 [PAGES] 782 
[FIELDS] 9 

Dictionary

npi
Unique clinician ID assigned by NPPES

ind_pac_id
Unique individual clinician ID assigned by PECOS

provider_last_name
Individual clinician last name

provider_first_name
Individual clinician first name

provider_middle_name
Individual clinician middle name

suff
Individual clinician suffix

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

facility_affiliations_certification_number
Medicare CCN of facility type or unit within
hospital where an individual clinician provides
service

facility_type_certification_number
Medicare CCN of the primary hospital where
individual clinician provides service, should the
clinician provide services in a unit within the
hospital

Data

obs: 2000 
cols: 9 

----- Categorical -----
             col n_missng p_complt n_unique n_levels
1            npi        0        1      925       NA
2     ind_pac_id        0        1      925       NA
3 providr_lst_nm        0        1      852       NA
4 provdr_frst_nm        0        1      614       NA
5 provdr_mddl_nm      708     0.65      137       NA
6           suff     1983   0.0085        4       NA
7  facility_type        0        1        7       NA
8 fclty_ffltns__        0        1     1428       NA
9 fclty_typ_crt_     1994    0.003        6       NA
                min          max
1        1003000126   1003083031
2        0042366981   9931384633
3      ABDELERAHMAN       ZITZKE
4             AAMIR          ZIA
5                 A            Z
6                II          SR.
7 Dialysis facility Nursing home
8            010001       B51745
9            131319       330241