economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
24 rows where country = "Mongolia" and days = 30 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, year, total_deaths, covid_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, month, total_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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22505 | 22505 | Mongolia | Mongolia | 0 | 2022-11-01 | 2022-11-30 | 30 | 2022 | 3398373 | 1472 | 3 | 1407.16877188645 | 64.8312281135472 | 1469 | 0.0882775375157465 | 1.90771372399519 | 0.0460721054992126 | monthly | 11 | 343.466666666667 | 0.7 | 328.339380106839 | 15.1272865598277 | 342.766666666667 | 0.0205980920870075 | 0.445133202265546 | ||
23882 | 23882 | Mongolia | Mongolia | 0 | 2022-11-01 | 2022-11-30 | 30 | 2022 | 3398373 | 1472 | 3 | 1407.16877188645 | 64.8312281135472 | 1469 | 0.0882775375157465 | 1.9077137239952 | 0.0460721054992106 | monthly | 11 | 343.466666666667 | 0.7 | 328.339380106839 | 15.1272865598277 | 342.766666666667 | 0.0205980920870075 | 0.445133202265546 | ||
22503 | 22503 | Mongolia | Mongolia | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 3398373 | 1490 | 3 | 1483.56877188645 | 6.43122811354715 | 1487 | 0.0882775375157465 | 0.189244327021994 | 0.00433497134438365 | monthly | 9 | 347.666666666667 | 0.7 | 346.166046773506 | 1.500619893161 | 346.966666666667 | 0.0205980920870075 | 0.0441570096384653 | ||
23880 | 23880 | Mongolia | Mongolia | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 3398373 | 1490 | 3 | 1483.56877188645 | 6.43122811354715 | 1487 | 0.0882775375157465 | 0.189244327021994 | 0.00433497134438166 | monthly | 9 | 347.666666666667 | 0.7 | 346.166046773506 | 1.500619893161 | 346.966666666667 | 0.0205980920870075 | 0.0441570096384653 | ||
22500 | 22500 | Mongolia | Mongolia | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 3398373 | 1424 | 3 | 1423.36877188645 | 0.631228113547195 | 1421 | 0.0882775375157465 | 0.0185744211582188 | 0.000443474752304329 | monthly | 6 | 332.266666666667 | 0.7 | 332.119380106839 | 0.147286559827679 | 331.566666666667 | 0.0205980920870075 | 0.00433403160358439 | ||
23877 | 23877 | Mongolia | Mongolia | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 3398373 | 1424 | 3 | 1423.36877188645 | 0.631228113547195 | 1421 | 0.0882775375157465 | 0.0185744211582188 | 0.000443474752302331 | monthly | 6 | 332.266666666667 | 0.7 | 332.119380106839 | 0.147286559827679 | 331.566666666667 | 0.0205980920870075 | 0.00433403160358439 | ||
22498 | 22498 | Mongolia | Mongolia | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 3398373 | 1558 | 2 | 1439.96877188645 | 118.031228113547 | 1556 | 0.0588516916771643 | 3.47316872260776 | 0.0819679082060381 | monthly | 4 | 363.533333333333 | 0.466666666666667 | 335.992713440172 | 27.540619893161 | 363.066666666667 | 0.0137320613913383 | 0.810406035275146 | ||
23875 | 23875 | Mongolia | Mongolia | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 3398373 | 1558 | 2 | 1439.96877188645 | 118.031228113547 | 1556 | 0.0588516916771643 | 3.47316872260777 | 0.0819679082060361 | monthly | 4 | 363.533333333333 | 0.466666666666667 | 335.992713440172 | 27.540619893161 | 363.066666666667 | 0.0137320613913383 | 0.810406035275146 | ||
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 | ||
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 | ||
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 | ||
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 | ||
22481 | 22481 | Mongolia | Mongolia | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 3398373 | 1278 | 0 | 1369.18126313187 | -91.1812631318689 | 1278 | 0.0 | -2.68308579228557 | -0.0665954651784394 | monthly | 11 | 298.2 | 0.0 | 319.475628064103 | -21.2756280641028 | 298.2 | 0.0 | -0.6260533515333 | ||
23858 | 23858 | Mongolia | Mongolia | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 3398373 | 1278 | 0 | 1369.18126313187 | -91.1812631318689 | 1278 | 0.0 | -2.68308579228557 | -0.0665954651784386 | monthly | 11 | 298.2 | 0.0 | 319.475628064103 | -21.2756280641028 | 298.2 | 0.0 | -0.6260533515333 | ||
22479 | 22479 | Mongolia | Mongolia | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 3398373 | 1405 | 0 | 1445.58126313187 | -40.581263131869 | 1405 | 0.0 | -1.19413799285332 | -0.0280726266774862 | monthly | 9 | 327.833333333333 | 0.0 | 337.302294730769 | -9.46896139743611 | 327.833333333333 | 0.0 | -0.278632198332441 | ||
23856 | 23856 | Mongolia | Mongolia | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 3398373 | 1405 | 0 | 1445.58126313187 | -40.581263131869 | 1405 | 0.0 | -1.19413799285332 | -0.0280726266774856 | monthly | 9 | 327.833333333333 | 0.0 | 337.302294730769 | -9.46896139743611 | 327.833333333333 | 0.0 | -0.278632198332441 | ||
22476 | 22476 | Mongolia | Mongolia | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 3398373 | 1306 | 0 | 1385.38126313187 | -79.381263131869 | 1306 | 0.0 | -2.3358608113903 | -0.0572992180884677 | monthly | 6 | 304.733333333333 | 0.0 | 323.255628064103 | -18.5222947307694 | 304.733333333333 | 0.0 | -0.545034189324404 | ||
23853 | 23853 | Mongolia | Mongolia | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 3398373 | 1306 | 0 | 1385.38126313187 | -79.381263131869 | 1306 | 0.0 | -2.3358608113903 | -0.0572992180884671 | monthly | 6 | 304.733333333333 | 0.0 | 323.255628064103 | -18.5222947307694 | 304.733333333333 | 0.0 | -0.545034189324404 | ||
22474 | 22474 | Mongolia | Mongolia | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 3398373 | 1310 | 0 | 1401.98126313187 | -91.9812631318689 | 1310 | 0.0 | -2.70662646895644 | -0.0656080545087986 | monthly | 4 | 305.666666666667 | 0.0 | 327.128961397436 | -21.4622947307694 | 305.666666666667 | 0.0 | -0.631546176089835 | ||
23851 | 23851 | Mongolia | Mongolia | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 3398373 | 1310 | 0 | 1401.98126313187 | -91.9812631318689 | 1310 | 0.0 | -2.70662646895644 | -0.0656080545087978 | monthly | 4 | 305.666666666667 | 0.0 | 327.128961397436 | -21.4622947307694 | 305.666666666667 | 0.0 | -0.631546176089835 |
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);