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 |
---|---|---|---|---|---|---|---|
2174898 | 2174898 | 2022-02-02 | Winnebago | Illinois | 17201 | 73421 | 789 |
2171645 | 2171645 | 2022-02-01 | Winnebago | Illinois | 17201 | 73194 | 783 |
2168392 | 2168392 | 2022-01-31 | Winnebago | Illinois | 17201 | 72999 | 780 |
2165137 | 2165137 | 2022-01-30 | Winnebago | Illinois | 17201 | 72370 | 774 |
2161882 | 2161882 | 2022-01-29 | Winnebago | Illinois | 17201 | 72370 | 774 |
2158627 | 2158627 | 2022-01-28 | Winnebago | Illinois | 17201 | 72370 | 774 |
2155373 | 2155373 | 2022-01-27 | Winnebago | Illinois | 17201 | 71897 | 773 |
2152120 | 2152120 | 2022-01-26 | Winnebago | Illinois | 17201 | 71581 | 770 |
2148868 | 2148868 | 2022-01-25 | Winnebago | Illinois | 17201 | 71089 | 768 |
2145616 | 2145616 | 2022-01-24 | Winnebago | Illinois | 17201 | 70774 | 763 |
2142361 | 2142361 | 2022-01-23 | Winnebago | Illinois | 17201 | 69472 | 754 |
2139106 | 2139106 | 2022-01-22 | Winnebago | Illinois | 17201 | 69472 | 754 |
2135850 | 2135850 | 2022-01-21 | Winnebago | Illinois | 17201 | 69472 | 754 |
2132598 | 2132598 | 2022-01-20 | Winnebago | Illinois | 17201 | 68314 | 749 |
2129345 | 2129345 | 2022-01-19 | Winnebago | Illinois | 17201 | 67751 | 742 |
2126091 | 2126091 | 2022-01-18 | Winnebago | Illinois | 17201 | 67114 | 741 |
2122839 | 2122839 | 2022-01-17 | Winnebago | Illinois | 17201 | 64043 | 734 |
2119587 | 2119587 | 2022-01-16 | Winnebago | Illinois | 17201 | 64043 | 734 |
2116335 | 2116335 | 2022-01-15 | Winnebago | Illinois | 17201 | 64043 | 734 |
2113084 | 2113084 | 2022-01-14 | Winnebago | Illinois | 17201 | 64043 | 734 |
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 |
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);