ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 51161 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502616 | 2502616 | 2022-05-13 | Roanoke | Virginia | 51161 | 21633 | 282 |
2499358 | 2499358 | 2022-05-12 | Roanoke | Virginia | 51161 | 21590 | 282 |
2496100 | 2496100 | 2022-05-11 | Roanoke | Virginia | 51161 | 21540 | 282 |
2492842 | 2492842 | 2022-05-10 | Roanoke | Virginia | 51161 | 21516 | 281 |
2489584 | 2489584 | 2022-05-09 | Roanoke | Virginia | 51161 | 21476 | 281 |
2486327 | 2486327 | 2022-05-08 | Roanoke | Virginia | 51161 | 21421 | 281 |
2483069 | 2483069 | 2022-05-07 | Roanoke | Virginia | 51161 | 21421 | 281 |
2479811 | 2479811 | 2022-05-06 | Roanoke | Virginia | 51161 | 21421 | 281 |
2476553 | 2476553 | 2022-05-05 | Roanoke | Virginia | 51161 | 21392 | 281 |
2473295 | 2473295 | 2022-05-04 | Roanoke | Virginia | 51161 | 21375 | 281 |
2470039 | 2470039 | 2022-05-03 | Roanoke | Virginia | 51161 | 21342 | 281 |
2466783 | 2466783 | 2022-05-02 | Roanoke | Virginia | 51161 | 21325 | 281 |
2463528 | 2463528 | 2022-05-01 | Roanoke | Virginia | 51161 | 21280 | 281 |
2460272 | 2460272 | 2022-04-30 | Roanoke | Virginia | 51161 | 21280 | 281 |
2457016 | 2457016 | 2022-04-29 | Roanoke | Virginia | 51161 | 21280 | 281 |
2453760 | 2453760 | 2022-04-28 | Roanoke | Virginia | 51161 | 21257 | 281 |
2450504 | 2450504 | 2022-04-27 | Roanoke | Virginia | 51161 | 21238 | 281 |
2447247 | 2447247 | 2022-04-26 | Roanoke | Virginia | 51161 | 21202 | 281 |
2443992 | 2443992 | 2022-04-25 | Roanoke | Virginia | 51161 | 21192 | 281 |
2440736 | 2440736 | 2022-04-24 | Roanoke | Virginia | 51161 | 21160 | 281 |
2437480 | 2437480 | 2022-04-23 | Roanoke | Virginia | 51161 | 21160 | 281 |
2434224 | 2434224 | 2022-04-22 | Roanoke | Virginia | 51161 | 21160 | 281 |
2430968 | 2430968 | 2022-04-21 | Roanoke | Virginia | 51161 | 21151 | 281 |
2427712 | 2427712 | 2022-04-20 | Roanoke | Virginia | 51161 | 21136 | 281 |
2424456 | 2424456 | 2022-04-19 | Roanoke | Virginia | 51161 | 21127 | 281 |
2421200 | 2421200 | 2022-04-18 | Roanoke | Virginia | 51161 | 21126 | 282 |
2417944 | 2417944 | 2022-04-17 | Roanoke | Virginia | 51161 | 21107 | 280 |
2414688 | 2414688 | 2022-04-16 | Roanoke | Virginia | 51161 | 21107 | 280 |
2411432 | 2411432 | 2022-04-15 | Roanoke | Virginia | 51161 | 21107 | 280 |
2408176 | 2408176 | 2022-04-14 | Roanoke | Virginia | 51161 | 21097 | 279 |
2404920 | 2404920 | 2022-04-13 | Roanoke | Virginia | 51161 | 21098 | 279 |
2401665 | 2401665 | 2022-04-12 | Roanoke | Virginia | 51161 | 21078 | 279 |
2398410 | 2398410 | 2022-04-11 | Roanoke | Virginia | 51161 | 21076 | 278 |
2395155 | 2395155 | 2022-04-10 | Roanoke | Virginia | 51161 | 21068 | 278 |
2391899 | 2391899 | 2022-04-09 | Roanoke | Virginia | 51161 | 21068 | 278 |
2388643 | 2388643 | 2022-04-08 | Roanoke | Virginia | 51161 | 21068 | 278 |
2385388 | 2385388 | 2022-04-07 | Roanoke | Virginia | 51161 | 21063 | 278 |
2382133 | 2382133 | 2022-04-06 | Roanoke | Virginia | 51161 | 21071 | 277 |
2378878 | 2378878 | 2022-04-05 | Roanoke | Virginia | 51161 | 21062 | 273 |
2375624 | 2375624 | 2022-04-04 | Roanoke | Virginia | 51161 | 21064 | 271 |
2372372 | 2372372 | 2022-04-03 | Roanoke | Virginia | 51161 | 21049 | 271 |
2369119 | 2369119 | 2022-04-02 | Roanoke | Virginia | 51161 | 21049 | 271 |
2365866 | 2365866 | 2022-04-01 | Roanoke | Virginia | 51161 | 21049 | 271 |
2362613 | 2362613 | 2022-03-31 | Roanoke | Virginia | 51161 | 21008 | 270 |
2359359 | 2359359 | 2022-03-30 | Roanoke | Virginia | 51161 | 20996 | 269 |
2356105 | 2356105 | 2022-03-29 | Roanoke | Virginia | 51161 | 20978 | 269 |
2352852 | 2352852 | 2022-03-28 | Roanoke | Virginia | 51161 | 20960 | 269 |
2349600 | 2349600 | 2022-03-27 | Roanoke | Virginia | 51161 | 20953 | 269 |
2346347 | 2346347 | 2022-03-26 | Roanoke | Virginia | 51161 | 20953 | 269 |
2343094 | 2343094 | 2022-03-25 | Roanoke | Virginia | 51161 | 20953 | 269 |
2339841 | 2339841 | 2022-03-24 | Roanoke | Virginia | 51161 | 20938 | 267 |
2336587 | 2336587 | 2022-03-23 | Roanoke | Virginia | 51161 | 20926 | 267 |
2333333 | 2333333 | 2022-03-22 | Roanoke | Virginia | 51161 | 20949 | 267 |
2330080 | 2330080 | 2022-03-21 | Roanoke | Virginia | 51161 | 20949 | 267 |
2326828 | 2326828 | 2022-03-20 | Roanoke | Virginia | 51161 | 20962 | 266 |
2323575 | 2323575 | 2022-03-19 | Roanoke | Virginia | 51161 | 20962 | 266 |
2320321 | 2320321 | 2022-03-18 | Roanoke | Virginia | 51161 | 20962 | 266 |
2317067 | 2317067 | 2022-03-17 | Roanoke | Virginia | 51161 | 20967 | 267 |
2313814 | 2313814 | 2022-03-16 | Roanoke | Virginia | 51161 | 20946 | 266 |
2310561 | 2310561 | 2022-03-15 | Roanoke | Virginia | 51161 | 20934 | 265 |
2307308 | 2307308 | 2022-03-14 | Roanoke | Virginia | 51161 | 20920 | 264 |
2304057 | 2304057 | 2022-03-13 | Roanoke | Virginia | 51161 | 20960 | 265 |
2300805 | 2300805 | 2022-03-12 | Roanoke | Virginia | 51161 | 20960 | 265 |
2297553 | 2297553 | 2022-03-11 | Roanoke | Virginia | 51161 | 20960 | 265 |
2294301 | 2294301 | 2022-03-10 | Roanoke | Virginia | 51161 | 21163 | 267 |
2291049 | 2291049 | 2022-03-09 | Roanoke | Virginia | 51161 | 21173 | 270 |
2287797 | 2287797 | 2022-03-08 | Roanoke | Virginia | 51161 | 21173 | 270 |
2284545 | 2284545 | 2022-03-07 | Roanoke | Virginia | 51161 | 21174 | 272 |
2281293 | 2281293 | 2022-03-06 | Roanoke | Virginia | 51161 | 21161 | 271 |
2278040 | 2278040 | 2022-03-05 | Roanoke | Virginia | 51161 | 21161 | 271 |
2274787 | 2274787 | 2022-03-04 | Roanoke | Virginia | 51161 | 21161 | 271 |
2271534 | 2271534 | 2022-03-03 | Roanoke | Virginia | 51161 | 21002 | 270 |
2268282 | 2268282 | 2022-03-02 | Roanoke | Virginia | 51161 | 20516 | 263 |
2265029 | 2265029 | 2022-03-01 | Roanoke | Virginia | 51161 | 20253 | 259 |
2261779 | 2261779 | 2022-02-28 | Roanoke | Virginia | 51161 | 20074 | 255 |
2258528 | 2258528 | 2022-02-27 | Roanoke | Virginia | 51161 | 19860 | 250 |
2255277 | 2255277 | 2022-02-26 | Roanoke | Virginia | 51161 | 19860 | 250 |
2252026 | 2252026 | 2022-02-25 | Roanoke | Virginia | 51161 | 19860 | 250 |
2248775 | 2248775 | 2022-02-24 | Roanoke | Virginia | 51161 | 19700 | 245 |
2245524 | 2245524 | 2022-02-23 | Roanoke | Virginia | 51161 | 19745 | 244 |
2242273 | 2242273 | 2022-02-22 | Roanoke | Virginia | 51161 | 19750 | 242 |
2239022 | 2239022 | 2022-02-21 | Roanoke | Virginia | 51161 | 19745 | 242 |
2235771 | 2235771 | 2022-02-20 | Roanoke | Virginia | 51161 | 19707 | 241 |
2232520 | 2232520 | 2022-02-19 | Roanoke | Virginia | 51161 | 19707 | 241 |
2229269 | 2229269 | 2022-02-18 | Roanoke | Virginia | 51161 | 19707 | 241 |
2226018 | 2226018 | 2022-02-17 | Roanoke | Virginia | 51161 | 19742 | 242 |
2222767 | 2222767 | 2022-02-16 | Roanoke | Virginia | 51161 | 19746 | 240 |
2219516 | 2219516 | 2022-02-15 | Roanoke | Virginia | 51161 | 19741 | 240 |
2216266 | 2216266 | 2022-02-14 | Roanoke | Virginia | 51161 | 19785 | 239 |
2213015 | 2213015 | 2022-02-13 | Roanoke | Virginia | 51161 | 19718 | 234 |
2209762 | 2209762 | 2022-02-12 | Roanoke | Virginia | 51161 | 19718 | 234 |
2206509 | 2206509 | 2022-02-11 | Roanoke | Virginia | 51161 | 19718 | 234 |
2203256 | 2203256 | 2022-02-10 | Roanoke | Virginia | 51161 | 19801 | 235 |
2200002 | 2200002 | 2022-02-09 | Roanoke | Virginia | 51161 | 19799 | 232 |
2196748 | 2196748 | 2022-02-08 | Roanoke | Virginia | 51161 | 19787 | 234 |
2193493 | 2193493 | 2022-02-07 | Roanoke | Virginia | 51161 | 19740 | 229 |
2190240 | 2190240 | 2022-02-06 | Roanoke | Virginia | 51161 | 19484 | 212 |
2186987 | 2186987 | 2022-02-05 | Roanoke | Virginia | 51161 | 19484 | 212 |
2183734 | 2183734 | 2022-02-04 | Roanoke | Virginia | 51161 | 19484 | 212 |
2180482 | 2180482 | 2022-02-03 | Roanoke | Virginia | 51161 | 19420 | 209 |
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);