covid-geography: mmsa-icu-beds.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
136 rows
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | MMSA | total_percent_at_risk | high_risk_per_ICU_bed | high_risk_per_hospital | icu_beds | hospitals | total_at_risk |
---|---|---|---|---|---|---|---|---|
101 | 101 | St. Louis, MO-IL | 61.91% | 1493.132605 | 38650.804 | 906 | 35 | 1352778.14 |
102 | 102 | Knoxville, TN | 67.61% | 1490.921329 | 47113.114 | 316 | 10 | 471131.14 |
103 | 103 | Huntington-Ashland, WV-KY-OH | 72.66% | 1484.641304 | 40976.1 | 138 | 5 | 204880.5 |
104 | 104 | Louisville/Jefferson County, KY-IN | 63.04% | 1480.792787 | 52691.54333 | 427 | 12 | 632298.52 |
105 | 105 | Indianapolis-Carmel-Anderson, IN | 62.39% | 1469.136169 | 36728.40423 | 650 | 26 | 954938.51 |
106 | 106 | Columbia, SC | 62.66% | 1468.166739 | 67535.67 | 276 | 6 | 405214.02 |
107 | 107 | Grand Forks, ND-MN | 54.83% | 1429.04871 | 11075.1275 | 31 | 4 | 44300.51 |
108 | 108 | Milwaukee-Waukesha-West Allis, WI | 58.69% | 1411.037416 | 44359.48875 | 503 | 16 | 709751.82 |
109 | 109 | Panama City, FL | 66.84% | 1390.313636 | 35684.71667 | 77 | 3 | 107054.15 |
110 | 110 | Tuscaloosa, AL | 62.40% | 1370.504318 | 40201.46 | 88 | 3 | 120604.38 |
111 | 111 | New Orleans-Metairie, LA | 66.27% | 1347.585845 | 34824.45526 | 491 | 19 | 661664.65 |
112 | 112 | Cleveland-Elyria, OH | 66.87% | 1340.427345 | 46973.23652 | 806 | 23 | 1080384.44 |
113 | 113 | Provo-Orem, UT | 38.92% | 1318.728361 | 26814.14333 | 122 | 6 | 160884.86 |
114 | 114 | Kansas City, MO-KS | 59.01% | 1309.019106 | 28838.08758 | 727 | 33 | 951656.89 |
115 | 115 | Lincoln, NE | 53.81% | 1274.84037 | 27536.552 | 108 | 5 | 137682.76 |
116 | 116 | Tulsa, OK | 65.09% | 1253.763299 | 21313.97609 | 391 | 23 | 490221.45 |
117 | 117 | Fort Wayne, IN | 65.98% | 1212.837345 | 26834.02625 | 177 | 8 | 214672.21 |
118 | 118 | Wichita, KS | 62.52% | 1165.437984 | 25056.91667 | 258 | 12 | 300683.0 |
119 | 119 | Toledo, OH | 64.20% | 1123.504366 | 33455.46333 | 268 | 9 | 301099.17 |
120 | 120 | Birmingham-Hoover, AL | 66.48% | 1109.572514 | 42243.01071 | 533 | 14 | 591402.15 |
121 | 121 | Jackson, MS | 59.79% | 1082.387778 | 18787.15929 | 243 | 14 | 263020.23 |
122 | 122 | Lansing-East Lansing, MI | 61.69% | 1060.187421 | 46860.284 | 221 | 5 | 234301.42 |
123 | 123 | Nashville-Davidson--Murfreesboro--Franklin, TN | 61.09% | 1056.271281 | 35955.4744 | 851 | 25 | 898886.86 |
124 | 124 | Florence, SC | 72.31% | 1040.463182 | 22890.19 | 110 | 5 | 114450.95 |
125 | 125 | Augusta-Richmond County, GA-SC | 65.67% | 1016.301672 | 43410.6 | 299 | 7 | 303874.2 |
126 | 126 | North Platte, NE | 64.19% | 944.2910526 | 17941.53 | 19 | 1 | 17941.53 |
127 | 127 | Lexington-Fayette, KY | 63.39% | 915.7096043 | 31820.90875 | 278 | 8 | 254567.27 |
128 | 128 | Scottsbluff, NE | 68.20% | 899.2759091 | 19784.07 | 22 | 1 | 19784.07 |
129 | 129 | Evansville, IN-KY | 69.07% | 893.5168947 | 33953.642 | 190 | 5 | 169768.21 |
130 | 130 | Fargo, ND-MN | 51.26% | 870.3837838 | 48306.3 | 111 | 2 | 96612.6 |
131 | 131 | Bismarck, ND | 60.22% | 864.1463889 | 20739.51333 | 72 | 3 | 62218.54 |
132 | 132 | Charleston, WV | 75.97% | 831.6897436 | 25948.72 | 156 | 5 | 129743.6 |
133 | 133 | Duluth, MN-WI | 60.34% | 730.5231351 | 12286.07091 | 185 | 11 | 135146.78 |
134 | 134 | Reno, NV | 57.86% | 638.8247432 | 42290.198 | 331 | 5 | 211450.99 |
135 | 135 | Gainesville, FL | 56.38% | 621.4499524 | 65252.245 | 210 | 2 | 130504.49 |
136 | 136 | Rochester, MN | 54.72% | 413.6677064 | 22544.89 | 218 | 4 | 90179.56 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "covid-geography/mmsa-icu-beds" ( "MMSA" TEXT, "total_percent_at_risk" TEXT, "high_risk_per_ICU_bed" REAL, "high_risk_per_hospital" REAL, "icu_beds" INTEGER, "hospitals" INTEGER, "total_at_risk" REAL );