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 |
---|---|---|---|---|---|---|---|
1842564 | 1842564 | 2021-10-22 | Rock | Wisconsin | 55105 | 22145 | 244 |
1839315 | 1839315 | 2021-10-21 | Rock | Wisconsin | 55105 | 22106 | 244 |
1836066 | 1836066 | 2021-10-20 | Rock | Wisconsin | 55105 | 22059 | 243 |
1832817 | 1832817 | 2021-10-19 | Rock | Wisconsin | 55105 | 22010 | 242 |
1829568 | 1829568 | 2021-10-18 | Rock | Wisconsin | 55105 | 21971 | 242 |
1826319 | 1826319 | 2021-10-17 | Rock | Wisconsin | 55105 | 21920 | 242 |
1823070 | 1823070 | 2021-10-16 | Rock | Wisconsin | 55105 | 21837 | 242 |
1819821 | 1819821 | 2021-10-15 | Rock | Wisconsin | 55105 | 21837 | 242 |
1816572 | 1816572 | 2021-10-14 | Rock | Wisconsin | 55105 | 21837 | 242 |
1813324 | 1813324 | 2021-10-13 | Rock | Wisconsin | 55105 | 21806 | 242 |
1810075 | 1810075 | 2021-10-12 | Rock | Wisconsin | 55105 | 21752 | 241 |
1806826 | 1806826 | 2021-10-11 | Rock | Wisconsin | 55105 | 21706 | 240 |
1803575 | 1803575 | 2021-10-10 | Rock | Wisconsin | 55105 | 21600 | 228 |
1800326 | 1800326 | 2021-10-09 | Rock | Wisconsin | 55105 | 21600 | 228 |
1797077 | 1797077 | 2021-10-08 | Rock | Wisconsin | 55105 | 21600 | 228 |
1793828 | 1793828 | 2021-10-07 | Rock | Wisconsin | 55105 | 21550 | 227 |
1790579 | 1790579 | 2021-10-06 | Rock | Wisconsin | 55105 | 21484 | 227 |
1787331 | 1787331 | 2021-10-05 | Rock | Wisconsin | 55105 | 21397 | 227 |
1784082 | 1784082 | 2021-10-04 | Rock | Wisconsin | 55105 | 21375 | 227 |
1780833 | 1780833 | 2021-10-03 | Rock | Wisconsin | 55105 | 21231 | 227 |
1777583 | 1777583 | 2021-10-02 | Rock | Wisconsin | 55105 | 21231 | 227 |
1774333 | 1774333 | 2021-10-01 | Rock | Wisconsin | 55105 | 21231 | 227 |
1771083 | 1771083 | 2021-09-30 | Rock | Wisconsin | 55105 | 21154 | 225 |
1767834 | 1767834 | 2021-09-29 | Rock | Wisconsin | 55105 | 21110 | 225 |
1764585 | 1764585 | 2021-09-28 | Rock | Wisconsin | 55105 | 21051 | 225 |
1761336 | 1761336 | 2021-09-27 | Rock | Wisconsin | 55105 | 21005 | 225 |
1758088 | 1758088 | 2021-09-26 | Rock | Wisconsin | 55105 | 20879 | 225 |
1754840 | 1754840 | 2021-09-25 | Rock | Wisconsin | 55105 | 20879 | 225 |
1751592 | 1751592 | 2021-09-24 | Rock | Wisconsin | 55105 | 20879 | 225 |
1748343 | 1748343 | 2021-09-23 | Rock | Wisconsin | 55105 | 20835 | 224 |
1745093 | 1745093 | 2021-09-22 | Rock | Wisconsin | 55105 | 20767 | 223 |
1741844 | 1741844 | 2021-09-21 | Rock | Wisconsin | 55105 | 20710 | 223 |
1738595 | 1738595 | 2021-09-20 | Rock | Wisconsin | 55105 | 20601 | 223 |
1735346 | 1735346 | 2021-09-19 | Rock | Wisconsin | 55105 | 20475 | 222 |
1732096 | 1732096 | 2021-09-18 | Rock | Wisconsin | 55105 | 20475 | 222 |
1728846 | 1728846 | 2021-09-17 | Rock | Wisconsin | 55105 | 20475 | 222 |
1725596 | 1725596 | 2021-09-16 | Rock | Wisconsin | 55105 | 20390 | 222 |
1722347 | 1722347 | 2021-09-15 | Rock | Wisconsin | 55105 | 20259 | 222 |
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 |
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);