economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
414 rows where country = "New Zealand"
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9670 | 9670 | New Zealand | New Zealand | 0 | 2016-11-28 | 2016-12-04 | 7 | 2016 | 48 | 5185289 | 596 | 0 | TBC | weekly | |
9671 | 9671 | New Zealand | New Zealand | 0 | 2016-12-05 | 2016-12-11 | 7 | 2016 | 49 | 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 | |
9673 | 9673 | New Zealand | New Zealand | 0 | 2016-12-19 | 2016-12-25 | 7 | 2016 | 51 | 5185289 | 548 | 0 | TBC | weekly | |
9674 | 9674 | New Zealand | New Zealand | 0 | 2016-12-26 | 2017-01-01 | 7 | 2016 | 52 | 5185289 | 602 | 0 | TBC | weekly | |
9675 | 9675 | New Zealand | New Zealand | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 5185289 | 528 | 0 | TBC | weekly | |
9676 | 9676 | New Zealand | New Zealand | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 5185289 | 601 | 0 | TBC | weekly | |
9677 | 9677 | New Zealand | New Zealand | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 5185289 | 557 | 0 | TBC | weekly | |
9678 | 9678 | New Zealand | New Zealand | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 5185289 | 608 | 0 | TBC | weekly | |
9679 | 9679 | New Zealand | New Zealand | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 5185289 | 591 | 0 | TBC | weekly | |
9680 | 9680 | New Zealand | New Zealand | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 5185289 | 564 | 0 | TBC | weekly | |
9681 | 9681 | New Zealand | New Zealand | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 5185289 | 571 | 0 | TBC | weekly | |
9682 | 9682 | New Zealand | New Zealand | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 5185289 | 580 | 0 | TBC | weekly | |
9683 | 9683 | New Zealand | New Zealand | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 5185289 | 572 | 0 | TBC | weekly | |
9684 | 9684 | New Zealand | New Zealand | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 5185289 | 599 | 0 | TBC | weekly | |
9685 | 9685 | New Zealand | New Zealand | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 5185289 | 571 | 0 | TBC | weekly | |
9686 | 9686 | New Zealand | New Zealand | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 5185289 | 593 | 0 | TBC | weekly | |
9687 | 9687 | New Zealand | New Zealand | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 5185289 | 596 | 0 | TBC | weekly | |
9688 | 9688 | New Zealand | New Zealand | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 5185289 | 596 | 0 | TBC | weekly | |
9689 | 9689 | New Zealand | New Zealand | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 5185289 | 570 | 0 | TBC | weekly | |
9690 | 9690 | New Zealand | New Zealand | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 5185289 | 592 | 0 | TBC | weekly | |
9691 | 9691 | New Zealand | New Zealand | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 5185289 | 629 | 0 | TBC | weekly | |
9692 | 9692 | New Zealand | New Zealand | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 5185289 | 632 | 0 | TBC | weekly | |
9693 | 9693 | New Zealand | New Zealand | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 5185289 | 626 | 0 | TBC | weekly | |
9694 | 9694 | New Zealand | New Zealand | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 5185289 | 620 | 0 | TBC | weekly | |
9695 | 9695 | New Zealand | New Zealand | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 5185289 | 679 | 0 | TBC | weekly | |
9696 | 9696 | New Zealand | New Zealand | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 5185289 | 682 | 0 | TBC | weekly | |
9697 | 9697 | New Zealand | New Zealand | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 5185289 | 660 | 0 | TBC | weekly | |
9698 | 9698 | New Zealand | New Zealand | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 5185289 | 719 | 0 | TBC | weekly | |
9699 | 9699 | New Zealand | New Zealand | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 5185289 | 727 | 0 | TBC | weekly | |
9700 | 9700 | New Zealand | New Zealand | 0 | 2017-06-26 | 2017-07-02 | 7 | 2017 | 26 | 5185289 | 695 | 0 | TBC | weekly | |
9701 | 9701 | New Zealand | New Zealand | 0 | 2017-07-03 | 2017-07-09 | 7 | 2017 | 27 | 5185289 | 737 | 0 | TBC | weekly | |
9702 | 9702 | New Zealand | New Zealand | 0 | 2017-07-10 | 2017-07-16 | 7 | 2017 | 28 | 5185289 | 700 | 0 | TBC | weekly | |
9703 | 9703 | New Zealand | New Zealand | 0 | 2017-07-17 | 2017-07-23 | 7 | 2017 | 29 | 5185289 | 806 | 0 | TBC | weekly | |
9704 | 9704 | New Zealand | New Zealand | 0 | 2017-07-24 | 2017-07-30 | 7 | 2017 | 30 | 5185289 | 839 | 0 | TBC | weekly | |
9705 | 9705 | New Zealand | New Zealand | 0 | 2017-07-31 | 2017-08-06 | 7 | 2017 | 31 | 5185289 | 863 | 0 | TBC | weekly | |
9706 | 9706 | New Zealand | New Zealand | 0 | 2017-08-07 | 2017-08-13 | 7 | 2017 | 32 | 5185289 | 810 | 0 | TBC | weekly | |
9707 | 9707 | New Zealand | New Zealand | 0 | 2017-08-14 | 2017-08-20 | 7 | 2017 | 33 | 5185289 | 739 | 0 | TBC | weekly | |
9708 | 9708 | New Zealand | New Zealand | 0 | 2017-08-21 | 2017-08-27 | 7 | 2017 | 34 | 5185289 | 709 | 0 | TBC | weekly | |
9709 | 9709 | New Zealand | New Zealand | 0 | 2017-08-28 | 2017-09-03 | 7 | 2017 | 35 | 5185289 | 717 | 0 | TBC | weekly | |
9710 | 9710 | New Zealand | New Zealand | 0 | 2017-09-04 | 2017-09-10 | 7 | 2017 | 36 | 5185289 | 687 | 0 | TBC | weekly | |
9711 | 9711 | New Zealand | New Zealand | 0 | 2017-09-11 | 2017-09-17 | 7 | 2017 | 37 | 5185289 | 699 | 0 | TBC | weekly | |
9712 | 9712 | New Zealand | New Zealand | 0 | 2017-09-18 | 2017-09-24 | 7 | 2017 | 38 | 5185289 | 665 | 0 | TBC | weekly | |
9713 | 9713 | New Zealand | New Zealand | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 5185289 | 639 | 0 | TBC | weekly | |
9714 | 9714 | New Zealand | New Zealand | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 5185289 | 637 | 0 | TBC | weekly | |
9715 | 9715 | New Zealand | New Zealand | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 5185289 | 635 | 0 | TBC | weekly | |
9716 | 9716 | New Zealand | New Zealand | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 5185289 | 624 | 0 | TBC | weekly | |
9717 | 9717 | New Zealand | New Zealand | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 5185289 | 633 | 0 | TBC | weekly | |
9718 | 9718 | New Zealand | New Zealand | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 5185289 | 618 | 0 | TBC | weekly | |
9719 | 9719 | New Zealand | New Zealand | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 5185289 | 591 | 0 | TBC | weekly | |
9720 | 9720 | New Zealand | New Zealand | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 5185289 | 589 | 0 | TBC | weekly | |
9721 | 9721 | New Zealand | New Zealand | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 5185289 | 626 | 0 | TBC | weekly | |
9722 | 9722 | New Zealand | New Zealand | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 5185289 | 586 | 0 | TBC | weekly | |
9723 | 9723 | New Zealand | New Zealand | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 5185289 | 550 | 0 | TBC | weekly | |
9724 | 9724 | New Zealand | New Zealand | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 5185289 | 596 | 0 | TBC | weekly | |
9725 | 9725 | New Zealand | New Zealand | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 5185289 | 617 | 0 | TBC | weekly | |
9726 | 9726 | New Zealand | New Zealand | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 5185289 | 625 | 0 | TBC | weekly | |
9727 | 9727 | New Zealand | New Zealand | 0 | 2018-01-01 | 2018-01-07 | 7 | 2018 | 1 | 5185289 | 582 | 0 | TBC | weekly | |
9728 | 9728 | New Zealand | New Zealand | 0 | 2018-01-08 | 2018-01-14 | 7 | 2018 | 2 | 5185289 | 611 | 0 | TBC | weekly | |
9729 | 9729 | New Zealand | New Zealand | 0 | 2018-01-15 | 2018-01-21 | 7 | 2018 | 3 | 5185289 | 576 | 0 | TBC | weekly | |
9730 | 9730 | New Zealand | New Zealand | 0 | 2018-01-22 | 2018-01-28 | 7 | 2018 | 4 | 5185289 | 653 | 0 | TBC | weekly | |
9731 | 9731 | New Zealand | New Zealand | 0 | 2018-01-29 | 2018-02-04 | 7 | 2018 | 5 | 5185289 | 591 | 0 | TBC | weekly | |
9732 | 9732 | New Zealand | New Zealand | 0 | 2018-02-05 | 2018-02-11 | 7 | 2018 | 6 | 5185289 | 624 | 0 | TBC | weekly | |
9733 | 9733 | New Zealand | New Zealand | 0 | 2018-02-12 | 2018-02-18 | 7 | 2018 | 7 | 5185289 | 542 | 0 | TBC | weekly | |
9734 | 9734 | New Zealand | New Zealand | 0 | 2018-02-19 | 2018-02-25 | 7 | 2018 | 8 | 5185289 | 583 | 0 | TBC | weekly | |
9735 | 9735 | New Zealand | New Zealand | 0 | 2018-02-26 | 2018-03-04 | 7 | 2018 | 9 | 5185289 | 572 | 0 | TBC | weekly | |
9736 | 9736 | New Zealand | New Zealand | 0 | 2018-03-05 | 2018-03-11 | 7 | 2018 | 10 | 5185289 | 602 | 0 | TBC | weekly | |
9737 | 9737 | New Zealand | New Zealand | 0 | 2018-03-12 | 2018-03-18 | 7 | 2018 | 11 | 5185289 | 617 | 0 | TBC | weekly | |
9738 | 9738 | New Zealand | New Zealand | 0 | 2018-03-19 | 2018-03-25 | 7 | 2018 | 12 | 5185289 | 605 | 0 | TBC | weekly | |
9739 | 9739 | New Zealand | New Zealand | 0 | 2018-03-26 | 2018-04-01 | 7 | 2018 | 13 | 5185289 | 571 | 0 | TBC | weekly | |
9740 | 9740 | New Zealand | New Zealand | 0 | 2018-04-02 | 2018-04-08 | 7 | 2018 | 14 | 5185289 | 583 | 0 | TBC | weekly | |
9741 | 9741 | New Zealand | New Zealand | 0 | 2018-04-09 | 2018-04-15 | 7 | 2018 | 15 | 5185289 | 596 | 0 | TBC | weekly | |
9742 | 9742 | New Zealand | New Zealand | 0 | 2018-04-16 | 2018-04-22 | 7 | 2018 | 16 | 5185289 | 663 | 0 | TBC | weekly | |
9743 | 9743 | New Zealand | New Zealand | 0 | 2018-04-23 | 2018-04-29 | 7 | 2018 | 17 | 5185289 | 632 | 0 | TBC | weekly | |
9744 | 9744 | New Zealand | New Zealand | 0 | 2018-04-30 | 2018-05-06 | 7 | 2018 | 18 | 5185289 | 608 | 0 | TBC | weekly | |
9745 | 9745 | New Zealand | New Zealand | 0 | 2018-05-07 | 2018-05-13 | 7 | 2018 | 19 | 5185289 | 623 | 0 | TBC | weekly | |
9746 | 9746 | New Zealand | New Zealand | 0 | 2018-05-14 | 2018-05-20 | 7 | 2018 | 20 | 5185289 | 654 | 0 | TBC | weekly | |
9747 | 9747 | New Zealand | New Zealand | 0 | 2018-05-21 | 2018-05-27 | 7 | 2018 | 21 | 5185289 | 638 | 0 | TBC | weekly | |
9748 | 9748 | New Zealand | New Zealand | 0 | 2018-05-28 | 2018-06-03 | 7 | 2018 | 22 | 5185289 | 707 | 0 | TBC | weekly | |
9749 | 9749 | New Zealand | New Zealand | 0 | 2018-06-04 | 2018-06-10 | 7 | 2018 | 23 | 5185289 | 653 | 0 | TBC | weekly | |
9750 | 9750 | New Zealand | New Zealand | 0 | 2018-06-11 | 2018-06-17 | 7 | 2018 | 24 | 5185289 | 679 | 0 | TBC | weekly | |
9751 | 9751 | New Zealand | New Zealand | 0 | 2018-06-18 | 2018-06-24 | 7 | 2018 | 25 | 5185289 | 684 | 0 | TBC | weekly | |
9752 | 9752 | New Zealand | New Zealand | 0 | 2018-06-25 | 2018-07-01 | 7 | 2018 | 26 | 5185289 | 673 | 0 | TBC | weekly | |
9753 | 9753 | New Zealand | New Zealand | 0 | 2018-07-02 | 2018-07-08 | 7 | 2018 | 27 | 5185289 | 650 | 0 | TBC | weekly | |
9754 | 9754 | New Zealand | New Zealand | 0 | 2018-07-09 | 2018-07-15 | 7 | 2018 | 28 | 5185289 | 667 | 0 | TBC | weekly | |
9755 | 9755 | New Zealand | New Zealand | 0 | 2018-07-16 | 2018-07-22 | 7 | 2018 | 29 | 5185289 | 711 | 0 | TBC | weekly | |
9756 | 9756 | New Zealand | New Zealand | 0 | 2018-07-23 | 2018-07-29 | 7 | 2018 | 30 | 5185289 | 714 | 0 | TBC | weekly | |
9757 | 9757 | New Zealand | New Zealand | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 5185289 | 683 | 0 | TBC | weekly | |
9758 | 9758 | New Zealand | New Zealand | 0 | 2018-08-06 | 2018-08-12 | 7 | 2018 | 32 | 5185289 | 697 | 0 | TBC | weekly | |
9759 | 9759 | New Zealand | New Zealand | 0 | 2018-08-13 | 2018-08-19 | 7 | 2018 | 33 | 5185289 | 720 | 0 | TBC | weekly | |
9760 | 9760 | New Zealand | New Zealand | 0 | 2018-08-20 | 2018-08-26 | 7 | 2018 | 34 | 5185289 | 725 | 0 | TBC | weekly | |
9761 | 9761 | New Zealand | New Zealand | 0 | 2018-08-27 | 2018-09-02 | 7 | 2018 | 35 | 5185289 | 707 | 0 | TBC | weekly | |
9762 | 9762 | New Zealand | New Zealand | 0 | 2018-09-03 | 2018-09-09 | 7 | 2018 | 36 | 5185289 | 682 | 0 | TBC | weekly | |
9763 | 9763 | New Zealand | New Zealand | 0 | 2018-09-10 | 2018-09-16 | 7 | 2018 | 37 | 5185289 | 674 | 0 | TBC | weekly | |
9764 | 9764 | New Zealand | New Zealand | 0 | 2018-09-17 | 2018-09-23 | 7 | 2018 | 38 | 5185289 | 691 | 0 | TBC | weekly | |
9765 | 9765 | New Zealand | New Zealand | 0 | 2018-09-24 | 2018-09-30 | 7 | 2018 | 39 | 5185289 | 619 | 0 | TBC | weekly | |
9766 | 9766 | New Zealand | New Zealand | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 5185289 | 652 | 0 | TBC | weekly | |
9767 | 9767 | New Zealand | New Zealand | 0 | 2018-10-08 | 2018-10-14 | 7 | 2018 | 41 | 5185289 | 666 | 0 | TBC | weekly | |
9768 | 9768 | New Zealand | New Zealand | 0 | 2018-10-15 | 2018-10-21 | 7 | 2018 | 42 | 5185289 | 647 | 0 | TBC | weekly | |
9769 | 9769 | New Zealand | New Zealand | 0 | 2018-10-22 | 2018-10-28 | 7 | 2018 | 43 | 5185289 | 626 | 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]);