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 |
---|---|---|---|---|---|---|---|
2175451 | 2175451 | 2022-02-02 | Calhoun | Michigan | 26025 | 32504 | 526 |
2172198 | 2172198 | 2022-02-01 | Calhoun | Michigan | 26025 | 32116 | 524 |
2168945 | 2168945 | 2022-01-31 | Calhoun | Michigan | 26025 | 32116 | 524 |
2165690 | 2165690 | 2022-01-30 | Calhoun | Michigan | 26025 | 31807 | 523 |
2162435 | 2162435 | 2022-01-29 | Calhoun | Michigan | 26025 | 31807 | 523 |
2159180 | 2159180 | 2022-01-28 | Calhoun | Michigan | 26025 | 31807 | 523 |
2155926 | 2155926 | 2022-01-27 | Calhoun | Michigan | 26025 | 31381 | 522 |
2152673 | 2152673 | 2022-01-26 | Calhoun | Michigan | 26025 | 31381 | 522 |
2149421 | 2149421 | 2022-01-25 | Calhoun | Michigan | 26025 | 30755 | 515 |
2146169 | 2146169 | 2022-01-24 | Calhoun | Michigan | 26025 | 30755 | 515 |
2142914 | 2142914 | 2022-01-23 | Calhoun | Michigan | 26025 | 30098 | 512 |
2139659 | 2139659 | 2022-01-22 | Calhoun | Michigan | 26025 | 30098 | 512 |
2136403 | 2136403 | 2022-01-21 | Calhoun | Michigan | 26025 | 30098 | 512 |
2133151 | 2133151 | 2022-01-20 | Calhoun | Michigan | 26025 | 29427 | 511 |
2129898 | 2129898 | 2022-01-19 | Calhoun | Michigan | 26025 | 29427 | 511 |
2126644 | 2126644 | 2022-01-18 | Calhoun | Michigan | 26025 | 27744 | 496 |
2123392 | 2123392 | 2022-01-17 | Calhoun | Michigan | 26025 | 27744 | 496 |
2120140 | 2120140 | 2022-01-16 | Calhoun | Michigan | 26025 | 27744 | 496 |
2116888 | 2116888 | 2022-01-15 | Calhoun | Michigan | 26025 | 27744 | 496 |
2113637 | 2113637 | 2022-01-14 | Calhoun | Michigan | 26025 | 27744 | 496 |
2110385 | 2110385 | 2022-01-13 | Calhoun | Michigan | 26025 | 27223 | 491 |
2107134 | 2107134 | 2022-01-12 | Calhoun | Michigan | 26025 | 27223 | 491 |
2103883 | 2103883 | 2022-01-11 | Calhoun | Michigan | 26025 | 26717 | 487 |
2100632 | 2100632 | 2022-01-10 | Calhoun | Michigan | 26025 | 26717 | 487 |
2097381 | 2097381 | 2022-01-09 | Calhoun | Michigan | 26025 | 26203 | 486 |
2094129 | 2094129 | 2022-01-08 | Calhoun | Michigan | 26025 | 26203 | 486 |
2090877 | 2090877 | 2022-01-07 | Calhoun | Michigan | 26025 | 26203 | 486 |
2087626 | 2087626 | 2022-01-06 | Calhoun | Michigan | 26025 | 25703 | 478 |
2084374 | 2084374 | 2022-01-05 | Calhoun | Michigan | 26025 | 25703 | 478 |
2081122 | 2081122 | 2022-01-04 | Calhoun | Michigan | 26025 | 25372 | 469 |
2077870 | 2077870 | 2022-01-03 | Calhoun | Michigan | 26025 | 25372 | 469 |
2074619 | 2074619 | 2022-01-02 | Calhoun | Michigan | 26025 | 24824 | 462 |
2071368 | 2071368 | 2022-01-01 | Calhoun | Michigan | 26025 | 24824 | 462 |
2068117 | 2068117 | 2021-12-31 | Calhoun | Michigan | 26025 | 24824 | 462 |
2064866 | 2064866 | 2021-12-30 | Calhoun | Michigan | 26025 | 24824 | 462 |
2061616 | 2061616 | 2021-12-29 | Calhoun | Michigan | 26025 | 24824 | 462 |
2058367 | 2058367 | 2021-12-28 | Calhoun | Michigan | 26025 | 24614 | 459 |
2055118 | 2055118 | 2021-12-27 | Calhoun | Michigan | 26025 | 24614 | 459 |
2051868 | 2051868 | 2021-12-26 | Calhoun | Michigan | 26025 | 24376 | 456 |
2048618 | 2048618 | 2021-12-25 | Calhoun | Michigan | 26025 | 24376 | 456 |
2045368 | 2045368 | 2021-12-24 | Calhoun | Michigan | 26025 | 24376 | 456 |
2042118 | 2042118 | 2021-12-23 | Calhoun | Michigan | 26025 | 24376 | 456 |
2038869 | 2038869 | 2021-12-22 | Calhoun | Michigan | 26025 | 24376 | 456 |
2035619 | 2035619 | 2021-12-21 | Calhoun | Michigan | 26025 | 24199 | 446 |
2032369 | 2032369 | 2021-12-20 | Calhoun | Michigan | 26025 | 24199 | 446 |
2029118 | 2029118 | 2021-12-19 | Calhoun | Michigan | 26025 | 24049 | 443 |
2025867 | 2025867 | 2021-12-18 | Calhoun | Michigan | 26025 | 24049 | 443 |
2022616 | 2022616 | 2021-12-17 | Calhoun | Michigan | 26025 | 24049 | 443 |
2019365 | 2019365 | 2021-12-16 | Calhoun | Michigan | 26025 | 23869 | 438 |
2016115 | 2016115 | 2021-12-15 | Calhoun | Michigan | 26025 | 23869 | 438 |
2012864 | 2012864 | 2021-12-14 | Calhoun | Michigan | 26025 | 23670 | 430 |
2009613 | 2009613 | 2021-12-13 | Calhoun | Michigan | 26025 | 23670 | 430 |
2006362 | 2006362 | 2021-12-12 | Calhoun | Michigan | 26025 | 23415 | 425 |
2003111 | 2003111 | 2021-12-11 | Calhoun | Michigan | 26025 | 23415 | 425 |
1999861 | 1999861 | 2021-12-10 | Calhoun | Michigan | 26025 | 23415 | 425 |
1996610 | 1996610 | 2021-12-09 | Calhoun | Michigan | 26025 | 23161 | 419 |
1993359 | 1993359 | 2021-12-08 | Calhoun | Michigan | 26025 | 23161 | 419 |
1990108 | 1990108 | 2021-12-07 | Calhoun | Michigan | 26025 | 22819 | 414 |
1986858 | 1986858 | 2021-12-06 | Calhoun | Michigan | 26025 | 22819 | 414 |
1983608 | 1983608 | 2021-12-05 | Calhoun | Michigan | 26025 | 22567 | 407 |
1980358 | 1980358 | 2021-12-04 | Calhoun | Michigan | 26025 | 22567 | 407 |
1977108 | 1977108 | 2021-12-03 | Calhoun | Michigan | 26025 | 22567 | 407 |
1973858 | 1973858 | 2021-12-02 | Calhoun | Michigan | 26025 | 22197 | 401 |
1970609 | 1970609 | 2021-12-01 | Calhoun | Michigan | 26025 | 22197 | 401 |
1967359 | 1967359 | 2021-11-30 | Calhoun | Michigan | 26025 | 21794 | 393 |
1964107 | 1964107 | 2021-11-29 | Calhoun | Michigan | 26025 | 21794 | 393 |
1960856 | 1960856 | 2021-11-28 | Calhoun | Michigan | 26025 | 21430 | 384 |
1957605 | 1957605 | 2021-11-27 | Calhoun | Michigan | 26025 | 21430 | 384 |
1954354 | 1954354 | 2021-11-26 | Calhoun | Michigan | 26025 | 21430 | 384 |
1951103 | 1951103 | 2021-11-25 | Calhoun | Michigan | 26025 | 21430 | 384 |
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 |
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);