ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where deaths = 10, fips = 23001 and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
687980 | 687980 | 2020-11-01 | Androscoggin | Maine | 23001 | 876 | 10 |
684736 | 684736 | 2020-10-31 | Androscoggin | Maine | 23001 | 873 | 10 |
681493 | 681493 | 2020-10-30 | Androscoggin | Maine | 23001 | 868 | 10 |
678249 | 678249 | 2020-10-29 | Androscoggin | Maine | 23001 | 862 | 10 |
675007 | 675007 | 2020-10-28 | Androscoggin | Maine | 23001 | 855 | 10 |
671764 | 671764 | 2020-10-27 | Androscoggin | Maine | 23001 | 852 | 10 |
668522 | 668522 | 2020-10-26 | Androscoggin | Maine | 23001 | 849 | 10 |
665278 | 665278 | 2020-10-25 | Androscoggin | Maine | 23001 | 847 | 10 |
662033 | 662033 | 2020-10-24 | Androscoggin | Maine | 23001 | 845 | 10 |
658789 | 658789 | 2020-10-23 | Androscoggin | Maine | 23001 | 841 | 10 |
655544 | 655544 | 2020-10-22 | Androscoggin | Maine | 23001 | 840 | 10 |
652299 | 652299 | 2020-10-21 | Androscoggin | Maine | 23001 | 839 | 10 |
649054 | 649054 | 2020-10-20 | Androscoggin | Maine | 23001 | 839 | 10 |
645810 | 645810 | 2020-10-19 | Androscoggin | Maine | 23001 | 834 | 10 |
642563 | 642563 | 2020-10-18 | Androscoggin | Maine | 23001 | 833 | 10 |
639316 | 639316 | 2020-10-17 | Androscoggin | Maine | 23001 | 832 | 10 |
636070 | 636070 | 2020-10-16 | Androscoggin | Maine | 23001 | 830 | 10 |
632824 | 632824 | 2020-10-15 | Androscoggin | Maine | 23001 | 826 | 10 |
629580 | 629580 | 2020-10-14 | Androscoggin | Maine | 23001 | 823 | 10 |
626336 | 626336 | 2020-10-13 | Androscoggin | Maine | 23001 | 817 | 10 |
623094 | 623094 | 2020-10-12 | Androscoggin | Maine | 23001 | 815 | 10 |
619850 | 619850 | 2020-10-11 | Androscoggin | Maine | 23001 | 807 | 10 |
616608 | 616608 | 2020-10-10 | Androscoggin | Maine | 23001 | 799 | 10 |
613367 | 613367 | 2020-10-09 | Androscoggin | Maine | 23001 | 791 | 10 |
610125 | 610125 | 2020-10-08 | Androscoggin | Maine | 23001 | 786 | 10 |
606883 | 606883 | 2020-10-07 | Androscoggin | Maine | 23001 | 780 | 10 |
603641 | 603641 | 2020-10-06 | Androscoggin | Maine | 23001 | 775 | 10 |
600398 | 600398 | 2020-10-05 | Androscoggin | Maine | 23001 | 771 | 10 |
597156 | 597156 | 2020-10-04 | Androscoggin | Maine | 23001 | 767 | 10 |
593914 | 593914 | 2020-10-03 | Androscoggin | Maine | 23001 | 758 | 10 |
590673 | 590673 | 2020-10-02 | Androscoggin | Maine | 23001 | 754 | 10 |
587432 | 587432 | 2020-10-01 | Androscoggin | Maine | 23001 | 751 | 10 |
584192 | 584192 | 2020-09-30 | Androscoggin | Maine | 23001 | 737 | 10 |
580952 | 580952 | 2020-09-29 | Androscoggin | Maine | 23001 | 723 | 10 |
577711 | 577711 | 2020-09-28 | Androscoggin | Maine | 23001 | 714 | 10 |
574469 | 574469 | 2020-09-27 | Androscoggin | Maine | 23001 | 711 | 10 |
571226 | 571226 | 2020-09-26 | Androscoggin | Maine | 23001 | 706 | 10 |
567984 | 567984 | 2020-09-25 | Androscoggin | Maine | 23001 | 705 | 10 |
564744 | 564744 | 2020-09-24 | Androscoggin | Maine | 23001 | 698 | 10 |
561504 | 561504 | 2020-09-23 | Androscoggin | Maine | 23001 | 693 | 10 |
558268 | 558268 | 2020-09-22 | Androscoggin | Maine | 23001 | 687 | 10 |
555031 | 555031 | 2020-09-21 | Androscoggin | Maine | 23001 | 687 | 10 |
551792 | 551792 | 2020-09-20 | Androscoggin | Maine | 23001 | 682 | 10 |
548553 | 548553 | 2020-09-19 | Androscoggin | Maine | 23001 | 674 | 10 |
545315 | 545315 | 2020-09-18 | Androscoggin | Maine | 23001 | 668 | 10 |
542079 | 542079 | 2020-09-17 | Androscoggin | Maine | 23001 | 658 | 10 |
538843 | 538843 | 2020-09-16 | Androscoggin | Maine | 23001 | 656 | 10 |
535606 | 535606 | 2020-09-15 | Androscoggin | Maine | 23001 | 653 | 10 |
532371 | 532371 | 2020-09-14 | Androscoggin | Maine | 23001 | 652 | 10 |
529134 | 529134 | 2020-09-13 | Androscoggin | Maine | 23001 | 641 | 10 |
525898 | 525898 | 2020-09-12 | Androscoggin | Maine | 23001 | 634 | 10 |
522662 | 522662 | 2020-09-11 | Androscoggin | Maine | 23001 | 635 | 10 |
519425 | 519425 | 2020-09-10 | Androscoggin | Maine | 23001 | 631 | 10 |
516190 | 516190 | 2020-09-09 | Androscoggin | Maine | 23001 | 627 | 10 |
512957 | 512957 | 2020-09-08 | Androscoggin | Maine | 23001 | 625 | 10 |
509725 | 509725 | 2020-09-07 | Androscoggin | Maine | 23001 | 624 | 10 |
506492 | 506492 | 2020-09-06 | Androscoggin | Maine | 23001 | 623 | 10 |
503258 | 503258 | 2020-09-05 | Androscoggin | Maine | 23001 | 623 | 10 |
500025 | 500025 | 2020-09-04 | Androscoggin | Maine | 23001 | 620 | 10 |
496791 | 496791 | 2020-09-03 | Androscoggin | Maine | 23001 | 620 | 10 |
493558 | 493558 | 2020-09-02 | Androscoggin | Maine | 23001 | 616 | 10 |
490324 | 490324 | 2020-09-01 | Androscoggin | Maine | 23001 | 615 | 10 |
487091 | 487091 | 2020-08-31 | Androscoggin | Maine | 23001 | 613 | 10 |
483856 | 483856 | 2020-08-30 | Androscoggin | Maine | 23001 | 612 | 10 |
480622 | 480622 | 2020-08-29 | Androscoggin | Maine | 23001 | 610 | 10 |
477389 | 477389 | 2020-08-28 | Androscoggin | Maine | 23001 | 602 | 10 |
474156 | 474156 | 2020-08-27 | Androscoggin | Maine | 23001 | 600 | 10 |
470924 | 470924 | 2020-08-26 | Androscoggin | Maine | 23001 | 596 | 10 |
467695 | 467695 | 2020-08-25 | Androscoggin | Maine | 23001 | 594 | 10 |
464466 | 464466 | 2020-08-24 | Androscoggin | Maine | 23001 | 594 | 10 |
461235 | 461235 | 2020-08-23 | Androscoggin | Maine | 23001 | 591 | 10 |
458008 | 458008 | 2020-08-22 | Androscoggin | Maine | 23001 | 590 | 10 |
454780 | 454780 | 2020-08-21 | Androscoggin | Maine | 23001 | 586 | 10 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);