ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 50027 and state = "Vermont" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056426 | 1056426 | 2021-02-22 | Windsor | Vermont | 50027 | 1017 | 9 |
1053180 | 1053180 | 2021-02-21 | Windsor | Vermont | 50027 | 1012 | 9 |
1049933 | 1049933 | 2021-02-20 | Windsor | Vermont | 50027 | 1009 | 9 |
1046686 | 1046686 | 2021-02-19 | Windsor | Vermont | 50027 | 1007 | 9 |
1043441 | 1043441 | 2021-02-18 | Windsor | Vermont | 50027 | 1002 | 9 |
1040196 | 1040196 | 2021-02-17 | Windsor | Vermont | 50027 | 996 | 9 |
1036951 | 1036951 | 2021-02-16 | Windsor | Vermont | 50027 | 991 | 9 |
1033706 | 1033706 | 2021-02-15 | Windsor | Vermont | 50027 | 988 | 9 |
1030460 | 1030460 | 2021-02-14 | Windsor | Vermont | 50027 | 976 | 9 |
1027213 | 1027213 | 2021-02-13 | Windsor | Vermont | 50027 | 971 | 9 |
1023968 | 1023968 | 2021-02-12 | Windsor | Vermont | 50027 | 961 | 9 |
1020723 | 1020723 | 2021-02-11 | Windsor | Vermont | 50027 | 949 | 9 |
1017478 | 1017478 | 2021-02-10 | Windsor | Vermont | 50027 | 927 | 9 |
1014233 | 1014233 | 2021-02-09 | Windsor | Vermont | 50027 | 924 | 9 |
1010988 | 1010988 | 2021-02-08 | Windsor | Vermont | 50027 | 917 | 8 |
1007742 | 1007742 | 2021-02-07 | Windsor | Vermont | 50027 | 910 | 8 |
1004496 | 1004496 | 2021-02-06 | Windsor | Vermont | 50027 | 902 | 7 |
1001250 | 1001250 | 2021-02-05 | Windsor | Vermont | 50027 | 895 | 7 |
998004 | 998004 | 2021-02-04 | Windsor | Vermont | 50027 | 888 | 7 |
994758 | 994758 | 2021-02-03 | Windsor | Vermont | 50027 | 874 | 7 |
991512 | 991512 | 2021-02-02 | Windsor | Vermont | 50027 | 868 | 6 |
988266 | 988266 | 2021-02-01 | Windsor | Vermont | 50027 | 862 | 6 |
985019 | 985019 | 2021-01-31 | Windsor | Vermont | 50027 | 853 | 6 |
981772 | 981772 | 2021-01-30 | Windsor | Vermont | 50027 | 845 | 6 |
978526 | 978526 | 2021-01-29 | Windsor | Vermont | 50027 | 827 | 6 |
975281 | 975281 | 2021-01-28 | Windsor | Vermont | 50027 | 810 | 6 |
972036 | 972036 | 2021-01-27 | Windsor | Vermont | 50027 | 800 | 6 |
968791 | 968791 | 2021-01-26 | Windsor | Vermont | 50027 | 799 | 6 |
965547 | 965547 | 2021-01-25 | Windsor | Vermont | 50027 | 794 | 6 |
962302 | 962302 | 2021-01-24 | Windsor | Vermont | 50027 | 786 | 5 |
959057 | 959057 | 2021-01-23 | Windsor | Vermont | 50027 | 775 | 5 |
955811 | 955811 | 2021-01-22 | Windsor | Vermont | 50027 | 767 | 5 |
952566 | 952566 | 2021-01-21 | Windsor | Vermont | 50027 | 765 | 5 |
949321 | 949321 | 2021-01-20 | Windsor | Vermont | 50027 | 757 | 4 |
946075 | 946075 | 2021-01-19 | Windsor | Vermont | 50027 | 743 | 4 |
942828 | 942828 | 2021-01-18 | Windsor | Vermont | 50027 | 726 | 4 |
939583 | 939583 | 2021-01-17 | Windsor | Vermont | 50027 | 709 | 4 |
936338 | 936338 | 2021-01-16 | Windsor | Vermont | 50027 | 690 | 4 |
933093 | 933093 | 2021-01-15 | Windsor | Vermont | 50027 | 678 | 4 |
929848 | 929848 | 2021-01-14 | Windsor | Vermont | 50027 | 656 | 4 |
926603 | 926603 | 2021-01-13 | Windsor | Vermont | 50027 | 624 | 3 |
923357 | 923357 | 2021-01-12 | Windsor | Vermont | 50027 | 598 | 3 |
920112 | 920112 | 2021-01-11 | Windsor | Vermont | 50027 | 578 | 3 |
916867 | 916867 | 2021-01-10 | Windsor | Vermont | 50027 | 566 | 3 |
913622 | 913622 | 2021-01-09 | Windsor | Vermont | 50027 | 543 | 3 |
910377 | 910377 | 2021-01-08 | Windsor | Vermont | 50027 | 529 | 3 |
907132 | 907132 | 2021-01-07 | Windsor | Vermont | 50027 | 504 | 3 |
903886 | 903886 | 2021-01-06 | Windsor | Vermont | 50027 | 480 | 3 |
900641 | 900641 | 2021-01-05 | Windsor | Vermont | 50027 | 463 | 3 |
897396 | 897396 | 2021-01-04 | Windsor | Vermont | 50027 | 446 | 3 |
894150 | 894150 | 2021-01-03 | Windsor | Vermont | 50027 | 442 | 3 |
890904 | 890904 | 2021-01-02 | Windsor | Vermont | 50027 | 434 | 3 |
887657 | 887657 | 2021-01-01 | Windsor | Vermont | 50027 | 404 | 3 |
884412 | 884412 | 2020-12-31 | Windsor | Vermont | 50027 | 404 | 3 |
881167 | 881167 | 2020-12-30 | Windsor | Vermont | 50027 | 389 | 3 |
877922 | 877922 | 2020-12-29 | Windsor | Vermont | 50027 | 385 | 3 |
874677 | 874677 | 2020-12-28 | Windsor | Vermont | 50027 | 377 | 3 |
871432 | 871432 | 2020-12-27 | Windsor | Vermont | 50027 | 377 | 3 |
868187 | 868187 | 2020-12-26 | Windsor | Vermont | 50027 | 373 | 3 |
864942 | 864942 | 2020-12-25 | Windsor | Vermont | 50027 | 353 | 3 |
861697 | 861697 | 2020-12-24 | Windsor | Vermont | 50027 | 353 | 3 |
858452 | 858452 | 2020-12-23 | Windsor | Vermont | 50027 | 347 | 3 |
855207 | 855207 | 2020-12-22 | Windsor | Vermont | 50027 | 347 | 3 |
851962 | 851962 | 2020-12-21 | Windsor | Vermont | 50027 | 342 | 3 |
848717 | 848717 | 2020-12-20 | Windsor | Vermont | 50027 | 338 | 3 |
845472 | 845472 | 2020-12-19 | Windsor | Vermont | 50027 | 335 | 3 |
842226 | 842226 | 2020-12-18 | Windsor | Vermont | 50027 | 326 | 3 |
838981 | 838981 | 2020-12-17 | Windsor | Vermont | 50027 | 325 | 2 |
835735 | 835735 | 2020-12-16 | Windsor | Vermont | 50027 | 312 | 2 |
832489 | 832489 | 2020-12-15 | Windsor | Vermont | 50027 | 305 | 2 |
829242 | 829242 | 2020-12-14 | Windsor | Vermont | 50027 | 298 | 2 |
825996 | 825996 | 2020-12-13 | Windsor | Vermont | 50027 | 295 | 2 |
822749 | 822749 | 2020-12-12 | Windsor | Vermont | 50027 | 292 | 2 |
819503 | 819503 | 2020-12-11 | Windsor | Vermont | 50027 | 285 | 2 |
816257 | 816257 | 2020-12-10 | Windsor | Vermont | 50027 | 279 | 2 |
813011 | 813011 | 2020-12-09 | Windsor | Vermont | 50027 | 271 | 2 |
809767 | 809767 | 2020-12-08 | Windsor | Vermont | 50027 | 261 | 2 |
806522 | 806522 | 2020-12-07 | Windsor | Vermont | 50027 | 254 | 2 |
803277 | 803277 | 2020-12-06 | Windsor | Vermont | 50027 | 252 | 2 |
800032 | 800032 | 2020-12-05 | Windsor | Vermont | 50027 | 241 | 2 |
796787 | 796787 | 2020-12-04 | Windsor | Vermont | 50027 | 227 | 2 |
793542 | 793542 | 2020-12-03 | Windsor | Vermont | 50027 | 221 | 2 |
790297 | 790297 | 2020-12-02 | Windsor | Vermont | 50027 | 218 | 2 |
787052 | 787052 | 2020-12-01 | Windsor | Vermont | 50027 | 209 | 2 |
783808 | 783808 | 2020-11-30 | Windsor | Vermont | 50027 | 205 | 2 |
780563 | 780563 | 2020-11-29 | Windsor | Vermont | 50027 | 203 | 2 |
777317 | 777317 | 2020-11-28 | Windsor | Vermont | 50027 | 201 | 2 |
774072 | 774072 | 2020-11-27 | Windsor | Vermont | 50027 | 199 | 2 |
770827 | 770827 | 2020-11-26 | Windsor | Vermont | 50027 | 187 | 2 |
767581 | 767581 | 2020-11-25 | Windsor | Vermont | 50027 | 187 | 2 |
764336 | 764336 | 2020-11-24 | Windsor | Vermont | 50027 | 184 | 2 |
761091 | 761091 | 2020-11-23 | Windsor | Vermont | 50027 | 183 | 2 |
757846 | 757846 | 2020-11-22 | Windsor | Vermont | 50027 | 179 | 2 |
754599 | 754599 | 2020-11-21 | Windsor | Vermont | 50027 | 169 | 2 |
751353 | 751353 | 2020-11-20 | Windsor | Vermont | 50027 | 163 | 2 |
748107 | 748107 | 2020-11-19 | Windsor | Vermont | 50027 | 158 | 2 |
744861 | 744861 | 2020-11-18 | Windsor | Vermont | 50027 | 152 | 2 |
741614 | 741614 | 2020-11-17 | Windsor | Vermont | 50027 | 152 | 2 |
738367 | 738367 | 2020-11-16 | Windsor | Vermont | 50027 | 152 | 2 |
735123 | 735123 | 2020-11-15 | Windsor | Vermont | 50027 | 151 | 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);