economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "Ecuador" and year = 2018
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
642 | 642 | Ecuador | Ecuador | 0 | 2018-01-01 | 2018-01-07 | 7 | 2018 | 1 | 18001002 | 1502 | 0 | TBC | weekly | |
643 | 643 | Ecuador | Ecuador | 0 | 2018-01-08 | 2018-01-14 | 7 | 2018 | 2 | 18001002 | 1496 | 0 | TBC | weekly | |
644 | 644 | Ecuador | Ecuador | 0 | 2018-01-15 | 2018-01-21 | 7 | 2018 | 3 | 18001002 | 1492 | 0 | TBC | weekly | |
645 | 645 | Ecuador | Ecuador | 0 | 2018-01-22 | 2018-01-28 | 7 | 2018 | 4 | 18001002 | 1581 | 0 | TBC | weekly | |
646 | 646 | Ecuador | Ecuador | 0 | 2018-01-29 | 2018-02-04 | 7 | 2018 | 5 | 18001002 | 1418 | 0 | TBC | weekly | |
647 | 647 | Ecuador | Ecuador | 0 | 2018-02-05 | 2018-02-11 | 7 | 2018 | 6 | 18001002 | 1395 | 0 | TBC | weekly | |
648 | 648 | Ecuador | Ecuador | 0 | 2018-02-12 | 2018-02-18 | 7 | 2018 | 7 | 18001002 | 1502 | 0 | TBC | weekly | |
649 | 649 | Ecuador | Ecuador | 0 | 2018-02-19 | 2018-02-25 | 7 | 2018 | 8 | 18001002 | 1451 | 0 | TBC | weekly | |
650 | 650 | Ecuador | Ecuador | 0 | 2018-02-26 | 2018-03-04 | 7 | 2018 | 9 | 18001002 | 1413 | 0 | TBC | weekly | |
651 | 651 | Ecuador | Ecuador | 0 | 2018-03-05 | 2018-03-11 | 7 | 2018 | 10 | 18001002 | 1432 | 0 | TBC | weekly | |
652 | 652 | Ecuador | Ecuador | 0 | 2018-03-12 | 2018-03-18 | 7 | 2018 | 11 | 18001002 | 1399 | 0 | TBC | weekly | |
653 | 653 | Ecuador | Ecuador | 0 | 2018-03-19 | 2018-03-25 | 7 | 2018 | 12 | 18001002 | 1283 | 0 | TBC | weekly | |
654 | 654 | Ecuador | Ecuador | 0 | 2018-03-26 | 2018-04-01 | 7 | 2018 | 13 | 18001002 | 1330 | 0 | TBC | weekly | |
655 | 655 | Ecuador | Ecuador | 0 | 2018-04-02 | 2018-04-08 | 7 | 2018 | 14 | 18001002 | 1383 | 0 | TBC | weekly | |
656 | 656 | Ecuador | Ecuador | 0 | 2018-04-09 | 2018-04-15 | 7 | 2018 | 15 | 18001002 | 1369 | 0 | TBC | weekly | |
657 | 657 | Ecuador | Ecuador | 0 | 2018-04-16 | 2018-04-22 | 7 | 2018 | 16 | 18001002 | 1334 | 0 | TBC | weekly | |
658 | 658 | Ecuador | Ecuador | 0 | 2018-04-23 | 2018-04-29 | 7 | 2018 | 17 | 18001002 | 1316 | 0 | TBC | weekly | |
659 | 659 | Ecuador | Ecuador | 0 | 2018-04-30 | 2018-05-06 | 7 | 2018 | 18 | 18001002 | 1356 | 0 | TBC | weekly | |
660 | 660 | Ecuador | Ecuador | 0 | 2018-05-07 | 2018-05-13 | 7 | 2018 | 19 | 18001002 | 1274 | 0 | TBC | weekly | |
661 | 661 | Ecuador | Ecuador | 0 | 2018-05-14 | 2018-05-20 | 7 | 2018 | 20 | 18001002 | 1429 | 0 | TBC | weekly | |
662 | 662 | Ecuador | Ecuador | 0 | 2018-05-21 | 2018-05-27 | 7 | 2018 | 21 | 18001002 | 1286 | 0 | TBC | weekly | |
663 | 663 | Ecuador | Ecuador | 0 | 2018-05-28 | 2018-06-03 | 7 | 2018 | 22 | 18001002 | 1248 | 0 | TBC | weekly | |
664 | 664 | Ecuador | Ecuador | 0 | 2018-06-04 | 2018-06-10 | 7 | 2018 | 23 | 18001002 | 1370 | 0 | TBC | weekly | |
665 | 665 | Ecuador | Ecuador | 0 | 2018-06-11 | 2018-06-17 | 7 | 2018 | 24 | 18001002 | 1357 | 0 | TBC | weekly | |
666 | 666 | Ecuador | Ecuador | 0 | 2018-06-18 | 2018-06-24 | 7 | 2018 | 25 | 18001002 | 1309 | 0 | TBC | weekly | |
667 | 667 | Ecuador | Ecuador | 0 | 2018-06-25 | 2018-07-01 | 7 | 2018 | 26 | 18001002 | 1388 | 0 | TBC | weekly | |
668 | 668 | Ecuador | Ecuador | 0 | 2018-07-02 | 2018-07-08 | 7 | 2018 | 27 | 18001002 | 1415 | 0 | TBC | weekly | |
669 | 669 | Ecuador | Ecuador | 0 | 2018-07-09 | 2018-07-15 | 7 | 2018 | 28 | 18001002 | 1368 | 0 | TBC | weekly | |
670 | 670 | Ecuador | Ecuador | 0 | 2018-07-16 | 2018-07-22 | 7 | 2018 | 29 | 18001002 | 1324 | 0 | TBC | weekly | |
671 | 671 | Ecuador | Ecuador | 0 | 2018-07-23 | 2018-07-29 | 7 | 2018 | 30 | 18001002 | 1283 | 0 | TBC | weekly | |
672 | 672 | Ecuador | Ecuador | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 18001002 | 1376 | 0 | TBC | weekly | |
673 | 673 | Ecuador | Ecuador | 0 | 2018-08-06 | 2018-08-12 | 7 | 2018 | 32 | 18001002 | 1355 | 0 | TBC | weekly | |
674 | 674 | Ecuador | Ecuador | 0 | 2018-08-13 | 2018-08-19 | 7 | 2018 | 33 | 18001002 | 1440 | 0 | TBC | weekly | |
675 | 675 | Ecuador | Ecuador | 0 | 2018-08-20 | 2018-08-26 | 7 | 2018 | 34 | 18001002 | 1318 | 0 | TBC | weekly | |
676 | 676 | Ecuador | Ecuador | 0 | 2018-08-27 | 2018-09-02 | 7 | 2018 | 35 | 18001002 | 1444 | 0 | TBC | weekly | |
677 | 677 | Ecuador | Ecuador | 0 | 2018-09-03 | 2018-09-09 | 7 | 2018 | 36 | 18001002 | 1361 | 0 | TBC | weekly | |
678 | 678 | Ecuador | Ecuador | 0 | 2018-09-10 | 2018-09-16 | 7 | 2018 | 37 | 18001002 | 1373 | 0 | TBC | weekly | |
679 | 679 | Ecuador | Ecuador | 0 | 2018-09-17 | 2018-09-23 | 7 | 2018 | 38 | 18001002 | 1296 | 0 | TBC | weekly | |
680 | 680 | Ecuador | Ecuador | 0 | 2018-09-24 | 2018-09-30 | 7 | 2018 | 39 | 18001002 | 1352 | 0 | TBC | weekly | |
681 | 681 | Ecuador | Ecuador | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 18001002 | 1403 | 0 | TBC | weekly | |
682 | 682 | Ecuador | Ecuador | 0 | 2018-10-08 | 2018-10-14 | 7 | 2018 | 41 | 18001002 | 1315 | 0 | TBC | weekly | |
683 | 683 | Ecuador | Ecuador | 0 | 2018-10-15 | 2018-10-21 | 7 | 2018 | 42 | 18001002 | 1326 | 0 | TBC | weekly | |
684 | 684 | Ecuador | Ecuador | 0 | 2018-10-22 | 2018-10-28 | 7 | 2018 | 43 | 18001002 | 1311 | 0 | TBC | weekly | |
685 | 685 | Ecuador | Ecuador | 0 | 2018-10-29 | 2018-11-04 | 7 | 2018 | 44 | 18001002 | 1370 | 0 | TBC | weekly | |
686 | 686 | Ecuador | Ecuador | 0 | 2018-11-05 | 2018-11-11 | 7 | 2018 | 45 | 18001002 | 1394 | 0 | TBC | weekly | |
687 | 687 | Ecuador | Ecuador | 0 | 2018-11-12 | 2018-11-18 | 7 | 2018 | 46 | 18001002 | 1337 | 0 | TBC | weekly | |
688 | 688 | Ecuador | Ecuador | 0 | 2018-11-19 | 2018-11-25 | 7 | 2018 | 47 | 18001002 | 1344 | 0 | TBC | weekly | |
689 | 689 | Ecuador | Ecuador | 0 | 2018-11-26 | 2018-12-02 | 7 | 2018 | 48 | 18001002 | 1331 | 0 | TBC | weekly | |
690 | 690 | Ecuador | Ecuador | 0 | 2018-12-03 | 2018-12-09 | 7 | 2018 | 49 | 18001002 | 1380 | 0 | TBC | weekly | |
691 | 691 | Ecuador | Ecuador | 0 | 2018-12-10 | 2018-12-16 | 7 | 2018 | 50 | 18001002 | 1447 | 0 | TBC | weekly | |
692 | 692 | Ecuador | Ecuador | 0 | 2018-12-17 | 2018-12-23 | 7 | 2018 | 51 | 18001002 | 1492 | 0 | TBC | weekly | |
693 | 693 | Ecuador | Ecuador | 0 | 2018-12-24 | 2018-12-30 | 7 | 2018 | 52 | 18001002 | 1501 | 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]);