economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where cadence = "weekly" and "end_date" is on date 2019-03-16
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_date (date)
country 1
cadence 1
- weekly · 52 ✖
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21573 | 21573 | United States | Alabama | AL | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 4903185 | 1090 | 0 | 1068 | weekly | |
21881 | 21881 | United States | Alaska | AK | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 731545 | 100 | 0 | 88 | weekly | |
22189 | 22189 | United States | Arizona | AZ | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 7278717 | 1279 | 0 | 1111 | weekly | |
22497 | 22497 | United States | Arkansas | AR | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 3017825 | 703 | 0 | 635 | weekly | |
22805 | 22805 | United States | California | CA | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 39512223 | 5590 | 0 | 5699 | weekly | |
23113 | 23113 | United States | Colorado | CO | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 5758736 | 819 | 0 | 852 | weekly | |
23421 | 23421 | United States | Connecticut | CT | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 3565287 | 677 | 0 | 649 | weekly | |
23729 | 23729 | United States | Delaware | DE | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 973764 | 184 | 0 | 194 | weekly | |
24037 | 24037 | United States | District of Columbia | DC | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 705749 | 121 | 0 | 125 | weekly | |
24345 | 24345 | United States | Florida | FL | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 21477737 | 4193 | 0 | 3894 | weekly | |
24653 | 24653 | United States | Georgia | GA | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 10617423 | 1706 | 0 | 1758 | weekly | |
24961 | 24961 | United States | Hawaii | HI | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 1415872 | 259 | 0 | 224 | weekly | |
25269 | 25269 | United States | Idaho | ID | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 1787065 | 289 | 0 | 284 | weekly | |
25577 | 25577 | United States | Illinois | IL | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 12671821 | 2160 | 0 | 2161 | weekly | |
25885 | 25885 | United States | Indiana | IN | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 6732219 | 1375 | 0 | 1319 | weekly | |
26193 | 26193 | United States | Iowa | IA | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 3155070 | 634 | 0 | 592 | weekly | |
26501 | 26501 | United States | Kansas | KS | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 2913314 | 557 | 0 | 536 | weekly | |
26809 | 26809 | United States | Kentucky | KY | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 4467673 | 942 | 0 | 1035 | weekly | |
27117 | 27117 | United States | Louisiana | LA | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 4648794 | 938 | 0 | 896 | weekly | |
27425 | 27425 | United States | Maine | ME | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 1344212 | 298 | 0 | 306 | weekly | |
27733 | 27733 | United States | Maryland | MD | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 6045680 | 1037 | 0 | 1024 | weekly | |
28041 | 28041 | United States | Massachusetts | MA | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 6949503 | 1151 | 0 | 1252 | weekly | |
28349 | 28349 | United States | Michigan | MI | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 9986857 | 1980 | 0 | 1961 | weekly | |
28657 | 28657 | United States | Minnesota | MN | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 5639632 | 856 | 0 | 898 | weekly | |
28965 | 28965 | United States | Mississippi | MS | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 2976149 | 628 | 0 | 642 | weekly | |
29273 | 29273 | United States | Missouri | MO | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 6137428 | 1340 | 0 | 1301 | weekly | |
29581 | 29581 | United States | Montana | MT | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 1068778 | 209 | 0 | 206 | weekly | |
29889 | 29889 | United States | Nebraska | NE | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 1934408 | 317 | 0 | 353 | weekly | |
30197 | 30197 | United States | Nevada | NV | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 3080156 | 512 | 0 | 468 | weekly | |
30505 | 30505 | United States | New Hampshire | NH | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 1359711 | 252 | 0 | 259 | weekly | |
30813 | 30813 | United States | New Jersey | NJ | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 8882190 | 1457 | 0 | 1488 | weekly | |
31121 | 31121 | United States | New Mexico | NM | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 2096829 | 404 | 0 | 394 | weekly | |
31429 | 31429 | United States | New York | NY | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 19453561 | 3118 | 0 | 3179 | weekly | |
31737 | 31737 | United States | North Carolina | NC | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 10488084 | 1907 | 0 | 1984 | weekly | |
32045 | 32045 | United States | North Dakota | ND | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 762062 | 118 | 0 | 130 | weekly | |
32353 | 32353 | United States | Ohio | OH | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 11689100 | 2562 | 0 | 2539 | weekly | |
32661 | 32661 | United States | Oklahoma | OK | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 3956971 | 870 | 0 | 786 | weekly | |
32969 | 32969 | United States | Oregon | OR | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 4217737 | 783 | 0 | 756 | weekly | |
33277 | 33277 | United States | Pennsylvania | PA | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 12801989 | 2805 | 0 | 2793 | weekly | |
33585 | 33585 | United States | Rhode Island | RI | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 1059361 | 225 | 0 | 213 | weekly | |
33893 | 33893 | United States | South Carolina | SC | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 5148714 | 1005 | 0 | 1005 | weekly | |
34201 | 34201 | United States | South Dakota | SD | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 884659 | 177 | 0 | 176 | weekly | |
34509 | 34509 | United States | Tennessee | TN | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 6833174 | 1449 | 0 | 1513 | weekly | |
34817 | 34817 | United States | Texas | TX | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 28995881 | 4199 | 0 | 4195 | weekly | |
35125 | 35125 | United States | Utah | UT | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 3205958 | 385 | 0 | 411 | weekly | |
35433 | 35433 | United States | Vermont | VT | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 623989 | 119 | 0 | 125 | weekly | |
35741 | 35741 | United States | Virginia | VA | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 8535519 | 1384 | 0 | 1390 | weekly | |
36049 | 36049 | United States | Washington | WA | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 7614893 | 1220 | 0 | 1185 | weekly | |
36357 | 36357 | United States | West Virginia | WV | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 1792147 | 455 | 0 | 448 | weekly | |
36665 | 36665 | United States | Wisconsin | WI | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 5822434 | 1078 | 0 | 1080 | weekly | |
36973 | 36973 | United States | Wyoming | WY | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 578759 | 111 | 0 | 92 | weekly | |
37281 | 37281 | United States | United States | USA | 2019-03-10 | 2019-03-16 | 7 | 2019 | 11 | 328300544 | 58027 | 0 | 57672 | 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]);