ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Danville city" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502542 | 2502542 | 2022-05-13 | Danville city | Virginia | 51590 | 11226 | 282 |
2499284 | 2499284 | 2022-05-12 | Danville city | Virginia | 51590 | 11207 | 282 |
2496026 | 2496026 | 2022-05-11 | Danville city | Virginia | 51590 | 11191 | 282 |
2492768 | 2492768 | 2022-05-10 | Danville city | Virginia | 51590 | 11182 | 282 |
2489510 | 2489510 | 2022-05-09 | Danville city | Virginia | 51590 | 11182 | 282 |
2486253 | 2486253 | 2022-05-08 | Danville city | Virginia | 51590 | 11163 | 282 |
2482995 | 2482995 | 2022-05-07 | Danville city | Virginia | 51590 | 11163 | 282 |
2479737 | 2479737 | 2022-05-06 | Danville city | Virginia | 51590 | 11163 | 282 |
2476479 | 2476479 | 2022-05-05 | Danville city | Virginia | 51590 | 11149 | 282 |
2473221 | 2473221 | 2022-05-04 | Danville city | Virginia | 51590 | 11152 | 282 |
2469965 | 2469965 | 2022-05-03 | Danville city | Virginia | 51590 | 11120 | 282 |
2466709 | 2466709 | 2022-05-02 | Danville city | Virginia | 51590 | 11113 | 282 |
2463454 | 2463454 | 2022-05-01 | Danville city | Virginia | 51590 | 11090 | 282 |
2460198 | 2460198 | 2022-04-30 | Danville city | Virginia | 51590 | 11090 | 282 |
2456942 | 2456942 | 2022-04-29 | Danville city | Virginia | 51590 | 11090 | 282 |
2453686 | 2453686 | 2022-04-28 | Danville city | Virginia | 51590 | 11090 | 281 |
2450430 | 2450430 | 2022-04-27 | Danville city | Virginia | 51590 | 11086 | 281 |
2447173 | 2447173 | 2022-04-26 | Danville city | Virginia | 51590 | 11093 | 281 |
2443918 | 2443918 | 2022-04-25 | Danville city | Virginia | 51590 | 11099 | 281 |
2440662 | 2440662 | 2022-04-24 | Danville city | Virginia | 51590 | 11074 | 280 |
2437406 | 2437406 | 2022-04-23 | Danville city | Virginia | 51590 | 11074 | 280 |
2434150 | 2434150 | 2022-04-22 | Danville city | Virginia | 51590 | 11074 | 280 |
2430894 | 2430894 | 2022-04-21 | Danville city | Virginia | 51590 | 11066 | 280 |
2427638 | 2427638 | 2022-04-20 | Danville city | Virginia | 51590 | 11063 | 280 |
2424382 | 2424382 | 2022-04-19 | Danville city | Virginia | 51590 | 11060 | 280 |
2421126 | 2421126 | 2022-04-18 | Danville city | Virginia | 51590 | 11062 | 280 |
2417870 | 2417870 | 2022-04-17 | Danville city | Virginia | 51590 | 11059 | 280 |
2414614 | 2414614 | 2022-04-16 | Danville city | Virginia | 51590 | 11059 | 280 |
2411358 | 2411358 | 2022-04-15 | Danville city | Virginia | 51590 | 11059 | 280 |
2408102 | 2408102 | 2022-04-14 | Danville city | Virginia | 51590 | 11055 | 280 |
2404846 | 2404846 | 2022-04-13 | Danville city | Virginia | 51590 | 11054 | 279 |
2401591 | 2401591 | 2022-04-12 | Danville city | Virginia | 51590 | 11050 | 278 |
2398336 | 2398336 | 2022-04-11 | Danville city | Virginia | 51590 | 11046 | 277 |
2395081 | 2395081 | 2022-04-10 | Danville city | Virginia | 51590 | 11044 | 277 |
2391825 | 2391825 | 2022-04-09 | Danville city | Virginia | 51590 | 11044 | 277 |
2388569 | 2388569 | 2022-04-08 | Danville city | Virginia | 51590 | 11044 | 277 |
2385314 | 2385314 | 2022-04-07 | Danville city | Virginia | 51590 | 11036 | 276 |
2382059 | 2382059 | 2022-04-06 | Danville city | Virginia | 51590 | 11055 | 275 |
2378804 | 2378804 | 2022-04-05 | Danville city | Virginia | 51590 | 11092 | 276 |
2375550 | 2375550 | 2022-04-04 | Danville city | Virginia | 51590 | 11112 | 276 |
2372298 | 2372298 | 2022-04-03 | Danville city | Virginia | 51590 | 11120 | 276 |
2369045 | 2369045 | 2022-04-02 | Danville city | Virginia | 51590 | 11120 | 276 |
2365792 | 2365792 | 2022-04-01 | Danville city | Virginia | 51590 | 11120 | 276 |
2362539 | 2362539 | 2022-03-31 | Danville city | Virginia | 51590 | 11112 | 276 |
2359285 | 2359285 | 2022-03-30 | Danville city | Virginia | 51590 | 11112 | 276 |
2356031 | 2356031 | 2022-03-29 | Danville city | Virginia | 51590 | 11125 | 276 |
2352778 | 2352778 | 2022-03-28 | Danville city | Virginia | 51590 | 11125 | 276 |
2349526 | 2349526 | 2022-03-27 | Danville city | Virginia | 51590 | 11123 | 276 |
2346273 | 2346273 | 2022-03-26 | Danville city | Virginia | 51590 | 11123 | 276 |
2343020 | 2343020 | 2022-03-25 | Danville city | Virginia | 51590 | 11123 | 276 |
2339767 | 2339767 | 2022-03-24 | Danville city | Virginia | 51590 | 11120 | 276 |
2336513 | 2336513 | 2022-03-23 | Danville city | Virginia | 51590 | 11119 | 276 |
2333259 | 2333259 | 2022-03-22 | Danville city | Virginia | 51590 | 11119 | 275 |
2330006 | 2330006 | 2022-03-21 | Danville city | Virginia | 51590 | 11119 | 275 |
2326754 | 2326754 | 2022-03-20 | Danville city | Virginia | 51590 | 11114 | 275 |
2323501 | 2323501 | 2022-03-19 | Danville city | Virginia | 51590 | 11114 | 275 |
2320247 | 2320247 | 2022-03-18 | Danville city | Virginia | 51590 | 11114 | 275 |
2316993 | 2316993 | 2022-03-17 | Danville city | Virginia | 51590 | 11114 | 274 |
2313740 | 2313740 | 2022-03-16 | Danville city | Virginia | 51590 | 11120 | 274 |
2310487 | 2310487 | 2022-03-15 | Danville city | Virginia | 51590 | 11072 | 274 |
2307234 | 2307234 | 2022-03-14 | Danville city | Virginia | 51590 | 11049 | 271 |
2303983 | 2303983 | 2022-03-13 | Danville city | Virginia | 51590 | 11038 | 265 |
2300731 | 2300731 | 2022-03-12 | Danville city | Virginia | 51590 | 11038 | 265 |
2297479 | 2297479 | 2022-03-11 | Danville city | Virginia | 51590 | 11038 | 265 |
2294227 | 2294227 | 2022-03-10 | Danville city | Virginia | 51590 | 11017 | 263 |
2290975 | 2290975 | 2022-03-09 | Danville city | Virginia | 51590 | 10966 | 262 |
2287723 | 2287723 | 2022-03-08 | Danville city | Virginia | 51590 | 10940 | 262 |
2284471 | 2284471 | 2022-03-07 | Danville city | Virginia | 51590 | 10930 | 260 |
2281219 | 2281219 | 2022-03-06 | Danville city | Virginia | 51590 | 10885 | 257 |
2277966 | 2277966 | 2022-03-05 | Danville city | Virginia | 51590 | 10885 | 257 |
2274713 | 2274713 | 2022-03-04 | Danville city | Virginia | 51590 | 10885 | 257 |
2271460 | 2271460 | 2022-03-03 | Danville city | Virginia | 51590 | 10883 | 255 |
2268208 | 2268208 | 2022-03-02 | Danville city | Virginia | 51590 | 10834 | 255 |
2264955 | 2264955 | 2022-03-01 | Danville city | Virginia | 51590 | 10763 | 252 |
2261705 | 2261705 | 2022-02-28 | Danville city | Virginia | 51590 | 10721 | 252 |
2258454 | 2258454 | 2022-02-27 | Danville city | Virginia | 51590 | 10696 | 246 |
2255203 | 2255203 | 2022-02-26 | Danville city | Virginia | 51590 | 10696 | 246 |
2251952 | 2251952 | 2022-02-25 | Danville city | Virginia | 51590 | 10696 | 246 |
2248701 | 2248701 | 2022-02-24 | Danville city | Virginia | 51590 | 10686 | 244 |
2245450 | 2245450 | 2022-02-23 | Danville city | Virginia | 51590 | 10678 | 243 |
2242199 | 2242199 | 2022-02-22 | Danville city | Virginia | 51590 | 10680 | 241 |
2238948 | 2238948 | 2022-02-21 | Danville city | Virginia | 51590 | 10649 | 241 |
2235697 | 2235697 | 2022-02-20 | Danville city | Virginia | 51590 | 10627 | 237 |
2232446 | 2232446 | 2022-02-19 | Danville city | Virginia | 51590 | 10627 | 237 |
2229195 | 2229195 | 2022-02-18 | Danville city | Virginia | 51590 | 10627 | 237 |
2225944 | 2225944 | 2022-02-17 | Danville city | Virginia | 51590 | 10608 | 236 |
2222693 | 2222693 | 2022-02-16 | Danville city | Virginia | 51590 | 10611 | 235 |
2219442 | 2219442 | 2022-02-15 | Danville city | Virginia | 51590 | 10602 | 234 |
2216192 | 2216192 | 2022-02-14 | Danville city | Virginia | 51590 | 10583 | 234 |
2212941 | 2212941 | 2022-02-13 | Danville city | Virginia | 51590 | 10537 | 232 |
2209688 | 2209688 | 2022-02-12 | Danville city | Virginia | 51590 | 10537 | 232 |
2206435 | 2206435 | 2022-02-11 | Danville city | Virginia | 51590 | 10537 | 232 |
2203182 | 2203182 | 2022-02-10 | Danville city | Virginia | 51590 | 10493 | 231 |
2199928 | 2199928 | 2022-02-09 | Danville city | Virginia | 51590 | 10436 | 230 |
2196674 | 2196674 | 2022-02-08 | Danville city | Virginia | 51590 | 10331 | 228 |
2193419 | 2193419 | 2022-02-07 | Danville city | Virginia | 51590 | 10277 | 225 |
2190166 | 2190166 | 2022-02-06 | Danville city | Virginia | 51590 | 10179 | 223 |
2186913 | 2186913 | 2022-02-05 | Danville city | Virginia | 51590 | 10179 | 223 |
2183660 | 2183660 | 2022-02-04 | Danville city | Virginia | 51590 | 10179 | 223 |
2180408 | 2180408 | 2022-02-03 | Danville city | Virginia | 51590 | 10122 | 223 |
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);