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 2021-10-09
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21707 | 21707 | United States | Alabama | AL | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 4903185 | 1371 | 363 | 1025 | weekly | |
22015 | 22015 | United States | Alaska | AK | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 731545 | 150 | 16 | 86 | weekly | |
22323 | 22323 | United States | Arizona | AZ | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 7278717 | 1559 | 280 | 1147 | weekly | |
22631 | 22631 | United States | Arkansas | AR | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 3017825 | 830 | 92 | 629 | weekly | |
22939 | 22939 | United States | California | CA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 39512223 | 6098 | 699 | 5057 | weekly | |
23247 | 23247 | United States | Colorado | CO | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 5758736 | 991 | 139 | 782 | weekly | |
23555 | 23555 | United States | Connecticut | CT | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 3565287 | 627 | 17 | 621 | weekly | |
23863 | 23863 | United States | Delaware | DE | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 973764 | 205 | 23 | 197 | weekly | |
24171 | 24171 | United States | District of Columbia | DC | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 705749 | 158 | 6 | 126 | weekly | |
24479 | 24479 | United States | Florida | FL | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 21477737 | 5104 | 794 | 4106 | weekly | |
24787 | 24787 | United States | Georgia | GA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 10617423 | 2210 | 900 | 1670 | weekly | |
25095 | 25095 | United States | Hawaii | HI | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1415872 | 272 | 37 | 234 | weekly | |
25403 | 25403 | United States | Idaho | ID | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1787065 | 499 | 186 | 288 | weekly | |
25711 | 25711 | United States | Illinois | IL | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 12671821 | 2332 | 253 | 2097 | weekly | |
26019 | 26019 | United States | Indiana | IN | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 6732219 | 1627 | 296 | 1318 | weekly | |
26327 | 26327 | United States | Iowa | IA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 3155070 | 721 | 88 | 609 | weekly | |
26635 | 26635 | United States | Kansas | KS | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 2913314 | 582 | 60 | 520 | weekly | |
26943 | 26943 | United States | Kentucky | KY | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 4467673 | 1290 | 249 | 939 | weekly | |
27251 | 27251 | United States | Louisiana | LA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 4648794 | 1101 | 185 | 907 | weekly | |
27559 | 27559 | United States | Maine | ME | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1344212 | 363 | 49 | 293 | weekly | |
27867 | 27867 | United States | Maryland | MD | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 6045680 | 1166 | 108 | 1012 | weekly | |
28175 | 28175 | United States | Massachusetts | MA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 6949503 | 1191 | 99 | 1178 | weekly | |
28483 | 28483 | United States | Michigan | MI | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 9986857 | 2161 | 263 | 1923 | weekly | |
28791 | 28791 | United States | Minnesota | MN | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 5639632 | 1047 | 125 | 921 | weekly | |
29099 | 29099 | United States | Mississippi | MS | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 2976149 | 670 | 165 | 612 | weekly | |
29407 | 29407 | United States | Missouri | MO | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 6137428 | 1411 | 171 | 1308 | weekly | |
29715 | 29715 | United States | Montana | MT | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1068778 | 346 | 62 | 189 | weekly | |
30023 | 30023 | United States | Nebraska | NE | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1934408 | 399 | 15 | 349 | weekly | |
30331 | 30331 | United States | Nevada | NV | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 3080156 | 677 | 119 | 497 | weekly | |
30639 | 30639 | United States | New Hampshire | NH | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1359711 | 277 | 16 | 266 | weekly | |
30947 | 30947 | United States | New Jersey | NJ | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 8882190 | 1594 | 0 | 1504 | weekly | |
31255 | 31255 | United States | New Mexico | NM | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 2096829 | 470 | 57 | 364 | weekly | |
31563 | 31563 | United States | New York | NY | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 19453561 | 3423 | 217 | 3034 | weekly | |
31871 | 31871 | United States | North Carolina | NC | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 10488084 | 2450 | 499 | 1892 | weekly | |
32179 | 32179 | United States | North Dakota | ND | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 762062 | 178 | 24 | 146 | weekly | |
32487 | 32487 | United States | Ohio | OH | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 11689100 | 3152 | 546 | 2486 | weekly | |
32795 | 32795 | United States | Oklahoma | OK | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 3956971 | 982 | 163 | 767 | weekly | |
33103 | 33103 | United States | Oregon | OR | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 4217737 | 981 | 167 | 690 | weekly | |
33411 | 33411 | United States | Pennsylvania | PA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 12801989 | 3130 | 419 | 2657 | weekly | |
33719 | 33719 | United States | Rhode Island | RI | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1059361 | 220 | 16 | 212 | weekly | |
34027 | 34027 | United States | South Carolina | SC | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 5148714 | 1379 | 359 | 997 | weekly | |
34335 | 34335 | United States | South Dakota | SD | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 884659 | 176 | 34 | 156 | weekly | |
34643 | 34643 | United States | Tennessee | TN | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 6833174 | 2085 | 353 | 1491 | weekly | |
34951 | 34951 | United States | Texas | TX | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 28995881 | 5505 | 636 | 4053 | weekly | |
35259 | 35259 | United States | Utah | UT | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 3205958 | 489 | 51 | 369 | weekly | |
35567 | 35567 | United States | Vermont | VT | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 623989 | 132 | 14 | 110 | weekly | |
35875 | 35875 | United States | Virginia | VA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 8535519 | 1854 | 269 | 1390 | weekly | |
36183 | 36183 | United States | Washington | WA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 7614893 | 1431 | 257 | 1122 | weekly | |
36491 | 36491 | United States | West Virginia | WV | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1792147 | 662 | 144 | 453 | weekly | |
36799 | 36799 | United States | Wisconsin | WI | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 5822434 | 1272 | 119 | 1069 | weekly | |
37107 | 37107 | United States | Wyoming | WY | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 578759 | 160 | 45 | 94 | weekly | |
37415 | 37415 | United States | United States | USA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 328300544 | 69160 | 10264 | 55962 | 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]);