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 |
---|---|---|---|---|---|---|---|
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 |
1849832 | 1849832 | 2021-10-25 | Fayette | Indiana | 18041 | 4212 | 90 |
1846582 | 1846582 | 2021-10-24 | Fayette | Indiana | 18041 | 4204 | 90 |
1843332 | 1843332 | 2021-10-23 | Fayette | Indiana | 18041 | 4204 | 90 |
1840082 | 1840082 | 2021-10-22 | Fayette | Indiana | 18041 | 4204 | 90 |
1836833 | 1836833 | 2021-10-21 | Fayette | Indiana | 18041 | 4200 | 90 |
1833584 | 1833584 | 2021-10-20 | Fayette | Indiana | 18041 | 4196 | 90 |
1830335 | 1830335 | 2021-10-19 | Fayette | Indiana | 18041 | 4188 | 90 |
1827086 | 1827086 | 2021-10-18 | Fayette | Indiana | 18041 | 4181 | 89 |
1823837 | 1823837 | 2021-10-17 | Fayette | Indiana | 18041 | 4160 | 89 |
1820588 | 1820588 | 2021-10-16 | Fayette | Indiana | 18041 | 4160 | 89 |
1817339 | 1817339 | 2021-10-15 | Fayette | Indiana | 18041 | 4160 | 89 |
1814091 | 1814091 | 2021-10-14 | Fayette | Indiana | 18041 | 4151 | 89 |
1810842 | 1810842 | 2021-10-13 | Fayette | Indiana | 18041 | 4144 | 89 |
1807593 | 1807593 | 2021-10-12 | Fayette | Indiana | 18041 | 4135 | 89 |
1804342 | 1804342 | 2021-10-11 | Fayette | Indiana | 18041 | 4132 | 89 |
1801093 | 1801093 | 2021-10-10 | Fayette | Indiana | 18041 | 4111 | 89 |
1797844 | 1797844 | 2021-10-09 | Fayette | Indiana | 18041 | 4111 | 89 |
1794595 | 1794595 | 2021-10-08 | Fayette | Indiana | 18041 | 4111 | 89 |
1791347 | 1791347 | 2021-10-07 | Fayette | Indiana | 18041 | 4093 | 89 |
1788098 | 1788098 | 2021-10-06 | Fayette | Indiana | 18041 | 4084 | 89 |
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);