ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where "date" is on date 2020-11-26 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Adams 1
- Asotin 1
- Benton 1
- Chelan 1
- Clallam 1
- Clark 1
- Columbia 1
- Cowlitz 1
- Douglas 1
- Ferry 1
- Franklin 1
- Garfield 1
- Grant 1
- Grays Harbor 1
- Island 1
- Jefferson 1
- King 1
- Kitsap 1
- Kittitas 1
- Klickitat 1
- Lewis 1
- Lincoln 1
- Mason 1
- Okanogan 1
- Pacific 1
- Pend Oreille 1
- Pierce 1
- San Juan 1
- Skagit 1
- Skamania 1
- …
state 1
- Washington · 40 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
770964 | 770964 | 2020-11-26 | Adams | Washington | 53001 | 1310 | 12 |
770965 | 770965 | 2020-11-26 | Asotin | Washington | 53003 | 617 | 12 |
770966 | 770966 | 2020-11-26 | Benton | Washington | 53005 | 7795 | 144 |
770967 | 770967 | 2020-11-26 | Chelan | Washington | 53007 | 3394 | 30 |
770968 | 770968 | 2020-11-26 | Clallam | Washington | 53009 | 427 | 3 |
770969 | 770969 | 2020-11-26 | Clark | Washington | 53011 | 8030 | 117 |
770970 | 770970 | 2020-11-26 | Columbia | Washington | 53013 | 33 | 2 |
770971 | 770971 | 2020-11-26 | Cowlitz | Washington | 53015 | 1315 | 8 |
770972 | 770972 | 2020-11-26 | Douglas | Washington | 53017 | 1893 | 12 |
770973 | 770973 | 2020-11-26 | Ferry | Washington | 53019 | 59 | 1 |
770974 | 770974 | 2020-11-26 | Franklin | Washington | 53021 | 6316 | 73 |
770975 | 770975 | 2020-11-26 | Garfield | Washington | 53023 | 52 | 0 |
770976 | 770976 | 2020-11-26 | Grant | Washington | 53025 | 4814 | 35 |
770977 | 770977 | 2020-11-26 | Grays Harbor | Washington | 53027 | 965 | 17 |
770978 | 770978 | 2020-11-26 | Island | Washington | 53029 | 606 | 15 |
770979 | 770979 | 2020-11-26 | Jefferson | Washington | 53031 | 152 | 1 |
770980 | 770980 | 2020-11-26 | King | Washington | 53033 | 42122 | 885 |
770981 | 770981 | 2020-11-26 | Kitsap | Washington | 53035 | 2318 | 31 |
770982 | 770982 | 2020-11-26 | Kittitas | Washington | 53037 | 901 | 23 |
770983 | 770983 | 2020-11-26 | Klickitat | Washington | 53039 | 254 | 3 |
770984 | 770984 | 2020-11-26 | Lewis | Washington | 53041 | 1118 | 16 |
770985 | 770985 | 2020-11-26 | Lincoln | Washington | 53043 | 149 | 3 |
770986 | 770986 | 2020-11-26 | Mason | Washington | 53045 | 713 | 11 |
770987 | 770987 | 2020-11-26 | Okanogan | Washington | 53047 | 1321 | 15 |
770988 | 770988 | 2020-11-26 | Pacific | Washington | 53049 | 236 | 3 |
770989 | 770989 | 2020-11-26 | Pend Oreille | Washington | 53051 | 213 | 1 |
770990 | 770990 | 2020-11-26 | Pierce | Washington | 53053 | 17155 | 308 |
770991 | 770991 | 2020-11-26 | San Juan | Washington | 53055 | 61 | 0 |
770992 | 770992 | 2020-11-26 | Skagit | Washington | 53057 | 1891 | 27 |
770993 | 770993 | 2020-11-26 | Skamania | Washington | 53059 | 99 | 1 |
770994 | 770994 | 2020-11-26 | Snohomish | Washington | 53061 | 14925 | 287 |
770995 | 770995 | 2020-11-26 | Spokane | Washington | 53063 | 15752 | 254 |
770996 | 770996 | 2020-11-26 | Stevens | Washington | 53065 | 591 | 7 |
770997 | 770997 | 2020-11-26 | Thurston | Washington | 53067 | 2778 | 47 |
770998 | 770998 | 2020-11-26 | Unknown | Washington | 2 | 2 | |
770999 | 770999 | 2020-11-26 | Wahkiakum | Washington | 53069 | 19 | 0 |
771000 | 771000 | 2020-11-26 | Walla Walla | Washington | 53071 | 2143 | 24 |
771001 | 771001 | 2020-11-26 | Whatcom | Washington | 53073 | 2265 | 63 |
771002 | 771002 | 2020-11-26 | Whitman | Washington | 53075 | 2285 | 24 |
771003 | 771003 | 2020-11-26 | Yakima | Washington | 53077 | 14822 | 308 |
Advanced export
JSON shape: default, array, newline-delimited
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);