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 |
---|---|---|---|---|---|---|---|
1244435 | 1244435 | 2021-04-21 | Sullivan | Tennessee | 47163 | 16266 | 287 |
1241188 | 1241188 | 2021-04-20 | Sullivan | Tennessee | 47163 | 16211 | 287 |
1237941 | 1237941 | 2021-04-19 | Sullivan | Tennessee | 47163 | 16184 | 287 |
1234694 | 1234694 | 2021-04-18 | Sullivan | Tennessee | 47163 | 16096 | 287 |
1231446 | 1231446 | 2021-04-17 | Sullivan | Tennessee | 47163 | 16096 | 287 |
1228198 | 1228198 | 2021-04-16 | Sullivan | Tennessee | 47163 | 16096 | 287 |
1224950 | 1224950 | 2021-04-15 | Sullivan | Tennessee | 47163 | 16062 | 287 |
1221703 | 1221703 | 2021-04-14 | Sullivan | Tennessee | 47163 | 15971 | 287 |
1218455 | 1218455 | 2021-04-13 | Sullivan | Tennessee | 47163 | 15926 | 285 |
1215207 | 1215207 | 2021-04-12 | Sullivan | Tennessee | 47163 | 15880 | 284 |
1211960 | 1211960 | 2021-04-11 | Sullivan | Tennessee | 47163 | 15781 | 283 |
1208711 | 1208711 | 2021-04-10 | Sullivan | Tennessee | 47163 | 15781 | 283 |
1205463 | 1205463 | 2021-04-09 | Sullivan | Tennessee | 47163 | 15781 | 283 |
1202215 | 1202215 | 2021-04-08 | Sullivan | Tennessee | 47163 | 15730 | 283 |
1198966 | 1198966 | 2021-04-07 | Sullivan | Tennessee | 47163 | 15676 | 283 |
1195717 | 1195717 | 2021-04-06 | Sullivan | Tennessee | 47163 | 15643 | 283 |
1192469 | 1192469 | 2021-04-05 | Sullivan | Tennessee | 47163 | 15582 | 281 |
1189220 | 1189220 | 2021-04-04 | Sullivan | Tennessee | 47163 | 15468 | 281 |
1185973 | 1185973 | 2021-04-03 | Sullivan | Tennessee | 47163 | 15468 | 281 |
1182726 | 1182726 | 2021-04-02 | Sullivan | Tennessee | 47163 | 15468 | 281 |
1179479 | 1179479 | 2021-04-01 | Sullivan | Tennessee | 47163 | 15468 | 281 |
1176232 | 1176232 | 2021-03-31 | Sullivan | Tennessee | 47163 | 15417 | 281 |
1172985 | 1172985 | 2021-03-30 | Sullivan | Tennessee | 47163 | 15380 | 281 |
1169738 | 1169738 | 2021-03-29 | Sullivan | Tennessee | 47163 | 15333 | 281 |
1166490 | 1166490 | 2021-03-28 | Sullivan | Tennessee | 47163 | 15257 | 280 |
1163242 | 1163242 | 2021-03-27 | Sullivan | Tennessee | 47163 | 15257 | 280 |
1159993 | 1159993 | 2021-03-26 | Sullivan | Tennessee | 47163 | 15257 | 280 |
1156746 | 1156746 | 2021-03-25 | Sullivan | Tennessee | 47163 | 15191 | 280 |
1153499 | 1153499 | 2021-03-24 | Sullivan | Tennessee | 47163 | 15151 | 280 |
1150252 | 1150252 | 2021-03-23 | Sullivan | Tennessee | 47163 | 15129 | 280 |
1147005 | 1147005 | 2021-03-22 | Sullivan | Tennessee | 47163 | 15060 | 279 |
1143758 | 1143758 | 2021-03-21 | Sullivan | Tennessee | 47163 | 14983 | 279 |
1140511 | 1140511 | 2021-03-20 | Sullivan | Tennessee | 47163 | 14983 | 279 |
1137265 | 1137265 | 2021-03-19 | Sullivan | Tennessee | 47163 | 14983 | 279 |
1134019 | 1134019 | 2021-03-18 | Sullivan | Tennessee | 47163 | 14935 | 279 |
1130771 | 1130771 | 2021-03-17 | Sullivan | Tennessee | 47163 | 14902 | 279 |
1127524 | 1127524 | 2021-03-16 | Sullivan | Tennessee | 47163 | 14864 | 278 |
1124278 | 1124278 | 2021-03-15 | Sullivan | Tennessee | 47163 | 14832 | 278 |
1121032 | 1121032 | 2021-03-14 | Sullivan | Tennessee | 47163 | 14762 | 276 |
1117785 | 1117785 | 2021-03-13 | Sullivan | Tennessee | 47163 | 14762 | 276 |
1114538 | 1114538 | 2021-03-12 | Sullivan | Tennessee | 47163 | 14762 | 276 |
1111292 | 1111292 | 2021-03-11 | Sullivan | Tennessee | 47163 | 14672 | 276 |
1108046 | 1108046 | 2021-03-10 | Sullivan | Tennessee | 47163 | 14615 | 276 |
1104800 | 1104800 | 2021-03-09 | Sullivan | Tennessee | 47163 | 14559 | 275 |
1101554 | 1101554 | 2021-03-08 | Sullivan | Tennessee | 47163 | 14532 | 275 |
1098308 | 1098308 | 2021-03-07 | Sullivan | Tennessee | 47163 | 14527 | 275 |
1095060 | 1095060 | 2021-03-06 | Sullivan | Tennessee | 47163 | 14499 | 275 |
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 |
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);