ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
814 rows where fips = 6023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1621890 | 1621890 | 2021-08-16 | Humboldt | California | 6023 | 6200 | 59 |
1618643 | 1618643 | 2021-08-15 | Humboldt | California | 6023 | 6174 | 58 |
1615395 | 1615395 | 2021-08-14 | Humboldt | California | 6023 | 6058 | 58 |
1612146 | 1612146 | 2021-08-13 | Humboldt | California | 6023 | 6021 | 58 |
1608898 | 1608898 | 2021-08-12 | Humboldt | California | 6023 | 5941 | 58 |
1605649 | 1605649 | 2021-08-11 | Humboldt | California | 6023 | 5894 | 57 |
1602400 | 1602400 | 2021-08-10 | Humboldt | California | 6023 | 5808 | 57 |
1599151 | 1599151 | 2021-08-09 | Humboldt | California | 6023 | 5747 | 56 |
1595902 | 1595902 | 2021-08-08 | Humboldt | California | 6023 | 5686 | 56 |
1592653 | 1592653 | 2021-08-07 | Humboldt | California | 6023 | 5504 | 56 |
1589404 | 1589404 | 2021-08-06 | Humboldt | California | 6023 | 5504 | 56 |
1586155 | 1586155 | 2021-08-05 | Humboldt | California | 6023 | 5447 | 55 |
1582905 | 1582905 | 2021-08-04 | Humboldt | California | 6023 | 5359 | 54 |
1579655 | 1579655 | 2021-08-03 | Humboldt | California | 6023 | 5321 | 53 |
1576407 | 1576407 | 2021-08-02 | Humboldt | California | 6023 | 5278 | 53 |
1573159 | 1573159 | 2021-08-01 | Humboldt | California | 6023 | 5138 | 53 |
1569911 | 1569911 | 2021-07-31 | Humboldt | California | 6023 | 5138 | 53 |
1566663 | 1566663 | 2021-07-30 | Humboldt | California | 6023 | 5138 | 53 |
1563415 | 1563415 | 2021-07-29 | Humboldt | California | 6023 | 5106 | 53 |
1560167 | 1560167 | 2021-07-28 | Humboldt | California | 6023 | 5073 | 53 |
1556920 | 1556920 | 2021-07-27 | Humboldt | California | 6023 | 5054 | 53 |
1553673 | 1553673 | 2021-07-26 | Humboldt | California | 6023 | 5040 | 53 |
1550426 | 1550426 | 2021-07-25 | Humboldt | California | 6023 | 4928 | 53 |
1547179 | 1547179 | 2021-07-24 | Humboldt | California | 6023 | 4928 | 53 |
1543932 | 1543932 | 2021-07-23 | Humboldt | California | 6023 | 4928 | 53 |
1540684 | 1540684 | 2021-07-22 | Humboldt | California | 6023 | 4911 | 53 |
1537437 | 1537437 | 2021-07-21 | Humboldt | California | 6023 | 4872 | 53 |
1534189 | 1534189 | 2021-07-20 | Humboldt | California | 6023 | 4856 | 53 |
1530942 | 1530942 | 2021-07-19 | Humboldt | California | 6023 | 4851 | 53 |
1527695 | 1527695 | 2021-07-18 | Humboldt | California | 6023 | 4791 | 53 |
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);