ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Johnson" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1793371 | 1793371 | 2021-10-07 | Johnson | Texas | 48251 | 26967 | 497 |
1790122 | 1790122 | 2021-10-06 | Johnson | Texas | 48251 | 26824 | 496 |
1786874 | 1786874 | 2021-10-05 | Johnson | Texas | 48251 | 26731 | 494 |
1783625 | 1783625 | 2021-10-04 | Johnson | Texas | 48251 | 26560 | 488 |
1780376 | 1780376 | 2021-10-03 | Johnson | Texas | 48251 | 26560 | 488 |
1777126 | 1777126 | 2021-10-02 | Johnson | Texas | 48251 | 26560 | 487 |
1773876 | 1773876 | 2021-10-01 | Johnson | Texas | 48251 | 26458 | 483 |
1770626 | 1770626 | 2021-09-30 | Johnson | Texas | 48251 | 26375 | 478 |
1767377 | 1767377 | 2021-09-29 | Johnson | Texas | 48251 | 26262 | 471 |
1764128 | 1764128 | 2021-09-28 | Johnson | Texas | 48251 | 26169 | 465 |
1760879 | 1760879 | 2021-09-27 | Johnson | Texas | 48251 | 25947 | 463 |
1757631 | 1757631 | 2021-09-26 | Johnson | Texas | 48251 | 25947 | 462 |
1754383 | 1754383 | 2021-09-25 | Johnson | Texas | 48251 | 25947 | 462 |
1751135 | 1751135 | 2021-09-24 | Johnson | Texas | 48251 | 25734 | 458 |
1747886 | 1747886 | 2021-09-23 | Johnson | Texas | 48251 | 25734 | 457 |
1744636 | 1744636 | 2021-09-22 | Johnson | Texas | 48251 | 25544 | 451 |
1741387 | 1741387 | 2021-09-21 | Johnson | Texas | 48251 | 25521 | 448 |
1738138 | 1738138 | 2021-09-20 | Johnson | Texas | 48251 | 25298 | 445 |
1734888 | 1734888 | 2021-09-19 | Johnson | Texas | 48251 | 25298 | 445 |
1731638 | 1731638 | 2021-09-18 | Johnson | Texas | 48251 | 25298 | 447 |
1728388 | 1728388 | 2021-09-17 | Johnson | Texas | 48251 | 25162 | 444 |
1725139 | 1725139 | 2021-09-16 | Johnson | Texas | 48251 | 25008 | 441 |
1721890 | 1721890 | 2021-09-15 | Johnson | Texas | 48251 | 24836 | 438 |
1718642 | 1718642 | 2021-09-14 | Johnson | Texas | 48251 | 24724 | 435 |
1715394 | 1715394 | 2021-09-13 | Johnson | Texas | 48251 | 24463 | 434 |
1712148 | 1712148 | 2021-09-12 | Johnson | Texas | 48251 | 24463 | 434 |
1708901 | 1708901 | 2021-09-11 | Johnson | Texas | 48251 | 24463 | 434 |
1705654 | 1705654 | 2021-09-10 | Johnson | Texas | 48251 | 24348 | 433 |
1702404 | 1702404 | 2021-09-09 | Johnson | Texas | 48251 | 24167 | 429 |
1699155 | 1699155 | 2021-09-08 | Johnson | Texas | 48251 | 24119 | 427 |
1695907 | 1695907 | 2021-09-07 | Johnson | Texas | 48251 | 23631 | 424 |
1692659 | 1692659 | 2021-09-06 | Johnson | Texas | 48251 | 23631 | 423 |
1689410 | 1689410 | 2021-09-05 | Johnson | Texas | 48251 | 23631 | 423 |
1686160 | 1686160 | 2021-09-04 | Johnson | Texas | 48251 | 23631 | 423 |
1682909 | 1682909 | 2021-09-03 | Johnson | Texas | 48251 | 23522 | 418 |
1679659 | 1679659 | 2021-09-02 | Johnson | Texas | 48251 | 23278 | 418 |
1676411 | 1676411 | 2021-09-01 | Johnson | Texas | 48251 | 23121 | 417 |
1673164 | 1673164 | 2021-08-31 | Johnson | Texas | 48251 | 23048 | 416 |
1669916 | 1669916 | 2021-08-30 | Johnson | Texas | 48251 | 22776 | 413 |
1666669 | 1666669 | 2021-08-29 | Johnson | Texas | 48251 | 22776 | 413 |
1663421 | 1663421 | 2021-08-28 | Johnson | Texas | 48251 | 22776 | 411 |
1660173 | 1660173 | 2021-08-27 | Johnson | Texas | 48251 | 22776 | 411 |
1656924 | 1656924 | 2021-08-26 | Johnson | Texas | 48251 | 22629 | 407 |
1653677 | 1653677 | 2021-08-25 | Johnson | Texas | 48251 | 22556 | 405 |
1650430 | 1650430 | 2021-08-24 | Johnson | Texas | 48251 | 22440 | 402 |
1647181 | 1647181 | 2021-08-23 | Johnson | Texas | 48251 | 22326 | 399 |
1643932 | 1643932 | 2021-08-22 | Johnson | Texas | 48251 | 22326 | 399 |
1640682 | 1640682 | 2021-08-21 | Johnson | Texas | 48251 | 22326 | 398 |
1637432 | 1637432 | 2021-08-20 | Johnson | Texas | 48251 | 22250 | 398 |
1634182 | 1634182 | 2021-08-19 | Johnson | Texas | 48251 | 22218 | 398 |
1630935 | 1630935 | 2021-08-18 | Johnson | Texas | 48251 | 22062 | 396 |
1627688 | 1627688 | 2021-08-17 | Johnson | Texas | 48251 | 21963 | 396 |
1624441 | 1624441 | 2021-08-16 | Johnson | Texas | 48251 | 21763 | 396 |
1621194 | 1621194 | 2021-08-15 | Johnson | Texas | 48251 | 21763 | 396 |
1617946 | 1617946 | 2021-08-14 | Johnson | Texas | 48251 | 21763 | 395 |
1614698 | 1614698 | 2021-08-13 | Johnson | Texas | 48251 | 21686 | 394 |
1611449 | 1611449 | 2021-08-12 | Johnson | Texas | 48251 | 21619 | 393 |
1608201 | 1608201 | 2021-08-11 | Johnson | Texas | 48251 | 21495 | 393 |
1604952 | 1604952 | 2021-08-10 | Johnson | Texas | 48251 | 21400 | 389 |
1601703 | 1601703 | 2021-08-09 | Johnson | Texas | 48251 | 21241 | 388 |
1598455 | 1598455 | 2021-08-08 | Johnson | Texas | 48251 | 21241 | 388 |
1595206 | 1595206 | 2021-08-07 | Johnson | Texas | 48251 | 21241 | 388 |
1591957 | 1591957 | 2021-08-06 | Johnson | Texas | 48251 | 21182 | 387 |
1588708 | 1588708 | 2021-08-05 | Johnson | Texas | 48251 | 21121 | 386 |
1585458 | 1585458 | 2021-08-04 | Johnson | Texas | 48251 | 20986 | 385 |
1582208 | 1582208 | 2021-08-03 | Johnson | Texas | 48251 | 20951 | 384 |
1578959 | 1578959 | 2021-08-02 | Johnson | Texas | 48251 | 20782 | 384 |
1575711 | 1575711 | 2021-08-01 | Johnson | Texas | 48251 | 20782 | 384 |
1572463 | 1572463 | 2021-07-31 | Johnson | Texas | 48251 | 20782 | 384 |
1569215 | 1569215 | 2021-07-30 | Johnson | Texas | 48251 | 20682 | 384 |
1565967 | 1565967 | 2021-07-29 | Johnson | Texas | 48251 | 20639 | 383 |
1562719 | 1562719 | 2021-07-28 | Johnson | Texas | 48251 | 20551 | 382 |
1559471 | 1559471 | 2021-07-27 | Johnson | Texas | 48251 | 20534 | 381 |
1556224 | 1556224 | 2021-07-26 | Johnson | Texas | 48251 | 20452 | 381 |
1552977 | 1552977 | 2021-07-25 | Johnson | Texas | 48251 | 20452 | 381 |
1549730 | 1549730 | 2021-07-24 | Johnson | Texas | 48251 | 20453 | 381 |
1546483 | 1546483 | 2021-07-23 | Johnson | Texas | 48251 | 20427 | 381 |
1543236 | 1543236 | 2021-07-22 | Johnson | Texas | 48251 | 20402 | 381 |
1539988 | 1539988 | 2021-07-21 | Johnson | Texas | 48251 | 20360 | 380 |
1536741 | 1536741 | 2021-07-20 | Johnson | Texas | 48251 | 20355 | 380 |
1533493 | 1533493 | 2021-07-19 | Johnson | Texas | 48251 | 20348 | 380 |
1530246 | 1530246 | 2021-07-18 | Johnson | Texas | 48251 | 20348 | 380 |
1526999 | 1526999 | 2021-07-17 | Johnson | Texas | 48251 | 20348 | 380 |
1523752 | 1523752 | 2021-07-16 | Johnson | Texas | 48251 | 20325 | 380 |
1520504 | 1520504 | 2021-07-15 | Johnson | Texas | 48251 | 20310 | 380 |
1517256 | 1517256 | 2021-07-14 | Johnson | Texas | 48251 | 20279 | 380 |
1514009 | 1514009 | 2021-07-13 | Johnson | Texas | 48251 | 20277 | 380 |
1510763 | 1510763 | 2021-07-12 | Johnson | Texas | 48251 | 20233 | 380 |
1507516 | 1507516 | 2021-07-11 | Johnson | Texas | 48251 | 20233 | 380 |
1504270 | 1504270 | 2021-07-10 | Johnson | Texas | 48251 | 20233 | 379 |
1501024 | 1501024 | 2021-07-09 | Johnson | Texas | 48251 | 20245 | 379 |
1497778 | 1497778 | 2021-07-08 | Johnson | Texas | 48251 | 20227 | 379 |
1494531 | 1494531 | 2021-07-07 | Johnson | Texas | 48251 | 20219 | 379 |
1491284 | 1491284 | 2021-07-06 | Johnson | Texas | 48251 | 20216 | 379 |
1488037 | 1488037 | 2021-07-05 | Johnson | Texas | 48251 | 20204 | 379 |
1484790 | 1484790 | 2021-07-04 | Johnson | Texas | 48251 | 20204 | 379 |
1481544 | 1481544 | 2021-07-03 | Johnson | Texas | 48251 | 20204 | 379 |
1478297 | 1478297 | 2021-07-02 | Johnson | Texas | 48251 | 20180 | 377 |
1475051 | 1475051 | 2021-07-01 | Johnson | Texas | 48251 | 20162 | 376 |
1471805 | 1471805 | 2021-06-30 | Johnson | Texas | 48251 | 20158 | 376 |
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);