economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "New Zealand" and year = 2019
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9779 | 9779 | New Zealand | New Zealand | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 5185289 | 609 | 0 | TBC | weekly | |
9780 | 9780 | New Zealand | New Zealand | 0 | 2019-01-07 | 2019-01-13 | 7 | 2019 | 2 | 5185289 | 604 | 0 | TBC | weekly | |
9781 | 9781 | New Zealand | New Zealand | 0 | 2019-01-14 | 2019-01-20 | 7 | 2019 | 3 | 5185289 | 625 | 0 | TBC | weekly | |
9782 | 9782 | New Zealand | New Zealand | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 5185289 | 589 | 0 | TBC | weekly | |
9783 | 9783 | New Zealand | New Zealand | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 5185289 | 544 | 0 | TBC | weekly | |
9784 | 9784 | New Zealand | New Zealand | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 5185289 | 557 | 0 | TBC | weekly | |
9785 | 9785 | New Zealand | New Zealand | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 5185289 | 558 | 0 | TBC | weekly | |
9786 | 9786 | New Zealand | New Zealand | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 5185289 | 571 | 0 | TBC | weekly | |
9787 | 9787 | New Zealand | New Zealand | 0 | 2019-02-25 | 2019-03-03 | 7 | 2019 | 9 | 5185289 | 618 | 0 | TBC | weekly | |
9788 | 9788 | New Zealand | New Zealand | 0 | 2019-03-04 | 2019-03-10 | 7 | 2019 | 10 | 5185289 | 626 | 0 | TBC | weekly | |
9789 | 9789 | New Zealand | New Zealand | 0 | 2019-03-11 | 2019-03-17 | 7 | 2019 | 11 | 5185289 | 675 | 0 | TBC | weekly | |
9790 | 9790 | New Zealand | New Zealand | 0 | 2019-03-18 | 2019-03-24 | 7 | 2019 | 12 | 5185289 | 632 | 0 | TBC | weekly | |
9791 | 9791 | New Zealand | New Zealand | 0 | 2019-03-25 | 2019-03-31 | 7 | 2019 | 13 | 5185289 | 637 | 0 | TBC | weekly | |
9792 | 9792 | New Zealand | New Zealand | 0 | 2019-04-01 | 2019-04-07 | 7 | 2019 | 14 | 5185289 | 640 | 0 | TBC | weekly | |
9793 | 9793 | New Zealand | New Zealand | 0 | 2019-04-08 | 2019-04-14 | 7 | 2019 | 15 | 5185289 | 648 | 0 | TBC | weekly | |
9794 | 9794 | New Zealand | New Zealand | 0 | 2019-04-15 | 2019-04-21 | 7 | 2019 | 16 | 5185289 | 690 | 0 | TBC | weekly | |
9795 | 9795 | New Zealand | New Zealand | 0 | 2019-04-22 | 2019-04-28 | 7 | 2019 | 17 | 5185289 | 637 | 0 | TBC | weekly | |
9796 | 9796 | New Zealand | New Zealand | 0 | 2019-04-29 | 2019-05-05 | 7 | 2019 | 18 | 5185289 | 637 | 0 | TBC | weekly | |
9797 | 9797 | New Zealand | New Zealand | 0 | 2019-05-06 | 2019-05-12 | 7 | 2019 | 19 | 5185289 | 669 | 0 | TBC | weekly | |
9798 | 9798 | New Zealand | New Zealand | 0 | 2019-05-13 | 2019-05-19 | 7 | 2019 | 20 | 5185289 | 630 | 0 | TBC | weekly | |
9799 | 9799 | New Zealand | New Zealand | 0 | 2019-05-20 | 2019-05-26 | 7 | 2019 | 21 | 5185289 | 702 | 0 | TBC | weekly | |
9800 | 9800 | New Zealand | New Zealand | 0 | 2019-05-27 | 2019-06-02 | 7 | 2019 | 22 | 5185289 | 725 | 0 | TBC | weekly | |
9801 | 9801 | New Zealand | New Zealand | 0 | 2019-06-03 | 2019-06-09 | 7 | 2019 | 23 | 5185289 | 726 | 0 | TBC | weekly | |
9802 | 9802 | New Zealand | New Zealand | 0 | 2019-06-10 | 2019-06-16 | 7 | 2019 | 24 | 5185289 | 701 | 0 | TBC | weekly | |
9803 | 9803 | New Zealand | New Zealand | 0 | 2019-06-17 | 2019-06-23 | 7 | 2019 | 25 | 5185289 | 720 | 0 | TBC | weekly | |
9804 | 9804 | New Zealand | New Zealand | 0 | 2019-06-24 | 2019-06-30 | 7 | 2019 | 26 | 5185289 | 760 | 0 | TBC | weekly | |
9805 | 9805 | New Zealand | New Zealand | 0 | 2019-07-01 | 2019-07-07 | 7 | 2019 | 27 | 5185289 | 744 | 0 | TBC | weekly | |
9806 | 9806 | New Zealand | New Zealand | 0 | 2019-07-08 | 2019-07-14 | 7 | 2019 | 28 | 5185289 | 796 | 0 | TBC | weekly | |
9807 | 9807 | New Zealand | New Zealand | 0 | 2019-07-15 | 2019-07-21 | 7 | 2019 | 29 | 5185289 | 736 | 0 | TBC | weekly | |
9808 | 9808 | New Zealand | New Zealand | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 5185289 | 728 | 0 | TBC | weekly | |
9809 | 9809 | New Zealand | New Zealand | 0 | 2019-07-29 | 2019-08-04 | 7 | 2019 | 31 | 5185289 | 733 | 0 | TBC | weekly | |
9810 | 9810 | New Zealand | New Zealand | 0 | 2019-08-05 | 2019-08-11 | 7 | 2019 | 32 | 5185289 | 756 | 0 | TBC | weekly | |
9811 | 9811 | New Zealand | New Zealand | 0 | 2019-08-12 | 2019-08-18 | 7 | 2019 | 33 | 5185289 | 692 | 0 | TBC | weekly | |
9812 | 9812 | New Zealand | New Zealand | 0 | 2019-08-19 | 2019-08-25 | 7 | 2019 | 34 | 5185289 | 670 | 0 | TBC | weekly | |
9813 | 9813 | New Zealand | New Zealand | 0 | 2019-08-26 | 2019-09-01 | 7 | 2019 | 35 | 5185289 | 698 | 0 | TBC | weekly | |
9814 | 9814 | New Zealand | New Zealand | 0 | 2019-09-02 | 2019-09-08 | 7 | 2019 | 36 | 5185289 | 665 | 0 | TBC | weekly | |
9815 | 9815 | New Zealand | New Zealand | 0 | 2019-09-09 | 2019-09-15 | 7 | 2019 | 37 | 5185289 | 697 | 0 | TBC | weekly | |
9816 | 9816 | New Zealand | New Zealand | 0 | 2019-09-16 | 2019-09-22 | 7 | 2019 | 38 | 5185289 | 668 | 0 | TBC | weekly | |
9817 | 9817 | New Zealand | New Zealand | 0 | 2019-09-23 | 2019-09-29 | 7 | 2019 | 39 | 5185289 | 681 | 0 | TBC | weekly | |
9818 | 9818 | New Zealand | New Zealand | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 5185289 | 688 | 0 | TBC | weekly | |
9819 | 9819 | New Zealand | New Zealand | 0 | 2019-10-07 | 2019-10-13 | 7 | 2019 | 41 | 5185289 | 713 | 0 | TBC | weekly | |
9820 | 9820 | New Zealand | New Zealand | 0 | 2019-10-14 | 2019-10-20 | 7 | 2019 | 42 | 5185289 | 609 | 0 | TBC | weekly | |
9821 | 9821 | New Zealand | New Zealand | 0 | 2019-10-21 | 2019-10-27 | 7 | 2019 | 43 | 5185289 | 612 | 0 | TBC | weekly | |
9822 | 9822 | New Zealand | New Zealand | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 5185289 | 646 | 0 | TBC | weekly | |
9823 | 9823 | New Zealand | New Zealand | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 5185289 | 611 | 0 | TBC | weekly | |
9824 | 9824 | New Zealand | New Zealand | 0 | 2019-11-11 | 2019-11-17 | 7 | 2019 | 46 | 5185289 | 620 | 0 | TBC | weekly | |
9825 | 9825 | New Zealand | New Zealand | 0 | 2019-11-18 | 2019-11-24 | 7 | 2019 | 47 | 5185289 | 585 | 0 | TBC | weekly | |
9826 | 9826 | New Zealand | New Zealand | 0 | 2019-11-25 | 2019-12-01 | 7 | 2019 | 48 | 5185289 | 640 | 0 | TBC | weekly | |
9827 | 9827 | New Zealand | New Zealand | 0 | 2019-12-02 | 2019-12-08 | 7 | 2019 | 49 | 5185289 | 571 | 0 | TBC | weekly | |
9828 | 9828 | New Zealand | New Zealand | 0 | 2019-12-09 | 2019-12-15 | 7 | 2019 | 50 | 5185289 | 638 | 0 | TBC | weekly | |
9829 | 9829 | New Zealand | New Zealand | 0 | 2019-12-16 | 2019-12-22 | 7 | 2019 | 51 | 5185289 | 596 | 0 | TBC | weekly | |
9830 | 9830 | New Zealand | New Zealand | 0 | 2019-12-23 | 2019-12-29 | 7 | 2019 | 52 | 5185289 | 565 | 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]);