ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Anderson" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175199 | 2175199 | 2022-02-02 | Anderson | Kentucky | 21005 | 5664 | 60 |
2171946 | 2171946 | 2022-02-01 | Anderson | Kentucky | 21005 | 5615 | 59 |
2168693 | 2168693 | 2022-01-31 | Anderson | Kentucky | 21005 | 5577 | 59 |
2165438 | 2165438 | 2022-01-30 | Anderson | Kentucky | 21005 | 5481 | 59 |
2162183 | 2162183 | 2022-01-29 | Anderson | Kentucky | 21005 | 5481 | 59 |
2158928 | 2158928 | 2022-01-28 | Anderson | Kentucky | 21005 | 5481 | 59 |
2155674 | 2155674 | 2022-01-27 | Anderson | Kentucky | 21005 | 5354 | 59 |
2152421 | 2152421 | 2022-01-26 | Anderson | Kentucky | 21005 | 5285 | 59 |
2149169 | 2149169 | 2022-01-25 | Anderson | Kentucky | 21005 | 5209 | 59 |
2145917 | 2145917 | 2022-01-24 | Anderson | Kentucky | 21005 | 5175 | 58 |
2142662 | 2142662 | 2022-01-23 | Anderson | Kentucky | 21005 | 5036 | 58 |
2139407 | 2139407 | 2022-01-22 | Anderson | Kentucky | 21005 | 5036 | 58 |
2136151 | 2136151 | 2022-01-21 | Anderson | Kentucky | 21005 | 5036 | 58 |
2132899 | 2132899 | 2022-01-20 | Anderson | Kentucky | 21005 | 4922 | 58 |
2129646 | 2129646 | 2022-01-19 | Anderson | Kentucky | 21005 | 4860 | 58 |
2126392 | 2126392 | 2022-01-18 | Anderson | Kentucky | 21005 | 4818 | 58 |
2123140 | 2123140 | 2022-01-17 | Anderson | Kentucky | 21005 | 4643 | 58 |
2119888 | 2119888 | 2022-01-16 | Anderson | Kentucky | 21005 | 4643 | 58 |
2116636 | 2116636 | 2022-01-15 | Anderson | Kentucky | 21005 | 4643 | 58 |
2113385 | 2113385 | 2022-01-14 | Anderson | Kentucky | 21005 | 4643 | 58 |
2110133 | 2110133 | 2022-01-13 | Anderson | Kentucky | 21005 | 4564 | 57 |
2106882 | 2106882 | 2022-01-12 | Anderson | Kentucky | 21005 | 4524 | 57 |
2103631 | 2103631 | 2022-01-11 | Anderson | Kentucky | 21005 | 4456 | 57 |
2100380 | 2100380 | 2022-01-10 | Anderson | Kentucky | 21005 | 4423 | 57 |
2097129 | 2097129 | 2022-01-09 | Anderson | Kentucky | 21005 | 4345 | 57 |
2093877 | 2093877 | 2022-01-08 | Anderson | Kentucky | 21005 | 4345 | 57 |
2090625 | 2090625 | 2022-01-07 | Anderson | Kentucky | 21005 | 4345 | 57 |
2087374 | 2087374 | 2022-01-06 | Anderson | Kentucky | 21005 | 4296 | 57 |
2084122 | 2084122 | 2022-01-05 | Anderson | Kentucky | 21005 | 4261 | 57 |
2080870 | 2080870 | 2022-01-04 | Anderson | Kentucky | 21005 | 4232 | 57 |
2077618 | 2077618 | 2022-01-03 | Anderson | Kentucky | 21005 | 4216 | 57 |
2074367 | 2074367 | 2022-01-02 | Anderson | Kentucky | 21005 | 4135 | 57 |
2071116 | 2071116 | 2022-01-01 | Anderson | Kentucky | 21005 | 4135 | 57 |
2067865 | 2067865 | 2021-12-31 | Anderson | Kentucky | 21005 | 4135 | 57 |
2064614 | 2064614 | 2021-12-30 | Anderson | Kentucky | 21005 | 4135 | 57 |
2061364 | 2061364 | 2021-12-29 | Anderson | Kentucky | 21005 | 4135 | 57 |
2058115 | 2058115 | 2021-12-28 | Anderson | Kentucky | 21005 | 4112 | 57 |
2054866 | 2054866 | 2021-12-27 | Anderson | Kentucky | 21005 | 4104 | 57 |
2051616 | 2051616 | 2021-12-26 | Anderson | Kentucky | 21005 | 4055 | 56 |
2048366 | 2048366 | 2021-12-25 | Anderson | Kentucky | 21005 | 4055 | 56 |
2045116 | 2045116 | 2021-12-24 | Anderson | Kentucky | 21005 | 4055 | 56 |
2041867 | 2041867 | 2021-12-23 | Anderson | Kentucky | 21005 | 4055 | 56 |
2038617 | 2038617 | 2021-12-22 | Anderson | Kentucky | 21005 | 4055 | 56 |
2035367 | 2035367 | 2021-12-21 | Anderson | Kentucky | 21005 | 4042 | 56 |
2032117 | 2032117 | 2021-12-20 | Anderson | Kentucky | 21005 | 4020 | 56 |
2028866 | 2028866 | 2021-12-19 | Anderson | Kentucky | 21005 | 3998 | 56 |
2025615 | 2025615 | 2021-12-18 | Anderson | Kentucky | 21005 | 3998 | 56 |
2022364 | 2022364 | 2021-12-17 | Anderson | Kentucky | 21005 | 3998 | 56 |
2019113 | 2019113 | 2021-12-16 | Anderson | Kentucky | 21005 | 3991 | 56 |
2015863 | 2015863 | 2021-12-15 | Anderson | Kentucky | 21005 | 3974 | 56 |
2012612 | 2012612 | 2021-12-14 | Anderson | Kentucky | 21005 | 3959 | 56 |
2009361 | 2009361 | 2021-12-13 | Anderson | Kentucky | 21005 | 3956 | 56 |
2006110 | 2006110 | 2021-12-12 | Anderson | Kentucky | 21005 | 3928 | 54 |
2002859 | 2002859 | 2021-12-11 | Anderson | Kentucky | 21005 | 3928 | 54 |
1999609 | 1999609 | 2021-12-10 | Anderson | Kentucky | 21005 | 3928 | 54 |
1996358 | 1996358 | 2021-12-09 | Anderson | Kentucky | 21005 | 3908 | 54 |
1993107 | 1993107 | 2021-12-08 | Anderson | Kentucky | 21005 | 3892 | 53 |
1989856 | 1989856 | 2021-12-07 | Anderson | Kentucky | 21005 | 3875 | 52 |
1986606 | 1986606 | 2021-12-06 | Anderson | Kentucky | 21005 | 3868 | 52 |
1983356 | 1983356 | 2021-12-05 | Anderson | Kentucky | 21005 | 3835 | 52 |
1980106 | 1980106 | 2021-12-04 | Anderson | Kentucky | 21005 | 3835 | 52 |
1976856 | 1976856 | 2021-12-03 | Anderson | Kentucky | 21005 | 3835 | 52 |
1973607 | 1973607 | 2021-12-02 | Anderson | Kentucky | 21005 | 3826 | 52 |
1970357 | 1970357 | 2021-12-01 | Anderson | Kentucky | 21005 | 3803 | 52 |
1967107 | 1967107 | 2021-11-30 | Anderson | Kentucky | 21005 | 3772 | 52 |
1963855 | 1963855 | 2021-11-29 | Anderson | Kentucky | 21005 | 3763 | 52 |
1960604 | 1960604 | 2021-11-28 | Anderson | Kentucky | 21005 | 3737 | 52 |
1957353 | 1957353 | 2021-11-27 | Anderson | Kentucky | 21005 | 3737 | 52 |
1954102 | 1954102 | 2021-11-26 | Anderson | Kentucky | 21005 | 3737 | 52 |
1950851 | 1950851 | 2021-11-25 | Anderson | Kentucky | 21005 | 3737 | 52 |
1947600 | 1947600 | 2021-11-24 | Anderson | Kentucky | 21005 | 3737 | 52 |
1944349 | 1944349 | 2021-11-23 | Anderson | Kentucky | 21005 | 3719 | 52 |
1941099 | 1941099 | 2021-11-22 | Anderson | Kentucky | 21005 | 3709 | 52 |
1937849 | 1937849 | 2021-11-21 | Anderson | Kentucky | 21005 | 3687 | 51 |
1934599 | 1934599 | 2021-11-20 | Anderson | Kentucky | 21005 | 3687 | 51 |
1931348 | 1931348 | 2021-11-19 | Anderson | Kentucky | 21005 | 3687 | 51 |
1928097 | 1928097 | 2021-11-18 | Anderson | Kentucky | 21005 | 3681 | 50 |
1924847 | 1924847 | 2021-11-17 | Anderson | Kentucky | 21005 | 3669 | 50 |
1921598 | 1921598 | 2021-11-16 | Anderson | Kentucky | 21005 | 3653 | 49 |
1918348 | 1918348 | 2021-11-15 | Anderson | Kentucky | 21005 | 3644 | 49 |
1915098 | 1915098 | 2021-11-14 | Anderson | Kentucky | 21005 | 3638 | 48 |
1911848 | 1911848 | 2021-11-13 | Anderson | Kentucky | 21005 | 3638 | 48 |
1908599 | 1908599 | 2021-11-12 | Anderson | Kentucky | 21005 | 3638 | 48 |
1905350 | 1905350 | 2021-11-11 | Anderson | Kentucky | 21005 | 3622 | 48 |
1902100 | 1902100 | 2021-11-10 | Anderson | Kentucky | 21005 | 3622 | 48 |
1898850 | 1898850 | 2021-11-09 | Anderson | Kentucky | 21005 | 3611 | 48 |
1895600 | 1895600 | 2021-11-08 | Anderson | Kentucky | 21005 | 3605 | 48 |
1892350 | 1892350 | 2021-11-07 | Anderson | Kentucky | 21005 | 3584 | 48 |
1889100 | 1889100 | 2021-11-06 | Anderson | Kentucky | 21005 | 3584 | 48 |
1885850 | 1885850 | 2021-11-05 | Anderson | Kentucky | 21005 | 3584 | 48 |
1882601 | 1882601 | 2021-11-04 | Anderson | Kentucky | 21005 | 3575 | 48 |
1879352 | 1879352 | 2021-11-03 | Anderson | Kentucky | 21005 | 3571 | 48 |
1876103 | 1876103 | 2021-11-02 | Anderson | Kentucky | 21005 | 3556 | 48 |
1872854 | 1872854 | 2021-11-01 | Anderson | Kentucky | 21005 | 3537 | 47 |
1869605 | 1869605 | 2021-10-31 | Anderson | Kentucky | 21005 | 3518 | 44 |
1866356 | 1866356 | 2021-10-30 | Anderson | Kentucky | 21005 | 3518 | 44 |
1863107 | 1863107 | 2021-10-29 | Anderson | Kentucky | 21005 | 3518 | 44 |
1859858 | 1859858 | 2021-10-28 | Anderson | Kentucky | 21005 | 3489 | 44 |
1856609 | 1856609 | 2021-10-27 | Anderson | Kentucky | 21005 | 3455 | 44 |
1853360 | 1853360 | 2021-10-26 | Anderson | Kentucky | 21005 | 3446 | 44 |
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);