ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 18137 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109902 | 2109902 | 2022-01-13 | Ripley | Indiana | 18137 | 6799 | 114 |
2106651 | 2106651 | 2022-01-12 | Ripley | Indiana | 18137 | 6723 | 112 |
2103400 | 2103400 | 2022-01-11 | Ripley | Indiana | 18137 | 6652 | 112 |
2100149 | 2100149 | 2022-01-10 | Ripley | Indiana | 18137 | 6618 | 111 |
2096898 | 2096898 | 2022-01-09 | Ripley | Indiana | 18137 | 6507 | 107 |
2093646 | 2093646 | 2022-01-08 | Ripley | Indiana | 18137 | 6507 | 107 |
2090394 | 2090394 | 2022-01-07 | Ripley | Indiana | 18137 | 6507 | 107 |
2087143 | 2087143 | 2022-01-06 | Ripley | Indiana | 18137 | 6466 | 105 |
2083891 | 2083891 | 2022-01-05 | Ripley | Indiana | 18137 | 6420 | 105 |
2080639 | 2080639 | 2022-01-04 | Ripley | Indiana | 18137 | 6380 | 103 |
2077387 | 2077387 | 2022-01-03 | Ripley | Indiana | 18137 | 6362 | 103 |
2074136 | 2074136 | 2022-01-02 | Ripley | Indiana | 18137 | 6276 | 103 |
2070885 | 2070885 | 2022-01-01 | Ripley | Indiana | 18137 | 6276 | 103 |
2067634 | 2067634 | 2021-12-31 | Ripley | Indiana | 18137 | 6276 | 103 |
2064383 | 2064383 | 2021-12-30 | Ripley | Indiana | 18137 | 6276 | 103 |
2061133 | 2061133 | 2021-12-29 | Ripley | Indiana | 18137 | 6221 | 101 |
2057884 | 2057884 | 2021-12-28 | Ripley | Indiana | 18137 | 6187 | 100 |
2054635 | 2054635 | 2021-12-27 | Ripley | Indiana | 18137 | 6172 | 97 |
2051385 | 2051385 | 2021-12-26 | Ripley | Indiana | 18137 | 6088 | 97 |
2048135 | 2048135 | 2021-12-25 | Ripley | Indiana | 18137 | 6088 | 97 |
2044885 | 2044885 | 2021-12-24 | Ripley | Indiana | 18137 | 6088 | 97 |
2041636 | 2041636 | 2021-12-23 | Ripley | Indiana | 18137 | 6088 | 97 |
2038386 | 2038386 | 2021-12-22 | Ripley | Indiana | 18137 | 6088 | 97 |
2035136 | 2035136 | 2021-12-21 | Ripley | Indiana | 18137 | 6064 | 97 |
2031886 | 2031886 | 2021-12-20 | Ripley | Indiana | 18137 | 6044 | 97 |
2028635 | 2028635 | 2021-12-19 | Ripley | Indiana | 18137 | 5987 | 97 |
2025384 | 2025384 | 2021-12-18 | Ripley | Indiana | 18137 | 5987 | 97 |
2022133 | 2022133 | 2021-12-17 | Ripley | Indiana | 18137 | 5987 | 97 |
2018882 | 2018882 | 2021-12-16 | Ripley | Indiana | 18137 | 5943 | 97 |
2015632 | 2015632 | 2021-12-15 | Ripley | Indiana | 18137 | 5905 | 96 |
2012381 | 2012381 | 2021-12-14 | Ripley | Indiana | 18137 | 5871 | 96 |
2009130 | 2009130 | 2021-12-13 | Ripley | Indiana | 18137 | 5847 | 96 |
2005879 | 2005879 | 2021-12-12 | Ripley | Indiana | 18137 | 5769 | 96 |
2002628 | 2002628 | 2021-12-11 | Ripley | Indiana | 18137 | 5769 | 96 |
1999378 | 1999378 | 2021-12-10 | Ripley | Indiana | 18137 | 5769 | 96 |
1996127 | 1996127 | 2021-12-09 | Ripley | Indiana | 18137 | 5736 | 95 |
1992876 | 1992876 | 2021-12-08 | Ripley | Indiana | 18137 | 5712 | 95 |
1989625 | 1989625 | 2021-12-07 | Ripley | Indiana | 18137 | 5676 | 95 |
1986375 | 1986375 | 2021-12-06 | Ripley | Indiana | 18137 | 5662 | 95 |
1983125 | 1983125 | 2021-12-05 | Ripley | Indiana | 18137 | 5575 | 95 |
1979875 | 1979875 | 2021-12-04 | Ripley | Indiana | 18137 | 5575 | 95 |
1976625 | 1976625 | 2021-12-03 | Ripley | Indiana | 18137 | 5575 | 95 |
1973376 | 1973376 | 2021-12-02 | Ripley | Indiana | 18137 | 5561 | 94 |
1970126 | 1970126 | 2021-12-01 | Ripley | Indiana | 18137 | 5533 | 94 |
1966876 | 1966876 | 2021-11-30 | Ripley | Indiana | 18137 | 5505 | 93 |
1963624 | 1963624 | 2021-11-29 | Ripley | Indiana | 18137 | 5494 | 93 |
1960373 | 1960373 | 2021-11-28 | Ripley | Indiana | 18137 | 5411 | 93 |
1957122 | 1957122 | 2021-11-27 | Ripley | Indiana | 18137 | 5411 | 93 |
1953871 | 1953871 | 2021-11-26 | Ripley | Indiana | 18137 | 5411 | 93 |
1950620 | 1950620 | 2021-11-25 | Ripley | Indiana | 18137 | 5411 | 93 |
1947369 | 1947369 | 2021-11-24 | Ripley | Indiana | 18137 | 5411 | 93 |
1944118 | 1944118 | 2021-11-23 | Ripley | Indiana | 18137 | 5392 | 93 |
1940868 | 1940868 | 2021-11-22 | Ripley | Indiana | 18137 | 5380 | 93 |
1937618 | 1937618 | 2021-11-21 | Ripley | Indiana | 18137 | 5339 | 93 |
1934368 | 1934368 | 2021-11-20 | Ripley | Indiana | 18137 | 5339 | 93 |
1931117 | 1931117 | 2021-11-19 | Ripley | Indiana | 18137 | 5339 | 93 |
1927866 | 1927866 | 2021-11-18 | Ripley | Indiana | 18137 | 5316 | 93 |
1924616 | 1924616 | 2021-11-17 | Ripley | Indiana | 18137 | 5292 | 93 |
1921367 | 1921367 | 2021-11-16 | Ripley | Indiana | 18137 | 5280 | 93 |
1918117 | 1918117 | 2021-11-15 | Ripley | Indiana | 18137 | 5256 | 93 |
1914867 | 1914867 | 2021-11-14 | Ripley | Indiana | 18137 | 5234 | 93 |
1911617 | 1911617 | 2021-11-13 | Ripley | Indiana | 18137 | 5234 | 93 |
1908368 | 1908368 | 2021-11-12 | Ripley | Indiana | 18137 | 5234 | 93 |
1905119 | 1905119 | 2021-11-11 | Ripley | Indiana | 18137 | 5220 | 93 |
1901869 | 1901869 | 2021-11-10 | Ripley | Indiana | 18137 | 5181 | 93 |
1898619 | 1898619 | 2021-11-09 | Ripley | Indiana | 18137 | 5165 | 93 |
1895369 | 1895369 | 2021-11-08 | Ripley | Indiana | 18137 | 5153 | 93 |
1892119 | 1892119 | 2021-11-07 | Ripley | Indiana | 18137 | 5114 | 93 |
1888869 | 1888869 | 2021-11-06 | Ripley | Indiana | 18137 | 5114 | 93 |
1885619 | 1885619 | 2021-11-05 | Ripley | Indiana | 18137 | 5114 | 93 |
1882370 | 1882370 | 2021-11-04 | Ripley | Indiana | 18137 | 5099 | 93 |
1879121 | 1879121 | 2021-11-03 | Ripley | Indiana | 18137 | 5092 | 93 |
1875872 | 1875872 | 2021-11-02 | Ripley | Indiana | 18137 | 5083 | 93 |
1872623 | 1872623 | 2021-11-01 | Ripley | Indiana | 18137 | 5078 | 91 |
1869374 | 1869374 | 2021-10-31 | Ripley | Indiana | 18137 | 5062 | 91 |
1866125 | 1866125 | 2021-10-30 | Ripley | Indiana | 18137 | 5062 | 91 |
1862876 | 1862876 | 2021-10-29 | Ripley | Indiana | 18137 | 5062 | 91 |
1859627 | 1859627 | 2021-10-28 | Ripley | Indiana | 18137 | 5053 | 91 |
1856378 | 1856378 | 2021-10-27 | Ripley | Indiana | 18137 | 5042 | 89 |
1853129 | 1853129 | 2021-10-26 | Ripley | Indiana | 18137 | 5028 | 88 |
1849880 | 1849880 | 2021-10-25 | Ripley | Indiana | 18137 | 5022 | 88 |
1846630 | 1846630 | 2021-10-24 | Ripley | Indiana | 18137 | 5008 | 87 |
1843380 | 1843380 | 2021-10-23 | Ripley | Indiana | 18137 | 5008 | 87 |
1840130 | 1840130 | 2021-10-22 | Ripley | Indiana | 18137 | 5008 | 87 |
1836881 | 1836881 | 2021-10-21 | Ripley | Indiana | 18137 | 5001 | 87 |
1833632 | 1833632 | 2021-10-20 | Ripley | Indiana | 18137 | 4989 | 87 |
1830383 | 1830383 | 2021-10-19 | Ripley | Indiana | 18137 | 4971 | 87 |
1827134 | 1827134 | 2021-10-18 | Ripley | Indiana | 18137 | 4959 | 86 |
1823885 | 1823885 | 2021-10-17 | Ripley | Indiana | 18137 | 4927 | 86 |
1820636 | 1820636 | 2021-10-16 | Ripley | Indiana | 18137 | 4927 | 86 |
1817387 | 1817387 | 2021-10-15 | Ripley | Indiana | 18137 | 4927 | 86 |
1814139 | 1814139 | 2021-10-14 | Ripley | Indiana | 18137 | 4919 | 85 |
1810890 | 1810890 | 2021-10-13 | Ripley | Indiana | 18137 | 4908 | 85 |
1807641 | 1807641 | 2021-10-12 | Ripley | Indiana | 18137 | 4891 | 85 |
1804390 | 1804390 | 2021-10-11 | Ripley | Indiana | 18137 | 4880 | 83 |
1801141 | 1801141 | 2021-10-10 | Ripley | Indiana | 18137 | 4841 | 83 |
1797892 | 1797892 | 2021-10-09 | Ripley | Indiana | 18137 | 4841 | 83 |
1794643 | 1794643 | 2021-10-08 | Ripley | Indiana | 18137 | 4841 | 83 |
1791395 | 1791395 | 2021-10-07 | Ripley | Indiana | 18137 | 4800 | 83 |
1788146 | 1788146 | 2021-10-06 | Ripley | Indiana | 18137 | 4785 | 81 |
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);