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" is on date 2021-08-15 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2363 | 2363 | United States | Alabama | AL | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 4903185 | 1577 | 177 | 962.370927305748 | 614.629072694252 | 1400 | 3.60989846395761 | 12.5353025165123 | 0.638661305381457 | weekly | |||||||||
2515 | 2515 | United States | Alaska | AK | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 731545 | 149 | 0 | 98.2794486253737 | 50.7205513746263 | 149 | 0.0 | 6.93334673528304 | 0.516085021681036 | weekly | |||||||||
2667 | 2667 | United States | Arizona | AZ | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 7278717 | 1495 | 73 | 1091.88220552408 | 403.117794475923 | 1422 | 1.00292400432659 | 5.53830839248075 | 0.369195314692794 | weekly | |||||||||
2819 | 2819 | United States | Arkansas | AR | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 3017825 | 857 | 182 | 579.098997495289 | 277.901002504711 | 675 | 6.03083346449844 | 9.20865200946744 | 0.479885138303959 | weekly | |||||||||
2971 | 2971 | United States | California | CA | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 39512223 | 6280 | 339 | 4698.57142857184 | 1581.42857142816 | 5941 | 0.857962357622855 | 4.00237812847978 | 0.336576467011132 | weekly | |||||||||
3123 | 3123 | United States | Colorado | CO | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 5758736 | 914 | 35 | 743.132832081217 | 170.867167918783 | 879 | 0.607772261135082 | 2.96709499999276 | 0.229928164309808 | weekly | |||||||||
3275 | 3275 | United States | Connecticut | CT | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 3565287 | 634 | 30 | 541.728070176013 | 92.2719298239872 | 604 | 0.841446985894824 | 2.58806457443643 | 0.170328869600586 | weekly | |||||||||
3427 | 3427 | United States | Delaware | DE | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 973764 | 218 | 14 | 169.81578947748 | 48.1842105225195 | 204 | 1.43772002251059 | 4.94824315979226 | 0.283743995012368 | weekly | |||||||||
3579 | 3579 | United States | District of Columbia | DC | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 705749 | 132 | 5 | 112.615288220969 | 19.3847117790309 | 127 | 0.7084671745904 | 2.74668639686785 | 0.17213215084079 | weekly | |||||||||
3731 | 3731 | United States | Florida | FL | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 21477737 | 7165 | 363 | 3779.3609022566 | 3385.6390977434 | 6802 | 1.69012219490349 | 15.7634814959481 | 0.895823178919453 | weekly | |||||||||
3883 | 3883 | United States | Georgia | GA | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 10617423 | 2550 | 221 | 1658.3784461158 | 891.621553884197 | 2329 | 2.08148436772275 | 8.39772093364084 | 0.537646612552474 | weekly | |||||||||
4035 | 4035 | United States | Hawaii | HI | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 1415872 | 302 | 15 | 215.796992482052 | 86.2030075179484 | 287 | 1.05941780047914 | 6.08833337462344 | 0.399463433324346 | weekly | |||||||||
4187 | 4187 | United States | Idaho | ID | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 1787065 | 346 | 38 | 254.796992481925 | 91.2030075180755 | 308 | 2.12639159739573 | 5.10350812746461 | 0.35794381491589 | weekly | |||||||||
4339 | 4339 | United States | Illinois | IL | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 12671821 | 2266 | 137 | 1819.71929824608 | 446.280701753918 | 2129 | 1.08113900914478 | 3.52183558901217 | 0.245247001657927 | weekly | |||||||||
4491 | 4491 | United States | Indiana | IN | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 6732219 | 1497 | 100 | 1197.85839599158 | 299.141604008423 | 1397 | 1.48539434026136 | 4.44343245530816 | 0.249730356283721 | weekly | |||||||||
4643 | 4643 | United States | Iowa | IA | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 3155070 | 648 | 16 | 524.097744361463 | 123.902255638537 | 632 | 0.507120285762281 | 3.92708420537539 | 0.236410587474469 | weekly | |||||||||
4795 | 4795 | United States | Kansas | KS | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 2913314 | 625 | 109 | 477.590225564621 | 147.409774435379 | 516 | 3.74144359310394 | 5.05986565249673 | 0.308653248213165 | weekly | |||||||||
4947 | 4947 | United States | Kentucky | KY | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 4467673 | 1194 | 91 | 874.909774437533 | 319.090225562467 | 1103 | 2.03685453254972 | 7.14220189262883 | 0.364712150767324 | weekly | |||||||||
5099 | 5099 | United States | Louisiana | LA | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 4648794 | 1411 | 399 | 842.258145364258 | 568.741854635742 | 1012 | 8.5828711704584 | 12.2341806205167 | 0.675258360831611 | weekly | |||||||||
5251 | 5251 | United States | Maine | ME | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 1344212 | 306 | 20 | 280.535087719982 | 25.4649122800179 | 286 | 1.48786054580676 | 1.89441191419344 | 0.090772646256057 | weekly | |||||||||
5403 | 5403 | United States | Maryland | MD | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 6045680 | 945 | 45 | 919.828320802863 | 25.171679197137 | 900 | 0.744333143666221 | 0.416358113514725 | 0.0273656275066265 | weekly | |||||||||
5555 | 5555 | United States | Massachusetts | MA | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 6949503 | 1131 | 32 | 1042.35463659222 | 88.6453634077839 | 1099 | 0.460464582862976 | 1.27556407138444 | 0.08504338187394 | weekly | |||||||||
5707 | 5707 | United States | Michigan | MI | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 9986857 | 2049 | 109 | 1782.46365914867 | 266.536340851334 | 1940 | 1.09143447232698 | 2.6688711058077 | 0.149532552589956 | weekly | |||||||||
5859 | 5859 | United States | Minnesota | MN | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 5639632 | 895 | 31 | 823.243107770194 | 71.7568922298055 | 864 | 0.549681255798251 | 1.27236834300191 | 0.0871636720095521 | weekly | |||||||||
6011 | 6011 | United States | Mississippi | MS | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 2976149 | 993 | 230 | 569.602756892916 | 423.397243107084 | 763 | 7.72810769890889 | 14.2263456267507 | 0.743320213927057 | weekly | |||||||||
6163 | 6163 | United States | Missouri | MO | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 6137428 | 1646 | 175 | 1176.92355889802 | 469.076441101981 | 1471 | 2.85135727865158 | 7.64288299760064 | 0.398561518762687 | weekly | |||||||||
6315 | 6315 | United States | Montana | MT | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 1068778 | 270 | 25 | 187.468671680012 | 82.5313283199881 | 245 | 2.33912000434141 | 7.7220272423261 | 0.440240641704977 | weekly | |||||||||
6467 | 6467 | United States | Nebraska | NE | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 1934408 | 357 | 0 | 300.724310778006 | 56.2756892219937 | 357 | 0.0 | 2.90919440066386 | 0.187133820596022 | weekly | |||||||||
6619 | 6619 | United States | Nevada | NV | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 3080156 | 710 | 120 | 475.781954888051 | 234.218045111949 | 590 | 3.89590657096589 | 7.60409684158689 | 0.492280219343458 | weekly | |||||||||
6771 | 6771 | United States | New Hampshire | NH | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 1359711 | 257 | 2 | 230.066416040908 | 26.9335839590922 | 255 | 0.147090080171448 | 1.98083151192365 | 0.117068733553459 | weekly | |||||||||
6923 | 6923 | United States | New Jersey | NJ | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 8882190 | 1462 | 0 | 1293.1766917303 | 168.823308269697 | 1462 | 0.0 | 1.90069462902389 | 0.130549297206871 | weekly | |||||||||
7075 | 7075 | United States | New Mexico | NM | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 2096829 | 454 | 26 | 358.295739349208 | 95.7042606507921 | 428 | 1.23996758915486 | 4.56423774426966 | 0.267109681026699 | weekly | |||||||||
7227 | 7227 | United States | New York | NY | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 19453561 | 3074 | 122 | 2791.18295739429 | 282.817042605711 | 2952 | 0.627134538504287 | 1.45380602865311 | 0.101325153858683 | weekly | |||||||||
7379 | 7379 | United States | North Carolina | NC | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 10488084 | 2412 | 233 | 1778.72305764474 | 633.276942355258 | 2179 | 2.2215687822485 | 6.03806131182071 | 0.356028972376284 | weekly | |||||||||
7531 | 7531 | United States | North Dakota | ND | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 762062 | 142 | 6 | 153.010025063538 | -11.0100250635383 | 136 | 0.787337513220709 | -1.44476762567066 | -0.0719562333184791 | weekly | |||||||||
7683 | 7683 | United States | Ohio | OH | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 11689100 | 2553 | 75 | 2185.05889724529 | 367.941102754708 | 2478 | 0.641623392733401 | 3.14772824900727 | 0.168389558386079 | weekly | |||||||||
7835 | 7835 | United States | Oklahoma | OK | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 3956971 | 1132 | 270 | 708.398496241323 | 423.601503758677 | 862 | 6.82340103073791 | 10.7051960643299 | 0.597970642239157 | weekly | |||||||||
7987 | 7987 | United States | Oregon | OR | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 4217737 | 943 | 77 | 671.749373434499 | 271.250626565501 | 866 | 1.82562355120767 | 6.43118872906255 | 0.403797364452547 | weekly | |||||||||
8139 | 8139 | United States | Pennsylvania | PA | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 12801989 | 2653 | 109 | 2329.09523809633 | 323.90476190367 | 2544 | 0.851430195729742 | 2.53011279656364 | 0.139068921101059 | weekly | |||||||||
8291 | 8291 | United States | Rhode Island | RI | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 1059361 | 210 | 9 | 186.867167920669 | 23.1328320793309 | 201 | 0.84956874946312 | 2.18365902457528 | 0.123792918449706 | weekly | |||||||||
8443 | 8443 | United States | South Carolina | SC | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 5148714 | 1359 | 174 | 936.873433584915 | 422.126566415085 | 1185 | 3.37948466354899 | 8.19867963951939 | 0.450569469986817 | weekly | |||||||||
8595 | 8595 | United States | South Dakota | SD | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 884659 | 163 | 5 | 153.413533835279 | 9.58646616472063 | 158 | 0.565189525003419 | 1.08363405161996 | 0.0624877474956913 | weekly | |||||||||
8747 | 8747 | United States | Tennessee | TN | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 6833174 | 1964 | 201 | 1353.04135338436 | 610.958646615636 | 1763 | 2.94153200255108 | 8.94106672266264 | 0.451544696019411 | weekly | |||||||||
8899 | 8899 | United States | Texas | TX | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 28995881 | 6339 | 1711 | 3780.34335839654 | 2558.65664160346 | 4628 | 5.90083812249057 | 8.82420727828019 | 0.676831811036535 | weekly | |||||||||
9051 | 9051 | United States | Utah | UT | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 3205958 | 463 | 47 | 361.661654136169 | 101.338345863831 | 416 | 1.46602045316876 | 3.16093803673758 | 0.280202074798001 | weekly | |||||||||
9203 | 9203 | United States | Vermont | VT | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 623989 | 119 | 6 | 102.205513785316 | 16.7944862146842 | 113 | 0.961555412034507 | 2.69147151867809 | 0.164320745453727 | weekly | |||||||||
9355 | 9355 | United States | Virginia | VA | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 8535519 | 1605 | 39 | 1276.94611528888 | 328.053884711118 | 1566 | 0.456914219275946 | 3.84339704136466 | 0.256905033644981 | weekly | |||||||||
9507 | 9507 | United States | Washington | WA | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 7614893 | 1329 | 91 | 1048.35087719381 | 280.649122806192 | 1238 | 1.19502664055818 | 3.68552943299652 | 0.26770533502812 | weekly | |||||||||
9659 | 9659 | United States | West Virginia | WV | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 1792147 | 510 | 32 | 419.870927319269 | 90.1290726807314 | 478 | 1.7855678133546 | 5.02911160081909 | 0.214658998316875 | weekly | |||||||||
9811 | 9811 | United States | Wisconsin | WI | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 5822434 | 1150 | 42 | 980.120300752726 | 169.879699247274 | 1108 | 0.721347807463339 | 2.91767496629888 | 0.173325355180183 | weekly | |||||||||
9963 | 9963 | United States | Wyoming | WY | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 578759 | 107 | 16 | 89.4172932339295 | 17.5827067660705 | 91 | 2.76453584307112 | 3.03800144206318 | 0.196636535620368 | 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);