ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 47177 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419744 | 1419744 | 2021-06-14 | Warren | Tennessee | 47177 | 5610 | 86 |
1416499 | 1416499 | 2021-06-13 | Warren | Tennessee | 47177 | 5610 | 86 |
1413253 | 1413253 | 2021-06-12 | Warren | Tennessee | 47177 | 5610 | 86 |
1410008 | 1410008 | 2021-06-11 | Warren | Tennessee | 47177 | 5610 | 86 |
1406763 | 1406763 | 2021-06-10 | Warren | Tennessee | 47177 | 5558 | 84 |
1403517 | 1403517 | 2021-06-09 | Warren | Tennessee | 47177 | 5558 | 84 |
1400272 | 1400272 | 2021-06-08 | Warren | Tennessee | 47177 | 5558 | 83 |
1397027 | 1397027 | 2021-06-07 | Warren | Tennessee | 47177 | 5560 | 83 |
1393780 | 1393780 | 2021-06-06 | Warren | Tennessee | 47177 | 5554 | 83 |
1390535 | 1390535 | 2021-06-05 | Warren | Tennessee | 47177 | 5554 | 83 |
1387290 | 1387290 | 2021-06-04 | Warren | Tennessee | 47177 | 5554 | 83 |
1384045 | 1384045 | 2021-06-03 | Warren | Tennessee | 47177 | 5556 | 83 |
1380799 | 1380799 | 2021-06-02 | Warren | Tennessee | 47177 | 5555 | 83 |
1377554 | 1377554 | 2021-06-01 | Warren | Tennessee | 47177 | 5557 | 82 |
1374308 | 1374308 | 2021-05-31 | Warren | Tennessee | 47177 | 5554 | 82 |
1371063 | 1371063 | 2021-05-30 | Warren | Tennessee | 47177 | 5554 | 82 |
1367817 | 1367817 | 2021-05-29 | Warren | Tennessee | 47177 | 5554 | 82 |
1364571 | 1364571 | 2021-05-28 | Warren | Tennessee | 47177 | 5554 | 82 |
1361325 | 1361325 | 2021-05-27 | Warren | Tennessee | 47177 | 5554 | 82 |
1358079 | 1358079 | 2021-05-26 | Warren | Tennessee | 47177 | 5553 | 82 |
1354833 | 1354833 | 2021-05-25 | Warren | Tennessee | 47177 | 5552 | 82 |
1351587 | 1351587 | 2021-05-24 | Warren | Tennessee | 47177 | 5550 | 82 |
1348341 | 1348341 | 2021-05-23 | Warren | Tennessee | 47177 | 5551 | 82 |
1345093 | 1345093 | 2021-05-22 | Warren | Tennessee | 47177 | 5551 | 82 |
1341845 | 1341845 | 2021-05-21 | Warren | Tennessee | 47177 | 5551 | 82 |
1338597 | 1338597 | 2021-05-20 | Warren | Tennessee | 47177 | 5555 | 82 |
1335350 | 1335350 | 2021-05-19 | Warren | Tennessee | 47177 | 5560 | 81 |
1332103 | 1332103 | 2021-05-18 | Warren | Tennessee | 47177 | 5562 | 81 |
1328856 | 1328856 | 2021-05-17 | Warren | Tennessee | 47177 | 5564 | 81 |
1325610 | 1325610 | 2021-05-16 | Warren | Tennessee | 47177 | 5555 | 81 |
1322364 | 1322364 | 2021-05-15 | Warren | Tennessee | 47177 | 5555 | 81 |
1319118 | 1319118 | 2021-05-14 | Warren | Tennessee | 47177 | 5555 | 81 |
1315870 | 1315870 | 2021-05-13 | Warren | Tennessee | 47177 | 5550 | 81 |
1312624 | 1312624 | 2021-05-12 | Warren | Tennessee | 47177 | 5548 | 81 |
1309377 | 1309377 | 2021-05-11 | Warren | Tennessee | 47177 | 5548 | 81 |
1306131 | 1306131 | 2021-05-10 | Warren | Tennessee | 47177 | 5546 | 81 |
1302885 | 1302885 | 2021-05-09 | Warren | Tennessee | 47177 | 5548 | 81 |
1299638 | 1299638 | 2021-05-08 | Warren | Tennessee | 47177 | 5548 | 81 |
1296391 | 1296391 | 2021-05-07 | Warren | Tennessee | 47177 | 5548 | 81 |
1293145 | 1293145 | 2021-05-06 | Warren | Tennessee | 47177 | 5548 | 81 |
1289899 | 1289899 | 2021-05-05 | Warren | Tennessee | 47177 | 5544 | 81 |
1286653 | 1286653 | 2021-05-04 | Warren | Tennessee | 47177 | 5541 | 81 |
1283407 | 1283407 | 2021-05-03 | Warren | Tennessee | 47177 | 5540 | 81 |
1280160 | 1280160 | 2021-05-02 | Warren | Tennessee | 47177 | 5539 | 81 |
1276913 | 1276913 | 2021-05-01 | Warren | Tennessee | 47177 | 5539 | 81 |
1273666 | 1273666 | 2021-04-30 | Warren | Tennessee | 47177 | 5539 | 81 |
1270419 | 1270419 | 2021-04-29 | Warren | Tennessee | 47177 | 5538 | 81 |
1267172 | 1267172 | 2021-04-28 | Warren | Tennessee | 47177 | 5534 | 81 |
1263925 | 1263925 | 2021-04-27 | Warren | Tennessee | 47177 | 5534 | 81 |
1260678 | 1260678 | 2021-04-26 | Warren | Tennessee | 47177 | 5533 | 81 |
1257431 | 1257431 | 2021-04-25 | Warren | Tennessee | 47177 | 5528 | 81 |
1254184 | 1254184 | 2021-04-24 | Warren | Tennessee | 47177 | 5528 | 81 |
1250937 | 1250937 | 2021-04-23 | Warren | Tennessee | 47177 | 5528 | 81 |
1247690 | 1247690 | 2021-04-22 | Warren | Tennessee | 47177 | 5526 | 81 |
1244443 | 1244443 | 2021-04-21 | Warren | Tennessee | 47177 | 5518 | 81 |
1241196 | 1241196 | 2021-04-20 | Warren | Tennessee | 47177 | 5515 | 81 |
1237949 | 1237949 | 2021-04-19 | Warren | Tennessee | 47177 | 5513 | 81 |
1234702 | 1234702 | 2021-04-18 | Warren | Tennessee | 47177 | 5508 | 81 |
1231454 | 1231454 | 2021-04-17 | Warren | Tennessee | 47177 | 5508 | 81 |
1228206 | 1228206 | 2021-04-16 | Warren | Tennessee | 47177 | 5508 | 81 |
1224958 | 1224958 | 2021-04-15 | Warren | Tennessee | 47177 | 5504 | 81 |
1221711 | 1221711 | 2021-04-14 | Warren | Tennessee | 47177 | 5503 | 81 |
1218463 | 1218463 | 2021-04-13 | Warren | Tennessee | 47177 | 5501 | 80 |
1215215 | 1215215 | 2021-04-12 | Warren | Tennessee | 47177 | 5498 | 80 |
1211968 | 1211968 | 2021-04-11 | Warren | Tennessee | 47177 | 5494 | 81 |
1208719 | 1208719 | 2021-04-10 | Warren | Tennessee | 47177 | 5494 | 81 |
1205471 | 1205471 | 2021-04-09 | Warren | Tennessee | 47177 | 5494 | 81 |
1202223 | 1202223 | 2021-04-08 | Warren | Tennessee | 47177 | 5493 | 80 |
1198974 | 1198974 | 2021-04-07 | Warren | Tennessee | 47177 | 5482 | 80 |
1195725 | 1195725 | 2021-04-06 | Warren | Tennessee | 47177 | 5480 | 80 |
1192477 | 1192477 | 2021-04-05 | Warren | Tennessee | 47177 | 5474 | 80 |
1189228 | 1189228 | 2021-04-04 | Warren | Tennessee | 47177 | 5447 | 80 |
1185981 | 1185981 | 2021-04-03 | Warren | Tennessee | 47177 | 5447 | 80 |
1182734 | 1182734 | 2021-04-02 | Warren | Tennessee | 47177 | 5447 | 80 |
1179487 | 1179487 | 2021-04-01 | Warren | Tennessee | 47177 | 5447 | 80 |
1176240 | 1176240 | 2021-03-31 | Warren | Tennessee | 47177 | 5433 | 80 |
1172993 | 1172993 | 2021-03-30 | Warren | Tennessee | 47177 | 5426 | 80 |
1169746 | 1169746 | 2021-03-29 | Warren | Tennessee | 47177 | 5424 | 80 |
1166498 | 1166498 | 2021-03-28 | Warren | Tennessee | 47177 | 5415 | 80 |
1163250 | 1163250 | 2021-03-27 | Warren | Tennessee | 47177 | 5415 | 80 |
1160001 | 1160001 | 2021-03-26 | Warren | Tennessee | 47177 | 5415 | 80 |
1156754 | 1156754 | 2021-03-25 | Warren | Tennessee | 47177 | 5413 | 80 |
1153507 | 1153507 | 2021-03-24 | Warren | Tennessee | 47177 | 5409 | 80 |
1150260 | 1150260 | 2021-03-23 | Warren | Tennessee | 47177 | 5399 | 80 |
1147013 | 1147013 | 2021-03-22 | Warren | Tennessee | 47177 | 5397 | 80 |
1143766 | 1143766 | 2021-03-21 | Warren | Tennessee | 47177 | 5386 | 79 |
1140519 | 1140519 | 2021-03-20 | Warren | Tennessee | 47177 | 5386 | 79 |
1137273 | 1137273 | 2021-03-19 | Warren | Tennessee | 47177 | 5386 | 79 |
1134027 | 1134027 | 2021-03-18 | Warren | Tennessee | 47177 | 5378 | 79 |
1130779 | 1130779 | 2021-03-17 | Warren | Tennessee | 47177 | 5377 | 79 |
1127532 | 1127532 | 2021-03-16 | Warren | Tennessee | 47177 | 5371 | 79 |
1124286 | 1124286 | 2021-03-15 | Warren | Tennessee | 47177 | 5370 | 78 |
1121040 | 1121040 | 2021-03-14 | Warren | Tennessee | 47177 | 5355 | 78 |
1117793 | 1117793 | 2021-03-13 | Warren | Tennessee | 47177 | 5355 | 78 |
1114546 | 1114546 | 2021-03-12 | Warren | Tennessee | 47177 | 5355 | 78 |
1111300 | 1111300 | 2021-03-11 | Warren | Tennessee | 47177 | 5347 | 78 |
1108054 | 1108054 | 2021-03-10 | Warren | Tennessee | 47177 | 5342 | 78 |
1104808 | 1104808 | 2021-03-09 | Warren | Tennessee | 47177 | 5338 | 78 |
1101562 | 1101562 | 2021-03-08 | Warren | Tennessee | 47177 | 5338 | 77 |
1098316 | 1098316 | 2021-03-07 | Warren | Tennessee | 47177 | 5337 | 77 |
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);