economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where "end_date" is on date 2020-07-18 and week = 29 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2306 | 2306 | United States | Alabama | AL | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 4903185 | 1289 | 171 | 970.358395981031 | 318.641604018969 | 1118 | 3.48752902450142 | 6.49866574520376 | 0.328375170801529 | weekly | |||||||||
2458 | 2458 | United States | Alaska | AK | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 731545 | 89 | 3 | 80.4085213060767 | 8.59147869392332 | 86 | 0.410090971847255 | 1.17442928239867 | 0.106847863315626 | weekly | |||||||||
2610 | 2610 | United States | Arizona | AZ | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 7278717 | 1995 | 577 | 1161.03258146166 | 833.967418538336 | 1418 | 7.92722123967727 | 11.4576156558681 | 0.71829803216067 | weekly | |||||||||
2762 | 2762 | United States | Arkansas | AR | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 3017825 | 695 | 37 | 586.954887219379 | 108.045112780621 | 658 | 1.22604856146397 | 3.58023121886196 | 0.18407737141856 | weekly | |||||||||
2914 | 2914 | United States | California | CA | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 39512223 | 6230 | 887 | 4735.04761904826 | 1494.95238095174 | 5343 | 2.24487495932588 | 3.78351878848159 | 0.315720664547874 | weekly | |||||||||
3066 | 3066 | United States | Colorado | CO | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 5758736 | 808 | 27 | 709.977443610106 | 98.0225563898945 | 781 | 0.468852887161349 | 1.70215402112364 | 0.138064324820613 | weekly | |||||||||
3218 | 3218 | United States | Connecticut | CT | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 3565287 | 569 | 47 | 568.596491228834 | 0.403508771166457 | 522 | 1.31826694456856 | 0.0113177079760047 | 0.00070965751176976 | weekly | |||||||||
3370 | 3370 | United States | Delaware | DE | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 973764 | 191 | 8 | 183.543859652077 | 7.45614034792274 | 183 | 0.821554298577479 | 0.765703019204113 | 0.0406232077829052 | weekly | |||||||||
3522 | 3522 | United States | District of Columbia | DC | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 705749 | 121 | 10 | 117.521303258559 | 3.47869674144117 | 111 | 1.4169343491808 | 0.492908490333131 | 0.0296005630042042 | weekly | |||||||||
3674 | 3674 | United States | Florida | FL | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 21477737 | 5509 | 698 | 3787.24060150479 | 1721.75939849521 | 4811 | 3.24987683758303 | 8.01648422501501 | 0.454621076308461 | weekly | |||||||||
3826 | 3826 | United States | Georgia | GA | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 10617423 | 2177 | 170 | 1601.69674185513 | 575.303258144873 | 2007 | 1.60114182132519 | 5.41848297976706 | 0.3591836351484 | weekly | |||||||||
3978 | 3978 | United States | Hawaii | HI | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 1415872 | 227 | 5 | 215.864661655033 | 11.1353383449674 | 222 | 0.35313926682638 | 0.786465043801089 | 0.0515848136494079 | weekly | |||||||||
4130 | 4130 | United States | Idaho | ID | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 1787065 | 312 | 17 | 255.531328321604 | 56.4686716783964 | 295 | 0.951280451466511 | 3.15985549929053 | 0.220985317335832 | weekly | |||||||||
4282 | 4282 | United States | Illinois | IL | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 12671821 | 2087 | 122 | 1881.36842105316 | 205.631578946844 | 1965 | 0.962766124931847 | 1.62274687234648 | 0.109298942538716 | weekly | |||||||||
4434 | 4434 | United States | Indiana | IN | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 6732219 | 1383 | 64 | 1207.79448621691 | 175.205513783092 | 1319 | 0.950652377767271 | 2.60249278555989 | 0.145062356040287 | weekly | |||||||||
4586 | 4586 | United States | Iowa | IA | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 3155070 | 601 | 39 | 512.39849624127 | 88.60150375873 | 562 | 1.23610569654556 | 2.80822624406844 | 0.172915229862444 | weekly | |||||||||
4738 | 4738 | United States | Kansas | KS | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 2913314 | 518 | 17 | 487.393483710045 | 30.6065162899548 | 501 | 0.583527899841898 | 1.05057389247966 | 0.0627963181964963 | weekly | |||||||||
4890 | 4890 | United States | Kentucky | KY | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 4467673 | 936 | 45 | 864.273182958663 | 71.7268170413373 | 891 | 1.00723575785426 | 1.60546255380233 | 0.0829909089575072 | weekly | |||||||||
5042 | 5042 | United States | Louisiana | LA | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 4648794 | 1152 | 104 | 824.616541354298 | 327.383458645702 | 1048 | 2.23713935270094 | 7.04233094961191 | 0.397012965696792 | weekly | |||||||||
5194 | 5194 | United States | Maine | ME | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 1344212 | 294 | 3 | 281.57894736917 | 12.4210526308299 | 291 | 0.223179081871014 | 0.924039707340057 | 0.0441121495299328 | weekly | |||||||||
5346 | 5346 | United States | Maryland | MD | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 6045680 | 1026 | 64 | 919.774436091113 | 106.225563908887 | 962 | 1.05860713765863 | 1.75704906493375 | 0.11549088530915 | weekly | |||||||||
5498 | 5498 | United States | Massachusetts | MA | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 6949503 | 1060 | 105 | 1016.79197995066 | 43.2080200493384 | 955 | 1.51089941251914 | 0.621742591511054 | 0.0424944540292647 | weekly | |||||||||
5650 | 5650 | United States | Michigan | MI | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 9986857 | 1879 | 50 | 1820.5313283217 | 58.4686716783024 | 1829 | 0.50065801482889 | 0.58545618184282 | 0.0321162677997984 | weekly | |||||||||
5802 | 5802 | United States | Minnesota | MN | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 5639632 | 869 | 44 | 798.273182958206 | 70.7268170417935 | 825 | 0.780192750165259 | 1.25410340677891 | 0.0885997657840605 | weekly | |||||||||
5954 | 5954 | United States | Mississippi | MS | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 2976149 | 784 | 116 | 563.29072681778 | 220.70927318222 | 668 | 3.89765431771057 | 7.41593492739175 | 0.391821243763557 | weekly | |||||||||
6106 | 6106 | United States | Missouri | MO | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 6137428 | 1367 | 61 | 1176.06015037675 | 190.93984962325 | 1306 | 0.993901679987122 | 3.11107274290224 | 0.162355513501654 | weekly | |||||||||
6258 | 6258 | United States | Montana | MT | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 1068778 | 203 | 8 | 192.423558898092 | 10.5764411019076 | 195 | 0.74851840138925 | 0.989582598248431 | 0.0549643773479365 | weekly | |||||||||
6410 | 6410 | United States | Nebraska | NE | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 1934408 | 325 | 17 | 292.260651630153 | 32.7393483698469 | 308 | 0.87882184110074 | 1.6924737888722 | 0.112021061293183 | weekly | |||||||||
6562 | 6562 | United States | Nevada | NV | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 3080156 | 640 | 57 | 489.854636592343 | 150.145363407657 | 583 | 1.8505556212088 | 4.87460256583293 | 0.30651003826796 | weekly | |||||||||
6714 | 6714 | United States | New Hampshire | NH | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 1359711 | 231 | 5 | 236.822055138688 | -5.82205513868848 | 226 | 0.367725200428621 | -0.428183278556141 | -0.0245840917784408 | weekly | |||||||||
6866 | 6866 | United States | New Jersey | NJ | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 8882190 | 1324 | 147 | 1348.78446115389 | -24.7844611538853 | 1177 | 1.6549972473005 | -0.27903547609188 | -0.0183754053132271 | weekly | |||||||||
7018 | 7018 | United States | New Mexico | NM | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 2096829 | 402 | 26 | 343.97493734421 | 58.0250626557905 | 376 | 1.23996758915486 | 2.76727680968694 | 0.168689797878285 | weekly | |||||||||
7170 | 7170 | United States | New York | NY | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 19453561 | 2818 | 161 | 2807.23308270759 | 10.7669172924134 | 2657 | 0.827611972944182 | 0.0553467680925532 | 0.0038354197799737 | weekly | |||||||||
7322 | 7322 | United States | North Carolina | NC | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 10488084 | 2027 | 141 | 1748.37092731888 | 278.62907268112 | 1886 | 1.34438282530918 | 2.65662510598809 | 0.159364965595943 | weekly | |||||||||
7474 | 7474 | United States | North Dakota | ND | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 762062 | 134 | 3 | 127.117794487094 | 6.88220551290638 | 131 | 0.393668756610355 | 0.903103095667594 | 0.0541403785416144 | weekly | |||||||||
7626 | 7626 | United States | Ohio | OH | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 11689100 | 2537 | 99 | 2184.15037594183 | 352.849624058166 | 2438 | 0.84694287840809 | 3.01862097217208 | 0.161550059897324 | weekly | |||||||||
7778 | 7778 | United States | Oklahoma | OK | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 3956971 | 794 | 48 | 715.598997494513 | 78.4010025054874 | 746 | 1.21304907213118 | 1.98133881965492 | 0.109559966936774 | weekly | |||||||||
7930 | 7930 | United States | Oregon | OR | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 4217737 | 759 | 25 | 672.388471178852 | 86.6115288211479 | 734 | 0.592734919223271 | 2.05350710158428 | 0.12881173984036 | weekly | |||||||||
8082 | 8082 | United States | Pennsylvania | PA | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 12801989 | 2560 | 110 | 2360.28571428683 | 199.714285713168 | 2450 | 0.859241481929097 | 1.5600254438054 | 0.0846144534554847 | weekly | |||||||||
8234 | 8234 | United States | Rhode Island | RI | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 1059361 | 190 | 11 | 196.689223058525 | -6.68922305852468 | 179 | 1.03836180489937 | -0.631439429856742 | -0.0340090979795792 | weekly | |||||||||
8386 | 8386 | United States | South Carolina | SC | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 5148714 | 1335 | 177 | 929.137844612492 | 405.862155387508 | 1158 | 3.43775164050674 | 7.88278695199439 | 0.436815869400711 | weekly | |||||||||
8538 | 8538 | United States | South Dakota | SD | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 884659 | 158 | 7 | 145.609022557124 | 12.3909774428757 | 151 | 0.791265335004787 | 1.40065013105339 | 0.085097593715489 | weekly | |||||||||
8690 | 8690 | United States | Tennessee | TN | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 6833174 | 1650 | 92 | 1390.36090225654 | 259.639097743463 | 1558 | 1.34637285688905 | 3.79968514988003 | 0.186742231691119 | weekly | |||||||||
8842 | 8842 | United States | Texas | TX | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 28995881 | 6264 | 1668 | 3709.45112782007 | 2554.54887217993 | 4596 | 5.75254119714452 | 8.8100405439653 | 0.688659530522285 | weekly | |||||||||
8994 | 8994 | United States | Utah | UT | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 3205958 | 435 | 31 | 374.441102757738 | 60.5588972422615 | 404 | 0.966949660600669 | 1.88894855273405 | 0.161731435988861 | weekly | |||||||||
9146 | 9146 | United States | Vermont | VT | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 623989 | 90 | 0 | 96.9147869682911 | -6.91478696829105 | 90 | 0.0 | -1.10815847207099 | -0.0713491427325065 | weekly | |||||||||
9298 | 9298 | United States | Virginia | VA | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 8535519 | 1390 | 65 | 1253.74185463727 | 136.258145362729 | 1325 | 0.761523698793243 | 1.59636625918974 | 0.10868118094546 | weekly | |||||||||
9450 | 9450 | United States | Washington | WA | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 7614893 | 1180 | 26 | 1045.78947368506 | 134.210526314941 | 1154 | 0.341436183016623 | 1.76247422406251 | 0.128334172117856 | weekly | |||||||||
9602 | 9602 | United States | West Virginia | WV | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 1792147 | 426 | 4 | 383.025062657596 | 42.9749373424039 | 422 | 0.223195976669325 | 2.39795827811022 | 0.112198760687421 | weekly | |||||||||
9754 | 9754 | United States | Wisconsin | WI | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 5822434 | 1039 | 32 | 974.080200502103 | 64.9197994978965 | 1007 | 0.549598329495878 | 1.1149941673516 | 0.0666472837292378 | weekly | |||||||||
9906 | 9906 | United States | Wyoming | WY | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 578759 | 101 | 3 | 89.2781954895819 | 11.7218045104181 | 98 | 0.518350470575835 | 2.02533429465773 | 0.131295266958952 | weekly | |||||||||
11954 | 11954 | Canada | Canada | 0 | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 38454328 | 5275 | 58 | 5126.88210818327 | 148.117891816729 | 5217 | 0.150828276078573 | 0.385178728950169 | 0.0288904423178196 | weekly | |||||||||
17005 | 17005 | South Africa | South Africa | 0 | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 59893884 | 16711 | 977 | 10896.6259414226 | 5814.37405857743 | 15734 | 1.63121830602938 | 9.70779263301313 | 0.533593984948547 | 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);