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 |
---|---|---|---|---|---|---|---|
762825 | 762825 | 2020-11-24 | Washington | Minnesota | 27163 | 12799 | 108 |
759580 | 759580 | 2020-11-23 | Washington | Minnesota | 27163 | 12538 | 106 |
756333 | 756333 | 2020-11-22 | Washington | Minnesota | 27163 | 12351 | 104 |
753087 | 753087 | 2020-11-21 | Washington | Minnesota | 27163 | 12043 | 103 |
749841 | 749841 | 2020-11-20 | Washington | Minnesota | 27163 | 11756 | 102 |
746595 | 746595 | 2020-11-19 | Washington | Minnesota | 27163 | 11495 | 100 |
743348 | 743348 | 2020-11-18 | Washington | Minnesota | 27163 | 11204 | 100 |
740101 | 740101 | 2020-11-17 | Washington | Minnesota | 27163 | 10924 | 96 |
736857 | 736857 | 2020-11-16 | Washington | Minnesota | 27163 | 10689 | 95 |
733611 | 733611 | 2020-11-15 | Washington | Minnesota | 27163 | 10390 | 95 |
730366 | 730366 | 2020-11-14 | Washington | Minnesota | 27163 | 10119 | 94 |
727123 | 727123 | 2020-11-13 | Washington | Minnesota | 27163 | 9711 | 89 |
723880 | 723880 | 2020-11-12 | Washington | Minnesota | 27163 | 9395 | 84 |
720637 | 720637 | 2020-11-11 | Washington | Minnesota | 27163 | 9090 | 83 |
717394 | 717394 | 2020-11-10 | Washington | Minnesota | 27163 | 8908 | 81 |
714150 | 714150 | 2020-11-09 | Washington | Minnesota | 27163 | 8657 | 80 |
710906 | 710906 | 2020-11-08 | Washington | Minnesota | 27163 | 8412 | 79 |
707662 | 707662 | 2020-11-07 | Washington | Minnesota | 27163 | 8115 | 78 |
704419 | 704419 | 2020-11-06 | Washington | Minnesota | 27163 | 7930 | 77 |
701177 | 701177 | 2020-11-05 | Washington | Minnesota | 27163 | 7694 | 76 |
697933 | 697933 | 2020-11-04 | Washington | Minnesota | 27163 | 7519 | 75 |
694690 | 694690 | 2020-11-03 | Washington | Minnesota | 27163 | 7340 | 75 |
691448 | 691448 | 2020-11-02 | Washington | Minnesota | 27163 | 7092 | 75 |
688203 | 688203 | 2020-11-01 | Washington | Minnesota | 27163 | 6958 | 75 |
684959 | 684959 | 2020-10-31 | Washington | Minnesota | 27163 | 6861 | 74 |
681716 | 681716 | 2020-10-30 | Washington | Minnesota | 27163 | 6490 | 74 |
678472 | 678472 | 2020-10-29 | Washington | Minnesota | 27163 | 6362 | 73 |
675230 | 675230 | 2020-10-28 | Washington | Minnesota | 27163 | 6233 | 72 |
671987 | 671987 | 2020-10-27 | Washington | Minnesota | 27163 | 6089 | 72 |
668745 | 668745 | 2020-10-26 | Washington | Minnesota | 27163 | 5986 | 72 |
665501 | 665501 | 2020-10-25 | Washington | Minnesota | 27163 | 5932 | 72 |
662256 | 662256 | 2020-10-24 | Washington | Minnesota | 27163 | 5830 | 71 |
659012 | 659012 | 2020-10-23 | Washington | Minnesota | 27163 | 5469 | 70 |
655767 | 655767 | 2020-10-22 | Washington | Minnesota | 27163 | 5399 | 68 |
652522 | 652522 | 2020-10-21 | Washington | Minnesota | 27163 | 5345 | 68 |
649277 | 649277 | 2020-10-20 | Washington | Minnesota | 27163 | 5305 | 67 |
646033 | 646033 | 2020-10-19 | Washington | Minnesota | 27163 | 5259 | 67 |
642786 | 642786 | 2020-10-18 | Washington | Minnesota | 27163 | 5172 | 67 |
639539 | 639539 | 2020-10-17 | Washington | Minnesota | 27163 | 5016 | 66 |
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 |
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);