economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
36 rows where country = "Algeria"
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: days, year, total_deaths, covid_deaths, end_date (date)
start_date (date) 36 ✖
- 2018-01-01 1
- 2018-02-01 1
- 2018-03-01 1
- 2018-04-01 1
- 2018-05-01 1
- 2018-06-01 1
- 2018-07-01 1
- 2018-08-01 1
- 2018-09-01 1
- 2018-10-01 1
- 2018-11-01 1
- 2018-12-01 1
- 2019-01-01 1
- 2019-02-01 1
- 2019-03-01 1
- 2019-04-01 1
- 2019-05-01 1
- 2019-06-01 1
- 2019-07-01 1
- 2019-08-01 1
- 2019-09-01 1
- 2019-10-01 1
- 2019-11-01 1
- 2019-12-01 1
- 2020-01-01 1
- 2020-02-01 1
- 2020-03-01 1
- 2020-04-01 1
- 2020-05-01 1
- 2020-06-01 1
- 2020-07-01 1
- 2020-08-01 1
- 2020-09-01 1
- 2020-10-01 1
- 2020-11-01 1
- 2020-12-01 1
country 1
- Algeria · 36 ✖
cadence 1
- monthly 36
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10751 | 10751 | Algeria | Algeria | 0 | 2018-01-01 | 2018-01-31 | 31 | 2018 | 44903228 | 16409.1 | 0 | TBC | monthly | 1 | |
10752 | 10752 | Algeria | Algeria | 0 | 2018-02-01 | 2018-02-28 | 28 | 2018 | 44903228 | 15409.1 | 0 | TBC | monthly | 2 | |
10753 | 10753 | Algeria | Algeria | 0 | 2018-03-01 | 2018-03-31 | 31 | 2018 | 44903228 | 15227.3 | 0 | TBC | monthly | 3 | |
10754 | 10754 | Algeria | Algeria | 0 | 2018-04-01 | 2018-04-30 | 30 | 2018 | 44903228 | 14181.8 | 0 | TBC | monthly | 4 | |
10755 | 10755 | Algeria | Algeria | 0 | 2018-05-01 | 2018-05-31 | 31 | 2018 | 44903228 | 14159.1 | 0 | TBC | monthly | 5 | |
10756 | 10756 | Algeria | Algeria | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 44903228 | 13613.6 | 0 | TBC | monthly | 6 | |
10757 | 10757 | Algeria | Algeria | 0 | 2018-07-01 | 2018-07-31 | 31 | 2018 | 44903228 | 14704.5 | 0 | TBC | monthly | 7 | |
10758 | 10758 | Algeria | Algeria | 0 | 2018-08-01 | 2018-08-31 | 31 | 2018 | 44903228 | 14477.3 | 0 | TBC | monthly | 8 | |
10759 | 10759 | Algeria | Algeria | 0 | 2018-09-01 | 2018-09-30 | 30 | 2018 | 44903228 | 13500 | 0 | TBC | monthly | 9 | |
10760 | 10760 | Algeria | Algeria | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 44903228 | 14727.3 | 0 | TBC | monthly | 10 | |
10761 | 10761 | Algeria | Algeria | 0 | 2018-11-01 | 2018-11-30 | 30 | 2018 | 44903228 | 14909.1 | 0 | TBC | monthly | 11 | |
10762 | 10762 | Algeria | Algeria | 0 | 2018-12-01 | 2018-12-31 | 31 | 2018 | 44903228 | 15818.2 | 0 | TBC | monthly | 12 | |
10763 | 10763 | Algeria | Algeria | 0 | 2019-01-01 | 2019-01-31 | 31 | 2019 | 44903228 | 17783.6 | 0 | TBC | monthly | 1 | |
10764 | 10764 | Algeria | Algeria | 0 | 2019-02-01 | 2019-02-28 | 28 | 2019 | 44903228 | 15330.7 | 0 | TBC | monthly | 2 | |
10765 | 10765 | Algeria | Algeria | 0 | 2019-03-01 | 2019-03-31 | 31 | 2019 | 44903228 | 15366.7 | 0 | TBC | monthly | 3 | |
10766 | 10766 | Algeria | Algeria | 0 | 2019-04-01 | 2019-04-30 | 30 | 2019 | 44903228 | 14464.9 | 0 | TBC | monthly | 4 | |
10767 | 10767 | Algeria | Algeria | 0 | 2019-05-01 | 2019-05-31 | 31 | 2019 | 44903228 | 14464.9 | 0 | TBC | monthly | 5 | |
10768 | 10768 | Algeria | Algeria | 0 | 2019-06-01 | 2019-06-30 | 30 | 2019 | 44903228 | 14284.6 | 0 | TBC | monthly | 6 | |
10769 | 10769 | Algeria | Algeria | 0 | 2019-07-01 | 2019-07-31 | 31 | 2019 | 44903228 | 14753.5 | 0 | TBC | monthly | 7 | |
10770 | 10770 | Algeria | Algeria | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 44903228 | 14969.9 | 0 | TBC | monthly | 8 | |
10771 | 10771 | Algeria | Algeria | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 44903228 | 14032.1 | 0 | TBC | monthly | 9 | |
10772 | 10772 | Algeria | Algeria | 0 | 2019-10-01 | 2019-10-31 | 31 | 2019 | 44903228 | 14789.6 | 0 | TBC | monthly | 10 | |
10773 | 10773 | Algeria | Algeria | 0 | 2019-11-01 | 2019-11-30 | 30 | 2019 | 44903228 | 15042.1 | 0 | TBC | monthly | 11 | |
10774 | 10774 | Algeria | Algeria | 0 | 2019-12-01 | 2019-12-31 | 31 | 2019 | 44903228 | 16160.3 | 0 | TBC | monthly | 12 | |
10775 | 10775 | Algeria | Algeria | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 44903228 | 17195 | 0 | TBC | monthly | 1 | |
10776 | 10776 | Algeria | Algeria | 0 | 2020-02-01 | 2020-02-29 | 29 | 2020 | 44903228 | 15810 | 0 | TBC | monthly | 2 | |
10777 | 10777 | Algeria | Algeria | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 44903228 | 15882 | 44 | TBC | monthly | 3 | |
10778 | 10778 | Algeria | Algeria | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 44903228 | 15020 | 406 | TBC | monthly | 4 | |
10779 | 10779 | Algeria | Algeria | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 44903228 | 14833 | 203 | TBC | monthly | 5 | |
10780 | 10780 | Algeria | Algeria | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 44903228 | 18100 | 259 | TBC | monthly | 6 | |
10781 | 10781 | Algeria | Algeria | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 44903228 | 32170 | 298 | TBC | monthly | 7 | |
10782 | 10782 | Algeria | Algeria | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 44903228 | 23413 | 300 | TBC | monthly | 8 | |
10783 | 10783 | Algeria | Algeria | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 44903228 | 17043 | 226 | TBC | monthly | 9 | |
10784 | 10784 | Algeria | Algeria | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 44903228 | 18665 | 228 | TBC | monthly | 10 | |
10785 | 10785 | Algeria | Algeria | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 44903228 | 26100 | 467 | TBC | monthly | 11 | |
10786 | 10786 | Algeria | Algeria | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 44903228 | 21397 | 325 | TBC | monthly | 12 |
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]);