ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Brazoria" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1949241 | 1949241 | 2021-11-24 | Brazoria | Texas | 48039 | 60754 | 851 |
1945990 | 1945990 | 2021-11-23 | Brazoria | Texas | 48039 | 60675 | 850 |
1942739 | 1942739 | 2021-11-22 | Brazoria | Texas | 48039 | 60623 | 850 |
1939489 | 1939489 | 2021-11-21 | Brazoria | Texas | 48039 | 60623 | 850 |
1936239 | 1936239 | 2021-11-20 | Brazoria | Texas | 48039 | 60623 | 850 |
1932989 | 1932989 | 2021-11-19 | Brazoria | Texas | 48039 | 60525 | 848 |
1929738 | 1929738 | 2021-11-18 | Brazoria | Texas | 48039 | 60525 | 846 |
1926488 | 1926488 | 2021-11-17 | Brazoria | Texas | 48039 | 60498 | 845 |
1923238 | 1923238 | 2021-11-16 | Brazoria | Texas | 48039 | 60314 | 845 |
1919989 | 1919989 | 2021-11-15 | Brazoria | Texas | 48039 | 60314 | 843 |
1916739 | 1916739 | 2021-11-14 | Brazoria | Texas | 48039 | 60314 | 843 |
1913489 | 1913489 | 2021-11-13 | Brazoria | Texas | 48039 | 60314 | 842 |
1910239 | 1910239 | 2021-11-12 | Brazoria | Texas | 48039 | 60283 | 842 |
1906990 | 1906990 | 2021-11-11 | Brazoria | Texas | 48039 | 60283 | 841 |
1903741 | 1903741 | 2021-11-10 | Brazoria | Texas | 48039 | 60069 | 836 |
1900491 | 1900491 | 2021-11-09 | Brazoria | Texas | 48039 | 60069 | 836 |
1897241 | 1897241 | 2021-11-08 | Brazoria | Texas | 48039 | 59975 | 836 |
1893991 | 1893991 | 2021-11-07 | Brazoria | Texas | 48039 | 59975 | 836 |
1890741 | 1890741 | 2021-11-06 | Brazoria | Texas | 48039 | 59975 | 836 |
1887491 | 1887491 | 2021-11-05 | Brazoria | Texas | 48039 | 59975 | 835 |
1884241 | 1884241 | 2021-11-04 | Brazoria | Texas | 48039 | 59947 | 835 |
1880992 | 1880992 | 2021-11-03 | Brazoria | Texas | 48039 | 59916 | 833 |
1877743 | 1877743 | 2021-11-02 | Brazoria | Texas | 48039 | 59836 | 828 |
1874494 | 1874494 | 2021-11-01 | Brazoria | Texas | 48039 | 59756 | 826 |
1871245 | 1871245 | 2021-10-31 | Brazoria | Texas | 48039 | 59756 | 825 |
1867996 | 1867996 | 2021-10-30 | Brazoria | Texas | 48039 | 59756 | 824 |
1864747 | 1864747 | 2021-10-29 | Brazoria | Texas | 48039 | 59705 | 824 |
1861498 | 1861498 | 2021-10-28 | Brazoria | Texas | 48039 | 59673 | 821 |
1858249 | 1858249 | 2021-10-27 | Brazoria | Texas | 48039 | 59168 | 821 |
1855000 | 1855000 | 2021-10-26 | Brazoria | Texas | 48039 | 59168 | 817 |
1851751 | 1851751 | 2021-10-25 | Brazoria | Texas | 48039 | 59168 | 815 |
1848501 | 1848501 | 2021-10-24 | Brazoria | Texas | 48039 | 59168 | 815 |
1845251 | 1845251 | 2021-10-23 | Brazoria | Texas | 48039 | 59168 | 815 |
1842001 | 1842001 | 2021-10-22 | Brazoria | Texas | 48039 | 59168 | 814 |
1838752 | 1838752 | 2021-10-21 | Brazoria | Texas | 48039 | 59168 | 814 |
1835503 | 1835503 | 2021-10-20 | Brazoria | Texas | 48039 | 59168 | 809 |
1832254 | 1832254 | 2021-10-19 | Brazoria | Texas | 48039 | 59168 | 808 |
1829005 | 1829005 | 2021-10-18 | Brazoria | Texas | 48039 | 59077 | 804 |
1825756 | 1825756 | 2021-10-17 | Brazoria | Texas | 48039 | 59077 | 804 |
1822507 | 1822507 | 2021-10-16 | Brazoria | Texas | 48039 | 59077 | 803 |
1819258 | 1819258 | 2021-10-15 | Brazoria | Texas | 48039 | 58990 | 803 |
1816009 | 1816009 | 2021-10-14 | Brazoria | Texas | 48039 | 58914 | 800 |
1812761 | 1812761 | 2021-10-13 | Brazoria | Texas | 48039 | 58778 | 796 |
1809512 | 1809512 | 2021-10-12 | Brazoria | Texas | 48039 | 58552 | 793 |
1806262 | 1806262 | 2021-10-11 | Brazoria | Texas | 48039 | 58400 | 786 |
1803012 | 1803012 | 2021-10-10 | Brazoria | Texas | 48039 | 58400 | 786 |
1799763 | 1799763 | 2021-10-09 | Brazoria | Texas | 48039 | 58400 | 785 |
1796514 | 1796514 | 2021-10-08 | Brazoria | Texas | 48039 | 58211 | 782 |
1793265 | 1793265 | 2021-10-07 | Brazoria | Texas | 48039 | 58020 | 778 |
1790016 | 1790016 | 2021-10-06 | Brazoria | Texas | 48039 | 57795 | 777 |
1786768 | 1786768 | 2021-10-05 | Brazoria | Texas | 48039 | 57521 | 771 |
1783519 | 1783519 | 2021-10-04 | Brazoria | Texas | 48039 | 57379 | 764 |
1780270 | 1780270 | 2021-10-03 | Brazoria | Texas | 48039 | 57379 | 763 |
1777020 | 1777020 | 2021-10-02 | Brazoria | Texas | 48039 | 57379 | 763 |
1773770 | 1773770 | 2021-10-01 | Brazoria | Texas | 48039 | 57111 | 760 |
1770520 | 1770520 | 2021-09-30 | Brazoria | Texas | 48039 | 57096 | 756 |
1767271 | 1767271 | 2021-09-29 | Brazoria | Texas | 48039 | 56930 | 755 |
1764022 | 1764022 | 2021-09-28 | Brazoria | Texas | 48039 | 56536 | 750 |
1760773 | 1760773 | 2021-09-27 | Brazoria | Texas | 48039 | 56373 | 740 |
1757525 | 1757525 | 2021-09-26 | Brazoria | Texas | 48039 | 56373 | 739 |
1754277 | 1754277 | 2021-09-25 | Brazoria | Texas | 48039 | 56373 | 737 |
1751029 | 1751029 | 2021-09-24 | Brazoria | Texas | 48039 | 56207 | 732 |
1747780 | 1747780 | 2021-09-23 | Brazoria | Texas | 48039 | 56061 | 723 |
1744530 | 1744530 | 2021-09-22 | Brazoria | Texas | 48039 | 55805 | 712 |
1741281 | 1741281 | 2021-09-21 | Brazoria | Texas | 48039 | 55391 | 707 |
1738032 | 1738032 | 2021-09-20 | Brazoria | Texas | 48039 | 55139 | 705 |
1734782 | 1734782 | 2021-09-19 | Brazoria | Texas | 48039 | 55139 | 705 |
1731532 | 1731532 | 2021-09-18 | Brazoria | Texas | 48039 | 55139 | 704 |
1728282 | 1728282 | 2021-09-17 | Brazoria | Texas | 48039 | 54552 | 701 |
1725033 | 1725033 | 2021-09-16 | Brazoria | Texas | 48039 | 53839 | 693 |
1721784 | 1721784 | 2021-09-15 | Brazoria | Texas | 48039 | 53823 | 687 |
1718536 | 1718536 | 2021-09-14 | Brazoria | Texas | 48039 | 53648 | 681 |
1715288 | 1715288 | 2021-09-13 | Brazoria | Texas | 48039 | 53293 | 680 |
1712042 | 1712042 | 2021-09-12 | Brazoria | Texas | 48039 | 53293 | 678 |
1708795 | 1708795 | 2021-09-11 | Brazoria | Texas | 48039 | 53293 | 677 |
1705548 | 1705548 | 2021-09-10 | Brazoria | Texas | 48039 | 52899 | 670 |
1702298 | 1702298 | 2021-09-09 | Brazoria | Texas | 48039 | 52763 | 662 |
1699049 | 1699049 | 2021-09-08 | Brazoria | Texas | 48039 | 51173 | 654 |
1695801 | 1695801 | 2021-09-07 | Brazoria | Texas | 48039 | 50854 | 649 |
1692553 | 1692553 | 2021-09-06 | Brazoria | Texas | 48039 | 50854 | 649 |
1689304 | 1689304 | 2021-09-05 | Brazoria | Texas | 48039 | 50854 | 649 |
1686054 | 1686054 | 2021-09-04 | Brazoria | Texas | 48039 | 50854 | 647 |
1682803 | 1682803 | 2021-09-03 | Brazoria | Texas | 48039 | 50206 | 644 |
1679553 | 1679553 | 2021-09-02 | Brazoria | Texas | 48039 | 49675 | 636 |
1676305 | 1676305 | 2021-09-01 | Brazoria | Texas | 48039 | 49603 | 627 |
1673058 | 1673058 | 2021-08-31 | Brazoria | Texas | 48039 | 48850 | 619 |
1669810 | 1669810 | 2021-08-30 | Brazoria | Texas | 48039 | 48488 | 613 |
1666563 | 1666563 | 2021-08-29 | Brazoria | Texas | 48039 | 48488 | 612 |
1663315 | 1663315 | 2021-08-28 | Brazoria | Texas | 48039 | 48488 | 612 |
1660067 | 1660067 | 2021-08-27 | Brazoria | Texas | 48039 | 48070 | 609 |
1656818 | 1656818 | 2021-08-26 | Brazoria | Texas | 48039 | 47810 | 602 |
1653571 | 1653571 | 2021-08-25 | Brazoria | Texas | 48039 | 47482 | 598 |
1650324 | 1650324 | 2021-08-24 | Brazoria | Texas | 48039 | 46666 | 593 |
1647075 | 1647075 | 2021-08-23 | Brazoria | Texas | 48039 | 46666 | 589 |
1643826 | 1643826 | 2021-08-22 | Brazoria | Texas | 48039 | 46666 | 588 |
1640576 | 1640576 | 2021-08-21 | Brazoria | Texas | 48039 | 46666 | 585 |
1637326 | 1637326 | 2021-08-20 | Brazoria | Texas | 48039 | 46416 | 581 |
1634076 | 1634076 | 2021-08-19 | Brazoria | Texas | 48039 | 46151 | 579 |
1630829 | 1630829 | 2021-08-18 | Brazoria | Texas | 48039 | 45472 | 574 |
1627582 | 1627582 | 2021-08-17 | Brazoria | Texas | 48039 | 44791 | 568 |
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);