ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 47165 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091815 | 1091815 | 2021-03-05 | Sumner | Tennessee | 47165 | 21498 | 320 |
1088569 | 1088569 | 2021-03-04 | Sumner | Tennessee | 47165 | 21448 | 318 |
1085324 | 1085324 | 2021-03-03 | Sumner | Tennessee | 47165 | 21415 | 315 |
1082078 | 1082078 | 2021-03-02 | Sumner | Tennessee | 47165 | 21383 | 315 |
1078832 | 1078832 | 2021-03-01 | Sumner | Tennessee | 47165 | 21354 | 315 |
1075587 | 1075587 | 2021-02-28 | Sumner | Tennessee | 47165 | 21329 | 315 |
1072341 | 1072341 | 2021-02-27 | Sumner | Tennessee | 47165 | 21290 | 315 |
1069095 | 1069095 | 2021-02-26 | Sumner | Tennessee | 47165 | 21260 | 315 |
1065850 | 1065850 | 2021-02-25 | Sumner | Tennessee | 47165 | 21216 | 315 |
1062605 | 1062605 | 2021-02-24 | Sumner | Tennessee | 47165 | 21166 | 312 |
1059360 | 1059360 | 2021-02-23 | Sumner | Tennessee | 47165 | 21120 | 312 |
1056114 | 1056114 | 2021-02-22 | Sumner | Tennessee | 47165 | 21081 | 312 |
1052868 | 1052868 | 2021-02-21 | Sumner | Tennessee | 47165 | 21064 | 312 |
1049621 | 1049621 | 2021-02-20 | Sumner | Tennessee | 47165 | 21030 | 311 |
1046374 | 1046374 | 2021-02-19 | Sumner | Tennessee | 47165 | 20994 | 308 |
1043129 | 1043129 | 2021-02-18 | Sumner | Tennessee | 47165 | 20964 | 308 |
1039884 | 1039884 | 2021-02-17 | Sumner | Tennessee | 47165 | 20939 | 305 |
1036639 | 1036639 | 2021-02-16 | Sumner | Tennessee | 47165 | 20912 | 303 |
1033394 | 1033394 | 2021-02-15 | Sumner | Tennessee | 47165 | 20884 | 303 |
1030148 | 1030148 | 2021-02-14 | Sumner | Tennessee | 47165 | 20843 | 303 |
1026901 | 1026901 | 2021-02-13 | Sumner | Tennessee | 47165 | 20789 | 303 |
1023656 | 1023656 | 2021-02-12 | Sumner | Tennessee | 47165 | 20727 | 303 |
1020411 | 1020411 | 2021-02-11 | Sumner | Tennessee | 47165 | 20234 | 298 |
1017166 | 1017166 | 2021-02-10 | Sumner | Tennessee | 47165 | 19975 | 293 |
1013921 | 1013921 | 2021-02-09 | Sumner | Tennessee | 47165 | 19892 | 289 |
1010676 | 1010676 | 2021-02-08 | Sumner | Tennessee | 47165 | 19852 | 288 |
1007430 | 1007430 | 2021-02-07 | Sumner | Tennessee | 47165 | 19803 | 285 |
1004184 | 1004184 | 2021-02-06 | Sumner | Tennessee | 47165 | 19736 | 285 |
1000938 | 1000938 | 2021-02-05 | Sumner | Tennessee | 47165 | 19641 | 283 |
997692 | 997692 | 2021-02-04 | Sumner | Tennessee | 47165 | 19575 | 274 |
994446 | 994446 | 2021-02-03 | Sumner | Tennessee | 47165 | 19478 | 265 |
991200 | 991200 | 2021-02-02 | Sumner | Tennessee | 47165 | 19414 | 265 |
987954 | 987954 | 2021-02-01 | Sumner | Tennessee | 47165 | 19339 | 261 |
984707 | 984707 | 2021-01-31 | Sumner | Tennessee | 47165 | 19283 | 258 |
981460 | 981460 | 2021-01-30 | Sumner | Tennessee | 47165 | 19210 | 256 |
978214 | 978214 | 2021-01-29 | Sumner | Tennessee | 47165 | 19144 | 251 |
974969 | 974969 | 2021-01-28 | Sumner | Tennessee | 47165 | 19035 | 250 |
971724 | 971724 | 2021-01-27 | Sumner | Tennessee | 47165 | 18985 | 248 |
968479 | 968479 | 2021-01-26 | Sumner | Tennessee | 47165 | 18891 | 245 |
965235 | 965235 | 2021-01-25 | Sumner | Tennessee | 47165 | 18862 | 237 |
961990 | 961990 | 2021-01-24 | Sumner | Tennessee | 47165 | 18819 | 232 |
958745 | 958745 | 2021-01-23 | Sumner | Tennessee | 47165 | 18744 | 232 |
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 |
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);