ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where county = "Crawford", deaths = 30 and fips = 18025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
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);