ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 47149 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718495 | 1718495 | 2021-09-14 | Rutherford | Tennessee | 47149 | 56834 | 483 |
1715247 | 1715247 | 2021-09-13 | Rutherford | Tennessee | 47149 | 56648 | 479 |
1712001 | 1712001 | 2021-09-12 | Rutherford | Tennessee | 47149 | 55172 | 478 |
1708754 | 1708754 | 2021-09-11 | Rutherford | Tennessee | 47149 | 55172 | 478 |
1705507 | 1705507 | 2021-09-10 | Rutherford | Tennessee | 47149 | 55172 | 478 |
1702257 | 1702257 | 2021-09-09 | Rutherford | Tennessee | 47149 | 54973 | 478 |
1699008 | 1699008 | 2021-09-08 | Rutherford | Tennessee | 47149 | 54731 | 475 |
1695760 | 1695760 | 2021-09-07 | Rutherford | Tennessee | 47149 | 54545 | 475 |
1692512 | 1692512 | 2021-09-06 | Rutherford | Tennessee | 47149 | 52410 | 475 |
1689263 | 1689263 | 2021-09-05 | Rutherford | Tennessee | 47149 | 52410 | 475 |
1686013 | 1686013 | 2021-09-04 | Rutherford | Tennessee | 47149 | 52410 | 475 |
1682762 | 1682762 | 2021-09-03 | Rutherford | Tennessee | 47149 | 52410 | 475 |
1679512 | 1679512 | 2021-09-02 | Rutherford | Tennessee | 47149 | 52186 | 474 |
1676264 | 1676264 | 2021-09-01 | Rutherford | Tennessee | 47149 | 52127 | 473 |
1673017 | 1673017 | 2021-08-31 | Rutherford | Tennessee | 47149 | 51683 | 473 |
1669769 | 1669769 | 2021-08-30 | Rutherford | Tennessee | 47149 | 51144 | 471 |
1666522 | 1666522 | 2021-08-29 | Rutherford | Tennessee | 47149 | 50229 | 470 |
1663274 | 1663274 | 2021-08-28 | Rutherford | Tennessee | 47149 | 50229 | 470 |
1660026 | 1660026 | 2021-08-27 | Rutherford | Tennessee | 47149 | 50229 | 470 |
1656777 | 1656777 | 2021-08-26 | Rutherford | Tennessee | 47149 | 49845 | 468 |
1653530 | 1653530 | 2021-08-25 | Rutherford | Tennessee | 47149 | 49384 | 466 |
1650283 | 1650283 | 2021-08-24 | Rutherford | Tennessee | 47149 | 49384 | 466 |
1647034 | 1647034 | 2021-08-23 | Rutherford | Tennessee | 47149 | 49187 | 463 |
1643785 | 1643785 | 2021-08-22 | Rutherford | Tennessee | 47149 | 48277 | 462 |
1640535 | 1640535 | 2021-08-21 | Rutherford | Tennessee | 47149 | 48277 | 462 |
1637285 | 1637285 | 2021-08-20 | Rutherford | Tennessee | 47149 | 48277 | 462 |
1634035 | 1634035 | 2021-08-19 | Rutherford | Tennessee | 47149 | 47996 | 462 |
1630788 | 1630788 | 2021-08-18 | Rutherford | Tennessee | 47149 | 47755 | 458 |
1627541 | 1627541 | 2021-08-17 | Rutherford | Tennessee | 47149 | 47538 | 458 |
1624294 | 1624294 | 2021-08-16 | Rutherford | Tennessee | 47149 | 47405 | 458 |
1621047 | 1621047 | 2021-08-15 | Rutherford | Tennessee | 47149 | 46828 | 458 |
1617799 | 1617799 | 2021-08-14 | Rutherford | Tennessee | 47149 | 46828 | 458 |
1614551 | 1614551 | 2021-08-13 | Rutherford | Tennessee | 47149 | 46828 | 458 |
1611302 | 1611302 | 2021-08-12 | Rutherford | Tennessee | 47149 | 46664 | 458 |
1608054 | 1608054 | 2021-08-11 | Rutherford | Tennessee | 47149 | 46383 | 458 |
1604805 | 1604805 | 2021-08-10 | Rutherford | Tennessee | 47149 | 46205 | 458 |
1601556 | 1601556 | 2021-08-09 | Rutherford | Tennessee | 47149 | 46075 | 453 |
1598308 | 1598308 | 2021-08-08 | Rutherford | Tennessee | 47149 | 45709 | 453 |
1595059 | 1595059 | 2021-08-07 | Rutherford | Tennessee | 47149 | 45709 | 453 |
1591810 | 1591810 | 2021-08-06 | Rutherford | Tennessee | 47149 | 45709 | 453 |
1588561 | 1588561 | 2021-08-05 | Rutherford | Tennessee | 47149 | 45554 | 452 |
1585311 | 1585311 | 2021-08-04 | Rutherford | Tennessee | 47149 | 45428 | 452 |
1582061 | 1582061 | 2021-08-03 | Rutherford | Tennessee | 47149 | 45298 | 452 |
1578812 | 1578812 | 2021-08-02 | Rutherford | Tennessee | 47149 | 45177 | 452 |
1575564 | 1575564 | 2021-08-01 | Rutherford | Tennessee | 47149 | 44884 | 452 |
1572316 | 1572316 | 2021-07-31 | Rutherford | Tennessee | 47149 | 44884 | 452 |
1569068 | 1569068 | 2021-07-30 | Rutherford | Tennessee | 47149 | 44884 | 452 |
1565820 | 1565820 | 2021-07-29 | Rutherford | Tennessee | 47149 | 44775 | 453 |
1562572 | 1562572 | 2021-07-28 | Rutherford | Tennessee | 47149 | 44636 | 453 |
1559324 | 1559324 | 2021-07-27 | Rutherford | Tennessee | 47149 | 44558 | 453 |
1556077 | 1556077 | 2021-07-26 | Rutherford | Tennessee | 47149 | 44470 | 452 |
1552830 | 1552830 | 2021-07-25 | Rutherford | Tennessee | 47149 | 44291 | 451 |
1549583 | 1549583 | 2021-07-24 | Rutherford | Tennessee | 47149 | 44291 | 451 |
1546336 | 1546336 | 2021-07-23 | Rutherford | Tennessee | 47149 | 44291 | 451 |
1543089 | 1543089 | 2021-07-22 | Rutherford | Tennessee | 47149 | 44215 | 451 |
1539841 | 1539841 | 2021-07-21 | Rutherford | Tennessee | 47149 | 44154 | 451 |
1536594 | 1536594 | 2021-07-20 | Rutherford | Tennessee | 47149 | 44081 | 451 |
1533346 | 1533346 | 2021-07-19 | Rutherford | Tennessee | 47149 | 44034 | 451 |
1530099 | 1530099 | 2021-07-18 | Rutherford | Tennessee | 47149 | 43943 | 451 |
1526852 | 1526852 | 2021-07-17 | Rutherford | Tennessee | 47149 | 43943 | 451 |
1523605 | 1523605 | 2021-07-16 | Rutherford | Tennessee | 47149 | 43943 | 451 |
1520357 | 1520357 | 2021-07-15 | Rutherford | Tennessee | 47149 | 43915 | 451 |
1517109 | 1517109 | 2021-07-14 | Rutherford | Tennessee | 47149 | 43898 | 451 |
1513862 | 1513862 | 2021-07-13 | Rutherford | Tennessee | 47149 | 43867 | 451 |
1510616 | 1510616 | 2021-07-12 | Rutherford | Tennessee | 47149 | 43855 | 450 |
1507369 | 1507369 | 2021-07-11 | Rutherford | Tennessee | 47149 | 43818 | 450 |
1504123 | 1504123 | 2021-07-10 | Rutherford | Tennessee | 47149 | 43818 | 450 |
1500877 | 1500877 | 2021-07-09 | Rutherford | Tennessee | 47149 | 43818 | 450 |
1497631 | 1497631 | 2021-07-08 | Rutherford | Tennessee | 47149 | 43799 | 450 |
1494384 | 1494384 | 2021-07-07 | Rutherford | Tennessee | 47149 | 43784 | 449 |
1491137 | 1491137 | 2021-07-06 | Rutherford | Tennessee | 47149 | 43770 | 449 |
1487890 | 1487890 | 2021-07-05 | Rutherford | Tennessee | 47149 | 43727 | 448 |
1484643 | 1484643 | 2021-07-04 | Rutherford | Tennessee | 47149 | 43727 | 448 |
1481397 | 1481397 | 2021-07-03 | Rutherford | Tennessee | 47149 | 43727 | 448 |
1478150 | 1478150 | 2021-07-02 | Rutherford | Tennessee | 47149 | 43727 | 448 |
1474904 | 1474904 | 2021-07-01 | Rutherford | Tennessee | 47149 | 43717 | 448 |
1471658 | 1471658 | 2021-06-30 | Rutherford | Tennessee | 47149 | 43725 | 447 |
1468413 | 1468413 | 2021-06-29 | Rutherford | Tennessee | 47149 | 43717 | 447 |
1465168 | 1465168 | 2021-06-28 | Rutherford | Tennessee | 47149 | 43718 | 447 |
1461923 | 1461923 | 2021-06-27 | Rutherford | Tennessee | 47149 | 43716 | 447 |
1458678 | 1458678 | 2021-06-26 | Rutherford | Tennessee | 47149 | 43716 | 447 |
1455433 | 1455433 | 2021-06-25 | Rutherford | Tennessee | 47149 | 43716 | 447 |
1452188 | 1452188 | 2021-06-24 | Rutherford | Tennessee | 47149 | 43717 | 447 |
1448942 | 1448942 | 2021-06-23 | Rutherford | Tennessee | 47149 | 43714 | 446 |
1445697 | 1445697 | 2021-06-22 | Rutherford | Tennessee | 47149 | 43711 | 445 |
1442452 | 1442452 | 2021-06-21 | Rutherford | Tennessee | 47149 | 43706 | 445 |
1439207 | 1439207 | 2021-06-20 | Rutherford | Tennessee | 47149 | 43706 | 445 |
1435960 | 1435960 | 2021-06-19 | Rutherford | Tennessee | 47149 | 43706 | 445 |
1432713 | 1432713 | 2021-06-18 | Rutherford | Tennessee | 47149 | 43706 | 445 |
1429467 | 1429467 | 2021-06-17 | Rutherford | Tennessee | 47149 | 43704 | 445 |
1426222 | 1426222 | 2021-06-16 | Rutherford | Tennessee | 47149 | 43699 | 446 |
1422975 | 1422975 | 2021-06-15 | Rutherford | Tennessee | 47149 | 43697 | 446 |
1419729 | 1419729 | 2021-06-14 | Rutherford | Tennessee | 47149 | 43601 | 444 |
1416484 | 1416484 | 2021-06-13 | Rutherford | Tennessee | 47149 | 43601 | 444 |
1413238 | 1413238 | 2021-06-12 | Rutherford | Tennessee | 47149 | 43601 | 444 |
1409993 | 1409993 | 2021-06-11 | Rutherford | Tennessee | 47149 | 43601 | 444 |
1406748 | 1406748 | 2021-06-10 | Rutherford | Tennessee | 47149 | 43552 | 444 |
1403502 | 1403502 | 2021-06-09 | Rutherford | Tennessee | 47149 | 43547 | 444 |
1400257 | 1400257 | 2021-06-08 | Rutherford | Tennessee | 47149 | 43538 | 444 |
1397012 | 1397012 | 2021-06-07 | Rutherford | Tennessee | 47149 | 43525 | 443 |
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);