ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Washtenaw" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110454 | 2110454 | 2022-01-13 | Washtenaw | Michigan | 26161 | 58416 | 442 |
2107203 | 2107203 | 2022-01-12 | Washtenaw | Michigan | 26161 | 57534 | 440 |
2103952 | 2103952 | 2022-01-11 | Washtenaw | Michigan | 26161 | 56419 | 431 |
2100701 | 2100701 | 2022-01-10 | Washtenaw | Michigan | 26161 | 55888 | 431 |
2097450 | 2097450 | 2022-01-09 | Washtenaw | Michigan | 26161 | 53485 | 426 |
2094198 | 2094198 | 2022-01-08 | Washtenaw | Michigan | 26161 | 53485 | 426 |
2090946 | 2090946 | 2022-01-07 | Washtenaw | Michigan | 26161 | 53485 | 426 |
2087695 | 2087695 | 2022-01-06 | Washtenaw | Michigan | 26161 | 52082 | 420 |
2084443 | 2084443 | 2022-01-05 | Washtenaw | Michigan | 26161 | 51119 | 418 |
2081191 | 2081191 | 2022-01-04 | Washtenaw | Michigan | 26161 | 50150 | 414 |
2077939 | 2077939 | 2022-01-03 | Washtenaw | Michigan | 26161 | 49535 | 414 |
2074688 | 2074688 | 2022-01-02 | Washtenaw | Michigan | 26161 | 47433 | 413 |
2071437 | 2071437 | 2022-01-01 | Washtenaw | Michigan | 26161 | 47433 | 413 |
2068186 | 2068186 | 2021-12-31 | Washtenaw | Michigan | 26161 | 47433 | 413 |
2064935 | 2064935 | 2021-12-30 | Washtenaw | Michigan | 26161 | 47433 | 413 |
2061685 | 2061685 | 2021-12-29 | Washtenaw | Michigan | 26161 | 46619 | 405 |
2058436 | 2058436 | 2021-12-28 | Washtenaw | Michigan | 26161 | 45441 | 401 |
2055187 | 2055187 | 2021-12-27 | Washtenaw | Michigan | 26161 | 45441 | 401 |
2051937 | 2051937 | 2021-12-26 | Washtenaw | Michigan | 26161 | 44113 | 395 |
2048687 | 2048687 | 2021-12-25 | Washtenaw | Michigan | 26161 | 44113 | 395 |
2045437 | 2045437 | 2021-12-24 | Washtenaw | Michigan | 26161 | 44113 | 395 |
2042187 | 2042187 | 2021-12-23 | Washtenaw | Michigan | 26161 | 44113 | 395 |
2038938 | 2038938 | 2021-12-22 | Washtenaw | Michigan | 26161 | 44113 | 395 |
2035688 | 2035688 | 2021-12-21 | Washtenaw | Michigan | 26161 | 43561 | 389 |
2032438 | 2032438 | 2021-12-20 | Washtenaw | Michigan | 26161 | 43561 | 389 |
2029187 | 2029187 | 2021-12-19 | Washtenaw | Michigan | 26161 | 43121 | 387 |
2025936 | 2025936 | 2021-12-18 | Washtenaw | Michigan | 26161 | 43121 | 387 |
2022685 | 2022685 | 2021-12-17 | Washtenaw | Michigan | 26161 | 43121 | 387 |
2019434 | 2019434 | 2021-12-16 | Washtenaw | Michigan | 26161 | 42941 | 382 |
2016184 | 2016184 | 2021-12-15 | Washtenaw | Michigan | 26161 | 42608 | 380 |
2012933 | 2012933 | 2021-12-14 | Washtenaw | Michigan | 26161 | 42437 | 373 |
2009682 | 2009682 | 2021-12-13 | Washtenaw | Michigan | 26161 | 42301 | 373 |
2006431 | 2006431 | 2021-12-12 | Washtenaw | Michigan | 26161 | 41808 | 370 |
2003180 | 2003180 | 2021-12-11 | Washtenaw | Michigan | 26161 | 41808 | 370 |
1999930 | 1999930 | 2021-12-10 | Washtenaw | Michigan | 26161 | 41808 | 370 |
1996679 | 1996679 | 2021-12-09 | Washtenaw | Michigan | 26161 | 41672 | 367 |
1993428 | 1993428 | 2021-12-08 | Washtenaw | Michigan | 26161 | 41318 | 366 |
1990177 | 1990177 | 2021-12-07 | Washtenaw | Michigan | 26161 | 40950 | 364 |
1986927 | 1986927 | 2021-12-06 | Washtenaw | Michigan | 26161 | 40794 | 365 |
1983677 | 1983677 | 2021-12-05 | Washtenaw | Michigan | 26161 | 40288 | 361 |
1980427 | 1980427 | 2021-12-04 | Washtenaw | Michigan | 26161 | 40288 | 361 |
1977177 | 1977177 | 2021-12-03 | Washtenaw | Michigan | 26161 | 40288 | 361 |
1973927 | 1973927 | 2021-12-02 | Washtenaw | Michigan | 26161 | 40030 | 356 |
1970678 | 1970678 | 2021-12-01 | Washtenaw | Michigan | 26161 | 39630 | 356 |
1967428 | 1967428 | 2021-11-30 | Washtenaw | Michigan | 26161 | 39330 | 349 |
1964176 | 1964176 | 2021-11-29 | Washtenaw | Michigan | 26161 | 39152 | 349 |
1960925 | 1960925 | 2021-11-28 | Washtenaw | Michigan | 26161 | 38426 | 346 |
1957674 | 1957674 | 2021-11-27 | Washtenaw | Michigan | 26161 | 38426 | 346 |
1954423 | 1954423 | 2021-11-26 | Washtenaw | Michigan | 26161 | 38426 | 346 |
1951172 | 1951172 | 2021-11-25 | Washtenaw | Michigan | 26161 | 38426 | 346 |
1947921 | 1947921 | 2021-11-24 | Washtenaw | Michigan | 26161 | 38426 | 346 |
1944670 | 1944670 | 2021-11-23 | Washtenaw | Michigan | 26161 | 38029 | 345 |
1941419 | 1941419 | 2021-11-22 | Washtenaw | Michigan | 26161 | 37887 | 345 |
1938169 | 1938169 | 2021-11-21 | Washtenaw | Michigan | 26161 | 37467 | 345 |
1934919 | 1934919 | 2021-11-20 | Washtenaw | Michigan | 26161 | 37467 | 345 |
1931669 | 1931669 | 2021-11-19 | Washtenaw | Michigan | 26161 | 37467 | 345 |
1928418 | 1928418 | 2021-11-18 | Washtenaw | Michigan | 26161 | 37227 | 344 |
1925168 | 1925168 | 2021-11-17 | Washtenaw | Michigan | 26161 | 36873 | 343 |
1921919 | 1921919 | 2021-11-16 | Washtenaw | Michigan | 26161 | 36644 | 343 |
1918669 | 1918669 | 2021-11-15 | Washtenaw | Michigan | 26161 | 36500 | 343 |
1915419 | 1915419 | 2021-11-14 | Washtenaw | Michigan | 26161 | 35942 | 341 |
1912169 | 1912169 | 2021-11-13 | Washtenaw | Michigan | 26161 | 35942 | 341 |
1908919 | 1908919 | 2021-11-12 | Washtenaw | Michigan | 26161 | 35942 | 341 |
1905670 | 1905670 | 2021-11-11 | Washtenaw | Michigan | 26161 | 35559 | 341 |
1902421 | 1902421 | 2021-11-10 | Washtenaw | Michigan | 26161 | 35559 | 341 |
1899171 | 1899171 | 2021-11-09 | Washtenaw | Michigan | 26161 | 35345 | 340 |
1895921 | 1895921 | 2021-11-08 | Washtenaw | Michigan | 26161 | 35252 | 340 |
1892671 | 1892671 | 2021-11-07 | Washtenaw | Michigan | 26161 | 35006 | 340 |
1889421 | 1889421 | 2021-11-06 | Washtenaw | Michigan | 26161 | 35006 | 340 |
1886171 | 1886171 | 2021-11-05 | Washtenaw | Michigan | 26161 | 35006 | 340 |
1882922 | 1882922 | 2021-11-04 | Washtenaw | Michigan | 26161 | 34838 | 340 |
1879673 | 1879673 | 2021-11-03 | Washtenaw | Michigan | 26161 | 34638 | 340 |
1876424 | 1876424 | 2021-11-02 | Washtenaw | Michigan | 26161 | 34455 | 340 |
1873175 | 1873175 | 2021-11-01 | Washtenaw | Michigan | 26161 | 34369 | 340 |
1869926 | 1869926 | 2021-10-31 | Washtenaw | Michigan | 26161 | 34142 | 339 |
1866677 | 1866677 | 2021-10-30 | Washtenaw | Michigan | 26161 | 34142 | 339 |
1863428 | 1863428 | 2021-10-29 | Washtenaw | Michigan | 26161 | 34142 | 339 |
1860179 | 1860179 | 2021-10-28 | Washtenaw | Michigan | 26161 | 34064 | 339 |
1856930 | 1856930 | 2021-10-27 | Washtenaw | Michigan | 26161 | 33888 | 338 |
1853681 | 1853681 | 2021-10-26 | Washtenaw | Michigan | 26161 | 33813 | 338 |
1850432 | 1850432 | 2021-10-25 | Washtenaw | Michigan | 26161 | 33739 | 338 |
1847182 | 1847182 | 2021-10-24 | Washtenaw | Michigan | 26161 | 33569 | 334 |
1843932 | 1843932 | 2021-10-23 | Washtenaw | Michigan | 26161 | 33569 | 334 |
1840682 | 1840682 | 2021-10-22 | Washtenaw | Michigan | 26161 | 33569 | 334 |
1837433 | 1837433 | 2021-10-21 | Washtenaw | Michigan | 26161 | 33499 | 334 |
1834184 | 1834184 | 2021-10-20 | Washtenaw | Michigan | 26161 | 33304 | 331 |
1830935 | 1830935 | 2021-10-19 | Washtenaw | Michigan | 26161 | 33217 | 331 |
1827686 | 1827686 | 2021-10-18 | Washtenaw | Michigan | 26161 | 33168 | 331 |
1824437 | 1824437 | 2021-10-17 | Washtenaw | Michigan | 26161 | 32962 | 331 |
1821188 | 1821188 | 2021-10-16 | Washtenaw | Michigan | 26161 | 32962 | 331 |
1817939 | 1817939 | 2021-10-15 | Washtenaw | Michigan | 26161 | 32962 | 331 |
1814690 | 1814690 | 2021-10-14 | Washtenaw | Michigan | 26161 | 32829 | 330 |
1811442 | 1811442 | 2021-10-13 | Washtenaw | Michigan | 26161 | 32656 | 328 |
1808193 | 1808193 | 2021-10-12 | Washtenaw | Michigan | 26161 | 32529 | 328 |
1804942 | 1804942 | 2021-10-11 | Washtenaw | Michigan | 26161 | 32351 | 327 |
1801693 | 1801693 | 2021-10-10 | Washtenaw | Michigan | 26161 | 32193 | 327 |
1798444 | 1798444 | 2021-10-09 | Washtenaw | Michigan | 26161 | 32193 | 327 |
1795195 | 1795195 | 2021-10-08 | Washtenaw | Michigan | 26161 | 32193 | 327 |
1791946 | 1791946 | 2021-10-07 | Washtenaw | Michigan | 26161 | 32110 | 326 |
1788697 | 1788697 | 2021-10-06 | Washtenaw | Michigan | 26161 | 31886 | 325 |
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);