ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 48039 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1624335 | 1624335 | 2021-08-16 | Brazoria | Texas | 48039 | 44478 | 567 |
1621088 | 1621088 | 2021-08-15 | Brazoria | Texas | 48039 | 44478 | 566 |
1617840 | 1617840 | 2021-08-14 | Brazoria | Texas | 48039 | 44478 | 566 |
1614592 | 1614592 | 2021-08-13 | Brazoria | Texas | 48039 | 44246 | 565 |
1611343 | 1611343 | 2021-08-12 | Brazoria | Texas | 48039 | 43780 | 561 |
1608095 | 1608095 | 2021-08-11 | Brazoria | Texas | 48039 | 43595 | 558 |
1604846 | 1604846 | 2021-08-10 | Brazoria | Texas | 48039 | 43028 | 553 |
1601597 | 1601597 | 2021-08-09 | Brazoria | Texas | 48039 | 42811 | 552 |
1598349 | 1598349 | 2021-08-08 | Brazoria | Texas | 48039 | 42811 | 551 |
1595100 | 1595100 | 2021-08-07 | Brazoria | Texas | 48039 | 42811 | 551 |
1591851 | 1591851 | 2021-08-06 | Brazoria | Texas | 48039 | 42182 | 551 |
1588602 | 1588602 | 2021-08-05 | Brazoria | Texas | 48039 | 42182 | 550 |
1585352 | 1585352 | 2021-08-04 | Brazoria | Texas | 48039 | 41883 | 549 |
1582102 | 1582102 | 2021-08-03 | Brazoria | Texas | 48039 | 41353 | 548 |
1578853 | 1578853 | 2021-08-02 | Brazoria | Texas | 48039 | 41092 | 546 |
1575605 | 1575605 | 2021-08-01 | Brazoria | Texas | 48039 | 41092 | 546 |
1572357 | 1572357 | 2021-07-31 | Brazoria | Texas | 48039 | 41092 | 546 |
1569109 | 1569109 | 2021-07-30 | Brazoria | Texas | 48039 | 40989 | 545 |
1565861 | 1565861 | 2021-07-29 | Brazoria | Texas | 48039 | 40694 | 542 |
1562613 | 1562613 | 2021-07-28 | Brazoria | Texas | 48039 | 40547 | 542 |
1559365 | 1559365 | 2021-07-27 | Brazoria | Texas | 48039 | 40197 | 541 |
1556118 | 1556118 | 2021-07-26 | Brazoria | Texas | 48039 | 40090 | 541 |
1552871 | 1552871 | 2021-07-25 | Brazoria | Texas | 48039 | 40090 | 541 |
1549624 | 1549624 | 2021-07-24 | Brazoria | Texas | 48039 | 40090 | 540 |
1546377 | 1546377 | 2021-07-23 | Brazoria | Texas | 48039 | 40034 | 539 |
1543130 | 1543130 | 2021-07-22 | Brazoria | Texas | 48039 | 39880 | 539 |
1539882 | 1539882 | 2021-07-21 | Brazoria | Texas | 48039 | 39743 | 539 |
1536635 | 1536635 | 2021-07-20 | Brazoria | Texas | 48039 | 39691 | 539 |
1533387 | 1533387 | 2021-07-19 | Brazoria | Texas | 48039 | 39594 | 538 |
1530140 | 1530140 | 2021-07-18 | Brazoria | Texas | 48039 | 39594 | 538 |
1526893 | 1526893 | 2021-07-17 | Brazoria | Texas | 48039 | 39594 | 538 |
1523646 | 1523646 | 2021-07-16 | Brazoria | Texas | 48039 | 39488 | 537 |
1520398 | 1520398 | 2021-07-15 | Brazoria | Texas | 48039 | 39337 | 537 |
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);