economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where cadence = "weekly", country = "Bulgaria" and year = 2019
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2188 | 2188 | Bulgaria | Bulgaria | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 6781955 | 2533 | 0 | TBC | weekly | |
2189 | 2189 | Bulgaria | Bulgaria | 0 | 2019-01-07 | 2019-01-13 | 7 | 2019 | 2 | 6781955 | 2692 | 0 | TBC | weekly | |
2190 | 2190 | Bulgaria | Bulgaria | 0 | 2019-01-14 | 2019-01-20 | 7 | 2019 | 3 | 6781955 | 2756 | 0 | TBC | weekly | |
2191 | 2191 | Bulgaria | Bulgaria | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 6781955 | 2848 | 0 | TBC | weekly | |
2192 | 2192 | Bulgaria | Bulgaria | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 6781955 | 2573 | 0 | TBC | weekly | |
2193 | 2193 | Bulgaria | Bulgaria | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 6781955 | 2245 | 0 | TBC | weekly | |
2194 | 2194 | Bulgaria | Bulgaria | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 6781955 | 2300 | 0 | TBC | weekly | |
2195 | 2195 | Bulgaria | Bulgaria | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 6781955 | 2264 | 0 | TBC | weekly | |
2196 | 2196 | Bulgaria | Bulgaria | 0 | 2019-02-25 | 2019-03-03 | 7 | 2019 | 9 | 6781955 | 2275 | 0 | TBC | weekly | |
2197 | 2197 | Bulgaria | Bulgaria | 0 | 2019-03-04 | 2019-03-10 | 7 | 2019 | 10 | 6781955 | 2166 | 0 | TBC | weekly | |
2198 | 2198 | Bulgaria | Bulgaria | 0 | 2019-03-11 | 2019-03-17 | 7 | 2019 | 11 | 6781955 | 2123 | 0 | TBC | weekly | |
2199 | 2199 | Bulgaria | Bulgaria | 0 | 2019-03-18 | 2019-03-24 | 7 | 2019 | 12 | 6781955 | 2148 | 0 | TBC | weekly | |
2200 | 2200 | Bulgaria | Bulgaria | 0 | 2019-03-25 | 2019-03-31 | 7 | 2019 | 13 | 6781955 | 2081 | 0 | TBC | weekly | |
2201 | 2201 | Bulgaria | Bulgaria | 0 | 2019-04-01 | 2019-04-07 | 7 | 2019 | 14 | 6781955 | 2114 | 0 | TBC | weekly | |
2202 | 2202 | Bulgaria | Bulgaria | 0 | 2019-04-08 | 2019-04-14 | 7 | 2019 | 15 | 6781955 | 2092 | 0 | TBC | weekly | |
2203 | 2203 | Bulgaria | Bulgaria | 0 | 2019-04-15 | 2019-04-21 | 7 | 2019 | 16 | 6781955 | 2036 | 0 | TBC | weekly | |
2204 | 2204 | Bulgaria | Bulgaria | 0 | 2019-04-22 | 2019-04-28 | 7 | 2019 | 17 | 6781955 | 2051 | 0 | TBC | weekly | |
2205 | 2205 | Bulgaria | Bulgaria | 0 | 2019-04-29 | 2019-05-05 | 7 | 2019 | 18 | 6781955 | 1980 | 0 | TBC | weekly | |
2206 | 2206 | Bulgaria | Bulgaria | 0 | 2019-05-06 | 2019-05-12 | 7 | 2019 | 19 | 6781955 | 2120 | 0 | TBC | weekly | |
2207 | 2207 | Bulgaria | Bulgaria | 0 | 2019-05-13 | 2019-05-19 | 7 | 2019 | 20 | 6781955 | 1980 | 0 | TBC | weekly | |
2208 | 2208 | Bulgaria | Bulgaria | 0 | 2019-05-20 | 2019-05-26 | 7 | 2019 | 21 | 6781955 | 1998 | 0 | TBC | weekly | |
2209 | 2209 | Bulgaria | Bulgaria | 0 | 2019-05-27 | 2019-06-02 | 7 | 2019 | 22 | 6781955 | 1967 | 0 | TBC | weekly | |
2210 | 2210 | Bulgaria | Bulgaria | 0 | 2019-06-03 | 2019-06-09 | 7 | 2019 | 23 | 6781955 | 1932 | 0 | TBC | weekly | |
2211 | 2211 | Bulgaria | Bulgaria | 0 | 2019-06-10 | 2019-06-16 | 7 | 2019 | 24 | 6781955 | 1994 | 0 | TBC | weekly | |
2212 | 2212 | Bulgaria | Bulgaria | 0 | 2019-06-17 | 2019-06-23 | 7 | 2019 | 25 | 6781955 | 2026 | 0 | TBC | weekly | |
2213 | 2213 | Bulgaria | Bulgaria | 0 | 2019-06-24 | 2019-06-30 | 7 | 2019 | 26 | 6781955 | 1908 | 0 | TBC | weekly | |
2214 | 2214 | Bulgaria | Bulgaria | 0 | 2019-07-01 | 2019-07-07 | 7 | 2019 | 27 | 6781955 | 1954 | 0 | TBC | weekly | |
2215 | 2215 | Bulgaria | Bulgaria | 0 | 2019-07-08 | 2019-07-14 | 7 | 2019 | 28 | 6781955 | 1820 | 0 | TBC | weekly | |
2216 | 2216 | Bulgaria | Bulgaria | 0 | 2019-07-15 | 2019-07-21 | 7 | 2019 | 29 | 6781955 | 1867 | 0 | TBC | weekly | |
2217 | 2217 | Bulgaria | Bulgaria | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 6781955 | 1963 | 0 | TBC | weekly | |
2218 | 2218 | Bulgaria | Bulgaria | 0 | 2019-07-29 | 2019-08-04 | 7 | 2019 | 31 | 6781955 | 1854 | 0 | TBC | weekly | |
2219 | 2219 | Bulgaria | Bulgaria | 0 | 2019-08-05 | 2019-08-11 | 7 | 2019 | 32 | 6781955 | 1896 | 0 | TBC | weekly | |
2220 | 2220 | Bulgaria | Bulgaria | 0 | 2019-08-12 | 2019-08-18 | 7 | 2019 | 33 | 6781955 | 1920 | 0 | TBC | weekly | |
2221 | 2221 | Bulgaria | Bulgaria | 0 | 2019-08-19 | 2019-08-25 | 7 | 2019 | 34 | 6781955 | 1936 | 0 | TBC | weekly | |
2222 | 2222 | Bulgaria | Bulgaria | 0 | 2019-08-26 | 2019-09-01 | 7 | 2019 | 35 | 6781955 | 1863 | 0 | TBC | weekly | |
2223 | 2223 | Bulgaria | Bulgaria | 0 | 2019-09-02 | 2019-09-08 | 7 | 2019 | 36 | 6781955 | 1734 | 0 | TBC | weekly | |
2224 | 2224 | Bulgaria | Bulgaria | 0 | 2019-09-09 | 2019-09-15 | 7 | 2019 | 37 | 6781955 | 1753 | 0 | TBC | weekly | |
2225 | 2225 | Bulgaria | Bulgaria | 0 | 2019-09-16 | 2019-09-22 | 7 | 2019 | 38 | 6781955 | 1791 | 0 | TBC | weekly | |
2226 | 2226 | Bulgaria | Bulgaria | 0 | 2019-09-23 | 2019-09-29 | 7 | 2019 | 39 | 6781955 | 1827 | 0 | TBC | weekly | |
2227 | 2227 | Bulgaria | Bulgaria | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 6781955 | 1887 | 0 | TBC | weekly | |
2228 | 2228 | Bulgaria | Bulgaria | 0 | 2019-10-07 | 2019-10-13 | 7 | 2019 | 41 | 6781955 | 1888 | 0 | TBC | weekly | |
2229 | 2229 | Bulgaria | Bulgaria | 0 | 2019-10-14 | 2019-10-20 | 7 | 2019 | 42 | 6781955 | 1971 | 0 | TBC | weekly | |
2230 | 2230 | Bulgaria | Bulgaria | 0 | 2019-10-21 | 2019-10-27 | 7 | 2019 | 43 | 6781955 | 1911 | 0 | TBC | weekly | |
2231 | 2231 | Bulgaria | Bulgaria | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 6781955 | 2039 | 0 | TBC | weekly | |
2232 | 2232 | Bulgaria | Bulgaria | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 6781955 | 2194 | 0 | TBC | weekly | |
2233 | 2233 | Bulgaria | Bulgaria | 0 | 2019-11-11 | 2019-11-17 | 7 | 2019 | 46 | 6781955 | 2026 | 0 | TBC | weekly | |
2234 | 2234 | Bulgaria | Bulgaria | 0 | 2019-11-18 | 2019-11-24 | 7 | 2019 | 47 | 6781955 | 1958 | 0 | TBC | weekly | |
2235 | 2235 | Bulgaria | Bulgaria | 0 | 2019-11-25 | 2019-12-01 | 7 | 2019 | 48 | 6781955 | 2071 | 0 | TBC | weekly | |
2236 | 2236 | Bulgaria | Bulgaria | 0 | 2019-12-02 | 2019-12-08 | 7 | 2019 | 49 | 6781955 | 2128 | 0 | TBC | weekly | |
2237 | 2237 | Bulgaria | Bulgaria | 0 | 2019-12-09 | 2019-12-15 | 7 | 2019 | 50 | 6781955 | 2113 | 0 | TBC | weekly | |
2238 | 2238 | Bulgaria | Bulgaria | 0 | 2019-12-16 | 2019-12-22 | 7 | 2019 | 51 | 6781955 | 2135 | 0 | TBC | weekly | |
2239 | 2239 | Bulgaria | Bulgaria | 0 | 2019-12-23 | 2019-12-29 | 7 | 2019 | 52 | 6781955 | 2117 | 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]);