ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Sumner" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955499 | 955499 | 2021-01-22 | Sumner | Tennessee | 47165 | 18644 | 232 |
952254 | 952254 | 2021-01-21 | Sumner | Tennessee | 47165 | 18551 | 232 |
949009 | 949009 | 2021-01-20 | Sumner | Tennessee | 47165 | 18454 | 232 |
945763 | 945763 | 2021-01-19 | Sumner | Tennessee | 47165 | 18322 | 232 |
942516 | 942516 | 2021-01-18 | Sumner | Tennessee | 47165 | 18262 | 232 |
939271 | 939271 | 2021-01-17 | Sumner | Tennessee | 47165 | 18205 | 230 |
936026 | 936026 | 2021-01-16 | Sumner | Tennessee | 47165 | 18067 | 229 |
932781 | 932781 | 2021-01-15 | Sumner | Tennessee | 47165 | 17980 | 229 |
929536 | 929536 | 2021-01-14 | Sumner | Tennessee | 47165 | 17850 | 228 |
926291 | 926291 | 2021-01-13 | Sumner | Tennessee | 47165 | 17710 | 228 |
923045 | 923045 | 2021-01-12 | Sumner | Tennessee | 47165 | 17584 | 226 |
919800 | 919800 | 2021-01-11 | Sumner | Tennessee | 47165 | 17473 | 224 |
916555 | 916555 | 2021-01-10 | Sumner | Tennessee | 47165 | 17405 | 223 |
913310 | 913310 | 2021-01-09 | Sumner | Tennessee | 47165 | 17243 | 220 |
910065 | 910065 | 2021-01-08 | Sumner | Tennessee | 47165 | 17105 | 220 |
906820 | 906820 | 2021-01-07 | Sumner | Tennessee | 47165 | 16992 | 214 |
903574 | 903574 | 2021-01-06 | Sumner | Tennessee | 47165 | 16714 | 213 |
900329 | 900329 | 2021-01-05 | Sumner | Tennessee | 47165 | 16501 | 210 |
897084 | 897084 | 2021-01-04 | Sumner | Tennessee | 47165 | 16390 | 209 |
893838 | 893838 | 2021-01-03 | Sumner | Tennessee | 47165 | 16292 | 207 |
890592 | 890592 | 2021-01-02 | Sumner | Tennessee | 47165 | 16241 | 207 |
887345 | 887345 | 2021-01-01 | Sumner | Tennessee | 47165 | 15789 | 206 |
884100 | 884100 | 2020-12-31 | Sumner | Tennessee | 47165 | 15789 | 206 |
880855 | 880855 | 2020-12-30 | Sumner | Tennessee | 47165 | 15645 | 203 |
877610 | 877610 | 2020-12-29 | Sumner | Tennessee | 47165 | 15380 | 201 |
874365 | 874365 | 2020-12-28 | Sumner | Tennessee | 47165 | 15219 | 199 |
871120 | 871120 | 2020-12-27 | Sumner | Tennessee | 47165 | 15132 | 198 |
867875 | 867875 | 2020-12-26 | Sumner | Tennessee | 47165 | 15076 | 196 |
864630 | 864630 | 2020-12-25 | Sumner | Tennessee | 47165 | 14953 | 195 |
861385 | 861385 | 2020-12-24 | Sumner | Tennessee | 47165 | 14760 | 195 |
858140 | 858140 | 2020-12-23 | Sumner | Tennessee | 47165 | 14616 | 193 |
854895 | 854895 | 2020-12-22 | Sumner | Tennessee | 47165 | 14458 | 190 |
851650 | 851650 | 2020-12-21 | Sumner | Tennessee | 47165 | 14339 | 185 |
848405 | 848405 | 2020-12-20 | Sumner | Tennessee | 47165 | 14081 | 182 |
845160 | 845160 | 2020-12-19 | Sumner | Tennessee | 47165 | 13866 | 181 |
841914 | 841914 | 2020-12-18 | Sumner | Tennessee | 47165 | 13676 | 178 |
838669 | 838669 | 2020-12-17 | Sumner | Tennessee | 47165 | 13383 | 173 |
835423 | 835423 | 2020-12-16 | Sumner | Tennessee | 47165 | 13216 | 167 |
832177 | 832177 | 2020-12-15 | Sumner | Tennessee | 47165 | 12925 | 165 |
828930 | 828930 | 2020-12-14 | Sumner | Tennessee | 47165 | 12762 | 164 |
825684 | 825684 | 2020-12-13 | Sumner | Tennessee | 47165 | 12456 | 160 |
822437 | 822437 | 2020-12-12 | Sumner | Tennessee | 47165 | 12156 | 158 |
819191 | 819191 | 2020-12-11 | Sumner | Tennessee | 47165 | 11986 | 156 |
815945 | 815945 | 2020-12-10 | Sumner | Tennessee | 47165 | 11785 | 152 |
812699 | 812699 | 2020-12-09 | Sumner | Tennessee | 47165 | 11558 | 151 |
809455 | 809455 | 2020-12-08 | Sumner | Tennessee | 47165 | 11380 | 148 |
806210 | 806210 | 2020-12-07 | Sumner | Tennessee | 47165 | 11148 | 145 |
802965 | 802965 | 2020-12-06 | Sumner | Tennessee | 47165 | 10928 | 144 |
799720 | 799720 | 2020-12-05 | Sumner | Tennessee | 47165 | 10851 | 145 |
796475 | 796475 | 2020-12-04 | Sumner | Tennessee | 47165 | 10700 | 144 |
793230 | 793230 | 2020-12-03 | Sumner | Tennessee | 47165 | 10566 | 142 |
789985 | 789985 | 2020-12-02 | Sumner | Tennessee | 47165 | 10404 | 138 |
786740 | 786740 | 2020-12-01 | Sumner | Tennessee | 47165 | 10255 | 137 |
783496 | 783496 | 2020-11-30 | Sumner | Tennessee | 47165 | 10123 | 137 |
780251 | 780251 | 2020-11-29 | Sumner | Tennessee | 47165 | 9817 | 137 |
777005 | 777005 | 2020-11-28 | Sumner | Tennessee | 47165 | 9744 | 137 |
773760 | 773760 | 2020-11-27 | Sumner | Tennessee | 47165 | 9573 | 136 |
770515 | 770515 | 2020-11-26 | Sumner | Tennessee | 47165 | 9412 | 136 |
767269 | 767269 | 2020-11-25 | Sumner | Tennessee | 47165 | 9248 | 135 |
764024 | 764024 | 2020-11-24 | Sumner | Tennessee | 47165 | 9163 | 134 |
760779 | 760779 | 2020-11-23 | Sumner | Tennessee | 47165 | 9141 | 134 |
757534 | 757534 | 2020-11-22 | Sumner | Tennessee | 47165 | 9016 | 134 |
754287 | 754287 | 2020-11-21 | Sumner | Tennessee | 47165 | 8833 | 132 |
751041 | 751041 | 2020-11-20 | Sumner | Tennessee | 47165 | 8696 | 131 |
747795 | 747795 | 2020-11-19 | Sumner | Tennessee | 47165 | 8529 | 129 |
744549 | 744549 | 2020-11-18 | Sumner | Tennessee | 47165 | 8422 | 128 |
741302 | 741302 | 2020-11-17 | Sumner | Tennessee | 47165 | 8312 | 126 |
738056 | 738056 | 2020-11-16 | Sumner | Tennessee | 47165 | 8211 | 124 |
734812 | 734812 | 2020-11-15 | Sumner | Tennessee | 47165 | 7995 | 122 |
731566 | 731566 | 2020-11-14 | Sumner | Tennessee | 47165 | 7776 | 122 |
728322 | 728322 | 2020-11-13 | Sumner | Tennessee | 47165 | 7638 | 121 |
725078 | 725078 | 2020-11-12 | Sumner | Tennessee | 47165 | 7480 | 121 |
721835 | 721835 | 2020-11-11 | Sumner | Tennessee | 47165 | 7356 | 121 |
718592 | 718592 | 2020-11-10 | Sumner | Tennessee | 47165 | 7273 | 121 |
715349 | 715349 | 2020-11-09 | Sumner | Tennessee | 47165 | 7168 | 120 |
712105 | 712105 | 2020-11-08 | Sumner | Tennessee | 47165 | 7025 | 120 |
708861 | 708861 | 2020-11-07 | Sumner | Tennessee | 47165 | 6922 | 120 |
705618 | 705618 | 2020-11-06 | Sumner | Tennessee | 47165 | 6796 | 120 |
702375 | 702375 | 2020-11-05 | Sumner | Tennessee | 47165 | 6770 | 120 |
699131 | 699131 | 2020-11-04 | Sumner | Tennessee | 47165 | 6723 | 120 |
695888 | 695888 | 2020-11-03 | Sumner | Tennessee | 47165 | 6639 | 120 |
692646 | 692646 | 2020-11-02 | Sumner | Tennessee | 47165 | 6598 | 119 |
689402 | 689402 | 2020-11-01 | Sumner | Tennessee | 47165 | 6500 | 117 |
686157 | 686157 | 2020-10-31 | Sumner | Tennessee | 47165 | 6459 | 117 |
682914 | 682914 | 2020-10-30 | Sumner | Tennessee | 47165 | 6439 | 117 |
679671 | 679671 | 2020-10-29 | Sumner | Tennessee | 47165 | 6371 | 113 |
676428 | 676428 | 2020-10-28 | Sumner | Tennessee | 47165 | 6305 | 113 |
673185 | 673185 | 2020-10-27 | Sumner | Tennessee | 47165 | 6230 | 112 |
669943 | 669943 | 2020-10-26 | Sumner | Tennessee | 47165 | 6184 | 112 |
666699 | 666699 | 2020-10-25 | Sumner | Tennessee | 47165 | 6114 | 110 |
663454 | 663454 | 2020-10-24 | Sumner | Tennessee | 47165 | 5948 | 109 |
660210 | 660210 | 2020-10-23 | Sumner | Tennessee | 47165 | 5900 | 109 |
656966 | 656966 | 2020-10-22 | Sumner | Tennessee | 47165 | 5788 | 108 |
653721 | 653721 | 2020-10-21 | Sumner | Tennessee | 47165 | 5715 | 107 |
650476 | 650476 | 2020-10-20 | Sumner | Tennessee | 47165 | 5664 | 107 |
647232 | 647232 | 2020-10-19 | Sumner | Tennessee | 47165 | 5636 | 107 |
643986 | 643986 | 2020-10-18 | Sumner | Tennessee | 47165 | 5551 | 107 |
640738 | 640738 | 2020-10-17 | Sumner | Tennessee | 47165 | 5486 | 106 |
637492 | 637492 | 2020-10-16 | Sumner | Tennessee | 47165 | 5442 | 106 |
634246 | 634246 | 2020-10-15 | Sumner | Tennessee | 47165 | 5428 | 106 |
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);