ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Campbell" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815900 | 1815900 | 2021-10-14 | Campbell | Tennessee | 47013 | 6953 | 79 |
1812652 | 1812652 | 2021-10-13 | Campbell | Tennessee | 47013 | 6923 | 79 |
1809403 | 1809403 | 2021-10-12 | Campbell | Tennessee | 47013 | 6892 | 78 |
1806153 | 1806153 | 2021-10-11 | Campbell | Tennessee | 47013 | 6842 | 75 |
1802903 | 1802903 | 2021-10-10 | Campbell | Tennessee | 47013 | 6790 | 75 |
1799654 | 1799654 | 2021-10-09 | Campbell | Tennessee | 47013 | 6790 | 75 |
1796405 | 1796405 | 2021-10-08 | Campbell | Tennessee | 47013 | 6790 | 75 |
1793156 | 1793156 | 2021-10-07 | Campbell | Tennessee | 47013 | 6741 | 74 |
1789907 | 1789907 | 2021-10-06 | Campbell | Tennessee | 47013 | 6707 | 73 |
1786659 | 1786659 | 2021-10-05 | Campbell | Tennessee | 47013 | 6670 | 72 |
1783410 | 1783410 | 2021-10-04 | Campbell | Tennessee | 47013 | 6656 | 72 |
1780161 | 1780161 | 2021-10-03 | Campbell | Tennessee | 47013 | 6568 | 71 |
1776911 | 1776911 | 2021-10-02 | Campbell | Tennessee | 47013 | 6568 | 71 |
1773661 | 1773661 | 2021-10-01 | Campbell | Tennessee | 47013 | 6568 | 71 |
1770411 | 1770411 | 2021-09-30 | Campbell | Tennessee | 47013 | 6528 | 71 |
1767162 | 1767162 | 2021-09-29 | Campbell | Tennessee | 47013 | 6463 | 71 |
1763913 | 1763913 | 2021-09-28 | Campbell | Tennessee | 47013 | 6426 | 71 |
1760664 | 1760664 | 2021-09-27 | Campbell | Tennessee | 47013 | 6384 | 71 |
1757416 | 1757416 | 2021-09-26 | Campbell | Tennessee | 47013 | 6197 | 70 |
1754168 | 1754168 | 2021-09-25 | Campbell | Tennessee | 47013 | 6197 | 70 |
1750920 | 1750920 | 2021-09-24 | Campbell | Tennessee | 47013 | 6197 | 70 |
1747671 | 1747671 | 2021-09-23 | Campbell | Tennessee | 47013 | 6072 | 70 |
1744421 | 1744421 | 2021-09-22 | Campbell | Tennessee | 47013 | 6030 | 70 |
1741172 | 1741172 | 2021-09-21 | Campbell | Tennessee | 47013 | 5984 | 70 |
1737923 | 1737923 | 2021-09-20 | Campbell | Tennessee | 47013 | 5984 | 70 |
1734673 | 1734673 | 2021-09-19 | Campbell | Tennessee | 47013 | 5888 | 70 |
1731423 | 1731423 | 2021-09-18 | Campbell | Tennessee | 47013 | 5888 | 70 |
1728173 | 1728173 | 2021-09-17 | Campbell | Tennessee | 47013 | 5888 | 70 |
1724924 | 1724924 | 2021-09-16 | Campbell | Tennessee | 47013 | 5794 | 70 |
1721675 | 1721675 | 2021-09-15 | Campbell | Tennessee | 47013 | 5713 | 70 |
1718427 | 1718427 | 2021-09-14 | Campbell | Tennessee | 47013 | 5633 | 69 |
1715179 | 1715179 | 2021-09-13 | Campbell | Tennessee | 47013 | 5579 | 69 |
1711933 | 1711933 | 2021-09-12 | Campbell | Tennessee | 47013 | 5422 | 68 |
1708686 | 1708686 | 2021-09-11 | Campbell | Tennessee | 47013 | 5422 | 68 |
1705439 | 1705439 | 2021-09-10 | Campbell | Tennessee | 47013 | 5422 | 68 |
1702189 | 1702189 | 2021-09-09 | Campbell | Tennessee | 47013 | 5360 | 68 |
1698940 | 1698940 | 2021-09-08 | Campbell | Tennessee | 47013 | 5314 | 67 |
1695692 | 1695692 | 2021-09-07 | Campbell | Tennessee | 47013 | 5304 | 67 |
1692444 | 1692444 | 2021-09-06 | Campbell | Tennessee | 47013 | 5090 | 66 |
1689195 | 1689195 | 2021-09-05 | Campbell | Tennessee | 47013 | 5090 | 66 |
1685945 | 1685945 | 2021-09-04 | Campbell | Tennessee | 47013 | 5090 | 66 |
1682694 | 1682694 | 2021-09-03 | Campbell | Tennessee | 47013 | 5090 | 66 |
1679444 | 1679444 | 2021-09-02 | Campbell | Tennessee | 47013 | 5080 | 66 |
1676196 | 1676196 | 2021-09-01 | Campbell | Tennessee | 47013 | 5016 | 66 |
1672949 | 1672949 | 2021-08-31 | Campbell | Tennessee | 47013 | 4973 | 66 |
1669701 | 1669701 | 2021-08-30 | Campbell | Tennessee | 47013 | 4952 | 66 |
1666454 | 1666454 | 2021-08-29 | Campbell | Tennessee | 47013 | 4851 | 66 |
1663206 | 1663206 | 2021-08-28 | Campbell | Tennessee | 47013 | 4851 | 66 |
1659958 | 1659958 | 2021-08-27 | Campbell | Tennessee | 47013 | 4851 | 66 |
1656709 | 1656709 | 2021-08-26 | Campbell | Tennessee | 47013 | 4829 | 66 |
1653462 | 1653462 | 2021-08-25 | Campbell | Tennessee | 47013 | 4768 | 64 |
1650215 | 1650215 | 2021-08-24 | Campbell | Tennessee | 47013 | 4768 | 64 |
1646966 | 1646966 | 2021-08-23 | Campbell | Tennessee | 47013 | 4738 | 64 |
1643717 | 1643717 | 2021-08-22 | Campbell | Tennessee | 47013 | 4658 | 64 |
1640467 | 1640467 | 2021-08-21 | Campbell | Tennessee | 47013 | 4658 | 64 |
1637217 | 1637217 | 2021-08-20 | Campbell | Tennessee | 47013 | 4658 | 64 |
1633967 | 1633967 | 2021-08-19 | Campbell | Tennessee | 47013 | 4613 | 64 |
1630720 | 1630720 | 2021-08-18 | Campbell | Tennessee | 47013 | 4594 | 64 |
1627473 | 1627473 | 2021-08-17 | Campbell | Tennessee | 47013 | 4576 | 64 |
1624226 | 1624226 | 2021-08-16 | Campbell | Tennessee | 47013 | 4519 | 64 |
1620979 | 1620979 | 2021-08-15 | Campbell | Tennessee | 47013 | 4460 | 64 |
1617731 | 1617731 | 2021-08-14 | Campbell | Tennessee | 47013 | 4460 | 64 |
1614483 | 1614483 | 2021-08-13 | Campbell | Tennessee | 47013 | 4460 | 64 |
1611234 | 1611234 | 2021-08-12 | Campbell | Tennessee | 47013 | 4442 | 64 |
1607986 | 1607986 | 2021-08-11 | Campbell | Tennessee | 47013 | 4413 | 64 |
1604737 | 1604737 | 2021-08-10 | Campbell | Tennessee | 47013 | 4396 | 64 |
1601488 | 1601488 | 2021-08-09 | Campbell | Tennessee | 47013 | 4379 | 64 |
1598240 | 1598240 | 2021-08-08 | Campbell | Tennessee | 47013 | 4352 | 64 |
1594991 | 1594991 | 2021-08-07 | Campbell | Tennessee | 47013 | 4352 | 64 |
1591742 | 1591742 | 2021-08-06 | Campbell | Tennessee | 47013 | 4352 | 64 |
1588493 | 1588493 | 2021-08-05 | Campbell | Tennessee | 47013 | 4326 | 62 |
1585243 | 1585243 | 2021-08-04 | Campbell | Tennessee | 47013 | 4306 | 62 |
1581993 | 1581993 | 2021-08-03 | Campbell | Tennessee | 47013 | 4306 | 62 |
1578744 | 1578744 | 2021-08-02 | Campbell | Tennessee | 47013 | 4299 | 62 |
1575496 | 1575496 | 2021-08-01 | Campbell | Tennessee | 47013 | 4282 | 62 |
1572248 | 1572248 | 2021-07-31 | Campbell | Tennessee | 47013 | 4282 | 62 |
1569000 | 1569000 | 2021-07-30 | Campbell | Tennessee | 47013 | 4282 | 62 |
1565752 | 1565752 | 2021-07-29 | Campbell | Tennessee | 47013 | 4269 | 62 |
1562504 | 1562504 | 2021-07-28 | Campbell | Tennessee | 47013 | 4264 | 62 |
1559256 | 1559256 | 2021-07-27 | Campbell | Tennessee | 47013 | 4256 | 62 |
1556009 | 1556009 | 2021-07-26 | Campbell | Tennessee | 47013 | 4251 | 62 |
1552762 | 1552762 | 2021-07-25 | Campbell | Tennessee | 47013 | 4235 | 62 |
1549515 | 1549515 | 2021-07-24 | Campbell | Tennessee | 47013 | 4235 | 62 |
1546268 | 1546268 | 2021-07-23 | Campbell | Tennessee | 47013 | 4235 | 62 |
1543021 | 1543021 | 2021-07-22 | Campbell | Tennessee | 47013 | 4235 | 62 |
1539773 | 1539773 | 2021-07-21 | Campbell | Tennessee | 47013 | 4233 | 62 |
1536526 | 1536526 | 2021-07-20 | Campbell | Tennessee | 47013 | 4230 | 62 |
1533278 | 1533278 | 2021-07-19 | Campbell | Tennessee | 47013 | 4226 | 62 |
1530031 | 1530031 | 2021-07-18 | Campbell | Tennessee | 47013 | 4218 | 62 |
1526784 | 1526784 | 2021-07-17 | Campbell | Tennessee | 47013 | 4218 | 62 |
1523537 | 1523537 | 2021-07-16 | Campbell | Tennessee | 47013 | 4218 | 62 |
1520289 | 1520289 | 2021-07-15 | Campbell | Tennessee | 47013 | 4219 | 62 |
1517041 | 1517041 | 2021-07-14 | Campbell | Tennessee | 47013 | 4218 | 62 |
1513794 | 1513794 | 2021-07-13 | Campbell | Tennessee | 47013 | 4218 | 62 |
1510548 | 1510548 | 2021-07-12 | Campbell | Tennessee | 47013 | 4216 | 62 |
1507301 | 1507301 | 2021-07-11 | Campbell | Tennessee | 47013 | 4212 | 62 |
1504055 | 1504055 | 2021-07-10 | Campbell | Tennessee | 47013 | 4212 | 62 |
1500809 | 1500809 | 2021-07-09 | Campbell | Tennessee | 47013 | 4212 | 62 |
1497563 | 1497563 | 2021-07-08 | Campbell | Tennessee | 47013 | 4207 | 62 |
1494316 | 1494316 | 2021-07-07 | Campbell | Tennessee | 47013 | 4200 | 62 |
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);