ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 21151 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175269 | 2175269 | 2022-02-02 | Madison | Kentucky | 21151 | 25154 | 231 |
2172016 | 2172016 | 2022-02-01 | Madison | Kentucky | 21151 | 24972 | 229 |
2168763 | 2168763 | 2022-01-31 | Madison | Kentucky | 21151 | 24764 | 223 |
2165508 | 2165508 | 2022-01-30 | Madison | Kentucky | 21151 | 24335 | 223 |
2162253 | 2162253 | 2022-01-29 | Madison | Kentucky | 21151 | 24335 | 223 |
2158998 | 2158998 | 2022-01-28 | Madison | Kentucky | 21151 | 24335 | 223 |
2155744 | 2155744 | 2022-01-27 | Madison | Kentucky | 21151 | 23868 | 222 |
2152491 | 2152491 | 2022-01-26 | Madison | Kentucky | 21151 | 23582 | 222 |
2149239 | 2149239 | 2022-01-25 | Madison | Kentucky | 21151 | 23323 | 222 |
2145987 | 2145987 | 2022-01-24 | Madison | Kentucky | 21151 | 23074 | 222 |
2142732 | 2142732 | 2022-01-23 | Madison | Kentucky | 21151 | 22466 | 222 |
2139477 | 2139477 | 2022-01-22 | Madison | Kentucky | 21151 | 22466 | 222 |
2136221 | 2136221 | 2022-01-21 | Madison | Kentucky | 21151 | 22466 | 222 |
2132969 | 2132969 | 2022-01-20 | Madison | Kentucky | 21151 | 22102 | 222 |
2129716 | 2129716 | 2022-01-19 | Madison | Kentucky | 21151 | 21756 | 222 |
2126462 | 2126462 | 2022-01-18 | Madison | Kentucky | 21151 | 21497 | 221 |
2123210 | 2123210 | 2022-01-17 | Madison | Kentucky | 21151 | 20842 | 221 |
2119958 | 2119958 | 2022-01-16 | Madison | Kentucky | 21151 | 20842 | 221 |
2116706 | 2116706 | 2022-01-15 | Madison | Kentucky | 21151 | 20842 | 221 |
2113455 | 2113455 | 2022-01-14 | Madison | Kentucky | 21151 | 20842 | 221 |
2110203 | 2110203 | 2022-01-13 | Madison | Kentucky | 21151 | 20583 | 221 |
2106952 | 2106952 | 2022-01-12 | Madison | Kentucky | 21151 | 20352 | 221 |
2103701 | 2103701 | 2022-01-11 | Madison | Kentucky | 21151 | 20128 | 221 |
2100450 | 2100450 | 2022-01-10 | Madison | Kentucky | 21151 | 19844 | 221 |
2097199 | 2097199 | 2022-01-09 | Madison | Kentucky | 21151 | 19621 | 219 |
2093947 | 2093947 | 2022-01-08 | Madison | Kentucky | 21151 | 19621 | 219 |
2090695 | 2090695 | 2022-01-07 | Madison | Kentucky | 21151 | 19621 | 219 |
2087444 | 2087444 | 2022-01-06 | Madison | Kentucky | 21151 | 19438 | 216 |
2084192 | 2084192 | 2022-01-05 | Madison | Kentucky | 21151 | 19225 | 216 |
2080940 | 2080940 | 2022-01-04 | Madison | Kentucky | 21151 | 19060 | 214 |
2077688 | 2077688 | 2022-01-03 | Madison | Kentucky | 21151 | 18914 | 213 |
2074437 | 2074437 | 2022-01-02 | Madison | Kentucky | 21151 | 18597 | 213 |
2071186 | 2071186 | 2022-01-01 | Madison | Kentucky | 21151 | 18597 | 213 |
2067935 | 2067935 | 2021-12-31 | Madison | Kentucky | 21151 | 18597 | 213 |
2064684 | 2064684 | 2021-12-30 | Madison | Kentucky | 21151 | 18597 | 213 |
2061434 | 2061434 | 2021-12-29 | Madison | Kentucky | 21151 | 18597 | 213 |
2058185 | 2058185 | 2021-12-28 | Madison | Kentucky | 21151 | 18538 | 212 |
2054936 | 2054936 | 2021-12-27 | Madison | Kentucky | 21151 | 18446 | 212 |
2051686 | 2051686 | 2021-12-26 | Madison | Kentucky | 21151 | 18269 | 212 |
2048436 | 2048436 | 2021-12-25 | Madison | Kentucky | 21151 | 18269 | 212 |
2045186 | 2045186 | 2021-12-24 | Madison | Kentucky | 21151 | 18269 | 212 |
2041937 | 2041937 | 2021-12-23 | Madison | Kentucky | 21151 | 18269 | 212 |
2038687 | 2038687 | 2021-12-22 | Madison | Kentucky | 21151 | 18269 | 212 |
2035437 | 2035437 | 2021-12-21 | Madison | Kentucky | 21151 | 18191 | 212 |
2032187 | 2032187 | 2021-12-20 | Madison | Kentucky | 21151 | 18105 | 212 |
2028936 | 2028936 | 2021-12-19 | Madison | Kentucky | 21151 | 18002 | 209 |
2025685 | 2025685 | 2021-12-18 | Madison | Kentucky | 21151 | 18002 | 209 |
2022434 | 2022434 | 2021-12-17 | Madison | Kentucky | 21151 | 18002 | 209 |
2019183 | 2019183 | 2021-12-16 | Madison | Kentucky | 21151 | 17921 | 208 |
2015933 | 2015933 | 2021-12-15 | Madison | Kentucky | 21151 | 17842 | 207 |
2012682 | 2012682 | 2021-12-14 | Madison | Kentucky | 21151 | 17784 | 207 |
2009431 | 2009431 | 2021-12-13 | Madison | Kentucky | 21151 | 17688 | 207 |
2006180 | 2006180 | 2021-12-12 | Madison | Kentucky | 21151 | 17586 | 206 |
2002929 | 2002929 | 2021-12-11 | Madison | Kentucky | 21151 | 17586 | 206 |
1999679 | 1999679 | 2021-12-10 | Madison | Kentucky | 21151 | 17586 | 206 |
1996428 | 1996428 | 2021-12-09 | Madison | Kentucky | 21151 | 17499 | 206 |
1993177 | 1993177 | 2021-12-08 | Madison | Kentucky | 21151 | 17440 | 202 |
1989926 | 1989926 | 2021-12-07 | Madison | Kentucky | 21151 | 17369 | 202 |
1986676 | 1986676 | 2021-12-06 | Madison | Kentucky | 21151 | 17248 | 200 |
1983426 | 1983426 | 2021-12-05 | Madison | Kentucky | 21151 | 17117 | 197 |
1980176 | 1980176 | 2021-12-04 | Madison | Kentucky | 21151 | 17117 | 197 |
1976926 | 1976926 | 2021-12-03 | Madison | Kentucky | 21151 | 17117 | 197 |
1973677 | 1973677 | 2021-12-02 | Madison | Kentucky | 21151 | 17034 | 197 |
1970427 | 1970427 | 2021-12-01 | Madison | Kentucky | 21151 | 16960 | 196 |
1967177 | 1967177 | 2021-11-30 | Madison | Kentucky | 21151 | 16903 | 195 |
1963925 | 1963925 | 2021-11-29 | Madison | Kentucky | 21151 | 16791 | 195 |
1960674 | 1960674 | 2021-11-28 | Madison | Kentucky | 21151 | 16676 | 191 |
1957423 | 1957423 | 2021-11-27 | Madison | Kentucky | 21151 | 16676 | 191 |
1954172 | 1954172 | 2021-11-26 | Madison | Kentucky | 21151 | 16676 | 191 |
1950921 | 1950921 | 2021-11-25 | Madison | Kentucky | 21151 | 16676 | 191 |
1947670 | 1947670 | 2021-11-24 | Madison | Kentucky | 21151 | 16676 | 191 |
1944419 | 1944419 | 2021-11-23 | Madison | Kentucky | 21151 | 16619 | 191 |
1941169 | 1941169 | 2021-11-22 | Madison | Kentucky | 21151 | 16519 | 190 |
1937919 | 1937919 | 2021-11-21 | Madison | Kentucky | 21151 | 16462 | 190 |
1934669 | 1934669 | 2021-11-20 | Madison | Kentucky | 21151 | 16462 | 190 |
1931418 | 1931418 | 2021-11-19 | Madison | Kentucky | 21151 | 16462 | 190 |
1928167 | 1928167 | 2021-11-18 | Madison | Kentucky | 21151 | 16421 | 189 |
1924917 | 1924917 | 2021-11-17 | Madison | Kentucky | 21151 | 16367 | 188 |
1921668 | 1921668 | 2021-11-16 | Madison | Kentucky | 21151 | 16303 | 187 |
1918418 | 1918418 | 2021-11-15 | Madison | Kentucky | 21151 | 16231 | 187 |
1915168 | 1915168 | 2021-11-14 | Madison | Kentucky | 21151 | 16175 | 186 |
1911918 | 1911918 | 2021-11-13 | Madison | Kentucky | 21151 | 16175 | 186 |
1908669 | 1908669 | 2021-11-12 | Madison | Kentucky | 21151 | 16175 | 186 |
1905420 | 1905420 | 2021-11-11 | Madison | Kentucky | 21151 | 16116 | 179 |
1902170 | 1902170 | 2021-11-10 | Madison | Kentucky | 21151 | 16116 | 179 |
1898920 | 1898920 | 2021-11-09 | Madison | Kentucky | 21151 | 16078 | 177 |
1895670 | 1895670 | 2021-11-08 | Madison | Kentucky | 21151 | 16023 | 176 |
1892420 | 1892420 | 2021-11-07 | Madison | Kentucky | 21151 | 15992 | 167 |
1889170 | 1889170 | 2021-11-06 | Madison | Kentucky | 21151 | 15992 | 167 |
1885920 | 1885920 | 2021-11-05 | Madison | Kentucky | 21151 | 15992 | 167 |
1882671 | 1882671 | 2021-11-04 | Madison | Kentucky | 21151 | 15962 | 163 |
1879422 | 1879422 | 2021-11-03 | Madison | Kentucky | 21151 | 15945 | 162 |
1876173 | 1876173 | 2021-11-02 | Madison | Kentucky | 21151 | 15923 | 162 |
1872924 | 1872924 | 2021-11-01 | Madison | Kentucky | 21151 | 15880 | 162 |
1869675 | 1869675 | 2021-10-31 | Madison | Kentucky | 21151 | 15834 | 160 |
1866426 | 1866426 | 2021-10-30 | Madison | Kentucky | 21151 | 15834 | 160 |
1863177 | 1863177 | 2021-10-29 | Madison | Kentucky | 21151 | 15834 | 160 |
1859928 | 1859928 | 2021-10-28 | Madison | Kentucky | 21151 | 15813 | 160 |
1856679 | 1856679 | 2021-10-27 | Madison | Kentucky | 21151 | 15791 | 160 |
1853430 | 1853430 | 2021-10-26 | Madison | Kentucky | 21151 | 15771 | 158 |
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);