ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
180 rows where county = "Unknown" and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
835906 | 835906 | 2020-12-16 | Unknown | Washington | 2 | 2 | |
832660 | 832660 | 2020-12-15 | Unknown | Washington | 2 | 2 | |
829413 | 829413 | 2020-12-14 | Unknown | Washington | 2 | 2 | |
826167 | 826167 | 2020-12-13 | Unknown | Washington | 2 | 2 | |
822920 | 822920 | 2020-12-12 | Unknown | Washington | 2 | 2 | |
819674 | 819674 | 2020-12-11 | Unknown | Washington | 2 | 2 | |
816428 | 816428 | 2020-12-10 | Unknown | Washington | 2 | 2 | |
813182 | 813182 | 2020-12-09 | Unknown | Washington | 2 | 2 | |
809938 | 809938 | 2020-12-08 | Unknown | Washington | 2 | 2 | |
806693 | 806693 | 2020-12-07 | Unknown | Washington | 2 | 2 | |
803448 | 803448 | 2020-12-06 | Unknown | Washington | 2 | 2 | |
800203 | 800203 | 2020-12-05 | Unknown | Washington | 2 | 2 | |
796958 | 796958 | 2020-12-04 | Unknown | Washington | 2 | 2 | |
793713 | 793713 | 2020-12-03 | Unknown | Washington | 2 | 2 | |
790468 | 790468 | 2020-12-02 | Unknown | Washington | 2 | 2 | |
787223 | 787223 | 2020-12-01 | Unknown | Washington | 2 | 2 | |
783979 | 783979 | 2020-11-30 | Unknown | Washington | 2 | 2 | |
780734 | 780734 | 2020-11-29 | Unknown | Washington | 2 | 2 | |
777488 | 777488 | 2020-11-28 | Unknown | Washington | 2 | 2 | |
774243 | 774243 | 2020-11-27 | Unknown | Washington | 2 | 2 | |
770998 | 770998 | 2020-11-26 | Unknown | Washington | 2 | 2 | |
767752 | 767752 | 2020-11-25 | Unknown | Washington | 2 | 2 | |
764507 | 764507 | 2020-11-24 | Unknown | Washington | 2 | 2 | |
761262 | 761262 | 2020-11-23 | Unknown | Washington | 2 | 2 | |
758017 | 758017 | 2020-11-22 | Unknown | Washington | 2 | 2 | |
754770 | 754770 | 2020-11-21 | Unknown | Washington | 2 | 2 | |
751524 | 751524 | 2020-11-20 | Unknown | Washington | 2 | 2 | |
748278 | 748278 | 2020-11-19 | Unknown | Washington | 2 | 2 | |
745032 | 745032 | 2020-11-18 | Unknown | Washington | 2 | 2 | |
741785 | 741785 | 2020-11-17 | Unknown | Washington | 2 | 2 | |
738538 | 738538 | 2020-11-16 | Unknown | Washington | 2 | 2 | |
735294 | 735294 | 2020-11-15 | Unknown | Washington | 2 | 2 | |
732048 | 732048 | 2020-11-14 | Unknown | Washington | 2 | 2 | |
728803 | 728803 | 2020-11-13 | Unknown | Washington | 2 | 2 | |
725560 | 725560 | 2020-11-12 | Unknown | Washington | 2 | 2 | |
722317 | 722317 | 2020-11-11 | Unknown | Washington | 2 | 2 | |
719074 | 719074 | 2020-11-10 | Unknown | Washington | 2 | 2 | |
715831 | 715831 | 2020-11-09 | Unknown | Washington | 2 | 2 | |
712587 | 712587 | 2020-11-08 | Unknown | Washington | 2 | 2 | |
709343 | 709343 | 2020-11-07 | Unknown | Washington | 2 | 2 | |
706099 | 706099 | 2020-11-06 | Unknown | Washington | 2 | 2 | |
702856 | 702856 | 2020-11-05 | Unknown | Washington | 2 | 2 | |
699613 | 699613 | 2020-11-04 | Unknown | Washington | 2 | 2 | |
696369 | 696369 | 2020-11-03 | Unknown | Washington | 2 | 2 | |
693127 | 693127 | 2020-11-02 | Unknown | Washington | 2 | 2 | |
689883 | 689883 | 2020-11-01 | Unknown | Washington | 2 | 2 | |
686638 | 686638 | 2020-10-31 | Unknown | Washington | 2 | 2 | |
683395 | 683395 | 2020-10-30 | Unknown | Washington | 2 | 2 | |
680152 | 680152 | 2020-10-29 | Unknown | Washington | 2 | 2 | |
676909 | 676909 | 2020-10-28 | Unknown | Washington | 2 | 2 | |
673666 | 673666 | 2020-10-27 | Unknown | Washington | 2 | 2 | |
670424 | 670424 | 2020-10-26 | Unknown | Washington | 2 | 2 | |
667181 | 667181 | 2020-10-25 | Unknown | Washington | 2 | 2 | |
663936 | 663936 | 2020-10-24 | Unknown | Washington | 2 | 2 | |
660692 | 660692 | 2020-10-23 | Unknown | Washington | 2 | 2 | |
657448 | 657448 | 2020-10-22 | Unknown | Washington | 2 | 2 | |
654203 | 654203 | 2020-10-21 | Unknown | Washington | 2 | 2 | |
650958 | 650958 | 2020-10-20 | Unknown | Washington | 2 | 2 | |
647714 | 647714 | 2020-10-19 | Unknown | Washington | 2 | 2 | |
644468 | 644468 | 2020-10-18 | Unknown | Washington | 2 | 2 | |
641220 | 641220 | 2020-10-17 | Unknown | Washington | 2 | 2 | |
637973 | 637973 | 2020-10-16 | Unknown | Washington | 2 | 2 | |
634728 | 634728 | 2020-10-15 | Unknown | Washington | 2 | 2 | |
631483 | 631483 | 2020-10-14 | Unknown | Washington | 2 | 2 | |
628239 | 628239 | 2020-10-13 | Unknown | Washington | 2 | 2 | |
624996 | 624996 | 2020-10-12 | Unknown | Washington | 2 | 2 | |
621753 | 621753 | 2020-10-11 | Unknown | Washington | 2 | 2 | |
618510 | 618510 | 2020-10-10 | Unknown | Washington | 2 | 2 | |
615268 | 615268 | 2020-10-09 | Unknown | Washington | 2 | 2 | |
612027 | 612027 | 2020-10-08 | Unknown | Washington | 2 | 2 | |
608785 | 608785 | 2020-10-07 | Unknown | Washington | 2 | 2 | |
605542 | 605542 | 2020-10-06 | Unknown | Washington | 2 | 2 | |
602300 | 602300 | 2020-10-05 | Unknown | Washington | 2 | 2 | |
599057 | 599057 | 2020-10-04 | Unknown | Washington | 2 | 2 | |
595814 | 595814 | 2020-10-03 | Unknown | Washington | 2 | 2 | |
592572 | 592572 | 2020-10-02 | Unknown | Washington | 2 | 2 | |
589332 | 589332 | 2020-10-01 | Unknown | Washington | 2 | 2 | |
586091 | 586091 | 2020-09-30 | Unknown | Washington | 2 | 2 | |
582851 | 582851 | 2020-09-29 | Unknown | Washington | 2 | 2 | |
579612 | 579612 | 2020-09-28 | Unknown | Washington | 2 | 2 | |
576371 | 576371 | 2020-09-27 | Unknown | Washington | 2 | 2 | |
573127 | 573127 | 2020-09-26 | Unknown | Washington | 2 | 2 | |
569885 | 569885 | 2020-09-25 | Unknown | Washington | 2 | 2 | |
566644 | 566644 | 2020-09-24 | Unknown | Washington | 2 | 2 | |
563403 | 563403 | 2020-09-23 | Unknown | Washington | 2 | 2 | |
560164 | 560164 | 2020-09-22 | Unknown | Washington | 2 | 2 | |
556928 | 556928 | 2020-09-21 | Unknown | Washington | 2 | 2 | |
553691 | 553691 | 2020-09-20 | Unknown | Washington | 2 | 2 | |
550452 | 550452 | 2020-09-19 | Unknown | Washington | 2 | 2 | |
547213 | 547213 | 2020-09-18 | Unknown | Washington | 2 | 2 | |
543976 | 543976 | 2020-09-17 | Unknown | Washington | 2 | 2 | |
540740 | 540740 | 2020-09-16 | Unknown | Washington | 2 | 2 | |
537503 | 537503 | 2020-09-15 | Unknown | Washington | 2 | 2 | |
534267 | 534267 | 2020-09-14 | Unknown | Washington | 2 | 2 | |
531032 | 531032 | 2020-09-13 | Unknown | Washington | 2 | 2 | |
527795 | 527795 | 2020-09-12 | Unknown | Washington | 2 | 2 | |
524559 | 524559 | 2020-09-11 | Unknown | Washington | 2 | 2 | |
521323 | 521323 | 2020-09-10 | Unknown | Washington | 2 | 2 | |
518086 | 518086 | 2020-09-09 | Unknown | Washington | 2 | 2 | |
514851 | 514851 | 2020-09-08 | Unknown | Washington | 2 | 2 |
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);