ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Randolph" 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 |
---|---|---|---|---|---|---|---|
2112271 | 2112271 | 2022-01-13 | Randolph | West Virginia | 54083 | 6598 | 65 |
2109019 | 2109019 | 2022-01-12 | Randolph | West Virginia | 54083 | 6528 | 64 |
2105768 | 2105768 | 2022-01-11 | Randolph | West Virginia | 54083 | 6460 | 64 |
2102517 | 2102517 | 2022-01-10 | Randolph | West Virginia | 54083 | 6384 | 64 |
2099266 | 2099266 | 2022-01-09 | Randolph | West Virginia | 54083 | 6342 | 64 |
2096015 | 2096015 | 2022-01-08 | Randolph | West Virginia | 54083 | 6317 | 64 |
2092763 | 2092763 | 2022-01-07 | Randolph | West Virginia | 54083 | 6267 | 64 |
2089511 | 2089511 | 2022-01-06 | Randolph | West Virginia | 54083 | 6206 | 64 |
2086260 | 2086260 | 2022-01-05 | Randolph | West Virginia | 54083 | 6127 | 64 |
2083008 | 2083008 | 2022-01-04 | Randolph | West Virginia | 54083 | 6089 | 64 |
2079756 | 2079756 | 2022-01-03 | Randolph | West Virginia | 54083 | 6057 | 64 |
2076504 | 2076504 | 2022-01-02 | Randolph | West Virginia | 54083 | 5933 | 64 |
2073253 | 2073253 | 2022-01-01 | Randolph | West Virginia | 54083 | 5933 | 64 |
2070002 | 2070002 | 2021-12-31 | Randolph | West Virginia | 54083 | 5933 | 64 |
2066751 | 2066751 | 2021-12-30 | Randolph | West Virginia | 54083 | 5933 | 64 |
2063501 | 2063501 | 2021-12-29 | Randolph | West Virginia | 54083 | 5900 | 64 |
2060251 | 2060251 | 2021-12-28 | Randolph | West Virginia | 54083 | 5873 | 64 |
2057002 | 2057002 | 2021-12-27 | Randolph | West Virginia | 54083 | 5862 | 63 |
2053753 | 2053753 | 2021-12-26 | Randolph | West Virginia | 54083 | 5821 | 63 |
2050503 | 2050503 | 2021-12-25 | Randolph | West Virginia | 54083 | 5821 | 63 |
2047253 | 2047253 | 2021-12-24 | Randolph | West Virginia | 54083 | 5821 | 63 |
2044003 | 2044003 | 2021-12-23 | Randolph | West Virginia | 54083 | 5821 | 63 |
2040754 | 2040754 | 2021-12-22 | Randolph | West Virginia | 54083 | 5786 | 63 |
2037504 | 2037504 | 2021-12-21 | Randolph | West Virginia | 54083 | 5763 | 63 |
2034254 | 2034254 | 2021-12-20 | Randolph | West Virginia | 54083 | 5756 | 61 |
2031004 | 2031004 | 2021-12-19 | Randolph | West Virginia | 54083 | 5741 | 60 |
2027753 | 2027753 | 2021-12-18 | Randolph | West Virginia | 54083 | 5729 | 60 |
2024502 | 2024502 | 2021-12-17 | Randolph | West Virginia | 54083 | 5707 | 60 |
2021251 | 2021251 | 2021-12-16 | Randolph | West Virginia | 54083 | 5697 | 59 |
2018000 | 2018000 | 2021-12-15 | Randolph | West Virginia | 54083 | 5677 | 59 |
2014750 | 2014750 | 2021-12-14 | Randolph | West Virginia | 54083 | 5653 | 59 |
2011499 | 2011499 | 2021-12-13 | Randolph | West Virginia | 54083 | 5643 | 59 |
2008248 | 2008248 | 2021-12-12 | Randolph | West Virginia | 54083 | 5634 | 58 |
2004997 | 2004997 | 2021-12-11 | Randolph | West Virginia | 54083 | 5626 | 58 |
2001746 | 2001746 | 2021-12-10 | Randolph | West Virginia | 54083 | 5609 | 58 |
1998496 | 1998496 | 2021-12-09 | Randolph | West Virginia | 54083 | 5599 | 57 |
1995245 | 1995245 | 2021-12-08 | Randolph | West Virginia | 54083 | 5580 | 57 |
1991994 | 1991994 | 2021-12-07 | Randolph | West Virginia | 54083 | 5577 | 57 |
1988743 | 1988743 | 2021-12-06 | Randolph | West Virginia | 54083 | 5570 | 56 |
1985493 | 1985493 | 2021-12-05 | Randolph | West Virginia | 54083 | 5561 | 56 |
1982243 | 1982243 | 2021-12-04 | Randolph | West Virginia | 54083 | 5555 | 56 |
1978993 | 1978993 | 2021-12-03 | Randolph | West Virginia | 54083 | 5542 | 56 |
1975743 | 1975743 | 2021-12-02 | Randolph | West Virginia | 54083 | 5525 | 56 |
1972494 | 1972494 | 2021-12-01 | Randolph | West Virginia | 54083 | 5510 | 56 |
1969244 | 1969244 | 2021-11-30 | Randolph | West Virginia | 54083 | 5498 | 56 |
1965994 | 1965994 | 2021-11-29 | Randolph | West Virginia | 54083 | 5478 | 56 |
1962742 | 1962742 | 2021-11-28 | Randolph | West Virginia | 54083 | 5462 | 55 |
1959491 | 1959491 | 2021-11-27 | Randolph | West Virginia | 54083 | 5462 | 55 |
1956240 | 1956240 | 2021-11-26 | Randolph | West Virginia | 54083 | 5462 | 55 |
1952989 | 1952989 | 2021-11-25 | Randolph | West Virginia | 54083 | 5462 | 55 |
1949738 | 1949738 | 2021-11-24 | Randolph | West Virginia | 54083 | 5462 | 55 |
1946487 | 1946487 | 2021-11-23 | Randolph | West Virginia | 54083 | 5452 | 55 |
1943236 | 1943236 | 2021-11-22 | Randolph | West Virginia | 54083 | 5435 | 55 |
1939986 | 1939986 | 2021-11-21 | Randolph | West Virginia | 54083 | 5417 | 53 |
1936736 | 1936736 | 2021-11-20 | Randolph | West Virginia | 54083 | 5406 | 53 |
1933486 | 1933486 | 2021-11-19 | Randolph | West Virginia | 54083 | 5387 | 53 |
1930234 | 1930234 | 2021-11-18 | Randolph | West Virginia | 54083 | 5373 | 53 |
1926984 | 1926984 | 2021-11-17 | Randolph | West Virginia | 54083 | 5343 | 53 |
1923734 | 1923734 | 2021-11-16 | Randolph | West Virginia | 54083 | 5320 | 52 |
1920485 | 1920485 | 2021-11-15 | Randolph | West Virginia | 54083 | 5309 | 51 |
1917235 | 1917235 | 2021-11-14 | Randolph | West Virginia | 54083 | 5303 | 51 |
1913985 | 1913985 | 2021-11-13 | Randolph | West Virginia | 54083 | 5294 | 51 |
1910735 | 1910735 | 2021-11-12 | Randolph | West Virginia | 54083 | 5283 | 51 |
1907486 | 1907486 | 2021-11-11 | Randolph | West Virginia | 54083 | 5266 | 51 |
1904237 | 1904237 | 2021-11-10 | Randolph | West Virginia | 54083 | 5254 | 50 |
1900987 | 1900987 | 2021-11-09 | Randolph | West Virginia | 54083 | 5237 | 50 |
1897737 | 1897737 | 2021-11-08 | Randolph | West Virginia | 54083 | 5221 | 50 |
1894487 | 1894487 | 2021-11-07 | Randolph | West Virginia | 54083 | 5217 | 50 |
1891237 | 1891237 | 2021-11-06 | Randolph | West Virginia | 54083 | 5212 | 50 |
1887987 | 1887987 | 2021-11-05 | Randolph | West Virginia | 54083 | 5202 | 50 |
1884737 | 1884737 | 2021-11-04 | Randolph | West Virginia | 54083 | 5186 | 50 |
1881488 | 1881488 | 2021-11-03 | Randolph | West Virginia | 54083 | 5176 | 50 |
1878239 | 1878239 | 2021-11-02 | Randolph | West Virginia | 54083 | 5162 | 50 |
1874990 | 1874990 | 2021-11-01 | Randolph | West Virginia | 54083 | 5149 | 50 |
1871741 | 1871741 | 2021-10-31 | Randolph | West Virginia | 54083 | 5144 | 50 |
1868492 | 1868492 | 2021-10-30 | Randolph | West Virginia | 54083 | 5143 | 50 |
1865243 | 1865243 | 2021-10-29 | Randolph | West Virginia | 54083 | 5100 | 50 |
1861994 | 1861994 | 2021-10-28 | Randolph | West Virginia | 54083 | 5088 | 49 |
1858745 | 1858745 | 2021-10-27 | Randolph | West Virginia | 54083 | 5077 | 48 |
1855496 | 1855496 | 2021-10-26 | Randolph | West Virginia | 54083 | 5066 | 47 |
1852247 | 1852247 | 2021-10-25 | Randolph | West Virginia | 54083 | 5047 | 47 |
1848997 | 1848997 | 2021-10-24 | Randolph | West Virginia | 54083 | 5029 | 47 |
1845747 | 1845747 | 2021-10-23 | Randolph | West Virginia | 54083 | 5025 | 47 |
1842497 | 1842497 | 2021-10-22 | Randolph | West Virginia | 54083 | 5015 | 47 |
1839248 | 1839248 | 2021-10-21 | Randolph | West Virginia | 54083 | 4996 | 47 |
1835999 | 1835999 | 2021-10-20 | Randolph | West Virginia | 54083 | 4988 | 46 |
1832750 | 1832750 | 2021-10-19 | Randolph | West Virginia | 54083 | 4976 | 44 |
1829501 | 1829501 | 2021-10-18 | Randolph | West Virginia | 54083 | 4956 | 44 |
1826252 | 1826252 | 2021-10-17 | Randolph | West Virginia | 54083 | 4948 | 44 |
1823003 | 1823003 | 2021-10-16 | Randolph | West Virginia | 54083 | 4944 | 44 |
1819754 | 1819754 | 2021-10-15 | Randolph | West Virginia | 54083 | 4935 | 44 |
1816505 | 1816505 | 2021-10-14 | Randolph | West Virginia | 54083 | 4923 | 43 |
1813257 | 1813257 | 2021-10-13 | Randolph | West Virginia | 54083 | 4905 | 41 |
1810008 | 1810008 | 2021-10-12 | Randolph | West Virginia | 54083 | 4894 | 41 |
1806759 | 1806759 | 2021-10-11 | Randolph | West Virginia | 54083 | 4878 | 40 |
1803508 | 1803508 | 2021-10-10 | Randolph | West Virginia | 54083 | 4869 | 39 |
1800259 | 1800259 | 2021-10-09 | Randolph | West Virginia | 54083 | 4864 | 38 |
1797010 | 1797010 | 2021-10-08 | Randolph | West Virginia | 54083 | 4849 | 39 |
1793761 | 1793761 | 2021-10-07 | Randolph | West Virginia | 54083 | 4826 | 38 |
1790512 | 1790512 | 2021-10-06 | Randolph | West Virginia | 54083 | 4804 | 37 |
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);