ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 17201 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109832 | 2109832 | 2022-01-13 | Winnebago | Illinois | 17201 | 63391 | 727 |
2106581 | 2106581 | 2022-01-12 | Winnebago | Illinois | 17201 | 62521 | 723 |
2103330 | 2103330 | 2022-01-11 | Winnebago | Illinois | 17201 | 61458 | 718 |
2100079 | 2100079 | 2022-01-10 | Winnebago | Illinois | 17201 | 60751 | 716 |
2096828 | 2096828 | 2022-01-09 | Winnebago | Illinois | 17201 | 59076 | 709 |
2093576 | 2093576 | 2022-01-08 | Winnebago | Illinois | 17201 | 59076 | 709 |
2090324 | 2090324 | 2022-01-07 | Winnebago | Illinois | 17201 | 59076 | 709 |
2087073 | 2087073 | 2022-01-06 | Winnebago | Illinois | 17201 | 57705 | 705 |
2083821 | 2083821 | 2022-01-05 | Winnebago | Illinois | 17201 | 56871 | 702 |
2080569 | 2080569 | 2022-01-04 | Winnebago | Illinois | 17201 | 56056 | 701 |
2077317 | 2077317 | 2022-01-03 | Winnebago | Illinois | 17201 | 55393 | 701 |
2074066 | 2074066 | 2022-01-02 | Winnebago | Illinois | 17201 | 53922 | 692 |
2070815 | 2070815 | 2022-01-01 | Winnebago | Illinois | 17201 | 53922 | 692 |
2067564 | 2067564 | 2021-12-31 | Winnebago | Illinois | 17201 | 53922 | 692 |
2064313 | 2064313 | 2021-12-30 | Winnebago | Illinois | 17201 | 53922 | 692 |
2061063 | 2061063 | 2021-12-29 | Winnebago | Illinois | 17201 | 53417 | 686 |
2057814 | 2057814 | 2021-12-28 | Winnebago | Illinois | 17201 | 53238 | 685 |
2054565 | 2054565 | 2021-12-27 | Winnebago | Illinois | 17201 | 53019 | 681 |
2051315 | 2051315 | 2021-12-26 | Winnebago | Illinois | 17201 | 52365 | 669 |
2048065 | 2048065 | 2021-12-25 | Winnebago | Illinois | 17201 | 52365 | 669 |
2044815 | 2044815 | 2021-12-24 | Winnebago | Illinois | 17201 | 52365 | 669 |
2041566 | 2041566 | 2021-12-23 | Winnebago | Illinois | 17201 | 52365 | 669 |
2038316 | 2038316 | 2021-12-22 | Winnebago | Illinois | 17201 | 52113 | 666 |
2035066 | 2035066 | 2021-12-21 | Winnebago | Illinois | 17201 | 51901 | 660 |
2031816 | 2031816 | 2021-12-20 | Winnebago | Illinois | 17201 | 51735 | 658 |
2028565 | 2028565 | 2021-12-19 | Winnebago | Illinois | 17201 | 51192 | 653 |
2025314 | 2025314 | 2021-12-18 | Winnebago | Illinois | 17201 | 51192 | 653 |
2022063 | 2022063 | 2021-12-17 | Winnebago | Illinois | 17201 | 51192 | 653 |
2018812 | 2018812 | 2021-12-16 | Winnebago | Illinois | 17201 | 50938 | 651 |
2015562 | 2015562 | 2021-12-15 | Winnebago | Illinois | 17201 | 50656 | 650 |
2012311 | 2012311 | 2021-12-14 | Winnebago | Illinois | 17201 | 50412 | 646 |
2009060 | 2009060 | 2021-12-13 | Winnebago | Illinois | 17201 | 50239 | 646 |
2005809 | 2005809 | 2021-12-12 | Winnebago | Illinois | 17201 | 49661 | 639 |
2002558 | 2002558 | 2021-12-11 | Winnebago | Illinois | 17201 | 49661 | 639 |
1999308 | 1999308 | 2021-12-10 | Winnebago | Illinois | 17201 | 49661 | 639 |
1996057 | 1996057 | 2021-12-09 | Winnebago | Illinois | 17201 | 49364 | 635 |
1992806 | 1992806 | 2021-12-08 | Winnebago | Illinois | 17201 | 49077 | 633 |
1989555 | 1989555 | 2021-12-07 | Winnebago | Illinois | 17201 | 48833 | 632 |
1986305 | 1986305 | 2021-12-06 | Winnebago | Illinois | 17201 | 48608 | 627 |
1983055 | 1983055 | 2021-12-05 | Winnebago | Illinois | 17201 | 47927 | 622 |
1979805 | 1979805 | 2021-12-04 | Winnebago | Illinois | 17201 | 47927 | 622 |
1976555 | 1976555 | 2021-12-03 | Winnebago | Illinois | 17201 | 47927 | 622 |
1973306 | 1973306 | 2021-12-02 | Winnebago | Illinois | 17201 | 47712 | 620 |
1970056 | 1970056 | 2021-12-01 | Winnebago | Illinois | 17201 | 47279 | 616 |
1966806 | 1966806 | 2021-11-30 | Winnebago | Illinois | 17201 | 47028 | 614 |
1963554 | 1963554 | 2021-11-29 | Winnebago | Illinois | 17201 | 46854 | 614 |
1960303 | 1960303 | 2021-11-28 | Winnebago | Illinois | 17201 | 46109 | 612 |
1957052 | 1957052 | 2021-11-27 | Winnebago | Illinois | 17201 | 46109 | 612 |
1953801 | 1953801 | 2021-11-26 | Winnebago | Illinois | 17201 | 46109 | 612 |
1950550 | 1950550 | 2021-11-25 | Winnebago | Illinois | 17201 | 46109 | 612 |
1947299 | 1947299 | 2021-11-24 | Winnebago | Illinois | 17201 | 46109 | 612 |
1944048 | 1944048 | 2021-11-23 | Winnebago | Illinois | 17201 | 45891 | 611 |
1940798 | 1940798 | 2021-11-22 | Winnebago | Illinois | 17201 | 45721 | 611 |
1937548 | 1937548 | 2021-11-21 | Winnebago | Illinois | 17201 | 45161 | 609 |
1934298 | 1934298 | 2021-11-20 | Winnebago | Illinois | 17201 | 45161 | 609 |
1931047 | 1931047 | 2021-11-19 | Winnebago | Illinois | 17201 | 45161 | 609 |
1927796 | 1927796 | 2021-11-18 | Winnebago | Illinois | 17201 | 44895 | 609 |
1924546 | 1924546 | 2021-11-17 | Winnebago | Illinois | 17201 | 44553 | 607 |
1921297 | 1921297 | 2021-11-16 | Winnebago | Illinois | 17201 | 44345 | 606 |
1918047 | 1918047 | 2021-11-15 | Winnebago | Illinois | 17201 | 44224 | 605 |
1914797 | 1914797 | 2021-11-14 | Winnebago | Illinois | 17201 | 43743 | 603 |
1911547 | 1911547 | 2021-11-13 | Winnebago | Illinois | 17201 | 43743 | 603 |
1908298 | 1908298 | 2021-11-12 | Winnebago | Illinois | 17201 | 43743 | 603 |
1905049 | 1905049 | 2021-11-11 | Winnebago | Illinois | 17201 | 43366 | 599 |
1901799 | 1901799 | 2021-11-10 | Winnebago | Illinois | 17201 | 43366 | 599 |
1898549 | 1898549 | 2021-11-09 | Winnebago | Illinois | 17201 | 43120 | 598 |
1895299 | 1895299 | 2021-11-08 | Winnebago | Illinois | 17201 | 43056 | 597 |
1892049 | 1892049 | 2021-11-07 | Winnebago | Illinois | 17201 | 42604 | 596 |
1888799 | 1888799 | 2021-11-06 | Winnebago | Illinois | 17201 | 42604 | 596 |
1885549 | 1885549 | 2021-11-05 | Winnebago | Illinois | 17201 | 42604 | 596 |
1882300 | 1882300 | 2021-11-04 | Winnebago | Illinois | 17201 | 42488 | 595 |
1879051 | 1879051 | 2021-11-03 | Winnebago | Illinois | 17201 | 42276 | 593 |
1875802 | 1875802 | 2021-11-02 | Winnebago | Illinois | 17201 | 42199 | 593 |
1872553 | 1872553 | 2021-11-01 | Winnebago | Illinois | 17201 | 42113 | 593 |
1869304 | 1869304 | 2021-10-31 | Winnebago | Illinois | 17201 | 41830 | 592 |
1866055 | 1866055 | 2021-10-30 | Winnebago | Illinois | 17201 | 41830 | 592 |
1862806 | 1862806 | 2021-10-29 | Winnebago | Illinois | 17201 | 41830 | 592 |
1859557 | 1859557 | 2021-10-28 | Winnebago | Illinois | 17201 | 41701 | 592 |
1856308 | 1856308 | 2021-10-27 | Winnebago | Illinois | 17201 | 41587 | 591 |
1853059 | 1853059 | 2021-10-26 | Winnebago | Illinois | 17201 | 41507 | 591 |
1849810 | 1849810 | 2021-10-25 | Winnebago | Illinois | 17201 | 41428 | 591 |
1846560 | 1846560 | 2021-10-24 | Winnebago | Illinois | 17201 | 41222 | 591 |
1843310 | 1843310 | 2021-10-23 | Winnebago | Illinois | 17201 | 41222 | 591 |
1840060 | 1840060 | 2021-10-22 | Winnebago | Illinois | 17201 | 41222 | 591 |
1836811 | 1836811 | 2021-10-21 | Winnebago | Illinois | 17201 | 41117 | 591 |
1833562 | 1833562 | 2021-10-20 | Winnebago | Illinois | 17201 | 41041 | 590 |
1830313 | 1830313 | 2021-10-19 | Winnebago | Illinois | 17201 | 40972 | 589 |
1827064 | 1827064 | 2021-10-18 | Winnebago | Illinois | 17201 | 40918 | 589 |
1823815 | 1823815 | 2021-10-17 | Winnebago | Illinois | 17201 | 40745 | 589 |
1820566 | 1820566 | 2021-10-16 | Winnebago | Illinois | 17201 | 40745 | 589 |
1817317 | 1817317 | 2021-10-15 | Winnebago | Illinois | 17201 | 40745 | 589 |
1814069 | 1814069 | 2021-10-14 | Winnebago | Illinois | 17201 | 40662 | 588 |
1810820 | 1810820 | 2021-10-13 | Winnebago | Illinois | 17201 | 40592 | 587 |
1807571 | 1807571 | 2021-10-12 | Winnebago | Illinois | 17201 | 40513 | 587 |
1804320 | 1804320 | 2021-10-11 | Winnebago | Illinois | 17201 | 40272 | 583 |
1801071 | 1801071 | 2021-10-10 | Winnebago | Illinois | 17201 | 40272 | 583 |
1797822 | 1797822 | 2021-10-09 | Winnebago | Illinois | 17201 | 40272 | 583 |
1794573 | 1794573 | 2021-10-08 | Winnebago | Illinois | 17201 | 40272 | 583 |
1791325 | 1791325 | 2021-10-07 | Winnebago | Illinois | 17201 | 40181 | 583 |
1788076 | 1788076 | 2021-10-06 | Winnebago | Illinois | 17201 | 40096 | 582 |
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);