ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 54035 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 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
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- …
state 1
- West Virginia · 685 ✖
fips 1
- 54035 · 685 ✖
county 1
- Jackson 685
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177314 | 2177314 | 2022-02-02 | Jackson | West Virginia | 54035 | 6304 | 116 |
2174061 | 2174061 | 2022-02-01 | Jackson | West Virginia | 54035 | 6274 | 116 |
2170809 | 2170809 | 2022-01-31 | Jackson | West Virginia | 54035 | 6260 | 116 |
2167556 | 2167556 | 2022-01-30 | Jackson | West Virginia | 54035 | 6229 | 115 |
2164301 | 2164301 | 2022-01-29 | Jackson | West Virginia | 54035 | 6186 | 115 |
2161046 | 2161046 | 2022-01-28 | Jackson | West Virginia | 54035 | 6130 | 115 |
2157790 | 2157790 | 2022-01-27 | Jackson | West Virginia | 54035 | 6074 | 114 |
2154537 | 2154537 | 2022-01-26 | Jackson | West Virginia | 54035 | 5999 | 114 |
2151284 | 2151284 | 2022-01-25 | Jackson | West Virginia | 54035 | 5930 | 114 |
2148032 | 2148032 | 2022-01-24 | Jackson | West Virginia | 54035 | 5909 | 114 |
2144780 | 2144780 | 2022-01-23 | Jackson | West Virginia | 54035 | 5845 | 113 |
2141525 | 2141525 | 2022-01-22 | Jackson | West Virginia | 54035 | 5754 | 113 |
2138269 | 2138269 | 2022-01-21 | Jackson | West Virginia | 54035 | 5671 | 113 |
2135014 | 2135014 | 2022-01-20 | Jackson | West Virginia | 54035 | 5553 | 113 |
2131762 | 2131762 | 2022-01-19 | Jackson | West Virginia | 54035 | 5474 | 113 |
2128508 | 2128508 | 2022-01-18 | Jackson | West Virginia | 54035 | 5440 | 113 |
2125255 | 2125255 | 2022-01-17 | Jackson | West Virginia | 54035 | 5398 | 113 |
2122003 | 2122003 | 2022-01-16 | Jackson | West Virginia | 54035 | 5323 | 112 |
2118751 | 2118751 | 2022-01-15 | Jackson | West Virginia | 54035 | 5242 | 112 |
2115499 | 2115499 | 2022-01-14 | Jackson | West Virginia | 54035 | 5144 | 112 |
2112247 | 2112247 | 2022-01-13 | Jackson | West Virginia | 54035 | 5096 | 112 |
2108995 | 2108995 | 2022-01-12 | Jackson | West Virginia | 54035 | 5027 | 111 |
2105744 | 2105744 | 2022-01-11 | Jackson | West Virginia | 54035 | 4982 | 111 |
2102493 | 2102493 | 2022-01-10 | Jackson | West Virginia | 54035 | 4953 | 111 |
2099242 | 2099242 | 2022-01-09 | Jackson | West Virginia | 54035 | 4920 | 111 |
2095991 | 2095991 | 2022-01-08 | Jackson | West Virginia | 54035 | 4892 | 111 |
2092739 | 2092739 | 2022-01-07 | Jackson | West Virginia | 54035 | 4853 | 111 |
2089487 | 2089487 | 2022-01-06 | Jackson | West Virginia | 54035 | 4774 | 111 |
2086236 | 2086236 | 2022-01-05 | Jackson | West Virginia | 54035 | 4731 | 111 |
2082984 | 2082984 | 2022-01-04 | Jackson | West Virginia | 54035 | 4699 | 111 |
2079732 | 2079732 | 2022-01-03 | Jackson | West Virginia | 54035 | 4673 | 110 |
2076480 | 2076480 | 2022-01-02 | Jackson | West Virginia | 54035 | 4584 | 109 |
2073229 | 2073229 | 2022-01-01 | Jackson | West Virginia | 54035 | 4584 | 109 |
2069978 | 2069978 | 2021-12-31 | Jackson | West Virginia | 54035 | 4584 | 109 |
2066727 | 2066727 | 2021-12-30 | Jackson | West Virginia | 54035 | 4584 | 109 |
2063477 | 2063477 | 2021-12-29 | Jackson | West Virginia | 54035 | 4563 | 108 |
2060227 | 2060227 | 2021-12-28 | Jackson | West Virginia | 54035 | 4546 | 108 |
2056978 | 2056978 | 2021-12-27 | Jackson | West Virginia | 54035 | 4536 | 108 |
2053729 | 2053729 | 2021-12-26 | Jackson | West Virginia | 54035 | 4506 | 108 |
2050479 | 2050479 | 2021-12-25 | Jackson | West Virginia | 54035 | 4506 | 108 |
2047229 | 2047229 | 2021-12-24 | Jackson | West Virginia | 54035 | 4506 | 108 |
2043979 | 2043979 | 2021-12-23 | Jackson | West Virginia | 54035 | 4506 | 108 |
2040730 | 2040730 | 2021-12-22 | Jackson | West Virginia | 54035 | 4493 | 107 |
2037480 | 2037480 | 2021-12-21 | Jackson | West Virginia | 54035 | 4480 | 106 |
2034230 | 2034230 | 2021-12-20 | Jackson | West Virginia | 54035 | 4471 | 106 |
2030980 | 2030980 | 2021-12-19 | Jackson | West Virginia | 54035 | 4452 | 103 |
2027729 | 2027729 | 2021-12-18 | Jackson | West Virginia | 54035 | 4449 | 103 |
2024478 | 2024478 | 2021-12-17 | Jackson | West Virginia | 54035 | 4441 | 103 |
2021227 | 2021227 | 2021-12-16 | Jackson | West Virginia | 54035 | 4426 | 101 |
2017976 | 2017976 | 2021-12-15 | Jackson | West Virginia | 54035 | 4405 | 101 |
2014726 | 2014726 | 2021-12-14 | Jackson | West Virginia | 54035 | 4396 | 99 |
2011475 | 2011475 | 2021-12-13 | Jackson | West Virginia | 54035 | 4392 | 99 |
2008224 | 2008224 | 2021-12-12 | Jackson | West Virginia | 54035 | 4386 | 98 |
2004973 | 2004973 | 2021-12-11 | Jackson | West Virginia | 54035 | 4370 | 98 |
2001722 | 2001722 | 2021-12-10 | Jackson | West Virginia | 54035 | 4362 | 98 |
1998472 | 1998472 | 2021-12-09 | Jackson | West Virginia | 54035 | 4359 | 97 |
1995221 | 1995221 | 2021-12-08 | Jackson | West Virginia | 54035 | 4351 | 96 |
1991970 | 1991970 | 2021-12-07 | Jackson | West Virginia | 54035 | 4341 | 94 |
1988719 | 1988719 | 2021-12-06 | Jackson | West Virginia | 54035 | 4330 | 94 |
1985469 | 1985469 | 2021-12-05 | Jackson | West Virginia | 54035 | 4323 | 94 |
1982219 | 1982219 | 2021-12-04 | Jackson | West Virginia | 54035 | 4316 | 94 |
1978969 | 1978969 | 2021-12-03 | Jackson | West Virginia | 54035 | 4302 | 94 |
1975719 | 1975719 | 2021-12-02 | Jackson | West Virginia | 54035 | 4279 | 93 |
1972470 | 1972470 | 2021-12-01 | Jackson | West Virginia | 54035 | 4265 | 93 |
1969220 | 1969220 | 2021-11-30 | Jackson | West Virginia | 54035 | 4258 | 92 |
1965970 | 1965970 | 2021-11-29 | Jackson | West Virginia | 54035 | 4245 | 92 |
1962718 | 1962718 | 2021-11-28 | Jackson | West Virginia | 54035 | 4212 | 92 |
1959467 | 1959467 | 2021-11-27 | Jackson | West Virginia | 54035 | 4212 | 92 |
1956216 | 1956216 | 2021-11-26 | Jackson | West Virginia | 54035 | 4212 | 92 |
1952965 | 1952965 | 2021-11-25 | Jackson | West Virginia | 54035 | 4212 | 92 |
1949714 | 1949714 | 2021-11-24 | Jackson | West Virginia | 54035 | 4212 | 92 |
1946463 | 1946463 | 2021-11-23 | Jackson | West Virginia | 54035 | 4207 | 90 |
1943212 | 1943212 | 2021-11-22 | Jackson | West Virginia | 54035 | 4208 | 90 |
1939962 | 1939962 | 2021-11-21 | Jackson | West Virginia | 54035 | 4191 | 88 |
1936712 | 1936712 | 2021-11-20 | Jackson | West Virginia | 54035 | 4186 | 88 |
1933462 | 1933462 | 2021-11-19 | Jackson | West Virginia | 54035 | 4171 | 88 |
1930210 | 1930210 | 2021-11-18 | Jackson | West Virginia | 54035 | 4158 | 88 |
1926960 | 1926960 | 2021-11-17 | Jackson | West Virginia | 54035 | 4146 | 88 |
1923710 | 1923710 | 2021-11-16 | Jackson | West Virginia | 54035 | 4136 | 88 |
1920461 | 1920461 | 2021-11-15 | Jackson | West Virginia | 54035 | 4132 | 88 |
1917211 | 1917211 | 2021-11-14 | Jackson | West Virginia | 54035 | 4121 | 87 |
1913961 | 1913961 | 2021-11-13 | Jackson | West Virginia | 54035 | 4111 | 87 |
1910711 | 1910711 | 2021-11-12 | Jackson | West Virginia | 54035 | 4098 | 87 |
1907462 | 1907462 | 2021-11-11 | Jackson | West Virginia | 54035 | 4090 | 87 |
1904213 | 1904213 | 2021-11-10 | Jackson | West Virginia | 54035 | 4075 | 87 |
1900963 | 1900963 | 2021-11-09 | Jackson | West Virginia | 54035 | 4059 | 87 |
1897713 | 1897713 | 2021-11-08 | Jackson | West Virginia | 54035 | 4054 | 87 |
1894463 | 1894463 | 2021-11-07 | Jackson | West Virginia | 54035 | 4050 | 87 |
1891213 | 1891213 | 2021-11-06 | Jackson | West Virginia | 54035 | 4043 | 87 |
1887963 | 1887963 | 2021-11-05 | Jackson | West Virginia | 54035 | 4033 | 87 |
1884713 | 1884713 | 2021-11-04 | Jackson | West Virginia | 54035 | 4016 | 87 |
1881464 | 1881464 | 2021-11-03 | Jackson | West Virginia | 54035 | 4006 | 87 |
1878215 | 1878215 | 2021-11-02 | Jackson | West Virginia | 54035 | 3999 | 87 |
1874966 | 1874966 | 2021-11-01 | Jackson | West Virginia | 54035 | 3988 | 87 |
1871717 | 1871717 | 2021-10-31 | Jackson | West Virginia | 54035 | 3975 | 86 |
1868468 | 1868468 | 2021-10-30 | Jackson | West Virginia | 54035 | 3970 | 86 |
1865219 | 1865219 | 2021-10-29 | Jackson | West Virginia | 54035 | 3961 | 86 |
1861970 | 1861970 | 2021-10-28 | Jackson | West Virginia | 54035 | 3954 | 86 |
1858721 | 1858721 | 2021-10-27 | Jackson | West Virginia | 54035 | 3944 | 85 |
1855472 | 1855472 | 2021-10-26 | Jackson | West Virginia | 54035 | 3928 | 83 |
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);