ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 55139 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1719116 | 1719116 | 2021-09-14 | Winnebago | Wisconsin | 55139 | 23865 | 238 |
1715868 | 1715868 | 2021-09-13 | Winnebago | Wisconsin | 55139 | 23784 | 238 |
1712622 | 1712622 | 2021-09-12 | Winnebago | Wisconsin | 55139 | 23690 | 236 |
1709375 | 1709375 | 2021-09-11 | Winnebago | Wisconsin | 55139 | 23690 | 236 |
1706128 | 1706128 | 2021-09-10 | Winnebago | Wisconsin | 55139 | 23690 | 236 |
1702880 | 1702880 | 2021-09-09 | Winnebago | Wisconsin | 55139 | 23583 | 236 |
1699630 | 1699630 | 2021-09-08 | Winnebago | Wisconsin | 55139 | 23505 | 233 |
1696381 | 1696381 | 2021-09-07 | Winnebago | Wisconsin | 55139 | 23421 | 232 |
1693133 | 1693133 | 2021-09-06 | Winnebago | Wisconsin | 55139 | 23417 | 232 |
1689884 | 1689884 | 2021-09-05 | Winnebago | Wisconsin | 55139 | 23234 | 232 |
1686634 | 1686634 | 2021-09-04 | Winnebago | Wisconsin | 55139 | 23234 | 232 |
1683384 | 1683384 | 2021-09-03 | Winnebago | Wisconsin | 55139 | 23234 | 232 |
1680133 | 1680133 | 2021-09-02 | Winnebago | Wisconsin | 55139 | 23166 | 231 |
1676885 | 1676885 | 2021-09-01 | Winnebago | Wisconsin | 55139 | 23086 | 231 |
1673638 | 1673638 | 2021-08-31 | Winnebago | Wisconsin | 55139 | 23010 | 231 |
1670390 | 1670390 | 2021-08-30 | Winnebago | Wisconsin | 55139 | 22912 | 231 |
1667143 | 1667143 | 2021-08-29 | Winnebago | Wisconsin | 55139 | 22852 | 231 |
1663895 | 1663895 | 2021-08-28 | Winnebago | Wisconsin | 55139 | 22852 | 231 |
1660647 | 1660647 | 2021-08-27 | Winnebago | Wisconsin | 55139 | 22852 | 231 |
1657399 | 1657399 | 2021-08-26 | Winnebago | Wisconsin | 55139 | 22775 | 232 |
1654151 | 1654151 | 2021-08-25 | Winnebago | Wisconsin | 55139 | 22703 | 232 |
1650905 | 1650905 | 2021-08-24 | Winnebago | Wisconsin | 55139 | 22664 | 232 |
1647656 | 1647656 | 2021-08-23 | Winnebago | Wisconsin | 55139 | 22514 | 232 |
1644407 | 1644407 | 2021-08-22 | Winnebago | Wisconsin | 55139 | 22474 | 232 |
1641157 | 1641157 | 2021-08-21 | Winnebago | Wisconsin | 55139 | 22474 | 232 |
1637907 | 1637907 | 2021-08-20 | Winnebago | Wisconsin | 55139 | 22474 | 232 |
1634657 | 1634657 | 2021-08-19 | Winnebago | Wisconsin | 55139 | 22407 | 231 |
1631409 | 1631409 | 2021-08-18 | Winnebago | Wisconsin | 55139 | 22350 | 230 |
1628162 | 1628162 | 2021-08-17 | Winnebago | Wisconsin | 55139 | 22298 | 230 |
1624915 | 1624915 | 2021-08-16 | Winnebago | Wisconsin | 55139 | 22202 | 230 |
1621668 | 1621668 | 2021-08-15 | Winnebago | Wisconsin | 55139 | 22175 | 230 |
1618420 | 1618420 | 2021-08-14 | Winnebago | Wisconsin | 55139 | 22175 | 230 |
1615172 | 1615172 | 2021-08-13 | Winnebago | Wisconsin | 55139 | 22175 | 230 |
1611923 | 1611923 | 2021-08-12 | Winnebago | Wisconsin | 55139 | 22106 | 230 |
1608676 | 1608676 | 2021-08-11 | Winnebago | Wisconsin | 55139 | 22054 | 230 |
1605427 | 1605427 | 2021-08-10 | Winnebago | Wisconsin | 55139 | 22019 | 230 |
1602177 | 1602177 | 2021-08-09 | Winnebago | Wisconsin | 55139 | 21953 | 230 |
1598929 | 1598929 | 2021-08-08 | Winnebago | Wisconsin | 55139 | 21908 | 230 |
1595680 | 1595680 | 2021-08-07 | Winnebago | Wisconsin | 55139 | 21908 | 230 |
1592431 | 1592431 | 2021-08-06 | Winnebago | Wisconsin | 55139 | 21908 | 230 |
1589182 | 1589182 | 2021-08-05 | Winnebago | Wisconsin | 55139 | 21866 | 230 |
1585933 | 1585933 | 2021-08-04 | Winnebago | Wisconsin | 55139 | 21826 | 230 |
1582683 | 1582683 | 2021-08-03 | Winnebago | Wisconsin | 55139 | 21787 | 230 |
1579433 | 1579433 | 2021-08-02 | Winnebago | Wisconsin | 55139 | 21741 | 229 |
1576185 | 1576185 | 2021-08-01 | Winnebago | Wisconsin | 55139 | 21724 | 229 |
1572937 | 1572937 | 2021-07-31 | Winnebago | Wisconsin | 55139 | 21724 | 229 |
1569689 | 1569689 | 2021-07-30 | Winnebago | Wisconsin | 55139 | 21724 | 229 |
1566441 | 1566441 | 2021-07-29 | Winnebago | Wisconsin | 55139 | 21694 | 229 |
1563193 | 1563193 | 2021-07-28 | Winnebago | Wisconsin | 55139 | 21669 | 229 |
1559945 | 1559945 | 2021-07-27 | Winnebago | Wisconsin | 55139 | 21661 | 229 |
1556698 | 1556698 | 2021-07-26 | Winnebago | Wisconsin | 55139 | 21622 | 228 |
1553451 | 1553451 | 2021-07-25 | Winnebago | Wisconsin | 55139 | 21615 | 228 |
1550204 | 1550204 | 2021-07-24 | Winnebago | Wisconsin | 55139 | 21615 | 228 |
1546957 | 1546957 | 2021-07-23 | Winnebago | Wisconsin | 55139 | 21615 | 228 |
1543710 | 1543710 | 2021-07-22 | Winnebago | Wisconsin | 55139 | 21605 | 228 |
1540462 | 1540462 | 2021-07-21 | Winnebago | Wisconsin | 55139 | 21598 | 228 |
1537215 | 1537215 | 2021-07-20 | Winnebago | Wisconsin | 55139 | 21590 | 228 |
1533967 | 1533967 | 2021-07-19 | Winnebago | Wisconsin | 55139 | 21561 | 228 |
1530720 | 1530720 | 2021-07-18 | Winnebago | Wisconsin | 55139 | 21550 | 228 |
1527473 | 1527473 | 2021-07-17 | Winnebago | Wisconsin | 55139 | 21550 | 228 |
1524226 | 1524226 | 2021-07-16 | Winnebago | Wisconsin | 55139 | 21550 | 228 |
1520978 | 1520978 | 2021-07-15 | Winnebago | Wisconsin | 55139 | 21540 | 227 |
1517730 | 1517730 | 2021-07-14 | Winnebago | Wisconsin | 55139 | 21537 | 227 |
1514483 | 1514483 | 2021-07-13 | Winnebago | Wisconsin | 55139 | 21530 | 227 |
1511237 | 1511237 | 2021-07-12 | Winnebago | Wisconsin | 55139 | 21519 | 227 |
1507990 | 1507990 | 2021-07-11 | Winnebago | Wisconsin | 55139 | 21519 | 226 |
1504744 | 1504744 | 2021-07-10 | Winnebago | Wisconsin | 55139 | 21519 | 226 |
1501498 | 1501498 | 2021-07-09 | Winnebago | Wisconsin | 55139 | 21519 | 226 |
1498252 | 1498252 | 2021-07-08 | Winnebago | Wisconsin | 55139 | 21519 | 225 |
1495005 | 1495005 | 2021-07-07 | Winnebago | Wisconsin | 55139 | 21518 | 225 |
1491758 | 1491758 | 2021-07-06 | Winnebago | Wisconsin | 55139 | 21514 | 225 |
1488511 | 1488511 | 2021-07-05 | Winnebago | Wisconsin | 55139 | 21514 | 225 |
1485264 | 1485264 | 2021-07-04 | Winnebago | Wisconsin | 55139 | 21514 | 225 |
1482018 | 1482018 | 2021-07-03 | Winnebago | Wisconsin | 55139 | 21514 | 225 |
1478771 | 1478771 | 2021-07-02 | Winnebago | Wisconsin | 55139 | 21514 | 225 |
1475525 | 1475525 | 2021-07-01 | Winnebago | Wisconsin | 55139 | 21508 | 225 |
1472279 | 1472279 | 2021-06-30 | Winnebago | Wisconsin | 55139 | 21504 | 225 |
1469034 | 1469034 | 2021-06-29 | Winnebago | Wisconsin | 55139 | 21501 | 225 |
1465789 | 1465789 | 2021-06-28 | Winnebago | Wisconsin | 55139 | 21495 | 225 |
1462544 | 1462544 | 2021-06-27 | Winnebago | Wisconsin | 55139 | 21492 | 225 |
1459299 | 1459299 | 2021-06-26 | Winnebago | Wisconsin | 55139 | 21492 | 225 |
1456054 | 1456054 | 2021-06-25 | Winnebago | Wisconsin | 55139 | 21492 | 225 |
1452809 | 1452809 | 2021-06-24 | Winnebago | Wisconsin | 55139 | 21491 | 225 |
1449563 | 1449563 | 2021-06-23 | Winnebago | Wisconsin | 55139 | 21491 | 225 |
1446318 | 1446318 | 2021-06-22 | Winnebago | Wisconsin | 55139 | 21488 | 225 |
1443073 | 1443073 | 2021-06-21 | Winnebago | Wisconsin | 55139 | 21488 | 225 |
1439828 | 1439828 | 2021-06-20 | Winnebago | Wisconsin | 55139 | 21487 | 225 |
1436581 | 1436581 | 2021-06-19 | Winnebago | Wisconsin | 55139 | 21487 | 225 |
1433334 | 1433334 | 2021-06-18 | Winnebago | Wisconsin | 55139 | 21487 | 225 |
1430088 | 1430088 | 2021-06-17 | Winnebago | Wisconsin | 55139 | 21483 | 224 |
1426843 | 1426843 | 2021-06-16 | Winnebago | Wisconsin | 55139 | 21479 | 224 |
1423597 | 1423597 | 2021-06-15 | Winnebago | Wisconsin | 55139 | 21477 | 224 |
1420350 | 1420350 | 2021-06-14 | Winnebago | Wisconsin | 55139 | 21471 | 224 |
1417105 | 1417105 | 2021-06-13 | Winnebago | Wisconsin | 55139 | 21468 | 224 |
1413859 | 1413859 | 2021-06-12 | Winnebago | Wisconsin | 55139 | 21468 | 224 |
1410614 | 1410614 | 2021-06-11 | Winnebago | Wisconsin | 55139 | 21468 | 224 |
1407369 | 1407369 | 2021-06-10 | Winnebago | Wisconsin | 55139 | 21463 | 224 |
1404123 | 1404123 | 2021-06-09 | Winnebago | Wisconsin | 55139 | 21459 | 224 |
1400878 | 1400878 | 2021-06-08 | Winnebago | Wisconsin | 55139 | 21456 | 224 |
1397633 | 1397633 | 2021-06-07 | Winnebago | Wisconsin | 55139 | 21447 | 224 |
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);