economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
308 rows where region_code = "IA"
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: year, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26079 | 26079 | United States | Iowa | IA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 3155070 | 655 | 0 | 603 | weekly | |
26080 | 26080 | United States | Iowa | IA | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 3155070 | 716 | 0 | 605 | weekly | |
26081 | 26081 | United States | Iowa | IA | 2017-01-15 | 2017-01-21 | 7 | 2017 | 3 | 3155070 | 673 | 0 | 607 | weekly | |
26082 | 26082 | United States | Iowa | IA | 2017-01-22 | 2017-01-28 | 7 | 2017 | 4 | 3155070 | 650 | 0 | 609 | weekly | |
26083 | 26083 | United States | Iowa | IA | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 3155070 | 672 | 0 | 610 | weekly | |
26084 | 26084 | United States | Iowa | IA | 2017-02-05 | 2017-02-11 | 7 | 2017 | 6 | 3155070 | 634 | 0 | 604 | weekly | |
26085 | 26085 | United States | Iowa | IA | 2017-02-12 | 2017-02-18 | 7 | 2017 | 7 | 3155070 | 658 | 0 | 603 | weekly | |
26086 | 26086 | United States | Iowa | IA | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 3155070 | 603 | 0 | 595 | weekly | |
26087 | 26087 | United States | Iowa | IA | 2017-02-26 | 2017-03-04 | 7 | 2017 | 9 | 3155070 | 626 | 0 | 593 | weekly | |
26088 | 26088 | United States | Iowa | IA | 2017-03-05 | 2017-03-11 | 7 | 2017 | 10 | 3155070 | 609 | 0 | 589 | weekly | |
26089 | 26089 | United States | Iowa | IA | 2017-03-12 | 2017-03-18 | 7 | 2017 | 11 | 3155070 | 595 | 0 | 585 | weekly | |
26090 | 26090 | United States | Iowa | IA | 2017-03-19 | 2017-03-25 | 7 | 2017 | 12 | 3155070 | 637 | 0 | 579 | weekly | |
26091 | 26091 | United States | Iowa | IA | 2017-03-26 | 2017-04-01 | 7 | 2017 | 13 | 3155070 | 576 | 0 | 578 | weekly | |
26092 | 26092 | United States | Iowa | IA | 2017-04-02 | 2017-04-08 | 7 | 2017 | 14 | 3155070 | 551 | 0 | 575 | weekly | |
26093 | 26093 | United States | Iowa | IA | 2017-04-09 | 2017-04-15 | 7 | 2017 | 15 | 3155070 | 611 | 0 | 568 | weekly | |
26094 | 26094 | United States | Iowa | IA | 2017-04-16 | 2017-04-22 | 7 | 2017 | 16 | 3155070 | 577 | 0 | 564 | weekly | |
26095 | 26095 | United States | Iowa | IA | 2017-04-23 | 2017-04-29 | 7 | 2017 | 17 | 3155070 | 597 | 0 | 559 | weekly | |
26096 | 26096 | United States | Iowa | IA | 2017-04-30 | 2017-05-06 | 7 | 2017 | 18 | 3155070 | 626 | 0 | 553 | weekly | |
26097 | 26097 | United States | Iowa | IA | 2017-05-07 | 2017-05-13 | 7 | 2017 | 19 | 3155070 | 535 | 0 | 548 | weekly | |
26098 | 26098 | United States | Iowa | IA | 2017-05-14 | 2017-05-20 | 7 | 2017 | 20 | 3155070 | 554 | 0 | 543 | weekly | |
26099 | 26099 | United States | Iowa | IA | 2017-05-21 | 2017-05-27 | 7 | 2017 | 21 | 3155070 | 547 | 0 | 542 | weekly | |
26100 | 26100 | United States | Iowa | IA | 2017-05-28 | 2017-06-03 | 7 | 2017 | 22 | 3155070 | 571 | 0 | 538 | weekly | |
26101 | 26101 | United States | Iowa | IA | 2017-06-04 | 2017-06-10 | 7 | 2017 | 23 | 3155070 | 541 | 0 | 534 | weekly | |
26102 | 26102 | United States | Iowa | IA | 2017-06-11 | 2017-06-17 | 7 | 2017 | 24 | 3155070 | 535 | 0 | 532 | weekly | |
26103 | 26103 | United States | Iowa | IA | 2017-06-18 | 2017-06-24 | 7 | 2017 | 25 | 3155070 | 534 | 0 | 533 | weekly | |
26104 | 26104 | United States | Iowa | IA | 2017-06-25 | 2017-07-01 | 7 | 2017 | 26 | 3155070 | 533 | 0 | 531 | weekly | |
26105 | 26105 | United States | Iowa | IA | 2017-07-02 | 2017-07-08 | 7 | 2017 | 27 | 3155070 | 518 | 0 | 531 | weekly | |
26106 | 26106 | United States | Iowa | IA | 2017-07-09 | 2017-07-15 | 7 | 2017 | 28 | 3155070 | 506 | 0 | 535 | weekly | |
26107 | 26107 | United States | Iowa | IA | 2017-07-16 | 2017-07-22 | 7 | 2017 | 29 | 3155070 | 469 | 0 | 535 | weekly | |
26108 | 26108 | United States | Iowa | IA | 2017-07-23 | 2017-07-29 | 7 | 2017 | 30 | 3155070 | 540 | 0 | 541 | weekly | |
26109 | 26109 | United States | Iowa | IA | 2017-07-30 | 2017-08-05 | 7 | 2017 | 31 | 3155070 | 508 | 0 | 541 | weekly | |
26110 | 26110 | United States | Iowa | IA | 2017-08-06 | 2017-08-12 | 7 | 2017 | 32 | 3155070 | 497 | 0 | 542 | weekly | |
26111 | 26111 | United States | Iowa | IA | 2017-08-13 | 2017-08-19 | 7 | 2017 | 33 | 3155070 | 528 | 0 | 546 | weekly | |
26112 | 26112 | United States | Iowa | IA | 2017-08-20 | 2017-08-26 | 7 | 2017 | 34 | 3155070 | 510 | 0 | 549 | weekly | |
26113 | 26113 | United States | Iowa | IA | 2017-08-27 | 2017-09-02 | 7 | 2017 | 35 | 3155070 | 511 | 0 | 556 | weekly | |
26114 | 26114 | United States | Iowa | IA | 2017-09-03 | 2017-09-09 | 7 | 2017 | 36 | 3155070 | 542 | 0 | 560 | weekly | |
26115 | 26115 | United States | Iowa | IA | 2017-09-10 | 2017-09-16 | 7 | 2017 | 37 | 3155070 | 543 | 0 | 562 | weekly | |
26116 | 26116 | United States | Iowa | IA | 2017-09-17 | 2017-09-23 | 7 | 2017 | 38 | 3155070 | 575 | 0 | 568 | weekly | |
26117 | 26117 | United States | Iowa | IA | 2017-09-24 | 2017-09-30 | 7 | 2017 | 39 | 3155070 | 547 | 0 | 580 | weekly | |
26118 | 26118 | United States | Iowa | IA | 2017-10-01 | 2017-10-07 | 7 | 2017 | 40 | 3155070 | 559 | 0 | 585 | weekly | |
26119 | 26119 | United States | Iowa | IA | 2017-10-08 | 2017-10-14 | 7 | 2017 | 41 | 3155070 | 550 | 0 | 591 | weekly | |
26120 | 26120 | United States | Iowa | IA | 2017-10-15 | 2017-10-21 | 7 | 2017 | 42 | 3155070 | 558 | 0 | 593 | weekly | |
26121 | 26121 | United States | Iowa | IA | 2017-10-22 | 2017-10-28 | 7 | 2017 | 43 | 3155070 | 561 | 0 | 598 | weekly | |
26122 | 26122 | United States | Iowa | IA | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 3155070 | 630 | 0 | 607 | weekly | |
26123 | 26123 | United States | Iowa | IA | 2017-11-05 | 2017-11-11 | 7 | 2017 | 45 | 3155070 | 600 | 0 | 615 | weekly | |
26124 | 26124 | United States | Iowa | IA | 2017-11-12 | 2017-11-18 | 7 | 2017 | 46 | 3155070 | 596 | 0 | 620 | weekly | |
26125 | 26125 | United States | Iowa | IA | 2017-11-19 | 2017-11-25 | 7 | 2017 | 47 | 3155070 | 626 | 0 | 625 | weekly | |
26126 | 26126 | United States | Iowa | IA | 2017-11-26 | 2017-12-02 | 7 | 2017 | 48 | 3155070 | 582 | 0 | 635 | weekly | |
26127 | 26127 | United States | Iowa | IA | 2017-12-03 | 2017-12-09 | 7 | 2017 | 49 | 3155070 | 590 | 0 | 641 | weekly | |
26128 | 26128 | United States | Iowa | IA | 2017-12-10 | 2017-12-16 | 7 | 2017 | 50 | 3155070 | 604 | 0 | 650 | weekly | |
26129 | 26129 | United States | Iowa | IA | 2017-12-17 | 2017-12-23 | 7 | 2017 | 51 | 3155070 | 638 | 0 | 650 | weekly | |
26130 | 26130 | United States | Iowa | IA | 2017-12-24 | 2017-12-30 | 7 | 2017 | 52 | 3155070 | 637 | 0 | 649 | weekly | |
26131 | 26131 | United States | Iowa | IA | 2017-12-31 | 2018-01-06 | 7 | 2018 | 1 | 3155070 | 667 | 0 | 649 | weekly | |
26132 | 26132 | United States | Iowa | IA | 2018-01-07 | 2018-01-13 | 7 | 2018 | 2 | 3155070 | 675 | 0 | 653 | weekly | |
26133 | 26133 | United States | Iowa | IA | 2018-01-14 | 2018-01-20 | 7 | 2018 | 3 | 3155070 | 661 | 0 | 651 | weekly | |
26134 | 26134 | United States | Iowa | IA | 2018-01-21 | 2018-01-27 | 7 | 2018 | 4 | 3155070 | 640 | 0 | 650 | weekly | |
26135 | 26135 | United States | Iowa | IA | 2018-01-28 | 2018-02-03 | 7 | 2018 | 5 | 3155070 | 610 | 0 | 648 | weekly | |
26136 | 26136 | United States | Iowa | IA | 2018-02-04 | 2018-02-10 | 7 | 2018 | 6 | 3155070 | 649 | 0 | 646 | weekly | |
26137 | 26137 | United States | Iowa | IA | 2018-02-11 | 2018-02-17 | 7 | 2018 | 7 | 3155070 | 663 | 0 | 647 | weekly | |
26138 | 26138 | United States | Iowa | IA | 2018-02-18 | 2018-02-24 | 7 | 2018 | 8 | 3155070 | 671 | 0 | 633 | weekly | |
26139 | 26139 | United States | Iowa | IA | 2018-02-25 | 2018-03-03 | 7 | 2018 | 9 | 3155070 | 599 | 0 | 625 | weekly | |
26140 | 26140 | United States | Iowa | IA | 2018-03-04 | 2018-03-10 | 7 | 2018 | 10 | 3155070 | 600 | 0 | 616 | weekly | |
26141 | 26141 | United States | Iowa | IA | 2018-03-11 | 2018-03-17 | 7 | 2018 | 11 | 3155070 | 600 | 0 | 608 | weekly | |
26142 | 26142 | United States | Iowa | IA | 2018-03-18 | 2018-03-24 | 7 | 2018 | 12 | 3155070 | 595 | 0 | 610 | weekly | |
26143 | 26143 | United States | Iowa | IA | 2018-03-25 | 2018-03-31 | 7 | 2018 | 13 | 3155070 | 568 | 0 | 602 | weekly | |
26144 | 26144 | United States | Iowa | IA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 3155070 | 614 | 0 | 592 | weekly | |
26145 | 26145 | United States | Iowa | IA | 2018-04-08 | 2018-04-14 | 7 | 2018 | 15 | 3155070 | 580 | 0 | 588 | weekly | |
26146 | 26146 | United States | Iowa | IA | 2018-04-15 | 2018-04-21 | 7 | 2018 | 16 | 3155070 | 576 | 0 | 583 | weekly | |
26147 | 26147 | United States | Iowa | IA | 2018-04-22 | 2018-04-28 | 7 | 2018 | 17 | 3155070 | 594 | 0 | 586 | weekly | |
26148 | 26148 | United States | Iowa | IA | 2018-04-29 | 2018-05-05 | 7 | 2018 | 18 | 3155070 | 588 | 0 | 572 | weekly | |
26149 | 26149 | United States | Iowa | IA | 2018-05-06 | 2018-05-12 | 7 | 2018 | 19 | 3155070 | 561 | 0 | 562 | weekly | |
26150 | 26150 | United States | Iowa | IA | 2018-05-13 | 2018-05-19 | 7 | 2018 | 20 | 3155070 | 545 | 0 | 552 | weekly | |
26151 | 26151 | United States | Iowa | IA | 2018-05-20 | 2018-05-26 | 7 | 2018 | 21 | 3155070 | 553 | 0 | 549 | weekly | |
26152 | 26152 | United States | Iowa | IA | 2018-05-27 | 2018-06-02 | 7 | 2018 | 22 | 3155070 | 476 | 0 | 542 | weekly | |
26153 | 26153 | United States | Iowa | IA | 2018-06-03 | 2018-06-09 | 7 | 2018 | 23 | 3155070 | 552 | 0 | 540 | weekly | |
26154 | 26154 | United States | Iowa | IA | 2018-06-10 | 2018-06-16 | 7 | 2018 | 24 | 3155070 | 573 | 0 | 538 | weekly | |
26155 | 26155 | United States | Iowa | IA | 2018-06-17 | 2018-06-23 | 7 | 2018 | 25 | 3155070 | 554 | 0 | 530 | weekly | |
26156 | 26156 | United States | Iowa | IA | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 3155070 | 553 | 0 | 525 | weekly | |
26157 | 26157 | United States | Iowa | IA | 2018-07-01 | 2018-07-07 | 7 | 2018 | 27 | 3155070 | 506 | 0 | 522 | weekly | |
26158 | 26158 | United States | Iowa | IA | 2018-07-08 | 2018-07-14 | 7 | 2018 | 28 | 3155070 | 534 | 0 | 522 | weekly | |
26159 | 26159 | United States | Iowa | IA | 2018-07-15 | 2018-07-21 | 7 | 2018 | 29 | 3155070 | 514 | 0 | 520 | weekly | |
26160 | 26160 | United States | Iowa | IA | 2018-07-22 | 2018-07-28 | 7 | 2018 | 30 | 3155070 | 541 | 0 | 516 | weekly | |
26161 | 26161 | United States | Iowa | IA | 2018-07-29 | 2018-08-04 | 7 | 2018 | 31 | 3155070 | 499 | 0 | 515 | weekly | |
26162 | 26162 | United States | Iowa | IA | 2018-08-05 | 2018-08-11 | 7 | 2018 | 32 | 3155070 | 544 | 0 | 520 | weekly | |
26163 | 26163 | United States | Iowa | IA | 2018-08-12 | 2018-08-18 | 7 | 2018 | 33 | 3155070 | 509 | 0 | 525 | weekly | |
26164 | 26164 | United States | Iowa | IA | 2018-08-19 | 2018-08-25 | 7 | 2018 | 34 | 3155070 | 537 | 0 | 524 | weekly | |
26165 | 26165 | United States | Iowa | IA | 2018-08-26 | 2018-09-01 | 7 | 2018 | 35 | 3155070 | 560 | 0 | 522 | weekly | |
26166 | 26166 | United States | Iowa | IA | 2018-09-02 | 2018-09-08 | 7 | 2018 | 36 | 3155070 | 513 | 0 | 525 | weekly | |
26167 | 26167 | United States | Iowa | IA | 2018-09-09 | 2018-09-15 | 7 | 2018 | 37 | 3155070 | 535 | 0 | 538 | weekly | |
26168 | 26168 | United States | Iowa | IA | 2018-09-16 | 2018-09-22 | 7 | 2018 | 38 | 3155070 | 514 | 0 | 536 | weekly | |
26169 | 26169 | United States | Iowa | IA | 2018-09-23 | 2018-09-29 | 7 | 2018 | 39 | 3155070 | 583 | 0 | 533 | weekly | |
26170 | 26170 | United States | Iowa | IA | 2018-09-30 | 2018-10-06 | 7 | 2018 | 40 | 3155070 | 634 | 0 | 535 | weekly | |
26171 | 26171 | United States | Iowa | IA | 2018-10-07 | 2018-10-13 | 7 | 2018 | 41 | 3155070 | 536 | 0 | 536 | weekly | |
26172 | 26172 | United States | Iowa | IA | 2018-10-14 | 2018-10-20 | 7 | 2018 | 42 | 3155070 | 614 | 0 | 552 | weekly | |
26173 | 26173 | United States | Iowa | IA | 2018-10-21 | 2018-10-27 | 7 | 2018 | 43 | 3155070 | 615 | 0 | 551 | weekly | |
26174 | 26174 | United States | Iowa | IA | 2018-10-28 | 2018-11-03 | 7 | 2018 | 44 | 3155070 | 564 | 0 | 547 | weekly | |
26175 | 26175 | United States | Iowa | IA | 2018-11-04 | 2018-11-10 | 7 | 2018 | 45 | 3155070 | 560 | 0 | 557 | weekly | |
26176 | 26176 | United States | Iowa | IA | 2018-11-11 | 2018-11-17 | 7 | 2018 | 46 | 3155070 | 604 | 0 | 562 | weekly | |
26177 | 26177 | United States | Iowa | IA | 2018-11-18 | 2018-11-24 | 7 | 2018 | 47 | 3155070 | 579 | 0 | 580 | weekly | |
26178 | 26178 | United States | Iowa | IA | 2018-11-25 | 2018-12-01 | 7 | 2018 | 48 | 3155070 | 613 | 0 | 588 | 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]);