ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jefferson" and fips = 48245 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1835606 | 1835606 | 2021-10-20 | Jefferson | Texas | 48245 | 31521 | 680 |
1832357 | 1832357 | 2021-10-19 | Jefferson | Texas | 48245 | 31476 | 677 |
1829108 | 1829108 | 2021-10-18 | Jefferson | Texas | 48245 | 31439 | 672 |
1825859 | 1825859 | 2021-10-17 | Jefferson | Texas | 48245 | 31439 | 672 |
1822610 | 1822610 | 2021-10-16 | Jefferson | Texas | 48245 | 31439 | 671 |
1819361 | 1819361 | 2021-10-15 | Jefferson | Texas | 48245 | 31406 | 670 |
1816112 | 1816112 | 2021-10-14 | Jefferson | Texas | 48245 | 31374 | 666 |
1812864 | 1812864 | 2021-10-13 | Jefferson | Texas | 48245 | 31305 | 662 |
1809615 | 1809615 | 2021-10-12 | Jefferson | Texas | 48245 | 31267 | 657 |
1806365 | 1806365 | 2021-10-11 | Jefferson | Texas | 48245 | 31200 | 655 |
1803115 | 1803115 | 2021-10-10 | Jefferson | Texas | 48245 | 31200 | 655 |
1799866 | 1799866 | 2021-10-09 | Jefferson | Texas | 48245 | 31200 | 655 |
1796617 | 1796617 | 2021-10-08 | Jefferson | Texas | 48245 | 31161 | 653 |
1793368 | 1793368 | 2021-10-07 | Jefferson | Texas | 48245 | 31104 | 649 |
1790119 | 1790119 | 2021-10-06 | Jefferson | Texas | 48245 | 31048 | 646 |
1786871 | 1786871 | 2021-10-05 | Jefferson | Texas | 48245 | 30990 | 642 |
1783622 | 1783622 | 2021-10-04 | Jefferson | Texas | 48245 | 30882 | 636 |
1780373 | 1780373 | 2021-10-03 | Jefferson | Texas | 48245 | 30882 | 636 |
1777123 | 1777123 | 2021-10-02 | Jefferson | Texas | 48245 | 30882 | 636 |
1773873 | 1773873 | 2021-10-01 | Jefferson | Texas | 48245 | 30827 | 632 |
1770623 | 1770623 | 2021-09-30 | Jefferson | Texas | 48245 | 30763 | 630 |
1767374 | 1767374 | 2021-09-29 | Jefferson | Texas | 48245 | 30678 | 626 |
1764125 | 1764125 | 2021-09-28 | Jefferson | Texas | 48245 | 30618 | 620 |
1760876 | 1760876 | 2021-09-27 | Jefferson | Texas | 48245 | 30434 | 616 |
1757628 | 1757628 | 2021-09-26 | Jefferson | Texas | 48245 | 30434 | 616 |
1754380 | 1754380 | 2021-09-25 | Jefferson | Texas | 48245 | 30434 | 614 |
1751132 | 1751132 | 2021-09-24 | Jefferson | Texas | 48245 | 30355 | 612 |
1747883 | 1747883 | 2021-09-23 | Jefferson | Texas | 48245 | 30203 | 606 |
1744633 | 1744633 | 2021-09-22 | Jefferson | Texas | 48245 | 30041 | 591 |
1741384 | 1741384 | 2021-09-21 | Jefferson | Texas | 48245 | 29873 | 583 |
1738135 | 1738135 | 2021-09-20 | Jefferson | Texas | 48245 | 29571 | 576 |
1734885 | 1734885 | 2021-09-19 | Jefferson | Texas | 48245 | 29571 | 576 |
1731635 | 1731635 | 2021-09-18 | Jefferson | Texas | 48245 | 29571 | 574 |
1728385 | 1728385 | 2021-09-17 | Jefferson | Texas | 48245 | 29404 | 566 |
1725136 | 1725136 | 2021-09-16 | Jefferson | Texas | 48245 | 29165 | 564 |
1721887 | 1721887 | 2021-09-15 | Jefferson | Texas | 48245 | 28930 | 550 |
1718639 | 1718639 | 2021-09-14 | Jefferson | Texas | 48245 | 28846 | 549 |
1715391 | 1715391 | 2021-09-13 | Jefferson | Texas | 48245 | 28518 | 546 |
1712145 | 1712145 | 2021-09-12 | Jefferson | Texas | 48245 | 28518 | 545 |
1708898 | 1708898 | 2021-09-11 | Jefferson | Texas | 48245 | 28518 | 538 |
1705651 | 1705651 | 2021-09-10 | Jefferson | Texas | 48245 | 28302 | 536 |
1702401 | 1702401 | 2021-09-09 | Jefferson | Texas | 48245 | 27985 | 530 |
1699152 | 1699152 | 2021-09-08 | Jefferson | Texas | 48245 | 27907 | 525 |
1695904 | 1695904 | 2021-09-07 | Jefferson | Texas | 48245 | 27397 | 517 |
1692656 | 1692656 | 2021-09-06 | Jefferson | Texas | 48245 | 27294 | 517 |
1689407 | 1689407 | 2021-09-05 | Jefferson | Texas | 48245 | 27294 | 517 |
1686157 | 1686157 | 2021-09-04 | Jefferson | Texas | 48245 | 27294 | 514 |
1682906 | 1682906 | 2021-09-03 | Jefferson | Texas | 48245 | 26974 | 510 |
1679656 | 1679656 | 2021-09-02 | Jefferson | Texas | 48245 | 26670 | 498 |
1676408 | 1676408 | 2021-09-01 | Jefferson | Texas | 48245 | 26403 | 489 |
1673161 | 1673161 | 2021-08-31 | Jefferson | Texas | 48245 | 26086 | 481 |
1669913 | 1669913 | 2021-08-30 | Jefferson | Texas | 48245 | 25800 | 478 |
1666666 | 1666666 | 2021-08-29 | Jefferson | Texas | 48245 | 25800 | 478 |
1663418 | 1663418 | 2021-08-28 | Jefferson | Texas | 48245 | 25800 | 476 |
1660170 | 1660170 | 2021-08-27 | Jefferson | Texas | 48245 | 25589 | 475 |
1656921 | 1656921 | 2021-08-26 | Jefferson | Texas | 48245 | 25060 | 474 |
1653674 | 1653674 | 2021-08-25 | Jefferson | Texas | 48245 | 24980 | 472 |
1650427 | 1650427 | 2021-08-24 | Jefferson | Texas | 48245 | 24794 | 469 |
1647178 | 1647178 | 2021-08-23 | Jefferson | Texas | 48245 | 24585 | 466 |
1643929 | 1643929 | 2021-08-22 | Jefferson | Texas | 48245 | 24585 | 466 |
1640679 | 1640679 | 2021-08-21 | Jefferson | Texas | 48245 | 24585 | 466 |
1637429 | 1637429 | 2021-08-20 | Jefferson | Texas | 48245 | 24302 | 462 |
1634179 | 1634179 | 2021-08-19 | Jefferson | Texas | 48245 | 24222 | 461 |
1630932 | 1630932 | 2021-08-18 | Jefferson | Texas | 48245 | 24073 | 457 |
1627685 | 1627685 | 2021-08-17 | Jefferson | Texas | 48245 | 23884 | 455 |
1624438 | 1624438 | 2021-08-16 | Jefferson | Texas | 48245 | 23505 | 455 |
1621191 | 1621191 | 2021-08-15 | Jefferson | Texas | 48245 | 23505 | 455 |
1617943 | 1617943 | 2021-08-14 | Jefferson | Texas | 48245 | 23505 | 455 |
1614695 | 1614695 | 2021-08-13 | Jefferson | Texas | 48245 | 23417 | 455 |
1611446 | 1611446 | 2021-08-12 | Jefferson | Texas | 48245 | 23230 | 452 |
1608198 | 1608198 | 2021-08-11 | Jefferson | Texas | 48245 | 23029 | 450 |
1604949 | 1604949 | 2021-08-10 | Jefferson | Texas | 48245 | 22796 | 450 |
1601700 | 1601700 | 2021-08-09 | Jefferson | Texas | 48245 | 22639 | 450 |
1598452 | 1598452 | 2021-08-08 | Jefferson | Texas | 48245 | 22639 | 450 |
1595203 | 1595203 | 2021-08-07 | Jefferson | Texas | 48245 | 22639 | 450 |
1591954 | 1591954 | 2021-08-06 | Jefferson | Texas | 48245 | 22484 | 450 |
1588705 | 1588705 | 2021-08-05 | Jefferson | Texas | 48245 | 22289 | 450 |
1585455 | 1585455 | 2021-08-04 | Jefferson | Texas | 48245 | 22100 | 449 |
1582205 | 1582205 | 2021-08-03 | Jefferson | Texas | 48245 | 21872 | 449 |
1578956 | 1578956 | 2021-08-02 | Jefferson | Texas | 48245 | 21668 | 448 |
1575708 | 1575708 | 2021-08-01 | Jefferson | Texas | 48245 | 21668 | 448 |
1572460 | 1572460 | 2021-07-31 | Jefferson | Texas | 48245 | 21668 | 448 |
1569212 | 1569212 | 2021-07-30 | Jefferson | Texas | 48245 | 21500 | 448 |
1565964 | 1565964 | 2021-07-29 | Jefferson | Texas | 48245 | 21500 | 448 |
1562716 | 1562716 | 2021-07-28 | Jefferson | Texas | 48245 | 21388 | 447 |
1559468 | 1559468 | 2021-07-27 | Jefferson | Texas | 48245 | 21253 | 447 |
1556221 | 1556221 | 2021-07-26 | Jefferson | Texas | 48245 | 21168 | 447 |
1552974 | 1552974 | 2021-07-25 | Jefferson | Texas | 48245 | 21168 | 447 |
1549727 | 1549727 | 2021-07-24 | Jefferson | Texas | 48245 | 21146 | 447 |
1546480 | 1546480 | 2021-07-23 | Jefferson | Texas | 48245 | 21068 | 445 |
1543233 | 1543233 | 2021-07-22 | Jefferson | Texas | 48245 | 20944 | 444 |
1539985 | 1539985 | 2021-07-21 | Jefferson | Texas | 48245 | 20793 | 443 |
1536738 | 1536738 | 2021-07-20 | Jefferson | Texas | 48245 | 20755 | 443 |
1533490 | 1533490 | 2021-07-19 | Jefferson | Texas | 48245 | 20685 | 443 |
1530243 | 1530243 | 2021-07-18 | Jefferson | Texas | 48245 | 20685 | 443 |
1526996 | 1526996 | 2021-07-17 | Jefferson | Texas | 48245 | 20685 | 443 |
1523749 | 1523749 | 2021-07-16 | Jefferson | Texas | 48245 | 20658 | 443 |
1520501 | 1520501 | 2021-07-15 | Jefferson | Texas | 48245 | 20639 | 443 |
1517253 | 1517253 | 2021-07-14 | Jefferson | Texas | 48245 | 20581 | 443 |
1514006 | 1514006 | 2021-07-13 | Jefferson | Texas | 48245 | 20566 | 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);