ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 1121 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712707 | 1712707 | 2021-09-13 | Talladega | Alabama | 1121 | 11886 | 197 |
1709460 | 1709460 | 2021-09-12 | Talladega | Alabama | 1121 | 11815 | 197 |
1706213 | 1706213 | 2021-09-11 | Talladega | Alabama | 1121 | 11784 | 197 |
1702965 | 1702965 | 2021-09-10 | Talladega | Alabama | 1121 | 11647 | 196 |
1699715 | 1699715 | 2021-09-09 | Talladega | Alabama | 1121 | 11572 | 196 |
1696466 | 1696466 | 2021-09-08 | Talladega | Alabama | 1121 | 11458 | 194 |
1693218 | 1693218 | 2021-09-07 | Talladega | Alabama | 1121 | 11367 | 194 |
1689969 | 1689969 | 2021-09-06 | Talladega | Alabama | 1121 | 11309 | 194 |
1686719 | 1686719 | 2021-09-05 | Talladega | Alabama | 1121 | 11251 | 194 |
1683469 | 1683469 | 2021-09-04 | Talladega | Alabama | 1121 | 11180 | 194 |
1680218 | 1680218 | 2021-09-03 | Talladega | Alabama | 1121 | 11078 | 194 |
1676970 | 1676970 | 2021-09-02 | Talladega | Alabama | 1121 | 10945 | 194 |
1673723 | 1673723 | 2021-09-01 | Talladega | Alabama | 1121 | 10817 | 194 |
1670475 | 1670475 | 2021-08-31 | Talladega | Alabama | 1121 | 10713 | 194 |
1667228 | 1667228 | 2021-08-30 | Talladega | Alabama | 1121 | 10566 | 194 |
1663980 | 1663980 | 2021-08-29 | Talladega | Alabama | 1121 | 10508 | 194 |
1660732 | 1660732 | 2021-08-28 | Talladega | Alabama | 1121 | 10445 | 194 |
1657484 | 1657484 | 2021-08-27 | Talladega | Alabama | 1121 | 10343 | 194 |
1654236 | 1654236 | 2021-08-26 | Talladega | Alabama | 1121 | 10252 | 194 |
1650990 | 1650990 | 2021-08-25 | Talladega | Alabama | 1121 | 10077 | 193 |
1647741 | 1647741 | 2021-08-24 | Talladega | Alabama | 1121 | 10077 | 193 |
1644492 | 1644492 | 2021-08-23 | Talladega | Alabama | 1121 | 10077 | 193 |
1641242 | 1641242 | 2021-08-22 | Talladega | Alabama | 1121 | 10029 | 193 |
1637992 | 1637992 | 2021-08-21 | Talladega | Alabama | 1121 | 9956 | 193 |
1634742 | 1634742 | 2021-08-20 | Talladega | Alabama | 1121 | 9875 | 191 |
1631494 | 1631494 | 2021-08-19 | Talladega | Alabama | 1121 | 9793 | 191 |
1628247 | 1628247 | 2021-08-18 | Talladega | Alabama | 1121 | 9717 | 191 |
1625000 | 1625000 | 2021-08-17 | Talladega | Alabama | 1121 | 9617 | 191 |
1621753 | 1621753 | 2021-08-16 | Talladega | Alabama | 1121 | 9556 | 191 |
1618505 | 1618505 | 2021-08-15 | Talladega | Alabama | 1121 | 9530 | 191 |
1615257 | 1615257 | 2021-08-14 | Talladega | Alabama | 1121 | 9420 | 190 |
1612008 | 1612008 | 2021-08-13 | Talladega | Alabama | 1121 | 9420 | 190 |
1608761 | 1608761 | 2021-08-12 | Talladega | Alabama | 1121 | 9368 | 190 |
1605512 | 1605512 | 2021-08-11 | Talladega | Alabama | 1121 | 9295 | 190 |
1602262 | 1602262 | 2021-08-10 | Talladega | Alabama | 1121 | 9245 | 189 |
1599014 | 1599014 | 2021-08-09 | Talladega | Alabama | 1121 | 9200 | 188 |
1595765 | 1595765 | 2021-08-08 | Talladega | Alabama | 1121 | 9141 | 188 |
1592516 | 1592516 | 2021-08-07 | Talladega | Alabama | 1121 | 9141 | 188 |
1589267 | 1589267 | 2021-08-06 | Talladega | Alabama | 1121 | 9105 | 188 |
1586018 | 1586018 | 2021-08-05 | Talladega | Alabama | 1121 | 9074 | 188 |
1582768 | 1582768 | 2021-08-04 | Talladega | Alabama | 1121 | 9032 | 188 |
1579518 | 1579518 | 2021-08-03 | Talladega | Alabama | 1121 | 9005 | 188 |
1576270 | 1576270 | 2021-08-02 | Talladega | Alabama | 1121 | 8972 | 188 |
1573022 | 1573022 | 2021-08-01 | Talladega | Alabama | 1121 | 8949 | 188 |
1569774 | 1569774 | 2021-07-31 | Talladega | Alabama | 1121 | 8935 | 188 |
1566526 | 1566526 | 2021-07-30 | Talladega | Alabama | 1121 | 8869 | 188 |
1563278 | 1563278 | 2021-07-29 | Talladega | Alabama | 1121 | 8869 | 188 |
1560030 | 1560030 | 2021-07-28 | Talladega | Alabama | 1121 | 8836 | 188 |
1556783 | 1556783 | 2021-07-27 | Talladega | Alabama | 1121 | 8797 | 187 |
1553536 | 1553536 | 2021-07-26 | Talladega | Alabama | 1121 | 8746 | 187 |
1550289 | 1550289 | 2021-07-25 | Talladega | Alabama | 1121 | 8739 | 187 |
1547042 | 1547042 | 2021-07-24 | Talladega | Alabama | 1121 | 8721 | 187 |
1543795 | 1543795 | 2021-07-23 | Talladega | Alabama | 1121 | 8706 | 187 |
1540547 | 1540547 | 2021-07-22 | Talladega | Alabama | 1121 | 8705 | 187 |
1537300 | 1537300 | 2021-07-21 | Talladega | Alabama | 1121 | 8640 | 187 |
1534052 | 1534052 | 2021-07-20 | Talladega | Alabama | 1121 | 8624 | 187 |
1530805 | 1530805 | 2021-07-19 | Talladega | Alabama | 1121 | 8599 | 186 |
1527558 | 1527558 | 2021-07-18 | Talladega | Alabama | 1121 | 8591 | 186 |
1524311 | 1524311 | 2021-07-17 | Talladega | Alabama | 1121 | 8586 | 186 |
1521063 | 1521063 | 2021-07-16 | Talladega | Alabama | 1121 | 8570 | 186 |
1517815 | 1517815 | 2021-07-15 | Talladega | Alabama | 1121 | 8566 | 186 |
1514568 | 1514568 | 2021-07-14 | Talladega | Alabama | 1121 | 8559 | 185 |
1511322 | 1511322 | 2021-07-13 | Talladega | Alabama | 1121 | 8544 | 185 |
1508075 | 1508075 | 2021-07-12 | Talladega | Alabama | 1121 | 8544 | 185 |
1504829 | 1504829 | 2021-07-11 | Talladega | Alabama | 1121 | 8541 | 185 |
1501583 | 1501583 | 2021-07-10 | Talladega | Alabama | 1121 | 8541 | 185 |
1498337 | 1498337 | 2021-07-09 | Talladega | Alabama | 1121 | 8536 | 185 |
1495090 | 1495090 | 2021-07-08 | Talladega | Alabama | 1121 | 8498 | 185 |
1491843 | 1491843 | 2021-07-07 | Talladega | Alabama | 1121 | 8498 | 185 |
1488596 | 1488596 | 2021-07-06 | Talladega | Alabama | 1121 | 8485 | 185 |
1485349 | 1485349 | 2021-07-05 | Talladega | Alabama | 1121 | 8485 | 185 |
1482103 | 1482103 | 2021-07-04 | Talladega | Alabama | 1121 | 8485 | 185 |
1478856 | 1478856 | 2021-07-03 | Talladega | Alabama | 1121 | 8485 | 185 |
1475610 | 1475610 | 2021-07-02 | Talladega | Alabama | 1121 | 8485 | 185 |
1472364 | 1472364 | 2021-07-01 | Talladega | Alabama | 1121 | 8482 | 185 |
1469119 | 1469119 | 2021-06-30 | Talladega | Alabama | 1121 | 8482 | 185 |
1465874 | 1465874 | 2021-06-29 | Talladega | Alabama | 1121 | 8466 | 184 |
1462629 | 1462629 | 2021-06-28 | Talladega | Alabama | 1121 | 8466 | 184 |
1459384 | 1459384 | 2021-06-27 | Talladega | Alabama | 1121 | 8474 | 184 |
1456139 | 1456139 | 2021-06-26 | Talladega | Alabama | 1121 | 8474 | 184 |
1452894 | 1452894 | 2021-06-25 | Talladega | Alabama | 1121 | 8474 | 184 |
1449648 | 1449648 | 2021-06-24 | Talladega | Alabama | 1121 | 8467 | 184 |
1446403 | 1446403 | 2021-06-23 | Talladega | Alabama | 1121 | 8467 | 184 |
1443158 | 1443158 | 2021-06-22 | Talladega | Alabama | 1121 | 8462 | 184 |
1439913 | 1439913 | 2021-06-21 | Talladega | Alabama | 1121 | 8462 | 184 |
1436666 | 1436666 | 2021-06-20 | Talladega | Alabama | 1121 | 8460 | 184 |
1433419 | 1433419 | 2021-06-19 | Talladega | Alabama | 1121 | 8460 | 184 |
1430173 | 1430173 | 2021-06-18 | Talladega | Alabama | 1121 | 8460 | 184 |
1426928 | 1426928 | 2021-06-17 | Talladega | Alabama | 1121 | 8458 | 184 |
1423682 | 1423682 | 2021-06-16 | Talladega | Alabama | 1121 | 8458 | 184 |
1420435 | 1420435 | 2021-06-15 | Talladega | Alabama | 1121 | 8455 | 184 |
1417190 | 1417190 | 2021-06-14 | Talladega | Alabama | 1121 | 8455 | 184 |
1413944 | 1413944 | 2021-06-13 | Talladega | Alabama | 1121 | 8441 | 184 |
1410699 | 1410699 | 2021-06-12 | Talladega | Alabama | 1121 | 8441 | 184 |
1407454 | 1407454 | 2021-06-11 | Talladega | Alabama | 1121 | 8441 | 184 |
1404208 | 1404208 | 2021-06-10 | Talladega | Alabama | 1121 | 8439 | 183 |
1400963 | 1400963 | 2021-06-09 | Talladega | Alabama | 1121 | 8436 | 182 |
1397718 | 1397718 | 2021-06-08 | Talladega | Alabama | 1121 | 8435 | 182 |
1394471 | 1394471 | 2021-06-07 | Talladega | Alabama | 1121 | 8421 | 182 |
1391226 | 1391226 | 2021-06-06 | Talladega | Alabama | 1121 | 8411 | 181 |
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);