economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "South Africa" and year = 2018
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_date (date)
start_date (date) >30 ✖
- 2018-01-01 1
- 2018-01-08 1
- 2018-01-15 1
- 2018-01-22 1
- 2018-01-29 1
- 2018-02-05 1
- 2018-02-12 1
- 2018-02-19 1
- 2018-02-26 1
- 2018-03-05 1
- 2018-03-12 1
- 2018-03-19 1
- 2018-03-26 1
- 2018-04-02 1
- 2018-04-09 1
- 2018-04-16 1
- 2018-04-23 1
- 2018-04-30 1
- 2018-05-07 1
- 2018-05-14 1
- 2018-05-21 1
- 2018-05-28 1
- 2018-06-04 1
- 2018-06-11 1
- 2018-06-18 1
- 2018-06-25 1
- 2018-07-02 1
- 2018-07-09 1
- 2018-07-16 1
- 2018-07-23 1
- …
country 1
- South Africa · 52 ✖
cadence 1
- weekly 52
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7995 | 7995 | South Africa | South Africa | 0 | 2018-01-01 | 2018-01-07 | 7 | 2018 | 1 | 59893884 | 10251 | 0 | TBC | weekly | |
7996 | 7996 | South Africa | South Africa | 0 | 2018-01-08 | 2018-01-14 | 7 | 2018 | 2 | 59893884 | 9499 | 0 | TBC | weekly | |
7997 | 7997 | South Africa | South Africa | 0 | 2018-01-15 | 2018-01-21 | 7 | 2018 | 3 | 59893884 | 9276 | 0 | TBC | weekly | |
7998 | 7998 | South Africa | South Africa | 0 | 2018-01-22 | 2018-01-28 | 7 | 2018 | 4 | 59893884 | 8653 | 0 | TBC | weekly | |
7999 | 7999 | South Africa | South Africa | 0 | 2018-01-29 | 2018-02-04 | 7 | 2018 | 5 | 59893884 | 9014 | 0 | TBC | weekly | |
8000 | 8000 | South Africa | South Africa | 0 | 2018-02-05 | 2018-02-11 | 7 | 2018 | 6 | 59893884 | 9158 | 0 | TBC | weekly | |
8001 | 8001 | South Africa | South Africa | 0 | 2018-02-12 | 2018-02-18 | 7 | 2018 | 7 | 59893884 | 8860 | 0 | TBC | weekly | |
8002 | 8002 | South Africa | South Africa | 0 | 2018-02-19 | 2018-02-25 | 7 | 2018 | 8 | 59893884 | 8864 | 0 | TBC | weekly | |
8003 | 8003 | South Africa | South Africa | 0 | 2018-02-26 | 2018-03-04 | 7 | 2018 | 9 | 59893884 | 9181 | 0 | TBC | weekly | |
8004 | 8004 | South Africa | South Africa | 0 | 2018-03-05 | 2018-03-11 | 7 | 2018 | 10 | 59893884 | 9427 | 0 | TBC | weekly | |
8005 | 8005 | South Africa | South Africa | 0 | 2018-03-12 | 2018-03-18 | 7 | 2018 | 11 | 59893884 | 9093 | 0 | TBC | weekly | |
8006 | 8006 | South Africa | South Africa | 0 | 2018-03-19 | 2018-03-25 | 7 | 2018 | 12 | 59893884 | 9321 | 0 | TBC | weekly | |
8007 | 8007 | South Africa | South Africa | 0 | 2018-03-26 | 2018-04-01 | 7 | 2018 | 13 | 59893884 | 9690 | 0 | TBC | weekly | |
8008 | 8008 | South Africa | South Africa | 0 | 2018-04-02 | 2018-04-08 | 7 | 2018 | 14 | 59893884 | 10125 | 0 | TBC | weekly | |
8009 | 8009 | South Africa | South Africa | 0 | 2018-04-09 | 2018-04-15 | 7 | 2018 | 15 | 59893884 | 9414 | 0 | TBC | weekly | |
8010 | 8010 | South Africa | South Africa | 0 | 2018-04-16 | 2018-04-22 | 7 | 2018 | 16 | 59893884 | 9591 | 0 | TBC | weekly | |
8011 | 8011 | South Africa | South Africa | 0 | 2018-04-23 | 2018-04-29 | 7 | 2018 | 17 | 59893884 | 9779 | 0 | TBC | weekly | |
8012 | 8012 | South Africa | South Africa | 0 | 2018-04-30 | 2018-05-06 | 7 | 2018 | 18 | 59893884 | 10123 | 0 | TBC | weekly | |
8013 | 8013 | South Africa | South Africa | 0 | 2018-05-07 | 2018-05-13 | 7 | 2018 | 19 | 59893884 | 10420 | 0 | TBC | weekly | |
8014 | 8014 | South Africa | South Africa | 0 | 2018-05-14 | 2018-05-20 | 7 | 2018 | 20 | 59893884 | 10525 | 0 | TBC | weekly | |
8015 | 8015 | South Africa | South Africa | 0 | 2018-05-21 | 2018-05-27 | 7 | 2018 | 21 | 59893884 | 10193 | 0 | TBC | weekly | |
8016 | 8016 | South Africa | South Africa | 0 | 2018-05-28 | 2018-06-03 | 7 | 2018 | 22 | 59893884 | 10888 | 0 | TBC | weekly | |
8017 | 8017 | South Africa | South Africa | 0 | 2018-06-04 | 2018-06-10 | 7 | 2018 | 23 | 59893884 | 11834 | 0 | TBC | weekly | |
8018 | 8018 | South Africa | South Africa | 0 | 2018-06-11 | 2018-06-17 | 7 | 2018 | 24 | 59893884 | 11521 | 0 | TBC | weekly | |
8019 | 8019 | South Africa | South Africa | 0 | 2018-06-18 | 2018-06-24 | 7 | 2018 | 25 | 59893884 | 11600 | 0 | TBC | weekly | |
8020 | 8020 | South Africa | South Africa | 0 | 2018-06-25 | 2018-07-01 | 7 | 2018 | 26 | 59893884 | 11254 | 0 | TBC | weekly | |
8021 | 8021 | South Africa | South Africa | 0 | 2018-07-02 | 2018-07-08 | 7 | 2018 | 27 | 59893884 | 11990 | 0 | TBC | weekly | |
8022 | 8022 | South Africa | South Africa | 0 | 2018-07-09 | 2018-07-15 | 7 | 2018 | 28 | 59893884 | 10908 | 0 | TBC | weekly | |
8023 | 8023 | South Africa | South Africa | 0 | 2018-07-16 | 2018-07-22 | 7 | 2018 | 29 | 59893884 | 11223 | 0 | TBC | weekly | |
8024 | 8024 | South Africa | South Africa | 0 | 2018-07-23 | 2018-07-29 | 7 | 2018 | 30 | 59893884 | 10309 | 0 | TBC | weekly | |
8025 | 8025 | South Africa | South Africa | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 59893884 | 10648 | 0 | TBC | weekly | |
8026 | 8026 | South Africa | South Africa | 0 | 2018-08-06 | 2018-08-12 | 7 | 2018 | 32 | 59893884 | 10744 | 0 | TBC | weekly | |
8027 | 8027 | South Africa | South Africa | 0 | 2018-08-13 | 2018-08-19 | 7 | 2018 | 33 | 59893884 | 10689 | 0 | TBC | weekly | |
8028 | 8028 | South Africa | South Africa | 0 | 2018-08-20 | 2018-08-26 | 7 | 2018 | 34 | 59893884 | 10124 | 0 | TBC | weekly | |
8029 | 8029 | South Africa | South Africa | 0 | 2018-08-27 | 2018-09-02 | 7 | 2018 | 35 | 59893884 | 10540 | 0 | TBC | weekly | |
8030 | 8030 | South Africa | South Africa | 0 | 2018-09-03 | 2018-09-09 | 7 | 2018 | 36 | 59893884 | 11079 | 0 | TBC | weekly | |
8031 | 8031 | South Africa | South Africa | 0 | 2018-09-10 | 2018-09-16 | 7 | 2018 | 37 | 59893884 | 10758 | 0 | TBC | weekly | |
8032 | 8032 | South Africa | South Africa | 0 | 2018-09-17 | 2018-09-23 | 7 | 2018 | 38 | 59893884 | 10500 | 0 | TBC | weekly | |
8033 | 8033 | South Africa | South Africa | 0 | 2018-09-24 | 2018-09-30 | 7 | 2018 | 39 | 59893884 | 10394 | 0 | TBC | weekly | |
8034 | 8034 | South Africa | South Africa | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 59893884 | 10494 | 0 | TBC | weekly | |
8035 | 8035 | South Africa | South Africa | 0 | 2018-10-08 | 2018-10-14 | 7 | 2018 | 41 | 59893884 | 10067 | 0 | TBC | weekly | |
8036 | 8036 | South Africa | South Africa | 0 | 2018-10-15 | 2018-10-21 | 7 | 2018 | 42 | 59893884 | 9653 | 0 | TBC | weekly | |
8037 | 8037 | South Africa | South Africa | 0 | 2018-10-22 | 2018-10-28 | 7 | 2018 | 43 | 59893884 | 9729 | 0 | TBC | weekly | |
8038 | 8038 | South Africa | South Africa | 0 | 2018-10-29 | 2018-11-04 | 7 | 2018 | 44 | 59893884 | 9878 | 0 | TBC | weekly | |
8039 | 8039 | South Africa | South Africa | 0 | 2018-11-05 | 2018-11-11 | 7 | 2018 | 45 | 59893884 | 9660 | 0 | TBC | weekly | |
8040 | 8040 | South Africa | South Africa | 0 | 2018-11-12 | 2018-11-18 | 7 | 2018 | 46 | 59893884 | 9940 | 0 | TBC | weekly | |
8041 | 8041 | South Africa | South Africa | 0 | 2018-11-19 | 2018-11-25 | 7 | 2018 | 47 | 59893884 | 9431 | 0 | TBC | weekly | |
8042 | 8042 | South Africa | South Africa | 0 | 2018-11-26 | 2018-12-02 | 7 | 2018 | 48 | 59893884 | 9813 | 0 | TBC | weekly | |
8043 | 8043 | South Africa | South Africa | 0 | 2018-12-03 | 2018-12-09 | 7 | 2018 | 49 | 59893884 | 10062 | 0 | TBC | weekly | |
8044 | 8044 | South Africa | South Africa | 0 | 2018-12-10 | 2018-12-16 | 7 | 2018 | 50 | 59893884 | 9542 | 0 | TBC | weekly | |
8045 | 8045 | South Africa | South Africa | 0 | 2018-12-17 | 2018-12-23 | 7 | 2018 | 51 | 59893884 | 10448 | 0 | TBC | weekly | |
8046 | 8046 | South Africa | South Africa | 0 | 2018-12-24 | 2018-12-30 | 7 | 2018 | 52 | 59893884 | 10812 | 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]);