economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where "start_date" is on date 2021-07-04 and week = 27 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date), end_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2357 | 2357 | United States | Alabama | AL | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 4903185 | 1133 | 44 | 997.704260639053 | 135.295739360947 | 1089 | 0.897375889345395 | 2.75934396440166 | 0.13560705782121 | weekly | |||||||||
2509 | 2509 | United States | Alaska | AK | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 731545 | 98 | 2 | 91.2794486253973 | 6.72055137460268 | 96 | 0.273393981231503 | 0.918679148186739 | 0.0736261171140857 | weekly | |||||||||
2661 | 2661 | United States | Arizona | AZ | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 7278717 | 1299 | 48 | 1185.21553885743 | 113.784461142568 | 1251 | 0.659456879557208 | 1.56324886848284 | 0.0960031803601378 | weekly | |||||||||
2813 | 2813 | United States | Arkansas | AR | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 3017825 | 683 | 35 | 595.432330828647 | 87.5676691713534 | 648 | 1.1597756662497 | 2.90168148157542 | 0.147065694349327 | weekly | |||||||||
2965 | 2965 | United States | California | CA | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 39512223 | 5283 | 94 | 4871.90476190521 | 411.095238094786 | 5189 | 0.237901066715482 | 1.04042548579154 | 0.0843808034404232 | weekly | |||||||||
3117 | 3117 | United States | Colorado | CO | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 5758736 | 837 | 23 | 761.132832081241 | 75.8671679187592 | 814 | 0.399393200174483 | 1.31742743405426 | 0.0996766460741261 | weekly | |||||||||
3269 | 3269 | United States | Connecticut | CT | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 3565287 | 612 | 0 | 583.394736842704 | 28.6052631572957 | 612 | 0.0 | 0.802327082147823 | 0.0490324326751823 | weekly | |||||||||
3421 | 3421 | United States | Delaware | DE | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 973764 | 174 | 0 | 181.48245614417 | -7.48245614417047 | 174 | 0.0 | -0.76840550114509 | -0.0412296389587453 | weekly | |||||||||
3573 | 3573 | United States | District of Columbia | DC | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 705749 | 149 | 2 | 101.281954887662 | 47.7180451123383 | 147 | 0.28338686983616 | 6.76133371954311 | 0.471140640652775 | weekly | |||||||||
3725 | 3725 | United States | Florida | FL | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 21477737 | 4463 | 179 | 3996.02756892329 | 466.972431076715 | 4284 | 0.833421137431751 | 2.17421617126942 | 0.116859161510374 | weekly | |||||||||
3877 | 3877 | United States | Georgia | GA | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 10617423 | 1758 | 43 | 1581.71177944916 | 176.288220550839 | 1715 | 0.404994695982255 | 1.66036730900558 | 0.111454073264999 | weekly | |||||||||
4029 | 4029 | United States | Hawaii | HI | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 1415872 | 235 | 1 | 215.796992482078 | 19.2030075179223 | 234 | 0.070627853365276 | 1.35626719914811 | 0.0889864464608658 | weekly | |||||||||
4181 | 4181 | United States | Idaho | ID | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 1787065 | 290 | 7 | 272.463659148617 | 17.5363408513832 | 283 | 0.39170371530974 | 0.981292837774967 | 0.0643621278014839 | weekly | |||||||||
4333 | 4333 | United States | Illinois | IL | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 12671821 | 2102 | 60 | 1864.7192982461 | 237.280701753896 | 2042 | 0.473491536851728 | 1.87250673564515 | 0.127247410362018 | weekly | |||||||||
4485 | 4485 | United States | Indiana | IN | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 6732219 | 1338 | 51 | 1213.52506265827 | 124.474937341732 | 1287 | 0.757551113533294 | 1.84894367431796 | 0.102573025619318 | weekly | |||||||||
4637 | 4637 | United States | Iowa | IA | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 3155070 | 574 | 7 | 535.097744361488 | 38.9022556385122 | 567 | 0.221865125020998 | 1.23300768726248 | 0.0727012140276031 | weekly | |||||||||
4789 | 4789 | United States | Kansas | KS | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 2913314 | 541 | 17 | 489.590225564646 | 51.4097744353538 | 524 | 0.583527899841898 | 1.7646492769181 | 0.105005720602495 | weekly | |||||||||
4941 | 4941 | United States | Kentucky | KY | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 4467673 | 990 | 26 | 910.576441104224 | 79.4235588957761 | 964 | 0.581958437871348 | 1.77773885635265 | 0.087223384342628 | weekly | |||||||||
5093 | 5093 | United States | Louisiana | LA | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 4648794 | 991 | 24 | 826.92481203095 | 164.07518796905 | 967 | 0.51626292754637 | 3.52941403660928 | 0.198416090050651 | weekly | |||||||||
5245 | 5245 | United States | Maine | ME | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 1344212 | 318 | 2 | 277.201754386673 | 40.7982456133266 | 316 | 0.148786054580676 | 3.03510499931012 | 0.147178886741158 | weekly | |||||||||
5397 | 5397 | United States | Maryland | MD | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 6045680 | 884 | 15 | 922.828320802888 | -38.8283208028876 | 869 | 0.24811104788874 | -0.642249024144307 | -0.0420753458986887 | weekly | |||||||||
5549 | 5549 | United States | Massachusetts | MA | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 6949503 | 1133 | 15 | 1098.35463659225 | 34.6453634077545 | 1118 | 0.21584277321702 | 0.498530087802747 | 0.0315429664095062 | weekly | |||||||||
5701 | 5701 | United States | Michigan | MI | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 9986857 | 1913 | 50 | 1811.13032581536 | 101.869674184645 | 1863 | 0.50065801482889 | 1.020037376971 | 0.0562464626275769 | weekly | |||||||||
5853 | 5853 | United States | Minnesota | MN | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 5639632 | 892 | 12 | 835.243107770215 | 56.756892229785 | 880 | 0.212779840954162 | 1.00639354180884 | 0.0679525418429425 | weekly | |||||||||
6005 | 6005 | United States | Mississippi | MS | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 2976149 | 662 | 20 | 573.936090226273 | 88.0639097737269 | 642 | 0.672009365122512 | 2.95898860486242 | 0.153438529608772 | weekly | |||||||||
6157 | 6157 | United States | Missouri | MO | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 6137428 | 1393 | 48 | 1204.25689223138 | 188.743107768623 | 1345 | 0.782086567858719 | 3.07528019503648 | 0.156729937761784 | weekly | |||||||||
6309 | 6309 | United States | Montana | MT | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 1068778 | 196 | 7 | 197.135338346702 | -1.1353383467025 | 189 | 0.654953601215594 | -0.106227705538708 | -0.00575918227662342 | weekly | |||||||||
6461 | 6461 | United States | Nebraska | NE | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 1934408 | 301 | 2 | 316.390977444695 | -15.3909774446951 | 299 | 0.103390804835381 | -0.795642772605111 | -0.0486454372656231 | weekly | |||||||||
6613 | 6613 | United States | Nevada | NV | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 3080156 | 637 | 23 | 503.448621554742 | 133.551378445258 | 614 | 0.746715426101795 | 4.33586410705361 | 0.265273103803179 | weekly | |||||||||
6765 | 6765 | United States | New Hampshire | NH | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 1359711 | 244 | 3 | 219.399749374264 | 24.6002506257358 | 241 | 0.220635120257172 | 1.8092264183886 | 0.112125244882442 | weekly | |||||||||
6917 | 6917 | United States | New Jersey | NJ | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 8882190 | 1387 | 80 | 1365.51002506366 | 21.489974936344 | 1307 | 0.900678774041087 | 0.241944553498 | 0.0157376910765208 | weekly | |||||||||
7069 | 7069 | United States | New Mexico | NM | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 2096829 | 388 | 10 | 354.9624060159 | 33.0375939840998 | 378 | 0.476910611213408 | 1.57559791399775 | 0.0930735013741708 | weekly | |||||||||
7221 | 7221 | United States | New York | NY | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 19453561 | 2897 | 34 | 2853.51629072765 | 43.4837092723542 | 2863 | 0.174775199255293 | 0.223525704483381 | 0.0152386406251306 | weekly | |||||||||
7373 | 7373 | United States | North Carolina | NC | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 10488084 | 1946 | 49 | 1828.38972431143 | 117.610275688575 | 1897 | 0.467196868369857 | 1.12137045897587 | 0.0643245114128319 | weekly | |||||||||
7525 | 7525 | United States | North Dakota | ND | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 762062 | 141 | 4 | 132.010025063562 | 8.98997493643756 | 137 | 0.524891675480473 | 1.17969075172854 | 0.0681006986560977 | weekly | |||||||||
7677 | 7677 | United States | Ohio | OH | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 11689100 | 2354 | 36 | 2207.05889724532 | 146.941102754683 | 2318 | 0.307979228512033 | 1.25707798508596 | 0.0665777895361486 | weekly | |||||||||
7829 | 7829 | United States | Oklahoma | OK | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 3956971 | 822 | 32 | 703.398496241346 | 118.601503758654 | 790 | 0.808699381420789 | 2.99728008516246 | 0.168612108772493 | weekly | |||||||||
7981 | 7981 | United States | Oregon | OR | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 4217737 | 789 | 11 | 661.749373434523 | 127.250626565477 | 778 | 0.260803364458239 | 3.01703559433595 | 0.192294290971578 | weekly | |||||||||
8133 | 8133 | United States | Pennsylvania | PA | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 12801989 | 2537 | 40 | 2360.42857142967 | 176.571428570326 | 2497 | 0.312451447974217 | 1.37924996319186 | 0.0748048175265814 | weekly | |||||||||
8285 | 8285 | United States | Rhode Island | RI | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 1059361 | 187 | 0 | 190.867167920692 | -3.86716792069194 | 187 | 0.0 | -0.365047223816238 | -0.0202610431265937 | weekly | |||||||||
8437 | 8437 | United States | South Carolina | SC | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 5148714 | 1044 | 16 | 930.206766918275 | 113.793233081725 | 1028 | 0.310757210441287 | 2.21012922997326 | 0.122331117261935 | weekly | |||||||||
8589 | 8589 | United States | South Dakota | SD | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 884659 | 154 | 1 | 160.080200501973 | -6.08020050197266 | 153 | 0.113037905000684 | -0.687293126727095 | -0.0379822144331817 | weekly | |||||||||
8741 | 8741 | United States | Tennessee | TN | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 6833174 | 1447 | 25 | 1449.37468671772 | -2.37468671771626 | 1422 | 0.365862189372025 | -0.0347523232646536 | -0.00163842154791183 | weekly | |||||||||
8893 | 8893 | United States | Texas | TX | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 28995881 | 4259 | 146 | 3786.67669172988 | 472.323308270119 | 4113 | 0.503519793035431 | 1.62893242757521 | 0.124732937803134 | weekly | |||||||||
9045 | 9045 | United States | Utah | UT | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 3205958 | 434 | 15 | 369.994987469527 | 64.0050125304729 | 419 | 0.467878868032582 | 1.99643952074459 | 0.172988863898445 | weekly | |||||||||
9197 | 9197 | United States | Vermont | VT | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 623989 | 119 | 0 | 108.538847118674 | 10.4611528813257 | 119 | 0.0 | 1.67649636152652 | 0.0963816472998618 | weekly | |||||||||
9349 | 9349 | United States | Virginia | VA | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 8535519 | 1358 | 27 | 1285.9461152889 | 72.0538847110952 | 1331 | 0.316325228729501 | 0.844165243040232 | 0.0560318071297314 | weekly | |||||||||
9501 | 9501 | United States | Washington | WA | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 7614893 | 1289 | 58 | 1079.0175438605 | 209.982456139501 | 1231 | 0.761665331344774 | 2.75752339710487 | 0.194605228927259 | weekly | |||||||||
9653 | 9653 | United States | West Virginia | WV | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 1792147 | 471 | 9 | 420.204260652628 | 50.7957393473721 | 462 | 0.50219094750598 | 2.83435116356929 | 0.120883446703944 | weekly | |||||||||
9805 | 9805 | United States | Wisconsin | WI | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 5822434 | 988 | 9 | 995.78696741942 | -7.78696741942031 | 979 | 0.154574530170716 | -0.133740758923507 | -0.00781991296752982 | weekly | |||||||||
9957 | 9957 | United States | Wyoming | WY | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 578759 | 85 | 4 | 97.4172932339545 | -12.4172932339545 | 81 | 0.691133960767781 | -2.14550326369949 | -0.127464978975894 | weekly | |||||||||
12005 | 12005 | Canada | Canada | 0 | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 38454328 | 5425 | 80 | 5347.17614424422 | 77.8238557557834 | 5345 | 0.208039001487687 | 0.202379965541937 | 0.0145541971418972 | weekly | |||||||||
17056 | 17056 | South Africa | South Africa | 0 | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 59893884 | 18885 | 2631 | 11615.1012552301 | 7269.89874476995 | 16254 | 4.39276905134421 | 12.1379651130489 | 0.625900591395738 | 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);