economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
24 rows where cadence = "monthly", country = "Liechtenstein" and year = 2021 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, days, total_deaths, covid_deaths, expected_deaths, excess_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, start_date (date), end_date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21146 | 21146 | Liechtenstein | Liechtenstein | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 39355 | 25 | 8 | 22.9160420847777 | 2.08395791522229 | 17 | 20.3277855418625 | 5.2952811973632 | 0.0909388238820954 | monthly | 12 | 5.64516129032258 | 1.80645161290323 | 5.17459014817561 | 0.470571142146968 | 3.83870967741935 | 4.59014512235606 | 1.19570865746911 | ||
22290 | 22290 | Liechtenstein | Liechtenstein | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 39355 | 25 | 8 | 22.9160420847777 | 2.08395791522229 | 17 | 20.3277855418625 | 5.29528119736321 | 0.0909388238820961 | monthly | 12 | 5.64516129032258 | 1.80645161290323 | 5.17459014817561 | 0.470571142146968 | 3.83870967741935 | 4.59014512235606 | 1.19570865746911 | ||
21145 | 21145 | Liechtenstein | Liechtenstein | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 39355 | 25 | 0 | 23.0800407272042 | 1.91995927279577 | 25 | 0.0 | 4.87856504331283 | 0.0831869967427192 | monthly | 11 | 5.83333333333333 | 0.0 | 5.38534283634765 | 0.447990496985678 | 5.83333333333333 | 0.0 | 1.13833184343966 | ||
22289 | 22289 | Liechtenstein | Liechtenstein | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 39355 | 25 | 0 | 23.0800407272042 | 1.91995927279577 | 25 | 0.0 | 4.87856504331284 | 0.0831869967427208 | monthly | 11 | 5.83333333333333 | 0.0 | 5.38534283634765 | 0.447990496985678 | 5.83333333333333 | 0.0 | 1.13833184343966 | ||
21144 | 21144 | Liechtenstein | Liechtenstein | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 39355 | 20 | 3 | 23.5160420847777 | -3.51604208477771 | 17 | 7.62291957819845 | -8.93416868194056 | -0.149516745722006 | monthly | 10 | 4.51612903225806 | 0.67741935483871 | 5.31007401914335 | -0.793944986885288 | 3.83870967741935 | 1.72130442088352 | -2.01739292818013 | ||
22288 | 22288 | Liechtenstein | Liechtenstein | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 39355 | 20 | 3 | 23.5160420847777 | -3.51604208477771 | 17 | 7.62291957819845 | -8.93416868194057 | -0.149516745722006 | monthly | 10 | 4.51612903225806 | 0.67741935483871 | 5.31007401914335 | -0.793944986885288 | 3.83870967741935 | 1.72130442088352 | -2.01739292818013 | ||
21143 | 21143 | Liechtenstein | Liechtenstein | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 39355 | 18 | 0 | 21.8800407272042 | -3.88004072720424 | 18 | 0.0 | -9.85907947453751 | -0.177332427100103 | monthly | 9 | 4.2 | 0.0 | 5.10534283634765 | -0.905342836347655 | 4.2 | 0.0 | -2.30045187739208 | ||
22287 | 22287 | Liechtenstein | Liechtenstein | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 39355 | 18 | 0 | 21.8800407272042 | -3.88004072720424 | 18 | 0.0 | -9.85907947453752 | -0.177332427100102 | monthly | 9 | 4.2 | 0.0 | 5.10534283634765 | -0.905342836347655 | 4.2 | 0.0 | -2.30045187739208 | ||
21142 | 21142 | Liechtenstein | Liechtenstein | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 39355 | 20 | 0 | 23.7160420847777 | -3.71604208477771 | 20 | 0.0 | -9.44236332048714 | -0.156688964857373 | monthly | 8 | 4.51612903225806 | 0.0 | 5.35523530946593 | -0.83910627720787 | 4.51612903225806 | 0.0 | -2.13214655623903 | ||
22286 | 22286 | Liechtenstein | Liechtenstein | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 39355 | 20 | 0 | 23.7160420847777 | -3.71604208477771 | 20 | 0.0 | -9.44236332048713 | -0.156688964857372 | monthly | 8 | 4.51612903225806 | 0.0 | 5.35523530946593 | -0.83910627720787 | 4.51612903225806 | 0.0 | -2.13214655623903 | ||
21141 | 21141 | Liechtenstein | Liechtenstein | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 39355 | 26 | 0 | 22.7160420847777 | 3.28395791522229 | 26 | 0.0 | 8.34444902864259 | 0.14456558510353 | monthly | 7 | 5.87096774193548 | 0.0 | 5.12942885785303 | 0.741538884082453 | 5.87096774193548 | 0.0 | 1.88423042582252 | ||
22285 | 22285 | Liechtenstein | Liechtenstein | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 39355 | 26 | 0 | 22.7160420847777 | 3.28395791522229 | 26 | 0.0 | 8.34444902864259 | 0.14456558510353 | monthly | 7 | 5.87096774193548 | 0.0 | 5.12942885785303 | 0.741538884082453 | 5.87096774193548 | 0.0 | 1.88423042582252 | ||
21140 | 21140 | Liechtenstein | Liechtenstein | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 39355 | 11 | 1 | 20.4800407272042 | -9.48004072720423 | 10 | 2.54097319273282 | -24.0885293538413 | -0.462891693111314 | monthly | 6 | 2.56666666666667 | 0.233333333333333 | 4.77867616968099 | -2.21200950301432 | 2.33333333333333 | 0.59289374497099 | -5.62065684922963 | ||
22284 | 22284 | Liechtenstein | Liechtenstein | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 39355 | 11 | 1 | 20.4800407272042 | -9.48004072720423 | 10 | 2.54097319273282 | -24.0885293538413 | -0.462891693111313 | monthly | 6 | 2.56666666666667 | 0.233333333333333 | 4.77867616968099 | -2.21200950301432 | 2.33333333333333 | 0.59289374497099 | -5.62065684922963 | ||
21139 | 21139 | Liechtenstein | Liechtenstein | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 39355 | 24 | 1 | 19.5160420847777 | 4.4839579152223 | 23 | 2.54097319273282 | 11.393616859922 | 0.229757544882512 | monthly | 5 | 5.41935483870968 | 0.225806451612903 | 4.40684821269174 | 1.01250662601794 | 5.19354838709677 | 0.573768140294507 | 2.57275219417593 | ||
22283 | 22283 | Liechtenstein | Liechtenstein | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 39355 | 24 | 1 | 19.5160420847777 | 4.4839579152223 | 23 | 2.54097319273282 | 11.393616859922 | 0.229757544882512 | monthly | 5 | 5.41935483870968 | 0.225806451612903 | 4.40684821269174 | 1.01250662601794 | 5.19354838709677 | 0.573768140294507 | 2.57275219417593 | ||
21138 | 21138 | Liechtenstein | Liechtenstein | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 39355 | 29 | 0 | 21.2800407272042 | 7.71995927279577 | 29 | 0.0 | 19.6162095611632 | 0.362779346701467 | monthly | 4 | 6.76666666666667 | 0.0 | 4.96534283634765 | 1.80132383031901 | 6.76666666666667 | 0.0 | 4.57711556427141 | ||
22282 | 22282 | Liechtenstein | Liechtenstein | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 39355 | 29 | 0 | 21.2800407272042 | 7.71995927279577 | 29 | 0.0 | 19.6162095611632 | 0.362779346701469 | monthly | 4 | 6.76666666666667 | 0.0 | 4.96534283634765 | 1.80132383031901 | 6.76666666666667 | 0.0 | 4.57711556427141 | ||
21137 | 21137 | Liechtenstein | Liechtenstein | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 39355 | 16 | 1 | 28.5160420847777 | -12.5160420847777 | 15 | 2.54097319273282 | -31.8029274165359 | -0.438912316357499 | monthly | 3 | 3.61290322580645 | 0.225806451612903 | 6.43910627720787 | -2.82620305140142 | 3.38709677419355 | 0.573768140294507 | -7.18130619083069 | ||
22281 | 22281 | Liechtenstein | Liechtenstein | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 39355 | 16 | 1 | 28.5160420847777 | -12.5160420847777 | 15 | 2.54097319273282 | -31.8029274165359 | -0.438912316357499 | monthly | 3 | 3.61290322580645 | 0.225806451612903 | 6.43910627720787 | -2.82620305140142 | 3.38709677419355 | 0.573768140294507 | -7.18130619083069 | ||
21136 | 21136 | Liechtenstein | Liechtenstein | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 39355 | 23 | 2 | 22.4337573984811 | 0.566242601518855 | 21 | 5.08194638546563 | 1.4388072710427 | 0.0252406492350314 | monthly | 2 | 5.75 | 0.5 | 5.60843934962029 | 0.141560650379714 | 5.25 | 1.27048659636641 | 0.359701817760675 | ||
22280 | 22280 | Liechtenstein | Liechtenstein | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 39355 | 23 | 2 | 22.4337573984811 | 0.566242601518855 | 21 | 5.08194638546563 | 1.4388072710427 | 0.0252406492350337 | monthly | 2 | 5.75 | 0.5 | 5.60843934962029 | 0.141560650379714 | 5.25 | 1.27048659636641 | 0.359701817760675 | ||
21135 | 21135 | Liechtenstein | Liechtenstein | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 39355 | 31 | 9 | 24.9765368241804 | 6.02346317581958 | 22 | 22.8687587345953 | 15.3054584571708 | 0.241164866779614 | monthly | 1 | 7.0 | 2.03225806451613 | 5.63986315384719 | 1.36013684615281 | 4.96774193548387 | 5.16391326265056 | 3.45607126452245 | ||
22279 | 22279 | Liechtenstein | Liechtenstein | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 39355 | 31 | 9 | 24.9765368241804 | 6.02346317581958 | 22 | 22.8687587345953 | 15.3054584571708 | 0.241164866779614 | monthly | 1 | 7.0 | 2.03225806451613 | 5.63986315384719 | 1.36013684615281 | 4.96774193548387 | 5.16391326265056 | 3.45607126452245 |
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);