economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
54 rows where country = "United States" and covid_deaths = 18
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22560 | 22560 | United States | Arkansas | AR | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 3017825 | 610 | 18 | 623 | weekly | |
23272 | 23272 | United States | Colorado | CO | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 5758736 | 879 | 18 | 815 | weekly | |
23492 | 23492 | United States | Connecticut | CT | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 3565287 | 586 | 18 | 585 | weekly | |
23493 | 23493 | United States | Connecticut | CT | 2020-07-26 | 2020-08-01 | 7 | 2020 | 31 | 3565287 | 555 | 18 | 583 | weekly | |
24128 | 24128 | United States | District of Columbia | DC | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 705749 | 175 | 18 | 140 | weekly | |
25044 | 25044 | United States | Hawaii | HI | 2020-10-11 | 2020-10-17 | 7 | 2020 | 42 | 1415872 | 237 | 18 | 225 | weekly | |
25430 | 25430 | United States | Idaho | ID | 2022-04-10 | 2022-04-16 | 7 | 2022 | 15 | 1787065 | 291 | 18 | 300 | weekly | |
25445 | 25445 | United States | Idaho | ID | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 1787065 | 324 | 18 | 278 | weekly | |
25446 | 25446 | United States | Idaho | ID | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 1787065 | 329 | 18 | 276 | weekly | |
26261 | 26261 | United States | Iowa | IA | 2020-06-28 | 2020-07-04 | 7 | 2020 | 27 | 3155070 | 596 | 18 | 549 | weekly | |
26577 | 26577 | United States | Kansas | KS | 2020-08-23 | 2020-08-29 | 7 | 2020 | 35 | 2913314 | 532 | 18 | 492 | weekly | |
26610 | 26610 | United States | Kansas | KS | 2021-04-11 | 2021-04-17 | 7 | 2021 | 15 | 2913314 | 496 | 18 | 532 | weekly | |
26620 | 26620 | United States | Kansas | KS | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 2913314 | 513 | 18 | 498 | weekly | |
26687 | 26687 | United States | Kansas | KS | 2022-10-02 | 2022-10-08 | 7 | 2022 | 40 | 2913314 | 534 | 18 | 509 | weekly | |
27283 | 27283 | United States | Louisiana | LA | 2022-05-15 | 2022-05-21 | 7 | 2022 | 20 | 4648794 | 972 | 18 | 886 | weekly | |
27483 | 27483 | United States | Maine | ME | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 1344212 | 285 | 18 | 301 | weekly | |
27539 | 27539 | United States | Maine | ME | 2021-05-16 | 2021-05-22 | 7 | 2021 | 20 | 1344212 | 336 | 18 | 282 | weekly | |
27855 | 27855 | United States | Maryland | MD | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 6045680 | 940 | 18 | 984 | weekly | |
28781 | 28781 | United States | Minnesota | MN | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 5639632 | 911 | 18 | 861 | weekly | |
29083 | 29083 | United States | Mississippi | MS | 2021-06-13 | 2021-06-19 | 7 | 2021 | 24 | 2976149 | 657 | 18 | 599 | weekly | |
29691 | 29691 | United States | Montana | MT | 2021-04-18 | 2021-04-24 | 7 | 2021 | 16 | 1068778 | 205 | 18 | 192 | weekly | |
29693 | 29693 | United States | Montana | MT | 2021-05-02 | 2021-05-08 | 7 | 2021 | 18 | 1068778 | 197 | 18 | 189 | weekly | |
29703 | 29703 | United States | Montana | MT | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 1068778 | 218 | 18 | 191 | weekly | |
29706 | 29706 | United States | Montana | MT | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 1068778 | 238 | 18 | 190 | weekly | |
29726 | 29726 | United States | Montana | MT | 2021-12-19 | 2021-12-25 | 7 | 2021 | 51 | 1068778 | 237 | 18 | 210 | weekly | |
29745 | 29745 | United States | Montana | MT | 2022-05-01 | 2022-05-07 | 7 | 2022 | 18 | 1068778 | 208 | 18 | 194 | weekly | |
30054 | 30054 | United States | Nebraska | NE | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 1934408 | 346 | 18 | 327 | weekly | |
30063 | 30063 | United States | Nebraska | NE | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 1934408 | 327 | 18 | 317 | weekly | |
30316 | 30316 | United States | Nevada | NV | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 3080156 | 548 | 18 | 530 | weekly | |
30633 | 30633 | United States | New Hampshire | NH | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 1359711 | 242 | 18 | 262 | weekly | |
30671 | 30671 | United States | New Hampshire | NH | 2022-05-15 | 2022-05-21 | 7 | 2022 | 20 | 1359711 | 242 | 18 | 237 | weekly | |
30888 | 30888 | United States | New Jersey | NJ | 2020-08-16 | 2020-08-22 | 7 | 2020 | 34 | 8882190 | 1341 | 18 | 1394 | weekly | |
31235 | 31235 | United States | New Mexico | NM | 2021-05-16 | 2021-05-22 | 7 | 2021 | 20 | 2096829 | 410 | 18 | 369 | weekly | |
31244 | 31244 | United States | New Mexico | NM | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 2096829 | 398 | 18 | 350 | weekly | |
31313 | 31313 | United States | New Mexico | NM | 2022-11-13 | 2022-11-19 | 7 | 2022 | 46 | 2096829 | 428 | 18 | 384 | weekly | |
32200 | 32200 | United States | North Dakota | ND | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 762062 | 149 | 18 | 148 | weekly | |
32201 | 32201 | United States | North Dakota | ND | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 762062 | 143 | 18 | 147 | weekly | |
32727 | 32727 | United States | Oklahoma | OK | 2020-06-14 | 2020-06-20 | 7 | 2020 | 25 | 3956971 | 741 | 18 | 736 | weekly | |
32728 | 32728 | United States | Oklahoma | OK | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 3956971 | 765 | 18 | 732 | weekly | |
32802 | 32802 | United States | Oklahoma | OK | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 3956971 | 864 | 18 | 802 | weekly | |
33029 | 33029 | United States | Oregon | OR | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 4217737 | 703 | 18 | 732 | weekly | |
33048 | 33048 | United States | Oregon | OR | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 4217737 | 790 | 18 | 684 | weekly | |
34281 | 34281 | United States | South Dakota | SD | 2020-09-20 | 2020-09-26 | 7 | 2020 | 39 | 884659 | 191 | 18 | 159 | weekly | |
34627 | 34627 | United States | Tennessee | TN | 2021-06-13 | 2021-06-19 | 7 | 2021 | 24 | 6833174 | 1576 | 18 | 1477 | weekly | |
35190 | 35190 | United States | Utah | UT | 2020-06-07 | 2020-06-13 | 7 | 2020 | 24 | 3205958 | 388 | 18 | 378 | weekly | |
35297 | 35297 | United States | Utah | UT | 2022-06-26 | 2022-07-02 | 7 | 2022 | 26 | 3205958 | 451 | 18 | 383 | weekly | |
35527 | 35527 | United States | Vermont | VT | 2020-12-27 | 2021-01-02 | 7 | 2020 | 53 | 623989 | 140 | 18 | 124 | weekly | |
35583 | 35583 | United States | Vermont | VT | 2022-01-23 | 2022-01-29 | 7 | 2022 | 4 | 623989 | 153 | 18 | 118 | weekly | |
36440 | 36440 | United States | West Virginia | WV | 2020-10-11 | 2020-10-17 | 7 | 2020 | 42 | 1792147 | 455 | 18 | 438 | weekly | |
36527 | 36527 | United States | West Virginia | WV | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1792147 | 519 | 18 | 430 | weekly | |
36541 | 36541 | United States | West Virginia | WV | 2022-09-18 | 2022-09-24 | 7 | 2022 | 38 | 1792147 | 469 | 18 | 435 | weekly | |
36719 | 36719 | United States | Wisconsin | WI | 2020-03-22 | 2020-03-28 | 7 | 2020 | 13 | 5822434 | 1146 | 18 | 1088 | weekly | |
36830 | 36830 | United States | Wisconsin | WI | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 5822434 | 1077 | 18 | 1037 | weekly | |
36856 | 36856 | United States | Wisconsin | WI | 2022-11-06 | 2022-11-12 | 7 | 2022 | 45 | 5822434 | 1154 | 18 | 1092 | 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]);