ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,559 rows where county = "Roane" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2339409 | 2339409 | 2022-03-24 | Roane | Tennessee | 47145 | 15764 | 231 |
2339950 | 2339950 | 2022-03-24 | Roane | West Virginia | 54087 | 3137 | 37 |
2336155 | 2336155 | 2022-03-23 | Roane | Tennessee | 47145 | 15764 | 231 |
2336697 | 2336697 | 2022-03-23 | Roane | West Virginia | 54087 | 3137 | 37 |
2332901 | 2332901 | 2022-03-22 | Roane | Tennessee | 47145 | 15740 | 228 |
2333443 | 2333443 | 2022-03-22 | Roane | West Virginia | 54087 | 3136 | 37 |
2329648 | 2329648 | 2022-03-21 | Roane | Tennessee | 47145 | 15740 | 228 |
2330189 | 2330189 | 2022-03-21 | Roane | West Virginia | 54087 | 3135 | 37 |
2326396 | 2326396 | 2022-03-20 | Roane | Tennessee | 47145 | 15740 | 228 |
2326937 | 2326937 | 2022-03-20 | Roane | West Virginia | 54087 | 3134 | 37 |
2323143 | 2323143 | 2022-03-19 | Roane | Tennessee | 47145 | 15740 | 228 |
2323684 | 2323684 | 2022-03-19 | Roane | West Virginia | 54087 | 3134 | 37 |
2319889 | 2319889 | 2022-03-18 | Roane | Tennessee | 47145 | 15740 | 228 |
2320430 | 2320430 | 2022-03-18 | Roane | West Virginia | 54087 | 3134 | 37 |
2316635 | 2316635 | 2022-03-17 | Roane | Tennessee | 47145 | 15740 | 228 |
2317176 | 2317176 | 2022-03-17 | Roane | West Virginia | 54087 | 3133 | 37 |
2313382 | 2313382 | 2022-03-16 | Roane | Tennessee | 47145 | 15740 | 228 |
2313923 | 2313923 | 2022-03-16 | Roane | West Virginia | 54087 | 3131 | 37 |
2310129 | 2310129 | 2022-03-15 | Roane | Tennessee | 47145 | 15712 | 225 |
2310670 | 2310670 | 2022-03-15 | Roane | West Virginia | 54087 | 3129 | 37 |
2306876 | 2306876 | 2022-03-14 | Roane | Tennessee | 47145 | 15712 | 225 |
2307417 | 2307417 | 2022-03-14 | Roane | West Virginia | 54087 | 3125 | 37 |
2303625 | 2303625 | 2022-03-13 | Roane | Tennessee | 47145 | 15712 | 225 |
2304166 | 2304166 | 2022-03-13 | Roane | West Virginia | 54087 | 3123 | 37 |
2300373 | 2300373 | 2022-03-12 | Roane | Tennessee | 47145 | 15712 | 225 |
2300914 | 2300914 | 2022-03-12 | Roane | West Virginia | 54087 | 3123 | 37 |
2297121 | 2297121 | 2022-03-11 | Roane | Tennessee | 47145 | 15712 | 225 |
2297662 | 2297662 | 2022-03-11 | Roane | West Virginia | 54087 | 3123 | 37 |
2293869 | 2293869 | 2022-03-10 | Roane | Tennessee | 47145 | 15712 | 225 |
2294410 | 2294410 | 2022-03-10 | Roane | West Virginia | 54087 | 3121 | 37 |
2290617 | 2290617 | 2022-03-09 | Roane | Tennessee | 47145 | 15712 | 225 |
2291158 | 2291158 | 2022-03-09 | Roane | West Virginia | 54087 | 3119 | 36 |
2287365 | 2287365 | 2022-03-08 | Roane | Tennessee | 47145 | 15681 | 221 |
2287906 | 2287906 | 2022-03-08 | Roane | West Virginia | 54087 | 3118 | 36 |
2284113 | 2284113 | 2022-03-07 | Roane | Tennessee | 47145 | 15681 | 221 |
2284654 | 2284654 | 2022-03-07 | Roane | West Virginia | 54087 | 3118 | 36 |
2280861 | 2280861 | 2022-03-06 | Roane | Tennessee | 47145 | 15681 | 221 |
2281402 | 2281402 | 2022-03-06 | Roane | West Virginia | 54087 | 3112 | 36 |
2277608 | 2277608 | 2022-03-05 | Roane | Tennessee | 47145 | 15681 | 221 |
2278149 | 2278149 | 2022-03-05 | Roane | West Virginia | 54087 | 3112 | 36 |
2274355 | 2274355 | 2022-03-04 | Roane | Tennessee | 47145 | 15681 | 221 |
2274896 | 2274896 | 2022-03-04 | Roane | West Virginia | 54087 | 3112 | 36 |
2271102 | 2271102 | 2022-03-03 | Roane | Tennessee | 47145 | 15681 | 221 |
2271643 | 2271643 | 2022-03-03 | Roane | West Virginia | 54087 | 3108 | 36 |
2267850 | 2267850 | 2022-03-02 | Roane | Tennessee | 47145 | 15681 | 221 |
2268391 | 2268391 | 2022-03-02 | Roane | West Virginia | 54087 | 3103 | 36 |
2264597 | 2264597 | 2022-03-01 | Roane | Tennessee | 47145 | 15588 | 217 |
2265138 | 2265138 | 2022-03-01 | Roane | West Virginia | 54087 | 3106 | 36 |
2261347 | 2261347 | 2022-02-28 | Roane | Tennessee | 47145 | 15588 | 217 |
2261888 | 2261888 | 2022-02-28 | Roane | West Virginia | 54087 | 3102 | 35 |
2258096 | 2258096 | 2022-02-27 | Roane | Tennessee | 47145 | 15588 | 217 |
2258637 | 2258637 | 2022-02-27 | Roane | West Virginia | 54087 | 3082 | 35 |
2254845 | 2254845 | 2022-02-26 | Roane | Tennessee | 47145 | 15588 | 217 |
2255386 | 2255386 | 2022-02-26 | Roane | West Virginia | 54087 | 3082 | 35 |
2251594 | 2251594 | 2022-02-25 | Roane | Tennessee | 47145 | 15588 | 217 |
2252135 | 2252135 | 2022-02-25 | Roane | West Virginia | 54087 | 3082 | 35 |
2248343 | 2248343 | 2022-02-24 | Roane | Tennessee | 47145 | 15588 | 217 |
2248884 | 2248884 | 2022-02-24 | Roane | West Virginia | 54087 | 3081 | 35 |
2245092 | 2245092 | 2022-02-23 | Roane | Tennessee | 47145 | 15588 | 217 |
2245633 | 2245633 | 2022-02-23 | Roane | West Virginia | 54087 | 3069 | 35 |
2241841 | 2241841 | 2022-02-22 | Roane | Tennessee | 47145 | 15418 | 215 |
2242382 | 2242382 | 2022-02-22 | Roane | West Virginia | 54087 | 3064 | 35 |
2238590 | 2238590 | 2022-02-21 | Roane | Tennessee | 47145 | 15418 | 215 |
2239131 | 2239131 | 2022-02-21 | Roane | West Virginia | 54087 | 3061 | 34 |
2235339 | 2235339 | 2022-02-20 | Roane | Tennessee | 47145 | 15418 | 215 |
2235880 | 2235880 | 2022-02-20 | Roane | West Virginia | 54087 | 3035 | 34 |
2232088 | 2232088 | 2022-02-19 | Roane | Tennessee | 47145 | 15418 | 215 |
2232629 | 2232629 | 2022-02-19 | Roane | West Virginia | 54087 | 3035 | 34 |
2228837 | 2228837 | 2022-02-18 | Roane | Tennessee | 47145 | 15418 | 215 |
2229378 | 2229378 | 2022-02-18 | Roane | West Virginia | 54087 | 3035 | 34 |
2225586 | 2225586 | 2022-02-17 | Roane | Tennessee | 47145 | 15418 | 215 |
2226127 | 2226127 | 2022-02-17 | Roane | West Virginia | 54087 | 3024 | 34 |
2222335 | 2222335 | 2022-02-16 | Roane | Tennessee | 47145 | 15418 | 215 |
2222876 | 2222876 | 2022-02-16 | Roane | West Virginia | 54087 | 3009 | 34 |
2219084 | 2219084 | 2022-02-15 | Roane | Tennessee | 47145 | 15095 | 208 |
2219625 | 2219625 | 2022-02-15 | Roane | West Virginia | 54087 | 3006 | 34 |
2215833 | 2215833 | 2022-02-14 | Roane | Tennessee | 47145 | 15095 | 208 |
2216375 | 2216375 | 2022-02-14 | Roane | West Virginia | 54087 | 3000 | 33 |
2212582 | 2212582 | 2022-02-13 | Roane | Tennessee | 47145 | 15095 | 208 |
2213124 | 2213124 | 2022-02-13 | Roane | West Virginia | 54087 | 2989 | 33 |
2209329 | 2209329 | 2022-02-12 | Roane | Tennessee | 47145 | 15095 | 208 |
2209871 | 2209871 | 2022-02-12 | Roane | West Virginia | 54087 | 2983 | 33 |
2206076 | 2206076 | 2022-02-11 | Roane | Tennessee | 47145 | 15095 | 208 |
2206618 | 2206618 | 2022-02-11 | Roane | West Virginia | 54087 | 2968 | 33 |
2202823 | 2202823 | 2022-02-10 | Roane | Tennessee | 47145 | 15095 | 208 |
2203365 | 2203365 | 2022-02-10 | Roane | West Virginia | 54087 | 2963 | 33 |
2199569 | 2199569 | 2022-02-09 | Roane | Tennessee | 47145 | 15095 | 208 |
2200111 | 2200111 | 2022-02-09 | Roane | West Virginia | 54087 | 2940 | 33 |
2196315 | 2196315 | 2022-02-08 | Roane | Tennessee | 47145 | 14288 | 203 |
2196857 | 2196857 | 2022-02-08 | Roane | West Virginia | 54087 | 2931 | 33 |
2193061 | 2193061 | 2022-02-07 | Roane | Tennessee | 47145 | 14288 | 203 |
2193602 | 2193602 | 2022-02-07 | Roane | West Virginia | 54087 | 2913 | 32 |
2189807 | 2189807 | 2022-02-06 | Roane | Tennessee | 47145 | 14288 | 203 |
2190349 | 2190349 | 2022-02-06 | Roane | West Virginia | 54087 | 2905 | 31 |
2186554 | 2186554 | 2022-02-05 | Roane | Tennessee | 47145 | 14288 | 203 |
2187096 | 2187096 | 2022-02-05 | Roane | West Virginia | 54087 | 2895 | 31 |
2183302 | 2183302 | 2022-02-04 | Roane | Tennessee | 47145 | 14288 | 203 |
2183843 | 2183843 | 2022-02-04 | Roane | West Virginia | 54087 | 2881 | 31 |
2180050 | 2180050 | 2022-02-03 | Roane | Tennessee | 47145 | 14288 | 203 |
2180591 | 2180591 | 2022-02-03 | Roane | West Virginia | 54087 | 2868 | 31 |
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);