economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
13 rows where country = "United States" and covid_deaths = 134 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, year, week, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7748 | 7748 | United States | Ohio | OH | 2022-11-13 | 2022-11-19 | 7 | 2022 | 46 | 11689100 | 2642 | 134 | 2365.63408521547 | 276.365914784529 | 2508 | 1.14636712835034 | 2.36430447839893 | 0.116825301305783 | weekly | |||||||||
5739 | 5739 | United States | Michigan | MI | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 9986857 | 1882 | 134 | 1966.06265664234 | -84.0626566423443 | 1748 | 1.34176347974142 | -0.841732855915974 | -0.0427568553618262 | weekly | |||||||||
2388 | 2388 | United States | Alabama | AL | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 4903185 | 1601 | 134 | 1127.96052630046 | 473.039473699536 | 1467 | 2.73291748118825 | 9.64759587287723 | 0.4193759113637 | weekly | |||||||||
9682 | 9682 | United States | West Virginia | WV | 2022-01-23 | 2022-01-29 | 7 | 2022 | 4 | 1792147 | 687 | 134 | 473.710526316974 | 213.289473683026 | 553 | 7.47706521842237 | 11.9013380979923 | 0.450252763731721 | weekly | |||||||||
4195 | 4195 | United States | Idaho | ID | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 1787065 | 477 | 134 | 260.463659148599 | 216.536340851401 | 343 | 7.49832826450073 | 12.1168698872957 | 0.831349530906588 | weekly | |||||||||
5685 | 5685 | United States | Michigan | MI | 2021-03-14 | 2021-03-20 | 7 | 2021 | 11 | 9986857 | 2014 | 134 | 1997.79699248199 | 16.2030075180146 | 1880 | 1.34176347974142 | 0.162243311564535 | 0.00811043743633055 | weekly | |||||||||
9482 | 9482 | United States | Washington | WA | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 7614893 | 1234 | 134 | 1169.48684210612 | 64.5131578938795 | 1100 | 1.75970955862413 | 0.847197168678266 | 0.0551636457727889 | weekly | |||||||||
3094 | 3094 | United States | Colorado | CO | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 5758736 | 932 | 134 | 835.721804512518 | 96.2781954874821 | 798 | 2.32689951406003 | 1.67186333055521 | 0.115203641890906 | weekly | |||||||||
5514 | 5514 | United States | Massachusetts | MA | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 6949503 | 1218 | 134 | 1094.4586466173 | 123.541353382702 | 1084 | 1.92819544073871 | 1.77770055474042 | 0.11287895962496 | weekly | |||||||||
7186 | 7186 | United States | New York | NY | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 19453561 | 3317 | 134 | 3002.89974937422 | 314.100250625783 | 3183 | 0.688819902947332 | 1.61461570262526 | 0.104598979933059 | weekly | |||||||||
4288 | 4288 | United States | Illinois | IL | 2020-08-23 | 2020-08-29 | 7 | 2020 | 35 | 12671821 | 2120 | 134 | 1866.70175438645 | 253.298245613548 | 1986 | 1.05746443230219 | 1.99890959329008 | 0.135692938102371 | weekly | |||||||||
5955 | 5955 | United States | Mississippi | MS | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 2976149 | 885 | 134 | 552.29072681779 | 332.70927318221 | 751 | 4.50246274632083 | 11.1791873720775 | 0.60241691020095 | weekly | |||||||||
5036 | 5036 | United States | Louisiana | LA | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 4648794 | 1016 | 134 | 884.616541354335 | 131.383458645665 | 882 | 2.8824680121339 | 2.82618370798244 | 0.148520237304764 | 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);