economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where cadence = "weekly", "start_date" is on date 2020-05-03 and week = 19 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date)
country 3
- United States 51
- Canada 1
- South Africa 1
cadence 1
- weekly · 53 ✖
Link | rowid | country | region | region_code | start_date | end_date ▲ | days | year | week | population | total_deaths | covid_deaths | expected_deaths | excess_deaths | non_covid_deaths | covid_deaths_per_100k | excess_deaths_per_100k | excess_deaths_pct_change | cadence | month | total_deaths_per_7_days | covid_deaths_per_7_days | expected_deaths_per_7_days | excess_deaths_per_7_days | non_covid_deaths_per_7_days | covid_deaths_per_100k_per_7_days | excess_deaths_per_100k_per_7_days | quarter |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2296 | 2296 | United States | Alabama | AL | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 4903185 | 1171 | 101 | 1016.35839598188 | 154.641604018121 | 1070 | 2.0598855641792 | 3.15390106671726 | 0.152152631030047 | weekly | |||||||||
2448 | 2448 | United States | Alaska | AK | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 731545 | 89 | 0 | 83.0751879727108 | 5.92481202728922 | 89 | 0.0 | 0.809903974094447 | 0.0713186713370477 | weekly | |||||||||
2600 | 2600 | United States | Arizona | AZ | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 7278717 | 1427 | 183 | 1198.36591479497 | 228.634085205029 | 1244 | 2.51417935331185 | 3.14113167478594 | 0.190788207827278 | weekly | |||||||||
2752 | 2752 | United States | Arkansas | AR | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 3017825 | 661 | 16 | 604.954887219346 | 56.0451127806541 | 645 | 0.530183161714148 | 1.85713594329208 | 0.0926434581564644 | weekly | |||||||||
2904 | 2904 | United States | California | CA | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 39512223 | 5671 | 575 | 4948.04761904823 | 722.952380951768 | 5096 | 1.45524588682343 | 1.82969300652046 | 0.146108614268112 | weekly | |||||||||
3056 | 3056 | United States | Colorado | CO | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 5758736 | 906 | 135 | 771.977443610078 | 134.022556389922 | 771 | 2.34426443580675 | 2.32729120400591 | 0.1736094201965 | weekly | |||||||||
3208 | 3208 | United States | Connecticut | CT | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 3565287 | 1052 | 496 | 577.5964912288 | 474.4035087712 | 556 | 13.9119235001278 | 13.3061800851152 | 0.821340704064766 | weekly | |||||||||
3360 | 3360 | United States | Delaware | DE | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 973764 | 271 | 34 | 164.877192985375 | 106.122807014625 | 237 | 3.49160576895428 | 10.8982060349967 | 0.643647584563367 | weekly | |||||||||
3512 | 3512 | United States | District of Columbia | DC | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 705749 | 214 | 71 | 108.521303258523 | 105.478696741477 | 143 | 10.0602338791837 | 14.9456388519823 | 0.971963048491977 | weekly | |||||||||
3664 | 3664 | United States | Florida | FL | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 21477737 | 4407 | 349 | 3999.24060150478 | 407.759398495222 | 4058 | 1.62493841879151 | 1.89852123850488 | 0.101959206540811 | weekly | |||||||||
3816 | 3816 | United States | Georgia | GA | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 10617423 | 1987 | 225 | 1632.69674185511 | 354.303258144892 | 1762 | 2.1191582929304 | 3.33699861204449 | 0.217004939779769 | weekly | |||||||||
3968 | 3968 | United States | Hawaii | HI | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 1415872 | 210 | 1 | 230.864661655 | -20.8646616549997 | 209 | 0.070627853365276 | -1.47362626388542 | -0.0903761602378953 | weekly | |||||||||
4120 | 4120 | United States | Idaho | ID | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 1787065 | 304 | 4 | 265.197994988236 | 38.8020050117641 | 300 | 0.223830694462708 | 2.17126993208216 | 0.146313342276533 | weekly | |||||||||
4272 | 4272 | United States | Illinois | IL | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 12671821 | 2962 | 790 | 1920.03508771979 | 1041.96491228021 | 2172 | 6.23430523521442 | 8.22269279435224 | 0.542680141078901 | weekly | |||||||||
4424 | 4424 | United States | Indiana | IN | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 6732219 | 1583 | 247 | 1270.12781955021 | 312.872180449791 | 1336 | 3.66892402044556 | 4.64738566065351 | 0.246331255511425 | weekly | |||||||||
4576 | 4576 | United States | Iowa | IA | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 3155070 | 702 | 76 | 560.398496241238 | 141.601503758762 | 626 | 2.40882135737083 | 4.48806219065699 | 0.252680020928903 | weekly | |||||||||
4728 | 4728 | United States | Kansas | KS | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 2913314 | 507 | 31 | 499.726817043346 | 7.27318295665378 | 476 | 1.06408028794699 | 0.249653245638945 | 0.0145543178964977 | weekly | |||||||||
4880 | 4880 | United States | Kentucky | KY | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 4467673 | 1006 | 56 | 913.273182958631 | 92.726817041369 | 950 | 1.25344894310752 | 2.07550590746836 | 0.101532398817375 | weekly | |||||||||
5032 | 5032 | United States | Louisiana | LA | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 4648794 | 1129 | 241 | 881.616541354265 | 247.383458645735 | 888 | 5.18414023077813 | 5.32145452445806 | 0.280602106518697 | weekly | |||||||||
5184 | 5184 | United States | Maine | ME | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 1344212 | 293 | 8 | 276.578947369139 | 16.421052630861 | 285 | 0.595144218322705 | 1.22161181650372 | 0.0593720266385442 | weekly | |||||||||
5336 | 5336 | United States | Maryland | MD | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 6045680 | 1445 | 337 | 914.107769424414 | 530.892230575586 | 1108 | 5.5742282092337 | 8.78134850960663 | 0.580776412074337 | weekly | |||||||||
5488 | 5488 | United States | Massachusetts | MA | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 6949503 | 2071 | 994 | 1073.12531328396 | 997.874686716039 | 1077 | 14.3031811051812 | 14.358935980257 | 0.929877130250855 | weekly | |||||||||
5640 | 5640 | United States | Michigan | MI | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 9986857 | 2241 | 505 | 1838.19799498833 | 402.802005011669 | 1736 | 5.05664594977179 | 4.03332104396477 | 0.219128737007585 | weekly | |||||||||
5792 | 5792 | United States | Minnesota | MN | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 5639632 | 1057 | 164 | 873.93984962484 | 183.06015037516 | 893 | 2.90799115970687 | 3.24595914015596 | 0.209465388783614 | weekly | |||||||||
5944 | 5944 | United States | Mississippi | MS | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 2976149 | 748 | 128 | 598.624060151082 | 149.375939848918 | 620 | 4.30085993678408 | 5.0191015251225 | 0.249532135095302 | weekly | |||||||||
6096 | 6096 | United States | Missouri | MO | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 6137428 | 1427 | 121 | 1180.06015037672 | 246.939849623282 | 1306 | 1.97150988981052 | 4.02350707207126 | 0.209260391976163 | weekly | |||||||||
6248 | 6248 | United States | Montana | MT | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 1068778 | 177 | 0 | 192.42355889806 | -15.4235588980605 | 177 | 0.0 | -1.44310220626365 | -0.0801542128541098 | weekly | |||||||||
6400 | 6400 | United States | Nebraska | NE | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 1934408 | 338 | 17 | 312.593984963453 | 25.4060150365466 | 321 | 0.87882184110074 | 1.31337417114417 | 0.0812748045664311 | weekly | |||||||||
6552 | 6552 | United States | Nevada | NV | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 3080156 | 544 | 49 | 492.854636592312 | 51.1453634076885 | 495 | 1.59082851647774 | 1.6604796447871 | 0.103773728824623 | weekly | |||||||||
6704 | 6704 | United States | New Hampshire | NH | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 1359711 | 292 | 47 | 239.488721805323 | 52.5112781946772 | 245 | 3.45661688402903 | 3.86194405978014 | 0.219264096441931 | weekly | |||||||||
6856 | 6856 | United States | New Jersey | NJ | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 8882190 | 2603 | 1373 | 1347.11779448719 | 1255.88220551281 | 1230 | 15.4578994594802 | 14.1393305650162 | 0.9322734883707 | weekly | |||||||||
7008 | 7008 | United States | New Mexico | NM | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 2096829 | 442 | 53 | 374.97493734418 | 67.0250626558204 | 389 | 2.52762623943106 | 3.19649635978043 | 0.178745446643811 | weekly | |||||||||
7160 | 7160 | United States | New York | NY | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 19453561 | 4851 | 2737 | 2785.56641604089 | 2065.43358395911 | 2114 | 14.0694035400511 | 10.6172519466185 | 0.741477055461742 | weekly | |||||||||
7312 | 7312 | United States | North Carolina | NC | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 10488084 | 2059 | 123 | 1797.37092731886 | 261.629072681142 | 1936 | 1.17275948590801 | 2.49453639655386 | 0.145562092222897 | weekly | |||||||||
7464 | 7464 | United States | North Dakota | ND | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 762062 | 141 | 10 | 143.451127820397 | -2.45112782039683 | 131 | 1.31222918870118 | -0.321644147116223 | -0.0170868494213979 | weekly | |||||||||
7616 | 7616 | United States | Ohio | OH | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 11689100 | 2616 | 310 | 2298.1503759418 | 317.849624058199 | 2306 | 2.65204335663139 | 2.71919672223011 | 0.138306712818104 | weekly | |||||||||
7768 | 7768 | United States | Oklahoma | OK | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 3956971 | 776 | 29 | 716.932330827813 | 59.0676691721874 | 747 | 0.73288381441259 | 1.49274961004737 | 0.0823894622020802 | weekly | |||||||||
7920 | 7920 | United States | Oregon | OR | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 4217737 | 703 | 18 | 698.721804512154 | 4.27819548784555 | 685 | 0.426769141840755 | 0.10143343427638 | 0.00612288819415419 | weekly | |||||||||
8072 | 8072 | United States | Pennsylvania | PA | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 12801989 | 3439 | 1252 | 2405.95238095345 | 1033.04761904655 | 2187 | 9.779730321593 | 8.06943060993527 | 0.429371598218066 | weekly | |||||||||
8224 | 8224 | United States | Rhode Island | RI | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 1059361 | 381 | 122 | 193.689223058493 | 187.310776941507 | 259 | 11.5163763816112 | 17.6814869474624 | 0.967068657634812 | weekly | |||||||||
8376 | 8376 | United States | South Carolina | SC | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 5148714 | 1060 | 62 | 933.471177945798 | 126.528822054202 | 998 | 1.20418419045999 | 2.45748398637412 | 0.135546576095303 | weekly | |||||||||
8528 | 8528 | United States | South Dakota | SD | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 884659 | 181 | 13 | 158.942355890427 | 22.0576441095733 | 168 | 1.46949276500889 | 2.49334987939684 | 0.138777634105157 | weekly | |||||||||
8680 | 8680 | United States | Tennessee | TN | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 6833174 | 1492 | 37 | 1415.36090225651 | 76.639097743486 | 1455 | 0.541476040270597 | 1.12157392367714 | 0.054148095811676 | weekly | |||||||||
8832 | 8832 | United States | Texas | TX | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 28995881 | 4278 | 222 | 3805.11779448672 | 472.882205513283 | 4056 | 0.765625986670314 | 1.63085993322046 | 0.124275313158097 | weekly | |||||||||
8984 | 8984 | United States | Utah | UT | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 3205958 | 372 | 19 | 375.774436091044 | -3.77443609104409 | 353 | 0.592646566174604 | -0.117731925715936 | -0.0100444195467559 | weekly | |||||||||
9136 | 9136 | United States | Vermont | VT | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 623989 | 114 | 3 | 91.9147869682586 | 22.0852130317414 | 111 | 0.480777706017254 | 3.53935935276767 | 0.240279216872561 | weekly | |||||||||
9288 | 9288 | United States | Virginia | VA | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 8535519 | 1593 | 211 | 1300.74185463724 | 292.258145362761 | 1382 | 2.47202308377499 | 3.42402313629389 | 0.224685739388519 | weekly | |||||||||
9440 | 9440 | United States | Washington | WA | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 7614893 | 1211 | 91 | 1089.4561403517 | 121.543859648304 | 1120 | 1.19502664055818 | 1.59613351951635 | 0.111563793296964 | weekly | |||||||||
9592 | 9592 | United States | West Virginia | WV | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 1792147 | 449 | 3 | 417.358395990899 | 31.6416040091009 | 446 | 0.167396982501993 | 1.76556967754882 | 0.07581398700265 | weekly | |||||||||
9744 | 9744 | United States | Wisconsin | WI | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 5822434 | 1080 | 61 | 1058.41353383541 | 21.5864661645903 | 1019 | 1.04767181560152 | 0.370746429493066 | 0.0203951154010349 | weekly | |||||||||
9896 | 9896 | United States | Wyoming | WY | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 578759 | 83 | 0 | 101.278195489551 | -18.2781954895508 | 83 | 0.0 | -3.15817041109525 | -0.180475129925045 | weekly | |||||||||
11944 | 11944 | Canada | Canada | 0 | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 38454328 | 6440 | 1164 | 5516.88210818327 | 923.117891816732 | 5276 | 3.02696747164584 | 2.40055655586214 | 0.167326013809042 | weekly | |||||||||
16995 | 16995 | South Africa | South Africa | 0 | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 59893884 | 9485 | 63 | 10200.4259414226 | -715.425941422573 | 9422 | 0.105186032016224 | -1.19448914253511 | -0.0701368693357547 | weekly |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [economist_excess_deaths] ( [country] TEXT, [region] TEXT, [region_code] INTEGER, [start_date] TEXT, [end_date] TEXT, [days] INTEGER, [year] INTEGER, [week] INTEGER, [population] INTEGER, [total_deaths] INTEGER, [covid_deaths] INTEGER, [expected_deaths] FLOAT, [excess_deaths] FLOAT, [non_covid_deaths] INTEGER, [covid_deaths_per_100k] FLOAT, [excess_deaths_per_100k] FLOAT, [excess_deaths_pct_change] FLOAT, [cadence] TEXT , [month] INTEGER, [total_deaths_per_7_days] FLOAT, [covid_deaths_per_7_days] FLOAT, [expected_deaths_per_7_days] FLOAT, [excess_deaths_per_7_days] FLOAT, [non_covid_deaths_per_7_days] FLOAT, [covid_deaths_per_100k_per_7_days] FLOAT, [excess_deaths_per_100k_per_7_days] FLOAT, [quarter] INTEGER);