ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Fayette" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174920 | 2174920 | 2022-02-02 | Fayette | Indiana | 18041 | 6605 | 133 |
2171667 | 2171667 | 2022-02-01 | Fayette | Indiana | 18041 | 6559 | 131 |
2168414 | 2168414 | 2022-01-31 | Fayette | Indiana | 18041 | 6529 | 131 |
2165159 | 2165159 | 2022-01-30 | Fayette | Indiana | 18041 | 6405 | 131 |
2161904 | 2161904 | 2022-01-29 | Fayette | Indiana | 18041 | 6405 | 131 |
2158649 | 2158649 | 2022-01-28 | Fayette | Indiana | 18041 | 6405 | 131 |
2155395 | 2155395 | 2022-01-27 | Fayette | Indiana | 18041 | 6293 | 129 |
2152142 | 2152142 | 2022-01-26 | Fayette | Indiana | 18041 | 6255 | 128 |
2148890 | 2148890 | 2022-01-25 | Fayette | Indiana | 18041 | 6237 | 128 |
2145638 | 2145638 | 2022-01-24 | Fayette | Indiana | 18041 | 6197 | 128 |
2142383 | 2142383 | 2022-01-23 | Fayette | Indiana | 18041 | 6029 | 128 |
2139128 | 2139128 | 2022-01-22 | Fayette | Indiana | 18041 | 6029 | 128 |
2135872 | 2135872 | 2022-01-21 | Fayette | Indiana | 18041 | 6029 | 128 |
2132620 | 2132620 | 2022-01-20 | Fayette | Indiana | 18041 | 5929 | 128 |
2129367 | 2129367 | 2022-01-19 | Fayette | Indiana | 18041 | 5878 | 127 |
2126113 | 2126113 | 2022-01-18 | Fayette | Indiana | 18041 | 5830 | 127 |
2122861 | 2122861 | 2022-01-17 | Fayette | Indiana | 18041 | 5800 | 127 |
2119609 | 2119609 | 2022-01-16 | Fayette | Indiana | 18041 | 5682 | 125 |
2116357 | 2116357 | 2022-01-15 | Fayette | Indiana | 18041 | 5682 | 125 |
2113106 | 2113106 | 2022-01-14 | Fayette | Indiana | 18041 | 5682 | 125 |
2109854 | 2109854 | 2022-01-13 | Fayette | Indiana | 18041 | 5648 | 123 |
2106603 | 2106603 | 2022-01-12 | Fayette | Indiana | 18041 | 5607 | 122 |
2103352 | 2103352 | 2022-01-11 | Fayette | Indiana | 18041 | 5559 | 121 |
2100101 | 2100101 | 2022-01-10 | Fayette | Indiana | 18041 | 5541 | 120 |
2096850 | 2096850 | 2022-01-09 | Fayette | Indiana | 18041 | 5464 | 120 |
2093598 | 2093598 | 2022-01-08 | Fayette | Indiana | 18041 | 5464 | 120 |
2090346 | 2090346 | 2022-01-07 | Fayette | Indiana | 18041 | 5464 | 120 |
2087095 | 2087095 | 2022-01-06 | Fayette | Indiana | 18041 | 5420 | 120 |
2083843 | 2083843 | 2022-01-05 | Fayette | Indiana | 18041 | 5398 | 117 |
2080591 | 2080591 | 2022-01-04 | Fayette | Indiana | 18041 | 5378 | 117 |
2077339 | 2077339 | 2022-01-03 | Fayette | Indiana | 18041 | 5366 | 115 |
2074088 | 2074088 | 2022-01-02 | Fayette | Indiana | 18041 | 5296 | 115 |
2070837 | 2070837 | 2022-01-01 | Fayette | Indiana | 18041 | 5296 | 115 |
2067586 | 2067586 | 2021-12-31 | Fayette | Indiana | 18041 | 5296 | 115 |
2064335 | 2064335 | 2021-12-30 | Fayette | Indiana | 18041 | 5296 | 115 |
2061085 | 2061085 | 2021-12-29 | Fayette | Indiana | 18041 | 5259 | 115 |
2057836 | 2057836 | 2021-12-28 | Fayette | Indiana | 18041 | 5245 | 115 |
2054587 | 2054587 | 2021-12-27 | Fayette | Indiana | 18041 | 5234 | 115 |
2051337 | 2051337 | 2021-12-26 | Fayette | Indiana | 18041 | 5173 | 113 |
2048087 | 2048087 | 2021-12-25 | Fayette | Indiana | 18041 | 5173 | 113 |
2044837 | 2044837 | 2021-12-24 | Fayette | Indiana | 18041 | 5173 | 113 |
2041588 | 2041588 | 2021-12-23 | Fayette | Indiana | 18041 | 5173 | 113 |
2038338 | 2038338 | 2021-12-22 | Fayette | Indiana | 18041 | 5173 | 113 |
2035088 | 2035088 | 2021-12-21 | Fayette | Indiana | 18041 | 5147 | 111 |
2031838 | 2031838 | 2021-12-20 | Fayette | Indiana | 18041 | 5132 | 110 |
2028587 | 2028587 | 2021-12-19 | Fayette | Indiana | 18041 | 5100 | 110 |
2025336 | 2025336 | 2021-12-18 | Fayette | Indiana | 18041 | 5100 | 110 |
2022085 | 2022085 | 2021-12-17 | Fayette | Indiana | 18041 | 5100 | 110 |
2018834 | 2018834 | 2021-12-16 | Fayette | Indiana | 18041 | 5027 | 109 |
2015584 | 2015584 | 2021-12-15 | Fayette | Indiana | 18041 | 5002 | 109 |
2012333 | 2012333 | 2021-12-14 | Fayette | Indiana | 18041 | 4987 | 107 |
2009082 | 2009082 | 2021-12-13 | Fayette | Indiana | 18041 | 4965 | 105 |
2005831 | 2005831 | 2021-12-12 | Fayette | Indiana | 18041 | 4881 | 105 |
2002580 | 2002580 | 2021-12-11 | Fayette | Indiana | 18041 | 4881 | 105 |
1999330 | 1999330 | 2021-12-10 | Fayette | Indiana | 18041 | 4881 | 105 |
1996079 | 1996079 | 2021-12-09 | Fayette | Indiana | 18041 | 4855 | 104 |
1992828 | 1992828 | 2021-12-08 | Fayette | Indiana | 18041 | 4832 | 103 |
1989577 | 1989577 | 2021-12-07 | Fayette | Indiana | 18041 | 4793 | 102 |
1986327 | 1986327 | 2021-12-06 | Fayette | Indiana | 18041 | 4766 | 101 |
1983077 | 1983077 | 2021-12-05 | Fayette | Indiana | 18041 | 4665 | 100 |
1979827 | 1979827 | 2021-12-04 | Fayette | Indiana | 18041 | 4665 | 100 |
1976577 | 1976577 | 2021-12-03 | Fayette | Indiana | 18041 | 4665 | 100 |
1973328 | 1973328 | 2021-12-02 | Fayette | Indiana | 18041 | 4624 | 100 |
1970078 | 1970078 | 2021-12-01 | Fayette | Indiana | 18041 | 4568 | 97 |
1966828 | 1966828 | 2021-11-30 | Fayette | Indiana | 18041 | 4524 | 97 |
1963576 | 1963576 | 2021-11-29 | Fayette | Indiana | 18041 | 4496 | 97 |
1960325 | 1960325 | 2021-11-28 | Fayette | Indiana | 18041 | 4430 | 97 |
1957074 | 1957074 | 2021-11-27 | Fayette | Indiana | 18041 | 4430 | 97 |
1953823 | 1953823 | 2021-11-26 | Fayette | Indiana | 18041 | 4430 | 97 |
1950572 | 1950572 | 2021-11-25 | Fayette | Indiana | 18041 | 4430 | 97 |
1947321 | 1947321 | 2021-11-24 | Fayette | Indiana | 18041 | 4430 | 97 |
1944070 | 1944070 | 2021-11-23 | Fayette | Indiana | 18041 | 4418 | 97 |
1940820 | 1940820 | 2021-11-22 | Fayette | Indiana | 18041 | 4401 | 97 |
1937570 | 1937570 | 2021-11-21 | Fayette | Indiana | 18041 | 4371 | 95 |
1934320 | 1934320 | 2021-11-20 | Fayette | Indiana | 18041 | 4371 | 95 |
1931069 | 1931069 | 2021-11-19 | Fayette | Indiana | 18041 | 4371 | 95 |
1927818 | 1927818 | 2021-11-18 | Fayette | Indiana | 18041 | 4362 | 95 |
1924568 | 1924568 | 2021-11-17 | Fayette | Indiana | 18041 | 4357 | 95 |
1921319 | 1921319 | 2021-11-16 | Fayette | Indiana | 18041 | 4346 | 94 |
1918069 | 1918069 | 2021-11-15 | Fayette | Indiana | 18041 | 4333 | 94 |
1914819 | 1914819 | 2021-11-14 | Fayette | Indiana | 18041 | 4322 | 94 |
1911569 | 1911569 | 2021-11-13 | Fayette | Indiana | 18041 | 4322 | 94 |
1908320 | 1908320 | 2021-11-12 | Fayette | Indiana | 18041 | 4322 | 94 |
1905071 | 1905071 | 2021-11-11 | Fayette | Indiana | 18041 | 4319 | 94 |
1901821 | 1901821 | 2021-11-10 | Fayette | Indiana | 18041 | 4283 | 94 |
1898571 | 1898571 | 2021-11-09 | Fayette | Indiana | 18041 | 4280 | 94 |
1895321 | 1895321 | 2021-11-08 | Fayette | Indiana | 18041 | 4273 | 94 |
1892071 | 1892071 | 2021-11-07 | Fayette | Indiana | 18041 | 4258 | 93 |
1888821 | 1888821 | 2021-11-06 | Fayette | Indiana | 18041 | 4258 | 93 |
1885571 | 1885571 | 2021-11-05 | Fayette | Indiana | 18041 | 4258 | 93 |
1882322 | 1882322 | 2021-11-04 | Fayette | Indiana | 18041 | 4256 | 93 |
1879073 | 1879073 | 2021-11-03 | Fayette | Indiana | 18041 | 4249 | 93 |
1875824 | 1875824 | 2021-11-02 | Fayette | Indiana | 18041 | 4240 | 93 |
1872575 | 1872575 | 2021-11-01 | Fayette | Indiana | 18041 | 4232 | 92 |
1869326 | 1869326 | 2021-10-31 | Fayette | Indiana | 18041 | 4222 | 92 |
1866077 | 1866077 | 2021-10-30 | Fayette | Indiana | 18041 | 4222 | 92 |
1862828 | 1862828 | 2021-10-29 | Fayette | Indiana | 18041 | 4222 | 92 |
1859579 | 1859579 | 2021-10-28 | Fayette | Indiana | 18041 | 4217 | 91 |
1856330 | 1856330 | 2021-10-27 | Fayette | Indiana | 18041 | 4215 | 91 |
1853081 | 1853081 | 2021-10-26 | Fayette | Indiana | 18041 | 4214 | 90 |
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);