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-06-16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21534 | 21534 | United States | Alabama | AL | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 4903185 | 940 | 0 | 941 | weekly | |
21842 | 21842 | United States | Alaska | AK | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 731545 | 82 | 0 | 88 | weekly | |
22150 | 22150 | United States | Arizona | AZ | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 7278717 | 1154 | 0 | 1076 | weekly | |
22458 | 22458 | United States | Arkansas | AR | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 3017825 | 603 | 0 | 576 | weekly | |
22766 | 22766 | United States | California | CA | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 39512223 | 4804 | 0 | 4949 | weekly | |
23074 | 23074 | United States | Colorado | CO | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 5758736 | 713 | 0 | 747 | weekly | |
23382 | 23382 | United States | Connecticut | CT | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 3565287 | 543 | 0 | 577 | weekly | |
23690 | 23690 | United States | Delaware | DE | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 973764 | 165 | 0 | 167 | weekly | |
23998 | 23998 | United States | District of Columbia | DC | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 705749 | 114 | 0 | 105 | weekly | |
24306 | 24306 | United States | Florida | FL | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 21477737 | 3793 | 0 | 3892 | weekly | |
24614 | 24614 | United States | Georgia | GA | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 10617423 | 1517 | 0 | 1575 | weekly | |
24922 | 24922 | United States | Hawaii | HI | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 1415872 | 252 | 0 | 233 | weekly | |
25230 | 25230 | United States | Idaho | ID | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 1787065 | 260 | 0 | 265 | weekly | |
25538 | 25538 | United States | Illinois | IL | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 12671821 | 1872 | 0 | 1981 | weekly | |
25846 | 25846 | United States | Indiana | IN | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 6732219 | 1190 | 0 | 1187 | weekly | |
26154 | 26154 | United States | Iowa | IA | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 3155070 | 573 | 0 | 538 | weekly | |
26462 | 26462 | United States | Kansas | KS | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 2913314 | 493 | 0 | 495 | weekly | |
26770 | 26770 | United States | Kentucky | KY | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 4467673 | 872 | 0 | 884 | weekly | |
27078 | 27078 | United States | Louisiana | LA | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 4648794 | 821 | 0 | 810 | weekly | |
27386 | 27386 | United States | Maine | ME | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 1344212 | 250 | 0 | 286 | weekly | |
27694 | 27694 | United States | Maryland | MD | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 6045680 | 866 | 0 | 892 | weekly | |
28002 | 28002 | United States | Massachusetts | MA | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 6949503 | 1098 | 0 | 1137 | weekly | |
28310 | 28310 | United States | Michigan | MI | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 9986857 | 1797 | 0 | 1810 | weekly | |
28618 | 28618 | United States | Minnesota | MN | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 5639632 | 810 | 0 | 819 | weekly | |
28926 | 28926 | United States | Mississippi | MS | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 2976149 | 592 | 0 | 591 | weekly | |
29234 | 29234 | United States | Missouri | MO | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 6137428 | 1167 | 0 | 1195 | weekly | |
29542 | 29542 | United States | Montana | MT | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 1068778 | 195 | 0 | 196 | weekly | |
29850 | 29850 | United States | Nebraska | NE | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 1934408 | 315 | 0 | 322 | weekly | |
30158 | 30158 | United States | Nevada | NV | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 3080156 | 483 | 0 | 473 | weekly | |
30466 | 30466 | United States | New Hampshire | NH | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 1359711 | 230 | 0 | 242 | weekly | |
30774 | 30774 | United States | New Jersey | NJ | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 8882190 | 1362 | 0 | 1290 | weekly | |
31082 | 31082 | United States | New Mexico | NM | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 2096829 | 363 | 0 | 336 | weekly | |
31390 | 31390 | United States | New York | NY | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 19453561 | 2811 | 0 | 2777 | weekly | |
31698 | 31698 | United States | North Carolina | NC | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 10488084 | 1779 | 0 | 1732 | weekly | |
32006 | 32006 | United States | North Dakota | ND | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 762062 | 120 | 0 | 128 | weekly | |
32314 | 32314 | United States | Ohio | OH | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 11689100 | 2197 | 0 | 2220 | weekly | |
32622 | 32622 | United States | Oklahoma | OK | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 3956971 | 726 | 0 | 723 | weekly | |
32930 | 32930 | United States | Oregon | OR | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 4217737 | 713 | 0 | 716 | weekly | |
33238 | 33238 | United States | Pennsylvania | PA | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 12801989 | 2483 | 0 | 2448 | weekly | |
33546 | 33546 | United States | Rhode Island | RI | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 1059361 | 181 | 0 | 206 | weekly | |
33854 | 33854 | United States | South Carolina | SC | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 5148714 | 834 | 0 | 905 | weekly | |
34162 | 34162 | United States | South Dakota | SD | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 884659 | 159 | 0 | 149 | weekly | |
34470 | 34470 | United States | Tennessee | TN | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 6833174 | 1344 | 0 | 1359 | weekly | |
34778 | 34778 | United States | Texas | TX | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 28995881 | 3664 | 0 | 3793 | weekly | |
35086 | 35086 | United States | Utah | UT | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 3205958 | 348 | 0 | 357 | weekly | |
35394 | 35394 | United States | Vermont | VT | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 623989 | 125 | 0 | 108 | weekly | |
35702 | 35702 | United States | Virginia | VA | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 8535519 | 1282 | 0 | 1221 | weekly | |
36010 | 36010 | United States | Washington | WA | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 7614893 | 1047 | 0 | 1066 | weekly | |
36318 | 36318 | United States | West Virginia | WV | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 1792147 | 416 | 0 | 408 | weekly | |
36626 | 36626 | United States | Wisconsin | WI | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 5822434 | 923 | 0 | 968 | weekly | |
36934 | 36934 | United States | Wyoming | WY | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 578759 | 74 | 0 | 89 | weekly | |
37242 | 37242 | United States | United States | USA | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 328300544 | 51515 | 0 | 52048 | 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]);