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 rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▲ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12001 | 12001 | Mexico | Mexico | 0 | 2020-11-09 | 2020-11-15 | 7 | 2020 | 46 | 127504120 | 21843 | 3515 | TBC | weekly | |
12000 | 12000 | Mexico | Mexico | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 127504120 | 21571 | 3132 | TBC | weekly | |
11999 | 11999 | Mexico | Mexico | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 127504120 | 20459 | 2971 | TBC | weekly | |
11998 | 11998 | Mexico | Mexico | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 127504120 | 19750 | 2757 | TBC | weekly | |
11997 | 11997 | Mexico | Mexico | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 127504120 | 19003 | 2386 | TBC | weekly | |
11996 | 11996 | Mexico | Mexico | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 127504120 | 18995 | 1904 | TBC | weekly | |
11995 | 11995 | Mexico | Mexico | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 127504120 | 18625 | 2658 | TBC | weekly | |
11994 | 11994 | Mexico | Mexico | 0 | 2020-09-21 | 2020-09-27 | 7 | 2020 | 39 | 127504120 | 19073 | 2937 | TBC | weekly | |
11993 | 11993 | Mexico | Mexico | 0 | 2020-09-14 | 2020-09-20 | 7 | 2020 | 38 | 127504120 | 18963 | 2672 | TBC | weekly | |
11992 | 11992 | Mexico | Mexico | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 127504120 | 19609 | 3263 | TBC | weekly | |
11991 | 11991 | Mexico | Mexico | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 127504120 | 20326 | 3400 | TBC | weekly | |
11990 | 11990 | Mexico | Mexico | 0 | 2020-08-24 | 2020-08-30 | 7 | 2020 | 35 | 127504120 | 21007 | 3678 | TBC | weekly | |
11989 | 11989 | Mexico | Mexico | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 127504120 | 21921 | 3723 | TBC | weekly | |
11988 | 11988 | Mexico | Mexico | 0 | 2020-08-10 | 2020-08-16 | 7 | 2020 | 33 | 127504120 | 22875 | 4459 | TBC | weekly | |
11987 | 11987 | Mexico | Mexico | 0 | 2020-08-03 | 2020-08-09 | 7 | 2020 | 32 | 127504120 | 24016 | 4552 | TBC | weekly | |
11986 | 11986 | Mexico | Mexico | 0 | 2020-07-27 | 2020-08-02 | 7 | 2020 | 31 | 127504120 | 25060 | 4066 | TBC | weekly | |
11985 | 11985 | Mexico | Mexico | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 127504120 | 26027 | 4496 | TBC | weekly | |
11984 | 11984 | Mexico | Mexico | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 127504120 | 26756 | 4178 | TBC | weekly | |
11983 | 11983 | Mexico | Mexico | 0 | 2020-07-06 | 2020-07-12 | 7 | 2020 | 28 | 127504120 | 26798 | 4367 | TBC | weekly | |
11982 | 11982 | Mexico | Mexico | 0 | 2020-06-29 | 2020-07-05 | 7 | 2020 | 27 | 127504120 | 25845 | 3991 | TBC | weekly | |
11981 | 11981 | Mexico | Mexico | 0 | 2020-06-22 | 2020-06-28 | 7 | 2020 | 26 | 127504120 | 25024 | 4823 | TBC | weekly | |
11980 | 11980 | Mexico | Mexico | 0 | 2020-06-15 | 2020-06-21 | 7 | 2020 | 25 | 127504120 | 25281 | 4684 | TBC | weekly | |
11979 | 11979 | Mexico | Mexico | 0 | 2020-06-08 | 2020-06-14 | 7 | 2020 | 24 | 127504120 | 24971 | 3442 | TBC | weekly | |
11978 | 11978 | Mexico | Mexico | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 127504120 | 24361 | 3769 | TBC | weekly | |
11977 | 11977 | Mexico | Mexico | 0 | 2020-05-25 | 2020-05-31 | 7 | 2020 | 22 | 127504120 | 23320 | 2536 | TBC | weekly | |
11976 | 11976 | Mexico | Mexico | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 127504120 | 23376 | 2217 | TBC | weekly | |
11975 | 11975 | Mexico | Mexico | 0 | 2020-05-11 | 2020-05-17 | 7 | 2020 | 20 | 127504120 | 22444 | 1712 | TBC | weekly | |
11974 | 11974 | Mexico | Mexico | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 127504120 | 20731 | 1311 | TBC | weekly | |
11973 | 11973 | Mexico | Mexico | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 127504120 | 18935 | 803 | TBC | weekly | |
11972 | 11972 | Mexico | Mexico | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 127504120 | 17199 | 665 | TBC | weekly | |
11971 | 11971 | Mexico | Mexico | 0 | 2020-04-13 | 2020-04-19 | 7 | 2020 | 16 | 127504120 | 15111 | 390 | TBC | weekly | |
11970 | 11970 | Mexico | Mexico | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 127504120 | 14135 | 202 | TBC | weekly | |
11969 | 11969 | Mexico | Mexico | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 127504120 | 13627 | 74 | TBC | weekly | |
11968 | 11968 | Mexico | Mexico | 0 | 2020-03-23 | 2020-03-29 | 7 | 2020 | 13 | 127504120 | 13806 | 17 | TBC | weekly | |
11967 | 11967 | Mexico | Mexico | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 127504120 | 13290 | 3 | TBC | weekly | |
11966 | 11966 | Mexico | Mexico | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 127504120 | 14032 | 0 | TBC | weekly | |
11965 | 11965 | Mexico | Mexico | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 127504120 | 14214 | 0 | TBC | weekly | |
11964 | 11964 | Mexico | Mexico | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 127504120 | 14116 | 0 | TBC | weekly | |
11963 | 11963 | Mexico | Mexico | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 127504120 | 14687 | 0 | TBC | weekly | |
11962 | 11962 | Mexico | Mexico | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 127504120 | 15090 | 0 | TBC | weekly | |
11961 | 11961 | Mexico | Mexico | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 127504120 | 15915 | 0 | TBC | weekly | |
11960 | 11960 | Mexico | Mexico | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 127504120 | 15437 | 0 | TBC | weekly | |
11959 | 11959 | Mexico | Mexico | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 127504120 | 15814 | 0 | TBC | weekly | |
11958 | 11958 | Mexico | Mexico | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 127504120 | 16421 | 0 | TBC | weekly | |
11957 | 11957 | Mexico | Mexico | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 127504120 | 16926 | 0 | TBC | weekly | |
11956 | 11956 | Mexico | Mexico | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 127504120 | 16779 | 0 | TBC | weekly | |
11955 | 11955 | Mexico | Mexico | 0 | 2019-12-23 | 2019-12-29 | 7 | 2019 | 52 | 127504120 | 15651 | 0 | TBC | weekly | |
11954 | 11954 | Mexico | Mexico | 0 | 2019-12-16 | 2019-12-22 | 7 | 2019 | 51 | 127504120 | 13545 | 0 | TBC | weekly | |
11953 | 11953 | Mexico | Mexico | 0 | 2019-12-09 | 2019-12-15 | 7 | 2019 | 50 | 127504120 | 13926 | 0 | TBC | weekly | |
11952 | 11952 | Mexico | Mexico | 0 | 2019-12-02 | 2019-12-08 | 7 | 2019 | 49 | 127504120 | 13894 | 0 | TBC | weekly | |
11951 | 11951 | Mexico | Mexico | 0 | 2019-11-25 | 2019-12-01 | 7 | 2019 | 48 | 127504120 | 13793 | 0 | TBC | weekly | |
11950 | 11950 | Mexico | Mexico | 0 | 2019-11-18 | 2019-11-24 | 7 | 2019 | 47 | 127504120 | 14855 | 0 | TBC | weekly | |
11949 | 11949 | Mexico | Mexico | 0 | 2019-11-11 | 2019-11-17 | 7 | 2019 | 46 | 127504120 | 14238 | 0 | TBC | weekly | |
11948 | 11948 | Mexico | Mexico | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 127504120 | 14035 | 0 | TBC | weekly | |
11947 | 11947 | Mexico | Mexico | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 127504120 | 13959 | 0 | TBC | weekly | |
11946 | 11946 | Mexico | Mexico | 0 | 2019-10-21 | 2019-10-27 | 7 | 2019 | 43 | 127504120 | 13611 | 0 | TBC | weekly | |
11945 | 11945 | Mexico | Mexico | 0 | 2019-10-14 | 2019-10-20 | 7 | 2019 | 42 | 127504120 | 13736 | 0 | TBC | weekly | |
11944 | 11944 | Mexico | Mexico | 0 | 2019-10-07 | 2019-10-13 | 7 | 2019 | 41 | 127504120 | 13438 | 0 | TBC | weekly | |
11943 | 11943 | Mexico | Mexico | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 127504120 | 13433 | 0 | TBC | weekly | |
11942 | 11942 | Mexico | Mexico | 0 | 2019-09-23 | 2019-09-29 | 7 | 2019 | 39 | 127504120 | 13521 | 0 | TBC | weekly | |
11941 | 11941 | Mexico | Mexico | 0 | 2019-09-16 | 2019-09-22 | 7 | 2019 | 38 | 127504120 | 13838 | 0 | TBC | weekly | |
11940 | 11940 | Mexico | Mexico | 0 | 2019-09-09 | 2019-09-15 | 7 | 2019 | 37 | 127504120 | 12943 | 0 | TBC | weekly | |
11939 | 11939 | Mexico | Mexico | 0 | 2019-09-02 | 2019-09-08 | 7 | 2019 | 36 | 127504120 | 12986 | 0 | TBC | weekly | |
11938 | 11938 | Mexico | Mexico | 0 | 2019-08-26 | 2019-09-01 | 7 | 2019 | 35 | 127504120 | 13023 | 0 | TBC | weekly | |
11937 | 11937 | Mexico | Mexico | 0 | 2019-08-19 | 2019-08-25 | 7 | 2019 | 34 | 127504120 | 13293 | 0 | TBC | weekly | |
11936 | 11936 | Mexico | Mexico | 0 | 2019-08-12 | 2019-08-18 | 7 | 2019 | 33 | 127504120 | 13610 | 0 | TBC | weekly | |
11935 | 11935 | Mexico | Mexico | 0 | 2019-08-05 | 2019-08-11 | 7 | 2019 | 32 | 127504120 | 13242 | 0 | TBC | weekly | |
11934 | 11934 | Mexico | Mexico | 0 | 2019-07-29 | 2019-08-04 | 7 | 2019 | 31 | 127504120 | 13596 | 0 | TBC | weekly | |
11933 | 11933 | Mexico | Mexico | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 127504120 | 13256 | 0 | TBC | weekly | |
11932 | 11932 | Mexico | Mexico | 0 | 2019-07-15 | 2019-07-21 | 7 | 2019 | 29 | 127504120 | 13276 | 0 | TBC | weekly | |
11931 | 11931 | Mexico | Mexico | 0 | 2019-07-08 | 2019-07-14 | 7 | 2019 | 28 | 127504120 | 13146 | 0 | TBC | weekly | |
11930 | 11930 | Mexico | Mexico | 0 | 2019-07-01 | 2019-07-07 | 7 | 2019 | 27 | 127504120 | 13496 | 0 | TBC | weekly | |
11929 | 11929 | Mexico | Mexico | 0 | 2019-06-24 | 2019-06-30 | 7 | 2019 | 26 | 127504120 | 13111 | 0 | TBC | weekly | |
11928 | 11928 | Mexico | Mexico | 0 | 2019-06-17 | 2019-06-23 | 7 | 2019 | 25 | 127504120 | 13562 | 0 | TBC | weekly | |
11927 | 11927 | Mexico | Mexico | 0 | 2019-06-10 | 2019-06-16 | 7 | 2019 | 24 | 127504120 | 13398 | 0 | TBC | weekly | |
11926 | 11926 | Mexico | Mexico | 0 | 2019-06-03 | 2019-06-09 | 7 | 2019 | 23 | 127504120 | 13382 | 0 | TBC | weekly | |
11925 | 11925 | Mexico | Mexico | 0 | 2019-05-27 | 2019-06-02 | 7 | 2019 | 22 | 127504120 | 13438 | 0 | TBC | weekly | |
11924 | 11924 | Mexico | Mexico | 0 | 2019-05-20 | 2019-05-26 | 7 | 2019 | 21 | 127504120 | 14160 | 0 | TBC | weekly | |
11923 | 11923 | Mexico | Mexico | 0 | 2019-05-13 | 2019-05-19 | 7 | 2019 | 20 | 127504120 | 13590 | 0 | TBC | weekly | |
11922 | 11922 | Mexico | Mexico | 0 | 2019-05-06 | 2019-05-12 | 7 | 2019 | 19 | 127504120 | 13792 | 0 | TBC | weekly | |
11921 | 11921 | Mexico | Mexico | 0 | 2019-04-29 | 2019-05-05 | 7 | 2019 | 18 | 127504120 | 13698 | 0 | TBC | weekly | |
11920 | 11920 | Mexico | Mexico | 0 | 2019-04-22 | 2019-04-28 | 7 | 2019 | 17 | 127504120 | 13718 | 0 | TBC | weekly | |
11919 | 11919 | Mexico | Mexico | 0 | 2019-04-15 | 2019-04-21 | 7 | 2019 | 16 | 127504120 | 13743 | 0 | TBC | weekly | |
11918 | 11918 | Mexico | Mexico | 0 | 2019-04-08 | 2019-04-14 | 7 | 2019 | 15 | 127504120 | 13718 | 0 | TBC | weekly | |
11917 | 11917 | Mexico | Mexico | 0 | 2019-04-01 | 2019-04-07 | 7 | 2019 | 14 | 127504120 | 14049 | 0 | TBC | weekly | |
11916 | 11916 | Mexico | Mexico | 0 | 2019-03-25 | 2019-03-31 | 7 | 2019 | 13 | 127504120 | 13903 | 0 | TBC | weekly | |
11915 | 11915 | Mexico | Mexico | 0 | 2019-03-18 | 2019-03-24 | 7 | 2019 | 12 | 127504120 | 13660 | 0 | TBC | weekly | |
11914 | 11914 | Mexico | Mexico | 0 | 2019-03-11 | 2019-03-17 | 7 | 2019 | 11 | 127504120 | 13749 | 0 | TBC | weekly | |
11913 | 11913 | Mexico | Mexico | 0 | 2019-03-04 | 2019-03-10 | 7 | 2019 | 10 | 127504120 | 14391 | 0 | TBC | weekly | |
11912 | 11912 | Mexico | Mexico | 0 | 2019-02-25 | 2019-03-03 | 7 | 2019 | 9 | 127504120 | 14639 | 0 | TBC | weekly | |
11911 | 11911 | Mexico | Mexico | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 127504120 | 14755 | 0 | TBC | weekly | |
11910 | 11910 | Mexico | Mexico | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 127504120 | 15445 | 0 | TBC | weekly | |
11909 | 11909 | Mexico | Mexico | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 127504120 | 15689 | 0 | TBC | weekly | |
11908 | 11908 | Mexico | Mexico | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 127504120 | 15862 | 0 | TBC | weekly | |
11907 | 11907 | Mexico | Mexico | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 127504120 | 15864 | 0 | TBC | weekly | |
11906 | 11906 | Mexico | Mexico | 0 | 2019-01-14 | 2019-01-20 | 7 | 2019 | 3 | 127504120 | 16252 | 0 | TBC | weekly | |
11905 | 11905 | Mexico | Mexico | 0 | 2019-01-07 | 2019-01-13 | 7 | 2019 | 2 | 127504120 | 16602 | 0 | TBC | weekly | |
11904 | 11904 | Mexico | Mexico | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 127504120 | 17723 | 0 | TBC | weekly | |
11903 | 11903 | Mexico | Mexico | 0 | 2018-12-24 | 2018-12-30 | 7 | 2018 | 52 | 127504120 | 17373 | 0 | TBC | weekly | |
11902 | 11902 | Mexico | Mexico | 0 | 2018-12-17 | 2018-12-23 | 7 | 2018 | 51 | 127504120 | 16440 | 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]);