ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Franklin" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1816335 | 1816335 | 2021-10-14 | Franklin | Virginia | 51067 | 5822 | 98 |
1813087 | 1813087 | 2021-10-13 | Franklin | Virginia | 51067 | 5800 | 98 |
1809838 | 1809838 | 2021-10-12 | Franklin | Virginia | 51067 | 5779 | 96 |
1806588 | 1806588 | 2021-10-11 | Franklin | Virginia | 51067 | 5724 | 96 |
1803338 | 1803338 | 2021-10-10 | Franklin | Virginia | 51067 | 5724 | 96 |
1800089 | 1800089 | 2021-10-09 | Franklin | Virginia | 51067 | 5724 | 96 |
1796840 | 1796840 | 2021-10-08 | Franklin | Virginia | 51067 | 5724 | 96 |
1793591 | 1793591 | 2021-10-07 | Franklin | Virginia | 51067 | 5706 | 96 |
1790342 | 1790342 | 2021-10-06 | Franklin | Virginia | 51067 | 5674 | 96 |
1787094 | 1787094 | 2021-10-05 | Franklin | Virginia | 51067 | 5644 | 94 |
1783845 | 1783845 | 2021-10-04 | Franklin | Virginia | 51067 | 5639 | 94 |
1780596 | 1780596 | 2021-10-03 | Franklin | Virginia | 51067 | 5554 | 93 |
1777346 | 1777346 | 2021-10-02 | Franklin | Virginia | 51067 | 5554 | 93 |
1774096 | 1774096 | 2021-10-01 | Franklin | Virginia | 51067 | 5554 | 93 |
1770846 | 1770846 | 2021-09-30 | Franklin | Virginia | 51067 | 5537 | 93 |
1767597 | 1767597 | 2021-09-29 | Franklin | Virginia | 51067 | 5526 | 93 |
1764348 | 1764348 | 2021-09-28 | Franklin | Virginia | 51067 | 5500 | 93 |
1761099 | 1761099 | 2021-09-27 | Franklin | Virginia | 51067 | 5487 | 93 |
1757851 | 1757851 | 2021-09-26 | Franklin | Virginia | 51067 | 5430 | 91 |
1754603 | 1754603 | 2021-09-25 | Franklin | Virginia | 51067 | 5430 | 91 |
1751355 | 1751355 | 2021-09-24 | Franklin | Virginia | 51067 | 5430 | 91 |
1748106 | 1748106 | 2021-09-23 | Franklin | Virginia | 51067 | 5342 | 90 |
1744856 | 1744856 | 2021-09-22 | Franklin | Virginia | 51067 | 5320 | 90 |
1741607 | 1741607 | 2021-09-21 | Franklin | Virginia | 51067 | 5292 | 90 |
1738358 | 1738358 | 2021-09-20 | Franklin | Virginia | 51067 | 5268 | 90 |
1735109 | 1735109 | 2021-09-19 | Franklin | Virginia | 51067 | 5204 | 87 |
1731859 | 1731859 | 2021-09-18 | Franklin | Virginia | 51067 | 5204 | 87 |
1728609 | 1728609 | 2021-09-17 | Franklin | Virginia | 51067 | 5204 | 87 |
1725359 | 1725359 | 2021-09-16 | Franklin | Virginia | 51067 | 5160 | 87 |
1722110 | 1722110 | 2021-09-15 | Franklin | Virginia | 51067 | 5142 | 87 |
1718862 | 1718862 | 2021-09-14 | Franklin | Virginia | 51067 | 5120 | 86 |
1715614 | 1715614 | 2021-09-13 | Franklin | Virginia | 51067 | 5094 | 86 |
1712368 | 1712368 | 2021-09-12 | Franklin | Virginia | 51067 | 5034 | 84 |
1709121 | 1709121 | 2021-09-11 | Franklin | Virginia | 51067 | 5034 | 84 |
1705874 | 1705874 | 2021-09-10 | Franklin | Virginia | 51067 | 5034 | 84 |
1702624 | 1702624 | 2021-09-09 | Franklin | Virginia | 51067 | 5020 | 84 |
1699375 | 1699375 | 2021-09-08 | Franklin | Virginia | 51067 | 5001 | 84 |
1696127 | 1696127 | 2021-09-07 | Franklin | Virginia | 51067 | 4948 | 84 |
1692879 | 1692879 | 2021-09-06 | Franklin | Virginia | 51067 | 4926 | 84 |
1689630 | 1689630 | 2021-09-05 | Franklin | Virginia | 51067 | 4856 | 84 |
1686380 | 1686380 | 2021-09-04 | Franklin | Virginia | 51067 | 4856 | 84 |
1683129 | 1683129 | 2021-09-03 | Franklin | Virginia | 51067 | 4856 | 84 |
1679879 | 1679879 | 2021-09-02 | Franklin | Virginia | 51067 | 4830 | 84 |
1676631 | 1676631 | 2021-09-01 | Franklin | Virginia | 51067 | 4788 | 84 |
1673384 | 1673384 | 2021-08-31 | Franklin | Virginia | 51067 | 4752 | 84 |
1670136 | 1670136 | 2021-08-30 | Franklin | Virginia | 51067 | 4718 | 84 |
1666889 | 1666889 | 2021-08-29 | Franklin | Virginia | 51067 | 4650 | 83 |
1663641 | 1663641 | 2021-08-28 | Franklin | Virginia | 51067 | 4650 | 83 |
1660393 | 1660393 | 2021-08-27 | Franklin | Virginia | 51067 | 4650 | 83 |
1657144 | 1657144 | 2021-08-26 | Franklin | Virginia | 51067 | 4625 | 83 |
1653897 | 1653897 | 2021-08-25 | Franklin | Virginia | 51067 | 4589 | 83 |
1650651 | 1650651 | 2021-08-24 | Franklin | Virginia | 51067 | 4564 | 83 |
1647402 | 1647402 | 2021-08-23 | Franklin | Virginia | 51067 | 4546 | 83 |
1644153 | 1644153 | 2021-08-22 | Franklin | Virginia | 51067 | 4488 | 83 |
1640903 | 1640903 | 2021-08-21 | Franklin | Virginia | 51067 | 4488 | 83 |
1637653 | 1637653 | 2021-08-20 | Franklin | Virginia | 51067 | 4488 | 83 |
1634403 | 1634403 | 2021-08-19 | Franklin | Virginia | 51067 | 4466 | 83 |
1631155 | 1631155 | 2021-08-18 | Franklin | Virginia | 51067 | 4448 | 83 |
1627908 | 1627908 | 2021-08-17 | Franklin | Virginia | 51067 | 4430 | 83 |
1624661 | 1624661 | 2021-08-16 | Franklin | Virginia | 51067 | 4422 | 83 |
1621414 | 1621414 | 2021-08-15 | Franklin | Virginia | 51067 | 4370 | 83 |
1618166 | 1618166 | 2021-08-14 | Franklin | Virginia | 51067 | 4370 | 83 |
1614918 | 1614918 | 2021-08-13 | Franklin | Virginia | 51067 | 4370 | 83 |
1611669 | 1611669 | 2021-08-12 | Franklin | Virginia | 51067 | 4347 | 83 |
1608422 | 1608422 | 2021-08-11 | Franklin | Virginia | 51067 | 4327 | 83 |
1605173 | 1605173 | 2021-08-10 | Franklin | Virginia | 51067 | 4310 | 83 |
1601923 | 1601923 | 2021-08-09 | Franklin | Virginia | 51067 | 4304 | 83 |
1598675 | 1598675 | 2021-08-08 | Franklin | Virginia | 51067 | 4261 | 83 |
1595426 | 1595426 | 2021-08-07 | Franklin | Virginia | 51067 | 4261 | 83 |
1592177 | 1592177 | 2021-08-06 | Franklin | Virginia | 51067 | 4261 | 83 |
1588928 | 1588928 | 2021-08-05 | Franklin | Virginia | 51067 | 4248 | 83 |
1585679 | 1585679 | 2021-08-04 | Franklin | Virginia | 51067 | 4234 | 83 |
1582429 | 1582429 | 2021-08-03 | Franklin | Virginia | 51067 | 4222 | 83 |
1579179 | 1579179 | 2021-08-02 | Franklin | Virginia | 51067 | 4214 | 83 |
1575931 | 1575931 | 2021-08-01 | Franklin | Virginia | 51067 | 4186 | 83 |
1572683 | 1572683 | 2021-07-31 | Franklin | Virginia | 51067 | 4186 | 83 |
1569435 | 1569435 | 2021-07-30 | Franklin | Virginia | 51067 | 4186 | 83 |
1566187 | 1566187 | 2021-07-29 | Franklin | Virginia | 51067 | 4176 | 83 |
1562939 | 1562939 | 2021-07-28 | Franklin | Virginia | 51067 | 4175 | 83 |
1559691 | 1559691 | 2021-07-27 | Franklin | Virginia | 51067 | 4168 | 83 |
1556444 | 1556444 | 2021-07-26 | Franklin | Virginia | 51067 | 4158 | 83 |
1553197 | 1553197 | 2021-07-25 | Franklin | Virginia | 51067 | 4153 | 83 |
1549950 | 1549950 | 2021-07-24 | Franklin | Virginia | 51067 | 4153 | 83 |
1546703 | 1546703 | 2021-07-23 | Franklin | Virginia | 51067 | 4153 | 83 |
1543456 | 1543456 | 2021-07-22 | Franklin | Virginia | 51067 | 4149 | 83 |
1540208 | 1540208 | 2021-07-21 | Franklin | Virginia | 51067 | 4146 | 83 |
1536961 | 1536961 | 2021-07-20 | Franklin | Virginia | 51067 | 4145 | 83 |
1533713 | 1533713 | 2021-07-19 | Franklin | Virginia | 51067 | 4142 | 83 |
1530466 | 1530466 | 2021-07-18 | Franklin | Virginia | 51067 | 4130 | 82 |
1527219 | 1527219 | 2021-07-17 | Franklin | Virginia | 51067 | 4130 | 82 |
1523972 | 1523972 | 2021-07-16 | Franklin | Virginia | 51067 | 4130 | 82 |
1520724 | 1520724 | 2021-07-15 | Franklin | Virginia | 51067 | 4129 | 82 |
1517476 | 1517476 | 2021-07-14 | Franklin | Virginia | 51067 | 4129 | 82 |
1514229 | 1514229 | 2021-07-13 | Franklin | Virginia | 51067 | 4127 | 82 |
1510983 | 1510983 | 2021-07-12 | Franklin | Virginia | 51067 | 4125 | 82 |
1507736 | 1507736 | 2021-07-11 | Franklin | Virginia | 51067 | 4125 | 82 |
1504490 | 1504490 | 2021-07-10 | Franklin | Virginia | 51067 | 4124 | 82 |
1501244 | 1501244 | 2021-07-09 | Franklin | Virginia | 51067 | 4121 | 82 |
1497998 | 1497998 | 2021-07-08 | Franklin | Virginia | 51067 | 4121 | 81 |
1494751 | 1494751 | 2021-07-07 | Franklin | Virginia | 51067 | 4120 | 81 |
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);