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-11-12 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 |
---|---|---|---|---|---|---|---|
725526 | 725526 | 2020-11-12 | Adams | Washington | 53001 | 1030 | 11 |
725527 | 725527 | 2020-11-12 | Asotin | Washington | 53003 | 428 | 10 |
725528 | 725528 | 2020-11-12 | Benton | Washington | 53005 | 6428 | 141 |
725529 | 725529 | 2020-11-12 | Chelan | Washington | 53007 | 2693 | 24 |
725530 | 725530 | 2020-11-12 | Clallam | Washington | 53009 | 294 | 2 |
725531 | 725531 | 2020-11-12 | Clark | Washington | 53011 | 6049 | 98 |
725532 | 725532 | 2020-11-12 | Columbia | Washington | 53013 | 23 | 2 |
725533 | 725533 | 2020-11-12 | Cowlitz | Washington | 53015 | 968 | 8 |
725534 | 725534 | 2020-11-12 | Douglas | Washington | 53017 | 1553 | 11 |
725535 | 725535 | 2020-11-12 | Ferry | Washington | 53019 | 38 | 1 |
725536 | 725536 | 2020-11-12 | Franklin | Washington | 53021 | 5438 | 70 |
725537 | 725537 | 2020-11-12 | Garfield | Washington | 53023 | 46 | 0 |
725538 | 725538 | 2020-11-12 | Grant | Washington | 53025 | 3890 | 29 |
725539 | 725539 | 2020-11-12 | Grays Harbor | Washington | 53027 | 827 | 15 |
725540 | 725540 | 2020-11-12 | Island | Washington | 53029 | 470 | 15 |
725541 | 725541 | 2020-11-12 | Jefferson | Washington | 53031 | 103 | 0 |
725542 | 725542 | 2020-11-12 | King | Washington | 53033 | 32589 | 857 |
725543 | 725543 | 2020-11-12 | Kitsap | Washington | 53035 | 1846 | 27 |
725544 | 725544 | 2020-11-12 | Kittitas | Washington | 53037 | 790 | 22 |
725545 | 725545 | 2020-11-12 | Klickitat | Washington | 53039 | 226 | 3 |
725546 | 725546 | 2020-11-12 | Lewis | Washington | 53041 | 860 | 13 |
725547 | 725547 | 2020-11-12 | Lincoln | Washington | 53043 | 88 | 2 |
725548 | 725548 | 2020-11-12 | Mason | Washington | 53045 | 592 | 10 |
725549 | 725549 | 2020-11-12 | Okanogan | Washington | 53047 | 1191 | 14 |
725550 | 725550 | 2020-11-12 | Pacific | Washington | 53049 | 164 | 3 |
725551 | 725551 | 2020-11-12 | Pend Oreille | Washington | 53051 | 170 | 1 |
725552 | 725552 | 2020-11-12 | Pierce | Washington | 53053 | 13734 | 278 |
725553 | 725553 | 2020-11-12 | San Juan | Washington | 53055 | 41 | 0 |
725554 | 725554 | 2020-11-12 | Skagit | Washington | 53057 | 1513 | 26 |
725555 | 725555 | 2020-11-12 | Skamania | Washington | 53059 | 80 | 1 |
725556 | 725556 | 2020-11-12 | Snohomish | Washington | 53061 | 12013 | 259 |
725557 | 725557 | 2020-11-12 | Spokane | Washington | 53063 | 11904 | 224 |
725558 | 725558 | 2020-11-12 | Stevens | Washington | 53065 | 380 | 6 |
725559 | 725559 | 2020-11-12 | Thurston | Washington | 53067 | 2282 | 40 |
725560 | 725560 | 2020-11-12 | Unknown | Washington | 2 | 2 | |
725561 | 725561 | 2020-11-12 | Wahkiakum | Washington | 53069 | 11 | 0 |
725562 | 725562 | 2020-11-12 | Walla Walla | Washington | 53071 | 1669 | 14 |
725563 | 725563 | 2020-11-12 | Whatcom | Washington | 53073 | 1786 | 63 |
725564 | 725564 | 2020-11-12 | Whitman | Washington | 53075 | 1986 | 23 |
725565 | 725565 | 2020-11-12 | Yakima | Washington | 53077 | 13477 | 294 |
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);