ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 47149 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955491 | 955491 | 2021-01-22 | Rutherford | Tennessee | 47149 | 33860 | 294 |
952246 | 952246 | 2021-01-21 | Rutherford | Tennessee | 47149 | 33687 | 294 |
949001 | 949001 | 2021-01-20 | Rutherford | Tennessee | 47149 | 33516 | 288 |
945755 | 945755 | 2021-01-19 | Rutherford | Tennessee | 47149 | 33298 | 287 |
942508 | 942508 | 2021-01-18 | Rutherford | Tennessee | 47149 | 33228 | 285 |
939263 | 939263 | 2021-01-17 | Rutherford | Tennessee | 47149 | 33114 | 283 |
936018 | 936018 | 2021-01-16 | Rutherford | Tennessee | 47149 | 32907 | 282 |
932773 | 932773 | 2021-01-15 | Rutherford | Tennessee | 47149 | 32696 | 282 |
929528 | 929528 | 2021-01-14 | Rutherford | Tennessee | 47149 | 32471 | 281 |
926283 | 926283 | 2021-01-13 | Rutherford | Tennessee | 47149 | 32214 | 279 |
923037 | 923037 | 2021-01-12 | Rutherford | Tennessee | 47149 | 31972 | 271 |
919792 | 919792 | 2021-01-11 | Rutherford | Tennessee | 47149 | 31744 | 268 |
916547 | 916547 | 2021-01-10 | Rutherford | Tennessee | 47149 | 31563 | 267 |
913302 | 913302 | 2021-01-09 | Rutherford | Tennessee | 47149 | 31214 | 266 |
910057 | 910057 | 2021-01-08 | Rutherford | Tennessee | 47149 | 30893 | 263 |
906812 | 906812 | 2021-01-07 | Rutherford | Tennessee | 47149 | 30617 | 259 |
903566 | 903566 | 2021-01-06 | Rutherford | Tennessee | 47149 | 30200 | 254 |
900321 | 900321 | 2021-01-05 | Rutherford | Tennessee | 47149 | 29823 | 252 |
897076 | 897076 | 2021-01-04 | Rutherford | Tennessee | 47149 | 29609 | 248 |
893830 | 893830 | 2021-01-03 | Rutherford | Tennessee | 47149 | 29378 | 245 |
890584 | 890584 | 2021-01-02 | Rutherford | Tennessee | 47149 | 29250 | 244 |
887337 | 887337 | 2021-01-01 | Rutherford | Tennessee | 47149 | 28618 | 242 |
884092 | 884092 | 2020-12-31 | Rutherford | Tennessee | 47149 | 28618 | 242 |
880847 | 880847 | 2020-12-30 | Rutherford | Tennessee | 47149 | 28272 | 241 |
877602 | 877602 | 2020-12-29 | Rutherford | Tennessee | 47149 | 27864 | 238 |
874357 | 874357 | 2020-12-28 | Rutherford | Tennessee | 47149 | 27679 | 235 |
871112 | 871112 | 2020-12-27 | Rutherford | Tennessee | 47149 | 27519 | 234 |
867867 | 867867 | 2020-12-26 | Rutherford | Tennessee | 47149 | 27407 | 232 |
864622 | 864622 | 2020-12-25 | Rutherford | Tennessee | 47149 | 27173 | 228 |
861377 | 861377 | 2020-12-24 | Rutherford | Tennessee | 47149 | 26681 | 228 |
858132 | 858132 | 2020-12-23 | Rutherford | Tennessee | 47149 | 26488 | 227 |
854887 | 854887 | 2020-12-22 | Rutherford | Tennessee | 47149 | 26161 | 222 |
851642 | 851642 | 2020-12-21 | Rutherford | Tennessee | 47149 | 25953 | 215 |
848397 | 848397 | 2020-12-20 | Rutherford | Tennessee | 47149 | 25529 | 214 |
845152 | 845152 | 2020-12-19 | Rutherford | Tennessee | 47149 | 25081 | 213 |
841906 | 841906 | 2020-12-18 | Rutherford | Tennessee | 47149 | 24821 | 212 |
838661 | 838661 | 2020-12-17 | Rutherford | Tennessee | 47149 | 24221 | 208 |
835415 | 835415 | 2020-12-16 | Rutherford | Tennessee | 47149 | 23828 | 201 |
832169 | 832169 | 2020-12-15 | Rutherford | Tennessee | 47149 | 23272 | 198 |
828922 | 828922 | 2020-12-14 | Rutherford | Tennessee | 47149 | 22904 | 195 |
825676 | 825676 | 2020-12-13 | Rutherford | Tennessee | 47149 | 22336 | 193 |
822429 | 822429 | 2020-12-12 | Rutherford | Tennessee | 47149 | 21809 | 191 |
819183 | 819183 | 2020-12-11 | Rutherford | Tennessee | 47149 | 21504 | 191 |
815937 | 815937 | 2020-12-10 | Rutherford | Tennessee | 47149 | 21014 | 189 |
812691 | 812691 | 2020-12-09 | Rutherford | Tennessee | 47149 | 20721 | 185 |
809447 | 809447 | 2020-12-08 | Rutherford | Tennessee | 47149 | 20346 | 185 |
806202 | 806202 | 2020-12-07 | Rutherford | Tennessee | 47149 | 20061 | 177 |
802957 | 802957 | 2020-12-06 | Rutherford | Tennessee | 47149 | 19594 | 175 |
799712 | 799712 | 2020-12-05 | Rutherford | Tennessee | 47149 | 19456 | 174 |
796467 | 796467 | 2020-12-04 | Rutherford | Tennessee | 47149 | 19202 | 173 |
793222 | 793222 | 2020-12-03 | Rutherford | Tennessee | 47149 | 18968 | 169 |
789977 | 789977 | 2020-12-02 | Rutherford | Tennessee | 47149 | 18788 | 164 |
786732 | 786732 | 2020-12-01 | Rutherford | Tennessee | 47149 | 18613 | 164 |
783488 | 783488 | 2020-11-30 | Rutherford | Tennessee | 47149 | 18248 | 163 |
780243 | 780243 | 2020-11-29 | Rutherford | Tennessee | 47149 | 17930 | 161 |
776997 | 776997 | 2020-11-28 | Rutherford | Tennessee | 47149 | 17749 | 161 |
773752 | 773752 | 2020-11-27 | Rutherford | Tennessee | 47149 | 17439 | 160 |
770507 | 770507 | 2020-11-26 | Rutherford | Tennessee | 47149 | 17212 | 159 |
767261 | 767261 | 2020-11-25 | Rutherford | Tennessee | 47149 | 17025 | 154 |
764016 | 764016 | 2020-11-24 | Rutherford | Tennessee | 47149 | 16918 | 153 |
760771 | 760771 | 2020-11-23 | Rutherford | Tennessee | 47149 | 16907 | 150 |
757526 | 757526 | 2020-11-22 | Rutherford | Tennessee | 47149 | 16668 | 150 |
754279 | 754279 | 2020-11-21 | Rutherford | Tennessee | 47149 | 16458 | 149 |
751033 | 751033 | 2020-11-20 | Rutherford | Tennessee | 47149 | 16264 | 148 |
747787 | 747787 | 2020-11-19 | Rutherford | Tennessee | 47149 | 16052 | 143 |
744541 | 744541 | 2020-11-18 | Rutherford | Tennessee | 47149 | 15857 | 139 |
741294 | 741294 | 2020-11-17 | Rutherford | Tennessee | 47149 | 15635 | 134 |
738048 | 738048 | 2020-11-16 | Rutherford | Tennessee | 47149 | 15530 | 131 |
734804 | 734804 | 2020-11-15 | Rutherford | Tennessee | 47149 | 15146 | 131 |
731558 | 731558 | 2020-11-14 | Rutherford | Tennessee | 47149 | 14883 | 129 |
728314 | 728314 | 2020-11-13 | Rutherford | Tennessee | 47149 | 14659 | 129 |
725070 | 725070 | 2020-11-12 | Rutherford | Tennessee | 47149 | 14425 | 129 |
721827 | 721827 | 2020-11-11 | Rutherford | Tennessee | 47149 | 14255 | 128 |
718584 | 718584 | 2020-11-10 | Rutherford | Tennessee | 47149 | 14090 | 127 |
715341 | 715341 | 2020-11-09 | Rutherford | Tennessee | 47149 | 13914 | 127 |
712097 | 712097 | 2020-11-08 | Rutherford | Tennessee | 47149 | 13640 | 126 |
708853 | 708853 | 2020-11-07 | Rutherford | Tennessee | 47149 | 13419 | 126 |
705610 | 705610 | 2020-11-06 | Rutherford | Tennessee | 47149 | 13181 | 123 |
702367 | 702367 | 2020-11-05 | Rutherford | Tennessee | 47149 | 13111 | 122 |
699123 | 699123 | 2020-11-04 | Rutherford | Tennessee | 47149 | 13014 | 121 |
695880 | 695880 | 2020-11-03 | Rutherford | Tennessee | 47149 | 12822 | 117 |
692638 | 692638 | 2020-11-02 | Rutherford | Tennessee | 47149 | 12730 | 117 |
689394 | 689394 | 2020-11-01 | Rutherford | Tennessee | 47149 | 12607 | 116 |
686149 | 686149 | 2020-10-31 | Rutherford | Tennessee | 47149 | 12528 | 116 |
682906 | 682906 | 2020-10-30 | Rutherford | Tennessee | 47149 | 12485 | 116 |
679663 | 679663 | 2020-10-29 | Rutherford | Tennessee | 47149 | 12406 | 115 |
676420 | 676420 | 2020-10-28 | Rutherford | Tennessee | 47149 | 12271 | 115 |
673177 | 673177 | 2020-10-27 | Rutherford | Tennessee | 47149 | 12143 | 115 |
669935 | 669935 | 2020-10-26 | Rutherford | Tennessee | 47149 | 12017 | 115 |
666691 | 666691 | 2020-10-25 | Rutherford | Tennessee | 47149 | 11893 | 114 |
663446 | 663446 | 2020-10-24 | Rutherford | Tennessee | 47149 | 11611 | 112 |
660202 | 660202 | 2020-10-23 | Rutherford | Tennessee | 47149 | 11502 | 113 |
656958 | 656958 | 2020-10-22 | Rutherford | Tennessee | 47149 | 11274 | 110 |
653713 | 653713 | 2020-10-21 | Rutherford | Tennessee | 47149 | 11165 | 107 |
650468 | 650468 | 2020-10-20 | Rutherford | Tennessee | 47149 | 11090 | 106 |
647224 | 647224 | 2020-10-19 | Rutherford | Tennessee | 47149 | 11031 | 106 |
643978 | 643978 | 2020-10-18 | Rutherford | Tennessee | 47149 | 10866 | 106 |
640730 | 640730 | 2020-10-17 | Rutherford | Tennessee | 47149 | 10770 | 106 |
637484 | 637484 | 2020-10-16 | Rutherford | Tennessee | 47149 | 10654 | 105 |
634238 | 634238 | 2020-10-15 | Rutherford | Tennessee | 47149 | 10637 | 105 |
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);