ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Pulaski" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175296 | 2175296 | 2022-02-02 | Pulaski | Kentucky | 21199 | 14282 | 243 |
2172043 | 2172043 | 2022-02-01 | Pulaski | Kentucky | 21199 | 14196 | 243 |
2168790 | 2168790 | 2022-01-31 | Pulaski | Kentucky | 21199 | 14127 | 243 |
2165535 | 2165535 | 2022-01-30 | Pulaski | Kentucky | 21199 | 13954 | 240 |
2162280 | 2162280 | 2022-01-29 | Pulaski | Kentucky | 21199 | 13954 | 240 |
2159025 | 2159025 | 2022-01-28 | Pulaski | Kentucky | 21199 | 13954 | 240 |
2155771 | 2155771 | 2022-01-27 | Pulaski | Kentucky | 21199 | 13779 | 239 |
2152518 | 2152518 | 2022-01-26 | Pulaski | Kentucky | 21199 | 13663 | 239 |
2149266 | 2149266 | 2022-01-25 | Pulaski | Kentucky | 21199 | 13556 | 239 |
2146014 | 2146014 | 2022-01-24 | Pulaski | Kentucky | 21199 | 13469 | 239 |
2142759 | 2142759 | 2022-01-23 | Pulaski | Kentucky | 21199 | 13233 | 235 |
2139504 | 2139504 | 2022-01-22 | Pulaski | Kentucky | 21199 | 13233 | 235 |
2136248 | 2136248 | 2022-01-21 | Pulaski | Kentucky | 21199 | 13233 | 235 |
2132996 | 2132996 | 2022-01-20 | Pulaski | Kentucky | 21199 | 13119 | 235 |
2129743 | 2129743 | 2022-01-19 | Pulaski | Kentucky | 21199 | 13036 | 234 |
2126489 | 2126489 | 2022-01-18 | Pulaski | Kentucky | 21199 | 12971 | 234 |
2123237 | 2123237 | 2022-01-17 | Pulaski | Kentucky | 21199 | 12779 | 230 |
2119985 | 2119985 | 2022-01-16 | Pulaski | Kentucky | 21199 | 12779 | 230 |
2116733 | 2116733 | 2022-01-15 | Pulaski | Kentucky | 21199 | 12779 | 230 |
2113482 | 2113482 | 2022-01-14 | Pulaski | Kentucky | 21199 | 12779 | 230 |
2110230 | 2110230 | 2022-01-13 | Pulaski | Kentucky | 21199 | 12779 | 230 |
2106979 | 2106979 | 2022-01-12 | Pulaski | Kentucky | 21199 | 12779 | 230 |
2103728 | 2103728 | 2022-01-11 | Pulaski | Kentucky | 21199 | 12779 | 230 |
2100477 | 2100477 | 2022-01-10 | Pulaski | Kentucky | 21199 | 12779 | 230 |
2097226 | 2097226 | 2022-01-09 | Pulaski | Kentucky | 21199 | 12779 | 230 |
2093974 | 2093974 | 2022-01-08 | Pulaski | Kentucky | 21199 | 12779 | 230 |
2090722 | 2090722 | 2022-01-07 | Pulaski | Kentucky | 21199 | 12779 | 230 |
2087471 | 2087471 | 2022-01-06 | Pulaski | Kentucky | 21199 | 12745 | 229 |
2084219 | 2084219 | 2022-01-05 | Pulaski | Kentucky | 21199 | 12704 | 229 |
2080967 | 2080967 | 2022-01-04 | Pulaski | Kentucky | 21199 | 12653 | 228 |
2077715 | 2077715 | 2022-01-03 | Pulaski | Kentucky | 21199 | 12653 | 228 |
2074464 | 2074464 | 2022-01-02 | Pulaski | Kentucky | 21199 | 12583 | 226 |
2071213 | 2071213 | 2022-01-01 | Pulaski | Kentucky | 21199 | 12583 | 226 |
2067962 | 2067962 | 2021-12-31 | Pulaski | Kentucky | 21199 | 12583 | 226 |
2064711 | 2064711 | 2021-12-30 | Pulaski | Kentucky | 21199 | 12583 | 226 |
2061461 | 2061461 | 2021-12-29 | Pulaski | Kentucky | 21199 | 12537 | 226 |
2058212 | 2058212 | 2021-12-28 | Pulaski | Kentucky | 21199 | 12537 | 226 |
2054963 | 2054963 | 2021-12-27 | Pulaski | Kentucky | 21199 | 12465 | 222 |
2051713 | 2051713 | 2021-12-26 | Pulaski | Kentucky | 21199 | 12465 | 222 |
2048463 | 2048463 | 2021-12-25 | Pulaski | Kentucky | 21199 | 12465 | 222 |
2045213 | 2045213 | 2021-12-24 | Pulaski | Kentucky | 21199 | 12465 | 222 |
2041964 | 2041964 | 2021-12-23 | Pulaski | Kentucky | 21199 | 12465 | 222 |
2038714 | 2038714 | 2021-12-22 | Pulaski | Kentucky | 21199 | 12451 | 222 |
2035464 | 2035464 | 2021-12-21 | Pulaski | Kentucky | 21199 | 12451 | 222 |
2032214 | 2032214 | 2021-12-20 | Pulaski | Kentucky | 21199 | 12410 | 220 |
2028963 | 2028963 | 2021-12-19 | Pulaski | Kentucky | 21199 | 12382 | 219 |
2025712 | 2025712 | 2021-12-18 | Pulaski | Kentucky | 21199 | 12382 | 219 |
2022461 | 2022461 | 2021-12-17 | Pulaski | Kentucky | 21199 | 12382 | 219 |
2019210 | 2019210 | 2021-12-16 | Pulaski | Kentucky | 21199 | 12311 | 219 |
2015960 | 2015960 | 2021-12-15 | Pulaski | Kentucky | 21199 | 12311 | 219 |
2012709 | 2012709 | 2021-12-14 | Pulaski | Kentucky | 21199 | 12269 | 219 |
2009458 | 2009458 | 2021-12-13 | Pulaski | Kentucky | 21199 | 12242 | 217 |
2006207 | 2006207 | 2021-12-12 | Pulaski | Kentucky | 21199 | 12242 | 217 |
2002956 | 2002956 | 2021-12-11 | Pulaski | Kentucky | 21199 | 12242 | 217 |
1999706 | 1999706 | 2021-12-10 | Pulaski | Kentucky | 21199 | 12242 | 217 |
1996455 | 1996455 | 2021-12-09 | Pulaski | Kentucky | 21199 | 12206 | 211 |
1993204 | 1993204 | 2021-12-08 | Pulaski | Kentucky | 21199 | 12176 | 211 |
1989953 | 1989953 | 2021-12-07 | Pulaski | Kentucky | 21199 | 12176 | 211 |
1986703 | 1986703 | 2021-12-06 | Pulaski | Kentucky | 21199 | 12150 | 207 |
1983453 | 1983453 | 2021-12-05 | Pulaski | Kentucky | 21199 | 12118 | 206 |
1980203 | 1980203 | 2021-12-04 | Pulaski | Kentucky | 21199 | 12118 | 206 |
1976953 | 1976953 | 2021-12-03 | Pulaski | Kentucky | 21199 | 12096 | 205 |
1973704 | 1973704 | 2021-12-02 | Pulaski | Kentucky | 21199 | 12067 | 205 |
1970454 | 1970454 | 2021-12-01 | Pulaski | Kentucky | 21199 | 12036 | 205 |
1967204 | 1967204 | 2021-11-30 | Pulaski | Kentucky | 21199 | 12003 | 204 |
1963952 | 1963952 | 2021-11-29 | Pulaski | Kentucky | 21199 | 12003 | 204 |
1960701 | 1960701 | 2021-11-28 | Pulaski | Kentucky | 21199 | 11948 | 202 |
1957450 | 1957450 | 2021-11-27 | Pulaski | Kentucky | 21199 | 11948 | 202 |
1954199 | 1954199 | 2021-11-26 | Pulaski | Kentucky | 21199 | 11948 | 202 |
1950948 | 1950948 | 2021-11-25 | Pulaski | Kentucky | 21199 | 11948 | 202 |
1947697 | 1947697 | 2021-11-24 | Pulaski | Kentucky | 21199 | 11928 | 198 |
1944446 | 1944446 | 2021-11-23 | Pulaski | Kentucky | 21199 | 11891 | 194 |
1941196 | 1941196 | 2021-11-22 | Pulaski | Kentucky | 21199 | 11854 | 194 |
1937946 | 1937946 | 2021-11-21 | Pulaski | Kentucky | 21199 | 11854 | 194 |
1934696 | 1934696 | 2021-11-20 | Pulaski | Kentucky | 21199 | 11854 | 194 |
1931445 | 1931445 | 2021-11-19 | Pulaski | Kentucky | 21199 | 11817 | 194 |
1928194 | 1928194 | 2021-11-18 | Pulaski | Kentucky | 21199 | 11817 | 194 |
1924944 | 1924944 | 2021-11-17 | Pulaski | Kentucky | 21199 | 11716 | 194 |
1921695 | 1921695 | 2021-11-16 | Pulaski | Kentucky | 21199 | 11679 | 194 |
1918445 | 1918445 | 2021-11-15 | Pulaski | Kentucky | 21199 | 11660 | 194 |
1915195 | 1915195 | 2021-11-14 | Pulaski | Kentucky | 21199 | 11660 | 194 |
1911945 | 1911945 | 2021-11-13 | Pulaski | Kentucky | 21199 | 11660 | 194 |
1908696 | 1908696 | 2021-11-12 | Pulaski | Kentucky | 21199 | 11611 | 194 |
1905447 | 1905447 | 2021-11-11 | Pulaski | Kentucky | 21199 | 11611 | 194 |
1902197 | 1902197 | 2021-11-10 | Pulaski | Kentucky | 21199 | 11590 | 193 |
1898947 | 1898947 | 2021-11-09 | Pulaski | Kentucky | 21199 | 11558 | 188 |
1895697 | 1895697 | 2021-11-08 | Pulaski | Kentucky | 21199 | 11545 | 186 |
1892447 | 1892447 | 2021-11-07 | Pulaski | Kentucky | 21199 | 11545 | 186 |
1889197 | 1889197 | 2021-11-06 | Pulaski | Kentucky | 21199 | 11545 | 186 |
1885947 | 1885947 | 2021-11-05 | Pulaski | Kentucky | 21199 | 11545 | 186 |
1882698 | 1882698 | 2021-11-04 | Pulaski | Kentucky | 21199 | 11515 | 186 |
1879449 | 1879449 | 2021-11-03 | Pulaski | Kentucky | 21199 | 11495 | 186 |
1876200 | 1876200 | 2021-11-02 | Pulaski | Kentucky | 21199 | 11476 | 186 |
1872951 | 1872951 | 2021-11-01 | Pulaski | Kentucky | 21199 | 11476 | 186 |
1869702 | 1869702 | 2021-10-31 | Pulaski | Kentucky | 21199 | 11450 | 186 |
1866453 | 1866453 | 2021-10-30 | Pulaski | Kentucky | 21199 | 11450 | 186 |
1863204 | 1863204 | 2021-10-29 | Pulaski | Kentucky | 21199 | 11416 | 185 |
1859955 | 1859955 | 2021-10-28 | Pulaski | Kentucky | 21199 | 11416 | 185 |
1856706 | 1856706 | 2021-10-27 | Pulaski | Kentucky | 21199 | 11377 | 184 |
1853457 | 1853457 | 2021-10-26 | Pulaski | Kentucky | 21199 | 11377 | 184 |
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);