economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
51 rows where cadence = "weekly", country = "United States" and start_date = "2021-08-01" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2361 | 2361 | United States | Alabama | AL | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 4903185 | 1330 | 58 | 978.037593972453 | 351.962406027547 | 1272 | 1.18290458140984 | 7.17824038920715 | 0.359865927645988 | weekly | |||||||||
2513 | 2513 | United States | Alaska | AK | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 731545 | 144 | 8 | 83.2794486253541 | 60.7205513746459 | 136 | 1.09357592492601 | 8.30031664144323 | 0.729118076271217 | weekly | |||||||||
2665 | 2665 | United States | Arizona | AZ | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 7278717 | 1507 | 118 | 1148.2155388574 | 358.784461142605 | 1389 | 1.62116482891147 | 4.92922669122326 | 0.312471351415115 | weekly | |||||||||
2817 | 2817 | United States | Arkansas | AR | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 3017825 | 899 | 146 | 554.098997495271 | 344.901002504729 | 753 | 4.8379213506416 | 11.428793999146 | 0.622453756573838 | weekly | |||||||||
2969 | 2969 | United States | California | CA | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 39512223 | 5735 | 206 | 4720.90476190517 | 1014.09523809483 | 5529 | 0.521357656844567 | 2.56653552014734 | 0.214809509879961 | weekly | |||||||||
3121 | 3121 | United States | Colorado | CO | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 5758736 | 843 | 25 | 752.466165414533 | 90.5338345854672 | 818 | 0.434123043667916 | 1.57211295300683 | 0.12031615339886 | weekly | |||||||||
3273 | 3273 | United States | Connecticut | CT | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 3565287 | 613 | 3 | 578.061403509327 | 34.9385964906726 | 610 | 0.0841446985894824 | 0.979965890282397 | 0.0604409778590396 | weekly | |||||||||
3425 | 3425 | United States | Delaware | DE | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 973764 | 189 | 133 | 159.149122810795 | 29.8508771892047 | 56 | 13.6583402138506 | 3.06551455888744 | 0.187565452212344 | weekly | |||||||||
3577 | 3577 | United States | District of Columbia | DC | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 705749 | 127 | 0 | 108.948621554284 | 18.0513784457163 | 127 | 0.0 | 2.55776181697973 | 0.165687075138644 | weekly | |||||||||
3729 | 3729 | United States | Florida | FL | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 21477737 | 5978 | 1161 | 3857.02756892325 | 2120.97243107675 | 4817 | 5.40559743328638 | 9.8752137204993 | 0.549898177592975 | weekly | |||||||||
3881 | 3881 | United States | Georgia | GA | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 10617423 | 2055 | 126 | 1610.71177944911 | 444.288220550886 | 1929 | 1.18672864404103 | 4.18452029791868 | 0.275833470779508 | weekly | |||||||||
4033 | 4033 | United States | Hawaii | HI | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 1415872 | 217 | 3 | 209.796992482035 | 7.20300751796455 | 214 | 0.211883560095828 | 0.508732958767781 | 0.0343332258139084 | weekly | |||||||||
4185 | 4185 | United States | Idaho | ID | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 1787065 | 335 | 13 | 257.463659148575 | 77.5363408514248 | 322 | 0.727449757003802 | 4.33875325471792 | 0.301154505097283 | weekly | |||||||||
4337 | 4337 | United States | Illinois | IL | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 12671821 | 2117 | 81 | 1863.0526315794 | 253.947368420598 | 2036 | 0.639213574749833 | 2.00403216254869 | 0.136307135996107 | weekly | |||||||||
4489 | 4489 | United States | Indiana | IN | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 6732219 | 1359 | 49 | 1192.52506265822 | 166.474937341775 | 1310 | 0.727843226728067 | 2.47280929722837 | 0.139598690672958 | weekly | |||||||||
4641 | 4641 | United States | Iowa | IA | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 3155070 | 609 | 23 | 530.764411028112 | 78.2355889718881 | 586 | 0.728985410783279 | 2.47967838976277 | 0.147401723526155 | weekly | |||||||||
4793 | 4793 | United States | Kansas | KS | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 2913314 | 605 | 44 | 466.25689223127 | 138.74310776873 | 561 | 1.51030750547315 | 4.76238084081324 | 0.297567950373399 | weekly | |||||||||
4945 | 4945 | United States | Kentucky | KY | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 4467673 | 1085 | 38 | 865.243107770847 | 219.756892229153 | 1047 | 0.850554639965817 | 4.91882221973616 | 0.253982828936159 | weekly | |||||||||
5097 | 5097 | United States | Louisiana | LA | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 4648794 | 1317 | 211 | 830.924812030906 | 486.075187969094 | 1106 | 4.53881157134517 | 10.4559416478574 | 0.584980952465545 | weekly | |||||||||
5249 | 5249 | United States | Maine | ME | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 1344212 | 276 | 1 | 282.201754386631 | -6.20175438663057 | 275 | 0.0743930272903381 | -0.461367283332582 | -0.0219763140739864 | weekly | |||||||||
5401 | 5401 | United States | Maryland | MD | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 6045680 | 953 | 27 | 910.494987469511 | 42.5050125304889 | 926 | 0.446599886199733 | 0.703064213297576 | 0.0466834118973249 | weekly | |||||||||
5553 | 5553 | United States | Massachusetts | MA | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 6949503 | 1139 | 13 | 1057.3546365922 | 81.645363407798 | 1126 | 0.187063736788084 | 1.17483744388337 | 0.0772166315654856 | weekly | |||||||||
5705 | 5705 | United States | Michigan | MI | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 9986857 | 1937 | 33 | 1797.13032581531 | 139.869674184691 | 1904 | 0.330434289787067 | 1.40053746824142 | 0.0778294552017176 | weekly | |||||||||
5857 | 5857 | United States | Minnesota | MN | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 5639632 | 905 | 26 | 855.909774436837 | 49.0902255631632 | 879 | 0.461022988734017 | 0.870450865644482 | 0.057354439719377 | weekly | |||||||||
6009 | 6009 | United States | Mississippi | MS | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 2976149 | 852 | 78 | 578.602756892897 | 273.397243107103 | 774 | 2.6208365239778 | 9.18627538833246 | 0.472512859384301 | weekly | |||||||||
6161 | 6161 | United States | Missouri | MO | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 6137428 | 1655 | 160 | 1122.25689223133 | 532.743107768666 | 1495 | 2.60695522619573 | 8.68023393135799 | 0.474706915552496 | weekly | |||||||||
6313 | 6313 | United States | Montana | MT | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 1068778 | 238 | 18 | 206.802005013327 | 31.1979949866733 | 220 | 1.68416640312581 | 2.91903416674682 | 0.150859248123164 | weekly | |||||||||
6465 | 6465 | United States | Nebraska | NE | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 1934408 | 367 | 10 | 303.057644111319 | 63.9423558886806 | 357 | 0.516954024176906 | 3.30552581920053 | 0.210990737673633 | weekly | |||||||||
6617 | 6617 | United States | Nevada | NV | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 3080156 | 662 | 93 | 503.115288221364 | 158.884711778636 | 569 | 3.01932759249856 | 5.15833327203673 | 0.31580179632452 | weekly | |||||||||
6769 | 6769 | United States | New Hampshire | NH | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 1359711 | 249 | 2 | 230.066416040889 | 18.9335839591114 | 247 | 0.147090080171448 | 1.39247119123927 | 0.0822961659721182 | weekly | |||||||||
6921 | 6921 | United States | New Jersey | NJ | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 8882190 | 1396 | 27 | 1321.84335839695 | 74.1566416030487 | 1369 | 0.303979086238867 | 0.834891413075477 | 0.0561009299112274 | weekly | |||||||||
7073 | 7073 | United States | New Mexico | NM | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 2096829 | 409 | 15 | 323.962406015854 | 85.0375939841457 | 394 | 0.715365916820113 | 4.05553309230966 | 0.262492167007749 | weekly | |||||||||
7225 | 7225 | United States | New York | NY | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 19453561 | 3161 | 60 | 2776.84962406094 | 384.150375939061 | 3101 | 0.308426822215223 | 1.9747046617278 | 0.138340359740931 | weekly | |||||||||
7377 | 7377 | United States | North Carolina | NC | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 10488084 | 2200 | 101 | 1749.38972431137 | 450.61027568863 | 2099 | 0.962997626639909 | 4.29640223789807 | 0.257581412207053 | weekly | |||||||||
7529 | 7529 | United States | North Dakota | ND | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 762062 | 128 | 3 | 136.676691730186 | -8.67669173018595 | 125 | 0.393668756610355 | -1.13858081497122 | -0.0634833315055258 | weekly | |||||||||
7681 | 7681 | United States | Ohio | OH | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 11689100 | 2456 | 64 | 2177.72556391195 | 278.274436088045 | 2392 | 0.547518628465836 | 2.38063183725047 | 0.127782141468812 | weekly | |||||||||
7833 | 7833 | United States | Oklahoma | OK | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 3956971 | 941 | 157 | 702.398496241305 | 238.601503758695 | 784 | 3.96768134009574 | 6.02990276549146 | 0.339695351051442 | weekly | |||||||||
7985 | 7985 | United States | Oregon | OR | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 4217737 | 808 | 31 | 674.416040101146 | 133.583959898854 | 777 | 0.734991299836856 | 3.16719510720687 | 0.198073521321971 | weekly | |||||||||
8137 | 8137 | United States | Pennsylvania | PA | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 12801989 | 2533 | 52 | 2315.09523809632 | 217.904761903676 | 2481 | 0.406186882366482 | 1.70211645943202 | 0.0941234547581105 | weekly | |||||||||
8289 | 8289 | United States | Rhode Island | RI | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 1059361 | 227 | 3 | 177.533834587319 | 49.4661654126812 | 224 | 0.283189583154373 | 4.66943425448749 | 0.27862951041229 | weekly | |||||||||
8441 | 8441 | United States | South Carolina | SC | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 5148714 | 1140 | 46 | 942.873433584892 | 197.126566415108 | 1094 | 0.8934269800187 | 3.82865636768925 | 0.209070018725222 | weekly | |||||||||
8593 | 8593 | United States | South Dakota | SD | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 884659 | 159 | 7 | 157.746867168596 | 1.25313283140395 | 152 | 0.791265335004787 | 0.141651509949477 | 0.00794394750207394 | weekly | |||||||||
8745 | 8745 | United States | Tennessee | TN | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 6833174 | 1710 | 95 | 1442.04135338433 | 267.958646615667 | 1615 | 1.3902763196137 | 3.9214374844789 | 0.185818975292763 | weekly | |||||||||
8897 | 8897 | United States | Texas | TX | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 28995881 | 5121 | 747 | 3864.67669172983 | 1256.32330827017 | 4374 | 2.57622798217443 | 4.33276474086153 | 0.325078501639897 | weekly | |||||||||
9049 | 9049 | United States | Utah | UT | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 3205958 | 459 | 43 | 371.994987469482 | 87.0050125305175 | 416 | 1.34125275502673 | 2.71385378506261 | 0.233887593815105 | weekly | |||||||||
9201 | 9201 | United States | Vermont | VT | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 623989 | 160 | 0 | 102.538847118632 | 57.4611528813681 | 160 | 0.0 | 9.20868042247028 | 0.560384229938617 | weekly | |||||||||
9353 | 9353 | United States | Virginia | VA | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 8535519 | 1516 | 26 | 1267.61278195552 | 248.387218044483 | 1490 | 0.304609479517297 | 2.91004235412613 | 0.195948811482716 | weekly | |||||||||
9505 | 9505 | United States | Washington | WA | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 7614893 | 1276 | 46 | 1049.68421052712 | 226.31578947288 | 1230 | 0.604079400721717 | 2.97201535823129 | 0.215603690332 | weekly | |||||||||
9657 | 9657 | United States | West Virginia | WV | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 1792147 | 525 | 19 | 390.537593985918 | 134.462406014082 | 506 | 1.06018088917929 | 7.50286700890507 | 0.344300799935102 | weekly | |||||||||
9809 | 9809 | United States | Wisconsin | WI | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 5822434 | 1074 | 22 | 972.786967419363 | 101.213032580637 | 1052 | 0.377848851528416 | 1.73832855092281 | 0.104044396122142 | weekly | |||||||||
9961 | 9961 | United States | Wyoming | WY | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 578759 | 124 | 10 | 92.7506265672441 | 31.2493734327559 | 114 | 1.72783490191945 | 5.39937580802302 | 0.336918192246391 | 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);