ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Monroe" and fips = 47123 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176788 | 2176788 | 2022-02-02 | Monroe | Tennessee | 47123 | 13183 | 206 |
2173534 | 2173534 | 2022-02-01 | Monroe | Tennessee | 47123 | 12335 | 203 |
2170282 | 2170282 | 2022-01-31 | Monroe | Tennessee | 47123 | 12335 | 203 |
2167028 | 2167028 | 2022-01-30 | Monroe | Tennessee | 47123 | 12335 | 203 |
2163773 | 2163773 | 2022-01-29 | Monroe | Tennessee | 47123 | 12335 | 203 |
2160518 | 2160518 | 2022-01-28 | Monroe | Tennessee | 47123 | 12335 | 203 |
2157262 | 2157262 | 2022-01-27 | Monroe | Tennessee | 47123 | 12335 | 203 |
2154009 | 2154009 | 2022-01-26 | Monroe | Tennessee | 47123 | 12335 | 203 |
2150757 | 2150757 | 2022-01-25 | Monroe | Tennessee | 47123 | 11433 | 201 |
2147505 | 2147505 | 2022-01-24 | Monroe | Tennessee | 47123 | 11433 | 201 |
2144251 | 2144251 | 2022-01-23 | Monroe | Tennessee | 47123 | 11433 | 201 |
2140996 | 2140996 | 2022-01-22 | Monroe | Tennessee | 47123 | 11433 | 201 |
2137740 | 2137740 | 2022-01-21 | Monroe | Tennessee | 47123 | 11433 | 201 |
2134486 | 2134486 | 2022-01-20 | Monroe | Tennessee | 47123 | 11433 | 201 |
2131234 | 2131234 | 2022-01-19 | Monroe | Tennessee | 47123 | 11433 | 201 |
2127980 | 2127980 | 2022-01-18 | Monroe | Tennessee | 47123 | 10755 | 196 |
2124728 | 2124728 | 2022-01-17 | Monroe | Tennessee | 47123 | 10755 | 196 |
2121476 | 2121476 | 2022-01-16 | Monroe | Tennessee | 47123 | 10755 | 196 |
2118224 | 2118224 | 2022-01-15 | Monroe | Tennessee | 47123 | 10755 | 196 |
2114973 | 2114973 | 2022-01-14 | Monroe | Tennessee | 47123 | 10755 | 196 |
2111721 | 2111721 | 2022-01-13 | Monroe | Tennessee | 47123 | 10755 | 196 |
2108469 | 2108469 | 2022-01-12 | Monroe | Tennessee | 47123 | 10755 | 196 |
2105218 | 2105218 | 2022-01-11 | Monroe | Tennessee | 47123 | 10467 | 196 |
2101967 | 2101967 | 2022-01-10 | Monroe | Tennessee | 47123 | 10467 | 196 |
2098716 | 2098716 | 2022-01-09 | Monroe | Tennessee | 47123 | 10467 | 196 |
2095464 | 2095464 | 2022-01-08 | Monroe | Tennessee | 47123 | 10467 | 196 |
2092212 | 2092212 | 2022-01-07 | Monroe | Tennessee | 47123 | 10467 | 196 |
2088960 | 2088960 | 2022-01-06 | Monroe | Tennessee | 47123 | 10467 | 196 |
2085709 | 2085709 | 2022-01-05 | Monroe | Tennessee | 47123 | 10467 | 196 |
2082457 | 2082457 | 2022-01-04 | Monroe | Tennessee | 47123 | 10467 | 196 |
2079205 | 2079205 | 2022-01-03 | Monroe | Tennessee | 47123 | 10428 | 196 |
2075954 | 2075954 | 2022-01-02 | Monroe | Tennessee | 47123 | 10353 | 196 |
2072703 | 2072703 | 2022-01-01 | Monroe | Tennessee | 47123 | 10353 | 196 |
2069452 | 2069452 | 2021-12-31 | Monroe | Tennessee | 47123 | 10353 | 196 |
2066201 | 2066201 | 2021-12-30 | Monroe | Tennessee | 47123 | 10353 | 196 |
2062951 | 2062951 | 2021-12-29 | Monroe | Tennessee | 47123 | 10324 | 195 |
2059701 | 2059701 | 2021-12-28 | Monroe | Tennessee | 47123 | 10290 | 194 |
2056452 | 2056452 | 2021-12-27 | Monroe | Tennessee | 47123 | 10261 | 193 |
2053203 | 2053203 | 2021-12-26 | Monroe | Tennessee | 47123 | 10237 | 191 |
2049953 | 2049953 | 2021-12-25 | Monroe | Tennessee | 47123 | 10237 | 191 |
2046703 | 2046703 | 2021-12-24 | Monroe | Tennessee | 47123 | 10237 | 191 |
2043453 | 2043453 | 2021-12-23 | Monroe | Tennessee | 47123 | 10237 | 191 |
2040204 | 2040204 | 2021-12-22 | Monroe | Tennessee | 47123 | 10206 | 153 |
2036954 | 2036954 | 2021-12-21 | Monroe | Tennessee | 47123 | 10183 | 145 |
2033704 | 2033704 | 2021-12-20 | Monroe | Tennessee | 47123 | 10171 | 144 |
2030454 | 2030454 | 2021-12-19 | Monroe | Tennessee | 47123 | 10154 | 144 |
2027203 | 2027203 | 2021-12-18 | Monroe | Tennessee | 47123 | 10154 | 144 |
2023952 | 2023952 | 2021-12-17 | Monroe | Tennessee | 47123 | 10154 | 144 |
2020701 | 2020701 | 2021-12-16 | Monroe | Tennessee | 47123 | 10141 | 142 |
2017450 | 2017450 | 2021-12-15 | Monroe | Tennessee | 47123 | 10135 | 142 |
2014200 | 2014200 | 2021-12-14 | Monroe | Tennessee | 47123 | 10125 | 141 |
2010949 | 2010949 | 2021-12-13 | Monroe | Tennessee | 47123 | 10110 | 140 |
2007698 | 2007698 | 2021-12-12 | Monroe | Tennessee | 47123 | 10088 | 140 |
2004447 | 2004447 | 2021-12-11 | Monroe | Tennessee | 47123 | 10088 | 140 |
2001196 | 2001196 | 2021-12-10 | Monroe | Tennessee | 47123 | 10088 | 140 |
1997946 | 1997946 | 2021-12-09 | Monroe | Tennessee | 47123 | 10062 | 140 |
1994695 | 1994695 | 2021-12-08 | Monroe | Tennessee | 47123 | 10062 | 140 |
1991444 | 1991444 | 2021-12-07 | Monroe | Tennessee | 47123 | 10037 | 140 |
1988193 | 1988193 | 2021-12-06 | Monroe | Tennessee | 47123 | 10020 | 140 |
1984943 | 1984943 | 2021-12-05 | Monroe | Tennessee | 47123 | 9987 | 139 |
1981693 | 1981693 | 2021-12-04 | Monroe | Tennessee | 47123 | 9987 | 139 |
1978443 | 1978443 | 2021-12-03 | Monroe | Tennessee | 47123 | 9987 | 139 |
1975193 | 1975193 | 2021-12-02 | Monroe | Tennessee | 47123 | 9978 | 134 |
1971944 | 1971944 | 2021-12-01 | Monroe | Tennessee | 47123 | 9971 | 133 |
1968694 | 1968694 | 2021-11-30 | Monroe | Tennessee | 47123 | 9958 | 129 |
1965443 | 1965443 | 2021-11-29 | Monroe | Tennessee | 47123 | 9942 | 129 |
1962191 | 1962191 | 2021-11-28 | Monroe | Tennessee | 47123 | 9915 | 128 |
1958940 | 1958940 | 2021-11-27 | Monroe | Tennessee | 47123 | 9915 | 128 |
1955689 | 1955689 | 2021-11-26 | Monroe | Tennessee | 47123 | 9915 | 128 |
1952438 | 1952438 | 2021-11-25 | Monroe | Tennessee | 47123 | 9915 | 128 |
1949187 | 1949187 | 2021-11-24 | Monroe | Tennessee | 47123 | 9915 | 128 |
1945936 | 1945936 | 2021-11-23 | Monroe | Tennessee | 47123 | 9911 | 128 |
1942685 | 1942685 | 2021-11-22 | Monroe | Tennessee | 47123 | 9900 | 127 |
1939435 | 1939435 | 2021-11-21 | Monroe | Tennessee | 47123 | 9875 | 126 |
1936185 | 1936185 | 2021-11-20 | Monroe | Tennessee | 47123 | 9875 | 126 |
1932935 | 1932935 | 2021-11-19 | Monroe | Tennessee | 47123 | 9875 | 126 |
1929684 | 1929684 | 2021-11-18 | Monroe | Tennessee | 47123 | 9870 | 126 |
1926434 | 1926434 | 2021-11-17 | Monroe | Tennessee | 47123 | 9857 | 126 |
1923184 | 1923184 | 2021-11-16 | Monroe | Tennessee | 47123 | 9851 | 126 |
1919935 | 1919935 | 2021-11-15 | Monroe | Tennessee | 47123 | 9844 | 126 |
1916685 | 1916685 | 2021-11-14 | Monroe | Tennessee | 47123 | 9825 | 126 |
1913435 | 1913435 | 2021-11-13 | Monroe | Tennessee | 47123 | 9825 | 126 |
1910185 | 1910185 | 2021-11-12 | Monroe | Tennessee | 47123 | 9825 | 126 |
1906936 | 1906936 | 2021-11-11 | Monroe | Tennessee | 47123 | 9812 | 126 |
1903687 | 1903687 | 2021-11-10 | Monroe | Tennessee | 47123 | 9812 | 126 |
1900437 | 1900437 | 2021-11-09 | Monroe | Tennessee | 47123 | 9787 | 126 |
1897187 | 1897187 | 2021-11-08 | Monroe | Tennessee | 47123 | 9762 | 125 |
1893937 | 1893937 | 2021-11-07 | Monroe | Tennessee | 47123 | 9762 | 125 |
1890687 | 1890687 | 2021-11-06 | Monroe | Tennessee | 47123 | 9762 | 125 |
1887437 | 1887437 | 2021-11-05 | Monroe | Tennessee | 47123 | 9762 | 125 |
1884187 | 1884187 | 2021-11-04 | Monroe | Tennessee | 47123 | 9758 | 124 |
1880938 | 1880938 | 2021-11-03 | Monroe | Tennessee | 47123 | 9753 | 124 |
1877689 | 1877689 | 2021-11-02 | Monroe | Tennessee | 47123 | 9744 | 124 |
1874440 | 1874440 | 2021-11-01 | Monroe | Tennessee | 47123 | 9715 | 124 |
1871191 | 1871191 | 2021-10-31 | Monroe | Tennessee | 47123 | 9715 | 124 |
1867942 | 1867942 | 2021-10-30 | Monroe | Tennessee | 47123 | 9715 | 124 |
1864693 | 1864693 | 2021-10-29 | Monroe | Tennessee | 47123 | 9715 | 124 |
1861444 | 1861444 | 2021-10-28 | Monroe | Tennessee | 47123 | 9711 | 123 |
1858195 | 1858195 | 2021-10-27 | Monroe | Tennessee | 47123 | 9704 | 122 |
1854946 | 1854946 | 2021-10-26 | Monroe | Tennessee | 47123 | 9694 | 122 |
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);