economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
16,429 rows where country = "United States" sorted by week
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: year, start_date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | United States | United States | 0 | 2014-12-29 | 2015-01-04 | 7 | 2015 | 1 | 338289856 | 61889 | 0 | TBC | weekly | |
53 | 53 | United States | United States | 0 | 2016-01-04 | 2016-01-10 | 7 | 2016 | 1 | 338289856 | 55989 | 0 | TBC | weekly | |
105 | 105 | United States | United States | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 338289856 | 59901 | 0 | TBC | weekly | |
157 | 157 | United States | United States | 0 | 2018-01-01 | 2018-01-07 | 7 | 2018 | 1 | 338289856 | 66320 | 0 | TBC | weekly | |
209 | 209 | United States | United States | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 338289856 | 58466 | 0 | TBC | weekly | |
261 | 261 | United States | United States | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 338289856 | 60180 | 0 | TBC | weekly | |
314 | 314 | United States | United States | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 338289856 | 87074 | 22905 | TBC | weekly | |
366 | 366 | United States | United States | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 338289856 | 79800 | 12491 | TBC | weekly | |
21459 | 21459 | United States | Alabama | AL | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 4903185 | 1121 | 0 | 1033 | weekly | |
21511 | 21511 | United States | Alabama | AL | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 4903185 | 1248 | 0 | 1101 | weekly | |
21563 | 21563 | United States | Alabama | AL | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 4903185 | 1077 | 0 | 1091 | weekly | |
21615 | 21615 | United States | Alabama | AL | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 4903185 | 1082 | 0 | 1138 | weekly | |
21668 | 21668 | United States | Alabama | AL | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 4903185 | 1811 | 428 | 1141 | weekly | |
21720 | 21720 | United States | Alabama | AL | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 4903185 | 1328 | 130 | 1137 | weekly | |
21767 | 21767 | United States | Alaska | AK | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 731545 | 104 | 0 | 76 | weekly | |
21819 | 21819 | United States | Alaska | AK | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 731545 | 72 | 0 | 87 | weekly | |
21871 | 21871 | United States | Alaska | AK | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 731545 | 93 | 0 | 91 | weekly | |
21923 | 21923 | United States | Alaska | AK | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 731545 | 89 | 0 | 94 | weekly | |
21976 | 21976 | United States | Alaska | AK | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 731545 | 113 | 12 | 89 | weekly | |
22028 | 22028 | United States | Alaska | AK | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 731545 | 116 | 5 | 94 | weekly | |
22075 | 22075 | United States | Arizona | AZ | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 7278717 | 1170 | 0 | 1107 | weekly | |
22127 | 22127 | United States | Arizona | AZ | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 7278717 | 1532 | 0 | 1175 | weekly | |
22179 | 22179 | United States | Arizona | AZ | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 7278717 | 1351 | 0 | 1302 | weekly | |
22231 | 22231 | United States | Arizona | AZ | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 7278717 | 1301 | 0 | 1312 | weekly | |
22284 | 22284 | United States | Arizona | AZ | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 7278717 | 2426 | 975 | 1372 | weekly | |
22336 | 22336 | United States | Arizona | AZ | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 7278717 | 2009 | 387 | 1300 | weekly | |
22383 | 22383 | United States | Arkansas | AR | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 3017825 | 651 | 0 | 632 | weekly | |
22435 | 22435 | United States | Arkansas | AR | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 3017825 | 734 | 0 | 668 | weekly | |
22487 | 22487 | United States | Arkansas | AR | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 3017825 | 692 | 0 | 637 | weekly | |
22539 | 22539 | United States | Arkansas | AR | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 3017825 | 672 | 0 | 675 | weekly | |
22592 | 22592 | United States | Arkansas | AR | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 3017825 | 963 | 281 | 711 | weekly | |
22644 | 22644 | United States | Arkansas | AR | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 3017825 | 872 | 150 | 702 | weekly | |
22691 | 22691 | United States | California | CA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 39512223 | 6061 | 0 | 5169 | weekly | |
22743 | 22743 | United States | California | CA | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 39512223 | 7042 | 0 | 5553 | weekly | |
22795 | 22795 | United States | California | CA | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 39512223 | 5692 | 0 | 5835 | weekly | |
22847 | 22847 | United States | California | CA | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 39512223 | 5888 | 0 | 6114 | weekly | |
22900 | 22900 | United States | California | CA | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 39512223 | 11908 | 4762 | 5992 | weekly | |
22952 | 22952 | United States | California | CA | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 39512223 | 7399 | 622 | 5717 | weekly | |
22999 | 22999 | United States | Colorado | CO | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 5758736 | 793 | 0 | 746 | weekly | |
23051 | 23051 | United States | Colorado | CO | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 5758736 | 867 | 0 | 830 | weekly | |
23103 | 23103 | United States | Colorado | CO | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 5758736 | 836 | 0 | 861 | weekly | |
23155 | 23155 | United States | Colorado | CO | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 5758736 | 854 | 0 | 868 | weekly | |
23208 | 23208 | United States | Colorado | CO | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 5758736 | 1080 | 278 | 868 | weekly | |
23260 | 23260 | United States | Colorado | CO | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 5758736 | 1183 | 190 | 833 | weekly | |
23307 | 23307 | United States | Connecticut | CT | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 3565287 | 656 | 0 | 620 | weekly | |
23359 | 23359 | United States | Connecticut | CT | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 3565287 | 692 | 0 | 665 | weekly | |
23411 | 23411 | United States | Connecticut | CT | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 3565287 | 631 | 0 | 639 | weekly | |
23463 | 23463 | United States | Connecticut | CT | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 3565287 | 633 | 0 | 653 | weekly | |
23516 | 23516 | United States | Connecticut | CT | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 3565287 | 860 | 225 | 680 | weekly | |
23568 | 23568 | United States | Connecticut | CT | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 3565287 | 921 | 217 | 691 | weekly | |
23615 | 23615 | United States | Delaware | DE | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 973764 | 197 | 0 | 174 | weekly | |
23667 | 23667 | United States | Delaware | DE | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 973764 | 221 | 0 | 195 | weekly | |
23719 | 23719 | United States | Delaware | DE | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 973764 | 185 | 0 | 190 | weekly | |
23771 | 23771 | United States | Delaware | DE | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 973764 | 199 | 0 | 201 | weekly | |
23824 | 23824 | United States | Delaware | DE | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 973764 | 276 | 39 | 214 | weekly | |
23876 | 23876 | United States | Delaware | DE | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 973764 | 268 | 44 | 210 | weekly | |
23923 | 23923 | United States | District of Columbia | DC | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 705749 | 133 | 0 | 108 | weekly | |
23975 | 23975 | United States | District of Columbia | DC | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 705749 | 155 | 0 | 123 | weekly | |
24027 | 24027 | United States | District of Columbia | DC | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 705749 | 130 | 0 | 120 | weekly | |
24079 | 24079 | United States | District of Columbia | DC | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 705749 | 132 | 0 | 147 | weekly | |
24132 | 24132 | United States | District of Columbia | DC | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 705749 | 173 | 21 | 147 | weekly | |
24184 | 24184 | United States | District of Columbia | DC | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 705749 | 173 | 14 | 126 | weekly | |
24231 | 24231 | United States | Florida | FL | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 21477737 | 4153 | 0 | 3943 | weekly | |
24283 | 24283 | United States | Florida | FL | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 21477737 | 4480 | 0 | 3735 | weekly | |
24335 | 24335 | United States | Florida | FL | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 21477737 | 4220 | 0 | 3827 | weekly | |
24387 | 24387 | United States | Florida | FL | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 21477737 | 4341 | 0 | 3904 | weekly | |
24440 | 24440 | United States | Florida | FL | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 21477737 | 5495 | 917 | 4526 | weekly | |
24492 | 24492 | United States | Florida | FL | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 21477737 | 5219 | 269 | 4380 | weekly | |
24539 | 24539 | United States | Georgia | GA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 10617423 | 1816 | 0 | 1713 | weekly | |
24591 | 24591 | United States | Georgia | GA | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 10617423 | 1934 | 0 | 1566 | weekly | |
24643 | 24643 | United States | Georgia | GA | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 10617423 | 1803 | 0 | 1619 | weekly | |
24695 | 24695 | United States | Georgia | GA | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 10617423 | 1803 | 0 | 1646 | weekly | |
24748 | 24748 | United States | Georgia | GA | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 10617423 | 2873 | 389 | 1826 | weekly | |
24800 | 24800 | United States | Georgia | GA | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 10617423 | 2392 | 78 | 1829 | weekly | |
24847 | 24847 | United States | Hawaii | HI | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 1415872 | 217 | 0 | 226 | weekly | |
24899 | 24899 | United States | Hawaii | HI | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 1415872 | 268 | 0 | 228 | weekly | |
24951 | 24951 | United States | Hawaii | HI | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 1415872 | 246 | 0 | 220 | weekly | |
25003 | 25003 | United States | Hawaii | HI | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 1415872 | 242 | 0 | 231 | weekly | |
25056 | 25056 | United States | Hawaii | HI | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 1415872 | 215 | 38 | 254 | weekly | |
25108 | 25108 | United States | Hawaii | HI | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 1415872 | 255 | 11 | 253 | weekly | |
25155 | 25155 | United States | Idaho | ID | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 1787065 | 291 | 0 | 259 | weekly | |
25207 | 25207 | United States | Idaho | ID | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 1787065 | 326 | 0 | 278 | weekly | |
25259 | 25259 | United States | Idaho | ID | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 1787065 | 271 | 0 | 283 | weekly | |
25311 | 25311 | United States | Idaho | ID | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 1787065 | 278 | 0 | 299 | weekly | |
25364 | 25364 | United States | Idaho | ID | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 1787065 | 389 | 80 | 311 | weekly | |
25416 | 25416 | United States | Idaho | ID | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 1787065 | 380 | 73 | 305 | weekly | |
25463 | 25463 | United States | Illinois | IL | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 12671821 | 2178 | 0 | 2075 | weekly | |
25515 | 25515 | United States | Illinois | IL | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 12671821 | 2589 | 0 | 2274 | weekly | |
25567 | 25567 | United States | Illinois | IL | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 12671821 | 2176 | 0 | 2204 | weekly | |
25619 | 25619 | United States | Illinois | IL | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 12671821 | 2191 | 0 | 2255 | weekly | |
25672 | 25672 | United States | Illinois | IL | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 12671821 | 2794 | 992 | 2279 | weekly | |
25724 | 25724 | United States | Illinois | IL | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 12671821 | 3381 | 643 | 2210 | weekly | |
25771 | 25771 | United States | Indiana | IN | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 6732219 | 1457 | 0 | 1278 | weekly | |
25823 | 25823 | United States | Indiana | IN | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 6732219 | 1522 | 0 | 1357 | weekly | |
25875 | 25875 | United States | Indiana | IN | 2018-12-30 | 2019-01-05 | 7 | 2019 | 1 | 6732219 | 1326 | 0 | 1336 | weekly | |
25927 | 25927 | United States | Indiana | IN | 2019-12-29 | 2020-01-04 | 7 | 2020 | 1 | 6732219 | 1470 | 0 | 1456 | weekly | |
25980 | 25980 | United States | Indiana | IN | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 6732219 | 1984 | 556 | 1468 | weekly | |
26032 | 26032 | United States | Indiana | IN | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 6732219 | 1917 | 577 | 1400 | weekly | |
26079 | 26079 | United States | Iowa | IA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 3155070 | 655 | 0 | 603 | weekly | |
26131 | 26131 | United States | Iowa | IA | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 3155070 | 667 | 0 | 649 | 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]);