ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48453 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1845458 | 1845458 | 2021-10-23 | Travis | Texas | 48453 | 118951 | 1413 |
1842208 | 1842208 | 2021-10-22 | Travis | Texas | 48453 | 118822 | 1411 |
1838959 | 1838959 | 2021-10-21 | Travis | Texas | 48453 | 118671 | 1409 |
1835710 | 1835710 | 2021-10-20 | Travis | Texas | 48453 | 118564 | 1404 |
1832461 | 1832461 | 2021-10-19 | Travis | Texas | 48453 | 118391 | 1397 |
1829212 | 1829212 | 2021-10-18 | Travis | Texas | 48453 | 118150 | 1394 |
1825963 | 1825963 | 2021-10-17 | Travis | Texas | 48453 | 118150 | 1391 |
1822714 | 1822714 | 2021-10-16 | Travis | Texas | 48453 | 118150 | 1389 |
1819465 | 1819465 | 2021-10-15 | Travis | Texas | 48453 | 117954 | 1387 |
1816216 | 1816216 | 2021-10-14 | Travis | Texas | 48453 | 117807 | 1384 |
1812968 | 1812968 | 2021-10-13 | Travis | Texas | 48453 | 117397 | 1383 |
1809719 | 1809719 | 2021-10-12 | Travis | Texas | 48453 | 117141 | 1379 |
1806469 | 1806469 | 2021-10-11 | Travis | Texas | 48453 | 116783 | 1375 |
1803219 | 1803219 | 2021-10-10 | Travis | Texas | 48453 | 116783 | 1374 |
1799970 | 1799970 | 2021-10-09 | Travis | Texas | 48453 | 116783 | 1370 |
1796721 | 1796721 | 2021-10-08 | Travis | Texas | 48453 | 116621 | 1367 |
1793472 | 1793472 | 2021-10-07 | Travis | Texas | 48453 | 116389 | 1362 |
1790223 | 1790223 | 2021-10-06 | Travis | Texas | 48453 | 116248 | 1358 |
1786975 | 1786975 | 2021-10-05 | Travis | Texas | 48453 | 115947 | 1353 |
1783726 | 1783726 | 2021-10-04 | Travis | Texas | 48453 | 115667 | 1352 |
1780477 | 1780477 | 2021-10-03 | Travis | Texas | 48453 | 115667 | 1349 |
1777227 | 1777227 | 2021-10-02 | Travis | Texas | 48453 | 115667 | 1347 |
1773977 | 1773977 | 2021-10-01 | Travis | Texas | 48453 | 115423 | 1344 |
1770727 | 1770727 | 2021-09-30 | Travis | Texas | 48453 | 115108 | 1335 |
1767478 | 1767478 | 2021-09-29 | Travis | Texas | 48453 | 114766 | 1331 |
1764229 | 1764229 | 2021-09-28 | Travis | Texas | 48453 | 114374 | 1326 |
1760980 | 1760980 | 2021-09-27 | Travis | Texas | 48453 | 114060 | 1323 |
1757732 | 1757732 | 2021-09-26 | Travis | Texas | 48453 | 114060 | 1322 |
1754484 | 1754484 | 2021-09-25 | Travis | Texas | 48453 | 114060 | 1318 |
1751236 | 1751236 | 2021-09-24 | Travis | Texas | 48453 | 113743 | 1310 |
1747987 | 1747987 | 2021-09-23 | Travis | Texas | 48453 | 113490 | 1295 |
1744737 | 1744737 | 2021-09-22 | Travis | Texas | 48453 | 113132 | 1283 |
1741488 | 1741488 | 2021-09-21 | Travis | Texas | 48453 | 112620 | 1274 |
1738239 | 1738239 | 2021-09-20 | Travis | Texas | 48453 | 112089 | 1264 |
1734989 | 1734989 | 2021-09-19 | Travis | Texas | 48453 | 112089 | 1261 |
1731739 | 1731739 | 2021-09-18 | Travis | Texas | 48453 | 112089 | 1260 |
1728489 | 1728489 | 2021-09-17 | Travis | Texas | 48453 | 111701 | 1251 |
1725240 | 1725240 | 2021-09-16 | Travis | Texas | 48453 | 111361 | 1243 |
1721991 | 1721991 | 2021-09-15 | Travis | Texas | 48453 | 110733 | 1238 |
1718743 | 1718743 | 2021-09-14 | Travis | Texas | 48453 | 110057 | 1227 |
1715495 | 1715495 | 2021-09-13 | Travis | Texas | 48453 | 109645 | 1222 |
1712249 | 1712249 | 2021-09-12 | Travis | Texas | 48453 | 109645 | 1221 |
1709002 | 1709002 | 2021-09-11 | Travis | Texas | 48453 | 109645 | 1216 |
1705755 | 1705755 | 2021-09-10 | Travis | Texas | 48453 | 108932 | 1211 |
1702505 | 1702505 | 2021-09-09 | Travis | Texas | 48453 | 107895 | 1194 |
1699256 | 1699256 | 2021-09-08 | Travis | Texas | 48453 | 107248 | 1190 |
1696008 | 1696008 | 2021-09-07 | Travis | Texas | 48453 | 105988 | 1185 |
1692760 | 1692760 | 2021-09-06 | Travis | Texas | 48453 | 105988 | 1183 |
1689511 | 1689511 | 2021-09-05 | Travis | Texas | 48453 | 105988 | 1179 |
1686261 | 1686261 | 2021-09-04 | Travis | Texas | 48453 | 105988 | 1176 |
1683010 | 1683010 | 2021-09-03 | Travis | Texas | 48453 | 105250 | 1163 |
1679760 | 1679760 | 2021-09-02 | Travis | Texas | 48453 | 104530 | 1151 |
1676512 | 1676512 | 2021-09-01 | Travis | Texas | 48453 | 103893 | 1147 |
1673265 | 1673265 | 2021-08-31 | Travis | Texas | 48453 | 103169 | 1137 |
1670017 | 1670017 | 2021-08-30 | Travis | Texas | 48453 | 102283 | 1134 |
1666770 | 1666770 | 2021-08-29 | Travis | Texas | 48453 | 102283 | 1131 |
1663522 | 1663522 | 2021-08-28 | Travis | Texas | 48453 | 102283 | 1129 |
1660274 | 1660274 | 2021-08-27 | Travis | Texas | 48453 | 101576 | 1120 |
1657025 | 1657025 | 2021-08-26 | Travis | Texas | 48453 | 100976 | 1118 |
1653778 | 1653778 | 2021-08-25 | Travis | Texas | 48453 | 100341 | 1108 |
1650531 | 1650531 | 2021-08-24 | Travis | Texas | 48453 | 99717 | 1104 |
1647282 | 1647282 | 2021-08-23 | Travis | Texas | 48453 | 99009 | 1101 |
1644033 | 1644033 | 2021-08-22 | Travis | Texas | 48453 | 99009 | 1097 |
1640783 | 1640783 | 2021-08-21 | Travis | Texas | 48453 | 99009 | 1096 |
1637533 | 1637533 | 2021-08-20 | Travis | Texas | 48453 | 98256 | 1091 |
1634283 | 1634283 | 2021-08-19 | Travis | Texas | 48453 | 97515 | 1085 |
1631036 | 1631036 | 2021-08-18 | Travis | Texas | 48453 | 96668 | 1080 |
1627789 | 1627789 | 2021-08-17 | Travis | Texas | 48453 | 96009 | 1077 |
1624542 | 1624542 | 2021-08-16 | Travis | Texas | 48453 | 95054 | 1075 |
1621295 | 1621295 | 2021-08-15 | Travis | Texas | 48453 | 95054 | 1075 |
1618047 | 1618047 | 2021-08-14 | Travis | Texas | 48453 | 95054 | 1074 |
1614799 | 1614799 | 2021-08-13 | Travis | Texas | 48453 | 94400 | 1073 |
1611550 | 1611550 | 2021-08-12 | Travis | Texas | 48453 | 93922 | 1067 |
1608302 | 1608302 | 2021-08-11 | Travis | Texas | 48453 | 93389 | 1065 |
1605053 | 1605053 | 2021-08-10 | Travis | Texas | 48453 | 92806 | 1064 |
1601804 | 1601804 | 2021-08-09 | Travis | Texas | 48453 | 92361 | 1064 |
1598556 | 1598556 | 2021-08-08 | Travis | Texas | 48453 | 92361 | 1064 |
1595307 | 1595307 | 2021-08-07 | Travis | Texas | 48453 | 92361 | 1063 |
1592058 | 1592058 | 2021-08-06 | Travis | Texas | 48453 | 91894 | 1062 |
1588809 | 1588809 | 2021-08-05 | Travis | Texas | 48453 | 91254 | 1057 |
1585559 | 1585559 | 2021-08-04 | Travis | Texas | 48453 | 90727 | 1055 |
1582309 | 1582309 | 2021-08-03 | Travis | Texas | 48453 | 90126 | 1054 |
1579060 | 1579060 | 2021-08-02 | Travis | Texas | 48453 | 89433 | 1053 |
1575812 | 1575812 | 2021-08-01 | Travis | Texas | 48453 | 89433 | 1053 |
1572564 | 1572564 | 2021-07-31 | Travis | Texas | 48453 | 89433 | 1052 |
1569316 | 1569316 | 2021-07-30 | Travis | Texas | 48453 | 88887 | 1052 |
1566068 | 1566068 | 2021-07-29 | Travis | Texas | 48453 | 88436 | 1051 |
1562820 | 1562820 | 2021-07-28 | Travis | Texas | 48453 | 87946 | 1049 |
1559572 | 1559572 | 2021-07-27 | Travis | Texas | 48453 | 87571 | 1048 |
1556325 | 1556325 | 2021-07-26 | Travis | Texas | 48453 | 87125 | 1046 |
1553078 | 1553078 | 2021-07-25 | Travis | Texas | 48453 | 87125 | 1046 |
1549831 | 1549831 | 2021-07-24 | Travis | Texas | 48453 | 87125 | 1046 |
1546584 | 1546584 | 2021-07-23 | Travis | Texas | 48453 | 86826 | 1046 |
1543337 | 1543337 | 2021-07-22 | Travis | Texas | 48453 | 86524 | 1045 |
1540089 | 1540089 | 2021-07-21 | Travis | Texas | 48453 | 86361 | 1045 |
1536842 | 1536842 | 2021-07-20 | Travis | Texas | 48453 | 86079 | 1045 |
1533594 | 1533594 | 2021-07-19 | Travis | Texas | 48453 | 85920 | 1045 |
1530347 | 1530347 | 2021-07-18 | Travis | Texas | 48453 | 85920 | 1045 |
1527100 | 1527100 | 2021-07-17 | Travis | Texas | 48453 | 85920 | 1044 |
1523853 | 1523853 | 2021-07-16 | Travis | Texas | 48453 | 85787 | 1044 |
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);