economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
22 rows where cadence = "monthly", country = "Azerbaijan" and days = 30 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, total_deaths, expected_deaths, excess_deaths, non_covid_deaths, excess_deaths_per_100k, excess_deaths_pct_change, month, total_deaths_per_7_days, covid_deaths_per_7_days, expected_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
21477 | 21477 | Azerbaijan | Azerbaijan | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 10358078 | 7610 | 782 | 4738.63195673028 | 2871.36804326972 | 6828 | 7.54966317110182 | 27.7210505971255 | 0.605948735729838 | monthly | 11 | 1775.66666666667 | 182.466666666667 | 1105.68078990373 | 669.985876762934 | 1593.2 | 1.76158807325709 | 6.46824513932927 | ||
24207 | 24207 | Azerbaijan | Azerbaijan | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 10358078 | 7610 | 782 | 4738.63195673028 | 2871.36804326972 | 6828 | 7.54966317110182 | 27.7210505971254 | 0.605948735729837 | monthly | 11 | 1775.66666666667 | 182.466666666667 | 1105.68078990373 | 669.985876762934 | 1593.2 | 1.76158807325709 | 6.46824513932927 | ||
21475 | 21475 | Azerbaijan | Azerbaijan | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 10358078 | 7540 | 889 | 4185.03195673028 | 3354.96804326972 | 6651 | 8.58267334924491 | 32.389870430303 | 0.801658882884832 | monthly | 9 | 1759.33333333333 | 207.433333333333 | 976.507456570399 | 782.825876762935 | 1551.9 | 2.00262378149048 | 7.55763643373736 | ||
24205 | 24205 | Azerbaijan | Azerbaijan | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 10358078 | 7540 | 889 | 4185.03195673028 | 3354.96804326972 | 6651 | 8.58267334924491 | 32.389870430303 | 0.801658882884832 | monthly | 9 | 1759.33333333333 | 207.433333333333 | 976.507456570399 | 782.825876762935 | 1551.9 | 2.00262378149048 | 7.55763643373736 | ||
21472 | 21472 | Azerbaijan | Azerbaijan | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 10358078 | 5198 | 61 | 4273.63195673028 | 924.368043269719 | 5137 | 0.588912344548863 | 8.92412707521336 | 0.216295659670457 | monthly | 6 | 1212.86666666667 | 14.2333333333333 | 997.180789903732 | 215.685876762934 | 1198.63333333333 | 0.137412880394735 | 2.08229631754979 | ||
24202 | 24202 | Azerbaijan | Azerbaijan | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 10358078 | 5198 | 61 | 4273.63195673028 | 924.368043269719 | 5137 | 0.588912344548863 | 8.92412707521337 | 0.216295659670456 | monthly | 6 | 1212.86666666667 | 14.2333333333333 | 997.180789903732 | 215.685876762934 | 1198.63333333333 | 0.137412880394735 | 2.08229631754979 | ||
21470 | 21470 | Azerbaijan | Azerbaijan | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 10358078 | 7400 | 950 | 5310.83195673028 | 2089.16804326972 | 6450 | 9.17158569379377 | 20.1694565658776 | 0.393378675938366 | monthly | 4 | 1726.66666666667 | 221.666666666667 | 1239.19412323707 | 487.472543429601 | 1505.0 | 2.14003666188521 | 4.7062065320381 | ||
24200 | 24200 | Azerbaijan | Azerbaijan | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 10358078 | 7400 | 950 | 5310.83195673028 | 2089.16804326972 | 6450 | 9.17158569379377 | 20.1694565658776 | 0.393378675938366 | monthly | 4 | 1726.66666666667 | 221.666666666667 | 1239.19412323707 | 487.472543429601 | 1505.0 | 2.14003666188521 | 4.7062065320381 | ||
21465 | 21465 | Azerbaijan | Azerbaijan | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 10358078 | 8378 | 662 | 4709.92396754771 | 3668.07603245229 | 7716 | 6.39114708346471 | 35.4127091189339 | 0.778797292212368 | monthly | 11 | 1954.86666666667 | 154.466666666667 | 1098.98225909447 | 855.884407572201 | 1800.4 | 1.49126765280843 | 8.26296546108459 | ||
24195 | 24195 | Azerbaijan | Azerbaijan | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 10358078 | 8378 | 662 | 4709.92396754771 | 3668.07603245229 | 7716 | 6.39114708346471 | 35.4127091189339 | 0.778797292212368 | monthly | 11 | 1954.86666666667 | 154.466666666667 | 1098.98225909447 | 855.884407572201 | 1800.4 | 1.49126765280843 | 8.26296546108459 | ||
21463 | 21463 | Azerbaijan | Azerbaijan | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 10358078 | 4520 | 57 | 4156.32396754771 | 363.676032452291 | 4463 | 0.550295141627626 | 3.51103778570012 | 0.0874994430876532 | monthly | 9 | 1054.66666666667 | 13.3 | 969.808925761132 | 84.8577409055346 | 1041.36666666667 | 0.128402199713113 | 0.819242149996694 | ||
24193 | 24193 | Azerbaijan | Azerbaijan | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 10358078 | 4520 | 57 | 4156.32396754771 | 363.676032452291 | 4463 | 0.550295141627626 | 3.51103778570012 | 0.0874994430876535 | monthly | 9 | 1054.66666666667 | 13.3 | 969.808925761132 | 84.8577409055346 | 1041.36666666667 | 0.128402199713113 | 0.819242149996694 | ||
21460 | 21460 | Azerbaijan | Azerbaijan | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 10358078 | 6203 | 150 | 4244.92396754771 | 1958.07603245229 | 6053 | 1.44814510954639 | 18.9038548701051 | 0.461274700659354 | monthly | 6 | 1447.36666666667 | 35.0 | 990.482259094465 | 456.884407572201 | 1412.36666666667 | 0.337900525560823 | 4.4108994696912 | ||
24190 | 24190 | Azerbaijan | Azerbaijan | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 10358078 | 6203 | 150 | 4244.92396754771 | 1958.07603245229 | 6053 | 1.44814510954639 | 18.9038548701052 | 0.461274700659355 | monthly | 6 | 1447.36666666667 | 35.0 | 990.482259094465 | 456.884407572201 | 1412.36666666667 | 0.337900525560823 | 4.4108994696912 | ||
21458 | 21458 | Azerbaijan | Azerbaijan | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 10358078 | 4511 | 19 | 5282.12396754771 | -771.123967547709 | 4492 | 0.183431713875875 | -7.4446626830548 | -0.145987480090459 | monthly | 4 | 1052.56666666667 | 4.43333333333333 | 1232.4955924278 | -179.928925761132 | 1048.13333333333 | 0.0428007332377043 | -1.73708795937945 | ||
24188 | 24188 | Azerbaijan | Azerbaijan | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 10358078 | 4511 | 19 | 5282.12396754771 | -771.123967547709 | 4492 | 0.183431713875875 | -7.4446626830548 | -0.145987480090459 | monthly | 4 | 1052.56666666667 | 4.43333333333333 | 1232.4955924278 | -179.928925761132 | 1048.13333333333 | 0.0428007332377043 | -1.73708795937945 |
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);