ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Hamilton" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1849840 | 1849840 | 2021-10-25 | Hamilton | Indiana | 18057 | 46553 | 494 |
1846590 | 1846590 | 2021-10-24 | Hamilton | Indiana | 18057 | 46405 | 492 |
1843340 | 1843340 | 2021-10-23 | Hamilton | Indiana | 18057 | 46405 | 492 |
1840090 | 1840090 | 2021-10-22 | Hamilton | Indiana | 18057 | 46405 | 492 |
1836841 | 1836841 | 2021-10-21 | Hamilton | Indiana | 18057 | 46351 | 491 |
1833592 | 1833592 | 2021-10-20 | Hamilton | Indiana | 18057 | 46272 | 491 |
1830343 | 1830343 | 2021-10-19 | Hamilton | Indiana | 18057 | 46211 | 490 |
1827094 | 1827094 | 2021-10-18 | Hamilton | Indiana | 18057 | 46154 | 487 |
1823845 | 1823845 | 2021-10-17 | Hamilton | Indiana | 18057 | 46017 | 486 |
1820596 | 1820596 | 2021-10-16 | Hamilton | Indiana | 18057 | 46017 | 486 |
1817347 | 1817347 | 2021-10-15 | Hamilton | Indiana | 18057 | 46017 | 486 |
1814099 | 1814099 | 2021-10-14 | Hamilton | Indiana | 18057 | 45931 | 486 |
1810850 | 1810850 | 2021-10-13 | Hamilton | Indiana | 18057 | 45852 | 482 |
1807601 | 1807601 | 2021-10-12 | Hamilton | Indiana | 18057 | 45745 | 479 |
1804350 | 1804350 | 2021-10-11 | Hamilton | Indiana | 18057 | 45688 | 478 |
1801101 | 1801101 | 2021-10-10 | Hamilton | Indiana | 18057 | 45464 | 477 |
1797852 | 1797852 | 2021-10-09 | Hamilton | Indiana | 18057 | 45464 | 477 |
1794603 | 1794603 | 2021-10-08 | Hamilton | Indiana | 18057 | 45464 | 477 |
1791355 | 1791355 | 2021-10-07 | Hamilton | Indiana | 18057 | 45330 | 476 |
1788106 | 1788106 | 2021-10-06 | Hamilton | Indiana | 18057 | 45286 | 475 |
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);