economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
51 rows where country = "United States" and start_date = "2020-08-02" sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 | excess_deaths | non_covid_deaths | covid_deaths_per_100k | excess_deaths_per_100k | excess_deaths_pct_change | cadence | month | total_deaths_per_7_days | covid_deaths_per_7_days | expected_deaths_per_7_days | excess_deaths_per_7_days | non_covid_deaths_per_7_days | covid_deaths_per_100k_per_7_days | excess_deaths_per_100k_per_7_days | quarter |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2309 | 2309 | United States | Alabama | AL | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 4903185 | 1379 | 149 | 976.35839598103 | 402.64160401897 | 1230 | 3.03884107982872 | 8.21183789759044 | 0.412391193312167 | weekly | |||||||||
2461 | 2461 | United States | Alaska | AK | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 731545 | 101 | 4 | 83.7418546394427 | 17.2581453605573 | 97 | 0.546787962463006 | 2.35913653439738 | 0.206087450951064 | weekly | |||||||||
2613 | 2613 | United States | Arizona | AZ | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 7278717 | 1586 | 391 | 1111.36591479503 | 474.634085204966 | 1195 | 5.37182583139309 | 6.52084818251577 | 0.427072738948001 | weekly | |||||||||
2765 | 2765 | United States | Arkansas | AR | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 3017825 | 736 | 77 | 585.954887219412 | 150.045112780588 | 659 | 2.55150646574934 | 4.97196201836051 | 0.256069393827589 | weekly | |||||||||
2917 | 2917 | United States | California | CA | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 39512223 | 6309 | 1017 | 4745.38095238163 | 1563.61904761837 | 5292 | 2.57388707286857 | 3.95730467409635 | 0.32950337671702 | weekly | |||||||||
3069 | 3069 | United States | Colorado | CO | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 5758736 | 841 | 13 | 726.977443610138 | 114.022556389862 | 828 | 0.225743982707316 | 1.97999276907053 | 0.156844696341101 | weekly | |||||||||
3221 | 3221 | United States | Connecticut | CT | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 3565287 | 593 | 9 | 560.929824562198 | 32.0701754378019 | 584 | 0.252434095768447 | 0.899511748641889 | 0.057173239919686 | weekly | |||||||||
3373 | 3373 | United States | Delaware | DE | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 973764 | 197 | 5 | 180.877192985443 | 16.1228070145575 | 192 | 0.513471436610924 | 1.6557201759931 | 0.0891367604087878 | weekly | |||||||||
3525 | 3525 | United States | District of Columbia | DC | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 705749 | 118 | 5 | 108.52130325859 | 9.47869674141003 | 113 | 0.7084671745904 | 1.3430690998372 | 0.0873441108500488 | weekly | |||||||||
3677 | 3677 | United States | Florida | FL | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 21477737 | 5585 | 1088 | 3825.90726817149 | 1759.09273182851 | 4497 | 5.06571060070249 | 8.19030762798014 | 0.459784466409515 | weekly | |||||||||
3829 | 3829 | United States | Georgia | GA | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 10617423 | 2192 | 358 | 1573.0300751885 | 618.969924811504 | 1834 | 3.37181630608482 | 5.82975666328359 | 0.393488932331655 | weekly | |||||||||
3981 | 3981 | United States | Hawaii | HI | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 1415872 | 231 | 5 | 217.53132832173 | 13.4686716782696 | 226 | 0.35313926682638 | 0.951263368317873 | 0.0619160089821609 | weekly | |||||||||
4133 | 4133 | United States | Idaho | ID | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 1787065 | 312 | 39 | 269.864661654968 | 42.1353383450324 | 273 | 2.18234927101141 | 2.35779551079745 | 0.156135071878748 | weekly | |||||||||
4285 | 4285 | United States | Illinois | IL | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 12671821 | 2138 | 127 | 1861.70175438653 | 276.298245613472 | 2011 | 1.00222375300282 | 2.18041468241598 | 0.148411658829058 | weekly | |||||||||
4437 | 4437 | United States | Indiana | IN | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 6732219 | 1344 | 62 | 1183.79448621694 | 160.20551378306 | 1282 | 0.920944490962044 | 2.3796836345202 | 0.135332201364638 | weekly | |||||||||
4589 | 4589 | United States | Iowa | IA | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 3155070 | 649 | 53 | 536.065162907969 | 112.934837092031 | 596 | 1.67983594658756 | 3.57947167866421 | 0.210673710784335 | weekly | |||||||||
4741 | 4741 | United States | Kansas | KS | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 2913314 | 601 | 22 | 472.393483710077 | 128.606516289923 | 579 | 0.755153752736574 | 4.41444060921422 | 0.272244475685556 | weekly | |||||||||
4893 | 4893 | United States | Kentucky | KY | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 4467673 | 1007 | 35 | 885.939849625361 | 121.060150374639 | 972 | 0.7834055894422 | 2.70969138463444 | 0.136646015444313 | weekly | |||||||||
5045 | 5045 | United States | Louisiana | LA | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 4648794 | 1243 | 254 | 833.949874687665 | 409.050125312335 | 989 | 5.46378264986575 | 8.79905896695648 | 0.490497256163668 | weekly | |||||||||
5197 | 5197 | United States | Maine | ME | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 1344212 | 276 | 2 | 281.245614035869 | -5.24561403586881 | 274 | 0.148786054580676 | -0.390237108124969 | -0.0186513629869436 | weekly | |||||||||
5349 | 5349 | United States | Maryland | MD | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 6045680 | 1007 | 69 | 899.774436091145 | 107.225563908855 | 938 | 1.14131082028821 | 1.77358980145915 | 0.119169382467312 | weekly | |||||||||
5501 | 5501 | United States | Massachusetts | MA | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 6949503 | 996 | 95 | 1062.7919799507 | -66.7919799506976 | 901 | 1.36700423037446 | -0.961104412080945 | -0.0628457696432712 | weekly | |||||||||
5653 | 5653 | United States | Michigan | MI | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 9986857 | 1868 | 61 | 1764.19799498839 | 103.802005011605 | 1807 | 0.610802778091245 | 1.03938611528738 | 0.0588380699368658 | weekly | |||||||||
5805 | 5805 | United States | Minnesota | MN | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 5639632 | 897 | 42 | 878.60651629157 | 18.3934837084302 | 855 | 0.744729443339565 | 0.326146878172727 | 0.0209348364340223 | weekly | |||||||||
5957 | 5957 | United States | Mississippi | MS | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 2976149 | 915 | 202 | 593.290726817814 | 321.709273182186 | 713 | 6.78729458773737 | 10.8095822212593 | 0.542245578163193 | weekly | |||||||||
6109 | 6109 | United States | Missouri | MO | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 6137428 | 1355 | 48 | 1205.39348371012 | 149.606516289884 | 1307 | 0.782086567858719 | 2.4376093094678 | 0.124114256723377 | weekly | |||||||||
6261 | 6261 | United States | Montana | MT | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 1068778 | 216 | 15 | 192.090225564792 | 23.909774435208 | 201 | 1.40347200260484 | 2.23711326722744 | 0.124471582897607 | weekly | |||||||||
6413 | 6413 | United States | Nebraska | NE | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 1934408 | 381 | 13 | 293.593984963519 | 87.4060150364805 | 368 | 0.672040231429978 | 4.51848912103758 | 0.297710510136443 | weekly | |||||||||
6565 | 6565 | United States | Nevada | NV | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 3080156 | 694 | 117 | 467.187969925709 | 226.812030074291 | 577 | 3.79850890669174 | 7.36365398617118 | 0.485483455642828 | weekly | |||||||||
6717 | 6717 | United States | New Hampshire | NH | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 1359711 | 233 | 3 | 231.488721805387 | 1.51127819461314 | 230 | 0.220635120257172 | 0.111147015403504 | 0.00652851760045436 | weekly | |||||||||
6869 | 6869 | United States | New Jersey | NJ | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 8882190 | 1344 | 46 | 1337.45112782059 | 6.54887217941382 | 1298 | 0.517890295073625 | 0.0737303770738277 | 0.00489653195035644 | weekly | |||||||||
7021 | 7021 | United States | New Mexico | NM | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 2096829 | 433 | 30 | 345.641604010911 | 87.358395989089 | 403 | 1.43073183364023 | 4.16621460257794 | 0.252742710875544 | weekly | |||||||||
7173 | 7173 | United States | New York | NY | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 19453561 | 2841 | 59 | 2755.89974937429 | 85.1002506257119 | 2782 | 0.303286375178303 | 0.437453331170123 | 0.0308792983652737 | weekly | |||||||||
7325 | 7325 | United States | North Carolina | NC | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 10488084 | 2061 | 197 | 1758.37092731891 | 302.629072681088 | 1864 | 1.87832210344616 | 2.88545622518935 | 0.172107641214544 | weekly | |||||||||
7477 | 7477 | United States | North Dakota | ND | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 762062 | 154 | 9 | 130.451127820462 | 23.5488721795382 | 145 | 1.18100626983106 | 3.09015174349832 | 0.180518731980211 | weekly | |||||||||
7629 | 7629 | United States | Ohio | OH | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 11689100 | 2584 | 156 | 2194.81704260854 | 389.182957391457 | 2428 | 1.33457665688547 | 3.32945186020701 | 0.177319088487172 | weekly | |||||||||
7781 | 7781 | United States | Oklahoma | OK | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 3956971 | 814 | 73 | 715.598997494546 | 98.4010025054536 | 741 | 1.84484546386617 | 2.48677593304206 | 0.137508580713465 | weekly | |||||||||
7933 | 7933 | United States | Oregon | OR | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 4217737 | 768 | 30 | 671.055137845551 | 96.9448621544485 | 738 | 0.711281903067925 | 2.29850420152913 | 0.144466313849699 | weekly | |||||||||
8085 | 8085 | United States | Pennsylvania | PA | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 12801989 | 2540 | 109 | 2385.95238095353 | 154.047619046466 | 2431 | 0.851430195729742 | 1.20331004070122 | 0.0645644147285545 | weekly | |||||||||
8237 | 8237 | United States | Rhode Island | RI | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 1059361 | 209 | 5 | 178.022556391892 | 30.9774436081078 | 204 | 0.471982638590622 | 2.92416311418939 | 0.17400853148022 | weekly | |||||||||
8389 | 8389 | United States | South Carolina | SC | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 5148714 | 1368 | 233 | 961.804511279189 | 406.195488720811 | 1135 | 4.52540187705124 | 7.88926106054465 | 0.422326454032302 | weekly | |||||||||
8541 | 8541 | United States | South Dakota | SD | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 884659 | 187 | 12 | 157.94235589049 | 29.0576441095102 | 175 | 1.35645486000821 | 3.28461521439449 | 0.183976261121858 | weekly | |||||||||
8693 | 8693 | United States | Tennessee | TN | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 6833174 | 1707 | 146 | 1376.6942355899 | 330.305764410095 | 1561 | 2.13663518593263 | 4.83385560517111 | 0.239926743260141 | weekly | |||||||||
8845 | 8845 | United States | Texas | TX | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 28995881 | 5712 | 1420 | 3761.11779448676 | 1950.88220551324 | 4292 | 4.89724730212543 | 6.72813564627761 | 0.518697449033088 | weekly | |||||||||
8997 | 8997 | United States | Utah | UT | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 3205958 | 449 | 26 | 355.441102757772 | 93.5588972422285 | 423 | 0.810990037923142 | 2.9182820624047 | 0.263219128334709 | weekly | |||||||||
9149 | 9149 | United States | Vermont | VT | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 623989 | 106 | 1 | 98.5814536349909 | 7.41854636500908 | 105 | 0.160259235339084 | 1.1888905677839 | 0.0752529618043278 | weekly | |||||||||
9301 | 9301 | United States | Virginia | VA | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 8535519 | 1513 | 110 | 1291.07518797063 | 221.924812029372 | 1403 | 1.28873241334241 | 2.60001544170158 | 0.171891470068605 | weekly | |||||||||
9453 | 9453 | United States | Washington | WA | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 7614893 | 1234 | 78 | 1048.78947368509 | 185.210526314909 | 1156 | 1.02430854904987 | 2.43221442921008 | 0.176594570180173 | weekly | |||||||||
9605 | 9605 | United States | West Virginia | WV | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 1792147 | 494 | 15 | 385.358395990962 | 108.641604009038 | 479 | 0.836984912509967 | 6.06209222842982 | 0.281923542186391 | weekly | |||||||||
9757 | 9757 | United States | Wisconsin | WI | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 5822434 | 1099 | 64 | 1021.7468671688 | 77.2531328311951 | 1035 | 1.09919665899176 | 1.32681852351087 | 0.0756088766342475 | weekly | |||||||||
9909 | 9909 | United States | Wyoming | WY | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 578759 | 106 | 2 | 91.9448621562814 | 14.0551378437186 | 104 | 0.34556698038389 | 2.42849577176659 | 0.152864853066272 | weekly |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [economist_excess_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] FLOAT, [excess_deaths] FLOAT, [non_covid_deaths] INTEGER, [covid_deaths_per_100k] FLOAT, [excess_deaths_per_100k] FLOAT, [excess_deaths_pct_change] FLOAT, [cadence] TEXT , [month] INTEGER, [total_deaths_per_7_days] FLOAT, [covid_deaths_per_7_days] FLOAT, [expected_deaths_per_7_days] FLOAT, [excess_deaths_per_7_days] FLOAT, [non_covid_deaths_per_7_days] FLOAT, [covid_deaths_per_100k_per_7_days] FLOAT, [excess_deaths_per_100k_per_7_days] FLOAT, [quarter] INTEGER);