ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Rock" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1719099 | 1719099 | 2021-09-14 | Rock | Wisconsin | 55105 | 20240 | 222 |
1715851 | 1715851 | 2021-09-13 | Rock | Wisconsin | 55105 | 20198 | 221 |
1712605 | 1712605 | 2021-09-12 | Rock | Wisconsin | 55105 | 20171 | 221 |
1709358 | 1709358 | 2021-09-11 | Rock | Wisconsin | 55105 | 20171 | 221 |
1706111 | 1706111 | 2021-09-10 | Rock | Wisconsin | 55105 | 20171 | 221 |
1702862 | 1702862 | 2021-09-09 | Rock | Wisconsin | 55105 | 20109 | 221 |
1699612 | 1699612 | 2021-09-08 | Rock | Wisconsin | 55105 | 20082 | 219 |
1696364 | 1696364 | 2021-09-07 | Rock | Wisconsin | 55105 | 20047 | 219 |
1693116 | 1693116 | 2021-09-06 | Rock | Wisconsin | 55105 | 20023 | 219 |
1689867 | 1689867 | 2021-09-05 | Rock | Wisconsin | 55105 | 19876 | 219 |
1686617 | 1686617 | 2021-09-04 | Rock | Wisconsin | 55105 | 19876 | 219 |
1683367 | 1683367 | 2021-09-03 | Rock | Wisconsin | 55105 | 19876 | 219 |
1680116 | 1680116 | 2021-09-02 | Rock | Wisconsin | 55105 | 19844 | 218 |
1676868 | 1676868 | 2021-09-01 | Rock | Wisconsin | 55105 | 19815 | 218 |
1673621 | 1673621 | 2021-08-31 | Rock | Wisconsin | 55105 | 19739 | 216 |
1670373 | 1670373 | 2021-08-30 | Rock | Wisconsin | 55105 | 19698 | 216 |
1667126 | 1667126 | 2021-08-29 | Rock | Wisconsin | 55105 | 19602 | 216 |
1663878 | 1663878 | 2021-08-28 | Rock | Wisconsin | 55105 | 19602 | 216 |
1660630 | 1660630 | 2021-08-27 | Rock | Wisconsin | 55105 | 19602 | 216 |
1657382 | 1657382 | 2021-08-26 | Rock | Wisconsin | 55105 | 19512 | 216 |
1654134 | 1654134 | 2021-08-25 | Rock | Wisconsin | 55105 | 19459 | 216 |
1650888 | 1650888 | 2021-08-24 | Rock | Wisconsin | 55105 | 19404 | 215 |
1647639 | 1647639 | 2021-08-23 | Rock | Wisconsin | 55105 | 19371 | 214 |
1644390 | 1644390 | 2021-08-22 | Rock | Wisconsin | 55105 | 19277 | 214 |
1641140 | 1641140 | 2021-08-21 | Rock | Wisconsin | 55105 | 19277 | 214 |
1637890 | 1637890 | 2021-08-20 | Rock | Wisconsin | 55105 | 19277 | 214 |
1634640 | 1634640 | 2021-08-19 | Rock | Wisconsin | 55105 | 19238 | 214 |
1631392 | 1631392 | 2021-08-18 | Rock | Wisconsin | 55105 | 19194 | 214 |
1628145 | 1628145 | 2021-08-17 | Rock | Wisconsin | 55105 | 19171 | 214 |
1624898 | 1624898 | 2021-08-16 | Rock | Wisconsin | 55105 | 19146 | 214 |
1621651 | 1621651 | 2021-08-15 | Rock | Wisconsin | 55105 | 19055 | 214 |
1618403 | 1618403 | 2021-08-14 | Rock | Wisconsin | 55105 | 19055 | 214 |
1615155 | 1615155 | 2021-08-13 | Rock | Wisconsin | 55105 | 19055 | 214 |
1611906 | 1611906 | 2021-08-12 | Rock | Wisconsin | 55105 | 19012 | 213 |
1608659 | 1608659 | 2021-08-11 | Rock | Wisconsin | 55105 | 18967 | 212 |
1605410 | 1605410 | 2021-08-10 | Rock | Wisconsin | 55105 | 18934 | 212 |
1602160 | 1602160 | 2021-08-09 | Rock | Wisconsin | 55105 | 18908 | 211 |
1598912 | 1598912 | 2021-08-08 | Rock | Wisconsin | 55105 | 18828 | 211 |
1595663 | 1595663 | 2021-08-07 | Rock | Wisconsin | 55105 | 18828 | 211 |
1592414 | 1592414 | 2021-08-06 | Rock | Wisconsin | 55105 | 18828 | 211 |
1589165 | 1589165 | 2021-08-05 | Rock | Wisconsin | 55105 | 18801 | 211 |
1585916 | 1585916 | 2021-08-04 | Rock | Wisconsin | 55105 | 18748 | 211 |
1582666 | 1582666 | 2021-08-03 | Rock | Wisconsin | 55105 | 18734 | 211 |
1579416 | 1579416 | 2021-08-02 | Rock | Wisconsin | 55105 | 18710 | 211 |
1576168 | 1576168 | 2021-08-01 | Rock | Wisconsin | 55105 | 18640 | 211 |
1572920 | 1572920 | 2021-07-31 | Rock | Wisconsin | 55105 | 18640 | 211 |
1569672 | 1569672 | 2021-07-30 | Rock | Wisconsin | 55105 | 18640 | 211 |
1566424 | 1566424 | 2021-07-29 | Rock | Wisconsin | 55105 | 18611 | 211 |
1563176 | 1563176 | 2021-07-28 | Rock | Wisconsin | 55105 | 18585 | 210 |
1559928 | 1559928 | 2021-07-27 | Rock | Wisconsin | 55105 | 18563 | 210 |
1556681 | 1556681 | 2021-07-26 | Rock | Wisconsin | 55105 | 18532 | 209 |
1553434 | 1553434 | 2021-07-25 | Rock | Wisconsin | 55105 | 18512 | 209 |
1550187 | 1550187 | 2021-07-24 | Rock | Wisconsin | 55105 | 18512 | 209 |
1546940 | 1546940 | 2021-07-23 | Rock | Wisconsin | 55105 | 18512 | 209 |
1543693 | 1543693 | 2021-07-22 | Rock | Wisconsin | 55105 | 18503 | 209 |
1540445 | 1540445 | 2021-07-21 | Rock | Wisconsin | 55105 | 18490 | 209 |
1537198 | 1537198 | 2021-07-20 | Rock | Wisconsin | 55105 | 18474 | 209 |
1533950 | 1533950 | 2021-07-19 | Rock | Wisconsin | 55105 | 18461 | 209 |
1530703 | 1530703 | 2021-07-18 | Rock | Wisconsin | 55105 | 18452 | 209 |
1527456 | 1527456 | 2021-07-17 | Rock | Wisconsin | 55105 | 18452 | 209 |
1524209 | 1524209 | 2021-07-16 | Rock | Wisconsin | 55105 | 18452 | 209 |
1520961 | 1520961 | 2021-07-15 | Rock | Wisconsin | 55105 | 18451 | 209 |
1517713 | 1517713 | 2021-07-14 | Rock | Wisconsin | 55105 | 18444 | 209 |
1514466 | 1514466 | 2021-07-13 | Rock | Wisconsin | 55105 | 18437 | 209 |
1511220 | 1511220 | 2021-07-12 | Rock | Wisconsin | 55105 | 18428 | 209 |
1507973 | 1507973 | 2021-07-11 | Rock | Wisconsin | 55105 | 18419 | 209 |
1504727 | 1504727 | 2021-07-10 | Rock | Wisconsin | 55105 | 18419 | 209 |
1501481 | 1501481 | 2021-07-09 | Rock | Wisconsin | 55105 | 18419 | 209 |
1498235 | 1498235 | 2021-07-08 | Rock | Wisconsin | 55105 | 18408 | 209 |
1494988 | 1494988 | 2021-07-07 | Rock | Wisconsin | 55105 | 18400 | 209 |
1491741 | 1491741 | 2021-07-06 | Rock | Wisconsin | 55105 | 18391 | 209 |
1488494 | 1488494 | 2021-07-05 | Rock | Wisconsin | 55105 | 18391 | 209 |
1485247 | 1485247 | 2021-07-04 | Rock | Wisconsin | 55105 | 18389 | 209 |
1482001 | 1482001 | 2021-07-03 | Rock | Wisconsin | 55105 | 18389 | 209 |
1478754 | 1478754 | 2021-07-02 | Rock | Wisconsin | 55105 | 18389 | 209 |
1475508 | 1475508 | 2021-07-01 | Rock | Wisconsin | 55105 | 18387 | 209 |
1472262 | 1472262 | 2021-06-30 | Rock | Wisconsin | 55105 | 18385 | 209 |
1469017 | 1469017 | 2021-06-29 | Rock | Wisconsin | 55105 | 18388 | 209 |
1465772 | 1465772 | 2021-06-28 | Rock | Wisconsin | 55105 | 18384 | 208 |
1462527 | 1462527 | 2021-06-27 | Rock | Wisconsin | 55105 | 18379 | 207 |
1459282 | 1459282 | 2021-06-26 | Rock | Wisconsin | 55105 | 18379 | 207 |
1456037 | 1456037 | 2021-06-25 | Rock | Wisconsin | 55105 | 18379 | 207 |
1452792 | 1452792 | 2021-06-24 | Rock | Wisconsin | 55105 | 18377 | 206 |
1449546 | 1449546 | 2021-06-23 | Rock | Wisconsin | 55105 | 18374 | 206 |
1446301 | 1446301 | 2021-06-22 | Rock | Wisconsin | 55105 | 18369 | 207 |
1443056 | 1443056 | 2021-06-21 | Rock | Wisconsin | 55105 | 18366 | 207 |
1439811 | 1439811 | 2021-06-20 | Rock | Wisconsin | 55105 | 18362 | 203 |
1436564 | 1436564 | 2021-06-19 | Rock | Wisconsin | 55105 | 18362 | 203 |
1433317 | 1433317 | 2021-06-18 | Rock | Wisconsin | 55105 | 18362 | 203 |
1430071 | 1430071 | 2021-06-17 | Rock | Wisconsin | 55105 | 18358 | 208 |
1426826 | 1426826 | 2021-06-16 | Rock | Wisconsin | 55105 | 18353 | 208 |
1423580 | 1423580 | 2021-06-15 | Rock | Wisconsin | 55105 | 18352 | 207 |
1420333 | 1420333 | 2021-06-14 | Rock | Wisconsin | 55105 | 18350 | 207 |
1417088 | 1417088 | 2021-06-13 | Rock | Wisconsin | 55105 | 18342 | 206 |
1413842 | 1413842 | 2021-06-12 | Rock | Wisconsin | 55105 | 18342 | 206 |
1410597 | 1410597 | 2021-06-11 | Rock | Wisconsin | 55105 | 18342 | 206 |
1407352 | 1407352 | 2021-06-10 | Rock | Wisconsin | 55105 | 18341 | 206 |
1404106 | 1404106 | 2021-06-09 | Rock | Wisconsin | 55105 | 18339 | 204 |
1400861 | 1400861 | 2021-06-08 | Rock | Wisconsin | 55105 | 18336 | 204 |
1397616 | 1397616 | 2021-06-07 | Rock | Wisconsin | 55105 | 18331 | 204 |
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);