ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 47157 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176805 | 2176805 | 2022-02-02 | Shelby | Tennessee | 47157 | 225074 | 2935 |
2173551 | 2173551 | 2022-02-01 | Shelby | Tennessee | 47157 | 221671 | 2920 |
2170299 | 2170299 | 2022-01-31 | Shelby | Tennessee | 47157 | 221197 | 2915 |
2167045 | 2167045 | 2022-01-30 | Shelby | Tennessee | 47157 | 220482 | 2915 |
2163790 | 2163790 | 2022-01-29 | Shelby | Tennessee | 47157 | 219606 | 2903 |
2160535 | 2160535 | 2022-01-28 | Shelby | Tennessee | 47157 | 218534 | 2899 |
2157279 | 2157279 | 2022-01-27 | Shelby | Tennessee | 47157 | 217582 | 2885 |
2154026 | 2154026 | 2022-01-26 | Shelby | Tennessee | 47157 | 217582 | 2880 |
2150774 | 2150774 | 2022-01-25 | Shelby | Tennessee | 47157 | 215182 | 2863 |
2147522 | 2147522 | 2022-01-24 | Shelby | Tennessee | 47157 | 214302 | 2862 |
2144268 | 2144268 | 2022-01-23 | Shelby | Tennessee | 47157 | 213307 | 2862 |
2141013 | 2141013 | 2022-01-22 | Shelby | Tennessee | 47157 | 211884 | 2845 |
2137757 | 2137757 | 2022-01-21 | Shelby | Tennessee | 47157 | 210302 | 2827 |
2134503 | 2134503 | 2022-01-20 | Shelby | Tennessee | 47157 | 208357 | 2822 |
2131251 | 2131251 | 2022-01-19 | Shelby | Tennessee | 47157 | 207298 | 2822 |
2127997 | 2127997 | 2022-01-18 | Shelby | Tennessee | 47157 | 205793 | 2808 |
2124745 | 2124745 | 2022-01-17 | Shelby | Tennessee | 47157 | 204741 | 2808 |
2121493 | 2121493 | 2022-01-16 | Shelby | Tennessee | 47157 | 203128 | 2804 |
2118241 | 2118241 | 2022-01-15 | Shelby | Tennessee | 47157 | 201072 | 2781 |
2114990 | 2114990 | 2022-01-14 | Shelby | Tennessee | 47157 | 198837 | 2752 |
2111738 | 2111738 | 2022-01-13 | Shelby | Tennessee | 47157 | 196464 | 2734 |
2108486 | 2108486 | 2022-01-12 | Shelby | Tennessee | 47157 | 193915 | 2731 |
2105235 | 2105235 | 2022-01-11 | Shelby | Tennessee | 47157 | 192434 | 2719 |
2101984 | 2101984 | 2022-01-10 | Shelby | Tennessee | 47157 | 191089 | 2719 |
2098733 | 2098733 | 2022-01-09 | Shelby | Tennessee | 47157 | 188762 | 2719 |
2095481 | 2095481 | 2022-01-08 | Shelby | Tennessee | 47157 | 186005 | 2716 |
2092229 | 2092229 | 2022-01-07 | Shelby | Tennessee | 47157 | 183392 | 2715 |
2088977 | 2088977 | 2022-01-06 | Shelby | Tennessee | 47157 | 180331 | 2715 |
2085726 | 2085726 | 2022-01-05 | Shelby | Tennessee | 47157 | 178126 | 2715 |
2082474 | 2082474 | 2022-01-04 | Shelby | Tennessee | 47157 | 178126 | 2715 |
2079222 | 2079222 | 2022-01-03 | Shelby | Tennessee | 47157 | 176310 | 2710 |
2075971 | 2075971 | 2022-01-02 | Shelby | Tennessee | 47157 | 172627 | 2708 |
2072720 | 2072720 | 2022-01-01 | Shelby | Tennessee | 47157 | 169233 | 2708 |
2069469 | 2069469 | 2021-12-31 | Shelby | Tennessee | 47157 | 166471 | 2708 |
2066218 | 2066218 | 2021-12-30 | Shelby | Tennessee | 47157 | 165757 | 2708 |
2062968 | 2062968 | 2021-12-29 | Shelby | Tennessee | 47157 | 162589 | 2705 |
2059718 | 2059718 | 2021-12-28 | Shelby | Tennessee | 47157 | 160499 | 2698 |
2056469 | 2056469 | 2021-12-27 | Shelby | Tennessee | 47157 | 159425 | 2689 |
2053220 | 2053220 | 2021-12-26 | Shelby | Tennessee | 47157 | 156036 | 2663 |
2049970 | 2049970 | 2021-12-25 | Shelby | Tennessee | 47157 | 156036 | 2663 |
2046720 | 2046720 | 2021-12-24 | Shelby | Tennessee | 47157 | 156036 | 2663 |
2043470 | 2043470 | 2021-12-23 | Shelby | Tennessee | 47157 | 154748 | 2663 |
2040221 | 2040221 | 2021-12-22 | Shelby | Tennessee | 47157 | 153972 | 2449 |
2036971 | 2036971 | 2021-12-21 | Shelby | Tennessee | 47157 | 153551 | 2442 |
2033721 | 2033721 | 2021-12-20 | Shelby | Tennessee | 47157 | 153234 | 2435 |
2030471 | 2030471 | 2021-12-19 | Shelby | Tennessee | 47157 | 152854 | 2431 |
2027220 | 2027220 | 2021-12-18 | Shelby | Tennessee | 47157 | 152486 | 2431 |
2023969 | 2023969 | 2021-12-17 | Shelby | Tennessee | 47157 | 152083 | 2431 |
2020718 | 2020718 | 2021-12-16 | Shelby | Tennessee | 47157 | 151851 | 2430 |
2017467 | 2017467 | 2021-12-15 | Shelby | Tennessee | 47157 | 151586 | 2424 |
2014217 | 2014217 | 2021-12-14 | Shelby | Tennessee | 47157 | 151449 | 2416 |
2010966 | 2010966 | 2021-12-13 | Shelby | Tennessee | 47157 | 151365 | 2412 |
2007715 | 2007715 | 2021-12-12 | Shelby | Tennessee | 47157 | 151242 | 2409 |
2004464 | 2004464 | 2021-12-11 | Shelby | Tennessee | 47157 | 151071 | 2409 |
2001213 | 2001213 | 2021-12-10 | Shelby | Tennessee | 47157 | 150861 | 2409 |
1997963 | 1997963 | 2021-12-09 | Shelby | Tennessee | 47157 | 150604 | 2402 |
1994712 | 1994712 | 2021-12-08 | Shelby | Tennessee | 47157 | 150388 | 2402 |
1991461 | 1991461 | 2021-12-07 | Shelby | Tennessee | 47157 | 150249 | 2399 |
1988210 | 1988210 | 2021-12-06 | Shelby | Tennessee | 47157 | 150125 | 2387 |
1984960 | 1984960 | 2021-12-05 | Shelby | Tennessee | 47157 | 150018 | 2380 |
1981710 | 1981710 | 2021-12-04 | Shelby | Tennessee | 47157 | 149836 | 2380 |
1978460 | 1978460 | 2021-12-03 | Shelby | Tennessee | 47157 | 149836 | 2380 |
1975210 | 1975210 | 2021-12-02 | Shelby | Tennessee | 47157 | 149410 | 2363 |
1971961 | 1971961 | 2021-12-01 | Shelby | Tennessee | 47157 | 149234 | 2352 |
1968711 | 1968711 | 2021-11-30 | Shelby | Tennessee | 47157 | 149122 | 2334 |
1965460 | 1965460 | 2021-11-29 | Shelby | Tennessee | 47157 | 148806 | 2327 |
1962208 | 1962208 | 2021-11-28 | Shelby | Tennessee | 47157 | 148806 | 2327 |
1958957 | 1958957 | 2021-11-27 | Shelby | Tennessee | 47157 | 148806 | 2327 |
1955706 | 1955706 | 2021-11-26 | Shelby | Tennessee | 47157 | 148806 | 2327 |
1952455 | 1952455 | 2021-11-25 | Shelby | Tennessee | 47157 | 148680 | 2327 |
1949204 | 1949204 | 2021-11-24 | Shelby | Tennessee | 47157 | 148549 | 2327 |
1945953 | 1945953 | 2021-11-23 | Shelby | Tennessee | 47157 | 148444 | 2321 |
1942702 | 1942702 | 2021-11-22 | Shelby | Tennessee | 47157 | 148387 | 2312 |
1939452 | 1939452 | 2021-11-21 | Shelby | Tennessee | 47157 | 148317 | 2307 |
1936202 | 1936202 | 2021-11-20 | Shelby | Tennessee | 47157 | 148192 | 2307 |
1932952 | 1932952 | 2021-11-19 | Shelby | Tennessee | 47157 | 148028 | 2307 |
1929701 | 1929701 | 2021-11-18 | Shelby | Tennessee | 47157 | 147796 | 2307 |
1926451 | 1926451 | 2021-11-17 | Shelby | Tennessee | 47157 | 147659 | 2307 |
1923201 | 1923201 | 2021-11-16 | Shelby | Tennessee | 47157 | 147557 | 2305 |
1919952 | 1919952 | 2021-11-15 | Shelby | Tennessee | 47157 | 147486 | 2298 |
1916702 | 1916702 | 2021-11-14 | Shelby | Tennessee | 47157 | 147417 | 2298 |
1913452 | 1913452 | 2021-11-13 | Shelby | Tennessee | 47157 | 147284 | 2298 |
1910202 | 1910202 | 2021-11-12 | Shelby | Tennessee | 47157 | 147284 | 2298 |
1906953 | 1906953 | 2021-11-11 | Shelby | Tennessee | 47157 | 147025 | 2291 |
1903704 | 1903704 | 2021-11-10 | Shelby | Tennessee | 47157 | 146814 | 2291 |
1900454 | 1900454 | 2021-11-09 | Shelby | Tennessee | 47157 | 146718 | 2288 |
1897204 | 1897204 | 2021-11-08 | Shelby | Tennessee | 47157 | 146636 | 2276 |
1893954 | 1893954 | 2021-11-07 | Shelby | Tennessee | 47157 | 146579 | 2276 |
1890704 | 1890704 | 2021-11-06 | Shelby | Tennessee | 47157 | 146472 | 2276 |
1887454 | 1887454 | 2021-11-05 | Shelby | Tennessee | 47157 | 146403 | 2276 |
1884204 | 1884204 | 2021-11-04 | Shelby | Tennessee | 47157 | 146296 | 2273 |
1880955 | 1880955 | 2021-11-03 | Shelby | Tennessee | 47157 | 146212 | 2269 |
1877706 | 1877706 | 2021-11-02 | Shelby | Tennessee | 47157 | 146101 | 2267 |
1874457 | 1874457 | 2021-11-01 | Shelby | Tennessee | 47157 | 146061 | 2256 |
1871208 | 1871208 | 2021-10-31 | Shelby | Tennessee | 47157 | 146005 | 2256 |
1867959 | 1867959 | 2021-10-30 | Shelby | Tennessee | 47157 | 145918 | 2256 |
1864710 | 1864710 | 2021-10-29 | Shelby | Tennessee | 47157 | 145832 | 2256 |
1861461 | 1861461 | 2021-10-28 | Shelby | Tennessee | 47157 | 145710 | 2255 |
1858212 | 1858212 | 2021-10-27 | Shelby | Tennessee | 47157 | 145601 | 2246 |
1854963 | 1854963 | 2021-10-26 | Shelby | Tennessee | 47157 | 145523 | 2238 |
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);