ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Lawrence" and fips = 18093 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174946 | 2174946 | 2022-02-02 | Lawrence | Indiana | 18093 | 11327 | 232 |
2171693 | 2171693 | 2022-02-01 | Lawrence | Indiana | 18093 | 11224 | 231 |
2168440 | 2168440 | 2022-01-31 | Lawrence | Indiana | 18093 | 11169 | 231 |
2165185 | 2165185 | 2022-01-30 | Lawrence | Indiana | 18093 | 10887 | 229 |
2161930 | 2161930 | 2022-01-29 | Lawrence | Indiana | 18093 | 10887 | 229 |
2158675 | 2158675 | 2022-01-28 | Lawrence | Indiana | 18093 | 10887 | 229 |
2155421 | 2155421 | 2022-01-27 | Lawrence | Indiana | 18093 | 10761 | 227 |
2152168 | 2152168 | 2022-01-26 | Lawrence | Indiana | 18093 | 10679 | 227 |
2148916 | 2148916 | 2022-01-25 | Lawrence | Indiana | 18093 | 10607 | 226 |
2145664 | 2145664 | 2022-01-24 | Lawrence | Indiana | 18093 | 10533 | 225 |
2142409 | 2142409 | 2022-01-23 | Lawrence | Indiana | 18093 | 10312 | 225 |
2139154 | 2139154 | 2022-01-22 | Lawrence | Indiana | 18093 | 10312 | 225 |
2135898 | 2135898 | 2022-01-21 | Lawrence | Indiana | 18093 | 10312 | 225 |
2132646 | 2132646 | 2022-01-20 | Lawrence | Indiana | 18093 | 10199 | 223 |
2129393 | 2129393 | 2022-01-19 | Lawrence | Indiana | 18093 | 10085 | 223 |
2126139 | 2126139 | 2022-01-18 | Lawrence | Indiana | 18093 | 9976 | 223 |
2122887 | 2122887 | 2022-01-17 | Lawrence | Indiana | 18093 | 9917 | 222 |
2119635 | 2119635 | 2022-01-16 | Lawrence | Indiana | 18093 | 9658 | 222 |
2116383 | 2116383 | 2022-01-15 | Lawrence | Indiana | 18093 | 9658 | 222 |
2113132 | 2113132 | 2022-01-14 | Lawrence | Indiana | 18093 | 9658 | 222 |
2109880 | 2109880 | 2022-01-13 | Lawrence | Indiana | 18093 | 9548 | 220 |
2106629 | 2106629 | 2022-01-12 | Lawrence | Indiana | 18093 | 9462 | 219 |
2103378 | 2103378 | 2022-01-11 | Lawrence | Indiana | 18093 | 9370 | 216 |
2100127 | 2100127 | 2022-01-10 | Lawrence | Indiana | 18093 | 9317 | 214 |
2096876 | 2096876 | 2022-01-09 | Lawrence | Indiana | 18093 | 9161 | 213 |
2093624 | 2093624 | 2022-01-08 | Lawrence | Indiana | 18093 | 9161 | 213 |
2090372 | 2090372 | 2022-01-07 | Lawrence | Indiana | 18093 | 9161 | 213 |
2087121 | 2087121 | 2022-01-06 | Lawrence | Indiana | 18093 | 9101 | 211 |
2083869 | 2083869 | 2022-01-05 | Lawrence | Indiana | 18093 | 9045 | 209 |
2080617 | 2080617 | 2022-01-04 | Lawrence | Indiana | 18093 | 8994 | 209 |
2077365 | 2077365 | 2022-01-03 | Lawrence | Indiana | 18093 | 8962 | 208 |
2074114 | 2074114 | 2022-01-02 | Lawrence | Indiana | 18093 | 8852 | 208 |
2070863 | 2070863 | 2022-01-01 | Lawrence | Indiana | 18093 | 8852 | 208 |
2067612 | 2067612 | 2021-12-31 | Lawrence | Indiana | 18093 | 8852 | 208 |
2064361 | 2064361 | 2021-12-30 | Lawrence | Indiana | 18093 | 8852 | 208 |
2061111 | 2061111 | 2021-12-29 | Lawrence | Indiana | 18093 | 8798 | 207 |
2057862 | 2057862 | 2021-12-28 | Lawrence | Indiana | 18093 | 8765 | 205 |
2054613 | 2054613 | 2021-12-27 | Lawrence | Indiana | 18093 | 8742 | 205 |
2051363 | 2051363 | 2021-12-26 | Lawrence | Indiana | 18093 | 8634 | 205 |
2048113 | 2048113 | 2021-12-25 | Lawrence | Indiana | 18093 | 8634 | 205 |
2044863 | 2044863 | 2021-12-24 | Lawrence | Indiana | 18093 | 8634 | 205 |
2041614 | 2041614 | 2021-12-23 | Lawrence | Indiana | 18093 | 8634 | 205 |
2038364 | 2038364 | 2021-12-22 | Lawrence | Indiana | 18093 | 8634 | 205 |
2035114 | 2035114 | 2021-12-21 | Lawrence | Indiana | 18093 | 8596 | 205 |
2031864 | 2031864 | 2021-12-20 | Lawrence | Indiana | 18093 | 8566 | 202 |
2028613 | 2028613 | 2021-12-19 | Lawrence | Indiana | 18093 | 8505 | 200 |
2025362 | 2025362 | 2021-12-18 | Lawrence | Indiana | 18093 | 8505 | 200 |
2022111 | 2022111 | 2021-12-17 | Lawrence | Indiana | 18093 | 8505 | 200 |
2018860 | 2018860 | 2021-12-16 | Lawrence | Indiana | 18093 | 8457 | 197 |
2015610 | 2015610 | 2021-12-15 | Lawrence | Indiana | 18093 | 8431 | 197 |
2012359 | 2012359 | 2021-12-14 | Lawrence | Indiana | 18093 | 8391 | 195 |
2009108 | 2009108 | 2021-12-13 | Lawrence | Indiana | 18093 | 8351 | 192 |
2005857 | 2005857 | 2021-12-12 | Lawrence | Indiana | 18093 | 8276 | 191 |
2002606 | 2002606 | 2021-12-11 | Lawrence | Indiana | 18093 | 8276 | 191 |
1999356 | 1999356 | 2021-12-10 | Lawrence | Indiana | 18093 | 8276 | 191 |
1996105 | 1996105 | 2021-12-09 | Lawrence | Indiana | 18093 | 8233 | 191 |
1992854 | 1992854 | 2021-12-08 | Lawrence | Indiana | 18093 | 8202 | 191 |
1989603 | 1989603 | 2021-12-07 | Lawrence | Indiana | 18093 | 8162 | 190 |
1986353 | 1986353 | 2021-12-06 | Lawrence | Indiana | 18093 | 8137 | 188 |
1983103 | 1983103 | 2021-12-05 | Lawrence | Indiana | 18093 | 8060 | 188 |
1979853 | 1979853 | 2021-12-04 | Lawrence | Indiana | 18093 | 8060 | 188 |
1976603 | 1976603 | 2021-12-03 | Lawrence | Indiana | 18093 | 8060 | 188 |
1973354 | 1973354 | 2021-12-02 | Lawrence | Indiana | 18093 | 8021 | 188 |
1970104 | 1970104 | 2021-12-01 | Lawrence | Indiana | 18093 | 7992 | 187 |
1966854 | 1966854 | 2021-11-30 | Lawrence | Indiana | 18093 | 7942 | 187 |
1963602 | 1963602 | 2021-11-29 | Lawrence | Indiana | 18093 | 7925 | 185 |
1960351 | 1960351 | 2021-11-28 | Lawrence | Indiana | 18093 | 7864 | 185 |
1957100 | 1957100 | 2021-11-27 | Lawrence | Indiana | 18093 | 7864 | 185 |
1953849 | 1953849 | 2021-11-26 | Lawrence | Indiana | 18093 | 7864 | 185 |
1950598 | 1950598 | 2021-11-25 | Lawrence | Indiana | 18093 | 7864 | 185 |
1947347 | 1947347 | 2021-11-24 | Lawrence | Indiana | 18093 | 7864 | 185 |
1944096 | 1944096 | 2021-11-23 | Lawrence | Indiana | 18093 | 7839 | 185 |
1940846 | 1940846 | 2021-11-22 | Lawrence | Indiana | 18093 | 7821 | 185 |
1937596 | 1937596 | 2021-11-21 | Lawrence | Indiana | 18093 | 7792 | 185 |
1934346 | 1934346 | 2021-11-20 | Lawrence | Indiana | 18093 | 7792 | 185 |
1931095 | 1931095 | 2021-11-19 | Lawrence | Indiana | 18093 | 7792 | 185 |
1927844 | 1927844 | 2021-11-18 | Lawrence | Indiana | 18093 | 7778 | 184 |
1924594 | 1924594 | 2021-11-17 | Lawrence | Indiana | 18093 | 7760 | 183 |
1921345 | 1921345 | 2021-11-16 | Lawrence | Indiana | 18093 | 7737 | 183 |
1918095 | 1918095 | 2021-11-15 | Lawrence | Indiana | 18093 | 7729 | 183 |
1914845 | 1914845 | 2021-11-14 | Lawrence | Indiana | 18093 | 7708 | 183 |
1911595 | 1911595 | 2021-11-13 | Lawrence | Indiana | 18093 | 7708 | 183 |
1908346 | 1908346 | 2021-11-12 | Lawrence | Indiana | 18093 | 7708 | 183 |
1905097 | 1905097 | 2021-11-11 | Lawrence | Indiana | 18093 | 7697 | 183 |
1901847 | 1901847 | 2021-11-10 | Lawrence | Indiana | 18093 | 7662 | 182 |
1898597 | 1898597 | 2021-11-09 | Lawrence | Indiana | 18093 | 7646 | 182 |
1895347 | 1895347 | 2021-11-08 | Lawrence | Indiana | 18093 | 7635 | 181 |
1892097 | 1892097 | 2021-11-07 | Lawrence | Indiana | 18093 | 7611 | 181 |
1888847 | 1888847 | 2021-11-06 | Lawrence | Indiana | 18093 | 7611 | 181 |
1885597 | 1885597 | 2021-11-05 | Lawrence | Indiana | 18093 | 7611 | 181 |
1882348 | 1882348 | 2021-11-04 | Lawrence | Indiana | 18093 | 7597 | 181 |
1879099 | 1879099 | 2021-11-03 | Lawrence | Indiana | 18093 | 7583 | 180 |
1875850 | 1875850 | 2021-11-02 | Lawrence | Indiana | 18093 | 7561 | 179 |
1872601 | 1872601 | 2021-11-01 | Lawrence | Indiana | 18093 | 7548 | 178 |
1869352 | 1869352 | 2021-10-31 | Lawrence | Indiana | 18093 | 7530 | 177 |
1866103 | 1866103 | 2021-10-30 | Lawrence | Indiana | 18093 | 7530 | 177 |
1862854 | 1862854 | 2021-10-29 | Lawrence | Indiana | 18093 | 7530 | 177 |
1859605 | 1859605 | 2021-10-28 | Lawrence | Indiana | 18093 | 7517 | 175 |
1856356 | 1856356 | 2021-10-27 | Lawrence | Indiana | 18093 | 7505 | 175 |
1853107 | 1853107 | 2021-10-26 | Lawrence | Indiana | 18093 | 7497 | 175 |
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);