ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where county = "Grayson", deaths = 40 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1741615 | 1741615 | 2021-09-21 | Grayson | Virginia | 51077 | 1854 | 40 |
1738366 | 1738366 | 2021-09-20 | Grayson | Virginia | 51077 | 1843 | 40 |
1735117 | 1735117 | 2021-09-19 | Grayson | Virginia | 51077 | 1823 | 40 |
1731867 | 1731867 | 2021-09-18 | Grayson | Virginia | 51077 | 1823 | 40 |
1728617 | 1728617 | 2021-09-17 | Grayson | Virginia | 51077 | 1823 | 40 |
1725367 | 1725367 | 2021-09-16 | Grayson | Virginia | 51077 | 1814 | 40 |
1722118 | 1722118 | 2021-09-15 | Grayson | Virginia | 51077 | 1802 | 40 |
1718870 | 1718870 | 2021-09-14 | Grayson | Virginia | 51077 | 1795 | 40 |
1715622 | 1715622 | 2021-09-13 | Grayson | Virginia | 51077 | 1787 | 40 |
1712376 | 1712376 | 2021-09-12 | Grayson | Virginia | 51077 | 1764 | 40 |
1709129 | 1709129 | 2021-09-11 | Grayson | Virginia | 51077 | 1764 | 40 |
1705882 | 1705882 | 2021-09-10 | Grayson | Virginia | 51077 | 1764 | 40 |
1702632 | 1702632 | 2021-09-09 | Grayson | Virginia | 51077 | 1751 | 40 |
1699383 | 1699383 | 2021-09-08 | Grayson | Virginia | 51077 | 1750 | 40 |
1696135 | 1696135 | 2021-09-07 | Grayson | Virginia | 51077 | 1732 | 40 |
1692887 | 1692887 | 2021-09-06 | Grayson | Virginia | 51077 | 1727 | 40 |
1689638 | 1689638 | 2021-09-05 | Grayson | Virginia | 51077 | 1703 | 40 |
1686388 | 1686388 | 2021-09-04 | Grayson | Virginia | 51077 | 1703 | 40 |
1683137 | 1683137 | 2021-09-03 | Grayson | Virginia | 51077 | 1703 | 40 |
1679887 | 1679887 | 2021-09-02 | Grayson | Virginia | 51077 | 1693 | 40 |
1676639 | 1676639 | 2021-09-01 | Grayson | Virginia | 51077 | 1682 | 40 |
1673392 | 1673392 | 2021-08-31 | Grayson | Virginia | 51077 | 1675 | 40 |
1670144 | 1670144 | 2021-08-30 | Grayson | Virginia | 51077 | 1665 | 40 |
1666897 | 1666897 | 2021-08-29 | Grayson | Virginia | 51077 | 1643 | 40 |
1663649 | 1663649 | 2021-08-28 | Grayson | Virginia | 51077 | 1643 | 40 |
1660401 | 1660401 | 2021-08-27 | Grayson | Virginia | 51077 | 1643 | 40 |
1657152 | 1657152 | 2021-08-26 | Grayson | Virginia | 51077 | 1637 | 40 |
1653905 | 1653905 | 2021-08-25 | Grayson | Virginia | 51077 | 1626 | 40 |
1650659 | 1650659 | 2021-08-24 | Grayson | Virginia | 51077 | 1617 | 40 |
1647410 | 1647410 | 2021-08-23 | Grayson | Virginia | 51077 | 1614 | 40 |
1644161 | 1644161 | 2021-08-22 | Grayson | Virginia | 51077 | 1594 | 40 |
1640911 | 1640911 | 2021-08-21 | Grayson | Virginia | 51077 | 1594 | 40 |
1637661 | 1637661 | 2021-08-20 | Grayson | Virginia | 51077 | 1594 | 40 |
1634411 | 1634411 | 2021-08-19 | Grayson | Virginia | 51077 | 1588 | 40 |
1631163 | 1631163 | 2021-08-18 | Grayson | Virginia | 51077 | 1583 | 40 |
1627916 | 1627916 | 2021-08-17 | Grayson | Virginia | 51077 | 1576 | 40 |
1624669 | 1624669 | 2021-08-16 | Grayson | Virginia | 51077 | 1575 | 40 |
1621422 | 1621422 | 2021-08-15 | Grayson | Virginia | 51077 | 1566 | 40 |
1618174 | 1618174 | 2021-08-14 | Grayson | Virginia | 51077 | 1566 | 40 |
1614926 | 1614926 | 2021-08-13 | Grayson | Virginia | 51077 | 1566 | 40 |
1611677 | 1611677 | 2021-08-12 | Grayson | Virginia | 51077 | 1562 | 40 |
1608430 | 1608430 | 2021-08-11 | Grayson | Virginia | 51077 | 1557 | 40 |
1605181 | 1605181 | 2021-08-10 | Grayson | Virginia | 51077 | 1553 | 40 |
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);