| A | B | C | D | E | F | I | O | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Rough analysis of ventilators per capita by state | |||||||||||||||||
2 | ||||||||||||||||||
3 | Assumptions | Note: This is a very rough analysis with many assumptions that may be incorrect | ||||||||||||||||
4 | ICU as % of total beds | 15% | ||||||||||||||||
5 | Total ventilators | 160,000 | ||||||||||||||||
6 | Ventilator:ICU Bed Ratio | 1.43 | ||||||||||||||||
7 | Covid ICU Rate | 5% | ||||||||||||||||
8 | Normal Bed Utilization | 61% | ||||||||||||||||
9 | ||||||||||||||||||
10 | Rank | State | Staffed Beds | ICU Beds | Available ICU Beds | Available Ventilators | Total Population | Available ventilators per capita | People per ventilator | |||||||||
11 | 1 | Mississippi | 9,970 | 1,496 | 912 | 1,304 | 2,879,400 | 0.045% | 2,207 | |||||||||
12 | 2 | Louisiana | 14,989 | 2,248 | 1,371 | 1,961 | 4,519,300 | 0.043% | 2,304 | |||||||||
13 | 3 | Alabama | 15,542 | 2,331 | 1,422 | 2,033 | 4,752,600 | 0.043% | 2,337 | |||||||||
14 | 4 | West Virginia | 5,712 | 857 | 523 | 747 | 1,752,300 | 0.043% | 2,345 | |||||||||
15 | 5 | Washington D.C. | 2,156 | 323 | 197 | 282 | 667,900 | 0.042% | 2,368 | |||||||||
16 | 6 | South Dakota | 2,735 | 410 | 250 | 358 | 848,700 | 0.042% | 2,372 | |||||||||
17 | 7 | Kentucky | 13,799 | 2,070 | 1,263 | 1,805 | 4,320,300 | 0.042% | 2,393 | |||||||||
18 | 8 | New York | 57,261 | 8,589 | 5,239 | 7,492 | 19,016,900 | 0.039% | 2,538 | |||||||||
19 | 9 | Missouri | 16,712 | 2,507 | 1,529 | 2,187 | 5,934,500 | 0.037% | 2,714 | |||||||||
20 | 10 | Tennessee | 18,522 | 2,778 | 1,695 | 2,423 | 6,586,400 | 0.037% | 2,718 | |||||||||
21 | 11 | Pennsylvania | 34,816 | 5,222 | 3,186 | 4,555 | 12,388,100 | 0.037% | 2,720 | |||||||||
22 | 12 | North Dakota | 2,003 | 300 | 183 | 262 | 730,600 | 0.036% | 2,788 | |||||||||
23 | 13 | Oklahoma | 10,312 | 1,547 | 944 | 1,349 | 3,816,100 | 0.035% | 2,828 | |||||||||
24 | 14 | Arkansas | 7,848 | 1,177 | 718 | 1,027 | 2,921,300 | 0.035% | 2,845 | |||||||||
25 | 15 | Florida | 55,727 | 8,359 | 5,099 | 7,291 | 20,843,500 | 0.035% | 2,859 | |||||||||
26 | 16 | Connecticut | 8,847 | 1,327 | 810 | 1,158 | 3,466,300 | 0.033% | 2,995 | |||||||||
27 | 17 | Indiana | 16,084 | 2,413 | 1,472 | 2,104 | 6,487,100 | 0.032% | 3,083 | |||||||||
28 | 18 | Michigan | 23,819 | 3,573 | 2,179 | 3,116 | 9,770,000 | 0.032% | 3,135 | |||||||||
29 | 19 | Ohio | 27,185 | 4,078 | 2,487 | 3,557 | 11,355,900 | 0.031% | 3,193 | |||||||||
30 | 20 | Rhode Island | 2,424 | 364 | 222 | 317 | 1,014,000 | 0.031% | 3,197 | |||||||||
31 | 21 | Illinois | 28,953 | 4,343 | 2,649 | 3,788 | 12,438,400 | 0.030% | 3,283 | |||||||||
32 | 22 | South Carolina | 11,455 | 1,718 | 1,048 | 1,499 | 4,929,800 | 0.030% | 3,289 | |||||||||
33 | 23 | New Jersey | 20,207 | 3,031 | 1,849 | 2,644 | 8,728,300 | 0.030% | 3,301 | |||||||||
34 | 24 | North Carolina | 23,194 | 3,479 | 2,122 | 3,035 | 10,044,400 | 0.030% | 3,310 | |||||||||
35 | 25 | Kansas | 6,466 | 970 | 592 | 846 | 2,814,700 | 0.030% | 3,327 | |||||||||
36 | 26 | Massachusetts | 15,193 | 2,279 | 1,390 | 1,988 | 6,659,900 | 0.030% | 3,350 | |||||||||
37 | 27 | Nebraska | 4,225 | 634 | 387 | 553 | 1,868,900 | 0.030% | 3,381 | |||||||||
38 | 28 | Wyoming | 1,261 | 189 | 115 | 165 | 560,300 | 0.029% | 3,396 | |||||||||
39 | 29 | Maine | 2,893 | 434 | 265 | 379 | 1,299,500 | 0.029% | 3,433 | |||||||||
40 | 30 | Delaware | 2,072 | 311 | 190 | 271 | 937,700 | 0.029% | 3,459 | |||||||||
41 | 31 | Georgia | 22,344 | 3,352 | 2,044 | 2,923 | 10,212,800 | 0.029% | 3,493 | |||||||||
42 | 32 | Virginia | 17,719 | 2,658 | 1,621 | 2,318 | 8,182,100 | 0.028% | 3,529 | |||||||||
43 | 33 | Montana | 2,202 | 330 | 201 | 288 | 1,034,000 | 0.028% | 3,589 | |||||||||
44 | 34 | Texas | 58,055 | 8,708 | 5,312 | 7,596 | 28,024,000 | 0.027% | 3,689 | |||||||||
45 | 35 | Iowa | 6,266 | 940 | 573 | 820 | 3,056,800 | 0.027% | 3,729 | |||||||||
46 | 36 | Wisconsin | 11,050 | 1,658 | 1,011 | 1,446 | 5,662,800 | 0.026% | 3,917 | |||||||||
47 | 37 | Nevada | 5,726 | 859 | 524 | 749 | 2,983,400 | 0.025% | 3,982 | |||||||||
48 | 38 | Minnesota | 10,518 | 1,578 | 962 | 1,376 | 5,489,000 | 0.025% | 3,989 | |||||||||
49 | 39 | New Mexico | 3,917 | 588 | 358 | 512 | 2,045,300 | 0.025% | 3,991 | |||||||||
50 | 40 | California | 74,186 | 11,128 | 6,788 | 9,706 | 38,745,900 | 0.025% | 3,992 | |||||||||
51 | 41 | Hawaii | 2,583 | 387 | 236 | 338 | 1,354,800 | 0.025% | 4,009 | |||||||||
52 | 42 | Arizona | 13,296 | 1,994 | 1,217 | 1,740 | 7,004,300 | 0.025% | 4,026 | |||||||||
53 | 43 | Maryland | 10,806 | 1,621 | 989 | 1,414 | 5,870,800 | 0.024% | 4,152 | |||||||||
54 | 44 | Alaska | 1,235 | 185 | 113 | 162 | 709,100 | 0.023% | 4,388 | |||||||||
55 | 45 | New Hampshire | 2,266 | 340 | 207 | 296 | 1,310,300 | 0.023% | 4,420 | |||||||||
56 | 46 | Oregon | 6,218 | 933 | 569 | 814 | 4,110,800 | 0.020% | 5,053 | |||||||||
57 | 47 | Utah | 4,630 | 695 | 424 | 606 | 3,105,900 | 0.020% | 5,127 | |||||||||
58 | 48 | Colorado | 8,243 | 1,236 | 754 | 1,079 | 5,555,200 | 0.019% | 5,151 | |||||||||
59 | 49 | Idaho | 2,470 | 371 | 226 | 323 | 1,719,600 | 0.019% | 5,321 | |||||||||
60 | 50 | Washington | 10,231 | 1,535 | 936 | 1,339 | 7,368,000 | 0.018% | 5,504 | |||||||||
61 | 51 | Vermont | 828 | 124 | 76 | 108 | 600,600 | 0.018% | 5,544 | |||||||||
62 | ||||||||||||||||||
63 | Total U.S. | 745,957 | 111,894 | 68,255 | 97,600 | 318,498,600 | 0.031% | 3,263 | ||||||||||
64 | Total Italy | 193,600 | 29,040 | 17,714 | 25,330 | 60,500,000 | 0.042% | 2,388 | ||||||||||
65 | ||||||||||||||||||
66 | Sources | |||||||||||||||||
67 | https://www.ahd.com/state_statistics.html | |||||||||||||||||
68 | https://www.ncbi.nlm.nih.gov/pmc/articles/PMC5520980/ | |||||||||||||||||
69 | https://www.nytimes.com/2020/03/12/upshot/coronavirus-biggest-worry-hospital-capacity.html | |||||||||||||||||
70 | https://www.washingtonpost.com/world/europe/coronavirus-in-italy-fills-hospital-beds-and-turns-doctors-into-patients/2020/03/03/60a723a2-5c9e-11ea-ac50-18701e14e06d_story.html | |||||||||||||||||
71 | https://www.statnews.com/2020/03/10/simple-math-alarming-answers-covid-19/ | |||||||||||||||||
72 | https://www.kff.org/other/state-indicator/distribution-by-age/?dataView=1¤tTimeframe=0&sortModel=%7B%22colId%22:%22Location%22,%22sort%22:%22asc%22%7D | |||||||||||||||||
73 | https://ourworldindata.org/coronavirus | |||||||||||||||||
74 | https://www.reddit.com/r/dataisbeautiful/comments/fhkat4/oc_comparing_coronavirus_to_the_flu_mortality/ | |||||||||||||||||
75 | https://www.vox.com/2020/1/31/21113178/what-is-coronavirus-symptoms-travel-china-map | |||||||||||||||||
76 | https://en.wikipedia.org/wiki/List_of_OECD_countries_by_hospital_beds | |||||||||||||||||
77 | https://www.macrotrends.net/countries/ITA/italy/population-growth-rate | |||||||||||||||||
78 | https://www.google.com/search?q=asia+times+why+are+koresas+so+low&oq=asia+times+why+are+koresas+so+low&aqs=chrome..69i57.5128j0j9&sourceid=chrome&ie=UTF-8 | |||||||||||||||||
79 | https://www.statista.com/statistics/185904/hospital-occupancy-rate-in-the-us-since-2001/ | |||||||||||||||||
80 | https://www.beckershospitalreview.com/patient-flow/capacity-dashboard-52-statistics-on-u-s-hospital-capacity.html | |||||||||||||||||
81 | https://emcrit.org/ibcc/COVID19/#prognosis | |||||||||||||||||
82 | https://www.nejm.org/doi/pdf/10.1056/NEJMoa2002032?articleTools=true | |||||||||||||||||
83 | ||||||||||||||||||
84 | ||||||||||||||||||
85 | ||||||||||||||||||
86 | ||||||||||||||||||
87 | ||||||||||||||||||
88 | ||||||||||||||||||
89 | ||||||||||||||||||
90 | ||||||||||||||||||
91 | ||||||||||||||||||
92 | ||||||||||||||||||
93 | ||||||||||||||||||
94 | ||||||||||||||||||
95 | ||||||||||||||||||
96 | ||||||||||||||||||
97 | ||||||||||||||||||
98 | ||||||||||||||||||
99 | ||||||||||||||||||
100 |