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 |
---|---|---|---|---|---|---|---|
1196030 | 1196030 | 2021-04-06 | Windsor | Vermont | 50027 | 1220 | 12 |
1192782 | 1192782 | 2021-04-05 | Windsor | Vermont | 50027 | 1220 | 12 |
1189533 | 1189533 | 2021-04-04 | Windsor | Vermont | 50027 | 1218 | 12 |
1186286 | 1186286 | 2021-04-03 | Windsor | Vermont | 50027 | 1209 | 12 |
1183039 | 1183039 | 2021-04-02 | Windsor | Vermont | 50027 | 1208 | 12 |
1179792 | 1179792 | 2021-04-01 | Windsor | Vermont | 50027 | 1196 | 12 |
1176545 | 1176545 | 2021-03-31 | Windsor | Vermont | 50027 | 1179 | 12 |
1173298 | 1173298 | 2021-03-30 | Windsor | Vermont | 50027 | 1177 | 12 |
1170051 | 1170051 | 2021-03-29 | Windsor | Vermont | 50027 | 1172 | 12 |
1166803 | 1166803 | 2021-03-28 | Windsor | Vermont | 50027 | 1168 | 12 |
1163555 | 1163555 | 2021-03-27 | Windsor | Vermont | 50027 | 1163 | 12 |
1160306 | 1160306 | 2021-03-26 | Windsor | Vermont | 50027 | 1152 | 12 |
1157059 | 1157059 | 2021-03-25 | Windsor | Vermont | 50027 | 1146 | 12 |
1153812 | 1153812 | 2021-03-24 | Windsor | Vermont | 50027 | 1138 | 12 |
1150565 | 1150565 | 2021-03-23 | Windsor | Vermont | 50027 | 1135 | 12 |
1147318 | 1147318 | 2021-03-22 | Windsor | Vermont | 50027 | 1134 | 11 |
1144071 | 1144071 | 2021-03-21 | Windsor | Vermont | 50027 | 1134 | 11 |
1140824 | 1140824 | 2021-03-20 | Windsor | Vermont | 50027 | 1131 | 11 |
1137578 | 1137578 | 2021-03-19 | Windsor | Vermont | 50027 | 1124 | 11 |
1134332 | 1134332 | 2021-03-18 | Windsor | Vermont | 50027 | 1119 | 11 |
1131084 | 1131084 | 2021-03-17 | Windsor | Vermont | 50027 | 1110 | 11 |
1127837 | 1127837 | 2021-03-16 | Windsor | Vermont | 50027 | 1104 | 11 |
1124591 | 1124591 | 2021-03-15 | Windsor | Vermont | 50027 | 1104 | 11 |
1121345 | 1121345 | 2021-03-14 | Windsor | Vermont | 50027 | 1102 | 11 |
1118098 | 1118098 | 2021-03-13 | Windsor | Vermont | 50027 | 1099 | 11 |
1114851 | 1114851 | 2021-03-12 | Windsor | Vermont | 50027 | 1095 | 11 |
1111605 | 1111605 | 2021-03-11 | Windsor | Vermont | 50027 | 1085 | 10 |
1108359 | 1108359 | 2021-03-10 | Windsor | Vermont | 50027 | 1082 | 10 |
1105113 | 1105113 | 2021-03-09 | Windsor | Vermont | 50027 | 1076 | 10 |
1101867 | 1101867 | 2021-03-08 | Windsor | Vermont | 50027 | 1074 | 10 |
1098621 | 1098621 | 2021-03-07 | Windsor | Vermont | 50027 | 1069 | 10 |
1095373 | 1095373 | 2021-03-06 | Windsor | Vermont | 50027 | 1066 | 10 |
1092127 | 1092127 | 2021-03-05 | Windsor | Vermont | 50027 | 1070 | 10 |
1088881 | 1088881 | 2021-03-04 | Windsor | Vermont | 50027 | 1061 | 10 |
1085636 | 1085636 | 2021-03-03 | Windsor | Vermont | 50027 | 1060 | 10 |
1082390 | 1082390 | 2021-03-02 | Windsor | Vermont | 50027 | 1056 | 10 |
1079144 | 1079144 | 2021-03-01 | Windsor | Vermont | 50027 | 1053 | 10 |
1075899 | 1075899 | 2021-02-28 | Windsor | Vermont | 50027 | 1048 | 10 |
1072653 | 1072653 | 2021-02-27 | Windsor | Vermont | 50027 | 1041 | 10 |
1069407 | 1069407 | 2021-02-26 | Windsor | Vermont | 50027 | 1034 | 10 |
1066162 | 1066162 | 2021-02-25 | Windsor | Vermont | 50027 | 1029 | 9 |
1062917 | 1062917 | 2021-02-24 | Windsor | Vermont | 50027 | 1023 | 9 |
1059672 | 1059672 | 2021-02-23 | Windsor | Vermont | 50027 | 1018 | 9 |
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 |
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);