ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Clay" and fips = 5021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174316 | 2174316 | 2022-02-02 | Clay | Arkansas | 5021 | 3858 | 78 |
2171063 | 2171063 | 2022-02-01 | Clay | Arkansas | 5021 | 3833 | 78 |
2167810 | 2167810 | 2022-01-31 | Clay | Arkansas | 5021 | 3810 | 78 |
2164555 | 2164555 | 2022-01-30 | Clay | Arkansas | 5021 | 3763 | 78 |
2161300 | 2161300 | 2022-01-29 | Clay | Arkansas | 5021 | 3763 | 78 |
2158044 | 2158044 | 2022-01-28 | Clay | Arkansas | 5021 | 3763 | 78 |
2154791 | 2154791 | 2022-01-27 | Clay | Arkansas | 5021 | 3743 | 78 |
2151538 | 2151538 | 2022-01-26 | Clay | Arkansas | 5021 | 3720 | 77 |
2148286 | 2148286 | 2022-01-25 | Clay | Arkansas | 5021 | 3705 | 77 |
2145034 | 2145034 | 2022-01-24 | Clay | Arkansas | 5021 | 3665 | 77 |
2141779 | 2141779 | 2022-01-23 | Clay | Arkansas | 5021 | 3652 | 77 |
2138524 | 2138524 | 2022-01-22 | Clay | Arkansas | 5021 | 3626 | 77 |
2135268 | 2135268 | 2022-01-21 | Clay | Arkansas | 5021 | 3577 | 77 |
2132016 | 2132016 | 2022-01-20 | Clay | Arkansas | 5021 | 3532 | 77 |
2128763 | 2128763 | 2022-01-19 | Clay | Arkansas | 5021 | 3503 | 77 |
2125509 | 2125509 | 2022-01-18 | Clay | Arkansas | 5021 | 3388 | 77 |
2122257 | 2122257 | 2022-01-17 | Clay | Arkansas | 5021 | 3377 | 77 |
2119005 | 2119005 | 2022-01-16 | Clay | Arkansas | 5021 | 3361 | 77 |
2115753 | 2115753 | 2022-01-15 | Clay | Arkansas | 5021 | 3320 | 77 |
2112502 | 2112502 | 2022-01-14 | Clay | Arkansas | 5021 | 3251 | 77 |
2109250 | 2109250 | 2022-01-13 | Clay | Arkansas | 5021 | 3214 | 77 |
2105999 | 2105999 | 2022-01-12 | Clay | Arkansas | 5021 | 3180 | 77 |
2102748 | 2102748 | 2022-01-11 | Clay | Arkansas | 5021 | 3155 | 77 |
2099497 | 2099497 | 2022-01-10 | Clay | Arkansas | 5021 | 3120 | 77 |
2096246 | 2096246 | 2022-01-09 | Clay | Arkansas | 5021 | 3077 | 77 |
2092994 | 2092994 | 2022-01-08 | Clay | Arkansas | 5021 | 3077 | 77 |
2089742 | 2089742 | 2022-01-07 | Clay | Arkansas | 5021 | 3057 | 77 |
2086491 | 2086491 | 2022-01-06 | Clay | Arkansas | 5021 | 3035 | 77 |
2083239 | 2083239 | 2022-01-05 | Clay | Arkansas | 5021 | 3009 | 77 |
2079987 | 2079987 | 2022-01-04 | Clay | Arkansas | 5021 | 2995 | 77 |
2076735 | 2076735 | 2022-01-03 | Clay | Arkansas | 5021 | 2980 | 77 |
2073484 | 2073484 | 2022-01-02 | Clay | Arkansas | 5021 | 2977 | 77 |
2070233 | 2070233 | 2022-01-01 | Clay | Arkansas | 5021 | 2975 | 77 |
2066982 | 2066982 | 2021-12-31 | Clay | Arkansas | 5021 | 2970 | 77 |
2063731 | 2063731 | 2021-12-30 | Clay | Arkansas | 5021 | 2963 | 77 |
2060481 | 2060481 | 2021-12-29 | Clay | Arkansas | 5021 | 2947 | 77 |
2057232 | 2057232 | 2021-12-28 | Clay | Arkansas | 5021 | 2941 | 77 |
2053983 | 2053983 | 2021-12-27 | Clay | Arkansas | 5021 | 2923 | 77 |
2050733 | 2050733 | 2021-12-26 | Clay | Arkansas | 5021 | 2921 | 77 |
2047483 | 2047483 | 2021-12-25 | Clay | Arkansas | 5021 | 2920 | 77 |
2044233 | 2044233 | 2021-12-24 | Clay | Arkansas | 5021 | 2919 | 77 |
2040984 | 2040984 | 2021-12-23 | Clay | Arkansas | 5021 | 2915 | 77 |
2037734 | 2037734 | 2021-12-22 | Clay | Arkansas | 5021 | 2905 | 77 |
2034484 | 2034484 | 2021-12-21 | Clay | Arkansas | 5021 | 2904 | 77 |
2031234 | 2031234 | 2021-12-20 | Clay | Arkansas | 5021 | 2900 | 77 |
2027983 | 2027983 | 2021-12-19 | Clay | Arkansas | 5021 | 2898 | 77 |
2024732 | 2024732 | 2021-12-18 | Clay | Arkansas | 5021 | 2894 | 77 |
2021481 | 2021481 | 2021-12-17 | Clay | Arkansas | 5021 | 2886 | 77 |
2018230 | 2018230 | 2021-12-16 | Clay | Arkansas | 5021 | 2883 | 77 |
2014980 | 2014980 | 2021-12-15 | Clay | Arkansas | 5021 | 2879 | 77 |
2011729 | 2011729 | 2021-12-14 | Clay | Arkansas | 5021 | 2874 | 77 |
2008478 | 2008478 | 2021-12-13 | Clay | Arkansas | 5021 | 2867 | 77 |
2005227 | 2005227 | 2021-12-12 | Clay | Arkansas | 5021 | 2867 | 77 |
2001976 | 2001976 | 2021-12-11 | Clay | Arkansas | 5021 | 2866 | 77 |
1998726 | 1998726 | 2021-12-10 | Clay | Arkansas | 5021 | 2865 | 77 |
1995475 | 1995475 | 2021-12-09 | Clay | Arkansas | 5021 | 2862 | 77 |
1992224 | 1992224 | 2021-12-08 | Clay | Arkansas | 5021 | 2852 | 77 |
1988973 | 1988973 | 2021-12-07 | Clay | Arkansas | 5021 | 2848 | 77 |
1985723 | 1985723 | 2021-12-06 | Clay | Arkansas | 5021 | 2832 | 76 |
1982473 | 1982473 | 2021-12-05 | Clay | Arkansas | 5021 | 2831 | 76 |
1979223 | 1979223 | 2021-12-04 | Clay | Arkansas | 5021 | 2831 | 75 |
1975973 | 1975973 | 2021-12-03 | Clay | Arkansas | 5021 | 2823 | 74 |
1972724 | 1972724 | 2021-12-02 | Clay | Arkansas | 5021 | 2820 | 74 |
1969474 | 1969474 | 2021-12-01 | Clay | Arkansas | 5021 | 2814 | 74 |
1966224 | 1966224 | 2021-11-30 | Clay | Arkansas | 5021 | 2809 | 74 |
1962972 | 1962972 | 2021-11-29 | Clay | Arkansas | 5021 | 2803 | 74 |
1959721 | 1959721 | 2021-11-28 | Clay | Arkansas | 5021 | 2802 | 74 |
1956470 | 1956470 | 2021-11-27 | Clay | Arkansas | 5021 | 2801 | 74 |
1953219 | 1953219 | 2021-11-26 | Clay | Arkansas | 5021 | 2799 | 74 |
1949968 | 1949968 | 2021-11-25 | Clay | Arkansas | 5021 | 2798 | 74 |
1946717 | 1946717 | 2021-11-24 | Clay | Arkansas | 5021 | 2793 | 74 |
1943466 | 1943466 | 2021-11-23 | Clay | Arkansas | 5021 | 2786 | 74 |
1940216 | 1940216 | 2021-11-22 | Clay | Arkansas | 5021 | 2780 | 74 |
1936966 | 1936966 | 2021-11-21 | Clay | Arkansas | 5021 | 2779 | 74 |
1933716 | 1933716 | 2021-11-20 | Clay | Arkansas | 5021 | 2777 | 74 |
1930464 | 1930464 | 2021-11-19 | Clay | Arkansas | 5021 | 2773 | 74 |
1927214 | 1927214 | 2021-11-18 | Clay | Arkansas | 5021 | 2764 | 74 |
1923964 | 1923964 | 2021-11-17 | Clay | Arkansas | 5021 | 2754 | 74 |
1920715 | 1920715 | 2021-11-16 | Clay | Arkansas | 5021 | 2753 | 74 |
1917465 | 1917465 | 2021-11-15 | Clay | Arkansas | 5021 | 2750 | 74 |
1914215 | 1914215 | 2021-11-14 | Clay | Arkansas | 5021 | 2748 | 74 |
1910965 | 1910965 | 2021-11-13 | Clay | Arkansas | 5021 | 2745 | 73 |
1907716 | 1907716 | 2021-11-12 | Clay | Arkansas | 5021 | 2746 | 73 |
1904467 | 1904467 | 2021-11-11 | Clay | Arkansas | 5021 | 2741 | 73 |
1901217 | 1901217 | 2021-11-10 | Clay | Arkansas | 5021 | 2737 | 73 |
1897967 | 1897967 | 2021-11-09 | Clay | Arkansas | 5021 | 2732 | 73 |
1894717 | 1894717 | 2021-11-08 | Clay | Arkansas | 5021 | 2727 | 73 |
1891467 | 1891467 | 2021-11-07 | Clay | Arkansas | 5021 | 2727 | 73 |
1888217 | 1888217 | 2021-11-06 | Clay | Arkansas | 5021 | 2727 | 73 |
1884967 | 1884967 | 2021-11-05 | Clay | Arkansas | 5021 | 2718 | 72 |
1881718 | 1881718 | 2021-11-04 | Clay | Arkansas | 5021 | 2714 | 72 |
1878469 | 1878469 | 2021-11-03 | Clay | Arkansas | 5021 | 2714 | 71 |
1875220 | 1875220 | 2021-11-02 | Clay | Arkansas | 5021 | 2712 | 71 |
1871971 | 1871971 | 2021-11-01 | Clay | Arkansas | 5021 | 2708 | 70 |
1868722 | 1868722 | 2021-10-31 | Clay | Arkansas | 5021 | 2708 | 70 |
1865473 | 1865473 | 2021-10-30 | Clay | Arkansas | 5021 | 2708 | 70 |
1862224 | 1862224 | 2021-10-29 | Clay | Arkansas | 5021 | 2708 | 70 |
1858975 | 1858975 | 2021-10-28 | Clay | Arkansas | 5021 | 2708 | 70 |
1855726 | 1855726 | 2021-10-27 | Clay | Arkansas | 5021 | 2708 | 70 |
1852477 | 1852477 | 2021-10-26 | Clay | Arkansas | 5021 | 2708 | 70 |
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);