ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lauderdale" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1618483 | 1618483 | 2021-08-15 | Lauderdale | Alabama | 1077 | 10948 | 256 |
1615235 | 1615235 | 2021-08-14 | Lauderdale | Alabama | 1077 | 10836 | 256 |
1611986 | 1611986 | 2021-08-13 | Lauderdale | Alabama | 1077 | 10836 | 256 |
1608739 | 1608739 | 2021-08-12 | Lauderdale | Alabama | 1077 | 10769 | 256 |
1605490 | 1605490 | 2021-08-11 | Lauderdale | Alabama | 1077 | 10711 | 255 |
1602240 | 1602240 | 2021-08-10 | Lauderdale | Alabama | 1077 | 10654 | 255 |
1598992 | 1598992 | 2021-08-09 | Lauderdale | Alabama | 1077 | 10614 | 255 |
1595743 | 1595743 | 2021-08-08 | Lauderdale | Alabama | 1077 | 10542 | 255 |
1592494 | 1592494 | 2021-08-07 | Lauderdale | Alabama | 1077 | 10542 | 255 |
1589245 | 1589245 | 2021-08-06 | Lauderdale | Alabama | 1077 | 10473 | 255 |
1585996 | 1585996 | 2021-08-05 | Lauderdale | Alabama | 1077 | 10429 | 255 |
1582746 | 1582746 | 2021-08-04 | Lauderdale | Alabama | 1077 | 10374 | 255 |
1579496 | 1579496 | 2021-08-03 | Lauderdale | Alabama | 1077 | 10305 | 254 |
1576248 | 1576248 | 2021-08-02 | Lauderdale | Alabama | 1077 | 10266 | 254 |
1573000 | 1573000 | 2021-08-01 | Lauderdale | Alabama | 1077 | 10255 | 254 |
1569752 | 1569752 | 2021-07-31 | Lauderdale | Alabama | 1077 | 10240 | 254 |
1566504 | 1566504 | 2021-07-30 | Lauderdale | Alabama | 1077 | 10120 | 254 |
1563256 | 1563256 | 2021-07-29 | Lauderdale | Alabama | 1077 | 10120 | 254 |
1560008 | 1560008 | 2021-07-28 | Lauderdale | Alabama | 1077 | 10083 | 254 |
1556761 | 1556761 | 2021-07-27 | Lauderdale | Alabama | 1077 | 10044 | 253 |
1553514 | 1553514 | 2021-07-26 | Lauderdale | Alabama | 1077 | 10009 | 253 |
1550267 | 1550267 | 2021-07-25 | Lauderdale | Alabama | 1077 | 9991 | 253 |
1547020 | 1547020 | 2021-07-24 | Lauderdale | Alabama | 1077 | 9968 | 253 |
1543773 | 1543773 | 2021-07-23 | Lauderdale | Alabama | 1077 | 9918 | 253 |
1540525 | 1540525 | 2021-07-22 | Lauderdale | Alabama | 1077 | 9883 | 253 |
1537278 | 1537278 | 2021-07-21 | Lauderdale | Alabama | 1077 | 9872 | 253 |
1534030 | 1534030 | 2021-07-20 | Lauderdale | Alabama | 1077 | 9830 | 253 |
1530783 | 1530783 | 2021-07-19 | Lauderdale | Alabama | 1077 | 9813 | 253 |
1527536 | 1527536 | 2021-07-18 | Lauderdale | Alabama | 1077 | 9805 | 253 |
1524289 | 1524289 | 2021-07-17 | Lauderdale | Alabama | 1077 | 9793 | 253 |
1521041 | 1521041 | 2021-07-16 | Lauderdale | Alabama | 1077 | 9782 | 253 |
1517793 | 1517793 | 2021-07-15 | Lauderdale | Alabama | 1077 | 9767 | 253 |
1514546 | 1514546 | 2021-07-14 | Lauderdale | Alabama | 1077 | 9754 | 253 |
1511300 | 1511300 | 2021-07-13 | Lauderdale | Alabama | 1077 | 9720 | 252 |
1508053 | 1508053 | 2021-07-12 | Lauderdale | Alabama | 1077 | 9720 | 252 |
1504807 | 1504807 | 2021-07-11 | Lauderdale | Alabama | 1077 | 9703 | 252 |
1501561 | 1501561 | 2021-07-10 | Lauderdale | Alabama | 1077 | 9703 | 252 |
1498315 | 1498315 | 2021-07-09 | Lauderdale | Alabama | 1077 | 9698 | 252 |
1495068 | 1495068 | 2021-07-08 | Lauderdale | Alabama | 1077 | 9674 | 252 |
1491821 | 1491821 | 2021-07-07 | Lauderdale | Alabama | 1077 | 9674 | 252 |
1488574 | 1488574 | 2021-07-06 | Lauderdale | Alabama | 1077 | 9653 | 251 |
1485327 | 1485327 | 2021-07-05 | Lauderdale | Alabama | 1077 | 9653 | 251 |
1482081 | 1482081 | 2021-07-04 | Lauderdale | Alabama | 1077 | 9653 | 251 |
1478834 | 1478834 | 2021-07-03 | Lauderdale | Alabama | 1077 | 9653 | 251 |
1475588 | 1475588 | 2021-07-02 | Lauderdale | Alabama | 1077 | 9653 | 251 |
1472342 | 1472342 | 2021-07-01 | Lauderdale | Alabama | 1077 | 9645 | 251 |
1469097 | 1469097 | 2021-06-30 | Lauderdale | Alabama | 1077 | 9645 | 251 |
1465852 | 1465852 | 2021-06-29 | Lauderdale | Alabama | 1077 | 9640 | 251 |
1462607 | 1462607 | 2021-06-28 | Lauderdale | Alabama | 1077 | 9640 | 251 |
1459362 | 1459362 | 2021-06-27 | Lauderdale | Alabama | 1077 | 9632 | 250 |
1456117 | 1456117 | 2021-06-26 | Lauderdale | Alabama | 1077 | 9632 | 250 |
1452872 | 1452872 | 2021-06-25 | Lauderdale | Alabama | 1077 | 9632 | 250 |
1449626 | 1449626 | 2021-06-24 | Lauderdale | Alabama | 1077 | 9621 | 250 |
1446381 | 1446381 | 2021-06-23 | Lauderdale | Alabama | 1077 | 9621 | 250 |
1443136 | 1443136 | 2021-06-22 | Lauderdale | Alabama | 1077 | 9612 | 250 |
1439891 | 1439891 | 2021-06-21 | Lauderdale | Alabama | 1077 | 9612 | 250 |
1436644 | 1436644 | 2021-06-20 | Lauderdale | Alabama | 1077 | 9603 | 250 |
1433397 | 1433397 | 2021-06-19 | Lauderdale | Alabama | 1077 | 9603 | 250 |
1430151 | 1430151 | 2021-06-18 | Lauderdale | Alabama | 1077 | 9603 | 250 |
1426906 | 1426906 | 2021-06-17 | Lauderdale | Alabama | 1077 | 9596 | 249 |
1423660 | 1423660 | 2021-06-16 | Lauderdale | Alabama | 1077 | 9596 | 249 |
1420413 | 1420413 | 2021-06-15 | Lauderdale | Alabama | 1077 | 9592 | 249 |
1417168 | 1417168 | 2021-06-14 | Lauderdale | Alabama | 1077 | 9591 | 248 |
1413922 | 1413922 | 2021-06-13 | Lauderdale | Alabama | 1077 | 9582 | 248 |
1410677 | 1410677 | 2021-06-12 | Lauderdale | Alabama | 1077 | 9582 | 248 |
1407432 | 1407432 | 2021-06-11 | Lauderdale | Alabama | 1077 | 9582 | 248 |
1404186 | 1404186 | 2021-06-10 | Lauderdale | Alabama | 1077 | 9578 | 248 |
1400941 | 1400941 | 2021-06-09 | Lauderdale | Alabama | 1077 | 9570 | 248 |
1397696 | 1397696 | 2021-06-08 | Lauderdale | Alabama | 1077 | 9556 | 246 |
1394449 | 1394449 | 2021-06-07 | Lauderdale | Alabama | 1077 | 9552 | 246 |
1391204 | 1391204 | 2021-06-06 | Lauderdale | Alabama | 1077 | 9537 | 245 |
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);