ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Halifax" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1816346 | 1816346 | 2021-10-14 | Halifax | Virginia | 51083 | 3765 | 100 |
1813098 | 1813098 | 2021-10-13 | Halifax | Virginia | 51083 | 3737 | 100 |
1809849 | 1809849 | 2021-10-12 | Halifax | Virginia | 51083 | 3732 | 99 |
1806599 | 1806599 | 2021-10-11 | Halifax | Virginia | 51083 | 3677 | 99 |
1803349 | 1803349 | 2021-10-10 | Halifax | Virginia | 51083 | 3677 | 99 |
1800100 | 1800100 | 2021-10-09 | Halifax | Virginia | 51083 | 3677 | 99 |
1796851 | 1796851 | 2021-10-08 | Halifax | Virginia | 51083 | 3677 | 99 |
1793602 | 1793602 | 2021-10-07 | Halifax | Virginia | 51083 | 3660 | 99 |
1790353 | 1790353 | 2021-10-06 | Halifax | Virginia | 51083 | 3642 | 99 |
1787105 | 1787105 | 2021-10-05 | Halifax | Virginia | 51083 | 3620 | 99 |
1783856 | 1783856 | 2021-10-04 | Halifax | Virginia | 51083 | 3613 | 99 |
1780607 | 1780607 | 2021-10-03 | Halifax | Virginia | 51083 | 3553 | 99 |
1777357 | 1777357 | 2021-10-02 | Halifax | Virginia | 51083 | 3553 | 99 |
1774107 | 1774107 | 2021-10-01 | Halifax | Virginia | 51083 | 3553 | 99 |
1770857 | 1770857 | 2021-09-30 | Halifax | Virginia | 51083 | 3532 | 98 |
1767608 | 1767608 | 2021-09-29 | Halifax | Virginia | 51083 | 3513 | 96 |
1764359 | 1764359 | 2021-09-28 | Halifax | Virginia | 51083 | 3499 | 94 |
1761110 | 1761110 | 2021-09-27 | Halifax | Virginia | 51083 | 3487 | 92 |
1757862 | 1757862 | 2021-09-26 | Halifax | Virginia | 51083 | 3454 | 91 |
1754614 | 1754614 | 2021-09-25 | Halifax | Virginia | 51083 | 3454 | 91 |
1751366 | 1751366 | 2021-09-24 | Halifax | Virginia | 51083 | 3454 | 91 |
1748117 | 1748117 | 2021-09-23 | Halifax | Virginia | 51083 | 3450 | 91 |
1744867 | 1744867 | 2021-09-22 | Halifax | Virginia | 51083 | 3433 | 91 |
1741618 | 1741618 | 2021-09-21 | Halifax | Virginia | 51083 | 3416 | 91 |
1738369 | 1738369 | 2021-09-20 | Halifax | Virginia | 51083 | 3401 | 90 |
1735120 | 1735120 | 2021-09-19 | Halifax | Virginia | 51083 | 3369 | 90 |
1731870 | 1731870 | 2021-09-18 | Halifax | Virginia | 51083 | 3369 | 90 |
1728620 | 1728620 | 2021-09-17 | Halifax | Virginia | 51083 | 3369 | 90 |
1725370 | 1725370 | 2021-09-16 | Halifax | Virginia | 51083 | 3358 | 90 |
1722121 | 1722121 | 2021-09-15 | Halifax | Virginia | 51083 | 3343 | 90 |
1718873 | 1718873 | 2021-09-14 | Halifax | Virginia | 51083 | 3334 | 90 |
1715625 | 1715625 | 2021-09-13 | Halifax | Virginia | 51083 | 3323 | 90 |
1712379 | 1712379 | 2021-09-12 | Halifax | Virginia | 51083 | 3297 | 89 |
1709132 | 1709132 | 2021-09-11 | Halifax | Virginia | 51083 | 3297 | 89 |
1705885 | 1705885 | 2021-09-10 | Halifax | Virginia | 51083 | 3297 | 89 |
1702635 | 1702635 | 2021-09-09 | Halifax | Virginia | 51083 | 3271 | 89 |
1699386 | 1699386 | 2021-09-08 | Halifax | Virginia | 51083 | 3259 | 89 |
1696138 | 1696138 | 2021-09-07 | Halifax | Virginia | 51083 | 3242 | 89 |
1692890 | 1692890 | 2021-09-06 | Halifax | Virginia | 51083 | 3240 | 89 |
1689641 | 1689641 | 2021-09-05 | Halifax | Virginia | 51083 | 3211 | 89 |
1686391 | 1686391 | 2021-09-04 | Halifax | Virginia | 51083 | 3211 | 89 |
1683140 | 1683140 | 2021-09-03 | Halifax | Virginia | 51083 | 3211 | 89 |
1679890 | 1679890 | 2021-09-02 | Halifax | Virginia | 51083 | 3194 | 89 |
1676642 | 1676642 | 2021-09-01 | Halifax | Virginia | 51083 | 3186 | 89 |
1673395 | 1673395 | 2021-08-31 | Halifax | Virginia | 51083 | 3171 | 89 |
1670147 | 1670147 | 2021-08-30 | Halifax | Virginia | 51083 | 3168 | 88 |
1666900 | 1666900 | 2021-08-29 | Halifax | Virginia | 51083 | 3145 | 88 |
1663652 | 1663652 | 2021-08-28 | Halifax | Virginia | 51083 | 3145 | 88 |
1660404 | 1660404 | 2021-08-27 | Halifax | Virginia | 51083 | 3145 | 88 |
1657155 | 1657155 | 2021-08-26 | Halifax | Virginia | 51083 | 3128 | 85 |
1653908 | 1653908 | 2021-08-25 | Halifax | Virginia | 51083 | 3111 | 84 |
1650662 | 1650662 | 2021-08-24 | Halifax | Virginia | 51083 | 3109 | 80 |
1647413 | 1647413 | 2021-08-23 | Halifax | Virginia | 51083 | 3096 | 80 |
1644164 | 1644164 | 2021-08-22 | Halifax | Virginia | 51083 | 3067 | 80 |
1640914 | 1640914 | 2021-08-21 | Halifax | Virginia | 51083 | 3067 | 80 |
1637664 | 1637664 | 2021-08-20 | Halifax | Virginia | 51083 | 3067 | 80 |
1634414 | 1634414 | 2021-08-19 | Halifax | Virginia | 51083 | 3059 | 80 |
1631166 | 1631166 | 2021-08-18 | Halifax | Virginia | 51083 | 3056 | 80 |
1627919 | 1627919 | 2021-08-17 | Halifax | Virginia | 51083 | 3044 | 80 |
1624672 | 1624672 | 2021-08-16 | Halifax | Virginia | 51083 | 3035 | 80 |
1621425 | 1621425 | 2021-08-15 | Halifax | Virginia | 51083 | 2974 | 78 |
1618177 | 1618177 | 2021-08-14 | Halifax | Virginia | 51083 | 2974 | 78 |
1614929 | 1614929 | 2021-08-13 | Halifax | Virginia | 51083 | 2974 | 78 |
1611680 | 1611680 | 2021-08-12 | Halifax | Virginia | 51083 | 2960 | 78 |
1608433 | 1608433 | 2021-08-11 | Halifax | Virginia | 51083 | 2948 | 78 |
1605184 | 1605184 | 2021-08-10 | Halifax | Virginia | 51083 | 2940 | 78 |
1601934 | 1601934 | 2021-08-09 | Halifax | Virginia | 51083 | 2934 | 78 |
1598686 | 1598686 | 2021-08-08 | Halifax | Virginia | 51083 | 2921 | 78 |
1595437 | 1595437 | 2021-08-07 | Halifax | Virginia | 51083 | 2921 | 78 |
1592188 | 1592188 | 2021-08-06 | Halifax | Virginia | 51083 | 2921 | 78 |
1588939 | 1588939 | 2021-08-05 | Halifax | Virginia | 51083 | 2913 | 78 |
1585690 | 1585690 | 2021-08-04 | Halifax | Virginia | 51083 | 2901 | 78 |
1582440 | 1582440 | 2021-08-03 | Halifax | Virginia | 51083 | 2896 | 78 |
1579190 | 1579190 | 2021-08-02 | Halifax | Virginia | 51083 | 2886 | 78 |
1575942 | 1575942 | 2021-08-01 | Halifax | Virginia | 51083 | 2873 | 78 |
1572694 | 1572694 | 2021-07-31 | Halifax | Virginia | 51083 | 2873 | 78 |
1569446 | 1569446 | 2021-07-30 | Halifax | Virginia | 51083 | 2873 | 78 |
1566198 | 1566198 | 2021-07-29 | Halifax | Virginia | 51083 | 2871 | 78 |
1562950 | 1562950 | 2021-07-28 | Halifax | Virginia | 51083 | 2869 | 78 |
1559702 | 1559702 | 2021-07-27 | Halifax | Virginia | 51083 | 2865 | 78 |
1556455 | 1556455 | 2021-07-26 | Halifax | Virginia | 51083 | 2860 | 78 |
1553208 | 1553208 | 2021-07-25 | Halifax | Virginia | 51083 | 2858 | 78 |
1549961 | 1549961 | 2021-07-24 | Halifax | Virginia | 51083 | 2858 | 78 |
1546714 | 1546714 | 2021-07-23 | Halifax | Virginia | 51083 | 2858 | 78 |
1543467 | 1543467 | 2021-07-22 | Halifax | Virginia | 51083 | 2858 | 78 |
1540219 | 1540219 | 2021-07-21 | Halifax | Virginia | 51083 | 2854 | 78 |
1536972 | 1536972 | 2021-07-20 | Halifax | Virginia | 51083 | 2852 | 78 |
1533724 | 1533724 | 2021-07-19 | Halifax | Virginia | 51083 | 2850 | 78 |
1530477 | 1530477 | 2021-07-18 | Halifax | Virginia | 51083 | 2850 | 78 |
1527230 | 1527230 | 2021-07-17 | Halifax | Virginia | 51083 | 2850 | 78 |
1523983 | 1523983 | 2021-07-16 | Halifax | Virginia | 51083 | 2850 | 78 |
1520735 | 1520735 | 2021-07-15 | Halifax | Virginia | 51083 | 2847 | 78 |
1517487 | 1517487 | 2021-07-14 | Halifax | Virginia | 51083 | 2846 | 78 |
1514240 | 1514240 | 2021-07-13 | Halifax | Virginia | 51083 | 2846 | 78 |
1510994 | 1510994 | 2021-07-12 | Halifax | Virginia | 51083 | 2844 | 78 |
1507747 | 1507747 | 2021-07-11 | Halifax | Virginia | 51083 | 2844 | 78 |
1504501 | 1504501 | 2021-07-10 | Halifax | Virginia | 51083 | 2844 | 78 |
1501255 | 1501255 | 2021-07-09 | Halifax | Virginia | 51083 | 2843 | 78 |
1498009 | 1498009 | 2021-07-08 | Halifax | Virginia | 51083 | 2844 | 78 |
1494762 | 1494762 | 2021-07-07 | Halifax | Virginia | 51083 | 2842 | 78 |
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);