ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Staunton city", fips = 51790 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502628 | 2502628 | 2022-05-13 | Staunton city | Virginia | 51790 | 5737 | 115 |
2499370 | 2499370 | 2022-05-12 | Staunton city | Virginia | 51790 | 5730 | 115 |
2496112 | 2496112 | 2022-05-11 | Staunton city | Virginia | 51790 | 5781 | 116 |
2492854 | 2492854 | 2022-05-10 | Staunton city | Virginia | 51790 | 5752 | 116 |
2489596 | 2489596 | 2022-05-09 | Staunton city | Virginia | 51790 | 5670 | 115 |
2486339 | 2486339 | 2022-05-08 | Staunton city | Virginia | 51790 | 5745 | 118 |
2483081 | 2483081 | 2022-05-07 | Staunton city | Virginia | 51790 | 5745 | 118 |
2479823 | 2479823 | 2022-05-06 | Staunton city | Virginia | 51790 | 5745 | 118 |
2476565 | 2476565 | 2022-05-05 | Staunton city | Virginia | 51790 | 5721 | 118 |
2473307 | 2473307 | 2022-05-04 | Staunton city | Virginia | 51790 | 5730 | 118 |
2470051 | 2470051 | 2022-05-03 | Staunton city | Virginia | 51790 | 5725 | 117 |
2466795 | 2466795 | 2022-05-02 | Staunton city | Virginia | 51790 | 5730 | 118 |
2463540 | 2463540 | 2022-05-01 | Staunton city | Virginia | 51790 | 5710 | 118 |
2460284 | 2460284 | 2022-04-30 | Staunton city | Virginia | 51790 | 5710 | 118 |
2457028 | 2457028 | 2022-04-29 | Staunton city | Virginia | 51790 | 5710 | 118 |
2453772 | 2453772 | 2022-04-28 | Staunton city | Virginia | 51790 | 5699 | 118 |
2450516 | 2450516 | 2022-04-27 | Staunton city | Virginia | 51790 | 5692 | 118 |
2447259 | 2447259 | 2022-04-26 | Staunton city | Virginia | 51790 | 5693 | 115 |
2444004 | 2444004 | 2022-04-25 | Staunton city | Virginia | 51790 | 5678 | 112 |
2440748 | 2440748 | 2022-04-24 | Staunton city | Virginia | 51790 | 5667 | 112 |
2437492 | 2437492 | 2022-04-23 | Staunton city | Virginia | 51790 | 5667 | 112 |
2434236 | 2434236 | 2022-04-22 | Staunton city | Virginia | 51790 | 5667 | 112 |
2430980 | 2430980 | 2022-04-21 | Staunton city | Virginia | 51790 | 5666 | 112 |
2427724 | 2427724 | 2022-04-20 | Staunton city | Virginia | 51790 | 5663 | 112 |
2424468 | 2424468 | 2022-04-19 | Staunton city | Virginia | 51790 | 5663 | 112 |
2421212 | 2421212 | 2022-04-18 | Staunton city | Virginia | 51790 | 5663 | 112 |
2417956 | 2417956 | 2022-04-17 | Staunton city | Virginia | 51790 | 5659 | 112 |
2414700 | 2414700 | 2022-04-16 | Staunton city | Virginia | 51790 | 5659 | 112 |
2411444 | 2411444 | 2022-04-15 | Staunton city | Virginia | 51790 | 5659 | 112 |
2408188 | 2408188 | 2022-04-14 | Staunton city | Virginia | 51790 | 5661 | 111 |
2404932 | 2404932 | 2022-04-13 | Staunton city | Virginia | 51790 | 5660 | 110 |
2401677 | 2401677 | 2022-04-12 | Staunton city | Virginia | 51790 | 5661 | 110 |
2398422 | 2398422 | 2022-04-11 | Staunton city | Virginia | 51790 | 5655 | 110 |
2395167 | 2395167 | 2022-04-10 | Staunton city | Virginia | 51790 | 5648 | 110 |
2391911 | 2391911 | 2022-04-09 | Staunton city | Virginia | 51790 | 5648 | 110 |
2388655 | 2388655 | 2022-04-08 | Staunton city | Virginia | 51790 | 5648 | 110 |
2385400 | 2385400 | 2022-04-07 | Staunton city | Virginia | 51790 | 5646 | 110 |
2382145 | 2382145 | 2022-04-06 | Staunton city | Virginia | 51790 | 5642 | 110 |
2378890 | 2378890 | 2022-04-05 | Staunton city | Virginia | 51790 | 5637 | 110 |
2375636 | 2375636 | 2022-04-04 | Staunton city | Virginia | 51790 | 5636 | 110 |
2372384 | 2372384 | 2022-04-03 | Staunton city | Virginia | 51790 | 5625 | 110 |
2369131 | 2369131 | 2022-04-02 | Staunton city | Virginia | 51790 | 5625 | 110 |
2365878 | 2365878 | 2022-04-01 | Staunton city | Virginia | 51790 | 5625 | 110 |
2362625 | 2362625 | 2022-03-31 | Staunton city | Virginia | 51790 | 5621 | 110 |
2359371 | 2359371 | 2022-03-30 | Staunton city | Virginia | 51790 | 5621 | 110 |
2356117 | 2356117 | 2022-03-29 | Staunton city | Virginia | 51790 | 5616 | 110 |
2352864 | 2352864 | 2022-03-28 | Staunton city | Virginia | 51790 | 5610 | 110 |
2349612 | 2349612 | 2022-03-27 | Staunton city | Virginia | 51790 | 5612 | 109 |
2346359 | 2346359 | 2022-03-26 | Staunton city | Virginia | 51790 | 5612 | 109 |
2343106 | 2343106 | 2022-03-25 | Staunton city | Virginia | 51790 | 5612 | 109 |
2339853 | 2339853 | 2022-03-24 | Staunton city | Virginia | 51790 | 5612 | 109 |
2336599 | 2336599 | 2022-03-23 | Staunton city | Virginia | 51790 | 5606 | 109 |
2333345 | 2333345 | 2022-03-22 | Staunton city | Virginia | 51790 | 5612 | 109 |
2330092 | 2330092 | 2022-03-21 | Staunton city | Virginia | 51790 | 5612 | 109 |
2326840 | 2326840 | 2022-03-20 | Staunton city | Virginia | 51790 | 5600 | 109 |
2323587 | 2323587 | 2022-03-19 | Staunton city | Virginia | 51790 | 5600 | 109 |
2320333 | 2320333 | 2022-03-18 | Staunton city | Virginia | 51790 | 5600 | 109 |
2317079 | 2317079 | 2022-03-17 | Staunton city | Virginia | 51790 | 5598 | 109 |
2313826 | 2313826 | 2022-03-16 | Staunton city | Virginia | 51790 | 5598 | 107 |
2310573 | 2310573 | 2022-03-15 | Staunton city | Virginia | 51790 | 5586 | 107 |
2307320 | 2307320 | 2022-03-14 | Staunton city | Virginia | 51790 | 5579 | 107 |
2304069 | 2304069 | 2022-03-13 | Staunton city | Virginia | 51790 | 5571 | 105 |
2300817 | 2300817 | 2022-03-12 | Staunton city | Virginia | 51790 | 5571 | 105 |
2297565 | 2297565 | 2022-03-11 | Staunton city | Virginia | 51790 | 5571 | 105 |
2294313 | 2294313 | 2022-03-10 | Staunton city | Virginia | 51790 | 5569 | 105 |
2291061 | 2291061 | 2022-03-09 | Staunton city | Virginia | 51790 | 5566 | 105 |
2287809 | 2287809 | 2022-03-08 | Staunton city | Virginia | 51790 | 5554 | 105 |
2284557 | 2284557 | 2022-03-07 | Staunton city | Virginia | 51790 | 5550 | 105 |
2281305 | 2281305 | 2022-03-06 | Staunton city | Virginia | 51790 | 5543 | 104 |
2278052 | 2278052 | 2022-03-05 | Staunton city | Virginia | 51790 | 5543 | 104 |
2274799 | 2274799 | 2022-03-04 | Staunton city | Virginia | 51790 | 5543 | 104 |
2271546 | 2271546 | 2022-03-03 | Staunton city | Virginia | 51790 | 5540 | 104 |
2268294 | 2268294 | 2022-03-02 | Staunton city | Virginia | 51790 | 5537 | 104 |
2265041 | 2265041 | 2022-03-01 | Staunton city | Virginia | 51790 | 5534 | 104 |
2261791 | 2261791 | 2022-02-28 | Staunton city | Virginia | 51790 | 5531 | 104 |
2258540 | 2258540 | 2022-02-27 | Staunton city | Virginia | 51790 | 5514 | 103 |
2255289 | 2255289 | 2022-02-26 | Staunton city | Virginia | 51790 | 5514 | 103 |
2252038 | 2252038 | 2022-02-25 | Staunton city | Virginia | 51790 | 5514 | 103 |
2248787 | 2248787 | 2022-02-24 | Staunton city | Virginia | 51790 | 5509 | 103 |
2245536 | 2245536 | 2022-02-23 | Staunton city | Virginia | 51790 | 5500 | 102 |
2242285 | 2242285 | 2022-02-22 | Staunton city | Virginia | 51790 | 5493 | 100 |
2239034 | 2239034 | 2022-02-21 | Staunton city | Virginia | 51790 | 5485 | 100 |
2235783 | 2235783 | 2022-02-20 | Staunton city | Virginia | 51790 | 5460 | 99 |
2232532 | 2232532 | 2022-02-19 | Staunton city | Virginia | 51790 | 5460 | 99 |
2229281 | 2229281 | 2022-02-18 | Staunton city | Virginia | 51790 | 5460 | 99 |
2226030 | 2226030 | 2022-02-17 | Staunton city | Virginia | 51790 | 5447 | 99 |
2222779 | 2222779 | 2022-02-16 | Staunton city | Virginia | 51790 | 5436 | 99 |
2219528 | 2219528 | 2022-02-15 | Staunton city | Virginia | 51790 | 5422 | 99 |
2216278 | 2216278 | 2022-02-14 | Staunton city | Virginia | 51790 | 5407 | 98 |
2213027 | 2213027 | 2022-02-13 | Staunton city | Virginia | 51790 | 5363 | 98 |
2209774 | 2209774 | 2022-02-12 | Staunton city | Virginia | 51790 | 5363 | 98 |
2206521 | 2206521 | 2022-02-11 | Staunton city | Virginia | 51790 | 5363 | 98 |
2203268 | 2203268 | 2022-02-10 | Staunton city | Virginia | 51790 | 5350 | 98 |
2200014 | 2200014 | 2022-02-09 | Staunton city | Virginia | 51790 | 5336 | 98 |
2196760 | 2196760 | 2022-02-08 | Staunton city | Virginia | 51790 | 5321 | 98 |
2193505 | 2193505 | 2022-02-07 | Staunton city | Virginia | 51790 | 5300 | 98 |
2190252 | 2190252 | 2022-02-06 | Staunton city | Virginia | 51790 | 5264 | 97 |
2186999 | 2186999 | 2022-02-05 | Staunton city | Virginia | 51790 | 5264 | 97 |
2183746 | 2183746 | 2022-02-04 | Staunton city | Virginia | 51790 | 5264 | 97 |
2180494 | 2180494 | 2022-02-03 | Staunton city | Virginia | 51790 | 5233 | 96 |
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);