ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 55111 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420335 | 1420335 | 2021-06-14 | Sauk | Wisconsin | 55111 | 6230 | 56 |
1417090 | 1417090 | 2021-06-13 | Sauk | Wisconsin | 55111 | 6227 | 56 |
1413844 | 1413844 | 2021-06-12 | Sauk | Wisconsin | 55111 | 6227 | 56 |
1410599 | 1410599 | 2021-06-11 | Sauk | Wisconsin | 55111 | 6227 | 56 |
1407354 | 1407354 | 2021-06-10 | Sauk | Wisconsin | 55111 | 6227 | 56 |
1404108 | 1404108 | 2021-06-09 | Sauk | Wisconsin | 55111 | 6226 | 56 |
1400863 | 1400863 | 2021-06-08 | Sauk | Wisconsin | 55111 | 6226 | 56 |
1397618 | 1397618 | 2021-06-07 | Sauk | Wisconsin | 55111 | 6223 | 56 |
1394371 | 1394371 | 2021-06-06 | Sauk | Wisconsin | 55111 | 6223 | 56 |
1391126 | 1391126 | 2021-06-05 | Sauk | Wisconsin | 55111 | 6223 | 56 |
1387881 | 1387881 | 2021-06-04 | Sauk | Wisconsin | 55111 | 6223 | 56 |
1384636 | 1384636 | 2021-06-03 | Sauk | Wisconsin | 55111 | 6221 | 56 |
1381390 | 1381390 | 2021-06-02 | Sauk | Wisconsin | 55111 | 6217 | 55 |
1378145 | 1378145 | 2021-06-01 | Sauk | Wisconsin | 55111 | 6212 | 55 |
1374899 | 1374899 | 2021-05-31 | Sauk | Wisconsin | 55111 | 6211 | 55 |
1371654 | 1371654 | 2021-05-30 | Sauk | Wisconsin | 55111 | 6210 | 55 |
1368408 | 1368408 | 2021-05-29 | Sauk | Wisconsin | 55111 | 6210 | 55 |
1365162 | 1365162 | 2021-05-28 | Sauk | Wisconsin | 55111 | 6210 | 55 |
1361916 | 1361916 | 2021-05-27 | Sauk | Wisconsin | 55111 | 6209 | 55 |
1358670 | 1358670 | 2021-05-26 | Sauk | Wisconsin | 55111 | 6198 | 54 |
1355424 | 1355424 | 2021-05-25 | Sauk | Wisconsin | 55111 | 6193 | 54 |
1352178 | 1352178 | 2021-05-24 | Sauk | Wisconsin | 55111 | 6190 | 54 |
1348932 | 1348932 | 2021-05-23 | Sauk | Wisconsin | 55111 | 6191 | 54 |
1345684 | 1345684 | 2021-05-22 | Sauk | Wisconsin | 55111 | 6186 | 54 |
1342436 | 1342436 | 2021-05-21 | Sauk | Wisconsin | 55111 | 6177 | 54 |
1339188 | 1339188 | 2021-05-20 | Sauk | Wisconsin | 55111 | 6172 | 54 |
1335941 | 1335941 | 2021-05-19 | Sauk | Wisconsin | 55111 | 6163 | 54 |
1332694 | 1332694 | 2021-05-18 | Sauk | Wisconsin | 55111 | 6156 | 54 |
1329447 | 1329447 | 2021-05-17 | Sauk | Wisconsin | 55111 | 6150 | 54 |
1326201 | 1326201 | 2021-05-16 | Sauk | Wisconsin | 55111 | 6139 | 54 |
1322955 | 1322955 | 2021-05-15 | Sauk | Wisconsin | 55111 | 6139 | 54 |
1319709 | 1319709 | 2021-05-14 | Sauk | Wisconsin | 55111 | 6129 | 54 |
1316461 | 1316461 | 2021-05-13 | Sauk | Wisconsin | 55111 | 6115 | 54 |
1313215 | 1313215 | 2021-05-12 | Sauk | Wisconsin | 55111 | 6107 | 54 |
1309968 | 1309968 | 2021-05-11 | Sauk | Wisconsin | 55111 | 6101 | 54 |
1306722 | 1306722 | 2021-05-10 | Sauk | Wisconsin | 55111 | 6101 | 54 |
1303476 | 1303476 | 2021-05-09 | Sauk | Wisconsin | 55111 | 6100 | 54 |
1300229 | 1300229 | 2021-05-08 | Sauk | Wisconsin | 55111 | 6091 | 54 |
1296982 | 1296982 | 2021-05-07 | Sauk | Wisconsin | 55111 | 6086 | 53 |
1293736 | 1293736 | 2021-05-06 | Sauk | Wisconsin | 55111 | 6074 | 53 |
1290490 | 1290490 | 2021-05-05 | Sauk | Wisconsin | 55111 | 6066 | 53 |
1287244 | 1287244 | 2021-05-04 | Sauk | Wisconsin | 55111 | 6058 | 53 |
1283998 | 1283998 | 2021-05-03 | Sauk | Wisconsin | 55111 | 6058 | 53 |
1280751 | 1280751 | 2021-05-02 | Sauk | Wisconsin | 55111 | 6048 | 53 |
1277504 | 1277504 | 2021-05-01 | Sauk | Wisconsin | 55111 | 6032 | 53 |
1274257 | 1274257 | 2021-04-30 | Sauk | Wisconsin | 55111 | 6022 | 53 |
1271010 | 1271010 | 2021-04-29 | Sauk | Wisconsin | 55111 | 6013 | 53 |
1267763 | 1267763 | 2021-04-28 | Sauk | Wisconsin | 55111 | 6002 | 53 |
1264516 | 1264516 | 2021-04-27 | Sauk | Wisconsin | 55111 | 5991 | 53 |
1261269 | 1261269 | 2021-04-26 | Sauk | Wisconsin | 55111 | 5990 | 53 |
1258022 | 1258022 | 2021-04-25 | Sauk | Wisconsin | 55111 | 5979 | 53 |
1254775 | 1254775 | 2021-04-24 | Sauk | Wisconsin | 55111 | 5975 | 53 |
1251528 | 1251528 | 2021-04-23 | Sauk | Wisconsin | 55111 | 5966 | 52 |
1248281 | 1248281 | 2021-04-22 | Sauk | Wisconsin | 55111 | 5954 | 52 |
1245034 | 1245034 | 2021-04-21 | Sauk | Wisconsin | 55111 | 5948 | 52 |
1241787 | 1241787 | 2021-04-20 | Sauk | Wisconsin | 55111 | 5937 | 52 |
1238540 | 1238540 | 2021-04-19 | Sauk | Wisconsin | 55111 | 5933 | 52 |
1235293 | 1235293 | 2021-04-18 | Sauk | Wisconsin | 55111 | 5918 | 52 |
1232045 | 1232045 | 2021-04-17 | Sauk | Wisconsin | 55111 | 5914 | 52 |
1228797 | 1228797 | 2021-04-16 | Sauk | Wisconsin | 55111 | 5913 | 52 |
1225549 | 1225549 | 2021-04-15 | Sauk | Wisconsin | 55111 | 5910 | 52 |
1222302 | 1222302 | 2021-04-14 | Sauk | Wisconsin | 55111 | 5895 | 52 |
1219054 | 1219054 | 2021-04-13 | Sauk | Wisconsin | 55111 | 5874 | 52 |
1215806 | 1215806 | 2021-04-12 | Sauk | Wisconsin | 55111 | 5871 | 51 |
1212559 | 1212559 | 2021-04-11 | Sauk | Wisconsin | 55111 | 5862 | 51 |
1209310 | 1209310 | 2021-04-10 | Sauk | Wisconsin | 55111 | 5858 | 51 |
1206062 | 1206062 | 2021-04-09 | Sauk | Wisconsin | 55111 | 5841 | 51 |
1202814 | 1202814 | 2021-04-08 | Sauk | Wisconsin | 55111 | 5831 | 51 |
1199566 | 1199566 | 2021-04-07 | Sauk | Wisconsin | 55111 | 5812 | 50 |
1196317 | 1196317 | 2021-04-06 | Sauk | Wisconsin | 55111 | 5790 | 50 |
1193069 | 1193069 | 2021-04-05 | Sauk | Wisconsin | 55111 | 5784 | 50 |
1189819 | 1189819 | 2021-04-04 | Sauk | Wisconsin | 55111 | 5774 | 50 |
1186572 | 1186572 | 2021-04-03 | Sauk | Wisconsin | 55111 | 5767 | 50 |
1183325 | 1183325 | 2021-04-02 | Sauk | Wisconsin | 55111 | 5766 | 50 |
1180078 | 1180078 | 2021-04-01 | Sauk | Wisconsin | 55111 | 5762 | 50 |
1176831 | 1176831 | 2021-03-31 | Sauk | Wisconsin | 55111 | 5752 | 50 |
1173584 | 1173584 | 2021-03-30 | Sauk | Wisconsin | 55111 | 5743 | 50 |
1170337 | 1170337 | 2021-03-29 | Sauk | Wisconsin | 55111 | 5739 | 50 |
1167089 | 1167089 | 2021-03-28 | Sauk | Wisconsin | 55111 | 5732 | 50 |
1163841 | 1163841 | 2021-03-27 | Sauk | Wisconsin | 55111 | 5723 | 50 |
1160593 | 1160593 | 2021-03-26 | Sauk | Wisconsin | 55111 | 5713 | 50 |
1157345 | 1157345 | 2021-03-25 | Sauk | Wisconsin | 55111 | 5698 | 50 |
1154098 | 1154098 | 2021-03-24 | Sauk | Wisconsin | 55111 | 5692 | 50 |
1150851 | 1150851 | 2021-03-23 | Sauk | Wisconsin | 55111 | 5673 | 50 |
1147604 | 1147604 | 2021-03-22 | Sauk | Wisconsin | 55111 | 5673 | 50 |
1144357 | 1144357 | 2021-03-21 | Sauk | Wisconsin | 55111 | 5669 | 50 |
1141110 | 1141110 | 2021-03-20 | Sauk | Wisconsin | 55111 | 5665 | 50 |
1137864 | 1137864 | 2021-03-19 | Sauk | Wisconsin | 55111 | 5659 | 50 |
1134618 | 1134618 | 2021-03-18 | Sauk | Wisconsin | 55111 | 5650 | 49 |
1131370 | 1131370 | 2021-03-17 | Sauk | Wisconsin | 55111 | 5642 | 49 |
1128123 | 1128123 | 2021-03-16 | Sauk | Wisconsin | 55111 | 5636 | 49 |
1124877 | 1124877 | 2021-03-15 | Sauk | Wisconsin | 55111 | 5634 | 49 |
1121631 | 1121631 | 2021-03-14 | Sauk | Wisconsin | 55111 | 5625 | 49 |
1118384 | 1118384 | 2021-03-13 | Sauk | Wisconsin | 55111 | 5615 | 49 |
1115137 | 1115137 | 2021-03-12 | Sauk | Wisconsin | 55111 | 5605 | 49 |
1111891 | 1111891 | 2021-03-11 | Sauk | Wisconsin | 55111 | 5603 | 49 |
1108645 | 1108645 | 2021-03-10 | Sauk | Wisconsin | 55111 | 5592 | 49 |
1105399 | 1105399 | 2021-03-09 | Sauk | Wisconsin | 55111 | 5584 | 49 |
1102153 | 1102153 | 2021-03-08 | Sauk | Wisconsin | 55111 | 5572 | 48 |
1098907 | 1098907 | 2021-03-07 | Sauk | Wisconsin | 55111 | 5570 | 48 |
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);