ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Johnson" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175254 | 2175254 | 2022-02-02 | Johnson | Kentucky | 21115 | 5312 | 86 |
2172001 | 2172001 | 2022-02-01 | Johnson | Kentucky | 21115 | 5281 | 85 |
2168748 | 2168748 | 2022-01-31 | Johnson | Kentucky | 21115 | 5215 | 85 |
2165493 | 2165493 | 2022-01-30 | Johnson | Kentucky | 21115 | 5133 | 84 |
2162238 | 2162238 | 2022-01-29 | Johnson | Kentucky | 21115 | 5133 | 84 |
2158983 | 2158983 | 2022-01-28 | Johnson | Kentucky | 21115 | 5133 | 84 |
2155729 | 2155729 | 2022-01-27 | Johnson | Kentucky | 21115 | 5052 | 83 |
2152476 | 2152476 | 2022-01-26 | Johnson | Kentucky | 21115 | 4949 | 83 |
2149224 | 2149224 | 2022-01-25 | Johnson | Kentucky | 21115 | 4836 | 83 |
2145972 | 2145972 | 2022-01-24 | Johnson | Kentucky | 21115 | 4760 | 83 |
2142717 | 2142717 | 2022-01-23 | Johnson | Kentucky | 21115 | 4708 | 82 |
2139462 | 2139462 | 2022-01-22 | Johnson | Kentucky | 21115 | 4708 | 82 |
2136206 | 2136206 | 2022-01-21 | Johnson | Kentucky | 21115 | 4708 | 82 |
2132954 | 2132954 | 2022-01-20 | Johnson | Kentucky | 21115 | 4668 | 82 |
2129701 | 2129701 | 2022-01-19 | Johnson | Kentucky | 21115 | 4625 | 82 |
2126447 | 2126447 | 2022-01-18 | Johnson | Kentucky | 21115 | 4560 | 82 |
2123195 | 2123195 | 2022-01-17 | Johnson | Kentucky | 21115 | 4466 | 82 |
2119943 | 2119943 | 2022-01-16 | Johnson | Kentucky | 21115 | 4466 | 82 |
2116691 | 2116691 | 2022-01-15 | Johnson | Kentucky | 21115 | 4466 | 82 |
2113440 | 2113440 | 2022-01-14 | Johnson | Kentucky | 21115 | 4466 | 82 |
2110188 | 2110188 | 2022-01-13 | Johnson | Kentucky | 21115 | 4416 | 82 |
2106937 | 2106937 | 2022-01-12 | Johnson | Kentucky | 21115 | 4372 | 82 |
2103686 | 2103686 | 2022-01-11 | Johnson | Kentucky | 21115 | 4332 | 82 |
2100435 | 2100435 | 2022-01-10 | Johnson | Kentucky | 21115 | 4301 | 82 |
2097184 | 2097184 | 2022-01-09 | Johnson | Kentucky | 21115 | 4280 | 80 |
2093932 | 2093932 | 2022-01-08 | Johnson | Kentucky | 21115 | 4280 | 80 |
2090680 | 2090680 | 2022-01-07 | Johnson | Kentucky | 21115 | 4280 | 80 |
2087429 | 2087429 | 2022-01-06 | Johnson | Kentucky | 21115 | 4263 | 80 |
2084177 | 2084177 | 2022-01-05 | Johnson | Kentucky | 21115 | 4241 | 80 |
2080925 | 2080925 | 2022-01-04 | Johnson | Kentucky | 21115 | 4220 | 80 |
2077673 | 2077673 | 2022-01-03 | Johnson | Kentucky | 21115 | 4198 | 79 |
2074422 | 2074422 | 2022-01-02 | Johnson | Kentucky | 21115 | 4158 | 78 |
2071171 | 2071171 | 2022-01-01 | Johnson | Kentucky | 21115 | 4158 | 78 |
2067920 | 2067920 | 2021-12-31 | Johnson | Kentucky | 21115 | 4158 | 78 |
2064669 | 2064669 | 2021-12-30 | Johnson | Kentucky | 21115 | 4158 | 78 |
2061419 | 2061419 | 2021-12-29 | Johnson | Kentucky | 21115 | 4158 | 78 |
2058170 | 2058170 | 2021-12-28 | Johnson | Kentucky | 21115 | 4141 | 78 |
2054921 | 2054921 | 2021-12-27 | Johnson | Kentucky | 21115 | 4134 | 78 |
2051671 | 2051671 | 2021-12-26 | Johnson | Kentucky | 21115 | 4107 | 75 |
2048421 | 2048421 | 2021-12-25 | Johnson | Kentucky | 21115 | 4107 | 75 |
2045171 | 2045171 | 2021-12-24 | Johnson | Kentucky | 21115 | 4107 | 75 |
2041922 | 2041922 | 2021-12-23 | Johnson | Kentucky | 21115 | 4107 | 75 |
2038672 | 2038672 | 2021-12-22 | Johnson | Kentucky | 21115 | 4107 | 75 |
2035422 | 2035422 | 2021-12-21 | Johnson | Kentucky | 21115 | 4101 | 75 |
2032172 | 2032172 | 2021-12-20 | Johnson | Kentucky | 21115 | 4092 | 75 |
2028921 | 2028921 | 2021-12-19 | Johnson | Kentucky | 21115 | 4075 | 75 |
2025670 | 2025670 | 2021-12-18 | Johnson | Kentucky | 21115 | 4075 | 75 |
2022419 | 2022419 | 2021-12-17 | Johnson | Kentucky | 21115 | 4075 | 75 |
2019168 | 2019168 | 2021-12-16 | Johnson | Kentucky | 21115 | 4070 | 75 |
2015918 | 2015918 | 2021-12-15 | Johnson | Kentucky | 21115 | 4063 | 75 |
2012667 | 2012667 | 2021-12-14 | Johnson | Kentucky | 21115 | 4053 | 75 |
2009416 | 2009416 | 2021-12-13 | Johnson | Kentucky | 21115 | 4040 | 75 |
2006165 | 2006165 | 2021-12-12 | Johnson | Kentucky | 21115 | 4020 | 74 |
2002914 | 2002914 | 2021-12-11 | Johnson | Kentucky | 21115 | 4020 | 74 |
1999664 | 1999664 | 2021-12-10 | Johnson | Kentucky | 21115 | 4020 | 74 |
1996413 | 1996413 | 2021-12-09 | Johnson | Kentucky | 21115 | 4006 | 74 |
1993162 | 1993162 | 2021-12-08 | Johnson | Kentucky | 21115 | 3984 | 73 |
1989911 | 1989911 | 2021-12-07 | Johnson | Kentucky | 21115 | 3973 | 73 |
1986661 | 1986661 | 2021-12-06 | Johnson | Kentucky | 21115 | 3962 | 71 |
1983411 | 1983411 | 2021-12-05 | Johnson | Kentucky | 21115 | 3955 | 67 |
1980161 | 1980161 | 2021-12-04 | Johnson | Kentucky | 21115 | 3955 | 67 |
1976911 | 1976911 | 2021-12-03 | Johnson | Kentucky | 21115 | 3955 | 67 |
1973662 | 1973662 | 2021-12-02 | Johnson | Kentucky | 21115 | 3946 | 64 |
1970412 | 1970412 | 2021-12-01 | Johnson | Kentucky | 21115 | 3941 | 64 |
1967162 | 1967162 | 2021-11-30 | Johnson | Kentucky | 21115 | 3930 | 64 |
1963910 | 1963910 | 2021-11-29 | Johnson | Kentucky | 21115 | 3919 | 62 |
1960659 | 1960659 | 2021-11-28 | Johnson | Kentucky | 21115 | 3901 | 62 |
1957408 | 1957408 | 2021-11-27 | Johnson | Kentucky | 21115 | 3901 | 62 |
1954157 | 1954157 | 2021-11-26 | Johnson | Kentucky | 21115 | 3901 | 62 |
1950906 | 1950906 | 2021-11-25 | Johnson | Kentucky | 21115 | 3901 | 62 |
1947655 | 1947655 | 2021-11-24 | Johnson | Kentucky | 21115 | 3901 | 62 |
1944404 | 1944404 | 2021-11-23 | Johnson | Kentucky | 21115 | 3890 | 60 |
1941154 | 1941154 | 2021-11-22 | Johnson | Kentucky | 21115 | 3886 | 55 |
1937904 | 1937904 | 2021-11-21 | Johnson | Kentucky | 21115 | 3868 | 51 |
1934654 | 1934654 | 2021-11-20 | Johnson | Kentucky | 21115 | 3868 | 51 |
1931403 | 1931403 | 2021-11-19 | Johnson | Kentucky | 21115 | 3868 | 51 |
1928152 | 1928152 | 2021-11-18 | Johnson | Kentucky | 21115 | 3864 | 50 |
1924902 | 1924902 | 2021-11-17 | Johnson | Kentucky | 21115 | 3839 | 50 |
1921653 | 1921653 | 2021-11-16 | Johnson | Kentucky | 21115 | 3831 | 50 |
1918403 | 1918403 | 2021-11-15 | Johnson | Kentucky | 21115 | 3821 | 50 |
1915153 | 1915153 | 2021-11-14 | Johnson | Kentucky | 21115 | 3811 | 49 |
1911903 | 1911903 | 2021-11-13 | Johnson | Kentucky | 21115 | 3811 | 49 |
1908654 | 1908654 | 2021-11-12 | Johnson | Kentucky | 21115 | 3811 | 49 |
1905405 | 1905405 | 2021-11-11 | Johnson | Kentucky | 21115 | 3801 | 49 |
1902155 | 1902155 | 2021-11-10 | Johnson | Kentucky | 21115 | 3801 | 49 |
1898905 | 1898905 | 2021-11-09 | Johnson | Kentucky | 21115 | 3790 | 49 |
1895655 | 1895655 | 2021-11-08 | Johnson | Kentucky | 21115 | 3787 | 48 |
1892405 | 1892405 | 2021-11-07 | Johnson | Kentucky | 21115 | 3784 | 48 |
1889155 | 1889155 | 2021-11-06 | Johnson | Kentucky | 21115 | 3784 | 48 |
1885905 | 1885905 | 2021-11-05 | Johnson | Kentucky | 21115 | 3784 | 48 |
1882656 | 1882656 | 2021-11-04 | Johnson | Kentucky | 21115 | 3768 | 48 |
1879407 | 1879407 | 2021-11-03 | Johnson | Kentucky | 21115 | 3762 | 48 |
1876158 | 1876158 | 2021-11-02 | Johnson | Kentucky | 21115 | 3734 | 48 |
1872909 | 1872909 | 2021-11-01 | Johnson | Kentucky | 21115 | 3725 | 48 |
1869660 | 1869660 | 2021-10-31 | Johnson | Kentucky | 21115 | 3721 | 47 |
1866411 | 1866411 | 2021-10-30 | Johnson | Kentucky | 21115 | 3721 | 47 |
1863162 | 1863162 | 2021-10-29 | Johnson | Kentucky | 21115 | 3721 | 47 |
1859913 | 1859913 | 2021-10-28 | Johnson | Kentucky | 21115 | 3721 | 47 |
1856664 | 1856664 | 2021-10-27 | Johnson | Kentucky | 21115 | 3702 | 47 |
1853415 | 1853415 | 2021-10-26 | Johnson | Kentucky | 21115 | 3694 | 46 |
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);