ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,851 rows where deaths = 6 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Craig 164
- Falls Church city 106
- Williamsburg city 82
- Powhatan 69
- Goochland 64
- Fluvanna 61
- Appomattox 60
- Fredericksburg city 54
- Warren 54
- Amelia 47
- Norton city 46
- Richmond 45
- Caroline 42
- Manassas Park city 41
- Roanoke 38
- Amherst 35
- Franklin city 35
- Fauquier 34
- Bland 31
- Salem city 30
- Buckingham 26
- Emporia city 26
- Prince Edward 26
- Northumberland 25
- York 22
- Pulaski 21
- Rockingham 21
- Charlotte 20
- Brunswick 19
- Fairfax city 19
- …
state 1
- Virginia · 1,851 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2261733 | 2261733 | 2022-02-28 | Highland | Virginia | 51091 | 356 | 6 |
2017890 | 2017890 | 2021-12-15 | Rappahannock | Virginia | 51157 | 667 | 6 |
2014640 | 2014640 | 2021-12-14 | Rappahannock | Virginia | 51157 | 662 | 6 |
2011389 | 2011389 | 2021-12-13 | Rappahannock | Virginia | 51157 | 658 | 6 |
1852063 | 1852063 | 2021-10-25 | Craig | Virginia | 51045 | 542 | 6 |
1848813 | 1848813 | 2021-10-24 | Craig | Virginia | 51045 | 539 | 6 |
1845563 | 1845563 | 2021-10-23 | Craig | Virginia | 51045 | 539 | 6 |
1842313 | 1842313 | 2021-10-22 | Craig | Virginia | 51045 | 539 | 6 |
1839064 | 1839064 | 2021-10-21 | Craig | Virginia | 51045 | 538 | 6 |
1835815 | 1835815 | 2021-10-20 | Craig | Virginia | 51045 | 535 | 6 |
1832566 | 1832566 | 2021-10-19 | Craig | Virginia | 51045 | 532 | 6 |
1829317 | 1829317 | 2021-10-18 | Craig | Virginia | 51045 | 530 | 6 |
1826068 | 1826068 | 2021-10-17 | Craig | Virginia | 51045 | 527 | 6 |
1822819 | 1822819 | 2021-10-16 | Craig | Virginia | 51045 | 527 | 6 |
1819570 | 1819570 | 2021-10-15 | Craig | Virginia | 51045 | 527 | 6 |
1816321 | 1816321 | 2021-10-14 | Craig | Virginia | 51045 | 525 | 6 |
1813073 | 1813073 | 2021-10-13 | Craig | Virginia | 51045 | 519 | 6 |
1809824 | 1809824 | 2021-10-12 | Craig | Virginia | 51045 | 519 | 6 |
1806574 | 1806574 | 2021-10-11 | Craig | Virginia | 51045 | 501 | 6 |
1803324 | 1803324 | 2021-10-10 | Craig | Virginia | 51045 | 501 | 6 |
1800075 | 1800075 | 2021-10-09 | Craig | Virginia | 51045 | 501 | 6 |
1796826 | 1796826 | 2021-10-08 | Craig | Virginia | 51045 | 501 | 6 |
1793577 | 1793577 | 2021-10-07 | Craig | Virginia | 51045 | 495 | 6 |
1790328 | 1790328 | 2021-10-06 | Craig | Virginia | 51045 | 492 | 6 |
1787080 | 1787080 | 2021-10-05 | Craig | Virginia | 51045 | 483 | 6 |
1783831 | 1783831 | 2021-10-04 | Craig | Virginia | 51045 | 482 | 6 |
1780582 | 1780582 | 2021-10-03 | Craig | Virginia | 51045 | 475 | 6 |
1777332 | 1777332 | 2021-10-02 | Craig | Virginia | 51045 | 475 | 6 |
1774082 | 1774082 | 2021-10-01 | Craig | Virginia | 51045 | 475 | 6 |
1770832 | 1770832 | 2021-09-30 | Craig | Virginia | 51045 | 473 | 6 |
1767583 | 1767583 | 2021-09-29 | Craig | Virginia | 51045 | 471 | 6 |
1764334 | 1764334 | 2021-09-28 | Craig | Virginia | 51045 | 470 | 6 |
1761085 | 1761085 | 2021-09-27 | Craig | Virginia | 51045 | 468 | 6 |
1757837 | 1757837 | 2021-09-26 | Craig | Virginia | 51045 | 464 | 6 |
1754589 | 1754589 | 2021-09-25 | Craig | Virginia | 51045 | 464 | 6 |
1751341 | 1751341 | 2021-09-24 | Craig | Virginia | 51045 | 464 | 6 |
1748092 | 1748092 | 2021-09-23 | Craig | Virginia | 51045 | 464 | 6 |
1744842 | 1744842 | 2021-09-22 | Craig | Virginia | 51045 | 463 | 6 |
1741593 | 1741593 | 2021-09-21 | Craig | Virginia | 51045 | 459 | 6 |
1738344 | 1738344 | 2021-09-20 | Craig | Virginia | 51045 | 455 | 6 |
1735095 | 1735095 | 2021-09-19 | Craig | Virginia | 51045 | 443 | 6 |
1731845 | 1731845 | 2021-09-18 | Craig | Virginia | 51045 | 443 | 6 |
1728595 | 1728595 | 2021-09-17 | Craig | Virginia | 51045 | 443 | 6 |
1725345 | 1725345 | 2021-09-16 | Craig | Virginia | 51045 | 442 | 6 |
1722096 | 1722096 | 2021-09-15 | Craig | Virginia | 51045 | 438 | 6 |
1718848 | 1718848 | 2021-09-14 | Craig | Virginia | 51045 | 438 | 6 |
1715600 | 1715600 | 2021-09-13 | Craig | Virginia | 51045 | 435 | 6 |
1712354 | 1712354 | 2021-09-12 | Craig | Virginia | 51045 | 432 | 6 |
1709107 | 1709107 | 2021-09-11 | Craig | Virginia | 51045 | 432 | 6 |
1705860 | 1705860 | 2021-09-10 | Craig | Virginia | 51045 | 432 | 6 |
1702610 | 1702610 | 2021-09-09 | Craig | Virginia | 51045 | 431 | 6 |
1699361 | 1699361 | 2021-09-08 | Craig | Virginia | 51045 | 429 | 6 |
1696113 | 1696113 | 2021-09-07 | Craig | Virginia | 51045 | 421 | 6 |
1692865 | 1692865 | 2021-09-06 | Craig | Virginia | 51045 | 417 | 6 |
1689616 | 1689616 | 2021-09-05 | Craig | Virginia | 51045 | 413 | 6 |
1686366 | 1686366 | 2021-09-04 | Craig | Virginia | 51045 | 413 | 6 |
1683115 | 1683115 | 2021-09-03 | Craig | Virginia | 51045 | 413 | 6 |
1679865 | 1679865 | 2021-09-02 | Craig | Virginia | 51045 | 411 | 6 |
1676617 | 1676617 | 2021-09-01 | Craig | Virginia | 51045 | 404 | 6 |
1673370 | 1673370 | 2021-08-31 | Craig | Virginia | 51045 | 402 | 6 |
1670122 | 1670122 | 2021-08-30 | Craig | Virginia | 51045 | 397 | 6 |
1666875 | 1666875 | 2021-08-29 | Craig | Virginia | 51045 | 393 | 6 |
1663627 | 1663627 | 2021-08-28 | Craig | Virginia | 51045 | 393 | 6 |
1660379 | 1660379 | 2021-08-27 | Craig | Virginia | 51045 | 393 | 6 |
1657130 | 1657130 | 2021-08-26 | Craig | Virginia | 51045 | 391 | 6 |
1653883 | 1653883 | 2021-08-25 | Craig | Virginia | 51045 | 391 | 6 |
1650637 | 1650637 | 2021-08-24 | Craig | Virginia | 51045 | 389 | 6 |
1647388 | 1647388 | 2021-08-23 | Craig | Virginia | 51045 | 383 | 6 |
1644139 | 1644139 | 2021-08-22 | Craig | Virginia | 51045 | 374 | 6 |
1640889 | 1640889 | 2021-08-21 | Craig | Virginia | 51045 | 374 | 6 |
1637639 | 1637639 | 2021-08-20 | Craig | Virginia | 51045 | 374 | 6 |
1634389 | 1634389 | 2021-08-19 | Craig | Virginia | 51045 | 371 | 6 |
1631141 | 1631141 | 2021-08-18 | Craig | Virginia | 51045 | 367 | 6 |
1627894 | 1627894 | 2021-08-17 | Craig | Virginia | 51045 | 359 | 6 |
1624647 | 1624647 | 2021-08-16 | Craig | Virginia | 51045 | 359 | 6 |
1621400 | 1621400 | 2021-08-15 | Craig | Virginia | 51045 | 354 | 6 |
1618152 | 1618152 | 2021-08-14 | Craig | Virginia | 51045 | 354 | 6 |
1614904 | 1614904 | 2021-08-13 | Craig | Virginia | 51045 | 354 | 6 |
1611655 | 1611655 | 2021-08-12 | Craig | Virginia | 51045 | 355 | 6 |
1608408 | 1608408 | 2021-08-11 | Craig | Virginia | 51045 | 351 | 6 |
1605159 | 1605159 | 2021-08-10 | Craig | Virginia | 51045 | 349 | 6 |
1601909 | 1601909 | 2021-08-09 | Craig | Virginia | 51045 | 349 | 6 |
1598661 | 1598661 | 2021-08-08 | Craig | Virginia | 51045 | 345 | 6 |
1595412 | 1595412 | 2021-08-07 | Craig | Virginia | 51045 | 345 | 6 |
1592163 | 1592163 | 2021-08-06 | Craig | Virginia | 51045 | 345 | 6 |
1588914 | 1588914 | 2021-08-05 | Craig | Virginia | 51045 | 343 | 6 |
1585665 | 1585665 | 2021-08-04 | Craig | Virginia | 51045 | 341 | 6 |
1582415 | 1582415 | 2021-08-03 | Craig | Virginia | 51045 | 341 | 6 |
1579165 | 1579165 | 2021-08-02 | Craig | Virginia | 51045 | 339 | 6 |
1575917 | 1575917 | 2021-08-01 | Craig | Virginia | 51045 | 338 | 6 |
1572669 | 1572669 | 2021-07-31 | Craig | Virginia | 51045 | 338 | 6 |
1569421 | 1569421 | 2021-07-30 | Craig | Virginia | 51045 | 338 | 6 |
1566173 | 1566173 | 2021-07-29 | Craig | Virginia | 51045 | 337 | 6 |
1562925 | 1562925 | 2021-07-28 | Craig | Virginia | 51045 | 336 | 6 |
1559677 | 1559677 | 2021-07-27 | Craig | Virginia | 51045 | 336 | 6 |
1556430 | 1556430 | 2021-07-26 | Craig | Virginia | 51045 | 336 | 6 |
1553183 | 1553183 | 2021-07-25 | Craig | Virginia | 51045 | 337 | 6 |
1549936 | 1549936 | 2021-07-24 | Craig | Virginia | 51045 | 337 | 6 |
1546689 | 1546689 | 2021-07-23 | Craig | Virginia | 51045 | 337 | 6 |
1543442 | 1543442 | 2021-07-22 | Craig | Virginia | 51045 | 337 | 6 |
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);