[ROWS] 1557102
[PAGES] 779
[FIELDS] 9
[ISSUED] 2023-08-17
[MODIFIED] 2025-04-18
[RELEASED] 2025-05-01
[DICTIONARY] https://data.cms.gov/provider-data/dataset/27ea-46a8#data-dictionary
[SITE] https://data.cms.gov/provider-data/dataset/27ea-46a8
[DOWNLOAD] https://data.cms.gov/provider-data/sites/default/files/resources/b7c4080ae144663e43353a9c35cd3f53_1744999531/Facility_Affiliation.csv
20 Facility Affiliations
This is the facility affiliations data publicly reported in the Provider Data Catalog.
Metadata
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
Dataset: resp, 9 Variables, N = 2000
--------------------------------------------------------------------------------
npi (character):
Statistics
N Ndist
2000 929
Table
Freq Perc
1003053653 19 0.95
1003012931 11 0.55
1003078254 11 0.55
1003053851 10 0.50
1003059403 10 0.50
1003052739 9 0.45
1003077421 9 0.45
1003023581 8 0.40
1003055021 8 0.40
1003077702 8 0.40
1003079583 8 0.40
1003042490 7 0.35
1003062647 7 0.35
1003074006 7 0.35
... 915 Others 1868 93.40
Summary of Table Frequencies
Min. 1st Qu. Median Mean 3rd Qu. Max.
1.0 1.0 2.0 2.1 3.0 19.0
--------------------------------------------------------------------------------
ind_pac_id (character):
Statistics
N Ndist
2000 929
Table
Freq Perc
5193874584 19 0.95
3577651264 11 0.55
0840321741 11 0.55
1658567524 10 0.50
0042469520 10 0.50
3678799483 9 0.45
3072670348 9 0.45
0345385589 8 0.40
0941353007 8 0.40
0547316218 8 0.40
3072781806 8 0.40
9234308388 7 0.35
1456412451 7 0.35
9931379070 7 0.35
... 915 Others 1868 93.40
Summary of Table Frequencies
Min. 1st Qu. Median Mean 3rd Qu. Max.
1.0 1.0 2.0 2.1 3.0 19.0
--------------------------------------------------------------------------------
provider_last_name (character):
Statistics
N Ndist
2000 856
Table
Freq Perc
MATHEW 19 0.95
LOPEZ 15 0.75
THOMAS 14 0.70
SMITH 13 0.65
RUTKOWSKI 11 0.55
KIM 10 0.50
BAJAJ 10 0.50
LEE 10 0.50
SINGH 10 0.50
JENG 10 0.50
EDWARDS 10 0.50
GUPTA 9 0.45
WILLIAMS 9 0.45
PATEL 9 0.45
... 842 Others 1841 92.05
Summary of Table Frequencies
Min. 1st Qu. Median Mean 3rd Qu. Max.
1.0 1.0 2.0 2.3 3.0 19.0
--------------------------------------------------------------------------------
provider_first_name (character):
Statistics
N Ndist
2000 617
Table
Freq Perc
MATTHEW 34 1.70
JENNIFER 28 1.40
STANLEY 27 1.35
MICHAEL 27 1.35
ROBERT 25 1.25
JOHN 19 0.95
BRIAN 19 0.95
AARON 17 0.85
WILLIAM 16 0.80
THOMAS 16 0.80
RICHARD 15 0.75
CHRISTOPHER 15 0.75
PAUL 14 0.70
KIMBERLY 14 0.70
... 603 Others 1714 85.70
Summary of Table Frequencies
Min. 1st Qu. Median Mean 3rd Qu. Max.
1.0 1.0 2.0 3.2 4.0 34.0
--------------------------------------------------------------------------------
provider_middle_name (character):
Statistics (35.5% NAs)
N Ndist
1289 137
Table
Freq Perc
M 154 11.95
A 118 9.15
J 74 5.74
R 73 5.66
L 60 4.65
E 58 4.50
D 57 4.42
C 54 4.19
S 53 4.11
G 38 2.95
B 34 2.64
T 34 2.64
W 33 2.56
H 25 1.94
... 123 Others 424 32.89
Summary of Table Frequencies
Min. 1st Qu. Median Mean 3rd Qu. Max.
1.0 1.0 2.0 9.4 5.0 154.0
--------------------------------------------------------------------------------
suff (character):
Statistics (99.2% NAs)
N Ndist
16 4
Table
Freq Perc
II 9 56.25
JR. 4 25.00
III 2 12.50
SR. 1 6.25
--------------------------------------------------------------------------------
facility_type (character):
Statistics
N Ndist
2000 7
Table
Freq Perc
Hospital 1763 88.15
Home health agency 99 4.95
Hospice 40 2.00
Dialysis facility 36 1.80
Nursing home 36 1.80
Inpatient rehabilitation facility 18 0.90
Long-term care hospital 8 0.40
--------------------------------------------------------------------------------
facility_affiliations_certification_number (character):
Statistics
N Ndist
2000 1420
Table
Freq Perc
220071 8 0.40
360180 8 0.40
330101 7 0.35
100007 6 0.30
390111 6 0.30
330154 5 0.25
130007 5 0.25
450184 5 0.25
100087 5 0.25
140281 5 0.25
220110 5 0.25
390164 5 0.25
230038 5 0.25
340113 5 0.25
... 1406 Others 1920 96.00
Summary of Table Frequencies
Min. 1st Qu. Median Mean 3rd Qu. Max.
1.0 1.0 1.0 1.4 2.0 8.0
--------------------------------------------------------------------------------
facility_type_certification_number (character):
Statistics (99.8% NAs)
N Ndist
5 5
Table
Freq Perc
330241 1 20
131319 1 20
160069 1 20
160045 1 20
160117 1 20
--------------------------------------------------------------------------------