economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
24 rows where cadence = "monthly", country = "Bolivia" and year = 2021 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, total_deaths, covid_deaths, expected_deaths, excess_deaths, covid_deaths_per_100k, excess_deaths_per_100k, excess_deaths_pct_change, month, covid_deaths_per_7_days, expected_deaths_per_7_days, non_covid_deaths_per_7_days, covid_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21632 | 21632 | Bolivia | Bolivia | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 12224114 | 6564 | 509 | 4568.82360639784 | 1995.17639360216 | 6055 | 4.16390095838439 | 16.3216441993437 | 0.436693679924141 | monthly | 12 | 1482.1935483871 | 114.935483870968 | 1031.66984660596 | 450.523701781134 | 1367.25806451613 | 0.940235700280345 | 3.68553256114213 | ||
23846 | 23846 | Bolivia | Bolivia | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 12224114 | 6564 | 509 | 4568.82360639784 | 1995.17639360216 | 6055 | 4.16390095838439 | 16.3216441993437 | 0.436693679924142 | monthly | 12 | 1482.1935483871 | 114.935483870968 | 1031.66984660596 | 450.523701781134 | 1367.25806451613 | 0.940235700280345 | 3.68553256114213 | ||
21631 | 21631 | Bolivia | Bolivia | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 12224114 | 5202 | 246 | 4276.82284490113 | 925.177155098867 | 4956 | 2.01241578735277 | 7.56845980902065 | 0.216323469231809 | monthly | 11 | 1213.8 | 57.4 | 997.925330476931 | 215.874669523069 | 1156.4 | 0.469563683715646 | 1.76597395543815 | ||
23845 | 23845 | Bolivia | Bolivia | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 12224114 | 5202 | 246 | 4276.82284490113 | 925.177155098867 | 4956 | 2.01241578735277 | 7.56845980902065 | 0.216323469231809 | monthly | 11 | 1213.8 | 57.4 | 997.925330476931 | 215.874669523069 | 1156.4 | 0.469563683715646 | 1.76597395543815 | ||
21630 | 21630 | Bolivia | Bolivia | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 12224114 | 5045 | 190 | 4473.02360639784 | 571.976393602163 | 4855 | 1.55430487641067 | 4.67908261982965 | 0.127872429017377 | monthly | 10 | 1139.1935483871 | 42.9032258064516 | 1010.03758854145 | 129.15595984565 | 1096.29032258065 | 0.350972068866927 | 1.05656704318734 | ||
23844 | 23844 | Bolivia | Bolivia | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 12224114 | 5045 | 190 | 4473.02360639784 | 571.976393602163 | 4855 | 1.55430487641067 | 4.67908261982965 | 0.127872429017378 | monthly | 10 | 1139.1935483871 | 42.9032258064516 | 1010.03758854145 | 129.15595984565 | 1096.29032258065 | 0.350972068866927 | 1.05656704318734 | ||
21629 | 21629 | Bolivia | Bolivia | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 12224114 | 5067 | 283 | 4375.82284490113 | 691.177155098868 | 4784 | 2.31509621065379 | 5.6542106454412 | 0.157953641999985 | monthly | 9 | 1182.3 | 66.0333333333333 | 1021.02533047693 | 161.274669523069 | 1116.26666666667 | 0.540189115819219 | 1.31931581726961 | ||
23843 | 23843 | Bolivia | Bolivia | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 12224114 | 5067 | 283 | 4375.82284490113 | 691.177155098868 | 4784 | 2.31509621065379 | 5.6542106454412 | 0.157953641999985 | monthly | 9 | 1182.3 | 66.0333333333333 | 1021.02533047693 | 161.274669523069 | 1116.26666666667 | 0.540189115819219 | 1.31931581726961 | ||
21628 | 21628 | Bolivia | Bolivia | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 12224114 | 6087 | 631 | 4599.22360639784 | 1487.77639360216 | 5456 | 5.16192830007966 | 12.1708321241291 | 0.323484248848558 | monthly | 8 | 1374.48387096774 | 142.483870967742 | 1038.534362735 | 335.949508232746 | 1232.0 | 1.16559671292121 | 2.74825241512593 | ||
23842 | 23842 | Bolivia | Bolivia | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 12224114 | 6087 | 631 | 4599.22360639784 | 1487.77639360216 | 5456 | 5.16192830007966 | 12.1708321241291 | 0.323484248848559 | monthly | 8 | 1374.48387096774 | 142.483870967742 | 1038.534362735 | 335.949508232746 | 1232.0 | 1.16559671292121 | 2.74825241512593 | ||
21627 | 21627 | Bolivia | Bolivia | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 12224114 | 7631 | 1054 | 4729.02360639784 | 2901.97639360216 | 6577 | 8.62230178808869 | 23.7397687358132 | 0.613652338228152 | monthly | 7 | 1723.12903225806 | 238.0 | 1067.84404015435 | 655.284992103714 | 1485.12903225806 | 1.9469713715039 | 5.36059294034492 | ||
23841 | 23841 | Bolivia | Bolivia | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 12224114 | 7631 | 1054 | 4729.02360639784 | 2901.97639360216 | 6577 | 8.62230178808869 | 23.7397687358132 | 0.613652338228153 | monthly | 7 | 1723.12903225806 | 238.0 | 1067.84404015435 | 655.284992103714 | 1485.12903225806 | 1.9469713715039 | 5.36059294034492 | ||
21626 | 21626 | Bolivia | Bolivia | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 12224114 | 10599 | 2243 | 4696.62284490113 | 5902.37715509887 | 8356 | 18.3489780936271 | 48.2847031293955 | 1.25672794048318 | monthly | 6 | 2473.1 | 523.366666666667 | 1095.87866381026 | 1377.22133618974 | 1949.73333333333 | 4.28142822184632 | 11.2664307301923 | ||
23840 | 23840 | Bolivia | Bolivia | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 12224114 | 10599 | 2243 | 4696.62284490113 | 5902.37715509887 | 8356 | 18.3489780936271 | 48.2847031293955 | 1.25672794048318 | monthly | 6 | 2473.1 | 523.366666666667 | 1095.87866381026 | 1377.22133618974 | 1949.73333333333 | 4.28142822184632 | 11.2664307301923 | ||
21625 | 21625 | Bolivia | Bolivia | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 12224114 | 9055 | 1573 | 4584.22360639784 | 4470.77639360216 | 7482 | 12.8680082662842 | 36.5734186837767 | 0.975252687797046 | monthly | 5 | 2044.67741935484 | 355.193548387097 | 1035.1472659608 | 1009.53015339404 | 1689.48387096774 | 2.90567928593513 | 8.25851389633667 | ||
23839 | 23839 | Bolivia | Bolivia | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 12224114 | 9055 | 1573 | 4584.22360639784 | 4470.77639360216 | 7482 | 12.8680082662842 | 36.5734186837767 | 0.975252687797048 | monthly | 5 | 2044.67741935484 | 355.193548387097 | 1035.1472659608 | 1009.53015339404 | 1689.48387096774 | 2.90567928593513 | 8.25851389633667 | ||
21624 | 21624 | Bolivia | Bolivia | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 12224114 | 5666 | 694 | 4302.82284490113 | 1363.17715509887 | 4972 | 5.67730307488952 | 11.1515415767463 | 0.316809965047537 | monthly | 4 | 1322.06666666667 | 161.933333333333 | 1003.9919971436 | 318.074669523069 | 1160.13333333333 | 1.32470405080755 | 2.60202636790748 | ||
23838 | 23838 | Bolivia | Bolivia | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 12224114 | 5666 | 694 | 4302.82284490113 | 1363.17715509887 | 4972 | 5.67730307488952 | 11.1515415767463 | 0.316809965047536 | monthly | 4 | 1322.06666666667 | 161.933333333333 | 1003.9919971436 | 318.074669523069 | 1160.13333333333 | 1.32470405080755 | 2.60202636790748 | ||
21623 | 21623 | Bolivia | Bolivia | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 12224114 | 6026 | 608 | 4500.02360639784 | 1525.97639360216 | 5418 | 4.97377560451416 | 12.4833292098074 | 0.339104086350264 | monthly | 3 | 1360.70967741935 | 137.290322580645 | 1016.134362735 | 344.575314684359 | 1223.41935483871 | 1.12311062037417 | 2.81881627318233 | ||
23837 | 23837 | Bolivia | Bolivia | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 12224114 | 6026 | 608 | 4500.02360639784 | 1525.97639360216 | 5418 | 4.97377560451416 | 12.4833292098075 | 0.339104086350265 | monthly | 3 | 1360.70967741935 | 137.290322580645 | 1016.134362735 | 344.575314684359 | 1223.41935483871 | 1.12311062037417 | 2.81881627318233 | ||
21622 | 21622 | Bolivia | Bolivia | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 12224114 | 7382 | 1270 | 4136.44624287615 | 3245.55375712385 | 6112 | 10.3893010160082 | 26.5504212176347 | 0.784623700287026 | monthly | 2 | 1845.5 | 317.5 | 1034.11156071904 | 811.388439280962 | 1528.0 | 2.59732525400205 | 6.63760530440866 | ||
23836 | 23836 | Bolivia | Bolivia | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 12224114 | 7382 | 1270 | 4136.44624287615 | 3245.55375712385 | 6112 | 10.3893010160082 | 26.5504212176347 | 0.784623700287025 | monthly | 2 | 1845.5 | 317.5 | 1034.11156071904 | 811.388439280962 | 1528.0 | 2.59732525400205 | 6.63760530440866 | ||
21621 | 21621 | Bolivia | Bolivia | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 12224114 | 9977 | 1214 | 4615.55398893142 | 5361.44601106858 | 8763 | 9.9311901050661 | 43.859587787455 | 1.16160400765019 | monthly | 1 | 2252.87096774194 | 274.129032258065 | 1042.22186846838 | 1210.64909927355 | 1978.74193548387 | 2.24252679791815 | 9.90377788748985 | ||
23835 | 23835 | Bolivia | Bolivia | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 12224114 | 9977 | 1214 | 4615.55398893142 | 5361.44601106858 | 8763 | 9.9311901050661 | 43.859587787455 | 1.1616040076502 | monthly | 1 | 2252.87096774194 | 274.129032258065 | 1042.22186846838 | 1210.64909927355 | 1978.74193548387 | 2.24252679791815 | 9.90377788748985 |
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);