ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 12017 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174526 | 2174526 | 2022-02-02 | Citrus | Florida | 12017 | 26800 | 864 |
2171273 | 2171273 | 2022-02-01 | Citrus | Florida | 12017 | 26800 | 853 |
2168020 | 2168020 | 2022-01-31 | Citrus | Florida | 12017 | 26800 | 853 |
2164765 | 2164765 | 2022-01-30 | Citrus | Florida | 12017 | 26800 | 853 |
2161510 | 2161510 | 2022-01-29 | Citrus | Florida | 12017 | 26800 | 853 |
2158254 | 2158254 | 2022-01-28 | Citrus | Florida | 12017 | 26800 | 853 |
2155001 | 2155001 | 2022-01-27 | Citrus | Florida | 12017 | 25333 | 853 |
2151748 | 2151748 | 2022-01-26 | Citrus | Florida | 12017 | 25333 | 853 |
2148496 | 2148496 | 2022-01-25 | Citrus | Florida | 12017 | 25333 | 849 |
2145244 | 2145244 | 2022-01-24 | Citrus | Florida | 12017 | 25333 | 849 |
2141989 | 2141989 | 2022-01-23 | Citrus | Florida | 12017 | 25333 | 849 |
2138734 | 2138734 | 2022-01-22 | Citrus | Florida | 12017 | 25333 | 849 |
2135478 | 2135478 | 2022-01-21 | Citrus | Florida | 12017 | 25333 | 849 |
2132226 | 2132226 | 2022-01-20 | Citrus | Florida | 12017 | 23731 | 849 |
2128973 | 2128973 | 2022-01-19 | Citrus | Florida | 12017 | 23731 | 849 |
2125719 | 2125719 | 2022-01-18 | Citrus | Florida | 12017 | 23731 | 846 |
2122467 | 2122467 | 2022-01-17 | Citrus | Florida | 12017 | 23731 | 846 |
2119215 | 2119215 | 2022-01-16 | Citrus | Florida | 12017 | 23731 | 846 |
2115963 | 2115963 | 2022-01-15 | Citrus | Florida | 12017 | 23731 | 846 |
2112712 | 2112712 | 2022-01-14 | Citrus | Florida | 12017 | 23731 | 846 |
2109460 | 2109460 | 2022-01-13 | Citrus | Florida | 12017 | 22267 | 846 |
2106209 | 2106209 | 2022-01-12 | Citrus | Florida | 12017 | 22267 | 846 |
2102958 | 2102958 | 2022-01-11 | Citrus | Florida | 12017 | 22267 | 840 |
2099707 | 2099707 | 2022-01-10 | Citrus | Florida | 12017 | 22267 | 840 |
2096456 | 2096456 | 2022-01-09 | Citrus | Florida | 12017 | 22267 | 840 |
2093204 | 2093204 | 2022-01-08 | Citrus | Florida | 12017 | 22267 | 840 |
2089952 | 2089952 | 2022-01-07 | Citrus | Florida | 12017 | 22267 | 840 |
2086701 | 2086701 | 2022-01-06 | Citrus | Florida | 12017 | 21313 | 840 |
2083449 | 2083449 | 2022-01-05 | Citrus | Florida | 12017 | 21313 | 840 |
2080197 | 2080197 | 2022-01-04 | Citrus | Florida | 12017 | 21313 | 839 |
2076945 | 2076945 | 2022-01-03 | Citrus | Florida | 12017 | 21313 | 839 |
2073694 | 2073694 | 2022-01-02 | Citrus | Florida | 12017 | 21313 | 839 |
2070443 | 2070443 | 2022-01-01 | Citrus | Florida | 12017 | 21313 | 839 |
2067192 | 2067192 | 2021-12-31 | Citrus | Florida | 12017 | 21313 | 839 |
2063941 | 2063941 | 2021-12-30 | Citrus | Florida | 12017 | 20936 | 839 |
2060691 | 2060691 | 2021-12-29 | Citrus | Florida | 12017 | 20936 | 839 |
2057442 | 2057442 | 2021-12-28 | Citrus | Florida | 12017 | 20936 | 838 |
2054193 | 2054193 | 2021-12-27 | Citrus | Florida | 12017 | 20936 | 838 |
2050943 | 2050943 | 2021-12-26 | Citrus | Florida | 12017 | 20936 | 838 |
2047693 | 2047693 | 2021-12-25 | Citrus | Florida | 12017 | 20936 | 838 |
2044443 | 2044443 | 2021-12-24 | Citrus | Florida | 12017 | 20936 | 838 |
2041194 | 2041194 | 2021-12-23 | Citrus | Florida | 12017 | 20839 | 838 |
2037944 | 2037944 | 2021-12-22 | Citrus | Florida | 12017 | 20839 | 838 |
2034694 | 2034694 | 2021-12-21 | Citrus | Florida | 12017 | 20839 | 837 |
2031444 | 2031444 | 2021-12-20 | Citrus | Florida | 12017 | 20839 | 837 |
2028193 | 2028193 | 2021-12-19 | Citrus | Florida | 12017 | 20839 | 837 |
2024942 | 2024942 | 2021-12-18 | Citrus | Florida | 12017 | 20839 | 837 |
2021691 | 2021691 | 2021-12-17 | Citrus | Florida | 12017 | 20839 | 837 |
2018440 | 2018440 | 2021-12-16 | Citrus | Florida | 12017 | 20793 | 837 |
2015190 | 2015190 | 2021-12-15 | Citrus | Florida | 12017 | 20793 | 837 |
2011939 | 2011939 | 2021-12-14 | Citrus | Florida | 12017 | 20793 | 837 |
2008688 | 2008688 | 2021-12-13 | Citrus | Florida | 12017 | 20793 | 835 |
2005437 | 2005437 | 2021-12-12 | Citrus | Florida | 12017 | 20793 | 835 |
2002186 | 2002186 | 2021-12-11 | Citrus | Florida | 12017 | 20793 | 835 |
1998936 | 1998936 | 2021-12-10 | Citrus | Florida | 12017 | 20793 | 835 |
1995685 | 1995685 | 2021-12-09 | Citrus | Florida | 12017 | 20742 | 835 |
1992434 | 1992434 | 2021-12-08 | Citrus | Florida | 12017 | 20742 | 835 |
1989183 | 1989183 | 2021-12-07 | Citrus | Florida | 12017 | 20742 | 826 |
1985933 | 1985933 | 2021-12-06 | Citrus | Florida | 12017 | 20742 | 826 |
1982683 | 1982683 | 2021-12-05 | Citrus | Florida | 12017 | 20742 | 826 |
1979433 | 1979433 | 2021-12-04 | Citrus | Florida | 12017 | 20742 | 826 |
1976183 | 1976183 | 2021-12-03 | Citrus | Florida | 12017 | 20742 | 826 |
1972934 | 1972934 | 2021-12-02 | Citrus | Florida | 12017 | 20669 | 826 |
1969684 | 1969684 | 2021-12-01 | Citrus | Florida | 12017 | 20669 | 826 |
1966434 | 1966434 | 2021-11-30 | Citrus | Florida | 12017 | 20669 | 826 |
1963182 | 1963182 | 2021-11-29 | Citrus | Florida | 12017 | 20558 | 826 |
1959931 | 1959931 | 2021-11-28 | Citrus | Florida | 12017 | 20558 | 826 |
1956680 | 1956680 | 2021-11-27 | Citrus | Florida | 12017 | 20558 | 826 |
1953429 | 1953429 | 2021-11-26 | Citrus | Florida | 12017 | 20558 | 826 |
1950178 | 1950178 | 2021-11-25 | Citrus | Florida | 12017 | 20558 | 826 |
1946927 | 1946927 | 2021-11-24 | Citrus | Florida | 12017 | 20558 | 826 |
1943676 | 1943676 | 2021-11-23 | Citrus | Florida | 12017 | 20558 | 826 |
1940426 | 1940426 | 2021-11-22 | Citrus | Florida | 12017 | 20558 | 826 |
1937176 | 1937176 | 2021-11-21 | Citrus | Florida | 12017 | 20558 | 826 |
1933926 | 1933926 | 2021-11-20 | Citrus | Florida | 12017 | 20558 | 826 |
1930674 | 1930674 | 2021-11-19 | Citrus | Florida | 12017 | 20558 | 822 |
1927424 | 1927424 | 2021-11-18 | Citrus | Florida | 12017 | 20514 | 822 |
1924174 | 1924174 | 2021-11-17 | Citrus | Florida | 12017 | 20514 | 822 |
1920925 | 1920925 | 2021-11-16 | Citrus | Florida | 12017 | 20514 | 822 |
1917675 | 1917675 | 2021-11-15 | Citrus | Florida | 12017 | 20514 | 822 |
1914425 | 1914425 | 2021-11-14 | Citrus | Florida | 12017 | 20514 | 820 |
1911175 | 1911175 | 2021-11-13 | Citrus | Florida | 12017 | 20514 | 820 |
1907926 | 1907926 | 2021-11-12 | Citrus | Florida | 12017 | 20514 | 820 |
1904677 | 1904677 | 2021-11-11 | Citrus | Florida | 12017 | 20464 | 820 |
1901427 | 1901427 | 2021-11-10 | Citrus | Florida | 12017 | 20464 | 820 |
1898177 | 1898177 | 2021-11-09 | Citrus | Florida | 12017 | 20464 | 820 |
1894927 | 1894927 | 2021-11-08 | Citrus | Florida | 12017 | 20464 | 820 |
1891677 | 1891677 | 2021-11-07 | Citrus | Florida | 12017 | 20464 | 815 |
1888427 | 1888427 | 2021-11-06 | Citrus | Florida | 12017 | 20464 | 815 |
1885177 | 1885177 | 2021-11-05 | Citrus | Florida | 12017 | 20464 | 815 |
1881928 | 1881928 | 2021-11-04 | Citrus | Florida | 12017 | 20392 | 815 |
1878679 | 1878679 | 2021-11-03 | Citrus | Florida | 12017 | 20392 | 815 |
1875430 | 1875430 | 2021-11-02 | Citrus | Florida | 12017 | 20392 | 815 |
1872181 | 1872181 | 2021-11-01 | Citrus | Florida | 12017 | 20392 | 815 |
1868932 | 1868932 | 2021-10-31 | Citrus | Florida | 12017 | 20392 | 815 |
1865683 | 1865683 | 2021-10-30 | Citrus | Florida | 12017 | 20392 | 802 |
1862434 | 1862434 | 2021-10-29 | Citrus | Florida | 12017 | 20392 | 802 |
1859185 | 1859185 | 2021-10-28 | Citrus | Florida | 12017 | 20328 | 802 |
1855936 | 1855936 | 2021-10-27 | Citrus | Florida | 12017 | 20328 | 802 |
1852687 | 1852687 | 2021-10-26 | Citrus | Florida | 12017 | 20328 | 802 |
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);