economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where start_date = "2022-01-30" and week = 5 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2387 | 2387 | United States | Alabama | AL | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 4903185 | 1676 | 545 | 1091.21052630118 | 584.789473698822 | 1131 | 11.1152240839373 | 11.9267266827342 | 0.53590893746329 | weekly | |||||||||
2539 | 2539 | United States | Alaska | AK | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 731545 | 103 | 8 | 97.1315789516897 | 5.86842104831031 | 95 | 1.09357592492601 | 0.802195496970154 | 0.0604172310555056 | weekly | |||||||||
2691 | 2691 | United States | Arizona | AZ | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 7278717 | 1901 | 529 | 1356.47368422195 | 544.526315778046 | 1372 | 7.26776436012006 | 7.48107552166194 | 0.40142785083986 | weekly | |||||||||
2843 | 2843 | United States | Arkansas | AR | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 3017825 | 968 | 146 | 670.421052633248 | 297.578947366752 | 822 | 4.8379213506416 | 9.86070919840455 | 0.443868739201932 | weekly | |||||||||
2995 | 2995 | United States | California | CA | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 39512223 | 7928 | 1255 | 5768.50000000032 | 2159.49999999968 | 6673 | 3.17623232689287 | 5.46539737842561 | 0.374360752361889 | weekly | |||||||||
3147 | 3147 | United States | Colorado | CO | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 5758736 | 1115 | 248 | 850.960526316778 | 264.039473683222 | 867 | 4.30650059318573 | 4.58502479855339 | 0.31028404434465 | weekly | |||||||||
3299 | 3299 | United States | Connecticut | CT | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 3565287 | 845 | 174 | 666.460526316275 | 178.539473683725 | 671 | 4.88039251818998 | 5.00771673314728 | 0.267892045565797 | weekly | |||||||||
3451 | 3451 | United States | Delaware | DE | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 973764 | 269 | 65 | 186.118421056854 | 82.8815789431459 | 204 | 6.67512867594202 | 8.51146468170377 | 0.44531636617435 | weekly | |||||||||
3603 | 3603 | United States | District of Columbia | DC | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 705749 | 153 | 9 | 130.328947368849 | 22.6710526311513 | 144 | 1.27524091426272 | 3.2123393205164 | 0.173952549213715 | weekly | |||||||||
3755 | 3755 | United States | Florida | FL | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 21477737 | 5992 | 1324 | 4569.92105263249 | 1422.07894736751 | 4668 | 6.16452282659016 | 6.62117683705461 | 0.31118238827087 | weekly | |||||||||
3907 | 3907 | United States | Georgia | GA | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 10617423 | 2590 | 534 | 1863.30263157947 | 726.697368420532 | 2056 | 5.02946901522149 | 6.84438557661809 | 0.39000501373442 | weekly | |||||||||
4059 | 4059 | United States | Hawaii | HI | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 1415872 | 309 | 40 | 248.013157895568 | 60.9868421044323 | 269 | 2.82511413461104 | 4.30736974136308 | 0.245901639340088 | weekly | |||||||||
4211 | 4211 | United States | Idaho | ID | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 1787065 | 385 | 78 | 284.263157895426 | 100.736842104574 | 307 | 4.36469854202281 | 5.63699933156173 | 0.354378818733986 | weekly | |||||||||
4363 | 4363 | United States | Illinois | IL | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 12671821 | 2777 | 718 | 2147.89473684255 | 629.105263157451 | 2059 | 5.66611539099234 | 4.96460029823221 | 0.292893898554009 | weekly | |||||||||
4515 | 4515 | United States | Indiana | IN | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 6732219 | 1841 | 411 | 1396.22368421225 | 444.776315787752 | 1430 | 6.10497073847419 | 6.60668222153426 | 0.31855663302166 | weekly | |||||||||
4667 | 4667 | United States | Iowa | IA | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 3155070 | 792 | 156 | 638.447368421564 | 153.552631578436 | 636 | 4.94442278618224 | 4.86685340035042 | 0.240509459625568 | weekly | |||||||||
4819 | 4819 | United States | Kansas | KS | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 2913314 | 771 | 194 | 569.105263158581 | 201.894736841419 | 577 | 6.65908309231343 | 6.93007128107095 | 0.354758161470669 | weekly | |||||||||
4971 | 4971 | United States | Kentucky | KY | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 4467673 | 1457 | 173 | 1004.14473684364 | 452.855263156362 | 1284 | 3.87226191352859 | 10.1362669818575 | 0.450986044681006 | weekly | |||||||||
5123 | 5123 | United States | Louisiana | LA | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 4648794 | 1293 | 274 | 967.078947369246 | 325.921052630754 | 1019 | 5.89400175615439 | 7.01087319917282 | 0.337015973222621 | weekly | |||||||||
5275 | 5275 | United States | Maine | ME | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 1344212 | 387 | 66 | 294.763157895392 | 92.2368421046085 | 321 | 4.90993980116232 | 6.86177791186275 | 0.312918489417671 | weekly | |||||||||
5427 | 5427 | United States | Maryland | MD | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 6045680 | 1309 | 238 | 1055.60526315874 | 253.394736841257 | 1071 | 3.93669529316801 | 4.19133557914505 | 0.240046867598036 | weekly | |||||||||
5579 | 5579 | United States | Massachusetts | MA | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 6949503 | 1527 | 470 | 1239.80263157967 | 287.197368420328 | 1057 | 6.76307356079996 | 4.13263176403159 | 0.231647651896335 | weekly | |||||||||
5731 | 5731 | United States | Michigan | MI | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 9986857 | 2513 | 676 | 2011.26315789548 | 501.736842104516 | 1837 | 6.76889636048659 | 5.02397142669126 | 0.249463547390544 | weekly | |||||||||
5883 | 5883 | United States | Minnesota | MN | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 5639632 | 1086 | 217 | 963.644736842851 | 122.355263157149 | 869 | 3.84776879058776 | 2.16956111954023 | 0.126971339622542 | weekly | |||||||||
6035 | 6035 | United States | Mississippi | MS | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 2976149 | 1014 | 419 | 646.092105263823 | 367.907894736177 | 595 | 14.0785961993166 | 12.3618775382609 | 0.569435676026326 | weekly | |||||||||
6187 | 6187 | United States | Missouri | MO | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 6137428 | 1876 | 470 | 1351.60526315866 | 524.394736841338 | 1406 | 7.65793097694995 | 8.54420999873788 | 0.387979206011556 | weekly | |||||||||
6339 | 6339 | United States | Montana | MT | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 1068778 | 272 | 38 | 213.657894737645 | 58.3421052623548 | 234 | 3.55546240659894 | 5.45876742058265 | 0.273063185116535 | weekly | |||||||||
6491 | 6491 | United States | Nebraska | NE | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 1934408 | 426 | 89 | 349.539473685273 | 76.460526314727 | 337 | 4.60089081517446 | 3.95265767690823 | 0.218746470916679 | weekly | |||||||||
6643 | 6643 | United States | Nevada | NV | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 3080156 | 844 | 230 | 552.828947369241 | 291.171052630759 | 614 | 7.46715426101795 | 9.45312681016025 | 0.526692847790192 | weekly | |||||||||
6795 | 6795 | United States | New Hampshire | NH | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 1359711 | 307 | 41 | 263.105263158692 | 43.8947368413077 | 266 | 3.01534664351469 | 3.22824018054628 | 0.166833366669798 | weekly | |||||||||
6947 | 6947 | United States | New Jersey | NJ | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 8882190 | 1958 | 548 | 1566.78947368519 | 391.210526314814 | 1410 | 6.16964960218144 | 4.40443771541494 | 0.249689274076282 | weekly | |||||||||
7099 | 7099 | United States | New Mexico | NM | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 2096829 | 542 | 118 | 396.039473685042 | 145.960526314958 | 424 | 5.62754521231822 | 6.96101238178974 | 0.368550450178196 | weekly | |||||||||
7251 | 7251 | United States | New York | NY | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 19453561 | 4162 | 1181 | 3209.90789473765 | 952.092105262352 | 2981 | 6.07086795060298 | 4.89417904137115 | 0.29661041266113 | weekly | |||||||||
7403 | 7403 | United States | North Carolina | NC | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 10488084 | 2763 | 502 | 2029.06578947432 | 733.93421052568 | 2261 | 4.78638424329935 | 6.99779111728777 | 0.361710406007005 | weekly | |||||||||
7555 | 7555 | United States | North Dakota | ND | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 762062 | 174 | 37 | 144.539473685101 | 29.4605263148988 | 137 | 4.85524799819437 | 3.86589625449094 | 0.203823395531953 | weekly | |||||||||
7707 | 7707 | United States | Ohio | OH | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 11689100 | 3392 | 1146 | 2501.51315789705 | 890.486842102951 | 2246 | 9.80400544096637 | 7.61809585086064 | 0.355979275700296 | weekly | |||||||||
7859 | 7859 | United States | Oklahoma | OK | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 3956971 | 1294 | 287 | 860.131578948071 | 433.868421051929 | 1007 | 7.2530225771177 | 10.9646601163347 | 0.504420988219667 | weekly | |||||||||
8011 | 8011 | United States | Oregon | OR | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 4217737 | 1055 | 128 | 742.513157895661 | 312.486842104339 | 927 | 3.03480278642315 | 7.408874524522 | 0.420850241886555 | weekly | |||||||||
8163 | 8163 | United States | Pennsylvania | PA | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 12801989 | 3545 | 811 | 2763.00000000113 | 781.999999998875 | 2734 | 6.33495310767725 | 6.10842580788716 | 0.283025696705956 | weekly | |||||||||
8315 | 8315 | United States | Rhode Island | RI | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 1059361 | 261 | 46 | 220.289473685084 | 40.7105263149158 | 215 | 4.34224027503372 | 3.84293232570538 | 0.184804682828893 | weekly | |||||||||
8467 | 8467 | United States | South Carolina | SC | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 5148714 | 1633 | 525 | 1096.65789473779 | 536.342105262209 | 1108 | 10.1967209676047 | 10.4170110295932 | 0.489069661410177 | weekly | |||||||||
8619 | 8619 | United States | South Dakota | SD | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 884659 | 219 | 42 | 176.315789474366 | 42.6842105256338 | 177 | 4.74759201002872 | 4.82493373442578 | 0.242089552234001 | weekly | |||||||||
8771 | 8771 | United States | Tennessee | TN | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 6833174 | 2299 | 423 | 1602.88157894827 | 696.118421051733 | 1876 | 6.19038824417467 | 10.1873363835274 | 0.434291859232977 | weekly | |||||||||
8923 | 8923 | United States | Texas | TX | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 28995881 | 6582 | 1352 | 4393.28947368476 | 2188.71052631524 | 5230 | 4.66273123413632 | 7.54834980290904 | 0.498194015993104 | weekly | |||||||||
9075 | 9075 | United States | Utah | UT | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 3205958 | 549 | 66 | 392.355263158721 | 156.644736841279 | 483 | 2.05866701934336 | 4.88605081043728 | 0.399242093963987 | weekly | |||||||||
9227 | 9227 | United States | Vermont | VT | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 623989 | 175 | 21 | 106.434210527172 | 68.5657894728278 | 154 | 3.36544394212077 | 10.988300991336 | 0.644208183940288 | weekly | |||||||||
9379 | 9379 | United States | Virginia | VA | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 8535519 | 2045 | 576 | 1487.88157894801 | 557.118421051986 | 1469 | 6.74827154622935 | 6.52705970254399 | 0.374437340265943 | weekly | |||||||||
9531 | 9531 | United States | Washington | WA | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 7614893 | 1569 | 268 | 1199.63157894819 | 369.368421051814 | 1301 | 3.51941911724827 | 4.85060553118492 | 0.307901548720207 | weekly | |||||||||
9683 | 9683 | United States | West Virginia | WV | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 1792147 | 668 | 103 | 480.71052631678 | 187.28947368322 | 565 | 5.74729639923511 | 10.4505642496525 | 0.389609678652635 | weekly | |||||||||
9835 | 9835 | United States | Wisconsin | WI | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 5822434 | 1414 | 225 | 1176.72368421137 | 237.276315788635 | 1189 | 3.86436325426789 | 4.07520833707406 | 0.201641488968293 | weekly | |||||||||
9987 | 9987 | United States | Wyoming | WY | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 578759 | 135 | 25 | 100.73684210611 | 34.2631578938898 | 110 | 4.31958725479863 | 5.92010800590398 | 0.340125391838261 | weekly | |||||||||
12035 | 12035 | Canada | Canada | 0 | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 38454328 | 7410 | 989 | 6254.65649560803 | 1155.34350439197 | 6421 | 2.57188215589153 | 3.00445636286238 | 0.184717339026251 | weekly | |||||||||
17086 | 17086 | South Africa | South Africa | 0 | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 59893884 | 10226 | 912 | 9216.2389121338 | 1009.7610878662 | 9314 | 1.52269303490153 | 1.68591685900049 | 0.109563249986584 | 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);