economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
26 rows where country = "United States" and covid_deaths = 55
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, start_date, end_date, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23195 | 23195 | United States | Colorado | CO | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 5758736 | 801 | 55 | 782 | weekly | |
23507 | 23507 | United States | Connecticut | CT | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 3565287 | 727 | 55 | 626 | weekly | |
25995 | 25995 | United States | Indiana | IN | 2021-04-18 | 2021-04-24 | 7 | 2021 | 16 | 6732219 | 1285 | 55 | 1357 | weekly | |
26270 | 26270 | United States | Iowa | IA | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 3155070 | 597 | 55 | 568 | weekly | |
27293 | 27293 | United States | Louisiana | LA | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 4648794 | 966 | 55 | 853 | weekly | |
27573 | 27573 | United States | Maine | ME | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 1344212 | 352 | 55 | 321 | weekly | |
28735 | 28735 | United States | Minnesota | MN | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 5639632 | 893 | 55 | 872 | weekly | |
28772 | 28772 | United States | Minnesota | MN | 2021-05-23 | 2021-05-29 | 7 | 2021 | 21 | 5639632 | 876 | 55 | 868 | weekly | |
29072 | 29072 | United States | Mississippi | MS | 2021-03-28 | 2021-04-03 | 7 | 2021 | 13 | 2976149 | 650 | 55 | 622 | weekly | |
29121 | 29121 | United States | Mississippi | MS | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 2976149 | 698 | 55 | 645 | weekly | |
29674 | 29674 | United States | Montana | MT | 2020-12-20 | 2020-12-26 | 7 | 2020 | 52 | 1068778 | 308 | 55 | 203 | weekly | |
30649 | 30649 | United States | New Hampshire | NH | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 1359711 | 325 | 55 | 268 | weekly | |
30936 | 30936 | United States | New Jersey | NJ | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 8882190 | 1371 | 55 | 1465 | weekly | |
30976 | 30976 | United States | New Jersey | NJ | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 8882190 | 1345 | 55 | 1432 | weekly | |
31183 | 31183 | United States | New Mexico | NM | 2020-05-17 | 2020-05-23 | 7 | 2020 | 21 | 2096829 | 396 | 55 | 357 | weekly | |
31297 | 31297 | United States | New Mexico | NM | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 2096829 | 400 | 55 | 366 | weekly | |
31506 | 31506 | United States | New York | NY | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 19453561 | 2768 | 55 | 2847 | weekly | |
31793 | 31793 | United States | North Carolina | NC | 2020-04-05 | 2020-04-11 | 7 | 2020 | 15 | 10488084 | 2016 | 55 | 1991 | weekly | |
32784 | 32784 | United States | Oklahoma | OK | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 3956971 | 846 | 55 | 752 | weekly | |
33070 | 33070 | United States | Oregon | OR | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 4217737 | 814 | 55 | 754 | weekly | |
33077 | 33077 | United States | Oregon | OR | 2021-04-04 | 2021-04-10 | 7 | 2021 | 14 | 4217737 | 781 | 55 | 735 | weekly | |
33450 | 33450 | United States | Pennsylvania | PA | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 12801989 | 2578 | 55 | 2369 | weekly | |
33688 | 33688 | United States | Rhode Island | RI | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 1059361 | 227 | 55 | 210 | weekly | |
34622 | 34622 | United States | Tennessee | TN | 2021-05-09 | 2021-05-15 | 7 | 2021 | 19 | 6833174 | 1641 | 55 | 1510 | weekly | |
35009 | 35009 | United States | Texas | TX | 2022-11-13 | 2022-11-19 | 7 | 2022 | 46 | 28995881 | 4329 | 55 | 4285 | weekly | |
37112 | 37112 | United States | Wyoming | WY | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 578759 | 142 | 55 | 101 | 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]);