economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
5,727 rows where year = 2021
This data as json, yaml, Notebook, copyable, CSV (advanced)
start_date (date) >30 ✖
- 2021-08-01 109
- 2021-02-01 103
- 2021-03-01 103
- 2021-11-01 100
- 2021-01-01 59
- 2021-04-01 57
- 2021-05-01 57
- 2021-06-01 57
- 2021-07-01 57
- 2021-09-01 57
- 2021-10-01 57
- 2021-12-01 54
- 2021-01-03 52
- 2021-01-10 52
- 2021-01-17 52
- 2021-01-24 52
- 2021-01-31 52
- 2021-02-07 52
- 2021-02-14 52
- 2021-02-21 52
- 2021-02-28 52
- 2021-03-07 52
- 2021-03-14 52
- 2021-03-21 52
- 2021-03-28 52
- 2021-04-04 52
- 2021-04-11 52
- 2021-04-18 52
- 2021-04-25 52
- 2021-05-02 52
- …
end_date (date) >30 ✖
- 2021-07-31 109
- 2021-01-31 104
- 2021-02-28 103
- 2021-10-31 102
- 2021-03-31 58
- 2021-04-30 57
- 2021-05-31 57
- 2021-06-30 57
- 2021-08-31 57
- 2021-09-30 57
- 2021-11-30 55
- 2021-12-31 54
- 2021-01-09 52
- 2021-01-16 52
- 2021-01-23 52
- 2021-01-30 52
- 2021-02-06 52
- 2021-02-13 52
- 2021-02-20 52
- 2021-02-27 52
- 2021-03-06 52
- 2021-03-13 52
- 2021-03-20 52
- 2021-03-27 52
- 2021-04-03 52
- 2021-04-10 52
- 2021-04-17 52
- 2021-04-24 52
- 2021-05-01 52
- 2021-05-08 52
- …
country >30
- United States 2,756
- 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
- Ecuador 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
- …
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
314 | 314 | United States | United States | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 338289856 | 87074 | 22905 | TBC | weekly | |
315 | 315 | United States | United States | 0 | 2021-01-11 | 2021-01-17 | 7 | 2021 | 2 | 338289856 | 87415 | 23341 | TBC | weekly | |
316 | 316 | United States | United States | 0 | 2021-01-18 | 2021-01-24 | 7 | 2021 | 3 | 338289856 | 83682 | 21602 | TBC | weekly | |
317 | 317 | United States | United States | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 338289856 | 79223 | 21983 | TBC | weekly | |
318 | 318 | United States | United States | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 338289856 | 76514 | 20914 | TBC | weekly | |
319 | 319 | United States | United States | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 338289856 | 71527 | 17242 | TBC | weekly | |
320 | 320 | United States | United States | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 338289856 | 69515 | 13197 | TBC | weekly | |
321 | 321 | United States | United States | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 338289856 | 66740 | 13827 | TBC | weekly | |
322 | 322 | United States | United States | 0 | 2021-03-01 | 2021-03-07 | 7 | 2021 | 9 | 338289856 | 63727 | 11611 | TBC | weekly | |
323 | 323 | United States | United States | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 338289856 | 61867 | 8463 | TBC | weekly | |
324 | 324 | United States | United States | 0 | 2021-03-15 | 2021-03-21 | 7 | 2021 | 11 | 338289856 | 60374 | 7281 | TBC | weekly | |
325 | 325 | United States | United States | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 338289856 | 60817 | 6708 | TBC | weekly | |
326 | 326 | United States | United States | 0 | 2021-03-29 | 2021-04-04 | 7 | 2021 | 13 | 338289856 | 58699 | 5659 | TBC | weekly | |
327 | 327 | United States | United States | 0 | 2021-04-05 | 2021-04-11 | 7 | 2021 | 14 | 338289856 | 60998 | 6867 | TBC | weekly | |
328 | 328 | United States | United States | 0 | 2021-04-12 | 2021-04-18 | 7 | 2021 | 15 | 338289856 | 59149 | 5090 | TBC | weekly | |
329 | 329 | United States | United States | 0 | 2021-04-19 | 2021-04-25 | 7 | 2021 | 16 | 338289856 | 60260 | 4994 | TBC | weekly | |
330 | 330 | United States | United States | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 338289856 | 59858 | 4891 | TBC | weekly | |
331 | 331 | United States | United States | 0 | 2021-05-03 | 2021-05-09 | 7 | 2021 | 18 | 338289856 | 59014 | 4631 | TBC | weekly | |
332 | 332 | United States | United States | 0 | 2021-05-10 | 2021-05-16 | 7 | 2021 | 19 | 338289856 | 58469 | 4019 | TBC | weekly | |
333 | 333 | United States | United States | 0 | 2021-05-17 | 2021-05-23 | 7 | 2021 | 20 | 338289856 | 58760 | 3816 | TBC | weekly | |
334 | 334 | United States | United States | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 338289856 | 57358 | 4426 | TBC | weekly | |
335 | 335 | United States | United States | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 338289856 | 57459 | 3285 | TBC | weekly | |
336 | 336 | United States | United States | 0 | 2021-06-07 | 2021-06-13 | 7 | 2021 | 23 | 338289856 | 57179 | 2402 | TBC | weekly | |
337 | 337 | United States | United States | 0 | 2021-06-14 | 2021-06-20 | 7 | 2021 | 24 | 338289856 | 57243 | 2043 | TBC | weekly | |
338 | 338 | United States | United States | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 338289856 | 56933 | 2095 | TBC | weekly | |
339 | 339 | United States | United States | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 338289856 | 57530 | 1628 | TBC | weekly | |
340 | 340 | United States | United States | 0 | 2021-07-05 | 2021-07-11 | 7 | 2021 | 27 | 338289856 | 57219 | 1665 | TBC | weekly | |
341 | 341 | United States | United States | 0 | 2021-07-12 | 2021-07-18 | 7 | 2021 | 28 | 338289856 | 57217 | 1895 | TBC | weekly | |
342 | 342 | United States | United States | 0 | 2021-07-19 | 2021-07-25 | 7 | 2021 | 29 | 338289856 | 58475 | 1929 | TBC | weekly | |
343 | 343 | United States | United States | 0 | 2021-07-26 | 2021-08-01 | 7 | 2021 | 30 | 338289856 | 60317 | 2703 | TBC | weekly | |
344 | 344 | United States | United States | 0 | 2021-08-02 | 2021-08-08 | 7 | 2021 | 31 | 338289856 | 63820 | 3535 | TBC | weekly | |
345 | 345 | United States | United States | 0 | 2021-08-09 | 2021-08-15 | 7 | 2021 | 32 | 338289856 | 67050 | 4732 | TBC | weekly | |
346 | 346 | United States | United States | 0 | 2021-08-16 | 2021-08-22 | 7 | 2021 | 33 | 338289856 | 69962 | 7315 | TBC | weekly | |
347 | 347 | United States | United States | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 338289856 | 72188 | 9267 | TBC | weekly | |
348 | 348 | United States | United States | 0 | 2021-08-30 | 2021-09-05 | 7 | 2021 | 35 | 338289856 | 73524 | 11229 | TBC | weekly | |
349 | 349 | United States | United States | 0 | 2021-09-06 | 2021-09-12 | 7 | 2021 | 36 | 338289856 | 73745 | 11931 | TBC | weekly | |
350 | 350 | United States | United States | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 338289856 | 73317 | 14185 | TBC | weekly | |
351 | 351 | United States | United States | 0 | 2021-09-20 | 2021-09-26 | 7 | 2021 | 38 | 338289856 | 72188 | 14686 | TBC | weekly | |
352 | 352 | United States | United States | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 338289856 | 71368 | 13767 | TBC | weekly | |
353 | 353 | United States | United States | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 338289856 | 69136 | 11709 | TBC | weekly | |
354 | 354 | United States | United States | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 338289856 | 67575 | 11748 | TBC | weekly | |
355 | 355 | United States | United States | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 338289856 | 67064 | 11663 | TBC | weekly | |
356 | 356 | United States | United States | 0 | 2021-10-25 | 2021-10-31 | 7 | 2021 | 43 | 338289856 | 66479 | 9382 | TBC | weekly | |
357 | 357 | United States | United States | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 338289856 | 66623 | 8594 | TBC | weekly | |
358 | 358 | United States | United States | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 338289856 | 67467 | 8543 | TBC | weekly | |
359 | 359 | United States | United States | 0 | 2021-11-15 | 2021-11-21 | 7 | 2021 | 46 | 338289856 | 66964 | 8103 | TBC | weekly | |
360 | 360 | United States | United States | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 338289856 | 67969 | 5798 | TBC | weekly | |
361 | 361 | United States | United States | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 338289856 | 70209 | 12174 | TBC | weekly | |
362 | 362 | United States | United States | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 338289856 | 72148 | 9068 | TBC | weekly | |
363 | 363 | United States | United States | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 338289856 | 71355 | 9279 | TBC | weekly | |
364 | 364 | United States | United States | 0 | 2021-12-20 | 2021-12-26 | 7 | 2021 | 51 | 338289856 | 72326 | 10361 | TBC | weekly | |
365 | 365 | United States | United States | 0 | 2021-12-27 | 2022-01-02 | 7 | 2021 | 52 | 338289856 | 74430 | 9533 | TBC | weekly | |
799 | 799 | Ecuador | Ecuador | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 18001002 | 2007 | 118 | TBC | weekly | |
800 | 800 | Ecuador | Ecuador | 0 | 2021-01-11 | 2021-01-17 | 7 | 2021 | 2 | 18001002 | 2195 | 142 | TBC | weekly | |
801 | 801 | Ecuador | Ecuador | 0 | 2021-01-18 | 2021-01-24 | 7 | 2021 | 3 | 18001002 | 2345 | 304 | TBC | weekly | |
802 | 802 | Ecuador | Ecuador | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 18001002 | 2211 | 236 | TBC | weekly | |
803 | 803 | Ecuador | Ecuador | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 18001002 | 2236 | 153 | TBC | weekly | |
804 | 804 | Ecuador | Ecuador | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 18001002 | 2216 | 309 | TBC | weekly | |
805 | 805 | Ecuador | Ecuador | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 18001002 | 2253 | 215 | TBC | weekly | |
806 | 806 | Ecuador | Ecuador | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 18001002 | 2279 | 275 | TBC | weekly | |
807 | 807 | Ecuador | Ecuador | 0 | 2021-03-01 | 2021-03-07 | 7 | 2021 | 9 | 18001002 | 2223 | 228 | TBC | weekly | |
808 | 808 | Ecuador | Ecuador | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 18001002 | 2425 | 197 | TBC | weekly | |
809 | 809 | Ecuador | Ecuador | 0 | 2021-03-15 | 2021-03-21 | 7 | 2021 | 11 | 18001002 | 2639 | 215 | TBC | weekly | |
810 | 810 | Ecuador | Ecuador | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 18001002 | 2715 | 287 | TBC | weekly | |
811 | 811 | Ecuador | Ecuador | 0 | 2021-03-29 | 2021-04-04 | 7 | 2021 | 13 | 18001002 | 2858 | 218 | TBC | weekly | |
812 | 812 | Ecuador | Ecuador | 0 | 2021-04-05 | 2021-04-11 | 7 | 2021 | 14 | 18001002 | 3053 | 337 | TBC | weekly | |
813 | 813 | Ecuador | Ecuador | 0 | 2021-04-12 | 2021-04-18 | 7 | 2021 | 15 | 18001002 | 3147 | 410 | TBC | weekly | |
814 | 814 | Ecuador | Ecuador | 0 | 2021-04-19 | 2021-04-25 | 7 | 2021 | 16 | 18001002 | 3270 | 474 | TBC | weekly | |
815 | 815 | Ecuador | Ecuador | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 18001002 | 3096 | 563 | TBC | weekly | |
816 | 816 | Ecuador | Ecuador | 0 | 2021-05-03 | 2021-05-09 | 7 | 2021 | 18 | 18001002 | 2901 | 482 | TBC | weekly | |
817 | 817 | Ecuador | Ecuador | 0 | 2021-05-10 | 2021-05-16 | 7 | 2021 | 19 | 18001002 | 2584 | 477 | TBC | weekly | |
818 | 818 | Ecuador | Ecuador | 0 | 2021-05-17 | 2021-05-23 | 7 | 2021 | 20 | 18001002 | 2390 | 494 | TBC | weekly | |
819 | 819 | Ecuador | Ecuador | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 18001002 | 2186 | 352 | TBC | weekly | |
820 | 820 | Ecuador | Ecuador | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 18001002 | 2003 | 264 | TBC | weekly | |
821 | 821 | Ecuador | Ecuador | 0 | 2021-06-07 | 2021-06-13 | 7 | 2021 | 23 | 18001002 | 1984 | 239 | TBC | weekly | |
822 | 822 | Ecuador | Ecuador | 0 | 2021-06-14 | 2021-06-20 | 7 | 2021 | 24 | 18001002 | 1935 | 245 | TBC | weekly | |
823 | 823 | Ecuador | Ecuador | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 18001002 | 1918 | 230 | TBC | weekly | |
824 | 824 | Ecuador | Ecuador | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 18001002 | 1835 | 137 | TBC | weekly | |
825 | 825 | Ecuador | Ecuador | 0 | 2021-07-05 | 2021-07-11 | 7 | 2021 | 27 | 18001002 | 1886 | 170 | TBC | weekly | |
826 | 826 | Ecuador | Ecuador | 0 | 2021-07-12 | 2021-07-18 | 7 | 2021 | 28 | 18001002 | 1818 | 123 | TBC | weekly | |
827 | 827 | Ecuador | Ecuador | 0 | 2021-07-19 | 2021-07-25 | 7 | 2021 | 29 | 18001002 | 1745 | 58 | TBC | weekly | |
828 | 828 | Ecuador | Ecuador | 0 | 2021-07-26 | 2021-08-01 | 7 | 2021 | 30 | 18001002 | 1770 | 837 | TBC | weekly | |
829 | 829 | Ecuador | Ecuador | 0 | 2021-08-02 | 2021-08-08 | 7 | 2021 | 31 | 18001002 | 1626 | 161 | TBC | weekly | |
830 | 830 | Ecuador | Ecuador | 0 | 2021-08-09 | 2021-08-15 | 7 | 2021 | 32 | 18001002 | 1590 | 178 | TBC | weekly | |
831 | 831 | Ecuador | Ecuador | 0 | 2021-08-16 | 2021-08-22 | 7 | 2021 | 33 | 18001002 | 1554 | 114 | TBC | weekly | |
832 | 832 | Ecuador | Ecuador | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 18001002 | 1617 | 145 | TBC | weekly | |
833 | 833 | Ecuador | Ecuador | 0 | 2021-08-30 | 2021-09-05 | 7 | 2021 | 35 | 18001002 | 1577 | 120 | TBC | weekly | |
834 | 834 | Ecuador | Ecuador | 0 | 2021-09-06 | 2021-09-12 | 7 | 2021 | 36 | 18001002 | 1530 | 96 | TBC | weekly | |
835 | 835 | Ecuador | Ecuador | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 18001002 | 1548 | 213 | TBC | weekly | |
836 | 836 | Ecuador | Ecuador | 0 | 2021-09-20 | 2021-09-26 | 7 | 2021 | 38 | 18001002 | 1498 | 86 | TBC | weekly | |
837 | 837 | Ecuador | Ecuador | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 18001002 | 1613 | 58 | TBC | weekly | |
838 | 838 | Ecuador | Ecuador | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 18001002 | 1504 | 42 | TBC | weekly | |
839 | 839 | Ecuador | Ecuador | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 18001002 | 1559 | 81 | TBC | weekly | |
840 | 840 | Ecuador | Ecuador | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 18001002 | 1482 | 24 | TBC | weekly | |
841 | 841 | Ecuador | Ecuador | 0 | 2021-10-25 | 2021-10-31 | 7 | 2021 | 43 | 18001002 | 1475 | 28 | TBC | weekly | |
842 | 842 | Ecuador | Ecuador | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 18001002 | 1477 | 9 | TBC | weekly | |
843 | 843 | Ecuador | Ecuador | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 18001002 | 1586 | 99 | TBC | weekly | |
844 | 844 | Ecuador | Ecuador | 0 | 2021-11-15 | 2021-11-21 | 7 | 2021 | 46 | 18001002 | 1609 | 37 | TBC | weekly | |
845 | 845 | Ecuador | Ecuador | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 18001002 | 1593 | 109 | TBC | weekly | |
846 | 846 | Ecuador | Ecuador | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 18001002 | 1530 | 250 | 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]);