economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where cadence = "weekly", country = "Ecuador" and year = 2019
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
694 | 694 | Ecuador | Ecuador | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 18001002 | 1540 | 0 | TBC | weekly | |
695 | 695 | Ecuador | Ecuador | 0 | 2019-01-07 | 2019-01-13 | 7 | 2019 | 2 | 18001002 | 1534 | 0 | TBC | weekly | |
696 | 696 | Ecuador | Ecuador | 0 | 2019-01-14 | 2019-01-20 | 7 | 2019 | 3 | 18001002 | 1499 | 0 | TBC | weekly | |
697 | 697 | Ecuador | Ecuador | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 18001002 | 1528 | 0 | TBC | weekly | |
698 | 698 | Ecuador | Ecuador | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 18001002 | 1478 | 0 | TBC | weekly | |
699 | 699 | Ecuador | Ecuador | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 18001002 | 1529 | 0 | TBC | weekly | |
700 | 700 | Ecuador | Ecuador | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 18001002 | 1475 | 0 | TBC | weekly | |
701 | 701 | Ecuador | Ecuador | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 18001002 | 1441 | 0 | TBC | weekly | |
702 | 702 | Ecuador | Ecuador | 0 | 2019-02-25 | 2019-03-03 | 7 | 2019 | 9 | 18001002 | 1467 | 0 | TBC | weekly | |
703 | 703 | Ecuador | Ecuador | 0 | 2019-03-04 | 2019-03-10 | 7 | 2019 | 10 | 18001002 | 1513 | 0 | TBC | weekly | |
704 | 704 | Ecuador | Ecuador | 0 | 2019-03-11 | 2019-03-17 | 7 | 2019 | 11 | 18001002 | 1505 | 0 | TBC | weekly | |
705 | 705 | Ecuador | Ecuador | 0 | 2019-03-18 | 2019-03-24 | 7 | 2019 | 12 | 18001002 | 1480 | 0 | TBC | weekly | |
706 | 706 | Ecuador | Ecuador | 0 | 2019-03-25 | 2019-03-31 | 7 | 2019 | 13 | 18001002 | 1430 | 0 | TBC | weekly | |
707 | 707 | Ecuador | Ecuador | 0 | 2019-04-01 | 2019-04-07 | 7 | 2019 | 14 | 18001002 | 1465 | 0 | TBC | weekly | |
708 | 708 | Ecuador | Ecuador | 0 | 2019-04-08 | 2019-04-14 | 7 | 2019 | 15 | 18001002 | 1389 | 0 | TBC | weekly | |
709 | 709 | Ecuador | Ecuador | 0 | 2019-04-15 | 2019-04-21 | 7 | 2019 | 16 | 18001002 | 1417 | 0 | TBC | weekly | |
710 | 710 | Ecuador | Ecuador | 0 | 2019-04-22 | 2019-04-28 | 7 | 2019 | 17 | 18001002 | 1450 | 0 | TBC | weekly | |
711 | 711 | Ecuador | Ecuador | 0 | 2019-04-29 | 2019-05-05 | 7 | 2019 | 18 | 18001002 | 1414 | 0 | TBC | weekly | |
712 | 712 | Ecuador | Ecuador | 0 | 2019-05-06 | 2019-05-12 | 7 | 2019 | 19 | 18001002 | 1315 | 0 | TBC | weekly | |
713 | 713 | Ecuador | Ecuador | 0 | 2019-05-13 | 2019-05-19 | 7 | 2019 | 20 | 18001002 | 1355 | 0 | TBC | weekly | |
714 | 714 | Ecuador | Ecuador | 0 | 2019-05-20 | 2019-05-26 | 7 | 2019 | 21 | 18001002 | 1349 | 0 | TBC | weekly | |
715 | 715 | Ecuador | Ecuador | 0 | 2019-05-27 | 2019-06-02 | 7 | 2019 | 22 | 18001002 | 1370 | 0 | TBC | weekly | |
716 | 716 | Ecuador | Ecuador | 0 | 2019-06-03 | 2019-06-09 | 7 | 2019 | 23 | 18001002 | 1350 | 0 | TBC | weekly | |
717 | 717 | Ecuador | Ecuador | 0 | 2019-06-10 | 2019-06-16 | 7 | 2019 | 24 | 18001002 | 1374 | 0 | TBC | weekly | |
718 | 718 | Ecuador | Ecuador | 0 | 2019-06-17 | 2019-06-23 | 7 | 2019 | 25 | 18001002 | 1385 | 0 | TBC | weekly | |
719 | 719 | Ecuador | Ecuador | 0 | 2019-06-24 | 2019-06-30 | 7 | 2019 | 26 | 18001002 | 1377 | 0 | TBC | weekly | |
720 | 720 | Ecuador | Ecuador | 0 | 2019-07-01 | 2019-07-07 | 7 | 2019 | 27 | 18001002 | 1441 | 0 | TBC | weekly | |
721 | 721 | Ecuador | Ecuador | 0 | 2019-07-08 | 2019-07-14 | 7 | 2019 | 28 | 18001002 | 1308 | 0 | TBC | weekly | |
722 | 722 | Ecuador | Ecuador | 0 | 2019-07-15 | 2019-07-21 | 7 | 2019 | 29 | 18001002 | 1404 | 0 | TBC | weekly | |
723 | 723 | Ecuador | Ecuador | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 18001002 | 1365 | 0 | TBC | weekly | |
724 | 724 | Ecuador | Ecuador | 0 | 2019-07-29 | 2019-08-04 | 7 | 2019 | 31 | 18001002 | 1372 | 0 | TBC | weekly | |
725 | 725 | Ecuador | Ecuador | 0 | 2019-08-05 | 2019-08-11 | 7 | 2019 | 32 | 18001002 | 1407 | 0 | TBC | weekly | |
726 | 726 | Ecuador | Ecuador | 0 | 2019-08-12 | 2019-08-18 | 7 | 2019 | 33 | 18001002 | 1436 | 0 | TBC | weekly | |
727 | 727 | Ecuador | Ecuador | 0 | 2019-08-19 | 2019-08-25 | 7 | 2019 | 34 | 18001002 | 1399 | 0 | TBC | weekly | |
728 | 728 | Ecuador | Ecuador | 0 | 2019-08-26 | 2019-09-01 | 7 | 2019 | 35 | 18001002 | 1444 | 0 | TBC | weekly | |
729 | 729 | Ecuador | Ecuador | 0 | 2019-09-02 | 2019-09-08 | 7 | 2019 | 36 | 18001002 | 1497 | 0 | TBC | weekly | |
730 | 730 | Ecuador | Ecuador | 0 | 2019-09-09 | 2019-09-15 | 7 | 2019 | 37 | 18001002 | 1447 | 0 | TBC | weekly | |
731 | 731 | Ecuador | Ecuador | 0 | 2019-09-16 | 2019-09-22 | 7 | 2019 | 38 | 18001002 | 1402 | 0 | TBC | weekly | |
732 | 732 | Ecuador | Ecuador | 0 | 2019-09-23 | 2019-09-29 | 7 | 2019 | 39 | 18001002 | 1398 | 0 | TBC | weekly | |
733 | 733 | Ecuador | Ecuador | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 18001002 | 1325 | 0 | TBC | weekly | |
734 | 734 | Ecuador | Ecuador | 0 | 2019-10-07 | 2019-10-13 | 7 | 2019 | 41 | 18001002 | 1349 | 0 | TBC | weekly | |
735 | 735 | Ecuador | Ecuador | 0 | 2019-10-14 | 2019-10-20 | 7 | 2019 | 42 | 18001002 | 1371 | 0 | TBC | weekly | |
736 | 736 | Ecuador | Ecuador | 0 | 2019-10-21 | 2019-10-27 | 7 | 2019 | 43 | 18001002 | 1306 | 0 | TBC | weekly | |
737 | 737 | Ecuador | Ecuador | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 18001002 | 1426 | 0 | TBC | weekly | |
738 | 738 | Ecuador | Ecuador | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 18001002 | 1432 | 0 | TBC | weekly | |
739 | 739 | Ecuador | Ecuador | 0 | 2019-11-11 | 2019-11-17 | 7 | 2019 | 46 | 18001002 | 1384 | 0 | TBC | weekly | |
740 | 740 | Ecuador | Ecuador | 0 | 2019-11-18 | 2019-11-24 | 7 | 2019 | 47 | 18001002 | 1441 | 0 | TBC | weekly | |
741 | 741 | Ecuador | Ecuador | 0 | 2019-11-25 | 2019-12-01 | 7 | 2019 | 48 | 18001002 | 1381 | 0 | TBC | weekly | |
742 | 742 | Ecuador | Ecuador | 0 | 2019-12-02 | 2019-12-08 | 7 | 2019 | 49 | 18001002 | 1350 | 0 | TBC | weekly | |
743 | 743 | Ecuador | Ecuador | 0 | 2019-12-09 | 2019-12-15 | 7 | 2019 | 50 | 18001002 | 1479 | 0 | TBC | weekly | |
744 | 744 | Ecuador | Ecuador | 0 | 2019-12-16 | 2019-12-22 | 7 | 2019 | 51 | 18001002 | 1359 | 0 | TBC | weekly | |
745 | 745 | Ecuador | Ecuador | 0 | 2019-12-23 | 2019-12-29 | 7 | 2019 | 52 | 18001002 | 1127 | 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]);