ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Montgomery" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812911 | 1812911 | 2021-10-13 | Montgomery | Texas | 48339 | 86577 | 1004 |
1809662 | 1809662 | 2021-10-12 | Montgomery | Texas | 48339 | 86402 | 998 |
1806412 | 1806412 | 2021-10-11 | Montgomery | Texas | 48339 | 86176 | 992 |
1803162 | 1803162 | 2021-10-10 | Montgomery | Texas | 48339 | 86176 | 992 |
1799913 | 1799913 | 2021-10-09 | Montgomery | Texas | 48339 | 86176 | 991 |
1796664 | 1796664 | 2021-10-08 | Montgomery | Texas | 48339 | 85987 | 985 |
1793415 | 1793415 | 2021-10-07 | Montgomery | Texas | 48339 | 85861 | 982 |
1790166 | 1790166 | 2021-10-06 | Montgomery | Texas | 48339 | 85710 | 976 |
1786918 | 1786918 | 2021-10-05 | Montgomery | Texas | 48339 | 85545 | 966 |
1783669 | 1783669 | 2021-10-04 | Montgomery | Texas | 48339 | 85161 | 956 |
1780420 | 1780420 | 2021-10-03 | Montgomery | Texas | 48339 | 85161 | 954 |
1777170 | 1777170 | 2021-10-02 | Montgomery | Texas | 48339 | 85161 | 951 |
1773920 | 1773920 | 2021-10-01 | Montgomery | Texas | 48339 | 84936 | 942 |
1770670 | 1770670 | 2021-09-30 | Montgomery | Texas | 48339 | 84857 | 931 |
1767421 | 1767421 | 2021-09-29 | Montgomery | Texas | 48339 | 84684 | 923 |
1764172 | 1764172 | 2021-09-28 | Montgomery | Texas | 48339 | 84476 | 911 |
1760923 | 1760923 | 2021-09-27 | Montgomery | Texas | 48339 | 83949 | 905 |
1757675 | 1757675 | 2021-09-26 | Montgomery | Texas | 48339 | 83949 | 902 |
1754427 | 1754427 | 2021-09-25 | Montgomery | Texas | 48339 | 83949 | 899 |
1751179 | 1751179 | 2021-09-24 | Montgomery | Texas | 48339 | 83637 | 891 |
1747930 | 1747930 | 2021-09-23 | Montgomery | Texas | 48339 | 83476 | 879 |
1744680 | 1744680 | 2021-09-22 | Montgomery | Texas | 48339 | 83024 | 864 |
1741431 | 1741431 | 2021-09-21 | Montgomery | Texas | 48339 | 82829 | 847 |
1738182 | 1738182 | 2021-09-20 | Montgomery | Texas | 48339 | 82070 | 840 |
1734932 | 1734932 | 2021-09-19 | Montgomery | Texas | 48339 | 82070 | 836 |
1731682 | 1731682 | 2021-09-18 | Montgomery | Texas | 48339 | 82070 | 835 |
1728432 | 1728432 | 2021-09-17 | Montgomery | Texas | 48339 | 81722 | 830 |
1725183 | 1725183 | 2021-09-16 | Montgomery | Texas | 48339 | 80939 | 818 |
1721934 | 1721934 | 2021-09-15 | Montgomery | Texas | 48339 | 80939 | 806 |
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 |
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);