economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where cadence = "weekly", country = "Australia" and year = 2016
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3864 | 3864 | Australia | Australia | 0 | 2016-01-04 | 2016-01-10 | 7 | 2016 | 1 | 26177410 | 2789 | 0 | TBC | weekly | |
3865 | 3865 | Australia | Australia | 0 | 2016-01-11 | 2016-01-17 | 7 | 2016 | 2 | 26177410 | 2870 | 0 | TBC | weekly | |
3866 | 3866 | Australia | Australia | 0 | 2016-01-18 | 2016-01-24 | 7 | 2016 | 3 | 26177410 | 2825 | 0 | TBC | weekly | |
3867 | 3867 | Australia | Australia | 0 | 2016-01-25 | 2016-01-31 | 7 | 2016 | 4 | 26177410 | 2668 | 0 | TBC | weekly | |
3868 | 3868 | Australia | Australia | 0 | 2016-02-01 | 2016-02-07 | 7 | 2016 | 5 | 26177410 | 2817 | 0 | TBC | weekly | |
3869 | 3869 | Australia | Australia | 0 | 2016-02-08 | 2016-02-14 | 7 | 2016 | 6 | 26177410 | 2730 | 0 | TBC | weekly | |
3870 | 3870 | Australia | Australia | 0 | 2016-02-15 | 2016-02-21 | 7 | 2016 | 7 | 26177410 | 2734 | 0 | TBC | weekly | |
3871 | 3871 | Australia | Australia | 0 | 2016-02-22 | 2016-02-28 | 7 | 2016 | 8 | 26177410 | 2753 | 0 | TBC | weekly | |
3872 | 3872 | Australia | Australia | 0 | 2016-02-29 | 2016-03-06 | 7 | 2016 | 9 | 26177410 | 2728 | 0 | TBC | weekly | |
3873 | 3873 | Australia | Australia | 0 | 2016-03-07 | 2016-03-13 | 7 | 2016 | 10 | 26177410 | 2817 | 0 | TBC | weekly | |
3874 | 3874 | Australia | Australia | 0 | 2016-03-14 | 2016-03-20 | 7 | 2016 | 11 | 26177410 | 2756 | 0 | TBC | weekly | |
3875 | 3875 | Australia | Australia | 0 | 2016-03-21 | 2016-03-27 | 7 | 2016 | 12 | 26177410 | 2824 | 0 | TBC | weekly | |
3876 | 3876 | Australia | Australia | 0 | 2016-03-28 | 2016-04-03 | 7 | 2016 | 13 | 26177410 | 2810 | 0 | TBC | weekly | |
3877 | 3877 | Australia | Australia | 0 | 2016-04-04 | 2016-04-10 | 7 | 2016 | 14 | 26177410 | 2930 | 0 | TBC | weekly | |
3878 | 3878 | Australia | Australia | 0 | 2016-04-11 | 2016-04-17 | 7 | 2016 | 15 | 26177410 | 2919 | 0 | TBC | weekly | |
3879 | 3879 | Australia | Australia | 0 | 2016-04-18 | 2016-04-24 | 7 | 2016 | 16 | 26177410 | 2852 | 0 | TBC | weekly | |
3880 | 3880 | Australia | Australia | 0 | 2016-04-25 | 2016-05-01 | 7 | 2016 | 17 | 26177410 | 2853 | 0 | TBC | weekly | |
3881 | 3881 | Australia | Australia | 0 | 2016-05-02 | 2016-05-08 | 7 | 2016 | 18 | 26177410 | 2837 | 0 | TBC | weekly | |
3882 | 3882 | Australia | Australia | 0 | 2016-05-09 | 2016-05-15 | 7 | 2016 | 19 | 26177410 | 2953 | 0 | TBC | weekly | |
3883 | 3883 | Australia | Australia | 0 | 2016-05-16 | 2016-05-22 | 7 | 2016 | 20 | 26177410 | 2970 | 0 | TBC | weekly | |
3884 | 3884 | Australia | Australia | 0 | 2016-05-23 | 2016-05-29 | 7 | 2016 | 21 | 26177410 | 3161 | 0 | TBC | weekly | |
3885 | 3885 | Australia | Australia | 0 | 2016-05-30 | 2016-06-05 | 7 | 2016 | 22 | 26177410 | 3152 | 0 | TBC | weekly | |
3886 | 3886 | Australia | Australia | 0 | 2016-06-06 | 2016-06-12 | 7 | 2016 | 23 | 26177410 | 3265 | 0 | TBC | weekly | |
3887 | 3887 | Australia | Australia | 0 | 2016-06-13 | 2016-06-19 | 7 | 2016 | 24 | 26177410 | 3044 | 0 | TBC | weekly | |
3888 | 3888 | Australia | Australia | 0 | 2016-06-20 | 2016-06-26 | 7 | 2016 | 25 | 26177410 | 3191 | 0 | TBC | weekly | |
3889 | 3889 | Australia | Australia | 0 | 2016-06-27 | 2016-07-03 | 7 | 2016 | 26 | 26177410 | 3245 | 0 | TBC | weekly | |
3890 | 3890 | Australia | Australia | 0 | 2016-07-04 | 2016-07-10 | 7 | 2016 | 27 | 26177410 | 3320 | 0 | TBC | weekly | |
3891 | 3891 | Australia | Australia | 0 | 2016-07-11 | 2016-07-17 | 7 | 2016 | 28 | 26177410 | 3324 | 0 | TBC | weekly | |
3892 | 3892 | Australia | Australia | 0 | 2016-07-18 | 2016-07-24 | 7 | 2016 | 29 | 26177410 | 3291 | 0 | TBC | weekly | |
3893 | 3893 | Australia | Australia | 0 | 2016-07-25 | 2016-07-31 | 7 | 2016 | 30 | 26177410 | 3327 | 0 | TBC | weekly | |
3894 | 3894 | Australia | Australia | 0 | 2016-08-01 | 2016-08-07 | 7 | 2016 | 31 | 26177410 | 3283 | 0 | TBC | weekly | |
3895 | 3895 | Australia | Australia | 0 | 2016-08-08 | 2016-08-14 | 7 | 2016 | 32 | 26177410 | 3348 | 0 | TBC | weekly | |
3896 | 3896 | Australia | Australia | 0 | 2016-08-15 | 2016-08-21 | 7 | 2016 | 33 | 26177410 | 3440 | 0 | TBC | weekly | |
3897 | 3897 | Australia | Australia | 0 | 2016-08-22 | 2016-08-28 | 7 | 2016 | 34 | 26177410 | 3438 | 0 | TBC | weekly | |
3898 | 3898 | Australia | Australia | 0 | 2016-08-29 | 2016-09-04 | 7 | 2016 | 35 | 26177410 | 3461 | 0 | TBC | weekly | |
3899 | 3899 | Australia | Australia | 0 | 2016-09-05 | 2016-09-11 | 7 | 2016 | 36 | 26177410 | 3319 | 0 | TBC | weekly | |
3900 | 3900 | Australia | Australia | 0 | 2016-09-12 | 2016-09-18 | 7 | 2016 | 37 | 26177410 | 3277 | 0 | TBC | weekly | |
3901 | 3901 | Australia | Australia | 0 | 2016-09-19 | 2016-09-25 | 7 | 2016 | 38 | 26177410 | 3158 | 0 | TBC | weekly | |
3902 | 3902 | Australia | Australia | 0 | 2016-09-26 | 2016-10-02 | 7 | 2016 | 39 | 26177410 | 3219 | 0 | TBC | weekly | |
3903 | 3903 | Australia | Australia | 0 | 2016-10-03 | 2016-10-09 | 7 | 2016 | 40 | 26177410 | 3191 | 0 | TBC | weekly | |
3904 | 3904 | Australia | Australia | 0 | 2016-10-10 | 2016-10-16 | 7 | 2016 | 41 | 26177410 | 3163 | 0 | TBC | weekly | |
3905 | 3905 | Australia | Australia | 0 | 2016-10-17 | 2016-10-23 | 7 | 2016 | 42 | 26177410 | 3154 | 0 | TBC | weekly | |
3906 | 3906 | Australia | Australia | 0 | 2016-10-24 | 2016-10-30 | 7 | 2016 | 43 | 26177410 | 3116 | 0 | TBC | weekly | |
3907 | 3907 | Australia | Australia | 0 | 2016-10-31 | 2016-11-06 | 7 | 2016 | 44 | 26177410 | 3066 | 0 | TBC | weekly | |
3908 | 3908 | Australia | Australia | 0 | 2016-11-07 | 2016-11-13 | 7 | 2016 | 45 | 26177410 | 3115 | 0 | TBC | weekly | |
3909 | 3909 | Australia | Australia | 0 | 2016-11-14 | 2016-11-20 | 7 | 2016 | 46 | 26177410 | 2948 | 0 | TBC | weekly | |
3910 | 3910 | Australia | Australia | 0 | 2016-11-21 | 2016-11-27 | 7 | 2016 | 47 | 26177410 | 3015 | 0 | TBC | weekly | |
3911 | 3911 | Australia | Australia | 0 | 2016-11-28 | 2016-12-04 | 7 | 2016 | 48 | 26177410 | 2888 | 0 | TBC | weekly | |
3912 | 3912 | Australia | Australia | 0 | 2016-12-05 | 2016-12-11 | 7 | 2016 | 49 | 26177410 | 2741 | 0 | TBC | weekly | |
3913 | 3913 | Australia | Australia | 0 | 2016-12-12 | 2016-12-18 | 7 | 2016 | 50 | 26177410 | 2901 | 0 | TBC | weekly | |
3914 | 3914 | Australia | Australia | 0 | 2016-12-19 | 2016-12-25 | 7 | 2016 | 51 | 26177410 | 2933 | 0 | TBC | weekly | |
3915 | 3915 | Australia | Australia | 0 | 2016-12-26 | 2017-01-01 | 7 | 2016 | 52 | 26177410 | 2919 | 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]);