ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 55063 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1842542 | 1842542 | 2021-10-22 | La Crosse | Wisconsin | 55063 | 17186 | 110 |
1839293 | 1839293 | 2021-10-21 | La Crosse | Wisconsin | 55063 | 17147 | 110 |
1836044 | 1836044 | 2021-10-20 | La Crosse | Wisconsin | 55063 | 17110 | 109 |
1832795 | 1832795 | 2021-10-19 | La Crosse | Wisconsin | 55063 | 17041 | 109 |
1829546 | 1829546 | 2021-10-18 | La Crosse | Wisconsin | 55063 | 17034 | 109 |
1826297 | 1826297 | 2021-10-17 | La Crosse | Wisconsin | 55063 | 16966 | 109 |
1823048 | 1823048 | 2021-10-16 | La Crosse | Wisconsin | 55063 | 16882 | 109 |
1819799 | 1819799 | 2021-10-15 | La Crosse | Wisconsin | 55063 | 16882 | 109 |
1816550 | 1816550 | 2021-10-14 | La Crosse | Wisconsin | 55063 | 16882 | 109 |
1813302 | 1813302 | 2021-10-13 | La Crosse | Wisconsin | 55063 | 16838 | 109 |
1810053 | 1810053 | 2021-10-12 | La Crosse | Wisconsin | 55063 | 16786 | 108 |
1806804 | 1806804 | 2021-10-11 | La Crosse | Wisconsin | 55063 | 16732 | 107 |
1803553 | 1803553 | 2021-10-10 | La Crosse | Wisconsin | 55063 | 16634 | 106 |
1800304 | 1800304 | 2021-10-09 | La Crosse | Wisconsin | 55063 | 16634 | 106 |
1797055 | 1797055 | 2021-10-08 | La Crosse | Wisconsin | 55063 | 16634 | 106 |
1793806 | 1793806 | 2021-10-07 | La Crosse | Wisconsin | 55063 | 16578 | 105 |
1790557 | 1790557 | 2021-10-06 | La Crosse | Wisconsin | 55063 | 16522 | 105 |
1787309 | 1787309 | 2021-10-05 | La Crosse | Wisconsin | 55063 | 16477 | 105 |
1784060 | 1784060 | 2021-10-04 | La Crosse | Wisconsin | 55063 | 16416 | 105 |
1780811 | 1780811 | 2021-10-03 | La Crosse | Wisconsin | 55063 | 16249 | 105 |
1777561 | 1777561 | 2021-10-02 | La Crosse | Wisconsin | 55063 | 16249 | 105 |
1774311 | 1774311 | 2021-10-01 | La Crosse | Wisconsin | 55063 | 16249 | 105 |
1771061 | 1771061 | 2021-09-30 | La Crosse | Wisconsin | 55063 | 16199 | 104 |
1767812 | 1767812 | 2021-09-29 | La Crosse | Wisconsin | 55063 | 16118 | 104 |
1764563 | 1764563 | 2021-09-28 | La Crosse | Wisconsin | 55063 | 16035 | 104 |
1761314 | 1761314 | 2021-09-27 | La Crosse | Wisconsin | 55063 | 15974 | 103 |
1758066 | 1758066 | 2021-09-26 | La Crosse | Wisconsin | 55063 | 15855 | 103 |
1754818 | 1754818 | 2021-09-25 | La Crosse | Wisconsin | 55063 | 15855 | 103 |
1751570 | 1751570 | 2021-09-24 | La Crosse | Wisconsin | 55063 | 15855 | 103 |
1748321 | 1748321 | 2021-09-23 | La Crosse | Wisconsin | 55063 | 15774 | 102 |
1745071 | 1745071 | 2021-09-22 | La Crosse | Wisconsin | 55063 | 15703 | 101 |
1741822 | 1741822 | 2021-09-21 | La Crosse | Wisconsin | 55063 | 15662 | 101 |
1738573 | 1738573 | 2021-09-20 | La Crosse | Wisconsin | 55063 | 15612 | 101 |
1735324 | 1735324 | 2021-09-19 | La Crosse | Wisconsin | 55063 | 15472 | 101 |
1732074 | 1732074 | 2021-09-18 | La Crosse | Wisconsin | 55063 | 15472 | 101 |
1728824 | 1728824 | 2021-09-17 | La Crosse | Wisconsin | 55063 | 15472 | 101 |
1725574 | 1725574 | 2021-09-16 | La Crosse | Wisconsin | 55063 | 15394 | 101 |
1722325 | 1722325 | 2021-09-15 | La Crosse | Wisconsin | 55063 | 15316 | 101 |
1719077 | 1719077 | 2021-09-14 | La Crosse | Wisconsin | 55063 | 15203 | 100 |
1715829 | 1715829 | 2021-09-13 | La Crosse | Wisconsin | 55063 | 15159 | 100 |
1712583 | 1712583 | 2021-09-12 | La Crosse | Wisconsin | 55063 | 15064 | 100 |
1709336 | 1709336 | 2021-09-11 | La Crosse | Wisconsin | 55063 | 15064 | 100 |
1706089 | 1706089 | 2021-09-10 | La Crosse | Wisconsin | 55063 | 15064 | 100 |
1702840 | 1702840 | 2021-09-09 | La Crosse | Wisconsin | 55063 | 15008 | 97 |
1699590 | 1699590 | 2021-09-08 | La Crosse | Wisconsin | 55063 | 14967 | 96 |
1696342 | 1696342 | 2021-09-07 | La Crosse | Wisconsin | 55063 | 14920 | 96 |
1693094 | 1693094 | 2021-09-06 | La Crosse | Wisconsin | 55063 | 14916 | 96 |
1689845 | 1689845 | 2021-09-05 | La Crosse | Wisconsin | 55063 | 14781 | 95 |
1686595 | 1686595 | 2021-09-04 | La Crosse | Wisconsin | 55063 | 14781 | 95 |
1683345 | 1683345 | 2021-09-03 | La Crosse | Wisconsin | 55063 | 14781 | 95 |
1680094 | 1680094 | 2021-09-02 | La Crosse | Wisconsin | 55063 | 14724 | 95 |
1676846 | 1676846 | 2021-09-01 | La Crosse | Wisconsin | 55063 | 14690 | 95 |
1673599 | 1673599 | 2021-08-31 | La Crosse | Wisconsin | 55063 | 14611 | 95 |
1670351 | 1670351 | 2021-08-30 | La Crosse | Wisconsin | 55063 | 14584 | 95 |
1667104 | 1667104 | 2021-08-29 | La Crosse | Wisconsin | 55063 | 14494 | 94 |
1663856 | 1663856 | 2021-08-28 | La Crosse | Wisconsin | 55063 | 14494 | 94 |
1660608 | 1660608 | 2021-08-27 | La Crosse | Wisconsin | 55063 | 14494 | 94 |
1657360 | 1657360 | 2021-08-26 | La Crosse | Wisconsin | 55063 | 14422 | 94 |
1654112 | 1654112 | 2021-08-25 | La Crosse | Wisconsin | 55063 | 14363 | 94 |
1650866 | 1650866 | 2021-08-24 | La Crosse | Wisconsin | 55063 | 14294 | 94 |
1647617 | 1647617 | 2021-08-23 | La Crosse | Wisconsin | 55063 | 14224 | 94 |
1644368 | 1644368 | 2021-08-22 | La Crosse | Wisconsin | 55063 | 14135 | 94 |
1641118 | 1641118 | 2021-08-21 | La Crosse | Wisconsin | 55063 | 14135 | 94 |
1637868 | 1637868 | 2021-08-20 | La Crosse | Wisconsin | 55063 | 14135 | 94 |
1634618 | 1634618 | 2021-08-19 | La Crosse | Wisconsin | 55063 | 14099 | 94 |
1631370 | 1631370 | 2021-08-18 | La Crosse | Wisconsin | 55063 | 14060 | 94 |
1628123 | 1628123 | 2021-08-17 | La Crosse | Wisconsin | 55063 | 14028 | 93 |
1624876 | 1624876 | 2021-08-16 | La Crosse | Wisconsin | 55063 | 14003 | 93 |
1621629 | 1621629 | 2021-08-15 | La Crosse | Wisconsin | 55063 | 13955 | 93 |
1618381 | 1618381 | 2021-08-14 | La Crosse | Wisconsin | 55063 | 13955 | 93 |
1615133 | 1615133 | 2021-08-13 | La Crosse | Wisconsin | 55063 | 13955 | 93 |
1611884 | 1611884 | 2021-08-12 | La Crosse | Wisconsin | 55063 | 13913 | 93 |
1608637 | 1608637 | 2021-08-11 | La Crosse | Wisconsin | 55063 | 13880 | 93 |
1605388 | 1605388 | 2021-08-10 | La Crosse | Wisconsin | 55063 | 13849 | 94 |
1602138 | 1602138 | 2021-08-09 | La Crosse | Wisconsin | 55063 | 13816 | 94 |
1598890 | 1598890 | 2021-08-08 | La Crosse | Wisconsin | 55063 | 13774 | 93 |
1595641 | 1595641 | 2021-08-07 | La Crosse | Wisconsin | 55063 | 13774 | 93 |
1592392 | 1592392 | 2021-08-06 | La Crosse | Wisconsin | 55063 | 13774 | 93 |
1589143 | 1589143 | 2021-08-05 | La Crosse | Wisconsin | 55063 | 13739 | 93 |
1585894 | 1585894 | 2021-08-04 | La Crosse | Wisconsin | 55063 | 13729 | 93 |
1582644 | 1582644 | 2021-08-03 | La Crosse | Wisconsin | 55063 | 13717 | 93 |
1579394 | 1579394 | 2021-08-02 | La Crosse | Wisconsin | 55063 | 13699 | 93 |
1576146 | 1576146 | 2021-08-01 | La Crosse | Wisconsin | 55063 | 13663 | 93 |
1572898 | 1572898 | 2021-07-31 | La Crosse | Wisconsin | 55063 | 13663 | 93 |
1569650 | 1569650 | 2021-07-30 | La Crosse | Wisconsin | 55063 | 13663 | 93 |
1566402 | 1566402 | 2021-07-29 | La Crosse | Wisconsin | 55063 | 13647 | 93 |
1563154 | 1563154 | 2021-07-28 | La Crosse | Wisconsin | 55063 | 13635 | 92 |
1559906 | 1559906 | 2021-07-27 | La Crosse | Wisconsin | 55063 | 13623 | 91 |
1556659 | 1556659 | 2021-07-26 | La Crosse | Wisconsin | 55063 | 13617 | 91 |
1553412 | 1553412 | 2021-07-25 | La Crosse | Wisconsin | 55063 | 13605 | 91 |
1550165 | 1550165 | 2021-07-24 | La Crosse | Wisconsin | 55063 | 13605 | 91 |
1546918 | 1546918 | 2021-07-23 | La Crosse | Wisconsin | 55063 | 13605 | 91 |
1543671 | 1543671 | 2021-07-22 | La Crosse | Wisconsin | 55063 | 13602 | 91 |
1540423 | 1540423 | 2021-07-21 | La Crosse | Wisconsin | 55063 | 13596 | 91 |
1537176 | 1537176 | 2021-07-20 | La Crosse | Wisconsin | 55063 | 13591 | 91 |
1533928 | 1533928 | 2021-07-19 | La Crosse | Wisconsin | 55063 | 13586 | 91 |
1530681 | 1530681 | 2021-07-18 | La Crosse | Wisconsin | 55063 | 13580 | 91 |
1527434 | 1527434 | 2021-07-17 | La Crosse | Wisconsin | 55063 | 13580 | 91 |
1524187 | 1524187 | 2021-07-16 | La Crosse | Wisconsin | 55063 | 13580 | 91 |
1520939 | 1520939 | 2021-07-15 | La Crosse | Wisconsin | 55063 | 13573 | 90 |
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);