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

634 rows where fips = 53061 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

  • 53061 · 634 ✖

county

Link rowid date ▲ county state fips cases deaths
1819704 1819704 2021-10-15 Snohomish Washington 53061 62200 731
1816455 1816455 2021-10-14 Snohomish Washington 53061 61965 727
1813207 1813207 2021-10-13 Snohomish Washington 53061 61717 724
1809958 1809958 2021-10-12 Snohomish Washington 53061 61503 716
1806709 1806709 2021-10-11 Snohomish Washington 53061 61336 716
1803458 1803458 2021-10-10 Snohomish Washington 53061 60795 714
1800209 1800209 2021-10-09 Snohomish Washington 53061 60795 714
1796960 1796960 2021-10-08 Snohomish Washington 53061 60795 714
1793711 1793711 2021-10-07 Snohomish Washington 53061 60624 712
1790462 1790462 2021-10-06 Snohomish Washington 53061 60397 710
1787214 1787214 2021-10-05 Snohomish Washington 53061 60219 705
1783965 1783965 2021-10-04 Snohomish Washington 53061 59991 703
1780716 1780716 2021-10-03 Snohomish Washington 53061 59337 700
1777466 1777466 2021-10-02 Snohomish Washington 53061 59337 700
1774216 1774216 2021-10-01 Snohomish Washington 53061 59337 700
1770966 1770966 2021-09-30 Snohomish Washington 53061 59051 698
1767717 1767717 2021-09-29 Snohomish Washington 53061 58768 697
1764468 1764468 2021-09-28 Snohomish Washington 53061 58517 693
1761219 1761219 2021-09-27 Snohomish Washington 53061 58286 690
1757971 1757971 2021-09-26 Snohomish Washington 53061 57581 688
1754723 1754723 2021-09-25 Snohomish Washington 53061 57581 688
1751475 1751475 2021-09-24 Snohomish Washington 53061 57581 688
1748226 1748226 2021-09-23 Snohomish Washington 53061 57319 688
1744976 1744976 2021-09-22 Snohomish Washington 53061 56969 685
1741727 1741727 2021-09-21 Snohomish Washington 53061 56765 681
1738478 1738478 2021-09-20 Snohomish Washington 53061 56488 680
1735229 1735229 2021-09-19 Snohomish Washington 53061 55869 677
1731979 1731979 2021-09-18 Snohomish Washington 53061 55869 677
1728729 1728729 2021-09-17 Snohomish Washington 53061 55869 677
1725479 1725479 2021-09-16 Snohomish Washington 53061 55543 673
1722230 1722230 2021-09-15 Snohomish Washington 53061 55239 670
1718982 1718982 2021-09-14 Snohomish Washington 53061 54850 668
1715734 1715734 2021-09-13 Snohomish Washington 53061 54633 666
1712488 1712488 2021-09-12 Snohomish Washington 53061 53814 665
1709241 1709241 2021-09-11 Snohomish Washington 53061 53814 665
1705994 1705994 2021-09-10 Snohomish Washington 53061 53814 665
1702744 1702744 2021-09-09 Snohomish Washington 53061 53510 658
1699495 1699495 2021-09-08 Snohomish Washington 53061 53217 657
1696247 1696247 2021-09-07 Snohomish Washington 53061 52887 656
1692999 1692999 2021-09-06 Snohomish Washington 53061 51968 655
1689750 1689750 2021-09-05 Snohomish Washington 53061 51968 655
1686500 1686500 2021-09-04 Snohomish Washington 53061 51968 655
1683249 1683249 2021-09-03 Snohomish Washington 53061 51968 655
1679999 1679999 2021-09-02 Snohomish Washington 53061 51675 652
1676751 1676751 2021-09-01 Snohomish Washington 53061 51385 652
1673504 1673504 2021-08-31 Snohomish Washington 53061 51115 649
1670256 1670256 2021-08-30 Snohomish Washington 53061 50803 648
1667009 1667009 2021-08-29 Snohomish Washington 53061 50079 646
1663761 1663761 2021-08-28 Snohomish Washington 53061 50079 646
1660513 1660513 2021-08-27 Snohomish Washington 53061 50079 646
1657265 1657265 2021-08-26 Snohomish Washington 53061 49615 645
1654017 1654017 2021-08-25 Snohomish Washington 53061 49304 643
1650771 1650771 2021-08-24 Snohomish Washington 53061 49000 642
1647522 1647522 2021-08-23 Snohomish Washington 53061 48672 639
1644273 1644273 2021-08-22 Snohomish Washington 53061 47940 636
1641023 1641023 2021-08-21 Snohomish Washington 53061 47940 636
1637773 1637773 2021-08-20 Snohomish Washington 53061 47940 636
1634523 1634523 2021-08-19 Snohomish Washington 53061 47254 635
1631275 1631275 2021-08-18 Snohomish Washington 53061 46936 632
1628028 1628028 2021-08-17 Snohomish Washington 53061 46643 631
1624781 1624781 2021-08-16 Snohomish Washington 53061 46455 631
1621534 1621534 2021-08-15 Snohomish Washington 53061 45980 631
1618286 1618286 2021-08-14 Snohomish Washington 53061 45980 631
1615038 1615038 2021-08-13 Snohomish Washington 53061 45980 631
1611789 1611789 2021-08-12 Snohomish Washington 53061 45732 629
1608542 1608542 2021-08-11 Snohomish Washington 53061 45417 627
1605293 1605293 2021-08-10 Snohomish Washington 53061 44948 626
1602043 1602043 2021-08-09 Snohomish Washington 53061 44927 625
1598795 1598795 2021-08-08 Snohomish Washington 53061 44286 625
1595546 1595546 2021-08-07 Snohomish Washington 53061 44286 625
1592297 1592297 2021-08-06 Snohomish Washington 53061 44286 625
1589048 1589048 2021-08-05 Snohomish Washington 53061 44024 624
1585799 1585799 2021-08-04 Snohomish Washington 53061 43771 623
1582549 1582549 2021-08-03 Snohomish Washington 53061 43529 623
1579299 1579299 2021-08-02 Snohomish Washington 53061 42953 620
1576051 1576051 2021-08-01 Snohomish Washington 53061 42758 620
1572803 1572803 2021-07-31 Snohomish Washington 53061 42758 620
1569555 1569555 2021-07-30 Snohomish Washington 53061 42758 620
1566307 1566307 2021-07-29 Snohomish Washington 53061 42711 619
1563059 1563059 2021-07-28 Snohomish Washington 53061 42642 617
1559811 1559811 2021-07-27 Snohomish Washington 53061 42527 617
1556564 1556564 2021-07-26 Snohomish Washington 53061 42432 616
1553317 1553317 2021-07-25 Snohomish Washington 53061 42178 616
1550070 1550070 2021-07-24 Snohomish Washington 53061 42178 616
1546823 1546823 2021-07-23 Snohomish Washington 53061 42178 616
1543576 1543576 2021-07-22 Snohomish Washington 53061 41695 614
1540328 1540328 2021-07-21 Snohomish Washington 53061 41552 614
1537081 1537081 2021-07-20 Snohomish Washington 53061 41477 614
1533833 1533833 2021-07-19 Snohomish Washington 53061 41365 614
1530586 1530586 2021-07-18 Snohomish Washington 53061 41194 613
1527339 1527339 2021-07-17 Snohomish Washington 53061 41194 613
1524092 1524092 2021-07-16 Snohomish Washington 53061 41194 613
1520844 1520844 2021-07-15 Snohomish Washington 53061 41114 613
1517596 1517596 2021-07-14 Snohomish Washington 53061 41005 613
1514349 1514349 2021-07-13 Snohomish Washington 53061 40924 613
1511103 1511103 2021-07-12 Snohomish Washington 53061 40827 611
1507856 1507856 2021-07-11 Snohomish Washington 53061 40576 611
1504610 1504610 2021-07-10 Snohomish Washington 53061 40576 611
1501364 1501364 2021-07-09 Snohomish Washington 53061 40576 611
1498118 1498118 2021-07-08 Snohomish Washington 53061 40543 610

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