ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
734 rows where fips = 47137 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419723 | 1419723 | 2021-06-14 | Pickett | Tennessee | 47137 | 764 | 24 |
1416478 | 1416478 | 2021-06-13 | Pickett | Tennessee | 47137 | 764 | 24 |
1413232 | 1413232 | 2021-06-12 | Pickett | Tennessee | 47137 | 764 | 24 |
1409987 | 1409987 | 2021-06-11 | Pickett | Tennessee | 47137 | 764 | 24 |
1406742 | 1406742 | 2021-06-10 | Pickett | Tennessee | 47137 | 763 | 24 |
1403496 | 1403496 | 2021-06-09 | Pickett | Tennessee | 47137 | 763 | 24 |
1400251 | 1400251 | 2021-06-08 | Pickett | Tennessee | 47137 | 763 | 24 |
1397006 | 1397006 | 2021-06-07 | Pickett | Tennessee | 47137 | 763 | 24 |
1393759 | 1393759 | 2021-06-06 | Pickett | Tennessee | 47137 | 763 | 24 |
1390514 | 1390514 | 2021-06-05 | Pickett | Tennessee | 47137 | 763 | 24 |
1387269 | 1387269 | 2021-06-04 | Pickett | Tennessee | 47137 | 763 | 24 |
1384024 | 1384024 | 2021-06-03 | Pickett | Tennessee | 47137 | 763 | 24 |
1380778 | 1380778 | 2021-06-02 | Pickett | Tennessee | 47137 | 763 | 24 |
1377533 | 1377533 | 2021-06-01 | Pickett | Tennessee | 47137 | 764 | 24 |
1374287 | 1374287 | 2021-05-31 | Pickett | Tennessee | 47137 | 763 | 24 |
1371042 | 1371042 | 2021-05-30 | Pickett | Tennessee | 47137 | 763 | 24 |
1367796 | 1367796 | 2021-05-29 | Pickett | Tennessee | 47137 | 763 | 24 |
1364550 | 1364550 | 2021-05-28 | Pickett | Tennessee | 47137 | 763 | 24 |
1361304 | 1361304 | 2021-05-27 | Pickett | Tennessee | 47137 | 763 | 24 |
1358058 | 1358058 | 2021-05-26 | Pickett | Tennessee | 47137 | 763 | 24 |
1354812 | 1354812 | 2021-05-25 | Pickett | Tennessee | 47137 | 763 | 24 |
1351566 | 1351566 | 2021-05-24 | Pickett | Tennessee | 47137 | 764 | 24 |
1348320 | 1348320 | 2021-05-23 | Pickett | Tennessee | 47137 | 761 | 24 |
1345072 | 1345072 | 2021-05-22 | Pickett | Tennessee | 47137 | 761 | 24 |
1341824 | 1341824 | 2021-05-21 | Pickett | Tennessee | 47137 | 761 | 24 |
1338576 | 1338576 | 2021-05-20 | Pickett | Tennessee | 47137 | 758 | 24 |
1335329 | 1335329 | 2021-05-19 | Pickett | Tennessee | 47137 | 758 | 24 |
1332082 | 1332082 | 2021-05-18 | Pickett | Tennessee | 47137 | 758 | 24 |
1328835 | 1328835 | 2021-05-17 | Pickett | Tennessee | 47137 | 758 | 24 |
1325589 | 1325589 | 2021-05-16 | Pickett | Tennessee | 47137 | 759 | 24 |
1322343 | 1322343 | 2021-05-15 | Pickett | Tennessee | 47137 | 759 | 24 |
1319097 | 1319097 | 2021-05-14 | Pickett | Tennessee | 47137 | 759 | 24 |
1315849 | 1315849 | 2021-05-13 | Pickett | Tennessee | 47137 | 759 | 24 |
1312603 | 1312603 | 2021-05-12 | Pickett | Tennessee | 47137 | 760 | 24 |
1309356 | 1309356 | 2021-05-11 | Pickett | Tennessee | 47137 | 760 | 24 |
1306110 | 1306110 | 2021-05-10 | Pickett | Tennessee | 47137 | 760 | 24 |
1302864 | 1302864 | 2021-05-09 | Pickett | Tennessee | 47137 | 760 | 24 |
1299617 | 1299617 | 2021-05-08 | Pickett | Tennessee | 47137 | 760 | 24 |
1296370 | 1296370 | 2021-05-07 | Pickett | Tennessee | 47137 | 760 | 24 |
1293124 | 1293124 | 2021-05-06 | Pickett | Tennessee | 47137 | 759 | 24 |
1289878 | 1289878 | 2021-05-05 | Pickett | Tennessee | 47137 | 759 | 24 |
1286632 | 1286632 | 2021-05-04 | Pickett | Tennessee | 47137 | 759 | 24 |
1283386 | 1283386 | 2021-05-03 | Pickett | Tennessee | 47137 | 759 | 24 |
1280139 | 1280139 | 2021-05-02 | Pickett | Tennessee | 47137 | 759 | 24 |
1276892 | 1276892 | 2021-05-01 | Pickett | Tennessee | 47137 | 759 | 24 |
1273645 | 1273645 | 2021-04-30 | Pickett | Tennessee | 47137 | 759 | 24 |
1270398 | 1270398 | 2021-04-29 | Pickett | Tennessee | 47137 | 759 | 24 |
1267151 | 1267151 | 2021-04-28 | Pickett | Tennessee | 47137 | 759 | 24 |
1263904 | 1263904 | 2021-04-27 | Pickett | Tennessee | 47137 | 759 | 24 |
1260657 | 1260657 | 2021-04-26 | Pickett | Tennessee | 47137 | 757 | 24 |
1257410 | 1257410 | 2021-04-25 | Pickett | Tennessee | 47137 | 757 | 24 |
1254163 | 1254163 | 2021-04-24 | Pickett | Tennessee | 47137 | 757 | 24 |
1250916 | 1250916 | 2021-04-23 | Pickett | Tennessee | 47137 | 757 | 24 |
1247669 | 1247669 | 2021-04-22 | Pickett | Tennessee | 47137 | 757 | 24 |
1244422 | 1244422 | 2021-04-21 | Pickett | Tennessee | 47137 | 757 | 24 |
1241175 | 1241175 | 2021-04-20 | Pickett | Tennessee | 47137 | 757 | 24 |
1237928 | 1237928 | 2021-04-19 | Pickett | Tennessee | 47137 | 756 | 24 |
1234681 | 1234681 | 2021-04-18 | Pickett | Tennessee | 47137 | 756 | 24 |
1231433 | 1231433 | 2021-04-17 | Pickett | Tennessee | 47137 | 756 | 24 |
1228185 | 1228185 | 2021-04-16 | Pickett | Tennessee | 47137 | 756 | 24 |
1224937 | 1224937 | 2021-04-15 | Pickett | Tennessee | 47137 | 756 | 24 |
1221690 | 1221690 | 2021-04-14 | Pickett | Tennessee | 47137 | 755 | 24 |
1218442 | 1218442 | 2021-04-13 | Pickett | Tennessee | 47137 | 755 | 24 |
1215194 | 1215194 | 2021-04-12 | Pickett | Tennessee | 47137 | 755 | 24 |
1211947 | 1211947 | 2021-04-11 | Pickett | Tennessee | 47137 | 755 | 24 |
1208698 | 1208698 | 2021-04-10 | Pickett | Tennessee | 47137 | 755 | 24 |
1205450 | 1205450 | 2021-04-09 | Pickett | Tennessee | 47137 | 755 | 24 |
1202202 | 1202202 | 2021-04-08 | Pickett | Tennessee | 47137 | 755 | 24 |
1198953 | 1198953 | 2021-04-07 | Pickett | Tennessee | 47137 | 755 | 24 |
1195704 | 1195704 | 2021-04-06 | Pickett | Tennessee | 47137 | 755 | 24 |
1192456 | 1192456 | 2021-04-05 | Pickett | Tennessee | 47137 | 754 | 24 |
1189207 | 1189207 | 2021-04-04 | Pickett | Tennessee | 47137 | 753 | 24 |
1185960 | 1185960 | 2021-04-03 | Pickett | Tennessee | 47137 | 753 | 24 |
1182713 | 1182713 | 2021-04-02 | Pickett | Tennessee | 47137 | 753 | 24 |
1179466 | 1179466 | 2021-04-01 | Pickett | Tennessee | 47137 | 753 | 24 |
1176219 | 1176219 | 2021-03-31 | Pickett | Tennessee | 47137 | 753 | 24 |
1172972 | 1172972 | 2021-03-30 | Pickett | Tennessee | 47137 | 753 | 24 |
1169725 | 1169725 | 2021-03-29 | Pickett | Tennessee | 47137 | 753 | 24 |
1166477 | 1166477 | 2021-03-28 | Pickett | Tennessee | 47137 | 753 | 23 |
1163229 | 1163229 | 2021-03-27 | Pickett | Tennessee | 47137 | 753 | 23 |
1159980 | 1159980 | 2021-03-26 | Pickett | Tennessee | 47137 | 753 | 23 |
1156733 | 1156733 | 2021-03-25 | Pickett | Tennessee | 47137 | 751 | 23 |
1153486 | 1153486 | 2021-03-24 | Pickett | Tennessee | 47137 | 751 | 23 |
1150239 | 1150239 | 2021-03-23 | Pickett | Tennessee | 47137 | 751 | 23 |
1146992 | 1146992 | 2021-03-22 | Pickett | Tennessee | 47137 | 751 | 23 |
1143745 | 1143745 | 2021-03-21 | Pickett | Tennessee | 47137 | 751 | 23 |
1140498 | 1140498 | 2021-03-20 | Pickett | Tennessee | 47137 | 751 | 23 |
1137252 | 1137252 | 2021-03-19 | Pickett | Tennessee | 47137 | 751 | 23 |
1134006 | 1134006 | 2021-03-18 | Pickett | Tennessee | 47137 | 751 | 23 |
1130758 | 1130758 | 2021-03-17 | Pickett | Tennessee | 47137 | 751 | 23 |
1127511 | 1127511 | 2021-03-16 | Pickett | Tennessee | 47137 | 750 | 23 |
1124265 | 1124265 | 2021-03-15 | Pickett | Tennessee | 47137 | 750 | 23 |
1121019 | 1121019 | 2021-03-14 | Pickett | Tennessee | 47137 | 748 | 23 |
1117772 | 1117772 | 2021-03-13 | Pickett | Tennessee | 47137 | 748 | 23 |
1114525 | 1114525 | 2021-03-12 | Pickett | Tennessee | 47137 | 748 | 23 |
1111279 | 1111279 | 2021-03-11 | Pickett | Tennessee | 47137 | 748 | 23 |
1108033 | 1108033 | 2021-03-10 | Pickett | Tennessee | 47137 | 748 | 23 |
1104787 | 1104787 | 2021-03-09 | Pickett | Tennessee | 47137 | 748 | 23 |
1101541 | 1101541 | 2021-03-08 | Pickett | Tennessee | 47137 | 748 | 23 |
1098295 | 1098295 | 2021-03-07 | Pickett | Tennessee | 47137 | 748 | 23 |
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);