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 2020-04-04
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21628 | 21628 | United States | Alabama | AL | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 4903185 | 1156 | 23 | 1077 | weekly | |
21936 | 21936 | United States | Alaska | AK | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 731545 | 98 | 3 | 83 | weekly | |
22244 | 22244 | United States | Arizona | AZ | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 7278717 | 1357 | 37 | 1301 | weekly | |
22552 | 22552 | United States | Arkansas | AR | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 3017825 | 606 | 8 | 657 | weekly | |
22860 | 22860 | United States | California | CA | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 39512223 | 5986 | 272 | 5701 | weekly | |
23168 | 23168 | United States | Colorado | CO | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 5758736 | 967 | 82 | 835 | weekly | |
23476 | 23476 | United States | Connecticut | CT | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 3565287 | 891 | 132 | 650 | weekly | |
23784 | 23784 | United States | Delaware | DE | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 973764 | 214 | 9 | 193 | weekly | |
24092 | 24092 | United States | District of Columbia | DC | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 705749 | 156 | 16 | 142 | weekly | |
24400 | 24400 | United States | Florida | FL | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 21477737 | 4497 | 139 | 3925 | weekly | |
24708 | 24708 | United States | Georgia | GA | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 10617423 | 2033 | 129 | 1763 | weekly | |
25016 | 25016 | United States | Hawaii | HI | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 1415872 | 235 | 3 | 223 | weekly | |
25324 | 25324 | United States | Idaho | ID | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 1787065 | 271 | 5 | 291 | weekly | |
25632 | 25632 | United States | Illinois | IL | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 12671821 | 2622 | 197 | 2145 | weekly | |
25940 | 25940 | United States | Indiana | IN | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 6732219 | 1581 | 138 | 1383 | weekly | |
26248 | 26248 | United States | Iowa | IA | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 3155070 | 608 | 8 | 605 | weekly | |
26556 | 26556 | United States | Kansas | KS | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 2913314 | 550 | 16 | 520 | weekly | |
26864 | 26864 | United States | Kentucky | KY | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 4467673 | 1048 | 30 | 1028 | weekly | |
27172 | 27172 | United States | Louisiana | LA | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 4648794 | 1390 | 271 | 916 | weekly | |
27480 | 27480 | United States | Maine | ME | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 1344212 | 300 | 9 | 308 | weekly | |
27788 | 27788 | United States | Maryland | MD | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 6045680 | 1191 | 43 | 1047 | weekly | |
28096 | 28096 | United States | Massachusetts | MA | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 6949503 | 1549 | 172 | 1238 | weekly | |
28404 | 28404 | United States | Michigan | MI | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 9986857 | 3117 | 436 | 1966 | weekly | |
28712 | 28712 | United States | Minnesota | MN | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 5639632 | 928 | 19 | 899 | weekly | |
29020 | 29020 | United States | Mississippi | MS | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 2976149 | 707 | 29 | 637 | weekly | |
29328 | 29328 | United States | Missouri | MO | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 6137428 | 1301 | 13 | 1300 | weekly | |
29636 | 29636 | United States | Montana | MT | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 1068778 | 177 | 4 | 216 | weekly | |
29944 | 29944 | United States | Nebraska | NE | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 1934408 | 310 | 4 | 337 | weekly | |
30252 | 30252 | United States | Nevada | NV | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 3080156 | 593 | 32 | 571 | weekly | |
30560 | 30560 | United States | New Hampshire | NH | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 1359711 | 248 | 6 | 261 | weekly | |
30868 | 30868 | United States | New Jersey | NJ | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 8882190 | 3484 | 697 | 1523 | weekly | |
31176 | 31176 | United States | New Mexico | NM | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 2096829 | 399 | 9 | 385 | weekly | |
31484 | 31484 | United States | New York | NY | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 19453561 | 10070 | 3532 | 3131 | weekly | |
31792 | 31792 | United States | North Carolina | NC | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 10488084 | 2024 | 20 | 2011 | weekly | |
32100 | 32100 | United States | North Dakota | ND | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 762062 | 140 | 2 | 143 | weekly | |
32408 | 32408 | United States | Ohio | OH | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 11689100 | 2571 | 77 | 2616 | weekly | |
32716 | 32716 | United States | Oklahoma | OK | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 3956971 | 784 | 42 | 794 | weekly | |
33024 | 33024 | United States | Oregon | OR | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 4217737 | 778 | 13 | 756 | weekly | |
33332 | 33332 | United States | Pennsylvania | PA | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 12801989 | 3003 | 102 | 2840 | weekly | |
33640 | 33640 | United States | Rhode Island | RI | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 1059361 | 236 | 13 | 211 | weekly | |
33948 | 33948 | United States | South Carolina | SC | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 5148714 | 1048 | 25 | 1013 | weekly | |
34256 | 34256 | United States | South Dakota | SD | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 884659 | 170 | 1 | 171 | weekly | |
34564 | 34564 | United States | Tennessee | TN | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 6833174 | 1593 | 34 | 1533 | weekly | |
34872 | 34872 | United States | Texas | TX | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 28995881 | 4186 | 127 | 4177 | weekly | |
35180 | 35180 | United States | Utah | UT | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 3205958 | 408 | 5 | 401 | weekly | |
35488 | 35488 | United States | Vermont | VT | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 623989 | 135 | 4 | 119 | weekly | |
35796 | 35796 | United States | Virginia | VA | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 8535519 | 1467 | 32 | 1427 | weekly | |
36104 | 36104 | United States | Washington | WA | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 7614893 | 1305 | 126 | 1166 | weekly | |
36412 | 36412 | United States | West Virginia | WV | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 1792147 | 467 | 2 | 450 | weekly | |
36720 | 36720 | United States | Wisconsin | WI | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 5822434 | 1221 | 80 | 1076 | weekly | |
37028 | 37028 | United States | Wyoming | WY | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 578759 | 123 | 0 | 81 | weekly | |
37336 | 37336 | United States | United States | USA | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 328300544 | 72299 | 7228 | 58242 | 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]);