ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Wayne" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1814691 | 1814691 | 2021-10-14 | Wayne | Michigan | 26163 | 192783 | 5494 |
1811443 | 1811443 | 2021-10-13 | Wayne | Michigan | 26163 | 192783 | 5494 |
1808194 | 1808194 | 2021-10-12 | Wayne | Michigan | 26163 | 191660 | 5473 |
1804943 | 1804943 | 2021-10-11 | Wayne | Michigan | 26163 | 191660 | 5473 |
1801694 | 1801694 | 2021-10-10 | Wayne | Michigan | 26163 | 190419 | 5464 |
1798445 | 1798445 | 2021-10-09 | Wayne | Michigan | 26163 | 190419 | 5464 |
1795196 | 1795196 | 2021-10-08 | Wayne | Michigan | 26163 | 190419 | 5464 |
1791947 | 1791947 | 2021-10-07 | Wayne | Michigan | 26163 | 189458 | 5453 |
1788698 | 1788698 | 2021-10-06 | Wayne | Michigan | 26163 | 189458 | 5453 |
1785450 | 1785450 | 2021-10-05 | Wayne | Michigan | 26163 | 188385 | 5428 |
1782201 | 1782201 | 2021-10-04 | Wayne | Michigan | 26163 | 188385 | 5428 |
1778951 | 1778951 | 2021-10-03 | Wayne | Michigan | 26163 | 187216 | 5422 |
1775701 | 1775701 | 2021-10-02 | Wayne | Michigan | 26163 | 187216 | 5422 |
1772451 | 1772451 | 2021-10-01 | Wayne | Michigan | 26163 | 187216 | 5422 |
1769202 | 1769202 | 2021-09-30 | Wayne | Michigan | 26163 | 186206 | 5404 |
1765953 | 1765953 | 2021-09-29 | Wayne | Michigan | 26163 | 186206 | 5404 |
1762704 | 1762704 | 2021-09-28 | Wayne | Michigan | 26163 | 185283 | 5385 |
1759455 | 1759455 | 2021-09-27 | Wayne | Michigan | 26163 | 185283 | 5385 |
1756207 | 1756207 | 2021-09-26 | Wayne | Michigan | 26163 | 184301 | 5379 |
1752959 | 1752959 | 2021-09-25 | Wayne | Michigan | 26163 | 184301 | 5379 |
1749711 | 1749711 | 2021-09-24 | Wayne | Michigan | 26163 | 184301 | 5379 |
1746461 | 1746461 | 2021-09-23 | Wayne | Michigan | 26163 | 183517 | 5368 |
1743212 | 1743212 | 2021-09-22 | Wayne | Michigan | 26163 | 183517 | 5368 |
1739963 | 1739963 | 2021-09-21 | Wayne | Michigan | 26163 | 182670 | 5354 |
1736714 | 1736714 | 2021-09-20 | Wayne | Michigan | 26163 | 182670 | 5354 |
1733464 | 1733464 | 2021-09-19 | Wayne | Michigan | 26163 | 181817 | 5351 |
1730214 | 1730214 | 2021-09-18 | Wayne | Michigan | 26163 | 181817 | 5351 |
1726964 | 1726964 | 2021-09-17 | Wayne | Michigan | 26163 | 181817 | 5351 |
1723715 | 1723715 | 2021-09-16 | Wayne | Michigan | 26163 | 181110 | 5339 |
1720466 | 1720466 | 2021-09-15 | Wayne | Michigan | 26163 | 181110 | 5339 |
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 |
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);