ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 1117 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1839414 | 1839414 | 2021-10-22 | Shelby | Alabama | 1117 | 37575 | 349 |
1836165 | 1836165 | 2021-10-21 | Shelby | Alabama | 1117 | 37533 | 348 |
1832916 | 1832916 | 2021-10-20 | Shelby | Alabama | 1117 | 37488 | 348 |
1829667 | 1829667 | 2021-10-19 | Shelby | Alabama | 1117 | 37458 | 346 |
1826418 | 1826418 | 2021-10-18 | Shelby | Alabama | 1117 | 37315 | 341 |
1823169 | 1823169 | 2021-10-17 | Shelby | Alabama | 1117 | 37304 | 341 |
1819920 | 1819920 | 2021-10-16 | Shelby | Alabama | 1117 | 37279 | 341 |
1816671 | 1816671 | 2021-10-15 | Shelby | Alabama | 1117 | 37240 | 339 |
1813423 | 1813423 | 2021-10-14 | Shelby | Alabama | 1117 | 37203 | 339 |
1810174 | 1810174 | 2021-10-13 | Shelby | Alabama | 1117 | 37167 | 332 |
1806925 | 1806925 | 2021-10-12 | Shelby | Alabama | 1117 | 37130 | 330 |
1803674 | 1803674 | 2021-10-11 | Shelby | Alabama | 1117 | 37076 | 330 |
1800425 | 1800425 | 2021-10-10 | Shelby | Alabama | 1117 | 37060 | 330 |
1797176 | 1797176 | 2021-10-09 | Shelby | Alabama | 1117 | 37034 | 330 |
1793927 | 1793927 | 2021-10-08 | Shelby | Alabama | 1117 | 36998 | 328 |
1790678 | 1790678 | 2021-10-07 | Shelby | Alabama | 1117 | 36967 | 328 |
1787430 | 1787430 | 2021-10-06 | Shelby | Alabama | 1117 | 36924 | 327 |
1784181 | 1784181 | 2021-10-05 | Shelby | Alabama | 1117 | 36877 | 322 |
1780932 | 1780932 | 2021-10-04 | Shelby | Alabama | 1117 | 36804 | 322 |
1777682 | 1777682 | 2021-10-03 | Shelby | Alabama | 1117 | 36773 | 322 |
1774432 | 1774432 | 2021-10-02 | Shelby | Alabama | 1117 | 36725 | 322 |
1771182 | 1771182 | 2021-10-01 | Shelby | Alabama | 1117 | 36673 | 321 |
1767933 | 1767933 | 2021-09-30 | Shelby | Alabama | 1117 | 36609 | 321 |
1764684 | 1764684 | 2021-09-29 | Shelby | Alabama | 1117 | 36546 | 319 |
1761435 | 1761435 | 2021-09-28 | Shelby | Alabama | 1117 | 36444 | 317 |
1758187 | 1758187 | 2021-09-27 | Shelby | Alabama | 1117 | 36350 | 315 |
1754939 | 1754939 | 2021-09-26 | Shelby | Alabama | 1117 | 36274 | 315 |
1751691 | 1751691 | 2021-09-25 | Shelby | Alabama | 1117 | 36186 | 315 |
1748442 | 1748442 | 2021-09-24 | Shelby | Alabama | 1117 | 36062 | 314 |
1745192 | 1745192 | 2021-09-23 | Shelby | Alabama | 1117 | 35933 | 311 |
1741943 | 1741943 | 2021-09-22 | Shelby | Alabama | 1117 | 35796 | 302 |
1738694 | 1738694 | 2021-09-21 | Shelby | Alabama | 1117 | 35560 | 297 |
1735445 | 1735445 | 2021-09-20 | Shelby | Alabama | 1117 | 35392 | 291 |
1732195 | 1732195 | 2021-09-19 | Shelby | Alabama | 1117 | 35304 | 291 |
1728945 | 1728945 | 2021-09-18 | Shelby | Alabama | 1117 | 35193 | 291 |
1725695 | 1725695 | 2021-09-17 | Shelby | Alabama | 1117 | 35053 | 289 |
1722446 | 1722446 | 2021-09-16 | Shelby | Alabama | 1117 | 34948 | 283 |
1719198 | 1719198 | 2021-09-15 | Shelby | Alabama | 1117 | 34758 | 281 |
1715950 | 1715950 | 2021-09-14 | Shelby | Alabama | 1117 | 34596 | 280 |
1712704 | 1712704 | 2021-09-13 | Shelby | Alabama | 1117 | 34429 | 280 |
1709457 | 1709457 | 2021-09-12 | Shelby | Alabama | 1117 | 34306 | 280 |
1706210 | 1706210 | 2021-09-11 | Shelby | Alabama | 1117 | 34222 | 280 |
1702962 | 1702962 | 2021-09-10 | Shelby | Alabama | 1117 | 34013 | 280 |
1699712 | 1699712 | 2021-09-09 | Shelby | Alabama | 1117 | 33849 | 279 |
1696463 | 1696463 | 2021-09-08 | Shelby | Alabama | 1117 | 33642 | 278 |
1693215 | 1693215 | 2021-09-07 | Shelby | Alabama | 1117 | 33473 | 276 |
1689966 | 1689966 | 2021-09-06 | Shelby | Alabama | 1117 | 33355 | 276 |
1686716 | 1686716 | 2021-09-05 | Shelby | Alabama | 1117 | 33200 | 276 |
1683466 | 1683466 | 2021-09-04 | Shelby | Alabama | 1117 | 33044 | 276 |
1680215 | 1680215 | 2021-09-03 | Shelby | Alabama | 1117 | 32818 | 276 |
1676967 | 1676967 | 2021-09-02 | Shelby | Alabama | 1117 | 32623 | 276 |
1673720 | 1673720 | 2021-09-01 | Shelby | Alabama | 1117 | 32350 | 275 |
1670472 | 1670472 | 2021-08-31 | Shelby | Alabama | 1117 | 32121 | 276 |
1667225 | 1667225 | 2021-08-30 | Shelby | Alabama | 1117 | 31907 | 276 |
1663977 | 1663977 | 2021-08-29 | Shelby | Alabama | 1117 | 31769 | 276 |
1660729 | 1660729 | 2021-08-28 | Shelby | Alabama | 1117 | 31616 | 276 |
1657481 | 1657481 | 2021-08-27 | Shelby | Alabama | 1117 | 31209 | 275 |
1654233 | 1654233 | 2021-08-26 | Shelby | Alabama | 1117 | 30999 | 274 |
1650987 | 1650987 | 2021-08-25 | Shelby | Alabama | 1117 | 30521 | 272 |
1647738 | 1647738 | 2021-08-24 | Shelby | Alabama | 1117 | 30521 | 272 |
1644489 | 1644489 | 2021-08-23 | Shelby | Alabama | 1117 | 30521 | 272 |
1641239 | 1641239 | 2021-08-22 | Shelby | Alabama | 1117 | 30403 | 272 |
1637989 | 1637989 | 2021-08-21 | Shelby | Alabama | 1117 | 30267 | 272 |
1634739 | 1634739 | 2021-08-20 | Shelby | Alabama | 1117 | 29987 | 271 |
1631491 | 1631491 | 2021-08-19 | Shelby | Alabama | 1117 | 29850 | 270 |
1628244 | 1628244 | 2021-08-18 | Shelby | Alabama | 1117 | 29718 | 269 |
1624997 | 1624997 | 2021-08-17 | Shelby | Alabama | 1117 | 29561 | 269 |
1621750 | 1621750 | 2021-08-16 | Shelby | Alabama | 1117 | 29401 | 267 |
1618502 | 1618502 | 2021-08-15 | Shelby | Alabama | 1117 | 29284 | 267 |
1615254 | 1615254 | 2021-08-14 | Shelby | Alabama | 1117 | 28898 | 267 |
1612005 | 1612005 | 2021-08-13 | Shelby | Alabama | 1117 | 28898 | 267 |
1608758 | 1608758 | 2021-08-12 | Shelby | Alabama | 1117 | 28764 | 267 |
1605509 | 1605509 | 2021-08-11 | Shelby | Alabama | 1117 | 28595 | 266 |
1602259 | 1602259 | 2021-08-10 | Shelby | Alabama | 1117 | 28472 | 264 |
1599011 | 1599011 | 2021-08-09 | Shelby | Alabama | 1117 | 28336 | 263 |
1595762 | 1595762 | 2021-08-08 | Shelby | Alabama | 1117 | 28122 | 263 |
1592513 | 1592513 | 2021-08-07 | Shelby | Alabama | 1117 | 28122 | 263 |
1589264 | 1589264 | 2021-08-06 | Shelby | Alabama | 1117 | 27961 | 262 |
1586015 | 1586015 | 2021-08-05 | Shelby | Alabama | 1117 | 27810 | 261 |
1582765 | 1582765 | 2021-08-04 | Shelby | Alabama | 1117 | 27652 | 260 |
1579515 | 1579515 | 2021-08-03 | Shelby | Alabama | 1117 | 27501 | 259 |
1576267 | 1576267 | 2021-08-02 | Shelby | Alabama | 1117 | 27362 | 257 |
1573019 | 1573019 | 2021-08-01 | Shelby | Alabama | 1117 | 27280 | 257 |
1569771 | 1569771 | 2021-07-31 | Shelby | Alabama | 1117 | 27192 | 257 |
1566523 | 1566523 | 2021-07-30 | Shelby | Alabama | 1117 | 26983 | 256 |
1563275 | 1563275 | 2021-07-29 | Shelby | Alabama | 1117 | 26983 | 256 |
1560027 | 1560027 | 2021-07-28 | Shelby | Alabama | 1117 | 26873 | 256 |
1556780 | 1556780 | 2021-07-27 | Shelby | Alabama | 1117 | 26769 | 255 |
1553533 | 1553533 | 2021-07-26 | Shelby | Alabama | 1117 | 26671 | 255 |
1550286 | 1550286 | 2021-07-25 | Shelby | Alabama | 1117 | 26612 | 255 |
1547039 | 1547039 | 2021-07-24 | Shelby | Alabama | 1117 | 26527 | 255 |
1543792 | 1543792 | 2021-07-23 | Shelby | Alabama | 1117 | 26461 | 255 |
1540544 | 1540544 | 2021-07-22 | Shelby | Alabama | 1117 | 26409 | 255 |
1537297 | 1537297 | 2021-07-21 | Shelby | Alabama | 1117 | 26332 | 255 |
1534049 | 1534049 | 2021-07-20 | Shelby | Alabama | 1117 | 26270 | 255 |
1530802 | 1530802 | 2021-07-19 | Shelby | Alabama | 1117 | 26225 | 255 |
1527555 | 1527555 | 2021-07-18 | Shelby | Alabama | 1117 | 26194 | 255 |
1524308 | 1524308 | 2021-07-17 | Shelby | Alabama | 1117 | 26159 | 255 |
1521060 | 1521060 | 2021-07-16 | Shelby | Alabama | 1117 | 26122 | 255 |
1517812 | 1517812 | 2021-07-15 | Shelby | Alabama | 1117 | 26060 | 255 |
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);