ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 55009 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420284 | 1420284 | 2021-06-14 | Brown | Wisconsin | 55009 | 35623 | 296 |
1417039 | 1417039 | 2021-06-13 | Brown | Wisconsin | 55009 | 35613 | 296 |
1413793 | 1413793 | 2021-06-12 | Brown | Wisconsin | 55009 | 35613 | 296 |
1410548 | 1410548 | 2021-06-11 | Brown | Wisconsin | 55009 | 35613 | 296 |
1407303 | 1407303 | 2021-06-10 | Brown | Wisconsin | 55009 | 35607 | 294 |
1404057 | 1404057 | 2021-06-09 | Brown | Wisconsin | 55009 | 35589 | 294 |
1400812 | 1400812 | 2021-06-08 | Brown | Wisconsin | 55009 | 35582 | 294 |
1397567 | 1397567 | 2021-06-07 | Brown | Wisconsin | 55009 | 35565 | 294 |
1394320 | 1394320 | 2021-06-06 | Brown | Wisconsin | 55009 | 35551 | 293 |
1391075 | 1391075 | 2021-06-05 | Brown | Wisconsin | 55009 | 35551 | 293 |
1387830 | 1387830 | 2021-06-04 | Brown | Wisconsin | 55009 | 35551 | 293 |
1384585 | 1384585 | 2021-06-03 | Brown | Wisconsin | 55009 | 35543 | 293 |
1381339 | 1381339 | 2021-06-02 | Brown | Wisconsin | 55009 | 35527 | 292 |
1378094 | 1378094 | 2021-06-01 | Brown | Wisconsin | 55009 | 35490 | 292 |
1374848 | 1374848 | 2021-05-31 | Brown | Wisconsin | 55009 | 35490 | 292 |
1371603 | 1371603 | 2021-05-30 | Brown | Wisconsin | 55009 | 35462 | 292 |
1368357 | 1368357 | 2021-05-29 | Brown | Wisconsin | 55009 | 35462 | 292 |
1365111 | 1365111 | 2021-05-28 | Brown | Wisconsin | 55009 | 35462 | 292 |
1361865 | 1361865 | 2021-05-27 | Brown | Wisconsin | 55009 | 35444 | 291 |
1358619 | 1358619 | 2021-05-26 | Brown | Wisconsin | 55009 | 35428 | 290 |
1355373 | 1355373 | 2021-05-25 | Brown | Wisconsin | 55009 | 35417 | 290 |
1352127 | 1352127 | 2021-05-24 | Brown | Wisconsin | 55009 | 35396 | 289 |
1348881 | 1348881 | 2021-05-23 | Brown | Wisconsin | 55009 | 35391 | 289 |
1345633 | 1345633 | 2021-05-22 | Brown | Wisconsin | 55009 | 35386 | 289 |
1342385 | 1342385 | 2021-05-21 | Brown | Wisconsin | 55009 | 35367 | 289 |
1339137 | 1339137 | 2021-05-20 | Brown | Wisconsin | 55009 | 35348 | 289 |
1335890 | 1335890 | 2021-05-19 | Brown | Wisconsin | 55009 | 35326 | 289 |
1332643 | 1332643 | 2021-05-18 | Brown | Wisconsin | 55009 | 35306 | 289 |
1329396 | 1329396 | 2021-05-17 | Brown | Wisconsin | 55009 | 35283 | 289 |
1326150 | 1326150 | 2021-05-16 | Brown | Wisconsin | 55009 | 35277 | 289 |
1322904 | 1322904 | 2021-05-15 | Brown | Wisconsin | 55009 | 35277 | 289 |
1319658 | 1319658 | 2021-05-14 | Brown | Wisconsin | 55009 | 35247 | 289 |
1316410 | 1316410 | 2021-05-13 | Brown | Wisconsin | 55009 | 35223 | 289 |
1313164 | 1313164 | 2021-05-12 | Brown | Wisconsin | 55009 | 35198 | 289 |
1309917 | 1309917 | 2021-05-11 | Brown | Wisconsin | 55009 | 35172 | 289 |
1306671 | 1306671 | 2021-05-10 | Brown | Wisconsin | 55009 | 35126 | 289 |
1303425 | 1303425 | 2021-05-09 | Brown | Wisconsin | 55009 | 35124 | 289 |
1300178 | 1300178 | 2021-05-08 | Brown | Wisconsin | 55009 | 35111 | 289 |
1296931 | 1296931 | 2021-05-07 | Brown | Wisconsin | 55009 | 35075 | 288 |
1293685 | 1293685 | 2021-05-06 | Brown | Wisconsin | 55009 | 35035 | 286 |
1290439 | 1290439 | 2021-05-05 | Brown | Wisconsin | 55009 | 35010 | 283 |
1287193 | 1287193 | 2021-05-04 | Brown | Wisconsin | 55009 | 34974 | 283 |
1283947 | 1283947 | 2021-05-03 | Brown | Wisconsin | 55009 | 34892 | 283 |
1280700 | 1280700 | 2021-05-02 | Brown | Wisconsin | 55009 | 34890 | 283 |
1277453 | 1277453 | 2021-05-01 | Brown | Wisconsin | 55009 | 34881 | 283 |
1274206 | 1274206 | 2021-04-30 | Brown | Wisconsin | 55009 | 34859 | 282 |
1270959 | 1270959 | 2021-04-29 | Brown | Wisconsin | 55009 | 34819 | 282 |
1267712 | 1267712 | 2021-04-28 | Brown | Wisconsin | 55009 | 34772 | 282 |
1264465 | 1264465 | 2021-04-27 | Brown | Wisconsin | 55009 | 34740 | 276 |
1261218 | 1261218 | 2021-04-26 | Brown | Wisconsin | 55009 | 34689 | 275 |
1257971 | 1257971 | 2021-04-25 | Brown | Wisconsin | 55009 | 34648 | 275 |
1254724 | 1254724 | 2021-04-24 | Brown | Wisconsin | 55009 | 34643 | 275 |
1251477 | 1251477 | 2021-04-23 | Brown | Wisconsin | 55009 | 34606 | 275 |
1248230 | 1248230 | 2021-04-22 | Brown | Wisconsin | 55009 | 34546 | 274 |
1244983 | 1244983 | 2021-04-21 | Brown | Wisconsin | 55009 | 34505 | 274 |
1241736 | 1241736 | 2021-04-20 | Brown | Wisconsin | 55009 | 34487 | 274 |
1238489 | 1238489 | 2021-04-19 | Brown | Wisconsin | 55009 | 34438 | 274 |
1235242 | 1235242 | 2021-04-18 | Brown | Wisconsin | 55009 | 34436 | 274 |
1231994 | 1231994 | 2021-04-17 | Brown | Wisconsin | 55009 | 34413 | 274 |
1228746 | 1228746 | 2021-04-16 | Brown | Wisconsin | 55009 | 34383 | 274 |
1225498 | 1225498 | 2021-04-15 | Brown | Wisconsin | 55009 | 34374 | 274 |
1222251 | 1222251 | 2021-04-14 | Brown | Wisconsin | 55009 | 34336 | 274 |
1219003 | 1219003 | 2021-04-13 | Brown | Wisconsin | 55009 | 34311 | 273 |
1215755 | 1215755 | 2021-04-12 | Brown | Wisconsin | 55009 | 34213 | 273 |
1212508 | 1212508 | 2021-04-11 | Brown | Wisconsin | 55009 | 34206 | 273 |
1209259 | 1209259 | 2021-04-10 | Brown | Wisconsin | 55009 | 34196 | 273 |
1206011 | 1206011 | 2021-04-09 | Brown | Wisconsin | 55009 | 34136 | 272 |
1202763 | 1202763 | 2021-04-08 | Brown | Wisconsin | 55009 | 34078 | 272 |
1199515 | 1199515 | 2021-04-07 | Brown | Wisconsin | 55009 | 34027 | 272 |
1196266 | 1196266 | 2021-04-06 | Brown | Wisconsin | 55009 | 34003 | 272 |
1193018 | 1193018 | 2021-04-05 | Brown | Wisconsin | 55009 | 33912 | 272 |
1189768 | 1189768 | 2021-04-04 | Brown | Wisconsin | 55009 | 33912 | 272 |
1186521 | 1186521 | 2021-04-03 | Brown | Wisconsin | 55009 | 33900 | 272 |
1183274 | 1183274 | 2021-04-02 | Brown | Wisconsin | 55009 | 33859 | 272 |
1180027 | 1180027 | 2021-04-01 | Brown | Wisconsin | 55009 | 33830 | 272 |
1176780 | 1176780 | 2021-03-31 | Brown | Wisconsin | 55009 | 33812 | 271 |
1173533 | 1173533 | 2021-03-30 | Brown | Wisconsin | 55009 | 33755 | 270 |
1170286 | 1170286 | 2021-03-29 | Brown | Wisconsin | 55009 | 33688 | 269 |
1167038 | 1167038 | 2021-03-28 | Brown | Wisconsin | 55009 | 33688 | 269 |
1163790 | 1163790 | 2021-03-27 | Brown | Wisconsin | 55009 | 33657 | 269 |
1160542 | 1160542 | 2021-03-26 | Brown | Wisconsin | 55009 | 33632 | 268 |
1157294 | 1157294 | 2021-03-25 | Brown | Wisconsin | 55009 | 33593 | 266 |
1154047 | 1154047 | 2021-03-24 | Brown | Wisconsin | 55009 | 33564 | 266 |
1150800 | 1150800 | 2021-03-23 | Brown | Wisconsin | 55009 | 33464 | 261 |
1147553 | 1147553 | 2021-03-22 | Brown | Wisconsin | 55009 | 33464 | 261 |
1144306 | 1144306 | 2021-03-21 | Brown | Wisconsin | 55009 | 33456 | 261 |
1141059 | 1141059 | 2021-03-20 | Brown | Wisconsin | 55009 | 33447 | 261 |
1137813 | 1137813 | 2021-03-19 | Brown | Wisconsin | 55009 | 33417 | 261 |
1134567 | 1134567 | 2021-03-18 | Brown | Wisconsin | 55009 | 33365 | 260 |
1131319 | 1131319 | 2021-03-17 | Brown | Wisconsin | 55009 | 33315 | 259 |
1128072 | 1128072 | 2021-03-16 | Brown | Wisconsin | 55009 | 33259 | 260 |
1124826 | 1124826 | 2021-03-15 | Brown | Wisconsin | 55009 | 33194 | 260 |
1121580 | 1121580 | 2021-03-14 | Brown | Wisconsin | 55009 | 33178 | 260 |
1118333 | 1118333 | 2021-03-13 | Brown | Wisconsin | 55009 | 33166 | 260 |
1115086 | 1115086 | 2021-03-12 | Brown | Wisconsin | 55009 | 33126 | 258 |
1111840 | 1111840 | 2021-03-11 | Brown | Wisconsin | 55009 | 33080 | 258 |
1108594 | 1108594 | 2021-03-10 | Brown | Wisconsin | 55009 | 33043 | 258 |
1105348 | 1105348 | 2021-03-09 | Brown | Wisconsin | 55009 | 33008 | 257 |
1102102 | 1102102 | 2021-03-08 | Brown | Wisconsin | 55009 | 32936 | 254 |
1098856 | 1098856 | 2021-03-07 | Brown | Wisconsin | 55009 | 32924 | 254 |
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);