economist_excess_deaths

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette

28 rows where country = "Mexico"

View and edit SQL

Suggested facets: start_date, end_date, total_deaths, covid_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, week, start_date (date), end_date (date)

country

  • Mexico · 28

cadence

Link rowid ▼ country region region_code start_date end_date year month population total_deaths covid_deaths expected_deaths excess_deaths non_covid_deaths covid_deaths_per_100k excess_deaths_per_100k excess_deaths_pct_change cadence week
629 Mexico Mexico City MX-CMX 2020-03-02 2020-03-08 2020   8918653 1430 0 1540.5 -110.5 1430       weekly 10
630 Mexico Mexico City MX-CMX 2020-03-09 2020-03-15 2020   8918653 1550 0 1558.5 -8.5 1550       weekly 11
631 Mexico Mexico City MX-CMX 2020-03-16 2020-03-22 2020   8918653 1407 1 1451.5 -44.5 1406       weekly 12
632 Mexico Mexico City MX-CMX 2020-03-23 2020-03-29 2020   8918653 1499 6 1448.5 50.5 1493       weekly 13
633 Mexico Mexico City MX-CMX 2020-03-30 2020-04-05 2020   8918653 1491 12 1468.0 23.0 1479       weekly 14
634 Mexico Mexico City MX-CMX 2020-04-06 2020-04-12 2020   8918653 1624 37 1416.0 208.0 1587       weekly 15
635 Mexico Mexico City MX-CMX 2020-04-13 2020-04-19 2020   8918653 1828 127 1386.25 441.75 1701       weekly 16
636 Mexico Mexico City MX-CMX 2020-04-20 2020-04-26 2020   8918653 2475 126 1380.75 1094.25 2349       weekly 17
637 Mexico Mexico City MX-CMX 2020-04-27 2020-05-03 2020   8918653 3508 163 1379.0 2129.0 3345       weekly 18
638 Mexico Mexico City MX-CMX 2020-05-04 2020-05-10 2020   8918653 4127 324 1405.5 2721.5 3803       weekly 19
639 Mexico Mexico City MX-CMX 2020-05-11 2020-05-17 2020   8918653 4188 536 1391.75 2796.25 3652       weekly 20
640 Mexico Mexico City MX-CMX 2020-05-18 2020-05-24 2020   8918653 4313 631 1353.25 2959.75 3682       weekly 21
641 Mexico Mexico City MX-CMX 2020-05-25 2020-05-31 2020   8918653 3840 695 1354.0 2486.0 3145       weekly 22
642 Mexico Mexico City MX-CMX 2020-06-01 2020-06-07 2020   8918653 3815 1071 1364.5 2450.5 2744       weekly 23
2698 Mexico Mexico City MX-CMX 2020-03-02 2020-03-08 2020   8918653 1430 0 1540.5 -110.5 1430 0.0 -1.23897633420652 -0.0717299578059072 weekly 10
2699 Mexico Mexico City MX-CMX 2020-03-09 2020-03-15 2020   8918653 1550 0 1558.5 -8.5 1550 0.0 -0.0953058718620401 -0.00545396214308635 weekly 11
2700 Mexico Mexico City MX-CMX 2020-03-16 2020-03-22 2020   8918653 1407 1 1451.5 -44.5 1406 0.0112124555131812 -0.498954270336563 -0.0306579400620048 weekly 12
2701 Mexico Mexico City MX-CMX 2020-03-23 2020-03-29 2020   8918653 1499 6 1448.5 50.5 1493 0.0672747330790872 0.56622900341565 0.0348636520538488 weekly 13
2702 Mexico Mexico City MX-CMX 2020-03-30 2020-04-05 2020   8918653 1491 12 1468.0 23.0 1479 0.134549466158174 0.257886476803168 0.0156675749318802 weekly 14
2703 Mexico Mexico City MX-CMX 2020-04-06 2020-04-12 2020   8918653 1624 37 1416.0 208.0 1587 0.414860853987704 2.33219074674169 0.146892655367232 weekly 15
2704 Mexico Mexico City MX-CMX 2020-04-13 2020-04-19 2020   8918653 1828 127 1386.25 441.75 1701 1.42398185017401 4.95310222294779 0.318665464382326 weekly 16
2705 Mexico Mexico City MX-CMX 2020-04-20 2020-04-26 2020   8918653 2475 126 1380.75 1094.25 2349 1.41276939466083 12.2692294452985 0.792504073872895 weekly 17
2706 Mexico Mexico City MX-CMX 2020-04-27 2020-05-03 2020   8918653 3508 163 1379.0 2129.0 3345 1.82763024864853 23.8713177875628 1.54387237128354 weekly 18
2707 Mexico Mexico City MX-CMX 2020-05-04 2020-05-10 2020   8918653 4127 324 1405.5 2721.5 3803 3.63283558627071 30.5146976791226 1.93632159373888 weekly 19
2708 Mexico Mexico City MX-CMX 2020-05-11 2020-05-17 2020   8918653 4188 536 1391.75 2796.25 3652 6.00987615506512 31.3528287287329 2.00916112807616 weekly 20
2709 Mexico Mexico City MX-CMX 2020-05-18 2020-05-24 2020   8918653 4313 631 1353.25 2959.75 3682 7.07505942881733 33.186065205138 2.18714206539812 weekly 21
2710 Mexico Mexico City MX-CMX 2020-05-25 2020-05-31 2020   8918653 3840 695 1354.0 2486.0 3145 7.79265658166093 27.8741644057685 1.83604135893648 weekly 22
2711 Mexico Mexico City MX-CMX 2020-06-01 2020-06-07 2020   8918653 3815 1071 1364.5 2450.5 2744 12.0085398546171 27.4761222350505 1.79589593257604 weekly 23

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [economist_excess_deaths] (
   [country] TEXT,
   [region] TEXT,
   [region_code] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [year] INTEGER,
   [month] INTEGER,
   [population] INTEGER,
   [total_deaths] INTEGER,
   [covid_deaths] INTEGER,
   [expected_deaths] FLOAT,
   [excess_deaths] FLOAT,
   [non_covid_deaths] INTEGER,
   [covid_deaths_per_100k] FLOAT,
   [excess_deaths_per_100k] FLOAT,
   [excess_deaths_pct_change] FLOAT,
   [cadence] TEXT
, [week] INTEGER);
Powered by Datasette · Query took 65.075ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette