ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 18177 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109922 | 2109922 | 2022-01-13 | Wayne | Indiana | 18177 | 15491 | 303 |
2106671 | 2106671 | 2022-01-12 | Wayne | Indiana | 18177 | 15333 | 302 |
2103420 | 2103420 | 2022-01-11 | Wayne | Indiana | 18177 | 15170 | 301 |
2100169 | 2100169 | 2022-01-10 | Wayne | Indiana | 18177 | 15072 | 301 |
2096918 | 2096918 | 2022-01-09 | Wayne | Indiana | 18177 | 14528 | 298 |
2093666 | 2093666 | 2022-01-08 | Wayne | Indiana | 18177 | 14528 | 298 |
2090414 | 2090414 | 2022-01-07 | Wayne | Indiana | 18177 | 14528 | 298 |
2087163 | 2087163 | 2022-01-06 | Wayne | Indiana | 18177 | 14353 | 294 |
2083911 | 2083911 | 2022-01-05 | Wayne | Indiana | 18177 | 14231 | 293 |
2080659 | 2080659 | 2022-01-04 | Wayne | Indiana | 18177 | 14124 | 293 |
2077407 | 2077407 | 2022-01-03 | Wayne | Indiana | 18177 | 14017 | 289 |
2074156 | 2074156 | 2022-01-02 | Wayne | Indiana | 18177 | 13727 | 289 |
2070905 | 2070905 | 2022-01-01 | Wayne | Indiana | 18177 | 13727 | 289 |
2067654 | 2067654 | 2021-12-31 | Wayne | Indiana | 18177 | 13727 | 289 |
2064403 | 2064403 | 2021-12-30 | Wayne | Indiana | 18177 | 13727 | 289 |
2061153 | 2061153 | 2021-12-29 | Wayne | Indiana | 18177 | 13598 | 288 |
2057904 | 2057904 | 2021-12-28 | Wayne | Indiana | 18177 | 13491 | 286 |
2054655 | 2054655 | 2021-12-27 | Wayne | Indiana | 18177 | 13441 | 285 |
2051405 | 2051405 | 2021-12-26 | Wayne | Indiana | 18177 | 13265 | 283 |
2048155 | 2048155 | 2021-12-25 | Wayne | Indiana | 18177 | 13265 | 283 |
2044905 | 2044905 | 2021-12-24 | Wayne | Indiana | 18177 | 13265 | 283 |
2041656 | 2041656 | 2021-12-23 | Wayne | Indiana | 18177 | 13265 | 283 |
2038406 | 2038406 | 2021-12-22 | Wayne | Indiana | 18177 | 13265 | 283 |
2035156 | 2035156 | 2021-12-21 | Wayne | Indiana | 18177 | 13228 | 282 |
2031906 | 2031906 | 2021-12-20 | Wayne | Indiana | 18177 | 13173 | 281 |
2028655 | 2028655 | 2021-12-19 | Wayne | Indiana | 18177 | 13079 | 280 |
2025404 | 2025404 | 2021-12-18 | Wayne | Indiana | 18177 | 13079 | 280 |
2022153 | 2022153 | 2021-12-17 | Wayne | Indiana | 18177 | 13079 | 280 |
2018902 | 2018902 | 2021-12-16 | Wayne | Indiana | 18177 | 13001 | 280 |
2015652 | 2015652 | 2021-12-15 | Wayne | Indiana | 18177 | 12954 | 279 |
2012401 | 2012401 | 2021-12-14 | Wayne | Indiana | 18177 | 12907 | 278 |
2009150 | 2009150 | 2021-12-13 | Wayne | Indiana | 18177 | 12876 | 278 |
2005899 | 2005899 | 2021-12-12 | Wayne | Indiana | 18177 | 12770 | 277 |
2002648 | 2002648 | 2021-12-11 | Wayne | Indiana | 18177 | 12770 | 277 |
1999398 | 1999398 | 2021-12-10 | Wayne | Indiana | 18177 | 12770 | 277 |
1996147 | 1996147 | 2021-12-09 | Wayne | Indiana | 18177 | 12717 | 277 |
1992896 | 1992896 | 2021-12-08 | Wayne | Indiana | 18177 | 12681 | 277 |
1989645 | 1989645 | 2021-12-07 | Wayne | Indiana | 18177 | 12617 | 276 |
1986395 | 1986395 | 2021-12-06 | Wayne | Indiana | 18177 | 12574 | 274 |
1983145 | 1983145 | 2021-12-05 | Wayne | Indiana | 18177 | 12464 | 274 |
1979895 | 1979895 | 2021-12-04 | Wayne | Indiana | 18177 | 12464 | 274 |
1976645 | 1976645 | 2021-12-03 | Wayne | Indiana | 18177 | 12464 | 274 |
1973396 | 1973396 | 2021-12-02 | Wayne | Indiana | 18177 | 12410 | 273 |
1970146 | 1970146 | 2021-12-01 | Wayne | Indiana | 18177 | 12361 | 273 |
1966896 | 1966896 | 2021-11-30 | Wayne | Indiana | 18177 | 12295 | 272 |
1963644 | 1963644 | 2021-11-29 | Wayne | Indiana | 18177 | 12253 | 270 |
1960393 | 1960393 | 2021-11-28 | Wayne | Indiana | 18177 | 12168 | 269 |
1957142 | 1957142 | 2021-11-27 | Wayne | Indiana | 18177 | 12168 | 269 |
1953891 | 1953891 | 2021-11-26 | Wayne | Indiana | 18177 | 12168 | 269 |
1950640 | 1950640 | 2021-11-25 | Wayne | Indiana | 18177 | 12168 | 269 |
1947389 | 1947389 | 2021-11-24 | Wayne | Indiana | 18177 | 12168 | 269 |
1944138 | 1944138 | 2021-11-23 | Wayne | Indiana | 18177 | 12139 | 268 |
1940888 | 1940888 | 2021-11-22 | Wayne | Indiana | 18177 | 12093 | 266 |
1937638 | 1937638 | 2021-11-21 | Wayne | Indiana | 18177 | 12042 | 265 |
1934388 | 1934388 | 2021-11-20 | Wayne | Indiana | 18177 | 12042 | 265 |
1931137 | 1931137 | 2021-11-19 | Wayne | Indiana | 18177 | 12042 | 265 |
1927886 | 1927886 | 2021-11-18 | Wayne | Indiana | 18177 | 12010 | 265 |
1924636 | 1924636 | 2021-11-17 | Wayne | Indiana | 18177 | 11986 | 265 |
1921387 | 1921387 | 2021-11-16 | Wayne | Indiana | 18177 | 11945 | 265 |
1918137 | 1918137 | 2021-11-15 | Wayne | Indiana | 18177 | 11898 | 265 |
1914887 | 1914887 | 2021-11-14 | Wayne | Indiana | 18177 | 11843 | 264 |
1911637 | 1911637 | 2021-11-13 | Wayne | Indiana | 18177 | 11843 | 264 |
1908388 | 1908388 | 2021-11-12 | Wayne | Indiana | 18177 | 11843 | 264 |
1905139 | 1905139 | 2021-11-11 | Wayne | Indiana | 18177 | 11817 | 263 |
1901889 | 1901889 | 2021-11-10 | Wayne | Indiana | 18177 | 11712 | 263 |
1898639 | 1898639 | 2021-11-09 | Wayne | Indiana | 18177 | 11693 | 263 |
1895389 | 1895389 | 2021-11-08 | Wayne | Indiana | 18177 | 11664 | 263 |
1892139 | 1892139 | 2021-11-07 | Wayne | Indiana | 18177 | 11613 | 263 |
1888889 | 1888889 | 2021-11-06 | Wayne | Indiana | 18177 | 11613 | 263 |
1885639 | 1885639 | 2021-11-05 | Wayne | Indiana | 18177 | 11613 | 263 |
1882390 | 1882390 | 2021-11-04 | Wayne | Indiana | 18177 | 11587 | 263 |
1879141 | 1879141 | 2021-11-03 | Wayne | Indiana | 18177 | 11568 | 263 |
1875892 | 1875892 | 2021-11-02 | Wayne | Indiana | 18177 | 11547 | 261 |
1872643 | 1872643 | 2021-11-01 | Wayne | Indiana | 18177 | 11520 | 260 |
1869394 | 1869394 | 2021-10-31 | Wayne | Indiana | 18177 | 11480 | 260 |
1866145 | 1866145 | 2021-10-30 | Wayne | Indiana | 18177 | 11480 | 260 |
1862896 | 1862896 | 2021-10-29 | Wayne | Indiana | 18177 | 11480 | 260 |
1859647 | 1859647 | 2021-10-28 | Wayne | Indiana | 18177 | 11445 | 260 |
1856398 | 1856398 | 2021-10-27 | Wayne | Indiana | 18177 | 11430 | 260 |
1853149 | 1853149 | 2021-10-26 | Wayne | Indiana | 18177 | 11409 | 259 |
1849900 | 1849900 | 2021-10-25 | Wayne | Indiana | 18177 | 11396 | 258 |
1846650 | 1846650 | 2021-10-24 | Wayne | Indiana | 18177 | 11359 | 258 |
1843400 | 1843400 | 2021-10-23 | Wayne | Indiana | 18177 | 11359 | 258 |
1840150 | 1840150 | 2021-10-22 | Wayne | Indiana | 18177 | 11359 | 258 |
1836901 | 1836901 | 2021-10-21 | Wayne | Indiana | 18177 | 11338 | 258 |
1833652 | 1833652 | 2021-10-20 | Wayne | Indiana | 18177 | 11320 | 258 |
1830403 | 1830403 | 2021-10-19 | Wayne | Indiana | 18177 | 11292 | 257 |
1827154 | 1827154 | 2021-10-18 | Wayne | Indiana | 18177 | 11271 | 255 |
1823905 | 1823905 | 2021-10-17 | Wayne | Indiana | 18177 | 11214 | 253 |
1820656 | 1820656 | 2021-10-16 | Wayne | Indiana | 18177 | 11214 | 253 |
1817407 | 1817407 | 2021-10-15 | Wayne | Indiana | 18177 | 11214 | 253 |
1814159 | 1814159 | 2021-10-14 | Wayne | Indiana | 18177 | 11186 | 252 |
1810910 | 1810910 | 2021-10-13 | Wayne | Indiana | 18177 | 11154 | 250 |
1807661 | 1807661 | 2021-10-12 | Wayne | Indiana | 18177 | 11102 | 250 |
1804410 | 1804410 | 2021-10-11 | Wayne | Indiana | 18177 | 11078 | 249 |
1801161 | 1801161 | 2021-10-10 | Wayne | Indiana | 18177 | 11012 | 245 |
1797912 | 1797912 | 2021-10-09 | Wayne | Indiana | 18177 | 11012 | 245 |
1794663 | 1794663 | 2021-10-08 | Wayne | Indiana | 18177 | 11012 | 245 |
1791415 | 1791415 | 2021-10-07 | Wayne | Indiana | 18177 | 10953 | 245 |
1788166 | 1788166 | 2021-10-06 | Wayne | Indiana | 18177 | 10913 | 244 |
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);