ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Marshall" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175272 | 2175272 | 2022-02-02 | Marshall | Kentucky | 21157 | 7815 | 91 |
2172019 | 2172019 | 2022-02-01 | Marshall | Kentucky | 21157 | 7769 | 91 |
2168766 | 2168766 | 2022-01-31 | Marshall | Kentucky | 21157 | 7724 | 91 |
2165511 | 2165511 | 2022-01-30 | Marshall | Kentucky | 21157 | 7527 | 91 |
2162256 | 2162256 | 2022-01-29 | Marshall | Kentucky | 21157 | 7527 | 91 |
2159001 | 2159001 | 2022-01-28 | Marshall | Kentucky | 21157 | 7527 | 91 |
2155747 | 2155747 | 2022-01-27 | Marshall | Kentucky | 21157 | 7385 | 91 |
2152494 | 2152494 | 2022-01-26 | Marshall | Kentucky | 21157 | 7270 | 91 |
2149242 | 2149242 | 2022-01-25 | Marshall | Kentucky | 21157 | 7146 | 91 |
2145990 | 2145990 | 2022-01-24 | Marshall | Kentucky | 21157 | 6965 | 91 |
2142735 | 2142735 | 2022-01-23 | Marshall | Kentucky | 21157 | 6729 | 91 |
2139480 | 2139480 | 2022-01-22 | Marshall | Kentucky | 21157 | 6729 | 91 |
2136224 | 2136224 | 2022-01-21 | Marshall | Kentucky | 21157 | 6729 | 91 |
2132972 | 2132972 | 2022-01-20 | Marshall | Kentucky | 21157 | 6620 | 91 |
2129719 | 2129719 | 2022-01-19 | Marshall | Kentucky | 21157 | 6564 | 91 |
2126465 | 2126465 | 2022-01-18 | Marshall | Kentucky | 21157 | 6466 | 91 |
2123213 | 2123213 | 2022-01-17 | Marshall | Kentucky | 21157 | 6181 | 90 |
2119961 | 2119961 | 2022-01-16 | Marshall | Kentucky | 21157 | 6181 | 90 |
2116709 | 2116709 | 2022-01-15 | Marshall | Kentucky | 21157 | 6181 | 90 |
2113458 | 2113458 | 2022-01-14 | Marshall | Kentucky | 21157 | 6181 | 90 |
2110206 | 2110206 | 2022-01-13 | Marshall | Kentucky | 21157 | 6076 | 90 |
2106955 | 2106955 | 2022-01-12 | Marshall | Kentucky | 21157 | 5995 | 90 |
2103704 | 2103704 | 2022-01-11 | Marshall | Kentucky | 21157 | 5957 | 89 |
2100453 | 2100453 | 2022-01-10 | Marshall | Kentucky | 21157 | 5905 | 89 |
2097202 | 2097202 | 2022-01-09 | Marshall | Kentucky | 21157 | 5827 | 89 |
2093950 | 2093950 | 2022-01-08 | Marshall | Kentucky | 21157 | 5827 | 89 |
2090698 | 2090698 | 2022-01-07 | Marshall | Kentucky | 21157 | 5827 | 89 |
2087447 | 2087447 | 2022-01-06 | Marshall | Kentucky | 21157 | 5781 | 88 |
2084195 | 2084195 | 2022-01-05 | Marshall | Kentucky | 21157 | 5766 | 87 |
2080943 | 2080943 | 2022-01-04 | Marshall | Kentucky | 21157 | 5692 | 86 |
2077691 | 2077691 | 2022-01-03 | Marshall | Kentucky | 21157 | 5644 | 86 |
2074440 | 2074440 | 2022-01-02 | Marshall | Kentucky | 21157 | 5580 | 85 |
2071189 | 2071189 | 2022-01-01 | Marshall | Kentucky | 21157 | 5580 | 85 |
2067938 | 2067938 | 2021-12-31 | Marshall | Kentucky | 21157 | 5580 | 85 |
2064687 | 2064687 | 2021-12-30 | Marshall | Kentucky | 21157 | 5580 | 85 |
2061437 | 2061437 | 2021-12-29 | Marshall | Kentucky | 21157 | 5580 | 85 |
2058188 | 2058188 | 2021-12-28 | Marshall | Kentucky | 21157 | 5529 | 85 |
2054939 | 2054939 | 2021-12-27 | Marshall | Kentucky | 21157 | 5507 | 85 |
2051689 | 2051689 | 2021-12-26 | Marshall | Kentucky | 21157 | 5465 | 85 |
2048439 | 2048439 | 2021-12-25 | Marshall | Kentucky | 21157 | 5465 | 85 |
2045189 | 2045189 | 2021-12-24 | Marshall | Kentucky | 21157 | 5465 | 85 |
2041940 | 2041940 | 2021-12-23 | Marshall | Kentucky | 21157 | 5465 | 85 |
2038690 | 2038690 | 2021-12-22 | Marshall | Kentucky | 21157 | 5465 | 85 |
2035440 | 2035440 | 2021-12-21 | Marshall | Kentucky | 21157 | 5435 | 85 |
2032190 | 2032190 | 2021-12-20 | Marshall | Kentucky | 21157 | 5393 | 85 |
2028939 | 2028939 | 2021-12-19 | Marshall | Kentucky | 21157 | 5371 | 85 |
2025688 | 2025688 | 2021-12-18 | Marshall | Kentucky | 21157 | 5371 | 85 |
2022437 | 2022437 | 2021-12-17 | Marshall | Kentucky | 21157 | 5371 | 85 |
2019186 | 2019186 | 2021-12-16 | Marshall | Kentucky | 21157 | 5358 | 85 |
2015936 | 2015936 | 2021-12-15 | Marshall | Kentucky | 21157 | 5338 | 85 |
2012685 | 2012685 | 2021-12-14 | Marshall | Kentucky | 21157 | 5326 | 85 |
2009434 | 2009434 | 2021-12-13 | Marshall | Kentucky | 21157 | 5323 | 85 |
2006183 | 2006183 | 2021-12-12 | Marshall | Kentucky | 21157 | 5304 | 85 |
2002932 | 2002932 | 2021-12-11 | Marshall | Kentucky | 21157 | 5304 | 85 |
1999682 | 1999682 | 2021-12-10 | Marshall | Kentucky | 21157 | 5304 | 85 |
1996431 | 1996431 | 2021-12-09 | Marshall | Kentucky | 21157 | 5286 | 85 |
1993180 | 1993180 | 2021-12-08 | Marshall | Kentucky | 21157 | 5268 | 85 |
1989929 | 1989929 | 2021-12-07 | Marshall | Kentucky | 21157 | 5261 | 85 |
1986679 | 1986679 | 2021-12-06 | Marshall | Kentucky | 21157 | 5248 | 83 |
1983429 | 1983429 | 2021-12-05 | Marshall | Kentucky | 21157 | 5239 | 82 |
1980179 | 1980179 | 2021-12-04 | Marshall | Kentucky | 21157 | 5239 | 82 |
1976929 | 1976929 | 2021-12-03 | Marshall | Kentucky | 21157 | 5239 | 82 |
1973680 | 1973680 | 2021-12-02 | Marshall | Kentucky | 21157 | 5233 | 81 |
1970430 | 1970430 | 2021-12-01 | Marshall | Kentucky | 21157 | 5221 | 80 |
1967180 | 1967180 | 2021-11-30 | Marshall | Kentucky | 21157 | 5199 | 80 |
1963928 | 1963928 | 2021-11-29 | Marshall | Kentucky | 21157 | 5187 | 80 |
1960677 | 1960677 | 2021-11-28 | Marshall | Kentucky | 21157 | 5163 | 80 |
1957426 | 1957426 | 2021-11-27 | Marshall | Kentucky | 21157 | 5163 | 80 |
1954175 | 1954175 | 2021-11-26 | Marshall | Kentucky | 21157 | 5163 | 80 |
1950924 | 1950924 | 2021-11-25 | Marshall | Kentucky | 21157 | 5163 | 80 |
1947673 | 1947673 | 2021-11-24 | Marshall | Kentucky | 21157 | 5163 | 80 |
1944422 | 1944422 | 2021-11-23 | Marshall | Kentucky | 21157 | 5155 | 80 |
1941172 | 1941172 | 2021-11-22 | Marshall | Kentucky | 21157 | 5147 | 80 |
1937922 | 1937922 | 2021-11-21 | Marshall | Kentucky | 21157 | 5132 | 80 |
1934672 | 1934672 | 2021-11-20 | Marshall | Kentucky | 21157 | 5132 | 80 |
1931421 | 1931421 | 2021-11-19 | Marshall | Kentucky | 21157 | 5132 | 80 |
1928170 | 1928170 | 2021-11-18 | Marshall | Kentucky | 21157 | 5128 | 80 |
1924920 | 1924920 | 2021-11-17 | Marshall | Kentucky | 21157 | 5114 | 80 |
1921671 | 1921671 | 2021-11-16 | Marshall | Kentucky | 21157 | 5097 | 80 |
1918421 | 1918421 | 2021-11-15 | Marshall | Kentucky | 21157 | 5091 | 80 |
1915171 | 1915171 | 2021-11-14 | Marshall | Kentucky | 21157 | 5077 | 80 |
1911921 | 1911921 | 2021-11-13 | Marshall | Kentucky | 21157 | 5077 | 80 |
1908672 | 1908672 | 2021-11-12 | Marshall | Kentucky | 21157 | 5077 | 80 |
1905423 | 1905423 | 2021-11-11 | Marshall | Kentucky | 21157 | 5074 | 79 |
1902173 | 1902173 | 2021-11-10 | Marshall | Kentucky | 21157 | 5074 | 79 |
1898923 | 1898923 | 2021-11-09 | Marshall | Kentucky | 21157 | 5061 | 79 |
1895673 | 1895673 | 2021-11-08 | Marshall | Kentucky | 21157 | 5054 | 79 |
1892423 | 1892423 | 2021-11-07 | Marshall | Kentucky | 21157 | 5049 | 79 |
1889173 | 1889173 | 2021-11-06 | Marshall | Kentucky | 21157 | 5049 | 79 |
1885923 | 1885923 | 2021-11-05 | Marshall | Kentucky | 21157 | 5049 | 79 |
1882674 | 1882674 | 2021-11-04 | Marshall | Kentucky | 21157 | 5047 | 79 |
1879425 | 1879425 | 2021-11-03 | Marshall | Kentucky | 21157 | 5046 | 78 |
1876176 | 1876176 | 2021-11-02 | Marshall | Kentucky | 21157 | 5041 | 78 |
1872927 | 1872927 | 2021-11-01 | Marshall | Kentucky | 21157 | 5038 | 78 |
1869678 | 1869678 | 2021-10-31 | Marshall | Kentucky | 21157 | 5031 | 78 |
1866429 | 1866429 | 2021-10-30 | Marshall | Kentucky | 21157 | 5031 | 78 |
1863180 | 1863180 | 2021-10-29 | Marshall | Kentucky | 21157 | 5031 | 78 |
1859931 | 1859931 | 2021-10-28 | Marshall | Kentucky | 21157 | 5027 | 78 |
1856682 | 1856682 | 2021-10-27 | Marshall | Kentucky | 21157 | 5020 | 78 |
1853433 | 1853433 | 2021-10-26 | Marshall | Kentucky | 21157 | 5016 | 78 |
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);