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 |
---|---|---|---|---|---|---|---|
1946741 | 1946741 | 2021-11-24 | Jefferson | Arkansas | 5069 | 12443 | 228 |
1943490 | 1943490 | 2021-11-23 | Jefferson | Arkansas | 5069 | 12435 | 227 |
1940240 | 1940240 | 2021-11-22 | Jefferson | Arkansas | 5069 | 12429 | 227 |
1936990 | 1936990 | 2021-11-21 | Jefferson | Arkansas | 5069 | 12426 | 227 |
1933740 | 1933740 | 2021-11-20 | Jefferson | Arkansas | 5069 | 12423 | 227 |
1930488 | 1930488 | 2021-11-19 | Jefferson | Arkansas | 5069 | 12418 | 227 |
1927238 | 1927238 | 2021-11-18 | Jefferson | Arkansas | 5069 | 12416 | 227 |
1923988 | 1923988 | 2021-11-17 | Jefferson | Arkansas | 5069 | 12408 | 226 |
1920739 | 1920739 | 2021-11-16 | Jefferson | Arkansas | 5069 | 12399 | 226 |
1917489 | 1917489 | 2021-11-15 | Jefferson | Arkansas | 5069 | 12397 | 227 |
1914239 | 1914239 | 2021-11-14 | Jefferson | Arkansas | 5069 | 12397 | 227 |
1910989 | 1910989 | 2021-11-13 | Jefferson | Arkansas | 5069 | 12397 | 227 |
1907740 | 1907740 | 2021-11-12 | Jefferson | Arkansas | 5069 | 12393 | 227 |
1904491 | 1904491 | 2021-11-11 | Jefferson | Arkansas | 5069 | 12387 | 227 |
1901241 | 1901241 | 2021-11-10 | Jefferson | Arkansas | 5069 | 12383 | 228 |
1897991 | 1897991 | 2021-11-09 | Jefferson | Arkansas | 5069 | 12379 | 228 |
1894741 | 1894741 | 2021-11-08 | Jefferson | Arkansas | 5069 | 12370 | 228 |
1891491 | 1891491 | 2021-11-07 | Jefferson | Arkansas | 5069 | 12369 | 228 |
1888241 | 1888241 | 2021-11-06 | Jefferson | Arkansas | 5069 | 12369 | 228 |
1884991 | 1884991 | 2021-11-05 | Jefferson | Arkansas | 5069 | 12364 | 228 |
1881742 | 1881742 | 2021-11-04 | Jefferson | Arkansas | 5069 | 12358 | 228 |
1878493 | 1878493 | 2021-11-03 | Jefferson | Arkansas | 5069 | 12355 | 228 |
1875244 | 1875244 | 2021-11-02 | Jefferson | Arkansas | 5069 | 12352 | 228 |
1871995 | 1871995 | 2021-11-01 | Jefferson | Arkansas | 5069 | 12339 | 228 |
1868746 | 1868746 | 2021-10-31 | Jefferson | Arkansas | 5069 | 12336 | 228 |
1865497 | 1865497 | 2021-10-30 | Jefferson | Arkansas | 5069 | 12336 | 228 |
1862248 | 1862248 | 2021-10-29 | Jefferson | Arkansas | 5069 | 12333 | 228 |
1858999 | 1858999 | 2021-10-28 | Jefferson | Arkansas | 5069 | 12329 | 227 |
1855750 | 1855750 | 2021-10-27 | Jefferson | Arkansas | 5069 | 12320 | 226 |
1852501 | 1852501 | 2021-10-26 | Jefferson | Arkansas | 5069 | 12314 | 226 |
1849252 | 1849252 | 2021-10-25 | Jefferson | Arkansas | 5069 | 12309 | 226 |
1846002 | 1846002 | 2021-10-24 | Jefferson | Arkansas | 5069 | 12308 | 226 |
1842752 | 1842752 | 2021-10-23 | Jefferson | Arkansas | 5069 | 12307 | 226 |
1839502 | 1839502 | 2021-10-22 | Jefferson | Arkansas | 5069 | 12303 | 226 |
1836253 | 1836253 | 2021-10-21 | Jefferson | Arkansas | 5069 | 12293 | 226 |
1833004 | 1833004 | 2021-10-20 | Jefferson | Arkansas | 5069 | 12291 | 227 |
1829755 | 1829755 | 2021-10-19 | Jefferson | Arkansas | 5069 | 12287 | 227 |
1826506 | 1826506 | 2021-10-18 | Jefferson | Arkansas | 5069 | 12283 | 227 |
1823257 | 1823257 | 2021-10-17 | Jefferson | Arkansas | 5069 | 12283 | 227 |
1820008 | 1820008 | 2021-10-16 | Jefferson | Arkansas | 5069 | 12281 | 227 |
1816759 | 1816759 | 2021-10-15 | Jefferson | Arkansas | 5069 | 12276 | 227 |
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 |
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);