ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
803 rows where fips = 6061 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1946813 | 1946813 | 2021-11-24 | Placer | California | 6061 | 41881 | 468 |
1943562 | 1943562 | 2021-11-23 | Placer | California | 6061 | 41836 | 465 |
1940312 | 1940312 | 2021-11-22 | Placer | California | 6061 | 41809 | 465 |
1937062 | 1937062 | 2021-11-21 | Placer | California | 6061 | 41680 | 462 |
1933812 | 1933812 | 2021-11-20 | Placer | California | 6061 | 41680 | 462 |
1930560 | 1930560 | 2021-11-19 | Placer | California | 6061 | 41680 | 462 |
1927310 | 1927310 | 2021-11-18 | Placer | California | 6061 | 41605 | 460 |
1924060 | 1924060 | 2021-11-17 | Placer | California | 6061 | 41494 | 459 |
1920811 | 1920811 | 2021-11-16 | Placer | California | 6061 | 41428 | 452 |
1917561 | 1917561 | 2021-11-15 | Placer | California | 6061 | 41387 | 452 |
1914311 | 1914311 | 2021-11-14 | Placer | California | 6061 | 41271 | 445 |
1911061 | 1911061 | 2021-11-13 | Placer | California | 6061 | 41271 | 445 |
1907812 | 1907812 | 2021-11-12 | Placer | California | 6061 | 41151 | 444 |
1904563 | 1904563 | 2021-11-11 | Placer | California | 6061 | 41151 | 440 |
1901313 | 1901313 | 2021-11-10 | Placer | California | 6061 | 41040 | 440 |
1898063 | 1898063 | 2021-11-09 | Placer | California | 6061 | 40999 | 439 |
1894813 | 1894813 | 2021-11-08 | Placer | California | 6061 | 40951 | 439 |
1891563 | 1891563 | 2021-11-07 | Placer | California | 6061 | 40716 | 438 |
1888313 | 1888313 | 2021-11-06 | Placer | California | 6061 | 40716 | 438 |
1885063 | 1885063 | 2021-11-05 | Placer | California | 6061 | 40716 | 438 |
1881814 | 1881814 | 2021-11-04 | Placer | California | 6061 | 40617 | 438 |
1878565 | 1878565 | 2021-11-03 | Placer | California | 6061 | 40493 | 438 |
1875316 | 1875316 | 2021-11-02 | Placer | California | 6061 | 40423 | 435 |
1872067 | 1872067 | 2021-11-01 | Placer | California | 6061 | 40374 | 435 |
1868818 | 1868818 | 2021-10-31 | Placer | California | 6061 | 40076 | 434 |
1865569 | 1865569 | 2021-10-30 | Placer | California | 6061 | 40076 | 434 |
1862320 | 1862320 | 2021-10-29 | Placer | California | 6061 | 40076 | 434 |
1859071 | 1859071 | 2021-10-28 | Placer | California | 6061 | 39972 | 434 |
1855822 | 1855822 | 2021-10-27 | Placer | California | 6061 | 39858 | 434 |
1852573 | 1852573 | 2021-10-26 | Placer | California | 6061 | 39766 | 431 |
1849324 | 1849324 | 2021-10-25 | Placer | California | 6061 | 39435 | 429 |
1846074 | 1846074 | 2021-10-24 | Placer | California | 6061 | 39435 | 429 |
1842824 | 1842824 | 2021-10-23 | Placer | California | 6061 | 39435 | 429 |
1839574 | 1839574 | 2021-10-22 | Placer | California | 6061 | 39435 | 429 |
1836325 | 1836325 | 2021-10-21 | Placer | California | 6061 | 39342 | 425 |
1833076 | 1833076 | 2021-10-20 | Placer | California | 6061 | 39222 | 424 |
1829827 | 1829827 | 2021-10-19 | Placer | California | 6061 | 39157 | 420 |
1826578 | 1826578 | 2021-10-18 | Placer | California | 6061 | 39118 | 420 |
1823329 | 1823329 | 2021-10-17 | Placer | California | 6061 | 38902 | 415 |
1820080 | 1820080 | 2021-10-16 | Placer | California | 6061 | 38902 | 415 |
1816831 | 1816831 | 2021-10-15 | Placer | California | 6061 | 38902 | 415 |
1813583 | 1813583 | 2021-10-14 | Placer | California | 6061 | 38813 | 412 |
1810334 | 1810334 | 2021-10-13 | Placer | California | 6061 | 38714 | 405 |
1807085 | 1807085 | 2021-10-12 | Placer | California | 6061 | 38673 | 404 |
1803834 | 1803834 | 2021-10-11 | Placer | California | 6061 | 38628 | 404 |
1800585 | 1800585 | 2021-10-10 | Placer | California | 6061 | 38377 | 393 |
1797336 | 1797336 | 2021-10-09 | Placer | California | 6061 | 38377 | 393 |
1794087 | 1794087 | 2021-10-08 | Placer | California | 6061 | 38377 | 393 |
1790839 | 1790839 | 2021-10-07 | Placer | California | 6061 | 38264 | 390 |
1787590 | 1787590 | 2021-10-06 | Placer | California | 6061 | 38093 | 384 |
1784341 | 1784341 | 2021-10-05 | Placer | California | 6061 | 37995 | 379 |
1781092 | 1781092 | 2021-10-04 | Placer | California | 6061 | 37961 | 379 |
1777842 | 1777842 | 2021-10-03 | Placer | California | 6061 | 37742 | 381 |
1774592 | 1774592 | 2021-10-02 | Placer | California | 6061 | 37742 | 381 |
1771342 | 1771342 | 2021-10-01 | Placer | California | 6061 | 37742 | 381 |
1768093 | 1768093 | 2021-09-30 | Placer | California | 6061 | 37636 | 379 |
1764844 | 1764844 | 2021-09-29 | Placer | California | 6061 | 37456 | 374 |
1761595 | 1761595 | 2021-09-28 | Placer | California | 6061 | 37356 | 370 |
1758347 | 1758347 | 2021-09-27 | Placer | California | 6061 | 37312 | 370 |
1755099 | 1755099 | 2021-09-26 | Placer | California | 6061 | 37033 | 367 |
1751851 | 1751851 | 2021-09-25 | Placer | California | 6061 | 37033 | 367 |
1748602 | 1748602 | 2021-09-24 | Placer | California | 6061 | 37033 | 367 |
1745352 | 1745352 | 2021-09-23 | Placer | California | 6061 | 36930 | 367 |
1742103 | 1742103 | 2021-09-22 | Placer | California | 6061 | 36690 | 365 |
1738854 | 1738854 | 2021-09-21 | Placer | California | 6061 | 36612 | 364 |
1735605 | 1735605 | 2021-09-20 | Placer | California | 6061 | 36487 | 364 |
1732355 | 1732355 | 2021-09-19 | Placer | California | 6061 | 36390 | 364 |
1729105 | 1729105 | 2021-09-18 | Placer | California | 6061 | 36269 | 362 |
1725855 | 1725855 | 2021-09-17 | Placer | California | 6061 | 36118 | 358 |
1722606 | 1722606 | 2021-09-16 | Placer | California | 6061 | 35941 | 352 |
1719357 | 1719357 | 2021-09-15 | Placer | California | 6061 | 35668 | 350 |
1716109 | 1716109 | 2021-09-14 | Placer | California | 6061 | 35550 | 343 |
1712863 | 1712863 | 2021-09-13 | Placer | California | 6061 | 35453 | 343 |
1709616 | 1709616 | 2021-09-12 | Placer | California | 6061 | 35347 | 344 |
1706369 | 1706369 | 2021-09-11 | Placer | California | 6061 | 35197 | 343 |
1703121 | 1703121 | 2021-09-10 | Placer | California | 6061 | 34981 | 342 |
1699871 | 1699871 | 2021-09-09 | Placer | California | 6061 | 34785 | 337 |
1696622 | 1696622 | 2021-09-08 | Placer | California | 6061 | 34474 | 337 |
1693374 | 1693374 | 2021-09-07 | Placer | California | 6061 | 34359 | 337 |
1690125 | 1690125 | 2021-09-06 | Placer | California | 6061 | 34251 | 337 |
1686875 | 1686875 | 2021-09-05 | Placer | California | 6061 | 34138 | 337 |
1683625 | 1683625 | 2021-09-04 | Placer | California | 6061 | 34002 | 336 |
1680374 | 1680374 | 2021-09-03 | Placer | California | 6061 | 33831 | 336 |
1677126 | 1677126 | 2021-09-02 | Placer | California | 6061 | 33666 | 331 |
1673879 | 1673879 | 2021-09-01 | Placer | California | 6061 | 33301 | 326 |
1670631 | 1670631 | 2021-08-31 | Placer | California | 6061 | 32381 | 326 |
1667384 | 1667384 | 2021-08-30 | Placer | California | 6061 | 32230 | 319 |
1664137 | 1664137 | 2021-08-29 | Placer | California | 6061 | 31984 | 319 |
1660889 | 1660889 | 2021-08-28 | Placer | California | 6061 | 31713 | 320 |
1657641 | 1657641 | 2021-08-27 | Placer | California | 6061 | 31454 | 319 |
1654393 | 1654393 | 2021-08-26 | Placer | California | 6061 | 31296 | 319 |
1651146 | 1651146 | 2021-08-25 | Placer | California | 6061 | 30951 | 318 |
1647897 | 1647897 | 2021-08-24 | Placer | California | 6061 | 30873 | 316 |
1644649 | 1644649 | 2021-08-23 | Placer | California | 6061 | 30728 | 314 |
1641399 | 1641399 | 2021-08-22 | Placer | California | 6061 | 30622 | 314 |
1638149 | 1638149 | 2021-08-21 | Placer | California | 6061 | 30489 | 313 |
1634899 | 1634899 | 2021-08-20 | Placer | California | 6061 | 30286 | 313 |
1631650 | 1631650 | 2021-08-19 | Placer | California | 6061 | 30074 | 312 |
1628403 | 1628403 | 2021-08-18 | Placer | California | 6061 | 29667 | 312 |
1625156 | 1625156 | 2021-08-17 | Placer | California | 6061 | 29417 | 312 |
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);