ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 1123 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1806929 | 1806929 | 2021-10-12 | Tallapoosa | Alabama | 1123 | 6990 | 194 |
1803678 | 1803678 | 2021-10-11 | Tallapoosa | Alabama | 1123 | 6970 | 194 |
1800429 | 1800429 | 2021-10-10 | Tallapoosa | Alabama | 1123 | 6962 | 194 |
1797180 | 1797180 | 2021-10-09 | Tallapoosa | Alabama | 1123 | 6952 | 194 |
1793931 | 1793931 | 2021-10-08 | Tallapoosa | Alabama | 1123 | 6930 | 194 |
1790682 | 1790682 | 2021-10-07 | Tallapoosa | Alabama | 1123 | 6916 | 192 |
1787434 | 1787434 | 2021-10-06 | Tallapoosa | Alabama | 1123 | 6885 | 190 |
1784185 | 1784185 | 2021-10-05 | Tallapoosa | Alabama | 1123 | 6862 | 189 |
1780936 | 1780936 | 2021-10-04 | Tallapoosa | Alabama | 1123 | 6838 | 189 |
1777686 | 1777686 | 2021-10-03 | Tallapoosa | Alabama | 1123 | 6828 | 189 |
1774436 | 1774436 | 2021-10-02 | Tallapoosa | Alabama | 1123 | 6813 | 189 |
1771186 | 1771186 | 2021-10-01 | Tallapoosa | Alabama | 1123 | 6794 | 188 |
1767937 | 1767937 | 2021-09-30 | Tallapoosa | Alabama | 1123 | 6778 | 187 |
1764688 | 1764688 | 2021-09-29 | Tallapoosa | Alabama | 1123 | 6753 | 187 |
1761439 | 1761439 | 2021-09-28 | Tallapoosa | Alabama | 1123 | 6726 | 183 |
1758191 | 1758191 | 2021-09-27 | Tallapoosa | Alabama | 1123 | 6688 | 181 |
1754943 | 1754943 | 2021-09-26 | Tallapoosa | Alabama | 1123 | 6673 | 181 |
1751695 | 1751695 | 2021-09-25 | Tallapoosa | Alabama | 1123 | 6661 | 181 |
1748446 | 1748446 | 2021-09-24 | Tallapoosa | Alabama | 1123 | 6616 | 177 |
1745196 | 1745196 | 2021-09-23 | Tallapoosa | Alabama | 1123 | 6557 | 177 |
1741947 | 1741947 | 2021-09-22 | Tallapoosa | Alabama | 1123 | 6501 | 172 |
1738698 | 1738698 | 2021-09-21 | Tallapoosa | Alabama | 1123 | 6482 | 171 |
1735449 | 1735449 | 2021-09-20 | Tallapoosa | Alabama | 1123 | 6435 | 168 |
1732199 | 1732199 | 2021-09-19 | Tallapoosa | Alabama | 1123 | 6420 | 168 |
1728949 | 1728949 | 2021-09-18 | Tallapoosa | Alabama | 1123 | 6394 | 168 |
1725699 | 1725699 | 2021-09-17 | Tallapoosa | Alabama | 1123 | 6353 | 166 |
1722450 | 1722450 | 2021-09-16 | Tallapoosa | Alabama | 1123 | 6315 | 165 |
1719202 | 1719202 | 2021-09-15 | Tallapoosa | Alabama | 1123 | 6255 | 165 |
1715954 | 1715954 | 2021-09-14 | Tallapoosa | Alabama | 1123 | 6188 | 163 |
1712708 | 1712708 | 2021-09-13 | Tallapoosa | Alabama | 1123 | 6149 | 163 |
1709461 | 1709461 | 2021-09-12 | Tallapoosa | Alabama | 1123 | 6129 | 163 |
1706214 | 1706214 | 2021-09-11 | Tallapoosa | Alabama | 1123 | 6116 | 163 |
1702966 | 1702966 | 2021-09-10 | Tallapoosa | Alabama | 1123 | 6035 | 163 |
1699716 | 1699716 | 2021-09-09 | Tallapoosa | Alabama | 1123 | 5976 | 163 |
1696467 | 1696467 | 2021-09-08 | Tallapoosa | Alabama | 1123 | 5923 | 163 |
1693219 | 1693219 | 2021-09-07 | Tallapoosa | Alabama | 1123 | 5861 | 163 |
1689970 | 1689970 | 2021-09-06 | Tallapoosa | Alabama | 1123 | 5851 | 163 |
1686720 | 1686720 | 2021-09-05 | Tallapoosa | Alabama | 1123 | 5836 | 163 |
1683470 | 1683470 | 2021-09-04 | Tallapoosa | Alabama | 1123 | 5799 | 163 |
1680219 | 1680219 | 2021-09-03 | Tallapoosa | Alabama | 1123 | 5740 | 163 |
1676971 | 1676971 | 2021-09-02 | Tallapoosa | Alabama | 1123 | 5675 | 163 |
1673724 | 1673724 | 2021-09-01 | Tallapoosa | Alabama | 1123 | 5627 | 163 |
1670476 | 1670476 | 2021-08-31 | Tallapoosa | Alabama | 1123 | 5577 | 163 |
1667229 | 1667229 | 2021-08-30 | Tallapoosa | Alabama | 1123 | 5524 | 161 |
1663981 | 1663981 | 2021-08-29 | Tallapoosa | Alabama | 1123 | 5489 | 161 |
1660733 | 1660733 | 2021-08-28 | Tallapoosa | Alabama | 1123 | 5468 | 161 |
1657485 | 1657485 | 2021-08-27 | Tallapoosa | Alabama | 1123 | 5420 | 160 |
1654237 | 1654237 | 2021-08-26 | Tallapoosa | Alabama | 1123 | 5361 | 159 |
1650991 | 1650991 | 2021-08-25 | Tallapoosa | Alabama | 1123 | 5257 | 158 |
1647742 | 1647742 | 2021-08-24 | Tallapoosa | Alabama | 1123 | 5257 | 158 |
1644493 | 1644493 | 2021-08-23 | Tallapoosa | Alabama | 1123 | 5257 | 158 |
1641243 | 1641243 | 2021-08-22 | Tallapoosa | Alabama | 1123 | 5247 | 158 |
1637993 | 1637993 | 2021-08-21 | Tallapoosa | Alabama | 1123 | 5223 | 158 |
1634743 | 1634743 | 2021-08-20 | Tallapoosa | Alabama | 1123 | 5147 | 158 |
1631495 | 1631495 | 2021-08-19 | Tallapoosa | Alabama | 1123 | 5103 | 158 |
1628248 | 1628248 | 2021-08-18 | Tallapoosa | Alabama | 1123 | 5060 | 157 |
1625001 | 1625001 | 2021-08-17 | Tallapoosa | Alabama | 1123 | 5036 | 157 |
1621754 | 1621754 | 2021-08-16 | Tallapoosa | Alabama | 1123 | 4977 | 157 |
1618506 | 1618506 | 2021-08-15 | Tallapoosa | Alabama | 1123 | 4956 | 157 |
1615258 | 1615258 | 2021-08-14 | Tallapoosa | Alabama | 1123 | 4879 | 157 |
1612009 | 1612009 | 2021-08-13 | Tallapoosa | Alabama | 1123 | 4879 | 157 |
1608762 | 1608762 | 2021-08-12 | Tallapoosa | Alabama | 1123 | 4848 | 157 |
1605513 | 1605513 | 2021-08-11 | Tallapoosa | Alabama | 1123 | 4826 | 157 |
1602263 | 1602263 | 2021-08-10 | Tallapoosa | Alabama | 1123 | 4770 | 157 |
1599015 | 1599015 | 2021-08-09 | Tallapoosa | Alabama | 1123 | 4734 | 157 |
1595766 | 1595766 | 2021-08-08 | Tallapoosa | Alabama | 1123 | 4710 | 157 |
1592517 | 1592517 | 2021-08-07 | Tallapoosa | Alabama | 1123 | 4710 | 157 |
1589268 | 1589268 | 2021-08-06 | Tallapoosa | Alabama | 1123 | 4659 | 156 |
1586019 | 1586019 | 2021-08-05 | Tallapoosa | Alabama | 1123 | 4633 | 156 |
1582769 | 1582769 | 2021-08-04 | Tallapoosa | Alabama | 1123 | 4591 | 156 |
1579519 | 1579519 | 2021-08-03 | Tallapoosa | Alabama | 1123 | 4571 | 156 |
1576271 | 1576271 | 2021-08-02 | Tallapoosa | Alabama | 1123 | 4525 | 156 |
1573023 | 1573023 | 2021-08-01 | Tallapoosa | Alabama | 1123 | 4519 | 156 |
1569775 | 1569775 | 2021-07-31 | Tallapoosa | Alabama | 1123 | 4511 | 156 |
1566527 | 1566527 | 2021-07-30 | Tallapoosa | Alabama | 1123 | 4462 | 156 |
1563279 | 1563279 | 2021-07-29 | Tallapoosa | Alabama | 1123 | 4462 | 156 |
1560031 | 1560031 | 2021-07-28 | Tallapoosa | Alabama | 1123 | 4440 | 156 |
1556784 | 1556784 | 2021-07-27 | Tallapoosa | Alabama | 1123 | 4420 | 157 |
1553537 | 1553537 | 2021-07-26 | Tallapoosa | Alabama | 1123 | 4383 | 157 |
1550290 | 1550290 | 2021-07-25 | Tallapoosa | Alabama | 1123 | 4379 | 157 |
1547043 | 1547043 | 2021-07-24 | Tallapoosa | Alabama | 1123 | 4372 | 157 |
1543796 | 1543796 | 2021-07-23 | Tallapoosa | Alabama | 1123 | 4362 | 156 |
1540548 | 1540548 | 2021-07-22 | Tallapoosa | Alabama | 1123 | 4343 | 156 |
1537301 | 1537301 | 2021-07-21 | Tallapoosa | Alabama | 1123 | 4326 | 156 |
1534053 | 1534053 | 2021-07-20 | Tallapoosa | Alabama | 1123 | 4315 | 156 |
1530806 | 1530806 | 2021-07-19 | Tallapoosa | Alabama | 1123 | 4291 | 156 |
1527559 | 1527559 | 2021-07-18 | Tallapoosa | Alabama | 1123 | 4291 | 156 |
1524312 | 1524312 | 2021-07-17 | Tallapoosa | Alabama | 1123 | 4290 | 156 |
1521064 | 1521064 | 2021-07-16 | Tallapoosa | Alabama | 1123 | 4278 | 156 |
1517816 | 1517816 | 2021-07-15 | Tallapoosa | Alabama | 1123 | 4264 | 156 |
1514569 | 1514569 | 2021-07-14 | Tallapoosa | Alabama | 1123 | 4245 | 156 |
1511323 | 1511323 | 2021-07-13 | Tallapoosa | Alabama | 1123 | 4207 | 156 |
1508076 | 1508076 | 2021-07-12 | Tallapoosa | Alabama | 1123 | 4207 | 156 |
1504830 | 1504830 | 2021-07-11 | Tallapoosa | Alabama | 1123 | 4201 | 156 |
1501584 | 1501584 | 2021-07-10 | Tallapoosa | Alabama | 1123 | 4201 | 156 |
1498338 | 1498338 | 2021-07-09 | Tallapoosa | Alabama | 1123 | 4196 | 156 |
1495091 | 1495091 | 2021-07-08 | Tallapoosa | Alabama | 1123 | 4173 | 156 |
1491844 | 1491844 | 2021-07-07 | Tallapoosa | Alabama | 1123 | 4173 | 156 |
1488597 | 1488597 | 2021-07-06 | Tallapoosa | Alabama | 1123 | 4154 | 156 |
1485350 | 1485350 | 2021-07-05 | Tallapoosa | Alabama | 1123 | 4154 | 156 |
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);