ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 18157 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109912 | 2109912 | 2022-01-13 | Tippecanoe | Indiana | 18157 | 40222 | 334 |
2106661 | 2106661 | 2022-01-12 | Tippecanoe | Indiana | 18157 | 39428 | 331 |
2103410 | 2103410 | 2022-01-11 | Tippecanoe | Indiana | 18157 | 38951 | 324 |
2100159 | 2100159 | 2022-01-10 | Tippecanoe | Indiana | 18157 | 38478 | 324 |
2096908 | 2096908 | 2022-01-09 | Tippecanoe | Indiana | 18157 | 37079 | 321 |
2093656 | 2093656 | 2022-01-08 | Tippecanoe | Indiana | 18157 | 37079 | 321 |
2090404 | 2090404 | 2022-01-07 | Tippecanoe | Indiana | 18157 | 37079 | 321 |
2087153 | 2087153 | 2022-01-06 | Tippecanoe | Indiana | 18157 | 36643 | 316 |
2083901 | 2083901 | 2022-01-05 | Tippecanoe | Indiana | 18157 | 36191 | 313 |
2080649 | 2080649 | 2022-01-04 | Tippecanoe | Indiana | 18157 | 35764 | 313 |
2077397 | 2077397 | 2022-01-03 | Tippecanoe | Indiana | 18157 | 35486 | 310 |
2074146 | 2074146 | 2022-01-02 | Tippecanoe | Indiana | 18157 | 34574 | 309 |
2070895 | 2070895 | 2022-01-01 | Tippecanoe | Indiana | 18157 | 34574 | 309 |
2067644 | 2067644 | 2021-12-31 | Tippecanoe | Indiana | 18157 | 34574 | 309 |
2064393 | 2064393 | 2021-12-30 | Tippecanoe | Indiana | 18157 | 34574 | 309 |
2061143 | 2061143 | 2021-12-29 | Tippecanoe | Indiana | 18157 | 34200 | 309 |
2057894 | 2057894 | 2021-12-28 | Tippecanoe | Indiana | 18157 | 34024 | 305 |
2054645 | 2054645 | 2021-12-27 | Tippecanoe | Indiana | 18157 | 33802 | 301 |
2051395 | 2051395 | 2021-12-26 | Tippecanoe | Indiana | 18157 | 33227 | 301 |
2048145 | 2048145 | 2021-12-25 | Tippecanoe | Indiana | 18157 | 33227 | 301 |
2044895 | 2044895 | 2021-12-24 | Tippecanoe | Indiana | 18157 | 33227 | 301 |
2041646 | 2041646 | 2021-12-23 | Tippecanoe | Indiana | 18157 | 33227 | 301 |
2038396 | 2038396 | 2021-12-22 | Tippecanoe | Indiana | 18157 | 33227 | 301 |
2035146 | 2035146 | 2021-12-21 | Tippecanoe | Indiana | 18157 | 33094 | 300 |
2031896 | 2031896 | 2021-12-20 | Tippecanoe | Indiana | 18157 | 32969 | 298 |
2028645 | 2028645 | 2021-12-19 | Tippecanoe | Indiana | 18157 | 32669 | 295 |
2025394 | 2025394 | 2021-12-18 | Tippecanoe | Indiana | 18157 | 32669 | 295 |
2022143 | 2022143 | 2021-12-17 | Tippecanoe | Indiana | 18157 | 32669 | 295 |
2018892 | 2018892 | 2021-12-16 | Tippecanoe | Indiana | 18157 | 32514 | 295 |
2015642 | 2015642 | 2021-12-15 | Tippecanoe | Indiana | 18157 | 32336 | 292 |
2012391 | 2012391 | 2021-12-14 | Tippecanoe | Indiana | 18157 | 32232 | 288 |
2009140 | 2009140 | 2021-12-13 | Tippecanoe | Indiana | 18157 | 32138 | 288 |
2005889 | 2005889 | 2021-12-12 | Tippecanoe | Indiana | 18157 | 31749 | 285 |
2002638 | 2002638 | 2021-12-11 | Tippecanoe | Indiana | 18157 | 31749 | 285 |
1999388 | 1999388 | 2021-12-10 | Tippecanoe | Indiana | 18157 | 31749 | 285 |
1996137 | 1996137 | 2021-12-09 | Tippecanoe | Indiana | 18157 | 31598 | 284 |
1992886 | 1992886 | 2021-12-08 | Tippecanoe | Indiana | 18157 | 31475 | 283 |
1989635 | 1989635 | 2021-12-07 | Tippecanoe | Indiana | 18157 | 31313 | 282 |
1986385 | 1986385 | 2021-12-06 | Tippecanoe | Indiana | 18157 | 31223 | 280 |
1983135 | 1983135 | 2021-12-05 | Tippecanoe | Indiana | 18157 | 30819 | 280 |
1979885 | 1979885 | 2021-12-04 | Tippecanoe | Indiana | 18157 | 30819 | 280 |
1976635 | 1976635 | 2021-12-03 | Tippecanoe | Indiana | 18157 | 30819 | 280 |
1973386 | 1973386 | 2021-12-02 | Tippecanoe | Indiana | 18157 | 30665 | 278 |
1970136 | 1970136 | 2021-12-01 | Tippecanoe | Indiana | 18157 | 30495 | 278 |
1966886 | 1966886 | 2021-11-30 | Tippecanoe | Indiana | 18157 | 30347 | 277 |
1963634 | 1963634 | 2021-11-29 | Tippecanoe | Indiana | 18157 | 30248 | 275 |
1960383 | 1960383 | 2021-11-28 | Tippecanoe | Indiana | 18157 | 29874 | 275 |
1957132 | 1957132 | 2021-11-27 | Tippecanoe | Indiana | 18157 | 29874 | 275 |
1953881 | 1953881 | 2021-11-26 | Tippecanoe | Indiana | 18157 | 29874 | 275 |
1950630 | 1950630 | 2021-11-25 | Tippecanoe | Indiana | 18157 | 29874 | 275 |
1947379 | 1947379 | 2021-11-24 | Tippecanoe | Indiana | 18157 | 29874 | 275 |
1944128 | 1944128 | 2021-11-23 | Tippecanoe | Indiana | 18157 | 29802 | 275 |
1940878 | 1940878 | 2021-11-22 | Tippecanoe | Indiana | 18157 | 29731 | 275 |
1937628 | 1937628 | 2021-11-21 | Tippecanoe | Indiana | 18157 | 29467 | 275 |
1934378 | 1934378 | 2021-11-20 | Tippecanoe | Indiana | 18157 | 29467 | 275 |
1931127 | 1931127 | 2021-11-19 | Tippecanoe | Indiana | 18157 | 29467 | 275 |
1927876 | 1927876 | 2021-11-18 | Tippecanoe | Indiana | 18157 | 29369 | 275 |
1924626 | 1924626 | 2021-11-17 | Tippecanoe | Indiana | 18157 | 29286 | 274 |
1921377 | 1921377 | 2021-11-16 | Tippecanoe | Indiana | 18157 | 29216 | 274 |
1918127 | 1918127 | 2021-11-15 | Tippecanoe | Indiana | 18157 | 29150 | 274 |
1914877 | 1914877 | 2021-11-14 | Tippecanoe | Indiana | 18157 | 28966 | 274 |
1911627 | 1911627 | 2021-11-13 | Tippecanoe | Indiana | 18157 | 28966 | 274 |
1908378 | 1908378 | 2021-11-12 | Tippecanoe | Indiana | 18157 | 28966 | 274 |
1905129 | 1905129 | 2021-11-11 | Tippecanoe | Indiana | 18157 | 28860 | 272 |
1901879 | 1901879 | 2021-11-10 | Tippecanoe | Indiana | 18157 | 28698 | 272 |
1898629 | 1898629 | 2021-11-09 | Tippecanoe | Indiana | 18157 | 28648 | 272 |
1895379 | 1895379 | 2021-11-08 | Tippecanoe | Indiana | 18157 | 28608 | 271 |
1892129 | 1892129 | 2021-11-07 | Tippecanoe | Indiana | 18157 | 28474 | 271 |
1888879 | 1888879 | 2021-11-06 | Tippecanoe | Indiana | 18157 | 28474 | 271 |
1885629 | 1885629 | 2021-11-05 | Tippecanoe | Indiana | 18157 | 28474 | 271 |
1882380 | 1882380 | 2021-11-04 | Tippecanoe | Indiana | 18157 | 28427 | 270 |
1879131 | 1879131 | 2021-11-03 | Tippecanoe | Indiana | 18157 | 28385 | 270 |
1875882 | 1875882 | 2021-11-02 | Tippecanoe | Indiana | 18157 | 28366 | 270 |
1872633 | 1872633 | 2021-11-01 | Tippecanoe | Indiana | 18157 | 28317 | 270 |
1869384 | 1869384 | 2021-10-31 | Tippecanoe | Indiana | 18157 | 28189 | 266 |
1866135 | 1866135 | 2021-10-30 | Tippecanoe | Indiana | 18157 | 28189 | 266 |
1862886 | 1862886 | 2021-10-29 | Tippecanoe | Indiana | 18157 | 28189 | 266 |
1859637 | 1859637 | 2021-10-28 | Tippecanoe | Indiana | 18157 | 28139 | 266 |
1856388 | 1856388 | 2021-10-27 | Tippecanoe | Indiana | 18157 | 28092 | 266 |
1853139 | 1853139 | 2021-10-26 | Tippecanoe | Indiana | 18157 | 28063 | 265 |
1849890 | 1849890 | 2021-10-25 | Tippecanoe | Indiana | 18157 | 28047 | 264 |
1846640 | 1846640 | 2021-10-24 | Tippecanoe | Indiana | 18157 | 27943 | 264 |
1843390 | 1843390 | 2021-10-23 | Tippecanoe | Indiana | 18157 | 27943 | 264 |
1840140 | 1840140 | 2021-10-22 | Tippecanoe | Indiana | 18157 | 27943 | 264 |
1836891 | 1836891 | 2021-10-21 | Tippecanoe | Indiana | 18157 | 27908 | 262 |
1833642 | 1833642 | 2021-10-20 | Tippecanoe | Indiana | 18157 | 27869 | 262 |
1830393 | 1830393 | 2021-10-19 | Tippecanoe | Indiana | 18157 | 27834 | 262 |
1827144 | 1827144 | 2021-10-18 | Tippecanoe | Indiana | 18157 | 27806 | 261 |
1823895 | 1823895 | 2021-10-17 | Tippecanoe | Indiana | 18157 | 27704 | 260 |
1820646 | 1820646 | 2021-10-16 | Tippecanoe | Indiana | 18157 | 27704 | 260 |
1817397 | 1817397 | 2021-10-15 | Tippecanoe | Indiana | 18157 | 27704 | 260 |
1814149 | 1814149 | 2021-10-14 | Tippecanoe | Indiana | 18157 | 27654 | 260 |
1810900 | 1810900 | 2021-10-13 | Tippecanoe | Indiana | 18157 | 27597 | 258 |
1807651 | 1807651 | 2021-10-12 | Tippecanoe | Indiana | 18157 | 27561 | 258 |
1804400 | 1804400 | 2021-10-11 | Tippecanoe | Indiana | 18157 | 27538 | 258 |
1801151 | 1801151 | 2021-10-10 | Tippecanoe | Indiana | 18157 | 27423 | 258 |
1797902 | 1797902 | 2021-10-09 | Tippecanoe | Indiana | 18157 | 27423 | 258 |
1794653 | 1794653 | 2021-10-08 | Tippecanoe | Indiana | 18157 | 27423 | 258 |
1791405 | 1791405 | 2021-10-07 | Tippecanoe | Indiana | 18157 | 27361 | 258 |
1788156 | 1788156 | 2021-10-06 | Tippecanoe | Indiana | 18157 | 27334 | 258 |
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);