ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Shelby" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955495 | 955495 | 2021-01-22 | Shelby | Tennessee | 47157 | 79925 | 1182 |
952250 | 952250 | 2021-01-21 | Shelby | Tennessee | 47157 | 79388 | 1169 |
949005 | 949005 | 2021-01-20 | Shelby | Tennessee | 47157 | 79051 | 1154 |
945759 | 945759 | 2021-01-19 | Shelby | Tennessee | 47157 | 78619 | 1140 |
942512 | 942512 | 2021-01-18 | Shelby | Tennessee | 47157 | 78020 | 1140 |
939267 | 939267 | 2021-01-17 | Shelby | Tennessee | 47157 | 77566 | 1128 |
936022 | 936022 | 2021-01-16 | Shelby | Tennessee | 47157 | 77069 | 1115 |
932777 | 932777 | 2021-01-15 | Shelby | Tennessee | 47157 | 77069 | 1115 |
929532 | 929532 | 2021-01-14 | Shelby | Tennessee | 47157 | 76534 | 1102 |
926287 | 926287 | 2021-01-13 | Shelby | Tennessee | 47157 | 75495 | 1080 |
923041 | 923041 | 2021-01-12 | Shelby | Tennessee | 47157 | 75016 | 1055 |
919796 | 919796 | 2021-01-11 | Shelby | Tennessee | 47157 | 74508 | 1039 |
916551 | 916551 | 2021-01-10 | Shelby | Tennessee | 47157 | 73817 | 1029 |
913306 | 913306 | 2021-01-09 | Shelby | Tennessee | 47157 | 73817 | 1024 |
910061 | 910061 | 2021-01-08 | Shelby | Tennessee | 47157 | 72626 | 1009 |
906816 | 906816 | 2021-01-07 | Shelby | Tennessee | 47157 | 72626 | 1003 |
903570 | 903570 | 2021-01-06 | Shelby | Tennessee | 47157 | 71728 | 984 |
900325 | 900325 | 2021-01-05 | Shelby | Tennessee | 47157 | 70532 | 947 |
897080 | 897080 | 2021-01-04 | Shelby | Tennessee | 47157 | 70532 | 945 |
893834 | 893834 | 2021-01-03 | Shelby | Tennessee | 47157 | 70142 | 925 |
890588 | 890588 | 2021-01-02 | Shelby | Tennessee | 47157 | 69798 | 914 |
887341 | 887341 | 2021-01-01 | Shelby | Tennessee | 47157 | 67800 | 903 |
884096 | 884096 | 2020-12-31 | Shelby | Tennessee | 47157 | 67198 | 903 |
880851 | 880851 | 2020-12-30 | Shelby | Tennessee | 47157 | 66437 | 889 |
877606 | 877606 | 2020-12-29 | Shelby | Tennessee | 47157 | 66437 | 877 |
874361 | 874361 | 2020-12-28 | Shelby | Tennessee | 47157 | 66084 | 861 |
871116 | 871116 | 2020-12-27 | Shelby | Tennessee | 47157 | 65713 | 849 |
867871 | 867871 | 2020-12-26 | Shelby | Tennessee | 47157 | 64356 | 839 |
864626 | 864626 | 2020-12-25 | Shelby | Tennessee | 47157 | 64013 | 839 |
861381 | 861381 | 2020-12-24 | Shelby | Tennessee | 47157 | 63394 | 837 |
858136 | 858136 | 2020-12-23 | Shelby | Tennessee | 47157 | 62783 | 835 |
854891 | 854891 | 2020-12-22 | Shelby | Tennessee | 47157 | 62783 | 826 |
851646 | 851646 | 2020-12-21 | Shelby | Tennessee | 47157 | 61444 | 818 |
848401 | 848401 | 2020-12-20 | Shelby | Tennessee | 47157 | 61429 | 818 |
845156 | 845156 | 2020-12-19 | Shelby | Tennessee | 47157 | 60651 | 810 |
841910 | 841910 | 2020-12-18 | Shelby | Tennessee | 47157 | 59387 | 802 |
838665 | 838665 | 2020-12-17 | Shelby | Tennessee | 47157 | 58762 | 782 |
835419 | 835419 | 2020-12-16 | Shelby | Tennessee | 47157 | 58762 | 761 |
832173 | 832173 | 2020-12-15 | Shelby | Tennessee | 47157 | 57599 | 757 |
828926 | 828926 | 2020-12-14 | Shelby | Tennessee | 47157 | 56820 | 753 |
825680 | 825680 | 2020-12-13 | Shelby | Tennessee | 47157 | 55456 | 744 |
822433 | 822433 | 2020-12-12 | Shelby | Tennessee | 47157 | 54465 | 737 |
819187 | 819187 | 2020-12-11 | Shelby | Tennessee | 47157 | 54234 | 731 |
815941 | 815941 | 2020-12-10 | Shelby | Tennessee | 47157 | 53304 | 726 |
812695 | 812695 | 2020-12-09 | Shelby | Tennessee | 47157 | 53058 | 722 |
809451 | 809451 | 2020-12-08 | Shelby | Tennessee | 47157 | 52363 | 716 |
806206 | 806206 | 2020-12-07 | Shelby | Tennessee | 47157 | 51775 | 709 |
802961 | 802961 | 2020-12-06 | Shelby | Tennessee | 47157 | 51030 | 705 |
799716 | 799716 | 2020-12-05 | Shelby | Tennessee | 47157 | 50923 | 702 |
796471 | 796471 | 2020-12-04 | Shelby | Tennessee | 47157 | 50470 | 696 |
793226 | 793226 | 2020-12-03 | Shelby | Tennessee | 47157 | 49731 | 687 |
789981 | 789981 | 2020-12-02 | Shelby | Tennessee | 47157 | 49412 | 681 |
786736 | 786736 | 2020-12-01 | Shelby | Tennessee | 47157 | 49077 | 672 |
783492 | 783492 | 2020-11-30 | Shelby | Tennessee | 47157 | 48561 | 673 |
780247 | 780247 | 2020-11-29 | Shelby | Tennessee | 47157 | 47963 | 660 |
777001 | 777001 | 2020-11-28 | Shelby | Tennessee | 47157 | 47682 | 659 |
773756 | 773756 | 2020-11-27 | Shelby | Tennessee | 47157 | 47215 | 659 |
770511 | 770511 | 2020-11-26 | Shelby | Tennessee | 47157 | 46549 | 658 |
767265 | 767265 | 2020-11-25 | Shelby | Tennessee | 47157 | 46330 | 652 |
764020 | 764020 | 2020-11-24 | Shelby | Tennessee | 47157 | 46210 | 645 |
760775 | 760775 | 2020-11-23 | Shelby | Tennessee | 47157 | 45952 | 637 |
757530 | 757530 | 2020-11-22 | Shelby | Tennessee | 47157 | 45609 | 635 |
754283 | 754283 | 2020-11-21 | Shelby | Tennessee | 47157 | 45045 | 630 |
751037 | 751037 | 2020-11-20 | Shelby | Tennessee | 47157 | 44659 | 630 |
747791 | 747791 | 2020-11-19 | Shelby | Tennessee | 47157 | 44474 | 626 |
744545 | 744545 | 2020-11-18 | Shelby | Tennessee | 47157 | 44102 | 623 |
741298 | 741298 | 2020-11-17 | Shelby | Tennessee | 47157 | 43700 | 616 |
738052 | 738052 | 2020-11-16 | Shelby | Tennessee | 47157 | 43478 | 613 |
734808 | 734808 | 2020-11-15 | Shelby | Tennessee | 47157 | 42660 | 612 |
731562 | 731562 | 2020-11-14 | Shelby | Tennessee | 47157 | 42120 | 612 |
728318 | 728318 | 2020-11-13 | Shelby | Tennessee | 47157 | 41571 | 609 |
725074 | 725074 | 2020-11-12 | Shelby | Tennessee | 47157 | 41280 | 606 |
721831 | 721831 | 2020-11-11 | Shelby | Tennessee | 47157 | 41125 | 604 |
718588 | 718588 | 2020-11-10 | Shelby | Tennessee | 47157 | 40733 | 593 |
715345 | 715345 | 2020-11-09 | Shelby | Tennessee | 47157 | 40577 | 589 |
712101 | 712101 | 2020-11-08 | Shelby | Tennessee | 47157 | 39852 | 588 |
708857 | 708857 | 2020-11-07 | Shelby | Tennessee | 47157 | 39328 | 586 |
705614 | 705614 | 2020-11-06 | Shelby | Tennessee | 47157 | 39031 | 582 |
702371 | 702371 | 2020-11-05 | Shelby | Tennessee | 47157 | 38875 | 580 |
699127 | 699127 | 2020-11-04 | Shelby | Tennessee | 47157 | 38623 | 580 |
695884 | 695884 | 2020-11-03 | Shelby | Tennessee | 47157 | 38352 | 578 |
692642 | 692642 | 2020-11-02 | Shelby | Tennessee | 47157 | 38288 | 573 |
689398 | 689398 | 2020-11-01 | Shelby | Tennessee | 47157 | 37873 | 573 |
686153 | 686153 | 2020-10-31 | Shelby | Tennessee | 47157 | 37764 | 573 |
682910 | 682910 | 2020-10-30 | Shelby | Tennessee | 47157 | 37618 | 571 |
679667 | 679667 | 2020-10-29 | Shelby | Tennessee | 47157 | 37335 | 570 |
676424 | 676424 | 2020-10-28 | Shelby | Tennessee | 47157 | 37111 | 570 |
673181 | 673181 | 2020-10-27 | Shelby | Tennessee | 47157 | 36855 | 568 |
669939 | 669939 | 2020-10-26 | Shelby | Tennessee | 47157 | 36685 | 565 |
666695 | 666695 | 2020-10-25 | Shelby | Tennessee | 47157 | 36376 | 563 |
663450 | 663450 | 2020-10-24 | Shelby | Tennessee | 47157 | 35901 | 563 |
660206 | 660206 | 2020-10-23 | Shelby | Tennessee | 47157 | 35564 | 562 |
656962 | 656962 | 2020-10-22 | Shelby | Tennessee | 47157 | 35279 | 558 |
653717 | 653717 | 2020-10-21 | Shelby | Tennessee | 47157 | 35077 | 556 |
650472 | 650472 | 2020-10-20 | Shelby | Tennessee | 47157 | 34850 | 554 |
647228 | 647228 | 2020-10-19 | Shelby | Tennessee | 47157 | 34508 | 553 |
643982 | 643982 | 2020-10-18 | Shelby | Tennessee | 47157 | 34221 | 551 |
640734 | 640734 | 2020-10-17 | Shelby | Tennessee | 47157 | 34009 | 549 |
637488 | 637488 | 2020-10-16 | Shelby | Tennessee | 47157 | 33960 | 548 |
634242 | 634242 | 2020-10-15 | Shelby | Tennessee | 47157 | 33710 | 547 |
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);