economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
8 rows where cadence = "monthly", covid_deaths = 3 and "start_date" is on date 2020-06-01 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, population, total_deaths, expected_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_per_100k, total_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
352 | 352 | Singapore | Singapore | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 5637022 | 1761 | 3 | 1886.64986934336 | -125.649869343365 | 1758 | 0.0532195900601417 | -2.22901151252141 | -0.0665994636233677 | monthly | 6 | 410.9 | 0.7 | 440.218302846785 | -29.3183028467851 | 410.2 | 0.0124179043473664 | -0.520102686254996 | ||
605 | 605 | Hong Kong | Hong Kong | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 7488863 | 3728 | 3 | 3819.08029733214 | -91.0802973321402 | 3725 | 0.040059485665581 | -1.21620995513124 | -0.0238487515949234 | monthly | 6 | 869.866666666667 | 0.7 | 891.118736044166 | -21.2520693774994 | 869.166666666667 | 0.0093472133219689 | -0.283782322863956 | ||
11076 | 11076 | Georgia | Georgia | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 3744385 | 3523 | 3 | 3490.92637851583 | 32.0736214841686 | 3520 | 0.0801199662962008 | 0.85657915743623 | 0.00918771065513124 | monthly | 6 | 822.033333333333 | 0.7 | 814.549488320361 | 7.48384501297267 | 821.333333333333 | 0.0186946588024469 | 0.199868470068454 | ||
19103 | 19103 | Cuba | Cuba | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 11212198 | 8722 | 3 | 9163.20939933257 | -441.209399332574 | 8719 | 0.0267565735103857 | -3.93508390890505 | -0.0481500945907348 | monthly | 6 | 2035.13333333333 | 0.7 | 2138.0821931776 | -102.948859844267 | 2034.43333333333 | 0.00624320048575667 | -0.918186245411179 | ||
21754 | 21754 | Cuba | Cuba | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 11212198 | 8722 | 3 | 9163.20939933257 | -441.209399332574 | 8719 | 0.0267565735103857 | -3.93508390890505 | -0.0481500945907345 | monthly | 6 | 2035.13333333333 | 0.7 | 2138.0821931776 | -102.948859844267 | 2034.43333333333 | 0.00624320048575667 | -0.918186245411179 | ||
21899 | 21899 | Georgia | Georgia | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 3744385 | 3523 | 3 | 3490.92637851583 | 32.0736214841686 | 3520 | 0.0801199662962008 | 0.85657915743623 | 0.00918771065513169 | monthly | 6 | 822.033333333333 | 0.7 | 814.549488320361 | 7.48384501297267 | 821.333333333333 | 0.0186946588024469 | 0.199868470068454 | ||
21975 | 21975 | Hong Kong | Hong Kong | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 7488863 | 3728 | 3 | 3819.08029733214 | -91.0802973321402 | 3725 | 0.040059485665581 | -1.21620995513124 | -0.0238487515949234 | monthly | 6 | 869.866666666667 | 0.7 | 891.118736044166 | -21.2520693774994 | 869.166666666667 | 0.0093472133219689 | -0.283782322863956 | ||
22904 | 22904 | Singapore | Singapore | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 5637022 | 1761 | 3 | 1886.64986934336 | -125.649869343365 | 1758 | 0.0532195900601417 | -2.22901151252142 | -0.0665994636233653 | monthly | 6 | 410.9 | 0.7 | 440.218302846785 | -29.3183028467851 | 410.2 | 0.0124179043473664 | -0.520102686254996 |
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);