ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Note: this sheet is read-only (automatically generated by the data and model)
2
Note: this sheet is read-only (automatically generated by the data and model)This covid pandemic severity index (CPSI) is designed to help aid the distribution of medical resources to hospitals. It takes on three values (3: High, 2: Medium, 1: Low), indicating the severity of the covid-19 outbreak for a hospital on a certain day. It is calculated in these steps: (1) county-level predictions for number of deaths are modeled (2) county-level predictions are allocated to hospitals within counties proportional the their total number of employees (3) each hospital is given a percentile among all US hospitals for its current recorded deaths + predicted future deaths (4) the mean of these percentiles is evenly discretized into three categoriesThis number is estimated based on county-level deaths, and then allocated to hospitals within the county based on their number of employeesUnique hospital IDUnique county identifier
3
Severity 1-daySeverity 2-daySeverity 3-daySeverity 4-daySeverity 5-daySeverity 6-daySeverity 7-dayTotal Deaths HospitalHospital NameCMS Certification NumbercountyFIPSCountyNameStateNameSystem AffiliationLatitudeLongitude
4
33333333331.79Montefiore Hospital- Moses Campus33005936005BronxNY
Montefiore Health System - Bronx, NY
40.88-73.88
5
33333332204.25Cedars-Sinai Medical Center506256037Los AngelesCA
Cedars Sinai Health System - Los Angeles, CA
34.08-118.38
6
33333332023.31NewYork-Presbyterian Queens Hospital33005536081QueensNY
New York-Presbyterian Healthcare System - New York, NY
40.75-73.83
7
33333331650.11Jamaica Hospital Medical Center33001436081QueensNYNot In Any System - ,40.7-73.82
8
33333331611.85Maimonides Medical Center33019436047KingsNYNot In Any System - ,40.64-74
9
33333331599.99NYC Health + Hospitals Elmhurst33012836081QueensNY
NYC Health + Hospitals - New York, NY
40.74-73.89
10
33333331469.22Saint Joseph's University Medical Center31001934031PassaicNJ
Saint Joseph's Healthcare System - Paterson, NJ
40.9-74.17
11
33333331405.99
Los Angeles County and University of Southern California Medical Center
503736037Los AngelesCA
Los Angeles County, Department of Health Services - Los Angeles, CA
34.06-118.21
12
33333331404.17Henry Ford Hospital23005326163WayneMI
Henry Ford Health System - Detroit, MI
42.37-83.08
13
33333331290.4Ronald Reagan UCLA Medical Center502626037Los AngelesCA
University of California Health - Oakland, CA
34.07-118.44
14
33333331217.01Hackensack University Medical Center31000134003BergenNJ
Hackensack Meridian Health - Hackensack, NJ
40.88-74.06
15
33333331210.18NYU Langone Hospital - Brooklyn33030636047KingsNY
NYU Langone Health - New York, NY
40.65-74.02
16
33333331206.62Staten Island University Hospital33016036085RichmondNY
Northwell Health - Great Neck, NY
40.58-74.09
17
33333331198.3
The University of Texas M. D. Anderson Cancer Center
45007648201HarrisTX
University of Texas System - Dallas, TX
29.71-95.4
18
33333331184.13Yale-New Haven Hospital700229009New HavenCT
Yale New Haven Health - New Haven, CT
41.3-72.93
19
33333331154.28
New York Presbyterian/Weill Cornell Medical Center
33010136061New YorkNY
New York-Presbyterian Healthcare System - New York, NY
40.76-73.96
20
33333331145.86Parkland Hospital45001548113DallasTXNot In Any System - ,32.81-96.84
21
33333331110.98
NewYork-Presbyterian Brooklyn Methodist Hospital
33023636047KingsNY
New York-Presbyterian Healthcare System - New York, NY
40.67-73.98
22
33333331069.22IntraCare North Hospital45408348201HarrisTXNot In Any System - ,30.02-95.44
23
33333331047.98Children's Hospital Los Angeles533026037Los AngelesCANot In Any System - ,34.1-118.29
24
33333331035.38NYC Health + Hospitals Queens33023136081QueensNY
NYC Health + Hospitals - New York, NY
40.72-73.8
25
33333331023.22Loma Linda University Medical Center503276071San BernardinoCA
Loma Linda University Healthcare - Loma Linda, CA
34.05-117.26
26
33333331000.64
UMass Memorial Medical Center - University Campus
22016325027WorcesterMA
UMass Memorial Health Care - Worcester, MA
42.28-71.76
27
3333333992.39Rush University Medical Center14011917031CookIL
Rush System for Health - Chicago, IL
41.88-87.67
28
3333333983.68The Cleveland Clinic36018039035CuyahogaOH
Cleveland Clinic Health System - Cleveland, OH
41.5-81.62
29
3333333980.73Stony Brook University Hospital33039336103SuffolkNY
Stony Brook Medicine - Stony Brook, NY
40.91-73.12
30
3333333964.5Long Island Jewish Medical Center33019536059NassauNY
Northwell Health - Great Neck, NY
40.75-73.71
31
3333333957.6Mayo Clinic Hospital301034013MaricopaAZ
Mayo Clinic Health System - Rochester, MN
33.66-111.96
32
3333333954.03DHR Health45086948215HidalgoTXNot In Any System - ,26.25-98.2
33
3333333949.28
The Brookdale University Hospital and Medical Center
33023336047KingsNYNot In Any System - ,40.66-73.91
34
3333333945.78Eisenhower Medical Center505736065RiversideCANot In Any System - ,33.76-116.41
35
3333333938.93South Shore Hospital22010025021NorfolkMANot In Any System - ,42.17-70.95
36
3333333927.33Charlton Memorial Hospital22007425005BristolMA
Southcoast Health System - New Bedford, MA
41.71-71.15
37
3333333926.63NYC Health + Hospitals Kings County33020236047KingsNY
NYC Health + Hospitals - New York, NY
40.66-73.94
38
3333333902.22Baystate Medical Center22007725013HampdenMA
Baystate Health System, Inc - Springfield, MA
42.12-72.61
39
3333333902.09Saint Joseph's Hospital and Medical Center300244013MaricopaAZ
CommonSpirit Health - Englewood, CO
33.48-112.08
40
3333333899.43Flushing Hospital Medical Center33019336081QueensNYNot In Any System - ,40.76-73.82
41
3333333885.74Community Regional Medical Center500606019FresnoCA
Community Medical Centers - Fresno, CA
36.74-119.78
42
3333333882.01University Hospital45021348029BexarTXNot In Any System - ,29.51-98.58
43
3333333871.25The University of Chicago Medical Center14008817031CookIL
UChicago Medicine - Chicago, IL
41.79-87.6
44
3333333870.86Lancaster General Hospital39010042071LancasterPA
Penn Medicine - Philadelphia, PA
40.05-76.31
45
3333333859.34Rhode Island Hospital41000744007ProvidenceRI
Lifespan Corporation - Providence, RI
41.81-71.41
46
3333333847.82Northside Hospital Gwinnett11008713135GwinnettGA
Northside Hospital - Atlanta, GA
33.96-84.02
47
3333333842.34Methodist Hospital45038848029BexarTX
Methodist Healthcare System - San Antonio, TX
29.51-98.57
48
3333333824.27Memorial Regional Hospital10003812011BrowardFL
Memorial Healthcare System - Hollywood, FL
26.02-80.18
49
3333333817.8Hartford Hospital700259003HartfordCT
Hartford Healthcare - Hartford, CT
41.75-72.68
50
3333333810.44Harbor-UCLA Medical Center503766037Los AngelesCA
Los Angeles County, Department of Health Services - Los Angeles, CA
33.83-118.29
51
3333333809.56The Children's Hospital of Philadelphia39330342101PhiladelphiaPANot In Any System - ,39.95-75.19
52
3333333789.45Yuma Regional Medical Center300134027YumaAZNot In Any System - ,32.68-114.63
53
3333333774.76Phoenix Children's Hospital333024013MaricopaAZNot In Any System - ,33.48-112.04
54
3333333761.34Saint John's Episcopal Hospital33039536081QueensNYNot In Any System - ,40.6-73.75
55
3333333760.22Jersey City Medical Center31007434017HudsonNJ
RWJBarnabas Health - West Orange, NJ
40.72-74.05
56
3333333759.21Long Island Jewish Forest Hills Hospital33035336081QueensNY
Northwell Health - Great Neck, NY
40.73-73.85
57
3333333754.47UC San Diego Health System - Hillcrest500256073San DiegoCA
UC San Diego Health System - San Diego, CA
32.75-117.17
58
3333333751.88Beaumont Hospital, Royal Oak23013026125OaklandMI
Beaumont Health - Royal Oak, MI
42.52-83.19
59
3333333746.94North Shore University Hospital33010636059NassauNY
Northwell Health - Great Neck, NY
40.77-73.7
60
3333333742.68
BronxCare Dr. Martin Luther King, Jr. Health Center
33000936005BronxNY
BronxCare Heath Care System - Bronx, NY
40.83-73.9
61
3333333742.28University Hospital of Brooklyn33035036047KingsNYNot In Any System - ,40.66-73.95
62
3333333741.58Overlook Medical Center31005134039UnionNJ
Atlantic Health System - Morristown, NJ
40.71-74.35
63
3333333729.57
Henry Ford Macomb Hospital - Clinton Township
23004726099MacombMI
Henry Ford Health System - Detroit, MI
42.61-82.96
64
3333333726.48Methodist University Hospital44004947157ShelbyTN
Methodist Le Bonheur Healthcare - Memphis, TN
35.14-90.02
65
3333333726.28Lakeland Regional Health Medical Center10015712105PolkFLNot In Any System - ,28.06-81.95
66
3333333720.03Stanford Hospital504416085Santa ClaraCA
Stanford Health Care - Stanford, CA
37.43-122.17
67
3333333714.12
Banner - University Medical Center Phoenix
300024013MaricopaAZ
Banner Health - Phoenix, AZ
33.47-112.06
68
3333333711.9Riverside University Medical Center502926065RiversideCANot In Any System - ,33.91-117.2
69
3333333711.78UCI Health503486059OrangeCA
University of California Health - Oakland, CA
33.79-117.89
70
3333333709.08
Ascension Macomb - Oakland Hospital Warren Campus
23019526099MacombMI
Ascension Health - Saint Louis, MO
42.51-83
71
3333333703.74NYU Langone Tisch Hospital33021436061New YorkNY
NYU Langone Health - New York, NY
40.74-73.97
72
3333333703.56Community Medical Center31004134029OceanNJ
RWJBarnabas Health - West Orange, NJ
39.97-74.22
73
3333333701.35 Reading Hospital39004442011BerksPA
Tower Health - Reading, PA
40.33-75.95
74
3333333697.39AdventHealth Orlando10000712095OrangeFL
AdventHealth - Altamonte Springs, FL
28.57-81.37
75
3333333696.89Hoag Hospital Newport Beach502246059OrangeCA
Hoag Hospitals - Newport Beach, CA
33.63-117.93
76
3333333693.32Trinitas Regional Medical Center31002734039UnionNJNot In Any System - ,40.66-74.22
77
3333333690.11University Medical Center29000732003ClarkNV
University Medical Center - Las Vegas, NV
36.16-115.17
78
3333333688.3Creedmoor Psychiatric Center33400436081QueensNY
New York State Office of Mental Health - Albany, NY
40.74-73.73
79
3333333688.29
City of Hope Comprehensive Cancer Center
501466037Los AngelesCANot In Any System - ,34.13-117.97
80
3333333685.86Kaweah Delta Health Care District500576107TulareCANot In Any System - ,36.33-119.29
81
3333333683.22NYC Health + Hospitals Coney Island33019636047KingsNY
NYC Health + Hospitals - New York, NY
40.59-73.97
82
3333333678.88The University Hospital31011934013EssexNJNot In Any System - ,40.74-74.19
83
3333333678.44
Lahey Hospital and Medical Center Burlington
22017125017MiddlesexMA
Beth Israel Lahey Health - Boston, MA
42.49-71.21
84
3333333675.47UC Davis Medical Center505996067SacramentoCA
University of California Health - Oakland, CA
38.55-121.46
85
3333333673.91Evanston Hospital14001017031CookIL
NorthShore University HealthSystem - Chicago, IL
42.07-87.68
86
3333333670.24AdventHealth Ocala10006212083MarionFL
AdventHealth - Altamonte Springs, FL
29.18-82.14
87
3333333668.31NYC Health + Hospitals Woodhull33039636047KingsNY
NYC Health + Hospitals - New York, NY
40.7-73.94
88
3333333666.78University Medical Center of El Paso45002448141El PasoTXNot In Any System - ,31.77-106.43
89
3333333664.98McLaren Macomb23022726099MacombMI
McLaren Health Care - Flint, MI
42.59-82.9
90
3333333659.7Loyola University Medical Center14027617031CookIL
Trinity Health - Livonia, MI
41.86-87.83
91
3333333659.13The Brooklyn Hospital Center33005636047KingsNYNot In Any System - ,40.69-73.98
92
3333333655.65
Robert Wood Johnson University Hospital New Brunswick
31003834023MiddlesexNJ
RWJBarnabas Health - West Orange, NJ
40.5-74.45
93
3333333646.71Vanderbilt University Hospital44003947037DavidsonTN
Vanderbilt University Medical Center - Nashville, TN
36.14-86.8
94
3333333646.65Spartanburg Medical Center42000745083SpartanburgSC
Spartanburg Regional Healthcare System - Spartanburg, SC
34.97-81.94
95
3333333640.41WellStar Kennestone Hospital11003513067CobbGA
WellStar Health System - Marietta, GA
33.97-84.55
96
3333333633.45Ocean Medical Center31005234029OceanNJ
Hackensack Meridian Health - Hackensack, NJ
40.08-74.13
97
3333333632.94Tucson Medical Center300064019PimaAZNot In Any System - ,32.25-110.88
98
3333333629.23
Banner - University Medical Center Tucson
300644019PimaAZ
Banner Health - Phoenix, AZ
32.24-110.94
99
3333333628Inspira Medical Center Woodbury31008134015GloucesterNJ
Inspira Health Network - Vineland, NJ
39.84-75.15
100
3333333612.49Jersey Shore University Medical Center31007334025MonmouthNJ
Hackensack Meridian Health - Hackensack, NJ
40.21-74.04