economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
32 rows where cadence = "weekly", country = "New Zealand" and covid_deaths_per_100k = "0.0192853281658939" sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, year, total_deaths, expected_deaths, excess_deaths, excess_deaths_pct_change, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15886 | 15886 | New Zealand | New Zealand | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 5185289 | 681 | 1 | 627.390870786494 | 53.6091292135059 | 680 | 0.0192853281658939 | 1.03386964957027 | 0.0854477355500916 | weekly | |||||||||
20217 | 20217 | New Zealand | New Zealand | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 5185289 | 681 | 1 | 627.390870786494 | 53.6091292135059 | 680 | 0.0192853281658939 | 1.03386964957027 | 0.0854477355500913 | weekly | |||||||||
15883 | 15883 | New Zealand | New Zealand | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 5185289 | 634 | 1 | 642.390870786494 | -8.39087078649436 | 633 | 0.0192853281658939 | -0.161820696715156 | -0.0130619396508871 | weekly | |||||||||
20214 | 20214 | New Zealand | New Zealand | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 5185289 | 634 | 1 | 642.390870786494 | -8.39087078649436 | 633 | 0.0192853281658939 | -0.161820696715156 | -0.0130619396508876 | weekly | |||||||||
15880 | 15880 | New Zealand | New Zealand | 0 | 2021-12-27 | 2022-01-02 | 7 | 2021 | 52 | 5185289 | 622 | 1 | 636.169662921322 | -14.169662921322 | 621 | 0.0192853281658939 | -0.273266599437794 | -0.0222734024383593 | weekly | |||||||||
20211 | 20211 | New Zealand | New Zealand | 0 | 2021-12-27 | 2022-01-02 | 7 | 2021 | 52 | 5185289 | 622 | 1 | 636.169662921322 | -14.169662921322 | 621 | 0.0192853281658939 | -0.273266599437794 | -0.0222734024383593 | weekly | |||||||||
15878 | 15878 | New Zealand | New Zealand | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 5185289 | 604 | 1 | 651.169662921322 | -47.169662921322 | 603 | 0.0192853281658939 | -0.909682428912294 | -0.0724383607026565 | weekly | |||||||||
20209 | 20209 | New Zealand | New Zealand | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 5185289 | 604 | 1 | 651.169662921322 | -47.169662921322 | 603 | 0.0192853281658939 | -0.909682428912294 | -0.0724383607026565 | weekly | |||||||||
15877 | 15877 | New Zealand | New Zealand | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 5185289 | 665 | 1 | 626.569662921322 | 38.4303370786781 | 664 | 0.0192853281658939 | 0.741141662088229 | 0.0613345001408145 | weekly | |||||||||
20208 | 20208 | New Zealand | New Zealand | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 5185289 | 665 | 1 | 626.569662921322 | 38.4303370786781 | 664 | 0.0192853281658939 | 0.741141662088229 | 0.0613345001408148 | weekly | |||||||||
15876 | 15876 | New Zealand | New Zealand | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 5185289 | 633 | 1 | 638.969662921322 | -5.96966292132197 | 632 | 0.0192853281658939 | -0.115126908477463 | -0.00934263904491039 | weekly | |||||||||
20207 | 20207 | New Zealand | New Zealand | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 5185289 | 633 | 1 | 638.969662921322 | -5.96966292132197 | 632 | 0.0192853281658939 | -0.115126908477463 | -0.00934263904491039 | weekly | |||||||||
15871 | 15871 | New Zealand | New Zealand | 0 | 2021-10-25 | 2021-10-31 | 7 | 2021 | 43 | 5185289 | 638 | 1 | 664.969662921322 | -26.969662921322 | 637 | 0.0192853281658939 | -0.520118799961237 | -0.0405577343225551 | weekly | |||||||||
20202 | 20202 | New Zealand | New Zealand | 0 | 2021-10-25 | 2021-10-31 | 7 | 2021 | 43 | 5185289 | 638 | 1 | 664.969662921322 | -26.969662921322 | 637 | 0.0192853281658939 | -0.520118799961236 | -0.0405577343225551 | weekly | |||||||||
15867 | 15867 | New Zealand | New Zealand | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 5185289 | 647 | 1 | 697.569662921322 | -50.5696629213221 | 646 | 0.0192853281658939 | -0.975252544676335 | -0.0724940684913725 | weekly | |||||||||
20198 | 20198 | New Zealand | New Zealand | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 5185289 | 647 | 1 | 697.569662921322 | -50.5696629213221 | 646 | 0.0192853281658939 | -0.975252544676335 | -0.0724940684913727 | weekly | |||||||||
15862 | 15862 | New Zealand | New Zealand | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 5185289 | 705 | 1 | 736.969662921322 | -31.9696629213224 | 704 | 0.0192853281658939 | -0.616545440790714 | -0.0433798900141905 | weekly | |||||||||
20193 | 20193 | New Zealand | New Zealand | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 5185289 | 705 | 1 | 736.969662921322 | -31.9696629213224 | 704 | 0.0192853281658939 | -0.616545440790714 | -0.0433798900141911 | weekly | |||||||||
15833 | 15833 | New Zealand | New Zealand | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 5185289 | 642 | 1 | 624.248455056151 | 17.7515449438492 | 641 | 0.0192853281658939 | 0.342344369693747 | 0.0284366662024855 | weekly | |||||||||
20164 | 20164 | New Zealand | New Zealand | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 5185289 | 642 | 1 | 624.248455056151 | 17.7515449438492 | 641 | 0.0192853281658939 | 0.342344369693748 | 0.0284366662024857 | weekly | |||||||||
15829 | 15829 | New Zealand | New Zealand | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 5185289 | 669 | 1 | 617.081788389356 | 51.9182116106444 | 668 | 0.0192853281658939 | 1.0012597486976 | 0.0841350572768573 | weekly | |||||||||
20160 | 20160 | New Zealand | New Zealand | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 5185289 | 669 | 1 | 617.081788389356 | 51.9182116106444 | 668 | 0.0192853281658939 | 1.0012597486976 | 0.084135057276858 | weekly | |||||||||
15812 | 15812 | New Zealand | New Zealand | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 5185289 | 623 | 1 | 721.127247190978 | -98.1272471909781 | 622 | 0.0192853281658939 | -1.89241616409381 | -0.136074801740213 | weekly | |||||||||
20143 | 20143 | New Zealand | New Zealand | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 5185289 | 623 | 1 | 721.127247190978 | -98.1272471909781 | 622 | 0.0192853281658939 | -1.89241616409381 | -0.136074801740213 | weekly | |||||||||
15796 | 15796 | New Zealand | New Zealand | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 5185289 | 608 | 1 | 674.327247190978 | -66.3272471909784 | 607 | 0.0192853281658939 | -1.27914272841839 | -0.0983606215932623 | weekly | |||||||||
20127 | 20127 | New Zealand | New Zealand | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 5185289 | 608 | 1 | 674.327247190978 | -66.3272471909784 | 607 | 0.0192853281658939 | -1.27914272841838 | -0.0983606215932628 | weekly | |||||||||
15794 | 15794 | New Zealand | New Zealand | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 5185289 | 629 | 1 | 669.527247190978 | -40.5272471909784 | 628 | 0.0192853281658939 | -0.781581261738322 | -0.0605311394883647 | weekly | |||||||||
20125 | 20125 | New Zealand | New Zealand | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 5185289 | 629 | 1 | 669.527247190978 | -40.5272471909784 | 628 | 0.0192853281658939 | -0.781581261738322 | -0.0605311394883654 | weekly | |||||||||
15793 | 15793 | New Zealand | New Zealand | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 5185289 | 561 | 1 | 648.927247190979 | -87.9272471909785 | 560 | 0.0192853281658939 | -1.6957058168017 | -0.135496309596478 | weekly | |||||||||
20124 | 20124 | New Zealand | New Zealand | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 5185289 | 561 | 1 | 648.927247190979 | -87.9272471909785 | 560 | 0.0192853281658939 | -1.6957058168017 | -0.135496309596477 | weekly | |||||||||
15788 | 15788 | New Zealand | New Zealand | 0 | 2020-03-23 | 2020-03-29 | 7 | 2020 | 13 | 5185289 | 613 | 1 | 631.727247190978 | -18.7272471909782 | 612 | 0.0192853281658939 | -0.36116110772183 | -0.0296445139484645 | weekly | |||||||||
20119 | 20119 | New Zealand | New Zealand | 0 | 2020-03-23 | 2020-03-29 | 7 | 2020 | 13 | 5185289 | 613 | 1 | 631.727247190978 | -18.7272471909782 | 612 | 0.0192853281658939 | -0.361161107721831 | -0.0296445139484648 | 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);