ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
803 rows where fips = 6061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1621909 | 1621909 | 2021-08-16 | Placer | California | 6061 | 29253 | 308 |
1618662 | 1618662 | 2021-08-15 | Placer | California | 6061 | 29148 | 308 |
1615414 | 1615414 | 2021-08-14 | Placer | California | 6061 | 29020 | 308 |
1612165 | 1612165 | 2021-08-13 | Placer | California | 6061 | 28889 | 308 |
1608917 | 1608917 | 2021-08-12 | Placer | California | 6061 | 28720 | 308 |
1605668 | 1605668 | 2021-08-11 | Placer | California | 6061 | 28594 | 307 |
1602419 | 1602419 | 2021-08-10 | Placer | California | 6061 | 28490 | 307 |
1599170 | 1599170 | 2021-08-09 | Placer | California | 6061 | 28365 | 307 |
1595921 | 1595921 | 2021-08-08 | Placer | California | 6061 | 28277 | 307 |
1592672 | 1592672 | 2021-08-07 | Placer | California | 6061 | 27998 | 307 |
1589423 | 1589423 | 2021-08-06 | Placer | California | 6061 | 27998 | 307 |
1586174 | 1586174 | 2021-08-05 | Placer | California | 6061 | 27721 | 307 |
1582924 | 1582924 | 2021-08-04 | Placer | California | 6061 | 27540 | 307 |
1579674 | 1579674 | 2021-08-03 | Placer | California | 6061 | 27432 | 307 |
1576426 | 1576426 | 2021-08-02 | Placer | California | 6061 | 27380 | 307 |
1573178 | 1573178 | 2021-08-01 | Placer | California | 6061 | 27020 | 307 |
1569930 | 1569930 | 2021-07-31 | Placer | California | 6061 | 27020 | 307 |
1566682 | 1566682 | 2021-07-30 | Placer | California | 6061 | 27020 | 307 |
1563434 | 1563434 | 2021-07-29 | Placer | California | 6061 | 26894 | 307 |
1560186 | 1560186 | 2021-07-28 | Placer | California | 6061 | 26723 | 307 |
1556939 | 1556939 | 2021-07-27 | Placer | California | 6061 | 26649 | 307 |
1553692 | 1553692 | 2021-07-26 | Placer | California | 6061 | 26562 | 304 |
1550445 | 1550445 | 2021-07-25 | Placer | California | 6061 | 26337 | 304 |
1547198 | 1547198 | 2021-07-24 | Placer | California | 6061 | 26337 | 304 |
1543951 | 1543951 | 2021-07-23 | Placer | California | 6061 | 26337 | 304 |
1540703 | 1540703 | 2021-07-22 | Placer | California | 6061 | 26248 | 304 |
1537456 | 1537456 | 2021-07-21 | Placer | California | 6061 | 26066 | 304 |
1534208 | 1534208 | 2021-07-20 | Placer | California | 6061 | 26017 | 304 |
1530961 | 1530961 | 2021-07-19 | Placer | California | 6061 | 25971 | 304 |
1527714 | 1527714 | 2021-07-18 | Placer | California | 6061 | 25827 | 304 |
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);