ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,932 rows where deaths = 5 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Surry 131
- Charles City 117
- Bland 80
- Caroline 78
- King William 76
- Craig 75
- Powhatan 65
- Richmond 61
- Hopewell city 54
- Brunswick 45
- Orange 44
- Fredericksburg city 42
- King George 38
- Lynchburg city 38
- Rappahannock 38
- Stafford 38
- Roanoke 36
- Highland 35
- Westmoreland 35
- Hampton city 34
- Montgomery 33
- Wise 29
- Prince George 28
- Amelia 27
- Greene 27
- New Kent 27
- Henry 25
- Charlotte 22
- Goochland 22
- Pulaski 22
- …
state 1
- Virginia · 1,932 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2258482 | 2258482 | 2022-02-27 | Highland | Virginia | 51091 | 356 | 5 |
2255231 | 2255231 | 2022-02-26 | Highland | Virginia | 51091 | 356 | 5 |
2251980 | 2251980 | 2022-02-25 | Highland | Virginia | 51091 | 356 | 5 |
2248729 | 2248729 | 2022-02-24 | Highland | Virginia | 51091 | 355 | 5 |
2245478 | 2245478 | 2022-02-23 | Highland | Virginia | 51091 | 351 | 5 |
2242227 | 2242227 | 2022-02-22 | Highland | Virginia | 51091 | 351 | 5 |
2238976 | 2238976 | 2022-02-21 | Highland | Virginia | 51091 | 350 | 5 |
2235725 | 2235725 | 2022-02-20 | Highland | Virginia | 51091 | 348 | 5 |
2232474 | 2232474 | 2022-02-19 | Highland | Virginia | 51091 | 348 | 5 |
2229223 | 2229223 | 2022-02-18 | Highland | Virginia | 51091 | 348 | 5 |
2225972 | 2225972 | 2022-02-17 | Highland | Virginia | 51091 | 347 | 5 |
2222721 | 2222721 | 2022-02-16 | Highland | Virginia | 51091 | 344 | 5 |
2219470 | 2219470 | 2022-02-15 | Highland | Virginia | 51091 | 341 | 5 |
2216220 | 2216220 | 2022-02-14 | Highland | Virginia | 51091 | 341 | 5 |
2212969 | 2212969 | 2022-02-13 | Highland | Virginia | 51091 | 341 | 5 |
2209716 | 2209716 | 2022-02-12 | Highland | Virginia | 51091 | 341 | 5 |
2206463 | 2206463 | 2022-02-11 | Highland | Virginia | 51091 | 341 | 5 |
2203210 | 2203210 | 2022-02-10 | Highland | Virginia | 51091 | 341 | 5 |
2199956 | 2199956 | 2022-02-09 | Highland | Virginia | 51091 | 341 | 5 |
2196702 | 2196702 | 2022-02-08 | Highland | Virginia | 51091 | 341 | 5 |
2193447 | 2193447 | 2022-02-07 | Highland | Virginia | 51091 | 341 | 5 |
2190194 | 2190194 | 2022-02-06 | Highland | Virginia | 51091 | 340 | 5 |
2186941 | 2186941 | 2022-02-05 | Highland | Virginia | 51091 | 340 | 5 |
2183688 | 2183688 | 2022-02-04 | Highland | Virginia | 51091 | 340 | 5 |
2180436 | 2180436 | 2022-02-03 | Highland | Virginia | 51091 | 337 | 5 |
2177185 | 2177185 | 2022-02-02 | Highland | Virginia | 51091 | 333 | 5 |
2173932 | 2173932 | 2022-02-01 | Highland | Virginia | 51091 | 330 | 5 |
2170680 | 2170680 | 2022-01-31 | Highland | Virginia | 51091 | 324 | 5 |
2167427 | 2167427 | 2022-01-30 | Highland | Virginia | 51091 | 319 | 5 |
2164172 | 2164172 | 2022-01-29 | Highland | Virginia | 51091 | 319 | 5 |
2160917 | 2160917 | 2022-01-28 | Highland | Virginia | 51091 | 319 | 5 |
2157661 | 2157661 | 2022-01-27 | Highland | Virginia | 51091 | 314 | 5 |
2154408 | 2154408 | 2022-01-26 | Highland | Virginia | 51091 | 309 | 5 |
2151155 | 2151155 | 2022-01-25 | Highland | Virginia | 51091 | 303 | 5 |
2147903 | 2147903 | 2022-01-24 | Highland | Virginia | 51091 | 299 | 5 |
2008138 | 2008138 | 2021-12-12 | Rappahannock | Virginia | 51157 | 654 | 5 |
2004887 | 2004887 | 2021-12-11 | Rappahannock | Virginia | 51157 | 654 | 5 |
2001636 | 2001636 | 2021-12-10 | Rappahannock | Virginia | 51157 | 654 | 5 |
1998386 | 1998386 | 2021-12-09 | Rappahannock | Virginia | 51157 | 649 | 5 |
1995135 | 1995135 | 2021-12-08 | Rappahannock | Virginia | 51157 | 646 | 5 |
1991884 | 1991884 | 2021-12-07 | Rappahannock | Virginia | 51157 | 645 | 5 |
1988633 | 1988633 | 2021-12-06 | Rappahannock | Virginia | 51157 | 644 | 5 |
1985383 | 1985383 | 2021-12-05 | Rappahannock | Virginia | 51157 | 639 | 5 |
1982133 | 1982133 | 2021-12-04 | Rappahannock | Virginia | 51157 | 639 | 5 |
1978883 | 1978883 | 2021-12-03 | Rappahannock | Virginia | 51157 | 639 | 5 |
1975633 | 1975633 | 2021-12-02 | Rappahannock | Virginia | 51157 | 638 | 5 |
1972384 | 1972384 | 2021-12-01 | Rappahannock | Virginia | 51157 | 636 | 5 |
1969134 | 1969134 | 2021-11-30 | Rappahannock | Virginia | 51157 | 635 | 5 |
1965884 | 1965884 | 2021-11-29 | Rappahannock | Virginia | 51157 | 634 | 5 |
1962632 | 1962632 | 2021-11-28 | Rappahannock | Virginia | 51157 | 627 | 5 |
1959381 | 1959381 | 2021-11-27 | Rappahannock | Virginia | 51157 | 627 | 5 |
1956130 | 1956130 | 2021-11-26 | Rappahannock | Virginia | 51157 | 627 | 5 |
1952879 | 1952879 | 2021-11-25 | Rappahannock | Virginia | 51157 | 627 | 5 |
1949628 | 1949628 | 2021-11-24 | Rappahannock | Virginia | 51157 | 626 | 5 |
1946377 | 1946377 | 2021-11-23 | Rappahannock | Virginia | 51157 | 622 | 5 |
1943126 | 1943126 | 2021-11-22 | Rappahannock | Virginia | 51157 | 620 | 5 |
1939876 | 1939876 | 2021-11-21 | Rappahannock | Virginia | 51157 | 616 | 5 |
1936626 | 1936626 | 2021-11-20 | Rappahannock | Virginia | 51157 | 616 | 5 |
1933376 | 1933376 | 2021-11-19 | Rappahannock | Virginia | 51157 | 616 | 5 |
1930124 | 1930124 | 2021-11-18 | Rappahannock | Virginia | 51157 | 615 | 5 |
1926874 | 1926874 | 2021-11-17 | Rappahannock | Virginia | 51157 | 611 | 5 |
1923624 | 1923624 | 2021-11-16 | Rappahannock | Virginia | 51157 | 608 | 5 |
1920375 | 1920375 | 2021-11-15 | Rappahannock | Virginia | 51157 | 605 | 5 |
1917125 | 1917125 | 2021-11-14 | Rappahannock | Virginia | 51157 | 604 | 5 |
1913875 | 1913875 | 2021-11-13 | Rappahannock | Virginia | 51157 | 604 | 5 |
1910625 | 1910625 | 2021-11-12 | Rappahannock | Virginia | 51157 | 604 | 5 |
1907376 | 1907376 | 2021-11-11 | Rappahannock | Virginia | 51157 | 602 | 5 |
1904127 | 1904127 | 2021-11-10 | Rappahannock | Virginia | 51157 | 601 | 5 |
1900877 | 1900877 | 2021-11-09 | Rappahannock | Virginia | 51157 | 598 | 5 |
1897627 | 1897627 | 2021-11-08 | Rappahannock | Virginia | 51157 | 598 | 5 |
1894377 | 1894377 | 2021-11-07 | Rappahannock | Virginia | 51157 | 590 | 5 |
1891127 | 1891127 | 2021-11-06 | Rappahannock | Virginia | 51157 | 590 | 5 |
1887877 | 1887877 | 2021-11-05 | Rappahannock | Virginia | 51157 | 590 | 5 |
1335688 | 1335688 | 2021-05-19 | Craig | Virginia | 51045 | 313 | 5 |
1332441 | 1332441 | 2021-05-18 | Craig | Virginia | 51045 | 314 | 5 |
1329194 | 1329194 | 2021-05-17 | Craig | Virginia | 51045 | 313 | 5 |
1325948 | 1325948 | 2021-05-16 | Craig | Virginia | 51045 | 313 | 5 |
1322702 | 1322702 | 2021-05-15 | Craig | Virginia | 51045 | 313 | 5 |
1319456 | 1319456 | 2021-05-14 | Craig | Virginia | 51045 | 312 | 5 |
1316208 | 1316208 | 2021-05-13 | Craig | Virginia | 51045 | 311 | 5 |
1312962 | 1312962 | 2021-05-12 | Craig | Virginia | 51045 | 311 | 5 |
1309715 | 1309715 | 2021-05-11 | Craig | Virginia | 51045 | 311 | 5 |
1306469 | 1306469 | 2021-05-10 | Craig | Virginia | 51045 | 311 | 5 |
1303223 | 1303223 | 2021-05-09 | Craig | Virginia | 51045 | 310 | 5 |
1299976 | 1299976 | 2021-05-08 | Craig | Virginia | 51045 | 310 | 5 |
1296729 | 1296729 | 2021-05-07 | Craig | Virginia | 51045 | 309 | 5 |
1293483 | 1293483 | 2021-05-06 | Craig | Virginia | 51045 | 309 | 5 |
1290237 | 1290237 | 2021-05-05 | Craig | Virginia | 51045 | 309 | 5 |
1286991 | 1286991 | 2021-05-04 | Craig | Virginia | 51045 | 309 | 5 |
1283745 | 1283745 | 2021-05-03 | Craig | Virginia | 51045 | 309 | 5 |
1280498 | 1280498 | 2021-05-02 | Craig | Virginia | 51045 | 309 | 5 |
1277251 | 1277251 | 2021-05-01 | Craig | Virginia | 51045 | 309 | 5 |
1274004 | 1274004 | 2021-04-30 | Craig | Virginia | 51045 | 309 | 5 |
1270757 | 1270757 | 2021-04-29 | Craig | Virginia | 51045 | 307 | 5 |
1267510 | 1267510 | 2021-04-28 | Craig | Virginia | 51045 | 306 | 5 |
1264263 | 1264263 | 2021-04-27 | Craig | Virginia | 51045 | 306 | 5 |
1261016 | 1261016 | 2021-04-26 | Craig | Virginia | 51045 | 306 | 5 |
1257769 | 1257769 | 2021-04-25 | Craig | Virginia | 51045 | 305 | 5 |
1254522 | 1254522 | 2021-04-24 | Craig | Virginia | 51045 | 304 | 5 |
1251275 | 1251275 | 2021-04-23 | Craig | Virginia | 51045 | 304 | 5 |
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);