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-09-26 sorted by covid_deaths_per_100k
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6929 | 6929 | United States | New Jersey | NJ | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 8882190 | 1507 | 0 | 1301.51002506364 | 205.489974936359 | 1507 | 0.0 | 2.31350573379267 | 0.157885817995379 | weekly | |||||||||
3585 | 3585 | United States | District of Columbia | DC | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 705749 | 141 | 4 | 118.615288220976 | 22.3847117790242 | 137 | 0.56677373967232 | 3.17176670162114 | 0.188716919334398 | weekly | |||||||||
6777 | 6777 | United States | New Hampshire | NH | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 1359711 | 236 | 9 | 227.399749374245 | 8.600250625755 | 227 | 0.661905360771517 | 0.632505777018425 | 0.0378199652788582 | weekly | |||||||||
12017 | 12017 | Canada | Canada | 0 | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 38454328 | 6060 | 310 | 5507.17614424422 | 552.823855755781 | 5750 | 0.806151130764787 | 1.43761153687507 | 0.100382453961194 | weekly | |||||||||
5257 | 5257 | United States | Maine | ME | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 1344212 | 348 | 13 | 297.868421053318 | 50.1315789466819 | 335 | 0.967109354774396 | 3.72943992068825 | 0.168301086665741 | weekly | |||||||||
3433 | 3433 | United States | Delaware | DE | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 973764 | 217 | 12 | 178.815789477484 | 38.184210522516 | 205 | 1.23233144786622 | 3.92130028657005 | 0.213539367155964 | weekly | |||||||||
17068 | 17068 | South Africa | South Africa | 0 | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 59893884 | 11161 | 752 | 9968.30125523006 | 1192.69874476994 | 10409 | 1.25555390597143 | 1.9913531484616 | 0.119649147255072 | weekly | |||||||||
8297 | 8297 | United States | Rhode Island | RI | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 1059361 | 209 | 15 | 197.200501254009 | 11.7994987459914 | 194 | 1.41594791577187 | 1.11383171043595 | 0.0598350342466565 | weekly | |||||||||
5561 | 5561 | United States | Massachusetts | MA | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 6949503 | 1210 | 106 | 1049.35463659222 | 160.645363407775 | 1104 | 1.52528893073361 | 2.31160938282602 | 0.153089677984814 | weekly | |||||||||
5409 | 5409 | United States | Maryland | MD | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 6045680 | 1112 | 94 | 908.828320802867 | 203.171679197133 | 1018 | 1.55482923343611 | 3.36060921512772 | 0.223553419877639 | weekly | |||||||||
5865 | 5865 | United States | Minnesota | MN | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 5639632 | 1055 | 94 | 886.243107770194 | 168.756892229806 | 961 | 1.6667754208076 | 2.99233872404805 | 0.190418284498033 | weekly | |||||||||
7233 | 7233 | United States | New York | NY | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 19453561 | 3396 | 327 | 2841.84962406096 | 554.150375939039 | 3069 | 1.68092618107297 | 2.84858065800415 | 0.194996375335007 | weekly | |||||||||
2977 | 2977 | United States | California | CA | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 39512223 | 6143 | 674 | 4873.90476190519 | 1269.09523809481 | 5469 | 1.70580126559824 | 3.21190543517334 | 0.260385727684741 | weekly | |||||||||
7537 | 7537 | United States | North Dakota | ND | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 762062 | 182 | 14 | 154.676691730209 | 27.3233082697905 | 168 | 1.83712086418165 | 3.58544426434995 | 0.176647870885734 | weekly | |||||||||
4345 | 4345 | United States | Illinois | IL | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 12671821 | 2365 | 253 | 1946.38596491276 | 418.61403508724 | 2112 | 1.99655598039145 | 3.30350338035267 | 0.215072468993067 | weekly | |||||||||
3129 | 3129 | United States | Colorado | CO | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 5758736 | 1033 | 122 | 751.466165414553 | 281.533834585447 | 911 | 2.11852045309943 | 4.88881300662935 | 0.374646055328567 | weekly | |||||||||
9817 | 9817 | United States | Wisconsin | WI | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 5822434 | 1305 | 124 | 1021.12030075272 | 283.879699247277 | 1181 | 2.12969352679653 | 4.87561901512798 | 0.278008084882862 | weekly | |||||||||
5713 | 5713 | United States | Michigan | MI | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 9986857 | 2239 | 225 | 1816.13032581533 | 422.869674184665 | 2014 | 2.25296106673 | 4.23426183217268 | 0.232841040190671 | weekly | |||||||||
9057 | 9057 | United States | Utah | UT | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 3205958 | 495 | 74 | 378.994987469504 | 116.005012530496 | 421 | 2.3082024156274 | 3.61841959659159 | 0.30608587544929 | weekly | |||||||||
9209 | 9209 | United States | Vermont | VT | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 623989 | 140 | 15 | 103.205513785325 | 36.7944862146746 | 125 | 2.40388853008627 | 5.89665622545823 | 0.356516671107414 | weekly | |||||||||
4649 | 4649 | United States | Iowa | IA | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 3155070 | 737 | 80 | 571.097744361467 | 165.902255638533 | 657 | 2.5356014288114 | 5.25827495550124 | 0.290497129916044 | weekly | |||||||||
8145 | 8145 | United States | Pennsylvania | PA | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 12801989 | 3160 | 360 | 2387.09523809634 | 772.904761903657 | 2800 | 2.81206303176795 | 6.03738030007413 | 0.323784635639436 | weekly | |||||||||
8601 | 8601 | United States | South Dakota | SD | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 884659 | 206 | 25 | 153.080200501954 | 52.9197994980461 | 181 | 2.8259476250171 | 5.98194326831537 | 0.345699831359775 | weekly | |||||||||
4041 | 4041 | United States | Hawaii | HI | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 1415872 | 266 | 42 | 214.796992482056 | 51.2030075179439 | 224 | 2.96636984134159 | 3.61635850683846 | 0.238378605427733 | weekly | |||||||||
7081 | 7081 | United States | New Mexico | NM | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 2096829 | 490 | 63 | 356.29573934921 | 133.70426065079 | 427 | 3.00453685064447 | 6.37649806688053 | 0.375262025010479 | weekly | |||||||||
4801 | 4801 | United States | Kansas | KS | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 2913314 | 629 | 88 | 496.256892231291 | 132.743107768709 | 541 | 3.0206150109463 | 4.5564298173389 | 0.267488693551163 | weekly | |||||||||
6169 | 6169 | United States | Missouri | MO | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 6137428 | 1552 | 191 | 1195.25689223136 | 356.743107768642 | 1361 | 3.11205280127115 | 5.81258318254229 | 0.298465635368693 | weekly | |||||||||
7993 | 7993 | United States | Oregon | OR | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 4217737 | 949 | 133 | 688.082706767837 | 260.917293232163 | 816 | 3.1533497702678 | 6.18619162911683 | 0.379194667538998 | weekly | |||||||||
9361 | 9361 | United States | Virginia | VA | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 8535519 | 1787 | 295 | 1313.27944862221 | 473.720551377792 | 1492 | 3.4561460176001 | 5.54999117660909 | 0.360715727239 | weekly | |||||||||
9513 | 9513 | United States | Washington | WA | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 7614893 | 1498 | 271 | 1037.01754386048 | 460.982456139522 | 1227 | 3.55881559990403 | 6.05369577930409 | 0.444527152764875 | weekly | |||||||||
7689 | 7689 | United States | Ohio | OH | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 11689100 | 3242 | 453 | 2185.05889724531 | 1056.94110275469 | 2789 | 3.87540529210974 | 9.0421084835846 | 0.483712866544314 | weekly | |||||||||
8905 | 8905 | United States | Texas | TX | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 28995881 | 5899 | 1156 | 3801.01002506317 | 2097.98997493683 | 4743 | 3.98677315581479 | 7.23547587651097 | 0.551955917270162 | weekly | |||||||||
2673 | 2673 | United States | Arizona | AZ | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 7278717 | 1616 | 302 | 1151.21553885742 | 464.784461142582 | 1314 | 4.1490828672141 | 6.38552730024511 | 0.403733658428447 | weekly | |||||||||
3281 | 3281 | United States | Connecticut | CT | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 3565287 | 636 | 149 | 564.728070176018 | 71.271929823982 | 487 | 4.17918669661096 | 1.9990516843099 | 0.126205750321154 | weekly | |||||||||
4497 | 4497 | United States | Indiana | IN | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 6732219 | 1696 | 309 | 1236.85839599158 | 459.141604008419 | 1387 | 4.58986851140761 | 6.82006339972629 | 0.371215981955904 | weekly | |||||||||
7385 | 7385 | United States | North Carolina | NC | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 10488084 | 2518 | 497 | 1808.72305764474 | 709.276942355262 | 2021 | 4.73871109346569 | 6.76269318929236 | 0.392142367709328 | weekly | |||||||||
6625 | 6625 | United States | Nevada | NV | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 3080156 | 645 | 151 | 490.448621554719 | 154.551378445281 | 494 | 4.90234910179874 | 5.01764775697337 | 0.315122464724956 | weekly | |||||||||
2825 | 2825 | United States | Arkansas | AR | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 3017825 | 821 | 157 | 599.098997495292 | 221.901002504708 | 664 | 5.20242227432008 | 7.35301094346784 | 0.370391209854181 | weekly | |||||||||
5105 | 5105 | United States | Louisiana | LA | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 4648794 | 1144 | 247 | 800.258145364265 | 343.741854635735 | 897 | 5.31320596266473 | 7.3942156747693 | 0.429538714009926 | weekly | |||||||||
8753 | 8753 | United States | Tennessee | TN | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 6833174 | 2168 | 380 | 1418.37468671768 | 749.625313282318 | 1788 | 5.56110527845479 | 10.9703823330464 | 0.528510075865113 | weekly | |||||||||
7841 | 7841 | United States | Oklahoma | OK | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 3956971 | 1061 | 224 | 706.731829574662 | 354.268170425338 | 837 | 5.66089566994552 | 8.95301407125141 | 0.501276659123376 | weekly | |||||||||
6321 | 6321 | United States | Montana | MT | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 1068778 | 297 | 72 | 183.802005013349 | 113.197994986651 | 225 | 6.73666561250325 | 10.5913477809845 | 0.61586920653248 | weekly | |||||||||
4953 | 4953 | United States | Kentucky | KY | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 4467673 | 1427 | 312 | 903.909774437536 | 523.090225562464 | 1115 | 6.98350125445618 | 11.7083373282347 | 0.578697388119252 | weekly | |||||||||
3889 | 3889 | United States | Georgia | GA | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 10617423 | 2436 | 764 | 1620.3784461158 | 815.6215538842 | 1672 | 7.19571971466146 | 7.68191635469548 | 0.503352507458564 | weekly | |||||||||
6017 | 6017 | United States | Mississippi | MS | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 2976149 | 790 | 221 | 587.60275689292 | 202.39724310708 | 569 | 7.42570348460376 | 6.80064214214677 | 0.344445700318528 | weekly | |||||||||
8449 | 8449 | United States | South Carolina | SC | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 5148714 | 1399 | 490 | 971.540100251575 | 427.459899748425 | 909 | 9.51693956976441 | 8.30226537633329 | 0.439981735841615 | weekly | |||||||||
2369 | 2369 | United States | Alabama | AL | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 4903185 | 1496 | 472 | 1005.70426063889 | 490.295739361114 | 1024 | 9.62639590388696 | 9.9995357988963 | 0.487514827718486 | weekly | |||||||||
4193 | 4193 | United States | Idaho | ID | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 1787065 | 509 | 178 | 282.130325815263 | 226.869674184737 | 331 | 9.96046590359052 | 12.6950991813245 | 0.804130763076101 | weekly | |||||||||
9665 | 9665 | United States | West Virginia | WV | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 1792147 | 734 | 199 | 414.870927319275 | 319.129072680725 | 535 | 11.1039998392989 | 17.8070812651376 | 0.769224960502309 | weekly | |||||||||
2521 | 2521 | United States | Alaska | AK | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 731545 | 171 | 83 | 100.612781958707 | 70.3872180412931 | 88 | 11.3458502211074 | 9.6217208840595 | 0.699585248226027 | weekly | |||||||||
3737 | 3737 | United States | Florida | FL | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 21477737 | 5493 | 2495 | 3881.02756892325 | 1611.97243107675 | 2998 | 11.6166800999565 | 7.50531786042796 | 0.415346812783391 | weekly | |||||||||
9969 | 9969 | United States | Wyoming | WY | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 578759 | 152 | 117 | 100.417293233934 | 51.5827067660656 | 35 | 20.2156683524576 | 8.91264010858848 | 0.513683501166452 | weekly | |||||||||
6473 | 6473 | United States | Nebraska | NE | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 1934408 | 393 | 429 | 304.72431077801 | 88.2756892219899 | -36 | 22.1773276371893 | 4.56344727802976 | 0.289690340086775 | 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);