ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Unicoi" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419740 | 1419740 | 2021-06-14 | Unicoi | Tennessee | 47171 | 2057 | 49 |
1416495 | 1416495 | 2021-06-13 | Unicoi | Tennessee | 47171 | 2057 | 49 |
1413249 | 1413249 | 2021-06-12 | Unicoi | Tennessee | 47171 | 2057 | 49 |
1410004 | 1410004 | 2021-06-11 | Unicoi | Tennessee | 47171 | 2057 | 49 |
1406759 | 1406759 | 2021-06-10 | Unicoi | Tennessee | 47171 | 2054 | 49 |
1403513 | 1403513 | 2021-06-09 | Unicoi | Tennessee | 47171 | 2055 | 49 |
1400268 | 1400268 | 2021-06-08 | Unicoi | Tennessee | 47171 | 2055 | 49 |
1397023 | 1397023 | 2021-06-07 | Unicoi | Tennessee | 47171 | 2055 | 49 |
1393776 | 1393776 | 2021-06-06 | Unicoi | Tennessee | 47171 | 2052 | 49 |
1390531 | 1390531 | 2021-06-05 | Unicoi | Tennessee | 47171 | 2052 | 49 |
1387286 | 1387286 | 2021-06-04 | Unicoi | Tennessee | 47171 | 2052 | 49 |
1384041 | 1384041 | 2021-06-03 | Unicoi | Tennessee | 47171 | 2050 | 49 |
1380795 | 1380795 | 2021-06-02 | Unicoi | Tennessee | 47171 | 2050 | 49 |
1377550 | 1377550 | 2021-06-01 | Unicoi | Tennessee | 47171 | 2051 | 49 |
1374304 | 1374304 | 2021-05-31 | Unicoi | Tennessee | 47171 | 2049 | 49 |
1371059 | 1371059 | 2021-05-30 | Unicoi | Tennessee | 47171 | 2049 | 49 |
1367813 | 1367813 | 2021-05-29 | Unicoi | Tennessee | 47171 | 2049 | 49 |
1364567 | 1364567 | 2021-05-28 | Unicoi | Tennessee | 47171 | 2049 | 49 |
1361321 | 1361321 | 2021-05-27 | Unicoi | Tennessee | 47171 | 2050 | 49 |
1358075 | 1358075 | 2021-05-26 | Unicoi | Tennessee | 47171 | 2051 | 49 |
1354829 | 1354829 | 2021-05-25 | Unicoi | Tennessee | 47171 | 2050 | 49 |
1351583 | 1351583 | 2021-05-24 | Unicoi | Tennessee | 47171 | 2051 | 49 |
1348337 | 1348337 | 2021-05-23 | Unicoi | Tennessee | 47171 | 2050 | 49 |
1345089 | 1345089 | 2021-05-22 | Unicoi | Tennessee | 47171 | 2050 | 49 |
1341841 | 1341841 | 2021-05-21 | Unicoi | Tennessee | 47171 | 2050 | 49 |
1338593 | 1338593 | 2021-05-20 | Unicoi | Tennessee | 47171 | 2047 | 49 |
1335346 | 1335346 | 2021-05-19 | Unicoi | Tennessee | 47171 | 2047 | 49 |
1332099 | 1332099 | 2021-05-18 | Unicoi | Tennessee | 47171 | 2046 | 49 |
1328852 | 1328852 | 2021-05-17 | Unicoi | Tennessee | 47171 | 2044 | 49 |
1325606 | 1325606 | 2021-05-16 | Unicoi | Tennessee | 47171 | 2045 | 49 |
1322360 | 1322360 | 2021-05-15 | Unicoi | Tennessee | 47171 | 2045 | 49 |
1319114 | 1319114 | 2021-05-14 | Unicoi | Tennessee | 47171 | 2045 | 49 |
1315866 | 1315866 | 2021-05-13 | Unicoi | Tennessee | 47171 | 2045 | 49 |
1312620 | 1312620 | 2021-05-12 | Unicoi | Tennessee | 47171 | 2043 | 49 |
1309373 | 1309373 | 2021-05-11 | Unicoi | Tennessee | 47171 | 2042 | 49 |
1306127 | 1306127 | 2021-05-10 | Unicoi | Tennessee | 47171 | 2042 | 49 |
1302881 | 1302881 | 2021-05-09 | Unicoi | Tennessee | 47171 | 2035 | 49 |
1299634 | 1299634 | 2021-05-08 | Unicoi | Tennessee | 47171 | 2035 | 49 |
1296387 | 1296387 | 2021-05-07 | Unicoi | Tennessee | 47171 | 2035 | 49 |
1293141 | 1293141 | 2021-05-06 | Unicoi | Tennessee | 47171 | 2034 | 49 |
1289895 | 1289895 | 2021-05-05 | Unicoi | Tennessee | 47171 | 2025 | 49 |
1286649 | 1286649 | 2021-05-04 | Unicoi | Tennessee | 47171 | 2022 | 49 |
1283403 | 1283403 | 2021-05-03 | Unicoi | Tennessee | 47171 | 2020 | 49 |
1280156 | 1280156 | 2021-05-02 | Unicoi | Tennessee | 47171 | 2013 | 49 |
1276909 | 1276909 | 2021-05-01 | Unicoi | Tennessee | 47171 | 2013 | 49 |
1273662 | 1273662 | 2021-04-30 | Unicoi | Tennessee | 47171 | 2013 | 49 |
1270415 | 1270415 | 2021-04-29 | Unicoi | Tennessee | 47171 | 2009 | 49 |
1267168 | 1267168 | 2021-04-28 | Unicoi | Tennessee | 47171 | 1998 | 49 |
1263921 | 1263921 | 2021-04-27 | Unicoi | Tennessee | 47171 | 1992 | 49 |
1260674 | 1260674 | 2021-04-26 | Unicoi | Tennessee | 47171 | 1982 | 49 |
1257427 | 1257427 | 2021-04-25 | Unicoi | Tennessee | 47171 | 1975 | 49 |
1254180 | 1254180 | 2021-04-24 | Unicoi | Tennessee | 47171 | 1975 | 49 |
1250933 | 1250933 | 2021-04-23 | Unicoi | Tennessee | 47171 | 1975 | 49 |
1247686 | 1247686 | 2021-04-22 | Unicoi | Tennessee | 47171 | 1968 | 49 |
1244439 | 1244439 | 2021-04-21 | Unicoi | Tennessee | 47171 | 1952 | 49 |
1241192 | 1241192 | 2021-04-20 | Unicoi | Tennessee | 47171 | 1948 | 49 |
1237945 | 1237945 | 2021-04-19 | Unicoi | Tennessee | 47171 | 1945 | 49 |
1234698 | 1234698 | 2021-04-18 | Unicoi | Tennessee | 47171 | 1941 | 49 |
1231450 | 1231450 | 2021-04-17 | Unicoi | Tennessee | 47171 | 1941 | 49 |
1228202 | 1228202 | 2021-04-16 | Unicoi | Tennessee | 47171 | 1941 | 49 |
1224954 | 1224954 | 2021-04-15 | Unicoi | Tennessee | 47171 | 1940 | 49 |
1221707 | 1221707 | 2021-04-14 | Unicoi | Tennessee | 47171 | 1932 | 49 |
1218459 | 1218459 | 2021-04-13 | Unicoi | Tennessee | 47171 | 1928 | 49 |
1215211 | 1215211 | 2021-04-12 | Unicoi | Tennessee | 47171 | 1923 | 49 |
1211964 | 1211964 | 2021-04-11 | Unicoi | Tennessee | 47171 | 1911 | 49 |
1208715 | 1208715 | 2021-04-10 | Unicoi | Tennessee | 47171 | 1911 | 49 |
1205467 | 1205467 | 2021-04-09 | Unicoi | Tennessee | 47171 | 1911 | 49 |
1202219 | 1202219 | 2021-04-08 | Unicoi | Tennessee | 47171 | 1906 | 49 |
1198970 | 1198970 | 2021-04-07 | Unicoi | Tennessee | 47171 | 1899 | 49 |
1195721 | 1195721 | 2021-04-06 | Unicoi | Tennessee | 47171 | 1895 | 49 |
1192473 | 1192473 | 2021-04-05 | Unicoi | Tennessee | 47171 | 1888 | 49 |
1189224 | 1189224 | 2021-04-04 | Unicoi | Tennessee | 47171 | 1879 | 49 |
1185977 | 1185977 | 2021-04-03 | Unicoi | Tennessee | 47171 | 1879 | 49 |
1182730 | 1182730 | 2021-04-02 | Unicoi | Tennessee | 47171 | 1879 | 49 |
1179483 | 1179483 | 2021-04-01 | Unicoi | Tennessee | 47171 | 1879 | 49 |
1176236 | 1176236 | 2021-03-31 | Unicoi | Tennessee | 47171 | 1874 | 49 |
1172989 | 1172989 | 2021-03-30 | Unicoi | Tennessee | 47171 | 1874 | 49 |
1169742 | 1169742 | 2021-03-29 | Unicoi | Tennessee | 47171 | 1874 | 49 |
1166494 | 1166494 | 2021-03-28 | Unicoi | Tennessee | 47171 | 1871 | 49 |
1163246 | 1163246 | 2021-03-27 | Unicoi | Tennessee | 47171 | 1871 | 49 |
1159997 | 1159997 | 2021-03-26 | Unicoi | Tennessee | 47171 | 1871 | 49 |
1156750 | 1156750 | 2021-03-25 | Unicoi | Tennessee | 47171 | 1865 | 49 |
1153503 | 1153503 | 2021-03-24 | Unicoi | Tennessee | 47171 | 1861 | 49 |
1150256 | 1150256 | 2021-03-23 | Unicoi | Tennessee | 47171 | 1859 | 48 |
1147009 | 1147009 | 2021-03-22 | Unicoi | Tennessee | 47171 | 1857 | 47 |
1143762 | 1143762 | 2021-03-21 | Unicoi | Tennessee | 47171 | 1849 | 47 |
1140515 | 1140515 | 2021-03-20 | Unicoi | Tennessee | 47171 | 1849 | 47 |
1137269 | 1137269 | 2021-03-19 | Unicoi | Tennessee | 47171 | 1849 | 47 |
1134023 | 1134023 | 2021-03-18 | Unicoi | Tennessee | 47171 | 1847 | 47 |
1130775 | 1130775 | 2021-03-17 | Unicoi | Tennessee | 47171 | 1841 | 47 |
1127528 | 1127528 | 2021-03-16 | Unicoi | Tennessee | 47171 | 1835 | 47 |
1124282 | 1124282 | 2021-03-15 | Unicoi | Tennessee | 47171 | 1834 | 47 |
1121036 | 1121036 | 2021-03-14 | Unicoi | Tennessee | 47171 | 1829 | 47 |
1117789 | 1117789 | 2021-03-13 | Unicoi | Tennessee | 47171 | 1829 | 47 |
1114542 | 1114542 | 2021-03-12 | Unicoi | Tennessee | 47171 | 1829 | 47 |
1111296 | 1111296 | 2021-03-11 | Unicoi | Tennessee | 47171 | 1827 | 47 |
1108050 | 1108050 | 2021-03-10 | Unicoi | Tennessee | 47171 | 1823 | 47 |
1104804 | 1104804 | 2021-03-09 | Unicoi | Tennessee | 47171 | 1824 | 47 |
1101558 | 1101558 | 2021-03-08 | Unicoi | Tennessee | 47171 | 1824 | 47 |
1098312 | 1098312 | 2021-03-07 | Unicoi | Tennessee | 47171 | 1822 | 47 |
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);