ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Clay" and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1823233 | 1823233 | 2021-10-17 | Clay | Arkansas | 5021 | 2689 | 66 |
1819984 | 1819984 | 2021-10-16 | Clay | Arkansas | 5021 | 2683 | 66 |
1816735 | 1816735 | 2021-10-15 | Clay | Arkansas | 5021 | 2679 | 66 |
1813487 | 1813487 | 2021-10-14 | Clay | Arkansas | 5021 | 2678 | 66 |
1810238 | 1810238 | 2021-10-13 | Clay | Arkansas | 5021 | 2676 | 66 |
1806989 | 1806989 | 2021-10-12 | Clay | Arkansas | 5021 | 2673 | 64 |
1803738 | 1803738 | 2021-10-11 | Clay | Arkansas | 5021 | 2670 | 64 |
1800489 | 1800489 | 2021-10-10 | Clay | Arkansas | 5021 | 2669 | 64 |
1797240 | 1797240 | 2021-10-09 | Clay | Arkansas | 5021 | 2664 | 60 |
1793991 | 1793991 | 2021-10-08 | Clay | Arkansas | 5021 | 2657 | 60 |
1790743 | 1790743 | 2021-10-07 | Clay | Arkansas | 5021 | 2651 | 60 |
1787494 | 1787494 | 2021-10-06 | Clay | Arkansas | 5021 | 2637 | 61 |
1784245 | 1784245 | 2021-10-05 | Clay | Arkansas | 5021 | 2629 | 60 |
1780996 | 1780996 | 2021-10-04 | Clay | Arkansas | 5021 | 2625 | 60 |
1777746 | 1777746 | 2021-10-03 | Clay | Arkansas | 5021 | 2623 | 59 |
1774496 | 1774496 | 2021-10-02 | Clay | Arkansas | 5021 | 2613 | 58 |
1771246 | 1771246 | 2021-10-01 | Clay | Arkansas | 5021 | 2611 | 58 |
1767997 | 1767997 | 2021-09-30 | Clay | Arkansas | 5021 | 2600 | 58 |
1764748 | 1764748 | 2021-09-29 | Clay | Arkansas | 5021 | 2589 | 58 |
1761499 | 1761499 | 2021-09-28 | Clay | Arkansas | 5021 | 2584 | 58 |
1758251 | 1758251 | 2021-09-27 | Clay | Arkansas | 5021 | 2580 | 58 |
1755003 | 1755003 | 2021-09-26 | Clay | Arkansas | 5021 | 2576 | 58 |
1751755 | 1751755 | 2021-09-25 | Clay | Arkansas | 5021 | 2574 | 58 |
1748506 | 1748506 | 2021-09-24 | Clay | Arkansas | 5021 | 2568 | 58 |
1745256 | 1745256 | 2021-09-23 | Clay | Arkansas | 5021 | 2560 | 58 |
1742007 | 1742007 | 2021-09-22 | Clay | Arkansas | 5021 | 2547 | 57 |
1738758 | 1738758 | 2021-09-21 | Clay | Arkansas | 5021 | 2532 | 55 |
1735509 | 1735509 | 2021-09-20 | Clay | Arkansas | 5021 | 2524 | 55 |
1732259 | 1732259 | 2021-09-19 | Clay | Arkansas | 5021 | 2521 | 54 |
1729009 | 1729009 | 2021-09-18 | Clay | Arkansas | 5021 | 2511 | 54 |
1725759 | 1725759 | 2021-09-17 | Clay | Arkansas | 5021 | 2506 | 54 |
1722510 | 1722510 | 2021-09-16 | Clay | Arkansas | 5021 | 2496 | 53 |
1719261 | 1719261 | 2021-09-15 | Clay | Arkansas | 5021 | 2481 | 53 |
1716013 | 1716013 | 2021-09-14 | Clay | Arkansas | 5021 | 2454 | 53 |
1712767 | 1712767 | 2021-09-13 | Clay | Arkansas | 5021 | 2447 | 53 |
1709520 | 1709520 | 2021-09-12 | Clay | Arkansas | 5021 | 2444 | 53 |
1706273 | 1706273 | 2021-09-11 | Clay | Arkansas | 5021 | 2429 | 53 |
1703025 | 1703025 | 2021-09-10 | Clay | Arkansas | 5021 | 2412 | 53 |
1699775 | 1699775 | 2021-09-09 | Clay | Arkansas | 5021 | 2395 | 52 |
1696526 | 1696526 | 2021-09-08 | Clay | Arkansas | 5021 | 2373 | 52 |
1693278 | 1693278 | 2021-09-07 | Clay | Arkansas | 5021 | 2360 | 52 |
1690029 | 1690029 | 2021-09-06 | Clay | Arkansas | 5021 | 2361 | 52 |
1686779 | 1686779 | 2021-09-05 | Clay | Arkansas | 5021 | 2352 | 52 |
1683529 | 1683529 | 2021-09-04 | Clay | Arkansas | 5021 | 2345 | 52 |
1680278 | 1680278 | 2021-09-03 | Clay | Arkansas | 5021 | 2323 | 52 |
1677030 | 1677030 | 2021-09-02 | Clay | Arkansas | 5021 | 2298 | 52 |
1673783 | 1673783 | 2021-09-01 | Clay | Arkansas | 5021 | 2278 | 52 |
1670535 | 1670535 | 2021-08-31 | Clay | Arkansas | 5021 | 2255 | 52 |
1667288 | 1667288 | 2021-08-30 | Clay | Arkansas | 5021 | 2237 | 52 |
1664041 | 1664041 | 2021-08-29 | Clay | Arkansas | 5021 | 2232 | 52 |
1660793 | 1660793 | 2021-08-28 | Clay | Arkansas | 5021 | 2226 | 52 |
1657545 | 1657545 | 2021-08-27 | Clay | Arkansas | 5021 | 2211 | 52 |
1654297 | 1654297 | 2021-08-26 | Clay | Arkansas | 5021 | 2196 | 52 |
1651050 | 1651050 | 2021-08-25 | Clay | Arkansas | 5021 | 2174 | 52 |
1647801 | 1647801 | 2021-08-24 | Clay | Arkansas | 5021 | 2162 | 52 |
1644553 | 1644553 | 2021-08-23 | Clay | Arkansas | 5021 | 2137 | 52 |
1641303 | 1641303 | 2021-08-22 | Clay | Arkansas | 5021 | 2129 | 52 |
1638053 | 1638053 | 2021-08-21 | Clay | Arkansas | 5021 | 2118 | 52 |
1634803 | 1634803 | 2021-08-20 | Clay | Arkansas | 5021 | 2108 | 52 |
1631554 | 1631554 | 2021-08-19 | Clay | Arkansas | 5021 | 2104 | 52 |
1628307 | 1628307 | 2021-08-18 | Clay | Arkansas | 5021 | 2090 | 52 |
1625060 | 1625060 | 2021-08-17 | Clay | Arkansas | 5021 | 2078 | 52 |
1621813 | 1621813 | 2021-08-16 | Clay | Arkansas | 5021 | 2071 | 52 |
1618566 | 1618566 | 2021-08-15 | Clay | Arkansas | 5021 | 2067 | 52 |
1615318 | 1615318 | 2021-08-14 | Clay | Arkansas | 5021 | 2062 | 52 |
1612069 | 1612069 | 2021-08-13 | Clay | Arkansas | 5021 | 2052 | 52 |
1608821 | 1608821 | 2021-08-12 | Clay | Arkansas | 5021 | 2034 | 52 |
1605572 | 1605572 | 2021-08-11 | Clay | Arkansas | 5021 | 2027 | 52 |
1602323 | 1602323 | 2021-08-10 | Clay | Arkansas | 5021 | 2017 | 52 |
1599074 | 1599074 | 2021-08-09 | Clay | Arkansas | 5021 | 2008 | 52 |
1595825 | 1595825 | 2021-08-08 | Clay | Arkansas | 5021 | 2003 | 52 |
1592576 | 1592576 | 2021-08-07 | Clay | Arkansas | 5021 | 1995 | 52 |
1589327 | 1589327 | 2021-08-06 | Clay | Arkansas | 5021 | 1983 | 52 |
1586078 | 1586078 | 2021-08-05 | Clay | Arkansas | 5021 | 1967 | 52 |
1582828 | 1582828 | 2021-08-04 | Clay | Arkansas | 5021 | 1956 | 52 |
1579578 | 1579578 | 2021-08-03 | Clay | Arkansas | 5021 | 1944 | 52 |
1576330 | 1576330 | 2021-08-02 | Clay | Arkansas | 5021 | 1931 | 52 |
1573082 | 1573082 | 2021-08-01 | Clay | Arkansas | 5021 | 1931 | 52 |
1569834 | 1569834 | 2021-07-31 | Clay | Arkansas | 5021 | 1929 | 52 |
1566586 | 1566586 | 2021-07-30 | Clay | Arkansas | 5021 | 1925 | 52 |
1563338 | 1563338 | 2021-07-29 | Clay | Arkansas | 5021 | 1921 | 52 |
1560090 | 1560090 | 2021-07-28 | Clay | Arkansas | 5021 | 1914 | 52 |
1556843 | 1556843 | 2021-07-27 | Clay | Arkansas | 5021 | 1903 | 52 |
1553596 | 1553596 | 2021-07-26 | Clay | Arkansas | 5021 | 1901 | 52 |
1550349 | 1550349 | 2021-07-25 | Clay | Arkansas | 5021 | 1901 | 52 |
1547102 | 1547102 | 2021-07-24 | Clay | Arkansas | 5021 | 1894 | 52 |
1543855 | 1543855 | 2021-07-23 | Clay | Arkansas | 5021 | 1890 | 52 |
1540607 | 1540607 | 2021-07-22 | Clay | Arkansas | 5021 | 1885 | 52 |
1537360 | 1537360 | 2021-07-21 | Clay | Arkansas | 5021 | 1875 | 52 |
1534112 | 1534112 | 2021-07-20 | Clay | Arkansas | 5021 | 1870 | 52 |
1530865 | 1530865 | 2021-07-19 | Clay | Arkansas | 5021 | 1864 | 52 |
1527618 | 1527618 | 2021-07-18 | Clay | Arkansas | 5021 | 1849 | 52 |
1524371 | 1524371 | 2021-07-17 | Clay | Arkansas | 5021 | 1849 | 52 |
1521123 | 1521123 | 2021-07-16 | Clay | Arkansas | 5021 | 1849 | 52 |
1517875 | 1517875 | 2021-07-15 | Clay | Arkansas | 5021 | 1831 | 52 |
1514628 | 1514628 | 2021-07-14 | Clay | Arkansas | 5021 | 1824 | 52 |
1511382 | 1511382 | 2021-07-13 | Clay | Arkansas | 5021 | 1821 | 52 |
1508135 | 1508135 | 2021-07-12 | Clay | Arkansas | 5021 | 1819 | 52 |
1504889 | 1504889 | 2021-07-11 | Clay | Arkansas | 5021 | 1815 | 52 |
1501643 | 1501643 | 2021-07-10 | Clay | Arkansas | 5021 | 1815 | 52 |
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);