ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Travis" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1949448 | 1949448 | 2021-11-24 | Travis | Texas | 48453 | 122029 | 1465 |
1946197 | 1946197 | 2021-11-23 | Travis | Texas | 48453 | 121812 | 1464 |
1942946 | 1942946 | 2021-11-22 | Travis | Texas | 48453 | 121709 | 1464 |
1939696 | 1939696 | 2021-11-21 | Travis | Texas | 48453 | 121709 | 1463 |
1936446 | 1936446 | 2021-11-20 | Travis | Texas | 48453 | 121709 | 1463 |
1933196 | 1933196 | 2021-11-19 | Travis | Texas | 48453 | 121617 | 1463 |
1929945 | 1929945 | 2021-11-18 | Travis | Texas | 48453 | 121508 | 1462 |
1926695 | 1926695 | 2021-11-17 | Travis | Texas | 48453 | 121361 | 1462 |
1923445 | 1923445 | 2021-11-16 | Travis | Texas | 48453 | 121156 | 1461 |
1920196 | 1920196 | 2021-11-15 | Travis | Texas | 48453 | 120940 | 1461 |
1916946 | 1916946 | 2021-11-14 | Travis | Texas | 48453 | 120940 | 1460 |
1913696 | 1913696 | 2021-11-13 | Travis | Texas | 48453 | 120940 | 1458 |
1910446 | 1910446 | 2021-11-12 | Travis | Texas | 48453 | 120844 | 1456 |
1907197 | 1907197 | 2021-11-11 | Travis | Texas | 48453 | 120844 | 1452 |
1903948 | 1903948 | 2021-11-10 | Travis | Texas | 48453 | 120481 | 1447 |
1900698 | 1900698 | 2021-11-09 | Travis | Texas | 48453 | 120481 | 1447 |
1897448 | 1897448 | 2021-11-08 | Travis | Texas | 48453 | 120366 | 1446 |
1894198 | 1894198 | 2021-11-07 | Travis | Texas | 48453 | 120366 | 1445 |
1890948 | 1890948 | 2021-11-06 | Travis | Texas | 48453 | 120366 | 1445 |
1887698 | 1887698 | 2021-11-05 | Travis | Texas | 48453 | 120299 | 1442 |
1884448 | 1884448 | 2021-11-04 | Travis | Texas | 48453 | 120179 | 1439 |
1881199 | 1881199 | 2021-11-03 | Travis | Texas | 48453 | 120106 | 1438 |
1877950 | 1877950 | 2021-11-02 | Travis | Texas | 48453 | 119847 | 1436 |
1874701 | 1874701 | 2021-11-01 | Travis | Texas | 48453 | 119762 | 1434 |
1871452 | 1871452 | 2021-10-31 | Travis | Texas | 48453 | 119762 | 1433 |
1868203 | 1868203 | 2021-10-30 | Travis | Texas | 48453 | 119762 | 1431 |
1864954 | 1864954 | 2021-10-29 | Travis | Texas | 48453 | 119609 | 1431 |
1861705 | 1861705 | 2021-10-28 | Travis | Texas | 48453 | 119524 | 1429 |
1858456 | 1858456 | 2021-10-27 | Travis | Texas | 48453 | 119391 | 1426 |
1855207 | 1855207 | 2021-10-26 | Travis | Texas | 48453 | 119220 | 1419 |
1851958 | 1851958 | 2021-10-25 | Travis | Texas | 48453 | 118951 | 1415 |
1848708 | 1848708 | 2021-10-24 | Travis | Texas | 48453 | 118951 | 1413 |
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 |
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);