economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
26 rows where cadence = "weekly" and covid_deaths = 127 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, start_date, end_date, year, week, population, total_deaths, expected_deaths, excess_deaths, covid_deaths_per_100k, excess_deaths_per_100k, start_date (date)
country 8
- United States 14
- Belgium 2
- Chile 2
- Colombia 2
- Israel 2
- Spain 2
- South Africa 1
- Turkey 1
cadence 1
- weekly · 26 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8804 | 8804 | United States | Tennessee | TN | 2022-09-18 | 2022-09-24 | 7 | 2022 | 38 | 6833174 | 1585 | 127 | 1420.05513784553 | 164.944862154465 | 1458 | 1.85857992200989 | 2.41388353573999 | 0.116153843437879 | weekly | |||||||||
2089 | 2089 | Colombia | Colombia | 0 | 2022-08-29 | 2022-09-04 | 7 | 2022 | 35 | 51874028 | 5212 | 127 | 4917.82977528073 | 294.170224719269 | 5085 | 0.244823864458723 | 0.567085757672932 | 0.0598170815504642 | weekly | |||||||||
12354 | 12354 | Colombia | Colombia | 0 | 2022-08-29 | 2022-09-04 | 7 | 2022 | 35 | 51874028 | 5212 | 127 | 4917.82977528073 | 294.170224719269 | 5085 | 0.244823864458723 | 0.567085757672932 | 0.0598170815504644 | weekly | |||||||||
9555 | 9555 | United States | Washington | WA | 2022-07-17 | 2022-07-23 | 7 | 2022 | 29 | 7614893 | 1249 | 127 | 1055.57894736925 | 193.421052630751 | 1122 | 1.66778443242735 | 2.54003638174234 | 0.183236936576654 | weekly | |||||||||
19449 | 19449 | South Africa | South Africa | 0 | 2022-06-20 | 2022-06-26 | 7 | 2022 | 25 | 59893884 | 11950 | 127 | 11306.433898305 | 643.566101695036 | 11823 | 0.212041683588261 | 1.07451054884842 | 0.0569203435392232 | weekly | |||||||||
8015 | 8015 | United States | Oregon | OR | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 4217737 | 880 | 127 | 750.263157895688 | 129.736842104312 | 753 | 3.01109338965422 | 3.07598226499925 | 0.172921781829449 | weekly | |||||||||
6487 | 6487 | United States | Nebraska | NE | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 1934408 | 465 | 127 | 376.039473685285 | 88.9605263147153 | 338 | 6.5653161070467 | 4.59885020712876 | 0.236572308334758 | weekly | |||||||||
8002 | 8002 | United States | Oregon | OR | 2021-11-28 | 2021-12-04 | 7 | 2021 | 48 | 4217737 | 865 | 127 | 707.082706767836 | 157.917293232164 | 738 | 3.01109338965422 | 3.74412376191697 | 0.223336381615135 | weekly | |||||||||
12150 | 12150 | Chile | Chile | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 19603736 | 2389 | 127 | 2287.68606557386 | 101.313934426136 | 2262 | 0.6478356982567 | 0.516809318520388 | 0.0442866422761226 | weekly | |||||||||
19808 | 19808 | Chile | Chile | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 19603736 | 2389 | 127 | 2287.68606557386 | 101.313934426136 | 2262 | 0.6478356982567 | 0.516809318520389 | 0.044286642276121 | weekly | |||||||||
5708 | 5708 | United States | Michigan | MI | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 9986857 | 1990 | 127 | 1715.13032581533 | 274.869674184669 | 1863 | 1.27167135766538 | 2.7523141082792 | 0.160261683935886 | weekly | |||||||||
17343 | 17343 | Spain | Spain | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 47558632 | 7285 | 127 | 7425.96629213482 | -140.966292134821 | 7158 | 0.267038799602142 | -0.29640527114998 | -0.0189828887701959 | weekly | |||||||||
18137 | 18137 | Spain | Spain | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 47558632 | 7285 | 127 | 7425.96629213482 | -140.966292134821 | 7158 | 0.267038799602142 | -0.296405271149979 | -0.018982888770196 | weekly | |||||||||
7662 | 7662 | United States | Ohio | OH | 2021-03-21 | 2021-03-27 | 7 | 2021 | 12 | 11689100 | 2491 | 127 | 2457.72556391193 | 33.2744360880702 | 2364 | 1.08648227836189 | 0.284662087654911 | 0.0135387109841132 | weekly | |||||||||
5077 | 5077 | United States | Louisiana | LA | 2021-03-14 | 2021-03-20 | 7 | 2021 | 11 | 4648794 | 1008 | 127 | 914.924812030914 | 93.0751879690858 | 881 | 2.73189132493288 | 2.00213620928537 | 0.101729876318996 | weekly | |||||||||
5075 | 5075 | United States | Louisiana | LA | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 4648794 | 1078 | 127 | 908.770676692634 | 169.229323307366 | 951 | 2.73189132493288 | 3.64028441155634 | 0.18621785192636 | weekly | |||||||||
14498 | 14498 | Israel | Israel | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 9449000 | 1017 | 127 | 993.481741572992 | 23.5182584270084 | 890 | 1.34405757222987 | 0.248896797830547 | 0.0236725623057463 | weekly | |||||||||
20667 | 20667 | Israel | Israel | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 9449000 | 1017 | 127 | 993.481741572992 | 23.5182584270084 | 890 | 1.34405757222987 | 0.248896797830547 | 0.0236725623057468 | weekly | |||||||||
6122 | 6122 | United States | Missouri | MO | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 6137428 | 1790 | 127 | 1219.06015037671 | 570.939849623286 | 1663 | 2.06927071079286 | 9.30259140511769 | 0.468344280999469 | weekly | |||||||||
11513 | 11513 | Belgium | Belgium | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 11655923 | 2060 | 127 | 1999.11629213488 | 60.8837078651227 | 1933 | 1.08957480244164 | 0.522341369835085 | 0.0304553107313739 | weekly | |||||||||
20337 | 20337 | Belgium | Belgium | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 11655923 | 2060 | 127 | 1999.11629213488 | 60.8837078651227 | 1933 | 1.08957480244164 | 0.522341369835085 | 0.0304553107313754 | weekly | |||||||||
24889 | 24889 | Turkey | Istanbul | 0 | 2020-08-26 | 2020-09-02 | 7 | 2020 | 35 | 15519267 | 1441 | 127 | 1299.50000000015 | 141.499999999848 | 1314 | 0.818337618651706 | 0.911769866449544 | 0.108888033859047 | 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 | |||||||||
7171 | 7171 | United States | New York | NY | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 19453561 | 2834 | 127 | 2729.56641604093 | 104.433583959072 | 2707 | 0.652836773688889 | 0.536835307217389 | 0.0382601366082702 | weekly | |||||||||
7625 | 7625 | United States | Ohio | OH | 2020-07-05 | 2020-07-11 | 7 | 2020 | 28 | 11689100 | 2515 | 127 | 2255.81704260848 | 259.182957391519 | 2388 | 1.08648227836189 | 2.21730464613631 | 0.114895380474569 | weekly | |||||||||
8827 | 8827 | United States | Texas | TX | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 28995881 | 4186 | 127 | 3893.45112782009 | 292.548872179907 | 4059 | 0.437993244626711 | 1.00893251762175 | 0.0751387040894238 | 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);