economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where cadence = "weekly" and "start_date" is on date 2018-04-01 sorted by region
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_date (date)
Link | rowid | country | region ▼ | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21524 | 21524 | United States | Alabama | AL | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 4903185 | 1012 | 0 | 1017 | weekly | |
21832 | 21832 | United States | Alaska | AK | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 731545 | 92 | 0 | 84 | weekly | |
22140 | 22140 | United States | Arizona | AZ | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 7278717 | 1247 | 0 | 1157 | weekly | |
22448 | 22448 | United States | Arkansas | AR | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 3017825 | 576 | 0 | 613 | weekly | |
22756 | 22756 | United States | California | CA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 39512223 | 5279 | 0 | 5200 | weekly | |
23064 | 23064 | United States | Colorado | CO | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 5758736 | 780 | 0 | 778 | weekly | |
23372 | 23372 | United States | Connecticut | CT | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 3565287 | 658 | 0 | 634 | weekly | |
23680 | 23680 | United States | Delaware | DE | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 973764 | 179 | 0 | 186 | weekly | |
23988 | 23988 | United States | District of Columbia | DC | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 705749 | 120 | 0 | 112 | weekly | |
24296 | 24296 | United States | Florida | FL | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 21477737 | 4158 | 0 | 4168 | weekly | |
24604 | 24604 | United States | Georgia | GA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 10617423 | 1614 | 0 | 1681 | weekly | |
24912 | 24912 | United States | Hawaii | HI | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 1415872 | 222 | 0 | 237 | weekly | |
25220 | 25220 | United States | Idaho | ID | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 1787065 | 299 | 0 | 269 | weekly | |
25528 | 25528 | United States | Illinois | IL | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 12671821 | 2100 | 0 | 2091 | weekly | |
25836 | 25836 | United States | Indiana | IN | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 6732219 | 1279 | 0 | 1289 | weekly | |
26144 | 26144 | United States | Iowa | IA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 3155070 | 614 | 0 | 592 | weekly | |
26452 | 26452 | United States | Kansas | KS | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 2913314 | 518 | 0 | 530 | weekly | |
26760 | 26760 | United States | Kentucky | KY | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 4467673 | 889 | 0 | 940 | weekly | |
27068 | 27068 | United States | Louisiana | LA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 4648794 | 887 | 0 | 880 | weekly | |
27376 | 27376 | United States | Maine | ME | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 1344212 | 276 | 0 | 307 | weekly | |
27684 | 27684 | United States | Maryland | MD | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 6045680 | 937 | 0 | 955 | weekly | |
27992 | 27992 | United States | Massachusetts | MA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 6949503 | 1180 | 0 | 1259 | weekly | |
28300 | 28300 | United States | Michigan | MI | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 9986857 | 1984 | 0 | 1938 | weekly | |
28608 | 28608 | United States | Minnesota | MN | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 5639632 | 843 | 0 | 884 | weekly | |
28916 | 28916 | United States | Mississippi | MS | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 2976149 | 592 | 0 | 639 | weekly | |
29224 | 29224 | United States | Missouri | MO | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 6137428 | 1268 | 0 | 1290 | weekly | |
29532 | 29532 | United States | Montana | MT | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 1068778 | 212 | 0 | 205 | weekly | |
29840 | 29840 | United States | Nebraska | NE | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 1934408 | 355 | 0 | 349 | weekly | |
30148 | 30148 | United States | Nevada | NV | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 3080156 | 507 | 0 | 490 | weekly | |
30456 | 30456 | United States | New Hampshire | NH | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 1359711 | 256 | 0 | 252 | weekly | |
30764 | 30764 | United States | New Jersey | NJ | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 8882190 | 1463 | 0 | 1428 | weekly | |
31072 | 31072 | United States | New Mexico | NM | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 2096829 | 369 | 0 | 356 | weekly | |
31380 | 31380 | United States | New York | NY | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 19453561 | 3018 | 0 | 3030 | weekly | |
31688 | 31688 | United States | North Carolina | NC | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 10488084 | 1799 | 0 | 1863 | weekly | |
31996 | 31996 | United States | North Dakota | ND | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 762062 | 144 | 0 | 139 | weekly | |
32304 | 32304 | United States | Ohio | OH | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 11689100 | 2540 | 0 | 2383 | weekly | |
32612 | 32612 | United States | Oklahoma | OK | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 3956971 | 743 | 0 | 776 | weekly | |
32920 | 32920 | United States | Oregon | OR | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 4217737 | 743 | 0 | 751 | weekly | |
33228 | 33228 | United States | Pennsylvania | PA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 12801989 | 2669 | 0 | 2699 | weekly | |
33536 | 33536 | United States | Rhode Island | RI | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 1059361 | 229 | 0 | 227 | weekly | |
33844 | 33844 | United States | South Carolina | SC | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 5148714 | 927 | 0 | 961 | weekly | |
34152 | 34152 | United States | South Dakota | SD | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 884659 | 150 | 0 | 160 | weekly | |
34460 | 34460 | United States | Tennessee | TN | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 6833174 | 1415 | 0 | 1433 | weekly | |
34768 | 34768 | United States | Texas | TX | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 28995881 | 3768 | 0 | 4039 | weekly | |
37232 | 37232 | United States | United States | USA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 328300544 | 55423 | 0 | 55790 | weekly | |
35076 | 35076 | United States | Utah | UT | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 3205958 | 344 | 0 | 373 | weekly | |
35384 | 35384 | United States | Vermont | VT | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 623989 | 94 | 0 | 116 | weekly | |
35692 | 35692 | United States | Virginia | VA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 8535519 | 1338 | 0 | 1317 | weekly | |
36000 | 36000 | United States | Washington | WA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 7614893 | 1166 | 0 | 1134 | weekly | |
36308 | 36308 | United States | West Virginia | WV | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 1792147 | 443 | 0 | 431 | weekly | |
36616 | 36616 | United States | Wisconsin | WI | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 5822434 | 1034 | 0 | 1057 | weekly | |
36924 | 36924 | United States | Wyoming | WY | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 578759 | 94 | 0 | 91 | 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]);