ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 1073 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712683 | 1712683 | 2021-09-13 | Jefferson | Alabama | 1073 | 107467 | 1701 |
1709436 | 1709436 | 2021-09-12 | Jefferson | Alabama | 1073 | 107108 | 1701 |
1706189 | 1706189 | 2021-09-11 | Jefferson | Alabama | 1073 | 106845 | 1701 |
1702941 | 1702941 | 2021-09-10 | Jefferson | Alabama | 1073 | 106362 | 1687 |
1699691 | 1699691 | 2021-09-09 | Jefferson | Alabama | 1073 | 105851 | 1687 |
1696442 | 1696442 | 2021-09-08 | Jefferson | Alabama | 1073 | 105355 | 1671 |
1693194 | 1693194 | 2021-09-07 | Jefferson | Alabama | 1073 | 104955 | 1670 |
1689945 | 1689945 | 2021-09-06 | Jefferson | Alabama | 1073 | 104567 | 1670 |
1686695 | 1686695 | 2021-09-05 | Jefferson | Alabama | 1073 | 104173 | 1670 |
1683445 | 1683445 | 2021-09-04 | Jefferson | Alabama | 1073 | 103817 | 1670 |
1680194 | 1680194 | 2021-09-03 | Jefferson | Alabama | 1073 | 103264 | 1667 |
1676946 | 1676946 | 2021-09-02 | Jefferson | Alabama | 1073 | 102537 | 1660 |
1673699 | 1673699 | 2021-09-01 | Jefferson | Alabama | 1073 | 101613 | 1659 |
1670451 | 1670451 | 2021-08-31 | Jefferson | Alabama | 1073 | 101002 | 1653 |
1667204 | 1667204 | 2021-08-30 | Jefferson | Alabama | 1073 | 100345 | 1647 |
1663956 | 1663956 | 2021-08-29 | Jefferson | Alabama | 1073 | 99807 | 1647 |
1660708 | 1660708 | 2021-08-28 | Jefferson | Alabama | 1073 | 99379 | 1647 |
1657460 | 1657460 | 2021-08-27 | Jefferson | Alabama | 1073 | 98372 | 1624 |
1654212 | 1654212 | 2021-08-26 | Jefferson | Alabama | 1073 | 97700 | 1625 |
1650966 | 1650966 | 2021-08-25 | Jefferson | Alabama | 1073 | 96037 | 1623 |
1647717 | 1647717 | 2021-08-24 | Jefferson | Alabama | 1073 | 96037 | 1623 |
1644468 | 1644468 | 2021-08-23 | Jefferson | Alabama | 1073 | 96037 | 1623 |
1641218 | 1641218 | 2021-08-22 | Jefferson | Alabama | 1073 | 95624 | 1623 |
1637968 | 1637968 | 2021-08-21 | Jefferson | Alabama | 1073 | 95077 | 1623 |
1634718 | 1634718 | 2021-08-20 | Jefferson | Alabama | 1073 | 94190 | 1623 |
1631470 | 1631470 | 2021-08-19 | Jefferson | Alabama | 1073 | 93764 | 1616 |
1628223 | 1628223 | 2021-08-18 | Jefferson | Alabama | 1073 | 93288 | 1616 |
1624976 | 1624976 | 2021-08-17 | Jefferson | Alabama | 1073 | 92736 | 1616 |
1621729 | 1621729 | 2021-08-16 | Jefferson | Alabama | 1073 | 92177 | 1615 |
1618481 | 1618481 | 2021-08-15 | Jefferson | Alabama | 1073 | 91744 | 1615 |
1615233 | 1615233 | 2021-08-14 | Jefferson | Alabama | 1073 | 90559 | 1609 |
1611984 | 1611984 | 2021-08-13 | Jefferson | Alabama | 1073 | 90559 | 1609 |
1608737 | 1608737 | 2021-08-12 | Jefferson | Alabama | 1073 | 89977 | 1606 |
1605488 | 1605488 | 2021-08-11 | Jefferson | Alabama | 1073 | 89507 | 1606 |
1602238 | 1602238 | 2021-08-10 | Jefferson | Alabama | 1073 | 89043 | 1606 |
1598990 | 1598990 | 2021-08-09 | Jefferson | Alabama | 1073 | 88521 | 1598 |
1595741 | 1595741 | 2021-08-08 | Jefferson | Alabama | 1073 | 87843 | 1598 |
1592492 | 1592492 | 2021-08-07 | Jefferson | Alabama | 1073 | 87843 | 1598 |
1589243 | 1589243 | 2021-08-06 | Jefferson | Alabama | 1073 | 87414 | 1591 |
1585994 | 1585994 | 2021-08-05 | Jefferson | Alabama | 1073 | 87039 | 1591 |
1582744 | 1582744 | 2021-08-04 | Jefferson | Alabama | 1073 | 86525 | 1591 |
1579494 | 1579494 | 2021-08-03 | Jefferson | Alabama | 1073 | 86109 | 1591 |
1576246 | 1576246 | 2021-08-02 | Jefferson | Alabama | 1073 | 85603 | 1591 |
1572998 | 1572998 | 2021-08-01 | Jefferson | Alabama | 1073 | 85385 | 1591 |
1569750 | 1569750 | 2021-07-31 | Jefferson | Alabama | 1073 | 85143 | 1591 |
1566502 | 1566502 | 2021-07-30 | Jefferson | Alabama | 1073 | 84522 | 1589 |
1563254 | 1563254 | 2021-07-29 | Jefferson | Alabama | 1073 | 84522 | 1589 |
1560006 | 1560006 | 2021-07-28 | Jefferson | Alabama | 1073 | 84198 | 1589 |
1556759 | 1556759 | 2021-07-27 | Jefferson | Alabama | 1073 | 83957 | 1589 |
1553512 | 1553512 | 2021-07-26 | Jefferson | Alabama | 1073 | 83649 | 1584 |
1550265 | 1550265 | 2021-07-25 | Jefferson | Alabama | 1073 | 83482 | 1584 |
1547018 | 1547018 | 2021-07-24 | Jefferson | Alabama | 1073 | 83188 | 1584 |
1543771 | 1543771 | 2021-07-23 | Jefferson | Alabama | 1073 | 83039 | 1584 |
1540523 | 1540523 | 2021-07-22 | Jefferson | Alabama | 1073 | 82806 | 1584 |
1537276 | 1537276 | 2021-07-21 | Jefferson | Alabama | 1073 | 82655 | 1584 |
1534028 | 1534028 | 2021-07-20 | Jefferson | Alabama | 1073 | 82487 | 1584 |
1530781 | 1530781 | 2021-07-19 | Jefferson | Alabama | 1073 | 82320 | 1581 |
1527534 | 1527534 | 2021-07-18 | Jefferson | Alabama | 1073 | 82231 | 1581 |
1524287 | 1524287 | 2021-07-17 | Jefferson | Alabama | 1073 | 82150 | 1581 |
1521039 | 1521039 | 2021-07-16 | Jefferson | Alabama | 1073 | 82048 | 1581 |
1517791 | 1517791 | 2021-07-15 | Jefferson | Alabama | 1073 | 81957 | 1581 |
1514544 | 1514544 | 2021-07-14 | Jefferson | Alabama | 1073 | 81862 | 1581 |
1511298 | 1511298 | 2021-07-13 | Jefferson | Alabama | 1073 | 81730 | 1576 |
1508051 | 1508051 | 2021-07-12 | Jefferson | Alabama | 1073 | 81730 | 1576 |
1504805 | 1504805 | 2021-07-11 | Jefferson | Alabama | 1073 | 81656 | 1576 |
1501559 | 1501559 | 2021-07-10 | Jefferson | Alabama | 1073 | 81656 | 1576 |
1498313 | 1498313 | 2021-07-09 | Jefferson | Alabama | 1073 | 81621 | 1576 |
1495066 | 1495066 | 2021-07-08 | Jefferson | Alabama | 1073 | 81507 | 1576 |
1491819 | 1491819 | 2021-07-07 | Jefferson | Alabama | 1073 | 81507 | 1576 |
1488572 | 1488572 | 2021-07-06 | Jefferson | Alabama | 1073 | 81328 | 1569 |
1485325 | 1485325 | 2021-07-05 | Jefferson | Alabama | 1073 | 81328 | 1569 |
1482079 | 1482079 | 2021-07-04 | Jefferson | Alabama | 1073 | 81328 | 1569 |
1478832 | 1478832 | 2021-07-03 | Jefferson | Alabama | 1073 | 81328 | 1569 |
1475586 | 1475586 | 2021-07-02 | Jefferson | Alabama | 1073 | 81328 | 1569 |
1472340 | 1472340 | 2021-07-01 | Jefferson | Alabama | 1073 | 81290 | 1569 |
1469095 | 1469095 | 2021-06-30 | Jefferson | Alabama | 1073 | 81290 | 1569 |
1465850 | 1465850 | 2021-06-29 | Jefferson | Alabama | 1073 | 81216 | 1571 |
1462605 | 1462605 | 2021-06-28 | Jefferson | Alabama | 1073 | 81216 | 1571 |
1459360 | 1459360 | 2021-06-27 | Jefferson | Alabama | 1073 | 81151 | 1571 |
1456115 | 1456115 | 2021-06-26 | Jefferson | Alabama | 1073 | 81151 | 1571 |
1452870 | 1452870 | 2021-06-25 | Jefferson | Alabama | 1073 | 81151 | 1571 |
1449624 | 1449624 | 2021-06-24 | Jefferson | Alabama | 1073 | 81085 | 1571 |
1446379 | 1446379 | 2021-06-23 | Jefferson | Alabama | 1073 | 81085 | 1571 |
1443134 | 1443134 | 2021-06-22 | Jefferson | Alabama | 1073 | 81046 | 1571 |
1439889 | 1439889 | 2021-06-21 | Jefferson | Alabama | 1073 | 81046 | 1571 |
1436642 | 1436642 | 2021-06-20 | Jefferson | Alabama | 1073 | 81003 | 1566 |
1433395 | 1433395 | 2021-06-19 | Jefferson | Alabama | 1073 | 81003 | 1566 |
1430149 | 1430149 | 2021-06-18 | Jefferson | Alabama | 1073 | 81003 | 1566 |
1426904 | 1426904 | 2021-06-17 | Jefferson | Alabama | 1073 | 80953 | 1565 |
1423658 | 1423658 | 2021-06-16 | Jefferson | Alabama | 1073 | 80953 | 1565 |
1420411 | 1420411 | 2021-06-15 | Jefferson | Alabama | 1073 | 80937 | 1565 |
1417166 | 1417166 | 2021-06-14 | Jefferson | Alabama | 1073 | 80914 | 1565 |
1413920 | 1413920 | 2021-06-13 | Jefferson | Alabama | 1073 | 80802 | 1563 |
1410675 | 1410675 | 2021-06-12 | Jefferson | Alabama | 1073 | 80802 | 1563 |
1407430 | 1407430 | 2021-06-11 | Jefferson | Alabama | 1073 | 80802 | 1563 |
1404184 | 1404184 | 2021-06-10 | Jefferson | Alabama | 1073 | 80745 | 1560 |
1400939 | 1400939 | 2021-06-09 | Jefferson | Alabama | 1073 | 80715 | 1560 |
1397694 | 1397694 | 2021-06-08 | Jefferson | Alabama | 1073 | 80705 | 1549 |
1394447 | 1394447 | 2021-06-07 | Jefferson | Alabama | 1073 | 80681 | 1549 |
1391202 | 1391202 | 2021-06-06 | Jefferson | Alabama | 1073 | 80586 | 1549 |
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);