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 = "2021-06-26" sorted by end_date descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2355 | 2355 | United States | Alabama | AL | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 4903185 | 1074 | 30 | 988.037593972341 | 85.962406027659 | 1044 | 0.611847197280951 | 1.75319523998501 | 0.0870031733125181 | weekly | |||||||||
2507 | 2507 | United States | Alaska | AK | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 731545 | 90 | 1 | 92.9461152920349 | -2.9461152920349 | 89 | 0.136696990615752 | -0.402725094428217 | -0.0316970244832532 | weekly | |||||||||
2659 | 2659 | United States | Arizona | AZ | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 7278717 | 1388 | 81 | 1147.21553885741 | 240.784461142594 | 1307 | 1.11283348425279 | 3.30806186231164 | 0.209885983049366 | weekly | |||||||||
2811 | 2811 | United States | Arkansas | AR | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 3017825 | 660 | 19 | 578.765664161953 | 81.2343358380466 | 641 | 0.629592504535551 | 2.69181731339778 | 0.140357904534079 | weekly | |||||||||
2963 | 2963 | United States | California | CA | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 39512223 | 5358 | 66 | 4974.23809523852 | 383.761904761475 | 5292 | 0.167036919183211 | 0.971248579867236 | 0.0771498865582696 | weekly | |||||||||
3115 | 3115 | United States | Colorado | CO | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 5758736 | 800 | 38 | 755.132832081218 | 44.8671679187823 | 762 | 0.659867026375232 | 0.779114859906451 | 0.0594162589846929 | weekly | |||||||||
3267 | 3267 | United States | Connecticut | CT | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 3565287 | 595 | 5 | 563.061403509344 | 31.9385964906564 | 590 | 0.140241164315804 | 0.895821191692462 | 0.0567231145512648 | weekly | |||||||||
3419 | 3419 | United States | Delaware | DE | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 973764 | 207 | 14 | 170.149122810811 | 36.8508771891889 | 193 | 1.43772002251059 | 3.78437457014111 | 0.216579883460013 | weekly | |||||||||
3571 | 3571 | United States | District of Columbia | DC | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 705749 | 115 | 0 | 106.281954887634 | 8.71804511236633 | 115 | 0.0 | 1.23528975774196 | 0.0820275193619036 | weekly | |||||||||
3723 | 3723 | United States | Florida | FL | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 21477737 | 4491 | 217 | 3955.69423558993 | 535.305764410071 | 4274 | 1.0103485297357 | 2.49237507848276 | 0.135325364532438 | weekly | |||||||||
3875 | 3875 | United States | Georgia | GA | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 10617423 | 1763 | 74 | 1626.3784461158 | 136.6215538842 | 1689 | 0.696967616341555 | 1.28676755069663 | 0.084003544322963 | weekly | |||||||||
4027 | 4027 | United States | Hawaii | HI | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 1415872 | 227 | 4 | 238.130325815384 | -11.1303258153843 | 223 | 0.282511413461104 | -0.786111019596707 | -0.0467404803536585 | weekly | |||||||||
4179 | 4179 | United States | Idaho | ID | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 1787065 | 294 | 23 | 278.796992481924 | 15.2030075180755 | 271 | 1.28702649316057 | 0.850724932673156 | 0.0545307443338408 | weekly | |||||||||
4331 | 4331 | United States | Illinois | IL | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 12671821 | 1997 | 73 | 1874.38596491275 | 122.61403508725 | 1924 | 0.576081369836269 | 0.967611798550896 | 0.0654155746908602 | weekly | |||||||||
4483 | 4483 | United States | Indiana | IN | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 6732219 | 1281 | 27 | 1187.19172932491 | 93.808270675092 | 1254 | 0.401056471870568 | 1.39342274330487 | 0.0790169509759269 | weekly | |||||||||
4635 | 4635 | United States | Iowa | IA | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 3155070 | 586 | 16 | 551.431077694795 | 34.5689223052049 | 570 | 0.507120285762281 | 1.09566260986935 | 0.0626894705494601 | weekly | |||||||||
4787 | 4787 | United States | Kansas | KS | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 2913314 | 513 | 18 | 483.59022556462 | 29.4097744353803 | 495 | 0.617853070420833 | 1.00949552418244 | 0.0608154856749694 | weekly | |||||||||
4939 | 4939 | United States | Kentucky | KY | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 4467673 | 1014 | 24 | 887.576441104197 | 126.423558895803 | 990 | 0.537192404188937 | 2.82974064788991 | 0.142436812246306 | weekly | |||||||||
5091 | 5091 | United States | Louisiana | LA | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 4648794 | 991 | 35 | 817.924812030924 | 173.075187969076 | 956 | 0.752883436005123 | 3.72301263443972 | 0.211602809235395 | weekly | |||||||||
5243 | 5243 | United States | Maine | ME | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 1344212 | 316 | 4 | 279.868421053314 | 36.131578946686 | 312 | 0.297572109161353 | 2.68793753862382 | 0.129102021623951 | weekly | |||||||||
5395 | 5395 | United States | Maryland | MD | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 6045680 | 918 | 30 | 912.161654136195 | 5.83834586380544 | 888 | 0.496222095777481 | 0.0965705406803775 | 0.00640056051175963 | weekly | |||||||||
5547 | 5547 | United States | Massachusetts | MA | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 6949503 | 1063 | 25 | 1050.02130325889 | 12.9786967411112 | 1038 | 0.3597379553617 | 0.186757193156276 | 0.0123604127847978 | weekly | |||||||||
5699 | 5699 | United States | Michigan | MI | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 9986857 | 1927 | 97 | 1795.46365914866 | 131.53634085134 | 1830 | 0.971276548768046 | 1.31709446576976 | 0.0732603749349676 | weekly | |||||||||
5851 | 5851 | United States | Minnesota | MN | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 5639632 | 890 | 42 | 800.909774436853 | 89.0902255631472 | 848 | 0.744729443339565 | 1.57971700215807 | 0.111236282046613 | weekly | |||||||||
6003 | 6003 | United States | Mississippi | MS | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 2976149 | 658 | 24 | 570.936090226247 | 87.0639097737533 | 634 | 0.806411238147015 | 2.92538813660718 | 0.152493267222347 | weekly | |||||||||
6155 | 6155 | United States | Missouri | MO | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 6137428 | 1385 | 27 | 1156.25689223135 | 228.743107768649 | 1358 | 0.439923694420529 | 3.72701900158583 | 0.197830697750238 | weekly | |||||||||
6307 | 6307 | United States | Montana | MT | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 1068778 | 214 | 11 | 181.135338346676 | 32.8646616533238 | 203 | 1.02921280191022 | 3.07497550036806 | 0.181437051175646 | weekly | |||||||||
6459 | 6459 | United States | Nebraska | NE | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 1934408 | 315 | 0 | 318.057644111335 | -3.05764411133498 | 315 | 0.0 | -0.158066142785544 | -0.00961349040950787 | weekly | |||||||||
6611 | 6611 | United States | Nevada | NV | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 3080156 | 548 | 18 | 515.781954888049 | 32.2180451119511 | 530 | 0.584385985644883 | 1.04598744712772 | 0.0624644674103501 | weekly | |||||||||
6763 | 6763 | United States | New Hampshire | NH | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 1359711 | 236 | 4 | 234.066416040903 | 1.93358395909652 | 232 | 0.294180160342896 | 0.142205509780867 | 0.00826083464600336 | weekly | |||||||||
6915 | 6915 | United States | New Jersey | NJ | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 8882190 | 1374 | 53 | 1327.51002506363 | 46.4899749363697 | 1321 | 0.59669968780222 | 0.523406670386128 | 0.0350204322819643 | weekly | |||||||||
7067 | 7067 | United States | New Mexico | NM | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 2096829 | 411 | 19 | 349.295739349205 | 61.7042606507946 | 392 | 0.906130161305476 | 2.94274166614419 | 0.176653344715168 | weekly | |||||||||
7219 | 7219 | United States | New York | NY | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 19453561 | 2834 | 39 | 2842.18295739429 | -8.18295739428549 | 2795 | 0.200477434439895 | -0.0420640590907006 | -0.00287911000697427 | weekly | |||||||||
7371 | 7371 | United States | North Carolina | NC | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 10488084 | 1899 | 75 | 1812.72305764473 | 86.2769423552718 | 1824 | 0.715097247504883 | 0.822618720018564 | 0.0475952142779998 | weekly | |||||||||
7523 | 7523 | United States | North Dakota | ND | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 762062 | 149 | 5 | 137.010025063537 | 11.9899749364628 | 144 | 0.656114594350591 | 1.5733595083422 | 0.0875116615072695 | weekly | |||||||||
7675 | 7675 | United States | Ohio | OH | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 11689100 | 2361 | 115 | 2205.72556391197 | 155.274436088032 | 2246 | 0.983822535524548 | 1.32836947316759 | 0.0703960812843123 | weekly | |||||||||
7827 | 7827 | United States | Oklahoma | OK | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 3956971 | 784 | 29 | 708.731829574655 | 75.2681704253448 | 755 | 0.73288381441259 | 1.90216633948909 | 0.106201199500969 | weekly | |||||||||
7979 | 7979 | United States | Oregon | OR | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 4217737 | 767 | 11 | 699.08270676783 | 67.9172932321696 | 756 | 0.260803364458239 | 1.61027805271333 | 0.0971520144535993 | weekly | |||||||||
8131 | 8131 | United States | Pennsylvania | PA | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 12801989 | 2514 | 83 | 2387.76190476301 | 126.238095236989 | 2431 | 0.648336754546501 | 0.986081891157612 | 0.0528687952451099 | weekly | |||||||||
8283 | 8283 | United States | Rhode Island | RI | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 1059361 | 194 | 4 | 195.867167920669 | -1.86716792066932 | 190 | 0.377586110872498 | -0.176254168377854 | -0.00953282747941486 | weekly | |||||||||
8435 | 8435 | United States | South Carolina | SC | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 5148714 | 1034 | 27 | 970.540100251576 | 63.4598997484236 | 1007 | 0.524402792619672 | 1.23253883879399 | 0.0653861697543192 | weekly | |||||||||
8587 | 8587 | United States | South Dakota | SD | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 884659 | 150 | 3 | 150.413533835281 | -0.413533835281271 | 147 | 0.339113715002052 | -0.0467449983870928 | -0.00274931267643863 | weekly | |||||||||
8739 | 8739 | United States | Tennessee | TN | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 6833174 | 1547 | 34 | 1424.37468671769 | 122.625313282307 | 1513 | 0.497572577545954 | 1.79455862359581 | 0.0860906294009498 | weekly | |||||||||
8891 | 8891 | United States | Texas | TX | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 28995881 | 4343 | 131 | 3829.67669172986 | 513.32330827014 | 4212 | 0.4517883074496 | 1.77033182150989 | 0.134038288239489 | weekly | |||||||||
9043 | 9043 | United States | Utah | UT | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 3205958 | 420 | 25 | 368.661654136167 | 51.3383458638327 | 395 | 0.779798113387636 | 1.60134180996235 | 0.139255996081628 | weekly | |||||||||
9195 | 9195 | United States | Vermont | VT | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 623989 | 129 | 0 | 101.872180451981 | 27.1278195480186 | 129 | 0.0 | 4.34748361718213 | 0.266292715318934 | weekly | |||||||||
9347 | 9347 | United States | Virginia | VA | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 8535519 | 1368 | 49 | 1283.61278195554 | 84.3872180444557 | 1319 | 0.574071711397983 | 0.988659483324397 | 0.0657419583465775 | weekly | |||||||||
9499 | 9499 | United States | Washington | WA | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 7614893 | 1273 | 82 | 1046.01754386047 | 226.982456139528 | 1191 | 1.07683719259089 | 2.98077013215456 | 0.216996796537291 | weekly | |||||||||
9651 | 9651 | United States | West Virginia | WV | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 1792147 | 442 | 13 | 412.537593985935 | 29.462406014065 | 429 | 0.725386924175305 | 1.64397262133436 | 0.0714175058069242 | weekly | |||||||||
9803 | 9803 | United States | Wisconsin | WI | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 5822434 | 947 | 8 | 990.453634086054 | -43.4536340860542 | 939 | 0.137399582373969 | -0.746313897006891 | -0.0438724566104008 | weekly | |||||||||
9955 | 9955 | United States | Wyoming | WY | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 578759 | 98 | 6 | 92.0839599005948 | 5.91604009940519 | 92 | 1.03670094115167 | 1.02219405649073 | 0.0642461521614794 | 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);