economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
24 rows where cadence = "monthly", country = "Mongolia" and year = 2021 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, covid_deaths_per_100k, 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22494 | 22494 | Mongolia | Mongolia | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 3398373 | 1785 | 56 | 1571.5075180928 | 213.492481907204 | 1729 | 1.6478473669606 | 6.28219686029768 | 0.135852027081803 | monthly | 12 | 403.064516129032 | 12.6451612903226 | 354.856536343535 | 48.2079797854977 | 390.41935483871 | 0.372094566733039 | 1.41856058135754 | ||
23871 | 23871 | Mongolia | Mongolia | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 3398373 | 1785 | 56 | 1571.5075180928 | 213.492481907204 | 1729 | 1.6478473669606 | 6.28219686029768 | 0.135852027081806 | monthly | 12 | 403.064516129032 | 12.6451612903226 | 354.856536343535 | 48.2079797854977 | 390.41935483871 | 0.372094566733039 | 1.41856058135754 | ||
22493 | 22493 | Mongolia | Mongolia | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 3398373 | 1950 | 269 | 1388.17501750916 | 561.824982490843 | 1681 | 7.9155525305786 | 16.5321753230397 | 0.404722009404072 | monthly | 11 | 455.0 | 62.7666666666667 | 323.90750408547 | 131.09249591453 | 392.233333333333 | 1.84696225713501 | 3.85750757537592 | ||
23870 | 23870 | Mongolia | Mongolia | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 3398373 | 1950 | 269 | 1388.17501750916 | 561.824982490843 | 1681 | 7.9155525305786 | 16.5321753230397 | 0.404722009404074 | monthly | 11 | 455.0 | 62.7666666666667 | 323.90750408547 | 131.09249591453 | 392.233333333333 | 1.84696225713501 | 3.85750757537592 | ||
22492 | 22492 | Mongolia | Mongolia | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 3398373 | 2302 | 457 | 1475.3075180928 | 826.692481907204 | 1845 | 13.4476115482321 | 24.3261255285163 | 0.560352653103744 | monthly | 10 | 519.806451612903 | 103.193548387097 | 333.133955698373 | 186.67249591453 | 416.612903225806 | 3.03655744637498 | 5.49299608708432 | ||
23869 | 23869 | Mongolia | Mongolia | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 3398373 | 2302 | 457 | 1475.3075180928 | 826.692481907204 | 1845 | 13.4476115482321 | 24.3261255285163 | 0.560352653103748 | monthly | 10 | 519.806451612903 | 103.193548387097 | 333.133955698373 | 186.67249591453 | 416.612903225806 | 3.03655744637498 | 5.49299608708432 | ||
22491 | 22491 | Mongolia | Mongolia | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 3398373 | 2026 | 368 | 1464.57501750916 | 561.424982490842 | 1658 | 10.8287112685982 | 16.5204049847042 | 0.383336446258431 | monthly | 9 | 472.733333333333 | 85.8666666666667 | 341.734170752137 | 130.999162581197 | 386.866666666667 | 2.52669929600626 | 3.85476116309765 | ||
23868 | 23868 | Mongolia | Mongolia | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 3398373 | 2026 | 368 | 1464.57501750916 | 561.424982490842 | 1658 | 10.8287112685982 | 16.5204049847042 | 0.383336446258433 | monthly | 9 | 472.733333333333 | 85.8666666666667 | 341.734170752137 | 130.999162581197 | 386.866666666667 | 2.52669929600626 | 3.85476116309765 | ||
22490 | 22490 | Mongolia | Mongolia | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 3398373 | 1678 | 123 | 1445.1075180928 | 232.892481907204 | 1555 | 3.61937903814561 | 6.85305826956617 | 0.161159276380046 | monthly | 8 | 378.903225806452 | 27.7741935483871 | 326.314600859664 | 52.588624946788 | 351.129032258065 | 0.817279137645782 | 1.5474647705472 | ||
23867 | 23867 | Mongolia | Mongolia | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 3398373 | 1678 | 123 | 1445.1075180928 | 232.892481907204 | 1555 | 3.61937903814561 | 6.85305826956617 | 0.161159276380049 | monthly | 8 | 378.903225806452 | 27.7741935483871 | 326.314600859664 | 52.588624946788 | 351.129032258065 | 0.817279137645782 | 1.5474647705472 | ||
22489 | 22489 | Mongolia | Mongolia | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 3398373 | 1819 | 217 | 1454.7075180928 | 364.292481907204 | 1602 | 6.38540854697233 | 10.7196144127559 | 0.250423179488896 | monthly | 7 | 410.741935483871 | 49.0 | 328.482342795147 | 82.2595926887235 | 361.741935483871 | 1.44186644609053 | 2.42055809320294 | ||
23866 | 23866 | Mongolia | Mongolia | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 3398373 | 1819 | 217 | 1454.7075180928 | 364.292481907204 | 1602 | 6.38540854697233 | 10.7196144127559 | 0.2504231794889 | monthly | 7 | 410.741935483871 | 49.0 | 328.482342795147 | 82.2595926887235 | 361.741935483871 | 1.44186644609053 | 2.42055809320294 | ||
22488 | 22488 | Mongolia | Mongolia | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 3398373 | 1715 | 243 | 1404.37501750916 | 310.624982490843 | 1472 | 7.15048053877547 | 9.14040284838783 | 0.221183785397844 | monthly | 6 | 400.166666666667 | 56.7 | 327.68750408547 | 72.4791625811966 | 343.466666666667 | 1.66844545904761 | 2.13276066462382 | ||
23865 | 23865 | Mongolia | Mongolia | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 3398373 | 1715 | 243 | 1404.37501750916 | 310.624982490843 | 1472 | 7.15048053877547 | 9.14040284838782 | 0.221183785397847 | monthly | 6 | 400.166666666667 | 56.7 | 327.68750408547 | 72.4791625811966 | 343.466666666667 | 1.66844545904761 | 2.13276066462382 | ||
22487 | 22487 | Mongolia | Mongolia | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 3398373 | 1403 | 135 | 1499.1075180928 | -96.1075180927958 | 1268 | 3.97248918820859 | -2.82804501132736 | -0.0641098233001128 | monthly | 5 | 316.806451612903 | 30.4838709677419 | 338.50814924676 | -21.7016976338571 | 286.322580645161 | 0.897013687660005 | -0.638590809009403 | ||
23864 | 23864 | Mongolia | Mongolia | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 3398373 | 1403 | 135 | 1499.1075180928 | -96.1075180927958 | 1268 | 3.97248918820859 | -2.82804501132735 | -0.0641098233001102 | monthly | 5 | 316.806451612903 | 30.4838709677419 | 338.50814924676 | -21.7016976338571 | 286.322580645161 | 0.897013687660005 | -0.638590809009403 | ||
22486 | 22486 | Mongolia | Mongolia | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 3398373 | 1484 | 110 | 1420.97501750916 | 63.0249824908426 | 1374 | 3.23684304224404 | 1.85456341875487 | 0.0443533360644983 | monthly | 4 | 346.266666666667 | 25.6666666666667 | 331.560837418803 | 14.7058292478633 | 320.6 | 0.755263376523609 | 0.432731464376137 | ||
23863 | 23863 | Mongolia | Mongolia | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 3398373 | 1484 | 110 | 1420.97501750916 | 63.0249824908426 | 1374 | 3.23684304224404 | 1.85456341875487 | 0.0443533360645001 | monthly | 4 | 346.266666666667 | 25.6666666666667 | 331.560837418803 | 14.7058292478633 | 320.6 | 0.755263376523609 | 0.432731464376137 | ||
22485 | 22485 | Mongolia | Mongolia | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 3398373 | 1381 | 6 | 1516.3075180928 | -135.307518092796 | 1375 | 0.176555075031493 | -3.98153816819978 | -0.089234879124644 | monthly | 3 | 311.838709677419 | 1.35483870967742 | 342.392020214502 | -30.5533105370829 | 310.483870967742 | 0.0398672750071113 | -0.89905700572253 | ||
23862 | 23862 | Mongolia | Mongolia | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 3398373 | 1381 | 6 | 1516.3075180928 | -135.307518092796 | 1375 | 0.176555075031493 | -3.98153816819978 | -0.0892348791246416 | monthly | 3 | 311.838709677419 | 1.35483870967742 | 342.392020214502 | -30.5533105370829 | 310.483870967742 | 0.0398672750071113 | -0.89905700572253 | ||
22484 | 22484 | Mongolia | Mongolia | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 3398373 | 1237 | 0 | 1347.03477004627 | -110.03477004627 | 1237 | 0.0 | -3.23786618026538 | -0.0816866590923191 | monthly | 2 | 309.25 | 0.0 | 336.758692511568 | -27.5086925115676 | 309.25 | 0.0 | -0.809466545066347 | ||
23861 | 23861 | Mongolia | Mongolia | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 3398373 | 1237 | 0 | 1347.03477004627 | -110.03477004627 | 1237 | 0.0 | -3.23786618026539 | -0.0816866590923192 | monthly | 2 | 309.25 | 0.0 | 336.758692511568 | -27.5086925115676 | 309.25 | 0.0 | -0.809466545066347 | ||
22483 | 22483 | Mongolia | Mongolia | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 3398373 | 1151 | 1 | 1475.19407833119 | -324.19407833119 | 1150 | 0.0294258458385822 | -9.53968497075483 | -0.219763679296987 | monthly | 1 | 259.903225806452 | 0.225806451612903 | 333.108340268333 | -73.2051144618816 | 259.677419354839 | 0.00664454583451855 | -2.15412241275109 | ||
23860 | 23860 | Mongolia | Mongolia | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 3398373 | 1151 | 1 | 1475.19407833119 | -324.19407833119 | 1150 | 0.0294258458385822 | -9.53968497075483 | -0.219763679296987 | monthly | 1 | 259.903225806452 | 0.225806451612903 | 333.108340268333 | -73.2051144618816 | 259.677419354839 | 0.00664454583451855 | -2.15412241275109 |
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);