ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
456 rows where deaths = 57 and state = "Indiana" 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 |
---|---|---|---|---|---|---|---|
2337573 | 2337573 | 2022-03-24 | Posey | Indiana | 18129 | 6527 | 57 |
2334319 | 2334319 | 2022-03-23 | Posey | Indiana | 18129 | 6525 | 57 |
2331065 | 2331065 | 2022-03-22 | Posey | Indiana | 18129 | 6526 | 57 |
2327813 | 2327813 | 2022-03-21 | Posey | Indiana | 18129 | 6525 | 57 |
2279031 | 2279031 | 2022-03-06 | Rush | Indiana | 18139 | 4894 | 57 |
2275778 | 2275778 | 2022-03-05 | Rush | Indiana | 18139 | 4894 | 57 |
2272525 | 2272525 | 2022-03-04 | Rush | Indiana | 18139 | 4894 | 57 |
2148893 | 2148893 | 2022-01-25 | Franklin | Indiana | 18047 | 3989 | 57 |
2109838 | 2109838 | 2022-01-13 | Blackford | Indiana | 18009 | 2612 | 57 |
2106587 | 2106587 | 2022-01-12 | Blackford | Indiana | 18009 | 2601 | 57 |
2103336 | 2103336 | 2022-01-11 | Blackford | Indiana | 18009 | 2584 | 57 |
2087147 | 2087147 | 2022-01-06 | Spencer | Indiana | 18147 | 4083 | 57 |
2083895 | 2083895 | 2022-01-05 | Spencer | Indiana | 18147 | 4041 | 57 |
2080643 | 2080643 | 2022-01-04 | Spencer | Indiana | 18147 | 4015 | 57 |
2077391 | 2077391 | 2022-01-03 | Spencer | Indiana | 18147 | 4004 | 57 |
2054622 | 2054622 | 2021-12-27 | Newton | Indiana | 18111 | 2014 | 57 |
2051372 | 2051372 | 2021-12-26 | Newton | Indiana | 18111 | 1991 | 57 |
2048122 | 2048122 | 2021-12-25 | Newton | Indiana | 18111 | 1991 | 57 |
2044872 | 2044872 | 2021-12-24 | Newton | Indiana | 18111 | 1991 | 57 |
2041623 | 2041623 | 2021-12-23 | Newton | Indiana | 18111 | 1991 | 57 |
2038373 | 2038373 | 2021-12-22 | Newton | Indiana | 18111 | 1991 | 57 |
2035123 | 2035123 | 2021-12-21 | Newton | Indiana | 18111 | 1978 | 57 |
2031873 | 2031873 | 2021-12-20 | Newton | Indiana | 18111 | 1969 | 57 |
2028622 | 2028622 | 2021-12-19 | Newton | Indiana | 18111 | 1954 | 57 |
2025371 | 2025371 | 2021-12-18 | Newton | Indiana | 18111 | 1954 | 57 |
2022120 | 2022120 | 2021-12-17 | Newton | Indiana | 18111 | 1954 | 57 |
2018851 | 2018851 | 2021-12-16 | Jay | Indiana | 18075 | 3568 | 57 |
2015601 | 2015601 | 2021-12-15 | Jay | Indiana | 18075 | 3551 | 57 |
2012350 | 2012350 | 2021-12-14 | Jay | Indiana | 18075 | 3529 | 57 |
2009099 | 2009099 | 2021-12-13 | Jay | Indiana | 18075 | 3517 | 57 |
2009149 | 2009149 | 2021-12-13 | Washington | Indiana | 18175 | 4033 | 57 |
2005848 | 2005848 | 2021-12-12 | Jay | Indiana | 18075 | 3464 | 57 |
2005887 | 2005887 | 2021-12-12 | Sullivan | Indiana | 18153 | 3562 | 57 |
2005898 | 2005898 | 2021-12-12 | Washington | Indiana | 18175 | 4000 | 57 |
2002597 | 2002597 | 2021-12-11 | Jay | Indiana | 18075 | 3464 | 57 |
2002636 | 2002636 | 2021-12-11 | Sullivan | Indiana | 18153 | 3562 | 57 |
2002647 | 2002647 | 2021-12-11 | Washington | Indiana | 18175 | 4000 | 57 |
1999347 | 1999347 | 2021-12-10 | Jay | Indiana | 18075 | 3464 | 57 |
1999386 | 1999386 | 2021-12-10 | Sullivan | Indiana | 18153 | 3562 | 57 |
1999397 | 1999397 | 2021-12-10 | Washington | Indiana | 18175 | 4000 | 57 |
1996096 | 1996096 | 2021-12-09 | Jay | Indiana | 18075 | 3441 | 57 |
1996120 | 1996120 | 2021-12-09 | Perry | Indiana | 18123 | 3001 | 57 |
1996135 | 1996135 | 2021-12-09 | Sullivan | Indiana | 18153 | 3549 | 57 |
1996146 | 1996146 | 2021-12-09 | Washington | Indiana | 18175 | 3984 | 57 |
1992869 | 1992869 | 2021-12-08 | Perry | Indiana | 18123 | 2981 | 57 |
1992884 | 1992884 | 2021-12-08 | Sullivan | Indiana | 18153 | 3540 | 57 |
1992895 | 1992895 | 2021-12-08 | Washington | Indiana | 18175 | 3968 | 57 |
1989618 | 1989618 | 2021-12-07 | Perry | Indiana | 18123 | 2958 | 57 |
1989633 | 1989633 | 2021-12-07 | Sullivan | Indiana | 18153 | 3531 | 57 |
1989644 | 1989644 | 2021-12-07 | Washington | Indiana | 18175 | 3948 | 57 |
1986368 | 1986368 | 2021-12-06 | Perry | Indiana | 18123 | 2941 | 57 |
1986383 | 1986383 | 2021-12-06 | Sullivan | Indiana | 18153 | 3518 | 57 |
1986394 | 1986394 | 2021-12-06 | Washington | Indiana | 18175 | 3937 | 57 |
1983133 | 1983133 | 2021-12-05 | Sullivan | Indiana | 18153 | 3492 | 57 |
1983144 | 1983144 | 2021-12-05 | Washington | Indiana | 18175 | 3910 | 57 |
1979883 | 1979883 | 2021-12-04 | Sullivan | Indiana | 18153 | 3492 | 57 |
1979894 | 1979894 | 2021-12-04 | Washington | Indiana | 18175 | 3910 | 57 |
1976633 | 1976633 | 2021-12-03 | Sullivan | Indiana | 18153 | 3492 | 57 |
1976644 | 1976644 | 2021-12-03 | Washington | Indiana | 18175 | 3910 | 57 |
1973395 | 1973395 | 2021-12-02 | Washington | Indiana | 18175 | 3899 | 57 |
1970145 | 1970145 | 2021-12-01 | Washington | Indiana | 18175 | 3871 | 57 |
1960387 | 1960387 | 2021-11-28 | Vermillion | Indiana | 18165 | 2776 | 57 |
1957136 | 1957136 | 2021-11-27 | Vermillion | Indiana | 18165 | 2776 | 57 |
1953885 | 1953885 | 2021-11-26 | Vermillion | Indiana | 18165 | 2776 | 57 |
1950634 | 1950634 | 2021-11-25 | Vermillion | Indiana | 18165 | 2776 | 57 |
1947383 | 1947383 | 2021-11-24 | Vermillion | Indiana | 18165 | 2776 | 57 |
1944132 | 1944132 | 2021-11-23 | Vermillion | Indiana | 18165 | 2773 | 57 |
1940882 | 1940882 | 2021-11-22 | Vermillion | Indiana | 18165 | 2765 | 57 |
1905116 | 1905116 | 2021-11-11 | Pulaski | Indiana | 18131 | 1943 | 57 |
1901866 | 1901866 | 2021-11-10 | Pulaski | Indiana | 18131 | 1932 | 57 |
1898616 | 1898616 | 2021-11-09 | Pulaski | Indiana | 18131 | 1922 | 57 |
1895366 | 1895366 | 2021-11-08 | Pulaski | Indiana | 18131 | 1919 | 57 |
1892116 | 1892116 | 2021-11-07 | Pulaski | Indiana | 18131 | 1905 | 57 |
1888866 | 1888866 | 2021-11-06 | Pulaski | Indiana | 18131 | 1905 | 57 |
1885616 | 1885616 | 2021-11-05 | Pulaski | Indiana | 18131 | 1905 | 57 |
1882367 | 1882367 | 2021-11-04 | Pulaski | Indiana | 18131 | 1895 | 57 |
1882393 | 1882393 | 2021-11-04 | Whitley | Indiana | 18183 | 5823 | 57 |
1879118 | 1879118 | 2021-11-03 | Pulaski | Indiana | 18131 | 1890 | 57 |
1879144 | 1879144 | 2021-11-03 | Whitley | Indiana | 18183 | 5810 | 57 |
1875869 | 1875869 | 2021-11-02 | Pulaski | Indiana | 18131 | 1880 | 57 |
1875895 | 1875895 | 2021-11-02 | Whitley | Indiana | 18183 | 5784 | 57 |
1872620 | 1872620 | 2021-11-01 | Pulaski | Indiana | 18131 | 1878 | 57 |
1872646 | 1872646 | 2021-11-01 | Whitley | Indiana | 18183 | 5776 | 57 |
1869371 | 1869371 | 2021-10-31 | Pulaski | Indiana | 18131 | 1868 | 57 |
1869397 | 1869397 | 2021-10-31 | Whitley | Indiana | 18183 | 5750 | 57 |
1866122 | 1866122 | 2021-10-30 | Pulaski | Indiana | 18131 | 1868 | 57 |
1866148 | 1866148 | 2021-10-30 | Whitley | Indiana | 18183 | 5750 | 57 |
1862873 | 1862873 | 2021-10-29 | Pulaski | Indiana | 18131 | 1868 | 57 |
1862899 | 1862899 | 2021-10-29 | Whitley | Indiana | 18183 | 5750 | 57 |
1859624 | 1859624 | 2021-10-28 | Pulaski | Indiana | 18131 | 1861 | 57 |
1859650 | 1859650 | 2021-10-28 | Whitley | Indiana | 18183 | 5738 | 57 |
1856375 | 1856375 | 2021-10-27 | Pulaski | Indiana | 18131 | 1855 | 57 |
1856401 | 1856401 | 2021-10-27 | Whitley | Indiana | 18183 | 5718 | 57 |
1853126 | 1853126 | 2021-10-26 | Pulaski | Indiana | 18131 | 1849 | 57 |
1853152 | 1853152 | 2021-10-26 | Whitley | Indiana | 18183 | 5698 | 57 |
1849877 | 1849877 | 2021-10-25 | Pulaski | Indiana | 18131 | 1848 | 57 |
1846627 | 1846627 | 2021-10-24 | Pulaski | Indiana | 18131 | 1839 | 57 |
1843377 | 1843377 | 2021-10-23 | Pulaski | Indiana | 18131 | 1839 | 57 |
1840127 | 1840127 | 2021-10-22 | Pulaski | Indiana | 18131 | 1839 | 57 |
1836878 | 1836878 | 2021-10-21 | Pulaski | Indiana | 18131 | 1836 | 57 |
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);