economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
31 rows where covid_deaths = 146 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, start_date, end_date, year, week, population, total_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_per_100k, excess_deaths_pct_change, month, 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)
country 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3940 | 3940 | United States | Georgia | GA | 2022-09-18 | 2022-09-24 | 7 | 2022 | 38 | 10617423 | 1884 | 146 | 1630.72681704316 | 253.273182956844 | 1738 | 1.37509827007928 | 2.38544873795501 | 0.155313066731852 | weekly | |||||||||
3934 | 3934 | United States | Georgia | GA | 2022-08-07 | 2022-08-13 | 7 | 2022 | 32 | 10617423 | 1838 | 146 | 1617.06015037653 | 220.939849623469 | 1692 | 1.37509827007928 | 2.08091784252609 | 0.13663056972372 | weekly | |||||||||
14422 | 14422 | Iran | Iran | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 88550568 | 7499.6 | 146 | 7499.75558988747 | -0.15558988747307 | 7353.6 | 0.164877542061616 | -0.000175707385042488 | -2.0745994400051e-05 | weekly | |||||||||
24338 | 24338 | Iran | Iran | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 88550568 | 7499.6 | 146 | 7499.75558988747 | -0.15558988747307 | 7353.6 | 0.164877542061616 | -0.000175707385042488 | -2.07459944004951e-05 | weekly | |||||||||
12929 | 12929 | Denmark | Denmark | 0 | 2022-04-04 | 2022-04-10 | 7 | 2022 | 14 | 5882259 | 1197 | 146 | 1091.40477528089 | 105.595224719108 | 1051 | 2.48203963817302 | 1.79514748873023 | 0.0967516608967864 | weekly | |||||||||
19038 | 19038 | Denmark | Denmark | 0 | 2022-04-04 | 2022-04-10 | 7 | 2022 | 14 | 5882259 | 1197 | 146 | 1091.40477528089 | 105.595224719108 | 1051 | 2.48203963817302 | 1.79514748873023 | 0.0967516608967844 | weekly | |||||||||
11292 | 11292 | Australia | Australia | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 26177410 | 3344 | 146 | 2991.14578651684 | 352.854213483163 | 3198 | 0.557732793274812 | 1.34793401441611 | 0.117966237243841 | weekly | |||||||||
18880 | 18880 | Australia | Australia | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 26177410 | 3344 | 146 | 2991.14578651684 | 352.854213483163 | 3198 | 0.557732793274812 | 1.34793401441611 | 0.117966237243842 | weekly | |||||||||
9686 | 9686 | United States | West Virginia | WV | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 1792147 | 552 | 146 | 448.210526316807 | 103.789473683193 | 406 | 8.14665314843035 | 5.79134823667886 | 0.231564114605002 | weekly | |||||||||
9684 | 9684 | United States | West Virginia | WV | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 1792147 | 674 | 146 | 475.710526316804 | 198.289473683196 | 528 | 8.14665314843035 | 11.0643531854918 | 0.416828013494793 | weekly | |||||||||
2843 | 2843 | United States | Arkansas | AR | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 3017825 | 968 | 146 | 670.421052633248 | 297.578947366752 | 822 | 4.8379213506416 | 9.86070919840455 | 0.443868739201932 | weekly | |||||||||
14538 | 14538 | Israel | Israel | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 9449000 | 959 | 146 | 806.308988763996 | 152.691011236004 | 813 | 1.54513705153985 | 1.61594889656052 | 0.189370344822853 | weekly | |||||||||
20707 | 20707 | Israel | Israel | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 9449000 | 959 | 146 | 806.308988763996 | 152.691011236004 | 813 | 1.54513705153985 | 1.61594889656052 | 0.189370344822853 | weekly | |||||||||
11033 | 11033 | Moldova | Moldova | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 3272993 | 2499 | 146 | 2376.57911938208 | 122.420880617916 | 2353 | 4.4607489230805 | 3.74033432451326 | 0.0515113844178459 | monthly | 8 | 564.290322580645 | 32.9677419354839 | 536.646897924987 | 27.6434246556585 | 531.322580645161 | 1.00726588585689 | 0.844591621664284 | ||
22424 | 22424 | Moldova | Moldova | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 3272993 | 2499 | 146 | 2376.57911938208 | 122.420880617916 | 2353 | 4.4607489230805 | 3.74033432451325 | 0.0515113844178476 | monthly | 8 | 564.290322580645 | 32.9677419354839 | 536.646897924987 | 27.6434246556585 | 531.322580645161 | 1.00726588585689 | 0.844591621664284 | ||
2817 | 2817 | United States | Arkansas | AR | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 3017825 | 899 | 146 | 554.098997495271 | 344.901002504729 | 753 | 4.8379213506416 | 11.428793999146 | 0.622453756573838 | weekly | |||||||||
8893 | 8893 | United States | Texas | TX | 2021-07-04 | 2021-07-10 | 7 | 2021 | 27 | 28995881 | 4259 | 146 | 3786.67669172988 | 472.323308270119 | 4113 | 0.503519793035431 | 1.62893242757521 | 0.124732937803134 | weekly | |||||||||
1185 | 1185 | Ecuador | Ecuador | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 18001002 | 1672 | 146 | 1453.09438202238 | 218.905617977623 | 1526 | 0.811065961772572 | 1.21607462727699 | 0.150647900567172 | weekly | |||||||||
13009 | 13009 | Ecuador | Ecuador | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 18001002 | 1672 | 146 | 1453.09438202238 | 218.905617977623 | 1526 | 0.811065961772572 | 1.21607462727699 | 0.150647900567169 | weekly | |||||||||
1856 | 1856 | Guatemala | Guatemala | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 17843914 | 1819 | 146 | 1617.29353932583 | 201.706460674174 | 1673 | 0.818206140199958 | 1.13039359343569 | 0.124718522500409 | weekly | |||||||||
13910 | 13910 | Guatemala | Guatemala | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 17843914 | 1819 | 146 | 1617.29353932583 | 201.706460674174 | 1673 | 0.818206140199958 | 1.13039359343569 | 0.124718522500406 | weekly | |||||||||
1849 | 1849 | Guatemala | Guatemala | 0 | 2020-08-24 | 2020-08-30 | 7 | 2020 | 35 | 17843914 | 2127 | 146 | 1566.69353932583 | 560.306460674173 | 1981 | 0.818206140199958 | 3.14004237340627 | 0.3576362872571 | weekly | |||||||||
13903 | 13903 | Guatemala | Guatemala | 0 | 2020-08-24 | 2020-08-30 | 7 | 2020 | 35 | 17843914 | 2127 | 146 | 1566.69353932583 | 560.306460674173 | 1981 | 0.818206140199958 | 3.14004237340627 | 0.357636287257097 | weekly | |||||||||
8693 | 8693 | United States | Tennessee | TN | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 6833174 | 1707 | 146 | 1376.6942355899 | 330.305764410095 | 1561 | 2.13663518593263 | 4.83385560517111 | 0.239926743260141 | weekly | |||||||||
13446 | 13446 | France | France | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 67813000 | 10129 | 146 | 10637.5581460671 | -508.558146067107 | 9983 | 0.215297951720172 | -0.749941966978466 | -0.0478077900100714 | weekly | |||||||||
19985 | 19985 | France | France | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 67813000 | 10129 | 146 | 10637.5581460671 | -508.558146067107 | 9983 | 0.215297951720172 | -0.749941966978466 | -0.0478077900100721 | weekly | |||||||||
21550 | 21550 | Belarus | Belarus | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 9534956 | 11966 | 146 | 10270.0721720489 | 1695.9278279511 | 11820 | 1.53120790489227 | 17.786425317024 | 0.165132999996509 | monthly | 5 | 2702.0 | 32.9677419354839 | 2319.04855497878 | 382.951445021216 | 2669.03225806452 | 0.345756623685352 | 4.0162895877151 | ||
24367 | 24367 | Belarus | Belarus | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 9534956 | 11966 | 146 | 10270.0721720489 | 1695.9278279511 | 11820 | 1.53120790489227 | 17.786425317024 | 0.165132999996509 | monthly | 5 | 2702.0 | 32.9677419354839 | 2319.04855497878 | 382.951445021216 | 2669.03225806452 | 0.345756623685352 | 4.0162895877151 | ||
16997 | 16997 | South Africa | South Africa | 0 | 2020-05-17 | 2020-05-23 | 7 | 2020 | 21 | 59893884 | 9798 | 146 | 10169.2259414226 | -371.225941422574 | 9652 | 0.243764455148709 | -0.61980609142425 | -0.0365048375914704 | weekly | |||||||||
16551 | 16551 | Romania | Romania | 0 | 2020-05-11 | 2020-05-17 | 7 | 2020 | 20 | 19659270 | 4870 | 146 | 4610.02837078653 | 259.971629213466 | 4724 | 0.742652194104867 | 1.32238699205752 | 0.056392631086805 | weekly | |||||||||
23482 | 23482 | Romania | Romania | 0 | 2020-05-11 | 2020-05-17 | 7 | 2020 | 20 | 19659270 | 4870 | 146 | 4610.02837078653 | 259.971629213466 | 4724 | 0.742652194104867 | 1.32238699205752 | 0.0563926310868041 | weekly |
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);