ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Morgan" 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 |
---|---|---|---|---|---|---|---|
2177329 | 2177329 | 2022-02-02 | Morgan | West Virginia | 54065 | 4009 | 58 |
2174076 | 2174076 | 2022-02-01 | Morgan | West Virginia | 54065 | 4001 | 58 |
2170824 | 2170824 | 2022-01-31 | Morgan | West Virginia | 54065 | 3989 | 58 |
2167571 | 2167571 | 2022-01-30 | Morgan | West Virginia | 54065 | 3975 | 58 |
2164316 | 2164316 | 2022-01-29 | Morgan | West Virginia | 54065 | 3959 | 58 |
2161061 | 2161061 | 2022-01-28 | Morgan | West Virginia | 54065 | 3946 | 58 |
2157805 | 2157805 | 2022-01-27 | Morgan | West Virginia | 54065 | 3923 | 57 |
2154552 | 2154552 | 2022-01-26 | Morgan | West Virginia | 54065 | 3902 | 57 |
2151299 | 2151299 | 2022-01-25 | Morgan | West Virginia | 54065 | 3882 | 57 |
2148047 | 2148047 | 2022-01-24 | Morgan | West Virginia | 54065 | 3870 | 57 |
2144795 | 2144795 | 2022-01-23 | Morgan | West Virginia | 54065 | 3866 | 57 |
2141540 | 2141540 | 2022-01-22 | Morgan | West Virginia | 54065 | 3825 | 57 |
2138284 | 2138284 | 2022-01-21 | Morgan | West Virginia | 54065 | 3763 | 57 |
2135029 | 2135029 | 2022-01-20 | Morgan | West Virginia | 54065 | 3718 | 57 |
2131777 | 2131777 | 2022-01-19 | Morgan | West Virginia | 54065 | 3661 | 57 |
2128523 | 2128523 | 2022-01-18 | Morgan | West Virginia | 54065 | 3627 | 57 |
2125270 | 2125270 | 2022-01-17 | Morgan | West Virginia | 54065 | 3621 | 57 |
2122018 | 2122018 | 2022-01-16 | Morgan | West Virginia | 54065 | 3598 | 57 |
2118766 | 2118766 | 2022-01-15 | Morgan | West Virginia | 54065 | 3543 | 57 |
2115514 | 2115514 | 2022-01-14 | Morgan | West Virginia | 54065 | 3486 | 57 |
2112262 | 2112262 | 2022-01-13 | Morgan | West Virginia | 54065 | 3362 | 57 |
2109010 | 2109010 | 2022-01-12 | Morgan | West Virginia | 54065 | 3330 | 57 |
2105759 | 2105759 | 2022-01-11 | Morgan | West Virginia | 54065 | 3295 | 57 |
2102508 | 2102508 | 2022-01-10 | Morgan | West Virginia | 54065 | 3274 | 57 |
2099257 | 2099257 | 2022-01-09 | Morgan | West Virginia | 54065 | 3240 | 57 |
2096006 | 2096006 | 2022-01-08 | Morgan | West Virginia | 54065 | 3206 | 57 |
2092754 | 2092754 | 2022-01-07 | Morgan | West Virginia | 54065 | 3160 | 57 |
2089502 | 2089502 | 2022-01-06 | Morgan | West Virginia | 54065 | 3117 | 54 |
2086251 | 2086251 | 2022-01-05 | Morgan | West Virginia | 54065 | 3034 | 53 |
2082999 | 2082999 | 2022-01-04 | Morgan | West Virginia | 54065 | 3001 | 53 |
2079747 | 2079747 | 2022-01-03 | Morgan | West Virginia | 54065 | 2974 | 53 |
2076495 | 2076495 | 2022-01-02 | Morgan | West Virginia | 54065 | 2847 | 53 |
2073244 | 2073244 | 2022-01-01 | Morgan | West Virginia | 54065 | 2847 | 53 |
2069993 | 2069993 | 2021-12-31 | Morgan | West Virginia | 54065 | 2847 | 53 |
2066742 | 2066742 | 2021-12-30 | Morgan | West Virginia | 54065 | 2847 | 53 |
2063492 | 2063492 | 2021-12-29 | Morgan | West Virginia | 54065 | 2816 | 53 |
2060242 | 2060242 | 2021-12-28 | Morgan | West Virginia | 54065 | 2795 | 53 |
2056993 | 2056993 | 2021-12-27 | Morgan | West Virginia | 54065 | 2782 | 53 |
2053744 | 2053744 | 2021-12-26 | Morgan | West Virginia | 54065 | 2716 | 53 |
2050494 | 2050494 | 2021-12-25 | Morgan | West Virginia | 54065 | 2716 | 53 |
2047244 | 2047244 | 2021-12-24 | Morgan | West Virginia | 54065 | 2716 | 53 |
2043994 | 2043994 | 2021-12-23 | Morgan | West Virginia | 54065 | 2716 | 53 |
2040745 | 2040745 | 2021-12-22 | Morgan | West Virginia | 54065 | 2691 | 53 |
2037495 | 2037495 | 2021-12-21 | Morgan | West Virginia | 54065 | 2672 | 52 |
2034245 | 2034245 | 2021-12-20 | Morgan | West Virginia | 54065 | 2661 | 51 |
2030995 | 2030995 | 2021-12-19 | Morgan | West Virginia | 54065 | 2648 | 51 |
2027744 | 2027744 | 2021-12-18 | Morgan | West Virginia | 54065 | 2636 | 51 |
2024493 | 2024493 | 2021-12-17 | Morgan | West Virginia | 54065 | 2612 | 51 |
2021242 | 2021242 | 2021-12-16 | Morgan | West Virginia | 54065 | 2586 | 51 |
2017991 | 2017991 | 2021-12-15 | Morgan | West Virginia | 54065 | 2552 | 51 |
2014741 | 2014741 | 2021-12-14 | Morgan | West Virginia | 54065 | 2536 | 51 |
2011490 | 2011490 | 2021-12-13 | Morgan | West Virginia | 54065 | 2530 | 51 |
2008239 | 2008239 | 2021-12-12 | Morgan | West Virginia | 54065 | 2515 | 51 |
2004988 | 2004988 | 2021-12-11 | Morgan | West Virginia | 54065 | 2501 | 51 |
2001737 | 2001737 | 2021-12-10 | Morgan | West Virginia | 54065 | 2481 | 51 |
1998487 | 1998487 | 2021-12-09 | Morgan | West Virginia | 54065 | 2466 | 50 |
1995236 | 1995236 | 2021-12-08 | Morgan | West Virginia | 54065 | 2448 | 50 |
1991985 | 1991985 | 2021-12-07 | Morgan | West Virginia | 54065 | 2439 | 50 |
1988734 | 1988734 | 2021-12-06 | Morgan | West Virginia | 54065 | 2444 | 50 |
1985484 | 1985484 | 2021-12-05 | Morgan | West Virginia | 54065 | 2435 | 50 |
1982234 | 1982234 | 2021-12-04 | Morgan | West Virginia | 54065 | 2424 | 50 |
1978984 | 1978984 | 2021-12-03 | Morgan | West Virginia | 54065 | 2403 | 50 |
1975734 | 1975734 | 2021-12-02 | Morgan | West Virginia | 54065 | 2387 | 48 |
1972485 | 1972485 | 2021-12-01 | Morgan | West Virginia | 54065 | 2363 | 48 |
1969235 | 1969235 | 2021-11-30 | Morgan | West Virginia | 54065 | 2347 | 48 |
1965985 | 1965985 | 2021-11-29 | Morgan | West Virginia | 54065 | 2348 | 48 |
1962733 | 1962733 | 2021-11-28 | Morgan | West Virginia | 54065 | 2293 | 48 |
1959482 | 1959482 | 2021-11-27 | Morgan | West Virginia | 54065 | 2293 | 48 |
1956231 | 1956231 | 2021-11-26 | Morgan | West Virginia | 54065 | 2293 | 48 |
1952980 | 1952980 | 2021-11-25 | Morgan | West Virginia | 54065 | 2293 | 48 |
1949729 | 1949729 | 2021-11-24 | Morgan | West Virginia | 54065 | 2293 | 48 |
1946478 | 1946478 | 2021-11-23 | Morgan | West Virginia | 54065 | 2281 | 48 |
1943227 | 1943227 | 2021-11-22 | Morgan | West Virginia | 54065 | 2274 | 48 |
1939977 | 1939977 | 2021-11-21 | Morgan | West Virginia | 54065 | 2270 | 48 |
1936727 | 1936727 | 2021-11-20 | Morgan | West Virginia | 54065 | 2263 | 48 |
1933477 | 1933477 | 2021-11-19 | Morgan | West Virginia | 54065 | 2251 | 48 |
1930225 | 1930225 | 2021-11-18 | Morgan | West Virginia | 54065 | 2238 | 48 |
1926975 | 1926975 | 2021-11-17 | Morgan | West Virginia | 54065 | 2226 | 48 |
1923725 | 1923725 | 2021-11-16 | Morgan | West Virginia | 54065 | 2214 | 48 |
1920476 | 1920476 | 2021-11-15 | Morgan | West Virginia | 54065 | 2209 | 48 |
1917226 | 1917226 | 2021-11-14 | Morgan | West Virginia | 54065 | 2203 | 47 |
1913976 | 1913976 | 2021-11-13 | Morgan | West Virginia | 54065 | 2197 | 47 |
1910726 | 1910726 | 2021-11-12 | Morgan | West Virginia | 54065 | 2185 | 47 |
1907477 | 1907477 | 2021-11-11 | Morgan | West Virginia | 54065 | 2182 | 47 |
1904228 | 1904228 | 2021-11-10 | Morgan | West Virginia | 54065 | 2176 | 47 |
1900978 | 1900978 | 2021-11-09 | Morgan | West Virginia | 54065 | 2172 | 47 |
1897728 | 1897728 | 2021-11-08 | Morgan | West Virginia | 54065 | 2172 | 46 |
1894478 | 1894478 | 2021-11-07 | Morgan | West Virginia | 54065 | 2171 | 46 |
1891228 | 1891228 | 2021-11-06 | Morgan | West Virginia | 54065 | 2166 | 46 |
1887978 | 1887978 | 2021-11-05 | Morgan | West Virginia | 54065 | 2161 | 46 |
1884728 | 1884728 | 2021-11-04 | Morgan | West Virginia | 54065 | 2152 | 46 |
1881479 | 1881479 | 2021-11-03 | Morgan | West Virginia | 54065 | 2140 | 46 |
1878230 | 1878230 | 2021-11-02 | Morgan | West Virginia | 54065 | 2128 | 46 |
1874981 | 1874981 | 2021-11-01 | Morgan | West Virginia | 54065 | 2122 | 45 |
1871732 | 1871732 | 2021-10-31 | Morgan | West Virginia | 54065 | 2119 | 44 |
1868483 | 1868483 | 2021-10-30 | Morgan | West Virginia | 54065 | 2117 | 44 |
1865234 | 1865234 | 2021-10-29 | Morgan | West Virginia | 54065 | 2110 | 44 |
1861985 | 1861985 | 2021-10-28 | Morgan | West Virginia | 54065 | 2108 | 42 |
1858736 | 1858736 | 2021-10-27 | Morgan | West Virginia | 54065 | 2094 | 41 |
1855487 | 1855487 | 2021-10-26 | Morgan | West Virginia | 54065 | 2089 | 41 |
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);