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-06-18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21743 | 21743 | United States | Alabama | AL | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 4903185 | 1078 | 4 | 1017 | weekly | |
22051 | 22051 | United States | Alaska | AK | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 731545 | 107 | 0 | 87 | weekly | |
22359 | 22359 | United States | Arizona | AZ | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 7278717 | 1440 | 0 | 1225 | weekly | |
22667 | 22667 | United States | Arkansas | AR | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 3017825 | 649 | 21 | 604 | weekly | |
22975 | 22975 | United States | California | CA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 39512223 | 5445 | 396 | 5006 | weekly | |
23283 | 23283 | United States | Colorado | CO | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 5758736 | 851 | 159 | 753 | weekly | |
23591 | 23591 | United States | Connecticut | CT | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 3565287 | 607 | 15 | 589 | weekly | |
23899 | 23899 | United States | Delaware | DE | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 973764 | 206 | 7 | 175 | weekly | |
24207 | 24207 | United States | District of Columbia | DC | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 705749 | 132 | 1 | 101 | weekly | |
24515 | 24515 | United States | Florida | FL | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 21477737 | 4445 | 545 | 4051 | weekly | |
24823 | 24823 | United States | Georgia | GA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 10617423 | 1818 | 70 | 1643 | weekly | |
25131 | 25131 | United States | Hawaii | HI | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1415872 | 243 | 9 | 236 | weekly | |
25439 | 25439 | United States | Idaho | ID | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1787065 | 293 | 3 | 283 | weekly | |
25747 | 25747 | United States | Illinois | IL | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 12671821 | 2113 | 249 | 1913 | weekly | |
26055 | 26055 | United States | Indiana | IN | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 6732219 | 1267 | 28 | 1218 | weekly | |
26363 | 26363 | United States | Iowa | IA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 3155070 | 608 | 0 | 557 | weekly | |
26671 | 26671 | United States | Kansas | KS | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 2913314 | 529 | -3 | 492 | weekly | |
26979 | 26979 | United States | Kentucky | KY | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 4467673 | 1034 | 59 | 894 | weekly | |
27287 | 27287 | United States | Louisiana | LA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 4648794 | 904 | 17 | 871 | weekly | |
27595 | 27595 | United States | Maine | ME | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1344212 | 318 | 5 | 281 | weekly | |
27903 | 27903 | United States | Maryland | MD | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 6045680 | 995 | 51 | 930 | weekly | |
28211 | 28211 | United States | Massachusetts | MA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 6949503 | 1094 | 83 | 1092 | weekly | |
28519 | 28519 | United States | Michigan | MI | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 9986857 | 1934 | 137 | 1804 | weekly | |
28827 | 28827 | United States | Minnesota | MN | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 5639632 | 892 | 31 | 860 | weekly | |
29135 | 29135 | United States | Mississippi | MS | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 2976149 | 603 | 10 | 609 | weekly | |
29443 | 29443 | United States | Missouri | MO | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 6137428 | 1305 | 0 | 1228 | weekly | |
29751 | 29751 | United States | Montana | MT | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1068778 | 197 | 6 | 191 | weekly | |
30059 | 30059 | United States | Nebraska | NE | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1934408 | 286 | 7 | 318 | weekly | |
30367 | 30367 | United States | Nevada | NV | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 3080156 | 602 | 32 | 515 | weekly | |
30675 | 30675 | United States | New Hampshire | NH | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1359711 | 274 | 8 | 232 | weekly | |
30983 | 30983 | United States | New Jersey | NJ | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 8882190 | 1439 | 75 | 1374 | weekly | |
31291 | 31291 | United States | New Mexico | NM | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 2096829 | 387 | 10 | 369 | weekly | |
31599 | 31599 | United States | New York | NY | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 19453561 | 2979 | 165 | 2842 | weekly | |
31907 | 31907 | United States | North Carolina | NC | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 10488084 | 1961 | 46 | 1855 | weekly | |
32215 | 32215 | United States | North Dakota | ND | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 762062 | 114 | 0 | 139 | weekly | |
32523 | 32523 | United States | Ohio | OH | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 11689100 | 2327 | 0 | 2295 | weekly | |
32831 | 32831 | United States | Oklahoma | OK | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 3956971 | 816 | 0 | 733 | weekly | |
33139 | 33139 | United States | Oregon | OR | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 4217737 | 803 | 34 | 685 | weekly | |
33447 | 33447 | United States | Pennsylvania | PA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 12801989 | 2551 | 139 | 2391 | weekly | |
33755 | 33755 | United States | Rhode Island | RI | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1059361 | 193 | 6 | 203 | weekly | |
34063 | 34063 | United States | South Carolina | SC | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 5148714 | 1019 | 0 | 982 | weekly | |
34371 | 34371 | United States | South Dakota | SD | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 884659 | 138 | 3 | 155 | weekly | |
34679 | 34679 | United States | Tennessee | TN | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 6833174 | 1633 | 77 | 1459 | weekly | |
34987 | 34987 | United States | Texas | TX | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 28995881 | 4366 | 103 | 3943 | weekly | |
35295 | 35295 | United States | Utah | UT | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 3205958 | 444 | 13 | 382 | weekly | |
35603 | 35603 | United States | Vermont | VT | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 623989 | 112 | 6 | 99 | weekly | |
35911 | 35911 | United States | Virginia | VA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 8535519 | 1381 | 12 | 1337 | weekly | |
36219 | 36219 | United States | Washington | WA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 7614893 | 1234 | 69 | 1127 | weekly | |
36527 | 36527 | United States | West Virginia | WV | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1792147 | 519 | 18 | 430 | weekly | |
36835 | 36835 | United States | Wisconsin | WI | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 5822434 | 1038 | 64 | 1018 | weekly | |
37143 | 37143 | United States | Wyoming | WY | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 578759 | 104 | 0 | 91 | weekly | |
37451 | 37451 | United States | United States | USA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 328300544 | 57827 | 2790 | 53684 | 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]);