economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
54 rows where cadence = "monthly", country = "Malaysia" and days = 31
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: year, covid_deaths, month, 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 | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7350 | 7350 | Malaysia | Malaysia | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 33938216 | 14073 | 0 | TBC | monthly | 1 | |
7352 | 7352 | Malaysia | Malaysia | 0 | 2015-03-01 | 2015-03-31 | 31 | 2015 | 33938216 | 13397 | 0 | TBC | monthly | 3 | |
7354 | 7354 | Malaysia | Malaysia | 0 | 2015-05-01 | 2015-05-31 | 31 | 2015 | 33938216 | 13152 | 0 | TBC | monthly | 5 | |
7356 | 7356 | Malaysia | Malaysia | 0 | 2015-07-01 | 2015-07-31 | 31 | 2015 | 33938216 | 13497 | 0 | TBC | monthly | 7 | |
7357 | 7357 | Malaysia | Malaysia | 0 | 2015-08-01 | 2015-08-31 | 31 | 2015 | 33938216 | 13312 | 0 | TBC | monthly | 8 | |
7359 | 7359 | Malaysia | Malaysia | 0 | 2015-10-01 | 2015-10-31 | 31 | 2015 | 33938216 | 12969 | 0 | TBC | monthly | 10 | |
7361 | 7361 | Malaysia | Malaysia | 0 | 2015-12-01 | 2015-12-31 | 31 | 2015 | 33938216 | 13177 | 0 | TBC | monthly | 12 | |
7362 | 7362 | Malaysia | Malaysia | 0 | 2016-01-01 | 2016-01-31 | 31 | 2016 | 33938216 | 13281 | 0 | TBC | monthly | 1 | |
7364 | 7364 | Malaysia | Malaysia | 0 | 2016-03-01 | 2016-03-31 | 31 | 2016 | 33938216 | 14660 | 0 | TBC | monthly | 3 | |
7366 | 7366 | Malaysia | Malaysia | 0 | 2016-05-01 | 2016-05-31 | 31 | 2016 | 33938216 | 13658 | 0 | TBC | monthly | 5 | |
7368 | 7368 | Malaysia | Malaysia | 0 | 2016-07-01 | 2016-07-31 | 31 | 2016 | 33938216 | 13982 | 0 | TBC | monthly | 7 | |
7369 | 7369 | Malaysia | Malaysia | 0 | 2016-08-01 | 2016-08-31 | 31 | 2016 | 33938216 | 13906 | 0 | TBC | monthly | 8 | |
7371 | 7371 | Malaysia | Malaysia | 0 | 2016-10-01 | 2016-10-31 | 31 | 2016 | 33938216 | 13083 | 0 | TBC | monthly | 10 | |
7373 | 7373 | Malaysia | Malaysia | 0 | 2016-12-01 | 2016-12-31 | 31 | 2016 | 33938216 | 13771 | 0 | TBC | monthly | 12 | |
7374 | 7374 | Malaysia | Malaysia | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 33938216 | 14333 | 0 | TBC | monthly | 1 | |
7376 | 7376 | Malaysia | Malaysia | 0 | 2017-03-01 | 2017-03-31 | 31 | 2017 | 33938216 | 14458 | 0 | TBC | monthly | 3 | |
7378 | 7378 | Malaysia | Malaysia | 0 | 2017-05-01 | 2017-05-31 | 31 | 2017 | 33938216 | 14633 | 0 | TBC | monthly | 5 | |
7380 | 7380 | Malaysia | Malaysia | 0 | 2017-07-01 | 2017-07-31 | 31 | 2017 | 33938216 | 14613 | 0 | TBC | monthly | 7 | |
7381 | 7381 | Malaysia | Malaysia | 0 | 2017-08-01 | 2017-08-31 | 31 | 2017 | 33938216 | 13576 | 0 | TBC | monthly | 8 | |
7383 | 7383 | Malaysia | Malaysia | 0 | 2017-10-01 | 2017-10-31 | 31 | 2017 | 33938216 | 14229 | 0 | TBC | monthly | 10 | |
7385 | 7385 | Malaysia | Malaysia | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 33938216 | 14603 | 0 | TBC | monthly | 12 | |
7386 | 7386 | Malaysia | Malaysia | 0 | 2018-01-01 | 2018-01-31 | 31 | 2018 | 33938216 | 14960 | 0 | TBC | monthly | 1 | |
7388 | 7388 | Malaysia | Malaysia | 0 | 2018-03-01 | 2018-03-31 | 31 | 2018 | 33938216 | 14985 | 0 | TBC | monthly | 3 | |
7390 | 7390 | Malaysia | Malaysia | 0 | 2018-05-01 | 2018-05-31 | 31 | 2018 | 33938216 | 14413 | 0 | TBC | monthly | 5 | |
7392 | 7392 | Malaysia | Malaysia | 0 | 2018-07-01 | 2018-07-31 | 31 | 2018 | 33938216 | 14461 | 0 | TBC | monthly | 7 | |
7393 | 7393 | Malaysia | Malaysia | 0 | 2018-08-01 | 2018-08-31 | 31 | 2018 | 33938216 | 14278 | 0 | TBC | monthly | 8 | |
7395 | 7395 | Malaysia | Malaysia | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 33938216 | 13823 | 0 | TBC | monthly | 10 | |
7397 | 7397 | Malaysia | Malaysia | 0 | 2018-12-01 | 2018-12-31 | 31 | 2018 | 33938216 | 15297 | 0 | TBC | monthly | 12 | |
7398 | 7398 | Malaysia | Malaysia | 0 | 2019-01-01 | 2019-01-31 | 31 | 2019 | 33938216 | 14872 | 0 | TBC | monthly | 1 | |
7400 | 7400 | Malaysia | Malaysia | 0 | 2019-03-01 | 2019-03-31 | 31 | 2019 | 33938216 | 14750 | 0 | TBC | monthly | 3 | |
7402 | 7402 | Malaysia | Malaysia | 0 | 2019-05-01 | 2019-05-31 | 31 | 2019 | 33938216 | 14540 | 0 | TBC | monthly | 5 | |
7404 | 7404 | Malaysia | Malaysia | 0 | 2019-07-01 | 2019-07-31 | 31 | 2019 | 33938216 | 14850 | 0 | TBC | monthly | 7 | |
7405 | 7405 | Malaysia | Malaysia | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 33938216 | 14328 | 0 | TBC | monthly | 8 | |
7407 | 7407 | Malaysia | Malaysia | 0 | 2019-10-01 | 2019-10-31 | 31 | 2019 | 33938216 | 14282 | 0 | TBC | monthly | 10 | |
7409 | 7409 | Malaysia | Malaysia | 0 | 2019-12-01 | 2019-12-31 | 31 | 2019 | 33938216 | 15599 | 0 | TBC | monthly | 12 | |
7410 | 7410 | Malaysia | Malaysia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 33938216 | 16028 | 0 | TBC | monthly | 1 | |
7412 | 7412 | Malaysia | Malaysia | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 33938216 | 14676 | 48 | TBC | monthly | 3 | |
7414 | 7414 | Malaysia | Malaysia | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 33938216 | 13886 | 12 | TBC | monthly | 5 | |
7416 | 7416 | Malaysia | Malaysia | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 33938216 | 13659 | 4 | TBC | monthly | 7 | |
7417 | 7417 | Malaysia | Malaysia | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 33938216 | 13950 | 2 | TBC | monthly | 8 | |
7419 | 7419 | Malaysia | Malaysia | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 33938216 | 13880 | 127 | TBC | monthly | 10 | |
7421 | 7421 | Malaysia | Malaysia | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 33938216 | 14151 | 111 | TBC | monthly | 12 | |
7422 | 7422 | Malaysia | Malaysia | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 33938216 | 16184 | 289 | TBC | monthly | 1 | |
7424 | 7424 | Malaysia | Malaysia | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 33938216 | 15391 | 137 | TBC | monthly | 3 | |
7426 | 7426 | Malaysia | Malaysia | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 33938216 | 18089 | 1290 | TBC | monthly | 5 | |
7428 | 7428 | Malaysia | Malaysia | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 33938216 | 24520 | 3854 | TBC | monthly | 7 | |
7429 | 7429 | Malaysia | Malaysia | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 33938216 | 26799 | 7640 | TBC | monthly | 8 | |
7431 | 7431 | Malaysia | Malaysia | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 33938216 | 19439 | 2577 | TBC | monthly | 10 | |
7433 | 7433 | Malaysia | Malaysia | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 33938216 | 17712 | 1062 | TBC | monthly | 12 | |
7434 | 7434 | Malaysia | Malaysia | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 33938216 | 16465 | 491 | TBC | monthly | 1 | |
7436 | 7436 | Malaysia | Malaysia | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 33938216 | 21173 | 2234 | TBC | monthly | 3 | |
7438 | 7438 | Malaysia | Malaysia | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 33938216 | 16558 | 129 | TBC | monthly | 5 | |
7440 | 7440 | Malaysia | Malaysia | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 33938216 | 19099 | 204 | TBC | monthly | 7 | |
7441 | 7441 | Malaysia | Malaysia | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 33938216 | 15986 | 269 | TBC | monthly | 8 |
Advanced export
JSON shape: default, array, newline-delimited
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]);