economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
22 rows where cadence = "monthly", covid_deaths = 1 and year = 2022 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, start_date, end_date, days, population, total_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_pct_change, 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, start_date (date), end_date (date)
country 9
- Kosovo 4
- San Marino 4
- Albania 2
- Liechtenstein 2
- Monaco 2
- Mongolia 2
- Qatar 2
- Saint Kitts and Nevis 2
- Taiwan 2
cadence 1
- monthly · 22 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18307 | 18307 | San Marino | San Marino | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 33690 | 25 | 1 | 20.2887702973912 | 4.7112297026088 | 24 | 2.96823983377857 | 13.9840596693642 | 0.232208735845099 | monthly | 10 | 5.64516129032258 | 0.225806451612903 | 4.58133522844317 | 1.06382606187941 | 5.41935483870968 | 0.670247704401613 | 3.15769089308224 | ||
22840 | 22840 | San Marino | San Marino | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 33690 | 25 | 1 | 20.2887702973912 | 4.7112297026088 | 24 | 2.96823983377857 | 13.9840596693642 | 0.232208735845099 | monthly | 10 | 5.64516129032258 | 0.225806451612903 | 4.58133522844317 | 1.06382606187941 | 5.41935483870968 | 0.670247704401613 | 3.15769089308224 | ||
18058 | 18058 | Qatar | Qatar | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 2695131 | 230 | 1 | 178.607381805769 | 51.392618194231 | 229 | 0.0371039478229444 | 1.90686902396325 | 0.287740728712541 | monthly | 9 | 53.6666666666667 | 0.233333333333333 | 41.6750557546794 | 11.9916109119872 | 53.4333333333333 | 0.0086575878253537 | 0.444936105591426 | ||
22715 | 22715 | Qatar | Qatar | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 2695131 | 230 | 1 | 178.607381805769 | 51.392618194231 | 229 | 0.0371039478229444 | 1.90686902396325 | 0.287740728712541 | monthly | 9 | 53.6666666666667 | 0.233333333333333 | 41.6750557546794 | 11.9916109119872 | 53.4333333333333 | 0.0086575878253537 | 0.444936105591426 | ||
22501 | 22501 | Mongolia | Mongolia | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 3398373 | 1438 | 1 | 1474.334397616 | -36.3343976160011 | 1437 | 0.0294258458385822 | -1.0691703828862 | -0.0246446109340952 | monthly | 7 | 324.709677419355 | 0.225806451612903 | 332.914218816516 | -8.20454139716153 | 324.483870967742 | 0.00664454583451855 | -0.241425570329141 | ||
23878 | 23878 | Mongolia | Mongolia | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 3398373 | 1438 | 1 | 1474.334397616 | -36.3343976160011 | 1437 | 0.0294258458385822 | -1.06917038288619 | -0.024644610934096 | monthly | 7 | 324.709677419355 | 0.225806451612903 | 332.914218816516 | -8.20454139716153 | 324.483870967742 | 0.00664454583451855 | -0.241425570329141 | ||
17954 | 17954 | Kosovo | Kosovo | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 1782115 | 640 | 1 | 795.127411115231 | -155.127411115231 | 639 | 0.0561131015675195 | -8.70468017581533 | -0.195097551595728 | monthly | 6 | 149.333333333333 | 0.233333333333333 | 185.529729260221 | -36.1963959268873 | 149.1 | 0.0130930570324212 | -2.03109204102358 | ||
18270 | 18270 | Monaco | Monaco | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 36491 | 39 | 1 | 32.7622982031772 | 6.23770179682282 | 38 | 2.74040174289551 | 17.0938088756757 | 0.190392681189194 | monthly | 6 | 9.1 | 0.233333333333333 | 7.64453624740801 | 1.45546375259199 | 8.86666666666667 | 0.639427073342285 | 3.98855540432433 | ||
22180 | 22180 | Kosovo | Kosovo | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 1782115 | 640 | 1 | 795.127411115231 | -155.127411115231 | 639 | 0.0561131015675195 | -8.70468017581531 | -0.195097551595728 | monthly | 6 | 149.333333333333 | 0.233333333333333 | 185.529729260221 | -36.1963959268873 | 149.1 | 0.0130930570324212 | -2.03109204102358 | ||
22467 | 22467 | Monaco | Monaco | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 36491 | 39 | 1 | 32.7622982031772 | 6.23770179682282 | 38 | 2.74040174289551 | 17.0938088756757 | 0.190392681189193 | monthly | 6 | 9.1 | 0.233333333333333 | 7.64453624740801 | 1.45546375259199 | 8.86666666666667 | 0.639427073342285 | 3.98855540432433 | ||
11175 | 11175 | Albania | Albania | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 2842318 | 1675 | 1 | 1654.68391260719 | 20.316087392807 | 1674 | 0.0351825517060371 | 0.714771795161803 | 0.0122779264595594 | monthly | 5 | 378.225806451613 | 0.225806451612903 | 373.638302846786 | 4.5875036048274 | 378.0 | 0.00794444715942774 | 0.161400082778472 | ||
17953 | 17953 | Kosovo | Kosovo | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 1782115 | 746 | 1 | 843.171658152406 | -97.1716581524056 | 745 | 0.0561131015675195 | -5.45260312339022 | -0.115245403723997 | monthly | 5 | 168.451612903226 | 0.225806451612903 | 190.393600227963 | -21.9419873247367 | 168.225806451613 | 0.012670700353956 | -1.23123296334618 | ||
21335 | 21335 | Albania | Albania | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 2842318 | 1675 | 1 | 1654.68391260719 | 20.316087392807 | 1674 | 0.0351825517060371 | 0.714771795161801 | 0.0122779264595612 | monthly | 5 | 378.225806451613 | 0.225806451612903 | 373.638302846786 | 4.5875036048274 | 378.0 | 0.00794444715942774 | 0.161400082778472 | ||
22179 | 22179 | Kosovo | Kosovo | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 1782115 | 746 | 1 | 843.171658152406 | -97.1716581524056 | 745 | 0.0561131015675195 | -5.45260312339022 | -0.115245403723997 | monthly | 5 | 168.451612903226 | 0.225806451612903 | 190.393600227963 | -21.9419873247367 | 168.225806451613 | 0.012670700353956 | -1.23123296334618 | ||
21150 | 21150 | Liechtenstein | Liechtenstein | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 39355 | 19 | 1 | 21.5500509090054 | -2.55005090900535 | 18 | 2.54097319273282 | -6.47961099988655 | -0.118331549181619 | monthly | 4 | 4.43333333333333 | 0.233333333333333 | 5.02834521210125 | -0.595011878767916 | 4.2 | 0.59289374497099 | -1.51190923330686 | ||
22294 | 22294 | Liechtenstein | Liechtenstein | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 39355 | 19 | 1 | 21.5500509090054 | -2.55005090900535 | 18 | 2.54097319273282 | -6.47961099988655 | -0.118331549181621 | monthly | 4 | 4.43333333333333 | 0.233333333333333 | 5.02834521210125 | -0.595011878767916 | 4.2 | 0.59289374497099 | -1.51190923330686 | ||
18300 | 18300 | San Marino | San Marino | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 33690 | 19 | 1 | 22.2887702973912 | -3.28877029739121 | 18 | 2.96823983377857 | -9.76185900086438 | -0.147552792438089 | monthly | 3 | 4.29032258064516 | 0.225806451612903 | 5.03294813166898 | -0.742625551023822 | 4.06451612903226 | 0.670247704401613 | -2.20429074213067 | ||
19530 | 19530 | Saint Kitts and Nevis | Saint Kitts and Nevis | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 47681 | 39 | 1 | 32.5483040112606 | 6.45169598873938 | 38 | 2.09727144984375 | 13.5309578002546 | 0.198219114166665 | monthly | 3 | 8.80645161290323 | 0.225806451612903 | 7.34961703480078 | 1.45683457810244 | 8.58064516129032 | 0.473577424158267 | 3.05537756779942 | ||
22777 | 22777 | Saint Kitts and Nevis | Saint Kitts and Nevis | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 47681 | 39 | 1 | 32.5483040112606 | 6.45169598873938 | 38 | 2.09727144984375 | 13.5309578002546 | 0.198219114166666 | monthly | 3 | 8.80645161290323 | 0.225806451612903 | 7.34961703480078 | 1.45683457810244 | 8.58064516129032 | 0.473577424158267 | 3.05537756779942 | ||
22833 | 22833 | San Marino | San Marino | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 33690 | 19 | 1 | 22.2887702973912 | -3.28877029739121 | 18 | 2.96823983377857 | -9.76185900086438 | -0.147552792438089 | monthly | 3 | 4.29032258064516 | 0.225806451612903 | 5.03294813166898 | -0.742625551023822 | 4.06451612903226 | 0.670247704401613 | -2.20429074213067 | ||
19297 | 19297 | Taiwan | Taiwan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 23893396 | 15954 | 1 | 15920.2750930487 | 33.7249069513455 | 15953 | 0.00418525688018564 | 0.141147398851739 | 0.0021183620731573 | monthly | 1 | 3602.51612903226 | 0.225806451612903 | 3594.9008274626 | 7.61530156965866 | 3602.29032258065 | 0.000945058005203209 | 0.0318719932891024 | ||
22968 | 22968 | Taiwan | Taiwan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 23893396 | 15954 | 1 | 15920.2750930487 | 33.7249069513455 | 15953 | 0.00418525688018564 | 0.141147398851739 | 0.00211836207315441 | monthly | 1 | 3602.51612903226 | 0.225806451612903 | 3594.9008274626 | 7.61530156965866 | 3602.29032258065 | 0.0009450580052032 | 0.0318719932891024 |
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);