economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
32 rows where covid_deaths = 45 and year = 2022 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region_code, start_date, end_date, days, week, population, total_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, month, covid_deaths_per_7_days, excess_deaths_per_7_days, non_covid_deaths_per_7_days, excess_deaths_per_100k_per_7_days, start_date (date), end_date (date)
country 11
- United States 10
- New Zealand 4
- Austria 2
- Belgium 2
- Bulgaria 2
- Iran 2
- Israel 2
- North Macedonia 2
- Norway 2
- Romania 2
- Serbia 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11472 | 11472 | Austria | Austria | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 8939617 | 1824 | 45 | 1562.37415730333 | 261.625842696669 | 1779 | 0.503377269965816 | 2.92658894331456 | 0.167454025960234 | weekly | |||||||||
21122 | 21122 | Austria | Austria | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 8939617 | 1824 | 45 | 1562.37415730333 | 261.625842696669 | 1779 | 0.503377269965816 | 2.92658894331456 | 0.167454025960233 | weekly | |||||||||
11623 | 11623 | Belgium | Belgium | 0 | 2022-11-14 | 2022-11-20 | 7 | 2022 | 46 | 11655923 | 2011 | 45 | 2009.19382022478 | 1.80617977522184 | 1966 | 0.386069811888771 | 0.0154958108012711 | 0.00089895746096702 | weekly | |||||||||
20447 | 20447 | Belgium | Belgium | 0 | 2022-11-14 | 2022-11-20 | 7 | 2022 | 46 | 11655923 | 2011 | 45 | 2009.19382022478 | 1.80617977522184 | 1966 | 0.386069811888771 | 0.015495810801271 | 0.000898957460967909 | weekly | |||||||||
9876 | 9876 | United States | Wisconsin | WI | 2022-11-13 | 2022-11-19 | 7 | 2022 | 46 | 5822434 | 1183 | 45 | 1090.4937343367 | 92.5062656632956 | 1138 | 0.772872650853578 | 1.58879028363904 | 0.0848297085535872 | weekly | |||||||||
16676 | 16676 | Romania | Romania | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 19659270 | 4592 | 45 | 4748.58061797753 | -156.580617977532 | 4547 | 0.228899648867939 | -0.796472188324043 | -0.032974193885376 | weekly | |||||||||
23607 | 23607 | Romania | Romania | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 19659270 | 4592 | 45 | 4748.58061797753 | -156.580617977532 | 4547 | 0.228899648867939 | -0.796472188324042 | -0.0329741938853765 | weekly | |||||||||
14445 | 14445 | Iran | Iran | 0 | 2022-09-26 | 2022-10-02 | 7 | 2022 | 39 | 88550568 | 7154.1 | 45 | 7702.47558988747 | -548.375589887471 | 7109.1 | 0.0508184204984433 | -0.619279584844076 | -0.0711947196051395 | weekly | |||||||||
24361 | 24361 | Iran | Iran | 0 | 2022-09-26 | 2022-10-02 | 7 | 2022 | 39 | 88550568 | 7154.1 | 45 | 7702.47558988747 | -548.375589887471 | 7109.1 | 0.0508184204984433 | -0.619279584844075 | -0.0711947196051396 | weekly | |||||||||
4851 | 4851 | United States | Kansas | KS | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 2913314 | 563 | 45 | 491.786967419274 | 71.2130325807261 | 518 | 1.54463267605208 | 2.44439949077669 | 0.144804635540521 | weekly | |||||||||
6979 | 6979 | United States | New Jersey | NJ | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 8882190 | 1396 | 45 | 1307.56892230679 | 88.4310776932061 | 1351 | 0.506631810398111 | 0.995599933048112 | 0.0676301464378621 | weekly | |||||||||
15914 | 15914 | New Zealand | New Zealand | 0 | 2022-08-22 | 2022-08-28 | 7 | 2022 | 34 | 5185289 | 756 | 45 | 749.612078651666 | 6.38792134833398 | 711 | 0.867839767465227 | 0.12319315950054 | 0.00852163609719847 | weekly | |||||||||
20245 | 20245 | New Zealand | New Zealand | 0 | 2022-08-22 | 2022-08-28 | 7 | 2022 | 34 | 5185289 | 756 | 45 | 749.612078651666 | 6.38792134833398 | 711 | 0.867839767465227 | 0.12319315950054 | 0.00852163609719847 | weekly | |||||||||
5456 | 5456 | United States | Maryland | MD | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 6045680 | 1004 | 45 | 901.882205514627 | 102.117794485373 | 959 | 0.744333143666221 | 1.6891035331902 | 0.11322741912521 | weekly | |||||||||
4997 | 4997 | United States | Kentucky | KY | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 4467673 | 1063 | 45 | 870.213032583063 | 192.786967416937 | 1018 | 1.00723575785426 | 4.31515393845827 | 0.221539968029076 | weekly | |||||||||
20613 | 20613 | North Macedonia | North Macedonia | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 2093606 | 1528 | 45 | 1528.48165936874 | -0.481659368737382 | 1483 | 2.14940155884154 | -0.023006208844328 | -0.000315122766298859 | monthly | 7 | 345.032258064516 | 10.1612903225806 | 345.141019857457 | -0.108761792940699 | 334.870967741935 | 0.485348739093251 | -0.00519495038420311 | ||
22548 | 22548 | North Macedonia | North Macedonia | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 2093606 | 1528 | 45 | 1528.48165936874 | -0.481659368737382 | 1483 | 2.14940155884154 | -0.023006208844328 | -0.000315122766300635 | monthly | 7 | 345.032258064516 | 10.1612903225806 | 345.141019857457 | -0.108761792940699 | 334.870967741935 | 0.485348739093251 | -0.00519495038420311 | ||
4540 | 4540 | United States | Indiana | IN | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 6732219 | 1366 | 45 | 1179.58897243295 | 186.411027567051 | 1321 | 0.668427453117613 | 2.76893885310403 | 0.158030493607084 | weekly | |||||||||
15909 | 15909 | New Zealand | New Zealand | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 5185289 | 852 | 45 | 783.212078651666 | 68.7879213483338 | 807 | 0.867839767465227 | 1.32659763705232 | 0.0878279628510779 | weekly | |||||||||
20240 | 20240 | New Zealand | New Zealand | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 5185289 | 852 | 45 | 783.212078651666 | 68.7879213483338 | 807 | 0.867839767465227 | 1.32659763705232 | 0.0878279628510776 | weekly | |||||||||
10240 | 10240 | Serbia | Serbia | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 6871547 | 7744 | 45 | 7578.50571740499 | 165.494282595009 | 7699 | 0.654874368173571 | 2.408399194461 | 0.0218373237107852 | monthly | 6 | 1806.93333333333 | 10.5 | 1768.31800072783 | 38.6153326055022 | 1796.43333333333 | 0.1528040192405 | 0.561959812040901 | ||
22870 | 22870 | Serbia | Serbia | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 6871547 | 7744 | 45 | 7578.50571740499 | 165.494282595009 | 7699 | 0.654874368173571 | 2.408399194461 | 0.0218373237107854 | monthly | 6 | 1806.93333333333 | 10.5 | 1768.31800072783 | 38.6153326055022 | 1796.43333333333 | 0.1528040192405 | 0.561959812040901 | ||
11901 | 11901 | Bulgaria | Bulgaria | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 6781955 | 1967 | 45 | 1909.16460674159 | 57.8353932584132 | 1922 | 0.663525487857115 | 0.852783500604371 | 0.0302935603636183 | weekly | |||||||||
19660 | 19660 | Bulgaria | Bulgaria | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 6781955 | 1967 | 45 | 1909.16460674159 | 57.8353932584132 | 1922 | 0.663525487857115 | 0.852783500604371 | 0.0302935603636201 | weekly | |||||||||
4530 | 4530 | United States | Indiana | IN | 2022-05-15 | 2022-05-21 | 7 | 2022 | 20 | 6732219 | 1291 | 45 | 1219.2556390996 | 71.7443609003994 | 1246 | 0.668427453117613 | 1.06568667627122 | 0.0588427550381325 | weekly | |||||||||
6652 | 6652 | United States | Nevada | NV | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 3080156 | 601 | 45 | 536.709273183785 | 64.2907268162153 | 556 | 1.46096496411221 | 2.08725554212888 | 0.11978687536893 | weekly | |||||||||
14564 | 14564 | Israel | Israel | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 9449000 | 1134 | 45 | 921.136235955005 | 212.863764044995 | 1089 | 0.476240872049952 | 2.25276499148053 | 0.231088253546235 | weekly | |||||||||
20733 | 20733 | Israel | Israel | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 9449000 | 1134 | 45 | 921.136235955005 | 212.863764044995 | 1089 | 0.476240872049952 | 2.25276499148053 | 0.231088253546236 | weekly | |||||||||
9079 | 9079 | United States | Utah | UT | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 3205958 | 448 | 45 | 420.355263158751 | 27.644736841249 | 403 | 1.40363660409775 | 0.862292545356147 | 0.0657651735665523 | weekly | |||||||||
4061 | 4061 | United States | Hawaii | HI | 2022-02-13 | 2022-02-19 | 7 | 2022 | 7 | 1415872 | 267 | 45 | 261.763157895598 | 5.23684210440166 | 222 | 3.17825340143742 | 0.369866916246784 | 0.0200060319660811 | weekly | |||||||||
738 | 738 | Norway | Norway | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 5434324 | 957 | 45 | 905.236376404528 | 51.7636235954722 | 912 | 0.828069875848404 | 0.952531052537025 | 0.0571824386919471 | weekly | |||||||||
16034 | 16034 | Norway | Norway | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 5434324 | 957 | 45 | 905.236376404528 | 51.7636235954722 | 912 | 0.828069875848404 | 0.952531052537026 | 0.0571824386919468 | 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);