economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
16,429 rows where cadence = "weekly" and country = "United States"
This data as json, yaml, Notebook, copyable, CSV (advanced)
end_date (date) >30 ✖
- 2017-01-07 52
- 2017-01-14 52
- 2017-01-21 52
- 2017-01-28 52
- 2017-02-04 52
- 2017-02-11 52
- 2017-02-18 52
- 2017-02-25 52
- 2017-03-04 52
- 2017-03-11 52
- 2017-03-18 52
- 2017-03-25 52
- 2017-04-01 52
- 2017-04-08 52
- 2017-04-15 52
- 2017-04-22 52
- 2017-04-29 52
- 2017-05-06 52
- 2017-05-13 52
- 2017-05-20 52
- 2017-05-27 52
- 2017-06-03 52
- 2017-06-10 52
- 2017-06-17 52
- 2017-06-24 52
- 2017-07-01 52
- 2017-07-08 52
- 2017-07-15 52
- 2017-07-22 52
- 2017-07-29 52
- …
country 1
- United States · 16,329 ✖
cadence 1
- weekly · 16,329 ✖
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101 | 101 | United States | United States | 0 | 2016-12-05 | 2016-12-11 | 7 | 2016 | 49 | 338289856 | 55262 | 0 | TBC | weekly | |
102 | 102 | United States | United States | 0 | 2016-12-12 | 2016-12-18 | 7 | 2016 | 50 | 338289856 | 56128 | 0 | TBC | weekly | |
103 | 103 | United States | United States | 0 | 2016-12-19 | 2016-12-25 | 7 | 2016 | 51 | 338289856 | 56854 | 0 | TBC | weekly | |
104 | 104 | United States | United States | 0 | 2016-12-26 | 2017-01-01 | 7 | 2016 | 52 | 338289856 | 57772 | 0 | TBC | weekly | |
105 | 105 | United States | United States | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 338289856 | 59901 | 0 | TBC | weekly | |
106 | 106 | United States | United States | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 338289856 | 61118 | 0 | TBC | weekly | |
107 | 107 | United States | United States | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 338289856 | 59445 | 0 | TBC | weekly | |
108 | 108 | United States | United States | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 338289856 | 58178 | 0 | TBC | weekly | |
109 | 109 | United States | United States | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 338289856 | 58541 | 0 | TBC | weekly | |
110 | 110 | United States | United States | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 338289856 | 59164 | 0 | TBC | weekly | |
111 | 111 | United States | United States | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 338289856 | 58596 | 0 | TBC | weekly | |
112 | 112 | United States | United States | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 338289856 | 58386 | 0 | TBC | weekly | |
113 | 113 | United States | United States | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 338289856 | 57360 | 0 | TBC | weekly | |
114 | 114 | United States | United States | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 338289856 | 57598 | 0 | TBC | weekly | |
115 | 115 | United States | United States | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 338289856 | 56781 | 0 | TBC | weekly | |
116 | 116 | United States | United States | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 338289856 | 57168 | 0 | TBC | weekly | |
117 | 117 | United States | United States | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 338289856 | 55829 | 0 | TBC | weekly | |
118 | 118 | United States | United States | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 338289856 | 55269 | 0 | TBC | weekly | |
119 | 119 | United States | United States | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 338289856 | 54971 | 0 | TBC | weekly | |
120 | 120 | United States | United States | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 338289856 | 53168 | 0 | TBC | weekly | |
121 | 121 | United States | United States | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 338289856 | 53407 | 0 | TBC | weekly | |
122 | 122 | United States | United States | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 338289856 | 52753 | 0 | TBC | weekly | |
123 | 123 | United States | United States | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 338289856 | 52078 | 0 | TBC | weekly | |
124 | 124 | United States | United States | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 338289856 | 52578 | 0 | TBC | weekly | |
125 | 125 | United States | United States | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 338289856 | 51102 | 0 | TBC | weekly | |
126 | 126 | United States | United States | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 338289856 | 51369 | 0 | TBC | weekly | |
127 | 127 | United States | United States | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 338289856 | 51526 | 0 | TBC | weekly | |
128 | 128 | United States | United States | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 338289856 | 50937 | 0 | TBC | weekly | |
129 | 129 | United States | United States | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 338289856 | 51320 | 0 | TBC | weekly | |
130 | 130 | United States | United States | 0 | 2017-06-26 | 2017-07-02 | 7 | 2017 | 26 | 338289856 | 50743 | 0 | TBC | weekly | |
131 | 131 | United States | United States | 0 | 2017-07-03 | 2017-07-09 | 7 | 2017 | 27 | 338289856 | 51091 | 0 | TBC | weekly | |
132 | 132 | United States | United States | 0 | 2017-07-10 | 2017-07-16 | 7 | 2017 | 28 | 338289856 | 50127 | 0 | TBC | weekly | |
133 | 133 | United States | United States | 0 | 2017-07-17 | 2017-07-23 | 7 | 2017 | 29 | 338289856 | 50231 | 0 | TBC | weekly | |
134 | 134 | United States | United States | 0 | 2017-07-24 | 2017-07-30 | 7 | 2017 | 30 | 338289856 | 49496 | 0 | TBC | weekly | |
135 | 135 | United States | United States | 0 | 2017-07-31 | 2017-08-06 | 7 | 2017 | 31 | 338289856 | 50213 | 0 | TBC | weekly | |
136 | 136 | United States | United States | 0 | 2017-08-07 | 2017-08-13 | 7 | 2017 | 32 | 338289856 | 50365 | 0 | TBC | weekly | |
137 | 137 | United States | United States | 0 | 2017-08-14 | 2017-08-20 | 7 | 2017 | 33 | 338289856 | 50297 | 0 | TBC | weekly | |
138 | 138 | United States | United States | 0 | 2017-08-21 | 2017-08-27 | 7 | 2017 | 34 | 338289856 | 49662 | 0 | TBC | weekly | |
139 | 139 | United States | United States | 0 | 2017-08-28 | 2017-09-03 | 7 | 2017 | 35 | 338289856 | 50962 | 0 | TBC | weekly | |
140 | 140 | United States | United States | 0 | 2017-09-04 | 2017-09-10 | 7 | 2017 | 36 | 338289856 | 51114 | 0 | TBC | weekly | |
141 | 141 | United States | United States | 0 | 2017-09-11 | 2017-09-17 | 7 | 2017 | 37 | 338289856 | 51822 | 0 | TBC | weekly | |
142 | 142 | United States | United States | 0 | 2017-09-18 | 2017-09-24 | 7 | 2017 | 38 | 338289856 | 51354 | 0 | TBC | weekly | |
143 | 143 | United States | United States | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 338289856 | 51464 | 0 | TBC | weekly | |
144 | 144 | United States | United States | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 338289856 | 52243 | 0 | TBC | weekly | |
145 | 145 | United States | United States | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 338289856 | 51704 | 0 | TBC | weekly | |
146 | 146 | United States | United States | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 338289856 | 52366 | 0 | TBC | weekly | |
147 | 147 | United States | United States | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 338289856 | 52682 | 0 | TBC | weekly | |
148 | 148 | United States | United States | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 338289856 | 53838 | 0 | TBC | weekly | |
149 | 149 | United States | United States | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 338289856 | 53404 | 0 | TBC | weekly | |
150 | 150 | United States | United States | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 338289856 | 53916 | 0 | TBC | weekly | |
151 | 151 | United States | United States | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 338289856 | 54229 | 0 | TBC | weekly | |
152 | 152 | United States | United States | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 338289856 | 54904 | 0 | TBC | weekly | |
153 | 153 | United States | United States | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 338289856 | 55751 | 0 | TBC | weekly | |
154 | 154 | United States | United States | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 338289856 | 57538 | 0 | TBC | weekly | |
155 | 155 | United States | United States | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 338289856 | 59674 | 0 | TBC | weekly | |
156 | 156 | United States | United States | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 338289856 | 61255 | 0 | TBC | weekly | |
157 | 157 | United States | United States | 0 | 2018-01-01 | 2018-01-07 | 7 | 2018 | 1 | 338289856 | 66320 | 0 | TBC | weekly | |
158 | 158 | United States | United States | 0 | 2018-01-08 | 2018-01-14 | 7 | 2018 | 2 | 338289856 | 67672 | 0 | TBC | weekly | |
159 | 159 | United States | United States | 0 | 2018-01-15 | 2018-01-21 | 7 | 2018 | 3 | 338289856 | 64823 | 0 | TBC | weekly | |
160 | 160 | United States | United States | 0 | 2018-01-22 | 2018-01-28 | 7 | 2018 | 4 | 338289856 | 62927 | 0 | TBC | weekly | |
161 | 161 | United States | United States | 0 | 2018-01-29 | 2018-02-04 | 7 | 2018 | 5 | 338289856 | 61128 | 0 | TBC | weekly | |
162 | 162 | United States | United States | 0 | 2018-02-05 | 2018-02-11 | 7 | 2018 | 6 | 338289856 | 61247 | 0 | TBC | weekly | |
163 | 163 | United States | United States | 0 | 2018-02-12 | 2018-02-18 | 7 | 2018 | 7 | 338289856 | 59937 | 0 | TBC | weekly | |
164 | 164 | United States | United States | 0 | 2018-02-19 | 2018-02-25 | 7 | 2018 | 8 | 338289856 | 57943 | 0 | TBC | weekly | |
165 | 165 | United States | United States | 0 | 2018-02-26 | 2018-03-04 | 7 | 2018 | 9 | 338289856 | 56833 | 0 | TBC | weekly | |
166 | 166 | United States | United States | 0 | 2018-03-05 | 2018-03-11 | 7 | 2018 | 10 | 338289856 | 57228 | 0 | TBC | weekly | |
167 | 167 | United States | United States | 0 | 2018-03-12 | 2018-03-18 | 7 | 2018 | 11 | 338289856 | 56466 | 0 | TBC | weekly | |
168 | 168 | United States | United States | 0 | 2018-03-19 | 2018-03-25 | 7 | 2018 | 12 | 338289856 | 55920 | 0 | TBC | weekly | |
169 | 169 | United States | United States | 0 | 2018-03-26 | 2018-04-01 | 7 | 2018 | 13 | 338289856 | 55046 | 0 | TBC | weekly | |
170 | 170 | United States | United States | 0 | 2018-04-02 | 2018-04-08 | 7 | 2018 | 14 | 338289856 | 55423 | 0 | TBC | weekly | |
171 | 171 | United States | United States | 0 | 2018-04-09 | 2018-04-15 | 7 | 2018 | 15 | 338289856 | 55354 | 0 | TBC | weekly | |
172 | 172 | United States | United States | 0 | 2018-04-16 | 2018-04-22 | 7 | 2018 | 16 | 338289856 | 54155 | 0 | TBC | weekly | |
173 | 173 | United States | United States | 0 | 2018-04-23 | 2018-04-29 | 7 | 2018 | 17 | 338289856 | 53848 | 0 | TBC | weekly | |
174 | 174 | United States | United States | 0 | 2018-04-30 | 2018-05-06 | 7 | 2018 | 18 | 338289856 | 53875 | 0 | TBC | weekly | |
175 | 175 | United States | United States | 0 | 2018-05-07 | 2018-05-13 | 7 | 2018 | 19 | 338289856 | 52221 | 0 | TBC | weekly | |
176 | 176 | United States | United States | 0 | 2018-05-14 | 2018-05-20 | 7 | 2018 | 20 | 338289856 | 50741 | 0 | TBC | weekly | |
177 | 177 | United States | United States | 0 | 2018-05-21 | 2018-05-27 | 7 | 2018 | 21 | 338289856 | 51057 | 0 | TBC | weekly | |
178 | 178 | United States | United States | 0 | 2018-05-28 | 2018-06-03 | 7 | 2018 | 22 | 338289856 | 51163 | 0 | TBC | weekly | |
179 | 179 | United States | United States | 0 | 2018-06-04 | 2018-06-10 | 7 | 2018 | 23 | 338289856 | 52127 | 0 | TBC | weekly | |
180 | 180 | United States | United States | 0 | 2018-06-11 | 2018-06-17 | 7 | 2018 | 24 | 338289856 | 51515 | 0 | TBC | weekly | |
181 | 181 | United States | United States | 0 | 2018-06-18 | 2018-06-24 | 7 | 2018 | 25 | 338289856 | 51224 | 0 | TBC | weekly | |
182 | 182 | United States | United States | 0 | 2018-06-25 | 2018-07-01 | 7 | 2018 | 26 | 338289856 | 50996 | 0 | TBC | weekly | |
183 | 183 | United States | United States | 0 | 2018-07-02 | 2018-07-08 | 7 | 2018 | 27 | 338289856 | 51814 | 0 | TBC | weekly | |
184 | 184 | United States | United States | 0 | 2018-07-09 | 2018-07-15 | 7 | 2018 | 28 | 338289856 | 51340 | 0 | TBC | weekly | |
185 | 185 | United States | United States | 0 | 2018-07-16 | 2018-07-22 | 7 | 2018 | 29 | 338289856 | 50733 | 0 | TBC | weekly | |
186 | 186 | United States | United States | 0 | 2018-07-23 | 2018-07-29 | 7 | 2018 | 30 | 338289856 | 50425 | 0 | TBC | weekly | |
187 | 187 | United States | United States | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 338289856 | 50800 | 0 | TBC | weekly | |
188 | 188 | United States | United States | 0 | 2018-08-06 | 2018-08-12 | 7 | 2018 | 32 | 338289856 | 51135 | 0 | TBC | weekly | |
189 | 189 | United States | United States | 0 | 2018-08-13 | 2018-08-19 | 7 | 2018 | 33 | 338289856 | 50423 | 0 | TBC | weekly | |
190 | 190 | United States | United States | 0 | 2018-08-20 | 2018-08-26 | 7 | 2018 | 34 | 338289856 | 50582 | 0 | TBC | weekly | |
191 | 191 | United States | United States | 0 | 2018-08-27 | 2018-09-02 | 7 | 2018 | 35 | 338289856 | 50746 | 0 | TBC | weekly | |
192 | 192 | United States | United States | 0 | 2018-09-03 | 2018-09-09 | 7 | 2018 | 36 | 338289856 | 50433 | 0 | TBC | weekly | |
193 | 193 | United States | United States | 0 | 2018-09-10 | 2018-09-16 | 7 | 2018 | 37 | 338289856 | 51215 | 0 | TBC | weekly | |
194 | 194 | United States | United States | 0 | 2018-09-17 | 2018-09-23 | 7 | 2018 | 38 | 338289856 | 51714 | 0 | TBC | weekly | |
195 | 195 | United States | United States | 0 | 2018-09-24 | 2018-09-30 | 7 | 2018 | 39 | 338289856 | 51100 | 0 | TBC | weekly | |
196 | 196 | United States | United States | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 338289856 | 52489 | 0 | TBC | weekly | |
197 | 197 | United States | United States | 0 | 2018-10-08 | 2018-10-14 | 7 | 2018 | 41 | 338289856 | 51976 | 0 | TBC | weekly | |
198 | 198 | United States | United States | 0 | 2018-10-15 | 2018-10-21 | 7 | 2018 | 42 | 338289856 | 53115 | 0 | TBC | weekly | |
199 | 199 | United States | United States | 0 | 2018-10-22 | 2018-10-28 | 7 | 2018 | 43 | 338289856 | 53883 | 0 | TBC | weekly | |
200 | 200 | United States | United States | 0 | 2018-10-29 | 2018-11-04 | 7 | 2018 | 44 | 338289856 | 53771 | 0 | 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]);