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 2017-02-04 and year = 2017
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21463 | 21463 | United States | Alabama | AL | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 4903185 | 1036 | 0 | 1039 | weekly | |
21771 | 21771 | United States | Alaska | AK | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 731545 | 87 | 0 | 78 | weekly | |
22079 | 22079 | United States | Arizona | AZ | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 7278717 | 1235 | 0 | 1147 | weekly | |
22387 | 22387 | United States | Arkansas | AR | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 3017825 | 614 | 0 | 643 | weekly | |
22695 | 22695 | United States | California | CA | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 39512223 | 5970 | 0 | 5283 | weekly | |
23003 | 23003 | United States | Colorado | CO | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 5758736 | 782 | 0 | 758 | weekly | |
23311 | 23311 | United States | Connecticut | CT | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 3565287 | 665 | 0 | 628 | weekly | |
23619 | 23619 | United States | Delaware | DE | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 973764 | 191 | 0 | 171 | weekly | |
23927 | 23927 | United States | District of Columbia | DC | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 705749 | 128 | 0 | 110 | weekly | |
24235 | 24235 | United States | Florida | FL | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 21477737 | 4333 | 0 | 3725 | weekly | |
24543 | 24543 | United States | Georgia | GA | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 10617423 | 1693 | 0 | 1711 | weekly | |
24851 | 24851 | United States | Hawaii | HI | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 1415872 | 222 | 0 | 240 | weekly | |
25159 | 25159 | United States | Idaho | ID | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 1787065 | 283 | 0 | 261 | weekly | |
25467 | 25467 | United States | Illinois | IL | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 12671821 | 2238 | 0 | 2089 | weekly | |
25775 | 25775 | United States | Indiana | IN | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 6732219 | 1314 | 0 | 1304 | weekly | |
26083 | 26083 | United States | Iowa | IA | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 3155070 | 672 | 0 | 610 | weekly | |
26391 | 26391 | United States | Kansas | KS | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 2913314 | 555 | 0 | 526 | weekly | |
26699 | 26699 | United States | Kentucky | KY | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 4467673 | 988 | 0 | 934 | weekly | |
27007 | 27007 | United States | Louisiana | LA | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 4648794 | 935 | 0 | 991 | weekly | |
27315 | 27315 | United States | Maine | ME | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 1344212 | 264 | 0 | 278 | weekly | |
27623 | 27623 | United States | Maryland | MD | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 6045680 | 1021 | 0 | 993 | weekly | |
27931 | 27931 | United States | Massachusetts | MA | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 6949503 | 1294 | 0 | 1187 | weekly | |
28239 | 28239 | United States | Michigan | MI | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 9986857 | 1920 | 0 | 1918 | weekly | |
28547 | 28547 | United States | Minnesota | MN | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 5639632 | 893 | 0 | 847 | weekly | |
28855 | 28855 | United States | Mississippi | MS | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 2976149 | 648 | 0 | 637 | weekly | |
29163 | 29163 | United States | Missouri | MO | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 6137428 | 1340 | 0 | 1264 | weekly | |
29471 | 29471 | United States | Montana | MT | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 1068778 | 221 | 0 | 198 | weekly | |
29779 | 29779 | United States | Nebraska | NE | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 1934408 | 357 | 0 | 335 | weekly | |
30087 | 30087 | United States | Nevada | NV | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 3080156 | 524 | 0 | 488 | weekly | |
30395 | 30395 | United States | New Hampshire | NH | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 1359711 | 250 | 0 | 235 | weekly | |
30703 | 30703 | United States | New Jersey | NJ | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 8882190 | 1632 | 0 | 1468 | weekly | |
31011 | 31011 | United States | New Mexico | NM | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 2096829 | 352 | 0 | 365 | weekly | |
31319 | 31319 | United States | New York | NY | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 19453561 | 3176 | 0 | 3084 | weekly | |
31627 | 31627 | United States | North Carolina | NC | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 10488084 | 1827 | 0 | 1874 | weekly | |
31935 | 31935 | United States | North Dakota | ND | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 762062 | 121 | 0 | 141 | weekly | |
32243 | 32243 | United States | Ohio | OH | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 11689100 | 2534 | 0 | 2341 | weekly | |
32551 | 32551 | United States | Oklahoma | OK | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 3956971 | 845 | 0 | 809 | weekly | |
32859 | 32859 | United States | Oregon | OR | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 4217737 | 816 | 0 | 720 | weekly | |
33167 | 33167 | United States | Pennsylvania | PA | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 12801989 | 2836 | 0 | 2686 | weekly | |
33475 | 33475 | United States | Rhode Island | RI | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 1059361 | 216 | 0 | 211 | weekly | |
33783 | 33783 | United States | South Carolina | SC | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 5148714 | 970 | 0 | 968 | weekly | |
34091 | 34091 | United States | South Dakota | SD | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 884659 | 181 | 0 | 151 | weekly | |
34399 | 34399 | United States | Tennessee | TN | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 6833174 | 1506 | 0 | 1469 | weekly | |
34707 | 34707 | United States | Texas | TX | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 28995881 | 4089 | 0 | 4179 | weekly | |
35015 | 35015 | United States | Utah | UT | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 3205958 | 355 | 0 | 371 | weekly | |
35323 | 35323 | United States | Vermont | VT | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 623989 | 122 | 0 | 114 | weekly | |
35631 | 35631 | United States | Virginia | VA | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 8535519 | 1370 | 0 | 1334 | weekly | |
35939 | 35939 | United States | Washington | WA | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 7614893 | 1250 | 0 | 1083 | weekly | |
36247 | 36247 | United States | West Virginia | WV | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 1792147 | 478 | 0 | 436 | weekly | |
36555 | 36555 | United States | Wisconsin | WI | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 5822434 | 1098 | 0 | 1033 | weekly | |
36863 | 36863 | United States | Wyoming | WY | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 578759 | 94 | 0 | 88 | weekly | |
37171 | 37171 | United States | United States | USA | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 328300544 | 58541 | 0 | 55553 | 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]);