economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
24 rows where cadence = "monthly", country = "San Marino" and year = 2021 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, days, total_deaths, covid_deaths, expected_deaths, non_covid_deaths, covid_deaths_per_100k, month, total_deaths_per_7_days, covid_deaths_per_7_days, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18297 | 18297 | San Marino | San Marino | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 33690 | 35 | 7 | 22.271016237913 | 12.728983762087 | 28 | 20.77767883645 | 37.7826766461473 | 0.571549300943794 | monthly | 12 | 7.90322580645161 | 1.58064516129032 | 5.02893915049648 | 2.87428665595514 | 6.32258064516129 | 4.69173393081129 | 8.53157214590424 | ||
22830 | 22830 | San Marino | San Marino | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 33690 | 35 | 7 | 22.271016237913 | 12.728983762087 | 28 | 20.77767883645 | 37.7826766461472 | 0.571549300943791 | monthly | 12 | 7.90322580645161 | 1.58064516129032 | 5.02893915049648 | 2.87428665595514 | 6.32258064516129 | 4.69173393081129 | 8.53157214590424 | ||
18296 | 18296 | San Marino | San Marino | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 33690 | 23 | 1 | 21.8429189399158 | 1.15708106008422 | 22 | 2.96823983377857 | 3.43449409345273 | 0.0529728221428214 | monthly | 11 | 5.36666666666667 | 0.233333333333333 | 5.09668108598035 | 0.269985580686319 | 5.13333333333333 | 0.692589294548333 | 0.80138195513897 | ||
22829 | 22829 | San Marino | San Marino | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 33690 | 23 | 1 | 21.8429189399158 | 1.15708106008422 | 22 | 2.96823983377857 | 3.43449409345272 | 0.0529728221428203 | monthly | 11 | 5.36666666666667 | 0.233333333333333 | 5.09668108598035 | 0.269985580686319 | 5.13333333333333 | 0.692589294548333 | 0.80138195513897 | ||
18295 | 18295 | San Marino | San Marino | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 33690 | 26 | 1 | 20.071016237913 | 5.92898376208704 | 25 | 2.96823983377857 | 17.5986457764531 | 0.295400277285788 | monthly | 10 | 5.87096774193548 | 0.225806451612903 | 4.53216495694809 | 1.3388027849874 | 5.64516129032258 | 0.670247704401613 | 3.97388775597327 | ||
22828 | 22828 | San Marino | San Marino | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 33690 | 26 | 1 | 20.071016237913 | 5.92898376208704 | 25 | 2.96823983377857 | 17.5986457764531 | 0.295400277285785 | monthly | 10 | 5.87096774193548 | 0.225806451612903 | 4.53216495694809 | 1.3388027849874 | 5.64516129032258 | 0.670247704401613 | 3.97388775597327 | ||
18294 | 18294 | San Marino | San Marino | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 33690 | 23 | 1 | 20.6429189399158 | 2.35708106008422 | 22 | 2.96823983377857 | 6.99638189398701 | 0.114183515758835 | monthly | 9 | 5.36666666666667 | 0.233333333333333 | 4.81668108598035 | 0.549985580686319 | 5.13333333333333 | 0.692589294548333 | 1.63248910859697 | ||
22827 | 22827 | San Marino | San Marino | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 33690 | 23 | 1 | 20.6429189399158 | 2.35708106008422 | 22 | 2.96823983377857 | 6.996381893987 | 0.114183515758834 | monthly | 9 | 5.36666666666667 | 0.233333333333333 | 4.81668108598035 | 0.549985580686319 | 5.13333333333333 | 0.692589294548333 | 1.63248910859697 | ||
18293 | 18293 | San Marino | San Marino | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 33690 | 22 | 0 | 21.271016237913 | 0.728983762087037 | 22 | 0.0 | 2.1637986408045 | 0.0342712239948233 | monthly | 8 | 4.96774193548387 | 0.0 | 4.80313269888357 | 0.164609236600299 | 4.96774193548387 | 0.0 | 0.488599693084887 | ||
22826 | 22826 | San Marino | San Marino | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 33690 | 22 | 0 | 21.271016237913 | 0.728983762087037 | 22 | 0.0 | 2.1637986408045 | 0.0342712239948215 | monthly | 8 | 4.96774193548387 | 0.0 | 4.80313269888357 | 0.164609236600299 | 4.96774193548387 | 0.0 | 0.488599693084887 | ||
18292 | 18292 | San Marino | San Marino | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 33690 | 24 | 0 | 19.871016237913 | 4.12898376208703 | 24 | 0.0 | 12.2558140756516 | 0.207789260128987 | monthly | 7 | 5.41935483870968 | 0.0 | 4.48700366662551 | 0.932351172084169 | 5.41935483870968 | 0.0 | 2.76744188805037 | ||
22825 | 22825 | San Marino | San Marino | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 33690 | 24 | 0 | 19.871016237913 | 4.12898376208703 | 24 | 0.0 | 12.2558140756516 | 0.207789260128985 | monthly | 7 | 5.41935483870968 | 0.0 | 4.48700366662551 | 0.932351172084169 | 5.41935483870968 | 0.0 | 2.76744188805037 | ||
18291 | 18291 | San Marino | San Marino | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 33690 | 20 | 0 | 22.2429189399158 | -2.24291893991577 | 20 | 0.0 | -6.65752134139439 | -0.100837437117606 | monthly | 6 | 4.66666666666667 | 0.0 | 5.19001441931368 | -0.523347752647013 | 4.66666666666667 | 0.0 | -1.55342164632536 | ||
22824 | 22824 | San Marino | San Marino | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 33690 | 20 | 0 | 22.2429189399158 | -2.24291893991577 | 20 | 0.0 | -6.65752134139439 | -0.100837437117608 | monthly | 6 | 4.66666666666667 | 0.0 | 5.19001441931368 | -0.523347752647013 | 4.66666666666667 | 0.0 | -1.55342164632536 | ||
18290 | 18290 | San Marino | San Marino | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 33690 | 21 | 0 | 21.071016237913 | -0.0710162379129677 | 21 | 0.0 | -0.210793226218367 | -0.00337032809007043 | monthly | 5 | 4.74193548387097 | 0.0 | 4.75797140856099 | -0.016035924690025 | 4.74193548387097 | 0.0 | -0.0475984704364054 | ||
22823 | 22823 | San Marino | San Marino | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 33690 | 21 | 0 | 21.071016237913 | -0.0710162379129677 | 21 | 0.0 | -0.210793226218367 | -0.00337032809007187 | monthly | 5 | 4.74193548387097 | 0.0 | 4.75797140856099 | -0.016035924690025 | 4.74193548387097 | 0.0 | -0.0475984704364054 | ||
18289 | 18289 | San Marino | San Marino | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 33690 | 28 | 6 | 23.4429189399158 | 4.55708106008423 | 22 | 17.8094390026714 | 13.5265095282999 | 0.194390513901619 | monthly | 4 | 6.53333333333333 | 1.4 | 5.47001441931368 | 1.06331891401965 | 5.13333333333333 | 4.15553576729 | 3.1561855566033 | ||
22822 | 22822 | San Marino | San Marino | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 33690 | 28 | 6 | 23.4429189399158 | 4.55708106008423 | 22 | 17.8094390026714 | 13.5265095282999 | 0.194390513901618 | monthly | 4 | 6.53333333333333 | 1.4 | 5.47001441931368 | 1.06331891401965 | 5.13333333333333 | 4.15553576729 | 3.1561855566033 | ||
18288 | 18288 | San Marino | San Marino | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 33690 | 36 | 10 | 22.071016237913 | 13.928983762087 | 26 | 29.6823983377857 | 41.3445644466816 | 0.631098432982901 | monthly | 3 | 8.12903225806452 | 2.25806451612903 | 4.9837778601739 | 3.14525439789062 | 5.87096774193548 | 6.70247704401612 | 9.33586939118617 | ||
22821 | 22821 | San Marino | San Marino | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 33690 | 36 | 10 | 22.071016237913 | 13.928983762087 | 26 | 29.6823983377857 | 41.3445644466815 | 0.631098432982898 | monthly | 3 | 8.12903225806452 | 2.25806451612903 | 4.9837778601739 | 3.14525439789062 | 5.87096774193548 | 6.70247704401612 | 9.33586939118617 | ||
18287 | 18287 | San Marino | San Marino | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 33690 | 32 | 7 | 23.2171194331151 | 8.78288056688488 | 25 | 20.77767883645 | 26.0696959539474 | 0.378293293110154 | monthly | 2 | 8.0 | 1.75 | 5.80427985827878 | 2.19572014172122 | 6.25 | 5.1944197091125 | 6.51742398848685 | ||
22820 | 22820 | San Marino | San Marino | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 33690 | 32 | 7 | 23.2171194331151 | 8.78288056688488 | 25 | 20.77767883645 | 26.0696959539474 | 0.378293293110155 | monthly | 2 | 8.0 | 1.75 | 5.80427985827878 | 2.19572014172122 | 6.25 | 5.1944197091125 | 6.51742398848685 | ||
18286 | 18286 | San Marino | San Marino | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 33690 | 22 | 8 | 24.4288058748405 | -2.42880587484045 | 14 | 23.7459186702286 | -7.20927834621684 | -0.0994238477019425 | monthly | 1 | 4.96774193548387 | 1.80645161290323 | 5.51618197173817 | -0.548440036254296 | 3.16129032258065 | 5.3619816352129 | -1.62790156204896 | ||
22819 | 22819 | San Marino | San Marino | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 33690 | 22 | 8 | 24.4288058748405 | -2.42880587484045 | 14 | 23.7459186702286 | -7.20927834621683 | -0.0994238477019441 | monthly | 1 | 4.96774193548387 | 1.80645161290323 | 5.51618197173817 | -0.548440036254296 | 3.16129032258065 | 5.3619816352129 | -1.62790156204896 |
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);