ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Berkeley" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177298 | 2177298 | 2022-02-02 | Berkeley | West Virginia | 54003 | 34021 | 246 |
2174045 | 2174045 | 2022-02-01 | Berkeley | West Virginia | 54003 | 33906 | 245 |
2170793 | 2170793 | 2022-01-31 | Berkeley | West Virginia | 54003 | 33815 | 242 |
2167540 | 2167540 | 2022-01-30 | Berkeley | West Virginia | 54003 | 33764 | 241 |
2164285 | 2164285 | 2022-01-29 | Berkeley | West Virginia | 54003 | 33665 | 241 |
2161030 | 2161030 | 2022-01-28 | Berkeley | West Virginia | 54003 | 33586 | 241 |
2157774 | 2157774 | 2022-01-27 | Berkeley | West Virginia | 54003 | 33391 | 236 |
2154521 | 2154521 | 2022-01-26 | Berkeley | West Virginia | 54003 | 33229 | 234 |
2151268 | 2151268 | 2022-01-25 | Berkeley | West Virginia | 54003 | 33018 | 233 |
2148016 | 2148016 | 2022-01-24 | Berkeley | West Virginia | 54003 | 32906 | 233 |
2144764 | 2144764 | 2022-01-23 | Berkeley | West Virginia | 54003 | 32812 | 229 |
2141509 | 2141509 | 2022-01-22 | Berkeley | West Virginia | 54003 | 32609 | 229 |
2138253 | 2138253 | 2022-01-21 | Berkeley | West Virginia | 54003 | 32302 | 229 |
2134998 | 2134998 | 2022-01-20 | Berkeley | West Virginia | 54003 | 32088 | 226 |
2131746 | 2131746 | 2022-01-19 | Berkeley | West Virginia | 54003 | 31575 | 226 |
2128492 | 2128492 | 2022-01-18 | Berkeley | West Virginia | 54003 | 31256 | 223 |
2125239 | 2125239 | 2022-01-17 | Berkeley | West Virginia | 54003 | 31188 | 223 |
2121987 | 2121987 | 2022-01-16 | Berkeley | West Virginia | 54003 | 30974 | 222 |
2118735 | 2118735 | 2022-01-15 | Berkeley | West Virginia | 54003 | 30595 | 222 |
2115483 | 2115483 | 2022-01-14 | Berkeley | West Virginia | 54003 | 30262 | 222 |
2112231 | 2112231 | 2022-01-13 | Berkeley | West Virginia | 54003 | 29891 | 222 |
2108979 | 2108979 | 2022-01-12 | Berkeley | West Virginia | 54003 | 29501 | 222 |
2105728 | 2105728 | 2022-01-11 | Berkeley | West Virginia | 54003 | 29135 | 222 |
2102477 | 2102477 | 2022-01-10 | Berkeley | West Virginia | 54003 | 28892 | 221 |
2099226 | 2099226 | 2022-01-09 | Berkeley | West Virginia | 54003 | 28591 | 219 |
2095975 | 2095975 | 2022-01-08 | Berkeley | West Virginia | 54003 | 28342 | 219 |
2092723 | 2092723 | 2022-01-07 | Berkeley | West Virginia | 54003 | 27808 | 219 |
2089471 | 2089471 | 2022-01-06 | Berkeley | West Virginia | 54003 | 27382 | 217 |
2086220 | 2086220 | 2022-01-05 | Berkeley | West Virginia | 54003 | 26580 | 215 |
2082968 | 2082968 | 2022-01-04 | Berkeley | West Virginia | 54003 | 26201 | 215 |
2079716 | 2079716 | 2022-01-03 | Berkeley | West Virginia | 54003 | 25824 | 215 |
2076464 | 2076464 | 2022-01-02 | Berkeley | West Virginia | 54003 | 24218 | 215 |
2073213 | 2073213 | 2022-01-01 | Berkeley | West Virginia | 54003 | 24218 | 215 |
2069962 | 2069962 | 2021-12-31 | Berkeley | West Virginia | 54003 | 24218 | 215 |
2066711 | 2066711 | 2021-12-30 | Berkeley | West Virginia | 54003 | 24218 | 215 |
2063461 | 2063461 | 2021-12-29 | Berkeley | West Virginia | 54003 | 23932 | 210 |
2060211 | 2060211 | 2021-12-28 | Berkeley | West Virginia | 54003 | 23623 | 210 |
2056962 | 2056962 | 2021-12-27 | Berkeley | West Virginia | 54003 | 23529 | 209 |
2053713 | 2053713 | 2021-12-26 | Berkeley | West Virginia | 54003 | 23000 | 209 |
2050463 | 2050463 | 2021-12-25 | Berkeley | West Virginia | 54003 | 23000 | 209 |
2047213 | 2047213 | 2021-12-24 | Berkeley | West Virginia | 54003 | 23000 | 209 |
2043963 | 2043963 | 2021-12-23 | Berkeley | West Virginia | 54003 | 23000 | 209 |
2040714 | 2040714 | 2021-12-22 | Berkeley | West Virginia | 54003 | 22832 | 209 |
2037464 | 2037464 | 2021-12-21 | Berkeley | West Virginia | 54003 | 22667 | 209 |
2034214 | 2034214 | 2021-12-20 | Berkeley | West Virginia | 54003 | 22571 | 210 |
2030964 | 2030964 | 2021-12-19 | Berkeley | West Virginia | 54003 | 22467 | 208 |
2027713 | 2027713 | 2021-12-18 | Berkeley | West Virginia | 54003 | 22325 | 208 |
2024462 | 2024462 | 2021-12-17 | Berkeley | West Virginia | 54003 | 22174 | 208 |
2021211 | 2021211 | 2021-12-16 | Berkeley | West Virginia | 54003 | 22031 | 204 |
2017960 | 2017960 | 2021-12-15 | Berkeley | West Virginia | 54003 | 21875 | 204 |
2014710 | 2014710 | 2021-12-14 | Berkeley | West Virginia | 54003 | 21640 | 203 |
2011459 | 2011459 | 2021-12-13 | Berkeley | West Virginia | 54003 | 21556 | 203 |
2008208 | 2008208 | 2021-12-12 | Berkeley | West Virginia | 54003 | 21491 | 202 |
2004957 | 2004957 | 2021-12-11 | Berkeley | West Virginia | 54003 | 21368 | 202 |
2001706 | 2001706 | 2021-12-10 | Berkeley | West Virginia | 54003 | 21267 | 202 |
1998456 | 1998456 | 2021-12-09 | Berkeley | West Virginia | 54003 | 21156 | 201 |
1995205 | 1995205 | 2021-12-08 | Berkeley | West Virginia | 54003 | 21045 | 199 |
1991954 | 1991954 | 2021-12-07 | Berkeley | West Virginia | 54003 | 20893 | 199 |
1988703 | 1988703 | 2021-12-06 | Berkeley | West Virginia | 54003 | 20829 | 198 |
1985453 | 1985453 | 2021-12-05 | Berkeley | West Virginia | 54003 | 20782 | 198 |
1982203 | 1982203 | 2021-12-04 | Berkeley | West Virginia | 54003 | 20699 | 198 |
1978953 | 1978953 | 2021-12-03 | Berkeley | West Virginia | 54003 | 20615 | 198 |
1975703 | 1975703 | 2021-12-02 | Berkeley | West Virginia | 54003 | 20491 | 197 |
1972454 | 1972454 | 2021-12-01 | Berkeley | West Virginia | 54003 | 20372 | 196 |
1969204 | 1969204 | 2021-11-30 | Berkeley | West Virginia | 54003 | 20281 | 195 |
1965954 | 1965954 | 2021-11-29 | Berkeley | West Virginia | 54003 | 20218 | 195 |
1962702 | 1962702 | 2021-11-28 | Berkeley | West Virginia | 54003 | 19937 | 193 |
1959451 | 1959451 | 2021-11-27 | Berkeley | West Virginia | 54003 | 19937 | 193 |
1956200 | 1956200 | 2021-11-26 | Berkeley | West Virginia | 54003 | 19937 | 193 |
1952949 | 1952949 | 2021-11-25 | Berkeley | West Virginia | 54003 | 19937 | 193 |
1949698 | 1949698 | 2021-11-24 | Berkeley | West Virginia | 54003 | 19937 | 193 |
1946447 | 1946447 | 2021-11-23 | Berkeley | West Virginia | 54003 | 19890 | 192 |
1943196 | 1943196 | 2021-11-22 | Berkeley | West Virginia | 54003 | 19837 | 191 |
1939946 | 1939946 | 2021-11-21 | Berkeley | West Virginia | 54003 | 19815 | 190 |
1936696 | 1936696 | 2021-11-20 | Berkeley | West Virginia | 54003 | 19747 | 190 |
1933446 | 1933446 | 2021-11-19 | Berkeley | West Virginia | 54003 | 19672 | 190 |
1930194 | 1930194 | 2021-11-18 | Berkeley | West Virginia | 54003 | 19600 | 190 |
1926944 | 1926944 | 2021-11-17 | Berkeley | West Virginia | 54003 | 19526 | 190 |
1923694 | 1923694 | 2021-11-16 | Berkeley | West Virginia | 54003 | 19461 | 190 |
1920445 | 1920445 | 2021-11-15 | Berkeley | West Virginia | 54003 | 19421 | 190 |
1917195 | 1917195 | 2021-11-14 | Berkeley | West Virginia | 54003 | 19395 | 189 |
1913945 | 1913945 | 2021-11-13 | Berkeley | West Virginia | 54003 | 19328 | 189 |
1910695 | 1910695 | 2021-11-12 | Berkeley | West Virginia | 54003 | 19274 | 189 |
1907446 | 1907446 | 2021-11-11 | Berkeley | West Virginia | 54003 | 19214 | 189 |
1904197 | 1904197 | 2021-11-10 | Berkeley | West Virginia | 54003 | 19155 | 188 |
1900947 | 1900947 | 2021-11-09 | Berkeley | West Virginia | 54003 | 19051 | 188 |
1897697 | 1897697 | 2021-11-08 | Berkeley | West Virginia | 54003 | 19018 | 187 |
1894447 | 1894447 | 2021-11-07 | Berkeley | West Virginia | 54003 | 18985 | 186 |
1891197 | 1891197 | 2021-11-06 | Berkeley | West Virginia | 54003 | 18950 | 186 |
1887947 | 1887947 | 2021-11-05 | Berkeley | West Virginia | 54003 | 18892 | 186 |
1884697 | 1884697 | 2021-11-04 | Berkeley | West Virginia | 54003 | 18849 | 186 |
1881448 | 1881448 | 2021-11-03 | Berkeley | West Virginia | 54003 | 18805 | 185 |
1878199 | 1878199 | 2021-11-02 | Berkeley | West Virginia | 54003 | 18777 | 185 |
1874950 | 1874950 | 2021-11-01 | Berkeley | West Virginia | 54003 | 18740 | 184 |
1871701 | 1871701 | 2021-10-31 | Berkeley | West Virginia | 54003 | 18715 | 183 |
1868452 | 1868452 | 2021-10-30 | Berkeley | West Virginia | 54003 | 18672 | 183 |
1865203 | 1865203 | 2021-10-29 | Berkeley | West Virginia | 54003 | 18634 | 183 |
1861954 | 1861954 | 2021-10-28 | Berkeley | West Virginia | 54003 | 18564 | 181 |
1858705 | 1858705 | 2021-10-27 | Berkeley | West Virginia | 54003 | 18522 | 181 |
1855456 | 1855456 | 2021-10-26 | Berkeley | West Virginia | 54003 | 18465 | 180 |
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);