ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
753 rows where fips = 51141 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 |
---|---|---|---|---|---|---|---|
2502602 | 2502602 | 2022-05-13 | Patrick | Virginia | 51141 | 3706 | 98 |
2499344 | 2499344 | 2022-05-12 | Patrick | Virginia | 51141 | 3702 | 98 |
2496086 | 2496086 | 2022-05-11 | Patrick | Virginia | 51141 | 3698 | 98 |
2492828 | 2492828 | 2022-05-10 | Patrick | Virginia | 51141 | 3697 | 98 |
2489570 | 2489570 | 2022-05-09 | Patrick | Virginia | 51141 | 3696 | 98 |
2486313 | 2486313 | 2022-05-08 | Patrick | Virginia | 51141 | 3690 | 98 |
2483055 | 2483055 | 2022-05-07 | Patrick | Virginia | 51141 | 3690 | 98 |
2479797 | 2479797 | 2022-05-06 | Patrick | Virginia | 51141 | 3690 | 98 |
2476539 | 2476539 | 2022-05-05 | Patrick | Virginia | 51141 | 3689 | 98 |
2473281 | 2473281 | 2022-05-04 | Patrick | Virginia | 51141 | 3682 | 98 |
2470025 | 2470025 | 2022-05-03 | Patrick | Virginia | 51141 | 3678 | 98 |
2466769 | 2466769 | 2022-05-02 | Patrick | Virginia | 51141 | 3677 | 98 |
2463514 | 2463514 | 2022-05-01 | Patrick | Virginia | 51141 | 3671 | 98 |
2460258 | 2460258 | 2022-04-30 | Patrick | Virginia | 51141 | 3671 | 98 |
2457002 | 2457002 | 2022-04-29 | Patrick | Virginia | 51141 | 3671 | 98 |
2453746 | 2453746 | 2022-04-28 | Patrick | Virginia | 51141 | 3669 | 97 |
2450490 | 2450490 | 2022-04-27 | Patrick | Virginia | 51141 | 3666 | 96 |
2447233 | 2447233 | 2022-04-26 | Patrick | Virginia | 51141 | 3660 | 95 |
2443978 | 2443978 | 2022-04-25 | Patrick | Virginia | 51141 | 3661 | 95 |
2440722 | 2440722 | 2022-04-24 | Patrick | Virginia | 51141 | 3644 | 94 |
2437466 | 2437466 | 2022-04-23 | Patrick | Virginia | 51141 | 3644 | 94 |
2434210 | 2434210 | 2022-04-22 | Patrick | Virginia | 51141 | 3644 | 94 |
2430954 | 2430954 | 2022-04-21 | Patrick | Virginia | 51141 | 3639 | 94 |
2427698 | 2427698 | 2022-04-20 | Patrick | Virginia | 51141 | 3636 | 94 |
2424442 | 2424442 | 2022-04-19 | Patrick | Virginia | 51141 | 3635 | 94 |
2421186 | 2421186 | 2022-04-18 | Patrick | Virginia | 51141 | 3634 | 94 |
2417930 | 2417930 | 2022-04-17 | Patrick | Virginia | 51141 | 3631 | 93 |
2414674 | 2414674 | 2022-04-16 | Patrick | Virginia | 51141 | 3631 | 93 |
2411418 | 2411418 | 2022-04-15 | Patrick | Virginia | 51141 | 3631 | 93 |
2408162 | 2408162 | 2022-04-14 | Patrick | Virginia | 51141 | 3629 | 93 |
2404906 | 2404906 | 2022-04-13 | Patrick | Virginia | 51141 | 3629 | 93 |
2401651 | 2401651 | 2022-04-12 | Patrick | Virginia | 51141 | 3628 | 93 |
2398396 | 2398396 | 2022-04-11 | Patrick | Virginia | 51141 | 3628 | 93 |
2395141 | 2395141 | 2022-04-10 | Patrick | Virginia | 51141 | 3627 | 93 |
2391885 | 2391885 | 2022-04-09 | Patrick | Virginia | 51141 | 3627 | 93 |
2388629 | 2388629 | 2022-04-08 | Patrick | Virginia | 51141 | 3627 | 93 |
2385374 | 2385374 | 2022-04-07 | Patrick | Virginia | 51141 | 3609 | 93 |
2382119 | 2382119 | 2022-04-06 | Patrick | Virginia | 51141 | 3604 | 93 |
2378864 | 2378864 | 2022-04-05 | Patrick | Virginia | 51141 | 3604 | 92 |
2375610 | 2375610 | 2022-04-04 | Patrick | Virginia | 51141 | 3604 | 92 |
2372358 | 2372358 | 2022-04-03 | Patrick | Virginia | 51141 | 3601 | 92 |
2369105 | 2369105 | 2022-04-02 | Patrick | Virginia | 51141 | 3601 | 92 |
2365852 | 2365852 | 2022-04-01 | Patrick | Virginia | 51141 | 3601 | 92 |
2362599 | 2362599 | 2022-03-31 | Patrick | Virginia | 51141 | 3601 | 92 |
2359345 | 2359345 | 2022-03-30 | Patrick | Virginia | 51141 | 3599 | 92 |
2356091 | 2356091 | 2022-03-29 | Patrick | Virginia | 51141 | 3597 | 92 |
2352838 | 2352838 | 2022-03-28 | Patrick | Virginia | 51141 | 3597 | 92 |
2349586 | 2349586 | 2022-03-27 | Patrick | Virginia | 51141 | 3598 | 91 |
2346333 | 2346333 | 2022-03-26 | Patrick | Virginia | 51141 | 3598 | 91 |
2343080 | 2343080 | 2022-03-25 | Patrick | Virginia | 51141 | 3598 | 91 |
2339827 | 2339827 | 2022-03-24 | Patrick | Virginia | 51141 | 3598 | 91 |
2336573 | 2336573 | 2022-03-23 | Patrick | Virginia | 51141 | 3596 | 91 |
2333319 | 2333319 | 2022-03-22 | Patrick | Virginia | 51141 | 3593 | 91 |
2330066 | 2330066 | 2022-03-21 | Patrick | Virginia | 51141 | 3593 | 91 |
2326814 | 2326814 | 2022-03-20 | Patrick | Virginia | 51141 | 3578 | 91 |
2323561 | 2323561 | 2022-03-19 | Patrick | Virginia | 51141 | 3578 | 91 |
2320307 | 2320307 | 2022-03-18 | Patrick | Virginia | 51141 | 3578 | 91 |
2317053 | 2317053 | 2022-03-17 | Patrick | Virginia | 51141 | 3570 | 91 |
2313800 | 2313800 | 2022-03-16 | Patrick | Virginia | 51141 | 3556 | 91 |
2310547 | 2310547 | 2022-03-15 | Patrick | Virginia | 51141 | 3551 | 90 |
2307294 | 2307294 | 2022-03-14 | Patrick | Virginia | 51141 | 3549 | 90 |
2304043 | 2304043 | 2022-03-13 | Patrick | Virginia | 51141 | 3548 | 89 |
2300791 | 2300791 | 2022-03-12 | Patrick | Virginia | 51141 | 3548 | 89 |
2297539 | 2297539 | 2022-03-11 | Patrick | Virginia | 51141 | 3548 | 89 |
2294287 | 2294287 | 2022-03-10 | Patrick | Virginia | 51141 | 3545 | 89 |
2291035 | 2291035 | 2022-03-09 | Patrick | Virginia | 51141 | 3543 | 89 |
2287783 | 2287783 | 2022-03-08 | Patrick | Virginia | 51141 | 3542 | 89 |
2284531 | 2284531 | 2022-03-07 | Patrick | Virginia | 51141 | 3542 | 88 |
2281279 | 2281279 | 2022-03-06 | Patrick | Virginia | 51141 | 3538 | 87 |
2278026 | 2278026 | 2022-03-05 | Patrick | Virginia | 51141 | 3538 | 87 |
2274773 | 2274773 | 2022-03-04 | Patrick | Virginia | 51141 | 3538 | 87 |
2271520 | 2271520 | 2022-03-03 | Patrick | Virginia | 51141 | 3533 | 86 |
2268268 | 2268268 | 2022-03-02 | Patrick | Virginia | 51141 | 3528 | 86 |
2265015 | 2265015 | 2022-03-01 | Patrick | Virginia | 51141 | 3524 | 86 |
2261765 | 2261765 | 2022-02-28 | Patrick | Virginia | 51141 | 3524 | 86 |
2258514 | 2258514 | 2022-02-27 | Patrick | Virginia | 51141 | 3510 | 85 |
2255263 | 2255263 | 2022-02-26 | Patrick | Virginia | 51141 | 3510 | 85 |
2252012 | 2252012 | 2022-02-25 | Patrick | Virginia | 51141 | 3510 | 85 |
2248761 | 2248761 | 2022-02-24 | Patrick | Virginia | 51141 | 3500 | 85 |
2245510 | 2245510 | 2022-02-23 | Patrick | Virginia | 51141 | 3490 | 85 |
2242259 | 2242259 | 2022-02-22 | Patrick | Virginia | 51141 | 3483 | 83 |
2239008 | 2239008 | 2022-02-21 | Patrick | Virginia | 51141 | 3477 | 83 |
2235757 | 2235757 | 2022-02-20 | Patrick | Virginia | 51141 | 3443 | 83 |
2232506 | 2232506 | 2022-02-19 | Patrick | Virginia | 51141 | 3443 | 83 |
2229255 | 2229255 | 2022-02-18 | Patrick | Virginia | 51141 | 3443 | 83 |
2226004 | 2226004 | 2022-02-17 | Patrick | Virginia | 51141 | 3438 | 83 |
2222753 | 2222753 | 2022-02-16 | Patrick | Virginia | 51141 | 3410 | 83 |
2219502 | 2219502 | 2022-02-15 | Patrick | Virginia | 51141 | 3395 | 82 |
2216252 | 2216252 | 2022-02-14 | Patrick | Virginia | 51141 | 3380 | 82 |
2213001 | 2213001 | 2022-02-13 | Patrick | Virginia | 51141 | 3343 | 81 |
2209748 | 2209748 | 2022-02-12 | Patrick | Virginia | 51141 | 3343 | 81 |
2206495 | 2206495 | 2022-02-11 | Patrick | Virginia | 51141 | 3343 | 81 |
2203242 | 2203242 | 2022-02-10 | Patrick | Virginia | 51141 | 3335 | 80 |
2199988 | 2199988 | 2022-02-09 | Patrick | Virginia | 51141 | 3328 | 80 |
2196734 | 2196734 | 2022-02-08 | Patrick | Virginia | 51141 | 3312 | 80 |
2193479 | 2193479 | 2022-02-07 | Patrick | Virginia | 51141 | 3299 | 80 |
2190226 | 2190226 | 2022-02-06 | Patrick | Virginia | 51141 | 3259 | 78 |
2186973 | 2186973 | 2022-02-05 | Patrick | Virginia | 51141 | 3259 | 78 |
2183720 | 2183720 | 2022-02-04 | Patrick | Virginia | 51141 | 3259 | 78 |
2180468 | 2180468 | 2022-02-03 | Patrick | Virginia | 51141 | 3239 | 77 |
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);