ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Douglas" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1839277 | 1839277 | 2021-10-21 | Douglas | Wisconsin | 55031 | 5927 | 66 |
1836028 | 1836028 | 2021-10-20 | Douglas | Wisconsin | 55031 | 5910 | 66 |
1832779 | 1832779 | 2021-10-19 | Douglas | Wisconsin | 55031 | 5883 | 66 |
1829530 | 1829530 | 2021-10-18 | Douglas | Wisconsin | 55031 | 5864 | 66 |
1826281 | 1826281 | 2021-10-17 | Douglas | Wisconsin | 55031 | 5835 | 66 |
1823032 | 1823032 | 2021-10-16 | Douglas | Wisconsin | 55031 | 5794 | 66 |
1819783 | 1819783 | 2021-10-15 | Douglas | Wisconsin | 55031 | 5794 | 66 |
1816534 | 1816534 | 2021-10-14 | Douglas | Wisconsin | 55031 | 5794 | 66 |
1813286 | 1813286 | 2021-10-13 | Douglas | Wisconsin | 55031 | 5766 | 66 |
1810037 | 1810037 | 2021-10-12 | Douglas | Wisconsin | 55031 | 5737 | 66 |
1806788 | 1806788 | 2021-10-11 | Douglas | Wisconsin | 55031 | 5729 | 66 |
1803537 | 1803537 | 2021-10-10 | Douglas | Wisconsin | 55031 | 5698 | 66 |
1800288 | 1800288 | 2021-10-09 | Douglas | Wisconsin | 55031 | 5698 | 66 |
1797039 | 1797039 | 2021-10-08 | Douglas | Wisconsin | 55031 | 5698 | 66 |
1793790 | 1793790 | 2021-10-07 | Douglas | Wisconsin | 55031 | 5664 | 66 |
1790541 | 1790541 | 2021-10-06 | Douglas | Wisconsin | 55031 | 5649 | 66 |
1787293 | 1787293 | 2021-10-05 | Douglas | Wisconsin | 55031 | 5623 | 66 |
1784044 | 1784044 | 2021-10-04 | Douglas | Wisconsin | 55031 | 5605 | 66 |
1780795 | 1780795 | 2021-10-03 | Douglas | Wisconsin | 55031 | 5546 | 66 |
1777545 | 1777545 | 2021-10-02 | Douglas | Wisconsin | 55031 | 5546 | 66 |
1774295 | 1774295 | 2021-10-01 | Douglas | Wisconsin | 55031 | 5546 | 66 |
1771045 | 1771045 | 2021-09-30 | Douglas | Wisconsin | 55031 | 5516 | 66 |
1767796 | 1767796 | 2021-09-29 | Douglas | Wisconsin | 55031 | 5508 | 66 |
1764547 | 1764547 | 2021-09-28 | Douglas | Wisconsin | 55031 | 5493 | 66 |
1761298 | 1761298 | 2021-09-27 | Douglas | Wisconsin | 55031 | 5489 | 66 |
1758050 | 1758050 | 2021-09-26 | Douglas | Wisconsin | 55031 | 5451 | 66 |
1754802 | 1754802 | 2021-09-25 | Douglas | Wisconsin | 55031 | 5451 | 66 |
1751554 | 1751554 | 2021-09-24 | Douglas | Wisconsin | 55031 | 5451 | 66 |
1748305 | 1748305 | 2021-09-23 | Douglas | Wisconsin | 55031 | 5428 | 66 |
1745055 | 1745055 | 2021-09-22 | Douglas | Wisconsin | 55031 | 5415 | 66 |
1741806 | 1741806 | 2021-09-21 | Douglas | Wisconsin | 55031 | 5411 | 66 |
1738557 | 1738557 | 2021-09-20 | Douglas | Wisconsin | 55031 | 5406 | 66 |
1735308 | 1735308 | 2021-09-19 | Douglas | Wisconsin | 55031 | 5364 | 66 |
1732058 | 1732058 | 2021-09-18 | Douglas | Wisconsin | 55031 | 5364 | 66 |
1728808 | 1728808 | 2021-09-17 | Douglas | Wisconsin | 55031 | 5364 | 66 |
1725558 | 1725558 | 2021-09-16 | Douglas | Wisconsin | 55031 | 5344 | 66 |
1722309 | 1722309 | 2021-09-15 | Douglas | Wisconsin | 55031 | 5339 | 66 |
1719061 | 1719061 | 2021-09-14 | Douglas | Wisconsin | 55031 | 5325 | 66 |
1715813 | 1715813 | 2021-09-13 | Douglas | Wisconsin | 55031 | 5314 | 66 |
1712567 | 1712567 | 2021-09-12 | Douglas | Wisconsin | 55031 | 5291 | 66 |
1709320 | 1709320 | 2021-09-11 | Douglas | Wisconsin | 55031 | 5291 | 66 |
1706073 | 1706073 | 2021-09-10 | Douglas | Wisconsin | 55031 | 5291 | 66 |
1702824 | 1702824 | 2021-09-09 | Douglas | Wisconsin | 55031 | 5272 | 66 |
1699574 | 1699574 | 2021-09-08 | Douglas | Wisconsin | 55031 | 5266 | 66 |
1696326 | 1696326 | 2021-09-07 | Douglas | Wisconsin | 55031 | 5256 | 66 |
1693078 | 1693078 | 2021-09-06 | Douglas | Wisconsin | 55031 | 5254 | 66 |
1689829 | 1689829 | 2021-09-05 | Douglas | Wisconsin | 55031 | 5219 | 66 |
1686579 | 1686579 | 2021-09-04 | Douglas | Wisconsin | 55031 | 5219 | 66 |
1683329 | 1683329 | 2021-09-03 | Douglas | Wisconsin | 55031 | 5219 | 66 |
1680078 | 1680078 | 2021-09-02 | Douglas | Wisconsin | 55031 | 5209 | 66 |
1676830 | 1676830 | 2021-09-01 | Douglas | Wisconsin | 55031 | 5203 | 66 |
1673583 | 1673583 | 2021-08-31 | Douglas | Wisconsin | 55031 | 5196 | 66 |
1670335 | 1670335 | 2021-08-30 | Douglas | Wisconsin | 55031 | 5191 | 66 |
1667088 | 1667088 | 2021-08-29 | Douglas | Wisconsin | 55031 | 5175 | 66 |
1663840 | 1663840 | 2021-08-28 | Douglas | Wisconsin | 55031 | 5175 | 66 |
1660592 | 1660592 | 2021-08-27 | Douglas | Wisconsin | 55031 | 5175 | 66 |
1657344 | 1657344 | 2021-08-26 | Douglas | Wisconsin | 55031 | 5166 | 66 |
1654096 | 1654096 | 2021-08-25 | Douglas | Wisconsin | 55031 | 5159 | 66 |
1650850 | 1650850 | 2021-08-24 | Douglas | Wisconsin | 55031 | 5150 | 66 |
1647601 | 1647601 | 2021-08-23 | Douglas | Wisconsin | 55031 | 5145 | 66 |
1644352 | 1644352 | 2021-08-22 | Douglas | Wisconsin | 55031 | 5122 | 66 |
1641102 | 1641102 | 2021-08-21 | Douglas | Wisconsin | 55031 | 5122 | 66 |
1637852 | 1637852 | 2021-08-20 | Douglas | Wisconsin | 55031 | 5122 | 66 |
1634602 | 1634602 | 2021-08-19 | Douglas | Wisconsin | 55031 | 5113 | 66 |
1631354 | 1631354 | 2021-08-18 | Douglas | Wisconsin | 55031 | 5102 | 66 |
1628107 | 1628107 | 2021-08-17 | Douglas | Wisconsin | 55031 | 5098 | 66 |
1624860 | 1624860 | 2021-08-16 | Douglas | Wisconsin | 55031 | 5091 | 66 |
1621613 | 1621613 | 2021-08-15 | Douglas | Wisconsin | 55031 | 5079 | 66 |
1618365 | 1618365 | 2021-08-14 | Douglas | Wisconsin | 55031 | 5079 | 66 |
1615117 | 1615117 | 2021-08-13 | Douglas | Wisconsin | 55031 | 5079 | 66 |
1611868 | 1611868 | 2021-08-12 | Douglas | Wisconsin | 55031 | 5072 | 66 |
1608621 | 1608621 | 2021-08-11 | Douglas | Wisconsin | 55031 | 5066 | 66 |
1605372 | 1605372 | 2021-08-10 | Douglas | Wisconsin | 55031 | 5060 | 66 |
1602122 | 1602122 | 2021-08-09 | Douglas | Wisconsin | 55031 | 5057 | 66 |
1598874 | 1598874 | 2021-08-08 | Douglas | Wisconsin | 55031 | 5050 | 66 |
1595625 | 1595625 | 2021-08-07 | Douglas | Wisconsin | 55031 | 5050 | 66 |
1592376 | 1592376 | 2021-08-06 | Douglas | Wisconsin | 55031 | 5050 | 66 |
1589127 | 1589127 | 2021-08-05 | Douglas | Wisconsin | 55031 | 5050 | 66 |
1585878 | 1585878 | 2021-08-04 | Douglas | Wisconsin | 55031 | 5046 | 66 |
1582628 | 1582628 | 2021-08-03 | Douglas | Wisconsin | 55031 | 5044 | 66 |
1579378 | 1579378 | 2021-08-02 | Douglas | Wisconsin | 55031 | 5042 | 66 |
1576130 | 1576130 | 2021-08-01 | Douglas | Wisconsin | 55031 | 5033 | 66 |
1572882 | 1572882 | 2021-07-31 | Douglas | Wisconsin | 55031 | 5033 | 66 |
1569634 | 1569634 | 2021-07-30 | Douglas | Wisconsin | 55031 | 5033 | 66 |
1566386 | 1566386 | 2021-07-29 | Douglas | Wisconsin | 55031 | 5029 | 66 |
1563138 | 1563138 | 2021-07-28 | Douglas | Wisconsin | 55031 | 5028 | 66 |
1559890 | 1559890 | 2021-07-27 | Douglas | Wisconsin | 55031 | 5026 | 66 |
1556643 | 1556643 | 2021-07-26 | Douglas | Wisconsin | 55031 | 5026 | 66 |
1553396 | 1553396 | 2021-07-25 | Douglas | Wisconsin | 55031 | 5022 | 67 |
1550149 | 1550149 | 2021-07-24 | Douglas | Wisconsin | 55031 | 5022 | 67 |
1546902 | 1546902 | 2021-07-23 | Douglas | Wisconsin | 55031 | 5022 | 67 |
1543655 | 1543655 | 2021-07-22 | Douglas | Wisconsin | 55031 | 5019 | 66 |
1540407 | 1540407 | 2021-07-21 | Douglas | Wisconsin | 55031 | 5018 | 66 |
1537160 | 1537160 | 2021-07-20 | Douglas | Wisconsin | 55031 | 5018 | 66 |
1533912 | 1533912 | 2021-07-19 | Douglas | Wisconsin | 55031 | 5013 | 66 |
1530665 | 1530665 | 2021-07-18 | Douglas | Wisconsin | 55031 | 5012 | 66 |
1527418 | 1527418 | 2021-07-17 | Douglas | Wisconsin | 55031 | 5012 | 66 |
1524171 | 1524171 | 2021-07-16 | Douglas | Wisconsin | 55031 | 5012 | 66 |
1520923 | 1520923 | 2021-07-15 | Douglas | Wisconsin | 55031 | 5011 | 66 |
1517675 | 1517675 | 2021-07-14 | Douglas | Wisconsin | 55031 | 5012 | 66 |
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);