ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Henrico" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1816350 | 1816350 | 2021-10-14 | Henrico | Virginia | 51087 | 33604 | 701 |
1813102 | 1813102 | 2021-10-13 | Henrico | Virginia | 51087 | 33522 | 701 |
1809853 | 1809853 | 2021-10-12 | Henrico | Virginia | 51087 | 33460 | 700 |
1806603 | 1806603 | 2021-10-11 | Henrico | Virginia | 51087 | 33230 | 694 |
1803353 | 1803353 | 2021-10-10 | Henrico | Virginia | 51087 | 33230 | 694 |
1800104 | 1800104 | 2021-10-09 | Henrico | Virginia | 51087 | 33230 | 694 |
1796855 | 1796855 | 2021-10-08 | Henrico | Virginia | 51087 | 33230 | 694 |
1793606 | 1793606 | 2021-10-07 | Henrico | Virginia | 51087 | 33127 | 698 |
1790357 | 1790357 | 2021-10-06 | Henrico | Virginia | 51087 | 33054 | 698 |
1787109 | 1787109 | 2021-10-05 | Henrico | Virginia | 51087 | 32944 | 696 |
1783860 | 1783860 | 2021-10-04 | Henrico | Virginia | 51087 | 32898 | 690 |
1780611 | 1780611 | 2021-10-03 | Henrico | Virginia | 51087 | 32659 | 687 |
1777361 | 1777361 | 2021-10-02 | Henrico | Virginia | 51087 | 32659 | 687 |
1774111 | 1774111 | 2021-10-01 | Henrico | Virginia | 51087 | 32659 | 687 |
1770861 | 1770861 | 2021-09-30 | Henrico | Virginia | 51087 | 32584 | 683 |
1767612 | 1767612 | 2021-09-29 | Henrico | Virginia | 51087 | 32493 | 681 |
1764363 | 1764363 | 2021-09-28 | Henrico | Virginia | 51087 | 32411 | 681 |
1761114 | 1761114 | 2021-09-27 | Henrico | Virginia | 51087 | 32324 | 679 |
1757866 | 1757866 | 2021-09-26 | Henrico | Virginia | 51087 | 32106 | 677 |
1754618 | 1754618 | 2021-09-25 | Henrico | Virginia | 51087 | 32106 | 677 |
1751370 | 1751370 | 2021-09-24 | Henrico | Virginia | 51087 | 32106 | 677 |
1748121 | 1748121 | 2021-09-23 | Henrico | Virginia | 51087 | 32034 | 676 |
1744871 | 1744871 | 2021-09-22 | Henrico | Virginia | 51087 | 31907 | 675 |
1741622 | 1741622 | 2021-09-21 | Henrico | Virginia | 51087 | 31770 | 673 |
1738373 | 1738373 | 2021-09-20 | Henrico | Virginia | 51087 | 31667 | 670 |
1735124 | 1735124 | 2021-09-19 | Henrico | Virginia | 51087 | 31422 | 668 |
1731874 | 1731874 | 2021-09-18 | Henrico | Virginia | 51087 | 31422 | 668 |
1728624 | 1728624 | 2021-09-17 | Henrico | Virginia | 51087 | 31422 | 668 |
1725374 | 1725374 | 2021-09-16 | Henrico | Virginia | 51087 | 31288 | 666 |
1722125 | 1722125 | 2021-09-15 | Henrico | Virginia | 51087 | 31183 | 665 |
1718877 | 1718877 | 2021-09-14 | Henrico | Virginia | 51087 | 31066 | 662 |
1715629 | 1715629 | 2021-09-13 | Henrico | Virginia | 51087 | 30928 | 660 |
1712383 | 1712383 | 2021-09-12 | Henrico | Virginia | 51087 | 30630 | 660 |
1709136 | 1709136 | 2021-09-11 | Henrico | Virginia | 51087 | 30630 | 660 |
1705889 | 1705889 | 2021-09-10 | Henrico | Virginia | 51087 | 30630 | 660 |
1702639 | 1702639 | 2021-09-09 | Henrico | Virginia | 51087 | 30503 | 658 |
1699390 | 1699390 | 2021-09-08 | Henrico | Virginia | 51087 | 30388 | 656 |
1696142 | 1696142 | 2021-09-07 | Henrico | Virginia | 51087 | 30243 | 656 |
1692894 | 1692894 | 2021-09-06 | Henrico | Virginia | 51087 | 30172 | 654 |
1689645 | 1689645 | 2021-09-05 | Henrico | Virginia | 51087 | 29847 | 653 |
1686395 | 1686395 | 2021-09-04 | Henrico | Virginia | 51087 | 29847 | 653 |
1683144 | 1683144 | 2021-09-03 | Henrico | Virginia | 51087 | 29847 | 653 |
1679894 | 1679894 | 2021-09-02 | Henrico | Virginia | 51087 | 29714 | 652 |
1676646 | 1676646 | 2021-09-01 | Henrico | Virginia | 51087 | 29581 | 651 |
1673399 | 1673399 | 2021-08-31 | Henrico | Virginia | 51087 | 29472 | 651 |
1670151 | 1670151 | 2021-08-30 | Henrico | Virginia | 51087 | 29357 | 650 |
1666904 | 1666904 | 2021-08-29 | Henrico | Virginia | 51087 | 29025 | 649 |
1663656 | 1663656 | 2021-08-28 | Henrico | Virginia | 51087 | 29025 | 649 |
1660408 | 1660408 | 2021-08-27 | Henrico | Virginia | 51087 | 29025 | 649 |
1657159 | 1657159 | 2021-08-26 | Henrico | Virginia | 51087 | 28873 | 647 |
1653912 | 1653912 | 2021-08-25 | Henrico | Virginia | 51087 | 28712 | 647 |
1650666 | 1650666 | 2021-08-24 | Henrico | Virginia | 51087 | 28592 | 645 |
1647417 | 1647417 | 2021-08-23 | Henrico | Virginia | 51087 | 28473 | 644 |
1644168 | 1644168 | 2021-08-22 | Henrico | Virginia | 51087 | 28138 | 643 |
1640918 | 1640918 | 2021-08-21 | Henrico | Virginia | 51087 | 28138 | 643 |
1637668 | 1637668 | 2021-08-20 | Henrico | Virginia | 51087 | 28138 | 643 |
1634418 | 1634418 | 2021-08-19 | Henrico | Virginia | 51087 | 28041 | 643 |
1631170 | 1631170 | 2021-08-18 | Henrico | Virginia | 51087 | 27915 | 643 |
1627923 | 1627923 | 2021-08-17 | Henrico | Virginia | 51087 | 27848 | 643 |
1624676 | 1624676 | 2021-08-16 | Henrico | Virginia | 51087 | 27762 | 643 |
1621429 | 1621429 | 2021-08-15 | Henrico | Virginia | 51087 | 27455 | 643 |
1618181 | 1618181 | 2021-08-14 | Henrico | Virginia | 51087 | 27455 | 643 |
1614933 | 1614933 | 2021-08-13 | Henrico | Virginia | 51087 | 27455 | 643 |
1611684 | 1611684 | 2021-08-12 | Henrico | Virginia | 51087 | 27371 | 643 |
1608437 | 1608437 | 2021-08-11 | Henrico | Virginia | 51087 | 27289 | 643 |
1605188 | 1605188 | 2021-08-10 | Henrico | Virginia | 51087 | 27210 | 643 |
1601938 | 1601938 | 2021-08-09 | Henrico | Virginia | 51087 | 27144 | 643 |
1598690 | 1598690 | 2021-08-08 | Henrico | Virginia | 51087 | 26971 | 642 |
1595441 | 1595441 | 2021-08-07 | Henrico | Virginia | 51087 | 26971 | 642 |
1592192 | 1592192 | 2021-08-06 | Henrico | Virginia | 51087 | 26971 | 642 |
1588943 | 1588943 | 2021-08-05 | Henrico | Virginia | 51087 | 26907 | 642 |
1585694 | 1585694 | 2021-08-04 | Henrico | Virginia | 51087 | 26850 | 642 |
1582444 | 1582444 | 2021-08-03 | Henrico | Virginia | 51087 | 26769 | 642 |
1579194 | 1579194 | 2021-08-02 | Henrico | Virginia | 51087 | 26685 | 642 |
1575946 | 1575946 | 2021-08-01 | Henrico | Virginia | 51087 | 26532 | 642 |
1572698 | 1572698 | 2021-07-31 | Henrico | Virginia | 51087 | 26532 | 642 |
1569450 | 1569450 | 2021-07-30 | Henrico | Virginia | 51087 | 26532 | 642 |
1566202 | 1566202 | 2021-07-29 | Henrico | Virginia | 51087 | 26492 | 642 |
1562954 | 1562954 | 2021-07-28 | Henrico | Virginia | 51087 | 26440 | 642 |
1559706 | 1559706 | 2021-07-27 | Henrico | Virginia | 51087 | 26396 | 641 |
1556459 | 1556459 | 2021-07-26 | Henrico | Virginia | 51087 | 26378 | 641 |
1553212 | 1553212 | 2021-07-25 | Henrico | Virginia | 51087 | 26273 | 641 |
1549965 | 1549965 | 2021-07-24 | Henrico | Virginia | 51087 | 26273 | 641 |
1546718 | 1546718 | 2021-07-23 | Henrico | Virginia | 51087 | 26273 | 641 |
1543471 | 1543471 | 2021-07-22 | Henrico | Virginia | 51087 | 26247 | 641 |
1540223 | 1540223 | 2021-07-21 | Henrico | Virginia | 51087 | 26222 | 641 |
1536976 | 1536976 | 2021-07-20 | Henrico | Virginia | 51087 | 26187 | 641 |
1533728 | 1533728 | 2021-07-19 | Henrico | Virginia | 51087 | 26137 | 641 |
1530481 | 1530481 | 2021-07-18 | Henrico | Virginia | 51087 | 26110 | 639 |
1527234 | 1527234 | 2021-07-17 | Henrico | Virginia | 51087 | 26110 | 639 |
1523987 | 1523987 | 2021-07-16 | Henrico | Virginia | 51087 | 26110 | 639 |
1520739 | 1520739 | 2021-07-15 | Henrico | Virginia | 51087 | 26087 | 639 |
1517491 | 1517491 | 2021-07-14 | Henrico | Virginia | 51087 | 26070 | 639 |
1514244 | 1514244 | 2021-07-13 | Henrico | Virginia | 51087 | 26046 | 639 |
1510998 | 1510998 | 2021-07-12 | Henrico | Virginia | 51087 | 26044 | 640 |
1507751 | 1507751 | 2021-07-11 | Henrico | Virginia | 51087 | 26030 | 640 |
1504505 | 1504505 | 2021-07-10 | Henrico | Virginia | 51087 | 26021 | 640 |
1501259 | 1501259 | 2021-07-09 | Henrico | Virginia | 51087 | 26019 | 640 |
1498013 | 1498013 | 2021-07-08 | Henrico | Virginia | 51087 | 26018 | 640 |
1494766 | 1494766 | 2021-07-07 | Henrico | Virginia | 51087 | 26034 | 638 |
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);