ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48167 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1842065 | 1842065 | 2021-10-22 | Galveston | Texas | 48167 | 63798 | 692 |
1838816 | 1838816 | 2021-10-21 | Galveston | Texas | 48167 | 63752 | 690 |
1835567 | 1835567 | 2021-10-20 | Galveston | Texas | 48167 | 63709 | 690 |
1832318 | 1832318 | 2021-10-19 | Galveston | Texas | 48167 | 63665 | 688 |
1829069 | 1829069 | 2021-10-18 | Galveston | Texas | 48167 | 63533 | 685 |
1825820 | 1825820 | 2021-10-17 | Galveston | Texas | 48167 | 63533 | 683 |
1822571 | 1822571 | 2021-10-16 | Galveston | Texas | 48167 | 63456 | 680 |
1819322 | 1819322 | 2021-10-15 | Galveston | Texas | 48167 | 63357 | 680 |
1816073 | 1816073 | 2021-10-14 | Galveston | Texas | 48167 | 63290 | 679 |
1812825 | 1812825 | 2021-10-13 | Galveston | Texas | 48167 | 63145 | 676 |
1809576 | 1809576 | 2021-10-12 | Galveston | Texas | 48167 | 62992 | 676 |
1806326 | 1806326 | 2021-10-11 | Galveston | Texas | 48167 | 62927 | 674 |
1803076 | 1803076 | 2021-10-10 | Galveston | Texas | 48167 | 62927 | 674 |
1799827 | 1799827 | 2021-10-09 | Galveston | Texas | 48167 | 62889 | 671 |
1796578 | 1796578 | 2021-10-08 | Galveston | Texas | 48167 | 62797 | 668 |
1793329 | 1793329 | 2021-10-07 | Galveston | Texas | 48167 | 62715 | 665 |
1790080 | 1790080 | 2021-10-06 | Galveston | Texas | 48167 | 62618 | 664 |
1786832 | 1786832 | 2021-10-05 | Galveston | Texas | 48167 | 62490 | 658 |
1783583 | 1783583 | 2021-10-04 | Galveston | Texas | 48167 | 62372 | 657 |
1780334 | 1780334 | 2021-10-03 | Galveston | Texas | 48167 | 62372 | 655 |
1777084 | 1777084 | 2021-10-02 | Galveston | Texas | 48167 | 62263 | 652 |
1773834 | 1773834 | 2021-10-01 | Galveston | Texas | 48167 | 62091 | 650 |
1770584 | 1770584 | 2021-09-30 | Galveston | Texas | 48167 | 61964 | 646 |
1767335 | 1767335 | 2021-09-29 | Galveston | Texas | 48167 | 61823 | 644 |
1764086 | 1764086 | 2021-09-28 | Galveston | Texas | 48167 | 61714 | 640 |
1760837 | 1760837 | 2021-09-27 | Galveston | Texas | 48167 | 61517 | 637 |
1757589 | 1757589 | 2021-09-26 | Galveston | Texas | 48167 | 61517 | 637 |
1754341 | 1754341 | 2021-09-25 | Galveston | Texas | 48167 | 61333 | 634 |
1751093 | 1751093 | 2021-09-24 | Galveston | Texas | 48167 | 61146 | 631 |
1747844 | 1747844 | 2021-09-23 | Galveston | Texas | 48167 | 60925 | 623 |
1744594 | 1744594 | 2021-09-22 | Galveston | Texas | 48167 | 60732 | 617 |
1741345 | 1741345 | 2021-09-21 | Galveston | Texas | 48167 | 60545 | 611 |
1738096 | 1738096 | 2021-09-20 | Galveston | Texas | 48167 | 60163 | 607 |
1734846 | 1734846 | 2021-09-19 | Galveston | Texas | 48167 | 60163 | 606 |
1731596 | 1731596 | 2021-09-18 | Galveston | Texas | 48167 | 59974 | 603 |
1728346 | 1728346 | 2021-09-17 | Galveston | Texas | 48167 | 59730 | 597 |
1725097 | 1725097 | 2021-09-16 | Galveston | Texas | 48167 | 59537 | 592 |
1721848 | 1721848 | 2021-09-15 | Galveston | Texas | 48167 | 59336 | 589 |
1718600 | 1718600 | 2021-09-14 | Galveston | Texas | 48167 | 58980 | 586 |
1715352 | 1715352 | 2021-09-13 | Galveston | Texas | 48167 | 58267 | 579 |
1712106 | 1712106 | 2021-09-12 | Galveston | Texas | 48167 | 58267 | 577 |
1708859 | 1708859 | 2021-09-11 | Galveston | Texas | 48167 | 57932 | 575 |
1705612 | 1705612 | 2021-09-10 | Galveston | Texas | 48167 | 57670 | 567 |
1702362 | 1702362 | 2021-09-09 | Galveston | Texas | 48167 | 57460 | 563 |
1699113 | 1699113 | 2021-09-08 | Galveston | Texas | 48167 | 57242 | 554 |
1695865 | 1695865 | 2021-09-07 | Galveston | Texas | 48167 | 56239 | 547 |
1692617 | 1692617 | 2021-09-06 | Galveston | Texas | 48167 | 56239 | 542 |
1689368 | 1689368 | 2021-09-05 | Galveston | Texas | 48167 | 56239 | 541 |
1686118 | 1686118 | 2021-09-04 | Galveston | Texas | 48167 | 55824 | 537 |
1682867 | 1682867 | 2021-09-03 | Galveston | Texas | 48167 | 55597 | 534 |
1679617 | 1679617 | 2021-09-02 | Galveston | Texas | 48167 | 55056 | 532 |
1676369 | 1676369 | 2021-09-01 | Galveston | Texas | 48167 | 54774 | 531 |
1673122 | 1673122 | 2021-08-31 | Galveston | Texas | 48167 | 54408 | 526 |
1669874 | 1669874 | 2021-08-30 | Galveston | Texas | 48167 | 53944 | 523 |
1666627 | 1666627 | 2021-08-29 | Galveston | Texas | 48167 | 53944 | 523 |
1663379 | 1663379 | 2021-08-28 | Galveston | Texas | 48167 | 53505 | 520 |
1660131 | 1660131 | 2021-08-27 | Galveston | Texas | 48167 | 52951 | 511 |
1656882 | 1656882 | 2021-08-26 | Galveston | Texas | 48167 | 52705 | 507 |
1653635 | 1653635 | 2021-08-25 | Galveston | Texas | 48167 | 52490 | 503 |
1650388 | 1650388 | 2021-08-24 | Galveston | Texas | 48167 | 52035 | 496 |
1647139 | 1647139 | 2021-08-23 | Galveston | Texas | 48167 | 51565 | 495 |
1643890 | 1643890 | 2021-08-22 | Galveston | Texas | 48167 | 51565 | 494 |
1640640 | 1640640 | 2021-08-21 | Galveston | Texas | 48167 | 51237 | 491 |
1637390 | 1637390 | 2021-08-20 | Galveston | Texas | 48167 | 50866 | 489 |
1634140 | 1634140 | 2021-08-19 | Galveston | Texas | 48167 | 50533 | 489 |
1630893 | 1630893 | 2021-08-18 | Galveston | Texas | 48167 | 50243 | 483 |
1627646 | 1627646 | 2021-08-17 | Galveston | Texas | 48167 | 49937 | 478 |
1624399 | 1624399 | 2021-08-16 | Galveston | Texas | 48167 | 49274 | 476 |
1621152 | 1621152 | 2021-08-15 | Galveston | Texas | 48167 | 48919 | 476 |
1617904 | 1617904 | 2021-08-14 | Galveston | Texas | 48167 | 48919 | 476 |
1614656 | 1614656 | 2021-08-13 | Galveston | Texas | 48167 | 48581 | 474 |
1611407 | 1611407 | 2021-08-12 | Galveston | Texas | 48167 | 48185 | 473 |
1608159 | 1608159 | 2021-08-11 | Galveston | Texas | 48167 | 47978 | 470 |
1604910 | 1604910 | 2021-08-10 | Galveston | Texas | 48167 | 47653 | 469 |
1601661 | 1601661 | 2021-08-09 | Galveston | Texas | 48167 | 47062 | 469 |
1598413 | 1598413 | 2021-08-08 | Galveston | Texas | 48167 | 47062 | 469 |
1595164 | 1595164 | 2021-08-07 | Galveston | Texas | 48167 | 46641 | 469 |
1591915 | 1591915 | 2021-08-06 | Galveston | Texas | 48167 | 46171 | 466 |
1588666 | 1588666 | 2021-08-05 | Galveston | Texas | 48167 | 45807 | 465 |
1585416 | 1585416 | 2021-08-04 | Galveston | Texas | 48167 | 45499 | 463 |
1582166 | 1582166 | 2021-08-03 | Galveston | Texas | 48167 | 45108 | 459 |
1578917 | 1578917 | 2021-08-02 | Galveston | Texas | 48167 | 44698 | 459 |
1575669 | 1575669 | 2021-08-01 | Galveston | Texas | 48167 | 44384 | 459 |
1572421 | 1572421 | 2021-07-31 | Galveston | Texas | 48167 | 44384 | 459 |
1569173 | 1569173 | 2021-07-30 | Galveston | Texas | 48167 | 44099 | 459 |
1565925 | 1565925 | 2021-07-29 | Galveston | Texas | 48167 | 43864 | 459 |
1562677 | 1562677 | 2021-07-28 | Galveston | Texas | 48167 | 43528 | 459 |
1559429 | 1559429 | 2021-07-27 | Galveston | Texas | 48167 | 43241 | 456 |
1556182 | 1556182 | 2021-07-26 | Galveston | Texas | 48167 | 42809 | 456 |
1552935 | 1552935 | 2021-07-25 | Galveston | Texas | 48167 | 42809 | 456 |
1549688 | 1549688 | 2021-07-24 | Galveston | Texas | 48167 | 42809 | 456 |
1546441 | 1546441 | 2021-07-23 | Galveston | Texas | 48167 | 42649 | 456 |
1543194 | 1543194 | 2021-07-22 | Galveston | Texas | 48167 | 42507 | 455 |
1539946 | 1539946 | 2021-07-21 | Galveston | Texas | 48167 | 42405 | 453 |
1536699 | 1536699 | 2021-07-20 | Galveston | Texas | 48167 | 42274 | 453 |
1533451 | 1533451 | 2021-07-19 | Galveston | Texas | 48167 | 42047 | 452 |
1530204 | 1530204 | 2021-07-18 | Galveston | Texas | 48167 | 42047 | 452 |
1526957 | 1526957 | 2021-07-17 | Galveston | Texas | 48167 | 42047 | 451 |
1523710 | 1523710 | 2021-07-16 | Galveston | Texas | 48167 | 41953 | 450 |
1520462 | 1520462 | 2021-07-15 | Galveston | Texas | 48167 | 41838 | 448 |
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);