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 "start_date" is on date 2020-03-08 sorted by start_date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2288 | 2288 | United States | Alabama | AL | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 4903185 | 1091 | 0 | 1089.69172931409 | 1.3082706859127 | 1091 | 0.0 | 0.0266820584153505 | 0.00120058788253474 | weekly | |||||||||
2440 | 2440 | United States | Alaska | AK | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 731545 | 92 | 0 | 89.4085213060503 | 2.59147869394967 | 92 | 0.0 | 0.354247338707758 | 0.028984694703527 | weekly | |||||||||
2592 | 2592 | United States | Arizona | AZ | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 7278717 | 1349 | 0 | 1275.69924812831 | 73.3007518716877 | 1349 | 0.0 | 1.00705593955209 | 0.0574592733978903 | weekly | |||||||||
2744 | 2744 | United States | Arkansas | AR | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 3017825 | 628 | 0 | 649.954887219354 | -21.954887219354 | 628 | 0.0 | -0.727506970064665 | -0.0337790939818634 | weekly | |||||||||
2896 | 2896 | United States | California | CA | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 39512223 | 5465 | 5 | 5549.7142857149 | -84.7142857148965 | 5460 | 0.0126543120593341 | -0.214400201463979 | -0.015264621087423 | weekly | |||||||||
3048 | 3048 | United States | Colorado | CO | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 5758736 | 822 | 1 | 830.644110276747 | -8.64411027674669 | 821 | 0.0173649217467166 | -0.150104298525695 | -0.0104065148597354 | weekly | |||||||||
3200 | 3200 | United States | Connecticut | CT | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 3565287 | 632 | 0 | 628.92982456214 | 3.07017543786037 | 632 | 0.0 | 0.0861129956118644 | 0.00488158665396066 | weekly | |||||||||
3352 | 3352 | United States | Delaware | DE | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 973764 | 189 | 0 | 186.543859652049 | 2.45614034795057 | 189 | 0.0 | 0.252231582596046 | 0.0131665569294634 | weekly | |||||||||
3504 | 3504 | United States | District of Columbia | DC | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 705749 | 114 | 0 | 116.187969925197 | -2.18796992519712 | 114 | 0.0 | -0.310020974198635 | -0.0188312948974473 | weekly | |||||||||
3656 | 3656 | United States | Florida | FL | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 21477737 | 4435 | 1 | 4258.57393483811 | 176.426065161894 | 4434 | 0.00465598400799861 | 0.8214369379879 | 0.0414284377496903 | weekly | |||||||||
3808 | 3808 | United States | Georgia | GA | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 10617423 | 1784 | 1 | 1742.36340852177 | 41.6365914782273 | 1783 | 0.0094184813019129 | 0.39215345831307 | 0.0238966172467727 | weekly | |||||||||
3960 | 3960 | United States | Hawaii | HI | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 1415872 | 243 | 0 | 254.19799498834 | -11.1979949883398 | 243 | 0.0 | -0.790890348021557 | -0.0440522553643802 | weekly | |||||||||
4112 | 4112 | United States | Idaho | ID | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 1787065 | 282 | 0 | 278.197994988243 | 3.80200501175659 | 282 | 0.0 | 0.212751355533044 | 0.0136665435418299 | weekly | |||||||||
4264 | 4264 | United States | Illinois | IL | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 12671821 | 2191 | 0 | 2096.36842105314 | 94.631578946864 | 2191 | 0.0 | 0.746787529170938 | 0.0451407195398053 | weekly | |||||||||
4416 | 4416 | United States | Indiana | IN | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 6732219 | 1407 | 0 | 1360.12781955022 | 46.8721804497845 | 1407 | 0.0 | 0.696236715558192 | 0.0344615996938322 | weekly | |||||||||
4568 | 4568 | United States | Iowa | IA | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 3155070 | 636 | 0 | 615.065162907911 | 20.9348370920885 | 636 | 0.0 | 0.66353003553292 | 0.0340367791163989 | weekly | |||||||||
4720 | 4720 | United States | Kansas | KS | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 2913314 | 522 | 1 | 560.726817043353 | -38.7268170433533 | 521 | 0.0343251705789352 | -1.32930460099232 | -0.0690653913211344 | weekly | |||||||||
4872 | 4872 | United States | Kentucky | KY | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 4467673 | 1021 | 0 | 966.939849625303 | 54.0601503746973 | 1021 | 0.0 | 1.21002925627496 | 0.0559084935796639 | weekly | |||||||||
5024 | 5024 | United States | Louisiana | LA | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 4648794 | 994 | 1 | 914.616541354274 | 79.3834586457256 | 993 | 0.0215109553144321 | 1.70761403163327 | 0.0867942520787808 | weekly | |||||||||
5176 | 5176 | United States | Maine | ME | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 1344212 | 301 | 0 | 316.912280702478 | -15.9122807024784 | 301 | 0.0 | -1.18376273255099 | -0.0502103631554027 | weekly | |||||||||
5328 | 5328 | United States | Maryland | MD | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 6045680 | 1005 | 0 | 1006.44110275775 | -1.44110275775461 | 1005 | 0.0 | -0.0238369010227899 | -0.00143187987235993 | weekly | |||||||||
5480 | 5480 | United States | Massachusetts | MA | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 6949503 | 1311 | 0 | 1148.12531328397 | 162.874686716027 | 1311 | 0.0 | 2.34368827117604 | 0.141861419508432 | weekly | |||||||||
5632 | 5632 | United States | Michigan | MI | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 9986857 | 1955 | 0 | 1987.864661655 | -32.8646616550045 | 1955 | 0.0 | -0.329079125244354 | -0.0165326454506429 | weekly | |||||||||
5784 | 5784 | United States | Minnesota | MN | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 5639632 | 882 | 0 | 868.939849624845 | 13.0601503751553 | 882 | 0.0 | 0.231578059971915 | 0.015029982087706 | weekly | |||||||||
5936 | 5936 | United States | Mississippi | MS | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 2976149 | 623 | 0 | 639.957393484422 | -16.9573934844223 | 623 | 0.0 | -0.569776361479961 | -0.0264976913417518 | weekly | |||||||||
6088 | 6088 | United States | Missouri | MO | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 6137428 | 1301 | 0 | 1308.39348371006 | -7.39348371005781 | 1301 | 0.0 | -0.120465506235801 | -0.00565081055669348 | weekly | |||||||||
6240 | 6240 | United States | Montana | MT | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 1068778 | 218 | 0 | 207.423558898065 | 10.5764411019346 | 218 | 0.0 | 0.989582598250952 | 0.0509895845877959 | weekly | |||||||||
6392 | 6392 | United States | Nebraska | NE | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 1934408 | 343 | 0 | 349.593984963458 | -6.59398496345773 | 343 | 0.0 | -0.340878706222148 | -0.0188618375803776 | weekly | |||||||||
6544 | 6544 | United States | Nevada | NV | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 3080156 | 515 | 0 | 549.521303258986 | -34.5213032589858 | 515 | 0.0 | -1.12076476837491 | -0.0628206823907537 | weekly | |||||||||
6696 | 6696 | United States | New Hampshire | NH | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 1359711 | 240 | 0 | 236.488721805328 | 3.51127819467183 | 240 | 0.0 | 0.258237095579269 | 0.0148475503096601 | weekly | |||||||||
6848 | 6848 | United States | New Jersey | NJ | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 8882190 | 1477 | 1 | 1457.45112782053 | 19.5488721794725 | 1476 | 0.0112584846755136 | 0.220090677856165 | 0.0134130550289573 | weekly | |||||||||
7000 | 7000 | United States | New Mexico | NM | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 2096829 | 342 | 0 | 398.974937344187 | -56.9749373441869 | 342 | 0.0 | -2.71719521926618 | -0.142803299183267 | weekly | |||||||||
7152 | 7152 | United States | New York | NY | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 19453561 | 3117 | 3 | 3087.23308270756 | 29.766917292442 | 3114 | 0.0154213411107612 | 0.153015261794188 | 0.0096419403702217 | weekly | |||||||||
7304 | 7304 | United States | North Carolina | NC | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 10488084 | 2025 | 0 | 1954.37092731886 | 70.629072681136 | 2025 | 0.0 | 0.673422072908035 | 0.0361390315900931 | weekly | |||||||||
7456 | 7456 | United States | North Dakota | ND | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 762062 | 148 | 0 | 135.784461153736 | 12.2155388462643 | 148 | 0.0 | 1.60295866297812 | 0.0899627154865226 | weekly | |||||||||
7608 | 7608 | United States | Ohio | OH | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 11689100 | 2555 | 0 | 2450.48370927514 | 104.516290724859 | 2555 | 0.0 | 0.894134627343928 | 0.0426512897552684 | weekly | |||||||||
7760 | 7760 | United States | Oklahoma | OK | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 3956971 | 792 | 0 | 818.265664161153 | -26.2656641611532 | 792 | 0.0 | -0.663782073741585 | -0.0320991889450469 | weekly | |||||||||
7912 | 7912 | United States | Oregon | OR | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 4217737 | 746 | 1 | 770.055137845494 | -24.0551378454941 | 745 | 0.0237093967689308 | -0.570332807510143 | -0.0312382018679818 | weekly | |||||||||
8064 | 8064 | United States | Pennsylvania | PA | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 12801989 | 2833 | 0 | 2736.95238095346 | 96.0476190465438 | 2833 | 0.0 | 0.750255441139215 | 0.0350929083439457 | weekly | |||||||||
8216 | 8216 | United States | Rhode Island | RI | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 1059361 | 196 | 0 | 203.355889725167 | -7.35588972516652 | 196 | 0.0 | -0.694370448333148 | -0.0361724941190931 | weekly | |||||||||
8368 | 8368 | United States | South Carolina | SC | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 5148714 | 1103 | 0 | 1009.80451127914 | 93.1954887208643 | 1103 | 0.0 | 1.81007313128801 | 0.0922906242544035 | weekly | |||||||||
8520 | 8520 | United States | South Dakota | SD | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 884659 | 166 | 1 | 171.609022557099 | -5.60902255709919 | 165 | 0.113037905000684 | -0.634032158956072 | -0.0326848930989798 | weekly | |||||||||
8672 | 8672 | United States | Tennessee | TN | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 6833174 | 1601 | 0 | 1517.02756892318 | 83.972431076819 | 1601 | 0.0 | 1.22889349922626 | 0.055353266345993 | weekly | |||||||||
8824 | 8824 | United States | Texas | TX | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 28995881 | 4169 | 0 | 4113.78446115337 | 55.2155388466308 | 4169 | 0.0 | 0.190425456797229 | 0.0134220787131736 | weekly | |||||||||
8976 | 8976 | United States | Utah | UT | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 3205958 | 406 | 0 | 384.441102757713 | 21.5588972422866 | 406 | 0.0 | 0.67246349585012 | 0.0560785438592233 | weekly | |||||||||
9128 | 9128 | United States | Vermont | VT | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 623989 | 143 | 0 | 109.914786968267 | 33.0852130317327 | 143 | 0.0 | 5.3022109414962 | 0.301007843842563 | weekly | |||||||||
9280 | 9280 | United States | Virginia | VA | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 8535519 | 1435 | 1 | 1392.07518797057 | 42.9248120294346 | 1434 | 0.0117157492122037 | 0.502896332717842 | 0.0308351247119147 | weekly | |||||||||
9432 | 9432 | United States | Washington | WA | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 7614893 | 1165 | 24 | 1170.78947368503 | -5.78947368503395 | 1141 | 0.315171861246113 | -0.0760282998728144 | -0.00494493144596841 | weekly | |||||||||
9584 | 9584 | United States | West Virginia | WV | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 1792147 | 475 | 0 | 462.025062657572 | 12.9749373424276 | 475 | 0.0 | 0.723988453091605 | 0.0280827565236301 | weekly | |||||||||
9736 | 9736 | United States | Wisconsin | WI | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 5822434 | 1105 | 0 | 1077.74686716874 | 27.2531328312575 | 1105 | 0.0 | 0.468071133674637 | 0.0252871371390315 | weekly | |||||||||
9888 | 9888 | United States | Wyoming | WY | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 578759 | 85 | 0 | 99.6115288228911 | -14.6115288228911 | 85 | 0.0 | -2.52463094705933 | -0.14668511763202 | 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);