economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
97 rows where country = "United States" and covid_deaths = 9
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, year, start_date (date), end_date (date)
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21765 | 21765 | United States | Alabama | AL | 2022-11-13 | 2022-11-19 | 7 | 2022 | 46 | 4903185 | 1119 | 9 | 1049 | weekly | |
21990 | 21990 | United States | Alaska | AK | 2021-04-11 | 2021-04-17 | 7 | 2021 | 15 | 731545 | 95 | 9 | 84 | weekly | |
22011 | 22011 | United States | Alaska | AK | 2021-09-05 | 2021-09-11 | 7 | 2021 | 36 | 731545 | 131 | 9 | 87 | weekly | |
23494 | 23494 | United States | Connecticut | CT | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 3565287 | 593 | 9 | 583 | weekly | |
23501 | 23501 | United States | Connecticut | CT | 2020-09-20 | 2020-09-26 | 7 | 2020 | 39 | 3565287 | 644 | 9 | 589 | weekly | |
23539 | 23539 | United States | Connecticut | CT | 2021-06-13 | 2021-06-19 | 7 | 2021 | 24 | 3565287 | 575 | 9 | 606 | weekly | |
23784 | 23784 | United States | Delaware | DE | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 973764 | 214 | 9 | 193 | weekly | |
23888 | 23888 | United States | Delaware | DE | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 973764 | 209 | 9 | 187 | weekly | |
23898 | 23898 | United States | Delaware | DE | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 973764 | 191 | 9 | 176 | weekly | |
23922 | 23922 | United States | Delaware | DE | 2022-11-20 | 2022-11-26 | 7 | 2022 | 47 | 973764 | 242 | 9 | 186 | weekly | |
24105 | 24105 | United States | District of Columbia | DC | 2020-06-28 | 2020-07-04 | 7 | 2020 | 27 | 705749 | 122 | 9 | 126 | weekly | |
24142 | 24142 | United States | District of Columbia | DC | 2021-03-14 | 2021-03-20 | 7 | 2021 | 11 | 705749 | 145 | 9 | 144 | weekly | |
24188 | 24188 | United States | District of Columbia | DC | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 705749 | 153 | 9 | 120 | weekly | |
24222 | 24222 | United States | District of Columbia | DC | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 705749 | 123 | 9 | 105 | weekly | |
25035 | 25035 | United States | Hawaii | HI | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 1415872 | 223 | 9 | 227 | weekly | |
25049 | 25049 | United States | Hawaii | HI | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 1415872 | 224 | 9 | 230 | weekly | |
25050 | 25050 | United States | Hawaii | HI | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 1415872 | 216 | 9 | 236 | weekly | |
25061 | 25061 | United States | Hawaii | HI | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 1415872 | 265 | 9 | 254 | weekly | |
25063 | 25063 | United States | Hawaii | HI | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 1415872 | 262 | 9 | 252 | weekly | |
25067 | 25067 | United States | Hawaii | HI | 2021-03-21 | 2021-03-27 | 7 | 2021 | 12 | 1415872 | 241 | 9 | 245 | weekly | |
25131 | 25131 | United States | Hawaii | HI | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1415872 | 243 | 9 | 236 | weekly | |
25151 | 25151 | United States | Hawaii | HI | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 1415872 | 260 | 9 | 223 | weekly | |
25428 | 25428 | United States | Idaho | ID | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 1787065 | 288 | 9 | 305 | weekly | |
25431 | 25431 | United States | Idaho | ID | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 1787065 | 314 | 9 | 300 | weekly | |
25438 | 25438 | United States | Idaho | ID | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 1787065 | 357 | 9 | 282 | weekly | |
25459 | 25459 | United States | Idaho | ID | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 1787065 | 332 | 9 | 286 | weekly | |
25461 | 25461 | United States | Idaho | ID | 2022-11-13 | 2022-11-19 | 7 | 2022 | 46 | 1787065 | 337 | 9 | 286 | weekly | |
25938 | 25938 | United States | Indiana | IN | 2020-03-15 | 2020-03-21 | 7 | 2020 | 12 | 6732219 | 1329 | 9 | 1421 | weekly | |
26315 | 26315 | United States | Iowa | IA | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 3155070 | 568 | 9 | 565 | weekly | |
26353 | 26353 | United States | Iowa | IA | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 3155070 | 596 | 9 | 605 | weekly | |
26564 | 26564 | United States | Kansas | KS | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 2913314 | 506 | 9 | 486 | weekly | |
26674 | 26674 | United States | Kansas | KS | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 2913314 | 533 | 9 | 485 | weekly | |
26676 | 26676 | United States | Kansas | KS | 2022-07-17 | 2022-07-23 | 7 | 2022 | 29 | 2913314 | 543 | 9 | 484 | weekly | |
27480 | 27480 | United States | Maine | ME | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 1344212 | 300 | 9 | 308 | weekly | |
27481 | 27481 | United States | Maine | ME | 2020-04-05 | 2020-04-11 | 7 | 2020 | 15 | 1344212 | 304 | 9 | 306 | weekly | |
27489 | 27489 | United States | Maine | ME | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 1344212 | 255 | 9 | 282 | weekly | |
27532 | 27532 | United States | Maine | ME | 2021-03-28 | 2021-04-03 | 7 | 2021 | 13 | 1344212 | 309 | 9 | 297 | weekly | |
27543 | 27543 | United States | Maine | ME | 2021-06-13 | 2021-06-19 | 7 | 2021 | 24 | 1344212 | 294 | 9 | 277 | weekly | |
27597 | 27597 | United States | Maine | ME | 2022-06-26 | 2022-07-02 | 7 | 2022 | 26 | 1344212 | 305 | 9 | 283 | weekly | |
27605 | 27605 | United States | Maine | ME | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 1344212 | 305 | 9 | 289 | weekly | |
27610 | 27610 | United States | Maine | ME | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 1344212 | 376 | 9 | 296 | weekly | |
29652 | 29652 | United States | Montana | MT | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 1068778 | 224 | 9 | 202 | weekly | |
29698 | 29698 | United States | Montana | MT | 2021-06-06 | 2021-06-12 | 7 | 2021 | 23 | 1068778 | 228 | 9 | 187 | weekly | |
29705 | 29705 | United States | Montana | MT | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 1068778 | 255 | 9 | 189 | weekly | |
29760 | 29760 | United States | Montana | MT | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 1068778 | 235 | 9 | 195 | weekly | |
29994 | 29994 | United States | Nebraska | NE | 2021-03-14 | 2021-03-20 | 7 | 2021 | 11 | 1934408 | 327 | 9 | 349 | weekly | |
30075 | 30075 | United States | Nebraska | NE | 2022-10-02 | 2022-10-08 | 7 | 2022 | 40 | 1934408 | 358 | 9 | 324 | weekly | |
30262 | 30262 | United States | Nevada | NV | 2020-06-07 | 2020-06-13 | 7 | 2020 | 24 | 3080156 | 543 | 9 | 536 | weekly | |
30573 | 30573 | United States | New Hampshire | NH | 2020-06-28 | 2020-07-04 | 7 | 2020 | 27 | 1359711 | 247 | 9 | 241 | weekly | |
30593 | 30593 | United States | New Hampshire | NH | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 1359711 | 259 | 9 | 253 | weekly | |
30613 | 30613 | United States | New Hampshire | NH | 2021-04-04 | 2021-04-10 | 7 | 2021 | 14 | 1359711 | 230 | 9 | 264 | weekly | |
30638 | 30638 | United States | New Hampshire | NH | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 1359711 | 236 | 9 | 267 | weekly | |
30642 | 30642 | United States | New Hampshire | NH | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 1359711 | 296 | 9 | 265 | weekly | |
30673 | 30673 | United States | New Hampshire | NH | 2022-05-29 | 2022-06-04 | 7 | 2022 | 22 | 1359711 | 261 | 9 | 235 | weekly | |
30680 | 30680 | United States | New Hampshire | NH | 2022-07-17 | 2022-07-23 | 7 | 2022 | 29 | 1359711 | 279 | 9 | 229 | weekly | |
30681 | 30681 | United States | New Hampshire | NH | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 1359711 | 246 | 9 | 230 | weekly | |
30687 | 30687 | United States | New Hampshire | NH | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 1359711 | 242 | 9 | 237 | weekly | |
31176 | 31176 | United States | New Mexico | NM | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 2096829 | 399 | 9 | 385 | weekly | |
31177 | 31177 | United States | New Mexico | NM | 2020-04-05 | 2020-04-11 | 7 | 2020 | 15 | 2096829 | 411 | 9 | 381 | weekly | |
31241 | 31241 | United States | New Mexico | NM | 2021-06-27 | 2021-07-03 | 7 | 2021 | 26 | 2096829 | 411 | 9 | 351 | weekly | |
31905 | 31905 | United States | North Carolina | NC | 2022-05-29 | 2022-06-04 | 7 | 2022 | 22 | 10488084 | 1997 | 9 | 1875 | weekly | |
32116 | 32116 | United States | North Dakota | ND | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 762062 | 132 | 9 | 133 | weekly | |
32118 | 32118 | United States | North Dakota | ND | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 762062 | 154 | 9 | 133 | weekly | |
32119 | 32119 | United States | North Dakota | ND | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 762062 | 136 | 9 | 133 | weekly | |
32149 | 32149 | United States | North Dakota | ND | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 762062 | 135 | 9 | 151 | weekly | |
32173 | 32173 | United States | North Dakota | ND | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 762062 | 139 | 9 | 139 | weekly | |
32202 | 32202 | United States | North Dakota | ND | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 762062 | 137 | 9 | 145 | weekly | |
33023 | 33023 | United States | Oregon | OR | 2020-03-22 | 2020-03-28 | 7 | 2020 | 13 | 4217737 | 768 | 9 | 763 | weekly | |
33694 | 33694 | United States | Rhode Island | RI | 2021-04-11 | 2021-04-17 | 7 | 2021 | 15 | 1059361 | 190 | 9 | 209 | weekly | |
33701 | 33701 | United States | Rhode Island | RI | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 1059361 | 188 | 9 | 198 | weekly | |
33712 | 33712 | United States | Rhode Island | RI | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 1059361 | 210 | 9 | 198 | weekly | |
33724 | 33724 | United States | Rhode Island | RI | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 1059361 | 220 | 9 | 217 | weekly | |
33726 | 33726 | United States | Rhode Island | RI | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1059361 | 248 | 9 | 220 | weekly | |
33739 | 33739 | United States | Rhode Island | RI | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 1059361 | 236 | 9 | 227 | weekly | |
33743 | 33743 | United States | Rhode Island | RI | 2022-03-20 | 2022-03-26 | 7 | 2022 | 12 | 1059361 | 190 | 9 | 221 | weekly | |
33756 | 33756 | United States | Rhode Island | RI | 2022-06-19 | 2022-06-25 | 7 | 2022 | 25 | 1059361 | 184 | 9 | 200 | weekly | |
33768 | 33768 | United States | Rhode Island | RI | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 1059361 | 204 | 9 | 201 | weekly | |
33775 | 33775 | United States | Rhode Island | RI | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 1059361 | 210 | 9 | 206 | weekly | |
34316 | 34316 | United States | South Dakota | SD | 2021-05-23 | 2021-05-29 | 7 | 2021 | 21 | 884659 | 137 | 9 | 157 | weekly | |
34377 | 34377 | United States | South Dakota | SD | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 884659 | 178 | 9 | 154 | weekly | |
34382 | 34382 | United States | South Dakota | SD | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 884659 | 145 | 9 | 157 | weekly | |
34383 | 34383 | United States | South Dakota | SD | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 884659 | 185 | 9 | 160 | weekly | |
35491 | 35491 | United States | Vermont | VT | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 623989 | 124 | 9 | 115 | weekly | |
35532 | 35532 | United States | Vermont | VT | 2021-01-31 | 2021-02-06 | 7 | 2021 | 5 | 623989 | 137 | 9 | 123 | weekly | |
35535 | 35535 | United States | Vermont | VT | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 623989 | 168 | 9 | 119 | weekly | |
35572 | 35572 | United States | Vermont | VT | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 623989 | 128 | 9 | 111 | weekly | |
35601 | 35601 | United States | Vermont | VT | 2022-05-29 | 2022-06-04 | 7 | 2022 | 22 | 623989 | 121 | 9 | 101 | weekly | |
35619 | 35619 | United States | Vermont | VT | 2022-10-02 | 2022-10-08 | 7 | 2022 | 40 | 623989 | 118 | 9 | 105 | weekly | |
35624 | 35624 | United States | Vermont | VT | 2022-11-06 | 2022-11-12 | 7 | 2022 | 45 | 623989 | 121 | 9 | 106 | weekly | |
36478 | 36478 | United States | West Virginia | WV | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 1792147 | 471 | 9 | 435 | weekly | |
36786 | 36786 | United States | Wisconsin | WI | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 5822434 | 988 | 9 | 1026 | weekly | |
37048 | 37048 | United States | Wyoming | WY | 2020-08-16 | 2020-08-22 | 7 | 2020 | 34 | 578759 | 100 | 9 | 79 | weekly | |
37075 | 37075 | United States | Wyoming | WY | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 578759 | 102 | 9 | 92 | weekly | |
37077 | 37077 | United States | Wyoming | WY | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 578759 | 104 | 9 | 92 | weekly | |
37091 | 37091 | United States | Wyoming | WY | 2021-06-13 | 2021-06-19 | 7 | 2021 | 24 | 578759 | 108 | 9 | 88 | weekly | |
37095 | 37095 | United States | Wyoming | WY | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 578759 | 108 | 9 | 89 | weekly | |
37151 | 37151 | United States | Wyoming | WY | 2022-08-07 | 2022-08-13 | 7 | 2022 | 32 | 578759 | 115 | 9 | 98 | 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]);