ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Montcalm" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947898 | 1947898 | 2021-11-24 | Montcalm | Michigan | 26117 | 12325 | 149 |
1944647 | 1944647 | 2021-11-23 | Montcalm | Michigan | 26117 | 12203 | 144 |
1941396 | 1941396 | 2021-11-22 | Montcalm | Michigan | 26117 | 12203 | 144 |
1938146 | 1938146 | 2021-11-21 | Montcalm | Michigan | 26117 | 12026 | 144 |
1934896 | 1934896 | 2021-11-20 | Montcalm | Michigan | 26117 | 12026 | 144 |
1931646 | 1931646 | 2021-11-19 | Montcalm | Michigan | 26117 | 12026 | 144 |
1928395 | 1928395 | 2021-11-18 | Montcalm | Michigan | 26117 | 11848 | 143 |
1925145 | 1925145 | 2021-11-17 | Montcalm | Michigan | 26117 | 11848 | 143 |
1921896 | 1921896 | 2021-11-16 | Montcalm | Michigan | 26117 | 11727 | 140 |
1918646 | 1918646 | 2021-11-15 | Montcalm | Michigan | 26117 | 11727 | 140 |
1915396 | 1915396 | 2021-11-14 | Montcalm | Michigan | 26117 | 11520 | 140 |
1912146 | 1912146 | 2021-11-13 | Montcalm | Michigan | 26117 | 11520 | 140 |
1908896 | 1908896 | 2021-11-12 | Montcalm | Michigan | 26117 | 11520 | 140 |
1905647 | 1905647 | 2021-11-11 | Montcalm | Michigan | 26117 | 11352 | 138 |
1902398 | 1902398 | 2021-11-10 | Montcalm | Michigan | 26117 | 11352 | 138 |
1899148 | 1899148 | 2021-11-09 | Montcalm | Michigan | 26117 | 11294 | 138 |
1895898 | 1895898 | 2021-11-08 | Montcalm | Michigan | 26117 | 11294 | 138 |
1892648 | 1892648 | 2021-11-07 | Montcalm | Michigan | 26117 | 11195 | 137 |
1889398 | 1889398 | 2021-11-06 | Montcalm | Michigan | 26117 | 11195 | 137 |
1886148 | 1886148 | 2021-11-05 | Montcalm | Michigan | 26117 | 11195 | 137 |
1882899 | 1882899 | 2021-11-04 | Montcalm | Michigan | 26117 | 11104 | 137 |
1879650 | 1879650 | 2021-11-03 | Montcalm | Michigan | 26117 | 11104 | 137 |
1876401 | 1876401 | 2021-11-02 | Montcalm | Michigan | 26117 | 11006 | 134 |
1873152 | 1873152 | 2021-11-01 | Montcalm | Michigan | 26117 | 11006 | 134 |
1869903 | 1869903 | 2021-10-31 | Montcalm | Michigan | 26117 | 10921 | 133 |
1866654 | 1866654 | 2021-10-30 | Montcalm | Michigan | 26117 | 10921 | 133 |
1863405 | 1863405 | 2021-10-29 | Montcalm | Michigan | 26117 | 10921 | 133 |
1860156 | 1860156 | 2021-10-28 | Montcalm | Michigan | 26117 | 10856 | 133 |
1856907 | 1856907 | 2021-10-27 | Montcalm | Michigan | 26117 | 10856 | 133 |
1853658 | 1853658 | 2021-10-26 | Montcalm | Michigan | 26117 | 10755 | 133 |
1850409 | 1850409 | 2021-10-25 | Montcalm | Michigan | 26117 | 10755 | 133 |
1847159 | 1847159 | 2021-10-24 | Montcalm | Michigan | 26117 | 10644 | 132 |
1843909 | 1843909 | 2021-10-23 | Montcalm | Michigan | 26117 | 10644 | 132 |
1840659 | 1840659 | 2021-10-22 | Montcalm | Michigan | 26117 | 10644 | 132 |
1837410 | 1837410 | 2021-10-21 | Montcalm | Michigan | 26117 | 10508 | 130 |
1834161 | 1834161 | 2021-10-20 | Montcalm | Michigan | 26117 | 10508 | 130 |
1830912 | 1830912 | 2021-10-19 | Montcalm | Michigan | 26117 | 10414 | 129 |
1827663 | 1827663 | 2021-10-18 | Montcalm | Michigan | 26117 | 10414 | 129 |
1824414 | 1824414 | 2021-10-17 | Montcalm | Michigan | 26117 | 10275 | 129 |
1821165 | 1821165 | 2021-10-16 | Montcalm | Michigan | 26117 | 10275 | 129 |
1817916 | 1817916 | 2021-10-15 | Montcalm | Michigan | 26117 | 10275 | 129 |
1814667 | 1814667 | 2021-10-14 | Montcalm | Michigan | 26117 | 10149 | 128 |
1811419 | 1811419 | 2021-10-13 | Montcalm | Michigan | 26117 | 10149 | 128 |
1808170 | 1808170 | 2021-10-12 | Montcalm | Michigan | 26117 | 10009 | 128 |
1804919 | 1804919 | 2021-10-11 | Montcalm | Michigan | 26117 | 10009 | 128 |
1801670 | 1801670 | 2021-10-10 | Montcalm | Michigan | 26117 | 9870 | 128 |
1798421 | 1798421 | 2021-10-09 | Montcalm | Michigan | 26117 | 9870 | 128 |
1795172 | 1795172 | 2021-10-08 | Montcalm | Michigan | 26117 | 9870 | 128 |
1791923 | 1791923 | 2021-10-07 | Montcalm | Michigan | 26117 | 9715 | 128 |
1788674 | 1788674 | 2021-10-06 | Montcalm | Michigan | 26117 | 9715 | 128 |
1785426 | 1785426 | 2021-10-05 | Montcalm | Michigan | 26117 | 9597 | 128 |
1782177 | 1782177 | 2021-10-04 | Montcalm | Michigan | 26117 | 9597 | 128 |
1778927 | 1778927 | 2021-10-03 | Montcalm | Michigan | 26117 | 9469 | 128 |
1775677 | 1775677 | 2021-10-02 | Montcalm | Michigan | 26117 | 9469 | 128 |
1772427 | 1772427 | 2021-10-01 | Montcalm | Michigan | 26117 | 9469 | 128 |
1769178 | 1769178 | 2021-09-30 | Montcalm | Michigan | 26117 | 9373 | 128 |
1765929 | 1765929 | 2021-09-29 | Montcalm | Michigan | 26117 | 9373 | 128 |
1762680 | 1762680 | 2021-09-28 | Montcalm | Michigan | 26117 | 9283 | 128 |
1759431 | 1759431 | 2021-09-27 | Montcalm | Michigan | 26117 | 9283 | 128 |
1756183 | 1756183 | 2021-09-26 | Montcalm | Michigan | 26117 | 9193 | 127 |
1752935 | 1752935 | 2021-09-25 | Montcalm | Michigan | 26117 | 9193 | 127 |
1749687 | 1749687 | 2021-09-24 | Montcalm | Michigan | 26117 | 9193 | 127 |
1746437 | 1746437 | 2021-09-23 | Montcalm | Michigan | 26117 | 9125 | 126 |
1743188 | 1743188 | 2021-09-22 | Montcalm | Michigan | 26117 | 9125 | 126 |
1739939 | 1739939 | 2021-09-21 | Montcalm | Michigan | 26117 | 9052 | 127 |
1736690 | 1736690 | 2021-09-20 | Montcalm | Michigan | 26117 | 9052 | 127 |
1733440 | 1733440 | 2021-09-19 | Montcalm | Michigan | 26117 | 8947 | 127 |
1730190 | 1730190 | 2021-09-18 | Montcalm | Michigan | 26117 | 8947 | 127 |
1726940 | 1726940 | 2021-09-17 | Montcalm | Michigan | 26117 | 8947 | 127 |
1723691 | 1723691 | 2021-09-16 | Montcalm | Michigan | 26117 | 8876 | 127 |
1720442 | 1720442 | 2021-09-15 | Montcalm | Michigan | 26117 | 8876 | 127 |
1717194 | 1717194 | 2021-09-14 | Montcalm | Michigan | 26117 | 8800 | 126 |
1713946 | 1713946 | 2021-09-13 | Montcalm | Michigan | 26117 | 8800 | 126 |
1710700 | 1710700 | 2021-09-12 | Montcalm | Michigan | 26117 | 8744 | 126 |
1707453 | 1707453 | 2021-09-11 | Montcalm | Michigan | 26117 | 8744 | 126 |
1704206 | 1704206 | 2021-09-10 | Montcalm | Michigan | 26117 | 8744 | 126 |
1700956 | 1700956 | 2021-09-09 | Montcalm | Michigan | 26117 | 8686 | 126 |
1697707 | 1697707 | 2021-09-08 | Montcalm | Michigan | 26117 | 8686 | 126 |
1694459 | 1694459 | 2021-09-07 | Montcalm | Michigan | 26117 | 8666 | 125 |
1691210 | 1691210 | 2021-09-06 | Montcalm | Michigan | 26117 | 8612 | 124 |
1687960 | 1687960 | 2021-09-05 | Montcalm | Michigan | 26117 | 8612 | 124 |
1684710 | 1684710 | 2021-09-04 | Montcalm | Michigan | 26117 | 8612 | 124 |
1681459 | 1681459 | 2021-09-03 | Montcalm | Michigan | 26117 | 8612 | 124 |
1678211 | 1678211 | 2021-09-02 | Montcalm | Michigan | 26117 | 8567 | 123 |
1674963 | 1674963 | 2021-09-01 | Montcalm | Michigan | 26117 | 8567 | 123 |
1671715 | 1671715 | 2021-08-31 | Montcalm | Michigan | 26117 | 8533 | 123 |
1668468 | 1668468 | 2021-08-30 | Montcalm | Michigan | 26117 | 8533 | 123 |
1665221 | 1665221 | 2021-08-29 | Montcalm | Michigan | 26117 | 8485 | 123 |
1661973 | 1661973 | 2021-08-28 | Montcalm | Michigan | 26117 | 8485 | 123 |
1658725 | 1658725 | 2021-08-27 | Montcalm | Michigan | 26117 | 8485 | 123 |
1655476 | 1655476 | 2021-08-26 | Montcalm | Michigan | 26117 | 8452 | 122 |
1652229 | 1652229 | 2021-08-25 | Montcalm | Michigan | 26117 | 8452 | 122 |
1648981 | 1648981 | 2021-08-24 | Montcalm | Michigan | 26117 | 8417 | 122 |
1645732 | 1645732 | 2021-08-23 | Montcalm | Michigan | 26117 | 8417 | 122 |
1642483 | 1642483 | 2021-08-22 | Montcalm | Michigan | 26117 | 8370 | 122 |
1639233 | 1639233 | 2021-08-21 | Montcalm | Michigan | 26117 | 8370 | 122 |
1635983 | 1635983 | 2021-08-20 | Montcalm | Michigan | 26117 | 8370 | 122 |
1632733 | 1632733 | 2021-08-19 | Montcalm | Michigan | 26117 | 8343 | 122 |
1629486 | 1629486 | 2021-08-18 | Montcalm | Michigan | 26117 | 8343 | 122 |
1626239 | 1626239 | 2021-08-17 | Montcalm | Michigan | 26117 | 8311 | 122 |
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);