ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where cases = 11 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 |
---|---|---|---|---|---|---|---|
738539 | 738539 | 2020-11-16 | Wahkiakum | Washington | 53069 | 11 | 0 |
735295 | 735295 | 2020-11-15 | Wahkiakum | Washington | 53069 | 11 | 0 |
732049 | 732049 | 2020-11-14 | Wahkiakum | Washington | 53069 | 11 | 0 |
728804 | 728804 | 2020-11-13 | Wahkiakum | Washington | 53069 | 11 | 0 |
725561 | 725561 | 2020-11-12 | Wahkiakum | Washington | 53069 | 11 | 0 |
722318 | 722318 | 2020-11-11 | Wahkiakum | Washington | 53069 | 11 | 0 |
719075 | 719075 | 2020-11-10 | Wahkiakum | Washington | 53069 | 11 | 0 |
715832 | 715832 | 2020-11-09 | Wahkiakum | Washington | 53069 | 11 | 0 |
712588 | 712588 | 2020-11-08 | Wahkiakum | Washington | 53069 | 11 | 0 |
709344 | 709344 | 2020-11-07 | Wahkiakum | Washington | 53069 | 11 | 0 |
706100 | 706100 | 2020-11-06 | Wahkiakum | Washington | 53069 | 11 | 0 |
702857 | 702857 | 2020-11-05 | Wahkiakum | Washington | 53069 | 11 | 0 |
699614 | 699614 | 2020-11-04 | Wahkiakum | Washington | 53069 | 11 | 0 |
696370 | 696370 | 2020-11-03 | Wahkiakum | Washington | 53069 | 11 | 0 |
693128 | 693128 | 2020-11-02 | Wahkiakum | Washington | 53069 | 11 | 0 |
689884 | 689884 | 2020-11-01 | Wahkiakum | Washington | 53069 | 11 | 0 |
579589 | 579589 | 2020-09-28 | Garfield | Washington | 53023 | 11 | 0 |
576348 | 576348 | 2020-09-27 | Garfield | Washington | 53023 | 11 | 0 |
573104 | 573104 | 2020-09-26 | Garfield | Washington | 53023 | 11 | 0 |
569862 | 569862 | 2020-09-25 | Garfield | Washington | 53023 | 11 | 0 |
566621 | 566621 | 2020-09-24 | Garfield | Washington | 53023 | 11 | 0 |
563380 | 563380 | 2020-09-23 | Garfield | Washington | 53023 | 11 | 0 |
560141 | 560141 | 2020-09-22 | Garfield | Washington | 53023 | 11 | 0 |
556905 | 556905 | 2020-09-21 | Garfield | Washington | 53023 | 11 | 0 |
553668 | 553668 | 2020-09-20 | Garfield | Washington | 53023 | 11 | 0 |
550429 | 550429 | 2020-09-19 | Garfield | Washington | 53023 | 11 | 0 |
547190 | 547190 | 2020-09-18 | Garfield | Washington | 53023 | 11 | 0 |
543953 | 543953 | 2020-09-17 | Garfield | Washington | 53023 | 11 | 0 |
540717 | 540717 | 2020-09-16 | Garfield | Washington | 53023 | 11 | 0 |
379323 | 379323 | 2020-07-28 | Ferry | Washington | 53019 | 11 | 0 |
236864 | 236864 | 2020-06-13 | Pacific | Washington | 53049 | 11 | 1 |
233757 | 233757 | 2020-06-12 | Pacific | Washington | 53049 | 11 | 1 |
202845 | 202845 | 2020-06-02 | Stevens | Washington | 53065 | 11 | 1 |
199769 | 199769 | 2020-06-01 | Stevens | Washington | 53065 | 11 | 1 |
196696 | 196696 | 2020-05-31 | Stevens | Washington | 53065 | 11 | 1 |
193626 | 193626 | 2020-05-30 | Stevens | Washington | 53065 | 11 | 1 |
190560 | 190560 | 2020-05-29 | Stevens | Washington | 53065 | 11 | 1 |
187496 | 187496 | 2020-05-28 | Stevens | Washington | 53065 | 11 | 1 |
67193 | 67193 | 2020-04-17 | Asotin | Washington | 53003 | 11 | 0 |
59004 | 59004 | 2020-04-14 | Grays Harbor | Washington | 53027 | 11 | 0 |
56298 | 56298 | 2020-04-13 | Grays Harbor | Washington | 53027 | 11 | 0 |
53608 | 53608 | 2020-04-12 | Grays Harbor | Washington | 53027 | 11 | 0 |
50933 | 50933 | 2020-04-11 | Grays Harbor | Washington | 53027 | 11 | 0 |
48267 | 48267 | 2020-04-10 | Clallam | Washington | 53009 | 11 | 0 |
45640 | 45640 | 2020-04-09 | Clallam | Washington | 53009 | 11 | 0 |
45654 | 45654 | 2020-04-09 | Klickitat | Washington | 53039 | 11 | 1 |
43058 | 43058 | 2020-04-08 | Klickitat | Washington | 53039 | 11 | 1 |
40489 | 40489 | 2020-04-07 | Klickitat | Washington | 53039 | 11 | 1 |
40496 | 40496 | 2020-04-07 | San Juan | Washington | 53055 | 11 | 0 |
37954 | 37954 | 2020-04-06 | Klickitat | Washington | 53039 | 11 | 1 |
35469 | 35469 | 2020-04-05 | Kittitas | Washington | 53037 | 11 | 0 |
35488 | 35488 | 2020-04-05 | Whitman | Washington | 53075 | 11 | 0 |
33050 | 33050 | 2020-04-04 | Whitman | Washington | 53075 | 11 | 0 |
30649 | 30649 | 2020-04-03 | Whitman | Washington | 53075 | 11 | 0 |
28296 | 28296 | 2020-04-02 | Whitman | Washington | 53075 | 11 | 0 |
15706 | 15706 | 2020-03-27 | Jefferson | Washington | 53031 | 11 | 0 |
13927 | 13927 | 2020-03-26 | Chelan | Washington | 53007 | 11 | 1 |
13938 | 13938 | 2020-03-26 | Jefferson | Washington | 53031 | 11 | 0 |
12277 | 12277 | 2020-03-25 | Chelan | Washington | 53007 | 11 | 1 |
9430 | 9430 | 2020-03-23 | Thurston | Washington | 53067 | 11 | 0 |
8205 | 8205 | 2020-03-22 | Thurston | Washington | 53067 | 11 | 0 |
7051 | 7051 | 2020-03-21 | Grant | Washington | 53025 | 11 | 0 |
6020 | 6020 | 2020-03-20 | Grant | Washington | 53025 | 11 | 0 |
6035 | 6035 | 2020-03-20 | Spokane | Washington | 53063 | 11 | 0 |
6039 | 6039 | 2020-03-20 | Whatcom | Washington | 53073 | 11 | 1 |
422 | 422 | 2020-03-01 | King | Washington | 53033 | 11 | 3 |
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);