ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Tuscaloosa" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1806930 | 1806930 | 2021-10-12 | Tuscaloosa | Alabama | 1125 | 34766 | 586 |
1803679 | 1803679 | 2021-10-11 | Tuscaloosa | Alabama | 1125 | 34742 | 586 |
1800430 | 1800430 | 2021-10-10 | Tuscaloosa | Alabama | 1125 | 34709 | 586 |
1797181 | 1797181 | 2021-10-09 | Tuscaloosa | Alabama | 1125 | 34677 | 586 |
1793932 | 1793932 | 2021-10-08 | Tuscaloosa | Alabama | 1125 | 34639 | 579 |
1790683 | 1790683 | 2021-10-07 | Tuscaloosa | Alabama | 1125 | 34589 | 576 |
1787435 | 1787435 | 2021-10-06 | Tuscaloosa | Alabama | 1125 | 34544 | 570 |
1784186 | 1784186 | 2021-10-05 | Tuscaloosa | Alabama | 1125 | 34494 | 569 |
1780937 | 1780937 | 2021-10-04 | Tuscaloosa | Alabama | 1125 | 34442 | 567 |
1777687 | 1777687 | 2021-10-03 | Tuscaloosa | Alabama | 1125 | 34420 | 567 |
1774437 | 1774437 | 2021-10-02 | Tuscaloosa | Alabama | 1125 | 34395 | 567 |
1771187 | 1771187 | 2021-10-01 | Tuscaloosa | Alabama | 1125 | 34333 | 558 |
1767938 | 1767938 | 2021-09-30 | Tuscaloosa | Alabama | 1125 | 34266 | 554 |
1764689 | 1764689 | 2021-09-29 | Tuscaloosa | Alabama | 1125 | 34201 | 550 |
1761440 | 1761440 | 2021-09-28 | Tuscaloosa | Alabama | 1125 | 34122 | 550 |
1758192 | 1758192 | 2021-09-27 | Tuscaloosa | Alabama | 1125 | 34034 | 548 |
1754944 | 1754944 | 2021-09-26 | Tuscaloosa | Alabama | 1125 | 33931 | 548 |
1751696 | 1751696 | 2021-09-25 | Tuscaloosa | Alabama | 1125 | 33818 | 548 |
1748447 | 1748447 | 2021-09-24 | Tuscaloosa | Alabama | 1125 | 33661 | 547 |
1745197 | 1745197 | 2021-09-23 | Tuscaloosa | Alabama | 1125 | 33540 | 540 |
1741948 | 1741948 | 2021-09-22 | Tuscaloosa | Alabama | 1125 | 33410 | 532 |
1738699 | 1738699 | 2021-09-21 | Tuscaloosa | Alabama | 1125 | 33308 | 517 |
1735450 | 1735450 | 2021-09-20 | Tuscaloosa | Alabama | 1125 | 33187 | 512 |
1732200 | 1732200 | 2021-09-19 | Tuscaloosa | Alabama | 1125 | 33128 | 512 |
1728950 | 1728950 | 2021-09-18 | Tuscaloosa | Alabama | 1125 | 33029 | 512 |
1725700 | 1725700 | 2021-09-17 | Tuscaloosa | Alabama | 1125 | 32903 | 508 |
1722451 | 1722451 | 2021-09-16 | Tuscaloosa | Alabama | 1125 | 32719 | 498 |
1719203 | 1719203 | 2021-09-15 | Tuscaloosa | Alabama | 1125 | 32576 | 495 |
1715955 | 1715955 | 2021-09-14 | Tuscaloosa | Alabama | 1125 | 32385 | 493 |
1712709 | 1712709 | 2021-09-13 | Tuscaloosa | Alabama | 1125 | 32196 | 491 |
1709462 | 1709462 | 2021-09-12 | Tuscaloosa | Alabama | 1125 | 32045 | 491 |
1706215 | 1706215 | 2021-09-11 | Tuscaloosa | Alabama | 1125 | 31967 | 491 |
1702967 | 1702967 | 2021-09-10 | Tuscaloosa | Alabama | 1125 | 31795 | 491 |
1699717 | 1699717 | 2021-09-09 | Tuscaloosa | Alabama | 1125 | 31649 | 489 |
1696468 | 1696468 | 2021-09-08 | Tuscaloosa | Alabama | 1125 | 31446 | 489 |
1693220 | 1693220 | 2021-09-07 | Tuscaloosa | Alabama | 1125 | 31248 | 487 |
1689971 | 1689971 | 2021-09-06 | Tuscaloosa | Alabama | 1125 | 31169 | 487 |
1686721 | 1686721 | 2021-09-05 | Tuscaloosa | Alabama | 1125 | 31105 | 487 |
1683471 | 1683471 | 2021-09-04 | Tuscaloosa | Alabama | 1125 | 30983 | 487 |
1680220 | 1680220 | 2021-09-03 | Tuscaloosa | Alabama | 1125 | 30793 | 487 |
1676972 | 1676972 | 2021-09-02 | Tuscaloosa | Alabama | 1125 | 30607 | 486 |
1673725 | 1673725 | 2021-09-01 | Tuscaloosa | Alabama | 1125 | 30360 | 486 |
1670477 | 1670477 | 2021-08-31 | Tuscaloosa | Alabama | 1125 | 30178 | 486 |
1667230 | 1667230 | 2021-08-30 | Tuscaloosa | Alabama | 1125 | 30023 | 484 |
1663982 | 1663982 | 2021-08-29 | Tuscaloosa | Alabama | 1125 | 29912 | 484 |
1660734 | 1660734 | 2021-08-28 | Tuscaloosa | Alabama | 1125 | 29801 | 484 |
1657486 | 1657486 | 2021-08-27 | Tuscaloosa | Alabama | 1125 | 29599 | 483 |
1654238 | 1654238 | 2021-08-26 | Tuscaloosa | Alabama | 1125 | 29447 | 482 |
1650992 | 1650992 | 2021-08-25 | Tuscaloosa | Alabama | 1125 | 29142 | 479 |
1647743 | 1647743 | 2021-08-24 | Tuscaloosa | Alabama | 1125 | 29142 | 479 |
1644494 | 1644494 | 2021-08-23 | Tuscaloosa | Alabama | 1125 | 29142 | 479 |
1641244 | 1641244 | 2021-08-22 | Tuscaloosa | Alabama | 1125 | 29099 | 479 |
1637994 | 1637994 | 2021-08-21 | Tuscaloosa | Alabama | 1125 | 29020 | 479 |
1634744 | 1634744 | 2021-08-20 | Tuscaloosa | Alabama | 1125 | 28885 | 478 |
1631496 | 1631496 | 2021-08-19 | Tuscaloosa | Alabama | 1125 | 28778 | 476 |
1628249 | 1628249 | 2021-08-18 | Tuscaloosa | Alabama | 1125 | 28691 | 475 |
1625002 | 1625002 | 2021-08-17 | Tuscaloosa | Alabama | 1125 | 28597 | 473 |
1621755 | 1621755 | 2021-08-16 | Tuscaloosa | Alabama | 1125 | 28454 | 473 |
1618507 | 1618507 | 2021-08-15 | Tuscaloosa | Alabama | 1125 | 28416 | 473 |
1615259 | 1615259 | 2021-08-14 | Tuscaloosa | Alabama | 1125 | 28261 | 472 |
1612010 | 1612010 | 2021-08-13 | Tuscaloosa | Alabama | 1125 | 28261 | 472 |
1608763 | 1608763 | 2021-08-12 | Tuscaloosa | Alabama | 1125 | 28148 | 470 |
1605514 | 1605514 | 2021-08-11 | Tuscaloosa | Alabama | 1125 | 28048 | 469 |
1602264 | 1602264 | 2021-08-10 | Tuscaloosa | Alabama | 1125 | 27943 | 467 |
1599016 | 1599016 | 2021-08-09 | Tuscaloosa | Alabama | 1125 | 27853 | 466 |
1595767 | 1595767 | 2021-08-08 | Tuscaloosa | Alabama | 1125 | 27714 | 466 |
1592518 | 1592518 | 2021-08-07 | Tuscaloosa | Alabama | 1125 | 27714 | 466 |
1589269 | 1589269 | 2021-08-06 | Tuscaloosa | Alabama | 1125 | 27630 | 466 |
1586020 | 1586020 | 2021-08-05 | Tuscaloosa | Alabama | 1125 | 27540 | 465 |
1582770 | 1582770 | 2021-08-04 | Tuscaloosa | Alabama | 1125 | 27422 | 465 |
1579520 | 1579520 | 2021-08-03 | Tuscaloosa | Alabama | 1125 | 27344 | 465 |
1576272 | 1576272 | 2021-08-02 | Tuscaloosa | Alabama | 1125 | 27208 | 465 |
1573024 | 1573024 | 2021-08-01 | Tuscaloosa | Alabama | 1125 | 27171 | 465 |
1569776 | 1569776 | 2021-07-31 | Tuscaloosa | Alabama | 1125 | 27145 | 465 |
1566528 | 1566528 | 2021-07-30 | Tuscaloosa | Alabama | 1125 | 27009 | 465 |
1563280 | 1563280 | 2021-07-29 | Tuscaloosa | Alabama | 1125 | 27009 | 465 |
1560032 | 1560032 | 2021-07-28 | Tuscaloosa | Alabama | 1125 | 26915 | 465 |
1556785 | 1556785 | 2021-07-27 | Tuscaloosa | Alabama | 1125 | 26841 | 465 |
1553538 | 1553538 | 2021-07-26 | Tuscaloosa | Alabama | 1125 | 26792 | 465 |
1550291 | 1550291 | 2021-07-25 | Tuscaloosa | Alabama | 1125 | 26757 | 465 |
1547044 | 1547044 | 2021-07-24 | Tuscaloosa | Alabama | 1125 | 26717 | 465 |
1543797 | 1543797 | 2021-07-23 | Tuscaloosa | Alabama | 1125 | 26667 | 465 |
1540549 | 1540549 | 2021-07-22 | Tuscaloosa | Alabama | 1125 | 26589 | 465 |
1537302 | 1537302 | 2021-07-21 | Tuscaloosa | Alabama | 1125 | 26561 | 465 |
1534054 | 1534054 | 2021-07-20 | Tuscaloosa | Alabama | 1125 | 26491 | 465 |
1530807 | 1530807 | 2021-07-19 | Tuscaloosa | Alabama | 1125 | 26463 | 465 |
1527560 | 1527560 | 2021-07-18 | Tuscaloosa | Alabama | 1125 | 26433 | 465 |
1524313 | 1524313 | 2021-07-17 | Tuscaloosa | Alabama | 1125 | 26419 | 465 |
1521065 | 1521065 | 2021-07-16 | Tuscaloosa | Alabama | 1125 | 26403 | 465 |
1517817 | 1517817 | 2021-07-15 | Tuscaloosa | Alabama | 1125 | 26389 | 465 |
1514570 | 1514570 | 2021-07-14 | Tuscaloosa | Alabama | 1125 | 26369 | 465 |
1511324 | 1511324 | 2021-07-13 | Tuscaloosa | Alabama | 1125 | 26346 | 465 |
1508077 | 1508077 | 2021-07-12 | Tuscaloosa | Alabama | 1125 | 26346 | 465 |
1504831 | 1504831 | 2021-07-11 | Tuscaloosa | Alabama | 1125 | 26332 | 465 |
1501585 | 1501585 | 2021-07-10 | Tuscaloosa | Alabama | 1125 | 26332 | 465 |
1498339 | 1498339 | 2021-07-09 | Tuscaloosa | Alabama | 1125 | 26323 | 465 |
1495092 | 1495092 | 2021-07-08 | Tuscaloosa | Alabama | 1125 | 26301 | 465 |
1491845 | 1491845 | 2021-07-07 | Tuscaloosa | Alabama | 1125 | 26301 | 465 |
1488598 | 1488598 | 2021-07-06 | Tuscaloosa | Alabama | 1125 | 26243 | 464 |
1485351 | 1485351 | 2021-07-05 | Tuscaloosa | Alabama | 1125 | 26243 | 464 |
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);