ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 21215 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175304 | 2175304 | 2022-02-02 | Spencer | Kentucky | 21215 | 4953 | 48 |
2172051 | 2172051 | 2022-02-01 | Spencer | Kentucky | 21215 | 4920 | 48 |
2168798 | 2168798 | 2022-01-31 | Spencer | Kentucky | 21215 | 4880 | 48 |
2165543 | 2165543 | 2022-01-30 | Spencer | Kentucky | 21215 | 4820 | 48 |
2162288 | 2162288 | 2022-01-29 | Spencer | Kentucky | 21215 | 4820 | 48 |
2159033 | 2159033 | 2022-01-28 | Spencer | Kentucky | 21215 | 4820 | 48 |
2155779 | 2155779 | 2022-01-27 | Spencer | Kentucky | 21215 | 4761 | 48 |
2152526 | 2152526 | 2022-01-26 | Spencer | Kentucky | 21215 | 4693 | 44 |
2149274 | 2149274 | 2022-01-25 | Spencer | Kentucky | 21215 | 4622 | 44 |
2146022 | 2146022 | 2022-01-24 | Spencer | Kentucky | 21215 | 4517 | 44 |
2142767 | 2142767 | 2022-01-23 | Spencer | Kentucky | 21215 | 4367 | 44 |
2139512 | 2139512 | 2022-01-22 | Spencer | Kentucky | 21215 | 4367 | 44 |
2136256 | 2136256 | 2022-01-21 | Spencer | Kentucky | 21215 | 4367 | 44 |
2133004 | 2133004 | 2022-01-20 | Spencer | Kentucky | 21215 | 4280 | 44 |
2129751 | 2129751 | 2022-01-19 | Spencer | Kentucky | 21215 | 4209 | 44 |
2126497 | 2126497 | 2022-01-18 | Spencer | Kentucky | 21215 | 4127 | 44 |
2123245 | 2123245 | 2022-01-17 | Spencer | Kentucky | 21215 | 3892 | 44 |
2119993 | 2119993 | 2022-01-16 | Spencer | Kentucky | 21215 | 3892 | 44 |
2116741 | 2116741 | 2022-01-15 | Spencer | Kentucky | 21215 | 3892 | 44 |
2113490 | 2113490 | 2022-01-14 | Spencer | Kentucky | 21215 | 3892 | 44 |
2110238 | 2110238 | 2022-01-13 | Spencer | Kentucky | 21215 | 3836 | 44 |
2106987 | 2106987 | 2022-01-12 | Spencer | Kentucky | 21215 | 3812 | 44 |
2103736 | 2103736 | 2022-01-11 | Spencer | Kentucky | 21215 | 3746 | 44 |
2100485 | 2100485 | 2022-01-10 | Spencer | Kentucky | 21215 | 3679 | 44 |
2097234 | 2097234 | 2022-01-09 | Spencer | Kentucky | 21215 | 3613 | 44 |
2093982 | 2093982 | 2022-01-08 | Spencer | Kentucky | 21215 | 3613 | 44 |
2090730 | 2090730 | 2022-01-07 | Spencer | Kentucky | 21215 | 3613 | 44 |
2087479 | 2087479 | 2022-01-06 | Spencer | Kentucky | 21215 | 3568 | 44 |
2084227 | 2084227 | 2022-01-05 | Spencer | Kentucky | 21215 | 3543 | 44 |
2080975 | 2080975 | 2022-01-04 | Spencer | Kentucky | 21215 | 3503 | 44 |
2077723 | 2077723 | 2022-01-03 | Spencer | Kentucky | 21215 | 3493 | 44 |
2074472 | 2074472 | 2022-01-02 | Spencer | Kentucky | 21215 | 3415 | 43 |
2071221 | 2071221 | 2022-01-01 | Spencer | Kentucky | 21215 | 3415 | 43 |
2067970 | 2067970 | 2021-12-31 | Spencer | Kentucky | 21215 | 3415 | 43 |
2064719 | 2064719 | 2021-12-30 | Spencer | Kentucky | 21215 | 3415 | 43 |
2061469 | 2061469 | 2021-12-29 | Spencer | Kentucky | 21215 | 3415 | 43 |
2058220 | 2058220 | 2021-12-28 | Spencer | Kentucky | 21215 | 3382 | 43 |
2054971 | 2054971 | 2021-12-27 | Spencer | Kentucky | 21215 | 3374 | 43 |
2051721 | 2051721 | 2021-12-26 | Spencer | Kentucky | 21215 | 3345 | 43 |
2048471 | 2048471 | 2021-12-25 | Spencer | Kentucky | 21215 | 3345 | 43 |
2045221 | 2045221 | 2021-12-24 | Spencer | Kentucky | 21215 | 3345 | 43 |
2041972 | 2041972 | 2021-12-23 | Spencer | Kentucky | 21215 | 3345 | 43 |
2038722 | 2038722 | 2021-12-22 | Spencer | Kentucky | 21215 | 3345 | 43 |
2035472 | 2035472 | 2021-12-21 | Spencer | Kentucky | 21215 | 3343 | 43 |
2032222 | 2032222 | 2021-12-20 | Spencer | Kentucky | 21215 | 3332 | 43 |
2028971 | 2028971 | 2021-12-19 | Spencer | Kentucky | 21215 | 3299 | 42 |
2025720 | 2025720 | 2021-12-18 | Spencer | Kentucky | 21215 | 3299 | 42 |
2022469 | 2022469 | 2021-12-17 | Spencer | Kentucky | 21215 | 3299 | 42 |
2019218 | 2019218 | 2021-12-16 | Spencer | Kentucky | 21215 | 3287 | 42 |
2015968 | 2015968 | 2021-12-15 | Spencer | Kentucky | 21215 | 3281 | 41 |
2012717 | 2012717 | 2021-12-14 | Spencer | Kentucky | 21215 | 3273 | 41 |
2009466 | 2009466 | 2021-12-13 | Spencer | Kentucky | 21215 | 3261 | 41 |
2006215 | 2006215 | 2021-12-12 | Spencer | Kentucky | 21215 | 3241 | 40 |
2002964 | 2002964 | 2021-12-11 | Spencer | Kentucky | 21215 | 3241 | 40 |
1999714 | 1999714 | 2021-12-10 | Spencer | Kentucky | 21215 | 3241 | 40 |
1996463 | 1996463 | 2021-12-09 | Spencer | Kentucky | 21215 | 3234 | 40 |
1993212 | 1993212 | 2021-12-08 | Spencer | Kentucky | 21215 | 3227 | 40 |
1989961 | 1989961 | 2021-12-07 | Spencer | Kentucky | 21215 | 3204 | 40 |
1986711 | 1986711 | 2021-12-06 | Spencer | Kentucky | 21215 | 3196 | 40 |
1983461 | 1983461 | 2021-12-05 | Spencer | Kentucky | 21215 | 3170 | 40 |
1980211 | 1980211 | 2021-12-04 | Spencer | Kentucky | 21215 | 3170 | 40 |
1976961 | 1976961 | 2021-12-03 | Spencer | Kentucky | 21215 | 3170 | 40 |
1973712 | 1973712 | 2021-12-02 | Spencer | Kentucky | 21215 | 3148 | 40 |
1970462 | 1970462 | 2021-12-01 | Spencer | Kentucky | 21215 | 3138 | 40 |
1967212 | 1967212 | 2021-11-30 | Spencer | Kentucky | 21215 | 3112 | 40 |
1963960 | 1963960 | 2021-11-29 | Spencer | Kentucky | 21215 | 3100 | 40 |
1960709 | 1960709 | 2021-11-28 | Spencer | Kentucky | 21215 | 3056 | 38 |
1957458 | 1957458 | 2021-11-27 | Spencer | Kentucky | 21215 | 3056 | 38 |
1954207 | 1954207 | 2021-11-26 | Spencer | Kentucky | 21215 | 3056 | 38 |
1950956 | 1950956 | 2021-11-25 | Spencer | Kentucky | 21215 | 3056 | 38 |
1947705 | 1947705 | 2021-11-24 | Spencer | Kentucky | 21215 | 3056 | 38 |
1944454 | 1944454 | 2021-11-23 | Spencer | Kentucky | 21215 | 3039 | 38 |
1941204 | 1941204 | 2021-11-22 | Spencer | Kentucky | 21215 | 3022 | 36 |
1937954 | 1937954 | 2021-11-21 | Spencer | Kentucky | 21215 | 2996 | 36 |
1934704 | 1934704 | 2021-11-20 | Spencer | Kentucky | 21215 | 2996 | 36 |
1931453 | 1931453 | 2021-11-19 | Spencer | Kentucky | 21215 | 2996 | 36 |
1928202 | 1928202 | 2021-11-18 | Spencer | Kentucky | 21215 | 3002 | 35 |
1924952 | 1924952 | 2021-11-17 | Spencer | Kentucky | 21215 | 2986 | 35 |
1921703 | 1921703 | 2021-11-16 | Spencer | Kentucky | 21215 | 2969 | 35 |
1918453 | 1918453 | 2021-11-15 | Spencer | Kentucky | 21215 | 2961 | 35 |
1915203 | 1915203 | 2021-11-14 | Spencer | Kentucky | 21215 | 2944 | 35 |
1911953 | 1911953 | 2021-11-13 | Spencer | Kentucky | 21215 | 2944 | 35 |
1908704 | 1908704 | 2021-11-12 | Spencer | Kentucky | 21215 | 2944 | 35 |
1905455 | 1905455 | 2021-11-11 | Spencer | Kentucky | 21215 | 2936 | 34 |
1902205 | 1902205 | 2021-11-10 | Spencer | Kentucky | 21215 | 2936 | 34 |
1898955 | 1898955 | 2021-11-09 | Spencer | Kentucky | 21215 | 2924 | 34 |
1895705 | 1895705 | 2021-11-08 | Spencer | Kentucky | 21215 | 2917 | 34 |
1892455 | 1892455 | 2021-11-07 | Spencer | Kentucky | 21215 | 2907 | 34 |
1889205 | 1889205 | 2021-11-06 | Spencer | Kentucky | 21215 | 2907 | 34 |
1885955 | 1885955 | 2021-11-05 | Spencer | Kentucky | 21215 | 2907 | 34 |
1882706 | 1882706 | 2021-11-04 | Spencer | Kentucky | 21215 | 2901 | 34 |
1879457 | 1879457 | 2021-11-03 | Spencer | Kentucky | 21215 | 2894 | 34 |
1876208 | 1876208 | 2021-11-02 | Spencer | Kentucky | 21215 | 2887 | 34 |
1872959 | 1872959 | 2021-11-01 | Spencer | Kentucky | 21215 | 2879 | 34 |
1869710 | 1869710 | 2021-10-31 | Spencer | Kentucky | 21215 | 2868 | 34 |
1866461 | 1866461 | 2021-10-30 | Spencer | Kentucky | 21215 | 2868 | 34 |
1863212 | 1863212 | 2021-10-29 | Spencer | Kentucky | 21215 | 2868 | 34 |
1859963 | 1859963 | 2021-10-28 | Spencer | Kentucky | 21215 | 2856 | 34 |
1856714 | 1856714 | 2021-10-27 | Spencer | Kentucky | 21215 | 2850 | 34 |
1853465 | 1853465 | 2021-10-26 | Spencer | Kentucky | 21215 | 2844 | 34 |
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);