ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Washington" and fips = 21229 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175311 | 2175311 | 2022-02-02 | Washington | Kentucky | 21229 | 3534 | 54 |
2172058 | 2172058 | 2022-02-01 | Washington | Kentucky | 21229 | 3492 | 54 |
2168805 | 2168805 | 2022-01-31 | Washington | Kentucky | 21229 | 3465 | 54 |
2165550 | 2165550 | 2022-01-30 | Washington | Kentucky | 21229 | 3396 | 54 |
2162295 | 2162295 | 2022-01-29 | Washington | Kentucky | 21229 | 3396 | 54 |
2159040 | 2159040 | 2022-01-28 | Washington | Kentucky | 21229 | 3396 | 54 |
2155786 | 2155786 | 2022-01-27 | Washington | Kentucky | 21229 | 3334 | 54 |
2152533 | 2152533 | 2022-01-26 | Washington | Kentucky | 21229 | 3295 | 54 |
2149281 | 2149281 | 2022-01-25 | Washington | Kentucky | 21229 | 3253 | 54 |
2146029 | 2146029 | 2022-01-24 | Washington | Kentucky | 21229 | 3213 | 54 |
2142774 | 2142774 | 2022-01-23 | Washington | Kentucky | 21229 | 3151 | 53 |
2139519 | 2139519 | 2022-01-22 | Washington | Kentucky | 21229 | 3151 | 53 |
2136263 | 2136263 | 2022-01-21 | Washington | Kentucky | 21229 | 3151 | 53 |
2133011 | 2133011 | 2022-01-20 | Washington | Kentucky | 21229 | 3111 | 53 |
2129758 | 2129758 | 2022-01-19 | Washington | Kentucky | 21229 | 3087 | 53 |
2126504 | 2126504 | 2022-01-18 | Washington | Kentucky | 21229 | 3059 | 53 |
2123252 | 2123252 | 2022-01-17 | Washington | Kentucky | 21229 | 2980 | 53 |
2120000 | 2120000 | 2022-01-16 | Washington | Kentucky | 21229 | 2980 | 53 |
2116748 | 2116748 | 2022-01-15 | Washington | Kentucky | 21229 | 2980 | 53 |
2113497 | 2113497 | 2022-01-14 | Washington | Kentucky | 21229 | 2980 | 53 |
2110245 | 2110245 | 2022-01-13 | Washington | Kentucky | 21229 | 2952 | 53 |
2106994 | 2106994 | 2022-01-12 | Washington | Kentucky | 21229 | 2924 | 53 |
2103743 | 2103743 | 2022-01-11 | Washington | Kentucky | 21229 | 2911 | 53 |
2100492 | 2100492 | 2022-01-10 | Washington | Kentucky | 21229 | 2895 | 53 |
2097241 | 2097241 | 2022-01-09 | Washington | Kentucky | 21229 | 2845 | 52 |
2093989 | 2093989 | 2022-01-08 | Washington | Kentucky | 21229 | 2845 | 52 |
2090737 | 2090737 | 2022-01-07 | Washington | Kentucky | 21229 | 2845 | 52 |
2087486 | 2087486 | 2022-01-06 | Washington | Kentucky | 21229 | 2823 | 52 |
2084234 | 2084234 | 2022-01-05 | Washington | Kentucky | 21229 | 2805 | 52 |
2080982 | 2080982 | 2022-01-04 | Washington | Kentucky | 21229 | 2770 | 52 |
2077730 | 2077730 | 2022-01-03 | Washington | Kentucky | 21229 | 2745 | 52 |
2074479 | 2074479 | 2022-01-02 | Washington | Kentucky | 21229 | 2709 | 51 |
2071228 | 2071228 | 2022-01-01 | Washington | Kentucky | 21229 | 2709 | 51 |
2067977 | 2067977 | 2021-12-31 | Washington | Kentucky | 21229 | 2709 | 51 |
2064726 | 2064726 | 2021-12-30 | Washington | Kentucky | 21229 | 2709 | 51 |
2061476 | 2061476 | 2021-12-29 | Washington | Kentucky | 21229 | 2709 | 51 |
2058227 | 2058227 | 2021-12-28 | Washington | Kentucky | 21229 | 2692 | 51 |
2054978 | 2054978 | 2021-12-27 | Washington | Kentucky | 21229 | 2672 | 51 |
2051728 | 2051728 | 2021-12-26 | Washington | Kentucky | 21229 | 2653 | 51 |
2048478 | 2048478 | 2021-12-25 | Washington | Kentucky | 21229 | 2653 | 51 |
2045228 | 2045228 | 2021-12-24 | Washington | Kentucky | 21229 | 2653 | 51 |
2041979 | 2041979 | 2021-12-23 | Washington | Kentucky | 21229 | 2653 | 51 |
2038729 | 2038729 | 2021-12-22 | Washington | Kentucky | 21229 | 2653 | 51 |
2035479 | 2035479 | 2021-12-21 | Washington | Kentucky | 21229 | 2647 | 51 |
2032229 | 2032229 | 2021-12-20 | Washington | Kentucky | 21229 | 2637 | 51 |
2028978 | 2028978 | 2021-12-19 | Washington | Kentucky | 21229 | 2623 | 51 |
2025727 | 2025727 | 2021-12-18 | Washington | Kentucky | 21229 | 2623 | 51 |
2022476 | 2022476 | 2021-12-17 | Washington | Kentucky | 21229 | 2623 | 51 |
2019225 | 2019225 | 2021-12-16 | Washington | Kentucky | 21229 | 2616 | 51 |
2015975 | 2015975 | 2021-12-15 | Washington | Kentucky | 21229 | 2599 | 51 |
2012724 | 2012724 | 2021-12-14 | Washington | Kentucky | 21229 | 2589 | 50 |
2009473 | 2009473 | 2021-12-13 | Washington | Kentucky | 21229 | 2586 | 50 |
2006222 | 2006222 | 2021-12-12 | Washington | Kentucky | 21229 | 2576 | 49 |
2002971 | 2002971 | 2021-12-11 | Washington | Kentucky | 21229 | 2576 | 49 |
1999721 | 1999721 | 2021-12-10 | Washington | Kentucky | 21229 | 2576 | 49 |
1996470 | 1996470 | 2021-12-09 | Washington | Kentucky | 21229 | 2564 | 49 |
1993219 | 1993219 | 2021-12-08 | Washington | Kentucky | 21229 | 2549 | 49 |
1989968 | 1989968 | 2021-12-07 | Washington | Kentucky | 21229 | 2534 | 49 |
1986718 | 1986718 | 2021-12-06 | Washington | Kentucky | 21229 | 2531 | 48 |
1983468 | 1983468 | 2021-12-05 | Washington | Kentucky | 21229 | 2517 | 48 |
1980218 | 1980218 | 2021-12-04 | Washington | Kentucky | 21229 | 2517 | 48 |
1976968 | 1976968 | 2021-12-03 | Washington | Kentucky | 21229 | 2517 | 48 |
1973719 | 1973719 | 2021-12-02 | Washington | Kentucky | 21229 | 2511 | 48 |
1970469 | 1970469 | 2021-12-01 | Washington | Kentucky | 21229 | 2505 | 48 |
1967219 | 1967219 | 2021-11-30 | Washington | Kentucky | 21229 | 2492 | 48 |
1963967 | 1963967 | 2021-11-29 | Washington | Kentucky | 21229 | 2486 | 48 |
1960716 | 1960716 | 2021-11-28 | Washington | Kentucky | 21229 | 2456 | 48 |
1957465 | 1957465 | 2021-11-27 | Washington | Kentucky | 21229 | 2456 | 48 |
1954214 | 1954214 | 2021-11-26 | Washington | Kentucky | 21229 | 2456 | 48 |
1950963 | 1950963 | 2021-11-25 | Washington | Kentucky | 21229 | 2456 | 48 |
1947712 | 1947712 | 2021-11-24 | Washington | Kentucky | 21229 | 2456 | 48 |
1944461 | 1944461 | 2021-11-23 | Washington | Kentucky | 21229 | 2449 | 48 |
1941211 | 1941211 | 2021-11-22 | Washington | Kentucky | 21229 | 2438 | 48 |
1937961 | 1937961 | 2021-11-21 | Washington | Kentucky | 21229 | 2425 | 48 |
1934711 | 1934711 | 2021-11-20 | Washington | Kentucky | 21229 | 2425 | 48 |
1931460 | 1931460 | 2021-11-19 | Washington | Kentucky | 21229 | 2425 | 48 |
1928209 | 1928209 | 2021-11-18 | Washington | Kentucky | 21229 | 2414 | 47 |
1924959 | 1924959 | 2021-11-17 | Washington | Kentucky | 21229 | 2411 | 47 |
1921710 | 1921710 | 2021-11-16 | Washington | Kentucky | 21229 | 2395 | 47 |
1918460 | 1918460 | 2021-11-15 | Washington | Kentucky | 21229 | 2389 | 47 |
1915210 | 1915210 | 2021-11-14 | Washington | Kentucky | 21229 | 2384 | 47 |
1911960 | 1911960 | 2021-11-13 | Washington | Kentucky | 21229 | 2384 | 47 |
1908711 | 1908711 | 2021-11-12 | Washington | Kentucky | 21229 | 2384 | 47 |
1905462 | 1905462 | 2021-11-11 | Washington | Kentucky | 21229 | 2377 | 47 |
1902212 | 1902212 | 2021-11-10 | Washington | Kentucky | 21229 | 2377 | 47 |
1898962 | 1898962 | 2021-11-09 | Washington | Kentucky | 21229 | 2370 | 47 |
1895712 | 1895712 | 2021-11-08 | Washington | Kentucky | 21229 | 2355 | 47 |
1892462 | 1892462 | 2021-11-07 | Washington | Kentucky | 21229 | 2349 | 47 |
1889212 | 1889212 | 2021-11-06 | Washington | Kentucky | 21229 | 2349 | 47 |
1885962 | 1885962 | 2021-11-05 | Washington | Kentucky | 21229 | 2349 | 47 |
1882713 | 1882713 | 2021-11-04 | Washington | Kentucky | 21229 | 2344 | 46 |
1879464 | 1879464 | 2021-11-03 | Washington | Kentucky | 21229 | 2342 | 46 |
1876215 | 1876215 | 2021-11-02 | Washington | Kentucky | 21229 | 2339 | 46 |
1872966 | 1872966 | 2021-11-01 | Washington | Kentucky | 21229 | 2332 | 46 |
1869717 | 1869717 | 2021-10-31 | Washington | Kentucky | 21229 | 2332 | 46 |
1866468 | 1866468 | 2021-10-30 | Washington | Kentucky | 21229 | 2332 | 46 |
1863219 | 1863219 | 2021-10-29 | Washington | Kentucky | 21229 | 2332 | 46 |
1859970 | 1859970 | 2021-10-28 | Washington | Kentucky | 21229 | 2328 | 46 |
1856721 | 1856721 | 2021-10-27 | Washington | Kentucky | 21229 | 2326 | 46 |
1853472 | 1853472 | 2021-10-26 | Washington | Kentucky | 21229 | 2322 | 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);