economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
5,884 rows where year = 2019
This data as json, yaml, Notebook, copyable, CSV (advanced)
country >30
- United States 2,704
- Australia 52
- Austria 52
- Belgium 52
- Britain 52
- Bulgaria 52
- Canada 52
- Chile 52
- Colombia 52
- Croatia 52
- Cyprus 52
- Czech Republic 52
- Denmark 52
- Estonia 52
- Finland 52
- France 52
- Germany 52
- Greece 52
- Guatemala 52
- Hungary 52
- Iceland 52
- Iran 52
- Israel 52
- Italy 52
- Latvia 52
- Lithuania 52
- Luxembourg 52
- Malta 52
- Mexico 52
- Montenegro 52
- …
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
730 | 730 | Ecuador | Ecuador | 0 | 2019-09-09 | 2019-09-15 | 7 | 2019 | 37 | 18001002 | 1447 | 0 | TBC | weekly | |
731 | 731 | Ecuador | Ecuador | 0 | 2019-09-16 | 2019-09-22 | 7 | 2019 | 38 | 18001002 | 1402 | 0 | TBC | weekly | |
732 | 732 | Ecuador | Ecuador | 0 | 2019-09-23 | 2019-09-29 | 7 | 2019 | 39 | 18001002 | 1398 | 0 | TBC | weekly | |
733 | 733 | Ecuador | Ecuador | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 18001002 | 1325 | 0 | TBC | weekly | |
734 | 734 | Ecuador | Ecuador | 0 | 2019-10-07 | 2019-10-13 | 7 | 2019 | 41 | 18001002 | 1349 | 0 | TBC | weekly | |
735 | 735 | Ecuador | Ecuador | 0 | 2019-10-14 | 2019-10-20 | 7 | 2019 | 42 | 18001002 | 1371 | 0 | TBC | weekly | |
736 | 736 | Ecuador | Ecuador | 0 | 2019-10-21 | 2019-10-27 | 7 | 2019 | 43 | 18001002 | 1306 | 0 | TBC | weekly | |
737 | 737 | Ecuador | Ecuador | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 18001002 | 1426 | 0 | TBC | weekly | |
738 | 738 | Ecuador | Ecuador | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 18001002 | 1432 | 0 | TBC | weekly | |
739 | 739 | Ecuador | Ecuador | 0 | 2019-11-11 | 2019-11-17 | 7 | 2019 | 46 | 18001002 | 1384 | 0 | TBC | weekly | |
740 | 740 | Ecuador | Ecuador | 0 | 2019-11-18 | 2019-11-24 | 7 | 2019 | 47 | 18001002 | 1441 | 0 | TBC | weekly | |
741 | 741 | Ecuador | Ecuador | 0 | 2019-11-25 | 2019-12-01 | 7 | 2019 | 48 | 18001002 | 1381 | 0 | TBC | weekly | |
742 | 742 | Ecuador | Ecuador | 0 | 2019-12-02 | 2019-12-08 | 7 | 2019 | 49 | 18001002 | 1350 | 0 | TBC | weekly | |
743 | 743 | Ecuador | Ecuador | 0 | 2019-12-09 | 2019-12-15 | 7 | 2019 | 50 | 18001002 | 1479 | 0 | TBC | weekly | |
744 | 744 | Ecuador | Ecuador | 0 | 2019-12-16 | 2019-12-22 | 7 | 2019 | 51 | 18001002 | 1359 | 0 | TBC | weekly | |
745 | 745 | Ecuador | Ecuador | 0 | 2019-12-23 | 2019-12-29 | 7 | 2019 | 52 | 18001002 | 1127 | 0 | TBC | weekly | |
947 | 947 | Maldives | Maldives | 0 | 2019-01-01 | 2019-01-31 | 31 | 2019 | 523798 | 110 | 0 | TBC | monthly | 1 | |
948 | 948 | Maldives | Maldives | 0 | 2019-02-01 | 2019-02-28 | 28 | 2019 | 523798 | 78 | 0 | TBC | monthly | 2 | |
949 | 949 | Maldives | Maldives | 0 | 2019-03-01 | 2019-03-31 | 31 | 2019 | 523798 | 101 | 0 | TBC | monthly | 3 | |
950 | 950 | Maldives | Maldives | 0 | 2019-04-01 | 2019-04-30 | 30 | 2019 | 523798 | 87 | 0 | TBC | monthly | 4 | |
951 | 951 | Maldives | Maldives | 0 | 2019-05-01 | 2019-05-31 | 31 | 2019 | 523798 | 89 | 0 | TBC | monthly | 5 | |
952 | 952 | Maldives | Maldives | 0 | 2019-06-01 | 2019-06-30 | 30 | 2019 | 523798 | 80 | 0 | TBC | monthly | 6 | |
953 | 953 | Maldives | Maldives | 0 | 2019-07-01 | 2019-07-31 | 31 | 2019 | 523798 | 98 | 0 | TBC | monthly | 7 | |
954 | 954 | Maldives | Maldives | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 523798 | 85 | 0 | TBC | monthly | 8 | |
955 | 955 | Maldives | Maldives | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 523798 | 78 | 0 | TBC | monthly | 9 | |
956 | 956 | Maldives | Maldives | 0 | 2019-10-01 | 2019-10-31 | 31 | 2019 | 523798 | 91 | 0 | TBC | monthly | 10 | |
957 | 957 | Maldives | Maldives | 0 | 2019-11-01 | 2019-11-30 | 30 | 2019 | 523798 | 86 | 0 | TBC | monthly | 11 | |
958 | 958 | Maldives | Maldives | 0 | 2019-12-01 | 2019-12-31 | 31 | 2019 | 523798 | 58 | 0 | TBC | monthly | 12 | |
1180 | 1180 | Latvia | Latvia | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 1850654 | 586 | 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 | |
1183 | 1183 | Latvia | Latvia | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 1850654 | 612 | 0 | TBC | weekly | |
1184 | 1184 | Latvia | Latvia | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 1850654 | 636 | 0 | TBC | weekly | |
1185 | 1185 | Latvia | Latvia | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 1850654 | 619 | 0 | TBC | weekly | |
1186 | 1186 | Latvia | Latvia | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 1850654 | 599 | 0 | TBC | weekly | |
1187 | 1187 | Latvia | Latvia | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 1850654 | 596 | 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 | |
1190 | 1190 | Latvia | Latvia | 0 | 2019-03-11 | 2019-03-17 | 7 | 2019 | 11 | 1850654 | 533 | 0 | TBC | weekly | |
1191 | 1191 | Latvia | Latvia | 0 | 2019-03-18 | 2019-03-24 | 7 | 2019 | 12 | 1850654 | 557 | 0 | TBC | weekly | |
1192 | 1192 | Latvia | Latvia | 0 | 2019-03-25 | 2019-03-31 | 7 | 2019 | 13 | 1850654 | 562 | 0 | TBC | weekly | |
1193 | 1193 | Latvia | Latvia | 0 | 2019-04-01 | 2019-04-07 | 7 | 2019 | 14 | 1850654 | 523 | 0 | TBC | weekly | |
1194 | 1194 | Latvia | Latvia | 0 | 2019-04-08 | 2019-04-14 | 7 | 2019 | 15 | 1850654 | 552 | 0 | TBC | weekly | |
1195 | 1195 | Latvia | Latvia | 0 | 2019-04-15 | 2019-04-21 | 7 | 2019 | 16 | 1850654 | 509 | 0 | TBC | weekly | |
1196 | 1196 | Latvia | Latvia | 0 | 2019-04-22 | 2019-04-28 | 7 | 2019 | 17 | 1850654 | 564 | 0 | TBC | weekly | |
1197 | 1197 | Latvia | Latvia | 0 | 2019-04-29 | 2019-05-05 | 7 | 2019 | 18 | 1850654 | 455 | 0 | TBC | weekly | |
1198 | 1198 | Latvia | Latvia | 0 | 2019-05-06 | 2019-05-12 | 7 | 2019 | 19 | 1850654 | 545 | 0 | TBC | weekly | |
1199 | 1199 | Latvia | Latvia | 0 | 2019-05-13 | 2019-05-19 | 7 | 2019 | 20 | 1850654 | 501 | 0 | TBC | weekly | |
1200 | 1200 | Latvia | Latvia | 0 | 2019-05-20 | 2019-05-26 | 7 | 2019 | 21 | 1850654 | 533 | 0 | TBC | weekly | |
1201 | 1201 | Latvia | Latvia | 0 | 2019-05-27 | 2019-06-02 | 7 | 2019 | 22 | 1850654 | 490 | 0 | TBC | weekly | |
1202 | 1202 | Latvia | Latvia | 0 | 2019-06-03 | 2019-06-09 | 7 | 2019 | 23 | 1850654 | 498 | 0 | TBC | weekly | |
1203 | 1203 | Latvia | Latvia | 0 | 2019-06-10 | 2019-06-16 | 7 | 2019 | 24 | 1850654 | 488 | 0 | TBC | weekly | |
1204 | 1204 | Latvia | Latvia | 0 | 2019-06-17 | 2019-06-23 | 7 | 2019 | 25 | 1850654 | 505 | 0 | TBC | weekly | |
1205 | 1205 | Latvia | Latvia | 0 | 2019-06-24 | 2019-06-30 | 7 | 2019 | 26 | 1850654 | 469 | 0 | TBC | weekly | |
1206 | 1206 | Latvia | Latvia | 0 | 2019-07-01 | 2019-07-07 | 7 | 2019 | 27 | 1850654 | 483 | 0 | TBC | weekly | |
1207 | 1207 | Latvia | Latvia | 0 | 2019-07-08 | 2019-07-14 | 7 | 2019 | 28 | 1850654 | 493 | 0 | TBC | weekly | |
1208 | 1208 | Latvia | Latvia | 0 | 2019-07-15 | 2019-07-21 | 7 | 2019 | 29 | 1850654 | 535 | 0 | TBC | weekly | |
1209 | 1209 | Latvia | Latvia | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 1850654 | 492 | 0 | TBC | weekly | |
1210 | 1210 | Latvia | Latvia | 0 | 2019-07-29 | 2019-08-04 | 7 | 2019 | 31 | 1850654 | 456 | 0 | TBC | weekly | |
1211 | 1211 | Latvia | Latvia | 0 | 2019-08-05 | 2019-08-11 | 7 | 2019 | 32 | 1850654 | 448 | 0 | TBC | weekly | |
1212 | 1212 | Latvia | Latvia | 0 | 2019-08-12 | 2019-08-18 | 7 | 2019 | 33 | 1850654 | 484 | 0 | TBC | weekly | |
1213 | 1213 | Latvia | Latvia | 0 | 2019-08-19 | 2019-08-25 | 7 | 2019 | 34 | 1850654 | 453 | 0 | TBC | weekly | |
1214 | 1214 | Latvia | Latvia | 0 | 2019-08-26 | 2019-09-01 | 7 | 2019 | 35 | 1850654 | 473 | 0 | TBC | weekly | |
1215 | 1215 | Latvia | Latvia | 0 | 2019-09-02 | 2019-09-08 | 7 | 2019 | 36 | 1850654 | 456 | 0 | TBC | weekly | |
1216 | 1216 | Latvia | Latvia | 0 | 2019-09-09 | 2019-09-15 | 7 | 2019 | 37 | 1850654 | 505 | 0 | TBC | weekly | |
1217 | 1217 | Latvia | Latvia | 0 | 2019-09-16 | 2019-09-22 | 7 | 2019 | 38 | 1850654 | 463 | 0 | TBC | weekly | |
1218 | 1218 | Latvia | Latvia | 0 | 2019-09-23 | 2019-09-29 | 7 | 2019 | 39 | 1850654 | 562 | 0 | TBC | weekly | |
1219 | 1219 | Latvia | Latvia | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 1850654 | 534 | 0 | TBC | weekly | |
1220 | 1220 | Latvia | Latvia | 0 | 2019-10-07 | 2019-10-13 | 7 | 2019 | 41 | 1850654 | 532 | 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 | |
1223 | 1223 | Latvia | Latvia | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 1850654 | 509 | 0 | TBC | weekly | |
1224 | 1224 | Latvia | Latvia | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 1850654 | 486 | 0 | TBC | weekly | |
1225 | 1225 | Latvia | Latvia | 0 | 2019-11-11 | 2019-11-17 | 7 | 2019 | 46 | 1850654 | 481 | 0 | TBC | weekly | |
1226 | 1226 | Latvia | Latvia | 0 | 2019-11-18 | 2019-11-24 | 7 | 2019 | 47 | 1850654 | 538 | 0 | TBC | weekly | |
1227 | 1227 | Latvia | Latvia | 0 | 2019-11-25 | 2019-12-01 | 7 | 2019 | 48 | 1850654 | 548 | 0 | TBC | weekly | |
1228 | 1228 | Latvia | Latvia | 0 | 2019-12-02 | 2019-12-08 | 7 | 2019 | 49 | 1850654 | 544 | 0 | TBC | weekly | |
1229 | 1229 | Latvia | Latvia | 0 | 2019-12-09 | 2019-12-15 | 7 | 2019 | 50 | 1850654 | 558 | 0 | TBC | weekly | |
1230 | 1230 | Latvia | Latvia | 0 | 2019-12-16 | 2019-12-22 | 7 | 2019 | 51 | 1850654 | 563 | 0 | TBC | weekly | |
1231 | 1231 | Latvia | Latvia | 0 | 2019-12-23 | 2019-12-29 | 7 | 2019 | 52 | 1850654 | 597 | 0 | TBC | weekly | |
1432 | 1432 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-01-01 | 2019-01-31 | 31 | 2019 | 6630621 | 3085 | 0 | TBC | monthly | 1 | |
1433 | 1433 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-02-01 | 2019-02-28 | 28 | 2019 | 6630621 | 2590 | 0 | TBC | monthly | 2 | |
1434 | 1434 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-03-01 | 2019-03-31 | 31 | 2019 | 6630621 | 2606 | 0 | TBC | monthly | 3 | |
1435 | 1435 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-04-01 | 2019-04-30 | 30 | 2019 | 6630621 | 2827 | 0 | TBC | monthly | 4 | |
1436 | 1436 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-05-01 | 2019-05-31 | 31 | 2019 | 6630621 | 2802 | 0 | TBC | monthly | 5 | |
1437 | 1437 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-06-01 | 2019-06-30 | 30 | 2019 | 6630621 | 2377 | 0 | TBC | monthly | 6 | |
1438 | 1438 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-07-01 | 2019-07-31 | 31 | 2019 | 6630621 | 3059 | 0 | TBC | monthly | 7 | |
1439 | 1439 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 6630621 | 2663 | 0 | TBC | monthly | 8 | |
1440 | 1440 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 6630621 | 2584 | 0 | TBC | monthly | 9 | |
1441 | 1441 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-10-01 | 2019-10-31 | 31 | 2019 | 6630621 | 2809 | 0 | TBC | monthly | 10 | |
1442 | 1442 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-11-01 | 2019-11-30 | 30 | 2019 | 6630621 | 2687 | 0 | TBC | monthly | 11 | |
1443 | 1443 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-12-01 | 2019-12-31 | 31 | 2019 | 6630621 | 3206 | 0 | TBC | monthly | 12 | |
1687 | 1687 | Slovakia | Slovakia | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 5643455 | 1105 | 0 | TBC | weekly | |
1688 | 1688 | Slovakia | Slovakia | 0 | 2019-01-07 | 2019-01-13 | 7 | 2019 | 2 | 5643455 | 1094 | 0 | TBC | weekly | |
1689 | 1689 | Slovakia | Slovakia | 0 | 2019-01-14 | 2019-01-20 | 7 | 2019 | 3 | 5643455 | 1176 | 0 | TBC | weekly | |
1690 | 1690 | Slovakia | Slovakia | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 5643455 | 1135 | 0 | TBC | weekly | |
1691 | 1691 | Slovakia | Slovakia | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 5643455 | 1224 | 0 | TBC | weekly | |
1692 | 1692 | Slovakia | Slovakia | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 5643455 | 1339 | 0 | TBC | weekly | |
1693 | 1693 | Slovakia | Slovakia | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 5643455 | 1252 | 0 | TBC | weekly | |
1694 | 1694 | Slovakia | Slovakia | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 5643455 | 1254 | 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]);