ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1019 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712656 | 1712656 | 2021-09-13 | Cherokee | Alabama | 1019 | 2714 | 49 |
1709409 | 1709409 | 2021-09-12 | Cherokee | Alabama | 1019 | 2703 | 49 |
1706162 | 1706162 | 2021-09-11 | Cherokee | Alabama | 1019 | 2688 | 49 |
1702914 | 1702914 | 2021-09-10 | Cherokee | Alabama | 1019 | 2673 | 49 |
1699664 | 1699664 | 2021-09-09 | Cherokee | Alabama | 1019 | 2662 | 49 |
1696415 | 1696415 | 2021-09-08 | Cherokee | Alabama | 1019 | 2639 | 49 |
1693167 | 1693167 | 2021-09-07 | Cherokee | Alabama | 1019 | 2620 | 49 |
1689918 | 1689918 | 2021-09-06 | Cherokee | Alabama | 1019 | 2611 | 49 |
1686668 | 1686668 | 2021-09-05 | Cherokee | Alabama | 1019 | 2585 | 49 |
1683418 | 1683418 | 2021-09-04 | Cherokee | Alabama | 1019 | 2558 | 49 |
1680167 | 1680167 | 2021-09-03 | Cherokee | Alabama | 1019 | 2529 | 49 |
1676919 | 1676919 | 2021-09-02 | Cherokee | Alabama | 1019 | 2496 | 49 |
1673672 | 1673672 | 2021-09-01 | Cherokee | Alabama | 1019 | 2481 | 49 |
1670424 | 1670424 | 2021-08-31 | Cherokee | Alabama | 1019 | 2444 | 49 |
1667177 | 1667177 | 2021-08-30 | Cherokee | Alabama | 1019 | 2412 | 49 |
1663929 | 1663929 | 2021-08-29 | Cherokee | Alabama | 1019 | 2400 | 49 |
1660681 | 1660681 | 2021-08-28 | Cherokee | Alabama | 1019 | 2372 | 49 |
1657433 | 1657433 | 2021-08-27 | Cherokee | Alabama | 1019 | 2347 | 49 |
1654185 | 1654185 | 2021-08-26 | Cherokee | Alabama | 1019 | 2318 | 49 |
1650939 | 1650939 | 2021-08-25 | Cherokee | Alabama | 1019 | 2290 | 49 |
1647690 | 1647690 | 2021-08-24 | Cherokee | Alabama | 1019 | 2290 | 49 |
1644441 | 1644441 | 2021-08-23 | Cherokee | Alabama | 1019 | 2290 | 49 |
1641191 | 1641191 | 2021-08-22 | Cherokee | Alabama | 1019 | 2275 | 49 |
1637941 | 1637941 | 2021-08-21 | Cherokee | Alabama | 1019 | 2249 | 49 |
1634691 | 1634691 | 2021-08-20 | Cherokee | Alabama | 1019 | 2223 | 49 |
1631443 | 1631443 | 2021-08-19 | Cherokee | Alabama | 1019 | 2201 | 49 |
1628196 | 1628196 | 2021-08-18 | Cherokee | Alabama | 1019 | 2184 | 49 |
1624949 | 1624949 | 2021-08-17 | Cherokee | Alabama | 1019 | 2165 | 49 |
1621702 | 1621702 | 2021-08-16 | Cherokee | Alabama | 1019 | 2161 | 49 |
1618454 | 1618454 | 2021-08-15 | Cherokee | Alabama | 1019 | 2153 | 49 |
1615206 | 1615206 | 2021-08-14 | Cherokee | Alabama | 1019 | 2118 | 49 |
1611957 | 1611957 | 2021-08-13 | Cherokee | Alabama | 1019 | 2118 | 49 |
1608710 | 1608710 | 2021-08-12 | Cherokee | Alabama | 1019 | 2105 | 49 |
1605461 | 1605461 | 2021-08-11 | Cherokee | Alabama | 1019 | 2099 | 48 |
1602211 | 1602211 | 2021-08-10 | Cherokee | Alabama | 1019 | 2080 | 48 |
1598963 | 1598963 | 2021-08-09 | Cherokee | Alabama | 1019 | 2074 | 48 |
1595714 | 1595714 | 2021-08-08 | Cherokee | Alabama | 1019 | 2052 | 48 |
1592465 | 1592465 | 2021-08-07 | Cherokee | Alabama | 1019 | 2052 | 48 |
1589216 | 1589216 | 2021-08-06 | Cherokee | Alabama | 1019 | 2039 | 48 |
1585967 | 1585967 | 2021-08-05 | Cherokee | Alabama | 1019 | 2030 | 48 |
1582717 | 1582717 | 2021-08-04 | Cherokee | Alabama | 1019 | 2017 | 48 |
1579467 | 1579467 | 2021-08-03 | Cherokee | Alabama | 1019 | 2007 | 48 |
1576219 | 1576219 | 2021-08-02 | Cherokee | Alabama | 1019 | 1995 | 48 |
1572971 | 1572971 | 2021-08-01 | Cherokee | Alabama | 1019 | 1992 | 48 |
1569723 | 1569723 | 2021-07-31 | Cherokee | Alabama | 1019 | 1988 | 48 |
1566475 | 1566475 | 2021-07-30 | Cherokee | Alabama | 1019 | 1973 | 48 |
1563227 | 1563227 | 2021-07-29 | Cherokee | Alabama | 1019 | 1973 | 48 |
1559979 | 1559979 | 2021-07-28 | Cherokee | Alabama | 1019 | 1963 | 48 |
1556732 | 1556732 | 2021-07-27 | Cherokee | Alabama | 1019 | 1945 | 48 |
1553485 | 1553485 | 2021-07-26 | Cherokee | Alabama | 1019 | 1939 | 48 |
1550238 | 1550238 | 2021-07-25 | Cherokee | Alabama | 1019 | 1939 | 48 |
1546991 | 1546991 | 2021-07-24 | Cherokee | Alabama | 1019 | 1938 | 48 |
1543744 | 1543744 | 2021-07-23 | Cherokee | Alabama | 1019 | 1927 | 48 |
1540496 | 1540496 | 2021-07-22 | Cherokee | Alabama | 1019 | 1923 | 47 |
1537249 | 1537249 | 2021-07-21 | Cherokee | Alabama | 1019 | 1920 | 47 |
1534001 | 1534001 | 2021-07-20 | Cherokee | Alabama | 1019 | 1911 | 47 |
1530754 | 1530754 | 2021-07-19 | Cherokee | Alabama | 1019 | 1909 | 47 |
1527507 | 1527507 | 2021-07-18 | Cherokee | Alabama | 1019 | 1909 | 47 |
1524260 | 1524260 | 2021-07-17 | Cherokee | Alabama | 1019 | 1908 | 47 |
1521012 | 1521012 | 2021-07-16 | Cherokee | Alabama | 1019 | 1903 | 47 |
1517764 | 1517764 | 2021-07-15 | Cherokee | Alabama | 1019 | 1899 | 47 |
1514517 | 1514517 | 2021-07-14 | Cherokee | Alabama | 1019 | 1898 | 47 |
1511271 | 1511271 | 2021-07-13 | Cherokee | Alabama | 1019 | 1896 | 47 |
1508024 | 1508024 | 2021-07-12 | Cherokee | Alabama | 1019 | 1896 | 47 |
1504778 | 1504778 | 2021-07-11 | Cherokee | Alabama | 1019 | 1896 | 47 |
1501532 | 1501532 | 2021-07-10 | Cherokee | Alabama | 1019 | 1896 | 47 |
1498286 | 1498286 | 2021-07-09 | Cherokee | Alabama | 1019 | 1896 | 47 |
1495039 | 1495039 | 2021-07-08 | Cherokee | Alabama | 1019 | 1885 | 45 |
1491792 | 1491792 | 2021-07-07 | Cherokee | Alabama | 1019 | 1885 | 45 |
1488545 | 1488545 | 2021-07-06 | Cherokee | Alabama | 1019 | 1874 | 45 |
1485298 | 1485298 | 2021-07-05 | Cherokee | Alabama | 1019 | 1874 | 45 |
1482052 | 1482052 | 2021-07-04 | Cherokee | Alabama | 1019 | 1874 | 45 |
1478805 | 1478805 | 2021-07-03 | Cherokee | Alabama | 1019 | 1874 | 45 |
1475559 | 1475559 | 2021-07-02 | Cherokee | Alabama | 1019 | 1874 | 45 |
1472313 | 1472313 | 2021-07-01 | Cherokee | Alabama | 1019 | 1874 | 45 |
1469068 | 1469068 | 2021-06-30 | Cherokee | Alabama | 1019 | 1874 | 45 |
1465823 | 1465823 | 2021-06-29 | Cherokee | Alabama | 1019 | 1874 | 45 |
1462578 | 1462578 | 2021-06-28 | Cherokee | Alabama | 1019 | 1874 | 45 |
1459333 | 1459333 | 2021-06-27 | Cherokee | Alabama | 1019 | 1874 | 45 |
1456088 | 1456088 | 2021-06-26 | Cherokee | Alabama | 1019 | 1874 | 45 |
1452843 | 1452843 | 2021-06-25 | Cherokee | Alabama | 1019 | 1874 | 45 |
1449597 | 1449597 | 2021-06-24 | Cherokee | Alabama | 1019 | 1875 | 45 |
1446352 | 1446352 | 2021-06-23 | Cherokee | Alabama | 1019 | 1875 | 45 |
1443107 | 1443107 | 2021-06-22 | Cherokee | Alabama | 1019 | 1873 | 45 |
1439862 | 1439862 | 2021-06-21 | Cherokee | Alabama | 1019 | 1873 | 45 |
1436615 | 1436615 | 2021-06-20 | Cherokee | Alabama | 1019 | 1873 | 45 |
1433368 | 1433368 | 2021-06-19 | Cherokee | Alabama | 1019 | 1873 | 45 |
1430122 | 1430122 | 2021-06-18 | Cherokee | Alabama | 1019 | 1873 | 45 |
1426877 | 1426877 | 2021-06-17 | Cherokee | Alabama | 1019 | 1872 | 45 |
1423631 | 1423631 | 2021-06-16 | Cherokee | Alabama | 1019 | 1872 | 45 |
1420384 | 1420384 | 2021-06-15 | Cherokee | Alabama | 1019 | 1872 | 45 |
1417139 | 1417139 | 2021-06-14 | Cherokee | Alabama | 1019 | 1872 | 45 |
1413893 | 1413893 | 2021-06-13 | Cherokee | Alabama | 1019 | 1872 | 45 |
1410648 | 1410648 | 2021-06-12 | Cherokee | Alabama | 1019 | 1872 | 45 |
1407403 | 1407403 | 2021-06-11 | Cherokee | Alabama | 1019 | 1872 | 45 |
1404157 | 1404157 | 2021-06-10 | Cherokee | Alabama | 1019 | 1872 | 45 |
1400912 | 1400912 | 2021-06-09 | Cherokee | Alabama | 1019 | 1870 | 45 |
1397667 | 1397667 | 2021-06-08 | Cherokee | Alabama | 1019 | 1869 | 45 |
1394420 | 1394420 | 2021-06-07 | Cherokee | Alabama | 1019 | 1869 | 45 |
1391175 | 1391175 | 2021-06-06 | Cherokee | Alabama | 1019 | 1866 | 45 |
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);