ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Washington" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1719112 | 1719112 | 2021-09-14 | Washington | Wisconsin | 55131 | 19129 | 212 |
1715864 | 1715864 | 2021-09-13 | Washington | Wisconsin | 55131 | 19090 | 211 |
1712618 | 1712618 | 2021-09-12 | Washington | Wisconsin | 55131 | 18850 | 211 |
1709371 | 1709371 | 2021-09-11 | Washington | Wisconsin | 55131 | 18850 | 211 |
1706124 | 1706124 | 2021-09-10 | Washington | Wisconsin | 55131 | 18850 | 211 |
1702876 | 1702876 | 2021-09-09 | Washington | Wisconsin | 55131 | 18815 | 211 |
1699626 | 1699626 | 2021-09-08 | Washington | Wisconsin | 55131 | 18782 | 211 |
1696377 | 1696377 | 2021-09-07 | Washington | Wisconsin | 55131 | 18764 | 209 |
1693129 | 1693129 | 2021-09-06 | Washington | Wisconsin | 55131 | 18710 | 209 |
1689880 | 1689880 | 2021-09-05 | Washington | Wisconsin | 55131 | 18643 | 209 |
1686630 | 1686630 | 2021-09-04 | Washington | Wisconsin | 55131 | 18643 | 209 |
1683380 | 1683380 | 2021-09-03 | Washington | Wisconsin | 55131 | 18643 | 209 |
1680129 | 1680129 | 2021-09-02 | Washington | Wisconsin | 55131 | 18568 | 208 |
1676881 | 1676881 | 2021-09-01 | Washington | Wisconsin | 55131 | 18453 | 208 |
1673634 | 1673634 | 2021-08-31 | Washington | Wisconsin | 55131 | 18407 | 207 |
1670386 | 1670386 | 2021-08-30 | Washington | Wisconsin | 55131 | 18342 | 206 |
1667139 | 1667139 | 2021-08-29 | Washington | Wisconsin | 55131 | 18232 | 206 |
1663891 | 1663891 | 2021-08-28 | Washington | Wisconsin | 55131 | 18232 | 206 |
1660643 | 1660643 | 2021-08-27 | Washington | Wisconsin | 55131 | 18232 | 206 |
1657395 | 1657395 | 2021-08-26 | Washington | Wisconsin | 55131 | 18174 | 206 |
1654147 | 1654147 | 2021-08-25 | Washington | Wisconsin | 55131 | 18091 | 206 |
1650901 | 1650901 | 2021-08-24 | Washington | Wisconsin | 55131 | 18005 | 205 |
1647652 | 1647652 | 2021-08-23 | Washington | Wisconsin | 55131 | 17934 | 205 |
1644403 | 1644403 | 2021-08-22 | Washington | Wisconsin | 55131 | 17866 | 205 |
1641153 | 1641153 | 2021-08-21 | Washington | Wisconsin | 55131 | 17866 | 205 |
1637903 | 1637903 | 2021-08-20 | Washington | Wisconsin | 55131 | 17866 | 205 |
1634653 | 1634653 | 2021-08-19 | Washington | Wisconsin | 55131 | 17835 | 204 |
1631405 | 1631405 | 2021-08-18 | Washington | Wisconsin | 55131 | 17766 | 204 |
1628158 | 1628158 | 2021-08-17 | Washington | Wisconsin | 55131 | 17728 | 204 |
1624911 | 1624911 | 2021-08-16 | Washington | Wisconsin | 55131 | 17665 | 204 |
1621664 | 1621664 | 2021-08-15 | Washington | Wisconsin | 55131 | 17635 | 204 |
1618416 | 1618416 | 2021-08-14 | Washington | Wisconsin | 55131 | 17635 | 204 |
1615168 | 1615168 | 2021-08-13 | Washington | Wisconsin | 55131 | 17635 | 204 |
1611919 | 1611919 | 2021-08-12 | Washington | Wisconsin | 55131 | 17568 | 204 |
1608672 | 1608672 | 2021-08-11 | Washington | Wisconsin | 55131 | 17506 | 204 |
1605423 | 1605423 | 2021-08-10 | Washington | Wisconsin | 55131 | 17430 | 204 |
1602173 | 1602173 | 2021-08-09 | Washington | Wisconsin | 55131 | 17410 | 204 |
1598925 | 1598925 | 2021-08-08 | Washington | Wisconsin | 55131 | 17371 | 204 |
1595676 | 1595676 | 2021-08-07 | Washington | Wisconsin | 55131 | 17371 | 204 |
1592427 | 1592427 | 2021-08-06 | Washington | Wisconsin | 55131 | 17371 | 204 |
1589178 | 1589178 | 2021-08-05 | Washington | Wisconsin | 55131 | 17339 | 204 |
1585929 | 1585929 | 2021-08-04 | Washington | Wisconsin | 55131 | 17266 | 203 |
1582679 | 1582679 | 2021-08-03 | Washington | Wisconsin | 55131 | 17221 | 203 |
1579429 | 1579429 | 2021-08-02 | Washington | Wisconsin | 55131 | 17183 | 203 |
1576181 | 1576181 | 2021-08-01 | Washington | Wisconsin | 55131 | 17150 | 202 |
1572933 | 1572933 | 2021-07-31 | Washington | Wisconsin | 55131 | 17150 | 202 |
1569685 | 1569685 | 2021-07-30 | Washington | Wisconsin | 55131 | 17150 | 202 |
1566437 | 1566437 | 2021-07-29 | Washington | Wisconsin | 55131 | 17129 | 202 |
1563189 | 1563189 | 2021-07-28 | Washington | Wisconsin | 55131 | 17100 | 202 |
1559941 | 1559941 | 2021-07-27 | Washington | Wisconsin | 55131 | 17080 | 201 |
1556694 | 1556694 | 2021-07-26 | Washington | Wisconsin | 55131 | 17052 | 201 |
1553447 | 1553447 | 2021-07-25 | Washington | Wisconsin | 55131 | 17044 | 201 |
1550200 | 1550200 | 2021-07-24 | Washington | Wisconsin | 55131 | 17044 | 201 |
1546953 | 1546953 | 2021-07-23 | Washington | Wisconsin | 55131 | 17044 | 201 |
1543706 | 1543706 | 2021-07-22 | Washington | Wisconsin | 55131 | 17034 | 201 |
1540458 | 1540458 | 2021-07-21 | Washington | Wisconsin | 55131 | 17022 | 201 |
1537211 | 1537211 | 2021-07-20 | Washington | Wisconsin | 55131 | 17010 | 201 |
1533963 | 1533963 | 2021-07-19 | Washington | Wisconsin | 55131 | 16991 | 198 |
1530716 | 1530716 | 2021-07-18 | Washington | Wisconsin | 55131 | 16984 | 197 |
1527469 | 1527469 | 2021-07-17 | Washington | Wisconsin | 55131 | 16984 | 197 |
1524222 | 1524222 | 2021-07-16 | Washington | Wisconsin | 55131 | 16984 | 197 |
1520974 | 1520974 | 2021-07-15 | Washington | Wisconsin | 55131 | 16979 | 195 |
1517726 | 1517726 | 2021-07-14 | Washington | Wisconsin | 55131 | 16968 | 195 |
1514479 | 1514479 | 2021-07-13 | Washington | Wisconsin | 55131 | 16957 | 194 |
1511233 | 1511233 | 2021-07-12 | Washington | Wisconsin | 55131 | 16958 | 194 |
1507986 | 1507986 | 2021-07-11 | Washington | Wisconsin | 55131 | 16952 | 194 |
1504740 | 1504740 | 2021-07-10 | Washington | Wisconsin | 55131 | 16952 | 194 |
1501494 | 1501494 | 2021-07-09 | Washington | Wisconsin | 55131 | 16952 | 194 |
1498248 | 1498248 | 2021-07-08 | Washington | Wisconsin | 55131 | 16947 | 192 |
1495001 | 1495001 | 2021-07-07 | Washington | Wisconsin | 55131 | 16937 | 192 |
1491754 | 1491754 | 2021-07-06 | Washington | Wisconsin | 55131 | 16932 | 191 |
1488507 | 1488507 | 2021-07-05 | Washington | Wisconsin | 55131 | 16932 | 191 |
1485260 | 1485260 | 2021-07-04 | Washington | Wisconsin | 55131 | 16930 | 191 |
1482014 | 1482014 | 2021-07-03 | Washington | Wisconsin | 55131 | 16930 | 191 |
1478767 | 1478767 | 2021-07-02 | Washington | Wisconsin | 55131 | 16930 | 191 |
1475521 | 1475521 | 2021-07-01 | Washington | Wisconsin | 55131 | 16927 | 191 |
1472275 | 1472275 | 2021-06-30 | Washington | Wisconsin | 55131 | 16925 | 190 |
1469030 | 1469030 | 2021-06-29 | Washington | Wisconsin | 55131 | 16924 | 190 |
1465785 | 1465785 | 2021-06-28 | Washington | Wisconsin | 55131 | 16920 | 189 |
1462540 | 1462540 | 2021-06-27 | Washington | Wisconsin | 55131 | 16917 | 189 |
1459295 | 1459295 | 2021-06-26 | Washington | Wisconsin | 55131 | 16917 | 189 |
1456050 | 1456050 | 2021-06-25 | Washington | Wisconsin | 55131 | 16917 | 189 |
1452805 | 1452805 | 2021-06-24 | Washington | Wisconsin | 55131 | 16916 | 189 |
1449559 | 1449559 | 2021-06-23 | Washington | Wisconsin | 55131 | 16916 | 188 |
1446314 | 1446314 | 2021-06-22 | Washington | Wisconsin | 55131 | 16916 | 188 |
1443069 | 1443069 | 2021-06-21 | Washington | Wisconsin | 55131 | 16915 | 188 |
1439824 | 1439824 | 2021-06-20 | Washington | Wisconsin | 55131 | 16916 | 187 |
1436577 | 1436577 | 2021-06-19 | Washington | Wisconsin | 55131 | 16916 | 187 |
1433330 | 1433330 | 2021-06-18 | Washington | Wisconsin | 55131 | 16916 | 187 |
1430084 | 1430084 | 2021-06-17 | Washington | Wisconsin | 55131 | 16913 | 186 |
1426839 | 1426839 | 2021-06-16 | Washington | Wisconsin | 55131 | 16911 | 186 |
1423593 | 1423593 | 2021-06-15 | Washington | Wisconsin | 55131 | 16911 | 185 |
1420346 | 1420346 | 2021-06-14 | Washington | Wisconsin | 55131 | 16905 | 185 |
1417101 | 1417101 | 2021-06-13 | Washington | Wisconsin | 55131 | 16903 | 185 |
1413855 | 1413855 | 2021-06-12 | Washington | Wisconsin | 55131 | 16903 | 185 |
1410610 | 1410610 | 2021-06-11 | Washington | Wisconsin | 55131 | 16903 | 185 |
1407365 | 1407365 | 2021-06-10 | Washington | Wisconsin | 55131 | 16902 | 184 |
1404119 | 1404119 | 2021-06-09 | Washington | Wisconsin | 55131 | 16895 | 184 |
1400874 | 1400874 | 2021-06-08 | Washington | Wisconsin | 55131 | 16892 | 183 |
1397629 | 1397629 | 2021-06-07 | Washington | Wisconsin | 55131 | 16886 | 183 |
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);