ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
170 rows where cases = 3 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 |
---|---|---|---|---|---|---|---|
286913 | 286913 | 2020-06-29 | Lincoln | Washington | 53043 | 3 | 0 |
283767 | 283767 | 2020-06-28 | Lincoln | Washington | 53043 | 3 | 0 |
283771 | 283771 | 2020-06-28 | Pend Oreille | Washington | 53051 | 3 | 0 |
280621 | 280621 | 2020-06-27 | Lincoln | Washington | 53043 | 3 | 0 |
280625 | 280625 | 2020-06-27 | Pend Oreille | Washington | 53051 | 3 | 0 |
277477 | 277477 | 2020-06-26 | Pend Oreille | Washington | 53051 | 3 | 0 |
274329 | 274329 | 2020-06-25 | Pend Oreille | Washington | 53051 | 3 | 0 |
274333 | 274333 | 2020-06-25 | Skamania | Washington | 53059 | 3 | 0 |
271189 | 271189 | 2020-06-24 | Pend Oreille | Washington | 53051 | 3 | 0 |
271193 | 271193 | 2020-06-24 | Skamania | Washington | 53059 | 3 | 0 |
268055 | 268055 | 2020-06-23 | Pend Oreille | Washington | 53051 | 3 | 0 |
264926 | 264926 | 2020-06-22 | Pend Oreille | Washington | 53051 | 3 | 0 |
264930 | 264930 | 2020-06-22 | Skamania | Washington | 53059 | 3 | 0 |
261797 | 261797 | 2020-06-21 | Pend Oreille | Washington | 53051 | 3 | 0 |
258670 | 258670 | 2020-06-20 | Pend Oreille | Washington | 53051 | 3 | 0 |
255543 | 255543 | 2020-06-19 | Pend Oreille | Washington | 53051 | 3 | 0 |
252424 | 252424 | 2020-06-18 | Pend Oreille | Washington | 53051 | 3 | 0 |
252428 | 252428 | 2020-06-18 | Skamania | Washington | 53059 | 3 | 0 |
249309 | 249309 | 2020-06-17 | Pend Oreille | Washington | 53051 | 3 | 0 |
249313 | 249313 | 2020-06-17 | Skamania | Washington | 53059 | 3 | 0 |
246197 | 246197 | 2020-06-16 | Pend Oreille | Washington | 53051 | 3 | 0 |
246201 | 246201 | 2020-06-16 | Skamania | Washington | 53059 | 3 | 0 |
243084 | 243084 | 2020-06-15 | Pend Oreille | Washington | 53051 | 3 | 0 |
243088 | 243088 | 2020-06-15 | Skamania | Washington | 53059 | 3 | 0 |
239973 | 239973 | 2020-06-14 | Pend Oreille | Washington | 53051 | 3 | 0 |
239977 | 239977 | 2020-06-14 | Skamania | Washington | 53059 | 3 | 0 |
236865 | 236865 | 2020-06-13 | Pend Oreille | Washington | 53051 | 3 | 0 |
236869 | 236869 | 2020-06-13 | Skamania | Washington | 53059 | 3 | 0 |
233758 | 233758 | 2020-06-12 | Pend Oreille | Washington | 53051 | 3 | 0 |
233762 | 233762 | 2020-06-12 | Skamania | Washington | 53059 | 3 | 0 |
230653 | 230653 | 2020-06-11 | Pend Oreille | Washington | 53051 | 3 | 0 |
230657 | 230657 | 2020-06-11 | Skamania | Washington | 53059 | 3 | 0 |
227549 | 227549 | 2020-06-10 | Pend Oreille | Washington | 53051 | 3 | 0 |
227553 | 227553 | 2020-06-10 | Skamania | Washington | 53059 | 3 | 0 |
224449 | 224449 | 2020-06-09 | Pend Oreille | Washington | 53051 | 3 | 0 |
224453 | 224453 | 2020-06-09 | Skamania | Washington | 53059 | 3 | 0 |
221353 | 221353 | 2020-06-08 | Pend Oreille | Washington | 53051 | 3 | 0 |
221357 | 221357 | 2020-06-08 | Skamania | Washington | 53059 | 3 | 0 |
218261 | 218261 | 2020-06-07 | Pend Oreille | Washington | 53051 | 3 | 0 |
218265 | 218265 | 2020-06-07 | Skamania | Washington | 53059 | 3 | 0 |
215171 | 215171 | 2020-06-06 | Pend Oreille | Washington | 53051 | 3 | 0 |
215175 | 215175 | 2020-06-06 | Skamania | Washington | 53059 | 3 | 0 |
212084 | 212084 | 2020-06-05 | Pend Oreille | Washington | 53051 | 3 | 0 |
212088 | 212088 | 2020-06-05 | Skamania | Washington | 53059 | 3 | 0 |
208999 | 208999 | 2020-06-04 | Pend Oreille | Washington | 53051 | 3 | 0 |
209003 | 209003 | 2020-06-04 | Skamania | Washington | 53059 | 3 | 0 |
205917 | 205917 | 2020-06-03 | Pend Oreille | Washington | 53051 | 3 | 0 |
202838 | 202838 | 2020-06-02 | Pend Oreille | Washington | 53051 | 3 | 0 |
202842 | 202842 | 2020-06-02 | Skamania | Washington | 53059 | 3 | 0 |
199762 | 199762 | 2020-06-01 | Pend Oreille | Washington | 53051 | 3 | 0 |
199766 | 199766 | 2020-06-01 | Skamania | Washington | 53059 | 3 | 0 |
196689 | 196689 | 2020-05-31 | Pend Oreille | Washington | 53051 | 3 | 0 |
196693 | 196693 | 2020-05-31 | Skamania | Washington | 53059 | 3 | 0 |
193619 | 193619 | 2020-05-30 | Pend Oreille | Washington | 53051 | 3 | 0 |
193623 | 193623 | 2020-05-30 | Skamania | Washington | 53059 | 3 | 0 |
190553 | 190553 | 2020-05-29 | Pend Oreille | Washington | 53051 | 3 | 0 |
190557 | 190557 | 2020-05-29 | Skamania | Washington | 53059 | 3 | 0 |
187489 | 187489 | 2020-05-28 | Pend Oreille | Washington | 53051 | 3 | 0 |
187493 | 187493 | 2020-05-28 | Skamania | Washington | 53059 | 3 | 0 |
184432 | 184432 | 2020-05-27 | Pend Oreille | Washington | 53051 | 3 | 0 |
184436 | 184436 | 2020-05-27 | Skamania | Washington | 53059 | 3 | 0 |
181381 | 181381 | 2020-05-26 | Pend Oreille | Washington | 53051 | 3 | 0 |
181385 | 181385 | 2020-05-26 | Skamania | Washington | 53059 | 3 | 0 |
178337 | 178337 | 2020-05-25 | Pend Oreille | Washington | 53051 | 3 | 0 |
178341 | 178341 | 2020-05-25 | Skamania | Washington | 53059 | 3 | 0 |
175292 | 175292 | 2020-05-24 | Pend Oreille | Washington | 53051 | 3 | 0 |
175296 | 175296 | 2020-05-24 | Skamania | Washington | 53059 | 3 | 0 |
172253 | 172253 | 2020-05-23 | Skamania | Washington | 53059 | 3 | 0 |
169212 | 169212 | 2020-05-22 | Skamania | Washington | 53059 | 3 | 0 |
166176 | 166176 | 2020-05-21 | Skamania | Washington | 53059 | 3 | 0 |
163147 | 163147 | 2020-05-20 | Skamania | Washington | 53059 | 3 | 0 |
160119 | 160119 | 2020-05-19 | Skamania | Washington | 53059 | 3 | 0 |
157095 | 157095 | 2020-05-18 | Skamania | Washington | 53059 | 3 | 0 |
154078 | 154078 | 2020-05-17 | Skamania | Washington | 53059 | 3 | 0 |
151067 | 151067 | 2020-05-16 | Skamania | Washington | 53059 | 3 | 0 |
148058 | 148058 | 2020-05-15 | Skamania | Washington | 53059 | 3 | 0 |
145055 | 145055 | 2020-05-14 | Skamania | Washington | 53059 | 3 | 0 |
142058 | 142058 | 2020-05-13 | Skamania | Washington | 53059 | 3 | 0 |
139062 | 139062 | 2020-05-12 | Skamania | Washington | 53059 | 3 | 0 |
136071 | 136071 | 2020-05-11 | Skamania | Washington | 53059 | 3 | 0 |
133081 | 133081 | 2020-05-10 | Skamania | Washington | 53059 | 3 | 0 |
133086 | 133086 | 2020-05-10 | Wahkiakum | Washington | 53069 | 3 | 0 |
130091 | 130091 | 2020-05-09 | Skamania | Washington | 53059 | 3 | 0 |
130096 | 130096 | 2020-05-09 | Wahkiakum | Washington | 53069 | 3 | 0 |
127101 | 127101 | 2020-05-08 | Skamania | Washington | 53059 | 3 | 0 |
127106 | 127106 | 2020-05-08 | Wahkiakum | Washington | 53069 | 3 | 0 |
124116 | 124116 | 2020-05-07 | Skamania | Washington | 53059 | 3 | 0 |
121136 | 121136 | 2020-05-06 | Skamania | Washington | 53059 | 3 | 0 |
118172 | 118172 | 2020-05-05 | Skamania | Washington | 53059 | 3 | 0 |
115213 | 115213 | 2020-05-04 | Skamania | Washington | 53059 | 3 | 0 |
112330 | 112330 | 2020-05-03 | Skamania | Washington | 53059 | 3 | 0 |
109456 | 109456 | 2020-05-02 | Skamania | Washington | 53059 | 3 | 0 |
106587 | 106587 | 2020-05-01 | Skamania | Washington | 53059 | 3 | 0 |
103723 | 103723 | 2020-04-30 | Skamania | Washington | 53059 | 3 | 0 |
100868 | 100868 | 2020-04-29 | Skamania | Washington | 53059 | 3 | 0 |
98018 | 98018 | 2020-04-28 | Skamania | Washington | 53059 | 3 | 0 |
95173 | 95173 | 2020-04-27 | Skamania | Washington | 53059 | 3 | 0 |
92344 | 92344 | 2020-04-26 | Skamania | Washington | 53059 | 3 | 0 |
89527 | 89527 | 2020-04-25 | Skamania | Washington | 53059 | 3 | 0 |
86712 | 86712 | 2020-04-24 | Skamania | Washington | 53059 | 3 | 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);