economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where "start_date" is on date 2022-09-04 sorted by month
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths, non_covid_deaths, covid_deaths_per_100k, end_date (date)
country 2
cadence 1
- weekly 52
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2418 | 2418 | United States | Alabama | AL | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 4903185 | 1061 | 79 | 988.383458629553 | 72.6165413704471 | 982 | 1.6111976195065 | 1.48100757712481 | 0.0734700087667735 | weekly | |||||||||
2570 | 2570 | United States | Alaska | AK | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 731545 | 97 | 25 | 91.8170426113294 | 5.18295738867062 | 72 | 3.41742476539379 | 0.708494677520948 | 0.0564487511388336 | weekly | |||||||||
2722 | 2722 | United States | Arizona | AZ | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 7278717 | 1291 | 0 | 1193.39849625314 | 97.6015037468576 | 1291 | 0.0 | 1.34091631460404 | 0.0817845037121234 | weekly | |||||||||
2874 | 2874 | United States | Arkansas | AR | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 3017825 | 687 | 24 | 576.576441104527 | 110.423558895473 | 663 | 0.795274742571223 | 3.65904447393315 | 0.191515904957786 | weekly | |||||||||
3026 | 3026 | United States | California | CA | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 39512223 | 5960 | 326 | 4817.76190476211 | 1142.23809523789 | 5634 | 0.825061146268586 | 2.89084746063994 | 0.237088946655676 | weekly | |||||||||
3178 | 3178 | United States | Colorado | CO | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 5758736 | 864 | 25 | 785.288220552322 | 78.7117794476782 | 839 | 0.434123043667916 | 1.36682389065375 | 0.100232981200606 | weekly | |||||||||
3330 | 3330 | United States | Connecticut | CT | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 3565287 | 619 | 0 | 568.192982456523 | 50.8070175434774 | 619 | 0.0 | 1.42504705914215 | 0.0894185938795278 | weekly | |||||||||
3482 | 3482 | United States | Delaware | DE | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 973764 | 192 | 10 | 169.754385969546 | 22.2456140304537 | 182 | 1.02694287322185 | 2.28449747890184 | 0.131045886699178 | weekly | |||||||||
3634 | 3634 | United States | District of Columbia | DC | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 705749 | 131 | 0 | 109.375939850044 | 21.6240601499563 | 131 | 0.0 | 3.06398735952248 | 0.197703993946047 | weekly | |||||||||
3786 | 3786 | United States | Florida | FL | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 21477737 | 4458 | 436 | 3865.81453634171 | 592.185463658293 | 4022 | 2.03000902748739 | 2.75720604856225 | 0.153185171738396 | weekly | |||||||||
3938 | 3938 | United States | Georgia | GA | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 10617423 | 1829 | 103 | 1604.3934837098 | 224.606516290204 | 1726 | 0.970103574097029 | 2.11545227396708 | 0.139994657526813 | weekly | |||||||||
4090 | 4090 | United States | Hawaii | HI | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 1415872 | 238 | 11 | 221.395989975735 | 16.6040100242654 | 227 | 0.776906387018036 | 1.17270558526939 | 0.0749968869178037 | weekly | |||||||||
4242 | 4242 | United States | Idaho | ID | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 1787065 | 327 | 13 | 276.729323308911 | 50.2706766910893 | 314 | 0.727449757003802 | 2.8130301187192 | 0.181660100527086 | weekly | |||||||||
4394 | 4394 | United States | Illinois | IL | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 12671821 | 2004 | 11 | 1869.40350877234 | 134.596491227663 | 1993 | 0.0868067817561501 | 1.06217165810394 | 0.0719996996881933 | weekly | |||||||||
4546 | 4546 | United States | Indiana | IN | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 6732219 | 1326 | 66 | 1213.25563909957 | 112.744360900427 | 1260 | 0.980360264572498 | 1.67469835577878 | 0.0929271270349099 | weekly | |||||||||
4698 | 4698 | United States | Iowa | IA | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 3155070 | 618 | 28 | 552.796992481651 | 65.2030075183488 | 590 | 0.887460500083992 | 2.06661048782908 | 0.117951089468912 | weekly | |||||||||
4850 | 4850 | United States | Kansas | KS | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 2913314 | 531 | 8 | 495.453634085859 | 35.5463659141411 | 523 | 0.274601364631482 | 1.22013507346414 | 0.0717450906979948 | weekly | |||||||||
5002 | 5002 | United States | Kentucky | KY | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 4467673 | 971 | 78 | 872.213032583063 | 98.7869674169372 | 893 | 1.74587531361404 | 2.21115035538494 | 0.113260136831915 | weekly | |||||||||
5154 | 5154 | United States | Louisiana | LA | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 4648794 | 861 | 46 | 816.233082707549 | 44.7669172924514 | 815 | 0.989503944463876 | 0.962979157442798 | 0.0548457520785042 | weekly | |||||||||
5306 | 5306 | United States | Maine | ME | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 1344212 | 335 | 38 | 285.824561404121 | 49.1754385958794 | 297 | 2.82693503703285 | 3.6583097454776 | 0.172047630736504 | weekly | |||||||||
5458 | 5458 | United States | Maryland | MD | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 6045680 | 999 | 51 | 928.215538847941 | 70.7844611520588 | 948 | 0.843577562821717 | 1.17082712204514 | 0.0762586470378563 | weekly | |||||||||
5610 | 5610 | United States | Massachusetts | MA | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 6949503 | 1132 | 0 | 1029.91729323377 | 102.082706766225 | 1132 | 0.0 | 1.4689209683948 | 0.0991173829557732 | weekly | |||||||||
5762 | 5762 | United States | Michigan | MI | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 9986857 | 2010 | 83 | 1786.39598997562 | 223.604010024378 | 1927 | 0.831092304615957 | 2.23898279533168 | 0.125170461241031 | weekly | |||||||||
5914 | 5914 | United States | Minnesota | MN | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 5639632 | 995 | 0 | 862.546365915498 | 132.453634084502 | 995 | 0.0 | 2.34862193285842 | 0.153561175744932 | weekly | |||||||||
6066 | 6066 | United States | Mississippi | MS | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 2976149 | 655 | 27 | 596.24812030138 | 58.7518796986204 | 628 | 0.907212642915392 | 1.97409066880121 | 0.0985359579312781 | weekly | |||||||||
6218 | 6218 | United States | Missouri | MO | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 6137428 | 1333 | 0 | 1163.12030075262 | 169.879699247382 | 1333 | 0.0 | 2.76792981110951 | 0.146055140760124 | weekly | |||||||||
6370 | 6370 | United States | Montana | MT | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 1068778 | 207 | 7 | 195.513784461927 | 11.4862155380734 | 200 | 0.654953601215594 | 1.07470546157139 | 0.0587488783447399 | weekly | |||||||||
6522 | 6522 | United States | Nebraska | NE | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 1934408 | 331 | 33 | 304.187969925855 | 26.8120300741453 | 298 | 1.70594827978379 | 1.38605868431816 | 0.0881429666027906 | weekly | |||||||||
6674 | 6674 | United States | Nevada | NV | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 3080156 | 559 | 17 | 483.70927318375 | 75.2907268162501 | 542 | 0.551920097553501 | 2.44438031113522 | 0.155652849739039 | weekly | |||||||||
6826 | 6826 | United States | New Hampshire | NH | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 1359711 | 242 | 9 | 229.644110276456 | 12.3558897235437 | 233 | 0.661905360771517 | 0.908714405012808 | 0.0538045139005268 | weekly | |||||||||
6978 | 6978 | United States | New Jersey | NJ | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 8882190 | 1479 | 40 | 1328.23558897338 | 150.764411026623 | 1439 | 0.450339387020543 | 1.69737881115606 | 0.113507281598404 | weekly | |||||||||
7130 | 7130 | United States | New Mexico | NM | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 2096829 | 409 | 14 | 379.283208020862 | 29.7167919791377 | 395 | 0.667674855698772 | 1.41722534260723 | 0.0783498751083733 | weekly | |||||||||
7282 | 7282 | United States | New York | NY | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 19453561 | 3058 | 130 | 2761.79949874765 | 296.200501252348 | 2928 | 0.66825811479965 | 1.52260298899697 | 0.107249096607723 | weekly | |||||||||
7434 | 7434 | United States | North Carolina | NC | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 10488084 | 2059 | 30 | 1788.74185463723 | 270.258145362769 | 2029 | 0.286038899001953 | 2.5768114115292 | 0.151088400297749 | weekly | |||||||||
7586 | 7586 | United States | North Dakota | ND | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 762062 | 139 | 0 | 134.902255639976 | 4.09774436002422 | 139 | 0.0 | 0.537717975705943 | 0.0303756548812659 | weekly | |||||||||
7738 | 7738 | United States | Ohio | OH | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 11689100 | 2432 | 86 | 2206.96741854877 | 225.032581451229 | 2346 | 0.735728157000967 | 1.92514891181724 | 0.101964614230328 | weekly | |||||||||
7890 | 7890 | United States | Oklahoma | OK | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 3956971 | 803 | 39 | 708.197994988131 | 94.8020050118694 | 764 | 0.985602371106586 | 2.39582258782966 | 0.133863701511127 | weekly | |||||||||
8042 | 8042 | United States | Oregon | OR | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 4217737 | 767 | 44 | 661.443609023473 | 105.556390976527 | 723 | 1.04321345783296 | 2.50267835515887 | 0.159584867910911 | weekly | |||||||||
8194 | 8194 | United States | Pennsylvania | PA | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 12801989 | 2531 | 115 | 2299.57142857252 | 231.42857142748 | 2416 | 0.898297912925874 | 1.80775480612802 | 0.100639870782854 | weekly | |||||||||
8346 | 8346 | United States | Rhode Island | RI | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 1059361 | 189 | 7 | 199.378446116146 | -10.378446116146 | 182 | 0.660775694026871 | -0.979689276473839 | -0.0520540024175941 | weekly | |||||||||
8498 | 8498 | United States | South Carolina | SC | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 5148714 | 1131 | 0 | 955.609022557328 | 175.390977442672 | 1131 | 0.0 | 3.40650068041596 | 0.183538427644084 | weekly | |||||||||
8650 | 8650 | United States | South Dakota | SD | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 884659 | 185 | 9 | 153.218045113434 | 31.7819548865657 | 176 | 1.01734114500615 | 3.59256559720363 | 0.20742958091546 | weekly | |||||||||
8802 | 8802 | United States | Tennessee | TN | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 6833174 | 1606 | 17 | 1443.0551378455 | 162.944862154502 | 1589 | 0.248786288772977 | 2.38461456059075 | 0.112916587787339 | weekly | |||||||||
8954 | 8954 | United States | Texas | TX | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 28995881 | 4334 | 233 | 3826.90225563964 | 507.097744360359 | 4101 | 0.803562409433257 | 1.74886131019905 | 0.132508674245091 | weekly | |||||||||
9106 | 9106 | United States | Utah | UT | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 3205958 | 430 | 8 | 381.215538847924 | 48.7844611520757 | 422 | 0.249535396284044 | 1.52168123076084 | 0.127970809635693 | weekly | |||||||||
9258 | 9258 | United States | Vermont | VT | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 623989 | 115 | 8 | 92.1629072690087 | 22.8370927309913 | 107 | 1.28207388271268 | 3.65985501843642 | 0.247790498452197 | weekly | |||||||||
9410 | 9410 | United States | Virginia | VA | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 8535519 | 1485 | 124 | 1295.48370927381 | 189.516290726194 | 1361 | 1.45275290231326 | 2.22032533377518 | 0.146289983709968 | weekly | |||||||||
9562 | 9562 | United States | Washington | WA | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 7614893 | 1293 | 56 | 1070.24561403588 | 222.754385964117 | 1237 | 0.735401009574265 | 2.92524643437692 | 0.208133892858587 | weekly | |||||||||
9714 | 9714 | United States | West Virginia | WV | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 1792147 | 475 | 28 | 424.716791980939 | 50.2832080190605 | 447 | 1.56237183668527 | 2.80575243097026 | 0.118392323940225 | weekly | |||||||||
9866 | 9866 | United States | Wisconsin | WI | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 5822434 | 1053 | 62 | 1025.16040100333 | 27.8395989966707 | 991 | 1.06484676339826 | 0.478143659450166 | 0.027156334725204 | weekly | |||||||||
10018 | 10018 | United States | Wyoming | WY | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 578759 | 109 | 3 | 107.22305764494 | 1.7769423550601 | 106 | 0.518350470575835 | 0.307026301977179 | 0.0165723902497195 | weekly | |||||||||
17117 | 17117 | South Africa | South Africa | 0 | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 59893884 | 11069 | 21 | 10659.9765690375 | 409.023430962463 | 11048 | 0.0350620106720746 | 0.682913519120689 | 0.0383700121959489 | 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);