economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where cadence = "weekly", country = "Latvia" and year = 2016
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1024 | 1024 | Latvia | Latvia | 0 | 2016-01-04 | 2016-01-10 | 7 | 2016 | 1 | 1850654 | 684 | 0 | TBC | weekly | |
1025 | 1025 | Latvia | Latvia | 0 | 2016-01-11 | 2016-01-17 | 7 | 2016 | 2 | 1850654 | 649 | 0 | TBC | weekly | |
1026 | 1026 | Latvia | Latvia | 0 | 2016-01-18 | 2016-01-24 | 7 | 2016 | 3 | 1850654 | 634 | 0 | TBC | weekly | |
1027 | 1027 | Latvia | Latvia | 0 | 2016-01-25 | 2016-01-31 | 7 | 2016 | 4 | 1850654 | 670 | 0 | TBC | weekly | |
1028 | 1028 | Latvia | Latvia | 0 | 2016-02-01 | 2016-02-07 | 7 | 2016 | 5 | 1850654 | 551 | 0 | TBC | weekly | |
1029 | 1029 | Latvia | Latvia | 0 | 2016-02-08 | 2016-02-14 | 7 | 2016 | 6 | 1850654 | 557 | 0 | TBC | weekly | |
1030 | 1030 | Latvia | Latvia | 0 | 2016-02-15 | 2016-02-21 | 7 | 2016 | 7 | 1850654 | 581 | 0 | TBC | weekly | |
1031 | 1031 | Latvia | Latvia | 0 | 2016-02-22 | 2016-02-28 | 7 | 2016 | 8 | 1850654 | 565 | 0 | TBC | weekly | |
1032 | 1032 | Latvia | Latvia | 0 | 2016-02-29 | 2016-03-06 | 7 | 2016 | 9 | 1850654 | 608 | 0 | TBC | weekly | |
1033 | 1033 | Latvia | Latvia | 0 | 2016-03-07 | 2016-03-13 | 7 | 2016 | 10 | 1850654 | 582 | 0 | TBC | weekly | |
1034 | 1034 | Latvia | Latvia | 0 | 2016-03-14 | 2016-03-20 | 7 | 2016 | 11 | 1850654 | 604 | 0 | TBC | weekly | |
1035 | 1035 | Latvia | Latvia | 0 | 2016-03-21 | 2016-03-27 | 7 | 2016 | 12 | 1850654 | 577 | 0 | TBC | weekly | |
1036 | 1036 | Latvia | Latvia | 0 | 2016-03-28 | 2016-04-03 | 7 | 2016 | 13 | 1850654 | 606 | 0 | TBC | weekly | |
1037 | 1037 | Latvia | Latvia | 0 | 2016-04-04 | 2016-04-10 | 7 | 2016 | 14 | 1850654 | 575 | 0 | TBC | weekly | |
1038 | 1038 | Latvia | Latvia | 0 | 2016-04-11 | 2016-04-17 | 7 | 2016 | 15 | 1850654 | 566 | 0 | TBC | weekly | |
1039 | 1039 | Latvia | Latvia | 0 | 2016-04-18 | 2016-04-24 | 7 | 2016 | 16 | 1850654 | 544 | 0 | TBC | weekly | |
1040 | 1040 | Latvia | Latvia | 0 | 2016-04-25 | 2016-05-01 | 7 | 2016 | 17 | 1850654 | 537 | 0 | TBC | weekly | |
1041 | 1041 | Latvia | Latvia | 0 | 2016-05-02 | 2016-05-08 | 7 | 2016 | 18 | 1850654 | 520 | 0 | TBC | weekly | |
1042 | 1042 | Latvia | Latvia | 0 | 2016-05-09 | 2016-05-15 | 7 | 2016 | 19 | 1850654 | 545 | 0 | TBC | weekly | |
1043 | 1043 | Latvia | Latvia | 0 | 2016-05-16 | 2016-05-22 | 7 | 2016 | 20 | 1850654 | 537 | 0 | TBC | weekly | |
1044 | 1044 | Latvia | Latvia | 0 | 2016-05-23 | 2016-05-29 | 7 | 2016 | 21 | 1850654 | 527 | 0 | TBC | weekly | |
1045 | 1045 | Latvia | Latvia | 0 | 2016-05-30 | 2016-06-05 | 7 | 2016 | 22 | 1850654 | 558 | 0 | TBC | weekly | |
1046 | 1046 | Latvia | Latvia | 0 | 2016-06-06 | 2016-06-12 | 7 | 2016 | 23 | 1850654 | 492 | 0 | TBC | weekly | |
1047 | 1047 | Latvia | Latvia | 0 | 2016-06-13 | 2016-06-19 | 7 | 2016 | 24 | 1850654 | 503 | 0 | TBC | weekly | |
1048 | 1048 | Latvia | Latvia | 0 | 2016-06-20 | 2016-06-26 | 7 | 2016 | 25 | 1850654 | 586 | 0 | TBC | weekly | |
1049 | 1049 | Latvia | Latvia | 0 | 2016-06-27 | 2016-07-03 | 7 | 2016 | 26 | 1850654 | 527 | 0 | TBC | weekly | |
1050 | 1050 | Latvia | Latvia | 0 | 2016-07-04 | 2016-07-10 | 7 | 2016 | 27 | 1850654 | 464 | 0 | TBC | weekly | |
1051 | 1051 | Latvia | Latvia | 0 | 2016-07-11 | 2016-07-17 | 7 | 2016 | 28 | 1850654 | 490 | 0 | TBC | weekly | |
1052 | 1052 | Latvia | Latvia | 0 | 2016-07-18 | 2016-07-24 | 7 | 2016 | 29 | 1850654 | 490 | 0 | TBC | weekly | |
1053 | 1053 | Latvia | Latvia | 0 | 2016-07-25 | 2016-07-31 | 7 | 2016 | 30 | 1850654 | 474 | 0 | TBC | weekly | |
1054 | 1054 | Latvia | Latvia | 0 | 2016-08-01 | 2016-08-07 | 7 | 2016 | 31 | 1850654 | 465 | 0 | TBC | weekly | |
1055 | 1055 | Latvia | Latvia | 0 | 2016-08-08 | 2016-08-14 | 7 | 2016 | 32 | 1850654 | 474 | 0 | TBC | weekly | |
1056 | 1056 | Latvia | Latvia | 0 | 2016-08-15 | 2016-08-21 | 7 | 2016 | 33 | 1850654 | 524 | 0 | TBC | weekly | |
1057 | 1057 | Latvia | Latvia | 0 | 2016-08-22 | 2016-08-28 | 7 | 2016 | 34 | 1850654 | 550 | 0 | TBC | weekly | |
1058 | 1058 | Latvia | Latvia | 0 | 2016-08-29 | 2016-09-04 | 7 | 2016 | 35 | 1850654 | 466 | 0 | TBC | weekly | |
1059 | 1059 | Latvia | Latvia | 0 | 2016-09-05 | 2016-09-11 | 7 | 2016 | 36 | 1850654 | 494 | 0 | TBC | weekly | |
1060 | 1060 | Latvia | Latvia | 0 | 2016-09-12 | 2016-09-18 | 7 | 2016 | 37 | 1850654 | 514 | 0 | TBC | weekly | |
1061 | 1061 | Latvia | Latvia | 0 | 2016-09-19 | 2016-09-25 | 7 | 2016 | 38 | 1850654 | 509 | 0 | TBC | weekly | |
1062 | 1062 | Latvia | Latvia | 0 | 2016-09-26 | 2016-10-02 | 7 | 2016 | 39 | 1850654 | 522 | 0 | TBC | weekly | |
1063 | 1063 | Latvia | Latvia | 0 | 2016-10-03 | 2016-10-09 | 7 | 2016 | 40 | 1850654 | 550 | 0 | TBC | weekly | |
1064 | 1064 | Latvia | Latvia | 0 | 2016-10-10 | 2016-10-16 | 7 | 2016 | 41 | 1850654 | 537 | 0 | TBC | weekly | |
1065 | 1065 | Latvia | Latvia | 0 | 2016-10-17 | 2016-10-23 | 7 | 2016 | 42 | 1850654 | 593 | 0 | TBC | weekly | |
1066 | 1066 | Latvia | Latvia | 0 | 2016-10-24 | 2016-10-30 | 7 | 2016 | 43 | 1850654 | 478 | 0 | TBC | weekly | |
1067 | 1067 | Latvia | Latvia | 0 | 2016-10-31 | 2016-11-06 | 7 | 2016 | 44 | 1850654 | 556 | 0 | TBC | weekly | |
1068 | 1068 | Latvia | Latvia | 0 | 2016-11-07 | 2016-11-13 | 7 | 2016 | 45 | 1850654 | 538 | 0 | TBC | weekly | |
1069 | 1069 | Latvia | Latvia | 0 | 2016-11-14 | 2016-11-20 | 7 | 2016 | 46 | 1850654 | 522 | 0 | TBC | weekly | |
1070 | 1070 | Latvia | Latvia | 0 | 2016-11-21 | 2016-11-27 | 7 | 2016 | 47 | 1850654 | 571 | 0 | TBC | weekly | |
1071 | 1071 | Latvia | Latvia | 0 | 2016-11-28 | 2016-12-04 | 7 | 2016 | 48 | 1850654 | 534 | 0 | TBC | weekly | |
1072 | 1072 | Latvia | Latvia | 0 | 2016-12-05 | 2016-12-11 | 7 | 2016 | 49 | 1850654 | 534 | 0 | TBC | weekly | |
1073 | 1073 | Latvia | Latvia | 0 | 2016-12-12 | 2016-12-18 | 7 | 2016 | 50 | 1850654 | 528 | 0 | TBC | weekly | |
1074 | 1074 | Latvia | Latvia | 0 | 2016-12-19 | 2016-12-25 | 7 | 2016 | 51 | 1850654 | 610 | 0 | TBC | weekly | |
1075 | 1075 | Latvia | Latvia | 0 | 2016-12-26 | 2017-01-01 | 7 | 2016 | 52 | 1850654 | 571 | 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]);