economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
17 rows where covid_deaths = 187 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, start_date, end_date, days, year, week, population, total_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_per_100k, month, total_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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
631 | 631 | Hong Kong | Hong Kong | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 7488863 | 4191 | 187 | 3989.96051207203 | 201.039487927966 | 4004 | 2.49704127315455 | 2.6845128282887 | 0.0503863352330682 | monthly | 8 | 946.354838709677 | 42.2258064516129 | 900.958825306588 | 45.3960134030891 | 904.129032258065 | 0.563848029421995 | 0.606180316065191 | ||
22001 | 22001 | Hong Kong | Hong Kong | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 7488863 | 4191 | 187 | 3989.96051207203 | 201.039487927966 | 4004 | 2.49704127315455 | 2.6845128282887 | 0.0503863352330693 | monthly | 8 | 946.354838709677 | 42.2258064516129 | 900.958825306588 | 45.3960134030891 | 904.129032258065 | 0.563848029421995 | 0.606180316065191 | ||
8948 | 8948 | United States | Texas | TX | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 28995881 | 4628 | 187 | 3833.56892230636 | 794.431077693644 | 4441 | 0.644919186970039 | 2.73980665630972 | 0.207230153883786 | weekly | |||||||||
12921 | 12921 | Denmark | Denmark | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 5882259 | 1281 | 187 | 1161.05763108613 | 119.942368913867 | 1094 | 3.17905076944079 | 2.03905283520952 | 0.103304406002369 | weekly | |||||||||
19030 | 19030 | Denmark | Denmark | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 5882259 | 1281 | 187 | 1161.05763108613 | 119.942368913867 | 1094 | 3.17905076944079 | 2.03905283520951 | 0.103304406002366 | weekly | |||||||||
5121 | 5121 | United States | Louisiana | LA | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 4648794 | 1381 | 187 | 998.078947369245 | 382.921052630755 | 1194 | 4.0225486437988 | 8.23699765209548 | 0.38365807999464 | weekly | |||||||||
12030 | 12030 | Canada | Canada | 0 | 2021-12-26 | 2022-01-01 | 7 | 2021 | 52 | 38454328 | 6355 | 187 | 6118.17614424422 | 236.82385575578 | 6168 | 0.486291165977468 | 0.615857480998706 | 0.0387082441192177 | weekly | |||||||||
10786 | 10786 | Canada | Canada | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 38454328 | 6200 | 187 | 5740.24157303359 | 459.758426966415 | 6013 | 0.486291165977468 | 1.19559605089553 | 0.0800939161038554 | weekly | |||||||||
11134 | 11134 | Ireland | Ireland | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 5023108 | 2948 | 187 | 2577.07901842729 | 370.920981572713 | 2761 | 3.7227947318672 | 7.38429238576421 | 0.143930775471167 | monthly | 10 | 665.677419354839 | 42.2258064516129 | 581.921068677129 | 83.7563506777094 | 623.451612903226 | 0.840631068486143 | 1.6674208613016 | ||
22024 | 22024 | Ireland | Ireland | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 5023108 | 2948 | 187 | 2577.07901842729 | 370.920981572713 | 2761 | 3.7227947318672 | 7.38429238576421 | 0.143930775471166 | monthly | 10 | 665.677419354839 | 42.2258064516129 | 581.921068677129 | 83.7563506777094 | 623.451612903226 | 0.840631068486143 | 1.6674208613016 | ||
4316 | 4316 | United States | Illinois | IL | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 12671821 | 2110 | 187 | 2085.38596491274 | 24.6140350872633 | 1923 | 1.47571528985455 | 0.194242288359845 | 0.0118031076747431 | weekly | |||||||||
4293 | 4293 | United States | Illinois | IL | 2020-09-27 | 2020-10-03 | 7 | 2020 | 40 | 12671821 | 2138 | 187 | 1985.36842105319 | 152.631578946806 | 1951 | 1.47571528985455 | 1.20449601479382 | 0.0768782143043447 | weekly | |||||||||
1178 | 1178 | Ecuador | Ecuador | 0 | 2020-09-14 | 2020-09-20 | 7 | 2020 | 38 | 18001002 | 1882 | 187 | 1393.49438202238 | 488.505617977624 | 1695 | 1.03883106062651 | 2.71376903339949 | 0.350561598439067 | weekly | |||||||||
13002 | 13002 | Ecuador | Ecuador | 0 | 2020-09-14 | 2020-09-20 | 7 | 2020 | 38 | 18001002 | 1882 | 187 | 1393.49438202238 | 488.505617977624 | 1695 | 1.03883106062651 | 2.7137690333995 | 0.350561598439063 | weekly | |||||||||
11494 | 11494 | Belgium | Belgium | 0 | 2020-05-25 | 2020-05-31 | 7 | 2020 | 22 | 11655923 | 1983 | 187 | 1910.51629213488 | 72.4837078651215 | 1796 | 1.60433455162667 | 0.621861588010847 | 0.0379393298887414 | weekly | |||||||||
20318 | 20318 | Belgium | Belgium | 0 | 2020-05-25 | 2020-05-31 | 7 | 2020 | 22 | 11655923 | 1983 | 187 | 1910.51629213488 | 72.4837078651215 | 1796 | 1.60433455162667 | 0.621861588010846 | 0.037939329888742 | weekly | |||||||||
24873 | 24873 | Turkey | Istanbul | 0 | 2020-05-06 | 2020-05-13 | 7 | 2020 | 19 | 15519267 | 1694 | 187 | 1404.50000000015 | 289.499999999847 | 1507 | 1.20495381643991 | 1.86542315432712 | 0.206123175507167 | 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);