ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "McLennan" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718677 | 1718677 | 2021-09-14 | McLennan | Texas | 48309 | 38015 | 577 |
1715429 | 1715429 | 2021-09-13 | McLennan | Texas | 48309 | 37492 | 573 |
1712183 | 1712183 | 2021-09-12 | McLennan | Texas | 48309 | 37492 | 572 |
1708936 | 1708936 | 2021-09-11 | McLennan | Texas | 48309 | 37492 | 568 |
1705689 | 1705689 | 2021-09-10 | McLennan | Texas | 48309 | 37205 | 565 |
1702439 | 1702439 | 2021-09-09 | McLennan | Texas | 48309 | 36962 | 559 |
1699190 | 1699190 | 2021-09-08 | McLennan | Texas | 48309 | 36450 | 554 |
1695942 | 1695942 | 2021-09-07 | McLennan | Texas | 48309 | 35596 | 553 |
1692694 | 1692694 | 2021-09-06 | McLennan | Texas | 48309 | 35596 | 553 |
1689445 | 1689445 | 2021-09-05 | McLennan | Texas | 48309 | 35596 | 553 |
1686195 | 1686195 | 2021-09-04 | McLennan | Texas | 48309 | 35596 | 551 |
1682944 | 1682944 | 2021-09-03 | McLennan | Texas | 48309 | 35356 | 551 |
1679694 | 1679694 | 2021-09-02 | McLennan | Texas | 48309 | 34951 | 547 |
1676446 | 1676446 | 2021-09-01 | McLennan | Texas | 48309 | 34450 | 536 |
1673199 | 1673199 | 2021-08-31 | McLennan | Texas | 48309 | 34242 | 533 |
1669951 | 1669951 | 2021-08-30 | McLennan | Texas | 48309 | 33698 | 531 |
1666704 | 1666704 | 2021-08-29 | McLennan | Texas | 48309 | 33698 | 528 |
1663456 | 1663456 | 2021-08-28 | McLennan | Texas | 48309 | 33698 | 525 |
1660208 | 1660208 | 2021-08-27 | McLennan | Texas | 48309 | 33388 | 523 |
1656959 | 1656959 | 2021-08-26 | McLennan | Texas | 48309 | 33139 | 521 |
1653712 | 1653712 | 2021-08-25 | McLennan | Texas | 48309 | 32821 | 520 |
1650465 | 1650465 | 2021-08-24 | McLennan | Texas | 48309 | 32779 | 518 |
1647216 | 1647216 | 2021-08-23 | McLennan | Texas | 48309 | 32216 | 518 |
1643967 | 1643967 | 2021-08-22 | McLennan | Texas | 48309 | 32216 | 517 |
1640717 | 1640717 | 2021-08-21 | McLennan | Texas | 48309 | 32216 | 515 |
1637467 | 1637467 | 2021-08-20 | McLennan | Texas | 48309 | 30940 | 513 |
1634217 | 1634217 | 2021-08-19 | McLennan | Texas | 48309 | 30940 | 512 |
1630970 | 1630970 | 2021-08-18 | McLennan | Texas | 48309 | 30940 | 507 |
1627723 | 1627723 | 2021-08-17 | McLennan | Texas | 48309 | 30940 | 506 |
1624476 | 1624476 | 2021-08-16 | McLennan | Texas | 48309 | 30940 | 505 |
1621229 | 1621229 | 2021-08-15 | McLennan | Texas | 48309 | 30940 | 505 |
1617981 | 1617981 | 2021-08-14 | McLennan | Texas | 48309 | 30940 | 504 |
1614733 | 1614733 | 2021-08-13 | McLennan | Texas | 48309 | 29967 | 502 |
1611484 | 1611484 | 2021-08-12 | McLennan | Texas | 48309 | 29967 | 500 |
1608236 | 1608236 | 2021-08-11 | McLennan | Texas | 48309 | 29967 | 500 |
1604987 | 1604987 | 2021-08-10 | McLennan | Texas | 48309 | 29967 | 498 |
1601738 | 1601738 | 2021-08-09 | McLennan | Texas | 48309 | 29967 | 497 |
1598490 | 1598490 | 2021-08-08 | McLennan | Texas | 48309 | 29967 | 497 |
1595241 | 1595241 | 2021-08-07 | McLennan | Texas | 48309 | 29967 | 495 |
1591992 | 1591992 | 2021-08-06 | McLennan | Texas | 48309 | 29062 | 494 |
1588743 | 1588743 | 2021-08-05 | McLennan | Texas | 48309 | 29062 | 492 |
1585493 | 1585493 | 2021-08-04 | McLennan | Texas | 48309 | 29062 | 492 |
1582243 | 1582243 | 2021-08-03 | McLennan | Texas | 48309 | 29062 | 491 |
1578994 | 1578994 | 2021-08-02 | McLennan | Texas | 48309 | 28443 | 491 |
1575746 | 1575746 | 2021-08-01 | McLennan | Texas | 48309 | 28443 | 491 |
1572498 | 1572498 | 2021-07-31 | McLennan | Texas | 48309 | 28443 | 491 |
1569250 | 1569250 | 2021-07-30 | McLennan | Texas | 48309 | 28443 | 491 |
1566002 | 1566002 | 2021-07-29 | McLennan | Texas | 48309 | 28443 | 490 |
1562754 | 1562754 | 2021-07-28 | McLennan | Texas | 48309 | 28443 | 490 |
1559506 | 1559506 | 2021-07-27 | McLennan | Texas | 48309 | 28443 | 490 |
1556259 | 1556259 | 2021-07-26 | McLennan | Texas | 48309 | 28443 | 490 |
1553012 | 1553012 | 2021-07-25 | McLennan | Texas | 48309 | 28443 | 490 |
1549765 | 1549765 | 2021-07-24 | McLennan | Texas | 48309 | 28443 | 490 |
1546518 | 1546518 | 2021-07-23 | McLennan | Texas | 48309 | 28132 | 489 |
1543271 | 1543271 | 2021-07-22 | McLennan | Texas | 48309 | 28132 | 489 |
1540023 | 1540023 | 2021-07-21 | McLennan | Texas | 48309 | 28132 | 489 |
1536776 | 1536776 | 2021-07-20 | McLennan | Texas | 48309 | 28132 | 488 |
1533528 | 1533528 | 2021-07-19 | McLennan | Texas | 48309 | 28132 | 487 |
1530281 | 1530281 | 2021-07-18 | McLennan | Texas | 48309 | 27984 | 487 |
1527034 | 1527034 | 2021-07-17 | McLennan | Texas | 48309 | 27984 | 487 |
1523787 | 1523787 | 2021-07-16 | McLennan | Texas | 48309 | 27984 | 487 |
1520539 | 1520539 | 2021-07-15 | McLennan | Texas | 48309 | 27984 | 487 |
1517291 | 1517291 | 2021-07-14 | McLennan | Texas | 48309 | 27984 | 485 |
1514044 | 1514044 | 2021-07-13 | McLennan | Texas | 48309 | 27984 | 484 |
1510798 | 1510798 | 2021-07-12 | McLennan | Texas | 48309 | 27984 | 484 |
1507551 | 1507551 | 2021-07-11 | McLennan | Texas | 48309 | 27984 | 484 |
1504305 | 1504305 | 2021-07-10 | McLennan | Texas | 48309 | 27984 | 484 |
1501059 | 1501059 | 2021-07-09 | McLennan | Texas | 48309 | 27865 | 484 |
1497813 | 1497813 | 2021-07-08 | McLennan | Texas | 48309 | 27865 | 482 |
1494566 | 1494566 | 2021-07-07 | McLennan | Texas | 48309 | 27865 | 482 |
1491319 | 1491319 | 2021-07-06 | McLennan | Texas | 48309 | 27794 | 482 |
1488072 | 1488072 | 2021-07-05 | McLennan | Texas | 48309 | 27794 | 482 |
1484825 | 1484825 | 2021-07-04 | McLennan | Texas | 48309 | 27794 | 482 |
1481579 | 1481579 | 2021-07-03 | McLennan | Texas | 48309 | 27794 | 481 |
1478332 | 1478332 | 2021-07-02 | McLennan | Texas | 48309 | 27794 | 481 |
1475086 | 1475086 | 2021-07-01 | McLennan | Texas | 48309 | 27794 | 479 |
1471840 | 1471840 | 2021-06-30 | McLennan | Texas | 48309 | 27794 | 479 |
1468595 | 1468595 | 2021-06-29 | McLennan | Texas | 48309 | 27794 | 479 |
1465350 | 1465350 | 2021-06-28 | McLennan | Texas | 48309 | 27794 | 479 |
1462105 | 1462105 | 2021-06-27 | McLennan | Texas | 48309 | 27794 | 479 |
1458860 | 1458860 | 2021-06-26 | McLennan | Texas | 48309 | 27794 | 479 |
1455615 | 1455615 | 2021-06-25 | McLennan | Texas | 48309 | 27716 | 479 |
1452370 | 1452370 | 2021-06-24 | McLennan | Texas | 48309 | 27716 | 479 |
1449124 | 1449124 | 2021-06-23 | McLennan | Texas | 48309 | 27716 | 479 |
1445879 | 1445879 | 2021-06-22 | McLennan | Texas | 48309 | 27716 | 479 |
1442634 | 1442634 | 2021-06-21 | McLennan | Texas | 48309 | 27716 | 479 |
1439389 | 1439389 | 2021-06-20 | McLennan | Texas | 48309 | 27716 | 479 |
1436142 | 1436142 | 2021-06-19 | McLennan | Texas | 48309 | 27716 | 479 |
1432895 | 1432895 | 2021-06-18 | McLennan | Texas | 48309 | 27708 | 479 |
1429649 | 1429649 | 2021-06-17 | McLennan | Texas | 48309 | 27697 | 478 |
1426404 | 1426404 | 2021-06-16 | McLennan | Texas | 48309 | 27682 | 478 |
1423157 | 1423157 | 2021-06-15 | McLennan | Texas | 48309 | 27661 | 478 |
1419911 | 1419911 | 2021-06-14 | McLennan | Texas | 48309 | 27640 | 478 |
1416666 | 1416666 | 2021-06-13 | McLennan | Texas | 48309 | 27640 | 478 |
1413420 | 1413420 | 2021-06-12 | McLennan | Texas | 48309 | 27640 | 478 |
1410175 | 1410175 | 2021-06-11 | McLennan | Texas | 48309 | 27632 | 478 |
1406930 | 1406930 | 2021-06-10 | McLennan | Texas | 48309 | 27617 | 478 |
1403684 | 1403684 | 2021-06-09 | McLennan | Texas | 48309 | 27611 | 478 |
1400439 | 1400439 | 2021-06-08 | McLennan | Texas | 48309 | 27605 | 478 |
1397194 | 1397194 | 2021-06-07 | McLennan | Texas | 48309 | 27592 | 478 |
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);