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-28 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
975418 | 975418 | 2021-01-28 | Adams | Washington | 53001 | 1779 | 19 |
975419 | 975419 | 2021-01-28 | Asotin | Washington | 53003 | 1226 | 26 |
975420 | 975420 | 2021-01-28 | Benton | Washington | 53005 | 14187 | 188 |
975421 | 975421 | 2021-01-28 | Chelan | Washington | 53007 | 5890 | 50 |
975422 | 975422 | 2021-01-28 | Clallam | Washington | 53009 | 890 | 5 |
975423 | 975423 | 2021-01-28 | Clark | Washington | 53011 | 17249 | 183 |
975424 | 975424 | 2021-01-28 | Columbia | Washington | 53013 | 94 | 4 |
975425 | 975425 | 2021-01-28 | Cowlitz | Washington | 53015 | 3611 | 42 |
975426 | 975426 | 2021-01-28 | Douglas | Washington | 53017 | 3083 | 18 |
975427 | 975427 | 2021-01-28 | Ferry | Washington | 53019 | 197 | 4 |
975428 | 975428 | 2021-01-28 | Franklin | Washington | 53021 | 10095 | 90 |
975429 | 975429 | 2021-01-28 | Garfield | Washington | 53023 | 103 | 4 |
975430 | 975430 | 2021-01-28 | Grant | Washington | 53025 | 8210 | 104 |
975431 | 975431 | 2021-01-28 | Grays Harbor | Washington | 53027 | 2924 | 32 |
975432 | 975432 | 2021-01-28 | Island | Washington | 53029 | 1170 | 22 |
975433 | 975433 | 2021-01-28 | Jefferson | Washington | 53031 | 290 | 2 |
975434 | 975434 | 2021-01-28 | King | Washington | 53033 | 77069 | 1235 |
975435 | 975435 | 2021-01-28 | Kitsap | Washington | 53035 | 5077 | 66 |
975436 | 975436 | 2021-01-28 | Kittitas | Washington | 53037 | 2053 | 30 |
975437 | 975437 | 2021-01-28 | Klickitat | Washington | 53039 | 602 | 5 |
975438 | 975438 | 2021-01-28 | Lewis | Washington | 53041 | 3265 | 37 |
975439 | 975439 | 2021-01-28 | Lincoln | Washington | 53043 | 304 | 4 |
975440 | 975440 | 2021-01-28 | Mason | Washington | 53045 | 2084 | 18 |
975441 | 975441 | 2021-01-28 | Okanogan | Washington | 53047 | 2015 | 34 |
975442 | 975442 | 2021-01-28 | Pacific | Washington | 53049 | 648 | 8 |
975443 | 975443 | 2021-01-28 | Pend Oreille | Washington | 53051 | 554 | 4 |
975444 | 975444 | 2021-01-28 | Pierce | Washington | 53053 | 34590 | 459 |
975445 | 975445 | 2021-01-28 | San Juan | Washington | 53055 | 96 | 0 |
975446 | 975446 | 2021-01-28 | Skagit | Washington | 53057 | 4042 | 50 |
975447 | 975447 | 2021-01-28 | Skamania | Washington | 53059 | 240 | 1 |
975448 | 975448 | 2021-01-28 | Snohomish | Washington | 53061 | 28328 | 483 |
975449 | 975449 | 2021-01-28 | Spokane | Washington | 53063 | 33979 | 498 |
975450 | 975450 | 2021-01-28 | Stevens | Washington | 53065 | 1442 | 21 |
975451 | 975451 | 2021-01-28 | Thurston | Washington | 53067 | 6297 | 67 |
975452 | 975452 | 2021-01-28 | Wahkiakum | Washington | 53069 | 66 | 0 |
975453 | 975453 | 2021-01-28 | Walla Walla | Washington | 53071 | 4400 | 49 |
975454 | 975454 | 2021-01-28 | Whatcom | Washington | 53073 | 5419 | 64 |
975455 | 975455 | 2021-01-28 | Whitman | Washington | 53075 | 3141 | 36 |
975456 | 975456 | 2021-01-28 | Yakima | Washington | 53077 | 25333 | 366 |
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);