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 |
---|---|---|---|---|---|---|---|
2177338 | 2177338 | 2022-02-02 | Randolph | West Virginia | 54083 | 8256 | 66 |
2174085 | 2174085 | 2022-02-01 | Randolph | West Virginia | 54083 | 8190 | 66 |
2170833 | 2170833 | 2022-01-31 | Randolph | West Virginia | 54083 | 8095 | 66 |
2167580 | 2167580 | 2022-01-30 | Randolph | West Virginia | 54083 | 8064 | 65 |
2164325 | 2164325 | 2022-01-29 | Randolph | West Virginia | 54083 | 7991 | 65 |
2161070 | 2161070 | 2022-01-28 | Randolph | West Virginia | 54083 | 7870 | 65 |
2157814 | 2157814 | 2022-01-27 | Randolph | West Virginia | 54083 | 7790 | 65 |
2154561 | 2154561 | 2022-01-26 | Randolph | West Virginia | 54083 | 7689 | 65 |
2151308 | 2151308 | 2022-01-25 | Randolph | West Virginia | 54083 | 7626 | 65 |
2148056 | 2148056 | 2022-01-24 | Randolph | West Virginia | 54083 | 7536 | 65 |
2144804 | 2144804 | 2022-01-23 | Randolph | West Virginia | 54083 | 7470 | 65 |
2141549 | 2141549 | 2022-01-22 | Randolph | West Virginia | 54083 | 7414 | 65 |
2138293 | 2138293 | 2022-01-21 | Randolph | West Virginia | 54083 | 7305 | 65 |
2135038 | 2135038 | 2022-01-20 | Randolph | West Virginia | 54083 | 7195 | 65 |
2131786 | 2131786 | 2022-01-19 | Randolph | West Virginia | 54083 | 7070 | 65 |
2128532 | 2128532 | 2022-01-18 | Randolph | West Virginia | 54083 | 6967 | 65 |
2125279 | 2125279 | 2022-01-17 | Randolph | West Virginia | 54083 | 6896 | 65 |
2122027 | 2122027 | 2022-01-16 | Randolph | West Virginia | 54083 | 6858 | 65 |
2118775 | 2118775 | 2022-01-15 | Randolph | West Virginia | 54083 | 6795 | 65 |
2115523 | 2115523 | 2022-01-14 | Randolph | West Virginia | 54083 | 6710 | 65 |
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 |
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);