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-01-30
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21671 | 21671 | United States | Alabama | AL | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 4903185 | 1637 | 909 | 1145 | weekly | |
21979 | 21979 | United States | Alaska | AK | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 731545 | 92 | 8 | 88 | weekly | |
22287 | 22287 | United States | Arizona | AZ | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 7278717 | 2083 | 927 | 1406 | weekly | |
22595 | 22595 | United States | Arkansas | AR | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 3017825 | 873 | 275 | 701 | weekly | |
22903 | 22903 | United States | California | CA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 39512223 | 9597 | 3311 | 6061 | weekly | |
23211 | 23211 | United States | Colorado | CO | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 5758736 | 932 | 134 | 871 | weekly | |
23519 | 23519 | United States | Connecticut | CT | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 3565287 | 827 | 227 | 683 | weekly | |
23827 | 23827 | United States | Delaware | DE | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 973764 | 265 | 45 | 216 | weekly | |
24135 | 24135 | United States | District of Columbia | DC | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 705749 | 181 | 39 | 144 | weekly | |
24443 | 24443 | United States | Florida | FL | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 21477737 | 5491 | 1196 | 4656 | weekly | |
24751 | 24751 | United States | Georgia | GA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 10617423 | 2768 | 770 | 1833 | weekly | |
25059 | 25059 | United States | Hawaii | HI | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1415872 | 228 | 73 | 255 | weekly | |
25367 | 25367 | United States | Idaho | ID | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1787065 | 284 | 57 | 317 | weekly | |
25675 | 25675 | United States | Illinois | IL | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 12671821 | 2585 | 569 | 2308 | weekly | |
25983 | 25983 | United States | Indiana | IN | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 6732219 | 1624 | 275 | 1487 | weekly | |
26291 | 26291 | United States | Iowa | IA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 3155070 | 645 | 165 | 666 | weekly | |
26599 | 26599 | United States | Kansas | KS | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 2913314 | 691 | 181 | 581 | weekly | |
26907 | 26907 | United States | Kentucky | KY | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 4467673 | 1261 | 328 | 1070 | weekly | |
27215 | 27215 | United States | Louisiana | LA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 4648794 | 1253 | 318 | 988 | weekly | |
27523 | 27523 | United States | Maine | ME | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1344212 | 356 | 36 | 297 | weekly | |
27831 | 27831 | United States | Maryland | MD | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 6045680 | 1321 | 219 | 1131 | weekly | |
28139 | 28139 | United States | Massachusetts | MA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 6949503 | 1571 | 467 | 1285 | weekly | |
28447 | 28447 | United States | Michigan | MI | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 9986857 | 2191 | 347 | 2097 | weekly | |
28755 | 28755 | United States | Minnesota | MN | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 5639632 | 924 | 124 | 950 | weekly | |
29063 | 29063 | United States | Mississippi | MS | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 2976149 | 922 | 267 | 656 | weekly | |
29371 | 29371 | United States | Missouri | MO | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 6137428 | 1619 | 207 | 1436 | weekly | |
29679 | 29679 | United States | Montana | MT | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1068778 | 199 | 91 | 214 | weekly | |
29987 | 29987 | United States | Nebraska | NE | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1934408 | 378 | 36 | 358 | weekly | |
30295 | 30295 | United States | Nevada | NV | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 3080156 | 782 | 244 | 596 | weekly | |
30603 | 30603 | United States | New Hampshire | NH | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1359711 | 272 | 71 | 276 | weekly | |
30911 | 30911 | United States | New Jersey | NJ | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 8882190 | 2007 | 521 | 1666 | weekly | |
31219 | 31219 | United States | New Mexico | NM | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 2096829 | 485 | 150 | 415 | weekly | |
31527 | 31527 | United States | New York | NY | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 19453561 | 4443 | 1311 | 3302 | weekly | |
31835 | 31835 | United States | North Carolina | NC | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 10488084 | 2931 | 702 | 2106 | weekly | |
32143 | 32143 | United States | North Dakota | ND | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 762062 | 147 | 11 | 147 | weekly | |
32451 | 32451 | United States | Ohio | OH | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 11689100 | 3126 | 441 | 2752 | weekly | |
32759 | 32759 | United States | Oklahoma | OK | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 3956971 | 1171 | 365 | 866 | weekly | |
33067 | 33067 | United States | Oregon | OR | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 4217737 | 836 | 73 | 766 | weekly | |
33375 | 33375 | United States | Pennsylvania | PA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 12801989 | 3593 | 1076 | 2999 | weekly | |
33683 | 33683 | United States | Rhode Island | RI | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1059361 | 264 | 73 | 212 | weekly | |
33991 | 33991 | United States | South Carolina | SC | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 5148714 | 1582 | 535 | 1093 | weekly | |
34299 | 34299 | United States | South Dakota | SD | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 884659 | 204 | 79 | 167 | weekly | |
34607 | 34607 | United States | Tennessee | TN | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 6833174 | 2083 | 695 | 1641 | weekly | |
34915 | 34915 | United States | Texas | TX | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 28995881 | 6641 | 2115 | 4533 | weekly | |
35223 | 35223 | United States | Utah | UT | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 3205958 | 502 | 81 | 412 | weekly | |
35531 | 35531 | United States | Vermont | VT | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 623989 | 114 | 3 | 121 | weekly | |
35839 | 35839 | United States | Virginia | VA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 8535519 | 1957 | 374 | 1519 | weekly | |
36147 | 36147 | United States | Washington | WA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 7614893 | 1331 | 173 | 1233 | weekly | |
36455 | 36455 | United States | West Virginia | WV | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1792147 | 623 | 143 | 476 | weekly | |
36763 | 36763 | United States | Wisconsin | WI | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 5822434 | 1192 | 190 | 1155 | weekly | |
37071 | 37071 | United States | Wyoming | WY | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 578759 | 118 | 25 | 90 | weekly | |
37379 | 37379 | United States | United States | USA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 328300544 | 79202 | 21052 | 62443 | 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]);