ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Wabash" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174984 | 2174984 | 2022-02-02 | Wabash | Indiana | 18169 | 8396 | 144 |
2171731 | 2171731 | 2022-02-01 | Wabash | Indiana | 18169 | 8355 | 143 |
2168478 | 2168478 | 2022-01-31 | Wabash | Indiana | 18169 | 8329 | 142 |
2165223 | 2165223 | 2022-01-30 | Wabash | Indiana | 18169 | 8238 | 142 |
2161968 | 2161968 | 2022-01-29 | Wabash | Indiana | 18169 | 8238 | 142 |
2158713 | 2158713 | 2022-01-28 | Wabash | Indiana | 18169 | 8238 | 142 |
2155459 | 2155459 | 2022-01-27 | Wabash | Indiana | 18169 | 8170 | 142 |
2152206 | 2152206 | 2022-01-26 | Wabash | Indiana | 18169 | 8087 | 142 |
2148954 | 2148954 | 2022-01-25 | Wabash | Indiana | 18169 | 8075 | 142 |
2145702 | 2145702 | 2022-01-24 | Wabash | Indiana | 18169 | 8032 | 141 |
2142447 | 2142447 | 2022-01-23 | Wabash | Indiana | 18169 | 7919 | 140 |
2139192 | 2139192 | 2022-01-22 | Wabash | Indiana | 18169 | 7919 | 140 |
2135936 | 2135936 | 2022-01-21 | Wabash | Indiana | 18169 | 7919 | 140 |
2132684 | 2132684 | 2022-01-20 | Wabash | Indiana | 18169 | 7832 | 140 |
2129431 | 2129431 | 2022-01-19 | Wabash | Indiana | 18169 | 7731 | 140 |
2126177 | 2126177 | 2022-01-18 | Wabash | Indiana | 18169 | 7656 | 140 |
2122925 | 2122925 | 2022-01-17 | Wabash | Indiana | 18169 | 7603 | 139 |
2119673 | 2119673 | 2022-01-16 | Wabash | Indiana | 18169 | 7436 | 139 |
2116421 | 2116421 | 2022-01-15 | Wabash | Indiana | 18169 | 7436 | 139 |
2113170 | 2113170 | 2022-01-14 | Wabash | Indiana | 18169 | 7436 | 139 |
2109918 | 2109918 | 2022-01-13 | Wabash | Indiana | 18169 | 7383 | 137 |
2106667 | 2106667 | 2022-01-12 | Wabash | Indiana | 18169 | 7321 | 137 |
2103416 | 2103416 | 2022-01-11 | Wabash | Indiana | 18169 | 7278 | 136 |
2100165 | 2100165 | 2022-01-10 | Wabash | Indiana | 18169 | 7242 | 134 |
2096914 | 2096914 | 2022-01-09 | Wabash | Indiana | 18169 | 7132 | 134 |
2093662 | 2093662 | 2022-01-08 | Wabash | Indiana | 18169 | 7132 | 134 |
2090410 | 2090410 | 2022-01-07 | Wabash | Indiana | 18169 | 7132 | 134 |
2087159 | 2087159 | 2022-01-06 | Wabash | Indiana | 18169 | 7095 | 132 |
2083907 | 2083907 | 2022-01-05 | Wabash | Indiana | 18169 | 7028 | 131 |
2080655 | 2080655 | 2022-01-04 | Wabash | Indiana | 18169 | 6979 | 131 |
2077403 | 2077403 | 2022-01-03 | Wabash | Indiana | 18169 | 6957 | 131 |
2074152 | 2074152 | 2022-01-02 | Wabash | Indiana | 18169 | 6870 | 131 |
2070901 | 2070901 | 2022-01-01 | Wabash | Indiana | 18169 | 6870 | 131 |
2067650 | 2067650 | 2021-12-31 | Wabash | Indiana | 18169 | 6870 | 131 |
2064399 | 2064399 | 2021-12-30 | Wabash | Indiana | 18169 | 6870 | 131 |
2061149 | 2061149 | 2021-12-29 | Wabash | Indiana | 18169 | 6829 | 130 |
2057900 | 2057900 | 2021-12-28 | Wabash | Indiana | 18169 | 6807 | 129 |
2054651 | 2054651 | 2021-12-27 | Wabash | Indiana | 18169 | 6784 | 128 |
2051401 | 2051401 | 2021-12-26 | Wabash | Indiana | 18169 | 6723 | 128 |
2048151 | 2048151 | 2021-12-25 | Wabash | Indiana | 18169 | 6723 | 128 |
2044901 | 2044901 | 2021-12-24 | Wabash | Indiana | 18169 | 6723 | 128 |
2041652 | 2041652 | 2021-12-23 | Wabash | Indiana | 18169 | 6723 | 128 |
2038402 | 2038402 | 2021-12-22 | Wabash | Indiana | 18169 | 6723 | 128 |
2035152 | 2035152 | 2021-12-21 | Wabash | Indiana | 18169 | 6690 | 125 |
2031902 | 2031902 | 2021-12-20 | Wabash | Indiana | 18169 | 6675 | 124 |
2028651 | 2028651 | 2021-12-19 | Wabash | Indiana | 18169 | 6634 | 122 |
2025400 | 2025400 | 2021-12-18 | Wabash | Indiana | 18169 | 6634 | 122 |
2022149 | 2022149 | 2021-12-17 | Wabash | Indiana | 18169 | 6634 | 122 |
2018898 | 2018898 | 2021-12-16 | Wabash | Indiana | 18169 | 6615 | 122 |
2015648 | 2015648 | 2021-12-15 | Wabash | Indiana | 18169 | 6589 | 121 |
2012397 | 2012397 | 2021-12-14 | Wabash | Indiana | 18169 | 6559 | 120 |
2009146 | 2009146 | 2021-12-13 | Wabash | Indiana | 18169 | 6530 | 119 |
2005895 | 2005895 | 2021-12-12 | Wabash | Indiana | 18169 | 6461 | 118 |
2002644 | 2002644 | 2021-12-11 | Wabash | Indiana | 18169 | 6461 | 118 |
1999394 | 1999394 | 2021-12-10 | Wabash | Indiana | 18169 | 6461 | 118 |
1996143 | 1996143 | 2021-12-09 | Wabash | Indiana | 18169 | 6428 | 118 |
1992892 | 1992892 | 2021-12-08 | Wabash | Indiana | 18169 | 6393 | 118 |
1989641 | 1989641 | 2021-12-07 | Wabash | Indiana | 18169 | 6358 | 114 |
1986391 | 1986391 | 2021-12-06 | Wabash | Indiana | 18169 | 6328 | 112 |
1983141 | 1983141 | 2021-12-05 | Wabash | Indiana | 18169 | 6226 | 112 |
1979891 | 1979891 | 2021-12-04 | Wabash | Indiana | 18169 | 6226 | 112 |
1976641 | 1976641 | 2021-12-03 | Wabash | Indiana | 18169 | 6226 | 112 |
1973392 | 1973392 | 2021-12-02 | Wabash | Indiana | 18169 | 6187 | 112 |
1970142 | 1970142 | 2021-12-01 | Wabash | Indiana | 18169 | 6141 | 111 |
1966892 | 1966892 | 2021-11-30 | Wabash | Indiana | 18169 | 6084 | 109 |
1963640 | 1963640 | 2021-11-29 | Wabash | Indiana | 18169 | 6064 | 108 |
1960389 | 1960389 | 2021-11-28 | Wabash | Indiana | 18169 | 5962 | 108 |
1957138 | 1957138 | 2021-11-27 | Wabash | Indiana | 18169 | 5962 | 108 |
1953887 | 1953887 | 2021-11-26 | Wabash | Indiana | 18169 | 5962 | 108 |
1950636 | 1950636 | 2021-11-25 | Wabash | Indiana | 18169 | 5962 | 108 |
1947385 | 1947385 | 2021-11-24 | Wabash | Indiana | 18169 | 5962 | 108 |
1944134 | 1944134 | 2021-11-23 | Wabash | Indiana | 18169 | 5920 | 108 |
1940884 | 1940884 | 2021-11-22 | Wabash | Indiana | 18169 | 5902 | 107 |
1937634 | 1937634 | 2021-11-21 | Wabash | Indiana | 18169 | 5837 | 107 |
1934384 | 1934384 | 2021-11-20 | Wabash | Indiana | 18169 | 5837 | 107 |
1931133 | 1931133 | 2021-11-19 | Wabash | Indiana | 18169 | 5837 | 107 |
1927882 | 1927882 | 2021-11-18 | Wabash | Indiana | 18169 | 5810 | 107 |
1924632 | 1924632 | 2021-11-17 | Wabash | Indiana | 18169 | 5784 | 107 |
1921383 | 1921383 | 2021-11-16 | Wabash | Indiana | 18169 | 5745 | 107 |
1918133 | 1918133 | 2021-11-15 | Wabash | Indiana | 18169 | 5718 | 107 |
1914883 | 1914883 | 2021-11-14 | Wabash | Indiana | 18169 | 5668 | 107 |
1911633 | 1911633 | 2021-11-13 | Wabash | Indiana | 18169 | 5668 | 107 |
1908384 | 1908384 | 2021-11-12 | Wabash | Indiana | 18169 | 5668 | 107 |
1905135 | 1905135 | 2021-11-11 | Wabash | Indiana | 18169 | 5637 | 106 |
1901885 | 1901885 | 2021-11-10 | Wabash | Indiana | 18169 | 5595 | 106 |
1898635 | 1898635 | 2021-11-09 | Wabash | Indiana | 18169 | 5559 | 106 |
1895385 | 1895385 | 2021-11-08 | Wabash | Indiana | 18169 | 5544 | 105 |
1892135 | 1892135 | 2021-11-07 | Wabash | Indiana | 18169 | 5503 | 105 |
1888885 | 1888885 | 2021-11-06 | Wabash | Indiana | 18169 | 5503 | 105 |
1885635 | 1885635 | 2021-11-05 | Wabash | Indiana | 18169 | 5503 | 105 |
1882386 | 1882386 | 2021-11-04 | Wabash | Indiana | 18169 | 5489 | 105 |
1879137 | 1879137 | 2021-11-03 | Wabash | Indiana | 18169 | 5476 | 105 |
1875888 | 1875888 | 2021-11-02 | Wabash | Indiana | 18169 | 5458 | 105 |
1872639 | 1872639 | 2021-11-01 | Wabash | Indiana | 18169 | 5452 | 105 |
1869390 | 1869390 | 2021-10-31 | Wabash | Indiana | 18169 | 5425 | 105 |
1866141 | 1866141 | 2021-10-30 | Wabash | Indiana | 18169 | 5425 | 105 |
1862892 | 1862892 | 2021-10-29 | Wabash | Indiana | 18169 | 5425 | 105 |
1859643 | 1859643 | 2021-10-28 | Wabash | Indiana | 18169 | 5404 | 105 |
1856394 | 1856394 | 2021-10-27 | Wabash | Indiana | 18169 | 5392 | 105 |
1853145 | 1853145 | 2021-10-26 | Wabash | Indiana | 18169 | 5376 | 104 |
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);