economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
51 rows where country = "United States", "end_date" is on date 2020-05-30 and "start_date" is on date 2020-05-24 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2299 | 2299 | United States | Alabama | AL | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 4903185 | 1109 | 67 | 983.691729315106 | 125.308270684894 | 1042 | 1.36645874059412 | 2.55565047382251 | 0.127385711346928 | weekly | |||||||||
2451 | 2451 | United States | Alaska | AK | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 731545 | 97 | 0 | 77.4085213060518 | 19.5914786939482 | 97 | 0.0 | 2.67809617917533 | 0.253092015754814 | weekly | |||||||||
2603 | 2603 | United States | Arizona | AZ | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 7278717 | 1310 | 101 | 1163.36591479498 | 146.634085205017 | 1209 | 1.38760718406829 | 2.01455950554221 | 0.126042961496648 | weekly | |||||||||
2755 | 2755 | United States | Arkansas | AR | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 3017825 | 610 | 18 | 587.621553886022 | 22.3784461139785 | 592 | 0.596456056928417 | 0.741542207184926 | 0.038083092708201 | weekly | |||||||||
2907 | 2907 | United States | California | CA | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 39512223 | 5593 | 500 | 4948.38095238157 | 644.619047618431 | 5093 | 1.26543120593341 | 1.63144211759088 | 0.130268678547917 | weekly | |||||||||
3059 | 3059 | United States | Colorado | CO | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 5758736 | 834 | 117 | 741.310776943418 | 92.6892230565818 | 717 | 2.03169584436585 | 1.60954110514151 | 0.125034231174622 | weekly | |||||||||
3211 | 3211 | United States | Connecticut | CT | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 3565287 | 759 | 238 | 560.596491228808 | 198.403508771192 | 521 | 6.67547942143227 | 5.56486781488256 | 0.353915002814767 | weekly | |||||||||
3363 | 3363 | United States | Delaware | DE | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 973764 | 226 | 37 | 165.543859652051 | 60.4561403479492 | 189 | 3.79968863092084 | 6.20850024728263 | 0.36519711739849 | weekly | |||||||||
3515 | 3515 | United States | District of Columbia | DC | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 705749 | 169 | 35 | 112.187969925198 | 56.8120300748016 | 134 | 4.9592702221328 | 8.0498916859679 | 0.506400375304778 | weekly | |||||||||
3667 | 3667 | United States | Florida | FL | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 21477737 | 4211 | 214 | 3969.24060150478 | 241.759398495225 | 3997 | 0.996380577711702 | 1.12562789317713 | 0.0609082247126997 | weekly | |||||||||
3819 | 3819 | United States | Georgia | GA | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 10617423 | 1785 | 180 | 1623.69674185511 | 161.303258144888 | 1605 | 1.69532663434432 | 1.51923172077526 | 0.0993432172319293 | weekly | |||||||||
3971 | 3971 | United States | Hawaii | HI | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 1415872 | 200 | 0 | 213.864661655007 | -13.864661655007 | 200 | 0.0 | -0.979231290328998 | -0.0648291379590921 | weekly | |||||||||
4123 | 4123 | United States | Idaho | ID | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 1787065 | 279 | 4 | 277.86466165491 | 1.13533834508968 | 275 | 0.223830694462708 | 0.0635308925578912 | 0.00408594003400009 | weekly | |||||||||
4275 | 4275 | United States | Illinois | IL | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 12671821 | 2547 | 540 | 1931.36842105313 | 615.631578946873 | 2007 | 4.26142383166555 | 4.85827237416685 | 0.318754087638641 | weekly | |||||||||
4427 | 4427 | United States | Indiana | IN | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 6732219 | 1383 | 131 | 1182.46115288355 | 200.53884711645 | 1252 | 1.94586658574238 | 2.97879268509313 | 0.169594448517328 | weekly | |||||||||
4579 | 4579 | United States | Iowa | IA | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 3155070 | 632 | 83 | 538.73182957458 | 93.2681704254201 | 549 | 2.63068648239183 | 2.95613632741651 | 0.17312541287763 | weekly | |||||||||
4731 | 4731 | United States | Kansas | KS | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 2913314 | 506 | 9 | 481.060150376687 | 24.9398496233126 | 497 | 0.308926535210417 | 0.856064592533198 | 0.0518435160421911 | weekly | |||||||||
4883 | 4883 | United States | Kentucky | KY | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 4467673 | 987 | 40 | 863.606516291972 | 123.393483708028 | 947 | 0.895320673648228 | 2.76191842393184 | 0.142881603346206 | weekly | |||||||||
5035 | 5035 | United States | Louisiana | LA | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 4648794 | 1054 | 118 | 858.949874687608 | 195.050125312392 | 936 | 2.53829272710299 | 4.19571452966925 | 0.227079752917282 | weekly | |||||||||
5187 | 5187 | United States | Maine | ME | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 1344212 | 302 | 12 | 268.91228070248 | 33.0877192975205 | 290 | 0.892716327484057 | 2.46149560467549 | 0.123042797491753 | weekly | |||||||||
5339 | 5339 | United States | Maryland | MD | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 6045680 | 1265 | 320 | 881.77443609109 | 383.22556390891 | 945 | 5.29303568829313 | 6.33883308261288 | 0.434607251269101 | weekly | |||||||||
5491 | 5491 | United States | Massachusetts | MA | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 6949503 | 1360 | 464 | 1095.79197995064 | 264.208020049359 | 896 | 6.67673645151315 | 3.80182611690878 | 0.241111474516596 | weekly | |||||||||
5643 | 5643 | United States | Michigan | MI | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 9986857 | 1962 | 244 | 1816.53132832167 | 145.468671678326 | 1718 | 2.44321111236498 | 1.45660112764533 | 0.0800804640197026 | weekly | |||||||||
5795 | 5795 | United States | Minnesota | MN | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 5639632 | 1017 | 176 | 836.273182958183 | 180.726817041817 | 841 | 3.12077100066104 | 3.20458528219247 | 0.216109784128823 | weekly | |||||||||
5947 | 5947 | United States | Mississippi | MS | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 2976149 | 750 | 107 | 604.290726817757 | 145.709273182243 | 643 | 3.59525010340544 | 4.8958998081831 | 0.241124456682564 | weekly | |||||||||
6099 | 6099 | United States | Missouri | MO | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 6137428 | 1244 | 94 | 1175.06015037672 | 68.9398496232764 | 1150 | 1.53158619538999 | 1.12326938292842 | 0.0586692090623397 | weekly | |||||||||
6251 | 6251 | United States | Montana | MT | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 1068778 | 180 | 1 | 176.756892231402 | 3.24310776859784 | 179 | 0.0935648001736563 | 0.303440730310489 | 0.0183478433437951 | weekly | |||||||||
6403 | 6403 | United States | Nebraska | NE | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 1934408 | 375 | 21 | 312.260651630128 | 62.739348369872 | 354 | 1.0856034507715 | 3.24333586140421 | 0.200919802230435 | weekly | |||||||||
6555 | 6555 | United States | Nevada | NV | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 3080156 | 543 | 22 | 495.854636592322 | 47.1453634076778 | 521 | 0.714249538010412 | 1.53061609242122 | 0.0950790008371736 | weekly | |||||||||
6707 | 6707 | United States | New Hampshire | NH | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 1359711 | 250 | 34 | 226.155388471996 | 23.8446115280042 | 216 | 2.50053136291462 | 1.75365291065559 | 0.1054346380562 | weekly | |||||||||
6859 | 6859 | United States | New Jersey | NJ | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 8882190 | 1746 | 553 | 1342.11779448719 | 403.882205512805 | 1193 | 6.22594202555901 | 4.54710162147855 | 0.300929029606618 | weekly | |||||||||
7011 | 7011 | United States | New Mexico | NM | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 2096829 | 433 | 43 | 348.308270677522 | 84.6917293224778 | 390 | 2.05071562821766 | 4.03903843959034 | 0.243151645976529 | weekly | |||||||||
7163 | 7163 | United States | New York | NY | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 19453561 | 3281 | 671 | 2705.23308270756 | 575.766917292437 | 2610 | 3.44923996177358 | 2.95969934395269 | 0.212834495102423 | weekly | |||||||||
7315 | 7315 | United States | North Carolina | NC | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 10488084 | 1991 | 144 | 1768.37092731886 | 222.629072681141 | 1847 | 1.37298671520937 | 2.12268582785131 | 0.125895008361556 | weekly | |||||||||
7467 | 7467 | United States | North Dakota | ND | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 762062 | 143 | 7 | 146.784461153739 | -3.78446115373913 | 136 | 0.918560432090827 | -0.496608038944224 | -0.0257824372143545 | weekly | |||||||||
7619 | 7619 | United States | Ohio | OH | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 11689100 | 2530 | 195 | 2204.15037594181 | 325.849624058188 | 2335 | 1.66822082110684 | 2.78763655078824 | 0.147834570460718 | weekly | |||||||||
7771 | 7771 | United States | Oklahoma | OK | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 3956971 | 740 | 24 | 696.59899749449 | 43.4010025055104 | 716 | 0.606524536065592 | 1.09682387122651 | 0.0623041414954861 | weekly | |||||||||
7923 | 7923 | United States | Oregon | OR | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 4217737 | 748 | 6 | 690.38847117883 | 57.6115288211697 | 742 | 0.142256380613585 | 1.36593459528581 | 0.0834479879462626 | weekly | |||||||||
8075 | 8075 | United States | Pennsylvania | PA | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 12801989 | 2792 | 440 | 2413.2857142868 | 378.714285713203 | 2352 | 3.43696592771639 | 2.95824567349029 | 0.156928905463283 | weekly | |||||||||
8227 | 8227 | United States | Rhode Island | RI | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 1059361 | 254 | 121 | 167.355889725171 | 86.6441102748294 | 133 | 11.4219798538931 | 8.17890315717016 | 0.517723698981345 | weekly | |||||||||
8379 | 8379 | United States | South Carolina | SC | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 5148714 | 1048 | 58 | 945.804511279137 | 102.195488720863 | 990 | 1.12649488784967 | 1.98487406216121 | 0.108051386414567 | weekly | |||||||||
8531 | 8531 | United States | South Dakota | SD | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 884659 | 157 | 10 | 151.942355890435 | 5.05764410956516 | 147 | 1.13037905000684 | 0.571705494384295 | 0.0332865979333123 | weekly | |||||||||
8683 | 8683 | United States | Tennessee | TN | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 6833174 | 1467 | 45 | 1417.69423558985 | 49.305764410145 | 1422 | 0.658551940869646 | 0.721564596630277 | 0.0347788424135269 | weekly | |||||||||
8835 | 8835 | United States | Texas | TX | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 28995881 | 4156 | 205 | 3814.11779448672 | 341.882205513282 | 3951 | 0.706996969673037 | 1.17907162577085 | 0.0896359850258088 | weekly | |||||||||
8987 | 8987 | United States | Utah | UT | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 3205958 | 390 | 11 | 365.441102757717 | 24.5588972422828 | 379 | 0.34311116989056 | 0.766039269456518 | 0.0672034345807155 | weekly | |||||||||
9139 | 9139 | United States | Vermont | VT | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 623989 | 134 | 1 | 96.9147869682665 | 37.0852130317335 | 133 | 0.160259235339084 | 5.94324788285266 | 0.382657943043063 | weekly | |||||||||
9291 | 9291 | United States | Virginia | VA | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 8535519 | 1443 | 204 | 1306.40852130391 | 136.591478696088 | 1239 | 2.39001283928956 | 1.60027150892744 | 0.104554950820251 | weekly | |||||||||
9443 | 9443 | United States | Washington | WA | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 7614893 | 1058 | 68 | 1060.78947368504 | -2.78947368503646 | 990 | 0.892986940197321 | -0.0366318172170831 | -0.00262962044235437 | weekly | |||||||||
9595 | 9595 | United States | West Virginia | WV | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 1792147 | 412 | 2 | 438.025062657572 | -26.0250626575724 | 410 | 0.111597988334662 | -1.45217231943431 | -0.059414551531992 | weekly | |||||||||
9747 | 9747 | United States | Wisconsin | WI | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 5822434 | 1139 | 91 | 978.746867168752 | 160.253132831248 | 1048 | 1.5629202495039 | 2.75233919064171 | 0.163732971421729 | weekly | |||||||||
9899 | 9899 | United States | Wyoming | WY | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 578759 | 84 | 3 | 82.6115288228924 | 1.38847117710759 | 81 | 0.518350470575835 | 0.239904896011568 | 0.0168072325605337 | 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);