ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

612 rows where fips = 6023 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

  • 6023 · 612 ✖

county

Link rowid date ▲ county state fips cases deaths
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
1524448 1524448 2021-07-17 Humboldt California 6023 4791 53
1521200 1521200 2021-07-16 Humboldt California 6023 4791 53

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);