economist_historical_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

830 rows where cadence = "monthly"

View and edit SQL

Suggested facets: year, covid_deaths, month, start_date (date), end_date (date)

country

cadence

  • monthly · 830
Link rowid ▼ country region region_code start_date end_date year week population total_deaths covid_deaths expected_deaths cadence month
468 Brazil Fortaleza 2304400 2016-01-01 2016-01-31 2016   2669342 1266 0 TBC monthly 1
469 Brazil Fortaleza 2304400 2016-02-01 2016-02-29 2016   2669342 1256 0 TBC monthly 2
470 Brazil Fortaleza 2304400 2016-03-01 2016-03-31 2016   2669342 1321 0 TBC monthly 3
471 Brazil Fortaleza 2304400 2016-04-01 2016-04-30 2016   2669342 1321 0 TBC monthly 4
472 Brazil Fortaleza 2304400 2016-05-01 2016-05-31 2016   2669342 1380 0 TBC monthly 5
473 Brazil Fortaleza 2304400 2016-06-01 2016-06-30 2016   2669342 1305 0 TBC monthly 6
474 Brazil Fortaleza 2304400 2016-07-01 2016-07-31 2016   2669342 1285 0 TBC monthly 7
475 Brazil Fortaleza 2304400 2016-08-01 2016-08-31 2016   2669342 1265 0 TBC monthly 8
476 Brazil Fortaleza 2304400 2016-09-01 2016-09-30 2016   2669342 1138 0 TBC monthly 9
477 Brazil Fortaleza 2304400 2016-10-01 2016-10-31 2016   2669342 1270 0 TBC monthly 10
478 Brazil Fortaleza 2304400 2016-11-01 2016-11-30 2016   2669342 1230 0 TBC monthly 11
479 Brazil Fortaleza 2304400 2016-12-01 2016-12-31 2016   2669342 1339 0 TBC monthly 12
480 Brazil Fortaleza 2304400 2017-01-01 2017-01-31 2017   2669342 1391 0 TBC monthly 1
481 Brazil Fortaleza 2304400 2017-02-01 2017-02-28 2017   2669342 1477 0 TBC monthly 2
482 Brazil Fortaleza 2304400 2017-03-01 2017-03-31 2017   2669342 1728 0 TBC monthly 3
483 Brazil Fortaleza 2304400 2017-04-01 2017-04-30 2017   2669342 1752 0 TBC monthly 4
484 Brazil Fortaleza 2304400 2017-05-01 2017-05-31 2017   2669342 1646 0 TBC monthly 5
485 Brazil Fortaleza 2304400 2017-06-01 2017-06-30 2017   2669342 1493 0 TBC monthly 6
486 Brazil Fortaleza 2304400 2017-07-01 2017-07-31 2017   2669342 1462 0 TBC monthly 7
487 Brazil Fortaleza 2304400 2017-08-01 2017-08-31 2017   2669342 1310 0 TBC monthly 8
488 Brazil Fortaleza 2304400 2017-09-01 2017-09-30 2017   2669342 1320 0 TBC monthly 9
489 Brazil Fortaleza 2304400 2017-10-01 2017-10-31 2017   2669342 1307 0 TBC monthly 10
490 Brazil Fortaleza 2304400 2017-11-01 2017-11-30 2017   2669342 1323 0 TBC monthly 11
491 Brazil Fortaleza 2304400 2017-12-01 2017-12-31 2017   2669342 1391 0 TBC monthly 12
492 Brazil Fortaleza 2304400 2018-01-01 2018-01-31 2018   2669342 1330 0 TBC monthly 1
493 Brazil Fortaleza 2304400 2018-02-01 2018-02-28 2018   2669342 1229 0 TBC monthly 2
494 Brazil Fortaleza 2304400 2018-03-01 2018-03-31 2018   2669342 1457 0 TBC monthly 3
495 Brazil Fortaleza 2304400 2018-04-01 2018-04-30 2018   2669342 1488 0 TBC monthly 4
496 Brazil Fortaleza 2304400 2018-05-01 2018-05-31 2018   2669342 1452 0 TBC monthly 5
497 Brazil Fortaleza 2304400 2018-06-01 2018-06-30 2018   2669342 1255 0 TBC monthly 6
498 Brazil Fortaleza 2304400 2018-07-01 2018-07-31 2018   2669342 1315 0 TBC monthly 7
499 Brazil Fortaleza 2304400 2018-08-01 2018-08-31 2018   2669342 1373 0 TBC monthly 8
500 Brazil Fortaleza 2304400 2018-09-01 2018-09-30 2018   2669342 1277 0 TBC monthly 9
501 Brazil Fortaleza 2304400 2018-10-01 2018-10-31 2018   2669342 1304 0 TBC monthly 10
502 Brazil Fortaleza 2304400 2018-11-01 2018-11-30 2018   2669342 1255 0 TBC monthly 11
503 Brazil Fortaleza 2304400 2018-12-01 2018-12-31 2018   2669342 1307 0 TBC monthly 12
504 Brazil Fortaleza 2304400 2019-01-01 2019-01-31 2019   2669342 1616 0 TBC monthly 1
505 Brazil Fortaleza 2304400 2019-02-01 2019-02-28 2019   2669342 1427 0 TBC monthly 2
506 Brazil Fortaleza 2304400 2019-03-01 2019-03-31 2019   2669342 1694 0 TBC monthly 3
507 Brazil Fortaleza 2304400 2019-04-01 2019-04-30 2019   2669342 1813 0 TBC monthly 4
508 Brazil Fortaleza 2304400 2019-05-01 2019-05-31 2019   2669342 1690 0 TBC monthly 5
509 Brazil Fortaleza 2304400 2019-06-01 2019-06-30 2019   2669342 1458 0 TBC monthly 6
510 Brazil Fortaleza 2304400 2019-07-01 2019-07-31 2019   2669342 1519 0 TBC monthly 7
511 Brazil Fortaleza 2304400 2019-08-01 2019-08-31 2019   2669342 1233 0 TBC monthly 8
512 Brazil Fortaleza 2304400 2019-09-01 2019-09-30 2019   2669342 1332 0 TBC monthly 9
513 Brazil Fortaleza 2304400 2019-10-01 2019-10-31 2019   2669342 1468 0 TBC monthly 10
514 Brazil Fortaleza 2304400 2019-11-01 2019-11-30 2019   2669342 1525 0 TBC monthly 11
515 Brazil Fortaleza 2304400 2019-12-01 2019-12-31 2019   2669342 1493 0 TBC monthly 12
516 Brazil Fortaleza 2304400 2020-01-01 2020-01-31 2020   2669342 1569 0 TBC monthly 1
517 Brazil Fortaleza 2304400 2020-02-01 2020-02-29 2020   2669342 1473 0 TBC monthly 2
518 Brazil Fortaleza 2304400 2020-03-01 2020-03-31 2020   2669342 1693 22 TBC monthly 3
519 Brazil Fortaleza 2304400 2020-04-01 2020-04-30 2020   2669342 2187 629 TBC monthly 4
520 Brazil Manaus 1302603 2016-01-01 2016-01-31 2016   2182763 882 0 TBC monthly 1
521 Brazil Manaus 1302603 2016-02-01 2016-02-29 2016   2182763 801 0 TBC monthly 2
522 Brazil Manaus 1302603 2016-03-01 2016-03-31 2016   2182763 857 0 TBC monthly 3
523 Brazil Manaus 1302603 2016-04-01 2016-04-30 2016   2182763 946 0 TBC monthly 4
524 Brazil Manaus 1302603 2016-05-01 2016-05-31 2016   2182763 977 0 TBC monthly 5
525 Brazil Manaus 1302603 2016-06-01 2016-06-30 2016   2182763 891 0 TBC monthly 6
526 Brazil Manaus 1302603 2016-07-01 2016-07-31 2016   2182763 918 0 TBC monthly 7
527 Brazil Manaus 1302603 2016-08-01 2016-08-31 2016   2182763 841 0 TBC monthly 8
528 Brazil Manaus 1302603 2016-09-01 2016-09-30 2016   2182763 858 0 TBC monthly 9
529 Brazil Manaus 1302603 2016-10-01 2016-10-31 2016   2182763 824 0 TBC monthly 10
530 Brazil Manaus 1302603 2016-11-01 2016-11-30 2016   2182763 765 0 TBC monthly 11
531 Brazil Manaus 1302603 2016-12-01 2016-12-31 2016   2182763 870 0 TBC monthly 12
532 Brazil Manaus 1302603 2017-01-01 2017-01-31 2017   2182763 950 0 TBC monthly 1
533 Brazil Manaus 1302603 2017-02-01 2017-02-28 2017   2182763 918 0 TBC monthly 2
534 Brazil Manaus 1302603 2017-03-01 2017-03-31 2017   2182763 943 0 TBC monthly 3
535 Brazil Manaus 1302603 2017-04-01 2017-04-30 2017   2182763 875 0 TBC monthly 4
536 Brazil Manaus 1302603 2017-05-01 2017-05-31 2017   2182763 952 0 TBC monthly 5
537 Brazil Manaus 1302603 2017-06-01 2017-06-30 2017   2182763 882 0 TBC monthly 6
538 Brazil Manaus 1302603 2017-07-01 2017-07-31 2017   2182763 931 0 TBC monthly 7
539 Brazil Manaus 1302603 2017-08-01 2017-08-31 2017   2182763 868 0 TBC monthly 8
540 Brazil Manaus 1302603 2017-09-01 2017-09-30 2017   2182763 779 0 TBC monthly 9
541 Brazil Manaus 1302603 2017-10-01 2017-10-31 2017   2182763 850 0 TBC monthly 10
542 Brazil Manaus 1302603 2017-11-01 2017-11-30 2017   2182763 821 0 TBC monthly 11
543 Brazil Manaus 1302603 2017-12-01 2017-12-31 2017   2182763 862 0 TBC monthly 12
544 Brazil Manaus 1302603 2018-01-01 2018-01-31 2018   2182763 887 0 TBC monthly 1
545 Brazil Manaus 1302603 2018-02-01 2018-02-28 2018   2182763 768 0 TBC monthly 2
546 Brazil Manaus 1302603 2018-03-01 2018-03-31 2018   2182763 836 0 TBC monthly 3
547 Brazil Manaus 1302603 2018-04-01 2018-04-30 2018   2182763 956 0 TBC monthly 4
548 Brazil Manaus 1302603 2018-05-01 2018-05-31 2018   2182763 962 0 TBC monthly 5
549 Brazil Manaus 1302603 2018-06-01 2018-06-30 2018   2182763 948 0 TBC monthly 6
550 Brazil Manaus 1302603 2018-07-01 2018-07-31 2018   2182763 953 0 TBC monthly 7
551 Brazil Manaus 1302603 2018-08-01 2018-08-31 2018   2182763 858 0 TBC monthly 8
552 Brazil Manaus 1302603 2018-09-01 2018-09-30 2018   2182763 853 0 TBC monthly 9
553 Brazil Manaus 1302603 2018-10-01 2018-10-31 2018   2182763 1031 0 TBC monthly 10
554 Brazil Manaus 1302603 2018-11-01 2018-11-30 2018   2182763 849 0 TBC monthly 11
555 Brazil Manaus 1302603 2018-12-01 2018-12-31 2018   2182763 936 0 TBC monthly 12
556 Brazil Manaus 1302603 2019-01-01 2019-01-31 2019   2182763 1013 0 TBC monthly 1
557 Brazil Manaus 1302603 2019-02-01 2019-02-28 2019   2182763 1016 0 TBC monthly 2
558 Brazil Manaus 1302603 2019-03-01 2019-03-31 2019   2182763 1056 0 TBC monthly 3
559 Brazil Manaus 1302603 2019-04-01 2019-04-30 2019   2182763 1025 0 TBC monthly 4
560 Brazil Manaus 1302603 2019-05-01 2019-05-31 2019   2182763 1025 0 TBC monthly 5
561 Brazil Manaus 1302603 2019-06-01 2019-06-30 2019   2182763 965 0 TBC monthly 6
562 Brazil Manaus 1302603 2019-07-01 2019-07-31 2019   2182763 1062 0 TBC monthly 7
563 Brazil Manaus 1302603 2019-08-01 2019-08-31 2019   2182763 1067 0 TBC monthly 8
564 Brazil Manaus 1302603 2019-09-01 2019-09-30 2019   2182763 995 0 TBC monthly 9
565 Brazil Manaus 1302603 2019-10-01 2019-10-31 2019   2182763 1053 0 TBC monthly 10
566 Brazil Manaus 1302603 2019-11-01 2019-11-30 2019   2182763 919 0 TBC monthly 11
567 Brazil Manaus 1302603 2019-12-01 2019-12-31 2019   2182763 1024 0 TBC monthly 12

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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