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 2021-05-30 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths, covid_deaths_per_100k
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2352 | 2352 | United States | Alabama | AL | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 4903185 | 1086 | 52 | 988.037593972271 | 97.962406027729 | 1034 | 1.06053514195365 | 1.99793411889882 | 0.0991484601652499 | weekly | |||||||||
2504 | 2504 | United States | Alaska | AK | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 731545 | 83 | 0 | 79.9461152920266 | 3.05388470797335 | 83 | 0.0 | 0.417456849267421 | 0.0381992883183648 | weekly | |||||||||
2656 | 2656 | United States | Arizona | AZ | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 7278717 | 1335 | 72 | 1187.21553885741 | 147.784461142592 | 1263 | 0.989185319335812 | 2.03036415816953 | 0.124479891229205 | weekly | |||||||||
2808 | 2808 | United States | Arkansas | AR | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 3017825 | 672 | 16 | 591.098997495278 | 80.901002504722 | 656 | 0.530183161714148 | 2.68077183086236 | 0.136865402999382 | weekly | |||||||||
2960 | 2960 | United States | California | CA | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 39512223 | 5207 | 104 | 4946.23809523851 | 260.761904761485 | 5103 | 0.26320969083415 | 0.659952503207641 | 0.0527192382858617 | weekly | |||||||||
3112 | 3112 | United States | Colorado | CO | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 5758736 | 827 | 37 | 754.799498747876 | 72.200501252124 | 790 | 0.642502104628516 | 1.25375605431685 | 0.0956552056167184 | weekly | |||||||||
3264 | 3264 | United States | Connecticut | CT | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 3565287 | 558 | 8 | 560.728070176001 | -2.7280701760011 | 550 | 0.224385862905286 | -0.0765175475635229 | -0.00486522847901094 | weekly | |||||||||
3416 | 3416 | United States | Delaware | DE | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 973764 | 173 | 16 | 166.149122810801 | 6.85087718919902 | 157 | 1.64310859715496 | 0.703545950476607 | 0.0412333033921601 | weekly | |||||||||
3568 | 3568 | United States | District of Columbia | DC | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 705749 | 125 | 4 | 111.281954887624 | 13.7180451123765 | 121 | 0.56677373967232 | 1.9437569323338 | 0.123272862399204 | weekly | |||||||||
3720 | 3720 | United States | Florida | FL | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 21477737 | 4380 | 199 | 4002.36090225659 | 377.63909774341 | 4181 | 0.926540817591723 | 1.75828159988834 | 0.0943540842432504 | weekly | |||||||||
3872 | 3872 | United States | Georgia | GA | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 10617423 | 1767 | 149 | 1645.71177944913 | 121.288220550871 | 1618 | 1.40335371398502 | 1.14235083740066 | 0.0736995518081967 | weekly | |||||||||
4024 | 4024 | United States | Hawaii | HI | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 1415872 | 210 | 3 | 216.79699248204 | -6.79699248204039 | 207 | 0.211883560095828 | -0.480056988346432 | -0.0313518762609378 | weekly | |||||||||
4176 | 4176 | United States | Idaho | ID | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 1787065 | 292 | 11 | 280.796992481913 | 11.2030075180869 | 281 | 0.615534409772448 | 0.626894238211084 | 0.0398971777406361 | weekly | |||||||||
4328 | 4328 | United States | Illinois | IL | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 12671821 | 2186 | 148 | 1920.0526315794 | 265.947368420603 | 2038 | 1.16794579090093 | 2.09873046991907 | 0.138510457498157 | weekly | |||||||||
4480 | 4480 | United States | Indiana | IN | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 6732219 | 1405 | 70 | 1186.52506265823 | 218.474937341768 | 1335 | 1.03977603818295 | 3.24521435416417 | 0.184130065362722 | weekly | |||||||||
4632 | 4632 | United States | Iowa | IA | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 3155070 | 555 | 14 | 541.431077694785 | 13.5689223052148 | 541 | 0.443730250041996 | 0.430067234806668 | 0.025061218064885 | weekly | |||||||||
4784 | 4784 | United States | Kansas | KS | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 2913314 | 519 | 8 | 484.59022556461 | 34.4097744353902 | 511 | 0.274601364631482 | 1.18112137707745 | 0.071007982869028 | weekly | |||||||||
4936 | 4936 | United States | Kentucky | KY | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 4467673 | 981 | 309 | 868.576441104188 | 112.423558895812 | 672 | 6.91635220393256 | 2.51637841211324 | 0.129434271499342 | weekly | |||||||||
5088 | 5088 | United States | Louisiana | LA | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 4648794 | 1006 | 39 | 859.258145364248 | 146.741854635752 | 967 | 0.838927257262851 | 3.15655747782656 | 0.170777379798416 | weekly | |||||||||
5240 | 5240 | United States | Maine | ME | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 1344212 | 294 | 14 | 273.201754386637 | 20.798245613363 | 280 | 1.04150238206473 | 1.54724445350607 | 0.0761277893696435 | weekly | |||||||||
5392 | 5392 | United States | Maryland | MD | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 6045680 | 1024 | 41 | 885.161654136186 | 138.838345863814 | 983 | 0.678170197562557 | 2.29648849862735 | 0.156850836471564 | weekly | |||||||||
5544 | 5544 | United States | Massachusetts | MA | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 6949503 | 1078 | 39 | 1090.02130325888 | -12.0213032588761 | 1039 | 0.561191210364252 | -0.172980762205241 | -0.0110285030420374 | weekly | |||||||||
5696 | 5696 | United States | Michigan | MI | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 9986857 | 1963 | 212 | 1826.46365914865 | 136.536340851345 | 1751 | 2.12278998287449 | 1.3671602672527 | 0.0747544798756015 | weekly | |||||||||
5848 | 5848 | United States | Minnesota | MN | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 5639632 | 850 | 43 | 847.243107770182 | 2.75689222981794 | 807 | 0.762461096752412 | 0.048884257515702 | 0.00325395651441029 | weekly | |||||||||
6000 | 6000 | United States | Mississippi | MS | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 2976149 | 628 | 15 | 605.602756892904 | 22.3972431070958 | 613 | 0.504007023841884 | 0.752557856044702 | 0.0369833902705576 | weekly | |||||||||
6152 | 6152 | United States | Missouri | MO | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 6137428 | 1325 | 60 | 1174.59022556467 | 150.409774435328 | 1265 | 0.977608209823398 | 2.45069717209436 | 0.128052976401212 | weekly | |||||||||
6304 | 6304 | United States | Montana | MT | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 1068778 | 202 | 19 | 177.802005013335 | 24.1979949866651 | 183 | 1.77773120329947 | 2.26408056553046 | 0.136095174994513 | weekly | |||||||||
6456 | 6456 | United States | Nebraska | NE | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 1934408 | 311 | 0 | 311.057644111328 | -0.0576441113275905 | 311 | 0.0 | -0.00297993553208995 | -0.00018531649171416 | weekly | |||||||||
6608 | 6608 | United States | Nevada | NV | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 3080156 | 571 | 14 | 502.448621554709 | 68.551378445291 | 557 | 0.454522433279353 | 2.22558138111482 | 0.136434603468858 | weekly | |||||||||
6760 | 6760 | United States | New Hampshire | NH | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 1359711 | 246 | 3 | 226.399749374229 | 19.6002506257715 | 243 | 0.220635120257172 | 1.4415012179626 | 0.0865736410042273 | weekly | |||||||||
6912 | 6912 | United States | New Jersey | NJ | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 8882190 | 1432 | 0 | 1339.84335839696 | 92.1566416030444 | 1432 | 0.0 | 1.03754413723467 | 0.0687816534861989 | weekly | |||||||||
7064 | 7064 | United States | New Mexico | NM | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 2096829 | 412 | 17 | 354.962406015864 | 57.0375939841355 | 395 | 0.810748039062794 | 2.72018338091163 | 0.160686295273721 | weekly | |||||||||
7216 | 7216 | United States | New York | NY | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 19453561 | 3013 | 137 | 2705.84962406095 | 307.150375939054 | 2876 | 0.704241244058093 | 1.57889023988489 | 0.113513468452871 | weekly | |||||||||
7368 | 7368 | United States | North Carolina | NC | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 10488084 | 2026 | 96 | 1788.38972431139 | 237.610275688612 | 1930 | 0.91532447680625 | 2.26552605498404 | 0.132862693437865 | weekly | |||||||||
7520 | 7520 | United States | North Dakota | ND | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 762062 | 148 | 4 | 150.010025063529 | -2.01002506352944 | 144 | 0.524891675480473 | -0.263761355838428 | -0.0133992715665382 | weekly | |||||||||
7672 | 7672 | United States | Ohio | OH | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 11689100 | 2416 | 119 | 2192.72556391195 | 223.274436088045 | 2297 | 1.01804244980366 | 1.91010801591265 | 0.101825070935786 | weekly | |||||||||
7824 | 7824 | United States | Oklahoma | OK | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 3956971 | 757 | 20 | 697.06516290798 | 59.9348370920197 | 737 | 0.505437113387993 | 1.5146645525585 | 0.0859816847566828 | weekly | |||||||||
7976 | 7976 | United States | Oregon | OR | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 4217737 | 798 | 21 | 693.74937343449 | 104.25062656551 | 777 | 0.497897332147547 | 2.47171946865132 | 0.150271309146421 | weekly | |||||||||
8128 | 8128 | United States | Pennsylvania | PA | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 12801989 | 2653 | 162 | 2389.42857142965 | 263.571428570345 | 2491 | 1.26542836429558 | 2.05883186253593 | 0.11030730599017 | weekly | |||||||||
8280 | 8280 | United States | Rhode Island | RI | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 1059361 | 188 | 9 | 167.867167920662 | 20.1328320793381 | 179 | 0.84956874946312 | 1.90046944142159 | 0.119933113358137 | weekly | |||||||||
8432 | 8432 | United States | South Carolina | SC | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 5148714 | 1034 | 24 | 961.206766918238 | 72.7932330817617 | 1010 | 0.46613581566193 | 1.41381387821817 | 0.0757310867828644 | weekly | |||||||||
8584 | 8584 | United States | South Dakota | SD | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 884659 | 152 | 12 | 153.746867168606 | -1.746867168606 | 140 | 1.35645486000821 | -0.197462205053699 | -0.0113619691950556 | weekly | |||||||||
8736 | 8736 | United States | Tennessee | TN | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 6833174 | 1548 | 35 | 1435.37468671769 | 112.625313282314 | 1513 | 0.512207065120835 | 1.64821374784711 | 0.0784640514595238 | weekly | |||||||||
8888 | 8888 | United States | Texas | TX | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 28995881 | 4243 | 162 | 3853.34335839652 | 389.656641603484 | 4081 | 0.558700044326986 | 1.34383446256896 | 0.101121702729764 | weekly | |||||||||
9040 | 9040 | United States | Utah | UT | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 3205958 | 393 | 10 | 372.328320802827 | 20.6716791971729 | 383 | 0.311919245355055 | 0.644789457540396 | 0.0555200290770252 | weekly | |||||||||
9192 | 9192 | United States | Vermont | VT | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 623989 | 85 | 1 | 95.5388471186404 | -10.5388471186404 | 84 | 0.160259235339084 | -1.68894758058883 | -0.110309548801162 | weekly | |||||||||
9344 | 9344 | United States | Virginia | VA | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 8535519 | 1426 | 69 | 1322.94611528887 | 103.05388471113 | 1357 | 0.808386695642058 | 1.20735346861896 | 0.0778972654442756 | weekly | |||||||||
9496 | 9496 | United States | Washington | WA | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 7614893 | 1242 | 71 | 1065.68421052713 | 176.315789472868 | 1171 | 0.932383422853086 | 2.31540731396841 | 0.165448439351143 | weekly | |||||||||
9648 | 9648 | United States | West Virginia | WV | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 1792147 | 487 | 21 | 439.87092731926 | 47.12907268074 | 466 | 1.17177887751395 | 2.62975485162433 | 0.107142958885604 | weekly | |||||||||
9800 | 9800 | United States | Wisconsin | WI | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 5822434 | 1042 | 25 | 991.453634086049 | 50.5463659139506 | 1017 | 0.429373694918654 | 0.868131195887331 | 0.0509820774024856 | weekly | |||||||||
9952 | 9952 | United States | Wyoming | WY | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 578759 | 105 | 1 | 85.7506265672544 | 19.2493734327456 | 104 | 0.172783490191945 | 3.3259739257179 | 0.224480848750981 | 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);