ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where "date" is on date 2020-03-28 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
17573 | 17573 | 2020-03-28 | Adams | Washington | 53001 | 5 | 0 |
17574 | 17574 | 2020-03-28 | Benton | Washington | 53005 | 56 | 5 |
17575 | 17575 | 2020-03-28 | Chelan | Washington | 53007 | 14 | 2 |
17576 | 17576 | 2020-03-28 | Clallam | Washington | 53009 | 5 | 0 |
17577 | 17577 | 2020-03-28 | Clark | Washington | 53011 | 82 | 6 |
17578 | 17578 | 2020-03-28 | Columbia | Washington | 53013 | 1 | 0 |
17579 | 17579 | 2020-03-28 | Cowlitz | Washington | 53015 | 10 | 0 |
17580 | 17580 | 2020-03-28 | Douglas | Washington | 53017 | 5 | 0 |
17581 | 17581 | 2020-03-28 | Ferry | Washington | 53019 | 1 | 0 |
17582 | 17582 | 2020-03-28 | Franklin | Washington | 53021 | 16 | 0 |
17583 | 17583 | 2020-03-28 | Grant | Washington | 53025 | 44 | 1 |
17584 | 17584 | 2020-03-28 | Grays Harbor | Washington | 53027 | 1 | 0 |
17585 | 17585 | 2020-03-28 | Island | Washington | 53029 | 92 | 1 |
17586 | 17586 | 2020-03-28 | Jefferson | Washington | 53031 | 13 | 0 |
17587 | 17587 | 2020-03-28 | King | Washington | 53033 | 2079 | 138 |
17588 | 17588 | 2020-03-28 | Kitsap | Washington | 53035 | 49 | 1 |
17589 | 17589 | 2020-03-28 | Kittitas | Washington | 53037 | 8 | 0 |
17590 | 17590 | 2020-03-28 | Klickitat | Washington | 53039 | 7 | 0 |
17591 | 17591 | 2020-03-28 | Lewis | Washington | 53041 | 7 | 0 |
17592 | 17592 | 2020-03-28 | Lincoln | Washington | 53043 | 1 | 0 |
17593 | 17593 | 2020-03-28 | Mason | Washington | 53045 | 2 | 0 |
17594 | 17594 | 2020-03-28 | Okanogan | Washington | 53047 | 3 | 0 |
17595 | 17595 | 2020-03-28 | Pierce | Washington | 53053 | 282 | 5 |
17596 | 17596 | 2020-03-28 | San Juan | Washington | 53055 | 4 | 0 |
17597 | 17597 | 2020-03-28 | Skagit | Washington | 53057 | 97 | 3 |
17598 | 17598 | 2020-03-28 | Skamania | Washington | 53059 | 1 | 0 |
17599 | 17599 | 2020-03-28 | Snohomish | Washington | 53061 | 912 | 23 |
17600 | 17600 | 2020-03-28 | Spokane | Washington | 53063 | 108 | 2 |
17601 | 17601 | 2020-03-28 | Stevens | Washington | 53065 | 3 | 0 |
17602 | 17602 | 2020-03-28 | Thurston | Washington | 53067 | 33 | 0 |
17603 | 17603 | 2020-03-28 | Unknown | Washington | 158 | 0 | |
17604 | 17604 | 2020-03-28 | Walla Walla | Washington | 53071 | 4 | 0 |
17605 | 17605 | 2020-03-28 | Whatcom | Washington | 53073 | 102 | 4 |
17606 | 17606 | 2020-03-28 | Whitman | Washington | 53075 | 6 | 0 |
17607 | 17607 | 2020-03-28 | Yakima | Washington | 53077 | 100 | 2 |
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);