ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 47027 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419668 | 1419668 | 2021-06-14 | Clay | Tennessee | 47027 | 1107 | 31 |
1416423 | 1416423 | 2021-06-13 | Clay | Tennessee | 47027 | 1107 | 31 |
1413177 | 1413177 | 2021-06-12 | Clay | Tennessee | 47027 | 1107 | 31 |
1409932 | 1409932 | 2021-06-11 | Clay | Tennessee | 47027 | 1107 | 31 |
1406687 | 1406687 | 2021-06-10 | Clay | Tennessee | 47027 | 1102 | 30 |
1403441 | 1403441 | 2021-06-09 | Clay | Tennessee | 47027 | 1102 | 30 |
1400196 | 1400196 | 2021-06-08 | Clay | Tennessee | 47027 | 1102 | 30 |
1396951 | 1396951 | 2021-06-07 | Clay | Tennessee | 47027 | 1102 | 30 |
1393704 | 1393704 | 2021-06-06 | Clay | Tennessee | 47027 | 1102 | 30 |
1390459 | 1390459 | 2021-06-05 | Clay | Tennessee | 47027 | 1102 | 30 |
1387214 | 1387214 | 2021-06-04 | Clay | Tennessee | 47027 | 1102 | 30 |
1383969 | 1383969 | 2021-06-03 | Clay | Tennessee | 47027 | 1102 | 30 |
1380723 | 1380723 | 2021-06-02 | Clay | Tennessee | 47027 | 1102 | 30 |
1377478 | 1377478 | 2021-06-01 | Clay | Tennessee | 47027 | 1102 | 30 |
1374232 | 1374232 | 2021-05-31 | Clay | Tennessee | 47027 | 1102 | 30 |
1370987 | 1370987 | 2021-05-30 | Clay | Tennessee | 47027 | 1102 | 30 |
1367741 | 1367741 | 2021-05-29 | Clay | Tennessee | 47027 | 1102 | 30 |
1364495 | 1364495 | 2021-05-28 | Clay | Tennessee | 47027 | 1102 | 30 |
1361249 | 1361249 | 2021-05-27 | Clay | Tennessee | 47027 | 1103 | 30 |
1358003 | 1358003 | 2021-05-26 | Clay | Tennessee | 47027 | 1104 | 30 |
1354757 | 1354757 | 2021-05-25 | Clay | Tennessee | 47027 | 1104 | 30 |
1351511 | 1351511 | 2021-05-24 | Clay | Tennessee | 47027 | 1104 | 30 |
1348265 | 1348265 | 2021-05-23 | Clay | Tennessee | 47027 | 1104 | 30 |
1345017 | 1345017 | 2021-05-22 | Clay | Tennessee | 47027 | 1104 | 30 |
1341769 | 1341769 | 2021-05-21 | Clay | Tennessee | 47027 | 1104 | 30 |
1338521 | 1338521 | 2021-05-20 | Clay | Tennessee | 47027 | 1104 | 30 |
1335274 | 1335274 | 2021-05-19 | Clay | Tennessee | 47027 | 1104 | 30 |
1332027 | 1332027 | 2021-05-18 | Clay | Tennessee | 47027 | 1104 | 30 |
1328780 | 1328780 | 2021-05-17 | Clay | Tennessee | 47027 | 1103 | 30 |
1325534 | 1325534 | 2021-05-16 | Clay | Tennessee | 47027 | 1103 | 30 |
1322288 | 1322288 | 2021-05-15 | Clay | Tennessee | 47027 | 1103 | 30 |
1319042 | 1319042 | 2021-05-14 | Clay | Tennessee | 47027 | 1103 | 30 |
1315794 | 1315794 | 2021-05-13 | Clay | Tennessee | 47027 | 1103 | 30 |
1312548 | 1312548 | 2021-05-12 | Clay | Tennessee | 47027 | 1102 | 30 |
1309301 | 1309301 | 2021-05-11 | Clay | Tennessee | 47027 | 1103 | 31 |
1306055 | 1306055 | 2021-05-10 | Clay | Tennessee | 47027 | 1103 | 31 |
1302809 | 1302809 | 2021-05-09 | Clay | Tennessee | 47027 | 1101 | 31 |
1299562 | 1299562 | 2021-05-08 | Clay | Tennessee | 47027 | 1101 | 31 |
1296315 | 1296315 | 2021-05-07 | Clay | Tennessee | 47027 | 1101 | 31 |
1293069 | 1293069 | 2021-05-06 | Clay | Tennessee | 47027 | 1101 | 31 |
1289823 | 1289823 | 2021-05-05 | Clay | Tennessee | 47027 | 1101 | 31 |
1286577 | 1286577 | 2021-05-04 | Clay | Tennessee | 47027 | 1101 | 31 |
1283331 | 1283331 | 2021-05-03 | Clay | Tennessee | 47027 | 1101 | 31 |
1280084 | 1280084 | 2021-05-02 | Clay | Tennessee | 47027 | 1101 | 31 |
1276837 | 1276837 | 2021-05-01 | Clay | Tennessee | 47027 | 1101 | 31 |
1273590 | 1273590 | 2021-04-30 | Clay | Tennessee | 47027 | 1101 | 31 |
1270343 | 1270343 | 2021-04-29 | Clay | Tennessee | 47027 | 1100 | 31 |
1267096 | 1267096 | 2021-04-28 | Clay | Tennessee | 47027 | 1100 | 31 |
1263849 | 1263849 | 2021-04-27 | Clay | Tennessee | 47027 | 1100 | 31 |
1260602 | 1260602 | 2021-04-26 | Clay | Tennessee | 47027 | 1100 | 31 |
1257355 | 1257355 | 2021-04-25 | Clay | Tennessee | 47027 | 1099 | 31 |
1254108 | 1254108 | 2021-04-24 | Clay | Tennessee | 47027 | 1099 | 31 |
1250861 | 1250861 | 2021-04-23 | Clay | Tennessee | 47027 | 1099 | 31 |
1247614 | 1247614 | 2021-04-22 | Clay | Tennessee | 47027 | 1099 | 31 |
1244367 | 1244367 | 2021-04-21 | Clay | Tennessee | 47027 | 1094 | 31 |
1241120 | 1241120 | 2021-04-20 | Clay | Tennessee | 47027 | 1093 | 31 |
1237873 | 1237873 | 2021-04-19 | Clay | Tennessee | 47027 | 1090 | 31 |
1234626 | 1234626 | 2021-04-18 | Clay | Tennessee | 47027 | 1090 | 31 |
1231378 | 1231378 | 2021-04-17 | Clay | Tennessee | 47027 | 1090 | 31 |
1228130 | 1228130 | 2021-04-16 | Clay | Tennessee | 47027 | 1090 | 31 |
1224882 | 1224882 | 2021-04-15 | Clay | Tennessee | 47027 | 1090 | 31 |
1221635 | 1221635 | 2021-04-14 | Clay | Tennessee | 47027 | 1088 | 31 |
1218387 | 1218387 | 2021-04-13 | Clay | Tennessee | 47027 | 1085 | 31 |
1215139 | 1215139 | 2021-04-12 | Clay | Tennessee | 47027 | 1085 | 31 |
1211892 | 1211892 | 2021-04-11 | Clay | Tennessee | 47027 | 1083 | 31 |
1208643 | 1208643 | 2021-04-10 | Clay | Tennessee | 47027 | 1083 | 31 |
1205395 | 1205395 | 2021-04-09 | Clay | Tennessee | 47027 | 1083 | 31 |
1202147 | 1202147 | 2021-04-08 | Clay | Tennessee | 47027 | 1083 | 31 |
1198898 | 1198898 | 2021-04-07 | Clay | Tennessee | 47027 | 1083 | 31 |
1195649 | 1195649 | 2021-04-06 | Clay | Tennessee | 47027 | 1082 | 31 |
1192401 | 1192401 | 2021-04-05 | Clay | Tennessee | 47027 | 1080 | 31 |
1189152 | 1189152 | 2021-04-04 | Clay | Tennessee | 47027 | 1079 | 31 |
1185905 | 1185905 | 2021-04-03 | Clay | Tennessee | 47027 | 1079 | 31 |
1182658 | 1182658 | 2021-04-02 | Clay | Tennessee | 47027 | 1079 | 31 |
1179411 | 1179411 | 2021-04-01 | Clay | Tennessee | 47027 | 1079 | 31 |
1176164 | 1176164 | 2021-03-31 | Clay | Tennessee | 47027 | 1076 | 31 |
1172917 | 1172917 | 2021-03-30 | Clay | Tennessee | 47027 | 1076 | 31 |
1169670 | 1169670 | 2021-03-29 | Clay | Tennessee | 47027 | 1076 | 31 |
1166422 | 1166422 | 2021-03-28 | Clay | Tennessee | 47027 | 1076 | 31 |
1163174 | 1163174 | 2021-03-27 | Clay | Tennessee | 47027 | 1076 | 31 |
1159925 | 1159925 | 2021-03-26 | Clay | Tennessee | 47027 | 1076 | 31 |
1156678 | 1156678 | 2021-03-25 | Clay | Tennessee | 47027 | 1076 | 31 |
1153431 | 1153431 | 2021-03-24 | Clay | Tennessee | 47027 | 1076 | 31 |
1150184 | 1150184 | 2021-03-23 | Clay | Tennessee | 47027 | 1076 | 31 |
1146937 | 1146937 | 2021-03-22 | Clay | Tennessee | 47027 | 1075 | 31 |
1143690 | 1143690 | 2021-03-21 | Clay | Tennessee | 47027 | 1074 | 31 |
1140443 | 1140443 | 2021-03-20 | Clay | Tennessee | 47027 | 1074 | 31 |
1137197 | 1137197 | 2021-03-19 | Clay | Tennessee | 47027 | 1074 | 31 |
1133951 | 1133951 | 2021-03-18 | Clay | Tennessee | 47027 | 1073 | 31 |
1130703 | 1130703 | 2021-03-17 | Clay | Tennessee | 47027 | 1073 | 31 |
1127456 | 1127456 | 2021-03-16 | Clay | Tennessee | 47027 | 1073 | 31 |
1124210 | 1124210 | 2021-03-15 | Clay | Tennessee | 47027 | 1073 | 31 |
1120964 | 1120964 | 2021-03-14 | Clay | Tennessee | 47027 | 1073 | 31 |
1117717 | 1117717 | 2021-03-13 | Clay | Tennessee | 47027 | 1073 | 31 |
1114470 | 1114470 | 2021-03-12 | Clay | Tennessee | 47027 | 1073 | 31 |
1111224 | 1111224 | 2021-03-11 | Clay | Tennessee | 47027 | 1073 | 31 |
1107978 | 1107978 | 2021-03-10 | Clay | Tennessee | 47027 | 1072 | 31 |
1104732 | 1104732 | 2021-03-09 | Clay | Tennessee | 47027 | 1072 | 31 |
1101486 | 1101486 | 2021-03-08 | Clay | Tennessee | 47027 | 1072 | 31 |
1098240 | 1098240 | 2021-03-07 | Clay | Tennessee | 47027 | 1072 | 31 |
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);