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 2022-10-30 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths, non_covid_deaths, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2426 | 2426 | United States | Alabama | AL | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 4903185 | 1137 | 0 | 970.050125295901 | 166.949874704099 | 1137 | 0.0 | 3.4049270974703 | 0.172104379300166 | weekly | |||||||||
2578 | 2578 | United States | Alaska | AK | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 731545 | 72 | 0 | 84.817042611361 | -12.817042611361 | 72 | 0.0 | -1.7520511535669 | -0.151114000403077 | weekly | |||||||||
2730 | 2730 | United States | Arizona | AZ | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 7278717 | 1423 | 0 | 1173.06516291984 | 249.934837080155 | 1423 | 0.0 | 3.43377599486496 | 0.213061341330817 | weekly | |||||||||
2882 | 2882 | United States | Arkansas | AR | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 3017825 | 675 | 44 | 620.243107771228 | 54.7568922287724 | 631 | 1.45800369471391 | 1.81444889046821 | 0.088282951543847 | weekly | |||||||||
3034 | 3034 | United States | California | CA | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 39512223 | 5637 | 128 | 4986.09523809548 | 650.904761904524 | 5509 | 0.323950388718954 | 1.64735039560929 | 0.130543988997921 | weekly | |||||||||
3186 | 3186 | United States | Colorado | CO | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 5758736 | 915 | 15 | 790.954887219027 | 124.045112780973 | 900 | 0.26047382620075 | 2.15403367650424 | 0.156829567381664 | weekly | |||||||||
3338 | 3338 | United States | Connecticut | CT | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 3565287 | 683 | 0 | 606.192982456557 | 76.8070175434432 | 683 | 0.0 | 2.15430111358337 | 0.126703904146478 | weekly | |||||||||
3490 | 3490 | United States | Delaware | DE | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 973764 | 233 | 0 | 170.087719302914 | 62.9122806970856 | 233 | 0.0 | 6.46073183000045 | 0.369881382118148 | weekly | |||||||||
3642 | 3642 | United States | District of Columbia | DC | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 705749 | 110 | 0 | 114.709273183412 | -4.70927318341221 | 110 | 0.0 | -0.667273093325277 | -0.0410539885113073 | weekly | |||||||||
3794 | 3794 | United States | Florida | FL | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 21477737 | 4418 | 634 | 4006.14786967508 | 411.852130324918 | 3784 | 2.95189386107112 | 1.91757693245298 | 0.102805024607921 | weekly | |||||||||
3946 | 3946 | United States | Georgia | GA | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 10617423 | 1821 | 0 | 1726.39348370983 | 94.6065162901657 | 1821 | 0.0 | 0.891049704718044 | 0.0548000888458329 | weekly | |||||||||
4098 | 4098 | United States | Hawaii | HI | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 1415872 | 260 | 9 | 222.729323309104 | 37.270676690896 | 251 | 0.635650680287484 | 2.63234788814921 | 0.167336191468475 | weekly | |||||||||
4250 | 4250 | United States | Idaho | ID | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 1787065 | 332 | 9 | 280.062656642279 | 51.9373433577213 | 323 | 0.503619062541094 | 2.90629290807672 | 0.185449013375819 | weekly | |||||||||
4402 | 4402 | United States | Illinois | IL | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 12671821 | 2231 | 0 | 2004.40350877237 | 226.596491227633 | 2231 | 0.0 | 1.78819201460969 | 0.113049338736399 | weekly | |||||||||
4554 | 4554 | United States | Indiana | IN | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 6732219 | 1332 | 86 | 1304.92230576627 | 27.0776942337259 | 1246 | 1.27743913262477 | 0.402210537621041 | 0.020750426377167 | weekly | |||||||||
4706 | 4706 | United States | Iowa | IA | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 3155070 | 591 | 30 | 613.796992481685 | -22.7969924816853 | 561 | 0.950850535804277 | -0.72255108386455 | -0.0371409321989559 | weekly | |||||||||
4858 | 4858 | United States | Kansas | KS | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 2913314 | 522 | 14 | 527.120300752561 | -5.12030075256064 | 508 | 0.480552388105093 | -0.175755196747094 | -0.00971372330993603 | weekly | |||||||||
5010 | 5010 | United States | Kentucky | KY | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 4467673 | 1054 | 61 | 942.213032583098 | 111.786967416902 | 993 | 1.36536402731355 | 2.50212957431983 | 0.118642985769827 | weekly | |||||||||
5162 | 5162 | United States | Louisiana | LA | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 4648794 | 893 | 0 | 865.899749374248 | 27.1002506257522 | 893 | 0.0 | 0.582952280220466 | 0.0312972150013169 | weekly | |||||||||
5314 | 5314 | United States | Maine | ME | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 1344212 | 329 | 31 | 302.824561404156 | 26.1754385958442 | 298 | 2.30618384600048 | 1.94727011779721 | 0.086437633970218 | weekly | |||||||||
5466 | 5466 | United States | Maryland | MD | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 6045680 | 1065 | 81 | 964.882205514641 | 100.117794485359 | 984 | 1.3397996585992 | 1.65602206013812 | 0.103761675687613 | weekly | |||||||||
5618 | 5618 | United States | Massachusetts | MA | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 6949503 | 1277 | 0 | 1121.58395990047 | 155.416040099531 | 1277 | 0.0 | 2.23636193983269 | 0.138568351239013 | weekly | |||||||||
5770 | 5770 | United States | Michigan | MI | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 9986857 | 2262 | 156 | 1937.39598997566 | 324.604010024338 | 2106 | 1.56205300626614 | 3.25031198528564 | 0.167546547894123 | weekly | |||||||||
5922 | 5922 | United States | Minnesota | MN | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 5639632 | 1007 | 0 | 917.879699248871 | 89.1203007511289 | 1007 | 0.0 | 1.58025028496769 | 0.0970936614286804 | weekly | |||||||||
6074 | 6074 | United States | Mississippi | MS | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 2976149 | 665 | 24 | 593.914786968079 | 71.0852130319211 | 641 | 0.806411238147015 | 2.38849644395899 | 0.119689245985623 | weekly | |||||||||
6226 | 6226 | United States | Missouri | MO | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 6137428 | 1330 | 0 | 1237.12030075265 | 92.8796992473508 | 1330 | 0.0 | 1.5133326085023 | 0.0750773382272072 | weekly | |||||||||
6378 | 6378 | United States | Montana | MT | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 1068778 | 236 | 3 | 188.513784461961 | 47.4862155380395 | 233 | 0.280694400520969 | 4.44303826781983 | 0.251897842237746 | weekly | |||||||||
6530 | 6530 | United States | Nebraska | NE | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 1934408 | 355 | 16 | 309.521303259221 | 45.4786967407792 | 339 | 0.827126438683049 | 2.3510395294467 | 0.146932363820823 | weekly | |||||||||
6682 | 6682 | United States | Nevada | NV | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 3080156 | 578 | 15 | 502.709273183785 | 75.2907268162149 | 563 | 0.486988321370736 | 2.44438031113408 | 0.149769918385193 | weekly | |||||||||
6834 | 6834 | United States | New Hampshire | NH | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 1359711 | 266 | 36 | 250.310776943159 | 15.6892230568411 | 230 | 2.64762144308607 | 1.15386453862925 | 0.0626789755057326 | weekly | |||||||||
6986 | 6986 | United States | New Jersey | NJ | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 8882190 | 1505 | 64 | 1374.56892230675 | 130.431077693254 | 1441 | 0.720543019232869 | 1.46845628942022 | 0.0948887142554991 | weekly | |||||||||
7138 | 7138 | United States | New Mexico | NM | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 2096829 | 386 | 22 | 371.616541354231 | 14.3834586457686 | 364 | 1.0492033446695 | 0.685962405411629 | 0.0387051087482622 | weekly | |||||||||
7290 | 7290 | United States | New York | NY | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 19453561 | 3279 | 130 | 2945.46616541435 | 333.533834585646 | 3149 | 0.66825811479965 | 1.71451301170848 | 0.113236348969816 | weekly | |||||||||
7442 | 7442 | United States | North Carolina | NC | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 10488084 | 2144 | 281 | 1891.40852130394 | 252.591478696063 | 1863 | 2.67923102065163 | 2.40836628211657 | 0.133546759386453 | weekly | |||||||||
7594 | 7594 | United States | North Dakota | ND | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 762062 | 136 | 0 | 162.235588973347 | -26.2355889733467 | 136 | 0.0 | -3.44271056335924 | -0.161712908612529 | weekly | |||||||||
7746 | 7746 | United States | Ohio | OH | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 11689100 | 2634 | 76 | 2328.9674185488 | 305.0325814512 | 2558 | 0.65017837130318 | 2.60954719739929 | 0.130973314191432 | weekly | |||||||||
7898 | 7898 | United States | Oklahoma | OK | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 3956971 | 840 | -2007 | 751.531328321498 | 88.4686716785019 | 2847 | -50.7206143284851 | 2.2357675019226 | 0.117717875948155 | weekly | |||||||||
8050 | 8050 | United States | Oregon | OR | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 4217737 | 825 | 80 | 699.443609023508 | 125.556390976492 | 745 | 1.89675174151447 | 2.97686629053665 | 0.179508954484238 | weekly | |||||||||
8202 | 8202 | United States | Pennsylvania | PA | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 12801989 | 2826 | 135 | 2501.23809523922 | 324.761904760777 | 2691 | 1.05452363691298 | 2.53680818473424 | 0.129840459962176 | weekly | |||||||||
8354 | 8354 | United States | Rhode Island | RI | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 1059361 | 210 | 9 | 198.045112782849 | 11.9548872171512 | 201 | 0.84956874946312 | 1.12849984256086 | 0.0603644646876966 | weekly | |||||||||
8506 | 8506 | United States | South Carolina | SC | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 5148714 | 1143 | 0 | 1016.27568922403 | 126.724310775968 | 1143 | 0.0 | 2.46128083198966 | 0.124694816691647 | weekly | |||||||||
8658 | 8658 | United States | South Dakota | SD | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 884659 | 183 | 6 | 176.218045113468 | 6.78195488653159 | 177 | 0.678227430004103 | 0.766617972182682 | 0.0384861543672479 | weekly | |||||||||
8810 | 8810 | United States | Tennessee | TN | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 6833174 | 1657 | 107 | 1443.05513784554 | 213.944862154462 | 1550 | 1.56589017051227 | 3.13097342690911 | 0.148258272704589 | weekly | |||||||||
8962 | 8962 | United States | Texas | TX | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 28995881 | 4251 | 177 | 4101.56892230634 | 149.431077693657 | 4074 | 0.610431529912818 | 0.515352776118985 | 0.0364326628478624 | weekly | |||||||||
9114 | 9114 | United States | Utah | UT | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 3205958 | 402 | 4 | 395.21553884796 | 6.78446115204036 | 398 | 0.124767698142022 | 0.211620400268511 | 0.0171664838174552 | weekly | |||||||||
9266 | 9266 | United States | Vermont | VT | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 623989 | 172 | 20 | 110.162907269043 | 61.837092730957 | 152 | 3.20518470678169 | 9.90996519665522 | 0.561324081434567 | weekly | |||||||||
9418 | 9418 | United States | Virginia | VA | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 8535519 | 1541 | 33 | 1396.81704260718 | 144.18295739282 | 1508 | 0.386619724002723 | 1.68921136948813 | 0.103222507311122 | weekly | |||||||||
9570 | 9570 | United States | Washington | WA | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 7614893 | 1264 | 47 | 1128.24561403592 | 135.754385964081 | 1217 | 0.617211561606972 | 1.78274843735928 | 0.120323433368791 | weekly | |||||||||
9722 | 9722 | United States | West Virginia | WV | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 1792147 | 568 | 20 | 451.050125314308 | 116.949874685692 | 548 | 1.11597988334662 | 6.52568537545706 | 0.259283543274038 | weekly | |||||||||
9874 | 9874 | United States | Wisconsin | WI | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 5822434 | 1119 | 39 | 1089.82706767004 | 29.1729323299644 | 1080 | 0.669822964073101 | 0.501043589845147 | 0.0267684050023953 | weekly | |||||||||
10026 | 10026 | United States | Wyoming | WY | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 578759 | 123 | 6 | 99.8897243116436 | 23.1102756883564 | 117 | 1.03670094115167 | 3.99307409273227 | 0.23135788838755 | 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);