ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Fayette" and fips = 21067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175230 | 2175230 | 2022-02-02 | Fayette | Kentucky | 21067 | 86518 | 512 |
2171977 | 2171977 | 2022-02-01 | Fayette | Kentucky | 21067 | 86113 | 511 |
2168724 | 2168724 | 2022-01-31 | Fayette | Kentucky | 21067 | 85597 | 511 |
2165469 | 2165469 | 2022-01-30 | Fayette | Kentucky | 21067 | 84273 | 504 |
2162214 | 2162214 | 2022-01-29 | Fayette | Kentucky | 21067 | 84273 | 504 |
2158959 | 2158959 | 2022-01-28 | Fayette | Kentucky | 21067 | 84273 | 504 |
2155705 | 2155705 | 2022-01-27 | Fayette | Kentucky | 21067 | 83175 | 502 |
2152452 | 2152452 | 2022-01-26 | Fayette | Kentucky | 21067 | 82398 | 502 |
2149200 | 2149200 | 2022-01-25 | Fayette | Kentucky | 21067 | 81492 | 502 |
2145948 | 2145948 | 2022-01-24 | Fayette | Kentucky | 21067 | 80713 | 502 |
2142693 | 2142693 | 2022-01-23 | Fayette | Kentucky | 21067 | 78233 | 496 |
2139438 | 2139438 | 2022-01-22 | Fayette | Kentucky | 21067 | 78233 | 496 |
2136182 | 2136182 | 2022-01-21 | Fayette | Kentucky | 21067 | 78233 | 496 |
2132930 | 2132930 | 2022-01-20 | Fayette | Kentucky | 21067 | 76833 | 495 |
2129677 | 2129677 | 2022-01-19 | Fayette | Kentucky | 21067 | 75983 | 492 |
2126423 | 2126423 | 2022-01-18 | Fayette | Kentucky | 21067 | 75052 | 492 |
2123171 | 2123171 | 2022-01-17 | Fayette | Kentucky | 21067 | 70895 | 489 |
2119919 | 2119919 | 2022-01-16 | Fayette | Kentucky | 21067 | 70895 | 489 |
2116667 | 2116667 | 2022-01-15 | Fayette | Kentucky | 21067 | 70895 | 489 |
2113416 | 2113416 | 2022-01-14 | Fayette | Kentucky | 21067 | 70895 | 489 |
2110164 | 2110164 | 2022-01-13 | Fayette | Kentucky | 21067 | 69645 | 489 |
2106913 | 2106913 | 2022-01-12 | Fayette | Kentucky | 21067 | 68621 | 489 |
2103662 | 2103662 | 2022-01-11 | Fayette | Kentucky | 21067 | 67905 | 489 |
2100411 | 2100411 | 2022-01-10 | Fayette | Kentucky | 21067 | 66909 | 489 |
2097160 | 2097160 | 2022-01-09 | Fayette | Kentucky | 21067 | 65170 | 485 |
2093908 | 2093908 | 2022-01-08 | Fayette | Kentucky | 21067 | 65170 | 485 |
2090656 | 2090656 | 2022-01-07 | Fayette | Kentucky | 21067 | 65170 | 485 |
2087405 | 2087405 | 2022-01-06 | Fayette | Kentucky | 21067 | 63769 | 482 |
2084153 | 2084153 | 2022-01-05 | Fayette | Kentucky | 21067 | 62703 | 481 |
2080901 | 2080901 | 2022-01-04 | Fayette | Kentucky | 21067 | 61659 | 481 |
2077649 | 2077649 | 2022-01-03 | Fayette | Kentucky | 21067 | 60990 | 480 |
2074398 | 2074398 | 2022-01-02 | Fayette | Kentucky | 21067 | 58442 | 474 |
2071147 | 2071147 | 2022-01-01 | Fayette | Kentucky | 21067 | 58442 | 474 |
2067896 | 2067896 | 2021-12-31 | Fayette | Kentucky | 21067 | 58442 | 474 |
2064645 | 2064645 | 2021-12-30 | Fayette | Kentucky | 21067 | 58442 | 474 |
2061395 | 2061395 | 2021-12-29 | Fayette | Kentucky | 21067 | 58442 | 474 |
2058146 | 2058146 | 2021-12-28 | Fayette | Kentucky | 21067 | 57940 | 473 |
2054897 | 2054897 | 2021-12-27 | Fayette | Kentucky | 21067 | 57545 | 473 |
2051647 | 2051647 | 2021-12-26 | Fayette | Kentucky | 21067 | 56590 | 468 |
2048397 | 2048397 | 2021-12-25 | Fayette | Kentucky | 21067 | 56590 | 468 |
2045147 | 2045147 | 2021-12-24 | Fayette | Kentucky | 21067 | 56590 | 468 |
2041898 | 2041898 | 2021-12-23 | Fayette | Kentucky | 21067 | 56590 | 468 |
2038648 | 2038648 | 2021-12-22 | Fayette | Kentucky | 21067 | 56590 | 468 |
2035398 | 2035398 | 2021-12-21 | Fayette | Kentucky | 21067 | 56340 | 467 |
2032148 | 2032148 | 2021-12-20 | Fayette | Kentucky | 21067 | 56175 | 467 |
2028897 | 2028897 | 2021-12-19 | Fayette | Kentucky | 21067 | 55864 | 464 |
2025646 | 2025646 | 2021-12-18 | Fayette | Kentucky | 21067 | 55864 | 464 |
2022395 | 2022395 | 2021-12-17 | Fayette | Kentucky | 21067 | 55864 | 464 |
2019144 | 2019144 | 2021-12-16 | Fayette | Kentucky | 21067 | 55699 | 463 |
2015894 | 2015894 | 2021-12-15 | Fayette | Kentucky | 21067 | 55586 | 462 |
2012643 | 2012643 | 2021-12-14 | Fayette | Kentucky | 21067 | 55446 | 462 |
2009392 | 2009392 | 2021-12-13 | Fayette | Kentucky | 21067 | 55291 | 462 |
2006141 | 2006141 | 2021-12-12 | Fayette | Kentucky | 21067 | 55040 | 458 |
2002890 | 2002890 | 2021-12-11 | Fayette | Kentucky | 21067 | 55040 | 458 |
1999640 | 1999640 | 2021-12-10 | Fayette | Kentucky | 21067 | 55040 | 458 |
1996389 | 1996389 | 2021-12-09 | Fayette | Kentucky | 21067 | 54921 | 456 |
1993138 | 1993138 | 2021-12-08 | Fayette | Kentucky | 21067 | 54765 | 453 |
1989887 | 1989887 | 2021-12-07 | Fayette | Kentucky | 21067 | 54628 | 453 |
1986637 | 1986637 | 2021-12-06 | Fayette | Kentucky | 21067 | 54421 | 451 |
1983387 | 1983387 | 2021-12-05 | Fayette | Kentucky | 21067 | 54148 | 448 |
1980137 | 1980137 | 2021-12-04 | Fayette | Kentucky | 21067 | 54148 | 448 |
1976887 | 1976887 | 2021-12-03 | Fayette | Kentucky | 21067 | 54148 | 448 |
1973638 | 1973638 | 2021-12-02 | Fayette | Kentucky | 21067 | 54029 | 448 |
1970388 | 1970388 | 2021-12-01 | Fayette | Kentucky | 21067 | 53906 | 446 |
1967138 | 1967138 | 2021-11-30 | Fayette | Kentucky | 21067 | 53749 | 446 |
1963886 | 1963886 | 2021-11-29 | Fayette | Kentucky | 21067 | 53623 | 446 |
1960635 | 1960635 | 2021-11-28 | Fayette | Kentucky | 21067 | 53335 | 442 |
1957384 | 1957384 | 2021-11-27 | Fayette | Kentucky | 21067 | 53335 | 442 |
1954133 | 1954133 | 2021-11-26 | Fayette | Kentucky | 21067 | 53335 | 442 |
1950882 | 1950882 | 2021-11-25 | Fayette | Kentucky | 21067 | 53335 | 442 |
1947631 | 1947631 | 2021-11-24 | Fayette | Kentucky | 21067 | 53335 | 442 |
1944380 | 1944380 | 2021-11-23 | Fayette | Kentucky | 21067 | 53254 | 440 |
1941130 | 1941130 | 2021-11-22 | Fayette | Kentucky | 21067 | 53134 | 439 |
1937880 | 1937880 | 2021-11-21 | Fayette | Kentucky | 21067 | 52945 | 437 |
1934630 | 1934630 | 2021-11-20 | Fayette | Kentucky | 21067 | 52945 | 437 |
1931379 | 1931379 | 2021-11-19 | Fayette | Kentucky | 21067 | 52945 | 437 |
1928128 | 1928128 | 2021-11-18 | Fayette | Kentucky | 21067 | 53002 | 430 |
1924878 | 1924878 | 2021-11-17 | Fayette | Kentucky | 21067 | 52935 | 425 |
1921629 | 1921629 | 2021-11-16 | Fayette | Kentucky | 21067 | 52870 | 422 |
1918379 | 1918379 | 2021-11-15 | Fayette | Kentucky | 21067 | 52785 | 420 |
1915129 | 1915129 | 2021-11-14 | Fayette | Kentucky | 21067 | 52645 | 417 |
1911879 | 1911879 | 2021-11-13 | Fayette | Kentucky | 21067 | 52645 | 417 |
1908630 | 1908630 | 2021-11-12 | Fayette | Kentucky | 21067 | 52645 | 417 |
1905381 | 1905381 | 2021-11-11 | Fayette | Kentucky | 21067 | 52490 | 413 |
1902131 | 1902131 | 2021-11-10 | Fayette | Kentucky | 21067 | 52490 | 413 |
1898881 | 1898881 | 2021-11-09 | Fayette | Kentucky | 21067 | 52415 | 412 |
1895631 | 1895631 | 2021-11-08 | Fayette | Kentucky | 21067 | 52288 | 412 |
1892381 | 1892381 | 2021-11-07 | Fayette | Kentucky | 21067 | 52201 | 411 |
1889131 | 1889131 | 2021-11-06 | Fayette | Kentucky | 21067 | 52201 | 411 |
1885881 | 1885881 | 2021-11-05 | Fayette | Kentucky | 21067 | 52201 | 411 |
1882632 | 1882632 | 2021-11-04 | Fayette | Kentucky | 21067 | 52137 | 409 |
1879383 | 1879383 | 2021-11-03 | Fayette | Kentucky | 21067 | 52093 | 409 |
1876134 | 1876134 | 2021-11-02 | Fayette | Kentucky | 21067 | 52011 | 409 |
1872885 | 1872885 | 2021-11-01 | Fayette | Kentucky | 21067 | 51940 | 408 |
1869636 | 1869636 | 2021-10-31 | Fayette | Kentucky | 21067 | 51823 | 405 |
1866387 | 1866387 | 2021-10-30 | Fayette | Kentucky | 21067 | 51823 | 405 |
1863138 | 1863138 | 2021-10-29 | Fayette | Kentucky | 21067 | 51823 | 405 |
1859889 | 1859889 | 2021-10-28 | Fayette | Kentucky | 21067 | 51742 | 403 |
1856640 | 1856640 | 2021-10-27 | Fayette | Kentucky | 21067 | 51663 | 403 |
1853391 | 1853391 | 2021-10-26 | Fayette | Kentucky | 21067 | 51581 | 399 |
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);