ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Sullivan" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815975 | 1815975 | 2021-10-14 | Sullivan | Tennessee | 47163 | 26226 | 413 |
1812727 | 1812727 | 2021-10-13 | Sullivan | Tennessee | 47163 | 26162 | 412 |
1809478 | 1809478 | 2021-10-12 | Sullivan | Tennessee | 47163 | 26075 | 409 |
1806228 | 1806228 | 2021-10-11 | Sullivan | Tennessee | 47163 | 26025 | 407 |
1802978 | 1802978 | 2021-10-10 | Sullivan | Tennessee | 47163 | 25880 | 403 |
1799729 | 1799729 | 2021-10-09 | Sullivan | Tennessee | 47163 | 25880 | 403 |
1796480 | 1796480 | 2021-10-08 | Sullivan | Tennessee | 47163 | 25880 | 403 |
1793231 | 1793231 | 2021-10-07 | Sullivan | Tennessee | 47163 | 25772 | 403 |
1789982 | 1789982 | 2021-10-06 | Sullivan | Tennessee | 47163 | 25691 | 400 |
1786734 | 1786734 | 2021-10-05 | Sullivan | Tennessee | 47163 | 25626 | 398 |
1783485 | 1783485 | 2021-10-04 | Sullivan | Tennessee | 47163 | 25587 | 394 |
1780236 | 1780236 | 2021-10-03 | Sullivan | Tennessee | 47163 | 25424 | 393 |
1776986 | 1776986 | 2021-10-02 | Sullivan | Tennessee | 47163 | 25424 | 393 |
1773736 | 1773736 | 2021-10-01 | Sullivan | Tennessee | 47163 | 25424 | 393 |
1770486 | 1770486 | 2021-09-30 | Sullivan | Tennessee | 47163 | 25347 | 391 |
1767237 | 1767237 | 2021-09-29 | Sullivan | Tennessee | 47163 | 25229 | 391 |
1763988 | 1763988 | 2021-09-28 | Sullivan | Tennessee | 47163 | 25163 | 388 |
1760739 | 1760739 | 2021-09-27 | Sullivan | Tennessee | 47163 | 25034 | 384 |
1757491 | 1757491 | 2021-09-26 | Sullivan | Tennessee | 47163 | 24861 | 384 |
1754243 | 1754243 | 2021-09-25 | Sullivan | Tennessee | 47163 | 24861 | 384 |
1750995 | 1750995 | 2021-09-24 | Sullivan | Tennessee | 47163 | 24861 | 384 |
1747746 | 1747746 | 2021-09-23 | Sullivan | Tennessee | 47163 | 24733 | 383 |
1744496 | 1744496 | 2021-09-22 | Sullivan | Tennessee | 47163 | 24603 | 382 |
1741247 | 1741247 | 2021-09-21 | Sullivan | Tennessee | 47163 | 24389 | 377 |
1737998 | 1737998 | 2021-09-20 | Sullivan | Tennessee | 47163 | 24389 | 377 |
1734748 | 1734748 | 2021-09-19 | Sullivan | Tennessee | 47163 | 24081 | 376 |
1731498 | 1731498 | 2021-09-18 | Sullivan | Tennessee | 47163 | 24081 | 376 |
1728248 | 1728248 | 2021-09-17 | Sullivan | Tennessee | 47163 | 24081 | 376 |
1724999 | 1724999 | 2021-09-16 | Sullivan | Tennessee | 47163 | 23921 | 373 |
1721750 | 1721750 | 2021-09-15 | Sullivan | Tennessee | 47163 | 23775 | 368 |
1718502 | 1718502 | 2021-09-14 | Sullivan | Tennessee | 47163 | 23605 | 365 |
1715254 | 1715254 | 2021-09-13 | Sullivan | Tennessee | 47163 | 23422 | 359 |
1712008 | 1712008 | 2021-09-12 | Sullivan | Tennessee | 47163 | 22746 | 356 |
1708761 | 1708761 | 2021-09-11 | Sullivan | Tennessee | 47163 | 22746 | 356 |
1705514 | 1705514 | 2021-09-10 | Sullivan | Tennessee | 47163 | 22746 | 356 |
1702264 | 1702264 | 2021-09-09 | Sullivan | Tennessee | 47163 | 22619 | 356 |
1699015 | 1699015 | 2021-09-08 | Sullivan | Tennessee | 47163 | 22525 | 355 |
1695767 | 1695767 | 2021-09-07 | Sullivan | Tennessee | 47163 | 22410 | 354 |
1692519 | 1692519 | 2021-09-06 | Sullivan | Tennessee | 47163 | 21658 | 348 |
1689270 | 1689270 | 2021-09-05 | Sullivan | Tennessee | 47163 | 21658 | 348 |
1686020 | 1686020 | 2021-09-04 | Sullivan | Tennessee | 47163 | 21658 | 348 |
1682769 | 1682769 | 2021-09-03 | Sullivan | Tennessee | 47163 | 21658 | 348 |
1679519 | 1679519 | 2021-09-02 | Sullivan | Tennessee | 47163 | 21504 | 347 |
1676271 | 1676271 | 2021-09-01 | Sullivan | Tennessee | 47163 | 21447 | 346 |
1673024 | 1673024 | 2021-08-31 | Sullivan | Tennessee | 47163 | 21187 | 345 |
1669776 | 1669776 | 2021-08-30 | Sullivan | Tennessee | 47163 | 21021 | 345 |
1666529 | 1666529 | 2021-08-29 | Sullivan | Tennessee | 47163 | 20565 | 339 |
1663281 | 1663281 | 2021-08-28 | Sullivan | Tennessee | 47163 | 20565 | 339 |
1660033 | 1660033 | 2021-08-27 | Sullivan | Tennessee | 47163 | 20565 | 339 |
1656784 | 1656784 | 2021-08-26 | Sullivan | Tennessee | 47163 | 20390 | 334 |
1653537 | 1653537 | 2021-08-25 | Sullivan | Tennessee | 47163 | 20051 | 330 |
1650290 | 1650290 | 2021-08-24 | Sullivan | Tennessee | 47163 | 20051 | 330 |
1647041 | 1647041 | 2021-08-23 | Sullivan | Tennessee | 47163 | 19935 | 329 |
1643792 | 1643792 | 2021-08-22 | Sullivan | Tennessee | 47163 | 19518 | 328 |
1640542 | 1640542 | 2021-08-21 | Sullivan | Tennessee | 47163 | 19518 | 328 |
1637292 | 1637292 | 2021-08-20 | Sullivan | Tennessee | 47163 | 19518 | 328 |
1634042 | 1634042 | 2021-08-19 | Sullivan | Tennessee | 47163 | 19372 | 328 |
1630795 | 1630795 | 2021-08-18 | Sullivan | Tennessee | 47163 | 19216 | 328 |
1627548 | 1627548 | 2021-08-17 | Sullivan | Tennessee | 47163 | 19072 | 328 |
1624301 | 1624301 | 2021-08-16 | Sullivan | Tennessee | 47163 | 18964 | 325 |
1621054 | 1621054 | 2021-08-15 | Sullivan | Tennessee | 47163 | 18698 | 323 |
1617806 | 1617806 | 2021-08-14 | Sullivan | Tennessee | 47163 | 18698 | 323 |
1614558 | 1614558 | 2021-08-13 | Sullivan | Tennessee | 47163 | 18698 | 323 |
1611309 | 1611309 | 2021-08-12 | Sullivan | Tennessee | 47163 | 18615 | 322 |
1608061 | 1608061 | 2021-08-11 | Sullivan | Tennessee | 47163 | 18493 | 320 |
1604812 | 1604812 | 2021-08-10 | Sullivan | Tennessee | 47163 | 18402 | 320 |
1601563 | 1601563 | 2021-08-09 | Sullivan | Tennessee | 47163 | 18313 | 318 |
1598315 | 1598315 | 2021-08-08 | Sullivan | Tennessee | 47163 | 18150 | 318 |
1595066 | 1595066 | 2021-08-07 | Sullivan | Tennessee | 47163 | 18150 | 318 |
1591817 | 1591817 | 2021-08-06 | Sullivan | Tennessee | 47163 | 18150 | 318 |
1588568 | 1588568 | 2021-08-05 | Sullivan | Tennessee | 47163 | 18075 | 318 |
1585318 | 1585318 | 2021-08-04 | Sullivan | Tennessee | 47163 | 18004 | 317 |
1582068 | 1582068 | 2021-08-03 | Sullivan | Tennessee | 47163 | 17919 | 317 |
1578819 | 1578819 | 2021-08-02 | Sullivan | Tennessee | 47163 | 17846 | 316 |
1575571 | 1575571 | 2021-08-01 | Sullivan | Tennessee | 47163 | 17750 | 316 |
1572323 | 1572323 | 2021-07-31 | Sullivan | Tennessee | 47163 | 17750 | 316 |
1569075 | 1569075 | 2021-07-30 | Sullivan | Tennessee | 47163 | 17750 | 316 |
1565827 | 1565827 | 2021-07-29 | Sullivan | Tennessee | 47163 | 17727 | 315 |
1562579 | 1562579 | 2021-07-28 | Sullivan | Tennessee | 47163 | 17700 | 315 |
1559331 | 1559331 | 2021-07-27 | Sullivan | Tennessee | 47163 | 17660 | 315 |
1556084 | 1556084 | 2021-07-26 | Sullivan | Tennessee | 47163 | 17613 | 314 |
1552837 | 1552837 | 2021-07-25 | Sullivan | Tennessee | 47163 | 17559 | 314 |
1549590 | 1549590 | 2021-07-24 | Sullivan | Tennessee | 47163 | 17559 | 314 |
1546343 | 1546343 | 2021-07-23 | Sullivan | Tennessee | 47163 | 17559 | 314 |
1543096 | 1543096 | 2021-07-22 | Sullivan | Tennessee | 47163 | 17550 | 313 |
1539848 | 1539848 | 2021-07-21 | Sullivan | Tennessee | 47163 | 17513 | 313 |
1536601 | 1536601 | 2021-07-20 | Sullivan | Tennessee | 47163 | 17506 | 313 |
1533353 | 1533353 | 2021-07-19 | Sullivan | Tennessee | 47163 | 17490 | 313 |
1530106 | 1530106 | 2021-07-18 | Sullivan | Tennessee | 47163 | 17459 | 313 |
1526859 | 1526859 | 2021-07-17 | Sullivan | Tennessee | 47163 | 17459 | 313 |
1523612 | 1523612 | 2021-07-16 | Sullivan | Tennessee | 47163 | 17459 | 313 |
1520364 | 1520364 | 2021-07-15 | Sullivan | Tennessee | 47163 | 17442 | 313 |
1517116 | 1517116 | 2021-07-14 | Sullivan | Tennessee | 47163 | 17428 | 313 |
1513869 | 1513869 | 2021-07-13 | Sullivan | Tennessee | 47163 | 17415 | 313 |
1510623 | 1510623 | 2021-07-12 | Sullivan | Tennessee | 47163 | 17402 | 313 |
1507376 | 1507376 | 2021-07-11 | Sullivan | Tennessee | 47163 | 17388 | 312 |
1504130 | 1504130 | 2021-07-10 | Sullivan | Tennessee | 47163 | 17388 | 312 |
1500884 | 1500884 | 2021-07-09 | Sullivan | Tennessee | 47163 | 17388 | 312 |
1497638 | 1497638 | 2021-07-08 | Sullivan | Tennessee | 47163 | 17382 | 311 |
1494391 | 1494391 | 2021-07-07 | Sullivan | Tennessee | 47163 | 17370 | 310 |
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);