ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "La Crosse" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1517691 | 1517691 | 2021-07-14 | La Crosse | Wisconsin | 55063 | 13571 | 90 |
1514444 | 1514444 | 2021-07-13 | La Crosse | Wisconsin | 55063 | 13569 | 90 |
1511198 | 1511198 | 2021-07-12 | La Crosse | Wisconsin | 55063 | 13566 | 90 |
1507951 | 1507951 | 2021-07-11 | La Crosse | Wisconsin | 55063 | 13563 | 90 |
1504705 | 1504705 | 2021-07-10 | La Crosse | Wisconsin | 55063 | 13563 | 90 |
1501459 | 1501459 | 2021-07-09 | La Crosse | Wisconsin | 55063 | 13563 | 90 |
1498213 | 1498213 | 2021-07-08 | La Crosse | Wisconsin | 55063 | 13560 | 90 |
1494966 | 1494966 | 2021-07-07 | La Crosse | Wisconsin | 55063 | 13558 | 90 |
1491719 | 1491719 | 2021-07-06 | La Crosse | Wisconsin | 55063 | 13555 | 90 |
1488472 | 1488472 | 2021-07-05 | La Crosse | Wisconsin | 55063 | 13554 | 90 |
1485225 | 1485225 | 2021-07-04 | La Crosse | Wisconsin | 55063 | 13553 | 90 |
1481979 | 1481979 | 2021-07-03 | La Crosse | Wisconsin | 55063 | 13553 | 90 |
1478732 | 1478732 | 2021-07-02 | La Crosse | Wisconsin | 55063 | 13553 | 90 |
1475486 | 1475486 | 2021-07-01 | La Crosse | Wisconsin | 55063 | 13552 | 90 |
1472240 | 1472240 | 2021-06-30 | La Crosse | Wisconsin | 55063 | 13551 | 90 |
1468995 | 1468995 | 2021-06-29 | La Crosse | Wisconsin | 55063 | 13551 | 90 |
1465750 | 1465750 | 2021-06-28 | La Crosse | Wisconsin | 55063 | 13551 | 90 |
1462505 | 1462505 | 2021-06-27 | La Crosse | Wisconsin | 55063 | 13549 | 90 |
1459260 | 1459260 | 2021-06-26 | La Crosse | Wisconsin | 55063 | 13549 | 90 |
1456015 | 1456015 | 2021-06-25 | La Crosse | Wisconsin | 55063 | 13549 | 90 |
1452770 | 1452770 | 2021-06-24 | La Crosse | Wisconsin | 55063 | 13547 | 90 |
1449524 | 1449524 | 2021-06-23 | La Crosse | Wisconsin | 55063 | 13545 | 90 |
1446279 | 1446279 | 2021-06-22 | La Crosse | Wisconsin | 55063 | 13544 | 90 |
1443034 | 1443034 | 2021-06-21 | La Crosse | Wisconsin | 55063 | 13544 | 90 |
1439789 | 1439789 | 2021-06-20 | La Crosse | Wisconsin | 55063 | 13543 | 89 |
1436542 | 1436542 | 2021-06-19 | La Crosse | Wisconsin | 55063 | 13543 | 89 |
1433295 | 1433295 | 2021-06-18 | La Crosse | Wisconsin | 55063 | 13543 | 89 |
1430049 | 1430049 | 2021-06-17 | La Crosse | Wisconsin | 55063 | 13550 | 89 |
1426804 | 1426804 | 2021-06-16 | La Crosse | Wisconsin | 55063 | 13563 | 89 |
1423558 | 1423558 | 2021-06-15 | La Crosse | Wisconsin | 55063 | 13565 | 89 |
1420311 | 1420311 | 2021-06-14 | La Crosse | Wisconsin | 55063 | 13566 | 89 |
1417066 | 1417066 | 2021-06-13 | La Crosse | Wisconsin | 55063 | 13565 | 89 |
1413820 | 1413820 | 2021-06-12 | La Crosse | Wisconsin | 55063 | 13565 | 89 |
1410575 | 1410575 | 2021-06-11 | La Crosse | Wisconsin | 55063 | 13565 | 89 |
1407330 | 1407330 | 2021-06-10 | La Crosse | Wisconsin | 55063 | 13570 | 89 |
1404084 | 1404084 | 2021-06-09 | La Crosse | Wisconsin | 55063 | 13577 | 89 |
1400839 | 1400839 | 2021-06-08 | La Crosse | Wisconsin | 55063 | 13582 | 89 |
1397594 | 1397594 | 2021-06-07 | La Crosse | Wisconsin | 55063 | 13582 | 89 |
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);