ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Appomattox", fips = 51011 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 |
---|---|---|---|---|---|---|---|
2502516 | 2502516 | 2022-05-13 | Appomattox | Virginia | 51011 | 3817 | 53 |
2499258 | 2499258 | 2022-05-12 | Appomattox | Virginia | 51011 | 3815 | 53 |
2496000 | 2496000 | 2022-05-11 | Appomattox | Virginia | 51011 | 3812 | 53 |
2492742 | 2492742 | 2022-05-10 | Appomattox | Virginia | 51011 | 3812 | 53 |
2489484 | 2489484 | 2022-05-09 | Appomattox | Virginia | 51011 | 3811 | 53 |
2486227 | 2486227 | 2022-05-08 | Appomattox | Virginia | 51011 | 3808 | 53 |
2482969 | 2482969 | 2022-05-07 | Appomattox | Virginia | 51011 | 3808 | 53 |
2479711 | 2479711 | 2022-05-06 | Appomattox | Virginia | 51011 | 3808 | 53 |
2476453 | 2476453 | 2022-05-05 | Appomattox | Virginia | 51011 | 3806 | 53 |
2473195 | 2473195 | 2022-05-04 | Appomattox | Virginia | 51011 | 3805 | 53 |
2469939 | 2469939 | 2022-05-03 | Appomattox | Virginia | 51011 | 3801 | 53 |
2466683 | 2466683 | 2022-05-02 | Appomattox | Virginia | 51011 | 3801 | 53 |
2463428 | 2463428 | 2022-05-01 | Appomattox | Virginia | 51011 | 3799 | 53 |
2460172 | 2460172 | 2022-04-30 | Appomattox | Virginia | 51011 | 3799 | 53 |
2456916 | 2456916 | 2022-04-29 | Appomattox | Virginia | 51011 | 3799 | 53 |
2453660 | 2453660 | 2022-04-28 | Appomattox | Virginia | 51011 | 3796 | 53 |
2450404 | 2450404 | 2022-04-27 | Appomattox | Virginia | 51011 | 3795 | 52 |
2447147 | 2447147 | 2022-04-26 | Appomattox | Virginia | 51011 | 3794 | 52 |
2443892 | 2443892 | 2022-04-25 | Appomattox | Virginia | 51011 | 3794 | 52 |
2440636 | 2440636 | 2022-04-24 | Appomattox | Virginia | 51011 | 3794 | 52 |
2437380 | 2437380 | 2022-04-23 | Appomattox | Virginia | 51011 | 3794 | 52 |
2434124 | 2434124 | 2022-04-22 | Appomattox | Virginia | 51011 | 3794 | 52 |
2430868 | 2430868 | 2022-04-21 | Appomattox | Virginia | 51011 | 3791 | 52 |
2427612 | 2427612 | 2022-04-20 | Appomattox | Virginia | 51011 | 3789 | 52 |
2424356 | 2424356 | 2022-04-19 | Appomattox | Virginia | 51011 | 3784 | 52 |
2421100 | 2421100 | 2022-04-18 | Appomattox | Virginia | 51011 | 3784 | 52 |
2417844 | 2417844 | 2022-04-17 | Appomattox | Virginia | 51011 | 3783 | 52 |
2414588 | 2414588 | 2022-04-16 | Appomattox | Virginia | 51011 | 3783 | 52 |
2411332 | 2411332 | 2022-04-15 | Appomattox | Virginia | 51011 | 3783 | 52 |
2408076 | 2408076 | 2022-04-14 | Appomattox | Virginia | 51011 | 3780 | 52 |
2404820 | 2404820 | 2022-04-13 | Appomattox | Virginia | 51011 | 3776 | 52 |
2401565 | 2401565 | 2022-04-12 | Appomattox | Virginia | 51011 | 3776 | 52 |
2398310 | 2398310 | 2022-04-11 | Appomattox | Virginia | 51011 | 3776 | 52 |
2395055 | 2395055 | 2022-04-10 | Appomattox | Virginia | 51011 | 3773 | 52 |
2391799 | 2391799 | 2022-04-09 | Appomattox | Virginia | 51011 | 3773 | 52 |
2388543 | 2388543 | 2022-04-08 | Appomattox | Virginia | 51011 | 3773 | 52 |
2385288 | 2385288 | 2022-04-07 | Appomattox | Virginia | 51011 | 3771 | 52 |
2382033 | 2382033 | 2022-04-06 | Appomattox | Virginia | 51011 | 3769 | 52 |
2378778 | 2378778 | 2022-04-05 | Appomattox | Virginia | 51011 | 3769 | 52 |
2375524 | 2375524 | 2022-04-04 | Appomattox | Virginia | 51011 | 3764 | 52 |
2372272 | 2372272 | 2022-04-03 | Appomattox | Virginia | 51011 | 3760 | 52 |
2369019 | 2369019 | 2022-04-02 | Appomattox | Virginia | 51011 | 3760 | 52 |
2365766 | 2365766 | 2022-04-01 | Appomattox | Virginia | 51011 | 3760 | 52 |
2362513 | 2362513 | 2022-03-31 | Appomattox | Virginia | 51011 | 3760 | 52 |
2359259 | 2359259 | 2022-03-30 | Appomattox | Virginia | 51011 | 3760 | 52 |
2356005 | 2356005 | 2022-03-29 | Appomattox | Virginia | 51011 | 3759 | 52 |
2352752 | 2352752 | 2022-03-28 | Appomattox | Virginia | 51011 | 3756 | 52 |
2349500 | 2349500 | 2022-03-27 | Appomattox | Virginia | 51011 | 3751 | 52 |
2346247 | 2346247 | 2022-03-26 | Appomattox | Virginia | 51011 | 3751 | 52 |
2342994 | 2342994 | 2022-03-25 | Appomattox | Virginia | 51011 | 3751 | 52 |
2339741 | 2339741 | 2022-03-24 | Appomattox | Virginia | 51011 | 3747 | 51 |
2336487 | 2336487 | 2022-03-23 | Appomattox | Virginia | 51011 | 3741 | 51 |
2333233 | 2333233 | 2022-03-22 | Appomattox | Virginia | 51011 | 3738 | 51 |
2329980 | 2329980 | 2022-03-21 | Appomattox | Virginia | 51011 | 3738 | 51 |
2326728 | 2326728 | 2022-03-20 | Appomattox | Virginia | 51011 | 3729 | 51 |
2323475 | 2323475 | 2022-03-19 | Appomattox | Virginia | 51011 | 3729 | 51 |
2320221 | 2320221 | 2022-03-18 | Appomattox | Virginia | 51011 | 3729 | 51 |
2316967 | 2316967 | 2022-03-17 | Appomattox | Virginia | 51011 | 3726 | 51 |
2313714 | 2313714 | 2022-03-16 | Appomattox | Virginia | 51011 | 3718 | 51 |
2310461 | 2310461 | 2022-03-15 | Appomattox | Virginia | 51011 | 3716 | 51 |
2307208 | 2307208 | 2022-03-14 | Appomattox | Virginia | 51011 | 3710 | 51 |
2303957 | 2303957 | 2022-03-13 | Appomattox | Virginia | 51011 | 3702 | 51 |
2300705 | 2300705 | 2022-03-12 | Appomattox | Virginia | 51011 | 3702 | 51 |
2297453 | 2297453 | 2022-03-11 | Appomattox | Virginia | 51011 | 3702 | 51 |
2294201 | 2294201 | 2022-03-10 | Appomattox | Virginia | 51011 | 3697 | 51 |
2290949 | 2290949 | 2022-03-09 | Appomattox | Virginia | 51011 | 3693 | 51 |
2287697 | 2287697 | 2022-03-08 | Appomattox | Virginia | 51011 | 3686 | 51 |
2284445 | 2284445 | 2022-03-07 | Appomattox | Virginia | 51011 | 3685 | 51 |
2281193 | 2281193 | 2022-03-06 | Appomattox | Virginia | 51011 | 3672 | 50 |
2277940 | 2277940 | 2022-03-05 | Appomattox | Virginia | 51011 | 3672 | 50 |
2274687 | 2274687 | 2022-03-04 | Appomattox | Virginia | 51011 | 3672 | 50 |
2271434 | 2271434 | 2022-03-03 | Appomattox | Virginia | 51011 | 3662 | 50 |
2268182 | 2268182 | 2022-03-02 | Appomattox | Virginia | 51011 | 3659 | 50 |
2264929 | 2264929 | 2022-03-01 | Appomattox | Virginia | 51011 | 3642 | 50 |
2261679 | 2261679 | 2022-02-28 | Appomattox | Virginia | 51011 | 3643 | 51 |
2258428 | 2258428 | 2022-02-27 | Appomattox | Virginia | 51011 | 3633 | 51 |
2255177 | 2255177 | 2022-02-26 | Appomattox | Virginia | 51011 | 3633 | 51 |
2251926 | 2251926 | 2022-02-25 | Appomattox | Virginia | 51011 | 3633 | 51 |
2248675 | 2248675 | 2022-02-24 | Appomattox | Virginia | 51011 | 3627 | 51 |
2245424 | 2245424 | 2022-02-23 | Appomattox | Virginia | 51011 | 3613 | 51 |
2242173 | 2242173 | 2022-02-22 | Appomattox | Virginia | 51011 | 3608 | 50 |
2238922 | 2238922 | 2022-02-21 | Appomattox | Virginia | 51011 | 3600 | 50 |
2235671 | 2235671 | 2022-02-20 | Appomattox | Virginia | 51011 | 3583 | 50 |
2232420 | 2232420 | 2022-02-19 | Appomattox | Virginia | 51011 | 3583 | 50 |
2229169 | 2229169 | 2022-02-18 | Appomattox | Virginia | 51011 | 3583 | 50 |
2225918 | 2225918 | 2022-02-17 | Appomattox | Virginia | 51011 | 3573 | 50 |
2222667 | 2222667 | 2022-02-16 | Appomattox | Virginia | 51011 | 3565 | 49 |
2219416 | 2219416 | 2022-02-15 | Appomattox | Virginia | 51011 | 3554 | 48 |
2216166 | 2216166 | 2022-02-14 | Appomattox | Virginia | 51011 | 3547 | 48 |
2212915 | 2212915 | 2022-02-13 | Appomattox | Virginia | 51011 | 3528 | 48 |
2209662 | 2209662 | 2022-02-12 | Appomattox | Virginia | 51011 | 3528 | 48 |
2206409 | 2206409 | 2022-02-11 | Appomattox | Virginia | 51011 | 3528 | 48 |
2203156 | 2203156 | 2022-02-10 | Appomattox | Virginia | 51011 | 3507 | 48 |
2199902 | 2199902 | 2022-02-09 | Appomattox | Virginia | 51011 | 3483 | 48 |
2196648 | 2196648 | 2022-02-08 | Appomattox | Virginia | 51011 | 3466 | 47 |
2193393 | 2193393 | 2022-02-07 | Appomattox | Virginia | 51011 | 3445 | 47 |
2190140 | 2190140 | 2022-02-06 | Appomattox | Virginia | 51011 | 3407 | 45 |
2186887 | 2186887 | 2022-02-05 | Appomattox | Virginia | 51011 | 3407 | 45 |
2183634 | 2183634 | 2022-02-04 | Appomattox | Virginia | 51011 | 3407 | 45 |
2180382 | 2180382 | 2022-02-03 | Appomattox | Virginia | 51011 | 3386 | 44 |
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);