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-10-21 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, 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 |
---|---|---|---|---|---|---|---|
654169 | 654169 | 2020-10-21 | Adams | Washington | 53001 | 910 | 10 |
654170 | 654170 | 2020-10-21 | Asotin | Washington | 53003 | 199 | 7 |
654171 | 654171 | 2020-10-21 | Benton | Washington | 53005 | 5238 | 137 |
654172 | 654172 | 2020-10-21 | Chelan | Washington | 53007 | 2305 | 20 |
654173 | 654173 | 2020-10-21 | Clallam | Washington | 53009 | 255 | 1 |
654174 | 654174 | 2020-10-21 | Clark | Washington | 53011 | 4332 | 79 |
654175 | 654175 | 2020-10-21 | Columbia | Washington | 53013 | 14 | 1 |
654176 | 654176 | 2020-10-21 | Cowlitz | Washington | 53015 | 776 | 7 |
654177 | 654177 | 2020-10-21 | Douglas | Washington | 53017 | 1391 | 10 |
654178 | 654178 | 2020-10-21 | Ferry | Washington | 53019 | 33 | 0 |
654179 | 654179 | 2020-10-21 | Franklin | Washington | 53021 | 4840 | 68 |
654180 | 654180 | 2020-10-21 | Garfield | Washington | 53023 | 14 | 0 |
654181 | 654181 | 2020-10-21 | Grant | Washington | 53025 | 3467 | 25 |
654182 | 654182 | 2020-10-21 | Grays Harbor | Washington | 53027 | 656 | 12 |
654183 | 654183 | 2020-10-21 | Island | Washington | 53029 | 376 | 15 |
654184 | 654184 | 2020-10-21 | Jefferson | Washington | 53031 | 81 | 0 |
654185 | 654185 | 2020-10-21 | King | Washington | 53033 | 25559 | 819 |
654186 | 654186 | 2020-10-21 | Kitsap | Washington | 53035 | 1438 | 22 |
654187 | 654187 | 2020-10-21 | Kittitas | Washington | 53037 | 690 | 22 |
654188 | 654188 | 2020-10-21 | Klickitat | Washington | 53039 | 206 | 3 |
654189 | 654189 | 2020-10-21 | Lewis | Washington | 53041 | 677 | 12 |
654190 | 654190 | 2020-10-21 | Lincoln | Washington | 53043 | 69 | 2 |
654191 | 654191 | 2020-10-21 | Mason | Washington | 53045 | 503 | 9 |
654192 | 654192 | 2020-10-21 | Okanogan | Washington | 53047 | 1128 | 13 |
654193 | 654193 | 2020-10-21 | Pacific | Washington | 53049 | 114 | 3 |
654194 | 654194 | 2020-10-21 | Pend Oreille | Washington | 53051 | 133 | 1 |
654195 | 654195 | 2020-10-21 | Pierce | Washington | 53053 | 10585 | 243 |
654196 | 654196 | 2020-10-21 | San Juan | Washington | 53055 | 30 | 0 |
654197 | 654197 | 2020-10-21 | Skagit | Washington | 53057 | 1213 | 24 |
654198 | 654198 | 2020-10-21 | Skamania | Washington | 53059 | 72 | 1 |
654199 | 654199 | 2020-10-21 | Snohomish | Washington | 53061 | 9478 | 238 |
654200 | 654200 | 2020-10-21 | Spokane | Washington | 53063 | 8922 | 194 |
654201 | 654201 | 2020-10-21 | Stevens | Washington | 53065 | 238 | 5 |
654202 | 654202 | 2020-10-21 | Thurston | Washington | 53067 | 1646 | 23 |
654203 | 654203 | 2020-10-21 | Unknown | Washington | 2 | 2 | |
654204 | 654204 | 2020-10-21 | Wahkiakum | Washington | 53069 | 10 | 0 |
654205 | 654205 | 2020-10-21 | Walla Walla | Washington | 53071 | 1045 | 7 |
654206 | 654206 | 2020-10-21 | Whatcom | Washington | 53073 | 1547 | 59 |
654207 | 654207 | 2020-10-21 | Whitman | Washington | 53075 | 1691 | 10 |
654208 | 654208 | 2020-10-21 | Yakima | Washington | 53077 | 12741 | 280 |
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);