ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Warren" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174985 | 2174985 | 2022-02-02 | Warren | Indiana | 18171 | 1988 | 24 |
2171732 | 2171732 | 2022-02-01 | Warren | Indiana | 18171 | 1963 | 24 |
2168479 | 2168479 | 2022-01-31 | Warren | Indiana | 18171 | 1959 | 24 |
2165224 | 2165224 | 2022-01-30 | Warren | Indiana | 18171 | 1934 | 24 |
2161969 | 2161969 | 2022-01-29 | Warren | Indiana | 18171 | 1934 | 24 |
2158714 | 2158714 | 2022-01-28 | Warren | Indiana | 18171 | 1934 | 24 |
2155460 | 2155460 | 2022-01-27 | Warren | Indiana | 18171 | 1897 | 24 |
2152207 | 2152207 | 2022-01-26 | Warren | Indiana | 18171 | 1867 | 24 |
2148955 | 2148955 | 2022-01-25 | Warren | Indiana | 18171 | 1861 | 24 |
2145703 | 2145703 | 2022-01-24 | Warren | Indiana | 18171 | 1842 | 24 |
2142448 | 2142448 | 2022-01-23 | Warren | Indiana | 18171 | 1798 | 24 |
2139193 | 2139193 | 2022-01-22 | Warren | Indiana | 18171 | 1798 | 24 |
2135937 | 2135937 | 2022-01-21 | Warren | Indiana | 18171 | 1798 | 24 |
2132685 | 2132685 | 2022-01-20 | Warren | Indiana | 18171 | 1762 | 24 |
2129432 | 2129432 | 2022-01-19 | Warren | Indiana | 18171 | 1751 | 23 |
2126178 | 2126178 | 2022-01-18 | Warren | Indiana | 18171 | 1711 | 22 |
2122926 | 2122926 | 2022-01-17 | Warren | Indiana | 18171 | 1698 | 22 |
2119674 | 2119674 | 2022-01-16 | Warren | Indiana | 18171 | 1669 | 22 |
2116422 | 2116422 | 2022-01-15 | Warren | Indiana | 18171 | 1669 | 22 |
2113171 | 2113171 | 2022-01-14 | Warren | Indiana | 18171 | 1669 | 22 |
2109919 | 2109919 | 2022-01-13 | Warren | Indiana | 18171 | 1663 | 22 |
2106668 | 2106668 | 2022-01-12 | Warren | Indiana | 18171 | 1642 | 22 |
2103417 | 2103417 | 2022-01-11 | Warren | Indiana | 18171 | 1630 | 22 |
2100166 | 2100166 | 2022-01-10 | Warren | Indiana | 18171 | 1611 | 22 |
2096915 | 2096915 | 2022-01-09 | Warren | Indiana | 18171 | 1585 | 22 |
2093663 | 2093663 | 2022-01-08 | Warren | Indiana | 18171 | 1585 | 22 |
2090411 | 2090411 | 2022-01-07 | Warren | Indiana | 18171 | 1585 | 22 |
2087160 | 2087160 | 2022-01-06 | Warren | Indiana | 18171 | 1573 | 22 |
2083908 | 2083908 | 2022-01-05 | Warren | Indiana | 18171 | 1562 | 22 |
2080656 | 2080656 | 2022-01-04 | Warren | Indiana | 18171 | 1559 | 22 |
2077404 | 2077404 | 2022-01-03 | Warren | Indiana | 18171 | 1548 | 22 |
2074153 | 2074153 | 2022-01-02 | Warren | Indiana | 18171 | 1538 | 22 |
2070902 | 2070902 | 2022-01-01 | Warren | Indiana | 18171 | 1538 | 22 |
2067651 | 2067651 | 2021-12-31 | Warren | Indiana | 18171 | 1538 | 22 |
2064400 | 2064400 | 2021-12-30 | Warren | Indiana | 18171 | 1538 | 22 |
2061150 | 2061150 | 2021-12-29 | Warren | Indiana | 18171 | 1528 | 22 |
2057901 | 2057901 | 2021-12-28 | Warren | Indiana | 18171 | 1523 | 22 |
2054652 | 2054652 | 2021-12-27 | Warren | Indiana | 18171 | 1520 | 22 |
2051402 | 2051402 | 2021-12-26 | Warren | Indiana | 18171 | 1499 | 22 |
2048152 | 2048152 | 2021-12-25 | Warren | Indiana | 18171 | 1499 | 22 |
2044902 | 2044902 | 2021-12-24 | Warren | Indiana | 18171 | 1499 | 22 |
2041653 | 2041653 | 2021-12-23 | Warren | Indiana | 18171 | 1499 | 22 |
2038403 | 2038403 | 2021-12-22 | Warren | Indiana | 18171 | 1499 | 22 |
2035153 | 2035153 | 2021-12-21 | Warren | Indiana | 18171 | 1494 | 22 |
2031903 | 2031903 | 2021-12-20 | Warren | Indiana | 18171 | 1492 | 22 |
2028652 | 2028652 | 2021-12-19 | Warren | Indiana | 18171 | 1473 | 22 |
2025401 | 2025401 | 2021-12-18 | Warren | Indiana | 18171 | 1473 | 22 |
2022150 | 2022150 | 2021-12-17 | Warren | Indiana | 18171 | 1473 | 22 |
2018899 | 2018899 | 2021-12-16 | Warren | Indiana | 18171 | 1459 | 21 |
2015649 | 2015649 | 2021-12-15 | Warren | Indiana | 18171 | 1453 | 21 |
2012398 | 2012398 | 2021-12-14 | Warren | Indiana | 18171 | 1449 | 19 |
2009147 | 2009147 | 2021-12-13 | Warren | Indiana | 18171 | 1444 | 19 |
2005896 | 2005896 | 2021-12-12 | Warren | Indiana | 18171 | 1427 | 19 |
2002645 | 2002645 | 2021-12-11 | Warren | Indiana | 18171 | 1427 | 19 |
1999395 | 1999395 | 2021-12-10 | Warren | Indiana | 18171 | 1427 | 19 |
1996144 | 1996144 | 2021-12-09 | Warren | Indiana | 18171 | 1420 | 19 |
1992893 | 1992893 | 2021-12-08 | Warren | Indiana | 18171 | 1408 | 19 |
1989642 | 1989642 | 2021-12-07 | Warren | Indiana | 18171 | 1390 | 19 |
1986392 | 1986392 | 2021-12-06 | Warren | Indiana | 18171 | 1381 | 18 |
1983142 | 1983142 | 2021-12-05 | Warren | Indiana | 18171 | 1361 | 18 |
1979892 | 1979892 | 2021-12-04 | Warren | Indiana | 18171 | 1361 | 18 |
1976642 | 1976642 | 2021-12-03 | Warren | Indiana | 18171 | 1361 | 18 |
1973393 | 1973393 | 2021-12-02 | Warren | Indiana | 18171 | 1356 | 18 |
1970143 | 1970143 | 2021-12-01 | Warren | Indiana | 18171 | 1342 | 18 |
1966893 | 1966893 | 2021-11-30 | Warren | Indiana | 18171 | 1326 | 18 |
1963641 | 1963641 | 2021-11-29 | Warren | Indiana | 18171 | 1325 | 18 |
1960390 | 1960390 | 2021-11-28 | Warren | Indiana | 18171 | 1317 | 18 |
1957139 | 1957139 | 2021-11-27 | Warren | Indiana | 18171 | 1317 | 18 |
1953888 | 1953888 | 2021-11-26 | Warren | Indiana | 18171 | 1317 | 18 |
1950637 | 1950637 | 2021-11-25 | Warren | Indiana | 18171 | 1317 | 18 |
1947386 | 1947386 | 2021-11-24 | Warren | Indiana | 18171 | 1317 | 18 |
1944135 | 1944135 | 2021-11-23 | Warren | Indiana | 18171 | 1312 | 18 |
1940885 | 1940885 | 2021-11-22 | Warren | Indiana | 18171 | 1307 | 18 |
1937635 | 1937635 | 2021-11-21 | Warren | Indiana | 18171 | 1297 | 18 |
1934385 | 1934385 | 2021-11-20 | Warren | Indiana | 18171 | 1297 | 18 |
1931134 | 1931134 | 2021-11-19 | Warren | Indiana | 18171 | 1297 | 18 |
1927883 | 1927883 | 2021-11-18 | Warren | Indiana | 18171 | 1295 | 18 |
1924633 | 1924633 | 2021-11-17 | Warren | Indiana | 18171 | 1281 | 18 |
1921384 | 1921384 | 2021-11-16 | Warren | Indiana | 18171 | 1274 | 18 |
1918134 | 1918134 | 2021-11-15 | Warren | Indiana | 18171 | 1268 | 18 |
1914884 | 1914884 | 2021-11-14 | Warren | Indiana | 18171 | 1263 | 18 |
1911634 | 1911634 | 2021-11-13 | Warren | Indiana | 18171 | 1263 | 18 |
1908385 | 1908385 | 2021-11-12 | Warren | Indiana | 18171 | 1263 | 18 |
1905136 | 1905136 | 2021-11-11 | Warren | Indiana | 18171 | 1263 | 18 |
1901886 | 1901886 | 2021-11-10 | Warren | Indiana | 18171 | 1252 | 18 |
1898636 | 1898636 | 2021-11-09 | Warren | Indiana | 18171 | 1250 | 18 |
1895386 | 1895386 | 2021-11-08 | Warren | Indiana | 18171 | 1244 | 18 |
1892136 | 1892136 | 2021-11-07 | Warren | Indiana | 18171 | 1238 | 18 |
1888886 | 1888886 | 2021-11-06 | Warren | Indiana | 18171 | 1238 | 18 |
1885636 | 1885636 | 2021-11-05 | Warren | Indiana | 18171 | 1238 | 18 |
1882387 | 1882387 | 2021-11-04 | Warren | Indiana | 18171 | 1237 | 18 |
1879138 | 1879138 | 2021-11-03 | Warren | Indiana | 18171 | 1236 | 18 |
1875889 | 1875889 | 2021-11-02 | Warren | Indiana | 18171 | 1230 | 18 |
1872640 | 1872640 | 2021-11-01 | Warren | Indiana | 18171 | 1227 | 18 |
1869391 | 1869391 | 2021-10-31 | Warren | Indiana | 18171 | 1225 | 18 |
1866142 | 1866142 | 2021-10-30 | Warren | Indiana | 18171 | 1225 | 18 |
1862893 | 1862893 | 2021-10-29 | Warren | Indiana | 18171 | 1225 | 18 |
1859644 | 1859644 | 2021-10-28 | Warren | Indiana | 18171 | 1223 | 18 |
1856395 | 1856395 | 2021-10-27 | Warren | Indiana | 18171 | 1219 | 18 |
1853146 | 1853146 | 2021-10-26 | Warren | Indiana | 18171 | 1217 | 18 |
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);