ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 54055 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 |
---|---|---|---|---|---|---|---|
2177324 | 2177324 | 2022-02-02 | Mercer | West Virginia | 54055 | 14803 | 231 |
2174071 | 2174071 | 2022-02-01 | Mercer | West Virginia | 54055 | 14672 | 227 |
2170819 | 2170819 | 2022-01-31 | Mercer | West Virginia | 54055 | 14611 | 227 |
2167566 | 2167566 | 2022-01-30 | Mercer | West Virginia | 54055 | 14490 | 226 |
2164311 | 2164311 | 2022-01-29 | Mercer | West Virginia | 54055 | 14384 | 226 |
2161056 | 2161056 | 2022-01-28 | Mercer | West Virginia | 54055 | 14221 | 226 |
2157800 | 2157800 | 2022-01-27 | Mercer | West Virginia | 54055 | 14052 | 222 |
2154547 | 2154547 | 2022-01-26 | Mercer | West Virginia | 54055 | 13871 | 221 |
2151294 | 2151294 | 2022-01-25 | Mercer | West Virginia | 54055 | 13744 | 217 |
2148042 | 2148042 | 2022-01-24 | Mercer | West Virginia | 54055 | 13628 | 217 |
2144790 | 2144790 | 2022-01-23 | Mercer | West Virginia | 54055 | 13475 | 217 |
2141535 | 2141535 | 2022-01-22 | Mercer | West Virginia | 54055 | 13319 | 217 |
2138279 | 2138279 | 2022-01-21 | Mercer | West Virginia | 54055 | 13115 | 217 |
2135024 | 2135024 | 2022-01-20 | Mercer | West Virginia | 54055 | 12926 | 217 |
2131772 | 2131772 | 2022-01-19 | Mercer | West Virginia | 54055 | 12767 | 217 |
2128518 | 2128518 | 2022-01-18 | Mercer | West Virginia | 54055 | 12654 | 214 |
2125265 | 2125265 | 2022-01-17 | Mercer | West Virginia | 54055 | 12595 | 214 |
2122013 | 2122013 | 2022-01-16 | Mercer | West Virginia | 54055 | 12462 | 213 |
2118761 | 2118761 | 2022-01-15 | Mercer | West Virginia | 54055 | 12362 | 213 |
2115509 | 2115509 | 2022-01-14 | Mercer | West Virginia | 54055 | 12250 | 213 |
2112257 | 2112257 | 2022-01-13 | Mercer | West Virginia | 54055 | 12152 | 213 |
2109005 | 2109005 | 2022-01-12 | Mercer | West Virginia | 54055 | 11994 | 212 |
2105754 | 2105754 | 2022-01-11 | Mercer | West Virginia | 54055 | 11908 | 210 |
2102503 | 2102503 | 2022-01-10 | Mercer | West Virginia | 54055 | 11829 | 210 |
2099252 | 2099252 | 2022-01-09 | Mercer | West Virginia | 54055 | 11736 | 202 |
2096001 | 2096001 | 2022-01-08 | Mercer | West Virginia | 54055 | 11695 | 202 |
2092749 | 2092749 | 2022-01-07 | Mercer | West Virginia | 54055 | 11601 | 202 |
2089497 | 2089497 | 2022-01-06 | Mercer | West Virginia | 54055 | 11481 | 202 |
2086246 | 2086246 | 2022-01-05 | Mercer | West Virginia | 54055 | 11409 | 202 |
2082994 | 2082994 | 2022-01-04 | Mercer | West Virginia | 54055 | 11359 | 202 |
2079742 | 2079742 | 2022-01-03 | Mercer | West Virginia | 54055 | 11312 | 202 |
2076490 | 2076490 | 2022-01-02 | Mercer | West Virginia | 54055 | 11076 | 202 |
2073239 | 2073239 | 2022-01-01 | Mercer | West Virginia | 54055 | 11076 | 202 |
2069988 | 2069988 | 2021-12-31 | Mercer | West Virginia | 54055 | 11076 | 202 |
2066737 | 2066737 | 2021-12-30 | Mercer | West Virginia | 54055 | 11076 | 202 |
2063487 | 2063487 | 2021-12-29 | Mercer | West Virginia | 54055 | 10985 | 197 |
2060237 | 2060237 | 2021-12-28 | Mercer | West Virginia | 54055 | 10955 | 197 |
2056988 | 2056988 | 2021-12-27 | Mercer | West Virginia | 54055 | 10921 | 196 |
2053739 | 2053739 | 2021-12-26 | Mercer | West Virginia | 54055 | 10770 | 196 |
2050489 | 2050489 | 2021-12-25 | Mercer | West Virginia | 54055 | 10770 | 196 |
2047239 | 2047239 | 2021-12-24 | Mercer | West Virginia | 54055 | 10770 | 196 |
2043989 | 2043989 | 2021-12-23 | Mercer | West Virginia | 54055 | 10770 | 196 |
2040740 | 2040740 | 2021-12-22 | Mercer | West Virginia | 54055 | 10700 | 196 |
2037490 | 2037490 | 2021-12-21 | Mercer | West Virginia | 54055 | 10650 | 195 |
2034240 | 2034240 | 2021-12-20 | Mercer | West Virginia | 54055 | 10610 | 194 |
2030990 | 2030990 | 2021-12-19 | Mercer | West Virginia | 54055 | 10562 | 194 |
2027739 | 2027739 | 2021-12-18 | Mercer | West Virginia | 54055 | 10515 | 194 |
2024488 | 2024488 | 2021-12-17 | Mercer | West Virginia | 54055 | 10439 | 194 |
2021237 | 2021237 | 2021-12-16 | Mercer | West Virginia | 54055 | 10391 | 194 |
2017986 | 2017986 | 2021-12-15 | Mercer | West Virginia | 54055 | 10331 | 194 |
2014736 | 2014736 | 2021-12-14 | Mercer | West Virginia | 54055 | 10301 | 194 |
2011485 | 2011485 | 2021-12-13 | Mercer | West Virginia | 54055 | 10277 | 193 |
2008234 | 2008234 | 2021-12-12 | Mercer | West Virginia | 54055 | 10242 | 191 |
2004983 | 2004983 | 2021-12-11 | Mercer | West Virginia | 54055 | 10202 | 191 |
2001732 | 2001732 | 2021-12-10 | Mercer | West Virginia | 54055 | 10152 | 191 |
1998482 | 1998482 | 2021-12-09 | Mercer | West Virginia | 54055 | 10101 | 190 |
1995231 | 1995231 | 2021-12-08 | Mercer | West Virginia | 54055 | 10031 | 190 |
1991980 | 1991980 | 2021-12-07 | Mercer | West Virginia | 54055 | 9986 | 190 |
1988729 | 1988729 | 2021-12-06 | Mercer | West Virginia | 54055 | 9954 | 189 |
1985479 | 1985479 | 2021-12-05 | Mercer | West Virginia | 54055 | 9917 | 188 |
1982229 | 1982229 | 2021-12-04 | Mercer | West Virginia | 54055 | 9869 | 188 |
1978979 | 1978979 | 2021-12-03 | Mercer | West Virginia | 54055 | 9811 | 188 |
1975729 | 1975729 | 2021-12-02 | Mercer | West Virginia | 54055 | 9757 | 188 |
1972480 | 1972480 | 2021-12-01 | Mercer | West Virginia | 54055 | 9690 | 185 |
1969230 | 1969230 | 2021-11-30 | Mercer | West Virginia | 54055 | 9652 | 184 |
1965980 | 1965980 | 2021-11-29 | Mercer | West Virginia | 54055 | 9624 | 183 |
1962728 | 1962728 | 2021-11-28 | Mercer | West Virginia | 54055 | 9469 | 184 |
1959477 | 1959477 | 2021-11-27 | Mercer | West Virginia | 54055 | 9469 | 184 |
1956226 | 1956226 | 2021-11-26 | Mercer | West Virginia | 54055 | 9469 | 184 |
1952975 | 1952975 | 2021-11-25 | Mercer | West Virginia | 54055 | 9469 | 184 |
1949724 | 1949724 | 2021-11-24 | Mercer | West Virginia | 54055 | 9469 | 184 |
1946473 | 1946473 | 2021-11-23 | Mercer | West Virginia | 54055 | 9447 | 182 |
1943222 | 1943222 | 2021-11-22 | Mercer | West Virginia | 54055 | 9434 | 182 |
1939972 | 1939972 | 2021-11-21 | Mercer | West Virginia | 54055 | 9395 | 182 |
1936722 | 1936722 | 2021-11-20 | Mercer | West Virginia | 54055 | 9359 | 182 |
1933472 | 1933472 | 2021-11-19 | Mercer | West Virginia | 54055 | 9317 | 182 |
1930220 | 1930220 | 2021-11-18 | Mercer | West Virginia | 54055 | 9290 | 182 |
1926970 | 1926970 | 2021-11-17 | Mercer | West Virginia | 54055 | 9247 | 181 |
1923720 | 1923720 | 2021-11-16 | Mercer | West Virginia | 54055 | 9217 | 181 |
1920471 | 1920471 | 2021-11-15 | Mercer | West Virginia | 54055 | 9196 | 181 |
1917221 | 1917221 | 2021-11-14 | Mercer | West Virginia | 54055 | 9165 | 180 |
1913971 | 1913971 | 2021-11-13 | Mercer | West Virginia | 54055 | 9137 | 180 |
1910721 | 1910721 | 2021-11-12 | Mercer | West Virginia | 54055 | 9115 | 180 |
1907472 | 1907472 | 2021-11-11 | Mercer | West Virginia | 54055 | 9082 | 180 |
1904223 | 1904223 | 2021-11-10 | Mercer | West Virginia | 54055 | 9045 | 180 |
1900973 | 1900973 | 2021-11-09 | Mercer | West Virginia | 54055 | 9014 | 180 |
1897723 | 1897723 | 2021-11-08 | Mercer | West Virginia | 54055 | 8995 | 180 |
1894473 | 1894473 | 2021-11-07 | Mercer | West Virginia | 54055 | 8981 | 180 |
1891223 | 1891223 | 2021-11-06 | Mercer | West Virginia | 54055 | 8943 | 180 |
1887973 | 1887973 | 2021-11-05 | Mercer | West Virginia | 54055 | 8910 | 180 |
1884723 | 1884723 | 2021-11-04 | Mercer | West Virginia | 54055 | 8867 | 180 |
1881474 | 1881474 | 2021-11-03 | Mercer | West Virginia | 54055 | 8830 | 179 |
1878225 | 1878225 | 2021-11-02 | Mercer | West Virginia | 54055 | 8807 | 179 |
1874976 | 1874976 | 2021-11-01 | Mercer | West Virginia | 54055 | 8790 | 179 |
1871727 | 1871727 | 2021-10-31 | Mercer | West Virginia | 54055 | 8756 | 179 |
1868478 | 1868478 | 2021-10-30 | Mercer | West Virginia | 54055 | 8741 | 179 |
1865229 | 1865229 | 2021-10-29 | Mercer | West Virginia | 54055 | 8705 | 179 |
1861980 | 1861980 | 2021-10-28 | Mercer | West Virginia | 54055 | 8661 | 179 |
1858731 | 1858731 | 2021-10-27 | Mercer | West Virginia | 54055 | 8628 | 174 |
1855482 | 1855482 | 2021-10-26 | Mercer | West Virginia | 54055 | 8614 | 174 |
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);