ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 51081 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 |
---|---|---|---|---|---|---|---|
2502563 | 2502563 | 2022-05-13 | Greensville | Virginia | 51081 | 3341 | 40 |
2499305 | 2499305 | 2022-05-12 | Greensville | Virginia | 51081 | 3341 | 40 |
2496047 | 2496047 | 2022-05-11 | Greensville | Virginia | 51081 | 3340 | 40 |
2492789 | 2492789 | 2022-05-10 | Greensville | Virginia | 51081 | 3338 | 40 |
2489531 | 2489531 | 2022-05-09 | Greensville | Virginia | 51081 | 3340 | 40 |
2486274 | 2486274 | 2022-05-08 | Greensville | Virginia | 51081 | 3334 | 40 |
2483016 | 2483016 | 2022-05-07 | Greensville | Virginia | 51081 | 3334 | 40 |
2479758 | 2479758 | 2022-05-06 | Greensville | Virginia | 51081 | 3334 | 40 |
2476500 | 2476500 | 2022-05-05 | Greensville | Virginia | 51081 | 3333 | 40 |
2473242 | 2473242 | 2022-05-04 | Greensville | Virginia | 51081 | 3333 | 40 |
2469986 | 2469986 | 2022-05-03 | Greensville | Virginia | 51081 | 3330 | 40 |
2466730 | 2466730 | 2022-05-02 | Greensville | Virginia | 51081 | 3330 | 40 |
2463475 | 2463475 | 2022-05-01 | Greensville | Virginia | 51081 | 3332 | 40 |
2460219 | 2460219 | 2022-04-30 | Greensville | Virginia | 51081 | 3332 | 40 |
2456963 | 2456963 | 2022-04-29 | Greensville | Virginia | 51081 | 3332 | 40 |
2453707 | 2453707 | 2022-04-28 | Greensville | Virginia | 51081 | 3330 | 40 |
2450451 | 2450451 | 2022-04-27 | Greensville | Virginia | 51081 | 3330 | 40 |
2447194 | 2447194 | 2022-04-26 | Greensville | Virginia | 51081 | 3326 | 39 |
2443939 | 2443939 | 2022-04-25 | Greensville | Virginia | 51081 | 3326 | 39 |
2440683 | 2440683 | 2022-04-24 | Greensville | Virginia | 51081 | 3327 | 39 |
2437427 | 2437427 | 2022-04-23 | Greensville | Virginia | 51081 | 3327 | 39 |
2434171 | 2434171 | 2022-04-22 | Greensville | Virginia | 51081 | 3327 | 39 |
2430915 | 2430915 | 2022-04-21 | Greensville | Virginia | 51081 | 3325 | 39 |
2427659 | 2427659 | 2022-04-20 | Greensville | Virginia | 51081 | 3324 | 39 |
2424403 | 2424403 | 2022-04-19 | Greensville | Virginia | 51081 | 3323 | 39 |
2421147 | 2421147 | 2022-04-18 | Greensville | Virginia | 51081 | 3324 | 39 |
2417891 | 2417891 | 2022-04-17 | Greensville | Virginia | 51081 | 3328 | 39 |
2414635 | 2414635 | 2022-04-16 | Greensville | Virginia | 51081 | 3328 | 39 |
2411379 | 2411379 | 2022-04-15 | Greensville | Virginia | 51081 | 3328 | 39 |
2408123 | 2408123 | 2022-04-14 | Greensville | Virginia | 51081 | 3327 | 39 |
2404867 | 2404867 | 2022-04-13 | Greensville | Virginia | 51081 | 3327 | 39 |
2401612 | 2401612 | 2022-04-12 | Greensville | Virginia | 51081 | 3324 | 39 |
2398357 | 2398357 | 2022-04-11 | Greensville | Virginia | 51081 | 3322 | 38 |
2395102 | 2395102 | 2022-04-10 | Greensville | Virginia | 51081 | 3318 | 37 |
2391846 | 2391846 | 2022-04-09 | Greensville | Virginia | 51081 | 3318 | 37 |
2388590 | 2388590 | 2022-04-08 | Greensville | Virginia | 51081 | 3318 | 37 |
2385335 | 2385335 | 2022-04-07 | Greensville | Virginia | 51081 | 3318 | 37 |
2382080 | 2382080 | 2022-04-06 | Greensville | Virginia | 51081 | 3319 | 37 |
2378825 | 2378825 | 2022-04-05 | Greensville | Virginia | 51081 | 3322 | 37 |
2375571 | 2375571 | 2022-04-04 | Greensville | Virginia | 51081 | 3322 | 37 |
2372319 | 2372319 | 2022-04-03 | Greensville | Virginia | 51081 | 3315 | 37 |
2369066 | 2369066 | 2022-04-02 | Greensville | Virginia | 51081 | 3315 | 37 |
2365813 | 2365813 | 2022-04-01 | Greensville | Virginia | 51081 | 3315 | 37 |
2362560 | 2362560 | 2022-03-31 | Greensville | Virginia | 51081 | 3311 | 37 |
2359306 | 2359306 | 2022-03-30 | Greensville | Virginia | 51081 | 3310 | 37 |
2356052 | 2356052 | 2022-03-29 | Greensville | Virginia | 51081 | 3313 | 39 |
2352799 | 2352799 | 2022-03-28 | Greensville | Virginia | 51081 | 3313 | 39 |
2349547 | 2349547 | 2022-03-27 | Greensville | Virginia | 51081 | 3312 | 39 |
2346294 | 2346294 | 2022-03-26 | Greensville | Virginia | 51081 | 3312 | 39 |
2343041 | 2343041 | 2022-03-25 | Greensville | Virginia | 51081 | 3312 | 39 |
2339788 | 2339788 | 2022-03-24 | Greensville | Virginia | 51081 | 3313 | 39 |
2336534 | 2336534 | 2022-03-23 | Greensville | Virginia | 51081 | 3315 | 39 |
2333280 | 2333280 | 2022-03-22 | Greensville | Virginia | 51081 | 3311 | 37 |
2330027 | 2330027 | 2022-03-21 | Greensville | Virginia | 51081 | 3311 | 37 |
2326775 | 2326775 | 2022-03-20 | Greensville | Virginia | 51081 | 3312 | 37 |
2323522 | 2323522 | 2022-03-19 | Greensville | Virginia | 51081 | 3312 | 37 |
2320268 | 2320268 | 2022-03-18 | Greensville | Virginia | 51081 | 3312 | 37 |
2317014 | 2317014 | 2022-03-17 | Greensville | Virginia | 51081 | 3313 | 37 |
2313761 | 2313761 | 2022-03-16 | Greensville | Virginia | 51081 | 3313 | 37 |
2310508 | 2310508 | 2022-03-15 | Greensville | Virginia | 51081 | 3313 | 37 |
2307255 | 2307255 | 2022-03-14 | Greensville | Virginia | 51081 | 3313 | 37 |
2304004 | 2304004 | 2022-03-13 | Greensville | Virginia | 51081 | 3310 | 37 |
2300752 | 2300752 | 2022-03-12 | Greensville | Virginia | 51081 | 3310 | 37 |
2297500 | 2297500 | 2022-03-11 | Greensville | Virginia | 51081 | 3310 | 37 |
2294248 | 2294248 | 2022-03-10 | Greensville | Virginia | 51081 | 3309 | 37 |
2290996 | 2290996 | 2022-03-09 | Greensville | Virginia | 51081 | 3304 | 37 |
2287744 | 2287744 | 2022-03-08 | Greensville | Virginia | 51081 | 3303 | 37 |
2284492 | 2284492 | 2022-03-07 | Greensville | Virginia | 51081 | 3300 | 38 |
2281240 | 2281240 | 2022-03-06 | Greensville | Virginia | 51081 | 3300 | 38 |
2277987 | 2277987 | 2022-03-05 | Greensville | Virginia | 51081 | 3300 | 38 |
2274734 | 2274734 | 2022-03-04 | Greensville | Virginia | 51081 | 3300 | 38 |
2271481 | 2271481 | 2022-03-03 | Greensville | Virginia | 51081 | 3298 | 37 |
2268229 | 2268229 | 2022-03-02 | Greensville | Virginia | 51081 | 3292 | 37 |
2264976 | 2264976 | 2022-03-01 | Greensville | Virginia | 51081 | 3288 | 36 |
2261726 | 2261726 | 2022-02-28 | Greensville | Virginia | 51081 | 3288 | 36 |
2258475 | 2258475 | 2022-02-27 | Greensville | Virginia | 51081 | 3281 | 35 |
2255224 | 2255224 | 2022-02-26 | Greensville | Virginia | 51081 | 3281 | 35 |
2251973 | 2251973 | 2022-02-25 | Greensville | Virginia | 51081 | 3281 | 35 |
2248722 | 2248722 | 2022-02-24 | Greensville | Virginia | 51081 | 3280 | 35 |
2245471 | 2245471 | 2022-02-23 | Greensville | Virginia | 51081 | 3279 | 33 |
2242220 | 2242220 | 2022-02-22 | Greensville | Virginia | 51081 | 3272 | 33 |
2238969 | 2238969 | 2022-02-21 | Greensville | Virginia | 51081 | 3271 | 33 |
2235718 | 2235718 | 2022-02-20 | Greensville | Virginia | 51081 | 3257 | 33 |
2232467 | 2232467 | 2022-02-19 | Greensville | Virginia | 51081 | 3257 | 33 |
2229216 | 2229216 | 2022-02-18 | Greensville | Virginia | 51081 | 3257 | 33 |
2225965 | 2225965 | 2022-02-17 | Greensville | Virginia | 51081 | 3254 | 33 |
2222714 | 2222714 | 2022-02-16 | Greensville | Virginia | 51081 | 3253 | 33 |
2219463 | 2219463 | 2022-02-15 | Greensville | Virginia | 51081 | 3250 | 33 |
2216213 | 2216213 | 2022-02-14 | Greensville | Virginia | 51081 | 3248 | 33 |
2212962 | 2212962 | 2022-02-13 | Greensville | Virginia | 51081 | 3242 | 33 |
2209709 | 2209709 | 2022-02-12 | Greensville | Virginia | 51081 | 3242 | 33 |
2206456 | 2206456 | 2022-02-11 | Greensville | Virginia | 51081 | 3242 | 33 |
2203203 | 2203203 | 2022-02-10 | Greensville | Virginia | 51081 | 3240 | 33 |
2199949 | 2199949 | 2022-02-09 | Greensville | Virginia | 51081 | 3234 | 32 |
2196695 | 2196695 | 2022-02-08 | Greensville | Virginia | 51081 | 3230 | 32 |
2193440 | 2193440 | 2022-02-07 | Greensville | Virginia | 51081 | 3229 | 31 |
2190187 | 2190187 | 2022-02-06 | Greensville | Virginia | 51081 | 3214 | 31 |
2186934 | 2186934 | 2022-02-05 | Greensville | Virginia | 51081 | 3214 | 31 |
2183681 | 2183681 | 2022-02-04 | Greensville | Virginia | 51081 | 3214 | 31 |
2180429 | 2180429 | 2022-02-03 | Greensville | Virginia | 51081 | 3204 | 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);