ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Champaign" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109740 | 2109740 | 2022-01-13 | Champaign | Illinois | 17019 | 48086 | 244 |
2106489 | 2106489 | 2022-01-12 | Champaign | Illinois | 17019 | 47121 | 242 |
2103238 | 2103238 | 2022-01-11 | Champaign | Illinois | 17019 | 46440 | 241 |
2099987 | 2099987 | 2022-01-10 | Champaign | Illinois | 17019 | 45784 | 240 |
2096736 | 2096736 | 2022-01-09 | Champaign | Illinois | 17019 | 43813 | 237 |
2093484 | 2093484 | 2022-01-08 | Champaign | Illinois | 17019 | 43813 | 237 |
2090232 | 2090232 | 2022-01-07 | Champaign | Illinois | 17019 | 43813 | 237 |
2086981 | 2086981 | 2022-01-06 | Champaign | Illinois | 17019 | 42843 | 236 |
2083729 | 2083729 | 2022-01-05 | Champaign | Illinois | 17019 | 41580 | 235 |
2080477 | 2080477 | 2022-01-04 | Champaign | Illinois | 17019 | 40731 | 232 |
2077225 | 2077225 | 2022-01-03 | Champaign | Illinois | 17019 | 39980 | 232 |
2073974 | 2073974 | 2022-01-02 | Champaign | Illinois | 17019 | 37529 | 231 |
2070723 | 2070723 | 2022-01-01 | Champaign | Illinois | 17019 | 37529 | 231 |
2067472 | 2067472 | 2021-12-31 | Champaign | Illinois | 17019 | 37529 | 231 |
2064221 | 2064221 | 2021-12-30 | Champaign | Illinois | 17019 | 37529 | 231 |
2060971 | 2060971 | 2021-12-29 | Champaign | Illinois | 17019 | 36672 | 231 |
2057722 | 2057722 | 2021-12-28 | Champaign | Illinois | 17019 | 35987 | 231 |
2054473 | 2054473 | 2021-12-27 | Champaign | Illinois | 17019 | 35461 | 228 |
2051223 | 2051223 | 2021-12-26 | Champaign | Illinois | 17019 | 34446 | 228 |
2047973 | 2047973 | 2021-12-25 | Champaign | Illinois | 17019 | 34446 | 228 |
2044723 | 2044723 | 2021-12-24 | Champaign | Illinois | 17019 | 34446 | 228 |
2041474 | 2041474 | 2021-12-23 | Champaign | Illinois | 17019 | 34446 | 228 |
2038224 | 2038224 | 2021-12-22 | Champaign | Illinois | 17019 | 34103 | 227 |
2034974 | 2034974 | 2021-12-21 | Champaign | Illinois | 17019 | 33784 | 224 |
2031724 | 2031724 | 2021-12-20 | Champaign | Illinois | 17019 | 33514 | 224 |
2028473 | 2028473 | 2021-12-19 | Champaign | Illinois | 17019 | 32999 | 223 |
2025222 | 2025222 | 2021-12-18 | Champaign | Illinois | 17019 | 32999 | 223 |
2021971 | 2021971 | 2021-12-17 | Champaign | Illinois | 17019 | 32999 | 223 |
2018720 | 2018720 | 2021-12-16 | Champaign | Illinois | 17019 | 32740 | 222 |
2015470 | 2015470 | 2021-12-15 | Champaign | Illinois | 17019 | 32518 | 220 |
2012219 | 2012219 | 2021-12-14 | Champaign | Illinois | 17019 | 32249 | 219 |
2008968 | 2008968 | 2021-12-13 | Champaign | Illinois | 17019 | 32064 | 218 |
2005717 | 2005717 | 2021-12-12 | Champaign | Illinois | 17019 | 31639 | 217 |
2002466 | 2002466 | 2021-12-11 | Champaign | Illinois | 17019 | 31639 | 217 |
1999216 | 1999216 | 2021-12-10 | Champaign | Illinois | 17019 | 31639 | 217 |
1995965 | 1995965 | 2021-12-09 | Champaign | Illinois | 17019 | 31449 | 217 |
1992714 | 1992714 | 2021-12-08 | Champaign | Illinois | 17019 | 31272 | 216 |
1989463 | 1989463 | 2021-12-07 | Champaign | Illinois | 17019 | 31092 | 216 |
1986213 | 1986213 | 2021-12-06 | Champaign | Illinois | 17019 | 30890 | 216 |
1982963 | 1982963 | 2021-12-05 | Champaign | Illinois | 17019 | 30506 | 216 |
1979713 | 1979713 | 2021-12-04 | Champaign | Illinois | 17019 | 30506 | 216 |
1976463 | 1976463 | 2021-12-03 | Champaign | Illinois | 17019 | 30506 | 216 |
1973214 | 1973214 | 2021-12-02 | Champaign | Illinois | 17019 | 30321 | 216 |
1969964 | 1969964 | 2021-12-01 | Champaign | Illinois | 17019 | 30062 | 216 |
1966714 | 1966714 | 2021-11-30 | Champaign | Illinois | 17019 | 29881 | 215 |
1963462 | 1963462 | 2021-11-29 | Champaign | Illinois | 17019 | 29668 | 215 |
1960211 | 1960211 | 2021-11-28 | Champaign | Illinois | 17019 | 29225 | 212 |
1956960 | 1956960 | 2021-11-27 | Champaign | Illinois | 17019 | 29225 | 212 |
1953709 | 1953709 | 2021-11-26 | Champaign | Illinois | 17019 | 29225 | 212 |
1950458 | 1950458 | 2021-11-25 | Champaign | Illinois | 17019 | 29225 | 212 |
1947207 | 1947207 | 2021-11-24 | Champaign | Illinois | 17019 | 29225 | 212 |
1943956 | 1943956 | 2021-11-23 | Champaign | Illinois | 17019 | 29129 | 212 |
1940706 | 1940706 | 2021-11-22 | Champaign | Illinois | 17019 | 29033 | 211 |
1937456 | 1937456 | 2021-11-21 | Champaign | Illinois | 17019 | 28789 | 211 |
1934206 | 1934206 | 2021-11-20 | Champaign | Illinois | 17019 | 28789 | 211 |
1930955 | 1930955 | 2021-11-19 | Champaign | Illinois | 17019 | 28789 | 211 |
1927704 | 1927704 | 2021-11-18 | Champaign | Illinois | 17019 | 28669 | 211 |
1924454 | 1924454 | 2021-11-17 | Champaign | Illinois | 17019 | 28539 | 211 |
1921205 | 1921205 | 2021-11-16 | Champaign | Illinois | 17019 | 28453 | 211 |
1917955 | 1917955 | 2021-11-15 | Champaign | Illinois | 17019 | 28383 | 211 |
1914705 | 1914705 | 2021-11-14 | Champaign | Illinois | 17019 | 28184 | 209 |
1911455 | 1911455 | 2021-11-13 | Champaign | Illinois | 17019 | 28184 | 209 |
1908206 | 1908206 | 2021-11-12 | Champaign | Illinois | 17019 | 28184 | 209 |
1904957 | 1904957 | 2021-11-11 | Champaign | Illinois | 17019 | 28002 | 208 |
1901707 | 1901707 | 2021-11-10 | Champaign | Illinois | 17019 | 28002 | 208 |
1898457 | 1898457 | 2021-11-09 | Champaign | Illinois | 17019 | 27909 | 208 |
1895207 | 1895207 | 2021-11-08 | Champaign | Illinois | 17019 | 27829 | 207 |
1891957 | 1891957 | 2021-11-07 | Champaign | Illinois | 17019 | 27680 | 207 |
1888707 | 1888707 | 2021-11-06 | Champaign | Illinois | 17019 | 27680 | 207 |
1885457 | 1885457 | 2021-11-05 | Champaign | Illinois | 17019 | 27680 | 207 |
1882208 | 1882208 | 2021-11-04 | Champaign | Illinois | 17019 | 27606 | 206 |
1878959 | 1878959 | 2021-11-03 | Champaign | Illinois | 17019 | 27508 | 206 |
1875710 | 1875710 | 2021-11-02 | Champaign | Illinois | 17019 | 27453 | 206 |
1872461 | 1872461 | 2021-11-01 | Champaign | Illinois | 17019 | 27407 | 206 |
1869212 | 1869212 | 2021-10-31 | Champaign | Illinois | 17019 | 27318 | 206 |
1865963 | 1865963 | 2021-10-30 | Champaign | Illinois | 17019 | 27318 | 206 |
1862714 | 1862714 | 2021-10-29 | Champaign | Illinois | 17019 | 27318 | 206 |
1859465 | 1859465 | 2021-10-28 | Champaign | Illinois | 17019 | 27262 | 206 |
1856216 | 1856216 | 2021-10-27 | Champaign | Illinois | 17019 | 27218 | 206 |
1852967 | 1852967 | 2021-10-26 | Champaign | Illinois | 17019 | 27178 | 206 |
1849718 | 1849718 | 2021-10-25 | Champaign | Illinois | 17019 | 27150 | 205 |
1846468 | 1846468 | 2021-10-24 | Champaign | Illinois | 17019 | 27087 | 205 |
1843218 | 1843218 | 2021-10-23 | Champaign | Illinois | 17019 | 27087 | 205 |
1839968 | 1839968 | 2021-10-22 | Champaign | Illinois | 17019 | 27087 | 205 |
1836719 | 1836719 | 2021-10-21 | Champaign | Illinois | 17019 | 27034 | 205 |
1833470 | 1833470 | 2021-10-20 | Champaign | Illinois | 17019 | 26998 | 205 |
1830221 | 1830221 | 2021-10-19 | Champaign | Illinois | 17019 | 26960 | 205 |
1826972 | 1826972 | 2021-10-18 | Champaign | Illinois | 17019 | 26931 | 204 |
1823723 | 1823723 | 2021-10-17 | Champaign | Illinois | 17019 | 26859 | 204 |
1820474 | 1820474 | 2021-10-16 | Champaign | Illinois | 17019 | 26859 | 204 |
1817225 | 1817225 | 2021-10-15 | Champaign | Illinois | 17019 | 26859 | 204 |
1813977 | 1813977 | 2021-10-14 | Champaign | Illinois | 17019 | 26817 | 203 |
1810728 | 1810728 | 2021-10-13 | Champaign | Illinois | 17019 | 26786 | 203 |
1807479 | 1807479 | 2021-10-12 | Champaign | Illinois | 17019 | 26734 | 201 |
1804228 | 1804228 | 2021-10-11 | Champaign | Illinois | 17019 | 26580 | 200 |
1800979 | 1800979 | 2021-10-10 | Champaign | Illinois | 17019 | 26580 | 200 |
1797730 | 1797730 | 2021-10-09 | Champaign | Illinois | 17019 | 26580 | 200 |
1794481 | 1794481 | 2021-10-08 | Champaign | Illinois | 17019 | 26580 | 200 |
1791233 | 1791233 | 2021-10-07 | Champaign | Illinois | 17019 | 26537 | 197 |
1787984 | 1787984 | 2021-10-06 | Champaign | Illinois | 17019 | 26497 | 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);