ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 1125 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1482105 | 1482105 | 2021-07-04 | Tuscaloosa | Alabama | 1125 | 26243 | 464 |
1478858 | 1478858 | 2021-07-03 | Tuscaloosa | Alabama | 1125 | 26243 | 464 |
1475612 | 1475612 | 2021-07-02 | Tuscaloosa | Alabama | 1125 | 26243 | 464 |
1472366 | 1472366 | 2021-07-01 | Tuscaloosa | Alabama | 1125 | 26229 | 464 |
1469121 | 1469121 | 2021-06-30 | Tuscaloosa | Alabama | 1125 | 26229 | 464 |
1465876 | 1465876 | 2021-06-29 | Tuscaloosa | Alabama | 1125 | 26228 | 461 |
1462631 | 1462631 | 2021-06-28 | Tuscaloosa | Alabama | 1125 | 26228 | 461 |
1459386 | 1459386 | 2021-06-27 | Tuscaloosa | Alabama | 1125 | 26216 | 461 |
1456141 | 1456141 | 2021-06-26 | Tuscaloosa | Alabama | 1125 | 26216 | 461 |
1452896 | 1452896 | 2021-06-25 | Tuscaloosa | Alabama | 1125 | 26216 | 461 |
1449650 | 1449650 | 2021-06-24 | Tuscaloosa | Alabama | 1125 | 26186 | 460 |
1446405 | 1446405 | 2021-06-23 | Tuscaloosa | Alabama | 1125 | 26186 | 460 |
1443160 | 1443160 | 2021-06-22 | Tuscaloosa | Alabama | 1125 | 26179 | 458 |
1439915 | 1439915 | 2021-06-21 | Tuscaloosa | Alabama | 1125 | 26179 | 458 |
1436668 | 1436668 | 2021-06-20 | Tuscaloosa | Alabama | 1125 | 26173 | 458 |
1433421 | 1433421 | 2021-06-19 | Tuscaloosa | Alabama | 1125 | 26173 | 458 |
1430175 | 1430175 | 2021-06-18 | Tuscaloosa | Alabama | 1125 | 26173 | 458 |
1426930 | 1426930 | 2021-06-17 | Tuscaloosa | Alabama | 1125 | 26162 | 458 |
1423684 | 1423684 | 2021-06-16 | Tuscaloosa | Alabama | 1125 | 26162 | 458 |
1420437 | 1420437 | 2021-06-15 | Tuscaloosa | Alabama | 1125 | 26161 | 458 |
1417192 | 1417192 | 2021-06-14 | Tuscaloosa | Alabama | 1125 | 26147 | 458 |
1413946 | 1413946 | 2021-06-13 | Tuscaloosa | Alabama | 1125 | 26136 | 458 |
1410701 | 1410701 | 2021-06-12 | Tuscaloosa | Alabama | 1125 | 26136 | 458 |
1407456 | 1407456 | 2021-06-11 | Tuscaloosa | Alabama | 1125 | 26136 | 458 |
1404210 | 1404210 | 2021-06-10 | Tuscaloosa | Alabama | 1125 | 26119 | 457 |
1400965 | 1400965 | 2021-06-09 | Tuscaloosa | Alabama | 1125 | 26110 | 457 |
1397720 | 1397720 | 2021-06-08 | Tuscaloosa | Alabama | 1125 | 26105 | 457 |
1394473 | 1394473 | 2021-06-07 | Tuscaloosa | Alabama | 1125 | 26100 | 457 |
1391228 | 1391228 | 2021-06-06 | Tuscaloosa | Alabama | 1125 | 26085 | 457 |
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);