ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 55021 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1719056 | 1719056 | 2021-09-14 | Columbia | Wisconsin | 55021 | 6646 | 75 |
1715808 | 1715808 | 2021-09-13 | Columbia | Wisconsin | 55021 | 6613 | 75 |
1712562 | 1712562 | 2021-09-12 | Columbia | Wisconsin | 55021 | 6550 | 75 |
1709315 | 1709315 | 2021-09-11 | Columbia | Wisconsin | 55021 | 6550 | 75 |
1706068 | 1706068 | 2021-09-10 | Columbia | Wisconsin | 55021 | 6550 | 75 |
1702819 | 1702819 | 2021-09-09 | Columbia | Wisconsin | 55021 | 6517 | 75 |
1699569 | 1699569 | 2021-09-08 | Columbia | Wisconsin | 55021 | 6484 | 75 |
1696321 | 1696321 | 2021-09-07 | Columbia | Wisconsin | 55021 | 6462 | 75 |
1693073 | 1693073 | 2021-09-06 | Columbia | Wisconsin | 55021 | 6449 | 75 |
1689824 | 1689824 | 2021-09-05 | Columbia | Wisconsin | 55021 | 6389 | 75 |
1686574 | 1686574 | 2021-09-04 | Columbia | Wisconsin | 55021 | 6389 | 75 |
1683324 | 1683324 | 2021-09-03 | Columbia | Wisconsin | 55021 | 6389 | 75 |
1680073 | 1680073 | 2021-09-02 | Columbia | Wisconsin | 55021 | 6367 | 75 |
1676825 | 1676825 | 2021-09-01 | Columbia | Wisconsin | 55021 | 6336 | 75 |
1673578 | 1673578 | 2021-08-31 | Columbia | Wisconsin | 55021 | 6323 | 75 |
1670330 | 1670330 | 2021-08-30 | Columbia | Wisconsin | 55021 | 6321 | 75 |
1667083 | 1667083 | 2021-08-29 | Columbia | Wisconsin | 55021 | 6277 | 75 |
1663835 | 1663835 | 2021-08-28 | Columbia | Wisconsin | 55021 | 6277 | 75 |
1660587 | 1660587 | 2021-08-27 | Columbia | Wisconsin | 55021 | 6277 | 75 |
1657339 | 1657339 | 2021-08-26 | Columbia | Wisconsin | 55021 | 6247 | 75 |
1654091 | 1654091 | 2021-08-25 | Columbia | Wisconsin | 55021 | 6244 | 75 |
1650845 | 1650845 | 2021-08-24 | Columbia | Wisconsin | 55021 | 6225 | 74 |
1647596 | 1647596 | 2021-08-23 | Columbia | Wisconsin | 55021 | 6219 | 74 |
1644347 | 1644347 | 2021-08-22 | Columbia | Wisconsin | 55021 | 6185 | 74 |
1641097 | 1641097 | 2021-08-21 | Columbia | Wisconsin | 55021 | 6185 | 74 |
1637847 | 1637847 | 2021-08-20 | Columbia | Wisconsin | 55021 | 6185 | 74 |
1634597 | 1634597 | 2021-08-19 | Columbia | Wisconsin | 55021 | 6168 | 73 |
1631349 | 1631349 | 2021-08-18 | Columbia | Wisconsin | 55021 | 6160 | 73 |
1628102 | 1628102 | 2021-08-17 | Columbia | Wisconsin | 55021 | 6145 | 73 |
1624855 | 1624855 | 2021-08-16 | Columbia | Wisconsin | 55021 | 6142 | 73 |
1621608 | 1621608 | 2021-08-15 | Columbia | Wisconsin | 55021 | 6114 | 73 |
1618360 | 1618360 | 2021-08-14 | Columbia | Wisconsin | 55021 | 6114 | 73 |
1615112 | 1615112 | 2021-08-13 | Columbia | Wisconsin | 55021 | 6114 | 73 |
1611863 | 1611863 | 2021-08-12 | Columbia | Wisconsin | 55021 | 6099 | 73 |
1608616 | 1608616 | 2021-08-11 | Columbia | Wisconsin | 55021 | 6078 | 73 |
1605367 | 1605367 | 2021-08-10 | Columbia | Wisconsin | 55021 | 6070 | 73 |
1602117 | 1602117 | 2021-08-09 | Columbia | Wisconsin | 55021 | 6062 | 73 |
1598869 | 1598869 | 2021-08-08 | Columbia | Wisconsin | 55021 | 6044 | 73 |
1595620 | 1595620 | 2021-08-07 | Columbia | Wisconsin | 55021 | 6044 | 73 |
1592371 | 1592371 | 2021-08-06 | Columbia | Wisconsin | 55021 | 6044 | 73 |
1589122 | 1589122 | 2021-08-05 | Columbia | Wisconsin | 55021 | 6043 | 73 |
1585873 | 1585873 | 2021-08-04 | Columbia | Wisconsin | 55021 | 6031 | 73 |
1582623 | 1582623 | 2021-08-03 | Columbia | Wisconsin | 55021 | 6031 | 73 |
1579373 | 1579373 | 2021-08-02 | Columbia | Wisconsin | 55021 | 6024 | 73 |
1576125 | 1576125 | 2021-08-01 | Columbia | Wisconsin | 55021 | 6006 | 73 |
1572877 | 1572877 | 2021-07-31 | Columbia | Wisconsin | 55021 | 6006 | 73 |
1569629 | 1569629 | 2021-07-30 | Columbia | Wisconsin | 55021 | 6006 | 73 |
1566381 | 1566381 | 2021-07-29 | Columbia | Wisconsin | 55021 | 5994 | 73 |
1563133 | 1563133 | 2021-07-28 | Columbia | Wisconsin | 55021 | 5990 | 73 |
1559885 | 1559885 | 2021-07-27 | Columbia | Wisconsin | 55021 | 5980 | 73 |
1556638 | 1556638 | 2021-07-26 | Columbia | Wisconsin | 55021 | 5973 | 73 |
1553391 | 1553391 | 2021-07-25 | Columbia | Wisconsin | 55021 | 5963 | 73 |
1550144 | 1550144 | 2021-07-24 | Columbia | Wisconsin | 55021 | 5963 | 73 |
1546897 | 1546897 | 2021-07-23 | Columbia | Wisconsin | 55021 | 5963 | 73 |
1543650 | 1543650 | 2021-07-22 | Columbia | Wisconsin | 55021 | 5962 | 73 |
1540402 | 1540402 | 2021-07-21 | Columbia | Wisconsin | 55021 | 5958 | 73 |
1537155 | 1537155 | 2021-07-20 | Columbia | Wisconsin | 55021 | 5953 | 73 |
1533907 | 1533907 | 2021-07-19 | Columbia | Wisconsin | 55021 | 5951 | 73 |
1530660 | 1530660 | 2021-07-18 | Columbia | Wisconsin | 55021 | 5943 | 73 |
1527413 | 1527413 | 2021-07-17 | Columbia | Wisconsin | 55021 | 5943 | 73 |
1524166 | 1524166 | 2021-07-16 | Columbia | Wisconsin | 55021 | 5943 | 73 |
1520918 | 1520918 | 2021-07-15 | Columbia | Wisconsin | 55021 | 5939 | 73 |
1517670 | 1517670 | 2021-07-14 | Columbia | Wisconsin | 55021 | 5938 | 73 |
1514423 | 1514423 | 2021-07-13 | Columbia | Wisconsin | 55021 | 5935 | 73 |
1511177 | 1511177 | 2021-07-12 | Columbia | Wisconsin | 55021 | 5933 | 73 |
1507930 | 1507930 | 2021-07-11 | Columbia | Wisconsin | 55021 | 5929 | 73 |
1504684 | 1504684 | 2021-07-10 | Columbia | Wisconsin | 55021 | 5929 | 73 |
1501438 | 1501438 | 2021-07-09 | Columbia | Wisconsin | 55021 | 5929 | 73 |
1498192 | 1498192 | 2021-07-08 | Columbia | Wisconsin | 55021 | 5928 | 73 |
1494945 | 1494945 | 2021-07-07 | Columbia | Wisconsin | 55021 | 5925 | 73 |
1491698 | 1491698 | 2021-07-06 | Columbia | Wisconsin | 55021 | 5925 | 73 |
1488451 | 1488451 | 2021-07-05 | Columbia | Wisconsin | 55021 | 5925 | 73 |
1485204 | 1485204 | 2021-07-04 | Columbia | Wisconsin | 55021 | 5924 | 71 |
1481958 | 1481958 | 2021-07-03 | Columbia | Wisconsin | 55021 | 5924 | 71 |
1478711 | 1478711 | 2021-07-02 | Columbia | Wisconsin | 55021 | 5924 | 71 |
1475465 | 1475465 | 2021-07-01 | Columbia | Wisconsin | 55021 | 5924 | 71 |
1472219 | 1472219 | 2021-06-30 | Columbia | Wisconsin | 55021 | 5924 | 71 |
1468974 | 1468974 | 2021-06-29 | Columbia | Wisconsin | 55021 | 5924 | 71 |
1465729 | 1465729 | 2021-06-28 | Columbia | Wisconsin | 55021 | 5926 | 71 |
1462484 | 1462484 | 2021-06-27 | Columbia | Wisconsin | 55021 | 5925 | 71 |
1459239 | 1459239 | 2021-06-26 | Columbia | Wisconsin | 55021 | 5925 | 71 |
1455994 | 1455994 | 2021-06-25 | Columbia | Wisconsin | 55021 | 5925 | 71 |
1452749 | 1452749 | 2021-06-24 | Columbia | Wisconsin | 55021 | 5924 | 71 |
1449503 | 1449503 | 2021-06-23 | Columbia | Wisconsin | 55021 | 5919 | 71 |
1446258 | 1446258 | 2021-06-22 | Columbia | Wisconsin | 55021 | 5921 | 71 |
1443013 | 1443013 | 2021-06-21 | Columbia | Wisconsin | 55021 | 5920 | 71 |
1439768 | 1439768 | 2021-06-20 | Columbia | Wisconsin | 55021 | 5919 | 71 |
1436521 | 1436521 | 2021-06-19 | Columbia | Wisconsin | 55021 | 5919 | 71 |
1433274 | 1433274 | 2021-06-18 | Columbia | Wisconsin | 55021 | 5919 | 71 |
1430028 | 1430028 | 2021-06-17 | Columbia | Wisconsin | 55021 | 5919 | 71 |
1426783 | 1426783 | 2021-06-16 | Columbia | Wisconsin | 55021 | 5916 | 71 |
1423537 | 1423537 | 2021-06-15 | Columbia | Wisconsin | 55021 | 5916 | 71 |
1420290 | 1420290 | 2021-06-14 | Columbia | Wisconsin | 55021 | 5913 | 71 |
1417045 | 1417045 | 2021-06-13 | Columbia | Wisconsin | 55021 | 5911 | 71 |
1413799 | 1413799 | 2021-06-12 | Columbia | Wisconsin | 55021 | 5911 | 71 |
1410554 | 1410554 | 2021-06-11 | Columbia | Wisconsin | 55021 | 5911 | 71 |
1407309 | 1407309 | 2021-06-10 | Columbia | Wisconsin | 55021 | 5910 | 71 |
1404063 | 1404063 | 2021-06-09 | Columbia | Wisconsin | 55021 | 5910 | 70 |
1400818 | 1400818 | 2021-06-08 | Columbia | Wisconsin | 55021 | 5909 | 70 |
1397573 | 1397573 | 2021-06-07 | Columbia | Wisconsin | 55021 | 5909 | 69 |
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);