ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Unknown" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174581 | 2174581 | 2022-02-02 | Unknown | Florida | 94087 | 318 | |
2171328 | 2171328 | 2022-02-01 | Unknown | Florida | 77204 | 1508 | |
2168075 | 2168075 | 2022-01-31 | Unknown | Florida | 57133 | 1502 | |
2164820 | 2164820 | 2022-01-30 | Unknown | Florida | 22929 | 1192 | |
2161565 | 2161565 | 2022-01-29 | Unknown | Florida | 22929 | 1192 | |
2158309 | 2158309 | 2022-01-28 | Unknown | Florida | 224 | 1192 | |
2155056 | 2155056 | 2022-01-27 | Unknown | Florida | 167386 | 872 | |
2151803 | 2151803 | 2022-01-26 | Unknown | Florida | 139853 | 244 | |
2148551 | 2148551 | 2022-01-25 | Unknown | Florida | 102192 | 847 | |
2145299 | 2145299 | 2022-01-24 | Unknown | Florida | 66926 | 844 | |
2142044 | 2142044 | 2022-01-23 | Unknown | Florida | 22916 | 605 | |
2138789 | 2138789 | 2022-01-22 | Unknown | Florida | 22916 | 605 | |
2135533 | 2135533 | 2022-01-21 | Unknown | Florida | 98 | 605 | |
2132281 | 2132281 | 2022-01-20 | Unknown | Florida | 250122 | 411 | |
2129028 | 2129028 | 2022-01-19 | Unknown | Florida | 204454 | 300 | |
2125774 | 2125774 | 2022-01-18 | Unknown | Florida | 161275 | 767 | |
2122522 | 2122522 | 2022-01-17 | Unknown | Florida | 49654 | 470 | |
2119270 | 2119270 | 2022-01-16 | Unknown | Florida | 49654 | 470 | |
2116018 | 2116018 | 2022-01-15 | Unknown | Florida | 49654 | 470 | |
2112767 | 2112767 | 2022-01-14 | Unknown | Florida | 315 | 470 | |
2109515 | 2109515 | 2022-01-13 | Unknown | Florida | 370566 | 393 | |
2106264 | 2106264 | 2022-01-12 | Unknown | Florida | 315572 | 131 | |
2103013 | 2103013 | 2022-01-11 | Unknown | Florida | 243830 | 309 | |
2099762 | 2099762 | 2022-01-10 | Unknown | Florida | 196121 | 306 | |
2096511 | 2096511 | 2022-01-09 | Unknown | Florida | 70125 | 184 | |
2093259 | 2093259 | 2022-01-08 | Unknown | Florida | 70125 | 184 | |
2090007 | 2090007 | 2022-01-07 | Unknown | Florida | 211 | 184 | |
2086756 | 2086756 | 2022-01-06 | Unknown | Florida | 319889 | 118 | |
2083504 | 2083504 | 2022-01-05 | Unknown | Florida | 253278 | 38 | |
2080252 | 2080252 | 2022-01-04 | Unknown | Florida | 193791 | 199 | |
2077000 | 2077000 | 2022-01-03 | Unknown | Florida | 5 | 162 | |
2073749 | 2073749 | 2022-01-02 | Unknown | Florida | 5 | 162 | |
2070498 | 2070498 | 2022-01-01 | Unknown | Florida | 5 | 162 | |
2067247 | 2067247 | 2021-12-31 | Unknown | Florida | 5 | 162 | |
2063996 | 2063996 | 2021-12-30 | Unknown | Florida | 225789 | 138 | |
2060746 | 2060746 | 2021-12-29 | Unknown | Florida | 147941 | 48 | |
2057497 | 2057497 | 2021-12-28 | Unknown | Florida | 101018 | 170 | |
2054248 | 2054248 | 2021-12-27 | Unknown | Florida | 71959 | 169 | |
2050998 | 2050998 | 2021-12-26 | Unknown | Florida | 2 | 127 | |
2047748 | 2047748 | 2021-12-25 | Unknown | Florida | 2 | 127 | |
2044498 | 2044498 | 2021-12-24 | Unknown | Florida | 2 | 127 | |
2041249 | 2041249 | 2021-12-23 | Unknown | Florida | 93183 | 127 | |
2037999 | 2037999 | 2021-12-22 | Unknown | Florida | 60314 | 44 | |
2034749 | 2034749 | 2021-12-21 | Unknown | Florida | 40120 | 238 | |
2031499 | 2031499 | 2021-12-20 | Unknown | Florida | 27205 | 238 | |
2028248 | 2028248 | 2021-12-19 | Unknown | Florida | 8801 | 194 | |
2024997 | 2024997 | 2021-12-18 | Unknown | Florida | 8801 | 194 | |
2021746 | 2021746 | 2021-12-17 | Unknown | Florida | 92 | 194 | |
2018495 | 2018495 | 2021-12-16 | Unknown | Florida | 20148 | 165 | |
2015245 | 2015245 | 2021-12-15 | Unknown | Florida | 13767 | 48 | |
2011994 | 2011994 | 2021-12-14 | Unknown | Florida | 9640 | 47 | |
2008743 | 2008743 | 2021-12-13 | Unknown | Florida | 6573 | 452 | |
2005492 | 2005492 | 2021-12-12 | Unknown | Florida | 2708 | 405 | |
2002241 | 2002241 | 2021-12-11 | Unknown | Florida | 2708 | 405 | |
1998991 | 1998991 | 2021-12-10 | Unknown | Florida | 118 | 405 | |
1995740 | 1995740 | 2021-12-09 | Unknown | Florida | 10682 | 386 | |
1992489 | 1992489 | 2021-12-08 | Unknown | Florida | 8377 | 168 | |
1989238 | 1989238 | 2021-12-07 | Unknown | Florida | 6491 | 708 | |
1985988 | 1985988 | 2021-12-06 | Unknown | Florida | 4816 | 708 | |
1982738 | 1982738 | 2021-12-05 | Unknown | Florida | 2102 | 620 | |
1979488 | 1979488 | 2021-12-04 | Unknown | Florida | 2102 | 620 | |
1976238 | 1976238 | 2021-12-03 | Unknown | Florida | 102 | 620 | |
1972989 | 1972989 | 2021-12-02 | Unknown | Florida | 8782 | 549 | |
1969739 | 1969739 | 2021-12-01 | Unknown | Florida | 6657 | 467 | |
1966489 | 1966489 | 2021-11-30 | Unknown | Florida | 4561 | 467 | |
1963237 | 1963237 | 2021-11-29 | Unknown | Florida | 11821 | 457 | |
1959986 | 1959986 | 2021-11-28 | Unknown | Florida | 7032 | 66 | |
1956735 | 1956735 | 2021-11-27 | Unknown | Florida | 6365 | 66 | |
1953484 | 1953484 | 2021-11-26 | Unknown | Florida | 6365 | 66 | |
1950233 | 1950233 | 2021-11-25 | Unknown | Florida | 6365 | 66 | |
1946982 | 1946982 | 2021-11-24 | Unknown | Florida | 6365 | 66 | |
1943731 | 1943731 | 2021-11-23 | Unknown | Florida | 4842 | 66 | |
1940481 | 1940481 | 2021-11-22 | Unknown | Florida | 3237 | 66 | |
1937231 | 1937231 | 2021-11-21 | Unknown | Florida | 1581 | 0 | |
1933981 | 1933981 | 2021-11-20 | Unknown | Florida | 1581 | 0 | |
1930729 | 1930729 | 2021-11-19 | Unknown | Florida | 1 | 356 | |
1927479 | 1927479 | 2021-11-18 | Unknown | Florida | 8558 | 121 | |
1924229 | 1924229 | 2021-11-17 | Unknown | Florida | 6505 | 121 | |
1920980 | 1920980 | 2021-11-16 | Unknown | Florida | 4957 | 121 | |
1917730 | 1917730 | 2021-11-15 | Unknown | Florida | 3405 | 120 | |
1914480 | 1914480 | 2021-11-14 | Unknown | Florida | 1413 | 300 | |
1911230 | 1911230 | 2021-11-13 | Unknown | Florida | 1413 | 300 | |
1907981 | 1907981 | 2021-11-12 | Unknown | Florida | 1 | 299 | |
1904732 | 1904732 | 2021-11-11 | Unknown | Florida | 6629 | 20 | |
1901482 | 1901482 | 2021-11-10 | Unknown | Florida | 6629 | 20 | |
1898232 | 1898232 | 2021-11-09 | Unknown | Florida | 5183 | 20 | |
1894982 | 1894982 | 2021-11-08 | Unknown | Florida | 3408 | 20 | |
1891732 | 1891732 | 2021-11-07 | Unknown | Florida | 1481 | 686 | |
1888482 | 1888482 | 2021-11-06 | Unknown | Florida | 1481 | 686 | |
1885232 | 1885232 | 2021-11-05 | Unknown | Florida | 1 | 686 | |
1881983 | 1881983 | 2021-11-04 | Unknown | Florida | 8735 | 22 | |
1878734 | 1878734 | 2021-11-03 | Unknown | Florida | 7166 | 22 | |
1875485 | 1875485 | 2021-11-02 | Unknown | Florida | 5362 | 22 | |
1872236 | 1872236 | 2021-11-01 | Unknown | Florida | 3362 | 22 | |
1868987 | 1868987 | 2021-10-31 | Unknown | Florida | 1668 | 22 | |
1865738 | 1865738 | 2021-10-30 | Unknown | Florida | 1668 | 867 | |
1862489 | 1862489 | 2021-10-29 | Unknown | Florida | 2 | 867 | |
1859240 | 1859240 | 2021-10-28 | Unknown | Florida | 10087 | 692 | |
1855991 | 1855991 | 2021-10-27 | Unknown | Florida | 8066 | 130 | |
1852742 | 1852742 | 2021-10-26 | Unknown | Florida | 6179 | 130 |
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);