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-25
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21631 | 21631 | United States | Alabama | AL | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 4903185 | 1139 | 102 | 1047 | weekly | |
21939 | 21939 | United States | Alaska | AK | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 731545 | 61 | 0 | 83 | weekly | |
22247 | 22247 | United States | Arizona | AZ | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 7278717 | 1384 | 96 | 1270 | weekly | |
22555 | 22555 | United States | Arkansas | AR | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 3017825 | 615 | 10 | 642 | weekly | |
22863 | 22863 | United States | California | CA | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 39512223 | 5938 | 548 | 5516 | weekly | |
23171 | 23171 | United States | Colorado | CO | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 5758736 | 1067 | 259 | 818 | weekly | |
23479 | 23479 | United States | Connecticut | CT | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 3565287 | 1338 | 775 | 627 | weekly | |
23787 | 23787 | United States | Delaware | DE | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 973764 | 285 | 45 | 187 | weekly | |
24095 | 24095 | United States | District of Columbia | DC | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 705749 | 242 | 74 | 138 | weekly | |
24403 | 24403 | United States | Florida | FL | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 21477737 | 4555 | 304 | 4287 | weekly | |
24711 | 24711 | United States | Georgia | GA | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 10617423 | 2040 | 229 | 1714 | weekly | |
25019 | 25019 | United States | Hawaii | HI | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 1415872 | 200 | 0 | 220 | weekly | |
25327 | 25327 | United States | Idaho | ID | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 1787065 | 262 | 12 | 290 | weekly | |
25635 | 25635 | United States | Illinois | IL | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 12671821 | 3010 | 616 | 2073 | weekly | |
25943 | 25943 | United States | Indiana | IN | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 6732219 | 1597 | 227 | 1337 | weekly | |
26251 | 26251 | United States | Iowa | IA | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 3155070 | 587 | 38 | 589 | weekly | |
26559 | 26559 | United States | Kansas | KS | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 2913314 | 541 | 33 | 497 | weekly | |
26867 | 26867 | United States | Kentucky | KY | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 4467673 | 975 | 61 | 990 | weekly | |
27175 | 27175 | United States | Louisiana | LA | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 4648794 | 1248 | 375 | 894 | weekly | |
27483 | 27483 | United States | Maine | ME | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 1344212 | 285 | 18 | 301 | weekly | |
27791 | 27791 | United States | Maryland | MD | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 6045680 | 1538 | 321 | 1025 | weekly | |
28099 | 28099 | United States | Massachusetts | MA | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 6949503 | 2535 | 1170 | 1193 | weekly | |
28407 | 28407 | United States | Michigan | MI | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 9986857 | 2806 | 966 | 1896 | weekly | |
28715 | 28715 | United States | Minnesota | MN | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 5639632 | 1016 | 122 | 868 | weekly | |
29023 | 29023 | United States | Mississippi | MS | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 2976149 | 750 | 69 | 614 | weekly | |
29331 | 29331 | United States | Missouri | MO | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 6137428 | 1448 | 98 | 1251 | weekly | |
29639 | 29639 | United States | Montana | MT | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 1068778 | 187 | 4 | 215 | weekly | |
29947 | 29947 | United States | Nebraska | NE | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 1934408 | 353 | 0 | 327 | weekly | |
30255 | 30255 | United States | Nevada | NV | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 3080156 | 565 | 48 | 558 | weekly | |
30563 | 30563 | United States | New Hampshire | NH | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 1359711 | 274 | 22 | 253 | weekly | |
30871 | 30871 | United States | New Jersey | NJ | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 8882190 | 3979 | 1795 | 1464 | weekly | |
31179 | 31179 | United States | New Mexico | NM | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 2096829 | 407 | 40 | 377 | weekly | |
31487 | 31487 | United States | New York | NY | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 19453561 | 7791 | 5240 | 3018 | weekly | |
31795 | 31795 | United States | North Carolina | NC | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 10488084 | 2104 | 125 | 1922 | weekly | |
32103 | 32103 | United States | North Dakota | ND | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 762062 | 158 | 7 | 140 | weekly | |
32411 | 32411 | United States | Ohio | OH | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 11689100 | 2835 | 258 | 2517 | weekly | |
32719 | 32719 | United States | Oklahoma | OK | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 3956971 | 780 | 47 | 765 | weekly | |
33027 | 33027 | United States | Oregon | OR | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 4217737 | 770 | 15 | 742 | weekly | |
33335 | 33335 | United States | Pennsylvania | PA | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 12801989 | 3823 | 700 | 2725 | weekly | |
33643 | 33643 | United States | Rhode Island | RI | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 1059361 | 297 | 78 | 200 | weekly | |
33951 | 33951 | United States | South Carolina | SC | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 5148714 | 1023 | 47 | 983 | weekly | |
34259 | 34259 | United States | South Dakota | SD | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 884659 | 176 | 3 | 164 | weekly | |
34567 | 34567 | United States | Tennessee | TN | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 6833174 | 1483 | 26 | 1492 | weekly | |
34875 | 34875 | United States | Texas | TX | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 28995881 | 4464 | 230 | 4066 | weekly | |
35183 | 35183 | United States | Utah | UT | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 3205958 | 410 | 16 | 395 | weekly | |
35491 | 35491 | United States | Vermont | VT | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 623989 | 124 | 9 | 115 | weekly | |
35799 | 35799 | United States | Virginia | VA | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 8535519 | 1633 | 179 | 1384 | weekly | |
36107 | 36107 | United States | Washington | WA | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 7614893 | 1231 | 114 | 1150 | weekly | |
36415 | 36415 | United States | West Virginia | WV | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 1792147 | 460 | 15 | 437 | weekly | |
36723 | 36723 | United States | Wisconsin | WI | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 5822434 | 1026 | 50 | 1043 | weekly | |
37031 | 37031 | United States | Wyoming | WY | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 578759 | 98 | 5 | 81 | weekly | |
37339 | 37339 | United States | United States | USA | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 328300544 | 73913 | 15641 | 56900 | 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]);