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 |
---|---|---|---|---|---|---|---|
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 |
1621927 | 1621927 | 2021-08-16 | Sonoma | California | 6097 | 35126 | 338 |
1618680 | 1618680 | 2021-08-15 | Sonoma | California | 6097 | 35026 | 338 |
1615432 | 1615432 | 2021-08-14 | Sonoma | California | 6097 | 34884 | 338 |
1612183 | 1612183 | 2021-08-13 | Sonoma | California | 6097 | 34719 | 337 |
1608935 | 1608935 | 2021-08-12 | Sonoma | California | 6097 | 34608 | 337 |
1605686 | 1605686 | 2021-08-11 | Sonoma | California | 6097 | 34474 | 337 |
1602437 | 1602437 | 2021-08-10 | Sonoma | California | 6097 | 34353 | 337 |
1599188 | 1599188 | 2021-08-09 | Sonoma | California | 6097 | 34225 | 334 |
1595939 | 1595939 | 2021-08-08 | Sonoma | California | 6097 | 34136 | 334 |
1592690 | 1592690 | 2021-08-07 | Sonoma | California | 6097 | 33875 | 334 |
1589441 | 1589441 | 2021-08-06 | Sonoma | California | 6097 | 33875 | 334 |
1586192 | 1586192 | 2021-08-05 | Sonoma | California | 6097 | 33731 | 331 |
1582942 | 1582942 | 2021-08-04 | Sonoma | California | 6097 | 33639 | 331 |
1579692 | 1579692 | 2021-08-03 | Sonoma | California | 6097 | 33528 | 331 |
1576444 | 1576444 | 2021-08-02 | Sonoma | California | 6097 | 33472 | 330 |
1573196 | 1573196 | 2021-08-01 | Sonoma | California | 6097 | 32997 | 330 |
1569948 | 1569948 | 2021-07-31 | Sonoma | California | 6097 | 32997 | 330 |
1566700 | 1566700 | 2021-07-30 | Sonoma | California | 6097 | 32997 | 330 |
1563452 | 1563452 | 2021-07-29 | Sonoma | California | 6097 | 32830 | 329 |
1560204 | 1560204 | 2021-07-28 | Sonoma | California | 6097 | 32760 | 329 |
1556957 | 1556957 | 2021-07-27 | Sonoma | California | 6097 | 32676 | 329 |
1553710 | 1553710 | 2021-07-26 | Sonoma | California | 6097 | 32595 | 329 |
1550463 | 1550463 | 2021-07-25 | Sonoma | California | 6097 | 32321 | 329 |
1547216 | 1547216 | 2021-07-24 | Sonoma | California | 6097 | 32321 | 328 |
1543969 | 1543969 | 2021-07-23 | Sonoma | California | 6097 | 32321 | 328 |
1540721 | 1540721 | 2021-07-22 | Sonoma | California | 6097 | 32182 | 328 |
1537474 | 1537474 | 2021-07-21 | Sonoma | California | 6097 | 32144 | 327 |
1534226 | 1534226 | 2021-07-20 | Sonoma | California | 6097 | 32094 | 327 |
1530979 | 1530979 | 2021-07-19 | Sonoma | California | 6097 | 32056 | 327 |
1527732 | 1527732 | 2021-07-18 | Sonoma | California | 6097 | 31917 | 327 |
1524485 | 1524485 | 2021-07-17 | Sonoma | California | 6097 | 31917 | 327 |
1521237 | 1521237 | 2021-07-16 | Sonoma | California | 6097 | 31917 | 326 |
1517989 | 1517989 | 2021-07-15 | Sonoma | California | 6097 | 31851 | 323 |
1514742 | 1514742 | 2021-07-14 | Sonoma | California | 6097 | 31812 | 323 |
1511496 | 1511496 | 2021-07-13 | Sonoma | California | 6097 | 31758 | 323 |
1508249 | 1508249 | 2021-07-12 | Sonoma | California | 6097 | 31733 | 323 |
1505003 | 1505003 | 2021-07-11 | Sonoma | California | 6097 | 31612 | 323 |
1501757 | 1501757 | 2021-07-10 | Sonoma | California | 6097 | 31612 | 323 |
1498511 | 1498511 | 2021-07-09 | Sonoma | California | 6097 | 31612 | 319 |
1495264 | 1495264 | 2021-07-08 | Sonoma | California | 6097 | 31553 | 319 |
1492017 | 1492017 | 2021-07-07 | Sonoma | California | 6097 | 31160 | 318 |
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);