ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Kenosha" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1719075 | 1719075 | 2021-09-14 | Kenosha | Wisconsin | 55059 | 21287 | 345 |
1715827 | 1715827 | 2021-09-13 | Kenosha | Wisconsin | 55059 | 21219 | 345 |
1712581 | 1712581 | 2021-09-12 | Kenosha | Wisconsin | 55059 | 21106 | 345 |
1709334 | 1709334 | 2021-09-11 | Kenosha | Wisconsin | 55059 | 21106 | 345 |
1706087 | 1706087 | 2021-09-10 | Kenosha | Wisconsin | 55059 | 21106 | 345 |
1702838 | 1702838 | 2021-09-09 | Kenosha | Wisconsin | 55059 | 21018 | 344 |
1699588 | 1699588 | 2021-09-08 | Kenosha | Wisconsin | 55059 | 20868 | 343 |
1696340 | 1696340 | 2021-09-07 | Kenosha | Wisconsin | 55059 | 20758 | 343 |
1693092 | 1693092 | 2021-09-06 | Kenosha | Wisconsin | 55059 | 20721 | 343 |
1689843 | 1689843 | 2021-09-05 | Kenosha | Wisconsin | 55059 | 20583 | 343 |
1686593 | 1686593 | 2021-09-04 | Kenosha | Wisconsin | 55059 | 20583 | 343 |
1683343 | 1683343 | 2021-09-03 | Kenosha | Wisconsin | 55059 | 20583 | 343 |
1680092 | 1680092 | 2021-09-02 | Kenosha | Wisconsin | 55059 | 20524 | 343 |
1676844 | 1676844 | 2021-09-01 | Kenosha | Wisconsin | 55059 | 20454 | 343 |
1673597 | 1673597 | 2021-08-31 | Kenosha | Wisconsin | 55059 | 20384 | 343 |
1670349 | 1670349 | 2021-08-30 | Kenosha | Wisconsin | 55059 | 20323 | 342 |
1667102 | 1667102 | 2021-08-29 | Kenosha | Wisconsin | 55059 | 20186 | 342 |
1663854 | 1663854 | 2021-08-28 | Kenosha | Wisconsin | 55059 | 20186 | 342 |
1660606 | 1660606 | 2021-08-27 | Kenosha | Wisconsin | 55059 | 20186 | 342 |
1657358 | 1657358 | 2021-08-26 | Kenosha | Wisconsin | 55059 | 20121 | 342 |
1654110 | 1654110 | 2021-08-25 | Kenosha | Wisconsin | 55059 | 20062 | 342 |
1650864 | 1650864 | 2021-08-24 | Kenosha | Wisconsin | 55059 | 20010 | 342 |
1647615 | 1647615 | 2021-08-23 | Kenosha | Wisconsin | 55059 | 19960 | 342 |
1644366 | 1644366 | 2021-08-22 | Kenosha | Wisconsin | 55059 | 19901 | 342 |
1641116 | 1641116 | 2021-08-21 | Kenosha | Wisconsin | 55059 | 19901 | 342 |
1637866 | 1637866 | 2021-08-20 | Kenosha | Wisconsin | 55059 | 19901 | 342 |
1634616 | 1634616 | 2021-08-19 | Kenosha | Wisconsin | 55059 | 19859 | 342 |
1631368 | 1631368 | 2021-08-18 | Kenosha | Wisconsin | 55059 | 19810 | 342 |
1628121 | 1628121 | 2021-08-17 | Kenosha | Wisconsin | 55059 | 19746 | 342 |
1624874 | 1624874 | 2021-08-16 | Kenosha | Wisconsin | 55059 | 19675 | 342 |
1621627 | 1621627 | 2021-08-15 | Kenosha | Wisconsin | 55059 | 19641 | 342 |
1618379 | 1618379 | 2021-08-14 | Kenosha | Wisconsin | 55059 | 19641 | 342 |
1615131 | 1615131 | 2021-08-13 | Kenosha | Wisconsin | 55059 | 19641 | 342 |
1611882 | 1611882 | 2021-08-12 | Kenosha | Wisconsin | 55059 | 19559 | 341 |
1608635 | 1608635 | 2021-08-11 | Kenosha | Wisconsin | 55059 | 19518 | 341 |
1605386 | 1605386 | 2021-08-10 | Kenosha | Wisconsin | 55059 | 19479 | 340 |
1602136 | 1602136 | 2021-08-09 | Kenosha | Wisconsin | 55059 | 19424 | 340 |
1598888 | 1598888 | 2021-08-08 | Kenosha | Wisconsin | 55059 | 19363 | 340 |
1595639 | 1595639 | 2021-08-07 | Kenosha | Wisconsin | 55059 | 19363 | 340 |
1592390 | 1592390 | 2021-08-06 | Kenosha | Wisconsin | 55059 | 19363 | 340 |
1589141 | 1589141 | 2021-08-05 | Kenosha | Wisconsin | 55059 | 19317 | 340 |
1585892 | 1585892 | 2021-08-04 | Kenosha | Wisconsin | 55059 | 19281 | 340 |
1582642 | 1582642 | 2021-08-03 | Kenosha | Wisconsin | 55059 | 19246 | 340 |
1579392 | 1579392 | 2021-08-02 | Kenosha | Wisconsin | 55059 | 19187 | 340 |
1576144 | 1576144 | 2021-08-01 | Kenosha | Wisconsin | 55059 | 19139 | 340 |
1572896 | 1572896 | 2021-07-31 | Kenosha | Wisconsin | 55059 | 19139 | 340 |
1569648 | 1569648 | 2021-07-30 | Kenosha | Wisconsin | 55059 | 19139 | 340 |
1566400 | 1566400 | 2021-07-29 | Kenosha | Wisconsin | 55059 | 19101 | 340 |
1563152 | 1563152 | 2021-07-28 | Kenosha | Wisconsin | 55059 | 19067 | 339 |
1559904 | 1559904 | 2021-07-27 | Kenosha | Wisconsin | 55059 | 19049 | 339 |
1556657 | 1556657 | 2021-07-26 | Kenosha | Wisconsin | 55059 | 19011 | 339 |
1553410 | 1553410 | 2021-07-25 | Kenosha | Wisconsin | 55059 | 19000 | 339 |
1550163 | 1550163 | 2021-07-24 | Kenosha | Wisconsin | 55059 | 19000 | 339 |
1546916 | 1546916 | 2021-07-23 | Kenosha | Wisconsin | 55059 | 19000 | 339 |
1543669 | 1543669 | 2021-07-22 | Kenosha | Wisconsin | 55059 | 18980 | 338 |
1540421 | 1540421 | 2021-07-21 | Kenosha | Wisconsin | 55059 | 18976 | 338 |
1537174 | 1537174 | 2021-07-20 | Kenosha | Wisconsin | 55059 | 18968 | 338 |
1533926 | 1533926 | 2021-07-19 | Kenosha | Wisconsin | 55059 | 18947 | 338 |
1530679 | 1530679 | 2021-07-18 | Kenosha | Wisconsin | 55059 | 18945 | 338 |
1527432 | 1527432 | 2021-07-17 | Kenosha | Wisconsin | 55059 | 18945 | 338 |
1524185 | 1524185 | 2021-07-16 | Kenosha | Wisconsin | 55059 | 18945 | 338 |
1520937 | 1520937 | 2021-07-15 | Kenosha | Wisconsin | 55059 | 18939 | 338 |
1517689 | 1517689 | 2021-07-14 | Kenosha | Wisconsin | 55059 | 18928 | 338 |
1514442 | 1514442 | 2021-07-13 | Kenosha | Wisconsin | 55059 | 18920 | 338 |
1511196 | 1511196 | 2021-07-12 | Kenosha | Wisconsin | 55059 | 18904 | 338 |
1507949 | 1507949 | 2021-07-11 | Kenosha | Wisconsin | 55059 | 18892 | 337 |
1504703 | 1504703 | 2021-07-10 | Kenosha | Wisconsin | 55059 | 18892 | 337 |
1501457 | 1501457 | 2021-07-09 | Kenosha | Wisconsin | 55059 | 18892 | 337 |
1498211 | 1498211 | 2021-07-08 | Kenosha | Wisconsin | 55059 | 18868 | 336 |
1494964 | 1494964 | 2021-07-07 | Kenosha | Wisconsin | 55059 | 18846 | 336 |
1491717 | 1491717 | 2021-07-06 | Kenosha | Wisconsin | 55059 | 18837 | 336 |
1488470 | 1488470 | 2021-07-05 | Kenosha | Wisconsin | 55059 | 18836 | 336 |
1485223 | 1485223 | 2021-07-04 | Kenosha | Wisconsin | 55059 | 18835 | 336 |
1481977 | 1481977 | 2021-07-03 | Kenosha | Wisconsin | 55059 | 18835 | 336 |
1478730 | 1478730 | 2021-07-02 | Kenosha | Wisconsin | 55059 | 18835 | 336 |
1475484 | 1475484 | 2021-07-01 | Kenosha | Wisconsin | 55059 | 18828 | 336 |
1472238 | 1472238 | 2021-06-30 | Kenosha | Wisconsin | 55059 | 18823 | 336 |
1468993 | 1468993 | 2021-06-29 | Kenosha | Wisconsin | 55059 | 18814 | 336 |
1465748 | 1465748 | 2021-06-28 | Kenosha | Wisconsin | 55059 | 18797 | 335 |
1462503 | 1462503 | 2021-06-27 | Kenosha | Wisconsin | 55059 | 18797 | 335 |
1459258 | 1459258 | 2021-06-26 | Kenosha | Wisconsin | 55059 | 18797 | 335 |
1456013 | 1456013 | 2021-06-25 | Kenosha | Wisconsin | 55059 | 18797 | 335 |
1452768 | 1452768 | 2021-06-24 | Kenosha | Wisconsin | 55059 | 18798 | 335 |
1449522 | 1449522 | 2021-06-23 | Kenosha | Wisconsin | 55059 | 18774 | 335 |
1446277 | 1446277 | 2021-06-22 | Kenosha | Wisconsin | 55059 | 18763 | 335 |
1443032 | 1443032 | 2021-06-21 | Kenosha | Wisconsin | 55059 | 18743 | 335 |
1439787 | 1439787 | 2021-06-20 | Kenosha | Wisconsin | 55059 | 18739 | 335 |
1436540 | 1436540 | 2021-06-19 | Kenosha | Wisconsin | 55059 | 18739 | 335 |
1433293 | 1433293 | 2021-06-18 | Kenosha | Wisconsin | 55059 | 18739 | 335 |
1430047 | 1430047 | 2021-06-17 | Kenosha | Wisconsin | 55059 | 18736 | 335 |
1426802 | 1426802 | 2021-06-16 | Kenosha | Wisconsin | 55059 | 18733 | 334 |
1423556 | 1423556 | 2021-06-15 | Kenosha | Wisconsin | 55059 | 18732 | 334 |
1420309 | 1420309 | 2021-06-14 | Kenosha | Wisconsin | 55059 | 18729 | 334 |
1417064 | 1417064 | 2021-06-13 | Kenosha | Wisconsin | 55059 | 18725 | 334 |
1413818 | 1413818 | 2021-06-12 | Kenosha | Wisconsin | 55059 | 18725 | 334 |
1410573 | 1410573 | 2021-06-11 | Kenosha | Wisconsin | 55059 | 18725 | 334 |
1407328 | 1407328 | 2021-06-10 | Kenosha | Wisconsin | 55059 | 18721 | 334 |
1404082 | 1404082 | 2021-06-09 | Kenosha | Wisconsin | 55059 | 18714 | 333 |
1400837 | 1400837 | 2021-06-08 | Kenosha | Wisconsin | 55059 | 18713 | 333 |
1397592 | 1397592 | 2021-06-07 | Kenosha | Wisconsin | 55059 | 18705 | 333 |
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);