ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
832 rows where fips = 6075 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1946820 | 1946820 | 2021-11-24 | San Francisco | California | 6075 | 56617 | 669 |
1943569 | 1943569 | 2021-11-23 | San Francisco | California | 6075 | 56565 | 669 |
1940319 | 1940319 | 2021-11-22 | San Francisco | California | 6075 | 56528 | 669 |
1937069 | 1937069 | 2021-11-21 | San Francisco | California | 6075 | 56312 | 669 |
1933819 | 1933819 | 2021-11-20 | San Francisco | California | 6075 | 56312 | 669 |
1930567 | 1930567 | 2021-11-19 | San Francisco | California | 6075 | 56312 | 669 |
1927317 | 1927317 | 2021-11-18 | San Francisco | California | 6075 | 56256 | 667 |
1924067 | 1924067 | 2021-11-17 | San Francisco | California | 6075 | 56179 | 667 |
1920818 | 1920818 | 2021-11-16 | San Francisco | California | 6075 | 56138 | 667 |
1917568 | 1917568 | 2021-11-15 | San Francisco | California | 6075 | 56102 | 667 |
1914318 | 1914318 | 2021-11-14 | San Francisco | California | 6075 | 55959 | 667 |
1911068 | 1911068 | 2021-11-13 | San Francisco | California | 6075 | 55959 | 667 |
1907819 | 1907819 | 2021-11-12 | San Francisco | California | 6075 | 55827 | 666 |
1904570 | 1904570 | 2021-11-11 | San Francisco | California | 6075 | 55827 | 666 |
1901320 | 1901320 | 2021-11-10 | San Francisco | California | 6075 | 55706 | 666 |
1898070 | 1898070 | 2021-11-09 | San Francisco | California | 6075 | 55652 | 666 |
1894820 | 1894820 | 2021-11-08 | San Francisco | California | 6075 | 55578 | 666 |
1891570 | 1891570 | 2021-11-07 | San Francisco | California | 6075 | 55266 | 666 |
1888320 | 1888320 | 2021-11-06 | San Francisco | California | 6075 | 55266 | 666 |
1885070 | 1885070 | 2021-11-05 | San Francisco | California | 6075 | 55266 | 666 |
1881821 | 1881821 | 2021-11-04 | San Francisco | California | 6075 | 55203 | 663 |
1878572 | 1878572 | 2021-11-03 | San Francisco | California | 6075 | 55104 | 663 |
1875323 | 1875323 | 2021-11-02 | San Francisco | California | 6075 | 55072 | 661 |
1872074 | 1872074 | 2021-11-01 | San Francisco | California | 6075 | 55024 | 661 |
1868825 | 1868825 | 2021-10-31 | San Francisco | California | 6075 | 54815 | 661 |
1865576 | 1865576 | 2021-10-30 | San Francisco | California | 6075 | 54815 | 661 |
1862327 | 1862327 | 2021-10-29 | San Francisco | California | 6075 | 54815 | 661 |
1859078 | 1859078 | 2021-10-28 | San Francisco | California | 6075 | 54762 | 655 |
1855829 | 1855829 | 2021-10-27 | San Francisco | California | 6075 | 54686 | 655 |
1852580 | 1852580 | 2021-10-26 | San Francisco | California | 6075 | 54664 | 649 |
1849331 | 1849331 | 2021-10-25 | San Francisco | California | 6075 | 54443 | 649 |
1846081 | 1846081 | 2021-10-24 | San Francisco | California | 6075 | 54443 | 649 |
1842831 | 1842831 | 2021-10-23 | San Francisco | California | 6075 | 54443 | 649 |
1839581 | 1839581 | 2021-10-22 | San Francisco | California | 6075 | 54443 | 649 |
1836332 | 1836332 | 2021-10-21 | San Francisco | California | 6075 | 54378 | 646 |
1833083 | 1833083 | 2021-10-20 | San Francisco | California | 6075 | 54302 | 645 |
1829834 | 1829834 | 2021-10-19 | San Francisco | California | 6075 | 54269 | 644 |
1826585 | 1826585 | 2021-10-18 | San Francisco | California | 6075 | 54223 | 644 |
1823336 | 1823336 | 2021-10-17 | San Francisco | California | 6075 | 54034 | 645 |
1820087 | 1820087 | 2021-10-16 | San Francisco | California | 6075 | 54034 | 645 |
1816838 | 1816838 | 2021-10-15 | San Francisco | California | 6075 | 54034 | 645 |
1813590 | 1813590 | 2021-10-14 | San Francisco | California | 6075 | 53977 | 644 |
1810341 | 1810341 | 2021-10-13 | San Francisco | California | 6075 | 53860 | 643 |
1807092 | 1807092 | 2021-10-12 | San Francisco | California | 6075 | 53834 | 643 |
1803841 | 1803841 | 2021-10-11 | San Francisco | California | 6075 | 53775 | 643 |
1800592 | 1800592 | 2021-10-10 | San Francisco | California | 6075 | 53519 | 643 |
1797343 | 1797343 | 2021-10-09 | San Francisco | California | 6075 | 53519 | 643 |
1794094 | 1794094 | 2021-10-08 | San Francisco | California | 6075 | 53519 | 643 |
1790846 | 1790846 | 2021-10-07 | San Francisco | California | 6075 | 53453 | 641 |
1787597 | 1787597 | 2021-10-06 | San Francisco | California | 6075 | 53355 | 641 |
1784348 | 1784348 | 2021-10-05 | San Francisco | California | 6075 | 53327 | 638 |
1781099 | 1781099 | 2021-10-04 | San Francisco | California | 6075 | 53262 | 638 |
1777849 | 1777849 | 2021-10-03 | San Francisco | California | 6075 | 52922 | 634 |
1774599 | 1774599 | 2021-10-02 | San Francisco | California | 6075 | 52922 | 634 |
1771349 | 1771349 | 2021-10-01 | San Francisco | California | 6075 | 52922 | 634 |
1768100 | 1768100 | 2021-09-30 | San Francisco | California | 6075 | 52815 | 629 |
1764851 | 1764851 | 2021-09-29 | San Francisco | California | 6075 | 52725 | 627 |
1761602 | 1761602 | 2021-09-28 | San Francisco | California | 6075 | 52648 | 622 |
1758354 | 1758354 | 2021-09-27 | San Francisco | California | 6075 | 52583 | 622 |
1755106 | 1755106 | 2021-09-26 | San Francisco | California | 6075 | 52331 | 615 |
1751858 | 1751858 | 2021-09-25 | San Francisco | California | 6075 | 52331 | 615 |
1748609 | 1748609 | 2021-09-24 | San Francisco | California | 6075 | 52331 | 615 |
1745359 | 1745359 | 2021-09-23 | San Francisco | California | 6075 | 52225 | 610 |
1742110 | 1742110 | 2021-09-22 | San Francisco | California | 6075 | 52105 | 609 |
1738861 | 1738861 | 2021-09-21 | San Francisco | California | 6075 | 52011 | 605 |
1735612 | 1735612 | 2021-09-20 | San Francisco | California | 6075 | 51910 | 605 |
1732362 | 1732362 | 2021-09-19 | San Francisco | California | 6075 | 51811 | 605 |
1729112 | 1729112 | 2021-09-18 | San Francisco | California | 6075 | 51701 | 605 |
1725862 | 1725862 | 2021-09-17 | San Francisco | California | 6075 | 51585 | 605 |
1722613 | 1722613 | 2021-09-16 | San Francisco | California | 6075 | 51451 | 605 |
1719364 | 1719364 | 2021-09-15 | San Francisco | California | 6075 | 51380 | 603 |
1716116 | 1716116 | 2021-09-14 | San Francisco | California | 6075 | 51296 | 603 |
1712870 | 1712870 | 2021-09-13 | San Francisco | California | 6075 | 51201 | 603 |
1709623 | 1709623 | 2021-09-12 | San Francisco | California | 6075 | 51042 | 603 |
1706376 | 1706376 | 2021-09-11 | San Francisco | California | 6075 | 50900 | 602 |
1703128 | 1703128 | 2021-09-10 | San Francisco | California | 6075 | 50786 | 597 |
1699878 | 1699878 | 2021-09-09 | San Francisco | California | 6075 | 50645 | 589 |
1696629 | 1696629 | 2021-09-08 | San Francisco | California | 6075 | 50443 | 589 |
1693381 | 1693381 | 2021-09-07 | San Francisco | California | 6075 | 50388 | 589 |
1690132 | 1690132 | 2021-09-06 | San Francisco | California | 6075 | 50303 | 589 |
1686882 | 1686882 | 2021-09-05 | San Francisco | California | 6075 | 50205 | 589 |
1683632 | 1683632 | 2021-09-04 | San Francisco | California | 6075 | 50090 | 589 |
1680381 | 1680381 | 2021-09-03 | San Francisco | California | 6075 | 49942 | 587 |
1677133 | 1677133 | 2021-09-02 | San Francisco | California | 6075 | 49806 | 584 |
1673886 | 1673886 | 2021-09-01 | San Francisco | California | 6075 | 49636 | 581 |
1670638 | 1670638 | 2021-08-31 | San Francisco | California | 6075 | 49162 | 581 |
1667391 | 1667391 | 2021-08-30 | San Francisco | California | 6075 | 49081 | 581 |
1664144 | 1664144 | 2021-08-29 | San Francisco | California | 6075 | 48850 | 581 |
1660896 | 1660896 | 2021-08-28 | San Francisco | California | 6075 | 48652 | 581 |
1657648 | 1657648 | 2021-08-27 | San Francisco | California | 6075 | 48484 | 581 |
1654400 | 1654400 | 2021-08-26 | San Francisco | California | 6075 | 48303 | 578 |
1651153 | 1651153 | 2021-08-25 | San Francisco | California | 6075 | 48120 | 574 |
1647904 | 1647904 | 2021-08-24 | San Francisco | California | 6075 | 48055 | 573 |
1644656 | 1644656 | 2021-08-23 | San Francisco | California | 6075 | 47941 | 573 |
1641406 | 1641406 | 2021-08-22 | San Francisco | California | 6075 | 47747 | 573 |
1638156 | 1638156 | 2021-08-21 | San Francisco | California | 6075 | 47542 | 573 |
1634906 | 1634906 | 2021-08-20 | San Francisco | California | 6075 | 47330 | 571 |
1631657 | 1631657 | 2021-08-19 | San Francisco | California | 6075 | 47067 | 568 |
1628410 | 1628410 | 2021-08-18 | San Francisco | California | 6075 | 46581 | 567 |
1625163 | 1625163 | 2021-08-17 | San Francisco | California | 6075 | 46442 | 567 |
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);