economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where cadence = "weekly" and "end_date" is on date 2020-01-25
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths, start_date (date)
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21618 | 21618 | United States | Alabama | AL | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 4903185 | 1056 | 0 | 1149 | weekly | |
21926 | 21926 | United States | Alaska | AK | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 731545 | 97 | 0 | 89 | weekly | |
22234 | 22234 | United States | Arizona | AZ | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 7278717 | 1275 | 0 | 1136 | weekly | |
22542 | 22542 | United States | Arkansas | AR | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 3017825 | 616 | 0 | 682 | weekly | |
22850 | 22850 | United States | California | CA | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 39512223 | 5832 | 0 | 6158 | weekly | |
23158 | 23158 | United States | Colorado | CO | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 5758736 | 853 | 0 | 864 | weekly | |
23466 | 23466 | United States | Connecticut | CT | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 3565287 | 653 | 0 | 665 | weekly | |
23774 | 23774 | United States | Delaware | DE | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 973764 | 190 | 0 | 203 | weekly | |
24082 | 24082 | United States | District of Columbia | DC | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 705749 | 131 | 0 | 147 | weekly | |
24390 | 24390 | United States | Florida | FL | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 21477737 | 4387 | 0 | 3997 | weekly | |
24698 | 24698 | United States | Georgia | GA | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 10617423 | 1829 | 0 | 1655 | weekly | |
25006 | 25006 | United States | Hawaii | HI | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 1415872 | 242 | 0 | 234 | weekly | |
25314 | 25314 | United States | Idaho | ID | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 1787065 | 275 | 0 | 301 | weekly | |
25622 | 25622 | United States | Illinois | IL | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 12671821 | 2199 | 0 | 2259 | weekly | |
25930 | 25930 | United States | Indiana | IN | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 6732219 | 1422 | 0 | 1468 | weekly | |
26238 | 26238 | United States | Iowa | IA | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 3155070 | 640 | 0 | 649 | weekly | |
26546 | 26546 | United States | Kansas | KS | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 2913314 | 571 | 0 | 562 | weekly | |
26854 | 26854 | United States | Kentucky | KY | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 4467673 | 944 | 0 | 1104 | weekly | |
27162 | 27162 | United States | Louisiana | LA | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 4648794 | 970 | 0 | 934 | weekly | |
27470 | 27470 | United States | Maine | ME | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 1344212 | 308 | 0 | 306 | weekly | |
27778 | 27778 | United States | Maryland | MD | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 6045680 | 1003 | 0 | 1114 | weekly | |
28086 | 28086 | United States | Massachusetts | MA | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 6949503 | 1302 | 0 | 1282 | weekly | |
28394 | 28394 | United States | Michigan | MI | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 9986857 | 2012 | 0 | 2046 | weekly | |
28702 | 28702 | United States | Minnesota | MN | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 5639632 | 955 | 0 | 951 | weekly | |
29010 | 29010 | United States | Mississippi | MS | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 2976149 | 612 | 0 | 664 | weekly | |
29318 | 29318 | United States | Missouri | MO | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 6137428 | 1352 | 0 | 1392 | weekly | |
29626 | 29626 | United States | Montana | MT | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 1068778 | 197 | 0 | 223 | weekly | |
29934 | 29934 | United States | Nebraska | NE | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 1934408 | 358 | 0 | 362 | weekly | |
30242 | 30242 | United States | Nevada | NV | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 3080156 | 577 | 0 | 601 | weekly | |
30550 | 30550 | United States | New Hampshire | NH | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 1359711 | 241 | 0 | 268 | weekly | |
30858 | 30858 | United States | New Jersey | NJ | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 8882190 | 1579 | 0 | 1584 | weekly | |
31166 | 31166 | United States | New Mexico | NM | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 2096829 | 404 | 0 | 394 | weekly | |
31474 | 31474 | United States | New York | NY | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 19453561 | 3205 | 0 | 3281 | weekly | |
31782 | 31782 | United States | North Carolina | NC | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 10488084 | 1994 | 0 | 2106 | weekly | |
32090 | 32090 | United States | North Dakota | ND | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 762062 | 147 | 0 | 141 | weekly | |
32398 | 32398 | United States | Ohio | OH | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 11689100 | 2564 | 0 | 2746 | weekly | |
32706 | 32706 | United States | Oklahoma | OK | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 3956971 | 803 | 0 | 840 | weekly | |
33014 | 33014 | United States | Oregon | OR | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 4217737 | 745 | 0 | 796 | weekly | |
33322 | 33322 | United States | Pennsylvania | PA | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 12801989 | 2795 | 0 | 3005 | weekly | |
33630 | 33630 | United States | Rhode Island | RI | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 1059361 | 199 | 0 | 221 | weekly | |
33938 | 33938 | United States | South Carolina | SC | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 5148714 | 1033 | 0 | 955 | weekly | |
34246 | 34246 | United States | South Dakota | SD | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 884659 | 151 | 0 | 179 | weekly | |
34554 | 34554 | United States | Tennessee | TN | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 6833174 | 1532 | 0 | 1608 | weekly | |
34862 | 34862 | United States | Texas | TX | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 28995881 | 4128 | 0 | 4335 | weekly | |
35170 | 35170 | United States | Utah | UT | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 3205958 | 390 | 0 | 411 | weekly | |
35478 | 35478 | United States | Vermont | VT | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 623989 | 121 | 0 | 125 | weekly | |
35786 | 35786 | United States | Virginia | VA | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 8535519 | 1459 | 0 | 1488 | weekly | |
36094 | 36094 | United States | Washington | WA | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 7614893 | 1192 | 0 | 1238 | weekly | |
36402 | 36402 | United States | West Virginia | WV | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 1792147 | 442 | 0 | 478 | weekly | |
36710 | 36710 | United States | Wisconsin | WI | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 5822434 | 1086 | 1 | 1120 | weekly | |
37018 | 37018 | United States | Wyoming | WY | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 578759 | 96 | 0 | 86 | weekly | |
37326 | 37326 | United States | United States | USA | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 328300544 | 59164 | 1 | 60602 | 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]);