ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Roanoke city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502617 | 2502617 | 2022-05-13 | Roanoke city | Virginia | 51770 | 21671 | 376 |
2499359 | 2499359 | 2022-05-12 | Roanoke city | Virginia | 51770 | 21630 | 376 |
2496101 | 2496101 | 2022-05-11 | Roanoke city | Virginia | 51770 | 21603 | 376 |
2492843 | 2492843 | 2022-05-10 | Roanoke city | Virginia | 51770 | 21576 | 375 |
2489585 | 2489585 | 2022-05-09 | Roanoke city | Virginia | 51770 | 21560 | 375 |
2486328 | 2486328 | 2022-05-08 | Roanoke city | Virginia | 51770 | 21495 | 375 |
2483070 | 2483070 | 2022-05-07 | Roanoke city | Virginia | 51770 | 21495 | 375 |
2479812 | 2479812 | 2022-05-06 | Roanoke city | Virginia | 51770 | 21495 | 375 |
2476554 | 2476554 | 2022-05-05 | Roanoke city | Virginia | 51770 | 21475 | 375 |
2473296 | 2473296 | 2022-05-04 | Roanoke city | Virginia | 51770 | 21459 | 375 |
2470040 | 2470040 | 2022-05-03 | Roanoke city | Virginia | 51770 | 21435 | 374 |
2466784 | 2466784 | 2022-05-02 | Roanoke city | Virginia | 51770 | 21423 | 374 |
2463529 | 2463529 | 2022-05-01 | Roanoke city | Virginia | 51770 | 21398 | 374 |
2460273 | 2460273 | 2022-04-30 | Roanoke city | Virginia | 51770 | 21398 | 374 |
2457017 | 2457017 | 2022-04-29 | Roanoke city | Virginia | 51770 | 21398 | 374 |
2453761 | 2453761 | 2022-04-28 | Roanoke city | Virginia | 51770 | 21385 | 373 |
2450505 | 2450505 | 2022-04-27 | Roanoke city | Virginia | 51770 | 21366 | 373 |
2447248 | 2447248 | 2022-04-26 | Roanoke city | Virginia | 51770 | 21344 | 373 |
2443993 | 2443993 | 2022-04-25 | Roanoke city | Virginia | 51770 | 21338 | 373 |
2440737 | 2440737 | 2022-04-24 | Roanoke city | Virginia | 51770 | 21323 | 372 |
2437481 | 2437481 | 2022-04-23 | Roanoke city | Virginia | 51770 | 21323 | 372 |
2434225 | 2434225 | 2022-04-22 | Roanoke city | Virginia | 51770 | 21323 | 372 |
2430969 | 2430969 | 2022-04-21 | Roanoke city | Virginia | 51770 | 21315 | 370 |
2427713 | 2427713 | 2022-04-20 | Roanoke city | Virginia | 51770 | 21304 | 370 |
2424457 | 2424457 | 2022-04-19 | Roanoke city | Virginia | 51770 | 21295 | 369 |
2421201 | 2421201 | 2022-04-18 | Roanoke city | Virginia | 51770 | 21287 | 368 |
2417945 | 2417945 | 2022-04-17 | Roanoke city | Virginia | 51770 | 21267 | 368 |
2414689 | 2414689 | 2022-04-16 | Roanoke city | Virginia | 51770 | 21267 | 368 |
2411433 | 2411433 | 2022-04-15 | Roanoke city | Virginia | 51770 | 21267 | 368 |
2408177 | 2408177 | 2022-04-14 | Roanoke city | Virginia | 51770 | 21258 | 367 |
2404921 | 2404921 | 2022-04-13 | Roanoke city | Virginia | 51770 | 21250 | 366 |
2401666 | 2401666 | 2022-04-12 | Roanoke city | Virginia | 51770 | 21236 | 366 |
2398411 | 2398411 | 2022-04-11 | Roanoke city | Virginia | 51770 | 21234 | 365 |
2395156 | 2395156 | 2022-04-10 | Roanoke city | Virginia | 51770 | 21226 | 365 |
2391900 | 2391900 | 2022-04-09 | Roanoke city | Virginia | 51770 | 21226 | 365 |
2388644 | 2388644 | 2022-04-08 | Roanoke city | Virginia | 51770 | 21226 | 365 |
2385389 | 2385389 | 2022-04-07 | Roanoke city | Virginia | 51770 | 21223 | 364 |
2382134 | 2382134 | 2022-04-06 | Roanoke city | Virginia | 51770 | 21217 | 363 |
2378879 | 2378879 | 2022-04-05 | Roanoke city | Virginia | 51770 | 21219 | 361 |
2375625 | 2375625 | 2022-04-04 | Roanoke city | Virginia | 51770 | 21214 | 360 |
2372373 | 2372373 | 2022-04-03 | Roanoke city | Virginia | 51770 | 21191 | 360 |
2369120 | 2369120 | 2022-04-02 | Roanoke city | Virginia | 51770 | 21191 | 360 |
2365867 | 2365867 | 2022-04-01 | Roanoke city | Virginia | 51770 | 21191 | 360 |
2362614 | 2362614 | 2022-03-31 | Roanoke city | Virginia | 51770 | 21175 | 360 |
2359360 | 2359360 | 2022-03-30 | Roanoke city | Virginia | 51770 | 21151 | 360 |
2356106 | 2356106 | 2022-03-29 | Roanoke city | Virginia | 51770 | 21120 | 360 |
2352853 | 2352853 | 2022-03-28 | Roanoke city | Virginia | 51770 | 21111 | 359 |
2349601 | 2349601 | 2022-03-27 | Roanoke city | Virginia | 51770 | 21099 | 359 |
2346348 | 2346348 | 2022-03-26 | Roanoke city | Virginia | 51770 | 21099 | 359 |
2343095 | 2343095 | 2022-03-25 | Roanoke city | Virginia | 51770 | 21099 | 359 |
2339842 | 2339842 | 2022-03-24 | Roanoke city | Virginia | 51770 | 21086 | 358 |
2336588 | 2336588 | 2022-03-23 | Roanoke city | Virginia | 51770 | 21052 | 358 |
2333334 | 2333334 | 2022-03-22 | Roanoke city | Virginia | 51770 | 21040 | 357 |
2330081 | 2330081 | 2022-03-21 | Roanoke city | Virginia | 51770 | 21040 | 357 |
2326829 | 2326829 | 2022-03-20 | Roanoke city | Virginia | 51770 | 21001 | 354 |
2323576 | 2323576 | 2022-03-19 | Roanoke city | Virginia | 51770 | 21001 | 354 |
2320322 | 2320322 | 2022-03-18 | Roanoke city | Virginia | 51770 | 21001 | 354 |
2317068 | 2317068 | 2022-03-17 | Roanoke city | Virginia | 51770 | 20971 | 353 |
2313815 | 2313815 | 2022-03-16 | Roanoke city | Virginia | 51770 | 20957 | 349 |
2310562 | 2310562 | 2022-03-15 | Roanoke city | Virginia | 51770 | 20944 | 349 |
2307309 | 2307309 | 2022-03-14 | Roanoke city | Virginia | 51770 | 20917 | 348 |
2304058 | 2304058 | 2022-03-13 | Roanoke city | Virginia | 51770 | 20837 | 344 |
2300806 | 2300806 | 2022-03-12 | Roanoke city | Virginia | 51770 | 20837 | 344 |
2297554 | 2297554 | 2022-03-11 | Roanoke city | Virginia | 51770 | 20837 | 344 |
2294302 | 2294302 | 2022-03-10 | Roanoke city | Virginia | 51770 | 20610 | 340 |
2291050 | 2291050 | 2022-03-09 | Roanoke city | Virginia | 51770 | 20608 | 342 |
2287798 | 2287798 | 2022-03-08 | Roanoke city | Virginia | 51770 | 20604 | 336 |
2284546 | 2284546 | 2022-03-07 | Roanoke city | Virginia | 51770 | 20611 | 334 |
2281294 | 2281294 | 2022-03-06 | Roanoke city | Virginia | 51770 | 20560 | 330 |
2278041 | 2278041 | 2022-03-05 | Roanoke city | Virginia | 51770 | 20560 | 330 |
2274788 | 2274788 | 2022-03-04 | Roanoke city | Virginia | 51770 | 20560 | 330 |
2271535 | 2271535 | 2022-03-03 | Roanoke city | Virginia | 51770 | 20662 | 329 |
2268283 | 2268283 | 2022-03-02 | Roanoke city | Virginia | 51770 | 20723 | 329 |
2265030 | 2265030 | 2022-03-01 | Roanoke city | Virginia | 51770 | 20716 | 327 |
2261780 | 2261780 | 2022-02-28 | Roanoke city | Virginia | 51770 | 20719 | 327 |
2258529 | 2258529 | 2022-02-27 | Roanoke city | Virginia | 51770 | 20691 | 325 |
2255278 | 2255278 | 2022-02-26 | Roanoke city | Virginia | 51770 | 20691 | 325 |
2252027 | 2252027 | 2022-02-25 | Roanoke city | Virginia | 51770 | 20691 | 325 |
2248776 | 2248776 | 2022-02-24 | Roanoke city | Virginia | 51770 | 20678 | 324 |
2245525 | 2245525 | 2022-02-23 | Roanoke city | Virginia | 51770 | 20637 | 322 |
2242274 | 2242274 | 2022-02-22 | Roanoke city | Virginia | 51770 | 20614 | 321 |
2239023 | 2239023 | 2022-02-21 | Roanoke city | Virginia | 51770 | 20580 | 320 |
2235772 | 2235772 | 2022-02-20 | Roanoke city | Virginia | 51770 | 20505 | 319 |
2232521 | 2232521 | 2022-02-19 | Roanoke city | Virginia | 51770 | 20505 | 319 |
2229270 | 2229270 | 2022-02-18 | Roanoke city | Virginia | 51770 | 20505 | 319 |
2226019 | 2226019 | 2022-02-17 | Roanoke city | Virginia | 51770 | 20463 | 319 |
2222768 | 2222768 | 2022-02-16 | Roanoke city | Virginia | 51770 | 20444 | 319 |
2219517 | 2219517 | 2022-02-15 | Roanoke city | Virginia | 51770 | 20459 | 319 |
2216267 | 2216267 | 2022-02-14 | Roanoke city | Virginia | 51770 | 20445 | 318 |
2213016 | 2213016 | 2022-02-13 | Roanoke city | Virginia | 51770 | 20365 | 310 |
2209763 | 2209763 | 2022-02-12 | Roanoke city | Virginia | 51770 | 20365 | 310 |
2206510 | 2206510 | 2022-02-11 | Roanoke city | Virginia | 51770 | 20365 | 310 |
2203257 | 2203257 | 2022-02-10 | Roanoke city | Virginia | 51770 | 20319 | 308 |
2200003 | 2200003 | 2022-02-09 | Roanoke city | Virginia | 51770 | 20284 | 306 |
2196749 | 2196749 | 2022-02-08 | Roanoke city | Virginia | 51770 | 20207 | 305 |
2193494 | 2193494 | 2022-02-07 | Roanoke city | Virginia | 51770 | 20142 | 303 |
2190241 | 2190241 | 2022-02-06 | Roanoke city | Virginia | 51770 | 19993 | 296 |
2186988 | 2186988 | 2022-02-05 | Roanoke city | Virginia | 51770 | 19993 | 296 |
2183735 | 2183735 | 2022-02-04 | Roanoke city | Virginia | 51770 | 19993 | 296 |
2180483 | 2180483 | 2022-02-03 | Roanoke city | Virginia | 51770 | 19902 | 290 |
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);