ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 55003 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199512 | 1199512 | 2021-04-07 | Ashland | Wisconsin | 55003 | 1291 | 16 |
1196263 | 1196263 | 2021-04-06 | Ashland | Wisconsin | 55003 | 1289 | 16 |
1193015 | 1193015 | 2021-04-05 | Ashland | Wisconsin | 55003 | 1286 | 16 |
1189765 | 1189765 | 2021-04-04 | Ashland | Wisconsin | 55003 | 1286 | 16 |
1186518 | 1186518 | 2021-04-03 | Ashland | Wisconsin | 55003 | 1286 | 16 |
1183271 | 1183271 | 2021-04-02 | Ashland | Wisconsin | 55003 | 1283 | 16 |
1180024 | 1180024 | 2021-04-01 | Ashland | Wisconsin | 55003 | 1279 | 16 |
1176777 | 1176777 | 2021-03-31 | Ashland | Wisconsin | 55003 | 1274 | 16 |
1173530 | 1173530 | 2021-03-30 | Ashland | Wisconsin | 55003 | 1273 | 16 |
1170283 | 1170283 | 2021-03-29 | Ashland | Wisconsin | 55003 | 1273 | 16 |
1167035 | 1167035 | 2021-03-28 | Ashland | Wisconsin | 55003 | 1273 | 16 |
1163787 | 1163787 | 2021-03-27 | Ashland | Wisconsin | 55003 | 1272 | 16 |
1160539 | 1160539 | 2021-03-26 | Ashland | Wisconsin | 55003 | 1271 | 16 |
1157291 | 1157291 | 2021-03-25 | Ashland | Wisconsin | 55003 | 1269 | 16 |
1154044 | 1154044 | 2021-03-24 | Ashland | Wisconsin | 55003 | 1269 | 16 |
1150797 | 1150797 | 2021-03-23 | Ashland | Wisconsin | 55003 | 1264 | 16 |
1147550 | 1147550 | 2021-03-22 | Ashland | Wisconsin | 55003 | 1264 | 16 |
1144303 | 1144303 | 2021-03-21 | Ashland | Wisconsin | 55003 | 1264 | 16 |
1141056 | 1141056 | 2021-03-20 | Ashland | Wisconsin | 55003 | 1261 | 16 |
1137810 | 1137810 | 2021-03-19 | Ashland | Wisconsin | 55003 | 1259 | 16 |
1134564 | 1134564 | 2021-03-18 | Ashland | Wisconsin | 55003 | 1257 | 16 |
1131316 | 1131316 | 2021-03-17 | Ashland | Wisconsin | 55003 | 1257 | 16 |
1128069 | 1128069 | 2021-03-16 | Ashland | Wisconsin | 55003 | 1257 | 16 |
1124823 | 1124823 | 2021-03-15 | Ashland | Wisconsin | 55003 | 1257 | 16 |
1121577 | 1121577 | 2021-03-14 | Ashland | Wisconsin | 55003 | 1255 | 16 |
1118330 | 1118330 | 2021-03-13 | Ashland | Wisconsin | 55003 | 1255 | 16 |
1115083 | 1115083 | 2021-03-12 | Ashland | Wisconsin | 55003 | 1253 | 16 |
1111837 | 1111837 | 2021-03-11 | Ashland | Wisconsin | 55003 | 1251 | 16 |
1108591 | 1108591 | 2021-03-10 | Ashland | Wisconsin | 55003 | 1251 | 16 |
1105345 | 1105345 | 2021-03-09 | Ashland | Wisconsin | 55003 | 1247 | 16 |
1102099 | 1102099 | 2021-03-08 | Ashland | Wisconsin | 55003 | 1244 | 16 |
1098853 | 1098853 | 2021-03-07 | Ashland | Wisconsin | 55003 | 1244 | 16 |
1095605 | 1095605 | 2021-03-06 | Ashland | Wisconsin | 55003 | 1243 | 16 |
1092359 | 1092359 | 2021-03-05 | Ashland | Wisconsin | 55003 | 1242 | 16 |
1089113 | 1089113 | 2021-03-04 | Ashland | Wisconsin | 55003 | 1241 | 16 |
1085868 | 1085868 | 2021-03-03 | Ashland | Wisconsin | 55003 | 1241 | 16 |
1082622 | 1082622 | 2021-03-02 | Ashland | Wisconsin | 55003 | 1241 | 16 |
1079376 | 1079376 | 2021-03-01 | Ashland | Wisconsin | 55003 | 1241 | 16 |
1076131 | 1076131 | 2021-02-28 | Ashland | Wisconsin | 55003 | 1241 | 16 |
1072885 | 1072885 | 2021-02-27 | Ashland | Wisconsin | 55003 | 1241 | 16 |
1069639 | 1069639 | 2021-02-26 | Ashland | Wisconsin | 55003 | 1240 | 16 |
1066394 | 1066394 | 2021-02-25 | Ashland | Wisconsin | 55003 | 1238 | 16 |
1063149 | 1063149 | 2021-02-24 | Ashland | Wisconsin | 55003 | 1235 | 16 |
1059904 | 1059904 | 2021-02-23 | Ashland | Wisconsin | 55003 | 1237 | 16 |
1056658 | 1056658 | 2021-02-22 | Ashland | Wisconsin | 55003 | 1235 | 16 |
1053412 | 1053412 | 2021-02-21 | Ashland | Wisconsin | 55003 | 1235 | 16 |
1050165 | 1050165 | 2021-02-20 | Ashland | Wisconsin | 55003 | 1236 | 16 |
1046918 | 1046918 | 2021-02-19 | Ashland | Wisconsin | 55003 | 1236 | 16 |
1043673 | 1043673 | 2021-02-18 | Ashland | Wisconsin | 55003 | 1234 | 16 |
1040428 | 1040428 | 2021-02-17 | Ashland | Wisconsin | 55003 | 1234 | 16 |
1037183 | 1037183 | 2021-02-16 | Ashland | Wisconsin | 55003 | 1232 | 16 |
1033938 | 1033938 | 2021-02-15 | Ashland | Wisconsin | 55003 | 1232 | 16 |
1030692 | 1030692 | 2021-02-14 | Ashland | Wisconsin | 55003 | 1231 | 16 |
1027445 | 1027445 | 2021-02-13 | Ashland | Wisconsin | 55003 | 1231 | 16 |
1024200 | 1024200 | 2021-02-12 | Ashland | Wisconsin | 55003 | 1232 | 16 |
1020955 | 1020955 | 2021-02-11 | Ashland | Wisconsin | 55003 | 1230 | 16 |
1017710 | 1017710 | 2021-02-10 | Ashland | Wisconsin | 55003 | 1227 | 16 |
1014465 | 1014465 | 2021-02-09 | Ashland | Wisconsin | 55003 | 1226 | 16 |
1011220 | 1011220 | 2021-02-08 | Ashland | Wisconsin | 55003 | 1225 | 16 |
1007974 | 1007974 | 2021-02-07 | Ashland | Wisconsin | 55003 | 1224 | 16 |
1004728 | 1004728 | 2021-02-06 | Ashland | Wisconsin | 55003 | 1224 | 16 |
1001482 | 1001482 | 2021-02-05 | Ashland | Wisconsin | 55003 | 1223 | 16 |
998236 | 998236 | 2021-02-04 | Ashland | Wisconsin | 55003 | 1218 | 16 |
994990 | 994990 | 2021-02-03 | Ashland | Wisconsin | 55003 | 1212 | 16 |
991744 | 991744 | 2021-02-02 | Ashland | Wisconsin | 55003 | 1210 | 16 |
988498 | 988498 | 2021-02-01 | Ashland | Wisconsin | 55003 | 1210 | 16 |
985251 | 985251 | 2021-01-31 | Ashland | Wisconsin | 55003 | 1208 | 16 |
982004 | 982004 | 2021-01-30 | Ashland | Wisconsin | 55003 | 1208 | 16 |
978758 | 978758 | 2021-01-29 | Ashland | Wisconsin | 55003 | 1200 | 16 |
975513 | 975513 | 2021-01-28 | Ashland | Wisconsin | 55003 | 1197 | 16 |
972268 | 972268 | 2021-01-27 | Ashland | Wisconsin | 55003 | 1192 | 16 |
969023 | 969023 | 2021-01-26 | Ashland | Wisconsin | 55003 | 1190 | 16 |
965779 | 965779 | 2021-01-25 | Ashland | Wisconsin | 55003 | 1189 | 16 |
962534 | 962534 | 2021-01-24 | Ashland | Wisconsin | 55003 | 1186 | 16 |
959289 | 959289 | 2021-01-23 | Ashland | Wisconsin | 55003 | 1181 | 16 |
956043 | 956043 | 2021-01-22 | Ashland | Wisconsin | 55003 | 1176 | 16 |
952798 | 952798 | 2021-01-21 | Ashland | Wisconsin | 55003 | 1171 | 16 |
949553 | 949553 | 2021-01-20 | Ashland | Wisconsin | 55003 | 1165 | 16 |
946307 | 946307 | 2021-01-19 | Ashland | Wisconsin | 55003 | 1163 | 16 |
943060 | 943060 | 2021-01-18 | Ashland | Wisconsin | 55003 | 1154 | 16 |
939815 | 939815 | 2021-01-17 | Ashland | Wisconsin | 55003 | 1150 | 16 |
936570 | 936570 | 2021-01-16 | Ashland | Wisconsin | 55003 | 1145 | 16 |
933325 | 933325 | 2021-01-15 | Ashland | Wisconsin | 55003 | 1142 | 16 |
930080 | 930080 | 2021-01-14 | Ashland | Wisconsin | 55003 | 1138 | 16 |
926835 | 926835 | 2021-01-13 | Ashland | Wisconsin | 55003 | 1133 | 16 |
923589 | 923589 | 2021-01-12 | Ashland | Wisconsin | 55003 | 1121 | 16 |
920344 | 920344 | 2021-01-11 | Ashland | Wisconsin | 55003 | 1120 | 16 |
917099 | 917099 | 2021-01-10 | Ashland | Wisconsin | 55003 | 1113 | 16 |
913854 | 913854 | 2021-01-09 | Ashland | Wisconsin | 55003 | 1111 | 16 |
910609 | 910609 | 2021-01-08 | Ashland | Wisconsin | 55003 | 1099 | 16 |
907364 | 907364 | 2021-01-07 | Ashland | Wisconsin | 55003 | 1091 | 16 |
904118 | 904118 | 2021-01-06 | Ashland | Wisconsin | 55003 | 1083 | 16 |
900873 | 900873 | 2021-01-05 | Ashland | Wisconsin | 55003 | 1076 | 16 |
897628 | 897628 | 2021-01-04 | Ashland | Wisconsin | 55003 | 1067 | 16 |
894382 | 894382 | 2021-01-03 | Ashland | Wisconsin | 55003 | 1066 | 16 |
891136 | 891136 | 2021-01-02 | Ashland | Wisconsin | 55003 | 1063 | 16 |
887889 | 887889 | 2021-01-01 | Ashland | Wisconsin | 55003 | 1061 | 16 |
884644 | 884644 | 2020-12-31 | Ashland | Wisconsin | 55003 | 1059 | 16 |
881399 | 881399 | 2020-12-30 | Ashland | Wisconsin | 55003 | 1037 | 16 |
878154 | 878154 | 2020-12-29 | Ashland | Wisconsin | 55003 | 1033 | 15 |
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);