economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where country = "Ecuador" and year = 2020 sorted by region
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
746 | 746 | Ecuador | Ecuador | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 18001002 | 1370 | 0 | TBC | weekly | |
747 | 747 | Ecuador | Ecuador | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 18001002 | 1566 | 0 | TBC | weekly | |
748 | 748 | Ecuador | Ecuador | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 18001002 | 1517 | 0 | TBC | weekly | |
749 | 749 | Ecuador | Ecuador | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 18001002 | 1461 | 0 | TBC | weekly | |
750 | 750 | Ecuador | Ecuador | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 18001002 | 1363 | 0 | TBC | weekly | |
751 | 751 | Ecuador | Ecuador | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 18001002 | 1430 | 0 | TBC | weekly | |
752 | 752 | Ecuador | Ecuador | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 18001002 | 1508 | 0 | TBC | weekly | |
753 | 753 | Ecuador | Ecuador | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 18001002 | 1481 | 0 | TBC | weekly | |
754 | 754 | Ecuador | Ecuador | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 18001002 | 1546 | 0 | TBC | weekly | |
755 | 755 | Ecuador | Ecuador | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 18001002 | 1440 | 0 | TBC | weekly | |
756 | 756 | Ecuador | Ecuador | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 18001002 | 1474 | 2 | TBC | weekly | |
757 | 757 | Ecuador | Ecuador | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 18001002 | 1530 | 12 | TBC | weekly | |
758 | 758 | Ecuador | Ecuador | 0 | 2020-03-23 | 2020-03-29 | 7 | 2020 | 13 | 18001002 | 3766 | 44 | TBC | weekly | |
759 | 759 | Ecuador | Ecuador | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 18001002 | 7236 | 122 | TBC | weekly | |
760 | 760 | Ecuador | Ecuador | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 18001002 | 6411 | 153 | TBC | weekly | |
761 | 761 | Ecuador | Ecuador | 0 | 2020-04-13 | 2020-04-19 | 7 | 2020 | 16 | 18001002 | 4487 | 141 | TBC | weekly | |
762 | 762 | Ecuador | Ecuador | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 18001002 | 3495 | 102 | TBC | weekly | |
763 | 763 | Ecuador | Ecuador | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 18001002 | 2851 | 988 | TBC | weekly | |
764 | 764 | Ecuador | Ecuador | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 18001002 | 2618 | 563 | TBC | weekly | |
765 | 765 | Ecuador | Ecuador | 0 | 2020-05-11 | 2020-05-17 | 7 | 2020 | 20 | 18001002 | 2312 | 609 | TBC | weekly | |
766 | 766 | Ecuador | Ecuador | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 18001002 | 2191 | 372 | TBC | weekly | |
767 | 767 | Ecuador | Ecuador | 0 | 2020-05-25 | 2020-05-31 | 7 | 2020 | 22 | 18001002 | 2121 | 250 | TBC | weekly | |
768 | 768 | Ecuador | Ecuador | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 18001002 | 2088 | 263 | TBC | weekly | |
769 | 769 | Ecuador | Ecuador | 0 | 2020-06-08 | 2020-06-14 | 7 | 2020 | 24 | 18001002 | 2180 | 275 | TBC | weekly | |
770 | 770 | Ecuador | Ecuador | 0 | 2020-06-15 | 2020-06-21 | 7 | 2020 | 25 | 18001002 | 2148 | 327 | TBC | weekly | |
771 | 771 | Ecuador | Ecuador | 0 | 2020-06-22 | 2020-06-28 | 7 | 2020 | 26 | 18001002 | 2140 | 206 | TBC | weekly | |
772 | 772 | Ecuador | Ecuador | 0 | 2020-06-29 | 2020-07-05 | 7 | 2020 | 27 | 18001002 | 2243 | 352 | TBC | weekly | |
773 | 773 | Ecuador | Ecuador | 0 | 2020-07-06 | 2020-07-12 | 7 | 2020 | 28 | 18001002 | 2429 | 266 | TBC | weekly | |
774 | 774 | Ecuador | Ecuador | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 18001002 | 2534 | 266 | TBC | weekly | |
775 | 775 | Ecuador | Ecuador | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 18001002 | 2568 | 202 | TBC | weekly | |
776 | 776 | Ecuador | Ecuador | 0 | 2020-07-27 | 2020-08-02 | 7 | 2020 | 31 | 18001002 | 2542 | 221 | TBC | weekly | |
777 | 777 | Ecuador | Ecuador | 0 | 2020-08-03 | 2020-08-09 | 7 | 2020 | 32 | 18001002 | 2482 | 186 | TBC | weekly | |
778 | 778 | Ecuador | Ecuador | 0 | 2020-08-10 | 2020-08-16 | 7 | 2020 | 33 | 18001002 | 2378 | 148 | TBC | weekly | |
779 | 779 | Ecuador | Ecuador | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 18001002 | 2196 | 240 | TBC | weekly | |
780 | 780 | Ecuador | Ecuador | 0 | 2020-08-24 | 2020-08-30 | 7 | 2020 | 35 | 18001002 | 2080 | 245 | TBC | weekly | |
781 | 781 | Ecuador | Ecuador | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 18001002 | 2070 | 169 | TBC | weekly | |
782 | 782 | Ecuador | Ecuador | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 18001002 | 1948 | 327 | TBC | weekly | |
783 | 783 | Ecuador | Ecuador | 0 | 2020-09-14 | 2020-09-20 | 7 | 2020 | 38 | 18001002 | 1882 | 187 | TBC | weekly | |
784 | 784 | Ecuador | Ecuador | 0 | 2020-09-21 | 2020-09-27 | 7 | 2020 | 39 | 18001002 | 1783 | 189 | TBC | weekly | |
785 | 785 | Ecuador | Ecuador | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 18001002 | 1701 | 368 | TBC | weekly | |
786 | 786 | Ecuador | Ecuador | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 18001002 | 1828 | 544 | TBC | weekly | |
787 | 787 | Ecuador | Ecuador | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 18001002 | 1717 | 196 | TBC | weekly | |
788 | 788 | Ecuador | Ecuador | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 18001002 | 1758 | 166 | TBC | weekly | |
789 | 789 | Ecuador | Ecuador | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 18001002 | 1682 | 131 | TBC | weekly | |
790 | 790 | Ecuador | Ecuador | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 18001002 | 1672 | 146 | TBC | weekly | |
791 | 791 | Ecuador | Ecuador | 0 | 2020-11-09 | 2020-11-15 | 7 | 2020 | 46 | 18001002 | 1764 | 178 | TBC | weekly | |
792 | 792 | Ecuador | Ecuador | 0 | 2020-11-16 | 2020-11-22 | 7 | 2020 | 47 | 18001002 | 1811 | 193 | TBC | weekly | |
793 | 793 | Ecuador | Ecuador | 0 | 2020-11-23 | 2020-11-29 | 7 | 2020 | 48 | 18001002 | 1718 | 222 | TBC | weekly | |
794 | 794 | Ecuador | Ecuador | 0 | 2020-11-30 | 2020-12-06 | 7 | 2020 | 49 | 18001002 | 1798 | 355 | TBC | weekly | |
795 | 795 | Ecuador | Ecuador | 0 | 2020-12-07 | 2020-12-13 | 7 | 2020 | 50 | 18001002 | 1670 | 97 | TBC | weekly | |
796 | 796 | Ecuador | Ecuador | 0 | 2020-12-14 | 2020-12-20 | 7 | 2020 | 51 | 18001002 | 1782 | 73 | TBC | weekly | |
797 | 797 | Ecuador | Ecuador | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 18001002 | 1778 | 44 | TBC | weekly | |
798 | 798 | Ecuador | Ecuador | 0 | 2020-12-28 | 2021-01-03 | 7 | 2020 | 53 | 18001002 | 1914 | 67 | 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]);