economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where country = "Guatemala" and year = 2015
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37570 | 37570 | Guatemala | Guatemala | 0 | 2014-12-29 | 2015-01-04 | 7 | 2015 | 1 | 17843914 | 1690 | 0 | TBC | weekly | |
37571 | 37571 | Guatemala | Guatemala | 0 | 2015-01-05 | 2015-01-11 | 7 | 2015 | 2 | 17843914 | 1616 | 0 | TBC | weekly | |
37572 | 37572 | Guatemala | Guatemala | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 17843914 | 1604 | 0 | TBC | weekly | |
37573 | 37573 | Guatemala | Guatemala | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 17843914 | 1480 | 0 | TBC | weekly | |
37574 | 37574 | Guatemala | Guatemala | 0 | 2015-01-26 | 2015-02-01 | 7 | 2015 | 5 | 17843914 | 1441 | 0 | TBC | weekly | |
37575 | 37575 | Guatemala | Guatemala | 0 | 2015-02-02 | 2015-02-08 | 7 | 2015 | 6 | 17843914 | 1512 | 0 | TBC | weekly | |
37576 | 37576 | Guatemala | Guatemala | 0 | 2015-02-09 | 2015-02-15 | 7 | 2015 | 7 | 17843914 | 1549 | 0 | TBC | weekly | |
37577 | 37577 | Guatemala | Guatemala | 0 | 2015-02-16 | 2015-02-22 | 7 | 2015 | 8 | 17843914 | 1623 | 0 | TBC | weekly | |
37578 | 37578 | Guatemala | Guatemala | 0 | 2015-02-23 | 2015-03-01 | 7 | 2015 | 9 | 17843914 | 1511 | 0 | TBC | weekly | |
37579 | 37579 | Guatemala | Guatemala | 0 | 2015-03-02 | 2015-03-08 | 7 | 2015 | 10 | 17843914 | 1537 | 0 | TBC | weekly | |
37580 | 37580 | Guatemala | Guatemala | 0 | 2015-03-09 | 2015-03-15 | 7 | 2015 | 11 | 17843914 | 1543 | 0 | TBC | weekly | |
37581 | 37581 | Guatemala | Guatemala | 0 | 2015-03-16 | 2015-03-22 | 7 | 2015 | 12 | 17843914 | 1458 | 0 | TBC | weekly | |
37582 | 37582 | Guatemala | Guatemala | 0 | 2015-03-23 | 2015-03-29 | 7 | 2015 | 13 | 17843914 | 1502 | 0 | TBC | weekly | |
37583 | 37583 | Guatemala | Guatemala | 0 | 2015-03-30 | 2015-04-05 | 7 | 2015 | 14 | 17843914 | 1523 | 0 | TBC | weekly | |
37584 | 37584 | Guatemala | Guatemala | 0 | 2015-04-06 | 2015-04-12 | 7 | 2015 | 15 | 17843914 | 1493 | 0 | TBC | weekly | |
37585 | 37585 | Guatemala | Guatemala | 0 | 2015-04-13 | 2015-04-19 | 7 | 2015 | 16 | 17843914 | 1579 | 0 | TBC | weekly | |
37586 | 37586 | Guatemala | Guatemala | 0 | 2015-04-20 | 2015-04-26 | 7 | 2015 | 17 | 17843914 | 1636 | 0 | TBC | weekly | |
37587 | 37587 | Guatemala | Guatemala | 0 | 2015-04-27 | 2015-05-03 | 7 | 2015 | 18 | 17843914 | 1550 | 0 | TBC | weekly | |
37588 | 37588 | Guatemala | Guatemala | 0 | 2015-05-04 | 2015-05-10 | 7 | 2015 | 19 | 17843914 | 1610 | 0 | TBC | weekly | |
37589 | 37589 | Guatemala | Guatemala | 0 | 2015-05-11 | 2015-05-17 | 7 | 2015 | 20 | 17843914 | 1550 | 0 | TBC | weekly | |
37590 | 37590 | Guatemala | Guatemala | 0 | 2015-05-18 | 2015-05-24 | 7 | 2015 | 21 | 17843914 | 1528 | 0 | TBC | weekly | |
37591 | 37591 | Guatemala | Guatemala | 0 | 2015-05-25 | 2015-05-31 | 7 | 2015 | 22 | 17843914 | 1542 | 0 | TBC | weekly | |
37592 | 37592 | Guatemala | Guatemala | 0 | 2015-06-01 | 2015-06-07 | 7 | 2015 | 23 | 17843914 | 1541 | 0 | TBC | weekly | |
37593 | 37593 | Guatemala | Guatemala | 0 | 2015-06-08 | 2015-06-14 | 7 | 2015 | 24 | 17843914 | 1496 | 0 | TBC | weekly | |
37594 | 37594 | Guatemala | Guatemala | 0 | 2015-06-15 | 2015-06-21 | 7 | 2015 | 25 | 17843914 | 1558 | 0 | TBC | weekly | |
37595 | 37595 | Guatemala | Guatemala | 0 | 2015-06-22 | 2015-06-28 | 7 | 2015 | 26 | 17843914 | 1549 | 0 | TBC | weekly | |
37596 | 37596 | Guatemala | Guatemala | 0 | 2015-06-29 | 2015-07-05 | 7 | 2015 | 27 | 17843914 | 1538 | 0 | TBC | weekly | |
37597 | 37597 | Guatemala | Guatemala | 0 | 2015-07-06 | 2015-07-12 | 7 | 2015 | 28 | 17843914 | 1516 | 0 | TBC | weekly | |
37598 | 37598 | Guatemala | Guatemala | 0 | 2015-07-13 | 2015-07-19 | 7 | 2015 | 29 | 17843914 | 1577 | 0 | TBC | weekly | |
37599 | 37599 | Guatemala | Guatemala | 0 | 2015-07-20 | 2015-07-26 | 7 | 2015 | 30 | 17843914 | 1585 | 0 | TBC | weekly | |
37600 | 37600 | Guatemala | Guatemala | 0 | 2015-07-27 | 2015-08-02 | 7 | 2015 | 31 | 17843914 | 1574 | 0 | TBC | weekly | |
37601 | 37601 | Guatemala | Guatemala | 0 | 2015-08-03 | 2015-08-09 | 7 | 2015 | 32 | 17843914 | 1580 | 0 | TBC | weekly | |
37602 | 37602 | Guatemala | Guatemala | 0 | 2015-08-10 | 2015-08-16 | 7 | 2015 | 33 | 17843914 | 1491 | 0 | TBC | weekly | |
37603 | 37603 | Guatemala | Guatemala | 0 | 2015-08-17 | 2015-08-23 | 7 | 2015 | 34 | 17843914 | 1548 | 0 | TBC | weekly | |
37604 | 37604 | Guatemala | Guatemala | 0 | 2015-08-24 | 2015-08-30 | 7 | 2015 | 35 | 17843914 | 1615 | 0 | TBC | weekly | |
37605 | 37605 | Guatemala | Guatemala | 0 | 2015-08-31 | 2015-09-06 | 7 | 2015 | 36 | 17843914 | 1498 | 0 | TBC | weekly | |
37606 | 37606 | Guatemala | Guatemala | 0 | 2015-09-07 | 2015-09-13 | 7 | 2015 | 37 | 17843914 | 1522 | 0 | TBC | weekly | |
37607 | 37607 | Guatemala | Guatemala | 0 | 2015-09-14 | 2015-09-20 | 7 | 2015 | 38 | 17843914 | 1629 | 0 | TBC | weekly | |
37608 | 37608 | Guatemala | Guatemala | 0 | 2015-09-21 | 2015-09-27 | 7 | 2015 | 39 | 17843914 | 1524 | 0 | TBC | weekly | |
37609 | 37609 | Guatemala | Guatemala | 0 | 2015-09-28 | 2015-10-04 | 7 | 2015 | 40 | 17843914 | 1767 | 0 | TBC | weekly | |
37610 | 37610 | Guatemala | Guatemala | 0 | 2015-10-05 | 2015-10-11 | 7 | 2015 | 41 | 17843914 | 1641 | 0 | TBC | weekly | |
37611 | 37611 | Guatemala | Guatemala | 0 | 2015-10-12 | 2015-10-18 | 7 | 2015 | 42 | 17843914 | 1470 | 0 | TBC | weekly | |
37612 | 37612 | Guatemala | Guatemala | 0 | 2015-10-19 | 2015-10-25 | 7 | 2015 | 43 | 17843914 | 1492 | 0 | TBC | weekly | |
37613 | 37613 | Guatemala | Guatemala | 0 | 2015-10-26 | 2015-11-01 | 7 | 2015 | 44 | 17843914 | 1625 | 0 | TBC | weekly | |
37614 | 37614 | Guatemala | Guatemala | 0 | 2015-11-02 | 2015-11-08 | 7 | 2015 | 45 | 17843914 | 1580 | 0 | TBC | weekly | |
37615 | 37615 | Guatemala | Guatemala | 0 | 2015-11-09 | 2015-11-15 | 7 | 2015 | 46 | 17843914 | 1564 | 0 | TBC | weekly | |
37616 | 37616 | Guatemala | Guatemala | 0 | 2015-11-16 | 2015-11-22 | 7 | 2015 | 47 | 17843914 | 1480 | 0 | TBC | weekly | |
37617 | 37617 | Guatemala | Guatemala | 0 | 2015-11-23 | 2015-11-29 | 7 | 2015 | 48 | 17843914 | 1445 | 0 | TBC | weekly | |
37618 | 37618 | Guatemala | Guatemala | 0 | 2015-11-30 | 2015-12-06 | 7 | 2015 | 49 | 17843914 | 1549 | 0 | TBC | weekly | |
37619 | 37619 | Guatemala | Guatemala | 0 | 2015-12-07 | 2015-12-13 | 7 | 2015 | 50 | 17843914 | 1543 | 0 | TBC | weekly | |
37620 | 37620 | Guatemala | Guatemala | 0 | 2015-12-14 | 2015-12-20 | 7 | 2015 | 51 | 17843914 | 1491 | 0 | TBC | weekly | |
37621 | 37621 | Guatemala | Guatemala | 0 | 2015-12-21 | 2015-12-27 | 7 | 2015 | 52 | 17843914 | 1595 | 0 | TBC | weekly | |
37622 | 37622 | Guatemala | Guatemala | 0 | 2015-12-28 | 2016-01-03 | 7 | 2015 | 53 | 17843914 | 1605 | 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]);