economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
24 rows where cadence = "monthly", country = "Kosovo" 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, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_per_100k, month, total_deaths_per_7_days, covid_deaths_per_7_days, excess_deaths_per_7_days, non_covid_deaths_per_7_days, excess_deaths_per_100k_per_7_days, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17948 | 17948 | Kosovo | Kosovo | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 1782115 | 1024 | 6 | 904.297326521928 | 119.702673478072 | 1018 | 0.336678609405117 | 6.71688827477867 | 0.132370924879837 | monthly | 12 | 231.225806451613 | 1.35483870967742 | 204.196170504951 | 27.0296359466614 | 229.870967741935 | 0.0760242021237361 | 1.51671670720809 | ||
22174 | 22174 | Kosovo | Kosovo | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 1782115 | 1024 | 6 | 904.297326521928 | 119.702673478072 | 1018 | 0.336678609405117 | 6.71688827477868 | 0.132370924879837 | monthly | 12 | 231.225806451613 | 1.35483870967742 | 204.196170504951 | 27.0296359466614 | 229.870967741935 | 0.0760242021237361 | 1.51671670720809 | ||
17947 | 17947 | Kosovo | Kosovo | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 1782115 | 802 | 7 | 816.061928892188 | -14.0619288921885 | 795 | 0.392791710972636 | -0.789058444162608 | -0.0172314482447156 | monthly | 11 | 187.133333333333 | 1.63333333333333 | 190.414450074844 | -3.28111674151064 | 185.5 | 0.0916513992269485 | -0.184113636971275 | ||
22173 | 22173 | Kosovo | Kosovo | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 1782115 | 802 | 7 | 816.061928892188 | -14.0619288921885 | 795 | 0.392791710972636 | -0.78905844416261 | -0.017231448244715 | monthly | 11 | 187.133333333333 | 1.63333333333333 | 190.414450074844 | -3.28111674151064 | 185.5 | 0.0916513992269485 | -0.184113636971275 | ||
17946 | 17946 | Kosovo | Kosovo | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 1782115 | 893 | 24 | 837.897326521928 | 55.102673478072 | 869 | 1.34671443762047 | 3.09198191351692 | 0.065763037706303 | monthly | 10 | 201.645161290323 | 5.41935483870968 | 189.202622117855 | 12.4425391724679 | 196.225806451613 | 0.304096808494944 | 0.69818946434253 | ||
22172 | 22172 | Kosovo | Kosovo | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 1782115 | 893 | 24 | 837.897326521928 | 55.102673478072 | 869 | 1.34671443762047 | 3.09198191351692 | 0.065763037706303 | monthly | 10 | 201.645161290323 | 5.41935483870968 | 189.202622117855 | 12.4425391724679 | 196.225806451613 | 0.304096808494944 | 0.69818946434253 | ||
17945 | 17945 | Kosovo | Kosovo | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 1782115 | 1535 | 450 | 779.461928892188 | 755.538071107812 | 1085 | 25.2508957053838 | 42.3955845222004 | 0.969307214505809 | monthly | 9 | 358.166666666667 | 105.0 | 181.874450074844 | 176.292216591823 | 253.166666666667 | 5.89187566458955 | 9.89230305518009 | ||
22171 | 22171 | Kosovo | Kosovo | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 1782115 | 1535 | 450 | 779.461928892188 | 755.538071107812 | 1085 | 25.2508957053838 | 42.3955845222004 | 0.969307214505809 | monthly | 9 | 358.166666666667 | 105.0 | 181.874450074844 | 176.292216591823 | 253.166666666667 | 5.89187566458955 | 9.89230305518009 | ||
17944 | 17944 | Kosovo | Kosovo | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 1782115 | 1284 | 234 | 813.097326521928 | 470.902673478072 | 1050 | 13.1304657667996 | 26.4238095452915 | 0.579146749248809 | monthly | 8 | 289.935483870968 | 52.8387096774194 | 183.602622117855 | 106.332861753113 | 237.096774193548 | 2.96494388282571 | 5.96666667151744 | ||
22170 | 22170 | Kosovo | Kosovo | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 1782115 | 1284 | 234 | 813.097326521928 | 470.902673478072 | 1050 | 13.1304657667996 | 26.4238095452915 | 0.579146749248809 | monthly | 8 | 289.935483870968 | 52.8387096774194 | 183.602622117855 | 106.332861753113 | 237.096774193548 | 2.96494388282571 | 5.96666667151744 | ||
17943 | 17943 | Kosovo | Kosovo | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 1782115 | 777 | 7 | 774.697326521928 | 2.30267347807205 | 770 | 0.392791710972636 | 0.12921015075189 | 0.00297235242621796 | monthly | 7 | 175.451612903226 | 1.58064516129032 | 174.931654375919 | 0.519958527306592 | 173.870967741935 | 0.0886949024776921 | 0.0291764856536527 | ||
22169 | 22169 | Kosovo | Kosovo | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 1782115 | 777 | 7 | 774.697326521928 | 2.30267347807205 | 770 | 0.392791710972636 | 0.12921015075189 | 0.00297235242621796 | monthly | 7 | 175.451612903226 | 1.58064516129032 | 174.931654375919 | 0.519958527306592 | 173.870967741935 | 0.0886949024776921 | 0.0291764856536527 | ||
17942 | 17942 | Kosovo | Kosovo | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 1782115 | 814 | 14 | 770.861928892188 | 43.1380711078116 | 800 | 0.785583421945273 | 2.42061096549951 | 0.0559608270832699 | monthly | 6 | 189.933333333333 | 3.26666666666667 | 179.867783408177 | 10.065549925156 | 186.666666666667 | 0.183302798453897 | 0.564809225283219 | ||
22168 | 22168 | Kosovo | Kosovo | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 1782115 | 814 | 14 | 770.861928892188 | 43.1380711078116 | 800 | 0.785583421945273 | 2.42061096549951 | 0.0559608270832703 | monthly | 6 | 189.933333333333 | 3.26666666666667 | 179.867783408177 | 10.065549925156 | 186.666666666667 | 0.183302798453897 | 0.564809225283219 | ||
17941 | 17941 | Kosovo | Kosovo | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 1782115 | 943 | 114 | 818.097326521928 | 124.902673478072 | 829 | 6.39689357869722 | 7.00867640292978 | 0.152674589475907 | monthly | 5 | 212.935483870968 | 25.741935483871 | 184.731654375919 | 28.2038294950485 | 187.193548387097 | 1.44445984035099 | 1.58260434904866 | ||
22167 | 22167 | Kosovo | Kosovo | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 1782115 | 943 | 114 | 818.097326521928 | 124.902673478072 | 829 | 6.39689357869722 | 7.00867640292978 | 0.152674589475907 | monthly | 5 | 212.935483870968 | 25.741935483871 | 184.731654375919 | 28.2038294950485 | 187.193548387097 | 1.44445984035099 | 1.58260434904866 | ||
17940 | 17940 | Kosovo | Kosovo | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 1782115 | 1338 | 268 | 814.661928892188 | 523.338071107812 | 1070 | 15.0383112200952 | 29.3661223382224 | 0.642399076902328 | monthly | 4 | 312.2 | 62.5333333333333 | 190.087783408177 | 122.112216591823 | 249.666666666667 | 3.50893928468889 | 6.85209521225189 | ||
22166 | 22166 | Kosovo | Kosovo | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 1782115 | 1338 | 268 | 814.661928892188 | 523.338071107812 | 1070 | 15.0383112200952 | 29.3661223382224 | 0.642399076902328 | monthly | 4 | 312.2 | 62.5333333333333 | 190.087783408177 | 122.112216591823 | 249.666666666667 | 3.50893928468889 | 6.85209521225189 | ||
17939 | 17939 | Kosovo | Kosovo | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 1782115 | 1350 | 274 | 874.297326521928 | 475.702673478072 | 1076 | 15.3749898295003 | 26.6931524328156 | 0.544097138407687 | monthly | 3 | 304.838709677419 | 61.8709677419355 | 197.421976956564 | 107.416732720855 | 242.967741935484 | 3.47177189698395 | 6.02748603321643 | ||
22165 | 22165 | Kosovo | Kosovo | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 1782115 | 1350 | 274 | 874.297326521928 | 475.702673478072 | 1076 | 15.3749898295003 | 26.6931524328156 | 0.544097138407687 | monthly | 3 | 304.838709677419 | 61.8709677419355 | 197.421976956564 | 107.416732720855 | 242.967741935484 | 3.47177189698395 | 6.02748603321643 | ||
17938 | 17938 | Kosovo | Kosovo | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 1782115 | 1007 | 94 | 821.640805147012 | 185.359194852988 | 913 | 5.27463154734683 | 10.4010793272594 | 0.225596384322494 | monthly | 2 | 251.75 | 23.5 | 205.410201286753 | 46.3397987132471 | 228.25 | 1.31865788683671 | 2.60026983181484 | ||
22164 | 22164 | Kosovo | Kosovo | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 1782115 | 1007 | 94 | 821.640805147012 | 185.359194852988 | 913 | 5.27463154734683 | 10.4010793272594 | 0.225596384322493 | monthly | 2 | 251.75 | 23.5 | 205.410201286753 | 46.3397987132471 | 228.25 | 1.31865788683671 | 2.60026983181484 | ||
17937 | 17937 | Kosovo | Kosovo | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 1782115 | 1252 | 166 | 918.593494040014 | 333.406505959986 | 1086 | 9.31477486020824 | 18.7084731322045 | 0.362953262921174 | monthly | 1 | 282.709677419355 | 37.4838709677419 | 207.424337363874 | 75.2853400554806 | 245.225806451613 | 2.1033362587567 | 4.22449393307843 | ||
22163 | 22163 | Kosovo | Kosovo | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 1782115 | 1252 | 166 | 918.593494040014 | 333.406505959986 | 1086 | 9.31477486020824 | 18.7084731322045 | 0.362953262921175 | monthly | 1 | 282.709677419355 | 37.4838709677419 | 207.424337363874 | 75.2853400554806 | 245.225806451613 | 2.1033362587567 | 4.22449393307843 |
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);