economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
115 rows where country = "United States" and covid_deaths = 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21953 | 21953 | United States | Alaska | AK | 2020-07-26 | 2020-08-01 | 7 | 2020 | 31 | 731545 | 114 | 5 | 85 | weekly | |
21961 | 21961 | United States | Alaska | AK | 2020-09-20 | 2020-09-26 | 7 | 2020 | 39 | 731545 | 114 | 5 | 86 | weekly | |
21982 | 21982 | United States | Alaska | AK | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 731545 | 88 | 5 | 87 | weekly | |
21984 | 21984 | United States | Alaska | AK | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 731545 | 97 | 5 | 88 | weekly | |
21986 | 21986 | United States | Alaska | AK | 2021-03-14 | 2021-03-20 | 7 | 2021 | 11 | 731545 | 101 | 5 | 85 | weekly | |
22005 | 22005 | United States | Alaska | AK | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 731545 | 115 | 5 | 85 | weekly | |
22023 | 22023 | United States | Alaska | AK | 2021-11-28 | 2021-12-04 | 7 | 2021 | 48 | 731545 | 142 | 5 | 91 | weekly | |
22028 | 22028 | United States | Alaska | AK | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 731545 | 116 | 5 | 94 | weekly | |
22551 | 22551 | United States | Arkansas | AR | 2020-03-22 | 2020-03-28 | 7 | 2020 | 13 | 3017825 | 641 | 5 | 661 | weekly | |
22857 | 22857 | United States | California | CA | 2020-03-08 | 2020-03-14 | 7 | 2020 | 11 | 39512223 | 5465 | 5 | 5864 | weekly | |
23166 | 23166 | United States | Colorado | CO | 2020-03-15 | 2020-03-21 | 7 | 2020 | 12 | 5758736 | 891 | 5 | 834 | weekly | |
23474 | 23474 | United States | Connecticut | CT | 2020-03-15 | 2020-03-21 | 7 | 2020 | 12 | 3565287 | 665 | 5 | 659 | weekly | |
23496 | 23496 | United States | Connecticut | CT | 2020-08-16 | 2020-08-22 | 7 | 2020 | 34 | 3565287 | 571 | 5 | 580 | weekly | |
23498 | 23498 | United States | Connecticut | CT | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 3565287 | 574 | 5 | 582 | weekly | |
23540 | 23540 | United States | Connecticut | CT | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 3565287 | 595 | 5 | 609 | weekly | |
23783 | 23783 | United States | Delaware | DE | 2020-03-22 | 2020-03-28 | 7 | 2020 | 13 | 973764 | 188 | 5 | 196 | weekly | |
23802 | 23802 | United States | Delaware | DE | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 973764 | 197 | 5 | 179 | weekly | |
23807 | 23807 | United States | Delaware | DE | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 973764 | 198 | 5 | 185 | weekly | |
23897 | 23897 | United States | Delaware | DE | 2022-05-29 | 2022-06-04 | 7 | 2022 | 22 | 973764 | 190 | 5 | 176 | weekly | |
24110 | 24110 | United States | District of Columbia | DC | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 705749 | 118 | 5 | 130 | weekly | |
24115 | 24115 | United States | District of Columbia | DC | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 705749 | 125 | 5 | 133 | weekly | |
24118 | 24118 | United States | District of Columbia | DC | 2020-09-27 | 2020-10-03 | 7 | 2020 | 40 | 705749 | 138 | 5 | 131 | weekly | |
24120 | 24120 | United States | District of Columbia | DC | 2020-10-11 | 2020-10-17 | 7 | 2020 | 42 | 705749 | 118 | 5 | 132 | weekly | |
24164 | 24164 | United States | District of Columbia | DC | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 705749 | 132 | 5 | 126 | weekly | |
24169 | 24169 | United States | District of Columbia | DC | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 705749 | 128 | 5 | 127 | weekly | |
24190 | 24190 | United States | District of Columbia | DC | 2022-02-13 | 2022-02-19 | 7 | 2022 | 7 | 705749 | 136 | 5 | 117 | weekly | |
24200 | 24200 | United States | District of Columbia | DC | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 705749 | 113 | 5 | 104 | weekly | |
24205 | 24205 | United States | District of Columbia | DC | 2022-05-29 | 2022-06-04 | 7 | 2022 | 22 | 705749 | 121 | 5 | 101 | weekly | |
24214 | 24214 | United States | District of Columbia | DC | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 705749 | 127 | 5 | 100 | weekly | |
24215 | 24215 | United States | District of Columbia | DC | 2022-08-07 | 2022-08-13 | 7 | 2022 | 32 | 705749 | 108 | 5 | 103 | weekly | |
24217 | 24217 | United States | District of Columbia | DC | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 705749 | 114 | 5 | 106 | weekly | |
25017 | 25017 | United States | Hawaii | HI | 2020-04-05 | 2020-04-11 | 7 | 2020 | 15 | 1415872 | 221 | 5 | 223 | weekly | |
25031 | 25031 | United States | Hawaii | HI | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 1415872 | 227 | 5 | 224 | weekly | |
25034 | 25034 | United States | Hawaii | HI | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 1415872 | 231 | 5 | 228 | weekly | |
25062 | 25062 | United States | Hawaii | HI | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 1415872 | 251 | 5 | 253 | weekly | |
25064 | 25064 | United States | Hawaii | HI | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 1415872 | 231 | 5 | 249 | weekly | |
25065 | 25065 | United States | Hawaii | HI | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 1415872 | 253 | 5 | 248 | weekly | |
25068 | 25068 | United States | Hawaii | HI | 2021-03-28 | 2021-04-03 | 7 | 2021 | 13 | 1415872 | 250 | 5 | 240 | weekly | |
25072 | 25072 | United States | Hawaii | HI | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 1415872 | 234 | 5 | 236 | weekly | |
25076 | 25076 | United States | Hawaii | HI | 2021-05-23 | 2021-05-29 | 7 | 2021 | 21 | 1415872 | 211 | 5 | 237 | weekly | |
25079 | 25079 | United States | Hawaii | HI | 2021-06-13 | 2021-06-19 | 7 | 2021 | 24 | 1415872 | 231 | 5 | 234 | weekly | |
25119 | 25119 | United States | Hawaii | HI | 2022-03-20 | 2022-03-26 | 7 | 2022 | 12 | 1415872 | 225 | 5 | 248 | weekly | |
25128 | 25128 | United States | Hawaii | HI | 2022-05-22 | 2022-05-28 | 7 | 2022 | 21 | 1415872 | 268 | 5 | 238 | weekly | |
25148 | 25148 | United States | Hawaii | HI | 2022-10-09 | 2022-10-15 | 7 | 2022 | 41 | 1415872 | 272 | 5 | 221 | weekly | |
25152 | 25152 | United States | Hawaii | HI | 2022-11-06 | 2022-11-12 | 7 | 2022 | 45 | 1415872 | 251 | 5 | 223 | weekly | |
25323 | 25323 | United States | Idaho | ID | 2020-03-22 | 2020-03-28 | 7 | 2020 | 13 | 1787065 | 332 | 5 | 291 | weekly | |
25324 | 25324 | United States | Idaho | ID | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 1787065 | 271 | 5 | 291 | weekly | |
25331 | 25331 | United States | Idaho | ID | 2020-05-17 | 2020-05-23 | 7 | 2020 | 21 | 1787065 | 262 | 5 | 289 | weekly | |
25432 | 25432 | United States | Idaho | ID | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 1787065 | 302 | 5 | 294 | weekly | |
25434 | 25434 | United States | Idaho | ID | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 1787065 | 277 | 5 | 292 | weekly | |
25457 | 25457 | United States | Idaho | ID | 2022-10-16 | 2022-10-22 | 7 | 2022 | 42 | 1787065 | 328 | 5 | 287 | weekly | |
25462 | 25462 | United States | Idaho | ID | 2022-11-20 | 2022-11-26 | 7 | 2022 | 47 | 1787065 | 334 | 5 | 287 | weekly | |
26609 | 26609 | United States | Kansas | KS | 2021-04-04 | 2021-04-10 | 7 | 2021 | 14 | 2913314 | 507 | 5 | 538 | weekly | |
26677 | 26677 | United States | Kansas | KS | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 2913314 | 517 | 5 | 484 | weekly | |
26690 | 26690 | United States | Kansas | KS | 2022-10-23 | 2022-10-29 | 7 | 2022 | 43 | 2913314 | 565 | 5 | 519 | weekly | |
27493 | 27493 | United States | Maine | ME | 2020-06-28 | 2020-07-04 | 7 | 2020 | 27 | 1344212 | 280 | 5 | 280 | weekly | |
27494 | 27494 | United States | Maine | ME | 2020-07-05 | 2020-07-11 | 7 | 2020 | 28 | 1344212 | 289 | 5 | 276 | weekly | |
27504 | 27504 | United States | Maine | ME | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 1344212 | 299 | 5 | 283 | weekly | |
27511 | 27511 | United States | Maine | ME | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 1344212 | 334 | 5 | 291 | weekly | |
27533 | 27533 | United States | Maine | ME | 2021-04-04 | 2021-04-10 | 7 | 2021 | 14 | 1344212 | 287 | 5 | 296 | weekly | |
27595 | 27595 | United States | Maine | ME | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1344212 | 318 | 5 | 281 | weekly | |
27606 | 27606 | United States | Maine | ME | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 1344212 | 331 | 5 | 293 | weekly | |
28402 | 28402 | United States | Michigan | MI | 2020-03-15 | 2020-03-21 | 7 | 2020 | 12 | 9986857 | 2036 | 5 | 1991 | weekly | |
29019 | 29019 | United States | Mississippi | MS | 2020-03-22 | 2020-03-28 | 7 | 2020 | 13 | 2976149 | 698 | 5 | 640 | weekly | |
29132 | 29132 | United States | Mississippi | MS | 2022-05-22 | 2022-05-28 | 7 | 2022 | 21 | 2976149 | 594 | 5 | 618 | weekly | |
29638 | 29638 | United States | Montana | MT | 2020-04-12 | 2020-04-18 | 7 | 2020 | 16 | 1068778 | 191 | 5 | 216 | weekly | |
29695 | 29695 | United States | Montana | MT | 2021-05-16 | 2021-05-22 | 7 | 2021 | 20 | 1068778 | 221 | 5 | 185 | weekly | |
29742 | 29742 | United States | Montana | MT | 2022-04-10 | 2022-04-16 | 7 | 2022 | 15 | 1068778 | 208 | 5 | 203 | weekly | |
29754 | 29754 | United States | Montana | MT | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 1068778 | 235 | 5 | 197 | weekly | |
29755 | 29755 | United States | Montana | MT | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 1068778 | 224 | 5 | 196 | weekly | |
29770 | 29770 | United States | Montana | MT | 2022-10-23 | 2022-10-29 | 7 | 2022 | 43 | 1068778 | 212 | 5 | 200 | weekly | |
30575 | 30575 | United States | New Hampshire | NH | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 1359711 | 231 | 5 | 242 | weekly | |
30622 | 30622 | United States | New Hampshire | NH | 2021-06-06 | 2021-06-12 | 7 | 2021 | 23 | 1359711 | 251 | 5 | 253 | weekly | |
30686 | 30686 | United States | New Hampshire | NH | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 1359711 | 267 | 5 | 237 | weekly | |
32157 | 32157 | United States | North Dakota | ND | 2021-05-02 | 2021-05-08 | 7 | 2021 | 18 | 762062 | 145 | 5 | 144 | weekly | |
32158 | 32158 | United States | North Dakota | ND | 2021-05-09 | 2021-05-15 | 7 | 2021 | 19 | 762062 | 138 | 5 | 142 | weekly | |
32160 | 32160 | United States | North Dakota | ND | 2021-05-23 | 2021-05-29 | 7 | 2021 | 21 | 762062 | 123 | 5 | 141 | weekly | |
32164 | 32164 | United States | North Dakota | ND | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 762062 | 149 | 5 | 137 | weekly | |
32167 | 32167 | United States | North Dakota | ND | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 762062 | 126 | 5 | 134 | weekly | |
33658 | 33658 | United States | Rhode Island | RI | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 1059361 | 209 | 5 | 186 | weekly | |
33702 | 33702 | United States | Rhode Island | RI | 2021-06-06 | 2021-06-12 | 7 | 2021 | 23 | 1059361 | 208 | 5 | 198 | weekly | |
33747 | 33747 | United States | Rhode Island | RI | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 1059361 | 178 | 5 | 214 | weekly | |
33760 | 33760 | United States | Rhode Island | RI | 2022-07-17 | 2022-07-23 | 7 | 2022 | 29 | 1059361 | 214 | 5 | 201 | weekly | |
33771 | 33771 | United States | Rhode Island | RI | 2022-10-02 | 2022-10-08 | 7 | 2022 | 40 | 1059361 | 213 | 5 | 205 | weekly | |
34265 | 34265 | United States | South Dakota | SD | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 884659 | 147 | 5 | 157 | weekly | |
34269 | 34269 | United States | South Dakota | SD | 2020-06-28 | 2020-07-04 | 7 | 2020 | 27 | 884659 | 160 | 5 | 154 | weekly | |
34328 | 34328 | United States | South Dakota | SD | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 884659 | 163 | 5 | 154 | weekly | |
34362 | 34362 | United States | South Dakota | SD | 2022-04-10 | 2022-04-16 | 7 | 2022 | 15 | 884659 | 155 | 5 | 162 | weekly | |
34372 | 34372 | United States | South Dakota | SD | 2022-06-19 | 2022-06-25 | 7 | 2022 | 25 | 884659 | 160 | 5 | 156 | weekly | |
34375 | 34375 | United States | South Dakota | SD | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 884659 | 166 | 5 | 157 | weekly | |
34381 | 34381 | United States | South Dakota | SD | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 884659 | 151 | 5 | 155 | weekly | |
34389 | 34389 | United States | South Dakota | SD | 2022-10-16 | 2022-10-22 | 7 | 2022 | 42 | 884659 | 186 | 5 | 167 | weekly | |
35180 | 35180 | United States | Utah | UT | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 3205958 | 408 | 5 | 401 | weekly | |
35492 | 35492 | United States | Vermont | VT | 2020-04-26 | 2020-05-02 | 7 | 2020 | 18 | 623989 | 111 | 5 | 113 | weekly | |
35522 | 35522 | United States | Vermont | VT | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 623989 | 129 | 5 | 115 | weekly | |
35538 | 35538 | United States | Vermont | VT | 2021-03-14 | 2021-03-20 | 7 | 2021 | 11 | 623989 | 104 | 5 | 116 | weekly | |
35539 | 35539 | United States | Vermont | VT | 2021-03-21 | 2021-03-27 | 7 | 2021 | 12 | 623989 | 99 | 5 | 114 | weekly | |
35540 | 35540 | United States | Vermont | VT | 2021-03-28 | 2021-04-03 | 7 | 2021 | 13 | 623989 | 102 | 5 | 115 | weekly | |
35561 | 35561 | United States | Vermont | VT | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 623989 | 115 | 5 | 110 | weekly | |
35597 | 35597 | United States | Vermont | VT | 2022-05-01 | 2022-05-07 | 7 | 2022 | 18 | 623989 | 131 | 5 | 105 | 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]);