economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
24 rows where country = "Andorra" sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, total_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_per_100k, excess_deaths_pct_change, 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, end_date (date)
start_date (date) 12 ✖
- 2020-01-01 2
- 2020-02-01 2
- 2020-03-01 2
- 2020-04-01 2
- 2020-05-01 2
- 2020-06-01 2
- 2020-07-01 2
- 2020-08-01 2
- 2020-09-01 2
- 2020-10-01 2
- 2020-11-01 2
- 2020-12-01 2
country 1
- Andorra · 24 ✖
cadence 1
- monthly 24
week 0 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20296 | 20296 | Andorra | Andorra | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 79843 | 41 | 8 | 31.7374283889796 | 9.26257161102035 | 33 | 10.019663589795 | 11.6009814398511 | 0.29185009880122 | monthly | 12 | 9.25806451612903 | 1.80645161290323 | 7.16651608783411 | 2.09154842829492 | 7.45161290322581 | 2.26250468156661 | 2.61957645415994 | ||
21360 | 21360 | Andorra | Andorra | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 79843 | 41 | 8 | 31.7374283889796 | 9.26257161102035 | 33 | 10.019663589795 | 11.6009814398511 | 0.291850098801222 | monthly | 12 | 9.25806451612903 | 1.80645161290323 | 7.16651608783411 | 2.09154842829492 | 7.45161290322581 | 2.26250468156661 | 2.61957645415994 | ||
20295 | 20295 | Andorra | Andorra | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 79843 | 19 | 1 | 26.6684790861093 | -7.66847908610934 | 18 | 1.25245794872437 | -9.60444758602425 | -0.287548422290928 | monthly | 11 | 4.43333333333333 | 0.233333333333333 | 6.22264512009218 | -1.78931178675885 | 4.2 | 0.292240188035687 | -2.24103777007233 | ||
21359 | 21359 | Andorra | Andorra | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 79843 | 19 | 1 | 26.6684790861093 | -7.66847908610934 | 18 | 1.25245794872437 | -9.60444758602425 | -0.287548422290927 | monthly | 11 | 4.43333333333333 | 0.233333333333333 | 6.22264512009218 | -1.78931178675885 | 4.2 | 0.292240188035687 | -2.24103777007233 | ||
20294 | 20294 | Andorra | Andorra | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 79843 | 51 | 22 | 27.9374283889796 | 23.0625716110204 | 29 | 27.5540748719362 | 28.8849011322475 | 0.825508034952772 | monthly | 10 | 11.5161290322581 | 4.96774193548387 | 6.30845157170508 | 5.20767746055298 | 6.54838709677419 | 6.22188787430817 | 6.52239702986233 | ||
21358 | 21358 | Andorra | Andorra | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 79843 | 51 | 22 | 27.9374283889796 | 23.0625716110204 | 29 | 27.5540748719362 | 28.8849011322475 | 0.825508034952774 | monthly | 10 | 11.5161290322581 | 4.96774193548387 | 6.30845157170508 | 5.20767746055298 | 6.54838709677419 | 6.22188787430817 | 6.52239702986233 | ||
20293 | 20293 | Andorra | Andorra | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 79843 | 27 | 0 | 25.6684790861093 | 1.33152091389066 | 27 | 0.0 | 1.66767395249509 | 0.0518737752020226 | monthly | 9 | 6.3 | 0.0 | 5.98931178675885 | 0.310688213241153 | 6.3 | 0.0 | 0.389123922248855 | ||
21357 | 21357 | Andorra | Andorra | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 79843 | 27 | 0 | 25.6684790861093 | 1.33152091389066 | 27 | 0.0 | 1.6676739524951 | 0.0518737752020244 | monthly | 9 | 6.3 | 0.0 | 5.98931178675885 | 0.310688213241153 | 6.3 | 0.0 | 0.389123922248855 | ||
20292 | 20292 | Andorra | Andorra | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 79843 | 19 | 1 | 25.7374283889796 | -6.73742838897964 | 18 | 1.25245794872437 | -8.43834573973879 | -0.26177550791611 | monthly | 8 | 4.29032258064516 | 0.225806451612903 | 5.81167737815669 | -1.52135479751153 | 4.06451612903226 | 0.282813085195826 | -1.90543290897328 | ||
21356 | 21356 | Andorra | Andorra | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 79843 | 19 | 1 | 25.7374283889796 | -6.73742838897964 | 18 | 1.25245794872437 | -8.43834573973879 | -0.261775507916108 | monthly | 8 | 4.29032258064516 | 0.225806451612903 | 5.81167737815669 | -1.52135479751153 | 4.06451612903226 | 0.282813085195826 | -1.90543290897328 | ||
20291 | 20291 | Andorra | Andorra | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 79843 | 29 | 0 | 27.9374283889796 | 1.06257161102036 | 29 | 0.0 | 1.33082626031131 | 0.038033980659419 | monthly | 7 | 6.54838709677419 | 0.0 | 6.30845157170508 | 0.239935525069113 | 6.54838709677419 | 0.0 | 0.300509155554166 | ||
21355 | 21355 | Andorra | Andorra | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 79843 | 29 | 0 | 27.9374283889796 | 1.06257161102036 | 29 | 0.0 | 1.33082626031131 | 0.0380339806594205 | monthly | 7 | 6.54838709677419 | 0.0 | 6.30845157170508 | 0.239935525069113 | 6.54838709677419 | 0.0 | 0.300509155554166 | ||
20290 | 20290 | Andorra | Andorra | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 79843 | 26 | 1 | 26.2684790861093 | -0.268479086109334 | 25 | 1.25245794872437 | -0.33625876546389 | -0.0102205797765925 | monthly | 6 | 6.06666666666667 | 0.233333333333333 | 6.12931178675885 | -0.0626451200921779 | 5.83333333333333 | 0.292240188035687 | -0.0784603786082411 | ||
21354 | 21354 | Andorra | Andorra | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 79843 | 26 | 1 | 26.2684790861093 | -0.268479086109334 | 25 | 1.25245794872437 | -0.33625876546389 | -0.0102205797765912 | monthly | 6 | 6.06666666666667 | 0.233333333333333 | 6.12931178675885 | -0.0626451200921779 | 5.83333333333333 | 0.292240188035687 | -0.0784603786082411 | ||
20289 | 20289 | Andorra | Andorra | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 79843 | 36 | 9 | 22.1374283889796 | 13.8625716110204 | 27 | 11.2721215385193 | 17.3622880039833 | 0.626205147564536 | monthly | 5 | 8.12903225806452 | 2.03225806451613 | 4.99877415235024 | 3.13025810571427 | 6.09677419354839 | 2.54531776676243 | 3.92051664606074 | ||
21353 | 21353 | Andorra | Andorra | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 79843 | 36 | 9 | 22.1374283889796 | 13.8625716110204 | 27 | 11.2721215385193 | 17.3622880039833 | 0.62620514756454 | monthly | 5 | 8.12903225806452 | 2.03225806451613 | 4.99877415235024 | 3.13025810571427 | 6.09677419354839 | 2.54531776676243 | 3.92051664606074 | ||
20288 | 20288 | Andorra | Andorra | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 79843 | 60 | 30 | 24.8684790861093 | 35.1315209138907 | 30 | 37.5737384617311 | 44.0007526193789 | 1.41269278238708 | monthly | 4 | 14.0 | 7.0 | 5.80264512009218 | 8.19735487990782 | 7.0 | 8.7672056410706 | 10.2668422778551 | ||
21352 | 21352 | Andorra | Andorra | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 79843 | 60 | 30 | 24.8684790861093 | 35.1315209138907 | 30 | 37.5737384617311 | 44.0007526193789 | 1.41269278238708 | monthly | 4 | 14.0 | 7.0 | 5.80264512009218 | 8.19735487990782 | 7.0 | 8.7672056410706 | 10.2668422778551 | ||
20287 | 20287 | Andorra | Andorra | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 79843 | 40 | 12 | 32.9374283889796 | 7.06257161102035 | 28 | 15.0294953846925 | 8.84557395265753 | 0.214423892709954 | monthly | 3 | 9.03225806451613 | 2.70967741935484 | 7.4374838297696 | 1.59477423474653 | 6.32258064516129 | 3.39375702234991 | 1.99738766672912 | ||
21351 | 21351 | Andorra | Andorra | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 79843 | 40 | 12 | 32.9374283889796 | 7.06257161102035 | 28 | 15.0294953846925 | 8.84557395265753 | 0.214423892709956 | monthly | 3 | 9.03225806451613 | 2.70967741935484 | 7.4374838297696 | 1.59477423474653 | 6.32258064516129 | 3.39375702234991 | 1.99738766672912 | ||
20286 | 20286 | Andorra | Andorra | 0 | 2020-02-01 | 2020-02-29 | 29 | 2020 | 79843 | 37 | 0 | 30.4936557717468 | 6.50634422825322 | 37 | 0.0 | 8.14892254581268 | 0.213367143544708 | monthly | 2 | 8.93103448275862 | 0.0 | 7.36053760007681 | 1.57049688268181 | 8.93103448275862 | 0.0 | 1.96698130416168 | ||
21350 | 21350 | Andorra | Andorra | 0 | 2020-02-01 | 2020-02-29 | 29 | 2020 | 79843 | 37 | 0 | 30.4936557717468 | 6.50634422825322 | 37 | 0.0 | 8.14892254581268 | 0.213367143544708 | monthly | 2 | 8.93103448275862 | 0.0 | 7.36053760007681 | 1.57049688268181 | 8.93103448275862 | 0.0 | 1.96698130416168 | ||
20285 | 20285 | Andorra | Andorra | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 79843 | 34 | 0 | 34.9478569908162 | -0.947856990816163 | 34 | 0.0 | -1.18715102240167 | -0.027122034723481 | monthly | 1 | 7.67741935483871 | 0.0 | 7.89145157857139 | -0.214032223732682 | 7.67741935483871 | 0.0 | -0.268066359897151 | ||
21349 | 21349 | Andorra | Andorra | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 79843 | 34 | 0 | 34.9478569908162 | -0.947856990816163 | 34 | 0.0 | -1.18715102240167 | -0.027122034723482 | monthly | 1 | 7.67741935483871 | 0.0 | 7.89145157857139 | -0.214032223732682 | 7.67741935483871 | 0.0 | -0.268066359897151 |
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);