ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 18057 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174928 | 2174928 | 2022-02-02 | Hamilton | Indiana | 18057 | 79037 | 600 |
2171675 | 2171675 | 2022-02-01 | Hamilton | Indiana | 18057 | 78820 | 600 |
2168422 | 2168422 | 2022-01-31 | Hamilton | Indiana | 18057 | 78603 | 594 |
2165167 | 2165167 | 2022-01-30 | Hamilton | Indiana | 18057 | 77550 | 593 |
2161912 | 2161912 | 2022-01-29 | Hamilton | Indiana | 18057 | 77550 | 593 |
2158657 | 2158657 | 2022-01-28 | Hamilton | Indiana | 18057 | 77550 | 593 |
2155403 | 2155403 | 2022-01-27 | Hamilton | Indiana | 18057 | 76853 | 591 |
2152150 | 2152150 | 2022-01-26 | Hamilton | Indiana | 18057 | 76339 | 590 |
2148898 | 2148898 | 2022-01-25 | Hamilton | Indiana | 18057 | 76119 | 589 |
2145646 | 2145646 | 2022-01-24 | Hamilton | Indiana | 18057 | 75602 | 584 |
2142391 | 2142391 | 2022-01-23 | Hamilton | Indiana | 18057 | 73699 | 584 |
2139136 | 2139136 | 2022-01-22 | Hamilton | Indiana | 18057 | 73699 | 584 |
2135880 | 2135880 | 2022-01-21 | Hamilton | Indiana | 18057 | 73699 | 584 |
2132628 | 2132628 | 2022-01-20 | Hamilton | Indiana | 18057 | 72937 | 583 |
2129375 | 2129375 | 2022-01-19 | Hamilton | Indiana | 18057 | 72268 | 580 |
2126121 | 2126121 | 2022-01-18 | Hamilton | Indiana | 18057 | 71332 | 573 |
2122869 | 2122869 | 2022-01-17 | Hamilton | Indiana | 18057 | 70766 | 572 |
2119617 | 2119617 | 2022-01-16 | Hamilton | Indiana | 18057 | 68720 | 571 |
2116365 | 2116365 | 2022-01-15 | Hamilton | Indiana | 18057 | 68720 | 571 |
2113114 | 2113114 | 2022-01-14 | Hamilton | Indiana | 18057 | 68720 | 571 |
2109862 | 2109862 | 2022-01-13 | Hamilton | Indiana | 18057 | 67950 | 569 |
2106611 | 2106611 | 2022-01-12 | Hamilton | Indiana | 18057 | 67077 | 561 |
2103360 | 2103360 | 2022-01-11 | Hamilton | Indiana | 18057 | 66210 | 556 |
2100109 | 2100109 | 2022-01-10 | Hamilton | Indiana | 18057 | 65328 | 555 |
2096858 | 2096858 | 2022-01-09 | Hamilton | Indiana | 18057 | 63192 | 551 |
2093606 | 2093606 | 2022-01-08 | Hamilton | Indiana | 18057 | 63192 | 551 |
2090354 | 2090354 | 2022-01-07 | Hamilton | Indiana | 18057 | 63192 | 551 |
2087103 | 2087103 | 2022-01-06 | Hamilton | Indiana | 18057 | 62454 | 548 |
2083851 | 2083851 | 2022-01-05 | Hamilton | Indiana | 18057 | 61310 | 547 |
2080599 | 2080599 | 2022-01-04 | Hamilton | Indiana | 18057 | 60676 | 546 |
2077347 | 2077347 | 2022-01-03 | Hamilton | Indiana | 18057 | 60308 | 541 |
2074096 | 2074096 | 2022-01-02 | Hamilton | Indiana | 18057 | 57908 | 539 |
2070845 | 2070845 | 2022-01-01 | Hamilton | Indiana | 18057 | 57908 | 539 |
2067594 | 2067594 | 2021-12-31 | Hamilton | Indiana | 18057 | 57908 | 539 |
2064343 | 2064343 | 2021-12-30 | Hamilton | Indiana | 18057 | 57908 | 539 |
2061093 | 2061093 | 2021-12-29 | Hamilton | Indiana | 18057 | 57156 | 538 |
2057844 | 2057844 | 2021-12-28 | Hamilton | Indiana | 18057 | 56697 | 538 |
2054595 | 2054595 | 2021-12-27 | Hamilton | Indiana | 18057 | 56402 | 534 |
2051345 | 2051345 | 2021-12-26 | Hamilton | Indiana | 18057 | 55189 | 534 |
2048095 | 2048095 | 2021-12-25 | Hamilton | Indiana | 18057 | 55189 | 534 |
2044845 | 2044845 | 2021-12-24 | Hamilton | Indiana | 18057 | 55189 | 534 |
2041596 | 2041596 | 2021-12-23 | Hamilton | Indiana | 18057 | 55189 | 534 |
2038346 | 2038346 | 2021-12-22 | Hamilton | Indiana | 18057 | 55189 | 534 |
2035096 | 2035096 | 2021-12-21 | Hamilton | Indiana | 18057 | 54947 | 532 |
2031846 | 2031846 | 2021-12-20 | Hamilton | Indiana | 18057 | 54784 | 526 |
2028595 | 2028595 | 2021-12-19 | Hamilton | Indiana | 18057 | 54177 | 525 |
2025344 | 2025344 | 2021-12-18 | Hamilton | Indiana | 18057 | 54177 | 525 |
2022093 | 2022093 | 2021-12-17 | Hamilton | Indiana | 18057 | 54177 | 525 |
2018842 | 2018842 | 2021-12-16 | Hamilton | Indiana | 18057 | 53938 | 525 |
2015592 | 2015592 | 2021-12-15 | Hamilton | Indiana | 18057 | 53696 | 523 |
2012341 | 2012341 | 2021-12-14 | Hamilton | Indiana | 18057 | 53530 | 521 |
2009090 | 2009090 | 2021-12-13 | Hamilton | Indiana | 18057 | 53298 | 521 |
2005839 | 2005839 | 2021-12-12 | Hamilton | Indiana | 18057 | 52750 | 519 |
2002588 | 2002588 | 2021-12-11 | Hamilton | Indiana | 18057 | 52750 | 519 |
1999338 | 1999338 | 2021-12-10 | Hamilton | Indiana | 18057 | 52750 | 519 |
1996087 | 1996087 | 2021-12-09 | Hamilton | Indiana | 18057 | 52515 | 519 |
1992836 | 1992836 | 2021-12-08 | Hamilton | Indiana | 18057 | 52211 | 519 |
1989585 | 1989585 | 2021-12-07 | Hamilton | Indiana | 18057 | 52014 | 518 |
1986335 | 1986335 | 2021-12-06 | Hamilton | Indiana | 18057 | 51796 | 517 |
1983085 | 1983085 | 2021-12-05 | Hamilton | Indiana | 18057 | 51117 | 516 |
1979835 | 1979835 | 2021-12-04 | Hamilton | Indiana | 18057 | 51117 | 516 |
1976585 | 1976585 | 2021-12-03 | Hamilton | Indiana | 18057 | 51117 | 516 |
1973336 | 1973336 | 2021-12-02 | Hamilton | Indiana | 18057 | 50895 | 516 |
1970086 | 1970086 | 2021-12-01 | Hamilton | Indiana | 18057 | 50624 | 516 |
1966836 | 1966836 | 2021-11-30 | Hamilton | Indiana | 18057 | 50379 | 513 |
1963584 | 1963584 | 2021-11-29 | Hamilton | Indiana | 18057 | 50204 | 511 |
1960333 | 1960333 | 2021-11-28 | Hamilton | Indiana | 18057 | 49538 | 510 |
1957082 | 1957082 | 2021-11-27 | Hamilton | Indiana | 18057 | 49538 | 510 |
1953831 | 1953831 | 2021-11-26 | Hamilton | Indiana | 18057 | 49538 | 510 |
1950580 | 1950580 | 2021-11-25 | Hamilton | Indiana | 18057 | 49538 | 510 |
1947329 | 1947329 | 2021-11-24 | Hamilton | Indiana | 18057 | 49538 | 510 |
1944078 | 1944078 | 2021-11-23 | Hamilton | Indiana | 18057 | 49421 | 509 |
1940828 | 1940828 | 2021-11-22 | Hamilton | Indiana | 18057 | 49294 | 508 |
1937578 | 1937578 | 2021-11-21 | Hamilton | Indiana | 18057 | 48924 | 507 |
1934328 | 1934328 | 2021-11-20 | Hamilton | Indiana | 18057 | 48924 | 507 |
1931077 | 1931077 | 2021-11-19 | Hamilton | Indiana | 18057 | 48924 | 507 |
1927826 | 1927826 | 2021-11-18 | Hamilton | Indiana | 18057 | 48755 | 507 |
1924576 | 1924576 | 2021-11-17 | Hamilton | Indiana | 18057 | 48579 | 505 |
1921327 | 1921327 | 2021-11-16 | Hamilton | Indiana | 18057 | 48422 | 504 |
1918077 | 1918077 | 2021-11-15 | Hamilton | Indiana | 18057 | 48289 | 504 |
1914827 | 1914827 | 2021-11-14 | Hamilton | Indiana | 18057 | 48019 | 504 |
1911577 | 1911577 | 2021-11-13 | Hamilton | Indiana | 18057 | 48019 | 504 |
1908328 | 1908328 | 2021-11-12 | Hamilton | Indiana | 18057 | 48019 | 504 |
1905079 | 1905079 | 2021-11-11 | Hamilton | Indiana | 18057 | 47925 | 504 |
1901829 | 1901829 | 2021-11-10 | Hamilton | Indiana | 18057 | 47682 | 504 |
1898579 | 1898579 | 2021-11-09 | Hamilton | Indiana | 18057 | 47577 | 503 |
1895329 | 1895329 | 2021-11-08 | Hamilton | Indiana | 18057 | 47494 | 502 |
1892079 | 1892079 | 2021-11-07 | Hamilton | Indiana | 18057 | 47295 | 502 |
1888829 | 1888829 | 2021-11-06 | Hamilton | Indiana | 18057 | 47295 | 502 |
1885579 | 1885579 | 2021-11-05 | Hamilton | Indiana | 18057 | 47295 | 502 |
1882330 | 1882330 | 2021-11-04 | Hamilton | Indiana | 18057 | 47216 | 502 |
1879081 | 1879081 | 2021-11-03 | Hamilton | Indiana | 18057 | 47122 | 502 |
1875832 | 1875832 | 2021-11-02 | Hamilton | Indiana | 18057 | 47029 | 501 |
1872583 | 1872583 | 2021-11-01 | Hamilton | Indiana | 18057 | 46977 | 500 |
1869334 | 1869334 | 2021-10-31 | Hamilton | Indiana | 18057 | 46826 | 498 |
1866085 | 1866085 | 2021-10-30 | Hamilton | Indiana | 18057 | 46826 | 498 |
1862836 | 1862836 | 2021-10-29 | Hamilton | Indiana | 18057 | 46826 | 498 |
1859587 | 1859587 | 2021-10-28 | Hamilton | Indiana | 18057 | 46755 | 496 |
1856338 | 1856338 | 2021-10-27 | Hamilton | Indiana | 18057 | 46674 | 496 |
1853089 | 1853089 | 2021-10-26 | Hamilton | Indiana | 18057 | 46600 | 495 |
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);