economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
22 rows where cadence = "monthly", country = "Mongolia" 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, excess_deaths, covid_deaths_per_100k, excess_deaths_per_100k, 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
22502 | 22502 | Mongolia | Mongolia | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 3398373 | 1609 | 9 | 1464.734397616 | 144.265602383999 | 1600 | 0.26483261254724 | 4.24513737556175 | 0.0984926704928939 | monthly | 8 | 363.322580645161 | 2.03225806451613 | 330.746476881033 | 32.5761037641288 | 361.290322580645 | 0.059800912510667 | 0.958579407384909 | ||
23879 | 23879 | Mongolia | Mongolia | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 3398373 | 1609 | 9 | 1464.734397616 | 144.265602383999 | 1600 | 0.26483261254724 | 4.24513737556174 | 0.098492670492893 | monthly | 8 | 363.322580645161 | 2.03225806451613 | 330.746476881033 | 32.5761037641288 | 361.290322580645 | 0.059800912510667 | 0.958579407384909 | ||
22501 | 22501 | Mongolia | Mongolia | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 3398373 | 1438 | 1 | 1474.334397616 | -36.3343976160011 | 1437 | 0.0294258458385822 | -1.0691703828862 | -0.0246446109340952 | monthly | 7 | 324.709677419355 | 0.225806451612903 | 332.914218816516 | -8.20454139716153 | 324.483870967742 | 0.00664454583451855 | -0.241425570329141 | ||
23878 | 23878 | Mongolia | Mongolia | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 3398373 | 1438 | 1 | 1474.334397616 | -36.3343976160011 | 1437 | 0.0294258458385822 | -1.06917038288619 | -0.024644610934096 | monthly | 7 | 324.709677419355 | 0.225806451612903 | 332.914218816516 | -8.20454139716153 | 324.483870967742 | 0.00664454583451855 | -0.241425570329141 | ||
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 | ||
22499 | 22499 | Mongolia | Mongolia | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 3398373 | 1506 | 5 | 1518.734397616 | -12.7343976160009 | 1501 | 0.147129229192911 | -0.374720421095651 | -0.00838487469302707 | monthly | 5 | 340.064516129032 | 1.12903225806452 | 342.940025268129 | -2.87550913909699 | 338.935483870968 | 0.0332227291725928 | -0.084614288634502 | ||
23876 | 23876 | Mongolia | Mongolia | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 3398373 | 1506 | 5 | 1518.734397616 | -12.7343976160009 | 1501 | 0.147129229192911 | -0.374720421095652 | -0.00838487469302762 | monthly | 5 | 340.064516129032 | 1.12903225806452 | 342.940025268129 | -2.87550913909699 | 338.935483870968 | 0.0332227291725928 | -0.084614288634502 | ||
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 | ||
22497 | 22497 | Mongolia | Mongolia | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 3398373 | 1496 | 12 | 1535.934397616 | -39.934397616001 | 1484 | 0.353110150062986 | -1.17510342790509 | -0.0260000672411428 | monthly | 3 | 337.806451612903 | 2.70967741935484 | 346.823896235871 | -9.01744462296796 | 335.096774193548 | 0.0797345500142227 | -0.265345935333407 | ||
23874 | 23874 | Mongolia | Mongolia | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 3398373 | 1496 | 12 | 1535.934397616 | -39.934397616001 | 1484 | 0.353110150062986 | -1.17510342790509 | -0.0260000672411433 | monthly | 3 | 337.806451612903 | 2.70967741935484 | 346.823896235871 | -9.01744462296796 | 335.096774193548 | 0.0797345500142227 | -0.265345935333407 | ||
22496 | 22496 | Mongolia | Mongolia | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 3398373 | 1487 | 60 | 1364.76227413175 | 122.237725868254 | 1427 | 1.76555075031493 | 3.59694847705811 | 0.0895670463531948 | monthly | 2 | 371.75 | 15.0 | 341.190568532936 | 30.5594314670635 | 356.75 | 0.441387687578732 | 0.899237119264528 | ||
23873 | 23873 | Mongolia | Mongolia | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 3398373 | 1487 | 60 | 1364.76227413175 | 122.237725868254 | 1427 | 1.76555075031493 | 3.59694847705811 | 0.0895670463531981 | monthly | 2 | 371.75 | 15.0 | 341.190568532936 | 30.5594314670635 | 356.75 | 0.441387687578732 | 0.899237119264528 | ||
22495 | 22495 | Mongolia | Mongolia | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 3398373 | 1345 | 50 | 1494.8209578544 | -149.820957854395 | 1295 | 1.47129229192911 | -4.40860840921214 | -0.100226690739904 | monthly | 1 | 303.709677419355 | 11.2903225806452 | 337.540216289702 | -33.8305388703473 | 292.41935483871 | 0.332227291725928 | -0.995492221435001 | ||
23872 | 23872 | Mongolia | Mongolia | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 3398373 | 1345 | 50 | 1494.8209578544 | -149.820957854395 | 1295 | 1.47129229192911 | -4.40860840921215 | -0.100226690739901 | monthly | 1 | 303.709677419355 | 11.2903225806452 | 337.540216289702 | -33.8305388703473 | 292.41935483871 | 0.332227291725928 | -0.995492221435001 |
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);