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 2022-02-26 sorted by expected_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: total_deaths, expected_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37127 | 37127 | United States | Wyoming | WY | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 578759 | 133 | 29 | 100 | weekly | |
26963 | 26963 | United States | Kentucky | KY | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 4467673 | 1207 | 193 | 1004 | weekly | |
34047 | 34047 | United States | South Carolina | SC | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 5148714 | 1224 | 257 | 1069 | weekly | |
27887 | 27887 | United States | Maryland | MD | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 6045680 | 1096 | 102 | 1076 | weekly | |
21727 | 21727 | United States | Alabama | AL | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 4903185 | 1332 | 309 | 1104 | weekly | |
36819 | 36819 | United States | Wisconsin | WI | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 5822434 | 1171 | 242 | 1110 | weekly | |
24191 | 24191 | United States | District of Columbia | DC | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 705749 | 133 | 3 | 115 | weekly | |
35587 | 35587 | United States | Vermont | VT | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 623989 | 122 | 12 | 115 | weekly | |
36203 | 36203 | United States | Washington | WA | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 7614893 | 1321 | 216 | 1264 | weekly | |
28195 | 28195 | United States | Massachusetts | MA | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 6949503 | 1195 | 261 | 1285 | weekly | |
22343 | 22343 | United States | Arizona | AZ | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 7278717 | 1551 | 418 | 1335 | weekly | |
26039 | 26039 | United States | Indiana | IN | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 6732219 | 1604 | 271 | 1386 | weekly | |
29427 | 29427 | United States | Missouri | MO | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 6137428 | 1484 | 495 | 1388 | weekly | |
32199 | 32199 | United States | North Dakota | ND | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 762062 | 178 | 15 | 148 | weekly | |
35895 | 35895 | United States | Virginia | VA | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 8535519 | 1616 | 589 | 1480 | weekly | |
30967 | 30967 | United States | New Jersey | NJ | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 8882190 | 1544 | 241 | 1583 | weekly | |
34663 | 34663 | United States | Tennessee | TN | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 6833174 | 1897 | 577 | 1587 | weekly | |
34355 | 34355 | United States | South Dakota | SD | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 884659 | 160 | 26 | 172 | weekly | |
24807 | 24807 | United States | Georgia | GA | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 10617423 | 2060 | 559 | 1794 | weekly | |
23883 | 23883 | United States | Delaware | DE | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 973764 | 242 | 46 | 198 | weekly | |
28503 | 28503 | United States | Michigan | MI | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 9986857 | 2193 | 479 | 1999 | weekly | |
31891 | 31891 | United States | North Carolina | NC | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 10488084 | 2156 | 352 | 2044 | weekly | |
29735 | 29735 | United States | Montana | MT | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 1068778 | 251 | 67 | 217 | weekly | |
25731 | 25731 | United States | Illinois | IL | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 12671821 | 2304 | 432 | 2178 | weekly | |
33739 | 33739 | United States | Rhode Island | RI | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 1059361 | 236 | 9 | 227 | weekly | |
25115 | 25115 | United States | Hawaii | HI | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 1415872 | 279 | 29 | 256 | weekly | |
32507 | 32507 | United States | Ohio | OH | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 11689100 | 2753 | 1087 | 2617 | weekly | |
30659 | 30659 | United States | New Hampshire | NH | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 1359711 | 275 | 40 | 274 | weekly | |
33431 | 33431 | United States | Pennsylvania | PA | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 12801989 | 2883 | 517 | 2782 | weekly | |
25423 | 25423 | United States | Idaho | ID | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 1787065 | 336 | 56 | 310 | weekly | |
31583 | 31583 | United States | New York | NY | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 19453561 | 3144 | 357 | 3193 | weekly | |
27579 | 27579 | United States | Maine | ME | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 1344212 | 301 | 104 | 320 | weekly | |
30043 | 30043 | United States | Nebraska | NE | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 1934408 | 374 | 73 | 373 | weekly | |
31275 | 31275 | United States | New Mexico | NM | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 2096829 | 506 | 128 | 406 | weekly | |
35279 | 35279 | United States | Utah | UT | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 3205958 | 447 | 49 | 410 | weekly | |
34971 | 34971 | United States | Texas | TX | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 28995881 | 5125 | 1066 | 4364 | weekly | |
24499 | 24499 | United States | Florida | FL | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 21477737 | 5006 | 1132 | 4467 | weekly | |
36511 | 36511 | United States | West Virginia | WV | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 1792147 | 552 | 146 | 487 | weekly | |
30351 | 30351 | United States | Nevada | NV | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 3080156 | 676 | 156 | 565 | weekly | |
26655 | 26655 | United States | Kansas | KS | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 2913314 | 620 | 30 | 573 | weekly | |
22959 | 22959 | United States | California | CA | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 39512223 | 6427 | 1195 | 5760 | weekly | |
37435 | 37435 | United States | United States | USA | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 328300544 | 66002 | 13827 | 60218 | weekly | |
26347 | 26347 | United States | Iowa | IA | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 3155070 | 693 | 137 | 636 | weekly | |
29119 | 29119 | United States | Mississippi | MS | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 2976149 | 739 | 172 | 653 | weekly | |
23575 | 23575 | United States | Connecticut | CT | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 3565287 | 659 | 108 | 678 | weekly | |
22651 | 22651 | United States | Arkansas | AR | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 3017825 | 799 | 154 | 679 | weekly | |
33123 | 33123 | United States | Oregon | OR | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 4217737 | 954 | 126 | 757 | weekly | |
23267 | 23267 | United States | Colorado | CO | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 5758736 | 913 | 82 | 841 | weekly | |
32815 | 32815 | United States | Oklahoma | OK | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 3956971 | 903 | 336 | 854 | weekly | |
22035 | 22035 | United States | Alaska | AK | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 731545 | 92 | 21 | 91 | weekly | |
28811 | 28811 | United States | Minnesota | MN | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 5639632 | 1012 | 120 | 935 | weekly | |
27271 | 27271 | United States | Louisiana | LA | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 4648794 | 1124 | 206 | 959 | 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]);