economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where cadence = "weekly" and "end_date" is on date 2022-03-12 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region_code, covid_deaths, non_covid_deaths, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2392 | 2392 | United States | Alabama | AL | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 4903185 | 1183 | 352 | 1061.38345863171 | 121.61654136829 | 831 | 7.17900711476316 | 2.48035799930637 | 0.114583038184025 | weekly | |||||||||
2544 | 2544 | United States | Alaska | AK | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 731545 | 101 | 0 | 96.1503759446693 | 4.84962405533066 | 101 | 0.0 | 0.662929013981459 | 0.0504379104884771 | weekly | |||||||||
2696 | 2696 | United States | Arizona | AZ | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 7278717 | 1514 | 382 | 1329.7318295865 | 184.268170413502 | 1132 | 5.24817766647611 | 2.53160234713758 | 0.138575437778912 | weekly | |||||||||
2848 | 2848 | United States | Arkansas | AR | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 3017825 | 732 | 183 | 671.576441104536 | 60.4235588954643 | 549 | 6.06396991210557 | 2.00222209357615 | 0.0899727197042324 | weekly | |||||||||
3000 | 3000 | United States | California | CA | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 39512223 | 5904 | 786 | 5668.76190476211 | 235.238095237892 | 5118 | 1.98925785572733 | 0.595355253076729 | 0.0414972615167126 | weekly | |||||||||
3152 | 3152 | United States | Colorado | CO | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 5758736 | 924 | 38 | 866.954887219008 | 57.0451127809919 | 886 | 0.659867026375232 | 0.990583919474549 | 0.0657994015859111 | weekly | |||||||||
3304 | 3304 | United States | Connecticut | CT | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 3565287 | 626 | 105 | 634.52631578986 | -8.5263157898604 | 521 | 2.94506445063188 | -0.239148090738849 | -0.0134372926349742 | weekly | |||||||||
3456 | 3456 | United States | Delaware | DE | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 973764 | 215 | 40 | 187.421052636218 | 27.5789473637824 | 175 | 4.10777149288739 | 2.83220034461968 | 0.147149677028614 | weekly | |||||||||
3608 | 3608 | United States | District of Columbia | DC | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 705749 | 132 | 0 | 119.375939850048 | 12.6240601499522 | 132 | 0.0 | 1.78874644525917 | 0.105750456631459 | weekly | |||||||||
3760 | 3760 | United States | Florida | FL | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 21477737 | 4808 | 662 | 4339.81453634175 | 468.185463658255 | 4146 | 3.08226141329508 | 2.17986403157025 | 0.107881445102701 | weekly | |||||||||
3912 | 3912 | United States | Georgia | GA | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 10617423 | 1925 | 411 | 1768.39348370981 | 156.606516290185 | 1514 | 3.8709958150862 | 1.47499554543683 | 0.0885586368264879 | weekly | |||||||||
4064 | 4064 | United States | Hawaii | HI | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 1415872 | 248 | 6 | 264.395989975743 | -16.3959899757427 | 242 | 0.423767120191656 | -1.15801357578529 | -0.0620130054818416 | weekly | |||||||||
4216 | 4216 | United States | Idaho | ID | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 1787065 | 336 | 31 | 301.729323308918 | 34.2706766910816 | 305 | 1.73468788208599 | 1.91770734086794 | 0.113580862195466 | weekly | |||||||||
4368 | 4368 | United States | Illinois | IL | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 12671821 | 2185 | 202 | 2074.070175439 | 110.929824560999 | 1983 | 1.59408817406748 | 0.875405551901336 | 0.0534841230902516 | weekly | |||||||||
4520 | 4520 | United States | Indiana | IN | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 6732219 | 1375 | 162 | 1357.25563909958 | 17.7443609004181 | 1213 | 2.4063388312234 | 0.26357373253036 | 0.0130737057848511 | weekly | |||||||||
4672 | 4672 | United States | Iowa | IA | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 3155070 | 612 | 91 | 610.130325814991 | 1.86967418500876 | 521 | 2.88424662527297 | 0.0592593566865002 | 0.00306438494515304 | weekly | |||||||||
4824 | 4824 | United States | Kansas | KS | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 2913314 | 589 | 23 | 578.453634085867 | 10.5463659141332 | 566 | 0.78947892331551 | 0.362005808990489 | 0.0182319987163702 | weekly | |||||||||
4976 | 4976 | United States | Kentucky | KY | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 4467673 | 1066 | 79 | 1022.54636591641 | 43.4536340835945 | 987 | 1.76825833045525 | 0.972623423504685 | 0.0424955146602584 | weekly | |||||||||
5128 | 5128 | United States | Louisiana | LA | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 4648794 | 971 | 133 | 879.899749374221 | 91.1002506257793 | 838 | 2.86095705681947 | 1.9596534203447 | 0.103534806880635 | weekly | |||||||||
5280 | 5280 | United States | Maine | ME | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 1344212 | 372 | 10 | 319.82456140413 | 52.1754385958699 | 362 | 0.743930272903381 | 3.88148882734791 | 0.163137685132134 | weekly | |||||||||
5432 | 5432 | United States | Maryland | MD | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 6045680 | 1055 | 73 | 1018.88220551462 | 36.1177944853846 | 982 | 1.20747376639187 | 0.597414922479929 | 0.0354484495753287 | weekly | |||||||||
5584 | 5584 | United States | Massachusetts | MA | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 6949503 | 1196 | 174 | 1205.58395990044 | -9.58395990043505 | 1022 | 2.50377616931743 | -0.137908565554041 | -0.00794964118569275 | weekly | |||||||||
5736 | 5736 | United States | Michigan | MI | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 9986857 | 2007 | 347 | 2021.06265664231 | -14.0626566423098 | 1660 | 3.47456662291249 | -0.140811635155182 | -0.00695805080366618 | weekly | |||||||||
5888 | 5888 | United States | Minnesota | MN | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 5639632 | 944 | 81 | 923.546365915517 | 20.4536340844826 | 863 | 1.43626392644059 | 0.362676750619235 | 0.0221468405262 | weekly | |||||||||
6040 | 6040 | United States | Mississippi | MS | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 2976149 | 698 | 55 | 630.248120301384 | 67.7518796986158 | 643 | 1.84802575408691 | 2.27649488310618 | 0.107500328071136 | weekly | |||||||||
6192 | 6192 | United States | Missouri | MO | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 6137428 | 1428 | 266 | 1303.12030075262 | 124.879699247379 | 1162 | 4.3340630635504 | 2.0347236537419 | 0.095831289847341 | weekly | |||||||||
6344 | 6344 | United States | Montana | MT | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 1068778 | 238 | 19 | 231.513784461932 | 6.48621553806802 | 219 | 1.77773120329947 | 0.606881460702599 | 0.0280165414475981 | weekly | |||||||||
6496 | 6496 | United States | Nebraska | NE | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 1934408 | 334 | 13 | 341.854636592524 | -7.85463659252366 | 321 | 0.672040231429978 | -0.406048599495229 | -0.0229765395924293 | weekly | |||||||||
6648 | 6648 | United States | Nevada | NV | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 3080156 | 625 | 148 | 545.042606517096 | 79.9573934829044 | 477 | 4.80495143752459 | 2.5958877888946 | 0.146699345201367 | weekly | |||||||||
6800 | 6800 | United States | New Hampshire | NH | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 1359711 | 239 | 13 | 255.310776943128 | -16.3107769431281 | 226 | 0.956085521114413 | -1.19957674411166 | -0.0638859712011351 | weekly | |||||||||
6952 | 6952 | United States | New Jersey | NJ | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 8882190 | 1498 | 97 | 1516.23558897338 | -18.2355889733785 | 1401 | 1.09207301352482 | -0.205305099005747 | -0.0120268836228317 | weekly | |||||||||
7104 | 7104 | United States | New Mexico | NM | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 2096829 | 422 | 78 | 401.949874687542 | 20.0501253124576 | 344 | 3.71990276746459 | 0.95621175176696 | 0.0498821534104064 | weekly | |||||||||
7256 | 7256 | United States | New York | NY | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 19453561 | 3177 | 137 | 3181.46616541432 | -4.46616541432331 | 3040 | 0.704241244058093 | -0.0229580867704546 | -0.00140380729579181 | weekly | |||||||||
7408 | 7408 | United States | North Carolina | NC | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 10488084 | 2041 | 159 | 2035.74185463727 | 5.25814536272765 | 1882 | 1.51600616471035 | 0.0501344703448947 | 0.00258291361979412 | weekly | |||||||||
7560 | 7560 | United States | North Dakota | ND | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 762062 | 143 | 18 | 149.902255639985 | -6.90225563998484 | 125 | 2.36201253966213 | -0.905734131866547 | -0.0460450418875734 | weekly | |||||||||
7712 | 7712 | United States | Ohio | OH | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 11689100 | 2635 | 392 | 2480.63408521541 | 154.365914784587 | 2243 | 3.35355159935324 | 1.32059709288643 | 0.0622284099475245 | weekly | |||||||||
7864 | 7864 | United States | Oklahoma | OK | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 3956971 | 917 | 0 | 837.197994988132 | 79.8020050118675 | 917 | 0.0 | 2.01674475278862 | 0.0953203489372891 | weekly | |||||||||
8016 | 8016 | United States | Oregon | OR | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 4217737 | 810 | 160 | 764.443609023481 | 45.5563909765189 | 650 | 3.79350348302893 | 1.08011454902283 | 0.0595941812303378 | weekly | |||||||||
8168 | 8168 | United States | Pennsylvania | PA | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 12801989 | 2708 | 309 | 2704.90476190583 | 3.09523809417215 | 2399 | 2.41368743560083 | 0.0241777906087261 | 0.0011443057581042 | weekly | |||||||||
8320 | 8320 | United States | Rhode Island | RI | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 1059361 | 209 | 4 | 220.711779449484 | -11.7117794494837 | 205 | 0.377586110872498 | -1.10555131343175 | -0.0530636809630013 | weekly | |||||||||
8472 | 8472 | United States | South Carolina | SC | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 5148714 | 1144 | 411 | 1047.27568922402 | 96.7243107759809 | 733 | 7.98257584321056 | 1.8786110624125 | 0.0923580216472408 | weekly | |||||||||
8624 | 8624 | United States | South Dakota | SD | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 884659 | 168 | 30 | 180.884711780107 | -12.8847117801073 | 138 | 3.39113715002052 | -1.45646082616096 | -0.0712316240179027 | weekly | |||||||||
8776 | 8776 | United States | Tennessee | TN | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 6833174 | 1680 | 731 | 1526.72180451219 | 153.278195487806 | 949 | 10.697810417238 | 2.24314784736647 | 0.100396938744698 | weekly | |||||||||
8928 | 8928 | United States | Texas | TX | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 28995881 | 4572 | 478 | 4346.9022556397 | 225.097744360304 | 4094 | 1.64851000733518 | 0.776309381185225 | 0.0517834842198859 | weekly | |||||||||
9080 | 9080 | United States | Utah | UT | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 3205958 | 432 | 86 | 431.215538847938 | 0.784461152062192 | 346 | 2.68250551005347 | 0.0244688530561596 | 0.00181918572358963 | weekly | |||||||||
9232 | 9232 | United States | Vermont | VT | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 623989 | 135 | 1 | 124.496240602344 | 10.5037593976563 | 134 | 0.160259235339084 | 1.68332444925412 | 0.0843700929990858 | weekly | |||||||||
9384 | 9384 | United States | Virginia | VA | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 8535519 | 1507 | 257 | 1434.81704260717 | 72.1829573928323 | 1250 | 3.01094754753636 | 0.845677426209611 | 0.0503081265759644 | weekly | |||||||||
9536 | 9536 | United States | Washington | WA | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 7614893 | 1259 | 158 | 1172.57894736923 | 86.4210526307745 | 1101 | 2.07488141987025 | 1.1348951670204 | 0.0737016921757525 | weekly | |||||||||
9688 | 9688 | United States | West Virginia | WV | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 1792147 | 559 | 110 | 459.383458647612 | 99.6165413523885 | 449 | 6.13788935840643 | 5.55850280989163 | 0.216848342005286 | weekly | |||||||||
9840 | 9840 | United States | Wisconsin | WI | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 5822434 | 1134 | 208 | 1107.16040100335 | 26.8395989966516 | 926 | 3.5723891417232 | 0.460968711653092 | 0.0242418343108448 | weekly | |||||||||
9992 | 9992 | United States | Wyoming | WY | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 578759 | 103 | 8 | 108.556390978282 | -5.55639097828151 | 95 | 1.38226792153556 | -0.960052626098516 | -0.0511843745744381 | weekly | |||||||||
12040 | 12040 | Canada | Canada | 0 | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 38454328 | 6070 | 292 | 6180.47018030517 | -110.470180305174 | 5778 | 0.759342355430057 | -0.287276325060664 | -0.0178740738297221 | weekly | |||||||||
17091 | 17091 | South Africa | South Africa | 0 | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 59893884 | 10099 | 169 | 9302.17656903754 | 796.82343096246 | 9930 | 0.28216570493241 | 1.33039198286499 | 0.0856598909995647 | 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);