ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Washington" and fips = 48477 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923297 | 923297 | 2021-01-12 | Washington | Texas | 48477 | 1624 | 66 |
920052 | 920052 | 2021-01-11 | Washington | Texas | 48477 | 1624 | 64 |
916807 | 916807 | 2021-01-10 | Washington | Texas | 48477 | 1624 | 64 |
913562 | 913562 | 2021-01-09 | Washington | Texas | 48477 | 1624 | 64 |
910317 | 910317 | 2021-01-08 | Washington | Texas | 48477 | 1614 | 61 |
907072 | 907072 | 2021-01-07 | Washington | Texas | 48477 | 1588 | 61 |
903826 | 903826 | 2021-01-06 | Washington | Texas | 48477 | 1567 | 61 |
900581 | 900581 | 2021-01-05 | Washington | Texas | 48477 | 1532 | 61 |
897336 | 897336 | 2021-01-04 | Washington | Texas | 48477 | 1516 | 60 |
894090 | 894090 | 2021-01-03 | Washington | Texas | 48477 | 1516 | 60 |
890844 | 890844 | 2021-01-02 | Washington | Texas | 48477 | 1513 | 60 |
887597 | 887597 | 2021-01-01 | Washington | Texas | 48477 | 1513 | 60 |
884352 | 884352 | 2020-12-31 | Washington | Texas | 48477 | 1481 | 60 |
881107 | 881107 | 2020-12-30 | Washington | Texas | 48477 | 1416 | 59 |
877862 | 877862 | 2020-12-29 | Washington | Texas | 48477 | 1407 | 59 |
874617 | 874617 | 2020-12-28 | Washington | Texas | 48477 | 1386 | 59 |
871372 | 871372 | 2020-12-27 | Washington | Texas | 48477 | 1385 | 59 |
868127 | 868127 | 2020-12-26 | Washington | Texas | 48477 | 1384 | 59 |
864882 | 864882 | 2020-12-25 | Washington | Texas | 48477 | 1384 | 59 |
861637 | 861637 | 2020-12-24 | Washington | Texas | 48477 | 1384 | 59 |
858392 | 858392 | 2020-12-23 | Washington | Texas | 48477 | 1362 | 58 |
855147 | 855147 | 2020-12-22 | Washington | Texas | 48477 | 1349 | 58 |
851902 | 851902 | 2020-12-21 | Washington | Texas | 48477 | 1329 | 57 |
848657 | 848657 | 2020-12-20 | Washington | Texas | 48477 | 1329 | 57 |
845412 | 845412 | 2020-12-19 | Washington | Texas | 48477 | 1329 | 57 |
842166 | 842166 | 2020-12-18 | Washington | Texas | 48477 | 1294 | 57 |
838921 | 838921 | 2020-12-17 | Washington | Texas | 48477 | 1270 | 57 |
835675 | 835675 | 2020-12-16 | Washington | Texas | 48477 | 1258 | 57 |
832429 | 832429 | 2020-12-15 | Washington | Texas | 48477 | 1253 | 57 |
829182 | 829182 | 2020-12-14 | Washington | Texas | 48477 | 1243 | 56 |
825936 | 825936 | 2020-12-13 | Washington | Texas | 48477 | 1243 | 56 |
822689 | 822689 | 2020-12-12 | Washington | Texas | 48477 | 1238 | 55 |
819443 | 819443 | 2020-12-11 | Washington | Texas | 48477 | 1225 | 55 |
816197 | 816197 | 2020-12-10 | Washington | Texas | 48477 | 1035 | 55 |
812951 | 812951 | 2020-12-09 | Washington | Texas | 48477 | 1028 | 54 |
809707 | 809707 | 2020-12-08 | Washington | Texas | 48477 | 1014 | 54 |
806462 | 806462 | 2020-12-07 | Washington | Texas | 48477 | 998 | 54 |
803217 | 803217 | 2020-12-06 | Washington | Texas | 48477 | 998 | 54 |
799972 | 799972 | 2020-12-05 | Washington | Texas | 48477 | 989 | 54 |
796727 | 796727 | 2020-12-04 | Washington | Texas | 48477 | 985 | 54 |
793482 | 793482 | 2020-12-03 | Washington | Texas | 48477 | 976 | 54 |
790237 | 790237 | 2020-12-02 | Washington | Texas | 48477 | 966 | 53 |
786992 | 786992 | 2020-12-01 | Washington | Texas | 48477 | 966 | 53 |
783748 | 783748 | 2020-11-30 | Washington | Texas | 48477 | 965 | 53 |
780503 | 780503 | 2020-11-29 | Washington | Texas | 48477 | 958 | 53 |
777257 | 777257 | 2020-11-28 | Washington | Texas | 48477 | 958 | 53 |
774012 | 774012 | 2020-11-27 | Washington | Texas | 48477 | 957 | 53 |
770767 | 770767 | 2020-11-26 | Washington | Texas | 48477 | 954 | 53 |
767521 | 767521 | 2020-11-25 | Washington | Texas | 48477 | 939 | 53 |
764276 | 764276 | 2020-11-24 | Washington | Texas | 48477 | 925 | 53 |
761031 | 761031 | 2020-11-23 | Washington | Texas | 48477 | 915 | 53 |
757786 | 757786 | 2020-11-22 | Washington | Texas | 48477 | 915 | 53 |
754539 | 754539 | 2020-11-21 | Washington | Texas | 48477 | 915 | 53 |
751293 | 751293 | 2020-11-20 | Washington | Texas | 48477 | 907 | 53 |
748047 | 748047 | 2020-11-19 | Washington | Texas | 48477 | 886 | 53 |
744801 | 744801 | 2020-11-18 | Washington | Texas | 48477 | 869 | 52 |
741554 | 741554 | 2020-11-17 | Washington | Texas | 48477 | 846 | 52 |
738307 | 738307 | 2020-11-16 | Washington | Texas | 48477 | 823 | 52 |
735063 | 735063 | 2020-11-15 | Washington | Texas | 48477 | 821 | 52 |
731817 | 731817 | 2020-11-14 | Washington | Texas | 48477 | 821 | 52 |
728572 | 728572 | 2020-11-13 | Washington | Texas | 48477 | 812 | 52 |
725329 | 725329 | 2020-11-12 | Washington | Texas | 48477 | 800 | 52 |
722086 | 722086 | 2020-11-11 | Washington | Texas | 48477 | 792 | 52 |
718843 | 718843 | 2020-11-10 | Washington | Texas | 48477 | 761 | 52 |
715600 | 715600 | 2020-11-09 | Washington | Texas | 48477 | 759 | 51 |
712356 | 712356 | 2020-11-08 | Washington | Texas | 48477 | 757 | 51 |
709112 | 709112 | 2020-11-07 | Washington | Texas | 48477 | 755 | 51 |
705868 | 705868 | 2020-11-06 | Washington | Texas | 48477 | 750 | 50 |
702625 | 702625 | 2020-11-05 | Washington | Texas | 48477 | 744 | 50 |
699382 | 699382 | 2020-11-04 | Washington | Texas | 48477 | 725 | 50 |
696138 | 696138 | 2020-11-03 | Washington | Texas | 48477 | 722 | 50 |
692896 | 692896 | 2020-11-02 | Washington | Texas | 48477 | 720 | 50 |
689652 | 689652 | 2020-11-01 | Washington | Texas | 48477 | 719 | 50 |
686407 | 686407 | 2020-10-31 | Washington | Texas | 48477 | 719 | 50 |
683164 | 683164 | 2020-10-30 | Washington | Texas | 48477 | 710 | 50 |
679921 | 679921 | 2020-10-29 | Washington | Texas | 48477 | 705 | 50 |
676678 | 676678 | 2020-10-28 | Washington | Texas | 48477 | 702 | 49 |
673435 | 673435 | 2020-10-27 | Washington | Texas | 48477 | 702 | 48 |
670193 | 670193 | 2020-10-26 | Washington | Texas | 48477 | 700 | 48 |
666950 | 666950 | 2020-10-25 | Washington | Texas | 48477 | 700 | 48 |
663705 | 663705 | 2020-10-24 | Washington | Texas | 48477 | 694 | 48 |
660461 | 660461 | 2020-10-23 | Washington | Texas | 48477 | 692 | 48 |
657217 | 657217 | 2020-10-22 | Washington | Texas | 48477 | 692 | 48 |
653972 | 653972 | 2020-10-21 | Washington | Texas | 48477 | 692 | 48 |
650727 | 650727 | 2020-10-20 | Washington | Texas | 48477 | 693 | 48 |
647483 | 647483 | 2020-10-19 | Washington | Texas | 48477 | 692 | 48 |
644237 | 644237 | 2020-10-18 | Washington | Texas | 48477 | 692 | 48 |
640989 | 640989 | 2020-10-17 | Washington | Texas | 48477 | 692 | 48 |
637742 | 637742 | 2020-10-16 | Washington | Texas | 48477 | 673 | 48 |
634497 | 634497 | 2020-10-15 | Washington | Texas | 48477 | 671 | 48 |
631252 | 631252 | 2020-10-14 | Washington | Texas | 48477 | 667 | 48 |
628008 | 628008 | 2020-10-13 | Washington | Texas | 48477 | 664 | 48 |
624765 | 624765 | 2020-10-12 | Washington | Texas | 48477 | 657 | 48 |
621522 | 621522 | 2020-10-11 | Washington | Texas | 48477 | 657 | 48 |
618279 | 618279 | 2020-10-10 | Washington | Texas | 48477 | 657 | 48 |
615037 | 615037 | 2020-10-09 | Washington | Texas | 48477 | 655 | 48 |
611796 | 611796 | 2020-10-08 | Washington | Texas | 48477 | 655 | 48 |
608554 | 608554 | 2020-10-07 | Washington | Texas | 48477 | 653 | 48 |
605311 | 605311 | 2020-10-06 | Washington | Texas | 48477 | 652 | 48 |
602069 | 602069 | 2020-10-05 | Washington | Texas | 48477 | 646 | 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);