ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 1077 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1943383 | 1943383 | 2021-11-23 | Lauderdale | Alabama | 1077 | 14919 | 306 |
1940133 | 1940133 | 2021-11-22 | Lauderdale | Alabama | 1077 | 14907 | 306 |
1936883 | 1936883 | 2021-11-21 | Lauderdale | Alabama | 1077 | 14904 | 306 |
1933633 | 1933633 | 2021-11-20 | Lauderdale | Alabama | 1077 | 14900 | 306 |
1930381 | 1930381 | 2021-11-19 | Lauderdale | Alabama | 1077 | 14883 | 306 |
1927131 | 1927131 | 2021-11-18 | Lauderdale | Alabama | 1077 | 14869 | 305 |
1923881 | 1923881 | 2021-11-17 | Lauderdale | Alabama | 1077 | 14851 | 304 |
1920632 | 1920632 | 2021-11-16 | Lauderdale | Alabama | 1077 | 14843 | 306 |
1917382 | 1917382 | 2021-11-15 | Lauderdale | Alabama | 1077 | 14836 | 306 |
1914132 | 1914132 | 2021-11-14 | Lauderdale | Alabama | 1077 | 14832 | 306 |
1910882 | 1910882 | 2021-11-13 | Lauderdale | Alabama | 1077 | 14822 | 306 |
1907633 | 1907633 | 2021-11-12 | Lauderdale | Alabama | 1077 | 14817 | 303 |
1904384 | 1904384 | 2021-11-11 | Lauderdale | Alabama | 1077 | 14799 | 303 |
1901134 | 1901134 | 2021-11-10 | Lauderdale | Alabama | 1077 | 14775 | 303 |
1897884 | 1897884 | 2021-11-09 | Lauderdale | Alabama | 1077 | 14778 | 301 |
1894634 | 1894634 | 2021-11-08 | Lauderdale | Alabama | 1077 | 14760 | 301 |
1891384 | 1891384 | 2021-11-07 | Lauderdale | Alabama | 1077 | 14746 | 301 |
1888134 | 1888134 | 2021-11-06 | Lauderdale | Alabama | 1077 | 14744 | 301 |
1884884 | 1884884 | 2021-11-05 | Lauderdale | Alabama | 1077 | 14733 | 301 |
1881635 | 1881635 | 2021-11-04 | Lauderdale | Alabama | 1077 | 14721 | 300 |
1878386 | 1878386 | 2021-11-03 | Lauderdale | Alabama | 1077 | 14697 | 297 |
1875137 | 1875137 | 2021-11-02 | Lauderdale | Alabama | 1077 | 14671 | 297 |
1871888 | 1871888 | 2021-11-01 | Lauderdale | Alabama | 1077 | 14653 | 296 |
1868639 | 1868639 | 2021-10-31 | Lauderdale | Alabama | 1077 | 14650 | 296 |
1865390 | 1865390 | 2021-10-30 | Lauderdale | Alabama | 1077 | 14641 | 296 |
1862141 | 1862141 | 2021-10-29 | Lauderdale | Alabama | 1077 | 14636 | 296 |
1858892 | 1858892 | 2021-10-28 | Lauderdale | Alabama | 1077 | 14627 | 295 |
1855643 | 1855643 | 2021-10-27 | Lauderdale | Alabama | 1077 | 14582 | 295 |
1852394 | 1852394 | 2021-10-26 | Lauderdale | Alabama | 1077 | 14366 | 295 |
1849144 | 1849144 | 2021-10-25 | Lauderdale | Alabama | 1077 | 14323 | 295 |
1845894 | 1845894 | 2021-10-24 | Lauderdale | Alabama | 1077 | 14314 | 295 |
1842644 | 1842644 | 2021-10-23 | Lauderdale | Alabama | 1077 | 14302 | 295 |
1839395 | 1839395 | 2021-10-22 | Lauderdale | Alabama | 1077 | 14270 | 295 |
1836146 | 1836146 | 2021-10-21 | Lauderdale | Alabama | 1077 | 14225 | 294 |
1832897 | 1832897 | 2021-10-20 | Lauderdale | Alabama | 1077 | 14205 | 294 |
1829648 | 1829648 | 2021-10-19 | Lauderdale | Alabama | 1077 | 14178 | 294 |
1826399 | 1826399 | 2021-10-18 | Lauderdale | Alabama | 1077 | 14163 | 294 |
1823150 | 1823150 | 2021-10-17 | Lauderdale | Alabama | 1077 | 14157 | 294 |
1819901 | 1819901 | 2021-10-16 | Lauderdale | Alabama | 1077 | 14143 | 294 |
1816652 | 1816652 | 2021-10-15 | Lauderdale | Alabama | 1077 | 14125 | 294 |
1813404 | 1813404 | 2021-10-14 | Lauderdale | Alabama | 1077 | 14060 | 294 |
1810155 | 1810155 | 2021-10-13 | Lauderdale | Alabama | 1077 | 14038 | 294 |
1806906 | 1806906 | 2021-10-12 | Lauderdale | Alabama | 1077 | 13996 | 292 |
1803655 | 1803655 | 2021-10-11 | Lauderdale | Alabama | 1077 | 13971 | 292 |
1800406 | 1800406 | 2021-10-10 | Lauderdale | Alabama | 1077 | 13955 | 292 |
1797157 | 1797157 | 2021-10-09 | Lauderdale | Alabama | 1077 | 13938 | 292 |
1793908 | 1793908 | 2021-10-08 | Lauderdale | Alabama | 1077 | 13923 | 288 |
1790659 | 1790659 | 2021-10-07 | Lauderdale | Alabama | 1077 | 13898 | 287 |
1787411 | 1787411 | 2021-10-06 | Lauderdale | Alabama | 1077 | 13861 | 287 |
1784162 | 1784162 | 2021-10-05 | Lauderdale | Alabama | 1077 | 13822 | 285 |
1780913 | 1780913 | 2021-10-04 | Lauderdale | Alabama | 1077 | 13796 | 284 |
1777663 | 1777663 | 2021-10-03 | Lauderdale | Alabama | 1077 | 13786 | 284 |
1774413 | 1774413 | 2021-10-02 | Lauderdale | Alabama | 1077 | 13766 | 284 |
1771163 | 1771163 | 2021-10-01 | Lauderdale | Alabama | 1077 | 13737 | 284 |
1767914 | 1767914 | 2021-09-30 | Lauderdale | Alabama | 1077 | 13701 | 283 |
1764665 | 1764665 | 2021-09-29 | Lauderdale | Alabama | 1077 | 13664 | 282 |
1761416 | 1761416 | 2021-09-28 | Lauderdale | Alabama | 1077 | 13604 | 281 |
1758168 | 1758168 | 2021-09-27 | Lauderdale | Alabama | 1077 | 13557 | 281 |
1754920 | 1754920 | 2021-09-26 | Lauderdale | Alabama | 1077 | 13520 | 281 |
1751672 | 1751672 | 2021-09-25 | Lauderdale | Alabama | 1077 | 13486 | 281 |
1748423 | 1748423 | 2021-09-24 | Lauderdale | Alabama | 1077 | 13436 | 280 |
1745173 | 1745173 | 2021-09-23 | Lauderdale | Alabama | 1077 | 13395 | 278 |
1741924 | 1741924 | 2021-09-22 | Lauderdale | Alabama | 1077 | 13298 | 278 |
1738675 | 1738675 | 2021-09-21 | Lauderdale | Alabama | 1077 | 13248 | 273 |
1735426 | 1735426 | 2021-09-20 | Lauderdale | Alabama | 1077 | 13206 | 272 |
1732176 | 1732176 | 2021-09-19 | Lauderdale | Alabama | 1077 | 13176 | 272 |
1728926 | 1728926 | 2021-09-18 | Lauderdale | Alabama | 1077 | 13128 | 272 |
1725676 | 1725676 | 2021-09-17 | Lauderdale | Alabama | 1077 | 13030 | 266 |
1722427 | 1722427 | 2021-09-16 | Lauderdale | Alabama | 1077 | 12986 | 264 |
1719179 | 1719179 | 2021-09-15 | Lauderdale | Alabama | 1077 | 12909 | 263 |
1715931 | 1715931 | 2021-09-14 | Lauderdale | Alabama | 1077 | 12810 | 263 |
1712685 | 1712685 | 2021-09-13 | Lauderdale | Alabama | 1077 | 12734 | 263 |
1709438 | 1709438 | 2021-09-12 | Lauderdale | Alabama | 1077 | 12702 | 263 |
1706191 | 1706191 | 2021-09-11 | Lauderdale | Alabama | 1077 | 12680 | 263 |
1702943 | 1702943 | 2021-09-10 | Lauderdale | Alabama | 1077 | 12597 | 262 |
1699693 | 1699693 | 2021-09-09 | Lauderdale | Alabama | 1077 | 12500 | 261 |
1696444 | 1696444 | 2021-09-08 | Lauderdale | Alabama | 1077 | 12406 | 260 |
1693196 | 1693196 | 2021-09-07 | Lauderdale | Alabama | 1077 | 12363 | 259 |
1689947 | 1689947 | 2021-09-06 | Lauderdale | Alabama | 1077 | 12327 | 259 |
1686697 | 1686697 | 2021-09-05 | Lauderdale | Alabama | 1077 | 12293 | 259 |
1683447 | 1683447 | 2021-09-04 | Lauderdale | Alabama | 1077 | 12261 | 259 |
1680196 | 1680196 | 2021-09-03 | Lauderdale | Alabama | 1077 | 12198 | 259 |
1676948 | 1676948 | 2021-09-02 | Lauderdale | Alabama | 1077 | 12133 | 259 |
1673701 | 1673701 | 2021-09-01 | Lauderdale | Alabama | 1077 | 12073 | 258 |
1670453 | 1670453 | 2021-08-31 | Lauderdale | Alabama | 1077 | 11982 | 258 |
1667206 | 1667206 | 2021-08-30 | Lauderdale | Alabama | 1077 | 11921 | 258 |
1663958 | 1663958 | 2021-08-29 | Lauderdale | Alabama | 1077 | 11851 | 258 |
1660710 | 1660710 | 2021-08-28 | Lauderdale | Alabama | 1077 | 11808 | 258 |
1657462 | 1657462 | 2021-08-27 | Lauderdale | Alabama | 1077 | 11720 | 258 |
1654214 | 1654214 | 2021-08-26 | Lauderdale | Alabama | 1077 | 11599 | 258 |
1650968 | 1650968 | 2021-08-25 | Lauderdale | Alabama | 1077 | 11434 | 258 |
1647719 | 1647719 | 2021-08-24 | Lauderdale | Alabama | 1077 | 11434 | 258 |
1644470 | 1644470 | 2021-08-23 | Lauderdale | Alabama | 1077 | 11434 | 258 |
1641220 | 1641220 | 2021-08-22 | Lauderdale | Alabama | 1077 | 11395 | 258 |
1637970 | 1637970 | 2021-08-21 | Lauderdale | Alabama | 1077 | 11371 | 258 |
1634720 | 1634720 | 2021-08-20 | Lauderdale | Alabama | 1077 | 11281 | 257 |
1631472 | 1631472 | 2021-08-19 | Lauderdale | Alabama | 1077 | 11195 | 257 |
1628225 | 1628225 | 2021-08-18 | Lauderdale | Alabama | 1077 | 11147 | 256 |
1624978 | 1624978 | 2021-08-17 | Lauderdale | Alabama | 1077 | 11064 | 256 |
1621731 | 1621731 | 2021-08-16 | Lauderdale | Alabama | 1077 | 10997 | 256 |
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);