economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
308 rows where population = 5639632
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: year, start_date (date), end_date (date)
country 1
- United States 308
cadence 1
- weekly 308
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28543 | 28543 | United States | Minnesota | MN | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 5639632 | 885 | 0 | 843 | weekly | |
28544 | 28544 | United States | Minnesota | MN | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 5639632 | 916 | 0 | 845 | weekly | |
28545 | 28545 | United States | Minnesota | MN | 2017-01-15 | 2017-01-21 | 7 | 2017 | 3 | 5639632 | 867 | 0 | 846 | weekly | |
28546 | 28546 | United States | Minnesota | MN | 2017-01-22 | 2017-01-28 | 7 | 2017 | 4 | 5639632 | 909 | 0 | 844 | weekly | |
28547 | 28547 | United States | Minnesota | MN | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 5639632 | 893 | 0 | 847 | weekly | |
28548 | 28548 | United States | Minnesota | MN | 2017-02-05 | 2017-02-11 | 7 | 2017 | 6 | 5639632 | 892 | 0 | 845 | weekly | |
28549 | 28549 | United States | Minnesota | MN | 2017-02-12 | 2017-02-18 | 7 | 2017 | 7 | 5639632 | 963 | 0 | 842 | weekly | |
28550 | 28550 | United States | Minnesota | MN | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 5639632 | 880 | 0 | 842 | weekly | |
28551 | 28551 | United States | Minnesota | MN | 2017-02-26 | 2017-03-04 | 7 | 2017 | 9 | 5639632 | 905 | 0 | 838 | weekly | |
28552 | 28552 | United States | Minnesota | MN | 2017-03-05 | 2017-03-11 | 7 | 2017 | 10 | 5639632 | 880 | 0 | 831 | weekly | |
28553 | 28553 | United States | Minnesota | MN | 2017-03-12 | 2017-03-18 | 7 | 2017 | 11 | 5639632 | 867 | 0 | 829 | weekly | |
28554 | 28554 | United States | Minnesota | MN | 2017-03-19 | 2017-03-25 | 7 | 2017 | 12 | 5639632 | 949 | 0 | 825 | weekly | |
28555 | 28555 | United States | Minnesota | MN | 2017-03-26 | 2017-04-01 | 7 | 2017 | 13 | 5639632 | 845 | 0 | 824 | weekly | |
28556 | 28556 | United States | Minnesota | MN | 2017-04-02 | 2017-04-08 | 7 | 2017 | 14 | 5639632 | 889 | 0 | 819 | weekly | |
28557 | 28557 | United States | Minnesota | MN | 2017-04-09 | 2017-04-15 | 7 | 2017 | 15 | 5639632 | 946 | 0 | 813 | weekly | |
28558 | 28558 | United States | Minnesota | MN | 2017-04-16 | 2017-04-22 | 7 | 2017 | 16 | 5639632 | 834 | 0 | 811 | weekly | |
28559 | 28559 | United States | Minnesota | MN | 2017-04-23 | 2017-04-29 | 7 | 2017 | 17 | 5639632 | 834 | 0 | 808 | weekly | |
28560 | 28560 | United States | Minnesota | MN | 2017-04-30 | 2017-05-06 | 7 | 2017 | 18 | 5639632 | 806 | 0 | 805 | weekly | |
28561 | 28561 | United States | Minnesota | MN | 2017-05-07 | 2017-05-13 | 7 | 2017 | 19 | 5639632 | 839 | 0 | 800 | weekly | |
28562 | 28562 | United States | Minnesota | MN | 2017-05-14 | 2017-05-20 | 7 | 2017 | 20 | 5639632 | 843 | 0 | 799 | weekly | |
28563 | 28563 | United States | Minnesota | MN | 2017-05-21 | 2017-05-27 | 7 | 2017 | 21 | 5639632 | 819 | 0 | 797 | weekly | |
28564 | 28564 | United States | Minnesota | MN | 2017-05-28 | 2017-06-03 | 7 | 2017 | 22 | 5639632 | 835 | 0 | 796 | weekly | |
28565 | 28565 | United States | Minnesota | MN | 2017-06-04 | 2017-06-10 | 7 | 2017 | 23 | 5639632 | 749 | 0 | 797 | weekly | |
28566 | 28566 | United States | Minnesota | MN | 2017-06-11 | 2017-06-17 | 7 | 2017 | 24 | 5639632 | 737 | 0 | 793 | weekly | |
28567 | 28567 | United States | Minnesota | MN | 2017-06-18 | 2017-06-24 | 7 | 2017 | 25 | 5639632 | 757 | 0 | 793 | weekly | |
28568 | 28568 | United States | Minnesota | MN | 2017-06-25 | 2017-07-01 | 7 | 2017 | 26 | 5639632 | 800 | 0 | 795 | weekly | |
28569 | 28569 | United States | Minnesota | MN | 2017-07-02 | 2017-07-08 | 7 | 2017 | 27 | 5639632 | 775 | 0 | 796 | weekly | |
28570 | 28570 | United States | Minnesota | MN | 2017-07-09 | 2017-07-15 | 7 | 2017 | 28 | 5639632 | 750 | 0 | 795 | weekly | |
28571 | 28571 | United States | Minnesota | MN | 2017-07-16 | 2017-07-22 | 7 | 2017 | 29 | 5639632 | 776 | 0 | 799 | weekly | |
28572 | 28572 | United States | Minnesota | MN | 2017-07-23 | 2017-07-29 | 7 | 2017 | 30 | 5639632 | 787 | 0 | 803 | weekly | |
28573 | 28573 | United States | Minnesota | MN | 2017-07-30 | 2017-08-05 | 7 | 2017 | 31 | 5639632 | 769 | 0 | 806 | weekly | |
28574 | 28574 | United States | Minnesota | MN | 2017-08-06 | 2017-08-12 | 7 | 2017 | 32 | 5639632 | 819 | 0 | 809 | weekly | |
28575 | 28575 | United States | Minnesota | MN | 2017-08-13 | 2017-08-19 | 7 | 2017 | 33 | 5639632 | 761 | 0 | 816 | weekly | |
28576 | 28576 | United States | Minnesota | MN | 2017-08-20 | 2017-08-26 | 7 | 2017 | 34 | 5639632 | 776 | 0 | 822 | weekly | |
28577 | 28577 | United States | Minnesota | MN | 2017-08-27 | 2017-09-02 | 7 | 2017 | 35 | 5639632 | 829 | 0 | 827 | weekly | |
28578 | 28578 | United States | Minnesota | MN | 2017-09-03 | 2017-09-09 | 7 | 2017 | 36 | 5639632 | 808 | 0 | 833 | weekly | |
28579 | 28579 | United States | Minnesota | MN | 2017-09-10 | 2017-09-16 | 7 | 2017 | 37 | 5639632 | 836 | 0 | 841 | weekly | |
28580 | 28580 | United States | Minnesota | MN | 2017-09-17 | 2017-09-23 | 7 | 2017 | 38 | 5639632 | 817 | 0 | 847 | weekly | |
28581 | 28581 | United States | Minnesota | MN | 2017-09-24 | 2017-09-30 | 7 | 2017 | 39 | 5639632 | 840 | 0 | 858 | weekly | |
28582 | 28582 | United States | Minnesota | MN | 2017-10-01 | 2017-10-07 | 7 | 2017 | 40 | 5639632 | 833 | 0 | 870 | weekly | |
28583 | 28583 | United States | Minnesota | MN | 2017-10-08 | 2017-10-14 | 7 | 2017 | 41 | 5639632 | 816 | 0 | 874 | weekly | |
28584 | 28584 | United States | Minnesota | MN | 2017-10-15 | 2017-10-21 | 7 | 2017 | 42 | 5639632 | 872 | 0 | 881 | weekly | |
28585 | 28585 | United States | Minnesota | MN | 2017-10-22 | 2017-10-28 | 7 | 2017 | 43 | 5639632 | 908 | 0 | 893 | weekly | |
28586 | 28586 | United States | Minnesota | MN | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 5639632 | 879 | 0 | 899 | weekly | |
28587 | 28587 | United States | Minnesota | MN | 2017-11-05 | 2017-11-11 | 7 | 2017 | 45 | 5639632 | 896 | 0 | 904 | weekly | |
28588 | 28588 | United States | Minnesota | MN | 2017-11-12 | 2017-11-18 | 7 | 2017 | 46 | 5639632 | 854 | 0 | 914 | weekly | |
28589 | 28589 | United States | Minnesota | MN | 2017-11-19 | 2017-11-25 | 7 | 2017 | 47 | 5639632 | 880 | 0 | 917 | weekly | |
28590 | 28590 | United States | Minnesota | MN | 2017-11-26 | 2017-12-02 | 7 | 2017 | 48 | 5639632 | 862 | 0 | 918 | weekly | |
28591 | 28591 | United States | Minnesota | MN | 2017-12-03 | 2017-12-09 | 7 | 2017 | 49 | 5639632 | 842 | 0 | 931 | weekly | |
28592 | 28592 | United States | Minnesota | MN | 2017-12-10 | 2017-12-16 | 7 | 2017 | 50 | 5639632 | 883 | 0 | 932 | weekly | |
28593 | 28593 | United States | Minnesota | MN | 2017-12-17 | 2017-12-23 | 7 | 2017 | 51 | 5639632 | 969 | 0 | 937 | weekly | |
28594 | 28594 | United States | Minnesota | MN | 2017-12-24 | 2017-12-30 | 7 | 2017 | 52 | 5639632 | 975 | 0 | 934 | weekly | |
28595 | 28595 | United States | Minnesota | MN | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 5639632 | 1004 | 0 | 939 | weekly | |
28596 | 28596 | United States | Minnesota | MN | 2018-01-07 | 2018-01-13 | 7 | 2018 | 2 | 5639632 | 1037 | 0 | 942 | weekly | |
28597 | 28597 | United States | Minnesota | MN | 2018-01-14 | 2018-01-20 | 7 | 2018 | 3 | 5639632 | 1012 | 0 | 936 | weekly | |
28598 | 28598 | United States | Minnesota | MN | 2018-01-21 | 2018-01-27 | 7 | 2018 | 4 | 5639632 | 920 | 0 | 937 | weekly | |
28599 | 28599 | United States | Minnesota | MN | 2018-01-28 | 2018-02-03 | 7 | 2018 | 5 | 5639632 | 929 | 0 | 933 | weekly | |
28600 | 28600 | United States | Minnesota | MN | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 5639632 | 894 | 0 | 922 | weekly | |
28601 | 28601 | United States | Minnesota | MN | 2018-02-11 | 2018-02-17 | 7 | 2018 | 7 | 5639632 | 917 | 0 | 914 | weekly | |
28602 | 28602 | United States | Minnesota | MN | 2018-02-18 | 2018-02-24 | 7 | 2018 | 8 | 5639632 | 954 | 0 | 908 | weekly | |
28603 | 28603 | United States | Minnesota | MN | 2018-02-25 | 2018-03-03 | 7 | 2018 | 9 | 5639632 | 893 | 0 | 909 | weekly | |
28604 | 28604 | United States | Minnesota | MN | 2018-03-04 | 2018-03-10 | 7 | 2018 | 10 | 5639632 | 847 | 0 | 902 | weekly | |
28605 | 28605 | United States | Minnesota | MN | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 5639632 | 818 | 0 | 895 | weekly | |
28606 | 28606 | United States | Minnesota | MN | 2018-03-18 | 2018-03-24 | 7 | 2018 | 12 | 5639632 | 852 | 0 | 894 | weekly | |
28607 | 28607 | United States | Minnesota | MN | 2018-03-25 | 2018-03-31 | 7 | 2018 | 13 | 5639632 | 834 | 0 | 895 | weekly | |
28608 | 28608 | United States | Minnesota | MN | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 5639632 | 843 | 0 | 884 | weekly | |
28609 | 28609 | United States | Minnesota | MN | 2018-04-08 | 2018-04-14 | 7 | 2018 | 15 | 5639632 | 895 | 0 | 875 | weekly | |
28610 | 28610 | United States | Minnesota | MN | 2018-04-15 | 2018-04-21 | 7 | 2018 | 16 | 5639632 | 843 | 0 | 873 | weekly | |
28611 | 28611 | United States | Minnesota | MN | 2018-04-22 | 2018-04-28 | 7 | 2018 | 17 | 5639632 | 819 | 0 | 862 | weekly | |
28612 | 28612 | United States | Minnesota | MN | 2018-04-29 | 2018-05-05 | 7 | 2018 | 18 | 5639632 | 859 | 0 | 858 | weekly | |
28613 | 28613 | United States | Minnesota | MN | 2018-05-06 | 2018-05-12 | 7 | 2018 | 19 | 5639632 | 834 | 0 | 847 | weekly | |
28614 | 28614 | United States | Minnesota | MN | 2018-05-13 | 2018-05-19 | 7 | 2018 | 20 | 5639632 | 785 | 0 | 843 | weekly | |
28615 | 28615 | United States | Minnesota | MN | 2018-05-20 | 2018-05-26 | 7 | 2018 | 21 | 5639632 | 823 | 0 | 833 | weekly | |
28616 | 28616 | United States | Minnesota | MN | 2018-05-27 | 2018-06-02 | 7 | 2018 | 22 | 5639632 | 734 | 0 | 830 | weekly | |
28617 | 28617 | United States | Minnesota | MN | 2018-06-03 | 2018-06-09 | 7 | 2018 | 23 | 5639632 | 778 | 0 | 821 | weekly | |
28618 | 28618 | United States | Minnesota | MN | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 5639632 | 810 | 0 | 819 | weekly | |
28619 | 28619 | United States | Minnesota | MN | 2018-06-17 | 2018-06-23 | 7 | 2018 | 25 | 5639632 | 757 | 0 | 811 | weekly | |
28620 | 28620 | United States | Minnesota | MN | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 5639632 | 798 | 0 | 808 | weekly | |
28621 | 28621 | United States | Minnesota | MN | 2018-07-01 | 2018-07-07 | 7 | 2018 | 27 | 5639632 | 806 | 0 | 800 | weekly | |
28622 | 28622 | United States | Minnesota | MN | 2018-07-08 | 2018-07-14 | 7 | 2018 | 28 | 5639632 | 827 | 0 | 798 | weekly | |
28623 | 28623 | United States | Minnesota | MN | 2018-07-15 | 2018-07-21 | 7 | 2018 | 29 | 5639632 | 768 | 0 | 798 | weekly | |
28624 | 28624 | United States | Minnesota | MN | 2018-07-22 | 2018-07-28 | 7 | 2018 | 30 | 5639632 | 843 | 0 | 802 | weekly | |
28625 | 28625 | United States | Minnesota | MN | 2018-07-29 | 2018-08-04 | 7 | 2018 | 31 | 5639632 | 854 | 0 | 795 | weekly | |
28626 | 28626 | United States | Minnesota | MN | 2018-08-05 | 2018-08-11 | 7 | 2018 | 32 | 5639632 | 865 | 0 | 805 | weekly | |
28627 | 28627 | United States | Minnesota | MN | 2018-08-12 | 2018-08-18 | 7 | 2018 | 33 | 5639632 | 763 | 0 | 808 | weekly | |
28628 | 28628 | United States | Minnesota | MN | 2018-08-19 | 2018-08-25 | 7 | 2018 | 34 | 5639632 | 836 | 0 | 815 | weekly | |
28629 | 28629 | United States | Minnesota | MN | 2018-08-26 | 2018-09-01 | 7 | 2018 | 35 | 5639632 | 815 | 0 | 820 | weekly | |
28630 | 28630 | United States | Minnesota | MN | 2018-09-02 | 2018-09-08 | 7 | 2018 | 36 | 5639632 | 802 | 0 | 826 | weekly | |
28631 | 28631 | United States | Minnesota | MN | 2018-09-09 | 2018-09-15 | 7 | 2018 | 37 | 5639632 | 864 | 0 | 832 | weekly | |
28632 | 28632 | United States | Minnesota | MN | 2018-09-16 | 2018-09-22 | 7 | 2018 | 38 | 5639632 | 796 | 0 | 839 | weekly | |
28633 | 28633 | United States | Minnesota | MN | 2018-09-23 | 2018-09-29 | 7 | 2018 | 39 | 5639632 | 837 | 0 | 849 | weekly | |
28634 | 28634 | United States | Minnesota | MN | 2018-09-30 | 2018-10-06 | 7 | 2018 | 40 | 5639632 | 871 | 0 | 851 | weekly | |
28635 | 28635 | United States | Minnesota | MN | 2018-10-07 | 2018-10-13 | 7 | 2018 | 41 | 5639632 | 875 | 0 | 857 | weekly | |
28636 | 28636 | United States | Minnesota | MN | 2018-10-14 | 2018-10-20 | 7 | 2018 | 42 | 5639632 | 884 | 0 | 859 | weekly | |
28637 | 28637 | United States | Minnesota | MN | 2018-10-21 | 2018-10-27 | 7 | 2018 | 43 | 5639632 | 882 | 0 | 870 | weekly | |
28638 | 28638 | United States | Minnesota | MN | 2018-10-28 | 2018-11-03 | 7 | 2018 | 44 | 5639632 | 870 | 0 | 880 | weekly | |
28639 | 28639 | United States | Minnesota | MN | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 5639632 | 946 | 0 | 879 | weekly | |
28640 | 28640 | United States | Minnesota | MN | 2018-11-11 | 2018-11-17 | 7 | 2018 | 46 | 5639632 | 923 | 0 | 881 | weekly | |
28641 | 28641 | United States | Minnesota | MN | 2018-11-18 | 2018-11-24 | 7 | 2018 | 47 | 5639632 | 854 | 0 | 891 | weekly | |
28642 | 28642 | United States | Minnesota | MN | 2018-11-25 | 2018-12-01 | 7 | 2018 | 48 | 5639632 | 867 | 0 | 892 | 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]);