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 2021-03-13
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21677 | 21677 | United States | Alabama | AL | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 4903185 | 1189 | 181 | 1114 | weekly | |
21985 | 21985 | United States | Alaska | AK | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 731545 | 86 | 2 | 86 | weekly | |
22293 | 22293 | United States | Arizona | AZ | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 7278717 | 1412 | 284 | 1367 | weekly | |
22601 | 22601 | United States | Arkansas | AR | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 3017825 | 718 | 87 | 671 | weekly | |
22909 | 22909 | United States | California | CA | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 39512223 | 6220 | 638 | 5798 | weekly | |
23217 | 23217 | United States | Colorado | CO | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 5758736 | 842 | 53 | 858 | weekly | |
23525 | 23525 | United States | Connecticut | CT | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 3565287 | 646 | 61 | 672 | weekly | |
23833 | 23833 | United States | Delaware | DE | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 973764 | 204 | 32 | 216 | weekly | |
24141 | 24141 | United States | District of Columbia | DC | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 705749 | 125 | 10 | 143 | weekly | |
24449 | 24449 | United States | Florida | FL | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 21477737 | 4636 | 628 | 4638 | weekly | |
24757 | 24757 | United States | Georgia | GA | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 10617423 | 1992 | 285 | 1794 | weekly | |
25065 | 25065 | United States | Hawaii | HI | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 1415872 | 253 | 5 | 248 | weekly | |
25373 | 25373 | United States | Idaho | ID | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 1787065 | 310 | 33 | 312 | weekly | |
25681 | 25681 | United States | Illinois | IL | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 12671821 | 2110 | 187 | 2258 | weekly | |
25989 | 25989 | United States | Indiana | IN | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 6732219 | 1378 | 119 | 1449 | weekly | |
26297 | 26297 | United States | Iowa | IA | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 3155070 | 558 | 84 | 648 | weekly | |
26605 | 26605 | United States | Kansas | KS | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 2913314 | 528 | 52 | 553 | weekly | |
26913 | 26913 | United States | Kentucky | KY | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 4467673 | 1137 | 160 | 1035 | weekly | |
27221 | 27221 | United States | Louisiana | LA | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 4648794 | 1054 | 145 | 968 | weekly | |
27529 | 27529 | United States | Maine | ME | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 1344212 | 284 | 17 | 299 | weekly | |
27837 | 27837 | United States | Maryland | MD | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 6045680 | 1096 | 102 | 1097 | weekly | |
28145 | 28145 | United States | Massachusetts | MA | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 6949503 | 1213 | 206 | 1271 | weekly | |
28453 | 28453 | United States | Michigan | MI | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 9986857 | 1867 | 115 | 2083 | weekly | |
28761 | 28761 | United States | Minnesota | MN | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 5639632 | 865 | 195 | 939 | weekly | |
29069 | 29069 | United States | Mississippi | MS | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 2976149 | 753 | 91 | 634 | weekly | |
29377 | 29377 | United States | Missouri | MO | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 6137428 | 1314 | 149 | 1414 | weekly | |
29685 | 29685 | United States | Montana | MT | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 1068778 | 199 | 12 | 209 | weekly | |
29993 | 29993 | United States | Nebraska | NE | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 1934408 | 318 | 19 | 354 | weekly | |
30301 | 30301 | United States | Nevada | NV | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 3080156 | 605 | 60 | 578 | weekly | |
30609 | 30609 | United States | New Hampshire | NH | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 1359711 | 238 | 14 | 276 | weekly | |
30917 | 30917 | United States | New Jersey | NJ | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 8882190 | 1585 | 331 | 1626 | weekly | |
31225 | 31225 | United States | New Mexico | NM | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 2096829 | 412 | 54 | 414 | weekly | |
31533 | 31533 | United States | New York | NY | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 19453561 | 3598 | 547 | 3222 | weekly | |
31841 | 31841 | United States | North Carolina | NC | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 10488084 | 2052 | 164 | 2033 | weekly | |
32149 | 32149 | United States | North Dakota | ND | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 762062 | 135 | 9 | 151 | weekly | |
32457 | 32457 | United States | Ohio | OH | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 11689100 | 2549 | 565 | 2707 | weekly | |
32765 | 32765 | United States | Oklahoma | OK | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 3956971 | 842 | 68 | 840 | weekly | |
33073 | 33073 | United States | Oregon | OR | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 4217737 | 780 | 26 | 745 | weekly | |
33381 | 33381 | United States | Pennsylvania | PA | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 12801989 | 2712 | 253 | 2934 | weekly | |
33689 | 33689 | United States | Rhode Island | RI | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 1059361 | 240 | 33 | 211 | weekly | |
33997 | 33997 | United States | South Carolina | SC | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 5148714 | 1169 | 152 | 1069 | weekly | |
34305 | 34305 | United States | South Dakota | SD | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 884659 | 185 | 12 | 169 | weekly | |
34613 | 34613 | United States | Tennessee | TN | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 6833174 | 1603 | 104 | 1596 | weekly | |
34921 | 34921 | United States | Texas | TX | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 28995881 | 4924 | 607 | 4335 | weekly | |
35229 | 35229 | United States | Utah | UT | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 3205958 | 411 | 49 | 410 | weekly | |
35537 | 35537 | United States | Vermont | VT | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 623989 | 153 | 6 | 118 | weekly | |
35845 | 35845 | United States | Virginia | VA | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 8535519 | 1549 | 477 | 1483 | weekly | |
36153 | 36153 | United States | Washington | WA | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 7614893 | 1193 | 85 | 1195 | weekly | |
36461 | 36461 | United States | West Virginia | WV | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 1792147 | 490 | 212 | 481 | weekly | |
36769 | 36769 | United States | Wisconsin | WI | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 5822434 | 1055 | 40 | 1148 | weekly | |
37077 | 37077 | United States | Wyoming | WY | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 578759 | 104 | 9 | 92 | weekly | |
37385 | 37385 | United States | United States | USA | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 328300544 | 61891 | 7829 | 60961 | 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]);