ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 55031 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1514428 | 1514428 | 2021-07-13 | Douglas | Wisconsin | 55031 | 5011 | 66 |
1511182 | 1511182 | 2021-07-12 | Douglas | Wisconsin | 55031 | 5011 | 66 |
1507935 | 1507935 | 2021-07-11 | Douglas | Wisconsin | 55031 | 5011 | 66 |
1504689 | 1504689 | 2021-07-10 | Douglas | Wisconsin | 55031 | 5011 | 66 |
1501443 | 1501443 | 2021-07-09 | Douglas | Wisconsin | 55031 | 5011 | 66 |
1498197 | 1498197 | 2021-07-08 | Douglas | Wisconsin | 55031 | 5010 | 65 |
1494950 | 1494950 | 2021-07-07 | Douglas | Wisconsin | 55031 | 5010 | 65 |
1491703 | 1491703 | 2021-07-06 | Douglas | Wisconsin | 55031 | 5010 | 64 |
1488456 | 1488456 | 2021-07-05 | Douglas | Wisconsin | 55031 | 5009 | 64 |
1485209 | 1485209 | 2021-07-04 | Douglas | Wisconsin | 55031 | 5008 | 64 |
1481963 | 1481963 | 2021-07-03 | Douglas | Wisconsin | 55031 | 5008 | 64 |
1478716 | 1478716 | 2021-07-02 | Douglas | Wisconsin | 55031 | 5008 | 64 |
1475470 | 1475470 | 2021-07-01 | Douglas | Wisconsin | 55031 | 5008 | 64 |
1472224 | 1472224 | 2021-06-30 | Douglas | Wisconsin | 55031 | 5005 | 64 |
1468979 | 1468979 | 2021-06-29 | Douglas | Wisconsin | 55031 | 5005 | 64 |
1465734 | 1465734 | 2021-06-28 | Douglas | Wisconsin | 55031 | 5005 | 63 |
1462489 | 1462489 | 2021-06-27 | Douglas | Wisconsin | 55031 | 5002 | 63 |
1459244 | 1459244 | 2021-06-26 | Douglas | Wisconsin | 55031 | 5002 | 63 |
1455999 | 1455999 | 2021-06-25 | Douglas | Wisconsin | 55031 | 5002 | 63 |
1452754 | 1452754 | 2021-06-24 | Douglas | Wisconsin | 55031 | 5002 | 63 |
1449508 | 1449508 | 2021-06-23 | Douglas | Wisconsin | 55031 | 5002 | 63 |
1446263 | 1446263 | 2021-06-22 | Douglas | Wisconsin | 55031 | 5002 | 63 |
1443018 | 1443018 | 2021-06-21 | Douglas | Wisconsin | 55031 | 5002 | 63 |
1439773 | 1439773 | 2021-06-20 | Douglas | Wisconsin | 55031 | 5000 | 63 |
1436526 | 1436526 | 2021-06-19 | Douglas | Wisconsin | 55031 | 5000 | 63 |
1433279 | 1433279 | 2021-06-18 | Douglas | Wisconsin | 55031 | 5000 | 63 |
1430033 | 1430033 | 2021-06-17 | Douglas | Wisconsin | 55031 | 4998 | 63 |
1426788 | 1426788 | 2021-06-16 | Douglas | Wisconsin | 55031 | 4997 | 63 |
1423542 | 1423542 | 2021-06-15 | Douglas | Wisconsin | 55031 | 4998 | 63 |
1420295 | 1420295 | 2021-06-14 | Douglas | Wisconsin | 55031 | 4996 | 63 |
1417050 | 1417050 | 2021-06-13 | Douglas | Wisconsin | 55031 | 4992 | 63 |
1413804 | 1413804 | 2021-06-12 | Douglas | Wisconsin | 55031 | 4992 | 63 |
1410559 | 1410559 | 2021-06-11 | Douglas | Wisconsin | 55031 | 4992 | 63 |
1407314 | 1407314 | 2021-06-10 | Douglas | Wisconsin | 55031 | 4991 | 63 |
1404068 | 1404068 | 2021-06-09 | Douglas | Wisconsin | 55031 | 4990 | 63 |
1400823 | 1400823 | 2021-06-08 | Douglas | Wisconsin | 55031 | 4989 | 61 |
1397578 | 1397578 | 2021-06-07 | Douglas | Wisconsin | 55031 | 4987 | 61 |
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);