economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
413 rows where country = "Latvia"
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
1076 | 1076 | Latvia | Latvia | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 1850654 | 606 | 0 | TBC | weekly | |
1077 | 1077 | Latvia | Latvia | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 1850654 | 616 | 0 | TBC | weekly | |
1078 | 1078 | Latvia | Latvia | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 1850654 | 631 | 0 | TBC | weekly | |
1079 | 1079 | Latvia | Latvia | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 1850654 | 567 | 0 | TBC | weekly | |
1080 | 1080 | Latvia | Latvia | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 1850654 | 630 | 0 | TBC | weekly | |
1081 | 1081 | Latvia | Latvia | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 1850654 | 623 | 0 | TBC | weekly | |
1082 | 1082 | Latvia | Latvia | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 1850654 | 637 | 0 | TBC | weekly | |
1083 | 1083 | Latvia | Latvia | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 1850654 | 695 | 0 | TBC | weekly | |
1084 | 1084 | Latvia | Latvia | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 1850654 | 652 | 0 | TBC | weekly | |
1085 | 1085 | Latvia | Latvia | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 1850654 | 641 | 0 | TBC | weekly | |
1086 | 1086 | Latvia | Latvia | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 1850654 | 567 | 0 | TBC | weekly | |
1087 | 1087 | Latvia | Latvia | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 1850654 | 614 | 0 | TBC | weekly | |
1088 | 1088 | Latvia | Latvia | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 1850654 | 570 | 0 | TBC | weekly | |
1089 | 1089 | Latvia | Latvia | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 1850654 | 602 | 0 | TBC | weekly | |
1090 | 1090 | Latvia | Latvia | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 1850654 | 553 | 0 | TBC | weekly | |
1091 | 1091 | Latvia | Latvia | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 1850654 | 554 | 0 | TBC | weekly | |
1092 | 1092 | Latvia | Latvia | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 1850654 | 534 | 0 | TBC | weekly | |
1093 | 1093 | Latvia | Latvia | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 1850654 | 560 | 0 | TBC | weekly | |
1094 | 1094 | Latvia | Latvia | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 1850654 | 549 | 0 | TBC | weekly | |
1095 | 1095 | Latvia | Latvia | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 1850654 | 543 | 0 | TBC | weekly | |
1096 | 1096 | Latvia | Latvia | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 1850654 | 488 | 0 | TBC | weekly | |
1097 | 1097 | Latvia | Latvia | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 1850654 | 510 | 0 | TBC | weekly | |
1098 | 1098 | Latvia | Latvia | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 1850654 | 551 | 0 | TBC | weekly | |
1099 | 1099 | Latvia | Latvia | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 1850654 | 498 | 0 | TBC | weekly | |
1100 | 1100 | Latvia | Latvia | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 1850654 | 515 | 0 | TBC | weekly | |
1101 | 1101 | Latvia | Latvia | 0 | 2017-06-26 | 2017-07-02 | 7 | 2017 | 26 | 1850654 | 484 | 0 | TBC | weekly | |
1102 | 1102 | Latvia | Latvia | 0 | 2017-07-03 | 2017-07-09 | 7 | 2017 | 27 | 1850654 | 457 | 0 | TBC | weekly | |
1103 | 1103 | Latvia | Latvia | 0 | 2017-07-10 | 2017-07-16 | 7 | 2017 | 28 | 1850654 | 533 | 0 | TBC | weekly | |
1104 | 1104 | Latvia | Latvia | 0 | 2017-07-17 | 2017-07-23 | 7 | 2017 | 29 | 1850654 | 516 | 0 | TBC | weekly | |
1105 | 1105 | Latvia | Latvia | 0 | 2017-07-24 | 2017-07-30 | 7 | 2017 | 30 | 1850654 | 482 | 0 | TBC | weekly | |
1106 | 1106 | Latvia | Latvia | 0 | 2017-07-31 | 2017-08-06 | 7 | 2017 | 31 | 1850654 | 468 | 0 | TBC | weekly | |
1107 | 1107 | Latvia | Latvia | 0 | 2017-08-07 | 2017-08-13 | 7 | 2017 | 32 | 1850654 | 460 | 0 | TBC | weekly | |
1108 | 1108 | Latvia | Latvia | 0 | 2017-08-14 | 2017-08-20 | 7 | 2017 | 33 | 1850654 | 501 | 0 | TBC | weekly | |
1109 | 1109 | Latvia | Latvia | 0 | 2017-08-21 | 2017-08-27 | 7 | 2017 | 34 | 1850654 | 476 | 0 | TBC | weekly | |
1110 | 1110 | Latvia | Latvia | 0 | 2017-08-28 | 2017-09-03 | 7 | 2017 | 35 | 1850654 | 508 | 0 | TBC | weekly | |
1111 | 1111 | Latvia | Latvia | 0 | 2017-09-04 | 2017-09-10 | 7 | 2017 | 36 | 1850654 | 471 | 0 | TBC | weekly | |
1112 | 1112 | Latvia | Latvia | 0 | 2017-09-11 | 2017-09-17 | 7 | 2017 | 37 | 1850654 | 552 | 0 | TBC | weekly | |
1113 | 1113 | Latvia | Latvia | 0 | 2017-09-18 | 2017-09-24 | 7 | 2017 | 38 | 1850654 | 535 | 0 | TBC | weekly | |
1114 | 1114 | Latvia | Latvia | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 1850654 | 534 | 0 | TBC | weekly | |
1115 | 1115 | Latvia | Latvia | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 1850654 | 569 | 0 | TBC | weekly | |
1116 | 1116 | Latvia | Latvia | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 1850654 | 528 | 0 | TBC | weekly | |
1117 | 1117 | Latvia | Latvia | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 1850654 | 525 | 0 | TBC | weekly | |
1118 | 1118 | Latvia | Latvia | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 1850654 | 534 | 0 | TBC | weekly | |
1119 | 1119 | Latvia | Latvia | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 1850654 | 543 | 0 | TBC | weekly | |
1120 | 1120 | Latvia | Latvia | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 1850654 | 500 | 0 | TBC | weekly | |
1121 | 1121 | Latvia | Latvia | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 1850654 | 572 | 0 | TBC | weekly | |
1122 | 1122 | Latvia | Latvia | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 1850654 | 560 | 0 | TBC | weekly | |
1123 | 1123 | Latvia | Latvia | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 1850654 | 555 | 0 | TBC | weekly | |
1124 | 1124 | Latvia | Latvia | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 1850654 | 552 | 0 | TBC | weekly | |
1125 | 1125 | Latvia | Latvia | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 1850654 | 578 | 0 | TBC | weekly | |
1126 | 1126 | Latvia | Latvia | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 1850654 | 594 | 0 | TBC | weekly | |
1127 | 1127 | Latvia | Latvia | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 1850654 | 566 | 0 | TBC | weekly | |
1128 | 1128 | Latvia | Latvia | 0 | 2018-01-01 | 2018-01-07 | 7 | 2018 | 1 | 1850654 | 567 | 0 | TBC | weekly | |
1129 | 1129 | Latvia | Latvia | 0 | 2018-01-08 | 2018-01-14 | 7 | 2018 | 2 | 1850654 | 555 | 0 | TBC | weekly | |
1130 | 1130 | Latvia | Latvia | 0 | 2018-01-15 | 2018-01-21 | 7 | 2018 | 3 | 1850654 | 598 | 0 | TBC | weekly | |
1131 | 1131 | Latvia | Latvia | 0 | 2018-01-22 | 2018-01-28 | 7 | 2018 | 4 | 1850654 | 606 | 0 | TBC | weekly | |
1132 | 1132 | Latvia | Latvia | 0 | 2018-01-29 | 2018-02-04 | 7 | 2018 | 5 | 1850654 | 587 | 0 | TBC | weekly | |
1133 | 1133 | Latvia | Latvia | 0 | 2018-02-05 | 2018-02-11 | 7 | 2018 | 6 | 1850654 | 568 | 0 | TBC | weekly | |
1134 | 1134 | Latvia | Latvia | 0 | 2018-02-12 | 2018-02-18 | 7 | 2018 | 7 | 1850654 | 589 | 0 | TBC | weekly | |
1135 | 1135 | Latvia | Latvia | 0 | 2018-02-19 | 2018-02-25 | 7 | 2018 | 8 | 1850654 | 671 | 0 | TBC | weekly | |
1136 | 1136 | Latvia | Latvia | 0 | 2018-02-26 | 2018-03-04 | 7 | 2018 | 9 | 1850654 | 707 | 0 | TBC | weekly | |
1137 | 1137 | Latvia | Latvia | 0 | 2018-03-05 | 2018-03-11 | 7 | 2018 | 10 | 1850654 | 699 | 0 | TBC | weekly | |
1138 | 1138 | Latvia | Latvia | 0 | 2018-03-12 | 2018-03-18 | 7 | 2018 | 11 | 1850654 | 664 | 0 | TBC | weekly | |
1139 | 1139 | Latvia | Latvia | 0 | 2018-03-19 | 2018-03-25 | 7 | 2018 | 12 | 1850654 | 706 | 0 | TBC | weekly | |
1140 | 1140 | Latvia | Latvia | 0 | 2018-03-26 | 2018-04-01 | 7 | 2018 | 13 | 1850654 | 687 | 0 | TBC | weekly | |
1141 | 1141 | Latvia | Latvia | 0 | 2018-04-02 | 2018-04-08 | 7 | 2018 | 14 | 1850654 | 648 | 0 | TBC | weekly | |
1142 | 1142 | Latvia | Latvia | 0 | 2018-04-09 | 2018-04-15 | 7 | 2018 | 15 | 1850654 | 606 | 0 | TBC | weekly | |
1143 | 1143 | Latvia | Latvia | 0 | 2018-04-16 | 2018-04-22 | 7 | 2018 | 16 | 1850654 | 582 | 0 | TBC | weekly | |
1144 | 1144 | Latvia | Latvia | 0 | 2018-04-23 | 2018-04-29 | 7 | 2018 | 17 | 1850654 | 517 | 0 | TBC | weekly | |
1145 | 1145 | Latvia | Latvia | 0 | 2018-04-30 | 2018-05-06 | 7 | 2018 | 18 | 1850654 | 502 | 0 | TBC | weekly | |
1146 | 1146 | Latvia | Latvia | 0 | 2018-05-07 | 2018-05-13 | 7 | 2018 | 19 | 1850654 | 554 | 0 | TBC | weekly | |
1147 | 1147 | Latvia | Latvia | 0 | 2018-05-14 | 2018-05-20 | 7 | 2018 | 20 | 1850654 | 526 | 0 | TBC | weekly | |
1148 | 1148 | Latvia | Latvia | 0 | 2018-05-21 | 2018-05-27 | 7 | 2018 | 21 | 1850654 | 527 | 0 | TBC | weekly | |
1149 | 1149 | Latvia | Latvia | 0 | 2018-05-28 | 2018-06-03 | 7 | 2018 | 22 | 1850654 | 537 | 0 | TBC | weekly | |
1150 | 1150 | Latvia | Latvia | 0 | 2018-06-04 | 2018-06-10 | 7 | 2018 | 23 | 1850654 | 452 | 0 | TBC | weekly | |
1151 | 1151 | Latvia | Latvia | 0 | 2018-06-11 | 2018-06-17 | 7 | 2018 | 24 | 1850654 | 455 | 0 | TBC | weekly | |
1152 | 1152 | Latvia | Latvia | 0 | 2018-06-18 | 2018-06-24 | 7 | 2018 | 25 | 1850654 | 491 | 0 | TBC | weekly | |
1153 | 1153 | Latvia | Latvia | 0 | 2018-06-25 | 2018-07-01 | 7 | 2018 | 26 | 1850654 | 495 | 0 | TBC | weekly | |
1154 | 1154 | Latvia | Latvia | 0 | 2018-07-02 | 2018-07-08 | 7 | 2018 | 27 | 1850654 | 492 | 0 | TBC | weekly | |
1155 | 1155 | Latvia | Latvia | 0 | 2018-07-09 | 2018-07-15 | 7 | 2018 | 28 | 1850654 | 534 | 0 | TBC | weekly | |
1156 | 1156 | Latvia | Latvia | 0 | 2018-07-16 | 2018-07-22 | 7 | 2018 | 29 | 1850654 | 587 | 0 | TBC | weekly | |
1157 | 1157 | Latvia | Latvia | 0 | 2018-07-23 | 2018-07-29 | 7 | 2018 | 30 | 1850654 | 528 | 0 | TBC | weekly | |
1158 | 1158 | Latvia | Latvia | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 1850654 | 592 | 0 | TBC | weekly | |
1159 | 1159 | Latvia | Latvia | 0 | 2018-08-06 | 2018-08-12 | 7 | 2018 | 32 | 1850654 | 484 | 0 | TBC | weekly | |
1160 | 1160 | Latvia | Latvia | 0 | 2018-08-13 | 2018-08-19 | 7 | 2018 | 33 | 1850654 | 440 | 0 | TBC | weekly | |
1161 | 1161 | Latvia | Latvia | 0 | 2018-08-20 | 2018-08-26 | 7 | 2018 | 34 | 1850654 | 483 | 0 | TBC | weekly | |
1162 | 1162 | Latvia | Latvia | 0 | 2018-08-27 | 2018-09-02 | 7 | 2018 | 35 | 1850654 | 486 | 0 | TBC | weekly | |
1163 | 1163 | Latvia | Latvia | 0 | 2018-09-03 | 2018-09-09 | 7 | 2018 | 36 | 1850654 | 521 | 0 | TBC | weekly | |
1164 | 1164 | Latvia | Latvia | 0 | 2018-09-10 | 2018-09-16 | 7 | 2018 | 37 | 1850654 | 466 | 0 | TBC | weekly | |
1165 | 1165 | Latvia | Latvia | 0 | 2018-09-17 | 2018-09-23 | 7 | 2018 | 38 | 1850654 | 513 | 0 | TBC | weekly | |
1166 | 1166 | Latvia | Latvia | 0 | 2018-09-24 | 2018-09-30 | 7 | 2018 | 39 | 1850654 | 503 | 0 | TBC | weekly | |
1167 | 1167 | Latvia | Latvia | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 1850654 | 545 | 0 | TBC | weekly | |
1168 | 1168 | Latvia | Latvia | 0 | 2018-10-08 | 2018-10-14 | 7 | 2018 | 41 | 1850654 | 501 | 0 | TBC | weekly | |
1169 | 1169 | Latvia | Latvia | 0 | 2018-10-15 | 2018-10-21 | 7 | 2018 | 42 | 1850654 | 502 | 0 | TBC | weekly | |
1170 | 1170 | Latvia | Latvia | 0 | 2018-10-22 | 2018-10-28 | 7 | 2018 | 43 | 1850654 | 514 | 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]);