ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Washington" and fips = 27163 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636293 | 636293 | 2020-10-16 | Washington | Minnesota | 27163 | 4942 | 66 |
633047 | 633047 | 2020-10-15 | Washington | Minnesota | 27163 | 4859 | 66 |
629802 | 629802 | 2020-10-14 | Washington | Minnesota | 27163 | 4794 | 64 |
626558 | 626558 | 2020-10-13 | Washington | Minnesota | 27163 | 4723 | 62 |
623316 | 623316 | 2020-10-12 | Washington | Minnesota | 27163 | 4660 | 62 |
620073 | 620073 | 2020-10-11 | Washington | Minnesota | 27163 | 4521 | 62 |
616831 | 616831 | 2020-10-10 | Washington | Minnesota | 27163 | 4447 | 62 |
613590 | 613590 | 2020-10-09 | Washington | Minnesota | 27163 | 4368 | 61 |
610348 | 610348 | 2020-10-08 | Washington | Minnesota | 27163 | 4315 | 60 |
607106 | 607106 | 2020-10-07 | Washington | Minnesota | 27163 | 4259 | 60 |
603863 | 603863 | 2020-10-06 | Washington | Minnesota | 27163 | 4231 | 59 |
600621 | 600621 | 2020-10-05 | Washington | Minnesota | 27163 | 4180 | 58 |
597378 | 597378 | 2020-10-04 | Washington | Minnesota | 27163 | 4132 | 58 |
594137 | 594137 | 2020-10-03 | Washington | Minnesota | 27163 | 4088 | 57 |
590896 | 590896 | 2020-10-02 | Washington | Minnesota | 27163 | 4034 | 56 |
587655 | 587655 | 2020-10-01 | Washington | Minnesota | 27163 | 3989 | 55 |
584415 | 584415 | 2020-09-30 | Washington | Minnesota | 27163 | 3950 | 55 |
581174 | 581174 | 2020-09-29 | Washington | Minnesota | 27163 | 3918 | 55 |
577933 | 577933 | 2020-09-28 | Washington | Minnesota | 27163 | 3883 | 55 |
574692 | 574692 | 2020-09-27 | Washington | Minnesota | 27163 | 3841 | 55 |
571449 | 571449 | 2020-09-26 | Washington | Minnesota | 27163 | 3799 | 55 |
568207 | 568207 | 2020-09-25 | Washington | Minnesota | 27163 | 3735 | 55 |
564967 | 564967 | 2020-09-24 | Washington | Minnesota | 27163 | 3689 | 55 |
561727 | 561727 | 2020-09-23 | Washington | Minnesota | 27163 | 3652 | 55 |
558490 | 558490 | 2020-09-22 | Washington | Minnesota | 27163 | 3627 | 55 |
555253 | 555253 | 2020-09-21 | Washington | Minnesota | 27163 | 3610 | 55 |
552015 | 552015 | 2020-09-20 | Washington | Minnesota | 27163 | 3573 | 55 |
548776 | 548776 | 2020-09-19 | Washington | Minnesota | 27163 | 3526 | 55 |
545538 | 545538 | 2020-09-18 | Washington | Minnesota | 27163 | 3492 | 55 |
542301 | 542301 | 2020-09-17 | Washington | Minnesota | 27163 | 3459 | 55 |
539065 | 539065 | 2020-09-16 | Washington | Minnesota | 27163 | 3431 | 55 |
535828 | 535828 | 2020-09-15 | Washington | Minnesota | 27163 | 3416 | 55 |
532593 | 532593 | 2020-09-14 | Washington | Minnesota | 27163 | 3407 | 55 |
529357 | 529357 | 2020-09-13 | Washington | Minnesota | 27163 | 3384 | 55 |
526121 | 526121 | 2020-09-12 | Washington | Minnesota | 27163 | 3361 | 55 |
522885 | 522885 | 2020-09-11 | Washington | Minnesota | 27163 | 3335 | 55 |
519648 | 519648 | 2020-09-10 | Washington | Minnesota | 27163 | 3316 | 55 |
516413 | 516413 | 2020-09-09 | Washington | Minnesota | 27163 | 3296 | 55 |
513179 | 513179 | 2020-09-08 | Washington | Minnesota | 27163 | 3292 | 55 |
509947 | 509947 | 2020-09-07 | Washington | Minnesota | 27163 | 3264 | 55 |
506714 | 506714 | 2020-09-06 | Washington | Minnesota | 27163 | 3235 | 55 |
503481 | 503481 | 2020-09-05 | Washington | Minnesota | 27163 | 3203 | 55 |
500247 | 500247 | 2020-09-04 | Washington | Minnesota | 27163 | 3168 | 54 |
497013 | 497013 | 2020-09-03 | Washington | Minnesota | 27163 | 3124 | 54 |
493780 | 493780 | 2020-09-02 | Washington | Minnesota | 27163 | 3071 | 54 |
490546 | 490546 | 2020-09-01 | Washington | Minnesota | 27163 | 3003 | 54 |
487313 | 487313 | 2020-08-31 | Washington | Minnesota | 27163 | 2996 | 54 |
484079 | 484079 | 2020-08-30 | Washington | Minnesota | 27163 | 2962 | 54 |
480844 | 480844 | 2020-08-29 | Washington | Minnesota | 27163 | 2916 | 54 |
477612 | 477612 | 2020-08-28 | Washington | Minnesota | 27163 | 2861 | 54 |
474379 | 474379 | 2020-08-27 | Washington | Minnesota | 27163 | 2808 | 54 |
471147 | 471147 | 2020-08-26 | Washington | Minnesota | 27163 | 2715 | 53 |
467917 | 467917 | 2020-08-25 | Washington | Minnesota | 27163 | 2682 | 51 |
464688 | 464688 | 2020-08-24 | Washington | Minnesota | 27163 | 2663 | 51 |
461457 | 461457 | 2020-08-23 | Washington | Minnesota | 27163 | 2618 | 51 |
458230 | 458230 | 2020-08-22 | Washington | Minnesota | 27163 | 2568 | 51 |
455002 | 455002 | 2020-08-21 | Washington | Minnesota | 27163 | 2521 | 51 |
451774 | 451774 | 2020-08-20 | Washington | Minnesota | 27163 | 2478 | 51 |
448546 | 448546 | 2020-08-19 | Washington | Minnesota | 27163 | 2435 | 51 |
445320 | 445320 | 2020-08-18 | Washington | Minnesota | 27163 | 2404 | 48 |
442094 | 442094 | 2020-08-17 | Washington | Minnesota | 27163 | 2392 | 48 |
438867 | 438867 | 2020-08-16 | Washington | Minnesota | 27163 | 2354 | 48 |
435642 | 435642 | 2020-08-15 | Washington | Minnesota | 27163 | 2300 | 48 |
432416 | 432416 | 2020-08-14 | Washington | Minnesota | 27163 | 2255 | 48 |
429189 | 429189 | 2020-08-13 | Washington | Minnesota | 27163 | 2227 | 48 |
425965 | 425965 | 2020-08-12 | Washington | Minnesota | 27163 | 2192 | 47 |
422743 | 422743 | 2020-08-11 | Washington | Minnesota | 27163 | 2163 | 45 |
419521 | 419521 | 2020-08-10 | Washington | Minnesota | 27163 | 2155 | 45 |
416300 | 416300 | 2020-08-09 | Washington | Minnesota | 27163 | 2128 | 45 |
413080 | 413080 | 2020-08-08 | Washington | Minnesota | 27163 | 2077 | 44 |
409860 | 409860 | 2020-08-07 | Washington | Minnesota | 27163 | 2037 | 44 |
406640 | 406640 | 2020-08-06 | Washington | Minnesota | 27163 | 2009 | 44 |
403422 | 403422 | 2020-08-05 | Washington | Minnesota | 27163 | 1978 | 43 |
400205 | 400205 | 2020-08-04 | Washington | Minnesota | 27163 | 1938 | 43 |
396991 | 396991 | 2020-08-03 | Washington | Minnesota | 27163 | 1917 | 43 |
393775 | 393775 | 2020-08-02 | Washington | Minnesota | 27163 | 1886 | 43 |
390558 | 390558 | 2020-08-01 | Washington | Minnesota | 27163 | 1852 | 43 |
387341 | 387341 | 2020-07-31 | Washington | Minnesota | 27163 | 1817 | 43 |
384123 | 384123 | 2020-07-30 | Washington | Minnesota | 27163 | 1792 | 43 |
380906 | 380906 | 2020-07-29 | Washington | Minnesota | 27163 | 1760 | 43 |
377689 | 377689 | 2020-07-28 | Washington | Minnesota | 27163 | 1723 | 42 |
374474 | 374474 | 2020-07-27 | Washington | Minnesota | 27163 | 1700 | 41 |
371262 | 371262 | 2020-07-26 | Washington | Minnesota | 27163 | 1672 | 41 |
368052 | 368052 | 2020-07-25 | Washington | Minnesota | 27163 | 1631 | 41 |
364844 | 364844 | 2020-07-24 | Washington | Minnesota | 27163 | 1597 | 41 |
361637 | 361637 | 2020-07-23 | Washington | Minnesota | 27163 | 1572 | 41 |
358432 | 358432 | 2020-07-22 | Washington | Minnesota | 27163 | 1550 | 40 |
355229 | 355229 | 2020-07-21 | Washington | Minnesota | 27163 | 1515 | 40 |
352027 | 352027 | 2020-07-20 | Washington | Minnesota | 27163 | 1465 | 40 |
348827 | 348827 | 2020-07-19 | Washington | Minnesota | 27163 | 1458 | 40 |
345626 | 345626 | 2020-07-18 | Washington | Minnesota | 27163 | 1422 | 40 |
342426 | 342426 | 2020-07-17 | Washington | Minnesota | 27163 | 1402 | 40 |
339230 | 339230 | 2020-07-16 | Washington | Minnesota | 27163 | 1369 | 40 |
336034 | 336034 | 2020-07-15 | Washington | Minnesota | 27163 | 1344 | 41 |
332841 | 332841 | 2020-07-14 | Washington | Minnesota | 27163 | 1324 | 41 |
329654 | 329654 | 2020-07-13 | Washington | Minnesota | 27163 | 1306 | 41 |
326468 | 326468 | 2020-07-12 | Washington | Minnesota | 27163 | 1283 | 41 |
323285 | 323285 | 2020-07-11 | Washington | Minnesota | 27163 | 1255 | 41 |
320106 | 320106 | 2020-07-10 | Washington | Minnesota | 27163 | 1228 | 40 |
316931 | 316931 | 2020-07-09 | Washington | Minnesota | 27163 | 1190 | 40 |
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);