ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Jefferson" and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1813511 | 1813511 | 2021-10-14 | Jefferson | Arkansas | 5069 | 12266 | 227 |
1810262 | 1810262 | 2021-10-13 | Jefferson | Arkansas | 5069 | 12256 | 228 |
1807013 | 1807013 | 2021-10-12 | Jefferson | Arkansas | 5069 | 12252 | 227 |
1803762 | 1803762 | 2021-10-11 | Jefferson | Arkansas | 5069 | 12250 | 227 |
1800513 | 1800513 | 2021-10-10 | Jefferson | Arkansas | 5069 | 12250 | 227 |
1797264 | 1797264 | 2021-10-09 | Jefferson | Arkansas | 5069 | 12248 | 225 |
1794015 | 1794015 | 2021-10-08 | Jefferson | Arkansas | 5069 | 12245 | 225 |
1790767 | 1790767 | 2021-10-07 | Jefferson | Arkansas | 5069 | 12236 | 225 |
1787518 | 1787518 | 2021-10-06 | Jefferson | Arkansas | 5069 | 12231 | 225 |
1784269 | 1784269 | 2021-10-05 | Jefferson | Arkansas | 5069 | 12227 | 225 |
1781020 | 1781020 | 2021-10-04 | Jefferson | Arkansas | 5069 | 12222 | 225 |
1777770 | 1777770 | 2021-10-03 | Jefferson | Arkansas | 5069 | 12221 | 225 |
1774520 | 1774520 | 2021-10-02 | Jefferson | Arkansas | 5069 | 12217 | 225 |
1771270 | 1771270 | 2021-10-01 | Jefferson | Arkansas | 5069 | 12207 | 224 |
1768021 | 1768021 | 2021-09-30 | Jefferson | Arkansas | 5069 | 12193 | 224 |
1764772 | 1764772 | 2021-09-29 | Jefferson | Arkansas | 5069 | 12187 | 224 |
1761523 | 1761523 | 2021-09-28 | Jefferson | Arkansas | 5069 | 12165 | 224 |
1758275 | 1758275 | 2021-09-27 | Jefferson | Arkansas | 5069 | 12155 | 224 |
1755027 | 1755027 | 2021-09-26 | Jefferson | Arkansas | 5069 | 12152 | 223 |
1751779 | 1751779 | 2021-09-25 | Jefferson | Arkansas | 5069 | 12150 | 223 |
1748530 | 1748530 | 2021-09-24 | Jefferson | Arkansas | 5069 | 12131 | 223 |
1745280 | 1745280 | 2021-09-23 | Jefferson | Arkansas | 5069 | 12125 | 223 |
1742031 | 1742031 | 2021-09-22 | Jefferson | Arkansas | 5069 | 12112 | 221 |
1738782 | 1738782 | 2021-09-21 | Jefferson | Arkansas | 5069 | 12093 | 221 |
1735533 | 1735533 | 2021-09-20 | Jefferson | Arkansas | 5069 | 12074 | 221 |
1732283 | 1732283 | 2021-09-19 | Jefferson | Arkansas | 5069 | 12062 | 221 |
1729033 | 1729033 | 2021-09-18 | Jefferson | Arkansas | 5069 | 12052 | 221 |
1725783 | 1725783 | 2021-09-17 | Jefferson | Arkansas | 5069 | 12040 | 220 |
1722534 | 1722534 | 2021-09-16 | Jefferson | Arkansas | 5069 | 12025 | 220 |
1719285 | 1719285 | 2021-09-15 | Jefferson | Arkansas | 5069 | 11999 | 219 |
1716037 | 1716037 | 2021-09-14 | Jefferson | Arkansas | 5069 | 11972 | 217 |
1712791 | 1712791 | 2021-09-13 | Jefferson | Arkansas | 5069 | 11965 | 216 |
1709544 | 1709544 | 2021-09-12 | Jefferson | Arkansas | 5069 | 11950 | 213 |
1706297 | 1706297 | 2021-09-11 | Jefferson | Arkansas | 5069 | 11943 | 212 |
1703049 | 1703049 | 2021-09-10 | Jefferson | Arkansas | 5069 | 11925 | 212 |
1699799 | 1699799 | 2021-09-09 | Jefferson | Arkansas | 5069 | 11886 | 211 |
1696550 | 1696550 | 2021-09-08 | Jefferson | Arkansas | 5069 | 11864 | 210 |
1693302 | 1693302 | 2021-09-07 | Jefferson | Arkansas | 5069 | 11837 | 208 |
1690053 | 1690053 | 2021-09-06 | Jefferson | Arkansas | 5069 | 11828 | 208 |
1686803 | 1686803 | 2021-09-05 | Jefferson | Arkansas | 5069 | 11804 | 205 |
1683553 | 1683553 | 2021-09-04 | Jefferson | Arkansas | 5069 | 11788 | 204 |
1680302 | 1680302 | 2021-09-03 | Jefferson | Arkansas | 5069 | 11759 | 204 |
1677054 | 1677054 | 2021-09-02 | Jefferson | Arkansas | 5069 | 11741 | 204 |
1673807 | 1673807 | 2021-09-01 | Jefferson | Arkansas | 5069 | 11687 | 204 |
1670559 | 1670559 | 2021-08-31 | Jefferson | Arkansas | 5069 | 11652 | 203 |
1667312 | 1667312 | 2021-08-30 | Jefferson | Arkansas | 5069 | 11614 | 203 |
1664065 | 1664065 | 2021-08-29 | Jefferson | Arkansas | 5069 | 11594 | 202 |
1660817 | 1660817 | 2021-08-28 | Jefferson | Arkansas | 5069 | 11584 | 202 |
1657569 | 1657569 | 2021-08-27 | Jefferson | Arkansas | 5069 | 11546 | 201 |
1654321 | 1654321 | 2021-08-26 | Jefferson | Arkansas | 5069 | 11495 | 201 |
1651074 | 1651074 | 2021-08-25 | Jefferson | Arkansas | 5069 | 11457 | 200 |
1647825 | 1647825 | 2021-08-24 | Jefferson | Arkansas | 5069 | 11394 | 200 |
1644577 | 1644577 | 2021-08-23 | Jefferson | Arkansas | 5069 | 11363 | 199 |
1641327 | 1641327 | 2021-08-22 | Jefferson | Arkansas | 5069 | 11344 | 199 |
1638077 | 1638077 | 2021-08-21 | Jefferson | Arkansas | 5069 | 11322 | 199 |
1634827 | 1634827 | 2021-08-20 | Jefferson | Arkansas | 5069 | 11274 | 199 |
1631578 | 1631578 | 2021-08-19 | Jefferson | Arkansas | 5069 | 11231 | 199 |
1628331 | 1628331 | 2021-08-18 | Jefferson | Arkansas | 5069 | 11179 | 199 |
1625084 | 1625084 | 2021-08-17 | Jefferson | Arkansas | 5069 | 11116 | 197 |
1621837 | 1621837 | 2021-08-16 | Jefferson | Arkansas | 5069 | 11062 | 194 |
1618590 | 1618590 | 2021-08-15 | Jefferson | Arkansas | 5069 | 11048 | 193 |
1615342 | 1615342 | 2021-08-14 | Jefferson | Arkansas | 5069 | 10993 | 193 |
1612093 | 1612093 | 2021-08-13 | Jefferson | Arkansas | 5069 | 10955 | 193 |
1608845 | 1608845 | 2021-08-12 | Jefferson | Arkansas | 5069 | 10903 | 193 |
1605596 | 1605596 | 2021-08-11 | Jefferson | Arkansas | 5069 | 10847 | 192 |
1602347 | 1602347 | 2021-08-10 | Jefferson | Arkansas | 5069 | 10807 | 192 |
1599098 | 1599098 | 2021-08-09 | Jefferson | Arkansas | 5069 | 10728 | 192 |
1595849 | 1595849 | 2021-08-08 | Jefferson | Arkansas | 5069 | 10706 | 190 |
1592600 | 1592600 | 2021-08-07 | Jefferson | Arkansas | 5069 | 10692 | 190 |
1589351 | 1589351 | 2021-08-06 | Jefferson | Arkansas | 5069 | 10638 | 190 |
1586102 | 1586102 | 2021-08-05 | Jefferson | Arkansas | 5069 | 10547 | 189 |
1582852 | 1582852 | 2021-08-04 | Jefferson | Arkansas | 5069 | 10449 | 189 |
1579602 | 1579602 | 2021-08-03 | Jefferson | Arkansas | 5069 | 10399 | 189 |
1576354 | 1576354 | 2021-08-02 | Jefferson | Arkansas | 5069 | 10344 | 187 |
1573106 | 1573106 | 2021-08-01 | Jefferson | Arkansas | 5069 | 10312 | 184 |
1569858 | 1569858 | 2021-07-31 | Jefferson | Arkansas | 5069 | 10276 | 184 |
1566610 | 1566610 | 2021-07-30 | Jefferson | Arkansas | 5069 | 10250 | 179 |
1563362 | 1563362 | 2021-07-29 | Jefferson | Arkansas | 5069 | 10190 | 179 |
1560114 | 1560114 | 2021-07-28 | Jefferson | Arkansas | 5069 | 10120 | 178 |
1556867 | 1556867 | 2021-07-27 | Jefferson | Arkansas | 5069 | 10094 | 178 |
1553620 | 1553620 | 2021-07-26 | Jefferson | Arkansas | 5069 | 10020 | 178 |
1550373 | 1550373 | 2021-07-25 | Jefferson | Arkansas | 5069 | 10005 | 177 |
1547126 | 1547126 | 2021-07-24 | Jefferson | Arkansas | 5069 | 9986 | 175 |
1543879 | 1543879 | 2021-07-23 | Jefferson | Arkansas | 5069 | 9924 | 175 |
1540631 | 1540631 | 2021-07-22 | Jefferson | Arkansas | 5069 | 9874 | 175 |
1537384 | 1537384 | 2021-07-21 | Jefferson | Arkansas | 5069 | 9820 | 175 |
1534136 | 1534136 | 2021-07-20 | Jefferson | Arkansas | 5069 | 9779 | 175 |
1530889 | 1530889 | 2021-07-19 | Jefferson | Arkansas | 5069 | 9713 | 175 |
1527642 | 1527642 | 2021-07-18 | Jefferson | Arkansas | 5069 | 9632 | 175 |
1524395 | 1524395 | 2021-07-17 | Jefferson | Arkansas | 5069 | 9632 | 175 |
1521147 | 1521147 | 2021-07-16 | Jefferson | Arkansas | 5069 | 9632 | 175 |
1517899 | 1517899 | 2021-07-15 | Jefferson | Arkansas | 5069 | 9593 | 173 |
1514652 | 1514652 | 2021-07-14 | Jefferson | Arkansas | 5069 | 9561 | 173 |
1511406 | 1511406 | 2021-07-13 | Jefferson | Arkansas | 5069 | 9531 | 173 |
1508159 | 1508159 | 2021-07-12 | Jefferson | Arkansas | 5069 | 9489 | 172 |
1504913 | 1504913 | 2021-07-11 | Jefferson | Arkansas | 5069 | 9392 | 172 |
1501667 | 1501667 | 2021-07-10 | Jefferson | Arkansas | 5069 | 9392 | 172 |
1498421 | 1498421 | 2021-07-09 | Jefferson | Arkansas | 5069 | 9392 | 172 |
1495174 | 1495174 | 2021-07-08 | Jefferson | Arkansas | 5069 | 9370 | 172 |
1491927 | 1491927 | 2021-07-07 | Jefferson | Arkansas | 5069 | 9335 | 171 |
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);