ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Crawford" and fips = 18025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174912 | 2174912 | 2022-02-02 | Crawford | Indiana | 18025 | 2397 | 35 |
2171659 | 2171659 | 2022-02-01 | Crawford | Indiana | 18025 | 2383 | 35 |
2168406 | 2168406 | 2022-01-31 | Crawford | Indiana | 18025 | 2370 | 35 |
2165151 | 2165151 | 2022-01-30 | Crawford | Indiana | 18025 | 2330 | 35 |
2161896 | 2161896 | 2022-01-29 | Crawford | Indiana | 18025 | 2330 | 35 |
2158641 | 2158641 | 2022-01-28 | Crawford | Indiana | 18025 | 2330 | 35 |
2155387 | 2155387 | 2022-01-27 | Crawford | Indiana | 18025 | 2293 | 35 |
2152134 | 2152134 | 2022-01-26 | Crawford | Indiana | 18025 | 2280 | 34 |
2148882 | 2148882 | 2022-01-25 | Crawford | Indiana | 18025 | 2269 | 33 |
2145630 | 2145630 | 2022-01-24 | Crawford | Indiana | 18025 | 2251 | 33 |
2142375 | 2142375 | 2022-01-23 | Crawford | Indiana | 18025 | 2203 | 33 |
2139120 | 2139120 | 2022-01-22 | Crawford | Indiana | 18025 | 2203 | 33 |
2135864 | 2135864 | 2022-01-21 | Crawford | Indiana | 18025 | 2203 | 33 |
2132612 | 2132612 | 2022-01-20 | Crawford | Indiana | 18025 | 2177 | 33 |
2129359 | 2129359 | 2022-01-19 | Crawford | Indiana | 18025 | 2153 | 32 |
2126105 | 2126105 | 2022-01-18 | Crawford | Indiana | 18025 | 2132 | 32 |
2122853 | 2122853 | 2022-01-17 | Crawford | Indiana | 18025 | 2114 | 32 |
2119601 | 2119601 | 2022-01-16 | Crawford | Indiana | 18025 | 2064 | 32 |
2116349 | 2116349 | 2022-01-15 | Crawford | Indiana | 18025 | 2064 | 32 |
2113098 | 2113098 | 2022-01-14 | Crawford | Indiana | 18025 | 2064 | 32 |
2109846 | 2109846 | 2022-01-13 | Crawford | Indiana | 18025 | 2038 | 32 |
2106595 | 2106595 | 2022-01-12 | Crawford | Indiana | 18025 | 2010 | 32 |
2103344 | 2103344 | 2022-01-11 | Crawford | Indiana | 18025 | 1992 | 32 |
2100093 | 2100093 | 2022-01-10 | Crawford | Indiana | 18025 | 1971 | 32 |
2096842 | 2096842 | 2022-01-09 | Crawford | Indiana | 18025 | 1927 | 32 |
2093590 | 2093590 | 2022-01-08 | Crawford | Indiana | 18025 | 1927 | 32 |
2090338 | 2090338 | 2022-01-07 | Crawford | Indiana | 18025 | 1927 | 32 |
2087087 | 2087087 | 2022-01-06 | Crawford | Indiana | 18025 | 1903 | 32 |
2083835 | 2083835 | 2022-01-05 | Crawford | Indiana | 18025 | 1895 | 31 |
2080583 | 2080583 | 2022-01-04 | Crawford | Indiana | 18025 | 1882 | 31 |
2077331 | 2077331 | 2022-01-03 | Crawford | Indiana | 18025 | 1874 | 31 |
2074080 | 2074080 | 2022-01-02 | Crawford | Indiana | 18025 | 1842 | 31 |
2070829 | 2070829 | 2022-01-01 | Crawford | Indiana | 18025 | 1842 | 31 |
2067578 | 2067578 | 2021-12-31 | Crawford | Indiana | 18025 | 1842 | 31 |
2064327 | 2064327 | 2021-12-30 | Crawford | Indiana | 18025 | 1842 | 31 |
2061077 | 2061077 | 2021-12-29 | Crawford | Indiana | 18025 | 1836 | 31 |
2057828 | 2057828 | 2021-12-28 | Crawford | Indiana | 18025 | 1828 | 31 |
2054579 | 2054579 | 2021-12-27 | Crawford | Indiana | 18025 | 1822 | 31 |
2051329 | 2051329 | 2021-12-26 | Crawford | Indiana | 18025 | 1808 | 31 |
2048079 | 2048079 | 2021-12-25 | Crawford | Indiana | 18025 | 1808 | 31 |
2044829 | 2044829 | 2021-12-24 | Crawford | Indiana | 18025 | 1808 | 31 |
2041580 | 2041580 | 2021-12-23 | Crawford | Indiana | 18025 | 1808 | 31 |
2038330 | 2038330 | 2021-12-22 | Crawford | Indiana | 18025 | 1808 | 31 |
2035080 | 2035080 | 2021-12-21 | Crawford | Indiana | 18025 | 1804 | 30 |
2031830 | 2031830 | 2021-12-20 | Crawford | Indiana | 18025 | 1797 | 30 |
2028579 | 2028579 | 2021-12-19 | Crawford | Indiana | 18025 | 1779 | 30 |
2025328 | 2025328 | 2021-12-18 | Crawford | Indiana | 18025 | 1779 | 30 |
2022077 | 2022077 | 2021-12-17 | Crawford | Indiana | 18025 | 1779 | 30 |
2018826 | 2018826 | 2021-12-16 | Crawford | Indiana | 18025 | 1773 | 30 |
2015576 | 2015576 | 2021-12-15 | Crawford | Indiana | 18025 | 1768 | 30 |
2012325 | 2012325 | 2021-12-14 | Crawford | Indiana | 18025 | 1761 | 30 |
2009074 | 2009074 | 2021-12-13 | Crawford | Indiana | 18025 | 1755 | 30 |
2005823 | 2005823 | 2021-12-12 | Crawford | Indiana | 18025 | 1736 | 30 |
2002572 | 2002572 | 2021-12-11 | Crawford | Indiana | 18025 | 1736 | 30 |
1999322 | 1999322 | 2021-12-10 | Crawford | Indiana | 18025 | 1736 | 30 |
1996071 | 1996071 | 2021-12-09 | Crawford | Indiana | 18025 | 1729 | 30 |
1992820 | 1992820 | 2021-12-08 | Crawford | Indiana | 18025 | 1721 | 30 |
1989569 | 1989569 | 2021-12-07 | Crawford | Indiana | 18025 | 1714 | 30 |
1986319 | 1986319 | 2021-12-06 | Crawford | Indiana | 18025 | 1709 | 30 |
1983069 | 1983069 | 2021-12-05 | Crawford | Indiana | 18025 | 1693 | 30 |
1979819 | 1979819 | 2021-12-04 | Crawford | Indiana | 18025 | 1693 | 30 |
1976569 | 1976569 | 2021-12-03 | Crawford | Indiana | 18025 | 1693 | 30 |
1973320 | 1973320 | 2021-12-02 | Crawford | Indiana | 18025 | 1690 | 30 |
1970070 | 1970070 | 2021-12-01 | Crawford | Indiana | 18025 | 1685 | 30 |
1966820 | 1966820 | 2021-11-30 | Crawford | Indiana | 18025 | 1683 | 30 |
1963568 | 1963568 | 2021-11-29 | Crawford | Indiana | 18025 | 1681 | 30 |
1960317 | 1960317 | 2021-11-28 | Crawford | Indiana | 18025 | 1673 | 30 |
1957066 | 1957066 | 2021-11-27 | Crawford | Indiana | 18025 | 1673 | 30 |
1953815 | 1953815 | 2021-11-26 | Crawford | Indiana | 18025 | 1673 | 30 |
1950564 | 1950564 | 2021-11-25 | Crawford | Indiana | 18025 | 1673 | 30 |
1947313 | 1947313 | 2021-11-24 | Crawford | Indiana | 18025 | 1673 | 30 |
1944062 | 1944062 | 2021-11-23 | Crawford | Indiana | 18025 | 1671 | 30 |
1940812 | 1940812 | 2021-11-22 | Crawford | Indiana | 18025 | 1666 | 30 |
1937562 | 1937562 | 2021-11-21 | Crawford | Indiana | 18025 | 1660 | 30 |
1934312 | 1934312 | 2021-11-20 | Crawford | Indiana | 18025 | 1660 | 30 |
1931061 | 1931061 | 2021-11-19 | Crawford | Indiana | 18025 | 1660 | 30 |
1927810 | 1927810 | 2021-11-18 | Crawford | Indiana | 18025 | 1656 | 30 |
1924560 | 1924560 | 2021-11-17 | Crawford | Indiana | 18025 | 1654 | 30 |
1921311 | 1921311 | 2021-11-16 | Crawford | Indiana | 18025 | 1651 | 30 |
1918061 | 1918061 | 2021-11-15 | Crawford | Indiana | 18025 | 1650 | 30 |
1914811 | 1914811 | 2021-11-14 | Crawford | Indiana | 18025 | 1647 | 30 |
1911561 | 1911561 | 2021-11-13 | Crawford | Indiana | 18025 | 1647 | 30 |
1908312 | 1908312 | 2021-11-12 | Crawford | Indiana | 18025 | 1647 | 30 |
1905063 | 1905063 | 2021-11-11 | Crawford | Indiana | 18025 | 1643 | 30 |
1901813 | 1901813 | 2021-11-10 | Crawford | Indiana | 18025 | 1635 | 30 |
1898563 | 1898563 | 2021-11-09 | Crawford | Indiana | 18025 | 1634 | 30 |
1895313 | 1895313 | 2021-11-08 | Crawford | Indiana | 18025 | 1633 | 30 |
1892063 | 1892063 | 2021-11-07 | Crawford | Indiana | 18025 | 1630 | 30 |
1888813 | 1888813 | 2021-11-06 | Crawford | Indiana | 18025 | 1630 | 30 |
1885563 | 1885563 | 2021-11-05 | Crawford | Indiana | 18025 | 1630 | 30 |
1882314 | 1882314 | 2021-11-04 | Crawford | Indiana | 18025 | 1627 | 29 |
1879065 | 1879065 | 2021-11-03 | Crawford | Indiana | 18025 | 1626 | 29 |
1875816 | 1875816 | 2021-11-02 | Crawford | Indiana | 18025 | 1624 | 28 |
1872567 | 1872567 | 2021-11-01 | Crawford | Indiana | 18025 | 1624 | 27 |
1869318 | 1869318 | 2021-10-31 | Crawford | Indiana | 18025 | 1614 | 27 |
1866069 | 1866069 | 2021-10-30 | Crawford | Indiana | 18025 | 1614 | 27 |
1862820 | 1862820 | 2021-10-29 | Crawford | Indiana | 18025 | 1614 | 27 |
1859571 | 1859571 | 2021-10-28 | Crawford | Indiana | 18025 | 1610 | 27 |
1856322 | 1856322 | 2021-10-27 | Crawford | Indiana | 18025 | 1607 | 27 |
1853073 | 1853073 | 2021-10-26 | Crawford | Indiana | 18025 | 1604 | 27 |
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);