ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30,893 rows where state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Snohomish 74
- Spokane 40
- King 36
- Walla Walla 33
- Chelan 31
- Clark 29
- Jefferson 29
- Pierce 29
- Kittitas 28
- Kitsap 27
- Skagit 25
- Whatcom 25
- Island 24
- Thurston 24
- Columbia 23
- Grays Harbor 23
- Yakima 23
- Grant 22
- Klickitat 21
- Lewis 20
- Lincoln 20
- Franklin 18
- Mason 18
- Benton 17
- Clallam 16
- Cowlitz 15
- San Juan 15
- Stevens 15
- Whitman 13
- Adams 12
- …
state 1
- Washington · 797 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
30614 | 30614 | 2020-04-03 | Adams | Washington | 53001 | 20 | 0 |
30615 | 30615 | 2020-04-03 | Asotin | Washington | 53003 | 1 | 0 |
30616 | 30616 | 2020-04-03 | Benton | Washington | 53005 | 136 | 13 |
30617 | 30617 | 2020-04-03 | Chelan | Washington | 53007 | 20 | 3 |
30618 | 30618 | 2020-04-03 | Clallam | Washington | 53009 | 8 | 0 |
30619 | 30619 | 2020-04-03 | Clark | Washington | 53011 | 137 | 8 |
30620 | 30620 | 2020-04-03 | Columbia | Washington | 53013 | 1 | 0 |
30621 | 30621 | 2020-04-03 | Cowlitz | Washington | 53015 | 18 | 0 |
30622 | 30622 | 2020-04-03 | Douglas | Washington | 53017 | 7 | 0 |
30623 | 30623 | 2020-04-03 | Ferry | Washington | 53019 | 1 | 0 |
30624 | 30624 | 2020-04-03 | Franklin | Washington | 53021 | 45 | 1 |
30625 | 30625 | 2020-04-03 | Grant | Washington | 53025 | 77 | 0 |
30626 | 30626 | 2020-04-03 | Grays Harbor | Washington | 53027 | 3 | 0 |
30627 | 30627 | 2020-04-03 | Island | Washington | 53029 | 122 | 4 |
30628 | 30628 | 2020-04-03 | Jefferson | Washington | 53031 | 19 | 0 |
30629 | 30629 | 2020-04-03 | King | Washington | 53033 | 2789 | 188 |
30630 | 30630 | 2020-04-03 | Kitsap | Washington | 53035 | 95 | 0 |
30631 | 30631 | 2020-04-03 | Kittitas | Washington | 53037 | 10 | 0 |
30632 | 30632 | 2020-04-03 | Klickitat | Washington | 53039 | 9 | 1 |
30633 | 30633 | 2020-04-03 | Lewis | Washington | 53041 | 12 | 0 |
30634 | 30634 | 2020-04-03 | Lincoln | Washington | 53043 | 1 | 0 |
30635 | 30635 | 2020-04-03 | Mason | Washington | 53045 | 13 | 0 |
30636 | 30636 | 2020-04-03 | Okanogan | Washington | 53047 | 4 | 0 |
30637 | 30637 | 2020-04-03 | Pend Oreille | Washington | 53051 | 1 | 0 |
30638 | 30638 | 2020-04-03 | Pierce | Washington | 53053 | 578 | 7 |
30639 | 30639 | 2020-04-03 | San Juan | Washington | 53055 | 6 | 0 |
30640 | 30640 | 2020-04-03 | Skagit | Washington | 53057 | 160 | 4 |
30641 | 30641 | 2020-04-03 | Skamania | Washington | 53059 | 1 | 0 |
30642 | 30642 | 2020-04-03 | Snohomish | Washington | 53061 | 1449 | 41 |
30643 | 30643 | 2020-04-03 | Spokane | Washington | 53063 | 194 | 7 |
30644 | 30644 | 2020-04-03 | Stevens | Washington | 53065 | 5 | 0 |
30645 | 30645 | 2020-04-03 | Thurston | Washington | 53067 | 58 | 0 |
30646 | 30646 | 2020-04-03 | Unknown | Washington | 476 | 0 | |
30647 | 30647 | 2020-04-03 | Walla Walla | Washington | 53071 | 9 | 0 |
30648 | 30648 | 2020-04-03 | Whatcom | Washington | 53073 | 182 | 9 |
30649 | 30649 | 2020-04-03 | Whitman | Washington | 53075 | 11 | 0 |
30650 | 30650 | 2020-04-03 | Yakima | Washington | 53077 | 289 | 7 |
28262 | 28262 | 2020-04-02 | Adams | Washington | 53001 | 20 | 0 |
28263 | 28263 | 2020-04-02 | Benton | Washington | 53005 | 133 | 9 |
28264 | 28264 | 2020-04-02 | Chelan | Washington | 53007 | 19 | 3 |
28265 | 28265 | 2020-04-02 | Clallam | Washington | 53009 | 8 | 0 |
28266 | 28266 | 2020-04-02 | Clark | Washington | 53011 | 131 | 8 |
28267 | 28267 | 2020-04-02 | Columbia | Washington | 53013 | 1 | 0 |
28268 | 28268 | 2020-04-02 | Cowlitz | Washington | 53015 | 16 | 0 |
28269 | 28269 | 2020-04-02 | Douglas | Washington | 53017 | 6 | 0 |
28270 | 28270 | 2020-04-02 | Ferry | Washington | 53019 | 1 | 0 |
28271 | 28271 | 2020-04-02 | Franklin | Washington | 53021 | 43 | 0 |
28272 | 28272 | 2020-04-02 | Grant | Washington | 53025 | 74 | 0 |
28273 | 28273 | 2020-04-02 | Grays Harbor | Washington | 53027 | 2 | 0 |
28274 | 28274 | 2020-04-02 | Island | Washington | 53029 | 119 | 4 |
28275 | 28275 | 2020-04-02 | Jefferson | Washington | 53031 | 19 | 0 |
28276 | 28276 | 2020-04-02 | King | Washington | 53033 | 2658 | 177 |
28277 | 28277 | 2020-04-02 | Kitsap | Washington | 53035 | 85 | 0 |
28278 | 28278 | 2020-04-02 | Kittitas | Washington | 53037 | 10 | 0 |
28279 | 28279 | 2020-04-02 | Klickitat | Washington | 53039 | 9 | 1 |
28280 | 28280 | 2020-04-02 | Lewis | Washington | 53041 | 12 | 0 |
28281 | 28281 | 2020-04-02 | Lincoln | Washington | 53043 | 1 | 0 |
28282 | 28282 | 2020-04-02 | Mason | Washington | 53045 | 13 | 0 |
28283 | 28283 | 2020-04-02 | Okanogan | Washington | 53047 | 4 | 0 |
28284 | 28284 | 2020-04-02 | Pend Oreille | Washington | 53051 | 1 | 0 |
28285 | 28285 | 2020-04-02 | Pierce | Washington | 53053 | 499 | 7 |
28286 | 28286 | 2020-04-02 | San Juan | Washington | 53055 | 6 | 0 |
28287 | 28287 | 2020-04-02 | Skagit | Washington | 53057 | 153 | 4 |
28288 | 28288 | 2020-04-02 | Skamania | Washington | 53059 | 1 | 0 |
28289 | 28289 | 2020-04-02 | Snohomish | Washington | 53061 | 1375 | 39 |
28290 | 28290 | 2020-04-02 | Spokane | Washington | 53063 | 186 | 5 |
28291 | 28291 | 2020-04-02 | Stevens | Washington | 53065 | 5 | 0 |
28292 | 28292 | 2020-04-02 | Thurston | Washington | 53067 | 55 | 0 |
28293 | 28293 | 2020-04-02 | Unknown | Washington | 510 | 0 | |
28294 | 28294 | 2020-04-02 | Walla Walla | Washington | 53071 | 9 | 0 |
28295 | 28295 | 2020-04-02 | Whatcom | Washington | 53073 | 175 | 9 |
28296 | 28296 | 2020-04-02 | Whitman | Washington | 53075 | 11 | 0 |
28297 | 28297 | 2020-04-02 | Yakima | Washington | 53077 | 216 | 6 |
25972 | 25972 | 2020-04-01 | Adams | Washington | 53001 | 14 | 0 |
25973 | 25973 | 2020-04-01 | Benton | Washington | 53005 | 108 | 6 |
25974 | 25974 | 2020-04-01 | Chelan | Washington | 53007 | 15 | 2 |
25975 | 25975 | 2020-04-01 | Clallam | Washington | 53009 | 8 | 0 |
25976 | 25976 | 2020-04-01 | Clark | Washington | 53011 | 130 | 6 |
25977 | 25977 | 2020-04-01 | Columbia | Washington | 53013 | 1 | 0 |
25978 | 25978 | 2020-04-01 | Cowlitz | Washington | 53015 | 18 | 0 |
25979 | 25979 | 2020-04-01 | Douglas | Washington | 53017 | 5 | 0 |
25980 | 25980 | 2020-04-01 | Ferry | Washington | 53019 | 1 | 0 |
25981 | 25981 | 2020-04-01 | Franklin | Washington | 53021 | 33 | 0 |
25982 | 25982 | 2020-04-01 | Grant | Washington | 53025 | 73 | 0 |
25983 | 25983 | 2020-04-01 | Grays Harbor | Washington | 53027 | 1 | 0 |
25984 | 25984 | 2020-04-01 | Island | Washington | 53029 | 114 | 3 |
25985 | 25985 | 2020-04-01 | Jefferson | Washington | 53031 | 17 | 0 |
25986 | 25986 | 2020-04-01 | King | Washington | 53033 | 2498 | 166 |
25987 | 25987 | 2020-04-01 | Kitsap | Washington | 53035 | 74 | 1 |
25988 | 25988 | 2020-04-01 | Kittitas | Washington | 53037 | 10 | 0 |
25989 | 25989 | 2020-04-01 | Klickitat | Washington | 53039 | 9 | 1 |
25990 | 25990 | 2020-04-01 | Lewis | Washington | 53041 | 10 | 0 |
25991 | 25991 | 2020-04-01 | Lincoln | Washington | 53043 | 1 | 0 |
25992 | 25992 | 2020-04-01 | Mason | Washington | 53045 | 6 | 0 |
25993 | 25993 | 2020-04-01 | Okanogan | Washington | 53047 | 3 | 0 |
25994 | 25994 | 2020-04-01 | Pierce | Washington | 53053 | 424 | 7 |
25995 | 25995 | 2020-04-01 | San Juan | Washington | 53055 | 6 | 0 |
25996 | 25996 | 2020-04-01 | Skagit | Washington | 53057 | 143 | 4 |
25997 | 25997 | 2020-04-01 | Skamania | Washington | 53059 | 1 | 0 |
25998 | 25998 | 2020-04-01 | Snohomish | Washington | 53061 | 1304 | 39 |
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);