ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Berrien" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175449 | 2175449 | 2022-02-02 | Berrien | Michigan | 26021 | 33538 | 478 |
2172196 | 2172196 | 2022-02-01 | Berrien | Michigan | 26021 | 33042 | 468 |
2168943 | 2168943 | 2022-01-31 | Berrien | Michigan | 26021 | 33042 | 468 |
2165688 | 2165688 | 2022-01-30 | Berrien | Michigan | 26021 | 32698 | 464 |
2162433 | 2162433 | 2022-01-29 | Berrien | Michigan | 26021 | 32698 | 464 |
2159178 | 2159178 | 2022-01-28 | Berrien | Michigan | 26021 | 32698 | 464 |
2155924 | 2155924 | 2022-01-27 | Berrien | Michigan | 26021 | 32215 | 463 |
2152671 | 2152671 | 2022-01-26 | Berrien | Michigan | 26021 | 32215 | 463 |
2149419 | 2149419 | 2022-01-25 | Berrien | Michigan | 26021 | 31588 | 447 |
2146167 | 2146167 | 2022-01-24 | Berrien | Michigan | 26021 | 31588 | 447 |
2142912 | 2142912 | 2022-01-23 | Berrien | Michigan | 26021 | 31021 | 447 |
2139657 | 2139657 | 2022-01-22 | Berrien | Michigan | 26021 | 31021 | 447 |
2136401 | 2136401 | 2022-01-21 | Berrien | Michigan | 26021 | 31021 | 447 |
2133149 | 2133149 | 2022-01-20 | Berrien | Michigan | 26021 | 30389 | 444 |
2129896 | 2129896 | 2022-01-19 | Berrien | Michigan | 26021 | 30389 | 444 |
2126642 | 2126642 | 2022-01-18 | Berrien | Michigan | 26021 | 29149 | 432 |
2123390 | 2123390 | 2022-01-17 | Berrien | Michigan | 26021 | 29149 | 432 |
2120138 | 2120138 | 2022-01-16 | Berrien | Michigan | 26021 | 29149 | 432 |
2116886 | 2116886 | 2022-01-15 | Berrien | Michigan | 26021 | 29149 | 432 |
2113635 | 2113635 | 2022-01-14 | Berrien | Michigan | 26021 | 29149 | 432 |
2110383 | 2110383 | 2022-01-13 | Berrien | Michigan | 26021 | 28681 | 428 |
2107132 | 2107132 | 2022-01-12 | Berrien | Michigan | 26021 | 28681 | 428 |
2103881 | 2103881 | 2022-01-11 | Berrien | Michigan | 26021 | 27975 | 418 |
2100630 | 2100630 | 2022-01-10 | Berrien | Michigan | 26021 | 27975 | 418 |
2097379 | 2097379 | 2022-01-09 | Berrien | Michigan | 26021 | 27323 | 418 |
2094127 | 2094127 | 2022-01-08 | Berrien | Michigan | 26021 | 27323 | 418 |
2090875 | 2090875 | 2022-01-07 | Berrien | Michigan | 26021 | 27323 | 418 |
2087624 | 2087624 | 2022-01-06 | Berrien | Michigan | 26021 | 26747 | 415 |
2084372 | 2084372 | 2022-01-05 | Berrien | Michigan | 26021 | 26747 | 415 |
2081120 | 2081120 | 2022-01-04 | Berrien | Michigan | 26021 | 26240 | 405 |
2077868 | 2077868 | 2022-01-03 | Berrien | Michigan | 26021 | 26240 | 405 |
2074617 | 2074617 | 2022-01-02 | Berrien | Michigan | 26021 | 25487 | 396 |
2071366 | 2071366 | 2022-01-01 | Berrien | Michigan | 26021 | 25487 | 396 |
2068115 | 2068115 | 2021-12-31 | Berrien | Michigan | 26021 | 25487 | 396 |
2064864 | 2064864 | 2021-12-30 | Berrien | Michigan | 26021 | 25487 | 396 |
2061614 | 2061614 | 2021-12-29 | Berrien | Michigan | 26021 | 25487 | 396 |
2058365 | 2058365 | 2021-12-28 | Berrien | Michigan | 26021 | 25082 | 389 |
2055116 | 2055116 | 2021-12-27 | Berrien | Michigan | 26021 | 25082 | 389 |
2051866 | 2051866 | 2021-12-26 | Berrien | Michigan | 26021 | 24685 | 385 |
2048616 | 2048616 | 2021-12-25 | Berrien | Michigan | 26021 | 24685 | 385 |
2045366 | 2045366 | 2021-12-24 | Berrien | Michigan | 26021 | 24685 | 385 |
2042116 | 2042116 | 2021-12-23 | Berrien | Michigan | 26021 | 24685 | 385 |
2038867 | 2038867 | 2021-12-22 | Berrien | Michigan | 26021 | 24685 | 385 |
2035617 | 2035617 | 2021-12-21 | Berrien | Michigan | 26021 | 24425 | 374 |
2032367 | 2032367 | 2021-12-20 | Berrien | Michigan | 26021 | 24425 | 374 |
2029116 | 2029116 | 2021-12-19 | Berrien | Michigan | 26021 | 24157 | 372 |
2025865 | 2025865 | 2021-12-18 | Berrien | Michigan | 26021 | 24157 | 372 |
2022614 | 2022614 | 2021-12-17 | Berrien | Michigan | 26021 | 24157 | 372 |
2019363 | 2019363 | 2021-12-16 | Berrien | Michigan | 26021 | 23840 | 365 |
2016113 | 2016113 | 2021-12-15 | Berrien | Michigan | 26021 | 23840 | 365 |
2012862 | 2012862 | 2021-12-14 | Berrien | Michigan | 26021 | 23566 | 360 |
2009611 | 2009611 | 2021-12-13 | Berrien | Michigan | 26021 | 23566 | 360 |
2006360 | 2006360 | 2021-12-12 | Berrien | Michigan | 26021 | 23250 | 359 |
2003109 | 2003109 | 2021-12-11 | Berrien | Michigan | 26021 | 23250 | 359 |
1999859 | 1999859 | 2021-12-10 | Berrien | Michigan | 26021 | 23250 | 359 |
1996608 | 1996608 | 2021-12-09 | Berrien | Michigan | 26021 | 23033 | 354 |
1993357 | 1993357 | 2021-12-08 | Berrien | Michigan | 26021 | 23033 | 354 |
1990106 | 1990106 | 2021-12-07 | Berrien | Michigan | 26021 | 22714 | 352 |
1986856 | 1986856 | 2021-12-06 | Berrien | Michigan | 26021 | 22714 | 352 |
1983606 | 1983606 | 2021-12-05 | Berrien | Michigan | 26021 | 22413 | 351 |
1980356 | 1980356 | 2021-12-04 | Berrien | Michigan | 26021 | 22413 | 351 |
1977106 | 1977106 | 2021-12-03 | Berrien | Michigan | 26021 | 22413 | 351 |
1973856 | 1973856 | 2021-12-02 | Berrien | Michigan | 26021 | 22010 | 349 |
1970607 | 1970607 | 2021-12-01 | Berrien | Michigan | 26021 | 22010 | 349 |
1967357 | 1967357 | 2021-11-30 | Berrien | Michigan | 26021 | 21725 | 347 |
1964105 | 1964105 | 2021-11-29 | Berrien | Michigan | 26021 | 21725 | 347 |
1960854 | 1960854 | 2021-11-28 | Berrien | Michigan | 26021 | 21354 | 345 |
1957603 | 1957603 | 2021-11-27 | Berrien | Michigan | 26021 | 21354 | 345 |
1954352 | 1954352 | 2021-11-26 | Berrien | Michigan | 26021 | 21354 | 345 |
1951101 | 1951101 | 2021-11-25 | Berrien | Michigan | 26021 | 21354 | 345 |
1947850 | 1947850 | 2021-11-24 | Berrien | Michigan | 26021 | 21354 | 345 |
1944599 | 1944599 | 2021-11-23 | Berrien | Michigan | 26021 | 21087 | 342 |
1941348 | 1941348 | 2021-11-22 | Berrien | Michigan | 26021 | 21087 | 342 |
1938098 | 1938098 | 2021-11-21 | Berrien | Michigan | 26021 | 20896 | 341 |
1934848 | 1934848 | 2021-11-20 | Berrien | Michigan | 26021 | 20896 | 341 |
1931598 | 1931598 | 2021-11-19 | Berrien | Michigan | 26021 | 20896 | 341 |
1928347 | 1928347 | 2021-11-18 | Berrien | Michigan | 26021 | 20630 | 341 |
1925097 | 1925097 | 2021-11-17 | Berrien | Michigan | 26021 | 20630 | 341 |
1921848 | 1921848 | 2021-11-16 | Berrien | Michigan | 26021 | 20437 | 337 |
1918598 | 1918598 | 2021-11-15 | Berrien | Michigan | 26021 | 20437 | 337 |
1915348 | 1915348 | 2021-11-14 | Berrien | Michigan | 26021 | 20155 | 336 |
1912098 | 1912098 | 2021-11-13 | Berrien | Michigan | 26021 | 20155 | 336 |
1908848 | 1908848 | 2021-11-12 | Berrien | Michigan | 26021 | 20155 | 336 |
1905599 | 1905599 | 2021-11-11 | Berrien | Michigan | 26021 | 19982 | 335 |
1902350 | 1902350 | 2021-11-10 | Berrien | Michigan | 26021 | 19982 | 335 |
1899100 | 1899100 | 2021-11-09 | Berrien | Michigan | 26021 | 19904 | 333 |
1895850 | 1895850 | 2021-11-08 | Berrien | Michigan | 26021 | 19904 | 333 |
1892600 | 1892600 | 2021-11-07 | Berrien | Michigan | 26021 | 19813 | 333 |
1889350 | 1889350 | 2021-11-06 | Berrien | Michigan | 26021 | 19813 | 333 |
1886100 | 1886100 | 2021-11-05 | Berrien | Michigan | 26021 | 19813 | 333 |
1882851 | 1882851 | 2021-11-04 | Berrien | Michigan | 26021 | 19680 | 332 |
1879602 | 1879602 | 2021-11-03 | Berrien | Michigan | 26021 | 19680 | 332 |
1876353 | 1876353 | 2021-11-02 | Berrien | Michigan | 26021 | 19519 | 331 |
1873104 | 1873104 | 2021-11-01 | Berrien | Michigan | 26021 | 19519 | 331 |
1869855 | 1869855 | 2021-10-31 | Berrien | Michigan | 26021 | 19396 | 331 |
1866606 | 1866606 | 2021-10-30 | Berrien | Michigan | 26021 | 19396 | 331 |
1863357 | 1863357 | 2021-10-29 | Berrien | Michigan | 26021 | 19396 | 331 |
1860108 | 1860108 | 2021-10-28 | Berrien | Michigan | 26021 | 19273 | 329 |
1856859 | 1856859 | 2021-10-27 | Berrien | Michigan | 26021 | 19273 | 329 |
1853610 | 1853610 | 2021-10-26 | Berrien | Michigan | 26021 | 19151 | 330 |
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);