ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 47163 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091814 | 1091814 | 2021-03-05 | Sullivan | Tennessee | 47163 | 14489 | 275 |
1088568 | 1088568 | 2021-03-04 | Sullivan | Tennessee | 47163 | 14431 | 274 |
1085323 | 1085323 | 2021-03-03 | Sullivan | Tennessee | 47163 | 14396 | 273 |
1082077 | 1082077 | 2021-03-02 | Sullivan | Tennessee | 47163 | 14346 | 274 |
1078831 | 1078831 | 2021-03-01 | Sullivan | Tennessee | 47163 | 14336 | 273 |
1075586 | 1075586 | 2021-02-28 | Sullivan | Tennessee | 47163 | 14318 | 273 |
1072340 | 1072340 | 2021-02-27 | Sullivan | Tennessee | 47163 | 14305 | 273 |
1069094 | 1069094 | 2021-02-26 | Sullivan | Tennessee | 47163 | 14265 | 273 |
1065849 | 1065849 | 2021-02-25 | Sullivan | Tennessee | 47163 | 14239 | 273 |
1062604 | 1062604 | 2021-02-24 | Sullivan | Tennessee | 47163 | 14169 | 273 |
1059359 | 1059359 | 2021-02-23 | Sullivan | Tennessee | 47163 | 14142 | 273 |
1056113 | 1056113 | 2021-02-22 | Sullivan | Tennessee | 47163 | 14122 | 271 |
1052867 | 1052867 | 2021-02-21 | Sullivan | Tennessee | 47163 | 14107 | 270 |
1049620 | 1049620 | 2021-02-20 | Sullivan | Tennessee | 47163 | 14088 | 271 |
1046373 | 1046373 | 2021-02-19 | Sullivan | Tennessee | 47163 | 14041 | 271 |
1043128 | 1043128 | 2021-02-18 | Sullivan | Tennessee | 47163 | 13983 | 268 |
1039883 | 1039883 | 2021-02-17 | Sullivan | Tennessee | 47163 | 13954 | 264 |
1036638 | 1036638 | 2021-02-16 | Sullivan | Tennessee | 47163 | 13914 | 264 |
1033393 | 1033393 | 2021-02-15 | Sullivan | Tennessee | 47163 | 13865 | 263 |
1030147 | 1030147 | 2021-02-14 | Sullivan | Tennessee | 47163 | 13823 | 263 |
1026900 | 1026900 | 2021-02-13 | Sullivan | Tennessee | 47163 | 13768 | 263 |
1023655 | 1023655 | 2021-02-12 | Sullivan | Tennessee | 47163 | 13703 | 263 |
1020410 | 1020410 | 2021-02-11 | Sullivan | Tennessee | 47163 | 13673 | 262 |
1017165 | 1017165 | 2021-02-10 | Sullivan | Tennessee | 47163 | 13587 | 260 |
1013920 | 1013920 | 2021-02-09 | Sullivan | Tennessee | 47163 | 13577 | 257 |
1010675 | 1010675 | 2021-02-08 | Sullivan | Tennessee | 47163 | 13562 | 256 |
1007429 | 1007429 | 2021-02-07 | Sullivan | Tennessee | 47163 | 13550 | 254 |
1004183 | 1004183 | 2021-02-06 | Sullivan | Tennessee | 47163 | 13512 | 254 |
1000937 | 1000937 | 2021-02-05 | Sullivan | Tennessee | 47163 | 13482 | 251 |
997691 | 997691 | 2021-02-04 | Sullivan | Tennessee | 47163 | 13445 | 249 |
994445 | 994445 | 2021-02-03 | Sullivan | Tennessee | 47163 | 13390 | 247 |
991199 | 991199 | 2021-02-02 | Sullivan | Tennessee | 47163 | 13363 | 244 |
987953 | 987953 | 2021-02-01 | Sullivan | Tennessee | 47163 | 13299 | 243 |
984706 | 984706 | 2021-01-31 | Sullivan | Tennessee | 47163 | 13281 | 237 |
981459 | 981459 | 2021-01-30 | Sullivan | Tennessee | 47163 | 13228 | 236 |
978213 | 978213 | 2021-01-29 | Sullivan | Tennessee | 47163 | 13203 | 231 |
974968 | 974968 | 2021-01-28 | Sullivan | Tennessee | 47163 | 13109 | 230 |
971723 | 971723 | 2021-01-27 | Sullivan | Tennessee | 47163 | 13087 | 229 |
968478 | 968478 | 2021-01-26 | Sullivan | Tennessee | 47163 | 13036 | 229 |
965234 | 965234 | 2021-01-25 | Sullivan | Tennessee | 47163 | 13002 | 221 |
961989 | 961989 | 2021-01-24 | Sullivan | Tennessee | 47163 | 12961 | 220 |
958744 | 958744 | 2021-01-23 | Sullivan | Tennessee | 47163 | 12932 | 220 |
955498 | 955498 | 2021-01-22 | Sullivan | Tennessee | 47163 | 12893 | 218 |
952253 | 952253 | 2021-01-21 | Sullivan | Tennessee | 47163 | 12811 | 216 |
949008 | 949008 | 2021-01-20 | Sullivan | Tennessee | 47163 | 12736 | 212 |
945762 | 945762 | 2021-01-19 | Sullivan | Tennessee | 47163 | 12634 | 211 |
942515 | 942515 | 2021-01-18 | Sullivan | Tennessee | 47163 | 12606 | 211 |
939270 | 939270 | 2021-01-17 | Sullivan | Tennessee | 47163 | 12577 | 211 |
936025 | 936025 | 2021-01-16 | Sullivan | Tennessee | 47163 | 12473 | 210 |
932780 | 932780 | 2021-01-15 | Sullivan | Tennessee | 47163 | 12405 | 209 |
929535 | 929535 | 2021-01-14 | Sullivan | Tennessee | 47163 | 12293 | 207 |
926290 | 926290 | 2021-01-13 | Sullivan | Tennessee | 47163 | 12209 | 206 |
923044 | 923044 | 2021-01-12 | Sullivan | Tennessee | 47163 | 12133 | 203 |
919799 | 919799 | 2021-01-11 | Sullivan | Tennessee | 47163 | 12071 | 202 |
916554 | 916554 | 2021-01-10 | Sullivan | Tennessee | 47163 | 12010 | 200 |
913309 | 913309 | 2021-01-09 | Sullivan | Tennessee | 47163 | 11937 | 198 |
910064 | 910064 | 2021-01-08 | Sullivan | Tennessee | 47163 | 11801 | 198 |
906819 | 906819 | 2021-01-07 | Sullivan | Tennessee | 47163 | 11662 | 196 |
903573 | 903573 | 2021-01-06 | Sullivan | Tennessee | 47163 | 11528 | 196 |
900328 | 900328 | 2021-01-05 | Sullivan | Tennessee | 47163 | 11377 | 192 |
897083 | 897083 | 2021-01-04 | Sullivan | Tennessee | 47163 | 11276 | 188 |
893837 | 893837 | 2021-01-03 | Sullivan | Tennessee | 47163 | 11203 | 181 |
890591 | 890591 | 2021-01-02 | Sullivan | Tennessee | 47163 | 11106 | 181 |
887344 | 887344 | 2021-01-01 | Sullivan | Tennessee | 47163 | 10862 | 178 |
884099 | 884099 | 2020-12-31 | Sullivan | Tennessee | 47163 | 10862 | 178 |
880854 | 880854 | 2020-12-30 | Sullivan | Tennessee | 47163 | 10739 | 177 |
877609 | 877609 | 2020-12-29 | Sullivan | Tennessee | 47163 | 10545 | 175 |
874364 | 874364 | 2020-12-28 | Sullivan | Tennessee | 47163 | 10443 | 172 |
871119 | 871119 | 2020-12-27 | Sullivan | Tennessee | 47163 | 10424 | 170 |
867874 | 867874 | 2020-12-26 | Sullivan | Tennessee | 47163 | 10374 | 167 |
864629 | 864629 | 2020-12-25 | Sullivan | Tennessee | 47163 | 10233 | 167 |
861384 | 861384 | 2020-12-24 | Sullivan | Tennessee | 47163 | 10151 | 167 |
858139 | 858139 | 2020-12-23 | Sullivan | Tennessee | 47163 | 10040 | 166 |
854894 | 854894 | 2020-12-22 | Sullivan | Tennessee | 47163 | 9877 | 164 |
851649 | 851649 | 2020-12-21 | Sullivan | Tennessee | 47163 | 9842 | 161 |
848404 | 848404 | 2020-12-20 | Sullivan | Tennessee | 47163 | 9680 | 161 |
845159 | 845159 | 2020-12-19 | Sullivan | Tennessee | 47163 | 9435 | 161 |
841913 | 841913 | 2020-12-18 | Sullivan | Tennessee | 47163 | 9315 | 158 |
838668 | 838668 | 2020-12-17 | Sullivan | Tennessee | 47163 | 9080 | 154 |
835422 | 835422 | 2020-12-16 | Sullivan | Tennessee | 47163 | 8949 | 150 |
832176 | 832176 | 2020-12-15 | Sullivan | Tennessee | 47163 | 8745 | 149 |
828929 | 828929 | 2020-12-14 | Sullivan | Tennessee | 47163 | 8603 | 141 |
825683 | 825683 | 2020-12-13 | Sullivan | Tennessee | 47163 | 8358 | 135 |
822436 | 822436 | 2020-12-12 | Sullivan | Tennessee | 47163 | 8119 | 131 |
819190 | 819190 | 2020-12-11 | Sullivan | Tennessee | 47163 | 7997 | 128 |
815944 | 815944 | 2020-12-10 | Sullivan | Tennessee | 47163 | 7888 | 126 |
812698 | 812698 | 2020-12-09 | Sullivan | Tennessee | 47163 | 7730 | 125 |
809454 | 809454 | 2020-12-08 | Sullivan | Tennessee | 47163 | 7587 | 125 |
806209 | 806209 | 2020-12-07 | Sullivan | Tennessee | 47163 | 7459 | 120 |
802964 | 802964 | 2020-12-06 | Sullivan | Tennessee | 47163 | 7279 | 117 |
799719 | 799719 | 2020-12-05 | Sullivan | Tennessee | 47163 | 7249 | 116 |
796474 | 796474 | 2020-12-04 | Sullivan | Tennessee | 47163 | 7128 | 114 |
793229 | 793229 | 2020-12-03 | Sullivan | Tennessee | 47163 | 6979 | 111 |
789984 | 789984 | 2020-12-02 | Sullivan | Tennessee | 47163 | 6913 | 105 |
786739 | 786739 | 2020-12-01 | Sullivan | Tennessee | 47163 | 6787 | 102 |
783495 | 783495 | 2020-11-30 | Sullivan | Tennessee | 47163 | 6641 | 101 |
780250 | 780250 | 2020-11-29 | Sullivan | Tennessee | 47163 | 6485 | 97 |
777004 | 777004 | 2020-11-28 | Sullivan | Tennessee | 47163 | 6439 | 96 |
773759 | 773759 | 2020-11-27 | Sullivan | Tennessee | 47163 | 6300 | 96 |
770514 | 770514 | 2020-11-26 | Sullivan | Tennessee | 47163 | 6249 | 96 |
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);