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 2022-03-05
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21728 | 21728 | United States | Alabama | AL | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 4903185 | 1195 | 294 | 1095 | weekly | |
22036 | 22036 | United States | Alaska | AK | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 731545 | 104 | 35 | 90 | weekly | |
22344 | 22344 | United States | Arizona | AZ | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 7278717 | 1511 | -223 | 1339 | weekly | |
22652 | 22652 | United States | Arkansas | AR | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 3017825 | 801 | 256 | 677 | weekly | |
22960 | 22960 | United States | California | CA | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 39512223 | 6252 | 1300 | 5696 | weekly | |
23268 | 23268 | United States | Colorado | CO | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 5758736 | 943 | 42 | 837 | weekly | |
23576 | 23576 | United States | Connecticut | CT | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 3565287 | 675 | 78 | 679 | weekly | |
23884 | 23884 | United States | Delaware | DE | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 973764 | 217 | 7 | 197 | weekly | |
24192 | 24192 | United States | District of Columbia | DC | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 705749 | 121 | 2 | 114 | weekly | |
24500 | 24500 | United States | Florida | FL | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 21477737 | 4779 | 1309 | 4452 | weekly | |
24808 | 24808 | United States | Georgia | GA | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 10617423 | 2037 | 466 | 1785 | weekly | |
25116 | 25116 | United States | Hawaii | HI | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 1415872 | 244 | 27 | 255 | weekly | |
25424 | 25424 | United States | Idaho | ID | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 1787065 | 370 | 58 | 306 | weekly | |
25732 | 25732 | United States | Illinois | IL | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 12671821 | 2206 | 316 | 2162 | weekly | |
26040 | 26040 | United States | Indiana | IN | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 6732219 | 1476 | 202 | 1379 | weekly | |
26348 | 26348 | United States | Iowa | IA | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 3155070 | 714 | 86 | 631 | weekly | |
26656 | 26656 | United States | Kansas | KS | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 2913314 | 664 | 46 | 567 | weekly | |
26964 | 26964 | United States | Kentucky | KY | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 4467673 | 1232 | 260 | 998 | weekly | |
27272 | 27272 | United States | Louisiana | LA | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 4648794 | 1125 | 148 | 949 | weekly | |
27580 | 27580 | United States | Maine | ME | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 1344212 | 292 | 71 | 323 | weekly | |
27888 | 27888 | United States | Maryland | MD | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 6045680 | 1057 | 71 | 1064 | weekly | |
28196 | 28196 | United States | Massachusetts | MA | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 6949503 | 1154 | 207 | 1270 | weekly | |
28504 | 28504 | United States | Michigan | MI | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 9986857 | 2086 | 364 | 1988 | weekly | |
28812 | 28812 | United States | Minnesota | MN | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 5639632 | 936 | 102 | 931 | weekly | |
29120 | 29120 | United States | Mississippi | MS | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 2976149 | 754 | 143 | 649 | weekly | |
29428 | 29428 | United States | Missouri | MO | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 6137428 | 1423 | 243 | 1368 | weekly | |
29736 | 29736 | United States | Montana | MT | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 1068778 | 244 | 32 | 214 | weekly | |
30044 | 30044 | United States | Nebraska | NE | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 1934408 | 372 | 57 | 364 | weekly | |
30352 | 30352 | United States | Nevada | NV | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 3080156 | 644 | 110 | 558 | weekly | |
30660 | 30660 | United States | New Hampshire | NH | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 1359711 | 266 | 29 | 269 | weekly | |
30968 | 30968 | United States | New Jersey | NJ | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 8882190 | 1555 | 117 | 1568 | weekly | |
31276 | 31276 | United States | New Mexico | NM | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 2096829 | 488 | 69 | 401 | weekly | |
31584 | 31584 | United States | New York | NY | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 19453561 | 3208 | 254 | 3170 | weekly | |
31892 | 31892 | United States | North Carolina | NC | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 10488084 | 2155 | 263 | 2039 | weekly | |
32200 | 32200 | United States | North Dakota | ND | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 762062 | 149 | 18 | 148 | weekly | |
32508 | 32508 | United States | Ohio | OH | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 11689100 | 2574 | 438 | 2598 | weekly | |
32816 | 32816 | United States | Oklahoma | OK | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 3956971 | 985 | 242 | 842 | weekly | |
33124 | 33124 | United States | Oregon | OR | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 4217737 | 880 | 127 | 751 | weekly | |
33432 | 33432 | United States | Pennsylvania | PA | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 12801989 | 2902 | 322 | 2763 | weekly | |
33740 | 33740 | United States | Rhode Island | RI | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 1059361 | 224 | 11 | 224 | weekly | |
34048 | 34048 | United States | South Carolina | SC | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 5148714 | 1110 | 171 | 1066 | weekly | |
34356 | 34356 | United States | South Dakota | SD | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 884659 | 147 | 30 | 171 | weekly | |
34664 | 34664 | United States | Tennessee | TN | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 6833174 | 1876 | 0 | 1579 | weekly | |
34972 | 34972 | United States | Texas | TX | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 28995881 | 4984 | 952 | 4304 | weekly | |
35280 | 35280 | United States | Utah | UT | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 3205958 | 448 | 45 | 405 | weekly | |
35588 | 35588 | United States | Vermont | VT | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 623989 | 132 | 12 | 113 | weekly | |
35896 | 35896 | United States | Virginia | VA | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 8535519 | 1611 | 419 | 1473 | weekly | |
36204 | 36204 | United States | Washington | WA | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 7614893 | 1306 | 194 | 1257 | weekly | |
36512 | 36512 | United States | West Virginia | WV | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 1792147 | 531 | 132 | 485 | weekly | |
36820 | 36820 | United States | Wisconsin | WI | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 5822434 | 1163 | 214 | 1111 | weekly | |
37128 | 37128 | United States | Wyoming | WY | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 578759 | 102 | 23 | 100 | weekly | |
37436 | 37436 | United States | United States | USA | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 328300544 | 64424 | 10191 | 59774 | 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]);