economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
407 rows where country = "Mexico" sorted by days
This data as json, yaml, Notebook, copyable, CSV (advanced)
end_date (date) >30 ✖
- 2016-12-04 1
- 2016-12-11 1
- 2016-12-18 1
- 2016-12-25 1
- 2017-01-01 1
- 2017-01-08 1
- 2017-01-15 1
- 2017-01-22 1
- 2017-01-29 1
- 2017-02-05 1
- 2017-02-12 1
- 2017-02-19 1
- 2017-02-26 1
- 2017-03-05 1
- 2017-03-12 1
- 2017-03-19 1
- 2017-03-26 1
- 2017-04-02 1
- 2017-04-09 1
- 2017-04-16 1
- 2017-04-23 1
- 2017-04-30 1
- 2017-05-07 1
- 2017-05-14 1
- 2017-05-21 1
- 2017-05-28 1
- 2017-06-04 1
- 2017-06-11 1
- 2017-06-18 1
- 2017-06-25 1
- …
country 1
- Mexico · 307 ✖
cadence 1
- weekly 307
Link | rowid | country | region | region_code | start_date | end_date | days ▼ | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11795 | 11795 | Mexico | Mexico | 0 | 2016-11-28 | 2016-12-04 | 7 | 2016 | 48 | 127504120 | 13678 | 0 | TBC | weekly | |
11796 | 11796 | Mexico | Mexico | 0 | 2016-12-05 | 2016-12-11 | 7 | 2016 | 49 | 127504120 | 13396 | 0 | TBC | weekly | |
11797 | 11797 | Mexico | Mexico | 0 | 2016-12-12 | 2016-12-18 | 7 | 2016 | 50 | 127504120 | 13697 | 0 | TBC | weekly | |
11798 | 11798 | Mexico | Mexico | 0 | 2016-12-19 | 2016-12-25 | 7 | 2016 | 51 | 127504120 | 13784 | 0 | TBC | weekly | |
11799 | 11799 | Mexico | Mexico | 0 | 2016-12-26 | 2017-01-01 | 7 | 2016 | 52 | 127504120 | 14313 | 0 | TBC | weekly | |
11800 | 11800 | Mexico | Mexico | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 127504120 | 14312 | 0 | TBC | weekly | |
11801 | 11801 | Mexico | Mexico | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 127504120 | 14583 | 0 | TBC | weekly | |
11802 | 11802 | Mexico | Mexico | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 127504120 | 14163 | 0 | TBC | weekly | |
11803 | 11803 | Mexico | Mexico | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 127504120 | 14118 | 0 | TBC | weekly | |
11804 | 11804 | Mexico | Mexico | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 127504120 | 14444 | 0 | TBC | weekly | |
11805 | 11805 | Mexico | Mexico | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 127504120 | 14330 | 0 | TBC | weekly | |
11806 | 11806 | Mexico | Mexico | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 127504120 | 14165 | 0 | TBC | weekly | |
11807 | 11807 | Mexico | Mexico | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 127504120 | 14278 | 0 | TBC | weekly | |
11808 | 11808 | Mexico | Mexico | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 127504120 | 14456 | 0 | TBC | weekly | |
11809 | 11809 | Mexico | Mexico | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 127504120 | 13844 | 0 | TBC | weekly | |
11810 | 11810 | Mexico | Mexico | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 127504120 | 13948 | 0 | TBC | weekly | |
11811 | 11811 | Mexico | Mexico | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 127504120 | 13878 | 0 | TBC | weekly | |
11812 | 11812 | Mexico | Mexico | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 127504120 | 13307 | 0 | TBC | weekly | |
11813 | 11813 | Mexico | Mexico | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 127504120 | 13470 | 0 | TBC | weekly | |
11814 | 11814 | Mexico | Mexico | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 127504120 | 13210 | 0 | TBC | weekly | |
11815 | 11815 | Mexico | Mexico | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 127504120 | 13212 | 0 | TBC | weekly | |
11816 | 11816 | Mexico | Mexico | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 127504120 | 13363 | 0 | TBC | weekly | |
11817 | 11817 | Mexico | Mexico | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 127504120 | 13016 | 0 | TBC | weekly | |
11818 | 11818 | Mexico | Mexico | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 127504120 | 12868 | 0 | TBC | weekly | |
11819 | 11819 | Mexico | Mexico | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 127504120 | 13361 | 0 | TBC | weekly | |
11820 | 11820 | Mexico | Mexico | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 127504120 | 13165 | 0 | TBC | weekly | |
11821 | 11821 | Mexico | Mexico | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 127504120 | 12510 | 0 | TBC | weekly | |
11822 | 11822 | Mexico | Mexico | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 127504120 | 12753 | 0 | TBC | weekly | |
11823 | 11823 | Mexico | Mexico | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 127504120 | 12724 | 0 | TBC | weekly | |
11824 | 11824 | Mexico | Mexico | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 127504120 | 13154 | 0 | TBC | weekly | |
11825 | 11825 | Mexico | Mexico | 0 | 2017-06-26 | 2017-07-02 | 7 | 2017 | 26 | 127504120 | 12736 | 0 | TBC | weekly | |
11826 | 11826 | Mexico | Mexico | 0 | 2017-07-03 | 2017-07-09 | 7 | 2017 | 27 | 127504120 | 12502 | 0 | TBC | weekly | |
11827 | 11827 | Mexico | Mexico | 0 | 2017-07-10 | 2017-07-16 | 7 | 2017 | 28 | 127504120 | 12822 | 0 | TBC | weekly | |
11828 | 11828 | Mexico | Mexico | 0 | 2017-07-17 | 2017-07-23 | 7 | 2017 | 29 | 127504120 | 12512 | 0 | TBC | weekly | |
11829 | 11829 | Mexico | Mexico | 0 | 2017-07-24 | 2017-07-30 | 7 | 2017 | 30 | 127504120 | 12923 | 0 | TBC | weekly | |
11830 | 11830 | Mexico | Mexico | 0 | 2017-07-31 | 2017-08-06 | 7 | 2017 | 31 | 127504120 | 12967 | 0 | TBC | weekly | |
11831 | 11831 | Mexico | Mexico | 0 | 2017-08-07 | 2017-08-13 | 7 | 2017 | 32 | 127504120 | 12464 | 0 | TBC | weekly | |
11832 | 11832 | Mexico | Mexico | 0 | 2017-08-14 | 2017-08-20 | 7 | 2017 | 33 | 127504120 | 12638 | 0 | TBC | weekly | |
11833 | 11833 | Mexico | Mexico | 0 | 2017-08-21 | 2017-08-27 | 7 | 2017 | 34 | 127504120 | 12432 | 0 | TBC | weekly | |
11834 | 11834 | Mexico | Mexico | 0 | 2017-08-28 | 2017-09-03 | 7 | 2017 | 35 | 127504120 | 12172 | 0 | TBC | weekly | |
11835 | 11835 | Mexico | Mexico | 0 | 2017-09-04 | 2017-09-10 | 7 | 2017 | 36 | 127504120 | 12933 | 0 | TBC | weekly | |
11836 | 11836 | Mexico | Mexico | 0 | 2017-09-11 | 2017-09-17 | 7 | 2017 | 37 | 127504120 | 13333 | 0 | TBC | weekly | |
11837 | 11837 | Mexico | Mexico | 0 | 2017-09-18 | 2017-09-24 | 7 | 2017 | 38 | 127504120 | 13164 | 0 | TBC | weekly | |
11838 | 11838 | Mexico | Mexico | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 127504120 | 12604 | 0 | TBC | weekly | |
11839 | 11839 | Mexico | Mexico | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 127504120 | 13026 | 0 | TBC | weekly | |
11840 | 11840 | Mexico | Mexico | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 127504120 | 13031 | 0 | TBC | weekly | |
11841 | 11841 | Mexico | Mexico | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 127504120 | 13390 | 0 | TBC | weekly | |
11842 | 11842 | Mexico | Mexico | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 127504120 | 13216 | 0 | TBC | weekly | |
11843 | 11843 | Mexico | Mexico | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 127504120 | 13538 | 0 | TBC | weekly | |
11844 | 11844 | Mexico | Mexico | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 127504120 | 13258 | 0 | TBC | weekly | |
11845 | 11845 | Mexico | Mexico | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 127504120 | 13197 | 0 | TBC | weekly | |
11846 | 11846 | Mexico | Mexico | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 127504120 | 13584 | 0 | TBC | weekly | |
11847 | 11847 | Mexico | Mexico | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 127504120 | 14233 | 0 | TBC | weekly | |
11848 | 11848 | Mexico | Mexico | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 127504120 | 14470 | 0 | TBC | weekly | |
11849 | 11849 | Mexico | Mexico | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 127504120 | 16334 | 0 | TBC | weekly | |
11850 | 11850 | Mexico | Mexico | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 127504120 | 15557 | 0 | TBC | weekly | |
11851 | 11851 | Mexico | Mexico | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 127504120 | 15492 | 0 | TBC | weekly | |
11852 | 11852 | Mexico | Mexico | 0 | 2018-01-01 | 2018-01-07 | 7 | 2018 | 1 | 127504120 | 16721 | 0 | TBC | weekly | |
11853 | 11853 | Mexico | Mexico | 0 | 2018-01-08 | 2018-01-14 | 7 | 2018 | 2 | 127504120 | 16170 | 0 | TBC | weekly | |
11854 | 11854 | Mexico | Mexico | 0 | 2018-01-15 | 2018-01-21 | 7 | 2018 | 3 | 127504120 | 16738 | 0 | TBC | weekly | |
11855 | 11855 | Mexico | Mexico | 0 | 2018-01-22 | 2018-01-28 | 7 | 2018 | 4 | 127504120 | 16041 | 0 | TBC | weekly | |
11856 | 11856 | Mexico | Mexico | 0 | 2018-01-29 | 2018-02-04 | 7 | 2018 | 5 | 127504120 | 15770 | 0 | TBC | weekly | |
11857 | 11857 | Mexico | Mexico | 0 | 2018-02-05 | 2018-02-11 | 7 | 2018 | 6 | 127504120 | 15306 | 0 | TBC | weekly | |
11858 | 11858 | Mexico | Mexico | 0 | 2018-02-12 | 2018-02-18 | 7 | 2018 | 7 | 127504120 | 14588 | 0 | TBC | weekly | |
11859 | 11859 | Mexico | Mexico | 0 | 2018-02-19 | 2018-02-25 | 7 | 2018 | 8 | 127504120 | 14199 | 0 | TBC | weekly | |
11860 | 11860 | Mexico | Mexico | 0 | 2018-02-26 | 2018-03-04 | 7 | 2018 | 9 | 127504120 | 14001 | 0 | TBC | weekly | |
11861 | 11861 | Mexico | Mexico | 0 | 2018-03-05 | 2018-03-11 | 7 | 2018 | 10 | 127504120 | 13552 | 0 | TBC | weekly | |
11862 | 11862 | Mexico | Mexico | 0 | 2018-03-12 | 2018-03-18 | 7 | 2018 | 11 | 127504120 | 13497 | 0 | TBC | weekly | |
11863 | 11863 | Mexico | Mexico | 0 | 2018-03-19 | 2018-03-25 | 7 | 2018 | 12 | 127504120 | 13254 | 0 | TBC | weekly | |
11864 | 11864 | Mexico | Mexico | 0 | 2018-03-26 | 2018-04-01 | 7 | 2018 | 13 | 127504120 | 13191 | 0 | TBC | weekly | |
11865 | 11865 | Mexico | Mexico | 0 | 2018-04-02 | 2018-04-08 | 7 | 2018 | 14 | 127504120 | 13577 | 0 | TBC | weekly | |
11866 | 11866 | Mexico | Mexico | 0 | 2018-04-09 | 2018-04-15 | 7 | 2018 | 15 | 127504120 | 12888 | 0 | TBC | weekly | |
11867 | 11867 | Mexico | Mexico | 0 | 2018-04-16 | 2018-04-22 | 7 | 2018 | 16 | 127504120 | 13080 | 0 | TBC | weekly | |
11868 | 11868 | Mexico | Mexico | 0 | 2018-04-23 | 2018-04-29 | 7 | 2018 | 17 | 127504120 | 12657 | 0 | TBC | weekly | |
11869 | 11869 | Mexico | Mexico | 0 | 2018-04-30 | 2018-05-06 | 7 | 2018 | 18 | 127504120 | 13040 | 0 | TBC | weekly | |
11870 | 11870 | Mexico | Mexico | 0 | 2018-05-07 | 2018-05-13 | 7 | 2018 | 19 | 127504120 | 12784 | 0 | TBC | weekly | |
11871 | 11871 | Mexico | Mexico | 0 | 2018-05-14 | 2018-05-20 | 7 | 2018 | 20 | 127504120 | 13172 | 0 | TBC | weekly | |
11872 | 11872 | Mexico | Mexico | 0 | 2018-05-21 | 2018-05-27 | 7 | 2018 | 21 | 127504120 | 13125 | 0 | TBC | weekly | |
11873 | 11873 | Mexico | Mexico | 0 | 2018-05-28 | 2018-06-03 | 7 | 2018 | 22 | 127504120 | 13567 | 0 | TBC | weekly | |
11874 | 11874 | Mexico | Mexico | 0 | 2018-06-04 | 2018-06-10 | 7 | 2018 | 23 | 127504120 | 13025 | 0 | TBC | weekly | |
11875 | 11875 | Mexico | Mexico | 0 | 2018-06-11 | 2018-06-17 | 7 | 2018 | 24 | 127504120 | 12451 | 0 | TBC | weekly | |
11876 | 11876 | Mexico | Mexico | 0 | 2018-06-18 | 2018-06-24 | 7 | 2018 | 25 | 127504120 | 12932 | 0 | TBC | weekly | |
11877 | 11877 | Mexico | Mexico | 0 | 2018-06-25 | 2018-07-01 | 7 | 2018 | 26 | 127504120 | 12610 | 0 | TBC | weekly | |
11878 | 11878 | Mexico | Mexico | 0 | 2018-07-02 | 2018-07-08 | 7 | 2018 | 27 | 127504120 | 12845 | 0 | TBC | weekly | |
11879 | 11879 | Mexico | Mexico | 0 | 2018-07-09 | 2018-07-15 | 7 | 2018 | 28 | 127504120 | 13114 | 0 | TBC | weekly | |
11880 | 11880 | Mexico | Mexico | 0 | 2018-07-16 | 2018-07-22 | 7 | 2018 | 29 | 127504120 | 13334 | 0 | TBC | weekly | |
11881 | 11881 | Mexico | Mexico | 0 | 2018-07-23 | 2018-07-29 | 7 | 2018 | 30 | 127504120 | 13455 | 0 | TBC | weekly | |
11882 | 11882 | Mexico | Mexico | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 127504120 | 12997 | 0 | TBC | weekly | |
11883 | 11883 | Mexico | Mexico | 0 | 2018-08-06 | 2018-08-12 | 7 | 2018 | 32 | 127504120 | 12602 | 0 | TBC | weekly | |
11884 | 11884 | Mexico | Mexico | 0 | 2018-08-13 | 2018-08-19 | 7 | 2018 | 33 | 127504120 | 12767 | 0 | TBC | weekly | |
11885 | 11885 | Mexico | Mexico | 0 | 2018-08-20 | 2018-08-26 | 7 | 2018 | 34 | 127504120 | 12503 | 0 | TBC | weekly | |
11886 | 11886 | Mexico | Mexico | 0 | 2018-08-27 | 2018-09-02 | 7 | 2018 | 35 | 127504120 | 12811 | 0 | TBC | weekly | |
11887 | 11887 | Mexico | Mexico | 0 | 2018-09-03 | 2018-09-09 | 7 | 2018 | 36 | 127504120 | 12556 | 0 | TBC | weekly | |
11888 | 11888 | Mexico | Mexico | 0 | 2018-09-10 | 2018-09-16 | 7 | 2018 | 37 | 127504120 | 12780 | 0 | TBC | weekly | |
11889 | 11889 | Mexico | Mexico | 0 | 2018-09-17 | 2018-09-23 | 7 | 2018 | 38 | 127504120 | 12994 | 0 | TBC | weekly | |
11890 | 11890 | Mexico | Mexico | 0 | 2018-09-24 | 2018-09-30 | 7 | 2018 | 39 | 127504120 | 12807 | 0 | TBC | weekly | |
11891 | 11891 | Mexico | Mexico | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 127504120 | 12931 | 0 | TBC | weekly | |
11892 | 11892 | Mexico | Mexico | 0 | 2018-10-08 | 2018-10-14 | 7 | 2018 | 41 | 127504120 | 13232 | 0 | TBC | weekly | |
11893 | 11893 | Mexico | Mexico | 0 | 2018-10-15 | 2018-10-21 | 7 | 2018 | 42 | 127504120 | 13115 | 0 | TBC | weekly | |
11894 | 11894 | Mexico | Mexico | 0 | 2018-10-22 | 2018-10-28 | 7 | 2018 | 43 | 127504120 | 13435 | 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]);