economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where "start_date" is on date 2021-07-18 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths, end_date (date)
country 3
- United States 51
- Canada 1
- South Africa 1
cadence 1
- weekly 53
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2359 | 2359 | United States | Alabama | AL | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 4903185 | 1105 | 40 | 974.704260638197 | 130.295739361803 | 1065 | 0.815796263041268 | 2.65736943153896 | 0.133677203048739 | weekly | |||||||||
2511 | 2511 | United States | Alaska | AK | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 731545 | 99 | 3 | 82.9461152920515 | 16.0538847079485 | 96 | 0.410090971847255 | 2.1945177272688 | 0.193545950300664 | weekly | |||||||||
2663 | 2663 | United States | Arizona | AZ | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 7278717 | 1258 | 44 | 1184.88220552409 | 73.1177944759118 | 1214 | 0.604502139594107 | 1.00454234552479 | 0.0617089142996885 | weekly | |||||||||
2815 | 2815 | United States | Arkansas | AR | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 3017825 | 731 | 60 | 590.432330828636 | 140.567669171364 | 671 | 1.98818685642806 | 4.6579132047539 | 0.238075833303515 | weekly | |||||||||
2967 | 2967 | United States | California | CA | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 39512223 | 5432 | 144 | 4732.9047619052 | 699.095238094797 | 5288 | 0.364444187308823 | 1.76931386040921 | 0.147709551166498 | weekly | |||||||||
3119 | 3119 | United States | Colorado | CO | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 5758736 | 863 | 25 | 723.466165414563 | 139.533834585437 | 838 | 0.434123043667916 | 2.42299411859541 | 0.192868500637456 | weekly | |||||||||
3271 | 3271 | United States | Connecticut | CT | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 3565287 | 615 | 4 | 568.728070176027 | 46.2719298239734 | 611 | 0.112192931452643 | 1.29784586273064 | 0.081360376338822 | weekly | |||||||||
3423 | 3423 | United States | Delaware | DE | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 973764 | 180 | 1 | 184.149122810827 | -4.14912281082744 | 179 | 0.102694287322185 | -0.426091210070144 | -0.0225313199840205 | weekly | |||||||||
3575 | 3575 | United States | District of Columbia | DC | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 705749 | 136 | 0 | 116.615288220984 | 19.3847117790161 | 136 | 0.0 | 2.74668639686575 | 0.16622787693396 | weekly | |||||||||
3727 | 3727 | United States | Florida | FL | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 21477737 | 4872 | 479 | 3820.3609022566 | 1051.6390977434 | 4393 | 2.23021633983133 | 4.89641482127934 | 0.275272186227803 | weekly | |||||||||
3879 | 3879 | United States | Georgia | GA | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 10617423 | 1804 | 56 | 1623.71177944914 | 180.288220550856 | 1748 | 0.527434952907123 | 1.69804123421339 | 0.111034620080184 | weekly | |||||||||
4031 | 4031 | United States | Hawaii | HI | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 1415872 | 226 | 4 | 218.796992482066 | 7.20300751793394 | 222 | 0.282511413461104 | 0.508732958765619 | 0.0329209621952384 | weekly | |||||||||
4183 | 4183 | United States | Idaho | ID | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 1787065 | 323 | 10 | 258.463659148606 | 64.5363408513936 | 313 | 0.559576736156771 | 3.61130349771237 | 0.249692127179426 | weekly | |||||||||
4335 | 4335 | United States | Illinois | IL | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 12671821 | 2079 | 37 | 1870.05263157943 | 208.947368420574 | 2042 | 0.291986447725232 | 1.64891350990969 | 0.111733415890064 | weekly | |||||||||
4487 | 4487 | United States | Indiana | IN | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 6732219 | 1258 | 25 | 1211.85839599159 | 46.1416040084105 | 1233 | 0.37134858506534 | 0.685384774446738 | 0.0380750788714515 | weekly | |||||||||
4639 | 4639 | United States | Iowa | IA | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 3155070 | 610 | 0 | 515.097744361475 | 94.9022556385247 | 610 | 0.0 | 3.00792868743086 | 0.184241256494274 | weekly | |||||||||
4791 | 4791 | United States | Kansas | KS | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 2913314 | 533 | 42 | 490.923558897968 | 42.0764411020324 | 491 | 1.44165716431528 | 1.44428101818178 | 0.0857087429181158 | weekly | |||||||||
4943 | 4943 | United States | Kentucky | KY | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 4467673 | 1022 | 28 | 869.243107770879 | 152.756892229121 | 994 | 0.62672447155376 | 3.41916009137466 | 0.175735523081519 | weekly | |||||||||
5095 | 5095 | United States | Louisiana | LA | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 4648794 | 1095 | 72 | 824.924812030938 | 270.075187969062 | 1023 | 1.54878878263911 | 5.80957529993934 | 0.327393701862531 | weekly | |||||||||
5247 | 5247 | United States | Maine | ME | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 1344212 | 285 | 15 | 285.868421053328 | -0.868421053327552 | 270 | 1.11589540935507 | -0.0646044711197007 | -0.0030378348546779 | weekly | |||||||||
5399 | 5399 | United States | Maryland | MD | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 6045680 | 931 | 23 | 923.161654136209 | 7.83834586379066 | 908 | 0.380436940096069 | 0.129652013731965 | 0.00849076196857945 | weekly | |||||||||
5551 | 5551 | United States | Massachusetts | MA | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 6949503 | 1114 | 26 | 1011.0213032589 | 102.978696741103 | 1088 | 0.374127473576168 | 1.48181383245828 | 0.101856109667684 | weekly | |||||||||
5703 | 5703 | United States | Michigan | MI | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 9986857 | 1895 | 37 | 1830.46365914868 | 64.5363408513215 | 1858 | 0.370486930973378 | 0.646212725898864 | 0.0352568271589375 | weekly | |||||||||
5855 | 5855 | United States | Minnesota | MN | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 5639632 | 835 | 15 | 809.243107770205 | 25.7568922297949 | 820 | 0.265974801192702 | 0.456712286010769 | 0.0318283739243275 | weekly | |||||||||
6007 | 6007 | United States | Mississippi | MS | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 2976149 | 734 | 37 | 564.602756892927 | 169.397243107073 | 697 | 1.24321732547665 | 5.6918266896944 | 0.300029075379095 | weekly | |||||||||
6159 | 6159 | United States | Missouri | MO | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 6137428 | 1446 | 83 | 1175.5902255647 | 270.409774435301 | 1363 | 1.35235802358903 | 4.40591359174073 | 0.230020434463385 | weekly | |||||||||
6311 | 6311 | United States | Montana | MT | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 1068778 | 211 | 4 | 193.468671680025 | 17.5313283199749 | 207 | 0.374259200694625 | 1.64031523103721 | 0.0906158509682109 | weekly | |||||||||
6463 | 6463 | United States | Nebraska | NE | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 1934408 | 334 | 7 | 291.057644111353 | 42.9423558886473 | 327 | 0.361867816923834 | 2.21992236842731 | 0.147539007332233 | weekly | |||||||||
6615 | 6615 | United States | Nevada | NV | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 3080156 | 619 | 59 | 496.44862155473 | 122.55137844527 | 560 | 1.91548739739156 | 3.97873933804879 | 0.246856115868497 | weekly | |||||||||
6767 | 6767 | United States | New Hampshire | NH | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 1359711 | 246 | 4 | 237.066416040921 | 8.93358395907876 | 242 | 0.294180160342896 | 0.657020790379629 | 0.0376838866857323 | weekly | |||||||||
6919 | 6919 | United States | New Jersey | NJ | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 8882190 | 1371 | 55 | 1346.51002506365 | 24.4899749363537 | 1316 | 0.619216657153247 | 0.27572000752465 | 0.0181877405147401 | weekly | |||||||||
7071 | 7071 | United States | New Mexico | NM | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 2096829 | 398 | 18 | 350.629072682552 | 47.3709273174482 | 380 | 0.858439100184135 | 2.25916979007102 | 0.135102679749367 | weekly | |||||||||
7223 | 7223 | United States | New York | NY | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 19453561 | 2903 | 42 | 2807.84962406097 | 95.1503759390307 | 2861 | 0.215898775550656 | 0.489115468057651 | 0.0338872762713751 | weekly | |||||||||
7375 | 7375 | United States | North Carolina | NC | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 10488084 | 2024 | 47 | 1768.38972431141 | 255.610275688591 | 1977 | 0.448127608436393 | 2.43714939438501 | 0.144544085602014 | weekly | |||||||||
7527 | 7527 | United States | North Dakota | ND | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 762062 | 138 | 1 | 130.343358396884 | 7.65664160311607 | 137 | 0.131222918870118 | 1.00472685990327 | 0.0587420924033757 | weekly | |||||||||
7679 | 7679 | United States | Ohio | OH | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 11689100 | 2339 | 30 | 2172.72556391198 | 166.274436088023 | 2309 | 0.256649357093361 | 1.42247423743507 | 0.0765280433248308 | weekly | |||||||||
7831 | 7831 | United States | Oklahoma | OK | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 3956971 | 846 | 55 | 716.065162908003 | 129.934837091997 | 791 | 1.38995206181698 | 3.2836944494159 | 0.181456721849615 | weekly | |||||||||
7983 | 7983 | United States | Oregon | OR | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 4217737 | 812 | 19 | 675.749373434512 | 136.250626565488 | 793 | 0.450478538609686 | 3.23042016525659 | 0.201628935107985 | weekly | |||||||||
8135 | 8135 | United States | Pennsylvania | PA | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 12801989 | 2498 | 33 | 2336.42857142969 | 161.571428570311 | 2465 | 0.257772444578729 | 1.26208067020141 | 0.0691531641694672 | weekly | |||||||||
8287 | 8287 | United States | Rhode Island | RI | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 1059361 | 177 | 3 | 197.200501254016 | -20.200501254016 | 174 | 0.283189583154373 | -1.90685717654472 | -0.102436358556693 | weekly | |||||||||
8439 | 8439 | United States | South Carolina | SC | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 5148714 | 1080 | 16 | 944.540100251593 | 135.459899748407 | 1064 | 0.310757210441287 | 2.63094628577947 | 0.143413603839928 | weekly | |||||||||
8591 | 8591 | United States | South Dakota | SD | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 884659 | 163 | 1 | 147.413533835296 | 15.5864661647045 | 162 | 0.113037905000684 | 1.76186148162224 | 0.105732938890938 | weekly | |||||||||
8743 | 8743 | United States | Tennessee | TN | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 6833174 | 1560 | 45 | 1408.04135338437 | 151.958646615632 | 1515 | 0.658551940869646 | 2.22383692579221 | 0.107922005451321 | weekly | |||||||||
8895 | 8895 | United States | Texas | TX | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 28995881 | 4445 | 301 | 3748.67669172987 | 696.323308270132 | 4144 | 1.03807847742236 | 2.40145594565701 | 0.185751764030844 | weekly | |||||||||
9047 | 9047 | United States | Utah | UT | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 3205958 | 446 | 12 | 381.328320802848 | 64.6716791971517 | 434 | 0.374303094426065 | 2.01723413710197 | 0.169595793622126 | weekly | |||||||||
9199 | 9199 | United States | Vermont | VT | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 623989 | 110 | 1 | 95.538847118665 | 14.461152881335 | 109 | 0.160259235339084 | 2.31753330288435 | 0.151364113315848 | weekly | |||||||||
9351 | 9351 | United States | Virginia | VA | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 8535519 | 1382 | 23 | 1270.27944862223 | 111.720551377771 | 1359 | 0.269462231880686 | 1.30888996179109 | 0.0879495858166846 | weekly | |||||||||
9503 | 9503 | United States | Washington | WA | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 7614893 | 1239 | 36 | 1050.68421052715 | 188.315789472845 | 1203 | 0.47275779186917 | 2.47299324459116 | 0.179231578419136 | weekly | |||||||||
9655 | 9655 | United States | West Virginia | WV | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 1792147 | 441 | 17 | 384.870927319284 | 56.1290726807163 | 424 | 0.948582900844629 | 3.13194579912899 | 0.145838692134187 | weekly | |||||||||
9807 | 9807 | United States | Wisconsin | WI | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 5822434 | 1077 | 4 | 986.786967419401 | 90.2130325805995 | 1073 | 0.0686997911869847 | 1.54940412515796 | 0.0914209809808497 | weekly | |||||||||
9959 | 9959 | United States | Wyoming | WY | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 578759 | 99 | 6 | 92.4172932339438 | 6.58270676605618 | 93 | 1.03670094115167 | 1.13738304994932 | 0.0712280844386213 | weekly | |||||||||
12007 | 12007 | Canada | Canada | 0 | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 38454328 | 5415 | 51 | 5232.17614424422 | 182.823855755775 | 5364 | 0.1326248634484 | 0.475431154994504 | 0.0349422211170967 | weekly | |||||||||
17058 | 17058 | South Africa | South Africa | 0 | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 59893884 | 20408 | 2812 | 10863.9012552301 | 9544.09874476994 | 17596 | 4.69497019094637 | 15.9350139068789 | 0.878514865014553 | 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);