economist_historical_deaths

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette

14,708 rows where country = "United States"

View and edit SQL

Suggested facets: year, start_date (date), end_date (date)

country

  • United States · 14,708

cadence

Link rowid ▼ country region region_code start_date end_date year week population total_deaths covid_deaths expected_deaths cadence month
19913 United States Alabama AL 2015-01-04 2015-01-10 2015 1 4903185 1169 0 TBC weekly  
19914 United States Alabama AL 2015-01-11 2015-01-17 2015 2 4903185 1172 0 TBC weekly  
19915 United States Alabama AL 2015-01-18 2015-01-24 2015 3 4903185 1072 0 TBC weekly  
19916 United States Alabama AL 2015-01-25 2015-01-31 2015 4 4903185 1087 0 TBC weekly  
19917 United States Alabama AL 2015-02-01 2015-02-07 2015 5 4903185 1130 0 TBC weekly  
19918 United States Alabama AL 2015-02-08 2015-02-14 2015 6 4903185 1102 0 TBC weekly  
19919 United States Alabama AL 2015-02-15 2015-02-21 2015 7 4903185 1088 0 TBC weekly  
19920 United States Alabama AL 2015-02-22 2015-02-28 2015 8 4903185 1125 0 TBC weekly  
19921 United States Alabama AL 2015-03-01 2015-03-07 2015 9 4903185 1224 0 TBC weekly  
19922 United States Alabama AL 2015-03-08 2015-03-14 2015 10 4903185 1135 0 TBC weekly  
19923 United States Alabama AL 2015-03-15 2015-03-21 2015 11 4903185 1047 0 TBC weekly  
19924 United States Alabama AL 2015-03-22 2015-03-28 2015 12 4903185 983 0 TBC weekly  
19925 United States Alabama AL 2015-03-29 2015-04-04 2015 13 4903185 971 0 TBC weekly  
19926 United States Alabama AL 2015-04-05 2015-04-11 2015 14 4903185 1006 0 TBC weekly  
19927 United States Alabama AL 2015-04-12 2015-04-18 2015 15 4903185 924 0 TBC weekly  
19928 United States Alabama AL 2015-04-19 2015-04-25 2015 16 4903185 1012 0 TBC weekly  
19929 United States Alabama AL 2015-04-26 2015-05-02 2015 17 4903185 984 0 TBC weekly  
19930 United States Alabama AL 2015-05-03 2015-05-09 2015 18 4903185 916 0 TBC weekly  
19931 United States Alabama AL 2015-05-10 2015-05-16 2015 19 4903185 907 0 TBC weekly  
19932 United States Alabama AL 2015-05-17 2015-05-23 2015 20 4903185 898 0 TBC weekly  
19933 United States Alabama AL 2015-05-24 2015-05-30 2015 21 4903185 837 0 TBC weekly  
19934 United States Alabama AL 2015-05-31 2015-06-06 2015 22 4903185 769 0 TBC weekly  
19935 United States Alabama AL 2015-06-07 2015-06-13 2015 23 4903185 900 0 TBC weekly  
19936 United States Alabama AL 2015-06-14 2015-06-20 2015 24 4903185 931 0 TBC weekly  
19937 United States Alabama AL 2015-06-21 2015-06-27 2015 25 4903185 935 0 TBC weekly  
19938 United States Alabama AL 2015-06-28 2015-07-04 2015 26 4903185 940 0 TBC weekly  
19939 United States Alabama AL 2015-07-05 2015-07-11 2015 27 4903185 941 0 TBC weekly  
19940 United States Alabama AL 2015-07-12 2015-07-18 2015 28 4903185 935 0 TBC weekly  
19941 United States Alabama AL 2015-07-19 2015-07-25 2015 29 4903185 939 0 TBC weekly  
19942 United States Alabama AL 2015-07-26 2015-08-01 2015 30 4903185 911 0 TBC weekly  
19943 United States Alabama AL 2015-08-02 2015-08-08 2015 31 4903185 922 0 TBC weekly  
19944 United States Alabama AL 2015-08-09 2015-08-15 2015 32 4903185 980 0 TBC weekly  
19945 United States Alabama AL 2015-08-16 2015-08-22 2015 33 4903185 880 0 TBC weekly  
19946 United States Alabama AL 2015-08-23 2015-08-29 2015 34 4903185 936 0 TBC weekly  
19947 United States Alabama AL 2015-08-30 2015-09-05 2015 35 4903185 950 0 TBC weekly  
19948 United States Alabama AL 2015-09-06 2015-09-12 2015 36 4903185 977 0 TBC weekly  
19949 United States Alabama AL 2015-09-13 2015-09-19 2015 37 4903185 927 0 TBC weekly  
19950 United States Alabama AL 2015-09-20 2015-09-26 2015 38 4903185 949 0 TBC weekly  
19951 United States Alabama AL 2015-09-27 2015-10-03 2015 39 4903185 901 0 TBC weekly  
19952 United States Alabama AL 2015-10-04 2015-10-10 2015 40 4903185 935 0 TBC weekly  
19953 United States Alabama AL 2015-10-11 2015-10-17 2015 41 4903185 811 0 TBC weekly  
19954 United States Alabama AL 2015-10-18 2015-10-24 2015 42 4903185 809 0 TBC weekly  
19955 United States Alabama AL 2015-10-25 2015-10-31 2015 43 4903185 920 0 TBC weekly  
19956 United States Alabama AL 2015-11-01 2015-11-07 2015 44 4903185 900 0 TBC weekly  
19957 United States Alabama AL 2015-11-08 2015-11-14 2015 45 4903185 959 0 TBC weekly  
19958 United States Alabama AL 2015-11-15 2015-11-21 2015 46 4903185 1023 0 TBC weekly  
19959 United States Alabama AL 2015-11-22 2015-11-28 2015 47 4903185 1002 0 TBC weekly  
19960 United States Alabama AL 2015-11-29 2015-12-05 2015 48 4903185 923 0 TBC weekly  
19961 United States Alabama AL 2015-12-06 2015-12-12 2015 49 4903185 927 0 TBC weekly  
19962 United States Alabama AL 2015-12-13 2015-12-19 2015 50 4903185 787 0 TBC weekly  
19963 United States Alabama AL 2015-12-20 2015-12-26 2015 51 4903185 799 0 TBC weekly  
19964 United States Alabama AL 2015-12-27 2016-01-02 2015 52 4903185 928 0 TBC weekly  
19965 United States Alabama AL 2016-01-03 2016-01-09 2016 1 4903185 1027 0 TBC weekly  
19966 United States Alabama AL 2016-01-10 2016-01-16 2016 2 4903185 1060 0 TBC weekly  
19967 United States Alabama AL 2016-01-17 2016-01-23 2016 3 4903185 1052 0 TBC weekly  
19968 United States Alabama AL 2016-01-24 2016-01-30 2016 4 4903185 1043 0 TBC weekly  
19969 United States Alabama AL 2016-01-31 2016-02-06 2016 5 4903185 1121 0 TBC weekly  
19970 United States Alabama AL 2016-02-07 2016-02-13 2016 6 4903185 1098 0 TBC weekly  
19971 United States Alabama AL 2016-02-14 2016-02-20 2016 7 4903185 1135 0 TBC weekly  
19972 United States Alabama AL 2016-02-21 2016-02-27 2016 8 4903185 980 0 TBC weekly  
19973 United States Alabama AL 2016-02-28 2016-03-05 2016 9 4903185 1024 0 TBC weekly  
19974 United States Alabama AL 2016-03-06 2016-03-12 2016 10 4903185 1063 0 TBC weekly  
19975 United States Alabama AL 2016-03-13 2016-03-19 2016 11 4903185 1029 0 TBC weekly  
19976 United States Alabama AL 2016-03-20 2016-03-26 2016 12 4903185 1017 0 TBC weekly  
19977 United States Alabama AL 2016-03-27 2016-04-02 2016 13 4903185 984 0 TBC weekly  
19978 United States Alabama AL 2016-04-03 2016-04-09 2016 14 4903185 1017 0 TBC weekly  
19979 United States Alabama AL 2016-04-10 2016-04-16 2016 15 4903185 950 0 TBC weekly  
19980 United States Alabama AL 2016-04-17 2016-04-23 2016 16 4903185 1020 0 TBC weekly  
19981 United States Alabama AL 2016-04-24 2016-04-30 2016 17 4903185 990 0 TBC weekly  
19982 United States Alabama AL 2016-05-01 2016-05-07 2016 18 4903185 986 0 TBC weekly  
19983 United States Alabama AL 2016-05-08 2016-05-14 2016 19 4903185 970 0 TBC weekly  
19984 United States Alabama AL 2016-05-15 2016-05-21 2016 20 4903185 951 0 TBC weekly  
19985 United States Alabama AL 2016-05-22 2016-05-28 2016 21 4903185 950 0 TBC weekly  
19986 United States Alabama AL 2016-05-29 2016-06-04 2016 22 4903185 976 0 TBC weekly  
19987 United States Alabama AL 2016-06-05 2016-06-11 2016 23 4903185 991 0 TBC weekly  
19988 United States Alabama AL 2016-06-12 2016-06-18 2016 24 4903185 889 0 TBC weekly  
19989 United States Alabama AL 2016-06-19 2016-06-25 2016 25 4903185 988 0 TBC weekly  
19990 United States Alabama AL 2016-06-26 2016-07-02 2016 26 4903185 936 0 TBC weekly  
19991 United States Alabama AL 2016-07-03 2016-07-09 2016 27 4903185 924 0 TBC weekly  
19992 United States Alabama AL 2016-07-10 2016-07-16 2016 28 4903185 985 0 TBC weekly  
19993 United States Alabama AL 2016-07-17 2016-07-23 2016 29 4903185 940 0 TBC weekly  
19994 United States Alabama AL 2016-07-24 2016-07-30 2016 30 4903185 942 0 TBC weekly  
19995 United States Alabama AL 2016-07-31 2016-08-06 2016 31 4903185 924 0 TBC weekly  
19996 United States Alabama AL 2016-08-07 2016-08-13 2016 32 4903185 928 0 TBC weekly  
19997 United States Alabama AL 2016-08-14 2016-08-20 2016 33 4903185 997 0 TBC weekly  
19998 United States Alabama AL 2016-08-21 2016-08-27 2016 34 4903185 972 0 TBC weekly  
19999 United States Alabama AL 2016-08-28 2016-09-03 2016 35 4903185 932 0 TBC weekly  
20000 United States Alabama AL 2016-09-04 2016-09-10 2016 36 4903185 932 0 TBC weekly  
20001 United States Alabama AL 2016-09-11 2016-09-17 2016 37 4903185 980 0 TBC weekly  
20002 United States Alabama AL 2016-09-18 2016-09-24 2016 38 4903185 993 0 TBC weekly  
20003 United States Alabama AL 2016-09-25 2016-10-01 2016 39 4903185 956 0 TBC weekly  
20004 United States Alabama AL 2016-10-02 2016-10-08 2016 40 4903185 987 0 TBC weekly  
20005 United States Alabama AL 2016-10-09 2016-10-15 2016 41 4903185 980 0 TBC weekly  
20006 United States Alabama AL 2016-10-16 2016-10-22 2016 42 4903185 948 0 TBC weekly  
20007 United States Alabama AL 2016-10-23 2016-10-29 2016 43 4903185 996 0 TBC weekly  
20008 United States Alabama AL 2016-10-30 2016-11-05 2016 44 4903185 979 0 TBC weekly  
20009 United States Alabama AL 2016-11-06 2016-11-12 2016 45 4903185 1043 0 TBC weekly  
20010 United States Alabama AL 2016-11-13 2016-11-19 2016 46 4903185 1016 0 TBC weekly  
20011 United States Alabama AL 2016-11-20 2016-11-26 2016 47 4903185 1059 0 TBC weekly  
20012 United States Alabama AL 2016-11-27 2016-12-03 2016 48 4903185 1058 0 TBC weekly  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [economist_historical_deaths] (
   [country] TEXT,
   [region] TEXT,
   [region_code] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [year] INTEGER,
   [week] INTEGER,
   [population] INTEGER,
   [total_deaths] INTEGER,
   [covid_deaths] INTEGER,
   [expected_deaths] TEXT,
   [cadence] TEXT
, [month] INTEGER);
Powered by Datasette · Query took 459.63ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette