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 2022-03-19
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21730 | 21730 | United States | Alabama | AL | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 4903185 | 1138 | 206 | 1082 | weekly | |
22038 | 22038 | United States | Alaska | AK | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 731545 | 102 | 1 | 90 | weekly | |
22346 | 22346 | United States | Arizona | AZ | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 7278717 | 1472 | 457 | 1329 | weekly | |
22654 | 22654 | United States | Arkansas | AR | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 3017825 | 660 | 189 | 666 | weekly | |
22962 | 22962 | United States | California | CA | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 39512223 | 5760 | 701 | 5555 | weekly | |
23270 | 23270 | United States | Colorado | CO | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 5758736 | 848 | 64 | 830 | weekly | |
23578 | 23578 | United States | Connecticut | CT | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 3565287 | 632 | 69 | 669 | weekly | |
23886 | 23886 | United States | Delaware | DE | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 973764 | 211 | 59 | 190 | weekly | |
24194 | 24194 | United States | District of Columbia | DC | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 705749 | 129 | 0 | 111 | weekly | |
24502 | 24502 | United States | Florida | FL | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 21477737 | 4568 | 772 | 4416 | weekly | |
24810 | 24810 | United States | Georgia | GA | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 10617423 | 1817 | 314 | 1767 | weekly | |
25118 | 25118 | United States | Hawaii | HI | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 1415872 | 244 | 14 | 251 | weekly | |
25426 | 25426 | United States | Idaho | ID | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 1787065 | 286 | 15 | 306 | weekly | |
25734 | 25734 | United States | Illinois | IL | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 12671821 | 2206 | 149 | 2131 | weekly | |
26042 | 26042 | United States | Indiana | IN | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 6732219 | 1382 | 126 | 1364 | weekly | |
26350 | 26350 | United States | Iowa | IA | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 3155070 | 625 | 87 | 621 | weekly | |
26658 | 26658 | United States | Kansas | KS | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 2913314 | 581 | 140 | 553 | weekly | |
26966 | 26966 | United States | Kentucky | KY | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 4467673 | 1134 | 283 | 981 | weekly | |
27274 | 27274 | United States | Louisiana | LA | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 4648794 | 976 | 109 | 933 | weekly | |
27582 | 27582 | United States | Maine | ME | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 1344212 | 289 | 37 | 316 | weekly | |
27890 | 27890 | United States | Maryland | MD | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 6045680 | 1076 | 44 | 1037 | weekly | |
28198 | 28198 | United States | Massachusetts | MA | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 6949503 | 1113 | -3722 | 1238 | weekly | |
28506 | 28506 | United States | Michigan | MI | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 9986857 | 2030 | 230 | 1964 | weekly | |
28814 | 28814 | United States | Minnesota | MN | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 5639632 | 938 | 57 | 921 | weekly | |
29122 | 29122 | United States | Mississippi | MS | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 2976149 | 713 | 0 | 645 | weekly | |
29430 | 29430 | United States | Missouri | MO | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 6137428 | 1329 | 381 | 1340 | weekly | |
29738 | 29738 | United States | Montana | MT | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 1068778 | 211 | 11 | 214 | weekly | |
30046 | 30046 | United States | Nebraska | NE | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 1934408 | 362 | 21 | 359 | weekly | |
30354 | 30354 | United States | Nevada | NV | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 3080156 | 606 | 27 | 548 | weekly | |
30662 | 30662 | United States | New Hampshire | NH | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 1359711 | 276 | 19 | 264 | weekly | |
30970 | 30970 | United States | New Jersey | NJ | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 8882190 | 1427 | 65 | 1519 | weekly | |
31278 | 31278 | United States | New Mexico | NM | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 2096829 | 444 | 95 | 396 | weekly | |
31586 | 31586 | United States | New York | NY | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 19453561 | 3129 | 164 | 3108 | weekly | |
31894 | 31894 | United States | North Carolina | NC | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 10488084 | 1938 | 136 | 2006 | weekly | |
32202 | 32202 | United States | North Dakota | ND | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 762062 | 137 | 9 | 145 | weekly | |
32510 | 32510 | United States | Ohio | OH | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 11689100 | 2581 | 198 | 2540 | weekly | |
32818 | 32818 | United States | Oklahoma | OK | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 3956971 | 883 | 295 | 828 | weekly | |
33126 | 33126 | United States | Oregon | OR | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 4217737 | 781 | 102 | 744 | weekly | |
33434 | 33434 | United States | Pennsylvania | PA | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 12801989 | 2678 | 177 | 2710 | weekly | |
33742 | 33742 | United States | Rhode Island | RI | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 1059361 | 194 | 8 | 223 | weekly | |
34050 | 34050 | United States | South Carolina | SC | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 5148714 | 1060 | 8 | 1052 | weekly | |
34358 | 34358 | United States | South Dakota | SD | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 884659 | 169 | 26 | 167 | weekly | |
34666 | 34666 | United States | Tennessee | TN | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 6833174 | 1670 | 537 | 1571 | weekly | |
34974 | 34974 | United States | Texas | TX | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 28995881 | 4638 | 445 | 4232 | weekly | |
35282 | 35282 | United States | Utah | UT | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 3205958 | 454 | 22 | 401 | weekly | |
35590 | 35590 | United States | Vermont | VT | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 623989 | 118 | 3 | 113 | weekly | |
35898 | 35898 | United States | Virginia | VA | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 8535519 | 1544 | 144 | 1451 | weekly | |
36206 | 36206 | United States | Washington | WA | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 7614893 | 1256 | 150 | 1219 | weekly | |
36514 | 36514 | United States | West Virginia | WV | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 1792147 | 543 | 96 | 476 | weekly | |
36822 | 36822 | United States | Wisconsin | WI | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 5822434 | 1073 | 226 | 1096 | weekly | |
37130 | 37130 | United States | Wyoming | WY | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 578759 | 100 | 20 | 99 | weekly | |
37438 | 37438 | United States | United States | USA | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 328300544 | 60531 | 3786 | 58787 | 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]);