ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26157 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717214 | 1717214 | 2021-09-14 | Tuscola | Michigan | 26157 | 6134 | 181 |
1713966 | 1713966 | 2021-09-13 | Tuscola | Michigan | 26157 | 6134 | 181 |
1710720 | 1710720 | 2021-09-12 | Tuscola | Michigan | 26157 | 6113 | 180 |
1707473 | 1707473 | 2021-09-11 | Tuscola | Michigan | 26157 | 6113 | 180 |
1704226 | 1704226 | 2021-09-10 | Tuscola | Michigan | 26157 | 6113 | 180 |
1700976 | 1700976 | 2021-09-09 | Tuscola | Michigan | 26157 | 6064 | 179 |
1697727 | 1697727 | 2021-09-08 | Tuscola | Michigan | 26157 | 6064 | 179 |
1694479 | 1694479 | 2021-09-07 | Tuscola | Michigan | 26157 | 6054 | 179 |
1691230 | 1691230 | 2021-09-06 | Tuscola | Michigan | 26157 | 6022 | 179 |
1687980 | 1687980 | 2021-09-05 | Tuscola | Michigan | 26157 | 6022 | 179 |
1684730 | 1684730 | 2021-09-04 | Tuscola | Michigan | 26157 | 6022 | 179 |
1681479 | 1681479 | 2021-09-03 | Tuscola | Michigan | 26157 | 6022 | 179 |
1678231 | 1678231 | 2021-09-02 | Tuscola | Michigan | 26157 | 6003 | 177 |
1674983 | 1674983 | 2021-09-01 | Tuscola | Michigan | 26157 | 6003 | 177 |
1671735 | 1671735 | 2021-08-31 | Tuscola | Michigan | 26157 | 5971 | 176 |
1668488 | 1668488 | 2021-08-30 | Tuscola | Michigan | 26157 | 5971 | 176 |
1665241 | 1665241 | 2021-08-29 | Tuscola | Michigan | 26157 | 5953 | 176 |
1661993 | 1661993 | 2021-08-28 | Tuscola | Michigan | 26157 | 5953 | 176 |
1658745 | 1658745 | 2021-08-27 | Tuscola | Michigan | 26157 | 5953 | 176 |
1655496 | 1655496 | 2021-08-26 | Tuscola | Michigan | 26157 | 5922 | 176 |
1652249 | 1652249 | 2021-08-25 | Tuscola | Michigan | 26157 | 5922 | 176 |
1649001 | 1649001 | 2021-08-24 | Tuscola | Michigan | 26157 | 5896 | 176 |
1645752 | 1645752 | 2021-08-23 | Tuscola | Michigan | 26157 | 5896 | 176 |
1642503 | 1642503 | 2021-08-22 | Tuscola | Michigan | 26157 | 5867 | 176 |
1639253 | 1639253 | 2021-08-21 | Tuscola | Michigan | 26157 | 5867 | 176 |
1636003 | 1636003 | 2021-08-20 | Tuscola | Michigan | 26157 | 5867 | 176 |
1632753 | 1632753 | 2021-08-19 | Tuscola | Michigan | 26157 | 5839 | 176 |
1629506 | 1629506 | 2021-08-18 | Tuscola | Michigan | 26157 | 5839 | 176 |
1626259 | 1626259 | 2021-08-17 | Tuscola | Michigan | 26157 | 5822 | 176 |
1623012 | 1623012 | 2021-08-16 | Tuscola | Michigan | 26157 | 5822 | 176 |
1619765 | 1619765 | 2021-08-15 | Tuscola | Michigan | 26157 | 5806 | 176 |
1616517 | 1616517 | 2021-08-14 | Tuscola | Michigan | 26157 | 5806 | 176 |
1613269 | 1613269 | 2021-08-13 | Tuscola | Michigan | 26157 | 5806 | 176 |
1610020 | 1610020 | 2021-08-12 | Tuscola | Michigan | 26157 | 5799 | 176 |
1606772 | 1606772 | 2021-08-11 | Tuscola | Michigan | 26157 | 5799 | 176 |
1603523 | 1603523 | 2021-08-10 | Tuscola | Michigan | 26157 | 5780 | 176 |
1600274 | 1600274 | 2021-08-09 | Tuscola | Michigan | 26157 | 5780 | 176 |
1597026 | 1597026 | 2021-08-08 | Tuscola | Michigan | 26157 | 5761 | 176 |
1593777 | 1593777 | 2021-08-07 | Tuscola | Michigan | 26157 | 5761 | 176 |
1590528 | 1590528 | 2021-08-06 | Tuscola | Michigan | 26157 | 5761 | 176 |
1587279 | 1587279 | 2021-08-05 | Tuscola | Michigan | 26157 | 5741 | 176 |
1584028 | 1584028 | 2021-08-04 | Tuscola | Michigan | 26157 | 5741 | 176 |
1580779 | 1580779 | 2021-08-03 | Tuscola | Michigan | 26157 | 5741 | 176 |
1577530 | 1577530 | 2021-08-02 | Tuscola | Michigan | 26157 | 5726 | 174 |
1574282 | 1574282 | 2021-08-01 | Tuscola | Michigan | 26157 | 5726 | 174 |
1571034 | 1571034 | 2021-07-31 | Tuscola | Michigan | 26157 | 5726 | 174 |
1567786 | 1567786 | 2021-07-30 | Tuscola | Michigan | 26157 | 5726 | 174 |
1564538 | 1564538 | 2021-07-29 | Tuscola | Michigan | 26157 | 5705 | 174 |
1561290 | 1561290 | 2021-07-28 | Tuscola | Michigan | 26157 | 5705 | 174 |
1558042 | 1558042 | 2021-07-27 | Tuscola | Michigan | 26157 | 5705 | 174 |
1554795 | 1554795 | 2021-07-26 | Tuscola | Michigan | 26157 | 5695 | 174 |
1551548 | 1551548 | 2021-07-25 | Tuscola | Michigan | 26157 | 5695 | 174 |
1548301 | 1548301 | 2021-07-24 | Tuscola | Michigan | 26157 | 5695 | 174 |
1545054 | 1545054 | 2021-07-23 | Tuscola | Michigan | 26157 | 5695 | 174 |
1541806 | 1541806 | 2021-07-22 | Tuscola | Michigan | 26157 | 5689 | 174 |
1538559 | 1538559 | 2021-07-21 | Tuscola | Michigan | 26157 | 5689 | 174 |
1535312 | 1535312 | 2021-07-20 | Tuscola | Michigan | 26157 | 5689 | 174 |
1532064 | 1532064 | 2021-07-19 | Tuscola | Michigan | 26157 | 5684 | 174 |
1528817 | 1528817 | 2021-07-18 | Tuscola | Michigan | 26157 | 5684 | 174 |
1525570 | 1525570 | 2021-07-17 | Tuscola | Michigan | 26157 | 5684 | 174 |
1522323 | 1522323 | 2021-07-16 | Tuscola | Michigan | 26157 | 5684 | 174 |
1519074 | 1519074 | 2021-07-15 | Tuscola | Michigan | 26157 | 5676 | 174 |
1515827 | 1515827 | 2021-07-14 | Tuscola | Michigan | 26157 | 5676 | 174 |
1512581 | 1512581 | 2021-07-13 | Tuscola | Michigan | 26157 | 5676 | 174 |
1509334 | 1509334 | 2021-07-12 | Tuscola | Michigan | 26157 | 5674 | 174 |
1506088 | 1506088 | 2021-07-11 | Tuscola | Michigan | 26157 | 5674 | 174 |
1502842 | 1502842 | 2021-07-10 | Tuscola | Michigan | 26157 | 5674 | 174 |
1499596 | 1499596 | 2021-07-09 | Tuscola | Michigan | 26157 | 5674 | 174 |
1496350 | 1496350 | 2021-07-08 | Tuscola | Michigan | 26157 | 5670 | 174 |
1493103 | 1493103 | 2021-07-07 | Tuscola | Michigan | 26157 | 5670 | 174 |
1489856 | 1489856 | 2021-07-06 | Tuscola | Michigan | 26157 | 5670 | 174 |
1486609 | 1486609 | 2021-07-05 | Tuscola | Michigan | 26157 | 5668 | 174 |
1483363 | 1483363 | 2021-07-04 | Tuscola | Michigan | 26157 | 5668 | 174 |
1480117 | 1480117 | 2021-07-03 | Tuscola | Michigan | 26157 | 5668 | 174 |
1476870 | 1476870 | 2021-07-02 | Tuscola | Michigan | 26157 | 5668 | 174 |
1473624 | 1473624 | 2021-07-01 | Tuscola | Michigan | 26157 | 5668 | 174 |
1470378 | 1470378 | 2021-06-30 | Tuscola | Michigan | 26157 | 5668 | 174 |
1467133 | 1467133 | 2021-06-29 | Tuscola | Michigan | 26157 | 5668 | 174 |
1463888 | 1463888 | 2021-06-28 | Tuscola | Michigan | 26157 | 5668 | 174 |
1460643 | 1460643 | 2021-06-27 | Tuscola | Michigan | 26157 | 5668 | 174 |
1457398 | 1457398 | 2021-06-26 | Tuscola | Michigan | 26157 | 5668 | 174 |
1454153 | 1454153 | 2021-06-25 | Tuscola | Michigan | 26157 | 5668 | 174 |
1450908 | 1450908 | 2021-06-24 | Tuscola | Michigan | 26157 | 5667 | 174 |
1447662 | 1447662 | 2021-06-23 | Tuscola | Michigan | 26157 | 5667 | 174 |
1444417 | 1444417 | 2021-06-22 | Tuscola | Michigan | 26157 | 5665 | 174 |
1441172 | 1441172 | 2021-06-21 | Tuscola | Michigan | 26157 | 5665 | 173 |
1437926 | 1437926 | 2021-06-20 | Tuscola | Michigan | 26157 | 5665 | 173 |
1434679 | 1434679 | 2021-06-19 | Tuscola | Michigan | 26157 | 5665 | 173 |
1431432 | 1431432 | 2021-06-18 | Tuscola | Michigan | 26157 | 5665 | 173 |
1428187 | 1428187 | 2021-06-17 | Tuscola | Michigan | 26157 | 5665 | 173 |
1424942 | 1424942 | 2021-06-16 | Tuscola | Michigan | 26157 | 5665 | 173 |
1421694 | 1421694 | 2021-06-15 | Tuscola | Michigan | 26157 | 5665 | 173 |
1418449 | 1418449 | 2021-06-14 | Tuscola | Michigan | 26157 | 5664 | 173 |
1415204 | 1415204 | 2021-06-13 | Tuscola | Michigan | 26157 | 5663 | 173 |
1411958 | 1411958 | 2021-06-12 | Tuscola | Michigan | 26157 | 5663 | 173 |
1408713 | 1408713 | 2021-06-11 | Tuscola | Michigan | 26157 | 5663 | 173 |
1405468 | 1405468 | 2021-06-10 | Tuscola | Michigan | 26157 | 5663 | 173 |
1402222 | 1402222 | 2021-06-09 | Tuscola | Michigan | 26157 | 5662 | 173 |
1398977 | 1398977 | 2021-06-08 | Tuscola | Michigan | 26157 | 5662 | 173 |
1395731 | 1395731 | 2021-06-07 | Tuscola | Michigan | 26157 | 5662 | 173 |
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);