ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Washington" and fips = 50023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923355 | 923355 | 2021-01-12 | Washington | Vermont | 50023 | 962 | 10 |
920110 | 920110 | 2021-01-11 | Washington | Vermont | 50023 | 944 | 10 |
916865 | 916865 | 2021-01-10 | Washington | Vermont | 50023 | 943 | 10 |
913620 | 913620 | 2021-01-09 | Washington | Vermont | 50023 | 935 | 10 |
910375 | 910375 | 2021-01-08 | Washington | Vermont | 50023 | 925 | 10 |
907130 | 907130 | 2021-01-07 | Washington | Vermont | 50023 | 917 | 10 |
903884 | 903884 | 2021-01-06 | Washington | Vermont | 50023 | 905 | 10 |
900639 | 900639 | 2021-01-05 | Washington | Vermont | 50023 | 901 | 10 |
897394 | 897394 | 2021-01-04 | Washington | Vermont | 50023 | 899 | 9 |
894148 | 894148 | 2021-01-03 | Washington | Vermont | 50023 | 897 | 9 |
890902 | 890902 | 2021-01-02 | Washington | Vermont | 50023 | 886 | 9 |
887655 | 887655 | 2021-01-01 | Washington | Vermont | 50023 | 884 | 9 |
884410 | 884410 | 2020-12-31 | Washington | Vermont | 50023 | 884 | 9 |
881165 | 881165 | 2020-12-30 | Washington | Vermont | 50023 | 876 | 9 |
877920 | 877920 | 2020-12-29 | Washington | Vermont | 50023 | 872 | 9 |
874675 | 874675 | 2020-12-28 | Washington | Vermont | 50023 | 871 | 9 |
871430 | 871430 | 2020-12-27 | Washington | Vermont | 50023 | 866 | 7 |
868185 | 868185 | 2020-12-26 | Washington | Vermont | 50023 | 864 | 7 |
864940 | 864940 | 2020-12-25 | Washington | Vermont | 50023 | 858 | 7 |
861695 | 861695 | 2020-12-24 | Washington | Vermont | 50023 | 858 | 7 |
858450 | 858450 | 2020-12-23 | Washington | Vermont | 50023 | 855 | 7 |
855205 | 855205 | 2020-12-22 | Washington | Vermont | 50023 | 853 | 6 |
851960 | 851960 | 2020-12-21 | Washington | Vermont | 50023 | 850 | 6 |
848715 | 848715 | 2020-12-20 | Washington | Vermont | 50023 | 848 | 6 |
845470 | 845470 | 2020-12-19 | Washington | Vermont | 50023 | 847 | 6 |
842224 | 842224 | 2020-12-18 | Washington | Vermont | 50023 | 844 | 5 |
838979 | 838979 | 2020-12-17 | Washington | Vermont | 50023 | 840 | 5 |
835733 | 835733 | 2020-12-16 | Washington | Vermont | 50023 | 835 | 5 |
832487 | 832487 | 2020-12-15 | Washington | Vermont | 50023 | 831 | 4 |
829240 | 829240 | 2020-12-14 | Washington | Vermont | 50023 | 830 | 4 |
825994 | 825994 | 2020-12-13 | Washington | Vermont | 50023 | 821 | 4 |
822747 | 822747 | 2020-12-12 | Washington | Vermont | 50023 | 816 | 4 |
819501 | 819501 | 2020-12-11 | Washington | Vermont | 50023 | 814 | 4 |
816255 | 816255 | 2020-12-10 | Washington | Vermont | 50023 | 807 | 4 |
813009 | 813009 | 2020-12-09 | Washington | Vermont | 50023 | 801 | 3 |
809765 | 809765 | 2020-12-08 | Washington | Vermont | 50023 | 792 | 3 |
806520 | 806520 | 2020-12-07 | Washington | Vermont | 50023 | 784 | 3 |
803275 | 803275 | 2020-12-06 | Washington | Vermont | 50023 | 781 | 2 |
800030 | 800030 | 2020-12-05 | Washington | Vermont | 50023 | 761 | 2 |
796785 | 796785 | 2020-12-04 | Washington | Vermont | 50023 | 736 | 2 |
793540 | 793540 | 2020-12-03 | Washington | Vermont | 50023 | 721 | 2 |
790295 | 790295 | 2020-12-02 | Washington | Vermont | 50023 | 692 | 2 |
787050 | 787050 | 2020-12-01 | Washington | Vermont | 50023 | 654 | 2 |
783806 | 783806 | 2020-11-30 | Washington | Vermont | 50023 | 650 | 2 |
780561 | 780561 | 2020-11-29 | Washington | Vermont | 50023 | 643 | 2 |
777315 | 777315 | 2020-11-28 | Washington | Vermont | 50023 | 628 | 2 |
774070 | 774070 | 2020-11-27 | Washington | Vermont | 50023 | 624 | 2 |
770825 | 770825 | 2020-11-26 | Washington | Vermont | 50023 | 589 | 2 |
767579 | 767579 | 2020-11-25 | Washington | Vermont | 50023 | 589 | 2 |
764334 | 764334 | 2020-11-24 | Washington | Vermont | 50023 | 574 | 2 |
761089 | 761089 | 2020-11-23 | Washington | Vermont | 50023 | 567 | 2 |
757844 | 757844 | 2020-11-22 | Washington | Vermont | 50023 | 548 | 2 |
754597 | 754597 | 2020-11-21 | Washington | Vermont | 50023 | 519 | 2 |
751351 | 751351 | 2020-11-20 | Washington | Vermont | 50023 | 501 | 2 |
748105 | 748105 | 2020-11-19 | Washington | Vermont | 50023 | 470 | 2 |
744859 | 744859 | 2020-11-18 | Washington | Vermont | 50023 | 420 | 2 |
741612 | 741612 | 2020-11-17 | Washington | Vermont | 50023 | 403 | 2 |
738365 | 738365 | 2020-11-16 | Washington | Vermont | 50023 | 370 | 2 |
735121 | 735121 | 2020-11-15 | Washington | Vermont | 50023 | 331 | 2 |
731875 | 731875 | 2020-11-14 | Washington | Vermont | 50023 | 318 | 2 |
728630 | 728630 | 2020-11-13 | Washington | Vermont | 50023 | 278 | 2 |
725387 | 725387 | 2020-11-12 | Washington | Vermont | 50023 | 250 | 2 |
722144 | 722144 | 2020-11-11 | Washington | Vermont | 50023 | 199 | 2 |
718901 | 718901 | 2020-11-10 | Washington | Vermont | 50023 | 180 | 2 |
715658 | 715658 | 2020-11-09 | Washington | Vermont | 50023 | 167 | 2 |
712414 | 712414 | 2020-11-08 | Washington | Vermont | 50023 | 163 | 2 |
709170 | 709170 | 2020-11-07 | Washington | Vermont | 50023 | 154 | 2 |
705926 | 705926 | 2020-11-06 | Washington | Vermont | 50023 | 150 | 2 |
702683 | 702683 | 2020-11-05 | Washington | Vermont | 50023 | 145 | 2 |
699440 | 699440 | 2020-11-04 | Washington | Vermont | 50023 | 141 | 2 |
696196 | 696196 | 2020-11-03 | Washington | Vermont | 50023 | 138 | 2 |
692954 | 692954 | 2020-11-02 | Washington | Vermont | 50023 | 137 | 2 |
689710 | 689710 | 2020-11-01 | Washington | Vermont | 50023 | 137 | 2 |
686465 | 686465 | 2020-10-31 | Washington | Vermont | 50023 | 134 | 2 |
683222 | 683222 | 2020-10-30 | Washington | Vermont | 50023 | 133 | 2 |
679979 | 679979 | 2020-10-29 | Washington | Vermont | 50023 | 133 | 2 |
676736 | 676736 | 2020-10-28 | Washington | Vermont | 50023 | 132 | 2 |
673493 | 673493 | 2020-10-27 | Washington | Vermont | 50023 | 131 | 2 |
670251 | 670251 | 2020-10-26 | Washington | Vermont | 50023 | 125 | 2 |
667008 | 667008 | 2020-10-25 | Washington | Vermont | 50023 | 124 | 2 |
663763 | 663763 | 2020-10-24 | Washington | Vermont | 50023 | 122 | 2 |
660519 | 660519 | 2020-10-23 | Washington | Vermont | 50023 | 119 | 2 |
657275 | 657275 | 2020-10-22 | Washington | Vermont | 50023 | 109 | 2 |
654030 | 654030 | 2020-10-21 | Washington | Vermont | 50023 | 107 | 2 |
650785 | 650785 | 2020-10-20 | Washington | Vermont | 50023 | 104 | 2 |
647541 | 647541 | 2020-10-19 | Washington | Vermont | 50023 | 101 | 2 |
644295 | 644295 | 2020-10-18 | Washington | Vermont | 50023 | 99 | 2 |
641047 | 641047 | 2020-10-17 | Washington | Vermont | 50023 | 96 | 2 |
637800 | 637800 | 2020-10-16 | Washington | Vermont | 50023 | 94 | 2 |
634555 | 634555 | 2020-10-15 | Washington | Vermont | 50023 | 92 | 2 |
631310 | 631310 | 2020-10-14 | Washington | Vermont | 50023 | 90 | 2 |
628066 | 628066 | 2020-10-13 | Washington | Vermont | 50023 | 89 | 2 |
624823 | 624823 | 2020-10-12 | Washington | Vermont | 50023 | 86 | 2 |
621580 | 621580 | 2020-10-11 | Washington | Vermont | 50023 | 82 | 2 |
618337 | 618337 | 2020-10-10 | Washington | Vermont | 50023 | 82 | 2 |
615095 | 615095 | 2020-10-09 | Washington | Vermont | 50023 | 81 | 2 |
611854 | 611854 | 2020-10-08 | Washington | Vermont | 50023 | 81 | 2 |
608612 | 608612 | 2020-10-07 | Washington | Vermont | 50023 | 78 | 2 |
605369 | 605369 | 2020-10-06 | Washington | Vermont | 50023 | 78 | 2 |
602127 | 602127 | 2020-10-05 | Washington | Vermont | 50023 | 78 | 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);