ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where fips = 6097 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1849342 | 1849342 | 2021-10-25 | Sonoma | California | 6097 | 40997 | 404 |
1846092 | 1846092 | 2021-10-24 | Sonoma | California | 6097 | 40997 | 404 |
1842842 | 1842842 | 2021-10-23 | Sonoma | California | 6097 | 40997 | 404 |
1839592 | 1839592 | 2021-10-22 | Sonoma | California | 6097 | 40997 | 402 |
1836343 | 1836343 | 2021-10-21 | Sonoma | California | 6097 | 40925 | 402 |
1833094 | 1833094 | 2021-10-20 | Sonoma | California | 6097 | 40895 | 402 |
1829845 | 1829845 | 2021-10-19 | Sonoma | California | 6097 | 40865 | 402 |
1826596 | 1826596 | 2021-10-18 | Sonoma | California | 6097 | 40822 | 402 |
1823347 | 1823347 | 2021-10-17 | Sonoma | California | 6097 | 40711 | 402 |
1820098 | 1820098 | 2021-10-16 | Sonoma | California | 6097 | 40711 | 402 |
1816849 | 1816849 | 2021-10-15 | Sonoma | California | 6097 | 40711 | 402 |
1813601 | 1813601 | 2021-10-14 | Sonoma | California | 6097 | 40638 | 400 |
1810352 | 1810352 | 2021-10-13 | Sonoma | California | 6097 | 40613 | 398 |
1807103 | 1807103 | 2021-10-12 | Sonoma | California | 6097 | 40575 | 398 |
1803852 | 1803852 | 2021-10-11 | Sonoma | California | 6097 | 40535 | 396 |
1800603 | 1800603 | 2021-10-10 | Sonoma | California | 6097 | 40356 | 396 |
1797354 | 1797354 | 2021-10-09 | Sonoma | California | 6097 | 40356 | 396 |
1794105 | 1794105 | 2021-10-08 | Sonoma | California | 6097 | 40356 | 396 |
1790857 | 1790857 | 2021-10-07 | Sonoma | California | 6097 | 40295 | 396 |
1787608 | 1787608 | 2021-10-06 | Sonoma | California | 6097 | 40260 | 390 |
1784359 | 1784359 | 2021-10-05 | Sonoma | California | 6097 | 40224 | 386 |
1781110 | 1781110 | 2021-10-04 | Sonoma | California | 6097 | 40183 | 386 |
1777860 | 1777860 | 2021-10-03 | Sonoma | California | 6097 | 40001 | 386 |
1774610 | 1774610 | 2021-10-02 | Sonoma | California | 6097 | 40001 | 386 |
1771360 | 1771360 | 2021-10-01 | Sonoma | California | 6097 | 40001 | 386 |
1768111 | 1768111 | 2021-09-30 | Sonoma | California | 6097 | 39930 | 386 |
1764862 | 1764862 | 2021-09-29 | Sonoma | California | 6097 | 39892 | 384 |
1761613 | 1761613 | 2021-09-28 | Sonoma | California | 6097 | 39844 | 384 |
1758365 | 1758365 | 2021-09-27 | Sonoma | California | 6097 | 39799 | 384 |
1755117 | 1755117 | 2021-09-26 | Sonoma | California | 6097 | 39609 | 384 |
1751869 | 1751869 | 2021-09-25 | Sonoma | California | 6097 | 39609 | 384 |
1748620 | 1748620 | 2021-09-24 | Sonoma | California | 6097 | 39609 | 381 |
1745370 | 1745370 | 2021-09-23 | Sonoma | California | 6097 | 39560 | 381 |
1742121 | 1742121 | 2021-09-22 | Sonoma | California | 6097 | 39527 | 378 |
1738872 | 1738872 | 2021-09-21 | Sonoma | California | 6097 | 39476 | 378 |
1735623 | 1735623 | 2021-09-20 | Sonoma | California | 6097 | 39441 | 376 |
1732373 | 1732373 | 2021-09-19 | Sonoma | California | 6097 | 39376 | 376 |
1729123 | 1729123 | 2021-09-18 | Sonoma | California | 6097 | 39293 | 376 |
1725873 | 1725873 | 2021-09-17 | Sonoma | California | 6097 | 39192 | 376 |
1722624 | 1722624 | 2021-09-16 | Sonoma | California | 6097 | 39114 | 372 |
1719375 | 1719375 | 2021-09-15 | Sonoma | California | 6097 | 39066 | 372 |
1716127 | 1716127 | 2021-09-14 | Sonoma | California | 6097 | 38984 | 368 |
1712881 | 1712881 | 2021-09-13 | Sonoma | California | 6097 | 38927 | 368 |
1709634 | 1709634 | 2021-09-12 | Sonoma | California | 6097 | 38870 | 368 |
1706387 | 1706387 | 2021-09-11 | Sonoma | California | 6097 | 38742 | 368 |
1703139 | 1703139 | 2021-09-10 | Sonoma | California | 6097 | 38642 | 368 |
1699889 | 1699889 | 2021-09-09 | Sonoma | California | 6097 | 38546 | 365 |
1696640 | 1696640 | 2021-09-08 | Sonoma | California | 6097 | 38473 | 365 |
1693392 | 1693392 | 2021-09-07 | Sonoma | California | 6097 | 38389 | 365 |
1690143 | 1690143 | 2021-09-06 | Sonoma | California | 6097 | 38341 | 365 |
1686893 | 1686893 | 2021-09-05 | Sonoma | California | 6097 | 38269 | 365 |
1683643 | 1683643 | 2021-09-04 | Sonoma | California | 6097 | 38159 | 365 |
1680392 | 1680392 | 2021-09-03 | Sonoma | California | 6097 | 38018 | 361 |
1677144 | 1677144 | 2021-09-02 | Sonoma | California | 6097 | 37914 | 356 |
1673897 | 1673897 | 2021-09-01 | Sonoma | California | 6097 | 37827 | 356 |
1670649 | 1670649 | 2021-08-31 | Sonoma | California | 6097 | 37212 | 353 |
1667402 | 1667402 | 2021-08-30 | Sonoma | California | 6097 | 37098 | 353 |
1664155 | 1664155 | 2021-08-29 | Sonoma | California | 6097 | 36914 | 353 |
1660907 | 1660907 | 2021-08-28 | Sonoma | California | 6097 | 36774 | 353 |
1657659 | 1657659 | 2021-08-27 | Sonoma | California | 6097 | 36550 | 349 |
1654411 | 1654411 | 2021-08-26 | Sonoma | California | 6097 | 36434 | 349 |
1651164 | 1651164 | 2021-08-25 | Sonoma | California | 6097 | 36289 | 347 |
1647915 | 1647915 | 2021-08-24 | Sonoma | California | 6097 | 36209 | 344 |
1644667 | 1644667 | 2021-08-23 | Sonoma | California | 6097 | 36116 | 344 |
1641417 | 1641417 | 2021-08-22 | Sonoma | California | 6097 | 36022 | 344 |
1638167 | 1638167 | 2021-08-21 | Sonoma | California | 6097 | 35856 | 344 |
1634917 | 1634917 | 2021-08-20 | Sonoma | California | 6097 | 35673 | 344 |
1631668 | 1631668 | 2021-08-19 | Sonoma | California | 6097 | 35503 | 344 |
1628421 | 1628421 | 2021-08-18 | Sonoma | California | 6097 | 35363 | 340 |
1625174 | 1625174 | 2021-08-17 | Sonoma | California | 6097 | 35264 | 338 |
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);