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" and "start_date" is on date 2021-07-11 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2358 | 2358 | United States | Alabama | AL | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 4903185 | 1055 | 41 | 1006.37092730574 | 48.6290726942632 | 1014 | 0.8361911696173 | 0.991785394478552 | 0.0483212217034661 | weekly | |||||||||
2510 | 2510 | United States | Alaska | AK | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 731545 | 111 | 2 | 95.9461152920329 | 15.0538847079671 | 109 | 0.273393981231503 | 2.05782073665559 | 0.156899366505328 | weekly | |||||||||
2662 | 2662 | United States | Arizona | AZ | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 7278717 | 1362 | 91 | 1164.21553885741 | 197.784461142589 | 1271 | 1.25022033416054 | 2.71729840770825 | 0.169886463924627 | weekly | |||||||||
2814 | 2814 | United States | Arkansas | AR | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 3017825 | 720 | 33 | 593.432330828618 | 126.567669171382 | 687 | 1.09350277103543 | 4.19400293825459 | 0.213280710531314 | weekly | |||||||||
2966 | 2966 | United States | California | CA | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 39512223 | 5297 | 112 | 4845.57142857185 | 451.428571428151 | 5185 | 0.283456590129085 | 1.14250360307025 | 0.0931631239127564 | weekly | |||||||||
3118 | 3118 | United States | Colorado | CO | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 5758736 | 841 | 47 | 733.132832081216 | 107.867167918784 | 794 | 0.816151322095682 | 1.87310492994962 | 0.147131820044903 | weekly | |||||||||
3270 | 3270 | United States | Connecticut | CT | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 3565287 | 582 | 3 | 572.394736842674 | 9.60526315732579 | 579 | 0.0841446985894824 | 0.269410657748613 | 0.0167808376616256 | weekly | |||||||||
3422 | 3422 | United States | Delaware | DE | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 973764 | 169 | 2 | 167.482456144142 | 1.51754385585829 | 167 | 0.20538857464437 | 0.155843084757528 | 0.00906091235342421 | weekly | |||||||||
3574 | 3574 | United States | District of Columbia | DC | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 705749 | 126 | 3 | 111.281954887631 | 14.7180451123688 | 123 | 0.42508030475424 | 2.08545036725079 | 0.13225904529832 | weekly | |||||||||
3726 | 3726 | United States | Florida | FL | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 21477737 | 4494 | 758 | 3849.3609022566 | 644.639097743402 | 3736 | 3.52923587806294 | 3.00142933002393 | 0.167466526031762 | weekly | |||||||||
3878 | 3878 | United States | Georgia | GA | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 10617423 | 1744 | 72 | 1597.04511278247 | 146.95488721753 | 1672 | 0.678130653737729 | 1.38409185748303 | 0.0920167414441391 | weekly | |||||||||
4030 | 4030 | United States | Hawaii | HI | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 1415872 | 238 | 4 | 237.463659148714 | 0.5363408512859 | 234 | 0.282511413461104 | 0.0378806029984278 | 0.00225862286974188 | weekly | |||||||||
4182 | 4182 | United States | Idaho | ID | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 1787065 | 299 | 8 | 267.463659148588 | 31.5363408514124 | 291 | 0.447661388925417 | 1.76470026839608 | 0.117908881347849 | weekly | |||||||||
4334 | 4334 | United States | Illinois | IL | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 12671821 | 2110 | 67 | 1864.38596491274 | 245.614035087258 | 2043 | 0.528732216151096 | 1.938269449097 | 0.131739907781784 | weekly | |||||||||
4486 | 4486 | United States | Indiana | IN | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 6732219 | 1296 | 26 | 1161.52506265824 | 134.474937341761 | 1270 | 0.386202528467954 | 1.99748310834452 | 0.1157744603754 | weekly | |||||||||
4638 | 4638 | United States | Iowa | IA | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 3155070 | 568 | 9 | 562.097744361458 | 5.90225563854187 | 559 | 0.285255160741283 | 0.187072097878712 | 0.0105004079766355 | weekly | |||||||||
4790 | 4790 | United States | Kansas | KS | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 2913314 | 540 | 21 | 482.590225564617 | 57.4097744353832 | 519 | 0.720828582157639 | 1.97060030039272 | 0.11896174309833 | weekly | |||||||||
4942 | 4942 | United States | Kentucky | KY | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 4467673 | 1011 | 29 | 878.243107770862 | 132.756892229138 | 982 | 0.649107488394965 | 2.97149975455093 | 0.151161894758387 | weekly | |||||||||
5094 | 5094 | United States | Louisiana | LA | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 4648794 | 1037 | 47 | 841.258145364253 | 195.741854635747 | 990 | 1.01101489977831 | 4.21059428823361 | 0.232677514879803 | weekly | |||||||||
5246 | 5246 | United States | Maine | ME | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 1344212 | 305 | 20 | 272.201754386644 | 32.7982456133557 | 285 | 1.48786054580676 | 2.43996078098958 | 0.120492410812195 | weekly | |||||||||
5398 | 5398 | United States | Maryland | MD | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 6045680 | 940 | 18 | 906.161654136192 | 33.8383458638079 | 922 | 0.297733257466488 | 0.559711163406068 | 0.0373425047389195 | weekly | |||||||||
5550 | 5550 | United States | Massachusetts | MA | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 6949503 | 1030 | 8 | 1069.02130325888 | -39.0213032588822 | 1022 | 0.115116145715744 | -0.561497753995965 | -0.0365018949013708 | weekly | |||||||||
5702 | 5702 | United States | Michigan | MI | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 9986857 | 1866 | 50 | 1767.13032581533 | 98.8696741846741 | 1816 | 0.50065801482889 | 0.989997896081561 | 0.0559492827101233 | weekly | |||||||||
5854 | 5854 | United States | Minnesota | MN | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 5639632 | 873 | 13 | 840.576441103521 | 32.4235588964789 | 860 | 0.230511494367008 | 0.574923308763389 | 0.0385730045609092 | weekly | |||||||||
6006 | 6006 | United States | Mississippi | MS | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 2976149 | 710 | 26 | 604.269423559576 | 105.730576440424 | 684 | 0.873612174659266 | 3.55259687738832 | 0.174972574017721 | weekly | |||||||||
6158 | 6158 | United States | Missouri | MO | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 6137428 | 1456 | 87 | 1167.59022556468 | 288.40977443532 | 1369 | 1.41753190424393 | 4.69919605468806 | 0.247012837312711 | weekly | |||||||||
6310 | 6310 | United States | Montana | MT | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 1068778 | 218 | 18 | 184.468671680006 | 33.5313283199945 | 200 | 1.68416640312581 | 3.13735203381755 | 0.181772482094741 | weekly | |||||||||
6462 | 6462 | United States | Nebraska | NE | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 1934408 | 317 | 15 | 310.057644111332 | 6.94235588866837 | 302 | 0.775431036265359 | 0.358887881391535 | 0.0223905329235348 | weekly | |||||||||
6614 | 6614 | United States | Nevada | NV | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 3080156 | 719 | 38 | 508.781954888048 | 210.218045111952 | 681 | 1.23370374747253 | 6.82491552739382 | 0.413179050656796 | weekly | |||||||||
6766 | 6766 | United States | New Hampshire | NH | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 1359711 | 237 | 6 | 216.733082707568 | 20.2669172924324 | 231 | 0.441270240514345 | 1.49053124468599 | 0.0935109538389116 | weekly | |||||||||
6918 | 6918 | United States | New Jersey | NJ | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 8882190 | 1300 | 0 | 1333.84335839696 | -33.8433583969618 | 1300 | 0.0 | -0.381024931880108 | -0.0253728132197137 | weekly | |||||||||
7070 | 7070 | United States | New Mexico | NM | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 2096829 | 404 | 25 | 361.629072682537 | 42.3709273174628 | 379 | 1.19227652803352 | 2.02071448446501 | 0.11716681682465 | weekly | |||||||||
7222 | 7222 | United States | New York | NY | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 19453561 | 2843 | 35 | 2755.18295739428 | 87.8170426057163 | 2808 | 0.179915646292214 | 0.451418856453666 | 0.0318733978700163 | weekly | |||||||||
7374 | 7374 | United States | North Carolina | NC | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 10488084 | 1994 | 40 | 1732.05639097807 | 261.943609021929 | 1954 | 0.381385198669271 | 2.49753538417435 | 0.151232725670099 | weekly | |||||||||
7526 | 7526 | United States | North Dakota | ND | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 762062 | 126 | 5 | 141.343358396867 | -15.3433583968668 | 121 | 0.656114594350591 | -2.0134002741072 | -0.108553798147242 | weekly | |||||||||
7678 | 7678 | United States | Ohio | OH | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 11689100 | 2334 | 57 | 2244.39223057862 | 89.6077694213764 | 2277 | 0.487633778477385 | 0.766592547085544 | 0.0399251825062124 | weekly | |||||||||
7830 | 7830 | United States | Oklahoma | OK | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 3956971 | 779 | 37 | 735.065162907984 | 43.9348370920156 | 742 | 0.935058659767787 | 1.11031486184801 | 0.0597699895315478 | weekly | |||||||||
7982 | 7982 | United States | Oregon | OR | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 4217737 | 790 | 25 | 691.749373434494 | 98.2506265655056 | 765 | 0.592734919223271 | 2.32946308803763 | 0.142032115009656 | weekly | |||||||||
8134 | 8134 | United States | Pennsylvania | PA | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 12801989 | 2431 | 45 | 2314.42857142966 | 116.571428570338 | 2386 | 0.351507878970994 | 0.910572791230628 | 0.0503672612796728 | weekly | |||||||||
8286 | 8286 | United States | Rhode Island | RI | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 1059361 | 195 | 6 | 185.200501253999 | 9.79949874600146 | 189 | 0.566379166308747 | 0.925038655000653 | 0.0529129169718696 | weekly | |||||||||
8438 | 8438 | United States | South Carolina | SC | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 5148714 | 1026 | 16 | 912.206766918245 | 113.793233081755 | 1010 | 0.310757210441287 | 2.21012922997383 | 0.124744999937008 | weekly | |||||||||
8590 | 8590 | United States | South Dakota | SD | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 884659 | 158 | 1 | 148.413533835277 | 9.58646616472333 | 157 | 0.113037905000684 | 1.08363405162027 | 0.0645929378338455 | weekly | |||||||||
8742 | 8742 | United States | Tennessee | TN | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 6833174 | 1510 | 32 | 1410.70802005103 | 99.2919799489728 | 1478 | 0.468303602396192 | 1.45308724684858 | 0.0703845009298105 | weekly | |||||||||
8894 | 8894 | United States | Texas | TX | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 28995881 | 4446 | 200 | 3744.0100250632 | 701.989974936801 | 4246 | 0.689753141144427 | 2.42099895132278 | 0.187496820317662 | weekly | |||||||||
9046 | 9046 | United States | Utah | UT | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 3205958 | 384 | 20 | 359.328320802832 | 24.6716791971676 | 364 | 0.623838490710109 | 0.769557155682253 | 0.0686605473847559 | weekly | |||||||||
9198 | 9198 | United States | Vermont | VT | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 623989 | 139 | 0 | 90.2055137853128 | 48.7944862146872 | 139 | 0.0 | 7.81976704952927 | 0.540925761265736 | weekly | |||||||||
9350 | 9350 | United States | Virginia | VA | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 8535519 | 1425 | 27 | 1312.27944862221 | 112.720551377789 | 1398 | 0.316325228729501 | 1.3206057110035 | 0.085896758877186 | weekly | |||||||||
9502 | 9502 | United States | Washington | WA | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 7614893 | 1226 | 45 | 1084.01754386047 | 141.982456139527 | 1181 | 0.590947239836463 | 1.86453645690789 | 0.130978005793052 | weekly | |||||||||
9654 | 9654 | United States | West Virginia | WV | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 1792147 | 407 | 11 | 408.537593985933 | -1.53759398593252 | 396 | 0.613788935840643 | -0.085796197852772 | -0.00376365359900133 | weekly | |||||||||
9806 | 9806 | United States | Wisconsin | WI | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 5822434 | 957 | 10 | 1018.12030075272 | -61.1203007527243 | 947 | 0.171749477967462 | -1.04973797474947 | -0.0600324939081722 | weekly | |||||||||
9958 | 9958 | United States | Wyoming | WY | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 578759 | 108 | 9 | 92.0839599005945 | 15.9160400994055 | 99 | 1.55505141172751 | 2.75002895841023 | 0.17284269830041 | 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);