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-02-12
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21725 | 21725 | United States | Alabama | AL | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 4903185 | 1601 | 134 | 1122 | weekly | |
22033 | 22033 | United States | Alaska | AK | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 731545 | 112 | 21 | 89 | weekly | |
22341 | 22341 | United States | Arizona | AZ | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 7278717 | 1863 | 543 | 1360 | weekly | |
22649 | 22649 | United States | Arkansas | AR | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 3017825 | 985 | 215 | 695 | weekly | |
22957 | 22957 | United States | California | CA | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 39512223 | 7761 | 1477 | 5839 | weekly | |
23265 | 23265 | United States | Colorado | CO | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 5758736 | 1025 | 232 | 847 | weekly | |
23573 | 23573 | United States | Connecticut | CT | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 3565287 | 795 | 101 | 682 | weekly | |
23881 | 23881 | United States | Delaware | DE | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 973764 | 270 | 38 | 201 | weekly | |
24189 | 24189 | United States | District of Columbia | DC | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 705749 | 137 | 16 | 117 | weekly | |
24497 | 24497 | United States | Florida | FL | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 21477737 | 5659 | 1631 | 4487 | weekly | |
24805 | 24805 | United States | Georgia | GA | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 10617423 | 2501 | 674 | 1809 | weekly | |
25113 | 25113 | United States | Hawaii | HI | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 1415872 | 293 | 43 | 256 | weekly | |
25421 | 25421 | United States | Idaho | ID | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 1787065 | 398 | 75 | 313 | weekly | |
25729 | 25729 | United States | Illinois | IL | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 12671821 | 2743 | 568 | 2196 | weekly | |
26037 | 26037 | United States | Indiana | IN | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 6732219 | 1741 | 424 | 1406 | weekly | |
26345 | 26345 | United States | Iowa | IA | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 3155070 | 730 | 172 | 654 | weekly | |
26653 | 26653 | United States | Kansas | KS | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 2913314 | 735 | 104 | 583 | weekly | |
26961 | 26961 | United States | Kentucky | KY | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 4467673 | 1343 | 237 | 1015 | weekly | |
27269 | 27269 | United States | Louisiana | LA | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 4648794 | 1274 | 271 | 963 | weekly | |
27577 | 27577 | United States | Maine | ME | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 1344212 | 351 | 24 | 320 | weekly | |
27885 | 27885 | United States | Maryland | MD | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 6045680 | 1214 | 333 | 1085 | weekly | |
28193 | 28193 | United States | Massachusetts | MA | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 6949503 | 1441 | 412 | 1304 | weekly | |
28501 | 28501 | United States | Michigan | MI | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 9986857 | 2290 | 590 | 2024 | weekly | |
28809 | 28809 | United States | Minnesota | MN | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 5639632 | 1154 | 198 | 948 | weekly | |
29117 | 29117 | United States | Mississippi | MS | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 2976149 | 927 | 308 | 657 | weekly | |
29425 | 29425 | United States | Missouri | MO | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 6137428 | 1746 | 406 | 1405 | weekly | |
29733 | 29733 | United States | Montana | MT | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 1068778 | 258 | 36 | 223 | weekly | |
30041 | 30041 | United States | Nebraska | NE | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 1934408 | 472 | 60 | 378 | weekly | |
30349 | 30349 | United States | Nevada | NV | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 3080156 | 805 | 191 | 565 | weekly | |
30657 | 30657 | United States | New Hampshire | NH | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 1359711 | 320 | 48 | 274 | weekly | |
30965 | 30965 | United States | New Jersey | NJ | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 8882190 | 1757 | 506 | 1613 | weekly | |
31273 | 31273 | United States | New Mexico | NM | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 2096829 | 545 | 123 | 410 | weekly | |
31581 | 31581 | United States | New York | NY | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 19453561 | 3822 | 507 | 3254 | weekly | |
31889 | 31889 | United States | North Carolina | NC | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 10488084 | 2605 | 568 | 2073 | weekly | |
32197 | 32197 | United States | North Dakota | ND | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 762062 | 169 | 16 | 149 | weekly | |
32505 | 32505 | United States | Ohio | OH | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 11689100 | 3224 | 788 | 2642 | weekly | |
32813 | 32813 | United States | Oklahoma | OK | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 3956971 | 1225 | 346 | 868 | weekly | |
33121 | 33121 | United States | Oregon | OR | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 4217737 | 952 | 141 | 770 | weekly | |
33429 | 33429 | United States | Pennsylvania | PA | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 12801989 | 3374 | 844 | 2828 | weekly | |
33737 | 33737 | United States | Rhode Island | RI | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 1059361 | 253 | 42 | 233 | weekly | |
34045 | 34045 | United States | South Carolina | SC | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 5148714 | 1460 | 345 | 1075 | weekly | |
34353 | 34353 | United States | South Dakota | SD | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 884659 | 214 | 41 | 171 | weekly | |
34661 | 34661 | United States | Tennessee | TN | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 6833174 | 2216 | 455 | 1600 | weekly | |
34969 | 34969 | United States | Texas | TX | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 28995881 | 6227 | 1548 | 4434 | weekly | |
35277 | 35277 | United States | Utah | UT | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 3205958 | 489 | 88 | 415 | weekly | |
35585 | 35585 | United States | Vermont | VT | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 623989 | 131 | 13 | 119 | weekly | |
35893 | 35893 | United States | Virginia | VA | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 8535519 | 1865 | 779 | 1503 | weekly | |
36201 | 36201 | United States | Washington | WA | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 7614893 | 1487 | 349 | 1281 | weekly | |
36509 | 36509 | United States | West Virginia | WV | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 1792147 | 674 | 146 | 489 | weekly | |
36817 | 36817 | United States | Wisconsin | WI | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 5822434 | 1308 | 263 | 1123 | weekly | |
37125 | 37125 | United States | Wyoming | WY | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 578759 | 115 | 17 | 103 | weekly | |
37433 | 37433 | United States | United States | USA | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 328300544 | 77056 | 17507 | 60970 | 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]);