ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

4,264 rows where state = "Washington" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Washington · 4,264
Link rowid date ▲ county state fips cases deaths
294655 2020-07-03 Adams Washington 53001 147 0
294656 2020-07-03 Asotin Washington 53003 21 2
294657 2020-07-03 Benton Washington 53005 2059 84
294658 2020-07-03 Chelan Washington 53007 389 7
294659 2020-07-03 Clallam Washington 53009 42 0
294660 2020-07-03 Clark Washington 53011 901 30
294661 2020-07-03 Columbia Washington 53013 8 0
294662 2020-07-03 Cowlitz Washington 53015 207 0
294663 2020-07-03 Douglas Washington 53017 265 3
294664 2020-07-03 Ferry Washington 53019 1 0
294665 2020-07-03 Franklin Washington 53021 1930 33
294666 2020-07-03 Grant Washington 53025 646 5
294667 2020-07-03 Grays Harbor Washington 53027 26 0
294668 2020-07-03 Island Washington 53029 196 12
294669 2020-07-03 Jefferson Washington 53031 38 0
294670 2020-07-03 King Washington 53033 10721 620
294671 2020-07-03 Kitsap Washington 53035 239 2
294672 2020-07-03 Kittitas Washington 53037 140 0
294673 2020-07-03 Klickitat Washington 53039 66 3
294674 2020-07-03 Lewis Washington 53041 70 3
294675 2020-07-03 Lincoln Washington 53043 4 0
294676 2020-07-03 Mason Washington 53045 53 1
294677 2020-07-03 Okanogan Washington 53047 118 2
294678 2020-07-03 Pacific Washington 53049 18 1
294679 2020-07-03 Pend Oreille Washington 53051 4 0
294680 2020-07-03 Pierce Washington 53053 3048 105
294681 2020-07-03 San Juan Washington 53055 19 0
294682 2020-07-03 Skagit Washington 53057 532 15
294683 2020-07-03 Skamania Washington 53059 7 0
294684 2020-07-03 Snohomish Washington 53061 4112 172
294685 2020-07-03 Spokane Washington 53063 1533 41
294686 2020-07-03 Stevens Washington 53065 19 1
294687 2020-07-03 Thurston Washington 53067 288 7
294688 2020-07-03 Wahkiakum Washington 53069 5 0
294689 2020-07-03 Walla Walla Washington 53071 176 3
294690 2020-07-03 Whatcom Washington 53073 659 41
294691 2020-07-03 Whitman Washington 53075 43 0
294692 2020-07-03 Yakima Washington 53077 7667 160
291572 2020-07-02 Adams Washington 53001 146 0
291573 2020-07-02 Asotin Washington 53003 21 2
291574 2020-07-02 Benton Washington 53005 2026 82
291575 2020-07-02 Chelan Washington 53007 376 7
291576 2020-07-02 Clallam Washington 53009 41 0
291577 2020-07-02 Clark Washington 53011 901 30
291578 2020-07-02 Columbia Washington 53013 8 0
291579 2020-07-02 Cowlitz Washington 53015 202 0
291580 2020-07-02 Douglas Washington 53017 253 3
291581 2020-07-02 Ferry Washington 53019 1 0
291582 2020-07-02 Franklin Washington 53021 1887 33
291583 2020-07-02 Grant Washington 53025 634 5
291584 2020-07-02 Grays Harbor Washington 53027 26 0
291585 2020-07-02 Island Washington 53029 195 12
291586 2020-07-02 Jefferson Washington 53031 38 0
291587 2020-07-02 King Washington 53033 10598 617
291588 2020-07-02 Kitsap Washington 53035 230 2
291589 2020-07-02 Kittitas Washington 53037 140 0
291590 2020-07-02 Klickitat Washington 53039 66 3
291591 2020-07-02 Lewis Washington 53041 71 3
291592 2020-07-02 Lincoln Washington 53043 4 0
291593 2020-07-02 Mason Washington 53045 52 1
291594 2020-07-02 Okanogan Washington 53047 118 2
291595 2020-07-02 Pacific Washington 53049 18 1
291596 2020-07-02 Pend Oreille Washington 53051 4 0
291597 2020-07-02 Pierce Washington 53053 2984 104
291598 2020-07-02 San Juan Washington 53055 19 0
291599 2020-07-02 Skagit Washington 53057 528 15
291600 2020-07-02 Skamania Washington 53059 6 0
291601 2020-07-02 Snohomish Washington 53061 4112 170
291602 2020-07-02 Spokane Washington 53063 1489 41
291603 2020-07-02 Stevens Washington 53065 18 1
291604 2020-07-02 Thurston Washington 53067 282 7
291605 2020-07-02 Wahkiakum Washington 53069 5 0
291606 2020-07-02 Walla Walla Washington 53071 176 3
291607 2020-07-02 Whatcom Washington 53073 649 40
291608 2020-07-02 Whitman Washington 53075 41 0
291609 2020-07-02 Yakima Washington 53077 7556 159
288496 2020-07-01 Adams Washington 53001 142 0
288497 2020-07-01 Asotin Washington 53003 21 2
288498 2020-07-01 Benton Washington 53005 2051 82
288499 2020-07-01 Chelan Washington 53007 348 7
288500 2020-07-01 Clallam Washington 53009 36 0
288501 2020-07-01 Clark Washington 53011 883 30
288502 2020-07-01 Columbia Washington 53013 8 0
288503 2020-07-01 Cowlitz Washington 53015 187 0
288504 2020-07-01 Douglas Washington 53017 245 3
288505 2020-07-01 Ferry Washington 53019 1 0
288506 2020-07-01 Franklin Washington 53021 1842 33
288507 2020-07-01 Grant Washington 53025 621 5
288508 2020-07-01 Grays Harbor Washington 53027 26 0
288509 2020-07-01 Island Washington 53029 195 12
288510 2020-07-01 Jefferson Washington 53031 38 0
288511 2020-07-01 King Washington 53033 10358 614
288512 2020-07-01 Kitsap Washington 53035 225 2
288513 2020-07-01 Kittitas Washington 53037 131 0
288514 2020-07-01 Klickitat Washington 53039 59 3
288515 2020-07-01 Lewis Washington 53041 68 3
288516 2020-07-01 Lincoln Washington 53043 4 0
288517 2020-07-01 Mason Washington 53045 51 1
288518 2020-07-01 Okanogan Washington 53047 116 2
288519 2020-07-01 Pacific Washington 53049 17 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 946.018ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette