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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9570 | 9570 | New Zealand | New Zealand | 0 | 2014-12-29 | 2015-01-04 | 7 | 2015 | 1 | 5185289 | 564 | 0 | TBC | weekly | |
9623 | 9623 | New Zealand | New Zealand | 0 | 2016-01-04 | 2016-01-10 | 7 | 2016 | 1 | 5185289 | 564 | 0 | TBC | weekly | |
9675 | 9675 | New Zealand | New Zealand | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 5185289 | 528 | 0 | TBC | weekly | |
9727 | 9727 | New Zealand | New Zealand | 0 | 2018-01-01 | 2018-01-07 | 7 | 2018 | 1 | 5185289 | 582 | 0 | TBC | weekly | |
9779 | 9779 | New Zealand | New Zealand | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 5185289 | 609 | 0 | TBC | weekly | |
9831 | 9831 | New Zealand | New Zealand | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 5185289 | 590 | 0 | TBC | weekly | |
9884 | 9884 | New Zealand | New Zealand | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 5185289 | 669 | 1 | TBC | weekly | |
9936 | 9936 | New Zealand | New Zealand | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 5185289 | 677 | 2 | TBC | weekly | |
9571 | 9571 | New Zealand | New Zealand | 0 | 2015-01-05 | 2015-01-11 | 7 | 2015 | 2 | 5185289 | 566 | 0 | TBC | weekly | |
9624 | 9624 | New Zealand | New Zealand | 0 | 2016-01-11 | 2016-01-17 | 7 | 2016 | 2 | 5185289 | 558 | 0 | TBC | weekly | |
9676 | 9676 | New Zealand | New Zealand | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 5185289 | 601 | 0 | TBC | weekly | |
9728 | 9728 | New Zealand | New Zealand | 0 | 2018-01-08 | 2018-01-14 | 7 | 2018 | 2 | 5185289 | 611 | 0 | TBC | weekly | |
9780 | 9780 | New Zealand | New Zealand | 0 | 2019-01-07 | 2019-01-13 | 7 | 2019 | 2 | 5185289 | 604 | 0 | TBC | weekly | |
9832 | 9832 | New Zealand | New Zealand | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 5185289 | 581 | 0 | TBC | weekly | |
9885 | 9885 | New Zealand | New Zealand | 0 | 2021-01-11 | 2021-01-17 | 7 | 2021 | 2 | 5185289 | 631 | 0 | TBC | weekly | |
9937 | 9937 | New Zealand | New Zealand | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 5185289 | 609 | 0 | TBC | weekly | |
9572 | 9572 | New Zealand | New Zealand | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 5185289 | 595 | 0 | TBC | weekly | |
9625 | 9625 | New Zealand | New Zealand | 0 | 2016-01-18 | 2016-01-24 | 7 | 2016 | 3 | 5185289 | 519 | 0 | TBC | weekly | |
9677 | 9677 | New Zealand | New Zealand | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 5185289 | 557 | 0 | TBC | weekly | |
9729 | 9729 | New Zealand | New Zealand | 0 | 2018-01-15 | 2018-01-21 | 7 | 2018 | 3 | 5185289 | 576 | 0 | TBC | weekly | |
9781 | 9781 | New Zealand | New Zealand | 0 | 2019-01-14 | 2019-01-20 | 7 | 2019 | 3 | 5185289 | 625 | 0 | TBC | weekly | |
9833 | 9833 | New Zealand | New Zealand | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 5185289 | 641 | 0 | TBC | weekly | |
9886 | 9886 | New Zealand | New Zealand | 0 | 2021-01-18 | 2021-01-24 | 7 | 2021 | 3 | 5185289 | 659 | 0 | TBC | weekly | |
9938 | 9938 | New Zealand | New Zealand | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 5185289 | 634 | 1 | TBC | weekly | |
9573 | 9573 | New Zealand | New Zealand | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 5185289 | 531 | 0 | TBC | weekly | |
9626 | 9626 | New Zealand | New Zealand | 0 | 2016-01-25 | 2016-01-31 | 7 | 2016 | 4 | 5185289 | 541 | 0 | TBC | weekly | |
9678 | 9678 | New Zealand | New Zealand | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 5185289 | 608 | 0 | TBC | weekly | |
9730 | 9730 | New Zealand | New Zealand | 0 | 2018-01-22 | 2018-01-28 | 7 | 2018 | 4 | 5185289 | 653 | 0 | TBC | weekly | |
9782 | 9782 | New Zealand | New Zealand | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 5185289 | 589 | 0 | TBC | weekly | |
9834 | 9834 | New Zealand | New Zealand | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 5185289 | 610 | 0 | TBC | weekly | |
9887 | 9887 | New Zealand | New Zealand | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 5185289 | 603 | 0 | TBC | weekly | |
9939 | 9939 | New Zealand | New Zealand | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 5185289 | 647 | 0 | TBC | weekly | |
9574 | 9574 | New Zealand | New Zealand | 0 | 2015-01-26 | 2015-02-01 | 7 | 2015 | 5 | 5185289 | 587 | 0 | TBC | weekly | |
9627 | 9627 | New Zealand | New Zealand | 0 | 2016-02-01 | 2016-02-07 | 7 | 2016 | 5 | 5185289 | 552 | 0 | TBC | weekly | |
9679 | 9679 | New Zealand | New Zealand | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 5185289 | 591 | 0 | TBC | weekly | |
9731 | 9731 | New Zealand | New Zealand | 0 | 2018-01-29 | 2018-02-04 | 7 | 2018 | 5 | 5185289 | 591 | 0 | TBC | weekly | |
9783 | 9783 | New Zealand | New Zealand | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 5185289 | 544 | 0 | TBC | weekly | |
9835 | 9835 | New Zealand | New Zealand | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 5185289 | 615 | 0 | TBC | weekly | |
9888 | 9888 | New Zealand | New Zealand | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 5185289 | 642 | 1 | TBC | weekly | |
9940 | 9940 | New Zealand | New Zealand | 0 | 2022-01-31 | 2022-02-06 | 7 | 2022 | 5 | 5185289 | 660 | 0 | TBC | weekly | |
9575 | 9575 | New Zealand | New Zealand | 0 | 2015-02-02 | 2015-02-08 | 7 | 2015 | 6 | 5185289 | 567 | 0 | TBC | weekly | |
9628 | 9628 | New Zealand | New Zealand | 0 | 2016-02-08 | 2016-02-14 | 7 | 2016 | 6 | 5185289 | 523 | 0 | TBC | weekly | |
9680 | 9680 | New Zealand | New Zealand | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 5185289 | 564 | 0 | TBC | weekly | |
9732 | 9732 | New Zealand | New Zealand | 0 | 2018-02-05 | 2018-02-11 | 7 | 2018 | 6 | 5185289 | 624 | 0 | TBC | weekly | |
9784 | 9784 | New Zealand | New Zealand | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 5185289 | 557 | 0 | TBC | weekly | |
9836 | 9836 | New Zealand | New Zealand | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 5185289 | 588 | 0 | TBC | weekly | |
9889 | 9889 | New Zealand | New Zealand | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 5185289 | 647 | 0 | TBC | weekly | |
9941 | 9941 | New Zealand | New Zealand | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 5185289 | 681 | 1 | TBC | weekly | |
9576 | 9576 | New Zealand | New Zealand | 0 | 2015-02-09 | 2015-02-15 | 7 | 2015 | 7 | 5185289 | 577 | 0 | TBC | weekly | |
9629 | 9629 | New Zealand | New Zealand | 0 | 2016-02-15 | 2016-02-21 | 7 | 2016 | 7 | 5185289 | 517 | 0 | TBC | weekly | |
9681 | 9681 | New Zealand | New Zealand | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 5185289 | 571 | 0 | TBC | weekly | |
9733 | 9733 | New Zealand | New Zealand | 0 | 2018-02-12 | 2018-02-18 | 7 | 2018 | 7 | 5185289 | 542 | 0 | TBC | weekly | |
9785 | 9785 | New Zealand | New Zealand | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 5185289 | 558 | 0 | TBC | weekly | |
9837 | 9837 | New Zealand | New Zealand | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 5185289 | 618 | 0 | TBC | weekly | |
9890 | 9890 | New Zealand | New Zealand | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 5185289 | 591 | 0 | TBC | weekly | |
9942 | 9942 | New Zealand | New Zealand | 0 | 2022-02-14 | 2022-02-20 | 7 | 2022 | 7 | 5185289 | 642 | 11 | TBC | weekly | |
9577 | 9577 | New Zealand | New Zealand | 0 | 2015-02-16 | 2015-02-22 | 7 | 2015 | 8 | 5185289 | 542 | 0 | TBC | weekly | |
9630 | 9630 | New Zealand | New Zealand | 0 | 2016-02-22 | 2016-02-28 | 7 | 2016 | 8 | 5185289 | 568 | 0 | TBC | weekly | |
9682 | 9682 | New Zealand | New Zealand | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 5185289 | 580 | 0 | TBC | weekly | |
9734 | 9734 | New Zealand | New Zealand | 0 | 2018-02-19 | 2018-02-25 | 7 | 2018 | 8 | 5185289 | 583 | 0 | TBC | weekly | |
9786 | 9786 | New Zealand | New Zealand | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 5185289 | 571 | 0 | TBC | weekly | |
9838 | 9838 | New Zealand | New Zealand | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 5185289 | 622 | 0 | TBC | weekly | |
9891 | 9891 | New Zealand | New Zealand | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 5185289 | 603 | 0 | TBC | weekly | |
9943 | 9943 | New Zealand | New Zealand | 0 | 2022-02-21 | 2022-02-27 | 7 | 2022 | 8 | 5185289 | 627 | 20 | TBC | weekly | |
9578 | 9578 | New Zealand | New Zealand | 0 | 2015-02-23 | 2015-03-01 | 7 | 2015 | 9 | 5185289 | 586 | 0 | TBC | weekly | |
9631 | 9631 | New Zealand | New Zealand | 0 | 2016-02-29 | 2016-03-06 | 7 | 2016 | 9 | 5185289 | 534 | 0 | TBC | weekly | |
9683 | 9683 | New Zealand | New Zealand | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 5185289 | 572 | 0 | TBC | weekly | |
9735 | 9735 | New Zealand | New Zealand | 0 | 2018-02-26 | 2018-03-04 | 7 | 2018 | 9 | 5185289 | 572 | 0 | TBC | weekly | |
9787 | 9787 | New Zealand | New Zealand | 0 | 2019-02-25 | 2019-03-03 | 7 | 2019 | 9 | 5185289 | 618 | 0 | TBC | weekly | |
9839 | 9839 | New Zealand | New Zealand | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 5185289 | 595 | 0 | TBC | weekly | |
9892 | 9892 | New Zealand | New Zealand | 0 | 2021-03-01 | 2021-03-07 | 7 | 2021 | 9 | 5185289 | 640 | 0 | TBC | weekly | |
9944 | 9944 | New Zealand | New Zealand | 0 | 2022-02-28 | 2022-03-06 | 7 | 2022 | 9 | 5185289 | 686 | 34 | TBC | weekly | |
9579 | 9579 | New Zealand | New Zealand | 0 | 2015-03-02 | 2015-03-08 | 7 | 2015 | 10 | 5185289 | 550 | 0 | TBC | weekly | |
9632 | 9632 | New Zealand | New Zealand | 0 | 2016-03-07 | 2016-03-13 | 7 | 2016 | 10 | 5185289 | 511 | 0 | TBC | weekly | |
9684 | 9684 | New Zealand | New Zealand | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 5185289 | 599 | 0 | TBC | weekly | |
9736 | 9736 | New Zealand | New Zealand | 0 | 2018-03-05 | 2018-03-11 | 7 | 2018 | 10 | 5185289 | 602 | 0 | TBC | weekly | |
9788 | 9788 | New Zealand | New Zealand | 0 | 2019-03-04 | 2019-03-10 | 7 | 2019 | 10 | 5185289 | 626 | 0 | TBC | weekly | |
9840 | 9840 | New Zealand | New Zealand | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 5185289 | 611 | 0 | TBC | weekly | |
9893 | 9893 | New Zealand | New Zealand | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 5185289 | 618 | 0 | TBC | weekly | |
9945 | 9945 | New Zealand | New Zealand | 0 | 2022-03-07 | 2022-03-13 | 7 | 2022 | 10 | 5185289 | 732 | 62 | TBC | weekly | |
9580 | 9580 | New Zealand | New Zealand | 0 | 2015-03-09 | 2015-03-15 | 7 | 2015 | 11 | 5185289 | 552 | 0 | TBC | weekly | |
9633 | 9633 | New Zealand | New Zealand | 0 | 2016-03-14 | 2016-03-20 | 7 | 2016 | 11 | 5185289 | 525 | 0 | TBC | weekly | |
9685 | 9685 | New Zealand | New Zealand | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 5185289 | 571 | 0 | TBC | weekly | |
9737 | 9737 | New Zealand | New Zealand | 0 | 2018-03-12 | 2018-03-18 | 7 | 2018 | 11 | 5185289 | 617 | 0 | TBC | weekly | |
9789 | 9789 | New Zealand | New Zealand | 0 | 2019-03-11 | 2019-03-17 | 7 | 2019 | 11 | 5185289 | 675 | 0 | TBC | weekly | |
9841 | 9841 | New Zealand | New Zealand | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 5185289 | 601 | 0 | TBC | weekly | |
9894 | 9894 | New Zealand | New Zealand | 0 | 2021-03-15 | 2021-03-21 | 7 | 2021 | 11 | 5185289 | 630 | 0 | TBC | weekly | |
9946 | 9946 | New Zealand | New Zealand | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 5185289 | 776 | 93 | TBC | weekly | |
9581 | 9581 | New Zealand | New Zealand | 0 | 2015-03-16 | 2015-03-22 | 7 | 2015 | 12 | 5185289 | 567 | 0 | TBC | weekly | |
9634 | 9634 | New Zealand | New Zealand | 0 | 2016-03-21 | 2016-03-27 | 7 | 2016 | 12 | 5185289 | 515 | 0 | TBC | weekly | |
9686 | 9686 | New Zealand | New Zealand | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 5185289 | 593 | 0 | TBC | weekly | |
9738 | 9738 | New Zealand | New Zealand | 0 | 2018-03-19 | 2018-03-25 | 7 | 2018 | 12 | 5185289 | 605 | 0 | TBC | weekly | |
9790 | 9790 | New Zealand | New Zealand | 0 | 2019-03-18 | 2019-03-24 | 7 | 2019 | 12 | 5185289 | 632 | 0 | TBC | weekly | |
9842 | 9842 | New Zealand | New Zealand | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 5185289 | 619 | 0 | TBC | weekly | |
9895 | 9895 | New Zealand | New Zealand | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 5185289 | 638 | 0 | TBC | weekly | |
9947 | 9947 | New Zealand | New Zealand | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 5185289 | 750 | 92 | TBC | weekly | |
9582 | 9582 | New Zealand | New Zealand | 0 | 2015-03-23 | 2015-03-29 | 7 | 2015 | 13 | 5185289 | 575 | 0 | TBC | weekly | |
9635 | 9635 | New Zealand | New Zealand | 0 | 2016-03-28 | 2016-04-03 | 7 | 2016 | 13 | 5185289 | 590 | 0 | TBC | weekly | |
9687 | 9687 | New Zealand | New Zealand | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 5185289 | 596 | 0 | TBC | weekly | |
9739 | 9739 | New Zealand | New Zealand | 0 | 2018-03-26 | 2018-04-01 | 7 | 2018 | 13 | 5185289 | 571 | 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]);