ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 12113 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174572 | 2174572 | 2022-02-02 | Santa Rosa | Florida | 12113 | 44198 | 546 |
2171319 | 2171319 | 2022-02-01 | Santa Rosa | Florida | 12113 | 44198 | 538 |
2168066 | 2168066 | 2022-01-31 | Santa Rosa | Florida | 12113 | 44198 | 538 |
2164811 | 2164811 | 2022-01-30 | Santa Rosa | Florida | 12113 | 44198 | 538 |
2161556 | 2161556 | 2022-01-29 | Santa Rosa | Florida | 12113 | 44198 | 538 |
2158300 | 2158300 | 2022-01-28 | Santa Rosa | Florida | 12113 | 44198 | 538 |
2155047 | 2155047 | 2022-01-27 | Santa Rosa | Florida | 12113 | 41926 | 538 |
2151794 | 2151794 | 2022-01-26 | Santa Rosa | Florida | 12113 | 41926 | 538 |
2148542 | 2148542 | 2022-01-25 | Santa Rosa | Florida | 12113 | 41926 | 534 |
2145290 | 2145290 | 2022-01-24 | Santa Rosa | Florida | 12113 | 41926 | 534 |
2142035 | 2142035 | 2022-01-23 | Santa Rosa | Florida | 12113 | 41926 | 534 |
2138780 | 2138780 | 2022-01-22 | Santa Rosa | Florida | 12113 | 41926 | 534 |
2135524 | 2135524 | 2022-01-21 | Santa Rosa | Florida | 12113 | 41926 | 534 |
2132272 | 2132272 | 2022-01-20 | Santa Rosa | Florida | 12113 | 38814 | 534 |
2129019 | 2129019 | 2022-01-19 | Santa Rosa | Florida | 12113 | 38814 | 534 |
2125765 | 2125765 | 2022-01-18 | Santa Rosa | Florida | 12113 | 38814 | 531 |
2122513 | 2122513 | 2022-01-17 | Santa Rosa | Florida | 12113 | 38814 | 531 |
2119261 | 2119261 | 2022-01-16 | Santa Rosa | Florida | 12113 | 38814 | 531 |
2116009 | 2116009 | 2022-01-15 | Santa Rosa | Florida | 12113 | 38814 | 531 |
2112758 | 2112758 | 2022-01-14 | Santa Rosa | Florida | 12113 | 38814 | 531 |
2109506 | 2109506 | 2022-01-13 | Santa Rosa | Florida | 12113 | 35949 | 531 |
2106255 | 2106255 | 2022-01-12 | Santa Rosa | Florida | 12113 | 35949 | 531 |
2103004 | 2103004 | 2022-01-11 | Santa Rosa | Florida | 12113 | 35949 | 531 |
2099753 | 2099753 | 2022-01-10 | Santa Rosa | Florida | 12113 | 35949 | 531 |
2096502 | 2096502 | 2022-01-09 | Santa Rosa | Florida | 12113 | 35949 | 531 |
2093250 | 2093250 | 2022-01-08 | Santa Rosa | Florida | 12113 | 35949 | 531 |
2089998 | 2089998 | 2022-01-07 | Santa Rosa | Florida | 12113 | 35949 | 531 |
2086747 | 2086747 | 2022-01-06 | Santa Rosa | Florida | 12113 | 34032 | 531 |
2083495 | 2083495 | 2022-01-05 | Santa Rosa | Florida | 12113 | 34032 | 531 |
2080243 | 2080243 | 2022-01-04 | Santa Rosa | Florida | 12113 | 34032 | 527 |
2076991 | 2076991 | 2022-01-03 | Santa Rosa | Florida | 12113 | 34032 | 527 |
2073740 | 2073740 | 2022-01-02 | Santa Rosa | Florida | 12113 | 34032 | 527 |
2070489 | 2070489 | 2022-01-01 | Santa Rosa | Florida | 12113 | 34032 | 527 |
2067238 | 2067238 | 2021-12-31 | Santa Rosa | Florida | 12113 | 34032 | 527 |
2063987 | 2063987 | 2021-12-30 | Santa Rosa | Florida | 12113 | 33130 | 527 |
2060737 | 2060737 | 2021-12-29 | Santa Rosa | Florida | 12113 | 33130 | 527 |
2057488 | 2057488 | 2021-12-28 | Santa Rosa | Florida | 12113 | 33130 | 525 |
2054239 | 2054239 | 2021-12-27 | Santa Rosa | Florida | 12113 | 33130 | 525 |
2050989 | 2050989 | 2021-12-26 | Santa Rosa | Florida | 12113 | 33130 | 525 |
2047739 | 2047739 | 2021-12-25 | Santa Rosa | Florida | 12113 | 33130 | 525 |
2044489 | 2044489 | 2021-12-24 | Santa Rosa | Florida | 12113 | 33130 | 525 |
2041240 | 2041240 | 2021-12-23 | Santa Rosa | Florida | 12113 | 32881 | 525 |
2037990 | 2037990 | 2021-12-22 | Santa Rosa | Florida | 12113 | 32881 | 525 |
2034740 | 2034740 | 2021-12-21 | Santa Rosa | Florida | 12113 | 32881 | 523 |
2031490 | 2031490 | 2021-12-20 | Santa Rosa | Florida | 12113 | 32881 | 523 |
2028239 | 2028239 | 2021-12-19 | Santa Rosa | Florida | 12113 | 32881 | 523 |
2024988 | 2024988 | 2021-12-18 | Santa Rosa | Florida | 12113 | 32881 | 523 |
2021737 | 2021737 | 2021-12-17 | Santa Rosa | Florida | 12113 | 32881 | 523 |
2018486 | 2018486 | 2021-12-16 | Santa Rosa | Florida | 12113 | 32816 | 523 |
2015236 | 2015236 | 2021-12-15 | Santa Rosa | Florida | 12113 | 32816 | 523 |
2011985 | 2011985 | 2021-12-14 | Santa Rosa | Florida | 12113 | 32816 | 523 |
2008734 | 2008734 | 2021-12-13 | Santa Rosa | Florida | 12113 | 32816 | 523 |
2005483 | 2005483 | 2021-12-12 | Santa Rosa | Florida | 12113 | 32816 | 523 |
2002232 | 2002232 | 2021-12-11 | Santa Rosa | Florida | 12113 | 32816 | 523 |
1998982 | 1998982 | 2021-12-10 | Santa Rosa | Florida | 12113 | 32816 | 523 |
1995731 | 1995731 | 2021-12-09 | Santa Rosa | Florida | 12113 | 32730 | 523 |
1992480 | 1992480 | 2021-12-08 | Santa Rosa | Florida | 12113 | 32730 | 523 |
1989229 | 1989229 | 2021-12-07 | Santa Rosa | Florida | 12113 | 32730 | 520 |
1985979 | 1985979 | 2021-12-06 | Santa Rosa | Florida | 12113 | 32730 | 520 |
1982729 | 1982729 | 2021-12-05 | Santa Rosa | Florida | 12113 | 32730 | 520 |
1979479 | 1979479 | 2021-12-04 | Santa Rosa | Florida | 12113 | 32730 | 520 |
1976229 | 1976229 | 2021-12-03 | Santa Rosa | Florida | 12113 | 32730 | 520 |
1972980 | 1972980 | 2021-12-02 | Santa Rosa | Florida | 12113 | 32645 | 520 |
1969730 | 1969730 | 2021-12-01 | Santa Rosa | Florida | 12113 | 32645 | 520 |
1966480 | 1966480 | 2021-11-30 | Santa Rosa | Florida | 12113 | 32645 | 520 |
1963228 | 1963228 | 2021-11-29 | Santa Rosa | Florida | 12113 | 32593 | 520 |
1959977 | 1959977 | 2021-11-28 | Santa Rosa | Florida | 12113 | 32593 | 520 |
1956726 | 1956726 | 2021-11-27 | Santa Rosa | Florida | 12113 | 32593 | 520 |
1953475 | 1953475 | 2021-11-26 | Santa Rosa | Florida | 12113 | 32593 | 520 |
1950224 | 1950224 | 2021-11-25 | Santa Rosa | Florida | 12113 | 32593 | 520 |
1946973 | 1946973 | 2021-11-24 | Santa Rosa | Florida | 12113 | 32593 | 520 |
1943722 | 1943722 | 2021-11-23 | Santa Rosa | Florida | 12113 | 32593 | 520 |
1940472 | 1940472 | 2021-11-22 | Santa Rosa | Florida | 12113 | 32593 | 520 |
1937222 | 1937222 | 2021-11-21 | Santa Rosa | Florida | 12113 | 32593 | 520 |
1933972 | 1933972 | 2021-11-20 | Santa Rosa | Florida | 12113 | 32593 | 520 |
1930720 | 1930720 | 2021-11-19 | Santa Rosa | Florida | 12113 | 32593 | 519 |
1927470 | 1927470 | 2021-11-18 | Santa Rosa | Florida | 12113 | 32530 | 519 |
1924220 | 1924220 | 2021-11-17 | Santa Rosa | Florida | 12113 | 32530 | 519 |
1920971 | 1920971 | 2021-11-16 | Santa Rosa | Florida | 12113 | 32530 | 519 |
1917721 | 1917721 | 2021-11-15 | Santa Rosa | Florida | 12113 | 32530 | 519 |
1914471 | 1914471 | 2021-11-14 | Santa Rosa | Florida | 12113 | 32530 | 518 |
1911221 | 1911221 | 2021-11-13 | Santa Rosa | Florida | 12113 | 32530 | 518 |
1907972 | 1907972 | 2021-11-12 | Santa Rosa | Florida | 12113 | 32530 | 518 |
1904723 | 1904723 | 2021-11-11 | Santa Rosa | Florida | 12113 | 32460 | 518 |
1901473 | 1901473 | 2021-11-10 | Santa Rosa | Florida | 12113 | 32460 | 518 |
1898223 | 1898223 | 2021-11-09 | Santa Rosa | Florida | 12113 | 32460 | 518 |
1894973 | 1894973 | 2021-11-08 | Santa Rosa | Florida | 12113 | 32460 | 518 |
1891723 | 1891723 | 2021-11-07 | Santa Rosa | Florida | 12113 | 32460 | 514 |
1888473 | 1888473 | 2021-11-06 | Santa Rosa | Florida | 12113 | 32460 | 514 |
1885223 | 1885223 | 2021-11-05 | Santa Rosa | Florida | 12113 | 32460 | 514 |
1881974 | 1881974 | 2021-11-04 | Santa Rosa | Florida | 12113 | 32381 | 514 |
1878725 | 1878725 | 2021-11-03 | Santa Rosa | Florida | 12113 | 32381 | 514 |
1875476 | 1875476 | 2021-11-02 | Santa Rosa | Florida | 12113 | 32381 | 514 |
1872227 | 1872227 | 2021-11-01 | Santa Rosa | Florida | 12113 | 32381 | 514 |
1868978 | 1868978 | 2021-10-31 | Santa Rosa | Florida | 12113 | 32381 | 514 |
1865729 | 1865729 | 2021-10-30 | Santa Rosa | Florida | 12113 | 32381 | 512 |
1862480 | 1862480 | 2021-10-29 | Santa Rosa | Florida | 12113 | 32381 | 512 |
1859231 | 1859231 | 2021-10-28 | Santa Rosa | Florida | 12113 | 32310 | 512 |
1855982 | 1855982 | 2021-10-27 | Santa Rosa | Florida | 12113 | 32310 | 512 |
1852733 | 1852733 | 2021-10-26 | Santa Rosa | Florida | 12113 | 32310 | 512 |
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);