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 = 2019
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8047 | 8047 | South Africa | South Africa | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 59893884 | 9792 | 0 | TBC | weekly | |
8048 | 8048 | South Africa | South Africa | 0 | 2019-01-07 | 2019-01-13 | 7 | 2019 | 2 | 59893884 | 9595 | 0 | TBC | weekly | |
8049 | 8049 | South Africa | South Africa | 0 | 2019-01-14 | 2019-01-20 | 7 | 2019 | 3 | 59893884 | 9556 | 0 | TBC | weekly | |
8050 | 8050 | South Africa | South Africa | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 59893884 | 8907 | 0 | TBC | weekly | |
8051 | 8051 | South Africa | South Africa | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 59893884 | 9065 | 0 | TBC | weekly | |
8052 | 8052 | South Africa | South Africa | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 59893884 | 9465 | 0 | TBC | weekly | |
8053 | 8053 | South Africa | South Africa | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 59893884 | 9098 | 0 | TBC | weekly | |
8054 | 8054 | South Africa | South Africa | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 59893884 | 9039 | 0 | TBC | weekly | |
8055 | 8055 | South Africa | South Africa | 0 | 2019-02-25 | 2019-03-03 | 7 | 2019 | 9 | 59893884 | 9479 | 0 | TBC | weekly | |
8056 | 8056 | South Africa | South Africa | 0 | 2019-03-04 | 2019-03-10 | 7 | 2019 | 10 | 59893884 | 9670 | 0 | TBC | weekly | |
8057 | 8057 | South Africa | South Africa | 0 | 2019-03-11 | 2019-03-17 | 7 | 2019 | 11 | 59893884 | 9171 | 0 | TBC | weekly | |
8058 | 8058 | South Africa | South Africa | 0 | 2019-03-18 | 2019-03-24 | 7 | 2019 | 12 | 59893884 | 9153 | 0 | TBC | weekly | |
8059 | 8059 | South Africa | South Africa | 0 | 2019-03-25 | 2019-03-31 | 7 | 2019 | 13 | 59893884 | 9289 | 0 | TBC | weekly | |
8060 | 8060 | South Africa | South Africa | 0 | 2019-04-01 | 2019-04-07 | 7 | 2019 | 14 | 59893884 | 9633 | 0 | TBC | weekly | |
8061 | 8061 | South Africa | South Africa | 0 | 2019-04-08 | 2019-04-14 | 7 | 2019 | 15 | 59893884 | 9636 | 0 | TBC | weekly | |
8062 | 8062 | South Africa | South Africa | 0 | 2019-04-15 | 2019-04-21 | 7 | 2019 | 16 | 59893884 | 9398 | 0 | TBC | weekly | |
8063 | 8063 | South Africa | South Africa | 0 | 2019-04-22 | 2019-04-28 | 7 | 2019 | 17 | 59893884 | 9891 | 0 | TBC | weekly | |
8064 | 8064 | South Africa | South Africa | 0 | 2019-04-29 | 2019-05-05 | 7 | 2019 | 18 | 59893884 | 10225 | 0 | TBC | weekly | |
8065 | 8065 | South Africa | South Africa | 0 | 2019-05-06 | 2019-05-12 | 7 | 2019 | 19 | 59893884 | 10462 | 0 | TBC | weekly | |
8066 | 8066 | South Africa | South Africa | 0 | 2019-05-13 | 2019-05-19 | 7 | 2019 | 20 | 59893884 | 10180 | 0 | TBC | weekly | |
8067 | 8067 | South Africa | South Africa | 0 | 2019-05-20 | 2019-05-26 | 7 | 2019 | 21 | 59893884 | 10372 | 0 | TBC | weekly | |
8068 | 8068 | South Africa | South Africa | 0 | 2019-05-27 | 2019-06-02 | 7 | 2019 | 22 | 59893884 | 10946 | 0 | TBC | weekly | |
8069 | 8069 | South Africa | South Africa | 0 | 2019-06-03 | 2019-06-09 | 7 | 2019 | 23 | 59893884 | 11814 | 0 | TBC | weekly | |
8070 | 8070 | South Africa | South Africa | 0 | 2019-06-10 | 2019-06-16 | 7 | 2019 | 24 | 59893884 | 11995 | 0 | TBC | weekly | |
8071 | 8071 | South Africa | South Africa | 0 | 2019-06-17 | 2019-06-23 | 7 | 2019 | 25 | 59893884 | 12395 | 0 | TBC | weekly | |
8072 | 8072 | South Africa | South Africa | 0 | 2019-06-24 | 2019-06-30 | 7 | 2019 | 26 | 59893884 | 11834 | 0 | TBC | weekly | |
8073 | 8073 | South Africa | South Africa | 0 | 2019-07-01 | 2019-07-07 | 7 | 2019 | 27 | 59893884 | 11641 | 0 | TBC | weekly | |
8074 | 8074 | South Africa | South Africa | 0 | 2019-07-08 | 2019-07-14 | 7 | 2019 | 28 | 59893884 | 11219 | 0 | TBC | weekly | |
8075 | 8075 | South Africa | South Africa | 0 | 2019-07-15 | 2019-07-21 | 7 | 2019 | 29 | 59893884 | 10608 | 0 | TBC | weekly | |
8076 | 8076 | South Africa | South Africa | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 59893884 | 10732 | 0 | TBC | weekly | |
8077 | 8077 | South Africa | South Africa | 0 | 2019-07-29 | 2019-08-04 | 7 | 2019 | 31 | 59893884 | 10903 | 0 | TBC | weekly | |
8078 | 8078 | South Africa | South Africa | 0 | 2019-08-05 | 2019-08-11 | 7 | 2019 | 32 | 59893884 | 11020 | 0 | TBC | weekly | |
8079 | 8079 | South Africa | South Africa | 0 | 2019-08-12 | 2019-08-18 | 7 | 2019 | 33 | 59893884 | 10651 | 0 | TBC | weekly | |
8080 | 8080 | South Africa | South Africa | 0 | 2019-08-19 | 2019-08-25 | 7 | 2019 | 34 | 59893884 | 10260 | 0 | TBC | weekly | |
8081 | 8081 | South Africa | South Africa | 0 | 2019-08-26 | 2019-09-01 | 7 | 2019 | 35 | 59893884 | 10022 | 0 | TBC | weekly | |
8082 | 8082 | South Africa | South Africa | 0 | 2019-09-02 | 2019-09-08 | 7 | 2019 | 36 | 59893884 | 10568 | 0 | TBC | weekly | |
8083 | 8083 | South Africa | South Africa | 0 | 2019-09-09 | 2019-09-15 | 7 | 2019 | 37 | 59893884 | 10132 | 0 | TBC | weekly | |
8084 | 8084 | South Africa | South Africa | 0 | 2019-09-16 | 2019-09-22 | 7 | 2019 | 38 | 59893884 | 9984 | 0 | TBC | weekly | |
8085 | 8085 | South Africa | South Africa | 0 | 2019-09-23 | 2019-09-29 | 7 | 2019 | 39 | 59893884 | 9557 | 0 | TBC | weekly | |
8086 | 8086 | South Africa | South Africa | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 59893884 | 10241 | 0 | TBC | weekly | |
8087 | 8087 | South Africa | South Africa | 0 | 2019-10-07 | 2019-10-13 | 7 | 2019 | 41 | 59893884 | 9748 | 0 | TBC | weekly | |
8088 | 8088 | South Africa | South Africa | 0 | 2019-10-14 | 2019-10-20 | 7 | 2019 | 42 | 59893884 | 9630 | 0 | TBC | weekly | |
8089 | 8089 | South Africa | South Africa | 0 | 2019-10-21 | 2019-10-27 | 7 | 2019 | 43 | 59893884 | 9588 | 0 | TBC | weekly | |
8090 | 8090 | South Africa | South Africa | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 59893884 | 9655 | 0 | TBC | weekly | |
8091 | 8091 | South Africa | South Africa | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 59893884 | 9917 | 0 | TBC | weekly | |
8092 | 8092 | South Africa | South Africa | 0 | 2019-11-11 | 2019-11-17 | 7 | 2019 | 46 | 59893884 | 9299 | 0 | TBC | weekly | |
8093 | 8093 | South Africa | South Africa | 0 | 2019-11-18 | 2019-11-24 | 7 | 2019 | 47 | 59893884 | 9311 | 0 | TBC | weekly | |
8094 | 8094 | South Africa | South Africa | 0 | 2019-11-25 | 2019-12-01 | 7 | 2019 | 48 | 59893884 | 9979 | 0 | TBC | weekly | |
8095 | 8095 | South Africa | South Africa | 0 | 2019-12-02 | 2019-12-08 | 7 | 2019 | 49 | 59893884 | 10301 | 0 | TBC | weekly | |
8096 | 8096 | South Africa | South Africa | 0 | 2019-12-09 | 2019-12-15 | 7 | 2019 | 50 | 59893884 | 9720 | 0 | TBC | weekly | |
8097 | 8097 | South Africa | South Africa | 0 | 2019-12-16 | 2019-12-22 | 7 | 2019 | 51 | 59893884 | 10169 | 0 | TBC | weekly | |
8098 | 8098 | South Africa | South Africa | 0 | 2019-12-23 | 2019-12-29 | 7 | 2019 | 52 | 59893884 | 10542 | 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]);