economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
41 rows where country = "Mexico" and year = 2022
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12061 | 12061 | Mexico | Mexico | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 127504120 | 17994 | 790 | TBC | weekly | |
12062 | 12062 | Mexico | Mexico | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 127504120 | 19965 | 1076 | TBC | weekly | |
12063 | 12063 | Mexico | Mexico | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 127504120 | 24244 | 1773 | TBC | weekly | |
12064 | 12064 | Mexico | Mexico | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 127504120 | 33055 | 2710 | TBC | weekly | |
12065 | 12065 | Mexico | Mexico | 0 | 2022-01-31 | 2022-02-06 | 7 | 2022 | 5 | 127504120 | 27753 | 3653 | TBC | weekly | |
12066 | 12066 | Mexico | Mexico | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 127504120 | 23434 | 3151 | TBC | weekly | |
12067 | 12067 | Mexico | Mexico | 0 | 2022-02-14 | 2022-02-20 | 7 | 2022 | 7 | 127504120 | 20736 | 2991 | TBC | weekly | |
12068 | 12068 | Mexico | Mexico | 0 | 2022-02-21 | 2022-02-27 | 7 | 2022 | 8 | 127504120 | 17858 | 2398 | TBC | weekly | |
12069 | 12069 | Mexico | Mexico | 0 | 2022-02-28 | 2022-03-06 | 7 | 2022 | 9 | 127504120 | 16123 | 1773 | TBC | weekly | |
12070 | 12070 | Mexico | Mexico | 0 | 2022-03-07 | 2022-03-13 | 7 | 2022 | 10 | 127504120 | 15571 | 1244 | TBC | weekly | |
12071 | 12071 | Mexico | Mexico | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 127504120 | 14572 | 969 | TBC | weekly | |
12072 | 12072 | Mexico | Mexico | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 127504120 | 13882 | 678 | TBC | weekly | |
12073 | 12073 | Mexico | Mexico | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 127504120 | 14284 | 473 | TBC | weekly | |
12074 | 12074 | Mexico | Mexico | 0 | 2022-04-04 | 2022-04-10 | 7 | 2022 | 14 | 127504120 | 13645 | 502 | TBC | weekly | |
12075 | 12075 | Mexico | Mexico | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 127504120 | 13718 | 219 | TBC | weekly | |
12076 | 12076 | Mexico | Mexico | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 127504120 | 13563 | 185 | TBC | weekly | |
12077 | 12077 | Mexico | Mexico | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 127504120 | 12866 | 205 | TBC | weekly | |
12078 | 12078 | Mexico | Mexico | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 127504120 | 13920 | 16 | TBC | weekly | |
12079 | 12079 | Mexico | Mexico | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 127504120 | 14054 | 131 | TBC | weekly | |
12080 | 12080 | Mexico | Mexico | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 127504120 | 13984 | 152 | TBC | weekly | |
12081 | 12081 | Mexico | Mexico | 0 | 2022-05-23 | 2022-05-29 | 7 | 2022 | 21 | 127504120 | 13330 | 151 | TBC | weekly | |
12082 | 12082 | Mexico | Mexico | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 127504120 | 13243 | 249 | TBC | weekly | |
12083 | 12083 | Mexico | Mexico | 0 | 2022-06-06 | 2022-06-12 | 7 | 2022 | 23 | 127504120 | 13833 | 177 | TBC | weekly | |
12084 | 12084 | Mexico | Mexico | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 127504120 | 13597 | 214 | TBC | weekly | |
12085 | 12085 | Mexico | Mexico | 0 | 2022-06-20 | 2022-06-26 | 7 | 2022 | 25 | 127504120 | 13499 | 172 | TBC | weekly | |
12086 | 12086 | Mexico | Mexico | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 127504120 | 14162 | 208 | TBC | weekly | |
12087 | 12087 | Mexico | Mexico | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 127504120 | 14234 | 297 | TBC | weekly | |
12088 | 12088 | Mexico | Mexico | 0 | 2022-07-11 | 2022-07-17 | 7 | 2022 | 28 | 127504120 | 15227 | 419 | TBC | weekly | |
12089 | 12089 | Mexico | Mexico | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 127504120 | 15499 | 585 | TBC | weekly | |
12090 | 12090 | Mexico | Mexico | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 127504120 | 15083 | 436 | TBC | weekly | |
12091 | 12091 | Mexico | Mexico | 0 | 2022-08-01 | 2022-08-07 | 7 | 2022 | 31 | 127504120 | 15420 | 795 | TBC | weekly | |
12092 | 12092 | Mexico | Mexico | 0 | 2022-08-08 | 2022-08-14 | 7 | 2022 | 32 | 127504120 | 14563 | 412 | TBC | weekly | |
12093 | 12093 | Mexico | Mexico | 0 | 2022-08-15 | 2022-08-21 | 7 | 2022 | 33 | 127504120 | 14044 | 139 | TBC | weekly | |
12094 | 12094 | Mexico | Mexico | 0 | 2022-08-22 | 2022-08-28 | 7 | 2022 | 34 | 127504120 | 13587 | 519 | TBC | weekly | |
12095 | 12095 | Mexico | Mexico | 0 | 2022-08-29 | 2022-09-04 | 7 | 2022 | 35 | 127504120 | 13295 | 232 | TBC | weekly | |
12096 | 12096 | Mexico | Mexico | 0 | 2022-09-05 | 2022-09-11 | 7 | 2022 | 36 | 127504120 | 13204 | 140 | TBC | weekly | |
12097 | 12097 | Mexico | Mexico | 0 | 2022-09-12 | 2022-09-18 | 7 | 2022 | 37 | 127504120 | 13353 | 134 | TBC | weekly | |
12098 | 12098 | Mexico | Mexico | 0 | 2022-09-19 | 2022-09-25 | 7 | 2022 | 38 | 127504120 | 13381 | 148 | TBC | weekly | |
12099 | 12099 | Mexico | Mexico | 0 | 2022-09-26 | 2022-10-02 | 7 | 2022 | 39 | 127504120 | 13144 | 88 | TBC | weekly | |
12100 | 12100 | Mexico | Mexico | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 127504120 | 13312 | 77 | TBC | weekly | |
12101 | 12101 | Mexico | Mexico | 0 | 2022-10-10 | 2022-10-16 | 7 | 2022 | 41 | 127504120 | 13156 | 69 | 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]);