ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 47025 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419667 | 1419667 | 2021-06-14 | Claiborne | Tennessee | 47025 | 3226 | 74 |
1416422 | 1416422 | 2021-06-13 | Claiborne | Tennessee | 47025 | 3226 | 74 |
1413176 | 1413176 | 2021-06-12 | Claiborne | Tennessee | 47025 | 3226 | 74 |
1409931 | 1409931 | 2021-06-11 | Claiborne | Tennessee | 47025 | 3226 | 74 |
1406686 | 1406686 | 2021-06-10 | Claiborne | Tennessee | 47025 | 3205 | 74 |
1403440 | 1403440 | 2021-06-09 | Claiborne | Tennessee | 47025 | 3203 | 74 |
1400195 | 1400195 | 2021-06-08 | Claiborne | Tennessee | 47025 | 3202 | 74 |
1396950 | 1396950 | 2021-06-07 | Claiborne | Tennessee | 47025 | 3202 | 74 |
1393703 | 1393703 | 2021-06-06 | Claiborne | Tennessee | 47025 | 3201 | 74 |
1390458 | 1390458 | 2021-06-05 | Claiborne | Tennessee | 47025 | 3201 | 74 |
1387213 | 1387213 | 2021-06-04 | Claiborne | Tennessee | 47025 | 3201 | 74 |
1383968 | 1383968 | 2021-06-03 | Claiborne | Tennessee | 47025 | 3200 | 74 |
1380722 | 1380722 | 2021-06-02 | Claiborne | Tennessee | 47025 | 3202 | 74 |
1377477 | 1377477 | 2021-06-01 | Claiborne | Tennessee | 47025 | 3200 | 74 |
1374231 | 1374231 | 2021-05-31 | Claiborne | Tennessee | 47025 | 3197 | 74 |
1370986 | 1370986 | 2021-05-30 | Claiborne | Tennessee | 47025 | 3197 | 74 |
1367740 | 1367740 | 2021-05-29 | Claiborne | Tennessee | 47025 | 3197 | 74 |
1364494 | 1364494 | 2021-05-28 | Claiborne | Tennessee | 47025 | 3197 | 74 |
1361248 | 1361248 | 2021-05-27 | Claiborne | Tennessee | 47025 | 3198 | 74 |
1358002 | 1358002 | 2021-05-26 | Claiborne | Tennessee | 47025 | 3196 | 74 |
1354756 | 1354756 | 2021-05-25 | Claiborne | Tennessee | 47025 | 3194 | 74 |
1351510 | 1351510 | 2021-05-24 | Claiborne | Tennessee | 47025 | 3192 | 74 |
1348264 | 1348264 | 2021-05-23 | Claiborne | Tennessee | 47025 | 3194 | 74 |
1345016 | 1345016 | 2021-05-22 | Claiborne | Tennessee | 47025 | 3194 | 74 |
1341768 | 1341768 | 2021-05-21 | Claiborne | Tennessee | 47025 | 3194 | 74 |
1338520 | 1338520 | 2021-05-20 | Claiborne | Tennessee | 47025 | 3195 | 73 |
1335273 | 1335273 | 2021-05-19 | Claiborne | Tennessee | 47025 | 3193 | 73 |
1332026 | 1332026 | 2021-05-18 | Claiborne | Tennessee | 47025 | 3190 | 73 |
1328779 | 1328779 | 2021-05-17 | Claiborne | Tennessee | 47025 | 3189 | 73 |
1325533 | 1325533 | 2021-05-16 | Claiborne | Tennessee | 47025 | 3188 | 73 |
1322287 | 1322287 | 2021-05-15 | Claiborne | Tennessee | 47025 | 3188 | 73 |
1319041 | 1319041 | 2021-05-14 | Claiborne | Tennessee | 47025 | 3188 | 73 |
1315793 | 1315793 | 2021-05-13 | Claiborne | Tennessee | 47025 | 3189 | 73 |
1312547 | 1312547 | 2021-05-12 | Claiborne | Tennessee | 47025 | 3188 | 73 |
1309300 | 1309300 | 2021-05-11 | Claiborne | Tennessee | 47025 | 3186 | 73 |
1306054 | 1306054 | 2021-05-10 | Claiborne | Tennessee | 47025 | 3181 | 73 |
1302808 | 1302808 | 2021-05-09 | Claiborne | Tennessee | 47025 | 3182 | 73 |
1299561 | 1299561 | 2021-05-08 | Claiborne | Tennessee | 47025 | 3182 | 73 |
1296314 | 1296314 | 2021-05-07 | Claiborne | Tennessee | 47025 | 3182 | 73 |
1293068 | 1293068 | 2021-05-06 | Claiborne | Tennessee | 47025 | 3177 | 73 |
1289822 | 1289822 | 2021-05-05 | Claiborne | Tennessee | 47025 | 3178 | 73 |
1286576 | 1286576 | 2021-05-04 | Claiborne | Tennessee | 47025 | 3172 | 73 |
1283330 | 1283330 | 2021-05-03 | Claiborne | Tennessee | 47025 | 3168 | 73 |
1280083 | 1280083 | 2021-05-02 | Claiborne | Tennessee | 47025 | 3165 | 73 |
1276836 | 1276836 | 2021-05-01 | Claiborne | Tennessee | 47025 | 3165 | 73 |
1273589 | 1273589 | 2021-04-30 | Claiborne | Tennessee | 47025 | 3165 | 73 |
1270342 | 1270342 | 2021-04-29 | Claiborne | Tennessee | 47025 | 3160 | 73 |
1267095 | 1267095 | 2021-04-28 | Claiborne | Tennessee | 47025 | 3147 | 73 |
1263848 | 1263848 | 2021-04-27 | Claiborne | Tennessee | 47025 | 3132 | 73 |
1260601 | 1260601 | 2021-04-26 | Claiborne | Tennessee | 47025 | 3118 | 73 |
1257354 | 1257354 | 2021-04-25 | Claiborne | Tennessee | 47025 | 3104 | 73 |
1254107 | 1254107 | 2021-04-24 | Claiborne | Tennessee | 47025 | 3104 | 73 |
1250860 | 1250860 | 2021-04-23 | Claiborne | Tennessee | 47025 | 3104 | 73 |
1247613 | 1247613 | 2021-04-22 | Claiborne | Tennessee | 47025 | 3093 | 73 |
1244366 | 1244366 | 2021-04-21 | Claiborne | Tennessee | 47025 | 3073 | 73 |
1241119 | 1241119 | 2021-04-20 | Claiborne | Tennessee | 47025 | 3061 | 73 |
1237872 | 1237872 | 2021-04-19 | Claiborne | Tennessee | 47025 | 3062 | 73 |
1234625 | 1234625 | 2021-04-18 | Claiborne | Tennessee | 47025 | 3055 | 73 |
1231377 | 1231377 | 2021-04-17 | Claiborne | Tennessee | 47025 | 3055 | 73 |
1228129 | 1228129 | 2021-04-16 | Claiborne | Tennessee | 47025 | 3055 | 73 |
1224881 | 1224881 | 2021-04-15 | Claiborne | Tennessee | 47025 | 3048 | 73 |
1221634 | 1221634 | 2021-04-14 | Claiborne | Tennessee | 47025 | 3039 | 73 |
1218386 | 1218386 | 2021-04-13 | Claiborne | Tennessee | 47025 | 3036 | 73 |
1215138 | 1215138 | 2021-04-12 | Claiborne | Tennessee | 47025 | 3032 | 73 |
1211891 | 1211891 | 2021-04-11 | Claiborne | Tennessee | 47025 | 3023 | 73 |
1208642 | 1208642 | 2021-04-10 | Claiborne | Tennessee | 47025 | 3023 | 73 |
1205394 | 1205394 | 2021-04-09 | Claiborne | Tennessee | 47025 | 3023 | 73 |
1202146 | 1202146 | 2021-04-08 | Claiborne | Tennessee | 47025 | 3014 | 74 |
1198897 | 1198897 | 2021-04-07 | Claiborne | Tennessee | 47025 | 3008 | 74 |
1195648 | 1195648 | 2021-04-06 | Claiborne | Tennessee | 47025 | 3004 | 74 |
1192400 | 1192400 | 2021-04-05 | Claiborne | Tennessee | 47025 | 2998 | 74 |
1189151 | 1189151 | 2021-04-04 | Claiborne | Tennessee | 47025 | 2979 | 74 |
1185904 | 1185904 | 2021-04-03 | Claiborne | Tennessee | 47025 | 2979 | 74 |
1182657 | 1182657 | 2021-04-02 | Claiborne | Tennessee | 47025 | 2979 | 74 |
1179410 | 1179410 | 2021-04-01 | Claiborne | Tennessee | 47025 | 2979 | 74 |
1176163 | 1176163 | 2021-03-31 | Claiborne | Tennessee | 47025 | 2977 | 74 |
1172916 | 1172916 | 2021-03-30 | Claiborne | Tennessee | 47025 | 2973 | 74 |
1169669 | 1169669 | 2021-03-29 | Claiborne | Tennessee | 47025 | 2967 | 74 |
1166421 | 1166421 | 2021-03-28 | Claiborne | Tennessee | 47025 | 2956 | 73 |
1163173 | 1163173 | 2021-03-27 | Claiborne | Tennessee | 47025 | 2956 | 73 |
1159924 | 1159924 | 2021-03-26 | Claiborne | Tennessee | 47025 | 2956 | 73 |
1156677 | 1156677 | 2021-03-25 | Claiborne | Tennessee | 47025 | 2947 | 73 |
1153430 | 1153430 | 2021-03-24 | Claiborne | Tennessee | 47025 | 2941 | 73 |
1150183 | 1150183 | 2021-03-23 | Claiborne | Tennessee | 47025 | 2939 | 72 |
1146936 | 1146936 | 2021-03-22 | Claiborne | Tennessee | 47025 | 2933 | 71 |
1143689 | 1143689 | 2021-03-21 | Claiborne | Tennessee | 47025 | 2927 | 71 |
1140442 | 1140442 | 2021-03-20 | Claiborne | Tennessee | 47025 | 2927 | 71 |
1137196 | 1137196 | 2021-03-19 | Claiborne | Tennessee | 47025 | 2927 | 71 |
1133950 | 1133950 | 2021-03-18 | Claiborne | Tennessee | 47025 | 2923 | 71 |
1130702 | 1130702 | 2021-03-17 | Claiborne | Tennessee | 47025 | 2922 | 71 |
1127455 | 1127455 | 2021-03-16 | Claiborne | Tennessee | 47025 | 2910 | 71 |
1124209 | 1124209 | 2021-03-15 | Claiborne | Tennessee | 47025 | 2903 | 71 |
1120963 | 1120963 | 2021-03-14 | Claiborne | Tennessee | 47025 | 2894 | 71 |
1117716 | 1117716 | 2021-03-13 | Claiborne | Tennessee | 47025 | 2894 | 71 |
1114469 | 1114469 | 2021-03-12 | Claiborne | Tennessee | 47025 | 2894 | 71 |
1111223 | 1111223 | 2021-03-11 | Claiborne | Tennessee | 47025 | 2883 | 71 |
1107977 | 1107977 | 2021-03-10 | Claiborne | Tennessee | 47025 | 2878 | 71 |
1104731 | 1104731 | 2021-03-09 | Claiborne | Tennessee | 47025 | 2867 | 71 |
1101485 | 1101485 | 2021-03-08 | Claiborne | Tennessee | 47025 | 2856 | 69 |
1098239 | 1098239 | 2021-03-07 | Claiborne | Tennessee | 47025 | 2853 | 69 |
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);