economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
73 rows where country = "Gibraltar"
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: days, year, total_deaths, covid_deaths, month
start_date (date) 73 ✖
- 2015-01-01 1
- 2015-02-01 1
- 2015-03-01 1
- 2015-04-01 1
- 2015-05-01 1
- 2015-06-01 1
- 2015-07-01 1
- 2015-08-01 1
- 2015-09-01 1
- 2015-10-01 1
- 2015-11-01 1
- 2015-12-01 1
- 2016-01-01 1
- 2016-02-01 1
- 2016-03-01 1
- 2016-04-01 1
- 2016-05-01 1
- 2016-06-01 1
- 2016-07-01 1
- 2016-08-01 1
- 2016-09-01 1
- 2016-10-01 1
- 2016-11-01 1
- 2016-12-01 1
- 2017-01-01 1
- 2017-02-01 1
- 2017-03-01 1
- 2017-04-01 1
- 2017-05-01 1
- 2017-06-01 1
- 2017-07-01 1
- 2017-08-01 1
- 2017-09-01 1
- 2017-10-01 1
- 2017-11-01 1
- 2017-12-01 1
- 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
- 2021-01-01 1
end_date (date) 73 ✖
- 2015-01-31 1
- 2015-02-28 1
- 2015-03-31 1
- 2015-04-30 1
- 2015-05-31 1
- 2015-06-30 1
- 2015-07-31 1
- 2015-08-31 1
- 2015-09-30 1
- 2015-10-31 1
- 2015-11-30 1
- 2015-12-31 1
- 2016-01-31 1
- 2016-02-29 1
- 2016-03-31 1
- 2016-04-30 1
- 2016-05-31 1
- 2016-06-30 1
- 2016-07-31 1
- 2016-08-31 1
- 2016-09-30 1
- 2016-10-31 1
- 2016-11-30 1
- 2016-12-31 1
- 2017-01-31 1
- 2017-02-28 1
- 2017-03-31 1
- 2017-04-30 1
- 2017-05-31 1
- 2017-06-30 1
- 2017-07-31 1
- 2017-08-31 1
- 2017-09-30 1
- 2017-10-31 1
- 2017-11-30 1
- 2017-12-31 1
- 2018-01-31 1
- 2018-02-28 1
- 2018-03-31 1
- 2018-04-30 1
- 2018-05-31 1
- 2018-06-30 1
- 2018-07-31 1
- 2018-08-31 1
- 2018-09-30 1
- 2018-10-31 1
- 2018-11-30 1
- 2018-12-31 1
- 2019-01-31 1
- 2019-02-28 1
- 2019-03-31 1
- 2019-04-30 1
- 2019-05-31 1
- 2019-06-30 1
- 2019-07-31 1
- 2019-08-31 1
- 2019-09-30 1
- 2019-10-31 1
- 2019-11-30 1
- 2019-12-31 1
- 2020-01-31 1
- 2020-02-29 1
- 2020-03-31 1
- 2020-04-30 1
- 2020-05-31 1
- 2020-06-30 1
- 2020-07-31 1
- 2020-08-31 1
- 2020-09-30 1
- 2020-10-31 1
- 2020-11-30 1
- 2020-12-31 1
- 2021-01-31 1
country 1
- Gibraltar · 73 ✖
cadence 1
- monthly 73
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12102 | 12102 | Gibraltar | Gibraltar | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 32677 | 25 | 0 | TBC | monthly | 1 | |
12103 | 12103 | Gibraltar | Gibraltar | 0 | 2015-02-01 | 2015-02-28 | 28 | 2015 | 32677 | 26 | 0 | TBC | monthly | 2 | |
12104 | 12104 | Gibraltar | Gibraltar | 0 | 2015-03-01 | 2015-03-31 | 31 | 2015 | 32677 | 22 | 0 | TBC | monthly | 3 | |
12105 | 12105 | Gibraltar | Gibraltar | 0 | 2015-04-01 | 2015-04-30 | 30 | 2015 | 32677 | 21 | 0 | TBC | monthly | 4 | |
12106 | 12106 | Gibraltar | Gibraltar | 0 | 2015-05-01 | 2015-05-31 | 31 | 2015 | 32677 | 19 | 0 | TBC | monthly | 5 | |
12107 | 12107 | Gibraltar | Gibraltar | 0 | 2015-06-01 | 2015-06-30 | 30 | 2015 | 32677 | 19 | 0 | TBC | monthly | 6 | |
12108 | 12108 | Gibraltar | Gibraltar | 0 | 2015-07-01 | 2015-07-31 | 31 | 2015 | 32677 | 15 | 0 | TBC | monthly | 7 | |
12109 | 12109 | Gibraltar | Gibraltar | 0 | 2015-08-01 | 2015-08-31 | 31 | 2015 | 32677 | 22 | 0 | TBC | monthly | 8 | |
12110 | 12110 | Gibraltar | Gibraltar | 0 | 2015-09-01 | 2015-09-30 | 30 | 2015 | 32677 | 16 | 0 | TBC | monthly | 9 | |
12111 | 12111 | Gibraltar | Gibraltar | 0 | 2015-10-01 | 2015-10-31 | 31 | 2015 | 32677 | 19 | 0 | TBC | monthly | 10 | |
12112 | 12112 | Gibraltar | Gibraltar | 0 | 2015-11-01 | 2015-11-30 | 30 | 2015 | 32677 | 12 | 0 | TBC | monthly | 11 | |
12113 | 12113 | Gibraltar | Gibraltar | 0 | 2015-12-01 | 2015-12-31 | 31 | 2015 | 32677 | 25 | 0 | TBC | monthly | 12 | |
12114 | 12114 | Gibraltar | Gibraltar | 0 | 2016-01-01 | 2016-01-31 | 31 | 2016 | 32677 | 31 | 0 | TBC | monthly | 1 | |
12115 | 12115 | Gibraltar | Gibraltar | 0 | 2016-02-01 | 2016-02-29 | 29 | 2016 | 32677 | 30 | 0 | TBC | monthly | 2 | |
12116 | 12116 | Gibraltar | Gibraltar | 0 | 2016-03-01 | 2016-03-31 | 31 | 2016 | 32677 | 23 | 0 | TBC | monthly | 3 | |
12117 | 12117 | Gibraltar | Gibraltar | 0 | 2016-04-01 | 2016-04-30 | 30 | 2016 | 32677 | 20 | 0 | TBC | monthly | 4 | |
12118 | 12118 | Gibraltar | Gibraltar | 0 | 2016-05-01 | 2016-05-31 | 31 | 2016 | 32677 | 17 | 0 | TBC | monthly | 5 | |
12119 | 12119 | Gibraltar | Gibraltar | 0 | 2016-06-01 | 2016-06-30 | 30 | 2016 | 32677 | 22 | 0 | TBC | monthly | 6 | |
12120 | 12120 | Gibraltar | Gibraltar | 0 | 2016-07-01 | 2016-07-31 | 31 | 2016 | 32677 | 16 | 0 | TBC | monthly | 7 | |
12121 | 12121 | Gibraltar | Gibraltar | 0 | 2016-08-01 | 2016-08-31 | 31 | 2016 | 32677 | 18 | 0 | TBC | monthly | 8 | |
12122 | 12122 | Gibraltar | Gibraltar | 0 | 2016-09-01 | 2016-09-30 | 30 | 2016 | 32677 | 22 | 0 | TBC | monthly | 9 | |
12123 | 12123 | Gibraltar | Gibraltar | 0 | 2016-10-01 | 2016-10-31 | 31 | 2016 | 32677 | 23 | 0 | TBC | monthly | 10 | |
12124 | 12124 | Gibraltar | Gibraltar | 0 | 2016-11-01 | 2016-11-30 | 30 | 2016 | 32677 | 24 | 0 | TBC | monthly | 11 | |
12125 | 12125 | Gibraltar | Gibraltar | 0 | 2016-12-01 | 2016-12-31 | 31 | 2016 | 32677 | 25 | 0 | TBC | monthly | 12 | |
12126 | 12126 | Gibraltar | Gibraltar | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 32677 | 26 | 0 | TBC | monthly | 1 | |
12127 | 12127 | Gibraltar | Gibraltar | 0 | 2017-02-01 | 2017-02-28 | 28 | 2017 | 32677 | 22 | 0 | TBC | monthly | 2 | |
12128 | 12128 | Gibraltar | Gibraltar | 0 | 2017-03-01 | 2017-03-31 | 31 | 2017 | 32677 | 17 | 0 | TBC | monthly | 3 | |
12129 | 12129 | Gibraltar | Gibraltar | 0 | 2017-04-01 | 2017-04-30 | 30 | 2017 | 32677 | 13 | 0 | TBC | monthly | 4 | |
12130 | 12130 | Gibraltar | Gibraltar | 0 | 2017-05-01 | 2017-05-31 | 31 | 2017 | 32677 | 28 | 0 | TBC | monthly | 5 | |
12131 | 12131 | Gibraltar | Gibraltar | 0 | 2017-06-01 | 2017-06-30 | 30 | 2017 | 32677 | 23 | 0 | TBC | monthly | 6 | |
12132 | 12132 | Gibraltar | Gibraltar | 0 | 2017-07-01 | 2017-07-31 | 31 | 2017 | 32677 | 17 | 0 | TBC | monthly | 7 | |
12133 | 12133 | Gibraltar | Gibraltar | 0 | 2017-08-01 | 2017-08-31 | 31 | 2017 | 32677 | 24 | 0 | TBC | monthly | 8 | |
12134 | 12134 | Gibraltar | Gibraltar | 0 | 2017-09-01 | 2017-09-30 | 30 | 2017 | 32677 | 29 | 0 | TBC | monthly | 9 | |
12135 | 12135 | Gibraltar | Gibraltar | 0 | 2017-10-01 | 2017-10-31 | 31 | 2017 | 32677 | 27 | 0 | TBC | monthly | 10 | |
12136 | 12136 | Gibraltar | Gibraltar | 0 | 2017-11-01 | 2017-11-30 | 30 | 2017 | 32677 | 25 | 0 | TBC | monthly | 11 | |
12137 | 12137 | Gibraltar | Gibraltar | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 32677 | 35 | 0 | TBC | monthly | 12 | |
12138 | 12138 | Gibraltar | Gibraltar | 0 | 2018-01-01 | 2018-01-31 | 31 | 2018 | 32677 | 39 | 0 | TBC | monthly | 1 | |
12139 | 12139 | Gibraltar | Gibraltar | 0 | 2018-02-01 | 2018-02-28 | 28 | 2018 | 32677 | 29 | 0 | TBC | monthly | 2 | |
12140 | 12140 | Gibraltar | Gibraltar | 0 | 2018-03-01 | 2018-03-31 | 31 | 2018 | 32677 | 25 | 0 | TBC | monthly | 3 | |
12141 | 12141 | Gibraltar | Gibraltar | 0 | 2018-04-01 | 2018-04-30 | 30 | 2018 | 32677 | 28 | 0 | TBC | monthly | 4 | |
12142 | 12142 | Gibraltar | Gibraltar | 0 | 2018-05-01 | 2018-05-31 | 31 | 2018 | 32677 | 27 | 0 | TBC | monthly | 5 | |
12143 | 12143 | Gibraltar | Gibraltar | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 32677 | 21 | 0 | TBC | monthly | 6 | |
12144 | 12144 | Gibraltar | Gibraltar | 0 | 2018-07-01 | 2018-07-31 | 31 | 2018 | 32677 | 21 | 0 | TBC | monthly | 7 | |
12145 | 12145 | Gibraltar | Gibraltar | 0 | 2018-08-01 | 2018-08-31 | 31 | 2018 | 32677 | 23 | 0 | TBC | monthly | 8 | |
12146 | 12146 | Gibraltar | Gibraltar | 0 | 2018-09-01 | 2018-09-30 | 30 | 2018 | 32677 | 30 | 0 | TBC | monthly | 9 | |
12147 | 12147 | Gibraltar | Gibraltar | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 32677 | 22 | 0 | TBC | monthly | 10 | |
12148 | 12148 | Gibraltar | Gibraltar | 0 | 2018-11-01 | 2018-11-30 | 30 | 2018 | 32677 | 21 | 0 | TBC | monthly | 11 | |
12149 | 12149 | Gibraltar | Gibraltar | 0 | 2018-12-01 | 2018-12-31 | 31 | 2018 | 32677 | 28 | 0 | TBC | monthly | 12 | |
12150 | 12150 | Gibraltar | Gibraltar | 0 | 2019-01-01 | 2019-01-31 | 31 | 2019 | 32677 | 36 | 0 | TBC | monthly | 1 | |
12151 | 12151 | Gibraltar | Gibraltar | 0 | 2019-02-01 | 2019-02-28 | 28 | 2019 | 32677 | 26 | 0 | TBC | monthly | 2 | |
12152 | 12152 | Gibraltar | Gibraltar | 0 | 2019-03-01 | 2019-03-31 | 31 | 2019 | 32677 | 27 | 0 | TBC | monthly | 3 | |
12153 | 12153 | Gibraltar | Gibraltar | 0 | 2019-04-01 | 2019-04-30 | 30 | 2019 | 32677 | 22 | 0 | TBC | monthly | 4 | |
12154 | 12154 | Gibraltar | Gibraltar | 0 | 2019-05-01 | 2019-05-31 | 31 | 2019 | 32677 | 15 | 0 | TBC | monthly | 5 | |
12155 | 12155 | Gibraltar | Gibraltar | 0 | 2019-06-01 | 2019-06-30 | 30 | 2019 | 32677 | 17 | 0 | TBC | monthly | 6 | |
12156 | 12156 | Gibraltar | Gibraltar | 0 | 2019-07-01 | 2019-07-31 | 31 | 2019 | 32677 | 20 | 0 | TBC | monthly | 7 | |
12157 | 12157 | Gibraltar | Gibraltar | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 32677 | 21 | 0 | TBC | monthly | 8 | |
12158 | 12158 | Gibraltar | Gibraltar | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 32677 | 17 | 0 | TBC | monthly | 9 | |
12159 | 12159 | Gibraltar | Gibraltar | 0 | 2019-10-01 | 2019-10-31 | 31 | 2019 | 32677 | 21 | 0 | TBC | monthly | 10 | |
12160 | 12160 | Gibraltar | Gibraltar | 0 | 2019-11-01 | 2019-11-30 | 30 | 2019 | 32677 | 16 | 0 | TBC | monthly | 11 | |
12161 | 12161 | Gibraltar | Gibraltar | 0 | 2019-12-01 | 2019-12-31 | 31 | 2019 | 32677 | 30 | 0 | TBC | monthly | 12 | |
12162 | 12162 | Gibraltar | Gibraltar | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 32677 | 34 | 0 | TBC | monthly | 1 | |
12163 | 12163 | Gibraltar | Gibraltar | 0 | 2020-02-01 | 2020-02-29 | 29 | 2020 | 32677 | 27 | 0 | TBC | monthly | 2 | |
12164 | 12164 | Gibraltar | Gibraltar | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 32677 | 24 | 0 | TBC | monthly | 3 | |
12165 | 12165 | Gibraltar | Gibraltar | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 32677 | 21 | 0 | TBC | monthly | 4 | |
12166 | 12166 | Gibraltar | Gibraltar | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 32677 | 12 | 0 | TBC | monthly | 5 | |
12167 | 12167 | Gibraltar | Gibraltar | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 32677 | 16 | 0 | TBC | monthly | 6 | |
12168 | 12168 | Gibraltar | Gibraltar | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 32677 | 23 | 0 | TBC | monthly | 7 | |
12169 | 12169 | Gibraltar | Gibraltar | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 32677 | 22 | 0 | TBC | monthly | 8 | |
12170 | 12170 | Gibraltar | Gibraltar | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 32677 | 23 | 0 | TBC | monthly | 9 | |
12171 | 12171 | Gibraltar | Gibraltar | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 32677 | 25 | 0 | TBC | monthly | 10 | |
12172 | 12172 | Gibraltar | Gibraltar | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 32677 | 26 | 5 | TBC | monthly | 11 | |
12173 | 12173 | Gibraltar | Gibraltar | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 32677 | 17 | 2 | TBC | monthly | 12 | |
12174 | 12174 | Gibraltar | Gibraltar | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 32677 | 89 | 70 | TBC | monthly | 1 |
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]);