ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 48321 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812899 | 1812899 | 2021-10-13 | Matagorda | Texas | 48321 | 6003 | 152 |
1809650 | 1809650 | 2021-10-12 | Matagorda | Texas | 48321 | 5994 | 152 |
1806400 | 1806400 | 2021-10-11 | Matagorda | Texas | 48321 | 5990 | 152 |
1803150 | 1803150 | 2021-10-10 | Matagorda | Texas | 48321 | 5982 | 152 |
1799901 | 1799901 | 2021-10-09 | Matagorda | Texas | 48321 | 5976 | 152 |
1796652 | 1796652 | 2021-10-08 | Matagorda | Texas | 48321 | 5971 | 152 |
1793403 | 1793403 | 2021-10-07 | Matagorda | Texas | 48321 | 5961 | 151 |
1790154 | 1790154 | 2021-10-06 | Matagorda | Texas | 48321 | 5954 | 149 |
1786906 | 1786906 | 2021-10-05 | Matagorda | Texas | 48321 | 5949 | 146 |
1783657 | 1783657 | 2021-10-04 | Matagorda | Texas | 48321 | 5947 | 146 |
1780408 | 1780408 | 2021-10-03 | Matagorda | Texas | 48321 | 5934 | 146 |
1777158 | 1777158 | 2021-10-02 | Matagorda | Texas | 48321 | 5928 | 146 |
1773908 | 1773908 | 2021-10-01 | Matagorda | Texas | 48321 | 5923 | 145 |
1770658 | 1770658 | 2021-09-30 | Matagorda | Texas | 48321 | 5916 | 145 |
1767409 | 1767409 | 2021-09-29 | Matagorda | Texas | 48321 | 5895 | 145 |
1764160 | 1764160 | 2021-09-28 | Matagorda | Texas | 48321 | 5869 | 144 |
1760911 | 1760911 | 2021-09-27 | Matagorda | Texas | 48321 | 5864 | 144 |
1757663 | 1757663 | 2021-09-26 | Matagorda | Texas | 48321 | 5861 | 144 |
1754415 | 1754415 | 2021-09-25 | Matagorda | Texas | 48321 | 5843 | 144 |
1751167 | 1751167 | 2021-09-24 | Matagorda | Texas | 48321 | 5822 | 144 |
1747918 | 1747918 | 2021-09-23 | Matagorda | Texas | 48321 | 5815 | 143 |
1744668 | 1744668 | 2021-09-22 | Matagorda | Texas | 48321 | 5808 | 143 |
1741419 | 1741419 | 2021-09-21 | Matagorda | Texas | 48321 | 5793 | 143 |
1738170 | 1738170 | 2021-09-20 | Matagorda | Texas | 48321 | 5779 | 141 |
1734920 | 1734920 | 2021-09-19 | Matagorda | Texas | 48321 | 5772 | 140 |
1731670 | 1731670 | 2021-09-18 | Matagorda | Texas | 48321 | 5755 | 140 |
1728420 | 1728420 | 2021-09-17 | Matagorda | Texas | 48321 | 5725 | 138 |
1725171 | 1725171 | 2021-09-16 | Matagorda | Texas | 48321 | 5706 | 137 |
1721922 | 1721922 | 2021-09-15 | Matagorda | Texas | 48321 | 5608 | 135 |
1718674 | 1718674 | 2021-09-14 | Matagorda | Texas | 48321 | 5571 | 134 |
1715426 | 1715426 | 2021-09-13 | Matagorda | Texas | 48321 | 5555 | 133 |
1712180 | 1712180 | 2021-09-12 | Matagorda | Texas | 48321 | 5547 | 133 |
1708933 | 1708933 | 2021-09-11 | Matagorda | Texas | 48321 | 5521 | 133 |
1705686 | 1705686 | 2021-09-10 | Matagorda | Texas | 48321 | 5511 | 133 |
1702436 | 1702436 | 2021-09-09 | Matagorda | Texas | 48321 | 5488 | 127 |
1699187 | 1699187 | 2021-09-08 | Matagorda | Texas | 48321 | 5466 | 125 |
1695939 | 1695939 | 2021-09-07 | Matagorda | Texas | 48321 | 5402 | 123 |
1692691 | 1692691 | 2021-09-06 | Matagorda | Texas | 48321 | 5380 | 123 |
1689442 | 1689442 | 2021-09-05 | Matagorda | Texas | 48321 | 5346 | 122 |
1686192 | 1686192 | 2021-09-04 | Matagorda | Texas | 48321 | 5280 | 122 |
1682941 | 1682941 | 2021-09-03 | Matagorda | Texas | 48321 | 5238 | 121 |
1679691 | 1679691 | 2021-09-02 | Matagorda | Texas | 48321 | 5186 | 121 |
1676443 | 1676443 | 2021-09-01 | Matagorda | Texas | 48321 | 5111 | 121 |
1673196 | 1673196 | 2021-08-31 | Matagorda | Texas | 48321 | 5090 | 119 |
1669948 | 1669948 | 2021-08-30 | Matagorda | Texas | 48321 | 5089 | 118 |
1666701 | 1666701 | 2021-08-29 | Matagorda | Texas | 48321 | 5025 | 118 |
1663453 | 1663453 | 2021-08-28 | Matagorda | Texas | 48321 | 4999 | 118 |
1660205 | 1660205 | 2021-08-27 | Matagorda | Texas | 48321 | 4970 | 118 |
1656956 | 1656956 | 2021-08-26 | Matagorda | Texas | 48321 | 4960 | 118 |
1653709 | 1653709 | 2021-08-25 | Matagorda | Texas | 48321 | 4924 | 118 |
1650462 | 1650462 | 2021-08-24 | Matagorda | Texas | 48321 | 4896 | 117 |
1647213 | 1647213 | 2021-08-23 | Matagorda | Texas | 48321 | 4879 | 117 |
1643964 | 1643964 | 2021-08-22 | Matagorda | Texas | 48321 | 4873 | 117 |
1640714 | 1640714 | 2021-08-21 | Matagorda | Texas | 48321 | 4851 | 117 |
1637464 | 1637464 | 2021-08-20 | Matagorda | Texas | 48321 | 4828 | 117 |
1634214 | 1634214 | 2021-08-19 | Matagorda | Texas | 48321 | 4815 | 117 |
1630967 | 1630967 | 2021-08-18 | Matagorda | Texas | 48321 | 4785 | 116 |
1627720 | 1627720 | 2021-08-17 | Matagorda | Texas | 48321 | 4756 | 116 |
1624473 | 1624473 | 2021-08-16 | Matagorda | Texas | 48321 | 4704 | 116 |
1621226 | 1621226 | 2021-08-15 | Matagorda | Texas | 48321 | 4685 | 116 |
1617978 | 1617978 | 2021-08-14 | Matagorda | Texas | 48321 | 4626 | 116 |
1614730 | 1614730 | 2021-08-13 | Matagorda | Texas | 48321 | 4600 | 116 |
1611481 | 1611481 | 2021-08-12 | Matagorda | Texas | 48321 | 4593 | 115 |
1608233 | 1608233 | 2021-08-11 | Matagorda | Texas | 48321 | 4580 | 115 |
1604984 | 1604984 | 2021-08-10 | Matagorda | Texas | 48321 | 4551 | 115 |
1601735 | 1601735 | 2021-08-09 | Matagorda | Texas | 48321 | 4538 | 115 |
1598487 | 1598487 | 2021-08-08 | Matagorda | Texas | 48321 | 4527 | 115 |
1595238 | 1595238 | 2021-08-07 | Matagorda | Texas | 48321 | 4513 | 115 |
1591989 | 1591989 | 2021-08-06 | Matagorda | Texas | 48321 | 4495 | 115 |
1588740 | 1588740 | 2021-08-05 | Matagorda | Texas | 48321 | 4479 | 115 |
1585490 | 1585490 | 2021-08-04 | Matagorda | Texas | 48321 | 4463 | 115 |
1582240 | 1582240 | 2021-08-03 | Matagorda | Texas | 48321 | 4444 | 115 |
1578991 | 1578991 | 2021-08-02 | Matagorda | Texas | 48321 | 4435 | 115 |
1575743 | 1575743 | 2021-08-01 | Matagorda | Texas | 48321 | 4406 | 115 |
1572495 | 1572495 | 2021-07-31 | Matagorda | Texas | 48321 | 4392 | 115 |
1569247 | 1569247 | 2021-07-30 | Matagorda | Texas | 48321 | 4387 | 115 |
1565999 | 1565999 | 2021-07-29 | Matagorda | Texas | 48321 | 4383 | 115 |
1562751 | 1562751 | 2021-07-28 | Matagorda | Texas | 48321 | 4369 | 115 |
1559503 | 1559503 | 2021-07-27 | Matagorda | Texas | 48321 | 4364 | 115 |
1556256 | 1556256 | 2021-07-26 | Matagorda | Texas | 48321 | 4361 | 115 |
1553009 | 1553009 | 2021-07-25 | Matagorda | Texas | 48321 | 4351 | 115 |
1549762 | 1549762 | 2021-07-24 | Matagorda | Texas | 48321 | 4347 | 115 |
1546515 | 1546515 | 2021-07-23 | Matagorda | Texas | 48321 | 4346 | 115 |
1543268 | 1543268 | 2021-07-22 | Matagorda | Texas | 48321 | 4340 | 115 |
1540020 | 1540020 | 2021-07-21 | Matagorda | Texas | 48321 | 4330 | 115 |
1536773 | 1536773 | 2021-07-20 | Matagorda | Texas | 48321 | 4333 | 115 |
1533525 | 1533525 | 2021-07-19 | Matagorda | Texas | 48321 | 4333 | 115 |
1530278 | 1530278 | 2021-07-18 | Matagorda | Texas | 48321 | 4333 | 115 |
1527031 | 1527031 | 2021-07-17 | Matagorda | Texas | 48321 | 4323 | 115 |
1523784 | 1523784 | 2021-07-16 | Matagorda | Texas | 48321 | 4323 | 115 |
1520536 | 1520536 | 2021-07-15 | Matagorda | Texas | 48321 | 4319 | 115 |
1517288 | 1517288 | 2021-07-14 | Matagorda | Texas | 48321 | 4319 | 115 |
1514041 | 1514041 | 2021-07-13 | Matagorda | Texas | 48321 | 4310 | 115 |
1510795 | 1510795 | 2021-07-12 | Matagorda | Texas | 48321 | 4308 | 115 |
1507548 | 1507548 | 2021-07-11 | Matagorda | Texas | 48321 | 4308 | 115 |
1504302 | 1504302 | 2021-07-10 | Matagorda | Texas | 48321 | 4300 | 115 |
1501056 | 1501056 | 2021-07-09 | Matagorda | Texas | 48321 | 4298 | 115 |
1497810 | 1497810 | 2021-07-08 | Matagorda | Texas | 48321 | 4294 | 115 |
1494563 | 1494563 | 2021-07-07 | Matagorda | Texas | 48321 | 4294 | 115 |
1491316 | 1491316 | 2021-07-06 | Matagorda | Texas | 48321 | 4292 | 115 |
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);