economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
10 rows where cadence = "weekly", country = "United States" and covid_deaths = 105 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, year, population, covid_deaths_per_100k, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8798 | 8798 | United States | Tennessee | TN | 2022-08-07 | 2022-08-13 | 7 | 2022 | 32 | 6833174 | 1619 | 105 | 1412.05513784557 | 206.944862154431 | 1514 | 1.53662119536251 | 3.02853201388448 | 0.146555794181079 | weekly | |||||||||
8183 | 8183 | United States | Pennsylvania | PA | 2022-06-19 | 2022-06-25 | 7 | 2022 | 25 | 12801989 | 2624 | 105 | 2363.90476190587 | 260.095238094132 | 2519 | 0.82018505093232 | 2.03167834384276 | 0.110027799040615 | weekly | |||||||||
8171 | 8171 | United States | Pennsylvania | PA | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 12801989 | 2669 | 105 | 2612.90476190587 | 56.0952380941276 | 2564 | 0.82018505093232 | 0.438175959174216 | 0.0214685352914323 | weekly | |||||||||
3304 | 3304 | United States | Connecticut | CT | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 3565287 | 626 | 105 | 634.52631578986 | -8.5263157898604 | 521 | 2.94506445063188 | -0.239148090738849 | -0.0134372926349742 | weekly | |||||||||
7092 | 7092 | United States | New Mexico | NM | 2021-12-12 | 2021-12-18 | 7 | 2021 | 50 | 2096829 | 593 | 105 | 372.962406015875 | 220.037593984125 | 488 | 5.00756141774079 | 10.4938263436897 | 0.589972582852649 | weekly | |||||||||
4659 | 4659 | United States | Iowa | IA | 2021-12-05 | 2021-12-11 | 7 | 2021 | 49 | 3155070 | 824 | 105 | 623.097744361481 | 200.902255638519 | 719 | 3.32797687531497 | 6.36760058060579 | 0.322424944491484 | weekly | |||||||||
6581 | 6581 | United States | Nevada | NV | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 3080156 | 744 | 105 | 518.187969925667 | 225.812030074333 | 639 | 3.40891824959515 | 7.33118809808118 | 0.435772428500657 | weekly | |||||||||
5498 | 5498 | United States | Massachusetts | MA | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 6949503 | 1060 | 105 | 1016.79197995066 | 43.2080200493384 | 955 | 1.51089941251914 | 0.621742591511054 | 0.0424944540292647 | weekly | |||||||||
7319 | 7319 | United States | North Carolina | NC | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 10488084 | 1946 | 105 | 1779.3709273189 | 166.629072681097 | 1841 | 1.00113614650684 | 1.58874654971391 | 0.0936449337925105 | weekly | |||||||||
7313 | 7313 | United States | North Carolina | NC | 2020-05-10 | 2020-05-16 | 7 | 2020 | 20 | 10488084 | 2039 | 105 | 1780.03759398554 | 258.962406014459 | 1934 | 1.00113614650684 | 2.46911071664242 | 0.145481425161722 | 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);