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 2018-02-10 sorted by year
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21516 | 21516 | United States | Alabama | AL | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 4903185 | 1181 | 0 | 1104 | weekly | |
21824 | 21824 | United States | Alaska | AK | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 731545 | 65 | 0 | 88 | weekly | |
22132 | 22132 | United States | Arizona | AZ | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 7278717 | 1309 | 0 | 1219 | weekly | |
22440 | 22440 | United States | Arkansas | AR | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 3017825 | 680 | 0 | 674 | weekly | |
22748 | 22748 | United States | California | CA | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 39512223 | 5567 | 0 | 5666 | weekly | |
23056 | 23056 | United States | Colorado | CO | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 5758736 | 822 | 0 | 834 | weekly | |
23364 | 23364 | United States | Connecticut | CT | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 3565287 | 671 | 0 | 680 | weekly | |
23672 | 23672 | United States | Delaware | DE | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 973764 | 184 | 0 | 195 | weekly | |
23980 | 23980 | United States | District of Columbia | DC | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 705749 | 145 | 0 | 121 | weekly | |
24288 | 24288 | United States | Florida | FL | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 21477737 | 4658 | 0 | 3833 | weekly | |
24596 | 24596 | United States | Georgia | GA | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 10617423 | 1945 | 0 | 1567 | weekly | |
24904 | 24904 | United States | Hawaii | HI | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 1415872 | 207 | 0 | 246 | weekly | |
25212 | 25212 | United States | Idaho | ID | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 1787065 | 285 | 0 | 283 | weekly | |
25520 | 25520 | United States | Illinois | IL | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 12671821 | 2256 | 0 | 2238 | weekly | |
25828 | 25828 | United States | Indiana | IN | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 6732219 | 1475 | 0 | 1366 | weekly | |
26136 | 26136 | United States | Iowa | IA | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 3155070 | 649 | 0 | 646 | weekly | |
26444 | 26444 | United States | Kansas | KS | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 2913314 | 539 | 0 | 581 | weekly | |
26752 | 26752 | United States | Kentucky | KY | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 4467673 | 1039 | 0 | 1011 | weekly | |
27060 | 27060 | United States | Louisiana | LA | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 4648794 | 1039 | 0 | 975 | weekly | |
27368 | 27368 | United States | Maine | ME | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 1344212 | 300 | 0 | 324 | weekly | |
27676 | 27676 | United States | Maryland | MD | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 6045680 | 1056 | 0 | 1045 | weekly | |
27984 | 27984 | United States | Massachusetts | MA | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 6949503 | 1287 | 0 | 1355 | weekly | |
28292 | 28292 | United States | Michigan | MI | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 9986857 | 2091 | 0 | 2089 | weekly | |
28600 | 28600 | United States | Minnesota | MN | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 5639632 | 894 | 0 | 922 | weekly | |
28908 | 28908 | United States | Mississippi | MS | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 2976149 | 710 | 0 | 691 | weekly | |
29216 | 29216 | United States | Missouri | MO | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 6137428 | 1437 | 0 | 1247 | weekly | |
29524 | 29524 | United States | Montana | MT | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 1068778 | 199 | 0 | 212 | weekly | |
29832 | 29832 | United States | Nebraska | NE | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 1934408 | 340 | 0 | 384 | weekly | |
30140 | 30140 | United States | Nevada | NV | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 3080156 | 531 | 0 | 461 | weekly | |
30448 | 30448 | United States | New Hampshire | NH | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 1359711 | 265 | 0 | 277 | weekly | |
30756 | 30756 | United States | New Jersey | NJ | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 8882190 | 1666 | 0 | 1542 | weekly | |
31064 | 31064 | United States | New Mexico | NM | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 2096829 | 399 | 0 | 381 | weekly | |
31372 | 31372 | United States | New York | NY | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 19453561 | 3417 | 0 | 3332 | weekly | |
31680 | 31680 | United States | North Carolina | NC | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 10488084 | 2096 | 0 | 2029 | weekly | |
31988 | 31988 | United States | North Dakota | ND | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 762062 | 133 | 0 | 148 | weekly | |
32296 | 32296 | United States | Ohio | OH | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 11689100 | 2647 | 0 | 2536 | weekly | |
32604 | 32604 | United States | Oklahoma | OK | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 3956971 | 869 | 0 | 868 | weekly | |
32912 | 32912 | United States | Oregon | OR | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 4217737 | 708 | 0 | 787 | weekly | |
33220 | 33220 | United States | Pennsylvania | PA | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 12801989 | 2929 | 0 | 2929 | weekly | |
33528 | 33528 | United States | Rhode Island | RI | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 1059361 | 219 | 0 | 237 | weekly | |
33836 | 33836 | United States | South Carolina | SC | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 5148714 | 1067 | 0 | 1051 | weekly | |
34144 | 34144 | United States | South Dakota | SD | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 884659 | 158 | 0 | 172 | weekly | |
34452 | 34452 | United States | Tennessee | TN | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 6833174 | 1700 | 0 | 1569 | weekly | |
34760 | 34760 | United States | Texas | TX | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 28995881 | 4457 | 0 | 4384 | weekly | |
35068 | 35068 | United States | Utah | UT | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 3205958 | 412 | 0 | 398 | weekly | |
35376 | 35376 | United States | Vermont | VT | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 623989 | 140 | 0 | 127 | weekly | |
35684 | 35684 | United States | Virginia | VA | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 8535519 | 1498 | 0 | 1420 | weekly | |
35992 | 35992 | United States | Washington | WA | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 7614893 | 1145 | 0 | 1189 | weekly | |
36300 | 36300 | United States | West Virginia | WV | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 1792147 | 499 | 0 | 473 | weekly | |
36608 | 36608 | United States | Wisconsin | WI | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 5822434 | 1176 | 0 | 1123 | weekly | |
36916 | 36916 | United States | Wyoming | WY | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 578759 | 86 | 0 | 99 | weekly | |
37224 | 37224 | United States | United States | USA | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 328300544 | 61247 | 0 | 59128 | 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]);