ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 5109 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1813531 | 1813531 | 2021-10-14 | Pike | Arkansas | 5109 | 1680 | 35 |
1810282 | 1810282 | 2021-10-13 | Pike | Arkansas | 5109 | 1676 | 35 |
1807033 | 1807033 | 2021-10-12 | Pike | Arkansas | 5109 | 1675 | 35 |
1803782 | 1803782 | 2021-10-11 | Pike | Arkansas | 5109 | 1670 | 35 |
1800533 | 1800533 | 2021-10-10 | Pike | Arkansas | 5109 | 1670 | 35 |
1797284 | 1797284 | 2021-10-09 | Pike | Arkansas | 5109 | 1669 | 35 |
1794035 | 1794035 | 2021-10-08 | Pike | Arkansas | 5109 | 1662 | 35 |
1790787 | 1790787 | 2021-10-07 | Pike | Arkansas | 5109 | 1660 | 35 |
1787538 | 1787538 | 2021-10-06 | Pike | Arkansas | 5109 | 1656 | 35 |
1784289 | 1784289 | 2021-10-05 | Pike | Arkansas | 5109 | 1652 | 35 |
1781040 | 1781040 | 2021-10-04 | Pike | Arkansas | 5109 | 1648 | 35 |
1777790 | 1777790 | 2021-10-03 | Pike | Arkansas | 5109 | 1646 | 35 |
1774540 | 1774540 | 2021-10-02 | Pike | Arkansas | 5109 | 1645 | 35 |
1771290 | 1771290 | 2021-10-01 | Pike | Arkansas | 5109 | 1644 | 35 |
1768041 | 1768041 | 2021-09-30 | Pike | Arkansas | 5109 | 1643 | 35 |
1764792 | 1764792 | 2021-09-29 | Pike | Arkansas | 5109 | 1642 | 35 |
1761543 | 1761543 | 2021-09-28 | Pike | Arkansas | 5109 | 1642 | 35 |
1758295 | 1758295 | 2021-09-27 | Pike | Arkansas | 5109 | 1633 | 34 |
1755047 | 1755047 | 2021-09-26 | Pike | Arkansas | 5109 | 1633 | 34 |
1751799 | 1751799 | 2021-09-25 | Pike | Arkansas | 5109 | 1633 | 34 |
1748550 | 1748550 | 2021-09-24 | Pike | Arkansas | 5109 | 1631 | 34 |
1745300 | 1745300 | 2021-09-23 | Pike | Arkansas | 5109 | 1627 | 34 |
1742051 | 1742051 | 2021-09-22 | Pike | Arkansas | 5109 | 1623 | 34 |
1738802 | 1738802 | 2021-09-21 | Pike | Arkansas | 5109 | 1618 | 34 |
1735553 | 1735553 | 2021-09-20 | Pike | Arkansas | 5109 | 1613 | 34 |
1732303 | 1732303 | 2021-09-19 | Pike | Arkansas | 5109 | 1614 | 34 |
1729053 | 1729053 | 2021-09-18 | Pike | Arkansas | 5109 | 1613 | 34 |
1725803 | 1725803 | 2021-09-17 | Pike | Arkansas | 5109 | 1608 | 33 |
1722554 | 1722554 | 2021-09-16 | Pike | Arkansas | 5109 | 1601 | 33 |
1719305 | 1719305 | 2021-09-15 | Pike | Arkansas | 5109 | 1590 | 33 |
1716057 | 1716057 | 2021-09-14 | Pike | Arkansas | 5109 | 1579 | 32 |
1712811 | 1712811 | 2021-09-13 | Pike | Arkansas | 5109 | 1561 | 32 |
1709564 | 1709564 | 2021-09-12 | Pike | Arkansas | 5109 | 1561 | 32 |
1706317 | 1706317 | 2021-09-11 | Pike | Arkansas | 5109 | 1558 | 32 |
1703069 | 1703069 | 2021-09-10 | Pike | Arkansas | 5109 | 1546 | 32 |
1699819 | 1699819 | 2021-09-09 | Pike | Arkansas | 5109 | 1541 | 32 |
1696570 | 1696570 | 2021-09-08 | Pike | Arkansas | 5109 | 1520 | 32 |
1693322 | 1693322 | 2021-09-07 | Pike | Arkansas | 5109 | 1497 | 32 |
1690073 | 1690073 | 2021-09-06 | Pike | Arkansas | 5109 | 1491 | 30 |
1686823 | 1686823 | 2021-09-05 | Pike | Arkansas | 5109 | 1488 | 30 |
1683573 | 1683573 | 2021-09-04 | Pike | Arkansas | 5109 | 1478 | 30 |
1680322 | 1680322 | 2021-09-03 | Pike | Arkansas | 5109 | 1463 | 30 |
1677074 | 1677074 | 2021-09-02 | Pike | Arkansas | 5109 | 1455 | 29 |
1673827 | 1673827 | 2021-09-01 | Pike | Arkansas | 5109 | 1434 | 29 |
1670579 | 1670579 | 2021-08-31 | Pike | Arkansas | 5109 | 1412 | 29 |
1667332 | 1667332 | 2021-08-30 | Pike | Arkansas | 5109 | 1398 | 29 |
1664085 | 1664085 | 2021-08-29 | Pike | Arkansas | 5109 | 1394 | 29 |
1660837 | 1660837 | 2021-08-28 | Pike | Arkansas | 5109 | 1393 | 29 |
1657589 | 1657589 | 2021-08-27 | Pike | Arkansas | 5109 | 1381 | 28 |
1654341 | 1654341 | 2021-08-26 | Pike | Arkansas | 5109 | 1368 | 28 |
1651094 | 1651094 | 2021-08-25 | Pike | Arkansas | 5109 | 1343 | 28 |
1647845 | 1647845 | 2021-08-24 | Pike | Arkansas | 5109 | 1338 | 27 |
1644597 | 1644597 | 2021-08-23 | Pike | Arkansas | 5109 | 1316 | 27 |
1641347 | 1641347 | 2021-08-22 | Pike | Arkansas | 5109 | 1315 | 27 |
1638097 | 1638097 | 2021-08-21 | Pike | Arkansas | 5109 | 1311 | 27 |
1634847 | 1634847 | 2021-08-20 | Pike | Arkansas | 5109 | 1303 | 27 |
1631598 | 1631598 | 2021-08-19 | Pike | Arkansas | 5109 | 1287 | 27 |
1628351 | 1628351 | 2021-08-18 | Pike | Arkansas | 5109 | 1269 | 27 |
1625104 | 1625104 | 2021-08-17 | Pike | Arkansas | 5109 | 1265 | 26 |
1621857 | 1621857 | 2021-08-16 | Pike | Arkansas | 5109 | 1262 | 25 |
1618610 | 1618610 | 2021-08-15 | Pike | Arkansas | 5109 | 1260 | 25 |
1615362 | 1615362 | 2021-08-14 | Pike | Arkansas | 5109 | 1258 | 24 |
1612113 | 1612113 | 2021-08-13 | Pike | Arkansas | 5109 | 1252 | 24 |
1608865 | 1608865 | 2021-08-12 | Pike | Arkansas | 5109 | 1236 | 24 |
1605616 | 1605616 | 2021-08-11 | Pike | Arkansas | 5109 | 1229 | 24 |
1602367 | 1602367 | 2021-08-10 | Pike | Arkansas | 5109 | 1218 | 24 |
1599118 | 1599118 | 2021-08-09 | Pike | Arkansas | 5109 | 1216 | 24 |
1595869 | 1595869 | 2021-08-08 | Pike | Arkansas | 5109 | 1216 | 24 |
1592620 | 1592620 | 2021-08-07 | Pike | Arkansas | 5109 | 1214 | 24 |
1589371 | 1589371 | 2021-08-06 | Pike | Arkansas | 5109 | 1204 | 24 |
1586122 | 1586122 | 2021-08-05 | Pike | Arkansas | 5109 | 1192 | 23 |
1582872 | 1582872 | 2021-08-04 | Pike | Arkansas | 5109 | 1189 | 23 |
1579622 | 1579622 | 2021-08-03 | Pike | Arkansas | 5109 | 1182 | 23 |
1576374 | 1576374 | 2021-08-02 | Pike | Arkansas | 5109 | 1168 | 23 |
1573126 | 1573126 | 2021-08-01 | Pike | Arkansas | 5109 | 1165 | 23 |
1569878 | 1569878 | 2021-07-31 | Pike | Arkansas | 5109 | 1161 | 23 |
1566630 | 1566630 | 2021-07-30 | Pike | Arkansas | 5109 | 1156 | 23 |
1563382 | 1563382 | 2021-07-29 | Pike | Arkansas | 5109 | 1149 | 23 |
1560134 | 1560134 | 2021-07-28 | Pike | Arkansas | 5109 | 1138 | 23 |
1556887 | 1556887 | 2021-07-27 | Pike | Arkansas | 5109 | 1131 | 23 |
1553640 | 1553640 | 2021-07-26 | Pike | Arkansas | 5109 | 1126 | 23 |
1550393 | 1550393 | 2021-07-25 | Pike | Arkansas | 5109 | 1118 | 23 |
1547146 | 1547146 | 2021-07-24 | Pike | Arkansas | 5109 | 1117 | 23 |
1543899 | 1543899 | 2021-07-23 | Pike | Arkansas | 5109 | 1099 | 23 |
1540651 | 1540651 | 2021-07-22 | Pike | Arkansas | 5109 | 1090 | 23 |
1537404 | 1537404 | 2021-07-21 | Pike | Arkansas | 5109 | 1085 | 23 |
1534156 | 1534156 | 2021-07-20 | Pike | Arkansas | 5109 | 1082 | 23 |
1530909 | 1530909 | 2021-07-19 | Pike | Arkansas | 5109 | 1080 | 23 |
1527662 | 1527662 | 2021-07-18 | Pike | Arkansas | 5109 | 1071 | 23 |
1524415 | 1524415 | 2021-07-17 | Pike | Arkansas | 5109 | 1071 | 23 |
1521167 | 1521167 | 2021-07-16 | Pike | Arkansas | 5109 | 1071 | 23 |
1517919 | 1517919 | 2021-07-15 | Pike | Arkansas | 5109 | 1069 | 23 |
1514672 | 1514672 | 2021-07-14 | Pike | Arkansas | 5109 | 1068 | 23 |
1511426 | 1511426 | 2021-07-13 | Pike | Arkansas | 5109 | 1065 | 23 |
1508179 | 1508179 | 2021-07-12 | Pike | Arkansas | 5109 | 1062 | 23 |
1504933 | 1504933 | 2021-07-11 | Pike | Arkansas | 5109 | 1058 | 23 |
1501687 | 1501687 | 2021-07-10 | Pike | Arkansas | 5109 | 1058 | 23 |
1498441 | 1498441 | 2021-07-09 | Pike | Arkansas | 5109 | 1058 | 23 |
1495194 | 1495194 | 2021-07-08 | Pike | Arkansas | 5109 | 1054 | 23 |
1491947 | 1491947 | 2021-07-07 | Pike | Arkansas | 5109 | 1054 | 23 |
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);