economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
308 rows where population = 1415872
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24847 | 24847 | United States | Hawaii | HI | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 1415872 | 217 | 0 | 226 | weekly | |
24848 | 24848 | United States | Hawaii | HI | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 1415872 | 263 | 0 | 232 | weekly | |
24849 | 24849 | United States | Hawaii | HI | 2017-01-15 | 2017-01-21 | 7 | 2017 | 3 | 1415872 | 265 | 0 | 232 | weekly | |
24850 | 24850 | United States | Hawaii | HI | 2017-01-22 | 2017-01-28 | 7 | 2017 | 4 | 1415872 | 219 | 0 | 236 | weekly | |
24851 | 24851 | United States | Hawaii | HI | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 1415872 | 222 | 0 | 240 | weekly | |
24852 | 24852 | United States | Hawaii | HI | 2017-02-05 | 2017-02-11 | 7 | 2017 | 6 | 1415872 | 215 | 0 | 240 | weekly | |
24853 | 24853 | United States | Hawaii | HI | 2017-02-12 | 2017-02-18 | 7 | 2017 | 7 | 1415872 | 231 | 0 | 243 | weekly | |
24854 | 24854 | United States | Hawaii | HI | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 1415872 | 220 | 0 | 243 | weekly | |
24855 | 24855 | United States | Hawaii | HI | 2017-02-26 | 2017-03-04 | 7 | 2017 | 9 | 1415872 | 222 | 0 | 214 | weekly | |
24856 | 24856 | United States | Hawaii | HI | 2017-03-05 | 2017-03-11 | 7 | 2017 | 10 | 1415872 | 248 | 0 | 214 | weekly | |
24857 | 24857 | United States | Hawaii | HI | 2017-03-12 | 2017-03-18 | 7 | 2017 | 11 | 1415872 | 226 | 0 | 214 | weekly | |
24858 | 24858 | United States | Hawaii | HI | 2017-03-19 | 2017-03-25 | 7 | 2017 | 12 | 1415872 | 204 | 0 | 213 | weekly | |
24859 | 24859 | United States | Hawaii | HI | 2017-03-26 | 2017-04-01 | 7 | 2017 | 13 | 1415872 | 231 | 0 | 243 | weekly | |
24860 | 24860 | United States | Hawaii | HI | 2017-04-02 | 2017-04-08 | 7 | 2017 | 14 | 1415872 | 227 | 0 | 243 | weekly | |
24861 | 24861 | United States | Hawaii | HI | 2017-04-09 | 2017-04-15 | 7 | 2017 | 15 | 1415872 | 213 | 0 | 240 | weekly | |
24862 | 24862 | United States | Hawaii | HI | 2017-04-16 | 2017-04-22 | 7 | 2017 | 16 | 1415872 | 205 | 0 | 240 | weekly | |
24863 | 24863 | United States | Hawaii | HI | 2017-04-23 | 2017-04-29 | 7 | 2017 | 17 | 1415872 | 219 | 0 | 240 | weekly | |
24864 | 24864 | United States | Hawaii | HI | 2017-04-30 | 2017-05-06 | 7 | 2017 | 18 | 1415872 | 222 | 0 | 237 | weekly | |
24865 | 24865 | United States | Hawaii | HI | 2017-05-07 | 2017-05-13 | 7 | 2017 | 19 | 1415872 | 208 | 0 | 237 | weekly | |
24866 | 24866 | United States | Hawaii | HI | 2017-05-14 | 2017-05-20 | 7 | 2017 | 20 | 1415872 | 240 | 0 | 233 | weekly | |
24867 | 24867 | United States | Hawaii | HI | 2017-05-21 | 2017-05-27 | 7 | 2017 | 21 | 1415872 | 215 | 0 | 231 | weekly | |
24868 | 24868 | United States | Hawaii | HI | 2017-05-28 | 2017-06-03 | 7 | 2017 | 22 | 1415872 | 213 | 0 | 229 | weekly | |
24869 | 24869 | United States | Hawaii | HI | 2017-06-04 | 2017-06-10 | 7 | 2017 | 23 | 1415872 | 226 | 0 | 225 | weekly | |
24870 | 24870 | United States | Hawaii | HI | 2017-06-11 | 2017-06-17 | 7 | 2017 | 24 | 1415872 | 221 | 0 | 226 | weekly | |
24871 | 24871 | United States | Hawaii | HI | 2017-06-18 | 2017-06-24 | 7 | 2017 | 25 | 1415872 | 223 | 0 | 224 | weekly | |
24872 | 24872 | United States | Hawaii | HI | 2017-06-25 | 2017-07-01 | 7 | 2017 | 26 | 1415872 | 208 | 0 | 226 | weekly | |
24873 | 24873 | United States | Hawaii | HI | 2017-07-02 | 2017-07-08 | 7 | 2017 | 27 | 1415872 | 205 | 0 | 223 | weekly | |
24874 | 24874 | United States | Hawaii | HI | 2017-07-09 | 2017-07-15 | 7 | 2017 | 28 | 1415872 | 218 | 0 | 222 | weekly | |
24875 | 24875 | United States | Hawaii | HI | 2017-07-16 | 2017-07-22 | 7 | 2017 | 29 | 1415872 | 204 | 0 | 221 | weekly | |
24876 | 24876 | United States | Hawaii | HI | 2017-07-23 | 2017-07-29 | 7 | 2017 | 30 | 1415872 | 217 | 0 | 221 | weekly | |
24877 | 24877 | United States | Hawaii | HI | 2017-07-30 | 2017-08-05 | 7 | 2017 | 31 | 1415872 | 190 | 0 | 224 | weekly | |
24878 | 24878 | United States | Hawaii | HI | 2017-08-06 | 2017-08-12 | 7 | 2017 | 32 | 1415872 | 222 | 0 | 224 | weekly | |
24879 | 24879 | United States | Hawaii | HI | 2017-08-13 | 2017-08-19 | 7 | 2017 | 33 | 1415872 | 218 | 0 | 225 | weekly | |
24880 | 24880 | United States | Hawaii | HI | 2017-08-20 | 2017-08-26 | 7 | 2017 | 34 | 1415872 | 217 | 0 | 226 | weekly | |
24881 | 24881 | United States | Hawaii | HI | 2017-08-27 | 2017-09-02 | 7 | 2017 | 35 | 1415872 | 206 | 0 | 226 | weekly | |
24882 | 24882 | United States | Hawaii | HI | 2017-09-03 | 2017-09-09 | 7 | 2017 | 36 | 1415872 | 195 | 0 | 225 | weekly | |
24883 | 24883 | United States | Hawaii | HI | 2017-09-10 | 2017-09-16 | 7 | 2017 | 37 | 1415872 | 241 | 0 | 225 | weekly | |
24884 | 24884 | United States | Hawaii | HI | 2017-09-17 | 2017-09-23 | 7 | 2017 | 38 | 1415872 | 208 | 0 | 223 | weekly | |
24885 | 24885 | United States | Hawaii | HI | 2017-09-24 | 2017-09-30 | 7 | 2017 | 39 | 1415872 | 204 | 0 | 220 | weekly | |
24886 | 24886 | United States | Hawaii | HI | 2017-10-01 | 2017-10-07 | 7 | 2017 | 40 | 1415872 | 209 | 0 | 219 | weekly | |
24887 | 24887 | United States | Hawaii | HI | 2017-10-08 | 2017-10-14 | 7 | 2017 | 41 | 1415872 | 193 | 0 | 218 | weekly | |
24888 | 24888 | United States | Hawaii | HI | 2017-10-15 | 2017-10-21 | 7 | 2017 | 42 | 1415872 | 199 | 0 | 220 | weekly | |
24889 | 24889 | United States | Hawaii | HI | 2017-10-22 | 2017-10-28 | 7 | 2017 | 43 | 1415872 | 188 | 0 | 215 | weekly | |
24890 | 24890 | United States | Hawaii | HI | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 1415872 | 232 | 0 | 213 | weekly | |
24891 | 24891 | United States | Hawaii | HI | 2017-11-05 | 2017-11-11 | 7 | 2017 | 45 | 1415872 | 228 | 0 | 213 | weekly | |
24892 | 24892 | United States | Hawaii | HI | 2017-11-12 | 2017-11-18 | 7 | 2017 | 46 | 1415872 | 199 | 0 | 216 | weekly | |
24893 | 24893 | United States | Hawaii | HI | 2017-11-19 | 2017-11-25 | 7 | 2017 | 47 | 1415872 | 213 | 0 | 217 | weekly | |
24894 | 24894 | United States | Hawaii | HI | 2017-11-26 | 2017-12-02 | 7 | 2017 | 48 | 1415872 | 266 | 0 | 215 | weekly | |
24895 | 24895 | United States | Hawaii | HI | 2017-12-03 | 2017-12-09 | 7 | 2017 | 49 | 1415872 | 236 | 0 | 215 | weekly | |
24896 | 24896 | United States | Hawaii | HI | 2017-12-10 | 2017-12-16 | 7 | 2017 | 50 | 1415872 | 242 | 0 | 218 | weekly | |
24897 | 24897 | United States | Hawaii | HI | 2017-12-17 | 2017-12-23 | 7 | 2017 | 51 | 1415872 | 255 | 0 | 220 | weekly | |
24898 | 24898 | United States | Hawaii | HI | 2017-12-24 | 2017-12-30 | 7 | 2017 | 52 | 1415872 | 244 | 0 | 223 | weekly | |
24899 | 24899 | United States | Hawaii | HI | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 1415872 | 268 | 0 | 228 | weekly | |
24900 | 24900 | United States | Hawaii | HI | 2018-01-07 | 2018-01-13 | 7 | 2018 | 2 | 1415872 | 249 | 0 | 239 | weekly | |
24901 | 24901 | United States | Hawaii | HI | 2018-01-14 | 2018-01-20 | 7 | 2018 | 3 | 1415872 | 235 | 0 | 239 | weekly | |
24902 | 24902 | United States | Hawaii | HI | 2018-01-21 | 2018-01-27 | 7 | 2018 | 4 | 1415872 | 225 | 0 | 242 | weekly | |
24903 | 24903 | United States | Hawaii | HI | 2018-01-28 | 2018-02-03 | 7 | 2018 | 5 | 1415872 | 256 | 0 | 246 | weekly | |
24904 | 24904 | United States | Hawaii | HI | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 1415872 | 207 | 0 | 246 | weekly | |
24905 | 24905 | United States | Hawaii | HI | 2018-02-11 | 2018-02-17 | 7 | 2018 | 7 | 1415872 | 237 | 0 | 247 | weekly | |
24906 | 24906 | United States | Hawaii | HI | 2018-02-18 | 2018-02-24 | 7 | 2018 | 8 | 1415872 | 239 | 0 | 248 | weekly | |
24907 | 24907 | United States | Hawaii | HI | 2018-02-25 | 2018-03-03 | 7 | 2018 | 9 | 1415872 | 224 | 0 | 246 | weekly | |
24908 | 24908 | United States | Hawaii | HI | 2018-03-04 | 2018-03-10 | 7 | 2018 | 10 | 1415872 | 246 | 0 | 244 | weekly | |
24909 | 24909 | United States | Hawaii | HI | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 1415872 | 260 | 0 | 245 | weekly | |
24910 | 24910 | United States | Hawaii | HI | 2018-03-18 | 2018-03-24 | 7 | 2018 | 12 | 1415872 | 215 | 0 | 242 | weekly | |
24911 | 24911 | United States | Hawaii | HI | 2018-03-25 | 2018-03-31 | 7 | 2018 | 13 | 1415872 | 261 | 0 | 238 | weekly | |
24912 | 24912 | United States | Hawaii | HI | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 1415872 | 222 | 0 | 237 | weekly | |
24913 | 24913 | United States | Hawaii | HI | 2018-04-08 | 2018-04-14 | 7 | 2018 | 15 | 1415872 | 238 | 0 | 241 | weekly | |
24914 | 24914 | United States | Hawaii | HI | 2018-04-15 | 2018-04-21 | 7 | 2018 | 16 | 1415872 | 203 | 0 | 242 | weekly | |
24915 | 24915 | United States | Hawaii | HI | 2018-04-22 | 2018-04-28 | 7 | 2018 | 17 | 1415872 | 210 | 0 | 239 | weekly | |
24916 | 24916 | United States | Hawaii | HI | 2018-04-29 | 2018-05-05 | 7 | 2018 | 18 | 1415872 | 222 | 0 | 237 | weekly | |
24917 | 24917 | United States | Hawaii | HI | 2018-05-06 | 2018-05-12 | 7 | 2018 | 19 | 1415872 | 221 | 0 | 236 | weekly | |
24918 | 24918 | United States | Hawaii | HI | 2018-05-13 | 2018-05-19 | 7 | 2018 | 20 | 1415872 | 205 | 0 | 235 | weekly | |
24919 | 24919 | United States | Hawaii | HI | 2018-05-20 | 2018-05-26 | 7 | 2018 | 21 | 1415872 | 207 | 0 | 233 | weekly | |
24920 | 24920 | United States | Hawaii | HI | 2018-05-27 | 2018-06-02 | 7 | 2018 | 22 | 1415872 | 199 | 0 | 233 | weekly | |
24921 | 24921 | United States | Hawaii | HI | 2018-06-03 | 2018-06-09 | 7 | 2018 | 23 | 1415872 | 197 | 0 | 232 | weekly | |
24922 | 24922 | United States | Hawaii | HI | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 1415872 | 252 | 0 | 233 | weekly | |
24923 | 24923 | United States | Hawaii | HI | 2018-06-17 | 2018-06-23 | 7 | 2018 | 25 | 1415872 | 238 | 0 | 232 | weekly | |
24924 | 24924 | United States | Hawaii | HI | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 1415872 | 213 | 0 | 231 | weekly | |
24925 | 24925 | United States | Hawaii | HI | 2018-07-01 | 2018-07-07 | 7 | 2018 | 27 | 1415872 | 213 | 0 | 231 | weekly | |
24926 | 24926 | United States | Hawaii | HI | 2018-07-08 | 2018-07-14 | 7 | 2018 | 28 | 1415872 | 222 | 0 | 228 | weekly | |
24927 | 24927 | United States | Hawaii | HI | 2018-07-15 | 2018-07-21 | 7 | 2018 | 29 | 1415872 | 210 | 0 | 227 | weekly | |
24928 | 24928 | United States | Hawaii | HI | 2018-07-22 | 2018-07-28 | 7 | 2018 | 30 | 1415872 | 212 | 0 | 228 | weekly | |
24929 | 24929 | United States | Hawaii | HI | 2018-07-29 | 2018-08-04 | 7 | 2018 | 31 | 1415872 | 195 | 0 | 227 | weekly | |
24930 | 24930 | United States | Hawaii | HI | 2018-08-05 | 2018-08-11 | 7 | 2018 | 32 | 1415872 | 201 | 0 | 227 | weekly | |
24931 | 24931 | United States | Hawaii | HI | 2018-08-12 | 2018-08-18 | 7 | 2018 | 33 | 1415872 | 194 | 0 | 227 | weekly | |
24932 | 24932 | United States | Hawaii | HI | 2018-08-19 | 2018-08-25 | 7 | 2018 | 34 | 1415872 | 198 | 0 | 225 | weekly | |
24933 | 24933 | United States | Hawaii | HI | 2018-08-26 | 2018-09-01 | 7 | 2018 | 35 | 1415872 | 238 | 0 | 224 | weekly | |
24934 | 24934 | United States | Hawaii | HI | 2018-09-02 | 2018-09-08 | 7 | 2018 | 36 | 1415872 | 219 | 0 | 225 | weekly | |
24935 | 24935 | United States | Hawaii | HI | 2018-09-09 | 2018-09-15 | 7 | 2018 | 37 | 1415872 | 233 | 0 | 224 | weekly | |
24936 | 24936 | United States | Hawaii | HI | 2018-09-16 | 2018-09-22 | 7 | 2018 | 38 | 1415872 | 194 | 0 | 223 | weekly | |
24937 | 24937 | United States | Hawaii | HI | 2018-09-23 | 2018-09-29 | 7 | 2018 | 39 | 1415872 | 221 | 0 | 222 | weekly | |
24938 | 24938 | United States | Hawaii | HI | 2018-09-30 | 2018-10-06 | 7 | 2018 | 40 | 1415872 | 208 | 0 | 220 | weekly | |
24939 | 24939 | United States | Hawaii | HI | 2018-10-07 | 2018-10-13 | 7 | 2018 | 41 | 1415872 | 205 | 0 | 217 | weekly | |
24940 | 24940 | United States | Hawaii | HI | 2018-10-14 | 2018-10-20 | 7 | 2018 | 42 | 1415872 | 220 | 0 | 218 | weekly | |
24941 | 24941 | United States | Hawaii | HI | 2018-10-21 | 2018-10-27 | 7 | 2018 | 43 | 1415872 | 195 | 0 | 215 | weekly | |
24942 | 24942 | United States | Hawaii | HI | 2018-10-28 | 2018-11-03 | 7 | 2018 | 44 | 1415872 | 196 | 0 | 214 | weekly | |
24943 | 24943 | United States | Hawaii | HI | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 1415872 | 222 | 0 | 213 | weekly | |
24944 | 24944 | United States | Hawaii | HI | 2018-11-11 | 2018-11-17 | 7 | 2018 | 46 | 1415872 | 237 | 0 | 212 | weekly | |
24945 | 24945 | United States | Hawaii | HI | 2018-11-18 | 2018-11-24 | 7 | 2018 | 47 | 1415872 | 226 | 0 | 212 | weekly | |
24946 | 24946 | United States | Hawaii | HI | 2018-11-25 | 2018-12-01 | 7 | 2018 | 48 | 1415872 | 204 | 0 | 212 | 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]);