economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "Bulgaria", days = 7 and year = 2017
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2084 | 2084 | Bulgaria | Bulgaria | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 6781955 | 3169 | 0 | TBC | weekly | |
2085 | 2085 | Bulgaria | Bulgaria | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 6781955 | 3222 | 0 | TBC | weekly | |
2086 | 2086 | Bulgaria | Bulgaria | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 6781955 | 2814 | 0 | TBC | weekly | |
2087 | 2087 | Bulgaria | Bulgaria | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 6781955 | 2627 | 0 | TBC | weekly | |
2088 | 2088 | Bulgaria | Bulgaria | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 6781955 | 2525 | 0 | TBC | weekly | |
2089 | 2089 | Bulgaria | Bulgaria | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 6781955 | 2347 | 0 | TBC | weekly | |
2090 | 2090 | Bulgaria | Bulgaria | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 6781955 | 2352 | 0 | TBC | weekly | |
2091 | 2091 | Bulgaria | Bulgaria | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 6781955 | 2312 | 0 | TBC | weekly | |
2092 | 2092 | Bulgaria | Bulgaria | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 6781955 | 2138 | 0 | TBC | weekly | |
2093 | 2093 | Bulgaria | Bulgaria | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 6781955 | 2230 | 0 | TBC | weekly | |
2094 | 2094 | Bulgaria | Bulgaria | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 6781955 | 2117 | 0 | TBC | weekly | |
2095 | 2095 | Bulgaria | Bulgaria | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 6781955 | 2115 | 0 | TBC | weekly | |
2096 | 2096 | Bulgaria | Bulgaria | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 6781955 | 2098 | 0 | TBC | weekly | |
2097 | 2097 | Bulgaria | Bulgaria | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 6781955 | 2079 | 0 | TBC | weekly | |
2098 | 2098 | Bulgaria | Bulgaria | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 6781955 | 2025 | 0 | TBC | weekly | |
2099 | 2099 | Bulgaria | Bulgaria | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 6781955 | 2116 | 0 | TBC | weekly | |
2100 | 2100 | Bulgaria | Bulgaria | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 6781955 | 2036 | 0 | TBC | weekly | |
2101 | 2101 | Bulgaria | Bulgaria | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 6781955 | 1952 | 0 | TBC | weekly | |
2102 | 2102 | Bulgaria | Bulgaria | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 6781955 | 1983 | 0 | TBC | weekly | |
2103 | 2103 | Bulgaria | Bulgaria | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 6781955 | 1977 | 0 | TBC | weekly | |
2104 | 2104 | Bulgaria | Bulgaria | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 6781955 | 1981 | 0 | TBC | weekly | |
2105 | 2105 | Bulgaria | Bulgaria | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 6781955 | 2055 | 0 | TBC | weekly | |
2106 | 2106 | Bulgaria | Bulgaria | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 6781955 | 1958 | 0 | TBC | weekly | |
2107 | 2107 | Bulgaria | Bulgaria | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 6781955 | 1912 | 0 | TBC | weekly | |
2108 | 2108 | Bulgaria | Bulgaria | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 6781955 | 1957 | 0 | TBC | weekly | |
2109 | 2109 | Bulgaria | Bulgaria | 0 | 2017-06-26 | 2017-07-02 | 7 | 2017 | 26 | 6781955 | 2291 | 0 | TBC | weekly | |
2110 | 2110 | Bulgaria | Bulgaria | 0 | 2017-07-03 | 2017-07-09 | 7 | 2017 | 27 | 6781955 | 2008 | 0 | TBC | weekly | |
2111 | 2111 | Bulgaria | Bulgaria | 0 | 2017-07-10 | 2017-07-16 | 7 | 2017 | 28 | 6781955 | 1920 | 0 | TBC | weekly | |
2112 | 2112 | Bulgaria | Bulgaria | 0 | 2017-07-17 | 2017-07-23 | 7 | 2017 | 29 | 6781955 | 1795 | 0 | TBC | weekly | |
2113 | 2113 | Bulgaria | Bulgaria | 0 | 2017-07-24 | 2017-07-30 | 7 | 2017 | 30 | 6781955 | 1914 | 0 | TBC | weekly | |
2114 | 2114 | Bulgaria | Bulgaria | 0 | 2017-07-31 | 2017-08-06 | 7 | 2017 | 31 | 6781955 | 1943 | 0 | TBC | weekly | |
2115 | 2115 | Bulgaria | Bulgaria | 0 | 2017-08-07 | 2017-08-13 | 7 | 2017 | 32 | 6781955 | 2059 | 0 | TBC | weekly | |
2116 | 2116 | Bulgaria | Bulgaria | 0 | 2017-08-14 | 2017-08-20 | 7 | 2017 | 33 | 6781955 | 1769 | 0 | TBC | weekly | |
2117 | 2117 | Bulgaria | Bulgaria | 0 | 2017-08-21 | 2017-08-27 | 7 | 2017 | 34 | 6781955 | 1761 | 0 | TBC | weekly | |
2118 | 2118 | Bulgaria | Bulgaria | 0 | 2017-08-28 | 2017-09-03 | 7 | 2017 | 35 | 6781955 | 1804 | 0 | TBC | weekly | |
2119 | 2119 | Bulgaria | Bulgaria | 0 | 2017-09-04 | 2017-09-10 | 7 | 2017 | 36 | 6781955 | 1762 | 0 | TBC | weekly | |
2120 | 2120 | Bulgaria | Bulgaria | 0 | 2017-09-11 | 2017-09-17 | 7 | 2017 | 37 | 6781955 | 1942 | 0 | TBC | weekly | |
2121 | 2121 | Bulgaria | Bulgaria | 0 | 2017-09-18 | 2017-09-24 | 7 | 2017 | 38 | 6781955 | 1702 | 0 | TBC | weekly | |
2122 | 2122 | Bulgaria | Bulgaria | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 6781955 | 1702 | 0 | TBC | weekly | |
2123 | 2123 | Bulgaria | Bulgaria | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 6781955 | 1929 | 0 | TBC | weekly | |
2124 | 2124 | Bulgaria | Bulgaria | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 6781955 | 1958 | 0 | TBC | weekly | |
2125 | 2125 | Bulgaria | Bulgaria | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 6781955 | 2064 | 0 | TBC | weekly | |
2126 | 2126 | Bulgaria | Bulgaria | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 6781955 | 2054 | 0 | TBC | weekly | |
2127 | 2127 | Bulgaria | Bulgaria | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 6781955 | 2061 | 0 | TBC | weekly | |
2128 | 2128 | Bulgaria | Bulgaria | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 6781955 | 2016 | 0 | TBC | weekly | |
2129 | 2129 | Bulgaria | Bulgaria | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 6781955 | 2105 | 0 | TBC | weekly | |
2130 | 2130 | Bulgaria | Bulgaria | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 6781955 | 2072 | 0 | TBC | weekly | |
2131 | 2131 | Bulgaria | Bulgaria | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 6781955 | 2052 | 0 | TBC | weekly | |
2132 | 2132 | Bulgaria | Bulgaria | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 6781955 | 2015 | 0 | TBC | weekly | |
2133 | 2133 | Bulgaria | Bulgaria | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 6781955 | 2103 | 0 | TBC | weekly | |
2134 | 2134 | Bulgaria | Bulgaria | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 6781955 | 2033 | 0 | TBC | weekly | |
2135 | 2135 | Bulgaria | Bulgaria | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 6781955 | 2253 | 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]);