economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where "end_date" is on date 2021-11-27
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21714 | 21714 | United States | Alabama | AL | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 4903185 | 1188 | 52 | 1084 | weekly | |
22022 | 22022 | United States | Alaska | AK | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 731545 | 154 | 12 | 90 | weekly | |
22330 | 22330 | United States | Arizona | AZ | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 7278717 | 1814 | 291 | 1197 | weekly | |
22638 | 22638 | United States | Arkansas | AR | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 3017825 | 755 | 44 | 661 | weekly | |
22946 | 22946 | United States | California | CA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 39512223 | 6013 | 436 | 5326 | weekly | |
23254 | 23254 | United States | Colorado | CO | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 5758736 | 1182 | 182 | 797 | weekly | |
23562 | 23562 | United States | Connecticut | CT | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 3565287 | 712 | 15 | 652 | weekly | |
23870 | 23870 | United States | Delaware | DE | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 973764 | 234 | 19 | 203 | weekly | |
24178 | 24178 | United States | District of Columbia | DC | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 705749 | 133 | 0 | 126 | weekly | |
24486 | 24486 | United States | Florida | FL | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 21477737 | 4344 | 391 | 4191 | weekly | |
24794 | 24794 | United States | Georgia | GA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 10617423 | 1949 | 196 | 1771 | weekly | |
25102 | 25102 | United States | Hawaii | HI | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1415872 | 227 | 17 | 240 | weekly | |
25410 | 25410 | United States | Idaho | ID | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1787065 | 381 | 46 | 293 | weekly | |
25718 | 25718 | United States | Illinois | IL | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 12671821 | 2525 | 101 | 2128 | weekly | |
26026 | 26026 | United States | Indiana | IN | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 6732219 | 1697 | 139 | 1355 | weekly | |
26334 | 26334 | United States | Iowa | IA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 3155070 | 747 | 86 | 634 | weekly | |
26642 | 26642 | United States | Kansas | KS | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 2913314 | 648 | 39 | 550 | weekly | |
26950 | 26950 | United States | Kentucky | KY | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 4467673 | 1180 | 189 | 961 | weekly | |
27258 | 27258 | United States | Louisiana | LA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 4648794 | 988 | 28 | 943 | weekly | |
27566 | 27566 | United States | Maine | ME | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1344212 | 398 | 32 | 313 | weekly | |
27874 | 27874 | United States | Maryland | MD | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 6045680 | 1084 | 53 | 1042 | weekly | |
28182 | 28182 | United States | Massachusetts | MA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 6949503 | 1270 | 83 | 1247 | weekly | |
28490 | 28490 | United States | Michigan | MI | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 9986857 | 2849 | 403 | 1969 | weekly | |
28798 | 28798 | United States | Minnesota | MN | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 5639632 | 1238 | 183 | 941 | weekly | |
29106 | 29106 | United States | Mississippi | MS | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 2976149 | 722 | 33 | 635 | weekly | |
29414 | 29414 | United States | Missouri | MO | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 6137428 | 1486 | 2990 | 1346 | weekly | |
29722 | 29722 | United States | Montana | MT | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1068778 | 266 | 84 | 200 | weekly | |
30030 | 30030 | United States | Nebraska | NE | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1934408 | 413 | 38 | 365 | weekly | |
30338 | 30338 | United States | Nevada | NV | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 3080156 | 617 | 54 | 511 | weekly | |
30646 | 30646 | United States | New Hampshire | NH | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1359711 | 295 | 21 | 266 | weekly | |
30954 | 30954 | United States | New Jersey | NJ | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 8882190 | 1609 | 0 | 1553 | weekly | |
31262 | 31262 | United States | New Mexico | NM | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 2096829 | 528 | 47 | 380 | weekly | |
31570 | 31570 | United States | New York | NY | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 19453561 | 3591 | 189 | 3146 | weekly | |
31878 | 31878 | United States | North Carolina | NC | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 10488084 | 2261 | 79 | 1961 | weekly | |
32186 | 32186 | United States | North Dakota | ND | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 762062 | 181 | 22 | 152 | weekly | |
32494 | 32494 | United States | Ohio | OH | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 11689100 | 3297 | 420 | 2555 | weekly | |
32802 | 32802 | United States | Oklahoma | OK | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 3956971 | 864 | 18 | 802 | weekly | |
33110 | 33110 | United States | Oregon | OR | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 4217737 | 875 | 202 | 721 | weekly | |
33418 | 33418 | United States | Pennsylvania | PA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 12801989 | 3446 | 340 | 2723 | weekly | |
33726 | 33726 | United States | Rhode Island | RI | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1059361 | 248 | 9 | 220 | weekly | |
34034 | 34034 | United States | South Carolina | SC | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 5148714 | 1191 | 90 | 1037 | weekly | |
34342 | 34342 | United States | South Dakota | SD | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 884659 | 217 | 17 | 169 | weekly | |
34650 | 34650 | United States | Tennessee | TN | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 6833174 | 1751 | 138 | 1546 | weekly | |
34958 | 34958 | United States | Texas | TX | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 28995881 | 4718 | 306 | 4237 | weekly | |
35266 | 35266 | United States | Utah | UT | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 3205958 | 474 | 59 | 383 | weekly | |
35574 | 35574 | United States | Vermont | VT | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 623989 | 139 | 2 | 112 | weekly | |
35882 | 35882 | United States | Virginia | VA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 8535519 | 1631 | 143 | 1435 | weekly | |
36190 | 36190 | United States | Washington | WA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 7614893 | 1336 | 98 | 1177 | weekly | |
36498 | 36498 | United States | West Virginia | WV | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1792147 | 575 | 91 | 473 | weekly | |
36806 | 36806 | United States | Wisconsin | WI | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 5822434 | 1394 | 123 | 1103 | weekly | |
37114 | 37114 | United States | Wyoming | WY | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 578759 | 134 | 0 | 102 | weekly | |
37422 | 37422 | United States | United States | USA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 328300544 | 67969 | 8650 | 58024 | 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]);