So, here’s some quick arithmetic on the data in the CSV file from the OP. Two columns here, the first with week number and the second with 2019/2020 deaths compared to the average from that same week over the past six years (as Lance_Turbo has done above).
Week |
Excess |
40 |
1955 |
41 |
2772 |
42 |
3678 |
43 |
3174 |
44 |
2431 |
45 |
4150 |
46 |
3357 |
47 |
3756 |
48 |
2411 |
49 |
3198 |
50 |
2984 |
51 |
1746 |
52 |
2036 |
1 |
758 |
2 |
561 |
3 |
536 |
4 |
916 |
5 |
918 |
6 |
1704 |
7 |
1219 |
8 |
2010 |
9 |
2538 |
10 |
2393 |
11 |
2312 |
12 |
3567 |
13 |
8193 |
14 |
17487 |
15 |
24573 |
16 |
23343 |
17 |
20778 |
18 |
16037 |
19 |
13880 |
20 |
12080 |
21 |
8768 |
22 |
6433 |
23 |
4503 |
24 |
2856 |
I looked at the weeks going back to 40 of 2019 to see if there were some sort of ‘baseline excess death’ we should take into account. There does appear to be, as you may be able to see from the data.
The last 13 weeks of 2019 ran an excess of 2896 deaths a week, on average, compared to the average of the prior six years.
The first 12 weeks of 2020, before things start to really take off in week 13, run an excess of 1619 deaths a week, on average, compared to the average of the prior six years.
It follows, then, that in the six months or so before the deaths really took off in week 13 of 2020, Americans had been dying at an average of 2283 more per week than they had over the past six years. There does seem to be some sort of baseline of excess death, using this methodology, that we should account for.
In weeks 13 through 24 of 2020 – again, assuming week 24 is ‘complete’, as Lance_Turbo has mentioned – the US ran an excess of about 13,244 deaths a week, compared to the average of the prior six years. That’s 158,931 deaths in total. If you use 2283 per week as a sort of baseline that you’d be expecting to start from, you see a surge of about 131,500 deaths, or about 11,000 a week. Not sure how that would compare to Covid-19 (‘under-reported’ or not) during that same window of time.
I am not, of course, claiming that any of this necessarily reflects reality. But it’s the way I’d approach that data table.