ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jefferson" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- …
state 1
- West Virginia · 688 ✖
fips 1
- 54037 688
county 1
- Jefferson · 688 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177315 | 2177315 | 2022-02-02 | Jefferson | West Virginia | 54037 | 13536 | 117 |
2174062 | 2174062 | 2022-02-01 | Jefferson | West Virginia | 54037 | 13508 | 117 |
2170810 | 2170810 | 2022-01-31 | Jefferson | West Virginia | 54037 | 13457 | 116 |
2167557 | 2167557 | 2022-01-30 | Jefferson | West Virginia | 54037 | 13444 | 113 |
2164302 | 2164302 | 2022-01-29 | Jefferson | West Virginia | 54037 | 13387 | 113 |
2161047 | 2161047 | 2022-01-28 | Jefferson | West Virginia | 54037 | 13337 | 113 |
2157791 | 2157791 | 2022-01-27 | Jefferson | West Virginia | 54037 | 13257 | 112 |
2154538 | 2154538 | 2022-01-26 | Jefferson | West Virginia | 54037 | 13181 | 111 |
2151285 | 2151285 | 2022-01-25 | Jefferson | West Virginia | 54037 | 13092 | 111 |
2148033 | 2148033 | 2022-01-24 | Jefferson | West Virginia | 54037 | 13041 | 110 |
2144781 | 2144781 | 2022-01-23 | Jefferson | West Virginia | 54037 | 13001 | 110 |
2141526 | 2141526 | 2022-01-22 | Jefferson | West Virginia | 54037 | 12914 | 110 |
2138270 | 2138270 | 2022-01-21 | Jefferson | West Virginia | 54037 | 12771 | 110 |
2135015 | 2135015 | 2022-01-20 | Jefferson | West Virginia | 54037 | 12654 | 110 |
2131763 | 2131763 | 2022-01-19 | Jefferson | West Virginia | 54037 | 12493 | 110 |
2128509 | 2128509 | 2022-01-18 | Jefferson | West Virginia | 54037 | 12372 | 109 |
2125256 | 2125256 | 2022-01-17 | Jefferson | West Virginia | 54037 | 12337 | 106 |
2122004 | 2122004 | 2022-01-16 | Jefferson | West Virginia | 54037 | 12209 | 105 |
2118752 | 2118752 | 2022-01-15 | Jefferson | West Virginia | 54037 | 12041 | 105 |
2115500 | 2115500 | 2022-01-14 | Jefferson | West Virginia | 54037 | 11875 | 105 |
2112248 | 2112248 | 2022-01-13 | Jefferson | West Virginia | 54037 | 11636 | 101 |
2108996 | 2108996 | 2022-01-12 | Jefferson | West Virginia | 54037 | 11465 | 101 |
2105745 | 2105745 | 2022-01-11 | Jefferson | West Virginia | 54037 | 11272 | 101 |
2102494 | 2102494 | 2022-01-10 | Jefferson | West Virginia | 54037 | 11152 | 100 |
2099243 | 2099243 | 2022-01-09 | Jefferson | West Virginia | 54037 | 10970 | 100 |
2095992 | 2095992 | 2022-01-08 | Jefferson | West Virginia | 54037 | 10848 | 100 |
2092740 | 2092740 | 2022-01-07 | Jefferson | West Virginia | 54037 | 10615 | 100 |
2089488 | 2089488 | 2022-01-06 | Jefferson | West Virginia | 54037 | 10388 | 99 |
2086237 | 2086237 | 2022-01-05 | Jefferson | West Virginia | 54037 | 10098 | 99 |
2082985 | 2082985 | 2022-01-04 | Jefferson | West Virginia | 54037 | 9924 | 99 |
2079733 | 2079733 | 2022-01-03 | Jefferson | West Virginia | 54037 | 9782 | 98 |
2076481 | 2076481 | 2022-01-02 | Jefferson | West Virginia | 54037 | 9170 | 97 |
2073230 | 2073230 | 2022-01-01 | Jefferson | West Virginia | 54037 | 9170 | 97 |
2069979 | 2069979 | 2021-12-31 | Jefferson | West Virginia | 54037 | 9170 | 97 |
2066728 | 2066728 | 2021-12-30 | Jefferson | West Virginia | 54037 | 9170 | 97 |
2063478 | 2063478 | 2021-12-29 | Jefferson | West Virginia | 54037 | 8991 | 97 |
2060228 | 2060228 | 2021-12-28 | Jefferson | West Virginia | 54037 | 8908 | 97 |
2056979 | 2056979 | 2021-12-27 | Jefferson | West Virginia | 54037 | 8822 | 97 |
2053730 | 2053730 | 2021-12-26 | Jefferson | West Virginia | 54037 | 8570 | 97 |
2050480 | 2050480 | 2021-12-25 | Jefferson | West Virginia | 54037 | 8570 | 97 |
2047230 | 2047230 | 2021-12-24 | Jefferson | West Virginia | 54037 | 8570 | 97 |
2043980 | 2043980 | 2021-12-23 | Jefferson | West Virginia | 54037 | 8570 | 97 |
2040731 | 2040731 | 2021-12-22 | Jefferson | West Virginia | 54037 | 8490 | 97 |
2037481 | 2037481 | 2021-12-21 | Jefferson | West Virginia | 54037 | 8449 | 96 |
2034231 | 2034231 | 2021-12-20 | Jefferson | West Virginia | 54037 | 8397 | 95 |
2030981 | 2030981 | 2021-12-19 | Jefferson | West Virginia | 54037 | 8364 | 95 |
2027730 | 2027730 | 2021-12-18 | Jefferson | West Virginia | 54037 | 8317 | 95 |
2024479 | 2024479 | 2021-12-17 | Jefferson | West Virginia | 54037 | 8237 | 95 |
2021228 | 2021228 | 2021-12-16 | Jefferson | West Virginia | 54037 | 8198 | 95 |
2017977 | 2017977 | 2021-12-15 | Jefferson | West Virginia | 54037 | 8130 | 95 |
2014727 | 2014727 | 2021-12-14 | Jefferson | West Virginia | 54037 | 8057 | 94 |
2011476 | 2011476 | 2021-12-13 | Jefferson | West Virginia | 54037 | 8006 | 94 |
2008225 | 2008225 | 2021-12-12 | Jefferson | West Virginia | 54037 | 7980 | 94 |
2004974 | 2004974 | 2021-12-11 | Jefferson | West Virginia | 54037 | 7944 | 94 |
2001723 | 2001723 | 2021-12-10 | Jefferson | West Virginia | 54037 | 7881 | 94 |
1998473 | 1998473 | 2021-12-09 | Jefferson | West Virginia | 54037 | 7857 | 94 |
1995222 | 1995222 | 2021-12-08 | Jefferson | West Virginia | 54037 | 7810 | 94 |
1991971 | 1991971 | 2021-12-07 | Jefferson | West Virginia | 54037 | 7731 | 93 |
1988720 | 1988720 | 2021-12-06 | Jefferson | West Virginia | 54037 | 7703 | 92 |
1985470 | 1985470 | 2021-12-05 | Jefferson | West Virginia | 54037 | 7679 | 92 |
1982220 | 1982220 | 2021-12-04 | Jefferson | West Virginia | 54037 | 7653 | 92 |
1978970 | 1978970 | 2021-12-03 | Jefferson | West Virginia | 54037 | 7601 | 92 |
1975720 | 1975720 | 2021-12-02 | Jefferson | West Virginia | 54037 | 7544 | 92 |
1972471 | 1972471 | 2021-12-01 | Jefferson | West Virginia | 54037 | 7485 | 92 |
1969221 | 1969221 | 2021-11-30 | Jefferson | West Virginia | 54037 | 7438 | 92 |
1965971 | 1965971 | 2021-11-29 | Jefferson | West Virginia | 54037 | 7419 | 91 |
1962719 | 1962719 | 2021-11-28 | Jefferson | West Virginia | 54037 | 7292 | 90 |
1959468 | 1959468 | 2021-11-27 | Jefferson | West Virginia | 54037 | 7292 | 90 |
1956217 | 1956217 | 2021-11-26 | Jefferson | West Virginia | 54037 | 7292 | 90 |
1952966 | 1952966 | 2021-11-25 | Jefferson | West Virginia | 54037 | 7292 | 90 |
1949715 | 1949715 | 2021-11-24 | Jefferson | West Virginia | 54037 | 7292 | 90 |
1946464 | 1946464 | 2021-11-23 | Jefferson | West Virginia | 54037 | 7255 | 89 |
1943213 | 1943213 | 2021-11-22 | Jefferson | West Virginia | 54037 | 7245 | 90 |
1939963 | 1939963 | 2021-11-21 | Jefferson | West Virginia | 54037 | 7224 | 89 |
1936713 | 1936713 | 2021-11-20 | Jefferson | West Virginia | 54037 | 7212 | 89 |
1933463 | 1933463 | 2021-11-19 | Jefferson | West Virginia | 54037 | 7183 | 89 |
1930211 | 1930211 | 2021-11-18 | Jefferson | West Virginia | 54037 | 7145 | 89 |
1926961 | 1926961 | 2021-11-17 | Jefferson | West Virginia | 54037 | 7116 | 89 |
1923711 | 1923711 | 2021-11-16 | Jefferson | West Virginia | 54037 | 7092 | 89 |
1920462 | 1920462 | 2021-11-15 | Jefferson | West Virginia | 54037 | 7073 | 89 |
1917212 | 1917212 | 2021-11-14 | Jefferson | West Virginia | 54037 | 7065 | 89 |
1913962 | 1913962 | 2021-11-13 | Jefferson | West Virginia | 54037 | 7045 | 89 |
1910712 | 1910712 | 2021-11-12 | Jefferson | West Virginia | 54037 | 7022 | 89 |
1907463 | 1907463 | 2021-11-11 | Jefferson | West Virginia | 54037 | 6986 | 89 |
1904214 | 1904214 | 2021-11-10 | Jefferson | West Virginia | 54037 | 6959 | 89 |
1900964 | 1900964 | 2021-11-09 | Jefferson | West Virginia | 54037 | 6943 | 89 |
1897714 | 1897714 | 2021-11-08 | Jefferson | West Virginia | 54037 | 6919 | 89 |
1894464 | 1894464 | 2021-11-07 | Jefferson | West Virginia | 54037 | 6912 | 88 |
1891214 | 1891214 | 2021-11-06 | Jefferson | West Virginia | 54037 | 6903 | 88 |
1887964 | 1887964 | 2021-11-05 | Jefferson | West Virginia | 54037 | 6889 | 88 |
1884714 | 1884714 | 2021-11-04 | Jefferson | West Virginia | 54037 | 6869 | 88 |
1881465 | 1881465 | 2021-11-03 | Jefferson | West Virginia | 54037 | 6860 | 88 |
1878216 | 1878216 | 2021-11-02 | Jefferson | West Virginia | 54037 | 6842 | 88 |
1874967 | 1874967 | 2021-11-01 | Jefferson | West Virginia | 54037 | 6829 | 87 |
1871718 | 1871718 | 2021-10-31 | Jefferson | West Virginia | 54037 | 6828 | 85 |
1868469 | 1868469 | 2021-10-30 | Jefferson | West Virginia | 54037 | 6818 | 85 |
1865220 | 1865220 | 2021-10-29 | Jefferson | West Virginia | 54037 | 6801 | 85 |
1861971 | 1861971 | 2021-10-28 | Jefferson | West Virginia | 54037 | 6780 | 85 |
1858722 | 1858722 | 2021-10-27 | Jefferson | West Virginia | 54037 | 6762 | 85 |
1855473 | 1855473 | 2021-10-26 | Jefferson | West Virginia | 54037 | 6749 | 85 |
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);