ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Calhoun" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947852 | 1947852 | 2021-11-24 | Calhoun | Michigan | 26025 | 21430 | 384 |
1944601 | 1944601 | 2021-11-23 | Calhoun | Michigan | 26025 | 21076 | 377 |
1941350 | 1941350 | 2021-11-22 | Calhoun | Michigan | 26025 | 21076 | 377 |
1938100 | 1938100 | 2021-11-21 | Calhoun | Michigan | 26025 | 20812 | 372 |
1934850 | 1934850 | 2021-11-20 | Calhoun | Michigan | 26025 | 20812 | 372 |
1931600 | 1931600 | 2021-11-19 | Calhoun | Michigan | 26025 | 20812 | 372 |
1928349 | 1928349 | 2021-11-18 | Calhoun | Michigan | 26025 | 20487 | 370 |
1925099 | 1925099 | 2021-11-17 | Calhoun | Michigan | 26025 | 20487 | 370 |
1921850 | 1921850 | 2021-11-16 | Calhoun | Michigan | 26025 | 20192 | 369 |
1918600 | 1918600 | 2021-11-15 | Calhoun | Michigan | 26025 | 20192 | 369 |
1915350 | 1915350 | 2021-11-14 | Calhoun | Michigan | 26025 | 19907 | 364 |
1912100 | 1912100 | 2021-11-13 | Calhoun | Michigan | 26025 | 19907 | 364 |
1908850 | 1908850 | 2021-11-12 | Calhoun | Michigan | 26025 | 19907 | 364 |
1905601 | 1905601 | 2021-11-11 | Calhoun | Michigan | 26025 | 19671 | 363 |
1902352 | 1902352 | 2021-11-10 | Calhoun | Michigan | 26025 | 19671 | 363 |
1899102 | 1899102 | 2021-11-09 | Calhoun | Michigan | 26025 | 19554 | 360 |
1895852 | 1895852 | 2021-11-08 | Calhoun | Michigan | 26025 | 19554 | 360 |
1892602 | 1892602 | 2021-11-07 | Calhoun | Michigan | 26025 | 19429 | 359 |
1889352 | 1889352 | 2021-11-06 | Calhoun | Michigan | 26025 | 19429 | 359 |
1886102 | 1886102 | 2021-11-05 | Calhoun | Michigan | 26025 | 19429 | 359 |
1882853 | 1882853 | 2021-11-04 | Calhoun | Michigan | 26025 | 19266 | 357 |
1879604 | 1879604 | 2021-11-03 | Calhoun | Michigan | 26025 | 19266 | 357 |
1876355 | 1876355 | 2021-11-02 | Calhoun | Michigan | 26025 | 19103 | 356 |
1873106 | 1873106 | 2021-11-01 | Calhoun | Michigan | 26025 | 19103 | 356 |
1869857 | 1869857 | 2021-10-31 | Calhoun | Michigan | 26025 | 18951 | 354 |
1866608 | 1866608 | 2021-10-30 | Calhoun | Michigan | 26025 | 18951 | 354 |
1863359 | 1863359 | 2021-10-29 | Calhoun | Michigan | 26025 | 18951 | 354 |
1860110 | 1860110 | 2021-10-28 | Calhoun | Michigan | 26025 | 18818 | 353 |
1856861 | 1856861 | 2021-10-27 | Calhoun | Michigan | 26025 | 18818 | 353 |
1853612 | 1853612 | 2021-10-26 | Calhoun | Michigan | 26025 | 18672 | 353 |
1850363 | 1850363 | 2021-10-25 | Calhoun | Michigan | 26025 | 18672 | 353 |
1847113 | 1847113 | 2021-10-24 | Calhoun | Michigan | 26025 | 18582 | 351 |
1843863 | 1843863 | 2021-10-23 | Calhoun | Michigan | 26025 | 18582 | 351 |
1840613 | 1840613 | 2021-10-22 | Calhoun | Michigan | 26025 | 18582 | 351 |
1837364 | 1837364 | 2021-10-21 | Calhoun | Michigan | 26025 | 18436 | 347 |
1834115 | 1834115 | 2021-10-20 | Calhoun | Michigan | 26025 | 18436 | 347 |
1830866 | 1830866 | 2021-10-19 | Calhoun | Michigan | 26025 | 18300 | 345 |
1827617 | 1827617 | 2021-10-18 | Calhoun | Michigan | 26025 | 18300 | 345 |
1824368 | 1824368 | 2021-10-17 | Calhoun | Michigan | 26025 | 18176 | 345 |
1821119 | 1821119 | 2021-10-16 | Calhoun | Michigan | 26025 | 18176 | 345 |
1817870 | 1817870 | 2021-10-15 | Calhoun | Michigan | 26025 | 18176 | 345 |
1814621 | 1814621 | 2021-10-14 | Calhoun | Michigan | 26025 | 18000 | 342 |
1811373 | 1811373 | 2021-10-13 | Calhoun | Michigan | 26025 | 18000 | 342 |
1808124 | 1808124 | 2021-10-12 | Calhoun | Michigan | 26025 | 17799 | 341 |
1804873 | 1804873 | 2021-10-11 | Calhoun | Michigan | 26025 | 17799 | 341 |
1801624 | 1801624 | 2021-10-10 | Calhoun | Michigan | 26025 | 17645 | 339 |
1798375 | 1798375 | 2021-10-09 | Calhoun | Michigan | 26025 | 17645 | 339 |
1795126 | 1795126 | 2021-10-08 | Calhoun | Michigan | 26025 | 17645 | 339 |
1791877 | 1791877 | 2021-10-07 | Calhoun | Michigan | 26025 | 17463 | 338 |
1788628 | 1788628 | 2021-10-06 | Calhoun | Michigan | 26025 | 17463 | 338 |
1785380 | 1785380 | 2021-10-05 | Calhoun | Michigan | 26025 | 17314 | 337 |
1782131 | 1782131 | 2021-10-04 | Calhoun | Michigan | 26025 | 17314 | 337 |
1778881 | 1778881 | 2021-10-03 | Calhoun | Michigan | 26025 | 17135 | 337 |
1775631 | 1775631 | 2021-10-02 | Calhoun | Michigan | 26025 | 17135 | 337 |
1772381 | 1772381 | 2021-10-01 | Calhoun | Michigan | 26025 | 17135 | 337 |
1769132 | 1769132 | 2021-09-30 | Calhoun | Michigan | 26025 | 16966 | 337 |
1765883 | 1765883 | 2021-09-29 | Calhoun | Michigan | 26025 | 16966 | 337 |
1762634 | 1762634 | 2021-09-28 | Calhoun | Michigan | 26025 | 16845 | 335 |
1759385 | 1759385 | 2021-09-27 | Calhoun | Michigan | 26025 | 16845 | 335 |
1756137 | 1756137 | 2021-09-26 | Calhoun | Michigan | 26025 | 16708 | 334 |
1752889 | 1752889 | 2021-09-25 | Calhoun | Michigan | 26025 | 16708 | 334 |
1749641 | 1749641 | 2021-09-24 | Calhoun | Michigan | 26025 | 16708 | 334 |
1746391 | 1746391 | 2021-09-23 | Calhoun | Michigan | 26025 | 16589 | 334 |
1743142 | 1743142 | 2021-09-22 | Calhoun | Michigan | 26025 | 16589 | 334 |
1739893 | 1739893 | 2021-09-21 | Calhoun | Michigan | 26025 | 16445 | 333 |
1736644 | 1736644 | 2021-09-20 | Calhoun | Michigan | 26025 | 16445 | 333 |
1733394 | 1733394 | 2021-09-19 | Calhoun | Michigan | 26025 | 16345 | 332 |
1730144 | 1730144 | 2021-09-18 | Calhoun | Michigan | 26025 | 16345 | 332 |
1726894 | 1726894 | 2021-09-17 | Calhoun | Michigan | 26025 | 16345 | 332 |
1723645 | 1723645 | 2021-09-16 | Calhoun | Michigan | 26025 | 16232 | 332 |
1720396 | 1720396 | 2021-09-15 | Calhoun | Michigan | 26025 | 16232 | 332 |
1717148 | 1717148 | 2021-09-14 | Calhoun | Michigan | 26025 | 16113 | 332 |
1713900 | 1713900 | 2021-09-13 | Calhoun | Michigan | 26025 | 16113 | 332 |
1710654 | 1710654 | 2021-09-12 | Calhoun | Michigan | 26025 | 15987 | 331 |
1707407 | 1707407 | 2021-09-11 | Calhoun | Michigan | 26025 | 15987 | 331 |
1704160 | 1704160 | 2021-09-10 | Calhoun | Michigan | 26025 | 15987 | 331 |
1700910 | 1700910 | 2021-09-09 | Calhoun | Michigan | 26025 | 15848 | 328 |
1697661 | 1697661 | 2021-09-08 | Calhoun | Michigan | 26025 | 15848 | 328 |
1694413 | 1694413 | 2021-09-07 | Calhoun | Michigan | 26025 | 15759 | 327 |
1691164 | 1691164 | 2021-09-06 | Calhoun | Michigan | 26025 | 15663 | 327 |
1687914 | 1687914 | 2021-09-05 | Calhoun | Michigan | 26025 | 15663 | 327 |
1684664 | 1684664 | 2021-09-04 | Calhoun | Michigan | 26025 | 15663 | 327 |
1681413 | 1681413 | 2021-09-03 | Calhoun | Michigan | 26025 | 15663 | 327 |
1678165 | 1678165 | 2021-09-02 | Calhoun | Michigan | 26025 | 15578 | 327 |
1674917 | 1674917 | 2021-09-01 | Calhoun | Michigan | 26025 | 15578 | 327 |
1671669 | 1671669 | 2021-08-31 | Calhoun | Michigan | 26025 | 15513 | 327 |
1668422 | 1668422 | 2021-08-30 | Calhoun | Michigan | 26025 | 15513 | 327 |
1665175 | 1665175 | 2021-08-29 | Calhoun | Michigan | 26025 | 15423 | 327 |
1661927 | 1661927 | 2021-08-28 | Calhoun | Michigan | 26025 | 15423 | 327 |
1658679 | 1658679 | 2021-08-27 | Calhoun | Michigan | 26025 | 15423 | 327 |
1655430 | 1655430 | 2021-08-26 | Calhoun | Michigan | 26025 | 15347 | 326 |
1652183 | 1652183 | 2021-08-25 | Calhoun | Michigan | 26025 | 15347 | 326 |
1648935 | 1648935 | 2021-08-24 | Calhoun | Michigan | 26025 | 15265 | 325 |
1645686 | 1645686 | 2021-08-23 | Calhoun | Michigan | 26025 | 15265 | 325 |
1642437 | 1642437 | 2021-08-22 | Calhoun | Michigan | 26025 | 15195 | 325 |
1639187 | 1639187 | 2021-08-21 | Calhoun | Michigan | 26025 | 15195 | 325 |
1635937 | 1635937 | 2021-08-20 | Calhoun | Michigan | 26025 | 15195 | 325 |
1632687 | 1632687 | 2021-08-19 | Calhoun | Michigan | 26025 | 15119 | 324 |
1629440 | 1629440 | 2021-08-18 | Calhoun | Michigan | 26025 | 15119 | 324 |
1626193 | 1626193 | 2021-08-17 | Calhoun | Michigan | 26025 | 15084 | 322 |
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);