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 |
---|---|---|---|---|---|---|---|
2174340 | 2174340 | 2022-02-02 | Jefferson | Arkansas | 5069 | 17992 | 247 |
2171087 | 2171087 | 2022-02-01 | Jefferson | Arkansas | 5069 | 17933 | 246 |
2167834 | 2167834 | 2022-01-31 | Jefferson | Arkansas | 5069 | 17840 | 246 |
2164579 | 2164579 | 2022-01-30 | Jefferson | Arkansas | 5069 | 17726 | 246 |
2161324 | 2161324 | 2022-01-29 | Jefferson | Arkansas | 5069 | 17726 | 246 |
2158068 | 2158068 | 2022-01-28 | Jefferson | Arkansas | 5069 | 17726 | 246 |
2154815 | 2154815 | 2022-01-27 | Jefferson | Arkansas | 5069 | 17634 | 246 |
2151562 | 2151562 | 2022-01-26 | Jefferson | Arkansas | 5069 | 17512 | 246 |
2148310 | 2148310 | 2022-01-25 | Jefferson | Arkansas | 5069 | 17367 | 246 |
2145058 | 2145058 | 2022-01-24 | Jefferson | Arkansas | 5069 | 17230 | 244 |
2141803 | 2141803 | 2022-01-23 | Jefferson | Arkansas | 5069 | 17170 | 244 |
2138548 | 2138548 | 2022-01-22 | Jefferson | Arkansas | 5069 | 17087 | 244 |
2135292 | 2135292 | 2022-01-21 | Jefferson | Arkansas | 5069 | 16879 | 244 |
2132040 | 2132040 | 2022-01-20 | Jefferson | Arkansas | 5069 | 16664 | 242 |
2128787 | 2128787 | 2022-01-19 | Jefferson | Arkansas | 5069 | 16401 | 242 |
2125533 | 2125533 | 2022-01-18 | Jefferson | Arkansas | 5069 | 16051 | 242 |
2122281 | 2122281 | 2022-01-17 | Jefferson | Arkansas | 5069 | 15977 | 242 |
2119029 | 2119029 | 2022-01-16 | Jefferson | Arkansas | 5069 | 15915 | 242 |
2115777 | 2115777 | 2022-01-15 | Jefferson | Arkansas | 5069 | 15789 | 242 |
2112526 | 2112526 | 2022-01-14 | Jefferson | Arkansas | 5069 | 15505 | 240 |
2109274 | 2109274 | 2022-01-13 | Jefferson | Arkansas | 5069 | 15284 | 240 |
2106023 | 2106023 | 2022-01-12 | Jefferson | Arkansas | 5069 | 14924 | 240 |
2102772 | 2102772 | 2022-01-11 | Jefferson | Arkansas | 5069 | 14614 | 240 |
2099521 | 2099521 | 2022-01-10 | Jefferson | Arkansas | 5069 | 14414 | 239 |
2096270 | 2096270 | 2022-01-09 | Jefferson | Arkansas | 5069 | 14204 | 238 |
2093018 | 2093018 | 2022-01-08 | Jefferson | Arkansas | 5069 | 14204 | 238 |
2089766 | 2089766 | 2022-01-07 | Jefferson | Arkansas | 5069 | 13974 | 238 |
2086515 | 2086515 | 2022-01-06 | Jefferson | Arkansas | 5069 | 13821 | 238 |
2083263 | 2083263 | 2022-01-05 | Jefferson | Arkansas | 5069 | 13655 | 238 |
2080011 | 2080011 | 2022-01-04 | Jefferson | Arkansas | 5069 | 13414 | 238 |
2076759 | 2076759 | 2022-01-03 | Jefferson | Arkansas | 5069 | 13245 | 237 |
2073508 | 2073508 | 2022-01-02 | Jefferson | Arkansas | 5069 | 13226 | 235 |
2070257 | 2070257 | 2022-01-01 | Jefferson | Arkansas | 5069 | 13153 | 235 |
2067006 | 2067006 | 2021-12-31 | Jefferson | Arkansas | 5069 | 13031 | 235 |
2063755 | 2063755 | 2021-12-30 | Jefferson | Arkansas | 5069 | 12938 | 235 |
2060505 | 2060505 | 2021-12-29 | Jefferson | Arkansas | 5069 | 12846 | 235 |
2057256 | 2057256 | 2021-12-28 | Jefferson | Arkansas | 5069 | 12761 | 235 |
2054007 | 2054007 | 2021-12-27 | Jefferson | Arkansas | 5069 | 12709 | 235 |
2050757 | 2050757 | 2021-12-26 | Jefferson | Arkansas | 5069 | 12702 | 234 |
2047507 | 2047507 | 2021-12-25 | Jefferson | Arkansas | 5069 | 12698 | 234 |
2044257 | 2044257 | 2021-12-24 | Jefferson | Arkansas | 5069 | 12689 | 234 |
2041008 | 2041008 | 2021-12-23 | Jefferson | Arkansas | 5069 | 12643 | 234 |
2037758 | 2037758 | 2021-12-22 | Jefferson | Arkansas | 5069 | 12631 | 234 |
2034508 | 2034508 | 2021-12-21 | Jefferson | Arkansas | 5069 | 12622 | 234 |
2031258 | 2031258 | 2021-12-20 | Jefferson | Arkansas | 5069 | 12611 | 234 |
2028007 | 2028007 | 2021-12-19 | Jefferson | Arkansas | 5069 | 12607 | 234 |
2024756 | 2024756 | 2021-12-18 | Jefferson | Arkansas | 5069 | 12601 | 234 |
2021505 | 2021505 | 2021-12-17 | Jefferson | Arkansas | 5069 | 12595 | 234 |
2018254 | 2018254 | 2021-12-16 | Jefferson | Arkansas | 5069 | 12577 | 234 |
2015004 | 2015004 | 2021-12-15 | Jefferson | Arkansas | 5069 | 12570 | 234 |
2011753 | 2011753 | 2021-12-14 | Jefferson | Arkansas | 5069 | 12561 | 234 |
2008502 | 2008502 | 2021-12-13 | Jefferson | Arkansas | 5069 | 12554 | 234 |
2005251 | 2005251 | 2021-12-12 | Jefferson | Arkansas | 5069 | 12552 | 234 |
2002000 | 2002000 | 2021-12-11 | Jefferson | Arkansas | 5069 | 12550 | 233 |
1998750 | 1998750 | 2021-12-10 | Jefferson | Arkansas | 5069 | 12545 | 233 |
1995499 | 1995499 | 2021-12-09 | Jefferson | Arkansas | 5069 | 12528 | 233 |
1992248 | 1992248 | 2021-12-08 | Jefferson | Arkansas | 5069 | 12522 | 232 |
1988997 | 1988997 | 2021-12-07 | Jefferson | Arkansas | 5069 | 12511 | 231 |
1985747 | 1985747 | 2021-12-06 | Jefferson | Arkansas | 5069 | 12500 | 229 |
1982497 | 1982497 | 2021-12-05 | Jefferson | Arkansas | 5069 | 12499 | 229 |
1979247 | 1979247 | 2021-12-04 | Jefferson | Arkansas | 5069 | 12496 | 229 |
1975997 | 1975997 | 2021-12-03 | Jefferson | Arkansas | 5069 | 12489 | 229 |
1972748 | 1972748 | 2021-12-02 | Jefferson | Arkansas | 5069 | 12482 | 229 |
1969498 | 1969498 | 2021-12-01 | Jefferson | Arkansas | 5069 | 12472 | 229 |
1966248 | 1966248 | 2021-11-30 | Jefferson | Arkansas | 5069 | 12469 | 228 |
1962996 | 1962996 | 2021-11-29 | Jefferson | Arkansas | 5069 | 12453 | 228 |
1959745 | 1959745 | 2021-11-28 | Jefferson | Arkansas | 5069 | 12449 | 228 |
1956494 | 1956494 | 2021-11-27 | Jefferson | Arkansas | 5069 | 12448 | 228 |
1953243 | 1953243 | 2021-11-26 | Jefferson | Arkansas | 5069 | 12447 | 228 |
1949992 | 1949992 | 2021-11-25 | Jefferson | Arkansas | 5069 | 12447 | 228 |
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 |
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);