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 2019-04-13 sorted by year
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21577 | 21577 | United States | Alabama | AL | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 4903185 | 1031 | 0 | 1028 | weekly | |
21885 | 21885 | United States | Alaska | AK | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 731545 | 81 | 0 | 88 | weekly | |
22193 | 22193 | United States | Arizona | AZ | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 7278717 | 1325 | 0 | 1273 | weekly | |
22501 | 22501 | United States | Arkansas | AR | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 3017825 | 645 | 0 | 618 | weekly | |
22809 | 22809 | United States | California | CA | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 39512223 | 5215 | 0 | 5506 | weekly | |
23117 | 23117 | United States | Colorado | CO | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 5758736 | 804 | 0 | 840 | weekly | |
23425 | 23425 | United States | Connecticut | CT | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 3565287 | 656 | 0 | 620 | weekly | |
23733 | 23733 | United States | Delaware | DE | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 973764 | 147 | 0 | 193 | weekly | |
24041 | 24041 | United States | District of Columbia | DC | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 705749 | 104 | 0 | 122 | weekly | |
24349 | 24349 | United States | Florida | FL | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 21477737 | 4277 | 0 | 4296 | weekly | |
24657 | 24657 | United States | Georgia | GA | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 10617423 | 1654 | 0 | 1714 | weekly | |
24965 | 24965 | United States | Hawaii | HI | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 1415872 | 216 | 0 | 218 | weekly | |
25273 | 25273 | United States | Idaho | ID | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 1787065 | 292 | 0 | 281 | weekly | |
25581 | 25581 | United States | Illinois | IL | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 12671821 | 1969 | 0 | 2115 | weekly | |
25889 | 25889 | United States | Indiana | IN | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 6732219 | 1251 | 0 | 1293 | weekly | |
26197 | 26197 | United States | Iowa | IA | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 3155070 | 597 | 0 | 577 | weekly | |
26505 | 26505 | United States | Kansas | KS | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 2913314 | 516 | 0 | 519 | weekly | |
26813 | 26813 | United States | Kentucky | KY | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 4467673 | 957 | 0 | 1015 | weekly | |
27121 | 27121 | United States | Louisiana | LA | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 4648794 | 853 | 0 | 872 | weekly | |
27429 | 27429 | United States | Maine | ME | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 1344212 | 294 | 0 | 305 | weekly | |
27737 | 27737 | United States | Maryland | MD | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 6045680 | 998 | 0 | 996 | weekly | |
28045 | 28045 | United States | Massachusetts | MA | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 6949503 | 1167 | 0 | 1221 | weekly | |
28353 | 28353 | United States | Michigan | MI | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 9986857 | 1889 | 0 | 1933 | weekly | |
28661 | 28661 | United States | Minnesota | MN | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 5639632 | 854 | 0 | 888 | weekly | |
28969 | 28969 | United States | Mississippi | MS | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 2976149 | 632 | 0 | 626 | weekly | |
29277 | 29277 | United States | Missouri | MO | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 6137428 | 1214 | 0 | 1265 | weekly | |
29585 | 29585 | United States | Montana | MT | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 1068778 | 198 | 0 | 207 | weekly | |
29893 | 29893 | United States | Nebraska | NE | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 1934408 | 314 | 0 | 341 | weekly | |
30201 | 30201 | United States | Nevada | NV | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 3080156 | 517 | 0 | 535 | weekly | |
30509 | 30509 | United States | New Hampshire | NH | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 1359711 | 210 | 0 | 253 | weekly | |
30817 | 30817 | United States | New Jersey | NJ | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 8882190 | 1403 | 0 | 1430 | weekly | |
31125 | 31125 | United States | New Mexico | NM | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 2096829 | 375 | 0 | 376 | weekly | |
31433 | 31433 | United States | New York | NY | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 19453561 | 3006 | 0 | 3058 | weekly | |
31741 | 31741 | United States | North Carolina | NC | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 10488084 | 1957 | 0 | 1908 | weekly | |
32049 | 32049 | United States | North Dakota | ND | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 762062 | 149 | 0 | 130 | weekly | |
32357 | 32357 | United States | Ohio | OH | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 11689100 | 2358 | 0 | 2482 | weekly | |
32665 | 32665 | United States | Oklahoma | OK | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 3956971 | 756 | 0 | 762 | weekly | |
32973 | 32973 | United States | Oregon | OR | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 4217737 | 702 | 0 | 749 | weekly | |
33281 | 33281 | United States | Pennsylvania | PA | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 12801989 | 2704 | 0 | 2706 | weekly | |
33589 | 33589 | United States | Rhode Island | RI | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 1059361 | 203 | 0 | 205 | weekly | |
33897 | 33897 | United States | South Carolina | SC | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 5148714 | 925 | 0 | 980 | weekly | |
34205 | 34205 | United States | South Dakota | SD | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 884659 | 157 | 0 | 170 | weekly | |
34513 | 34513 | United States | Tennessee | TN | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 6833174 | 1494 | 0 | 1469 | weekly | |
34821 | 34821 | United States | Texas | TX | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 28995881 | 3973 | 0 | 4072 | weekly | |
35129 | 35129 | United States | Utah | UT | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 3205958 | 396 | 0 | 401 | weekly | |
35437 | 35437 | United States | Vermont | VT | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 623989 | 108 | 0 | 118 | weekly | |
35745 | 35745 | United States | Virginia | VA | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 8535519 | 1376 | 0 | 1341 | weekly | |
36053 | 36053 | United States | Washington | WA | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 7614893 | 1147 | 0 | 1165 | weekly | |
36361 | 36361 | United States | West Virginia | WV | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 1792147 | 451 | 0 | 435 | weekly | |
36669 | 36669 | United States | Wisconsin | WI | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 5822434 | 1051 | 0 | 1051 | weekly | |
36977 | 36977 | United States | Wyoming | WY | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 578759 | 70 | 0 | 87 | weekly | |
37285 | 37285 | United States | United States | USA | 2019-04-07 | 2019-04-13 | 7 | 2019 | 15 | 328300544 | 55638 | 0 | 56853 | 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]);