ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 1015 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712654 | 1712654 | 2021-09-13 | Calhoun | Alabama | 1015 | 19359 | 363 |
1709407 | 1709407 | 2021-09-12 | Calhoun | Alabama | 1015 | 19273 | 363 |
1706160 | 1706160 | 2021-09-11 | Calhoun | Alabama | 1015 | 19236 | 363 |
1702912 | 1702912 | 2021-09-10 | Calhoun | Alabama | 1015 | 19049 | 357 |
1699662 | 1699662 | 2021-09-09 | Calhoun | Alabama | 1015 | 18910 | 356 |
1696413 | 1696413 | 2021-09-08 | Calhoun | Alabama | 1015 | 18787 | 356 |
1693165 | 1693165 | 2021-09-07 | Calhoun | Alabama | 1015 | 18676 | 355 |
1689916 | 1689916 | 2021-09-06 | Calhoun | Alabama | 1015 | 18608 | 355 |
1686666 | 1686666 | 2021-09-05 | Calhoun | Alabama | 1015 | 18543 | 355 |
1683416 | 1683416 | 2021-09-04 | Calhoun | Alabama | 1015 | 18465 | 355 |
1680165 | 1680165 | 2021-09-03 | Calhoun | Alabama | 1015 | 18310 | 355 |
1676917 | 1676917 | 2021-09-02 | Calhoun | Alabama | 1015 | 18142 | 355 |
1673670 | 1673670 | 2021-09-01 | Calhoun | Alabama | 1015 | 17999 | 354 |
1670422 | 1670422 | 2021-08-31 | Calhoun | Alabama | 1015 | 17858 | 354 |
1667175 | 1667175 | 2021-08-30 | Calhoun | Alabama | 1015 | 17707 | 351 |
1663927 | 1663927 | 2021-08-29 | Calhoun | Alabama | 1015 | 17616 | 351 |
1660679 | 1660679 | 2021-08-28 | Calhoun | Alabama | 1015 | 17509 | 351 |
1657431 | 1657431 | 2021-08-27 | Calhoun | Alabama | 1015 | 17317 | 350 |
1654183 | 1654183 | 2021-08-26 | Calhoun | Alabama | 1015 | 17154 | 350 |
1650937 | 1650937 | 2021-08-25 | Calhoun | Alabama | 1015 | 16949 | 350 |
1647688 | 1647688 | 2021-08-24 | Calhoun | Alabama | 1015 | 16949 | 350 |
1644439 | 1644439 | 2021-08-23 | Calhoun | Alabama | 1015 | 16949 | 350 |
1641189 | 1641189 | 2021-08-22 | Calhoun | Alabama | 1015 | 16877 | 350 |
1637939 | 1637939 | 2021-08-21 | Calhoun | Alabama | 1015 | 16813 | 350 |
1634689 | 1634689 | 2021-08-20 | Calhoun | Alabama | 1015 | 16676 | 347 |
1631441 | 1631441 | 2021-08-19 | Calhoun | Alabama | 1015 | 16596 | 346 |
1628194 | 1628194 | 2021-08-18 | Calhoun | Alabama | 1015 | 16515 | 344 |
1624947 | 1624947 | 2021-08-17 | Calhoun | Alabama | 1015 | 16407 | 344 |
1621700 | 1621700 | 2021-08-16 | Calhoun | Alabama | 1015 | 16340 | 340 |
1618452 | 1618452 | 2021-08-15 | Calhoun | Alabama | 1015 | 16291 | 340 |
1615204 | 1615204 | 2021-08-14 | Calhoun | Alabama | 1015 | 16163 | 339 |
1611955 | 1611955 | 2021-08-13 | Calhoun | Alabama | 1015 | 16163 | 339 |
1608708 | 1608708 | 2021-08-12 | Calhoun | Alabama | 1015 | 16081 | 337 |
1605459 | 1605459 | 2021-08-11 | Calhoun | Alabama | 1015 | 15995 | 336 |
1602209 | 1602209 | 2021-08-10 | Calhoun | Alabama | 1015 | 15911 | 336 |
1598961 | 1598961 | 2021-08-09 | Calhoun | Alabama | 1015 | 15842 | 336 |
1595712 | 1595712 | 2021-08-08 | Calhoun | Alabama | 1015 | 15741 | 336 |
1592463 | 1592463 | 2021-08-07 | Calhoun | Alabama | 1015 | 15741 | 336 |
1589214 | 1589214 | 2021-08-06 | Calhoun | Alabama | 1015 | 15672 | 335 |
1585965 | 1585965 | 2021-08-05 | Calhoun | Alabama | 1015 | 15619 | 335 |
1582715 | 1582715 | 2021-08-04 | Calhoun | Alabama | 1015 | 15549 | 334 |
1579465 | 1579465 | 2021-08-03 | Calhoun | Alabama | 1015 | 15498 | 334 |
1576217 | 1576217 | 2021-08-02 | Calhoun | Alabama | 1015 | 15429 | 334 |
1572969 | 1572969 | 2021-08-01 | Calhoun | Alabama | 1015 | 15401 | 334 |
1569721 | 1569721 | 2021-07-31 | Calhoun | Alabama | 1015 | 15382 | 334 |
1566473 | 1566473 | 2021-07-30 | Calhoun | Alabama | 1015 | 15282 | 332 |
1563225 | 1563225 | 2021-07-29 | Calhoun | Alabama | 1015 | 15282 | 332 |
1559977 | 1559977 | 2021-07-28 | Calhoun | Alabama | 1015 | 15252 | 332 |
1556730 | 1556730 | 2021-07-27 | Calhoun | Alabama | 1015 | 15210 | 332 |
1553483 | 1553483 | 2021-07-26 | Calhoun | Alabama | 1015 | 15158 | 332 |
1550236 | 1550236 | 2021-07-25 | Calhoun | Alabama | 1015 | 15130 | 332 |
1546989 | 1546989 | 2021-07-24 | Calhoun | Alabama | 1015 | 15107 | 332 |
1543742 | 1543742 | 2021-07-23 | Calhoun | Alabama | 1015 | 15050 | 332 |
1540494 | 1540494 | 2021-07-22 | Calhoun | Alabama | 1015 | 15030 | 332 |
1537247 | 1537247 | 2021-07-21 | Calhoun | Alabama | 1015 | 14978 | 332 |
1533999 | 1533999 | 2021-07-20 | Calhoun | Alabama | 1015 | 14948 | 332 |
1530752 | 1530752 | 2021-07-19 | Calhoun | Alabama | 1015 | 14928 | 331 |
1527505 | 1527505 | 2021-07-18 | Calhoun | Alabama | 1015 | 14915 | 331 |
1524258 | 1524258 | 2021-07-17 | Calhoun | Alabama | 1015 | 14902 | 331 |
1521010 | 1521010 | 2021-07-16 | Calhoun | Alabama | 1015 | 14879 | 331 |
1517762 | 1517762 | 2021-07-15 | Calhoun | Alabama | 1015 | 14863 | 331 |
1514515 | 1514515 | 2021-07-14 | Calhoun | Alabama | 1015 | 14861 | 331 |
1511269 | 1511269 | 2021-07-13 | Calhoun | Alabama | 1015 | 14841 | 331 |
1508022 | 1508022 | 2021-07-12 | Calhoun | Alabama | 1015 | 14841 | 331 |
1504776 | 1504776 | 2021-07-11 | Calhoun | Alabama | 1015 | 14833 | 331 |
1501530 | 1501530 | 2021-07-10 | Calhoun | Alabama | 1015 | 14833 | 331 |
1498284 | 1498284 | 2021-07-09 | Calhoun | Alabama | 1015 | 14818 | 331 |
1495037 | 1495037 | 2021-07-08 | Calhoun | Alabama | 1015 | 14795 | 331 |
1491790 | 1491790 | 2021-07-07 | Calhoun | Alabama | 1015 | 14795 | 331 |
1488543 | 1488543 | 2021-07-06 | Calhoun | Alabama | 1015 | 14778 | 330 |
1485296 | 1485296 | 2021-07-05 | Calhoun | Alabama | 1015 | 14778 | 330 |
1482050 | 1482050 | 2021-07-04 | Calhoun | Alabama | 1015 | 14778 | 330 |
1478803 | 1478803 | 2021-07-03 | Calhoun | Alabama | 1015 | 14778 | 330 |
1475557 | 1475557 | 2021-07-02 | Calhoun | Alabama | 1015 | 14778 | 330 |
1472311 | 1472311 | 2021-07-01 | Calhoun | Alabama | 1015 | 14776 | 330 |
1469066 | 1469066 | 2021-06-30 | Calhoun | Alabama | 1015 | 14776 | 330 |
1465821 | 1465821 | 2021-06-29 | Calhoun | Alabama | 1015 | 14766 | 330 |
1462576 | 1462576 | 2021-06-28 | Calhoun | Alabama | 1015 | 14766 | 330 |
1459331 | 1459331 | 2021-06-27 | Calhoun | Alabama | 1015 | 14761 | 330 |
1456086 | 1456086 | 2021-06-26 | Calhoun | Alabama | 1015 | 14761 | 330 |
1452841 | 1452841 | 2021-06-25 | Calhoun | Alabama | 1015 | 14761 | 330 |
1449595 | 1449595 | 2021-06-24 | Calhoun | Alabama | 1015 | 14725 | 329 |
1446350 | 1446350 | 2021-06-23 | Calhoun | Alabama | 1015 | 14725 | 329 |
1443105 | 1443105 | 2021-06-22 | Calhoun | Alabama | 1015 | 14724 | 327 |
1439860 | 1439860 | 2021-06-21 | Calhoun | Alabama | 1015 | 14724 | 327 |
1436613 | 1436613 | 2021-06-20 | Calhoun | Alabama | 1015 | 14719 | 327 |
1433366 | 1433366 | 2021-06-19 | Calhoun | Alabama | 1015 | 14719 | 327 |
1430120 | 1430120 | 2021-06-18 | Calhoun | Alabama | 1015 | 14719 | 327 |
1426875 | 1426875 | 2021-06-17 | Calhoun | Alabama | 1015 | 14718 | 325 |
1423629 | 1423629 | 2021-06-16 | Calhoun | Alabama | 1015 | 14718 | 325 |
1420382 | 1420382 | 2021-06-15 | Calhoun | Alabama | 1015 | 14714 | 325 |
1417137 | 1417137 | 2021-06-14 | Calhoun | Alabama | 1015 | 14710 | 325 |
1413891 | 1413891 | 2021-06-13 | Calhoun | Alabama | 1015 | 14692 | 325 |
1410646 | 1410646 | 2021-06-12 | Calhoun | Alabama | 1015 | 14692 | 325 |
1407401 | 1407401 | 2021-06-11 | Calhoun | Alabama | 1015 | 14692 | 325 |
1404155 | 1404155 | 2021-06-10 | Calhoun | Alabama | 1015 | 14692 | 325 |
1400910 | 1400910 | 2021-06-09 | Calhoun | Alabama | 1015 | 14684 | 325 |
1397665 | 1397665 | 2021-06-08 | Calhoun | Alabama | 1015 | 14683 | 325 |
1394418 | 1394418 | 2021-06-07 | Calhoun | Alabama | 1015 | 14681 | 325 |
1391173 | 1391173 | 2021-06-06 | Calhoun | Alabama | 1015 | 14668 | 325 |
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);