economist_historical_deaths

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette

95 rows where cadence = "monthly" and country = "Taiwan"

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: days, year, covid_deaths, month, start_date (date), end_date (date)

country 1

  • Taiwan · 95 ✖

cadence 1

  • monthly · 95 ✖
Link rowid ▼ country region region_code start_date end_date days year week population total_deaths covid_deaths expected_deaths cadence month
18030 18030 Taiwan Taiwan 0 2015-01-01 2015-01-31 31 2015   23893396 14310 0 TBC monthly 1
18031 18031 Taiwan Taiwan 0 2015-02-01 2015-02-28 28 2015   23893396 12122 0 TBC monthly 2
18032 18032 Taiwan Taiwan 0 2015-03-01 2015-03-31 31 2015   23893396 16092 0 TBC monthly 3
18033 18033 Taiwan Taiwan 0 2015-04-01 2015-04-30 30 2015   23893396 14002 0 TBC monthly 4
18034 18034 Taiwan Taiwan 0 2015-05-01 2015-05-31 31 2015   23893396 12802 0 TBC monthly 5
18035 18035 Taiwan Taiwan 0 2015-06-01 2015-06-30 30 2015   23893396 13712 0 TBC monthly 6
18036 18036 Taiwan Taiwan 0 2015-07-01 2015-07-31 31 2015   23893396 14475 0 TBC monthly 7
18037 18037 Taiwan Taiwan 0 2015-08-01 2015-08-31 31 2015   23893396 12586 0 TBC monthly 8
18038 18038 Taiwan Taiwan 0 2015-09-01 2015-09-30 30 2015   23893396 12527 0 TBC monthly 9
18039 18039 Taiwan Taiwan 0 2015-10-01 2015-10-31 31 2015   23893396 13794 0 TBC monthly 10
18040 18040 Taiwan Taiwan 0 2015-11-01 2015-11-30 30 2015   23893396 13010 0 TBC monthly 11
18041 18041 Taiwan Taiwan 0 2015-12-01 2015-12-31 31 2015   23893396 14426 0 TBC monthly 12
18042 18042 Taiwan Taiwan 0 2016-01-01 2016-01-31 31 2016   23893396 14292 0 TBC monthly 1
18043 18043 Taiwan Taiwan 0 2016-02-01 2016-02-29 29 2016   23893396 15441 0 TBC monthly 2
18044 18044 Taiwan Taiwan 0 2016-03-01 2016-03-31 31 2016   23893396 18918 0 TBC monthly 3
18045 18045 Taiwan Taiwan 0 2016-04-01 2016-04-30 30 2016   23893396 14520 0 TBC monthly 4
18046 18046 Taiwan Taiwan 0 2016-05-01 2016-05-31 31 2016   23893396 14238 0 TBC monthly 5
18047 18047 Taiwan Taiwan 0 2016-06-01 2016-06-30 30 2016   23893396 13445 0 TBC monthly 6
18048 18048 Taiwan Taiwan 0 2016-07-01 2016-07-31 31 2016   23893396 13021 0 TBC monthly 7
18049 18049 Taiwan Taiwan 0 2016-08-01 2016-08-31 31 2016   23893396 14195 0 TBC monthly 8
18050 18050 Taiwan Taiwan 0 2016-09-01 2016-09-30 30 2016   23893396 12829 0 TBC monthly 9
18051 18051 Taiwan Taiwan 0 2016-10-01 2016-10-31 31 2016   23893396 13676 0 TBC monthly 10
18052 18052 Taiwan Taiwan 0 2016-11-01 2016-11-30 30 2016   23893396 13663 0 TBC monthly 11
18053 18053 Taiwan Taiwan 0 2016-12-01 2016-12-31 31 2016   23893396 14167 0 TBC monthly 12
18054 18054 Taiwan Taiwan 0 2017-01-01 2017-01-31 31 2017   23893396 12835 0 TBC monthly 1
18055 18055 Taiwan Taiwan 0 2017-02-01 2017-02-28 28 2017   23893396 14865 0 TBC monthly 2
18056 18056 Taiwan Taiwan 0 2017-03-01 2017-03-31 31 2017   23893396 17391 0 TBC monthly 3
18057 18057 Taiwan Taiwan 0 2017-04-01 2017-04-30 30 2017   23893396 13110 0 TBC monthly 4
18058 18058 Taiwan Taiwan 0 2017-05-01 2017-05-31 31 2017   23893396 13914 0 TBC monthly 5
18059 18059 Taiwan Taiwan 0 2017-06-01 2017-06-30 30 2017   23893396 14453 0 TBC monthly 6
18060 18060 Taiwan Taiwan 0 2017-07-01 2017-07-31 31 2017   23893396 14479 0 TBC monthly 7
18061 18061 Taiwan Taiwan 0 2017-08-01 2017-08-31 31 2017   23893396 15580 0 TBC monthly 8
18062 18062 Taiwan Taiwan 0 2017-09-01 2017-09-30 30 2017   23893396 13436 0 TBC monthly 9
18063 18063 Taiwan Taiwan 0 2017-10-01 2017-10-31 31 2017   23893396 13710 0 TBC monthly 10
18064 18064 Taiwan Taiwan 0 2017-11-01 2017-11-30 30 2017   23893396 13632 0 TBC monthly 11
18065 18065 Taiwan Taiwan 0 2017-12-01 2017-12-31 31 2017   23893396 13837 0 TBC monthly 12
18066 18066 Taiwan Taiwan 0 2018-01-01 2018-01-31 31 2018   23893396 16761 0 TBC monthly 1
18067 18067 Taiwan Taiwan 0 2018-02-01 2018-02-28 28 2018   23893396 14493 0 TBC monthly 2
18068 18068 Taiwan Taiwan 0 2018-03-01 2018-03-31 31 2018   23893396 17200 0 TBC monthly 3
18069 18069 Taiwan Taiwan 0 2018-04-01 2018-04-30 30 2018   23893396 13988 0 TBC monthly 4
18070 18070 Taiwan Taiwan 0 2018-05-01 2018-05-31 31 2018   23893396 14328 0 TBC monthly 5
18071 18071 Taiwan Taiwan 0 2018-06-01 2018-06-30 30 2018   23893396 13043 0 TBC monthly 6
18072 18072 Taiwan Taiwan 0 2018-07-01 2018-07-31 31 2018   23893396 14372 0 TBC monthly 7
18073 18073 Taiwan Taiwan 0 2018-08-01 2018-08-31 31 2018   23893396 14162 0 TBC monthly 8
18074 18074 Taiwan Taiwan 0 2018-09-01 2018-09-30 30 2018   23893396 12886 0 TBC monthly 9
18075 18075 Taiwan Taiwan 0 2018-10-01 2018-10-31 31 2018   23893396 14922 0 TBC monthly 10
18076 18076 Taiwan Taiwan 0 2018-11-01 2018-11-30 30 2018   23893396 13680 0 TBC monthly 11
18077 18077 Taiwan Taiwan 0 2018-12-01 2018-12-31 31 2018   23893396 12949 0 TBC monthly 12
18078 18078 Taiwan Taiwan 0 2019-01-01 2019-01-31 31 2019   23893396 16622 0 TBC monthly 1
18079 18079 Taiwan Taiwan 0 2019-02-01 2019-02-28 28 2019   23893396 13352 0 TBC monthly 2
18080 18080 Taiwan Taiwan 0 2019-03-01 2019-03-31 31 2019   23893396 15171 0 TBC monthly 3
18081 18081 Taiwan Taiwan 0 2019-04-01 2019-04-30 30 2019   23893396 14996 0 TBC monthly 4
18082 18082 Taiwan Taiwan 0 2019-05-01 2019-05-31 31 2019   23893396 14655 0 TBC monthly 5
18083 18083 Taiwan Taiwan 0 2019-06-01 2019-06-30 30 2019   23893396 13302 0 TBC monthly 6
18084 18084 Taiwan Taiwan 0 2019-07-01 2019-07-31 31 2019   23893396 15854 0 TBC monthly 7
18085 18085 Taiwan Taiwan 0 2019-08-01 2019-08-31 31 2019   23893396 13983 0 TBC monthly 8
18086 18086 Taiwan Taiwan 0 2019-09-01 2019-09-30 30 2019   23893396 13866 0 TBC monthly 9
18087 18087 Taiwan Taiwan 0 2019-10-01 2019-10-31 31 2019   23893396 15350 0 TBC monthly 10
18088 18088 Taiwan Taiwan 0 2019-11-01 2019-11-30 30 2019   23893396 13739 0 TBC monthly 11
18089 18089 Taiwan Taiwan 0 2019-12-01 2019-12-31 31 2019   23893396 15406 0 TBC monthly 12
18090 18090 Taiwan Taiwan 0 2020-01-01 2020-01-31 31 2020   23893396 14673 0 TBC monthly 1
18091 18091 Taiwan Taiwan 0 2020-02-01 2020-02-29 29 2020   23893396 16211 1 TBC monthly 2
18092 18092 Taiwan Taiwan 0 2020-03-01 2020-03-31 31 2020   23893396 16083 4 TBC monthly 3
18093 18093 Taiwan Taiwan 0 2020-04-01 2020-04-30 30 2020   23893396 14423 1 TBC monthly 4
18094 18094 Taiwan Taiwan 0 2020-05-01 2020-05-31 31 2020   23893396 13272 1 TBC monthly 5
18095 18095 Taiwan Taiwan 0 2020-06-01 2020-06-30 30 2020   23893396 13893 0 TBC monthly 6
18096 18096 Taiwan Taiwan 0 2020-07-01 2020-07-31 31 2020   23893396 14533 0 TBC monthly 7
18097 18097 Taiwan Taiwan 0 2020-08-01 2020-08-31 31 2020   23893396 13301 0 TBC monthly 8
18098 18098 Taiwan Taiwan 0 2020-09-01 2020-09-30 30 2020   23893396 13876 0 TBC monthly 9
18099 18099 Taiwan Taiwan 0 2020-10-01 2020-10-31 31 2020   23893396 13542 0 TBC monthly 10
18100 18100 Taiwan Taiwan 0 2020-11-01 2020-11-30 30 2020   23893396 14141 0 TBC monthly 11
18101 18101 Taiwan Taiwan 0 2020-12-01 2020-12-31 31 2020   23893396 15208 0 TBC monthly 12
18102 18102 Taiwan Taiwan 0 2021-01-01 2021-01-31 31 2021   23893396 16332 1 TBC monthly 1
18103 18103 Taiwan Taiwan 0 2021-02-01 2021-02-28 28 2021   23893396 14856 1 TBC monthly 2
18104 18104 Taiwan Taiwan 0 2021-03-01 2021-03-31 31 2021   23893396 16438 1 TBC monthly 3
18105 18105 Taiwan Taiwan 0 2021-04-01 2021-04-30 30 2021   23893396 14276 2 TBC monthly 4
18106 18106 Taiwan Taiwan 0 2021-05-01 2021-05-31 31 2021   23893396 15108 112 TBC monthly 5
18107 18107 Taiwan Taiwan 0 2021-06-01 2021-06-30 30 2021   23893396 16639 524 TBC monthly 6
18108 18108 Taiwan Taiwan 0 2021-07-01 2021-07-31 31 2021   23893396 15523 139 TBC monthly 7
18109 18109 Taiwan Taiwan 0 2021-08-01 2021-08-31 31 2021   23893396 14952 48 TBC monthly 8
18110 18110 Taiwan Taiwan 0 2021-09-01 2021-09-30 30 2021   23893396 13894 7 TBC monthly 9
18111 18111 Taiwan Taiwan 0 2021-10-01 2021-10-31 31 2021   23893396 14415 5 TBC monthly 10
18112 18112 Taiwan Taiwan 0 2021-11-01 2021-11-30 30 2021   23893396 15560 1 TBC monthly 11
18113 18113 Taiwan Taiwan 0 2021-12-01 2021-12-31 31 2021   23893396 15739 2 TBC monthly 12
18114 18114 Taiwan Taiwan 0 2022-01-01 2022-01-31 31 2022   23893396 15954 1 TBC monthly 1
18115 18115 Taiwan Taiwan 0 2022-02-01 2022-02-28 28 2022   23893396 14887 2 TBC monthly 2
18116 18116 Taiwan Taiwan 0 2022-03-01 2022-03-31 31 2022   23893396 18239 0 TBC monthly 3
18117 18117 Taiwan Taiwan 0 2022-04-01 2022-04-30 30 2022   23893396 14655 12 TBC monthly 4
18118 18118 Taiwan Taiwan 0 2022-05-01 2022-05-31 31 2022   23893396 17409 1390 TBC monthly 5
18119 18119 Taiwan Taiwan 0 2022-06-01 2022-06-30 30 2022   23893396 21033 4396 TBC monthly 6
18120 18120 Taiwan Taiwan 0 2022-07-01 2022-07-31 31 2022   23893396 18215 2276 TBC monthly 7
18121 18121 Taiwan Taiwan 0 2022-08-01 2022-08-31 31 2022   23893396 17830 987 TBC monthly 8
18122 18122 Taiwan Taiwan 0 2022-09-01 2022-09-30 30 2022   23893396 16505 1139 TBC monthly 9
18123 18123 Taiwan Taiwan 0 2022-10-01 2022-10-31 31 2022   23893396 17099 1778 TBC monthly 10
18124 18124 Taiwan Taiwan 0 2022-11-01 2022-11-30 30 2022   23893396 17719 1503 TBC monthly 11

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [economist_historical_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] TEXT,
   [cadence] TEXT
, [month] INTEGER);
CREATE INDEX [idx_economist_historical_deaths_country]
    ON [economist_historical_deaths] ([country]);
CREATE INDEX [idx_economist_historical_deaths_cadence]
    ON [economist_historical_deaths] ([cadence]);
CREATE INDEX [idx_economist_historical_deaths_end_date]
    ON [economist_historical_deaths] ([end_date]);