economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
24 rows where cadence = "monthly", country = "Kazakhstan" 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, expected_deaths, excess_deaths, non_covid_deaths, excess_deaths_per_100k, excess_deaths_pct_change, month, 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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
391 | 391 | Kazakhstan | Kazakhstan | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 19397998 | 13083 | 272 | 10733.9315526364 | 2349.06844736363 | 12811 | 1.40220655760455 | 12.1098499307177 | 0.218845111490083 | monthly | 12 | 2954.22580645161 | 61.4193548387097 | 2423.7909957566 | 530.434810695013 | 2892.8064516129 | 0.316627287201028 | 2.73448224242014 | ||
22129 | 22129 | Kazakhstan | Kazakhstan | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 19397998 | 13083 | 272 | 10733.9315526364 | 2349.06844736363 | 12811 | 1.40220655760455 | 12.1098499307177 | 0.21884511149008 | monthly | 12 | 2954.22580645161 | 61.4193548387097 | 2423.7909957566 | 530.434810695013 | 2892.8064516129 | 0.316627287201028 | 2.73448224242014 | ||
390 | 390 | Kazakhstan | Kazakhstan | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 19397998 | 12388 | 258 | 10708.4498896481 | 1679.5501103519 | 12130 | 1.33003416125726 | 8.65836830353267 | 0.156843439308198 | monthly | 11 | 2890.53333333333 | 60.2 | 2498.63830758456 | 391.895025748777 | 2830.33333333333 | 0.310341304293361 | 2.02028593749096 | ||
22128 | 22128 | Kazakhstan | Kazakhstan | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 19397998 | 12388 | 258 | 10708.4498896481 | 1679.5501103519 | 12130 | 1.33003416125726 | 8.65836830353266 | 0.156843439308198 | monthly | 11 | 2890.53333333333 | 60.2 | 2498.63830758456 | 391.895025748777 | 2830.33333333333 | 0.310341304293361 | 2.02028593749096 | ||
389 | 389 | Kazakhstan | Kazakhstan | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 19397998 | 12489 | 144 | 11097.1315526364 | 1391.86844736363 | 12345 | 0.742344648143587 | 7.17532008902997 | 0.125425966229351 | monthly | 10 | 2820.09677419355 | 32.5161290322581 | 2505.80389898241 | 314.292875211143 | 2787.58064516129 | 0.167626210871132 | 1.62023356849064 | ||
22127 | 22127 | Kazakhstan | Kazakhstan | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 19397998 | 12489 | 144 | 11097.1315526364 | 1391.86844736363 | 12345 | 0.742344648143587 | 7.17532008902996 | 0.125425966229348 | monthly | 10 | 2820.09677419355 | 32.5161290322581 | 2505.80389898241 | 314.292875211143 | 2787.58064516129 | 0.167626210871132 | 1.62023356849064 | ||
388 | 388 | Kazakhstan | Kazakhstan | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 19397998 | 13672 | 197 | 10594.8498896481 | 3077.1501103519 | 13475 | 1.01556872002977 | 15.8632355274596 | 0.290438292415873 | monthly | 9 | 3190.13333333333 | 45.9666666666667 | 2472.13164091789 | 718.001692415443 | 3144.16666666667 | 0.236966034673613 | 3.7014216230739 | ||
22126 | 22126 | Kazakhstan | Kazakhstan | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 19397998 | 13672 | 197 | 10594.8498896481 | 3077.1501103519 | 13475 | 1.01556872002977 | 15.8632355274596 | 0.290438292415873 | monthly | 9 | 3190.13333333333 | 45.9666666666667 | 2472.13164091789 | 718.001692415443 | 3144.16666666667 | 0.236966034673613 | 3.7014216230739 | ||
387 | 387 | Kazakhstan | Kazakhstan | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 19397998 | 17835 | 1085 | 10557.3315526364 | 7277.66844736363 | 16750 | 5.59336071691522 | 37.5176265476656 | 0.689347342278576 | monthly | 8 | 4027.25806451613 | 245.0 | 2383.91357640176 | 1643.34448811437 | 3782.25806451613 | 1.26301693607763 | 8.47172212366642 | ||
22125 | 22125 | Kazakhstan | Kazakhstan | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 19397998 | 17835 | 1085 | 10557.3315526364 | 7277.66844736363 | 16750 | 5.59336071691522 | 37.5176265476655 | 0.689347342278571 | monthly | 8 | 4027.25806451613 | 245.0 | 2383.91357640176 | 1643.34448811437 | 3782.25806451613 | 1.26301693607763 | 8.47172212366642 | ||
386 | 386 | Kazakhstan | Kazakhstan | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 19397998 | 28178 | 605 | 11627.7315526364 | 16550.2684473636 | 27573 | 3.1188785564366 | 85.3194667169449 | 1.42334455972293 | monthly | 7 | 6362.77419354839 | 136.612903225806 | 2625.61680220821 | 3737.15739134018 | 6226.16129032258 | 0.704262899840522 | 19.2656860328585 | ||
22124 | 22124 | Kazakhstan | Kazakhstan | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 19397998 | 28178 | 605 | 11627.7315526364 | 16550.2684473636 | 27573 | 3.1188785564366 | 85.3194667169447 | 1.42334455972292 | monthly | 7 | 6362.77419354839 | 136.612903225806 | 2625.61680220821 | 3737.15739134018 | 6226.16129032258 | 0.704262899840522 | 19.2656860328585 | ||
385 | 385 | Kazakhstan | Kazakhstan | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 19397998 | 14949 | 147 | 10847.8498896481 | 4101.1501103519 | 14802 | 0.757810161646578 | 21.1421308031473 | 0.378061104465093 | monthly | 6 | 3488.1 | 34.3 | 2531.16497425122 | 956.935025748777 | 3453.8 | 0.176822371050868 | 4.93316385406771 | ||
22123 | 22123 | Kazakhstan | Kazakhstan | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 19397998 | 14949 | 147 | 10847.8498896481 | 4101.1501103519 | 14802 | 0.757810161646578 | 21.1421308031473 | 0.378061104465093 | monthly | 6 | 3488.1 | 34.3 | 2531.16497425122 | 956.935025748777 | 3453.8 | 0.176822371050868 | 4.93316385406771 | ||
384 | 384 | Kazakhstan | Kazakhstan | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 19397998 | 14358 | 16 | 11175.5315526364 | 3182.46844736363 | 14342 | 0.0824827386826208 | 16.4061695818488 | 0.284771103045463 | monthly | 5 | 3242.12903225806 | 3.61290322580645 | 2523.50712478886 | 718.621907469207 | 3238.51612903226 | 0.0186251345412369 | 3.70461893783682 | ||
22122 | 22122 | Kazakhstan | Kazakhstan | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 19397998 | 14358 | 16 | 11175.5315526364 | 3182.46844736363 | 14342 | 0.0824827386826208 | 16.4061695818488 | 0.284771103045459 | monthly | 5 | 3242.12903225806 | 3.61290322580645 | 2523.50712478886 | 718.621907469207 | 3238.51612903226 | 0.0186251345412369 | 3.70461893783682 | ||
383 | 383 | Kazakhstan | Kazakhstan | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 19397998 | 4441 | 23 | 11106.2498896481 | -6665.2498896481 | 4418 | 0.118568936856267 | -34.3605040563882 | -0.600135055115286 | monthly | 4 | 1036.23333333333 | 5.36666666666667 | 2591.45830758456 | -1555.22497425122 | 1030.86666666667 | 0.0276660852664624 | -8.01745094649057 | ||
22121 | 22121 | Kazakhstan | Kazakhstan | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 19397998 | 4441 | 23 | 11106.2498896481 | -6665.2498896481 | 4418 | 0.118568936856267 | -34.3605040563882 | -0.600135055115286 | monthly | 4 | 1036.23333333333 | 5.36666666666667 | 2591.45830758456 | -1555.22497425122 | 1030.86666666667 | 0.0276660852664624 | -8.01745094649057 | ||
382 | 382 | Kazakhstan | Kazakhstan | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 19397998 | 8511 | 2 | 11040.3315526364 | -2529.33155263637 | 8509 | 0.0103103423353276 | -13.0391370936133 | -0.229099238603245 | monthly | 3 | 1921.83870967742 | 0.451612903225806 | 2492.97809253079 | -571.139382853374 | 1921.38709677419 | 0.00232814181765462 | -2.94432127920301 | ||
22120 | 22120 | Kazakhstan | Kazakhstan | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 19397998 | 8511 | 2 | 11040.3315526364 | -2529.33155263637 | 8509 | 0.0103103423353276 | -13.0391370936133 | -0.229099238603247 | monthly | 3 | 1921.83870967742 | 0.451612903225806 | 2492.97809253079 | -571.139382853374 | 1921.38709677419 | 0.00232814181765462 | -2.94432127920301 | ||
381 | 381 | Kazakhstan | Kazakhstan | 0 | 2020-02-01 | 2020-02-29 | 29 | 2020 | 19397998 | 10842 | 0 | 10842.8187603118 | -0.818760311762162 | 10842 | 0.0 | -0.00422084955242372 | -7.5511758506841e-05 | monthly | 2 | 2617.03448275862 | 0.0 | 2617.23211455801 | -0.197631799390867 | 2617.03448275862 | 0.0 | -0.00101882575403331 | ||
22119 | 22119 | Kazakhstan | Kazakhstan | 0 | 2020-02-01 | 2020-02-29 | 29 | 2020 | 19397998 | 10842 | 0 | 10842.8187603118 | -0.818760311762162 | 10842 | 0.0 | -0.00422084955242372 | -7.55117585103937e-05 | monthly | 2 | 2617.03448275862 | 0.0 | 2617.23211455801 | -0.197631799390867 | 2617.03448275862 | 0.0 | -0.00101882575403331 | ||
380 | 380 | Kazakhstan | Kazakhstan | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 19397998 | 11867 | 0 | 12193.7762938636 | -326.776293863633 | 11867 | 0.0 | -1.68458772840183 | -0.0267986131603939 | monthly | 1 | 2679.64516129032 | 0.0 | 2753.43335667889 | -73.7881953885624 | 2679.64516129032 | 0.0 | -0.380390777381059 | ||
22118 | 22118 | Kazakhstan | Kazakhstan | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 19397998 | 11867 | 0 | 12193.7762938636 | -326.776293863633 | 11867 | 0.0 | -1.68458772840183 | -0.0267986131603913 | monthly | 1 | 2679.64516129032 | 0.0 | 2753.43335667889 | -73.7881953885624 | 2679.64516129032 | 0.0 | -0.380390777381059 |
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);