ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where "date" is on date 2021-01-19 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 · 39 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
946212 | 946212 | 2021-01-19 | Adams | Washington | 53001 | 1721 | 18 |
946213 | 946213 | 2021-01-19 | Asotin | Washington | 53003 | 1147 | 25 |
946214 | 946214 | 2021-01-19 | Benton | Washington | 53005 | 13529 | 179 |
946215 | 946215 | 2021-01-19 | Chelan | Washington | 53007 | 5615 | 44 |
946216 | 946216 | 2021-01-19 | Clallam | Washington | 53009 | 840 | 5 |
946217 | 946217 | 2021-01-19 | Clark | Washington | 53011 | 16300 | 166 |
946218 | 946218 | 2021-01-19 | Columbia | Washington | 53013 | 93 | 4 |
946219 | 946219 | 2021-01-19 | Cowlitz | Washington | 53015 | 3203 | 35 |
946220 | 946220 | 2021-01-19 | Douglas | Washington | 53017 | 2965 | 17 |
946221 | 946221 | 2021-01-19 | Ferry | Washington | 53019 | 195 | 4 |
946222 | 946222 | 2021-01-19 | Franklin | Washington | 53021 | 9753 | 87 |
946223 | 946223 | 2021-01-19 | Garfield | Washington | 53023 | 102 | 4 |
946224 | 946224 | 2021-01-19 | Grant | Washington | 53025 | 7858 | 90 |
946225 | 946225 | 2021-01-19 | Grays Harbor | Washington | 53027 | 2737 | 28 |
946226 | 946226 | 2021-01-19 | Island | Washington | 53029 | 1095 | 22 |
946227 | 946227 | 2021-01-19 | Jefferson | Washington | 53031 | 273 | 2 |
946228 | 946228 | 2021-01-19 | King | Washington | 53033 | 73669 | 1168 |
946229 | 946229 | 2021-01-19 | Kitsap | Washington | 53035 | 4748 | 54 |
946230 | 946230 | 2021-01-19 | Kittitas | Washington | 53037 | 1976 | 30 |
946231 | 946231 | 2021-01-19 | Klickitat | Washington | 53039 | 569 | 3 |
946232 | 946232 | 2021-01-19 | Lewis | Washington | 53041 | 2996 | 32 |
946233 | 946233 | 2021-01-19 | Lincoln | Washington | 53043 | 293 | 5 |
946234 | 946234 | 2021-01-19 | Mason | Washington | 53045 | 1969 | 16 |
946235 | 946235 | 2021-01-19 | Okanogan | Washington | 53047 | 1939 | 32 |
946236 | 946236 | 2021-01-19 | Pacific | Washington | 53049 | 604 | 8 |
946237 | 946237 | 2021-01-19 | Pend Oreille | Washington | 53051 | 527 | 4 |
946238 | 946238 | 2021-01-19 | Pierce | Washington | 53053 | 32469 | 421 |
946239 | 946239 | 2021-01-19 | San Juan | Washington | 53055 | 89 | 0 |
946240 | 946240 | 2021-01-19 | Skagit | Washington | 53057 | 3812 | 46 |
946241 | 946241 | 2021-01-19 | Skamania | Washington | 53059 | 229 | 1 |
946242 | 946242 | 2021-01-19 | Snohomish | Washington | 53061 | 27339 | 457 |
946243 | 946243 | 2021-01-19 | Spokane | Washington | 53063 | 32031 | 450 |
946244 | 946244 | 2021-01-19 | Stevens | Washington | 53065 | 1358 | 19 |
946245 | 946245 | 2021-01-19 | Thurston | Washington | 53067 | 5850 | 62 |
946246 | 946246 | 2021-01-19 | Wahkiakum | Washington | 53069 | 63 | 0 |
946247 | 946247 | 2021-01-19 | Walla Walla | Washington | 53071 | 4232 | 45 |
946248 | 946248 | 2021-01-19 | Whatcom | Washington | 53073 | 4894 | 56 |
946249 | 946249 | 2021-01-19 | Whitman | Washington | 53075 | 3036 | 36 |
946250 | 946250 | 2021-01-19 | Yakima | Washington | 53077 | 24401 | 345 |
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);