economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
308 rows where population = 39512223
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22691 | 22691 | United States | California | CA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 39512223 | 6061 | 0 | 5169 | weekly | |
22692 | 22692 | United States | California | CA | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 39512223 | 6267 | 0 | 5205 | weekly | |
22693 | 22693 | United States | California | CA | 2017-01-15 | 2017-01-21 | 7 | 2017 | 3 | 39512223 | 5978 | 0 | 5256 | weekly | |
22694 | 22694 | United States | California | CA | 2017-01-22 | 2017-01-28 | 7 | 2017 | 4 | 39512223 | 5747 | 0 | 5286 | weekly | |
22695 | 22695 | United States | California | CA | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 39512223 | 5970 | 0 | 5283 | weekly | |
22696 | 22696 | United States | California | CA | 2017-02-05 | 2017-02-11 | 7 | 2017 | 6 | 39512223 | 5710 | 0 | 5275 | weekly | |
22697 | 22697 | United States | California | CA | 2017-02-12 | 2017-02-18 | 7 | 2017 | 7 | 39512223 | 5621 | 0 | 5249 | weekly | |
22698 | 22698 | United States | California | CA | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 39512223 | 5347 | 0 | 5205 | weekly | |
22699 | 22699 | United States | California | CA | 2017-02-26 | 2017-03-04 | 7 | 2017 | 9 | 39512223 | 5539 | 0 | 5160 | weekly | |
22700 | 22700 | United States | California | CA | 2017-03-05 | 2017-03-11 | 7 | 2017 | 10 | 39512223 | 5432 | 0 | 5085 | weekly | |
22701 | 22701 | United States | California | CA | 2017-03-12 | 2017-03-18 | 7 | 2017 | 11 | 39512223 | 5386 | 0 | 5040 | weekly | |
22702 | 22702 | United States | California | CA | 2017-03-19 | 2017-03-25 | 7 | 2017 | 12 | 39512223 | 5156 | 0 | 5016 | weekly | |
22703 | 22703 | United States | California | CA | 2017-03-26 | 2017-04-01 | 7 | 2017 | 13 | 39512223 | 5166 | 0 | 4970 | weekly | |
22704 | 22704 | United States | California | CA | 2017-04-02 | 2017-04-08 | 7 | 2017 | 14 | 39512223 | 5194 | 0 | 4947 | weekly | |
22705 | 22705 | United States | California | CA | 2017-04-09 | 2017-04-15 | 7 | 2017 | 15 | 39512223 | 5121 | 0 | 4897 | weekly | |
22706 | 22706 | United States | California | CA | 2017-04-16 | 2017-04-22 | 7 | 2017 | 16 | 39512223 | 5072 | 0 | 4854 | weekly | |
22707 | 22707 | United States | California | CA | 2017-04-23 | 2017-04-29 | 7 | 2017 | 17 | 39512223 | 5269 | 0 | 4832 | weekly | |
22708 | 22708 | United States | California | CA | 2017-04-30 | 2017-05-06 | 7 | 2017 | 18 | 39512223 | 5226 | 0 | 4814 | weekly | |
22709 | 22709 | United States | California | CA | 2017-05-07 | 2017-05-13 | 7 | 2017 | 19 | 39512223 | 4892 | 0 | 4780 | weekly | |
22710 | 22710 | United States | California | CA | 2017-05-14 | 2017-05-20 | 7 | 2017 | 20 | 39512223 | 5059 | 0 | 4751 | weekly | |
22711 | 22711 | United States | California | CA | 2017-05-21 | 2017-05-27 | 7 | 2017 | 21 | 39512223 | 4846 | 0 | 4735 | weekly | |
22712 | 22712 | United States | California | CA | 2017-05-28 | 2017-06-03 | 7 | 2017 | 22 | 39512223 | 4890 | 0 | 4703 | weekly | |
22713 | 22713 | United States | California | CA | 2017-06-04 | 2017-06-10 | 7 | 2017 | 23 | 39512223 | 4849 | 0 | 4678 | weekly | |
22714 | 22714 | United States | California | CA | 2017-06-11 | 2017-06-17 | 7 | 2017 | 24 | 39512223 | 4913 | 0 | 4666 | weekly | |
22715 | 22715 | United States | California | CA | 2017-06-18 | 2017-06-24 | 7 | 2017 | 25 | 39512223 | 5147 | 0 | 4641 | weekly | |
22716 | 22716 | United States | California | CA | 2017-06-25 | 2017-07-01 | 7 | 2017 | 26 | 39512223 | 4849 | 0 | 4626 | weekly | |
22717 | 22717 | United States | California | CA | 2017-07-02 | 2017-07-08 | 7 | 2017 | 27 | 39512223 | 4913 | 0 | 4623 | weekly | |
22718 | 22718 | United States | California | CA | 2017-07-09 | 2017-07-15 | 7 | 2017 | 28 | 39512223 | 4746 | 0 | 4623 | weekly | |
22719 | 22719 | United States | California | CA | 2017-07-16 | 2017-07-22 | 7 | 2017 | 29 | 39512223 | 4781 | 0 | 4611 | weekly | |
22720 | 22720 | United States | California | CA | 2017-07-23 | 2017-07-29 | 7 | 2017 | 30 | 39512223 | 4636 | 0 | 4640 | weekly | |
22721 | 22721 | United States | California | CA | 2017-07-30 | 2017-08-05 | 7 | 2017 | 31 | 39512223 | 4828 | 0 | 4637 | weekly | |
22722 | 22722 | United States | California | CA | 2017-08-06 | 2017-08-12 | 7 | 2017 | 32 | 39512223 | 4683 | 0 | 4645 | weekly | |
22723 | 22723 | United States | California | CA | 2017-08-13 | 2017-08-19 | 7 | 2017 | 33 | 39512223 | 4611 | 0 | 4628 | weekly | |
22724 | 22724 | United States | California | CA | 2017-08-20 | 2017-08-26 | 7 | 2017 | 34 | 39512223 | 4512 | 0 | 4635 | weekly | |
22725 | 22725 | United States | California | CA | 2017-08-27 | 2017-09-02 | 7 | 2017 | 35 | 39512223 | 5017 | 0 | 4691 | weekly | |
22726 | 22726 | United States | California | CA | 2017-09-03 | 2017-09-09 | 7 | 2017 | 36 | 39512223 | 4998 | 0 | 4689 | weekly | |
22727 | 22727 | United States | California | CA | 2017-09-10 | 2017-09-16 | 7 | 2017 | 37 | 39512223 | 4707 | 0 | 4699 | weekly | |
22728 | 22728 | United States | California | CA | 2017-09-17 | 2017-09-23 | 7 | 2017 | 38 | 39512223 | 4763 | 0 | 4703 | weekly | |
22729 | 22729 | United States | California | CA | 2017-09-24 | 2017-09-30 | 7 | 2017 | 39 | 39512223 | 5002 | 0 | 4751 | weekly | |
22730 | 22730 | United States | California | CA | 2017-10-01 | 2017-10-07 | 7 | 2017 | 40 | 39512223 | 4814 | 0 | 4785 | weekly | |
22731 | 22731 | United States | California | CA | 2017-10-08 | 2017-10-14 | 7 | 2017 | 41 | 39512223 | 4936 | 0 | 4804 | weekly | |
22732 | 22732 | United States | California | CA | 2017-10-15 | 2017-10-21 | 7 | 2017 | 42 | 39512223 | 4992 | 0 | 4838 | weekly | |
22733 | 22733 | United States | California | CA | 2017-10-22 | 2017-10-28 | 7 | 2017 | 43 | 39512223 | 4963 | 0 | 4851 | weekly | |
22734 | 22734 | United States | California | CA | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 39512223 | 4926 | 0 | 4925 | weekly | |
22735 | 22735 | United States | California | CA | 2017-11-05 | 2017-11-11 | 7 | 2017 | 45 | 39512223 | 4900 | 0 | 4985 | weekly | |
22736 | 22736 | United States | California | CA | 2017-11-12 | 2017-11-18 | 7 | 2017 | 46 | 39512223 | 4840 | 0 | 5069 | weekly | |
22737 | 22737 | United States | California | CA | 2017-11-19 | 2017-11-25 | 7 | 2017 | 47 | 39512223 | 5059 | 0 | 5120 | weekly | |
22738 | 22738 | United States | California | CA | 2017-11-26 | 2017-12-02 | 7 | 2017 | 48 | 39512223 | 4957 | 0 | 5145 | weekly | |
22739 | 22739 | United States | California | CA | 2017-12-03 | 2017-12-09 | 7 | 2017 | 49 | 39512223 | 5289 | 0 | 5201 | weekly | |
22740 | 22740 | United States | California | CA | 2017-12-10 | 2017-12-16 | 7 | 2017 | 50 | 39512223 | 5469 | 0 | 5294 | weekly | |
22741 | 22741 | United States | California | CA | 2017-12-17 | 2017-12-23 | 7 | 2017 | 51 | 39512223 | 5792 | 0 | 5368 | weekly | |
22742 | 22742 | United States | California | CA | 2017-12-24 | 2017-12-30 | 7 | 2017 | 52 | 39512223 | 6555 | 0 | 5505 | weekly | |
22743 | 22743 | United States | California | CA | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 39512223 | 7042 | 0 | 5553 | weekly | |
22744 | 22744 | United States | California | CA | 2018-01-07 | 2018-01-13 | 7 | 2018 | 2 | 39512223 | 6862 | 0 | 5601 | weekly | |
22745 | 22745 | United States | California | CA | 2018-01-14 | 2018-01-20 | 7 | 2018 | 3 | 39512223 | 6342 | 0 | 5619 | weekly | |
22746 | 22746 | United States | California | CA | 2018-01-21 | 2018-01-27 | 7 | 2018 | 4 | 39512223 | 5845 | 0 | 5649 | weekly | |
22747 | 22747 | United States | California | CA | 2018-01-28 | 2018-02-03 | 7 | 2018 | 5 | 39512223 | 5981 | 0 | 5659 | weekly | |
22748 | 22748 | United States | California | CA | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 39512223 | 5567 | 0 | 5666 | weekly | |
22749 | 22749 | United States | California | CA | 2018-02-11 | 2018-02-17 | 7 | 2018 | 7 | 39512223 | 5627 | 0 | 5648 | weekly | |
22750 | 22750 | United States | California | CA | 2018-02-18 | 2018-02-24 | 7 | 2018 | 8 | 39512223 | 5692 | 0 | 5594 | weekly | |
22751 | 22751 | United States | California | CA | 2018-02-25 | 2018-03-03 | 7 | 2018 | 9 | 39512223 | 5731 | 0 | 5498 | weekly | |
22752 | 22752 | United States | California | CA | 2018-03-04 | 2018-03-10 | 7 | 2018 | 10 | 39512223 | 5923 | 0 | 5456 | weekly | |
22753 | 22753 | United States | California | CA | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 39512223 | 5686 | 0 | 5354 | weekly | |
22754 | 22754 | United States | California | CA | 2018-03-18 | 2018-03-24 | 7 | 2018 | 12 | 39512223 | 5486 | 0 | 5329 | weekly | |
22755 | 22755 | United States | California | CA | 2018-03-25 | 2018-03-31 | 7 | 2018 | 13 | 39512223 | 5372 | 0 | 5241 | weekly | |
22756 | 22756 | United States | California | CA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 39512223 | 5279 | 0 | 5200 | weekly | |
22757 | 22757 | United States | California | CA | 2018-04-08 | 2018-04-14 | 7 | 2018 | 15 | 39512223 | 5090 | 0 | 5108 | weekly | |
22758 | 22758 | United States | California | CA | 2018-04-15 | 2018-04-21 | 7 | 2018 | 16 | 39512223 | 4996 | 0 | 5072 | weekly | |
22759 | 22759 | United States | California | CA | 2018-04-22 | 2018-04-28 | 7 | 2018 | 17 | 39512223 | 5139 | 0 | 5067 | weekly | |
22760 | 22760 | United States | California | CA | 2018-04-29 | 2018-05-05 | 7 | 2018 | 18 | 39512223 | 4968 | 0 | 5014 | weekly | |
22761 | 22761 | United States | California | CA | 2018-05-06 | 2018-05-12 | 7 | 2018 | 19 | 39512223 | 4946 | 0 | 5003 | weekly | |
22762 | 22762 | United States | California | CA | 2018-05-13 | 2018-05-19 | 7 | 2018 | 20 | 39512223 | 4696 | 0 | 4977 | weekly | |
22763 | 22763 | United States | California | CA | 2018-05-20 | 2018-05-26 | 7 | 2018 | 21 | 39512223 | 4845 | 0 | 4972 | weekly | |
22764 | 22764 | United States | California | CA | 2018-05-27 | 2018-06-02 | 7 | 2018 | 22 | 39512223 | 4935 | 0 | 4969 | weekly | |
22765 | 22765 | United States | California | CA | 2018-06-03 | 2018-06-09 | 7 | 2018 | 23 | 39512223 | 5039 | 0 | 4941 | weekly | |
22766 | 22766 | United States | California | CA | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 39512223 | 4804 | 0 | 4949 | weekly | |
22767 | 22767 | United States | California | CA | 2018-06-17 | 2018-06-23 | 7 | 2018 | 25 | 39512223 | 4881 | 0 | 4900 | weekly | |
22768 | 22768 | United States | California | CA | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 39512223 | 4757 | 0 | 4913 | weekly | |
22769 | 22769 | United States | California | CA | 2018-07-01 | 2018-07-07 | 7 | 2018 | 27 | 39512223 | 4810 | 0 | 4903 | weekly | |
22770 | 22770 | United States | California | CA | 2018-07-08 | 2018-07-14 | 7 | 2018 | 28 | 39512223 | 4991 | 0 | 4908 | weekly | |
22771 | 22771 | United States | California | CA | 2018-07-15 | 2018-07-21 | 7 | 2018 | 29 | 39512223 | 4723 | 0 | 4887 | weekly | |
22772 | 22772 | United States | California | CA | 2018-07-22 | 2018-07-28 | 7 | 2018 | 30 | 39512223 | 4783 | 0 | 4888 | weekly | |
22773 | 22773 | United States | California | CA | 2018-07-29 | 2018-08-04 | 7 | 2018 | 31 | 39512223 | 4713 | 0 | 4850 | weekly | |
22774 | 22774 | United States | California | CA | 2018-08-05 | 2018-08-11 | 7 | 2018 | 32 | 39512223 | 4803 | 0 | 4852 | weekly | |
22775 | 22775 | United States | California | CA | 2018-08-12 | 2018-08-18 | 7 | 2018 | 33 | 39512223 | 4803 | 0 | 4818 | weekly | |
22776 | 22776 | United States | California | CA | 2018-08-19 | 2018-08-25 | 7 | 2018 | 34 | 39512223 | 4761 | 0 | 4830 | weekly | |
22777 | 22777 | United States | California | CA | 2018-08-26 | 2018-09-01 | 7 | 2018 | 35 | 39512223 | 4685 | 0 | 4862 | weekly | |
22778 | 22778 | United States | California | CA | 2018-09-02 | 2018-09-08 | 7 | 2018 | 36 | 39512223 | 4635 | 0 | 4867 | weekly | |
22779 | 22779 | United States | California | CA | 2018-09-09 | 2018-09-15 | 7 | 2018 | 37 | 39512223 | 4674 | 0 | 4891 | weekly | |
22780 | 22780 | United States | California | CA | 2018-09-16 | 2018-09-22 | 7 | 2018 | 38 | 39512223 | 4848 | 0 | 4874 | weekly | |
22781 | 22781 | United States | California | CA | 2018-09-23 | 2018-09-29 | 7 | 2018 | 39 | 39512223 | 4807 | 0 | 4951 | weekly | |
22782 | 22782 | United States | California | CA | 2018-09-30 | 2018-10-06 | 7 | 2018 | 40 | 39512223 | 4771 | 0 | 4974 | weekly | |
22783 | 22783 | United States | California | CA | 2018-10-07 | 2018-10-13 | 7 | 2018 | 41 | 39512223 | 4731 | 0 | 5016 | weekly | |
22784 | 22784 | United States | California | CA | 2018-10-14 | 2018-10-20 | 7 | 2018 | 42 | 39512223 | 4846 | 0 | 5045 | weekly | |
22785 | 22785 | United States | California | CA | 2018-10-21 | 2018-10-27 | 7 | 2018 | 43 | 39512223 | 4882 | 0 | 5091 | weekly | |
22786 | 22786 | United States | California | CA | 2018-10-28 | 2018-11-03 | 7 | 2018 | 44 | 39512223 | 4923 | 0 | 5172 | weekly | |
22787 | 22787 | United States | California | CA | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 39512223 | 5057 | 0 | 5177 | weekly | |
22788 | 22788 | United States | California | CA | 2018-11-11 | 2018-11-17 | 7 | 2018 | 46 | 39512223 | 5049 | 0 | 5243 | weekly | |
22789 | 22789 | United States | California | CA | 2018-11-18 | 2018-11-24 | 7 | 2018 | 47 | 39512223 | 5278 | 0 | 5351 | weekly | |
22790 | 22790 | United States | California | CA | 2018-11-25 | 2018-12-01 | 7 | 2018 | 48 | 39512223 | 5083 | 0 | 5364 | 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]);