ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 26163 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717218 | 1717218 | 2021-09-14 | Wayne | Michigan | 26163 | 180274 | 5327 |
1713970 | 1713970 | 2021-09-13 | Wayne | Michigan | 26163 | 180274 | 5327 |
1710724 | 1710724 | 2021-09-12 | Wayne | Michigan | 26163 | 179400 | 5325 |
1707477 | 1707477 | 2021-09-11 | Wayne | Michigan | 26163 | 179400 | 5325 |
1704230 | 1704230 | 2021-09-10 | Wayne | Michigan | 26163 | 179400 | 5325 |
1700980 | 1700980 | 2021-09-09 | Wayne | Michigan | 26163 | 178474 | 5333 |
1697731 | 1697731 | 2021-09-08 | Wayne | Michigan | 26163 | 178474 | 5333 |
1694483 | 1694483 | 2021-09-07 | Wayne | Michigan | 26163 | 178053 | 5319 |
1691234 | 1691234 | 2021-09-06 | Wayne | Michigan | 26163 | 177167 | 5312 |
1687984 | 1687984 | 2021-09-05 | Wayne | Michigan | 26163 | 177167 | 5312 |
1684734 | 1684734 | 2021-09-04 | Wayne | Michigan | 26163 | 177167 | 5312 |
1681483 | 1681483 | 2021-09-03 | Wayne | Michigan | 26163 | 177167 | 5312 |
1678235 | 1678235 | 2021-09-02 | Wayne | Michigan | 26163 | 176513 | 5304 |
1674987 | 1674987 | 2021-09-01 | Wayne | Michigan | 26163 | 176513 | 5304 |
1671739 | 1671739 | 2021-08-31 | Wayne | Michigan | 26163 | 175854 | 5284 |
1668492 | 1668492 | 2021-08-30 | Wayne | Michigan | 26163 | 175854 | 5284 |
1665245 | 1665245 | 2021-08-29 | Wayne | Michigan | 26163 | 175078 | 5278 |
1661997 | 1661997 | 2021-08-28 | Wayne | Michigan | 26163 | 175078 | 5278 |
1658749 | 1658749 | 2021-08-27 | Wayne | Michigan | 26163 | 175078 | 5278 |
1655500 | 1655500 | 2021-08-26 | Wayne | Michigan | 26163 | 174488 | 5260 |
1652253 | 1652253 | 2021-08-25 | Wayne | Michigan | 26163 | 174488 | 5260 |
1649005 | 1649005 | 2021-08-24 | Wayne | Michigan | 26163 | 173635 | 5252 |
1645756 | 1645756 | 2021-08-23 | Wayne | Michigan | 26163 | 173635 | 5252 |
1642507 | 1642507 | 2021-08-22 | Wayne | Michigan | 26163 | 172976 | 5252 |
1639257 | 1639257 | 2021-08-21 | Wayne | Michigan | 26163 | 172976 | 5252 |
1636007 | 1636007 | 2021-08-20 | Wayne | Michigan | 26163 | 172976 | 5252 |
1632757 | 1632757 | 2021-08-19 | Wayne | Michigan | 26163 | 172311 | 5245 |
1629510 | 1629510 | 2021-08-18 | Wayne | Michigan | 26163 | 172311 | 5245 |
1626263 | 1626263 | 2021-08-17 | Wayne | Michigan | 26163 | 171788 | 5231 |
1623016 | 1623016 | 2021-08-16 | Wayne | Michigan | 26163 | 171788 | 5231 |
1619769 | 1619769 | 2021-08-15 | Wayne | Michigan | 26163 | 171113 | 5231 |
1616521 | 1616521 | 2021-08-14 | Wayne | Michigan | 26163 | 171113 | 5231 |
1613273 | 1613273 | 2021-08-13 | Wayne | Michigan | 26163 | 171113 | 5231 |
1610024 | 1610024 | 2021-08-12 | Wayne | Michigan | 26163 | 170534 | 5227 |
1606776 | 1606776 | 2021-08-11 | Wayne | Michigan | 26163 | 170534 | 5227 |
1603527 | 1603527 | 2021-08-10 | Wayne | Michigan | 26163 | 170033 | 5220 |
1600278 | 1600278 | 2021-08-09 | Wayne | Michigan | 26163 | 170033 | 5220 |
1597030 | 1597030 | 2021-08-08 | Wayne | Michigan | 26163 | 169487 | 5218 |
1593781 | 1593781 | 2021-08-07 | Wayne | Michigan | 26163 | 169487 | 5218 |
1590532 | 1590532 | 2021-08-06 | Wayne | Michigan | 26163 | 169487 | 5218 |
1587283 | 1587283 | 2021-08-05 | Wayne | Michigan | 26163 | 168625 | 5219 |
1584032 | 1584032 | 2021-08-04 | Wayne | Michigan | 26163 | 168625 | 5219 |
1580783 | 1580783 | 2021-08-03 | Wayne | Michigan | 26163 | 168625 | 5219 |
1577534 | 1577534 | 2021-08-02 | Wayne | Michigan | 26163 | 168054 | 5211 |
1574286 | 1574286 | 2021-08-01 | Wayne | Michigan | 26163 | 168054 | 5211 |
1571038 | 1571038 | 2021-07-31 | Wayne | Michigan | 26163 | 168054 | 5211 |
1567790 | 1567790 | 2021-07-30 | Wayne | Michigan | 26163 | 168054 | 5211 |
1564542 | 1564542 | 2021-07-29 | Wayne | Michigan | 26163 | 167651 | 5208 |
1561294 | 1561294 | 2021-07-28 | Wayne | Michigan | 26163 | 167651 | 5208 |
1558046 | 1558046 | 2021-07-27 | Wayne | Michigan | 26163 | 167651 | 5208 |
1554799 | 1554799 | 2021-07-26 | Wayne | Michigan | 26163 | 167307 | 5201 |
1551552 | 1551552 | 2021-07-25 | Wayne | Michigan | 26163 | 167307 | 5201 |
1548305 | 1548305 | 2021-07-24 | Wayne | Michigan | 26163 | 167307 | 5201 |
1545058 | 1545058 | 2021-07-23 | Wayne | Michigan | 26163 | 167307 | 5201 |
1541810 | 1541810 | 2021-07-22 | Wayne | Michigan | 26163 | 167006 | 5196 |
1538563 | 1538563 | 2021-07-21 | Wayne | Michigan | 26163 | 167006 | 5196 |
1535316 | 1535316 | 2021-07-20 | Wayne | Michigan | 26163 | 167006 | 5196 |
1532068 | 1532068 | 2021-07-19 | Wayne | Michigan | 26163 | 166784 | 5194 |
1528821 | 1528821 | 2021-07-18 | Wayne | Michigan | 26163 | 166784 | 5194 |
1525574 | 1525574 | 2021-07-17 | Wayne | Michigan | 26163 | 166784 | 5194 |
1522327 | 1522327 | 2021-07-16 | Wayne | Michigan | 26163 | 166784 | 5194 |
1519078 | 1519078 | 2021-07-15 | Wayne | Michigan | 26163 | 166558 | 5189 |
1515831 | 1515831 | 2021-07-14 | Wayne | Michigan | 26163 | 166558 | 5189 |
1512585 | 1512585 | 2021-07-13 | Wayne | Michigan | 26163 | 166558 | 5189 |
1509338 | 1509338 | 2021-07-12 | Wayne | Michigan | 26163 | 166400 | 5184 |
1506092 | 1506092 | 2021-07-11 | Wayne | Michigan | 26163 | 166400 | 5184 |
1502846 | 1502846 | 2021-07-10 | Wayne | Michigan | 26163 | 166400 | 5184 |
1499600 | 1499600 | 2021-07-09 | Wayne | Michigan | 26163 | 166400 | 5184 |
1496354 | 1496354 | 2021-07-08 | Wayne | Michigan | 26163 | 166249 | 5174 |
1493107 | 1493107 | 2021-07-07 | Wayne | Michigan | 26163 | 166249 | 5174 |
1489860 | 1489860 | 2021-07-06 | Wayne | Michigan | 26163 | 166249 | 5174 |
1486613 | 1486613 | 2021-07-05 | Wayne | Michigan | 26163 | 166128 | 5171 |
1483367 | 1483367 | 2021-07-04 | Wayne | Michigan | 26163 | 166128 | 5171 |
1480121 | 1480121 | 2021-07-03 | Wayne | Michigan | 26163 | 166128 | 5171 |
1476874 | 1476874 | 2021-07-02 | Wayne | Michigan | 26163 | 166128 | 5171 |
1473628 | 1473628 | 2021-07-01 | Wayne | Michigan | 26163 | 166066 | 5170 |
1470382 | 1470382 | 2021-06-30 | Wayne | Michigan | 26163 | 165942 | 5167 |
1467137 | 1467137 | 2021-06-29 | Wayne | Michigan | 26163 | 165895 | 5167 |
1463892 | 1463892 | 2021-06-28 | Wayne | Michigan | 26163 | 165841 | 5161 |
1460647 | 1460647 | 2021-06-27 | Wayne | Michigan | 26163 | 165755 | 5161 |
1457402 | 1457402 | 2021-06-26 | Wayne | Michigan | 26163 | 165755 | 5161 |
1454157 | 1454157 | 2021-06-25 | Wayne | Michigan | 26163 | 165755 | 5161 |
1450912 | 1450912 | 2021-06-24 | Wayne | Michigan | 26163 | 165732 | 5157 |
1447666 | 1447666 | 2021-06-23 | Wayne | Michigan | 26163 | 165690 | 5150 |
1444421 | 1444421 | 2021-06-22 | Wayne | Michigan | 26163 | 165648 | 5149 |
1441176 | 1441176 | 2021-06-21 | Wayne | Michigan | 26163 | 165611 | 5148 |
1437930 | 1437930 | 2021-06-20 | Wayne | Michigan | 26163 | 165535 | 5142 |
1434683 | 1434683 | 2021-06-19 | Wayne | Michigan | 26163 | 165535 | 5142 |
1431436 | 1431436 | 2021-06-18 | Wayne | Michigan | 26163 | 165535 | 5142 |
1428191 | 1428191 | 2021-06-17 | Wayne | Michigan | 26163 | 165484 | 5138 |
1424946 | 1424946 | 2021-06-16 | Wayne | Michigan | 26163 | 165446 | 5128 |
1421698 | 1421698 | 2021-06-15 | Wayne | Michigan | 26163 | 165410 | 5126 |
1418453 | 1418453 | 2021-06-14 | Wayne | Michigan | 26163 | 165350 | 5114 |
1415208 | 1415208 | 2021-06-13 | Wayne | Michigan | 26163 | 165272 | 5115 |
1411962 | 1411962 | 2021-06-12 | Wayne | Michigan | 26163 | 165272 | 5115 |
1408717 | 1408717 | 2021-06-11 | Wayne | Michigan | 26163 | 165203 | 5101 |
1405472 | 1405472 | 2021-06-10 | Wayne | Michigan | 26163 | 165113 | 5099 |
1402226 | 1402226 | 2021-06-09 | Wayne | Michigan | 26163 | 165057 | 5092 |
1398981 | 1398981 | 2021-06-08 | Wayne | Michigan | 26163 | 164994 | 5088 |
1395735 | 1395735 | 2021-06-07 | Wayne | Michigan | 26163 | 164917 | 5083 |
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);