economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
20 rows where cadence = "monthly", country = "Azerbaijan" and year = 2022 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_date, days, total_deaths, covid_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_per_100k, excess_deaths_pct_change, month, expected_deaths_per_7_days, excess_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21488 | 21488 | Azerbaijan | Azerbaijan | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 10358078 | 4085 | 27 | 4660.72461077661 | -575.724610776614 | 4058 | 0.260666119718349 | -5.55821853027766 | -0.123526845899757 | monthly | 10 | 922.41935483871 | 6.09677419354839 | 1052.4216863044 | -130.002331465687 | 916.322580645161 | 0.0588600915493047 | -1.25508160361109 | ||
24218 | 24218 | Azerbaijan | Azerbaijan | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 10358078 | 4085 | 27 | 4660.72461077661 | -575.724610776614 | 4058 | 0.260666119718349 | -5.55821853027766 | -0.123526845899758 | monthly | 10 | 922.41935483871 | 6.09677419354839 | 1052.4216863044 | -130.002331465687 | 916.322580645161 | 0.0588600915493047 | -1.25508160361109 | ||
21487 | 21487 | Azerbaijan | Azerbaijan | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 10358078 | 4614 | 112 | 4213.73994591285 | 400.260054087148 | 4502 | 1.08128168179463 | 3.86423093248717 | 0.0949892635105272 | monthly | 9 | 1076.6 | 26.1333333333333 | 983.205987379665 | 93.3940126203346 | 1050.46666666667 | 0.252299059085415 | 0.901653884247005 | ||
24217 | 24217 | Azerbaijan | Azerbaijan | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 10358078 | 4614 | 112 | 4213.73994591285 | 400.260054087148 | 4502 | 1.08128168179463 | 3.86423093248717 | 0.0949892635105267 | monthly | 9 | 1076.6 | 26.1333333333333 | 983.205987379665 | 93.3940126203346 | 1050.46666666667 | 0.252299059085415 | 0.901653884247005 | ||
21486 | 21486 | Azerbaijan | Azerbaijan | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 10358078 | 4575 | 57 | 4715.72461077661 | -140.724610776614 | 4518 | 0.550295141627626 | -1.35859771259315 | -0.029841566756256 | monthly | 8 | 1033.06451612903 | 12.8709677419355 | 1064.84104114311 | -31.7765250140742 | 1020.1935483871 | 0.124260193270754 | -0.306780128650066 | ||
24216 | 24216 | Azerbaijan | Azerbaijan | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 10358078 | 4575 | 57 | 4715.72461077661 | -140.724610776614 | 4518 | 0.550295141627626 | -1.35859771259315 | -0.0298415667562569 | monthly | 8 | 1033.06451612903 | 12.8709677419355 | 1064.84104114311 | -31.7765250140742 | 1020.1935483871 | 0.124260193270754 | -0.306780128650066 | ||
21485 | 21485 | Azerbaijan | Azerbaijan | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 10358078 | 4594 | 31 | 5050.72461077662 | -456.724610776615 | 4563 | 0.299283322639586 | -4.40935674337087 | -0.0904275417832356 | monthly | 7 | 1037.35483870968 | 7.0 | 1140.48620243343 | -103.131363723752 | 1030.35483870968 | 0.0675801051121646 | -0.995661200116004 | ||
24215 | 24215 | Azerbaijan | Azerbaijan | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 10358078 | 4594 | 31 | 5050.72461077662 | -456.724610776615 | 4563 | 0.299283322639586 | -4.40935674337087 | -0.0904275417832349 | monthly | 7 | 1037.35483870968 | 7.0 | 1140.48620243343 | -103.131363723752 | 1030.35483870968 | 0.0675801051121646 | -0.995661200116004 | ||
21484 | 21484 | Azerbaijan | Azerbaijan | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 10358078 | 4491 | 4 | 4302.33994591285 | 188.660054087148 | 4487 | 0.0386172029212369 | 1.82138089795373 | 0.0438505688669193 | monthly | 6 | 1047.9 | 0.933333333333333 | 1003.879320713 | 44.0206792870011 | 1046.96666666667 | 0.00901068068162195 | 0.424988876189204 | ||
24214 | 24214 | Azerbaijan | Azerbaijan | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 10358078 | 4491 | 4 | 4302.33994591285 | 188.660054087148 | 4487 | 0.0386172029212369 | 1.82138089795373 | 0.0438505688669188 | monthly | 6 | 1047.9 | 0.933333333333333 | 1003.879320713 | 44.0206792870011 | 1046.96666666667 | 0.00901068068162195 | 0.424988876189204 | ||
21483 | 21483 | Azerbaijan | Azerbaijan | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 10358078 | 4350 | 4 | 4859.12461077661 | -509.124610776615 | 4346 | 0.0386172029212369 | -4.91524210163908 | -0.104777022932787 | monthly | 5 | 982.258064516129 | 0.903225806451613 | 1097.2216863044 | -114.963621788268 | 981.354838709677 | 0.00872001356285995 | -1.10989337778947 | ||
24213 | 24213 | Azerbaijan | Azerbaijan | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 10358078 | 4350 | 4 | 4859.12461077661 | -509.124610776615 | 4346 | 0.0386172029212369 | -4.91524210163908 | -0.104777022932788 | monthly | 5 | 982.258064516129 | 0.903225806451613 | 1097.2216863044 | -114.963621788268 | 981.354838709677 | 0.00872001356285995 | -1.10989337778947 | ||
21482 | 21482 | Azerbaijan | Azerbaijan | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 10358078 | 5025 | 17 | 5339.53994591285 | -314.539945912852 | 5008 | 0.164123112415257 | -3.03666322953787 | -0.05890768663574 | monthly | 4 | 1172.5 | 3.96666666666667 | 1245.89265404633 | -73.3926540463322 | 1168.53333333333 | 0.0382953928968933 | -0.708554753558837 | ||
24212 | 24212 | Azerbaijan | Azerbaijan | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 10358078 | 5025 | 17 | 5339.53994591285 | -314.539945912852 | 5008 | 0.164123112415257 | -3.03666322953787 | -0.0589076866357403 | monthly | 4 | 1172.5 | 3.96666666666667 | 1245.89265404633 | -73.3926540463322 | 1168.53333333333 | 0.0382953928968933 | -0.708554753558837 | ||
21481 | 21481 | Azerbaijan | Azerbaijan | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 10358078 | 6166 | 275 | 4752.72461077662 | 1413.27538922338 | 5891 | 2.65493270083504 | 13.6441856223073 | 0.297361093891035 | monthly | 3 | 1392.32258064516 | 62.0967741935484 | 1073.19587985278 | 319.126700792377 | 1330.22580645161 | 0.599500932446622 | 3.08094514052102 | ||
24211 | 24211 | Azerbaijan | Azerbaijan | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 10358078 | 6166 | 275 | 4752.72461077662 | 1413.27538922338 | 5891 | 2.65493270083504 | 13.6441856223074 | 0.297361093891036 | monthly | 3 | 1392.32258064516 | 62.0967741935484 | 1073.19587985278 | 319.126700792377 | 1330.22580645161 | 0.599500932446622 | 3.08094514052102 | ||
21480 | 21480 | Azerbaijan | Azerbaijan | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 10358078 | 6548 | 683 | 4968.67125571622 | 1579.32874428378 | 5865 | 6.59388739880121 | 15.2473146493373 | 0.317857363267259 | monthly | 2 | 1637.0 | 170.75 | 1242.16781392906 | 394.832186070945 | 1466.25 | 1.6484718497003 | 3.81182866233431 | ||
24210 | 24210 | Azerbaijan | Azerbaijan | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 10358078 | 6548 | 683 | 4968.67125571622 | 1579.32874428378 | 5865 | 6.59388739880121 | 15.2473146493372 | 0.317857363267259 | monthly | 2 | 1637.0 | 170.75 | 1242.16781392906 | 394.832186070945 | 1466.25 | 1.6484718497003 | 3.81182866233431 | ||
21479 | 21479 | Azerbaijan | Azerbaijan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 10358078 | 6009 | 376 | 5453.82548303228 | 555.17451696772 | 5633 | 3.63001707459627 | 5.35982174461054 | 0.101795431242704 | monthly | 1 | 1356.87096774194 | 84.9032258064516 | 1231.50898003955 | 125.361987702388 | 1271.96774193548 | 0.819681274908836 | 1.21028232942818 | ||
24209 | 24209 | Azerbaijan | Azerbaijan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 10358078 | 6009 | 376 | 5453.82548303228 | 555.17451696772 | 5633 | 3.63001707459627 | 5.35982174461053 | 0.101795431242704 | monthly | 1 | 1356.87096774194 | 84.9032258064516 | 1231.50898003955 | 125.361987702388 | 1271.96774193548 | 0.819681274908836 | 1.21028232942818 |
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);