ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Roane" 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 |
---|---|---|---|---|---|---|---|
2339950 | 2339950 | 2022-03-24 | Roane | West Virginia | 54087 | 3137 | 37 |
2336697 | 2336697 | 2022-03-23 | Roane | West Virginia | 54087 | 3137 | 37 |
2333443 | 2333443 | 2022-03-22 | Roane | West Virginia | 54087 | 3136 | 37 |
2330189 | 2330189 | 2022-03-21 | Roane | West Virginia | 54087 | 3135 | 37 |
2326937 | 2326937 | 2022-03-20 | Roane | West Virginia | 54087 | 3134 | 37 |
2323684 | 2323684 | 2022-03-19 | Roane | West Virginia | 54087 | 3134 | 37 |
2320430 | 2320430 | 2022-03-18 | Roane | West Virginia | 54087 | 3134 | 37 |
2317176 | 2317176 | 2022-03-17 | Roane | West Virginia | 54087 | 3133 | 37 |
2313923 | 2313923 | 2022-03-16 | Roane | West Virginia | 54087 | 3131 | 37 |
2310670 | 2310670 | 2022-03-15 | Roane | West Virginia | 54087 | 3129 | 37 |
2307417 | 2307417 | 2022-03-14 | Roane | West Virginia | 54087 | 3125 | 37 |
2304166 | 2304166 | 2022-03-13 | Roane | West Virginia | 54087 | 3123 | 37 |
2300914 | 2300914 | 2022-03-12 | Roane | West Virginia | 54087 | 3123 | 37 |
2297662 | 2297662 | 2022-03-11 | Roane | West Virginia | 54087 | 3123 | 37 |
2294410 | 2294410 | 2022-03-10 | Roane | West Virginia | 54087 | 3121 | 37 |
2291158 | 2291158 | 2022-03-09 | Roane | West Virginia | 54087 | 3119 | 36 |
2287906 | 2287906 | 2022-03-08 | Roane | West Virginia | 54087 | 3118 | 36 |
2284654 | 2284654 | 2022-03-07 | Roane | West Virginia | 54087 | 3118 | 36 |
2281402 | 2281402 | 2022-03-06 | Roane | West Virginia | 54087 | 3112 | 36 |
2278149 | 2278149 | 2022-03-05 | Roane | West Virginia | 54087 | 3112 | 36 |
2274896 | 2274896 | 2022-03-04 | Roane | West Virginia | 54087 | 3112 | 36 |
2271643 | 2271643 | 2022-03-03 | Roane | West Virginia | 54087 | 3108 | 36 |
2268391 | 2268391 | 2022-03-02 | Roane | West Virginia | 54087 | 3103 | 36 |
2265138 | 2265138 | 2022-03-01 | Roane | West Virginia | 54087 | 3106 | 36 |
2261888 | 2261888 | 2022-02-28 | Roane | West Virginia | 54087 | 3102 | 35 |
2258637 | 2258637 | 2022-02-27 | Roane | West Virginia | 54087 | 3082 | 35 |
2255386 | 2255386 | 2022-02-26 | Roane | West Virginia | 54087 | 3082 | 35 |
2252135 | 2252135 | 2022-02-25 | Roane | West Virginia | 54087 | 3082 | 35 |
2248884 | 2248884 | 2022-02-24 | Roane | West Virginia | 54087 | 3081 | 35 |
2245633 | 2245633 | 2022-02-23 | Roane | West Virginia | 54087 | 3069 | 35 |
2242382 | 2242382 | 2022-02-22 | Roane | West Virginia | 54087 | 3064 | 35 |
2239131 | 2239131 | 2022-02-21 | Roane | West Virginia | 54087 | 3061 | 34 |
2235880 | 2235880 | 2022-02-20 | Roane | West Virginia | 54087 | 3035 | 34 |
2232629 | 2232629 | 2022-02-19 | Roane | West Virginia | 54087 | 3035 | 34 |
2229378 | 2229378 | 2022-02-18 | Roane | West Virginia | 54087 | 3035 | 34 |
2226127 | 2226127 | 2022-02-17 | Roane | West Virginia | 54087 | 3024 | 34 |
2222876 | 2222876 | 2022-02-16 | Roane | West Virginia | 54087 | 3009 | 34 |
2219625 | 2219625 | 2022-02-15 | Roane | West Virginia | 54087 | 3006 | 34 |
2216375 | 2216375 | 2022-02-14 | Roane | West Virginia | 54087 | 3000 | 33 |
2213124 | 2213124 | 2022-02-13 | Roane | West Virginia | 54087 | 2989 | 33 |
2209871 | 2209871 | 2022-02-12 | Roane | West Virginia | 54087 | 2983 | 33 |
2206618 | 2206618 | 2022-02-11 | Roane | West Virginia | 54087 | 2968 | 33 |
2203365 | 2203365 | 2022-02-10 | Roane | West Virginia | 54087 | 2963 | 33 |
2200111 | 2200111 | 2022-02-09 | Roane | West Virginia | 54087 | 2940 | 33 |
2196857 | 2196857 | 2022-02-08 | Roane | West Virginia | 54087 | 2931 | 33 |
2193602 | 2193602 | 2022-02-07 | Roane | West Virginia | 54087 | 2913 | 32 |
2190349 | 2190349 | 2022-02-06 | Roane | West Virginia | 54087 | 2905 | 31 |
2187096 | 2187096 | 2022-02-05 | Roane | West Virginia | 54087 | 2895 | 31 |
2183843 | 2183843 | 2022-02-04 | Roane | West Virginia | 54087 | 2881 | 31 |
2180591 | 2180591 | 2022-02-03 | Roane | West Virginia | 54087 | 2868 | 31 |
2177340 | 2177340 | 2022-02-02 | Roane | West Virginia | 54087 | 2844 | 31 |
2174087 | 2174087 | 2022-02-01 | Roane | West Virginia | 54087 | 2835 | 31 |
2170835 | 2170835 | 2022-01-31 | Roane | West Virginia | 54087 | 2812 | 31 |
2167582 | 2167582 | 2022-01-30 | Roane | West Virginia | 54087 | 2798 | 30 |
2164327 | 2164327 | 2022-01-29 | Roane | West Virginia | 54087 | 2784 | 30 |
2161072 | 2161072 | 2022-01-28 | Roane | West Virginia | 54087 | 2785 | 30 |
2157816 | 2157816 | 2022-01-27 | Roane | West Virginia | 54087 | 2758 | 30 |
2154563 | 2154563 | 2022-01-26 | Roane | West Virginia | 54087 | 2725 | 30 |
2151310 | 2151310 | 2022-01-25 | Roane | West Virginia | 54087 | 2694 | 30 |
2148058 | 2148058 | 2022-01-24 | Roane | West Virginia | 54087 | 2667 | 30 |
2144806 | 2144806 | 2022-01-23 | Roane | West Virginia | 54087 | 2642 | 30 |
2141551 | 2141551 | 2022-01-22 | Roane | West Virginia | 54087 | 2613 | 30 |
2138295 | 2138295 | 2022-01-21 | Roane | West Virginia | 54087 | 2560 | 30 |
2135040 | 2135040 | 2022-01-20 | Roane | West Virginia | 54087 | 2527 | 30 |
2131788 | 2131788 | 2022-01-19 | Roane | West Virginia | 54087 | 2487 | 30 |
2128534 | 2128534 | 2022-01-18 | Roane | West Virginia | 54087 | 2458 | 30 |
2125281 | 2125281 | 2022-01-17 | Roane | West Virginia | 54087 | 2431 | 29 |
2122029 | 2122029 | 2022-01-16 | Roane | West Virginia | 54087 | 2394 | 29 |
2118777 | 2118777 | 2022-01-15 | Roane | West Virginia | 54087 | 2373 | 29 |
2115525 | 2115525 | 2022-01-14 | Roane | West Virginia | 54087 | 2335 | 29 |
2112273 | 2112273 | 2022-01-13 | Roane | West Virginia | 54087 | 2281 | 29 |
2109021 | 2109021 | 2022-01-12 | Roane | West Virginia | 54087 | 2231 | 29 |
2105770 | 2105770 | 2022-01-11 | Roane | West Virginia | 54087 | 2209 | 29 |
2102519 | 2102519 | 2022-01-10 | Roane | West Virginia | 54087 | 2195 | 29 |
2099268 | 2099268 | 2022-01-09 | Roane | West Virginia | 54087 | 2177 | 29 |
2096017 | 2096017 | 2022-01-08 | Roane | West Virginia | 54087 | 2169 | 29 |
2092765 | 2092765 | 2022-01-07 | Roane | West Virginia | 54087 | 2155 | 29 |
2089513 | 2089513 | 2022-01-06 | Roane | West Virginia | 54087 | 2132 | 29 |
2086262 | 2086262 | 2022-01-05 | Roane | West Virginia | 54087 | 2116 | 28 |
2083010 | 2083010 | 2022-01-04 | Roane | West Virginia | 54087 | 2099 | 28 |
2079758 | 2079758 | 2022-01-03 | Roane | West Virginia | 54087 | 2090 | 28 |
2076506 | 2076506 | 2022-01-02 | Roane | West Virginia | 54087 | 2038 | 28 |
2073255 | 2073255 | 2022-01-01 | Roane | West Virginia | 54087 | 2038 | 28 |
2070004 | 2070004 | 2021-12-31 | Roane | West Virginia | 54087 | 2038 | 28 |
2066753 | 2066753 | 2021-12-30 | Roane | West Virginia | 54087 | 2038 | 28 |
2063503 | 2063503 | 2021-12-29 | Roane | West Virginia | 54087 | 2030 | 28 |
2060253 | 2060253 | 2021-12-28 | Roane | West Virginia | 54087 | 2025 | 28 |
2057004 | 2057004 | 2021-12-27 | Roane | West Virginia | 54087 | 2017 | 28 |
2053755 | 2053755 | 2021-12-26 | Roane | West Virginia | 54087 | 1996 | 27 |
2050505 | 2050505 | 2021-12-25 | Roane | West Virginia | 54087 | 1996 | 27 |
2047255 | 2047255 | 2021-12-24 | Roane | West Virginia | 54087 | 1996 | 27 |
2044005 | 2044005 | 2021-12-23 | Roane | West Virginia | 54087 | 1996 | 27 |
2040756 | 2040756 | 2021-12-22 | Roane | West Virginia | 54087 | 1991 | 27 |
2037506 | 2037506 | 2021-12-21 | Roane | West Virginia | 54087 | 1986 | 27 |
2034256 | 2034256 | 2021-12-20 | Roane | West Virginia | 54087 | 1978 | 27 |
2031006 | 2031006 | 2021-12-19 | Roane | West Virginia | 54087 | 1970 | 27 |
2027755 | 2027755 | 2021-12-18 | Roane | West Virginia | 54087 | 1964 | 27 |
2024504 | 2024504 | 2021-12-17 | Roane | West Virginia | 54087 | 1954 | 27 |
2021253 | 2021253 | 2021-12-16 | Roane | West Virginia | 54087 | 1947 | 27 |
2018002 | 2018002 | 2021-12-15 | Roane | West Virginia | 54087 | 1932 | 27 |
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);