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

40 rows where "date" is on date 2020-08-18 and state = "Washington" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Washington · 40 ✖
Link rowid date ▲ county state fips cases deaths
446953 446953 2020-08-18 Adams Washington 53001 509 6
446954 446954 2020-08-18 Asotin Washington 53003 42 2
446955 446955 2020-08-18 Benton Washington 53005 4062 125
446956 446956 2020-08-18 Chelan Washington 53007 1555 12
446957 446957 2020-08-18 Clallam Washington 53009 171 1
446958 446958 2020-08-18 Clark Washington 53011 2327 52
446959 446959 2020-08-18 Columbia Washington 53013 13 1
446960 446960 2020-08-18 Cowlitz Washington 53015 510 7
446961 446961 2020-08-18 Douglas Washington 53017 1042 8
446962 446962 2020-08-18 Ferry Washington 53019 25 0
446963 446963 2020-08-18 Franklin Washington 53021 3895 56
446964 446964 2020-08-18 Garfield Washington 53023 4 0
446965 446965 2020-08-18 Grant Washington 53025 1950 13
446966 446966 2020-08-18 Grays Harbor Washington 53027 144 3
446967 446967 2020-08-18 Island Washington 53029 257 15
446968 446968 2020-08-18 Jefferson Washington 53031 61 0
446969 446969 2020-08-18 King Washington 53033 18008 717
446970 446970 2020-08-18 Kitsap Washington 53035 827 8
446971 446971 2020-08-18 Kittitas Washington 53037 448 20
446972 446972 2020-08-18 Klickitat Washington 53039 152 3
446973 446973 2020-08-18 Lewis Washington 53041 267 4
446974 446974 2020-08-18 Lincoln Washington 53043 31 0
446975 446975 2020-08-18 Mason Washington 53045 265 2
446976 446976 2020-08-18 Okanogan Washington 53047 930 9
446977 446977 2020-08-18 Pacific Washington 53049 58 2
446978 446978 2020-08-18 Pend Oreille Washington 53051 51 0
446979 446979 2020-08-18 Pierce Washington 53053 6831 159
446980 446980 2020-08-18 San Juan Washington 53055 30 0
446981 446981 2020-08-18 Skagit Washington 53057 937 24
446982 446982 2020-08-18 Skamania Washington 53059 60 1
446983 446983 2020-08-18 Snohomish Washington 53061 6599 217
446984 446984 2020-08-18 Spokane Washington 53063 4843 117
446985 446985 2020-08-18 Stevens Washington 53065 118 1
446986 446986 2020-08-18 Thurston Washington 53067 869 12
446987 446987 2020-08-18 Unknown Washington   2 2
446988 446988 2020-08-18 Wahkiakum Washington 53069 5 0
446989 446989 2020-08-18 Walla Walla Washington 53071 656 6
446990 446990 2020-08-18 Whatcom Washington 53073 1044 50
446991 446991 2020-08-18 Whitman Washington 53075 131 0
446992 446992 2020-08-18 Yakima Washington 53077 11303 240

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