| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Nursing Home/LTC COVID Deaths by State | ||||||||||||||||||||||||||||
2 | by @kerpen and @nosmhnmh | ||||||||||||||||||||||||||||
3 | Change from yesterday's tally | ||||||||||||||||||||||||||||
4 | Data Reporting Status | last update | LTC COVID Deaths | State deaths on date | Total Deaths Minus LTC Deaths | LTC Share of COVID Deaths | Total LTC Population, 2020 (AHCA/NCAL) | COVID LTC deaths as % of LTC Population | LTC Deaths | State Deaths on Date | Total COVID Deaths Minus LTC Deaths | LTC Deaths as Share of Batch | |||||||||||||||||
5 | Alabama | Media | 17-Jun | 375 | 784 | 409 | 47.8% | 31,669 | 1.2% | 0 | #DIV/0! | https://www.wsfa.com/2020/06/17/more-than-covid-deaths-alabama-are-long-term-care-residents/?outputType=amp | https://www.usatoday.com/story/news/investigations/2020/06/01/coronavirus-nursing-home-deaths-top-40-600/5273075002/ | ||||||||||||||||
6 | Alaska | Media | 10-Jul | 4 | 17 | 13 | 23.5% | 2,858 | 0.1% | 0 | #DIV/0! | https://www.adn.com/alaska-news/2020/06/12/alaskas-12th-virus-death-involves-another-resident-at-anchorage-care-center-dealing-with-outbreak/ | https://www.adn.com/alaska-news/2020/06/26/two-more-alaskans-die-outside-from-covid-19-bringing-state-total-to-14/ | ||||||||||||||||
7 | Arizona | Maricopa/Mohave/Pima | 10-Jul | 679 | 1,324 | 645 | 51.3% | 42,849 | 1.6% | 0 | 0 | #DIV/0! | https://www.maricopa.gov/5460/Coronavirus-Disease-2019 | 28 of 42 | Pima: 137 of 273 as of 6/30 | 165 out of 315 | https://webcms.pima.gov/cms/One.aspx?portalId=169&pageId=578441 | ||||||||||||
8 | Arkansas | Media | 6-Jul | 113 | 292 | 179 | 38.7% | 24,995 | 0.5% | 0 | #DIV/0! | https://www.arkansasonline.com/arvirus/?utm_medium=email&utm_campaign=covid-06-15-20&utm_content=covid-06-15-20+CID_ef1cfb41980c14af8eff3404711954a9&utm_source=Email%20Marketing%20Platform&utm_term=our%20interactive%20page#arkansas | |||||||||||||||||
9 | California | LA Times - daily | 11-Jul | 3,238 | 7,028 | 3,790 | 46.1% | 258,294 | 1.3% | 25 | 305 | 280 | 8.2% | https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx | https://www.latimes.com/projects/california-coronavirus-cases-tracking-outbreak/ | ||||||||||||||
10 | Colorado | Best data - Wed | 8-Jul | 923 | 1,704 | 781 | 54.2% | 35,670 | 2.6% | 0 | 0 | #DIV/0! | https://covid19.colorado.gov/data/outbreak-data | ||||||||||||||||
11 | Connecticut | Best data - Thu | 10-Jul | 3,130 | 4,348 | 1,218 | 72.0% | 24,480 | 12.8% | 0 | 0 | #DIV/0! | https://portal.ct.gov/Coronavirus/Nursing-Homes-and-Assisted-Living-Facilities | ||||||||||||||||
12 | Delaware | Best data - Fri - staff | 10-Jul | 335 | 517 | 182 | 64.8% | 6,173 | 5.4% | 0 | #DIV/0! | https://news.delaware.gov/2020/06/26/public-health-announces-78-new-positive-cases-of-covid-19-in-delaware-no-new-deaths/ | |||||||||||||||||
13 | DC | Best data - daily - staff | 11-Jul | 167 | 568 | 401 | 29.4% | 2,934 | 5.7% | 0 | #DIV/0! | https://coronavirus.dc.gov/page/coronavirus-data | |||||||||||||||||
14 | Florida | Best data - daily | 11-Jul | 2,082 | 4,197 | 2,115 | 49.6% | 157,983 | 1.3% | 27 | 95 | 68 | 28.4% | https://floridahealthcovid19.gov | |||||||||||||||
15 | Georgia | Best data - daily - staff | 10-Jul | 1,342 | 2,965 | 1,623 | 45.3% | 60,741 | 2.2% | 0 | 0 | #DIV/0! | https://dch.georgia.gov/ | ||||||||||||||||
16 | Hawaii | 10-Jul | 8,125 | 0 | #DIV/0! | https://www.kitv.com/story/42217631/three-senior-care-facility-employees-test-positive-for-covid19 | |||||||||||||||||||||||
17 | Idaho | Best data - Fri | 10-Jul | 61 | 100 | 39 | 61.0% | 12,473 | 0.5% | 0 | #DIV/0! | https://coronavirus.idaho.gov/ltc/ | https://www.usatoday.com/story/news/investigations/2020/06/01/coronavirus-nursing-home-deaths-top-40-600/5273075002/ | ||||||||||||||||
18 | Illinois | Best data - Fri | 10-Jul | 3,898 | 7,144 | 3,246 | 54.6% | 89,387 | 4.4% | 0 | 0 | #DIV/0! | https://www.dph.illinois.gov/covid19/long-term-care-facility-outbreaks-covid-19 | ||||||||||||||||
19 | Indiana | Best data - Mon | 6-Jul | 1,220 | 2,505 | 1,285 | 48.7% | 43,135 | 2.8% | 0 | 0 | #DIV/0! | https://www.coronavirus.in.gov/ | ||||||||||||||||
20 | Iowa | Best data - daily | 10-Jul | 393 | 743 | 350 | 52.9% | 50,394 | 0.8% | 0 | #DIV/0! | https://coronavirus.iowa.gov/pages/long-term-care | |||||||||||||||||
21 | Kansas | Best data - Mon/Wed/Fri | 10-Jul | 165 | 284 | 119 | 58.1% | 26,105 | 0.6% | 0 | #DIV/0! | https://www.coronavirus.kdheks.gov/DocumentCenter/View/1125/Historical---May-22?bidId= | |||||||||||||||||
22 | Kentucky | Best data - daily - staff | 10-Jul | 399 | 620 | 221 | 64.4% | 31,179 | 1.3% | 0 | #DIV/0! | https://chfs.ky.gov/agencies/dph/covid19/LTCupdate.pdf | |||||||||||||||||
23 | Louisiana | Best data - Mon - staff | 6-Jul | 1,388 | 3,188 | 1,800 | 43.5% | 32,059 | 4.3% | 0 | 0 | #DIV/0! | http://ldh.la.gov/index.cfm/page/3965 Also includes assisted living starting June 15 | ||||||||||||||||
24 | Maine | NYT | 10-Jul | 58 | 111 | 53 | 52.3% | 13,579 | 0.4% | 0 | #DIV/0! | https://www.wmtw.com/amp/article/calls-grow-for-more-widespread-coronavirus-testing-at-nursing-homes/32703072 | https://bangordailynews.com/2020/06/18/news/state/maine-inspectors-didnt-visit-most-nursing-homes-even-as-they-became-coronavirus-hot-spots/ | https://www.nytimes.com/interactive/2020/us/coronavirus-nursing-homes.html | |||||||||||||||
25 | Maryland | Best data - Wed - staff | 8-Jul | 1,961 | 3,149 | 1,188 | 62.3% | 36,751 | 5.3% | 0 | 0 | #DIV/0! | https://coronavirus.maryland.gov/pages/hcf-resources | ||||||||||||||||
26 | Massachusetts | Best data - daily | 11-Jul | 5,268 | 8,310 | 3,042 | 63.4% | 53,450 | 9.9% | 10 | 14 | 4 | 71.4% | https://www.mass.gov/info-details/covid-19-response-reporting | |||||||||||||||
27 | Michigan | Best data - daily - staff | 10-Jul | 2,092 | 6,039 | 3,947 | 34.6% | 68,002 | 3.1% | 0 | 0 | #DIV/0! | https://www.michigan.gov/coronavirus/0,9753,7-406-98163_98173-526911--,00.html | ||||||||||||||||
28 | Minnesota | Best data - daily | 11-Jul | 1,170 | 1,499 | 329 | 78.1% | 82,776 | 1.4% | 4 | 4 | 0 | 100.0% | https://www.health.state.mn.us/diseases/coronavirus/situation.html | |||||||||||||||
29 | Mississippi | Best data - daily - staff | 11-Jul | 593 | 1,230 | 637 | 48.2% | 22,034 | 2.7% | 7 | 15 | 8 | 46.7% | https://msdh.ms.gov/msdhsite/_static/14,0,420.html | |||||||||||||||
30 | Missouri | Just St Louis County | 3-Jun | 305 | 530 | 225 | 57.5% | 59,840 | 0.5% | 0 | #DIV/0! | https://callnewspapers.com/wp-content/uploads/Residential-Care-Report-06-04-2020.pdf | |||||||||||||||||
31 | Montana | Media - USA Today | 10-Jul | 7 | 28 | 10 | 25.0% | 9,148 | 0.1% | 0 | #DIV/0! | https://billingsgazette.com/news/state-and-regional/official-montana-nursing-home-virus-outbreak-appears-over/article_9f50cb8a-33b8-5516-a3a8-666bb690bb10.amp.html | |||||||||||||||||
32 | Nebraska | Media | 10-Jul | 119 | 284 | 165 | 41.9% | 21,744 | 0.5% | 0 | #DIV/0! | https://www.1011now.com/content/news/Gov-Ricketts-discusses-changes-to-long-term-care-facilities--571272341.html | https://www.nytimes.com/interactive/2020/us/coronavirus-nursing-homes.html | ||||||||||||||||
33 | Nevada | Best data - daily - staff | 10-Jul | 136 | 579 | 443 | 23.5% | 13,018 | 1.0% | 0 | #DIV/0! | https://app.powerbigov.us/view?r=eyJrIjoiNDMwMDI0YmQtNmUyYS00ZmFjLWI0MGItZDM0OTY1Y2Y0YzNhIiwidCI6ImU0YTM0MGU2LWI4OWUtNGU2OC04ZWFhLTE1NDRkMjcwMzk4MCJ9 | |||||||||||||||||
34 | New Hampshire | Best data - daily | 11-Jul | 321 | 391 | 70 | 82.1% | 11,382 | 2.8% | 3 | 1 | -2 | 300.0% | https://www.nh.gov/covid19/dashboard/summary.htm | |||||||||||||||
35 | New Jersey | Best data - daily - staff | 11-Jul | 6,727 | 13,578 | 6,851 | 49.5% | 62,095 | 10.8% | 4 | 46 | 42 | 8.7% | https://covid19.nj.gov/#live-updates | |||||||||||||||
36 | New Mexico | Combined Media | 10-Jul | 197 | 539 | 342 | 36.5% | 10,605 | 1.9% | 0 | #DIV/0! | https://www.governor.state.nm.us/july-1st-covid-19-press-conference-graphics/ | |||||||||||||||||
37 | New York | BAD data - daily - missing data | 11-Jul | 6,485 | 24,974 | 18,489 | 26.0% | 145,720 | 4.5% | 6 | 6 | 0.0% | *NY is the only state to exclude deaths of nursing home residents who die at a hospital. Do not compare with other states. Exact footnote language: "This data does not reflect COVID-19 confirmed or COVID-19 presumed positive deaths that occurred outside of the facility." | ||||||||||||||||
38 | North Carolina | Best data - daily | 11-Jul | 818 | 1,499 | 681 | 54.6% | 68,821 | 1.2% | 5 | 20 | 15 | 25.0% | https://covid19.ncdhhs.gov/dashboard/congregate-living-settings | |||||||||||||||
39 | North Dakota | Best data - daily | 10-Jul | 61 | 85 | 24 | 71.8% | 9,570 | 0.6% | 0 | #DIV/0! | https://www.health.nd.gov/diseases-conditions/coronavirus/north-dakota-coronavirus-cases | |||||||||||||||||
40 | Ohio | Best data - Wed - staff | 8-Jul | 2,101 | 2,991 | 890 | 70.2% | 121,138 | 1.7% | 0 | 0 | #DIV/0! | Weekly report from April 15 https://public.tableau.com/profile/sohdoh#!/vizhome/MobileLTCMortality/DashboardMobileLongTermCareMortality plus 369 pre-April 15 LTC deaths https://twitter.com/karenkasler/status/1263468540033675264 | https://coronavirus.ohio.gov/wps/portal/gov/covid-19/dashboards/long-term-care-facilities/cases | https://www.cleveland.com/coronavirus/2020/06/1745-ohio-nursing-home-patients-now-dead-with-coronavirus-71-of-all-known-ohio-covid-19-deaths.html?outputType=amp | ||||||||||||||
41 | Oklahoma | Best data - Daily - staff | 9-Jul | 212 | 410 | 198 | 51.7% | 28,104 | 0.8% | 0 | #DIV/0! | https://coronavirus.health.ok.gov/executive-order-reports | |||||||||||||||||
42 | Oregon | Best data - Wed - staff | 6-Jul | 131 | 215 | 84 | 60.9% | 35,563 | 0.4% | 0 | #DIV/0! | https://www.oregon.gov/oha/PH/DISEASESCONDITIONS/DISEASESAZ/Emerging%20Respitory%20Infections/COVID-19-Weekly-Report-2020-06-17-FINAL.pdf | |||||||||||||||||
43 | Pennsylvania | Best data - Daily - staff | 11-Jul | 4,703 | 6,897 | 2,194 | 68.2% | 133,551 | 3.5% | 4 | 17 | 13 | 23.5% | https://www.health.pa.gov/topics/disease/coronavirus/Pages/LTCF-Data.aspx | |||||||||||||||
44 | Rhode Island | Best data - Friday | 10-Jul | 780 | 976 | 196 | 79.9% | 11,623 | 6.7% | 0 | #DIV/0! | https://ri-department-of-health-covid-19-data-rihealth.hub.arcgis.com/ | |||||||||||||||||
45 | South Carolina | Best data - Tue/Fri - staff | 9-Jul | 400 | 904 | 504 | 44.2% | 33,540 | 1.2% | 0 | #DIV/0! | https://www.scdhec.gov/infectious-diseases/viruses/coronavirus-disease-2019-covid-19/sc-demographic-data-covid-19 | |||||||||||||||||
46 | South Dakota | NYT | 10-Jul | 38 | 101 | 63 | 37.6% | 9,998 | 0.4% | 0 | #DIV/0! | https://www.keloland.com/keloland-com-original/nursing-home-covid-19-deaths-accounted-for-about-43-of-all-state-covid-19-deaths-through-may-31-national-report-says/amp/ | |||||||||||||||||
47 | Tennessee | Good data - Fri | 10-Jul | 238 | 723 | 485 | 32.9% | 45,472 | 0.5% | 0 | #DIV/0! | https://www.tn.gov/health/cedep/ncov.html | |||||||||||||||||
48 | Texas | Best data - daily - staff | 10-Jul | 1,209 | 3,112 | 1,903 | 38.8% | 153,635 | 0.8% | 9 | 99 | 90 | 9.1% | https://www.dshs.texas.gov/coronavirus/covid-19outbreaksinlong-termcarefacilities.aspx | |||||||||||||||
49 | Utah | Best data - daily - staff | 10-Jul | 89 | 207 | 118 | 43.0% | 14,001 | 0.6% | 0 | #DIV/0! | https://coronavirus.utah.gov/case-counts/ | |||||||||||||||||
50 | Vermont | Best data - Fri - staff | 10-Jul | 28 | 56 | 28 | 50.0% | 5,377 | 0.5% | 0 | #DIV/0! | https://www.healthvermont.gov/sites/default/files/documents/pdf/Weekly-Summary-of-Data.pdf | |||||||||||||||||
51 | Virginia | Best data - daily | 11-Jul | 1,173 | 1,962 | 789 | 59.8% | 58,311 | 2.0% | 4 | 4 | 0.0% | https://public.tableau.com/views/VirginiaCOVID-19Dashboard/Outbreaks?%3Aembed=yes&%3Adisplay_count=yes&%3AshowVizHome=no&%3Atoolbar=no | ||||||||||||||||
52 | Washington | Best data - Monday | 6-Jul | 820 | 1,386 | 566 | 59.2% | 57,162 | 1.4% | 0 | 0 | #DIV/0! | https://www.doh.wa.gov/Portals/1/Documents/1600/coronavirus/data-tables/Weekly-COVID-19-Long-Term-Care-Report.pdf | ||||||||||||||||
53 | West Virginia | *BAD data - Fri - staff | 10-Jul | 45 | 95 | 50 | 47.4% | 12,272 | 0.4% | 0 | #DIV/0! | https://dhhr.wv.gov/COVID-19/Pages/default.aspx | |||||||||||||||||
54 | Wisconsin | Best data - daily | 11-Jul | 343 | 821 | 478 | 41.8% | 68,031 | 0.5% | 1 | 7 | 6 | 14.3% | https://www.dhs.wisconsin.gov/covid-19/deaths.htm | |||||||||||||||
55 | Wyoming | Media | 10-Jul | 7 | 21 | 14 | 33.3% | 3,733 | 0.2% | 0 | #DIV/0! | https://health.wyo.gov/two-coronavirus-related-deaths-added-in-wyoming/ | https://www.gillettenewsrecord.com/news/wyoming/article_9e983fec-2fa2-53b8-ad53-e4b54c651bab.html | ||||||||||||||||
56 | Reporting states total, NY doubled to compensate for exclusion of hospital deaths | 65,032 | 122,030 | 56,998 | 53.3% | 2,421,549 | 2.7% | 99 | 633 | 534 | 15.6% | ||||||||||||||||||
57 | Reporting states total excluding NY | 52,062 | 97,056 | 44,994 | 53.6% | 2,275,829 | 2.3% | 99 | 627 | 528 | 15.8% | ||||||||||||||||||
58 | *Some states take out data from LTC outbreaks where all the cases have been resolved either by recovery or death. | ||||||||||||||||||||||||||||
59 | NYT data is from an article that The NY Times put out June 27th after their original one on May 11th | ||||||||||||||||||||||||||||
60 | |||||||||||||||||||||||||||||
61 | |||||||||||||||||||||||||||||
62 | |||||||||||||||||||||||||||||
63 | |||||||||||||||||||||||||||||
64 | |||||||||||||||||||||||||||||
65 | |||||||||||||||||||||||||||||
66 | |||||||||||||||||||||||||||||
67 | |||||||||||||||||||||||||||||
68 | |||||||||||||||||||||||||||||
69 | |||||||||||||||||||||||||||||
70 | |||||||||||||||||||||||||||||
71 | |||||||||||||||||||||||||||||
72 | |||||||||||||||||||||||||||||
73 | |||||||||||||||||||||||||||||
74 | |||||||||||||||||||||||||||||
75 | |||||||||||||||||||||||||||||
76 | |||||||||||||||||||||||||||||
77 | |||||||||||||||||||||||||||||
78 | |||||||||||||||||||||||||||||
79 | |||||||||||||||||||||||||||||
80 | |||||||||||||||||||||||||||||
81 | |||||||||||||||||||||||||||||
82 | |||||||||||||||||||||||||||||
83 | |||||||||||||||||||||||||||||
84 | |||||||||||||||||||||||||||||
85 | |||||||||||||||||||||||||||||
86 | |||||||||||||||||||||||||||||
87 | |||||||||||||||||||||||||||||
88 | |||||||||||||||||||||||||||||
89 | |||||||||||||||||||||||||||||
90 | |||||||||||||||||||||||||||||
91 | |||||||||||||||||||||||||||||
92 | |||||||||||||||||||||||||||||
93 | |||||||||||||||||||||||||||||
94 | |||||||||||||||||||||||||||||
95 | |||||||||||||||||||||||||||||
96 | |||||||||||||||||||||||||||||
97 | |||||||||||||||||||||||||||||
98 | |||||||||||||||||||||||||||||
99 | |||||||||||||||||||||||||||||
100 | |||||||||||||||||||||||||||||
Loading...