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
33333333360.43Montefiore Hospital- Moses Campus33005936005BronxNY
Montefiore Health System - Bronx, NY
40.88-73.88
5
33333332237.2Cedars-Sinai Medical Center506256037Los AngelesCA
Cedars Sinai Health System - Los Angeles, CA
34.08-118.38
6
33333332051.16NewYork-Presbyterian Queens Hospital33005536081QueensNY
New York-Presbyterian Healthcare System - New York, NY
40.75-73.83
7
33333331672.81Jamaica Hospital Medical Center33001436081QueensNYNot In Any System - ,40.7-73.82
8
33333331636.12Maimonides Medical Center33019436047KingsNYNot In Any System - ,40.64-74
9
33333331622.01NYC Health + Hospitals Elmhurst33012836081QueensNY
NYC Health + Hospitals - New York, NY
40.74-73.89
10
33333331493.19Saint Joseph's University Medical Center31001934031PassaicNJ
Saint Joseph's Healthcare System - Paterson, NJ
40.9-74.17
11
33333331489.36Henry Ford Hospital23005326163WayneMI
Henry Ford Health System - Detroit, MI
42.37-83.08
12
33333331427.01
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
13
33333331309.69Ronald Reagan UCLA Medical Center502626037Los AngelesCA
University of California Health - Oakland, CA
34.07-118.44
14
33333331240.94
The University of Texas M. D. Anderson Cancer Center
45007648201HarrisTX
University of Texas System - Dallas, TX
29.71-95.4
15
33333331228.4NYU Langone Hospital - Brooklyn33030636047KingsNY
NYU Langone Health - New York, NY
40.65-74.02
16
33333331228.1Hackensack University Medical Center31000134003BergenNJ
Hackensack Meridian Health - Hackensack, NJ
40.88-74.06
17
33333331227.3Staten Island University Hospital33016036085RichmondNY
Northwell Health - Great Neck, NY
40.58-74.09
18
33333331202.21Yale-New Haven Hospital700229009New HavenCT
Yale New Haven Health - New Haven, CT
41.3-72.93
19
33333331169.37
New York Presbyterian/Weill Cornell Medical Center
33010136061New YorkNY
New York-Presbyterian Healthcare System - New York, NY
40.76-73.96
20
33333331168.32Parkland Hospital45001548113DallasTXNot In Any System - ,32.81-96.84
21
33333331127.7
NewYork-Presbyterian Brooklyn Methodist Hospital
33023636047KingsNY
New York-Presbyterian Healthcare System - New York, NY
40.67-73.98
22
33333331107.27IntraCare North Hospital45408348201HarrisTXNot In Any System - ,30.02-95.44
23
33333331063.65Children's Hospital Los Angeles533026037Los AngelesCANot In Any System - ,34.1-118.29
24
33333331049.63NYC Health + Hospitals Queens33023136081QueensNY
NYC Health + Hospitals - New York, NY
40.72-73.8
25
33333331032.32Loma Linda University Medical Center503276071San BernardinoCA
Loma Linda University Healthcare - Loma Linda, CA
34.05-117.26
26
33333331027.89Rush University Medical Center14011917031CookIL
Rush System for Health - Chicago, IL
41.88-87.67
27
33333331019.17The Cleveland Clinic36018039035CuyahogaOH
Cleveland Clinic Health System - Cleveland, OH
41.5-81.62
28
33333331017.43
UMass Memorial Medical Center - University Campus
22016325027WorcesterMA
UMass Memorial Health Care - Worcester, MA
42.28-71.76
29
3333333987.12Stony Brook University Hospital33039336103SuffolkNY
Stony Brook Medicine - Stony Brook, NY
40.91-73.12
30
3333333981.28Mayo Clinic Hospital301034013MaricopaAZ
Mayo Clinic Health System - Rochester, MN
33.66-111.96
31
3333333971.94DHR Health45086948215HidalgoTXNot In Any System - ,26.25-98.2
32
3333333969.08Long Island Jewish Medical Center33019536059NassauNY
Northwell Health - Great Neck, NY
40.75-73.71
33
3333333963.57
The Brookdale University Hospital and Medical Center
33023336047KingsNYNot In Any System - ,40.66-73.91
34
3333333948.95South Shore Hospital22010025021NorfolkMANot In Any System - ,42.17-70.95
35
3333333943.22Eisenhower Medical Center505736065RiversideCANot In Any System - ,33.76-116.41
36
3333333940.58NYC Health + Hospitals Kings County33020236047KingsNY
NYC Health + Hospitals - New York, NY
40.66-73.94
37
3333333939.73Charlton Memorial Hospital22007425005BristolMA
Southcoast Health System - New Bedford, MA
41.71-71.15
38
3333333924.4Saint Joseph's Hospital and Medical Center300244013MaricopaAZ
CommonSpirit Health - Englewood, CO
33.48-112.08
39
3333333919.59Baystate Medical Center22007725013HampdenMA
Baystate Health System, Inc - Springfield, MA
42.12-72.61
40
3333333911.81Flushing Hospital Medical Center33019336081QueensNYNot In Any System - ,40.76-73.82
41
3333333903University Hospital45021348029BexarTXNot In Any System - ,29.51-98.58
42
3333333902.54Community Regional Medical Center500606019FresnoCA
Community Medical Centers - Fresno, CA
36.74-119.78
43
3333333902.42The University of Chicago Medical Center14008817031CookIL
UChicago Medicine - Chicago, IL
41.79-87.6
44
3333333893.98Lancaster General Hospital39010042071LancasterPA
Penn Medicine - Philadelphia, PA
40.05-76.31
45
3333333883.7Northside Hospital Gwinnett11008713135GwinnettGA
Northside Hospital - Atlanta, GA
33.96-84.02
46
3333333868.49Rhode Island Hospital41000744007ProvidenceRI
Lifespan Corporation - Providence, RI
41.81-71.41
47
3333333862.39Methodist Hospital45038848029BexarTX
Methodist Healthcare System - San Antonio, TX
29.51-98.57
48
3333333846.86The Children's Hospital of Philadelphia39330342101PhiladelphiaPANot In Any System - ,39.95-75.19
49
3333333845.41Memorial Regional Hospital10003812011BrowardFL
Memorial Healthcare System - Hollywood, FL
26.02-80.18
50
3333333825.94Hartford Hospital700259003HartfordCT
Hartford Healthcare - Hartford, CT
41.75-72.68
51
3333333822.55Harbor-UCLA Medical Center503766037Los AngelesCA
Los Angeles County, Department of Health Services - Los Angeles, CA
33.83-118.29
52
3333333800.81Yuma Regional Medical Center300134027YumaAZNot In Any System - ,32.68-114.63
53
3333333795.49Beaumont Hospital, Royal Oak23013026125OaklandMI
Beaumont Health - Royal Oak, MI
42.52-83.19
54
3333333793.93Phoenix Children's Hospital333024013MaricopaAZNot In Any System - ,33.48-112.04
55
3333333777.14Jersey City Medical Center31007434017HudsonNJ
RWJBarnabas Health - West Orange, NJ
40.72-74.05
56
3333333771.82Saint John's Episcopal Hospital33039536081QueensNYNot In Any System - ,40.6-73.75
57
3333333770.3
Henry Ford Macomb Hospital - Clinton Township
23004726099MacombMI
Henry Ford Health System - Detroit, MI
42.61-82.96
58
3333333769.66Long Island Jewish Forest Hills Hospital33035336081QueensNY
Northwell Health - Great Neck, NY
40.73-73.85
59
3333333762.97UC San Diego Health System - Hillcrest500256073San DiegoCA
UC San Diego Health System - San Diego, CA
32.75-117.17
60
3333333753.45University Hospital of Brooklyn33035036047KingsNYNot In Any System - ,40.66-73.95
61
3333333751.75Lakeland Regional Health Medical Center10015712105PolkFLNot In Any System - ,28.06-81.95
62
3333333750.48North Shore University Hospital33010636059NassauNY
Northwell Health - Great Neck, NY
40.77-73.7
63
3333333750.33Overlook Medical Center31005134039UnionNJ
Atlantic Health System - Morristown, NJ
40.71-74.35
64
3333333749.07
BronxCare Dr. Martin Luther King, Jr. Health Center
33000936005BronxNY
BronxCare Heath Care System - Bronx, NY
40.83-73.9
65
3333333748.67
Ascension Macomb - Oakland Hospital Warren Campus
23019526099MacombMI
Ascension Health - Saint Louis, MO
42.51-83
66
3333333745.07Stanford Hospital504416085Santa ClaraCA
Stanford Health Care - Stanford, CA
37.43-122.17
67
3333333744.32Methodist University Hospital44004947157ShelbyTN
Methodist Le Bonheur Healthcare - Memphis, TN
35.14-90.02
68
3333333731.79
Banner - University Medical Center Phoenix
300024013MaricopaAZ
Banner Health - Phoenix, AZ
33.47-112.06
69
3333333723.39UCI Health503486059OrangeCA
University of California Health - Oakland, CA
33.79-117.89
70
3333333720.06 Reading Hospital39004442011BerksPA
Tower Health - Reading, PA
40.33-75.95
71
3333333712.94NYU Langone Tisch Hospital33021436061New YorkNY
NYU Langone Health - New York, NY
40.74-73.97
72
3333333712.79Community Medical Center31004134029OceanNJ
RWJBarnabas Health - West Orange, NJ
39.97-74.22
73
3333333712.62AdventHealth Orlando10000712095OrangeFL
AdventHealth - Altamonte Springs, FL
28.57-81.37
74
3333333709.97Riverside University Medical Center502926065RiversideCANot In Any System - ,33.91-117.2
75
3333333708.26Hoag Hospital Newport Beach502246059OrangeCA
Hoag Hospitals - Newport Beach, CA
33.63-117.93
76
3333333706.42University Medical Center29000732003ClarkNV
University Medical Center - Las Vegas, NV
36.16-115.17
77
3333333702.11McLaren Macomb23022726099MacombMI
McLaren Health Care - Flint, MI
42.59-82.9
78
3333333701.5Trinitas Regional Medical Center31002734039UnionNJNot In Any System - ,40.66-74.22
79
3333333698.58
City of Hope Comprehensive Cancer Center
501466037Los AngelesCANot In Any System - ,34.13-117.97
80
3333333698.02Evanston Hospital14001017031CookIL
NorthShore University HealthSystem - Chicago, IL
42.07-87.68
81
3333333697.77Creedmoor Psychiatric Center33400436081QueensNY
New York State Office of Mental Health - Albany, NY
40.74-73.73
82
3333333694.88Kaweah Delta Health Care District500576107TulareCANot In Any System - ,36.33-119.29
83
3333333693.5NYC Health + Hospitals Coney Island33019636047KingsNY
NYC Health + Hospitals - New York, NY
40.59-73.97
84
3333333693.16The University Hospital31011934013EssexNJNot In Any System - ,40.74-74.19
85
3333333692.09UC Davis Medical Center505996067SacramentoCA
University of California Health - Oakland, CA
38.55-121.46
86
3333333688.21AdventHealth Ocala10006212083MarionFL
AdventHealth - Altamonte Springs, FL
29.18-82.14
87
3333333684.24
Lahey Hospital and Medical Center Burlington
22017125017MiddlesexMA
Beth Israel Lahey Health - Boston, MA
42.49-71.21
88
3333333683.3Loyola University Medical Center14027617031CookIL
Trinity Health - Livonia, MI
41.86-87.83
89
3333333678.72University Medical Center of El Paso45002448141El PasoTXNot In Any System - ,31.77-106.43
90
3333333678.37NYC Health + Hospitals Woodhull33039636047KingsNY
NYC Health + Hospitals - New York, NY
40.7-73.94
91
3333333669.06The Brooklyn Hospital Center33005636047KingsNYNot In Any System - ,40.69-73.98
92
3333333666.44WellStar Kennestone Hospital11003513067CobbGA
WellStar Health System - Marietta, GA
33.97-84.55
93
3333333664.36
Robert Wood Johnson University Hospital New Brunswick
31003834023MiddlesexNJ
RWJBarnabas Health - West Orange, NJ
40.5-74.45
94
3333333661.9Spartanburg Medical Center42000745083SpartanburgSC
Spartanburg Regional Healthcare System - Spartanburg, SC
34.97-81.94
95
3333333650.83Vanderbilt University Hospital44003947037DavidsonTN
Vanderbilt University Medical Center - Nashville, TN
36.14-86.8
96
3333333643Inspira Medical Center Woodbury31008134015GloucesterNJ
Inspira Health Network - Vineland, NJ
39.84-75.15
97
3333333641.76Ocean Medical Center31005234029OceanNJ
Hackensack Meridian Health - Hackensack, NJ
40.08-74.13
98
3333333636.62Tucson Medical Center300064019PimaAZNot In Any System - ,32.25-110.88
99
3333333632.89
Banner - University Medical Center Tucson
300644019PimaAZ
Banner Health - Phoenix, AZ
32.24-110.94
100
3333333623.24UAB Hospital100331073JeffersonAL
UAB Medicine - Birmingham, AL
33.51-86.8