economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where "start_date" is on date 2022-03-27
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date)
country 1
cadence 1
- weekly 52
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21732 | 21732 | United States | Alabama | AL | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 4903185 | 1043 | 103 | 1079 | weekly | |
22040 | 22040 | United States | Alaska | AK | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 731545 | 99 | 0 | 90 | weekly | |
22348 | 22348 | United States | Arizona | AZ | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 7278717 | 1326 | 385 | 1322 | weekly | |
22656 | 22656 | United States | Arkansas | AR | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 3017825 | 654 | 72 | 645 | weekly | |
22964 | 22964 | United States | California | CA | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 39512223 | 5357 | 309 | 5434 | weekly | |
23272 | 23272 | United States | Colorado | CO | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 5758736 | 879 | 18 | 815 | weekly | |
23580 | 23580 | United States | Connecticut | CT | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 3565287 | 628 | 20 | 651 | weekly | |
23888 | 23888 | United States | Delaware | DE | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 973764 | 209 | 9 | 187 | weekly | |
24196 | 24196 | United States | District of Columbia | DC | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 705749 | 129 | 0 | 110 | weekly | |
24504 | 24504 | United States | Florida | FL | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 21477737 | 4591 | 317 | 4371 | weekly | |
24812 | 24812 | United States | Georgia | GA | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 10617423 | 1808 | 286 | 1755 | weekly | |
25120 | 25120 | United States | Hawaii | HI | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 1415872 | 201 | 6 | 249 | weekly | |
25428 | 25428 | United States | Idaho | ID | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 1787065 | 288 | 9 | 305 | weekly | |
25736 | 25736 | United States | Illinois | IL | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 12671821 | 2063 | 95 | 2089 | weekly | |
26044 | 26044 | United States | Indiana | IN | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 6732219 | 1402 | 17 | 1339 | weekly | |
26352 | 26352 | United States | Iowa | IA | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 3155070 | 598 | 43 | 606 | weekly | |
26660 | 26660 | United States | Kansas | KS | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 2913314 | 531 | 176 | 540 | weekly | |
26968 | 26968 | United States | Kentucky | KY | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 4467673 | 1017 | 236 | 955 | weekly | |
27276 | 27276 | United States | Louisiana | LA | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 4648794 | 925 | 62 | 925 | weekly | |
27584 | 27584 | United States | Maine | ME | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 1344212 | 319 | 7 | 309 | weekly | |
27892 | 27892 | United States | Maryland | MD | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 6045680 | 1021 | 31 | 1013 | weekly | |
28200 | 28200 | United States | Massachusetts | MA | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 6949503 | 1160 | 43 | 1206 | weekly | |
28508 | 28508 | United States | Michigan | MI | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 9986857 | 1882 | 134 | 1931 | weekly | |
28816 | 28816 | United States | Minnesota | MN | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 5639632 | 898 | 41 | 908 | weekly | |
29124 | 29124 | United States | Mississippi | MS | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 2976149 | 620 | 177 | 640 | weekly | |
29432 | 29432 | United States | Missouri | MO | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 6137428 | 1235 | 119 | 1310 | weekly | |
29740 | 29740 | United States | Montana | MT | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 1068778 | 193 | 7 | 208 | weekly | |
30048 | 30048 | United States | Nebraska | NE | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 1934408 | 324 | 109 | 349 | weekly | |
30356 | 30356 | United States | Nevada | NV | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 3080156 | 528 | 60 | 540 | weekly | |
30664 | 30664 | United States | New Hampshire | NH | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 1359711 | 250 | 7 | 258 | weekly | |
30972 | 30972 | United States | New Jersey | NJ | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 8882190 | 1398 | 35 | 1496 | weekly | |
31280 | 31280 | United States | New Mexico | NM | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 2096829 | 393 | 73 | 393 | weekly | |
31588 | 31588 | United States | New York | NY | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 19453561 | 3004 | 121 | 3033 | weekly | |
31896 | 31896 | United States | North Carolina | NC | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 10488084 | 1936 | 41 | 1985 | weekly | |
32204 | 32204 | United States | North Dakota | ND | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 762062 | 125 | 0 | 147 | weekly | |
32512 | 32512 | United States | Ohio | OH | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 11689100 | 2463 | 249 | 2495 | weekly | |
32820 | 32820 | United States | Oklahoma | OK | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 3956971 | 828 | 147 | 801 | weekly | |
33128 | 33128 | United States | Oregon | OR | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 4217737 | 756 | 112 | 733 | weekly | |
33436 | 33436 | United States | Pennsylvania | PA | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 12801989 | 2669 | 105 | 2647 | weekly | |
33744 | 33744 | United States | Rhode Island | RI | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 1059361 | 176 | 84 | 220 | weekly | |
34052 | 34052 | United States | South Carolina | SC | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 5148714 | 993 | 98 | 1038 | weekly | |
34360 | 34360 | United States | South Dakota | SD | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 884659 | 187 | 3 | 165 | weekly | |
34668 | 34668 | United States | Tennessee | TN | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 6833174 | 1637 | 67 | 1552 | weekly | |
34976 | 34976 | United States | Texas | TX | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 28995881 | 4358 | 188 | 4176 | weekly | |
35284 | 35284 | United States | Utah | UT | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 3205958 | 405 | 12 | 396 | weekly | |
35592 | 35592 | United States | Vermont | VT | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 623989 | 119 | 2 | 110 | weekly | |
35900 | 35900 | United States | Virginia | VA | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 8535519 | 1428 | 358 | 1422 | weekly | |
36208 | 36208 | United States | Washington | WA | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 7614893 | 1209 | 78 | 1214 | weekly | |
36516 | 36516 | United States | West Virginia | WV | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 1792147 | 530 | 96 | 467 | weekly | |
36824 | 36824 | United States | Wisconsin | WI | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 5822434 | 1115 | 20 | 1079 | weekly | |
37132 | 37132 | United States | Wyoming | WY | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 578759 | 98 | 8 | 96 | weekly | |
37440 | 37440 | United States | United States | USA | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 328300544 | 58005 | 4795 | 57804 | 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]);