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 2022-07-24 and week = 30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2412 | 2412 | United States | Alabama | AL | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 4903185 | 1099 | 19 | 950.05012529628 | 148.94987470372 | 1080 | 0.387503224944602 | 3.037818779094 | 0.15678106948017 | weekly | |||||||||
2564 | 2564 | United States | Alaska | AK | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 731545 | 118 | 0 | 81.8170426113686 | 36.1829573886314 | 118 | 0.0 | 4.94610138660389 | 0.442242303483159 | weekly | |||||||||
2716 | 2716 | United States | Arizona | AZ | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 7278717 | 1352 | 0 | 1148.73182958653 | 203.268170413469 | 1352 | 0.0 | 2.79263736196186 | 0.176950063694703 | weekly | |||||||||
2868 | 2868 | United States | Arkansas | AR | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 3017825 | 650 | 41 | 565.576441104568 | 84.4235588954324 | 609 | 1.35859435189251 | 2.79749683614631 | 0.149269935520217 | weekly | |||||||||
3020 | 3020 | United States | California | CA | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 39512223 | 5651 | 290 | 4798.09523809548 | 852.904761904517 | 5361 | 0.73395009944138 | 2.15858460280637 | 0.177759031361591 | weekly | |||||||||
3172 | 3172 | United States | Colorado | CO | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 5758736 | 829 | 46 | 748.621553885708 | 80.3784461142918 | 783 | 0.798786400348965 | 1.39576542689736 | 0.107368597253297 | weekly | |||||||||
3324 | 3324 | United States | Connecticut | CT | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 3565287 | 597 | 0 | 560.19298245656 | 36.8070175434403 | 597 | 0.0 | 1.03237179905686 | 0.0657041746257407 | weekly | |||||||||
3476 | 3476 | United States | Delaware | DE | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 973764 | 222 | 3 | 165.42105263625 | 56.5789473637498 | 219 | 0.308082861966554 | 5.8103346769597 | 0.34202990769357 | weekly | |||||||||
3628 | 3628 | United States | District of Columbia | DC | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 705749 | 129 | 1 | 103.709273183416 | 25.2907268165842 | 128 | 0.14169343491808 | 3.58352995421661 | 0.243861768965019 | weekly | |||||||||
3780 | 3780 | United States | Florida | FL | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 21477737 | 4469 | 445 | 3847.14786967512 | 621.852130324884 | 4024 | 2.07191288355938 | 2.89533357413253 | 0.161639778711547 | weekly | |||||||||
3932 | 3932 | United States | Georgia | GA | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 10617423 | 1864 | 117 | 1638.06015037652 | 225.939849623481 | 1747 | 1.10196231232381 | 2.12801024903577 | 0.137931351038329 | weekly | |||||||||
4084 | 4084 | United States | Hawaii | HI | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 1415872 | 236 | 23 | 233.395989975776 | 2.6040100242239 | 213 | 1.62444062740135 | 0.183915638152594 | 0.0111570469762319 | weekly | |||||||||
4236 | 4236 | United States | Idaho | ID | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 1787065 | 324 | 18 | 261.395989975619 | 62.6040100243808 | 306 | 1.00723812508219 | 3.50317475997688 | 0.239498739174308 | weekly | |||||||||
4388 | 4388 | United States | Illinois | IL | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 12671821 | 2115 | 70 | 1833.40350877236 | 281.596491227639 | 2045 | 0.552406792993683 | 2.22222592339048 | 0.15359220699659 | weekly | |||||||||
4540 | 4540 | United States | Indiana | IN | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 6732219 | 1366 | 45 | 1179.58897243295 | 186.411027567051 | 1321 | 0.668427453117613 | 2.76893885310403 | 0.158030493607084 | weekly | |||||||||
4692 | 4692 | United States | Iowa | IA | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 3155070 | 595 | 23 | 557.796992481691 | 37.2030075183088 | 572 | 0.728985410783279 | 1.17914998774382 | 0.0666963214570038 | weekly | |||||||||
4844 | 4844 | United States | Kansas | KS | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 2913314 | 517 | 5 | 485.786967419234 | 31.2130325807664 | 512 | 0.171625852894676 | 1.07139266762067 | 0.0642525112326233 | weekly | |||||||||
4996 | 4996 | United States | Kentucky | KY | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 4467673 | 995 | 59 | 876.879699249771 | 118.120300750229 | 936 | 1.32059799363114 | 2.64388868098065 | 0.134705251873533 | weekly | |||||||||
5148 | 5148 | United States | Louisiana | LA | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 4648794 | 966 | 55 | 826.899749374252 | 139.100250625748 | 911 | 1.18310254229376 | 2.99217927543677 | 0.168219002038652 | weekly | |||||||||
5300 | 5300 | United States | Maine | ME | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 1344212 | 301 | 2 | 269.157894737496 | 31.8421052625038 | 299 | 0.148786054580676 | 2.36883060577527 | 0.118302698472058 | weekly | |||||||||
5452 | 5452 | United States | Maryland | MD | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 6045680 | 992 | 65 | 899.882205514649 | 92.1177944853509 | 927 | 1.07514787418454 | 1.52369616793067 | 0.10236650299432 | weekly | |||||||||
5604 | 5604 | United States | Massachusetts | MA | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 6949503 | 1123 | 0 | 1041.58395990047 | 81.4160400995268 | 1123 | 0.0 | 1.171537591962 | 0.0781656047269643 | weekly | |||||||||
5756 | 5756 | United States | Michigan | MI | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 9986857 | 1934 | 137 | 1721.06265664234 | 212.937343357662 | 1797 | 1.37180296063116 | 2.13217575216769 | 0.123724341200387 | weekly | |||||||||
5908 | 5908 | United States | Minnesota | MN | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 5639632 | 917 | 0 | 859.879699248878 | 57.1203007511219 | 917 | 0.0 | 1.01283737575647 | 0.0664282466501043 | weekly | |||||||||
6060 | 6060 | United States | Mississippi | MS | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 2976149 | 677 | 31 | 554.914786968085 | 122.085213031915 | 646 | 1.04161451593989 | 4.10212032502119 | 0.220007136048686 | weekly | |||||||||
6212 | 6212 | United States | Missouri | MO | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 6137428 | 1285 | 0 | 1171.45363408599 | 113.546365914014 | 1285 | 0.0 | 1.85006432521919 | 0.096927750796221 | weekly | |||||||||
6364 | 6364 | United States | Montana | MT | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 1068778 | 225 | 6 | 212.847117795299 | 12.1528822047012 | 219 | 0.561388801041938 | 1.13708199501685 | 0.0570967665927662 | weekly | |||||||||
6516 | 6516 | United States | Nebraska | NE | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 1934408 | 344 | 3 | 294.187969925889 | 49.812030074111 | 341 | 0.155086207253072 | 2.57505293992327 | 0.16932041812131 | weekly | |||||||||
6668 | 6668 | United States | Nevada | NV | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 3080156 | 575 | 32 | 478.709273183795 | 96.2907268162051 | 543 | 1.03890841892424 | 3.12616396105279 | 0.201146566841698 | weekly | |||||||||
6820 | 6820 | United States | New Hampshire | NH | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 1359711 | 246 | 9 | 227.977443609828 | 18.0225563901724 | 237 | 0.661905360771517 | 1.32546963216245 | 0.079054120902492 | weekly | |||||||||
6972 | 6972 | United States | New Jersey | NJ | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 8882190 | 1417 | 48 | 1316.56892230675 | 100.431077693255 | 1369 | 0.540407264424652 | 1.13070174915482 | 0.0762824307878167 | weekly | |||||||||
7124 | 7124 | United States | New Mexico | NM | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 2096829 | 400 | 55 | 345.61654135424 | 54.3834586457596 | 345 | 2.62300836167375 | 2.59360485026483 | 0.157352013398049 | weekly | |||||||||
7276 | 7276 | United States | New York | NY | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 19453561 | 3096 | 171 | 2730.79949874769 | 365.200501252308 | 2925 | 0.879016443313386 | 1.87729383454427 | 0.133733912511623 | weekly | |||||||||
7428 | 7428 | United States | North Carolina | NC | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 10488084 | 2043 | 48 | 1773.40852130396 | 269.59147869604 | 1995 | 0.457662238403125 | 2.57045499155079 | 0.152018824460037 | weekly | |||||||||
7580 | 7580 | United States | North Dakota | ND | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 762062 | 132 | 0 | 137.568922306684 | -5.56892230668439 | 132 | 0.0 | -0.730770240044036 | -0.0404809619302644 | weekly | |||||||||
7732 | 7732 | United States | Ohio | OH | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 11689100 | 2480 | 54 | 2139.96741854879 | 340.03258145121 | 2426 | 0.461968842768049 | 2.90897144734163 | 0.158896148840342 | weekly | |||||||||
7884 | 7884 | United States | Oklahoma | OK | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 3956971 | 837 | 36 | 709.5313283215 | 127.4686716785 | 801 | 0.909786804098387 | 3.22136987302913 | 0.179651928802137 | weekly | |||||||||
8036 | 8036 | United States | Oregon | OR | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 4217737 | 765 | 79 | 669.776942356847 | 95.2230576431532 | 686 | 1.87304234474554 | 2.25768125521229 | 0.142171298564082 | weekly | |||||||||
8188 | 8188 | United States | Pennsylvania | PA | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 12801989 | 2590 | 117 | 2293.23809523921 | 296.761904760788 | 2473 | 0.913920485324585 | 2.31809217115237 | 0.12940736741504 | weekly | |||||||||
8340 | 8340 | United States | Rhode Island | RI | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 1059361 | 201 | 4 | 180.71177944952 | 20.2882205504803 | 197 | 0.377586110872498 | 1.91513757354484 | 0.112268390097656 | weekly | |||||||||
8492 | 8492 | United States | South Carolina | SC | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 5148714 | 1096 | 0 | 963.942355890707 | 132.057644109293 | 1096 | 0.0 | 2.56486656880325 | 0.136997449383027 | weekly | |||||||||
8644 | 8644 | United States | South Dakota | SD | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 884659 | 178 | 9 | 154.884711780142 | 23.1152882198576 | 169 | 1.01734114500615 | 2.61290375385969 | 0.149241897112929 | weekly | |||||||||
8796 | 8796 | United States | Tennessee | TN | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 6833174 | 1548 | 83 | 1433.72180451222 | 114.278195487784 | 1465 | 1.21466246871512 | 1.6724028319458 | 0.0797073707940603 | weekly | |||||||||
8948 | 8948 | United States | Texas | TX | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 28995881 | 4628 | 187 | 3833.56892230636 | 794.431077693644 | 4441 | 0.644919186970039 | 2.73980665630972 | 0.207230153883786 | weekly | |||||||||
9100 | 9100 | United States | Utah | UT | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 3205958 | 408 | 16 | 366.215538847968 | 41.7844611520318 | 392 | 0.499070792568087 | 1.30333775901094 | 0.114098001639899 | weekly | |||||||||
9252 | 9252 | United States | Vermont | VT | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 623989 | 147 | 4 | 94.8295739357138 | 52.1704260642862 | 143 | 0.641036941356338 | 8.36079258837675 | 0.550149324720716 | weekly | |||||||||
9404 | 9404 | United States | Virginia | VA | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 8535519 | 1462 | 51 | 1275.48370927386 | 186.516290726141 | 1411 | 0.59750320982239 | 2.18517808613795 | 0.146231809446101 | weekly | |||||||||
9556 | 9556 | United States | Washington | WA | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 7614893 | 1355 | 73 | 1038.24561403593 | 316.754385964075 | 1282 | 0.958647744623595 | 4.1596695575903 | 0.305086177761705 | weekly | |||||||||
9708 | 9708 | United States | West Virginia | WV | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 1792147 | 465 | 35 | 422.050125314314 | 42.9498746856858 | 430 | 1.95296479585659 | 2.39655980707419 | 0.10176486656342 | weekly | |||||||||
9860 | 9860 | United States | Wisconsin | WI | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 5822434 | 1060 | 29 | 1031.82706767004 | 28.1729323299608 | 1031 | 0.498073486105639 | 0.483868642048339 | 0.0273039283545622 | weekly | |||||||||
10012 | 10012 | United States | Wyoming | WY | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 578759 | 111 | 7 | 97.2230576449827 | 13.7769423550173 | 104 | 1.20948443134362 | 2.38042818427313 | 0.141704475139271 | weekly | |||||||||
12060 | 12060 | Canada | Canada | 0 | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 38454328 | 5290 | 266 | 5379.47018030518 | -89.4701803051757 | 5024 | 0.691729679946559 | -0.232666087170151 | -0.0166317829277575 | weekly | |||||||||
17111 | 17111 | South Africa | South Africa | 0 | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 59893884 | 10858 | 39 | 10529.3765690375 | 328.623430962463 | 10819 | 0.06511516267671 | 0.548676106833317 | 0.0312101508392095 | 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);