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 2022-04-09
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21733 | 21733 | United States | Alabama | AL | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 4903185 | 1089 | 63 | 1069 | weekly | |
22041 | 22041 | United States | Alaska | AK | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 731545 | 106 | 7 | 89 | weekly | |
22349 | 22349 | United States | Arizona | AZ | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 7278717 | 1341 | 413 | 1316 | weekly | |
22657 | 22657 | United States | Arkansas | AR | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 3017825 | 696 | 64 | 637 | weekly | |
22965 | 22965 | United States | California | CA | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 39512223 | 5500 | 198 | 5353 | weekly | |
23273 | 23273 | United States | Colorado | CO | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 5758736 | 819 | 47 | 809 | weekly | |
23581 | 23581 | United States | Connecticut | CT | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 3565287 | 634 | 22 | 639 | weekly | |
23889 | 23889 | United States | Delaware | DE | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 973764 | 208 | 25 | 183 | weekly | |
24197 | 24197 | United States | District of Columbia | DC | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 705749 | 119 | 13 | 107 | weekly | |
24505 | 24505 | United States | Florida | FL | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 21477737 | 4294 | 167 | 4337 | weekly | |
24813 | 24813 | United States | Georgia | GA | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 10617423 | 1803 | 275 | 1746 | weekly | |
25121 | 25121 | United States | Hawaii | HI | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 1415872 | 275 | 3 | 245 | weekly | |
25429 | 25429 | United States | Idaho | ID | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 1787065 | 291 | 19 | 302 | weekly | |
25737 | 25737 | United States | Illinois | IL | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 12671821 | 2052 | 80 | 2068 | weekly | |
26045 | 26045 | United States | Indiana | IN | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 6732219 | 1273 | 0 | 1326 | weekly | |
26353 | 26353 | United States | Iowa | IA | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 3155070 | 596 | 9 | 605 | weekly | |
26661 | 26661 | United States | Kansas | KS | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 2913314 | 513 | 104 | 530 | weekly | |
26969 | 26969 | United States | Kentucky | KY | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 4467673 | 968 | 133 | 950 | weekly | |
27277 | 27277 | United States | Louisiana | LA | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 4648794 | 957 | 39 | 920 | weekly | |
27585 | 27585 | United States | Maine | ME | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 1344212 | 324 | 20 | 305 | weekly | |
27893 | 27893 | United States | Maryland | MD | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 6045680 | 977 | 22 | 1001 | weekly | |
28201 | 28201 | United States | Massachusetts | MA | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 6949503 | 1070 | 28 | 1175 | weekly | |
28509 | 28509 | United States | Michigan | MI | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 9986857 | 1972 | 70 | 1920 | weekly | |
28817 | 28817 | United States | Minnesota | MN | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 5639632 | 901 | 30 | 906 | weekly | |
29125 | 29125 | United States | Mississippi | MS | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 2976149 | 658 | 19 | 636 | weekly | |
29433 | 29433 | United States | Missouri | MO | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 6137428 | 1318 | 0 | 1290 | weekly | |
29741 | 29741 | United States | Montana | MT | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 1068778 | 207 | 6 | 204 | weekly | |
30049 | 30049 | United States | Nebraska | NE | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 1934408 | 319 | 13 | 347 | weekly | |
30357 | 30357 | United States | Nevada | NV | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 3080156 | 601 | 45 | 537 | weekly | |
30665 | 30665 | United States | New Hampshire | NH | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 1359711 | 267 | 8 | 251 | weekly | |
30973 | 30973 | United States | New Jersey | NJ | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 8882190 | 1401 | 53 | 1470 | weekly | |
31281 | 31281 | United States | New Mexico | NM | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 2096829 | 383 | 81 | 391 | weekly | |
31589 | 31589 | United States | New York | NY | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 19453561 | 3057 | 61 | 3012 | weekly | |
31897 | 31897 | United States | North Carolina | NC | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 10488084 | 1852 | 42 | 1969 | weekly | |
32205 | 32205 | United States | North Dakota | ND | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 762062 | 131 | 0 | 147 | weekly | |
32513 | 32513 | United States | Ohio | OH | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 11689100 | 2410 | 124 | 2463 | weekly | |
32821 | 32821 | United States | Oklahoma | OK | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 3956971 | 796 | 137 | 788 | weekly | |
33129 | 33129 | United States | Oregon | OR | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 4217737 | 800 | 149 | 725 | weekly | |
33437 | 33437 | United States | Pennsylvania | PA | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 12801989 | 2601 | 104 | 2621 | weekly | |
33745 | 33745 | United States | Rhode Island | RI | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 1059361 | 217 | 3 | 218 | weekly | |
34053 | 34053 | United States | South Carolina | SC | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 5148714 | 1061 | 59 | 1036 | weekly | |
34361 | 34361 | United States | South Dakota | SD | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 884659 | 164 | 10 | 163 | weekly | |
34669 | 34669 | United States | Tennessee | TN | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 6833174 | 1614 | 131 | 1541 | weekly | |
34977 | 34977 | United States | Texas | TX | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 28995881 | 4304 | 175 | 4145 | weekly | |
35285 | 35285 | United States | Utah | UT | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 3205958 | 378 | 16 | 395 | weekly | |
35593 | 35593 | United States | Vermont | VT | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 623989 | 129 | 3 | 109 | weekly | |
35901 | 35901 | United States | Virginia | VA | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 8535519 | 1414 | 75 | 1412 | weekly | |
36209 | 36209 | United States | Washington | WA | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 7614893 | 1241 | 56 | 1201 | weekly | |
36517 | 36517 | United States | West Virginia | WV | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 1792147 | 502 | -82 | 463 | weekly | |
36825 | 36825 | United States | Wisconsin | WI | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 5822434 | 1068 | 33 | 1067 | weekly | |
37133 | 37133 | United States | Wyoming | WY | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 578759 | 105 | 5 | 96 | weekly | |
37441 | 37441 | United States | United States | USA | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 328300544 | 57776 | 3177 | 57235 | 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]);