ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
734 rows where county = "Pickett" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111728 | 2111728 | 2022-01-13 | Pickett | Tennessee | 47137 | 1222 | 28 |
2108476 | 2108476 | 2022-01-12 | Pickett | Tennessee | 47137 | 1222 | 28 |
2105225 | 2105225 | 2022-01-11 | Pickett | Tennessee | 47137 | 1190 | 28 |
2101974 | 2101974 | 2022-01-10 | Pickett | Tennessee | 47137 | 1190 | 28 |
2098723 | 2098723 | 2022-01-09 | Pickett | Tennessee | 47137 | 1190 | 28 |
2095471 | 2095471 | 2022-01-08 | Pickett | Tennessee | 47137 | 1190 | 28 |
2092219 | 2092219 | 2022-01-07 | Pickett | Tennessee | 47137 | 1190 | 28 |
2088967 | 2088967 | 2022-01-06 | Pickett | Tennessee | 47137 | 1190 | 28 |
2085716 | 2085716 | 2022-01-05 | Pickett | Tennessee | 47137 | 1190 | 28 |
2082464 | 2082464 | 2022-01-04 | Pickett | Tennessee | 47137 | 1190 | 28 |
2079212 | 2079212 | 2022-01-03 | Pickett | Tennessee | 47137 | 1183 | 28 |
2075961 | 2075961 | 2022-01-02 | Pickett | Tennessee | 47137 | 1168 | 28 |
2072710 | 2072710 | 2022-01-01 | Pickett | Tennessee | 47137 | 1168 | 28 |
2069459 | 2069459 | 2021-12-31 | Pickett | Tennessee | 47137 | 1168 | 28 |
2066208 | 2066208 | 2021-12-30 | Pickett | Tennessee | 47137 | 1168 | 28 |
2062958 | 2062958 | 2021-12-29 | Pickett | Tennessee | 47137 | 1162 | 28 |
2059708 | 2059708 | 2021-12-28 | Pickett | Tennessee | 47137 | 1159 | 28 |
2056459 | 2056459 | 2021-12-27 | Pickett | Tennessee | 47137 | 1154 | 28 |
2053210 | 2053210 | 2021-12-26 | Pickett | Tennessee | 47137 | 1150 | 28 |
2049960 | 2049960 | 2021-12-25 | Pickett | Tennessee | 47137 | 1150 | 28 |
2046710 | 2046710 | 2021-12-24 | Pickett | Tennessee | 47137 | 1150 | 28 |
2043460 | 2043460 | 2021-12-23 | Pickett | Tennessee | 47137 | 1150 | 28 |
2040211 | 2040211 | 2021-12-22 | Pickett | Tennessee | 47137 | 1147 | 26 |
2036961 | 2036961 | 2021-12-21 | Pickett | Tennessee | 47137 | 1146 | 26 |
2033711 | 2033711 | 2021-12-20 | Pickett | Tennessee | 47137 | 1146 | 26 |
2030461 | 2030461 | 2021-12-19 | Pickett | Tennessee | 47137 | 1144 | 26 |
2027210 | 2027210 | 2021-12-18 | Pickett | Tennessee | 47137 | 1144 | 26 |
2023959 | 2023959 | 2021-12-17 | Pickett | Tennessee | 47137 | 1144 | 26 |
2020708 | 2020708 | 2021-12-16 | Pickett | Tennessee | 47137 | 1142 | 26 |
2017457 | 2017457 | 2021-12-15 | Pickett | Tennessee | 47137 | 1141 | 26 |
2014207 | 2014207 | 2021-12-14 | Pickett | Tennessee | 47137 | 1136 | 26 |
2010956 | 2010956 | 2021-12-13 | Pickett | Tennessee | 47137 | 1136 | 26 |
2007705 | 2007705 | 2021-12-12 | Pickett | Tennessee | 47137 | 1135 | 26 |
2004454 | 2004454 | 2021-12-11 | Pickett | Tennessee | 47137 | 1135 | 26 |
2001203 | 2001203 | 2021-12-10 | Pickett | Tennessee | 47137 | 1135 | 26 |
1997953 | 1997953 | 2021-12-09 | Pickett | Tennessee | 47137 | 1135 | 26 |
1994702 | 1994702 | 2021-12-08 | Pickett | Tennessee | 47137 | 1135 | 26 |
1991451 | 1991451 | 2021-12-07 | Pickett | Tennessee | 47137 | 1131 | 26 |
1988200 | 1988200 | 2021-12-06 | Pickett | Tennessee | 47137 | 1130 | 26 |
1984950 | 1984950 | 2021-12-05 | Pickett | Tennessee | 47137 | 1129 | 26 |
1981700 | 1981700 | 2021-12-04 | Pickett | Tennessee | 47137 | 1129 | 26 |
1978450 | 1978450 | 2021-12-03 | Pickett | Tennessee | 47137 | 1129 | 26 |
1975200 | 1975200 | 2021-12-02 | Pickett | Tennessee | 47137 | 1128 | 26 |
1971951 | 1971951 | 2021-12-01 | Pickett | Tennessee | 47137 | 1127 | 26 |
1968701 | 1968701 | 2021-11-30 | Pickett | Tennessee | 47137 | 1123 | 26 |
1965450 | 1965450 | 2021-11-29 | Pickett | Tennessee | 47137 | 1122 | 26 |
1962198 | 1962198 | 2021-11-28 | Pickett | Tennessee | 47137 | 1121 | 26 |
1958947 | 1958947 | 2021-11-27 | Pickett | Tennessee | 47137 | 1121 | 26 |
1955696 | 1955696 | 2021-11-26 | Pickett | Tennessee | 47137 | 1121 | 26 |
1952445 | 1952445 | 2021-11-25 | Pickett | Tennessee | 47137 | 1121 | 26 |
1949194 | 1949194 | 2021-11-24 | Pickett | Tennessee | 47137 | 1121 | 26 |
1945943 | 1945943 | 2021-11-23 | Pickett | Tennessee | 47137 | 1121 | 25 |
1942692 | 1942692 | 2021-11-22 | Pickett | Tennessee | 47137 | 1116 | 25 |
1939442 | 1939442 | 2021-11-21 | Pickett | Tennessee | 47137 | 1111 | 25 |
1936192 | 1936192 | 2021-11-20 | Pickett | Tennessee | 47137 | 1111 | 25 |
1932942 | 1932942 | 2021-11-19 | Pickett | Tennessee | 47137 | 1111 | 25 |
1929691 | 1929691 | 2021-11-18 | Pickett | Tennessee | 47137 | 1108 | 25 |
1926441 | 1926441 | 2021-11-17 | Pickett | Tennessee | 47137 | 1106 | 25 |
1923191 | 1923191 | 2021-11-16 | Pickett | Tennessee | 47137 | 1102 | 24 |
1919942 | 1919942 | 2021-11-15 | Pickett | Tennessee | 47137 | 1100 | 24 |
1916692 | 1916692 | 2021-11-14 | Pickett | Tennessee | 47137 | 1099 | 24 |
1913442 | 1913442 | 2021-11-13 | Pickett | Tennessee | 47137 | 1099 | 24 |
1910192 | 1910192 | 2021-11-12 | Pickett | Tennessee | 47137 | 1099 | 24 |
1906943 | 1906943 | 2021-11-11 | Pickett | Tennessee | 47137 | 1091 | 24 |
1903694 | 1903694 | 2021-11-10 | Pickett | Tennessee | 47137 | 1091 | 24 |
1900444 | 1900444 | 2021-11-09 | Pickett | Tennessee | 47137 | 1090 | 24 |
1897194 | 1897194 | 2021-11-08 | Pickett | Tennessee | 47137 | 1089 | 24 |
1893944 | 1893944 | 2021-11-07 | Pickett | Tennessee | 47137 | 1089 | 24 |
1890694 | 1890694 | 2021-11-06 | Pickett | Tennessee | 47137 | 1089 | 24 |
1887444 | 1887444 | 2021-11-05 | Pickett | Tennessee | 47137 | 1089 | 24 |
1884194 | 1884194 | 2021-11-04 | Pickett | Tennessee | 47137 | 1088 | 24 |
1880945 | 1880945 | 2021-11-03 | Pickett | Tennessee | 47137 | 1087 | 24 |
1877696 | 1877696 | 2021-11-02 | Pickett | Tennessee | 47137 | 1087 | 24 |
1874447 | 1874447 | 2021-11-01 | Pickett | Tennessee | 47137 | 1087 | 24 |
1871198 | 1871198 | 2021-10-31 | Pickett | Tennessee | 47137 | 1087 | 24 |
1867949 | 1867949 | 2021-10-30 | Pickett | Tennessee | 47137 | 1087 | 24 |
1864700 | 1864700 | 2021-10-29 | Pickett | Tennessee | 47137 | 1087 | 24 |
1861451 | 1861451 | 2021-10-28 | Pickett | Tennessee | 47137 | 1087 | 24 |
1858202 | 1858202 | 2021-10-27 | Pickett | Tennessee | 47137 | 1086 | 24 |
1854953 | 1854953 | 2021-10-26 | Pickett | Tennessee | 47137 | 1085 | 24 |
1851704 | 1851704 | 2021-10-25 | Pickett | Tennessee | 47137 | 1080 | 24 |
1848454 | 1848454 | 2021-10-24 | Pickett | Tennessee | 47137 | 1080 | 24 |
1845204 | 1845204 | 2021-10-23 | Pickett | Tennessee | 47137 | 1080 | 24 |
1841954 | 1841954 | 2021-10-22 | Pickett | Tennessee | 47137 | 1080 | 24 |
1838705 | 1838705 | 2021-10-21 | Pickett | Tennessee | 47137 | 1076 | 24 |
1835456 | 1835456 | 2021-10-20 | Pickett | Tennessee | 47137 | 1074 | 24 |
1832207 | 1832207 | 2021-10-19 | Pickett | Tennessee | 47137 | 1071 | 24 |
1828958 | 1828958 | 2021-10-18 | Pickett | Tennessee | 47137 | 1070 | 24 |
1825709 | 1825709 | 2021-10-17 | Pickett | Tennessee | 47137 | 1069 | 24 |
1822460 | 1822460 | 2021-10-16 | Pickett | Tennessee | 47137 | 1069 | 24 |
1819211 | 1819211 | 2021-10-15 | Pickett | Tennessee | 47137 | 1069 | 24 |
1815962 | 1815962 | 2021-10-14 | Pickett | Tennessee | 47137 | 1069 | 24 |
1812714 | 1812714 | 2021-10-13 | Pickett | Tennessee | 47137 | 1065 | 24 |
1809465 | 1809465 | 2021-10-12 | Pickett | Tennessee | 47137 | 1064 | 24 |
1806215 | 1806215 | 2021-10-11 | Pickett | Tennessee | 47137 | 1060 | 24 |
1802965 | 1802965 | 2021-10-10 | Pickett | Tennessee | 47137 | 1050 | 24 |
1799716 | 1799716 | 2021-10-09 | Pickett | Tennessee | 47137 | 1050 | 24 |
1796467 | 1796467 | 2021-10-08 | Pickett | Tennessee | 47137 | 1050 | 24 |
1793218 | 1793218 | 2021-10-07 | Pickett | Tennessee | 47137 | 1046 | 24 |
1789969 | 1789969 | 2021-10-06 | Pickett | Tennessee | 47137 | 1045 | 24 |
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);