economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
51 rows where cadence = "weekly", country = "United States" and "start_date" is on date 2020-08-30 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2313 | 2313 | United States | Alabama | AL | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 4903185 | 1216 | 119 | 979.691729315222 | 236.308270684778 | 1097 | 2.42699388254777 | 4.81948510375965 | 0.241206762917097 | weekly | |||||||||
2465 | 2465 | United States | Alaska | AK | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 731545 | 105 | 3 | 86.7418546393798 | 18.2581453606202 | 102 | 0.410090971847255 | 2.49583352502173 | 0.210488298140806 | weekly | |||||||||
2617 | 2617 | United States | Arizona | AZ | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 7278717 | 1296 | 201 | 1145.6992481283 | 150.3007518717 | 1095 | 2.76147568314581 | 2.06493468384195 | 0.131186916738614 | weekly | |||||||||
2769 | 2769 | United States | Arkansas | AR | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 3017825 | 713 | 112 | 569.621553886014 | 143.378446113986 | 601 | 3.71128213199904 | 4.75105236764843 | 0.25170825284936 | weekly | |||||||||
2921 | 2921 | United States | California | CA | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 39512223 | 5784 | 669 | 4822.04761904822 | 961.95238095178 | 5115 | 1.69314695353891 | 2.43456912295666 | 0.199490435795749 | weekly | |||||||||
3073 | 3073 | United States | Colorado | CO | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 5758736 | 743 | 22 | 758.310776943403 | -15.3107769434031 | 721 | 0.382028278427766 | -0.265870443503628 | -0.0201906360939742 | weekly | |||||||||
3225 | 3225 | United States | Connecticut | CT | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 3565287 | 574 | 5 | 567.929824562137 | 6.07017543786344 | 569 | 0.140241164315804 | 0.170257694201433 | 0.0106882491028595 | weekly | |||||||||
3377 | 3377 | United States | Delaware | DE | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 973764 | 208 | 4 | 168.543859652046 | 39.456140347954 | 204 | 0.410777149288739 | 4.05192021351724 | 0.234100135296593 | weekly | |||||||||
3529 | 3529 | United States | District of Columbia | DC | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 705749 | 143 | 6 | 111.187969925193 | 31.8120300748065 | 137 | 0.85016060950848 | 4.5075558130166 | 0.286110359746737 | weekly | |||||||||
3681 | 3681 | United States | Florida | FL | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 21477737 | 4758 | 705 | 3799.57393483808 | 958.426065161922 | 4053 | 3.28246872563902 | 4.46241643224294 | 0.252245667961391 | weekly | |||||||||
3833 | 3833 | United States | Georgia | GA | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 10617423 | 2044 | 400 | 1560.36340852176 | 483.636591478239 | 1644 | 3.76739252076516 | 4.55512219375868 | 0.309951251635938 | weekly | |||||||||
3985 | 3985 | United States | Hawaii | HI | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 1415872 | 235 | 22 | 215.531328321667 | 19.4686716783326 | 213 | 1.55381277403607 | 1.37503048851398 | 0.090328732393264 | weekly | |||||||||
4137 | 4137 | United States | Idaho | ID | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 1787065 | 352 | 26 | 270.864661654905 | 81.1353383450952 | 326 | 1.4548995140076 | 4.54014478181237 | 0.299541984729133 | weekly | |||||||||
4289 | 4289 | United States | Illinois | IL | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 12671821 | 2198 | 158 | 1892.0350877198 | 305.964912280197 | 2040 | 1.24686104704288 | 2.41452994230425 | 0.161712070915626 | weekly | |||||||||
4441 | 4441 | United States | Indiana | IN | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 6732219 | 1271 | 77 | 1205.12781955021 | 65.8721804497907 | 1194 | 1.14375364200125 | 0.978461640207941 | 0.0546599119040967 | weekly | |||||||||
4593 | 4593 | United States | Iowa | IA | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 3155070 | 597 | 55 | 547.39849624124 | 49.6015037587598 | 542 | 1.74322598230784 | 1.57212054752382 | 0.0906131531221823 | weekly | |||||||||
4745 | 4745 | United States | Kansas | KS | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 2913314 | 566 | 33 | 488.393483710014 | 77.6065162899861 | 533 | 1.13273062910486 | 2.66385690969069 | 0.158901621087282 | weekly | |||||||||
4897 | 4897 | United States | Kentucky | KY | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 4467673 | 1055 | 73 | 862.27318295863 | 192.72681704137 | 982 | 1.63396022940802 | 4.31380759158895 | 0.223510159947322 | weekly | |||||||||
5049 | 5049 | United States | Louisiana | LA | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 4648794 | 1110 | 131 | 815.616541354269 | 294.383458645731 | 979 | 2.8179351461906 | 6.33246942423628 | 0.360933654137187 | weekly | |||||||||
5201 | 5201 | United States | Maine | ME | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 1344212 | 289 | 2 | 277.245614035806 | 11.7543859641944 | 287 | 0.148786054580676 | 0.874444355815481 | 0.0423970132226379 | weekly | |||||||||
5353 | 5353 | United States | Maryland | MD | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 6045680 | 1046 | 53 | 921.441102757748 | 124.558897242252 | 993 | 0.876659035873549 | 2.06029590124273 | 0.135178360146366 | weekly | |||||||||
5505 | 5505 | United States | Massachusetts | MA | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 6949503 | 1014 | 81 | 1041.45864661731 | -27.4586466173068 | 933 | 1.16555097537191 | -0.395116695644377 | -0.0263655659362889 | weekly | |||||||||
5657 | 5657 | United States | Michigan | MI | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 9986857 | 1959 | 91 | 1766.53132832166 | 192.468671678341 | 1868 | 0.911197586988579 | 1.92721966158463 | 0.108952877649332 | weekly | |||||||||
5809 | 5809 | United States | Minnesota | MN | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 5639632 | 895 | 37 | 840.606516291502 | 54.3934837084977 | 858 | 0.656071176275331 | 0.964486401036409 | 0.0647074257150242 | weekly | |||||||||
5961 | 5961 | United States | Mississippi | MS | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 2976149 | 736 | 143 | 593.624060151085 | 142.375939848915 | 593 | 4.80486696062596 | 4.78389824732953 | 0.239841929272003 | weekly | |||||||||
6113 | 6113 | United States | Missouri | MO | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 6137428 | 1410 | 143 | 1164.06015037672 | 245.93984962328 | 1267 | 2.32996623341243 | 4.0072136019075 | 0.211277612710724 | weekly | |||||||||
6265 | 6265 | United States | Montana | MT | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 1068778 | 233 | 12 | 193.423558898061 | 39.5764411019389 | 221 | 1.12277760208388 | 3.70296180328739 | 0.204610241520769 | weekly | |||||||||
6417 | 6417 | United States | Nebraska | NE | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 1934408 | 350 | 12 | 306.593984963456 | 43.4060150365445 | 338 | 0.620344829012287 | 2.2438914146625 | 0.141574907419395 | weekly | |||||||||
6569 | 6569 | United States | Nevada | NV | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 3080156 | 640 | 85 | 470.521303258977 | 169.478696741023 | 555 | 2.7596004877675 | 5.50227640226738 | 0.360193461097639 | weekly | |||||||||
6721 | 6721 | United States | New Hampshire | NH | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 1359711 | 234 | 0 | 229.155388471989 | 4.8446115280108 | 234 | 0.0 | 0.356297149027315 | 0.0211411634712793 | weekly | |||||||||
6873 | 6873 | United States | New Jersey | NJ | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 8882190 | 1397 | 53 | 1332.78446115386 | 64.2155388461447 | 1344 | 0.59669968780222 | 0.722969660029167 | 0.0481814882434555 | weekly | |||||||||
7025 | 7025 | United States | New Mexico | NM | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 2096829 | 376 | 31 | 365.974937344178 | 10.0250626558222 | 345 | 1.47842289476157 | 0.47810587586409 | 0.0273927573526551 | weekly | |||||||||
7177 | 7177 | United States | New York | NY | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 19453561 | 2768 | 55 | 2760.56641604089 | 7.43358395911264 | 2713 | 0.282724587030621 | 0.0382119446363195 | 0.00269277490152686 | weekly | |||||||||
7329 | 7329 | United States | North Carolina | NC | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 10488084 | 2167 | 205 | 1748.70426065217 | 418.295739347827 | 1962 | 1.95459914318001 | 3.98829509134201 | 0.239203248233538 | weekly | |||||||||
7481 | 7481 | United States | North Dakota | ND | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 762062 | 163 | 14 | 128.451127820395 | 34.5488721796052 | 149 | 1.83712086418165 | 4.53360385107842 | 0.268965113548188 | weekly | |||||||||
7633 | 7633 | United States | Ohio | OH | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 11689100 | 2426 | 130 | 2229.81704260849 | 196.182957391515 | 2296 | 1.11214721407123 | 1.67834099624021 | 0.0879816386917627 | weekly | |||||||||
7785 | 7785 | United States | Oklahoma | OK | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 3956971 | 828 | 76 | 707.265664161149 | 120.734335838851 | 752 | 1.92066103087437 | 3.05118070966026 | 0.170705778545106 | weekly | |||||||||
7937 | 7937 | United States | Oregon | OR | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 4217737 | 707 | 28 | 654.721804512154 | 52.2781954878463 | 679 | 0.663863109530063 | 1.23948447918508 | 0.0798479524090387 | weekly | |||||||||
8089 | 8089 | United States | Pennsylvania | PA | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 12801989 | 2604 | 89 | 2347.2857142868 | 256.714285713196 | 2515 | 0.695204471742633 | 2.00526875716887 | 0.109366441482048 | weekly | |||||||||
8241 | 8241 | United States | Rhode Island | RI | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 1059361 | 207 | 11 | 198.355889725162 | 8.64411027483814 | 196 | 1.03836180489937 | 0.815973995157283 | 0.0435787930815428 | weekly | |||||||||
8393 | 8393 | United States | South Carolina | SC | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 5148714 | 1243 | 178 | 924.804511279123 | 318.195488720877 | 1065 | 3.45717396615932 | 6.18009640311886 | 0.344067837948554 | weekly | |||||||||
8545 | 8545 | United States | South Dakota | SD | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 884659 | 209 | 6 | 149.609022557093 | 59.3909774429072 | 203 | 0.678227430004103 | 6.71343166608911 | 0.396974570302021 | weekly | |||||||||
8697 | 8697 | United States | Tennessee | TN | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 6833174 | 1624 | 136 | 1407.69423558983 | 216.305764410166 | 1488 | 1.99029031018382 | 3.16552402163571 | 0.153659622197382 | weekly | |||||||||
8849 | 8849 | United States | Texas | TX | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 28995881 | 4942 | 629 | 3748.45112782003 | 1193.54887217997 | 4313 | 2.16927362889922 | 4.11627041847761 | 0.318411213453407 | weekly | |||||||||
9001 | 9001 | United States | Utah | UT | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 3205958 | 367 | 13 | 367.441102757705 | -0.441102757704527 | 354 | 0.405495018961571 | -0.013758843930723 | -0.00120047200597317 | weekly | |||||||||
9153 | 9153 | United States | Vermont | VT | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 623989 | 113 | 0 | 94.9147869682609 | 18.0852130317391 | 113 | 0.0 | 2.89832241141095 | 0.190541575337325 | weekly | |||||||||
9305 | 9305 | United States | Virginia | VA | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 8535519 | 1486 | 111 | 1262.40852130389 | 223.591478696106 | 1375 | 1.30044816255461 | 2.61954169038937 | 0.177114994807835 | weekly | |||||||||
9457 | 9457 | United States | Washington | WA | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 7614893 | 1240 | 50 | 1060.45614035169 | 179.543859648307 | 1190 | 0.656608044262736 | 2.35779885086116 | 0.169308142804249 | weekly | |||||||||
9609 | 9609 | United States | West Virginia | WV | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 1792147 | 460 | 32 | 421.025062657564 | 38.9749373424358 | 428 | 1.7855678133546 | 2.17476230144267 | 0.0925715374196989 | weekly | |||||||||
9761 | 9761 | United States | Wisconsin | WI | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 5822434 | 1039 | 41 | 999.746867168735 | 39.2531328312648 | 998 | 0.704172859666593 | 0.674170507235716 | 0.0392630716037441 | weekly | |||||||||
9913 | 9913 | United States | Wyoming | WY | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 578759 | 107 | 5 | 100.944862156216 | 6.05513784378439 | 102 | 0.863917450959726 | 1.0462278502424 | 0.0599846065906144 | 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);