ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
187 rows where cases = 4 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
518063 | 518063 | 2020-09-09 | Garfield | Washington | 53023 | 4 | 0 |
514828 | 514828 | 2020-09-08 | Garfield | Washington | 53023 | 4 | 0 |
511595 | 511595 | 2020-09-07 | Garfield | Washington | 53023 | 4 | 0 |
508362 | 508362 | 2020-09-06 | Garfield | Washington | 53023 | 4 | 0 |
505130 | 505130 | 2020-09-05 | Garfield | Washington | 53023 | 4 | 0 |
501896 | 501896 | 2020-09-04 | Garfield | Washington | 53023 | 4 | 0 |
498662 | 498662 | 2020-09-03 | Garfield | Washington | 53023 | 4 | 0 |
495429 | 495429 | 2020-09-02 | Garfield | Washington | 53023 | 4 | 0 |
492195 | 492195 | 2020-09-01 | Garfield | Washington | 53023 | 4 | 0 |
488962 | 488962 | 2020-08-31 | Garfield | Washington | 53023 | 4 | 0 |
485729 | 485729 | 2020-08-30 | Garfield | Washington | 53023 | 4 | 0 |
482494 | 482494 | 2020-08-29 | Garfield | Washington | 53023 | 4 | 0 |
479260 | 479260 | 2020-08-28 | Garfield | Washington | 53023 | 4 | 0 |
476027 | 476027 | 2020-08-27 | Garfield | Washington | 53023 | 4 | 0 |
472794 | 472794 | 2020-08-26 | Garfield | Washington | 53023 | 4 | 0 |
469562 | 469562 | 2020-08-25 | Garfield | Washington | 53023 | 4 | 0 |
466333 | 466333 | 2020-08-24 | Garfield | Washington | 53023 | 4 | 0 |
463104 | 463104 | 2020-08-23 | Garfield | Washington | 53023 | 4 | 0 |
459875 | 459875 | 2020-08-22 | Garfield | Washington | 53023 | 4 | 0 |
456648 | 456648 | 2020-08-21 | Garfield | Washington | 53023 | 4 | 0 |
453420 | 453420 | 2020-08-20 | Garfield | Washington | 53023 | 4 | 0 |
450192 | 450192 | 2020-08-19 | Garfield | Washington | 53023 | 4 | 0 |
446964 | 446964 | 2020-08-18 | Garfield | Washington | 53023 | 4 | 0 |
443737 | 443737 | 2020-08-17 | Garfield | Washington | 53023 | 4 | 0 |
440511 | 440511 | 2020-08-16 | Garfield | Washington | 53023 | 4 | 0 |
437285 | 437285 | 2020-08-15 | Garfield | Washington | 53023 | 4 | 0 |
434059 | 434059 | 2020-08-14 | Garfield | Washington | 53023 | 4 | 0 |
430834 | 430834 | 2020-08-13 | Garfield | Washington | 53023 | 4 | 0 |
427606 | 427606 | 2020-08-12 | Garfield | Washington | 53023 | 4 | 0 |
424382 | 424382 | 2020-08-11 | Garfield | Washington | 53023 | 4 | 0 |
421161 | 421161 | 2020-08-10 | Garfield | Washington | 53023 | 4 | 0 |
417940 | 417940 | 2020-08-09 | Garfield | Washington | 53023 | 4 | 0 |
340850 | 340850 | 2020-07-16 | Ferry | Washington | 53019 | 4 | 0 |
337654 | 337654 | 2020-07-15 | Ferry | Washington | 53019 | 4 | 0 |
337666 | 337666 | 2020-07-15 | Lincoln | Washington | 53043 | 4 | 0 |
334459 | 334459 | 2020-07-14 | Ferry | Washington | 53019 | 4 | 0 |
334471 | 334471 | 2020-07-14 | Lincoln | Washington | 53043 | 4 | 0 |
331266 | 331266 | 2020-07-13 | Ferry | Washington | 53019 | 4 | 0 |
331278 | 331278 | 2020-07-13 | Lincoln | Washington | 53043 | 4 | 0 |
328080 | 328080 | 2020-07-12 | Ferry | Washington | 53019 | 4 | 0 |
328092 | 328092 | 2020-07-12 | Lincoln | Washington | 53043 | 4 | 0 |
324906 | 324906 | 2020-07-11 | Lincoln | Washington | 53043 | 4 | 0 |
321725 | 321725 | 2020-07-10 | Lincoln | Washington | 53043 | 4 | 0 |
318546 | 318546 | 2020-07-09 | Lincoln | Washington | 53043 | 4 | 0 |
315373 | 315373 | 2020-07-08 | Lincoln | Washington | 53043 | 4 | 0 |
312198 | 312198 | 2020-07-07 | Lincoln | Washington | 53043 | 4 | 0 |
309029 | 309029 | 2020-07-06 | Lincoln | Washington | 53043 | 4 | 0 |
305861 | 305861 | 2020-07-05 | Lincoln | Washington | 53043 | 4 | 0 |
302697 | 302697 | 2020-07-04 | Lincoln | Washington | 53043 | 4 | 0 |
299533 | 299533 | 2020-07-03 | Lincoln | Washington | 53043 | 4 | 0 |
299537 | 299537 | 2020-07-03 | Pend Oreille | Washington | 53051 | 4 | 0 |
296371 | 296371 | 2020-07-02 | Lincoln | Washington | 53043 | 4 | 0 |
296375 | 296375 | 2020-07-02 | Pend Oreille | Washington | 53051 | 4 | 0 |
293216 | 293216 | 2020-07-01 | Lincoln | Washington | 53043 | 4 | 0 |
293220 | 293220 | 2020-07-01 | Pend Oreille | Washington | 53051 | 4 | 0 |
290063 | 290063 | 2020-06-30 | Lincoln | Washington | 53043 | 4 | 0 |
290067 | 290067 | 2020-06-30 | Pend Oreille | Washington | 53051 | 4 | 0 |
286917 | 286917 | 2020-06-29 | Pend Oreille | Washington | 53051 | 4 | 0 |
286921 | 286921 | 2020-06-29 | Skamania | Washington | 53059 | 4 | 0 |
283775 | 283775 | 2020-06-28 | Skamania | Washington | 53059 | 4 | 0 |
280629 | 280629 | 2020-06-27 | Skamania | Washington | 53059 | 4 | 0 |
277481 | 277481 | 2020-06-26 | Skamania | Washington | 53059 | 4 | 0 |
271198 | 271198 | 2020-06-24 | Wahkiakum | Washington | 53069 | 4 | 0 |
268059 | 268059 | 2020-06-23 | Skamania | Washington | 53059 | 4 | 0 |
268064 | 268064 | 2020-06-23 | Wahkiakum | Washington | 53069 | 4 | 0 |
264935 | 264935 | 2020-06-22 | Wahkiakum | Washington | 53069 | 4 | 0 |
261806 | 261806 | 2020-06-21 | Wahkiakum | Washington | 53069 | 4 | 0 |
258679 | 258679 | 2020-06-20 | Wahkiakum | Washington | 53069 | 4 | 0 |
255552 | 255552 | 2020-06-19 | Wahkiakum | Washington | 53069 | 4 | 0 |
252433 | 252433 | 2020-06-18 | Wahkiakum | Washington | 53069 | 4 | 0 |
249318 | 249318 | 2020-06-17 | Wahkiakum | Washington | 53069 | 4 | 0 |
246206 | 246206 | 2020-06-16 | Wahkiakum | Washington | 53069 | 4 | 0 |
243093 | 243093 | 2020-06-15 | Wahkiakum | Washington | 53069 | 4 | 0 |
239982 | 239982 | 2020-06-14 | Wahkiakum | Washington | 53069 | 4 | 0 |
236874 | 236874 | 2020-06-13 | Wahkiakum | Washington | 53069 | 4 | 0 |
233767 | 233767 | 2020-06-12 | Wahkiakum | Washington | 53069 | 4 | 0 |
230662 | 230662 | 2020-06-11 | Wahkiakum | Washington | 53069 | 4 | 0 |
227558 | 227558 | 2020-06-10 | Wahkiakum | Washington | 53069 | 4 | 0 |
224458 | 224458 | 2020-06-09 | Wahkiakum | Washington | 53069 | 4 | 0 |
221362 | 221362 | 2020-06-08 | Wahkiakum | Washington | 53069 | 4 | 0 |
218270 | 218270 | 2020-06-07 | Wahkiakum | Washington | 53069 | 4 | 0 |
215180 | 215180 | 2020-06-06 | Wahkiakum | Washington | 53069 | 4 | 0 |
212093 | 212093 | 2020-06-05 | Wahkiakum | Washington | 53069 | 4 | 0 |
209008 | 209008 | 2020-06-04 | Wahkiakum | Washington | 53069 | 4 | 0 |
205921 | 205921 | 2020-06-03 | Skamania | Washington | 53059 | 4 | 0 |
205926 | 205926 | 2020-06-03 | Wahkiakum | Washington | 53069 | 4 | 0 |
202847 | 202847 | 2020-06-02 | Wahkiakum | Washington | 53069 | 4 | 0 |
199771 | 199771 | 2020-06-01 | Wahkiakum | Washington | 53069 | 4 | 0 |
196698 | 196698 | 2020-05-31 | Wahkiakum | Washington | 53069 | 4 | 0 |
193628 | 193628 | 2020-05-30 | Wahkiakum | Washington | 53069 | 4 | 0 |
190562 | 190562 | 2020-05-29 | Wahkiakum | Washington | 53069 | 4 | 0 |
187498 | 187498 | 2020-05-28 | Wahkiakum | Washington | 53069 | 4 | 0 |
184441 | 184441 | 2020-05-27 | Wahkiakum | Washington | 53069 | 4 | 0 |
181390 | 181390 | 2020-05-26 | Wahkiakum | Washington | 53069 | 4 | 0 |
178346 | 178346 | 2020-05-25 | Wahkiakum | Washington | 53069 | 4 | 0 |
175301 | 175301 | 2020-05-24 | Wahkiakum | Washington | 53069 | 4 | 0 |
172249 | 172249 | 2020-05-23 | Pend Oreille | Washington | 53051 | 4 | 0 |
172258 | 172258 | 2020-05-23 | Wahkiakum | Washington | 53069 | 4 | 0 |
169217 | 169217 | 2020-05-22 | Wahkiakum | Washington | 53069 | 4 | 0 |
166181 | 166181 | 2020-05-21 | Wahkiakum | Washington | 53069 | 4 | 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);