economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
308 rows where population = 3565287
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date), end_date (date)
country 1
- United States 308
cadence 1
- weekly 308
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23307 | 23307 | United States | Connecticut | CT | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 3565287 | 656 | 0 | 620 | weekly | |
23308 | 23308 | United States | Connecticut | CT | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 3565287 | 662 | 0 | 623 | weekly | |
23309 | 23309 | United States | Connecticut | CT | 2017-01-15 | 2017-01-21 | 7 | 2017 | 3 | 3565287 | 694 | 0 | 628 | weekly | |
23310 | 23310 | United States | Connecticut | CT | 2017-01-22 | 2017-01-28 | 7 | 2017 | 4 | 3565287 | 654 | 0 | 629 | weekly | |
23311 | 23311 | United States | Connecticut | CT | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 3565287 | 665 | 0 | 628 | weekly | |
23312 | 23312 | United States | Connecticut | CT | 2017-02-05 | 2017-02-11 | 7 | 2017 | 6 | 3565287 | 733 | 0 | 625 | weekly | |
23313 | 23313 | United States | Connecticut | CT | 2017-02-12 | 2017-02-18 | 7 | 2017 | 7 | 3565287 | 677 | 0 | 620 | weekly | |
23314 | 23314 | United States | Connecticut | CT | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 3565287 | 678 | 0 | 619 | weekly | |
23315 | 23315 | United States | Connecticut | CT | 2017-02-26 | 2017-03-04 | 7 | 2017 | 9 | 3565287 | 614 | 0 | 619 | weekly | |
23316 | 23316 | United States | Connecticut | CT | 2017-03-05 | 2017-03-11 | 7 | 2017 | 10 | 3565287 | 641 | 0 | 617 | weekly | |
23317 | 23317 | United States | Connecticut | CT | 2017-03-12 | 2017-03-18 | 7 | 2017 | 11 | 3565287 | 596 | 0 | 615 | weekly | |
23318 | 23318 | United States | Connecticut | CT | 2017-03-19 | 2017-03-25 | 7 | 2017 | 12 | 3565287 | 628 | 0 | 611 | weekly | |
23319 | 23319 | United States | Connecticut | CT | 2017-03-26 | 2017-04-01 | 7 | 2017 | 13 | 3565287 | 643 | 0 | 608 | weekly | |
23320 | 23320 | United States | Connecticut | CT | 2017-04-02 | 2017-04-08 | 7 | 2017 | 14 | 3565287 | 657 | 0 | 606 | weekly | |
23321 | 23321 | United States | Connecticut | CT | 2017-04-09 | 2017-04-15 | 7 | 2017 | 15 | 3565287 | 632 | 0 | 601 | weekly | |
23322 | 23322 | United States | Connecticut | CT | 2017-04-16 | 2017-04-22 | 7 | 2017 | 16 | 3565287 | 602 | 0 | 589 | weekly | |
23323 | 23323 | United States | Connecticut | CT | 2017-04-23 | 2017-04-29 | 7 | 2017 | 17 | 3565287 | 617 | 0 | 586 | weekly | |
23324 | 23324 | United States | Connecticut | CT | 2017-04-30 | 2017-05-06 | 7 | 2017 | 18 | 3565287 | 541 | 0 | 583 | weekly | |
23325 | 23325 | United States | Connecticut | CT | 2017-05-07 | 2017-05-13 | 7 | 2017 | 19 | 3565287 | 561 | 0 | 578 | weekly | |
23326 | 23326 | United States | Connecticut | CT | 2017-05-14 | 2017-05-20 | 7 | 2017 | 20 | 3565287 | 559 | 0 | 573 | weekly | |
23327 | 23327 | United States | Connecticut | CT | 2017-05-21 | 2017-05-27 | 7 | 2017 | 21 | 3565287 | 580 | 0 | 570 | weekly | |
23328 | 23328 | United States | Connecticut | CT | 2017-05-28 | 2017-06-03 | 7 | 2017 | 22 | 3565287 | 589 | 0 | 564 | weekly | |
23329 | 23329 | United States | Connecticut | CT | 2017-06-04 | 2017-06-10 | 7 | 2017 | 23 | 3565287 | 575 | 0 | 558 | weekly | |
23330 | 23330 | United States | Connecticut | CT | 2017-06-11 | 2017-06-17 | 7 | 2017 | 24 | 3565287 | 582 | 0 | 553 | weekly | |
23331 | 23331 | United States | Connecticut | CT | 2017-06-18 | 2017-06-24 | 7 | 2017 | 25 | 3565287 | 606 | 0 | 548 | weekly | |
23332 | 23332 | United States | Connecticut | CT | 2017-06-25 | 2017-07-01 | 7 | 2017 | 26 | 3565287 | 568 | 0 | 547 | weekly | |
23333 | 23333 | United States | Connecticut | CT | 2017-07-02 | 2017-07-08 | 7 | 2017 | 27 | 3565287 | 550 | 0 | 544 | weekly | |
23334 | 23334 | United States | Connecticut | CT | 2017-07-09 | 2017-07-15 | 7 | 2017 | 28 | 3565287 | 552 | 0 | 544 | weekly | |
23335 | 23335 | United States | Connecticut | CT | 2017-07-16 | 2017-07-22 | 7 | 2017 | 29 | 3565287 | 571 | 0 | 541 | weekly | |
23336 | 23336 | United States | Connecticut | CT | 2017-07-23 | 2017-07-29 | 7 | 2017 | 30 | 3565287 | 555 | 0 | 543 | weekly | |
23337 | 23337 | United States | Connecticut | CT | 2017-07-30 | 2017-08-05 | 7 | 2017 | 31 | 3565287 | 582 | 0 | 543 | weekly | |
23338 | 23338 | United States | Connecticut | CT | 2017-08-06 | 2017-08-12 | 7 | 2017 | 32 | 3565287 | 531 | 0 | 546 | weekly | |
23339 | 23339 | United States | Connecticut | CT | 2017-08-13 | 2017-08-19 | 7 | 2017 | 33 | 3565287 | 528 | 0 | 554 | weekly | |
23340 | 23340 | United States | Connecticut | CT | 2017-08-20 | 2017-08-26 | 7 | 2017 | 34 | 3565287 | 540 | 0 | 554 | weekly | |
23341 | 23341 | United States | Connecticut | CT | 2017-08-27 | 2017-09-02 | 7 | 2017 | 35 | 3565287 | 536 | 0 | 554 | weekly | |
23342 | 23342 | United States | Connecticut | CT | 2017-09-03 | 2017-09-09 | 7 | 2017 | 36 | 3565287 | 567 | 0 | 560 | weekly | |
23343 | 23343 | United States | Connecticut | CT | 2017-09-10 | 2017-09-16 | 7 | 2017 | 37 | 3565287 | 601 | 0 | 566 | weekly | |
23344 | 23344 | United States | Connecticut | CT | 2017-09-17 | 2017-09-23 | 7 | 2017 | 38 | 3565287 | 563 | 0 | 573 | weekly | |
23345 | 23345 | United States | Connecticut | CT | 2017-09-24 | 2017-09-30 | 7 | 2017 | 39 | 3565287 | 545 | 0 | 581 | weekly | |
23346 | 23346 | United States | Connecticut | CT | 2017-10-01 | 2017-10-07 | 7 | 2017 | 40 | 3565287 | 599 | 0 | 588 | weekly | |
23347 | 23347 | United States | Connecticut | CT | 2017-10-08 | 2017-10-14 | 7 | 2017 | 41 | 3565287 | 608 | 0 | 593 | weekly | |
23348 | 23348 | United States | Connecticut | CT | 2017-10-15 | 2017-10-21 | 7 | 2017 | 42 | 3565287 | 565 | 0 | 595 | weekly | |
23349 | 23349 | United States | Connecticut | CT | 2017-10-22 | 2017-10-28 | 7 | 2017 | 43 | 3565287 | 542 | 0 | 598 | weekly | |
23350 | 23350 | United States | Connecticut | CT | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 3565287 | 598 | 0 | 607 | weekly | |
23351 | 23351 | United States | Connecticut | CT | 2017-11-05 | 2017-11-11 | 7 | 2017 | 45 | 3565287 | 595 | 0 | 614 | weekly | |
23352 | 23352 | United States | Connecticut | CT | 2017-11-12 | 2017-11-18 | 7 | 2017 | 46 | 3565287 | 647 | 0 | 614 | weekly | |
23353 | 23353 | United States | Connecticut | CT | 2017-11-19 | 2017-11-25 | 7 | 2017 | 47 | 3565287 | 590 | 0 | 620 | weekly | |
23354 | 23354 | United States | Connecticut | CT | 2017-11-26 | 2017-12-02 | 7 | 2017 | 48 | 3565287 | 626 | 0 | 630 | weekly | |
23355 | 23355 | United States | Connecticut | CT | 2017-12-03 | 2017-12-09 | 7 | 2017 | 49 | 3565287 | 677 | 0 | 637 | weekly | |
23356 | 23356 | United States | Connecticut | CT | 2017-12-10 | 2017-12-16 | 7 | 2017 | 50 | 3565287 | 644 | 0 | 644 | weekly | |
23357 | 23357 | United States | Connecticut | CT | 2017-12-17 | 2017-12-23 | 7 | 2017 | 51 | 3565287 | 670 | 0 | 652 | weekly | |
23358 | 23358 | United States | Connecticut | CT | 2017-12-24 | 2017-12-30 | 7 | 2017 | 52 | 3565287 | 662 | 0 | 657 | weekly | |
23359 | 23359 | United States | Connecticut | CT | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 3565287 | 692 | 0 | 665 | weekly | |
23360 | 23360 | United States | Connecticut | CT | 2018-01-07 | 2018-01-13 | 7 | 2018 | 2 | 3565287 | 793 | 0 | 667 | weekly | |
23361 | 23361 | United States | Connecticut | CT | 2018-01-14 | 2018-01-20 | 7 | 2018 | 3 | 3565287 | 685 | 0 | 678 | weekly | |
23362 | 23362 | United States | Connecticut | CT | 2018-01-21 | 2018-01-27 | 7 | 2018 | 4 | 3565287 | 672 | 0 | 682 | weekly | |
23363 | 23363 | United States | Connecticut | CT | 2018-01-28 | 2018-02-03 | 7 | 2018 | 5 | 3565287 | 656 | 0 | 681 | weekly | |
23364 | 23364 | United States | Connecticut | CT | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 3565287 | 671 | 0 | 680 | weekly | |
23365 | 23365 | United States | Connecticut | CT | 2018-02-11 | 2018-02-17 | 7 | 2018 | 7 | 3565287 | 639 | 0 | 677 | weekly | |
23366 | 23366 | United States | Connecticut | CT | 2018-02-18 | 2018-02-24 | 7 | 2018 | 8 | 3565287 | 632 | 0 | 673 | weekly | |
23367 | 23367 | United States | Connecticut | CT | 2018-02-25 | 2018-03-03 | 7 | 2018 | 9 | 3565287 | 630 | 0 | 668 | weekly | |
23368 | 23368 | United States | Connecticut | CT | 2018-03-04 | 2018-03-10 | 7 | 2018 | 10 | 3565287 | 617 | 0 | 663 | weekly | |
23369 | 23369 | United States | Connecticut | CT | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 3565287 | 613 | 0 | 656 | weekly | |
23370 | 23370 | United States | Connecticut | CT | 2018-03-18 | 2018-03-24 | 7 | 2018 | 12 | 3565287 | 609 | 0 | 646 | weekly | |
23371 | 23371 | United States | Connecticut | CT | 2018-03-25 | 2018-03-31 | 7 | 2018 | 13 | 3565287 | 626 | 0 | 642 | weekly | |
23372 | 23372 | United States | Connecticut | CT | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 3565287 | 658 | 0 | 634 | weekly | |
23373 | 23373 | United States | Connecticut | CT | 2018-04-08 | 2018-04-14 | 7 | 2018 | 15 | 3565287 | 660 | 0 | 624 | weekly | |
23374 | 23374 | United States | Connecticut | CT | 2018-04-15 | 2018-04-21 | 7 | 2018 | 16 | 3565287 | 581 | 0 | 613 | weekly | |
23375 | 23375 | United States | Connecticut | CT | 2018-04-22 | 2018-04-28 | 7 | 2018 | 17 | 3565287 | 654 | 0 | 606 | weekly | |
23376 | 23376 | United States | Connecticut | CT | 2018-04-29 | 2018-05-05 | 7 | 2018 | 18 | 3565287 | 591 | 0 | 601 | weekly | |
23377 | 23377 | United States | Connecticut | CT | 2018-05-06 | 2018-05-12 | 7 | 2018 | 19 | 3565287 | 593 | 0 | 594 | weekly | |
23378 | 23378 | United States | Connecticut | CT | 2018-05-13 | 2018-05-19 | 7 | 2018 | 20 | 3565287 | 546 | 0 | 590 | weekly | |
23379 | 23379 | United States | Connecticut | CT | 2018-05-20 | 2018-05-26 | 7 | 2018 | 21 | 3565287 | 573 | 0 | 589 | weekly | |
23380 | 23380 | United States | Connecticut | CT | 2018-05-27 | 2018-06-02 | 7 | 2018 | 22 | 3565287 | 534 | 0 | 584 | weekly | |
23381 | 23381 | United States | Connecticut | CT | 2018-06-03 | 2018-06-09 | 7 | 2018 | 23 | 3565287 | 573 | 0 | 582 | weekly | |
23382 | 23382 | United States | Connecticut | CT | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 3565287 | 543 | 0 | 577 | weekly | |
23383 | 23383 | United States | Connecticut | CT | 2018-06-17 | 2018-06-23 | 7 | 2018 | 25 | 3565287 | 544 | 0 | 571 | weekly | |
23384 | 23384 | United States | Connecticut | CT | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 3565287 | 546 | 0 | 565 | weekly | |
23385 | 23385 | United States | Connecticut | CT | 2018-07-01 | 2018-07-07 | 7 | 2018 | 27 | 3565287 | 610 | 0 | 560 | weekly | |
23386 | 23386 | United States | Connecticut | CT | 2018-07-08 | 2018-07-14 | 7 | 2018 | 28 | 3565287 | 573 | 0 | 557 | weekly | |
23387 | 23387 | United States | Connecticut | CT | 2018-07-15 | 2018-07-21 | 7 | 2018 | 29 | 3565287 | 574 | 0 | 554 | weekly | |
23388 | 23388 | United States | Connecticut | CT | 2018-07-22 | 2018-07-28 | 7 | 2018 | 30 | 3565287 | 536 | 0 | 551 | weekly | |
23389 | 23389 | United States | Connecticut | CT | 2018-07-29 | 2018-08-04 | 7 | 2018 | 31 | 3565287 | 591 | 0 | 550 | weekly | |
23390 | 23390 | United States | Connecticut | CT | 2018-08-05 | 2018-08-11 | 7 | 2018 | 32 | 3565287 | 555 | 0 | 547 | weekly | |
23391 | 23391 | United States | Connecticut | CT | 2018-08-12 | 2018-08-18 | 7 | 2018 | 33 | 3565287 | 539 | 0 | 547 | weekly | |
23392 | 23392 | United States | Connecticut | CT | 2018-08-19 | 2018-08-25 | 7 | 2018 | 34 | 3565287 | 552 | 0 | 545 | weekly | |
23393 | 23393 | United States | Connecticut | CT | 2018-08-26 | 2018-09-01 | 7 | 2018 | 35 | 3565287 | 559 | 0 | 546 | weekly | |
23394 | 23394 | United States | Connecticut | CT | 2018-09-02 | 2018-09-08 | 7 | 2018 | 36 | 3565287 | 574 | 0 | 548 | weekly | |
23395 | 23395 | United States | Connecticut | CT | 2018-09-09 | 2018-09-15 | 7 | 2018 | 37 | 3565287 | 567 | 0 | 555 | weekly | |
23396 | 23396 | United States | Connecticut | CT | 2018-09-16 | 2018-09-22 | 7 | 2018 | 38 | 3565287 | 573 | 0 | 556 | weekly | |
23397 | 23397 | United States | Connecticut | CT | 2018-09-23 | 2018-09-29 | 7 | 2018 | 39 | 3565287 | 585 | 0 | 562 | weekly | |
23398 | 23398 | United States | Connecticut | CT | 2018-09-30 | 2018-10-06 | 7 | 2018 | 40 | 3565287 | 577 | 0 | 568 | weekly | |
23399 | 23399 | United States | Connecticut | CT | 2018-10-07 | 2018-10-13 | 7 | 2018 | 41 | 3565287 | 563 | 0 | 570 | weekly | |
23400 | 23400 | United States | Connecticut | CT | 2018-10-14 | 2018-10-20 | 7 | 2018 | 42 | 3565287 | 613 | 0 | 576 | weekly | |
23401 | 23401 | United States | Connecticut | CT | 2018-10-21 | 2018-10-27 | 7 | 2018 | 43 | 3565287 | 614 | 0 | 578 | weekly | |
23402 | 23402 | United States | Connecticut | CT | 2018-10-28 | 2018-11-03 | 7 | 2018 | 44 | 3565287 | 608 | 0 | 585 | weekly | |
23403 | 23403 | United States | Connecticut | CT | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 3565287 | 576 | 0 | 591 | weekly | |
23404 | 23404 | United States | Connecticut | CT | 2018-11-11 | 2018-11-17 | 7 | 2018 | 46 | 3565287 | 595 | 0 | 590 | weekly | |
23405 | 23405 | United States | Connecticut | CT | 2018-11-18 | 2018-11-24 | 7 | 2018 | 47 | 3565287 | 614 | 0 | 599 | weekly | |
23406 | 23406 | United States | Connecticut | CT | 2018-11-25 | 2018-12-01 | 7 | 2018 | 48 | 3565287 | 617 | 0 | 605 | 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]);