ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
822 rows where fips = 48029 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1851746 | 1851746 | 2021-10-25 | Bexar | Texas | 48029 | 320471 | 5072 |
1848496 | 1848496 | 2021-10-24 | Bexar | Texas | 48029 | 319170 | 5070 |
1845246 | 1845246 | 2021-10-23 | Bexar | Texas | 48029 | 319170 | 5064 |
1841996 | 1841996 | 2021-10-22 | Bexar | Texas | 48029 | 319170 | 5042 |
1838747 | 1838747 | 2021-10-21 | Bexar | Texas | 48029 | 318961 | 5026 |
1835498 | 1835498 | 2021-10-20 | Bexar | Texas | 48029 | 318747 | 5010 |
1832249 | 1832249 | 2021-10-19 | Bexar | Texas | 48029 | 318399 | 4988 |
1829000 | 1829000 | 2021-10-18 | Bexar | Texas | 48029 | 318138 | 4976 |
1825751 | 1825751 | 2021-10-17 | Bexar | Texas | 48029 | 316907 | 4981 |
1822502 | 1822502 | 2021-10-16 | Bexar | Texas | 48029 | 316907 | 4974 |
1819253 | 1819253 | 2021-10-15 | Bexar | Texas | 48029 | 316907 | 4955 |
1816004 | 1816004 | 2021-10-14 | Bexar | Texas | 48029 | 316651 | 4945 |
1812756 | 1812756 | 2021-10-13 | Bexar | Texas | 48029 | 316402 | 4925 |
1809507 | 1809507 | 2021-10-12 | Bexar | Texas | 48029 | 316092 | 4904 |
1806257 | 1806257 | 2021-10-11 | Bexar | Texas | 48029 | 315661 | 4888 |
1803007 | 1803007 | 2021-10-10 | Bexar | Texas | 48029 | 314488 | 4887 |
1799758 | 1799758 | 2021-10-09 | Bexar | Texas | 48029 | 314488 | 4880 |
1796509 | 1796509 | 2021-10-08 | Bexar | Texas | 48029 | 314488 | 4855 |
1793260 | 1793260 | 2021-10-07 | Bexar | Texas | 48029 | 314197 | 4829 |
1790011 | 1790011 | 2021-10-06 | Bexar | Texas | 48029 | 313801 | 4816 |
1786763 | 1786763 | 2021-10-05 | Bexar | Texas | 48029 | 313017 | 4793 |
1783514 | 1783514 | 2021-10-04 | Bexar | Texas | 48029 | 313017 | 4770 |
1780265 | 1780265 | 2021-10-03 | Bexar | Texas | 48029 | 311345 | 4769 |
1777015 | 1777015 | 2021-10-02 | Bexar | Texas | 48029 | 311345 | 4756 |
1773765 | 1773765 | 2021-10-01 | Bexar | Texas | 48029 | 311345 | 4727 |
1770515 | 1770515 | 2021-09-30 | Bexar | Texas | 48029 | 310969 | 4697 |
1767266 | 1767266 | 2021-09-29 | Bexar | Texas | 48029 | 310552 | 4677 |
1764017 | 1764017 | 2021-09-28 | Bexar | Texas | 48029 | 309910 | 4648 |
1760768 | 1760768 | 2021-09-27 | Bexar | Texas | 48029 | 309469 | 4637 |
1757520 | 1757520 | 2021-09-26 | Bexar | Texas | 48029 | 307529 | 4635 |
1754272 | 1754272 | 2021-09-25 | Bexar | Texas | 48029 | 307529 | 4623 |
1751024 | 1751024 | 2021-09-24 | Bexar | Texas | 48029 | 307529 | 4596 |
1747775 | 1747775 | 2021-09-23 | Bexar | Texas | 48029 | 306781 | 4574 |
1744525 | 1744525 | 2021-09-22 | Bexar | Texas | 48029 | 306210 | 4551 |
1741276 | 1741276 | 2021-09-21 | Bexar | Texas | 48029 | 305290 | 4519 |
1738027 | 1738027 | 2021-09-20 | Bexar | Texas | 48029 | 304946 | 4488 |
1734777 | 1734777 | 2021-09-19 | Bexar | Texas | 48029 | 302976 | 4487 |
1731527 | 1731527 | 2021-09-18 | Bexar | Texas | 48029 | 302976 | 4481 |
1728277 | 1728277 | 2021-09-17 | Bexar | Texas | 48029 | 302976 | 4446 |
1725028 | 1725028 | 2021-09-16 | Bexar | Texas | 48029 | 302166 | 4415 |
1721779 | 1721779 | 2021-09-15 | Bexar | Texas | 48029 | 301432 | 4387 |
1718531 | 1718531 | 2021-09-14 | Bexar | Texas | 48029 | 300275 | 4357 |
1715283 | 1715283 | 2021-09-13 | Bexar | Texas | 48029 | 299500 | 4332 |
1712037 | 1712037 | 2021-09-12 | Bexar | Texas | 48029 | 296585 | 4328 |
1708790 | 1708790 | 2021-09-11 | Bexar | Texas | 48029 | 296585 | 4316 |
1705543 | 1705543 | 2021-09-10 | Bexar | Texas | 48029 | 296585 | 4277 |
1702293 | 1702293 | 2021-09-09 | Bexar | Texas | 48029 | 295965 | 4254 |
1699044 | 1699044 | 2021-09-08 | Bexar | Texas | 48029 | 294000 | 4209 |
1695796 | 1695796 | 2021-09-07 | Bexar | Texas | 48029 | 288389 | 4189 |
1692548 | 1692548 | 2021-09-06 | Bexar | Texas | 48029 | 288389 | 4173 |
1689299 | 1689299 | 2021-09-05 | Bexar | Texas | 48029 | 288389 | 4165 |
1686049 | 1686049 | 2021-09-04 | Bexar | Texas | 48029 | 288389 | 4142 |
1682798 | 1682798 | 2021-09-03 | Bexar | Texas | 48029 | 288389 | 4111 |
1679548 | 1679548 | 2021-09-02 | Bexar | Texas | 48029 | 287423 | 4082 |
1676300 | 1676300 | 2021-09-01 | Bexar | Texas | 48029 | 285742 | 4045 |
1673053 | 1673053 | 2021-08-31 | Bexar | Texas | 48029 | 283785 | 4024 |
1669805 | 1669805 | 2021-08-30 | Bexar | Texas | 48029 | 282921 | 4002 |
1666558 | 1666558 | 2021-08-29 | Bexar | Texas | 48029 | 279378 | 4000 |
1663310 | 1663310 | 2021-08-28 | Bexar | Texas | 48029 | 279378 | 3984 |
1660062 | 1660062 | 2021-08-27 | Bexar | Texas | 48029 | 279378 | 3964 |
1656813 | 1656813 | 2021-08-26 | Bexar | Texas | 48029 | 277788 | 3926 |
1653566 | 1653566 | 2021-08-25 | Bexar | Texas | 48029 | 276447 | 3900 |
1650319 | 1650319 | 2021-08-24 | Bexar | Texas | 48029 | 275179 | 3883 |
1647070 | 1647070 | 2021-08-23 | Bexar | Texas | 48029 | 273925 | 3867 |
1643821 | 1643821 | 2021-08-22 | Bexar | Texas | 48029 | 270223 | 3864 |
1640571 | 1640571 | 2021-08-21 | Bexar | Texas | 48029 | 270223 | 3859 |
1637321 | 1637321 | 2021-08-20 | Bexar | Texas | 48029 | 270223 | 3834 |
1634071 | 1634071 | 2021-08-19 | Bexar | Texas | 48029 | 268982 | 3814 |
1630824 | 1630824 | 2021-08-18 | Bexar | Texas | 48029 | 267642 | 3796 |
1627577 | 1627577 | 2021-08-17 | Bexar | Texas | 48029 | 266039 | 3779 |
1624330 | 1624330 | 2021-08-16 | Bexar | Texas | 48029 | 264250 | 3770 |
1621083 | 1621083 | 2021-08-15 | Bexar | Texas | 48029 | 259648 | 3770 |
1617835 | 1617835 | 2021-08-14 | Bexar | Texas | 48029 | 259648 | 3766 |
1614587 | 1614587 | 2021-08-13 | Bexar | Texas | 48029 | 259648 | 3754 |
1611338 | 1611338 | 2021-08-12 | Bexar | Texas | 48029 | 257806 | 3739 |
1608090 | 1608090 | 2021-08-11 | Bexar | Texas | 48029 | 256594 | 3728 |
1604841 | 1604841 | 2021-08-10 | Bexar | Texas | 48029 | 254645 | 3718 |
1601592 | 1601592 | 2021-08-09 | Bexar | Texas | 48029 | 252731 | 3710 |
1598344 | 1598344 | 2021-08-08 | Bexar | Texas | 48029 | 249550 | 3710 |
1595095 | 1595095 | 2021-08-07 | Bexar | Texas | 48029 | 249550 | 3707 |
1591846 | 1591846 | 2021-08-06 | Bexar | Texas | 48029 | 249550 | 3700 |
1588597 | 1588597 | 2021-08-05 | Bexar | Texas | 48029 | 248196 | 3695 |
1585347 | 1585347 | 2021-08-04 | Bexar | Texas | 48029 | 244814 | 3689 |
1582097 | 1582097 | 2021-08-03 | Bexar | Texas | 48029 | 244814 | 3684 |
1578848 | 1578848 | 2021-08-02 | Bexar | Texas | 48029 | 239062 | 3681 |
1575600 | 1575600 | 2021-08-01 | Bexar | Texas | 48029 | 239062 | 3681 |
1572352 | 1572352 | 2021-07-31 | Bexar | Texas | 48029 | 239062 | 3680 |
1569104 | 1569104 | 2021-07-30 | Bexar | Texas | 48029 | 239062 | 3679 |
1565856 | 1565856 | 2021-07-29 | Bexar | Texas | 48029 | 239062 | 3677 |
1562608 | 1562608 | 2021-07-28 | Bexar | Texas | 48029 | 236694 | 3676 |
1559360 | 1559360 | 2021-07-27 | Bexar | Texas | 48029 | 236694 | 3674 |
1556113 | 1556113 | 2021-07-26 | Bexar | Texas | 48029 | 233179 | 3670 |
1552866 | 1552866 | 2021-07-25 | Bexar | Texas | 48029 | 233179 | 3670 |
1549619 | 1549619 | 2021-07-24 | Bexar | Texas | 48029 | 233179 | 3667 |
1546372 | 1546372 | 2021-07-23 | Bexar | Texas | 48029 | 233179 | 3667 |
1543125 | 1543125 | 2021-07-22 | Bexar | Texas | 48029 | 233179 | 3659 |
1539877 | 1539877 | 2021-07-21 | Bexar | Texas | 48029 | 233179 | 3658 |
1536630 | 1536630 | 2021-07-20 | Bexar | Texas | 48029 | 230635 | 3655 |
1533382 | 1533382 | 2021-07-19 | Bexar | Texas | 48029 | 230635 | 3654 |
1530135 | 1530135 | 2021-07-18 | Bexar | Texas | 48029 | 230635 | 3654 |
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);