ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 3, fips = 53071 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 |
---|---|---|---|---|---|---|---|
360086 | 360086 | 2020-07-22 | Walla Walla | Washington | 53071 | 312 | 3 |
356881 | 356881 | 2020-07-21 | Walla Walla | Washington | 53071 | 304 | 3 |
353678 | 353678 | 2020-07-20 | Walla Walla | Washington | 53071 | 303 | 3 |
350476 | 350476 | 2020-07-19 | Walla Walla | Washington | 53071 | 294 | 3 |
347275 | 347275 | 2020-07-18 | Walla Walla | Washington | 53071 | 282 | 3 |
344075 | 344075 | 2020-07-17 | Walla Walla | Washington | 53071 | 266 | 3 |
340876 | 340876 | 2020-07-16 | Walla Walla | Washington | 53071 | 262 | 3 |
337680 | 337680 | 2020-07-15 | Walla Walla | Washington | 53071 | 250 | 3 |
334485 | 334485 | 2020-07-14 | Walla Walla | Washington | 53071 | 243 | 3 |
331292 | 331292 | 2020-07-13 | Walla Walla | Washington | 53071 | 234 | 3 |
328106 | 328106 | 2020-07-12 | Walla Walla | Washington | 53071 | 219 | 3 |
324920 | 324920 | 2020-07-11 | Walla Walla | Washington | 53071 | 219 | 3 |
321739 | 321739 | 2020-07-10 | Walla Walla | Washington | 53071 | 212 | 3 |
318560 | 318560 | 2020-07-09 | Walla Walla | Washington | 53071 | 205 | 3 |
315387 | 315387 | 2020-07-08 | Walla Walla | Washington | 53071 | 201 | 3 |
312212 | 312212 | 2020-07-07 | Walla Walla | Washington | 53071 | 196 | 3 |
309043 | 309043 | 2020-07-06 | Walla Walla | Washington | 53071 | 192 | 3 |
305875 | 305875 | 2020-07-05 | Walla Walla | Washington | 53071 | 187 | 3 |
302711 | 302711 | 2020-07-04 | Walla Walla | Washington | 53071 | 177 | 3 |
299547 | 299547 | 2020-07-03 | Walla Walla | Washington | 53071 | 176 | 3 |
296385 | 296385 | 2020-07-02 | Walla Walla | Washington | 53071 | 176 | 3 |
293230 | 293230 | 2020-07-01 | Walla Walla | Washington | 53071 | 171 | 3 |
290077 | 290077 | 2020-06-30 | Walla Walla | Washington | 53071 | 169 | 3 |
286927 | 286927 | 2020-06-29 | Walla Walla | Washington | 53071 | 164 | 3 |
283781 | 283781 | 2020-06-28 | Walla Walla | Washington | 53071 | 158 | 3 |
280635 | 280635 | 2020-06-27 | Walla Walla | Washington | 53071 | 152 | 3 |
277487 | 277487 | 2020-06-26 | Walla Walla | Washington | 53071 | 152 | 3 |
274339 | 274339 | 2020-06-25 | Walla Walla | Washington | 53071 | 148 | 3 |
271199 | 271199 | 2020-06-24 | Walla Walla | Washington | 53071 | 147 | 3 |
268065 | 268065 | 2020-06-23 | Walla Walla | Washington | 53071 | 144 | 3 |
264936 | 264936 | 2020-06-22 | Walla Walla | Washington | 53071 | 143 | 3 |
261807 | 261807 | 2020-06-21 | Walla Walla | Washington | 53071 | 141 | 3 |
258680 | 258680 | 2020-06-20 | Walla Walla | Washington | 53071 | 132 | 3 |
255553 | 255553 | 2020-06-19 | Walla Walla | Washington | 53071 | 131 | 3 |
252434 | 252434 | 2020-06-18 | Walla Walla | Washington | 53071 | 129 | 3 |
249319 | 249319 | 2020-06-17 | Walla Walla | Washington | 53071 | 127 | 3 |
246207 | 246207 | 2020-06-16 | Walla Walla | Washington | 53071 | 125 | 3 |
243094 | 243094 | 2020-06-15 | Walla Walla | Washington | 53071 | 122 | 3 |
239983 | 239983 | 2020-06-14 | Walla Walla | Washington | 53071 | 118 | 3 |
236875 | 236875 | 2020-06-13 | Walla Walla | Washington | 53071 | 118 | 3 |
233768 | 233768 | 2020-06-12 | Walla Walla | Washington | 53071 | 118 | 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);