economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
76 rows where country = "United States" and covid_deaths = 11
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, year, population, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21969 | 21969 | United States | Alaska | AK | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 731545 | 122 | 11 | 90 | weekly | |
22662 | 22662 | United States | Arkansas | AR | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 3017825 | 677 | 11 | 615 | weekly | |
23278 | 23278 | United States | Colorado | CO | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 5758736 | 869 | 11 | 785 | weekly | |
23547 | 23547 | United States | Connecticut | CT | 2021-08-08 | 2021-08-14 | 7 | 2021 | 32 | 3565287 | 650 | 11 | 600 | weekly | |
23840 | 23840 | United States | Delaware | DE | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 973764 | 205 | 11 | 207 | weekly | |
23892 | 23892 | United States | Delaware | DE | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 973764 | 209 | 11 | 180 | weekly | |
23918 | 23918 | United States | Delaware | DE | 2022-10-23 | 2022-10-29 | 7 | 2022 | 43 | 973764 | 267 | 11 | 179 | weekly | |
24106 | 24106 | United States | District of Columbia | DC | 2020-07-05 | 2020-07-11 | 7 | 2020 | 28 | 705749 | 138 | 11 | 126 | weekly | |
24139 | 24139 | United States | District of Columbia | DC | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 705749 | 144 | 11 | 146 | weekly | |
24145 | 24145 | United States | District of Columbia | DC | 2021-04-04 | 2021-04-10 | 7 | 2021 | 14 | 705749 | 158 | 11 | 138 | weekly | |
25041 | 25041 | United States | Hawaii | HI | 2020-09-20 | 2020-09-26 | 7 | 2020 | 39 | 1415872 | 242 | 11 | 226 | weekly | |
25106 | 25106 | United States | Hawaii | HI | 2021-12-19 | 2021-12-25 | 7 | 2021 | 51 | 1415872 | 250 | 11 | 251 | weekly | |
25108 | 25108 | United States | Hawaii | HI | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 1415872 | 255 | 11 | 253 | weekly | |
25124 | 25124 | United States | Hawaii | HI | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 1415872 | 224 | 11 | 237 | weekly | |
25135 | 25135 | United States | Hawaii | HI | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 1415872 | 228 | 11 | 230 | weekly | |
25143 | 25143 | United States | Hawaii | HI | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 1415872 | 238 | 11 | 223 | weekly | |
25385 | 25385 | United States | Idaho | ID | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 1787065 | 292 | 11 | 293 | weekly | |
25450 | 25450 | United States | Idaho | ID | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 1787065 | 314 | 11 | 281 | weekly | |
25455 | 25455 | United States | Idaho | ID | 2022-10-02 | 2022-10-08 | 7 | 2022 | 40 | 1787065 | 307 | 11 | 289 | weekly | |
25456 | 25456 | United States | Idaho | ID | 2022-10-09 | 2022-10-15 | 7 | 2022 | 41 | 1787065 | 309 | 11 | 287 | weekly | |
25759 | 25759 | United States | Illinois | IL | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 12671821 | 2004 | 11 | 1929 | weekly | |
26566 | 26566 | United States | Kansas | KS | 2020-06-07 | 2020-06-13 | 7 | 2020 | 24 | 2913314 | 516 | 11 | 487 | weekly | |
26570 | 26570 | United States | Kansas | KS | 2020-07-05 | 2020-07-11 | 7 | 2020 | 28 | 2913314 | 504 | 11 | 483 | weekly | |
26681 | 26681 | United States | Kansas | KS | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 2913314 | 499 | 11 | 492 | weekly | |
26689 | 26689 | United States | Kansas | KS | 2022-10-16 | 2022-10-22 | 7 | 2022 | 42 | 2913314 | 541 | 11 | 517 | weekly | |
27512 | 27512 | United States | Maine | ME | 2020-11-08 | 2020-11-14 | 7 | 2020 | 46 | 1344212 | 323 | 11 | 290 | weekly | |
27526 | 27526 | United States | Maine | ME | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 1344212 | 289 | 11 | 302 | weekly | |
27590 | 27590 | United States | Maine | ME | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 1344212 | 313 | 11 | 288 | weekly | |
29692 | 29692 | United States | Montana | MT | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 1068778 | 222 | 11 | 190 | weekly | |
29700 | 29700 | United States | Montana | MT | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 1068778 | 214 | 11 | 187 | weekly | |
29727 | 29727 | United States | Montana | MT | 2021-12-26 | 2022-01-01 | 7 | 2021 | 52 | 1068778 | 249 | 11 | 213 | weekly | |
29728 | 29728 | United States | Montana | MT | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 1068778 | 275 | 11 | 214 | weekly | |
29738 | 29738 | United States | Montana | MT | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 1068778 | 211 | 11 | 214 | weekly | |
29750 | 29750 | United States | Montana | MT | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 1068778 | 188 | 11 | 191 | weekly | |
29768 | 29768 | United States | Montana | MT | 2022-10-09 | 2022-10-15 | 7 | 2022 | 41 | 1068778 | 211 | 11 | 198 | weekly | |
30019 | 30019 | United States | Nebraska | NE | 2021-09-05 | 2021-09-11 | 7 | 2021 | 36 | 1934408 | 388 | 11 | 347 | weekly | |
30386 | 30386 | United States | Nevada | NV | 2022-10-23 | 2022-10-29 | 7 | 2022 | 43 | 3080156 | 570 | 11 | 507 | weekly | |
30588 | 30588 | United States | New Hampshire | NH | 2020-10-11 | 2020-10-17 | 7 | 2020 | 42 | 1359711 | 253 | 11 | 249 | weekly | |
30608 | 30608 | United States | New Hampshire | NH | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 1359711 | 246 | 11 | 272 | weekly | |
30634 | 30634 | United States | New Hampshire | NH | 2021-08-29 | 2021-09-04 | 7 | 2021 | 35 | 1359711 | 234 | 11 | 268 | weekly | |
30663 | 30663 | United States | New Hampshire | NH | 2022-03-20 | 2022-03-26 | 7 | 2022 | 12 | 1359711 | 293 | 11 | 262 | weekly | |
30667 | 30667 | United States | New Hampshire | NH | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 1359711 | 245 | 11 | 247 | weekly | |
30688 | 30688 | United States | New Hampshire | NH | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 1359711 | 262 | 11 | 239 | weekly | |
31902 | 31902 | United States | North Carolina | NC | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 10488084 | 1901 | 11 | 1899 | weekly | |
31908 | 31908 | United States | North Carolina | NC | 2022-06-19 | 2022-06-25 | 7 | 2022 | 25 | 10488084 | 2114 | 11 | 1857 | weekly | |
32143 | 32143 | United States | North Dakota | ND | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 762062 | 147 | 11 | 147 | weekly | |
32177 | 32177 | United States | North Dakota | ND | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 762062 | 167 | 11 | 145 | weekly | |
32191 | 32191 | United States | North Dakota | ND | 2021-12-26 | 2022-01-01 | 7 | 2021 | 52 | 762062 | 164 | 11 | 149 | weekly | |
33037 | 33037 | United States | Oregon | OR | 2020-06-28 | 2020-07-04 | 7 | 2020 | 27 | 4217737 | 760 | 11 | 695 | weekly | |
33088 | 33088 | United States | Oregon | OR | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 4217737 | 767 | 11 | 689 | weekly | |
33090 | 33090 | United States | Oregon | OR | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 4217737 | 789 | 11 | 686 | weekly | |
33655 | 33655 | United States | Rhode Island | RI | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 1059361 | 190 | 11 | 186 | weekly | |
33662 | 33662 | United States | Rhode Island | RI | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 1059361 | 207 | 11 | 188 | weekly | |
33663 | 33663 | United States | Rhode Island | RI | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 1059361 | 190 | 11 | 187 | weekly | |
33696 | 33696 | United States | Rhode Island | RI | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 1059361 | 208 | 11 | 207 | weekly | |
33713 | 33713 | United States | Rhode Island | RI | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 1059361 | 220 | 11 | 202 | weekly | |
33717 | 33717 | United States | Rhode Island | RI | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 1059361 | 216 | 11 | 206 | weekly | |
33740 | 33740 | United States | Rhode Island | RI | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 1059361 | 224 | 11 | 224 | weekly | |
34013 | 34013 | United States | South Carolina | SC | 2021-06-27 | 2021-07-03 | 7 | 2021 | 26 | 5148714 | 1029 | 11 | 979 | weekly | |
34260 | 34260 | United States | South Dakota | SD | 2020-04-26 | 2020-05-02 | 7 | 2020 | 18 | 884659 | 159 | 11 | 163 | weekly | |
34306 | 34306 | United States | South Dakota | SD | 2021-03-14 | 2021-03-20 | 7 | 2021 | 11 | 884659 | 155 | 11 | 167 | weekly | |
34364 | 34364 | United States | South Dakota | SD | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 884659 | 177 | 11 | 156 | weekly | |
34870 | 34870 | United States | Texas | TX | 2020-03-15 | 2020-03-21 | 7 | 2020 | 12 | 28995881 | 4256 | 11 | 4231 | weekly | |
35188 | 35188 | United States | Utah | UT | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 3205958 | 390 | 11 | 383 | weekly | |
35240 | 35240 | United States | Utah | UT | 2021-05-23 | 2021-05-29 | 7 | 2021 | 21 | 3205958 | 434 | 11 | 390 | weekly | |
35316 | 35316 | United States | Utah | UT | 2022-11-06 | 2022-11-12 | 7 | 2022 | 45 | 3205958 | 407 | 11 | 399 | weekly | |
35542 | 35542 | United States | Vermont | VT | 2021-04-11 | 2021-04-17 | 7 | 2021 | 15 | 623989 | 109 | 11 | 112 | weekly | |
35564 | 35564 | United States | Vermont | VT | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 623989 | 155 | 11 | 110 | weekly | |
35573 | 35573 | United States | Vermont | VT | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 623989 | 160 | 11 | 112 | weekly | |
36421 | 36421 | United States | West Virginia | WV | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 1792147 | 409 | 11 | 416 | weekly | |
36479 | 36479 | United States | West Virginia | WV | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 1792147 | 407 | 11 | 433 | weekly | |
36483 | 36483 | United States | West Virginia | WV | 2021-08-08 | 2021-08-14 | 7 | 2021 | 32 | 1792147 | 512 | 11 | 430 | weekly | |
36531 | 36531 | United States | West Virginia | WV | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 1792147 | 464 | 11 | 420 | weekly | |
36785 | 36785 | United States | Wisconsin | WI | 2021-06-27 | 2021-07-03 | 7 | 2021 | 26 | 5822434 | 1066 | 11 | 1029 | weekly | |
36789 | 36789 | United States | Wisconsin | WI | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 5822434 | 1103 | 11 | 1025 | weekly | |
37147 | 37147 | United States | Wyoming | WY | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 578759 | 99 | 11 | 93 | 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]);