economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
19 rows where cadence = "weekly" and covid_deaths = 202 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, start_date, end_date, week, population, total_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_per_100k, start_date (date), end_date (date)
cadence 1
- weekly · 19 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
117 | 117 | Finland | Finland | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 5540745 | 1232 | 202 | 1107.42022471906 | 124.579775280936 | 1030 | 3.64571912260896 | 2.24843004471304 | 0.112495485002127 | weekly | |||||||||
13385 | 13385 | Finland | Finland | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 5540745 | 1232 | 202 | 1107.42022471906 | 124.579775280936 | 1030 | 3.64571912260896 | 2.24843004471305 | 0.112495485002132 | weekly | |||||||||
4368 | 4368 | United States | Illinois | IL | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 12671821 | 2185 | 202 | 2074.070175439 | 110.929824560999 | 1983 | 1.59408817406748 | 0.875405551901336 | 0.0534841230902516 | weekly | |||||||||
4519 | 4519 | United States | Indiana | IN | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 6732219 | 1476 | 202 | 1367.97368421228 | 108.026315787723 | 1274 | 3.00049656732795 | 1.6046167807037 | 0.0789681241930671 | weekly | |||||||||
8001 | 8001 | United States | Oregon | OR | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 4217737 | 875 | 202 | 706.082706767845 | 168.917293232155 | 673 | 4.78929814732403 | 4.00492712637499 | 0.239231596543963 | weekly | |||||||||
2044 | 2044 | Colombia | Colombia | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 51874028 | 5041 | 202 | 4768.34382022451 | 272.656179775495 | 4839 | 0.389404886776866 | 0.525612122844007 | 0.0571804781817637 | weekly | |||||||||
12309 | 12309 | Colombia | Colombia | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 51874028 | 5041 | 202 | 4768.34382022451 | 272.656179775495 | 4839 | 0.389404886776866 | 0.525612122844008 | 0.0571804781817626 | weekly | |||||||||
7691 | 7691 | United States | Ohio | OH | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 11689100 | 3109 | 202 | 2251.0588972453 | 857.941102754699 | 2907 | 1.72810567109529 | 7.33966774819874 | 0.381127790038986 | weekly | |||||||||
10901 | 10901 | Italy | Italy | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 59037472 | 12871 | 202 | 10994.2494382024 | 1876.75056179763 | 12669 | 0.342155571973 | 3.17891416793326 | 0.170702927229973 | weekly | |||||||||
14674 | 14674 | Italy | Italy | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 59037472 | 12871 | 202 | 10994.2494382024 | 1876.75056179763 | 12669 | 0.342155571973 | 3.17891416793326 | 0.17070292722997 | weekly | |||||||||
12001 | 12001 | Canada | Canada | 0 | 2021-06-06 | 2021-06-12 | 7 | 2021 | 23 | 38454328 | 5355 | 202 | 5348.17614424422 | 6.82385575578064 | 5153 | 0.525298478756409 | 0.0177453517216076 | 0.00127592202869442 | weekly | |||||||||
5376 | 5376 | United States | Maryland | MD | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 6045680 | 1295 | 202 | 1047.96804511367 | 247.031954886331 | 1093 | 3.34122877823504 | 4.08609047925677 | 0.235724701757997 | weekly | |||||||||
24895 | 24895 | Turkey | Istanbul | 0 | 2020-10-07 | 2020-10-14 | 7 | 2020 | 41 | 15519267 | 1511 | 202 | 1357.83333333349 | 153.166666666515 | 1309 | 1.30160786588696 | 0.986945238241696 | 0.112802258499937 | weekly | |||||||||
24891 | 24891 | Turkey | Istanbul | 0 | 2020-09-09 | 2020-09-16 | 7 | 2020 | 37 | 15519267 | 1406 | 202 | 1322.16666666682 | 83.8333333331802 | 1204 | 1.30160786588696 | 0.540188743019759 | 0.0634060254631317 | weekly | |||||||||
5957 | 5957 | United States | Mississippi | MS | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 2976149 | 915 | 202 | 593.290726817814 | 321.709273182186 | 713 | 6.78729458773737 | 10.8095822212593 | 0.542245578163193 | weekly | |||||||||
1170 | 1170 | Ecuador | Ecuador | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 18001002 | 2568 | 202 | 1391.09438202238 | 1176.90561797762 | 2366 | 1.12215975532918 | 6.53800059562031 | 0.846028589567471 | weekly | |||||||||
12994 | 12994 | Ecuador | Ecuador | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 18001002 | 2568 | 202 | 1391.09438202238 | 1176.90561797762 | 2366 | 1.12215975532918 | 6.53800059562029 | 0.846028589567466 | weekly | |||||||||
10444 | 10444 | Mexico | Mexico | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 127504120 | 14135 | 202 | 14005.6129213473 | 129.387078652664 | 13933 | 0.158426253206563 | 0.101476782595468 | 0.00923823037087179 | weekly | |||||||||
15352 | 15352 | Mexico | Mexico | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 127504120 | 14135 | 202 | 14005.6129213473 | 129.387078652664 | 13933 | 0.158426253206563 | 0.101476782595467 | 0.00923823037087423 | 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);