ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Montcalm" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175497 | 2175497 | 2022-02-02 | Montcalm | Michigan | 26117 | 16402 | 194 |
2172244 | 2172244 | 2022-02-01 | Montcalm | Michigan | 26117 | 16164 | 192 |
2168991 | 2168991 | 2022-01-31 | Montcalm | Michigan | 26117 | 16164 | 192 |
2165736 | 2165736 | 2022-01-30 | Montcalm | Michigan | 26117 | 15944 | 192 |
2162481 | 2162481 | 2022-01-29 | Montcalm | Michigan | 26117 | 15944 | 192 |
2159226 | 2159226 | 2022-01-28 | Montcalm | Michigan | 26117 | 15944 | 192 |
2155972 | 2155972 | 2022-01-27 | Montcalm | Michigan | 26117 | 15695 | 190 |
2152719 | 2152719 | 2022-01-26 | Montcalm | Michigan | 26117 | 15695 | 190 |
2149467 | 2149467 | 2022-01-25 | Montcalm | Michigan | 26117 | 15457 | 188 |
2146215 | 2146215 | 2022-01-24 | Montcalm | Michigan | 26117 | 15457 | 188 |
2142960 | 2142960 | 2022-01-23 | Montcalm | Michigan | 26117 | 15165 | 188 |
2139705 | 2139705 | 2022-01-22 | Montcalm | Michigan | 26117 | 15165 | 188 |
2136449 | 2136449 | 2022-01-21 | Montcalm | Michigan | 26117 | 15165 | 188 |
2133197 | 2133197 | 2022-01-20 | Montcalm | Michigan | 26117 | 14970 | 187 |
2129944 | 2129944 | 2022-01-19 | Montcalm | Michigan | 26117 | 14970 | 187 |
2126690 | 2126690 | 2022-01-18 | Montcalm | Michigan | 26117 | 14593 | 183 |
2123438 | 2123438 | 2022-01-17 | Montcalm | Michigan | 26117 | 14593 | 183 |
2120186 | 2120186 | 2022-01-16 | Montcalm | Michigan | 26117 | 14593 | 183 |
2116934 | 2116934 | 2022-01-15 | Montcalm | Michigan | 26117 | 14593 | 183 |
2113683 | 2113683 | 2022-01-14 | Montcalm | Michigan | 26117 | 14593 | 183 |
2110431 | 2110431 | 2022-01-13 | Montcalm | Michigan | 26117 | 14428 | 182 |
2107180 | 2107180 | 2022-01-12 | Montcalm | Michigan | 26117 | 14428 | 182 |
2103929 | 2103929 | 2022-01-11 | Montcalm | Michigan | 26117 | 14292 | 178 |
2100678 | 2100678 | 2022-01-10 | Montcalm | Michigan | 26117 | 14292 | 178 |
2097427 | 2097427 | 2022-01-09 | Montcalm | Michigan | 26117 | 14160 | 177 |
2094175 | 2094175 | 2022-01-08 | Montcalm | Michigan | 26117 | 14160 | 177 |
2090923 | 2090923 | 2022-01-07 | Montcalm | Michigan | 26117 | 14160 | 177 |
2087672 | 2087672 | 2022-01-06 | Montcalm | Michigan | 26117 | 14022 | 175 |
2084420 | 2084420 | 2022-01-05 | Montcalm | Michigan | 26117 | 14022 | 175 |
2081168 | 2081168 | 2022-01-04 | Montcalm | Michigan | 26117 | 13927 | 174 |
2077916 | 2077916 | 2022-01-03 | Montcalm | Michigan | 26117 | 13927 | 174 |
2074665 | 2074665 | 2022-01-02 | Montcalm | Michigan | 26117 | 13737 | 171 |
2071414 | 2071414 | 2022-01-01 | Montcalm | Michigan | 26117 | 13737 | 171 |
2068163 | 2068163 | 2021-12-31 | Montcalm | Michigan | 26117 | 13737 | 171 |
2064912 | 2064912 | 2021-12-30 | Montcalm | Michigan | 26117 | 13737 | 171 |
2061662 | 2061662 | 2021-12-29 | Montcalm | Michigan | 26117 | 13737 | 171 |
2058413 | 2058413 | 2021-12-28 | Montcalm | Michigan | 26117 | 13673 | 168 |
2055164 | 2055164 | 2021-12-27 | Montcalm | Michigan | 26117 | 13673 | 168 |
2051914 | 2051914 | 2021-12-26 | Montcalm | Michigan | 26117 | 13559 | 166 |
2048664 | 2048664 | 2021-12-25 | Montcalm | Michigan | 26117 | 13559 | 166 |
2045414 | 2045414 | 2021-12-24 | Montcalm | Michigan | 26117 | 13559 | 166 |
2042164 | 2042164 | 2021-12-23 | Montcalm | Michigan | 26117 | 13559 | 166 |
2038915 | 2038915 | 2021-12-22 | Montcalm | Michigan | 26117 | 13559 | 166 |
2035665 | 2035665 | 2021-12-21 | Montcalm | Michigan | 26117 | 13507 | 164 |
2032415 | 2032415 | 2021-12-20 | Montcalm | Michigan | 26117 | 13507 | 164 |
2029164 | 2029164 | 2021-12-19 | Montcalm | Michigan | 26117 | 13404 | 163 |
2025913 | 2025913 | 2021-12-18 | Montcalm | Michigan | 26117 | 13404 | 163 |
2022662 | 2022662 | 2021-12-17 | Montcalm | Michigan | 26117 | 13404 | 163 |
2019411 | 2019411 | 2021-12-16 | Montcalm | Michigan | 26117 | 13307 | 160 |
2016161 | 2016161 | 2021-12-15 | Montcalm | Michigan | 26117 | 13307 | 160 |
2012910 | 2012910 | 2021-12-14 | Montcalm | Michigan | 26117 | 13212 | 159 |
2009659 | 2009659 | 2021-12-13 | Montcalm | Michigan | 26117 | 13212 | 159 |
2006408 | 2006408 | 2021-12-12 | Montcalm | Michigan | 26117 | 13099 | 157 |
2003157 | 2003157 | 2021-12-11 | Montcalm | Michigan | 26117 | 13099 | 157 |
1999907 | 1999907 | 2021-12-10 | Montcalm | Michigan | 26117 | 13099 | 157 |
1996656 | 1996656 | 2021-12-09 | Montcalm | Michigan | 26117 | 12987 | 156 |
1993405 | 1993405 | 2021-12-08 | Montcalm | Michigan | 26117 | 12987 | 156 |
1990154 | 1990154 | 2021-12-07 | Montcalm | Michigan | 26117 | 12891 | 155 |
1986904 | 1986904 | 2021-12-06 | Montcalm | Michigan | 26117 | 12891 | 155 |
1983654 | 1983654 | 2021-12-05 | Montcalm | Michigan | 26117 | 12769 | 154 |
1980404 | 1980404 | 2021-12-04 | Montcalm | Michigan | 26117 | 12769 | 154 |
1977154 | 1977154 | 2021-12-03 | Montcalm | Michigan | 26117 | 12769 | 154 |
1973904 | 1973904 | 2021-12-02 | Montcalm | Michigan | 26117 | 12641 | 153 |
1970655 | 1970655 | 2021-12-01 | Montcalm | Michigan | 26117 | 12641 | 153 |
1967405 | 1967405 | 2021-11-30 | Montcalm | Michigan | 26117 | 12520 | 151 |
1964153 | 1964153 | 2021-11-29 | Montcalm | Michigan | 26117 | 12520 | 151 |
1960902 | 1960902 | 2021-11-28 | Montcalm | Michigan | 26117 | 12325 | 149 |
1957651 | 1957651 | 2021-11-27 | Montcalm | Michigan | 26117 | 12325 | 149 |
1954400 | 1954400 | 2021-11-26 | Montcalm | Michigan | 26117 | 12325 | 149 |
1951149 | 1951149 | 2021-11-25 | Montcalm | Michigan | 26117 | 12325 | 149 |
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 |
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);