economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
18 rows where covid_deaths_per_7_days = "0.233333333333333" and month = 6 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, start_date, population, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_per_100k, excess_deaths_pct_change, total_deaths_per_7_days, expected_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)
cadence 1
- monthly 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17954 | 17954 | Kosovo | Kosovo | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 1782115 | 640 | 1 | 795.127411115231 | -155.127411115231 | 639 | 0.0561131015675195 | -8.70468017581533 | -0.195097551595728 | monthly | 6 | 149.333333333333 | 0.233333333333333 | 185.529729260221 | -36.1963959268873 | 149.1 | 0.0130930570324212 | -2.03109204102358 | ||
18270 | 18270 | Monaco | Monaco | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 36491 | 39 | 1 | 32.7622982031772 | 6.23770179682282 | 38 | 2.74040174289551 | 17.0938088756757 | 0.190392681189194 | monthly | 6 | 9.1 | 0.233333333333333 | 7.64453624740801 | 1.45546375259199 | 8.86666666666667 | 0.639427073342285 | 3.98855540432433 | ||
22180 | 22180 | Kosovo | Kosovo | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 1782115 | 640 | 1 | 795.127411115231 | -155.127411115231 | 639 | 0.0561131015675195 | -8.70468017581531 | -0.195097551595728 | monthly | 6 | 149.333333333333 | 0.233333333333333 | 185.529729260221 | -36.1963959268873 | 149.1 | 0.0130930570324212 | -2.03109204102358 | ||
22467 | 22467 | Monaco | Monaco | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 36491 | 39 | 1 | 32.7622982031772 | 6.23770179682282 | 38 | 2.74040174289551 | 17.0938088756757 | 0.190392681189193 | monthly | 6 | 9.1 | 0.233333333333333 | 7.64453624740801 | 1.45546375259199 | 8.86666666666667 | 0.639427073342285 | 3.98855540432433 | ||
617 | 617 | Hong Kong | Hong Kong | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 7488863 | 4022 | 1 | 3875.24039644286 | 146.75960355714 | 4021 | 0.013353161888527 | 1.95970474499453 | 0.0378710966400568 | monthly | 6 | 938.466666666667 | 0.233333333333333 | 904.222759170001 | 34.2439074966659 | 938.233333333333 | 0.00311573777398963 | 0.457264440498723 | ||
18258 | 18258 | Monaco | Monaco | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 36491 | 27 | 1 | 33.9298385625418 | -6.92983856254185 | 26 | 2.74040174289551 | -18.9905416747742 | -0.204240245640081 | monthly | 6 | 6.3 | 0.233333333333333 | 7.91696233125976 | -1.61696233125976 | 6.06666666666667 | 0.639427073342285 | -4.43112639078064 | ||
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 | ||
21987 | 21987 | Hong Kong | Hong Kong | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 7488863 | 4022 | 1 | 3875.24039644286 | 146.75960355714 | 4021 | 0.013353161888527 | 1.95970474499453 | 0.0378710966400568 | monthly | 6 | 938.466666666667 | 0.233333333333333 | 904.222759170001 | 34.2439074966659 | 938.233333333333 | 0.00311573777398963 | 0.457264440498723 | ||
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 | ||
22455 | 22455 | Monaco | Monaco | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 36491 | 27 | 1 | 33.9298385625418 | -6.92983856254185 | 26 | 2.74040174289551 | -18.9905416747742 | -0.20424024564008 | monthly | 6 | 6.3 | 0.233333333333333 | 7.91696233125976 | -1.61696233125976 | 6.06666666666667 | 0.639427073342285 | -4.43112639078064 | ||
1600 | 1600 | Jamaica | Jamaica | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 2827382 | 1503 | 1 | 1539.32423327507 | -36.3242332750715 | 1502 | 0.0353684079477057 | -1.28473030086035 | -0.0235975192814238 | monthly | 6 | 350.7 | 0.233333333333333 | 359.17565443085 | -8.47565443085001 | 350.466666666667 | 0.00825262852113133 | -0.299770403534083 | ||
10400 | 10400 | Thailand | Thailand | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 71697024 | 39479 | 1 | 38553.3378065576 | 925.662193442382 | 39478 | 0.001394758030682 | 1.29107477800248 | 0.0240099105837974 | monthly | 6 | 9211.76666666667 | 0.233333333333333 | 8995.77882153011 | 215.987845136556 | 9211.53333333333 | 0.000325443540492466 | 0.301250781533911 | ||
11106 | 11106 | Brunei | Brunei | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 449002 | 182 | 1 | 129.731952610484 | 52.2680473895158 | 181 | 0.222716157166338 | 11.640938657181 | 0.402892628514186 | monthly | 6 | 42.4666666666667 | 0.233333333333333 | 30.2707889424463 | 12.1958777242204 | 42.2333333333333 | 0.0519671033388122 | 2.7162190200089 | ||
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 | ||
21706 | 21706 | Brunei | Brunei | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 449002 | 182 | 1 | 129.731952610484 | 52.2680473895158 | 181 | 0.222716157166338 | 11.640938657181 | 0.402892628514188 | monthly | 6 | 42.4666666666667 | 0.233333333333333 | 30.2707889424463 | 12.1958777242204 | 42.2333333333333 | 0.0519671033388122 | 2.7162190200089 | ||
22042 | 22042 | Jamaica | Jamaica | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 2827382 | 1503 | 1 | 1539.32423327507 | -36.3242332750715 | 1502 | 0.0353684079477057 | -1.28473030086035 | -0.0235975192814228 | monthly | 6 | 350.7 | 0.233333333333333 | 359.17565443085 | -8.47565443085001 | 350.466666666667 | 0.00825262852113133 | -0.299770403534083 | ||
22984 | 22984 | Thailand | Thailand | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 71697024 | 39479 | 1 | 38553.3378065576 | 925.662193442382 | 39478 | 0.001394758030682 | 1.29107477800248 | 0.0240099105837976 | monthly | 6 | 9211.76666666667 | 0.233333333333333 | 8995.77882153011 | 215.987845136556 | 9211.53333333333 | 0.00032544354049246 | 0.301250781533911 |
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);