ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 5143 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174378 | 2174378 | 2022-02-02 | Washington | Arkansas | 5143 | 64630 | 537 |
2171125 | 2171125 | 2022-02-01 | Washington | Arkansas | 5143 | 64320 | 537 |
2167872 | 2167872 | 2022-01-31 | Washington | Arkansas | 5143 | 64034 | 535 |
2164617 | 2164617 | 2022-01-30 | Washington | Arkansas | 5143 | 63296 | 535 |
2161362 | 2161362 | 2022-01-29 | Washington | Arkansas | 5143 | 63296 | 535 |
2158106 | 2158106 | 2022-01-28 | Washington | Arkansas | 5143 | 63296 | 535 |
2154853 | 2154853 | 2022-01-27 | Washington | Arkansas | 5143 | 62926 | 535 |
2151600 | 2151600 | 2022-01-26 | Washington | Arkansas | 5143 | 62563 | 535 |
2148348 | 2148348 | 2022-01-25 | Washington | Arkansas | 5143 | 62098 | 534 |
2145096 | 2145096 | 2022-01-24 | Washington | Arkansas | 5143 | 61386 | 531 |
2141841 | 2141841 | 2022-01-23 | Washington | Arkansas | 5143 | 61184 | 531 |
2138586 | 2138586 | 2022-01-22 | Washington | Arkansas | 5143 | 60943 | 530 |
2135330 | 2135330 | 2022-01-21 | Washington | Arkansas | 5143 | 60307 | 529 |
2132078 | 2132078 | 2022-01-20 | Washington | Arkansas | 5143 | 59605 | 529 |
2128825 | 2128825 | 2022-01-19 | Washington | Arkansas | 5143 | 58500 | 528 |
2125571 | 2125571 | 2022-01-18 | Washington | Arkansas | 5143 | 57135 | 527 |
2122319 | 2122319 | 2022-01-17 | Washington | Arkansas | 5143 | 56841 | 527 |
2119067 | 2119067 | 2022-01-16 | Washington | Arkansas | 5143 | 56733 | 527 |
2115815 | 2115815 | 2022-01-15 | Washington | Arkansas | 5143 | 56202 | 527 |
2112564 | 2112564 | 2022-01-14 | Washington | Arkansas | 5143 | 55349 | 525 |
2109312 | 2109312 | 2022-01-13 | Washington | Arkansas | 5143 | 54794 | 523 |
2106061 | 2106061 | 2022-01-12 | Washington | Arkansas | 5143 | 53341 | 522 |
2102810 | 2102810 | 2022-01-11 | Washington | Arkansas | 5143 | 52327 | 522 |
2099559 | 2099559 | 2022-01-10 | Washington | Arkansas | 5143 | 51895 | 520 |
2096308 | 2096308 | 2022-01-09 | Washington | Arkansas | 5143 | 51123 | 521 |
2093056 | 2093056 | 2022-01-08 | Washington | Arkansas | 5143 | 51123 | 521 |
2089804 | 2089804 | 2022-01-07 | Washington | Arkansas | 5143 | 50517 | 521 |
2086553 | 2086553 | 2022-01-06 | Washington | Arkansas | 5143 | 49949 | 519 |
2083301 | 2083301 | 2022-01-05 | Washington | Arkansas | 5143 | 49250 | 520 |
2080049 | 2080049 | 2022-01-04 | Washington | Arkansas | 5143 | 48717 | 518 |
2076797 | 2076797 | 2022-01-03 | Washington | Arkansas | 5143 | 48245 | 518 |
2073546 | 2073546 | 2022-01-02 | Washington | Arkansas | 5143 | 48195 | 517 |
2070295 | 2070295 | 2022-01-01 | Washington | Arkansas | 5143 | 48114 | 515 |
2067044 | 2067044 | 2021-12-31 | Washington | Arkansas | 5143 | 47853 | 512 |
2063793 | 2063793 | 2021-12-30 | Washington | Arkansas | 5143 | 47756 | 511 |
2060543 | 2060543 | 2021-12-29 | Washington | Arkansas | 5143 | 47473 | 509 |
2057294 | 2057294 | 2021-12-28 | Washington | Arkansas | 5143 | 47306 | 509 |
2054045 | 2054045 | 2021-12-27 | Washington | Arkansas | 5143 | 47162 | 508 |
2050795 | 2050795 | 2021-12-26 | Washington | Arkansas | 5143 | 47084 | 507 |
2047545 | 2047545 | 2021-12-25 | Washington | Arkansas | 5143 | 47068 | 507 |
2044295 | 2044295 | 2021-12-24 | Washington | Arkansas | 5143 | 46994 | 507 |
2041046 | 2041046 | 2021-12-23 | Washington | Arkansas | 5143 | 46887 | 507 |
2037796 | 2037796 | 2021-12-22 | Washington | Arkansas | 5143 | 46809 | 507 |
2034546 | 2034546 | 2021-12-21 | Washington | Arkansas | 5143 | 46758 | 506 |
2031296 | 2031296 | 2021-12-20 | Washington | Arkansas | 5143 | 46713 | 506 |
2028045 | 2028045 | 2021-12-19 | Washington | Arkansas | 5143 | 46682 | 505 |
2024794 | 2024794 | 2021-12-18 | Washington | Arkansas | 5143 | 46658 | 504 |
2021543 | 2021543 | 2021-12-17 | Washington | Arkansas | 5143 | 46598 | 504 |
2018292 | 2018292 | 2021-12-16 | Washington | Arkansas | 5143 | 46540 | 504 |
2015042 | 2015042 | 2021-12-15 | Washington | Arkansas | 5143 | 46474 | 504 |
2011791 | 2011791 | 2021-12-14 | Washington | Arkansas | 5143 | 46393 | 504 |
2008540 | 2008540 | 2021-12-13 | Washington | Arkansas | 5143 | 46363 | 504 |
2005289 | 2005289 | 2021-12-12 | Washington | Arkansas | 5143 | 46346 | 502 |
2002038 | 2002038 | 2021-12-11 | Washington | Arkansas | 5143 | 46339 | 502 |
1998788 | 1998788 | 2021-12-10 | Washington | Arkansas | 5143 | 46280 | 502 |
1995537 | 1995537 | 2021-12-09 | Washington | Arkansas | 5143 | 46204 | 502 |
1992286 | 1992286 | 2021-12-08 | Washington | Arkansas | 5143 | 46143 | 502 |
1989035 | 1989035 | 2021-12-07 | Washington | Arkansas | 5143 | 46100 | 502 |
1985785 | 1985785 | 2021-12-06 | Washington | Arkansas | 5143 | 46056 | 502 |
1982535 | 1982535 | 2021-12-05 | Washington | Arkansas | 5143 | 46036 | 502 |
1979285 | 1979285 | 2021-12-04 | Washington | Arkansas | 5143 | 46010 | 500 |
1976035 | 1976035 | 2021-12-03 | Washington | Arkansas | 5143 | 45962 | 496 |
1972786 | 1972786 | 2021-12-02 | Washington | Arkansas | 5143 | 45874 | 496 |
1969536 | 1969536 | 2021-12-01 | Washington | Arkansas | 5143 | 45812 | 496 |
1966286 | 1966286 | 2021-11-30 | Washington | Arkansas | 5143 | 45716 | 495 |
1963034 | 1963034 | 2021-11-29 | Washington | Arkansas | 5143 | 45672 | 492 |
1959783 | 1959783 | 2021-11-28 | Washington | Arkansas | 5143 | 45653 | 493 |
1956532 | 1956532 | 2021-11-27 | Washington | Arkansas | 5143 | 45629 | 493 |
1953281 | 1953281 | 2021-11-26 | Washington | Arkansas | 5143 | 45601 | 493 |
1950030 | 1950030 | 2021-11-25 | Washington | Arkansas | 5143 | 45575 | 493 |
1946779 | 1946779 | 2021-11-24 | Washington | Arkansas | 5143 | 45518 | 493 |
1943528 | 1943528 | 2021-11-23 | Washington | Arkansas | 5143 | 45476 | 491 |
1940278 | 1940278 | 2021-11-22 | Washington | Arkansas | 5143 | 45423 | 491 |
1937028 | 1937028 | 2021-11-21 | Washington | Arkansas | 5143 | 45409 | 491 |
1933778 | 1933778 | 2021-11-20 | Washington | Arkansas | 5143 | 45379 | 491 |
1930526 | 1930526 | 2021-11-19 | Washington | Arkansas | 5143 | 45325 | 491 |
1927276 | 1927276 | 2021-11-18 | Washington | Arkansas | 5143 | 45273 | 491 |
1924026 | 1924026 | 2021-11-17 | Washington | Arkansas | 5143 | 45200 | 491 |
1920777 | 1920777 | 2021-11-16 | Washington | Arkansas | 5143 | 45168 | 491 |
1917527 | 1917527 | 2021-11-15 | Washington | Arkansas | 5143 | 45119 | 491 |
1914277 | 1914277 | 2021-11-14 | Washington | Arkansas | 5143 | 45113 | 490 |
1911027 | 1911027 | 2021-11-13 | Washington | Arkansas | 5143 | 45077 | 490 |
1907778 | 1907778 | 2021-11-12 | Washington | Arkansas | 5143 | 45030 | 490 |
1904529 | 1904529 | 2021-11-11 | Washington | Arkansas | 5143 | 45004 | 490 |
1901279 | 1901279 | 2021-11-10 | Washington | Arkansas | 5143 | 44939 | 489 |
1898029 | 1898029 | 2021-11-09 | Washington | Arkansas | 5143 | 44895 | 488 |
1894779 | 1894779 | 2021-11-08 | Washington | Arkansas | 5143 | 44846 | 488 |
1891529 | 1891529 | 2021-11-07 | Washington | Arkansas | 5143 | 44837 | 488 |
1888279 | 1888279 | 2021-11-06 | Washington | Arkansas | 5143 | 44818 | 488 |
1885029 | 1885029 | 2021-11-05 | Washington | Arkansas | 5143 | 44788 | 488 |
1881780 | 1881780 | 2021-11-04 | Washington | Arkansas | 5143 | 44743 | 487 |
1878531 | 1878531 | 2021-11-03 | Washington | Arkansas | 5143 | 44719 | 486 |
1875282 | 1875282 | 2021-11-02 | Washington | Arkansas | 5143 | 44681 | 485 |
1872033 | 1872033 | 2021-11-01 | Washington | Arkansas | 5143 | 44652 | 482 |
1868784 | 1868784 | 2021-10-31 | Washington | Arkansas | 5143 | 44645 | 482 |
1865535 | 1865535 | 2021-10-30 | Washington | Arkansas | 5143 | 44632 | 482 |
1862286 | 1862286 | 2021-10-29 | Washington | Arkansas | 5143 | 44599 | 481 |
1859037 | 1859037 | 2021-10-28 | Washington | Arkansas | 5143 | 44560 | 481 |
1855788 | 1855788 | 2021-10-27 | Washington | Arkansas | 5143 | 44527 | 481 |
1852539 | 1852539 | 2021-10-26 | Washington | Arkansas | 5143 | 44479 | 480 |
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);