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 |
---|---|---|---|---|---|---|---|
1947922 | 1947922 | 2021-11-24 | Wayne | Michigan | 26163 | 223857 | 5818 |
1944671 | 1944671 | 2021-11-23 | Wayne | Michigan | 26163 | 220832 | 5781 |
1941420 | 1941420 | 2021-11-22 | Wayne | Michigan | 26163 | 220832 | 5781 |
1938170 | 1938170 | 2021-11-21 | Wayne | Michigan | 26163 | 218136 | 5774 |
1934920 | 1934920 | 2021-11-20 | Wayne | Michigan | 26163 | 218136 | 5774 |
1931670 | 1931670 | 2021-11-19 | Wayne | Michigan | 26163 | 218136 | 5774 |
1928419 | 1928419 | 2021-11-18 | Wayne | Michigan | 26163 | 215405 | 5752 |
1925169 | 1925169 | 2021-11-17 | Wayne | Michigan | 26163 | 215405 | 5752 |
1921920 | 1921920 | 2021-11-16 | Wayne | Michigan | 26163 | 212684 | 5696 |
1918670 | 1918670 | 2021-11-15 | Wayne | Michigan | 26163 | 212684 | 5696 |
1915420 | 1915420 | 2021-11-14 | Wayne | Michigan | 26163 | 209592 | 5687 |
1912170 | 1912170 | 2021-11-13 | Wayne | Michigan | 26163 | 209592 | 5687 |
1908920 | 1908920 | 2021-11-12 | Wayne | Michigan | 26163 | 209592 | 5687 |
1905671 | 1905671 | 2021-11-11 | Wayne | Michigan | 26163 | 207307 | 5675 |
1902422 | 1902422 | 2021-11-10 | Wayne | Michigan | 26163 | 207307 | 5675 |
1899172 | 1899172 | 2021-11-09 | Wayne | Michigan | 26163 | 206233 | 5644 |
1895922 | 1895922 | 2021-11-08 | Wayne | Michigan | 26163 | 206233 | 5644 |
1892672 | 1892672 | 2021-11-07 | Wayne | Michigan | 26163 | 204921 | 5642 |
1889422 | 1889422 | 2021-11-06 | Wayne | Michigan | 26163 | 204921 | 5642 |
1886172 | 1886172 | 2021-11-05 | Wayne | Michigan | 26163 | 204921 | 5642 |
1882923 | 1882923 | 2021-11-04 | Wayne | Michigan | 26163 | 203373 | 5628 |
1879674 | 1879674 | 2021-11-03 | Wayne | Michigan | 26163 | 203373 | 5628 |
1876425 | 1876425 | 2021-11-02 | Wayne | Michigan | 26163 | 201869 | 5609 |
1873176 | 1873176 | 2021-11-01 | Wayne | Michigan | 26163 | 201869 | 5609 |
1869927 | 1869927 | 2021-10-31 | Wayne | Michigan | 26163 | 200547 | 5600 |
1866678 | 1866678 | 2021-10-30 | Wayne | Michigan | 26163 | 200547 | 5600 |
1863429 | 1863429 | 2021-10-29 | Wayne | Michigan | 26163 | 200547 | 5600 |
1860180 | 1860180 | 2021-10-28 | Wayne | Michigan | 26163 | 199451 | 5575 |
1856931 | 1856931 | 2021-10-27 | Wayne | Michigan | 26163 | 199451 | 5575 |
1853682 | 1853682 | 2021-10-26 | Wayne | Michigan | 26163 | 198255 | 5553 |
1850433 | 1850433 | 2021-10-25 | Wayne | Michigan | 26163 | 198255 | 5553 |
1847183 | 1847183 | 2021-10-24 | Wayne | Michigan | 26163 | 197135 | 5548 |
1843933 | 1843933 | 2021-10-23 | Wayne | Michigan | 26163 | 197135 | 5548 |
1840683 | 1840683 | 2021-10-22 | Wayne | Michigan | 26163 | 197135 | 5548 |
1837434 | 1837434 | 2021-10-21 | Wayne | Michigan | 26163 | 196132 | 5534 |
1834185 | 1834185 | 2021-10-20 | Wayne | Michigan | 26163 | 196132 | 5534 |
1830936 | 1830936 | 2021-10-19 | Wayne | Michigan | 26163 | 195167 | 5518 |
1827687 | 1827687 | 2021-10-18 | Wayne | Michigan | 26163 | 195167 | 5518 |
1824438 | 1824438 | 2021-10-17 | Wayne | Michigan | 26163 | 193985 | 5506 |
1821189 | 1821189 | 2021-10-16 | Wayne | Michigan | 26163 | 193985 | 5506 |
1817940 | 1817940 | 2021-10-15 | Wayne | Michigan | 26163 | 193985 | 5506 |
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 |
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);