ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Pierce" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1842558 | 1842558 | 2021-10-22 | Pierce | Wisconsin | 55093 | 6263 | 46 |
1839309 | 1839309 | 2021-10-21 | Pierce | Wisconsin | 55093 | 6243 | 46 |
1836060 | 1836060 | 2021-10-20 | Pierce | Wisconsin | 55093 | 6214 | 45 |
1832811 | 1832811 | 2021-10-19 | Pierce | Wisconsin | 55093 | 6202 | 45 |
1829562 | 1829562 | 2021-10-18 | Pierce | Wisconsin | 55093 | 6188 | 45 |
1826313 | 1826313 | 2021-10-17 | Pierce | Wisconsin | 55093 | 6163 | 45 |
1823064 | 1823064 | 2021-10-16 | Pierce | Wisconsin | 55093 | 6119 | 45 |
1819815 | 1819815 | 2021-10-15 | Pierce | Wisconsin | 55093 | 6119 | 45 |
1816566 | 1816566 | 2021-10-14 | Pierce | Wisconsin | 55093 | 6119 | 45 |
1813318 | 1813318 | 2021-10-13 | Pierce | Wisconsin | 55093 | 6094 | 45 |
1810069 | 1810069 | 2021-10-12 | Pierce | Wisconsin | 55093 | 6081 | 45 |
1806820 | 1806820 | 2021-10-11 | Pierce | Wisconsin | 55093 | 6056 | 45 |
1803569 | 1803569 | 2021-10-10 | Pierce | Wisconsin | 55093 | 5996 | 44 |
1800320 | 1800320 | 2021-10-09 | Pierce | Wisconsin | 55093 | 5996 | 44 |
1797071 | 1797071 | 2021-10-08 | Pierce | Wisconsin | 55093 | 5996 | 44 |
1793822 | 1793822 | 2021-10-07 | Pierce | Wisconsin | 55093 | 5974 | 44 |
1790573 | 1790573 | 2021-10-06 | Pierce | Wisconsin | 55093 | 5939 | 44 |
1787325 | 1787325 | 2021-10-05 | Pierce | Wisconsin | 55093 | 5934 | 44 |
1784076 | 1784076 | 2021-10-04 | Pierce | Wisconsin | 55093 | 5911 | 44 |
1780827 | 1780827 | 2021-10-03 | Pierce | Wisconsin | 55093 | 5828 | 44 |
1777577 | 1777577 | 2021-10-02 | Pierce | Wisconsin | 55093 | 5828 | 44 |
1774327 | 1774327 | 2021-10-01 | Pierce | Wisconsin | 55093 | 5828 | 44 |
1771077 | 1771077 | 2021-09-30 | Pierce | Wisconsin | 55093 | 5792 | 44 |
1767828 | 1767828 | 2021-09-29 | Pierce | Wisconsin | 55093 | 5763 | 44 |
1764579 | 1764579 | 2021-09-28 | Pierce | Wisconsin | 55093 | 5737 | 44 |
1761330 | 1761330 | 2021-09-27 | Pierce | Wisconsin | 55093 | 5718 | 44 |
1758082 | 1758082 | 2021-09-26 | Pierce | Wisconsin | 55093 | 5672 | 44 |
1754834 | 1754834 | 2021-09-25 | Pierce | Wisconsin | 55093 | 5672 | 44 |
1751586 | 1751586 | 2021-09-24 | Pierce | Wisconsin | 55093 | 5672 | 44 |
1748337 | 1748337 | 2021-09-23 | Pierce | Wisconsin | 55093 | 5656 | 44 |
1745087 | 1745087 | 2021-09-22 | Pierce | Wisconsin | 55093 | 5628 | 44 |
1741838 | 1741838 | 2021-09-21 | Pierce | Wisconsin | 55093 | 5607 | 44 |
1738589 | 1738589 | 2021-09-20 | Pierce | Wisconsin | 55093 | 5586 | 44 |
1735340 | 1735340 | 2021-09-19 | Pierce | Wisconsin | 55093 | 5526 | 44 |
1732090 | 1732090 | 2021-09-18 | Pierce | Wisconsin | 55093 | 5526 | 44 |
1728840 | 1728840 | 2021-09-17 | Pierce | Wisconsin | 55093 | 5526 | 44 |
1725590 | 1725590 | 2021-09-16 | Pierce | Wisconsin | 55093 | 5509 | 44 |
1722341 | 1722341 | 2021-09-15 | Pierce | Wisconsin | 55093 | 5474 | 44 |
1719093 | 1719093 | 2021-09-14 | Pierce | Wisconsin | 55093 | 5453 | 44 |
1715845 | 1715845 | 2021-09-13 | Pierce | Wisconsin | 55093 | 5429 | 44 |
1712599 | 1712599 | 2021-09-12 | Pierce | Wisconsin | 55093 | 5393 | 44 |
1709352 | 1709352 | 2021-09-11 | Pierce | Wisconsin | 55093 | 5393 | 44 |
1706105 | 1706105 | 2021-09-10 | Pierce | Wisconsin | 55093 | 5393 | 44 |
1702856 | 1702856 | 2021-09-09 | Pierce | Wisconsin | 55093 | 5380 | 44 |
1699606 | 1699606 | 2021-09-08 | Pierce | Wisconsin | 55093 | 5363 | 44 |
1696358 | 1696358 | 2021-09-07 | Pierce | Wisconsin | 55093 | 5356 | 44 |
1693110 | 1693110 | 2021-09-06 | Pierce | Wisconsin | 55093 | 5350 | 44 |
1689861 | 1689861 | 2021-09-05 | Pierce | Wisconsin | 55093 | 5311 | 44 |
1686611 | 1686611 | 2021-09-04 | Pierce | Wisconsin | 55093 | 5311 | 44 |
1683361 | 1683361 | 2021-09-03 | Pierce | Wisconsin | 55093 | 5311 | 44 |
1680110 | 1680110 | 2021-09-02 | Pierce | Wisconsin | 55093 | 5285 | 44 |
1676862 | 1676862 | 2021-09-01 | Pierce | Wisconsin | 55093 | 5262 | 44 |
1673615 | 1673615 | 2021-08-31 | Pierce | Wisconsin | 55093 | 5238 | 44 |
1670367 | 1670367 | 2021-08-30 | Pierce | Wisconsin | 55093 | 5225 | 44 |
1667120 | 1667120 | 2021-08-29 | Pierce | Wisconsin | 55093 | 5201 | 44 |
1663872 | 1663872 | 2021-08-28 | Pierce | Wisconsin | 55093 | 5201 | 44 |
1660624 | 1660624 | 2021-08-27 | Pierce | Wisconsin | 55093 | 5201 | 44 |
1657376 | 1657376 | 2021-08-26 | Pierce | Wisconsin | 55093 | 5185 | 44 |
1654128 | 1654128 | 2021-08-25 | Pierce | Wisconsin | 55093 | 5158 | 44 |
1650882 | 1650882 | 2021-08-24 | Pierce | Wisconsin | 55093 | 5144 | 44 |
1647633 | 1647633 | 2021-08-23 | Pierce | Wisconsin | 55093 | 5134 | 44 |
1644384 | 1644384 | 2021-08-22 | Pierce | Wisconsin | 55093 | 5124 | 44 |
1641134 | 1641134 | 2021-08-21 | Pierce | Wisconsin | 55093 | 5124 | 44 |
1637884 | 1637884 | 2021-08-20 | Pierce | Wisconsin | 55093 | 5124 | 44 |
1634634 | 1634634 | 2021-08-19 | Pierce | Wisconsin | 55093 | 5121 | 44 |
1631386 | 1631386 | 2021-08-18 | Pierce | Wisconsin | 55093 | 5113 | 44 |
1628139 | 1628139 | 2021-08-17 | Pierce | Wisconsin | 55093 | 5106 | 44 |
1624892 | 1624892 | 2021-08-16 | Pierce | Wisconsin | 55093 | 5103 | 44 |
1621645 | 1621645 | 2021-08-15 | Pierce | Wisconsin | 55093 | 5086 | 44 |
1618397 | 1618397 | 2021-08-14 | Pierce | Wisconsin | 55093 | 5086 | 44 |
1615149 | 1615149 | 2021-08-13 | Pierce | Wisconsin | 55093 | 5086 | 44 |
1611900 | 1611900 | 2021-08-12 | Pierce | Wisconsin | 55093 | 5084 | 44 |
1608653 | 1608653 | 2021-08-11 | Pierce | Wisconsin | 55093 | 5077 | 44 |
1605404 | 1605404 | 2021-08-10 | Pierce | Wisconsin | 55093 | 5069 | 44 |
1602154 | 1602154 | 2021-08-09 | Pierce | Wisconsin | 55093 | 5063 | 44 |
1598906 | 1598906 | 2021-08-08 | Pierce | Wisconsin | 55093 | 5051 | 44 |
1595657 | 1595657 | 2021-08-07 | Pierce | Wisconsin | 55093 | 5051 | 44 |
1592408 | 1592408 | 2021-08-06 | Pierce | Wisconsin | 55093 | 5051 | 44 |
1589159 | 1589159 | 2021-08-05 | Pierce | Wisconsin | 55093 | 5047 | 44 |
1585910 | 1585910 | 2021-08-04 | Pierce | Wisconsin | 55093 | 5041 | 44 |
1582660 | 1582660 | 2021-08-03 | Pierce | Wisconsin | 55093 | 5036 | 44 |
1579410 | 1579410 | 2021-08-02 | Pierce | Wisconsin | 55093 | 5034 | 44 |
1576162 | 1576162 | 2021-08-01 | Pierce | Wisconsin | 55093 | 5029 | 44 |
1572914 | 1572914 | 2021-07-31 | Pierce | Wisconsin | 55093 | 5029 | 44 |
1569666 | 1569666 | 2021-07-30 | Pierce | Wisconsin | 55093 | 5029 | 44 |
1566418 | 1566418 | 2021-07-29 | Pierce | Wisconsin | 55093 | 5026 | 44 |
1563170 | 1563170 | 2021-07-28 | Pierce | Wisconsin | 55093 | 5023 | 44 |
1559922 | 1559922 | 2021-07-27 | Pierce | Wisconsin | 55093 | 5023 | 44 |
1556675 | 1556675 | 2021-07-26 | Pierce | Wisconsin | 55093 | 5021 | 44 |
1553428 | 1553428 | 2021-07-25 | Pierce | Wisconsin | 55093 | 5016 | 44 |
1550181 | 1550181 | 2021-07-24 | Pierce | Wisconsin | 55093 | 5016 | 44 |
1546934 | 1546934 | 2021-07-23 | Pierce | Wisconsin | 55093 | 5016 | 44 |
1543687 | 1543687 | 2021-07-22 | Pierce | Wisconsin | 55093 | 5014 | 44 |
1540439 | 1540439 | 2021-07-21 | Pierce | Wisconsin | 55093 | 5011 | 44 |
1537192 | 1537192 | 2021-07-20 | Pierce | Wisconsin | 55093 | 5008 | 44 |
1533944 | 1533944 | 2021-07-19 | Pierce | Wisconsin | 55093 | 5007 | 44 |
1530697 | 1530697 | 2021-07-18 | Pierce | Wisconsin | 55093 | 5006 | 44 |
1527450 | 1527450 | 2021-07-17 | Pierce | Wisconsin | 55093 | 5006 | 44 |
1524203 | 1524203 | 2021-07-16 | Pierce | Wisconsin | 55093 | 5006 | 44 |
1520955 | 1520955 | 2021-07-15 | Pierce | Wisconsin | 55093 | 5006 | 44 |
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);