economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
51 rows where cadence = "weekly", country = "United States", end_date = "2021-02-13" and week = 6 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date), end_date (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2336 | 2336 | United States | Alabama | AL | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 4903185 | 1432 | 722 | 1123.6146616433 | 308.385338356701 | 710 | 14.7251225478949 | 6.28949016520284 | 0.274458271936114 | weekly | |||||||||
| 2488 | 2488 | United States | Alaska | AK | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 731545 | 93 | 6 | 85.3439849657393 | 7.65601503426069 | 87 | 0.82018194369451 | 1.04655421529239 | 0.089707728521631 | weekly | |||||||||
| 2640 | 2640 | United States | Arizona | AZ | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 7278717 | 1740 | 939 | 1307.87406015956 | 432.125939840442 | 801 | 12.9006252063379 | 5.93684216381048 | 0.330403326286419 | weekly | |||||||||
| 2792 | 2792 | United States | Arkansas | AR | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 3017825 | 803 | 191 | 669.693609024015 | 133.306390975985 | 612 | 6.32906149296265 | 4.41730024027189 | 0.199055790856748 | weekly | |||||||||
| 2944 | 2944 | United States | California | CA | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 39512223 | 7864 | 2216 | 5692.8928571434 | 2171.1071428566 | 5648 | 5.60839110469689 | 5.49477345999136 | 0.381371509588892 | weekly | |||||||||
| 3096 | 3096 | United States | Colorado | CO | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 5758736 | 833 | 97 | 854.721804512343 | -21.7218045123426 | 736 | 1.68439740943151 | -0.377197435554306 | -0.0254138883525218 | weekly | |||||||||
| 3248 | 3248 | United States | Connecticut | CT | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 3565287 | 734 | 167 | 686.578947369105 | 47.421052630895 | 567 | 4.68405488814785 | 1.33007672680755 | 0.0690686086612577 | weekly | |||||||||
| 3400 | 3400 | United States | Delaware | DE | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 973764 | 234 | 80 | 189.513157898126 | 44.4868421018745 | 154 | 8.21554298577479 | 4.56854454486657 | 0.23474276190252 | weekly | |||||||||
| 3552 | 3552 | United States | District of Columbia | DC | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 705749 | 153 | 32 | 127.484962406444 | 25.5150375935556 | 121 | 4.53418991737856 | 3.61531331869484 | 0.20014154698661 | weekly | |||||||||
| 3704 | 3704 | United States | Florida | FL | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 21477737 | 5460 | 1085 | 4463.8007518807 | 996.199248119296 | 4375 | 5.05174264867849 | 4.63828776802368 | 0.223172875200483 | weekly | |||||||||
| 3856 | 3856 | United States | Georgia | GA | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 10617423 | 2387 | 638 | 1829.53759398547 | 557.462406014527 | 1749 | 6.00899107062043 | 5.2504492475672 | 0.304701257764345 | weekly | |||||||||
| 4008 | 4008 | United States | Hawaii | HI | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 1415872 | 265 | 9 | 226.830827068557 | 38.1691729314427 | 256 | 0.635650680287484 | 2.69580674887579 | 0.168271541503953 | weekly | |||||||||
| 4160 | 4160 | United States | Idaho | ID | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 1787065 | 305 | 37 | 291.580827068445 | 13.4191729315549 | 268 | 2.07043392378005 | 0.750905699096278 | 0.0460221375543493 | weekly | |||||||||
| 4312 | 4312 | United States | Illinois | IL | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 12671821 | 2476 | 411 | 2226.46052631631 | 249.539473683691 | 2065 | 3.24341702743434 | 1.9692471483277 | 0.112079001955878 | weekly | |||||||||
| 4464 | 4464 | United States | Indiana | IN | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 6732219 | 1512 | 397 | 1418.15977443759 | 93.8402255624098 | 1115 | 5.8970155308376 | 1.39389739939253 | 0.0661704183505167 | weekly | |||||||||
| 4616 | 4616 | United States | Iowa | IA | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 3155070 | 611 | 128 | 631.998120301382 | -20.9981203013816 | 483 | 4.05696228609825 | -0.665535797981713 | -0.0332249727125268 | weekly | |||||||||
| 4768 | 4768 | United States | Kansas | KS | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 2913314 | 583 | 263 | 549.575187970682 | 33.4248120293183 | 320 | 9.02751986225996 | 1.1473123744752 | 0.060819361501272 | weekly | |||||||||
| 4920 | 4920 | United States | Kentucky | KY | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 4467673 | 1170 | 252 | 1006.42481203144 | 163.575187968555 | 918 | 5.64052024398384 | 3.66130618710357 | 0.16253095711977 | weekly | |||||||||
| 5072 | 5072 | United States | Louisiana | LA | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 4648794 | 1166 | 200 | 968.520676692628 | 197.479323307372 | 966 | 4.30219106288642 | 4.24796889918916 | 0.203897890937897 | weekly | |||||||||
| 5224 | 5224 | United States | Maine | ME | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 1344212 | 327 | 13 | 311.473684211258 | 15.5263157887424 | 314 | 0.967109354774396 | 1.15504963419032 | 0.0498479215926686 | weekly | |||||||||
| 5376 | 5376 | United States | Maryland | MD | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 6045680 | 1295 | 202 | 1047.96804511367 | 247.031954886331 | 1093 | 3.34122877823504 | 4.08609047925677 | 0.235724701757997 | weekly | |||||||||
| 5528 | 5528 | United States | Massachusetts | MA | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 6949503 | 1363 | 503 | 1242.32330827146 | 120.676691728542 | 860 | 7.2379276618774 | 1.73647945368959 | 0.0971379116249929 | weekly | |||||||||
| 5680 | 5680 | United States | Michigan | MI | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 9986857 | 2080 | 265 | 2038.33082706853 | 41.6691729314732 | 1815 | 2.65348747859312 | 0.417240107988662 | 0.0204427919050809 | weekly | |||||||||
| 5832 | 5832 | United States | Minnesota | MN | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 5639632 | 914 | 80 | 949.424812030879 | -35.4248120308787 | 834 | 1.41853227302774 | -0.628140489146786 | -0.0373118667028544 | weekly | |||||||||
| 5984 | 5984 | United States | Mississippi | MS | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 2976149 | 793 | 196 | 693.280075188696 | 99.7199248113041 | 597 | 6.58569177820062 | 3.35063616812546 | 0.143837863484195 | weekly | |||||||||
| 6136 | 6136 | United States | Missouri | MO | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 6137428 | 1429 | 311 | 1354.32518797073 | 74.6748120292668 | 1118 | 5.06726922091795 | 1.21671182178051 | 0.0551380220146069 | weekly | |||||||||
| 6288 | 6288 | United States | Montana | MT | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 1068778 | 222 | 17 | 213.862781955733 | 8.13721804426669 | 205 | 1.59060160295216 | 0.761357180281283 | 0.0380487804836982 | weekly | |||||||||
| 6440 | 6440 | United States | Nebraska | NE | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 1934408 | 341 | 43 | 357.742481204095 | -16.7424812040949 | 298 | 2.22290230396069 | -0.865509303316305 | -0.0468003720098961 | weekly | |||||||||
| 6592 | 6592 | United States | Nevada | NV | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 3080156 | 702 | 227 | 566.984962406878 | 135.015037593122 | 475 | 7.3697565967438 | 4.3833831011521 | 0.238128074896338 | weekly | |||||||||
| 6744 | 6744 | United States | New Hampshire | NH | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 1359711 | 258 | 32 | 255.61090225648 | 2.38909774351964 | 226 | 2.35344128274317 | 0.175706289315865 | 0.00934661910908008 | weekly | |||||||||
| 6896 | 6896 | United States | New Jersey | NJ | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 8882190 | 1865 | 476 | 1583.81390977545 | 281.186090224552 | 1389 | 5.35903870554447 | 3.1657292877607 | 0.177537328400164 | weekly | |||||||||
| 7048 | 7048 | United States | New Mexico | NM | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 2096829 | 475 | 130 | 411.635338346722 | 63.3646616532777 | 345 | 6.19983794577431 | 3.02192795183955 | 0.153933969585248 | weekly | |||||||||
| 7200 | 7200 | United States | New York | NY | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 19453561 | 4128 | 1093 | 3303.54135338429 | 824.458646615712 | 3035 | 5.61850861135398 | 4.23808600705913 | 0.249568132625645 | weekly | |||||||||
| 7352 | 7352 | United States | North Carolina | NC | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 10488084 | 2532 | 527 | 2094.79699248182 | 437.203007518178 | 2005 | 5.02474999246764 | 4.16856889702807 | 0.208709010509032 | weekly | |||||||||
| 7504 | 7504 | United States | North Dakota | ND | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 762062 | 119 | 4 | 143.813909775332 | -24.813909775332 | 115 | 0.524891675480473 | -3.25615366929883 | -0.172541792474015 | weekly | |||||||||
| 7656 | 7656 | United States | Ohio | OH | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 11689100 | 2947 | 4687 | 2527.18796992692 | 419.812030073083 | -1740 | 40.0971845565527 | 3.59148292061051 | 0.166118244890673 | weekly | |||||||||
| 7808 | 7808 | United States | Oklahoma | OK | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 3956971 | 986 | 213 | 847.6654135346 | 138.3345864654 | 773 | 5.38290525758213 | 3.49597170323967 | 0.163194798627646 | weekly | |||||||||
| 7960 | 7960 | United States | Oregon | OR | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 4217737 | 793 | 92 | 748.652255640025 | 44.3477443599754 | 701 | 2.18126450274164 | 1.05145826683777 | 0.0592367738504473 | weekly | |||||||||
| 8112 | 8112 | United States | Pennsylvania | PA | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 12801989 | 3235 | 564 | 2789.85714285827 | 445.142857141728 | 2671 | 4.40556541643646 | 3.47713825673283 | 0.159557581032866 | weekly | |||||||||
| 8264 | 8264 | United States | Rhode Island | RI | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 1059361 | 249 | 67 | 238.528195489615 | 10.4718045103848 | 182 | 6.32456735711434 | 0.988501984723322 | 0.0439017470823098 | weekly | |||||||||
| 8416 | 8416 | United States | South Carolina | SC | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 5148714 | 1368 | 302 | 1080.00563909871 | 287.994360901286 | 1066 | 5.86554234707929 | 5.59352026353156 | 0.266660052943449 | weekly | |||||||||
| 8568 | 8568 | United States | South Dakota | SD | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 884659 | 181 | 34 | 167.761278196219 | 13.2387218037806 | 147 | 3.84328877002325 | 1.49647737758623 | 0.0789140494524376 | weekly | |||||||||
| 8720 | 8720 | United States | Tennessee | TN | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 6833174 | 1774 | 486 | 1640.70112782046 | 133.29887217954 | 1288 | 7.11236096139217 | 1.95076068865712 | 0.0812450664653448 | weekly | |||||||||
| 8872 | 8872 | United States | Texas | TX | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 28995881 | 5896 | 1420 | 4373.31390977497 | 1522.68609022503 | 4476 | 4.89724730212543 | 5.2513875685482 | 0.348176719448748 | weekly | |||||||||
| 9024 | 9024 | United States | Utah | UT | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 3205958 | 450 | 57 | 407.218045113636 | 42.7819548863645 | 393 | 1.77793969852381 | 1.33445150829688 | 0.105059084192662 | weekly | |||||||||
| 9176 | 9176 | United States | Vermont | VT | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 623989 | 113 | 7 | 116.060150376821 | -3.06015037682084 | 106 | 1.12181464737359 | -0.49041735941192 | -0.0263669344463645 | weekly | |||||||||
| 9328 | 9328 | United States | Virginia | VA | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 8535519 | 1801 | 228 | 1523.09398496308 | 277.906015036916 | 1573 | 2.67119082038245 | 3.25587717673543 | 0.182461501247181 | weekly | |||||||||
| 9480 | 9480 | United States | Washington | WA | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 7614893 | 1236 | 226 | 1196.48684210612 | 39.5131578938842 | 1010 | 2.96786836006757 | 0.51889314654696 | 0.0330243146045226 | weekly | |||||||||
| 9632 | 9632 | United States | West Virginia | WV | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 1792147 | 574 | 80 | 473.864661655116 | 100.135338344884 | 494 | 4.46391953338649 | 5.58745116024989 | 0.211316323937578 | weekly | |||||||||
| 9784 | 9784 | United States | Wisconsin | WI | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 5822434 | 1144 | 104 | 1129.51691729409 | 14.4830827059075 | 1040 | 1.7861945708616 | 0.248746189409918 | 0.0128223690005491 | weekly | |||||||||
| 9936 | 9936 | United States | Wyoming | WY | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 578759 | 102 | 23 | 100.597744361772 | 1.40225563822754 | 79 | 3.97402027441474 | 0.242286623314289 | 0.0139392353886656 | 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);