economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
43 rows where country = "United States" and covid_deaths = 20
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, year, week, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
270 | 270 | United States | United States | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 338289856 | 59699 | 20 | TBC | weekly | |
22018 | 22018 | United States | Alaska | AK | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 731545 | 169 | 20 | 88 | weekly | |
22605 | 22605 | United States | Arkansas | AR | 2021-04-04 | 2021-04-10 | 7 | 2021 | 14 | 3017825 | 693 | 20 | 666 | weekly | |
22617 | 22617 | United States | Arkansas | AR | 2021-06-27 | 2021-07-03 | 7 | 2021 | 26 | 3017825 | 688 | 20 | 619 | weekly | |
23580 | 23580 | United States | Connecticut | CT | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 3565287 | 628 | 20 | 651 | weekly | |
23816 | 23816 | United States | Delaware | DE | 2020-11-08 | 2020-11-14 | 7 | 2020 | 46 | 973764 | 172 | 20 | 194 | weekly | |
23826 | 23826 | United States | Delaware | DE | 2021-01-17 | 2021-01-23 | 7 | 2021 | 3 | 973764 | 284 | 20 | 216 | weekly | |
24103 | 24103 | United States | District of Columbia | DC | 2020-06-14 | 2020-06-20 | 7 | 2020 | 25 | 705749 | 132 | 20 | 126 | weekly | |
25089 | 25089 | United States | Hawaii | HI | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 1415872 | 315 | 20 | 235 | weekly | |
25110 | 25110 | United States | Hawaii | HI | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 1415872 | 324 | 20 | 256 | weekly | |
25134 | 25134 | United States | Hawaii | HI | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 1415872 | 241 | 20 | 231 | weekly | |
25350 | 25350 | United States | Idaho | ID | 2020-09-27 | 2020-10-03 | 7 | 2020 | 40 | 1787065 | 328 | 20 | 289 | weekly | |
26379 | 26379 | United States | Iowa | IA | 2022-10-02 | 2022-10-08 | 7 | 2022 | 40 | 3155070 | 591 | 20 | 585 | weekly | |
27547 | 27547 | United States | Maine | ME | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 1344212 | 305 | 20 | 276 | weekly | |
27552 | 27552 | United States | Maine | ME | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 1344212 | 306 | 20 | 279 | weekly | |
27560 | 27560 | United States | Maine | ME | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 1344212 | 380 | 20 | 295 | weekly | |
27585 | 27585 | United States | Maine | ME | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 1344212 | 324 | 20 | 305 | weekly | |
29086 | 29086 | United States | Mississippi | MS | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 2976149 | 662 | 20 | 599 | weekly | |
29153 | 29153 | United States | Mississippi | MS | 2022-10-16 | 2022-10-22 | 7 | 2022 | 42 | 2976149 | 677 | 20 | 622 | weekly | |
29953 | 29953 | United States | Nebraska | NE | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 1934408 | 319 | 20 | 314 | weekly | |
29960 | 29960 | United States | Nebraska | NE | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 1934408 | 361 | 20 | 308 | weekly | |
30389 | 30389 | United States | Nevada | NV | 2022-11-13 | 2022-11-19 | 7 | 2022 | 46 | 3080156 | 551 | 20 | 523 | weekly | |
30618 | 30618 | United States | New Hampshire | NH | 2021-05-09 | 2021-05-15 | 7 | 2021 | 19 | 1359711 | 232 | 20 | 258 | weekly | |
31202 | 31202 | United States | New Mexico | NM | 2020-09-27 | 2020-10-03 | 7 | 2020 | 40 | 2096829 | 388 | 20 | 356 | weekly | |
31792 | 31792 | United States | North Carolina | NC | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 10488084 | 2024 | 20 | 2011 | weekly | |
32722 | 32722 | United States | Oklahoma | OK | 2020-05-10 | 2020-05-16 | 7 | 2020 | 20 | 3956971 | 733 | 20 | 745 | weekly | |
32775 | 32775 | United States | Oklahoma | OK | 2021-05-16 | 2021-05-22 | 7 | 2021 | 20 | 3956971 | 786 | 20 | 778 | weekly | |
32777 | 32777 | United States | Oklahoma | OK | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 3956971 | 757 | 20 | 774 | weekly | |
33050 | 33050 | United States | Oregon | OR | 2020-09-27 | 2020-10-03 | 7 | 2020 | 40 | 4217737 | 733 | 20 | 694 | weekly | |
33089 | 33089 | United States | Oregon | OR | 2021-06-27 | 2021-07-03 | 7 | 2021 | 26 | 4217737 | 943 | 20 | 688 | weekly | |
33776 | 33776 | United States | Rhode Island | RI | 2022-11-06 | 2022-11-12 | 7 | 2022 | 45 | 1059361 | 217 | 20 | 209 | weekly | |
35237 | 35237 | United States | Utah | UT | 2021-05-02 | 2021-05-08 | 7 | 2021 | 18 | 3205958 | 385 | 20 | 390 | weekly | |
35247 | 35247 | United States | Utah | UT | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 3205958 | 384 | 20 | 375 | weekly | |
35571 | 35571 | United States | Vermont | VT | 2021-10-31 | 2021-11-06 | 7 | 2021 | 44 | 623989 | 141 | 20 | 111 | weekly | |
35623 | 35623 | United States | Vermont | VT | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 623989 | 172 | 20 | 105 | weekly | |
36472 | 36472 | United States | West Virginia | WV | 2021-05-23 | 2021-05-29 | 7 | 2021 | 21 | 1792147 | 458 | 20 | 443 | weekly | |
36544 | 36544 | United States | West Virginia | WV | 2022-10-09 | 2022-10-15 | 7 | 2022 | 41 | 1792147 | 477 | 20 | 444 | weekly | |
36547 | 36547 | United States | West Virginia | WV | 2022-10-30 | 2022-11-05 | 7 | 2022 | 44 | 1792147 | 568 | 20 | 450 | weekly | |
36734 | 36734 | United States | Wisconsin | WI | 2020-07-05 | 2020-07-11 | 7 | 2020 | 28 | 5822434 | 1049 | 20 | 968 | weekly | |
36824 | 36824 | United States | Wisconsin | WI | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 5822434 | 1115 | 20 | 1079 | weekly | |
37058 | 37058 | United States | Wyoming | WY | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 578759 | 114 | 20 | 80 | weekly | |
37130 | 37130 | United States | Wyoming | WY | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 578759 | 100 | 20 | 99 | weekly | |
37332 | 37332 | United States | United States | USA | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 328300544 | 59699 | 20 | 59870 | 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]);