economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "Latvia" and year = 2019 sorted by total_deaths
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1211 | 1211 | Latvia | Latvia | 0 | 2019-08-05 | 2019-08-11 | 7 | 2019 | 32 | 1850654 | 448 | 0 | TBC | weekly | |
1213 | 1213 | Latvia | Latvia | 0 | 2019-08-19 | 2019-08-25 | 7 | 2019 | 34 | 1850654 | 453 | 0 | TBC | weekly | |
1197 | 1197 | Latvia | Latvia | 0 | 2019-04-29 | 2019-05-05 | 7 | 2019 | 18 | 1850654 | 455 | 0 | TBC | weekly | |
1210 | 1210 | Latvia | Latvia | 0 | 2019-07-29 | 2019-08-04 | 7 | 2019 | 31 | 1850654 | 456 | 0 | TBC | weekly | |
1215 | 1215 | Latvia | Latvia | 0 | 2019-09-02 | 2019-09-08 | 7 | 2019 | 36 | 1850654 | 456 | 0 | TBC | weekly | |
1217 | 1217 | Latvia | Latvia | 0 | 2019-09-16 | 2019-09-22 | 7 | 2019 | 38 | 1850654 | 463 | 0 | TBC | weekly | |
1205 | 1205 | Latvia | Latvia | 0 | 2019-06-24 | 2019-06-30 | 7 | 2019 | 26 | 1850654 | 469 | 0 | TBC | weekly | |
1214 | 1214 | Latvia | Latvia | 0 | 2019-08-26 | 2019-09-01 | 7 | 2019 | 35 | 1850654 | 473 | 0 | TBC | weekly | |
1225 | 1225 | Latvia | Latvia | 0 | 2019-11-11 | 2019-11-17 | 7 | 2019 | 46 | 1850654 | 481 | 0 | TBC | weekly | |
1206 | 1206 | Latvia | Latvia | 0 | 2019-07-01 | 2019-07-07 | 7 | 2019 | 27 | 1850654 | 483 | 0 | TBC | weekly | |
1212 | 1212 | Latvia | Latvia | 0 | 2019-08-12 | 2019-08-18 | 7 | 2019 | 33 | 1850654 | 484 | 0 | TBC | weekly | |
1224 | 1224 | Latvia | Latvia | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 1850654 | 486 | 0 | TBC | weekly | |
1203 | 1203 | Latvia | Latvia | 0 | 2019-06-10 | 2019-06-16 | 7 | 2019 | 24 | 1850654 | 488 | 0 | TBC | weekly | |
1201 | 1201 | Latvia | Latvia | 0 | 2019-05-27 | 2019-06-02 | 7 | 2019 | 22 | 1850654 | 490 | 0 | TBC | weekly | |
1209 | 1209 | Latvia | Latvia | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 1850654 | 492 | 0 | TBC | weekly | |
1207 | 1207 | Latvia | Latvia | 0 | 2019-07-08 | 2019-07-14 | 7 | 2019 | 28 | 1850654 | 493 | 0 | TBC | weekly | |
1202 | 1202 | Latvia | Latvia | 0 | 2019-06-03 | 2019-06-09 | 7 | 2019 | 23 | 1850654 | 498 | 0 | TBC | weekly | |
1199 | 1199 | Latvia | Latvia | 0 | 2019-05-13 | 2019-05-19 | 7 | 2019 | 20 | 1850654 | 501 | 0 | TBC | weekly | |
1204 | 1204 | Latvia | Latvia | 0 | 2019-06-17 | 2019-06-23 | 7 | 2019 | 25 | 1850654 | 505 | 0 | TBC | weekly | |
1216 | 1216 | Latvia | Latvia | 0 | 2019-09-09 | 2019-09-15 | 7 | 2019 | 37 | 1850654 | 505 | 0 | TBC | weekly | |
1195 | 1195 | Latvia | Latvia | 0 | 2019-04-15 | 2019-04-21 | 7 | 2019 | 16 | 1850654 | 509 | 0 | TBC | weekly | |
1223 | 1223 | Latvia | Latvia | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 1850654 | 509 | 0 | TBC | weekly | |
1221 | 1221 | Latvia | Latvia | 0 | 2019-10-14 | 2019-10-20 | 7 | 2019 | 42 | 1850654 | 511 | 0 | TBC | weekly | |
1222 | 1222 | Latvia | Latvia | 0 | 2019-10-21 | 2019-10-27 | 7 | 2019 | 43 | 1850654 | 511 | 0 | TBC | weekly | |
1193 | 1193 | Latvia | Latvia | 0 | 2019-04-01 | 2019-04-07 | 7 | 2019 | 14 | 1850654 | 523 | 0 | TBC | weekly | |
1220 | 1220 | Latvia | Latvia | 0 | 2019-10-07 | 2019-10-13 | 7 | 2019 | 41 | 1850654 | 532 | 0 | TBC | weekly | |
1190 | 1190 | Latvia | Latvia | 0 | 2019-03-11 | 2019-03-17 | 7 | 2019 | 11 | 1850654 | 533 | 0 | TBC | weekly | |
1200 | 1200 | Latvia | Latvia | 0 | 2019-05-20 | 2019-05-26 | 7 | 2019 | 21 | 1850654 | 533 | 0 | TBC | weekly | |
1219 | 1219 | Latvia | Latvia | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 1850654 | 534 | 0 | TBC | weekly | |
1208 | 1208 | Latvia | Latvia | 0 | 2019-07-15 | 2019-07-21 | 7 | 2019 | 29 | 1850654 | 535 | 0 | TBC | weekly | |
1226 | 1226 | Latvia | Latvia | 0 | 2019-11-18 | 2019-11-24 | 7 | 2019 | 47 | 1850654 | 538 | 0 | TBC | weekly | |
1228 | 1228 | Latvia | Latvia | 0 | 2019-12-02 | 2019-12-08 | 7 | 2019 | 49 | 1850654 | 544 | 0 | TBC | weekly | |
1198 | 1198 | Latvia | Latvia | 0 | 2019-05-06 | 2019-05-12 | 7 | 2019 | 19 | 1850654 | 545 | 0 | TBC | weekly | |
1227 | 1227 | Latvia | Latvia | 0 | 2019-11-25 | 2019-12-01 | 7 | 2019 | 48 | 1850654 | 548 | 0 | TBC | weekly | |
1194 | 1194 | Latvia | Latvia | 0 | 2019-04-08 | 2019-04-14 | 7 | 2019 | 15 | 1850654 | 552 | 0 | TBC | weekly | |
1191 | 1191 | Latvia | Latvia | 0 | 2019-03-18 | 2019-03-24 | 7 | 2019 | 12 | 1850654 | 557 | 0 | TBC | weekly | |
1229 | 1229 | Latvia | Latvia | 0 | 2019-12-09 | 2019-12-15 | 7 | 2019 | 50 | 1850654 | 558 | 0 | TBC | weekly | |
1192 | 1192 | Latvia | Latvia | 0 | 2019-03-25 | 2019-03-31 | 7 | 2019 | 13 | 1850654 | 562 | 0 | TBC | weekly | |
1218 | 1218 | Latvia | Latvia | 0 | 2019-09-23 | 2019-09-29 | 7 | 2019 | 39 | 1850654 | 562 | 0 | TBC | weekly | |
1230 | 1230 | Latvia | Latvia | 0 | 2019-12-16 | 2019-12-22 | 7 | 2019 | 51 | 1850654 | 563 | 0 | TBC | weekly | |
1196 | 1196 | Latvia | Latvia | 0 | 2019-04-22 | 2019-04-28 | 7 | 2019 | 17 | 1850654 | 564 | 0 | TBC | weekly | |
1188 | 1188 | Latvia | Latvia | 0 | 2019-02-25 | 2019-03-03 | 7 | 2019 | 9 | 1850654 | 572 | 0 | TBC | weekly | |
1189 | 1189 | Latvia | Latvia | 0 | 2019-03-04 | 2019-03-10 | 7 | 2019 | 10 | 1850654 | 575 | 0 | TBC | weekly | |
1180 | 1180 | Latvia | Latvia | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 1850654 | 586 | 0 | TBC | weekly | |
1187 | 1187 | Latvia | Latvia | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 1850654 | 596 | 0 | TBC | weekly | |
1231 | 1231 | Latvia | Latvia | 0 | 2019-12-23 | 2019-12-29 | 7 | 2019 | 52 | 1850654 | 597 | 0 | TBC | weekly | |
1186 | 1186 | Latvia | Latvia | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 1850654 | 599 | 0 | TBC | weekly | |
1183 | 1183 | Latvia | Latvia | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 1850654 | 612 | 0 | TBC | weekly | |
1185 | 1185 | Latvia | Latvia | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 1850654 | 619 | 0 | TBC | weekly | |
1184 | 1184 | Latvia | Latvia | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 1850654 | 636 | 0 | TBC | weekly | |
1181 | 1181 | Latvia | Latvia | 0 | 2019-01-07 | 2019-01-13 | 7 | 2019 | 2 | 1850654 | 669 | 0 | TBC | weekly | |
1182 | 1182 | Latvia | Latvia | 0 | 2019-01-14 | 2019-01-20 | 7 | 2019 | 3 | 1850654 | 669 | 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]);