ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Lawrence" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175260 | 2175260 | 2022-02-02 | Lawrence | Kentucky | 21127 | 3944 | 53 |
2172007 | 2172007 | 2022-02-01 | Lawrence | Kentucky | 21127 | 3909 | 53 |
2168754 | 2168754 | 2022-01-31 | Lawrence | Kentucky | 21127 | 3873 | 53 |
2165499 | 2165499 | 2022-01-30 | Lawrence | Kentucky | 21127 | 3786 | 53 |
2162244 | 2162244 | 2022-01-29 | Lawrence | Kentucky | 21127 | 3786 | 53 |
2158989 | 2158989 | 2022-01-28 | Lawrence | Kentucky | 21127 | 3786 | 53 |
2155735 | 2155735 | 2022-01-27 | Lawrence | Kentucky | 21127 | 3749 | 52 |
2152482 | 2152482 | 2022-01-26 | Lawrence | Kentucky | 21127 | 3716 | 52 |
2149230 | 2149230 | 2022-01-25 | Lawrence | Kentucky | 21127 | 3678 | 52 |
2145978 | 2145978 | 2022-01-24 | Lawrence | Kentucky | 21127 | 3623 | 52 |
2142723 | 2142723 | 2022-01-23 | Lawrence | Kentucky | 21127 | 3570 | 51 |
2139468 | 2139468 | 2022-01-22 | Lawrence | Kentucky | 21127 | 3570 | 51 |
2136212 | 2136212 | 2022-01-21 | Lawrence | Kentucky | 21127 | 3570 | 51 |
2132960 | 2132960 | 2022-01-20 | Lawrence | Kentucky | 21127 | 3523 | 51 |
2129707 | 2129707 | 2022-01-19 | Lawrence | Kentucky | 21127 | 3484 | 51 |
2126453 | 2126453 | 2022-01-18 | Lawrence | Kentucky | 21127 | 3449 | 50 |
2123201 | 2123201 | 2022-01-17 | Lawrence | Kentucky | 21127 | 3385 | 50 |
2119949 | 2119949 | 2022-01-16 | Lawrence | Kentucky | 21127 | 3385 | 50 |
2116697 | 2116697 | 2022-01-15 | Lawrence | Kentucky | 21127 | 3385 | 50 |
2113446 | 2113446 | 2022-01-14 | Lawrence | Kentucky | 21127 | 3385 | 50 |
2110194 | 2110194 | 2022-01-13 | Lawrence | Kentucky | 21127 | 3363 | 50 |
2106943 | 2106943 | 2022-01-12 | Lawrence | Kentucky | 21127 | 3342 | 50 |
2103692 | 2103692 | 2022-01-11 | Lawrence | Kentucky | 21127 | 3328 | 50 |
2100441 | 2100441 | 2022-01-10 | Lawrence | Kentucky | 21127 | 3302 | 50 |
2097190 | 2097190 | 2022-01-09 | Lawrence | Kentucky | 21127 | 3287 | 48 |
2093938 | 2093938 | 2022-01-08 | Lawrence | Kentucky | 21127 | 3287 | 48 |
2090686 | 2090686 | 2022-01-07 | Lawrence | Kentucky | 21127 | 3287 | 48 |
2087435 | 2087435 | 2022-01-06 | Lawrence | Kentucky | 21127 | 3257 | 48 |
2084183 | 2084183 | 2022-01-05 | Lawrence | Kentucky | 21127 | 3244 | 48 |
2080931 | 2080931 | 2022-01-04 | Lawrence | Kentucky | 21127 | 3204 | 48 |
2077679 | 2077679 | 2022-01-03 | Lawrence | Kentucky | 21127 | 3196 | 48 |
2074428 | 2074428 | 2022-01-02 | Lawrence | Kentucky | 21127 | 3167 | 48 |
2071177 | 2071177 | 2022-01-01 | Lawrence | Kentucky | 21127 | 3167 | 48 |
2067926 | 2067926 | 2021-12-31 | Lawrence | Kentucky | 21127 | 3167 | 48 |
2064675 | 2064675 | 2021-12-30 | Lawrence | Kentucky | 21127 | 3167 | 48 |
2061425 | 2061425 | 2021-12-29 | Lawrence | Kentucky | 21127 | 3167 | 48 |
2058176 | 2058176 | 2021-12-28 | Lawrence | Kentucky | 21127 | 3158 | 48 |
2054927 | 2054927 | 2021-12-27 | Lawrence | Kentucky | 21127 | 3145 | 48 |
2051677 | 2051677 | 2021-12-26 | Lawrence | Kentucky | 21127 | 3124 | 48 |
2048427 | 2048427 | 2021-12-25 | Lawrence | Kentucky | 21127 | 3124 | 48 |
2045177 | 2045177 | 2021-12-24 | Lawrence | Kentucky | 21127 | 3124 | 48 |
2041928 | 2041928 | 2021-12-23 | Lawrence | Kentucky | 21127 | 3124 | 48 |
2038678 | 2038678 | 2021-12-22 | Lawrence | Kentucky | 21127 | 3124 | 48 |
2035428 | 2035428 | 2021-12-21 | Lawrence | Kentucky | 21127 | 3115 | 47 |
2032178 | 2032178 | 2021-12-20 | Lawrence | Kentucky | 21127 | 3106 | 47 |
2028927 | 2028927 | 2021-12-19 | Lawrence | Kentucky | 21127 | 3088 | 46 |
2025676 | 2025676 | 2021-12-18 | Lawrence | Kentucky | 21127 | 3088 | 46 |
2022425 | 2022425 | 2021-12-17 | Lawrence | Kentucky | 21127 | 3088 | 46 |
2019174 | 2019174 | 2021-12-16 | Lawrence | Kentucky | 21127 | 3081 | 46 |
2015924 | 2015924 | 2021-12-15 | Lawrence | Kentucky | 21127 | 3071 | 46 |
2012673 | 2012673 | 2021-12-14 | Lawrence | Kentucky | 21127 | 3055 | 46 |
2009422 | 2009422 | 2021-12-13 | Lawrence | Kentucky | 21127 | 3037 | 45 |
2006171 | 2006171 | 2021-12-12 | Lawrence | Kentucky | 21127 | 3010 | 44 |
2002920 | 2002920 | 2021-12-11 | Lawrence | Kentucky | 21127 | 3010 | 44 |
1999670 | 1999670 | 2021-12-10 | Lawrence | Kentucky | 21127 | 3010 | 44 |
1996419 | 1996419 | 2021-12-09 | Lawrence | Kentucky | 21127 | 2993 | 44 |
1993168 | 1993168 | 2021-12-08 | Lawrence | Kentucky | 21127 | 2983 | 44 |
1989917 | 1989917 | 2021-12-07 | Lawrence | Kentucky | 21127 | 2972 | 44 |
1986667 | 1986667 | 2021-12-06 | Lawrence | Kentucky | 21127 | 2953 | 44 |
1983417 | 1983417 | 2021-12-05 | Lawrence | Kentucky | 21127 | 2918 | 44 |
1980167 | 1980167 | 2021-12-04 | Lawrence | Kentucky | 21127 | 2918 | 44 |
1976917 | 1976917 | 2021-12-03 | Lawrence | Kentucky | 21127 | 2918 | 44 |
1973668 | 1973668 | 2021-12-02 | Lawrence | Kentucky | 21127 | 2898 | 44 |
1970418 | 1970418 | 2021-12-01 | Lawrence | Kentucky | 21127 | 2887 | 44 |
1967168 | 1967168 | 2021-11-30 | Lawrence | Kentucky | 21127 | 2858 | 44 |
1963916 | 1963916 | 2021-11-29 | Lawrence | Kentucky | 21127 | 2842 | 44 |
1960665 | 1960665 | 2021-11-28 | Lawrence | Kentucky | 21127 | 2803 | 44 |
1957414 | 1957414 | 2021-11-27 | Lawrence | Kentucky | 21127 | 2803 | 44 |
1954163 | 1954163 | 2021-11-26 | Lawrence | Kentucky | 21127 | 2803 | 44 |
1950912 | 1950912 | 2021-11-25 | Lawrence | Kentucky | 21127 | 2803 | 44 |
1947661 | 1947661 | 2021-11-24 | Lawrence | Kentucky | 21127 | 2803 | 44 |
1944410 | 1944410 | 2021-11-23 | Lawrence | Kentucky | 21127 | 2791 | 43 |
1941160 | 1941160 | 2021-11-22 | Lawrence | Kentucky | 21127 | 2766 | 43 |
1937910 | 1937910 | 2021-11-21 | Lawrence | Kentucky | 21127 | 2755 | 43 |
1934660 | 1934660 | 2021-11-20 | Lawrence | Kentucky | 21127 | 2755 | 43 |
1931409 | 1931409 | 2021-11-19 | Lawrence | Kentucky | 21127 | 2755 | 43 |
1928158 | 1928158 | 2021-11-18 | Lawrence | Kentucky | 21127 | 2746 | 42 |
1924908 | 1924908 | 2021-11-17 | Lawrence | Kentucky | 21127 | 2743 | 42 |
1921659 | 1921659 | 2021-11-16 | Lawrence | Kentucky | 21127 | 2738 | 42 |
1918409 | 1918409 | 2021-11-15 | Lawrence | Kentucky | 21127 | 2731 | 42 |
1915159 | 1915159 | 2021-11-14 | Lawrence | Kentucky | 21127 | 2725 | 42 |
1911909 | 1911909 | 2021-11-13 | Lawrence | Kentucky | 21127 | 2725 | 42 |
1908660 | 1908660 | 2021-11-12 | Lawrence | Kentucky | 21127 | 2725 | 42 |
1905411 | 1905411 | 2021-11-11 | Lawrence | Kentucky | 21127 | 2712 | 42 |
1902161 | 1902161 | 2021-11-10 | Lawrence | Kentucky | 21127 | 2712 | 42 |
1898911 | 1898911 | 2021-11-09 | Lawrence | Kentucky | 21127 | 2702 | 41 |
1895661 | 1895661 | 2021-11-08 | Lawrence | Kentucky | 21127 | 2698 | 40 |
1892411 | 1892411 | 2021-11-07 | Lawrence | Kentucky | 21127 | 2689 | 40 |
1889161 | 1889161 | 2021-11-06 | Lawrence | Kentucky | 21127 | 2689 | 40 |
1885911 | 1885911 | 2021-11-05 | Lawrence | Kentucky | 21127 | 2689 | 40 |
1882662 | 1882662 | 2021-11-04 | Lawrence | Kentucky | 21127 | 2681 | 40 |
1879413 | 1879413 | 2021-11-03 | Lawrence | Kentucky | 21127 | 2678 | 39 |
1876164 | 1876164 | 2021-11-02 | Lawrence | Kentucky | 21127 | 2672 | 39 |
1872915 | 1872915 | 2021-11-01 | Lawrence | Kentucky | 21127 | 2664 | 39 |
1869666 | 1869666 | 2021-10-31 | Lawrence | Kentucky | 21127 | 2660 | 39 |
1866417 | 1866417 | 2021-10-30 | Lawrence | Kentucky | 21127 | 2660 | 39 |
1863168 | 1863168 | 2021-10-29 | Lawrence | Kentucky | 21127 | 2660 | 39 |
1859919 | 1859919 | 2021-10-28 | Lawrence | Kentucky | 21127 | 2652 | 39 |
1856670 | 1856670 | 2021-10-27 | Lawrence | Kentucky | 21127 | 2640 | 39 |
1853421 | 1853421 | 2021-10-26 | Lawrence | Kentucky | 21127 | 2628 | 39 |
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);