ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where cases = 20 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
414729 | 414729 | 2020-08-08 | Lincoln | Washington | 53043 | 20 | 0 |
411509 | 411509 | 2020-08-07 | Lincoln | Washington | 53043 | 20 | 0 |
408278 | 408278 | 2020-08-06 | Ferry | Washington | 53019 | 20 | 0 |
405058 | 405058 | 2020-08-05 | Ferry | Washington | 53019 | 20 | 0 |
401840 | 401840 | 2020-08-04 | Ferry | Washington | 53019 | 20 | 0 |
328098 | 328098 | 2020-07-12 | San Juan | Washington | 53055 | 20 | 0 |
324912 | 324912 | 2020-07-11 | San Juan | Washington | 53055 | 20 | 0 |
321731 | 321731 | 2020-07-10 | San Juan | Washington | 53055 | 20 | 0 |
318552 | 318552 | 2020-07-09 | San Juan | Washington | 53055 | 20 | 0 |
315379 | 315379 | 2020-07-08 | San Juan | Washington | 53055 | 20 | 0 |
315384 | 315384 | 2020-07-08 | Stevens | Washington | 53065 | 20 | 1 |
312204 | 312204 | 2020-07-07 | San Juan | Washington | 53055 | 20 | 0 |
312209 | 312209 | 2020-07-07 | Stevens | Washington | 53065 | 20 | 1 |
309035 | 309035 | 2020-07-06 | San Juan | Washington | 53055 | 20 | 0 |
309040 | 309040 | 2020-07-06 | Stevens | Washington | 53065 | 20 | 1 |
305872 | 305872 | 2020-07-05 | Stevens | Washington | 53065 | 20 | 1 |
280602 | 280602 | 2020-06-27 | Asotin | Washington | 53003 | 20 | 2 |
277454 | 277454 | 2020-06-26 | Asotin | Washington | 53003 | 20 | 2 |
274306 | 274306 | 2020-06-25 | Asotin | Washington | 53003 | 20 | 2 |
271166 | 271166 | 2020-06-24 | Asotin | Washington | 53003 | 20 | 2 |
271191 | 271191 | 2020-06-24 | San Juan | Washington | 53055 | 20 | 0 |
268032 | 268032 | 2020-06-23 | Asotin | Washington | 53003 | 20 | 2 |
264903 | 264903 | 2020-06-22 | Asotin | Washington | 53003 | 20 | 2 |
261774 | 261774 | 2020-06-21 | Asotin | Washington | 53003 | 20 | 2 |
258647 | 258647 | 2020-06-20 | Asotin | Washington | 53003 | 20 | 2 |
255520 | 255520 | 2020-06-19 | Asotin | Washington | 53003 | 20 | 2 |
252401 | 252401 | 2020-06-18 | Asotin | Washington | 53003 | 20 | 2 |
249286 | 249286 | 2020-06-17 | Asotin | Washington | 53003 | 20 | 2 |
246174 | 246174 | 2020-06-16 | Asotin | Washington | 53003 | 20 | 2 |
246185 | 246185 | 2020-06-16 | Grays Harbor | Washington | 53027 | 20 | 0 |
243061 | 243061 | 2020-06-15 | Asotin | Washington | 53003 | 20 | 2 |
243072 | 243072 | 2020-06-15 | Grays Harbor | Washington | 53027 | 20 | 0 |
239950 | 239950 | 2020-06-14 | Asotin | Washington | 53003 | 20 | 2 |
239961 | 239961 | 2020-06-14 | Grays Harbor | Washington | 53027 | 20 | 0 |
236842 | 236842 | 2020-06-13 | Asotin | Washington | 53003 | 20 | 2 |
236853 | 236853 | 2020-06-13 | Grays Harbor | Washington | 53027 | 20 | 0 |
233735 | 233735 | 2020-06-12 | Asotin | Washington | 53003 | 20 | 2 |
233746 | 233746 | 2020-06-12 | Grays Harbor | Washington | 53027 | 20 | 0 |
230630 | 230630 | 2020-06-11 | Asotin | Washington | 53003 | 20 | 2 |
227526 | 227526 | 2020-06-10 | Asotin | Washington | 53003 | 20 | 2 |
215183 | 215183 | 2020-06-06 | Whitman | Washington | 53075 | 20 | 0 |
212096 | 212096 | 2020-06-05 | Whitman | Washington | 53075 | 20 | 0 |
209011 | 209011 | 2020-06-04 | Whitman | Washington | 53075 | 20 | 0 |
205929 | 205929 | 2020-06-03 | Whitman | Washington | 53075 | 20 | 0 |
202850 | 202850 | 2020-06-02 | Whitman | Washington | 53075 | 20 | 0 |
199774 | 199774 | 2020-06-01 | Whitman | Washington | 53075 | 20 | 0 |
196701 | 196701 | 2020-05-31 | Whitman | Washington | 53075 | 20 | 0 |
193631 | 193631 | 2020-05-30 | Whitman | Washington | 53075 | 20 | 0 |
190565 | 190565 | 2020-05-29 | Whitman | Washington | 53075 | 20 | 0 |
187501 | 187501 | 2020-05-28 | Whitman | Washington | 53075 | 20 | 0 |
184444 | 184444 | 2020-05-27 | Whitman | Washington | 53075 | 20 | 0 |
181393 | 181393 | 2020-05-26 | Whitman | Washington | 53075 | 20 | 0 |
136061 | 136061 | 2020-05-11 | Klickitat | Washington | 53039 | 20 | 3 |
95167 | 95167 | 2020-04-27 | Okanogan | Washington | 53047 | 20 | 1 |
61732 | 61732 | 2020-04-15 | Mason | Washington | 53045 | 20 | 0 |
56294 | 56294 | 2020-04-13 | Douglas | Washington | 53017 | 20 | 0 |
33028 | 33028 | 2020-04-04 | Jefferson | Washington | 53031 | 20 | 0 |
30614 | 30614 | 2020-04-03 | Adams | Washington | 53001 | 20 | 0 |
30617 | 30617 | 2020-04-03 | Chelan | Washington | 53007 | 20 | 3 |
28262 | 28262 | 2020-04-02 | Adams | Washington | 53001 | 20 | 0 |
10767 | 10767 | 2020-03-24 | Kitsap | Washington | 53035 | 20 | 0 |
9418 | 9418 | 2020-03-23 | Kitsap | Washington | 53035 | 20 | 0 |
8193 | 8193 | 2020-03-22 | Kitsap | Washington | 53035 | 20 | 0 |
8203 | 8203 | 2020-03-22 | Spokane | Washington | 53063 | 20 | 0 |
7071 | 7071 | 2020-03-21 | Yakima | Washington | 53077 | 20 | 0 |
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);