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-03-07" sorted by region_code
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths, covid_deaths_per_100k, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2439 | 2439 | United States | Alaska | AK | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 731545 | 79 | 0 | 91.0751879727197 | -12.0751879727197 | 79 | 0.0 | -1.6506418569903 | -0.132584826246383 | weekly | |||||||||
2287 | 2287 | United States | Alabama | AL | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 4903185 | 1057 | 0 | 1052.69172931738 | 4.30827068262079 | 1057 | 0.0 | 0.0878667780763073 | 0.00409262328432503 | weekly | |||||||||
2743 | 2743 | United States | Arkansas | AR | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 3017825 | 697 | 0 | 664.621553886022 | 32.3784461139776 | 697 | 0.0 | 1.07290668325624 | 0.0487171171694054 | weekly | |||||||||
2591 | 2591 | United States | Arizona | AZ | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 7278717 | 1380 | 0 | 1282.03258146166 | 97.9674185383446 | 1380 | 0.0 | 1.34594350265774 | 0.0764157010944693 | weekly | |||||||||
2895 | 2895 | United States | California | CA | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 39512223 | 5736 | 3 | 5673.04761904822 | 62.9523809517814 | 5733 | 0.00759258723560049 | 0.159323814688385 | 0.0110967481993995 | weekly | |||||||||
3047 | 3047 | United States | Colorado | CO | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 5758736 | 821 | 0 | 839.977443610089 | -18.9774436100894 | 821 | 0.0 | -0.32954182324193 | -0.0225928014549145 | weekly | |||||||||
3199 | 3199 | United States | Connecticut | CT | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 3565287 | 625 | 0 | 634.263157895474 | -9.26315789547436 | 625 | 0.0 | -0.259815209700492 | -0.0146045971300148 | weekly | |||||||||
3503 | 3503 | United States | District of Columbia | DC | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 705749 | 118 | 0 | 121.187969925198 | -3.18796992519762 | 118 | 0.0 | -0.451714409116785 | -0.0263059933025148 | weekly | |||||||||
3351 | 3351 | United States | Delaware | DE | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 973764 | 200 | 0 | 186.210526318717 | 13.7894736812827 | 200 | 0.0 | 1.41610017224736 | 0.074053137348856 | weekly | |||||||||
3655 | 3655 | United States | Florida | FL | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 21477737 | 4520 | 2 | 4273.57393483812 | 246.426065161883 | 4518 | 0.00931196801599722 | 1.14735581854775 | 0.0576627593015349 | weekly | |||||||||
3807 | 3807 | United States | Georgia | GA | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 10617423 | 1755 | 0 | 1724.36340852178 | 30.6365914782202 | 1755 | 0.0 | 0.288550163991961 | 0.0177668995565636 | weekly | |||||||||
3959 | 3959 | United States | Hawaii | HI | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 1415872 | 239 | 0 | 258.531328321675 | -19.5313283216755 | 239 | 0.0 | -1.37945579273236 | -0.0755472400519823 | weekly | |||||||||
4567 | 4567 | United States | Iowa | IA | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 3155070 | 624 | 0 | 604.73182957458 | 19.2681704254198 | 624 | 0.0 | 0.610705005765953 | 0.0318623387807695 | weekly | |||||||||
4111 | 4111 | United States | Idaho | ID | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 1787065 | 278 | 0 | 295.864661654912 | -17.8646616549125 | 278 | 0.0 | -0.999664906140095 | -0.0603811944116167 | weekly | |||||||||
4263 | 4263 | United States | Illinois | IL | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 12671821 | 2254 | 0 | 2096.70175438647 | 157.298245613534 | 2254 | 0.0 | 1.24132313432721 | 0.0750217551373022 | weekly | |||||||||
4415 | 4415 | United States | Indiana | IN | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 6732219 | 1372 | 0 | 1349.12781955022 | 22.8721804497816 | 1372 | 0.0 | 0.339742073895421 | 0.0169533087364597 | weekly | |||||||||
4719 | 4719 | United States | Kansas | KS | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 2913314 | 575 | 0 | 571.393483710022 | 3.60651628997812 | 575 | 0.0 | 0.123794286849207 | 0.00631179107357194 | weekly | |||||||||
4871 | 4871 | United States | Kentucky | KY | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 4467673 | 1006 | 0 | 1012.60651629197 | -6.60651629197287 | 1006 | 0.0 | -0.147873765424928 | -0.00652426800112349 | weekly | |||||||||
5023 | 5023 | United States | Louisiana | LA | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 4648794 | 964 | 0 | 879.283208020941 | 84.7167919790587 | 964 | 0.0 | 1.82233912664357 | 0.0963475603835722 | weekly | |||||||||
5479 | 5479 | United States | Massachusetts | MA | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 6949503 | 1216 | 0 | 1217.12531328397 | -1.12531328396722 | 1216 | 0.0 | -0.0161927159966291 | -0.0009245664942511 | weekly | |||||||||
5327 | 5327 | United States | Maryland | MD | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 6045680 | 1049 | 0 | 1012.10776942442 | 36.8922305755773 | 1049 | 0.0 | 0.610224665803967 | 0.036450891584952 | weekly | |||||||||
5175 | 5175 | United States | Maine | ME | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 1344212 | 313 | 0 | 311.245614035815 | 1.75438596418491 | 313 | 0.0 | 0.130514082911394 | 0.00563666083976688 | weekly | |||||||||
5631 | 5631 | United States | Michigan | MI | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 9986857 | 1988 | 0 | 2001.19799498835 | -13.1979949883462 | 1988 | 0.0 | -0.132153639411741 | -0.00659504707749969 | weekly | |||||||||
5783 | 5783 | United States | Minnesota | MN | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 5639632 | 944 | 0 | 901.606516291522 | 42.3934837084784 | 944 | 0.0 | 0.751706560081905 | 0.0470199393443282 | weekly | |||||||||
6087 | 6087 | United States | Missouri | MO | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 6137428 | 1394 | 0 | 1304.06015037672 | 89.9398496232761 | 1394 | 0.0 | 1.46543225636661 | 0.0689690959403166 | weekly | |||||||||
5935 | 5935 | United States | Mississippi | MS | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 2976149 | 663 | 0 | 627.624060151089 | 35.3759398489108 | 663 | 0.0 | 1.18864814392394 | 0.0563648561216641 | weekly | |||||||||
6239 | 6239 | United States | Montana | MT | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 1068778 | 221 | 0 | 229.423558898066 | -8.42355889806649 | 221 | 0.0 | -0.788148605048615 | -0.0367161896473287 | weekly | |||||||||
7303 | 7303 | United States | North Carolina | NC | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 10488084 | 2032 | 0 | 1995.70426065221 | 36.2957393477859 | 2032 | 0.0 | 0.346066444050085 | 0.0181869328353912 | weekly | |||||||||
7455 | 7455 | United States | North Dakota | ND | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 762062 | 171 | 0 | 143.451127820404 | 27.5488721795962 | 171 | 0.0 | 3.6150434189864 | 0.192043608148459 | weekly | |||||||||
6391 | 6391 | United States | Nebraska | NE | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 1934408 | 355 | 0 | 344.260651630124 | 10.7393483698755 | 355 | 0.0 | 0.555174935684485 | 0.0311953989485094 | weekly | |||||||||
6695 | 6695 | United States | New Hampshire | NH | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 1359711 | 266 | 0 | 254.822055138661 | 11.177944861339 | 266 | 0.0 | 0.822082402903188 | 0.0438656883732318 | weekly | |||||||||
6847 | 6847 | United States | New Jersey | NJ | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 8882190 | 1509 | 0 | 1520.78446115386 | -11.7844611538567 | 1509 | 0.0 | -0.132675175309881 | -0.00774893579917002 | weekly | |||||||||
6999 | 6999 | United States | New Mexico | NM | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 2096829 | 400 | 0 | 388.641604010858 | 11.3583959891421 | 400 | 0.0 | 0.54169395735857 | 0.0292258879953182 | weekly | |||||||||
6543 | 6543 | United States | Nevada | NV | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 3080156 | 535 | 0 | 531.854636592323 | 3.14536340767722 | 535 | 0.0 | 0.102117016400378 | 0.00591395315800969 | weekly | |||||||||
7151 | 7151 | United States | New York | NY | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 19453561 | 3185 | 0 | 3180.23308270756 | 4.76691729244112 | 3185 | 0.0 | 0.0245040858711735 | 0.00149892072954061 | weekly | |||||||||
7607 | 7607 | United States | Ohio | OH | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 11689100 | 2509 | 0 | 2503.48370927513 | 5.51629072487322 | 2509 | 0.0 | 0.0471917489359593 | 0.00220344582408738 | weekly | |||||||||
7759 | 7759 | United States | Oklahoma | OK | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 3956971 | 799 | 0 | 836.265664161151 | -37.2656641611511 | 799 | 0.0 | -0.94177248610493 | -0.0445619923885454 | weekly | |||||||||
7911 | 7911 | United States | Oregon | OR | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 4217737 | 788 | 0 | 757.721804512162 | 30.2781954878382 | 788 | 0.0 | 0.717877750268406 | 0.0399595145705645 | weekly | |||||||||
8063 | 8063 | United States | Pennsylvania | PA | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 12801989 | 2786 | 0 | 2752.61904762011 | 33.3809523798877 | 2786 | 0.0 | 0.260748172646358 | 0.0121269786346747 | weekly | |||||||||
8215 | 8215 | United States | Rhode Island | RI | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 1059361 | 251 | 0 | 219.6892230585 | 31.3107769415004 | 251 | 0.0 | 2.95562862343436 | 0.142523044624556 | weekly | |||||||||
8367 | 8367 | United States | South Carolina | SC | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 5148714 | 1133 | 0 | 1016.47117794581 | 116.528822054186 | 1133 | 0.0 | 2.263260729848 | 0.114640557039383 | weekly | |||||||||
8519 | 8519 | United States | South Dakota | SD | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 884659 | 194 | 0 | 177.275689223766 | 16.7243107762342 | 194 | 0.0 | 1.89048105272588 | 0.0943406896313008 | weekly | |||||||||
8671 | 8671 | United States | Tennessee | TN | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 6833174 | 1611 | 0 | 1491.36090225653 | 119.63909774347 | 1611 | 0.0 | 1.75085688939678 | 0.080221425653876 | weekly | |||||||||
8823 | 8823 | United States | Texas | TX | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 28995881 | 4173 | 0 | 4268.45112782009 | -95.4511278200862 | 4173 | 0.0 | -0.329188576198413 | -0.0223620055523123 | weekly | |||||||||
8975 | 8975 | United States | Utah | UT | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 3205958 | 427 | 0 | 417.441102757718 | 9.55889724228194 | 427 | 0.0 | 0.29816040142391 | 0.0228987926180089 | weekly | |||||||||
9279 | 9279 | United States | Virginia | VA | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 8535519 | 1480 | 0 | 1401.74185463726 | 78.2581453627447 | 1480 | 0.0 | 0.916852804882101 | 0.0558292135630041 | weekly | |||||||||
9127 | 9127 | United States | Vermont | VT | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 623989 | 120 | 0 | 127.248120301596 | -7.24812030159589 | 120 | 0.0 | -1.16157821717945 | -0.0569605294319226 | weekly | |||||||||
9431 | 9431 | United States | Washington | WA | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 7614893 | 1208 | 15 | 1162.78947368504 | 45.2105263149647 | 1193 | 0.196982413278821 | 0.593711905275158 | 0.038881093558309 | weekly | |||||||||
9735 | 9735 | United States | Wisconsin | WI | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 5822434 | 1116 | 0 | 1081.74686716875 | 34.2531328312457 | 1116 | 0.0 | 0.588295768251657 | 0.0316646471284878 | weekly | |||||||||
9583 | 9583 | United States | West Virginia | WV | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 1792147 | 483 | 0 | 455.691729324236 | 27.3082706757638 | 483 | 0.0 | 1.52377403615684 | 0.0599270711282391 | weekly | |||||||||
9887 | 9887 | United States | Wyoming | WY | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 578759 | 80 | 0 | 102.278195489557 | -22.2781954895572 | 80 | 0.0 | -3.84930437186415 | -0.217819598624341 | 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);