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 2018-11-10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21555 | 21555 | United States | Alabama | AL | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 4903185 | 963 | 0 | 989 | weekly | |
21863 | 21863 | United States | Alaska | AK | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 731545 | 92 | 0 | 89 | weekly | |
22171 | 22171 | United States | Arizona | AZ | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 7278717 | 1102 | 0 | 1150 | weekly | |
22479 | 22479 | United States | Arkansas | AR | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 3017825 | 583 | 0 | 580 | weekly | |
22787 | 22787 | United States | California | CA | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 39512223 | 5057 | 0 | 5177 | weekly | |
23095 | 23095 | United States | Colorado | CO | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 5758736 | 706 | 0 | 792 | weekly | |
23403 | 23403 | United States | Connecticut | CT | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 3565287 | 576 | 0 | 591 | weekly | |
23711 | 23711 | United States | Delaware | DE | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 973764 | 193 | 0 | 176 | weekly | |
24019 | 24019 | United States | District of Columbia | DC | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 705749 | 125 | 0 | 111 | weekly | |
24327 | 24327 | United States | Florida | FL | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 21477737 | 3814 | 0 | 3941 | weekly | |
24635 | 24635 | United States | Georgia | GA | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 10617423 | 1578 | 0 | 1644 | weekly | |
24943 | 24943 | United States | Hawaii | HI | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 1415872 | 222 | 0 | 213 | weekly | |
25251 | 25251 | United States | Idaho | ID | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 1787065 | 279 | 0 | 269 | weekly | |
25559 | 25559 | United States | Illinois | IL | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 12671821 | 2052 | 0 | 2035 | weekly | |
25867 | 25867 | United States | Indiana | IN | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 6732219 | 1197 | 0 | 1237 | weekly | |
26175 | 26175 | United States | Iowa | IA | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 3155070 | 560 | 0 | 557 | weekly | |
26483 | 26483 | United States | Kansas | KS | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 2913314 | 490 | 0 | 499 | weekly | |
26791 | 26791 | United States | Kentucky | KY | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 4467673 | 914 | 0 | 945 | weekly | |
27099 | 27099 | United States | Louisiana | LA | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 4648794 | 889 | 0 | 832 | weekly | |
27407 | 27407 | United States | Maine | ME | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 1344212 | 295 | 0 | 281 | weekly | |
27715 | 27715 | United States | Maryland | MD | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 6045680 | 930 | 0 | 921 | weekly | |
28023 | 28023 | United States | Massachusetts | MA | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 6949503 | 1107 | 0 | 1131 | weekly | |
28331 | 28331 | United States | Michigan | MI | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 9986857 | 1907 | 0 | 1865 | weekly | |
28639 | 28639 | United States | Minnesota | MN | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 5639632 | 946 | 0 | 879 | weekly | |
28947 | 28947 | United States | Mississippi | MS | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 2976149 | 589 | 0 | 591 | weekly | |
29255 | 29255 | United States | Missouri | MO | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 6137428 | 1211 | 0 | 1195 | weekly | |
29563 | 29563 | United States | Montana | MT | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 1068778 | 204 | 0 | 197 | weekly | |
29871 | 29871 | United States | Nebraska | NE | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 1934408 | 335 | 0 | 320 | weekly | |
30179 | 30179 | United States | Nevada | NV | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 3080156 | 491 | 0 | 496 | weekly | |
30487 | 30487 | United States | New Hampshire | NH | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 1359711 | 220 | 0 | 242 | weekly | |
30795 | 30795 | United States | New Jersey | NJ | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 8882190 | 1374 | 0 | 1321 | weekly | |
31103 | 31103 | United States | New Mexico | NM | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 2096829 | 336 | 0 | 354 | weekly | |
31411 | 31411 | United States | New York | NY | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 19453561 | 2982 | 0 | 2898 | weekly | |
31719 | 31719 | United States | North Carolina | NC | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 10488084 | 1838 | 0 | 1842 | weekly | |
32027 | 32027 | United States | North Dakota | ND | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 762062 | 139 | 0 | 126 | weekly | |
32335 | 32335 | United States | Ohio | OH | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 11689100 | 2432 | 0 | 2339 | weekly | |
32643 | 32643 | United States | Oklahoma | OK | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 3956971 | 747 | 0 | 735 | weekly | |
32951 | 32951 | United States | Oregon | OR | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 4217737 | 711 | 0 | 723 | weekly | |
33259 | 33259 | United States | Pennsylvania | PA | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 12801989 | 2569 | 0 | 2520 | weekly | |
33567 | 33567 | United States | Rhode Island | RI | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 1059361 | 188 | 0 | 202 | weekly | |
33875 | 33875 | United States | South Carolina | SC | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 5148714 | 955 | 0 | 957 | weekly | |
34183 | 34183 | United States | South Dakota | SD | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 884659 | 144 | 0 | 163 | weekly | |
34491 | 34491 | United States | Tennessee | TN | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 6833174 | 1423 | 0 | 1415 | weekly | |
34799 | 34799 | United States | Texas | TX | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 28995881 | 3895 | 0 | 3855 | weekly | |
35107 | 35107 | United States | Utah | UT | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 3205958 | 347 | 0 | 381 | weekly | |
35415 | 35415 | United States | Vermont | VT | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 623989 | 121 | 0 | 117 | weekly | |
35723 | 35723 | United States | Virginia | VA | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 8535519 | 1287 | 0 | 1275 | weekly | |
36031 | 36031 | United States | Washington | WA | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 7614893 | 1074 | 0 | 1130 | weekly | |
36339 | 36339 | United States | West Virginia | WV | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 1792147 | 442 | 0 | 424 | weekly | |
36647 | 36647 | United States | Wisconsin | WI | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 5822434 | 975 | 0 | 1034 | weekly | |
36955 | 36955 | United States | Wyoming | WY | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 578759 | 89 | 0 | 86 | weekly | |
37263 | 37263 | United States | United States | USA | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 328300544 | 53695 | 0 | 53842 | 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]);