ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where county = "Crawford" and deaths = 22 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Crawford · 103 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2087633 | 2087633 | 2022-01-06 | Crawford | Michigan | 26039 | 1978 | 22 |
2084381 | 2084381 | 2022-01-05 | Crawford | Michigan | 26039 | 1978 | 22 |
2081129 | 2081129 | 2022-01-04 | Crawford | Michigan | 26039 | 1962 | 22 |
2077877 | 2077877 | 2022-01-03 | Crawford | Michigan | 26039 | 1962 | 22 |
1904262 | 1904262 | 2021-11-10 | Crawford | Wisconsin | 55023 | 2451 | 22 |
1901012 | 1901012 | 2021-11-09 | Crawford | Wisconsin | 55023 | 2434 | 22 |
1897762 | 1897762 | 2021-11-08 | Crawford | Wisconsin | 55023 | 2427 | 22 |
1894512 | 1894512 | 2021-11-07 | Crawford | Wisconsin | 55023 | 2411 | 22 |
1891262 | 1891262 | 2021-11-06 | Crawford | Wisconsin | 55023 | 2411 | 22 |
1888012 | 1888012 | 2021-11-05 | Crawford | Wisconsin | 55023 | 2411 | 22 |
1884762 | 1884762 | 2021-11-04 | Crawford | Wisconsin | 55023 | 2405 | 22 |
1881513 | 1881513 | 2021-11-03 | Crawford | Wisconsin | 55023 | 2382 | 22 |
1878264 | 1878264 | 2021-11-02 | Crawford | Wisconsin | 55023 | 2376 | 22 |
1875015 | 1875015 | 2021-11-01 | Crawford | Wisconsin | 55023 | 2367 | 22 |
1871766 | 1871766 | 2021-10-31 | Crawford | Wisconsin | 55023 | 2345 | 22 |
1868517 | 1868517 | 2021-10-30 | Crawford | Wisconsin | 55023 | 2345 | 22 |
1865268 | 1865268 | 2021-10-29 | Crawford | Wisconsin | 55023 | 2345 | 22 |
1862019 | 1862019 | 2021-10-28 | Crawford | Wisconsin | 55023 | 2328 | 22 |
1858770 | 1858770 | 2021-10-27 | Crawford | Wisconsin | 55023 | 2326 | 22 |
1855521 | 1855521 | 2021-10-26 | Crawford | Wisconsin | 55023 | 2315 | 22 |
1852272 | 1852272 | 2021-10-25 | Crawford | Wisconsin | 55023 | 2310 | 22 |
1849022 | 1849022 | 2021-10-24 | Crawford | Wisconsin | 55023 | 2285 | 22 |
1845772 | 1845772 | 2021-10-23 | Crawford | Wisconsin | 55023 | 2285 | 22 |
1842522 | 1842522 | 2021-10-22 | Crawford | Wisconsin | 55023 | 2285 | 22 |
1839273 | 1839273 | 2021-10-21 | Crawford | Wisconsin | 55023 | 2276 | 22 |
1836024 | 1836024 | 2021-10-20 | Crawford | Wisconsin | 55023 | 2269 | 22 |
1832775 | 1832775 | 2021-10-19 | Crawford | Wisconsin | 55023 | 2259 | 22 |
1829526 | 1829526 | 2021-10-18 | Crawford | Wisconsin | 55023 | 2253 | 22 |
1826277 | 1826277 | 2021-10-17 | Crawford | Wisconsin | 55023 | 2245 | 22 |
1823028 | 1823028 | 2021-10-16 | Crawford | Wisconsin | 55023 | 2228 | 22 |
1819779 | 1819779 | 2021-10-15 | Crawford | Wisconsin | 55023 | 2228 | 22 |
1816530 | 1816530 | 2021-10-14 | Crawford | Wisconsin | 55023 | 2228 | 22 |
1813282 | 1813282 | 2021-10-13 | Crawford | Wisconsin | 55023 | 2218 | 22 |
1810033 | 1810033 | 2021-10-12 | Crawford | Wisconsin | 55023 | 2201 | 22 |
1804334 | 1804334 | 2021-10-11 | Crawford | Indiana | 18025 | 1565 | 22 |
1806784 | 1806784 | 2021-10-11 | Crawford | Wisconsin | 55023 | 2191 | 22 |
1801085 | 1801085 | 2021-10-10 | Crawford | Indiana | 18025 | 1553 | 22 |
1803533 | 1803533 | 2021-10-10 | Crawford | Wisconsin | 55023 | 2172 | 22 |
1797836 | 1797836 | 2021-10-09 | Crawford | Indiana | 18025 | 1553 | 22 |
1800284 | 1800284 | 2021-10-09 | Crawford | Wisconsin | 55023 | 2172 | 22 |
1794587 | 1794587 | 2021-10-08 | Crawford | Indiana | 18025 | 1553 | 22 |
1797035 | 1797035 | 2021-10-08 | Crawford | Wisconsin | 55023 | 2172 | 22 |
1791339 | 1791339 | 2021-10-07 | Crawford | Indiana | 18025 | 1540 | 22 |
1793786 | 1793786 | 2021-10-07 | Crawford | Wisconsin | 55023 | 2164 | 22 |
1788090 | 1788090 | 2021-10-06 | Crawford | Indiana | 18025 | 1533 | 22 |
1790537 | 1790537 | 2021-10-06 | Crawford | Wisconsin | 55023 | 2144 | 22 |
1784841 | 1784841 | 2021-10-05 | Crawford | Indiana | 18025 | 1531 | 22 |
1787289 | 1787289 | 2021-10-05 | Crawford | Wisconsin | 55023 | 2133 | 22 |
1784040 | 1784040 | 2021-10-04 | Crawford | Wisconsin | 55023 | 2125 | 22 |
1780791 | 1780791 | 2021-10-03 | Crawford | Wisconsin | 55023 | 2097 | 22 |
1777541 | 1777541 | 2021-10-02 | Crawford | Wisconsin | 55023 | 2097 | 22 |
1774291 | 1774291 | 2021-10-01 | Crawford | Wisconsin | 55023 | 2097 | 22 |
1771041 | 1771041 | 2021-09-30 | Crawford | Wisconsin | 55023 | 2081 | 22 |
1767792 | 1767792 | 2021-09-29 | Crawford | Wisconsin | 55023 | 2074 | 22 |
1764543 | 1764543 | 2021-09-28 | Crawford | Wisconsin | 55023 | 2058 | 22 |
1761294 | 1761294 | 2021-09-27 | Crawford | Wisconsin | 55023 | 2057 | 22 |
1758046 | 1758046 | 2021-09-26 | Crawford | Wisconsin | 55023 | 2025 | 22 |
1754798 | 1754798 | 2021-09-25 | Crawford | Wisconsin | 55023 | 2025 | 22 |
1751550 | 1751550 | 2021-09-24 | Crawford | Wisconsin | 55023 | 2025 | 22 |
1748301 | 1748301 | 2021-09-23 | Crawford | Wisconsin | 55023 | 2016 | 22 |
1745051 | 1745051 | 2021-09-22 | Crawford | Wisconsin | 55023 | 2007 | 22 |
1741802 | 1741802 | 2021-09-21 | Crawford | Wisconsin | 55023 | 2000 | 22 |
1738553 | 1738553 | 2021-09-20 | Crawford | Wisconsin | 55023 | 1992 | 22 |
1735304 | 1735304 | 2021-09-19 | Crawford | Wisconsin | 55023 | 1965 | 22 |
1732054 | 1732054 | 2021-09-18 | Crawford | Wisconsin | 55023 | 1965 | 22 |
1728804 | 1728804 | 2021-09-17 | Crawford | Wisconsin | 55023 | 1965 | 22 |
1725554 | 1725554 | 2021-09-16 | Crawford | Wisconsin | 55023 | 1960 | 22 |
1722305 | 1722305 | 2021-09-15 | Crawford | Wisconsin | 55023 | 1953 | 22 |
1719057 | 1719057 | 2021-09-14 | Crawford | Wisconsin | 55023 | 1945 | 22 |
1715809 | 1715809 | 2021-09-13 | Crawford | Wisconsin | 55023 | 1944 | 22 |
1712563 | 1712563 | 2021-09-12 | Crawford | Wisconsin | 55023 | 1931 | 22 |
1709316 | 1709316 | 2021-09-11 | Crawford | Wisconsin | 55023 | 1931 | 22 |
1706069 | 1706069 | 2021-09-10 | Crawford | Wisconsin | 55023 | 1931 | 22 |
1664349 | 1664349 | 2021-08-29 | Crawford | Georgia | 13079 | 878 | 22 |
1661101 | 1661101 | 2021-08-28 | Crawford | Georgia | 13079 | 878 | 22 |
1657853 | 1657853 | 2021-08-27 | Crawford | Georgia | 13079 | 878 | 22 |
1654605 | 1654605 | 2021-08-26 | Crawford | Georgia | 13079 | 869 | 22 |
1651358 | 1651358 | 2021-08-25 | Crawford | Georgia | 13079 | 861 | 22 |
943971 | 943971 | 2021-01-19 | Crawford | Iowa | 19047 | 2310 | 22 |
940726 | 940726 | 2021-01-18 | Crawford | Iowa | 19047 | 2295 | 22 |
937481 | 937481 | 2021-01-17 | Crawford | Iowa | 19047 | 2283 | 22 |
934236 | 934236 | 2021-01-16 | Crawford | Iowa | 19047 | 2283 | 22 |
930991 | 930991 | 2021-01-15 | Crawford | Iowa | 19047 | 2277 | 22 |
927746 | 927746 | 2021-01-14 | Crawford | Iowa | 19047 | 2274 | 22 |
924500 | 924500 | 2021-01-13 | Crawford | Iowa | 19047 | 2266 | 22 |
921255 | 921255 | 2021-01-12 | Crawford | Iowa | 19047 | 2260 | 22 |
918010 | 918010 | 2021-01-11 | Crawford | Iowa | 19047 | 2254 | 22 |
914765 | 914765 | 2021-01-10 | Crawford | Iowa | 19047 | 2242 | 22 |
911520 | 911520 | 2021-01-09 | Crawford | Iowa | 19047 | 2235 | 22 |
908275 | 908275 | 2021-01-08 | Crawford | Iowa | 19047 | 2224 | 22 |
905029 | 905029 | 2021-01-07 | Crawford | Iowa | 19047 | 2216 | 22 |
901784 | 901784 | 2021-01-06 | Crawford | Iowa | 19047 | 2199 | 22 |
898539 | 898539 | 2021-01-05 | Crawford | Iowa | 19047 | 2180 | 22 |
895294 | 895294 | 2021-01-04 | Crawford | Iowa | 19047 | 2148 | 22 |
892047 | 892047 | 2021-01-03 | Crawford | Iowa | 19047 | 2134 | 22 |
888801 | 888801 | 2021-01-02 | Crawford | Iowa | 19047 | 2135 | 22 |
885555 | 885555 | 2021-01-01 | Crawford | Iowa | 19047 | 2133 | 22 |
882310 | 882310 | 2020-12-31 | Crawford | Iowa | 19047 | 2127 | 22 |
879065 | 879065 | 2020-12-30 | Crawford | Iowa | 19047 | 2107 | 22 |
875820 | 875820 | 2020-12-29 | Crawford | Iowa | 19047 | 2104 | 22 |
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);