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 2017-10-29
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: expected_deaths
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21502 | 21502 | United States | Alabama | AL | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 4903185 | 994 | 0 | 1024 | weekly | |
21810 | 21810 | United States | Alaska | AK | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 731545 | 76 | 0 | 89 | weekly | |
22118 | 22118 | United States | Arizona | AZ | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 7278717 | 1085 | 0 | 1035 | weekly | |
22426 | 22426 | United States | Arkansas | AR | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 3017825 | 609 | 0 | 584 | weekly | |
22734 | 22734 | United States | California | CA | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 39512223 | 4926 | 0 | 4925 | weekly | |
23042 | 23042 | United States | Colorado | CO | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 5758736 | 735 | 0 | 754 | weekly | |
23350 | 23350 | United States | Connecticut | CT | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 3565287 | 598 | 0 | 607 | weekly | |
23658 | 23658 | United States | Delaware | DE | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 973764 | 175 | 0 | 181 | weekly | |
23966 | 23966 | United States | District of Columbia | DC | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 705749 | 98 | 0 | 117 | weekly | |
24274 | 24274 | United States | Florida | FL | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 21477737 | 3985 | 0 | 3922 | weekly | |
24582 | 24582 | United States | Georgia | GA | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 10617423 | 1626 | 0 | 1676 | weekly | |
24890 | 24890 | United States | Hawaii | HI | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 1415872 | 232 | 0 | 213 | weekly | |
25198 | 25198 | United States | Idaho | ID | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 1787065 | 274 | 0 | 260 | weekly | |
25506 | 25506 | United States | Illinois | IL | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 12671821 | 2058 | 0 | 2112 | weekly | |
25814 | 25814 | United States | Indiana | IN | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 6732219 | 1269 | 0 | 1278 | weekly | |
26122 | 26122 | United States | Iowa | IA | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 3155070 | 630 | 0 | 607 | weekly | |
26430 | 26430 | United States | Kansas | KS | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 2913314 | 545 | 0 | 512 | weekly | |
26738 | 26738 | United States | Kentucky | KY | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 4467673 | 928 | 0 | 910 | weekly | |
27046 | 27046 | United States | Louisiana | LA | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 4648794 | 899 | 0 | 922 | weekly | |
27354 | 27354 | United States | Maine | ME | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 1344212 | 265 | 0 | 295 | weekly | |
27662 | 27662 | United States | Maryland | MD | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 6045680 | 891 | 0 | 959 | weekly | |
27970 | 27970 | United States | Massachusetts | MA | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 6949503 | 1160 | 0 | 1195 | weekly | |
28278 | 28278 | United States | Michigan | MI | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 9986857 | 1885 | 0 | 1944 | weekly | |
28586 | 28586 | United States | Minnesota | MN | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 5639632 | 879 | 0 | 899 | weekly | |
28894 | 28894 | United States | Mississippi | MS | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 2976149 | 603 | 0 | 633 | weekly | |
29202 | 29202 | United States | Missouri | MO | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 6137428 | 1192 | 0 | 1258 | weekly | |
29510 | 29510 | United States | Montana | MT | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 1068778 | 187 | 0 | 196 | weekly | |
29818 | 29818 | United States | Nebraska | NE | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 1934408 | 321 | 0 | 340 | weekly | |
30126 | 30126 | United States | Nevada | NV | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 3080156 | 466 | 0 | 462 | weekly | |
30434 | 30434 | United States | New Hampshire | NH | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 1359711 | 257 | 0 | 247 | weekly | |
30742 | 30742 | United States | New Jersey | NJ | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 8882190 | 1346 | 0 | 1418 | weekly | |
31050 | 31050 | United States | New Mexico | NM | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 2096829 | 327 | 0 | 339 | weekly | |
31358 | 31358 | United States | New York | NY | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 19453561 | 2864 | 0 | 3068 | weekly | |
31666 | 31666 | United States | North Carolina | NC | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 10488084 | 1817 | 0 | 1877 | weekly | |
31974 | 31974 | United States | North Dakota | ND | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 762062 | 154 | 0 | 143 | weekly | |
32282 | 32282 | United States | Ohio | OH | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 11689100 | 2326 | 0 | 2343 | weekly | |
32590 | 32590 | United States | Oklahoma | OK | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 3956971 | 753 | 0 | 773 | weekly | |
32898 | 32898 | United States | Oregon | OR | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 4217737 | 714 | 0 | 712 | weekly | |
33206 | 33206 | United States | Pennsylvania | PA | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 12801989 | 2590 | 0 | 2667 | weekly | |
33514 | 33514 | United States | Rhode Island | RI | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 1059361 | 176 | 0 | 207 | weekly | |
33822 | 33822 | United States | South Carolina | SC | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 5148714 | 967 | 0 | 971 | weekly | |
34130 | 34130 | United States | South Dakota | SD | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 884659 | 171 | 0 | 155 | weekly | |
34438 | 34438 | United States | Tennessee | TN | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 6833174 | 1356 | 0 | 1432 | weekly | |
34746 | 34746 | United States | Texas | TX | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 28995881 | 4015 | 0 | 3979 | weekly | |
35054 | 35054 | United States | Utah | UT | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 3205958 | 374 | 0 | 374 | weekly | |
35362 | 35362 | United States | Vermont | VT | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 623989 | 116 | 0 | 118 | weekly | |
35670 | 35670 | United States | Virginia | VA | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 8535519 | 1299 | 0 | 1322 | weekly | |
35978 | 35978 | United States | Washington | WA | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 7614893 | 1086 | 0 | 1086 | weekly | |
36286 | 36286 | United States | West Virginia | WV | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 1792147 | 430 | 0 | 435 | weekly | |
36594 | 36594 | United States | Wisconsin | WI | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 5822434 | 1026 | 0 | 1083 | weekly | |
36902 | 36902 | United States | Wyoming | WY | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 578759 | 83 | 0 | 93 | weekly | |
37210 | 37210 | United States | United States | USA | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 328300544 | 53838 | 0 | 54751 | 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]);