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

598 rows where fips = 6055 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

  • 6055 · 598 ✖

county

Link rowid date ▲ county state fips cases deaths
1816828 1816828 2021-10-15 Napa California 6055 12809 100
1813580 1813580 2021-10-14 Napa California 6055 12798 100
1810331 1810331 2021-10-13 Napa California 6055 12769 97
1807082 1807082 2021-10-12 Napa California 6055 12752 96
1803831 1803831 2021-10-11 Napa California 6055 12739 96
1800582 1800582 2021-10-10 Napa California 6055 12684 96
1797333 1797333 2021-10-09 Napa California 6055 12684 96
1794084 1794084 2021-10-08 Napa California 6055 12684 96
1790836 1790836 2021-10-07 Napa California 6055 12650 96
1787587 1787587 2021-10-06 Napa California 6055 12623 96
1784338 1784338 2021-10-05 Napa California 6055 12596 96
1781089 1781089 2021-10-04 Napa California 6055 12579 96
1777839 1777839 2021-10-03 Napa California 6055 12523 96
1774589 1774589 2021-10-02 Napa California 6055 12523 96
1771339 1771339 2021-10-01 Napa California 6055 12523 96
1768090 1768090 2021-09-30 Napa California 6055 12506 96
1764841 1764841 2021-09-29 Napa California 6055 12475 96
1761592 1761592 2021-09-28 Napa California 6055 12441 95
1758344 1758344 2021-09-27 Napa California 6055 12427 95
1755096 1755096 2021-09-26 Napa California 6055 12353 95
1751848 1751848 2021-09-25 Napa California 6055 12353 95
1748599 1748599 2021-09-24 Napa California 6055 12353 95
1745349 1745349 2021-09-23 Napa California 6055 12335 95
1742100 1742100 2021-09-22 Napa California 6055 12317 95
1738851 1738851 2021-09-21 Napa California 6055 12288 95
1735602 1735602 2021-09-20 Napa California 6055 12269 95
1732352 1732352 2021-09-19 Napa California 6055 12247 95
1729102 1729102 2021-09-18 Napa California 6055 12232 95
1725852 1725852 2021-09-17 Napa California 6055 12194 95
1722603 1722603 2021-09-16 Napa California 6055 12161 95
1719354 1719354 2021-09-15 Napa California 6055 12148 91
1716106 1716106 2021-09-14 Napa California 6055 12117 91
1712860 1712860 2021-09-13 Napa California 6055 12089 91
1709613 1709613 2021-09-12 Napa California 6055 12069 91
1706366 1706366 2021-09-11 Napa California 6055 12026 90
1703118 1703118 2021-09-10 Napa California 6055 11956 90
1699868 1699868 2021-09-09 Napa California 6055 11920 90
1696619 1696619 2021-09-08 Napa California 6055 11883 90
1693371 1693371 2021-09-07 Napa California 6055 11861 90
1690122 1690122 2021-09-06 Napa California 6055 11839 90
1686872 1686872 2021-09-05 Napa California 6055 11829 90
1683622 1683622 2021-09-04 Napa California 6055 11802 89
1680371 1680371 2021-09-03 Napa California 6055 11753 88
1677123 1677123 2021-09-02 Napa California 6055 11722 88
1673876 1673876 2021-09-01 Napa California 6055 11687 88
1670628 1670628 2021-08-31 Napa California 6055 11648 87
1667381 1667381 2021-08-30 Napa California 6055 11621 87
1664134 1664134 2021-08-29 Napa California 6055 11581 88
1660886 1660886 2021-08-28 Napa California 6055 11529 87
1657638 1657638 2021-08-27 Napa California 6055 11463 87
1654390 1654390 2021-08-26 Napa California 6055 11417 87
1651143 1651143 2021-08-25 Napa California 6055 11366 85
1647894 1647894 2021-08-24 Napa California 6055 11324 85
1644646 1644646 2021-08-23 Napa California 6055 11298 85
1641396 1641396 2021-08-22 Napa California 6055 11278 85
1638146 1638146 2021-08-21 Napa California 6055 11219 83
1634896 1634896 2021-08-20 Napa California 6055 11171 83
1631647 1631647 2021-08-19 Napa California 6055 11127 83
1628400 1628400 2021-08-18 Napa California 6055 11061 83
1625153 1625153 2021-08-17 Napa California 6055 11000 83
1621906 1621906 2021-08-16 Napa California 6055 10973 83
1618659 1618659 2021-08-15 Napa California 6055 10932 83
1615411 1615411 2021-08-14 Napa California 6055 10884 83
1612162 1612162 2021-08-13 Napa California 6055 10834 83
1608914 1608914 2021-08-12 Napa California 6055 10786 83
1605665 1605665 2021-08-11 Napa California 6055 10757 83
1602416 1602416 2021-08-10 Napa California 6055 10733 83
1599167 1599167 2021-08-09 Napa California 6055 10722 83
1595918 1595918 2021-08-08 Napa California 6055 10712 83
1592669 1592669 2021-08-07 Napa California 6055 10645 83
1589420 1589420 2021-08-06 Napa California 6055 10645 83
1586171 1586171 2021-08-05 Napa California 6055 10598 82
1582921 1582921 2021-08-04 Napa California 6055 10574 82
1579671 1579671 2021-08-03 Napa California 6055 10537 82
1576423 1576423 2021-08-02 Napa California 6055 10520 82
1573175 1573175 2021-08-01 Napa California 6055 10448 82
1569927 1569927 2021-07-31 Napa California 6055 10448 82
1566679 1566679 2021-07-30 Napa California 6055 10448 82
1563431 1563431 2021-07-29 Napa California 6055 10423 82
1560183 1560183 2021-07-28 Napa California 6055 10401 82
1556936 1556936 2021-07-27 Napa California 6055 10379 82
1553689 1553689 2021-07-26 Napa California 6055 10363 82
1550442 1550442 2021-07-25 Napa California 6055 10277 81
1547195 1547195 2021-07-24 Napa California 6055 10277 81
1543948 1543948 2021-07-23 Napa California 6055 10277 81
1540700 1540700 2021-07-22 Napa California 6055 10256 81
1537453 1537453 2021-07-21 Napa California 6055 10220 81
1534205 1534205 2021-07-20 Napa California 6055 10209 81
1530958 1530958 2021-07-19 Napa California 6055 10203 81
1527711 1527711 2021-07-18 Napa California 6055 10158 81
1524464 1524464 2021-07-17 Napa California 6055 10158 81
1521216 1521216 2021-07-16 Napa California 6055 10158 81
1517968 1517968 2021-07-15 Napa California 6055 10150 81
1514721 1514721 2021-07-14 Napa California 6055 10147 81
1511475 1511475 2021-07-13 Napa California 6055 10133 81
1508228 1508228 2021-07-12 Napa California 6055 10129 81
1504982 1504982 2021-07-11 Napa California 6055 10106 81
1501736 1501736 2021-07-10 Napa California 6055 10106 81
1498490 1498490 2021-07-09 Napa California 6055 10106 81
1495243 1495243 2021-07-08 Napa California 6055 10107 81

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