economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "United States" and "end_date" is on date 2019-11-30 sorted by week
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21610 | 21610 | United States | Alabama | AL | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 4903185 | 1038 | 0 | 1089 | weekly | |
21918 | 21918 | United States | Alaska | AK | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 731545 | 103 | 0 | 95 | weekly | |
22226 | 22226 | United States | Arizona | AZ | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 7278717 | 1119 | 0 | 1227 | weekly | |
22534 | 22534 | United States | Arkansas | AR | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 3017825 | 664 | 0 | 651 | weekly | |
22842 | 22842 | United States | California | CA | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 39512223 | 5181 | 0 | 5649 | weekly | |
23150 | 23150 | United States | Colorado | CO | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 5758736 | 739 | 0 | 848 | weekly | |
23458 | 23458 | United States | Connecticut | CT | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 3565287 | 657 | 0 | 628 | weekly | |
23766 | 23766 | United States | Delaware | DE | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 973764 | 180 | 0 | 199 | weekly | |
24074 | 24074 | United States | District of Columbia | DC | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 705749 | 119 | 0 | 142 | weekly | |
24382 | 24382 | United States | Florida | FL | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 21477737 | 4045 | 0 | 4235 | weekly | |
24690 | 24690 | United States | Georgia | GA | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 10617423 | 1732 | 0 | 1781 | weekly | |
24998 | 24998 | United States | Hawaii | HI | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 1415872 | 214 | 0 | 214 | weekly | |
25306 | 25306 | United States | Idaho | ID | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 1787065 | 267 | 0 | 291 | weekly | |
25614 | 25614 | United States | Illinois | IL | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 12671821 | 2091 | 0 | 2184 | weekly | |
25922 | 25922 | United States | Indiana | IN | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 6732219 | 1321 | 0 | 1397 | weekly | |
26230 | 26230 | United States | Iowa | IA | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 3155070 | 553 | 0 | 612 | weekly | |
26538 | 26538 | United States | Kansas | KS | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 2913314 | 461 | 0 | 544 | weekly | |
26846 | 26846 | United States | Kentucky | KY | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 4467673 | 931 | 0 | 1054 | weekly | |
27154 | 27154 | United States | Louisiana | LA | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 4648794 | 896 | 0 | 881 | weekly | |
27462 | 27462 | United States | Maine | ME | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 1344212 | 273 | 0 | 303 | weekly | |
27770 | 27770 | United States | Maryland | MD | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 6045680 | 1023 | 0 | 1058 | weekly | |
28078 | 28078 | United States | Massachusetts | MA | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 6949503 | 1204 | 0 | 1191 | weekly | |
28386 | 28386 | United States | Michigan | MI | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 9986857 | 1924 | 0 | 1973 | weekly | |
28694 | 28694 | United States | Minnesota | MN | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 5639632 | 870 | 0 | 929 | weekly | |
29002 | 29002 | United States | Mississippi | MS | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 2976149 | 597 | 0 | 629 | weekly | |
29310 | 29310 | United States | Missouri | MO | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 6137428 | 1255 | 0 | 1318 | weekly | |
29618 | 29618 | United States | Montana | MT | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 1068778 | 196 | 0 | 216 | weekly | |
29926 | 29926 | United States | Nebraska | NE | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 1934408 | 300 | 0 | 342 | weekly | |
30234 | 30234 | United States | Nevada | NV | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 3080156 | 501 | 0 | 558 | weekly | |
30542 | 30542 | United States | New Hampshire | NH | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 1359711 | 237 | 0 | 258 | weekly | |
30850 | 30850 | United States | New Jersey | NJ | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 8882190 | 1430 | 0 | 1481 | weekly | |
31158 | 31158 | United States | New Mexico | NM | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 2096829 | 408 | 0 | 375 | weekly | |
31466 | 31466 | United States | New York | NY | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 19453561 | 2981 | 0 | 3089 | weekly | |
31774 | 31774 | United States | North Carolina | NC | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 10488084 | 1814 | 0 | 2004 | weekly | |
32082 | 32082 | United States | North Dakota | ND | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 762062 | 147 | 0 | 138 | weekly | |
32390 | 32390 | United States | Ohio | OH | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 11689100 | 2403 | 0 | 2623 | weekly | |
32698 | 32698 | United States | Oklahoma | OK | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 3956971 | 767 | 0 | 785 | weekly | |
33006 | 33006 | United States | Oregon | OR | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 4217737 | 737 | 0 | 769 | weekly | |
33314 | 33314 | United States | Pennsylvania | PA | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 12801989 | 2669 | 0 | 2830 | weekly | |
33622 | 33622 | United States | Rhode Island | RI | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 1059361 | 211 | 0 | 207 | weekly | |
33930 | 33930 | United States | South Carolina | SC | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 5148714 | 1010 | 0 | 1010 | weekly | |
34238 | 34238 | United States | South Dakota | SD | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 884659 | 146 | 0 | 178 | weekly | |
34546 | 34546 | United States | Tennessee | TN | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 6833174 | 1460 | 0 | 1534 | weekly | |
34854 | 34854 | United States | Texas | TX | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 28995881 | 4126 | 0 | 4121 | weekly | |
35162 | 35162 | United States | Utah | UT | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 3205958 | 388 | 0 | 398 | weekly | |
35470 | 35470 | United States | Vermont | VT | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 623989 | 114 | 0 | 120 | weekly | |
35778 | 35778 | United States | Virginia | VA | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 8535519 | 1447 | 0 | 1412 | weekly | |
36086 | 36086 | United States | Washington | WA | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 7614893 | 1090 | 0 | 1185 | weekly | |
36394 | 36394 | United States | West Virginia | WV | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 1792147 | 418 | 0 | 460 | weekly | |
36702 | 36702 | United States | Wisconsin | WI | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 5822434 | 1041 | 0 | 1082 | weekly | |
37010 | 37010 | United States | Wyoming | WY | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 578759 | 110 | 0 | 85 | weekly | |
37318 | 37318 | United States | United States | USA | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 328300544 | 55608 | 0 | 58382 | 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]);