ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Will" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109830 | 2109830 | 2022-01-13 | Will | Illinois | 17197 | 140274 | 1370 |
2106579 | 2106579 | 2022-01-12 | Will | Illinois | 17197 | 138631 | 1361 |
2103328 | 2103328 | 2022-01-11 | Will | Illinois | 17197 | 137073 | 1349 |
2100077 | 2100077 | 2022-01-10 | Will | Illinois | 17197 | 135633 | 1347 |
2096826 | 2096826 | 2022-01-09 | Will | Illinois | 17197 | 131643 | 1336 |
2093574 | 2093574 | 2022-01-08 | Will | Illinois | 17197 | 131643 | 1336 |
2090322 | 2090322 | 2022-01-07 | Will | Illinois | 17197 | 131643 | 1336 |
2087071 | 2087071 | 2022-01-06 | Will | Illinois | 17197 | 129679 | 1333 |
2083819 | 2083819 | 2022-01-05 | Will | Illinois | 17197 | 127147 | 1326 |
2080567 | 2080567 | 2022-01-04 | Will | Illinois | 17197 | 125375 | 1324 |
2077315 | 2077315 | 2022-01-03 | Will | Illinois | 17197 | 124191 | 1320 |
2074064 | 2074064 | 2022-01-02 | Will | Illinois | 17197 | 119193 | 1314 |
2070813 | 2070813 | 2022-01-01 | Will | Illinois | 17197 | 119193 | 1314 |
2067562 | 2067562 | 2021-12-31 | Will | Illinois | 17197 | 119193 | 1314 |
2064311 | 2064311 | 2021-12-30 | Will | Illinois | 17197 | 119193 | 1314 |
2061061 | 2061061 | 2021-12-29 | Will | Illinois | 17197 | 117417 | 1310 |
2057812 | 2057812 | 2021-12-28 | Will | Illinois | 17197 | 116239 | 1307 |
2054563 | 2054563 | 2021-12-27 | Will | Illinois | 17197 | 115045 | 1304 |
2051313 | 2051313 | 2021-12-26 | Will | Illinois | 17197 | 111679 | 1294 |
2048063 | 2048063 | 2021-12-25 | Will | Illinois | 17197 | 111679 | 1294 |
2044813 | 2044813 | 2021-12-24 | Will | Illinois | 17197 | 111679 | 1294 |
2041564 | 2041564 | 2021-12-23 | Will | Illinois | 17197 | 111679 | 1294 |
2038314 | 2038314 | 2021-12-22 | Will | Illinois | 17197 | 110581 | 1290 |
2035064 | 2035064 | 2021-12-21 | Will | Illinois | 17197 | 109613 | 1287 |
2031814 | 2031814 | 2021-12-20 | Will | Illinois | 17197 | 109073 | 1285 |
2028563 | 2028563 | 2021-12-19 | Will | Illinois | 17197 | 107302 | 1279 |
2025312 | 2025312 | 2021-12-18 | Will | Illinois | 17197 | 107302 | 1279 |
2022061 | 2022061 | 2021-12-17 | Will | Illinois | 17197 | 107302 | 1279 |
2018810 | 2018810 | 2021-12-16 | Will | Illinois | 17197 | 106605 | 1277 |
2015560 | 2015560 | 2021-12-15 | Will | Illinois | 17197 | 105964 | 1273 |
2012309 | 2012309 | 2021-12-14 | Will | Illinois | 17197 | 105392 | 1269 |
2009058 | 2009058 | 2021-12-13 | Will | Illinois | 17197 | 104986 | 1268 |
2005807 | 2005807 | 2021-12-12 | Will | Illinois | 17197 | 103822 | 1261 |
2002556 | 2002556 | 2021-12-11 | Will | Illinois | 17197 | 103822 | 1261 |
1999306 | 1999306 | 2021-12-10 | Will | Illinois | 17197 | 103822 | 1261 |
1996055 | 1996055 | 2021-12-09 | Will | Illinois | 17197 | 103368 | 1258 |
1992804 | 1992804 | 2021-12-08 | Will | Illinois | 17197 | 102835 | 1253 |
1989553 | 1989553 | 2021-12-07 | Will | Illinois | 17197 | 102436 | 1253 |
1986303 | 1986303 | 2021-12-06 | Will | Illinois | 17197 | 102094 | 1251 |
1983053 | 1983053 | 2021-12-05 | Will | Illinois | 17197 | 100945 | 1245 |
1979803 | 1979803 | 2021-12-04 | Will | Illinois | 17197 | 100945 | 1245 |
1976553 | 1976553 | 2021-12-03 | Will | Illinois | 17197 | 100945 | 1245 |
1973304 | 1973304 | 2021-12-02 | Will | Illinois | 17197 | 100477 | 1244 |
1970054 | 1970054 | 2021-12-01 | Will | Illinois | 17197 | 99777 | 1241 |
1966804 | 1966804 | 2021-11-30 | Will | Illinois | 17197 | 99357 | 1239 |
1963552 | 1963552 | 2021-11-29 | Will | Illinois | 17197 | 99005 | 1236 |
1960301 | 1960301 | 2021-11-28 | Will | Illinois | 17197 | 97785 | 1232 |
1957050 | 1957050 | 2021-11-27 | Will | Illinois | 17197 | 97785 | 1232 |
1953799 | 1953799 | 2021-11-26 | Will | Illinois | 17197 | 97785 | 1232 |
1950548 | 1950548 | 2021-11-25 | Will | Illinois | 17197 | 97785 | 1232 |
1947297 | 1947297 | 2021-11-24 | Will | Illinois | 17197 | 97785 | 1232 |
1944046 | 1944046 | 2021-11-23 | Will | Illinois | 17197 | 97449 | 1232 |
1940796 | 1940796 | 2021-11-22 | Will | Illinois | 17197 | 97213 | 1231 |
1937546 | 1937546 | 2021-11-21 | Will | Illinois | 17197 | 96506 | 1226 |
1934296 | 1934296 | 2021-11-20 | Will | Illinois | 17197 | 96506 | 1226 |
1931045 | 1931045 | 2021-11-19 | Will | Illinois | 17197 | 96506 | 1226 |
1927794 | 1927794 | 2021-11-18 | Will | Illinois | 17197 | 96255 | 1225 |
1924544 | 1924544 | 2021-11-17 | Will | Illinois | 17197 | 95873 | 1225 |
1921295 | 1921295 | 2021-11-16 | Will | Illinois | 17197 | 95510 | 1224 |
1918045 | 1918045 | 2021-11-15 | Will | Illinois | 17197 | 95309 | 1222 |
1914795 | 1914795 | 2021-11-14 | Will | Illinois | 17197 | 94765 | 1222 |
1911545 | 1911545 | 2021-11-13 | Will | Illinois | 17197 | 94765 | 1222 |
1908296 | 1908296 | 2021-11-12 | Will | Illinois | 17197 | 94765 | 1222 |
1905047 | 1905047 | 2021-11-11 | Will | Illinois | 17197 | 94280 | 1219 |
1901797 | 1901797 | 2021-11-10 | Will | Illinois | 17197 | 94280 | 1219 |
1898547 | 1898547 | 2021-11-09 | Will | Illinois | 17197 | 94000 | 1219 |
1895297 | 1895297 | 2021-11-08 | Will | Illinois | 17197 | 93883 | 1217 |
1892047 | 1892047 | 2021-11-07 | Will | Illinois | 17197 | 93458 | 1214 |
1888797 | 1888797 | 2021-11-06 | Will | Illinois | 17197 | 93458 | 1214 |
1885547 | 1885547 | 2021-11-05 | Will | Illinois | 17197 | 93458 | 1214 |
1882298 | 1882298 | 2021-11-04 | Will | Illinois | 17197 | 93284 | 1214 |
1879049 | 1879049 | 2021-11-03 | Will | Illinois | 17197 | 93023 | 1214 |
1875800 | 1875800 | 2021-11-02 | Will | Illinois | 17197 | 92932 | 1212 |
1872551 | 1872551 | 2021-11-01 | Will | Illinois | 17197 | 92761 | 1211 |
1869302 | 1869302 | 2021-10-31 | Will | Illinois | 17197 | 92350 | 1209 |
1866053 | 1866053 | 2021-10-30 | Will | Illinois | 17197 | 92350 | 1209 |
1862804 | 1862804 | 2021-10-29 | Will | Illinois | 17197 | 92350 | 1209 |
1859555 | 1859555 | 2021-10-28 | Will | Illinois | 17197 | 92207 | 1208 |
1856306 | 1856306 | 2021-10-27 | Will | Illinois | 17197 | 92076 | 1208 |
1853057 | 1853057 | 2021-10-26 | Will | Illinois | 17197 | 91970 | 1206 |
1849808 | 1849808 | 2021-10-25 | Will | Illinois | 17197 | 91850 | 1204 |
1846558 | 1846558 | 2021-10-24 | Will | Illinois | 17197 | 91568 | 1201 |
1843308 | 1843308 | 2021-10-23 | Will | Illinois | 17197 | 91568 | 1201 |
1840058 | 1840058 | 2021-10-22 | Will | Illinois | 17197 | 91568 | 1201 |
1836809 | 1836809 | 2021-10-21 | Will | Illinois | 17197 | 91395 | 1200 |
1833560 | 1833560 | 2021-10-20 | Will | Illinois | 17197 | 91262 | 1199 |
1830311 | 1830311 | 2021-10-19 | Will | Illinois | 17197 | 91145 | 1198 |
1827062 | 1827062 | 2021-10-18 | Will | Illinois | 17197 | 91028 | 1197 |
1823813 | 1823813 | 2021-10-17 | Will | Illinois | 17197 | 90698 | 1191 |
1820564 | 1820564 | 2021-10-16 | Will | Illinois | 17197 | 90698 | 1191 |
1817315 | 1817315 | 2021-10-15 | Will | Illinois | 17197 | 90698 | 1191 |
1814067 | 1814067 | 2021-10-14 | Will | Illinois | 17197 | 90560 | 1191 |
1810818 | 1810818 | 2021-10-13 | Will | Illinois | 17197 | 90407 | 1191 |
1807569 | 1807569 | 2021-10-12 | Will | Illinois | 17197 | 90216 | 1190 |
1804318 | 1804318 | 2021-10-11 | Will | Illinois | 17197 | 89720 | 1185 |
1801069 | 1801069 | 2021-10-10 | Will | Illinois | 17197 | 89720 | 1185 |
1797820 | 1797820 | 2021-10-09 | Will | Illinois | 17197 | 89720 | 1185 |
1794571 | 1794571 | 2021-10-08 | Will | Illinois | 17197 | 89720 | 1185 |
1791323 | 1791323 | 2021-10-07 | Will | Illinois | 17197 | 89583 | 1185 |
1788074 | 1788074 | 2021-10-06 | Will | Illinois | 17197 | 89392 | 1183 |
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);