ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Amelia" 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 |
---|---|---|---|---|---|---|---|
2502514 | 2502514 | 2022-05-13 | Amelia | Virginia | 51007 | 2683 | 61 |
2499256 | 2499256 | 2022-05-12 | Amelia | Virginia | 51007 | 2680 | 60 |
2495998 | 2495998 | 2022-05-11 | Amelia | Virginia | 51007 | 2679 | 60 |
2492740 | 2492740 | 2022-05-10 | Amelia | Virginia | 51007 | 2674 | 60 |
2489482 | 2489482 | 2022-05-09 | Amelia | Virginia | 51007 | 2672 | 60 |
2486225 | 2486225 | 2022-05-08 | Amelia | Virginia | 51007 | 2666 | 60 |
2482967 | 2482967 | 2022-05-07 | Amelia | Virginia | 51007 | 2666 | 60 |
2479709 | 2479709 | 2022-05-06 | Amelia | Virginia | 51007 | 2666 | 60 |
2476451 | 2476451 | 2022-05-05 | Amelia | Virginia | 51007 | 2662 | 60 |
2473193 | 2473193 | 2022-05-04 | Amelia | Virginia | 51007 | 2657 | 60 |
2469937 | 2469937 | 2022-05-03 | Amelia | Virginia | 51007 | 2653 | 60 |
2466681 | 2466681 | 2022-05-02 | Amelia | Virginia | 51007 | 2651 | 60 |
2463426 | 2463426 | 2022-05-01 | Amelia | Virginia | 51007 | 2651 | 60 |
2460170 | 2460170 | 2022-04-30 | Amelia | Virginia | 51007 | 2651 | 60 |
2456914 | 2456914 | 2022-04-29 | Amelia | Virginia | 51007 | 2651 | 60 |
2453658 | 2453658 | 2022-04-28 | Amelia | Virginia | 51007 | 2650 | 60 |
2450402 | 2450402 | 2022-04-27 | Amelia | Virginia | 51007 | 2650 | 60 |
2447145 | 2447145 | 2022-04-26 | Amelia | Virginia | 51007 | 2646 | 60 |
2443890 | 2443890 | 2022-04-25 | Amelia | Virginia | 51007 | 2644 | 60 |
2440634 | 2440634 | 2022-04-24 | Amelia | Virginia | 51007 | 2642 | 60 |
2437378 | 2437378 | 2022-04-23 | Amelia | Virginia | 51007 | 2642 | 60 |
2434122 | 2434122 | 2022-04-22 | Amelia | Virginia | 51007 | 2642 | 60 |
2430866 | 2430866 | 2022-04-21 | Amelia | Virginia | 51007 | 2641 | 60 |
2427610 | 2427610 | 2022-04-20 | Amelia | Virginia | 51007 | 2640 | 60 |
2424354 | 2424354 | 2022-04-19 | Amelia | Virginia | 51007 | 2639 | 60 |
2421098 | 2421098 | 2022-04-18 | Amelia | Virginia | 51007 | 2638 | 60 |
2417842 | 2417842 | 2022-04-17 | Amelia | Virginia | 51007 | 2637 | 60 |
2414586 | 2414586 | 2022-04-16 | Amelia | Virginia | 51007 | 2637 | 60 |
2411330 | 2411330 | 2022-04-15 | Amelia | Virginia | 51007 | 2637 | 60 |
2408074 | 2408074 | 2022-04-14 | Amelia | Virginia | 51007 | 2634 | 60 |
2404818 | 2404818 | 2022-04-13 | Amelia | Virginia | 51007 | 2634 | 60 |
2401563 | 2401563 | 2022-04-12 | Amelia | Virginia | 51007 | 2629 | 60 |
2398308 | 2398308 | 2022-04-11 | Amelia | Virginia | 51007 | 2619 | 60 |
2395053 | 2395053 | 2022-04-10 | Amelia | Virginia | 51007 | 2616 | 61 |
2391797 | 2391797 | 2022-04-09 | Amelia | Virginia | 51007 | 2616 | 61 |
2388541 | 2388541 | 2022-04-08 | Amelia | Virginia | 51007 | 2616 | 61 |
2385286 | 2385286 | 2022-04-07 | Amelia | Virginia | 51007 | 2615 | 61 |
2382031 | 2382031 | 2022-04-06 | Amelia | Virginia | 51007 | 2615 | 61 |
2378776 | 2378776 | 2022-04-05 | Amelia | Virginia | 51007 | 2612 | 61 |
2375522 | 2375522 | 2022-04-04 | Amelia | Virginia | 51007 | 2613 | 61 |
2372270 | 2372270 | 2022-04-03 | Amelia | Virginia | 51007 | 2612 | 61 |
2369017 | 2369017 | 2022-04-02 | Amelia | Virginia | 51007 | 2612 | 61 |
2365764 | 2365764 | 2022-04-01 | Amelia | Virginia | 51007 | 2612 | 61 |
2362511 | 2362511 | 2022-03-31 | Amelia | Virginia | 51007 | 2611 | 61 |
2359257 | 2359257 | 2022-03-30 | Amelia | Virginia | 51007 | 2609 | 60 |
2356003 | 2356003 | 2022-03-29 | Amelia | Virginia | 51007 | 2605 | 60 |
2352750 | 2352750 | 2022-03-28 | Amelia | Virginia | 51007 | 2604 | 60 |
2349498 | 2349498 | 2022-03-27 | Amelia | Virginia | 51007 | 2605 | 60 |
2346245 | 2346245 | 2022-03-26 | Amelia | Virginia | 51007 | 2605 | 60 |
2342992 | 2342992 | 2022-03-25 | Amelia | Virginia | 51007 | 2605 | 60 |
2339739 | 2339739 | 2022-03-24 | Amelia | Virginia | 51007 | 2605 | 60 |
2336485 | 2336485 | 2022-03-23 | Amelia | Virginia | 51007 | 2602 | 60 |
2333231 | 2333231 | 2022-03-22 | Amelia | Virginia | 51007 | 2601 | 60 |
2329978 | 2329978 | 2022-03-21 | Amelia | Virginia | 51007 | 2601 | 60 |
2326726 | 2326726 | 2022-03-20 | Amelia | Virginia | 51007 | 2595 | 60 |
2323473 | 2323473 | 2022-03-19 | Amelia | Virginia | 51007 | 2595 | 60 |
2320219 | 2320219 | 2022-03-18 | Amelia | Virginia | 51007 | 2595 | 60 |
2316965 | 2316965 | 2022-03-17 | Amelia | Virginia | 51007 | 2595 | 60 |
2313712 | 2313712 | 2022-03-16 | Amelia | Virginia | 51007 | 2595 | 59 |
2310459 | 2310459 | 2022-03-15 | Amelia | Virginia | 51007 | 2595 | 59 |
2307206 | 2307206 | 2022-03-14 | Amelia | Virginia | 51007 | 2586 | 59 |
2303955 | 2303955 | 2022-03-13 | Amelia | Virginia | 51007 | 2587 | 59 |
2300703 | 2300703 | 2022-03-12 | Amelia | Virginia | 51007 | 2587 | 59 |
2297451 | 2297451 | 2022-03-11 | Amelia | Virginia | 51007 | 2587 | 59 |
2294199 | 2294199 | 2022-03-10 | Amelia | Virginia | 51007 | 2585 | 58 |
2290947 | 2290947 | 2022-03-09 | Amelia | Virginia | 51007 | 2583 | 58 |
2287695 | 2287695 | 2022-03-08 | Amelia | Virginia | 51007 | 2583 | 58 |
2284443 | 2284443 | 2022-03-07 | Amelia | Virginia | 51007 | 2581 | 58 |
2281191 | 2281191 | 2022-03-06 | Amelia | Virginia | 51007 | 2577 | 58 |
2277938 | 2277938 | 2022-03-05 | Amelia | Virginia | 51007 | 2577 | 58 |
2274685 | 2274685 | 2022-03-04 | Amelia | Virginia | 51007 | 2577 | 58 |
2271432 | 2271432 | 2022-03-03 | Amelia | Virginia | 51007 | 2576 | 57 |
2268180 | 2268180 | 2022-03-02 | Amelia | Virginia | 51007 | 2572 | 57 |
2264927 | 2264927 | 2022-03-01 | Amelia | Virginia | 51007 | 2571 | 57 |
2261677 | 2261677 | 2022-02-28 | Amelia | Virginia | 51007 | 2570 | 57 |
2258426 | 2258426 | 2022-02-27 | Amelia | Virginia | 51007 | 2569 | 57 |
2255175 | 2255175 | 2022-02-26 | Amelia | Virginia | 51007 | 2569 | 57 |
2251924 | 2251924 | 2022-02-25 | Amelia | Virginia | 51007 | 2569 | 57 |
2248673 | 2248673 | 2022-02-24 | Amelia | Virginia | 51007 | 2568 | 57 |
2245422 | 2245422 | 2022-02-23 | Amelia | Virginia | 51007 | 2569 | 54 |
2242171 | 2242171 | 2022-02-22 | Amelia | Virginia | 51007 | 2562 | 53 |
2238920 | 2238920 | 2022-02-21 | Amelia | Virginia | 51007 | 2558 | 53 |
2235669 | 2235669 | 2022-02-20 | Amelia | Virginia | 51007 | 2552 | 53 |
2232418 | 2232418 | 2022-02-19 | Amelia | Virginia | 51007 | 2552 | 53 |
2229167 | 2229167 | 2022-02-18 | Amelia | Virginia | 51007 | 2552 | 53 |
2225916 | 2225916 | 2022-02-17 | Amelia | Virginia | 51007 | 2549 | 52 |
2222665 | 2222665 | 2022-02-16 | Amelia | Virginia | 51007 | 2545 | 52 |
2219414 | 2219414 | 2022-02-15 | Amelia | Virginia | 51007 | 2541 | 52 |
2216164 | 2216164 | 2022-02-14 | Amelia | Virginia | 51007 | 2534 | 52 |
2212913 | 2212913 | 2022-02-13 | Amelia | Virginia | 51007 | 2518 | 51 |
2209660 | 2209660 | 2022-02-12 | Amelia | Virginia | 51007 | 2518 | 51 |
2206407 | 2206407 | 2022-02-11 | Amelia | Virginia | 51007 | 2518 | 51 |
2203154 | 2203154 | 2022-02-10 | Amelia | Virginia | 51007 | 2514 | 51 |
2199900 | 2199900 | 2022-02-09 | Amelia | Virginia | 51007 | 2505 | 51 |
2196646 | 2196646 | 2022-02-08 | Amelia | Virginia | 51007 | 2497 | 51 |
2193391 | 2193391 | 2022-02-07 | Amelia | Virginia | 51007 | 2472 | 51 |
2190138 | 2190138 | 2022-02-06 | Amelia | Virginia | 51007 | 2455 | 50 |
2186885 | 2186885 | 2022-02-05 | Amelia | Virginia | 51007 | 2455 | 50 |
2183632 | 2183632 | 2022-02-04 | Amelia | Virginia | 51007 | 2455 | 50 |
2180380 | 2180380 | 2022-02-03 | Amelia | Virginia | 51007 | 2445 | 49 |
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);