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 |
---|---|---|---|---|---|---|---|
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 |
1517707 | 1517707 | 2021-07-14 | Pierce | Wisconsin | 55093 | 5005 | 44 |
1514460 | 1514460 | 2021-07-13 | Pierce | Wisconsin | 55093 | 5005 | 44 |
1511214 | 1511214 | 2021-07-12 | Pierce | Wisconsin | 55093 | 5004 | 44 |
1507967 | 1507967 | 2021-07-11 | Pierce | Wisconsin | 55093 | 5000 | 44 |
1504721 | 1504721 | 2021-07-10 | Pierce | Wisconsin | 55093 | 5000 | 44 |
1501475 | 1501475 | 2021-07-09 | Pierce | Wisconsin | 55093 | 5000 | 44 |
1498229 | 1498229 | 2021-07-08 | Pierce | Wisconsin | 55093 | 4999 | 44 |
1494982 | 1494982 | 2021-07-07 | Pierce | Wisconsin | 55093 | 4999 | 44 |
1491735 | 1491735 | 2021-07-06 | Pierce | Wisconsin | 55093 | 4999 | 43 |
1488488 | 1488488 | 2021-07-05 | Pierce | Wisconsin | 55093 | 4999 | 43 |
1485241 | 1485241 | 2021-07-04 | Pierce | Wisconsin | 55093 | 4997 | 43 |
1481995 | 1481995 | 2021-07-03 | Pierce | Wisconsin | 55093 | 4997 | 43 |
1478748 | 1478748 | 2021-07-02 | Pierce | Wisconsin | 55093 | 4997 | 43 |
1475502 | 1475502 | 2021-07-01 | Pierce | Wisconsin | 55093 | 4997 | 43 |
1472256 | 1472256 | 2021-06-30 | Pierce | Wisconsin | 55093 | 4996 | 43 |
1469011 | 1469011 | 2021-06-29 | Pierce | Wisconsin | 55093 | 4996 | 43 |
1465766 | 1465766 | 2021-06-28 | Pierce | Wisconsin | 55093 | 4996 | 43 |
1462521 | 1462521 | 2021-06-27 | Pierce | Wisconsin | 55093 | 4997 | 43 |
1459276 | 1459276 | 2021-06-26 | Pierce | Wisconsin | 55093 | 4997 | 43 |
1456031 | 1456031 | 2021-06-25 | Pierce | Wisconsin | 55093 | 4997 | 43 |
1452786 | 1452786 | 2021-06-24 | Pierce | Wisconsin | 55093 | 4995 | 43 |
1449540 | 1449540 | 2021-06-23 | Pierce | Wisconsin | 55093 | 4995 | 43 |
1446295 | 1446295 | 2021-06-22 | Pierce | Wisconsin | 55093 | 4995 | 43 |
1443050 | 1443050 | 2021-06-21 | Pierce | Wisconsin | 55093 | 4994 | 43 |
1439805 | 1439805 | 2021-06-20 | Pierce | Wisconsin | 55093 | 4992 | 43 |
1436558 | 1436558 | 2021-06-19 | Pierce | Wisconsin | 55093 | 4992 | 43 |
1433311 | 1433311 | 2021-06-18 | Pierce | Wisconsin | 55093 | 4992 | 43 |
1430065 | 1430065 | 2021-06-17 | Pierce | Wisconsin | 55093 | 4989 | 43 |
1426820 | 1426820 | 2021-06-16 | Pierce | Wisconsin | 55093 | 4989 | 43 |
1423574 | 1423574 | 2021-06-15 | Pierce | Wisconsin | 55093 | 4988 | 43 |
1420327 | 1420327 | 2021-06-14 | Pierce | Wisconsin | 55093 | 4988 | 43 |
1417082 | 1417082 | 2021-06-13 | Pierce | Wisconsin | 55093 | 4988 | 43 |
1413836 | 1413836 | 2021-06-12 | Pierce | Wisconsin | 55093 | 4988 | 43 |
1410591 | 1410591 | 2021-06-11 | Pierce | Wisconsin | 55093 | 4988 | 43 |
1407346 | 1407346 | 2021-06-10 | Pierce | Wisconsin | 55093 | 4988 | 43 |
1404100 | 1404100 | 2021-06-09 | Pierce | Wisconsin | 55093 | 4985 | 43 |
1400855 | 1400855 | 2021-06-08 | Pierce | Wisconsin | 55093 | 4982 | 43 |
1397610 | 1397610 | 2021-06-07 | Pierce | Wisconsin | 55093 | 4982 | 43 |
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);