economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where cadence = "weekly", country = "South Africa" and year = 2017
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date)
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7943 | 7943 | South Africa | South Africa | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 59893884 | 9938 | 0 | TBC | weekly | |
7944 | 7944 | South Africa | South Africa | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 59893884 | 9264 | 0 | TBC | weekly | |
7945 | 7945 | South Africa | South Africa | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 59893884 | 8972 | 0 | TBC | weekly | |
7946 | 7946 | South Africa | South Africa | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 59893884 | 8971 | 0 | TBC | weekly | |
7947 | 7947 | South Africa | South Africa | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 59893884 | 9135 | 0 | TBC | weekly | |
7948 | 7948 | South Africa | South Africa | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 59893884 | 9366 | 0 | TBC | weekly | |
7949 | 7949 | South Africa | South Africa | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 59893884 | 8991 | 0 | TBC | weekly | |
7950 | 7950 | South Africa | South Africa | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 59893884 | 8870 | 0 | TBC | weekly | |
7951 | 7951 | South Africa | South Africa | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 59893884 | 9448 | 0 | TBC | weekly | |
7952 | 7952 | South Africa | South Africa | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 59893884 | 9305 | 0 | TBC | weekly | |
7953 | 7953 | South Africa | South Africa | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 59893884 | 9282 | 0 | TBC | weekly | |
7954 | 7954 | South Africa | South Africa | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 59893884 | 8763 | 0 | TBC | weekly | |
7955 | 7955 | South Africa | South Africa | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 59893884 | 9251 | 0 | TBC | weekly | |
7956 | 7956 | South Africa | South Africa | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 59893884 | 9577 | 0 | TBC | weekly | |
7957 | 7957 | South Africa | South Africa | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 59893884 | 9056 | 0 | TBC | weekly | |
7958 | 7958 | South Africa | South Africa | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 59893884 | 9754 | 0 | TBC | weekly | |
7959 | 7959 | South Africa | South Africa | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 59893884 | 9582 | 0 | TBC | weekly | |
7960 | 7960 | South Africa | South Africa | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 59893884 | 9991 | 0 | TBC | weekly | |
7961 | 7961 | South Africa | South Africa | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 59893884 | 9671 | 0 | TBC | weekly | |
7962 | 7962 | South Africa | South Africa | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 59893884 | 10549 | 0 | TBC | weekly | |
7963 | 7963 | South Africa | South Africa | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 59893884 | 9794 | 0 | TBC | weekly | |
7964 | 7964 | South Africa | South Africa | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 59893884 | 10182 | 0 | TBC | weekly | |
7965 | 7965 | South Africa | South Africa | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 59893884 | 10754 | 0 | TBC | weekly | |
7966 | 7966 | South Africa | South Africa | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 59893884 | 10655 | 0 | TBC | weekly | |
7967 | 7967 | South Africa | South Africa | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 59893884 | 10446 | 0 | TBC | weekly | |
7968 | 7968 | South Africa | South Africa | 0 | 2017-06-26 | 2017-07-02 | 7 | 2017 | 26 | 59893884 | 11218 | 0 | TBC | weekly | |
7969 | 7969 | South Africa | South Africa | 0 | 2017-07-03 | 2017-07-09 | 7 | 2017 | 27 | 59893884 | 11527 | 0 | TBC | weekly | |
7970 | 7970 | South Africa | South Africa | 0 | 2017-07-10 | 2017-07-16 | 7 | 2017 | 28 | 59893884 | 11262 | 0 | TBC | weekly | |
7971 | 7971 | South Africa | South Africa | 0 | 2017-07-17 | 2017-07-23 | 7 | 2017 | 29 | 59893884 | 11406 | 0 | TBC | weekly | |
7972 | 7972 | South Africa | South Africa | 0 | 2017-07-24 | 2017-07-30 | 7 | 2017 | 30 | 59893884 | 10845 | 0 | TBC | weekly | |
7973 | 7973 | South Africa | South Africa | 0 | 2017-07-31 | 2017-08-06 | 7 | 2017 | 31 | 59893884 | 11024 | 0 | TBC | weekly | |
7974 | 7974 | South Africa | South Africa | 0 | 2017-08-07 | 2017-08-13 | 7 | 2017 | 32 | 59893884 | 11052 | 0 | TBC | weekly | |
7975 | 7975 | South Africa | South Africa | 0 | 2017-08-14 | 2017-08-20 | 7 | 2017 | 33 | 59893884 | 11205 | 0 | TBC | weekly | |
7976 | 7976 | South Africa | South Africa | 0 | 2017-08-21 | 2017-08-27 | 7 | 2017 | 34 | 59893884 | 11548 | 0 | TBC | weekly | |
7977 | 7977 | South Africa | South Africa | 0 | 2017-08-28 | 2017-09-03 | 7 | 2017 | 35 | 59893884 | 11168 | 0 | TBC | weekly | |
7978 | 7978 | South Africa | South Africa | 0 | 2017-09-04 | 2017-09-10 | 7 | 2017 | 36 | 59893884 | 11441 | 0 | TBC | weekly | |
7979 | 7979 | South Africa | South Africa | 0 | 2017-09-11 | 2017-09-17 | 7 | 2017 | 37 | 59893884 | 10568 | 0 | TBC | weekly | |
7980 | 7980 | South Africa | South Africa | 0 | 2017-09-18 | 2017-09-24 | 7 | 2017 | 38 | 59893884 | 10435 | 0 | TBC | weekly | |
7981 | 7981 | South Africa | South Africa | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 59893884 | 10235 | 0 | TBC | weekly | |
7982 | 7982 | South Africa | South Africa | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 59893884 | 10694 | 0 | TBC | weekly | |
7983 | 7983 | South Africa | South Africa | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 59893884 | 10536 | 0 | TBC | weekly | |
7984 | 7984 | South Africa | South Africa | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 59893884 | 10035 | 0 | TBC | weekly | |
7985 | 7985 | South Africa | South Africa | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 59893884 | 9886 | 0 | TBC | weekly | |
7986 | 7986 | South Africa | South Africa | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 59893884 | 10476 | 0 | TBC | weekly | |
7987 | 7987 | South Africa | South Africa | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 59893884 | 9764 | 0 | TBC | weekly | |
7988 | 7988 | South Africa | South Africa | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 59893884 | 9870 | 0 | TBC | weekly | |
7989 | 7989 | South Africa | South Africa | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 59893884 | 9726 | 0 | TBC | weekly | |
7990 | 7990 | South Africa | South Africa | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 59893884 | 9819 | 0 | TBC | weekly | |
7991 | 7991 | South Africa | South Africa | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 59893884 | 10069 | 0 | TBC | weekly | |
7992 | 7992 | South Africa | South Africa | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 59893884 | 9732 | 0 | TBC | weekly | |
7993 | 7993 | South Africa | South Africa | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 59893884 | 10268 | 0 | TBC | weekly | |
7994 | 7994 | South Africa | South Africa | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 59893884 | 10082 | 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]);