ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Union" and fips = 5139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174375 | 2174375 | 2022-02-02 | Union | Arkansas | 5139 | 8762 | 159 |
2171122 | 2171122 | 2022-02-01 | Union | Arkansas | 5139 | 8728 | 159 |
2167869 | 2167869 | 2022-01-31 | Union | Arkansas | 5139 | 8700 | 159 |
2164614 | 2164614 | 2022-01-30 | Union | Arkansas | 5139 | 8613 | 159 |
2161359 | 2161359 | 2022-01-29 | Union | Arkansas | 5139 | 8613 | 159 |
2158103 | 2158103 | 2022-01-28 | Union | Arkansas | 5139 | 8613 | 159 |
2154850 | 2154850 | 2022-01-27 | Union | Arkansas | 5139 | 8543 | 158 |
2151597 | 2151597 | 2022-01-26 | Union | Arkansas | 5139 | 8502 | 157 |
2148345 | 2148345 | 2022-01-25 | Union | Arkansas | 5139 | 8445 | 157 |
2145093 | 2145093 | 2022-01-24 | Union | Arkansas | 5139 | 8353 | 157 |
2141838 | 2141838 | 2022-01-23 | Union | Arkansas | 5139 | 8323 | 157 |
2138583 | 2138583 | 2022-01-22 | Union | Arkansas | 5139 | 8309 | 157 |
2135327 | 2135327 | 2022-01-21 | Union | Arkansas | 5139 | 8197 | 157 |
2132075 | 2132075 | 2022-01-20 | Union | Arkansas | 5139 | 8131 | 157 |
2128822 | 2128822 | 2022-01-19 | Union | Arkansas | 5139 | 7941 | 157 |
2125568 | 2125568 | 2022-01-18 | Union | Arkansas | 5139 | 7805 | 157 |
2122316 | 2122316 | 2022-01-17 | Union | Arkansas | 5139 | 7799 | 156 |
2119064 | 2119064 | 2022-01-16 | Union | Arkansas | 5139 | 7785 | 156 |
2115812 | 2115812 | 2022-01-15 | Union | Arkansas | 5139 | 7735 | 156 |
2112561 | 2112561 | 2022-01-14 | Union | Arkansas | 5139 | 7581 | 155 |
2109309 | 2109309 | 2022-01-13 | Union | Arkansas | 5139 | 7495 | 155 |
2106058 | 2106058 | 2022-01-12 | Union | Arkansas | 5139 | 7353 | 153 |
2102807 | 2102807 | 2022-01-11 | Union | Arkansas | 5139 | 7282 | 153 |
2099556 | 2099556 | 2022-01-10 | Union | Arkansas | 5139 | 7202 | 153 |
2096305 | 2096305 | 2022-01-09 | Union | Arkansas | 5139 | 7151 | 153 |
2093053 | 2093053 | 2022-01-08 | Union | Arkansas | 5139 | 7151 | 153 |
2089801 | 2089801 | 2022-01-07 | Union | Arkansas | 5139 | 7064 | 153 |
2086550 | 2086550 | 2022-01-06 | Union | Arkansas | 5139 | 6960 | 153 |
2083298 | 2083298 | 2022-01-05 | Union | Arkansas | 5139 | 6821 | 153 |
2080046 | 2080046 | 2022-01-04 | Union | Arkansas | 5139 | 6745 | 152 |
2076794 | 2076794 | 2022-01-03 | Union | Arkansas | 5139 | 6673 | 151 |
2073543 | 2073543 | 2022-01-02 | Union | Arkansas | 5139 | 6649 | 151 |
2070292 | 2070292 | 2022-01-01 | Union | Arkansas | 5139 | 6594 | 151 |
2067041 | 2067041 | 2021-12-31 | Union | Arkansas | 5139 | 6542 | 151 |
2063790 | 2063790 | 2021-12-30 | Union | Arkansas | 5139 | 6493 | 152 |
2060540 | 2060540 | 2021-12-29 | Union | Arkansas | 5139 | 6402 | 151 |
2057291 | 2057291 | 2021-12-28 | Union | Arkansas | 5139 | 6308 | 151 |
2054042 | 2054042 | 2021-12-27 | Union | Arkansas | 5139 | 6279 | 151 |
2050792 | 2050792 | 2021-12-26 | Union | Arkansas | 5139 | 6275 | 151 |
2047542 | 2047542 | 2021-12-25 | Union | Arkansas | 5139 | 6270 | 151 |
2044292 | 2044292 | 2021-12-24 | Union | Arkansas | 5139 | 6260 | 151 |
2041043 | 2041043 | 2021-12-23 | Union | Arkansas | 5139 | 6240 | 150 |
2037793 | 2037793 | 2021-12-22 | Union | Arkansas | 5139 | 6220 | 150 |
2034543 | 2034543 | 2021-12-21 | Union | Arkansas | 5139 | 6196 | 149 |
2031293 | 2031293 | 2021-12-20 | Union | Arkansas | 5139 | 6182 | 149 |
2028042 | 2028042 | 2021-12-19 | Union | Arkansas | 5139 | 6179 | 148 |
2024791 | 2024791 | 2021-12-18 | Union | Arkansas | 5139 | 6169 | 148 |
2021540 | 2021540 | 2021-12-17 | Union | Arkansas | 5139 | 6160 | 147 |
2018289 | 2018289 | 2021-12-16 | Union | Arkansas | 5139 | 6146 | 146 |
2015039 | 2015039 | 2021-12-15 | Union | Arkansas | 5139 | 6130 | 146 |
2011788 | 2011788 | 2021-12-14 | Union | Arkansas | 5139 | 6109 | 146 |
2008537 | 2008537 | 2021-12-13 | Union | Arkansas | 5139 | 6098 | 146 |
2005286 | 2005286 | 2021-12-12 | Union | Arkansas | 5139 | 6095 | 146 |
2002035 | 2002035 | 2021-12-11 | Union | Arkansas | 5139 | 6093 | 145 |
1998785 | 1998785 | 2021-12-10 | Union | Arkansas | 5139 | 6083 | 144 |
1995534 | 1995534 | 2021-12-09 | Union | Arkansas | 5139 | 6075 | 144 |
1992283 | 1992283 | 2021-12-08 | Union | Arkansas | 5139 | 6069 | 144 |
1989032 | 1989032 | 2021-12-07 | Union | Arkansas | 5139 | 6051 | 144 |
1985782 | 1985782 | 2021-12-06 | Union | Arkansas | 5139 | 6043 | 144 |
1982532 | 1982532 | 2021-12-05 | Union | Arkansas | 5139 | 6041 | 144 |
1979282 | 1979282 | 2021-12-04 | Union | Arkansas | 5139 | 6040 | 144 |
1976032 | 1976032 | 2021-12-03 | Union | Arkansas | 5139 | 6028 | 143 |
1972783 | 1972783 | 2021-12-02 | Union | Arkansas | 5139 | 6002 | 143 |
1969533 | 1969533 | 2021-12-01 | Union | Arkansas | 5139 | 5985 | 143 |
1966283 | 1966283 | 2021-11-30 | Union | Arkansas | 5139 | 5968 | 143 |
1963031 | 1963031 | 2021-11-29 | Union | Arkansas | 5139 | 5954 | 143 |
1959780 | 1959780 | 2021-11-28 | Union | Arkansas | 5139 | 5953 | 144 |
1956529 | 1956529 | 2021-11-27 | Union | Arkansas | 5139 | 5944 | 144 |
1953278 | 1953278 | 2021-11-26 | Union | Arkansas | 5139 | 5939 | 144 |
1950027 | 1950027 | 2021-11-25 | Union | Arkansas | 5139 | 5938 | 144 |
1946776 | 1946776 | 2021-11-24 | Union | Arkansas | 5139 | 5930 | 142 |
1943525 | 1943525 | 2021-11-23 | Union | Arkansas | 5139 | 5925 | 142 |
1940275 | 1940275 | 2021-11-22 | Union | Arkansas | 5139 | 5915 | 142 |
1937025 | 1937025 | 2021-11-21 | Union | Arkansas | 5139 | 5911 | 141 |
1933775 | 1933775 | 2021-11-20 | Union | Arkansas | 5139 | 5910 | 141 |
1930523 | 1930523 | 2021-11-19 | Union | Arkansas | 5139 | 5902 | 141 |
1927273 | 1927273 | 2021-11-18 | Union | Arkansas | 5139 | 5890 | 141 |
1924023 | 1924023 | 2021-11-17 | Union | Arkansas | 5139 | 5878 | 141 |
1920774 | 1920774 | 2021-11-16 | Union | Arkansas | 5139 | 5869 | 141 |
1917524 | 1917524 | 2021-11-15 | Union | Arkansas | 5139 | 5864 | 141 |
1914274 | 1914274 | 2021-11-14 | Union | Arkansas | 5139 | 5861 | 141 |
1911024 | 1911024 | 2021-11-13 | Union | Arkansas | 5139 | 5858 | 141 |
1907775 | 1907775 | 2021-11-12 | Union | Arkansas | 5139 | 5856 | 141 |
1904526 | 1904526 | 2021-11-11 | Union | Arkansas | 5139 | 5850 | 141 |
1901276 | 1901276 | 2021-11-10 | Union | Arkansas | 5139 | 5843 | 141 |
1898026 | 1898026 | 2021-11-09 | Union | Arkansas | 5139 | 5839 | 141 |
1894776 | 1894776 | 2021-11-08 | Union | Arkansas | 5139 | 5833 | 141 |
1891526 | 1891526 | 2021-11-07 | Union | Arkansas | 5139 | 5833 | 141 |
1888276 | 1888276 | 2021-11-06 | Union | Arkansas | 5139 | 5829 | 140 |
1885026 | 1885026 | 2021-11-05 | Union | Arkansas | 5139 | 5829 | 140 |
1881777 | 1881777 | 2021-11-04 | Union | Arkansas | 5139 | 5823 | 140 |
1878528 | 1878528 | 2021-11-03 | Union | Arkansas | 5139 | 5819 | 140 |
1875279 | 1875279 | 2021-11-02 | Union | Arkansas | 5139 | 5808 | 139 |
1872030 | 1872030 | 2021-11-01 | Union | Arkansas | 5139 | 5798 | 138 |
1868781 | 1868781 | 2021-10-31 | Union | Arkansas | 5139 | 5797 | 138 |
1865532 | 1865532 | 2021-10-30 | Union | Arkansas | 5139 | 5796 | 138 |
1862283 | 1862283 | 2021-10-29 | Union | Arkansas | 5139 | 5790 | 138 |
1859034 | 1859034 | 2021-10-28 | Union | Arkansas | 5139 | 5785 | 138 |
1855785 | 1855785 | 2021-10-27 | Union | Arkansas | 5139 | 5775 | 138 |
1852536 | 1852536 | 2021-10-26 | Union | Arkansas | 5139 | 5763 | 138 |
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);