ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where fips = 6097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174430 | 2174430 | 2022-02-02 | Sonoma | California | 6097 | 78143 | 445 |
2171177 | 2171177 | 2022-02-01 | Sonoma | California | 6097 | 77963 | 445 |
2167924 | 2167924 | 2022-01-31 | Sonoma | California | 6097 | 77654 | 445 |
2164669 | 2164669 | 2022-01-30 | Sonoma | California | 6097 | 75608 | 445 |
2161414 | 2161414 | 2022-01-29 | Sonoma | California | 6097 | 75203 | 440 |
2158158 | 2158158 | 2022-01-28 | Sonoma | California | 6097 | 75203 | 440 |
2154905 | 2154905 | 2022-01-27 | Sonoma | California | 6097 | 74273 | 437 |
2151652 | 2151652 | 2022-01-26 | Sonoma | California | 6097 | 73163 | 432 |
2148400 | 2148400 | 2022-01-25 | Sonoma | California | 6097 | 72263 | 432 |
2145148 | 2145148 | 2022-01-24 | Sonoma | California | 6097 | 71321 | 432 |
2141893 | 2141893 | 2022-01-23 | Sonoma | California | 6097 | 68776 | 432 |
2138638 | 2138638 | 2022-01-22 | Sonoma | California | 6097 | 67646 | 432 |
2135382 | 2135382 | 2022-01-21 | Sonoma | California | 6097 | 67543 | 429 |
2132130 | 2132130 | 2022-01-20 | Sonoma | California | 6097 | 66219 | 429 |
2128877 | 2128877 | 2022-01-19 | Sonoma | California | 6097 | 64701 | 429 |
2125623 | 2125623 | 2022-01-18 | Sonoma | California | 6097 | 63750 | 426 |
2122371 | 2122371 | 2022-01-17 | Sonoma | California | 6097 | 62829 | 426 |
2119119 | 2119119 | 2022-01-16 | Sonoma | California | 6097 | 60574 | 426 |
2115867 | 2115867 | 2022-01-15 | Sonoma | California | 6097 | 59439 | 426 |
2112616 | 2112616 | 2022-01-14 | Sonoma | California | 6097 | 59168 | 423 |
2109364 | 2109364 | 2022-01-13 | Sonoma | California | 6097 | 57381 | 422 |
2106113 | 2106113 | 2022-01-12 | Sonoma | California | 6097 | 56159 | 421 |
2102862 | 2102862 | 2022-01-11 | Sonoma | California | 6097 | 55226 | 421 |
2099611 | 2099611 | 2022-01-10 | Sonoma | California | 6097 | 54291 | 421 |
2096360 | 2096360 | 2022-01-09 | Sonoma | California | 6097 | 50878 | 419 |
2093108 | 2093108 | 2022-01-08 | Sonoma | California | 6097 | 50878 | 419 |
2089856 | 2089856 | 2022-01-07 | Sonoma | California | 6097 | 50878 | 419 |
2086605 | 2086605 | 2022-01-06 | Sonoma | California | 6097 | 49868 | 418 |
2083353 | 2083353 | 2022-01-05 | Sonoma | California | 6097 | 49292 | 418 |
2080101 | 2080101 | 2022-01-04 | Sonoma | California | 6097 | 49030 | 418 |
2076849 | 2076849 | 2022-01-03 | Sonoma | California | 6097 | 46679 | 418 |
2073598 | 2073598 | 2022-01-02 | Sonoma | California | 6097 | 46679 | 418 |
2070347 | 2070347 | 2022-01-01 | Sonoma | California | 6097 | 46679 | 418 |
2067096 | 2067096 | 2021-12-31 | Sonoma | California | 6097 | 46679 | 418 |
2063845 | 2063845 | 2021-12-30 | Sonoma | California | 6097 | 46118 | 418 |
2060595 | 2060595 | 2021-12-29 | Sonoma | California | 6097 | 45709 | 418 |
2057346 | 2057346 | 2021-12-28 | Sonoma | California | 6097 | 45613 | 418 |
2054097 | 2054097 | 2021-12-27 | Sonoma | California | 6097 | 44981 | 418 |
2050847 | 2050847 | 2021-12-26 | Sonoma | California | 6097 | 44981 | 418 |
2047597 | 2047597 | 2021-12-25 | Sonoma | California | 6097 | 44981 | 418 |
2044347 | 2044347 | 2021-12-24 | Sonoma | California | 6097 | 44981 | 416 |
2041098 | 2041098 | 2021-12-23 | Sonoma | California | 6097 | 44824 | 416 |
2037848 | 2037848 | 2021-12-22 | Sonoma | California | 6097 | 44652 | 416 |
2034598 | 2034598 | 2021-12-21 | Sonoma | California | 6097 | 44583 | 416 |
2031348 | 2031348 | 2021-12-20 | Sonoma | California | 6097 | 44545 | 416 |
2028097 | 2028097 | 2021-12-19 | Sonoma | California | 6097 | 44259 | 416 |
2024846 | 2024846 | 2021-12-18 | Sonoma | California | 6097 | 44259 | 416 |
2021595 | 2021595 | 2021-12-17 | Sonoma | California | 6097 | 44259 | 416 |
2018344 | 2018344 | 2021-12-16 | Sonoma | California | 6097 | 44181 | 416 |
2015094 | 2015094 | 2021-12-15 | Sonoma | California | 6097 | 44122 | 416 |
2011843 | 2011843 | 2021-12-14 | Sonoma | California | 6097 | 44076 | 416 |
2008592 | 2008592 | 2021-12-13 | Sonoma | California | 6097 | 44008 | 416 |
2005341 | 2005341 | 2021-12-12 | Sonoma | California | 6097 | 43811 | 416 |
2002090 | 2002090 | 2021-12-11 | Sonoma | California | 6097 | 43811 | 416 |
1998840 | 1998840 | 2021-12-10 | Sonoma | California | 6097 | 43811 | 414 |
1995589 | 1995589 | 2021-12-09 | Sonoma | California | 6097 | 43763 | 414 |
1992338 | 1992338 | 2021-12-08 | Sonoma | California | 6097 | 43725 | 414 |
1989087 | 1989087 | 2021-12-07 | Sonoma | California | 6097 | 43685 | 414 |
1985837 | 1985837 | 2021-12-06 | Sonoma | California | 6097 | 43609 | 414 |
1982587 | 1982587 | 2021-12-05 | Sonoma | California | 6097 | 43349 | 414 |
1979337 | 1979337 | 2021-12-04 | Sonoma | California | 6097 | 43349 | 414 |
1976087 | 1976087 | 2021-12-03 | Sonoma | California | 6097 | 43349 | 414 |
1972838 | 1972838 | 2021-12-02 | Sonoma | California | 6097 | 43284 | 412 |
1969588 | 1969588 | 2021-12-01 | Sonoma | California | 6097 | 43207 | 412 |
1966338 | 1966338 | 2021-11-30 | Sonoma | California | 6097 | 43168 | 412 |
1963086 | 1963086 | 2021-11-29 | Sonoma | California | 6097 | 43127 | 412 |
1959835 | 1959835 | 2021-11-28 | Sonoma | California | 6097 | 42912 | 412 |
1956584 | 1956584 | 2021-11-27 | Sonoma | California | 6097 | 42912 | 412 |
1953333 | 1953333 | 2021-11-26 | Sonoma | California | 6097 | 42912 | 412 |
1950082 | 1950082 | 2021-11-25 | Sonoma | California | 6097 | 42912 | 412 |
1946831 | 1946831 | 2021-11-24 | Sonoma | California | 6097 | 42912 | 412 |
1943580 | 1943580 | 2021-11-23 | Sonoma | California | 6097 | 42888 | 412 |
1940330 | 1940330 | 2021-11-22 | Sonoma | California | 6097 | 42842 | 412 |
1937080 | 1937080 | 2021-11-21 | Sonoma | California | 6097 | 42695 | 412 |
1933830 | 1933830 | 2021-11-20 | Sonoma | California | 6097 | 42695 | 412 |
1930578 | 1930578 | 2021-11-19 | Sonoma | California | 6097 | 42695 | 412 |
1927328 | 1927328 | 2021-11-18 | Sonoma | California | 6097 | 42637 | 412 |
1924078 | 1924078 | 2021-11-17 | Sonoma | California | 6097 | 42596 | 410 |
1920829 | 1920829 | 2021-11-16 | Sonoma | California | 6097 | 42561 | 410 |
1917579 | 1917579 | 2021-11-15 | Sonoma | California | 6097 | 42514 | 410 |
1914329 | 1914329 | 2021-11-14 | Sonoma | California | 6097 | 42422 | 410 |
1911079 | 1911079 | 2021-11-13 | Sonoma | California | 6097 | 42422 | 410 |
1907830 | 1907830 | 2021-11-12 | Sonoma | California | 6097 | 42314 | 410 |
1904581 | 1904581 | 2021-11-11 | Sonoma | California | 6097 | 42314 | 410 |
1901331 | 1901331 | 2021-11-10 | Sonoma | California | 6097 | 42260 | 410 |
1898081 | 1898081 | 2021-11-09 | Sonoma | California | 6097 | 42202 | 408 |
1894831 | 1894831 | 2021-11-08 | Sonoma | California | 6097 | 42163 | 408 |
1891581 | 1891581 | 2021-11-07 | Sonoma | California | 6097 | 41931 | 408 |
1888331 | 1888331 | 2021-11-06 | Sonoma | California | 6097 | 41931 | 408 |
1885081 | 1885081 | 2021-11-05 | Sonoma | California | 6097 | 41931 | 408 |
1881832 | 1881832 | 2021-11-04 | Sonoma | California | 6097 | 41859 | 408 |
1878583 | 1878583 | 2021-11-03 | Sonoma | California | 6097 | 41817 | 406 |
1875334 | 1875334 | 2021-11-02 | Sonoma | California | 6097 | 41763 | 406 |
1872085 | 1872085 | 2021-11-01 | Sonoma | California | 6097 | 41712 | 406 |
1868836 | 1868836 | 2021-10-31 | Sonoma | California | 6097 | 41453 | 406 |
1865587 | 1865587 | 2021-10-30 | Sonoma | California | 6097 | 41453 | 406 |
1862338 | 1862338 | 2021-10-29 | Sonoma | California | 6097 | 41453 | 404 |
1859089 | 1859089 | 2021-10-28 | Sonoma | California | 6097 | 41358 | 404 |
1855840 | 1855840 | 2021-10-27 | Sonoma | California | 6097 | 41315 | 404 |
1852591 | 1852591 | 2021-10-26 | Sonoma | California | 6097 | 41267 | 404 |
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);