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 |
---|---|---|---|---|---|---|---|
1056424 | 1056424 | 2021-02-22 | Washington | Vermont | 50023 | 1424 | 13 |
1053178 | 1053178 | 2021-02-21 | Washington | Vermont | 50023 | 1416 | 13 |
1049931 | 1049931 | 2021-02-20 | Washington | Vermont | 50023 | 1406 | 13 |
1046684 | 1046684 | 2021-02-19 | Washington | Vermont | 50023 | 1404 | 13 |
1043439 | 1043439 | 2021-02-18 | Washington | Vermont | 50023 | 1400 | 13 |
1040194 | 1040194 | 2021-02-17 | Washington | Vermont | 50023 | 1384 | 12 |
1036949 | 1036949 | 2021-02-16 | Washington | Vermont | 50023 | 1378 | 12 |
1033704 | 1033704 | 2021-02-15 | Washington | Vermont | 50023 | 1377 | 12 |
1030458 | 1030458 | 2021-02-14 | Washington | Vermont | 50023 | 1358 | 12 |
1027211 | 1027211 | 2021-02-13 | Washington | Vermont | 50023 | 1350 | 12 |
1023966 | 1023966 | 2021-02-12 | Washington | Vermont | 50023 | 1332 | 12 |
1020721 | 1020721 | 2021-02-11 | Washington | Vermont | 50023 | 1314 | 12 |
1017476 | 1017476 | 2021-02-10 | Washington | Vermont | 50023 | 1324 | 12 |
1014231 | 1014231 | 2021-02-09 | Washington | Vermont | 50023 | 1324 | 12 |
1010986 | 1010986 | 2021-02-08 | Washington | Vermont | 50023 | 1325 | 12 |
1007740 | 1007740 | 2021-02-07 | Washington | Vermont | 50023 | 1310 | 12 |
1004494 | 1004494 | 2021-02-06 | Washington | Vermont | 50023 | 1294 | 12 |
1001248 | 1001248 | 2021-02-05 | Washington | Vermont | 50023 | 1276 | 12 |
998002 | 998002 | 2021-02-04 | Washington | Vermont | 50023 | 1270 | 12 |
994756 | 994756 | 2021-02-03 | Washington | Vermont | 50023 | 1254 | 12 |
991510 | 991510 | 2021-02-02 | Washington | Vermont | 50023 | 1234 | 12 |
988264 | 988264 | 2021-02-01 | Washington | Vermont | 50023 | 1225 | 12 |
985017 | 985017 | 2021-01-31 | Washington | Vermont | 50023 | 1217 | 12 |
981770 | 981770 | 2021-01-30 | Washington | Vermont | 50023 | 1212 | 12 |
978524 | 978524 | 2021-01-29 | Washington | Vermont | 50023 | 1200 | 12 |
975279 | 975279 | 2021-01-28 | Washington | Vermont | 50023 | 1183 | 12 |
972034 | 972034 | 2021-01-27 | Washington | Vermont | 50023 | 1166 | 12 |
968789 | 968789 | 2021-01-26 | Washington | Vermont | 50023 | 1154 | 12 |
965545 | 965545 | 2021-01-25 | Washington | Vermont | 50023 | 1115 | 12 |
962300 | 962300 | 2021-01-24 | Washington | Vermont | 50023 | 1107 | 12 |
959055 | 959055 | 2021-01-23 | Washington | Vermont | 50023 | 1092 | 12 |
955809 | 955809 | 2021-01-22 | Washington | Vermont | 50023 | 1081 | 12 |
952564 | 952564 | 2021-01-21 | Washington | Vermont | 50023 | 1064 | 12 |
949319 | 949319 | 2021-01-20 | Washington | Vermont | 50023 | 1051 | 11 |
946073 | 946073 | 2021-01-19 | Washington | Vermont | 50023 | 1042 | 11 |
942826 | 942826 | 2021-01-18 | Washington | Vermont | 50023 | 1035 | 11 |
939581 | 939581 | 2021-01-17 | Washington | Vermont | 50023 | 1017 | 11 |
936336 | 936336 | 2021-01-16 | Washington | Vermont | 50023 | 1002 | 11 |
933091 | 933091 | 2021-01-15 | Washington | Vermont | 50023 | 991 | 11 |
929846 | 929846 | 2021-01-14 | Washington | Vermont | 50023 | 974 | 11 |
926601 | 926601 | 2021-01-13 | Washington | Vermont | 50023 | 968 | 10 |
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 |
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);