economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
26 rows where cadence = "monthly", country = "Mongolia" and covid_deaths_per_100k_per_7_days = "0.0" sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, days, year, total_deaths, expected_deaths, excess_deaths, non_covid_deaths, excess_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, start_date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22504 | 22504 | Mongolia | Mongolia | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 3398373 | 1485 | 0 | 1494.934397616 | -9.93439761600098 | 1485 | 0.0 | -0.292328052747623 | -0.00664537362431594 | monthly | 10 | 335.322580645161 | 0.0 | 337.565831719742 | -2.24325107458087 | 335.322580645161 | 0.0 | -0.0660095602978504 | ||
23881 | 23881 | Mongolia | Mongolia | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 3398373 | 1485 | 0 | 1494.934397616 | -9.93439761600098 | 1485 | 0.0 | -0.292328052747623 | -0.00664537362431661 | monthly | 10 | 335.322580645161 | 0.0 | 337.565831719742 | -2.24325107458087 | 335.322580645161 | 0.0 | -0.0660095602978504 | ||
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 | ||
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 | ||
22480 | 22480 | Mongolia | Mongolia | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 3398373 | 1427 | 0 | 1455.6806385696 | -28.6806385695977 | 1427 | 0.0 | -0.843952049101076 | -0.0197025623682009 | monthly | 10 | 322.225806451613 | 0.0 | 328.702079677006 | -6.47627322539303 | 322.225806451613 | 0.0 | -0.190569817538953 | ||
23857 | 23857 | Mongolia | Mongolia | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 3398373 | 1427 | 0 | 1455.6806385696 | -28.6806385695977 | 1427 | 0.0 | -0.843952049101076 | -0.0197025623681993 | monthly | 10 | 322.225806451613 | 0.0 | 328.702079677006 | -6.47627322539303 | 322.225806451613 | 0.0 | -0.190569817538953 | ||
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 | ||
22478 | 22478 | Mongolia | Mongolia | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 3398373 | 1331 | 0 | 1425.4806385696 | -94.4806385695979 | 1331 | 0.0 | -2.78017270527979 | -0.0662798469605358 | monthly | 8 | 300.548387096774 | 0.0 | 321.882724838296 | -21.3343377415221 | 300.548387096774 | 0.0 | -0.627780933450275 | ||
23855 | 23855 | Mongolia | Mongolia | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 3398373 | 1331 | 0 | 1425.4806385696 | -94.4806385695979 | 1331 | 0.0 | -2.78017270527979 | -0.0662798469605345 | monthly | 8 | 300.548387096774 | 0.0 | 321.882724838296 | -21.3343377415221 | 300.548387096774 | 0.0 | -0.627780933450275 | ||
22477 | 22477 | Mongolia | Mongolia | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 3398373 | 1402 | 0 | 1435.0806385696 | -33.0806385695978 | 1402 | 0.0 | -0.97342577079084 | -0.0230514144505307 | monthly | 7 | 316.58064516129 | 0.0 | 324.05046677378 | -7.46982161248982 | 316.58064516129 | 0.0 | -0.219805819210835 | ||
23854 | 23854 | Mongolia | Mongolia | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 3398373 | 1402 | 0 | 1435.0806385696 | -33.0806385695978 | 1402 | 0.0 | -0.97342577079084 | -0.0230514144505292 | monthly | 7 | 316.58064516129 | 0.0 | 324.05046677378 | -7.46982161248982 | 316.58064516129 | 0.0 | -0.219805819210835 | ||
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 | ||
22475 | 22475 | Mongolia | Mongolia | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 3398373 | 1288 | 0 | 1479.4806385696 | -191.480638569598 | 1288 | 0.0 | -5.63447975162226 | -0.129424227379365 | monthly | 5 | 290.838709677419 | 0.0 | 334.076273225393 | -43.2375635479737 | 290.838709677419 | 0.0 | -1.27230187939857 | ||
23852 | 23852 | Mongolia | Mongolia | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 3398373 | 1288 | 0 | 1479.4806385696 | -191.480638569598 | 1288 | 0.0 | -5.63447975162225 | -0.129424227379364 | monthly | 5 | 290.838709677419 | 0.0 | 334.076273225393 | -43.2375635479737 | 290.838709677419 | 0.0 | -1.27230187939857 | ||
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 | ||
22473 | 22473 | Mongolia | Mongolia | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 3398373 | 1292 | 0 | 1496.6806385696 | -204.680638569598 | 1292 | 0.0 | -6.02290091669155 | -0.13675638830019 | monthly | 3 | 291.741935483871 | 0.0 | 337.960144193135 | -46.218208709264 | 291.741935483871 | 0.0 | -1.36000988441422 | ||
23850 | 23850 | Mongolia | Mongolia | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 3398373 | 1292 | 0 | 1496.6806385696 | -204.680638569598 | 1292 | 0.0 | -6.02290091669154 | -0.136756388300188 | monthly | 3 | 291.741935483871 | 0.0 | 337.960144193135 | -46.218208709264 | 291.741935483871 | 0.0 | -1.36000988441422 | ||
22472 | 22472 | Mongolia | Mongolia | 0 | 2020-02-01 | 2020-02-29 | 29 | 2020 | 3398373 | 1298 | 0 | 1376.7825254594 | -78.7825254594011 | 1298 | 0.0 | -2.31824244894251 | -0.0572222003130902 | monthly | 2 | 313.310344827586 | 0.0 | 332.3268164902 | -19.0164716626141 | 313.310344827586 | 0.0 | -0.559575763537848 | ||
23849 | 23849 | Mongolia | Mongolia | 0 | 2020-02-01 | 2020-02-29 | 29 | 2020 | 3398373 | 1298 | 0 | 1376.7825254594 | -78.7825254594011 | 1298 | 0.0 | -2.31824244894251 | -0.057222200313091 | monthly | 2 | 313.310344827586 | 0.0 | 332.3268164902 | -19.0164716626141 | 313.310344827586 | 0.0 | -0.559575763537848 | ||
22471 | 22471 | Mongolia | Mongolia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 3398373 | 1366 | 0 | 1455.56719880799 | -89.5671988079919 | 1366 | 0.0 | -2.63559058431761 | -0.0615342245149104 | monthly | 1 | 308.451612903226 | 0.0 | 328.676464246966 | -20.2248513437401 | 308.451612903226 | 0.0 | -0.595133357749138 | ||
23848 | 23848 | Mongolia | Mongolia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 3398373 | 1366 | 0 | 1455.56719880799 | -89.5671988079919 | 1366 | 0.0 | -2.63559058431761 | -0.0615342245149115 | monthly | 1 | 308.451612903226 | 0.0 | 328.676464246966 | -20.2248513437401 | 308.451612903226 | 0.0 | -0.595133357749138 |
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);