ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 51177 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1819657 | 1819657 | 2021-10-15 | Spotsylvania | Virginia | 51177 | 14577 | 144 |
1816408 | 1816408 | 2021-10-14 | Spotsylvania | Virginia | 51177 | 14522 | 144 |
1813160 | 1813160 | 2021-10-13 | Spotsylvania | Virginia | 51177 | 14482 | 143 |
1809911 | 1809911 | 2021-10-12 | Spotsylvania | Virginia | 51177 | 14434 | 143 |
1806661 | 1806661 | 2021-10-11 | Spotsylvania | Virginia | 51177 | 14266 | 141 |
1803411 | 1803411 | 2021-10-10 | Spotsylvania | Virginia | 51177 | 14266 | 141 |
1800162 | 1800162 | 2021-10-09 | Spotsylvania | Virginia | 51177 | 14266 | 141 |
1796913 | 1796913 | 2021-10-08 | Spotsylvania | Virginia | 51177 | 14266 | 141 |
1793664 | 1793664 | 2021-10-07 | Spotsylvania | Virginia | 51177 | 14205 | 141 |
1790415 | 1790415 | 2021-10-06 | Spotsylvania | Virginia | 51177 | 14148 | 141 |
1787167 | 1787167 | 2021-10-05 | Spotsylvania | Virginia | 51177 | 14061 | 141 |
1783918 | 1783918 | 2021-10-04 | Spotsylvania | Virginia | 51177 | 14040 | 141 |
1780669 | 1780669 | 2021-10-03 | Spotsylvania | Virginia | 51177 | 13885 | 140 |
1777419 | 1777419 | 2021-10-02 | Spotsylvania | Virginia | 51177 | 13885 | 140 |
1774169 | 1774169 | 2021-10-01 | Spotsylvania | Virginia | 51177 | 13885 | 140 |
1770919 | 1770919 | 2021-09-30 | Spotsylvania | Virginia | 51177 | 13846 | 140 |
1767670 | 1767670 | 2021-09-29 | Spotsylvania | Virginia | 51177 | 13774 | 140 |
1764421 | 1764421 | 2021-09-28 | Spotsylvania | Virginia | 51177 | 13722 | 140 |
1761172 | 1761172 | 2021-09-27 | Spotsylvania | Virginia | 51177 | 13673 | 138 |
1757924 | 1757924 | 2021-09-26 | Spotsylvania | Virginia | 51177 | 13501 | 138 |
1754676 | 1754676 | 2021-09-25 | Spotsylvania | Virginia | 51177 | 13501 | 138 |
1751428 | 1751428 | 2021-09-24 | Spotsylvania | Virginia | 51177 | 13501 | 138 |
1748179 | 1748179 | 2021-09-23 | Spotsylvania | Virginia | 51177 | 13436 | 138 |
1744929 | 1744929 | 2021-09-22 | Spotsylvania | Virginia | 51177 | 13352 | 137 |
1741680 | 1741680 | 2021-09-21 | Spotsylvania | Virginia | 51177 | 13286 | 135 |
1738431 | 1738431 | 2021-09-20 | Spotsylvania | Virginia | 51177 | 13215 | 134 |
1735182 | 1735182 | 2021-09-19 | Spotsylvania | Virginia | 51177 | 13012 | 134 |
1731932 | 1731932 | 2021-09-18 | Spotsylvania | Virginia | 51177 | 13012 | 134 |
1728682 | 1728682 | 2021-09-17 | Spotsylvania | Virginia | 51177 | 13012 | 134 |
1725432 | 1725432 | 2021-09-16 | Spotsylvania | Virginia | 51177 | 12912 | 134 |
1722183 | 1722183 | 2021-09-15 | Spotsylvania | Virginia | 51177 | 12833 | 133 |
1718935 | 1718935 | 2021-09-14 | Spotsylvania | Virginia | 51177 | 12760 | 132 |
1715687 | 1715687 | 2021-09-13 | Spotsylvania | Virginia | 51177 | 12648 | 132 |
1712441 | 1712441 | 2021-09-12 | Spotsylvania | Virginia | 51177 | 12446 | 130 |
1709194 | 1709194 | 2021-09-11 | Spotsylvania | Virginia | 51177 | 12446 | 130 |
1705947 | 1705947 | 2021-09-10 | Spotsylvania | Virginia | 51177 | 12446 | 130 |
1702697 | 1702697 | 2021-09-09 | Spotsylvania | Virginia | 51177 | 12373 | 130 |
1699448 | 1699448 | 2021-09-08 | Spotsylvania | Virginia | 51177 | 12312 | 129 |
1696200 | 1696200 | 2021-09-07 | Spotsylvania | Virginia | 51177 | 12225 | 129 |
1692952 | 1692952 | 2021-09-06 | Spotsylvania | Virginia | 51177 | 12159 | 128 |
1689703 | 1689703 | 2021-09-05 | Spotsylvania | Virginia | 51177 | 11986 | 128 |
1686453 | 1686453 | 2021-09-04 | Spotsylvania | Virginia | 51177 | 11986 | 128 |
1683202 | 1683202 | 2021-09-03 | Spotsylvania | Virginia | 51177 | 11986 | 128 |
1679952 | 1679952 | 2021-09-02 | Spotsylvania | Virginia | 51177 | 11914 | 128 |
1676704 | 1676704 | 2021-09-01 | Spotsylvania | Virginia | 51177 | 11879 | 128 |
1673457 | 1673457 | 2021-08-31 | Spotsylvania | Virginia | 51177 | 11804 | 128 |
1670209 | 1670209 | 2021-08-30 | Spotsylvania | Virginia | 51177 | 11713 | 128 |
1666962 | 1666962 | 2021-08-29 | Spotsylvania | Virginia | 51177 | 11528 | 128 |
1663714 | 1663714 | 2021-08-28 | Spotsylvania | Virginia | 51177 | 11528 | 128 |
1660466 | 1660466 | 2021-08-27 | Spotsylvania | Virginia | 51177 | 11528 | 128 |
1657217 | 1657217 | 2021-08-26 | Spotsylvania | Virginia | 51177 | 11477 | 128 |
1653970 | 1653970 | 2021-08-25 | Spotsylvania | Virginia | 51177 | 11419 | 127 |
1650724 | 1650724 | 2021-08-24 | Spotsylvania | Virginia | 51177 | 11362 | 127 |
1647475 | 1647475 | 2021-08-23 | Spotsylvania | Virginia | 51177 | 11313 | 126 |
1644226 | 1644226 | 2021-08-22 | Spotsylvania | Virginia | 51177 | 11186 | 126 |
1640976 | 1640976 | 2021-08-21 | Spotsylvania | Virginia | 51177 | 11186 | 126 |
1637726 | 1637726 | 2021-08-20 | Spotsylvania | Virginia | 51177 | 11186 | 126 |
1634476 | 1634476 | 2021-08-19 | Spotsylvania | Virginia | 51177 | 11141 | 126 |
1631228 | 1631228 | 2021-08-18 | Spotsylvania | Virginia | 51177 | 11115 | 126 |
1627981 | 1627981 | 2021-08-17 | Spotsylvania | Virginia | 51177 | 11064 | 126 |
1624734 | 1624734 | 2021-08-16 | Spotsylvania | Virginia | 51177 | 11028 | 126 |
1621487 | 1621487 | 2021-08-15 | Spotsylvania | Virginia | 51177 | 10904 | 126 |
1618239 | 1618239 | 2021-08-14 | Spotsylvania | Virginia | 51177 | 10904 | 126 |
1614991 | 1614991 | 2021-08-13 | Spotsylvania | Virginia | 51177 | 10904 | 126 |
1611742 | 1611742 | 2021-08-12 | Spotsylvania | Virginia | 51177 | 10841 | 126 |
1608495 | 1608495 | 2021-08-11 | Spotsylvania | Virginia | 51177 | 10797 | 126 |
1605246 | 1605246 | 2021-08-10 | Spotsylvania | Virginia | 51177 | 10756 | 126 |
1601996 | 1601996 | 2021-08-09 | Spotsylvania | Virginia | 51177 | 10730 | 126 |
1598748 | 1598748 | 2021-08-08 | Spotsylvania | Virginia | 51177 | 10652 | 126 |
1595499 | 1595499 | 2021-08-07 | Spotsylvania | Virginia | 51177 | 10652 | 126 |
1592250 | 1592250 | 2021-08-06 | Spotsylvania | Virginia | 51177 | 10652 | 126 |
1589001 | 1589001 | 2021-08-05 | Spotsylvania | Virginia | 51177 | 10612 | 125 |
1585752 | 1585752 | 2021-08-04 | Spotsylvania | Virginia | 51177 | 10583 | 125 |
1582502 | 1582502 | 2021-08-03 | Spotsylvania | Virginia | 51177 | 10555 | 125 |
1579252 | 1579252 | 2021-08-02 | Spotsylvania | Virginia | 51177 | 10538 | 125 |
1576004 | 1576004 | 2021-08-01 | Spotsylvania | Virginia | 51177 | 10468 | 125 |
1572756 | 1572756 | 2021-07-31 | Spotsylvania | Virginia | 51177 | 10468 | 125 |
1569508 | 1569508 | 2021-07-30 | Spotsylvania | Virginia | 51177 | 10468 | 125 |
1566260 | 1566260 | 2021-07-29 | Spotsylvania | Virginia | 51177 | 10443 | 125 |
1563012 | 1563012 | 2021-07-28 | Spotsylvania | Virginia | 51177 | 10421 | 125 |
1559764 | 1559764 | 2021-07-27 | Spotsylvania | Virginia | 51177 | 10407 | 125 |
1556517 | 1556517 | 2021-07-26 | Spotsylvania | Virginia | 51177 | 10395 | 125 |
1553270 | 1553270 | 2021-07-25 | Spotsylvania | Virginia | 51177 | 10350 | 125 |
1550023 | 1550023 | 2021-07-24 | Spotsylvania | Virginia | 51177 | 10350 | 125 |
1546776 | 1546776 | 2021-07-23 | Spotsylvania | Virginia | 51177 | 10350 | 125 |
1543529 | 1543529 | 2021-07-22 | Spotsylvania | Virginia | 51177 | 10335 | 125 |
1540281 | 1540281 | 2021-07-21 | Spotsylvania | Virginia | 51177 | 10323 | 125 |
1537034 | 1537034 | 2021-07-20 | Spotsylvania | Virginia | 51177 | 10309 | 125 |
1533786 | 1533786 | 2021-07-19 | Spotsylvania | Virginia | 51177 | 10304 | 125 |
1530539 | 1530539 | 2021-07-18 | Spotsylvania | Virginia | 51177 | 10282 | 125 |
1527292 | 1527292 | 2021-07-17 | Spotsylvania | Virginia | 51177 | 10282 | 125 |
1524045 | 1524045 | 2021-07-16 | Spotsylvania | Virginia | 51177 | 10282 | 125 |
1520797 | 1520797 | 2021-07-15 | Spotsylvania | Virginia | 51177 | 10272 | 125 |
1517549 | 1517549 | 2021-07-14 | Spotsylvania | Virginia | 51177 | 10261 | 125 |
1514302 | 1514302 | 2021-07-13 | Spotsylvania | Virginia | 51177 | 10251 | 125 |
1511056 | 1511056 | 2021-07-12 | Spotsylvania | Virginia | 51177 | 10250 | 125 |
1507809 | 1507809 | 2021-07-11 | Spotsylvania | Virginia | 51177 | 10249 | 125 |
1504563 | 1504563 | 2021-07-10 | Spotsylvania | Virginia | 51177 | 10242 | 125 |
1501317 | 1501317 | 2021-07-09 | Spotsylvania | Virginia | 51177 | 10242 | 125 |
1498071 | 1498071 | 2021-07-08 | Spotsylvania | Virginia | 51177 | 10235 | 125 |
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);