economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "Finland", 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15521 | 15521 | Finland | Finland | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 5540745 | 1273 | 0 | TBC | weekly | |
15522 | 15522 | Finland | Finland | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 5540745 | 1335 | 0 | TBC | weekly | |
15523 | 15523 | Finland | Finland | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 5540745 | 1208 | 0 | TBC | weekly | |
15524 | 15524 | Finland | Finland | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 5540745 | 1145 | 0 | TBC | weekly | |
15525 | 15525 | Finland | Finland | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 5540745 | 1116 | 0 | TBC | weekly | |
15526 | 15526 | Finland | Finland | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 5540745 | 1106 | 0 | TBC | weekly | |
15527 | 15527 | Finland | Finland | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 5540745 | 1122 | 0 | TBC | weekly | |
15528 | 15528 | Finland | Finland | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 5540745 | 1124 | 0 | TBC | weekly | |
15529 | 15529 | Finland | Finland | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 5540745 | 1083 | 0 | TBC | weekly | |
15530 | 15530 | Finland | Finland | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 5540745 | 1048 | 0 | TBC | weekly | |
15531 | 15531 | Finland | Finland | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 5540745 | 1021 | 0 | TBC | weekly | |
15532 | 15532 | Finland | Finland | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 5540745 | 1065 | 0 | TBC | weekly | |
15533 | 15533 | Finland | Finland | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 5540745 | 985 | 0 | TBC | weekly | |
15534 | 15534 | Finland | Finland | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 5540745 | 1059 | 0 | TBC | weekly | |
15535 | 15535 | Finland | Finland | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 5540745 | 998 | 0 | TBC | weekly | |
15536 | 15536 | Finland | Finland | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 5540745 | 1055 | 0 | TBC | weekly | |
15537 | 15537 | Finland | Finland | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 5540745 | 1006 | 0 | TBC | weekly | |
15538 | 15538 | Finland | Finland | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 5540745 | 1079 | 0 | TBC | weekly | |
15539 | 15539 | Finland | Finland | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 5540745 | 1049 | 0 | TBC | weekly | |
15540 | 15540 | Finland | Finland | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 5540745 | 999 | 0 | TBC | weekly | |
15541 | 15541 | Finland | Finland | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 5540745 | 995 | 0 | TBC | weekly | |
15542 | 15542 | Finland | Finland | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 5540745 | 980 | 0 | TBC | weekly | |
15543 | 15543 | Finland | Finland | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 5540745 | 1014 | 0 | TBC | weekly | |
15544 | 15544 | Finland | Finland | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 5540745 | 1021 | 0 | TBC | weekly | |
15545 | 15545 | Finland | Finland | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 5540745 | 993 | 0 | TBC | weekly | |
15546 | 15546 | Finland | Finland | 0 | 2017-06-26 | 2017-07-02 | 7 | 2017 | 26 | 5540745 | 993 | 0 | TBC | weekly | |
15547 | 15547 | Finland | Finland | 0 | 2017-07-03 | 2017-07-09 | 7 | 2017 | 27 | 5540745 | 929 | 0 | TBC | weekly | |
15548 | 15548 | Finland | Finland | 0 | 2017-07-10 | 2017-07-16 | 7 | 2017 | 28 | 5540745 | 921 | 0 | TBC | weekly | |
15549 | 15549 | Finland | Finland | 0 | 2017-07-17 | 2017-07-23 | 7 | 2017 | 29 | 5540745 | 925 | 0 | TBC | weekly | |
15550 | 15550 | Finland | Finland | 0 | 2017-07-24 | 2017-07-30 | 7 | 2017 | 30 | 5540745 | 944 | 0 | TBC | weekly | |
15551 | 15551 | Finland | Finland | 0 | 2017-07-31 | 2017-08-06 | 7 | 2017 | 31 | 5540745 | 923 | 0 | TBC | weekly | |
15552 | 15552 | Finland | Finland | 0 | 2017-08-07 | 2017-08-13 | 7 | 2017 | 32 | 5540745 | 954 | 0 | TBC | weekly | |
15553 | 15553 | Finland | Finland | 0 | 2017-08-14 | 2017-08-20 | 7 | 2017 | 33 | 5540745 | 943 | 0 | TBC | weekly | |
15554 | 15554 | Finland | Finland | 0 | 2017-08-21 | 2017-08-27 | 7 | 2017 | 34 | 5540745 | 906 | 0 | TBC | weekly | |
15555 | 15555 | Finland | Finland | 0 | 2017-08-28 | 2017-09-03 | 7 | 2017 | 35 | 5540745 | 954 | 0 | TBC | weekly | |
15556 | 15556 | Finland | Finland | 0 | 2017-09-04 | 2017-09-10 | 7 | 2017 | 36 | 5540745 | 1001 | 0 | TBC | weekly | |
15557 | 15557 | Finland | Finland | 0 | 2017-09-11 | 2017-09-17 | 7 | 2017 | 37 | 5540745 | 1040 | 0 | TBC | weekly | |
15558 | 15558 | Finland | Finland | 0 | 2017-09-18 | 2017-09-24 | 7 | 2017 | 38 | 5540745 | 940 | 0 | TBC | weekly | |
15559 | 15559 | Finland | Finland | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 5540745 | 974 | 0 | TBC | weekly | |
15560 | 15560 | Finland | Finland | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 5540745 | 1030 | 0 | TBC | weekly | |
15561 | 15561 | Finland | Finland | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 5540745 | 964 | 0 | TBC | weekly | |
15562 | 15562 | Finland | Finland | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 5540745 | 1024 | 0 | TBC | weekly | |
15563 | 15563 | Finland | Finland | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 5540745 | 1024 | 0 | TBC | weekly | |
15564 | 15564 | Finland | Finland | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 5540745 | 1034 | 0 | TBC | weekly | |
15565 | 15565 | Finland | Finland | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 5540745 | 977 | 0 | TBC | weekly | |
15566 | 15566 | Finland | Finland | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 5540745 | 966 | 0 | TBC | weekly | |
15567 | 15567 | Finland | Finland | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 5540745 | 998 | 0 | TBC | weekly | |
15568 | 15568 | Finland | Finland | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 5540745 | 988 | 0 | TBC | weekly | |
15569 | 15569 | Finland | Finland | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 5540745 | 1014 | 0 | TBC | weekly | |
15570 | 15570 | Finland | Finland | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 5540745 | 1056 | 0 | TBC | weekly | |
15571 | 15571 | Finland | Finland | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 5540745 | 1112 | 0 | TBC | weekly | |
15572 | 15572 | Finland | Finland | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 5540745 | 1103 | 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]);