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 |
---|---|---|---|---|---|---|---|
1852328 | 1852328 | 2021-10-25 | Waukesha | Wisconsin | 55133 | 62262 | 719 |
1849078 | 1849078 | 2021-10-24 | Waukesha | Wisconsin | 55133 | 62105 | 718 |
1845828 | 1845828 | 2021-10-23 | Waukesha | Wisconsin | 55133 | 62105 | 718 |
1842578 | 1842578 | 2021-10-22 | Waukesha | Wisconsin | 55133 | 62105 | 718 |
1839329 | 1839329 | 2021-10-21 | Waukesha | Wisconsin | 55133 | 61985 | 716 |
1836080 | 1836080 | 2021-10-20 | Waukesha | Wisconsin | 55133 | 61868 | 715 |
1832831 | 1832831 | 2021-10-19 | Waukesha | Wisconsin | 55133 | 61728 | 712 |
1829582 | 1829582 | 2021-10-18 | Waukesha | Wisconsin | 55133 | 61499 | 710 |
1826333 | 1826333 | 2021-10-17 | Waukesha | Wisconsin | 55133 | 61445 | 710 |
1823084 | 1823084 | 2021-10-16 | Waukesha | Wisconsin | 55133 | 61140 | 708 |
1819835 | 1819835 | 2021-10-15 | Waukesha | Wisconsin | 55133 | 61140 | 708 |
1816586 | 1816586 | 2021-10-14 | Waukesha | Wisconsin | 55133 | 61140 | 708 |
1813338 | 1813338 | 2021-10-13 | Waukesha | Wisconsin | 55133 | 60947 | 706 |
1810089 | 1810089 | 2021-10-12 | Waukesha | Wisconsin | 55133 | 60789 | 704 |
1806840 | 1806840 | 2021-10-11 | Waukesha | Wisconsin | 55133 | 60447 | 703 |
1803589 | 1803589 | 2021-10-10 | Waukesha | Wisconsin | 55133 | 60225 | 702 |
1800340 | 1800340 | 2021-10-09 | Waukesha | Wisconsin | 55133 | 60225 | 702 |
1797091 | 1797091 | 2021-10-08 | Waukesha | Wisconsin | 55133 | 60225 | 702 |
1793842 | 1793842 | 2021-10-07 | Waukesha | Wisconsin | 55133 | 60014 | 699 |
1790593 | 1790593 | 2021-10-06 | Waukesha | Wisconsin | 55133 | 59839 | 695 |
1787345 | 1787345 | 2021-10-05 | Waukesha | Wisconsin | 55133 | 59609 | 695 |
1784096 | 1784096 | 2021-10-04 | Waukesha | Wisconsin | 55133 | 59151 | 692 |
1780847 | 1780847 | 2021-10-03 | Waukesha | Wisconsin | 55133 | 58989 | 688 |
1777597 | 1777597 | 2021-10-02 | Waukesha | Wisconsin | 55133 | 58989 | 688 |
1774347 | 1774347 | 2021-10-01 | Waukesha | Wisconsin | 55133 | 58989 | 688 |
1771097 | 1771097 | 2021-09-30 | Waukesha | Wisconsin | 55133 | 58742 | 687 |
1767848 | 1767848 | 2021-09-29 | Waukesha | Wisconsin | 55133 | 58565 | 687 |
1764599 | 1764599 | 2021-09-28 | Waukesha | Wisconsin | 55133 | 58301 | 686 |
1761350 | 1761350 | 2021-09-27 | Waukesha | Wisconsin | 55133 | 57965 | 686 |
1758102 | 1758102 | 2021-09-26 | Waukesha | Wisconsin | 55133 | 57712 | 685 |
1754854 | 1754854 | 2021-09-25 | Waukesha | Wisconsin | 55133 | 57712 | 685 |
1751606 | 1751606 | 2021-09-24 | Waukesha | Wisconsin | 55133 | 57712 | 685 |
1748357 | 1748357 | 2021-09-23 | Waukesha | Wisconsin | 55133 | 57526 | 685 |
1745107 | 1745107 | 2021-09-22 | Waukesha | Wisconsin | 55133 | 57377 | 685 |
1741858 | 1741858 | 2021-09-21 | Waukesha | Wisconsin | 55133 | 57045 | 685 |
1738609 | 1738609 | 2021-09-20 | Waukesha | Wisconsin | 55133 | 56667 | 685 |
1735360 | 1735360 | 2021-09-19 | Waukesha | Wisconsin | 55133 | 56357 | 685 |
1732110 | 1732110 | 2021-09-18 | Waukesha | Wisconsin | 55133 | 56357 | 685 |
1728860 | 1728860 | 2021-09-17 | Waukesha | Wisconsin | 55133 | 56357 | 685 |
1725610 | 1725610 | 2021-09-16 | Waukesha | Wisconsin | 55133 | 56145 | 680 |
1722361 | 1722361 | 2021-09-15 | Waukesha | Wisconsin | 55133 | 55855 | 679 |
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 |
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);