ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Medina" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812904 | 1812904 | 2021-10-13 | Medina | Texas | 48325 | 6792 | 156 |
1809655 | 1809655 | 2021-10-12 | Medina | Texas | 48325 | 6765 | 156 |
1806405 | 1806405 | 2021-10-11 | Medina | Texas | 48325 | 6745 | 155 |
1803155 | 1803155 | 2021-10-10 | Medina | Texas | 48325 | 6744 | 155 |
1799906 | 1799906 | 2021-10-09 | Medina | Texas | 48325 | 6744 | 155 |
1796657 | 1796657 | 2021-10-08 | Medina | Texas | 48325 | 6744 | 155 |
1793408 | 1793408 | 2021-10-07 | Medina | Texas | 48325 | 6742 | 154 |
1790159 | 1790159 | 2021-10-06 | Medina | Texas | 48325 | 6738 | 154 |
1786911 | 1786911 | 2021-10-05 | Medina | Texas | 48325 | 6658 | 154 |
1783662 | 1783662 | 2021-10-04 | Medina | Texas | 48325 | 6658 | 153 |
1780413 | 1780413 | 2021-10-03 | Medina | Texas | 48325 | 6653 | 153 |
1777163 | 1777163 | 2021-10-02 | Medina | Texas | 48325 | 6653 | 153 |
1773913 | 1773913 | 2021-10-01 | Medina | Texas | 48325 | 6653 | 152 |
1770663 | 1770663 | 2021-09-30 | Medina | Texas | 48325 | 6652 | 150 |
1767414 | 1767414 | 2021-09-29 | Medina | Texas | 48325 | 6626 | 145 |
1764165 | 1764165 | 2021-09-28 | Medina | Texas | 48325 | 6577 | 145 |
1760916 | 1760916 | 2021-09-27 | Medina | Texas | 48325 | 6565 | 144 |
1757668 | 1757668 | 2021-09-26 | Medina | Texas | 48325 | 6536 | 144 |
1754420 | 1754420 | 2021-09-25 | Medina | Texas | 48325 | 6536 | 143 |
1751172 | 1751172 | 2021-09-24 | Medina | Texas | 48325 | 6536 | 143 |
1747923 | 1747923 | 2021-09-23 | Medina | Texas | 48325 | 6536 | 140 |
1744673 | 1744673 | 2021-09-22 | Medina | Texas | 48325 | 6525 | 140 |
1741424 | 1741424 | 2021-09-21 | Medina | Texas | 48325 | 6487 | 139 |
1738175 | 1738175 | 2021-09-20 | Medina | Texas | 48325 | 6467 | 138 |
1734925 | 1734925 | 2021-09-19 | Medina | Texas | 48325 | 6404 | 138 |
1731675 | 1731675 | 2021-09-18 | Medina | Texas | 48325 | 6404 | 139 |
1728425 | 1728425 | 2021-09-17 | Medina | Texas | 48325 | 6404 | 139 |
1725176 | 1725176 | 2021-09-16 | Medina | Texas | 48325 | 6404 | 139 |
1721927 | 1721927 | 2021-09-15 | Medina | Texas | 48325 | 6356 | 139 |
1718679 | 1718679 | 2021-09-14 | Medina | Texas | 48325 | 6325 | 138 |
1715431 | 1715431 | 2021-09-13 | Medina | Texas | 48325 | 6269 | 138 |
1712185 | 1712185 | 2021-09-12 | Medina | Texas | 48325 | 6237 | 138 |
1708938 | 1708938 | 2021-09-11 | Medina | Texas | 48325 | 6237 | 137 |
1705691 | 1705691 | 2021-09-10 | Medina | Texas | 48325 | 6237 | 134 |
1702441 | 1702441 | 2021-09-09 | Medina | Texas | 48325 | 6216 | 132 |
1699192 | 1699192 | 2021-09-08 | Medina | Texas | 48325 | 6150 | 131 |
1695944 | 1695944 | 2021-09-07 | Medina | Texas | 48325 | 6035 | 131 |
1692696 | 1692696 | 2021-09-06 | Medina | Texas | 48325 | 6035 | 131 |
1689447 | 1689447 | 2021-09-05 | Medina | Texas | 48325 | 6035 | 131 |
1686197 | 1686197 | 2021-09-04 | Medina | Texas | 48325 | 6035 | 131 |
1682946 | 1682946 | 2021-09-03 | Medina | Texas | 48325 | 6020 | 131 |
1679696 | 1679696 | 2021-09-02 | Medina | Texas | 48325 | 5965 | 130 |
1676448 | 1676448 | 2021-09-01 | Medina | Texas | 48325 | 5924 | 129 |
1673201 | 1673201 | 2021-08-31 | Medina | Texas | 48325 | 5907 | 129 |
1669953 | 1669953 | 2021-08-30 | Medina | Texas | 48325 | 5796 | 128 |
1666706 | 1666706 | 2021-08-29 | Medina | Texas | 48325 | 5795 | 128 |
1663458 | 1663458 | 2021-08-28 | Medina | Texas | 48325 | 5795 | 126 |
1660210 | 1660210 | 2021-08-27 | Medina | Texas | 48325 | 5791 | 123 |
1656961 | 1656961 | 2021-08-26 | Medina | Texas | 48325 | 5754 | 123 |
1653714 | 1653714 | 2021-08-25 | Medina | Texas | 48325 | 5723 | 122 |
1650467 | 1650467 | 2021-08-24 | Medina | Texas | 48325 | 5640 | 122 |
1647218 | 1647218 | 2021-08-23 | Medina | Texas | 48325 | 5590 | 121 |
1643969 | 1643969 | 2021-08-22 | Medina | Texas | 48325 | 5586 | 121 |
1640719 | 1640719 | 2021-08-21 | Medina | Texas | 48325 | 5586 | 121 |
1637469 | 1637469 | 2021-08-20 | Medina | Texas | 48325 | 5573 | 120 |
1634219 | 1634219 | 2021-08-19 | Medina | Texas | 48325 | 5560 | 118 |
1630972 | 1630972 | 2021-08-18 | Medina | Texas | 48325 | 5515 | 118 |
1627725 | 1627725 | 2021-08-17 | Medina | Texas | 48325 | 5471 | 117 |
1624478 | 1624478 | 2021-08-16 | Medina | Texas | 48325 | 5419 | 117 |
1621231 | 1621231 | 2021-08-15 | Medina | Texas | 48325 | 5418 | 117 |
1617983 | 1617983 | 2021-08-14 | Medina | Texas | 48325 | 5418 | 117 |
1614735 | 1614735 | 2021-08-13 | Medina | Texas | 48325 | 5398 | 115 |
1611486 | 1611486 | 2021-08-12 | Medina | Texas | 48325 | 5333 | 113 |
1608238 | 1608238 | 2021-08-11 | Medina | Texas | 48325 | 5333 | 111 |
1604989 | 1604989 | 2021-08-10 | Medina | Texas | 48325 | 5291 | 111 |
1601740 | 1601740 | 2021-08-09 | Medina | Texas | 48325 | 5245 | 110 |
1598492 | 1598492 | 2021-08-08 | Medina | Texas | 48325 | 5245 | 110 |
1595243 | 1595243 | 2021-08-07 | Medina | Texas | 48325 | 5245 | 109 |
1591994 | 1591994 | 2021-08-06 | Medina | Texas | 48325 | 5232 | 109 |
1588745 | 1588745 | 2021-08-05 | Medina | Texas | 48325 | 5203 | 109 |
1585495 | 1585495 | 2021-08-04 | Medina | Texas | 48325 | 5161 | 109 |
1582245 | 1582245 | 2021-08-03 | Medina | Texas | 48325 | 5133 | 108 |
1578996 | 1578996 | 2021-08-02 | Medina | Texas | 48325 | 5073 | 108 |
1575748 | 1575748 | 2021-08-01 | Medina | Texas | 48325 | 5073 | 108 |
1572500 | 1572500 | 2021-07-31 | Medina | Texas | 48325 | 5073 | 108 |
1569252 | 1569252 | 2021-07-30 | Medina | Texas | 48325 | 5050 | 108 |
1566004 | 1566004 | 2021-07-29 | Medina | Texas | 48325 | 5031 | 108 |
1562756 | 1562756 | 2021-07-28 | Medina | Texas | 48325 | 5001 | 108 |
1559508 | 1559508 | 2021-07-27 | Medina | Texas | 48325 | 4979 | 108 |
1556261 | 1556261 | 2021-07-26 | Medina | Texas | 48325 | 4951 | 107 |
1553014 | 1553014 | 2021-07-25 | Medina | Texas | 48325 | 4951 | 107 |
1549767 | 1549767 | 2021-07-24 | Medina | Texas | 48325 | 4951 | 107 |
1546520 | 1546520 | 2021-07-23 | Medina | Texas | 48325 | 4939 | 107 |
1543273 | 1543273 | 2021-07-22 | Medina | Texas | 48325 | 4854 | 107 |
1540025 | 1540025 | 2021-07-21 | Medina | Texas | 48325 | 4812 | 107 |
1536778 | 1536778 | 2021-07-20 | Medina | Texas | 48325 | 4744 | 107 |
1533530 | 1533530 | 2021-07-19 | Medina | Texas | 48325 | 4723 | 107 |
1530283 | 1530283 | 2021-07-18 | Medina | Texas | 48325 | 4723 | 107 |
1527036 | 1527036 | 2021-07-17 | Medina | Texas | 48325 | 4723 | 107 |
1523789 | 1523789 | 2021-07-16 | Medina | Texas | 48325 | 4726 | 107 |
1520541 | 1520541 | 2021-07-15 | Medina | Texas | 48325 | 4724 | 107 |
1517293 | 1517293 | 2021-07-14 | Medina | Texas | 48325 | 4713 | 107 |
1514046 | 1514046 | 2021-07-13 | Medina | Texas | 48325 | 4703 | 107 |
1510800 | 1510800 | 2021-07-12 | Medina | Texas | 48325 | 4695 | 107 |
1507553 | 1507553 | 2021-07-11 | Medina | Texas | 48325 | 4695 | 107 |
1504307 | 1504307 | 2021-07-10 | Medina | Texas | 48325 | 4695 | 107 |
1501061 | 1501061 | 2021-07-09 | Medina | Texas | 48325 | 4692 | 107 |
1497815 | 1497815 | 2021-07-08 | Medina | Texas | 48325 | 4693 | 107 |
1494568 | 1494568 | 2021-07-07 | Medina | Texas | 48325 | 4687 | 107 |
1491321 | 1491321 | 2021-07-06 | Medina | Texas | 48325 | 4689 | 107 |
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);