ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Clinton" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109845 | 2109845 | 2022-01-13 | Clinton | Indiana | 18023 | 7740 | 100 |
2106594 | 2106594 | 2022-01-12 | Clinton | Indiana | 18023 | 7618 | 100 |
2103343 | 2103343 | 2022-01-11 | Clinton | Indiana | 18023 | 7537 | 100 |
2100092 | 2100092 | 2022-01-10 | Clinton | Indiana | 18023 | 7511 | 99 |
2096841 | 2096841 | 2022-01-09 | Clinton | Indiana | 18023 | 7330 | 97 |
2093589 | 2093589 | 2022-01-08 | Clinton | Indiana | 18023 | 7330 | 97 |
2090337 | 2090337 | 2022-01-07 | Clinton | Indiana | 18023 | 7330 | 97 |
2087086 | 2087086 | 2022-01-06 | Clinton | Indiana | 18023 | 7244 | 97 |
2083834 | 2083834 | 2022-01-05 | Clinton | Indiana | 18023 | 7188 | 95 |
2080582 | 2080582 | 2022-01-04 | Clinton | Indiana | 18023 | 7131 | 94 |
2077330 | 2077330 | 2022-01-03 | Clinton | Indiana | 18023 | 7118 | 92 |
2074079 | 2074079 | 2022-01-02 | Clinton | Indiana | 18023 | 6965 | 92 |
2070828 | 2070828 | 2022-01-01 | Clinton | Indiana | 18023 | 6965 | 92 |
2067577 | 2067577 | 2021-12-31 | Clinton | Indiana | 18023 | 6965 | 92 |
2064326 | 2064326 | 2021-12-30 | Clinton | Indiana | 18023 | 6965 | 92 |
2061076 | 2061076 | 2021-12-29 | Clinton | Indiana | 18023 | 6930 | 92 |
2057827 | 2057827 | 2021-12-28 | Clinton | Indiana | 18023 | 6907 | 91 |
2054578 | 2054578 | 2021-12-27 | Clinton | Indiana | 18023 | 6885 | 90 |
2051328 | 2051328 | 2021-12-26 | Clinton | Indiana | 18023 | 6730 | 90 |
2048078 | 2048078 | 2021-12-25 | Clinton | Indiana | 18023 | 6730 | 90 |
2044828 | 2044828 | 2021-12-24 | Clinton | Indiana | 18023 | 6730 | 90 |
2041579 | 2041579 | 2021-12-23 | Clinton | Indiana | 18023 | 6730 | 90 |
2038329 | 2038329 | 2021-12-22 | Clinton | Indiana | 18023 | 6730 | 90 |
2035079 | 2035079 | 2021-12-21 | Clinton | Indiana | 18023 | 6718 | 90 |
2031829 | 2031829 | 2021-12-20 | Clinton | Indiana | 18023 | 6697 | 90 |
2028578 | 2028578 | 2021-12-19 | Clinton | Indiana | 18023 | 6633 | 90 |
2025327 | 2025327 | 2021-12-18 | Clinton | Indiana | 18023 | 6633 | 90 |
2022076 | 2022076 | 2021-12-17 | Clinton | Indiana | 18023 | 6633 | 90 |
2018825 | 2018825 | 2021-12-16 | Clinton | Indiana | 18023 | 6594 | 90 |
2015575 | 2015575 | 2021-12-15 | Clinton | Indiana | 18023 | 6549 | 88 |
2012324 | 2012324 | 2021-12-14 | Clinton | Indiana | 18023 | 6526 | 88 |
2009073 | 2009073 | 2021-12-13 | Clinton | Indiana | 18023 | 6501 | 88 |
2005822 | 2005822 | 2021-12-12 | Clinton | Indiana | 18023 | 6450 | 87 |
2002571 | 2002571 | 2021-12-11 | Clinton | Indiana | 18023 | 6450 | 87 |
1999321 | 1999321 | 2021-12-10 | Clinton | Indiana | 18023 | 6450 | 87 |
1996070 | 1996070 | 2021-12-09 | Clinton | Indiana | 18023 | 6414 | 87 |
1992819 | 1992819 | 2021-12-08 | Clinton | Indiana | 18023 | 6393 | 87 |
1989568 | 1989568 | 2021-12-07 | Clinton | Indiana | 18023 | 6356 | 86 |
1986318 | 1986318 | 2021-12-06 | Clinton | Indiana | 18023 | 6338 | 85 |
1983068 | 1983068 | 2021-12-05 | Clinton | Indiana | 18023 | 6278 | 85 |
1979818 | 1979818 | 2021-12-04 | Clinton | Indiana | 18023 | 6278 | 85 |
1976568 | 1976568 | 2021-12-03 | Clinton | Indiana | 18023 | 6278 | 85 |
1973319 | 1973319 | 2021-12-02 | Clinton | Indiana | 18023 | 6251 | 84 |
1970069 | 1970069 | 2021-12-01 | Clinton | Indiana | 18023 | 6227 | 82 |
1966819 | 1966819 | 2021-11-30 | Clinton | Indiana | 18023 | 6204 | 82 |
1963567 | 1963567 | 2021-11-29 | Clinton | Indiana | 18023 | 6195 | 81 |
1960316 | 1960316 | 2021-11-28 | Clinton | Indiana | 18023 | 6147 | 81 |
1957065 | 1957065 | 2021-11-27 | Clinton | Indiana | 18023 | 6147 | 81 |
1953814 | 1953814 | 2021-11-26 | Clinton | Indiana | 18023 | 6147 | 81 |
1950563 | 1950563 | 2021-11-25 | Clinton | Indiana | 18023 | 6147 | 81 |
1947312 | 1947312 | 2021-11-24 | Clinton | Indiana | 18023 | 6147 | 81 |
1944061 | 1944061 | 2021-11-23 | Clinton | Indiana | 18023 | 6139 | 81 |
1940811 | 1940811 | 2021-11-22 | Clinton | Indiana | 18023 | 6127 | 81 |
1937561 | 1937561 | 2021-11-21 | Clinton | Indiana | 18023 | 6089 | 81 |
1934311 | 1934311 | 2021-11-20 | Clinton | Indiana | 18023 | 6089 | 81 |
1931060 | 1931060 | 2021-11-19 | Clinton | Indiana | 18023 | 6089 | 81 |
1927809 | 1927809 | 2021-11-18 | Clinton | Indiana | 18023 | 6076 | 80 |
1924559 | 1924559 | 2021-11-17 | Clinton | Indiana | 18023 | 6057 | 80 |
1921310 | 1921310 | 2021-11-16 | Clinton | Indiana | 18023 | 6041 | 80 |
1918060 | 1918060 | 2021-11-15 | Clinton | Indiana | 18023 | 6028 | 80 |
1914810 | 1914810 | 2021-11-14 | Clinton | Indiana | 18023 | 6001 | 80 |
1911560 | 1911560 | 2021-11-13 | Clinton | Indiana | 18023 | 6001 | 80 |
1908311 | 1908311 | 2021-11-12 | Clinton | Indiana | 18023 | 6001 | 80 |
1905062 | 1905062 | 2021-11-11 | Clinton | Indiana | 18023 | 5986 | 80 |
1901812 | 1901812 | 2021-11-10 | Clinton | Indiana | 18023 | 5953 | 80 |
1898562 | 1898562 | 2021-11-09 | Clinton | Indiana | 18023 | 5942 | 80 |
1895312 | 1895312 | 2021-11-08 | Clinton | Indiana | 18023 | 5930 | 79 |
1892062 | 1892062 | 2021-11-07 | Clinton | Indiana | 18023 | 5905 | 79 |
1888812 | 1888812 | 2021-11-06 | Clinton | Indiana | 18023 | 5905 | 79 |
1885562 | 1885562 | 2021-11-05 | Clinton | Indiana | 18023 | 5905 | 79 |
1882313 | 1882313 | 2021-11-04 | Clinton | Indiana | 18023 | 5899 | 79 |
1879064 | 1879064 | 2021-11-03 | Clinton | Indiana | 18023 | 5874 | 79 |
1875815 | 1875815 | 2021-11-02 | Clinton | Indiana | 18023 | 5862 | 78 |
1872566 | 1872566 | 2021-11-01 | Clinton | Indiana | 18023 | 5857 | 78 |
1869317 | 1869317 | 2021-10-31 | Clinton | Indiana | 18023 | 5839 | 77 |
1866068 | 1866068 | 2021-10-30 | Clinton | Indiana | 18023 | 5839 | 77 |
1862819 | 1862819 | 2021-10-29 | Clinton | Indiana | 18023 | 5839 | 77 |
1859570 | 1859570 | 2021-10-28 | Clinton | Indiana | 18023 | 5824 | 77 |
1856321 | 1856321 | 2021-10-27 | Clinton | Indiana | 18023 | 5810 | 77 |
1853072 | 1853072 | 2021-10-26 | Clinton | Indiana | 18023 | 5803 | 77 |
1849823 | 1849823 | 2021-10-25 | Clinton | Indiana | 18023 | 5798 | 76 |
1846573 | 1846573 | 2021-10-24 | Clinton | Indiana | 18023 | 5767 | 76 |
1843323 | 1843323 | 2021-10-23 | Clinton | Indiana | 18023 | 5767 | 76 |
1840073 | 1840073 | 2021-10-22 | Clinton | Indiana | 18023 | 5767 | 76 |
1836824 | 1836824 | 2021-10-21 | Clinton | Indiana | 18023 | 5755 | 76 |
1833575 | 1833575 | 2021-10-20 | Clinton | Indiana | 18023 | 5727 | 76 |
1830326 | 1830326 | 2021-10-19 | Clinton | Indiana | 18023 | 5719 | 76 |
1827077 | 1827077 | 2021-10-18 | Clinton | Indiana | 18023 | 5708 | 76 |
1823828 | 1823828 | 2021-10-17 | Clinton | Indiana | 18023 | 5677 | 76 |
1820579 | 1820579 | 2021-10-16 | Clinton | Indiana | 18023 | 5677 | 76 |
1817330 | 1817330 | 2021-10-15 | Clinton | Indiana | 18023 | 5677 | 76 |
1814082 | 1814082 | 2021-10-14 | Clinton | Indiana | 18023 | 5651 | 76 |
1810833 | 1810833 | 2021-10-13 | Clinton | Indiana | 18023 | 5624 | 75 |
1807584 | 1807584 | 2021-10-12 | Clinton | Indiana | 18023 | 5613 | 74 |
1804333 | 1804333 | 2021-10-11 | Clinton | Indiana | 18023 | 5605 | 74 |
1801084 | 1801084 | 2021-10-10 | Clinton | Indiana | 18023 | 5564 | 74 |
1797835 | 1797835 | 2021-10-09 | Clinton | Indiana | 18023 | 5564 | 74 |
1794586 | 1794586 | 2021-10-08 | Clinton | Indiana | 18023 | 5564 | 74 |
1791338 | 1791338 | 2021-10-07 | Clinton | Indiana | 18023 | 5542 | 74 |
1788089 | 1788089 | 2021-10-06 | Clinton | Indiana | 18023 | 5515 | 74 |
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);