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

608 rows where fips = 53063 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

  • 53063 · 608 ✖

county

Link rowid date ▲ county state fips cases deaths
1845698 1845698 2021-10-23 Spokane Washington 53063 71290 981
1842448 1842448 2021-10-22 Spokane Washington 53063 71290 981
1839199 1839199 2021-10-21 Spokane Washington 53063 71003 974
1835950 1835950 2021-10-20 Spokane Washington 53063 70676 972
1832701 1832701 2021-10-19 Spokane Washington 53063 70400 964
1829452 1829452 2021-10-18 Spokane Washington 53063 70131 956
1826203 1826203 2021-10-17 Spokane Washington 53063 69661 956
1822954 1822954 2021-10-16 Spokane Washington 53063 69661 956
1819705 1819705 2021-10-15 Spokane Washington 53063 69661 956
1816456 1816456 2021-10-14 Spokane Washington 53063 69380 957
1813208 1813208 2021-10-13 Spokane Washington 53063 69097 949
1809959 1809959 2021-10-12 Spokane Washington 53063 68880 942
1806710 1806710 2021-10-11 Spokane Washington 53063 68240 942
1803459 1803459 2021-10-10 Spokane Washington 53063 68240 941
1800210 1800210 2021-10-09 Spokane Washington 53063 68240 941
1796961 1796961 2021-10-08 Spokane Washington 53063 68240 941
1793712 1793712 2021-10-07 Spokane Washington 53063 68029 937
1790463 1790463 2021-10-06 Spokane Washington 53063 67740 930
1787215 1787215 2021-10-05 Spokane Washington 53063 67479 923
1783966 1783966 2021-10-04 Spokane Washington 53063 67159 918
1780717 1780717 2021-10-03 Spokane Washington 53063 66523 916
1777467 1777467 2021-10-02 Spokane Washington 53063 66523 916
1774217 1774217 2021-10-01 Spokane Washington 53063 66523 916
1770967 1770967 2021-09-30 Spokane Washington 53063 66290 914
1767718 1767718 2021-09-29 Spokane Washington 53063 66046 903
1764469 1764469 2021-09-28 Spokane Washington 53063 65701 890
1761220 1761220 2021-09-27 Spokane Washington 53063 65356 883
1757972 1757972 2021-09-26 Spokane Washington 53063 64667 882
1754724 1754724 2021-09-25 Spokane Washington 53063 64667 882
1751476 1751476 2021-09-24 Spokane Washington 53063 64667 882
1748227 1748227 2021-09-23 Spokane Washington 53063 64338 875
1744977 1744977 2021-09-22 Spokane Washington 53063 63904 864
1741728 1741728 2021-09-21 Spokane Washington 53063 63675 856
1738479 1738479 2021-09-20 Spokane Washington 53063 63381 851
1735230 1735230 2021-09-19 Spokane Washington 53063 62555 843
1731980 1731980 2021-09-18 Spokane Washington 53063 62555 843
1728730 1728730 2021-09-17 Spokane Washington 53063 62555 843
1725480 1725480 2021-09-16 Spokane Washington 53063 62293 835
1722231 1722231 2021-09-15 Spokane Washington 53063 61990 817
1718983 1718983 2021-09-14 Spokane Washington 53063 61732 805
1715735 1715735 2021-09-13 Spokane Washington 53063 61368 799
1712489 1712489 2021-09-12 Spokane Washington 53063 60406 789
1709242 1709242 2021-09-11 Spokane Washington 53063 60406 789
1705995 1705995 2021-09-10 Spokane Washington 53063 60406 789
1702745 1702745 2021-09-09 Spokane Washington 53063 60053 782
1699496 1699496 2021-09-08 Spokane Washington 53063 59619 775
1696248 1696248 2021-09-07 Spokane Washington 53063 59268 770
1693000 1693000 2021-09-06 Spokane Washington 53063 58013 766
1689751 1689751 2021-09-05 Spokane Washington 53063 58013 766
1686501 1686501 2021-09-04 Spokane Washington 53063 58013 766
1683250 1683250 2021-09-03 Spokane Washington 53063 58013 766
1680000 1680000 2021-09-02 Spokane Washington 53063 57591 766
1676752 1676752 2021-09-01 Spokane Washington 53063 57200 765
1673505 1673505 2021-08-31 Spokane Washington 53063 56839 760
1670257 1670257 2021-08-30 Spokane Washington 53063 56531 751
1667010 1667010 2021-08-29 Spokane Washington 53063 55795 748
1663762 1663762 2021-08-28 Spokane Washington 53063 55795 748
1660514 1660514 2021-08-27 Spokane Washington 53063 55795 748
1657266 1657266 2021-08-26 Spokane Washington 53063 55389 742
1654018 1654018 2021-08-25 Spokane Washington 53063 55087 740
1650772 1650772 2021-08-24 Spokane Washington 53063 54814 736
1647523 1647523 2021-08-23 Spokane Washington 53063 54490 734
1644274 1644274 2021-08-22 Spokane Washington 53063 53748 729
1641024 1641024 2021-08-21 Spokane Washington 53063 53748 729
1637774 1637774 2021-08-20 Spokane Washington 53063 53748 729
1634524 1634524 2021-08-19 Spokane Washington 53063 53418 725
1631276 1631276 2021-08-18 Spokane Washington 53063 53103 723
1628029 1628029 2021-08-17 Spokane Washington 53063 52751 715
1624782 1624782 2021-08-16 Spokane Washington 53063 52500 710
1621535 1621535 2021-08-15 Spokane Washington 53063 51833 708
1618287 1618287 2021-08-14 Spokane Washington 53063 51833 708
1615039 1615039 2021-08-13 Spokane Washington 53063 51833 708
1611790 1611790 2021-08-12 Spokane Washington 53063 51535 705
1608543 1608543 2021-08-11 Spokane Washington 53063 51306 703
1605294 1605294 2021-08-10 Spokane Washington 53063 51088 703
1602044 1602044 2021-08-09 Spokane Washington 53063 50811 701
1598796 1598796 2021-08-08 Spokane Washington 53063 50232 699
1595547 1595547 2021-08-07 Spokane Washington 53063 50232 699
1592298 1592298 2021-08-06 Spokane Washington 53063 50232 699
1589049 1589049 2021-08-05 Spokane Washington 53063 50058 697
1585800 1585800 2021-08-04 Spokane Washington 53063 49884 697
1582550 1582550 2021-08-03 Spokane Washington 53063 49611 696
1579300 1579300 2021-08-02 Spokane Washington 53063 49184 696
1576052 1576052 2021-08-01 Spokane Washington 53063 48983 696
1572804 1572804 2021-07-31 Spokane Washington 53063 48983 696
1569556 1569556 2021-07-30 Spokane Washington 53063 48983 696
1566308 1566308 2021-07-29 Spokane Washington 53063 48886 696
1563060 1563060 2021-07-28 Spokane Washington 53063 48826 695
1559812 1559812 2021-07-27 Spokane Washington 53063 48731 694
1556565 1556565 2021-07-26 Spokane Washington 53063 48623 692
1553318 1553318 2021-07-25 Spokane Washington 53063 48358 693
1550071 1550071 2021-07-24 Spokane Washington 53063 48358 693
1546824 1546824 2021-07-23 Spokane Washington 53063 48358 693
1543577 1543577 2021-07-22 Spokane Washington 53063 48262 692
1540329 1540329 2021-07-21 Spokane Washington 53063 48188 692
1537082 1537082 2021-07-20 Spokane Washington 53063 48128 691
1533834 1533834 2021-07-19 Spokane Washington 53063 48068 689
1530587 1530587 2021-07-18 Spokane Washington 53063 47938 689
1527340 1527340 2021-07-17 Spokane Washington 53063 47938 689
1524093 1524093 2021-07-16 Spokane Washington 53063 47938 689

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