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

604 rows where fips = 41067 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

  • 41067 · 604 ✖

county

Link rowid date ▲ county state fips cases deaths
1844869 1844869 2021-10-23 Washington Oregon 41067 38782 324
1841619 1841619 2021-10-22 Washington Oregon 41067 38782 324
1838370 1838370 2021-10-21 Washington Oregon 41067 38673 322
1835121 1835121 2021-10-20 Washington Oregon 41067 38530 317
1831872 1831872 2021-10-19 Washington Oregon 41067 38425 317
1828623 1828623 2021-10-18 Washington Oregon 41067 38321 316
1825374 1825374 2021-10-17 Washington Oregon 41067 37988 313
1822125 1822125 2021-10-16 Washington Oregon 41067 37988 313
1818876 1818876 2021-10-15 Washington Oregon 41067 37988 313
1815627 1815627 2021-10-14 Washington Oregon 41067 37902 312
1812379 1812379 2021-10-13 Washington Oregon 41067 37818 312
1809130 1809130 2021-10-12 Washington Oregon 41067 37724 310
1805880 1805880 2021-10-11 Washington Oregon 41067 37647 304
1802630 1802630 2021-10-10 Washington Oregon 41067 37330 301
1799381 1799381 2021-10-09 Washington Oregon 41067 37330 301
1796132 1796132 2021-10-08 Washington Oregon 41067 37330 301
1792883 1792883 2021-10-07 Washington Oregon 41067 37204 301
1789634 1789634 2021-10-06 Washington Oregon 41067 37088 299
1786386 1786386 2021-10-05 Washington Oregon 41067 36985 297
1783137 1783137 2021-10-04 Washington Oregon 41067 36861 287
1779888 1779888 2021-10-03 Washington Oregon 41067 36545 285
1776638 1776638 2021-10-02 Washington Oregon 41067 36545 285
1773388 1773388 2021-10-01 Washington Oregon 41067 36545 285
1770138 1770138 2021-09-30 Washington Oregon 41067 36418 285
1766889 1766889 2021-09-29 Washington Oregon 41067 36261 281
1763640 1763640 2021-09-28 Washington Oregon 41067 36083 281
1760391 1760391 2021-09-27 Washington Oregon 41067 35987 280
1757143 1757143 2021-09-26 Washington Oregon 41067 35615 280
1753895 1753895 2021-09-25 Washington Oregon 41067 35615 280
1750647 1750647 2021-09-24 Washington Oregon 41067 35615 280
1747398 1747398 2021-09-23 Washington Oregon 41067 35457 278
1744148 1744148 2021-09-22 Washington Oregon 41067 35305 277
1740899 1740899 2021-09-21 Washington Oregon 41067 35086 277
1737650 1737650 2021-09-20 Washington Oregon 41067 34995 276
1734400 1734400 2021-09-19 Washington Oregon 41067 34683 272
1731150 1731150 2021-09-18 Washington Oregon 41067 34683 272
1727900 1727900 2021-09-17 Washington Oregon 41067 34683 272
1724651 1724651 2021-09-16 Washington Oregon 41067 34509 272
1721402 1721402 2021-09-15 Washington Oregon 41067 34277 272
1718154 1718154 2021-09-14 Washington Oregon 41067 34129 272
1714906 1714906 2021-09-13 Washington Oregon 41067 33973 271
1711660 1711660 2021-09-12 Washington Oregon 41067 33485 270
1708413 1708413 2021-09-11 Washington Oregon 41067 33485 270
1705166 1705166 2021-09-10 Washington Oregon 41067 33485 270
1701916 1701916 2021-09-09 Washington Oregon 41067 33297 270
1698667 1698667 2021-09-08 Washington Oregon 41067 33122 269
1695419 1695419 2021-09-07 Washington Oregon 41067 32991 267
1692171 1692171 2021-09-06 Washington Oregon 41067 32447 267
1688922 1688922 2021-09-05 Washington Oregon 41067 32447 267
1685672 1685672 2021-09-04 Washington Oregon 41067 32447 267
1682421 1682421 2021-09-03 Washington Oregon 41067 32447 267
1679171 1679171 2021-09-02 Washington Oregon 41067 32240 266
1675923 1675923 2021-09-01 Washington Oregon 41067 32007 266
1672676 1672676 2021-08-31 Washington Oregon 41067 31833 266
1669428 1669428 2021-08-30 Washington Oregon 41067 31693 266
1666181 1666181 2021-08-29 Washington Oregon 41067 31249 266
1662933 1662933 2021-08-28 Washington Oregon 41067 31249 266
1659685 1659685 2021-08-27 Washington Oregon 41067 31249 266
1656436 1656436 2021-08-26 Washington Oregon 41067 31025 265
1653189 1653189 2021-08-25 Washington Oregon 41067 30871 264
1649942 1649942 2021-08-24 Washington Oregon 41067 30710 263
1646693 1646693 2021-08-23 Washington Oregon 41067 30552 262
1643444 1643444 2021-08-22 Washington Oregon 41067 30158 262
1640194 1640194 2021-08-21 Washington Oregon 41067 30158 262
1636944 1636944 2021-08-20 Washington Oregon 41067 30158 262
1633694 1633694 2021-08-19 Washington Oregon 41067 29989 263
1630447 1630447 2021-08-18 Washington Oregon 41067 29786 263
1627200 1627200 2021-08-17 Washington Oregon 41067 29682 263
1623953 1623953 2021-08-16 Washington Oregon 41067 29262 261
1620706 1620706 2021-08-15 Washington Oregon 41067 29093 259
1617458 1617458 2021-08-14 Washington Oregon 41067 29093 259
1614210 1614210 2021-08-13 Washington Oregon 41067 29093 259
1610961 1610961 2021-08-12 Washington Oregon 41067 28976 259
1607713 1607713 2021-08-11 Washington Oregon 41067 28790 259
1604464 1604464 2021-08-10 Washington Oregon 41067 28593 259
1601215 1601215 2021-08-09 Washington Oregon 41067 28459 259
1597967 1597967 2021-08-08 Washington Oregon 41067 28353 259
1594718 1594718 2021-08-07 Washington Oregon 41067 28353 259
1591469 1591469 2021-08-06 Washington Oregon 41067 28353 259
1588220 1588220 2021-08-05 Washington Oregon 41067 28275 259
1584970 1584970 2021-08-04 Washington Oregon 41067 28176 259
1581720 1581720 2021-08-03 Washington Oregon 41067 28086 259
1578471 1578471 2021-08-02 Washington Oregon 41067 27925 258
1575223 1575223 2021-08-01 Washington Oregon 41067 27838 258
1571975 1571975 2021-07-31 Washington Oregon 41067 27838 258
1568727 1568727 2021-07-30 Washington Oregon 41067 27838 258
1565479 1565479 2021-07-29 Washington Oregon 41067 27764 258
1562231 1562231 2021-07-28 Washington Oregon 41067 27703 258
1558983 1558983 2021-07-27 Washington Oregon 41067 27645 257
1555736 1555736 2021-07-26 Washington Oregon 41067 27550 257
1552489 1552489 2021-07-25 Washington Oregon 41067 27471 257
1549242 1549242 2021-07-24 Washington Oregon 41067 27471 257
1545995 1545995 2021-07-23 Washington Oregon 41067 27471 257
1542748 1542748 2021-07-22 Washington Oregon 41067 27412 257
1539500 1539500 2021-07-21 Washington Oregon 41067 27369 257
1536253 1536253 2021-07-20 Washington Oregon 41067 27330 257
1533005 1533005 2021-07-19 Washington Oregon 41067 27266 257
1529758 1529758 2021-07-18 Washington Oregon 41067 27209 257
1526511 1526511 2021-07-17 Washington Oregon 41067 27209 257
1523264 1523264 2021-07-16 Washington Oregon 41067 27209 257

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