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
- 53061 163
- 53063 129
- 53033 125
- 53071 122
- 53007 120
- 53011 118
- 53031 118
- 53053 118
- 53037 117
- 53035 116
- 53057 114
- 53073 114
- 53029 113
- 53067 113
- 53013 112
- 53027 112
- 53077 112
- 53025 111
- 53039 110
- 53041 109
- 53043 109
- 53021 107
- 53045 107
- 53005 106
- 53009 105
- 53015 104
- 53055 104
- 53065 104
- 53075 102
- 53001 101
- …
county >30
- Snohomish 163
- Spokane 129
- King 125
- Walla Walla 122
- Chelan 120
- Clark 118
- Jefferson 118
- Pierce 118
- Kittitas 117
- Kitsap 116
- Skagit 114
- Whatcom 114
- Island 113
- Thurston 113
- Columbia 112
- Grays Harbor 112
- Yakima 112
- Grant 111
- Klickitat 110
- Lewis 109
- Lincoln 109
- Franklin 107
- Mason 107
- Benton 106
- Clallam 105
- Cowlitz 104
- San Juan 104
- Stevens 104
- Whitman 102
- Adams 101
- …
state 1
- Washington · 4,188 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293196 | 293196 | 2020-07-01 | Adams | Washington | 53001 | 142 | 0 |
293197 | 293197 | 2020-07-01 | Asotin | Washington | 53003 | 21 | 2 |
293198 | 293198 | 2020-07-01 | Benton | Washington | 53005 | 2051 | 82 |
293199 | 293199 | 2020-07-01 | Chelan | Washington | 53007 | 348 | 7 |
293200 | 293200 | 2020-07-01 | Clallam | Washington | 53009 | 36 | 0 |
293201 | 293201 | 2020-07-01 | Clark | Washington | 53011 | 883 | 30 |
293202 | 293202 | 2020-07-01 | Columbia | Washington | 53013 | 8 | 0 |
293203 | 293203 | 2020-07-01 | Cowlitz | Washington | 53015 | 187 | 0 |
293204 | 293204 | 2020-07-01 | Douglas | Washington | 53017 | 245 | 3 |
293205 | 293205 | 2020-07-01 | Ferry | Washington | 53019 | 1 | 0 |
293206 | 293206 | 2020-07-01 | Franklin | Washington | 53021 | 1842 | 33 |
293207 | 293207 | 2020-07-01 | Grant | Washington | 53025 | 621 | 5 |
293208 | 293208 | 2020-07-01 | Grays Harbor | Washington | 53027 | 26 | 0 |
293209 | 293209 | 2020-07-01 | Island | Washington | 53029 | 195 | 12 |
293210 | 293210 | 2020-07-01 | Jefferson | Washington | 53031 | 38 | 0 |
293211 | 293211 | 2020-07-01 | King | Washington | 53033 | 10358 | 614 |
293212 | 293212 | 2020-07-01 | Kitsap | Washington | 53035 | 225 | 2 |
293213 | 293213 | 2020-07-01 | Kittitas | Washington | 53037 | 131 | 0 |
293214 | 293214 | 2020-07-01 | Klickitat | Washington | 53039 | 59 | 3 |
293215 | 293215 | 2020-07-01 | Lewis | Washington | 53041 | 68 | 3 |
293216 | 293216 | 2020-07-01 | Lincoln | Washington | 53043 | 4 | 0 |
293217 | 293217 | 2020-07-01 | Mason | Washington | 53045 | 51 | 1 |
293218 | 293218 | 2020-07-01 | Okanogan | Washington | 53047 | 116 | 2 |
293219 | 293219 | 2020-07-01 | Pacific | Washington | 53049 | 17 | 1 |
293220 | 293220 | 2020-07-01 | Pend Oreille | Washington | 53051 | 4 | 0 |
293221 | 293221 | 2020-07-01 | Pierce | Washington | 53053 | 2928 | 104 |
293222 | 293222 | 2020-07-01 | San Juan | Washington | 53055 | 19 | 0 |
293223 | 293223 | 2020-07-01 | Skagit | Washington | 53057 | 527 | 15 |
293224 | 293224 | 2020-07-01 | Skamania | Washington | 53059 | 5 | 0 |
293225 | 293225 | 2020-07-01 | Snohomish | Washington | 53061 | 4063 | 170 |
293226 | 293226 | 2020-07-01 | Spokane | Washington | 53063 | 1420 | 41 |
293227 | 293227 | 2020-07-01 | Stevens | Washington | 53065 | 18 | 1 |
293228 | 293228 | 2020-07-01 | Thurston | Washington | 53067 | 273 | 7 |
293229 | 293229 | 2020-07-01 | Wahkiakum | Washington | 53069 | 5 | 0 |
293230 | 293230 | 2020-07-01 | Walla Walla | Washington | 53071 | 171 | 3 |
293231 | 293231 | 2020-07-01 | Whatcom | Washington | 53073 | 635 | 40 |
293232 | 293232 | 2020-07-01 | Whitman | Washington | 53075 | 41 | 0 |
293233 | 293233 | 2020-07-01 | Yakima | Washington | 53077 | 7476 | 159 |
290043 | 290043 | 2020-06-30 | Adams | Washington | 53001 | 134 | 0 |
290044 | 290044 | 2020-06-30 | Asotin | Washington | 53003 | 21 | 2 |
290045 | 290045 | 2020-06-30 | Benton | Washington | 53005 | 1904 | 82 |
290046 | 290046 | 2020-06-30 | Chelan | Washington | 53007 | 336 | 7 |
290047 | 290047 | 2020-06-30 | Clallam | Washington | 53009 | 36 | 0 |
290048 | 290048 | 2020-06-30 | Clark | Washington | 53011 | 843 | 30 |
290049 | 290049 | 2020-06-30 | Columbia | Washington | 53013 | 8 | 0 |
290050 | 290050 | 2020-06-30 | Cowlitz | Washington | 53015 | 179 | 0 |
290051 | 290051 | 2020-06-30 | Douglas | Washington | 53017 | 239 | 3 |
290052 | 290052 | 2020-06-30 | Ferry | Washington | 53019 | 1 | 0 |
290053 | 290053 | 2020-06-30 | Franklin | Washington | 53021 | 1777 | 33 |
290054 | 290054 | 2020-06-30 | Grant | Washington | 53025 | 611 | 5 |
290055 | 290055 | 2020-06-30 | Grays Harbor | Washington | 53027 | 27 | 0 |
290056 | 290056 | 2020-06-30 | Island | Washington | 53029 | 192 | 12 |
290057 | 290057 | 2020-06-30 | Jefferson | Washington | 53031 | 38 | 0 |
290058 | 290058 | 2020-06-30 | King | Washington | 53033 | 10198 | 612 |
290059 | 290059 | 2020-06-30 | Kitsap | Washington | 53035 | 221 | 2 |
290060 | 290060 | 2020-06-30 | Kittitas | Washington | 53037 | 128 | 0 |
290061 | 290061 | 2020-06-30 | Klickitat | Washington | 53039 | 59 | 3 |
290062 | 290062 | 2020-06-30 | Lewis | Washington | 53041 | 65 | 3 |
290063 | 290063 | 2020-06-30 | Lincoln | Washington | 53043 | 4 | 0 |
290064 | 290064 | 2020-06-30 | Mason | Washington | 53045 | 50 | 1 |
290065 | 290065 | 2020-06-30 | Okanogan | Washington | 53047 | 115 | 2 |
290066 | 290066 | 2020-06-30 | Pacific | Washington | 53049 | 17 | 1 |
290067 | 290067 | 2020-06-30 | Pend Oreille | Washington | 53051 | 4 | 0 |
290068 | 290068 | 2020-06-30 | Pierce | Washington | 53053 | 2887 | 101 |
290069 | 290069 | 2020-06-30 | San Juan | Washington | 53055 | 19 | 0 |
290070 | 290070 | 2020-06-30 | Skagit | Washington | 53057 | 519 | 15 |
290071 | 290071 | 2020-06-30 | Skamania | Washington | 53059 | 5 | 0 |
290072 | 290072 | 2020-06-30 | Snohomish | Washington | 53061 | 4018 | 170 |
290073 | 290073 | 2020-06-30 | Spokane | Washington | 53063 | 1385 | 40 |
290074 | 290074 | 2020-06-30 | Stevens | Washington | 53065 | 18 | 1 |
290075 | 290075 | 2020-06-30 | Thurston | Washington | 53067 | 263 | 7 |
290076 | 290076 | 2020-06-30 | Wahkiakum | Washington | 53069 | 5 | 0 |
290077 | 290077 | 2020-06-30 | Walla Walla | Washington | 53071 | 169 | 3 |
290078 | 290078 | 2020-06-30 | Whatcom | Washington | 53073 | 622 | 40 |
290079 | 290079 | 2020-06-30 | Whitman | Washington | 53075 | 39 | 0 |
290080 | 290080 | 2020-06-30 | Yakima | Washington | 53077 | 7385 | 158 |
286893 | 286893 | 2020-06-29 | Adams | Washington | 53001 | 130 | 0 |
286894 | 286894 | 2020-06-29 | Asotin | Washington | 53003 | 21 | 2 |
286895 | 286895 | 2020-06-29 | Benton | Washington | 53005 | 1889 | 79 |
286896 | 286896 | 2020-06-29 | Chelan | Washington | 53007 | 326 | 7 |
286897 | 286897 | 2020-06-29 | Clallam | Washington | 53009 | 36 | 0 |
286898 | 286898 | 2020-06-29 | Clark | Washington | 53011 | 826 | 30 |
286899 | 286899 | 2020-06-29 | Columbia | Washington | 53013 | 8 | 0 |
286900 | 286900 | 2020-06-29 | Cowlitz | Washington | 53015 | 172 | 0 |
286901 | 286901 | 2020-06-29 | Douglas | Washington | 53017 | 233 | 3 |
286902 | 286902 | 2020-06-29 | Ferry | Washington | 53019 | 1 | 0 |
286903 | 286903 | 2020-06-29 | Franklin | Washington | 53021 | 1750 | 33 |
286904 | 286904 | 2020-06-29 | Grant | Washington | 53025 | 610 | 5 |
286905 | 286905 | 2020-06-29 | Grays Harbor | Washington | 53027 | 26 | 0 |
286906 | 286906 | 2020-06-29 | Island | Washington | 53029 | 192 | 12 |
286907 | 286907 | 2020-06-29 | Jefferson | Washington | 53031 | 38 | 0 |
286908 | 286908 | 2020-06-29 | King | Washington | 53033 | 10071 | 612 |
286909 | 286909 | 2020-06-29 | Kitsap | Washington | 53035 | 212 | 2 |
286910 | 286910 | 2020-06-29 | Kittitas | Washington | 53037 | 127 | 0 |
286911 | 286911 | 2020-06-29 | Klickitat | Washington | 53039 | 60 | 3 |
286912 | 286912 | 2020-06-29 | Lewis | Washington | 53041 | 64 | 3 |
286913 | 286913 | 2020-06-29 | Lincoln | Washington | 53043 | 3 | 0 |
286914 | 286914 | 2020-06-29 | Mason | Washington | 53045 | 47 | 1 |
286915 | 286915 | 2020-06-29 | Okanogan | Washington | 53047 | 93 | 2 |
286916 | 286916 | 2020-06-29 | Pacific | Washington | 53049 | 13 | 1 |
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);