ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 18067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174933 | 2174933 | 2022-02-02 | Howard | Indiana | 18067 | 24646 | 409 |
2171680 | 2171680 | 2022-02-01 | Howard | Indiana | 18067 | 24530 | 409 |
2168427 | 2168427 | 2022-01-31 | Howard | Indiana | 18067 | 24454 | 406 |
2165172 | 2165172 | 2022-01-30 | Howard | Indiana | 18067 | 24060 | 406 |
2161917 | 2161917 | 2022-01-29 | Howard | Indiana | 18067 | 24060 | 406 |
2158662 | 2158662 | 2022-01-28 | Howard | Indiana | 18067 | 24060 | 406 |
2155408 | 2155408 | 2022-01-27 | Howard | Indiana | 18067 | 23811 | 401 |
2152155 | 2152155 | 2022-01-26 | Howard | Indiana | 18067 | 23568 | 399 |
2148903 | 2148903 | 2022-01-25 | Howard | Indiana | 18067 | 23465 | 391 |
2145651 | 2145651 | 2022-01-24 | Howard | Indiana | 18067 | 23258 | 391 |
2142396 | 2142396 | 2022-01-23 | Howard | Indiana | 18067 | 22403 | 391 |
2139141 | 2139141 | 2022-01-22 | Howard | Indiana | 18067 | 22403 | 391 |
2135885 | 2135885 | 2022-01-21 | Howard | Indiana | 18067 | 22403 | 391 |
2132633 | 2132633 | 2022-01-20 | Howard | Indiana | 18067 | 22109 | 388 |
2129380 | 2129380 | 2022-01-19 | Howard | Indiana | 18067 | 21838 | 386 |
2126126 | 2126126 | 2022-01-18 | Howard | Indiana | 18067 | 21579 | 384 |
2122874 | 2122874 | 2022-01-17 | Howard | Indiana | 18067 | 21367 | 384 |
2119622 | 2119622 | 2022-01-16 | Howard | Indiana | 18067 | 20882 | 382 |
2116370 | 2116370 | 2022-01-15 | Howard | Indiana | 18067 | 20882 | 382 |
2113119 | 2113119 | 2022-01-14 | Howard | Indiana | 18067 | 20882 | 382 |
2109867 | 2109867 | 2022-01-13 | Howard | Indiana | 18067 | 20615 | 377 |
2106616 | 2106616 | 2022-01-12 | Howard | Indiana | 18067 | 20342 | 376 |
2103365 | 2103365 | 2022-01-11 | Howard | Indiana | 18067 | 20133 | 375 |
2100114 | 2100114 | 2022-01-10 | Howard | Indiana | 18067 | 20043 | 372 |
2096863 | 2096863 | 2022-01-09 | Howard | Indiana | 18067 | 19527 | 369 |
2093611 | 2093611 | 2022-01-08 | Howard | Indiana | 18067 | 19527 | 369 |
2090359 | 2090359 | 2022-01-07 | Howard | Indiana | 18067 | 19527 | 369 |
2087108 | 2087108 | 2022-01-06 | Howard | Indiana | 18067 | 19310 | 367 |
2083856 | 2083856 | 2022-01-05 | Howard | Indiana | 18067 | 19087 | 362 |
2080604 | 2080604 | 2022-01-04 | Howard | Indiana | 18067 | 18893 | 362 |
2077352 | 2077352 | 2022-01-03 | Howard | Indiana | 18067 | 18827 | 357 |
2074101 | 2074101 | 2022-01-02 | Howard | Indiana | 18067 | 18477 | 356 |
2070850 | 2070850 | 2022-01-01 | Howard | Indiana | 18067 | 18477 | 356 |
2067599 | 2067599 | 2021-12-31 | Howard | Indiana | 18067 | 18477 | 356 |
2064348 | 2064348 | 2021-12-30 | Howard | Indiana | 18067 | 18477 | 356 |
2061098 | 2061098 | 2021-12-29 | Howard | Indiana | 18067 | 18359 | 356 |
2057849 | 2057849 | 2021-12-28 | Howard | Indiana | 18067 | 18272 | 354 |
2054600 | 2054600 | 2021-12-27 | Howard | Indiana | 18067 | 18231 | 349 |
2051350 | 2051350 | 2021-12-26 | Howard | Indiana | 18067 | 18033 | 349 |
2048100 | 2048100 | 2021-12-25 | Howard | Indiana | 18067 | 18033 | 349 |
2044850 | 2044850 | 2021-12-24 | Howard | Indiana | 18067 | 18033 | 349 |
2041601 | 2041601 | 2021-12-23 | Howard | Indiana | 18067 | 18033 | 349 |
2038351 | 2038351 | 2021-12-22 | Howard | Indiana | 18067 | 18033 | 349 |
2035101 | 2035101 | 2021-12-21 | Howard | Indiana | 18067 | 17947 | 348 |
2031851 | 2031851 | 2021-12-20 | Howard | Indiana | 18067 | 17924 | 344 |
2028600 | 2028600 | 2021-12-19 | Howard | Indiana | 18067 | 17729 | 339 |
2025349 | 2025349 | 2021-12-18 | Howard | Indiana | 18067 | 17729 | 339 |
2022098 | 2022098 | 2021-12-17 | Howard | Indiana | 18067 | 17729 | 339 |
2018847 | 2018847 | 2021-12-16 | Howard | Indiana | 18067 | 17644 | 337 |
2015597 | 2015597 | 2021-12-15 | Howard | Indiana | 18067 | 17571 | 333 |
2012346 | 2012346 | 2021-12-14 | Howard | Indiana | 18067 | 17485 | 331 |
2009095 | 2009095 | 2021-12-13 | Howard | Indiana | 18067 | 17430 | 329 |
2005844 | 2005844 | 2021-12-12 | Howard | Indiana | 18067 | 17257 | 328 |
2002593 | 2002593 | 2021-12-11 | Howard | Indiana | 18067 | 17257 | 328 |
1999343 | 1999343 | 2021-12-10 | Howard | Indiana | 18067 | 17257 | 328 |
1996092 | 1996092 | 2021-12-09 | Howard | Indiana | 18067 | 17156 | 327 |
1992841 | 1992841 | 2021-12-08 | Howard | Indiana | 18067 | 17089 | 326 |
1989590 | 1989590 | 2021-12-07 | Howard | Indiana | 18067 | 16998 | 322 |
1986340 | 1986340 | 2021-12-06 | Howard | Indiana | 18067 | 16960 | 322 |
1983090 | 1983090 | 2021-12-05 | Howard | Indiana | 18067 | 16788 | 321 |
1979840 | 1979840 | 2021-12-04 | Howard | Indiana | 18067 | 16788 | 321 |
1976590 | 1976590 | 2021-12-03 | Howard | Indiana | 18067 | 16788 | 321 |
1973341 | 1973341 | 2021-12-02 | Howard | Indiana | 18067 | 16684 | 320 |
1970091 | 1970091 | 2021-12-01 | Howard | Indiana | 18067 | 16595 | 320 |
1966841 | 1966841 | 2021-11-30 | Howard | Indiana | 18067 | 16450 | 318 |
1963589 | 1963589 | 2021-11-29 | Howard | Indiana | 18067 | 16426 | 318 |
1960338 | 1960338 | 2021-11-28 | Howard | Indiana | 18067 | 16199 | 317 |
1957087 | 1957087 | 2021-11-27 | Howard | Indiana | 18067 | 16199 | 317 |
1953836 | 1953836 | 2021-11-26 | Howard | Indiana | 18067 | 16199 | 317 |
1950585 | 1950585 | 2021-11-25 | Howard | Indiana | 18067 | 16199 | 317 |
1947334 | 1947334 | 2021-11-24 | Howard | Indiana | 18067 | 16199 | 317 |
1944083 | 1944083 | 2021-11-23 | Howard | Indiana | 18067 | 16095 | 317 |
1940833 | 1940833 | 2021-11-22 | Howard | Indiana | 18067 | 16040 | 315 |
1937583 | 1937583 | 2021-11-21 | Howard | Indiana | 18067 | 15905 | 314 |
1934333 | 1934333 | 2021-11-20 | Howard | Indiana | 18067 | 15905 | 314 |
1931082 | 1931082 | 2021-11-19 | Howard | Indiana | 18067 | 15905 | 314 |
1927831 | 1927831 | 2021-11-18 | Howard | Indiana | 18067 | 15806 | 312 |
1924581 | 1924581 | 2021-11-17 | Howard | Indiana | 18067 | 15739 | 312 |
1921332 | 1921332 | 2021-11-16 | Howard | Indiana | 18067 | 15675 | 311 |
1918082 | 1918082 | 2021-11-15 | Howard | Indiana | 18067 | 15641 | 310 |
1914832 | 1914832 | 2021-11-14 | Howard | Indiana | 18067 | 15547 | 310 |
1911582 | 1911582 | 2021-11-13 | Howard | Indiana | 18067 | 15547 | 310 |
1908333 | 1908333 | 2021-11-12 | Howard | Indiana | 18067 | 15547 | 310 |
1905084 | 1905084 | 2021-11-11 | Howard | Indiana | 18067 | 15496 | 308 |
1901834 | 1901834 | 2021-11-10 | Howard | Indiana | 18067 | 15353 | 308 |
1898584 | 1898584 | 2021-11-09 | Howard | Indiana | 18067 | 15305 | 308 |
1895334 | 1895334 | 2021-11-08 | Howard | Indiana | 18067 | 15269 | 307 |
1892084 | 1892084 | 2021-11-07 | Howard | Indiana | 18067 | 15179 | 306 |
1888834 | 1888834 | 2021-11-06 | Howard | Indiana | 18067 | 15179 | 306 |
1885584 | 1885584 | 2021-11-05 | Howard | Indiana | 18067 | 15179 | 306 |
1882335 | 1882335 | 2021-11-04 | Howard | Indiana | 18067 | 15142 | 304 |
1879086 | 1879086 | 2021-11-03 | Howard | Indiana | 18067 | 15109 | 304 |
1875837 | 1875837 | 2021-11-02 | Howard | Indiana | 18067 | 15068 | 303 |
1872588 | 1872588 | 2021-11-01 | Howard | Indiana | 18067 | 15058 | 303 |
1869339 | 1869339 | 2021-10-31 | Howard | Indiana | 18067 | 14984 | 300 |
1866090 | 1866090 | 2021-10-30 | Howard | Indiana | 18067 | 14984 | 300 |
1862841 | 1862841 | 2021-10-29 | Howard | Indiana | 18067 | 14984 | 300 |
1859592 | 1859592 | 2021-10-28 | Howard | Indiana | 18067 | 14950 | 299 |
1856343 | 1856343 | 2021-10-27 | Howard | Indiana | 18067 | 14921 | 299 |
1853094 | 1853094 | 2021-10-26 | Howard | Indiana | 18067 | 14856 | 297 |
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);