ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Monroe" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174863 | 2174863 | 2022-02-02 | Monroe | Illinois | 17133 | 9150 | 120 |
2171610 | 2171610 | 2022-02-01 | Monroe | Illinois | 17133 | 9118 | 120 |
2168357 | 2168357 | 2022-01-31 | Monroe | Illinois | 17133 | 9080 | 117 |
2165102 | 2165102 | 2022-01-30 | Monroe | Illinois | 17133 | 8989 | 117 |
2161847 | 2161847 | 2022-01-29 | Monroe | Illinois | 17133 | 8989 | 117 |
2158592 | 2158592 | 2022-01-28 | Monroe | Illinois | 17133 | 8989 | 117 |
2155338 | 2155338 | 2022-01-27 | Monroe | Illinois | 17133 | 8921 | 117 |
2152085 | 2152085 | 2022-01-26 | Monroe | Illinois | 17133 | 8865 | 116 |
2148833 | 2148833 | 2022-01-25 | Monroe | Illinois | 17133 | 8805 | 115 |
2145581 | 2145581 | 2022-01-24 | Monroe | Illinois | 17133 | 8755 | 114 |
2142326 | 2142326 | 2022-01-23 | Monroe | Illinois | 17133 | 8573 | 114 |
2139071 | 2139071 | 2022-01-22 | Monroe | Illinois | 17133 | 8573 | 114 |
2135815 | 2135815 | 2022-01-21 | Monroe | Illinois | 17133 | 8573 | 114 |
2132563 | 2132563 | 2022-01-20 | Monroe | Illinois | 17133 | 8500 | 113 |
2129310 | 2129310 | 2022-01-19 | Monroe | Illinois | 17133 | 8394 | 113 |
2126056 | 2126056 | 2022-01-18 | Monroe | Illinois | 17133 | 8239 | 111 |
2122804 | 2122804 | 2022-01-17 | Monroe | Illinois | 17133 | 7951 | 111 |
2119552 | 2119552 | 2022-01-16 | Monroe | Illinois | 17133 | 7951 | 111 |
2116300 | 2116300 | 2022-01-15 | Monroe | Illinois | 17133 | 7951 | 111 |
2113049 | 2113049 | 2022-01-14 | Monroe | Illinois | 17133 | 7951 | 111 |
2109797 | 2109797 | 2022-01-13 | Monroe | Illinois | 17133 | 7836 | 111 |
2106546 | 2106546 | 2022-01-12 | Monroe | Illinois | 17133 | 7669 | 110 |
2103295 | 2103295 | 2022-01-11 | Monroe | Illinois | 17133 | 7535 | 109 |
2100044 | 2100044 | 2022-01-10 | Monroe | Illinois | 17133 | 7368 | 109 |
2096793 | 2096793 | 2022-01-09 | Monroe | Illinois | 17133 | 7092 | 109 |
2093541 | 2093541 | 2022-01-08 | Monroe | Illinois | 17133 | 7092 | 109 |
2090289 | 2090289 | 2022-01-07 | Monroe | Illinois | 17133 | 7092 | 109 |
2087038 | 2087038 | 2022-01-06 | Monroe | Illinois | 17133 | 6935 | 109 |
2083786 | 2083786 | 2022-01-05 | Monroe | Illinois | 17133 | 6752 | 109 |
2080534 | 2080534 | 2022-01-04 | Monroe | Illinois | 17133 | 6653 | 109 |
2077282 | 2077282 | 2022-01-03 | Monroe | Illinois | 17133 | 6551 | 109 |
2074031 | 2074031 | 2022-01-02 | Monroe | Illinois | 17133 | 6365 | 108 |
2070780 | 2070780 | 2022-01-01 | Monroe | Illinois | 17133 | 6365 | 108 |
2067529 | 2067529 | 2021-12-31 | Monroe | Illinois | 17133 | 6365 | 108 |
2064278 | 2064278 | 2021-12-30 | Monroe | Illinois | 17133 | 6365 | 108 |
2061028 | 2061028 | 2021-12-29 | Monroe | Illinois | 17133 | 6258 | 108 |
2057779 | 2057779 | 2021-12-28 | Monroe | Illinois | 17133 | 6214 | 108 |
2054530 | 2054530 | 2021-12-27 | Monroe | Illinois | 17133 | 6176 | 108 |
2051280 | 2051280 | 2021-12-26 | Monroe | Illinois | 17133 | 6086 | 107 |
2048030 | 2048030 | 2021-12-25 | Monroe | Illinois | 17133 | 6086 | 107 |
2044780 | 2044780 | 2021-12-24 | Monroe | Illinois | 17133 | 6086 | 107 |
2041531 | 2041531 | 2021-12-23 | Monroe | Illinois | 17133 | 6086 | 107 |
2038281 | 2038281 | 2021-12-22 | Monroe | Illinois | 17133 | 6045 | 107 |
2035031 | 2035031 | 2021-12-21 | Monroe | Illinois | 17133 | 6033 | 107 |
2031781 | 2031781 | 2021-12-20 | Monroe | Illinois | 17133 | 6009 | 107 |
2028530 | 2028530 | 2021-12-19 | Monroe | Illinois | 17133 | 5965 | 107 |
2025279 | 2025279 | 2021-12-18 | Monroe | Illinois | 17133 | 5965 | 107 |
2022028 | 2022028 | 2021-12-17 | Monroe | Illinois | 17133 | 5965 | 107 |
2018777 | 2018777 | 2021-12-16 | Monroe | Illinois | 17133 | 5951 | 107 |
2015527 | 2015527 | 2021-12-15 | Monroe | Illinois | 17133 | 5920 | 106 |
2012276 | 2012276 | 2021-12-14 | Monroe | Illinois | 17133 | 5904 | 106 |
2009025 | 2009025 | 2021-12-13 | Monroe | Illinois | 17133 | 5878 | 106 |
2005774 | 2005774 | 2021-12-12 | Monroe | Illinois | 17133 | 5826 | 105 |
2002523 | 2002523 | 2021-12-11 | Monroe | Illinois | 17133 | 5826 | 105 |
1999273 | 1999273 | 2021-12-10 | Monroe | Illinois | 17133 | 5826 | 105 |
1996022 | 1996022 | 2021-12-09 | Monroe | Illinois | 17133 | 5796 | 105 |
1992771 | 1992771 | 2021-12-08 | Monroe | Illinois | 17133 | 5766 | 105 |
1989520 | 1989520 | 2021-12-07 | Monroe | Illinois | 17133 | 5748 | 105 |
1986270 | 1986270 | 2021-12-06 | Monroe | Illinois | 17133 | 5728 | 105 |
1983020 | 1983020 | 2021-12-05 | Monroe | Illinois | 17133 | 5669 | 105 |
1979770 | 1979770 | 2021-12-04 | Monroe | Illinois | 17133 | 5669 | 105 |
1976520 | 1976520 | 2021-12-03 | Monroe | Illinois | 17133 | 5669 | 105 |
1973271 | 1973271 | 2021-12-02 | Monroe | Illinois | 17133 | 5642 | 105 |
1970021 | 1970021 | 2021-12-01 | Monroe | Illinois | 17133 | 5604 | 105 |
1966771 | 1966771 | 2021-11-30 | Monroe | Illinois | 17133 | 5579 | 105 |
1963519 | 1963519 | 2021-11-29 | Monroe | Illinois | 17133 | 5567 | 105 |
1960268 | 1960268 | 2021-11-28 | Monroe | Illinois | 17133 | 5521 | 105 |
1957017 | 1957017 | 2021-11-27 | Monroe | Illinois | 17133 | 5521 | 105 |
1953766 | 1953766 | 2021-11-26 | Monroe | Illinois | 17133 | 5521 | 105 |
1950515 | 1950515 | 2021-11-25 | Monroe | Illinois | 17133 | 5521 | 105 |
1947264 | 1947264 | 2021-11-24 | Monroe | Illinois | 17133 | 5521 | 105 |
1944013 | 1944013 | 2021-11-23 | Monroe | Illinois | 17133 | 5510 | 105 |
1940763 | 1940763 | 2021-11-22 | Monroe | Illinois | 17133 | 5492 | 105 |
1937513 | 1937513 | 2021-11-21 | Monroe | Illinois | 17133 | 5463 | 105 |
1934263 | 1934263 | 2021-11-20 | Monroe | Illinois | 17133 | 5463 | 105 |
1931012 | 1931012 | 2021-11-19 | Monroe | Illinois | 17133 | 5463 | 105 |
1927761 | 1927761 | 2021-11-18 | Monroe | Illinois | 17133 | 5451 | 105 |
1924511 | 1924511 | 2021-11-17 | Monroe | Illinois | 17133 | 5436 | 105 |
1921262 | 1921262 | 2021-11-16 | Monroe | Illinois | 17133 | 5425 | 105 |
1918012 | 1918012 | 2021-11-15 | Monroe | Illinois | 17133 | 5416 | 105 |
1914762 | 1914762 | 2021-11-14 | Monroe | Illinois | 17133 | 5400 | 105 |
1911512 | 1911512 | 2021-11-13 | Monroe | Illinois | 17133 | 5400 | 105 |
1908263 | 1908263 | 2021-11-12 | Monroe | Illinois | 17133 | 5400 | 105 |
1905014 | 1905014 | 2021-11-11 | Monroe | Illinois | 17133 | 5379 | 105 |
1901764 | 1901764 | 2021-11-10 | Monroe | Illinois | 17133 | 5379 | 105 |
1898514 | 1898514 | 2021-11-09 | Monroe | Illinois | 17133 | 5365 | 105 |
1895264 | 1895264 | 2021-11-08 | Monroe | Illinois | 17133 | 5358 | 105 |
1892014 | 1892014 | 2021-11-07 | Monroe | Illinois | 17133 | 5337 | 105 |
1888764 | 1888764 | 2021-11-06 | Monroe | Illinois | 17133 | 5337 | 105 |
1885514 | 1885514 | 2021-11-05 | Monroe | Illinois | 17133 | 5337 | 105 |
1882265 | 1882265 | 2021-11-04 | Monroe | Illinois | 17133 | 5330 | 105 |
1879016 | 1879016 | 2021-11-03 | Monroe | Illinois | 17133 | 5316 | 105 |
1875767 | 1875767 | 2021-11-02 | Monroe | Illinois | 17133 | 5310 | 104 |
1872518 | 1872518 | 2021-11-01 | Monroe | Illinois | 17133 | 5305 | 104 |
1869269 | 1869269 | 2021-10-31 | Monroe | Illinois | 17133 | 5290 | 104 |
1866020 | 1866020 | 2021-10-30 | Monroe | Illinois | 17133 | 5290 | 104 |
1862771 | 1862771 | 2021-10-29 | Monroe | Illinois | 17133 | 5290 | 104 |
1859522 | 1859522 | 2021-10-28 | Monroe | Illinois | 17133 | 5286 | 104 |
1856273 | 1856273 | 2021-10-27 | Monroe | Illinois | 17133 | 5279 | 104 |
1853024 | 1853024 | 2021-10-26 | Monroe | Illinois | 17133 | 5278 | 104 |
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);