economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "Australia", days = 7 and year = 2017
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3916 | 3916 | Australia | Australia | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 26177410 | 2895 | 0 | TBC | weekly | |
3917 | 3917 | Australia | Australia | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 26177410 | 2897 | 0 | TBC | weekly | |
3918 | 3918 | Australia | Australia | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 26177410 | 2806 | 0 | TBC | weekly | |
3919 | 3919 | Australia | Australia | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 26177410 | 2887 | 0 | TBC | weekly | |
3920 | 3920 | Australia | Australia | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 26177410 | 2745 | 0 | TBC | weekly | |
3921 | 3921 | Australia | Australia | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 26177410 | 2911 | 0 | TBC | weekly | |
3922 | 3922 | Australia | Australia | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 26177410 | 2849 | 0 | TBC | weekly | |
3923 | 3923 | Australia | Australia | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 26177410 | 2958 | 0 | TBC | weekly | |
3924 | 3924 | Australia | Australia | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 26177410 | 2908 | 0 | TBC | weekly | |
3925 | 3925 | Australia | Australia | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 26177410 | 3017 | 0 | TBC | weekly | |
3926 | 3926 | Australia | Australia | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 26177410 | 2785 | 0 | TBC | weekly | |
3927 | 3927 | Australia | Australia | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 26177410 | 2885 | 0 | TBC | weekly | |
3928 | 3928 | Australia | Australia | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 26177410 | 2858 | 0 | TBC | weekly | |
3929 | 3929 | Australia | Australia | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 26177410 | 2988 | 0 | TBC | weekly | |
3930 | 3930 | Australia | Australia | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 26177410 | 2966 | 0 | TBC | weekly | |
3931 | 3931 | Australia | Australia | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 26177410 | 3011 | 0 | TBC | weekly | |
3932 | 3932 | Australia | Australia | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 26177410 | 3010 | 0 | TBC | weekly | |
3933 | 3933 | Australia | Australia | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 26177410 | 2963 | 0 | TBC | weekly | |
3934 | 3934 | Australia | Australia | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 26177410 | 3107 | 0 | TBC | weekly | |
3935 | 3935 | Australia | Australia | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 26177410 | 3091 | 0 | TBC | weekly | |
3936 | 3936 | Australia | Australia | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 26177410 | 3173 | 0 | TBC | weekly | |
3937 | 3937 | Australia | Australia | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 26177410 | 3203 | 0 | TBC | weekly | |
3938 | 3938 | Australia | Australia | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 26177410 | 3263 | 0 | TBC | weekly | |
3939 | 3939 | Australia | Australia | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 26177410 | 3266 | 0 | TBC | weekly | |
3940 | 3940 | Australia | Australia | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 26177410 | 3232 | 0 | TBC | weekly | |
3941 | 3941 | Australia | Australia | 0 | 2017-06-26 | 2017-07-02 | 7 | 2017 | 26 | 26177410 | 3313 | 0 | TBC | weekly | |
3942 | 3942 | Australia | Australia | 0 | 2017-07-03 | 2017-07-09 | 7 | 2017 | 27 | 26177410 | 3468 | 0 | TBC | weekly | |
3943 | 3943 | Australia | Australia | 0 | 2017-07-10 | 2017-07-16 | 7 | 2017 | 28 | 26177410 | 3504 | 0 | TBC | weekly | |
3944 | 3944 | Australia | Australia | 0 | 2017-07-17 | 2017-07-23 | 7 | 2017 | 29 | 26177410 | 3700 | 0 | TBC | weekly | |
3945 | 3945 | Australia | Australia | 0 | 2017-07-24 | 2017-07-30 | 7 | 2017 | 30 | 26177410 | 3634 | 0 | TBC | weekly | |
3946 | 3946 | Australia | Australia | 0 | 2017-07-31 | 2017-08-06 | 7 | 2017 | 31 | 26177410 | 3749 | 0 | TBC | weekly | |
3947 | 3947 | Australia | Australia | 0 | 2017-08-07 | 2017-08-13 | 7 | 2017 | 32 | 26177410 | 3734 | 0 | TBC | weekly | |
3948 | 3948 | Australia | Australia | 0 | 2017-08-14 | 2017-08-20 | 7 | 2017 | 33 | 26177410 | 3673 | 0 | TBC | weekly | |
3949 | 3949 | Australia | Australia | 0 | 2017-08-21 | 2017-08-27 | 7 | 2017 | 34 | 26177410 | 3668 | 0 | TBC | weekly | |
3950 | 3950 | Australia | Australia | 0 | 2017-08-28 | 2017-09-03 | 7 | 2017 | 35 | 26177410 | 3843 | 0 | TBC | weekly | |
3951 | 3951 | Australia | Australia | 0 | 2017-09-04 | 2017-09-10 | 7 | 2017 | 36 | 26177410 | 3620 | 0 | TBC | weekly | |
3952 | 3952 | Australia | Australia | 0 | 2017-09-11 | 2017-09-17 | 7 | 2017 | 37 | 26177410 | 3697 | 0 | TBC | weekly | |
3953 | 3953 | Australia | Australia | 0 | 2017-09-18 | 2017-09-24 | 7 | 2017 | 38 | 26177410 | 3603 | 0 | TBC | weekly | |
3954 | 3954 | Australia | Australia | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 26177410 | 3338 | 0 | TBC | weekly | |
3955 | 3955 | Australia | Australia | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 26177410 | 3283 | 0 | TBC | weekly | |
3956 | 3956 | Australia | Australia | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 26177410 | 3184 | 0 | TBC | weekly | |
3957 | 3957 | Australia | Australia | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 26177410 | 3075 | 0 | TBC | weekly | |
3958 | 3958 | Australia | Australia | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 26177410 | 2971 | 0 | TBC | weekly | |
3959 | 3959 | Australia | Australia | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 26177410 | 3015 | 0 | TBC | weekly | |
3960 | 3960 | Australia | Australia | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 26177410 | 2870 | 0 | TBC | weekly | |
3961 | 3961 | Australia | Australia | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 26177410 | 2947 | 0 | TBC | weekly | |
3962 | 3962 | Australia | Australia | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 26177410 | 2894 | 0 | TBC | weekly | |
3963 | 3963 | Australia | Australia | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 26177410 | 2882 | 0 | TBC | weekly | |
3964 | 3964 | Australia | Australia | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 26177410 | 2921 | 0 | TBC | weekly | |
3965 | 3965 | Australia | Australia | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 26177410 | 2974 | 0 | TBC | weekly | |
3966 | 3966 | Australia | Australia | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 26177410 | 2914 | 0 | TBC | weekly | |
3967 | 3967 | Australia | Australia | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 26177410 | 2775 | 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]);