ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Adams" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174797 | 2174797 | 2022-02-02 | Adams | Illinois | 17001 | 21360 | 219 |
2171544 | 2171544 | 2022-02-01 | Adams | Illinois | 17001 | 21261 | 218 |
2168291 | 2168291 | 2022-01-31 | Adams | Illinois | 17001 | 21186 | 218 |
2165036 | 2165036 | 2022-01-30 | Adams | Illinois | 17001 | 20940 | 218 |
2161781 | 2161781 | 2022-01-29 | Adams | Illinois | 17001 | 20940 | 218 |
2158526 | 2158526 | 2022-01-28 | Adams | Illinois | 17001 | 20940 | 218 |
2155272 | 2155272 | 2022-01-27 | Adams | Illinois | 17001 | 20809 | 217 |
2152019 | 2152019 | 2022-01-26 | Adams | Illinois | 17001 | 20660 | 217 |
2148767 | 2148767 | 2022-01-25 | Adams | Illinois | 17001 | 20519 | 217 |
2145515 | 2145515 | 2022-01-24 | Adams | Illinois | 17001 | 20364 | 216 |
2142260 | 2142260 | 2022-01-23 | Adams | Illinois | 17001 | 19923 | 214 |
2139005 | 2139005 | 2022-01-22 | Adams | Illinois | 17001 | 19923 | 214 |
2135749 | 2135749 | 2022-01-21 | Adams | Illinois | 17001 | 19923 | 214 |
2132497 | 2132497 | 2022-01-20 | Adams | Illinois | 17001 | 19805 | 213 |
2129244 | 2129244 | 2022-01-19 | Adams | Illinois | 17001 | 19602 | 213 |
2125990 | 2125990 | 2022-01-18 | Adams | Illinois | 17001 | 19358 | 212 |
2122738 | 2122738 | 2022-01-17 | Adams | Illinois | 17001 | 18752 | 212 |
2119486 | 2119486 | 2022-01-16 | Adams | Illinois | 17001 | 18752 | 212 |
2116234 | 2116234 | 2022-01-15 | Adams | Illinois | 17001 | 18752 | 212 |
2112983 | 2112983 | 2022-01-14 | Adams | Illinois | 17001 | 18752 | 212 |
2109731 | 2109731 | 2022-01-13 | Adams | Illinois | 17001 | 18513 | 210 |
2106480 | 2106480 | 2022-01-12 | Adams | Illinois | 17001 | 18268 | 208 |
2103229 | 2103229 | 2022-01-11 | Adams | Illinois | 17001 | 17991 | 205 |
2099978 | 2099978 | 2022-01-10 | Adams | Illinois | 17001 | 17734 | 205 |
2096727 | 2096727 | 2022-01-09 | Adams | Illinois | 17001 | 17327 | 203 |
2093475 | 2093475 | 2022-01-08 | Adams | Illinois | 17001 | 17327 | 203 |
2090223 | 2090223 | 2022-01-07 | Adams | Illinois | 17001 | 17327 | 203 |
2086972 | 2086972 | 2022-01-06 | Adams | Illinois | 17001 | 17160 | 203 |
2083720 | 2083720 | 2022-01-05 | Adams | Illinois | 17001 | 16939 | 201 |
2080468 | 2080468 | 2022-01-04 | Adams | Illinois | 17001 | 16784 | 201 |
2077216 | 2077216 | 2022-01-03 | Adams | Illinois | 17001 | 16598 | 201 |
2073965 | 2073965 | 2022-01-02 | Adams | Illinois | 17001 | 16257 | 198 |
2070714 | 2070714 | 2022-01-01 | Adams | Illinois | 17001 | 16257 | 198 |
2067463 | 2067463 | 2021-12-31 | Adams | Illinois | 17001 | 16257 | 198 |
2064212 | 2064212 | 2021-12-30 | Adams | Illinois | 17001 | 16257 | 198 |
2060962 | 2060962 | 2021-12-29 | Adams | Illinois | 17001 | 16123 | 197 |
2057713 | 2057713 | 2021-12-28 | Adams | Illinois | 17001 | 16028 | 197 |
2054464 | 2054464 | 2021-12-27 | Adams | Illinois | 17001 | 15879 | 196 |
2051214 | 2051214 | 2021-12-26 | Adams | Illinois | 17001 | 15742 | 194 |
2047964 | 2047964 | 2021-12-25 | Adams | Illinois | 17001 | 15742 | 194 |
2044714 | 2044714 | 2021-12-24 | Adams | Illinois | 17001 | 15742 | 194 |
2041465 | 2041465 | 2021-12-23 | Adams | Illinois | 17001 | 15742 | 194 |
2038215 | 2038215 | 2021-12-22 | Adams | Illinois | 17001 | 15685 | 193 |
2034965 | 2034965 | 2021-12-21 | Adams | Illinois | 17001 | 15571 | 193 |
2031715 | 2031715 | 2021-12-20 | Adams | Illinois | 17001 | 15547 | 193 |
2028464 | 2028464 | 2021-12-19 | Adams | Illinois | 17001 | 15414 | 192 |
2025213 | 2025213 | 2021-12-18 | Adams | Illinois | 17001 | 15414 | 192 |
2021962 | 2021962 | 2021-12-17 | Adams | Illinois | 17001 | 15414 | 192 |
2018711 | 2018711 | 2021-12-16 | Adams | Illinois | 17001 | 15347 | 192 |
2015461 | 2015461 | 2021-12-15 | Adams | Illinois | 17001 | 15231 | 192 |
2012210 | 2012210 | 2021-12-14 | Adams | Illinois | 17001 | 15170 | 192 |
2008959 | 2008959 | 2021-12-13 | Adams | Illinois | 17001 | 15097 | 192 |
2005708 | 2005708 | 2021-12-12 | Adams | Illinois | 17001 | 14987 | 192 |
2002457 | 2002457 | 2021-12-11 | Adams | Illinois | 17001 | 14987 | 192 |
1999207 | 1999207 | 2021-12-10 | Adams | Illinois | 17001 | 14987 | 192 |
1995956 | 1995956 | 2021-12-09 | Adams | Illinois | 17001 | 14913 | 192 |
1992705 | 1992705 | 2021-12-08 | Adams | Illinois | 17001 | 14837 | 191 |
1989454 | 1989454 | 2021-12-07 | Adams | Illinois | 17001 | 14760 | 191 |
1986204 | 1986204 | 2021-12-06 | Adams | Illinois | 17001 | 14673 | 190 |
1982954 | 1982954 | 2021-12-05 | Adams | Illinois | 17001 | 14545 | 189 |
1979704 | 1979704 | 2021-12-04 | Adams | Illinois | 17001 | 14545 | 189 |
1976454 | 1976454 | 2021-12-03 | Adams | Illinois | 17001 | 14545 | 189 |
1973205 | 1973205 | 2021-12-02 | Adams | Illinois | 17001 | 14509 | 189 |
1969955 | 1969955 | 2021-12-01 | Adams | Illinois | 17001 | 14429 | 188 |
1966705 | 1966705 | 2021-11-30 | Adams | Illinois | 17001 | 14399 | 188 |
1963453 | 1963453 | 2021-11-29 | Adams | Illinois | 17001 | 14307 | 188 |
1960202 | 1960202 | 2021-11-28 | Adams | Illinois | 17001 | 14146 | 188 |
1956951 | 1956951 | 2021-11-27 | Adams | Illinois | 17001 | 14146 | 188 |
1953700 | 1953700 | 2021-11-26 | Adams | Illinois | 17001 | 14146 | 188 |
1950449 | 1950449 | 2021-11-25 | Adams | Illinois | 17001 | 14146 | 188 |
1947198 | 1947198 | 2021-11-24 | Adams | Illinois | 17001 | 14146 | 188 |
1943947 | 1943947 | 2021-11-23 | Adams | Illinois | 17001 | 14111 | 187 |
1940697 | 1940697 | 2021-11-22 | Adams | Illinois | 17001 | 14053 | 187 |
1937447 | 1937447 | 2021-11-21 | Adams | Illinois | 17001 | 13959 | 187 |
1934197 | 1934197 | 2021-11-20 | Adams | Illinois | 17001 | 13959 | 187 |
1930946 | 1930946 | 2021-11-19 | Adams | Illinois | 17001 | 13959 | 187 |
1927695 | 1927695 | 2021-11-18 | Adams | Illinois | 17001 | 13920 | 187 |
1924445 | 1924445 | 2021-11-17 | Adams | Illinois | 17001 | 13871 | 187 |
1921196 | 1921196 | 2021-11-16 | Adams | Illinois | 17001 | 13817 | 186 |
1917946 | 1917946 | 2021-11-15 | Adams | Illinois | 17001 | 13794 | 186 |
1914696 | 1914696 | 2021-11-14 | Adams | Illinois | 17001 | 13727 | 186 |
1911446 | 1911446 | 2021-11-13 | Adams | Illinois | 17001 | 13727 | 186 |
1908197 | 1908197 | 2021-11-12 | Adams | Illinois | 17001 | 13727 | 186 |
1904948 | 1904948 | 2021-11-11 | Adams | Illinois | 17001 | 13659 | 186 |
1901698 | 1901698 | 2021-11-10 | Adams | Illinois | 17001 | 13659 | 186 |
1898448 | 1898448 | 2021-11-09 | Adams | Illinois | 17001 | 13561 | 186 |
1895198 | 1895198 | 2021-11-08 | Adams | Illinois | 17001 | 13533 | 186 |
1891948 | 1891948 | 2021-11-07 | Adams | Illinois | 17001 | 13477 | 186 |
1888698 | 1888698 | 2021-11-06 | Adams | Illinois | 17001 | 13477 | 186 |
1885448 | 1885448 | 2021-11-05 | Adams | Illinois | 17001 | 13477 | 186 |
1882199 | 1882199 | 2021-11-04 | Adams | Illinois | 17001 | 13447 | 185 |
1878950 | 1878950 | 2021-11-03 | Adams | Illinois | 17001 | 13419 | 185 |
1875701 | 1875701 | 2021-11-02 | Adams | Illinois | 17001 | 13401 | 185 |
1872452 | 1872452 | 2021-11-01 | Adams | Illinois | 17001 | 13367 | 185 |
1869203 | 1869203 | 2021-10-31 | Adams | Illinois | 17001 | 13319 | 184 |
1865954 | 1865954 | 2021-10-30 | Adams | Illinois | 17001 | 13319 | 184 |
1862705 | 1862705 | 2021-10-29 | Adams | Illinois | 17001 | 13319 | 184 |
1859456 | 1859456 | 2021-10-28 | Adams | Illinois | 17001 | 13290 | 184 |
1856207 | 1856207 | 2021-10-27 | Adams | Illinois | 17001 | 13266 | 183 |
1852958 | 1852958 | 2021-10-26 | Adams | Illinois | 17001 | 13244 | 182 |
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);