ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 19065 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175024 | 2175024 | 2022-02-02 | Fayette | Iowa | 19065 | 3855 | 68 |
2171771 | 2171771 | 2022-02-01 | Fayette | Iowa | 19065 | 3755 | 67 |
2168518 | 2168518 | 2022-01-31 | Fayette | Iowa | 19065 | 3755 | 67 |
2165263 | 2165263 | 2022-01-30 | Fayette | Iowa | 19065 | 3755 | 67 |
2162008 | 2162008 | 2022-01-29 | Fayette | Iowa | 19065 | 3755 | 67 |
2158753 | 2158753 | 2022-01-28 | Fayette | Iowa | 19065 | 3755 | 67 |
2155499 | 2155499 | 2022-01-27 | Fayette | Iowa | 19065 | 3755 | 67 |
2152246 | 2152246 | 2022-01-26 | Fayette | Iowa | 19065 | 3755 | 67 |
2148994 | 2148994 | 2022-01-25 | Fayette | Iowa | 19065 | 3581 | 63 |
2145742 | 2145742 | 2022-01-24 | Fayette | Iowa | 19065 | 3581 | 63 |
2142487 | 2142487 | 2022-01-23 | Fayette | Iowa | 19065 | 3581 | 63 |
2139232 | 2139232 | 2022-01-22 | Fayette | Iowa | 19065 | 3581 | 63 |
2135976 | 2135976 | 2022-01-21 | Fayette | Iowa | 19065 | 3581 | 63 |
2132724 | 2132724 | 2022-01-20 | Fayette | Iowa | 19065 | 3581 | 63 |
2129471 | 2129471 | 2022-01-19 | Fayette | Iowa | 19065 | 3581 | 63 |
2126217 | 2126217 | 2022-01-18 | Fayette | Iowa | 19065 | 3417 | 62 |
2122965 | 2122965 | 2022-01-17 | Fayette | Iowa | 19065 | 3417 | 62 |
2119713 | 2119713 | 2022-01-16 | Fayette | Iowa | 19065 | 3417 | 62 |
2116461 | 2116461 | 2022-01-15 | Fayette | Iowa | 19065 | 3417 | 62 |
2113210 | 2113210 | 2022-01-14 | Fayette | Iowa | 19065 | 3417 | 62 |
2109958 | 2109958 | 2022-01-13 | Fayette | Iowa | 19065 | 3417 | 62 |
2106707 | 2106707 | 2022-01-12 | Fayette | Iowa | 19065 | 3417 | 62 |
2103456 | 2103456 | 2022-01-11 | Fayette | Iowa | 19065 | 3266 | 59 |
2100205 | 2100205 | 2022-01-10 | Fayette | Iowa | 19065 | 3266 | 59 |
2096954 | 2096954 | 2022-01-09 | Fayette | Iowa | 19065 | 3266 | 59 |
2093702 | 2093702 | 2022-01-08 | Fayette | Iowa | 19065 | 3266 | 59 |
2090450 | 2090450 | 2022-01-07 | Fayette | Iowa | 19065 | 3266 | 59 |
2087199 | 2087199 | 2022-01-06 | Fayette | Iowa | 19065 | 3266 | 59 |
2083947 | 2083947 | 2022-01-05 | Fayette | Iowa | 19065 | 3266 | 59 |
2080695 | 2080695 | 2022-01-04 | Fayette | Iowa | 19065 | 3152 | 57 |
2077443 | 2077443 | 2022-01-03 | Fayette | Iowa | 19065 | 3152 | 57 |
2074192 | 2074192 | 2022-01-02 | Fayette | Iowa | 19065 | 3152 | 57 |
2070941 | 2070941 | 2022-01-01 | Fayette | Iowa | 19065 | 3152 | 57 |
2067690 | 2067690 | 2021-12-31 | Fayette | Iowa | 19065 | 3152 | 57 |
2064439 | 2064439 | 2021-12-30 | Fayette | Iowa | 19065 | 3152 | 57 |
2061189 | 2061189 | 2021-12-29 | Fayette | Iowa | 19065 | 3152 | 57 |
2057940 | 2057940 | 2021-12-28 | Fayette | Iowa | 19065 | 3099 | 57 |
2054691 | 2054691 | 2021-12-27 | Fayette | Iowa | 19065 | 3099 | 57 |
2051441 | 2051441 | 2021-12-26 | Fayette | Iowa | 19065 | 3099 | 57 |
2048191 | 2048191 | 2021-12-25 | Fayette | Iowa | 19065 | 3099 | 57 |
2044941 | 2044941 | 2021-12-24 | Fayette | Iowa | 19065 | 3099 | 57 |
2041692 | 2041692 | 2021-12-23 | Fayette | Iowa | 19065 | 3099 | 57 |
2038442 | 2038442 | 2021-12-22 | Fayette | Iowa | 19065 | 3099 | 57 |
2035192 | 2035192 | 2021-12-21 | Fayette | Iowa | 19065 | 3051 | 57 |
2031942 | 2031942 | 2021-12-20 | Fayette | Iowa | 19065 | 3051 | 57 |
2028691 | 2028691 | 2021-12-19 | Fayette | Iowa | 19065 | 3051 | 57 |
2025440 | 2025440 | 2021-12-18 | Fayette | Iowa | 19065 | 3051 | 57 |
2022189 | 2022189 | 2021-12-17 | Fayette | Iowa | 19065 | 3051 | 57 |
2018938 | 2018938 | 2021-12-16 | Fayette | Iowa | 19065 | 3051 | 57 |
2015688 | 2015688 | 2021-12-15 | Fayette | Iowa | 19065 | 3051 | 57 |
2012437 | 2012437 | 2021-12-14 | Fayette | Iowa | 19065 | 2977 | 56 |
2009186 | 2009186 | 2021-12-13 | Fayette | Iowa | 19065 | 2977 | 56 |
2005935 | 2005935 | 2021-12-12 | Fayette | Iowa | 19065 | 2977 | 56 |
2002684 | 2002684 | 2021-12-11 | Fayette | Iowa | 19065 | 2977 | 56 |
1999434 | 1999434 | 2021-12-10 | Fayette | Iowa | 19065 | 2977 | 56 |
1996183 | 1996183 | 2021-12-09 | Fayette | Iowa | 19065 | 2977 | 56 |
1992932 | 1992932 | 2021-12-08 | Fayette | Iowa | 19065 | 2977 | 56 |
1989681 | 1989681 | 2021-12-07 | Fayette | Iowa | 19065 | 2914 | 56 |
1986431 | 1986431 | 2021-12-06 | Fayette | Iowa | 19065 | 2914 | 56 |
1983181 | 1983181 | 2021-12-05 | Fayette | Iowa | 19065 | 2914 | 56 |
1979931 | 1979931 | 2021-12-04 | Fayette | Iowa | 19065 | 2914 | 56 |
1976681 | 1976681 | 2021-12-03 | Fayette | Iowa | 19065 | 2914 | 56 |
1973432 | 1973432 | 2021-12-02 | Fayette | Iowa | 19065 | 2914 | 56 |
1970182 | 1970182 | 2021-12-01 | Fayette | Iowa | 19065 | 2914 | 56 |
1966932 | 1966932 | 2021-11-30 | Fayette | Iowa | 19065 | 2866 | 53 |
1963680 | 1963680 | 2021-11-29 | Fayette | Iowa | 19065 | 2866 | 53 |
1960429 | 1960429 | 2021-11-28 | Fayette | Iowa | 19065 | 2866 | 53 |
1957178 | 1957178 | 2021-11-27 | Fayette | Iowa | 19065 | 2866 | 53 |
1953927 | 1953927 | 2021-11-26 | Fayette | Iowa | 19065 | 2866 | 53 |
1950676 | 1950676 | 2021-11-25 | Fayette | Iowa | 19065 | 2866 | 53 |
1947425 | 1947425 | 2021-11-24 | Fayette | Iowa | 19065 | 2866 | 53 |
1944174 | 1944174 | 2021-11-23 | Fayette | Iowa | 19065 | 2807 | 53 |
1940924 | 1940924 | 2021-11-22 | Fayette | Iowa | 19065 | 2807 | 53 |
1937674 | 1937674 | 2021-11-21 | Fayette | Iowa | 19065 | 2807 | 53 |
1934424 | 1934424 | 2021-11-20 | Fayette | Iowa | 19065 | 2807 | 53 |
1931173 | 1931173 | 2021-11-19 | Fayette | Iowa | 19065 | 2807 | 53 |
1927922 | 1927922 | 2021-11-18 | Fayette | Iowa | 19065 | 2807 | 53 |
1924672 | 1924672 | 2021-11-17 | Fayette | Iowa | 19065 | 2807 | 53 |
1921423 | 1921423 | 2021-11-16 | Fayette | Iowa | 19065 | 2746 | 52 |
1918173 | 1918173 | 2021-11-15 | Fayette | Iowa | 19065 | 2746 | 52 |
1914923 | 1914923 | 2021-11-14 | Fayette | Iowa | 19065 | 2746 | 52 |
1911673 | 1911673 | 2021-11-13 | Fayette | Iowa | 19065 | 2746 | 52 |
1908424 | 1908424 | 2021-11-12 | Fayette | Iowa | 19065 | 2746 | 52 |
1905175 | 1905175 | 2021-11-11 | Fayette | Iowa | 19065 | 2746 | 52 |
1901925 | 1901925 | 2021-11-10 | Fayette | Iowa | 19065 | 2746 | 52 |
1898675 | 1898675 | 2021-11-09 | Fayette | Iowa | 19065 | 2695 | 52 |
1895425 | 1895425 | 2021-11-08 | Fayette | Iowa | 19065 | 2695 | 52 |
1892175 | 1892175 | 2021-11-07 | Fayette | Iowa | 19065 | 2695 | 52 |
1888925 | 1888925 | 2021-11-06 | Fayette | Iowa | 19065 | 2695 | 52 |
1885675 | 1885675 | 2021-11-05 | Fayette | Iowa | 19065 | 2695 | 52 |
1882426 | 1882426 | 2021-11-04 | Fayette | Iowa | 19065 | 2695 | 52 |
1879177 | 1879177 | 2021-11-03 | Fayette | Iowa | 19065 | 2695 | 52 |
1875928 | 1875928 | 2021-11-02 | Fayette | Iowa | 19065 | 2648 | 52 |
1872679 | 1872679 | 2021-11-01 | Fayette | Iowa | 19065 | 2648 | 52 |
1869430 | 1869430 | 2021-10-31 | Fayette | Iowa | 19065 | 2648 | 52 |
1866181 | 1866181 | 2021-10-30 | Fayette | Iowa | 19065 | 2648 | 52 |
1862932 | 1862932 | 2021-10-29 | Fayette | Iowa | 19065 | 2648 | 52 |
1859683 | 1859683 | 2021-10-28 | Fayette | Iowa | 19065 | 2648 | 52 |
1856434 | 1856434 | 2021-10-27 | Fayette | Iowa | 19065 | 2648 | 52 |
1853185 | 1853185 | 2021-10-26 | Fayette | Iowa | 19065 | 2606 | 49 |
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);