ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Bayfield" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199514 | 1199514 | 2021-04-07 | Bayfield | Wisconsin | 55007 | 1206 | 19 |
1196265 | 1196265 | 2021-04-06 | Bayfield | Wisconsin | 55007 | 1200 | 19 |
1193017 | 1193017 | 2021-04-05 | Bayfield | Wisconsin | 55007 | 1200 | 19 |
1189767 | 1189767 | 2021-04-04 | Bayfield | Wisconsin | 55007 | 1197 | 19 |
1186520 | 1186520 | 2021-04-03 | Bayfield | Wisconsin | 55007 | 1192 | 20 |
1183273 | 1183273 | 2021-04-02 | Bayfield | Wisconsin | 55007 | 1186 | 19 |
1180026 | 1180026 | 2021-04-01 | Bayfield | Wisconsin | 55007 | 1182 | 19 |
1176779 | 1176779 | 2021-03-31 | Bayfield | Wisconsin | 55007 | 1178 | 19 |
1173532 | 1173532 | 2021-03-30 | Bayfield | Wisconsin | 55007 | 1174 | 19 |
1170285 | 1170285 | 2021-03-29 | Bayfield | Wisconsin | 55007 | 1171 | 19 |
1167037 | 1167037 | 2021-03-28 | Bayfield | Wisconsin | 55007 | 1168 | 19 |
1163789 | 1163789 | 2021-03-27 | Bayfield | Wisconsin | 55007 | 1167 | 19 |
1160541 | 1160541 | 2021-03-26 | Bayfield | Wisconsin | 55007 | 1164 | 19 |
1157293 | 1157293 | 2021-03-25 | Bayfield | Wisconsin | 55007 | 1162 | 19 |
1154046 | 1154046 | 2021-03-24 | Bayfield | Wisconsin | 55007 | 1161 | 19 |
1150799 | 1150799 | 2021-03-23 | Bayfield | Wisconsin | 55007 | 1158 | 19 |
1147552 | 1147552 | 2021-03-22 | Bayfield | Wisconsin | 55007 | 1158 | 19 |
1144305 | 1144305 | 2021-03-21 | Bayfield | Wisconsin | 55007 | 1157 | 19 |
1141058 | 1141058 | 2021-03-20 | Bayfield | Wisconsin | 55007 | 1155 | 19 |
1137812 | 1137812 | 2021-03-19 | Bayfield | Wisconsin | 55007 | 1153 | 19 |
1134566 | 1134566 | 2021-03-18 | Bayfield | Wisconsin | 55007 | 1151 | 19 |
1131318 | 1131318 | 2021-03-17 | Bayfield | Wisconsin | 55007 | 1150 | 19 |
1128071 | 1128071 | 2021-03-16 | Bayfield | Wisconsin | 55007 | 1148 | 19 |
1124825 | 1124825 | 2021-03-15 | Bayfield | Wisconsin | 55007 | 1148 | 19 |
1121579 | 1121579 | 2021-03-14 | Bayfield | Wisconsin | 55007 | 1147 | 19 |
1118332 | 1118332 | 2021-03-13 | Bayfield | Wisconsin | 55007 | 1147 | 19 |
1115085 | 1115085 | 2021-03-12 | Bayfield | Wisconsin | 55007 | 1146 | 19 |
1111839 | 1111839 | 2021-03-11 | Bayfield | Wisconsin | 55007 | 1145 | 19 |
1108593 | 1108593 | 2021-03-10 | Bayfield | Wisconsin | 55007 | 1144 | 19 |
1105347 | 1105347 | 2021-03-09 | Bayfield | Wisconsin | 55007 | 1144 | 19 |
1102101 | 1102101 | 2021-03-08 | Bayfield | Wisconsin | 55007 | 1144 | 19 |
1098855 | 1098855 | 2021-03-07 | Bayfield | Wisconsin | 55007 | 1144 | 19 |
1095607 | 1095607 | 2021-03-06 | Bayfield | Wisconsin | 55007 | 1144 | 19 |
1092361 | 1092361 | 2021-03-05 | Bayfield | Wisconsin | 55007 | 1144 | 19 |
1089115 | 1089115 | 2021-03-04 | Bayfield | Wisconsin | 55007 | 1142 | 19 |
1085870 | 1085870 | 2021-03-03 | Bayfield | Wisconsin | 55007 | 1141 | 19 |
1082624 | 1082624 | 2021-03-02 | Bayfield | Wisconsin | 55007 | 1140 | 19 |
1079378 | 1079378 | 2021-03-01 | Bayfield | Wisconsin | 55007 | 1140 | 19 |
1076133 | 1076133 | 2021-02-28 | Bayfield | Wisconsin | 55007 | 1139 | 19 |
1072887 | 1072887 | 2021-02-27 | Bayfield | Wisconsin | 55007 | 1138 | 19 |
1069641 | 1069641 | 2021-02-26 | Bayfield | Wisconsin | 55007 | 1137 | 19 |
1066396 | 1066396 | 2021-02-25 | Bayfield | Wisconsin | 55007 | 1136 | 19 |
1063151 | 1063151 | 2021-02-24 | Bayfield | Wisconsin | 55007 | 1136 | 19 |
1059906 | 1059906 | 2021-02-23 | Bayfield | Wisconsin | 55007 | 1135 | 19 |
1056660 | 1056660 | 2021-02-22 | Bayfield | Wisconsin | 55007 | 1132 | 19 |
1053414 | 1053414 | 2021-02-21 | Bayfield | Wisconsin | 55007 | 1132 | 19 |
1050167 | 1050167 | 2021-02-20 | Bayfield | Wisconsin | 55007 | 1131 | 19 |
1046920 | 1046920 | 2021-02-19 | Bayfield | Wisconsin | 55007 | 1130 | 19 |
1043675 | 1043675 | 2021-02-18 | Bayfield | Wisconsin | 55007 | 1130 | 18 |
1040430 | 1040430 | 2021-02-17 | Bayfield | Wisconsin | 55007 | 1130 | 18 |
1037185 | 1037185 | 2021-02-16 | Bayfield | Wisconsin | 55007 | 1129 | 18 |
1033940 | 1033940 | 2021-02-15 | Bayfield | Wisconsin | 55007 | 1130 | 18 |
1030694 | 1030694 | 2021-02-14 | Bayfield | Wisconsin | 55007 | 1130 | 18 |
1027447 | 1027447 | 2021-02-13 | Bayfield | Wisconsin | 55007 | 1128 | 18 |
1024202 | 1024202 | 2021-02-12 | Bayfield | Wisconsin | 55007 | 1128 | 18 |
1020957 | 1020957 | 2021-02-11 | Bayfield | Wisconsin | 55007 | 1124 | 18 |
1017712 | 1017712 | 2021-02-10 | Bayfield | Wisconsin | 55007 | 1122 | 18 |
1014467 | 1014467 | 2021-02-09 | Bayfield | Wisconsin | 55007 | 1122 | 18 |
1011222 | 1011222 | 2021-02-08 | Bayfield | Wisconsin | 55007 | 1122 | 18 |
1007976 | 1007976 | 2021-02-07 | Bayfield | Wisconsin | 55007 | 1118 | 18 |
1004730 | 1004730 | 2021-02-06 | Bayfield | Wisconsin | 55007 | 1116 | 18 |
1001484 | 1001484 | 2021-02-05 | Bayfield | Wisconsin | 55007 | 1113 | 18 |
998238 | 998238 | 2021-02-04 | Bayfield | Wisconsin | 55007 | 1103 | 18 |
994992 | 994992 | 2021-02-03 | Bayfield | Wisconsin | 55007 | 1099 | 18 |
991746 | 991746 | 2021-02-02 | Bayfield | Wisconsin | 55007 | 1094 | 18 |
988500 | 988500 | 2021-02-01 | Bayfield | Wisconsin | 55007 | 1092 | 18 |
985253 | 985253 | 2021-01-31 | Bayfield | Wisconsin | 55007 | 1090 | 18 |
982006 | 982006 | 2021-01-30 | Bayfield | Wisconsin | 55007 | 1088 | 18 |
978760 | 978760 | 2021-01-29 | Bayfield | Wisconsin | 55007 | 1086 | 18 |
975515 | 975515 | 2021-01-28 | Bayfield | Wisconsin | 55007 | 1086 | 18 |
972270 | 972270 | 2021-01-27 | Bayfield | Wisconsin | 55007 | 1082 | 18 |
969025 | 969025 | 2021-01-26 | Bayfield | Wisconsin | 55007 | 1083 | 18 |
965781 | 965781 | 2021-01-25 | Bayfield | Wisconsin | 55007 | 1081 | 18 |
962536 | 962536 | 2021-01-24 | Bayfield | Wisconsin | 55007 | 1075 | 18 |
959291 | 959291 | 2021-01-23 | Bayfield | Wisconsin | 55007 | 1072 | 18 |
956045 | 956045 | 2021-01-22 | Bayfield | Wisconsin | 55007 | 1071 | 18 |
952800 | 952800 | 2021-01-21 | Bayfield | Wisconsin | 55007 | 1065 | 18 |
949555 | 949555 | 2021-01-20 | Bayfield | Wisconsin | 55007 | 1058 | 18 |
946309 | 946309 | 2021-01-19 | Bayfield | Wisconsin | 55007 | 1055 | 18 |
943062 | 943062 | 2021-01-18 | Bayfield | Wisconsin | 55007 | 1051 | 18 |
939817 | 939817 | 2021-01-17 | Bayfield | Wisconsin | 55007 | 1048 | 18 |
936572 | 936572 | 2021-01-16 | Bayfield | Wisconsin | 55007 | 1044 | 18 |
933327 | 933327 | 2021-01-15 | Bayfield | Wisconsin | 55007 | 1028 | 18 |
930082 | 930082 | 2021-01-14 | Bayfield | Wisconsin | 55007 | 1026 | 18 |
926837 | 926837 | 2021-01-13 | Bayfield | Wisconsin | 55007 | 1015 | 18 |
923591 | 923591 | 2021-01-12 | Bayfield | Wisconsin | 55007 | 1012 | 18 |
920346 | 920346 | 2021-01-11 | Bayfield | Wisconsin | 55007 | 1006 | 18 |
917101 | 917101 | 2021-01-10 | Bayfield | Wisconsin | 55007 | 999 | 18 |
913856 | 913856 | 2021-01-09 | Bayfield | Wisconsin | 55007 | 992 | 18 |
910611 | 910611 | 2021-01-08 | Bayfield | Wisconsin | 55007 | 988 | 18 |
907366 | 907366 | 2021-01-07 | Bayfield | Wisconsin | 55007 | 983 | 18 |
904120 | 904120 | 2021-01-06 | Bayfield | Wisconsin | 55007 | 981 | 18 |
900875 | 900875 | 2021-01-05 | Bayfield | Wisconsin | 55007 | 973 | 18 |
897630 | 897630 | 2021-01-04 | Bayfield | Wisconsin | 55007 | 970 | 18 |
894384 | 894384 | 2021-01-03 | Bayfield | Wisconsin | 55007 | 968 | 18 |
891138 | 891138 | 2021-01-02 | Bayfield | Wisconsin | 55007 | 964 | 18 |
887891 | 887891 | 2021-01-01 | Bayfield | Wisconsin | 55007 | 964 | 18 |
884646 | 884646 | 2020-12-31 | Bayfield | Wisconsin | 55007 | 964 | 18 |
881401 | 881401 | 2020-12-30 | Bayfield | Wisconsin | 55007 | 950 | 18 |
878156 | 878156 | 2020-12-29 | Bayfield | Wisconsin | 55007 | 946 | 18 |
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);