economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
426 rows where week = 4 sorted by population descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, start_date (date), end_date (date)
country >30
- United States 159
- Australia 6
- Austria 6
- Belgium 6
- Britain 6
- Bulgaria 6
- Canada 6
- Chile 6
- Colombia 6
- Croatia 6
- Cyprus 6
- Czech Republic 6
- Denmark 6
- Ecuador 6
- Estonia 6
- Finland 6
- France 6
- Germany 6
- Greece 6
- Guatemala 6
- Hungary 6
- Iceland 6
- Iran 6
- Israel 6
- Italy 6
- Latvia 6
- Lithuania 6
- Luxembourg 6
- Malta 6
- Mexico 6
- …
cadence 1
- weekly 426
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2129 | 2129 | United States | United States | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 338289856 | 59164 | 0 | 60353.890536722 | -1189.89053672198 | 59164 | 0.0 | -0.351736984014674 | -0.0197152250855809 | weekly | |||||||||
2182 | 2182 | United States | United States | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 338289856 | 79223 | 21983 | 61063.3134180783 | 18159.6865819217 | 57240 | 6.49827348059766 | 5.36808487154923 | 0.297391110396989 | weekly | |||||||||
2234 | 2234 | United States | United States | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 338289856 | 85055 | 17610 | 61772.7362994347 | 23282.2637005653 | 67445 | 5.20559505041736 | 6.88234166281513 | 0.37690193271847 | weekly | |||||||||
17776 | 17776 | United States | United States | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 338289856 | 59164 | 0 | 60353.890536722 | -1189.89053672198 | 59164 | 0.0 | -0.351736984014673 | -0.0197152250855811 | weekly | |||||||||
17829 | 17829 | United States | United States | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 338289856 | 79223 | 21983 | 61063.3134180783 | 18159.6865819217 | 57240 | 6.49827348059766 | 5.36808487154924 | 0.29739111039699 | weekly | |||||||||
17881 | 17881 | United States | United States | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 338289856 | 85055 | 17610 | 61772.7362994347 | 23282.2637005653 | 67445 | 5.20559505041736 | 6.88234166281513 | 0.37690193271847 | weekly | |||||||||
10433 | 10433 | Mexico | Mexico | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 127504120 | 15814 | 0 | 16083.1774344559 | -269.177434455894 | 15814 | 0.0 | -0.211112734597042 | -0.0167365830261389 | weekly | |||||||||
10486 | 10486 | Mexico | Mexico | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 127504120 | 37017 | 8922 | 16455.7150749054 | 20561.2849250946 | 28095 | 6.99742094608394 | 16.1259768900759 | 1.249492035533 | weekly | |||||||||
10538 | 10538 | Mexico | Mexico | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 127504120 | 33055 | 2710 | 16828.252715355 | 16226.747284645 | 30345 | 2.12542151579102 | 12.7264493764162 | 0.964256215967023 | weekly | |||||||||
15341 | 15341 | Mexico | Mexico | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 127504120 | 15814 | 0 | 16083.1774344559 | -269.177434455894 | 15814 | 0.0 | -0.211112734597042 | -0.0167365830261392 | weekly | |||||||||
15394 | 15394 | Mexico | Mexico | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 127504120 | 37017 | 8922 | 16455.7150749054 | 20561.2849250946 | 28095 | 6.99742094608394 | 16.1259768900759 | 1.249492035533 | weekly | |||||||||
15446 | 15446 | Mexico | Mexico | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 127504120 | 33055 | 2710 | 16828.252715355 | 16226.747284645 | 30345 | 2.12542151579102 | 12.7264493764162 | 0.964256215967023 | weekly | |||||||||
14306 | 14306 | Iran | Iran | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 88550568 | 7509.4 | 0 | 8025.19112827684 | -515.791128276838 | 7509.4 | 0.0 | -0.582482009914197 | -0.0642715070622362 | weekly | |||||||||
14359 | 14359 | Iran | Iran | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 88550568 | 8933.9 | 576 | 8140.0942462544 | 793.805753745599 | 8357.9 | 0.650475782380075 | 0.89644343528728 | 0.0975180052873299 | weekly | |||||||||
14411 | 14411 | Iran | Iran | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 88550568 | 8549 | 194 | 8254.99736423201 | 294.002635767985 | 8355 | 0.219083857259956 | 0.332016657157959 | 0.0356151095870572 | weekly | |||||||||
24222 | 24222 | Iran | Iran | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 88550568 | 7509.4 | 0 | 8025.19112827684 | -515.791128276838 | 7509.4 | 0.0 | -0.582482009914198 | -0.0642715070622359 | weekly | |||||||||
24275 | 24275 | Iran | Iran | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 88550568 | 8933.9 | 576 | 8140.0942462544 | 793.805753745599 | 8357.9 | 0.650475782380075 | 0.89644343528728 | 0.0975180052873297 | weekly | |||||||||
24327 | 24327 | Iran | Iran | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 88550568 | 8549 | 194 | 8254.99736423201 | 294.002635767985 | 8355 | 0.219083857259956 | 0.332016657157959 | 0.0356151095870565 | weekly | |||||||||
13571 | 13571 | Germany | Germany | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 83369840 | 18827 | 0 | 19837.6952247188 | -1010.69522471877 | 18827 | 0.0 | -1.21230318388373 | -0.0509482181911647 | weekly | |||||||||
13624 | 13624 | Germany | Germany | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 83369840 | 22674 | 5075 | 19930.1733146064 | 2743.82668539359 | 17599 | 6.087333261045 | 3.29115023537719 | 0.137671993217576 | weekly | |||||||||
13676 | 13676 | Germany | Germany | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 83369840 | 20187 | 999 | 20022.651404494 | 164.348595505951 | 19188 | 1.19827505966186 | 0.197131955040277 | 0.00820813348771132 | weekly | |||||||||
23314 | 23314 | Germany | Germany | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 83369840 | 18827 | 0 | 19837.6952247188 | -1010.69522471877 | 18827 | 0.0 | -1.21230318388372 | -0.0509482181911631 | weekly | |||||||||
23367 | 23367 | Germany | Germany | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 83369840 | 22674 | 5075 | 19930.1733146064 | 2743.82668539359 | 17599 | 6.087333261045 | 3.2911502353772 | 0.137671993217575 | weekly | |||||||||
23419 | 23419 | Germany | Germany | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 83369840 | 20187 | 999 | 20022.651404494 | 164.348595505951 | 19188 | 1.19827505966186 | 0.197131955040278 | 0.0082081334877091 | weekly | |||||||||
13421 | 13421 | France | France | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 67813000 | 12331 | 0 | 13108.2984550559 | -777.29845505589 | 12331 | 0.0 | -1.14623811814238 | -0.059298196308316 | weekly | |||||||||
13474 | 13474 | France | France | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 67813000 | 14786 | 3008 | 13172.6178370783 | 1613.38216292167 | 11778 | 4.43572766283751 | 2.37916352752668 | 0.122479994703889 | weekly | |||||||||
13526 | 13526 | France | France | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 67813000 | 15072 | 1955 | 13236.9372191008 | 1835.06278089923 | 13117 | 2.88292805214339 | 2.70606341099676 | 0.138631977361894 | weekly | |||||||||
19960 | 19960 | France | France | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 67813000 | 12331 | 0 | 13108.2984550559 | -777.29845505589 | 12331 | 0.0 | -1.14623811814238 | -0.0592981963083153 | weekly | |||||||||
20013 | 20013 | France | France | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 67813000 | 14786 | 3008 | 13172.6178370783 | 1613.38216292167 | 11778 | 4.43572766283751 | 2.37916352752668 | 0.122479994703886 | weekly | |||||||||
20065 | 20065 | France | France | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 67813000 | 15072 | 1955 | 13236.9372191008 | 1835.06278089923 | 13117 | 2.88292805214339 | 2.70606341099675 | 0.138631977361897 | weekly | |||||||||
11627 | 11627 | Britain | Britain | 0 | 2020-01-18 | 2020-01-24 | 7 | 2020 | 4 | 67508936 | 13426 | 0 | 14273.6888580678 | -847.688858067788 | 13426 | 0.0 | -1.25566911329752 | -0.0593882118698887 | weekly | |||||||||
11680 | 11680 | Britain | Britain | 0 | 2021-01-23 | 2021-01-29 | 7 | 2021 | 4 | 67508936 | 20489 | 8578 | 14269.6977346282 | 6219.30226537176 | 11911 | 12.7064660002937 | 9.21256152722028 | 0.435839804110178 | weekly | |||||||||
11732 | 11732 | Britain | Britain | 0 | 2022-01-22 | 2022-01-28 | 7 | 2022 | 4 | 67508936 | 13998 | 1475 | 14265.7066111887 | -267.7066111887 | 12523 | 2.18489593733191 | -0.39654988961565 | -0.0187657449073525 | weekly | |||||||||
24035 | 24035 | Britain | Britain | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 67508936 | 13426 | 0 | 14277.1926498125 | -851.192649812459 | 13426 | 0.0 | -1.26085922878781 | -0.0596190491149281 | weekly | |||||||||
24088 | 24088 | Britain | Britain | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 67508936 | 20489 | 8072 | 14274.6030430708 | 6214.39695692923 | 12417 | 11.9569355973852 | 9.20529536553387 | 0.435346393744087 | weekly | |||||||||
24140 | 24140 | Britain | Britain | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 67508936 | 13998 | 1408 | 14272.0134363291 | -274.013436329087 | 12590 | 2.0856498167887 | -0.405892097498155 | -0.0191993538649279 | weekly | |||||||||
16980 | 16980 | South Africa | South Africa | 0 | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 59893884 | 8626 | 0 | 8877.52161785216 | -251.521617852159 | 8626 | 0.0 | -0.419945411875708 | -0.0283324140091493 | weekly | |||||||||
17033 | 17033 | South Africa | South Africa | 0 | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 59893884 | 15820 | 3377 | 8844.79693165964 | 6975.20306834036 | 12443 | 5.63830523998076 | 11.6459354486684 | 0.788622183441303 | weekly | |||||||||
17085 | 17085 | South Africa | South Africa | 0 | 2022-01-23 | 2022-01-29 | 7 | 2022 | 4 | 59893884 | 9837 | 1070 | 8812.07224546712 | 1024.92775453288 | 8767 | 1.78649292471999 | 1.71123942226368 | 0.116309504278077 | weekly | |||||||||
19323 | 19323 | South Africa | South Africa | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 59893884 | 8626 | 0 | 8881.85028248587 | -255.850282485866 | 8626 | 0.0 | -0.427172634998702 | -0.0288059665890088 | weekly | |||||||||
19376 | 19376 | South Africa | South Africa | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 59893884 | 15820 | 3290 | 8850.85706214684 | 6969.14293785316 | 12530 | 5.49304833862503 | 11.6358173362962 | 0.787397524207982 | weekly | |||||||||
19428 | 19428 | South Africa | South Africa | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 59893884 | 9837 | 1073 | 8819.86384180781 | 1017.13615819219 | 8764 | 1.79150178338743 | 1.69823042064226 | 0.115323340182506 | weekly | |||||||||
10827 | 10827 | Italy | Italy | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 59037472 | 13989 | 0 | 14664.8642322099 | -675.864232209873 | 13989 | 0.0 | -1.14480550964288 | -0.0460873160165647 | weekly | |||||||||
10880 | 10880 | Italy | Italy | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 59037472 | 16383 | 3055 | 14607.8765917604 | 1775.12340823959 | 13328 | 5.17467956622533 | 3.0067740844994 | 0.121518236896994 | weekly | |||||||||
10932 | 10932 | Italy | Italy | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 59037472 | 17289 | 2626 | 14550.888951311 | 2738.11104868905 | 14663 | 4.44802243564901 | 4.63792055440492 | 0.188174829582653 | weekly | |||||||||
14600 | 14600 | Italy | Italy | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 59037472 | 13989 | 0 | 14664.8642322099 | -675.864232209873 | 13989 | 0.0 | -1.14480550964288 | -0.0460873160165665 | weekly | |||||||||
14653 | 14653 | Italy | Italy | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 59037472 | 16383 | 3055 | 14607.8765917604 | 1775.12340823959 | 13328 | 5.17467956622533 | 3.0067740844994 | 0.121518236896994 | weekly | |||||||||
14705 | 14705 | Italy | Italy | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 59037472 | 17289 | 2626 | 14550.888951311 | 2738.11104868905 | 14663 | 4.44802243564901 | 4.63792055440492 | 0.188174829582649 | weekly | |||||||||
1953 | 1953 | Colombia | Colombia | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 51874028 | 4793 | 0 | 4780.88155430678 | 12.1184456932215 | 4793 | 0.0 | 0.0233612968964382 | 0.00253477220792142 | weekly | |||||||||
2006 | 2006 | Colombia | Colombia | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 51874028 | 7753 | 2609 | 4900.36750936305 | 2852.63249063695 | 5144 | 5.02949182970715 | 5.49915362392322 | 0.582126235468353 | weekly | |||||||||
2058 | 2058 | Colombia | Colombia | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 51874028 | 8279 | 1839 | 5019.85346441928 | 3259.14653558072 | 6440 | 3.54512666724088 | 6.28280983998528 | 0.649251329482335 | weekly | |||||||||
12218 | 12218 | Colombia | Colombia | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 51874028 | 4793 | 0 | 4780.88155430678 | 12.1184456932215 | 4793 | 0.0 | 0.0233612968964382 | 0.0025347722079212 | weekly | |||||||||
12271 | 12271 | Colombia | Colombia | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 51874028 | 7753 | 2609 | 4900.36750936305 | 2852.63249063695 | 5144 | 5.02949182970715 | 5.49915362392323 | 0.582126235468355 | weekly | |||||||||
12323 | 12323 | Colombia | Colombia | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 51874028 | 8279 | 1839 | 5019.85346441928 | 3259.14653558072 | 6440 | 3.54512666724088 | 6.28280983998528 | 0.649251329482335 | weekly | |||||||||
17134 | 17134 | South Korea | South Korea | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 51815808 | 6490 | 0 | 6365.45154494343 | 124.548455056568 | 6490 | 0.0 | 0.240367679022911 | 0.0195663189291746 | weekly | |||||||||
17187 | 17187 | South Korea | South Korea | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 51815808 | 5838 | 65 | 6475.63216292097 | -637.632162920973 | 5773 | 0.125444343162612 | -1.23057458241503 | -0.0984663963113915 | weekly | |||||||||
17239 | 17239 | South Korea | South Korea | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 51815808 | 6713 | 190 | 6585.81278089851 | 127.187219101485 | 6523 | 0.366683464629173 | 0.245460263982538 | 0.0193123040895398 | weekly | |||||||||
20451 | 20451 | South Korea | South Korea | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 51815808 | 6490 | 0 | 6365.45154494343 | 124.548455056568 | 6490 | 0.0 | 0.240367679022911 | 0.0195663189291742 | weekly | |||||||||
20504 | 20504 | South Korea | South Korea | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 51815808 | 5838 | 65 | 6475.63216292097 | -637.632162920973 | 5773 | 0.125444343162612 | -1.23057458241503 | -0.098466396311392 | weekly | |||||||||
20556 | 20556 | South Korea | South Korea | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 51815808 | 6713 | 190 | 6585.81278089851 | 127.187219101485 | 6523 | 0.366683464629173 | 0.245460263982539 | 0.0193123040895391 | weekly | |||||||||
17269 | 17269 | Spain | Spain | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 47558632 | 9954 | 0 | 10087.1039325843 | -133.103932584263 | 9954 | 0.0 | -0.279873341571858 | -0.01319545565049 | weekly | |||||||||
17322 | 17322 | Spain | Spain | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 47558632 | 12701 | 2878 | 10081.745505618 | 2619.25449438204 | 9823 | 6.05147767917294 | 5.507421858522 | 0.259801687408439 | weekly | |||||||||
17374 | 17374 | Spain | Spain | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 47558632 | 11225 | 1225 | 10076.3870786517 | 1148.61292134834 | 10000 | 2.57576794891829 | 2.4151513049163 | 0.113990551611679 | weekly | |||||||||
18063 | 18063 | Spain | Spain | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 47558632 | 9954 | 0 | 10087.1039325843 | -133.103932584263 | 9954 | 0.0 | -0.279873341571858 | -0.0131954556504864 | weekly | |||||||||
18116 | 18116 | Spain | Spain | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 47558632 | 12701 | 2878 | 10081.745505618 | 2619.25449438204 | 9823 | 6.05147767917294 | 5.507421858522 | 0.259801687408444 | weekly | |||||||||
18168 | 18168 | Spain | Spain | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 47558632 | 11225 | 1225 | 10076.3870786517 | 1148.61292134834 | 10000 | 2.57576794891829 | 2.4151513049163 | 0.113990551611683 | weekly | |||||||||
16230 | 16230 | Poland | Poland | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 39857144 | 8015 | 0 | 8707.59293071131 | -692.592930711315 | 8015 | 0.0 | -1.73768830679718 | -0.0795389651563251 | weekly | |||||||||
16283 | 16283 | Poland | Poland | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 39857144 | 10397 | 1817 | 8784.76343632927 | 1612.23656367073 | 8580 | 4.55878123128943 | 4.04503785738067 | 0.183526463217364 | weekly | |||||||||
16335 | 16335 | Poland | Poland | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 39857144 | 10156 | 1317 | 8861.93394194725 | 1294.06605805275 | 8839 | 3.30430098052184 | 3.24676062603168 | 0.14602524308237 | weekly | |||||||||
20799 | 20799 | Poland | Poland | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 39857144 | 8015 | 0 | 8707.59293071131 | -692.592930711315 | 8015 | 0.0 | -1.73768830679718 | -0.0795389651563256 | weekly | |||||||||
20852 | 20852 | Poland | Poland | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 39857144 | 10397 | 1817 | 8784.76343632927 | 1612.23656367073 | 8580 | 4.55878123128943 | 4.04503785738068 | 0.183526463217365 | weekly | |||||||||
20904 | 20904 | Poland | Poland | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 39857144 | 10156 | 1317 | 8861.93394194725 | 1294.06605805275 | 8839 | 3.30430098052184 | 3.2467606260317 | 0.14602524308237 | weekly | |||||||||
2889 | 2889 | United States | California | CA | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 39512223 | 5832 | 0 | 5732.53571428662 | 99.4642857133767 | 5832 | 0.0 | 0.251730422035168 | 0.0173508357681038 | weekly | |||||||||
2942 | 2942 | United States | California | CA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 39512223 | 9597 | 3311 | 5730.39285714357 | 3866.60714285643 | 6286 | 8.37968544569107 | 9.78585067931113 | 0.674754286355128 | weekly | |||||||||
2994 | 2994 | United States | California | CA | 2022-01-23 | 2022-01-29 | 7 | 2022 | 4 | 39512223 | 8121 | 1266 | 5728.25000000051 | 2392.74999999949 | 6855 | 3.20407181342341 | 6.05572103599305 | 0.417710470038715 | weekly | |||||||||
10692 | 10692 | Canada | Canada | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 38454328 | 6165 | 0 | 6276.81764981252 | -111.81764981252 | 6165 | 0.0 | -0.290780402696207 | -0.017814385577357 | weekly | |||||||||
10745 | 10745 | Canada | Canada | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 38454328 | 6675 | 922 | 6382.878043071 | 292.121956928998 | 5753 | 2.39764949214559 | 0.759659502901722 | 0.0457664951386803 | weekly | |||||||||
10797 | 10797 | Canada | Canada | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 38454328 | 7705 | 1162 | 6488.93843632951 | 1216.06156367049 | 6543 | 3.02176649660865 | 3.16235291816955 | 0.187405316848461 | weekly | |||||||||
11929 | 11929 | Canada | Canada | 0 | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 38454328 | 6165 | 0 | 6274.90175681946 | -109.901756819456 | 6165 | 0.0 | -0.285798146880778 | -0.0175144984062932 | weekly | |||||||||
11982 | 11982 | Canada | Canada | 0 | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 38454328 | 6675 | 962 | 6380.19579288041 | 294.804207119591 | 5713 | 2.50166899288943 | 0.766634661044112 | 0.0462061379759784 | weekly | |||||||||
12034 | 12034 | Canada | Canada | 0 | 2022-01-23 | 2022-01-29 | 7 | 2022 | 4 | 38454328 | 7705 | 1143 | 6485.48982894136 | 1219.51017105864 | 6562 | 2.97235723375533 | 3.17132097863897 | 0.188036710136619 | weekly | |||||||||
16085 | 16085 | Peru | Peru | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 34049588 | 2736.6 | 0 | 2817.84730769176 | -81.2473076917609 | 2736.6 | 0.0 | -0.238614657222169 | -0.0288331122378358 | weekly | |||||||||
16138 | 16138 | Peru | Peru | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 34049588 | 7133.7 | 3900 | 2871.92884615319 | 4261.77115384681 | 3233.7 | 11.4538830836955 | 12.5163662886224 | 1.48394036974671 | weekly | |||||||||
16190 | 16190 | Peru | Peru | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 34049588 | 4824.6 | 1182 | 2926.01038461463 | 1898.58961538537 | 3642.6 | 3.47140764228924 | 5.57595473808778 | 0.648866328488928 | weekly | |||||||||
24713 | 24713 | Peru | Peru | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 34049588 | 2736.6 | 0 | 2817.84730769176 | -81.2473076917609 | 2736.6 | 0.0 | -0.238614657222169 | -0.0288331122378361 | weekly | |||||||||
24766 | 24766 | Peru | Peru | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 34049588 | 7133.7 | 3900 | 2871.92884615319 | 4261.77115384681 | 3233.7 | 11.4538830836955 | 12.5163662886224 | 1.48394036974671 | weekly | |||||||||
24818 | 24818 | Peru | Peru | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 34049588 | 4824.6 | 1182 | 2926.01038461463 | 1898.58961538537 | 3642.6 | 3.47140764228924 | 5.57595473808778 | 0.648866328488927 | weekly | |||||||||
8817 | 8817 | United States | Texas | TX | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 28995881 | 4128 | 0 | 4311.83834586538 | -183.838345865379 | 4128 | 0.0 | -0.634015382617203 | -0.0426357231229834 | weekly | |||||||||
8870 | 8870 | United States | Texas | TX | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 28995881 | 6641 | 2115 | 4351.06390977518 | 2289.93609022482 | 4526 | 7.29413946760231 | 7.89745305626279 | 0.526293370474337 | weekly | |||||||||
8922 | 8922 | United States | Texas | TX | 2022-01-23 | 2022-01-29 | 7 | 2022 | 4 | 28995881 | 6840 | 1302 | 4390.28947368499 | 2449.71052631501 | 5538 | 4.49029294885022 | 8.44847765210173 | 0.557983827945369 | weekly | |||||||||
11180 | 11180 | Australia | Australia | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 26177410 | 3007 | 0 | 2940.37289325836 | 66.6271067416396 | 3007 | 0.0 | 0.254521385964614 | 0.0226594072113784 | weekly | |||||||||
11233 | 11233 | Australia | Australia | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 26177410 | 2944 | 0 | 2971.92205056175 | -27.9220505617509 | 2944 | 0.0 | -0.106664679820314 | -0.00939528362006403 | weekly | |||||||||
11285 | 11285 | Australia | Australia | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 26177410 | 3782 | 612 | 3003.47120786514 | 778.528792134859 | 3170 | 2.33789362660401 | 2.97404820467288 | 0.259209673825452 | weekly | |||||||||
18768 | 18768 | Australia | Australia | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 26177410 | 3007 | 0 | 2940.37289325836 | 66.6271067416396 | 3007 | 0.0 | 0.254521385964615 | 0.0226594072113782 | weekly | |||||||||
18821 | 18821 | Australia | Australia | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 26177410 | 2944 | 0 | 2971.92205056175 | -27.9220505617509 | 2944 | 0.0 | -0.106664679820314 | -0.00939528362006437 | weekly | |||||||||
18873 | 18873 | Australia | Australia | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 26177410 | 3782 | 612 | 3003.47120786514 | 778.528792134859 | 3170 | 2.33789362660401 | 2.97404820467288 | 0.259209673825452 | weekly | |||||||||
3649 | 3649 | United States | Florida | FL | 2020-01-19 | 2020-01-25 | 7 | 2020 | 4 | 21477737 | 4387 | 0 | 4368.43045112908 | 18.5695488709189 | 4387 | 0.0 | 0.0864595225787469 | 0.00425085143935844 | weekly | |||||||||
3702 | 3702 | United States | Florida | FL | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 21477737 | 5491 | 1196 | 4401.5507518809 | 1089.4492481191 | 4295 | 5.56855687356634 | 5.07245827676866 | 0.247514866812238 | weekly | |||||||||
3754 | 3754 | United States | Florida | FL | 2022-01-23 | 2022-01-29 | 7 | 2022 | 4 | 21477737 | 6113 | 953 | 4434.67105263271 | 1678.32894736729 | 5160 | 4.43715275962267 | 7.81427273910324 | 0.378456243416504 | weekly | |||||||||
16535 | 16535 | Romania | Romania | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 19659270 | 5350 | 0 | 5700.69030898879 | -350.69030898879 | 5350 | 0.0 | -1.78384196864273 | -0.0615171654625449 | 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);