ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
803 rows where fips = 53071 and state = "Washington" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
230663 | 230663 | 2020-06-11 | Walla Walla | Washington | 53071 | 118 | 2 |
233768 | 233768 | 2020-06-12 | Walla Walla | Washington | 53071 | 118 | 3 |
236875 | 236875 | 2020-06-13 | Walla Walla | Washington | 53071 | 118 | 3 |
239983 | 239983 | 2020-06-14 | Walla Walla | Washington | 53071 | 118 | 3 |
224459 | 224459 | 2020-06-09 | Walla Walla | Washington | 53071 | 119 | 2 |
243094 | 243094 | 2020-06-15 | Walla Walla | Washington | 53071 | 122 | 3 |
246207 | 246207 | 2020-06-16 | Walla Walla | Washington | 53071 | 125 | 3 |
249319 | 249319 | 2020-06-17 | Walla Walla | Washington | 53071 | 127 | 3 |
252434 | 252434 | 2020-06-18 | Walla Walla | Washington | 53071 | 129 | 3 |
255553 | 255553 | 2020-06-19 | Walla Walla | Washington | 53071 | 131 | 3 |
258680 | 258680 | 2020-06-20 | Walla Walla | Washington | 53071 | 132 | 3 |
261807 | 261807 | 2020-06-21 | Walla Walla | Washington | 53071 | 141 | 3 |
264936 | 264936 | 2020-06-22 | Walla Walla | Washington | 53071 | 143 | 3 |
268065 | 268065 | 2020-06-23 | Walla Walla | Washington | 53071 | 144 | 3 |
271199 | 271199 | 2020-06-24 | Walla Walla | Washington | 53071 | 147 | 3 |
274339 | 274339 | 2020-06-25 | Walla Walla | Washington | 53071 | 148 | 3 |
277487 | 277487 | 2020-06-26 | Walla Walla | Washington | 53071 | 152 | 3 |
280635 | 280635 | 2020-06-27 | Walla Walla | Washington | 53071 | 152 | 3 |
283781 | 283781 | 2020-06-28 | Walla Walla | Washington | 53071 | 158 | 3 |
286927 | 286927 | 2020-06-29 | Walla Walla | Washington | 53071 | 164 | 3 |
290077 | 290077 | 2020-06-30 | Walla Walla | Washington | 53071 | 169 | 3 |
293230 | 293230 | 2020-07-01 | Walla Walla | Washington | 53071 | 171 | 3 |
296385 | 296385 | 2020-07-02 | Walla Walla | Washington | 53071 | 176 | 3 |
299547 | 299547 | 2020-07-03 | Walla Walla | Washington | 53071 | 176 | 3 |
302711 | 302711 | 2020-07-04 | Walla Walla | Washington | 53071 | 177 | 3 |
305875 | 305875 | 2020-07-05 | Walla Walla | Washington | 53071 | 187 | 3 |
309043 | 309043 | 2020-07-06 | Walla Walla | Washington | 53071 | 192 | 3 |
312212 | 312212 | 2020-07-07 | Walla Walla | Washington | 53071 | 196 | 3 |
315387 | 315387 | 2020-07-08 | Walla Walla | Washington | 53071 | 201 | 3 |
318560 | 318560 | 2020-07-09 | Walla Walla | Washington | 53071 | 205 | 3 |
321739 | 321739 | 2020-07-10 | Walla Walla | Washington | 53071 | 212 | 3 |
324920 | 324920 | 2020-07-11 | Walla Walla | Washington | 53071 | 219 | 3 |
328106 | 328106 | 2020-07-12 | Walla Walla | Washington | 53071 | 219 | 3 |
331292 | 331292 | 2020-07-13 | Walla Walla | Washington | 53071 | 234 | 3 |
334485 | 334485 | 2020-07-14 | Walla Walla | Washington | 53071 | 243 | 3 |
337680 | 337680 | 2020-07-15 | Walla Walla | Washington | 53071 | 250 | 3 |
340876 | 340876 | 2020-07-16 | Walla Walla | Washington | 53071 | 262 | 3 |
344075 | 344075 | 2020-07-17 | Walla Walla | Washington | 53071 | 266 | 3 |
347275 | 347275 | 2020-07-18 | Walla Walla | Washington | 53071 | 282 | 3 |
350476 | 350476 | 2020-07-19 | Walla Walla | Washington | 53071 | 294 | 3 |
353678 | 353678 | 2020-07-20 | Walla Walla | Washington | 53071 | 303 | 3 |
356881 | 356881 | 2020-07-21 | Walla Walla | Washington | 53071 | 304 | 3 |
360086 | 360086 | 2020-07-22 | Walla Walla | Washington | 53071 | 312 | 3 |
363292 | 363292 | 2020-07-23 | Walla Walla | Washington | 53071 | 322 | 4 |
366499 | 366499 | 2020-07-24 | Walla Walla | Washington | 53071 | 333 | 4 |
369708 | 369708 | 2020-07-25 | Walla Walla | Washington | 53071 | 346 | 4 |
372920 | 372920 | 2020-07-26 | Walla Walla | Washington | 53071 | 348 | 4 |
376134 | 376134 | 2020-07-27 | Walla Walla | Washington | 53071 | 363 | 4 |
379350 | 379350 | 2020-07-28 | Walla Walla | Washington | 53071 | 382 | 4 |
382567 | 382567 | 2020-07-29 | Walla Walla | Washington | 53071 | 396 | 4 |
385785 | 385785 | 2020-07-30 | Walla Walla | Washington | 53071 | 402 | 4 |
389002 | 389002 | 2020-07-31 | Walla Walla | Washington | 53071 | 412 | 4 |
392219 | 392219 | 2020-08-01 | Walla Walla | Washington | 53071 | 421 | 4 |
395435 | 395435 | 2020-08-02 | Walla Walla | Washington | 53071 | 421 | 4 |
398651 | 398651 | 2020-08-03 | Walla Walla | Washington | 53071 | 462 | 4 |
401867 | 401867 | 2020-08-04 | Walla Walla | Washington | 53071 | 470 | 4 |
405085 | 405085 | 2020-08-05 | Walla Walla | Washington | 53071 | 488 | 4 |
408305 | 408305 | 2020-08-06 | Walla Walla | Washington | 53071 | 498 | 4 |
411524 | 411524 | 2020-08-07 | Walla Walla | Washington | 53071 | 526 | 4 |
414744 | 414744 | 2020-08-08 | Walla Walla | Washington | 53071 | 528 | 4 |
417965 | 417965 | 2020-08-09 | Walla Walla | Washington | 53071 | 545 | 4 |
421186 | 421186 | 2020-08-10 | Walla Walla | Washington | 53071 | 550 | 4 |
424407 | 424407 | 2020-08-11 | Walla Walla | Washington | 53071 | 561 | 4 |
427631 | 427631 | 2020-08-12 | Walla Walla | Washington | 53071 | 572 | 4 |
430859 | 430859 | 2020-08-13 | Walla Walla | Washington | 53071 | 581 | 4 |
434084 | 434084 | 2020-08-14 | Walla Walla | Washington | 53071 | 587 | 5 |
437310 | 437310 | 2020-08-15 | Walla Walla | Washington | 53071 | 587 | 5 |
440536 | 440536 | 2020-08-16 | Walla Walla | Washington | 53071 | 639 | 5 |
443762 | 443762 | 2020-08-17 | Walla Walla | Washington | 53071 | 645 | 5 |
446989 | 446989 | 2020-08-18 | Walla Walla | Washington | 53071 | 656 | 6 |
450217 | 450217 | 2020-08-19 | Walla Walla | Washington | 53071 | 673 | 6 |
453445 | 453445 | 2020-08-20 | Walla Walla | Washington | 53071 | 683 | 5 |
456673 | 456673 | 2020-08-21 | Walla Walla | Washington | 53071 | 693 | 6 |
459900 | 459900 | 2020-08-22 | Walla Walla | Washington | 53071 | 693 | 5 |
463129 | 463129 | 2020-08-23 | Walla Walla | Washington | 53071 | 696 | 6 |
466358 | 466358 | 2020-08-24 | Walla Walla | Washington | 53071 | 711 | 5 |
469587 | 469587 | 2020-08-25 | Walla Walla | Washington | 53071 | 719 | 5 |
472819 | 472819 | 2020-08-26 | Walla Walla | Washington | 53071 | 732 | 5 |
476052 | 476052 | 2020-08-27 | Walla Walla | Washington | 53071 | 737 | 5 |
479285 | 479285 | 2020-08-28 | Walla Walla | Washington | 53071 | 750 | 7 |
482519 | 482519 | 2020-08-29 | Walla Walla | Washington | 53071 | 750 | 7 |
485754 | 485754 | 2020-08-30 | Walla Walla | Washington | 53071 | 758 | 7 |
488987 | 488987 | 2020-08-31 | Walla Walla | Washington | 53071 | 766 | 6 |
492220 | 492220 | 2020-09-01 | Walla Walla | Washington | 53071 | 771 | 6 |
495454 | 495454 | 2020-09-02 | Walla Walla | Washington | 53071 | 775 | 6 |
498687 | 498687 | 2020-09-03 | Walla Walla | Washington | 53071 | 778 | 6 |
501921 | 501921 | 2020-09-04 | Walla Walla | Washington | 53071 | 790 | 6 |
505155 | 505155 | 2020-09-05 | Walla Walla | Washington | 53071 | 790 | 6 |
508387 | 508387 | 2020-09-06 | Walla Walla | Washington | 53071 | 795 | 6 |
511620 | 511620 | 2020-09-07 | Walla Walla | Washington | 53071 | 803 | 6 |
514853 | 514853 | 2020-09-08 | Walla Walla | Washington | 53071 | 805 | 6 |
518088 | 518088 | 2020-09-09 | Walla Walla | Washington | 53071 | 813 | 6 |
521325 | 521325 | 2020-09-10 | Walla Walla | Washington | 53071 | 818 | 6 |
524561 | 524561 | 2020-09-11 | Walla Walla | Washington | 53071 | 821 | 6 |
527797 | 527797 | 2020-09-12 | Walla Walla | Washington | 53071 | 823 | 6 |
531034 | 531034 | 2020-09-13 | Walla Walla | Washington | 53071 | 825 | 6 |
534269 | 534269 | 2020-09-14 | Walla Walla | Washington | 53071 | 829 | 6 |
537505 | 537505 | 2020-09-15 | Walla Walla | Washington | 53071 | 837 | 6 |
540742 | 540742 | 2020-09-16 | Walla Walla | Washington | 53071 | 842 | 6 |
543978 | 543978 | 2020-09-17 | Walla Walla | Washington | 53071 | 849 | 6 |
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);