economist_excess_deaths

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette

2,376 rows where country = "United States"

View and edit SQL

Suggested facets: start_date, end_date, week, start_date (date), end_date (date)

country

  • United States · 2,376

cadence

Link rowid ▼ country region region_code start_date end_date year month 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 week
3350 United States Alabama AL 2019-12-29 2020-01-04 2020   4903185 1093 0 1139.4 -46.4000000000001 1093 0.0 -0.946323665127873 -0.040723187642619 weekly 1
3351 United States Alabama AL 2020-01-05 2020-01-11 2020   4903185 1148 0 1163.6 -15.5999999999999 1148 0.0 -0.318160542586093 -0.0134066689584049 weekly 2
3352 United States Alabama AL 2020-01-12 2020-01-18 2020   4903185 1073 0 1130.4 -57.4000000000001 1073 0.0 -1.17066763746422 -0.0507784854918614 weekly 3
3353 United States Alabama AL 2020-01-19 2020-01-25 2020   4903185 1082 0 1117.6 -35.5999999999999 1082 0.0 -0.726058674106727 -0.0318539727988546 weekly 4
3354 United States Alabama AL 2020-01-26 2020-02-01 2020   4903185 1052 0 1117.6 -65.5999999999999 1052 0.0 -1.33790587138768 -0.0586972083035074 weekly 5
3355 United States Alabama AL 2020-02-02 2020-02-08 2020   4903185 1118 0 1117.6 0.400000000000091 1118 0.0 0.00815796263041453 0.000357909806728784 weekly 6
3356 United States Alabama AL 2020-02-09 2020-02-15 2020   4903185 1096 0 1106.4 -10.4000000000001 1096 0.0 -0.212107028390732 -0.00939985538684029 weekly 7
3357 United States Alabama AL 2020-02-16 2020-02-22 2020   4903185 1105 0 1089.0 16.0 1105 0.0 0.326318505216507 0.014692378328742 weekly 8
3358 United States Alabama AL 2020-02-23 2020-02-29 2020   4903185 1174 0 1081.4 92.5999999999999 1174 0.0 1.88856834894053 0.0856297392269281 weekly 9
3359 United States Alabama AL 2020-03-01 2020-03-07 2020   4903185 1089 0 1079.6 9.40000000000009 1089 0.0 0.1917121218147 0.00870692849203425 weekly 10
3360 United States Alabama AL 2020-03-08 2020-03-14 2020   4903185 1086 0 1073.2 12.8 1086 0.0 0.261054804173205 0.0119269474468877 weekly 11
3361 United States Alabama AL 2020-03-15 2020-03-21 2020   4903185 1075 0 1024.6 50.4000000000001 1075 0.0 1.027903291432 0.0491899277766934 weekly 12
3362 United States Alabama AL 2020-03-22 2020-03-28 2020   4903185 1074 3 1010.8 63.2 1071 0.0611847197280951 1.2889580956052 0.0625247328848437 weekly 13
3363 United States Alabama AL 2020-03-29 2020-04-04 2020   4903185 1156 23 1034.8 121.2 1133 0.469082851248729 2.47186267701504 0.117124081948203 weekly 14
3364 United States Alabama AL 2020-04-05 2020-04-11 2020   4903185 1120 34 1000.2 119.8 1086 0.693426823585078 2.4433098078086 0.119776044791042 weekly 15
3365 United States Alabama AL 2020-04-12 2020-04-18 2020   4903185 1134 50 1009.8 124.2 1084 1.01974532880158 2.53304739674314 0.122994652406417 weekly 16
3366 United States Alabama AL 2020-04-19 2020-04-25 2020   4903185 1125 102 1002.2 122.8 1023 2.08028047075523 2.50449452753669 0.122530433047296 weekly 17
3367 United States Alabama AL 2020-04-26 2020-05-02 2020   4903185 1112 75 991.4 120.6 1037 1.52961799320238 2.45962573306942 0.121646156949768 weekly 18
3368 United States Alabama AL 2020-05-03 2020-05-09 2020   4903185 1139 101 993.2 145.8 1038 2.0598855641792 2.97357737878542 0.14679822795006 weekly 19
3369 United States Alabama AL 2020-05-10 2020-05-16 2020   4903185 1069 94 983.8 85.2 975 1.91712121814698 1.7376460402779 0.0866029680829437 weekly 20
3370 United States Alabama AL 2020-05-17 2020-05-23 2020   4903185 1015 69 955.2 59.8 946 1.40724855374619 1.21961541324669 0.0626046901172528 weekly 21
3371 United States Alabama AL 2020-05-24 2020-05-30 2020   4903185 877 67 944.6 -67.6 810 1.36645874059412 -1.37869568453974 -0.0715646834639001 weekly 22
3372 United States Alabama AL 2020-05-31 2020-06-06 2020   4903185 722 66 992.4 -270.4 656 1.34606383401809 -5.51478273815897 -0.272470777912132 weekly 23
3373 United States Alaska AK 2019-12-29 2020-01-04 2020   731545 91 0 90.4 0.599999999999994 91 0.0 0.0820181943694502 0.00663716814159288 weekly 1
3374 United States Alaska AK 2020-01-05 2020-01-11 2020   731545 108 0 90.4 17.6 108 0.0 2.40586703483723 0.194690265486726 weekly 2
3375 United States Alaska AK 2020-01-12 2020-01-18 2020   731545 102 0 93.8 8.2 102 0.0 1.12091532304916 0.0874200426439233 weekly 3
3376 United States Alaska AK 2020-01-19 2020-01-25 2020   731545 102 0 90.4 11.6 102 0.0 1.58568509114272 0.128318584070796 weekly 4
3377 United States Alaska AK 2020-01-26 2020-02-01 2020   731545 90 0 90.8 -0.799999999999997 90 0.0 -0.109357592492601 -0.00881057268722463 weekly 5
3378 United States Alaska AK 2020-02-02 2020-02-08 2020   731545 94 0 80.6 13.4 94 0.0 1.83173967425107 0.166253101736973 weekly 6
3379 United States Alaska AK 2020-02-09 2020-02-15 2020   731545 92 0 85.6 6.40000000000001 92 0.0 0.874860739940811 0.0747663551401869 weekly 7
3380 United States Alaska AK 2020-02-16 2020-02-22 2020   731545 89 0 81.6 7.40000000000001 89 0.0 1.01155773055656 0.090686274509804 weekly 8
3381 United States Alaska AK 2020-02-23 2020-02-29 2020   731545 90 0 85.0 5.0 90 0.0 0.683484953078758 0.0588235294117647 weekly 9
3382 United States Alaska AK 2020-03-01 2020-03-07 2020   731545 82 0 88.4 -6.40000000000001 82 0.0 -0.874860739940811 -0.0723981900452489 weekly 10
3383 United States Alaska AK 2020-03-08 2020-03-14 2020   731545 94 0 85.4 8.59999999999999 94 0.0 1.17559411929546 0.100702576112412 weekly 11
3384 United States Alaska AK 2020-03-15 2020-03-21 2020   731545 65 6 85.6 -20.6 59 0.82018194369451 -2.81595800668448 -0.240654205607477 weekly 12
3385 United States Alaska AK 2020-03-22 2020-03-28 2020   731545 89 -4 88.2 0.799999999999997 93 -0.546787962463006 0.109357592492601 0.00907029478458043 weekly 13
3386 United States Alaska AK 2020-03-29 2020-04-04 2020   731545 99 3 87.0 12.0 96 0.410090971847255 1.64036388738902 0.137931034482759 weekly 14
3387 United States Alaska AK 2020-04-05 2020-04-11 2020   731545 79 3 87.8 -8.8 76 0.410090971847255 -1.20293351741861 -0.100227790432802 weekly 15
3388 United States Alaska AK 2020-04-12 2020-04-18 2020   731545 82 1 82.0 0.0 81 0.136696990615752 0.0 0.0 weekly 16
3389 United States Alaska AK 2020-04-19 2020-04-25 2020   731545 66 0 84.0 -18.0 66 0.0 -2.46054583108353 -0.214285714285714 weekly 17
3390 United States Alaska AK 2020-04-26 2020-05-02 2020   731545 84 0 86.0 -2.0 84 0.0 -0.273393981231503 -0.0232558139534884 weekly 18
3391 United States Alaska AK 2020-05-03 2020-05-09 2020   731545 82 1 89.6 -7.59999999999999 81 0.136696990615752 -1.03889712867971 -0.0848214285714285 weekly 19
3392 United States Alaska AK 2020-05-10 2020-05-16 2020   731545 69 -10 85.2 -16.2 79 -1.36696990615752 -2.21449124797518 -0.190140845070423 weekly 20
3393 United States Alaska AK 2020-05-17 2020-05-23 2020   731545 65 10 76.6 -11.6 55 1.36696990615752 -1.58568509114272 -0.151436031331593 weekly 21
3394 United States Alaska AK 2020-05-24 2020-05-30 2020   731545 69 0 82.8 -13.8 69 0.0 -1.88641847049737 -0.166666666666667 weekly 22
3395 United States Alaska AK 2020-05-31 2020-06-06 2020   731545 33 0 83.0 -50.0 33 0.0 -6.83484953078758 -0.602409638554217 weekly 23
3396 United States Arizona AZ 2019-12-29 2020-01-04 2020   7278717 1275 0 1241.0 34.0 1275 0.0 0.467115289686355 0.0273972602739727 weekly 1
3397 United States Arizona AZ 2020-01-05 2020-01-11 2020   7278717 1350 0 1267.6 82.4000000000001 1350 0.0 1.13206764323987 0.0650047333543706 weekly 2
3398 United States Arizona AZ 2020-01-12 2020-01-18 2020   7278717 1258 0 1182.2 75.8 1258 0.0 1.04139232230076 0.0641177465741838 weekly 3
3399 United States Arizona AZ 2020-01-19 2020-01-25 2020   7278717 1237 0 1226.8 10.2 1237 0.0 0.140134586905907 0.00831431366155866 weekly 4
3400 United States Arizona AZ 2020-01-26 2020-02-01 2020   7278717 1244 0 1205.2 38.8 1244 0.0 0.533060977642076 0.0321938267507467 weekly 5
3401 United States Arizona AZ 2020-02-02 2020-02-08 2020   7278717 1224 0 1187.0 37.0 1224 0.0 0.508331344658681 0.0311710193765795 weekly 6
3402 United States Arizona AZ 2020-02-09 2020-02-15 2020   7278717 1271 0 1160.4 110.6 1271 0.0 1.51949855997973 0.0953119613926232 weekly 7
3403 United States Arizona AZ 2020-02-16 2020-02-22 2020   7278717 1281 0 1145.4 135.6 1281 0.0 1.86296568474911 0.118386589837611 weekly 8
3404 United States Arizona AZ 2020-02-23 2020-02-29 2020   7278717 1310 0 1178.0 132.0 1310 0.0 1.81350641878232 0.112054329371817 weekly 9
3405 United States Arizona AZ 2020-03-01 2020-03-07 2020   7278717 1333 0 1201.6 131.4 1333 0.0 1.80526320778786 0.109354194407457 weekly 10
3406 United States Arizona AZ 2020-03-08 2020-03-14 2020   7278717 1285 0 1183.8 101.2 1285 0.0 1.39035492106645 0.0854874134144281 weekly 11
3407 United States Arizona AZ 2020-03-15 2020-03-21 2020   7278717 1252 1 1158.8 93.2 1251 0.0137386849907752 1.28044544114025 0.0804280289955126 weekly 12
3408 United States Arizona AZ 2020-03-22 2020-03-28 2020   7278717 1272 14 1131.4 140.6 1258 0.192341589870852 1.93165910970299 0.124270814919569 weekly 13
3409 United States Arizona AZ 2020-03-29 2020-04-04 2020   7278717 1317 37 1150.2 166.8 1280 0.508331344658681 2.2916126564613 0.145018257694314 weekly 14
3410 United States Arizona AZ 2020-04-05 2020-04-11 2020   7278717 1366 56 1146.6 219.4 1310 0.769366359483409 3.01426748697607 0.191348334205477 weekly 15
3411 United States Arizona AZ 2020-04-12 2020-04-18 2020   7278717 1282 68 1108.6 173.4 1214 0.934230579372711 2.38228797740041 0.156413494497565 weekly 16
3412 United States Arizona AZ 2020-04-19 2020-04-25 2020   7278717 1355 96 1105.6 249.4 1259 1.31891375911442 3.42642803669933 0.225578871201158 weekly 17
3413 United States Arizona AZ 2020-04-26 2020-05-02 2020   7278717 1362 74 1097.2 264.8 1288 1.01666268931736 3.63800378555726 0.241341596791834 weekly 18
3414 United States Arizona AZ 2020-05-03 2020-05-09 2020   7278717 1379 183 1100.0 279.0 1196 2.51417935331185 3.83309311242627 0.253636363636364 weekly 19
3415 United States Arizona AZ 2020-05-10 2020-05-16 2020   7278717 1263 147 1062.6 200.4 1116 2.01958669364395 2.75323247215134 0.188594014680971 weekly 20
3416 United States Arizona AZ 2020-05-17 2020-05-23 2020   7278717 1201 119 1042.2 158.8 1082 1.63490351390224 2.18170317653509 0.152369986566878 weekly 21
3417 United States Arizona AZ 2020-05-24 2020-05-30 2020   7278717 1189 101 1089.8 99.2 1088 1.38760718406829 1.3628775510849 0.0910258763075795 weekly 22
3418 United States Arizona AZ 2020-05-31 2020-06-06 2020   7278717 1057 139 1078.8 -21.8 918 1.90967721371775 -0.299503332798898 -0.0202076381164256 weekly 23
3419 United States Arkansas AR 2019-12-29 2020-01-04 2020   3017825 698 0 706.8 -8.79999999999995 698 0.0 -0.29160073894278 -0.0124504810413129 weekly 1
3420 United States Arkansas AR 2020-01-05 2020-01-11 2020   3017825 694 0 676.0 18.0 694 0.0 0.596456056928417 0.0266272189349113 weekly 2
3421 United States Arkansas AR 2020-01-12 2020-01-18 2020   3017825 659 0 679.8 -20.8 659 0.0 -0.689238110228392 -0.0305972344807296 weekly 3
3422 United States Arkansas AR 2020-01-19 2020-01-25 2020   3017825 622 0 667.4 -45.4 622 0.0 -1.5043947213639 -0.0680251723104585 weekly 4
3423 United States Arkansas AR 2020-01-26 2020-02-01 2020   3017825 686 0 668.0 18.0 686 0.0 0.596456056928417 0.0269461077844311 weekly 5
3424 United States Arkansas AR 2020-02-02 2020-02-08 2020   3017825 687 0 658.2 28.8 687 0.0 0.954329691085466 0.0437556973564266 weekly 6
3425 United States Arkansas AR 2020-02-09 2020-02-15 2020   3017825 700 0 655.4 44.6 700 0.0 1.47788556327819 0.0680500457735733 weekly 7
3426 United States Arkansas AR 2020-02-16 2020-02-22 2020   3017825 696 0 685.6 10.4 696 0.0 0.344619055114196 0.015169194865811 weekly 8
3427 United States Arkansas AR 2020-02-23 2020-02-29 2020   3017825 666 0 651.2 14.8 666 0.0 0.490419424585586 0.0227272727272727 weekly 9
3428 United States Arkansas AR 2020-03-01 2020-03-07 2020   3017825 695 0 649.8 45.2 695 0.0 1.49776743184247 0.069559864573715 weekly 10
3429 United States Arkansas AR 2020-03-08 2020-03-14 2020   3017825 625 0 647.6 -22.6 625 0.0 -0.748883715921235 -0.0348980852378011 weekly 11
3430 United States Arkansas AR 2020-03-15 2020-03-21 2020   3017825 642 0 615.8 26.2 642 0.0 0.86817492730692 0.0425462812601494 weekly 12
3431 United States Arkansas AR 2020-03-22 2020-03-28 2020   3017825 643 5 640.6 2.39999999999998 638 0.165682238035671 0.0795274742571215 0.00374648766781149 weekly 13
3432 United States Arkansas AR 2020-03-29 2020-04-04 2020   3017825 615 8 619.0 -4.0 607 0.265091580857074 -0.132545790428537 -0.00646203554119551 weekly 14
3433 United States Arkansas AR 2020-04-05 2020-04-11 2020   3017825 628 12 624.4 3.60000000000002 616 0.397637371285611 0.119291211385684 0.00576553491351706 weekly 15
3434 United States Arkansas AR 2020-04-12 2020-04-18 2020   3017825 635 13 595.2 39.8 622 0.430773818892746 1.31883061476394 0.0668682795698925 weekly 16
3435 United States Arkansas AR 2020-04-19 2020-04-25 2020   3017825 617 10 605.2 11.8 607 0.331364476071343 0.391010081764183 0.0194976867151355 weekly 17
3436 United States Arkansas AR 2020-04-26 2020-05-02 2020   3017825 624 24 599.6 24.4 600 0.795274742571223 0.808529321614076 0.0406937958639093 weekly 18
3437 United States Arkansas AR 2020-05-03 2020-05-09 2020   3017825 651 16 602.8 48.2 635 0.530183161714148 1.59717677466387 0.079960185799602 weekly 19
3438 United States Arkansas AR 2020-05-10 2020-05-16 2020   3017825 568 10 607.4 -39.4 558 0.331364476071343 -1.30557603572109 -0.0648666447151794 weekly 20
3439 United States Arkansas AR 2020-05-17 2020-05-23 2020   3017825 620 17 598.8 21.2 603 0.563319609321283 0.702492689271248 0.0354041416165665 weekly 21
3440 United States Arkansas AR 2020-05-24 2020-05-30 2020   3017825 544 18 594.6 -50.6 526 0.596456056928417 -1.676704248921 -0.0850992263706694 weekly 22
3441 United States Arkansas AR 2020-05-31 2020-06-06 2020   3017825 448 20 583.2 -135.2 428 0.662728952142685 -4.48004771648456 -0.231824417009602 weekly 23
3442 United States California CA 2019-12-29 2020-01-04 2020   39512223 5864 0 6043.0 -179.0 5864 0.0 -0.453024371724162 -0.0296210491477743 weekly 1
3443 United States California CA 2020-01-05 2020-01-11 2020   39512223 5837 0 6042.6 -205.6 5837 0.0 -0.520345311879821 -0.0340250885380466 weekly 2
3444 United States California CA 2020-01-12 2020-01-18 2020   39512223 5786 0 5758.6 27.3999999999996 5786 0.0 0.0693456300851502 0.00475810092730855 weekly 3
3445 United States California CA 2020-01-19 2020-01-25 2020   39512223 5794 0 5581.2 212.8 5794 0.0 0.538567521245262 0.0381280011467069 weekly 4
3446 United States California CA 2020-01-26 2020-02-01 2020   39512223 5655 0 5630.0 25.0 5655 0.0 0.0632715602966707 0.00444049733570151 weekly 5
3447 United States California CA 2020-02-02 2020-02-08 2020   39512223 5887 1 5583.8 303.2 5886 0.00253086241186683 0.767357483278022 0.0542999391095669 weekly 6
3448 United States California CA 2020-02-09 2020-02-15 2020   39512223 5557 0 5563.2 -6.19999999999982 5557 0.0 -0.0156913469535739 -0.00111446649410407 weekly 7
3449 United States California CA 2020-02-16 2020-02-22 2020   39512223 5757 1 5487.2 269.8 5756 0.00253086241186683 0.682826678721671 0.0491689750692521 weekly 8

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [economist_excess_deaths] (
   [country] TEXT,
   [region] TEXT,
   [region_code] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [year] INTEGER,
   [month] 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
, [week] INTEGER);
Powered by Datasette · Query took 151.534ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette