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 |
---|---|---|---|---|---|---|---|
1491144 | 1491144 | 2021-07-06 | Sullivan | Tennessee | 47163 | 17367 | 310 |
1487897 | 1487897 | 2021-07-05 | Sullivan | Tennessee | 47163 | 17352 | 311 |
1484650 | 1484650 | 2021-07-04 | Sullivan | Tennessee | 47163 | 17352 | 311 |
1481404 | 1481404 | 2021-07-03 | Sullivan | Tennessee | 47163 | 17352 | 311 |
1478157 | 1478157 | 2021-07-02 | Sullivan | Tennessee | 47163 | 17352 | 311 |
1474911 | 1474911 | 2021-07-01 | Sullivan | Tennessee | 47163 | 17346 | 311 |
1471665 | 1471665 | 2021-06-30 | Sullivan | Tennessee | 47163 | 17338 | 311 |
1468420 | 1468420 | 2021-06-29 | Sullivan | Tennessee | 47163 | 17335 | 311 |
1465175 | 1465175 | 2021-06-28 | Sullivan | Tennessee | 47163 | 17327 | 310 |
1461930 | 1461930 | 2021-06-27 | Sullivan | Tennessee | 47163 | 17323 | 310 |
1458685 | 1458685 | 2021-06-26 | Sullivan | Tennessee | 47163 | 17323 | 310 |
1455440 | 1455440 | 2021-06-25 | Sullivan | Tennessee | 47163 | 17323 | 310 |
1452195 | 1452195 | 2021-06-24 | Sullivan | Tennessee | 47163 | 17320 | 309 |
1448949 | 1448949 | 2021-06-23 | Sullivan | Tennessee | 47163 | 17316 | 308 |
1445704 | 1445704 | 2021-06-22 | Sullivan | Tennessee | 47163 | 17311 | 308 |
1442459 | 1442459 | 2021-06-21 | Sullivan | Tennessee | 47163 | 17312 | 304 |
1439214 | 1439214 | 2021-06-20 | Sullivan | Tennessee | 47163 | 17305 | 304 |
1435967 | 1435967 | 2021-06-19 | Sullivan | Tennessee | 47163 | 17305 | 304 |
1432720 | 1432720 | 2021-06-18 | Sullivan | Tennessee | 47163 | 17305 | 304 |
1429474 | 1429474 | 2021-06-17 | Sullivan | Tennessee | 47163 | 17306 | 304 |
1426229 | 1426229 | 2021-06-16 | Sullivan | Tennessee | 47163 | 17299 | 304 |
1422982 | 1422982 | 2021-06-15 | Sullivan | Tennessee | 47163 | 17297 | 304 |
1419736 | 1419736 | 2021-06-14 | Sullivan | Tennessee | 47163 | 17280 | 304 |
1416491 | 1416491 | 2021-06-13 | Sullivan | Tennessee | 47163 | 17280 | 304 |
1413245 | 1413245 | 2021-06-12 | Sullivan | Tennessee | 47163 | 17280 | 304 |
1410000 | 1410000 | 2021-06-11 | Sullivan | Tennessee | 47163 | 17280 | 304 |
1406755 | 1406755 | 2021-06-10 | Sullivan | Tennessee | 47163 | 17244 | 304 |
1403509 | 1403509 | 2021-06-09 | Sullivan | Tennessee | 47163 | 17240 | 304 |
1400264 | 1400264 | 2021-06-08 | Sullivan | Tennessee | 47163 | 17226 | 305 |
1397019 | 1397019 | 2021-06-07 | Sullivan | Tennessee | 47163 | 17226 | 304 |
1393772 | 1393772 | 2021-06-06 | Sullivan | Tennessee | 47163 | 17213 | 304 |
1390527 | 1390527 | 2021-06-05 | Sullivan | Tennessee | 47163 | 17213 | 304 |
1387282 | 1387282 | 2021-06-04 | Sullivan | Tennessee | 47163 | 17213 | 304 |
1384037 | 1384037 | 2021-06-03 | Sullivan | Tennessee | 47163 | 17208 | 304 |
1380791 | 1380791 | 2021-06-02 | Sullivan | Tennessee | 47163 | 17196 | 304 |
1377546 | 1377546 | 2021-06-01 | Sullivan | Tennessee | 47163 | 17179 | 303 |
1374300 | 1374300 | 2021-05-31 | Sullivan | Tennessee | 47163 | 17164 | 303 |
1371055 | 1371055 | 2021-05-30 | Sullivan | Tennessee | 47163 | 17164 | 303 |
1367809 | 1367809 | 2021-05-29 | Sullivan | Tennessee | 47163 | 17164 | 303 |
1364563 | 1364563 | 2021-05-28 | Sullivan | Tennessee | 47163 | 17164 | 303 |
1361317 | 1361317 | 2021-05-27 | Sullivan | Tennessee | 47163 | 17156 | 303 |
1358071 | 1358071 | 2021-05-26 | Sullivan | Tennessee | 47163 | 17139 | 302 |
1354825 | 1354825 | 2021-05-25 | Sullivan | Tennessee | 47163 | 17127 | 302 |
1351579 | 1351579 | 2021-05-24 | Sullivan | Tennessee | 47163 | 17111 | 302 |
1348333 | 1348333 | 2021-05-23 | Sullivan | Tennessee | 47163 | 17084 | 302 |
1345085 | 1345085 | 2021-05-22 | Sullivan | Tennessee | 47163 | 17084 | 302 |
1341837 | 1341837 | 2021-05-21 | Sullivan | Tennessee | 47163 | 17084 | 302 |
1338589 | 1338589 | 2021-05-20 | Sullivan | Tennessee | 47163 | 17066 | 302 |
1335342 | 1335342 | 2021-05-19 | Sullivan | Tennessee | 47163 | 17034 | 302 |
1332095 | 1332095 | 2021-05-18 | Sullivan | Tennessee | 47163 | 17023 | 301 |
1328848 | 1328848 | 2021-05-17 | Sullivan | Tennessee | 47163 | 16994 | 300 |
1325602 | 1325602 | 2021-05-16 | Sullivan | Tennessee | 47163 | 16952 | 298 |
1322356 | 1322356 | 2021-05-15 | Sullivan | Tennessee | 47163 | 16952 | 298 |
1319110 | 1319110 | 2021-05-14 | Sullivan | Tennessee | 47163 | 16952 | 298 |
1315862 | 1315862 | 2021-05-13 | Sullivan | Tennessee | 47163 | 16916 | 298 |
1312616 | 1312616 | 2021-05-12 | Sullivan | Tennessee | 47163 | 16893 | 297 |
1309369 | 1309369 | 2021-05-11 | Sullivan | Tennessee | 47163 | 16864 | 296 |
1306123 | 1306123 | 2021-05-10 | Sullivan | Tennessee | 47163 | 16846 | 295 |
1302877 | 1302877 | 2021-05-09 | Sullivan | Tennessee | 47163 | 16794 | 294 |
1299630 | 1299630 | 2021-05-08 | Sullivan | Tennessee | 47163 | 16794 | 294 |
1296383 | 1296383 | 2021-05-07 | Sullivan | Tennessee | 47163 | 16794 | 294 |
1293137 | 1293137 | 2021-05-06 | Sullivan | Tennessee | 47163 | 16760 | 294 |
1289891 | 1289891 | 2021-05-05 | Sullivan | Tennessee | 47163 | 16720 | 294 |
1286645 | 1286645 | 2021-05-04 | Sullivan | Tennessee | 47163 | 16691 | 290 |
1283399 | 1283399 | 2021-05-03 | Sullivan | Tennessee | 47163 | 16691 | 290 |
1280152 | 1280152 | 2021-05-02 | Sullivan | Tennessee | 47163 | 16604 | 290 |
1276905 | 1276905 | 2021-05-01 | Sullivan | Tennessee | 47163 | 16604 | 290 |
1273658 | 1273658 | 2021-04-30 | Sullivan | Tennessee | 47163 | 16604 | 290 |
1270411 | 1270411 | 2021-04-29 | Sullivan | Tennessee | 47163 | 16566 | 290 |
1267164 | 1267164 | 2021-04-28 | Sullivan | Tennessee | 47163 | 16506 | 289 |
1263917 | 1263917 | 2021-04-27 | Sullivan | Tennessee | 47163 | 16475 | 289 |
1260670 | 1260670 | 2021-04-26 | Sullivan | Tennessee | 47163 | 16425 | 287 |
1257423 | 1257423 | 2021-04-25 | Sullivan | Tennessee | 47163 | 16362 | 287 |
1254176 | 1254176 | 2021-04-24 | Sullivan | Tennessee | 47163 | 16362 | 287 |
1250929 | 1250929 | 2021-04-23 | Sullivan | Tennessee | 47163 | 16362 | 287 |
1247682 | 1247682 | 2021-04-22 | Sullivan | Tennessee | 47163 | 16318 | 287 |
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 |
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);