economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where "start_date" is on date 2017-02-19 sorted by expected_deaths descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_date (date)
Link | rowid | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths ▲ | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27010 | 27010 | United States | Louisiana | LA | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 4648794 | 962 | 0 | 970 | weekly | |
27626 | 27626 | United States | Maryland | MD | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 6045680 | 1075 | 0 | 970 | weekly | |
33786 | 33786 | United States | South Carolina | SC | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 5148714 | 964 | 0 | 962 | weekly | |
26702 | 26702 | United States | Kentucky | KY | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 4467673 | 1033 | 0 | 929 | weekly | |
36866 | 36866 | United States | Wyoming | WY | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 578759 | 83 | 0 | 88 | weekly | |
28550 | 28550 | United States | Minnesota | MN | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 5639632 | 880 | 0 | 842 | weekly | |
32554 | 32554 | United States | Oklahoma | OK | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 3956971 | 857 | 0 | 802 | weekly | |
21774 | 21774 | United States | Alaska | AK | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 731545 | 73 | 0 | 78 | weekly | |
23006 | 23006 | United States | Colorado | CO | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 5758736 | 822 | 0 | 751 | weekly | |
32862 | 32862 | United States | Oregon | OR | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 4217737 | 700 | 0 | 713 | weekly | |
22390 | 22390 | United States | Arkansas | AR | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 3017825 | 657 | 0 | 633 | weekly | |
28858 | 28858 | United States | Mississippi | MS | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 2976149 | 649 | 0 | 631 | weekly | |
23314 | 23314 | United States | Connecticut | CT | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 3565287 | 678 | 0 | 619 | weekly | |
26086 | 26086 | United States | Iowa | IA | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 3155070 | 603 | 0 | 595 | weekly | |
37174 | 37174 | United States | United States | USA | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 328300544 | 58386 | 0 | 54924 | weekly | |
26394 | 26394 | United States | Kansas | KS | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 2913314 | 585 | 0 | 521 | weekly | |
22698 | 22698 | United States | California | CA | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 39512223 | 5347 | 0 | 5205 | weekly | |
30090 | 30090 | United States | Nevada | NV | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 3080156 | 511 | 0 | 486 | weekly | |
36250 | 36250 | United States | West Virginia | WV | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 1792147 | 466 | 0 | 431 | weekly | |
34710 | 34710 | United States | Texas | TX | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 28995881 | 4157 | 0 | 4067 | weekly | |
24238 | 24238 | United States | Florida | FL | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 21477737 | 4354 | 0 | 3711 | weekly | |
35018 | 35018 | United States | Utah | UT | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 3205958 | 391 | 0 | 369 | weekly | |
31014 | 31014 | United States | New Mexico | NM | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 2096829 | 395 | 0 | 361 | weekly | |
29782 | 29782 | United States | Nebraska | NE | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 1934408 | 348 | 0 | 332 | weekly | |
31322 | 31322 | United States | New York | NY | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 19453561 | 3139 | 0 | 3030 | weekly | |
27318 | 27318 | United States | Maine | ME | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 1344212 | 295 | 0 | 275 | weekly | |
33170 | 33170 | United States | Pennsylvania | PA | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 12801989 | 2889 | 0 | 2669 | weekly | |
25162 | 25162 | United States | Idaho | ID | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 1787065 | 291 | 0 | 261 | weekly | |
24854 | 24854 | United States | Hawaii | HI | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 1415872 | 220 | 0 | 243 | weekly | |
32246 | 32246 | United States | Ohio | OH | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 11689100 | 2588 | 0 | 2326 | weekly | |
30398 | 30398 | United States | New Hampshire | NH | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 1359711 | 250 | 0 | 232 | weekly | |
33478 | 33478 | United States | Rhode Island | RI | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 1059361 | 209 | 0 | 211 | weekly | |
25470 | 25470 | United States | Illinois | IL | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 12671821 | 2225 | 0 | 2068 | weekly | |
29474 | 29474 | United States | Montana | MT | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 1068778 | 246 | 0 | 199 | weekly | |
28242 | 28242 | United States | Michigan | MI | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 9986857 | 1997 | 0 | 1908 | weekly | |
31630 | 31630 | United States | North Carolina | NC | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 10488084 | 2004 | 0 | 1842 | weekly | |
23622 | 23622 | United States | Delaware | DE | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 973764 | 178 | 0 | 171 | weekly | |
24546 | 24546 | United States | Georgia | GA | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 10617423 | 1711 | 0 | 1691 | weekly | |
34094 | 34094 | United States | South Dakota | SD | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 884659 | 175 | 0 | 152 | weekly | |
30706 | 30706 | United States | New Jersey | NJ | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 8882190 | 1581 | 0 | 1453 | weekly | |
34402 | 34402 | United States | Tennessee | TN | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 6833174 | 1478 | 0 | 1447 | weekly | |
31938 | 31938 | United States | North Dakota | ND | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 762062 | 151 | 0 | 140 | weekly | |
35634 | 35634 | United States | Virginia | VA | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 8535519 | 1432 | 0 | 1312 | weekly | |
25778 | 25778 | United States | Indiana | IN | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 6732219 | 1425 | 0 | 1281 | weekly | |
29166 | 29166 | United States | Missouri | MO | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 6137428 | 1347 | 0 | 1257 | weekly | |
27934 | 27934 | United States | Massachusetts | MA | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 6949503 | 1302 | 0 | 1183 | weekly | |
22082 | 22082 | United States | Arizona | AZ | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 7278717 | 1125 | 0 | 1150 | weekly | |
35326 | 35326 | United States | Vermont | VT | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 623989 | 118 | 0 | 113 | weekly | |
35942 | 35942 | United States | Washington | WA | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 7614893 | 1172 | 0 | 1084 | weekly | |
23930 | 23930 | United States | District of Columbia | DC | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 705749 | 125 | 0 | 108 | weekly | |
21466 | 21466 | United States | Alabama | AL | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 4903185 | 1099 | 0 | 1031 | weekly | |
36558 | 36558 | United States | Wisconsin | WI | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 5822434 | 1024 | 0 | 1021 | 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]);