ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where county = "Sawyer" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420336 | 1420336 | 2021-06-14 | Sawyer | Wisconsin | 55113 | 1848 | 28 |
1417091 | 1417091 | 2021-06-13 | Sawyer | Wisconsin | 55113 | 1846 | 28 |
1413845 | 1413845 | 2021-06-12 | Sawyer | Wisconsin | 55113 | 1846 | 28 |
1410600 | 1410600 | 2021-06-11 | Sawyer | Wisconsin | 55113 | 1846 | 28 |
1407355 | 1407355 | 2021-06-10 | Sawyer | Wisconsin | 55113 | 1845 | 28 |
1404109 | 1404109 | 2021-06-09 | Sawyer | Wisconsin | 55113 | 1845 | 28 |
1400864 | 1400864 | 2021-06-08 | Sawyer | Wisconsin | 55113 | 1844 | 28 |
1397619 | 1397619 | 2021-06-07 | Sawyer | Wisconsin | 55113 | 1845 | 28 |
1394372 | 1394372 | 2021-06-06 | Sawyer | Wisconsin | 55113 | 1836 | 28 |
1391127 | 1391127 | 2021-06-05 | Sawyer | Wisconsin | 55113 | 1836 | 28 |
1387882 | 1387882 | 2021-06-04 | Sawyer | Wisconsin | 55113 | 1836 | 28 |
1384637 | 1384637 | 2021-06-03 | Sawyer | Wisconsin | 55113 | 1834 | 28 |
1381391 | 1381391 | 2021-06-02 | Sawyer | Wisconsin | 55113 | 1834 | 28 |
1378146 | 1378146 | 2021-06-01 | Sawyer | Wisconsin | 55113 | 1832 | 28 |
1374900 | 1374900 | 2021-05-31 | Sawyer | Wisconsin | 55113 | 1832 | 28 |
1371655 | 1371655 | 2021-05-30 | Sawyer | Wisconsin | 55113 | 1827 | 28 |
1368409 | 1368409 | 2021-05-29 | Sawyer | Wisconsin | 55113 | 1827 | 28 |
1365163 | 1365163 | 2021-05-28 | Sawyer | Wisconsin | 55113 | 1827 | 28 |
1361917 | 1361917 | 2021-05-27 | Sawyer | Wisconsin | 55113 | 1824 | 28 |
1358671 | 1358671 | 2021-05-26 | Sawyer | Wisconsin | 55113 | 1822 | 28 |
1355425 | 1355425 | 2021-05-25 | Sawyer | Wisconsin | 55113 | 1817 | 28 |
1352179 | 1352179 | 2021-05-24 | Sawyer | Wisconsin | 55113 | 1814 | 28 |
1348933 | 1348933 | 2021-05-23 | Sawyer | Wisconsin | 55113 | 1814 | 28 |
1345685 | 1345685 | 2021-05-22 | Sawyer | Wisconsin | 55113 | 1814 | 28 |
1342437 | 1342437 | 2021-05-21 | Sawyer | Wisconsin | 55113 | 1807 | 28 |
1339189 | 1339189 | 2021-05-20 | Sawyer | Wisconsin | 55113 | 1798 | 27 |
1335942 | 1335942 | 2021-05-19 | Sawyer | Wisconsin | 55113 | 1796 | 27 |
1332695 | 1332695 | 2021-05-18 | Sawyer | Wisconsin | 55113 | 1794 | 27 |
1329448 | 1329448 | 2021-05-17 | Sawyer | Wisconsin | 55113 | 1792 | 27 |
1326202 | 1326202 | 2021-05-16 | Sawyer | Wisconsin | 55113 | 1790 | 27 |
1322956 | 1322956 | 2021-05-15 | Sawyer | Wisconsin | 55113 | 1790 | 27 |
1319710 | 1319710 | 2021-05-14 | Sawyer | Wisconsin | 55113 | 1780 | 27 |
1316462 | 1316462 | 2021-05-13 | Sawyer | Wisconsin | 55113 | 1758 | 27 |
1313216 | 1313216 | 2021-05-12 | Sawyer | Wisconsin | 55113 | 1756 | 27 |
1309969 | 1309969 | 2021-05-11 | Sawyer | Wisconsin | 55113 | 1747 | 26 |
1306723 | 1306723 | 2021-05-10 | Sawyer | Wisconsin | 55113 | 1742 | 26 |
1303477 | 1303477 | 2021-05-09 | Sawyer | Wisconsin | 55113 | 1742 | 26 |
1300230 | 1300230 | 2021-05-08 | Sawyer | Wisconsin | 55113 | 1740 | 26 |
1296983 | 1296983 | 2021-05-07 | Sawyer | Wisconsin | 55113 | 1734 | 26 |
1293737 | 1293737 | 2021-05-06 | Sawyer | Wisconsin | 55113 | 1724 | 26 |
1290491 | 1290491 | 2021-05-05 | Sawyer | Wisconsin | 55113 | 1720 | 26 |
1287245 | 1287245 | 2021-05-04 | Sawyer | Wisconsin | 55113 | 1720 | 26 |
1283999 | 1283999 | 2021-05-03 | Sawyer | Wisconsin | 55113 | 1716 | 26 |
1280752 | 1280752 | 2021-05-02 | Sawyer | Wisconsin | 55113 | 1715 | 26 |
1277505 | 1277505 | 2021-05-01 | Sawyer | Wisconsin | 55113 | 1712 | 26 |
1274258 | 1274258 | 2021-04-30 | Sawyer | Wisconsin | 55113 | 1709 | 26 |
1271011 | 1271011 | 2021-04-29 | Sawyer | Wisconsin | 55113 | 1706 | 26 |
1267764 | 1267764 | 2021-04-28 | Sawyer | Wisconsin | 55113 | 1701 | 25 |
1264517 | 1264517 | 2021-04-27 | Sawyer | Wisconsin | 55113 | 1697 | 25 |
1261270 | 1261270 | 2021-04-26 | Sawyer | Wisconsin | 55113 | 1687 | 25 |
1258023 | 1258023 | 2021-04-25 | Sawyer | Wisconsin | 55113 | 1685 | 25 |
1254776 | 1254776 | 2021-04-24 | Sawyer | Wisconsin | 55113 | 1681 | 25 |
1251529 | 1251529 | 2021-04-23 | Sawyer | Wisconsin | 55113 | 1678 | 25 |
1248282 | 1248282 | 2021-04-22 | Sawyer | Wisconsin | 55113 | 1663 | 25 |
1245035 | 1245035 | 2021-04-21 | Sawyer | Wisconsin | 55113 | 1658 | 25 |
1241788 | 1241788 | 2021-04-20 | Sawyer | Wisconsin | 55113 | 1650 | 26 |
1238541 | 1238541 | 2021-04-19 | Sawyer | Wisconsin | 55113 | 1644 | 25 |
1235294 | 1235294 | 2021-04-18 | Sawyer | Wisconsin | 55113 | 1644 | 25 |
1232046 | 1232046 | 2021-04-17 | Sawyer | Wisconsin | 55113 | 1641 | 26 |
1228798 | 1228798 | 2021-04-16 | Sawyer | Wisconsin | 55113 | 1638 | 25 |
1225550 | 1225550 | 2021-04-15 | Sawyer | Wisconsin | 55113 | 1634 | 25 |
1222303 | 1222303 | 2021-04-14 | Sawyer | Wisconsin | 55113 | 1633 | 25 |
1219055 | 1219055 | 2021-04-13 | Sawyer | Wisconsin | 55113 | 1632 | 24 |
1215807 | 1215807 | 2021-04-12 | Sawyer | Wisconsin | 55113 | 1631 | 24 |
1212560 | 1212560 | 2021-04-11 | Sawyer | Wisconsin | 55113 | 1630 | 24 |
1209311 | 1209311 | 2021-04-10 | Sawyer | Wisconsin | 55113 | 1628 | 24 |
1206063 | 1206063 | 2021-04-09 | Sawyer | Wisconsin | 55113 | 1624 | 24 |
1202815 | 1202815 | 2021-04-08 | Sawyer | Wisconsin | 55113 | 1621 | 24 |
1199567 | 1199567 | 2021-04-07 | Sawyer | Wisconsin | 55113 | 1619 | 24 |
1196318 | 1196318 | 2021-04-06 | Sawyer | Wisconsin | 55113 | 1619 | 24 |
1193070 | 1193070 | 2021-04-05 | Sawyer | Wisconsin | 55113 | 1618 | 24 |
1189820 | 1189820 | 2021-04-04 | Sawyer | Wisconsin | 55113 | 1619 | 24 |
1186573 | 1186573 | 2021-04-03 | Sawyer | Wisconsin | 55113 | 1617 | 24 |
1183326 | 1183326 | 2021-04-02 | Sawyer | Wisconsin | 55113 | 1617 | 24 |
1180079 | 1180079 | 2021-04-01 | Sawyer | Wisconsin | 55113 | 1614 | 24 |
1176832 | 1176832 | 2021-03-31 | Sawyer | Wisconsin | 55113 | 1612 | 24 |
1173585 | 1173585 | 2021-03-30 | Sawyer | Wisconsin | 55113 | 1608 | 23 |
1170338 | 1170338 | 2021-03-29 | Sawyer | Wisconsin | 55113 | 1605 | 23 |
1167090 | 1167090 | 2021-03-28 | Sawyer | Wisconsin | 55113 | 1604 | 22 |
1163842 | 1163842 | 2021-03-27 | Sawyer | Wisconsin | 55113 | 1602 | 22 |
1160594 | 1160594 | 2021-03-26 | Sawyer | Wisconsin | 55113 | 1600 | 22 |
1157346 | 1157346 | 2021-03-25 | Sawyer | Wisconsin | 55113 | 1596 | 22 |
1154099 | 1154099 | 2021-03-24 | Sawyer | Wisconsin | 55113 | 1594 | 22 |
1150852 | 1150852 | 2021-03-23 | Sawyer | Wisconsin | 55113 | 1590 | 22 |
1147605 | 1147605 | 2021-03-22 | Sawyer | Wisconsin | 55113 | 1590 | 22 |
1144358 | 1144358 | 2021-03-21 | Sawyer | Wisconsin | 55113 | 1589 | 22 |
1141111 | 1141111 | 2021-03-20 | Sawyer | Wisconsin | 55113 | 1586 | 22 |
1137865 | 1137865 | 2021-03-19 | Sawyer | Wisconsin | 55113 | 1586 | 22 |
1134619 | 1134619 | 2021-03-18 | Sawyer | Wisconsin | 55113 | 1585 | 22 |
1131371 | 1131371 | 2021-03-17 | Sawyer | Wisconsin | 55113 | 1585 | 22 |
1128124 | 1128124 | 2021-03-16 | Sawyer | Wisconsin | 55113 | 1581 | 22 |
1124878 | 1124878 | 2021-03-15 | Sawyer | Wisconsin | 55113 | 1580 | 22 |
1121632 | 1121632 | 2021-03-14 | Sawyer | Wisconsin | 55113 | 1579 | 22 |
1118385 | 1118385 | 2021-03-13 | Sawyer | Wisconsin | 55113 | 1579 | 22 |
1115138 | 1115138 | 2021-03-12 | Sawyer | Wisconsin | 55113 | 1575 | 22 |
1111892 | 1111892 | 2021-03-11 | Sawyer | Wisconsin | 55113 | 1575 | 22 |
1108646 | 1108646 | 2021-03-10 | Sawyer | Wisconsin | 55113 | 1572 | 22 |
1105400 | 1105400 | 2021-03-09 | Sawyer | Wisconsin | 55113 | 1570 | 22 |
1102154 | 1102154 | 2021-03-08 | Sawyer | Wisconsin | 55113 | 1570 | 22 |
1098908 | 1098908 | 2021-03-07 | Sawyer | Wisconsin | 55113 | 1569 | 22 |
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);