ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Howard" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1849845 | 1849845 | 2021-10-25 | Howard | Indiana | 18067 | 14818 | 295 |
1846595 | 1846595 | 2021-10-24 | Howard | Indiana | 18067 | 14765 | 295 |
1843345 | 1843345 | 2021-10-23 | Howard | Indiana | 18067 | 14765 | 295 |
1840095 | 1840095 | 2021-10-22 | Howard | Indiana | 18067 | 14765 | 295 |
1836846 | 1836846 | 2021-10-21 | Howard | Indiana | 18067 | 14736 | 294 |
1833597 | 1833597 | 2021-10-20 | Howard | Indiana | 18067 | 14698 | 294 |
1830348 | 1830348 | 2021-10-19 | Howard | Indiana | 18067 | 14664 | 293 |
1827099 | 1827099 | 2021-10-18 | Howard | Indiana | 18067 | 14643 | 292 |
1823850 | 1823850 | 2021-10-17 | Howard | Indiana | 18067 | 14591 | 291 |
1820601 | 1820601 | 2021-10-16 | Howard | Indiana | 18067 | 14591 | 291 |
1817352 | 1817352 | 2021-10-15 | Howard | Indiana | 18067 | 14591 | 291 |
1814104 | 1814104 | 2021-10-14 | Howard | Indiana | 18067 | 14564 | 291 |
1810855 | 1810855 | 2021-10-13 | Howard | Indiana | 18067 | 14531 | 290 |
1807606 | 1807606 | 2021-10-12 | Howard | Indiana | 18067 | 14477 | 290 |
1804355 | 1804355 | 2021-10-11 | Howard | Indiana | 18067 | 14472 | 289 |
1801106 | 1801106 | 2021-10-10 | Howard | Indiana | 18067 | 14415 | 287 |
1797857 | 1797857 | 2021-10-09 | Howard | Indiana | 18067 | 14415 | 287 |
1794608 | 1794608 | 2021-10-08 | Howard | Indiana | 18067 | 14415 | 287 |
1791360 | 1791360 | 2021-10-07 | Howard | Indiana | 18067 | 14376 | 286 |
1788111 | 1788111 | 2021-10-06 | Howard | Indiana | 18067 | 14348 | 285 |
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);