ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Dickson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815915 | 1815915 | 2021-10-14 | Dickson | Tennessee | 47043 | 10221 | 160 |
1812667 | 1812667 | 2021-10-13 | Dickson | Tennessee | 47043 | 10201 | 160 |
1809418 | 1809418 | 2021-10-12 | Dickson | Tennessee | 47043 | 10186 | 160 |
1806168 | 1806168 | 2021-10-11 | Dickson | Tennessee | 47043 | 10130 | 159 |
1802918 | 1802918 | 2021-10-10 | Dickson | Tennessee | 47043 | 10084 | 159 |
1799669 | 1799669 | 2021-10-09 | Dickson | Tennessee | 47043 | 10084 | 159 |
1796420 | 1796420 | 2021-10-08 | Dickson | Tennessee | 47043 | 10084 | 159 |
1793171 | 1793171 | 2021-10-07 | Dickson | Tennessee | 47043 | 10051 | 159 |
1789922 | 1789922 | 2021-10-06 | Dickson | Tennessee | 47043 | 10044 | 159 |
1786674 | 1786674 | 2021-10-05 | Dickson | Tennessee | 47043 | 10040 | 159 |
1783425 | 1783425 | 2021-10-04 | Dickson | Tennessee | 47043 | 10035 | 159 |
1780176 | 1780176 | 2021-10-03 | Dickson | Tennessee | 47043 | 9991 | 159 |
1776926 | 1776926 | 2021-10-02 | Dickson | Tennessee | 47043 | 9991 | 159 |
1773676 | 1773676 | 2021-10-01 | Dickson | Tennessee | 47043 | 9991 | 159 |
1770426 | 1770426 | 2021-09-30 | Dickson | Tennessee | 47043 | 9958 | 159 |
1767177 | 1767177 | 2021-09-29 | Dickson | Tennessee | 47043 | 9925 | 158 |
1763928 | 1763928 | 2021-09-28 | Dickson | Tennessee | 47043 | 9862 | 157 |
1760679 | 1760679 | 2021-09-27 | Dickson | Tennessee | 47043 | 9836 | 157 |
1757431 | 1757431 | 2021-09-26 | Dickson | Tennessee | 47043 | 9788 | 154 |
1754183 | 1754183 | 2021-09-25 | Dickson | Tennessee | 47043 | 9788 | 154 |
1750935 | 1750935 | 2021-09-24 | Dickson | Tennessee | 47043 | 9788 | 154 |
1747686 | 1747686 | 2021-09-23 | Dickson | Tennessee | 47043 | 9737 | 154 |
1744436 | 1744436 | 2021-09-22 | Dickson | Tennessee | 47043 | 9699 | 153 |
1741187 | 1741187 | 2021-09-21 | Dickson | Tennessee | 47043 | 9596 | 147 |
1737938 | 1737938 | 2021-09-20 | Dickson | Tennessee | 47043 | 9596 | 147 |
1734688 | 1734688 | 2021-09-19 | Dickson | Tennessee | 47043 | 9494 | 147 |
1731438 | 1731438 | 2021-09-18 | Dickson | Tennessee | 47043 | 9494 | 147 |
1728188 | 1728188 | 2021-09-17 | Dickson | Tennessee | 47043 | 9494 | 147 |
1724939 | 1724939 | 2021-09-16 | Dickson | Tennessee | 47043 | 9441 | 145 |
1721690 | 1721690 | 2021-09-15 | Dickson | Tennessee | 47043 | 9396 | 143 |
1718442 | 1718442 | 2021-09-14 | Dickson | Tennessee | 47043 | 9327 | 140 |
1715194 | 1715194 | 2021-09-13 | Dickson | Tennessee | 47043 | 9287 | 139 |
1711948 | 1711948 | 2021-09-12 | Dickson | Tennessee | 47043 | 9004 | 136 |
1708701 | 1708701 | 2021-09-11 | Dickson | Tennessee | 47043 | 9004 | 136 |
1705454 | 1705454 | 2021-09-10 | Dickson | Tennessee | 47043 | 9004 | 136 |
1702204 | 1702204 | 2021-09-09 | Dickson | Tennessee | 47043 | 8966 | 136 |
1698955 | 1698955 | 2021-09-08 | Dickson | Tennessee | 47043 | 8927 | 136 |
1695707 | 1695707 | 2021-09-07 | Dickson | Tennessee | 47043 | 8883 | 136 |
1692459 | 1692459 | 2021-09-06 | Dickson | Tennessee | 47043 | 8543 | 136 |
1689210 | 1689210 | 2021-09-05 | Dickson | Tennessee | 47043 | 8543 | 136 |
1685960 | 1685960 | 2021-09-04 | Dickson | Tennessee | 47043 | 8543 | 136 |
1682709 | 1682709 | 2021-09-03 | Dickson | Tennessee | 47043 | 8543 | 136 |
1679459 | 1679459 | 2021-09-02 | Dickson | Tennessee | 47043 | 8490 | 136 |
1676211 | 1676211 | 2021-09-01 | Dickson | Tennessee | 47043 | 8452 | 136 |
1672964 | 1672964 | 2021-08-31 | Dickson | Tennessee | 47043 | 8391 | 133 |
1669716 | 1669716 | 2021-08-30 | Dickson | Tennessee | 47043 | 8299 | 133 |
1666469 | 1666469 | 2021-08-29 | Dickson | Tennessee | 47043 | 8105 | 131 |
1663221 | 1663221 | 2021-08-28 | Dickson | Tennessee | 47043 | 8105 | 131 |
1659973 | 1659973 | 2021-08-27 | Dickson | Tennessee | 47043 | 8105 | 131 |
1656724 | 1656724 | 2021-08-26 | Dickson | Tennessee | 47043 | 8060 | 131 |
1653477 | 1653477 | 2021-08-25 | Dickson | Tennessee | 47043 | 7982 | 130 |
1650230 | 1650230 | 2021-08-24 | Dickson | Tennessee | 47043 | 7982 | 130 |
1646981 | 1646981 | 2021-08-23 | Dickson | Tennessee | 47043 | 7945 | 130 |
1643732 | 1643732 | 2021-08-22 | Dickson | Tennessee | 47043 | 7831 | 123 |
1640482 | 1640482 | 2021-08-21 | Dickson | Tennessee | 47043 | 7831 | 123 |
1637232 | 1637232 | 2021-08-20 | Dickson | Tennessee | 47043 | 7831 | 123 |
1633982 | 1633982 | 2021-08-19 | Dickson | Tennessee | 47043 | 7771 | 122 |
1630735 | 1630735 | 2021-08-18 | Dickson | Tennessee | 47043 | 7696 | 121 |
1627488 | 1627488 | 2021-08-17 | Dickson | Tennessee | 47043 | 7658 | 121 |
1624241 | 1624241 | 2021-08-16 | Dickson | Tennessee | 47043 | 7641 | 119 |
1620994 | 1620994 | 2021-08-15 | Dickson | Tennessee | 47043 | 7572 | 118 |
1617746 | 1617746 | 2021-08-14 | Dickson | Tennessee | 47043 | 7572 | 118 |
1614498 | 1614498 | 2021-08-13 | Dickson | Tennessee | 47043 | 7572 | 118 |
1611249 | 1611249 | 2021-08-12 | Dickson | Tennessee | 47043 | 7543 | 118 |
1608001 | 1608001 | 2021-08-11 | Dickson | Tennessee | 47043 | 7513 | 116 |
1604752 | 1604752 | 2021-08-10 | Dickson | Tennessee | 47043 | 7479 | 116 |
1601503 | 1601503 | 2021-08-09 | Dickson | Tennessee | 47043 | 7469 | 116 |
1598255 | 1598255 | 2021-08-08 | Dickson | Tennessee | 47043 | 7398 | 116 |
1595006 | 1595006 | 2021-08-07 | Dickson | Tennessee | 47043 | 7398 | 116 |
1591757 | 1591757 | 2021-08-06 | Dickson | Tennessee | 47043 | 7398 | 116 |
1588508 | 1588508 | 2021-08-05 | Dickson | Tennessee | 47043 | 7363 | 116 |
1585258 | 1585258 | 2021-08-04 | Dickson | Tennessee | 47043 | 7328 | 116 |
1582008 | 1582008 | 2021-08-03 | Dickson | Tennessee | 47043 | 7312 | 115 |
1578759 | 1578759 | 2021-08-02 | Dickson | Tennessee | 47043 | 7300 | 115 |
1575511 | 1575511 | 2021-08-01 | Dickson | Tennessee | 47043 | 7266 | 115 |
1572263 | 1572263 | 2021-07-31 | Dickson | Tennessee | 47043 | 7266 | 115 |
1569015 | 1569015 | 2021-07-30 | Dickson | Tennessee | 47043 | 7266 | 115 |
1565767 | 1565767 | 2021-07-29 | Dickson | Tennessee | 47043 | 7254 | 115 |
1562519 | 1562519 | 2021-07-28 | Dickson | Tennessee | 47043 | 7243 | 115 |
1559271 | 1559271 | 2021-07-27 | Dickson | Tennessee | 47043 | 7233 | 115 |
1556024 | 1556024 | 2021-07-26 | Dickson | Tennessee | 47043 | 7223 | 115 |
1552777 | 1552777 | 2021-07-25 | Dickson | Tennessee | 47043 | 7192 | 115 |
1549530 | 1549530 | 2021-07-24 | Dickson | Tennessee | 47043 | 7192 | 115 |
1546283 | 1546283 | 2021-07-23 | Dickson | Tennessee | 47043 | 7192 | 115 |
1543036 | 1543036 | 2021-07-22 | Dickson | Tennessee | 47043 | 7177 | 115 |
1539788 | 1539788 | 2021-07-21 | Dickson | Tennessee | 47043 | 7160 | 115 |
1536541 | 1536541 | 2021-07-20 | Dickson | Tennessee | 47043 | 7153 | 115 |
1533293 | 1533293 | 2021-07-19 | Dickson | Tennessee | 47043 | 7145 | 115 |
1530046 | 1530046 | 2021-07-18 | Dickson | Tennessee | 47043 | 7135 | 115 |
1526799 | 1526799 | 2021-07-17 | Dickson | Tennessee | 47043 | 7135 | 115 |
1523552 | 1523552 | 2021-07-16 | Dickson | Tennessee | 47043 | 7135 | 115 |
1520304 | 1520304 | 2021-07-15 | Dickson | Tennessee | 47043 | 7128 | 115 |
1517056 | 1517056 | 2021-07-14 | Dickson | Tennessee | 47043 | 7128 | 115 |
1513809 | 1513809 | 2021-07-13 | Dickson | Tennessee | 47043 | 7125 | 115 |
1510563 | 1510563 | 2021-07-12 | Dickson | Tennessee | 47043 | 7120 | 115 |
1507316 | 1507316 | 2021-07-11 | Dickson | Tennessee | 47043 | 7118 | 115 |
1504070 | 1504070 | 2021-07-10 | Dickson | Tennessee | 47043 | 7118 | 115 |
1500824 | 1500824 | 2021-07-09 | Dickson | Tennessee | 47043 | 7118 | 115 |
1497578 | 1497578 | 2021-07-08 | Dickson | Tennessee | 47043 | 7116 | 115 |
1494331 | 1494331 | 2021-07-07 | Dickson | Tennessee | 47043 | 7115 | 115 |
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);