economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
407 rows where country = "Mexico"
This data as json, yaml, Notebook, copyable, CSV (advanced)
start_date (date) >30 ✖
- 2014-12-29 1
- 2015-01-05 1
- 2015-01-12 1
- 2015-01-19 1
- 2015-01-26 1
- 2015-02-02 1
- 2015-02-09 1
- 2015-02-16 1
- 2015-02-23 1
- 2015-03-02 1
- 2015-03-09 1
- 2015-03-16 1
- 2015-03-23 1
- 2015-03-30 1
- 2015-04-06 1
- 2015-04-13 1
- 2015-04-20 1
- 2015-04-27 1
- 2015-05-04 1
- 2015-05-11 1
- 2015-05-18 1
- 2015-05-25 1
- 2015-06-01 1
- 2015-06-08 1
- 2015-06-15 1
- 2015-06-22 1
- 2015-06-29 1
- 2015-07-06 1
- 2015-07-13 1
- 2015-07-20 1
- …
end_date (date) >30 ✖
- 2015-01-04 1
- 2015-01-11 1
- 2015-01-18 1
- 2015-01-25 1
- 2015-02-01 1
- 2015-02-08 1
- 2015-02-15 1
- 2015-02-22 1
- 2015-03-01 1
- 2015-03-08 1
- 2015-03-15 1
- 2015-03-22 1
- 2015-03-29 1
- 2015-04-05 1
- 2015-04-12 1
- 2015-04-19 1
- 2015-04-26 1
- 2015-05-03 1
- 2015-05-10 1
- 2015-05-17 1
- 2015-05-24 1
- 2015-05-31 1
- 2015-06-07 1
- 2015-06-14 1
- 2015-06-21 1
- 2015-06-28 1
- 2015-07-05 1
- 2015-07-12 1
- 2015-07-19 1
- 2015-07-26 1
- …
country 1
- Mexico · 407 ✖
cadence 1
- weekly 407
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11695 | 11695 | Mexico | Mexico | 0 | 2014-12-29 | 2015-01-04 | 7 | 2015 | 1 | 127504120 | 15101 | 0 | TBC | weekly | |
11696 | 11696 | Mexico | Mexico | 0 | 2015-01-05 | 2015-01-11 | 7 | 2015 | 2 | 127504120 | 15449 | 0 | TBC | weekly | |
11697 | 11697 | Mexico | Mexico | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 127504120 | 14820 | 0 | TBC | weekly | |
11698 | 11698 | Mexico | Mexico | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 127504120 | 14172 | 0 | TBC | weekly | |
11699 | 11699 | Mexico | Mexico | 0 | 2015-01-26 | 2015-02-01 | 7 | 2015 | 5 | 127504120 | 13628 | 0 | TBC | weekly | |
11700 | 11700 | Mexico | Mexico | 0 | 2015-02-02 | 2015-02-08 | 7 | 2015 | 6 | 127504120 | 13914 | 0 | TBC | weekly | |
11701 | 11701 | Mexico | Mexico | 0 | 2015-02-09 | 2015-02-15 | 7 | 2015 | 7 | 127504120 | 13550 | 0 | TBC | weekly | |
11702 | 11702 | Mexico | Mexico | 0 | 2015-02-16 | 2015-02-22 | 7 | 2015 | 8 | 127504120 | 13799 | 0 | TBC | weekly | |
11703 | 11703 | Mexico | Mexico | 0 | 2015-02-23 | 2015-03-01 | 7 | 2015 | 9 | 127504120 | 13054 | 0 | TBC | weekly | |
11704 | 11704 | Mexico | Mexico | 0 | 2015-03-02 | 2015-03-08 | 7 | 2015 | 10 | 127504120 | 12979 | 0 | TBC | weekly | |
11705 | 11705 | Mexico | Mexico | 0 | 2015-03-09 | 2015-03-15 | 7 | 2015 | 11 | 127504120 | 12498 | 0 | TBC | weekly | |
11706 | 11706 | Mexico | Mexico | 0 | 2015-03-16 | 2015-03-22 | 7 | 2015 | 12 | 127504120 | 13133 | 0 | TBC | weekly | |
11707 | 11707 | Mexico | Mexico | 0 | 2015-03-23 | 2015-03-29 | 7 | 2015 | 13 | 127504120 | 12066 | 0 | TBC | weekly | |
11708 | 11708 | Mexico | Mexico | 0 | 2015-03-30 | 2015-04-05 | 7 | 2015 | 14 | 127504120 | 12477 | 0 | TBC | weekly | |
11709 | 11709 | Mexico | Mexico | 0 | 2015-04-06 | 2015-04-12 | 7 | 2015 | 15 | 127504120 | 12202 | 0 | TBC | weekly | |
11710 | 11710 | Mexico | Mexico | 0 | 2015-04-13 | 2015-04-19 | 7 | 2015 | 16 | 127504120 | 11796 | 0 | TBC | weekly | |
11711 | 11711 | Mexico | Mexico | 0 | 2015-04-20 | 2015-04-26 | 7 | 2015 | 17 | 127504120 | 12403 | 0 | TBC | weekly | |
11712 | 11712 | Mexico | Mexico | 0 | 2015-04-27 | 2015-05-03 | 7 | 2015 | 18 | 127504120 | 11763 | 0 | TBC | weekly | |
11713 | 11713 | Mexico | Mexico | 0 | 2015-05-04 | 2015-05-10 | 7 | 2015 | 19 | 127504120 | 12059 | 0 | TBC | weekly | |
11714 | 11714 | Mexico | Mexico | 0 | 2015-05-11 | 2015-05-17 | 7 | 2015 | 20 | 127504120 | 11732 | 0 | TBC | weekly | |
11715 | 11715 | Mexico | Mexico | 0 | 2015-05-18 | 2015-05-24 | 7 | 2015 | 21 | 127504120 | 11856 | 0 | TBC | weekly | |
11716 | 11716 | Mexico | Mexico | 0 | 2015-05-25 | 2015-05-31 | 7 | 2015 | 22 | 127504120 | 11608 | 0 | TBC | weekly | |
11717 | 11717 | Mexico | Mexico | 0 | 2015-06-01 | 2015-06-07 | 7 | 2015 | 23 | 127504120 | 11876 | 0 | TBC | weekly | |
11718 | 11718 | Mexico | Mexico | 0 | 2015-06-08 | 2015-06-14 | 7 | 2015 | 24 | 127504120 | 11709 | 0 | TBC | weekly | |
11719 | 11719 | Mexico | Mexico | 0 | 2015-06-15 | 2015-06-21 | 7 | 2015 | 25 | 127504120 | 11510 | 0 | TBC | weekly | |
11720 | 11720 | Mexico | Mexico | 0 | 2015-06-22 | 2015-06-28 | 7 | 2015 | 26 | 127504120 | 11571 | 0 | TBC | weekly | |
11721 | 11721 | Mexico | Mexico | 0 | 2015-06-29 | 2015-07-05 | 7 | 2015 | 27 | 127504120 | 11583 | 0 | TBC | weekly | |
11722 | 11722 | Mexico | Mexico | 0 | 2015-07-06 | 2015-07-12 | 7 | 2015 | 28 | 127504120 | 11538 | 0 | TBC | weekly | |
11723 | 11723 | Mexico | Mexico | 0 | 2015-07-13 | 2015-07-19 | 7 | 2015 | 29 | 127504120 | 12003 | 0 | TBC | weekly | |
11724 | 11724 | Mexico | Mexico | 0 | 2015-07-20 | 2015-07-26 | 7 | 2015 | 30 | 127504120 | 11947 | 0 | TBC | weekly | |
11725 | 11725 | Mexico | Mexico | 0 | 2015-07-27 | 2015-08-02 | 7 | 2015 | 31 | 127504120 | 12083 | 0 | TBC | weekly | |
11726 | 11726 | Mexico | Mexico | 0 | 2015-08-03 | 2015-08-09 | 7 | 2015 | 32 | 127504120 | 12237 | 0 | TBC | weekly | |
11727 | 11727 | Mexico | Mexico | 0 | 2015-08-10 | 2015-08-16 | 7 | 2015 | 33 | 127504120 | 11739 | 0 | TBC | weekly | |
11728 | 11728 | Mexico | Mexico | 0 | 2015-08-17 | 2015-08-23 | 7 | 2015 | 34 | 127504120 | 11670 | 0 | TBC | weekly | |
11729 | 11729 | Mexico | Mexico | 0 | 2015-08-24 | 2015-08-30 | 7 | 2015 | 35 | 127504120 | 11680 | 0 | TBC | weekly | |
11730 | 11730 | Mexico | Mexico | 0 | 2015-08-31 | 2015-09-06 | 7 | 2015 | 36 | 127504120 | 11668 | 0 | TBC | weekly | |
11731 | 11731 | Mexico | Mexico | 0 | 2015-09-07 | 2015-09-13 | 7 | 2015 | 37 | 127504120 | 11814 | 0 | TBC | weekly | |
11732 | 11732 | Mexico | Mexico | 0 | 2015-09-14 | 2015-09-20 | 7 | 2015 | 38 | 127504120 | 11957 | 0 | TBC | weekly | |
11733 | 11733 | Mexico | Mexico | 0 | 2015-09-21 | 2015-09-27 | 7 | 2015 | 39 | 127504120 | 11560 | 0 | TBC | weekly | |
11734 | 11734 | Mexico | Mexico | 0 | 2015-09-28 | 2015-10-04 | 7 | 2015 | 40 | 127504120 | 12484 | 0 | TBC | weekly | |
11735 | 11735 | Mexico | Mexico | 0 | 2015-10-05 | 2015-10-11 | 7 | 2015 | 41 | 127504120 | 12397 | 0 | TBC | weekly | |
11736 | 11736 | Mexico | Mexico | 0 | 2015-10-12 | 2015-10-18 | 7 | 2015 | 42 | 127504120 | 12063 | 0 | TBC | weekly | |
11737 | 11737 | Mexico | Mexico | 0 | 2015-10-19 | 2015-10-25 | 7 | 2015 | 43 | 127504120 | 12221 | 0 | TBC | weekly | |
11738 | 11738 | Mexico | Mexico | 0 | 2015-10-26 | 2015-11-01 | 7 | 2015 | 44 | 127504120 | 12153 | 0 | TBC | weekly | |
11739 | 11739 | Mexico | Mexico | 0 | 2015-11-02 | 2015-11-08 | 7 | 2015 | 45 | 127504120 | 12543 | 0 | TBC | weekly | |
11740 | 11740 | Mexico | Mexico | 0 | 2015-11-09 | 2015-11-15 | 7 | 2015 | 46 | 127504120 | 12217 | 0 | TBC | weekly | |
11741 | 11741 | Mexico | Mexico | 0 | 2015-11-16 | 2015-11-22 | 7 | 2015 | 47 | 127504120 | 12542 | 0 | TBC | weekly | |
11742 | 11742 | Mexico | Mexico | 0 | 2015-11-23 | 2015-11-29 | 7 | 2015 | 48 | 127504120 | 12597 | 0 | TBC | weekly | |
11743 | 11743 | Mexico | Mexico | 0 | 2015-11-30 | 2015-12-06 | 7 | 2015 | 49 | 127504120 | 12830 | 0 | TBC | weekly | |
11744 | 11744 | Mexico | Mexico | 0 | 2015-12-07 | 2015-12-13 | 7 | 2015 | 50 | 127504120 | 13526 | 0 | TBC | weekly | |
11745 | 11745 | Mexico | Mexico | 0 | 2015-12-14 | 2015-12-20 | 7 | 2015 | 51 | 127504120 | 13542 | 0 | TBC | weekly | |
11746 | 11746 | Mexico | Mexico | 0 | 2015-12-21 | 2015-12-27 | 7 | 2015 | 52 | 127504120 | 14351 | 0 | TBC | weekly | |
11747 | 11747 | Mexico | Mexico | 0 | 2015-12-28 | 2016-01-03 | 7 | 2015 | 53 | 127504120 | 14170 | 0 | TBC | weekly | |
11748 | 11748 | Mexico | Mexico | 0 | 2016-01-04 | 2016-01-10 | 7 | 2016 | 1 | 127504120 | 14299 | 0 | TBC | weekly | |
11749 | 11749 | Mexico | Mexico | 0 | 2016-01-11 | 2016-01-17 | 7 | 2016 | 2 | 127504120 | 14540 | 0 | TBC | weekly | |
11750 | 11750 | Mexico | Mexico | 0 | 2016-01-18 | 2016-01-24 | 7 | 2016 | 3 | 127504120 | 14557 | 0 | TBC | weekly | |
11751 | 11751 | Mexico | Mexico | 0 | 2016-01-25 | 2016-01-31 | 7 | 2016 | 4 | 127504120 | 14902 | 0 | TBC | weekly | |
11752 | 11752 | Mexico | Mexico | 0 | 2016-02-01 | 2016-02-07 | 7 | 2016 | 5 | 127504120 | 15160 | 0 | TBC | weekly | |
11753 | 11753 | Mexico | Mexico | 0 | 2016-02-08 | 2016-02-14 | 7 | 2016 | 6 | 127504120 | 15691 | 0 | TBC | weekly | |
11754 | 11754 | Mexico | Mexico | 0 | 2016-02-15 | 2016-02-21 | 7 | 2016 | 7 | 127504120 | 15725 | 0 | TBC | weekly | |
11755 | 11755 | Mexico | Mexico | 0 | 2016-02-22 | 2016-02-28 | 7 | 2016 | 8 | 127504120 | 15034 | 0 | TBC | weekly | |
11756 | 11756 | Mexico | Mexico | 0 | 2016-02-29 | 2016-03-06 | 7 | 2016 | 9 | 127504120 | 14797 | 0 | TBC | weekly | |
11757 | 11757 | Mexico | Mexico | 0 | 2016-03-07 | 2016-03-13 | 7 | 2016 | 10 | 127504120 | 14351 | 0 | TBC | weekly | |
11758 | 11758 | Mexico | Mexico | 0 | 2016-03-14 | 2016-03-20 | 7 | 2016 | 11 | 127504120 | 14025 | 0 | TBC | weekly | |
11759 | 11759 | Mexico | Mexico | 0 | 2016-03-21 | 2016-03-27 | 7 | 2016 | 12 | 127504120 | 13418 | 0 | TBC | weekly | |
11760 | 11760 | Mexico | Mexico | 0 | 2016-03-28 | 2016-04-03 | 7 | 2016 | 13 | 127504120 | 13411 | 0 | TBC | weekly | |
11761 | 11761 | Mexico | Mexico | 0 | 2016-04-04 | 2016-04-10 | 7 | 2016 | 14 | 127504120 | 12710 | 0 | TBC | weekly | |
11762 | 11762 | Mexico | Mexico | 0 | 2016-04-11 | 2016-04-17 | 7 | 2016 | 15 | 127504120 | 12422 | 0 | TBC | weekly | |
11763 | 11763 | Mexico | Mexico | 0 | 2016-04-18 | 2016-04-24 | 7 | 2016 | 16 | 127504120 | 11939 | 0 | TBC | weekly | |
11764 | 11764 | Mexico | Mexico | 0 | 2016-04-25 | 2016-05-01 | 7 | 2016 | 17 | 127504120 | 12481 | 0 | TBC | weekly | |
11765 | 11765 | Mexico | Mexico | 0 | 2016-05-02 | 2016-05-08 | 7 | 2016 | 18 | 127504120 | 12723 | 0 | TBC | weekly | |
11766 | 11766 | Mexico | Mexico | 0 | 2016-05-09 | 2016-05-15 | 7 | 2016 | 19 | 127504120 | 12478 | 0 | TBC | weekly | |
11767 | 11767 | Mexico | Mexico | 0 | 2016-05-16 | 2016-05-22 | 7 | 2016 | 20 | 127504120 | 12483 | 0 | TBC | weekly | |
11768 | 11768 | Mexico | Mexico | 0 | 2016-05-23 | 2016-05-29 | 7 | 2016 | 21 | 127504120 | 13019 | 0 | TBC | weekly | |
11769 | 11769 | Mexico | Mexico | 0 | 2016-05-30 | 2016-06-05 | 7 | 2016 | 22 | 127504120 | 12222 | 0 | TBC | weekly | |
11770 | 11770 | Mexico | Mexico | 0 | 2016-06-06 | 2016-06-12 | 7 | 2016 | 23 | 127504120 | 12011 | 0 | TBC | weekly | |
11771 | 11771 | Mexico | Mexico | 0 | 2016-06-13 | 2016-06-19 | 7 | 2016 | 24 | 127504120 | 11994 | 0 | TBC | weekly | |
11772 | 11772 | Mexico | Mexico | 0 | 2016-06-20 | 2016-06-26 | 7 | 2016 | 25 | 127504120 | 12117 | 0 | TBC | weekly | |
11773 | 11773 | Mexico | Mexico | 0 | 2016-06-27 | 2016-07-03 | 7 | 2016 | 26 | 127504120 | 12203 | 0 | TBC | weekly | |
11774 | 11774 | Mexico | Mexico | 0 | 2016-07-04 | 2016-07-10 | 7 | 2016 | 27 | 127504120 | 12439 | 0 | TBC | weekly | |
11775 | 11775 | Mexico | Mexico | 0 | 2016-07-11 | 2016-07-17 | 7 | 2016 | 28 | 127504120 | 12241 | 0 | TBC | weekly | |
11776 | 11776 | Mexico | Mexico | 0 | 2016-07-18 | 2016-07-24 | 7 | 2016 | 29 | 127504120 | 12316 | 0 | TBC | weekly | |
11777 | 11777 | Mexico | Mexico | 0 | 2016-07-25 | 2016-07-31 | 7 | 2016 | 30 | 127504120 | 12141 | 0 | TBC | weekly | |
11778 | 11778 | Mexico | Mexico | 0 | 2016-08-01 | 2016-08-07 | 7 | 2016 | 31 | 127504120 | 12456 | 0 | TBC | weekly | |
11779 | 11779 | Mexico | Mexico | 0 | 2016-08-08 | 2016-08-14 | 7 | 2016 | 32 | 127504120 | 12173 | 0 | TBC | weekly | |
11780 | 11780 | Mexico | Mexico | 0 | 2016-08-15 | 2016-08-21 | 7 | 2016 | 33 | 127504120 | 12261 | 0 | TBC | weekly | |
11781 | 11781 | Mexico | Mexico | 0 | 2016-08-22 | 2016-08-28 | 7 | 2016 | 34 | 127504120 | 12245 | 0 | TBC | weekly | |
11782 | 11782 | Mexico | Mexico | 0 | 2016-08-29 | 2016-09-04 | 7 | 2016 | 35 | 127504120 | 12137 | 0 | TBC | weekly | |
11783 | 11783 | Mexico | Mexico | 0 | 2016-09-05 | 2016-09-11 | 7 | 2016 | 36 | 127504120 | 12285 | 0 | TBC | weekly | |
11784 | 11784 | Mexico | Mexico | 0 | 2016-09-12 | 2016-09-18 | 7 | 2016 | 37 | 127504120 | 12491 | 0 | TBC | weekly | |
11785 | 11785 | Mexico | Mexico | 0 | 2016-09-19 | 2016-09-25 | 7 | 2016 | 38 | 127504120 | 12203 | 0 | TBC | weekly | |
11786 | 11786 | Mexico | Mexico | 0 | 2016-09-26 | 2016-10-02 | 7 | 2016 | 39 | 127504120 | 12300 | 0 | TBC | weekly | |
11787 | 11787 | Mexico | Mexico | 0 | 2016-10-03 | 2016-10-09 | 7 | 2016 | 40 | 127504120 | 12500 | 0 | TBC | weekly | |
11788 | 11788 | Mexico | Mexico | 0 | 2016-10-10 | 2016-10-16 | 7 | 2016 | 41 | 127504120 | 12201 | 0 | TBC | weekly | |
11789 | 11789 | Mexico | Mexico | 0 | 2016-10-17 | 2016-10-23 | 7 | 2016 | 42 | 127504120 | 12365 | 0 | TBC | weekly | |
11790 | 11790 | Mexico | Mexico | 0 | 2016-10-24 | 2016-10-30 | 7 | 2016 | 43 | 127504120 | 12506 | 0 | TBC | weekly | |
11791 | 11791 | Mexico | Mexico | 0 | 2016-10-31 | 2016-11-06 | 7 | 2016 | 44 | 127504120 | 12735 | 0 | TBC | weekly | |
11792 | 11792 | Mexico | Mexico | 0 | 2016-11-07 | 2016-11-13 | 7 | 2016 | 45 | 127504120 | 12478 | 0 | TBC | weekly | |
11793 | 11793 | Mexico | Mexico | 0 | 2016-11-14 | 2016-11-20 | 7 | 2016 | 46 | 127504120 | 12837 | 0 | TBC | weekly | |
11794 | 11794 | Mexico | Mexico | 0 | 2016-11-21 | 2016-11-27 | 7 | 2016 | 47 | 127504120 | 13616 | 0 | TBC | weekly |
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]);