economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where covid_deaths = 23 and year = 2022 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, start_date, end_date, days, week, population, covid_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)
country 18
- United States 17
- Finland 4
- Albania 2
- Bosnia and Herzegovina 2
- Colombia 2
- Cyprus 2
- Czech Republic 2
- Hong Kong 2
- Hungary 2
- Iran 2
- Montenegro 2
- Netherlands 2
- New Zealand 2
- North Macedonia 2
- Norway 2
- Romania 2
- Slovenia 2
- South Africa 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15928 | 15928 | New Zealand | New Zealand | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 5185289 | 599 | 23 | 651.612078651666 | -52.6120786516656 | 576 | 0.44356254781556 | -1.01464120228719 | -0.0807414109949165 | weekly | |||||||||
20259 | 20259 | New Zealand | New Zealand | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 5185289 | 599 | 23 | 651.612078651666 | -52.6120786516656 | 576 | 0.44356254781556 | -1.01464120228719 | -0.0807414109949158 | weekly | |||||||||
4709 | 4709 | United States | Iowa | IA | 2022-11-20 | 2022-11-26 | 7 | 2022 | 47 | 3155070 | 613 | 23 | 622.796992481683 | -9.79699248168299 | 590 | 0.728985410783279 | -0.310515851682625 | -0.0157306355039457 | weekly | |||||||||
2580 | 2580 | United States | Alaska | AK | 2022-11-13 | 2022-11-19 | 7 | 2022 | 46 | 731545 | 84 | 23 | 95.8170426113639 | -11.8170426113639 | 61 | 3.14403078416229 | -1.61535416295154 | -0.123329235481563 | weekly | |||||||||
16679 | 16679 | Romania | Romania | 0 | 2022-10-24 | 2022-10-30 | 7 | 2022 | 43 | 19659270 | 4371 | 23 | 4877.38061797753 | -506.380617977531 | 4348 | 0.116993153865835 | -2.57578545885748 | -0.103822247562772 | weekly | |||||||||
23610 | 23610 | Romania | Romania | 0 | 2022-10-24 | 2022-10-30 | 7 | 2022 | 43 | 19659270 | 4371 | 23 | 4877.38061797753 | -506.380617977531 | 4348 | 0.116993153865835 | -2.57578545885748 | -0.103822247562772 | weekly | |||||||||
777 | 777 | Norway | Norway | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 5434324 | 813 | 23 | 720.462640449453 | 92.5373595505472 | 790 | 0.423235714322517 | 1.70283110743024 | 0.128441579556185 | weekly | |||||||||
16073 | 16073 | Norway | Norway | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 5434324 | 813 | 23 | 720.462640449453 | 92.5373595505472 | 790 | 0.423235714322517 | 1.70283110743024 | 0.128441579556184 | weekly | |||||||||
2092 | 2092 | Colombia | Colombia | 0 | 2022-09-19 | 2022-09-25 | 7 | 2022 | 38 | 51874028 | 4876 | 23 | 4936.22977528073 | -60.2297752807299 | 4853 | 0.044338180177564 | -0.1161077664544 | -0.0122015744855201 | weekly | |||||||||
12357 | 12357 | Colombia | Colombia | 0 | 2022-09-19 | 2022-09-25 | 7 | 2022 | 38 | 51874028 | 4876 | 23 | 4936.22977528073 | -60.2297752807299 | 4853 | 0.044338180177564 | -0.1161077664544 | -0.0122015744855201 | weekly | |||||||||
19462 | 19462 | South Africa | South Africa | 0 | 2022-09-19 | 2022-09-25 | 7 | 2022 | 38 | 59893884 | 10205 | 23 | 10049.033898305 | 155.966101695034 | 10182 | 0.0384012497837008 | 0.26040405343396 | 0.0155205070729576 | weekly | |||||||||
3180 | 3180 | United States | Colorado | CO | 2022-09-18 | 2022-09-24 | 7 | 2022 | 38 | 5758736 | 870 | 23 | 783.954887219021 | 86.0451127809789 | 847 | 0.399393200174483 | 1.49416665012911 | 0.1097577350225 | weekly | |||||||||
17119 | 17119 | South Africa | South Africa | 0 | 2022-09-18 | 2022-09-24 | 7 | 2022 | 38 | 59893884 | 10205 | 23 | 10040.3765690375 | 164.623430962463 | 10182 | 0.0384012497837008 | 0.274858499679972 | 0.0163961411039268 | weekly | |||||||||
3177 | 3177 | United States | Colorado | CO | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 5758736 | 841 | 23 | 759.621553885647 | 81.3784461143526 | 818 | 0.399393200174483 | 1.41313034864513 | 0.10713024886943 | weekly | |||||||||
3175 | 3175 | United States | Colorado | CO | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 5758736 | 805 | 23 | 756.621553885678 | 48.3784461143223 | 782 | 0.399393200174483 | 0.840087931002954 | 0.0639400845321836 | weekly | |||||||||
285 | 285 | Slovenia | Slovenia | 0 | 2022-08-01 | 2022-08-07 | 7 | 2022 | 31 | 2119843 | 416 | 23 | 370.681741573014 | 45.3182584269857 | 393 | 1.08498601075646 | 2.13781201848371 | 0.122256516424776 | weekly | |||||||||
16961 | 16961 | Slovenia | Slovenia | 0 | 2022-08-01 | 2022-08-07 | 7 | 2022 | 31 | 2119843 | 416 | 23 | 370.681741573014 | 45.3182584269857 | 393 | 1.08498601075646 | 2.13781201848371 | 0.122256516424777 | weekly | |||||||||
9861 | 9861 | United States | Wisconsin | WI | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 5822434 | 1052 | 23 | 985.49373433666 | 66.5062656633401 | 1029 | 0.395023799325162 | 1.1422416409244 | 0.0674852242547292 | weekly | |||||||||
4084 | 4084 | United States | Hawaii | HI | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 1415872 | 236 | 23 | 233.395989975776 | 2.6040100242239 | 213 | 1.62444062740135 | 0.183915638152594 | 0.0111570469762319 | weekly | |||||||||
4692 | 4692 | United States | Iowa | IA | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 3155070 | 595 | 23 | 557.796992481691 | 37.2030075183088 | 572 | 0.728985410783279 | 1.17914998774382 | 0.0666963214570038 | weekly | |||||||||
4235 | 4235 | United States | Idaho | ID | 2022-07-17 | 2022-07-23 | 7 | 2022 | 29 | 1787065 | 343 | 23 | 261.39598997561 | 81.6040100243904 | 320 | 1.28702649316057 | 4.56637055867528 | 0.312185393632109 | weekly | |||||||||
10162 | 10162 | Czech Republic | Czech Republic | 0 | 2022-07-11 | 2022-07-17 | 7 | 2022 | 28 | 10493990 | 1950 | 23 | 2036.96769662921 | -86.9676966292136 | 1927 | 0.219173069537897 | -0.828738131341974 | -0.0426946862108458 | weekly | |||||||||
12795 | 12795 | Czech Republic | Czech Republic | 0 | 2022-07-11 | 2022-07-17 | 7 | 2022 | 28 | 10493990 | 1950 | 23 | 2036.96769662921 | -86.9676966292136 | 1927 | 0.219173069537897 | -0.828738131341974 | -0.042694686210844 | weekly | |||||||||
2865 | 2865 | United States | Arkansas | AR | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 3017825 | 702 | 23 | 598.909774437903 | 103.090225562097 | 679 | 0.762138294964088 | 3.41604385814607 | 0.172129809801235 | weekly | |||||||||
629 | 629 | Hong Kong | Hong Kong | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 7488863 | 3496 | 23 | 3931.40049555358 | -435.400495553581 | 3473 | 0.307122723436121 | -5.81397330347185 | -0.110749463466268 | monthly | 6 | 815.733333333333 | 5.36666666666667 | 917.326782295836 | -101.593448962502 | 810.366666666667 | 0.0716619688017616 | -1.3565937708101 | ||
21999 | 21999 | Hong Kong | Hong Kong | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 7488863 | 3496 | 23 | 3931.40049555358 | -435.400495553581 | 3473 | 0.307122723436121 | -5.81397330347185 | -0.110749463466268 | monthly | 6 | 815.733333333333 | 5.36666666666667 | 917.326782295836 | -101.593448962502 | 810.366666666667 | 0.0716619688017616 | -1.3565937708101 | ||
10373 | 10373 | Hungary | Hungary | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 9967304 | 2071 | 23 | 2239.83286516853 | -168.832865168532 | 2048 | 0.230754474830907 | -1.69386691896357 | -0.0753774390018288 | weekly | |||||||||
14132 | 14132 | Hungary | Hungary | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 9967304 | 2071 | 23 | 2239.83286516853 | -168.832865168532 | 2048 | 0.230754474830907 | -1.69386691896356 | -0.0753774390018278 | weekly | |||||||||
14428 | 14428 | Iran | Iran | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 88550568 | 7712.1 | 23 | 7009.45558988748 | 702.644410112524 | 7689.1 | 0.025973859365871 | 0.793495090977309 | 0.100242365630538 | weekly | |||||||||
24344 | 24344 | Iran | Iran | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 88550568 | 7712.1 | 23 | 7009.45558988748 | 702.644410112524 | 7689.1 | 0.025973859365871 | 0.79349509097731 | 0.100242365630539 | weekly | |||||||||
6356 | 6356 | United States | Montana | MT | 2022-05-29 | 2022-06-04 | 7 | 2022 | 22 | 1068778 | 192 | 23 | 178.847117795268 | 13.1528822047324 | 169 | 2.15199040399409 | 1.23064679519342 | 0.0735426008921705 | weekly | |||||||||
20611 | 20611 | North Macedonia | North Macedonia | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 2093606 | 1509 | 23 | 1566.28165936874 | -57.2816593687371 | 1486 | 1.09858301896345 | -2.73602862089319 | -0.036571748782287 | monthly | 5 | 340.741935483871 | 5.19354838709677 | 353.676503728425 | -12.9345682445535 | 335.548387096774 | 0.248067133314328 | -0.617812914395237 | ||
21662 | 21662 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 3233530 | 3000 | 23 | 2888.82801952204 | 111.17198047796 | 2977 | 0.71129694173241 | 3.43809955305688 | 0.0384834194790016 | monthly | 5 | 677.41935483871 | 5.19354838709677 | 652.316004408203 | 25.1033504305072 | 672.225806451613 | 0.160615438455706 | 0.776345060367685 | ||
22546 | 22546 | North Macedonia | North Macedonia | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 2093606 | 1509 | 23 | 1566.28165936874 | -57.2816593687371 | 1486 | 1.09858301896345 | -2.73602862089319 | -0.0365717487822889 | monthly | 5 | 340.741935483871 | 5.19354838709677 | 353.676503728425 | -12.9345682445535 | 335.548387096774 | 0.248067133314328 | -0.617812914395237 | ||
24555 | 24555 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 3233530 | 3000 | 23 | 2888.82801952204 | 111.17198047796 | 2977 | 0.71129694173241 | 3.43809955305689 | 0.0384834194790018 | monthly | 5 | 677.41935483871 | 5.19354838709677 | 652.316004408203 | 25.1033504305072 | 672.225806451613 | 0.160615438455706 | 0.776345060367685 | ||
15744 | 15744 | Netherlands | Netherlands | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 17564020 | 3128 | 23 | 2823.67331460673 | 304.326685393273 | 3105 | 0.13094952066782 | 1.7326710251598 | 0.107776874831448 | weekly | |||||||||
23791 | 23791 | Netherlands | Netherlands | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 17564020 | 3128 | 23 | 2823.67331460673 | 304.326685393273 | 3105 | 0.13094952066782 | 1.7326710251598 | 0.107776874831449 | weekly | |||||||||
8783 | 8783 | United States | Tennessee | TN | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 6833174 | 1498 | 23 | 1526.7218045122 | -28.7218045122038 | 1475 | 0.336593214222263 | -0.420328891262008 | -0.018812729619317 | weekly | |||||||||
3461 | 3461 | United States | Delaware | DE | 2022-04-10 | 2022-04-16 | 7 | 2022 | 15 | 973764 | 195 | 23 | 181.421052636207 | 13.5789473637926 | 172 | 2.36196860841025 | 1.39448032211014 | 0.0748476936192273 | weekly | |||||||||
4829 | 4829 | United States | Kansas | KS | 2022-04-10 | 2022-04-16 | 7 | 2022 | 15 | 2913314 | 540 | 23 | 523.78696741919 | 16.2130325808099 | 517 | 0.78947892331551 | 0.556515108938134 | 0.0309534860340168 | weekly | |||||||||
11173 | 11173 | Albania | Albania | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 2842318 | 1892 | 23 | 1936.88391260719 | -44.8839126071937 | 1869 | 0.809198689238854 | -1.57913057607184 | -0.0231732590244794 | monthly | 3 | 427.225806451613 | 5.19354838709677 | 437.360883491947 | -10.1350770403341 | 422.032258064516 | 0.182722284666838 | -0.356577872016222 | ||
21333 | 21333 | Albania | Albania | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 2842318 | 1892 | 23 | 1936.88391260719 | -44.8839126071937 | 1869 | 0.809198689238854 | -1.57913057607184 | -0.0231732590244776 | monthly | 3 | 427.225806451613 | 5.19354838709677 | 437.360883491947 | -10.1350770403341 | 422.032258064516 | 0.182722284666838 | -0.356577872016222 | ||
4824 | 4824 | United States | Kansas | KS | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 2913314 | 589 | 23 | 578.453634085867 | 10.5463659141332 | 566 | 0.78947892331551 | 0.362005808990489 | 0.0182319987163702 | weekly | |||||||||
114 | 114 | Finland | Finland | 0 | 2022-02-28 | 2022-03-06 | 7 | 2022 | 9 | 5540745 | 1245 | 23 | 1140.02022471906 | 104.979775280935 | 1222 | 0.415106632772308 | 1.89468700113316 | 0.0920858884822027 | weekly | |||||||||
911 | 911 | Cyprus | Cyprus | 0 | 2022-02-28 | 2022-03-06 | 7 | 2022 | 9 | 896007 | 149 | 23 | 145.905337078645 | 3.09466292135505 | 126 | 2.56694423146248 | 0.345383788447529 | 0.0212100734854339 | weekly | |||||||||
12627 | 12627 | Cyprus | Cyprus | 0 | 2022-02-28 | 2022-03-06 | 7 | 2022 | 9 | 896007 | 149 | 23 | 145.905337078645 | 3.09466292135505 | 126 | 2.56694423146248 | 0.345383788447529 | 0.0212100734854335 | weekly | |||||||||
13382 | 13382 | Finland | Finland | 0 | 2022-02-28 | 2022-03-06 | 7 | 2022 | 9 | 5540745 | 1245 | 23 | 1140.02022471906 | 104.979775280935 | 1222 | 0.415106632772308 | 1.89468700113315 | 0.0920858884822071 | weekly | |||||||||
9991 | 9991 | United States | Wyoming | WY | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 578759 | 102 | 23 | 103.486842106138 | -1.48684210613798 | 79 | 3.97402027441474 | -0.256901768462864 | -0.0143674507394191 | weekly | |||||||||
15595 | 15595 | Montenegro | Montenegro | 0 | 2022-02-14 | 2022-02-20 | 7 | 2022 | 7 | 627082 | 169 | 23 | 129.837734082397 | 39.1622659176028 | 146 | 3.66778188498474 | 6.24515867424082 | 0.30162468710945 | weekly | |||||||||
18738 | 18738 | Montenegro | Montenegro | 0 | 2022-02-14 | 2022-02-20 | 7 | 2022 | 7 | 627082 | 169 | 23 | 129.837734082397 | 39.1622659176028 | 146 | 3.66778188498474 | 6.24515867424081 | 0.301624687109448 | weekly | |||||||||
108 | 108 | Finland | Finland | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 5540745 | 1403 | 23 | 1171.67153558049 | 231.32846441951 | 1380 | 0.415106632772308 | 4.17504260563354 | 0.19743456881446 | weekly | |||||||||
13376 | 13376 | Finland | Finland | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 5540745 | 1403 | 23 | 1171.67153558049 | 231.32846441951 | 1380 | 0.415106632772308 | 4.17504260563354 | 0.19743456881446 | weekly | |||||||||
7553 | 7553 | United States | North Dakota | ND | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 762062 | 169 | 23 | 168.789473685096 | 0.210526314903575 | 146 | 3.01812713401272 | 0.0276258775406168 | 0.00124727158813442 | 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);