economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where country = "New Zealand" and year = 2020
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9831 | 9831 | New Zealand | New Zealand | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 5185289 | 590 | 0 | TBC | weekly | |
9832 | 9832 | New Zealand | New Zealand | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 5185289 | 581 | 0 | TBC | weekly | |
9833 | 9833 | New Zealand | New Zealand | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 5185289 | 641 | 0 | TBC | weekly | |
9834 | 9834 | New Zealand | New Zealand | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 5185289 | 610 | 0 | TBC | weekly | |
9835 | 9835 | New Zealand | New Zealand | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 5185289 | 615 | 0 | TBC | weekly | |
9836 | 9836 | New Zealand | New Zealand | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 5185289 | 588 | 0 | TBC | weekly | |
9837 | 9837 | New Zealand | New Zealand | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 5185289 | 618 | 0 | TBC | weekly | |
9838 | 9838 | New Zealand | New Zealand | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 5185289 | 622 | 0 | TBC | weekly | |
9839 | 9839 | New Zealand | New Zealand | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 5185289 | 595 | 0 | TBC | weekly | |
9840 | 9840 | New Zealand | New Zealand | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 5185289 | 611 | 0 | TBC | weekly | |
9841 | 9841 | New Zealand | New Zealand | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 5185289 | 601 | 0 | TBC | weekly | |
9842 | 9842 | New Zealand | New Zealand | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 5185289 | 619 | 0 | TBC | weekly | |
9843 | 9843 | New Zealand | New Zealand | 0 | 2020-03-23 | 2020-03-29 | 7 | 2020 | 13 | 5185289 | 613 | 1 | TBC | weekly | |
9844 | 9844 | New Zealand | New Zealand | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 5185289 | 628 | 3 | TBC | weekly | |
9845 | 9845 | New Zealand | New Zealand | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 5185289 | 651 | 8 | TBC | weekly | |
9846 | 9846 | New Zealand | New Zealand | 0 | 2020-04-13 | 2020-04-19 | 7 | 2020 | 16 | 5185289 | 663 | 6 | TBC | weekly | |
9847 | 9847 | New Zealand | New Zealand | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 5185289 | 633 | 2 | TBC | weekly | |
9848 | 9848 | New Zealand | New Zealand | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 5185289 | 561 | 1 | TBC | weekly | |
9849 | 9849 | New Zealand | New Zealand | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 5185289 | 629 | 1 | TBC | weekly | |
9850 | 9850 | New Zealand | New Zealand | 0 | 2020-05-11 | 2020-05-17 | 7 | 2020 | 20 | 5185289 | 617 | 0 | TBC | weekly | |
9851 | 9851 | New Zealand | New Zealand | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 5185289 | 608 | 1 | TBC | weekly | |
9852 | 9852 | New Zealand | New Zealand | 0 | 2020-05-25 | 2020-05-31 | 7 | 2020 | 22 | 5185289 | 603 | 0 | TBC | weekly | |
9853 | 9853 | New Zealand | New Zealand | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 5185289 | 623 | 0 | TBC | weekly | |
9854 | 9854 | New Zealand | New Zealand | 0 | 2020-06-08 | 2020-06-14 | 7 | 2020 | 24 | 5185289 | 643 | 0 | TBC | weekly | |
9855 | 9855 | New Zealand | New Zealand | 0 | 2020-06-15 | 2020-06-21 | 7 | 2020 | 25 | 5185289 | 642 | 0 | TBC | weekly | |
9856 | 9856 | New Zealand | New Zealand | 0 | 2020-06-22 | 2020-06-28 | 7 | 2020 | 26 | 5185289 | 621 | 0 | TBC | weekly | |
9857 | 9857 | New Zealand | New Zealand | 0 | 2020-06-29 | 2020-07-05 | 7 | 2020 | 27 | 5185289 | 618 | 0 | TBC | weekly | |
9858 | 9858 | New Zealand | New Zealand | 0 | 2020-07-06 | 2020-07-12 | 7 | 2020 | 28 | 5185289 | 617 | 0 | TBC | weekly | |
9859 | 9859 | New Zealand | New Zealand | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 5185289 | 693 | 0 | TBC | weekly | |
9860 | 9860 | New Zealand | New Zealand | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 5185289 | 683 | 0 | TBC | weekly | |
9861 | 9861 | New Zealand | New Zealand | 0 | 2020-07-27 | 2020-08-02 | 7 | 2020 | 31 | 5185289 | 676 | 0 | TBC | weekly | |
9862 | 9862 | New Zealand | New Zealand | 0 | 2020-08-03 | 2020-08-09 | 7 | 2020 | 32 | 5185289 | 643 | 0 | TBC | weekly | |
9863 | 9863 | New Zealand | New Zealand | 0 | 2020-08-10 | 2020-08-16 | 7 | 2020 | 33 | 5185289 | 634 | 0 | TBC | weekly | |
9864 | 9864 | New Zealand | New Zealand | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 5185289 | 656 | 0 | TBC | weekly | |
9865 | 9865 | New Zealand | New Zealand | 0 | 2020-08-24 | 2020-08-30 | 7 | 2020 | 35 | 5185289 | 601 | 2 | TBC | weekly | |
9866 | 9866 | New Zealand | New Zealand | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 5185289 | 630 | 0 | TBC | weekly | |
9867 | 9867 | New Zealand | New Zealand | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 5185289 | 623 | 1 | TBC | weekly | |
9868 | 9868 | New Zealand | New Zealand | 0 | 2020-09-14 | 2020-09-20 | 7 | 2020 | 38 | 5185289 | 606 | 0 | TBC | weekly | |
9869 | 9869 | New Zealand | New Zealand | 0 | 2020-09-21 | 2020-09-27 | 7 | 2020 | 39 | 5185289 | 611 | 0 | TBC | weekly | |
9870 | 9870 | New Zealand | New Zealand | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 5185289 | 651 | 0 | TBC | weekly | |
9871 | 9871 | New Zealand | New Zealand | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 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 | |
9873 | 9873 | New Zealand | New Zealand | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 5185289 | 689 | 0 | TBC | weekly | |
9874 | 9874 | New Zealand | New Zealand | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 5185289 | 584 | 0 | TBC | weekly | |
9875 | 9875 | New Zealand | New Zealand | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 5185289 | 631 | 0 | TBC | weekly | |
9876 | 9876 | New Zealand | New Zealand | 0 | 2020-11-09 | 2020-11-15 | 7 | 2020 | 46 | 5185289 | 586 | 0 | TBC | weekly | |
9877 | 9877 | New Zealand | New Zealand | 0 | 2020-11-16 | 2020-11-22 | 7 | 2020 | 47 | 5185289 | 612 | 0 | TBC | weekly | |
9878 | 9878 | New Zealand | New Zealand | 0 | 2020-11-23 | 2020-11-29 | 7 | 2020 | 48 | 5185289 | 650 | 0 | TBC | weekly | |
9879 | 9879 | New Zealand | New Zealand | 0 | 2020-11-30 | 2020-12-06 | 7 | 2020 | 49 | 5185289 | 643 | 0 | TBC | weekly | |
9880 | 9880 | New Zealand | New Zealand | 0 | 2020-12-07 | 2020-12-13 | 7 | 2020 | 50 | 5185289 | 639 | 0 | TBC | weekly | |
9881 | 9881 | New Zealand | New Zealand | 0 | 2020-12-14 | 2020-12-20 | 7 | 2020 | 51 | 5185289 | 670 | 0 | TBC | weekly | |
9882 | 9882 | New Zealand | New Zealand | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 5185289 | 625 | 0 | TBC | weekly | |
9883 | 9883 | New Zealand | New Zealand | 0 | 2020-12-28 | 2021-01-03 | 7 | 2020 | 53 | 5185289 | 675 | 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]);