ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 51760 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1819646 | 1819646 | 2021-10-15 | Richmond city | Virginia | 51760 | 23458 | 333 |
1816397 | 1816397 | 2021-10-14 | Richmond city | Virginia | 51760 | 23430 | 332 |
1813149 | 1813149 | 2021-10-13 | Richmond city | Virginia | 51760 | 23382 | 331 |
1809900 | 1809900 | 2021-10-12 | Richmond city | Virginia | 51760 | 23337 | 329 |
1806650 | 1806650 | 2021-10-11 | Richmond city | Virginia | 51760 | 23145 | 322 |
1803400 | 1803400 | 2021-10-10 | Richmond city | Virginia | 51760 | 23145 | 322 |
1800151 | 1800151 | 2021-10-09 | Richmond city | Virginia | 51760 | 23145 | 322 |
1796902 | 1796902 | 2021-10-08 | Richmond city | Virginia | 51760 | 23145 | 322 |
1793653 | 1793653 | 2021-10-07 | Richmond city | Virginia | 51760 | 23095 | 322 |
1790404 | 1790404 | 2021-10-06 | Richmond city | Virginia | 51760 | 23032 | 320 |
1787156 | 1787156 | 2021-10-05 | Richmond city | Virginia | 51760 | 22929 | 316 |
1783907 | 1783907 | 2021-10-04 | Richmond city | Virginia | 51760 | 22876 | 313 |
1780658 | 1780658 | 2021-10-03 | Richmond city | Virginia | 51760 | 22730 | 313 |
1777408 | 1777408 | 2021-10-02 | Richmond city | Virginia | 51760 | 22730 | 313 |
1774158 | 1774158 | 2021-10-01 | Richmond city | Virginia | 51760 | 22730 | 313 |
1770908 | 1770908 | 2021-09-30 | Richmond city | Virginia | 51760 | 22679 | 312 |
1767659 | 1767659 | 2021-09-29 | Richmond city | Virginia | 51760 | 22619 | 310 |
1764410 | 1764410 | 2021-09-28 | Richmond city | Virginia | 51760 | 22544 | 306 |
1761161 | 1761161 | 2021-09-27 | Richmond city | Virginia | 51760 | 22488 | 304 |
1757913 | 1757913 | 2021-09-26 | Richmond city | Virginia | 51760 | 22267 | 302 |
1754665 | 1754665 | 2021-09-25 | Richmond city | Virginia | 51760 | 22267 | 302 |
1751417 | 1751417 | 2021-09-24 | Richmond city | Virginia | 51760 | 22267 | 302 |
1748168 | 1748168 | 2021-09-23 | Richmond city | Virginia | 51760 | 22182 | 302 |
1744918 | 1744918 | 2021-09-22 | Richmond city | Virginia | 51760 | 22112 | 300 |
1741669 | 1741669 | 2021-09-21 | Richmond city | Virginia | 51760 | 22024 | 298 |
1738420 | 1738420 | 2021-09-20 | Richmond city | Virginia | 51760 | 21924 | 293 |
1735171 | 1735171 | 2021-09-19 | Richmond city | Virginia | 51760 | 21696 | 293 |
1731921 | 1731921 | 2021-09-18 | Richmond city | Virginia | 51760 | 21696 | 293 |
1728671 | 1728671 | 2021-09-17 | Richmond city | Virginia | 51760 | 21696 | 293 |
1725421 | 1725421 | 2021-09-16 | Richmond city | Virginia | 51760 | 21567 | 292 |
1722172 | 1722172 | 2021-09-15 | Richmond city | Virginia | 51760 | 21472 | 292 |
1718924 | 1718924 | 2021-09-14 | Richmond city | Virginia | 51760 | 21356 | 291 |
1715676 | 1715676 | 2021-09-13 | Richmond city | Virginia | 51760 | 21245 | 290 |
1712430 | 1712430 | 2021-09-12 | Richmond city | Virginia | 51760 | 20990 | 290 |
1709183 | 1709183 | 2021-09-11 | Richmond city | Virginia | 51760 | 20990 | 290 |
1705936 | 1705936 | 2021-09-10 | Richmond city | Virginia | 51760 | 20990 | 290 |
1702686 | 1702686 | 2021-09-09 | Richmond city | Virginia | 51760 | 20891 | 290 |
1699437 | 1699437 | 2021-09-08 | Richmond city | Virginia | 51760 | 20810 | 290 |
1696189 | 1696189 | 2021-09-07 | Richmond city | Virginia | 51760 | 20670 | 290 |
1692941 | 1692941 | 2021-09-06 | Richmond city | Virginia | 51760 | 20606 | 287 |
1689692 | 1689692 | 2021-09-05 | Richmond city | Virginia | 51760 | 20299 | 286 |
1686442 | 1686442 | 2021-09-04 | Richmond city | Virginia | 51760 | 20299 | 286 |
1683191 | 1683191 | 2021-09-03 | Richmond city | Virginia | 51760 | 20299 | 286 |
1679941 | 1679941 | 2021-09-02 | Richmond city | Virginia | 51760 | 20149 | 286 |
1676693 | 1676693 | 2021-09-01 | Richmond city | Virginia | 51760 | 20016 | 286 |
1673446 | 1673446 | 2021-08-31 | Richmond city | Virginia | 51760 | 19922 | 284 |
1670198 | 1670198 | 2021-08-30 | Richmond city | Virginia | 51760 | 19796 | 284 |
1666951 | 1666951 | 2021-08-29 | Richmond city | Virginia | 51760 | 19509 | 283 |
1663703 | 1663703 | 2021-08-28 | Richmond city | Virginia | 51760 | 19509 | 283 |
1660455 | 1660455 | 2021-08-27 | Richmond city | Virginia | 51760 | 19509 | 283 |
1657206 | 1657206 | 2021-08-26 | Richmond city | Virginia | 51760 | 19402 | 281 |
1653959 | 1653959 | 2021-08-25 | Richmond city | Virginia | 51760 | 19291 | 281 |
1650713 | 1650713 | 2021-08-24 | Richmond city | Virginia | 51760 | 19208 | 281 |
1647464 | 1647464 | 2021-08-23 | Richmond city | Virginia | 51760 | 19111 | 281 |
1644215 | 1644215 | 2021-08-22 | Richmond city | Virginia | 51760 | 18814 | 281 |
1640965 | 1640965 | 2021-08-21 | Richmond city | Virginia | 51760 | 18814 | 281 |
1637715 | 1637715 | 2021-08-20 | Richmond city | Virginia | 51760 | 18814 | 281 |
1634465 | 1634465 | 2021-08-19 | Richmond city | Virginia | 51760 | 18720 | 281 |
1631217 | 1631217 | 2021-08-18 | Richmond city | Virginia | 51760 | 18655 | 281 |
1627970 | 1627970 | 2021-08-17 | Richmond city | Virginia | 51760 | 18569 | 281 |
1624723 | 1624723 | 2021-08-16 | Richmond city | Virginia | 51760 | 18526 | 281 |
1621476 | 1621476 | 2021-08-15 | Richmond city | Virginia | 51760 | 18287 | 281 |
1618228 | 1618228 | 2021-08-14 | Richmond city | Virginia | 51760 | 18287 | 281 |
1614980 | 1614980 | 2021-08-13 | Richmond city | Virginia | 51760 | 18287 | 281 |
1611731 | 1611731 | 2021-08-12 | Richmond city | Virginia | 51760 | 18225 | 281 |
1608484 | 1608484 | 2021-08-11 | Richmond city | Virginia | 51760 | 18173 | 281 |
1605235 | 1605235 | 2021-08-10 | Richmond city | Virginia | 51760 | 18128 | 281 |
1601985 | 1601985 | 2021-08-09 | Richmond city | Virginia | 51760 | 18073 | 281 |
1598737 | 1598737 | 2021-08-08 | Richmond city | Virginia | 51760 | 17927 | 281 |
1595488 | 1595488 | 2021-08-07 | Richmond city | Virginia | 51760 | 17927 | 281 |
1592239 | 1592239 | 2021-08-06 | Richmond city | Virginia | 51760 | 17927 | 281 |
1588990 | 1588990 | 2021-08-05 | Richmond city | Virginia | 51760 | 17871 | 281 |
1585741 | 1585741 | 2021-08-04 | Richmond city | Virginia | 51760 | 17823 | 281 |
1582491 | 1582491 | 2021-08-03 | Richmond city | Virginia | 51760 | 17789 | 281 |
1579241 | 1579241 | 2021-08-02 | Richmond city | Virginia | 51760 | 17715 | 281 |
1575993 | 1575993 | 2021-08-01 | Richmond city | Virginia | 51760 | 17585 | 281 |
1572745 | 1572745 | 2021-07-31 | Richmond city | Virginia | 51760 | 17585 | 281 |
1569497 | 1569497 | 2021-07-30 | Richmond city | Virginia | 51760 | 17585 | 281 |
1566249 | 1566249 | 2021-07-29 | Richmond city | Virginia | 51760 | 17574 | 280 |
1563001 | 1563001 | 2021-07-28 | Richmond city | Virginia | 51760 | 17546 | 280 |
1559753 | 1559753 | 2021-07-27 | Richmond city | Virginia | 51760 | 17526 | 280 |
1556506 | 1556506 | 2021-07-26 | Richmond city | Virginia | 51760 | 17503 | 280 |
1553259 | 1553259 | 2021-07-25 | Richmond city | Virginia | 51760 | 17436 | 280 |
1550012 | 1550012 | 2021-07-24 | Richmond city | Virginia | 51760 | 17436 | 280 |
1546765 | 1546765 | 2021-07-23 | Richmond city | Virginia | 51760 | 17436 | 280 |
1543518 | 1543518 | 2021-07-22 | Richmond city | Virginia | 51760 | 17414 | 275 |
1540270 | 1540270 | 2021-07-21 | Richmond city | Virginia | 51760 | 17388 | 274 |
1537023 | 1537023 | 2021-07-20 | Richmond city | Virginia | 51760 | 17368 | 273 |
1533775 | 1533775 | 2021-07-19 | Richmond city | Virginia | 51760 | 17344 | 275 |
1530528 | 1530528 | 2021-07-18 | Richmond city | Virginia | 51760 | 17325 | 275 |
1527281 | 1527281 | 2021-07-17 | Richmond city | Virginia | 51760 | 17325 | 275 |
1524034 | 1524034 | 2021-07-16 | Richmond city | Virginia | 51760 | 17325 | 275 |
1520786 | 1520786 | 2021-07-15 | Richmond city | Virginia | 51760 | 17307 | 274 |
1517538 | 1517538 | 2021-07-14 | Richmond city | Virginia | 51760 | 17301 | 274 |
1514291 | 1514291 | 2021-07-13 | Richmond city | Virginia | 51760 | 17273 | 274 |
1511045 | 1511045 | 2021-07-12 | Richmond city | Virginia | 51760 | 17259 | 273 |
1507798 | 1507798 | 2021-07-11 | Richmond city | Virginia | 51760 | 17253 | 273 |
1504552 | 1504552 | 2021-07-10 | Richmond city | Virginia | 51760 | 17250 | 273 |
1501306 | 1501306 | 2021-07-09 | Richmond city | Virginia | 51760 | 17246 | 273 |
1498060 | 1498060 | 2021-07-08 | Richmond city | Virginia | 51760 | 17243 | 273 |
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);