ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 26115 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175496 | 2175496 | 2022-02-02 | Monroe | Michigan | 26115 | 36556 | 427 |
2172243 | 2172243 | 2022-02-01 | Monroe | Michigan | 26115 | 36243 | 419 |
2168990 | 2168990 | 2022-01-31 | Monroe | Michigan | 26115 | 36243 | 419 |
2165735 | 2165735 | 2022-01-30 | Monroe | Michigan | 26115 | 35968 | 419 |
2162480 | 2162480 | 2022-01-29 | Monroe | Michigan | 26115 | 35968 | 419 |
2159225 | 2159225 | 2022-01-28 | Monroe | Michigan | 26115 | 35968 | 419 |
2155971 | 2155971 | 2022-01-27 | Monroe | Michigan | 26115 | 35650 | 414 |
2152718 | 2152718 | 2022-01-26 | Monroe | Michigan | 26115 | 35650 | 414 |
2149466 | 2149466 | 2022-01-25 | Monroe | Michigan | 26115 | 35212 | 407 |
2146214 | 2146214 | 2022-01-24 | Monroe | Michigan | 26115 | 35212 | 407 |
2142959 | 2142959 | 2022-01-23 | Monroe | Michigan | 26115 | 34528 | 408 |
2139704 | 2139704 | 2022-01-22 | Monroe | Michigan | 26115 | 34528 | 408 |
2136448 | 2136448 | 2022-01-21 | Monroe | Michigan | 26115 | 34528 | 408 |
2133196 | 2133196 | 2022-01-20 | Monroe | Michigan | 26115 | 33819 | 403 |
2129943 | 2129943 | 2022-01-19 | Monroe | Michigan | 26115 | 33819 | 403 |
2126689 | 2126689 | 2022-01-18 | Monroe | Michigan | 26115 | 32120 | 394 |
2123437 | 2123437 | 2022-01-17 | Monroe | Michigan | 26115 | 32120 | 394 |
2120185 | 2120185 | 2022-01-16 | Monroe | Michigan | 26115 | 32120 | 394 |
2116933 | 2116933 | 2022-01-15 | Monroe | Michigan | 26115 | 32120 | 394 |
2113682 | 2113682 | 2022-01-14 | Monroe | Michigan | 26115 | 32120 | 394 |
2110430 | 2110430 | 2022-01-13 | Monroe | Michigan | 26115 | 31462 | 391 |
2107179 | 2107179 | 2022-01-12 | Monroe | Michigan | 26115 | 31462 | 391 |
2103928 | 2103928 | 2022-01-11 | Monroe | Michigan | 26115 | 30802 | 387 |
2100677 | 2100677 | 2022-01-10 | Monroe | Michigan | 26115 | 30802 | 387 |
2097426 | 2097426 | 2022-01-09 | Monroe | Michigan | 26115 | 29675 | 386 |
2094174 | 2094174 | 2022-01-08 | Monroe | Michigan | 26115 | 29675 | 386 |
2090922 | 2090922 | 2022-01-07 | Monroe | Michigan | 26115 | 29675 | 386 |
2087671 | 2087671 | 2022-01-06 | Monroe | Michigan | 26115 | 28685 | 377 |
2084419 | 2084419 | 2022-01-05 | Monroe | Michigan | 26115 | 28685 | 377 |
2081167 | 2081167 | 2022-01-04 | Monroe | Michigan | 26115 | 28249 | 375 |
2077915 | 2077915 | 2022-01-03 | Monroe | Michigan | 26115 | 28249 | 375 |
2074664 | 2074664 | 2022-01-02 | Monroe | Michigan | 26115 | 27232 | 372 |
2071413 | 2071413 | 2022-01-01 | Monroe | Michigan | 26115 | 27232 | 372 |
2068162 | 2068162 | 2021-12-31 | Monroe | Michigan | 26115 | 27232 | 372 |
2064911 | 2064911 | 2021-12-30 | Monroe | Michigan | 26115 | 27232 | 372 |
2061661 | 2061661 | 2021-12-29 | Monroe | Michigan | 26115 | 27232 | 372 |
2058412 | 2058412 | 2021-12-28 | Monroe | Michigan | 26115 | 26834 | 369 |
2055163 | 2055163 | 2021-12-27 | Monroe | Michigan | 26115 | 26834 | 369 |
2051913 | 2051913 | 2021-12-26 | Monroe | Michigan | 26115 | 26422 | 364 |
2048663 | 2048663 | 2021-12-25 | Monroe | Michigan | 26115 | 26422 | 364 |
2045413 | 2045413 | 2021-12-24 | Monroe | Michigan | 26115 | 26422 | 364 |
2042163 | 2042163 | 2021-12-23 | Monroe | Michigan | 26115 | 26422 | 364 |
2038914 | 2038914 | 2021-12-22 | Monroe | Michigan | 26115 | 26422 | 364 |
2035664 | 2035664 | 2021-12-21 | Monroe | Michigan | 26115 | 26188 | 360 |
2032414 | 2032414 | 2021-12-20 | Monroe | Michigan | 26115 | 26188 | 360 |
2029163 | 2029163 | 2021-12-19 | Monroe | Michigan | 26115 | 25935 | 354 |
2025912 | 2025912 | 2021-12-18 | Monroe | Michigan | 26115 | 25935 | 354 |
2022661 | 2022661 | 2021-12-17 | Monroe | Michigan | 26115 | 25935 | 354 |
2019410 | 2019410 | 2021-12-16 | Monroe | Michigan | 26115 | 25670 | 349 |
2016160 | 2016160 | 2021-12-15 | Monroe | Michigan | 26115 | 25670 | 349 |
2012909 | 2012909 | 2021-12-14 | Monroe | Michigan | 26115 | 25413 | 345 |
2009658 | 2009658 | 2021-12-13 | Monroe | Michigan | 26115 | 25413 | 345 |
2006407 | 2006407 | 2021-12-12 | Monroe | Michigan | 26115 | 25138 | 345 |
2003156 | 2003156 | 2021-12-11 | Monroe | Michigan | 26115 | 25138 | 345 |
1999906 | 1999906 | 2021-12-10 | Monroe | Michigan | 26115 | 25138 | 345 |
1996655 | 1996655 | 2021-12-09 | Monroe | Michigan | 26115 | 24962 | 342 |
1993404 | 1993404 | 2021-12-08 | Monroe | Michigan | 26115 | 24962 | 342 |
1990153 | 1990153 | 2021-12-07 | Monroe | Michigan | 26115 | 24641 | 337 |
1986903 | 1986903 | 2021-12-06 | Monroe | Michigan | 26115 | 24641 | 337 |
1983653 | 1983653 | 2021-12-05 | Monroe | Michigan | 26115 | 24406 | 337 |
1980403 | 1980403 | 2021-12-04 | Monroe | Michigan | 26115 | 24406 | 337 |
1977153 | 1977153 | 2021-12-03 | Monroe | Michigan | 26115 | 24406 | 337 |
1973903 | 1973903 | 2021-12-02 | Monroe | Michigan | 26115 | 24044 | 333 |
1970654 | 1970654 | 2021-12-01 | Monroe | Michigan | 26115 | 24044 | 333 |
1967404 | 1967404 | 2021-11-30 | Monroe | Michigan | 26115 | 23764 | 329 |
1964152 | 1964152 | 2021-11-29 | Monroe | Michigan | 26115 | 23764 | 329 |
1960901 | 1960901 | 2021-11-28 | Monroe | Michigan | 26115 | 23369 | 326 |
1957650 | 1957650 | 2021-11-27 | Monroe | Michigan | 26115 | 23369 | 326 |
1954399 | 1954399 | 2021-11-26 | Monroe | Michigan | 26115 | 23369 | 326 |
1951148 | 1951148 | 2021-11-25 | Monroe | Michigan | 26115 | 23369 | 326 |
1947897 | 1947897 | 2021-11-24 | Monroe | Michigan | 26115 | 23369 | 326 |
1944646 | 1944646 | 2021-11-23 | Monroe | Michigan | 26115 | 23111 | 321 |
1941395 | 1941395 | 2021-11-22 | Monroe | Michigan | 26115 | 23111 | 321 |
1938145 | 1938145 | 2021-11-21 | Monroe | Michigan | 26115 | 22881 | 321 |
1934895 | 1934895 | 2021-11-20 | Monroe | Michigan | 26115 | 22881 | 321 |
1931645 | 1931645 | 2021-11-19 | Monroe | Michigan | 26115 | 22881 | 321 |
1928394 | 1928394 | 2021-11-18 | Monroe | Michigan | 26115 | 22636 | 319 |
1925144 | 1925144 | 2021-11-17 | Monroe | Michigan | 26115 | 22636 | 319 |
1921895 | 1921895 | 2021-11-16 | Monroe | Michigan | 26115 | 22373 | 314 |
1918645 | 1918645 | 2021-11-15 | Monroe | Michigan | 26115 | 22373 | 314 |
1915395 | 1915395 | 2021-11-14 | Monroe | Michigan | 26115 | 21952 | 314 |
1912145 | 1912145 | 2021-11-13 | Monroe | Michigan | 26115 | 21952 | 314 |
1908895 | 1908895 | 2021-11-12 | Monroe | Michigan | 26115 | 21952 | 314 |
1905646 | 1905646 | 2021-11-11 | Monroe | Michigan | 26115 | 21701 | 311 |
1902397 | 1902397 | 2021-11-10 | Monroe | Michigan | 26115 | 21701 | 311 |
1899147 | 1899147 | 2021-11-09 | Monroe | Michigan | 26115 | 21490 | 310 |
1895897 | 1895897 | 2021-11-08 | Monroe | Michigan | 26115 | 21490 | 310 |
1892647 | 1892647 | 2021-11-07 | Monroe | Michigan | 26115 | 21297 | 309 |
1889397 | 1889397 | 2021-11-06 | Monroe | Michigan | 26115 | 21297 | 309 |
1886147 | 1886147 | 2021-11-05 | Monroe | Michigan | 26115 | 21297 | 309 |
1882898 | 1882898 | 2021-11-04 | Monroe | Michigan | 26115 | 21076 | 308 |
1879649 | 1879649 | 2021-11-03 | Monroe | Michigan | 26115 | 21076 | 308 |
1876400 | 1876400 | 2021-11-02 | Monroe | Michigan | 26115 | 20905 | 307 |
1873151 | 1873151 | 2021-11-01 | Monroe | Michigan | 26115 | 20905 | 307 |
1869902 | 1869902 | 2021-10-31 | Monroe | Michigan | 26115 | 20747 | 306 |
1866653 | 1866653 | 2021-10-30 | Monroe | Michigan | 26115 | 20747 | 306 |
1863404 | 1863404 | 2021-10-29 | Monroe | Michigan | 26115 | 20747 | 306 |
1860155 | 1860155 | 2021-10-28 | Monroe | Michigan | 26115 | 20521 | 302 |
1856906 | 1856906 | 2021-10-27 | Monroe | Michigan | 26115 | 20521 | 302 |
1853657 | 1853657 | 2021-10-26 | Monroe | Michigan | 26115 | 20312 | 300 |
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);