economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where country = "Australia" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4072 | 4072 | Australia | Australia | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 26177410 | 2926 | 0 | TBC | weekly | |
4073 | 4073 | Australia | Australia | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 26177410 | 2902 | 0 | TBC | weekly | |
4074 | 4074 | Australia | Australia | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 26177410 | 2914 | 0 | TBC | weekly | |
4075 | 4075 | Australia | Australia | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 26177410 | 3007 | 0 | TBC | weekly | |
4076 | 4076 | Australia | Australia | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 26177410 | 2910 | 0 | TBC | weekly | |
4077 | 4077 | Australia | Australia | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 26177410 | 2917 | 0 | TBC | weekly | |
4078 | 4078 | Australia | Australia | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 26177410 | 3030 | 0 | TBC | weekly | |
4079 | 4079 | Australia | Australia | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 26177410 | 3059 | 0 | TBC | weekly | |
4080 | 4080 | Australia | Australia | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 26177410 | 3090 | 1 | TBC | weekly | |
4081 | 4081 | Australia | Australia | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 26177410 | 2996 | 2 | TBC | weekly | |
4082 | 4082 | Australia | Australia | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 26177410 | 2976 | 0 | TBC | weekly | |
4083 | 4083 | Australia | Australia | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 26177410 | 3095 | 4 | TBC | weekly | |
4084 | 4084 | Australia | Australia | 0 | 2020-03-23 | 2020-03-29 | 7 | 2020 | 13 | 26177410 | 3143 | 9 | TBC | weekly | |
4085 | 4085 | Australia | Australia | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 26177410 | 3217 | 19 | TBC | weekly | |
4086 | 4086 | Australia | Australia | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 26177410 | 3140 | 25 | TBC | weekly | |
4087 | 4087 | Australia | Australia | 0 | 2020-04-13 | 2020-04-19 | 7 | 2020 | 16 | 26177410 | 3084 | 7 | TBC | weekly | |
4088 | 4088 | Australia | Australia | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 26177410 | 3044 | 16 | TBC | weekly | |
4089 | 4089 | Australia | Australia | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 26177410 | 3032 | 12 | TBC | weekly | |
4090 | 4090 | Australia | Australia | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 26177410 | 3161 | 2 | TBC | weekly | |
4091 | 4091 | Australia | Australia | 0 | 2020-05-11 | 2020-05-17 | 7 | 2020 | 20 | 26177410 | 3150 | 2 | TBC | weekly | |
4092 | 4092 | Australia | Australia | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 26177410 | 3214 | 3 | TBC | weekly | |
4093 | 4093 | Australia | Australia | 0 | 2020-05-25 | 2020-05-31 | 7 | 2020 | 22 | 26177410 | 3178 | 1 | TBC | weekly | |
4094 | 4094 | Australia | Australia | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 26177410 | 3113 | 0 | TBC | weekly | |
4095 | 4095 | Australia | Australia | 0 | 2020-06-08 | 2020-06-14 | 7 | 2020 | 24 | 26177410 | 3128 | 0 | TBC | weekly | |
4096 | 4096 | Australia | Australia | 0 | 2020-06-15 | 2020-06-21 | 7 | 2020 | 25 | 26177410 | 3064 | 0 | TBC | weekly | |
4097 | 4097 | Australia | Australia | 0 | 2020-06-22 | 2020-06-28 | 7 | 2020 | 26 | 26177410 | 3058 | 2 | TBC | weekly | |
4098 | 4098 | Australia | Australia | 0 | 2020-06-29 | 2020-07-05 | 7 | 2020 | 27 | 26177410 | 3218 | 2 | TBC | weekly | |
4099 | 4099 | Australia | Australia | 0 | 2020-07-06 | 2020-07-12 | 7 | 2020 | 28 | 26177410 | 3197 | 2 | TBC | weekly | |
4100 | 4100 | Australia | Australia | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 26177410 | 3204 | 15 | TBC | weekly | |
4101 | 4101 | Australia | Australia | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 26177410 | 3332 | 38 | TBC | weekly | |
4102 | 4102 | Australia | Australia | 0 | 2020-07-27 | 2020-08-02 | 7 | 2020 | 31 | 26177410 | 3353 | 60 | TBC | weekly | |
4103 | 4103 | Australia | Australia | 0 | 2020-08-03 | 2020-08-09 | 7 | 2020 | 32 | 26177410 | 3398 | 92 | TBC | weekly | |
4104 | 4104 | Australia | Australia | 0 | 2020-08-10 | 2020-08-16 | 7 | 2020 | 33 | 26177410 | 3478 | 108 | TBC | weekly | |
4105 | 4105 | Australia | Australia | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 26177410 | 3310 | 96 | TBC | weekly | |
4106 | 4106 | Australia | Australia | 0 | 2020-08-24 | 2020-08-30 | 7 | 2020 | 35 | 26177410 | 3283 | 135 | TBC | weekly | |
4107 | 4107 | Australia | Australia | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 26177410 | 3290 | 110 | TBC | weekly | |
4108 | 4108 | Australia | Australia | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 26177410 | 3239 | 54 | TBC | weekly | |
4109 | 4109 | Australia | Australia | 0 | 2020-09-14 | 2020-09-20 | 7 | 2020 | 38 | 26177410 | 3100 | 35 | TBC | weekly | |
4110 | 4110 | Australia | Australia | 0 | 2020-09-21 | 2020-09-27 | 7 | 2020 | 39 | 26177410 | 3145 | 24 | TBC | weekly | |
4111 | 4111 | Australia | Australia | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 26177410 | 3183 | 19 | TBC | weekly | |
4112 | 4112 | Australia | Australia | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 26177410 | 3042 | 4 | TBC | weekly | |
4113 | 4113 | Australia | Australia | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 26177410 | 3003 | 7 | TBC | weekly | |
4114 | 4114 | Australia | Australia | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 26177410 | 2964 | 0 | TBC | weekly | |
4115 | 4115 | Australia | Australia | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 26177410 | 3036 | 2 | TBC | weekly | |
4116 | 4116 | Australia | Australia | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 26177410 | 3034 | 0 | TBC | weekly | |
4117 | 4117 | Australia | Australia | 0 | 2020-11-09 | 2020-11-15 | 7 | 2020 | 46 | 26177410 | 3132 | 0 | TBC | weekly | |
4118 | 4118 | Australia | Australia | 0 | 2020-11-16 | 2020-11-22 | 7 | 2020 | 47 | 26177410 | 3043 | 0 | TBC | weekly | |
4119 | 4119 | Australia | Australia | 0 | 2020-11-23 | 2020-11-29 | 7 | 2020 | 48 | 26177410 | 2957 | 1 | TBC | weekly | |
4120 | 4120 | Australia | Australia | 0 | 2020-11-30 | 2020-12-06 | 7 | 2020 | 49 | 26177410 | 3106 | 0 | TBC | weekly | |
4121 | 4121 | Australia | Australia | 0 | 2020-12-07 | 2020-12-13 | 7 | 2020 | 50 | 26177410 | 3007 | 0 | TBC | weekly | |
4122 | 4122 | Australia | Australia | 0 | 2020-12-14 | 2020-12-20 | 7 | 2020 | 51 | 26177410 | 3047 | 0 | TBC | weekly | |
4123 | 4123 | Australia | Australia | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 26177410 | 3067 | 1 | TBC | weekly | |
4124 | 4124 | Australia | Australia | 0 | 2020-12-28 | 2021-01-03 | 7 | 2020 | 53 | 26177410 | 2987 | 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]);