economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
42 rows where covid_deaths = 140 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, start_date, end_date, days, year, week, population, total_deaths, expected_deaths, excess_deaths, non_covid_deaths, 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, start_date (date), end_date (date)
country 14
- United States 13
- Portugal 4
- Sweden 4
- Belgium 2
- Dominican Republic 2
- Germany 2
- Hungary 2
- Iran 2
- Ireland 2
- Israel 2
- Mexico 2
- Serbia 2
- Switzerland 2
- Canada 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10392 | 10392 | Hungary | Hungary | 0 | 2022-10-24 | 2022-10-30 | 7 | 2022 | 43 | 9967304 | 2478 | 140 | 2361.03286516853 | 116.967134831468 | 2338 | 1.40459245549248 | 1.1735082508918 | 0.0495406635617159 | weekly | |||||||||
14151 | 14151 | Hungary | Hungary | 0 | 2022-10-24 | 2022-10-30 | 7 | 2022 | 43 | 9967304 | 2478 | 140 | 2361.03286516853 | 116.967134831468 | 2338 | 1.40459245549248 | 1.1735082508918 | 0.0495406635617166 | weekly | |||||||||
8200 | 8200 | United States | Pennsylvania | PA | 2022-10-16 | 2022-10-22 | 7 | 2022 | 42 | 12801989 | 2755 | 140 | 2497.23809523923 | 257.761904760767 | 2615 | 1.09358006790976 | 2.01345200937735 | 0.103218794095832 | weekly | |||||||||
10570 | 10570 | Mexico | Mexico | 0 | 2022-09-05 | 2022-09-11 | 7 | 2022 | 36 | 127504120 | 13204 | 140 | 14348.2882022464 | -1144.28820224645 | 13064 | 0.109800373509499 | -0.897451942922667 | -0.0797508515383245 | weekly | |||||||||
15478 | 15478 | Mexico | Mexico | 0 | 2022-09-05 | 2022-09-11 | 7 | 2022 | 36 | 127504120 | 13204 | 140 | 14348.2882022464 | -1144.28820224645 | 13064 | 0.109800373509499 | -0.897451942922668 | -0.0797508515383213 | weekly | |||||||||
3937 | 3937 | United States | Georgia | GA | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 10617423 | 1789 | 140 | 1638.06015037645 | 150.939849623546 | 1649 | 1.31858738226781 | 1.42162415139292 | 0.0921454865920877 | weekly | |||||||||
569 | 569 | Portugal | Portugal | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 10270857 | 2219 | 140 | 2022.40983146069 | 196.590168539306 | 2079 | 1.36308002340993 | 1.91405808239085 | 0.0972059003477641 | weekly | |||||||||
16501 | 16501 | Portugal | Portugal | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 10270857 | 2219 | 140 | 2022.40983146069 | 196.590168539306 | 2079 | 1.36308002340993 | 1.91405808239085 | 0.0972059003477661 | weekly | |||||||||
11590 | 11590 | Belgium | Belgium | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 11655923 | 2506 | 140 | 2191.99382022478 | 314.006179775222 | 2366 | 1.20110608143173 | 2.69396237239404 | 0.143251398283148 | weekly | |||||||||
20414 | 20414 | Belgium | Belgium | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 11655923 | 2506 | 140 | 2191.99382022478 | 314.006179775222 | 2366 | 1.20110608143173 | 2.69396237239403 | 0.143251398283149 | weekly | |||||||||
4825 | 4825 | United States | Kansas | KS | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 2913314 | 581 | 140 | 567.786967419198 | 13.2130325808016 | 441 | 4.80552388105093 | 0.453539597201044 | 0.0232711093050615 | weekly | |||||||||
6171 | 6171 | United States | Missouri | MO | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 6137428 | 1479 | 140 | 1147.25689223136 | 331.743107768643 | 1339 | 2.28108582292126 | 5.40524642844923 | 0.28916200897553 | weekly | |||||||||
7843 | 7843 | United States | Oklahoma | OK | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 3956971 | 964 | 140 | 701.065162907995 | 262.934837092005 | 824 | 3.53805979371595 | 6.64485125344626 | 0.375050496021454 | weekly | |||||||||
4191 | 4191 | United States | Idaho | ID | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 1787065 | 465 | 140 | 266.463659148656 | 198.536340851344 | 325 | 7.8340743061948 | 11.1096317622103 | 0.745078490198857 | weekly | |||||||||
7990 | 7990 | United States | Oregon | OR | 2021-09-05 | 2021-09-11 | 7 | 2021 | 36 | 4217737 | 1013 | 140 | 658.082706767813 | 354.917293232187 | 873 | 3.31931554765032 | 8.41487492539688 | 0.539320194228124 | weekly | |||||||||
13654 | 13654 | Germany | Germany | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 83369840 | 17151 | 140 | 16596.9123595502 | 554.08764044979 | 17011 | 0.167926434787448 | 0.664614014432305 | 0.0333849832092996 | weekly | |||||||||
23397 | 23397 | Germany | Germany | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 83369840 | 17151 | 140 | 16596.9123595502 | 554.08764044979 | 17011 | 0.167926434787448 | 0.664614014432306 | 0.0333849832092989 | weekly | |||||||||
6010 | 6010 | United States | Mississippi | MS | 2021-08-08 | 2021-08-14 | 7 | 2021 | 32 | 2976149 | 934 | 140 | 594.602756892961 | 339.397243107039 | 794 | 4.70406555585759 | 11.4039062932346 | 0.570796618704774 | weekly | |||||||||
12002 | 12002 | Canada | Canada | 0 | 2021-06-13 | 2021-06-19 | 7 | 2021 | 24 | 38454328 | 5420 | 140 | 5340.17614424422 | 79.8238557557779 | 5280 | 0.364068252603452 | 0.207580940579115 | 0.0149477945295524 | weekly | |||||||||
17478 | 17478 | Sweden | Sweden | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 10549349 | 1770.2 | 140 | 1802.14505617977 | -31.9450561797655 | 1630.2 | 1.32709610801576 | -0.302815426617941 | -0.0177261292426082 | weekly | |||||||||
24624 | 24624 | Sweden | Sweden | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 10549349 | 1770.2 | 140 | 1802.14505617977 | -31.9450561797655 | 1630.2 | 1.32709610801576 | -0.302815426617941 | -0.0177261292426057 | weekly | |||||||||
9018 | 9018 | United States | Utah | UT | 2020-12-27 | 2021-01-02 | 7 | 2020 | 53 | 3205958 | 486 | 140 | 404.441102757711 | 81.558897242289 | 346 | 4.36686943497076 | 2.54397896798052 | 0.20165828024445 | weekly | |||||||||
7496 | 7496 | United States | North Dakota | ND | 2020-12-13 | 2020-12-19 | 7 | 2020 | 51 | 762062 | 200 | 140 | 153.117794487088 | 46.8822055129117 | 60 | 18.3712086418165 | 6.15201985047301 | 0.306183913306464 | weekly | |||||||||
11123 | 11123 | Ireland | Ireland | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 5023108 | 2548 | 140 | 2548.87993272948 | -0.879932729483698 | 2408 | 2.78711905059577 | -0.0175176948113339 | -0.000345223295214803 | monthly | 11 | 594.533333333333 | 32.6666666666667 | 594.738650970213 | -0.20531763687953 | 561.866666666667 | 0.650327778472346 | -0.00408746212264458 | ||
22013 | 22013 | Ireland | Ireland | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 5023108 | 2548 | 140 | 2548.87993272948 | -0.879932729483698 | 2408 | 2.78711905059577 | -0.0175176948113339 | -0.000345223295213359 | monthly | 11 | 594.533333333333 | 32.6666666666667 | 594.738650970213 | -0.20531763687953 | 561.866666666667 | 0.650327778472346 | -0.00408746212264458 | ||
14490 | 14490 | Israel | Israel | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 9449000 | 933 | 140 | 850.681741572992 | 82.3182584270085 | 793 | 1.48163826859985 | 0.871184870642486 | 0.0967673977283134 | weekly | |||||||||
20659 | 20659 | Israel | Israel | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 9449000 | 933 | 140 | 850.681741572992 | 82.3182584270085 | 793 | 1.48163826859985 | 0.871184870642486 | 0.0967673977283139 | weekly | |||||||||
8401 | 8401 | United States | South Carolina | SC | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 5148714 | 1225 | 140 | 985.471177945827 | 239.528822054173 | 1085 | 2.71912559136126 | 4.65220678511514 | 0.243060200455036 | weekly | |||||||||
10643 | 10643 | Dominican Republic | Dominican Republic | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 11228821 | 3562 | 140 | 3802.15528644407 | -240.15528644407 | 3422 | 1.2467916266543 | -2.13874000168023 | -0.0631629347965618 | monthly | 10 | 804.322580645161 | 31.6129032258065 | 858.551193713177 | -54.2286130680157 | 772.709677419355 | 0.281533593115488 | -0.482941290701987 | ||
21782 | 21782 | Dominican Republic | Dominican Republic | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 11228821 | 3562 | 140 | 3802.15528644407 | -240.15528644407 | 3422 | 1.2467916266543 | -2.13874000168023 | -0.0631629347965619 | monthly | 10 | 804.322580645161 | 31.6129032258065 | 858.551193713177 | -54.2286130680157 | 772.709677419355 | 0.281533593115488 | -0.482941290701987 | ||
17606 | 17606 | Switzerland | Switzerland | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 8740471 | 1492 | 140 | 1238.95393258426 | 253.046067415738 | 1352 | 1.60174434535622 | 2.89510791141276 | 0.204241708073783 | weekly | |||||||||
23158 | 23158 | Switzerland | Switzerland | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 8740471 | 1492 | 140 | 1238.95393258426 | 253.046067415738 | 1352 | 1.60174434535622 | 2.89510791141275 | 0.204241708073781 | weekly | |||||||||
10218 | 10218 | Serbia | Serbia | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 6871547 | 8626 | 140 | 7698.1095447911 | 927.890455208903 | 8486 | 2.03738692320667 | 13.5033705686493 | 0.120534846875069 | monthly | 8 | 1947.8064516129 | 31.6129032258065 | 1738.2828004367 | 209.523651176204 | 1916.1935483871 | 0.460055111691828 | 3.04914819292081 | ||
22848 | 22848 | Serbia | Serbia | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 6871547 | 8626 | 140 | 7698.1095447911 | 927.890455208903 | 8486 | 2.03738692320667 | 13.5033705686493 | 0.120534846875069 | monthly | 8 | 1947.8064516129 | 31.6129032258065 | 1738.2828004367 | 209.523651176204 | 1916.1935483871 | 0.460055111691828 | 3.04914819292081 | ||
2312 | 2312 | United States | Alabama | AL | 2020-08-23 | 2020-08-29 | 7 | 2020 | 35 | 4903185 | 1216 | 140 | 963.358395984306 | 252.641604015694 | 1076 | 2.85528692064444 | 5.15260191111888 | 0.262250897556728 | weekly | |||||||||
17440 | 17440 | Sweden | Sweden | 0 | 2020-06-29 | 2020-07-05 | 7 | 2020 | 27 | 10549349 | 1619.8 | 140 | 1592.19879213483 | 27.6012078651672 | 1479.8 | 1.32709610801576 | 0.261638968102839 | 0.0173352774801205 | weekly | |||||||||
24586 | 24586 | Sweden | Sweden | 0 | 2020-06-29 | 2020-07-05 | 7 | 2020 | 27 | 10549349 | 1619.8 | 140 | 1592.19879213483 | 27.6012078651672 | 1479.8 | 1.32709610801576 | 0.26163896810284 | 0.0173352774801188 | weekly | |||||||||
5496 | 5496 | United States | Massachusetts | MA | 2020-06-28 | 2020-07-04 | 7 | 2020 | 27 | 6949503 | 1048 | 140 | 1104.12531328401 | -56.12531328401 | 908 | 2.01453255002552 | -0.807616217792984 | -0.0508323761884201 | weekly | |||||||||
464 | 464 | Portugal | Portugal | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 10270857 | 2174 | 140 | 2003.6058988764 | 170.394101123601 | 2034 | 1.36308002340993 | 1.65900568106051 | 0.0850437210327419 | weekly | |||||||||
16396 | 16396 | Portugal | Portugal | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 10270857 | 2174 | 140 | 2003.6058988764 | 170.394101123601 | 2034 | 1.36308002340993 | 1.65900568106051 | 0.0850437210327415 | weekly | |||||||||
14312 | 14312 | Iran | Iran | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 88550568 | 8737 | 140 | 7650.8493539323 | 1086.1506460677 | 8597 | 0.158101752661824 | 1.22658800570054 | 0.141964714742351 | weekly | |||||||||
24228 | 24228 | Iran | Iran | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 88550568 | 8737 | 140 | 7650.8493539323 | 1086.1506460677 | 8597 | 0.158101752661824 | 1.22658800570054 | 0.141964714742351 | 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);