economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
22 rows where country = "Japan" 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, covid_deaths_per_100k, excess_deaths_per_100k, total_deaths_per_7_days, expected_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
333 | 333 | Japan | Japan | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 123951696 | 127040 | 4976 | 111227.981869037 | 15812.0181309628 | 122064 | 4.01446705497277 | 12.7565968366925 | 0.142158635491384 | monthly | 9 | 29642.6666666667 | 1161.06666666667 | 25953.195769442 | 3689.47089722465 | 28481.6 | 0.936708979493646 | 2.97653926189493 | ||
22092 | 22092 | Japan | Japan | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 123951696 | 127040 | 4976 | 111227.981869037 | 15812.0181309628 | 122064 | 4.01446705497277 | 12.7565968366926 | 0.142158635491387 | monthly | 9 | 29642.6666666667 | 1161.06666666667 | 25953.195769442 | 3689.47089722465 | 28481.6 | 0.936708979493646 | 2.97653926189493 | ||
330 | 330 | Japan | Japan | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 123951696 | 111904 | 658 | 106601.581869037 | 5302.41813096277 | 111246 | 0.530851953812717 | 4.27781006801454 | 0.0497405201498504 | monthly | 6 | 26110.9333333333 | 153.533333333333 | 24873.7024361087 | 1237.23089722465 | 25957.4 | 0.123865455889634 | 0.998155682536726 | ||
22089 | 22089 | Japan | Japan | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 123951696 | 111904 | 658 | 106601.581869037 | 5302.41813096277 | 111246 | 0.530851953812717 | 4.27781006801454 | 0.0497405201498526 | monthly | 6 | 26110.9333333333 | 153.533333333333 | 24873.7024361087 | 1237.23089722465 | 25957.4 | 0.123865455889634 | 0.998155682536726 | ||
328 | 328 | Japan | Japan | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 123951696 | 121799 | 1447 | 116946.181869037 | 4852.81813096278 | 120352 | 1.16739023885563 | 3.91508812510543 | 0.0414961656157122 | monthly | 4 | 28419.7666666667 | 337.633333333333 | 27287.4424361087 | 1132.32423055798 | 28082.1333333333 | 0.27239105573298 | 0.913520562524601 | ||
22087 | 22087 | Japan | Japan | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 123951696 | 121799 | 1447 | 116946.181869037 | 4852.81813096278 | 120352 | 1.16739023885563 | 3.91508812510543 | 0.0414961656157142 | monthly | 4 | 28419.7666666667 | 337.633333333333 | 27287.4424361087 | 1132.32423055798 | 28082.1333333333 | 0.27239105573298 | 0.913520562524601 | ||
323 | 323 | Japan | Japan | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 123951696 | 122806 | 93 | 121018.10549523 | 1787.89450477011 | 122713 | 0.0750292275145634 | 1.44241229645628 | 0.0147737770100904 | monthly | 11 | 28654.7333333333 | 21.7 | 28237.557948887 | 417.17538444636 | 28633.0333333333 | 0.0175068197533981 | 0.336562869173133 | ||
22082 | 22082 | Japan | Japan | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 123951696 | 122806 | 93 | 121018.10549523 | 1787.89450477011 | 122713 | 0.0750292275145634 | 1.44241229645628 | 0.0147737770100893 | monthly | 11 | 28654.7333333333 | 21.7 | 28237.557948887 | 417.17538444636 | 28633.0333333333 | 0.0175068197533981 | 0.336562869173133 | ||
321 | 321 | Japan | Japan | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 123951696 | 115706 | 1584 | 109452.30549523 | 6253.69450477013 | 114122 | 1.27791716540934 | 5.0452673957524 | 0.0571362519635794 | monthly | 9 | 26998.0666666667 | 369.6 | 25538.8712822203 | 1459.19538444636 | 26628.4666666667 | 0.298180671928846 | 1.17722905900889 | ||
22080 | 22080 | Japan | Japan | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 123951696 | 115706 | 1584 | 109452.30549523 | 6253.69450477013 | 114122 | 1.27791716540934 | 5.0452673957524 | 0.0571362519635783 | monthly | 9 | 26998.0666666667 | 369.6 | 25538.8712822203 | 1459.19538444636 | 26628.4666666667 | 0.298180671928846 | 1.17722905900889 | ||
318 | 318 | Japan | Japan | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 123951696 | 108734 | 1725 | 104825.90549523 | 3908.09450477014 | 107009 | 1.39167115551206 | 3.1529173306109 | 0.0372817624260635 | monthly | 6 | 25371.2666666667 | 402.5 | 24459.377948887 | 911.888717779699 | 24968.7666666667 | 0.324723269619481 | 0.735680710475877 | ||
22077 | 22077 | Japan | Japan | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 123951696 | 108734 | 1725 | 104825.90549523 | 3908.09450477014 | 107009 | 1.39167115551206 | 3.1529173306109 | 0.037281762426062 | monthly | 6 | 25371.2666666667 | 402.5 | 24459.377948887 | 911.888717779699 | 24968.7666666667 | 0.324723269619481 | 0.735680710475877 | ||
316 | 316 | Japan | Japan | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 123951696 | 118169 | 1067 | 115170.50549523 | 2998.49450477015 | 117102 | 0.860819201699346 | 2.41908307956524 | 0.0260352639061252 | monthly | 4 | 27572.7666666667 | 248.966666666667 | 26873.117948887 | 699.648717779701 | 27323.8 | 0.200857813729847 | 0.564452718565223 | ||
22075 | 22075 | Japan | Japan | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 123951696 | 118169 | 1067 | 115170.50549523 | 2998.49450477015 | 117102 | 0.860819201699346 | 2.41908307956524 | 0.0260352639061239 | monthly | 4 | 27572.7666666667 | 248.966666666667 | 26873.117948887 | 699.648717779701 | 27323.8 | 0.200857813729847 | 0.564452718565223 | ||
311 | 311 | Japan | Japan | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 123951696 | 118455 | 382 | 119242.429121422 | -787.429121422087 | 118073 | 0.308184568930787 | -0.635270953793231 | -0.00660359846091585 | monthly | 11 | 27639.5 | 89.1333333333333 | 27823.2334616652 | -183.733461665154 | 27550.3666666667 | 0.071909732750517 | -0.148229889218421 | ||
22070 | 22070 | Japan | Japan | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 123951696 | 118455 | 382 | 119242.429121422 | -787.429121422087 | 118073 | 0.308184568930787 | -0.635270953793232 | -0.00660359846091507 | monthly | 11 | 27639.5 | 89.1333333333333 | 27823.2334616652 | -183.733461665154 | 27550.3666666667 | 0.071909732750517 | -0.148229889218421 | ||
309 | 309 | Japan | Japan | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 123951696 | 107468 | 275 | 107676.629121422 | -208.629121422069 | 107193 | 0.221860618994677 | -0.168314858250967 | -0.00193755249513627 | monthly | 9 | 25075.8666666667 | 64.1666666666667 | 25124.5467949985 | -48.6801283318161 | 25011.7 | 0.0517674777654246 | -0.0392734669252256 | ||
22068 | 22068 | Japan | Japan | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 123951696 | 107468 | 275 | 107676.629121422 | -208.629121422069 | 107193 | 0.221860618994677 | -0.168314858250967 | -0.0019375524951355 | monthly | 9 | 25075.8666666667 | 64.1666666666667 | 25124.5467949985 | -48.6801283318161 | 25011.7 | 0.0517674777654246 | -0.0392734669252256 | ||
306 | 306 | Japan | Japan | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 123951696 | 100423 | 76 | 103050.229121422 | -2627.22912142206 | 100347 | 0.0613142074312561 | -2.11955883316196 | -0.0254946460946385 | monthly | 6 | 23432.0333333333 | 17.7333333333333 | 24045.0534616651 | -613.020128331814 | 23414.3 | 0.0143066484006264 | -0.494563727737791 | ||
22065 | 22065 | Japan | Japan | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 123951696 | 100423 | 76 | 103050.229121422 | -2627.22912142206 | 100347 | 0.0613142074312561 | -2.11955883316196 | -0.0254946460946379 | monthly | 6 | 23432.0333333333 | 17.7333333333333 | 24045.0534616651 | -613.020128331814 | 23414.3 | 0.0143066484006264 | -0.494563727737791 | ||
304 | 304 | Japan | Japan | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 123951696 | 113362 | 414 | 113394.829121422 | -32.8291214220517 | 112948 | 0.334001077322895 | -0.0264854152718101 | -0.00028951162655666 | monthly | 4 | 26451.1333333333 | 96.6 | 26458.7934616651 | -7.66012833181206 | 26354.5333333333 | 0.0779335847086755 | -0.00617993023008903 | ||
22063 | 22063 | Japan | Japan | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 123951696 | 113362 | 414 | 113394.829121422 | -32.8291214220517 | 112948 | 0.334001077322895 | -0.0264854152718102 | -0.000289511626556105 | monthly | 4 | 26451.1333333333 | 96.6 | 26458.7934616651 | -7.66012833181206 | 26354.5333333333 | 0.0779335847086755 | -0.00617993023008903 |
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);