ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Washington" and fips = 39167 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176344 | 2176344 | 2022-02-02 | Washington | Ohio | 39167 | 11828 | 173 |
2173090 | 2173090 | 2022-02-01 | Washington | Ohio | 39167 | 11792 | 173 |
2169838 | 2169838 | 2022-01-31 | Washington | Ohio | 39167 | 11718 | 173 |
2166583 | 2166583 | 2022-01-30 | Washington | Ohio | 39167 | 11673 | 173 |
2163328 | 2163328 | 2022-01-29 | Washington | Ohio | 39167 | 11626 | 173 |
2160073 | 2160073 | 2022-01-28 | Washington | Ohio | 39167 | 11580 | 173 |
2156818 | 2156818 | 2022-01-27 | Washington | Ohio | 39167 | 11521 | 173 |
2153565 | 2153565 | 2022-01-26 | Washington | Ohio | 39167 | 11422 | 173 |
2150313 | 2150313 | 2022-01-25 | Washington | Ohio | 39167 | 11217 | 173 |
2147061 | 2147061 | 2022-01-24 | Washington | Ohio | 39167 | 11152 | 172 |
2143807 | 2143807 | 2022-01-23 | Washington | Ohio | 39167 | 11054 | 172 |
2140552 | 2140552 | 2022-01-22 | Washington | Ohio | 39167 | 11009 | 172 |
2137296 | 2137296 | 2022-01-21 | Washington | Ohio | 39167 | 10911 | 172 |
2134042 | 2134042 | 2022-01-20 | Washington | Ohio | 39167 | 10836 | 168 |
2130790 | 2130790 | 2022-01-19 | Washington | Ohio | 39167 | 10729 | 168 |
2127536 | 2127536 | 2022-01-18 | Washington | Ohio | 39167 | 10644 | 168 |
2124284 | 2124284 | 2022-01-17 | Washington | Ohio | 39167 | 10564 | 168 |
2121032 | 2121032 | 2022-01-16 | Washington | Ohio | 39167 | 10497 | 168 |
2117780 | 2117780 | 2022-01-15 | Washington | Ohio | 39167 | 10398 | 168 |
2114529 | 2114529 | 2022-01-14 | Washington | Ohio | 39167 | 10165 | 168 |
2111277 | 2111277 | 2022-01-13 | Washington | Ohio | 39167 | 10066 | 168 |
2108025 | 2108025 | 2022-01-12 | Washington | Ohio | 39167 | 9976 | 168 |
2104774 | 2104774 | 2022-01-11 | Washington | Ohio | 39167 | 9904 | 168 |
2101523 | 2101523 | 2022-01-10 | Washington | Ohio | 39167 | 9867 | 167 |
2098272 | 2098272 | 2022-01-09 | Washington | Ohio | 39167 | 9810 | 167 |
2095020 | 2095020 | 2022-01-08 | Washington | Ohio | 39167 | 9764 | 167 |
2091768 | 2091768 | 2022-01-07 | Washington | Ohio | 39167 | 9740 | 167 |
2088516 | 2088516 | 2022-01-06 | Washington | Ohio | 39167 | 9660 | 168 |
2085265 | 2085265 | 2022-01-05 | Washington | Ohio | 39167 | 9596 | 168 |
2082013 | 2082013 | 2022-01-04 | Washington | Ohio | 39167 | 9492 | 168 |
2078761 | 2078761 | 2022-01-03 | Washington | Ohio | 39167 | 9408 | 165 |
2075510 | 2075510 | 2022-01-02 | Washington | Ohio | 39167 | 9361 | 165 |
2072259 | 2072259 | 2022-01-01 | Washington | Ohio | 39167 | 9299 | 165 |
2069008 | 2069008 | 2021-12-31 | Washington | Ohio | 39167 | 9299 | 165 |
2065757 | 2065757 | 2021-12-30 | Washington | Ohio | 39167 | 9256 | 163 |
2062507 | 2062507 | 2021-12-29 | Washington | Ohio | 39167 | 9181 | 163 |
2059257 | 2059257 | 2021-12-28 | Washington | Ohio | 39167 | 9138 | 163 |
2056008 | 2056008 | 2021-12-27 | Washington | Ohio | 39167 | 9110 | 163 |
2052759 | 2052759 | 2021-12-26 | Washington | Ohio | 39167 | 9094 | 163 |
2049509 | 2049509 | 2021-12-25 | Washington | Ohio | 39167 | 9049 | 163 |
2046259 | 2046259 | 2021-12-24 | Washington | Ohio | 39167 | 9049 | 163 |
2043009 | 2043009 | 2021-12-23 | Washington | Ohio | 39167 | 9029 | 162 |
2039760 | 2039760 | 2021-12-22 | Washington | Ohio | 39167 | 9010 | 162 |
2036510 | 2036510 | 2021-12-21 | Washington | Ohio | 39167 | 8983 | 162 |
2033260 | 2033260 | 2021-12-20 | Washington | Ohio | 39167 | 8957 | 162 |
2030010 | 2030010 | 2021-12-19 | Washington | Ohio | 39167 | 8941 | 162 |
2026759 | 2026759 | 2021-12-18 | Washington | Ohio | 39167 | 8936 | 162 |
2023508 | 2023508 | 2021-12-17 | Washington | Ohio | 39167 | 8923 | 162 |
2020257 | 2020257 | 2021-12-16 | Washington | Ohio | 39167 | 8899 | 160 |
2017006 | 2017006 | 2021-12-15 | Washington | Ohio | 39167 | 8882 | 160 |
2013756 | 2013756 | 2021-12-14 | Washington | Ohio | 39167 | 8866 | 160 |
2010505 | 2010505 | 2021-12-13 | Washington | Ohio | 39167 | 8846 | 159 |
2007254 | 2007254 | 2021-12-12 | Washington | Ohio | 39167 | 8833 | 159 |
2004003 | 2004003 | 2021-12-11 | Washington | Ohio | 39167 | 8827 | 159 |
2000752 | 2000752 | 2021-12-10 | Washington | Ohio | 39167 | 8813 | 159 |
1997502 | 1997502 | 2021-12-09 | Washington | Ohio | 39167 | 8798 | 159 |
1994251 | 1994251 | 2021-12-08 | Washington | Ohio | 39167 | 8788 | 159 |
1991000 | 1991000 | 2021-12-07 | Washington | Ohio | 39167 | 8767 | 159 |
1987749 | 1987749 | 2021-12-06 | Washington | Ohio | 39167 | 8738 | 159 |
1984499 | 1984499 | 2021-12-05 | Washington | Ohio | 39167 | 8714 | 159 |
1981249 | 1981249 | 2021-12-04 | Washington | Ohio | 39167 | 8704 | 159 |
1977999 | 1977999 | 2021-12-03 | Washington | Ohio | 39167 | 8688 | 159 |
1974749 | 1974749 | 2021-12-02 | Washington | Ohio | 39167 | 8675 | 158 |
1971500 | 1971500 | 2021-12-01 | Washington | Ohio | 39167 | 8655 | 158 |
1968250 | 1968250 | 2021-11-30 | Washington | Ohio | 39167 | 8632 | 158 |
1964999 | 1964999 | 2021-11-29 | Washington | Ohio | 39167 | 8613 | 156 |
1961747 | 1961747 | 2021-11-28 | Washington | Ohio | 39167 | 8588 | 156 |
1958496 | 1958496 | 2021-11-27 | Washington | Ohio | 39167 | 8578 | 156 |
1955245 | 1955245 | 2021-11-26 | Washington | Ohio | 39167 | 8558 | 156 |
1951994 | 1951994 | 2021-11-25 | Washington | Ohio | 39167 | 8522 | 155 |
1948743 | 1948743 | 2021-11-24 | Washington | Ohio | 39167 | 8522 | 155 |
1945492 | 1945492 | 2021-11-23 | Washington | Ohio | 39167 | 8505 | 155 |
1942241 | 1942241 | 2021-11-22 | Washington | Ohio | 39167 | 8473 | 155 |
1938991 | 1938991 | 2021-11-21 | Washington | Ohio | 39167 | 8456 | 155 |
1935741 | 1935741 | 2021-11-20 | Washington | Ohio | 39167 | 8442 | 155 |
1932491 | 1932491 | 2021-11-19 | Washington | Ohio | 39167 | 8427 | 155 |
1929240 | 1929240 | 2021-11-18 | Washington | Ohio | 39167 | 8408 | 154 |
1925990 | 1925990 | 2021-11-17 | Washington | Ohio | 39167 | 8387 | 154 |
1922740 | 1922740 | 2021-11-16 | Washington | Ohio | 39167 | 8378 | 154 |
1919491 | 1919491 | 2021-11-15 | Washington | Ohio | 39167 | 8362 | 153 |
1916241 | 1916241 | 2021-11-14 | Washington | Ohio | 39167 | 8352 | 153 |
1912991 | 1912991 | 2021-11-13 | Washington | Ohio | 39167 | 8344 | 153 |
1909741 | 1909741 | 2021-11-12 | Washington | Ohio | 39167 | 8333 | 153 |
1906492 | 1906492 | 2021-11-11 | Washington | Ohio | 39167 | 8323 | 152 |
1903243 | 1903243 | 2021-11-10 | Washington | Ohio | 39167 | 8302 | 152 |
1899993 | 1899993 | 2021-11-09 | Washington | Ohio | 39167 | 8283 | 152 |
1896743 | 1896743 | 2021-11-08 | Washington | Ohio | 39167 | 8271 | 151 |
1893493 | 1893493 | 2021-11-07 | Washington | Ohio | 39167 | 8259 | 151 |
1890243 | 1890243 | 2021-11-06 | Washington | Ohio | 39167 | 8250 | 151 |
1886993 | 1886993 | 2021-11-05 | Washington | Ohio | 39167 | 8244 | 151 |
1883743 | 1883743 | 2021-11-04 | Washington | Ohio | 39167 | 8230 | 150 |
1880494 | 1880494 | 2021-11-03 | Washington | Ohio | 39167 | 8217 | 150 |
1877245 | 1877245 | 2021-11-02 | Washington | Ohio | 39167 | 8209 | 150 |
1873996 | 1873996 | 2021-11-01 | Washington | Ohio | 39167 | 8190 | 148 |
1870747 | 1870747 | 2021-10-31 | Washington | Ohio | 39167 | 8182 | 148 |
1867498 | 1867498 | 2021-10-30 | Washington | Ohio | 39167 | 8177 | 148 |
1864249 | 1864249 | 2021-10-29 | Washington | Ohio | 39167 | 8163 | 148 |
1861000 | 1861000 | 2021-10-28 | Washington | Ohio | 39167 | 8155 | 147 |
1857751 | 1857751 | 2021-10-27 | Washington | Ohio | 39167 | 8142 | 147 |
1854502 | 1854502 | 2021-10-26 | Washington | Ohio | 39167 | 8131 | 147 |
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);