economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
414 rows where country = "New Zealand" sorted by week descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: year, 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 | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9622 | 9622 | New Zealand | New Zealand | 0 | 2015-12-28 | 2016-01-03 | 7 | 2015 | 53 | 5185289 | 575 | 0 | TBC | weekly | |
9883 | 9883 | New Zealand | New Zealand | 0 | 2020-12-28 | 2021-01-03 | 7 | 2020 | 53 | 5185289 | 675 | 0 | TBC | weekly | |
9621 | 9621 | New Zealand | New Zealand | 0 | 2015-12-21 | 2015-12-27 | 7 | 2015 | 52 | 5185289 | 567 | 0 | TBC | weekly | |
9674 | 9674 | New Zealand | New Zealand | 0 | 2016-12-26 | 2017-01-01 | 7 | 2016 | 52 | 5185289 | 602 | 0 | TBC | weekly | |
9726 | 9726 | New Zealand | New Zealand | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 5185289 | 625 | 0 | TBC | weekly | |
9778 | 9778 | New Zealand | New Zealand | 0 | 2018-12-24 | 2018-12-30 | 7 | 2018 | 52 | 5185289 | 569 | 0 | TBC | weekly | |
9830 | 9830 | New Zealand | New Zealand | 0 | 2019-12-23 | 2019-12-29 | 7 | 2019 | 52 | 5185289 | 565 | 0 | TBC | weekly | |
9882 | 9882 | New Zealand | New Zealand | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 5185289 | 625 | 0 | TBC | weekly | |
9935 | 9935 | New Zealand | New Zealand | 0 | 2021-12-27 | 2022-01-02 | 7 | 2021 | 52 | 5185289 | 622 | 1 | TBC | weekly | |
9620 | 9620 | New Zealand | New Zealand | 0 | 2015-12-14 | 2015-12-20 | 7 | 2015 | 51 | 5185289 | 537 | 0 | TBC | weekly | |
9673 | 9673 | New Zealand | New Zealand | 0 | 2016-12-19 | 2016-12-25 | 7 | 2016 | 51 | 5185289 | 548 | 0 | TBC | weekly | |
9725 | 9725 | New Zealand | New Zealand | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 5185289 | 617 | 0 | TBC | weekly | |
9777 | 9777 | New Zealand | New Zealand | 0 | 2018-12-17 | 2018-12-23 | 7 | 2018 | 51 | 5185289 | 614 | 0 | TBC | weekly | |
9829 | 9829 | New Zealand | New Zealand | 0 | 2019-12-16 | 2019-12-22 | 7 | 2019 | 51 | 5185289 | 596 | 0 | TBC | weekly | |
9881 | 9881 | New Zealand | New Zealand | 0 | 2020-12-14 | 2020-12-20 | 7 | 2020 | 51 | 5185289 | 670 | 0 | TBC | weekly | |
9934 | 9934 | New Zealand | New Zealand | 0 | 2021-12-20 | 2021-12-26 | 7 | 2021 | 51 | 5185289 | 704 | 4 | TBC | weekly | |
9619 | 9619 | New Zealand | New Zealand | 0 | 2015-12-07 | 2015-12-13 | 7 | 2015 | 50 | 5185289 | 575 | 0 | TBC | weekly | |
9672 | 9672 | New Zealand | New Zealand | 0 | 2016-12-12 | 2016-12-18 | 7 | 2016 | 50 | 5185289 | 606 | 0 | TBC | weekly | |
9724 | 9724 | New Zealand | New Zealand | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 5185289 | 596 | 0 | TBC | weekly | |
9776 | 9776 | New Zealand | New Zealand | 0 | 2018-12-10 | 2018-12-16 | 7 | 2018 | 50 | 5185289 | 588 | 0 | TBC | weekly | |
9828 | 9828 | New Zealand | New Zealand | 0 | 2019-12-09 | 2019-12-15 | 7 | 2019 | 50 | 5185289 | 638 | 0 | TBC | weekly | |
9880 | 9880 | New Zealand | New Zealand | 0 | 2020-12-07 | 2020-12-13 | 7 | 2020 | 50 | 5185289 | 639 | 0 | TBC | weekly | |
9933 | 9933 | New Zealand | New Zealand | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 5185289 | 604 | 1 | TBC | weekly | |
9618 | 9618 | New Zealand | New Zealand | 0 | 2015-11-30 | 2015-12-06 | 7 | 2015 | 49 | 5185289 | 603 | 0 | TBC | weekly | |
9671 | 9671 | New Zealand | New Zealand | 0 | 2016-12-05 | 2016-12-11 | 7 | 2016 | 49 | 5185289 | 575 | 0 | TBC | weekly | |
9723 | 9723 | New Zealand | New Zealand | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 5185289 | 550 | 0 | TBC | weekly | |
9775 | 9775 | New Zealand | New Zealand | 0 | 2018-12-03 | 2018-12-09 | 7 | 2018 | 49 | 5185289 | 581 | 0 | TBC | weekly | |
9827 | 9827 | New Zealand | New Zealand | 0 | 2019-12-02 | 2019-12-08 | 7 | 2019 | 49 | 5185289 | 571 | 0 | TBC | weekly | |
9879 | 9879 | New Zealand | New Zealand | 0 | 2020-11-30 | 2020-12-06 | 7 | 2020 | 49 | 5185289 | 643 | 0 | TBC | weekly | |
9932 | 9932 | New Zealand | New Zealand | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 5185289 | 665 | 1 | TBC | weekly | |
9617 | 9617 | New Zealand | New Zealand | 0 | 2015-11-23 | 2015-11-29 | 7 | 2015 | 48 | 5185289 | 546 | 0 | TBC | weekly | |
9670 | 9670 | New Zealand | New Zealand | 0 | 2016-11-28 | 2016-12-04 | 7 | 2016 | 48 | 5185289 | 596 | 0 | TBC | weekly | |
9722 | 9722 | New Zealand | New Zealand | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 5185289 | 586 | 0 | TBC | weekly | |
9774 | 9774 | New Zealand | New Zealand | 0 | 2018-11-26 | 2018-12-02 | 7 | 2018 | 48 | 5185289 | 574 | 0 | TBC | weekly | |
9826 | 9826 | New Zealand | New Zealand | 0 | 2019-11-25 | 2019-12-01 | 7 | 2019 | 48 | 5185289 | 640 | 0 | TBC | weekly | |
9878 | 9878 | New Zealand | New Zealand | 0 | 2020-11-23 | 2020-11-29 | 7 | 2020 | 48 | 5185289 | 650 | 0 | TBC | weekly | |
9931 | 9931 | New Zealand | New Zealand | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 5185289 | 633 | 1 | TBC | weekly | |
9983 | 9983 | New Zealand | New Zealand | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 5185289 | 599 | 23 | TBC | weekly | |
9616 | 9616 | New Zealand | New Zealand | 0 | 2015-11-16 | 2015-11-22 | 7 | 2015 | 47 | 5185289 | 613 | 0 | TBC | weekly | |
9669 | 9669 | New Zealand | New Zealand | 0 | 2016-11-21 | 2016-11-27 | 7 | 2016 | 47 | 5185289 | 619 | 0 | TBC | weekly | |
9721 | 9721 | New Zealand | New Zealand | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 5185289 | 626 | 0 | TBC | weekly | |
9773 | 9773 | New Zealand | New Zealand | 0 | 2018-11-19 | 2018-11-25 | 7 | 2018 | 47 | 5185289 | 609 | 0 | TBC | weekly | |
9825 | 9825 | New Zealand | New Zealand | 0 | 2019-11-18 | 2019-11-24 | 7 | 2019 | 47 | 5185289 | 585 | 0 | TBC | weekly | |
9877 | 9877 | New Zealand | New Zealand | 0 | 2020-11-16 | 2020-11-22 | 7 | 2020 | 47 | 5185289 | 612 | 0 | TBC | weekly | |
9930 | 9930 | New Zealand | New Zealand | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 5185289 | 635 | 0 | TBC | weekly | |
9982 | 9982 | New Zealand | New Zealand | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 5185289 | 713 | 30 | TBC | weekly | |
9615 | 9615 | New Zealand | New Zealand | 0 | 2015-11-09 | 2015-11-15 | 7 | 2015 | 46 | 5185289 | 545 | 0 | TBC | weekly | |
9668 | 9668 | New Zealand | New Zealand | 0 | 2016-11-14 | 2016-11-20 | 7 | 2016 | 46 | 5185289 | 582 | 0 | TBC | weekly | |
9720 | 9720 | New Zealand | New Zealand | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 5185289 | 589 | 0 | TBC | weekly | |
9772 | 9772 | New Zealand | New Zealand | 0 | 2018-11-12 | 2018-11-18 | 7 | 2018 | 46 | 5185289 | 603 | 0 | TBC | weekly | |
9824 | 9824 | New Zealand | New Zealand | 0 | 2019-11-11 | 2019-11-17 | 7 | 2019 | 46 | 5185289 | 620 | 0 | TBC | weekly | |
9876 | 9876 | New Zealand | New Zealand | 0 | 2020-11-09 | 2020-11-15 | 7 | 2020 | 46 | 5185289 | 586 | 0 | TBC | weekly | |
9929 | 9929 | New Zealand | New Zealand | 0 | 2021-11-15 | 2021-11-21 | 7 | 2021 | 46 | 5185289 | 667 | 5 | TBC | weekly | |
9981 | 9981 | New Zealand | New Zealand | 0 | 2022-11-14 | 2022-11-20 | 7 | 2022 | 46 | 5185289 | 656 | 28 | TBC | weekly | |
9614 | 9614 | New Zealand | New Zealand | 0 | 2015-11-02 | 2015-11-08 | 7 | 2015 | 45 | 5185289 | 624 | 0 | TBC | weekly | |
9667 | 9667 | New Zealand | New Zealand | 0 | 2016-11-07 | 2016-11-13 | 7 | 2016 | 45 | 5185289 | 594 | 0 | TBC | weekly | |
9719 | 9719 | New Zealand | New Zealand | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 5185289 | 591 | 0 | TBC | weekly | |
9771 | 9771 | New Zealand | New Zealand | 0 | 2018-11-05 | 2018-11-11 | 7 | 2018 | 45 | 5185289 | 636 | 0 | TBC | weekly | |
9823 | 9823 | New Zealand | New Zealand | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 5185289 | 611 | 0 | TBC | weekly | |
9875 | 9875 | New Zealand | New Zealand | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 5185289 | 631 | 0 | TBC | weekly | |
9928 | 9928 | New Zealand | New Zealand | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 5185289 | 662 | 5 | TBC | weekly | |
9980 | 9980 | New Zealand | New Zealand | 0 | 2022-11-07 | 2022-11-13 | 7 | 2022 | 45 | 5185289 | 663 | 35 | TBC | weekly | |
9613 | 9613 | New Zealand | New Zealand | 0 | 2015-10-26 | 2015-11-01 | 7 | 2015 | 44 | 5185289 | 606 | 0 | TBC | weekly | |
9666 | 9666 | New Zealand | New Zealand | 0 | 2016-10-31 | 2016-11-06 | 7 | 2016 | 44 | 5185289 | 599 | 0 | TBC | weekly | |
9718 | 9718 | New Zealand | New Zealand | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 5185289 | 618 | 0 | TBC | weekly | |
9770 | 9770 | New Zealand | New Zealand | 0 | 2018-10-29 | 2018-11-04 | 7 | 2018 | 44 | 5185289 | 626 | 0 | TBC | weekly | |
9822 | 9822 | New Zealand | New Zealand | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 5185289 | 646 | 0 | TBC | weekly | |
9874 | 9874 | New Zealand | New Zealand | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 5185289 | 584 | 0 | TBC | weekly | |
9927 | 9927 | New Zealand | New Zealand | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 5185289 | 648 | 0 | TBC | weekly | |
9979 | 9979 | New Zealand | New Zealand | 0 | 2022-10-31 | 2022-11-06 | 7 | 2022 | 44 | 5185289 | 712 | 13 | TBC | weekly | |
9612 | 9612 | New Zealand | New Zealand | 0 | 2015-10-19 | 2015-10-25 | 7 | 2015 | 43 | 5185289 | 596 | 0 | TBC | weekly | |
9665 | 9665 | New Zealand | New Zealand | 0 | 2016-10-24 | 2016-10-30 | 7 | 2016 | 43 | 5185289 | 605 | 0 | TBC | weekly | |
9717 | 9717 | New Zealand | New Zealand | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 5185289 | 633 | 0 | TBC | weekly | |
9769 | 9769 | New Zealand | New Zealand | 0 | 2018-10-22 | 2018-10-28 | 7 | 2018 | 43 | 5185289 | 626 | 0 | TBC | weekly | |
9821 | 9821 | New Zealand | New Zealand | 0 | 2019-10-21 | 2019-10-27 | 7 | 2019 | 43 | 5185289 | 612 | 0 | TBC | weekly | |
9873 | 9873 | New Zealand | New Zealand | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 5185289 | 689 | 0 | TBC | weekly | |
9926 | 9926 | New Zealand | New Zealand | 0 | 2021-10-25 | 2021-10-31 | 7 | 2021 | 43 | 5185289 | 638 | 1 | TBC | weekly | |
9978 | 9978 | New Zealand | New Zealand | 0 | 2022-10-24 | 2022-10-30 | 7 | 2022 | 43 | 5185289 | 708 | 41 | TBC | weekly | |
9611 | 9611 | New Zealand | New Zealand | 0 | 2015-10-12 | 2015-10-18 | 7 | 2015 | 42 | 5185289 | 596 | 0 | TBC | weekly | |
9664 | 9664 | New Zealand | New Zealand | 0 | 2016-10-17 | 2016-10-23 | 7 | 2016 | 42 | 5185289 | 594 | 0 | TBC | weekly | |
9716 | 9716 | New Zealand | New Zealand | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 5185289 | 624 | 0 | TBC | weekly | |
9768 | 9768 | New Zealand | New Zealand | 0 | 2018-10-15 | 2018-10-21 | 7 | 2018 | 42 | 5185289 | 647 | 0 | TBC | weekly | |
9820 | 9820 | New Zealand | New Zealand | 0 | 2019-10-14 | 2019-10-20 | 7 | 2019 | 42 | 5185289 | 609 | 0 | TBC | weekly | |
9872 | 9872 | New Zealand | New Zealand | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 5185289 | 615 | 0 | TBC | weekly | |
9925 | 9925 | New Zealand | New Zealand | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 5185289 | 678 | 0 | TBC | weekly | |
9977 | 9977 | New Zealand | New Zealand | 0 | 2022-10-17 | 2022-10-23 | 7 | 2022 | 42 | 5185289 | 746 | 0 | TBC | weekly | |
9610 | 9610 | New Zealand | New Zealand | 0 | 2015-10-05 | 2015-10-11 | 7 | 2015 | 41 | 5185289 | 638 | 0 | TBC | weekly | |
9663 | 9663 | New Zealand | New Zealand | 0 | 2016-10-10 | 2016-10-16 | 7 | 2016 | 41 | 5185289 | 631 | 0 | TBC | weekly | |
9715 | 9715 | New Zealand | New Zealand | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 5185289 | 635 | 0 | TBC | weekly | |
9767 | 9767 | New Zealand | New Zealand | 0 | 2018-10-08 | 2018-10-14 | 7 | 2018 | 41 | 5185289 | 666 | 0 | TBC | weekly | |
9819 | 9819 | New Zealand | New Zealand | 0 | 2019-10-07 | 2019-10-13 | 7 | 2019 | 41 | 5185289 | 713 | 0 | TBC | weekly | |
9871 | 9871 | New Zealand | New Zealand | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 5185289 | 609 | 0 | TBC | weekly | |
9924 | 9924 | New Zealand | New Zealand | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 5185289 | 650 | 0 | TBC | weekly | |
9976 | 9976 | New Zealand | New Zealand | 0 | 2022-10-10 | 2022-10-16 | 7 | 2022 | 41 | 5185289 | 698 | 10 | TBC | weekly | |
9609 | 9609 | New Zealand | New Zealand | 0 | 2015-09-28 | 2015-10-04 | 7 | 2015 | 40 | 5185289 | 595 | 0 | TBC | weekly | |
9662 | 9662 | New Zealand | New Zealand | 0 | 2016-10-03 | 2016-10-09 | 7 | 2016 | 40 | 5185289 | 643 | 0 | TBC | weekly | |
9714 | 9714 | New Zealand | New Zealand | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 5185289 | 637 | 0 | TBC | weekly | |
9766 | 9766 | New Zealand | New Zealand | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 5185289 | 652 | 0 | TBC | weekly | |
9818 | 9818 | New Zealand | New Zealand | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 5185289 | 688 | 0 | TBC | weekly | |
9870 | 9870 | New Zealand | New Zealand | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 5185289 | 651 | 0 | TBC | weekly |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [economist_historical_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] TEXT, [cadence] TEXT , [month] INTEGER); CREATE INDEX [idx_economist_historical_deaths_country] ON [economist_historical_deaths] ([country]); CREATE INDEX [idx_economist_historical_deaths_cadence] ON [economist_historical_deaths] ([cadence]); CREATE INDEX [idx_economist_historical_deaths_end_date] ON [economist_historical_deaths] ([end_date]);