ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Martin" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175273 | 2175273 | 2022-02-02 | Martin | Kentucky | 21159 | 2782 | 44 |
2172020 | 2172020 | 2022-02-01 | Martin | Kentucky | 21159 | 2754 | 44 |
2168767 | 2168767 | 2022-01-31 | Martin | Kentucky | 21159 | 2711 | 44 |
2165512 | 2165512 | 2022-01-30 | Martin | Kentucky | 21159 | 2692 | 44 |
2162257 | 2162257 | 2022-01-29 | Martin | Kentucky | 21159 | 2692 | 44 |
2159002 | 2159002 | 2022-01-28 | Martin | Kentucky | 21159 | 2692 | 44 |
2155748 | 2155748 | 2022-01-27 | Martin | Kentucky | 21159 | 2657 | 44 |
2152495 | 2152495 | 2022-01-26 | Martin | Kentucky | 21159 | 2645 | 44 |
2149243 | 2149243 | 2022-01-25 | Martin | Kentucky | 21159 | 2625 | 44 |
2145991 | 2145991 | 2022-01-24 | Martin | Kentucky | 21159 | 2586 | 44 |
2142736 | 2142736 | 2022-01-23 | Martin | Kentucky | 21159 | 2511 | 43 |
2139481 | 2139481 | 2022-01-22 | Martin | Kentucky | 21159 | 2511 | 43 |
2136225 | 2136225 | 2022-01-21 | Martin | Kentucky | 21159 | 2511 | 43 |
2132973 | 2132973 | 2022-01-20 | Martin | Kentucky | 21159 | 2479 | 43 |
2129720 | 2129720 | 2022-01-19 | Martin | Kentucky | 21159 | 2455 | 43 |
2126466 | 2126466 | 2022-01-18 | Martin | Kentucky | 21159 | 2429 | 43 |
2123214 | 2123214 | 2022-01-17 | Martin | Kentucky | 21159 | 2369 | 41 |
2119962 | 2119962 | 2022-01-16 | Martin | Kentucky | 21159 | 2369 | 41 |
2116710 | 2116710 | 2022-01-15 | Martin | Kentucky | 21159 | 2369 | 41 |
2113459 | 2113459 | 2022-01-14 | Martin | Kentucky | 21159 | 2369 | 41 |
2110207 | 2110207 | 2022-01-13 | Martin | Kentucky | 21159 | 2353 | 39 |
2106956 | 2106956 | 2022-01-12 | Martin | Kentucky | 21159 | 2346 | 39 |
2103705 | 2103705 | 2022-01-11 | Martin | Kentucky | 21159 | 2332 | 39 |
2100454 | 2100454 | 2022-01-10 | Martin | Kentucky | 21159 | 2308 | 39 |
2097203 | 2097203 | 2022-01-09 | Martin | Kentucky | 21159 | 2296 | 39 |
2093951 | 2093951 | 2022-01-08 | Martin | Kentucky | 21159 | 2296 | 39 |
2090699 | 2090699 | 2022-01-07 | Martin | Kentucky | 21159 | 2296 | 39 |
2087448 | 2087448 | 2022-01-06 | Martin | Kentucky | 21159 | 2281 | 39 |
2084196 | 2084196 | 2022-01-05 | Martin | Kentucky | 21159 | 2276 | 39 |
2080944 | 2080944 | 2022-01-04 | Martin | Kentucky | 21159 | 2263 | 39 |
2077692 | 2077692 | 2022-01-03 | Martin | Kentucky | 21159 | 2258 | 39 |
2074441 | 2074441 | 2022-01-02 | Martin | Kentucky | 21159 | 2228 | 39 |
2071190 | 2071190 | 2022-01-01 | Martin | Kentucky | 21159 | 2228 | 39 |
2067939 | 2067939 | 2021-12-31 | Martin | Kentucky | 21159 | 2228 | 39 |
2064688 | 2064688 | 2021-12-30 | Martin | Kentucky | 21159 | 2228 | 39 |
2061438 | 2061438 | 2021-12-29 | Martin | Kentucky | 21159 | 2228 | 39 |
2058189 | 2058189 | 2021-12-28 | Martin | Kentucky | 21159 | 2208 | 39 |
2054940 | 2054940 | 2021-12-27 | Martin | Kentucky | 21159 | 2205 | 39 |
2051690 | 2051690 | 2021-12-26 | Martin | Kentucky | 21159 | 2188 | 39 |
2048440 | 2048440 | 2021-12-25 | Martin | Kentucky | 21159 | 2188 | 39 |
2045190 | 2045190 | 2021-12-24 | Martin | Kentucky | 21159 | 2188 | 39 |
2041941 | 2041941 | 2021-12-23 | Martin | Kentucky | 21159 | 2188 | 39 |
2038691 | 2038691 | 2021-12-22 | Martin | Kentucky | 21159 | 2188 | 39 |
2035441 | 2035441 | 2021-12-21 | Martin | Kentucky | 21159 | 2182 | 39 |
2032191 | 2032191 | 2021-12-20 | Martin | Kentucky | 21159 | 2173 | 39 |
2028940 | 2028940 | 2021-12-19 | Martin | Kentucky | 21159 | 2162 | 38 |
2025689 | 2025689 | 2021-12-18 | Martin | Kentucky | 21159 | 2162 | 38 |
2022438 | 2022438 | 2021-12-17 | Martin | Kentucky | 21159 | 2162 | 38 |
2019187 | 2019187 | 2021-12-16 | Martin | Kentucky | 21159 | 2160 | 38 |
2015937 | 2015937 | 2021-12-15 | Martin | Kentucky | 21159 | 2153 | 38 |
2012686 | 2012686 | 2021-12-14 | Martin | Kentucky | 21159 | 2141 | 38 |
2009435 | 2009435 | 2021-12-13 | Martin | Kentucky | 21159 | 2118 | 38 |
2006184 | 2006184 | 2021-12-12 | Martin | Kentucky | 21159 | 2104 | 37 |
2002933 | 2002933 | 2021-12-11 | Martin | Kentucky | 21159 | 2104 | 37 |
1999683 | 1999683 | 2021-12-10 | Martin | Kentucky | 21159 | 2104 | 37 |
1996432 | 1996432 | 2021-12-09 | Martin | Kentucky | 21159 | 2098 | 37 |
1993181 | 1993181 | 2021-12-08 | Martin | Kentucky | 21159 | 2088 | 37 |
1989930 | 1989930 | 2021-12-07 | Martin | Kentucky | 21159 | 2081 | 37 |
1986680 | 1986680 | 2021-12-06 | Martin | Kentucky | 21159 | 2068 | 37 |
1983430 | 1983430 | 2021-12-05 | Martin | Kentucky | 21159 | 2062 | 37 |
1980180 | 1980180 | 2021-12-04 | Martin | Kentucky | 21159 | 2062 | 37 |
1976930 | 1976930 | 2021-12-03 | Martin | Kentucky | 21159 | 2062 | 37 |
1973681 | 1973681 | 2021-12-02 | Martin | Kentucky | 21159 | 2054 | 37 |
1970431 | 1970431 | 2021-12-01 | Martin | Kentucky | 21159 | 2049 | 37 |
1967181 | 1967181 | 2021-11-30 | Martin | Kentucky | 21159 | 2042 | 36 |
1963929 | 1963929 | 2021-11-29 | Martin | Kentucky | 21159 | 2041 | 36 |
1960678 | 1960678 | 2021-11-28 | Martin | Kentucky | 21159 | 2026 | 36 |
1957427 | 1957427 | 2021-11-27 | Martin | Kentucky | 21159 | 2026 | 36 |
1954176 | 1954176 | 2021-11-26 | Martin | Kentucky | 21159 | 2026 | 36 |
1950925 | 1950925 | 2021-11-25 | Martin | Kentucky | 21159 | 2026 | 36 |
1947674 | 1947674 | 2021-11-24 | Martin | Kentucky | 21159 | 2026 | 36 |
1944423 | 1944423 | 2021-11-23 | Martin | Kentucky | 21159 | 2022 | 36 |
1941173 | 1941173 | 2021-11-22 | Martin | Kentucky | 21159 | 2016 | 36 |
1937923 | 1937923 | 2021-11-21 | Martin | Kentucky | 21159 | 2006 | 36 |
1934673 | 1934673 | 2021-11-20 | Martin | Kentucky | 21159 | 2006 | 36 |
1931422 | 1931422 | 2021-11-19 | Martin | Kentucky | 21159 | 2006 | 36 |
1928171 | 1928171 | 2021-11-18 | Martin | Kentucky | 21159 | 2007 | 36 |
1924921 | 1924921 | 2021-11-17 | Martin | Kentucky | 21159 | 2003 | 36 |
1921672 | 1921672 | 2021-11-16 | Martin | Kentucky | 21159 | 1988 | 36 |
1918422 | 1918422 | 2021-11-15 | Martin | Kentucky | 21159 | 1984 | 36 |
1915172 | 1915172 | 2021-11-14 | Martin | Kentucky | 21159 | 1974 | 36 |
1911922 | 1911922 | 2021-11-13 | Martin | Kentucky | 21159 | 1974 | 36 |
1908673 | 1908673 | 2021-11-12 | Martin | Kentucky | 21159 | 1974 | 36 |
1905424 | 1905424 | 2021-11-11 | Martin | Kentucky | 21159 | 1969 | 36 |
1902174 | 1902174 | 2021-11-10 | Martin | Kentucky | 21159 | 1969 | 36 |
1898924 | 1898924 | 2021-11-09 | Martin | Kentucky | 21159 | 1964 | 36 |
1895674 | 1895674 | 2021-11-08 | Martin | Kentucky | 21159 | 1957 | 36 |
1892424 | 1892424 | 2021-11-07 | Martin | Kentucky | 21159 | 1956 | 35 |
1889174 | 1889174 | 2021-11-06 | Martin | Kentucky | 21159 | 1956 | 35 |
1885924 | 1885924 | 2021-11-05 | Martin | Kentucky | 21159 | 1956 | 35 |
1882675 | 1882675 | 2021-11-04 | Martin | Kentucky | 21159 | 1952 | 35 |
1879426 | 1879426 | 2021-11-03 | Martin | Kentucky | 21159 | 1936 | 35 |
1876177 | 1876177 | 2021-11-02 | Martin | Kentucky | 21159 | 1929 | 35 |
1872928 | 1872928 | 2021-11-01 | Martin | Kentucky | 21159 | 1924 | 35 |
1869679 | 1869679 | 2021-10-31 | Martin | Kentucky | 21159 | 1914 | 35 |
1866430 | 1866430 | 2021-10-30 | Martin | Kentucky | 21159 | 1914 | 35 |
1863181 | 1863181 | 2021-10-29 | Martin | Kentucky | 21159 | 1914 | 35 |
1859932 | 1859932 | 2021-10-28 | Martin | Kentucky | 21159 | 1912 | 35 |
1856683 | 1856683 | 2021-10-27 | Martin | Kentucky | 21159 | 1912 | 35 |
1853434 | 1853434 | 2021-10-26 | Martin | Kentucky | 21159 | 1902 | 35 |
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);