ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 18017 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109842 | 2109842 | 2022-01-13 | Cass | Indiana | 18017 | 9516 | 146 |
2106591 | 2106591 | 2022-01-12 | Cass | Indiana | 18017 | 9440 | 146 |
2103340 | 2103340 | 2022-01-11 | Cass | Indiana | 18017 | 9379 | 146 |
2100089 | 2100089 | 2022-01-10 | Cass | Indiana | 18017 | 9241 | 146 |
2096838 | 2096838 | 2022-01-09 | Cass | Indiana | 18017 | 9137 | 143 |
2093586 | 2093586 | 2022-01-08 | Cass | Indiana | 18017 | 9137 | 143 |
2090334 | 2090334 | 2022-01-07 | Cass | Indiana | 18017 | 9137 | 143 |
2087083 | 2087083 | 2022-01-06 | Cass | Indiana | 18017 | 9090 | 141 |
2083831 | 2083831 | 2022-01-05 | Cass | Indiana | 18017 | 9060 | 141 |
2080579 | 2080579 | 2022-01-04 | Cass | Indiana | 18017 | 9035 | 141 |
2077327 | 2077327 | 2022-01-03 | Cass | Indiana | 18017 | 9007 | 141 |
2074076 | 2074076 | 2022-01-02 | Cass | Indiana | 18017 | 8894 | 141 |
2070825 | 2070825 | 2022-01-01 | Cass | Indiana | 18017 | 8894 | 141 |
2067574 | 2067574 | 2021-12-31 | Cass | Indiana | 18017 | 8894 | 141 |
2064323 | 2064323 | 2021-12-30 | Cass | Indiana | 18017 | 8894 | 141 |
2061073 | 2061073 | 2021-12-29 | Cass | Indiana | 18017 | 8839 | 141 |
2057824 | 2057824 | 2021-12-28 | Cass | Indiana | 18017 | 8816 | 140 |
2054575 | 2054575 | 2021-12-27 | Cass | Indiana | 18017 | 8777 | 139 |
2051325 | 2051325 | 2021-12-26 | Cass | Indiana | 18017 | 8699 | 139 |
2048075 | 2048075 | 2021-12-25 | Cass | Indiana | 18017 | 8699 | 139 |
2044825 | 2044825 | 2021-12-24 | Cass | Indiana | 18017 | 8699 | 139 |
2041576 | 2041576 | 2021-12-23 | Cass | Indiana | 18017 | 8699 | 139 |
2038326 | 2038326 | 2021-12-22 | Cass | Indiana | 18017 | 8699 | 139 |
2035076 | 2035076 | 2021-12-21 | Cass | Indiana | 18017 | 8669 | 139 |
2031826 | 2031826 | 2021-12-20 | Cass | Indiana | 18017 | 8634 | 138 |
2028575 | 2028575 | 2021-12-19 | Cass | Indiana | 18017 | 8579 | 138 |
2025324 | 2025324 | 2021-12-18 | Cass | Indiana | 18017 | 8579 | 138 |
2022073 | 2022073 | 2021-12-17 | Cass | Indiana | 18017 | 8579 | 138 |
2018822 | 2018822 | 2021-12-16 | Cass | Indiana | 18017 | 8555 | 137 |
2015572 | 2015572 | 2021-12-15 | Cass | Indiana | 18017 | 8535 | 137 |
2012321 | 2012321 | 2021-12-14 | Cass | Indiana | 18017 | 8477 | 136 |
2009070 | 2009070 | 2021-12-13 | Cass | Indiana | 18017 | 8455 | 134 |
2005819 | 2005819 | 2021-12-12 | Cass | Indiana | 18017 | 8387 | 133 |
2002568 | 2002568 | 2021-12-11 | Cass | Indiana | 18017 | 8387 | 133 |
1999318 | 1999318 | 2021-12-10 | Cass | Indiana | 18017 | 8387 | 133 |
1996067 | 1996067 | 2021-12-09 | Cass | Indiana | 18017 | 8347 | 130 |
1992816 | 1992816 | 2021-12-08 | Cass | Indiana | 18017 | 8316 | 130 |
1989565 | 1989565 | 2021-12-07 | Cass | Indiana | 18017 | 8288 | 130 |
1986315 | 1986315 | 2021-12-06 | Cass | Indiana | 18017 | 8249 | 130 |
1983065 | 1983065 | 2021-12-05 | Cass | Indiana | 18017 | 8175 | 130 |
1979815 | 1979815 | 2021-12-04 | Cass | Indiana | 18017 | 8175 | 130 |
1976565 | 1976565 | 2021-12-03 | Cass | Indiana | 18017 | 8175 | 130 |
1973316 | 1973316 | 2021-12-02 | Cass | Indiana | 18017 | 8142 | 129 |
1970066 | 1970066 | 2021-12-01 | Cass | Indiana | 18017 | 8107 | 129 |
1966816 | 1966816 | 2021-11-30 | Cass | Indiana | 18017 | 8063 | 129 |
1963564 | 1963564 | 2021-11-29 | Cass | Indiana | 18017 | 8022 | 129 |
1960313 | 1960313 | 2021-11-28 | Cass | Indiana | 18017 | 7915 | 128 |
1957062 | 1957062 | 2021-11-27 | Cass | Indiana | 18017 | 7915 | 128 |
1953811 | 1953811 | 2021-11-26 | Cass | Indiana | 18017 | 7915 | 128 |
1950560 | 1950560 | 2021-11-25 | Cass | Indiana | 18017 | 7915 | 128 |
1947309 | 1947309 | 2021-11-24 | Cass | Indiana | 18017 | 7915 | 128 |
1944058 | 1944058 | 2021-11-23 | Cass | Indiana | 18017 | 7893 | 128 |
1940808 | 1940808 | 2021-11-22 | Cass | Indiana | 18017 | 7872 | 128 |
1937558 | 1937558 | 2021-11-21 | Cass | Indiana | 18017 | 7822 | 128 |
1934308 | 1934308 | 2021-11-20 | Cass | Indiana | 18017 | 7822 | 128 |
1931057 | 1931057 | 2021-11-19 | Cass | Indiana | 18017 | 7822 | 128 |
1927806 | 1927806 | 2021-11-18 | Cass | Indiana | 18017 | 7818 | 128 |
1924556 | 1924556 | 2021-11-17 | Cass | Indiana | 18017 | 7806 | 128 |
1921307 | 1921307 | 2021-11-16 | Cass | Indiana | 18017 | 7776 | 127 |
1918057 | 1918057 | 2021-11-15 | Cass | Indiana | 18017 | 7762 | 127 |
1914807 | 1914807 | 2021-11-14 | Cass | Indiana | 18017 | 7743 | 127 |
1911557 | 1911557 | 2021-11-13 | Cass | Indiana | 18017 | 7743 | 127 |
1908308 | 1908308 | 2021-11-12 | Cass | Indiana | 18017 | 7743 | 127 |
1905059 | 1905059 | 2021-11-11 | Cass | Indiana | 18017 | 7731 | 127 |
1901809 | 1901809 | 2021-11-10 | Cass | Indiana | 18017 | 7688 | 127 |
1898559 | 1898559 | 2021-11-09 | Cass | Indiana | 18017 | 7678 | 127 |
1895309 | 1895309 | 2021-11-08 | Cass | Indiana | 18017 | 7666 | 127 |
1892059 | 1892059 | 2021-11-07 | Cass | Indiana | 18017 | 7652 | 127 |
1888809 | 1888809 | 2021-11-06 | Cass | Indiana | 18017 | 7652 | 127 |
1885559 | 1885559 | 2021-11-05 | Cass | Indiana | 18017 | 7652 | 127 |
1882310 | 1882310 | 2021-11-04 | Cass | Indiana | 18017 | 7646 | 127 |
1879061 | 1879061 | 2021-11-03 | Cass | Indiana | 18017 | 7637 | 126 |
1875812 | 1875812 | 2021-11-02 | Cass | Indiana | 18017 | 7631 | 126 |
1872563 | 1872563 | 2021-11-01 | Cass | Indiana | 18017 | 7624 | 126 |
1869314 | 1869314 | 2021-10-31 | Cass | Indiana | 18017 | 7611 | 126 |
1866065 | 1866065 | 2021-10-30 | Cass | Indiana | 18017 | 7611 | 126 |
1862816 | 1862816 | 2021-10-29 | Cass | Indiana | 18017 | 7611 | 126 |
1859567 | 1859567 | 2021-10-28 | Cass | Indiana | 18017 | 7602 | 125 |
1856318 | 1856318 | 2021-10-27 | Cass | Indiana | 18017 | 7592 | 125 |
1853069 | 1853069 | 2021-10-26 | Cass | Indiana | 18017 | 7577 | 125 |
1849820 | 1849820 | 2021-10-25 | Cass | Indiana | 18017 | 7564 | 125 |
1846570 | 1846570 | 2021-10-24 | Cass | Indiana | 18017 | 7554 | 123 |
1843320 | 1843320 | 2021-10-23 | Cass | Indiana | 18017 | 7554 | 123 |
1840070 | 1840070 | 2021-10-22 | Cass | Indiana | 18017 | 7554 | 123 |
1836821 | 1836821 | 2021-10-21 | Cass | Indiana | 18017 | 7536 | 123 |
1833572 | 1833572 | 2021-10-20 | Cass | Indiana | 18017 | 7527 | 123 |
1830323 | 1830323 | 2021-10-19 | Cass | Indiana | 18017 | 7518 | 122 |
1827074 | 1827074 | 2021-10-18 | Cass | Indiana | 18017 | 7507 | 121 |
1823825 | 1823825 | 2021-10-17 | Cass | Indiana | 18017 | 7470 | 121 |
1820576 | 1820576 | 2021-10-16 | Cass | Indiana | 18017 | 7470 | 121 |
1817327 | 1817327 | 2021-10-15 | Cass | Indiana | 18017 | 7470 | 121 |
1814079 | 1814079 | 2021-10-14 | Cass | Indiana | 18017 | 7459 | 121 |
1810830 | 1810830 | 2021-10-13 | Cass | Indiana | 18017 | 7439 | 121 |
1807581 | 1807581 | 2021-10-12 | Cass | Indiana | 18017 | 7417 | 121 |
1804330 | 1804330 | 2021-10-11 | Cass | Indiana | 18017 | 7407 | 121 |
1801081 | 1801081 | 2021-10-10 | Cass | Indiana | 18017 | 7382 | 121 |
1797832 | 1797832 | 2021-10-09 | Cass | Indiana | 18017 | 7382 | 121 |
1794583 | 1794583 | 2021-10-08 | Cass | Indiana | 18017 | 7382 | 121 |
1791335 | 1791335 | 2021-10-07 | Cass | Indiana | 18017 | 7365 | 121 |
1788086 | 1788086 | 2021-10-06 | Cass | Indiana | 18017 | 7340 | 121 |
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);