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 2018-03-11 sorted by start_date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21521 | 21521 | United States | Alabama | AL | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 4903185 | 1086 | 0 | 1044 | weekly | |
21829 | 21829 | United States | Alaska | AK | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 731545 | 69 | 0 | 85 | weekly | |
22137 | 22137 | United States | Arizona | AZ | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 7278717 | 1196 | 0 | 1184 | weekly | |
22445 | 22445 | United States | Arkansas | AR | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 3017825 | 583 | 0 | 635 | weekly | |
22753 | 22753 | United States | California | CA | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 39512223 | 5686 | 0 | 5354 | weekly | |
23061 | 23061 | United States | Colorado | CO | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 5758736 | 796 | 0 | 802 | weekly | |
23369 | 23369 | United States | Connecticut | CT | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 3565287 | 613 | 0 | 656 | weekly | |
23677 | 23677 | United States | Delaware | DE | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 973764 | 169 | 0 | 190 | weekly | |
23985 | 23985 | United States | District of Columbia | DC | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 705749 | 118 | 0 | 117 | weekly | |
24293 | 24293 | United States | Florida | FL | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 21477737 | 4317 | 0 | 3749 | weekly | |
24601 | 24601 | United States | Georgia | GA | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 10617423 | 1694 | 0 | 1733 | weekly | |
24909 | 24909 | United States | Hawaii | HI | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 1415872 | 260 | 0 | 245 | weekly | |
25217 | 25217 | United States | Idaho | ID | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 1787065 | 270 | 0 | 272 | weekly | |
25525 | 25525 | United States | Illinois | IL | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 12671821 | 2093 | 0 | 2135 | weekly | |
25833 | 25833 | United States | Indiana | IN | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 6732219 | 1304 | 0 | 1306 | weekly | |
26141 | 26141 | United States | Iowa | IA | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 3155070 | 600 | 0 | 608 | weekly | |
26449 | 26449 | United States | Kansas | KS | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 2913314 | 546 | 0 | 541 | weekly | |
26757 | 26757 | United States | Kentucky | KY | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 4467673 | 956 | 0 | 966 | weekly | |
27065 | 27065 | United States | Louisiana | LA | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 4648794 | 888 | 0 | 910 | weekly | |
27373 | 27373 | United States | Maine | ME | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 1344212 | 300 | 0 | 309 | weekly | |
27681 | 27681 | United States | Maryland | MD | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 6045680 | 1010 | 0 | 995 | weekly | |
27989 | 27989 | United States | Massachusetts | MA | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 6949503 | 1144 | 0 | 1289 | weekly | |
28297 | 28297 | United States | Michigan | MI | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 9986857 | 1938 | 0 | 1994 | weekly | |
28605 | 28605 | United States | Minnesota | MN | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 5639632 | 818 | 0 | 895 | weekly | |
28913 | 28913 | United States | Mississippi | MS | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 2976149 | 601 | 0 | 656 | weekly | |
29221 | 29221 | United States | Missouri | MO | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 6137428 | 1290 | 0 | 1332 | weekly | |
29529 | 29529 | United States | Montana | MT | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 1068778 | 196 | 0 | 206 | weekly | |
29837 | 29837 | United States | Nebraska | NE | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 1934408 | 372 | 0 | 365 | weekly | |
30145 | 30145 | United States | Nevada | NV | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 3080156 | 550 | 0 | 505 | weekly | |
30453 | 30453 | United States | New Hampshire | NH | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 1359711 | 223 | 0 | 257 | weekly | |
30761 | 30761 | United States | New Jersey | NJ | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 8882190 | 1421 | 0 | 1478 | weekly | |
31069 | 31069 | United States | New Mexico | NM | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 2096829 | 363 | 0 | 366 | weekly | |
31377 | 31377 | United States | New York | NY | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 19453561 | 3019 | 0 | 3189 | weekly | |
31685 | 31685 | United States | North Carolina | NC | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 10488084 | 1844 | 0 | 1924 | weekly | |
31993 | 31993 | United States | North Dakota | ND | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 762062 | 130 | 0 | 138 | weekly | |
32301 | 32301 | United States | Ohio | OH | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 11689100 | 2363 | 0 | 2440 | weekly | |
32609 | 32609 | United States | Oklahoma | OK | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 3956971 | 739 | 0 | 810 | weekly | |
32917 | 32917 | United States | Oregon | OR | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 4217737 | 791 | 0 | 760 | weekly | |
33225 | 33225 | United States | Pennsylvania | PA | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 12801989 | 2752 | 0 | 2812 | weekly | |
33533 | 33533 | United States | Rhode Island | RI | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 1059361 | 181 | 0 | 231 | weekly | |
33841 | 33841 | United States | South Carolina | SC | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 5148714 | 996 | 0 | 992 | weekly | |
34149 | 34149 | United States | South Dakota | SD | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 884659 | 157 | 0 | 168 | weekly | |
34457 | 34457 | United States | Tennessee | TN | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 6833174 | 1532 | 0 | 1475 | weekly | |
34765 | 34765 | United States | Texas | TX | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 28995881 | 3954 | 0 | 4141 | weekly | |
35073 | 35073 | United States | Utah | UT | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 3205958 | 380 | 0 | 383 | weekly | |
35381 | 35381 | United States | Vermont | VT | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 623989 | 113 | 0 | 121 | weekly | |
35689 | 35689 | United States | Virginia | VA | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 8535519 | 1305 | 0 | 1372 | weekly | |
35997 | 35997 | United States | Washington | WA | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 7614893 | 1166 | 0 | 1154 | weekly | |
36305 | 36305 | United States | West Virginia | WV | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 1792147 | 458 | 0 | 446 | weekly | |
36613 | 36613 | United States | Wisconsin | WI | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 5822434 | 1035 | 0 | 1072 | weekly | |
36921 | 36921 | United States | Wyoming | WY | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 578759 | 81 | 0 | 95 | weekly | |
37229 | 37229 | United States | United States | USA | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 328300544 | 56466 | 0 | 56902 | 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]);