economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
51 rows where country = "United States" and "start_date" is on date 2021-12-12 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2380 | 2380 | United States | Alabama | AL | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 4903185 | 1148 | 100 | 1097.70426063905 | 50.2957393609522 | 1048 | 2.03949065760317 | 1.02577690543906 | 0.045819025364511 | weekly | |||||||||
2532 | 2532 | United States | Alaska | AK | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 731545 | 121 | 88 | 107.612781958708 | 13.387218041292 | 33 | 12.0293351741861 | 1.82999241896152 | 0.124401746684969 | weekly | |||||||||
2684 | 2684 | United States | Arizona | AZ | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 7278717 | 1861 | 540 | 1238.21553885742 | 622.784461142583 | 1321 | 7.41888989501859 | 8.5562395287876 | 0.502969347095472 | weekly | |||||||||
2836 | 2836 | United States | Arkansas | AR | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 3017825 | 821 | 99 | 687.765664161958 | 133.234335838042 | 722 | 3.28050831310629 | 4.4149125889686 | 0.193720539975469 | weekly | |||||||||
2988 | 2988 | United States | California | CA | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 39512223 | 6594 | 579 | 5368.23809523852 | 1225.76190476148 | 6015 | 1.46536933647089 | 3.10223473065911 | 0.228335979704159 | weekly | |||||||||
3140 | 3140 | United States | Colorado | CO | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 5758736 | 1137 | 353 | 816.799498747886 | 320.200501252114 | 784 | 6.12981737659097 | 5.5602566475024 | 0.392018484025719 | weekly | |||||||||
3292 | 3292 | United States | Connecticut | CT | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 3565287 | 718 | 30 | 641.728070176017 | 76.2719298239831 | 688 | 0.841446985894824 | 2.13929284862574 | 0.118853971594328 | weekly | |||||||||
3444 | 3444 | United States | Delaware | DE | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 973764 | 253 | 23 | 196.482456144151 | 56.5175438558495 | 230 | 2.36196860841025 | 5.80402888747679 | 0.287646769920186 | weekly | |||||||||
3596 | 3596 | United States | District of Columbia | DC | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 705749 | 121 | 7 | 120.281954887642 | 0.718045112358055 | 114 | 0.99185404442656 | 0.101742278396152 | 0.00596968275938647 | weekly | |||||||||
3748 | 3748 | United States | Florida | FL | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 21477737 | 4546 | 263 | 4329.36090225658 | 216.639097743416 | 4283 | 1.22452379410363 | 1.00866817460059 | 0.0500395099032971 | weekly | |||||||||
3900 | 3900 | United States | Georgia | GA | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 10617423 | 1991 | 171 | 1796.04511278246 | 194.954887217539 | 1820 | 1.61056030262711 | 1.83617895997493 | 0.10854676523994 | weekly | |||||||||
4052 | 4052 | United States | Hawaii | HI | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 1415872 | 252 | 22 | 233.796992482057 | 18.2030075179433 | 230 | 1.55381277403607 | 1.28563934578432 | 0.0778581765517807 | weekly | |||||||||
4204 | 4204 | United States | Idaho | ID | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 1787065 | 360 | 40 | 295.130325815262 | 64.8696741847377 | 320 | 2.23830694462708 | 3.62995605558487 | 0.219800096806531 | weekly | |||||||||
4356 | 4356 | United States | Illinois | IL | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 12671821 | 2669 | 360 | 2112.71929824609 | 556.280701753907 | 2309 | 2.84094922111037 | 4.38990340657359 | 0.263300809632265 | weekly | |||||||||
4508 | 4508 | United States | Indiana | IN | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 6732219 | 1876 | 371 | 1347.19172932491 | 528.808270675087 | 1505 | 5.51081300236965 | 7.85488812344171 | 0.392526363667684 | weekly | |||||||||
4660 | 4660 | United States | Iowa | IA | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 3155070 | 775 | 130 | 604.764411028133 | 170.235588971867 | 645 | 4.12035232181853 | 5.39562003289521 | 0.281490752212844 | weekly | |||||||||
4812 | 4812 | United States | Kansas | KS | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 2913314 | 721 | 0 | 557.256892231291 | 163.743107768709 | 721 | 0.0 | 5.6205101052859 | 0.293837743510127 | weekly | |||||||||
4964 | 4964 | United States | Kentucky | KY | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 4467673 | 1218 | 212 | 1006.24310777087 | 211.756892229131 | 1006 | 4.74519957033561 | 4.73975808500602 | 0.210443073442 | weekly | |||||||||
5116 | 5116 | United States | Louisiana | LA | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 4648794 | 996 | 47 | 948.591478697597 | 47.4085213024027 | 949 | 1.01101489977831 | 1.01980258325929 | 0.0499778064288474 | weekly | |||||||||
5268 | 5268 | United States | Maine | ME | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 1344212 | 415 | 74 | 298.201754386652 | 116.798245613348 | 341 | 5.50508401948502 | 8.6889750733774 | 0.391675246356551 | weekly | |||||||||
5420 | 5420 | United States | Maryland | MD | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 6045680 | 1217 | 46 | 1018.1616541362 | 198.8383458638 | 1171 | 0.760873880192137 | 3.28893269018208 | 0.195291528664466 | weekly | |||||||||
5572 | 5572 | United States | Massachusetts | MA | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 6949503 | 1364 | 195 | 1140.68796992556 | 223.312030074439 | 1169 | 2.80595605182126 | 3.21335252426596 | 0.195769602171759 | weekly | |||||||||
5724 | 5724 | United States | Michigan | MI | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 9986857 | 2915 | 825 | 1972.796992482 | 942.203007518001 | 2090 | 8.26085724467668 | 9.43442974619544 | 0.477597548611733 | weekly | |||||||||
5876 | 5876 | United States | Minnesota | MN | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 5639632 | 1278 | 239 | 915.909774436858 | 362.090225563142 | 1039 | 4.23786516567038 | 6.42045838386516 | 0.395333946278466 | weekly | |||||||||
6028 | 6028 | United States | Mississippi | MS | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 2976149 | 754 | 28 | 659.936090226253 | 94.0639097737472 | 726 | 0.940813111171517 | 3.16059141439986 | 0.14253487749321 | weekly | |||||||||
6180 | 6180 | United States | Missouri | MO | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 6137428 | 1624 | 153 | 1270.25689223136 | 353.743107768642 | 1471 | 2.49290093504967 | 5.76370277205113 | 0.278481549623596 | weekly | |||||||||
6332 | 6332 | United States | Montana | MT | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 1068778 | 285 | 56 | 196.135338346684 | 88.8646616533161 | 229 | 5.23962880972475 | 8.3146043100921 | 0.453078279530847 | weekly | |||||||||
6484 | 6484 | United States | Nebraska | NE | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 1934408 | 411 | 35 | 349.724310778012 | 61.2756892219884 | 376 | 1.80933908461917 | 3.16767141275204 | 0.175211408911414 | weekly | |||||||||
6636 | 6636 | United States | Nevada | NV | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 3080156 | 662 | 89 | 537.44862155472 | 124.55137844528 | 573 | 2.88946404013303 | 4.04367111423188 | 0.231745646839656 | weekly | |||||||||
6788 | 6788 | United States | New Hampshire | NH | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 1359711 | 325 | 55 | 255.066416040912 | 69.9335839590883 | 270 | 4.04497720471483 | 5.1432682356095 | 0.274177937827265 | weekly | |||||||||
6940 | 6940 | United States | New Jersey | NJ | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 8882190 | 1724 | 2069 | 1526.17669173031 | 197.823308269692 | -345 | 23.2938047936376 | 2.22719068461373 | 0.129620187060654 | weekly | |||||||||
7092 | 7092 | United States | New Mexico | NM | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 2096829 | 593 | 105 | 372.962406015875 | 220.037593984125 | 488 | 5.00756141774079 | 10.4938263436897 | 0.589972582852649 | weekly | |||||||||
7244 | 7244 | United States | New York | NY | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 19453561 | 3724 | 419 | 3106.51629072763 | 617.48370927237 | 3305 | 2.15384730846964 | 3.17414230367576 | 0.198770471964188 | weekly | |||||||||
7396 | 7396 | United States | North Carolina | NC | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 10488084 | 2277 | 145 | 1992.72305764473 | 284.276942355271 | 2132 | 1.38252134517611 | 2.71047545343144 | 0.142657526475991 | weekly | |||||||||
7548 | 7548 | United States | North Dakota | ND | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 762062 | 194 | 33 | 146.676691730209 | 47.3233082697908 | 161 | 4.3303563227139 | 6.20990264175235 | 0.322636866918401 | weekly | |||||||||
7700 | 7700 | United States | Ohio | OH | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 11689100 | 3652 | 657 | 2452.72556391198 | 1199.27443608802 | 2995 | 5.62062092034459 | 10.2597671000165 | 0.48895581867514 | weekly | |||||||||
7852 | 7852 | United States | Oklahoma | OK | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 3956971 | 1001 | 0 | 797.065162907995 | 203.934837092005 | 1001 | 0.0 | 5.15381176895167 | 0.255857170256913 | weekly | |||||||||
8004 | 8004 | United States | Oregon | OR | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 4217737 | 925 | 175 | 723.082706767836 | 201.917293232164 | 750 | 4.14914443456289 | 4.78733721974993 | 0.279245086823788 | weekly | |||||||||
8156 | 8156 | United States | Pennsylvania | PA | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 12801989 | 3695 | 807 | 2700.42857142968 | 994.571428570317 | 2888 | 6.30370796287983 | 7.76888207426453 | 0.368301327830998 | weekly | |||||||||
8308 | 8308 | United States | Rhode Island | RI | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 1059361 | 247 | 35 | 206.867167920676 | 40.1328320793239 | 212 | 3.30387847013435 | 3.78839999578273 | 0.194002907676065 | weekly | |||||||||
8460 | 8460 | United States | South Carolina | SC | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 5148714 | 1166 | 86 | 1073.54010025158 | 92.4598997484181 | 1080 | 1.67032000612192 | 1.79578628271872 | 0.0861261723961222 | weekly | |||||||||
8612 | 8612 | United States | South Dakota | SD | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 884659 | 212 | 35 | 150.746867168619 | 61.2531328313807 | 177 | 3.95632667502394 | 6.92392580998788 | 0.406331050069952 | weekly | |||||||||
8764 | 8764 | United States | Tennessee | TN | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 6833174 | 1868 | 257 | 1606.70802005102 | 261.291979948978 | 1611 | 3.76106330674442 | 3.82387423397937 | 0.162625677278116 | weekly | |||||||||
8916 | 8916 | United States | Texas | TX | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 28995881 | 4731 | 586 | 4282.67669172983 | 448.323308270171 | 4145 | 2.02097670355317 | 1.54616205063806 | 0.104682968279141 | weekly | |||||||||
9068 | 9068 | United States | Utah | UT | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 3205958 | 488 | 64 | 380.328320802836 | 107.671679197164 | 424 | 1.99628317027235 | 3.35848689212908 | 0.283101923543004 | weekly | |||||||||
9220 | 9220 | United States | Vermont | VT | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 623989 | 156 | 23 | 94.5388471186591 | 61.4611528813409 | 133 | 3.68596241279894 | 9.84971736382226 | 0.650115320363478 | weekly | |||||||||
9372 | 9372 | United States | Virginia | VA | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 8535519 | 1745 | 188 | 1446.61278195554 | 298.387218044459 | 1557 | 2.2025608518943 | 3.49582981473603 | 0.206266128549685 | weekly | |||||||||
9524 | 9524 | United States | Washington | WA | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 7614893 | 1340 | 120 | 1159.01754386048 | 180.982456139523 | 1220 | 1.57585930623057 | 2.37669073143277 | 0.156151610558631 | weekly | |||||||||
9676 | 9676 | United States | West Virginia | WV | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 1792147 | 594 | 79 | 472.204260652608 | 121.795739347392 | 515 | 4.40812053921916 | 6.79607974945093 | 0.257930199907695 | weekly | |||||||||
9828 | 9828 | United States | Wisconsin | WI | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 5822434 | 1477 | 339 | 1141.45363408606 | 335.546365913944 | 1138 | 5.82230730309695 | 5.76299131795987 | 0.293964078692176 | weekly | |||||||||
9980 | 9980 | United States | Wyoming | WY | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 578759 | 98 | 30 | 102.083959900602 | -4.08395990060151 | 68 | 5.18350470575835 | -0.705640845429879 | -0.0400058922535729 | 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);