ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
814 rows where fips = 6023 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1946794 | 1946794 | 2021-11-24 | Humboldt | California | 6023 | 10043 | 117 |
1943543 | 1943543 | 2021-11-23 | Humboldt | California | 6023 | 10033 | 117 |
1940293 | 1940293 | 2021-11-22 | Humboldt | California | 6023 | 10022 | 117 |
1937043 | 1937043 | 2021-11-21 | Humboldt | California | 6023 | 9946 | 117 |
1933793 | 1933793 | 2021-11-20 | Humboldt | California | 6023 | 9946 | 117 |
1930541 | 1930541 | 2021-11-19 | Humboldt | California | 6023 | 9946 | 117 |
1927291 | 1927291 | 2021-11-18 | Humboldt | California | 6023 | 9914 | 117 |
1924041 | 1924041 | 2021-11-17 | Humboldt | California | 6023 | 9873 | 117 |
1920792 | 1920792 | 2021-11-16 | Humboldt | California | 6023 | 9851 | 117 |
1917542 | 1917542 | 2021-11-15 | Humboldt | California | 6023 | 9836 | 117 |
1914292 | 1914292 | 2021-11-14 | Humboldt | California | 6023 | 9798 | 117 |
1911042 | 1911042 | 2021-11-13 | Humboldt | California | 6023 | 9798 | 117 |
1907793 | 1907793 | 2021-11-12 | Humboldt | California | 6023 | 9746 | 117 |
1904544 | 1904544 | 2021-11-11 | Humboldt | California | 6023 | 9746 | 117 |
1901294 | 1901294 | 2021-11-10 | Humboldt | California | 6023 | 9698 | 117 |
1898044 | 1898044 | 2021-11-09 | Humboldt | California | 6023 | 9681 | 117 |
1894794 | 1894794 | 2021-11-08 | Humboldt | California | 6023 | 9660 | 117 |
1891544 | 1891544 | 2021-11-07 | Humboldt | California | 6023 | 9558 | 116 |
1888294 | 1888294 | 2021-11-06 | Humboldt | California | 6023 | 9558 | 116 |
1885044 | 1885044 | 2021-11-05 | Humboldt | California | 6023 | 9558 | 116 |
1881795 | 1881795 | 2021-11-04 | Humboldt | California | 6023 | 9535 | 116 |
1878546 | 1878546 | 2021-11-03 | Humboldt | California | 6023 | 9490 | 116 |
1875297 | 1875297 | 2021-11-02 | Humboldt | California | 6023 | 9482 | 116 |
1872048 | 1872048 | 2021-11-01 | Humboldt | California | 6023 | 9472 | 116 |
1868799 | 1868799 | 2021-10-31 | Humboldt | California | 6023 | 9424 | 112 |
1865550 | 1865550 | 2021-10-30 | Humboldt | California | 6023 | 9424 | 112 |
1862301 | 1862301 | 2021-10-29 | Humboldt | California | 6023 | 9424 | 112 |
1859052 | 1859052 | 2021-10-28 | Humboldt | California | 6023 | 9404 | 110 |
1855803 | 1855803 | 2021-10-27 | Humboldt | California | 6023 | 9346 | 109 |
1852554 | 1852554 | 2021-10-26 | Humboldt | California | 6023 | 9341 | 109 |
1849305 | 1849305 | 2021-10-25 | Humboldt | California | 6023 | 9269 | 109 |
1846055 | 1846055 | 2021-10-24 | Humboldt | California | 6023 | 9269 | 109 |
1842805 | 1842805 | 2021-10-23 | Humboldt | California | 6023 | 9269 | 109 |
1839555 | 1839555 | 2021-10-22 | Humboldt | California | 6023 | 9269 | 109 |
1836306 | 1836306 | 2021-10-21 | Humboldt | California | 6023 | 9243 | 108 |
1833057 | 1833057 | 2021-10-20 | Humboldt | California | 6023 | 9195 | 108 |
1829808 | 1829808 | 2021-10-19 | Humboldt | California | 6023 | 9180 | 107 |
1826559 | 1826559 | 2021-10-18 | Humboldt | California | 6023 | 9171 | 108 |
1823310 | 1823310 | 2021-10-17 | Humboldt | California | 6023 | 9102 | 108 |
1820061 | 1820061 | 2021-10-16 | Humboldt | California | 6023 | 9102 | 108 |
1816812 | 1816812 | 2021-10-15 | Humboldt | California | 6023 | 9102 | 108 |
1813564 | 1813564 | 2021-10-14 | Humboldt | California | 6023 | 9085 | 108 |
1810315 | 1810315 | 2021-10-13 | Humboldt | California | 6023 | 9042 | 108 |
1807066 | 1807066 | 2021-10-12 | Humboldt | California | 6023 | 9026 | 106 |
1803815 | 1803815 | 2021-10-11 | Humboldt | California | 6023 | 9009 | 106 |
1800566 | 1800566 | 2021-10-10 | Humboldt | California | 6023 | 8903 | 106 |
1797317 | 1797317 | 2021-10-09 | Humboldt | California | 6023 | 8903 | 106 |
1794068 | 1794068 | 2021-10-08 | Humboldt | California | 6023 | 8903 | 106 |
1790820 | 1790820 | 2021-10-07 | Humboldt | California | 6023 | 8871 | 102 |
1787571 | 1787571 | 2021-10-06 | Humboldt | California | 6023 | 8840 | 101 |
1784322 | 1784322 | 2021-10-05 | Humboldt | California | 6023 | 8797 | 98 |
1781073 | 1781073 | 2021-10-04 | Humboldt | California | 6023 | 8794 | 98 |
1777823 | 1777823 | 2021-10-03 | Humboldt | California | 6023 | 8686 | 98 |
1774573 | 1774573 | 2021-10-02 | Humboldt | California | 6023 | 8686 | 98 |
1771323 | 1771323 | 2021-10-01 | Humboldt | California | 6023 | 8686 | 98 |
1768074 | 1768074 | 2021-09-30 | Humboldt | California | 6023 | 8645 | 98 |
1764825 | 1764825 | 2021-09-29 | Humboldt | California | 6023 | 8575 | 97 |
1761576 | 1761576 | 2021-09-28 | Humboldt | California | 6023 | 8534 | 97 |
1758328 | 1758328 | 2021-09-27 | Humboldt | California | 6023 | 8514 | 94 |
1755080 | 1755080 | 2021-09-26 | Humboldt | California | 6023 | 8430 | 93 |
1751832 | 1751832 | 2021-09-25 | Humboldt | California | 6023 | 8430 | 93 |
1748583 | 1748583 | 2021-09-24 | Humboldt | California | 6023 | 8430 | 93 |
1745333 | 1745333 | 2021-09-23 | Humboldt | California | 6023 | 8414 | 93 |
1742084 | 1742084 | 2021-09-22 | Humboldt | California | 6023 | 8336 | 89 |
1738835 | 1738835 | 2021-09-21 | Humboldt | California | 6023 | 8319 | 88 |
1735586 | 1735586 | 2021-09-20 | Humboldt | California | 6023 | 8295 | 87 |
1732336 | 1732336 | 2021-09-19 | Humboldt | California | 6023 | 8262 | 84 |
1729086 | 1729086 | 2021-09-18 | Humboldt | California | 6023 | 8231 | 84 |
1725836 | 1725836 | 2021-09-17 | Humboldt | California | 6023 | 8190 | 84 |
1722587 | 1722587 | 2021-09-16 | Humboldt | California | 6023 | 8135 | 83 |
1719338 | 1719338 | 2021-09-15 | Humboldt | California | 6023 | 8027 | 82 |
1716090 | 1716090 | 2021-09-14 | Humboldt | California | 6023 | 7969 | 82 |
1712844 | 1712844 | 2021-09-13 | Humboldt | California | 6023 | 7946 | 82 |
1709597 | 1709597 | 2021-09-12 | Humboldt | California | 6023 | 7925 | 81 |
1706350 | 1706350 | 2021-09-11 | Humboldt | California | 6023 | 7853 | 81 |
1703102 | 1703102 | 2021-09-10 | Humboldt | California | 6023 | 7781 | 81 |
1699852 | 1699852 | 2021-09-09 | Humboldt | California | 6023 | 7748 | 80 |
1696603 | 1696603 | 2021-09-08 | Humboldt | California | 6023 | 7725 | 80 |
1693355 | 1693355 | 2021-09-07 | Humboldt | California | 6023 | 7648 | 78 |
1690106 | 1690106 | 2021-09-06 | Humboldt | California | 6023 | 7640 | 75 |
1686856 | 1686856 | 2021-09-05 | Humboldt | California | 6023 | 7626 | 75 |
1683606 | 1683606 | 2021-09-04 | Humboldt | California | 6023 | 7522 | 75 |
1680355 | 1680355 | 2021-09-03 | Humboldt | California | 6023 | 7469 | 75 |
1677107 | 1677107 | 2021-09-02 | Humboldt | California | 6023 | 7418 | 75 |
1673860 | 1673860 | 2021-09-01 | Humboldt | California | 6023 | 7297 | 75 |
1670612 | 1670612 | 2021-08-31 | Humboldt | California | 6023 | 7197 | 75 |
1667365 | 1667365 | 2021-08-30 | Humboldt | California | 6023 | 7189 | 76 |
1664118 | 1664118 | 2021-08-29 | Humboldt | California | 6023 | 7154 | 71 |
1660870 | 1660870 | 2021-08-28 | Humboldt | California | 6023 | 7049 | 71 |
1657622 | 1657622 | 2021-08-27 | Humboldt | California | 6023 | 6962 | 71 |
1654374 | 1654374 | 2021-08-26 | Humboldt | California | 6023 | 6920 | 65 |
1651127 | 1651127 | 2021-08-25 | Humboldt | California | 6023 | 6783 | 65 |
1647878 | 1647878 | 2021-08-24 | Humboldt | California | 6023 | 6696 | 62 |
1644630 | 1644630 | 2021-08-23 | Humboldt | California | 6023 | 6681 | 62 |
1641380 | 1641380 | 2021-08-22 | Humboldt | California | 6023 | 6644 | 61 |
1638130 | 1638130 | 2021-08-21 | Humboldt | California | 6023 | 6547 | 61 |
1634880 | 1634880 | 2021-08-20 | Humboldt | California | 6023 | 6444 | 61 |
1631631 | 1631631 | 2021-08-19 | Humboldt | California | 6023 | 6393 | 59 |
1628384 | 1628384 | 2021-08-18 | Humboldt | California | 6023 | 6331 | 59 |
1625137 | 1625137 | 2021-08-17 | Humboldt | California | 6023 | 6252 | 59 |
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);