economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where end_date = "2020-01-18" and week = 3 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2280 | 2280 | United States | Alabama | AL | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 4903185 | 1039 | 0 | 1125.51879698715 | -86.5187969871452 | 1039 | 0.0 | -1.76454278162348 | -0.0768701484317665 | weekly | |||||||||
2432 | 2432 | United States | Alaska | AK | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 731545 | 99 | 0 | 99.0563909797412 | -0.0563909797412094 | 99 | 0.0 | -0.00770847722849714 | -0.00056928158984459 | weekly | |||||||||
2584 | 2584 | United States | Arizona | AZ | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 7278717 | 1315 | 0 | 1307.27443609711 | 7.72556390289128 | 1315 | 0.0 | 0.106139088837927 | 0.00590967259021458 | weekly | |||||||||
2736 | 2736 | United States | Arkansas | AR | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 3017825 | 658 | 0 | 689.466165414734 | -31.4661654147341 | 658 | 0.0 | -1.04267694166276 | -0.0456384475310783 | weekly | |||||||||
2888 | 2888 | United States | California | CA | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 39512223 | 5830 | 0 | 5947.78571428643 | -117.785714286427 | 5830 | 0.0 | -0.298099436942403 | -0.0198032881385602 | weekly | |||||||||
3040 | 3040 | United States | Colorado | CO | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 5758736 | 848 | 0 | 840.733082707859 | 7.26691729214144 | 848 | 0.0 | 0.126189450117898 | 0.00864354863821459 | weekly | |||||||||
3192 | 3192 | United States | Connecticut | CT | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 3565287 | 639 | 0 | 661.447368421889 | -22.4473684218885 | 639 | 0.0 | -0.629609016662292 | -0.0339367415966058 | weekly | |||||||||
3344 | 3344 | United States | Delaware | DE | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 973764 | 190 | 0 | 201.657894739354 | -11.6578947393538 | 190 | 0.0 | -1.19719919193499 | -0.0578102570912081 | weekly | |||||||||
3496 | 3496 | United States | District of Columbia | DC | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 705749 | 140 | 0 | 121.390977443998 | 18.6090225560018 | 140 | 0.0 | 2.63677632642792 | 0.153298234743902 | weekly | |||||||||
3648 | 3648 | United States | Florida | FL | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 21477737 | 4385 | 0 | 4435.18045112886 | -50.1804511288647 | 4385 | 0.0 | -0.23363937797015 | -0.0113141847737204 | weekly | |||||||||
3800 | 3800 | United States | Georgia | GA | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 10617423 | 1746 | 0 | 1844.27255639143 | -98.2725563914332 | 1746 | 0.0 | -0.925578234863895 | -0.053285267435588 | weekly | |||||||||
3952 | 3952 | United States | Hawaii | HI | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 1415872 | 215 | 0 | 247.898496241499 | -32.8984962414995 | 215 | 0.0 | -2.32355016848271 | -0.132709543382829 | weekly | |||||||||
4104 | 4104 | United States | Idaho | ID | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 1787065 | 293 | 0 | 279.648496241419 | 13.3515037585807 | 293 | 0.0 | 0.747119089601147 | 0.0477438782544157 | weekly | |||||||||
4256 | 4256 | United States | Illinois | IL | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 12671821 | 2231 | 0 | 2266.02631579002 | -35.0263157900195 | 2231 | 0.0 | -0.276411068227838 | -0.0154571531433464 | weekly | |||||||||
4408 | 4408 | United States | Indiana | IN | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 6732219 | 1389 | 0 | 1408.84586466288 | -19.8458646628847 | 1389 | 0.0 | -0.294789350478418 | -0.0140866117157773 | weekly | |||||||||
4560 | 4560 | United States | Iowa | IA | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 3155070 | 620 | 0 | 646.298872181153 | -26.2988721811527 | 620 | 0.0 | -0.83354322348324 | -0.0406915025124495 | weekly | |||||||||
4712 | 4712 | United States | Kansas | KS | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 2913314 | 576 | 0 | 563.295112782735 | 12.704887217265 | 576 | 0.0 | 0.436097420918753 | 0.0225545844956856 | weekly | |||||||||
4864 | 4864 | United States | Kentucky | KY | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 4467673 | 1041 | 0 | 1037.4548872192 | 3.54511278079531 | 1041 | 0.0 | 0.0793503190765149 | 0.00341712475835698 | weekly | |||||||||
5016 | 5016 | United States | Louisiana | LA | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 4648794 | 960 | 0 | 997.462406015965 | -37.4624060159651 | 960 | 0.0 | -0.805852141780538 | -0.037557712240601 | weekly | |||||||||
5168 | 5168 | United States | Maine | ME | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 1344212 | 295 | 0 | 310.434210527076 | -15.4342105270759 | 295 | 0.0 | -1.14819764494558 | -0.0497181367377991 | weekly | |||||||||
5320 | 5320 | United States | Maryland | MD | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 6045680 | 988 | 0 | 1043.83082706855 | -55.8308270685491 | 988 | 0.0 | -0.923483000564851 | -0.0534864708157183 | weekly | |||||||||
5472 | 5472 | United States | Massachusetts | MA | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 6949503 | 1189 | 0 | 1259.5939849632 | -70.5939849631982 | 1189 | 0.0 | -1.01581343245982 | -0.0560450318165506 | weekly | |||||||||
5624 | 5624 | United States | Michigan | MI | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 9986857 | 1936 | 0 | 2045.64849624152 | -109.648496241522 | 1936 | 0.0 | -1.09792796914507 | -0.0536008490427263 | weekly | |||||||||
5776 | 5776 | United States | Minnesota | MN | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 5639632 | 946 | 0 | 961.204887218854 | -15.2048872188543 | 946 | 0.0 | -0.269607790346149 | -0.0158185704432362 | weekly | |||||||||
5928 | 5928 | United States | Mississippi | MS | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 2976149 | 624 | 0 | 657.968045113525 | -33.968045113525 | 624 | 0.0 | -1.14134222155964 | -0.0516256759971744 | weekly | |||||||||
6080 | 6080 | United States | Missouri | MO | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 6137428 | 1334 | 0 | 1432.04511278276 | -98.0451127827616 | 1334 | 0.0 | -1.59749511982481 | -0.0684651006505232 | weekly | |||||||||
6232 | 6232 | United States | Montana | MT | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 1068778 | 202 | 0 | 204.567669173777 | -2.56766917377692 | 202 | 0.0 | -0.240243453156495 | -0.0125516861200375 | weekly | |||||||||
6384 | 6384 | United States | Nebraska | NE | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 1934408 | 333 | 0 | 361.94548872287 | -28.9454887228699 | 333 | 0.0 | -1.49634868770548 | -0.0799719560672091 | weekly | |||||||||
6536 | 6536 | United States | Nevada | NV | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 3080156 | 605 | 0 | 579.640977444466 | 25.3590225555342 | 605 | 0.0 | 0.823303188394816 | 0.0437495338361646 | weekly | |||||||||
6688 | 6688 | United States | New Hampshire | NH | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 1359711 | 245 | 0 | 246.616541354222 | -1.61654135422214 | 245 | 0.0 | -0.118888598696498 | -0.00655487805215893 | weekly | |||||||||
6840 | 6840 | United States | New Jersey | NJ | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 8882190 | 1490 | 0 | 1549.08834586566 | -59.0883458656563 | 1490 | 0.0 | -0.665245236429937 | -0.0381439483573396 | weekly | |||||||||
6992 | 6992 | United States | New Mexico | NM | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 2096829 | 388 | 0 | 406.731203008356 | -18.7312030083557 | 388 | 0.0 | -0.893310947547735 | -0.0460530268388848 | weekly | |||||||||
7144 | 7144 | United States | New York | NY | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 19453561 | 3298 | 0 | 3281.17481203088 | 16.8251879691193 | 3298 | 0.0 | 0.0864889876414877 | 0.00512779383391204 | weekly | |||||||||
7296 | 7296 | United States | North Carolina | NC | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 10488084 | 1902 | 0 | 1968.77819548926 | -66.778195489263 | 1902 | 0.0 | -0.636705383836199 | -0.0339185976572988 | weekly | |||||||||
7448 | 7448 | United States | North Dakota | ND | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 762062 | 171 | 0 | 162.338345865515 | 8.66165413448459 | 171 | 0.0 | 1.1366075377705 | 0.0533555648131347 | weekly | |||||||||
7600 | 7600 | United States | Ohio | OH | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 11689100 | 2477 | 0 | 2638.36278195675 | -161.362781956751 | 2477 | 0.0 | -1.38045514159988 | -0.0611601948982452 | weekly | |||||||||
7752 | 7752 | United States | Oklahoma | OK | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 3956971 | 850 | 0 | 858.949248121085 | -8.94924812108468 | 850 | 0.0 | -0.226164106865698 | -0.0104188322426043 | weekly | |||||||||
7904 | 7904 | United States | Oregon | OR | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 4217737 | 769 | 0 | 803.041353384339 | -34.0413533843391 | 769 | 0.0 | -0.807099953940682 | -0.0423905359803392 | weekly | |||||||||
8056 | 8056 | United States | Pennsylvania | PA | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 12801989 | 2862 | 0 | 2888.71428571539 | -26.7142857153867 | 2862 | 0.0 | -0.208672931334238 | -0.0092478116813034 | weekly | |||||||||
8208 | 8208 | United States | Rhode Island | RI | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 1059361 | 204 | 0 | 210.016917294097 | -6.01691729409691 | 204 | 0.0 | -0.567976100129881 | -0.0286496791383293 | weekly | |||||||||
8360 | 8360 | United States | South Carolina | SC | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 5148714 | 1048 | 0 | 1068.35338345959 | -20.3533834595867 | 1048 | 0.0 | -0.395310041683936 | -0.0190511714332551 | weekly | |||||||||
8512 | 8512 | United States | South Dakota | SD | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 884659 | 168 | 0 | 165.456766918022 | 2.54323308197831 | 168 | 0.0 | 0.287481739515261 | 0.0153709825796269 | weekly | |||||||||
8664 | 8664 | United States | Tennessee | TN | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 6833174 | 1597 | 0 | 1614.0206766926 | -17.0206766926017 | 1597 | 0.0 | -0.249088881573946 | -0.010545513411563 | weekly | |||||||||
8816 | 8816 | United States | Texas | TX | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 28995881 | 4250 | 0 | 4427.58834586514 | -177.588345865143 | 4250 | 0.0 | -0.612460596955627 | -0.0401094979913817 | weekly | |||||||||
8968 | 8968 | United States | Utah | UT | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 3205958 | 409 | 0 | 394.830827068498 | 14.1691729315016 | 409 | 0.0 | 0.441963772809926 | 0.0358866936421949 | weekly | |||||||||
9120 | 9120 | United States | Vermont | VT | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 623989 | 129 | 0 | 115.93609022642 | 13.0639097735796 | 129 | 0.0 | 2.09361219085266 | 0.112681993571338 | weekly | |||||||||
9272 | 9272 | United States | Virginia | VA | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 8535519 | 1466 | 0 | 1473.5563909781 | -7.55639097809967 | 1466 | 0.0 | -0.0885287816487746 | -0.00512799579599665 | weekly | |||||||||
9424 | 9424 | United States | Washington | WA | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 7614893 | 1221 | 0 | 1256.34210526399 | -35.3421052639928 | 1221 | 0.0 | -0.464118212350362 | -0.0281309566207418 | weekly | |||||||||
9576 | 9576 | United States | West Virginia | WV | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 1792147 | 520 | 0 | 517.768796993401 | 2.23120300659866 | 520 | 0.0 | 0.12449888355133 | 0.00430926509970253 | weekly | |||||||||
9728 | 9728 | United States | Wisconsin | WI | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 5822434 | 1133 | 0 | 1162.06015037677 | -29.0601503767678 | 1133 | 0.0 | -0.49910656568658 | -0.0250074407657347 | weekly | |||||||||
9880 | 9880 | United States | Wyoming | WY | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 578759 | 103 | 0 | 96.458646617383 | 6.54135338261702 | 103 | 0.0 | 1.13023786802745 | 0.0678151063902466 | weekly | |||||||||
11928 | 11928 | Canada | Canada | 0 | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 38454328 | 6135 | 0 | 6346.56842348612 | -211.568423486123 | 6135 | 0.0 | -0.550181044604714 | -0.0333358768658649 | weekly | |||||||||
16979 | 16979 | South Africa | South Africa | 0 | 2020-01-12 | 2020-01-18 | 7 | 2020 | 3 | 59893884 | 9256 | 0 | 9104.68828451883 | 151.31171548117 | 9256 | 0.0 | 0.252632999190986 | 0.0166190989469077 | 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);