economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
55 rows where cadence = "monthly", country = "Azerbaijan" and days = 31
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: year, covid_deaths, month, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16698 | 16698 | Azerbaijan | Azerbaijan | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 10358078 | 5000 | 0 | TBC | monthly | 1 | |
16700 | 16700 | Azerbaijan | Azerbaijan | 0 | 2015-03-01 | 2015-03-31 | 31 | 2015 | 10358078 | 4200 | 0 | TBC | monthly | 3 | |
16702 | 16702 | Azerbaijan | Azerbaijan | 0 | 2015-05-01 | 2015-05-31 | 31 | 2015 | 10358078 | 4600 | 0 | TBC | monthly | 5 | |
16704 | 16704 | Azerbaijan | Azerbaijan | 0 | 2015-07-01 | 2015-07-31 | 31 | 2015 | 10358078 | 4700 | 0 | TBC | monthly | 7 | |
16705 | 16705 | Azerbaijan | Azerbaijan | 0 | 2015-08-01 | 2015-08-31 | 31 | 2015 | 10358078 | 4400 | 0 | TBC | monthly | 8 | |
16707 | 16707 | Azerbaijan | Azerbaijan | 0 | 2015-10-01 | 2015-10-31 | 31 | 2015 | 10358078 | 4500 | 0 | TBC | monthly | 10 | |
16709 | 16709 | Azerbaijan | Azerbaijan | 0 | 2015-12-01 | 2015-12-31 | 31 | 2015 | 10358078 | 4700 | 0 | TBC | monthly | 12 | |
16710 | 16710 | Azerbaijan | Azerbaijan | 0 | 2016-01-01 | 2016-01-31 | 31 | 2016 | 10358078 | 4953 | 0 | TBC | monthly | 1 | |
16712 | 16712 | Azerbaijan | Azerbaijan | 0 | 2016-03-01 | 2016-03-31 | 31 | 2016 | 10358078 | 4566 | 0 | TBC | monthly | 3 | |
16714 | 16714 | Azerbaijan | Azerbaijan | 0 | 2016-05-01 | 2016-05-31 | 31 | 2016 | 10358078 | 4574 | 0 | TBC | monthly | 5 | |
16716 | 16716 | Azerbaijan | Azerbaijan | 0 | 2016-07-01 | 2016-07-31 | 31 | 2016 | 10358078 | 4586 | 0 | TBC | monthly | 7 | |
16717 | 16717 | Azerbaijan | Azerbaijan | 0 | 2016-08-01 | 2016-08-31 | 31 | 2016 | 10358078 | 4761 | 0 | TBC | monthly | 8 | |
16719 | 16719 | Azerbaijan | Azerbaijan | 0 | 2016-10-01 | 2016-10-31 | 31 | 2016 | 10358078 | 4524 | 0 | TBC | monthly | 10 | |
16721 | 16721 | Azerbaijan | Azerbaijan | 0 | 2016-12-01 | 2016-12-31 | 31 | 2016 | 10358078 | 5065 | 0 | TBC | monthly | 12 | |
16722 | 16722 | Azerbaijan | Azerbaijan | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 10358078 | 6085 | 0 | TBC | monthly | 1 | |
16724 | 16724 | Azerbaijan | Azerbaijan | 0 | 2017-03-01 | 2017-03-31 | 31 | 2017 | 10358078 | 4790 | 0 | TBC | monthly | 3 | |
16726 | 16726 | Azerbaijan | Azerbaijan | 0 | 2017-05-01 | 2017-05-31 | 31 | 2017 | 10358078 | 4954 | 0 | TBC | monthly | 5 | |
16728 | 16728 | Azerbaijan | Azerbaijan | 0 | 2017-07-01 | 2017-07-31 | 31 | 2017 | 10358078 | 4804 | 0 | TBC | monthly | 7 | |
16729 | 16729 | Azerbaijan | Azerbaijan | 0 | 2017-08-01 | 2017-08-31 | 31 | 2017 | 10358078 | 4723 | 0 | TBC | monthly | 8 | |
16731 | 16731 | Azerbaijan | Azerbaijan | 0 | 2017-10-01 | 2017-10-31 | 31 | 2017 | 10358078 | 4606 | 0 | TBC | monthly | 10 | |
16733 | 16733 | Azerbaijan | Azerbaijan | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 10358078 | 4791 | 0 | TBC | monthly | 12 | |
16734 | 16734 | Azerbaijan | Azerbaijan | 0 | 2018-01-01 | 2018-01-31 | 31 | 2018 | 10358078 | 5284 | 0 | TBC | monthly | 1 | |
16736 | 16736 | Azerbaijan | Azerbaijan | 0 | 2018-03-01 | 2018-03-31 | 31 | 2018 | 10358078 | 4903 | 0 | TBC | monthly | 3 | |
16738 | 16738 | Azerbaijan | Azerbaijan | 0 | 2018-05-01 | 2018-05-31 | 31 | 2018 | 10358078 | 4871 | 0 | TBC | monthly | 5 | |
16740 | 16740 | Azerbaijan | Azerbaijan | 0 | 2018-07-01 | 2018-07-31 | 31 | 2018 | 10358078 | 5520 | 0 | TBC | monthly | 7 | |
16741 | 16741 | Azerbaijan | Azerbaijan | 0 | 2018-08-01 | 2018-08-31 | 31 | 2018 | 10358078 | 4684 | 0 | TBC | monthly | 8 | |
16743 | 16743 | Azerbaijan | Azerbaijan | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 10358078 | 4546 | 0 | TBC | monthly | 10 | |
16745 | 16745 | Azerbaijan | Azerbaijan | 0 | 2018-12-01 | 2018-12-31 | 31 | 2018 | 10358078 | 4517 | 0 | TBC | monthly | 12 | |
16746 | 16746 | Azerbaijan | Azerbaijan | 0 | 2019-01-01 | 2019-01-31 | 31 | 2019 | 10358078 | 5423 | 0 | TBC | monthly | 1 | |
16748 | 16748 | Azerbaijan | Azerbaijan | 0 | 2019-03-01 | 2019-03-31 | 31 | 2019 | 10358078 | 4563 | 0 | TBC | monthly | 3 | |
16750 | 16750 | Azerbaijan | Azerbaijan | 0 | 2019-05-01 | 2019-05-31 | 31 | 2019 | 10358078 | 4555 | 0 | TBC | monthly | 5 | |
16752 | 16752 | Azerbaijan | Azerbaijan | 0 | 2019-07-01 | 2019-07-31 | 31 | 2019 | 10358078 | 4902 | 0 | TBC | monthly | 7 | |
16753 | 16753 | Azerbaijan | Azerbaijan | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 10358078 | 4269 | 0 | TBC | monthly | 8 | |
16755 | 16755 | Azerbaijan | Azerbaijan | 0 | 2019-10-01 | 2019-10-31 | 31 | 2019 | 10358078 | 4386 | 0 | TBC | monthly | 10 | |
16757 | 16757 | Azerbaijan | Azerbaijan | 0 | 2019-12-01 | 2019-12-31 | 31 | 2019 | 10358078 | 5210 | 0 | TBC | monthly | 12 | |
16758 | 16758 | Azerbaijan | Azerbaijan | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 10358078 | 5177 | 0 | TBC | monthly | 1 | |
16760 | 16760 | Azerbaijan | Azerbaijan | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 10358078 | 5792 | 5 | TBC | monthly | 3 | |
16762 | 16762 | Azerbaijan | Azerbaijan | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 10358078 | 4294 | 39 | TBC | monthly | 5 | |
16764 | 16764 | Azerbaijan | Azerbaijan | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 10358078 | 6410 | 235 | TBC | monthly | 7 | |
16765 | 16765 | Azerbaijan | Azerbaijan | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 10358078 | 5049 | 86 | TBC | monthly | 8 | |
16767 | 16767 | Azerbaijan | Azerbaijan | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 10358078 | 5774 | 139 | TBC | monthly | 10 | |
16769 | 16769 | Azerbaijan | Azerbaijan | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 10358078 | 14500 | 1249 | TBC | monthly | 12 | |
16770 | 16770 | Azerbaijan | Azerbaijan | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 10358078 | 7972 | 491 | TBC | monthly | 1 | |
16772 | 16772 | Azerbaijan | Azerbaijan | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 10358078 | 5676 | 347 | TBC | monthly | 3 | |
16774 | 16774 | Azerbaijan | Azerbaijan | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 10358078 | 5435 | 396 | TBC | monthly | 5 | |
16776 | 16776 | Azerbaijan | Azerbaijan | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 10358078 | 5087 | 49 | TBC | monthly | 7 | |
16777 | 16777 | Azerbaijan | Azerbaijan | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 10358078 | 6499 | 613 | TBC | monthly | 8 | |
16779 | 16779 | Azerbaijan | Azerbaijan | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 10358078 | 5978 | 549 | TBC | monthly | 10 | |
16781 | 16781 | Azerbaijan | Azerbaijan | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 10358078 | 7117 | 502 | TBC | monthly | 12 | |
16782 | 16782 | Azerbaijan | Azerbaijan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 10358078 | 6009 | 376 | TBC | monthly | 1 | |
16784 | 16784 | Azerbaijan | Azerbaijan | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 10358078 | 6166 | 275 | TBC | monthly | 3 | |
16786 | 16786 | Azerbaijan | Azerbaijan | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 10358078 | 4350 | 4 | TBC | monthly | 5 | |
16788 | 16788 | Azerbaijan | Azerbaijan | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 10358078 | 4594 | 31 | TBC | monthly | 7 | |
16789 | 16789 | Azerbaijan | Azerbaijan | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 10358078 | 4575 | 57 | TBC | monthly | 8 | |
16791 | 16791 | Azerbaijan | Azerbaijan | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 10358078 | 4085 | 27 | TBC | monthly | 10 |
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]);