economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
24 rows where country = "Bolivia" and year = 2020 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, days, total_deaths, covid_deaths, expected_deaths, excess_deaths, covid_deaths_per_100k, 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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21620 | 21620 | Bolivia | Bolivia | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 12224114 | 4822 | 208 | 4500.61770479836 | 321.382295201637 | 4614 | 1.70155481207063 | 2.62908457170505 | 0.0714084857416342 | monthly | 12 | 1088.83870967742 | 46.9677419354839 | 1016.26851398673 | 72.5701956906923 | 1041.87096774194 | 0.38422205433853 | 0.593664258126947 | ||
23834 | 23834 | Bolivia | Bolivia | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 12224114 | 4822 | 208 | 4500.61770479836 | 321.382295201637 | 4614 | 1.70155481207063 | 2.62908457170505 | 0.0714084857416335 | monthly | 12 | 1088.83870967742 | 46.9677419354839 | 1016.26851398673 | 72.5701956906923 | 1041.87096774194 | 0.38422205433853 | 0.593664258126947 | ||
21619 | 21619 | Bolivia | Bolivia | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 12224114 | 4642 | 232 | 4210.81713367584 | 431.182866324165 | 4410 | 1.89788805961725 | 3.52731385132833 | 0.102398858139859 | monthly | 11 | 1083.13333333333 | 54.1333333333333 | 982.523997857695 | 100.609335475638 | 1029.0 | 0.442840547244024 | 0.823039898643276 | ||
23833 | 23833 | Bolivia | Bolivia | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 12224114 | 4642 | 232 | 4210.81713367584 | 431.182866324165 | 4410 | 1.89788805961725 | 3.52731385132832 | 0.10239885813986 | monthly | 11 | 1083.13333333333 | 54.1333333333333 | 982.523997857695 | 100.609335475638 | 1029.0 | 0.442840547244024 | 0.823039898643276 | ||
21618 | 21618 | Bolivia | Bolivia | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 12224114 | 4972 | 760 | 4404.81770479836 | 567.182295201637 | 4212 | 6.2172195056427 | 4.6398642486616 | 0.128764079063654 | monthly | 10 | 1122.70967741935 | 171.612903225806 | 994.636255922211 | 128.073421497144 | 951.096774193548 | 1.40388827546771 | 1.04771128195584 | ||
23832 | 23832 | Bolivia | Bolivia | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 12224114 | 4972 | 760 | 4404.81770479836 | 567.182295201637 | 4212 | 6.2172195056427 | 4.6398642486616 | 0.128764079063654 | monthly | 10 | 1122.70967741935 | 171.612903225806 | 994.636255922211 | 128.073421497144 | 951.096774193548 | 1.40388827546771 | 1.04771128195584 | ||
21617 | 21617 | Bolivia | Bolivia | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 12224114 | 5240 | 2938 | 4309.81713367583 | 930.182866324166 | 2302 | 24.0344617204977 | 7.60940928990163 | 0.215828847831142 | monthly | 9 | 1222.66666666667 | 685.533333333333 | 1005.62399785769 | 217.042668808972 | 537.133333333333 | 5.60804106811613 | 1.77552883431038 | ||
23831 | 23831 | Bolivia | Bolivia | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 12224114 | 5240 | 2938 | 4309.81713367583 | 930.182866324166 | 2302 | 24.0344617204977 | 7.60940928990163 | 0.215828847831141 | monthly | 9 | 1222.66666666667 | 685.533333333333 | 1005.62399785769 | 217.042668808972 | 537.133333333333 | 5.60804106811613 | 1.77552883431038 | ||
21616 | 21616 | Bolivia | Bolivia | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 12224114 | 8283 | 2050 | 4531.01770479836 | 3751.98229520164 | 6233 | 16.7701315612731 | 30.693286198097 | 0.82806612987371 | monthly | 8 | 1870.35483870968 | 462.903225806452 | 1023.13303011576 | 847.221808593918 | 1407.45161290323 | 3.78680390093263 | 6.93074204473157 | ||
23830 | 23830 | Bolivia | Bolivia | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 12224114 | 8283 | 2050 | 4531.01770479836 | 3751.98229520164 | 6233 | 16.7701315612731 | 30.693286198097 | 0.828066129873709 | monthly | 8 | 1870.35483870968 | 462.903225806452 | 1023.13303011576 | 847.221808593918 | 1407.45161290323 | 3.78680390093263 | 6.93074204473157 | ||
21615 | 21615 | Bolivia | Bolivia | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 12224114 | 15992 | 1854 | 4660.81770479836 | 11331.1822952016 | 14138 | 15.1667433729757 | 92.6953257733166 | 2.43115758068291 | monthly | 7 | 3611.09677419355 | 418.645161290323 | 1052.44270753511 | 2558.65406665843 | 3192.45161290323 | 3.42474850357517 | 20.9312025939748 | ||
23829 | 23829 | Bolivia | Bolivia | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 12224114 | 15992 | 1854 | 4660.81770479836 | 11331.1822952016 | 14138 | 15.1667433729757 | 92.6953257733169 | 2.43115758068291 | monthly | 7 | 3611.09677419355 | 418.645161290323 | 1052.44270753511 | 2558.65406665843 | 3192.45161290323 | 3.42474850357517 | 20.9312025939748 | ||
21614 | 21614 | Bolivia | Bolivia | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 12224114 | 8960 | 810 | 4630.61713367583 | 4329.38286632417 | 8150 | 6.62624710469814 | 35.4167415840868 | 0.93494727405534 | monthly | 6 | 2090.66666666667 | 189.0 | 1080.47733119103 | 1010.18933547564 | 1901.66666666667 | 1.54612432442957 | 8.26390636962023 | ||
23828 | 23828 | Bolivia | Bolivia | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 12224114 | 8960 | 810 | 4630.61713367583 | 4329.38286632417 | 8150 | 6.62624710469814 | 35.4167415840867 | 0.934947274055338 | monthly | 6 | 2090.66666666667 | 189.0 | 1080.47733119103 | 1010.18933547564 | 1901.66666666667 | 1.54612432442957 | 8.26390636962023 | ||
21613 | 21613 | Bolivia | Bolivia | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 12224114 | 4763 | 251 | 4516.01770479836 | 246.982295201638 | 4512 | 2.05331854725831 | 2.02045150431056 | 0.0546902849692588 | monthly | 5 | 1075.51612903226 | 56.6774193548387 | 1019.74593334157 | 55.7701956906925 | 1018.83870967742 | 0.463652575187361 | 0.456230984844321 | ||
23827 | 23827 | Bolivia | Bolivia | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 12224114 | 4763 | 251 | 4516.01770479836 | 246.982295201638 | 4512 | 2.05331854725831 | 2.02045150431057 | 0.0546902849692583 | monthly | 5 | 1075.51612903226 | 56.6774193548387 | 1019.74593334157 | 55.7701956906925 | 1018.83870967742 | 0.463652575187361 | 0.456230984844321 | ||
21612 | 21612 | Bolivia | Bolivia | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 12224114 | 3393 | 56 | 4236.81713367583 | -843.817133675834 | 3337 | 0.458110910942094 | -6.90288992458541 | -0.199162981798023 | monthly | 4 | 791.7 | 13.0666666666667 | 988.590664524361 | -196.890664524361 | 778.633333333333 | 0.106892545886489 | -1.61067431573659 | ||
23826 | 23826 | Bolivia | Bolivia | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 12224114 | 3393 | 56 | 4236.81713367583 | -843.817133675834 | 3337 | 0.458110910942094 | -6.90288992458541 | -0.199162981798023 | monthly | 4 | 791.7 | 13.0666666666667 | 988.590664524361 | -196.890664524361 | 778.633333333333 | 0.106892545886489 | -1.61067431573659 | ||
21611 | 21611 | Bolivia | Bolivia | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 12224114 | 4715 | 6 | 4431.81770479836 | 283.182295201637 | 4709 | 0.0490833118866529 | 2.31658748602669 | 0.0638975504103061 | monthly | 3 | 1064.67741935484 | 1.35483870967742 | 1000.73303011576 | 63.9443892390794 | 1063.32258064516 | 0.0110833284905345 | 0.523100400070544 | ||
23825 | 23825 | Bolivia | Bolivia | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 12224114 | 4715 | 6 | 4431.81770479836 | 283.182295201637 | 4709 | 0.0490833118866529 | 2.3165874860267 | 0.0638975504103054 | monthly | 3 | 1064.67741935484 | 1.35483870967742 | 1000.73303011576 | 63.9443892390794 | 1063.32258064516 | 0.0110833284905345 | 0.523100400070544 | ||
21610 | 21610 | Bolivia | Bolivia | 0 | 2020-02-01 | 2020-02-29 | 29 | 2020 | 12224114 | 4364 | 0 | 4220.37094498489 | 143.629055015107 | 4364 | 0.0 | 1.17496495054862 | 0.0340323295955265 | monthly | 2 | 1053.37931034483 | 0.0 | 1018.7102280998 | 34.6690822450258 | 1053.37931034483 | 0.0 | 0.283612229442771 | ||
23824 | 23824 | Bolivia | Bolivia | 0 | 2020-02-01 | 2020-02-29 | 29 | 2020 | 12224114 | 4364 | 0 | 4220.37094498489 | 143.629055015107 | 4364 | 0.0 | 1.17496495054862 | 0.0340323295955258 | monthly | 2 | 1053.37931034483 | 0.0 | 1018.7102280998 | 34.6690822450258 | 1053.37931034483 | 0.0 | 0.283612229442771 | ||
21609 | 21609 | Bolivia | Bolivia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 12224114 | 4717 | 0 | 4547.34808733194 | 169.651912668056 | 4717 | 0.0 | 1.38784629027557 | 0.0373078791000578 | monthly | 1 | 1065.12903225806 | 0.0 | 1026.82053584915 | 38.3084964089159 | 1065.12903225806 | 0.0 | 0.313384646191257 | ||
23823 | 23823 | Bolivia | Bolivia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 12224114 | 4717 | 0 | 4547.34808733194 | 169.651912668056 | 4717 | 0.0 | 1.38784629027556 | 0.0373078791000572 | monthly | 1 | 1065.12903225806 | 0.0 | 1026.82053584915 | 38.3084964089159 | 1065.12903225806 | 0.0 | 0.313384646191257 |
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);