economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
38 rows where country = "United States" and covid_deaths = 45
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, year, week, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23787 | 23787 | United States | Delaware | DE | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 973764 | 285 | 45 | 187 | weekly | |
23827 | 23827 | United States | Delaware | DE | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 973764 | 265 | 45 | 216 | weekly | |
25114 | 25114 | United States | Hawaii | HI | 2022-02-13 | 2022-02-19 | 7 | 2022 | 7 | 1415872 | 267 | 45 | 257 | weekly | |
26051 | 26051 | United States | Indiana | IN | 2022-05-15 | 2022-05-21 | 7 | 2022 | 20 | 6732219 | 1291 | 45 | 1249 | weekly | |
26061 | 26061 | United States | Indiana | IN | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 6732219 | 1366 | 45 | 1199 | weekly | |
26684 | 26684 | United States | Kansas | KS | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 2913314 | 563 | 45 | 494 | weekly | |
26879 | 26879 | United States | Kentucky | KY | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 4467673 | 936 | 45 | 925 | weekly | |
26891 | 26891 | United States | Kentucky | KY | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 4467673 | 1068 | 45 | 941 | weekly | |
26986 | 26986 | United States | Kentucky | KY | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 4467673 | 1063 | 45 | 883 | weekly | |
27230 | 27230 | United States | Louisiana | LA | 2021-05-09 | 2021-05-15 | 7 | 2021 | 19 | 4648794 | 939 | 45 | 934 | weekly | |
27562 | 27562 | United States | Maine | ME | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 1344212 | 357 | 45 | 307 | weekly | |
27817 | 27817 | United States | Maryland | MD | 2020-10-18 | 2020-10-24 | 7 | 2020 | 43 | 6045680 | 1101 | 45 | 1014 | weekly | |
27860 | 27860 | United States | Maryland | MD | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 6045680 | 945 | 45 | 980 | weekly | |
27913 | 27913 | United States | Maryland | MD | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 6045680 | 1004 | 45 | 929 | weekly | |
28169 | 28169 | United States | Massachusetts | MA | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 6949503 | 1132 | 45 | 1152 | weekly | |
28724 | 28724 | United States | Minnesota | MN | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 5639632 | 840 | 45 | 822 | weekly | |
28786 | 28786 | United States | Minnesota | MN | 2021-08-29 | 2021-09-04 | 7 | 2021 | 35 | 5639632 | 971 | 45 | 892 | weekly | |
29071 | 29071 | United States | Mississippi | MS | 2021-03-21 | 2021-03-27 | 7 | 2021 | 12 | 2976149 | 671 | 45 | 624 | weekly | |
29347 | 29347 | United States | Missouri | MO | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 6137428 | 1380 | 45 | 1207 | weekly | |
30357 | 30357 | United States | Nevada | NV | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 3080156 | 601 | 45 | 537 | weekly | |
30595 | 30595 | United States | New Hampshire | NH | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 1359711 | 313 | 45 | 256 | weekly | |
30996 | 30996 | United States | New Jersey | NJ | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 8882190 | 1396 | 45 | 1353 | weekly | |
31180 | 31180 | United States | New Mexico | NM | 2020-04-26 | 2020-05-02 | 7 | 2020 | 18 | 2096829 | 420 | 45 | 373 | weekly | |
31507 | 31507 | United States | New York | NY | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 19453561 | 2757 | 45 | 2875 | weekly | |
32180 | 32180 | United States | North Dakota | ND | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 762062 | 207 | 45 | 149 | weekly | |
33399 | 33399 | United States | Pennsylvania | PA | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 12801989 | 2431 | 45 | 2564 | weekly | |
33955 | 33955 | United States | South Carolina | SC | 2020-05-17 | 2020-05-23 | 7 | 2020 | 21 | 5148714 | 1046 | 45 | 955 | weekly | |
33959 | 33959 | United States | South Carolina | SC | 2020-06-14 | 2020-06-20 | 7 | 2020 | 25 | 5148714 | 1052 | 45 | 943 | weekly | |
34572 | 34572 | United States | Tennessee | TN | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 6833174 | 1467 | 45 | 1451 | weekly | |
34632 | 34632 | United States | Tennessee | TN | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 6833174 | 1560 | 45 | 1461 | weekly | |
35280 | 35280 | United States | Utah | UT | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 3205958 | 448 | 45 | 405 | weekly | |
36125 | 36125 | United States | Washington | WA | 2020-08-23 | 2020-08-29 | 7 | 2020 | 35 | 7614893 | 1118 | 45 | 1077 | weekly | |
36128 | 36128 | United States | Washington | WA | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 7614893 | 1178 | 45 | 1084 | weekly | |
36171 | 36171 | United States | Washington | WA | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 7614893 | 1226 | 45 | 1090 | weekly | |
36729 | 36729 | United States | Wisconsin | WI | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 5822434 | 1043 | 45 | 979 | weekly | |
36768 | 36768 | United States | Wisconsin | WI | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 5822434 | 1075 | 45 | 1158 | weekly | |
36857 | 36857 | United States | Wisconsin | WI | 2022-11-13 | 2022-11-19 | 7 | 2022 | 46 | 5822434 | 1183 | 45 | 1098 | weekly | |
37107 | 37107 | United States | Wyoming | WY | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 578759 | 160 | 45 | 94 | 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]);