economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "Germany" and year = 2021 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38331 | 38331 | Germany | Germany | 0 | 2021-12-27 | 2022-01-02 | 7 | 2021 | 52 | 83369840 | 22169 | 1853 | TBC | weekly | |
38330 | 38330 | Germany | Germany | 0 | 2021-12-20 | 2021-12-26 | 7 | 2021 | 51 | 83369840 | 22479 | 2110 | TBC | weekly | |
38329 | 38329 | Germany | Germany | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 83369840 | 23009 | 2643 | TBC | weekly | |
38328 | 38328 | Germany | Germany | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 83369840 | 24032 | 2428 | TBC | weekly | |
38327 | 38327 | Germany | Germany | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 83369840 | 24185 | 2092 | TBC | weekly | |
38326 | 38326 | Germany | Germany | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 83369840 | 23273 | 1737 | TBC | weekly | |
38325 | 38325 | Germany | Germany | 0 | 2021-11-15 | 2021-11-21 | 7 | 2021 | 46 | 83369840 | 22344 | 1350 | TBC | weekly | |
38324 | 38324 | Germany | Germany | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 83369840 | 21071 | 1043 | TBC | weekly | |
38323 | 38323 | Germany | Germany | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 83369840 | 20426 | 740 | TBC | weekly | |
38322 | 38322 | Germany | Germany | 0 | 2021-10-25 | 2021-10-31 | 7 | 2021 | 43 | 83369840 | 20387 | 615 | TBC | weekly | |
38321 | 38321 | Germany | Germany | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 83369840 | 19761 | 465 | TBC | weekly | |
38320 | 38320 | Germany | Germany | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 83369840 | 18949 | 413 | TBC | weekly | |
38319 | 38319 | Germany | Germany | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 83369840 | 18209 | 402 | TBC | weekly | |
38318 | 38318 | Germany | Germany | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 83369840 | 18129 | 408 | TBC | weekly | |
38317 | 38317 | Germany | Germany | 0 | 2021-09-20 | 2021-09-26 | 7 | 2021 | 38 | 83369840 | 18157 | 446 | TBC | weekly | |
38316 | 38316 | Germany | Germany | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 83369840 | 18057 | 304 | TBC | weekly | |
38315 | 38315 | Germany | Germany | 0 | 2021-09-06 | 2021-09-12 | 7 | 2021 | 36 | 83369840 | 18879 | 252 | TBC | weekly | |
38314 | 38314 | Germany | Germany | 0 | 2021-08-30 | 2021-09-05 | 7 | 2021 | 35 | 83369840 | 17341 | 205 | TBC | weekly | |
38313 | 38313 | Germany | Germany | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 83369840 | 17151 | 140 | TBC | weekly | |
38312 | 38312 | Germany | Germany | 0 | 2021-08-16 | 2021-08-22 | 7 | 2021 | 33 | 83369840 | 17501 | 103 | TBC | weekly | |
38311 | 38311 | Germany | Germany | 0 | 2021-08-09 | 2021-08-15 | 7 | 2021 | 32 | 83369840 | 17560 | 99 | TBC | weekly | |
38310 | 38310 | Germany | Germany | 0 | 2021-08-02 | 2021-08-08 | 7 | 2021 | 31 | 83369840 | 17021 | 117 | TBC | weekly | |
38309 | 38309 | Germany | Germany | 0 | 2021-07-26 | 2021-08-01 | 7 | 2021 | 30 | 83369840 | 17211 | 145 | TBC | weekly | |
38308 | 38308 | Germany | Germany | 0 | 2021-07-19 | 2021-07-25 | 7 | 2021 | 29 | 83369840 | 17613 | 155 | TBC | weekly | |
38307 | 38307 | Germany | Germany | 0 | 2021-07-12 | 2021-07-18 | 7 | 2021 | 28 | 83369840 | 17662 | 147 | TBC | weekly | |
38306 | 38306 | Germany | Germany | 0 | 2021-07-05 | 2021-07-11 | 7 | 2021 | 27 | 83369840 | 16994 | 183 | TBC | weekly | |
38305 | 38305 | Germany | Germany | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 83369840 | 17013 | 253 | TBC | weekly | |
38304 | 38304 | Germany | Germany | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 83369840 | 17191 | 369 | TBC | weekly | |
38303 | 38303 | Germany | Germany | 0 | 2021-06-14 | 2021-06-20 | 7 | 2021 | 24 | 83369840 | 19076 | 551 | TBC | weekly | |
38302 | 38302 | Germany | Germany | 0 | 2021-06-07 | 2021-06-13 | 7 | 2021 | 23 | 83369840 | 17442 | 612 | TBC | weekly | |
38301 | 38301 | Germany | Germany | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 83369840 | 18191 | 816 | TBC | weekly | |
38300 | 38300 | Germany | Germany | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 83369840 | 17193 | 1026 | TBC | weekly | |
38299 | 38299 | Germany | Germany | 0 | 2021-05-17 | 2021-05-23 | 7 | 2021 | 20 | 83369840 | 17811 | 1284 | TBC | weekly | |
38298 | 38298 | Germany | Germany | 0 | 2021-05-10 | 2021-05-16 | 7 | 2021 | 19 | 83369840 | 18579 | 1321 | TBC | weekly | |
38297 | 38297 | Germany | Germany | 0 | 2021-05-03 | 2021-05-09 | 7 | 2021 | 18 | 83369840 | 19329 | 1583 | TBC | weekly | |
38296 | 38296 | Germany | Germany | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 83369840 | 19555 | 1628 | TBC | weekly | |
38295 | 38295 | Germany | Germany | 0 | 2021-04-19 | 2021-04-25 | 7 | 2021 | 16 | 83369840 | 19282 | 1650 | TBC | weekly | |
38294 | 38294 | Germany | Germany | 0 | 2021-04-12 | 2021-04-18 | 7 | 2021 | 15 | 83369840 | 19098 | 1561 | TBC | weekly | |
38293 | 38293 | Germany | Germany | 0 | 2021-04-05 | 2021-04-11 | 7 | 2021 | 14 | 83369840 | 18873 | 1390 | TBC | weekly | |
38292 | 38292 | Germany | Germany | 0 | 2021-03-29 | 2021-04-04 | 7 | 2021 | 13 | 83369840 | 18520 | 1093 | TBC | weekly | |
38291 | 38291 | Germany | Germany | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 83369840 | 18437 | 1206 | TBC | weekly | |
38290 | 38290 | Germany | Germany | 0 | 2021-03-15 | 2021-03-21 | 7 | 2021 | 11 | 83369840 | 18374 | 1293 | TBC | weekly | |
38289 | 38289 | Germany | Germany | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 83369840 | 18606 | 1471 | TBC | weekly | |
38288 | 38288 | Germany | Germany | 0 | 2021-03-01 | 2021-03-07 | 7 | 2021 | 9 | 83369840 | 18455 | 1855 | TBC | weekly | |
38287 | 38287 | Germany | Germany | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 83369840 | 18979 | 2204 | TBC | weekly | |
38286 | 38286 | Germany | Germany | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 83369840 | 20493 | 2881 | TBC | weekly | |
38285 | 38285 | Germany | Germany | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 83369840 | 20946 | 3443 | TBC | weekly | |
38284 | 38284 | Germany | Germany | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 83369840 | 21773 | 4572 | TBC | weekly | |
38283 | 38283 | Germany | Germany | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 83369840 | 22674 | 5075 | TBC | weekly | |
38282 | 38282 | Germany | Germany | 0 | 2021-01-18 | 2021-01-24 | 7 | 2021 | 3 | 83369840 | 24129 | 5451 | TBC | weekly | |
38281 | 38281 | Germany | Germany | 0 | 2021-01-11 | 2021-01-17 | 7 | 2021 | 2 | 83369840 | 24532 | 6076 | TBC | weekly | |
38280 | 38280 | Germany | Germany | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 83369840 | 24919 | 6071 | 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]);