economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
20 rows where cadence = "monthly", country = "Kyrgyzstan" and year = 2022 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, days, total_deaths, covid_deaths, expected_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_pct_change, month, covid_deaths_per_7_days, expected_deaths_per_7_days, non_covid_deaths_per_7_days, covid_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11001 | 11001 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 6630621 | 1656 | 0 | 2698.47193790671 | -1042.47193790671 | 1656 | 0.0 | -15.722086029449 | -0.38631935476616 | monthly | 10 | 373.935483870968 | 0.0 | 609.332373075708 | -235.396889204741 | 373.935483870968 | 0.0 | -3.55014845826267 | ||
22242 | 22242 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 6630621 | 1656 | 0 | 2698.47193790671 | -1042.47193790671 | 1656 | 0.0 | -15.722086029449 | -0.38631935476616 | monthly | 10 | 373.935483870968 | 0.0 | 609.332373075708 | -235.396889204741 | 373.935483870968 | 0.0 | -3.55014845826267 | ||
11000 | 11000 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 6630621 | 2799 | 0 | 2466.35348829682 | 332.646511703184 | 2799 | 0.0 | 5.01682288436007 | 0.134873818080676 | monthly | 9 | 653.1 | 0.0 | 575.48248060259 | 77.6175193974097 | 653.1 | 0.0 | 1.17059200635068 | ||
22241 | 22241 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 6630621 | 2799 | 0 | 2466.35348829682 | 332.646511703184 | 2799 | 0.0 | 5.01682288436006 | 0.134873818080673 | monthly | 9 | 653.1 | 0.0 | 575.48248060259 | 77.6175193974097 | 653.1 | 0.0 | 1.17059200635068 | ||
10999 | 10999 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 6630621 | 4307 | 0 | 2566.07193790671 | 1740.92806209329 | 4307 | 0.0 | 26.2558825499646 | 0.67844086378711 | monthly | 8 | 972.548387096774 | 0.0 | 579.43559888216 | 393.112788214614 | 972.548387096774 | 0.0 | 5.92874767257266 | ||
22240 | 22240 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 6630621 | 4307 | 0 | 2566.07193790671 | 1740.92806209329 | 4307 | 0.0 | 26.2558825499646 | 0.678440863787109 | monthly | 8 | 972.548387096774 | 0.0 | 579.43559888216 | 393.112788214614 | 972.548387096774 | 0.0 | 5.92874767257266 | ||
10998 | 10998 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 6630621 | 2378 | 0 | 2815.27193790671 | -437.271937906709 | 2378 | 0.0 | -6.59473581594709 | -0.155321385482868 | monthly | 7 | 536.967741935484 | 0.0 | 635.706566624096 | -98.7388246886118 | 536.967741935484 | 0.0 | -1.48913389392354 | ||
22239 | 22239 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 6630621 | 2378 | 0 | 2815.27193790671 | -437.271937906709 | 2378 | 0.0 | -6.59473581594709 | -0.155321385482868 | monthly | 7 | 536.967741935484 | 0.0 | 635.706566624096 | -98.7388246886118 | 536.967741935484 | 0.0 | -1.48913389392354 | ||
10997 | 10997 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 6630621 | 2483 | 0 | 2549.35348829682 | -66.3534882968156 | 2483 | 0.0 | -1.00071302969685 | -0.0260275746778237 | monthly | 6 | 579.366666666667 | 0.0 | 594.849147269257 | -15.4824806025903 | 579.366666666667 | 0.0 | -0.233499706929265 | ||
22238 | 22238 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 6630621 | 2483 | 0 | 2549.35348829682 | -66.3534882968156 | 2483 | 0.0 | -1.00071302969685 | -0.0260275746778253 | monthly | 6 | 579.366666666667 | 0.0 | 594.849147269257 | -15.4824806025903 | 579.366666666667 | 0.0 | -0.233499706929265 | ||
10996 | 10996 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 6630621 | 1951 | 0 | 2711.67193790671 | -760.671937906709 | 1951 | 0.0 | -11.4721070304985 | -0.280517686255925 | monthly | 5 | 440.548387096774 | 0.0 | 612.313018236999 | -171.764631140225 | 440.548387096774 | 0.0 | -2.5904757810803 | ||
22237 | 22237 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 6630621 | 1951 | 0 | 2711.67193790671 | -760.671937906709 | 1951 | 0.0 | -11.4721070304985 | -0.280517686255925 | monthly | 5 | 440.548387096774 | 0.0 | 612.313018236999 | -171.764631140225 | 440.548387096774 | 0.0 | -2.5904757810803 | ||
10995 | 10995 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 6630621 | 2924 | 3 | 2619.75348829682 | 304.246511703184 | 2921 | 0.0452446309327588 | 4.58850704486328 | 0.116135549799758 | monthly | 4 | 682.266666666667 | 0.7 | 611.275813935924 | 70.990852730743 | 681.566666666667 | 0.0105570805509771 | 1.07065164380143 | ||
22236 | 22236 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 6630621 | 2924 | 3 | 2619.75348829682 | 304.246511703184 | 2921 | 0.0452446309327588 | 4.58850704486328 | 0.116135549799756 | monthly | 4 | 682.266666666667 | 0.7 | 611.275813935924 | 70.990852730743 | 681.566666666667 | 0.0105570805509771 | 1.07065164380143 | ||
10994 | 10994 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 6630621 | 2955 | 30 | 2690.07193790671 | 264.92806209329 | 2925 | 0.452446309327588 | 3.99552413104731 | 0.098483634716269 | monthly | 3 | 667.258064516129 | 6.7741935483871 | 607.43559888216 | 59.8224656339688 | 660.483870967742 | 0.102165295654617 | 0.902215126365522 | ||
22235 | 22235 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 6630621 | 2955 | 30 | 2690.07193790671 | 264.92806209329 | 2925 | 0.452446309327588 | 3.9955241310473 | 0.098483634716269 | monthly | 3 | 667.258064516129 | 6.7741935483871 | 607.43559888216 | 59.8224656339688 | 660.483870967742 | 0.102165295654617 | 0.902215126365522 | ||
10993 | 10993 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 6630621 | 3177 | 78 | 2553.17872327277 | 623.821276727226 | 3099 | 1.17636040425173 | 9.40818781117524 | 0.244331221720188 | monthly | 2 | 794.25 | 19.5 | 638.294680818194 | 155.955319181806 | 774.75 | 0.294090101062932 | 2.35204695279381 | ||
22234 | 22234 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 6630621 | 3177 | 78 | 2553.17872327277 | 623.821276727226 | 3099 | 1.17636040425173 | 9.40818781117524 | 0.24433122172019 | monthly | 2 | 794.25 | 19.5 | 638.294680818194 | 155.955319181806 | 774.75 | 0.294090101062932 | 2.35204695279381 | ||
10992 | 10992 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 6630621 | 2671 | 78 | 2958.53141078271 | -287.531410782712 | 2593 | 1.17636040425173 | -4.33641752081308 | -0.0971872090777099 | monthly | 1 | 603.129032258065 | 17.6129032258065 | 668.055479854161 | -64.9264475960962 | 585.516129032258 | 0.265629768702003 | -0.979191053086825 | ||
22233 | 22233 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 6630621 | 2671 | 78 | 2958.53141078271 | -287.531410782712 | 2593 | 1.17636040425173 | -4.33641752081309 | -0.0971872090777094 | monthly | 1 | 603.129032258065 | 17.6129032258065 | 668.055479854161 | -64.9264475960962 | 585.516129032258 | 0.265629768702003 | -0.979191053086825 |
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);