ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 18153 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109910 | 2109910 | 2022-01-13 | Sullivan | Indiana | 18153 | 4169 | 65 |
2106659 | 2106659 | 2022-01-12 | Sullivan | Indiana | 18153 | 4157 | 65 |
2103408 | 2103408 | 2022-01-11 | Sullivan | Indiana | 18153 | 4132 | 63 |
2100157 | 2100157 | 2022-01-10 | Sullivan | Indiana | 18153 | 4110 | 63 |
2096906 | 2096906 | 2022-01-09 | Sullivan | Indiana | 18153 | 3987 | 62 |
2093654 | 2093654 | 2022-01-08 | Sullivan | Indiana | 18153 | 3987 | 62 |
2090402 | 2090402 | 2022-01-07 | Sullivan | Indiana | 18153 | 3987 | 62 |
2087151 | 2087151 | 2022-01-06 | Sullivan | Indiana | 18153 | 3943 | 62 |
2083899 | 2083899 | 2022-01-05 | Sullivan | Indiana | 18153 | 3892 | 61 |
2080647 | 2080647 | 2022-01-04 | Sullivan | Indiana | 18153 | 3863 | 61 |
2077395 | 2077395 | 2022-01-03 | Sullivan | Indiana | 18153 | 3849 | 60 |
2074144 | 2074144 | 2022-01-02 | Sullivan | Indiana | 18153 | 3776 | 60 |
2070893 | 2070893 | 2022-01-01 | Sullivan | Indiana | 18153 | 3776 | 60 |
2067642 | 2067642 | 2021-12-31 | Sullivan | Indiana | 18153 | 3776 | 60 |
2064391 | 2064391 | 2021-12-30 | Sullivan | Indiana | 18153 | 3776 | 60 |
2061141 | 2061141 | 2021-12-29 | Sullivan | Indiana | 18153 | 3756 | 60 |
2057892 | 2057892 | 2021-12-28 | Sullivan | Indiana | 18153 | 3749 | 59 |
2054643 | 2054643 | 2021-12-27 | Sullivan | Indiana | 18153 | 3744 | 58 |
2051393 | 2051393 | 2021-12-26 | Sullivan | Indiana | 18153 | 3695 | 58 |
2048143 | 2048143 | 2021-12-25 | Sullivan | Indiana | 18153 | 3695 | 58 |
2044893 | 2044893 | 2021-12-24 | Sullivan | Indiana | 18153 | 3695 | 58 |
2041644 | 2041644 | 2021-12-23 | Sullivan | Indiana | 18153 | 3695 | 58 |
2038394 | 2038394 | 2021-12-22 | Sullivan | Indiana | 18153 | 3695 | 58 |
2035144 | 2035144 | 2021-12-21 | Sullivan | Indiana | 18153 | 3684 | 58 |
2031894 | 2031894 | 2021-12-20 | Sullivan | Indiana | 18153 | 3680 | 58 |
2028643 | 2028643 | 2021-12-19 | Sullivan | Indiana | 18153 | 3646 | 58 |
2025392 | 2025392 | 2021-12-18 | Sullivan | Indiana | 18153 | 3646 | 58 |
2022141 | 2022141 | 2021-12-17 | Sullivan | Indiana | 18153 | 3646 | 58 |
2018890 | 2018890 | 2021-12-16 | Sullivan | Indiana | 18153 | 3627 | 58 |
2015640 | 2015640 | 2021-12-15 | Sullivan | Indiana | 18153 | 3614 | 58 |
2012389 | 2012389 | 2021-12-14 | Sullivan | Indiana | 18153 | 3606 | 58 |
2009138 | 2009138 | 2021-12-13 | Sullivan | Indiana | 18153 | 3599 | 58 |
2005887 | 2005887 | 2021-12-12 | Sullivan | Indiana | 18153 | 3562 | 57 |
2002636 | 2002636 | 2021-12-11 | Sullivan | Indiana | 18153 | 3562 | 57 |
1999386 | 1999386 | 2021-12-10 | Sullivan | Indiana | 18153 | 3562 | 57 |
1996135 | 1996135 | 2021-12-09 | Sullivan | Indiana | 18153 | 3549 | 57 |
1992884 | 1992884 | 2021-12-08 | Sullivan | Indiana | 18153 | 3540 | 57 |
1989633 | 1989633 | 2021-12-07 | Sullivan | Indiana | 18153 | 3531 | 57 |
1986383 | 1986383 | 2021-12-06 | Sullivan | Indiana | 18153 | 3518 | 57 |
1983133 | 1983133 | 2021-12-05 | Sullivan | Indiana | 18153 | 3492 | 57 |
1979883 | 1979883 | 2021-12-04 | Sullivan | Indiana | 18153 | 3492 | 57 |
1976633 | 1976633 | 2021-12-03 | Sullivan | Indiana | 18153 | 3492 | 57 |
1973384 | 1973384 | 2021-12-02 | Sullivan | Indiana | 18153 | 3482 | 56 |
1970134 | 1970134 | 2021-12-01 | Sullivan | Indiana | 18153 | 3473 | 56 |
1966884 | 1966884 | 2021-11-30 | Sullivan | Indiana | 18153 | 3464 | 56 |
1963632 | 1963632 | 2021-11-29 | Sullivan | Indiana | 18153 | 3456 | 56 |
1960381 | 1960381 | 2021-11-28 | Sullivan | Indiana | 18153 | 3431 | 56 |
1957130 | 1957130 | 2021-11-27 | Sullivan | Indiana | 18153 | 3431 | 56 |
1953879 | 1953879 | 2021-11-26 | Sullivan | Indiana | 18153 | 3431 | 56 |
1950628 | 1950628 | 2021-11-25 | Sullivan | Indiana | 18153 | 3431 | 56 |
1947377 | 1947377 | 2021-11-24 | Sullivan | Indiana | 18153 | 3431 | 56 |
1944126 | 1944126 | 2021-11-23 | Sullivan | Indiana | 18153 | 3427 | 56 |
1940876 | 1940876 | 2021-11-22 | Sullivan | Indiana | 18153 | 3426 | 56 |
1937626 | 1937626 | 2021-11-21 | Sullivan | Indiana | 18153 | 3412 | 56 |
1934376 | 1934376 | 2021-11-20 | Sullivan | Indiana | 18153 | 3412 | 56 |
1931125 | 1931125 | 2021-11-19 | Sullivan | Indiana | 18153 | 3412 | 56 |
1927874 | 1927874 | 2021-11-18 | Sullivan | Indiana | 18153 | 3407 | 56 |
1924624 | 1924624 | 2021-11-17 | Sullivan | Indiana | 18153 | 3401 | 56 |
1921375 | 1921375 | 2021-11-16 | Sullivan | Indiana | 18153 | 3396 | 55 |
1918125 | 1918125 | 2021-11-15 | Sullivan | Indiana | 18153 | 3391 | 55 |
1914875 | 1914875 | 2021-11-14 | Sullivan | Indiana | 18153 | 3388 | 55 |
1911625 | 1911625 | 2021-11-13 | Sullivan | Indiana | 18153 | 3388 | 55 |
1908376 | 1908376 | 2021-11-12 | Sullivan | Indiana | 18153 | 3388 | 55 |
1905127 | 1905127 | 2021-11-11 | Sullivan | Indiana | 18153 | 3380 | 55 |
1901877 | 1901877 | 2021-11-10 | Sullivan | Indiana | 18153 | 3362 | 55 |
1898627 | 1898627 | 2021-11-09 | Sullivan | Indiana | 18153 | 3361 | 55 |
1895377 | 1895377 | 2021-11-08 | Sullivan | Indiana | 18153 | 3359 | 55 |
1892127 | 1892127 | 2021-11-07 | Sullivan | Indiana | 18153 | 3350 | 55 |
1888877 | 1888877 | 2021-11-06 | Sullivan | Indiana | 18153 | 3350 | 55 |
1885627 | 1885627 | 2021-11-05 | Sullivan | Indiana | 18153 | 3350 | 55 |
1882378 | 1882378 | 2021-11-04 | Sullivan | Indiana | 18153 | 3347 | 54 |
1879129 | 1879129 | 2021-11-03 | Sullivan | Indiana | 18153 | 3341 | 54 |
1875880 | 1875880 | 2021-11-02 | Sullivan | Indiana | 18153 | 3337 | 54 |
1872631 | 1872631 | 2021-11-01 | Sullivan | Indiana | 18153 | 3334 | 54 |
1869382 | 1869382 | 2021-10-31 | Sullivan | Indiana | 18153 | 3329 | 54 |
1866133 | 1866133 | 2021-10-30 | Sullivan | Indiana | 18153 | 3329 | 54 |
1862884 | 1862884 | 2021-10-29 | Sullivan | Indiana | 18153 | 3329 | 54 |
1859635 | 1859635 | 2021-10-28 | Sullivan | Indiana | 18153 | 3326 | 54 |
1856386 | 1856386 | 2021-10-27 | Sullivan | Indiana | 18153 | 3323 | 54 |
1853137 | 1853137 | 2021-10-26 | Sullivan | Indiana | 18153 | 3319 | 54 |
1849888 | 1849888 | 2021-10-25 | Sullivan | Indiana | 18153 | 3315 | 54 |
1846638 | 1846638 | 2021-10-24 | Sullivan | Indiana | 18153 | 3301 | 54 |
1843388 | 1843388 | 2021-10-23 | Sullivan | Indiana | 18153 | 3301 | 54 |
1840138 | 1840138 | 2021-10-22 | Sullivan | Indiana | 18153 | 3301 | 54 |
1836889 | 1836889 | 2021-10-21 | Sullivan | Indiana | 18153 | 3293 | 54 |
1833640 | 1833640 | 2021-10-20 | Sullivan | Indiana | 18153 | 3285 | 54 |
1830391 | 1830391 | 2021-10-19 | Sullivan | Indiana | 18153 | 3281 | 54 |
1827142 | 1827142 | 2021-10-18 | Sullivan | Indiana | 18153 | 3273 | 54 |
1823893 | 1823893 | 2021-10-17 | Sullivan | Indiana | 18153 | 3272 | 54 |
1820644 | 1820644 | 2021-10-16 | Sullivan | Indiana | 18153 | 3272 | 54 |
1817395 | 1817395 | 2021-10-15 | Sullivan | Indiana | 18153 | 3272 | 54 |
1814147 | 1814147 | 2021-10-14 | Sullivan | Indiana | 18153 | 3269 | 54 |
1810898 | 1810898 | 2021-10-13 | Sullivan | Indiana | 18153 | 3257 | 54 |
1807649 | 1807649 | 2021-10-12 | Sullivan | Indiana | 18153 | 3255 | 54 |
1804398 | 1804398 | 2021-10-11 | Sullivan | Indiana | 18153 | 3244 | 54 |
1801149 | 1801149 | 2021-10-10 | Sullivan | Indiana | 18153 | 3230 | 53 |
1797900 | 1797900 | 2021-10-09 | Sullivan | Indiana | 18153 | 3230 | 53 |
1794651 | 1794651 | 2021-10-08 | Sullivan | Indiana | 18153 | 3230 | 53 |
1791403 | 1791403 | 2021-10-07 | Sullivan | Indiana | 18153 | 3222 | 53 |
1788154 | 1788154 | 2021-10-06 | Sullivan | Indiana | 18153 | 3217 | 52 |
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);