ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 17099 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174845 | 2174845 | 2022-02-02 | LaSalle | Illinois | 17099 | 27644 | 416 |
2171592 | 2171592 | 2022-02-01 | LaSalle | Illinois | 17099 | 27507 | 415 |
2168339 | 2168339 | 2022-01-31 | LaSalle | Illinois | 17099 | 27376 | 414 |
2165084 | 2165084 | 2022-01-30 | LaSalle | Illinois | 17099 | 27109 | 410 |
2161829 | 2161829 | 2022-01-29 | LaSalle | Illinois | 17099 | 27109 | 410 |
2158574 | 2158574 | 2022-01-28 | LaSalle | Illinois | 17099 | 27109 | 410 |
2155320 | 2155320 | 2022-01-27 | LaSalle | Illinois | 17099 | 26917 | 409 |
2152067 | 2152067 | 2022-01-26 | LaSalle | Illinois | 17099 | 26693 | 406 |
2148815 | 2148815 | 2022-01-25 | LaSalle | Illinois | 17099 | 26516 | 406 |
2145563 | 2145563 | 2022-01-24 | LaSalle | Illinois | 17099 | 26316 | 404 |
2142308 | 2142308 | 2022-01-23 | LaSalle | Illinois | 17099 | 25857 | 403 |
2139053 | 2139053 | 2022-01-22 | LaSalle | Illinois | 17099 | 25857 | 403 |
2135797 | 2135797 | 2022-01-21 | LaSalle | Illinois | 17099 | 25857 | 403 |
2132545 | 2132545 | 2022-01-20 | LaSalle | Illinois | 17099 | 25469 | 398 |
2129292 | 2129292 | 2022-01-19 | LaSalle | Illinois | 17099 | 25227 | 396 |
2126038 | 2126038 | 2022-01-18 | LaSalle | Illinois | 17099 | 24935 | 395 |
2122786 | 2122786 | 2022-01-17 | LaSalle | Illinois | 17099 | 23961 | 393 |
2119534 | 2119534 | 2022-01-16 | LaSalle | Illinois | 17099 | 23961 | 393 |
2116282 | 2116282 | 2022-01-15 | LaSalle | Illinois | 17099 | 23961 | 393 |
2113031 | 2113031 | 2022-01-14 | LaSalle | Illinois | 17099 | 23961 | 393 |
2109779 | 2109779 | 2022-01-13 | LaSalle | Illinois | 17099 | 23569 | 390 |
2106528 | 2106528 | 2022-01-12 | LaSalle | Illinois | 17099 | 23234 | 388 |
2103277 | 2103277 | 2022-01-11 | LaSalle | Illinois | 17099 | 22772 | 387 |
2100026 | 2100026 | 2022-01-10 | LaSalle | Illinois | 17099 | 22172 | 386 |
2096775 | 2096775 | 2022-01-09 | LaSalle | Illinois | 17099 | 21263 | 386 |
2093523 | 2093523 | 2022-01-08 | LaSalle | Illinois | 17099 | 21263 | 386 |
2090271 | 2090271 | 2022-01-07 | LaSalle | Illinois | 17099 | 21263 | 386 |
2087020 | 2087020 | 2022-01-06 | LaSalle | Illinois | 17099 | 20680 | 386 |
2083768 | 2083768 | 2022-01-05 | LaSalle | Illinois | 17099 | 20374 | 380 |
2080516 | 2080516 | 2022-01-04 | LaSalle | Illinois | 17099 | 20054 | 380 |
2077264 | 2077264 | 2022-01-03 | LaSalle | Illinois | 17099 | 19713 | 378 |
2074013 | 2074013 | 2022-01-02 | LaSalle | Illinois | 17099 | 19108 | 376 |
2070762 | 2070762 | 2022-01-01 | LaSalle | Illinois | 17099 | 19108 | 376 |
2067511 | 2067511 | 2021-12-31 | LaSalle | Illinois | 17099 | 19108 | 376 |
2064260 | 2064260 | 2021-12-30 | LaSalle | Illinois | 17099 | 19108 | 376 |
2061010 | 2061010 | 2021-12-29 | LaSalle | Illinois | 17099 | 18857 | 370 |
2057761 | 2057761 | 2021-12-28 | LaSalle | Illinois | 17099 | 18687 | 369 |
2054512 | 2054512 | 2021-12-27 | LaSalle | Illinois | 17099 | 18523 | 369 |
2051262 | 2051262 | 2021-12-26 | LaSalle | Illinois | 17099 | 18215 | 363 |
2048012 | 2048012 | 2021-12-25 | LaSalle | Illinois | 17099 | 18215 | 363 |
2044762 | 2044762 | 2021-12-24 | LaSalle | Illinois | 17099 | 18215 | 363 |
2041513 | 2041513 | 2021-12-23 | LaSalle | Illinois | 17099 | 18215 | 363 |
2038263 | 2038263 | 2021-12-22 | LaSalle | Illinois | 17099 | 18099 | 360 |
2035013 | 2035013 | 2021-12-21 | LaSalle | Illinois | 17099 | 18001 | 358 |
2031763 | 2031763 | 2021-12-20 | LaSalle | Illinois | 17099 | 17916 | 358 |
2028512 | 2028512 | 2021-12-19 | LaSalle | Illinois | 17099 | 17673 | 354 |
2025261 | 2025261 | 2021-12-18 | LaSalle | Illinois | 17099 | 17673 | 354 |
2022010 | 2022010 | 2021-12-17 | LaSalle | Illinois | 17099 | 17673 | 354 |
2018759 | 2018759 | 2021-12-16 | LaSalle | Illinois | 17099 | 17553 | 353 |
2015509 | 2015509 | 2021-12-15 | LaSalle | Illinois | 17099 | 17462 | 352 |
2012258 | 2012258 | 2021-12-14 | LaSalle | Illinois | 17099 | 17346 | 351 |
2009007 | 2009007 | 2021-12-13 | LaSalle | Illinois | 17099 | 17248 | 351 |
2005756 | 2005756 | 2021-12-12 | LaSalle | Illinois | 17099 | 17055 | 351 |
2002505 | 2002505 | 2021-12-11 | LaSalle | Illinois | 17099 | 17055 | 351 |
1999255 | 1999255 | 2021-12-10 | LaSalle | Illinois | 17099 | 17055 | 351 |
1996004 | 1996004 | 2021-12-09 | LaSalle | Illinois | 17099 | 16945 | 351 |
1992753 | 1992753 | 2021-12-08 | LaSalle | Illinois | 17099 | 16859 | 351 |
1989502 | 1989502 | 2021-12-07 | LaSalle | Illinois | 17099 | 16742 | 351 |
1986252 | 1986252 | 2021-12-06 | LaSalle | Illinois | 17099 | 16639 | 351 |
1983002 | 1983002 | 2021-12-05 | LaSalle | Illinois | 17099 | 16385 | 351 |
1979752 | 1979752 | 2021-12-04 | LaSalle | Illinois | 17099 | 16385 | 351 |
1976502 | 1976502 | 2021-12-03 | LaSalle | Illinois | 17099 | 16385 | 351 |
1973253 | 1973253 | 2021-12-02 | LaSalle | Illinois | 17099 | 16311 | 351 |
1970003 | 1970003 | 2021-12-01 | LaSalle | Illinois | 17099 | 16155 | 351 |
1966753 | 1966753 | 2021-11-30 | LaSalle | Illinois | 17099 | 16093 | 349 |
1963501 | 1963501 | 2021-11-29 | LaSalle | Illinois | 17099 | 16028 | 349 |
1960250 | 1960250 | 2021-11-28 | LaSalle | Illinois | 17099 | 15884 | 349 |
1956999 | 1956999 | 2021-11-27 | LaSalle | Illinois | 17099 | 15884 | 349 |
1953748 | 1953748 | 2021-11-26 | LaSalle | Illinois | 17099 | 15884 | 349 |
1950497 | 1950497 | 2021-11-25 | LaSalle | Illinois | 17099 | 15884 | 349 |
1947246 | 1947246 | 2021-11-24 | LaSalle | Illinois | 17099 | 15884 | 349 |
1943995 | 1943995 | 2021-11-23 | LaSalle | Illinois | 17099 | 15836 | 348 |
1940745 | 1940745 | 2021-11-22 | LaSalle | Illinois | 17099 | 15809 | 348 |
1937495 | 1937495 | 2021-11-21 | LaSalle | Illinois | 17099 | 15724 | 347 |
1934245 | 1934245 | 2021-11-20 | LaSalle | Illinois | 17099 | 15724 | 347 |
1930994 | 1930994 | 2021-11-19 | LaSalle | Illinois | 17099 | 15724 | 347 |
1927743 | 1927743 | 2021-11-18 | LaSalle | Illinois | 17099 | 15668 | 346 |
1924493 | 1924493 | 2021-11-17 | LaSalle | Illinois | 17099 | 15625 | 346 |
1921244 | 1921244 | 2021-11-16 | LaSalle | Illinois | 17099 | 15585 | 346 |
1917994 | 1917994 | 2021-11-15 | LaSalle | Illinois | 17099 | 15566 | 346 |
1914744 | 1914744 | 2021-11-14 | LaSalle | Illinois | 17099 | 15488 | 346 |
1911494 | 1911494 | 2021-11-13 | LaSalle | Illinois | 17099 | 15488 | 346 |
1908245 | 1908245 | 2021-11-12 | LaSalle | Illinois | 17099 | 15488 | 346 |
1904996 | 1904996 | 2021-11-11 | LaSalle | Illinois | 17099 | 15404 | 346 |
1901746 | 1901746 | 2021-11-10 | LaSalle | Illinois | 17099 | 15404 | 346 |
1898496 | 1898496 | 2021-11-09 | LaSalle | Illinois | 17099 | 15370 | 345 |
1895246 | 1895246 | 2021-11-08 | LaSalle | Illinois | 17099 | 15348 | 345 |
1891996 | 1891996 | 2021-11-07 | LaSalle | Illinois | 17099 | 15300 | 345 |
1888746 | 1888746 | 2021-11-06 | LaSalle | Illinois | 17099 | 15300 | 345 |
1885496 | 1885496 | 2021-11-05 | LaSalle | Illinois | 17099 | 15300 | 345 |
1882247 | 1882247 | 2021-11-04 | LaSalle | Illinois | 17099 | 15289 | 345 |
1878998 | 1878998 | 2021-11-03 | LaSalle | Illinois | 17099 | 15258 | 345 |
1875749 | 1875749 | 2021-11-02 | LaSalle | Illinois | 17099 | 15251 | 345 |
1872500 | 1872500 | 2021-11-01 | LaSalle | Illinois | 17099 | 15220 | 345 |
1869251 | 1869251 | 2021-10-31 | LaSalle | Illinois | 17099 | 15173 | 344 |
1866002 | 1866002 | 2021-10-30 | LaSalle | Illinois | 17099 | 15173 | 344 |
1862753 | 1862753 | 2021-10-29 | LaSalle | Illinois | 17099 | 15173 | 344 |
1859504 | 1859504 | 2021-10-28 | LaSalle | Illinois | 17099 | 15159 | 343 |
1856255 | 1856255 | 2021-10-27 | LaSalle | Illinois | 17099 | 15144 | 343 |
1853006 | 1853006 | 2021-10-26 | LaSalle | Illinois | 17099 | 15119 | 342 |
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);