ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 55059 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1813300 | 1813300 | 2021-10-13 | Kenosha | Wisconsin | 55059 | 23438 | 372 |
1810051 | 1810051 | 2021-10-12 | Kenosha | Wisconsin | 55059 | 23368 | 371 |
1806802 | 1806802 | 2021-10-11 | Kenosha | Wisconsin | 55059 | 23298 | 368 |
1803551 | 1803551 | 2021-10-10 | Kenosha | Wisconsin | 55059 | 23175 | 368 |
1800302 | 1800302 | 2021-10-09 | Kenosha | Wisconsin | 55059 | 23175 | 368 |
1797053 | 1797053 | 2021-10-08 | Kenosha | Wisconsin | 55059 | 23175 | 368 |
1793804 | 1793804 | 2021-10-07 | Kenosha | Wisconsin | 55059 | 23070 | 367 |
1790555 | 1790555 | 2021-10-06 | Kenosha | Wisconsin | 55059 | 22973 | 365 |
1787307 | 1787307 | 2021-10-05 | Kenosha | Wisconsin | 55059 | 22946 | 364 |
1784058 | 1784058 | 2021-10-04 | Kenosha | Wisconsin | 55059 | 22827 | 364 |
1780809 | 1780809 | 2021-10-03 | Kenosha | Wisconsin | 55059 | 22675 | 361 |
1777559 | 1777559 | 2021-10-02 | Kenosha | Wisconsin | 55059 | 22675 | 361 |
1774309 | 1774309 | 2021-10-01 | Kenosha | Wisconsin | 55059 | 22675 | 361 |
1771059 | 1771059 | 2021-09-30 | Kenosha | Wisconsin | 55059 | 22588 | 361 |
1767810 | 1767810 | 2021-09-29 | Kenosha | Wisconsin | 55059 | 22526 | 358 |
1764561 | 1764561 | 2021-09-28 | Kenosha | Wisconsin | 55059 | 22433 | 357 |
1761312 | 1761312 | 2021-09-27 | Kenosha | Wisconsin | 55059 | 22306 | 357 |
1758064 | 1758064 | 2021-09-26 | Kenosha | Wisconsin | 55059 | 22157 | 357 |
1754816 | 1754816 | 2021-09-25 | Kenosha | Wisconsin | 55059 | 22157 | 357 |
1751568 | 1751568 | 2021-09-24 | Kenosha | Wisconsin | 55059 | 22157 | 357 |
1748319 | 1748319 | 2021-09-23 | Kenosha | Wisconsin | 55059 | 22056 | 355 |
1745069 | 1745069 | 2021-09-22 | Kenosha | Wisconsin | 55059 | 21963 | 355 |
1741820 | 1741820 | 2021-09-21 | Kenosha | Wisconsin | 55059 | 21821 | 354 |
1738571 | 1738571 | 2021-09-20 | Kenosha | Wisconsin | 55059 | 21741 | 354 |
1735322 | 1735322 | 2021-09-19 | Kenosha | Wisconsin | 55059 | 21570 | 353 |
1732072 | 1732072 | 2021-09-18 | Kenosha | Wisconsin | 55059 | 21570 | 353 |
1728822 | 1728822 | 2021-09-17 | Kenosha | Wisconsin | 55059 | 21570 | 353 |
1725572 | 1725572 | 2021-09-16 | Kenosha | Wisconsin | 55059 | 21444 | 352 |
1722323 | 1722323 | 2021-09-15 | Kenosha | Wisconsin | 55059 | 21370 | 350 |
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 |
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);