economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
20 rows where cadence = "monthly", country = "Japan" and year = 2022 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, days, covid_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, excess_deaths_per_100k_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
334 | 334 | Japan | Japan | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 123951696 | 131840 | 1847 | 120086.727931338 | 11753.2720686615 | 129993 | 1.49009659375697 | 9.48213896860398 | 0.0978731977390679 | monthly | 10 | 29770.3225806452 | 417.064516129032 | 27116.3579199797 | 2653.96466066551 | 29353.2580645161 | 0.336473424396736 | 2.1411281542009 | ||
22093 | 22093 | Japan | Japan | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 123951696 | 131840 | 1847 | 120086.727931338 | 11753.2720686615 | 129993 | 1.49009659375697 | 9.48213896860395 | 0.0978731977390721 | monthly | 10 | 29770.3225806452 | 417.064516129032 | 27116.3579199797 | 2653.96466066551 | 29353.2580645161 | 0.336473424396736 | 2.1411281542009 | ||
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 | ||
332 | 332 | Japan | Japan | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 123951696 | 135649 | 7329 | 114261.327931338 | 21387.6720686615 | 128320 | 5.91278718767995 | 17.2548442327579 | 0.187182071623688 | monthly | 8 | 30630.4193548387 | 1654.93548387097 | 25800.9450167538 | 4829.47433808486 | 28975.4838709677 | 1.33514549399225 | 3.89625514933242 | ||
22091 | 22091 | Japan | Japan | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 123951696 | 135649 | 7329 | 114261.327931338 | 21387.6720686615 | 128320 | 5.91278718767995 | 17.2548442327578 | 0.187182071623693 | monthly | 8 | 30630.4193548387 | 1654.93548387097 | 25800.9450167538 | 4829.47433808486 | 28975.4838709677 | 1.33514549399225 | 3.89625514933242 | ||
331 | 331 | Japan | Japan | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 123951696 | 117568 | 1332 | 112057.127931338 | 5510.87206866153 | 116236 | 1.07461216182149 | 4.44598359401353 | 0.0491791300597875 | monthly | 7 | 26547.6129032258 | 300.774193548387 | 25303.2224361087 | 1244.39046711712 | 26246.8387096774 | 0.242654359120981 | 1.00393177929338 | ||
22090 | 22090 | Japan | Japan | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 123951696 | 117568 | 1332 | 112057.127931338 | 5510.87206866153 | 116236 | 1.07461216182149 | 4.44598359401353 | 0.0491791300597919 | monthly | 7 | 26547.6129032258 | 300.774193548387 | 25303.2224361087 | 1244.39046711712 | 26246.8387096774 | 0.242654359120981 | 1.00393177929338 | ||
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 | ||
329 | 329 | Japan | Japan | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 123951696 | 121473 | 1052 | 114878.527931338 | 6594.47206866153 | 120421 | 0.848717713390545 | 5.32019510944129 | 0.0574038698737764 | monthly | 5 | 27429.3870967742 | 237.548387096774 | 25940.3127586893 | 1489.07433808486 | 27191.8387096774 | 0.191645935281736 | 1.20133437955126 | ||
22088 | 22088 | Japan | Japan | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 123951696 | 121473 | 1052 | 114878.527931338 | 6594.47206866153 | 120421 | 0.848717713390545 | 5.32019510944129 | 0.0574038698737807 | monthly | 5 | 27429.3870967742 | 237.548387096774 | 25940.3127586893 | 1489.07433808486 | 27191.8387096774 | 0.191645935281736 | 1.20133437955126 | ||
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 | ||
327 | 327 | Japan | Japan | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 123951696 | 139571 | 4454 | 126946.527931338 | 12624.4720686615 | 135117 | 3.59333526182651 | 10.1849934095791 | 0.0994471631038991 | monthly | 3 | 31516.0322580645 | 1005.74193548387 | 28665.3450167539 | 2850.68724131066 | 30510.2903225806 | 0.811398284928567 | 2.29983722151786 | ||
22086 | 22086 | Japan | Japan | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 123951696 | 139571 | 4454 | 126946.527931338 | 12624.4720686615 | 135117 | 3.59333526182651 | 10.1849934095791 | 0.0994471631039033 | monthly | 3 | 31516.0322580645 | 1005.74193548387 | 28665.3450167539 | 2850.68724131066 | 30510.2903225806 | 0.811398284928567 | 2.29983722151786 | ||
326 | 326 | Japan | Japan | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 123951696 | 138474 | 4855 | 122507.168356198 | 15966.8316438019 | 133619 | 3.91684838261511 | 12.881495097737 | 0.130333856035079 | monthly | 2 | 34618.5 | 1213.75 | 30626.7920890495 | 3991.70791095047 | 33404.75 | 0.979212095653778 | 3.22037377443426 | ||
22085 | 22085 | Japan | Japan | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 123951696 | 138474 | 4855 | 122507.168356198 | 15966.8316438019 | 133619 | 3.91684838261511 | 12.881495097737 | 0.13033385603508 | monthly | 2 | 34618.5 | 1213.75 | 30626.7920890495 | 3991.70791095047 | 33404.75 | 0.979212095653778 | 3.22037377443426 | ||
325 | 325 | Japan | Japan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 123951696 | 143992 | 423 | 142209.561804871 | 1782.43819512927 | 143569 | 0.341261970308176 | 1.43801033196776 | 0.0125338843078289 | monthly | 1 | 32514.3225806452 | 95.5161290322581 | 32111.8365365837 | 402.486044061449 | 32418.8064516129 | 0.077059154585717 | 0.324712010444334 | ||
22084 | 22084 | Japan | Japan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 123951696 | 143992 | 423 | 142209.561804871 | 1782.43819512927 | 143569 | 0.341261970308176 | 1.43801033196776 | 0.0125338843078269 | monthly | 1 | 32514.3225806452 | 95.5161290322581 | 32111.8365365837 | 402.486044061449 | 32418.8064516129 | 0.077059154585717 | 0.324712010444334 |
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);