economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
54 rows where "end_date" is on date 2020-09-19 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: days, start_date (date)
country 4
- United States 51
- Canada 1
- South Africa 1
- Tajikistan 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2315 | 2315 | United States | Alabama | AL | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 4903185 | 1200 | 84 | 967.358395981718 | 232.641604018282 | 1116 | 1.71317215238666 | 4.74470377965102 | 0.240491636796295 | weekly | |||||||||
2467 | 2467 | United States | Alaska | AK | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 731545 | 104 | 1 | 94.408521306073 | 9.59147869392703 | 103 | 0.136696990615752 | 1.31112627301492 | 0.101595476353574 | weekly | |||||||||
2619 | 2619 | United States | Arizona | AZ | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 7278717 | 1259 | 156 | 1107.69924812833 | 151.30075187167 | 1103 | 2.14323485856092 | 2.07867336883232 | 0.136590100722125 | weekly | |||||||||
2771 | 2771 | United States | Arkansas | AR | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 3017825 | 736 | 226 | 594.954887219374 | 141.045112780626 | 510 | 7.48883715921235 | 4.67373398989757 | 0.23706858420783 | weekly | |||||||||
2923 | 2923 | United States | California | CA | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 39512223 | 5755 | 498 | 4803.71428571492 | 951.285714285081 | 5257 | 1.26036948110968 | 2.40757325723 | 0.198031285314777 | weekly | |||||||||
3075 | 3075 | United States | Colorado | CO | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 5758736 | 804 | 25 | 756.977443610102 | 47.0225563898977 | 779 | 0.434123043667916 | 0.816543012041143 | 0.0621188343019077 | weekly | |||||||||
3227 | 3227 | United States | Connecticut | CT | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 3565287 | 579 | 12 | 577.59649122883 | 1.4035087711701 | 567 | 0.33657879435793 | 0.0393659408392675 | 0.00242991221810263 | weekly | |||||||||
3379 | 3379 | United States | Delaware | DE | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 973764 | 161 | 8 | 165.877192985406 | -4.87719298540577 | 153 | 0.821554298577479 | -0.500859857769005 | -0.0294024325926161 | weekly | |||||||||
3531 | 3531 | United States | District of Columbia | DC | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 705749 | 109 | 0 | 114.521303258555 | -5.52130325855533 | 109 | 0.0 | -0.782332423929093 | -0.0482120190868756 | weekly | |||||||||
3683 | 3683 | United States | Florida | FL | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 21477737 | 4667 | 689 | 3892.90726817145 | 774.092731828546 | 3978 | 3.20797298151104 | 3.60416338010166 | 0.198846948695016 | weekly | |||||||||
3835 | 3835 | United States | Georgia | GA | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 10617423 | 1928 | 310 | 1586.69674185512 | 341.303258144879 | 1618 | 2.919729203593 | 3.2145583551195 | 0.215103018202355 | weekly | |||||||||
3987 | 3987 | United States | Hawaii | HI | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 1415872 | 242 | 23 | 218.531328321695 | 23.4686716783051 | 219 | 1.62444062740135 | 1.65754190197314 | 0.107392710503079 | weekly | |||||||||
4139 | 4139 | United States | Idaho | ID | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 1787065 | 320 | 26 | 284.197994988266 | 35.8020050117341 | 294 | 1.4548995140076 | 2.00339691123345 | 0.125975572112014 | weekly | |||||||||
4291 | 4291 | United States | Illinois | IL | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 12671821 | 2080 | 141 | 1972.03508771982 | 107.96491228018 | 1939 | 1.11270511160156 | 0.852007870693405 | 0.0547479671900843 | weekly | |||||||||
4443 | 4443 | United States | Indiana | IN | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 6732219 | 1409 | 67 | 1195.7944862169 | 213.205513783097 | 1342 | 0.995214207975112 | 3.16694263485927 | 0.178296117134315 | weekly | |||||||||
4595 | 4595 | United States | Iowa | IA | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 3155070 | 642 | 56 | 547.731829574599 | 94.2681704254011 | 586 | 1.77492100016798 | 2.98783134527605 | 0.172106431168361 | weekly | |||||||||
4747 | 4747 | United States | Kansas | KS | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 2913314 | 553 | 77 | 499.726817043373 | 53.273182956627 | 476 | 2.64303813457801 | 1.82861109226905 | 0.106604611038921 | weekly | |||||||||
4899 | 4899 | United States | Kentucky | KY | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 4467673 | 1017 | 50 | 879.939849625324 | 137.060150374676 | 967 | 1.11915084206029 | 3.06781965409455 | 0.155760817552513 | weekly | |||||||||
5051 | 5051 | United States | Louisiana | LA | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 4648794 | 1040 | 141 | 864.283208020961 | 175.716791979039 | 899 | 3.03304469933492 | 3.77983606025647 | 0.203309274492786 | weekly | |||||||||
5203 | 5203 | United States | Maine | ME | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 1344212 | 299 | 5 | 287.245614035833 | 11.7543859641672 | 294 | 0.371965136451691 | 0.87444435581346 | 0.0409210285198678 | weekly | |||||||||
5355 | 5355 | United States | Maryland | MD | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 6045680 | 991 | 40 | 907.774436091108 | 83.2255639088921 | 951 | 0.661629461036641 | 1.37661212483777 | 0.0916808852508149 | weekly | |||||||||
5507 | 5507 | United States | Massachusetts | MA | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 6949503 | 1094 | 99 | 1047.79197995066 | 46.2080200493374 | 995 | 1.42456230323233 | 0.664911146154443 | 0.0441003757745055 | weekly | |||||||||
5659 | 5659 | United States | Michigan | MI | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 9986857 | 1905 | 58 | 1765.53132832169 | 139.468671678309 | 1847 | 0.580763297201512 | 1.39652216586569 | 0.0789952970196728 | weekly | |||||||||
5811 | 5811 | United States | Minnesota | MN | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 5639632 | 957 | 57 | 861.606516291533 | 95.393483708467 | 900 | 1.01070424453227 | 1.69148419096258 | 0.110715833625601 | weekly | |||||||||
5963 | 5963 | United States | Mississippi | MS | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 2976149 | 738 | 131 | 553.290726817776 | 184.709273182224 | 607 | 4.40166134155246 | 6.20631807017135 | 0.333837644893436 | weekly | |||||||||
6115 | 6115 | United States | Missouri | MO | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 6137428 | 1445 | 89 | 1192.06015037674 | 252.939849623256 | 1356 | 1.45011884457137 | 4.12126789305318 | 0.21218715309233 | weekly | |||||||||
6267 | 6267 | United States | Montana | MT | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 1068778 | 235 | 23 | 183.090225564753 | 51.9097744352471 | 212 | 2.15199040399409 | 4.85692767209346 | 0.283520183970107 | weekly | |||||||||
6419 | 6419 | United States | Nebraska | NE | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 1934408 | 328 | 8 | 314.593984963478 | 13.4060150365219 | 320 | 0.413563219341525 | 0.693029342130609 | 0.0426137042578172 | weekly | |||||||||
6571 | 6571 | United States | Nevada | NV | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 3080156 | 537 | 79 | 469.854636592338 | 67.1453634076622 | 458 | 2.56480515921921 | 2.17993385424836 | 0.142906674061237 | weekly | |||||||||
6723 | 6723 | United States | New Hampshire | NH | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 1359711 | 226 | 3 | 230.155388472014 | -4.15538847201449 | 223 | 0.220635120257172 | -0.305608211746062 | -0.0180547086018791 | weekly | |||||||||
6875 | 6875 | United States | New Jersey | NJ | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 8882190 | 1378 | 36 | 1345.11779448721 | 32.8822055127885 | 1342 | 0.405305448318489 | 0.370203806862817 | 0.0244455955066181 | weekly | |||||||||
7027 | 7027 | United States | New Mexico | NM | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 2096829 | 398 | 26 | 359.641604010872 | 38.3583959891279 | 372 | 1.23996758915486 | 1.8293526076341 | 0.106657282031164 | weekly | |||||||||
7179 | 7179 | United States | New York | NY | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 19453561 | 2886 | 57 | 2798.23308270758 | 87.7669172924193 | 2829 | 0.293005481104462 | 0.451161189935453 | 0.0313651203092402 | weekly | |||||||||
7331 | 7331 | United States | North Carolina | NC | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 10488084 | 2261 | 186 | 1804.03759398555 | 456.962406014453 | 2075 | 1.77344117381211 | 4.35696745005525 | 0.253299824536868 | weekly | |||||||||
7483 | 7483 | United States | North Dakota | ND | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 762062 | 165 | 25 | 138.784461153755 | 26.2155388462452 | 140 | 3.28057297175295 | 3.44007952715727 | 0.188893905184399 | weekly | |||||||||
7635 | 7635 | United States | Ohio | OH | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 11689100 | 2485 | 201 | 2294.15037594182 | 190.849624058176 | 2284 | 1.71955069252552 | 1.63271444386801 | 0.08318967494876 | weekly | |||||||||
7787 | 7787 | United States | Oklahoma | OK | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 3956971 | 793 | 77 | 711.598997494506 | 81.4010025054945 | 716 | 1.94593288654377 | 2.0571543866633 | 0.114391676761915 | weekly | |||||||||
7939 | 7939 | United States | Oregon | OR | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 4217737 | 790 | 18 | 670.388471178847 | 119.611528821153 | 772 | 0.426769141840755 | 2.83591719495913 | 0.178421219879903 | weekly | |||||||||
8091 | 8091 | United States | Pennsylvania | PA | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 12801989 | 2618 | 119 | 2421.2857142868 | 196.714285713197 | 2499 | 0.929543057723296 | 1.53659158520755 | 0.0812437311930945 | weekly | |||||||||
8243 | 8243 | United States | Rhode Island | RI | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 1059361 | 194 | 13 | 196.689223058519 | -2.68922305851927 | 181 | 1.22715486033562 | -0.253853318983734 | -0.0136724474107012 | weekly | |||||||||
8395 | 8395 | United States | South Carolina | SC | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 5148714 | 1142 | 145 | 934.804511279156 | 207.195488720844 | 997 | 2.81623721962416 | 4.02421825568179 | 0.221645794624295 | weekly | |||||||||
8547 | 8547 | United States | South Dakota | SD | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 884659 | 181 | 17 | 159.94235589045 | 21.0576441095497 | 164 | 1.92164438501163 | 2.38031197439349 | 0.131657708755852 | weekly | |||||||||
8699 | 8699 | United States | Tennessee | TN | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 6833174 | 1620 | 171 | 1384.69423558987 | 235.30576441013 | 1449 | 2.50249737530465 | 3.44357928555792 | 0.169933374720731 | weekly | |||||||||
8851 | 8851 | United States | Texas | TX | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 28995881 | 4601 | 463 | 3701.78446115341 | 899.215538846589 | 4138 | 1.59677852174935 | 3.10118371242657 | 0.242914072465043 | weekly | |||||||||
9003 | 9003 | United States | Utah | UT | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 3205958 | 400 | 7 | 366.774436091066 | 33.2255639089344 | 393 | 0.218343471748538 | 1.0363692820971 | 0.0905885488177396 | weekly | |||||||||
9155 | 9155 | United States | Vermont | VT | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 623989 | 114 | 0 | 97.5814536349493 | 16.4185463650507 | 114 | 0.0 | 2.63122368584234 | 0.168254783603371 | weekly | |||||||||
9307 | 9307 | United States | Virginia | VA | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 8535519 | 1459 | 265 | 1318.40852130393 | 140.591478696072 | 1194 | 3.10467354123399 | 1.64713450577606 | 0.106637264872214 | weekly | |||||||||
9459 | 9459 | United States | Washington | WA | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 7614893 | 1178 | 45 | 1037.78947368505 | 140.210526314947 | 1133 | 0.590947239836463 | 1.84126718937413 | 0.135104980220197 | weekly | |||||||||
9611 | 9611 | United States | West Virginia | WV | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 1792147 | 484 | 44 | 407.691729324255 | 76.3082706757446 | 440 | 2.45515574336257 | 4.257924750355 | 0.187171495488085 | weekly | |||||||||
9763 | 9763 | United States | Wisconsin | WI | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 5822434 | 1140 | 34 | 999.413533835436 | 140.586466164564 | 1106 | 0.58394822508937 | 2.41456521730541 | 0.140668963752209 | weekly | |||||||||
9915 | 9915 | United States | Wyoming | WY | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 578759 | 94 | 7 | 88.9448621562421 | 5.05513784375789 | 87 | 1.20948443134362 | 0.873444360045872 | 0.0568345120921987 | weekly | |||||||||
11963 | 11963 | Canada | Canada | 0 | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 38454328 | 5465 | 52 | 5272.88210818327 | 192.117891816733 | 5413 | 0.135225350966997 | 0.499600179768407 | 0.0364350819675205 | weekly | |||||||||
17014 | 17014 | South Africa | South Africa | 0 | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 59893884 | 10010 | 513 | 10105.8259414226 | -95.8259414225722 | 9497 | 0.856514832132109 | -0.159992865753325 | -0.00948224736682035 | weekly | |||||||||
21301 | 21301 | Tajikistan | Tajikistan | 0 | 2020-06-20 | 2020-09-19 | 92 | 2020 | 9749625 | 10721.9 | 22 | 7644.83584249085 | 3077.06415750915 | 10699.9 | 0.225649704475813 | 31.5608462634117 | 0.402502319331238 | 815.796739130435 | 1.67391304347826 | 581.672292363434 | 234.124446767 | 814.122826086956 | 0.0171689992535945 | 2.4013687374335 | 3 |
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);