economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
90 rows where cadence = "monthly" and country = "Philippines"
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: days, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38556 | 38556 | Philippines | Philippines | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 115559008 | 50381 | 0 | TBC | monthly | 1 | |
38557 | 38557 | Philippines | Philippines | 0 | 2015-02-01 | 2015-02-28 | 28 | 2015 | 115559008 | 44540 | 0 | TBC | monthly | 2 | |
38558 | 38558 | Philippines | Philippines | 0 | 2015-03-01 | 2015-03-31 | 31 | 2015 | 115559008 | 46452 | 0 | TBC | monthly | 3 | |
38559 | 38559 | Philippines | Philippines | 0 | 2015-04-01 | 2015-04-30 | 30 | 2015 | 115559008 | 44421 | 0 | TBC | monthly | 4 | |
38560 | 38560 | Philippines | Philippines | 0 | 2015-05-01 | 2015-05-31 | 31 | 2015 | 115559008 | 46953 | 0 | TBC | monthly | 5 | |
38561 | 38561 | Philippines | Philippines | 0 | 2015-06-01 | 2015-06-30 | 30 | 2015 | 115559008 | 44172 | 0 | TBC | monthly | 6 | |
38562 | 38562 | Philippines | Philippines | 0 | 2015-07-01 | 2015-07-31 | 31 | 2015 | 115559008 | 47618 | 0 | TBC | monthly | 7 | |
38563 | 38563 | Philippines | Philippines | 0 | 2015-08-01 | 2015-08-31 | 31 | 2015 | 115559008 | 48511 | 0 | TBC | monthly | 8 | |
38564 | 38564 | Philippines | Philippines | 0 | 2015-09-01 | 2015-09-30 | 30 | 2015 | 115559008 | 45777 | 0 | TBC | monthly | 9 | |
38565 | 38565 | Philippines | Philippines | 0 | 2015-10-01 | 2015-10-31 | 31 | 2015 | 115559008 | 48404 | 0 | TBC | monthly | 10 | |
38566 | 38566 | Philippines | Philippines | 0 | 2015-11-01 | 2015-11-30 | 30 | 2015 | 115559008 | 45610 | 0 | TBC | monthly | 11 | |
38567 | 38567 | Philippines | Philippines | 0 | 2015-12-01 | 2015-12-31 | 31 | 2015 | 115559008 | 47766 | 0 | TBC | monthly | 12 | |
38568 | 38568 | Philippines | Philippines | 0 | 2016-01-01 | 2016-01-31 | 31 | 2016 | 115559008 | 49293 | 0 | TBC | monthly | 1 | |
38569 | 38569 | Philippines | Philippines | 0 | 2016-02-01 | 2016-02-29 | 29 | 2016 | 115559008 | 43931 | 0 | TBC | monthly | 2 | |
38570 | 38570 | Philippines | Philippines | 0 | 2016-03-01 | 2016-03-31 | 31 | 2016 | 115559008 | 46493 | 0 | TBC | monthly | 3 | |
38571 | 38571 | Philippines | Philippines | 0 | 2016-04-01 | 2016-04-30 | 30 | 2016 | 115559008 | 47511 | 0 | TBC | monthly | 4 | |
38572 | 38572 | Philippines | Philippines | 0 | 2016-05-01 | 2016-05-31 | 31 | 2016 | 115559008 | 48648 | 0 | TBC | monthly | 5 | |
38573 | 38573 | Philippines | Philippines | 0 | 2016-06-01 | 2016-06-30 | 30 | 2016 | 115559008 | 44862 | 0 | TBC | monthly | 6 | |
38574 | 38574 | Philippines | Philippines | 0 | 2016-07-01 | 2016-07-31 | 31 | 2016 | 115559008 | 48848 | 0 | TBC | monthly | 7 | |
38575 | 38575 | Philippines | Philippines | 0 | 2016-08-01 | 2016-08-31 | 31 | 2016 | 115559008 | 51521 | 0 | TBC | monthly | 8 | |
38576 | 38576 | Philippines | Philippines | 0 | 2016-09-01 | 2016-09-30 | 30 | 2016 | 115559008 | 51728 | 0 | TBC | monthly | 9 | |
38577 | 38577 | Philippines | Philippines | 0 | 2016-10-01 | 2016-10-31 | 31 | 2016 | 115559008 | 52357 | 0 | TBC | monthly | 10 | |
38578 | 38578 | Philippines | Philippines | 0 | 2016-11-01 | 2016-11-30 | 30 | 2016 | 115559008 | 48015 | 0 | TBC | monthly | 11 | |
38579 | 38579 | Philippines | Philippines | 0 | 2016-12-01 | 2016-12-31 | 31 | 2016 | 115559008 | 48976 | 0 | TBC | monthly | 12 | |
38580 | 38580 | Philippines | Philippines | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 115559008 | 50476 | 0 | TBC | monthly | 1 | |
38581 | 38581 | Philippines | Philippines | 0 | 2017-02-01 | 2017-02-28 | 28 | 2017 | 115559008 | 44765 | 0 | TBC | monthly | 2 | |
38582 | 38582 | Philippines | Philippines | 0 | 2017-03-01 | 2017-03-31 | 31 | 2017 | 115559008 | 47136 | 0 | TBC | monthly | 3 | |
38583 | 38583 | Philippines | Philippines | 0 | 2017-04-01 | 2017-04-30 | 30 | 2017 | 115559008 | 46487 | 0 | TBC | monthly | 4 | |
38584 | 38584 | Philippines | Philippines | 0 | 2017-05-01 | 2017-05-31 | 31 | 2017 | 115559008 | 48141 | 0 | TBC | monthly | 5 | |
38585 | 38585 | Philippines | Philippines | 0 | 2017-06-01 | 2017-06-30 | 30 | 2017 | 115559008 | 46118 | 0 | TBC | monthly | 6 | |
38586 | 38586 | Philippines | Philippines | 0 | 2017-07-01 | 2017-07-31 | 31 | 2017 | 115559008 | 48913 | 0 | TBC | monthly | 7 | |
38587 | 38587 | Philippines | Philippines | 0 | 2017-08-01 | 2017-08-31 | 31 | 2017 | 115559008 | 51154 | 0 | TBC | monthly | 8 | |
38588 | 38588 | Philippines | Philippines | 0 | 2017-09-01 | 2017-09-30 | 30 | 2017 | 115559008 | 47870 | 0 | TBC | monthly | 9 | |
38589 | 38589 | Philippines | Philippines | 0 | 2017-10-01 | 2017-10-31 | 31 | 2017 | 115559008 | 49922 | 0 | TBC | monthly | 10 | |
38590 | 38590 | Philippines | Philippines | 0 | 2017-11-01 | 2017-11-30 | 30 | 2017 | 115559008 | 48225 | 0 | TBC | monthly | 11 | |
38591 | 38591 | Philippines | Philippines | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 115559008 | 50030 | 0 | TBC | monthly | 12 | |
38592 | 38592 | Philippines | Philippines | 0 | 2018-01-01 | 2018-01-31 | 31 | 2018 | 115559008 | 52126 | 0 | TBC | monthly | 1 | |
38593 | 38593 | Philippines | Philippines | 0 | 2018-02-01 | 2018-02-28 | 28 | 2018 | 115559008 | 45236 | 0 | TBC | monthly | 2 | |
38594 | 38594 | Philippines | Philippines | 0 | 2018-03-01 | 2018-03-31 | 31 | 2018 | 115559008 | 48366 | 0 | TBC | monthly | 3 | |
38595 | 38595 | Philippines | Philippines | 0 | 2018-04-01 | 2018-04-30 | 30 | 2018 | 115559008 | 47626 | 0 | TBC | monthly | 4 | |
38596 | 38596 | Philippines | Philippines | 0 | 2018-05-01 | 2018-05-31 | 31 | 2018 | 115559008 | 49662 | 0 | TBC | monthly | 5 | |
38597 | 38597 | Philippines | Philippines | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 115559008 | 46353 | 0 | TBC | monthly | 6 | |
38598 | 38598 | Philippines | Philippines | 0 | 2018-07-01 | 2018-07-31 | 31 | 2018 | 115559008 | 49424 | 0 | TBC | monthly | 7 | |
38599 | 38599 | Philippines | Philippines | 0 | 2018-08-01 | 2018-08-31 | 31 | 2018 | 115559008 | 51375 | 0 | TBC | monthly | 8 | |
38600 | 38600 | Philippines | Philippines | 0 | 2018-09-01 | 2018-09-30 | 30 | 2018 | 115559008 | 49444 | 0 | TBC | monthly | 9 | |
38601 | 38601 | Philippines | Philippines | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 115559008 | 50917 | 0 | TBC | monthly | 10 | |
38602 | 38602 | Philippines | Philippines | 0 | 2018-11-01 | 2018-11-30 | 30 | 2018 | 115559008 | 48736 | 0 | TBC | monthly | 11 | |
38603 | 38603 | Philippines | Philippines | 0 | 2018-12-01 | 2018-12-31 | 31 | 2018 | 115559008 | 51444 | 0 | TBC | monthly | 12 | |
38604 | 38604 | Philippines | Philippines | 0 | 2019-01-01 | 2019-01-31 | 31 | 2019 | 115559008 | 57701 | 0 | TBC | monthly | 1 | |
38605 | 38605 | Philippines | Philippines | 0 | 2019-02-01 | 2019-02-28 | 28 | 2019 | 115559008 | 48798 | 0 | TBC | monthly | 2 | |
38606 | 38606 | Philippines | Philippines | 0 | 2019-03-01 | 2019-03-31 | 31 | 2019 | 115559008 | 51109 | 0 | TBC | monthly | 3 | |
38607 | 38607 | Philippines | Philippines | 0 | 2019-04-01 | 2019-04-30 | 30 | 2019 | 115559008 | 50247 | 0 | TBC | monthly | 4 | |
38608 | 38608 | Philippines | Philippines | 0 | 2019-05-01 | 2019-05-31 | 31 | 2019 | 115559008 | 52108 | 0 | TBC | monthly | 5 | |
38609 | 38609 | Philippines | Philippines | 0 | 2019-06-01 | 2019-06-30 | 30 | 2019 | 115559008 | 49028 | 0 | TBC | monthly | 6 | |
38610 | 38610 | Philippines | Philippines | 0 | 2019-07-01 | 2019-07-31 | 31 | 2019 | 115559008 | 49494 | 0 | TBC | monthly | 7 | |
38611 | 38611 | Philippines | Philippines | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 115559008 | 50265 | 0 | TBC | monthly | 8 | |
38612 | 38612 | Philippines | Philippines | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 115559008 | 52035 | 0 | TBC | monthly | 9 | |
38613 | 38613 | Philippines | Philippines | 0 | 2019-10-01 | 2019-10-31 | 31 | 2019 | 115559008 | 54980 | 0 | TBC | monthly | 10 | |
38614 | 38614 | Philippines | Philippines | 0 | 2019-11-01 | 2019-11-30 | 30 | 2019 | 115559008 | 52787 | 0 | TBC | monthly | 11 | |
38615 | 38615 | Philippines | Philippines | 0 | 2019-12-01 | 2019-12-31 | 31 | 2019 | 115559008 | 51862 | 0 | TBC | monthly | 12 | |
38616 | 38616 | Philippines | Philippines | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 115559008 | 53500 | 0 | TBC | monthly | 1 | |
38617 | 38617 | Philippines | Philippines | 0 | 2020-02-01 | 2020-02-29 | 29 | 2020 | 115559008 | 46256 | 1 | TBC | monthly | 2 | |
38618 | 38618 | Philippines | Philippines | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 115559008 | 45996 | 89 | TBC | monthly | 3 | |
38619 | 38619 | Philippines | Philippines | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 115559008 | 44768 | 480 | TBC | monthly | 4 | |
38620 | 38620 | Philippines | Philippines | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 115559008 | 50251 | 389 | TBC | monthly | 5 | |
38621 | 38621 | Philippines | Philippines | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 115559008 | 48484 | 309 | TBC | monthly | 6 | |
38622 | 38622 | Philippines | Philippines | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 115559008 | 54412 | 757 | TBC | monthly | 7 | |
38623 | 38623 | Philippines | Philippines | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 115559008 | 56827 | 1535 | TBC | monthly | 8 | |
38624 | 38624 | Philippines | Philippines | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 115559008 | 53953 | 1946 | TBC | monthly | 9 | |
38625 | 38625 | Philippines | Philippines | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 115559008 | 54200 | 1717 | TBC | monthly | 10 | |
38626 | 38626 | Philippines | Philippines | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 115559008 | 51558 | 1171 | TBC | monthly | 11 | |
38627 | 38627 | Philippines | Philippines | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 115559008 | 53731 | 852 | TBC | monthly | 12 | |
38628 | 38628 | Philippines | Philippines | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 115559008 | 59993 | 1505 | TBC | monthly | 1 | |
38629 | 38629 | Philippines | Philippines | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 115559008 | 53861 | 1569 | TBC | monthly | 2 | |
38630 | 38630 | Philippines | Philippines | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 115559008 | 62558 | 979 | TBC | monthly | 3 | |
38631 | 38631 | Philippines | Philippines | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 115559008 | 70556 | 3937 | TBC | monthly | 4 | |
38632 | 38632 | Philippines | Philippines | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 115559008 | 71920 | 3732 | TBC | monthly | 5 | |
38633 | 38633 | Philippines | Philippines | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 115559008 | 68399 | 3696 | TBC | monthly | 6 | |
38634 | 38634 | Philippines | Philippines | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 115559008 | 75672 | 3227 | TBC | monthly | 7 | |
38635 | 38635 | Philippines | Philippines | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 115559008 | 97880 | 5559 | TBC | monthly | 8 | |
38636 | 38636 | Philippines | Philippines | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 115559008 | 119758 | 4846 | TBC | monthly | 9 | |
38637 | 38637 | Philippines | Philippines | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 115559008 | 84428 | 4878 | TBC | monthly | 10 | |
38638 | 38638 | Philippines | Philippines | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 115559008 | 58202 | 5373 | TBC | monthly | 11 | |
38639 | 38639 | Philippines | Philippines | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 115559008 | 56202 | 2959 | TBC | monthly | 12 | |
38640 | 38640 | Philippines | Philippines | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 115559008 | 69869 | 2499 | TBC | monthly | 1 | |
38641 | 38641 | Philippines | Philippines | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 115559008 | 52248 | 2448 | TBC | monthly | 2 | |
38642 | 38642 | Philippines | Philippines | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 115559008 | 51862 | 2798 | TBC | monthly | 3 | |
38643 | 38643 | Philippines | Philippines | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 115559008 | 50159 | 1092 | TBC | monthly | 4 | |
38644 | 38644 | Philippines | Philippines | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 115559008 | 53396 | 120 | TBC | monthly | 5 | |
38645 | 38645 | Philippines | Philippines | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 115559008 | 49353 | 100 | TBC | monthly | 6 |
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]);