economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where "start_date" is on date 2021-02-14 sorted by non_covid_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths, end_date (date)
country 3
- United States 51
- Canada 1
- South Africa 1
cadence 1
- weekly 53
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2489 | 2489 | United States | Alaska | AK | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 731545 | 88 | 5 | 94.0939849657462 | -6.09398496574623 | 83 | 0.683484953078758 | -0.833029405675144 | -0.0647648727808124 | weekly | |||||||||
9937 | 9937 | United States | Wyoming | WY | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 578759 | 110 | 15 | 96.5977443617755 | 13.4022556382245 | 95 | 2.59175235287918 | 2.3156885056171 | 0.138742946088168 | weekly | |||||||||
3401 | 3401 | United States | Delaware | DE | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 973764 | 205 | 84 | 199.763157898134 | 5.23684210186639 | 121 | 8.62632013506353 | 0.537793767469981 | 0.026215254889677 | weekly | |||||||||
7505 | 7505 | United States | North Dakota | ND | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 762062 | 131 | 6 | 154.813909775338 | -23.813909775338 | 125 | 0.787337513220709 | -3.12493075042949 | -0.153822804487634 | weekly | |||||||||
8265 | 8265 | United States | Rhode Island | RI | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 1059361 | 222 | 94 | 214.778195489618 | 7.22180451038187 | 128 | 8.87327360550369 | 0.681713269639138 | 0.0336244770746803 | weekly | |||||||||
8569 | 8569 | United States | South Dakota | SD | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 884659 | 166 | 21 | 173.261278196222 | -7.26127819622215 | 145 | 2.37379600501436 | -0.820799674928097 | -0.0419094114496754 | weekly | |||||||||
9177 | 9177 | United States | Vermont | VT | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 623989 | 153 | 7 | 117.310150376821 | 35.6898496231785 | 146 | 1.12181464737359 | 5.7196280099775 | 0.304234966100855 | weekly | |||||||||
3553 | 3553 | United States | District of Columbia | DC | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 705749 | 167 | 15 | 125.984962406453 | 41.0150375935474 | 152 | 2.1254015237712 | 5.81156155992392 | 0.325555025061045 | weekly | |||||||||
6289 | 6289 | United States | Montana | MT | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 1068778 | 211 | 12 | 217.362781955742 | -6.3627819557417 | 199 | 1.12277760208388 | -0.595332422237518 | -0.029272637654395 | weekly | |||||||||
6745 | 6745 | United States | New Hampshire | NH | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 1359711 | 264 | 23 | 262.110902256488 | 1.88909774351168 | 241 | 1.69153592197165 | 0.138933769272418 | 0.00720724596820888 | weekly | |||||||||
4009 | 4009 | United States | Hawaii | HI | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 1415872 | 251 | 5 | 258.830827068565 | -7.83082706856453 | 246 | 0.35313926682638 | -0.553074505927409 | -0.0302546151756883 | weekly | |||||||||
4161 | 4161 | United States | Idaho | ID | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 1787065 | 298 | 22 | 311.580827068452 | -13.5808270684523 | 276 | 1.2310688195449 | -0.759951488527408 | -0.0435868509504557 | weekly | |||||||||
5225 | 5225 | United States | Maine | ME | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 1344212 | 289 | 11 | 308.723684211265 | -19.7236842112647 | 278 | 0.818323300193719 | -1.46730457779463 | -0.0638878233837332 | weekly | |||||||||
6441 | 6441 | United States | Nebraska | NE | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 1934408 | 328 | 44 | 336.492481204105 | -8.49248120410459 | 284 | 2.27459770637839 | -0.43902223337086 | -0.0252382495255618 | weekly | |||||||||
4769 | 4769 | United States | Kansas | KS | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 2913314 | 588 | 266 | 581.075187970688 | 6.92481202931174 | 322 | 9.13049537399676 | 0.237695354133188 | 0.0119172392362776 | weekly | |||||||||
7049 | 7049 | United States | New Mexico | NM | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 2096829 | 443 | 94 | 391.635338346729 | 51.3646616532707 | 349 | 4.48295974540604 | 2.44963521838312 | 0.13115430765289 | weekly | |||||||||
9025 | 9025 | United States | Utah | UT | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 3205958 | 428 | 50 | 396.218045113642 | 31.7819548863583 | 378 | 1.55959622677527 | 0.991340338406128 | 0.0802132948721272 | weekly | |||||||||
6593 | 6593 | United States | Nevada | NV | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 3080156 | 639 | 172 | 526.984962406884 | 112.015037593116 | 467 | 5.58413275171777 | 3.63666767505009 | 0.21255831870707 | weekly | |||||||||
9633 | 9633 | United States | West Virginia | WV | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 1792147 | 514 | 17 | 473.614661655118 | 40.3853383448818 | 497 | 0.948582900844629 | 2.25346125875175 | 0.0852704563742792 | weekly | |||||||||
3249 | 3249 | United States | Connecticut | CT | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 3565287 | 683 | 142 | 655.578947369111 | 27.4210526308888 | 541 | 3.98284906656883 | 0.769112069544156 | 0.0418272318550368 | weekly | |||||||||
4617 | 4617 | United States | Iowa | IA | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 3155070 | 656 | 100 | 643.248120301389 | 12.7518796986113 | 556 | 3.16950178601426 | 0.404171054797876 | 0.0198242004852445 | weekly | |||||||||
2793 | 2793 | United States | Arkansas | AR | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 3017825 | 772 | 96 | 684.943609024022 | 87.056390975978 | 676 | 3.18109897028489 | 2.88473953844169 | 0.127100085071273 | weekly | |||||||||
5985 | 5985 | United States | Mississippi | MS | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 2976149 | 810 | 92 | 658.530075188704 | 151.469924811296 | 718 | 3.09124307956356 | 5.08946040037967 | 0.230012159684417 | weekly | |||||||||
7961 | 7961 | United States | Oregon | OR | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 4217737 | 814 | 55 | 740.90225564003 | 73.0977443599702 | 759 | 1.3040168222912 | 1.73310342394441 | 0.0986604424585327 | weekly | |||||||||
3097 | 3097 | United States | Colorado | CO | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 5758736 | 894 | 75 | 853.47180451235 | 40.5281954876504 | 819 | 1.30236913100375 | 0.703768943178683 | 0.0474862734461474 | weekly | |||||||||
7809 | 7809 | United States | Oklahoma | OK | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 3956971 | 1013 | 181 | 864.165413534608 | 148.834586465392 | 832 | 4.57420587616134 | 3.76132618776817 | 0.172229279411483 | weekly | |||||||||
5833 | 5833 | United States | Minnesota | MN | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 5639632 | 904 | 54 | 955.674812030882 | -51.6748120308821 | 850 | 0.957509284293727 | -0.916279857105607 | -0.0540715433538205 | weekly | |||||||||
8417 | 8417 | United States | South Carolina | SC | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 5148714 | 1253 | 344 | 1052.00563909872 | 200.994360901277 | 909 | 6.68128002448767 | 3.90377793175688 | 0.191058254282243 | weekly | |||||||||
2337 | 2337 | United States | Alabama | AL | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 4903185 | 1332 | 347 | 1099.3646616428 | 232.6353383572 | 985 | 7.077032581883 | 4.74457599207863 | 0.211608892366587 | weekly | |||||||||
5529 | 5529 | United States | Massachusetts | MA | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 6949503 | 1342 | 355 | 1278.57330827147 | 63.4266917285327 | 987 | 5.10827896613614 | 0.912679535911167 | 0.0496073954603984 | weekly | |||||||||
4921 | 4921 | United States | Kentucky | KY | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 4467673 | 1145 | 154 | 977.424812031452 | 167.575187968548 | 991 | 3.44698459354568 | 3.75083825446821 | 0.171445604721517 | weekly | |||||||||
5073 | 5073 | United States | Louisiana | LA | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 4648794 | 1164 | 165 | 934.770676692637 | 229.229323307363 | 999 | 3.54930762688129 | 4.9309417304222 | 0.245225196963187 | weekly | |||||||||
5377 | 5377 | United States | Maryland | MD | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 6045680 | 1170 | 159 | 1036.71804511368 | 133.281954886323 | 1011 | 2.62997710762065 | 2.2045816994337 | 0.128561430482006 | weekly | |||||||||
2641 | 2641 | United States | Arizona | AZ | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 7278717 | 1552 | 533 | 1276.62406015957 | 275.375939840435 | 1019 | 7.32271910008316 | 3.78330329150638 | 0.215706368408892 | weekly | |||||||||
9785 | 9785 | United States | Wisconsin | WI | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 5822434 | 1126 | 67 | 1125.0169172941 | 0.983082705897004 | 1059 | 1.15072150238199 | 0.016884394153665 | 0.00087383815370656 | weekly | |||||||||
9481 | 9481 | United States | Washington | WA | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 7614893 | 1254 | 148 | 1216.73684210612 | 37.2631578938797 | 1106 | 1.9435598110177 | 0.489345784555077 | 0.0306254866330657 | weekly | |||||||||
6137 | 6137 | United States | Missouri | MO | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 6137428 | 1514 | 268 | 1396.07518797074 | 117.924812029257 | 1246 | 4.36665000387785 | 1.92140440636138 | 0.0844688115979382 | weekly | |||||||||
4465 | 4465 | United States | Indiana | IN | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 6732219 | 1467 | 189 | 1375.1597744376 | 91.8402255624026 | 1278 | 2.80739530309397 | 1.3641895125872 | 0.0667851309132153 | weekly | |||||||||
6897 | 6897 | United States | New Jersey | NJ | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 8882190 | 1827 | 395 | 1557.81390977545 | 269.186090224547 | 1432 | 4.44710144682787 | 3.03062747165448 | 0.172797333837742 | weekly | |||||||||
9329 | 9329 | United States | Virginia | VA | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 8535519 | 1738 | 209 | 1432.3439849631 | 305.656015036903 | 1529 | 2.44859158535058 | 3.58098921737393 | 0.213395677466945 | weekly | |||||||||
3857 | 3857 | United States | Georgia | GA | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 10617423 | 2283 | 668 | 1795.28759398548 | 487.712406014516 | 1615 | 6.29154550967782 | 4.59351017675868 | 0.271662550138727 | weekly | |||||||||
8721 | 8721 | United States | Tennessee | TN | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 6833174 | 1795 | 171 | 1565.20112782047 | 229.798872179529 | 1624 | 2.50249737530465 | 3.36298873963299 | 0.146817471630321 | weekly | |||||||||
5681 | 5681 | United States | Michigan | MI | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 9986857 | 2101 | 222 | 2000.58082706853 | 100.419172931468 | 1879 | 2.22292158584027 | 1.00551327541255 | 0.0501950091557224 | weekly | |||||||||
7353 | 7353 | United States | North Carolina | NC | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 10488084 | 2437 | 444 | 2062.54699248182 | 374.453007518176 | 1993 | 4.23337570522891 | 3.57027086661563 | 0.181548836891034 | weekly | |||||||||
4313 | 4313 | United States | Illinois | IL | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 12671821 | 2439 | 339 | 2177.71052631631 | 261.289473683686 | 2100 | 2.67522718321226 | 2.06197257429446 | 0.119983565550224 | weekly | |||||||||
7657 | 7657 | United States | Ohio | OH | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 11689100 | 2848 | 422 | 2456.43796992693 | 391.562030073071 | 2426 | 3.6102009564466 | 3.34980477601416 | 0.15940236833447 | weekly | |||||||||
8113 | 8113 | United States | Pennsylvania | PA | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 12801989 | 3120 | 611 | 2806.60714285828 | 313.392857141722 | 2509 | 4.77269586780617 | 2.4480012999677 | 0.11166253101692 | weekly | |||||||||
7201 | 7201 | United States | New York | NY | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 19453561 | 4015 | 945 | 3182.04135338429 | 832.958646615705 | 3070 | 4.85772244988977 | 4.28177980687292 | 0.261768642864997 | weekly | |||||||||
3705 | 3705 | United States | Florida | FL | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 21477737 | 5119 | 1126 | 4439.80075188071 | 679.199248119289 | 3993 | 5.24263799300643 | 3.16234083748809 | 0.152979668700578 | weekly | |||||||||
8873 | 8873 | United States | Texas | TX | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 28995881 | 6412 | 1228 | 4353.813909775 | 2058.186090225 | 5184 | 4.23508428662678 | 7.09820160396229 | 0.472731754934229 | weekly | |||||||||
2945 | 2945 | United States | California | CA | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 39512223 | 7021 | 1680 | 5614.64285714341 | 1406.35714285659 | 5341 | 4.25184885193627 | 3.55929643051618 | 0.250480249347883 | weekly | |||||||||
11985 | 11985 | Canada | Canada | 0 | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 38454328 | 6075 | 402 | 6128.52912621374 | -53.5291262137416 | 5673 | 1.04539598247563 | -0.13920182460019 | -0.00873441654781049 | weekly | |||||||||
17036 | 17036 | South Africa | South Africa | 0 | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 59893884 | 11441 | 1119 | 9039.29693165965 | 2401.70306834035 | 10322 | 1.86830428295483 | 4.00993041015732 | 0.265695782149662 | 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);