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 end_date = "2020-06-06" sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2300 | 2300 | United States | Alabama | AL | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 4903185 | 1173 | 66 | 1016.69172931531 | 156.308270684686 | 1107 | 1.34606383401809 | 3.18789257767524 | 0.153742050001676 | weekly | |||||||||
2452 | 2452 | United States | Alaska | AK | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 731545 | 79 | 1 | 90.0751879727754 | -11.0751879727754 | 78 | 0.136696990615752 | -1.51394486638217 | -0.122954924902547 | weekly | |||||||||
2604 | 2604 | United States | Arizona | AZ | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 7278717 | 1399 | 139 | 1147.36591479502 | 251.634085204978 | 1260 | 1.90967721371775 | 3.45712142957307 | 0.219314590018941 | weekly | |||||||||
2756 | 2756 | United States | Arkansas | AR | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 3017825 | 649 | 19 | 577.288220552744 | 71.7117794472557 | 630 | 0.629592504535551 | 2.37627362246836 | 0.124221795793084 | weekly | |||||||||
2908 | 2908 | United States | California | CA | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 39512223 | 5518 | 501 | 4996.04761904829 | 521.952380951714 | 5017 | 1.26796206834528 | 1.32098966173509 | 0.104473059656534 | weekly | |||||||||
3060 | 3060 | United States | Colorado | CO | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 5758736 | 820 | 82 | 749.6441102768 | 70.3558897231999 | 738 | 1.42392358323076 | 1.22172451946399 | 0.0938523877646709 | weekly | |||||||||
3212 | 3212 | United States | Connecticut | CT | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 3565287 | 669 | 143 | 604.9298245622 | 64.0701754378 | 526 | 4.01089729943199 | 1.79705520026298 | 0.105913401582025 | weekly | |||||||||
3364 | 3364 | United States | Delaware | DE | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 973764 | 182 | 29 | 170.210526318776 | 11.7894736812241 | 153 | 2.97813433234336 | 1.21071159759696 | 0.0692640692453084 | weekly | |||||||||
3516 | 3516 | United States | District of Columbia | DC | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 705749 | 149 | 21 | 109.854636591925 | 39.1453634080746 | 128 | 2.97556213327968 | 5.54664100240661 | 0.356337835365903 | weekly | |||||||||
3668 | 3668 | United States | Florida | FL | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 21477737 | 4265 | 242 | 3962.24060150481 | 302.75939849519 | 4023 | 1.12674812993566 | 1.40964291766488 | 0.0764111594788581 | weekly | |||||||||
3820 | 3820 | United States | Georgia | GA | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 10617423 | 1782 | 173 | 1604.69674185515 | 177.30325814485 | 1609 | 1.62939726523093 | 1.66992742160551 | 0.110490196384318 | weekly | |||||||||
3972 | 3972 | United States | Hawaii | HI | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 1415872 | 217 | 0 | 219.197994988398 | -2.19799498839799 | 217 | 0.0 | -0.155239667738185 | -0.0100274411201359 | weekly | |||||||||
4124 | 4124 | United States | Idaho | ID | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 1787065 | 294 | 1 | 269.531328321635 | 24.4686716783646 | 293 | 0.0559576736156771 | 1.36920994358709 | 0.0907822917310961 | weekly | |||||||||
4276 | 4276 | United States | Illinois | IL | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 12671821 | 2511 | 532 | 1911.03508771987 | 599.964912280128 | 1979 | 4.19829162675199 | 4.73463847287717 | 0.313947617254882 | weekly | |||||||||
4428 | 4428 | United States | Indiana | IN | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 6732219 | 1396 | 167 | 1218.46115288361 | 177.538847116392 | 1229 | 2.48060854823647 | 2.63715198683216 | 0.145707433262217 | weekly | |||||||||
4580 | 4580 | United States | Iowa | IA | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 3155070 | 600 | 71 | 563.398496241303 | 36.6015037586967 | 529 | 2.25034626807012 | 1.16008531533997 | 0.0649655687810362 | weekly | |||||||||
4732 | 4732 | United States | Kansas | KS | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 2913314 | 499 | 19 | 489.726817043411 | 9.27318295658904 | 480 | 0.652178240999769 | 0.318303586794593 | 0.0189354199808238 | weekly | |||||||||
4884 | 4884 | United States | Kentucky | KY | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 4467673 | 918 | 38 | 900.606516292028 | 17.3934837079723 | 880 | 0.850554639965817 | 0.389318638762782 | 0.0193130777907145 | weekly | |||||||||
5036 | 5036 | United States | Louisiana | LA | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 4648794 | 1016 | 134 | 884.616541354335 | 131.383458645665 | 882 | 2.8824680121339 | 2.82618370798244 | 0.148520237304764 | weekly | |||||||||
5188 | 5188 | United States | Maine | ME | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 1344212 | 255 | 9 | 262.245614035869 | -7.24561403586949 | 246 | 0.669537245613043 | -0.539023162705696 | -0.0276291142656764 | weekly | |||||||||
5340 | 5340 | United States | Maryland | MD | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 6045680 | 1167 | 361 | 938.774436091146 | 228.225563908854 | 806 | 5.97120588585569 | 3.77501892109496 | 0.243110117973744 | weekly | |||||||||
5492 | 5492 | United States | Massachusetts | MA | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 6949503 | 1236 | 521 | 1066.45864661737 | 169.541353382627 | 715 | 7.49693898973783 | 2.43961839260487 | 0.158976022108671 | weekly | |||||||||
5644 | 5644 | United States | Michigan | MI | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 9986857 | 2000 | 426 | 1766.86466165506 | 233.135338344943 | 1574 | 4.26560628634214 | 2.33442151364481 | 0.131948611234638 | weekly | |||||||||
5796 | 5796 | United States | Minnesota | MN | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 5639632 | 1038 | 143 | 812.939849624898 | 225.060150375102 | 895 | 2.53562643803709 | 3.99068858349448 | 0.276847235965794 | weekly | |||||||||
5948 | 5948 | United States | Mississippi | MS | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 2976149 | 728 | 88 | 597.957393484482 | 130.042606515518 | 640 | 2.95684120653905 | 4.3694924721685 | 0.217478047654398 | weekly | |||||||||
6100 | 6100 | United States | Missouri | MO | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 6137428 | 1293 | 37 | 1179.39348371012 | 113.606516289881 | 1256 | 0.602858396057762 | 1.85104438357372 | 0.0963262200945008 | weekly | |||||||||
6252 | 6252 | United States | Montana | MT | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 1068778 | 178 | 1 | 199.090225564794 | -21.0902255647939 | 177 | 0.0935648001736563 | -1.97330274058728 | -0.105933003516188 | weekly | |||||||||
6404 | 6404 | United States | Nebraska | NE | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 1934408 | 319 | 20 | 309.593984963521 | 9.4060150364794 | 299 | 1.03390804835381 | 0.486247732457651 | 0.0303817757880138 | weekly | |||||||||
6556 | 6556 | United States | Nevada | NV | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 3080156 | 562 | 25 | 506.521303259041 | 55.4786967409593 | 537 | 0.81164720228456 | 1.80116515984773 | 0.109528851765958 | weekly | |||||||||
6708 | 6708 | United States | New Hampshire | NH | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 1359711 | 259 | 41 | 205.48872180539 | 53.5112781946098 | 218 | 3.01534664351469 | 3.93548909986091 | 0.26040980606852 | weekly | |||||||||
6860 | 6860 | United States | New Jersey | NJ | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 8882190 | 1587 | 472 | 1364.78446115392 | 222.215538846078 | 1115 | 5.31400476684241 | 2.50181023875956 | 0.162820976623807 | weekly | |||||||||
7012 | 7012 | United States | New Mexico | NM | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 2096829 | 448 | 41 | 361.641604010908 | 86.3583959890917 | 407 | 1.95533350597497 | 4.11852354145673 | 0.238795523057372 | weekly | |||||||||
7164 | 7164 | United States | New York | NY | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 19453561 | 3088 | 550 | 2805.23308270762 | 282.766917292376 | 2538 | 2.82724587030621 | 1.4535483621347 | 0.100799794154519 | weekly | |||||||||
7316 | 7316 | United States | North Carolina | NC | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 10488084 | 1967 | 112 | 1820.03759398557 | 146.962406014425 | 1855 | 1.06787855627396 | 1.40123216036814 | 0.0807469068221842 | weekly | |||||||||
7468 | 7468 | United States | North Dakota | ND | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 762062 | 161 | 13 | 137.451127820462 | 23.5488721795381 | 148 | 1.70589794531154 | 3.09015174349831 | 0.17132541982702 | weekly | |||||||||
7620 | 7620 | United States | Ohio | OH | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 11689100 | 2597 | 224 | 2247.81704260854 | 349.182957391457 | 2373 | 1.91631519963042 | 2.98725271741585 | 0.155343139931992 | weekly | |||||||||
7772 | 7772 | United States | Oklahoma | OK | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 3956971 | 789 | 15 | 710.932330827881 | 78.0676691721188 | 774 | 0.379077835040995 | 1.97291486776423 | 0.109810267147661 | weekly | |||||||||
7924 | 7924 | United States | Oregon | OR | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 4217737 | 683 | 8 | 680.721804512219 | 2.27819548778109 | 675 | 0.189675174151447 | 0.0540146407369898 | 0.00334673499905525 | weekly | |||||||||
8076 | 8076 | United States | Pennsylvania | PA | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 12801989 | 2730 | 393 | 2460.28571428688 | 269.714285713123 | 2337 | 3.06983547634668 | 2.10681547775992 | 0.109627220995875 | weekly | |||||||||
8228 | 8228 | United States | Rhode Island | RI | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 1059361 | 241 | 54 | 199.689223058563 | 41.3107769414366 | 187 | 5.09741249677872 | 3.89959390060957 | 0.206875345142293 | weekly | |||||||||
8380 | 8380 | United States | South Carolina | SC | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 5148714 | 1037 | 62 | 938.471177945849 | 98.5288220541514 | 975 | 1.20418419045999 | 1.91365886810088 | 0.104988650018868 | weekly | |||||||||
8532 | 8532 | United States | South Dakota | SD | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 884659 | 147 | 5 | 164.942355890492 | -17.9423558904921 | 142 | 0.565189525003419 | -2.0281663206379 | -0.1087795538849 | weekly | |||||||||
8684 | 8684 | United States | Tennessee | TN | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 6833174 | 1485 | 48 | 1439.36090225657 | 45.6390977434332 | 1437 | 0.702455403594289 | 0.667904808855054 | 0.0317078904060004 | weekly | |||||||||
8836 | 8836 | United States | Texas | TX | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 28995881 | 4229 | 173 | 3839.78446115342 | 389.215538846585 | 4056 | 0.596636467089929 | 1.34231320250826 | 0.101363902787833 | weekly | |||||||||
8988 | 8988 | United States | Utah | UT | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 3205958 | 410 | 13 | 381.107769424437 | 28.8922305755632 | 397 | 0.405495018961571 | 0.901204275775392 | 0.0758111822784338 | weekly | |||||||||
9140 | 9140 | United States | Vermont | VT | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 623989 | 119 | 0 | 101.581453634993 | 17.4185463650073 | 119 | 0.0 | 2.79148292117446 | 0.171473686797163 | weekly | |||||||||
9292 | 9292 | United States | Virginia | VA | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 8535519 | 1410 | 88 | 1292.40852130396 | 117.591478696037 | 1322 | 1.03098593067393 | 1.37767227389497 | 0.0909863071603663 | weekly | |||||||||
9444 | 9444 | United States | Washington | WA | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 7614893 | 1055 | 35 | 1070.45614035176 | -15.4561403517589 | 1020 | 0.459625630983915 | -0.202972521764375 | -0.014438835716034 | weekly | |||||||||
9596 | 9596 | United States | West Virginia | WV | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 1792147 | 409 | 11 | 419.691729324297 | -10.6917293242969 | 398 | 0.613788935840643 | -0.596587742205125 | -0.0254751966199347 | weekly | |||||||||
9748 | 9748 | United States | Wisconsin | WI | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 5822434 | 1043 | 45 | 978.413533835469 | 64.5864661645312 | 998 | 0.772872650853578 | 1.10926918475214 | 0.0660114194366737 | weekly | |||||||||
9900 | 9900 | United States | Wyoming | WY | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 578759 | 105 | 2 | 85.9448621562819 | 19.0551378437181 | 103 | 0.34556698038389 | 3.29241322272623 | 0.221713519175448 | 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);