ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 12117 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174574 | 2174574 | 2022-02-02 | Seminole | Florida | 12117 | 96401 | 935 |
2171321 | 2171321 | 2022-02-01 | Seminole | Florida | 12117 | 96401 | 922 |
2168068 | 2168068 | 2022-01-31 | Seminole | Florida | 12117 | 96401 | 922 |
2164813 | 2164813 | 2022-01-30 | Seminole | Florida | 12117 | 96401 | 922 |
2161558 | 2161558 | 2022-01-29 | Seminole | Florida | 12117 | 96401 | 922 |
2158302 | 2158302 | 2022-01-28 | Seminole | Florida | 12117 | 96401 | 922 |
2155049 | 2155049 | 2022-01-27 | Seminole | Florida | 12117 | 92150 | 922 |
2151796 | 2151796 | 2022-01-26 | Seminole | Florida | 12117 | 92150 | 922 |
2148544 | 2148544 | 2022-01-25 | Seminole | Florida | 12117 | 92150 | 914 |
2145292 | 2145292 | 2022-01-24 | Seminole | Florida | 12117 | 92150 | 914 |
2142037 | 2142037 | 2022-01-23 | Seminole | Florida | 12117 | 92150 | 914 |
2138782 | 2138782 | 2022-01-22 | Seminole | Florida | 12117 | 92150 | 914 |
2135526 | 2135526 | 2022-01-21 | Seminole | Florida | 12117 | 92150 | 914 |
2132274 | 2132274 | 2022-01-20 | Seminole | Florida | 12117 | 86316 | 914 |
2129021 | 2129021 | 2022-01-19 | Seminole | Florida | 12117 | 86316 | 914 |
2125767 | 2125767 | 2022-01-18 | Seminole | Florida | 12117 | 86316 | 904 |
2122515 | 2122515 | 2022-01-17 | Seminole | Florida | 12117 | 86316 | 904 |
2119263 | 2119263 | 2022-01-16 | Seminole | Florida | 12117 | 86316 | 904 |
2116011 | 2116011 | 2022-01-15 | Seminole | Florida | 12117 | 86316 | 904 |
2112760 | 2112760 | 2022-01-14 | Seminole | Florida | 12117 | 86316 | 904 |
2109508 | 2109508 | 2022-01-13 | Seminole | Florida | 12117 | 78133 | 904 |
2106257 | 2106257 | 2022-01-12 | Seminole | Florida | 12117 | 78133 | 904 |
2103006 | 2103006 | 2022-01-11 | Seminole | Florida | 12117 | 78133 | 904 |
2099755 | 2099755 | 2022-01-10 | Seminole | Florida | 12117 | 78133 | 904 |
2096504 | 2096504 | 2022-01-09 | Seminole | Florida | 12117 | 78133 | 904 |
2093252 | 2093252 | 2022-01-08 | Seminole | Florida | 12117 | 78133 | 904 |
2090000 | 2090000 | 2022-01-07 | Seminole | Florida | 12117 | 78133 | 904 |
2086749 | 2086749 | 2022-01-06 | Seminole | Florida | 12117 | 71009 | 904 |
2083497 | 2083497 | 2022-01-05 | Seminole | Florida | 12117 | 71009 | 904 |
2080245 | 2080245 | 2022-01-04 | Seminole | Florida | 12117 | 71009 | 900 |
2076993 | 2076993 | 2022-01-03 | Seminole | Florida | 12117 | 71009 | 900 |
2073742 | 2073742 | 2022-01-02 | Seminole | Florida | 12117 | 71009 | 900 |
2070491 | 2070491 | 2022-01-01 | Seminole | Florida | 12117 | 71009 | 900 |
2067240 | 2067240 | 2021-12-31 | Seminole | Florida | 12117 | 71009 | 900 |
2063989 | 2063989 | 2021-12-30 | Seminole | Florida | 12117 | 65665 | 900 |
2060739 | 2060739 | 2021-12-29 | Seminole | Florida | 12117 | 65665 | 900 |
2057490 | 2057490 | 2021-12-28 | Seminole | Florida | 12117 | 65665 | 900 |
2054241 | 2054241 | 2021-12-27 | Seminole | Florida | 12117 | 65665 | 900 |
2050991 | 2050991 | 2021-12-26 | Seminole | Florida | 12117 | 65665 | 900 |
2047741 | 2047741 | 2021-12-25 | Seminole | Florida | 12117 | 65665 | 900 |
2044491 | 2044491 | 2021-12-24 | Seminole | Florida | 12117 | 65665 | 900 |
2041242 | 2041242 | 2021-12-23 | Seminole | Florida | 12117 | 64072 | 900 |
2037992 | 2037992 | 2021-12-22 | Seminole | Florida | 12117 | 64072 | 900 |
2034742 | 2034742 | 2021-12-21 | Seminole | Florida | 12117 | 64072 | 896 |
2031492 | 2031492 | 2021-12-20 | Seminole | Florida | 12117 | 64072 | 896 |
2028241 | 2028241 | 2021-12-19 | Seminole | Florida | 12117 | 64072 | 896 |
2024990 | 2024990 | 2021-12-18 | Seminole | Florida | 12117 | 64072 | 896 |
2021739 | 2021739 | 2021-12-17 | Seminole | Florida | 12117 | 64072 | 896 |
2018488 | 2018488 | 2021-12-16 | Seminole | Florida | 12117 | 63663 | 896 |
2015238 | 2015238 | 2021-12-15 | Seminole | Florida | 12117 | 63663 | 896 |
2011987 | 2011987 | 2021-12-14 | Seminole | Florida | 12117 | 63663 | 896 |
2008736 | 2008736 | 2021-12-13 | Seminole | Florida | 12117 | 63663 | 891 |
2005485 | 2005485 | 2021-12-12 | Seminole | Florida | 12117 | 63663 | 891 |
2002234 | 2002234 | 2021-12-11 | Seminole | Florida | 12117 | 63663 | 891 |
1998984 | 1998984 | 2021-12-10 | Seminole | Florida | 12117 | 63663 | 891 |
1995733 | 1995733 | 2021-12-09 | Seminole | Florida | 12117 | 63412 | 891 |
1992482 | 1992482 | 2021-12-08 | Seminole | Florida | 12117 | 63412 | 891 |
1989231 | 1989231 | 2021-12-07 | Seminole | Florida | 12117 | 63412 | 885 |
1985981 | 1985981 | 2021-12-06 | Seminole | Florida | 12117 | 63412 | 885 |
1982731 | 1982731 | 2021-12-05 | Seminole | Florida | 12117 | 63412 | 885 |
1979481 | 1979481 | 2021-12-04 | Seminole | Florida | 12117 | 63412 | 885 |
1976231 | 1976231 | 2021-12-03 | Seminole | Florida | 12117 | 63412 | 885 |
1972982 | 1972982 | 2021-12-02 | Seminole | Florida | 12117 | 63170 | 885 |
1969732 | 1969732 | 2021-12-01 | Seminole | Florida | 12117 | 63170 | 885 |
1966482 | 1966482 | 2021-11-30 | Seminole | Florida | 12117 | 63170 | 885 |
1963230 | 1963230 | 2021-11-29 | Seminole | Florida | 12117 | 62922 | 885 |
1959979 | 1959979 | 2021-11-28 | Seminole | Florida | 12117 | 62922 | 885 |
1956728 | 1956728 | 2021-11-27 | Seminole | Florida | 12117 | 62922 | 885 |
1953477 | 1953477 | 2021-11-26 | Seminole | Florida | 12117 | 62922 | 885 |
1950226 | 1950226 | 2021-11-25 | Seminole | Florida | 12117 | 62922 | 885 |
1946975 | 1946975 | 2021-11-24 | Seminole | Florida | 12117 | 62922 | 885 |
1943724 | 1943724 | 2021-11-23 | Seminole | Florida | 12117 | 62922 | 885 |
1940474 | 1940474 | 2021-11-22 | Seminole | Florida | 12117 | 62922 | 885 |
1937224 | 1937224 | 2021-11-21 | Seminole | Florida | 12117 | 62922 | 885 |
1933974 | 1933974 | 2021-11-20 | Seminole | Florida | 12117 | 62922 | 885 |
1930722 | 1930722 | 2021-11-19 | Seminole | Florida | 12117 | 62922 | 877 |
1927472 | 1927472 | 2021-11-18 | Seminole | Florida | 12117 | 62629 | 877 |
1924222 | 1924222 | 2021-11-17 | Seminole | Florida | 12117 | 62629 | 877 |
1920973 | 1920973 | 2021-11-16 | Seminole | Florida | 12117 | 62629 | 877 |
1917723 | 1917723 | 2021-11-15 | Seminole | Florida | 12117 | 62629 | 877 |
1914473 | 1914473 | 2021-11-14 | Seminole | Florida | 12117 | 62629 | 866 |
1911223 | 1911223 | 2021-11-13 | Seminole | Florida | 12117 | 62629 | 866 |
1907974 | 1907974 | 2021-11-12 | Seminole | Florida | 12117 | 62629 | 866 |
1904725 | 1904725 | 2021-11-11 | Seminole | Florida | 12117 | 62334 | 866 |
1901475 | 1901475 | 2021-11-10 | Seminole | Florida | 12117 | 62334 | 866 |
1898225 | 1898225 | 2021-11-09 | Seminole | Florida | 12117 | 62334 | 866 |
1894975 | 1894975 | 2021-11-08 | Seminole | Florida | 12117 | 62334 | 866 |
1891725 | 1891725 | 2021-11-07 | Seminole | Florida | 12117 | 62334 | 857 |
1888475 | 1888475 | 2021-11-06 | Seminole | Florida | 12117 | 62334 | 857 |
1885225 | 1885225 | 2021-11-05 | Seminole | Florida | 12117 | 62334 | 857 |
1881976 | 1881976 | 2021-11-04 | Seminole | Florida | 12117 | 62054 | 857 |
1878727 | 1878727 | 2021-11-03 | Seminole | Florida | 12117 | 62054 | 857 |
1875478 | 1875478 | 2021-11-02 | Seminole | Florida | 12117 | 62054 | 857 |
1872229 | 1872229 | 2021-11-01 | Seminole | Florida | 12117 | 62054 | 857 |
1868980 | 1868980 | 2021-10-31 | Seminole | Florida | 12117 | 62054 | 857 |
1865731 | 1865731 | 2021-10-30 | Seminole | Florida | 12117 | 62054 | 843 |
1862482 | 1862482 | 2021-10-29 | Seminole | Florida | 12117 | 62054 | 843 |
1859233 | 1859233 | 2021-10-28 | Seminole | Florida | 12117 | 61835 | 843 |
1855984 | 1855984 | 2021-10-27 | Seminole | Florida | 12117 | 61835 | 843 |
1852735 | 1852735 | 2021-10-26 | Seminole | Florida | 12117 | 61835 | 843 |
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);