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 |
---|---|---|---|---|---|---|---|
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 |
1488074 | 1488074 | 2021-07-05 | Medina | Texas | 48325 | 4676 | 107 |
1484827 | 1484827 | 2021-07-04 | Medina | Texas | 48325 | 4679 | 107 |
1481581 | 1481581 | 2021-07-03 | Medina | Texas | 48325 | 4679 | 107 |
1478334 | 1478334 | 2021-07-02 | Medina | Texas | 48325 | 4679 | 107 |
1475088 | 1475088 | 2021-07-01 | Medina | Texas | 48325 | 4673 | 107 |
1471842 | 1471842 | 2021-06-30 | Medina | Texas | 48325 | 4667 | 107 |
1468597 | 1468597 | 2021-06-29 | Medina | Texas | 48325 | 4661 | 107 |
1465352 | 1465352 | 2021-06-28 | Medina | Texas | 48325 | 4640 | 107 |
1462107 | 1462107 | 2021-06-27 | Medina | Texas | 48325 | 4640 | 107 |
1458862 | 1458862 | 2021-06-26 | Medina | Texas | 48325 | 4640 | 107 |
1455617 | 1455617 | 2021-06-25 | Medina | Texas | 48325 | 4631 | 107 |
1452372 | 1452372 | 2021-06-24 | Medina | Texas | 48325 | 4627 | 107 |
1449126 | 1449126 | 2021-06-23 | Medina | Texas | 48325 | 4624 | 107 |
1445881 | 1445881 | 2021-06-22 | Medina | Texas | 48325 | 4733 | 107 |
1442636 | 1442636 | 2021-06-21 | Medina | Texas | 48325 | 4733 | 107 |
1439391 | 1439391 | 2021-06-20 | Medina | Texas | 48325 | 4733 | 107 |
1436144 | 1436144 | 2021-06-19 | Medina | Texas | 48325 | 4733 | 107 |
1432897 | 1432897 | 2021-06-18 | Medina | Texas | 48325 | 4732 | 107 |
1429651 | 1429651 | 2021-06-17 | Medina | Texas | 48325 | 4733 | 107 |
1426406 | 1426406 | 2021-06-16 | Medina | Texas | 48325 | 4732 | 106 |
1423159 | 1423159 | 2021-06-15 | Medina | Texas | 48325 | 4727 | 106 |
1419913 | 1419913 | 2021-06-14 | Medina | Texas | 48325 | 4722 | 106 |
1416668 | 1416668 | 2021-06-13 | Medina | Texas | 48325 | 4722 | 106 |
1413422 | 1413422 | 2021-06-12 | Medina | Texas | 48325 | 4722 | 106 |
1410177 | 1410177 | 2021-06-11 | Medina | Texas | 48325 | 5128 | 106 |
1406932 | 1406932 | 2021-06-10 | Medina | Texas | 48325 | 5129 | 106 |
1403686 | 1403686 | 2021-06-09 | Medina | Texas | 48325 | 5117 | 106 |
1400441 | 1400441 | 2021-06-08 | Medina | Texas | 48325 | 5109 | 106 |
1397196 | 1397196 | 2021-06-07 | Medina | Texas | 48325 | 5102 | 106 |
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);