ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 55133 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1719113 | 1719113 | 2021-09-14 | Waukesha | Wisconsin | 55133 | 55537 | 678 |
1715865 | 1715865 | 2021-09-13 | Waukesha | Wisconsin | 55133 | 55366 | 677 |
1712619 | 1712619 | 2021-09-12 | Waukesha | Wisconsin | 55133 | 55180 | 676 |
1709372 | 1709372 | 2021-09-11 | Waukesha | Wisconsin | 55133 | 55180 | 676 |
1706125 | 1706125 | 2021-09-10 | Waukesha | Wisconsin | 55133 | 55180 | 676 |
1702877 | 1702877 | 2021-09-09 | Waukesha | Wisconsin | 55133 | 55036 | 673 |
1699627 | 1699627 | 2021-09-08 | Waukesha | Wisconsin | 55133 | 54953 | 670 |
1696378 | 1696378 | 2021-09-07 | Waukesha | Wisconsin | 55133 | 54571 | 668 |
1693130 | 1693130 | 2021-09-06 | Waukesha | Wisconsin | 55133 | 54571 | 668 |
1689881 | 1689881 | 2021-09-05 | Waukesha | Wisconsin | 55133 | 54431 | 668 |
1686631 | 1686631 | 2021-09-04 | Waukesha | Wisconsin | 55133 | 54431 | 668 |
1683381 | 1683381 | 2021-09-03 | Waukesha | Wisconsin | 55133 | 54431 | 668 |
1680130 | 1680130 | 2021-09-02 | Waukesha | Wisconsin | 55133 | 54292 | 668 |
1676882 | 1676882 | 2021-09-01 | Waukesha | Wisconsin | 55133 | 54086 | 665 |
1673635 | 1673635 | 2021-08-31 | Waukesha | Wisconsin | 55133 | 53944 | 665 |
1670387 | 1670387 | 2021-08-30 | Waukesha | Wisconsin | 55133 | 53653 | 662 |
1667140 | 1667140 | 2021-08-29 | Waukesha | Wisconsin | 55133 | 53504 | 661 |
1663892 | 1663892 | 2021-08-28 | Waukesha | Wisconsin | 55133 | 53504 | 661 |
1660644 | 1660644 | 2021-08-27 | Waukesha | Wisconsin | 55133 | 53504 | 661 |
1657396 | 1657396 | 2021-08-26 | Waukesha | Wisconsin | 55133 | 53282 | 661 |
1654148 | 1654148 | 2021-08-25 | Waukesha | Wisconsin | 55133 | 53122 | 661 |
1650902 | 1650902 | 2021-08-24 | Waukesha | Wisconsin | 55133 | 53015 | 659 |
1647653 | 1647653 | 2021-08-23 | Waukesha | Wisconsin | 55133 | 52655 | 658 |
1644404 | 1644404 | 2021-08-22 | Waukesha | Wisconsin | 55133 | 52512 | 658 |
1641154 | 1641154 | 2021-08-21 | Waukesha | Wisconsin | 55133 | 52512 | 658 |
1637904 | 1637904 | 2021-08-20 | Waukesha | Wisconsin | 55133 | 52512 | 658 |
1634654 | 1634654 | 2021-08-19 | Waukesha | Wisconsin | 55133 | 52379 | 658 |
1631406 | 1631406 | 2021-08-18 | Waukesha | Wisconsin | 55133 | 52242 | 658 |
1628159 | 1628159 | 2021-08-17 | Waukesha | Wisconsin | 55133 | 52119 | 658 |
1624912 | 1624912 | 2021-08-16 | Waukesha | Wisconsin | 55133 | 51878 | 656 |
1621665 | 1621665 | 2021-08-15 | Waukesha | Wisconsin | 55133 | 51766 | 656 |
1618417 | 1618417 | 2021-08-14 | Waukesha | Wisconsin | 55133 | 51766 | 656 |
1615169 | 1615169 | 2021-08-13 | Waukesha | Wisconsin | 55133 | 51766 | 656 |
1611920 | 1611920 | 2021-08-12 | Waukesha | Wisconsin | 55133 | 51577 | 656 |
1608673 | 1608673 | 2021-08-11 | Waukesha | Wisconsin | 55133 | 51431 | 654 |
1605424 | 1605424 | 2021-08-10 | Waukesha | Wisconsin | 55133 | 51319 | 654 |
1602174 | 1602174 | 2021-08-09 | Waukesha | Wisconsin | 55133 | 51039 | 653 |
1598926 | 1598926 | 2021-08-08 | Waukesha | Wisconsin | 55133 | 50925 | 652 |
1595677 | 1595677 | 2021-08-07 | Waukesha | Wisconsin | 55133 | 50925 | 652 |
1592428 | 1592428 | 2021-08-06 | Waukesha | Wisconsin | 55133 | 50925 | 652 |
1589179 | 1589179 | 2021-08-05 | Waukesha | Wisconsin | 55133 | 50810 | 651 |
1585930 | 1585930 | 2021-08-04 | Waukesha | Wisconsin | 55133 | 50599 | 650 |
1582680 | 1582680 | 2021-08-03 | Waukesha | Wisconsin | 55133 | 50383 | 649 |
1579430 | 1579430 | 2021-08-02 | Waukesha | Wisconsin | 55133 | 50234 | 648 |
1576182 | 1576182 | 2021-08-01 | Waukesha | Wisconsin | 55133 | 50103 | 648 |
1572934 | 1572934 | 2021-07-31 | Waukesha | Wisconsin | 55133 | 50103 | 648 |
1569686 | 1569686 | 2021-07-30 | Waukesha | Wisconsin | 55133 | 50103 | 648 |
1566438 | 1566438 | 2021-07-29 | Waukesha | Wisconsin | 55133 | 49988 | 648 |
1563190 | 1563190 | 2021-07-28 | Waukesha | Wisconsin | 55133 | 49882 | 647 |
1559942 | 1559942 | 2021-07-27 | Waukesha | Wisconsin | 55133 | 49796 | 645 |
1556695 | 1556695 | 2021-07-26 | Waukesha | Wisconsin | 55133 | 49614 | 644 |
1553448 | 1553448 | 2021-07-25 | Waukesha | Wisconsin | 55133 | 49569 | 642 |
1550201 | 1550201 | 2021-07-24 | Waukesha | Wisconsin | 55133 | 49569 | 642 |
1546954 | 1546954 | 2021-07-23 | Waukesha | Wisconsin | 55133 | 49569 | 642 |
1543707 | 1543707 | 2021-07-22 | Waukesha | Wisconsin | 55133 | 49509 | 642 |
1540459 | 1540459 | 2021-07-21 | Waukesha | Wisconsin | 55133 | 49477 | 640 |
1537212 | 1537212 | 2021-07-20 | Waukesha | Wisconsin | 55133 | 49447 | 640 |
1533964 | 1533964 | 2021-07-19 | Waukesha | Wisconsin | 55133 | 49379 | 640 |
1530717 | 1530717 | 2021-07-18 | Waukesha | Wisconsin | 55133 | 49364 | 640 |
1527470 | 1527470 | 2021-07-17 | Waukesha | Wisconsin | 55133 | 49364 | 640 |
1524223 | 1524223 | 2021-07-16 | Waukesha | Wisconsin | 55133 | 49364 | 640 |
1520975 | 1520975 | 2021-07-15 | Waukesha | Wisconsin | 55133 | 49345 | 639 |
1517727 | 1517727 | 2021-07-14 | Waukesha | Wisconsin | 55133 | 49330 | 638 |
1514480 | 1514480 | 2021-07-13 | Waukesha | Wisconsin | 55133 | 49318 | 638 |
1511234 | 1511234 | 2021-07-12 | Waukesha | Wisconsin | 55133 | 49287 | 638 |
1507987 | 1507987 | 2021-07-11 | Waukesha | Wisconsin | 55133 | 49278 | 637 |
1504741 | 1504741 | 2021-07-10 | Waukesha | Wisconsin | 55133 | 49278 | 637 |
1501495 | 1501495 | 2021-07-09 | Waukesha | Wisconsin | 55133 | 49278 | 637 |
1498249 | 1498249 | 2021-07-08 | Waukesha | Wisconsin | 55133 | 49269 | 636 |
1495002 | 1495002 | 2021-07-07 | Waukesha | Wisconsin | 55133 | 49254 | 636 |
1491755 | 1491755 | 2021-07-06 | Waukesha | Wisconsin | 55133 | 49238 | 634 |
1488508 | 1488508 | 2021-07-05 | Waukesha | Wisconsin | 55133 | 49238 | 634 |
1485261 | 1485261 | 2021-07-04 | Waukesha | Wisconsin | 55133 | 49234 | 634 |
1482015 | 1482015 | 2021-07-03 | Waukesha | Wisconsin | 55133 | 49234 | 634 |
1478768 | 1478768 | 2021-07-02 | Waukesha | Wisconsin | 55133 | 49234 | 634 |
1475522 | 1475522 | 2021-07-01 | Waukesha | Wisconsin | 55133 | 49230 | 634 |
1472276 | 1472276 | 2021-06-30 | Waukesha | Wisconsin | 55133 | 49226 | 633 |
1469031 | 1469031 | 2021-06-29 | Waukesha | Wisconsin | 55133 | 49224 | 633 |
1465786 | 1465786 | 2021-06-28 | Waukesha | Wisconsin | 55133 | 49219 | 632 |
1462541 | 1462541 | 2021-06-27 | Waukesha | Wisconsin | 55133 | 49217 | 630 |
1459296 | 1459296 | 2021-06-26 | Waukesha | Wisconsin | 55133 | 49217 | 630 |
1456051 | 1456051 | 2021-06-25 | Waukesha | Wisconsin | 55133 | 49217 | 630 |
1452806 | 1452806 | 2021-06-24 | Waukesha | Wisconsin | 55133 | 49210 | 627 |
1449560 | 1449560 | 2021-06-23 | Waukesha | Wisconsin | 55133 | 49203 | 626 |
1446315 | 1446315 | 2021-06-22 | Waukesha | Wisconsin | 55133 | 49201 | 625 |
1443070 | 1443070 | 2021-06-21 | Waukesha | Wisconsin | 55133 | 49192 | 625 |
1439825 | 1439825 | 2021-06-20 | Waukesha | Wisconsin | 55133 | 49189 | 623 |
1436578 | 1436578 | 2021-06-19 | Waukesha | Wisconsin | 55133 | 49189 | 623 |
1433331 | 1433331 | 2021-06-18 | Waukesha | Wisconsin | 55133 | 49189 | 623 |
1430085 | 1430085 | 2021-06-17 | Waukesha | Wisconsin | 55133 | 49184 | 623 |
1426840 | 1426840 | 2021-06-16 | Waukesha | Wisconsin | 55133 | 49179 | 623 |
1423594 | 1423594 | 2021-06-15 | Waukesha | Wisconsin | 55133 | 49180 | 622 |
1420347 | 1420347 | 2021-06-14 | Waukesha | Wisconsin | 55133 | 49173 | 620 |
1417102 | 1417102 | 2021-06-13 | Waukesha | Wisconsin | 55133 | 49173 | 620 |
1413856 | 1413856 | 2021-06-12 | Waukesha | Wisconsin | 55133 | 49173 | 620 |
1410611 | 1410611 | 2021-06-11 | Waukesha | Wisconsin | 55133 | 49173 | 620 |
1407366 | 1407366 | 2021-06-10 | Waukesha | Wisconsin | 55133 | 49164 | 620 |
1404120 | 1404120 | 2021-06-09 | Waukesha | Wisconsin | 55133 | 49158 | 620 |
1400875 | 1400875 | 2021-06-08 | Waukesha | Wisconsin | 55133 | 49153 | 616 |
1397630 | 1397630 | 2021-06-07 | Waukesha | Wisconsin | 55133 | 49133 | 615 |
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);