ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Harrison" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109864 | 2109864 | 2022-01-13 | Harrison | Indiana | 18061 | 8357 | 115 |
2106613 | 2106613 | 2022-01-12 | Harrison | Indiana | 18061 | 8260 | 115 |
2103362 | 2103362 | 2022-01-11 | Harrison | Indiana | 18061 | 8168 | 115 |
2100111 | 2100111 | 2022-01-10 | Harrison | Indiana | 18061 | 8124 | 115 |
2096860 | 2096860 | 2022-01-09 | Harrison | Indiana | 18061 | 7951 | 114 |
2093608 | 2093608 | 2022-01-08 | Harrison | Indiana | 18061 | 7951 | 114 |
2090356 | 2090356 | 2022-01-07 | Harrison | Indiana | 18061 | 7951 | 114 |
2087105 | 2087105 | 2022-01-06 | Harrison | Indiana | 18061 | 7881 | 112 |
2083853 | 2083853 | 2022-01-05 | Harrison | Indiana | 18061 | 7826 | 111 |
2080601 | 2080601 | 2022-01-04 | Harrison | Indiana | 18061 | 7774 | 111 |
2077349 | 2077349 | 2022-01-03 | Harrison | Indiana | 18061 | 7755 | 110 |
2074098 | 2074098 | 2022-01-02 | Harrison | Indiana | 18061 | 7655 | 110 |
2070847 | 2070847 | 2022-01-01 | Harrison | Indiana | 18061 | 7655 | 110 |
2067596 | 2067596 | 2021-12-31 | Harrison | Indiana | 18061 | 7655 | 110 |
2064345 | 2064345 | 2021-12-30 | Harrison | Indiana | 18061 | 7655 | 110 |
2061095 | 2061095 | 2021-12-29 | Harrison | Indiana | 18061 | 7603 | 111 |
2057846 | 2057846 | 2021-12-28 | Harrison | Indiana | 18061 | 7577 | 111 |
2054597 | 2054597 | 2021-12-27 | Harrison | Indiana | 18061 | 7548 | 110 |
2051347 | 2051347 | 2021-12-26 | Harrison | Indiana | 18061 | 7453 | 110 |
2048097 | 2048097 | 2021-12-25 | Harrison | Indiana | 18061 | 7453 | 110 |
2044847 | 2044847 | 2021-12-24 | Harrison | Indiana | 18061 | 7453 | 110 |
2041598 | 2041598 | 2021-12-23 | Harrison | Indiana | 18061 | 7453 | 110 |
2038348 | 2038348 | 2021-12-22 | Harrison | Indiana | 18061 | 7453 | 110 |
2035098 | 2035098 | 2021-12-21 | Harrison | Indiana | 18061 | 7441 | 109 |
2031848 | 2031848 | 2021-12-20 | Harrison | Indiana | 18061 | 7421 | 107 |
2028597 | 2028597 | 2021-12-19 | Harrison | Indiana | 18061 | 7340 | 106 |
2025346 | 2025346 | 2021-12-18 | Harrison | Indiana | 18061 | 7340 | 106 |
2022095 | 2022095 | 2021-12-17 | Harrison | Indiana | 18061 | 7340 | 106 |
2018844 | 2018844 | 2021-12-16 | Harrison | Indiana | 18061 | 7307 | 105 |
2015594 | 2015594 | 2021-12-15 | Harrison | Indiana | 18061 | 7276 | 105 |
2012343 | 2012343 | 2021-12-14 | Harrison | Indiana | 18061 | 7252 | 105 |
2009092 | 2009092 | 2021-12-13 | Harrison | Indiana | 18061 | 7237 | 105 |
2005841 | 2005841 | 2021-12-12 | Harrison | Indiana | 18061 | 7170 | 104 |
2002590 | 2002590 | 2021-12-11 | Harrison | Indiana | 18061 | 7170 | 104 |
1999340 | 1999340 | 2021-12-10 | Harrison | Indiana | 18061 | 7170 | 104 |
1996089 | 1996089 | 2021-12-09 | Harrison | Indiana | 18061 | 7136 | 103 |
1992838 | 1992838 | 2021-12-08 | Harrison | Indiana | 18061 | 7090 | 103 |
1989587 | 1989587 | 2021-12-07 | Harrison | Indiana | 18061 | 7067 | 103 |
1986337 | 1986337 | 2021-12-06 | Harrison | Indiana | 18061 | 7036 | 103 |
1983087 | 1983087 | 2021-12-05 | Harrison | Indiana | 18061 | 6959 | 103 |
1979837 | 1979837 | 2021-12-04 | Harrison | Indiana | 18061 | 6959 | 103 |
1976587 | 1976587 | 2021-12-03 | Harrison | Indiana | 18061 | 6959 | 103 |
1973338 | 1973338 | 2021-12-02 | Harrison | Indiana | 18061 | 6928 | 103 |
1970088 | 1970088 | 2021-12-01 | Harrison | Indiana | 18061 | 6910 | 103 |
1966838 | 1966838 | 2021-11-30 | Harrison | Indiana | 18061 | 6887 | 101 |
1963586 | 1963586 | 2021-11-29 | Harrison | Indiana | 18061 | 6857 | 99 |
1960335 | 1960335 | 2021-11-28 | Harrison | Indiana | 18061 | 6811 | 99 |
1957084 | 1957084 | 2021-11-27 | Harrison | Indiana | 18061 | 6811 | 99 |
1953833 | 1953833 | 2021-11-26 | Harrison | Indiana | 18061 | 6811 | 99 |
1950582 | 1950582 | 2021-11-25 | Harrison | Indiana | 18061 | 6811 | 99 |
1947331 | 1947331 | 2021-11-24 | Harrison | Indiana | 18061 | 6811 | 99 |
1944080 | 1944080 | 2021-11-23 | Harrison | Indiana | 18061 | 6805 | 98 |
1940830 | 1940830 | 2021-11-22 | Harrison | Indiana | 18061 | 6790 | 98 |
1937580 | 1937580 | 2021-11-21 | Harrison | Indiana | 18061 | 6751 | 98 |
1934330 | 1934330 | 2021-11-20 | Harrison | Indiana | 18061 | 6751 | 98 |
1931079 | 1931079 | 2021-11-19 | Harrison | Indiana | 18061 | 6751 | 98 |
1927828 | 1927828 | 2021-11-18 | Harrison | Indiana | 18061 | 6740 | 98 |
1924578 | 1924578 | 2021-11-17 | Harrison | Indiana | 18061 | 6734 | 98 |
1921329 | 1921329 | 2021-11-16 | Harrison | Indiana | 18061 | 6729 | 98 |
1918079 | 1918079 | 2021-11-15 | Harrison | Indiana | 18061 | 6710 | 98 |
1914829 | 1914829 | 2021-11-14 | Harrison | Indiana | 18061 | 6696 | 98 |
1911579 | 1911579 | 2021-11-13 | Harrison | Indiana | 18061 | 6696 | 98 |
1908330 | 1908330 | 2021-11-12 | Harrison | Indiana | 18061 | 6696 | 98 |
1905081 | 1905081 | 2021-11-11 | Harrison | Indiana | 18061 | 6687 | 98 |
1901831 | 1901831 | 2021-11-10 | Harrison | Indiana | 18061 | 6644 | 98 |
1898581 | 1898581 | 2021-11-09 | Harrison | Indiana | 18061 | 6636 | 98 |
1895331 | 1895331 | 2021-11-08 | Harrison | Indiana | 18061 | 6632 | 97 |
1892081 | 1892081 | 2021-11-07 | Harrison | Indiana | 18061 | 6612 | 97 |
1888831 | 1888831 | 2021-11-06 | Harrison | Indiana | 18061 | 6612 | 97 |
1885581 | 1885581 | 2021-11-05 | Harrison | Indiana | 18061 | 6612 | 97 |
1882332 | 1882332 | 2021-11-04 | Harrison | Indiana | 18061 | 6598 | 97 |
1879083 | 1879083 | 2021-11-03 | Harrison | Indiana | 18061 | 6588 | 97 |
1875834 | 1875834 | 2021-11-02 | Harrison | Indiana | 18061 | 6585 | 97 |
1872585 | 1872585 | 2021-11-01 | Harrison | Indiana | 18061 | 6583 | 98 |
1869336 | 1869336 | 2021-10-31 | Harrison | Indiana | 18061 | 6574 | 98 |
1866087 | 1866087 | 2021-10-30 | Harrison | Indiana | 18061 | 6574 | 98 |
1862838 | 1862838 | 2021-10-29 | Harrison | Indiana | 18061 | 6574 | 98 |
1859589 | 1859589 | 2021-10-28 | Harrison | Indiana | 18061 | 6561 | 97 |
1856340 | 1856340 | 2021-10-27 | Harrison | Indiana | 18061 | 6550 | 96 |
1853091 | 1853091 | 2021-10-26 | Harrison | Indiana | 18061 | 6537 | 96 |
1849842 | 1849842 | 2021-10-25 | Harrison | Indiana | 18061 | 6523 | 95 |
1846592 | 1846592 | 2021-10-24 | Harrison | Indiana | 18061 | 6496 | 95 |
1843342 | 1843342 | 2021-10-23 | Harrison | Indiana | 18061 | 6496 | 95 |
1840092 | 1840092 | 2021-10-22 | Harrison | Indiana | 18061 | 6496 | 95 |
1836843 | 1836843 | 2021-10-21 | Harrison | Indiana | 18061 | 6480 | 94 |
1833594 | 1833594 | 2021-10-20 | Harrison | Indiana | 18061 | 6471 | 94 |
1830345 | 1830345 | 2021-10-19 | Harrison | Indiana | 18061 | 6463 | 94 |
1827096 | 1827096 | 2021-10-18 | Harrison | Indiana | 18061 | 6449 | 94 |
1823847 | 1823847 | 2021-10-17 | Harrison | Indiana | 18061 | 6420 | 94 |
1820598 | 1820598 | 2021-10-16 | Harrison | Indiana | 18061 | 6420 | 94 |
1817349 | 1817349 | 2021-10-15 | Harrison | Indiana | 18061 | 6420 | 94 |
1814101 | 1814101 | 2021-10-14 | Harrison | Indiana | 18061 | 6401 | 94 |
1810852 | 1810852 | 2021-10-13 | Harrison | Indiana | 18061 | 6389 | 94 |
1807603 | 1807603 | 2021-10-12 | Harrison | Indiana | 18061 | 6375 | 94 |
1804352 | 1804352 | 2021-10-11 | Harrison | Indiana | 18061 | 6366 | 94 |
1801103 | 1801103 | 2021-10-10 | Harrison | Indiana | 18061 | 6317 | 93 |
1797854 | 1797854 | 2021-10-09 | Harrison | Indiana | 18061 | 6317 | 93 |
1794605 | 1794605 | 2021-10-08 | Harrison | Indiana | 18061 | 6317 | 93 |
1791357 | 1791357 | 2021-10-07 | Harrison | Indiana | 18061 | 6280 | 93 |
1788108 | 1788108 | 2021-10-06 | Harrison | Indiana | 18061 | 6264 | 93 |
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);