ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
829 rows where county = "Dane" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1839274 | 1839274 | 2021-10-21 | Dane | Wisconsin | 55025 | 57264 | 369 |
1836025 | 1836025 | 2021-10-20 | Dane | Wisconsin | 55025 | 57148 | 369 |
1832776 | 1832776 | 2021-10-19 | Dane | Wisconsin | 55025 | 57070 | 368 |
1829527 | 1829527 | 2021-10-18 | Dane | Wisconsin | 55025 | 57005 | 366 |
1826278 | 1826278 | 2021-10-17 | Dane | Wisconsin | 55025 | 56838 | 365 |
1823029 | 1823029 | 2021-10-16 | Dane | Wisconsin | 55025 | 56611 | 364 |
1819780 | 1819780 | 2021-10-15 | Dane | Wisconsin | 55025 | 56611 | 364 |
1816531 | 1816531 | 2021-10-14 | Dane | Wisconsin | 55025 | 56611 | 364 |
1813283 | 1813283 | 2021-10-13 | Dane | Wisconsin | 55025 | 56459 | 363 |
1810034 | 1810034 | 2021-10-12 | Dane | Wisconsin | 55025 | 56343 | 363 |
1806785 | 1806785 | 2021-10-11 | Dane | Wisconsin | 55025 | 56109 | 359 |
1803534 | 1803534 | 2021-10-10 | Dane | Wisconsin | 55025 | 55822 | 359 |
1800285 | 1800285 | 2021-10-09 | Dane | Wisconsin | 55025 | 55822 | 359 |
1797036 | 1797036 | 2021-10-08 | Dane | Wisconsin | 55025 | 55822 | 359 |
1793787 | 1793787 | 2021-10-07 | Dane | Wisconsin | 55025 | 55647 | 359 |
1790538 | 1790538 | 2021-10-06 | Dane | Wisconsin | 55025 | 55529 | 359 |
1787290 | 1787290 | 2021-10-05 | Dane | Wisconsin | 55025 | 55362 | 359 |
1784041 | 1784041 | 2021-10-04 | Dane | Wisconsin | 55025 | 55114 | 358 |
1780792 | 1780792 | 2021-10-03 | Dane | Wisconsin | 55025 | 54789 | 357 |
1777542 | 1777542 | 2021-10-02 | Dane | Wisconsin | 55025 | 54789 | 357 |
1774292 | 1774292 | 2021-10-01 | Dane | Wisconsin | 55025 | 54789 | 357 |
1771042 | 1771042 | 2021-09-30 | Dane | Wisconsin | 55025 | 54581 | 357 |
1767793 | 1767793 | 2021-09-29 | Dane | Wisconsin | 55025 | 54457 | 356 |
1764544 | 1764544 | 2021-09-28 | Dane | Wisconsin | 55025 | 54272 | 356 |
1761295 | 1761295 | 2021-09-27 | Dane | Wisconsin | 55025 | 54121 | 356 |
1758047 | 1758047 | 2021-09-26 | Dane | Wisconsin | 55025 | 53856 | 355 |
1754799 | 1754799 | 2021-09-25 | Dane | Wisconsin | 55025 | 53856 | 355 |
1751551 | 1751551 | 2021-09-24 | Dane | Wisconsin | 55025 | 53856 | 355 |
1748302 | 1748302 | 2021-09-23 | Dane | Wisconsin | 55025 | 53707 | 351 |
1745052 | 1745052 | 2021-09-22 | Dane | Wisconsin | 55025 | 53544 | 351 |
1741803 | 1741803 | 2021-09-21 | Dane | Wisconsin | 55025 | 53446 | 351 |
1738554 | 1738554 | 2021-09-20 | Dane | Wisconsin | 55025 | 53145 | 351 |
1735305 | 1735305 | 2021-09-19 | Dane | Wisconsin | 55025 | 52682 | 351 |
1732055 | 1732055 | 2021-09-18 | Dane | Wisconsin | 55025 | 52682 | 351 |
1728805 | 1728805 | 2021-09-17 | Dane | Wisconsin | 55025 | 52682 | 351 |
1725555 | 1725555 | 2021-09-16 | Dane | Wisconsin | 55025 | 52462 | 351 |
1722306 | 1722306 | 2021-09-15 | Dane | Wisconsin | 55025 | 52228 | 350 |
1719058 | 1719058 | 2021-09-14 | Dane | Wisconsin | 55025 | 52025 | 350 |
1715810 | 1715810 | 2021-09-13 | Dane | Wisconsin | 55025 | 51895 | 350 |
1712564 | 1712564 | 2021-09-12 | Dane | Wisconsin | 55025 | 51699 | 349 |
1709317 | 1709317 | 2021-09-11 | Dane | Wisconsin | 55025 | 51699 | 349 |
1706070 | 1706070 | 2021-09-10 | Dane | Wisconsin | 55025 | 51699 | 349 |
1702821 | 1702821 | 2021-09-09 | Dane | Wisconsin | 55025 | 51591 | 349 |
1699571 | 1699571 | 2021-09-08 | Dane | Wisconsin | 55025 | 51420 | 349 |
1696323 | 1696323 | 2021-09-07 | Dane | Wisconsin | 55025 | 51381 | 348 |
1693075 | 1693075 | 2021-09-06 | Dane | Wisconsin | 55025 | 51303 | 348 |
1689826 | 1689826 | 2021-09-05 | Dane | Wisconsin | 55025 | 50989 | 348 |
1686576 | 1686576 | 2021-09-04 | Dane | Wisconsin | 55025 | 50989 | 348 |
1683326 | 1683326 | 2021-09-03 | Dane | Wisconsin | 55025 | 50989 | 348 |
1680075 | 1680075 | 2021-09-02 | Dane | Wisconsin | 55025 | 50876 | 346 |
1676827 | 1676827 | 2021-09-01 | Dane | Wisconsin | 55025 | 50696 | 346 |
1673580 | 1673580 | 2021-08-31 | Dane | Wisconsin | 55025 | 50602 | 344 |
1670332 | 1670332 | 2021-08-30 | Dane | Wisconsin | 55025 | 50497 | 343 |
1667085 | 1667085 | 2021-08-29 | Dane | Wisconsin | 55025 | 50217 | 343 |
1663837 | 1663837 | 2021-08-28 | Dane | Wisconsin | 55025 | 50217 | 343 |
1660589 | 1660589 | 2021-08-27 | Dane | Wisconsin | 55025 | 50217 | 343 |
1657341 | 1657341 | 2021-08-26 | Dane | Wisconsin | 55025 | 50024 | 343 |
1654093 | 1654093 | 2021-08-25 | Dane | Wisconsin | 55025 | 49919 | 343 |
1650847 | 1650847 | 2021-08-24 | Dane | Wisconsin | 55025 | 49771 | 343 |
1647598 | 1647598 | 2021-08-23 | Dane | Wisconsin | 55025 | 49693 | 342 |
1644349 | 1644349 | 2021-08-22 | Dane | Wisconsin | 55025 | 49451 | 342 |
1641099 | 1641099 | 2021-08-21 | Dane | Wisconsin | 55025 | 49451 | 342 |
1637849 | 1637849 | 2021-08-20 | Dane | Wisconsin | 55025 | 49451 | 342 |
1634599 | 1634599 | 2021-08-19 | Dane | Wisconsin | 55025 | 49338 | 341 |
1631351 | 1631351 | 2021-08-18 | Dane | Wisconsin | 55025 | 49213 | 341 |
1628104 | 1628104 | 2021-08-17 | Dane | Wisconsin | 55025 | 49127 | 341 |
1624857 | 1624857 | 2021-08-16 | Dane | Wisconsin | 55025 | 49049 | 341 |
1621610 | 1621610 | 2021-08-15 | Dane | Wisconsin | 55025 | 48789 | 341 |
1618362 | 1618362 | 2021-08-14 | Dane | Wisconsin | 55025 | 48789 | 341 |
1615114 | 1615114 | 2021-08-13 | Dane | Wisconsin | 55025 | 48789 | 341 |
1611865 | 1611865 | 2021-08-12 | Dane | Wisconsin | 55025 | 48631 | 340 |
1608618 | 1608618 | 2021-08-11 | Dane | Wisconsin | 55025 | 48531 | 340 |
1605369 | 1605369 | 2021-08-10 | Dane | Wisconsin | 55025 | 48453 | 340 |
1602119 | 1602119 | 2021-08-09 | Dane | Wisconsin | 55025 | 48398 | 340 |
1598871 | 1598871 | 2021-08-08 | Dane | Wisconsin | 55025 | 48146 | 340 |
1595622 | 1595622 | 2021-08-07 | Dane | Wisconsin | 55025 | 48146 | 340 |
1592373 | 1592373 | 2021-08-06 | Dane | Wisconsin | 55025 | 48146 | 340 |
1589124 | 1589124 | 2021-08-05 | Dane | Wisconsin | 55025 | 48048 | 340 |
1585875 | 1585875 | 2021-08-04 | Dane | Wisconsin | 55025 | 47920 | 340 |
1582625 | 1582625 | 2021-08-03 | Dane | Wisconsin | 55025 | 47843 | 340 |
1579375 | 1579375 | 2021-08-02 | Dane | Wisconsin | 55025 | 47749 | 340 |
1576127 | 1576127 | 2021-08-01 | Dane | Wisconsin | 55025 | 47543 | 340 |
1572879 | 1572879 | 2021-07-31 | Dane | Wisconsin | 55025 | 47543 | 340 |
1569631 | 1569631 | 2021-07-30 | Dane | Wisconsin | 55025 | 47543 | 340 |
1566383 | 1566383 | 2021-07-29 | Dane | Wisconsin | 55025 | 47461 | 340 |
1563135 | 1563135 | 2021-07-28 | Dane | Wisconsin | 55025 | 47373 | 340 |
1559887 | 1559887 | 2021-07-27 | Dane | Wisconsin | 55025 | 47315 | 339 |
1556640 | 1556640 | 2021-07-26 | Dane | Wisconsin | 55025 | 47278 | 339 |
1553393 | 1553393 | 2021-07-25 | Dane | Wisconsin | 55025 | 47159 | 339 |
1550146 | 1550146 | 2021-07-24 | Dane | Wisconsin | 55025 | 47159 | 339 |
1546899 | 1546899 | 2021-07-23 | Dane | Wisconsin | 55025 | 47159 | 339 |
1543652 | 1543652 | 2021-07-22 | Dane | Wisconsin | 55025 | 47111 | 338 |
1540404 | 1540404 | 2021-07-21 | Dane | Wisconsin | 55025 | 47070 | 338 |
1537157 | 1537157 | 2021-07-20 | Dane | Wisconsin | 55025 | 47047 | 338 |
1533909 | 1533909 | 2021-07-19 | Dane | Wisconsin | 55025 | 47028 | 338 |
1530662 | 1530662 | 2021-07-18 | Dane | Wisconsin | 55025 | 46976 | 338 |
1527415 | 1527415 | 2021-07-17 | Dane | Wisconsin | 55025 | 46976 | 338 |
1524168 | 1524168 | 2021-07-16 | Dane | Wisconsin | 55025 | 46976 | 338 |
1520920 | 1520920 | 2021-07-15 | Dane | Wisconsin | 55025 | 46956 | 338 |
1517672 | 1517672 | 2021-07-14 | Dane | Wisconsin | 55025 | 46933 | 338 |
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);