ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
694 rows where fips = 51021 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502521 | 2502521 | 2022-05-13 | Bland | Virginia | 51021 | 1800 | 24 |
2499263 | 2499263 | 2022-05-12 | Bland | Virginia | 51021 | 1798 | 24 |
2496005 | 2496005 | 2022-05-11 | Bland | Virginia | 51021 | 1798 | 24 |
2492747 | 2492747 | 2022-05-10 | Bland | Virginia | 51021 | 1797 | 24 |
2489489 | 2489489 | 2022-05-09 | Bland | Virginia | 51021 | 1797 | 24 |
2486232 | 2486232 | 2022-05-08 | Bland | Virginia | 51021 | 1793 | 24 |
2482974 | 2482974 | 2022-05-07 | Bland | Virginia | 51021 | 1793 | 24 |
2479716 | 2479716 | 2022-05-06 | Bland | Virginia | 51021 | 1793 | 24 |
2476458 | 2476458 | 2022-05-05 | Bland | Virginia | 51021 | 1791 | 24 |
2473200 | 2473200 | 2022-05-04 | Bland | Virginia | 51021 | 1792 | 24 |
2469944 | 2469944 | 2022-05-03 | Bland | Virginia | 51021 | 1787 | 23 |
2466688 | 2466688 | 2022-05-02 | Bland | Virginia | 51021 | 1784 | 23 |
2463433 | 2463433 | 2022-05-01 | Bland | Virginia | 51021 | 1783 | 23 |
2460177 | 2460177 | 2022-04-30 | Bland | Virginia | 51021 | 1783 | 23 |
2456921 | 2456921 | 2022-04-29 | Bland | Virginia | 51021 | 1783 | 23 |
2453665 | 2453665 | 2022-04-28 | Bland | Virginia | 51021 | 1784 | 23 |
2450409 | 2450409 | 2022-04-27 | Bland | Virginia | 51021 | 1783 | 23 |
2447152 | 2447152 | 2022-04-26 | Bland | Virginia | 51021 | 1782 | 23 |
2443897 | 2443897 | 2022-04-25 | Bland | Virginia | 51021 | 1782 | 23 |
2440641 | 2440641 | 2022-04-24 | Bland | Virginia | 51021 | 1779 | 23 |
2437385 | 2437385 | 2022-04-23 | Bland | Virginia | 51021 | 1779 | 23 |
2434129 | 2434129 | 2022-04-22 | Bland | Virginia | 51021 | 1779 | 23 |
2430873 | 2430873 | 2022-04-21 | Bland | Virginia | 51021 | 1777 | 23 |
2427617 | 2427617 | 2022-04-20 | Bland | Virginia | 51021 | 1776 | 22 |
2424361 | 2424361 | 2022-04-19 | Bland | Virginia | 51021 | 1776 | 22 |
2421105 | 2421105 | 2022-04-18 | Bland | Virginia | 51021 | 1774 | 22 |
2417849 | 2417849 | 2022-04-17 | Bland | Virginia | 51021 | 1773 | 22 |
2414593 | 2414593 | 2022-04-16 | Bland | Virginia | 51021 | 1773 | 22 |
2411337 | 2411337 | 2022-04-15 | Bland | Virginia | 51021 | 1773 | 22 |
2408081 | 2408081 | 2022-04-14 | Bland | Virginia | 51021 | 1768 | 21 |
2404825 | 2404825 | 2022-04-13 | Bland | Virginia | 51021 | 1766 | 21 |
2401570 | 2401570 | 2022-04-12 | Bland | Virginia | 51021 | 1766 | 21 |
2398315 | 2398315 | 2022-04-11 | Bland | Virginia | 51021 | 1763 | 21 |
2395060 | 2395060 | 2022-04-10 | Bland | Virginia | 51021 | 1760 | 21 |
2391804 | 2391804 | 2022-04-09 | Bland | Virginia | 51021 | 1760 | 21 |
2388548 | 2388548 | 2022-04-08 | Bland | Virginia | 51021 | 1760 | 21 |
2385293 | 2385293 | 2022-04-07 | Bland | Virginia | 51021 | 1761 | 21 |
2382038 | 2382038 | 2022-04-06 | Bland | Virginia | 51021 | 1760 | 21 |
2378783 | 2378783 | 2022-04-05 | Bland | Virginia | 51021 | 1759 | 21 |
2375529 | 2375529 | 2022-04-04 | Bland | Virginia | 51021 | 1758 | 21 |
2372277 | 2372277 | 2022-04-03 | Bland | Virginia | 51021 | 1757 | 21 |
2369024 | 2369024 | 2022-04-02 | Bland | Virginia | 51021 | 1757 | 21 |
2365771 | 2365771 | 2022-04-01 | Bland | Virginia | 51021 | 1757 | 21 |
2362518 | 2362518 | 2022-03-31 | Bland | Virginia | 51021 | 1757 | 21 |
2359264 | 2359264 | 2022-03-30 | Bland | Virginia | 51021 | 1757 | 21 |
2356010 | 2356010 | 2022-03-29 | Bland | Virginia | 51021 | 1756 | 21 |
2352757 | 2352757 | 2022-03-28 | Bland | Virginia | 51021 | 1756 | 21 |
2349505 | 2349505 | 2022-03-27 | Bland | Virginia | 51021 | 1756 | 21 |
2346252 | 2346252 | 2022-03-26 | Bland | Virginia | 51021 | 1756 | 21 |
2342999 | 2342999 | 2022-03-25 | Bland | Virginia | 51021 | 1756 | 21 |
2339746 | 2339746 | 2022-03-24 | Bland | Virginia | 51021 | 1755 | 21 |
2336492 | 2336492 | 2022-03-23 | Bland | Virginia | 51021 | 1755 | 21 |
2333238 | 2333238 | 2022-03-22 | Bland | Virginia | 51021 | 1754 | 21 |
2329985 | 2329985 | 2022-03-21 | Bland | Virginia | 51021 | 1754 | 21 |
2326733 | 2326733 | 2022-03-20 | Bland | Virginia | 51021 | 1754 | 21 |
2323480 | 2323480 | 2022-03-19 | Bland | Virginia | 51021 | 1754 | 21 |
2320226 | 2320226 | 2022-03-18 | Bland | Virginia | 51021 | 1754 | 21 |
2316972 | 2316972 | 2022-03-17 | Bland | Virginia | 51021 | 1754 | 21 |
2313719 | 2313719 | 2022-03-16 | Bland | Virginia | 51021 | 1754 | 21 |
2310466 | 2310466 | 2022-03-15 | Bland | Virginia | 51021 | 1753 | 20 |
2307213 | 2307213 | 2022-03-14 | Bland | Virginia | 51021 | 1751 | 20 |
2303962 | 2303962 | 2022-03-13 | Bland | Virginia | 51021 | 1750 | 20 |
2300710 | 2300710 | 2022-03-12 | Bland | Virginia | 51021 | 1750 | 20 |
2297458 | 2297458 | 2022-03-11 | Bland | Virginia | 51021 | 1750 | 20 |
2294206 | 2294206 | 2022-03-10 | Bland | Virginia | 51021 | 1750 | 20 |
2290954 | 2290954 | 2022-03-09 | Bland | Virginia | 51021 | 1746 | 20 |
2287702 | 2287702 | 2022-03-08 | Bland | Virginia | 51021 | 1746 | 20 |
2284450 | 2284450 | 2022-03-07 | Bland | Virginia | 51021 | 1746 | 20 |
2281198 | 2281198 | 2022-03-06 | Bland | Virginia | 51021 | 1745 | 20 |
2277945 | 2277945 | 2022-03-05 | Bland | Virginia | 51021 | 1745 | 20 |
2274692 | 2274692 | 2022-03-04 | Bland | Virginia | 51021 | 1745 | 20 |
2271439 | 2271439 | 2022-03-03 | Bland | Virginia | 51021 | 1745 | 20 |
2268187 | 2268187 | 2022-03-02 | Bland | Virginia | 51021 | 1744 | 20 |
2264934 | 2264934 | 2022-03-01 | Bland | Virginia | 51021 | 1744 | 20 |
2261684 | 2261684 | 2022-02-28 | Bland | Virginia | 51021 | 1748 | 20 |
2258433 | 2258433 | 2022-02-27 | Bland | Virginia | 51021 | 1744 | 20 |
2255182 | 2255182 | 2022-02-26 | Bland | Virginia | 51021 | 1744 | 20 |
2251931 | 2251931 | 2022-02-25 | Bland | Virginia | 51021 | 1744 | 20 |
2248680 | 2248680 | 2022-02-24 | Bland | Virginia | 51021 | 1737 | 20 |
2245429 | 2245429 | 2022-02-23 | Bland | Virginia | 51021 | 1733 | 20 |
2242178 | 2242178 | 2022-02-22 | Bland | Virginia | 51021 | 1734 | 20 |
2238927 | 2238927 | 2022-02-21 | Bland | Virginia | 51021 | 1730 | 20 |
2235676 | 2235676 | 2022-02-20 | Bland | Virginia | 51021 | 1723 | 20 |
2232425 | 2232425 | 2022-02-19 | Bland | Virginia | 51021 | 1723 | 20 |
2229174 | 2229174 | 2022-02-18 | Bland | Virginia | 51021 | 1723 | 20 |
2225923 | 2225923 | 2022-02-17 | Bland | Virginia | 51021 | 1718 | 20 |
2222672 | 2222672 | 2022-02-16 | Bland | Virginia | 51021 | 1712 | 20 |
2219421 | 2219421 | 2022-02-15 | Bland | Virginia | 51021 | 1701 | 20 |
2216171 | 2216171 | 2022-02-14 | Bland | Virginia | 51021 | 1697 | 20 |
2212920 | 2212920 | 2022-02-13 | Bland | Virginia | 51021 | 1675 | 20 |
2209667 | 2209667 | 2022-02-12 | Bland | Virginia | 51021 | 1675 | 20 |
2206414 | 2206414 | 2022-02-11 | Bland | Virginia | 51021 | 1675 | 20 |
2203161 | 2203161 | 2022-02-10 | Bland | Virginia | 51021 | 1671 | 20 |
2199907 | 2199907 | 2022-02-09 | Bland | Virginia | 51021 | 1661 | 20 |
2196653 | 2196653 | 2022-02-08 | Bland | Virginia | 51021 | 1652 | 20 |
2193398 | 2193398 | 2022-02-07 | Bland | Virginia | 51021 | 1646 | 19 |
2190145 | 2190145 | 2022-02-06 | Bland | Virginia | 51021 | 1627 | 19 |
2186892 | 2186892 | 2022-02-05 | Bland | Virginia | 51021 | 1627 | 19 |
2183639 | 2183639 | 2022-02-04 | Bland | Virginia | 51021 | 1627 | 19 |
2180387 | 2180387 | 2022-02-03 | Bland | Virginia | 51021 | 1610 | 19 |
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);