economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
33 rows where cadence = "weekly" and covid_deaths = 168 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, start_date, end_date, year, week, population, total_deaths, expected_deaths, non_covid_deaths, covid_deaths_per_100k, start_date (date), end_date (date)
country 10
cadence 1
- weekly · 33 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5771 | 5771 | United States | Michigan | MI | 2022-11-06 | 2022-11-12 | 7 | 2022 | 45 | 9986857 | 2282 | 168 | 1919.06265664229 | 362.937343357713 | 2114 | 1.68221092982507 | 3.63414979665487 | 0.189122195724829 | weekly | |||||||||
145 | 145 | Finland | Finland | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 5540745 | 1204 | 168 | 1036.22022471906 | 167.779775280935 | 1036 | 3.03208323068468 | 3.02810858974624 | 0.161915171387842 | weekly | |||||||||
13413 | 13413 | Finland | Finland | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 5540745 | 1204 | 168 | 1036.22022471906 | 167.779775280935 | 1036 | 3.03208323068468 | 3.02810858974623 | 0.161915171387847 | weekly | |||||||||
12057 | 12057 | Canada | Canada | 0 | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 38454328 | 5275 | 168 | 5452.47018030517 | -177.47018030517 | 5107 | 0.436881903124143 | -0.461508988806592 | -0.0325485833826674 | weekly | |||||||||
1114 | 1114 | Slovakia | Slovakia | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 5643455 | 1085 | 168 | 1041.0283707865 | 43.9716292135049 | 917 | 2.97689978922486 | 0.779161510342599 | 0.0422386463687674 | weekly | |||||||||
11592 | 11592 | Belgium | Belgium | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 11655923 | 2435 | 168 | 2060.39382022478 | 374.606179775223 | 2267 | 1.44132729771808 | 3.21386971907092 | 0.181812902027804 | weekly | |||||||||
16799 | 16799 | Slovakia | Slovakia | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 5643455 | 1085 | 168 | 1041.0283707865 | 43.9716292135049 | 917 | 2.97689978922486 | 0.779161510342599 | 0.0422386463687625 | weekly | |||||||||
20416 | 20416 | Belgium | Belgium | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 11655923 | 2435 | 168 | 2060.39382022478 | 374.606179775223 | 2267 | 1.44132729771808 | 3.21386971907092 | 0.181812902027805 | weekly | |||||||||
11580 | 11580 | Belgium | Belgium | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 11655923 | 2368 | 168 | 2373.34110486897 | -5.34110486896907 | 2200 | 1.44132729771808 | -0.0458230967120242 | -0.00225045816550029 | weekly | |||||||||
20404 | 20404 | Belgium | Belgium | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 11655923 | 2368 | 168 | 2373.34110486897 | -5.34110486896907 | 2200 | 1.44132729771808 | -0.0458230967120242 | -0.00225045816549996 | weekly | |||||||||
8464 | 8464 | United States | South Carolina | SC | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 5148714 | 1508 | 168 | 1103.90789473781 | 404.092105262192 | 1340 | 3.26295070963351 | 7.84840846203911 | 0.36605599723351 | weekly | |||||||||
7093 | 7093 | United States | New Mexico | NM | 2021-12-19 | 2021-12-25 | 7 | 2021 | 51 | 2096829 | 613 | 168 | 379.962406015878 | 233.037593984122 | 445 | 8.01209826838526 | 11.113810138267 | 0.613317502717317 | weekly | |||||||||
3899 | 3899 | United States | Georgia | GA | 2021-12-05 | 2021-12-11 | 7 | 2021 | 49 | 10617423 | 2060 | 168 | 1760.71177944915 | 299.288220550848 | 1892 | 1.58230485872137 | 2.81884050914095 | 0.169981381418645 | weekly | |||||||||
14992 | 14992 | Lithuania | Lithuania | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 2750058 | 993 | 168 | 672.028089887664 | 320.971910112336 | 825 | 6.10896206552735 | 11.6714596605721 | 0.477616806413538 | weekly | |||||||||
18407 | 18407 | Lithuania | Lithuania | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 2750058 | 993 | 168 | 672.028089887664 | 320.971910112336 | 825 | 6.10896206552735 | 11.6714596605721 | 0.477616806413537 | weekly | |||||||||
5871 | 5871 | United States | Minnesota | MN | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 5639632 | 1179 | 168 | 933.576441103498 | 245.423558896502 | 1011 | 2.97891777335826 | 4.35176548570017 | 0.262885338672866 | weekly | |||||||||
7999 | 7999 | United States | Oregon | OR | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 4217737 | 881 | 168 | 734.082706767809 | 146.917293232191 | 713 | 3.98317865718038 | 3.48332039745938 | 0.200137248674707 | weekly | |||||||||
16175 | 16175 | Peru | Peru | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 34049588 | 3073.6 | 168 | 3247.74461538391 | -174.144615383907 | 2905.6 | 0.49339804052842 | -0.511444119041637 | -0.0536201690733386 | weekly | |||||||||
24803 | 24803 | Peru | Peru | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 34049588 | 3073.6 | 168 | 3247.74461538391 | -174.144615383907 | 2905.6 | 0.49339804052842 | -0.511444119041638 | -0.0536201690733378 | weekly | |||||||||
4948 | 4948 | United States | Kentucky | KY | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 4467673 | 1266 | 168 | 873.243107770866 | 392.756892229134 | 1098 | 3.76034682932256 | 8.79108413326433 | 0.449768098636046 | weekly | |||||||||
4321 | 4321 | United States | Illinois | IL | 2021-04-11 | 2021-04-17 | 7 | 2021 | 15 | 12671821 | 2108 | 168 | 2038.71929824607 | 69.2807017539326 | 1940 | 1.32577630318484 | 0.546730432460596 | 0.0339824623299223 | weekly | |||||||||
4467 | 4467 | United States | Indiana | IN | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 6732219 | 1415 | 168 | 1363.9097744376 | 51.0902255624046 | 1247 | 2.49546249163909 | 0.758891318930721 | 0.0374586549051394 | weekly | |||||||||
3247 | 3247 | United States | Connecticut | CT | 2021-01-31 | 2021-02-06 | 7 | 2021 | 5 | 3565287 | 786 | 168 | 666.328947369082 | 119.671052630918 | 618 | 4.71210312101102 | 3.35656155117155 | 0.179597559288733 | weekly | |||||||||
8407 | 8407 | United States | South Carolina | SC | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 5148714 | 1281 | 168 | 1058.13784461248 | 222.862155387519 | 1113 | 3.26295070963351 | 4.32850135757238 | 0.210617318454513 | weekly | |||||||||
2629 | 2629 | United States | Arizona | AZ | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 7278717 | 1531 | 168 | 1183.69924812832 | 347.300751871679 | 1363 | 2.30809907845023 | 4.77145562702437 | 0.293402865990525 | weekly | |||||||||
5515 | 5515 | United States | Massachusetts | MA | 2020-11-08 | 2020-11-14 | 7 | 2020 | 46 | 6949503 | 1234 | 168 | 1149.125313284 | 84.8746867159962 | 1066 | 2.41743906003062 | 1.22130585044709 | 0.0738602533029569 | weekly | |||||||||
1847 | 1847 | Guatemala | Guatemala | 0 | 2020-08-10 | 2020-08-16 | 7 | 2020 | 33 | 17843914 | 2225 | 168 | 1584.89353932583 | 640.106460674173 | 2057 | 0.941497476394473 | 3.58725367469364 | 0.403879784219739 | weekly | |||||||||
13901 | 13901 | Guatemala | Guatemala | 0 | 2020-08-10 | 2020-08-16 | 7 | 2020 | 33 | 17843914 | 2225 | 168 | 1584.89353932583 | 640.106460674173 | 2057 | 0.941497476394473 | 3.58725367469364 | 0.403879784219736 | weekly | |||||||||
2307 | 2307 | United States | Alabama | AL | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 4903185 | 1333 | 168 | 941.358395981949 | 391.641604018051 | 1165 | 3.42634430477333 | 7.98749392523535 | 0.416038785748038 | weekly | |||||||||
13590 | 13590 | Germany | Germany | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 83369840 | 17262 | 168 | 16802.8342696626 | 459.165730337416 | 17094 | 0.201511721744938 | 0.550757600515265 | 0.0273266832826187 | weekly | |||||||||
23333 | 23333 | Germany | Germany | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 83369840 | 17262 | 168 | 16802.8342696626 | 459.165730337416 | 17094 | 0.201511721744938 | 0.550757600515265 | 0.0273266832826196 | weekly | |||||||||
16548 | 16548 | Romania | Romania | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 19659270 | 5092 | 168 | 4876.22837078654 | 215.771629213459 | 4924 | 0.854558689106971 | 1.09755667028053 | 0.044249697267287 | weekly | |||||||||
23479 | 23479 | Romania | Romania | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 19659270 | 5092 | 168 | 4876.22837078654 | 215.771629213459 | 4924 | 0.854558689106971 | 1.09755667028053 | 0.0442496972672868 | 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);