ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 48339 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718686 | 1718686 | 2021-09-14 | Montgomery | Texas | 48339 | 78976 | 793 |
1715438 | 1715438 | 2021-09-13 | Montgomery | Texas | 48339 | 78976 | 785 |
1712192 | 1712192 | 2021-09-12 | Montgomery | Texas | 48339 | 78976 | 785 |
1708945 | 1708945 | 2021-09-11 | Montgomery | Texas | 48339 | 78976 | 778 |
1705698 | 1705698 | 2021-09-10 | Montgomery | Texas | 48339 | 78976 | 770 |
1702448 | 1702448 | 2021-09-09 | Montgomery | Texas | 48339 | 78534 | 763 |
1699199 | 1699199 | 2021-09-08 | Montgomery | Texas | 48339 | 78037 | 756 |
1695951 | 1695951 | 2021-09-07 | Montgomery | Texas | 48339 | 75631 | 744 |
1692703 | 1692703 | 2021-09-06 | Montgomery | Texas | 48339 | 75631 | 741 |
1689454 | 1689454 | 2021-09-05 | Montgomery | Texas | 48339 | 75631 | 741 |
1686204 | 1686204 | 2021-09-04 | Montgomery | Texas | 48339 | 75631 | 735 |
1682953 | 1682953 | 2021-09-03 | Montgomery | Texas | 48339 | 74967 | 730 |
1679703 | 1679703 | 2021-09-02 | Montgomery | Texas | 48339 | 73736 | 724 |
1676455 | 1676455 | 2021-09-01 | Montgomery | Texas | 48339 | 72979 | 711 |
1673208 | 1673208 | 2021-08-31 | Montgomery | Texas | 48339 | 72636 | 702 |
1669960 | 1669960 | 2021-08-30 | Montgomery | Texas | 48339 | 71505 | 696 |
1666713 | 1666713 | 2021-08-29 | Montgomery | Texas | 48339 | 71505 | 696 |
1663465 | 1663465 | 2021-08-28 | Montgomery | Texas | 48339 | 71505 | 693 |
1660217 | 1660217 | 2021-08-27 | Montgomery | Texas | 48339 | 70387 | 687 |
1656968 | 1656968 | 2021-08-26 | Montgomery | Texas | 48339 | 69816 | 679 |
1653721 | 1653721 | 2021-08-25 | Montgomery | Texas | 48339 | 69246 | 676 |
1650474 | 1650474 | 2021-08-24 | Montgomery | Texas | 48339 | 68664 | 671 |
1647225 | 1647225 | 2021-08-23 | Montgomery | Texas | 48339 | 67824 | 665 |
1643976 | 1643976 | 2021-08-22 | Montgomery | Texas | 48339 | 67824 | 665 |
1640726 | 1640726 | 2021-08-21 | Montgomery | Texas | 48339 | 67824 | 662 |
1637476 | 1637476 | 2021-08-20 | Montgomery | Texas | 48339 | 67428 | 657 |
1634226 | 1634226 | 2021-08-19 | Montgomery | Texas | 48339 | 67028 | 654 |
1630979 | 1630979 | 2021-08-18 | Montgomery | Texas | 48339 | 66368 | 645 |
1627732 | 1627732 | 2021-08-17 | Montgomery | Texas | 48339 | 65505 | 643 |
1624485 | 1624485 | 2021-08-16 | Montgomery | Texas | 48339 | 64472 | 641 |
1621238 | 1621238 | 2021-08-15 | Montgomery | Texas | 48339 | 64472 | 640 |
1617990 | 1617990 | 2021-08-14 | Montgomery | Texas | 48339 | 64472 | 640 |
1614742 | 1614742 | 2021-08-13 | Montgomery | Texas | 48339 | 64091 | 634 |
1611493 | 1611493 | 2021-08-12 | Montgomery | Texas | 48339 | 63680 | 633 |
1608245 | 1608245 | 2021-08-11 | Montgomery | Texas | 48339 | 63116 | 628 |
1604996 | 1604996 | 2021-08-10 | Montgomery | Texas | 48339 | 62543 | 625 |
1601747 | 1601747 | 2021-08-09 | Montgomery | Texas | 48339 | 61721 | 623 |
1598499 | 1598499 | 2021-08-08 | Montgomery | Texas | 48339 | 61721 | 623 |
1595250 | 1595250 | 2021-08-07 | Montgomery | Texas | 48339 | 61721 | 623 |
1592001 | 1592001 | 2021-08-06 | Montgomery | Texas | 48339 | 61444 | 622 |
1588752 | 1588752 | 2021-08-05 | Montgomery | Texas | 48339 | 60941 | 621 |
1585502 | 1585502 | 2021-08-04 | Montgomery | Texas | 48339 | 60424 | 621 |
1582252 | 1582252 | 2021-08-03 | Montgomery | Texas | 48339 | 60052 | 619 |
1579003 | 1579003 | 2021-08-02 | Montgomery | Texas | 48339 | 59344 | 618 |
1575755 | 1575755 | 2021-08-01 | Montgomery | Texas | 48339 | 59344 | 617 |
1572507 | 1572507 | 2021-07-31 | Montgomery | Texas | 48339 | 59344 | 617 |
1569259 | 1569259 | 2021-07-30 | Montgomery | Texas | 48339 | 58927 | 615 |
1566011 | 1566011 | 2021-07-29 | Montgomery | Texas | 48339 | 58659 | 615 |
1562763 | 1562763 | 2021-07-28 | Montgomery | Texas | 48339 | 58275 | 616 |
1559515 | 1559515 | 2021-07-27 | Montgomery | Texas | 48339 | 57991 | 613 |
1556268 | 1556268 | 2021-07-26 | Montgomery | Texas | 48339 | 57417 | 613 |
1553021 | 1553021 | 2021-07-25 | Montgomery | Texas | 48339 | 57417 | 613 |
1549774 | 1549774 | 2021-07-24 | Montgomery | Texas | 48339 | 57417 | 612 |
1546527 | 1546527 | 2021-07-23 | Montgomery | Texas | 48339 | 57200 | 612 |
1543280 | 1543280 | 2021-07-22 | Montgomery | Texas | 48339 | 57017 | 612 |
1540032 | 1540032 | 2021-07-21 | Montgomery | Texas | 48339 | 56820 | 612 |
1536785 | 1536785 | 2021-07-20 | Montgomery | Texas | 48339 | 56561 | 612 |
1533537 | 1533537 | 2021-07-19 | Montgomery | Texas | 48339 | 56488 | 611 |
1530290 | 1530290 | 2021-07-18 | Montgomery | Texas | 48339 | 56488 | 611 |
1527043 | 1527043 | 2021-07-17 | Montgomery | Texas | 48339 | 56488 | 611 |
1523796 | 1523796 | 2021-07-16 | Montgomery | Texas | 48339 | 56356 | 610 |
1520548 | 1520548 | 2021-07-15 | Montgomery | Texas | 48339 | 56267 | 609 |
1517300 | 1517300 | 2021-07-14 | Montgomery | Texas | 48339 | 56209 | 608 |
1514053 | 1514053 | 2021-07-13 | Montgomery | Texas | 48339 | 56137 | 607 |
1510807 | 1510807 | 2021-07-12 | Montgomery | Texas | 48339 | 55960 | 607 |
1507560 | 1507560 | 2021-07-11 | Montgomery | Texas | 48339 | 55960 | 607 |
1504314 | 1504314 | 2021-07-10 | Montgomery | Texas | 48339 | 55960 | 607 |
1501068 | 1501068 | 2021-07-09 | Montgomery | Texas | 48339 | 55871 | 607 |
1497822 | 1497822 | 2021-07-08 | Montgomery | Texas | 48339 | 55838 | 606 |
1494575 | 1494575 | 2021-07-07 | Montgomery | Texas | 48339 | 55768 | 604 |
1491328 | 1491328 | 2021-07-06 | Montgomery | Texas | 48339 | 55665 | 603 |
1488081 | 1488081 | 2021-07-05 | Montgomery | Texas | 48339 | 55665 | 603 |
1484834 | 1484834 | 2021-07-04 | Montgomery | Texas | 48339 | 55665 | 603 |
1481588 | 1481588 | 2021-07-03 | Montgomery | Texas | 48339 | 55665 | 603 |
1478341 | 1478341 | 2021-07-02 | Montgomery | Texas | 48339 | 55593 | 602 |
1475095 | 1475095 | 2021-07-01 | Montgomery | Texas | 48339 | 55571 | 602 |
1471849 | 1471849 | 2021-06-30 | Montgomery | Texas | 48339 | 55571 | 602 |
1468604 | 1468604 | 2021-06-29 | Montgomery | Texas | 48339 | 55431 | 602 |
1465359 | 1465359 | 2021-06-28 | Montgomery | Texas | 48339 | 55431 | 601 |
1462114 | 1462114 | 2021-06-27 | Montgomery | Texas | 48339 | 55431 | 601 |
1458869 | 1458869 | 2021-06-26 | Montgomery | Texas | 48339 | 55431 | 601 |
1455624 | 1455624 | 2021-06-25 | Montgomery | Texas | 48339 | 55405 | 601 |
1452379 | 1452379 | 2021-06-24 | Montgomery | Texas | 48339 | 55405 | 601 |
1449133 | 1449133 | 2021-06-23 | Montgomery | Texas | 48339 | 55348 | 601 |
1445888 | 1445888 | 2021-06-22 | Montgomery | Texas | 48339 | 55348 | 600 |
1442643 | 1442643 | 2021-06-21 | Montgomery | Texas | 48339 | 55262 | 600 |
1439398 | 1439398 | 2021-06-20 | Montgomery | Texas | 48339 | 55262 | 600 |
1436151 | 1436151 | 2021-06-19 | Montgomery | Texas | 48339 | 55262 | 600 |
1432904 | 1432904 | 2021-06-18 | Montgomery | Texas | 48339 | 55181 | 600 |
1429658 | 1429658 | 2021-06-17 | Montgomery | Texas | 48339 | 55181 | 600 |
1426413 | 1426413 | 2021-06-16 | Montgomery | Texas | 48339 | 55181 | 600 |
1423166 | 1423166 | 2021-06-15 | Montgomery | Texas | 48339 | 55129 | 598 |
1419920 | 1419920 | 2021-06-14 | Montgomery | Texas | 48339 | 55036 | 598 |
1416675 | 1416675 | 2021-06-13 | Montgomery | Texas | 48339 | 55036 | 598 |
1413429 | 1413429 | 2021-06-12 | Montgomery | Texas | 48339 | 55036 | 598 |
1410184 | 1410184 | 2021-06-11 | Montgomery | Texas | 48339 | 54977 | 598 |
1406939 | 1406939 | 2021-06-10 | Montgomery | Texas | 48339 | 54966 | 596 |
1403693 | 1403693 | 2021-06-09 | Montgomery | Texas | 48339 | 54850 | 595 |
1400448 | 1400448 | 2021-06-08 | Montgomery | Texas | 48339 | 54816 | 593 |
1397203 | 1397203 | 2021-06-07 | Montgomery | Texas | 48339 | 54624 | 593 |
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);