ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Lawrence" and fips = 47099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176776 | 2176776 | 2022-02-02 | Lawrence | Tennessee | 47099 | 13326 | 168 |
2173522 | 2173522 | 2022-02-01 | Lawrence | Tennessee | 47099 | 12472 | 166 |
2170270 | 2170270 | 2022-01-31 | Lawrence | Tennessee | 47099 | 12472 | 166 |
2167016 | 2167016 | 2022-01-30 | Lawrence | Tennessee | 47099 | 12472 | 166 |
2163761 | 2163761 | 2022-01-29 | Lawrence | Tennessee | 47099 | 12472 | 166 |
2160506 | 2160506 | 2022-01-28 | Lawrence | Tennessee | 47099 | 12472 | 166 |
2157250 | 2157250 | 2022-01-27 | Lawrence | Tennessee | 47099 | 12472 | 166 |
2153997 | 2153997 | 2022-01-26 | Lawrence | Tennessee | 47099 | 12472 | 166 |
2150745 | 2150745 | 2022-01-25 | Lawrence | Tennessee | 47099 | 11278 | 165 |
2147493 | 2147493 | 2022-01-24 | Lawrence | Tennessee | 47099 | 11278 | 165 |
2144239 | 2144239 | 2022-01-23 | Lawrence | Tennessee | 47099 | 11278 | 165 |
2140984 | 2140984 | 2022-01-22 | Lawrence | Tennessee | 47099 | 11278 | 165 |
2137728 | 2137728 | 2022-01-21 | Lawrence | Tennessee | 47099 | 11278 | 165 |
2134474 | 2134474 | 2022-01-20 | Lawrence | Tennessee | 47099 | 11278 | 165 |
2131222 | 2131222 | 2022-01-19 | Lawrence | Tennessee | 47099 | 11278 | 165 |
2127968 | 2127968 | 2022-01-18 | Lawrence | Tennessee | 47099 | 10645 | 160 |
2124716 | 2124716 | 2022-01-17 | Lawrence | Tennessee | 47099 | 10645 | 160 |
2121464 | 2121464 | 2022-01-16 | Lawrence | Tennessee | 47099 | 10645 | 160 |
2118212 | 2118212 | 2022-01-15 | Lawrence | Tennessee | 47099 | 10645 | 160 |
2114961 | 2114961 | 2022-01-14 | Lawrence | Tennessee | 47099 | 10645 | 160 |
2111709 | 2111709 | 2022-01-13 | Lawrence | Tennessee | 47099 | 10645 | 160 |
2108457 | 2108457 | 2022-01-12 | Lawrence | Tennessee | 47099 | 10645 | 160 |
2105206 | 2105206 | 2022-01-11 | Lawrence | Tennessee | 47099 | 10301 | 159 |
2101955 | 2101955 | 2022-01-10 | Lawrence | Tennessee | 47099 | 10301 | 159 |
2098704 | 2098704 | 2022-01-09 | Lawrence | Tennessee | 47099 | 10301 | 159 |
2095452 | 2095452 | 2022-01-08 | Lawrence | Tennessee | 47099 | 10301 | 159 |
2092200 | 2092200 | 2022-01-07 | Lawrence | Tennessee | 47099 | 10301 | 159 |
2088948 | 2088948 | 2022-01-06 | Lawrence | Tennessee | 47099 | 10301 | 159 |
2085697 | 2085697 | 2022-01-05 | Lawrence | Tennessee | 47099 | 10301 | 159 |
2082445 | 2082445 | 2022-01-04 | Lawrence | Tennessee | 47099 | 10301 | 159 |
2079193 | 2079193 | 2022-01-03 | Lawrence | Tennessee | 47099 | 10268 | 159 |
2075942 | 2075942 | 2022-01-02 | Lawrence | Tennessee | 47099 | 10163 | 158 |
2072691 | 2072691 | 2022-01-01 | Lawrence | Tennessee | 47099 | 10163 | 158 |
2069440 | 2069440 | 2021-12-31 | Lawrence | Tennessee | 47099 | 10163 | 158 |
2066189 | 2066189 | 2021-12-30 | Lawrence | Tennessee | 47099 | 10163 | 158 |
2062939 | 2062939 | 2021-12-29 | Lawrence | Tennessee | 47099 | 10118 | 157 |
2059689 | 2059689 | 2021-12-28 | Lawrence | Tennessee | 47099 | 10085 | 157 |
2056440 | 2056440 | 2021-12-27 | Lawrence | Tennessee | 47099 | 10036 | 157 |
2053191 | 2053191 | 2021-12-26 | Lawrence | Tennessee | 47099 | 10005 | 157 |
2049941 | 2049941 | 2021-12-25 | Lawrence | Tennessee | 47099 | 10005 | 157 |
2046691 | 2046691 | 2021-12-24 | Lawrence | Tennessee | 47099 | 10005 | 157 |
2043441 | 2043441 | 2021-12-23 | Lawrence | Tennessee | 47099 | 10005 | 157 |
2040192 | 2040192 | 2021-12-22 | Lawrence | Tennessee | 47099 | 9983 | 135 |
2036942 | 2036942 | 2021-12-21 | Lawrence | Tennessee | 47099 | 9966 | 135 |
2033692 | 2033692 | 2021-12-20 | Lawrence | Tennessee | 47099 | 9943 | 135 |
2030442 | 2030442 | 2021-12-19 | Lawrence | Tennessee | 47099 | 9926 | 135 |
2027191 | 2027191 | 2021-12-18 | Lawrence | Tennessee | 47099 | 9926 | 135 |
2023940 | 2023940 | 2021-12-17 | Lawrence | Tennessee | 47099 | 9926 | 135 |
2020689 | 2020689 | 2021-12-16 | Lawrence | Tennessee | 47099 | 9911 | 134 |
2017438 | 2017438 | 2021-12-15 | Lawrence | Tennessee | 47099 | 9905 | 134 |
2014188 | 2014188 | 2021-12-14 | Lawrence | Tennessee | 47099 | 9902 | 134 |
2010937 | 2010937 | 2021-12-13 | Lawrence | Tennessee | 47099 | 9891 | 134 |
2007686 | 2007686 | 2021-12-12 | Lawrence | Tennessee | 47099 | 9865 | 134 |
2004435 | 2004435 | 2021-12-11 | Lawrence | Tennessee | 47099 | 9865 | 134 |
2001184 | 2001184 | 2021-12-10 | Lawrence | Tennessee | 47099 | 9865 | 134 |
1997934 | 1997934 | 2021-12-09 | Lawrence | Tennessee | 47099 | 9844 | 133 |
1994683 | 1994683 | 2021-12-08 | Lawrence | Tennessee | 47099 | 9844 | 133 |
1991432 | 1991432 | 2021-12-07 | Lawrence | Tennessee | 47099 | 9837 | 131 |
1988181 | 1988181 | 2021-12-06 | Lawrence | Tennessee | 47099 | 9815 | 131 |
1984931 | 1984931 | 2021-12-05 | Lawrence | Tennessee | 47099 | 9790 | 131 |
1981681 | 1981681 | 2021-12-04 | Lawrence | Tennessee | 47099 | 9790 | 131 |
1978431 | 1978431 | 2021-12-03 | Lawrence | Tennessee | 47099 | 9790 | 131 |
1975181 | 1975181 | 2021-12-02 | Lawrence | Tennessee | 47099 | 9778 | 130 |
1971932 | 1971932 | 2021-12-01 | Lawrence | Tennessee | 47099 | 9771 | 130 |
1968682 | 1968682 | 2021-11-30 | Lawrence | Tennessee | 47099 | 9763 | 128 |
1965431 | 1965431 | 2021-11-29 | Lawrence | Tennessee | 47099 | 9754 | 127 |
1962179 | 1962179 | 2021-11-28 | Lawrence | Tennessee | 47099 | 9733 | 127 |
1958928 | 1958928 | 2021-11-27 | Lawrence | Tennessee | 47099 | 9733 | 127 |
1955677 | 1955677 | 2021-11-26 | Lawrence | Tennessee | 47099 | 9733 | 127 |
1952426 | 1952426 | 2021-11-25 | Lawrence | Tennessee | 47099 | 9733 | 127 |
1949175 | 1949175 | 2021-11-24 | Lawrence | Tennessee | 47099 | 9733 | 127 |
1945924 | 1945924 | 2021-11-23 | Lawrence | Tennessee | 47099 | 9730 | 126 |
1942673 | 1942673 | 2021-11-22 | Lawrence | Tennessee | 47099 | 9721 | 125 |
1939423 | 1939423 | 2021-11-21 | Lawrence | Tennessee | 47099 | 9701 | 125 |
1936173 | 1936173 | 2021-11-20 | Lawrence | Tennessee | 47099 | 9701 | 125 |
1932923 | 1932923 | 2021-11-19 | Lawrence | Tennessee | 47099 | 9701 | 125 |
1929672 | 1929672 | 2021-11-18 | Lawrence | Tennessee | 47099 | 9689 | 125 |
1926422 | 1926422 | 2021-11-17 | Lawrence | Tennessee | 47099 | 9680 | 125 |
1923172 | 1923172 | 2021-11-16 | Lawrence | Tennessee | 47099 | 9674 | 125 |
1919923 | 1919923 | 2021-11-15 | Lawrence | Tennessee | 47099 | 9658 | 125 |
1916673 | 1916673 | 2021-11-14 | Lawrence | Tennessee | 47099 | 9643 | 125 |
1913423 | 1913423 | 2021-11-13 | Lawrence | Tennessee | 47099 | 9643 | 125 |
1910173 | 1910173 | 2021-11-12 | Lawrence | Tennessee | 47099 | 9643 | 125 |
1906924 | 1906924 | 2021-11-11 | Lawrence | Tennessee | 47099 | 9632 | 125 |
1903675 | 1903675 | 2021-11-10 | Lawrence | Tennessee | 47099 | 9632 | 125 |
1900425 | 1900425 | 2021-11-09 | Lawrence | Tennessee | 47099 | 9620 | 125 |
1897175 | 1897175 | 2021-11-08 | Lawrence | Tennessee | 47099 | 9597 | 125 |
1893925 | 1893925 | 2021-11-07 | Lawrence | Tennessee | 47099 | 9597 | 125 |
1890675 | 1890675 | 2021-11-06 | Lawrence | Tennessee | 47099 | 9597 | 125 |
1887425 | 1887425 | 2021-11-05 | Lawrence | Tennessee | 47099 | 9597 | 125 |
1884175 | 1884175 | 2021-11-04 | Lawrence | Tennessee | 47099 | 9593 | 126 |
1880926 | 1880926 | 2021-11-03 | Lawrence | Tennessee | 47099 | 9586 | 126 |
1877677 | 1877677 | 2021-11-02 | Lawrence | Tennessee | 47099 | 9580 | 125 |
1874428 | 1874428 | 2021-11-01 | Lawrence | Tennessee | 47099 | 9557 | 124 |
1871179 | 1871179 | 2021-10-31 | Lawrence | Tennessee | 47099 | 9557 | 124 |
1867930 | 1867930 | 2021-10-30 | Lawrence | Tennessee | 47099 | 9557 | 124 |
1864681 | 1864681 | 2021-10-29 | Lawrence | Tennessee | 47099 | 9557 | 124 |
1861432 | 1861432 | 2021-10-28 | Lawrence | Tennessee | 47099 | 9554 | 124 |
1858183 | 1858183 | 2021-10-27 | Lawrence | Tennessee | 47099 | 9539 | 124 |
1854934 | 1854934 | 2021-10-26 | Lawrence | Tennessee | 47099 | 9527 | 121 |
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);